Lines 5848-5853
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
Link Here
|
5848 |
WHEN 5 THEN 'ACC' |
5848 |
WHEN 5 THEN 'ACC' |
5849 |
END;"); |
5849 |
END;"); |
5850 |
$dbh->do("ALTER TABLE reports_dictionary DROP area;"); |
5850 |
$dbh->do("ALTER TABLE reports_dictionary DROP area;"); |
|
|
5851 |
|
5851 |
$dbh->do("ALTER TABLE reports_dictionary ADD KEY dictionary_area_idx (report_area);"); |
5852 |
$dbh->do("ALTER TABLE reports_dictionary ADD KEY dictionary_area_idx (report_area);"); |
5852 |
|
5853 |
|
5853 |
$dbh->do("ALTER TABLE saved_sql ADD report_area varchar(6) DEFAULT NULL;"); |
5854 |
$dbh->do("ALTER TABLE saved_sql ADD report_area varchar(6) DEFAULT NULL;"); |
Lines 5859-5864
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
Link Here
|
5859 |
SetVersion($DBversion); |
5860 |
SetVersion($DBversion); |
5860 |
} |
5861 |
} |
5861 |
|
5862 |
|
|
|
5863 |
$DBversion ="3.09.00.XXX"; |
5864 |
if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
5865 |
$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')|); |
5866 |
$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')|); |
5867 |
$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')|); |
5868 |
print "Upgrade to $DBversion done (Add decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration sysprefs`)\n"; |
5869 |
SetVersion($DBversion); |
5870 |
} |
5871 |
|
5862 |
=head1 FUNCTIONS |
5872 |
=head1 FUNCTIONS |
5863 |
|
5873 |
|
5864 |
=head2 TableExists($table) |
5874 |
=head2 TableExists($table) |