liquid_feedback_core

changeset 553:85f25c413238

find changesets by author, revision, files, or words in the commit message
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

Impressum / About Us