log table
Fields
Schema summary
DESCRIBE menu;
6.1
+---------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------------------+------+-----+---------+----------------+ | menu_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | 0 | | | page_id | int(10) unsigned | NO | MUL | 0 | | | menu_lang | varchar(5) | NO | MUL | | | | menu_title | varchar(255) | NO | | | | | menu_position | smallint(2) unsigned | NO | | 0 | | +---------------+----------------------+------+-----+---------+----------------+
6.0
+---------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------------------+------+-----+---------+----------------+ | menu_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | MUL | 0 | | | page_id | int(10) unsigned | NO | | 0 | | | menu_lang | varchar(2) | NO | | NULL | | | menu_title | varchar(100) | NO | | NULL | | | menu_position | smallint(2) unsigned | NO | | 0 | | +---------------+----------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN menu;
+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wacko_menu | 0 | PRIMARY | 1 | menu_id | A | 120 | NULL | NULL | | BTREE | | | | wacko_menu | 0 | idx_menu | 1 | user_id | A | 2 | NULL | NULL | | BTREE | | | | wacko_menu | 0 | idx_menu | 2 | page_id | A | 8 | NULL | NULL | | BTREE | | | | wacko_menu | 0 | idx_menu | 3 | menu_lang | A | 120 | NULL | NULL | | BTREE | | | | wacko_menu | 1 | idx_user_id | 1 | user_id | A | 2 | NULL | NULL | | BTREE | | | | wacko_menu | 1 | idx_page_id | 1 | page_id | A | 8 | NULL | NULL | | BTREE | | | | wacko_menu | 1 | idx_lang | 1 | menu_lang | A | 60 | NULL | NULL | | BTREE | | | +------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+