1. ALTERs to run:

ALTER TABLE /*_*/global_block_whitelist
  CHANGE gbw_by gbw_by INT NOT NULL;

1. Where to run those changes: all.dblist (though likely only a subset of this list actually needs the update applied)
2. When to run those changes: When DBA has time, very low priority
3. If the schema change is backwards compatible: Yes
4. If the schema change has been tested already on some of the test/beta wikis: The beta wikis do not have a default set for gbw_by
5. If the data should be made available on the labs replicas and/or dumps: Yes, no changes to existing rules needed

As detailed in T381502: Fix GlobalBlocking database schema drifts in production, the gbw_by column has a default set on WMF wikis but the GlobalBlocking extension schema has this without a default set. Looking further, it seems that there was no default set in the SQL that was defined before the conversion to an abstract schema, so it seems that we shouldn't need a patch to GlobalBlocking to address this.

Progress

• s1
• s2
• s3
• s4
• s5
• s6
• s7
• s8

Acceptance criteria

• The default value on gbw_by is removed from the global_block_whitelist table on all wikis