From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes:
- The ALTER TABLEs to run- https://gerrit.wikimedia.org/r/#/c/418946/10/maintenance/archives/patch-rev_text_id-default.sql
- Where to run those changes: all.dblist
- When to run those changes: No time constraint (but ASAP)
- If the schema change is backwards compatible: Yes, the default is not yet used, it will be used in https://gerrit.wikimedia.org/r/#/c/406595/ but that usage is also behind a feature flag that is not enabled by default.
- If the schema change has been tested already on some of the test/beta wikis. Usually, as a last test, change should be applied to testwiki first. - It has been auto-deployed to Beta. I haven't heard that it broke anything. (also tested locally)
- If it involves new columns or tables, if the data should be made available on the labs replicas and/or dumps or not because they contain private or sensitive data: Treatment of replicas and dumps are the same.
Code within the linked patch:
ALTER TABLE /*$wgDBprefix*/revision ALTER COLUMN rev_text_id SET DEFAULT 0;
Schema change progress:
- s1
- codfw
- eqiad progress T190148#4228305
- s2
- codfw
- eqiad progress T190148#4160113
- s3
- codfw
- eqiad progress T190148#4212823
- s4
- codfw
- eqiad progress T190148#4181127
- s5
- codfw
- eqiad progress: T190148#4139166
- s6
- codfw
- eqiad progress: T190148#4149630
- s7
- codfw
- eqiad progress: T190148#4204533
- s8
- codfw
- eqiad progress: T190148#4222207