Manual:tag_summaryテーブル
↑ Manual:コンテンツ | 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. change_tag テーブルも参照してください。 For background, see this announcement: "Deprecation of tag_summary table"
フィールド
ts_id
MediaWiki バージョン: | ≧ 1.28 |
主キー。
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.
スキーマの要約
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 | | +-----------+---------+------+-----+---------+-------+
インデックス
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 | | | +-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+