liquid_feedback_core

changeset 294:703986b6de29

Correctly transform existing "contingent" entries when updating to v2.1.0
author jbe
date Sun Aug 26 21:04:20 2012 +0200 (2012-08-26)
parents 9ab561a91035
children 779ba19a07df
files update/core-update.v2.0.11-v2.1.0.sql
line diff
     1.1 --- a/update/core-update.v2.0.11-v2.1.0.sql	Sat Aug 25 20:55:33 2012 +0200
     1.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql	Sun Aug 26 21:04:20 2012 +0200
     1.3 @@ -59,8 +59,9 @@
     1.4  DROP VIEW "member_contingent";
     1.5  ALTER TABLE "contingent" DROP CONSTRAINT "contingent_pkey";
     1.6  ALTER TABLE "contingent" ALTER COLUMN "time_frame" DROP NOT NULL;
     1.7 -ALTER TABLE "contingent" ADD COLUMN "polling" BOOLEAN;
     1.8 +ALTER TABLE "contingent" ADD COLUMN "polling" BOOLEAN DEFAULT FALSE;
     1.9  ALTER TABLE "contingent" ADD PRIMARY KEY ("polling", "time_frame");
    1.10 +ALTER TABLE "contingent" ALTER COLUMN "polling" DROP DEFAULT;
    1.11  COMMENT ON COLUMN "contingent"."polling" IS 'Determines if settings are for creating initiatives and new drafts of initiatives with "polling" flag set';
    1.12  
    1.13  CREATE VIEW "member_contingent" AS

Impressum / About Us