Příručka:Databázová tabulka trackbacks
↑ Manuál:Obsah | MediaWiki schéma databáze | Tabulka trackbacks |
Verze MediaWiki: | 1.5 – 1.18 r104051 |
Tabulka trackbacks ukládá trackback požadavky.
Přehled změn ve schématu tabulky
Verze 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 | | +----------+----------------+------+-----+---------+----------------+
Verze 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 | | +----------+--------------+------+-----+---------+----------------+
Indexy
Verze 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 | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+