I'm converting a 2.0.15 RT system with mysql to 3.8.8 using Kai's scripts.[1]
For performance reasons, he drops the indices before the insert, then recreates them after. All perfectly logical, but his scripts were based on 3.8.4 I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 so that the index recreation works as expected. Thanks in advance: CREATE INDEX Attachments1 ON Attachments (Parent) ; CREATE INDEX Attachments2 ON Attachments (TransactionId) ; CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ; CREATE INDEX Links4 ON Links(Type,LocalBase); CREATE INDEX Principals2 ON Principals (ObjectId); CREATE INDEX Groups2 On Groups (lower(Type), lower(Domain), Instance); CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); CREATE INDEX ACL1 on ACL(ObjectId, ObjectType); CREATE INDEX ACL2 ON ACL(PrincipalId, PrincipalType); CREATE INDEX ACL3 ON ACL(RightName); CREATE INDEX CachedGroupMembers2 on CachedGroupMembers (MemberId); CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (GroupId); CREATE INDEX DisGrouMem on CachedGroupMembers (GroupId,MemberId,Disabled); CREATE INDEX Users3 ON Users (lower(EmailAddress)); CREATE INDEX Users4 ON Users (EmailAddress); CREATE INDEX Tickets1 ON Tickets (Queue, Status) ; CREATE INDEX Tickets2 ON Tickets (Owner) ; CREATE INDEX Tickets3 ON Tickets (EffectiveId) ; CREATE INDEX Tickets4 ON Tickets (id, Status) ; CREATE INDEX Tickets5 ON Tickets (id, EffectiveId) ; CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId,Content); CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId); CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField); CREATE INDEX Attributes1 on Attributes(Name); CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); [1] - http://bonsai.xs4all.nl/cgi-bin/gitweb.cgi?p=rt-migration.git Josh Narins Director of Application Development SeniorBridge 845 Third Ave 7th Floor New York, NY 10022 Tel: (212) 994-6194 Fax: (212) 994-4260 Mobile: (917) 488-6248 [email protected] seniorbridge.com<http://www.seniorbridge.com/> [http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif] ________________________________ SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.
RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
