liquid_feedback_core
changeset 618:5b3b20f1278d
Added missing referential integrity constraint on "posting" table
author | jbe |
---|---|
date | Fri Nov 27 15:45:31 2020 +0100 (2020-11-27) |
parents | 8e9d0878b5dc |
children | 63092784fe9d |
files | core.sql update/core-update.v4.2.0-v4.2.1.sql |
line diff
1.1 --- a/core.sql Mon Oct 05 16:18:17 2020 +0200 1.2 +++ b/core.sql Fri Nov 27 15:45:31 2020 +0100 1.3 @@ -1386,6 +1386,7 @@ 1.4 FOREIGN KEY ("area_id", "issue_id") REFERENCES "issue" ("area_id", "id") ON DELETE CASCADE ON UPDATE CASCADE, 1.5 FOREIGN KEY ("policy_id", "issue_id") REFERENCES "issue" ("policy_id", "id") ON DELETE CASCADE ON UPDATE CASCADE, 1.6 "initiative_id" INT4, 1.7 + FOREIGN KEY ("issue_id", "initiative_id") REFERENCES "initiative" ("issue_id", "id"), 1.8 "suggestion_id" INT8, 1.9 -- NOTE: no referential integrity for suggestions because those are 1.10 -- actually deleted
2.1 --- a/update/core-update.v4.2.0-v4.2.1.sql Mon Oct 05 16:18:17 2020 +0200 2.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql Fri Nov 27 15:45:31 2020 +0100 2.3 @@ -47,6 +47,8 @@ 2.4 COMMENT ON COLUMN "delegating_voter"."ownweight" IS 'Own voting weight of member, disregarding delegations'; 2.5 COMMENT ON COLUMN "delegating_voter"."weight" IS 'Intermediate voting weight considering incoming delegations'; 2.6 2.7 +ALTER TABLE "posting" ADD FOREIGN KEY ("issue_id", "initiative_id") REFERENCES "initiative" ("issue_id", "id"); 2.8 + 2.9 DROP VIEW "issue_delegation"; 2.10 CREATE VIEW "issue_delegation" AS 2.11 SELECT DISTINCT ON ("issue"."id", "delegation"."truster_id")