手册:externallinks表
| ↑ 手册:索引 | MediaWiki数据库布局 | externallinks表 |
| MediaWiki版本： | ≥ 1.6 |
externallinks表是MediaWiki存放与跟踪外部鏈接的地方。 Note unless $wgRegisterInternalExternals is enabled (it is disabled by default), links to the same server are not recorded.
Up to version 1.41, protocol-relative links are stored twice in this table as per r102951.
字段
el_id
| MediaWiki版本： | ≥ 1.22 |
主键。 現在沒有任何用途，但可以用於在線模式更改。
el_from
引用此鏈接的wiki頁面的page id。
el_to_domain_index
| MediaWiki版本： | ≥ 1.40 |
This is similar to el_index but only includes the protocol specification and domain in reverse, so http://en.wikipedia.org becomes http://org.wikipedia.en..
el_to_path
| MediaWiki版本： | ≥ 1.40 |
Only the path of el_to.
Example:
/wiki/Main_Page
el_to
| MediaWiki版本： | 1.6 – 1.41 Gerrit change 954900 |
實際的URL。 它會傳送給瀏覧器。
el_index
| MediaWiki版本： | 1.6 – 1.41 Gerrit change 954900 |
This is the same URL as el_to search-optimized: username and password information is stripped, and the other components are reversed for faster searching, so http://user:password@sub.example.com/page.html becomes http://com.example.sub./page.html, which allows searches of the form 'Show all links pointing to *.example.com'.
el_index_60
| MediaWiki版本： | 1.29 – 1.41 Gerrit change 954900 |
This is el_index truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index.
架构摘要
| MediaWiki版本： | ≥ 1.41 Gerrit change 954900 |
DESCRIBE externallinks;
+--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | el_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to_domain_index | varbinary(255) | NO | MUL | | | | el_to_path | blob | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.40 |
DESCRIBE externallinks;
+--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | el_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | | el_index_60 | varbinary(60) | NO | MUL | NULL | | | el_to_domain_index | varbinary(255) | NO | MUL | | | | el_to_path | blob | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.30 – 1.39 |
DESCRIBE externallinks;
+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | el_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | | el_index_60 | varbinary(60) | NO | MUL | NULL | | +-------------+------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.29 |
DESCRIBE externallinks;
+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | el_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | | el_index_60 | varbinary(60) | NO | MUL | | | +-------------+------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.22 – 1.28 |
DESCRIBE externallinks;
+----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | el_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | +----------+------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.10 – 1.21 |
DESCRIBE externallinks;
+----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+-------+ | el_from | int(10) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | +----------+------------------+------+-----+---------+-------+
| MediaWiki版本： | 1.6 – 1.9 |
DESCRIBE externallinks;
+----------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------+------+-----+---------+-------+ | el_from | int(8) unsigned | NO | MUL | 0 | | | el_to | blob | NO | MUL | NULL | | | el_index | blob | NO | MUL | NULL | | +----------+-----------------+------+-----+---------+-------+
Indexes
| MediaWiki版本： | ≥ 1.41 |
SHOW INDEX IN externallinks;
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | externallinks | 0 | PRIMARY | 1 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from | 1 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_to_domain_index_to_path | 1 | el_to_domain_index | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_to_domain_index_to_path | 2 | el_to_path | A | 0 | 60 | NULL | YES | BTREE | | | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| MediaWiki版本： | 1.40 |
SHOW INDEX IN externallinks;
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | externallinks | 0 | PRIMARY | 1 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from | 1 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_to | 1 | el_to | A | 0 | 60 | NULL | | BTREE | | | | externallinks | 1 | el_to | 2 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_index | 1 | el_index | A | 0 | 60 | NULL | | BTREE | | | | externallinks | 1 | el_index_60 | 1 | el_index_60 | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_index_60 | 2 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 1 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 2 | el_index_60 | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 3 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_to_domain_index_to_path | 1 | el_to_domain_index | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_to_domain_index_to_path | 2 | el_to_path | A | 0 | 60 | NULL | YES | BTREE | | | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| MediaWiki版本： | 1.30 – 1.39 |
SHOW INDEX IN externallinks;
+---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | externallinks | 0 | PRIMARY | 1 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from | 1 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from | 2 | el_to | A | 0 | 40 | NULL | | BTREE | | | | externallinks | 1 | el_to | 1 | el_to | A | 0 | 60 | NULL | | BTREE | | | | externallinks | 1 | el_to | 2 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_index | 1 | el_index | A | 0 | 60 | NULL | | BTREE | | | | externallinks | 1 | el_index_60 | 1 | el_index_60 | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_index_60 | 2 | el_id | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 1 | el_from | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 2 | el_index_60 | A | 0 | NULL | NULL | | BTREE | | | | externallinks | 1 | el_from_index_60 | 3 | el_id | A | 0 | NULL | NULL | | BTREE | | | +---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+