Attachment #128442 for bug #29605

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

Lines 51-56 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (+8 lines)
51	);	51	);
52	say $out "Ensure additional_contents.code is VARCHAR(100)";	52	say $out "Ensure additional_contents.code is VARCHAR(100)";
53		53
		54	$dbh->do(
		55	q{
		56	ALTER TABLE `additional_contents`
		57	MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT ''
		58	}
		59	);
		60	say $out "Ensure additional_contents.lang is VARCHAR(50)";
		61
54	},	62	},
55		63
56	}	64	}

Lines 196-202 CREATE TABLE `additional_contents` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
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	`content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content',	198	`content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content',
199	`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)',	199	`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)',
200	`published_on` date DEFAULT NULL COMMENT 'publication date',	200	`published_on` date DEFAULT NULL COMMENT 'publication date',
201	`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',	201	`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',
202	`expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible',	202	`expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible',
203	-

Return to bug 29605