View | Details | Raw Unified | Return to bug 29605
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (+8 lines)
Lines 43-48 return { Link Here
43
        );
43
        );
44
        say $out "Ensure NOT NULL on account_offsets.type";
44
        say $out "Ensure NOT NULL on account_offsets.type";
45
45
46
        $dbh->do(
47
            q{
48
                ALTER TABLE `additional_contents`
49
                MODIFY COLUMN `code` VARCHAR(100) NOT NULL
50
            }
51
        );
52
        say $out "Ensure additional_contents.code is VARCHAR(100)";
53
46
    },
54
    },
47
55
48
}
56
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 191-197 DROP TABLE IF EXISTS `additional_contents`; Link Here
191
CREATE TABLE `additional_contents` (
191
CREATE TABLE `additional_contents` (
192
  `idnew` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content',
192
  `idnew` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content',
193
  `category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'category for the additional content',
193
  `category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'category for the additional content',
194
  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang',
194
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang',
195
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'location of the additional content',
195
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'location of the additional content',
196
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.',
196
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.',
197
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content',
197
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content',
198
- 

Return to bug 29605