
#####日期:2021-09-08
#####提交人:徐永茂
#####sql 会员表新增表(关注,取消关注记录表)
#####sql语句
CREATE TABLE `member_attention_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `attention_uid` bigint(20) NOT NULL COMMENT '关注人id',
  `attentioned_uid` bigint(20) NOT NULL COMMENT '被关注人id',
  `attention_type` tinyint(4) NOT NULL COMMENT '关注类型：1 ：关注 2：取消关注',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_attention_type` (`attention_type`) USING BTREE,
  KEY `idx_attentioned_uid` (`attentioned_uid`) USING BTREE,
  KEY `idx_attention_uid` (`attention_uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.2.4.0',NOW());