diff options
Diffstat (limited to 'rt/etc/upgrade/3.3.0/schema.mysql')
| -rw-r--r-- | rt/etc/upgrade/3.3.0/schema.mysql | 5 |
1 files changed, 0 insertions, 5 deletions
diff --git a/rt/etc/upgrade/3.3.0/schema.mysql b/rt/etc/upgrade/3.3.0/schema.mysql index d8b04991e..539c50bce 100644 --- a/rt/etc/upgrade/3.3.0/schema.mysql +++ b/rt/etc/upgrade/3.3.0/schema.mysql @@ -9,7 +9,6 @@ alter Table Transactions CHANGE Ticket ObjectId integer NOT NULL DEFAULT 0; UPDATE Transactions set ObjectType = 'RT::Ticket'; -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); alter table TicketCustomFieldValues rename ObjectCustomFieldValues, change Ticket ObjectId integer NOT NULL DEFAULT 0 , @@ -25,10 +24,6 @@ update ObjectCustomFieldValues set ObjectType = 'RT::Ticket'; #alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues1; #alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues2; -alter table ObjectCustomFieldValues add index ObjectCustomFieldValues1 (Content), - add index ObjectCustomFieldValues2 (CustomField,ObjectType,ObjectId); - - CREATE TABLE ObjectCustomFields ( id INTEGER NOT NULL AUTO_INCREMENT, CustomField int NOT NULL , |