|
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 |
- |
|
|