CREATE TABLE groups (
        id      mediumint auto_increment PRIMARY KEY NOT NULL,
        name    varchar(255) NOT NULL,
        description     mediumtext NOT NULL,
        isbuggroup      tinyint NOT NULL,
        userregexp      tinytext DEFAULT '' NOT NULL,
        isactive        tinyint DEFAULT 1 NOT NULL,
        icon_url        tinytext
) ENGINE = InnoDB CHARACTER SET utf8;