Attachment #127288 for bug #29386

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




use Modern::Perl;

return {
    bug_number => "29386",
    description => "Extend background_jobs.data to LONGTEXT",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        $dbh->do(q|
            ALTER TABLE background_jobs
            CHANGE COLUMN `data` `data` LONGTEXT DEFAULT NULL
        |);
    },
}

Lines 944-950 CREATE TABLE `background_jobs` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
944	`size` int(11) DEFAULT NULL,	944	`size` int(11) DEFAULT NULL,
945	`borrowernumber` int(11) DEFAULT NULL,	945	`borrowernumber` int(11) DEFAULT NULL,
946	`type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,	946	`type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
947	`data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,	947	`data` LONGTEXT COLLATE utf8mb4_unicode_ci DEFAULT NULL,
948	`enqueued_on` datetime DEFAULT NULL,	948	`enqueued_on` datetime DEFAULT NULL,
949	`started_on` datetime DEFAULT NULL,	949	`started_on` datetime DEFAULT NULL,
950	`ended_on` datetime DEFAULT NULL,	950	`ended_on` datetime DEFAULT NULL,
951	-

Return to bug 29386

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29386.pl (+14 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "29386",
	5	description => "Extend background_jobs.data to LONGTEXT",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	$dbh->do(q\|
	10	ALTER TABLE background_jobs
	11	CHANGE COLUMN `data` `data` LONGTEXT DEFAULT NULL
	12	\|);
	13	},
	14	}