# HG changeset patch # User Tom Gottfried # Date 1553857342 -3600 # Node ID 96781e51995252d0da6b9c05b77a2090f5363ff2 # Parent e2d362589ce6a5a437e61200ba9efad8d6596170 Fix syntax error in schema diff -r e2d362589ce6 -r 96781e519952 schema/gemma.sql --- 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,