liquid_feedback_core

diff update/core-update.v1.3.1-v1.4.0.sql @ 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: 5d89f5fcdcfc
     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