===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; %%
%%(cl)
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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 | | |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
%%