A table for theCheckUser extension used to all events, except log events, from therecentchanges table.The IP and UA string used to make the action is also stored.See alsocu_log_event andcu_private_event tables, which hold CheckUser events that are log events.
Primary key, used to uniquely identify acu_changes row.
Similar torc_namespace.When pages are renamed, this namespace does not change.
Similar torc_title.When pages are renamed, this title does not change.
| MediaWiki version: | ≤ 1.39 |
References auser_id in theuser table.Similar torc_user.
| MediaWiki version: | ≤ 1.39 |
References either a username with the ID stored incuc_user in theuser table or the text representation of the IP address whencuc_user is 0.Similar torc_user_text.
| MediaWiki version: | ≥ 1.38 |
Stores theactor_id for the user who performed the action that created this row.Similar torc_actor.
| MediaWiki version: | ≤ 1.42 |
Stores the output of the text generated by using the database columnsrc_params orlog_params in language specified in the server configuation.Once set this does not change and is not translated for user-by-user.
| MediaWiki version: | ≤ 1.39 |
Similar torc_comment.
| MediaWiki version: | ≥ 1.38 |
References a row in thecomment table with thecomment_id as the value stored in this column.Similar torc_comment_id.
Seerc_minor.
Key topage_id.Used to keep links working after moves while keeping the title and namespace of this change the same in the changes list.If not applicable (and also by default), the value of this column is 0.
rev_id of the given revision.See alsorc_this_oldid.
rev_id of the prior revision, for generating diff links.See alsorc_last_oldid.
An integer specifying the type of the event.Usually one of RC_EDIT (0) or RC_NEW (1).Before MediaWiki 1.43, RC_LOG (3) was also a common value.Seerc_type.
Timestamp for the event that is stored in thecu_changes table, in the timestamp format MediaWiki uses everywhere in the database:yyyymmddhhmmss.
The IP address used to make the edit.
The IP address incuc_ip as hexadecimal.
The entire XFF header.If not provided or if all XFF IPs arevarnish servers, this will be the empty string.
If all XFF IPs are notvarnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.
The User agent header provided in the request that made the action being stored in this row.
| MediaWiki version: | ≥ 1.42 |
References a row in thecu_useragent table by thecuua_id column.The row in the table stores the user agent header provided in the request.
| MediaWiki version: | ≤ 1.42 |
Private data that is stored using encryption.Must have a public key defined in the server configuration using$wgCUPublicKey.Otherwise is left empty.
| MediaWiki versions: | 1.40 – 1.42 |
Temporary column used for migration of log entries tocu_log_event table andcu_private_event table.
| MediaWiki version: | ≥ 1.43 |
DESCRIBEcu_changes;
+----------------+---------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+----------------+---------------------+------+-----+---------+----------------+| cuc_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment || cuc_namespace | int(11) | NO | | 0 | || cuc_title | varbinary(255) | NO | | | || cuc_actor | bigint(20) unsigned | NO | MUL | NULL | || cuc_comment_id | bigint(20) unsigned | NO | | NULL | || cuc_minor | tinyint(1) | NO | | 0 | || cuc_page_id | int(10) unsigned | NO | | 0 | || cuc_this_oldid | int(10) unsigned | NO | MUL | 0 | || cuc_last_oldid | int(10) unsigned | NO | | 0 | || cuc_type | tinyint(3) unsigned | NO | | 0 | || cuc_timestamp | binary(14) | NO | MUL | NULL | || 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_agent_id | bigint(20) unsigned | NO | | 0 | |+----------------+---------------------+------+-----+---------+----------------+
| MediaWiki version: | 1.42 |
DESCRIBEcu_changes;
+-----------------------+---------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------------------+---------------------+------+-----+---------+----------------+| cuc_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment || cuc_namespace | int(11) | NO | | 0 | || cuc_title | varbinary(255) | NO | | | || cuc_actor | bigint(20) unsigned | NO | MUL | NULL | || cuc_actiontext | varbinary(255) | NO | | | || cuc_comment_id | bigint(20) unsigned | NO | | NULL | || 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 | NULL | || 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_agent_id | bigint(20) unsigned | NO | | 0 | || cuc_private | mediumblob | YES | | NULL | || cuc_only_for_read_old | tinyint(1) | NO | | 0 | |+-----------------------+---------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.40 – 1.41 |
DESCRIBEcu_changes;
+-----------------------+---------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------------------+---------------------+------+-----+---------+----------------+| cuc_id | int(10) unsigned | NO | PRI | NULL | auto_increment || cuc_namespace | int(11) | NO | | 0 | || cuc_title | varbinary(255) | NO | | | || cuc_actor | bigint(20) unsigned | NO | MUL | 0 | || cuc_actiontext | varbinary(255) | NO | | | || cuc_comment_id | bigint(20) unsigned | NO | | 0 | || 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 | NULL | || 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 | || cuc_only_for_read_old | tinyint(1) | NO | | 0 | |+-----------------------+---------------------+------+-----+---------+----------------+
