Document suggested investigations tables in tables-catalog.yaml
Closed, ResolvedPublic0.2 Estimated Story Points
Actions

Description

We need to update tables-catalog.yaml to document the tables added in T402391: Suggested investigations: Create database tables.

Background

tables-catalog.yaml is used to document what tables should exist on production databases
- We should document new tables that are created in this file when we create them on production
We need a list of wikis which the tables should exist on, so we cannot do this task until:
- We have decided which wikis we will initially deploy to
- Create the tables on the relevant extension1 databases

Acceptance criteria

tables-catalog.yaml is updated to include the tables added in T402391: Suggested investigations: Create database tables

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	tables-catalog: Document new CheckUser database tables	operations/puppet	production	+24 -0
	Create checkuser-suggested-investigations.dblist	operations/mediawiki-config	master	+26 -9

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Open	None	T402025 [Epic]: Display suggested investigations to CheckUsers
Resolved	Dreamy_Jazz	T403471 Document suggested investigations tables in tables-catalog.yaml
Resolved	Dreamy_Jazz	T403473 Create suggested investigation database tables on WMF production
Resolved	Dreamy_Jazz	T402391 Suggested investigations: Create database tables

Event Timeline

Dreamy_Jazz created this task.Sep 2 2025, 12:16 PM

Dreamy_Jazz updated the task description. (Show Details)Sep 2 2025, 12:20 PM

Change #1184058 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[operations/puppet@production] tables-catalog: Document new CheckUser database tables

https://gerrit.wikimedia.org/r/1184058

gerritbot added a project: Patch-For-Review.Sep 2 2025, 12:21 PM

Dreamy_Jazz claimed this task.Sep 2 2025, 12:22 PM

Dreamy_Jazz moved this task from Inbox to Engineering on the Trust and Safety Product Team board.

Dreamy_Jazz set the point value for this task to 0.2.

Johannnes89 unsubscribed.Sep 2 2025, 12:24 PM

Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Princess Tarta (August 18 - September 5)).Sep 3 2025, 1:06 PM

Dreamy_Jazz moved this task from Priority Backlog to Ready on the Trust and Safety Product Sprint (Sprint Princess Tarta (August 18 - September 5)) board.Sep 3 2025, 1:10 PM

Dreamy_Jazz closed subtask T403473: Create suggested investigation database tables on WMF production as Resolved.Sep 3 2025, 8:41 PM

Novem_Linguae subscribed.Sep 4 2025, 4:48 AM

Dreamy_Jazz moved this task from Ready to Needs Review on the Trust and Safety Product Sprint (Sprint Princess Tarta (August 18 - September 5)) board.Sep 4 2025, 9:16 AM

Dreamy_Jazz moved this task from Backlog to In Progress on the CheckUser-SuggestedInvestigations board.Sep 4 2025, 9:29 AM

Change #1184903 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[operations/mediawiki-config@master] Create checkuser-suggested-investigations.dblist

https://gerrit.wikimedia.org/r/1184903

Change #1184903 merged by jenkins-bot:

[operations/mediawiki-config@master] Create checkuser-suggested-investigations.dblist

https://gerrit.wikimedia.org/r/1184903

Mentioned in SAL (#wikimedia-operations) [2025-09-04T18:58:32Z] <dreamyjazz@deploy1003> Started scap sync-world: Backport for [[gerrit:1184903|Create checkuser-suggested-investigations.dblist (T403471)]]

Mentioned in SAL (#wikimedia-operations) [2025-09-04T19:03:42Z] <dreamyjazz@deploy1003> dreamyjazz: Backport for [[gerrit:1184903|Create checkuser-suggested-investigations.dblist (T403471)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-09-04T19:11:08Z] <dreamyjazz@deploy1003> Finished scap sync-world: Backport for [[gerrit:1184903|Create checkuser-suggested-investigations.dblist (T403471)]] (duration: 12m 36s)

Change #1184058 merged by Ladsgroup:

[operations/puppet@production] tables-catalog: Document new CheckUser database tables

https://gerrit.wikimedia.org/r/1184058

Maintenance_bot removed a project: Patch-For-Review.Sep 4 2025, 11:30 PM

mszwarc closed this task as Resolved.Sep 5 2025, 12:24 PM

mszwarc moved this task from Needs Review to Done on the Trust and Safety Product Sprint (Sprint Princess Tarta (August 18 - September 5)) board.

mszwarc moved this task from In Progress to Done on the CheckUser-SuggestedInvestigations board.

Dreamy_Jazz updated the task description. (Show Details)Sep 5 2025, 1:54 PM

Document suggested investigations tables in tables-catalog.yamlClosed, ResolvedPublic0.2 Estimated Story PointsActions