Jump to content

Extension:CheckUser/cu changes table

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

CheckUser uzantısı için bir tablo. The IP and UA string used to make the action is also stored. Ayrıca bakınız cu_log_event .

Alanlar

cuc_id

Birincil anahtar

cuc_namespace

Similar to rc_namespace . Sayfalar yeniden adlandırıldığında, RC girişleri DEĞİŞMEZ.

cuc_title

Similar to rc_title . Sayfalar yeniden adlandırıldığında, RC girişleri DEĞİŞMEZ.

cuc_user

MediaWiki sürümü:
1.39

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

cuc_user_text

MediaWiki sürümü:
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

MediaWiki sürümü:
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

MediaWiki sürümü:
1.39

Similar to rc_comment .

cuc_comment_id

MediaWiki sürümü:
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 sayfasına bakın.

cuc_page_id

page_id anahtarı (1.5'ten önce $2 idi). Bu, değişiklik listesinde o anki adı korurken bağlantıların hareketlerden sonra çalışmaya devam etmesini sağlayacaktır. If not applicable (and also by default), the value of this column is 0.

cuc_this_oldid

Verilen revizyonun rev_id . Ayrıca bakınız rc_this_oldid .

cuc_last_oldid

Farklı bağlantılar oluşturmak için önceki revizyonun rev_id . Ayrıca bakınız 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 sayfasına bakın.

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

IP adresi, görülebilir.

cuc_ip_hex

Onaltılık olarak IP adresi.

cuc_xff

XFF başlığı, görünür, tüm veriler 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

Kullanıcı aracısı

cuc_agent_id

MediaWiki sürümü:
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

Özel veri Must have a public key defined in the server configuration using $wgCUPublicKey. Otherwise is left empty.

cuc_only_for_read_old

MediaWiki sürümü:
1.40

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

Şema

MediaWiki sürümü:
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 sürümleri:
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       |                |
+-----------------------+---------------------+------+-----+---------+----------------+