maintenance/archives/patch-inverse_timestamp.sql

   1 -- Removes the inverse_timestamp field from early 1.5 alphas.
   2 -- This field was used in the olden days as a crutch for sorting
   3 -- limitations in MySQL 3.x, but is being dropped now as an
   4 -- unnecessary burden. Serious wikis should be running on 4.x.
   5 --
   6 -- Updater added 2005-03-13
   7
   8 ALTER TABLE /*$wgDBprefix*/revision
   9   DROP COLUMN inverse_timestamp,
  10   DROP INDEX page_timestamp,
  11   DROP INDEX user_timestamp,
  12   DROP INDEX usertext_timestamp,
  13   ADD  INDEX page_timestamp (rev_page,rev_timestamp),
  14   ADD  INDEX user_timestamp (rev_user,rev_timestamp),
  15   ADD  INDEX usertext_timestamp (rev_user_text,rev_timestamp);