Mercurial > gemma

diff schema/gemma.sql @ 211:e7826710d9c4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
     )