liquid_feedback_core
changeset 249:d4c754c4aeaa
Bugfix in core-update.v1.4.0-v2.0.0.sql: Explicitly drop NOT NULL constraint of columns winning/losing_initiative_id
author | jbe |
---|---|
date | Mon May 14 14:36:54 2012 +0200 (2012-05-14) |
parents | 05eb08f56f09 |
children | 7b8966b801e5 |
files | update/core-update.v1.4.0-v2.0.0.sql update/core-update.v2.0.8-v2.0.9.sql |
line diff
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",