3 files changed, 0 insertions, 18 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)
diff --git a/rt/etc/upgrade/3.3.0/schema.Pg b/rt/etc/upgrade/3.3.0/schema.Pg
index 427eae798..0c2ad543d 100644
--- a/rt/etc/upgrade/3.3.0/schema.Pg
+++ b/rt/etc/upgrade/3.3.0/schema.Pg
@@ -9,8 +9,6 @@ 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;
@@ -33,10 +31,6 @@ alter table objectcustomfieldvalues add column ContentType varchar(80) NULL;
 
 alter table objectcustomfieldvalues add column ContentEncoding varchar(80) NULL;
 
-create index ObjectCustomFieldValues1 on objectcustomfieldvalues (CustomField,ObjectType,ObjectId,Content); 
-
-create index ObjectCustomFieldValues2  on objectcustomfieldvalues (CustomField,ObjectType,ObjectId); 
-
 
 CREATE SEQUENCE objectcustomfields_id_s;
 
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  ,