- ALTER to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/5ffecc2a3d66c002403598a0bc06cd8cc5de2efd/schema/mysql/patch-cusi_user-add-siu_info.sql
- Where to run those changes: checkuser-suggested-investigations.dblist on the extension1 database cluster
- When to run those changes: Actively blocking product work, so would appreciate sooner than later
- If the schema change is backwards compatible: Yes
- If the schema change has been tested already on some of the test/beta wikis: CheckUser is not on the beta cluster, has been tested on local dev wikis
- If the data should be made available on the labs replicas and/or dumps: No changes needed (table should remain private)
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
Table is tiny, I will run it on the master with replication.
Affected wikis:
$ cat checkuser-suggested-investigations.dblist # NOTE: This file is automatically generated. Do not edit it directly, run 'composer manage-dblist' instead. enwiki fawiki frwiki idwiki jawiki loginwiki metawiki ptwiki test2wiki testwiki trwiki zhwiki
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2026-02-13T12:16:29Z] <marostegui> Deploy schema change on x1 master with replication https://phabricator.wikimedia.org/T417386
Comment Actions
Done
`; do echo $i; sudo db-mysql db2191 $i -e "show create table cusi_user\G" | grep siu_info;done enwiki `siu_info` int(10) unsigned NOT NULL, fawiki `siu_info` int(10) unsigned NOT NULL, frwiki `siu_info` int(10) unsigned NOT NULL, idwiki `siu_info` int(10) unsigned NOT NULL, jawiki `siu_info` int(10) unsigned NOT NULL, loginwiki `siu_info` int(10) unsigned NOT NULL, metawiki `siu_info` int(10) unsigned NOT NULL, ptwiki `siu_info` int(10) unsigned NOT NULL, test2wiki `siu_info` int(10) unsigned NOT NULL, testwiki `siu_info` int(10) unsigned NOT NULL, trwiki `siu_info` int(10) unsigned NOT NULL, zhwiki `siu_info` int(10) unsigned NOT NULL,