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;