From bc5315c0a3e6e1c752908cfaaf852b9dfe2da530 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 2 Dec 2021 12:29:37 +0100 Subject: [PATCH] Bug 29605: additional_contents.lang Up to 50 on bug 23797 but bug 24387 switched it back to 25 (bad resolution conflict) Signed-off-by: Tomas Cohen Arazi --- 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 5e973d7cd3..d07fc1f9a3 100755 --- a/installer/data/mysql/atomicupdate/bug_29605.pl +++ b/installer/data/mysql/atomicupdate/bug_29605.pl @@ -51,6 +51,14 @@ return { ); say $out "Ensure additional_contents.code is VARCHAR(100)"; + $dbh->do( + q{ + ALTER TABLE `additional_contents` + MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT '' + } + ); + say $out "Ensure additional_contents.lang is VARCHAR(50)"; + }, } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 292beedf5d..8a2c488ac1 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -196,7 +196,7 @@ CREATE TABLE `additional_contents` ( `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', `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content', - `lang` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)', + `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)', `published_on` date DEFAULT NULL COMMENT 'publication date', `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification', `expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible', -- 2.34.1