Mercurial > gemma

view schema/updates/1004/01.optimize_index-setup.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 9ab7e1056360
children
line wrap: on
line source

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)