Request to apply a schema change in production to add the cea_country_code column to the ce_address table, as part of the CampaignEvents extension.

Patch: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CampaignEvents/+/1162643

Schema change:

ALTER TABLE /*_*/ce_address
  ADD cea_country_code BINARY(2) DEFAULT NULL;

CREATE INDEX cea_country_code ON /*_*/ce_address (cea_country_code);

Target databases:

• x1.testwiki
• x1.test2wiki
• x1.officewiki
• x1.wikishared

When to run:

• When you can

Backwards compatibility:

• Yes: nullable column, not yet used by production code. The column was added in wmf.8.

Replicas/dumps:

• Technically public, but x1 isn't included in replicas anyway

Feature blocking:

• Yes, required for rollout of CLDR-based country support in CampaignEvents (see task graph)