-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: 2018-11-18 06:19:58
-- 服务器版本： 5.7.19
-- PHP Version: 5.6.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `qiusuo_user`
--

-- --------------------------------------------------------

--
-- 表的结构 `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `uid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `account` varchar(50) NOT NULL COMMENT '账号',
  `password` char(32) NOT NULL COMMENT '密码',
  `email` varchar(50) NOT NULL COMMENT '电子邮箱',
  `salt` char(8) NOT NULL DEFAULT '' COMMENT '盐',
  `re_time` datetime NOT NULL COMMENT '注册时间',
  `last_time` datetime NOT NULL COMMENT '最后登录时间',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `user`
--

-- --------------------------------------------------------

--
-- 表的结构 `userinfo`
--

DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE IF NOT EXISTS `userinfo` (
  `uiid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户信息ID',
  `uid` smallint(5) UNSIGNED NOT NULL COMMENT '用户ID',
  `account` varchar(50) NOT NULL COMMENT '账号',
  `name` varchar(50) NOT NULL COMMENT '用户名',
  `sex` varchar(5) NOT NULL DEFAULT '' COMMENT '性别',
  `birthday` date DEFAULT '2000-01-01' COMMENT '生日',
  `department` varchar(50) NOT NULL DEFAULT '' COMMENT '部门',
  `hometown` varchar(50) NOT NULL DEFAULT '' COMMENT '家乡',
  `college` varchar(50) NOT NULL DEFAULT '' COMMENT '学院',
  `class` varchar(50) NOT NULL DEFAULT '' COMMENT '班级',
  `qq` varchar(30) NOT NULL DEFAULT '' COMMENT 'QQ号码',
  `phone` varchar(30) NOT NULL DEFAULT '' COMMENT '手机号码',
  `email` varchar(50) NOT NULL COMMENT '电子邮箱',
  `per_intro` varchar(200) NOT NULL DEFAULT '' COMMENT '个人简介',
  PRIMARY KEY (`uiid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `userinfo`
--

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;