# HG changeset patch
# User jbe
# Date 1505589376 -7200
# Node ID 85f25c413238c1ea75f8c5993a510b0377eeb483
# Parent  a676d305502fe6fb2878c021ef704651cf9fcd51
Bugfix in update script to version 4.0.0: set new "policy_id" column in "event" table

diff -r a676d305502f -r 85f25c413238 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Sat Sep 16 19:58:27 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Sat Sep 16 21:16:16 2017 +0200
@@ -720,7 +720,10 @@
 ALTER TABLE "event" DROP CONSTRAINT "null_constr_for_initiative_creation_or_revocation_or_new_draft";
 ALTER TABLE "event" DROP CONSTRAINT "null_constr_for_suggestion_creation";
 
-UPDATE "event" SET "unit_id" = "area"."unit_id", "area_id" = "issue"."area_id"
+UPDATE "event" SET
+  "unit_id" = "area"."unit_id",
+  "area_id" = "issue"."area_id",
+  "policy_id" = "issue"."policy_id"
   FROM "issue", "area"
   WHERE "issue"."id" = "event"."issue_id" AND "area"."id" = "issue"."area_id";