From ce71c37a123131b8d15437ad05cd27383e6f81c2 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 2 Dec 2021 12:28:23 +0100 Subject: [PATCH] Bug 29605: additional_contents.code Added 100 on 210600016, but 20 in kohastructure Signed-off-by: Tomas Cohen Arazi Signed-off-by: Nick Clemens Signed-off-by: Fridolin Somers Signed-off-by: Kyle M Hall --- installer/data/mysql/atomicupdate/bug_29605.pl | 8 ++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 9 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_29605.pl b/installer/data/mysql/atomicupdate/bug_29605.pl index a6bbbb08de..5e973d7cd3 100755 --- a/installer/data/mysql/atomicupdate/bug_29605.pl +++ b/installer/data/mysql/atomicupdate/bug_29605.pl @@ -43,6 +43,14 @@ return { ); say $out "Ensure NOT NULL on account_offsets.type"; + $dbh->do( + q{ + ALTER TABLE `additional_contents` + MODIFY COLUMN `code` VARCHAR(100) NOT NULL + } + ); + say $out "Ensure additional_contents.code is VARCHAR(100)"; + }, } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6b6379cf8f..f2bd5b0fa0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -191,7 +191,7 @@ DROP TABLE IF EXISTS `additional_contents`; CREATE TABLE `additional_contents` ( `idnew` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content', `category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'category for the additional content', - `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang', + `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang', `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'location of the additional content', `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.', `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content', -- 2.39.5