diff options
Diffstat (limited to 'rt/etc/upgrade/3.9.5/schema.Oracle')
-rw-r--r-- | rt/etc/upgrade/3.9.5/schema.Oracle | 30 |
1 files changed, 18 insertions, 12 deletions
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 +); |