/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : fastchat

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2020-02-08 15:46:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `all_message`
-- ----------------------------
DROP TABLE IF EXISTS `all_message`;
CREATE TABLE `all_message` (
  `message_id` int(8) NOT NULL AUTO_INCREMENT,
  `maker_uid` int(8) NOT NULL,
  `maker_uname` varchar(50) NOT NULL,
  `accept_uid` int(8) NOT NULL,
  `accept_uname` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'message',
  `content` varchar(100) NOT NULL,
  `time` varchar(64) DEFAULT NULL,
  `timetick` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of all_message
-- ----------------------------
INSERT INTO `all_message` VALUES ('1', '1', '123', '1', '123', 'message', 'rty[-]123', null, null);
INSERT INTO `all_message` VALUES ('2', '1', '123', '1', '', 'message', 'rty', null, null);
INSERT INTO `all_message` VALUES ('3', '1', '123', '1', '123', 'message', 'qwe[-]123', null, null);
INSERT INTO `all_message` VALUES ('4', '1', '123', '2', '456', 'file', '10812uo.PNG', null, null);
INSERT INTO `all_message` VALUES ('5', '1', '123', '2', '456', 'img', '1033473499788_p0_master1200 - 副本.jpg', null, null);
INSERT INTO `all_message` VALUES ('6', '1', '123', '1', '123', 'message', 'fgh[-]123', null, null);
INSERT INTO `all_message` VALUES ('7', '1', '123', '1', '123', 'message', 'yui[-]123', null, null);
INSERT INTO `all_message` VALUES ('8', '1', '123', '1', '123', 'message', 'dfg[-]123', null, null);
INSERT INTO `all_message` VALUES ('9', '1', '123', '1', '123', 'message', 'dfg[-]123', null, null);
INSERT INTO `all_message` VALUES ('10', '1', '123', '1', '123', 'message', 'asd[-]123', null, null);
INSERT INTO `all_message` VALUES ('11', '1', '123', '2', '456', 'img', '10582sunsun.jpg', null, null);
INSERT INTO `all_message` VALUES ('12', '1', '123', '2', '456', 'img', '10360sunsun.jpg[-]456', null, null);
INSERT INTO `all_message` VALUES ('13', '1', '123', '2', '456', 'file', '108921.jpg[-]456', null, null);
INSERT INTO `all_message` VALUES ('14', '2', '456', '2', '456', 'message', 'asd[-]456', '2020-02-01 22:52:00', null);
INSERT INTO `all_message` VALUES ('15', '2', '456', '2', '456', 'message', 'ert[-]456', '2020-02-02 22:52:01', null);
INSERT INTO `all_message` VALUES ('16', '2', '456', '2', '456', 'message', 'vbn[-]456', '2020-02-03 22:52:02', null);
INSERT INTO `all_message` VALUES ('17', '2', '456', '2', '456', 'message', 'fgo[-]456', '2020-02-04 22:52:03', null);
INSERT INTO `all_message` VALUES ('18', '2', '456', '2', '456', 'message', 'qwe[-]456', '2020-02-05 22:52:04', null);
INSERT INTO `all_message` VALUES ('19', '2', '456', '2', '456', 'message', 'fgh[-]456', '2020-02-06 22:52:05', null);
INSERT INTO `all_message` VALUES ('20', '2', '456', '2', '456', 'message', 'dfg[-]456', '2020-02-07 22:52:06', null);
INSERT INTO `all_message` VALUES ('21', '2', '456', '2', '456', 'message', 'fgh[-]456', '2020-02-07 22:52:27', null);
INSERT INTO `all_message` VALUES ('22', '2', '456', '2', '456', 'message', 'asd[-]456', '2020-02-07 22:52:08', null);
INSERT INTO `all_message` VALUES ('23', '2', '456', '2', '456', 'message', 'win[-]456', '2020-02-07 22:52:23', null);
INSERT INTO `all_message` VALUES ('24', '1', '123', '2', '456', 'img', '10599sunsun.jpg', '2020-02-07 22:54:44', null);
INSERT INTO `all_message` VALUES ('25', '2', '456', '2', '456', 'message', '凉宫春日[-]456', '2020-02-08 10:18:18', null);
INSERT INTO `all_message` VALUES ('26', '2', '456', '1', '123', 'message', 'qwe[-]123[-]', '2020-02-08 13:33:17', '1581139997');
INSERT INTO `all_message` VALUES ('27', '2', '456', '1', '123', 'message', 'wer[-]123[-]', '2020-02-08 13:33:34', '1581140014');
INSERT INTO `all_message` VALUES ('28', '2', '456', '1', '123', 'message', '123[-]123', '2020-02-08 13:34:06', '1581140046');
INSERT INTO `all_message` VALUES ('29', '2', '456', '2', '456', 'message', '123[-]456', '2020-02-08 14:34:52', '1581143692');
INSERT INTO `all_message` VALUES ('30', '1', '123', '2', '456', 'img', '10010sunsun.jpg[-]456', '2020-02-08 15:08:04', '1581145684');
INSERT INTO `all_message` VALUES ('31', '1', '123', '1', '123', 'img', '10560sunsun.jpg[-]123', '2020-02-08 15:08:44', '1581145724');

-- ----------------------------
-- Table structure for `offline_message`
-- ----------------------------
DROP TABLE IF EXISTS `offline_message`;
CREATE TABLE `offline_message` (
  `message_id` int(8) NOT NULL AUTO_INCREMENT,
  `message_type` varchar(50) NOT NULL DEFAULT 'message',
  `maker_uid` int(8) NOT NULL,
  `maker_uname` varchar(50) NOT NULL,
  `accept_uid` int(8) NOT NULL,
  `accept_uname` varchar(50) NOT NULL,
  `content` varchar(100) NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of offline_message
-- ----------------------------

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` int(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`uid`,`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '123', '123');
INSERT INTO `user` VALUES ('2', '456', '456');
INSERT INTO `user` VALUES ('3', 'rty', 'dfg');

-- ----------------------------
-- Table structure for `user_relationship`
-- ----------------------------
DROP TABLE IF EXISTS `user_relationship`;
CREATE TABLE `user_relationship` (
  `relation_id` int(8) NOT NULL AUTO_INCREMENT,
  `maker_uid` int(8) NOT NULL,
  `accept_uid` int(8) NOT NULL,
  `accept_uname` varchar(50) NOT NULL,
  PRIMARY KEY (`relation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_relationship
-- ----------------------------
INSERT INTO `user_relationship` VALUES ('1', '1', '2', '456');
INSERT INTO `user_relationship` VALUES ('2', '2', '1', '123');
INSERT INTO `user_relationship` VALUES ('3', '2', '2', '456');