/*
Navicat MySQL Data Transfer
Source Host     : localhost:3306
Source Database : person
Target Host     : localhost:3306
Target Database : person
Date: 2012-10-21 17:49:11
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for date
-- ----------------------------
DROP TABLE IF EXISTS `date`;
CREATE TABLE `date` (
                      `userName` varchar(30) NOT NULL,
                      `date` varchar(30) NOT NULL,
                      `thing` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

-- ----------------------------
-- Records of date
-- ----------------------------
INSERT INTO `date` VALUES ('zzf', '2013-10-13', '去看海！');

-- ----------------------------
-- Table structure for friends
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
                         `userName` varchar(30) NOT NULL,
                         `name` varchar(30) NOT NULL,
                         `phone` varchar(30) NOT NULL,
                         `email` varchar(30) NOT NULL,
                         `workPlace` varchar(30) NOT NULL,
                         `place` varchar(30) NOT NULL,
                         `QQ` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

-- ----------------------------
-- Records of friends
-- ----------------------------
INSERT INTO `friends` VALUES ('hz', '刘杉', '13268568191', '1151717268@qq.com', '上海', '上海', '100010');
-- ----------------------------
-- Table structure for dgutInfor
-- ----------------------------
DROP TABLE IF EXISTS `dgutInfor`;
CREATE TABLE `dgutInfor` (
                           `username` varchar(30) NOT NULL UNIQUE,
                           `name` varchar(30) NOT NULL,
                           `group` varchar(30) NOT NULL,
                           `faculty_title` varchar(30) NOT NULL,
                           PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
                      `userName` varchar(30) NOT NULL,
                      `password` varchar(30) NOT NULL,
                      `name` varchar(30) NOT NULL,
                      `sex` varchar(30) NOT NULL,
                      `idCard` varchar(30) NOT NULL,
                      `birth` varchar(30),
                      `nation` varchar(30) NOT NULL,
                      `edu` varchar(30) NOT NULL,
                      `work` varchar(30) NOT NULL,
                      `monthPay` varchar(30) NOT NULL,
                      `phone` varchar(30),
                      `place` varchar(30),
                      `email` varchar(30),
                      `level` varchar(30) NOT NULL,
                      `picture` varchar(30) DEFAULT 'dgut.jpg',
                      `dgut_username` varchar(30),
                      FOREIGN KEY (`dgut_username`) REFERENCES `dgutInfor`(`username`)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('hz', '123', '黄忠', '男','360782199812191011','1998-12-19', '汉族', '本科', '董事长','360000', '15622952928', '上海', '1278077017@qq.com','超级管理员','dgut.jpg',null);
INSERT INTO `user` VALUES ('ls', '123', '刘杉', '男','360782199909141733','1999-09-14', '汉族', '本科', '总经理','36000', '13268568191', '上海', '1151717268@qq.com','管理员','dgut.jpg',null);
INSERT INTO `user` VALUES ('ls', '123', '刘杉', '男','360782199909141733','1999-09-14', '汉族', '本科', '总经理','36000', '13268568191', '上海', '1151717268@qq.com','管理员','dgut.jpg',null);