Mercurial > gemma

comparison wamos.sql @ 84:d905022a48e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
More user attributes from APUC3.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 16:14:40 +0200
parents d9d01dc58f60
children 1a640da943b6
comparison
equal deleted inserted replaced
83:d9d01dc58f60 84:d905022a48e9
56 CREATE TABLE wamos.responsibility_areas ( 56 CREATE TABLE wamos.responsibility_areas (
57 country char(2) PRIMARY KEY REFERENCES countries, 57 country char(2) PRIMARY KEY REFERENCES countries,
58 area geometry(POLYGON, 4326) 58 area geometry(POLYGON, 4326)
59 ); 59 );
60 60
61 CREATE TABLE wamos.languages (
62 language_code varchar PRIMARY KEY
63 );
64
61 CREATE TABLE wamos.user_profiles ( 65 CREATE TABLE wamos.user_profiles (
62 username varchar PRIMARY KEY, -- TODO: check it's in pg_roles by trigger 66 username varchar PRIMARY KEY, -- TODO: check it's in pg_roles by trigger
63 country char(2) REFERENCES countries, 67 country char(2) NOT NULL REFERENCES countries,
68 language_code varchar REFERENCES languages,
69 map_extent box2d,
64 email_adress varchar NOT NULL UNIQUE 70 email_adress varchar NOT NULL UNIQUE
65 ); 71 );
66 72
67 CREATE TABLE wamos.templates ( 73 CREATE TABLE wamos.templates (
68 id int PRIMARY KEY, 74 id int PRIMARY KEY,