Adding new indexes in 2.0.9 to pre-existing 2.0.9 database

RT Users
1

Hi,

I just upgraded from 2.0.7 to 20.9 and everything seems great. Thanks for
the new enhancements Jesse. There’s one thing that I would like to implement
that I think didn’t happen during the upgrade. I remember reading about some
new indexes for a MySQL database. During make upgrade, I don’t think they
were added. Is there a .sql command file that just includes the statements
to add the indexes. Is that all that’s need to add them?

Thanks.

Eric Mandel
WorldNow

Enabling media companies to build powerful new businesses on the Internet.

This message may contain confidential and/or privileged information.

If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on this
message or any information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.

2

So, the best I can offer is for you is a suggestion that you diff
the schemas from 2.0.7 and 2.0.9. The new “ADD INDEX” lines
can be inserted from the mysql command shell (mysql rt)

-jOn Mon, Dec 03, 2001 at 08:45:32AM -0500, Eric Mandel wrote:

Hi,

I just upgraded from 2.0.7 to 20.9 and everything seems great. Thanks for
the new enhancements Jesse. There’s one thing that I would like to implement
that I think didn’t happen during the upgrade. I remember reading about some
new indexes for a MySQL database. During make upgrade, I don’t think they
were added. Is there a .sql command file that just includes the statements
to add the indexes. Is that all that’s need to add them?

Thanks.

Eric Mandel
WorldNow

Enabling media companies to build powerful new businesses on the Internet.

This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on this
message or any information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.