重建这个表吧
可以试试这个sql语句:
注意:操作前请备份好数据
- 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',
- 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,
- exempt tinyint(1) unsigned NOT NULL,
- allowsendpm tinyint(1) NOT NULL DEFAULT '1',
- PRIMARY KEY (groupid),
- KEY creditsrange (creditshigher,creditslower)
- ) TYPE=MyISAM;
复制代码 |