/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : chatdb

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

 Date: 15/03/2019 17:59:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat_detail
-- ----------------------------
DROP TABLE IF EXISTS `chat_detail`;
CREATE TABLE `chat_detail`  (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `chat_main_id` int(16) NULL DEFAULT NULL,
  `user_id` int(16) NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `is_least` int(1) NULL DEFAULT 1,
  `type` int(1) NULL DEFAULT 0,
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_detail
-- ----------------------------
INSERT INTO `chat_detail` VALUES (1, 4, 333, '哈哈', NULL, NULL, '2019-03-15 14:25:50');
INSERT INTO `chat_detail` VALUES (2, 4, 666, '呵呵', NULL, NULL, '2019-03-15 14:25:50');

-- ----------------------------
-- Table structure for chat_list
-- ----------------------------
DROP TABLE IF EXISTS `chat_list`;
CREATE TABLE `chat_list`  (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `chat_main_id` int(16) NULL DEFAULT NULL,
  `user_id` int(16) NULL DEFAULT NULL,
  `another_id` int(16) NULL DEFAULT NULL,
  `unread` int(16) NULL DEFAULT NULL,
  `is_online` int(1) NULL DEFAULT NULL,
  `del_flag` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_list
-- ----------------------------
INSERT INTO `chat_list` VALUES (1, 1, 333, 666, 5, 1, 0);
INSERT INTO `chat_list` VALUES (2, 1, 666, 333, 3, 1, 0);

-- ----------------------------
-- Table structure for chat_main
-- ----------------------------
DROP TABLE IF EXISTS `chat_main`;
CREATE TABLE `chat_main`  (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `user_id` int(16) NULL DEFAULT NULL,
  `another_id` int(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_main
-- ----------------------------
INSERT INTO `chat_main` VALUES (1, 2, 3);
INSERT INTO `chat_main` VALUES (2, 2, 4);
INSERT INTO `chat_main` VALUES (3, 3, 4);
INSERT INTO `chat_main` VALUES (4, 333, 666);

SET FOREIGN_KEY_CHECKS = 1;