mirror of
https://github.com/lakaola/chat-api.git
synced 2026-05-07 14:27:41 +08:00
216 lines
8.4 KiB
SQL
216 lines
8.4 KiB
SQL
/*
|
|
SQLyog Ultimate v11.25 (64 bit)
|
|
MySQL - 5.7.21-log : Database - boot-im
|
|
*********************************************************************
|
|
*/
|
|
|
|
|
|
/*!40101 SET NAMES utf8 */;
|
|
|
|
/*!40101 SET SQL_MODE=''*/;
|
|
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/`boot-im` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
|
|
|
|
USE `boot-im`;
|
|
|
|
/*Table structure for table `chat_apply` */
|
|
|
|
DROP TABLE IF EXISTS `chat_apply`;
|
|
|
|
CREATE TABLE `chat_apply` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`from_id` bigint(20) DEFAULT NULL COMMENT '发起id',
|
|
`to_id` bigint(20) DEFAULT NULL COMMENT '接收id',
|
|
`target_id` bigint(20) DEFAULT NULL COMMENT '目标id',
|
|
`apply_type` char(1) DEFAULT NULL COMMENT '申请类型1好友2群组',
|
|
`apply_status` char(1) DEFAULT NULL COMMENT '申请状态0无1同意2拒绝3忽略',
|
|
`apply_source` char(1) DEFAULT NULL COMMENT '申请来源',
|
|
`reason` varchar(200) DEFAULT NULL COMMENT '理由',
|
|
`create_time` datetime DEFAULT NULL COMMENT '申请时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='好友申请表';
|
|
|
|
/*Table structure for table `chat_collect` */
|
|
|
|
DROP TABLE IF EXISTS `chat_collect`;
|
|
|
|
CREATE TABLE `chat_collect` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`collect_type` varchar(20) DEFAULT NULL COMMENT '收藏类型',
|
|
`content` longtext COMMENT '内容',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收藏表';
|
|
|
|
/*Table structure for table `chat_feedback` */
|
|
|
|
DROP TABLE IF EXISTS `chat_feedback`;
|
|
|
|
CREATE TABLE `chat_feedback` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`images` varchar(2000) DEFAULT NULL COMMENT '图片',
|
|
`content` longtext COMMENT '内容',
|
|
`version` varchar(20) DEFAULT '1.0.0' COMMENT '提交版本',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='建议反馈';
|
|
|
|
/*Table structure for table `chat_friend` */
|
|
|
|
DROP TABLE IF EXISTS `chat_friend`;
|
|
|
|
CREATE TABLE `chat_friend` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`from_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`to_id` bigint(20) DEFAULT NULL COMMENT '好友id',
|
|
`remark` varchar(32) DEFAULT NULL COMMENT '备注',
|
|
`black` char(1) DEFAULT 'N' COMMENT '黑名单',
|
|
`source` char(1) DEFAULT NULL COMMENT '好友来源',
|
|
`top` char(1) DEFAULT 'N' COMMENT '是否置顶',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `idx_user` (`from_id`,`to_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='好友表';
|
|
|
|
/*Table structure for table `chat_group` */
|
|
|
|
DROP TABLE IF EXISTS `chat_group`;
|
|
|
|
CREATE TABLE `chat_group` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`name` varchar(50) DEFAULT NULL COMMENT '群名',
|
|
`notice` varchar(200) DEFAULT NULL COMMENT '公告',
|
|
`portrait` longtext COMMENT '头像',
|
|
`master` bigint(20) DEFAULT NULL COMMENT '群主',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='群组';
|
|
|
|
/*Table structure for table `chat_group_info` */
|
|
|
|
DROP TABLE IF EXISTS `chat_group_info`;
|
|
|
|
CREATE TABLE `chat_group_info` (
|
|
`info_id` bigint(20) NOT NULL COMMENT '主键',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`group_id` bigint(20) DEFAULT NULL COMMENT '群组id',
|
|
`top` char(1) DEFAULT 'N' COMMENT '是否置顶',
|
|
`disturb` char(1) DEFAULT 'N' COMMENT '是否免打扰',
|
|
`keep_group` char(1) DEFAULT 'N' COMMENT '是否保存群组',
|
|
`create_time` datetime DEFAULT NULL COMMENT '加入时间',
|
|
PRIMARY KEY (`info_id`),
|
|
UNIQUE KEY `idx_group` (`user_id`,`group_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
/*Table structure for table `chat_msg` */
|
|
|
|
DROP TABLE IF EXISTS `chat_msg`;
|
|
|
|
CREATE TABLE `chat_msg` (
|
|
`id` bigint(20) NOT NULL COMMENT '消息主键',
|
|
`from_id` bigint(20) DEFAULT NULL COMMENT '发送人',
|
|
`to_id` bigint(20) DEFAULT NULL COMMENT '接收人',
|
|
`msg_type` varchar(20) DEFAULT NULL COMMENT '消息类型',
|
|
`talk_type` varchar(20) DEFAULT NULL COMMENT '聊天类型',
|
|
`content` longtext COMMENT '消息内容',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='聊天消息';
|
|
|
|
/*Table structure for table `chat_topic` */
|
|
|
|
DROP TABLE IF EXISTS `chat_topic`;
|
|
|
|
CREATE TABLE `chat_topic` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`topic_type` varchar(20) DEFAULT NULL COMMENT '类型',
|
|
`content` varchar(2000) DEFAULT NULL COMMENT '内容',
|
|
`location` varchar(200) DEFAULT NULL COMMENT '经纬度',
|
|
`create_time` datetime DEFAULT NULL COMMENT '时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主题';
|
|
|
|
/*Table structure for table `chat_topic_like` */
|
|
|
|
DROP TABLE IF EXISTS `chat_topic_like`;
|
|
|
|
CREATE TABLE `chat_topic_like` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`topic_id` bigint(20) DEFAULT NULL COMMENT '帖子id',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`has_like` char(1) DEFAULT 'Y' COMMENT '是否点赞',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='帖子点赞';
|
|
|
|
/*Table structure for table `chat_topic_reply` */
|
|
|
|
DROP TABLE IF EXISTS `chat_topic_reply`;
|
|
|
|
CREATE TABLE `chat_topic_reply` (
|
|
`reply_id` bigint(20) NOT NULL COMMENT '主键',
|
|
`reply_type` char(1) DEFAULT NULL COMMENT '回复类型1帖子2用户',
|
|
`reply_status` char(1) DEFAULT NULL COMMENT '回复状态',
|
|
`content` longtext COMMENT '回复内容',
|
|
`topic_id` bigint(20) DEFAULT NULL COMMENT '帖子id',
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
|
|
`target_id` bigint(20) DEFAULT NULL COMMENT '目标id',
|
|
`create_time` datetime DEFAULT NULL COMMENT '回复时间',
|
|
PRIMARY KEY (`reply_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='帖子回复表';
|
|
|
|
/*Table structure for table `chat_user` */
|
|
|
|
DROP TABLE IF EXISTS `chat_user`;
|
|
|
|
CREATE TABLE `chat_user` (
|
|
`user_id` bigint(20) NOT NULL COMMENT '主键',
|
|
`phone` varchar(20) DEFAULT NULL COMMENT '手机号',
|
|
`chat_no` varchar(32) DEFAULT NULL COMMENT '微聊号码',
|
|
`nick_name` varchar(32) DEFAULT NULL COMMENT '昵称',
|
|
`token` varchar(32) DEFAULT NULL COMMENT '用户token',
|
|
`gender` varchar(1) DEFAULT '1' COMMENT '性别1男0女',
|
|
`portrait` varchar(2000) DEFAULT NULL COMMENT '头像',
|
|
`intro` varchar(200) DEFAULT NULL COMMENT '介绍',
|
|
`cover` varchar(2000) DEFAULT NULL COMMENT '封面',
|
|
`provinces` varchar(20) DEFAULT NULL COMMENT '省份',
|
|
`city` varchar(20) DEFAULT NULL COMMENT '城市',
|
|
`salt` varchar(4) DEFAULT NULL COMMENT '盐',
|
|
`password` varchar(32) DEFAULT NULL COMMENT '密码',
|
|
`create_time` datetime DEFAULT NULL COMMENT '注册时间',
|
|
`version` varchar(20) DEFAULT '1.0.0' COMMENT '版本信息',
|
|
`deleted` tinyint(1) DEFAULT '0' COMMENT '注销0正常null注销',
|
|
`deleted_time` datetime DEFAULT NULL COMMENT '注销时间',
|
|
PRIMARY KEY (`user_id`),
|
|
UNIQUE KEY `idx_phone` (`phone`,`deleted`),
|
|
UNIQUE KEY `idx_no` (`chat_no`,`deleted_time`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
|
|
|
|
/*Table structure for table `chat_version` */
|
|
|
|
DROP TABLE IF EXISTS `chat_version`;
|
|
|
|
CREATE TABLE `chat_version` (
|
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
|
`version` varchar(20) DEFAULT NULL COMMENT '版本',
|
|
`url` varchar(2000) DEFAULT NULL COMMENT '地址',
|
|
`content` longtext COMMENT '内容',
|
|
`descr` varchar(200) DEFAULT NULL COMMENT '描述',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='版本';
|
|
|
|
/*Data for the table `chat_version` */
|
|
|
|
insert into `chat_version`(`id`,`version`,`url`,`content`,`descr`) values (1,'1.0.0','http://im.q3z3.com/public/am.html','我是用户协议','用户协议'),(2,'1.0.0','http://im.q3z3.com/public/im.apk','我是安卓包','安卓升级包'),(3,'1.0.0','https://www.baidu.com/3','我是iOS包','iOS升级包');
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|