liquid_feedback_core
diff update/core-update.v1.4.0-v1.5.0.sql @ 180:1024224df943
Update script to v1.5.0: Drop contraints on table "initiative" before changing columns
author | jbe |
---|---|
date | Wed Jun 08 20:53:36 2011 +0200 (2011-06-08) |
parents | fb2394116b39 |
children | 4c03ef70dd92 |
line diff
1.1 --- a/update/core-update.v1.4.0-v1.5.0.sql Wed Jun 08 20:52:06 2011 +0200 1.2 +++ b/update/core-update.v1.4.0-v1.5.0.sql Wed Jun 08 20:53:36 2011 +0200 1.3 @@ -83,6 +83,10 @@ 1.4 1.5 DROP VIEW "battle_view"; 1.6 1.7 +ALTER TABLE "initiative" DROP CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results"; 1.8 +ALTER TABLE "initiative" DROP CONSTRAINT "all_or_none_of_positive_votes_negative_votes_and_agreed_must_be_null"; 1.9 +ALTER TABLE "initiative" DROP CONSTRAINT "non_agreed_initiatives_cant_get_a_rank"; 1.10 + 1.11 ALTER TABLE "initiative" DROP COLUMN "agreed"; 1.12 ALTER TABLE "initiative" ADD COLUMN "direct_majority" BOOLEAN; 1.13 ALTER TABLE "initiative" ADD COLUMN "indirect_majority" BOOLEAN; 1.14 @@ -94,10 +98,6 @@ 1.15 ALTER TABLE "initiative" ADD COLUMN "eligible" BOOLEAN; 1.16 ALTER TABLE "initiative" ADD COLUMN "winner" BOOLEAN; 1.17 1.18 -ALTER TABLE "initiative" DROP CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results"; 1.19 -ALTER TABLE "initiative" DROP CONSTRAINT "all_or_none_of_positive_votes_negative_votes_and_agreed_must_be_null"; 1.20 -ALTER TABLE "initiative" DROP CONSTRAINT "non_agreed_initiatives_cant_get_a_rank"; 1.21 - 1.22 ALTER TABLE "initiative" ADD CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results" CHECK ( 1.23 ( "admitted" NOTNULL AND "admitted" = TRUE ) OR 1.24 ( "positive_votes" ISNULL AND "negative_votes" ISNULL AND