-- Changes indices to be friendlier to date-sorting

-- CURRENTLY EXPERIMENTAL!!!

-- cur and old need (namespace,title,timestamp) index for history,watchlist,rclinked
--  (q: watchlist does funny namespace stuff. maybe drop namespace?)
-- cur and old need (user,timestamp) index for contribs
-- cur and old need (user_text,timestamp) index for contribs

ALTER TABLE cur
  DROP INDEX cur_user,
  DROP INDEX cur_user_text,
  ADD INDEX name_title_timestamp (cur_namespace,cur_title,cur_timestamp),
  ADD INDEX user_timestamp (cur_user,cur_timestamp),
  ADD INDEX usertext_timestamp (cur_user_text,cur_timestamp);

ALTER TABLE old
  DROP INDEX old_user,
  DROP INDEX old_user_text,
  ADD INDEX name_title_timestamp (old_namespace,old_title,old_timestamp),
  ADD INDEX user_timestamp (old_user,old_timestamp),
  ADD INDEX usertext_timestamp (old_user_text,old_timestamp);
