From 810abb2a62ff4242f2b8a10984afe566704b29be Mon Sep 17 00:00:00 2001 From: Paul Derscheid Date: Mon, 16 Sep 2024 10:27:45 +0000 Subject: [PATCH] Bug 37601: (QA follow-up) Add status 'completed' This will probably be useful when transforming a booking into a checkout. Signed-off-by: Katrin Fischer --- .../bug_37601-add-status-field-to-bookings-table.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_37601-add-status-field-to-bookings-table.pl b/installer/data/mysql/atomicupdate/bug_37601-add-status-field-to-bookings-table.pl index 01172c044d..5e35688ac7 100755 --- a/installer/data/mysql/atomicupdate/bug_37601-add-status-field-to-bookings-table.pl +++ b/installer/data/mysql/atomicupdate/bug_37601-add-status-field-to-bookings-table.pl @@ -18,7 +18,7 @@ return { 'AFTER' . ( column_exists( 'bookings', 'modification_date' ) ? q{`modification_date`} : q{`end_date`} ); my $statement = <<~"SQL"; ALTER TABLE `bookings` - ADD COLUMN `status` ENUM('new', 'cancelled') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking' $after; + ADD COLUMN `status` ENUM('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking' $after; SQL if ( $dbh->do($statement) ) { say_success( $out, q{Added column 'bookings.status'} ); -- 2.39.5