Manual:imagelinks/ja table
From Linux Web Expert
↑ Manual:コンテンツ | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>imagelinks/ja</tvar> table</translate> |
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 バージョン: | <translate> ≥</translate> 1.24 |
page_namespace of the page containing the link.
il_to
リンク先のファイルのページ名。
スキーマの要約
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.36
<translate> MediaWiki version:</translate> |
DESCRIBE imagelinks/ja;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.26 – 1.35
<translate> MediaWiki versions:</translate> |
DESCRIBE imagelinks/ja;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.25</tvar> is unsupported version</translate>">
1.24 – 1.25
<translate> MediaWiki versions:</translate> |
DESCRIBE imagelinks/ja;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.23</tvar> is unsupported version</translate>">
1.10 – 1.23
<translate> MediaWiki versions:</translate> |
DESCRIBE imagelinks/ja;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">
1.3 – 1.9
<translate> MediaWiki versions:</translate> |
DESCRIBE imagelinks/ja;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(8) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.2</tvar> is unsupported version</translate>">
1.1 – 1.2
<translate> MediaWiki versions:</translate> |
DESCRIBE imagelinks/ja;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | varchar(255) binary | NO | PRI | NULL | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
インデックス
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.30
<translate> MediaWiki version:</translate> |
SHOW INDEX IN imagelinks/ja;
+------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+