Manual:querycachetwo table
Jump to navigation
Jump to search
| ↑ Manual:Contents | MediaWiki database layout | querycachetwo table |
| MediaWiki version: | ≥ 1.9 |
The querycachetwo table is a table used for caching expensive grouped queries that need two links (for example double-redirects).
Fields[edit]
qcc_type[edit]
A key name, generally the base name of the special page.
qcc_value[edit]
Some sort of stored value. Sizes, counts...
qcc_namespace[edit]
Target namespace. Used in conjunction with qcc_title.
qcc_title[edit]
Target title. Used in conjunction with qcc_namespace.
qcc_namespacetwo[edit]
Target namespace2. Used in conjunction with qcc_titletwo.
qcc_titletwo[edit]
Target title2. Used in conjunction with qcc_namespacetwo.
Schema summary[edit]
| MediaWiki version: | ≥ 1.11 |
DESCRIBE querycachetwo;
+------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | qcc_type | varbinary(32) | NO | MUL | NULL | | | qcc_value | int(10) unsigned | NO | | 0 | | | qcc_namespace | int(11) | NO | | 0 | | | qcc_title | varbinary(255) | NO | | | | | qcc_namespacetwo | int(11) | NO | | 0 | | | qcc_titletwo | varbinary(255) | NO | | | | +------------------+------------------+------+-----+---------+-------+
| MediaWiki version: | 1.10 |
DESCRIBE querycachetwo;
+------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | qcc_type | varbinary(32) | NO | MUL | NULL | | | qcc_value | int(10) unsigned | NO | | 0 | | | qcc_namespace | int(11) | NO | | 0 | | | qcc_title | char(255) binary | NO | | NULL | | | qcc_namespacetwo | int(11) | NO | | 0 | | | qcc_titletwo | char(255) binary | NO | | NULL | | +------------------+------------------+------+-----+---------+-------+
| MediaWiki version: | 1.9 |
DESCRIBE querycachetwo;
+------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | qcc_type | char(32) | NO | MUL | NULL | | | qcc_value | int(5) unsigned | NO | | 0 | | | qcc_namespace | int(11) | NO | | 0 | | | qcc_title | char(255) binary | NO | | NULL | | | qcc_namespacetwo | int(11) | NO | | 0 | | | qcc_titletwo | char(255) binary | NO | | NULL | | +------------------+------------------+------+-----+---------+-------+
