diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-filearchive-user-index.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-filearchive-user-index.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-filearchive-user-index.sql b/www/wiki/maintenance/archives/patch-filearchive-user-index.sql new file mode 100644 index 00000000..0d8c3ab1 --- /dev/null +++ b/www/wiki/maintenance/archives/patch-filearchive-user-index.sql @@ -0,0 +1,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; |