CREATE TABLE `[#DB_PREFIX#]user_action_history` (
`history_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`uid` int(11) NOT NULL COMMENT '用户id',
`associate_type` tinyint(1) DEFAULT NULL COMMENT '关联类型: 1 问题 2 回答 3 评论 4 话题',
`associate_action` smallint(3) DEFAULT NULL COMMENT '操作类型',
`associate_id` int(11) DEFAULT NULL COMMENT '关联ID',
`add_time` int(10) DEFAULT NULL COMMENT '添加时间',
`associate_attached` int(11) DEFAULT NULL,
`anonymous` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '是否匿名',
`fold_status` TINYINT( 1 ) NULL DEFAULT '0',
PRIMARY KEY (`history_id`),
KEY `add_time` (`add_time`),
KEY `uid` (`uid`),
KEY `associate_id` (`associate_id`),
KEY `anonymous` (`anonymous`),
KEY `fold_status` (`fold_status`),
KEY `associate` (`associate_type`,`associate_action`),
KEY `associate_attached` (`associate_attached`),
KEY `associate_with_id` (`associate_id`, `associate_type`, `associate_action`),
KEY `associate_with_uid` (`uid`, `associate_type`, `associate_action`)
) ENGINE=[#DB_ENGINE#] DEFAULT CHARSET=utf8 COMMENT='用户操作记录';

CREATE TABLE `[#DB_PREFIX#]user_action_history_data` (
`history_id` int(11) unsigned NOT NULL,
`associate_content` text,
`associate_attached` text,
`addon_data` TEXT NULL DEFAULT NULL COMMENT '附加数据',
PRIMARY KEY (`history_id`)
) ENGINE=[#DB_ENGINE#] DEFAULT CHARSET=utf8;

CREATE TABLE `[#DB_PREFIX#]user_action_history_fresh` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`history_id` int(11) NOT NULL,
`associate_id` int(11) NOT NULL,
`associate_type` tinyint(1) NOT NULL,
`associate_action` smallint(3) NOT NULL,
`add_time` int(10) NOT NULL DEFAULT '0',
`uid` int(10) NOT NULL DEFAULT '0',
`anonymous` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `associate` (`associate_type`,`associate_action`),
KEY `add_time` (`add_time`),
KEY `uid` (`uid`),
KEY `history_id` (`history_id`),
KEY `associate_with_id` (`id`,`associate_type`,`associate_action`),
KEY `associate_with_uid` (`uid`,`associate_type`,`associate_action`),
KEY `anonymous` (`anonymous`)
) ENGINE=[#DB_ENGINE#] DEFAULT CHARSET=utf8;