Mercurial > gemma
diff schema/gemma.sql @ 211:e7826710d9c4
Make responsibility area mandatory
Each waterway administrator has to have a responsibility
area assigned, which is now ensured by referencing the
respective table instead of countries directly.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 23 Jul 2018 16:45:27 +0200 |
parents | 9585982180ab |
children | 229f385448fa |
line wrap: on
line diff
--- a/schema/gemma.sql Mon Jul 23 16:40:21 2018 +0200 +++ b/schema/gemma.sql Mon Jul 23 16:45:27 2018 +0200 @@ -135,7 +135,7 @@ CREATE TABLE user_profiles ( username varchar PRIMARY KEY, - country char(2) NOT NULL REFERENCES countries, + country char(2) NOT NULL REFERENCES responsibility_areas, map_extent box2d, email_adress varchar NOT NULL UNIQUE )