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