-- MySQL dump 10.13  Distrib 5.7.30, for Win64 (x86_64)
--
-- Host: localhost    Database: personnel_sys
-- ------------------------------------------------------
-- Server version	5.7.30-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `sys_chanage`
--

DROP TABLE IF EXISTS `sys_chanage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_chanage` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `old_chanage` varchar(255) DEFAULT NULL COMMENT '原职位',
  `new_chanage` varchar(255) DEFAULT NULL COMMENT '新职位',
  `eid` int(255) DEFAULT NULL COMMENT '员工id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_chanage`
--

LOCK TABLES `sys_chanage` WRITE;
/*!40000 ALTER TABLE `sys_chanage` DISABLE KEYS */;
INSERT INTO `sys_chanage` VALUES (5,'4','5',3,'2021-04-12 18:01:24',1),(6,'333','无业',5,'2021-04-12 18:01:58',1);
/*!40000 ALTER TABLE `sys_chanage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_check`
--

DROP TABLE IF EXISTS `sys_check`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_check` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `check_name` varchar(255) DEFAULT NULL COMMENT '考核名称',
  `check_type` varchar(255) DEFAULT NULL COMMENT '考核类型',
  `time` datetime DEFAULT NULL COMMENT '考核时间',
  `eid` int(11) DEFAULT NULL COMMENT '员工id',
  `check_content` varchar(255) DEFAULT NULL COMMENT '考核内容',
  `check_result` varchar(255) DEFAULT NULL COMMENT '考核结果',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_check`
--

LOCK TABLES `sys_check` WRITE;
/*!40000 ALTER TABLE `sys_check` DISABLE KEYS */;
INSERT INTO `sys_check` VALUES (1,'考核1','测试考核','2021-04-14 00:00:00',3,'测试','0','2021-04-13 09:38:53','2021-04-13 09:41:15',1,1);
/*!40000 ALTER TABLE `sys_check` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dept`
--

DROP TABLE IF EXISTS `sys_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `dept_name` varchar(255) DEFAULT NULL COMMENT '部门名称',
  `dept_describe` varchar(255) DEFAULT NULL COMMENT '部门描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dept`
--

LOCK TABLES `sys_dept` WRITE;
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
INSERT INTO `sys_dept` VALUES (3,'人事','人事'),(4,'财务','财务'),(5,'行政','行政'),(6,'市场','市场');
/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_employee`
--

DROP TABLE IF EXISTS `sys_employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_employee` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `employee_name` varchar(255) DEFAULT NULL COMMENT '员工名称',
  `sex` varchar(255) DEFAULT NULL COMMENT '性别',
  `birth` varchar(255) DEFAULT NULL COMMENT '出生日期',
  `id_no` varchar(255) DEFAULT NULL COMMENT '身份证号',
  `marital_status` varchar(255) DEFAULT NULL COMMENT '婚姻状态（0未婚，1已婚）',
  `nation` varchar(255) DEFAULT NULL COMMENT '民族',
  `politic_countenance` varchar(255) DEFAULT NULL COMMENT '政治面貌',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱 ',
  `phone` varchar(255) DEFAULT NULL COMMENT '电话',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `dept_id` int(255) DEFAULT NULL COMMENT '部门id',
  `position_name` varchar(255) DEFAULT NULL COMMENT '职位',
  `academic_title` int(255) DEFAULT NULL COMMENT '职称',
  `educational_background` varchar(255) DEFAULT NULL COMMENT '教育背景',
  `school` varchar(255) DEFAULT NULL COMMENT '毕业学校',
  `entry_time` datetime DEFAULT NULL COMMENT '入职时间',
  `status` varchar(255) DEFAULT NULL COMMENT '状态',
  `contract_term` varchar(255) DEFAULT NULL COMMENT '合同期',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` varchar(255) DEFAULT NULL COMMENT '删除标识',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  `photo_url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_employee`
--

LOCK TABLES `sys_employee` WRITE;
/*!40000 ALTER TABLE `sys_employee` DISABLE KEYS */;
INSERT INTO `sys_employee` VALUES (3,'测试1','1','2021-03-31T16:00:00.000Z','111','1','汉族','0','[email protected]','123456','1',3,'5',1,'0','1','2021-04-01 00:00:00','1','2021-03-31T16:00:00.000Z','2021-04-10 09:17:20','2021-04-14 09:26:34','0',1,1,'5e64d7ec136848748bda240925a8080d.jpg'),(5,'1','1','2021-03-30T16:00:00.000Z','2','1','3','0','[email protected]','111','222',3,'无业',444,'3','555','2021-04-28 00:00:00','1','2021-04-29T16:00:00.000Z','2021-04-10 09:53:54','2021-04-14 10:27:28','0',1,1,'b26f8c7967d34b47932ba1e5cca93d7c.png'),(8,'1112312','1','2021-04-05T16:00:00.000Z','11','1','123','1','123123','123','12412',4,'123',123,'2','123','2021-04-28 00:00:00','1','2021-04-23T16:00:00.000Z','2021-04-14 10:32:59','2021-04-14 10:32:59','0',1,NULL,'b26f8c7967d34b47932ba1e5cca93d7c.png');
/*!40000 ALTER TABLE `sys_employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_employee_attendance`
--

DROP TABLE IF EXISTS `sys_employee_attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_employee_attendance` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `eid` int(255) DEFAULT NULL COMMENT '员工id',
  `dept_name` varchar(255) DEFAULT NULL COMMENT '部门名称',
  `attendance` varchar(255) DEFAULT NULL COMMENT '出勤情况（1正常，2迟到，3早退，4缺勤，5请假）',
  `create_time` datetime DEFAULT NULL COMMENT '时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `go_work_time` datetime DEFAULT NULL COMMENT '上班时间',
  `go_off_work_time` datetime DEFAULT NULL COMMENT '下班时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='出勤';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_employee_attendance`
--

LOCK TABLES `sys_employee_attendance` WRITE;
/*!40000 ALTER TABLE `sys_employee_attendance` DISABLE KEYS */;
INSERT INTO `sys_employee_attendance` VALUES (1,3,'人事','1',NULL,NULL,'1','2021-04-10 09:30:00','2021-04-10 15:30:00'),(2,5,'人事','2','2021-04-10 15:11:54','1','3','2021-04-10 09:30:00','2021-04-10 15:30:00'),(3,5,'人事','3','2021-04-10 15:13:16','1','1','2021-04-10 09:30:00','2021-04-10 15:30:00'),(5,3,'人事','4','2021-04-12 09:57:37','1','3','2021-04-12 09:30:00','2021-04-12 15:30:00');
/*!40000 ALTER TABLE `sys_employee_attendance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_employee_salary`
--

DROP TABLE IF EXISTS `sys_employee_salary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_employee_salary` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `must_salary` varchar(255) DEFAULT NULL COMMENT '基本工资',
  `reality_salary` varchar(255) DEFAULT NULL COMMENT '全勤工资',
  `fund_amount` varchar(255) DEFAULT NULL COMMENT '迟到扣款',
  `tax_amount` varchar(255) DEFAULT NULL COMMENT '请假扣款',
  `pension_amount` varchar(255) DEFAULT NULL COMMENT '个税',
  `injured_mount` varchar(255) DEFAULT NULL COMMENT '五险一金',
  `eid` int(255) DEFAULT NULL COMMENT '员工id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建人',
  `update_by` int(255) DEFAULT NULL COMMENT '修改人',
  `salary_month` varchar(255) DEFAULT NULL COMMENT '工资月份',
  `employee_name` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  `total_salary` varchar(255) DEFAULT NULL COMMENT '合计工资',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='工资';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_employee_salary`
--

LOCK TABLES `sys_employee_salary` WRITE;
/*!40000 ALTER TABLE `sys_employee_salary` DISABLE KEYS */;
INSERT INTO `sys_employee_salary` VALUES (8,'300','0','0','0','0','0',3,'2021-04-10 16:10:56','2021-04-10 16:10:56',1,NULL,'2021-03-31T16:00:00.000Z','测试1','300');
/*!40000 ALTER TABLE `sys_employee_salary` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log`
--

DROP TABLE IF EXISTS `sys_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `create_time` datetime DEFAULT NULL COMMENT '操作时间',
  `operation` varchar(255) DEFAULT NULL COMMENT '操作',
  `method` varchar(255) DEFAULT NULL COMMENT '请求方法',
  `ip` varchar(255) DEFAULT NULL COMMENT 'ip地址',
  `params` text COMMENT '请求参数',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log`
--

LOCK TABLES `sys_log` WRITE;
/*!40000 ALTER TABLE `sys_log` DISABLE KEYS */;
INSERT INTO `sys_log` VALUES (158,'admin','2021-04-13 16:09:43','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(159,'admin','2021-04-13 16:09:53','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(160,'admin','2021-04-13 16:11:47','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(161,'admin','2021-04-13 16:15:13','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(162,'admin','2021-04-13 16:16:15','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(163,'admin','2021-04-13 16:19:14','获取所有员工','com.sys.controller.EmployeeController.getAllEmployee','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(164,'admin','2021-04-13 17:31:10','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":6,\"updateTime\":1618306270008,\"url\":\"/employeeSalary/salarys\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306270008,\"perms\":\"salary:list\",\"id\":36,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(165,'admin','2021-04-13 17:31:58','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":6,\"updateTime\":1618306318031,\"url\":\"employeeSalary/salary\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306318031,\"perms\":\"salary:add\",\"id\":37,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(166,'admin','2021-04-13 17:32:54','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":6,\"updateTime\":1618306373672,\"url\":\"/employeeSalary/salaryUpd\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306373672,\"perms\":\"salary:upd\",\"id\":38,\"permissionName\":\"更新\",\"status\":\"2\"}]',1),(167,'admin','2021-04-13 17:37:54','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":7,\"updateTime\":1618306674043,\"url\":\"/rewards-and-punishments/listAllRewardsAndPunishments\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306674043,\"perms\":\"rp:list\",\"id\":39,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(168,'admin','2021-04-13 17:38:29','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":7,\"updateTime\":1618306709002,\"url\":\"/rewards-and-punishments/addRewardsAndPunishments\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306709002,\"perms\":\"rp:add\",\"id\":40,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(169,'admin','2021-04-13 17:39:13','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":7,\"updateTime\":1618306753170,\"url\":\"/rewards-and-punishments/updRewardsAndPunishments\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306753170,\"perms\":\"rp:upd\",\"id\":41,\"permissionName\":\"编辑\",\"status\":\"2\"}]',1),(170,'admin','2021-04-13 17:39:47','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":7,\"updateTime\":1618306787349,\"url\":\"/rewards-and-punishments/delRewardsAndPunishments\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306787349,\"perms\":\"rp:del\",\"id\":42,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(171,'admin','2021-04-13 17:41:40','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":19,\"updateTime\":1618306899913,\"url\":\"/training/listAllTraining\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306899913,\"perms\":\"training:list\",\"id\":43,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(172,'admin','2021-04-13 17:42:37','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":19,\"updateTime\":1618306956665,\"url\":\"/training/addTraining\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618306956665,\"perms\":\"training:add\",\"id\":44,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(173,'admin','2021-04-13 17:44:45','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":19,\"updateTime\":1618307085164,\"url\":\"/training/updTraining\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307085164,\"perms\":\"training:upd\",\"id\":45,\"permissionName\":\"更新\",\"status\":\"2\"}]',1),(174,'admin','2021-04-13 17:45:23','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":19,\"updateTime\":1618307122494,\"url\":\"/training/delTraining\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307122494,\"perms\":\"training:del\",\"id\":46,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(175,'admin','2021-04-13 17:47:33','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":20,\"updateTime\":1618307252392,\"url\":\"/check/listAllCheck\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307252392,\"perms\":\"check:list\",\"id\":47,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(176,'admin','2021-04-13 17:48:12','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":20,\"updateTime\":1618307292298,\"url\":\"/check/addCheck\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307292298,\"perms\":\"check:add\",\"id\":48,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(177,'admin','2021-04-13 17:48:51','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":20,\"updateTime\":1618307331226,\"url\":\"/check//check\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307331226,\"perms\":\"check:upd\",\"id\":49,\"permissionName\":\"编辑\",\"status\":\"2\"}]',1),(178,'admin','2021-04-13 17:49:23','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":20,\"updateTime\":1618307362528,\"url\":\"/check/delCheck\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307362528,\"perms\":\"check:del\",\"id\":50,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(179,'admin','2021-04-13 17:50:00','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":21,\"updateTime\":1618307399514,\"url\":\"/chanage/listAllChanage\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307399514,\"perms\":\"chanage:list\",\"id\":51,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(180,'admin','2021-04-13 17:53:21','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":9,\"updateTime\":1618307600539,\"url\":\"/user/listAllUser\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307600539,\"perms\":\"user:list\",\"id\":52,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(181,'admin','2021-04-13 17:54:34','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":9,\"updateTime\":1618307673700,\"url\":\"/user/updUser\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307673700,\"perms\":\"user:upd\",\"id\":53,\"permissionName\":\"编辑\",\"status\":\"2\"}]',1),(182,'admin','2021-04-13 17:55:02','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":9,\"updateTime\":1618307701566,\"url\":\"/user/delUser\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307701566,\"perms\":\"user:del\",\"id\":54,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(183,'admin','2021-04-13 17:55:50','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":9,\"updateTime\":1618307749986,\"url\":\"/user/relationRole\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307749986,\"perms\":\"user:relation\",\"id\":55,\"permissionName\":\"用户关联角色\",\"status\":\"2\"}]',1),(184,'admin','2021-04-13 17:56:46','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":10,\"updateTime\":1618307805864,\"url\":\"/role/listAllRole\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307805864,\"perms\":\"role:list\",\"id\":56,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(185,'admin','2021-04-13 17:57:32','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":10,\"updateTime\":1618307851831,\"url\":\"/role/addRole\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307851831,\"perms\":\"role:add\",\"id\":57,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(186,'admin','2021-04-13 17:58:00','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":10,\"updateTime\":1618307879491,\"url\":\"/role/updRole\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307879491,\"perms\":\"role:upd\",\"id\":58,\"permissionName\":\"编辑\",\"status\":\"2\"}]',1),(187,'admin','2021-04-13 17:58:27','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":10,\"updateTime\":1618307907067,\"url\":\"/role/delRole\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307907067,\"perms\":\"role:del\",\"id\":59,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(188,'admin','2021-04-13 17:59:41','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":12,\"updateTime\":1618307980433,\"url\":\"/dept/listAllDeptName\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618307980433,\"perms\":\"dept:list\",\"id\":60,\"permissionName\":\"列表\",\"status\":\"2\"}]',1),(189,'admin','2021-04-13 18:00:06','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":12,\"updateTime\":1618308005546,\"url\":\"/dept/addDept\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618308005546,\"perms\":\"dept:add\",\"id\":61,\"permissionName\":\"添加\",\"status\":\"2\"}]',1),(190,'admin','2021-04-13 18:00:32','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":12,\"updateTime\":1618308031521,\"url\":\"/dept/updDept\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618308031521,\"perms\":\"dept:upd\",\"id\":62,\"permissionName\":\"编辑\",\"status\":\"2\"}]',1),(191,'admin','2021-04-13 18:00:58','添加权限','com.sys.controller.PermissionController.addPermission','192.168.32.1','[{\"pid\":12,\"updateTime\":1618308057718,\"url\":\"/dept/delDept\",\"createBy\":1,\"deleted\":\"0\",\"createTime\":1618308057718,\"perms\":\"dept:del\",\"id\":63,\"permissionName\":\"删除\",\"status\":\"2\"}]',1),(192,'admin','2021-04-13 18:05:41','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[1,2,23,24,4,5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50,21,51,8,9,13,52,53,54,55,10,35,56,57,58,59,11,22,31,32,33,34,12,60,61,62,63],\"rId\":1}]',1),(193,'admin','2021-04-13 18:06:36','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[1,2,23,24,4,5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50,21,51,8,9,13,52,53,54,55,10,35,56,57,58,59,11,22,31,32,33,34,12,60,61,62,63],\"rId\":1}]',1),(194,'admin','2021-04-13 18:07:02','获取所有部门','com.sys.controller.DeptController.getAllDept','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(195,'admin','2021-04-14 10:31:39','删除员工信息','com.sys.controller.EmployeeController.delEmployee','192.168.32.1','[6]',1),(196,'admin','2021-04-14 10:33:00','添加新员工','com.sys.controller.EmployeeController.addEmployee','192.168.32.1','[{\"politicCountenance\":\"1\",\"nation\":\"123\",\"idNo\":\"11\",\"positionName\":\"123\",\"photoUrl\":\"b26f8c7967d34b47932ba1e5cca93d7c.png\",\"school\":\"123\",\"limit\":10,\"educationalBackground\":\"2\",\"id\":8,\"email\":\"123123\",\"employeeName\":\"1112312\",\"address\":\"12412\",\"sex\":\"1\",\"deptId\":4,\"birth\":\"2021-04-05T16:00:00.000Z\",\"updateTime\":1618367579344,\"academicTitle\":123,\"createBy\":1,\"entryTime\":1619539200000,\"deleted\":\"0\",\"createTime\":1618367579344,\"phone\":\"123\",\"contractTerm\":\"2021-04-23T16:00:00.000Z\",\"page\":1,\"maritalStatus\":\"1\",\"status\":\"1\"}]',1),(197,'admin','2021-04-14 11:45:17','获取所有部门','com.sys.controller.DeptController.getAllDept','192.168.32.1','[{\"limit\":10,\"page\":1}]',1),(198,'admin','2021-04-14 14:36:35','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[4,5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50,21,51],\"rId\":3}]',1),(199,'admin','2021-04-14 14:38:02','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50],\"rId\":3}]',1),(200,'admin','2021-04-14 14:39:26','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[1,2,23,24,4,5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50,21,51,8,9,13,52,53,54,55,10,35,56,57,58,59,11,22,31,32,33,34,12,60,61,62,63],\"rId\":1}]',1),(201,'admin','2021-04-14 14:40:48','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[14,15,16],\"rId\":4}]',1),(202,'admin','2021-04-14 14:41:17','更新角色信息','com.sys.controller.RoleController.updRole','192.168.32.1','[{\"updateBy\":1,\"limit\":10,\"roleName\":\"renshi\",\"updateTime\":1618382477255,\"id\":3,\"page\":1,\"status\":\"1\"}]',1),(203,'admin','2021-04-14 14:41:24','更新角色信息','com.sys.controller.RoleController.updRole','192.168.32.1','[{\"updateBy\":1,\"limit\":10,\"roleName\":\"人事\",\"updateTime\":1618382484140,\"id\":3,\"page\":1,\"status\":\"1\"}]',1),(204,'admin','2021-04-14 14:41:44','添加新用户','com.sys.controller.UserController.addUser','192.168.32.1','[{\"createBy\":1,\"password\":\"aVa5279f3bsc743cE75X17qe3L1fl9bQ72B1cAaeN86uf9C0\",\"deleted\":\"0\",\"createTime\":1618382504282,\"limit\":10,\"updateTime\":1618382504282,\"id\":31,\"page\":1,\"salet\":\"V2fs4EXqLlQBANuC\",\"status\":\"1\",\"username\":\"renshi\"}]',1),(205,'admin','2021-04-14 14:41:49','用户关联角色','com.sys.controller.UserController.relationRole','192.168.32.1','[{\"uId\":31,\"rId\":[3]}]',1),(206,'admin','2021-04-14 14:44:07','角色关联权限','com.sys.controller.PermissionController.relationPermission','192.168.32.1','[{\"pId\":[4,5,29,30,6,36,37,38,7,39,40,41,42,18,25,26,27,28,19,43,44,45,46,20,47,48,49,50,21,51,22],\"rId\":3}]',1),(207,'admin','2021-04-22 11:00:35','获取所有部门','com.sys.controller.DeptController.getAllDept','192.168.32.1','[{\"limit\":10,\"page\":1}]',1);
/*!40000 ALTER TABLE `sys_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_permission`
--

DROP TABLE IF EXISTS `sys_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_permission` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `permission_name` varchar(255) DEFAULT NULL COMMENT '名称',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `url` varchar(255) DEFAULT NULL COMMENT 'url',
  `status` varchar(255) DEFAULT NULL COMMENT '状态（0、目录，1、菜单、2按钮）',
  `pid` int(255) DEFAULT NULL COMMENT '父级id',
  `deleted` varchar(255) DEFAULT NULL COMMENT '删除标识',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_permission`
--

LOCK TABLES `sys_permission` WRITE;
/*!40000 ALTER TABLE `sys_permission` DISABLE KEYS */;
INSERT INTO `sys_permission` VALUES (1,'系统管理',NULL,NULL,'0',0,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(2,'日志管理',NULL,'/sys/log','1',1,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(3,'接口管理',NULL,'/sys/swagger','1',1,'1','2021-04-08 11:16:17','2021-04-12 13:33:47',1,1),(4,'人事管理',NULL,'','0',0,'0','2021-04-08 11:16:17','2021-04-08 15:04:41',1,1),(5,'出勤管理',NULL,'/personnel/attendance','1',4,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(6,'工资管理',NULL,'/personnel/salary','1',4,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(7,'员工奖惩',NULL,'/personnel/rewardandpunishment','1',4,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(8,'组织管理',NULL,'','0',0,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(9,'用户管理',NULL,'/sys/user','1',8,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(10,'角色管理',NULL,'/sys/role','1',8,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(11,'权限管理',NULL,'/sys/permission','1',8,'0','2021-04-08 11:16:17','2021-04-13 11:24:57',1,1),(12,'部门管理',NULL,'/sys/dept','1',8,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(13,'添加','user:add','/user/addUser','2',9,'0','2021-04-08 11:16:17','2021-04-08 11:16:17',1,1),(14,'测试','','','0',0,'0','2021-04-09 10:45:44','2021-04-10 14:15:58',1,1),(15,'测试菜单','','/测试','1',14,'0','2021-04-09 10:45:58','2021-04-09 10:45:58',1,NULL),(16,'测试按钮','测试：测试','/测试/测试','2',15,'0','2021-04-09 10:46:19','2021-04-10 14:15:44',1,1),(18,'员工管理','','/personnel/employee','1',4,'0','2021-04-09 16:06:39','2021-04-09 16:06:39',1,NULL),(19,'培训管理','','/personnel/training','1',4,'0','2021-04-12 13:39:34','2021-04-12 13:39:34',1,NULL),(20,'员工考核','','/personnel/check','1',4,'0','2021-04-12 13:40:26','2021-04-12 13:40:26',1,NULL),(21,'人事变动','','/personnel/change','1',4,'0','2021-04-12 13:40:57','2021-04-12 13:40:57',1,NULL),(22,'菜单列表','menu:list','/permission/getMenu','2',11,'0','2021-04-13 11:33:41','2021-04-13 11:33:41',1,NULL),(23,'查看日志','log:list','/log/queryLog','2',2,'0','2021-04-13 14:43:53','2021-04-13 14:52:59',1,1),(24,'批量删除','log:remove','/log/removeLog','2',2,'0','2021-04-13 14:54:18','2021-04-13 14:54:18',1,NULL),(25,'列表','employee:list','/employee/listAllEmployee','2',18,'0','2021-04-13 16:23:51','2021-04-13 16:23:51',1,NULL),(26,'添加','employee:add','/employee/addEmployee','2',18,'0','2021-04-13 16:24:24','2021-04-13 16:24:24',1,NULL),(27,'更新','employee:upd','/employee/updEmployee','2',18,'0','2021-04-13 16:25:02','2021-04-13 16:25:02',1,NULL),(28,'删除','employee:del','/employee/delEmployee','2',18,'0','2021-04-13 16:25:39','2021-04-13 16:25:39',1,NULL),(29,'列表','attendance:list','/employeeAttendance/attendances','2',5,'0','2021-04-13 16:28:58','2021-04-13 16:29:47',1,1),(30,'添加','attendance:add','/employeeAttendance/attendanceAdd','2',5,'0','2021-04-13 16:29:36','2021-04-13 16:29:36',1,NULL),(31,'列表','permission:list','/permission/listAllPermission','2',11,'0','2021-04-13 16:52:19','2021-04-13 16:52:19',1,NULL),(32,'添加','permission:add','/permission/addPermission','2',11,'0','2021-04-13 16:53:02','2021-04-13 16:53:02',1,NULL),(33,'编辑','permission:upd','/permission/permission','2',11,'0','2021-04-13 16:53:41','2021-04-13 16:53:41',1,NULL),(34,'删除','permission:del','/permission/permission','2',11,'0','2021-04-13 16:54:27','2021-04-13 16:54:27',1,NULL),(35,'角色关联权限','permission:relation','/permission/permission','2',10,'0','2021-04-13 16:55:10','2021-04-13 16:55:10',1,NULL),(36,'列表','salary:list','/employeeSalary/salarys','2',6,'0','2021-04-13 17:31:10','2021-04-13 17:31:10',1,NULL),(37,'添加','salary:add','employeeSalary/salary','2',6,'0','2021-04-13 17:31:58','2021-04-13 17:31:58',1,NULL),(38,'更新','salary:upd','/employeeSalary/salaryUpd','2',6,'0','2021-04-13 17:32:54','2021-04-13 17:32:54',1,NULL),(39,'列表','rp:list','/rewards-and-punishments/listAllRewardsAndPunishments','2',7,'0','2021-04-13 17:37:54','2021-04-13 17:37:54',1,NULL),(40,'添加','rp:add','/rewards-and-punishments/addRewardsAndPunishments','2',7,'0','2021-04-13 17:38:29','2021-04-13 17:38:29',1,NULL),(41,'编辑','rp:upd','/rewards-and-punishments/updRewardsAndPunishments','2',7,'0','2021-04-13 17:39:13','2021-04-13 17:39:13',1,NULL),(42,'删除','rp:del','/rewards-and-punishments/delRewardsAndPunishments','2',7,'0','2021-04-13 17:39:47','2021-04-13 17:39:47',1,NULL),(43,'列表','training:list','/training/listAllTraining','2',19,'0','2021-04-13 17:41:40','2021-04-13 17:41:40',1,NULL),(44,'添加','training:add','/training/addTraining','2',19,'0','2021-04-13 17:42:37','2021-04-13 17:42:37',1,NULL),(45,'更新','training:upd','/training/updTraining','2',19,'0','2021-04-13 17:44:45','2021-04-13 17:44:45',1,NULL),(46,'删除','training:del','/training/delTraining','2',19,'0','2021-04-13 17:45:22','2021-04-13 17:45:22',1,NULL),(47,'列表','check:list','/check/listAllCheck','2',20,'0','2021-04-13 17:47:32','2021-04-13 17:47:32',1,NULL),(48,'添加','check:add','/check/addCheck','2',20,'0','2021-04-13 17:48:12','2021-04-13 17:48:12',1,NULL),(49,'编辑','check:upd','/check//check','2',20,'0','2021-04-13 17:48:51','2021-04-13 17:48:51',1,NULL),(50,'删除','check:del','/check/delCheck','2',20,'0','2021-04-13 17:49:23','2021-04-13 17:49:23',1,NULL),(51,'列表','chanage:list','/chanage/listAllChanage','2',21,'0','2021-04-13 17:50:00','2021-04-13 17:50:00',1,NULL),(52,'列表','user:list','/user/listAllUser','2',9,'0','2021-04-13 17:53:21','2021-04-13 17:53:21',1,NULL),(53,'编辑','user:upd','/user/updUser','2',9,'0','2021-04-13 17:54:34','2021-04-13 17:54:34',1,NULL),(54,'删除','user:del','/user/delUser','2',9,'0','2021-04-13 17:55:02','2021-04-13 17:55:02',1,NULL),(55,'用户关联角色','user:relation','/user/relationRole','2',9,'0','2021-04-13 17:55:50','2021-04-13 17:55:50',1,NULL),(56,'列表','role:list','/role/listAllRole','2',10,'0','2021-04-13 17:56:46','2021-04-13 17:56:46',1,NULL),(57,'添加','role:add','/role/addRole','2',10,'0','2021-04-13 17:57:32','2021-04-13 17:57:32',1,NULL),(58,'编辑','role:upd','/role/updRole','2',10,'0','2021-04-13 17:57:59','2021-04-13 17:57:59',1,NULL),(59,'删除','role:del','/role/delRole','2',10,'0','2021-04-13 17:58:27','2021-04-13 17:58:27',1,NULL),(60,'列表','dept:list','/dept/listAllDeptName','2',12,'0','2021-04-13 17:59:40','2021-04-13 17:59:40',1,NULL),(61,'添加','dept:add','/dept/addDept','2',12,'0','2021-04-13 18:00:06','2021-04-13 18:00:06',1,NULL),(62,'编辑','dept:upd','/dept/updDept','2',12,'0','2021-04-13 18:00:32','2021-04-13 18:00:32',1,NULL),(63,'删除','dept:del','/dept/delDept','2',12,'0','2021-04-13 18:00:58','2021-04-13 18:00:58',1,NULL);
/*!40000 ALTER TABLE `sys_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_rewards_and_punishments`
--

DROP TABLE IF EXISTS `sys_rewards_and_punishments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_rewards_and_punishments` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `time` datetime DEFAULT NULL COMMENT '奖惩时间',
  `reason` varchar(255) DEFAULT NULL COMMENT '原因',
  `type` varchar(255) DEFAULT NULL COMMENT '类型（0、奖，1、惩）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  `eid` int(255) DEFAULT NULL COMMENT '员工编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_rewards_and_punishments`
--

LOCK TABLES `sys_rewards_and_punishments` WRITE;
/*!40000 ALTER TABLE `sys_rewards_and_punishments` DISABLE KEYS */;
INSERT INTO `sys_rewards_and_punishments` VALUES (1,'2021-04-12 00:00:00','2222','0','2021-04-12 16:40:22','2021-04-12 16:42:06',1,1,3);
/*!40000 ALTER TABLE `sys_rewards_and_punishments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `role_name` varchar(255) DEFAULT NULL COMMENT '角色名',
  `status` varchar(255) DEFAULT NULL COMMENT '角色状态',
  `deleted` varchar(255) DEFAULT NULL COMMENT '删除状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'管理员','1','0','2021-04-08 09:16:20','2021-04-08 09:16:23',NULL,NULL),(3,'人事','1','0',NULL,'2021-04-14 14:41:24',1,1),(4,'测试','1','0',NULL,NULL,1,1);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_permission`
--

DROP TABLE IF EXISTS `sys_role_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_permission` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `role_id` int(255) DEFAULT NULL,
  `permission_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=467 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_permission`
--

LOCK TABLES `sys_role_permission` WRITE;
/*!40000 ALTER TABLE `sys_role_permission` DISABLE KEYS */;
INSERT INTO `sys_role_permission` VALUES (375,1,1),(376,1,2),(377,1,23),(378,1,24),(379,1,4),(380,1,5),(381,1,29),(382,1,30),(383,1,6),(384,1,36),(385,1,37),(386,1,38),(387,1,7),(388,1,39),(389,1,40),(390,1,41),(391,1,42),(392,1,18),(393,1,25),(394,1,26),(395,1,27),(396,1,28),(397,1,19),(398,1,43),(399,1,44),(400,1,45),(401,1,46),(402,1,20),(403,1,47),(404,1,48),(405,1,49),(406,1,50),(407,1,21),(408,1,51),(409,1,8),(410,1,9),(411,1,13),(412,1,52),(413,1,53),(414,1,54),(415,1,55),(416,1,10),(417,1,35),(418,1,56),(419,1,57),(420,1,58),(421,1,59),(422,1,11),(423,1,22),(424,1,31),(425,1,32),(426,1,33),(427,1,34),(428,1,12),(429,1,60),(430,1,61),(431,1,62),(432,1,63),(433,4,14),(434,4,15),(435,4,16),(436,3,4),(437,3,5),(438,3,29),(439,3,30),(440,3,6),(441,3,36),(442,3,37),(443,3,38),(444,3,7),(445,3,39),(446,3,40),(447,3,41),(448,3,42),(449,3,18),(450,3,25),(451,3,26),(452,3,27),(453,3,28),(454,3,19),(455,3,43),(456,3,44),(457,3,45),(458,3,46),(459,3,20),(460,3,47),(461,3,48),(462,3,49),(463,3,50),(464,3,21),(465,3,51),(466,3,22);
/*!40000 ALTER TABLE `sys_role_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_training`
--

DROP TABLE IF EXISTS `sys_training`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_training` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `training_content` varchar(255) DEFAULT NULL COMMENT '培训内容',
  `time` datetime DEFAULT NULL COMMENT '培训时间',
  `type` varchar(255) DEFAULT NULL COMMENT '培训类型',
  `price` varchar(255) DEFAULT NULL COMMENT '培训价格',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  `eid` int(11) DEFAULT NULL COMMENT '员工编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_training`
--

LOCK TABLES `sys_training` WRITE;
/*!40000 ALTER TABLE `sys_training` DISABLE KEYS */;
INSERT INTO `sys_training` VALUES (2,'培训1','2021-04-12 00:00:00','员工培训','10',NULL,'2021-04-12 16:25:11',1,NULL,3),(3,'技术培训','2021-04-12 00:00:00','外出培训','100','2021-04-12 16:06:31','2021-04-12 16:06:31',1,NULL,5);
/*!40000 ALTER TABLE `sys_training` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `salet` varchar(255) DEFAULT NULL COMMENT '加密',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(255) DEFAULT NULL COMMENT '创建者',
  `update_by` int(255) DEFAULT NULL COMMENT '更新者',
  `status` varchar(255) DEFAULT NULL COMMENT '用户状态',
  `deleted` varchar(255) DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'admin','fp27B63ja3U6etb5Ha8l89004H04l91Nb4rff279wefsf0Ud','pBjUtHl0HlNr2wsU','2021-04-07 15:15:24','2021-04-07 15:15:27',1,1,'1','0'),(28,'test','7h21pcfl56Ka5fbe8226e3nac839X09Sa6oe5W52B77rdbv6','hplKf86n8XSoWBrv','2021-04-07 17:38:07','2021-04-08 08:29:33',1,1,'1','0'),(29,'1111','1F81La8d24T00Gbdg16a3ex5938eP4fy06J58j17Pce112n3','FLdTGgax3PyJjP1n','2021-04-07 17:42:21','2021-04-08 08:37:40',1,1,'0','1'),(30,'123123','bH0ah582d6n66Z87L82833e5bwffN23s21j13se2U33Td6h5','Hh2nZL8ewNsjsUTh','2021-04-08 08:42:49','2021-04-08 08:43:11',1,1,'1','1'),(31,'renshi','aVa5279f3bsc743cE75X17qe3L1fl9bQ72B1cAaeN86uf9C0','V2fs4EXqLlQBANuC','2021-04-14 14:41:44','2021-04-14 14:41:44',1,NULL,'1','0');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_role`
--

DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_role` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `role_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_role`
--

LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` VALUES (1,1,1),(27,28,4),(28,28,3),(29,31,3);
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-04-22 11:25:16