/*
Navicat MySQL Data Transfer

Source Server         : lll
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : xm

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

Date: 2022-06-07 18:19:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `share`
-- ----------------------------
DROP TABLE IF EXISTS `share`;
CREATE TABLE `share` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL,
  `share` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of share
-- ----------------------------

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userNumber` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `userInformationid` int(11) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `size` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('18', '1', '1', '30', '19861960515', '1111227847');

-- ----------------------------
-- Table structure for `userinformation`
-- ----------------------------
DROP TABLE IF EXISTS `userinformation`;
CREATE TABLE `userinformation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sex` varchar(255) DEFAULT NULL COMMENT '性别',
  `age` varchar(11) DEFAULT NULL COMMENT '年龄',
  `home` varchar(255) DEFAULT NULL COMMENT '家乡',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `school` varchar(255) DEFAULT NULL COMMENT '教育经历',
  `username` varchar(255) NOT NULL COMMENT '昵称',
  `img` varchar(255) DEFAULT NULL COMMENT '头像',
  `qm` varchar(255) DEFAULT NULL COMMENT '签名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userinformation
-- ----------------------------
INSERT INTO `userinformation` VALUES ('30', null, null, null, null, null, '1', 'e0165f5f-9393-4277-b87e-1ff2537bc634', null);