# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1532610622 -7200
# Node ID 55dce2f649bc5c158e38dbf6a5aced4cb0d74746
# Parent  531d1f8a2b4b9275543237e495ca1dbe322001c6
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.

diff -r 531d1f8a2b4b -r 55dce2f649bc schema/gemma.sql
--- 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 (
diff -r 531d1f8a2b4b -r 55dce2f649bc schema/manage_users_tests.sql
--- a/schema/manage_users_tests.sql	Thu Jul 26 15:02:19 2018 +0200
+++ b/schema/manage_users_tests.sql	Thu Jul 26 15:10:22 2018 +0200
@@ -53,13 +53,6 @@
     23505, NULL,
     'No duplicate user name is allowed');
 
-SELECT throws_ok($$
-    SELECT sys_admin.create_user(
-        'waterway_user', 'test2', 'secret', 'AT', NULL, 'xxx')
-    $$,
-    23505, NULL,
-    'No duplicate e-mail address is allowed');
-
 --
 -- Role update
 --
diff -r 531d1f8a2b4b -r 55dce2f649bc schema/run_tests.sh
--- a/schema/run_tests.sh	Thu Jul 26 15:02:19 2018 +0200
+++ b/schema/run_tests.sh	Thu Jul 26 15:10:22 2018 +0200
@@ -19,7 +19,7 @@
 psql -qXv ON_ERROR_STOP= -v -d gemma_test \
     -c "DROP ROLE IF EXISTS $TEST_ROLES" \
     -f tap_tests_data.sql \
-    -c 'SELECT plan(36)' \
+    -c 'SELECT plan(35)' \
     -f auth_tests.sql \
     -f manage_users_tests.sql \
     -c 'SELECT * FROM finish()'