Manuel:Table externallinks
| ↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table externallinks |
| Version de MediaWiki : | ≥ 1.6 |
La table externallinks est l'endroit où MediaWiki range et suit les liens externes. Note unless $wgRegisterInternalExternals is enabled (it is disabled by default), links to the same server are not recorded.
Les liens qui dépendent du protocole sont rangés deux fois dans la cette table conformément à r102951.
Champs
el_id
| Version de MediaWiki : | ≥ 1.22 |
Clé primaire. Actuellement ne sert à rien, mais sera utile lors des modifications en ligne du schéma.
el_from
L' ID de la page qui référence la page wiki.
el_to_domain_index
| Version de MediaWiki : | ≥ 1.40 |
Ceci est similaire à el_index mais inclut uniquement la spécification du protocole et le domaine inversé, de sorte que http://en.wikipedia.org devient http://org.wikipedia.en..
el_to_path
| Version de MediaWiki : | ≥ 1.40 |
Uniquement le chemin de el_to.
Exemple :
/wiki/Main_Page
el_to
| Versions de MediaWiki : | 1.6 – 1.41 Gerrit change 954900 |
L'URL actuelle elle même. Elle est passée au navigateur.
el_index
| Versions de MediaWiki : | 1.6 – 1.41 Gerrit change 954900 |
C'est la même URL que el_to optimisée pour la recherche : les informations relatives au nom d'utilisateur et le mot de passe sont enlevées et les autres composants sont inversés pour accélérer la recherche, donc http://user:password@sub.example.com/page.html devient http://com.example.sub./page.html, qui permet les recherches de la forme 'Afficher tous les liens pointant vers *.example.com'.
el_index_60
| Versions de MediaWiki : | 1.29 – 1.41 Gerrit change 954900 |
C'est le champ el_index tronqué à 60 octets pour permettre les requêtes de tri non prises en charge par une indexation partielle.
Résumé du schéma
| Version de 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 | | +--------------------+------------------+------+-----+---------+----------------+
| Version de 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 | | +--------------------+------------------+------+-----+---------+----------------+
| Versions de 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 | | +-------------+------------------+------+-----+---------+----------------+
| Version de 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 | | | +-------------+------------------+------+-----+---------+----------------+
| Versions de 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 | | +----------+------------------+------+-----+---------+----------------+
| Versions de 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 | | +----------+------------------+------+-----+---------+-------+
| Versions de 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 | | +----------+-----------------+------+-----+---------+-------+
Les index
| Version de 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 | | | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Version de 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 | | | +---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Versions de 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 | | | +---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+