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