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      |         |               |
+---------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+