usergroup table

Fields

Schema summary

 DESCRIBE usergroup;

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| group_id     | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| group_name   | varchar(100)        | NO   | UNI | NULL    |                |
| group_lang   | varchar(2)          | NO   |     | 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 |
+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_usergroup |          0 | PRIMARY  |            1 | group_id    | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| dev_usergroup |          0 | idx_name |            1 | group_name  | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+