From c340d2334d574816dd0a4dfe4133539997c3300f Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 20 Dec 2023 16:22:37 +0000 Subject: [PATCH] Bug 34324: Add opac_problem to source enum of tickets --- installer/data/mysql/atomicupdate/bug_34324.pl | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_34324.pl diff --git a/installer/data/mysql/atomicupdate/bug_34324.pl b/installer/data/mysql/atomicupdate/bug_34324.pl new file mode 100644 index 00000000000..3052637ce51 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_34324.pl @@ -0,0 +1,15 @@ +use Modern::Perl; + +return { + bug_number => "34324", + description => "Add opac_problem to source enum of tickets table", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do( + "ALTER TABLE `tickets` MODIFY COLUMN `source` enum('catalog','opac_problem') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket'" + ); + say $out "Added opac_problem to source enum of 'tickets.source'"; + }, +}; -- 2.47.0