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

admin

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
# MySQL 返回的查询结果为空(即零行)。
: I4 E/ [4 T4 n. F: E4 MCREATE TABLE uc_pms(
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
  h, w! ]* d. W" A( p; nmsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
: u7 x% E4 a( q/ u; a+ E2 J& Vmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
  ?6 `! D' U  S4 {- \new TINYINT( 1 ) NOT NULL DEFAULT '0',
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
" E! {7 v/ f; c, g+ s9 idateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
message TEXT NOT NULL ,
4 S' D: K. e% r! |% Adelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
, R: k- A) N6 D4 c; s  jrelated INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( pmid ) ,
9 P$ I- P. H$ @% [" @3 y' Z1 ~: u* \KEY msgtoid( msgtoid, folder, dateline ) ,
! V) ?8 ]* f  j6 r- g' yKEY msgfromid( msgfromid, folder, dateline ) ,
' u' p  |0 l& w: U% Z  vKEY RELATED( related ) ,
& Z8 ~& J6 Y8 G# |& t0 PKEY getnum( msgtoid, folder, delstatus )
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。
. q+ ~1 z1 q- h# n* U3 y
  N: t9 K2 Q3 `$ {