Attachment #128154 for bug #29605

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

Lines 43-48 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (+8 lines)
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	}

Lines 191-197 DROP TABLE IF EXISTS `additional_contents`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
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