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 / +2 lines)
Lines 14-20 return { Link Here
14
            return;
14
            return;
15
        }
15
        }
16
16
17
        my $after     = 'AFTER' . ( column_exists( 'bookings', 'updated_on' ) ? q{`updated_on`} : q{`end_date`} );
17
        my $after =
18
            'AFTER' . ( column_exists( 'bookings', 'modification_date' ) ? q{`modification_date`} : q{`end_date`} );
18
        my $statement = <<~"SQL";
19
        my $statement = <<~"SQL";
19
            ALTER TABLE `bookings`
20
            ALTER TABLE `bookings`
20
            ADD COLUMN `status` ENUM('created', 'cancelled') NOT NULL DEFAULT 'created' COMMENT 'current status of the booking' $after;
21
            ADD COLUMN `status` ENUM('created', 'cancelled') NOT NULL DEFAULT 'created' COMMENT 'current status of the booking' $after;
21
- 

Return to bug 37601