liquid_feedback_core
diff update/core-update.v1.4.0-v2.0.0.sql @ 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 | dc644643db99 |
children |
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