2009/6/6 Tim Starling <tstarling(a)wikimedia.org>rg>:
Please let me know if you know of any schema changes
that need to be
run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and
performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no
disruption to service.
* Please add the rc_user_text (rc_user_text, rc_timestamp) index to
all database servers (blocking deployment of bug 14200 fix), as well
as cl_sortkey (cl_to,cl_sortkey,cl_from) (see bug 17558 and the live
hack in ApiQueryCategoryMembers.php)
* Please add the rd_interwiki and rd_fragment fields to the redirect
table (bug 14418; will commit DB patches within 24 hrs, actual
implementation still has a few issues)
* I've also got a patch for rev_bot and rev_patrolled fields lying
around at bug 17237, but it's old, missing the actual DB patch and I'm
not sure you guys (meaning the senior devs) agree with adding these
fields, so we might wanna hold off on this one for now
Roan Kattouw (Catrope)