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
** [x] codfw
** [] eqiad progress T190148#4228305
[] s2
** [x] codfw
** [x] eqiad progress T190148#4160113
[] s3
** [x] codfw
** [x] eqiad progress T190148#4212823
[] s4
** [x] codfw
** [x] eqiad progress T190148#4181127
[] s5
** [x] codfw
** [x] eqiad progress: T190148#4139166
[] s6
** [x] codfw
** [x] eqiad progress: T190148#4149630
[] s7
** [x] codfw
** [x] eqiad progress: T190148#4204533
[] s8
** [x] codfw
** [x] eqiad progress: T190148#4222207