不知道什么意识!! Invalid default value for 'system' 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(4) NOT NULL default 'private', `grouptitle` char(15) 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(3) NOT NULL default '', `groupavatar` char(30) 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', `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(50) NOT NULL default '', `raterange` char(75) NOT NULL default '', `tradetaxtype` tinyint(1) NOT NULL default '1', `tradetaxs` smallint(6) unsigned NOT NULL default '0', `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 default '0', `allowmagics` tinyint(1) unsigned NOT NULL default '1', `maxmagicsweight` smallint(6) unsigned NOT NULL default '100', `allowbiobbcode` tinyint(1) unsigned NOT NULL default '0', `allowbioimgcode` tinyint(1) unsigned NOT NULL default '0', `maxbiosize` smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (`groupid`), KEY `creditsrange` (`creditshigher`,`creditslower`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=gb2312
|