Manual:linktarget数据表
↑ 手册:索引 | MediaWiki数据库布局 | linktarget表 |
MediaWiki版本: | ≥ 1.38 |
This table stores a page namespace-title tuples, each one with a unique integer ID. This table is used for referenced page titles in tables that track links to pages: templatelinks , pagelinks tables.
This table contains immutable rows, which means only new rows are inserted, and never deleted or updated during normal wiki operation. However, the pruneUnusedLinkTargetRows.php maintenance script can be run to delete unused entries.
Access to this table from code is handled by instances of the class MediaWiki\Linker\LinkTargetLookup interface.
During schema migration, this table is filled using the migrateLinksTable.php maintenance script.
$wgTemplateLinksSchemaMigrationStage
controls whether data is read/written to this table.
Fields
lt_id
Primary key.
lt_namespace
Namespace of the link target.
lt_title
Text part of link target excluding namespace.
Schema summary
MediaWiki版本: | ≥ 1.38 |
DESCRIBE linktarget;
+--------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+----------------+ | lt_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | lt_namespace | int(11) | NO | MUL | NULL | | | lt_title | varbinary(255) | NO | | NULL | | +--------------+---------------------+------+-----+---------+----------------+
Indexes
MediaWiki版本: | ≥ 1.38 Gerrit change 754989 |
SHOW INDEX IN linktarget;
+------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | linktarget | 0 | PRIMARY | 1 | lt_id | A | 0 | NULL | NULL | | BTREE | | | | linktarget | 0 | lt_namespace_title | 1 | lt_namespace | A | 0 | NULL | NULL | | BTREE | | | | linktarget | 0 | lt_namespace_title | 2 | lt_title | A | 0 | NULL | NULL | | BTREE | | | +------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+