Mailing List Archive

Author: autrijus
Date: Sun Nov 7 09:17:03 2004
New Revision: 1724

Added:
rt/branches/3.3-TESTING/etc/upgrade/3.3.11/
rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg
rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.mysql
Modified:
rt/ (props changed)
Log:
r10242@not: autrijus | 2004-11-06T06:59:58.274625Z
* Schema changes for Pg, SQLite, mysql and Oracle.

r10243@not: autrijus | 2004-11-06T07:00:15.865682Z
* schema updater for Pg and mysql; Oracle comes later and SQLite is nontrivial.



Added: rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg
==============================================================================
--- (empty file)
+++ rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg Sun Nov 7 09:17:03 2004
@@ -0,0 +1,9 @@
+START TRANSACTION;
+
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled INTEGER NOT NULL DEFAULT 0 ,
+
+UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0;
+ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current;
+
+COMMIT;

Added: rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.mysql
==============================================================================
--- (empty file)
+++ rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.mysql Sun Nov 7 09:17:03 2004
@@ -0,0 +1,9 @@
+START TRANSACTION;
+
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled int2 NOT NULL DEFAULT 0;
+
+UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0;
+ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current;
+
+COMMIT;
_______________________________________________
Rt-commit mailing list
Rt-commit@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-commit