-- +goose Up
UPDATE base_contact_roles SET role_code = 'hems_edc' WHERE role_code = 'responsible_flight_rescuer';
UPDATE base_contact_roles SET role_code = 'med_pax' WHERE role_code = 'chief_physician_in_charge';

ALTER TABLE base_contact_roles ADD CONSTRAINT chk_base_contact_roles_role_code
  CHECK (role_code IN ('hems_edc', 'med_pax', 'responsible_pilot', 'dul'));

-- +goose Down
ALTER TABLE base_contact_roles DROP CHECK chk_base_contact_roles_role_code;

UPDATE base_contact_roles SET role_code = 'responsible_flight_rescuer' WHERE role_code = 'hems_edc';
UPDATE base_contact_roles SET role_code = 'chief_physician_in_charge' WHERE role_code = 'med_pax';

ALTER TABLE base_contact_roles ADD CONSTRAINT chk_base_contact_roles_role_code
  CHECK (role_code IN ('responsible_flight_rescuer', 'chief_physician_in_charge', 'responsible_pilot', 'dul'));