changeset 84:d905022a48e9

More user attributes from APUC3.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 16:14:40 +0200
parents d9d01dc58f60
children 1a640da943b6
files wamos.sql
diffstat 1 files changed, 7 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Thu May 31 19:18:14 2018 +0200
+++ b/wamos.sql	Fri Jun 01 16:14:40 2018 +0200
@@ -58,9 +58,15 @@
        area geometry(POLYGON, 4326)
        );
 
+CREATE TABLE wamos.languages (
+       language_code varchar PRIMARY KEY
+       );
+
 CREATE TABLE wamos.user_profiles (
        username varchar PRIMARY KEY, -- TODO: check it's in pg_roles by trigger
-       country char(2) REFERENCES countries,
+       country char(2) NOT NULL REFERENCES countries,
+       language_code varchar REFERENCES languages,
+       map_extent box2d,
        email_adress varchar NOT NULL UNIQUE
        );