diff options
Diffstat (limited to 'www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql')
-rw-r--r-- | www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql new file mode 100644 index 00000000..16dea669 --- /dev/null +++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sql @@ -0,0 +1,18 @@ +-- Fixes abuse_filter_log indices. + +--# PRIMARY KEY (afl_id), +--# KEY (afl_filter,afl_timestamp), +--# KEY (afl_user,afl_user_text,afl_timestamp), +--# KEY (afl_timestamp), +--# KEY (afl_namespace, afl_title, afl_timestamp), +--# KEY (afl_ip, afl_timestamp) + +ALTER TABLE /*_*/abuse_filter_log ADD KEY filter_timestamp (afl_filter,afl_timestamp); +ALTER TABLE /*_*/abuse_filter_log ADD KEY user_timestamp (afl_user,afl_user_text,afl_timestamp); +ALTER TABLE /*_*/abuse_filter_log ADD KEY page_timestamp (afl_namespace, afl_title, afl_timestamp); +ALTER TABLE /*_*/abuse_filter_log ADD KEY ip_timestamp (afl_ip, afl_timestamp); + +ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_filter; +ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_user; +ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_namespace; +ALTER TABLE /*_*/abuse_filter_log DROP KEY afl_ip; |