3.7升级4.0 一点升级就出错
Table 'phome_ecms_flash' already exists CREATE TABLE `phome_ecms_flash` ( `id` int(11) NOT NULL auto_increment, `classid` smallint(6) NOT NULL default '0', `onclick` int(11) NOT NULL default '0', `newspath` varchar(50) NOT NULL default '', `keyboard` varchar(255) NOT NULL default '', `keyid` varchar(255) NOT NULL default '', `userid` int(11) NOT NULL default '0', `username` varchar(30) NOT NULL default '', `ztid` text NOT NULL, `checked` tinyint(1) NOT NULL default '0', `istop` tinyint(4) NOT NULL default '0', `truetime` int(11) NOT NULL default '0', `ismember` tinyint(1) NOT NULL default '0', `dokey` tinyint(1) NOT NULL default '0', `userfen` int(11) NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `titlecolor` varchar(10) NOT NULL default '', `titlefont` varchar(255) NOT NULL default '', `titleurl` varchar(200) NOT NULL default '', `filename` varchar(60) NOT NULL default '', `filenameqz` varchar(28) NOT NULL default '', `fh` tinyint(1) NOT NULL default '0', `groupid` smallint(6) NOT NULL default '0', `newstempid` smallint(6) NOT NULL default '0', `plnum` int(11) NOT NULL default '0', `firsttitle` tinyint(1) NOT NULL default '0', `checkuser` text NOT NULL, `docheckuser` text NOT NULL, `viewcheckuser` text NOT NULL, `returncheck` tinyint(1) NOT NULL default '0', `notdocheckuser` text NOT NULL, `totaldown` int(11) NOT NULL default '0', `title` varchar(200) NOT NULL default '', `newstime` datetime NOT NULL default '0000-00-00 00:00:00', `titlepic` varchar(200) NOT NULL default '', `wplay` tinyint(1) NOT NULL default '0', `flashsay` text NOT NULL, `flashwriter` varchar(30) NOT NULL default '', `star` tinyint(1) NOT NULL default '0', `filesize` varchar(30) NOT NULL default '', `flashurl` varchar(255) NOT NULL default '', `email` varchar(80) NOT NULL default '', `width` varchar(20) NOT NULL default '', `height` varchar(20) NOT NULL default '', `closepl` tinyint(1) NOT NULL default '0', `havehtml` tinyint(1) NOT NULL default '0', `lastdotime` int(11) NOT NULL default '0', `haveaddfen` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `classid` (`classid`) ) TYPE=MyISAM
|
|
|