summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-filearchive-user-index.sql
blob: c79000adaa92c69d93965a2238031243869dc7fa (plain)
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;