Jump to content

Extension:CheckUser/cu_changes テーブル

From mediawiki.org
This page is a translated version of the page Extension:CheckUser/cu changes table and the translation is 29% complete.

A table for the CheckUser extension used to all events, except log events, from the recentchanges table. The IP and UA string used to make the action is also stored. See also cu_log_event and cu_private_event tables, which hold CheckUser events that are log events.

フィールド

cuc_id

Primary key, used to uniquely identify a cu_changes row.

cuc_namespace

rc_namespace . と似ています When pages are renamed, this namespace does not change.

cuc_title

rc_title . と似ています When pages are renamed, this title does not change.

cuc_user

MediaWiki バージョン:
1.39

References a user_id in the user table. rc_user . と似ています

cuc_user_text

MediaWiki バージョン:
1.39

References either a username with the ID stored in cuc_user in the user table or the text representation of the IP address when cuc_user is 0. rc_user_text . と似ています

cuc_actor

MediaWiki バージョン:
1.38

Stores the actor_id for the user who performed the action that created this row. rc_actor と似ています。

cuc_actiontext

Stores the output of the text generated by using the database columns rc_params or log_params in language specified in the server configuation. Once set this does not change and is not translated for user-by-user.

cuc_comment

MediaWiki バージョン:
1.39

Similar to rc_comment .

cuc_comment_id

MediaWiki バージョン:
1.38

References a row in the comment table with the comment_id as the value stored in this column. Similar to rc_comment_id .

cuc_minor

rc_minor を参照してください。

cuc_page_id

page_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.

cuc_this_oldid

rev_id of the given revision. rc_this_oldid も参照してください。

cuc_last_oldid

rev_id of the prior revision, for generating diff links. rc_last_oldid も参照してください。

cuc_type

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. rc_type を参照してください。

cuc_timestamp

Timestamp for the event that is stored in the cu_changes table, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss.

cuc_ip

The IP address used to make the edit.

cuc_ip_hex

The IP address in cuc_ip as hexadecimal.

cuc_xff

The entire XFF header. If not provided or if all XFF IPs are varnish servers, this will be the empty string.

cuc_xff_hex

If all XFF IPs are not varnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.

cuc_agent

The User agent header provided in the request that made the action being stored in this row.

cuc_agent_id

MediaWiki バージョン:
1.42

References a row in the cu_useragent table by the cuua_id column. The row in the table stores the user agent header provided in the request.

cuc_private

Private data that is stored using encryption. Must have a public key defined in the server configuration using $wgCUPublicKey. Otherwise is left empty.

cuc_only_for_read_old

MediaWiki バージョン:
1.40

Temporary column used for migration of log entries to cu_log_event table and cu_private_event table.

スキーマ

MediaWiki バージョン:
1.42

DESCRIBE cu_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 バージョン:
1.40 – 1.41

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