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

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

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',

new TINYINT( 1 ) NOT NULL DEFAULT '0',

subject VARCHAR( 75 ) NOT NULL DEFAULT '',

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 ) ,

KEY msgtoid( msgtoid, folder, dateline ) ,

KEY msgfromid( msgfromid, folder, dateline ) ,

KEY RELATED( related ) ,

KEY getnum( msgtoid, folder, delstatus )

) TYPE = MYISAM ;

本文转自 jxwpx 51CTO博客，原文链接：http://blog.51cto.com/jxwpx/1257743，如需转载请自行联系原作者