DROP TABLE IF EXISTS cdb_usergroups;
CREATE TABLE cdb_usergroups (
groupid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
radminid tinyint(3) NOT NULL DEFAULT '0',
`type` enum('system','special','member') NOT NULL DEFAULT 'member',
system char(8) NOT NULL DEFAULT 'private',
grouptitle char(30) NOT NULL DEFAULT '',
creditshigher int(10) NOT NULL DEFAULT '0',
creditslower int(10) NOT NULL DEFAULT '0',
stars tinyint(3) NOT NULL DEFAULT '0',
color char(7) NOT NULL DEFAULT '',
groupavatar char(60) NOT NULL DEFAULT '',
readaccess tinyint(3) unsigned NOT NULL DEFAULT '0',
allowvisit tinyint(1) NOT NULL DEFAULT '0',
allowpost tinyint(1) NOT NULL DEFAULT '0',
allowreply tinyint(1) NOT NULL DEFAULT '0',
allowpostpoll tinyint(1) NOT NULL DEFAULT '0',
allowpostreward tinyint(1) NOT NULL DEFAULT '0',
allowposttrade tinyint(1) NOT NULL DEFAULT '0',
allowpostactivity tinyint(1) NOT NULL DEFAULT '0',
allowpostvideo tinyint(1) NOT NULL DEFAULT '0',
allowdirectpost tinyint(1) NOT NULL DEFAULT '0',
allowgetattach tinyint(1) NOT NULL DEFAULT '0',
allowpostattach tinyint(1) NOT NULL DEFAULT '0',
allowvote tinyint(1) NOT NULL DEFAULT '0',
allowmultigroups tinyint(1) NOT NULL DEFAULT '0',
allowsearch tinyint(1) NOT NULL DEFAULT '0',
allowavatar tinyint(1) NOT NULL DEFAULT '0',
allowcstatus tinyint(1) NOT NULL DEFAULT '0',
allowuseblog tinyint(1) NOT NULL DEFAULT '0',
allowinvisible tinyint(1) NOT NULL DEFAULT '0',
allowtransfer tinyint(1) NOT NULL DEFAULT '0',
allowsetreadperm tinyint(1) NOT NULL DEFAULT '0',
allowsetattachperm tinyint(1) NOT NULL DEFAULT '0',
allowhidecode tinyint(1) NOT NULL DEFAULT '0',
allowhtml tinyint(1) NOT NULL DEFAULT '0',
allowcusbbcode tinyint(1) NOT NULL DEFAULT '0',
allowanonymous tinyint(1) NOT NULL DEFAULT '0',
allownickname tinyint(1) NOT NULL DEFAULT '0',
allowsigbbcode tinyint(1) NOT NULL DEFAULT '0',
allowsigimgcode tinyint(1) NOT NULL DEFAULT '0',
allowviewpro tinyint(1) NOT NULL DEFAULT '0',
allowviewstats tinyint(1) NOT NULL DEFAULT '0',
disableperiodctrl tinyint(1) NOT NULL DEFAULT '0',
reasonpm tinyint(1) NOT NULL DEFAULT '0',
maxprice smallint(6) unsigned NOT NULL DEFAULT '0',
maxpmnum smallint(6) unsigned NOT NULL DEFAULT '0',
maxsigsize smallint(6) unsigned NOT NULL DEFAULT '0',
maxattachsize mediumint(8) unsigned NOT NULL DEFAULT '0',
maxsizeperday int(10) unsigned NOT NULL DEFAULT '0',
maxpostsperhour tinyint(3) unsigned NOT NULL DEFAULT '0',
attachextensions char(100) NOT NULL DEFAULT '',
raterange char(150) NOT NULL DEFAULT '',
mintradeprice smallint(6) unsigned NOT NULL DEFAULT '1',
maxtradeprice smallint(6) unsigned NOT NULL DEFAULT '0',
minrewardprice smallint(6) NOT NULL DEFAULT '1',
maxrewardprice smallint(6) NOT NULL DEFAULT '0',
magicsdiscount tinyint(1) NOT NULL,
allowmagics tinyint(1) unsigned NOT NULL,
maxmagicsweight smallint(6) unsigned NOT NULL,
allowbiobbcode tinyint(1) unsigned NOT NULL DEFAULT '0',
allowbioimgcode tinyint(1) unsigned NOT NULL DEFAULT '0',
maxbiosize smallint(6) unsigned NOT NULL DEFAULT '0',
allowinvite tinyint(1) NOT NULL DEFAULT '0',
allowmailinvite tinyint(1) NOT NULL DEFAULT '0',
maxinvitenum tinyint(3) unsigned NOT NULL DEFAULT '0',
inviteprice smallint(6) unsigned NOT NULL DEFAULT '0',
maxinviteday smallint(6) unsigned NOT NULL DEFAULT '0',
allowpostdebate tinyint(1) NOT NULL DEFAULT '0',
tradestick tinyint(1) unsigned NOT NULL,
PRIMARY KEY (groupid),
KEY creditsrange (creditshigher,creditslower)
) TYPE=MyISAM AUTO_INCREMENT=16; |