Mercurial > gemma
diff 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 |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Jul 26 15:02:19 2018 +0200 +++ b/schema/gemma.sql Thu Jul 26 15:10:22 2018 +0200 @@ -137,7 +137,7 @@ username varchar PRIMARY KEY, country char(2) NOT NULL REFERENCES responsibility_areas, map_extent box2d NOT NULL, - email_address varchar NOT NULL UNIQUE + email_address varchar NOT NULL ) CREATE TABLE templates (