From 220a4a44e7d005f693697a10fb563a7b028faad3 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Fri, 26 Apr 2024 16:59:58 +0000 Subject: [PATCH] Bug 33478: DBRev 23.12.00.032 Signed-off-by: Katrin Fischer --- Koha.pm | 2 +- .../bug_33478-add_letter_columns.pl | 18 ----------------- installer/data/mysql/db_revs/231200032.pl | 20 +++++++++++++++++++ 3 files changed, 21 insertions(+), 19 deletions(-) delete mode 100755 installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl create mode 100755 installer/data/mysql/db_revs/231200032.pl diff --git a/Koha.pm b/Koha.pm index cd41e65db4..d76c922c4e 100644 --- a/Koha.pm +++ b/Koha.pm @@ -29,7 +29,7 @@ use vars qw{ $VERSION }; # - #4 : the developer version. The 4th number is the database subversion. # used by developers when the database changes. updatedatabase take care of the changes itself # and is automatically called by Auth.pm when needed. -$VERSION = "23.12.00.031"; +$VERSION = "23.12.00.032"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl b/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl deleted file mode 100755 index 91caa66079..0000000000 --- a/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl +++ /dev/null @@ -1,18 +0,0 @@ -use Modern::Perl; - -return { - bug_number => "33478", - description => "Customise the format of notices when they are printed", - up => sub { - my ($args) = @_; - my ($dbh, $out) = @$args{qw(dbh out)}; - - if( !column_exists( 'letter', 'style' ) ) { - $dbh->do(q{ - ALTER TABLE letter ADD COLUMN `style` mediumtext DEFAULT NULL AFTER `updated_on` - }); - - say $out "Added column 'letter.style'"; - } - }, -}; diff --git a/installer/data/mysql/db_revs/231200032.pl b/installer/data/mysql/db_revs/231200032.pl new file mode 100755 index 0000000000..47f5833241 --- /dev/null +++ b/installer/data/mysql/db_revs/231200032.pl @@ -0,0 +1,20 @@ +use Modern::Perl; + +return { + bug_number => "33478", + description => "Customise the format of notices when they are printed", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + if ( !column_exists( 'letter', 'style' ) ) { + $dbh->do( + q{ + ALTER TABLE letter ADD COLUMN `style` mediumtext DEFAULT NULL AFTER `updated_on` + } + ); + + say $out "Added column 'letter.style'"; + } + }, +}; -- 2.39.5