Attachment #136296 for bug #30889

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




use Modern::Perl;

return {
    bug_number => "30889",
    description => "Add context to background_jobs",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};

        unless( column_exists( 'background_jobs', 'context') ) {
            $dbh->do(q{ ALTER TABLE background_jobs ADD `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `data` });
            say $out "field added";
        }
    },
};

Lines 984-989 CREATE TABLE `background_jobs` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
984	`type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,	984	`type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
985	`queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Name of the queue the job is sent to',	985	`queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Name of the queue the job is sent to',
986	`data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	986	`data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
		987	`context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
987	`enqueued_on` datetime DEFAULT NULL,	988	`enqueued_on` datetime DEFAULT NULL,
988	`started_on` datetime DEFAULT NULL,	989	`started_on` datetime DEFAULT NULL,
989	`ended_on` datetime DEFAULT NULL,	990	`ended_on` datetime DEFAULT NULL,
990	-

Return to bug 30889

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_30889.pl (+15 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "30889",
	5	description => "Add context to background_jobs",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9
	10	unless( column_exists( 'background_jobs', 'context') ) {
	11	$dbh->do(q{ ALTER TABLE background_jobs ADD `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `data` });
	12	say $out "field added";
	13	}
	14	},
	15	};