/*
Navicat MySQL Data Transfer

Source Server         : 本地数据库
Source Server Version : 80015
Source Host           : localhost:3306
Source Database       : java_cms

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

Date: 2019-12-13 22:32:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for messages
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `messageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `likeNumber` int(11) NOT NULL DEFAULT '0',
  `autherid` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `creatTime` datetime DEFAULT NULL,
  `headPic` varchar(255) DEFAULT NULL,
  `auther` varchar(255) NOT NULL,
  `digest` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  PRIMARY KEY (`messageid`),
  KEY `userid` (`autherid`),
  CONSTRAINT `userid` FOREIGN KEY (`autherid`) REFERENCES `users` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for replys
-- ----------------------------
DROP TABLE IF EXISTS `replys`;
CREATE TABLE `replys` (
  `replyId` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `isRead` int(255) unsigned NOT NULL DEFAULT '0',
  `messageId` int(10) unsigned NOT NULL,
  `replyTo` int(255) unsigned NOT NULL DEFAULT '0',
  `autherId` int(11) DEFAULT NULL,
  `autherName` varchar(255) DEFAULT NULL,
  `autherHeadPic` varchar(255) DEFAULT NULL,
  `replyToUserName` varchar(255) DEFAULT NULL,
  `content` text,
  `messageTitle` varchar(255) DEFAULT NULL,
  `messageDigest` varchar(255) DEFAULT NULL,
  `creatTime` datetime DEFAULT NULL,
  `messageAuther` varchar(255) DEFAULT NULL,
  `digest` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`replyId`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sexNumber` int(10) unsigned NOT NULL,
  `age` int(11) NOT NULL,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `headPic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `signature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phoneNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `introduction` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `profession` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `coverPic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `control` int(255) unsigned DEFAULT '1',
  `state` int(255) unsigned DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;