-- To allow "Measured" and "Forecast" values to coexist for the same
-- time and gauge, the primary key must include the measure_type.

ALTER TABLE waterway.effective_fairway_availability
    DROP CONSTRAINT effective_fairway_availability_pkey;

ALTER TABLE waterway.effective_fairway_availability
    ADD PRIMARY KEY (fairway_availability_id, measure_date,
                     level_of_service, measure_type);