From a1a70186920ff383f036edd5165782b52eafb6f9 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 3 Nov 2023 11:26:19 -0300 Subject: [PATCH] Bug 29002: DBRev 23.06.00.061 Signed-off-by: Tomas Cohen Arazi --- Koha.pm | 2 +- .../{atomicupdate/bug_29002.pl => db_revs/230600061.pl} | 7 ++++++- 2 files changed, 7 insertions(+), 2 deletions(-) rename installer/data/mysql/{atomicupdate/bug_29002.pl => db_revs/230600061.pl} (92%) diff --git a/Koha.pm b/Koha.pm index 577c71c35e..a931cf6bcf 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.06.00.060"; +$VERSION = "23.06.00.061"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_29002.pl b/installer/data/mysql/db_revs/230600061.pl similarity index 92% rename from installer/data/mysql/atomicupdate/bug_29002.pl rename to installer/data/mysql/db_revs/230600061.pl index 59b05e1cbd..31c2cc43bd 100755 --- a/installer/data/mysql/atomicupdate/bug_29002.pl +++ b/installer/data/mysql/db_revs/230600061.pl @@ -26,6 +26,7 @@ return { ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci } ); + say $out "Added new table 'bookings'"; } if ( !column_exists( 'items', 'bookable' ) ) { @@ -34,6 +35,8 @@ return { ALTER TABLE items ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not' AFTER `barcode` } ); + + say $out "Added column 'items.bookable'"; } if ( !column_exists( 'deleteditems', 'bookable' ) ) { @@ -42,6 +45,8 @@ return { ALTER TABLE deleteditems ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not' AFTER `barcode` } ); + + say $out "Added column 'deleteditems.bookable'"; } $dbh->do( @@ -53,7 +58,7 @@ return { ); } ); - say $out "Added new permissions 'manage_bookings'"; + say $out "Added new permission 'manage_bookings'"; }, }; -- 2.39.5