大汗,恢复数据库错误

枫恋

呵呵
有了啊

襄樊风景

  错误

% Q. a% w/ C# pSQL 查询 :  

CREATE TABLE `pw_threads` (
9 e7 H9 x) l) z! k9 j/ H% T. {
`tid` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`fid` smallint( 6 ) NOT NULL default '0',
( G' G: z. W  n) L+ K6 k0 ^" l" o`icon` tinyint( 2 ) NOT NULL default '0',
`titlefont` char( 15 ) NOT NULL default '',
3 f1 z7 g+ o8 y" }0 F2 ~2 y`author` char( 15 ) NOT NULL default '',
6 S% Z, C8 l& _9 i9 O3 Y2 O`authorid` mediumint( 8 ) unsigned NOT NULL default '0',
) U7 k) ^6 S7 W$ |; R# ^/ [5 E% j`subject` char( 130 ) NOT NULL default '',
" }8 G; W) v- b; ?, }; E8 C+ B4 P`ifmark` smallint( 6 ) NOT NULL default '0',
( S  q1 u. ?8 h/ _4 s`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 '',
  d1 q/ V& P+ G* ?; |`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',
( j. e! d" D( u8 X9 o1 J* w% y3 l  N`pollid` int( 10 ) NOT NULL default '0',
3 N7 [, {3 K% \1 a`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` ) ,
# q6 r. T, W4 ~1 u+ w0 e, `KEY `postdate` ( `postdate` )
7 I5 S, S$ A" P/ `* ?) TYPE = MYISAM AUTO_INCREMENT =6

MySQL 返回:


#1050 - Table 'pw_threads' already exists

[文档] · [返回]