init_data.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80035 (8.0.35)
 Source Host           : localhost:3306
 Source Schema         : jig_spring

 Target Server Type    : MySQL
 Target Server Version : 80035 (8.0.35)
 File Encoding         : 65001

 Date: 07/11/2025 14:07:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for conversation
-- ----------------------------
DROP TABLE IF EXISTS `conversation`;
CREATE TABLE `conversation`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '会话ID',
  `type` tinyint(1) NOT NULL COMMENT '会话类型: 1=单聊, 2=群聊',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会话名称(群聊时有用, 单聊可为空)',
  `group_avatar` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会话头像，群聊用',
  `unique_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一键: 单聊=userId小的在前_userId大的在后, 群聊=groupId',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会话表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of conversation
-- ----------------------------
INSERT INTO `conversation` VALUES (1, 1, NULL, NULL, '3_4', 1, 1, 3, NULL, '2025-08-20 11:24:09', '2025-08-20 11:24:09', '192.168.3.5');

-- ----------------------------
-- Table structure for conversation_member
-- ----------------------------
DROP TABLE IF EXISTS `conversation_member`;
CREATE TABLE `conversation_member`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `conversation_id` bigint NOT NULL COMMENT '会话ID',
  `user_id` bigint NOT NULL COMMENT '成员用户ID',
  `muted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否免打扰',
  `pinned` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否置顶',
  `unread_count` int NOT NULL DEFAULT 0 COMMENT '未读消息数',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会话成员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of conversation_member
-- ----------------------------
INSERT INTO `conversation_member` VALUES (1, 1, 3, 0, 0, 0, 1, 2, 3, 3, '2025-08-22 14:50:17', '2025-08-20 11:24:09', '192.168.3.5');
INSERT INTO `conversation_member` VALUES (2, 1, 4, 0, 0, 10, 1, 11, 3, 3, '2025-11-06 17:23:53', '2025-08-20 11:24:09', '192.168.3.5');

-- ----------------------------
-- Table structure for friend
-- ----------------------------
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `friend_id` bigint NOT NULL,
  `remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` tinyint NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of friend
-- ----------------------------

-- ----------------------------
-- Table structure for friend_request
-- ----------------------------
DROP TABLE IF EXISTS `friend_request`;
CREATE TABLE `friend_request`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `from_user_id` bigint NOT NULL,
  `to_user_id` bigint NOT NULL,
  `verify_message` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` tinyint NULL DEFAULT 0,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of friend_request
-- ----------------------------

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` tinyint NOT NULL,
  `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息内容',
  `sender_id` bigint NOT NULL COMMENT '消息发送者id',
  `receiver_id` bigint NOT NULL COMMENT '消息接收者id',
  `file_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件地址',
  `conversation_id` bigint NOT NULL COMMENT '会话id',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (1, 0, '消息1[:100]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 11:24:09', '2025-08-20 11:24:09', '192.168.3.5');
INSERT INTO `message` VALUES (2, 0, '消息2[:101]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 11:24:14', '2025-08-20 11:24:14', '192.168.3.5');
INSERT INTO `message` VALUES (3, 0, '消息3[:111]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 11:24:20', '2025-08-20 11:24:20', '192.168.3.5');
INSERT INTO `message` VALUES (4, 0, '消息4[:116]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 11:24:28', '2025-08-20 11:24:28', '192.168.3.5');
INSERT INTO `message` VALUES (5, 0, '消息5', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:33:29', '2025-08-20 14:33:29', '192.168.3.5');
INSERT INTO `message` VALUES (6, 0, '消息6[:109][:110][:111][:117][:116][:115][:114][:113][:112]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:37:29', '2025-08-20 14:37:29', '192.168.3.5');
INSERT INTO `message` VALUES (7, 0, '消息7[:100][:101][:103][:104][:104]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:37:49', '2025-08-20 14:37:49', '192.168.3.5');
INSERT INTO `message` VALUES (8, 0, '消息8[:108][:108][:108][:108]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:37:59', '2025-08-20 14:37:59', '192.168.3.5');
INSERT INTO `message` VALUES (9, 0, '消息9[:102][:102][:102][:102][:102]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:38:17', '2025-08-20 14:38:17', '192.168.3.5');
INSERT INTO `message` VALUES (10, 0, '[:101]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:49:21', '2025-08-20 14:49:21', '192.168.3.5');
INSERT INTO `message` VALUES (11, 0, '[:102]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:50:47', '2025-08-20 14:50:47', '192.168.3.5');
INSERT INTO `message` VALUES (12, 0, '[:102]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:51:19', '2025-08-20 14:51:19', '192.168.3.5');
INSERT INTO `message` VALUES (13, 0, '消息test', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 14:52:16', '2025-08-20 14:52:16', '192.168.3.5');
INSERT INTO `message` VALUES (14, 0, '消息test2', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:09:23', '2025-08-20 15:09:23', '192.168.3.5');
INSERT INTO `message` VALUES (15, 0, '消息test3', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:09:37', '2025-08-20 15:09:37', '192.168.3.5');
INSERT INTO `message` VALUES (16, 0, '消息test4', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:09:47', '2025-08-20 15:09:47', '192.168.3.5');
INSERT INTO `message` VALUES (17, 0, '消息test5', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:10:05', '2025-08-20 15:10:05', '192.168.3.5');
INSERT INTO `message` VALUES (18, 0, '消息test66[:101][:101][:101]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:34:05', '2025-08-20 15:34:05', '192.168.3.5');
INSERT INTO `message` VALUES (19, 0, '[:101][:101][:101]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:34:27', '2025-08-20 15:34:27', '192.168.3.5');
INSERT INTO `message` VALUES (20, 0, '1', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:36:45', '2025-08-20 15:36:45', '192.168.3.5');
INSERT INTO `message` VALUES (21, 0, '2', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:36:55', '2025-08-20 15:36:55', '192.168.3.5');
INSERT INTO `message` VALUES (22, 0, '3', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:36:58', '2025-08-20 15:36:58', '192.168.3.5');
INSERT INTO `message` VALUES (23, 0, '4', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-20 15:39:21', '2025-08-20 15:39:21', '192.168.3.5');
INSERT INTO `message` VALUES (24, 0, '233', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-21 14:58:50', '2025-08-21 14:58:50', '192.168.3.5');
INSERT INTO `message` VALUES (25, 0, '852', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-21 16:38:44', '2025-08-21 16:38:44', '192.168.3.5');
INSERT INTO `message` VALUES (26, 3, '语音[2s]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/voice%2F20250821_165001_%2FVOICE_20250821_165001__273603.aac', 1, 1, 1, 3, NULL, '2025-08-21 16:50:05', '2025-08-21 16:50:05', '192.168.3.5');
INSERT INTO `message` VALUES (29, 3, '语音[2s]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/voice%2F20250822_101619_%2FVOICE_20250822_101619__703931.aac', 1, 1, 1, 3, NULL, '2025-08-22 10:16:20', '2025-08-22 10:16:20', '192.168.3.5');
INSERT INTO `message` VALUES (30, 2, '[图片]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/chat_Img%2F20250822_111019_%2FCHAT_IMG_20250822_111019__611846.jpg', 1, 1, 1, 3, NULL, '2025-08-22 11:10:20', '2025-08-22 11:10:20', '192.168.3.5');
INSERT INTO `message` VALUES (31, 2, '[图片]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/chat_Img%2F20250822_111230_%2FCHAT_IMG_20250822_111230__182204.jpg', 1, 1, 1, 3, NULL, '2025-08-22 11:12:31', '2025-08-22 11:12:31', '192.168.3.5');
INSERT INTO `message` VALUES (32, 2, '[图片]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/chat_Img%2F20250822_1128%2FCHAT_IMG_20250822_1128_550640.png', 1, 1, 1, 3, NULL, '2025-08-22 11:28:24', '2025-08-22 11:28:24', '192.168.3.5');
INSERT INTO `message` VALUES (33, 0, '消息11111', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-22 14:46:03', '2025-08-22 14:46:03', '192.168.3.5');
INSERT INTO `message` VALUES (34, 0, '[:100]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-22 15:02:10', '2025-08-22 15:02:10', '192.168.3.5');
INSERT INTO `message` VALUES (35, 0, '[:105]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-08-29 16:32:23', '2025-08-29 16:32:23', '198.18.0.1');
INSERT INTO `message` VALUES (36, 0, '[:100]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 16:52:32', '2025-11-06 16:52:32', '192.168.3.5');
INSERT INTO `message` VALUES (37, 0, '[:100]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 16:52:53', '2025-11-06 16:52:53', '192.168.3.5');
INSERT INTO `message` VALUES (38, 0, '11111[:101]', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 16:57:22', '2025-11-06 16:57:22', '192.168.3.5');
INSERT INTO `message` VALUES (39, 0, '22222', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 16:58:02', '2025-11-06 16:58:02', '192.168.3.5');
INSERT INTO `message` VALUES (40, 0, '333333', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 17:00:08', '2025-11-06 17:00:08', '192.168.3.5');
INSERT INTO `message` VALUES (41, 0, '44444444444', 3, 4, NULL, 1, 1, 1, 3, NULL, '2025-11-06 17:03:29', '2025-11-06 17:03:29', '192.168.3.5');
INSERT INTO `message` VALUES (42, 3, '语音[3s]', 3, 4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/voice%2F20251106_1723%2FVOICE_20251106_1723_122716.aac', 1, 1, 1, 3, NULL, '2025-11-06 17:23:52', '2025-11-06 17:23:52', '192.168.3.5');

-- ----------------------------
-- Table structure for message_schema_history
-- ----------------------------
DROP TABLE IF EXISTS `message_schema_history`;
CREATE TABLE `message_schema_history`  (
  `installed_rank` int NOT NULL,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `script` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `checksum` int NULL DEFAULT NULL,
  `installed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `execution_time` int NOT NULL,
  `success` tinyint(1) NOT NULL,
  PRIMARY KEY (`installed_rank`) USING BTREE,
  INDEX `message_schema_history_s_idx`(`success` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of message_schema_history
-- ----------------------------
INSERT INTO `message_schema_history` VALUES (1, '1', '<< Flyway Baseline >>', 'BASELINE', '<< Flyway Baseline >>', NULL, 'root', '2025-08-20 11:22:42', 0, 1);
INSERT INTO `message_schema_history` VALUES (2, '1.0.20250526.1052', 'create table message', 'SQL', 'V1.0.20250526.1052__create_table_message.sql', -1384714763, 'root', '2025-08-20 11:22:42', 39, 1);
INSERT INTO `message_schema_history` VALUES (3, '1.0.20250801.1410', 'create msg group', 'SQL', 'V1.0.20250801.1410__create_msg_group.sql', 1993894421, 'root', '2025-08-20 11:22:42', 16, 1);
INSERT INTO `message_schema_history` VALUES (4, '1.0.20250801.1411', 'create msg group member', 'SQL', 'V1.0.20250801.1411__create_msg_group_member.sql', -1577708487, 'root', '2025-08-20 11:22:42', 17, 1);
INSERT INTO `message_schema_history` VALUES (5, '1.0.20250808.1511', 'create conversation', 'SQL', 'V1.0.20250808.1511__create_conversation.sql', -901584658, 'root', '2025-08-20 11:22:42', 17, 1);
INSERT INTO `message_schema_history` VALUES (6, '1.0.20250808.1522', 'create conversation member', 'SQL', 'V1.0.20250808.1522__create_conversation_member.sql', 310249940, 'root', '2025-08-20 11:22:42', 15, 1);
INSERT INTO `message_schema_history` VALUES (7, '1.0.20250829.1526', 'create table friend', 'SQL', 'V1.0.20250829.1526__create_table_friend.sql', -1309820726, 'root', '2025-08-29 15:36:28', 39, 1);
INSERT INTO `message_schema_history` VALUES (8, '1.0.20250829.1534', 'create friend request', 'SQL', 'V1.0.20250829.1534__create_friend_request.sql', -433199787, 'root', '2025-08-29 15:36:28', 20, 1);

-- ----------------------------
-- Table structure for msg_group_members
-- ----------------------------
DROP TABLE IF EXISTS `msg_group_members`;
CREATE TABLE `msg_group_members`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL COMMENT '群聊id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `role` tinyint NOT NULL DEFAULT 0 COMMENT '角色（0: 普通成员，1: 管理员，2: 群主）',
  `muted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁言（0:否，1:是）',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '群聊成员关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of msg_group_members
-- ----------------------------

-- ----------------------------
-- Table structure for msg_groups
-- ----------------------------
DROP TABLE IF EXISTS `msg_groups`;
CREATE TABLE `msg_groups`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '群聊名称',
  `group_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '群头像url',
  `owner_id` bigint UNSIGNED NOT NULL COMMENT '群主用户id',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '群聊信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of msg_groups
-- ----------------------------

-- ----------------------------
-- Table structure for right_role_rel
-- ----------------------------
DROP TABLE IF EXISTS `right_role_rel`;
CREATE TABLE `right_role_rel`  (
  `right_id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  PRIMARY KEY (`right_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限与角色关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of right_role_rel
-- ----------------------------
INSERT INTO `right_role_rel` VALUES (14, 1);
INSERT INTO `right_role_rel` VALUES (16, 1);
INSERT INTO `right_role_rel` VALUES (17, 1);
INSERT INTO `right_role_rel` VALUES (19, 1);
INSERT INTO `right_role_rel` VALUES (20, 1);
INSERT INTO `right_role_rel` VALUES (21, 1);
INSERT INTO `right_role_rel` VALUES (22, 1);
INSERT INTO `right_role_rel` VALUES (23, 1);
INSERT INTO `right_role_rel` VALUES (24, 1);
INSERT INTO `right_role_rel` VALUES (25, 1);

-- ----------------------------
-- Table structure for rights
-- ----------------------------
DROP TABLE IF EXISTS `rights`;
CREATE TABLE `rights`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint NOT NULL,
  `assignable` tinyint(1) NOT NULL,
  `parent_id` bigint NULL DEFAULT NULL,
  `right_class` tinyint NOT NULL,
  `right_object_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识，可以是id可以是其他字符',
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of rights
-- ----------------------------
INSERT INTO `rights` VALUES (4, '仪表盘', 0, 0, NULL, 0, NULL, 1, 1, 0, 1, '2025-06-11 06:19:28', '2025-06-09 09:48:45', '198.18.0.1');
INSERT INTO `rights` VALUES (5, '仪表盘权限管理', 0, 0, 4, 0, NULL, 1, 1, 0, 1, '2025-06-11 06:19:50', '2025-06-09 09:49:51', '198.18.0.1');
INSERT INTO `rights` VALUES (7, '系统管理', 0, 0, NULL, 0, NULL, 1, 1, 0, NULL, '2025-06-09 09:53:41', '2025-06-09 09:53:41', NULL);
INSERT INTO `rights` VALUES (8, '公告权限管理', 0, 0, 13, 0, NULL, 1, 1, 0, NULL, '2025-06-09 09:54:17', '2025-06-09 09:54:17', NULL);
INSERT INTO `rights` VALUES (9, '用户权限管理', 0, 0, 7, 0, NULL, 1, 1, 0, NULL, '2025-06-09 09:54:58', '2025-06-09 09:54:58', NULL);
INSERT INTO `rights` VALUES (11, '权限管理', 0, 0, 7, 0, NULL, 1, 1, 0, NULL, '2025-06-09 09:56:21', '2025-06-09 09:56:21', NULL);
INSERT INTO `rights` VALUES (12, '角色权限管理', 0, 0, 7, 0, NULL, 1, 1, 0, NULL, '2025-06-09 09:57:42', '2025-06-09 09:57:42', NULL);
INSERT INTO `rights` VALUES (13, '业务管理', 0, 0, NULL, 0, NULL, 1, 1, 0, NULL, '2025-06-09 10:02:44', '2025-06-09 10:02:44', NULL);
INSERT INTO `rights` VALUES (14, '数据统计页面', 0, 1, 5, 0, 'work:statistic:page', 1, 1, 0, 1, '2025-06-11 06:12:06', '2025-06-09 14:41:25', '198.18.0.1');
INSERT INTO `rights` VALUES (15, '公告管理页面', 0, 1, 8, 0, 'business:announce:page', 1, 1, 0, NULL, '2025-06-09 14:42:36', '2025-06-09 14:42:36', NULL);
INSERT INTO `rights` VALUES (16, '角色管理页面', 0, 1, 12, 0, 'system:role:page', 1, 1, 0, NULL, '2025-06-09 14:43:25', '2025-06-09 14:43:25', NULL);
INSERT INTO `rights` VALUES (17, '角色新增按钮权限', 0, 1, 12, 0, 'system:role:addBtn', 1, 1, 0, NULL, '2025-06-09 14:43:25', '2025-06-09 14:43:25', NULL);
INSERT INTO `rights` VALUES (19, '权限页面', 0, 1, 11, 0, 'system:rights:page', 1, 1, 0, NULL, '2025-06-09 14:43:25', '2025-06-09 14:43:25', NULL);
INSERT INTO `rights` VALUES (20, '用户页面', 0, 1, 9, 0, 'system:user:page', 1, 1, 0, NULL, '2025-06-09 14:43:25', '2025-06-09 14:43:25', NULL);
INSERT INTO `rights` VALUES (21, '工作台页面', 0, 1, 5, 0, 'work:workplace:page', 1, 1, 0, NULL, '2025-06-09 14:41:25', '2025-06-09 14:41:25', NULL);
INSERT INTO `rights` VALUES (22, '新增权限按钮', 0, 1, 11, 0, 'system:rights:addBtn', 1, 1, 1, NULL, '2025-06-11 06:15:23', '2025-06-11 06:15:23', '198.18.0.1');
INSERT INTO `rights` VALUES (23, '编辑按钮权限', 0, 1, 11, 0, 'system:rights:editBtn', 1, 1, 1, NULL, '2025-06-11 06:16:34', '2025-06-11 06:16:34', '198.18.0.1');
INSERT INTO `rights` VALUES (24, '角色编辑按钮权限', 0, 1, 12, 0, 'system:role:editBtn', 1, 1, 1, NULL, '2025-06-11 06:17:14', '2025-06-11 06:17:14', '198.18.0.1');
INSERT INTO `rights` VALUES (25, '删除角色按钮权限', 0, 1, 12, 0, 'system:role:delBtn', 1, 1, 1, NULL, '2025-06-11 06:17:51', '2025-06-11 06:17:51', '198.18.0.1');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` tinyint NOT NULL,
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `des` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 0, 'Admin', '管理员', 1, 1, 1, NULL, '2025-08-29 14:25:10', '2025-08-29 14:25:10', 'localhost');

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `config_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `config_desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_config
-- ----------------------------

-- ----------------------------
-- Table structure for system_schema_history
-- ----------------------------
DROP TABLE IF EXISTS `system_schema_history`;
CREATE TABLE `system_schema_history`  (
  `installed_rank` int NOT NULL,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `script` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `checksum` int NULL DEFAULT NULL,
  `installed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `execution_time` int NOT NULL,
  `success` tinyint(1) NOT NULL,
  PRIMARY KEY (`installed_rank`) USING BTREE,
  INDEX `system_schema_history_s_idx`(`success` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_schema_history
-- ----------------------------
INSERT INTO `system_schema_history` VALUES (1, '1', '<< Flyway Baseline >>', 'BASELINE', '<< Flyway Baseline >>', NULL, 'root', '2025-08-29 14:14:49', 0, 1);
INSERT INTO `system_schema_history` VALUES (2, '1.0.20250523.1651', 'create table users', 'SQL', 'V1.0.20250523.1651__create_table_users.sql', 1217887799, 'root', '2025-08-29 14:14:49', 39, 1);
INSERT INTO `system_schema_history` VALUES (3, '1.0.20250523.1652', 'create table role', 'SQL', 'V1.0.20250523.1652__create_table_role.sql', -1629545626, 'root', '2025-08-29 14:14:49', 19, 1);
INSERT INTO `system_schema_history` VALUES (4, '1.0.20250523.1653', 'create table rights', 'SQL', 'V1.0.20250523.1653__create_table_rights.sql', 1358741183, 'root', '2025-08-29 14:14:49', 18, 1);
INSERT INTO `system_schema_history` VALUES (5, '1.0.20250523.1654', 'create table user role rel', 'SQL', 'V1.0.20250523.1654__create_table_user_role_rel.sql', -1955370858, 'root', '2025-08-29 14:14:49', 17, 1);
INSERT INTO `system_schema_history` VALUES (6, '1.0.20250523.1655', 'create table right role rel', 'SQL', 'V1.0.20250523.1655__create_table_right_role_rel.sql', -1236475464, 'root', '2025-08-29 14:14:49', 12, 1);
INSERT INTO `system_schema_history` VALUES (7, '1.0.20250523.1656', 'create table sys config', 'SQL', 'V1.0.20250523.1656__create_table_sys_config.sql', -827359677, 'root', '2025-08-29 14:14:49', 14, 1);

-- ----------------------------
-- Table structure for user_role_rel
-- ----------------------------
DROP TABLE IF EXISTS `user_role_rel`;
CREATE TABLE `user_role_rel`  (
  `user_id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与角色关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_role_rel
-- ----------------------------
INSERT INTO `user_role_rel` VALUES (3, 1);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `avatar_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pwd` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `account` varchar(62) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `open_id` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` tinyint NOT NULL DEFAULT 1,
  `version` int NOT NULL DEFAULT 1,
  `create_user_id` bigint NULL DEFAULT NULL,
  `update_user_id` bigint NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `server_ip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产生这条数据的服务器ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (3, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/avatar/20250808_141104_/1.jpg', '657738b0841116916890e75cd6273397c335d36259059f420cb6f534fbbd3451', '1756448178134', 'MuShanYu', '', '', 1, 1, NULL, NULL, '2025-08-29 14:16:18', '2025-08-29 14:16:18', '198.18.0.1');
INSERT INTO `users` VALUES (4, 'https://jig-client-static-1311478414.cos.ap-beijing.myqcloud.com/avatar/20250808_141244_/IMG_20250808_141244__795161.jpeg', '657738b0841116916890e75cd6273397c335d36259059f420cb6f534fbbd3451', '1756448178135', '赵子龙', '', '', 1, 1, NULL, NULL, '2025-08-29 14:16:18', '2025-08-29 14:16:18', '198.18.0.1');

SET FOREIGN_KEY_CHECKS = 1;