This is for T220791. We need to remove the old column (not used by the code anymore) and drop defaults from the new fields.
**ALTERs to run:** https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/AbuseFilter/+/632b39f8ca32927781a3877982ae0a012438e4d4/db_patches/mysql/patch-remove-afl_filter.sql
```lang=sql
DROP INDEX /*i*/afl_filter_timestamp ON /*_*/abuse_filter_log;
ALTER TABLE /*_*/abuse_filter_log
DROP COLUMN afl_filter,
ALTER COLUMN afl_filter_id DROP DEFAULT,
ALTER COLUMN afl_global DROP DEFAULT;
```
# **Where to run those changes:** all.dblist
# **When to run those changes:** After deployment of wmf.2, next week
# **If the schema change is backwards compatible:** Yes
# **If the schema change has been tested already on some of the test/beta wikis:** Tested locally
# **if the data should be made available on the labs replicas and/or dumps:** `afl_filter` should be removed from the views.
Progress
[] s1
** [] eqiad
** [] codfw
[x] s2
** [x] eqiad T291719#7446907
** [x] codfw
[] s3
** [] eqiad
** [] codfw
[x] s4
** [x] eqiad
** [x] codfw T291719#7447029
[x] s5
** [x] eqiad T291719#7446902
** [x] codfw
[x] s6
** [x] eqiad T291719#7443429
** [x] codfw
[] s7
** [] eqiad
** [] codfw
[] s8
** [] eqiad T291719#7449983
** [x] codfw