大汗,恢复数据库错误

枫恋

呵呵
有了啊

襄樊风景

  错误
9 @6 y6 h$ j6 V- E( C; @" a
SQL 查询 :  

: g7 ?; \$ D: L) ?8 R6 UCREATE TABLE `pw_threads` (
$ I9 B* P6 d9 M8 |
* w% d; W8 r* W`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`fid` smallint( 6 ) NOT NULL default '0',
/ p9 P; q% t$ D$ }/ v6 O! v`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
- B8 f7 X2 D8 |5 w: t`author` char( 15 ) NOT NULL default '',
- Q% h% {5 p2 E6 \`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
, j& ~" o" V, r" ^3 I`subject` char( 130 ) NOT NULL default '',
& p& s9 ?0 J% ?0 z  u`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',
9 h6 O* l& s$ o2 B`topped` tinyint( 1 ) NOT NULL default '0',
+ L) S; v' @: f2 S+ Q# }`locked` tinyint( 1 ) NOT NULL default '0',
4 k% d; Z2 ]. n( @7 ]/ s3 X`digest` tinyint( 1 ) NOT NULL default '0',
`ifupload` tinyint( 1 ) NOT NULL default '0',
`pollid` int( 10 ) NOT NULL default '0',
3 L) e- K% f3 t+ X* I`ifmail` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `tid` ) ,
8 i) R, H5 y+ w% A' I! wKEY `lastpost` ( `fid` , `topped` , `lastpost` ) ,
KEY `tid` ( `tid` , `postdate` ) ,
KEY `authorid` ( `authorid` ) ,
+ X, o0 P! R% u* o, N2 p- @KEY `digest` ( `digest` ) ,
KEY `type` ( `type` ) ,
0 C+ @0 @$ |) J$ x, KKEY `postdate` ( `postdate` )
) TYPE = MYISAM AUTO_INCREMENT =6
/ X9 B3 @% m0 A: b- B$ D7 {
MySQL 返回:

' O1 Q4 |- W# ^) e  N# U7 a$ W/ ]
( w* \' x, ]% M  E( P#1050 - Table 'pw_threads' already exists

[文档] · [返回]