To T361139: Normalise the user agent column in CheckUser result tables, a column to store an ID that is a key to the cu_useragent table is needed in each CheckUser result table (added in T359312). The CheckUser result tables are cu_changes, cu_log_event, and cu_private_event. These columns were added to these tables in the extension in T361140.
- ALTERs to run:
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/refs/heads/master/schema/mysql/patch-cu_changes-add-cuc_agent_id.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/refs/heads/master/schema/mysql/patch-cu_log_event-add-cule_agent_id.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/refs/heads/master/schema/mysql/patch-cu_private_event-add-cupe_agent_id.sql
- Where to run those changes: all
- When to run those changes: At any time
- 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 beta cluster but has been deployed on a mwvagrant instance on https://checkuser-beta-wiki.wmcloud.org
- If the data should be made available on the labs replicas and/or dumps: Everything is private
Progress
- s1
- eqiad
- codfw
- s2
- eqiad
- codfw
- s3
- eqiad
- codfw
- s4
- eqiad
- codfw
- s5
- eqiad
- codfw
- s6
- eqiad
- codfw
- s7
- eqiad
- codfw (running)
- s8
- eqiad
- codfw
- labtestwiki