#####日期: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());