usergroup table

Fields

Schema summary

 DESCRIBE usergroup;

6.0

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| group_id     | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| group_name   | varchar(100)        | NO   | UNI | NULL    |                |
| description  | varchar(255)        | NO   |     | NULL    |                |
| moderator_id | int(10) unsigned    | NO   |     | 0       |                |
| created      | datetime            | YES  |     | NULL    |                |
| is_system    | tinyint(1) unsigned | NO   |     | 0       |                |
| open         | tinyint(1) unsigned | NO   |     | 0       |                |
| active       | tinyint(1) unsigned | NO   |     | 0       |                |
+--------------+---------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN usergroup;

+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table           | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_usergroup |          0 | PRIMARY  |            1 | group_id    | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_usergroup |          0 | idx_name |            1 | group_name  | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+