Podręcznik:Tabela externallinks
↑ Podręcznik:Spis treści | Opis i struktura bazy danych MediaWiki | externallinks table |
Wersja MediaWiki: | ≥ 1.6 |
Tabela externallinks jest miejscem, gdzie MediaWiki przechowuje dane o linkach zewnętrznych.
Pola
el_id
Wersja MediaWiki: | ≥ 1.22 |
Klucz podstawowy. Presently not used for anything, but will help with online schema changes.
el_from
Identyfikator strony, która zawiera link.
el_to
Adres URL It is passed to the browser.
el_index
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
Wersja MediaWiki: | ≥ 1.29 |
This is el_index truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index.
Podsumowanie struktury
Wersja MediaWiki: | ≥ 1.30 |
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 | | +-------------+------------------+------+-----+---------+----------------+
Wersja 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 | | | +-------------+------------------+------+-----+---------+----------------+
Wersje 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 | | +----------+------------------+------+-----+---------+----------------+
Wersje 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 | | +----------+------------------+------+-----+---------+-------+
Wersje 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 | | +----------+-----------------+------+-----+---------+-------+