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

(-)a/installer/data/mysql/sysprefs.sql (-5 / +5 lines)
Lines 95-100 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
95
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
95
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
96
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
96
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
97
('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'),
97
('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'),
98
('defaultLongOverdueChargeValue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
99
('defaultLongOverdueDays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
100
('defaultLongOverdueLostValue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
98
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
101
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
99
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
102
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
100
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
103
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
Lines 109-116 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
109
('EasyAnalyticalRecords','0','','If on, display in the catalogue screens tools to easily setup analytical record relationships','YesNo'),
112
('EasyAnalyticalRecords','0','','If on, display in the catalogue screens tools to easily setup analytical record relationships','YesNo'),
110
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
113
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
111
('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
114
('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
112
('EnableSearchHistory','0','','Enable or disable search history','YesNo'),
113
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
115
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
116
('EnableSearchHistory','0','','Enable or disable search history','YesNo'),
114
('EnhancedMessagingPreferences','0','','If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
117
('EnhancedMessagingPreferences','0','','If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
115
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
118
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
116
('ExpireReservesMaxPickUpDelay','0','','Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay','YesNo'),
119
('ExpireReservesMaxPickUpDelay','0','','Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay','YesNo'),
Lines 442-449 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
442
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
445
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
443
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
446
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
444
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
447
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
445
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
448
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
446
('defaultlongoverduechargevalue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer');
447
('defaultlongoverduedays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer');
448
('defaultlongoverduelostvalue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer');
449
;
449
;
(-)a/installer/data/mysql/updatedatabase.pl (-6 / +5 lines)
Lines 8615-8630 if ( CheckVersion($DBversion) ) { Link Here
8615
8615
8616
$DBversion = "XXX";
8616
$DBversion = "XXX";
8617
if( CheckVersion($DBversion) ){
8617
if( CheckVersion($DBversion) ){
8618
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduechargevalue','Charge a lost item to the borrower account when the LOST value of the item changes to n',  'integer')");
8618
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultLongOverdueChargeValue','Charge a lost item to the borrower account when the LOST value of the item changes to n',  'integer')");
8619
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduelostvalue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')");
8619
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultLongOverdueLostValue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultLongOverdueDays days.', 'integer')");
8620
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduedays', 'Set the LOST value of an item when the item has been overdue for more than n days.',  'integer')");
8620
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultLongOverdueDays', 'Set the LOST value of an item when the item has been overdue for more than n days.',  'integer')");
8621
    print "Upgrade to $DBversion done (System preferences for longoverdue cron)\n";
8621
    print "Upgrade to $DBversion done (Bug 8337 - System preferences for longoverdue cron)\n";
8622
    SetVersion($DBversion);
8622
    SetVersion($DBversion);
8623
}
8623
}
8624
8624
=head1 FUNCTIONS
8625
=head1 FUNCTIONS
8625
8626
8626
=head2 TableExists($table)
8627
=head2 TableExists($table)
8627
a
8628
8628
8629
=cut
8629
=cut
8630
8630
8631
- 

Return to bug 8337