Extension:TitleKey/titlekey table

Fields

tk_page

Reference to page.page_id.

tk_namespace

A denormalized copy of the namespace for filtering.

tk_key

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

Schema

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)