# HG changeset patch
# User jbe
# Date 1336999014 -7200
# Node ID d4c754c4aeaa5cf3e78704d753e1afbf2dbaf089
# Parent  05eb08f56f09cbb014e8c0d5494d5c2cdcddfe1a
Bugfix in core-update.v1.4.0-v2.0.0.sql: Explicitly drop NOT NULL constraint of columns winning/losing_initiative_id

diff -r 05eb08f56f09 -r d4c754c4aeaa update/core-update.v1.4.0-v2.0.0.sql
--- a/update/core-update.v1.4.0-v2.0.0.sql	Sat May 12 18:33:56 2012 +0200
+++ b/update/core-update.v1.4.0-v2.0.0.sql	Mon May 14 14:36:54 2012 +0200
@@ -165,6 +165,8 @@
 
 ALTER TABLE "battle" DROP CONSTRAINT "battle_pkey";
 ALTER TABLE "battle" ALTER COLUMN "issue_id" SET NOT NULL;
+ALTER TABLE "battle" ALTER COLUMN "winning_initiative_id" DROP NOT NULL;
+ALTER TABLE "battle" ALTER COLUMN "losing_initiative_id" DROP NOT NULL;
 ALTER TABLE "battle" ADD CONSTRAINT "initiative_ids_not_equal" CHECK (
   "winning_initiative_id" != "losing_initiative_id" OR
   ( ("winning_initiative_id" NOTNULL AND "losing_initiative_id" ISNULL) OR
diff -r 05eb08f56f09 -r d4c754c4aeaa update/core-update.v2.0.8-v2.0.9.sql
--- a/update/core-update.v2.0.8-v2.0.9.sql	Sat May 12 18:33:56 2012 +0200
+++ b/update/core-update.v2.0.8-v2.0.9.sql	Mon May 14 14:36:54 2012 +0200
@@ -4,6 +4,10 @@
   SELECT * FROM (VALUES ('2.0.9', 2, 0, 9))
   AS "subquery"("string", "major", "minor", "revision");
 
+-- Bugfix of error in update script to v2.0.0:
+ALTER TABLE "battle" ALTER COLUMN "winning_initiative_id" DROP NOT NULL;
+ALTER TABLE "battle" ALTER COLUMN "losing_initiative_id" DROP NOT NULL;
+
 CREATE OR REPLACE VIEW "unit_member_count" AS
   SELECT
     "unit"."id" AS "unit_id",