/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : 51zxw

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

Date: 2020-03-21 16:43:37
*/
CREATE DATABASE `51zxw` ;

USE `51zxw`;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `empid` int(11) NOT NULL AUTO_INCREMENT,
  `empname` varchar(100) DEFAULT NULL,
  `bsaralry` double DEFAULT NULL,
  `hiredate` date DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `depid` int(11) DEFAULT NULL,
  PRIMARY KEY (`empid`),
  KEY `depid` (`depid`),
  CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`depid`) REFERENCES `depart` (`depid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1014 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('1002', '曹操', '10000', '2014-07-01', '北京市', '1');
INSERT INTO `employee` VALUES ('1003', '刘备', '9000', '2015-04-15', '上海市', '2');
INSERT INTO `employee` VALUES ('1004', '张飞', '7000', '2016-07-22', '重庆市', '3');
INSERT INTO `employee` VALUES ('1005', '关羽', '8500', '2016-05-03', '深圳市', '3');
INSERT INTO `employee` VALUES ('1006', '赵云', '7000', '2016-09-14', '广东省广州市', '3');
INSERT INTO `employee` VALUES ('1007', '诸葛亮', '12000', '2017-02-01', '陕西省西安市', '2');
INSERT INTO `employee` VALUES ('1008', '孙权', '10000', '2013-03-13', '山东省青岛市', '2');
INSERT INTO `employee` VALUES ('1009', '周瑜', '11000', '2015-06-09', '安徽省合肥市', '4');
INSERT INTO `employee` VALUES ('1010', ' 马超 ', '6500', '2011-03-21', '湖南省长沙市', '4');
INSERT INTO `employee` VALUES ('1011', ' 魏延 ', '7000', '2012-06-01', '浙江省杭州市', '4');
INSERT INTO `employee` VALUES ('1012', '黄忠', '8000', '2010-01-05', '福建省福州市', '4');
INSERT INTO `employee` VALUES ('1013', '黄盖', '6600', '2013-10-16', '贵州省贵阳市', '4');

-- ----------------------------
-- Table structure for depart
-- ----------------------------
DROP TABLE IF EXISTS `depart`;
CREATE TABLE `depart` (
  `depid` int(11) NOT NULL AUTO_INCREMENT,
  `depname` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`depid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of depart
-- ----------------------------
INSERT INTO `depart` VALUES ('1', '财务部');
INSERT INTO `depart` VALUES ('2', '人力资源部');
INSERT INTO `depart` VALUES ('3', '开发部');
INSERT INTO `depart` VALUES ('4', '技术部');
INSERT INTO `depart` VALUES ('5', '运维部');
INSERT INTO `depart` VALUES ('6', '运营部');
INSERT INTO `depart` VALUES ('7', '市场部');