14 lines
401 B
SQL
14 lines
401 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE maintenance_check_flights
|
|
ADD COLUMN flight_id BINARY(16) NULL AFTER helicopter_id,
|
|
ADD KEY idx_maintenance_check_flights_flight_id (flight_id);
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
ALTER TABLE maintenance_check_flights
|
|
DROP KEY idx_maintenance_check_flights_flight_id,
|
|
DROP COLUMN flight_id;
|
|
-- +goose StatementEnd
|