Manual:Externallinks table/zh

externallinks表是MediaWiki存放与跟踪外部鏈接的地方.

el_id
主键. 現在沒有任何用途，但可以用於在線模式更改.

el_from
引用此鏈接的wiki頁面的page id.

el_to
實際的URL. 它會傳送給瀏覧器.

el_index
This is the same URL as  search-optimized: 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'.

el_index_60
This is el_index truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index.

@todo Drop the default once this is deployed everywhere and code is populating it.

架构摘要
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    |                |

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

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

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

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