Mercurial > gemma

comparison schema/gemma.sql @ 184:bc7829defa99

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove language code from user profiles The intention of this field was to provide a per user language setting, but it is currently foreseen to use client side browser settings for this.
author Tom Gottfried <tom@intevation.de>
date Thu, 19 Jul 2018 16:32:27 +0200
parents 4df4e4bf480e
children 5dc8e734487a
comparison
equal deleted inserted replaced
183:f3a09fc9c1eb 184:bc7829defa99
69 ); 69 );
70 70
71 CREATE TABLE gemma.user_profiles ( 71 CREATE TABLE gemma.user_profiles (
72 username varchar PRIMARY KEY, -- TODO: check it's in pg_roles by trigger 72 username varchar PRIMARY KEY, -- TODO: check it's in pg_roles by trigger
73 country char(2) NOT NULL REFERENCES countries, 73 country char(2) NOT NULL REFERENCES countries,
74 language_code varchar REFERENCES language_codes,
75 map_extent box2d, 74 map_extent box2d,
76 email_adress varchar NOT NULL UNIQUE 75 email_adress varchar NOT NULL UNIQUE
77 ); 76 );
78 77
79 CREATE TABLE gemma.templates ( 78 CREATE TABLE gemma.templates (