| This feature was removed completely in version 1.33.
|
MediaWiki versions:
|
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
"
Fields
[
edit
]
ts_id
[
edit
]
MediaWiki version:
|
≥
1.28
|
The primary key.
ts_rc_id
[
edit
]
rc_id
for the change.
ts_log_id
[
edit
]
log_id
for the change.
ts_rev_id
[
edit
]
rev_id
for the change.
ts_tags
[
edit
]
Comma-separated list of tags.
Schema summary
[
edit
]
MediaWiki versions:
|
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 versions:
|
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 versions:
|
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
[
edit
]
MediaWiki versions:
|
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 | | |
+-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|