# HG changeset patch
# User jbe
# Date 1505923662 -7200
# Node ID 71f431fb78d48cff5e179de50c62bd94afe081d6
# Parent  25b551e53da2639f1d09a9861e003e2ee3833b25
Bugfix in "member_useterms" table: allow multiple entries per member

diff -r 25b551e53da2 -r 71f431fb78d4 core.sql
--- a/core.sql	Wed Sep 20 17:57:21 2017 +0200
+++ b/core.sql	Wed Sep 20 18:07:42 2017 +0200
@@ -247,7 +247,8 @@
 
 
 CREATE TABLE "member_useterms" (
-        "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "id"                    SERIAL8         PRIMARY KEY,
+        "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "contract_identifier"   TEXT            NOT NULL );
 
diff -r 25b551e53da2 -r 71f431fb78d4 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 17:57:21 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 18:07:42 2017 +0200
@@ -80,7 +80,8 @@
 
 
 CREATE TABLE "member_useterms" (
-        "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "id"                    SERIAL8         PRIMARY KEY,
+        "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "contract_identifier"   TEXT            NOT NULL );