**ALTER TABLE:**
On `centralauth` run:
```lang=sql
ALTER TABLE /*_*/globalblocks MODIFY gb_reason varbinary(767) NOT NULL;
```
https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/GlobalBlocking/+/532265/6/localdb_patches/patch-globalblocks-reason-length.sql
---
On every other wiki where the `global_block_whitelist` table exists (should be every wiki database)
```lang=sql
ALTER TABLE /*_*/global_block_whitelist MODIFY gbw_reason varbinary(767) NOT NULL;
```
https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/GlobalBlocking/+/532265/6/localdb_patches/patch-global-block-whitelist-reason-length.sql
```lang=sql
ALTER TABLE /*_*/global_block_whitelist MODIFY gbw_by_text varbinary(255) NOT NULL;
```
https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/GlobalBlocking/+/532271/2/localdb_patches/patch-global_block_whitelist-use-varbinary.sql
Which becomes a combined SQL query of...
```lang=sql
ALTER TABLE /*_*/global_block_whitelist
MODIFY gbw_reason varbinary(767) NOT NULL,
MODIFY gbw_by_text varbinary(255) NOT NULL;
```
---
**WHEN?** At DBAs leisure
**Backwards Compatible?** Yes
Progress:
[] s1
** [] codfw
** [] eqiad
[] s2
** [] codfw
** [] eqiad
[] s3
** [] codfw
** [] eqiad
[] s4
** [] codfw
** [] eqiad
[x] s5 T231172#5518633
** [x] codfw
** [x] eqiad
[x] s6
** [x] codfw
** [x] eqiad T231172#5502869
[] s7 (needs special alter for `centralauth`)
** [] codfw
** [] eqiad
[] s8
** [] codfw
** [] eqiad
[] labswiki
[] labtestwiki