/*
Navicat MySQL Data Transfer

Source Server         : 本地mysql
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : manager

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

Date: 2020-08-01 15:56:33
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `emp`
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(12) NOT NULL,
  `address` varchar(20) NOT NULL,
  `userRole` varchar(10) NOT NULL,
  `department` varchar(15) NOT NULL,
  `registerTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES ('1', '安全帽检测', '广州市天河区黄埔大道', '员工', '技术部', '2020-06-17 02:34:11');
INSERT INTO `emp` VALUES ('3', '唐安', '广州市天河区黄埔大道', '员工', '技术部', '2020-06-17 01:06:53');
INSERT INTO `emp` VALUES ('4', '孙悟空', '花果山', '员工', '人事部', '2020-06-22 16:22:51');
INSERT INTO `emp` VALUES ('5', '唐僧', '长安', '管理员', '人事部', '2020-06-22 13:36:26');
INSERT INTO `emp` VALUES ('6', '猪八戒', '高老庄', '员工', '技术部', '2020-06-22 13:36:45');
INSERT INTO `emp` VALUES ('7', ' 唐小安', '广州市天河区黄埔大道', '管理员', '人事部', '2020-06-22 23:59:28');
INSERT INTO `emp` VALUES ('8', '王五', '西安', '员工', '技术部', '2020-06-25 01:16:30');
INSERT INTO `emp` VALUES ('9', '赵六', '北京', '管理员', '人事部', '2020-06-25 01:16:46');
INSERT INTO `emp` VALUES ('10', '李六', '花果山', '员工', '技术部', '2020-06-25 01:18:28');
INSERT INTO `emp` VALUES ('11', '小红帽', '长安', '员工', '技术部', '2020-07-10 19:05:10');