Manual:Querycache info table

↑ Manual:Contents

MediaWiki database layout

Querycache info table

querycache_info table contains details of updates to cached special pages.

MediaWiki version:

1.18

+---------------+---------------+------+-----+----------------+-------+
| Field         | Type          | Null | Key | Default        | Extra |
+---------------+---------------+------+-----+----------------+-------+
| qci_type      | varbinary(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)      | NO   |     | 19700101000000 |       |
+---------------+---------------+------+-----+----------------+-------+

MediaWiki version:

1.12

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

MediaWiki version:

1.11

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | binary(14)  | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

MediaWiki version:

1.9

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

MediaWiki version:

1.8

DESCRIBE querycache_info; in MediaWiki 1.8 gives the following:

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+