Mercurial > gemma
comparison schema/gemma.sql @ 212:229f385448fa
Make map extent mandatory
The extent of the countries responsibility area seems a
reasonable default.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 23 Jul 2018 17:41:31 +0200 |
| parents | e7826710d9c4 |
| children | 8b9cae6d3a21 |
comparison
equal
deleted
inserted
replaced
| 211:e7826710d9c4 | 212:229f385448fa |
|---|---|
| 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 responsibility_areas, | 138 country char(2) NOT NULL REFERENCES responsibility_areas, |
| 139 map_extent box2d, | 139 map_extent box2d NOT NULL, |
| 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 ( |
| 144 template_name varchar PRIMARY KEY, | 144 template_name varchar PRIMARY KEY, |