liquid_feedback_core

diff update/core-update.v2.0.8-v2.0.9.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: 05eb08f56f09
children: 7b8966b801e5
     1.1 --- a/update/core-update.v2.0.8-v2.0.9.sql	Sat May 12 18:33:56 2012 +0200
     1.2 +++ b/update/core-update.v2.0.8-v2.0.9.sql	Mon May 14 14:36:54 2012 +0200
     1.3 @@ -4,6 +4,10 @@
     1.4    SELECT * FROM (VALUES ('2.0.9', 2, 0, 9))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 +-- Bugfix of error in update script to v2.0.0:
     1.8 +ALTER TABLE "battle" ALTER COLUMN "winning_initiative_id" DROP NOT NULL;
     1.9 +ALTER TABLE "battle" ALTER COLUMN "losing_initiative_id" DROP NOT NULL;
    1.10 +
    1.11  CREATE OR REPLACE VIEW "unit_member_count" AS
    1.12    SELECT
    1.13      "unit"."id" AS "unit_id",