Summary

The AbuseFilter tables are not needed on closed wikis, after we disabled it the extension on those wikis

Technical details

• The wikis in abusefilter-disabled.dblist have the AbuseFilter DB tables but several weeks ago the extension was disabled on those wikis
  • These database tables are empty (I confirmed this by running SELECT COUNT(*) FROM table for all AbuseFilter tables on wikis in abusefilter-disabled.dblist

All those databases live in s3 except mhwiktionary which lives in s5.

Schema change template

1. ALTERs to run:
   1. RENAME TABLE abuse_filter TO abuse_filter_temp; RENAME TABLE abuse_filter_log TO abuse_filter_log_temp; RENAME TABLE abuse_filter_action TO abuse_filter_action_temp; RENAME TABLE abuse_filter_history TO abuse_filter_history_temp;
   2. DROP TABLE abuse_filter_temp; DROP TABLE abuse_filter_log_temp; DROP TABLE abuse_filter_action_temp; DROP TABLE abuse_filter_history_temp;
2. Where to run those changes: abusefilter-disabled.dblist
3. When to run those changes: When DBA has time
4. If the schema change is backwards compatible: No, suggest renaming tables first and then dropping. However, the tables should not be accessed
5. If the schema change has been tested already on some of the test/beta wikis: N/A
6. If the data should be made available on the labs replicas and/or dumps: N/A