ALTER TABLE:
On centralauth run:
ALTER TABLE /*_*/globalblocks MODIFY gb_reason varbinary(767) NOT NULL;
On every other wiki where the global_block_whitelist table exists (should be every wiki database)
ALTER TABLE /*_*/global_block_whitelist MODIFY gbw_reason varbinary(767) NOT NULL;
ALTER TABLE /*_*/global_block_whitelist MODIFY gbw_by_text varbinary(255) NOT NULL;
Which becomes a combined SQL query of...
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 T231172#5518967
- codfw
- eqiad
- s2 T231172#5518938
- codfw
- eqiad
- s3 T231172#5521300
- codfw
- eqiad
- s4 T231172#5518675
- codfw
- eqiad
- s5 T231172#5518633
- codfw
- eqiad
- s6
- codfw
- eqiad T231172#5502869
- s7 (needs special alter for centralauth) T231172#5518996
- codfw
- eqiad
- s8 T231172#5518729
- codfw
- eqiad
- labswiki
- labtestwiki