From d17c640510d0a17dec2928bf1124c9d27872818a Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Mon, 16 Sep 2024 11:17:49 +0000 Subject: [PATCH] Bug 37592: DBRev 24.06.00.029 Signed-off-by: Katrin Fischer --- Koha.pm | 2 +- .../240600029.pl} | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) rename installer/data/mysql/{atomicupdate/bug_37592-add_created_at_updated_at_to_bookings.pl => db_revs/240600029.pl} (96%) diff --git a/Koha.pm b/Koha.pm index 5eb2a5c1e1..1c4dcaccad 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 = "24.06.00.028"; +$VERSION = "24.06.00.029"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_37592-add_created_at_updated_at_to_bookings.pl b/installer/data/mysql/db_revs/240600029.pl similarity index 96% rename from installer/data/mysql/atomicupdate/bug_37592-add_created_at_updated_at_to_bookings.pl rename to installer/data/mysql/db_revs/240600029.pl index 0c95f4f425..59350818a8 100755 --- a/installer/data/mysql/atomicupdate/bug_37592-add_created_at_updated_at_to_bookings.pl +++ b/installer/data/mysql/db_revs/240600029.pl @@ -25,10 +25,10 @@ return { } my $creation_date_statement = <<~'SQL'; - ALTER TABLE bookings ADD COLUMN creation_date DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'The datetime for when a bookings was created' + ALTER TABLE bookings ADD COLUMN creation_date DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'The datetime for when a bookings was created' AFTER end_date SQL my $modification_date_statement = <<~'SQL'; - ALTER TABLE bookings ADD COLUMN modification_date DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The datetime for when a booking has been updated' + ALTER TABLE bookings ADD COLUMN modification_date DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The datetime for when a booking has been updated' AFTER modification_date SQL if ( @{$existing_columns} == 0 ) { if ( $dbh->do("$creation_date_statement AFTER `end_date`") ) { -- 2.39.5