-- -- 数据库： `im` -- -- -------------------------------------------------------- -- -- 表的结构 `yu_config` -- CREATE TABLE `yu_config` ( `id` int(11) NOT NULL, `name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` json DEFAULT NULL, `create_user` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `create_time` int(11) NOT NULL DEFAULT '0', `remark` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='配置表'; -- -- 转存表中的数据 `yu_config` -- INSERT INTO `yu_config` (`id`, `name`, `value`, `create_user`, `update_time`, `create_time`, `remark`, `status`) VALUES (1, 'sysInfo', '{\"logo\": \"\", \"name\": \"Raingad-IM\", \"state\": \"1\", \"regauth\": \"0\", \"regtype\": \"2\", \"runMode\": \"1\", \"ipregion\": \"1\", \"closeTips\": \"系统升级维护中，请稍候再试！\", \"description\": \"一款基于vue2.0的即时通信系统\", \"registerInterval\": \"600\"}', 0, 1688462862, 1688462862, NULL, 1), (2, 'chatInfo', '{\"stun\": \"\", \"online\": \"1\", \"webrtc\": \"0\", \"dbDelMsg\": \"1\", \"msgClear\": \"1\", \"redoTime\": \"120\", \"stunPass\": \"\", \"stunUser\": \"\", \"groupChat\": \"1\", \"simpleChat\": \"1\", \"autoAddUser\": {\"status\": \"0\", \"welcome\": \"你好啊，欢迎来到Raingad-IM\", \"user_ids\": [\"1\", \"2\", \"3\"], \"user_items\": [\"1\", \"2\", \"3\"]}, \"msgClearDay\": \"30\", \"autoAddGroup\": {\"name\": \"春游交流\", \"status\": \"0\", \"userMax\": \"100\", \"owner_uid\": \"1\", \"owner_info\": [{\"id\": \"1\", \"avatar\": \"", \"user_id\": \"1\", \"realname\": \"管理员\"}]}, \"groupUserMax\": \"0\", \"sendInterval\": \"0\"}', 0, 1688463300, 1688463300, NULL, 1), (3, 'smtp', '{\"addr\": \"xiekunyu@sss.com\", \"host\": \"smtp.exmail.qq.com\", \"pass\": \"ssss\", \"port\": \"465\", \"sign\": \"Raingad-IM\", \"security\": \"ssl\"}', 0, 1688464072, 1688464072, NULL, 1), (4, 'fileUpload', '{\"disk\": \"local\", \"size\": \"50\", \"qiniu\": {\"url\": \"\", \"bucket\": \"\", \"accessKey\": \"\", \"secretKey\": \"\"}, \"aliyun\": {\"url\": \"\", \"bucket\": \"\", \"accessId\": \"\", \"endpoint\": \"\", \"accessSecret\": \"\"}, \"qcloud\": {\"cdn\": \"\", \"appId\": \"\", \"bucket\": \"\", \"region\": \"\", \"secretId\": \"\", \"secretKey\": \"\"}, \"fileExt\": [\"jpg\", \"jpeg\", \"ico\", \"webp\", \"bmp\", \"gif\", \"pdf\", \"mp3\", \"wav\", \"wmv\", \"amr\", \"mp4\", \"3gp\", \"avi\", \"m2v\", \"mkv\", \"mov\", \"ppt\", \"pptx\", \"doc\", \"docx\", \"xls\", \"xlsx\", \"txt\", \"md\", \"hevc\", \"png\", \"KLKV\"], \"preview\": \"\"}', 0, 1688464130, 1688464130, NULL, 1), (5, 'compass', '{\"list\": [], \"mode\": 1, \"status\": 0}', 0, 1688464130, 1688464130, NULL, 1); -- -------------------------------------------------------- -- -- 表的结构 `yu_file` -- CREATE TABLE `yu_file` ( `file_id` int(11) NOT NULL, `cate` tinyint(1) NOT NULL DEFAULT '9' COMMENT '文件分类', `file_type` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父Id', `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称', `src` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '链接', `size` int(11) DEFAULT '0' COMMENT '大小', `ext` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件后缀', `md5` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'md5', `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建人', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `is_lock` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否锁定' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文件库'; -- -------------------------------------------------------- -- -- 表的结构 `yu_friend` -- CREATE TABLE `yu_friend` ( `friend_id` int(11) NOT NULL, `friend_user_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '好友ID', `nickname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '好友备注', `is_invite` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为邀请方', `is_top` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶', `is_notice` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否消息提醒', `create_user` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `create_time` int(11) NOT NULL DEFAULT '0', `delete_time` int(11) NOT NULL DEFAULT '0', `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '申请备注', `status` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='联系人置顶表'; -- -------------------------------------------------------- -- -- 表的结构 `yu_group` -- CREATE TABLE `yu_group` ( `group_id` int(11) NOT NULL, `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '团队名称', `name_py` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '团队的拼音', `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '群聊头像', `level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '等级', `create_user` int(11) NOT NULL DEFAULT '0' COMMENT '创建人', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `owner_id` int(11) NOT NULL DEFAULT '0' COMMENT '拥有者', `is_public` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否公开', `notice` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '公告', `setting` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '设置', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 表的结构 `yu_group_user` -- CREATE TABLE `yu_group_user` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL DEFAULT '0' COMMENT '团队Id', `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户Id', `role` tinyint(1) NOT NULL DEFAULT '2' COMMENT '角色 1拥有者，2管理员，3成员', `invite_id` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `unread` int(11) NOT NULL DEFAULT '0' COMMENT '群未读消息', `is_notice` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1是否提醒', `is_top` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶', `no_speak_time` int(11) NOT NULL DEFAULT '0' COMMENT '禁言到期时间', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 0 ，未同意邀请，1，同意', `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 表的结构 `yu_message` -- CREATE TABLE `yu_message` ( `msg_id` int(11) NOT NULL, `id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '消息id', `from_user` int(11) NOT NULL DEFAULT '0' COMMENT '发送者', `to_user` int(11) NOT NULL DEFAULT '0' COMMENT '接受收者', `content` text COLLATE utf8mb4_unicode_ci COMMENT '消息内容，如果为文件或图片就是url', `chat_identify` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标识 ：a与b聊天，b与a聊天。记录 a-b', `type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text' COMMENT '消息类型：text、file、image...', `is_group` tinyint(1) NOT NULL DEFAULT '0' COMMENT '群聊消息', `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否阅读', `is_last` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否是最后一条消息', `create_time` int(13) NOT NULL DEFAULT '0' COMMENT '发送时间', `is_undo` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否撤回', `at` text COLLATE utf8mb4_unicode_ci COMMENT '提醒某人', `pid` int(11) DEFAULT '0' COMMENT '引用id', `file_id` int(11) NOT NULL DEFAULT '0' COMMENT '文件id', `file_cate` tinyint(1) NOT NULL DEFAULT '0' COMMENT '文件类型', `file_size` int(11) NOT NULL DEFAULT '0' COMMENT '文件大小', `file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称', `extends` json DEFAULT NULL COMMENT '消息扩展内容', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `del_user` text COLLATE utf8mb4_unicode_ci COMMENT '已删除成员' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 表的结构 `yu_emoji` -- CREATE TABLE `yu_emoji` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id，0为系统', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型', `name` varchar(255) DEFAULT NULL COMMENT '名称', `src` varchar(255) DEFAULT NULL COMMENT '链接', `file_id` INT(11) NOT NULL DEFAULT '0' COMMENT '文件id', `create_time` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `delete_time` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='表情表'; -- -- 表的结构 `yu_user` -- CREATE TABLE `yu_user` ( `user_id` int(11) NOT NULL, `account` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `realname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `salt` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '加密盐', `avatar` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像', `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电子邮箱', `sex` tinyint(1) NOT NULL DEFAULT '2' COMMENT '性别，0女，1男，2未知', `role` tinyint(1) NOT NULL DEFAULT '0' COMMENT '角色，0无角色，1超管，2普管', `motto` text COLLATE utf8mb4_unicode_ci COMMENT '个性签名', `remark` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `name_py` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名字的拼音', `cs_uid` int(11) NOT NULL DEFAULT '0' COMMENT '客服ID', `setting` json DEFAULT NULL COMMENT '用户设置', `friend_limit` int(11) NOT NULL DEFAULT '0' COMMENT '好友上限', `group_limit` int(11) NOT NULL DEFAULT '0' COMMENT '群聊上限', `create_time` int(11) UNSIGNED NOT NULL COMMENT '创建时间', `update_time` int(11) UNSIGNED DEFAULT NULL, `login_count` mediumint(8) UNSIGNED DEFAULT '0' COMMENT '登录次数', `is_auth` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否认证', `last_login_time` int(11) UNSIGNED DEFAULT '0' COMMENT '最后登录时间', `last_login_ip` char(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后登录Ip\n', `register_ip` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '注册IP', `delete_time` int(11) UNSIGNED NOT NULL DEFAULT '0', `status` tinyint(1) UNSIGNED DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT; -- -- 转存表中的数据 `yu_user` -- INSERT INTO `yu_user` (`user_id`, `account`, `realname`, `password`, `salt`, `avatar`, `email`, `sex`, `role`, `motto`, `remark`, `name_py`, `cs_uid`, `setting`, `friend_limit`, `group_limit`, `create_time`, `update_time`, `login_count`, `is_auth`, `last_login_time`, `last_login_ip`, `register_ip`, `delete_time`, `status`) VALUES (1, 'administrator', '管理员', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'service@kais.com', 1, 1, NULL, '', 'guanliyuan', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1222907803, 1702625051, 300, 0, 1730704229, '171.212.121.209', NULL, 0, 1), (2, '13800000002', '熊大', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'lllll@bchn', 2, 0, '我是测试', '', 'xiongda', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"true\"}', 0, 0, 1555341865, 1730171777, 14886, 0, 1730704870, '125.80.141.99', NULL, 0, 1), (3, '13800000003', '熊二', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, '12345@qq.com', 0, 0, '', '', 'xionger', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1557933999, 1728161315, 1217, 0, 1730697701, '103.121.164.134', NULL, 0, 1), (4, '13800000004', '喜洋洋', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'xiyangyang@qq.com', 1, 0, '', '', 'xiyangyang', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"true\"}', 0, 0, 1604587165, 1730142085, 834, 0, 1730643800, '180.91.180.120', NULL, 0, 1), (5, '13800000005', '灰太狼', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'huitailang@qq.com', 1, 0, NULL, '', 'huitailang', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"true\"}', 0, 0, 1604587246, 1711360067, 859, 0, 1730692491, '1.199.39.24', NULL, 0, 1), (6, '13800000006', '奥特曼', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'aoteman@qq.com', 1, 0, '', '', 'aoteman', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587295, 1729431591, 824, 0, 1730688234, '120.224.39.54', NULL, 0, 1), (7, '13800000007', '孙悟空', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'sunwukong@qq.com', 1, 0, '', '', 'sunwukong', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587347, 1728972288, 761, 0, 1730703214, '115.60.18.127', NULL, 0, 1), (8, '13800000008', '猪八戒', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'zhubajie@qq.com', 1, 0, '', '', 'zhubajie', 0, '{\"theme\": \"default\", \"isVoice\": \"false\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"true\"}', 0, 0, 1604587378, 1726480311, 894, 0, 1730705108, '120.211.148.44', NULL, 0, 1), (9, '13800000009', '唐三藏', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'tangsanzang@qq.com', 0, 0, '', '', 'tangsanzang', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587409, 1723078304, 1147, 0, 1730462811, '120.228.7.21', NULL, 0, 1), (10, '13800000010', '沙悟净', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'sss', 2, 0, '', '', 'shawujing', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587409, 1727523988, 818, 0, 1730689889, '120.224.39.54', NULL, 0, 1), (11, '13800000011', '刘备', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'liubei@kaishanlaw.com', 1, 0, '', '', 'hongbaolai', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"2\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1555341865, 1724836138, 861, 0, 1730703374, '115.60.18.127', NULL, 0, 1), (12, '13800000012', '关羽', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'gggg', 1, 0, '', '', 'guanyu', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1557933999, 1730285557, 781, 0, 1730686560, '120.224.39.54', NULL, 0, 1), (13, '13800000013', '张飞', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'i', 1, 0, '', '', 'zhangfei', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587165, 1729275843, 641, 0, 1730702978, '115.60.18.127', NULL, 0, 1), (14, '13800000014', '赵云', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', '', 'zhaoyun@qq.com', 1, 0, '', '', 'zhaoyun', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587246, 1730374373, 662, 0, 1730688783, '124.135.239.79', NULL, 0, 1), (15, '13800000015', '曹操', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'caocao@qq.com', 1, 0, '', '', 'caocao', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587295, 1720255912, 800, 0, 1730703843, '220.173.180.106', NULL, 0, 1), (16, '13800000016', '司马懿', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'simayi@qq.com', 2, 0, '', '', 'simayi', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587347, 1711527030, 781, 0, 1730703600, '218.57.140.131', NULL, 0, 1), (17, '13800000017', '孙权', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'sunquan@qq.com', 1, 0, 'fv', '', 'sunquan', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"true\", \"hideMessageTime\": \"true\"}', 0, 0, 1604587378, 1714396067, 713, 0, 1730598894, '39.148.72.199', NULL, 0, 1), (18, '13800000018', '周瑜', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'zhouyu@qq.com', 1, 0, '12121', '', 'zhouyu', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587409, 1714437700, 786, 0, 1730700668, '222.71.91.18', NULL, 0, 1), (19, '13800000019', '诸葛亮', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'zhugeliang@qq.com', 0, 0, '', '', 'zhugeliang', 0, '{\"theme\": \"blue\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"false\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587378, 1730705058, 883, 0, 1730688482, '222.212.4.43', NULL, 0, 1), (20, '13800000020', '吕布', '2cb4ecb7fd5295685e275edc7d44e02e', 'srww', NULL, 'lvbu@qq.com', 0, 0, '', '', 'lvbu', 0, '{\"theme\": \"default\", \"isVoice\": \"true\", \"sendKey\": \"1\", \"avatarCricle\": \"true\", \"hideMessageName\": \"false\", \"hideMessageTime\": \"false\"}', 0, 0, 1604587409, 1729935411, 1750, 0, 1730014387, '101.44.83.192', NULL, 0, 1); CREATE TABLE `yu_chat_delog` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id', `to_user` varchar(32) DEFAULT NULL COMMENT '删除对象', `is_group` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否群聊', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会话删除表'; -- -- 转储表的索引 -- -- -- 表的索引 `yu_chat_delog` -- ALTER TABLE `yu_chat_delog` ADD PRIMARY KEY (`id`); -- -- 使用表AUTO_INCREMENT `yu_chat_delog` -- ALTER TABLE `yu_chat_delog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; -- -- 表的索引 `yu_config` -- ALTER TABLE `yu_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `yu_file` -- ALTER TABLE `yu_file` ADD PRIMARY KEY (`file_id`); -- -- 表的索引 `yu_friend` -- ALTER TABLE `yu_friend` ADD PRIMARY KEY (`friend_id`); -- -- 表的索引 `yu_group` -- ALTER TABLE `yu_group` ADD PRIMARY KEY (`group_id`); -- -- 表的索引 `yu_group_user` -- ALTER TABLE `yu_group_user` ADD PRIMARY KEY (`id`); -- -- 表的索引 `yu_message` -- ALTER TABLE `yu_message` ADD PRIMARY KEY (`msg_id`); -- -- 表的索引 `yu_emoji` -- ALTER TABLE `yu_emoji` ADD PRIMARY KEY (`id`); -- -- 表的索引 `yu_user` -- ALTER TABLE `yu_user` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `account` (`account`) USING BTREE, ADD KEY `accountpassword` (`account`,`password`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `yu_config` -- ALTER TABLE `yu_config` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- 使用表AUTO_INCREMENT `yu_file` -- ALTER TABLE `yu_file` MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `yu_friend` -- ALTER TABLE `yu_friend` MODIFY `friend_id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `yu_group` -- ALTER TABLE `yu_group` MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `yu_group_user` -- ALTER TABLE `yu_group_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `yu_message` -- ALTER TABLE `yu_message` MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `yu_emoji` -- ALTER TABLE `yu_emoji` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `yu_message` ADD INDEX( `from_user`, `to_user`, `is_group`, `is_read`); ALTER TABLE `yu_message` ADD INDEX( `from_user`, `to_user`, `is_group`, `is_last`); ALTER TABLE `yu_message` ADD INDEX( `from_user`, `is_group`, `is_last`); ALTER TABLE `yu_message` ADD INDEX( `to_user`, `is_group`, `is_last`); ALTER TABLE `yu_message` ADD INDEX( `chat_identify`); ALTER TABLE `yu_message` ADD INDEX( `chat_identify`, `is_last`); ALTER TABLE `yu_message` ADD INDEX( `chat_identify`, `status`); ALTER TABLE `yu_group_user` ADD INDEX( `group_id`, `status`); ALTER TABLE `yu_group_user` ADD INDEX( `group_id`, `user_id`); ALTER TABLE `yu_group_user` ADD INDEX( `group_id`, `user_id`, `status`); ALTER TABLE `yu_friend` ADD INDEX( `friend_user_id`, `create_user`); ALTER TABLE `yu_friend` ADD INDEX( `friend_user_id`, `create_user`, `status`); ALTER TABLE `yu_friend` ADD INDEX( `create_user`, `status`); ALTER TABLE `yu_friend` ADD INDEX( `create_user`); ALTER TABLE `yu_chat_delog` ADD INDEX( `user_id`, `is_group`); -- -- 使用表AUTO_INCREMENT `yu_user` -- ALTER TABLE `yu_user` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; COMMIT;