From 7e004b9a0de6a3115a0e6cb016e7f59f3c7360a7 Mon Sep 17 00:00:00 2001 From: Arthur Suzuki Date: Mon, 22 Aug 2022 10:45:11 +0200 Subject: [PATCH] DBRev 21.11.11.000 Signed-off-by: Arthur Suzuki --- .../data/mysql/atomicupdate/bug_24010.pl | 32 ------------------- installer/data/mysql/db_revs/211111000.pl | 7 ++++ 2 files changed, 7 insertions(+), 32 deletions(-) delete mode 100755 installer/data/mysql/atomicupdate/bug_24010.pl create mode 100644 installer/data/mysql/db_revs/211111000.pl diff --git a/installer/data/mysql/atomicupdate/bug_24010.pl b/installer/data/mysql/atomicupdate/bug_24010.pl deleted file mode 100755 index da0000bea5..0000000000 --- a/installer/data/mysql/atomicupdate/bug_24010.pl +++ /dev/null @@ -1,32 +0,0 @@ -use Modern::Perl; - -return { - bug_number => "24010", - description => "Make subscription.staffdisplaycount and opacdisplaycount integer columns", - up => sub { - my ($args) = @_; - my ($dbh, $out) = @$args{qw(dbh out)}; - - $dbh->do(q{ - UPDATE subscription - SET staffdisplaycount = NULL - WHERE staffdisplaycount = "" - }); - $dbh->do(q{ - ALTER TABLE subscription - MODIFY COLUMN staffdisplaycount INT(11) NULL DEFAULT NULL - COMMENT 'how many issues to show to the staff' - }); - - $dbh->do(q{ - UPDATE subscription - SET opacdisplaycount = NULL - WHERE opacdisplaycount = "" - }); - $dbh->do(q{ - ALTER TABLE subscription - MODIFY COLUMN opacdisplaycount INT(11) NULL DEFAULT NULL - COMMENT 'how many issues to show to the public' - }); - }, -}; diff --git a/installer/data/mysql/db_revs/211111000.pl b/installer/data/mysql/db_revs/211111000.pl new file mode 100644 index 0000000000..42c5b6130d --- /dev/null +++ b/installer/data/mysql/db_revs/211111000.pl @@ -0,0 +1,7 @@ +use Modern::Perl; + +return { + bug_number => undef, + description => 'Koha 21.11.11 release', + up => sub {}, +} -- 2.39.2