Manual:Querycache info table/zh

querycache_info table contains details of updates to cached special pages.

qci_type
Corresponds to a value

qci_timestamp
Timestamp of last update

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

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

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

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

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 |       |