From d01c0c7fa361c4ef7e455369f1a340aea905ef39 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 10 May 2022 08:18:02 +0200 Subject: [PATCH] Bug 30650: DB - Add policy.enable_waiting_holds_only Sponsored-by: Association KohaLa - https://koha-fr.org/ Signed-off-by: Koha Team University Lyon 3 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/atomicupdate/bug_30650.pl | 7 +++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 8 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_30650.pl b/installer/data/mysql/atomicupdate/bug_30650.pl index aef972c408..068b29d66c 100755 --- a/installer/data/mysql/atomicupdate/bug_30650.pl +++ b/installer/data/mysql/atomicupdate/bug_30650.pl @@ -173,5 +173,12 @@ return { VALUES (3, 'manage_curbside_pickups', 'Manage curbside pickups') }); + + unless ( column_exists('curbside_pickup_policy', 'enable_waiting_holds_only') ) { + $dbh->do(q{ + ALTER table curbside_pickup_policy + ADD COLUMN enable_waiting_holds_only INT(1) NOT NULL DEFAULT 0 AFTER enabled + }); + } } } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f53e0ab0bd..fadcedc909 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2333,6 +2333,7 @@ CREATE TABLE `curbside_pickup_policy` ( `id` int(11) NOT NULL auto_increment, `branchcode` varchar(10) NOT NULL, `enabled` TINYINT(1) NOT NULL DEFAULT 0, + `enable_waiting_holds_only` TINYINT(1) NOT NULL DEFAULT 0, `pickup_interval` INT(2) NOT NULL DEFAULT 0, `patrons_per_interval` INT(2) NOT NULL DEFAULT 0, `patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, -- 2.39.5