Extension:CheckUser/cu changes table

A table for the CheckUser extension used to store events from the recentchanges table and other selected events with the IP and UA string used to make the action. See also Extension:CheckUser/cu log table .

FieldsEdit

cuc_idEdit

Primary key, used to uniquely identify a cu_changes row.

cuc_namespaceEdit

Similar to rc_namespace . When pages are renamed, this namespace does not change.

cuc_titleEdit

Similar to rc_title . When pages are renamed, this title does not change.

cuc_userEdit

MediaWiki version:
1.39

References a user_id in the user table. Similar to rc_user .

cuc_user_textEdit

MediaWiki version:
1.39

References either a username with the ID stored in cuc_user in the user table or the text representation of the IP address when cuc_user is 0. Similar to rc_user_text .

cuc_actorEdit

MediaWiki version:
1.38

Stores the actor_id for the user who performed the action that created this row. Similar to rc_user .

cuc_actiontextEdit

Stores the output of the text generated by using the database columns rc_params or log_params in language specified in the server configuation. Once set this does not change and is not translated for user-by-user.

cuc_commentEdit

Similar to rc_comment and log_comment .

cuc_comment_idEdit

MediaWiki version:
1.38

References a row in the comment table with the comment_id as the value stored in this column. Similar to rc_comment_id and log_comment_id .

cuc_minorEdit

See rc_minor .

cuc_page_idEdit

Key to page_id . Used to keep links working after moves while keeping the title and namespace of this change the same in the changes list. If not applicable (and also by default), the value of this column is 0.

cuc_this_oldidEdit

rev_id of the given revision. See also rc_this_oldid .

cuc_last_oldidEdit

rev_id of the prior revision, for generating diff links. See also rc_last_oldid .

cuc_typeEdit

One of RC_EDIT (0), RC_NEW (1) or RC_LOG (3). See rc_type .

cuc_timestampEdit

Timestamp for the event that is stored in the cu_changes table, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss.

cuc_ipEdit

The IP address used to make the edit.

cuc_ip_hexEdit

The IP address in cuc_ip as hexadecimal.

cuc_xffEdit

The entire XFF header. If not provided or if all XFF IPs are varnish servers, this will be the empty string.

cuc_xff_hexEdit

If all XFF IPs are not varnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.

cuc_agentEdit

The User agent header provided in the request that made the action being stored in this row.

cuc_privateEdit

Private data that is stored using encryption. Must have a public key defined in the server configuration using $wgCUPublicKey. Otherwise is left empty.

SchemaEdit

mysql> describe cu_changes;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| cuc_id         | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| cuc_namespace  | int(11)             | NO   |     | 0       |                |
| cuc_title      | varbinary(255)      | NO   |     |         |                |
| cuc_user       | int(11)             | NO   | MUL | 0       |                |
| cuc_user_text  | varbinary(255)      | NO   |     |         |                |
| cuc_actor      | bigint(20) unsigned | NO   | MUL | 0       |                |
| cuc_actiontext | varbinary(255)      | NO   |     |         |                |
| cuc_comment    | varbinary(255)      | NO   |     |         |                |
| cuc_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| cuc_minor      | tinyint(1)          | NO   |     | 0       |                |
| cuc_page_id    | int(10) unsigned    | NO   |     | 0       |                |
| cuc_this_oldid | int(10) unsigned    | NO   |     | 0       |                |
| cuc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| cuc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| cuc_timestamp  | binary(14)          | NO   | MUL | NULL    |                |
| cuc_ip         | varbinary(255)      | YES  |     |         |                |
| cuc_ip_hex     | varbinary(255)      | YES  | MUL | NULL    |                |
| cuc_xff        | varbinary(255)      | YES  |     |         |                |
| cuc_xff_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cuc_agent      | varbinary(255)      | YES  |     | NULL    |                |
| cuc_private    | mediumblob          | YES  |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+