Extension:CheckUser/cu log table

The table records each time someone uses the CheckUser tool. See also.

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.

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

cul_user_text
of the user who performed the check. Comparable to.

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

cul_reason
The reason given for the check. Comparable to and.

cul_reason_id
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 in the  table.

cul_reason_plaintext_id
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 in the  table.

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

cul_target_text
of the user who was checked. Comparable to.

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
mysql> describe cu_log; +-+-+--+-+-++ +-+-+--+-+-++ +-+-+--+-+-++ (see source [ https://phabricator.wikimedia.org/diffusion/ECHU/browse/master/cu_log.sql here]).
 * 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   |     |         |                |