2009/6/6 Tim Starling tstarling@wikimedia.org:
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)