config table
Fields
Schema summary
DESCRIBE config;
6.0
+--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | config_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | config_name | varchar(100) | NO | UNI | NULL | | | config_value | mediumtext | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN config;
+--------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wacko_config | 0 | PRIMARY | 1 | config_id | A | 199 | NULL | NULL | | BTREE | | | | wacko_config | 0 | idx_config_name | 1 | config_name | A | 199 | NULL | NULL | | BTREE | | | +--------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+