liquid_feedback_core

diff core.sql @ 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
     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