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

(-)a/installer/data/mysql/atomicupdate/bug_22044_set_default_value_for_NoRenewalBeforePrecision.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( q{
4
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
5
        VALUES ('NoRenewalBeforePrecision', 'exact_time', 'Calculate "No renewal before" based on date or exact time. Only relevant for loans calculated in days, hourly loans are not affected.', 'date|exact_time', 'Choice');
6
    });
7
    $dbh->do("UPDATE systempreferences SET value='exact_time' WHERE variable='NoRenewalBeforePrecision' AND value IS NULL;" );
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 22044 - Set a default value for NoRenewalBeforePrecision)\n";
10
}
(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 310-315 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
310
('noissuescharge','5','','Define maximum amount withstanding before check outs are blocked','Integer'),
310
('noissuescharge','5','','Define maximum amount withstanding before check outs are blocked','Integer'),
311
('NoIssuesChargeGuarantees','','','Define maximum amount withstanding before check outs are blocked','Integer'),
311
('NoIssuesChargeGuarantees','','','Define maximum amount withstanding before check outs are blocked','Integer'),
312
('noItemTypeImages','0',NULL,'If ON, disables item-type images','YesNo'),
312
('noItemTypeImages','0',NULL,'If ON, disables item-type images','YesNo'),
313
('NoRenewalBefore','exact_time','date|exact_time','Calculate NoRenewalBefore based on date only or exact time of due date','Choice'),
313
('NotesBlacklist','',NULL,'List of notes fields that should not appear in the title notes/description separator of details','free'),
314
('NotesBlacklist','',NULL,'List of notes fields that should not appear in the title notes/description separator of details','free'),
314
('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','free'),
315
('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','free'),
315
('NoticeBcc','','','Email address to bcc outgoing notices sent by email','free'),
316
('NoticeBcc','','','Email address to bcc outgoing notices sent by email','free'),
316
- 

Return to bug 22044