Manual:trackbacks table

From mediawiki.org
Other languages:
Manual:Contents MediaWiki database layout trackbacks table
MediaWiki versions:
1.5 – 1.18
r104051

The trackbacks table stores trackback requests.

Schema summary[edit]

MediaWiki versions:
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    |                |
+----------+----------------+------+-----+---------+----------------+
MediaWiki versions:
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    |                |
+----------+--------------+------+-----+---------+----------------+

Indexes[edit]

MediaWiki versions:
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      |         |               |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+