大汗,恢复数据库错误

枫恋

呵呵
; w. I( H( j$ |; p* v有了啊

襄樊风景

  错误

! B5 X! ?5 S& M! W% S5 ISQL 查询 :  
+ |, h) c- Y8 r' E7 Z0 I% W( l
$ I# \/ {& o8 H0 NCREATE TABLE `pw_threads` (
2 z1 N: r  z3 i8 n- H0 C
; ]; ?" W2 M) w" u) [6 E`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
( h" B# H2 K1 m. f0 C`fid` smallint( 6 ) NOT NULL default '0',
`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
  b( p7 Y/ Q+ Z6 @8 C`author` char( 15 ) NOT NULL default '',
- \  D0 F4 X" y: D4 a3 V`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
`subject` char( 130 ) NOT NULL default '',
`ifmark` smallint( 6 ) NOT NULL default '0',
3 V0 Q) F6 p+ F; U: b" @3 Q! H2 P`ifcheck` tinyint( 1 ) NOT NULL default '0',
. B: |% x2 z6 a/ }`type` tinyint( 2 ) NOT NULL default '0',
`postdate` int( 10 ) unsigned NOT NULL default '0',
7 T% a# M4 S: X" j2 ?: u  d`lastpost` int( 10 ) unsigned NOT NULL default '0',
4 O( _- ?  a& J0 {; z% ~' Q`lastposter` char( 15 ) NOT NULL default '',
, D% O! i* }: f5 `0 U, a! I`hits` int( 10 ) NOT NULL default '0',
`replies` int( 10 ) NOT NULL default '0',
" z5 t( J1 B% {- O4 @  P7 w- e`topped` tinyint( 1 ) NOT NULL default '0',
`locked` tinyint( 1 ) NOT NULL default '0',
5 t* ~6 J2 Q* J5 j; L' j" e`digest` tinyint( 1 ) NOT NULL default '0',
; N5 U4 [2 Q+ N8 E`ifupload` tinyint( 1 ) NOT NULL default '0',
`pollid` int( 10 ) NOT NULL default '0',
% p% b6 q% ?  _! ]`ifmail` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `tid` ) ,
KEY `lastpost` ( `fid` , `topped` , `lastpost` ) ,
KEY `tid` ( `tid` , `postdate` ) ,
; b7 j( A) v* v5 bKEY `authorid` ( `authorid` ) ,
KEY `digest` ( `digest` ) ,
$ G, @1 c0 S9 Q( w# H8 Q* f* wKEY `type` ( `type` ) ,
KEY `postdate` ( `postdate` )
) TYPE = MYISAM AUTO_INCREMENT =6
5 p2 F0 g+ f" d. y$ n1 @- A( p. S
9 }% m, F9 m) N' KMySQL 返回:
2 ?! e2 y+ b) G) @

#1050 - Table 'pw_threads' already exists
* o  m! E1 I  z) {. U/ a* d/ b
[文档] · [返回]