Extension:CheckUser/cu changes table

Contents

A table for the CheckUser extension. See also Extension:CheckUser/cu_log table.

Fields

cuc_id

Primary key

cuc_namespace

When pages are renamed, their RC entries do _not_ change.

cuc_title

When pages are renamed, their RC entries do _not_ change.

cuc_user

user_id

cuc_user_text

user_text

cuc_actiontext

(Document me)

cuc_comment

rc_comment.

cuc_minor

See rc_minor.

cuc_page_id

Key to page_id (was cur_id prior to 1.5). This will keep links working after moves while retaining the at-the-time name in the changes list.

cuc_this_oldid

rev_id of the given revision. See also rc_this_oldid.

cuc_last_oldid

rev_id of the prior revision, for generating diff links. See also rc_last_oldid.

cuc_type

Edit/new/log. See rc_type.

cuc_timestamp

Event timestamp.

cuc_ip

IP address, visible.

cuc_ip_hex

IP address as hexadecimal.

cuc_xff

XFF header, visible, all data

cuc_xff_hex

XFF header, last IP, as hexadecimal

cuc_agent

User agent

cuc_private

Private data

Schema

mysql> describe cu_changes;
+----------------+---------------------+------+-----+----------------+----------------+
| Field          | Type                | Null | Key | Default        | Extra          |
+----------------+---------------------+------+-----+----------------+----------------+
| cuc_id         | int(11)             | NO   | PRI | NULL           | auto_increment |
| cuc_namespace  | int(11)             | NO   |     | 0              |                |
| cuc_title      | varbinary(255)      | NO   |     |                |                |
| cuc_user       | int(11)             | NO   | MUL | 0              |                |
| cuc_user_text  | varbinary(255)      | NO   |     |                |                |
| cuc_actiontext | varbinary(255)      | NO   |     |                |                |
| cuc_comment    | varbinary(255)      | NO   |     |                |                |
| cuc_minor      | tinyint(1)          | NO   |     | 0              |                |
| cuc_page_id    | int(10) unsigned    | NO   |     | 0              |                |
| cuc_this_oldid | int(10) unsigned    | NO   |     | 0              |                |
| cuc_last_oldid | int(10) unsigned    | NO   |     | 0              |                |
| cuc_type       | tinyint(3) unsigned | NO   |     | 0              |                |
| cuc_timestamp  | binary(14)          | NO   | MUL |                |                |
| cuc_ip         | varbinary(255)      | YES  |     |                |                |
| cuc_ip_hex     | varbinary(255)      | YES  | MUL | NULL           |                |
| cuc_xff        | varbinary(255)      | YES  |     |                |                |
| cuc_xff_hex    | varbinary(255)      | YES  | MUL | NULL           |                |
| cuc_agent      | varbinary(255)      | YES  |     | NULL           |                |
| cuc_private    | mediumblob          | YES  |     | NULL           |                |
+----------------+---------------------+------+-----+----------------+----------------+
19 rows in set (0.00 sec)