Change Details

===Acceptance criteria=== - Create a new column to store the event country code (as obtained by the CLDR extension) -- The new column should be in the `ce_address` table -- The name of the column will be `cea_country_code` -- Column type must be string of limit of 2 -- The column should be nullable to allow data migration (it may or may not remain nullable once the migration is over) - The column is created (automatically) in beta - The column is created in production See https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change for what else is needed here. ===[[https://wikitech.wikimedia.org/wiki/Creating_new_tables#Preparation | Checklist ]] === [x] Design the schema [x] Make schema change patch for it [x] Get initial reviews (+1s) [x] Tag this task with #dba [x] Request DBA signoff [] Get approval ====Deployment==== [] Merge the schema patch -- This will automatically create the new table in beta [x] Wait until the patch reaches production [] Schedule a dedicated deployment window, note the time here -- .... [] Create the table everywhere: -- `mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb wikishared /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql`

===Acceptance criteria=== - Create a new column to store the event country code (as obtained by the CLDR extension) -- The new column should be in the `ce_address` table -- The name of the column will be `cea_country_code` -- Column type must be string of limit of 2 -- The column should be nullable to allow data migration (it may or may not remain nullable once the migration is over) - The column is created (automatically) in beta - The column is created in production ===[[https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change | Checklist ]] === [x] Design the schema [x] Tag this task with #schema-change [x] Make schema change patch for it [x] Get initial reviews and DBA feedback [] Merge the schema patch -- This will automatically create the new table in beta [] Wait until the patch reaches production [] Create a subtask requesting the schema change in production, following instructions in https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change (3rd bullet)

===Acceptance criteria=== - Create a new column to store the event country code (as obtained by the CLDR extension) -- The new column should be in the `ce_address` table -- The name of the column will be `cea_country_code` -- Column type must be string of limit of 2 -- The column should be nullable to allow data migration (it may or may not remain nullable once the migration is over) - The column is created (automatically) in beta - The column is created in production See https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change for what else is needed here. ===[[https://wikitech.wikimedia.org/wiki/Creating_new_tables#PreparationSchema_changes#Workflow_of_a_schema_change | Checklist ]] === [x] Design the schema [x] Make schema change patch for it [x] Get initial reviews (+1s) [x] Tag this task with #dba#schema-change [x] Request DBA signoff [] Get approvalx] Make schema change patch for it ====Deployment====[x] Get initial reviews and DBA feedback [] Merge the schema patch -- This will automatically create the new table in beta [x] Wait until the patch reaches production [] Schedule a dedicated deployment window, note the time here -- .... [] Create the table everywhere: -- `mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql` -- `mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb wikishared /srv/mediawiki/php-1.44.0-wmf.11/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_country_code.sql`[] Create a subtask requesting the schema change in production, following instructions in https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change (3rd bullet)