@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ .../prog/en/modules/admin/preferences/circulation.pref | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -5848,6 +5848,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { WHEN 5 THEN 'ACC' END;"); $dbh->do("ALTER TABLE reports_dictionary DROP area;"); + $dbh->do("ALTER TABLE reports_dictionary ADD KEY dictionary_area_idx (report_area);"); $dbh->do("ALTER TABLE saved_sql ADD report_area varchar(6) DEFAULT NULL;"); @@ -5859,6 +5860,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion($DBversion); } +$DBversion ="3.09.00.XXX"; +if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { + $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHolds', NULL, '', 'Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue', 'YesNo')|); + $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHoldsValue', NULL, '', 'Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)', 'Integer')|); + $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHoldsDuration', NULL, '', 'Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds', 'Integer')|); + print "Upgrade to $DBversion done (Add decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration sysprefs`)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref @@ -422,7 +422,7 @@ Circulation: - A loan should be reduced by decreaseLoanHighHoldsDuration when - pref: decreaseLoanHighHoldsValue class: integer - - holds have been places (if decreaseLoanHighHolds is enables) + - holds have been placed (if decreaseLoanHighHolds is enables) Fines Policy: - - Calculate fines based on days overdue --