Manual:tag_summary table
Appearance
Outdated translations are marked like this.
↑ Manual: Contenidos de | MediaWiki database layout | tag_summary table |
Esta función se eliminó por completo en la versión 1.33. |
Versiones de MediaWiki: | 1.15 – 1.32 |
The tag_summary table is used to pull a LIST of tags simply without ugly GROUP_CONCAT. Véase también la tabla $change-tag. For background, see this announcement: "Deprecation of tag_summary table"
Campos
ts_id
Versión de 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 para el cambio.
ts_tags
Lista de etiquetas, separadas por comas.
Resumen del esquema
Versiones de 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 | | +-----------+------------------+------+-----+---------+----------------+
Versiones de 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 | | +-----------+------------------+------+-----+---------+----------------+
Versiones de 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
Versiones de 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 | | | +-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+