-- +goose Up
ALTER TABLE helicopters
  ADD COLUMN foto_attachment_id BINARY(16) NULL,
  ADD KEY idx_helicopters_foto_attachment_id (foto_attachment_id),
  ADD CONSTRAINT fk_helicopters_foto_attachment
    FOREIGN KEY (foto_attachment_id) REFERENCES attachments(id)
    ON UPDATE CASCADE
    ON DELETE SET NULL;

-- +goose Down
ALTER TABLE helicopters
  DROP FOREIGN KEY fk_helicopters_foto_attachment,
  DROP KEY idx_helicopters_foto_attachment_id,
  DROP COLUMN foto_attachment_id;