56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `e_from_list` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pri_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '',
`timestamp` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '时间戳',
`from_name` varchar(200) NOT NULL DEFAULT '' COMMENT '',
`from_time` int(11) unsigned DEFAULT '0' COMMENT '',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
PRIMARY KEY (`id`),
KEY `eid` (`pri_id`),
KEY `eidtime` (`pri_id`,`timestamp`),
KEY `eidtimefrom` (`pri_id`,`from_name`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=''