Extension:CheckUser/cu private event table/en

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

cupe_id
Primary key, used to uniquely identify a cu_private_event row.

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

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

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

cupe_log_type
The type of this log entry. Similar to and.

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

cupe_params
Similar to and.

cupe_comment_id
References a row in the with the  as the value stored in this column. Similar to and.

cupe_page
Key to. 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  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_private
Private data that is stored using encryption. Must have a public key defined in the server configuration using. Otherwise is left empty.

Schema
mysql> 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    |                |