Extension:CheckUser/cu changes table
CheckUser uzantısı için bir tablo. Ayrıca bakınız cu_log .
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 and log_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 and log_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
One of RC_EDIT (0), RC_NEW (1) or RC_LOG (3). 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_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
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 | | +-----------------------+---------------------+------+-----+---------+----------------+