手册:imagelinks表
↑ 手册:索引 | MediaWiki数据库布局 | imagelinks表 |
imagelinks表保存了文件嵌入。 有很多功能需要它,例如在输出功能的链接缓存和"链入页面"页面。 注意有的图片可能在外部文件集。 In the case of Wikimedia wikis, this table includes files hosted on Wikimedia Commons.
字段
il_from
链接所在的页面的page_id 。
il_from_namespace
MediaWiki版本: | ≥ 1.24 |
链接所在的页面的page_namespace 。
il_to
被链接的文件名。
模式摘要
MediaWiki版本: | ≥ 1.36 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_to | varbinary(255) | NO | PRI | | | | il_from_namespace | int(11) | NO | MUL | 0 | | +-------------------+------------------+------+-----+---------+-------+
MediaWiki版本: | 1.26 – 1.35 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_from_namespace | int(11) | NO | MUL | 0 | | | il_to | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+
MediaWiki版本: | 1.24 – 1.25 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_from_namespace | int(11) | NO | | 0 | | | il_to | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+
MediaWiki版本: | 1.10 – 1.23 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
MediaWiki版本: | 1.3 – 1.9 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(8) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
MediaWiki版本: | 1.1 – 1.2 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | varchar(255) binary | NO | PRI | NULL | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
Indexes
MediaWiki版本: | ≥ 1.30 |
SHOW INDEX IN imagelinks;
+------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | imagelinks | 0 | PRIMARY | 1 | il_from | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 0 | PRIMARY | 2 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_to | 1 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_to | 2 | il_from | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 1 | il_from_namespace | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 2 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 3 | il_from | A | 0 | NULL | NULL | | BTREE | | | +------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+