diff options
author | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
---|---|---|
committer | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
commit | fc7369835258467bf97eb64f184b93691f9a9fd5 (patch) | |
tree | daabd60089d2dd76d9f5fb416b005fbe159c799d /www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql |
first commit
Diffstat (limited to 'www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql')
-rw-r--r-- | www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.sql new file mode 100644 index 00000000..f490bf9c --- /dev/null +++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-fix-indexes.sqlite.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) + +CREATE INDEX afl_filter_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_filter,afl_timestamp); +CREATE INDEX afl_user_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp); +CREATE INDEX afl_page_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp); +CREATE INDEX afl_ip_timestamp ON /*$wgDBprefix*/abuse_filter_log (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; |