Error:Table 'ucenter.uc_pms' doesn't exist解决方法

admin

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
; S- S: T( m8 s  d* R# |( D2 P# MySQL 返回的查询结果为空(即零行)。
CREATE TABLE uc_pms(
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
9 j5 C4 Q+ S. Y! ^! nmsgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
  h/ m* F) c. j$ R! ?folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
6 S4 g6 r* l0 ]9 Onew TINYINT( 1 ) NOT NULL DEFAULT '0',
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
: N. b9 }1 r3 E  S- c# C* t6 nmessage TEXT NOT NULL ,
7 D1 P: v% U4 n; Xdelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( pmid ) ,
0 U% s4 M  G2 J% _, V0 s0 c9 qKEY msgtoid( msgtoid, folder, dateline ) ,
7 G9 v$ v2 ~6 b4 i+ Y, uKEY msgfromid( msgfromid, folder, dateline ) ,
KEY RELATED( related ) ,
KEY getnum( msgtoid, folder, delstatus )
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。

+ J. Y# m4 w, [2 k; P! l0 r2 v