Page MenuHomePhabricator

Create the DB schema for invitation lists in prod
Closed, ResolvedPublic1 Estimated Story Points

Description

Acceptance criteria

  • The new tables introduced in T366354 should be created in the following production databases:
    • x1.wikishared
    • x1.testwiki
    • x1.test2wiki
    • x1.officewiki

This needs to be done in a dedicated window, see T340000 for a previous example.

Event Timeline

Daimona set the point value for this task to 1.

@Daimona, has this already been done?

No. We'll do it when deploying.

Mentioned in SAL (#wikimedia-operations) [2024-08-27T13:29:54Z] <Daimona> Creating new DB tables for the CampaignEvents extension in x1.testwiki, x1.test2wiki, x1.officewiki, and x1.wikishared # T369303

This is happening NOW. For future reference:

  • mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_lists.sql
  • mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_list_users.sql
  • mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_worklist_articles.sql
  • mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_lists.sql
  • mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_list_users.sql
  • mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_worklist_articles.sql
  • mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_lists.sql
  • mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_list_users.sql
  • mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_worklist_articles.sql
  • mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb=wikishared /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_lists.sql
  • mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb=wikishared /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_invitation_list_users.sql
  • mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb=wikishared /srv/mediawiki/php-1.43.0-wmf.20/extensions/CampaignEvents/db_patches/mysql/patch-add-ce_worklist_articles.sql

This is done, and I've verified that the tables exist and look good everywhere while I was creating them.