Extension:CheckUser/cu private event table

MediaWiki version:

≥ 1.40

A table for the CheckUser extension used to store log entries without an associated log ID from the recentchanges table and other selected events with the IP and UA string used to make the action. See also cu_changes and cu_log_event .

In 1.40, this table is unused but is added to the database. Since 1.41, this table is used.

Fields

cupe_id

Primary key, used to uniquely identify a cu_private_event row.

cupe_namespace

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

cupe_title

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

cupe_actor

Stores the actor_id for the user who performed the action that created this row. Similar to rc_user . The value will be NULL if temporary accounts are enabled and the performer is an IP address. In this case, the performer of the action is the IP address in the cupe_id column.

cupe_log_type

The type of this log entry. Similar to rc_log_type and log_type .

cupe_log_action

The action that this log entry comes under. Similar to rc_log_action and log_action .

cupe_params

Similar to rc_params and log_params .

cupe_comment_id

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 .

cupe_page

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.

cupe_timestamp

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

cupe_ip

The IP address used to make the edit.

cupe_ip_hex

The IP address in cuc_ip as hexadecimal.

cupe_xff

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

cupe_xff_hex

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

cupe_agent

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

cupe_agent_id

MediaWiki version:

≥ 1.42

References a row in the cu_useragent table by the cuua_id column. The row in the table stores the user agent header provided in the request.

cupe_private

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

Schema

MediaWiki version:

≥ 1.42

DESCRIBE cu_private_event;

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| cupe_id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| cupe_namespace  | int(11)             | NO   |     | 0       |                |
| cupe_title      | varbinary(255)      | NO   |     |         |                |
| cupe_actor      | bigint(20) unsigned | YES  | MUL | 0       |                |
| cupe_log_type   | varbinary(32)       | NO   |     |         |                |
| cupe_log_action | varbinary(32)       | NO   |     |         |                |
| cupe_params     | blob                | NO   |     | NULL    |                |
| cupe_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| cupe_page       | int(10) unsigned    | NO   |     | 0       |                |
| cupe_timestamp  | binary(14)          | NO   | MUL | NULL    |                |
| cupe_ip         | varbinary(255)      | YES  |     |         |                |
| cupe_ip_hex     | varbinary(255)      | YES  | MUL | NULL    |                |
| cupe_xff        | varbinary(255)      | YES  |     |         |                |
| cupe_xff_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cupe_agent_id   | bigint(20) unsigned | NO   |     | 0       |                |
| cupe_private    | mediumblob          | YES  |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

MediaWiki version:

≤ 1.41

DESCRIBE cu_private_event;

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| cupe_id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| cupe_namespace  | int(11)             | NO   |     | 0       |                |
| cupe_title      | varbinary(255)      | NO   |     |         |                |
| cupe_actor      | bigint(20) unsigned | NO   | MUL | 0       |                |
| cupe_log_type   | varbinary(32)       | NO   |     |         |                |
| cupe_log_action | varbinary(32)       | NO   |     |         |                |
| cupe_params     | blob                | NO   |     | NULL    |                |
| cupe_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| cupe_page       | int(10) unsigned    | NO   |     | 0       |                |
| cupe_timestamp  | binary(14)          | NO   | MUL | NULL    |                |
| cupe_ip         | varbinary(255)      | YES  |     |         |                |
| cupe_ip_hex     | varbinary(255)      | YES  | MUL | NULL    |                |
| cupe_xff        | varbinary(255)      | YES  |     |         |                |
| cupe_xff_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cupe_agent      | varbinary(255)      | YES  |     | NULL    |                |
| cupe_private    | mediumblob          | YES  |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+