最新消息:iOS编程开发交流群(6906921) iOS编程开发交流群欢迎iOS开发编程爱好及学习者加入!

dz论坛出现uc_pms' doesn't exist

Discuz 天狐 2265浏览 0评论

新建表:

DROP TABLE IF EXISTS uc_pms;

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;

转载请注明:天狐博客 » dz论坛出现uc_pms' doesn't exist

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址