Mercurial > gemma
comparison 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 |
comparison
equal
deleted
inserted
replaced
210:a0e2c6bb3cb3 | 211:e7826710d9c4 |
---|---|
133 --XXX: Should be geography (elsewhere too) | 133 --XXX: Should be geography (elsewhere too) |
134 ) | 134 ) |
135 | 135 |
136 CREATE TABLE user_profiles ( | 136 CREATE TABLE user_profiles ( |
137 username varchar PRIMARY KEY, | 137 username varchar PRIMARY KEY, |
138 country char(2) NOT NULL REFERENCES countries, | 138 country char(2) NOT NULL REFERENCES responsibility_areas, |
139 map_extent box2d, | 139 map_extent box2d, |
140 email_adress varchar NOT NULL UNIQUE | 140 email_adress varchar NOT NULL UNIQUE |
141 ) | 141 ) |
142 | 142 |
143 CREATE TABLE templates ( | 143 CREATE TABLE templates ( |