Page MenuHomePhabricator
Create Task
Maniphest T369303

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

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.

Related Objects
Search...

Event Timeline

Daimona created this task.Jul 4 2024, 3:29 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 4 2024, 3:29 PM
Daimona added a parent task: T348779: [EPIC] Invitation Lists MVP.Jul 4 2024, 3:29 PM
Daimona moved this task from Backlog to Estimated/Ready for work on the Connection-Team board.Jul 17 2024, 4:27 PM
Daimona set the point value for this task to 1.
ifried subscribed.Aug 2 2024, 9:30 PM

@Daimona, has this already been done?

Daimona added a comment.Aug 2 2024, 9:59 PM
In T369303#10039721, @ifried wrote:

@Daimona, has this already been done?

No. We'll do it when deploying.

ifried added a comment.Aug 2 2024, 10:23 PM

Ok, thanks.

Daimona added a parent task: T373438: Invitation lists deployment work.Aug 27 2024, 1:21 PM
Daimona claimed this task.Aug 27 2024, 1:24 PM
Daimona edited projects, added Connection-Team (Connection-Current-Sprint); removed Connection-Team.
Stashbot added a comment.Aug 27 2024, 1:29 PM

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

Daimona added a comment.Aug 27 2024, 1:34 PM

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
Daimona closed this task as Resolved.Aug 27 2024, 1:35 PM
Daimona moved this task from Upcoming / refining 💡 to Done 🏁 on the Connection-Team (Connection-Current-Sprint) board.

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

Daimona removed a parent task: T348779: [EPIC] Invitation Lists MVP.Aug 27 2024, 1:50 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits