大汗,恢复数据库错误

枫恋

呵呵
有了啊

襄樊风景

  错误

SQL 查询 :  

CREATE TABLE `pw_threads` (
3 G* p" X! b/ a# I. {4 ?
& d) `& P) g/ l5 a, `& p`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`fid` smallint( 6 ) NOT NULL default '0',
; d* J5 v% L: `; U`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
`author` char( 15 ) NOT NULL default '',
3 a5 m6 y8 N* ?3 F) k`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
- \8 ~/ Y- o  j: f1 r9 d`subject` char( 130 ) NOT NULL default '',
`ifmark` smallint( 6 ) NOT NULL default '0',
( p' A: C1 a3 J- a+ e. T* v`ifcheck` tinyint( 1 ) NOT NULL default '0',
`type` tinyint( 2 ) NOT NULL default '0',
. z$ g% T% [" _8 p* \4 @9 L" q2 F`postdate` int( 10 ) unsigned NOT NULL default '0',
6 D3 ^+ X1 U, ~2 F4 ~  G`lastpost` int( 10 ) unsigned NOT NULL default '0',
5 }- p2 ]) G5 n1 ]. {! M`lastposter` char( 15 ) NOT NULL default '',
4 J, |- m+ s0 ~$ r`hits` int( 10 ) NOT NULL default '0',
`replies` int( 10 ) NOT NULL default '0',
2 B; ~8 k. u* Q' Y`topped` tinyint( 1 ) NOT NULL default '0',
) C% w: |, b  v`locked` tinyint( 1 ) NOT NULL default '0',
5 M1 ~+ T  j2 Z2 T`digest` tinyint( 1 ) NOT NULL default '0',
; I' f7 r& C0 ~) i6 e# V" f& m& A`ifupload` tinyint( 1 ) NOT NULL default '0',
`pollid` int( 10 ) NOT NULL default '0',
8 D- j3 M: i5 d9 {5 w6 G`ifmail` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `tid` ) ,
. H: F/ ^$ b& S! e- p% c! NKEY `lastpost` ( `fid` , `topped` , `lastpost` ) ,
KEY `tid` ( `tid` , `postdate` ) ,
KEY `authorid` ( `authorid` ) ,
: v: Y% I: z* M% A& F6 cKEY `digest` ( `digest` ) ,
KEY `type` ( `type` ) ,
, B% {& ^9 ?' F" \/ qKEY `postdate` ( `postdate` )
) `4 s/ u/ e* [# w' I0 e9 i! V# G) TYPE = MYISAM AUTO_INCREMENT =6
! N: ~( J/ D; a8 ]" H8 \
. K1 V2 m% Q+ q( E5 a; zMySQL 返回:
; V7 K4 a# j3 V/ O# }
. N& m6 _% X$ V4 y# F, q
#1050 - Table 'pw_threads' already exists
) n1 l) H5 f; ]
9 E. J# |$ q2 e- D* y* m0 S  L[文档] · [返回]