8 lines
481 B
SQL
8 lines
481 B
SQL
ALTER TABLE IF EXISTS `vn2008`.`flight` RENAME `vn`.`flight`;
|
|
|
|
ALTER TABLE IF EXISTS `vn`.`flight`
|
|
CHANGE COLUMN IF EXISTS `flight_id` `id` varchar(10) NOT NULL,
|
|
CHANGE COLUMN IF EXISTS `airline_id` `airlineFk` smallint(2) unsigned DEFAULT NULL,
|
|
CHANGE COLUMN IF EXISTS `route` `flightPath` varchar(20) DEFAULT NULL,
|
|
CHANGE COLUMN IF EXISTS `airport_out` `airportArrivalFk` varchar(3) NOT NULL,
|
|
CHANGE COLUMN IF EXISTS `airport_in` `airportDepartureFk` varchar(3) NOT NULL; |