Extension:CheckUser/cu log table
The cu_log table records each time someone uses the CheckUser tool.
Fields
cul_id
The primary key, used to uniquely identify a checkuser log entry
cul_timestamp
The time the check was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss. Comparable to rc_timestamp.
cul_user
| 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_text
| MediaWiki version: | ≤ 1.39 |
user_name of the user who performed the check. Comparable to rc_user_text.
cul_actor
| 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_reason
| MediaWiki version: | ≤ 1.39 |
The reason given for the check. Comparable to rc_comment and rev_comment.
cul_reason_id
| 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_id
| 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_type
| cul_type | message |
|---|---|
| ipedits | $3, user got actions performed by target |
| ipedits-xff | $3, user got actions performed by XFF target |
| ipusers | $3, user got users for target |
| ipusers-xff | $3, user got users for XFF target |
| useredits | $3, user got actions performed by target |
| userips | $3, user got IP addresses for target |
cul_target_id
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_text
user_name of the user who was checked. Comparable to rc_user_text.
cul_target_hex
If the target was an IP address, this contains the hexadecimal form of the IP.
cul_range_start
If the target was an IP range, this field contain the start, in hexadecimal form.
cul_range_end
If the target was an IP range, this field contain the end, in hexadecimal form.
Schema summary
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 | | | | +-------------------------+---------------------+------+-----+---------+----------------+