liquid_feedback_core

diff update/core-update.v4.2.0-v4.2.1.sql @ 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
     1.1 --- a/update/core-update.v4.2.0-v4.2.1.sql	Mon Oct 05 16:18:17 2020 +0200
     1.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql	Fri Nov 27 15:45:31 2020 +0100
     1.3 @@ -47,6 +47,8 @@
     1.4  COMMENT ON COLUMN "delegating_voter"."ownweight" IS 'Own voting weight of member, disregarding delegations';
     1.5  COMMENT ON COLUMN "delegating_voter"."weight"    IS 'Intermediate voting weight considering incoming delegations';
     1.6  
     1.7 +ALTER TABLE "posting" ADD FOREIGN KEY ("issue_id", "initiative_id") REFERENCES "initiative" ("issue_id", "id");
     1.8 +
     1.9  DROP VIEW "issue_delegation";
    1.10  CREATE VIEW "issue_delegation" AS
    1.11    SELECT DISTINCT ON ("issue"."id", "delegation"."truster_id")