Manual:tag_summary table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎davvisámegiella • ‎español • ‎中文 • ‎日本語
Manual:Contents MediaWiki database layout tag_summary table


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. (removed in 1.33) 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    |       | 
+-----------+---------+------+-----+---------+-------+