大汗,恢复数据库错误

枫恋

呵呵
有了啊

襄樊风景

  错误

SQL 查询 :  
# W0 b3 y1 C' X* a
8 ]$ a1 \& N: H0 x/ Z6 X: b4 ?CREATE TABLE `pw_threads` (
+ d8 F8 k: W7 U, T; a6 Q% `4 V
: d) S, ]3 c6 z`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
3 }* }% j, ^. [1 {4 F0 b" H2 X; b`fid` smallint( 6 ) NOT NULL default '0',
`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
5 v1 G. n" A5 [/ _`author` char( 15 ) NOT NULL default '',
; G8 _% R2 U% V. p4 u: c`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
`subject` char( 130 ) NOT NULL default '',
  `- s. o& A& |) s7 K; w`ifmark` smallint( 6 ) NOT NULL default '0',
`ifcheck` tinyint( 1 ) NOT NULL default '0',
, L9 M! ?# C$ x# r' B`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 '',
) B" M$ G. I9 G: C7 q`hits` int( 10 ) NOT NULL default '0',
`replies` int( 10 ) NOT NULL default '0',
`topped` tinyint( 1 ) NOT NULL default '0',
6 t# W9 F# ~" r$ ]- e& n1 P`locked` tinyint( 1 ) NOT NULL default '0',
$ Q9 y: h1 w( f. A`digest` tinyint( 1 ) NOT NULL default '0',
`ifupload` tinyint( 1 ) NOT NULL default '0',
% `+ V( Q' k- A" w- b`pollid` int( 10 ) NOT NULL default '0',
`ifmail` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `tid` ) ,
! _& B5 `3 E; ?% Y$ A+ JKEY `lastpost` ( `fid` , `topped` , `lastpost` ) ,
KEY `tid` ( `tid` , `postdate` ) ,
KEY `authorid` ( `authorid` ) ,
3 O. |8 {0 s0 d+ o0 x# L% WKEY `digest` ( `digest` ) ,
KEY `type` ( `type` ) ,
KEY `postdate` ( `postdate` )
) TYPE = MYISAM AUTO_INCREMENT =6
& {% n4 C3 r) H
MySQL 返回:
$ [4 Q- S1 h1 U8 K* m( b- L( s4 `
5 ?& I" o6 i9 W7 o
4 B* ^4 k4 n1 S#1050 - Table 'pw_threads' already exists

# _3 e! c; b# ~4 S[文档] · [返回]