Attachment #25855 for bug #7413

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

Lines 1155-1160 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
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




    SetVersion($DBversion);
}

$DBversion = "3.15.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        ALTER TABLE issuingrules ADD norenewalbefore int(4) default NULL AFTER renewalperiod
    });
    print "Upgrade to $DBversion done (Bug 7413: Allow OPAC renewal x days before due date)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 7413

Lines 8012-8017 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
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	-