# HG changeset patch
# User jbe
# Date 1307559216 -7200
# Node ID 1024224df943a2bd1967d6bf1cae43d2d4214c3f
# Parent  fb2394116b39283d3b4031e6f9cf982c90cd3b27
Update script to v1.5.0: Drop contraints on table "initiative" before changing columns

diff -r fb2394116b39 -r 1024224df943 update/core-update.v1.4.0-v1.5.0.sql
--- a/update/core-update.v1.4.0-v1.5.0.sql	Wed Jun 08 20:52:06 2011 +0200
+++ b/update/core-update.v1.4.0-v1.5.0.sql	Wed Jun 08 20:53:36 2011 +0200
@@ -83,6 +83,10 @@
 
 DROP VIEW "battle_view";
 
+ALTER TABLE "initiative" DROP CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results";
+ALTER TABLE "initiative" DROP CONSTRAINT "all_or_none_of_positive_votes_negative_votes_and_agreed_must_be_null";
+ALTER TABLE "initiative" DROP CONSTRAINT "non_agreed_initiatives_cant_get_a_rank";
+
 ALTER TABLE "initiative" DROP COLUMN "agreed";
 ALTER TABLE "initiative" ADD COLUMN "direct_majority"        BOOLEAN;
 ALTER TABLE "initiative" ADD COLUMN "indirect_majority"      BOOLEAN;
@@ -94,10 +98,6 @@
 ALTER TABLE "initiative" ADD COLUMN "eligible"               BOOLEAN;
 ALTER TABLE "initiative" ADD COLUMN "winner"                 BOOLEAN;
 
-ALTER TABLE "initiative" DROP CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results";
-ALTER TABLE "initiative" DROP CONSTRAINT  "all_or_none_of_positive_votes_negative_votes_and_agreed_must_be_null";
-ALTER TABLE "initiative" DROP CONSTRAINT "non_agreed_initiatives_cant_get_a_rank";
-
 ALTER TABLE "initiative" ADD CONSTRAINT "non_admitted_initiatives_cant_contain_voting_results" CHECK (
   ( "admitted" NOTNULL AND "admitted" = TRUE ) OR
   ( "positive_votes" ISNULL AND "negative_votes" ISNULL AND