[rt-users] Adding new indexes in 2.0.9 to pre-existing 2.0.9 database

[Jesse Vincent]

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)

	-j


On 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 at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

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