2 Star 0 Fork 1

Eazen/实验5

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
文件
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
person.sql 3.68 KB
Copy Edit Raw Blame History
Eazen authored 2019-06-25 16:27 . update READ.MD
/*
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);
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/Eazen/ShiYan5.git
git@gitee.com:Eazen/ShiYan5.git
Eazen
ShiYan5
实验5
master

Search

0d507c66 1850385 C8b1a773 1850385