# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527862480 -7200
# Node ID d905022a48e966980f6e50457b91d8131ba7f885
# Parent  d9d01dc58f609f300db0457f632133567ccb8cff
More user attributes from APUC3.

diff -r d9d01dc58f60 -r d905022a48e9 wamos.sql
--- 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
        );