@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_30889.pl | 15 +++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 16 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_30889.pl --- a/installer/data/mysql/atomicupdate/bug_30889.pl +++ a/installer/data/mysql/atomicupdate/bug_30889.pl @@ -0,0 +1,15 @@ +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"; + } + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -984,6 +984,7 @@ CREATE TABLE `background_jobs` ( `type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Name of the queue the job is sent to', `data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `enqueued_on` datetime DEFAULT NULL, `started_on` datetime DEFAULT NULL, `ended_on` datetime DEFAULT NULL, --