From c24af732c00425efbbd6b60222a5b0ec470a9760 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 7 Jul 2017 15:13:00 -0300 Subject: [PATCH] Bug 15486: DB structure change This patch adds a new column __max_holds_per_day__ to the issuingrules table. It's going to be used to set a daily limit for holds. Signed-off-by: Tomas Cohen Arazi --- .../mysql/atomicupdate/bug_15486_max_holds_per_day.perl | 14 ++++++++++++++ installer/data/mysql/kohastructure.sql | 3 ++- 2 files changed, 16 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_15486_max_holds_per_day.perl diff --git a/installer/data/mysql/atomicupdate/bug_15486_max_holds_per_day.perl b/installer/data/mysql/atomicupdate/bug_15486_max_holds_per_day.perl new file mode 100644 index 0000000000..62ade64c6d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_15486_max_holds_per_day.perl @@ -0,0 +1,14 @@ +$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); +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e227125ff1..e64e97f8a3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -880,6 +880,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib + `holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price @@ -1890,7 +1891,7 @@ DROP TABLE IF EXISTS `reserves`; CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `reserve_id` int(11) NOT NULL auto_increment, -- primary key `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for - `reservedate` date default NULL, -- the date the hold was places + `reservedate` date default NULL, -- the date the hold was placed `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at `notificationdate` date default NULL, -- currently unused -- 2.14.1