cache table

Fields

Schema summary

 DESCRIBE cache;

+------------+------------------+------+-----+-------------------+-----------------------------+
| Field      | Type             | Null | Key | Default           | Extra                       |
+------------+------------------+------+-----+-------------------+-----------------------------+
| cache_id   | int(10) unsigned | NO   | PRI | NULL              | auto_increment              |
| name       | char(40)         | NO   | MUL | NULL              |                             |
| method     | varchar(20)      | NO   |     | NULL              |                             |
| query      | varchar(100)     | NO   |     | NULL              |                             |
| cache_lang | varchar(2)       | NO   |     | NULL              |                             |
| cache_time | timestamp        | NO   | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+------------+------------------+------+-----+-------------------+-----------------------------+

Indices

 SHOW INDEX IN cache;

+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table     | Non_unique | Key_name       | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_cache |          0 | PRIMARY        |            1 | cache_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_cache |          1 | name           |            1 | name        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_cache |          1 | idx_cache_time |            1 | cache_time  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+