Příručka:Databázová tabulka tag_summary
↑ Manuál:Obsah | MediaWiki schéma databáze | Tabulka tag_summary |
![]() | Tato funkce byla ve verzi 1.33 zcela odstraněna. |
Verze MediaWiki: | 1.15 – 1.32 |
Tabulka tag_summary se používá k vytažení tagů LIST jednoduše bez ošklivé GROUP_CONCAT. Viz také tabulka change_tag . Pozadí viz toto oznámení: "Ukončení podpory tabulky tag_summary"
Pole
ts_id
Verze MediaWiki: | ≥ 1.28 |
Primární klíč.
ts_rc_id
rc_id pro změnu.
ts_log_id
log_id pro změnu.
ts_rev_id
rev_id pro změnu.
ts_tags
Seznam značek oddělených čárkami.
Přehled změn ve schématu tabulky
Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
Verze 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 | | +-----------+---------+------+-----+---------+-------+
Indexy
Verze 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 | | | +-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+