帮忙急~!恢复时候出错
Too big column length for column 'shorttitle' (max = 255). Use BLOB instead CREATE TABLE `gcma_archives` ( `ID` int(11) unsigned NOT NULL default '0', `typeid` int(11) unsigned NOT NULL default '0', `typeid2` int(11) unsigned NOT NULL default '0', `sortrank` int(11) NOT NULL default '0', `iscommend` smallint(6) NOT NULL default '0', `ismake` smallint(6) NOT NULL default '0', `channel` int(11) NOT NULL default '1', `arcrank` smallint(6) NOT NULL default '0', `click` int(11) unsigned NOT NULL default '0', `money` smallint(6) NOT NULL default '0', `title` varchar(80) NOT NULL default '', `shorttitle` varchar(1000) NOT NULL default '', `color` varchar(10) NOT NULL default '', `writer` varchar(30) NOT NULL default '', `source` varchar(50) NOT NULL default '', `litpic` varchar(100) NOT NULL default '', `pubdate` int(11) NOT NULL default '0', `senddate` int(11) NOT NULL default '0', `arcatt` smallint(6) NOT NULL default '0', `adminID` int(11) NOT NULL default '0', `memberID` int(11) unsigned NOT NULL default '0', `description` varchar(250) NOT NULL default '', `keywords` varchar(60) NOT NULL default '', `templet` varchar(60) NOT NULL default '', `lastpost` int(11) NOT NULL default '0', `postnum` int(11) NOT NULL default '0', `redirecturl` varchar(150) NOT NULL default '', `mtype` int(11) NOT NULL default '0', `userip` varchar(20) NOT NULL default '', `locklikeid` smallint(6) NOT NULL default '0', `likeid` varchar(240) default '', `smalltypeid` smallint(6) NOT NULL default '0', `areaid` smallint(6) NOT NULL default '0', `areaid2` smallint(6) NOT NULL default '0', `sectorid` smallint(6) NOT NULL default '0', `sectorid2` smallint(6) NOT NULL default '0', `endtime` int(11) NOT NULL default '0', `digg` int(11) NOT NULL default '0', `diggtime` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `typeid` (`typeid`,`typeid2`,`sortrank`,`channel`,`arcrank`,`adminID`,`memberID`,`smalltypeid`,`areaid`,`areaid2`,`sectorid`,`sectorid2`,`senddate`) ) TYPE=MyISAM
|
|
|