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