15 lines
804 B
SQL
15 lines
804 B
SQL
ALTER TABLE flight_prep_checks DROP FOREIGN KEY fk_flight_prep_checks_flight_prep_item;
|
|
ALTER TABLE flight_prep_checks DROP INDEX uk_flight_prep_checks_inspection_item;
|
|
ALTER TABLE flight_prep_checks DROP COLUMN flight_prep_item_id;
|
|
ALTER TABLE flight_prep_checks DROP COLUMN is_done;
|
|
ALTER TABLE flight_prep_checks DROP COLUMN note;
|
|
ALTER TABLE flight_prep_checks DROP INDEX idx_flight_prep_checks_flight_inspection_sorted;
|
|
|
|
ALTER TABLE flight_prep_checks
|
|
ADD COLUMN notam_briefing TINYINT(1) NOT NULL DEFAULT 0 AFTER id,
|
|
ADD COLUMN weather_briefing TINYINT(1) NOT NULL DEFAULT 0 AFTER notam_briefing,
|
|
ADD COLUMN operational_flight_plan TINYINT(1) NOT NULL DEFAULT 0 AFTER weather_briefing;
|
|
|
|
ALTER TABLE flight_prep_checks
|
|
ADD UNIQUE KEY uk_flight_prep_checks_inspection (flight_inspection_id);
|