Mercurial > gemma

comparison schema/gemma.sql @ 209:9585982180ab

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove obsolete TODO comment Users can write in this table only through user management functions which ensure consistency.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 16:14:36 +0200
parents 5dc8e734487a
children e7826710d9c4
comparison
equal deleted inserted replaced
208:87f21b9a1292 209:9585982180ab
132 area geometry(MULTIPOLYGON, 4326) 132 area geometry(MULTIPOLYGON, 4326)
133 --XXX: Should be geography (elsewhere too) 133 --XXX: Should be geography (elsewhere too)
134 ) 134 )
135 135
136 CREATE TABLE user_profiles ( 136 CREATE TABLE user_profiles (
137 username varchar PRIMARY KEY,-- TODO: check it's in pg_roles by trigger 137 username varchar PRIMARY KEY,
138 country char(2) NOT NULL REFERENCES countries, 138 country char(2) NOT NULL REFERENCES countries,
139 map_extent box2d, 139 map_extent box2d,
140 email_adress varchar NOT NULL UNIQUE 140 email_adress varchar NOT NULL UNIQUE
141 ) 141 )
142 142