[Summary view] [Print] [Text view]

   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);