Mercurial > gemma

diff schema/gemma.sql @ 212:229f385448fa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Jul 23 16:45:27 2018 +0200
+++ b/schema/gemma.sql	Mon Jul 23 17:41:31 2018 +0200
@@ -136,7 +136,7 @@
     CREATE TABLE user_profiles (
         username varchar PRIMARY KEY,
         country char(2) NOT NULL REFERENCES responsibility_areas,
-        map_extent box2d,
+        map_extent box2d NOT NULL,
         email_adress varchar NOT NULL UNIQUE
     )