Extension:CheckUser/table cu_changes

This page is a translated version of the page Extension:CheckUser/cu changes table and the translation is 22% complete.
Outdated translations are marked like this.

Table pour l'extension CheckUser . The IP and UA string used to make the action is also stored. Voir aussi cu_log_event .

Champs

cuc_id

Clé primaire

cuc_namespace

Similar to rc_namespace . Lorsque les pages sont renommées, leur entrées RC ne changent pas.

cuc_title

Similar to rc_title . Lorsque les pages sont renommées, leur entrées RC ne changent pas.

cuc_user

Version de MediaWiki :
1.39

References a user_id in the user table. Similar to rc_user .

cuc_user_text

Version de 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. Similar to rc_user_text .

cuc_actor

Version de MediaWiki :
1.38

Stores the actor_id for the user who performed the action that created this row. Similar to 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

Version de MediaWiki :
1.39

Similar to rc_comment .

cuc_comment_id

Version de 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

Voir rc_minor .

cuc_page_id

Clé de page_id (s'appelait $2 avant la version 1.5). Ceci permet de garder les liens actifs après avoir renommé en gardant l'ancien nom dans la liste des modifications. If not applicable (and also by default), the value of this column is 0.

cuc_this_oldid

rev_id de la révision donnée. Voir aussi rc_this_oldid .

cuc_last_oldid

rev_id de la révision précédente, pour générer les liens des diff . Voir aussi 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. Voir 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

Adresse IP, visible.

cuc_ip_hex

Adresse IP en format hexadecimal.

cuc_xff

Entête XFF, visible, toutes les données 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

Agent utilisateur

cuc_agent_id

Version de 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

Données privées. Must have a public key defined in the server configuration using $wgCUPublicKey. Otherwise is left empty.

cuc_only_for_read_old

Version de MediaWiki :
1.40

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

Schéma

Version de 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       |                |
+-----------------------+---------------------+------+-----+---------+----------------+
Versions de 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       |                |
+-----------------------+---------------------+------+-----+---------+----------------+