From 657a9f28998feb3745b31adaca2e4df19d25a02b Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Thu, 4 Aug 2022 09:47:38 -0300 Subject: [PATCH] Bug 30650: (QA follow-up) Fix TINYINT fields discrepancy on upgrade Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/db_revs/220600022.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/220600022.pl b/installer/data/mysql/db_revs/220600022.pl index 95a37f6d82f..e3b427e97f1 100755 --- a/installer/data/mysql/db_revs/220600022.pl +++ b/installer/data/mysql/db_revs/220600022.pl @@ -57,7 +57,7 @@ return { CREATE TABLE `curbside_pickup_opening_slots` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `curbside_pickup_policy_id` INT(11) NOT NULL, - `day` INT(1) NOT NULL, + `day` TINYINT(1) NOT NULL, `start_hour` INT(2) NOT NULL, `start_minute` INT(2) NOT NULL, `end_hour` INT(2) NOT NULL, @@ -182,7 +182,7 @@ return { 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 + ADD COLUMN enable_waiting_holds_only TINYINT(1) NOT NULL DEFAULT 0 AFTER enabled }); } } -- 2.34.1