From ace4c4e31de7aeac5be416395c069f030fb86515 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 25 Nov 2024 14:15:21 +0100 Subject: [PATCH] Bug 37592: (follow-up) Fix comments in db_rev Signed-off-by: Jonathan Druart --- installer/data/mysql/db_revs/240600029.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/240600029.pl b/installer/data/mysql/db_revs/240600029.pl index 9fa86ba00b4..3dd3438afea 100644 --- a/installer/data/mysql/db_revs/240600029.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 TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT 'the datetime for when a bookings was created' + ALTER TABLE bookings ADD COLUMN creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT 'the timestamp for when a booking was created' SQL my $modification_date_statement = <<~'SQL'; - ALTER TABLE bookings ADD COLUMN modification_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'the datetime for when a booking has been updated' + ALTER TABLE bookings ADD COLUMN modification_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'the timestamp for when a booking has been updated' SQL if ( @{$existing_columns} == 0 ) { $dbh->do("$creation_date_statement AFTER `end_date`"); -- 2.34.1