From 9f83bad68cc1f407b864820a023fdecb6fd67043 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 5 Jul 2022 11:08:16 -0300 Subject: [PATCH] Bug 24010: (QA follow-up) Correct COMMENT syntax Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 29a9d790e811c2a3139abf75a2f8f05901973c81) Signed-off-by: Lucas Gass --- installer/data/mysql/atomicupdate/bug_24010.pl | 2 ++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_24010.pl b/installer/data/mysql/atomicupdate/bug_24010.pl index d0bbe10eb1..da0000bea5 100755 --- a/installer/data/mysql/atomicupdate/bug_24010.pl +++ b/installer/data/mysql/atomicupdate/bug_24010.pl @@ -15,6 +15,7 @@ return { $dbh->do(q{ ALTER TABLE subscription MODIFY COLUMN staffdisplaycount INT(11) NULL DEFAULT NULL + COMMENT 'how many issues to show to the staff' }); $dbh->do(q{ @@ -25,6 +26,7 @@ return { $dbh->do(q{ ALTER TABLE subscription MODIFY COLUMN opacdisplaycount INT(11) NULL DEFAULT NULL + COMMENT 'how many issues to show to the public' }); }, }; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 46f60ade63..3d077b4e15 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4874,8 +4874,8 @@ CREATE TABLE `subscription` ( `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)', `lastbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record', - `staffdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the staff - `opacdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the public + `staffdisplaycount` INT(11) NULL DEFAULT NULL COMMENT 'how many issues to show to the staff', + `opacdisplaycount` INT(11) NULL DEFAULT NULL COMMENT 'how many issues to show to the public', `graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days', `enddate` date DEFAULT NULL COMMENT 'subscription end date', `closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed', -- 2.39.5