手册:Change_tag表
Outdated translations are marked like this.
↑ 手册:索引 | MediaWiki数据库布局 | change_tag表 |
MediaWiki版本: | ≥ 1.15 |
change_tag表格跟踪标签的修订、日志和最近的更改。 另请参阅tag_summary 和valid_tag 表。
字段
ct_id
MediaWiki版本: | ≥ 1.28 |
表结构:主键
ct_rc_id
rc_id 为了这一变化。
ct_log_id
log_id 为了这一变化。
ct_rev_id
rev_id 为了这一变化。 请注意,这将是唯一的:对于应用于更改的每个标记,都会添加一个不同的行。
ct_tag
MediaWiki版本: | 1.15 – 1.32 |
与应用于更改的一个tag相对应的字符串。
ct_tag_id
MediaWiki版本: | ≥ 1.32 |
change_tag_def 表(change_tag_def.ctd_id)的主键的外键。 填充后,ct_tag就过时了。
ct_params
标记的参数。 例如:Extension:ContentTranslation 中的gerrit:139881.
架构摘要
MediaWiki版本: | ≥ 1.43 |
DESCRIBE change_tag;
+-----------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | bigint(20) unsigned | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | NO | MUL | NULL | | +-----------+---------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.36 – 1.42 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(10) unsigned | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | NO | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.33 – 1.35 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | NO | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.32 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | YES | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.30 – 1.31 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.28 – 1.29 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(11) | YES | MUL | NULL | | | ct_rev_id | int(11) | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.15 – 1.27 |
DESCRIBE change_tag;
+-----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------------+------+-----+---------+-------+ | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(11) | YES | MUL | NULL | | | ct_rev_id | int(11) | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+----------------+------+-----+---------+-------+
索引
MediaWiki版本: | ≥ 1.37 |
SHOW INDEX IN change_tag;
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | change_tag | 0 | PRIMARY | 1 | ct_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_rc_tag_id | 1 | ct_rc_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_rc_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_log_tag_id | 1 | ct_log_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_log_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_rev_tag_id | 1 | ct_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_rev_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 1 | ct_tag_id_id | 1 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 1 | ct_tag_id_id | 2 | ct_rc_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | ct_tag_id_id | 3 | ct_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | ct_tag_id_id | 4 | ct_log_id | A | 0 | NULL | NULL | YES | BTREE | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+