- go to terbium, make local copies of [[ https://gerrit.wikimedia.org/r/#/c/212593/26/schema/archive/add-gl_list-flag-columns.sql | Gather/schema/gather_list_flag.sql ]] and [[ https://gerrit.wikimedia.org/r/#/c/212593/26/schema/gather_list_flag.sql | Gather/schema/archive/add-gl_list-flag-columns.sql ]]
- replace the UPDATE query in add-gl_list-flag-columns.sql with
-- gl_perm=HIDDEN -> gl_perm=PRIVATE, gl_perm_override=HIDDEN UPDATE gather_list SET gl_perm = 1, gl_perm_override = 1 WHERE gl_perm = 2;
- run mwscript sql.php --wiki=<wiki> gather_list_flag.sql
- run mwscript sql.php --wiki=<wiki> add-gl_list-flag-columns.sql
add-gl_list-flag-columns.sql includes an UPDATE command but it's indexed and does not match many rows (only hidden lists; currently 100 matches on enwiki) so there should be no need to batch it.
Post-deploy cleanup of the fake private settings: UPDATE gather_list SET gl_perm = 0 WHERE gl_perm_override = 2;