@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_29605.pl | 8 ++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 9 insertions(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_29605.pl +++ a/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)"; + }, } --- a/installer/data/mysql/kohastructure.sql +++ a/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', --