/*
SQLyog Ultimate v9.20 
MySQL - 5.5.62 : Database - emp
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`emp` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `emp`;

/*Table structure for table `employee` */

DROP TABLE IF EXISTS `employee`;

CREATE TABLE `employee` (
  `emp_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `emp_name` varchar(16) DEFAULT NULL COMMENT '员工姓名',
  `emp_department` varchar(32) DEFAULT NULL COMMENT '员工部门',
  `emp_birthday` date DEFAULT NULL COMMENT '员工生日',
  `emp_photo` varchar(255) DEFAULT NULL COMMENT '员工照片',
  `emp_tel` varchar(11) DEFAULT NULL COMMENT '员工电话',
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工表';

/*Data for the table `employee` */

insert  into `employee`(`emp_id`,`emp_name`,`emp_department`,`emp_birthday`,`emp_photo`,`emp_tel`) values (1,'张三','技术部','2020-12-01','张三_3fda8574-34d0-4de5-8776-2bbd7dc1db241.jpg','18341440000'),(3,'王五','财务部','2020-12-03','王五_76b68690-6af4-4178-b95c-a9a7152910143.jpeg','18341440002'),(4,'小明','运输部','2020-12-04','小明_fb79cf8d-3550-4fe2-9604-b4169b06b18a4.jpg','18341440003'),(5,'小红','秘书部','2020-12-05','小红_4a058a4f-2837-462a-b599-bd7d16dd12815.jpeg','18341440004');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
