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

(-)a/installer/data/mysql/sysprefs.sql (-3 / +3 lines)
Lines 97-105 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
97
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
97
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
98
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
98
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
99
('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'),
99
('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'),
100
('defaultLongOverdueChargeValue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
100
('DefaultLongOverdueChargeValue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'),
101
('defaultLongOverdueDays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
101
('DefaultLongOverdueDays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'),
102
('defaultLongOverdueLostValue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
102
('DefaultLongOverdueLostValue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'),
103
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
103
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
104
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
104
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
105
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
105
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
(-)a/installer/data/mysql/updatedatabase.pl (-8 / +6 lines)
Lines 9439-9445 if ( CheckVersion($DBversion) ) { Link Here
9439
}
9439
}
9440
9440
9441
$DBversion = "3.17.00.053";
9441
$DBversion = "3.17.00.053";
9442
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
9442
if ( CheckVersion($DBversion) ) {
9443
    $dbh->do(q{
9443
    $dbh->do(q{
9444
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)');
9444
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)');
9445
    });
9445
    });
Lines 9481-9487 if (CheckVersion($DBversion)) { Link Here
9481
}
9481
}
9482
9482
9483
$DBversion = "3.17.00.055";
9483
$DBversion = "3.17.00.055";
9484
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
9484
if ( CheckVersion($DBversion) ) {
9485
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBEnable', '0', NULL, 'Enable communication with the Norwegian national patron database.', 'YesNo')");
9485
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBEnable', '0', NULL, 'Enable communication with the Norwegian national patron database.', 'YesNo')");
9486
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBEndpoint', '', NULL, 'Which NL endpoint to use.', 'Free')");
9486
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBEndpoint', '', NULL, 'Which NL endpoint to use.', 'Free')");
9487
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBUsername', '', NULL, 'Username for communication with the Norwegian national patron database.', 'Free')");
9487
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('NorwegianPatronDBUsername', '', NULL, 'Username for communication with the Norwegian national patron database.', 'Free')");
Lines 9506-9512 CREATE TABLE borrower_sync ( Link Here
9506
}
9506
}
9507
9507
9508
$DBversion = "3.17.00.056";
9508
$DBversion = "3.17.00.056";
9509
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
9509
if ( CheckVersion($DBversion) ) {
9510
    $dbh->do(q{
9510
    $dbh->do(q{
9511
        UPDATE systempreferences SET value = 'pubdate,itemtype,language,sorting,location' WHERE variable='OpacAdvSearchOptions'
9511
        UPDATE systempreferences SET value = 'pubdate,itemtype,language,sorting,location' WHERE variable='OpacAdvSearchOptions'
9512
    });
9512
    });
Lines 9527-9535 if ( CheckVersion($DBversion) ) { Link Here
9527
9527
9528
$DBversion = "3.17.00.XXX";
9528
$DBversion = "3.17.00.XXX";
9529
if( CheckVersion($DBversion) ){
9529
if( CheckVersion($DBversion) ){
9530
    $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')");
9530
    $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')");
9531
    $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')");
9531
    $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')");
9532
    $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')");
9532
    $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')");
9533
    print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";
9533
    print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";
9534
    SetVersion($DBversion);
9534
    SetVersion($DBversion);
9535
}
9535
}
Lines 9537-9543 if( CheckVersion($DBversion) ){ Link Here
9537
=head1 FUNCTIONS
9537
=head1 FUNCTIONS
9538
9538
9539
=head2 TableExists($table)
9539
=head2 TableExists($table)
9540
a
9541
9540
9542
=cut
9541
=cut
9543
9542
9544
- 

Return to bug 8337