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

(-)a/installer/data/mysql/updatedatabase.pl (+10 lines)
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)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-2 / +1 lines)
Lines 422-428 Circulation: Link Here
422
            - A loan should be reduced by decreaseLoanHighHoldsDuration when
422
            - A loan should be reduced by decreaseLoanHighHoldsDuration when
423
            - pref: decreaseLoanHighHoldsValue
423
            - pref: decreaseLoanHighHoldsValue
424
              class: integer
424
              class: integer
425
            - holds have been places (if decreaseLoanHighHolds is enables)
425
            - holds have been placed (if decreaseLoanHighHolds is enables)
426
    Fines Policy:
426
    Fines Policy:
427
        -
427
        -
428
            - Calculate fines based on days overdue
428
            - Calculate fines based on days overdue
429
- 

Return to bug 7751