CREATE TABLE groups (
g_id int(3) unsigned NOT NULL auto_increment,
g_view_board tinyint(1) default NULL,
g_mem_info tinyint(1) default NULL,
g_other_topics tinyint(1) default NULL,
g_use_search tinyint(1) default NULL,
g_edit_profile tinyint(1) default NULL,
g_post_new_topics tinyint(1) default NULL,
g_reply_own_topics tinyint(1) default NULL,
g_reply_other_topics tinyint(1) default NULL,
g_edit_posts tinyint(1) default NULL,
g_delete_own_posts tinyint(1) default NULL,
g_open_close_posts tinyint(1) default NULL,
g_delete_own_topics tinyint(1) default NULL,
g_post_polls tinyint(1) default NULL,
g_vote_polls tinyint(1) default NULL,
g_use_pm tinyint(1) default 0,
g_is_supmod tinyint(1) default NULL,
g_access_cp tinyint(1) default NULL,
g_title varchar(32) NOT NULL default '',
g_append_edit tinyint(1) default NULL,
g_access_offline tinyint(1) default NULL,
g_avoid_q tinyint(1) default NULL,
g_avoid_flood tinyint(1) default NULL,
g_icon text,
g_attach_max bigint(20) default NULL,
prefix varchar(250) default NULL,
suffix varchar(250) default NULL,
g_max_messages int(5) default 50,
g_max_mass_pm int(5) default 0,
g_search_flood mediumint(6) default 20,
g_edit_cutoff int(10) default 0,
g_promotion varchar(10) default '-1&-1',
g_hide_from_list tinyint(1) default 0,
g_post_closed tinyint(1) default 0,
g_perm_id varchar(255) NOT NULL default '',
g_photo_max_vars varchar(200) default '100:200:300',
g_dohtml tinyint(1) NOT NULL default 0,
g_edit_topic tinyint(1) NOT NULL default 0,
g_bypass_badwords tinyint(1) NOT NULL default 0,
g_can_msg_attach tinyint(1) NOT NULL default 0,
g_attach_per_post int(10) NOT NULL default 0,
g_topic_rate_setting smallint(2) NOT NULL default 0,
g_dname_changes int(3) NOT NULL default 0,
g_dname_date int(5) NOT NULL default 0,
g_mod_preview tinyint(1) unsigned NOT NULL default 0,
g_rep_max_positive mediumint(8) unsigned NOT NULL default 0,
g_rep_max_negative mediumint(8) unsigned NOT NULL default 0,
g_signature_limits varchar(255) default NULL,
g_can_add_friends tinyint(1) NOT NULL default 1,
g_hide_online_list tinyint(1) NOT NULL default 0,
g_bitoptions int(10) unsigned NOT NULL default 0,
g_pm_perday smallint(6) NOT NULL default 0,
g_mod_post_unit int(5) UNSIGNED NOT NULL default 0,
g_ppd_limit int(5) UNSIGNED NOT NULL default 0,
g_ppd_unit int(5) UNSIGNED NOT NULL default 0,
g_displayname_unit int(5) UNSIGNED NOT NULL default 0,
g_sig_unit int(5) UNSIGNED NOT NULL default 0,
g_pm_flood_mins INT(5) UNSIGNED NOT NULL default 0,
g_max_notifications MEDIUMINT NOT NULL DEFAULT 0,
g_max_bgimg_upload INT(10) NOT NULL default 0,
PRIMARY KEY (g_id)
);