Fields
Schema summary
DESCRIBE acl;
+-----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| page_id | int(10) unsigned | NO | PRI | 0 | |
| privilege | varchar(10) | NO | PRI | NULL | |
| list | text | NO | | NULL | |
+-----------+------------------+------+-----+---------+-------+
Indices
SHOW INDEX IN acl;
+---------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_acl | 0 | idx_page_id | 1 | page_id | A | 390 | NULL | NULL | | BTREE | | |
| dev_acl | 0 | idx_page_id | 2 | privilege | A | 781 | NULL | NULL | | BTREE | | |
+---------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+