summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.9.5/schema.Pg
diff options
context:
space:
mode:
Diffstat (limited to 'rt/etc/upgrade/3.9.5/schema.Pg')
-rw-r--r--rt/etc/upgrade/3.9.5/schema.Pg27
1 files changed, 15 insertions, 12 deletions
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;