Jump to content

Extension:TitleKey/titlekey table

From mediawiki.org

Fields

[edit]

tk_page

[edit]

Reference to page.page_id.

tk_namespace

[edit]

A denormalized copy of the namespace for filtering.

tk_key

[edit]

Normalized title with namespace prefix, case-folded, in space form.

Schema

[edit]
mysql> describe titlekey;
+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| tk_page      | int(10) unsigned | NO   | PRI | NULL    |       |
| tk_namespace | int(11)          | NO   | MUL | NULL    |       |
| tk_key       | varbinary(255)   | NO   |     | NULL    |       |
+--------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)