liquid_feedback_core
changeset 553:85f25c413238
Bugfix in update script to version 4.0.0: set new "policy_id" column in "event" table
author | jbe |
---|---|
date | Sat Sep 16 21:16:16 2017 +0200 (2017-09-16) |
parents | a676d305502f |
children | 3e7ad7233404 |
files | update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Sat Sep 16 19:58:27 2017 +0200 1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Sat Sep 16 21:16:16 2017 +0200 1.3 @@ -720,7 +720,10 @@ 1.4 ALTER TABLE "event" DROP CONSTRAINT "null_constr_for_initiative_creation_or_revocation_or_new_draft"; 1.5 ALTER TABLE "event" DROP CONSTRAINT "null_constr_for_suggestion_creation"; 1.6 1.7 -UPDATE "event" SET "unit_id" = "area"."unit_id", "area_id" = "issue"."area_id" 1.8 +UPDATE "event" SET 1.9 + "unit_id" = "area"."unit_id", 1.10 + "area_id" = "issue"."area_id", 1.11 + "policy_id" = "issue"."policy_id" 1.12 FROM "issue", "area" 1.13 WHERE "issue"."id" = "event"."issue_id" AND "area"."id" = "issue"."area_id"; 1.14