Manual:tag_summary/fr table

↑ Manuel:Contenu

<translate> MediaWiki database layout</translate>

<translate> <tvar name=1>tag_summary/fr</tvar> table</translate>

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">

1.15 – 1.32

<translate> MediaWiki versions:</translate>

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"

Champs

ts_id

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.28

<translate> MediaWiki version:</translate>

The primary key.

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.

Résumé du schéma

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">

1.30 – 1.32

<translate> MediaWiki versions:</translate>

DESCRIBE tag_summary/fr;

+-----------+------------------+------+-----+---------+----------------+
| 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    |                |
+-----------+------------------+------+-----+---------+----------------+

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">

1.28 – 1.29

<translate> MediaWiki versions:</translate>

DESCRIBE tag_summary/fr;

+-----------+------------------+------+-----+---------+----------------+
| 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    |                |
+-----------+------------------+------+-----+---------+----------------+

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.27</tvar> is unsupported version</translate>">

1.15 – 1.27

<translate> MediaWiki versions:</translate>

DESCRIBE tag_summary/fr;

+-----------+---------+------+-----+---------+-------+
| 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    |       | 
+-----------+---------+------+-----+---------+-------+

Les index

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">

1.28 – 1.32

<translate> MediaWiki versions:</translate>

SHOW INDEX IN tag_summary/fr;

+-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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      |         |               |
+-------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+