X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fupgrade%2F3.9.5%2Fschema.Oracle;h=bcf5b1f08e29ecde18555d786e65528d56249b73;hb=1c538bfabc2cd31f27067505f0c3d1a46cba6ef0;hp=065776dfbb7fd6e6fb334798b040f209b86156e5;hpb=85e677b86fc37c54e6de2b06340351a28f5a5916;p=freeside.git

diff --git a/rt/etc/upgrade/3.9.5/schema.Oracle b/rt/etc/upgrade/3.9.5/schema.Oracle
index 065776dfb..bcf5b1f08 100644
--- a/rt/etc/upgrade/3.9.5/schema.Oracle
+++ b/rt/etc/upgrade/3.9.5/schema.Oracle
@@ -6,15 +6,21 @@ AND CustomFieldValues.id = Attributes.ObjectId);
 
 DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';
 
-ALTER TABLE Groups ADD Creator NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE Groups ADD Created DATE;
-ALTER TABLE Groups ADD LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE Groups ADD LastUpdated DATE;
-ALTER TABLE GroupMembers ADD Creator NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE GroupMembers ADD Created DATE;
-ALTER TABLE GroupMembers ADD LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE GroupMembers ADD LastUpdated DATE;
-ALTER TABLE ACL ADD Creator NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE ACL ADD Created DATE;
-ALTER TABLE ACL ADD LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL;
-ALTER TABLE ACL ADD LastUpdated DATE;
+ALTER TABLE Groups ADD(
+     Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
+     Created DATE,
+     LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
+     LastUpdated DATE
+);
+ALTER TABLE GroupMembers ADD(
+    Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
+    Created DATE,
+    LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
+    LastUpdated DATE
+);
+ALTER TABLE ACL ADD(
+    Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
+    Created DATE,
+    LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
+    LastUpdated DATE
+);