CREATE TABLE " . PREFIX . "_usergroups (
`id` smallint(5) NOT NULL auto_increment,
`group_name` varchar(32) NOT NULL default '',
`allow_cats` text NOT NULL,
`allow_adds` tinyint(1) NOT NULL default '1',
`cat_add` text NOT NULL,
`allow_admin` tinyint(1) NOT NULL default '0',
`allow_addc` tinyint(1) NOT NULL default '0',
`allow_editc` tinyint(1) NOT NULL default '0',
`allow_delc` tinyint(1) NOT NULL default '0',
`edit_allc` tinyint(1) NOT NULL default '0',
`del_allc` tinyint(1) NOT NULL default '0',
`moderation` tinyint(1) NOT NULL default '0',
`allow_all_edit` tinyint(1) NOT NULL default '0',
`allow_edit` tinyint(1) NOT NULL default '0',
`allow_pm` tinyint(1) NOT NULL default '0',
`max_pm` smallint(5) NOT NULL default '0',
`max_foto` smallint(5) NOT NULL default '0',
`allow_files` tinyint(1) NOT NULL default '1',
`allow_hide` tinyint(1) NOT NULL default '1',
`allow_short` tinyint(1) NOT NULL default '0',
`time_limit` tinyint(1) NOT NULL default '0',
`rid` smallint(5) NOT NULL default '0',
`allow_fixed` tinyint(1) NOT NULL default '0',
`allow_feed` tinyint(1) NOT NULL default '1',
`allow_search` tinyint(1) NOT NULL default '1',
`allow_poll` tinyint(1) NOT NULL default '1',
`allow_main` tinyint(1) NOT NULL default '1',
`captcha` tinyint(1) NOT NULL default '0',
`icon` varchar(200) NOT NULL default '',
`allow_modc` tinyint(1) NOT NULL default '0',
`allow_rating` tinyint(1) NOT NULL default '1',
`allow_offline` tinyint(1) NOT NULL default '0',
`allow_image_upload` tinyint(1) NOT NULL default '0',
`allow_file_upload` tinyint(1) NOT NULL default '0',
`allow_signature` tinyint(1) NOT NULL default '0',
`allow_url` tinyint(1) NOT NULL default '1',
`news_sec_code` tinyint(1) NOT NULL default '1',
`allow_image` tinyint(1) NOT NULL default '0',
`max_signature` SMALLINT(6) NOT NULL default '0',
`max_info` SMALLINT(6) NOT NULL default '0',
`admin_addnews` tinyint(1) NOT NULL default '0',
`admin_editnews` tinyint(1) NOT NULL default '0',
`admin_comments` tinyint(1) NOT NULL default '0',
`admin_categories` tinyint(1) NOT NULL default '0',
`admin_editusers` tinyint(1) NOT NULL default '0',
`admin_wordfilter` tinyint(1) NOT NULL default '0',
`admin_xfields` tinyint(1) NOT NULL default '0',
`admin_userfields` tinyint(1) NOT NULL default '0',
`admin_static` tinyint(1) NOT NULL default '0',
`admin_editvote` tinyint(1) NOT NULL default '0',
`admin_newsletter` tinyint(1) NOT NULL default '0',
`admin_blockip` tinyint(1) NOT NULL default '0',
`admin_banners` tinyint(1) NOT NULL default '0',
`admin_rss` tinyint(1) NOT NULL default '0',
`admin_iptools` tinyint(1) NOT NULL default '0',
`admin_rssinform` tinyint(1) NOT NULL default '0',
`admin_googlemap` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci