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
[x] s1
** [x] eqiad T291719#7454162
** [x] 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
[x] s7
** [x] eqiad T291719#7454959
** [x] codfw
[x] s8
** [x] eqiad T291719#7449983
** [x] codfw