Mercurial > gemma
diff schema/gemma.sql @ 2864:96781e519952
Fix syntax error in schema
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 29 Mar 2019 12:02:22 +0100 |
parents | e2d362589ce6 |
children | 23ff7f6c543b |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Mar 29 11:27:01 2019 +0100 +++ b/schema/gemma.sql Fri Mar 29 12:02:22 2019 +0100 @@ -348,12 +348,12 @@ -- fk_gauge_id/measure_date pairs in measured values. CREATE UNIQUE INDEX gm_measured_unique_constraint ON gauge_measurements (fk_gauge_id, measure_date, staging_done) - WHERE NOT predicted; + WHERE NOT predicted -- And we can have multiple predictions for one point in time -- (but they are never staged). CREATE UNIQUE INDEX gm_predicted_unique_constraint ON gauge_measurements (fk_gauge_id, measure_date, date_issue) - WHERE predicted; + WHERE predicted CREATE TABLE waterway_axis ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,