X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fupgrade%2F3.9.5%2Fschema.Pg;h=cd919011396c33003db8a9da1f15c8a9505192bf;hb=958c9aaf69a633eb6acdf81608c35963681e3a18;hp=cea2c44102fb6804f6cd85cc0e7e747a60141fd6;hpb=f3c4966ed1f6ec3db7accd6dcdd3a5a3821d72a7;p=freeside.git

diff --git a/rt/etc/upgrade/3.9.5/schema.Pg b/rt/etc/upgrade/3.9.5/schema.Pg
index cea2c4410..cd9190113 100644
--- a/rt/etc/upgrade/3.9.5/schema.Pg
+++ b/rt/etc/upgrade/3.9.5/schema.Pg
@@ -6,15 +6,18 @@ AND CustomFieldValues.id = Attributes.ObjectId);
 
 DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';
 
-ALTER TABLE Groups ADD COLUMN Creator integer NOT NULL DEFAULT 0;
-ALTER TABLE Groups ADD COLUMN Created TIMESTAMP NULL;
-ALTER TABLE Groups ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0;
-ALTER TABLE Groups ADD COLUMN LastUpdated TIMESTAMP NULL;
-ALTER TABLE GroupMembers ADD COLUMN Creator integer NOT NULL DEFAULT 0;
-ALTER TABLE GroupMembers ADD COLUMN Created TIMESTAMP NULL;
-ALTER TABLE GroupMembers ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0;
-ALTER TABLE GroupMembers ADD COLUMN LastUpdated TIMESTAMP NULL;
-ALTER TABLE ACL ADD COLUMN Creator integer NOT NULL DEFAULT 0;
-ALTER TABLE ACL ADD COLUMN Created TIMESTAMP NULL;
-ALTER TABLE ACL ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0;
-ALTER TABLE ACL ADD COLUMN LastUpdated TIMESTAMP NULL;
+ALTER TABLE Groups
+    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
+    ADD COLUMN Created TIMESTAMP NULL,
+    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
+    ADD COLUMN LastUpdated TIMESTAMP NULL;
+ALTER TABLE GroupMembers
+    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
+    ADD COLUMN Created TIMESTAMP NULL,
+    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
+    ADD COLUMN LastUpdated TIMESTAMP NULL;
+ALTER TABLE ACL
+    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
+    ADD COLUMN Created TIMESTAMP NULL,
+    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
+    ADD COLUMN LastUpdated TIMESTAMP NULL;