Those scripts [1] [2] rework the revision to set correctly the default values on fields:
- date_neg_utc_offset
- committer_date_neg_utc_offset
- extra_headers
(same goes for release on other field but this is done as their volume is small enough compared to revision)
The end goal is to enforce those default values with constraints.
Extra optimization work has been done so the migration passes smoothly (cache reuse, no replication problem, one vacuum trigger) [3]
This is currently running on belvedere.
The workers are still running alongside.
[1] https://forge.softwareheritage.org/source/swh-storage/browse/master/sql/upgrades/160.sql
[2] https://forge.softwareheritage.org/source/swh-storage/browse/master/sql/upgrades/161.sql
[3] P747