Mercurial > gemma

changeset 2864:96781e519952

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix syntax error in schema
author Tom Gottfried <tom@intevation.de>
date Fri, 29 Mar 2019 12:02:22 +0100
parents e2d362589ce6
children 23ff7f6c543b
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
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,