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 ,
#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 ,