liquid_feedback_core
diff update/core-update.v2.0.11-v2.1.0.sql @ 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 |
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