liquid_feedback_core

changeset 204:b8fa47ee5d82

Added column "draft_id" to table "direct_supporter_snapshot"
author jbe
date Sat Oct 08 21:06:24 2011 +0200 (2011-10-08)
parents 976e7dafe641
children eee75cff3e5a 6fce4f08157b
files core.sql
line diff
     1.1 --- a/core.sql	Sat Oct 08 20:48:30 2011 +0200
     1.2 +++ b/core.sql	Sat Oct 08 21:06:24 2011 +0200
     1.3 @@ -946,9 +946,11 @@
     1.4          "initiative_id"         INT4,
     1.5          "event"                 "snapshot_event",
     1.6          "member_id"             INT4            REFERENCES "member" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
     1.7 +        "draft_id"              INT8            NOT NULL,
     1.8          "informed"              BOOLEAN         NOT NULL,
     1.9          "satisfied"             BOOLEAN         NOT NULL,
    1.10          FOREIGN KEY ("issue_id", "initiative_id") REFERENCES "initiative" ("issue_id", "id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.11 +        FOREIGN KEY ("initiative_id", "draft_id") REFERENCES "draft" ("initiative_id", "id") ON DELETE NO ACTION ON UPDATE CASCADE,
    1.12          FOREIGN KEY ("issue_id", "event", "member_id") REFERENCES "direct_interest_snapshot" ("issue_id", "event", "member_id") ON DELETE CASCADE ON UPDATE CASCADE );
    1.13  CREATE INDEX "direct_supporter_snapshot_member_id_idx" ON "direct_supporter_snapshot" ("member_id");
    1.14  
    1.15 @@ -2991,12 +2993,13 @@
    1.16        END LOOP;
    1.17        INSERT INTO "direct_supporter_snapshot"
    1.18          ( "issue_id", "initiative_id", "event", "member_id",
    1.19 -          "informed", "satisfied" )
    1.20 +          "draft_id", "informed", "satisfied" )
    1.21          SELECT
    1.22            "issue_id_p"            AS "issue_id",
    1.23            "initiative"."id"       AS "initiative_id",
    1.24            'periodic'              AS "event",
    1.25            "supporter"."member_id" AS "member_id",
    1.26 +          "supporter"."draft_id"  AS "draft_id",
    1.27            "supporter"."draft_id" = "current_draft"."id" AS "informed",
    1.28            NOT EXISTS (
    1.29              SELECT NULL FROM "critical_opinion"

Impressum / About Us