Mercurial > gemma
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 );