Mercurial > gemma
view schema/updates/1004/01.optimize_index-setup.sql @ 4793:d6d73ca5496a
client: import_overview: improve implementation of exporting logs
* adjust using of end point
* delete the generation of csv in front end
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Fri, 25 Oct 2019 15:09:10 +0200 |
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)