maintenance/archives/patch-filearchive-user-index.sql


1
2
3
4
5

-- Adding index to sort by uploader
ALTER TABLE /*$wgDBprefix*/filearchive
  ADD INDEX fa_user_timestamp (fa_user_text,fa_timestamp),
  -- Remove useless, incomplete index
  DROP INDEX fa_deleted_user;