See parent tasks.
ALTERs to run:
ALTER TABLE ce_address DROP cea_country, CHANGE cea_country_code cea_country_code BINARY(2) NOT NULL;
(The column change is actually changing a DEFAULT NULL to NOT NULL)
- Where to run those changes:
- x1.testwiki
- x1.test2wiki
- x1.officewiki
- x1.wikishared
- When to run those changes: Later this week, once everything is on 1.46.0-wmf.1 (due to r1200390 dropping unintended references to the old schema in write_new/read_new)
- If the schema change is backwards compatible: Yes because the migration is already in the migration_new stage and old rows have been backfilled
- If the schema change has been tested already on some of the test/beta wikis: Tested locally
- if the data should be made available on the labs replicas and/or dumps: The table is in x1 and therefore not replicated.
- Is this schema change blocking a feature rollout? No