ALTER TABLE: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/620044/3/maintenance/archives/patch-sites-site_global_key.sql
ALTER TABLE sites MODIFY `site_global_key` varbinary(64) NOT NULL;
WHERE: All wikis with the site table (it should be every wiki database)
WHEN: At DBAs leisure; change isn't necessary for WMF production, but helps keep tables in sync with core schema changes
BACK COMPAT: Yes
TESTED: Not yet on beta, will be merged soon
Table on the wikis should be relatively small, ~1000 rows
Schema change progress:
- s1
- s2
- s3
- s4
- s5
- s6
- s7
- s8
- wikitech
- labtestwiki