**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/+/532270/3/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