View | Details | Raw Unified | Return to bug 16070
Collapse All | Expand All

(-)a/installer/data/mysql/sysprefs.sql (-13 / +12 lines)
Lines 95-102 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
95
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
95
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
96
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
96
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
97
('Coce','0', NULL, 'If on, enables cover retrieval from the configured Coce server', 'YesNo'),
97
('Coce','0', NULL, 'If on, enables cover retrieval from the configured Coce server', 'YesNo'),
98
('CoceHost', NULL, NULL, 'Coce server URL', 'Free'),
98
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
99
('CoceProviders', NULL, 'aws,gb,ol', 'Coce providers', 'multiple'),
99
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
100
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
100
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
101
('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'),
101
('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'),
102
('ConsiderOnSiteCheckoutsAsNormalCheckouts','1',NULL,'Consider on-site checkouts as normal checkouts','YesNo'),
102
('ConsiderOnSiteCheckoutsAsNormalCheckouts','1',NULL,'Consider on-site checkouts as normal checkouts','YesNo'),
Lines 111-119 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
111
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
111
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
112
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
112
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
113
('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'),
113
('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'),
114
('DefaultLongOverdueChargeValue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
114
('DefaultLongOverdueChargeValue', '', NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
115
('DefaultLongOverdueDays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
115
('DefaultLongOverdueDays', '', NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
116
('DefaultLongOverdueLostValue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
116
('DefaultLongOverdueLostValue', '', NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
117
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
117
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
118
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
118
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
119
('DefaultToLoggedInLibraryCircRules',  '0', NULL ,  'If enabled, circ rules editor will default to the logged in library''s rules, rather than the ''all libraries'' rules.',  'YesNo'),
119
('DefaultToLoggedInLibraryCircRules',  '0', NULL ,  'If enabled, circ rules editor will default to the logged in library''s rules, rather than the ''all libraries'' rules.',  'YesNo'),
Lines 180-186 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
180
('OnSiteCheckouts','0','','Enable/Disable the on-site checkouts feature','YesNo'),
180
('OnSiteCheckouts','0','','Enable/Disable the on-site checkouts feature','YesNo'),
181
('OnSiteCheckoutsForce','0','','Enable/Disable the on-site for all cases (Even if a user is debarred, etc.)','YesNo'),
181
('OnSiteCheckoutsForce','0','','Enable/Disable the on-site for all cases (Even if a user is debarred, etc.)','YesNo'),
182
('InProcessingToShelvingCart','0','','If set, when any item with a location code of PROC is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
182
('InProcessingToShelvingCart','0','','If set, when any item with a location code of PROC is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
183
('INTRAdidyoumean',NULL,NULL,'Did you mean? configuration for the Intranet. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
183
('INTRAdidyoumean','',NULL,'Did you mean? configuration for the Intranet. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
184
('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'),
184
('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'),
185
('intranetbookbag','1','','If ON, enables display of Cart feature in the intranet','YesNo'),
185
('intranetbookbag','1','','If ON, enables display of Cart feature in the intranet','YesNo'),
186
('intranetcolorstylesheet','','50','Define the color stylesheet to use in the Staff Client','free'),
186
('intranetcolorstylesheet','','50','Define the color stylesheet to use in the Staff Client','free'),
Lines 229-235 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
229
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
229
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
230
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
230
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
231
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
231
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
232
('MembershipExpiryDaysNotice',NULL,'Send an account expiration notice that a patron\'s card is about to expire after',NULL,'Integer'),
232
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
233
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
233
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
234
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
234
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
235
('NewItemsDefaultLocation','','','If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
235
('NewItemsDefaultLocation','','','If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
Lines 247-254 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
247
('NoticeCSS','',NULL,'Notices CSS url.','free'),
247
('NoticeCSS','',NULL,'Notices CSS url.','free'),
248
('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'),
248
('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'),
249
('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content.  Requires Novelist Profile and Password','YesNo'),
249
('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content.  Requires Novelist Profile and Password','YesNo'),
250
('NovelistSelectPassword',NULL,NULL,'Enable Novelist user Profile','free'),
250
('NovelistSelectPassword','',NULL,'Enable Novelist user Profile','free'),
251
('NovelistSelectProfile',NULL,NULL,'Novelist Select user Password','free'),
251
('NovelistSelectProfile','',NULL,'Novelist Select user Password','free'),
252
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
252
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
253
('numReturnedItemsToShow','20',NULL,'Number of returned items to show on the check-in page','Integer'),
253
('numReturnedItemsToShow','20',NULL,'Number of returned items to show on the check-in page','Integer'),
254
('numSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
254
('numSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
Lines 270-276 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
270
('OPACAllowUserToChooseBranch','1','1','Allow the user to choose the branch they want to pickup their hold from','YesNo'),
270
('OPACAllowUserToChooseBranch','1','1','Allow the user to choose the branch they want to pickup their hold from','YesNo'),
271
('OPACAmazonCoverImages','0','','Display cover images on OPAC from Amazon Web Services','YesNo'),
271
('OPACAmazonCoverImages','0','','Display cover images on OPAC from Amazon Web Services','YesNo'),
272
('OpacAuthorities','1',NULL,'If ON, enables the search authorities link on OPAC','YesNo'),
272
('OpacAuthorities','1',NULL,'If ON, enables the search authorities link on OPAC','YesNo'),
273
('OPACBaseURL',NULL,NULL,'Specify the Base URL of the OPAC, e.g., http://opac.mylibrary.com, including the protocol (http:// or https://). Otherwise, the http:// will be added automatically by Koha upon saving.','Free'),
273
('OPACBaseURL','',NULL,'Specify the Base URL of the OPAC, e.g., http://opac.mylibrary.com, including the protocol (http:// or https://). Otherwise, the http:// will be added automatically by Koha upon saving.','Free'),
274
('opacbookbag','1','','If ON, enables display of Cart feature','YesNo'),
274
('opacbookbag','1','','If ON, enables display of Cart feature','YesNo'),
275
('OpacBrowser','0',NULL,'If ON, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)','YesNo'),
275
('OpacBrowser','0',NULL,'If ON, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)','YesNo'),
276
('OpacBrowseResults','1',NULL,'Disable/enable browsing and paging search results from the OPAC detail page.','YesNo'),
276
('OpacBrowseResults','1',NULL,'Disable/enable browsing and paging search results from the OPAC detail page.','YesNo'),
Lines 280-286 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
280
('opaccredits','','70|10','Define HTML Credits at the bottom of the OPAC page','Textarea'),
280
('opaccredits','','70|10','Define HTML Credits at the bottom of the OPAC page','Textarea'),
281
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
281
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
282
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
282
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
283
('OPACdidyoumean',NULL,NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
283
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
284
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
284
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
285
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
285
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
286
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
286
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
Lines 470-476 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
470
('SyndeticsSummary','0','','Display Summary Information from Syndetics','YesNo'),
470
('SyndeticsSummary','0','','Display Summary Information from Syndetics','YesNo'),
471
('SyndeticsTOC','0','','Display Table of Content information from Syndetics','YesNo'),
471
('SyndeticsTOC','0','','Display Table of Content information from Syndetics','YesNo'),
472
('TagsEnabled','1','','Enables or disables all tagging features.  This is the main switch for tags.','YesNo'),
472
('TagsEnabled','1','','Enables or disables all tagging features.  This is the main switch for tags.','YesNo'),
473
('TagsExternalDictionary',NULL,'','Path on server to local ispell executable, used to set $Lingua::Ispell::path  This dictionary is used as a \"whitelist\" of pre-allowed tags.',''),
473
('TagsExternalDictionary','','','Path on server to local ispell executable, used to set $Lingua::Ispell::path  This dictionary is used as a \"whitelist\" of pre-allowed tags.',''),
474
('TagsInputOnDetail','1','','Allow users to input tags from the detail page.','YesNo'),
474
('TagsInputOnDetail','1','','Allow users to input tags from the detail page.','YesNo'),
475
('TagsInputOnList','0','','Allow users to input tags from the search results list.','YesNo'),
475
('TagsInputOnList','0','','Allow users to input tags from the search results list.','YesNo'),
476
('TagsModeration','0','','Require tags from patrons to be approved before becoming visible.','YesNo'),
476
('TagsModeration','0','','Require tags from patrons to be approved before becoming visible.','YesNo'),
477
- 

Return to bug 16070