Manual:Trackbacks table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Trackbacks table

"DESCRIBE trackbacks;" in MediaWiki 1.8 gives:

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

mysql> describe mw_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    |                |
+----------+--------------+------+-----+---------+----------------+
6 rows in set (0.02 sec)