From 051b9243149f2b26a5b3d9fd7b723466092f19d8 Mon Sep 17 00:00:00 2001 From: Agustin Moyano Date: Fri, 4 Dec 2020 18:47:30 -0300 Subject: [PATCH] Bug 23207: Add automatic_checkin column to itemtypes table installer/data/mysql/kohastructure.sql Signed-off-by: Andrew Fuerste-Henry --- installer/data/mysql/atomicupdate/bug_23027.perl | 11 +++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 12 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_23027.perl diff --git a/installer/data/mysql/atomicupdate/bug_23027.perl b/installer/data/mysql/atomicupdate/bug_23027.perl new file mode 100644 index 0000000000..5e7a57894c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_23027.perl @@ -0,0 +1,11 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + if( !column_exists( 'itemtypes', 'automatic_checkin' ) ) { + $dbh->do(q{ + ALTER TABLE itemtypes ADD COLUMN `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 AFTER `searchcategory` -- 1 if automatic checkin is enabled for items of this type + }); + } + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, 23027, "Add automatic_checkin to itemtypes table"); +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ae247e67c8..bddae483e7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3133,6 +3133,7 @@ CREATE TABLE `itemtypes` ( `sip_media_type` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype', `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC', `searchcategory` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options', + `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0, -- 1 if automatic checkin is enabled for items of this type PRIMARY KEY (`itemtype`), UNIQUE KEY `itemtype` (`itemtype`), KEY `itemtypes_ibfk_1` (`parent_type`), -- 2.11.0