Merge "Improve sorting on SpecialWanted*-Pages"
[mediawiki.git] / maintenance / archives / patch-filearchive-user-index.sql
blob0d8c3ab15e1977dc1703270ca07fc85513d2fcbc
1 -- Adding index to sort by uploader
2 ALTER TABLE /*$wgDBprefix*/filearchive
3   ADD INDEX fa_user_timestamp (fa_user_text,fa_timestamp),
4   -- Remove useless, incomplete index
5   DROP INDEX fa_deleted_user;