menu table

Fields

Schema summary

 DESCRIBE menu;

+---------------+----------------------+------+-----+---------+----------------+
| 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 |
+----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_menu |          0 | PRIMARY     |            1 | menu_id     | A         |          48 |     NULL | NULL   |      | BTREE      |         |               |
| dev_menu |          0 | idx_user_id |            1 | user_id     | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| dev_menu |          0 | idx_user_id |            2 | page_id     | A         |          48 |     NULL | NULL   |      | BTREE      |         |               |
| dev_menu |          0 | idx_user_id |            3 | menu_lang   | A         |          48 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+