friendship-parent/doc/ddl/table/V4.5.sql

-- 2020-08-10 用户陪聊房间同步数据
-- user_accompany_chat_message_queue_detail
CREATE TABLE `friendship`.`user_accompany_chat_message_queue_detail`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL COMMENT '用户id',
  `message_id` varchar(32) NULL COMMENT '消息id',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  `content` varchar(500) NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001000 COMMENT = '同步卿卿陪聊信息表';

-- 2020-08-13 10:00
CREATE TABLE `friendship`.`topic_tag_recommend_title` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `tag_id` bigint(20) NULL COMMENT '标签id',
    `tag_name` varchar(32) NULL COMMENT '标签名',
    `recommend_topic_title` varchar(32) NULL COMMENT '推荐话题名',
    `create_time` timestamp(0) NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001210 COMMENT = '相关标签推荐话题名';