From 2882a7461300369005a23ba1487eba73cb32f061 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Mon, 25 Nov 2024 13:09:08 +0000
Subject: [PATCH] Bug 37592: (Follow-up) Fix timestamp vs datetime in db_rev

---
 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 863f9bf2932..9fa86ba00b4 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 DATETIME 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 datetime for when a bookings was created'
         SQL
         my $modification_date_statement = <<~'SQL';
-            ALTER TABLE bookings ADD COLUMN modification_date DATETIME 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 datetime for when a booking has been updated'
         SQL
         if ( @{$existing_columns} == 0 ) {
             $dbh->do("$creation_date_statement AFTER `end_date`");
-- 
2.47.0