WackoWiki: log table

https://wackowiki.org/doc     Version: 2 (22.06.2020 11:09)

log 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(2)           | NO   |     | NULL    |                |
| menu_title    | varchar(100)         | NO   |     | NULL    |                |
| menu_position | smallint(2) unsigned | NO   |     | 0       |                |
| converted     | tinyint(1) 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         |          33 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_user_id |            1 | user_id     | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_user_id |            2 | page_id     | A         |          33 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_menu |          0 | idx_user_id |            3 | menu_lang   | A         |          33 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+