From d742e7066dc6cec9764413d74f06a484cc953e23 Mon Sep 17 00:00:00 2001 From: Paul Derscheid Date: Wed, 18 Sep 2024 08:35:19 +0000 Subject: [PATCH] Bug 37601: (QA follow-up) Adjust kohastructure.sql Signed-off-by: Jonathan Druart --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 9a3661df15..2b2175fe2f 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1219,7 +1219,7 @@ CREATE TABLE `bookings` ( `end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', `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', - `status` enum('created', 'cancelled') NOT NULL DEFAULT 'created' COMMENT 'current status of the booking', + `status` enum('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking', PRIMARY KEY (`booking_id`), KEY `patron_id` (`patron_id`), KEY `biblio_id` (`biblio_id`), -- 2.39.5