[prev in list] [next in list] [prev in thread] [next in thread] 

List:       rt-commit
Subject:    [Rt-commit] [svn] r1934 - in rt/branches/3.3-TESTING: .
From:       jesse () pallas ! eruditorum ! org
Date:       2004-11-24 16:15:39
Message-ID: 20041124161539.DE22084C263 () pallas ! eruditorum ! org
[Download RAW message or body]

Author: jesse
Date: Wed Nov 24 11:15:39 2004
New Revision: 1934

Modified:
   rt/branches/3.3-TESTING/   (props changed)
   rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg
Log:
 r9348@tinbook:  jesse | 2004-11-24T16:15:50.210159Z
 3.3.11 upgrade schema for postgres depended on features not supported by postgres. \
fixed. -- Mathieu Sauve-Frankel


Modified: rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg
==============================================================================
--- rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg	(original)
+++ rt/branches/3.3-TESTING/etc/upgrade/3.3.11/schema.Pg	Wed Nov 24 11:15:39 2004
@@ -1,7 +1,11 @@
 START TRANSACTION;
 
-ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0;
-ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled INTEGER NOT NULL DEFAULT 0 ,
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER;
+ALTER TABLE ObjectCustomFieldValues ALTER COLUMN SortOrder SET DEFAULT 0;
+ALTER TABLE ObjectCustomFieldValues ALTER COLUMN SortOrder SET NOT NULL;
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled INTEGER;
+ALTER TABLE ObjectCustomFieldValues ALTER COLUMN Disabled SET DEFAULT 0;
+ALTER TABLE ObjectCustomFieldValues ALTER COLUMN Disabled SET NOT NULL;
 
 UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0;
 ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current;
_______________________________________________
Rt-commit mailing list
Rt-commit@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-commit


[prev in list] [next in list] [prev in thread] [next in thread]