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

admin

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
- g4 E! s" |% k! W) k0 v1 l# MySQL 返回的查询结果为空(即零行)。
CREATE TABLE uc_pms(
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
8 ]& O% |; S5 Y3 b/ k) Qnew TINYINT( 1 ) NOT NULL DEFAULT '0',
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
% M7 S3 Z( M1 ~dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
message TEXT NOT NULL ,
delstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( pmid ) ,
$ \5 X3 P+ r# M, xKEY msgtoid( msgtoid, folder, dateline ) ,
& l) f+ |' C4 |; _KEY msgfromid( msgfromid, folder, dateline ) ,
3 L2 _3 x* E9 DKEY RELATED( related ) ,
KEY getnum( msgtoid, folder, delstatus )
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。

, b: Y; {( F4 W9 P( q5 j. \' W! d