在ucenter的表中创建 uc_pms表即可
表结构
- -- 表的结构 `uc_pms`
- --
- CREATE TABLE IF NOT EXISTS `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',
- `fromappid` smallint(6) 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`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ; // carset=utf8