Handbuch:trackbacks-Tabelle

This page is a translated version of the page Manual:Trackbacks table and the translation is 100% complete.

↑ Handbuch:Inhaltsübersicht

MediaWiki-Datenbank-Layout

trackbacks-Tabelle

MediaWiki Versions:

1.5 – 1.18

r104051

Die trackbacks-Tabelle speichert Trackback-Anfragen.

Schematische Übersicht

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

Indexe

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