liquid_feedback_core

changeset 559:71f431fb78d4

Bugfix in "member_useterms" table: allow multiple entries per member
author jbe
date Wed Sep 20 18:07:42 2017 +0200 (2017-09-20)
parents 25b551e53da2
children 318827ecd041
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Wed Sep 20 17:57:21 2017 +0200
     1.2 +++ b/core.sql	Wed Sep 20 18:07:42 2017 +0200
     1.3 @@ -247,7 +247,8 @@
     1.4  
     1.5  
     1.6  CREATE TABLE "member_useterms" (
     1.7 -        "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.8 +        "id"                    SERIAL8         PRIMARY KEY,
     1.9 +        "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.10          "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
    1.11          "contract_identifier"   TEXT            NOT NULL );
    1.12  
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 17:57:21 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 18:07:42 2017 +0200
     2.3 @@ -80,7 +80,8 @@
     2.4  
     2.5  
     2.6  CREATE TABLE "member_useterms" (
     2.7 -        "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     2.8 +        "id"                    SERIAL8         PRIMARY KEY,
     2.9 +        "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    2.10          "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
    2.11          "contract_identifier"   TEXT            NOT NULL );
    2.12  

Impressum / About Us