-- Allow multiple duty roster headers on the same base and duty date.
-- Previous schema enforced unique(base_id, duty_date) via idx_roster_base_date.

ALTER TABLE duty_rosters
  DROP INDEX idx_roster_base_date;

CREATE INDEX idx_roster_base_date
  ON duty_rosters (base_id, duty_date);