Manual:imagelinksテーブル

↑ Manual:コンテンツ

MediaWiki のデータベース レイアウト

imagelinks テーブル

imagelinks テーブルは、ファイルの参照読み込みを保持します。 This is good for a variety of functions, from link caching in the output functions to the "what links here" page. Note that some images may be on a foreign file repository. In the case of Wikimedia wikis, this table includes files hosted on Wikimedia Commons.

フィールド

il_from

リンクがあるページの page_id (ページ ID)。

il_from_namespace

MediaWiki バージョン:

≧ 1.24

page_namespace of the page containing the link.

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

インデックス

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