diff options
Diffstat (limited to 'rt/etc/upgrade/3.3.0/schema.Oracle')
| -rw-r--r-- | rt/etc/upgrade/3.3.0/schema.Oracle | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/rt/etc/upgrade/3.3.0/schema.Oracle b/rt/etc/upgrade/3.3.0/schema.Oracle index f81feeb79..9d77a12c9 100644 --- a/rt/etc/upgrade/3.3.0/schema.Oracle +++ b/rt/etc/upgrade/3.3.0/schema.Oracle @@ -7,7 +7,6 @@ ALTER TABLE Transactions ADD OldReference NUMBER(11,0) NULL; ALTER TABLE Transactions ADD NewReference NUMBER(11,0) NULL; DROP INDEX transactions1; ALTER TABLE Transactions rename column Ticket to ObjectId; -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); ALTER TABLE TicketCustomFieldValues rename to ObjectCustomFieldValues; ALTER TABLE ObjectCustomFieldValues rename column Ticket to ObjectId; @@ -24,12 +23,6 @@ ALTER TABLE ObjectCustomFieldValues ADD ContentEncoding VARCHAR2(80) NULL; ALTER TABLE ObjectCustomFieldValues ADD SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL; - -CREATE INDEX ObjectCustomFieldValues1 on ObjectCustomFieldValues (CustomField,ObjectType,ObjectId,Content); -CREATE INDEX ObjectCustomFieldValues2 on ObjectCustomFieldValues (CustomField,ObjectType,ObjectId); - - - CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq; CREATE TABLE ObjectCustomFields ( id NUMBER(11,0) |