From 78e28dc804d379f7409b553afe5851a8a4a7442b Mon Sep 17 00:00:00 2001 From: Kyle Hall Date: Thu, 11 Nov 2021 07:16:34 -0500 Subject: [PATCH] DBRev 21.05.05.004 Signed-off-by: Kyle M Hall --- installer/data/mysql/atomicupdate/bug_29386.pl | 14 -------------- installer/data/mysql/updatedatabase.pl | 9 +++++++++ 2 files changed, 9 insertions(+), 14 deletions(-) delete mode 100755 installer/data/mysql/atomicupdate/bug_29386.pl diff --git a/installer/data/mysql/atomicupdate/bug_29386.pl b/installer/data/mysql/atomicupdate/bug_29386.pl deleted file mode 100755 index ba57d823a1..0000000000 --- a/installer/data/mysql/atomicupdate/bug_29386.pl +++ /dev/null @@ -1,14 +0,0 @@ -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 - |); - }, -} diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 0ce8f8e08a..e3866330b0 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -24520,6 +24520,15 @@ if( CheckVersion( $DBversion ) ) { NewVersion( $DBversion, "", "Koha 21.05.05 release" ); } +$DBversion = '21.05.05.004'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q| + ALTER TABLE background_jobs + CHANGE COLUMN `data` `data` LONGTEXT DEFAULT NULL + |); + NewVersion( $DBversion, "29386", "Extend background_jobs.data to LONGTEXT" ); +} + # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; -- 2.39.5