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 ( |