手册:tag_summary表
↑ 手册:索引 | MediaWiki数据库布局 | tag_summary表 |
此功能已在版本1.33中完全移除。 |
MediaWiki版本: | 1.15 – 1.32 |
The tag_summary table is used to pull a LIST of tags simply without ugly GROUP_CONCAT. See also the change_tag table. For background, see this announcement: "Deprecation of tag_summary table"
字段
ts_id
MediaWiki版本: | ≥ 1.28 |
The primary key.
ts_rc_id
rc_id for the change.
ts_log_id
log_id for the change.
ts_rev_id
rev_id for the change.
ts_tags
Comma-separated list of tags.
Schema summary
MediaWiki版本: | 1.30 – 1.32 |
DESCRIBE tag_summary;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ts_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ts_rc_id | int(11) | YES | UNI | NULL | | | ts_log_id | int(10) unsigned | YES | UNI | NULL | | | ts_rev_id | int(10) unsigned | YES | UNI | NULL | | | ts_tags | blob | NO | | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.28 – 1.29 |
DESCRIBE tag_summary;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ts_id | int(10) unsigned | NO | PRI | NULL | AUTO_INCREMENT | | ts_rc_id | int(11) | YES | UNI | NULL | | | ts_log_id | int(11) | YES | UNI | NULL | | | ts_rev_id | int(11) | YES | UNI | NULL | | | ts_tags | blob | NO | | NULL | | +-----------+------------------+------+-----+---------+----------------+
MediaWiki版本: | 1.15 – 1.27 |
DESCRIBE tag_summary;
+-----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+-------+ | ts_rc_id | int(11) | YES | UNI | NULL | | | ts_log_id | int(11) | YES | UNI | NULL | | | ts_rev_id | int(11) | YES | UNI | NULL | | | ts_tags | blob | NO | | NULL | | +-----------+---------+------+-----+---------+-------+
Indexes
MediaWiki版本: | 1.28 – 1.32 |
SHOW INDEX IN tag_summary;
+-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | tag_summary | 0 | PRIMARY | 1 | ts_id | A | 0 | NULL | NULL | | BTREE | | | | tag_summary | 0 | tag_summary_rc_id | 1 | ts_rc_id | A | 0 | NULL | NULL | YES | BTREE | | | | tag_summary | 0 | tag_summary_log_id | 1 | ts_log_id | A | 0 | NULL | NULL | YES | BTREE | | | | tag_summary | 0 | tag_summary_rev_id | 1 | ts_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | +-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+