diff options
Diffstat (limited to 'rt/etc/upgrade/3.9.5/schema.Oracle')
-rw-r--r-- | rt/etc/upgrade/3.9.5/schema.Oracle | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/rt/etc/upgrade/3.9.5/schema.Oracle b/rt/etc/upgrade/3.9.5/schema.Oracle new file mode 100644 index 000000000..065776dfb --- /dev/null +++ b/rt/etc/upgrade/3.9.5/schema.Oracle @@ -0,0 +1,20 @@ +alter Table CustomFieldValues ADD Category varchar2(255); + +UPDATE CustomFieldValues SET Category = (SELECT Content FROM Attributes WHERE +Name = 'Category' AND ObjectType = 'RT::CustomFieldValue' +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; |