Extension:CheckUser/cu_log table

Languages:


The cu_log table records each time someone uses the CheckUser tool. See also Extension:CheckUser/cu changes table .

FieldsEdit

cul_idEdit

The primary key, used to uniquely identify a checkuser log entry

cul_timestampEdit

The time the check was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss. Comparable to rc_timestamp .

cul_userEdit

MediaWiki version:
1.39

The id of the checkuser who performed the check. This is a reference into the user table. Comparable to rc_user .

cul_user_textEdit

MediaWiki version:
1.39

user_name of the user who performed the check. Comparable to rc_user_text .

cul_actorEdit

MediaWiki version:
1.39

This is a foreign key to actor_id in the actor table, corresponding to the checkuser who performed the check.

cul_reasonEdit

MediaWiki version:
1.39

The reason given for the check. Comparable to rc_comment and rev_comment .

cul_reason_idEdit

MediaWiki version:
1.39

In future versions will store the ID to a comment table row that has the reason for the check. This is a foreign key to comment_id in the comment table.

cul_reason_plaintext_idEdit

MediaWiki version:
1.39

In future versions will store the ID to a comment table row that has the reason for the check but converted to plaintext. This is a foreign key to comment_id in the comment table.

cul_typeEdit

cul_type message
ipedits $3, user got edits for target
ipedits-xff $3, user got edits for XFF target
ipusers $3, user got users for target
ipusers-xff $3, user got users for XFF target
useredits $3, user got edits for target
userips $3, user got IP addresses for target

cul_target_idEdit

The id of the user who was checked. 0 for checks on IP addresses or ranges. This is a reference into the user table. Comparable to rc_user .

cul_target_textEdit

user_name of the user who was checked. Comparable to rc_user_text .

cul_target_hexEdit

If the target was an IP address, this contains the hexadecimal form of the IP.

cul_range_startEdit

If the target was an IP range, this field contain the start, in hexadecimal form.

cul_range_endEdit

If the target was an IP range, this field contain the end, in hexadecimal form.

Schema summaryEdit

mysql> describe cu_log;
+-------------------------+---------------------+------+-----+---------+----------------+
| Field                   | Type                | Null | Key | Default | Extra          |
+-------------------------+---------------------+------+-----+---------+----------------+
| cul_id                  | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| cul_timestamp           | binary(14)          | NO   | MUL | NULL    |                |
| cul_user                | int(10) unsigned    | NO   | MUL | NULL    |                |
| cul_user_text           | varbinary(255)      | NO   |     | NULL    |                |
| cul_actor               | bigint(20) unsigned | NO   | MUL | 0       |                |
| cul_reason              | varbinary(255)      | NO   |     | NULL    |                |
| cul_reason_id           | bigint(20) unsigned | NO   |     | 0       |                |
| cul_reason_plaintext_id | bigint(20) unsigned | NO   |     | 0       |                |
| cul_type                | varbinary(30)       | NO   | MUL | NULL    |                |
| cul_target_id           | int(10) unsigned    | NO   |     | 0       |                |
| cul_target_text         | blob                | NO   |     | NULL    |                |
| cul_target_hex          | varbinary(255)      | NO   | MUL |         |                |
| cul_range_start         | varbinary(255)      | NO   | MUL |         |                |
| cul_range_end           | varbinary(255)      | NO   |     |         |                |
+-------------------------+---------------------+------+-----+---------+----------------+

(see source here).