View | Details | Raw Unified | Return to bug 37601
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_37601-add-status-field-to-bookings-table.pl (-2 / +1 lines)
Lines 18-24 return { Link Here
18
            'AFTER' . ( column_exists( 'bookings', 'modification_date' ) ? q{`modification_date`} : q{`end_date`} );
18
            'AFTER' . ( column_exists( 'bookings', 'modification_date' ) ? q{`modification_date`} : q{`end_date`} );
19
        my $statement = <<~"SQL";
19
        my $statement = <<~"SQL";
20
            ALTER TABLE `bookings`
20
            ALTER TABLE `bookings`
21
            ADD COLUMN `status` ENUM('new', 'cancelled') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking' $after;
21
            ADD COLUMN `status` ENUM('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking' $after;
22
        SQL
22
        SQL
23
        if ( $dbh->do($statement) ) {
23
        if ( $dbh->do($statement) ) {
24
            say_success( $out, q{Added column 'bookings.status'} );
24
            say_success( $out, q{Added column 'bookings.status'} );
25
- 

Return to bug 37601