From c5d70256d5a9013e3a01574a4503bdc1742d1b9e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 6 Jun 2019 14:49:18 -0500 Subject: [PATCH] Bug 9834: Add DB changes Signed-off-by: Liz Rea --- installer/data/mysql/atomicupdate/bug_9834.perl | 12 ++++++++++++ installer/data/mysql/kohastructure.sql | 2 ++ 2 files changed, 14 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_9834.perl diff --git a/installer/data/mysql/atomicupdate/bug_9834.perl b/installer/data/mysql/atomicupdate/bug_9834.perl new file mode 100644 index 0000000000..37189f562c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_9834.perl @@ -0,0 +1,12 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + unless ( column_exists( 'reserves', 'item_level_hold' ) ) { + $dbh->do( "ALTER TABLE reserves ADD COLUMN item_level_hold BOOLEAN NOT NULL DEFAULT 0 AFTER itemtype" ); + } + unless ( column_exists( 'old_reserves', 'item_level_hold' ) ) { + $dbh->do( "ALTER TABLE old_reserves ADD COLUMN item_level_hold BOOLEAN NOT NULL DEFAULT 0 AFTER itemtype" ); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 9834 - Add the reserves.item_level_hold column)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e171b32e19..e3d0930369 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1882,6 +1882,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `suspend` BOOLEAN NOT NULL DEFAULT 0, `suspend_until` DATETIME NULL DEFAULT NULL, `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting + `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level PRIMARY KEY (`reserve_id`), KEY priorityfoundidx (priority,found), KEY `borrowernumber` (`borrowernumber`), @@ -1921,6 +1922,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting + `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level PRIMARY KEY (`reserve_id`), KEY `old_reserves_borrowernumber` (`borrowernumber`), KEY `old_reserves_biblionumber` (`biblionumber`), -- 2.11.0