mirror of
https://github.com/ccfish86/sctalk.git
synced 2026-10-16 21:21:46 +08:00
ccfish86
629 lines
30 KiB
SQL
629 lines
30 KiB
SQL
# ************************************************************
|
||
# 根据TeamTalk开发的JAVA（spring cloud）版服务器用
|
||
# Version 2017-05-17
|
||
#
|
||
# Database: teamtalk
|
||
# Generation Time: 2017-05-17 10:10:39 +0000
|
||
# ************************************************************
|
||
|
||
|
||
DROP DATABASE IF EXISTS teamtalk;
|
||
CREATE DATABASE teamtalk DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
||
USE teamtalk;
|
||
|
||
|
||
DROP TABLE IF EXISTS `im_admin`;
|
||
|
||
CREATE TABLE `im_admin` (
|
||
`id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
|
||
`uname` varchar(40) NOT NULL COMMENT '用户名',
|
||
`pwd` varchar(256) NOT NULL COMMENT '密码',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '用户状态 0 :正常 1:删除 可扩展',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间´',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间´',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
||
LOCK TABLES `im_admin` WRITE;
|
||
/*!40000 ALTER TABLE `im_admin` DISABLE KEYS */;
|
||
|
||
INSERT INTO `im_admin` (`id`, `uname`, `pwd`, `status`, `created`, `updated`)
|
||
VALUES
|
||
(1,'admin','21232f297a57a5a743894a0e4a801fc3',0,0,0);
|
||
|
||
/*!40000 ALTER TABLE `im_admin` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
|
||
# Dump of table im_audio
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_audio`;
|
||
|
||
CREATE TABLE `im_audio` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`from_id` bigint(20) unsigned NOT NULL COMMENT '发送者Id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收者Id',
|
||
`path` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '语音存储的地址',
|
||
`size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
|
||
`duration` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '语音时长',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_from_id_to_id` (`from_id`,`to_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
# Dump of table im_depart
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_depart`;
|
||
|
||
CREATE TABLE `im_depart` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '部门id',
|
||
`depart_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '部门名称',
|
||
`priority` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '显示优先级',
|
||
`parent_id` bigint(20) unsigned NOT NULL COMMENT '上级部门id',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_depart_name` (`depart_name`),
|
||
KEY `idx_priority_status` (`priority`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
|
||
# Dump of table im_discovery
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_discovery`;
|
||
|
||
CREATE TABLE `im_discovery` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`item_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '名称',
|
||
`item_url` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'URL',
|
||
`item_priority` int(11) unsigned NOT NULL COMMENT '显示优先级',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_item_name` (`item_name`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
# Dump of table im_group
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group`;
|
||
|
||
CREATE TABLE `im_group` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(256) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '群名称',
|
||
`avatar` varchar(256) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '群头像',
|
||
`creator` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者用户id',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '群组类型，1-固定;2-临时群',
|
||
`user_cnt` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '成员人数',
|
||
`status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除,0-正常，1-删除',
|
||
`version` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '群版本号',
|
||
`last_chated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后聊天时间',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_name` (`name`(191)),
|
||
KEY `idx_creator` (`creator`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群信息';
|
||
|
||
|
||
# Dump of table im_group_member
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_member`;
|
||
|
||
CREATE TABLE `im_group_member` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '群Id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '是否退出群，0-正常，1-已退出',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_user_id_status` (`group_id`,`user_id`,`status`),
|
||
KEY `idx_user_id_status_updated` (`user_id`,`status`,`updated`),
|
||
KEY `idx_group_id_updated` (`group_id`,`updated`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户和群的关系表';
|
||
|
||
|
||
# Dump of table im_group_message_0
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_0`;
|
||
|
||
CREATE TABLE `im_group_message_0` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
|
||
# Dump of table im_group_message_1
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_1`;
|
||
|
||
CREATE TABLE `im_group_message_1` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_group_message_2
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_2`;
|
||
|
||
CREATE TABLE `im_group_message_2` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_group_message_3
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_3`;
|
||
|
||
CREATE TABLE `im_group_message_3` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_group_message_4
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_4`;
|
||
|
||
CREATE TABLE `im_group_message_4` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_group_message_5
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_5`;
|
||
|
||
CREATE TABLE `im_group_message_5` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_group_message_6
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_6`;
|
||
|
||
CREATE TABLE `im_group_message_6` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
|
||
# Dump of table im_group_message_7
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_7`;
|
||
|
||
CREATE TABLE `im_group_message_7` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_8`;
|
||
|
||
CREATE TABLE `im_group_message_8` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
DROP TABLE IF EXISTS `im_group_message_9`;
|
||
|
||
CREATE TABLE `im_group_message_9` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`group_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '群消息类型,101为群语音,2为文本',
|
||
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '消息状态',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_group_id_status_created` (`group_id`,`status`,`created`),
|
||
KEY `idx_group_id_msg_id_status_created` (`group_id`,`msg_id`,`status`,`created`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='IM群消息表';
|
||
|
||
|
||
# Dump of table im_message_0
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_0`;
|
||
|
||
CREATE TABLE `im_message_0` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
# Dump of table im_message_1
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_1`;
|
||
|
||
CREATE TABLE `im_message_1` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
|
||
# Dump of table im_message_2
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_2`;
|
||
|
||
CREATE TABLE `im_message_2` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
# Dump of table im_message_3
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_3`;
|
||
|
||
CREATE TABLE `im_message_3` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_message_4
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_4`;
|
||
|
||
CREATE TABLE `im_message_4` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
|
||
# Dump of table im_message_5
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_5`;
|
||
|
||
CREATE TABLE `im_message_5` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_message_6
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_6`;
|
||
|
||
CREATE TABLE `im_message_6` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_message_7
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_7`;
|
||
|
||
CREATE TABLE `im_message_7` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_message_8
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_8`;
|
||
|
||
CREATE TABLE `im_message_8` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_message_9
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_message_9`;
|
||
|
||
CREATE TABLE `im_message_9` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`relate_id` bigint(20) unsigned NOT NULL COMMENT '用户的关系id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '发送用户的id',
|
||
`to_id` bigint(20) unsigned NOT NULL COMMENT '接收用户的id',
|
||
`msg_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
|
||
`content` varchar(4096) COLLATE utf8mb4_bin DEFAULT '' COMMENT '消息内容',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '消息类型',
|
||
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1被删除',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_relate_id_status_created` (`relate_id`,`status`,`created`),
|
||
KEY `idx_relate_id_status_msg_id_created` (`relate_id`,`status`,`msg_id`,`created`),
|
||
KEY `idx_from_id_to_id_created` (`user_id`,`to_id`,`status`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|
||
# Dump of table im_recent_session
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_recent_session`;
|
||
|
||
CREATE TABLE `im_recent_session` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
|
||
`peer_id` bigint(20) unsigned NOT NULL COMMENT '对方id',
|
||
`type` tinyint(2) unsigned DEFAULT '0' COMMENT '类型，1-用户,2-群组',
|
||
`status` tinyint(2) unsigned DEFAULT '0' COMMENT '用户:0-正常, 1-用户A删除,群组:0-正常, 1-被删除',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_user_id_peer_id_status_updated` (`user_id`,`peer_id`,`status`,`updated`),
|
||
KEY `idx_user_id_peer_id_type` (`user_id`,`peer_id`,`type`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
||
|
||
# Dump of table im_relation_ship
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_relation_ship`;
|
||
|
||
CREATE TABLE `im_relation_ship` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`small_id` bigint(20) unsigned NOT NULL COMMENT '用户A的id',
|
||
`big_id` bigint(20) unsigned NOT NULL COMMENT '用户B的id',
|
||
`status` tinyint(2) unsigned DEFAULT '0' COMMENT '用户:0-正常, 1-用户A删除,群组:0-正常, 1-被删除',
|
||
`created` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_small_id_big_id_status_updated` (`small_id`,`big_id`,`status`,`updated`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
||
|
||
# Dump of table im_User
|
||
# ------------------------------------------------------------
|
||
|
||
DROP TABLE IF EXISTS `im_user`;
|
||
|
||
CREATE TABLE `im_user` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
|
||
`sex` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1男2女0未知',
|
||
`name` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户名',
|
||
`domain` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '拼音',
|
||
`nick` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '花名,绰号等',
|
||
`password` varchar(256) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码',
|
||
`salt` varchar(4) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '混淆码',
|
||
`phone` varchar(11) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '手机号码',
|
||
`email` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'email',
|
||
`avatar` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '自定义用户头像',
|
||
`depart_id` bigint(20) unsigned NOT NULL COMMENT '所属部门Id',
|
||
`status` tinyint(2) unsigned DEFAULT '0' COMMENT '1. 试用期 2. 正式 3. 离职 4.实习',
|
||
`created` int(11) unsigned NOT NULL COMMENT '创建时间',
|
||
`updated` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`push_shield_status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0关闭勿扰 1开启勿扰',
|
||
`sign_info` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '个性签名',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_domain` (`domain`),
|
||
KEY `idx_name` (`name`),
|
||
KEY `idx_phone` (`phone`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
|