1.1 --- a/update/core-update.v1.4.0-v2.0.0.sql	Sat May 12 18:33:56 2012 +0200
     1.2 +++ b/update/core-update.v1.4.0-v2.0.0.sql	Mon May 14 14:36:54 2012 +0200
     1.3 @@ -165,6 +165,8 @@
     1.4  
     1.5  ALTER TABLE "battle" DROP CONSTRAINT "battle_pkey";
     1.6  ALTER TABLE "battle" ALTER COLUMN "issue_id" SET NOT NULL;
     1.7 +ALTER TABLE "battle" ALTER COLUMN "winning_initiative_id" DROP NOT NULL;
     1.8 +ALTER TABLE "battle" ALTER COLUMN "losing_initiative_id" DROP NOT NULL;
     1.9  ALTER TABLE "battle" ADD CONSTRAINT "initiative_ids_not_equal" CHECK (
    1.10    "winning_initiative_id" != "losing_initiative_id" OR
    1.11    ( ("winning_initiative_id" NOTNULL AND "losing_initiative_id" ISNULL) OR

     2.1 --- a/update/core-update.v2.0.8-v2.0.9.sql	Sat May 12 18:33:56 2012 +0200
     2.2 +++ b/update/core-update.v2.0.8-v2.0.9.sql	Mon May 14 14:36:54 2012 +0200
     2.3 @@ -4,6 +4,10 @@
     2.4    SELECT * FROM (VALUES ('2.0.9', 2, 0, 9))
     2.5    AS "subquery"("string", "major", "minor", "revision");
     2.6  
     2.7 +-- Bugfix of error in update script to v2.0.0:
     2.8 +ALTER TABLE "battle" ALTER COLUMN "winning_initiative_id" DROP NOT NULL;
     2.9 +ALTER TABLE "battle" ALTER COLUMN "losing_initiative_id" DROP NOT NULL;
    2.10 +
    2.11  CREATE OR REPLACE VIEW "unit_member_count" AS
    2.12    SELECT
    2.13      "unit"."id" AS "unit_id",