Mercurial > gemma

diff schema/gemma.sql @ 4859:082027fb2d58

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow "Measured" and "Forecast" values to coexist for the same time and gauge.
author Sascha Wilde <wilde@intevation.de>
date Wed, 04 Dec 2019 13:35:34 +0100
parents c69e35ec6adf
children 5c12b7cdc58c 8eb36d0d5bdf
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Nov 21 15:44:39 2019 +0100
+++ b/schema/gemma.sql	Wed Dec 04 13:35:34 2019 +0100
@@ -824,7 +824,8 @@
         fairway_availability_id int NOT NULL REFERENCES fairway_availability,
         measure_date timestamp with time zone NOT NULL,
         level_of_service smallint NOT NULL REFERENCES levels_of_service,
-        PRIMARY KEY (fairway_availability_id, measure_date, level_of_service),
+        PRIMARY KEY (fairway_availability_id, measure_date, level_of_service,
+                     measure_type),
         available_depth_value smallint,
         available_width_value smallint,
         water_level_value smallint,