This is for T220791
**ALTERs to run:** https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/AbuseFilter/+/537361/4/db_patches/patch-split-afl_filter.sql
```lang=sql
ALTER TABLE /*_*/abuse_filter_log
ADD COLUMN afl_global tinyint(1) NOT NULL DEFAULT 0 AFTER afl_filter,
ADD COLUMN afl_filter_id BIGINT unsigned NOT NULL DEFAULT 0 AFTER afl_global,
ALTER COLUMN afl_filter SET DEFAULT '';
CREATE INDEX /*i*/filter_timestamp_full ON /*_*/abuse_filter_log (afl_global,afl_filter_id,afl_timestamp);
```
# **Where to run those changes:** all.dblist
# **When to run those changes:** After deployment of wmf.25, 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:** [[https://codesearch.wmflabs.org/operations/?q=afl_filter&i=nope&files=&repos=|Same]] as `afl_filter` for both columns.
Progress:
[] s1
** [] eqiad
** [x] codfw
[x] s2
** [x] eqiad T234052#5773358
** [x] codfw
[] s3
** [] eqiad
** [] codfw
[x] s4
** [x] eqiad T234052#5773889
** [x] codfw
[x] s5
** [x] eqiad T234052#5770812
** [x] codfw
[x] s6
** [x] eqiad T234052#5770937
** [x] codfw
[x] s7
** [x] eqiad T234052#5782053
** [x] codfw
[x] s8
** [x] eqiad T234052#5780629
** [x] codfw
[x] wikitech
** [x] labswiki
** [x] labtestwiki @Andrew (done by @Marostegui)
[x] Add the columns to the list of OK columns to be replicated: https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/540855/