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

admin

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
# MySQL 返回的查询结果为空(即零行)。
CREATE TABLE uc_pms(
' |5 n5 v* ~5 |pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
* U8 n* Z; l' d' d& h' ^msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
' Q2 F5 o4 ^+ p+ w+ }" a1 Jmsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
: F0 T. A2 o4 x, P* {/ ]msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
new TINYINT( 1 ) NOT NULL DEFAULT '0',
9 X  F( x/ x5 Lsubject VARCHAR( 75 ) NOT NULL DEFAULT '',
dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
message TEXT NOT NULL ,
" X  h3 c+ [, L3 z" qdelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( pmid ) ,
1 u4 F5 b* D& N: UKEY msgtoid( msgtoid, folder, dateline ) ,
/ r5 Y1 Z/ w/ kKEY msgfromid( msgfromid, folder, dateline ) ,
KEY RELATED( related ) ,
' @" X1 {* y5 r. Z" W+ sKEY getnum( msgtoid, folder, delstatus )
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。

3 p' A; n9 a2 ~( L7 `" ?