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