diff options
Diffstat (limited to 'rt/etc/upgrade/3.9.5/schema.Pg')
-rw-r--r-- | rt/etc/upgrade/3.9.5/schema.Pg | 27 |
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; |