Extension:CheckUser/cu log event table

Languages:
MediaWiki version:
1.40

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

In 1.40, this table is unused but is added to the database. Future versions will introduce usage of this table.

FieldsEdit

cule_idEdit

Primary key, used to uniquely identify a cu_log_event row.

cule_idEdit

The log ID associated with this cu_log_event row.

cule_actorEdit

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

cule_timestampEdit

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

cule_ipEdit

The IP address used to make the edit.

cule_ip_hexEdit

The IP address in cuc_ip as hexadecimal.

cule_xffEdit

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

cule_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.

cule_agentEdit

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

SchemaEdit

mysql> describe cu_log_event;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| cule_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| cule_log_id    | int(10) unsigned    | NO   |     | 0       |                |
| cule_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| cule_timestamp | binary(14)          | NO   | MUL | NULL    |                |
| cule_ip        | varbinary(255)      | YES  |     |         |                |
| cule_ip_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_xff       | varbinary(255)      | YES  |     |         |                |
| cule_xff_hex   | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_agent     | varbinary(255)      | YES  |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+