Extension:CheckUser/cu changes table

From MediaWiki.org
Jump to: navigation, search

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

Fields[edit]

cuc_id[edit]

Primary key

cuc_namespace[edit]

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

cuc_title[edit]

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

cuc_user[edit]

user_id

cuc_user_text[edit]

user_text

cuc_actiontext[edit]

(Document me) dajgcmj gsjg

cuc_comment[edit]

rc_comment.

cuc_minor[edit]

See rc_minor.

cuc_page_id[edit]

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

rev_id of the given revision. See also rc_this_oldid.

cuc_last_oldid[edit]

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

cuc_type[edit]

Edit/new/log. See rc_type.

cuc_timestamp[edit]

Event timestamp.

cuc_ip[edit]

IP address, visible.

cuc_ip_hex[edit]

IP address as hexadecimal.

cuc_xff[edit]

XFF header, visible, all data

cuc_xff_hex[edit]

XFF header, last IP, as hexadecimal

cuc_agent[edit]

User agent

cuc_private[edit]

Private data

Schema[edit]

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)