ALTER TABLE waterway.gauge_measurements
    DROP CONSTRAINT gauge_measurements_location_measure_date_staging_done_key;
ALTER TABLE waterway.gauge_measurements
    ADD CONSTRAINT gauge_measurements_measure_date_location_staging_done_key
    UNIQUE (measure_date, location, staging_done);
DROP INDEX waterway.gauge_measurements_measure_date;

ALTER TABLE waterway.gauge_predictions
    DROP CONSTRAINT gauge_predictions_pkey;
ALTER TABLE waterway.gauge_predictions
    ADD CONSTRAINT gauge_predictions_pkey
    PRIMARY KEY (measure_date, location, date_issue);
DROP INDEX waterway.gauge_predictions_measure_date;

CREATE INDEX gauge_measurements_location_measure_date_desc
    ON waterway.gauge_measurements (location, measure_date DESC)