Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Jump to content

Manuel:Table trackback

From mediawiki.org
This page is a translated version of the page Manual:Trackbacks table and the translation is 100% complete.
Manuel:Contenu Schéma de base de données MédiaWiki table trackbacks
Versions de MediaWiki :
1.5 – 1.18
r104051

La table trackbacks stocke les demandes de notification (trackback).

Résumé du schéma

Versions de MediaWiki :
1.10 – 1.18

DESCRIBE trackbacks;

+----------+----------------+------+-----+---------+----------------+
| Field    | Type           | Null | Key | Default | Extra          |
+----------+----------------+------+-----+---------+----------------+
| tb_id    | int(11)        | NO   | PRI | NULL    | auto_increment |
| tb_page  | int(11)        | YES  | MUL | NULL    |                |
| tb_title | varbinary(255) | NO   |     | NULL    |                |
| tb_url   | blob           | NO   |     | NULL    |                |
| tb_ex    | blob           | YES  |     | NULL    |                |
| tb_name  | varbinary(255) | YES  |     | NULL    |                |
+----------+----------------+------+-----+---------+----------------+
Versions de MediaWiki :
1.5 – 1.9

DESCRIBE trackbacks;

+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| tb_id    | int(11)      | NO   | PRI | NULL    | auto_increment |
| tb_page  | int(11)      | YES  | MUL | NULL    |                |
| tb_title | varchar(255) | NO   |     | NULL    |                |
| tb_url   | varchar(255) | NO   |     | NULL    |                |
| tb_ex    | text         | YES  |     | NULL    |                |
| tb_name  | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

Les index

Versions de MediaWiki :
1.5 – 1.18

SHOW INDEX IN trackbacks;

+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| trackbacks |          0 | PRIMARY  |            1 | tb_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| trackbacks |          1 | tb_page  |            1 | tb_page     | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+