Mercurial > gemma

changeset 71:e9bc0d93bef9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add missing NOT NULL constraints.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 16:42:38 +0200
parents 28108455ad35
children 158f776732c7
files wamos.sql
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Wed May 30 16:39:26 2018 +0200
+++ b/wamos.sql	Wed May 30 16:42:38 2018 +0200
@@ -73,8 +73,9 @@
        );
 
 CREATE TABLE wamos.gauges_reference_water_levels (
-       gauge_id isrs REFERENCES gauges,
-       reference_water_level varchar(20) REFERENCES reference_water_levels,
+       gauge_id isrs NOT NULL REFERENCES gauges,
+       reference_water_level varchar(20)
+           NOT NULL REFERENCES reference_water_levels,
        PRIMARY KEY (gauge_id, reference_water_level),
        value int NOT NULL
        );