# HG changeset patch
# User jbe
# Date 1319482695 -7200
# Node ID eee75cff3e5a2e2a98e9262b35db07597714c787
# Parent  b8fa47ee5d82c000dc44cbaa5df83f67c5af9518
Bugfix in old update scripts from v1.3.1 to v1.4.0: Set default of "issue"."state" to 'admission'

diff -r b8fa47ee5d82 -r eee75cff3e5a update/core-update.v1.3.1-v1.4.0.sql
--- a/update/core-update.v1.3.1-v1.4.0.sql	Sat Oct 08 21:06:24 2011 +0200
+++ b/update/core-update.v1.3.1-v1.4.0.sql	Mon Oct 24 20:58:15 2011 +0200
@@ -101,7 +101,8 @@
 
 COMMENT ON TYPE "issue_state" IS 'State of issues';
 
-ALTER TABLE "issue" ADD "state" "issue_state";
+ALTER TABLE "issue" ADD "state" "issue_state" DEFAULT NULL;
+ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';
 
 -- NOTE: Filling new column with values is done after this transaction (see below)
 
diff -r b8fa47ee5d82 -r eee75cff3e5a update/core-update.v1.3.1-v1.4.0_rc1.sql
--- a/update/core-update.v1.3.1-v1.4.0_rc1.sql	Sat Oct 08 21:06:24 2011 +0200
+++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql	Mon Oct 24 20:58:15 2011 +0200
@@ -101,7 +101,8 @@
 
 COMMENT ON TYPE "issue_state" IS 'State of issues';
 
-ALTER TABLE "issue" ADD "state" "issue_state";
+ALTER TABLE "issue" ADD "state" "issue_state" DEFAULT NULL;
+ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';
 
 -- NOTE: Filling new column with values is done after this transaction (see below)
 
diff -r b8fa47ee5d82 -r eee75cff3e5a update/core-update.v2.0.0-v2.0.1.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v2.0.0-v2.0.1.sql	Mon Oct 24 20:58:15 2011 +0200
@@ -0,0 +1,7 @@
+BEGIN;
+
+-- work in progress
+
+ALTER TABLE "issue" ALTER "state" SET DEFAULT 'admission';  -- fixes wrong update script from v1.3.1 to v1.4.0
+
+COMMIT;