From 750f40eaae5198ca5e0f383aca1bcec1782b639c Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Mon, 16 Sep 2024 11:27:02 +0000 Subject: [PATCH] Bug 37592: (follow-up) Fix database column names in kohastructure.sql Signed-off-by: Katrin Fischer --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index cf1798e23c..0ac5919d3a 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1217,8 +1217,8 @@ CREATE TABLE `bookings` ( `pickup_library_id` varchar(10) NOT NULL COMMENT 'Identifier for booking pickup library', `start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', `end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', - `created_on` timestamp DEFAULT current_timestamp() COMMENT 'the timestamp for when a booking was created', - `updated_on` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated', + `creation_date` timestamp DEFAULT current_timestamp() COMMENT 'the timestamp for when a booking was created', + `modification_date` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated', PRIMARY KEY (`booking_id`), KEY `patron_id` (`patron_id`), KEY `biblio_id` (`biblio_id`), -- 2.39.5