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