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"