master

分支 (1)

管理

管理

master

online-chat-web-version
/
char.sql

/*
 Navicat Premium Data Transfer

 Source Server         : test
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : localhost:3306
 Source Schema         : char

 Target Server Type    : MySQL
 Target Server Version : 50737
 File Encoding         : 65001

 Date: 10/08/2023 15:29:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for autocode
-- ----------------------------
DROP TABLE IF EXISTS `autocode`;
CREATE TABLE `autocode`  (
  `AuthCodeMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被验证的邮箱',
  `AuthCodeType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱验证的类型，\r\nlogin//登录\r\nLogOut //登出\r\nForgot //忘记密码\r\nEdit // 修改密码',
  `AuthCodeText` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证码内容',
  `AuthCodeTime` datetime NULL DEFAULT NULL COMMENT '验证码时间// 该验证码十分钟失效',
  `AuthCodeUse` int(1) NULL DEFAULT NULL COMMENT '验证码是否被使用 // 使用为2，未使用为1'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of autocode
-- ----------------------------

-- ----------------------------
-- Table structure for await
-- ----------------------------
DROP TABLE IF EXISTS `await`;
CREATE TABLE `await`  (
  `AwaitPrimary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人邮箱，， 申请加好友等待表 ',
  `AwaitSecondary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被申请人邮箱，  ',
  `AwaitType` int(11) NULL DEFAULT NULL COMMENT '类型，申请人状态为1，被申请人状态为2',
  `AwaitTime` datetime NULL DEFAULT NULL COMMENT '申请时间， 一个星期内申请记录为完成则删除申请记录',
  `AwaitState` int(255) NULL DEFAULT NULL COMMENT '状态，未同意1，同意2，拒绝3，对方分组到达上线',
  `AwaitGroup` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组内容'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of await
-- ----------------------------

-- ----------------------------
-- Table structure for buddy
-- ----------------------------
DROP TABLE IF EXISTS `buddy`;
CREATE TABLE `buddy`  (
  `BuddyOneselfId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '好友表，自己的Id',
  `BuddyOthersId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他人Id',
  `BuddyTime` datetime NULL DEFAULT NULL COMMENT '加好友时间',
  `BuddyGroup` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组类别'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of buddy
-- ----------------------------

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat`  (
  `ChatId` int(11) NOT NULL AUTO_INCREMENT COMMENT '聊天表id',
  `ChatMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天表 主邮箱',
  `ChatMailBoxOthers` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天表次邮箱',
  `ChatTime` datetime NULL DEFAULT NULL COMMENT '聊天时间',
  `ChatText` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天内容',
  `ChatType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息类型\r\n\r\n系统消息类型为info',
  `ChatMailBoxType` int(1) NULL DEFAULT NULL COMMENT '1 标识未删除\r\n2 被主邮箱删除',
  `ChatMailBoxOthersType` int(1) NULL DEFAULT NULL COMMENT '1 标识未删除\r\n2标识被次要邮箱删除',
  PRIMARY KEY (`ChatId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat
-- ----------------------------

-- ----------------------------
-- Table structure for chatlist
-- ----------------------------
DROP TABLE IF EXISTS `chatlist`;
CREATE TABLE `chatlist`  (
  `ChatListMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天列表主id',
  `ChatListOthersMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天列表次要id',
  `ChatLisOldList` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天列表最后信息',
  `ChatListTime` datetime NULL DEFAULT NULL COMMENT '聊天列表时间',
  `ChatListType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天列表 类型 1为自己发送，2为对方发送\r\n',
  `ChatListNew` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天列表状态，1未读，2为已读',
  `ChatListChatType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聊天类型字段\r\ntext 文本\r\nPhoto 图片\r\ncancel 信息被撤销\r\ndelete 信息被删除'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chatlist
-- ----------------------------

-- ----------------------------
-- Table structure for groups
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups`  (
  `GroupId` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组表 id',
  `GroupUserId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组所属人id',
  `GroupName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组名称',
  `GroupTime` datetime NULL DEFAULT NULL COMMENT '分组创建时间',
  PRIMARY KEY (`GroupId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of groups
-- ----------------------------

-- ----------------------------
-- Table structure for image
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image`  (
  `ImageId` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上传图片id',
  `ImageBlob` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图片链接',
  PRIMARY KEY (`ImageId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of image
-- ----------------------------

-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting`  (
  `SettingMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设置表 填写用户邮箱',
  `SettingTheme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置表主题\r\n值为\r\nblack:黑夜\r\nlight：白天\r\n',
  `SettingSidebar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '侧边栏\r\ntop,\r\nleft,\r\nbottom,\r\nright\r\n',
  PRIMARY KEY (`SettingMailbox`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of setting
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `UserId` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户表id',
  `UserNickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `UserMailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `UserMailboxType` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用户邮箱类型',
  `UserTime` datetime NULL DEFAULT NULL COMMENT '用户注册时间',
  `UserPassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码',
  PRIMARY KEY (`UserId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;