liquid_feedback_core

diff update/core-update.v1.4.0-v2.0.0.sql @ 249:d4c754c4aeaa

find changesets by author, revision, files, or words in the commit message
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

Impressum / About Us