Attachment #67202 for bug #15486

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




$DBversion = "XXX";
if ( CheckVersion($DBversion) ) {

    if ( !column_exists( 'issuingrules', 'holds_per_day' ) ) {
        $dbh->do(q{
            ALTER TABLE `issuingrules`
                ADD COLUMN `holds_per_day` SMALLINT(6) DEFAULT NULL
                AFTER `holds_per_record`
        });
    }

    print "Upgrade to $DBversion done (Bug 15486: Restrict number of holds placed by day)\n";
    SetVersion($DBversion);
}

Return to bug 15486

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_15486_max_holds_per_day.perl (+14 lines)
	1	$DBversion = "XXX";
	2	if ( CheckVersion($DBversion) ) {
	3
	4	if ( !column_exists( 'issuingrules', 'holds_per_day' ) ) {
	5	$dbh->do(q{
	6	ALTER TABLE `issuingrules`
	7	ADD COLUMN `holds_per_day` SMALLINT(6) DEFAULT NULL
	8	AFTER `holds_per_record`
	9	});
	10	}
	11
	12	print "Upgrade to $DBversion done (Bug 15486: Restrict number of holds placed by day)\n";
	13	SetVersion($DBversion);
	14	}

Lines 880-885 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
880	`no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date	880	`no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date
881	`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed	881	`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
882	`holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib	882	`holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib
		883	`holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day
883	`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)	884	`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
884	overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine	885	overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
885	cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price	886	cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price
Lines 1890-1896 DROP TABLE IF EXISTS `reserves`; Link Here
1890	CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha	1891	CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
1891	`reserve_id` int(11) NOT NULL auto_increment, -- primary key	1892	`reserve_id` int(11) NOT NULL auto_increment, -- primary key
1892	`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for	1893	`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1893	`reservedate` date default NULL, -- the date the hold was places	1894	`reservedate` date default NULL, -- the date the hold was placed
1894	`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on	1895	`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1895	`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at	1896	`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1896	`notificationdate` date default NULL, -- currently unused	1897	`notificationdate` date default NULL, -- currently unused
1897	-