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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1155-1160 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1155
  `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
1155
  `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
1156
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
1156
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
1157
  `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
1157
  `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
1158
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
1158
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1159
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1159
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1160
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1160
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1161
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
Lines 8012-8017 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
8012
    SetVersion($DBversion);
8012
    SetVersion($DBversion);
8013
}
8013
}
8014
8014
8015
$DBversion = "3.15.00.XXX";
8016
if(CheckVersion($DBversion)) {
8017
    $dbh->do(q{
8018
        ALTER TABLE issuingrules ADD norenewalbefore int(4) default NULL AFTER renewalperiod
8019
    });
8020
    print "Upgrade to $DBversion done (Bug 7413: Allow OPAC renewal x days before due date)\n";
8021
    SetVersion($DBversion);
8022
}
8023
8015
=head1 FUNCTIONS
8024
=head1 FUNCTIONS
8016
8025
8017
=head2 TableExists($table)
8026
=head2 TableExists($table)
8018
- 

Return to bug 7413