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