使用SpringBoot和WebSocket搭建实时通信（第二部分）

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for im_chat -- ---------------------------- DROP TABLE IF EXISTS `im_chat`; CREATE TABLE `im_chat` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` bigint NOT NULL COMMENT '用户id', `chat_type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '聊天类型：01-私聊 02-群聊', `target_id` bigint NOT NULL COMMENT '聊天对象id', `top_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '置顶标志', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '聊天会话' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for im_friend -- ---------------------------- DROP TABLE IF EXISTS `im_friend`; CREATE TABLE `im_friend` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` bigint NOT NULL COMMENT '用户id', `friend_user_id` bigint NOT NULL COMMENT '好友用户id', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '好友备注', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '好友' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for im_group -- ---------------------------- DROP TABLE IF EXISTS `im_group`; CREATE TABLE `im_group` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '群名称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '群头像', `master` bigint NULL DEFAULT NULL COMMENT '群主', `manager` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '群管理', `notice` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '群组' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for im_group_user -- ---------------------------- DROP TABLE IF EXISTS `im_group_user`; CREATE TABLE `im_group_user` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `group_id` bigint NOT NULL COMMENT '群id ', `user_id` bigint NOT NULL COMMENT '用户id', `nick_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '群昵称', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '群成员' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for im_message -- ---------------------------- DROP TABLE IF EXISTS `im_message`; CREATE TABLE `im_message` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `chat_id` bigint NULL DEFAULT NULL COMMENT '聊天会话id', `sender_id` bigint NULL DEFAULT NULL COMMENT '发送者id', `message_type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息类型：00-系统、02-文本、03-图片、04-音频、05-视频', `message` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for im_message_receiver -- ---------------------------- DROP TABLE IF EXISTS `im_message_receiver`; CREATE TABLE `im_message_receiver` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `message_id` bigint NOT NULL COMMENT '消息id', `receiver_id` bigint NOT NULL COMMENT '接收者id', `read_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '已读标志', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '接收者消息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号', `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码', `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女）', `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像地址', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标志', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息' ROW_FORMAT = DYNAMIC; SET FOREIGN_KEY_CHECKS = 1;