liquid_feedback_core

changeset 461:4c3522ba2552

Changed reference to "member_id" in two tables to INT4 (was INT8)
author jbe
date Thu Mar 17 03:12:19 2016 +0100 (2016-03-17)
parents 6d4e51332251
children e9525f069607
files core.sql
line diff
     1.1 --- a/core.sql	Wed Mar 16 00:29:12 2016 +0100
     1.2 +++ b/core.sql	Thu Mar 17 03:12:19 2016 +0100
     1.3 @@ -219,7 +219,7 @@
     1.4  
     1.5  CREATE TABLE "rendered_member_statement" (
     1.6          PRIMARY KEY ("member_id", "format"),
     1.7 -        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.8 +        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.9          "format"                TEXT,
    1.10          "content"               TEXT            NOT NULL );
    1.11  
    1.12 @@ -323,7 +323,7 @@
    1.13          "ident"                 TEXT            PRIMARY KEY,
    1.14          "additional_secret"     TEXT,
    1.15          "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
    1.16 -        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
    1.17 +        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE SET NULL,
    1.18          "authority"             TEXT,
    1.19          "authority_uid"         TEXT,
    1.20          "authority_login"       TEXT,

Impressum / About Us