Mercurial > gemma
comparison schema/gemma.sql @ 234:55dce2f649bc
Allow using the same email-address for multiple users
This can be useful at least in testing scenarios, where one
person wants to have multiple accounts with different roles
and there is no other reason to enforce uniqueness.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 26 Jul 2018 15:10:22 +0200 |
parents | 531d1f8a2b4b |
children | 72062ca52746 |
comparison
equal
deleted
inserted
replaced
233:531d1f8a2b4b | 234:55dce2f649bc |
---|---|
135 | 135 |
136 CREATE TABLE user_profiles ( | 136 CREATE TABLE user_profiles ( |
137 username varchar PRIMARY KEY, | 137 username varchar PRIMARY KEY, |
138 country char(2) NOT NULL REFERENCES responsibility_areas, | 138 country char(2) NOT NULL REFERENCES responsibility_areas, |
139 map_extent box2d NOT NULL, | 139 map_extent box2d NOT NULL, |
140 email_address varchar NOT NULL UNIQUE | 140 email_address varchar NOT NULL |
141 ) | 141 ) |
142 | 142 |
143 CREATE TABLE templates ( | 143 CREATE TABLE templates ( |
144 template_name varchar PRIMARY KEY, | 144 template_name varchar PRIMARY KEY, |
145 template_data bytea NOT NULL, | 145 template_data bytea NOT NULL, |