Manual:Externallinks table/ja

externallinks テーブルでは、MediaWiki が外部リンクを格納して追跡します. このテーブルは MediaWiki 1.5 で導入されました.

el_id
主キーです. Presently not used for anything, but will help with online schema changes.

el_from
The page identifier of the referring wiki page.

el_to
The actual URL itself. It is passed to the browser.

el_index
This is the same URL as  search-optimised: username and password information is stripped, and the other components are reversed for faster searching, so   becomes , which allows searches of the form 'Show all links pointing to *.example.com'.

現在のバージョン
mysql> 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    |                |

以前のバージョン
mysql> 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    |       |

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

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

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field   | Type            | Null | Key | Default | Extra |
 * el_from | int(8) unsigned |      | MUL | 0       |       |
 * el_to   | blob            |      | MUL |         |       |
 * el_index | blob           |      | MUL |         |       |