Open main menu

Extension:CheckUser/cu changes table


FieldsEdit

cuc_idEdit

Primary key

cuc_namespaceEdit

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

cuc_titleEdit

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

cuc_userEdit

user_id

cuc_user_textEdit

user_text

cuc_actiontextEdit

(Document me)

cuc_commentEdit

rc_comment

cuc_minorEdit

See rc_minor .

cuc_page_idEdit

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_oldidEdit

rev_id of the given revision. See also rc_this_oldid .

cuc_last_oldidEdit

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

cuc_typeEdit

Edit/new/log. See rc_type .

cuc_timestampEdit

Event timestamp.

cuc_ipEdit

IP address, visible.

cuc_ip_hexEdit

IP address as hexadecimal.

cuc_xffEdit

XFF header, visible, all data

cuc_xff_hexEdit

XFF header, last IP, as hexadecimal

cuc_agentEdit

User agent

cuc_privateEdit

Private data

SchemaEdit

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