liquid_feedback_core

changeset 205:eee75cff3e5a

Bugfix in old update scripts from v1.3.1 to v1.4.0: Set default of "issue"."state" to 'admission'
author jbe
date Mon Oct 24 20:58:15 2011 +0200 (2011-10-24)
parents b8fa47ee5d82
children e14cb823f107
files update/core-update.v1.3.1-v1.4.0.sql update/core-update.v1.3.1-v1.4.0_rc1.sql update/core-update.v2.0.0-v2.0.1.sql
line diff
     1.1 --- a/update/core-update.v1.3.1-v1.4.0.sql	Sat Oct 08 21:06:24 2011 +0200
     1.2 +++ b/update/core-update.v1.3.1-v1.4.0.sql	Mon Oct 24 20:58:15 2011 +0200
     1.3 @@ -101,7 +101,8 @@
     1.4  
     1.5  COMMENT ON TYPE "issue_state" IS 'State of issues';
     1.6  
     1.7 -ALTER TABLE "issue" ADD "state" "issue_state";
     1.8 +ALTER TABLE "issue" ADD "state" "issue_state" DEFAULT NULL;
     1.9 +ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';
    1.10  
    1.11  -- NOTE: Filling new column with values is done after this transaction (see below)
    1.12  
     2.1 --- a/update/core-update.v1.3.1-v1.4.0_rc1.sql	Sat Oct 08 21:06:24 2011 +0200
     2.2 +++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql	Mon Oct 24 20:58:15 2011 +0200
     2.3 @@ -101,7 +101,8 @@
     2.4  
     2.5  COMMENT ON TYPE "issue_state" IS 'State of issues';
     2.6  
     2.7 -ALTER TABLE "issue" ADD "state" "issue_state";
     2.8 +ALTER TABLE "issue" ADD "state" "issue_state" DEFAULT NULL;
     2.9 +ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';
    2.10  
    2.11  -- NOTE: Filling new column with values is done after this transaction (see below)
    2.12  
     3.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     3.2 +++ b/update/core-update.v2.0.0-v2.0.1.sql	Mon Oct 24 20:58:15 2011 +0200
     3.3 @@ -0,0 +1,7 @@
     3.4 +BEGIN;
     3.5 +
     3.6 +-- work in progress
     3.7 +
     3.8 +ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';  -- fixes wrong update script from v1.3.1 to v1.4.0
     3.9 +
    3.10 +COMMIT;

Impressum / About Us