Jump to content

Extension:CheckUser/cu_log table

From mediawiki.org


The cu_log table records each time someone uses the CheckUser tool.

Fields

[edit]

cul_id

[edit]

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

cul_timestamp

[edit]

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

cul_user

[edit]
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

[edit]
MediaWiki version:
1.39

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

cul_actor

[edit]
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

[edit]
MediaWiki version:
1.39

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

cul_reason_id

[edit]
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

[edit]
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

[edit]
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

[edit]

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

[edit]

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

cul_target_hex

[edit]

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

cul_range_start

[edit]

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

cul_range_end

[edit]

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

Schema summary

[edit]

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   |     |         |                |
+-------------------------+---------------------+------+-----+---------+----------------+