Attachment #131184 for bug #30128

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




use Modern::Perl;

return {
    bug_number => "30128",
    description => "Change language_subtag_registry.description to varchar(255)",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        # Do you stuffs here
        $dbh->do(q{
            ALTER TABLE `language_subtag_registry` MODIFY COLUMN `description` VARCHAR(255) DEFAULT NULL
        });
    },
};

Lines 3277-3283 DROP TABLE IF EXISTS `language_subtag_registry`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
3277	CREATE TABLE `language_subtag_registry` (	3277	CREATE TABLE `language_subtag_registry` (
3278	`subtag` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3278	`subtag` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3279	`type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'language-script-region-variant-extension-privateuse',	3279	`type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'language-script-region-variant-extension-privateuse',
3280	`description` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'only one of the possible descriptions for ease of reference, see language_descriptions for the complete list',	3280	`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'only one of the possible descriptions for ease of reference, see language_descriptions for the complete list',
3281	`added` date DEFAULT NULL,	3281	`added` date DEFAULT NULL,
3282	`id` int(11) NOT NULL AUTO_INCREMENT,	3282	`id` int(11) NOT NULL AUTO_INCREMENT,
3283	PRIMARY KEY (`id`),	3283	PRIMARY KEY (`id`),
3284	-

Return to bug 30128

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_30128.pl (+14 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "30128",
	5	description => "Change language_subtag_registry.description to varchar(255)",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	# Do you stuffs here
	10	$dbh->do(q{
	11	ALTER TABLE `language_subtag_registry` MODIFY COLUMN `description` VARCHAR(255) DEFAULT NULL
	12	});
	13	},
	14	};