有了啊
大汗,恢复数据库错误
错误SQL 查询 :
CREATE TABLE `pw_threads` (
`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`fid` smallint( 6 ) NOT NULL default '0',
`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
`author` char( 15 ) NOT NULL default '',
`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
`subject` char( 130 ) NOT NULL default '',
`ifmark` smallint( 6 ) NOT NULL default '0',
`ifcheck` tinyint( 1 ) NOT NULL default '0',
`type` tinyint( 2 ) NOT NULL default '0',
`postdate` int( 10 ) unsigned NOT NULL default '0',
`lastpost` int( 10 ) unsigned NOT NULL default '0',
`lastposter` char( 15 ) NOT NULL default '',
`hits` int( 10 ) NOT NULL default '0',
`replies` int( 10 ) NOT NULL default '0',
`topped` tinyint( 1 ) NOT NULL default '0',
`locked` tinyint( 1 ) NOT NULL default '0',
`digest` tinyint( 1 ) NOT NULL default '0',
`ifupload` tinyint( 1 ) NOT NULL default '0',
`pollid` int( 10 ) NOT NULL default '0',
`ifmail` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `tid` ) ,
KEY `lastpost` ( `fid` , `topped` , `lastpost` ) ,
KEY `tid` ( `tid` , `postdate` ) ,
KEY `authorid` ( `authorid` ) ,
KEY `digest` ( `digest` ) ,
KEY `type` ( `type` ) ,
KEY `postdate` ( `postdate` )
) TYPE = MYISAM AUTO_INCREMENT =6
MySQL 返回:
#1050 - Table 'pw_threads' already exists
[文档] · [返回]
页:
1
[2]