menu table

Fields

Schema summary

 DESCRIBE menu;	

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(5)           | 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         |         105 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_menu    |            1 | user_id     | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_menu    |            2 | page_id     | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_menu    |            3 | menu_lang   | A         |         105 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          1 | idx_user_id |            1 | user_id     | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          1 | idx_page_id |            1 | page_id     | A         |          26 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          1 | idx_lang    |            1 | menu_lang   | A         |          52 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+