/*
 Navicat Premium Data Transfer

 Source Server         : sql1
 Source Server Type    : MySQL
 Source Server Version : 50541
 Source Host           : localhost:3306
 Source Schema         : db_hrmsys

 Target Server Type    : MySQL
 Target Server Version : 50541
 File Encoding         : 65001

 Date: 15/06/2020 22:06:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for boon
-- ----------------------------
DROP TABLE IF EXISTS `boon`;
CREATE TABLE `boon`  (
  `boon_id` int(10) UNSIGNED NOT NULL,
  `boon_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `boon_money` float NULL DEFAULT NULL,
  `boon_percent` float NULL DEFAULT NULL,
  `boon_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`boon_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of boon
-- ----------------------------
INSERT INTO `boon` VALUES (1, '养老保险', 1000, 8, NULL);
INSERT INTO `boon` VALUES (2, '医疗保险', 500, 5, NULL);
INSERT INTO `boon` VALUES (3, '失业保险', 400, 1.5, NULL);
INSERT INTO `boon` VALUES (4, '工伤保险', 500, 1, 'undefined');
INSERT INTO `boon` VALUES (5, '生育保险', 300, 0, NULL);
INSERT INTO `boon` VALUES (6, '住房公积金', 1000, 10, 'undefined');

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `dept_id` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `dept_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `dept_mgr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dept_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('01', '经理办', '李官', '备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注');
INSERT INTO `department` VALUES ('02', '行政部', '李四', '行政部门');
INSERT INTO `department` VALUES ('03', '人力资源部', '孙七', '');
INSERT INTO `department` VALUES ('04', '平台软件部', 'sum', '');
INSERT INTO `department` VALUES ('05', '产品部', 'jdongo', '');
INSERT INTO `department` VALUES ('06', '质量部', 'fenha', '');
INSERT INTO `department` VALUES ('07', '嵌入式部', 'cache', '');

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `dept_id` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_sex` int(11) NOT NULL,
  `emp_birth` date NOT NULL,
  `emp_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_post` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_mobilephone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_qq` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_idcard` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `emp_photo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_add_date` date NULL DEFAULT NULL,
  `emp_add_person` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_job` int(11) NULL DEFAULT NULL,
  `emp_bank` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_nationality` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_origin` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_nation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_school` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_education` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `emp_profession` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`emp_id`) USING BTREE,
  INDEX `FK_employee`(`emp_job`) USING BTREE,
  INDEX `FK_dep_emp`(`dept_id`) USING BTREE,
  CONSTRAINT `FK_dep_emp` FOREIGN KEY (`dept_id`) REFERENCES `department` (`dept_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_employee` FOREIGN KEY (`emp_job`) REFERENCES `job` (`job_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('04', '0001', '王仓龙', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号', '322334', '85553666', '15832898327', '', 'sam@sina.com', '6222838899992223000', '430221194907185829', 'http://localhost:8080/hrmsys/img/default.gif', '2018-05-15', 'admin', 8, '9827423794824', '美国', '******', '****', '********', '******', '*******');
INSERT INTO `employee` VALUES ('02', '0002', '门鼎', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '85536666', '15832398327', '452983728', 'sam@sina.com', '6222888899992222876', '430221199904185829', NULL, '2010-10-10', '陈白', 3, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('04', '0003', '蒲程磊', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '85554666', '15832858327', '452983728', 'sam@sina.com', '6242888899992222876', '430221199947185829', NULL, '2010-10-10', '陈白', 8, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('04', '0004', '冯一凡', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '86556666', '15836898327', '452983728', 'sam@sina.com', '6222888849992222876', '430221199907185829', NULL, '2010-10-10', '陈白', 7, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('03', '0005', '王仓龙', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '722403', '85576666', '15832888327', '', 'wcl@sina.com', '6222888896992223000', '610323199611031111', 'http://localhost:8080/hrmsys/img/default.gif', '2020-06-14', 'admin', 4, '西安东开发区支行', '中国', '陕西宝鸡', '汉', '西安工程大学', '研究生', '计算机科学');
INSERT INTO `employee` VALUES ('02', '00051', '大宝贝', 1, '2018-05-15', '陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号', '210020', '021-25665525', '13918621282', '', 'llqqxf@163.com', '12313213123', '622921199004080992', 'http://localhost:8080/hrmsys/photo/2018051522123410.jpg', '2018-05-15', 'admin', 3, '中国银行', '中国', '上海', '汉族', '西安工程大学', '研究生', '软件工程');
INSERT INTO `employee` VALUES ('04', '0006', '胡发丽', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '85558666', '15845898327', '452983728', 'sam@sina.com', '6222888899997222876', '430221199107185829', NULL, '2010-10-10', '陈白', 7, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('01', '0007', '黄泽华', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '85556576', '15862898327', '只能为数字', 'sam@sina.com', '6222788899992223000', '430221134907185829', 'http://localhost:8080/hrmsys/photo/2.jpg', '2011-05-15', '孙七', 1, '24234234', '2423', '24', '234', '24', '24', '234');
INSERT INTO `employee` VALUES ('04', '0008', '刘改', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '83556666', '15832848327', '只能为数字', 'sam@sina.com', '6222888897992223000', '430271199907185829', 'http://localhost:8080/hrmsys/photo/2.jpg', '2011-05-15', '孙七', 10, '223423423423423', '中国', '湖南', '汉', '西安工程大学', '本科', '计算机科学与技术');
INSERT INTO `employee` VALUES ('04', '0009', '夏青', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '25556666', '15834898327', '452983728', 'sam@sina.com', '6222888799992222876', '430221199902185829', 'http://localhost:8080/hrmsys/photo/2.jpg', '2010-10-10', '陈白', 8, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('04', '0010', '王不', 0, '1990-10-10', '陕西省西安市临潼区陕鼓大道58号', '322334', '85456666', '15562898327', '452983728', 'sam@sina.com', '6222888894992222876', '430221199907145829', 'http://localhost:8080/hrmsys/photo/2.jpg', '2010-10-10', '陈白', 7, '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `employee` VALUES ('04', '0011', '右要', 0, '2011-02-03', '陕西省西安市临潼区陕鼓大道58号', '432789', '12325654', '15878392923', '546321565', 'kdj@sina.com', '23948729875352', '48392749285922', 'http://localhost:8080/hrmsys/photo/1.jpg', '2011-02-28', '孙七', 8, '喹国', '中国', '湘', '汉', '西安工程大学', '本科', '计算机');
INSERT INTO `employee` VALUES ('04', '0012', 'sum', 1, '2011-02-03', '陕西省西安市临潼区陕鼓大道58号', '637283', '', '24243242', '2423', 'sld@sina.com', '234928347293423', '2434242342432', 'http://localhost:8080/hrmsys/photo/2.jpg', NULL, NULL, 5, '中行', '中国', '湘', '汉', '人文', '本科', '计算机');
INSERT INTO `employee` VALUES ('05', '0013', 'edwin', 1, '2011-01-05', '陕西省西安市临潼区陕鼓大道58号', '6', '', '6', '只能为数字', '6@sina.com', '6', '6', 'http://localhost:8080/hrmsys/photo/2.jpg', '2011-05-15', '孙七', 20, '6', '6', '6', '6', '6', '6', '6');
INSERT INTO `employee` VALUES ('04', '0014', 'jacky', 1, '2011-02-01', '陕西省西安市临潼区陕鼓大道58号\r\n陕西省西安市临潼区陕鼓大道58号', '6', '', '6', '只能为数字', '6@sina.com', '6', '6', 'http://localhost:8080/hrmsys/photo/1.jpg', '2011-05-15', '孙七', 9, '6', '6', '6', '6', '6', '6', '6');
INSERT INTO `employee` VALUES ('05', '0015', 'jdongo', 1, '2011-02-10', '陕西省西安市临潼区陕鼓大道58号', '6', '5', '6', '只能为数字', '6@sina.com', '6', '6', 'http://localhost:8080/hrmsys/photo/1.jpg', '2011-05-15', '孙七', 6, '6', '6', '6', '6', '6', '6', '6');
INSERT INTO `employee` VALUES ('06', '0016', 'lucy', 0, '2011-05-15', '陕西省西安市临潼区陕鼓大道58号', '412100', '85556666', '15877292384', '452912719', 'lucy@163.com', '234234234234', '430211999882938473', 'http://localhost:8080/hrmsys/img/default.gif', '2011-05-15', '孙七', 13, '234234234234234', '中国', '河南', '汉', '某某学校', '硕士', '某某专业');
INSERT INTO `employee` VALUES ('06', '0017', 'suny', 1, '1978-05-15', '陕西省西安市临潼区陕鼓大道58号', '412100', '8555666', '15873828492', '954299822', 'suny@163.com', '2423423424234234', '430221198907105919', 'http://localhost:8080/hrmsys/img/default.gif', '2011-05-15', '孙七', 15, 'mmm', '2222', '222', '22', '222', '222', '222');
INSERT INTO `employee` VALUES ('07', '0018', 'sina', 1, '1985-05-01', '陕西省西安市临潼区陕鼓大道58号', '412100', '0738-85556666', '15873828492', '452912739', 'sina@163.com', '4324284234242342', '43022119890710591x', 'http://localhost:8080/hrmsys/img/default.gif', '2011-05-15', '孙七', 22, '22222', '22', '222', '22', '22', '22', '22');
INSERT INTO `employee` VALUES ('07', '0019', 'cache', 1, '1978-05-01', '陕西省西安市临潼区陕鼓大道58号', '431200', '85556666', '15323928742', '24928423424', 'cache@163.com', '24242342423424', '430221998907105912', 'http://localhost:8080/hrmsys/img/default.gif', '2011-05-15', '孙七', 23, '24234', '234', '234', '24', '234', '234', '234');
INSERT INTO `employee` VALUES ('06', '0020', 'fenha', 1, '2011-04-01', '陕西省西安市临潼区陕鼓大道58号', '412080', '8555666', '15873829422', '4521293434', 'fenha@sina.com', '24242342141', '430221198907105910', 'http://localhost:8080/hrmsys/img/default.gif', '2011-05-15', '孙七', 12, '24234', '3434', '234', '234', '234', '234', '234');

-- ----------------------------
-- Table structure for job
-- ----------------------------
DROP TABLE IF EXISTS `job`;
CREATE TABLE `job`  (
  `job_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `job_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `job_dept_id` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `job_basic_wage` float NULL DEFAULT NULL COMMENT '基本工资',
  PRIMARY KEY (`job_id`) USING BTREE,
  INDEX `FK_job`(`job_dept_id`) USING BTREE,
  CONSTRAINT `FK_job` FOREIGN KEY (`job_dept_id`) REFERENCES `department` (`dept_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of job
-- ----------------------------
INSERT INTO `job` VALUES (1, '总经理', '', '01', 6000);
INSERT INTO `job` VALUES (2, '总经理助理', '', '01', 5000);
INSERT INTO `job` VALUES (3, '行政部经理', '', '02', 6000);
INSERT INTO `job` VALUES (4, '人力资源部经理', '', '03', 6000);
INSERT INTO `job` VALUES (5, '平台软件部经理', '', '04', 6000);
INSERT INTO `job` VALUES (6, '产品部经理', '', '05', 5000);
INSERT INTO `job` VALUES (7, '软件工程师', '', '04', 4000);
INSERT INTO `job` VALUES (8, '系统架构师', '', '04', 5000);
INSERT INTO `job` VALUES (9, '助理软件工程师', '', '04', 2500);
INSERT INTO `job` VALUES (10, '测试工程师', '', '04', 4000);
INSERT INTO `job` VALUES (11, '硬件高级工程师', '', '06', 5000);
INSERT INTO `job` VALUES (12, '质量部经理', '', '06', 6000);
INSERT INTO `job` VALUES (13, '工艺工程师', '', '06', 3000);
INSERT INTO `job` VALUES (14, '硬件工程师', '', '06', 4000);
INSERT INTO `job` VALUES (15, 'PCB工程师', '', '06', 4500);
INSERT INTO `job` VALUES (16, '招聘专员', '', '03', 3000);
INSERT INTO `job` VALUES (17, '劳资专员', '', '03', 3000);
INSERT INTO `job` VALUES (18, '绩效专员', '管理绩效的', '03', 3000);
INSERT INTO `job` VALUES (19, '产品工程师', '', '05', 4000);
INSERT INTO `job` VALUES (20, 'UI工程师', '', '05', 4000);
INSERT INTO `job` VALUES (21, '包装设计工程师', '', '05', 4000);
INSERT INTO `job` VALUES (22, '软件高级工程师', '', '07', 4000);
INSERT INTO `job` VALUES (23, '嵌入式部经理', '', '07', 6000);

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`  (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `menu_parent_id` int(11) NULL DEFAULT NULL,
  `menu_leaf` int(11) NULL DEFAULT NULL,
  `menu_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `menu_icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, '人力资源管理', 0, 0, NULL, NULL);
INSERT INTO `menu` VALUES (2, '部门管理', NULL, NULL, NULL, NULL);
INSERT INTO `menu` VALUES (3, '人事管理', 1, 0, NULL, NULL);
INSERT INTO `menu` VALUES (5, '薪酬管理', 1, 0, NULL, NULL);
INSERT INTO `menu` VALUES (9, '系统设置', NULL, NULL, NULL, NULL);
INSERT INTO `menu` VALUES (10, '部门信息管理', 2, 1, 'jsp/department/deptInfo.jsp', 'deptInfo');
INSERT INTO `menu` VALUES (11, '部门职位管理', 2, 1, 'jsp/department/jobInfo.jsp', 'job');
INSERT INTO `menu` VALUES (12, '员工信息管理', 3, 1, 'jsp/employee/empInfo.jsp', 'employee');
INSERT INTO `menu` VALUES (14, '员工职位变动', NULL, NULL, '', '');
INSERT INTO `menu` VALUES (19, '薪资标准管理', NULL, 0, '', NULL);
INSERT INTO `menu` VALUES (20, '税率表管理', NULL, NULL, '', '');
INSERT INTO `menu` VALUES (21, '福利表管理', 5, 1, 'jsp/salary/boon.jsp', 'boon');
INSERT INTO `menu` VALUES (22, '员工工资配置', 5, 1, 'jsp/salary/salaryBasic.jsp', 'config');
INSERT INTO `menu` VALUES (23, '员工工资录入', 5, 1, 'jsp/salary/salaryAdd.jsp', 'salaryAdd');
INSERT INTO `menu` VALUES (24, '员工工资信息', 5, 1, 'jsp/salary/salaryInfo.jsp', 'salary');
INSERT INTO `menu` VALUES (25, '用户管理', NULL, NULL, '', '');
INSERT INTO `menu` VALUES (26, '角色管理', NULL, NULL, '', '');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission`  (
  `per_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) NOT NULL,
  `per_function` int(1) NOT NULL,
  PRIMARY KEY (`per_id`) USING BTREE,
  INDEX `FK_permission`(`menu_id`) USING BTREE,
  CONSTRAINT `FK_permission` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`menu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 68 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES (1, 10, 1);
INSERT INTO `permission` VALUES (2, 10, 2);
INSERT INTO `permission` VALUES (3, 10, 3);
INSERT INTO `permission` VALUES (4, 10, 4);
INSERT INTO `permission` VALUES (5, 11, 1);
INSERT INTO `permission` VALUES (6, 11, 2);
INSERT INTO `permission` VALUES (7, 11, 3);
INSERT INTO `permission` VALUES (8, 11, 4);
INSERT INTO `permission` VALUES (9, 12, 1);
INSERT INTO `permission` VALUES (10, 12, 2);
INSERT INTO `permission` VALUES (11, 12, 3);
INSERT INTO `permission` VALUES (12, 12, 4);
INSERT INTO `permission` VALUES (13, 14, 1);
INSERT INTO `permission` VALUES (14, 14, 2);
INSERT INTO `permission` VALUES (15, 14, 4);
INSERT INTO `permission` VALUES (16, 18, 1);
INSERT INTO `permission` VALUES (17, 18, 2);
INSERT INTO `permission` VALUES (18, 18, 4);
INSERT INTO `permission` VALUES (19, 20, 1);
INSERT INTO `permission` VALUES (20, 20, 2);
INSERT INTO `permission` VALUES (21, 20, 4);
INSERT INTO `permission` VALUES (22, 20, 6);
INSERT INTO `permission` VALUES (23, 21, 1);
INSERT INTO `permission` VALUES (24, 21, 2);
INSERT INTO `permission` VALUES (25, 21, 4);
INSERT INTO `permission` VALUES (26, 21, 6);
INSERT INTO `permission` VALUES (27, 22, 1);
INSERT INTO `permission` VALUES (28, 22, 2);
INSERT INTO `permission` VALUES (29, 22, 4);
INSERT INTO `permission` VALUES (30, 22, 6);
INSERT INTO `permission` VALUES (31, 23, 1);
INSERT INTO `permission` VALUES (32, 24, 1);
INSERT INTO `permission` VALUES (33, 24, 3);
INSERT INTO `permission` VALUES (34, 24, 4);
INSERT INTO `permission` VALUES (35, 24, 5);
INSERT INTO `permission` VALUES (36, 16, 1);
INSERT INTO `permission` VALUES (37, 16, 2);
INSERT INTO `permission` VALUES (38, 16, 4);
INSERT INTO `permission` VALUES (39, 17, 1);
INSERT INTO `permission` VALUES (40, 17, 2);
INSERT INTO `permission` VALUES (41, 17, 4);
INSERT INTO `permission` VALUES (42, 15, 1);
INSERT INTO `permission` VALUES (43, 15, 2);
INSERT INTO `permission` VALUES (44, 15, 3);
INSERT INTO `permission` VALUES (45, 15, 4);
INSERT INTO `permission` VALUES (46, 15, 5);
INSERT INTO `permission` VALUES (47, 27, 1);
INSERT INTO `permission` VALUES (48, 28, 1);
INSERT INTO `permission` VALUES (49, 12, 5);
INSERT INTO `permission` VALUES (50, 25, 1);
INSERT INTO `permission` VALUES (51, 25, 2);
INSERT INTO `permission` VALUES (52, 25, 3);
INSERT INTO `permission` VALUES (53, 25, 4);
INSERT INTO `permission` VALUES (54, 26, 1);
INSERT INTO `permission` VALUES (55, 26, 2);
INSERT INTO `permission` VALUES (56, 26, 3);
INSERT INTO `permission` VALUES (57, 26, 4);
INSERT INTO `permission` VALUES (59, 14, 3);
INSERT INTO `permission` VALUES (60, 14, 5);
INSERT INTO `permission` VALUES (61, 18, 3);
INSERT INTO `permission` VALUES (62, 18, 5);
INSERT INTO `permission` VALUES (63, 16, 3);
INSERT INTO `permission` VALUES (64, 16, 5);
INSERT INTO `permission` VALUES (65, 17, 3);
INSERT INTO `permission` VALUES (66, 17, 5);
INSERT INTO `permission` VALUES (67, 30, 1);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `role_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '超级管理员', NULL);
INSERT INTO `role` VALUES (2, '管理员', NULL);
INSERT INTO `role` VALUES (3, '行政人员', '');
INSERT INTO `role` VALUES (5, '员工', '');

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission`  (
  `rp_id` int(11) NOT NULL AUTO_INCREMENT,
  `per_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`rp_id`) USING BTREE,
  INDEX `FK_role_permission`(`role_id`) USING BTREE,
  INDEX `FK_role_permission_id`(`per_id`) USING BTREE,
  CONSTRAINT `FK_role_permission` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_role_permission_id` FOREIGN KEY (`per_id`) REFERENCES `permission` (`per_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 511 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES (409, 36, 1);
INSERT INTO `role_permission` VALUES (410, 37, 1);
INSERT INTO `role_permission` VALUES (411, 38, 1);
INSERT INTO `role_permission` VALUES (412, 63, 1);
INSERT INTO `role_permission` VALUES (413, 64, 1);
INSERT INTO `role_permission` VALUES (414, 39, 1);
INSERT INTO `role_permission` VALUES (415, 40, 1);
INSERT INTO `role_permission` VALUES (416, 41, 1);
INSERT INTO `role_permission` VALUES (417, 65, 1);
INSERT INTO `role_permission` VALUES (418, 66, 1);
INSERT INTO `role_permission` VALUES (419, 16, 1);
INSERT INTO `role_permission` VALUES (420, 17, 1);
INSERT INTO `role_permission` VALUES (421, 18, 1);
INSERT INTO `role_permission` VALUES (422, 61, 1);
INSERT INTO `role_permission` VALUES (423, 62, 1);
INSERT INTO `role_permission` VALUES (424, 48, 1);
INSERT INTO `role_permission` VALUES (425, 67, 1);
INSERT INTO `role_permission` VALUES (426, 47, 1);
INSERT INTO `role_permission` VALUES (427, 42, 1);
INSERT INTO `role_permission` VALUES (428, 43, 1);
INSERT INTO `role_permission` VALUES (429, 44, 1);
INSERT INTO `role_permission` VALUES (430, 45, 1);
INSERT INTO `role_permission` VALUES (431, 46, 1);
INSERT INTO `role_permission` VALUES (433, 50, 1);
INSERT INTO `role_permission` VALUES (434, 51, 1);
INSERT INTO `role_permission` VALUES (435, 52, 1);
INSERT INTO `role_permission` VALUES (436, 53, 1);
INSERT INTO `role_permission` VALUES (437, 54, 1);
INSERT INTO `role_permission` VALUES (438, 55, 1);
INSERT INTO `role_permission` VALUES (439, 56, 1);
INSERT INTO `role_permission` VALUES (440, 57, 1);
INSERT INTO `role_permission` VALUES (441, 9, 1);
INSERT INTO `role_permission` VALUES (442, 10, 1);
INSERT INTO `role_permission` VALUES (443, 11, 1);
INSERT INTO `role_permission` VALUES (444, 12, 1);
INSERT INTO `role_permission` VALUES (445, 49, 1);
INSERT INTO `role_permission` VALUES (446, 13, 1);
INSERT INTO `role_permission` VALUES (447, 14, 1);
INSERT INTO `role_permission` VALUES (448, 15, 1);
INSERT INTO `role_permission` VALUES (449, 59, 1);
INSERT INTO `role_permission` VALUES (450, 60, 1);
INSERT INTO `role_permission` VALUES (451, 27, 1);
INSERT INTO `role_permission` VALUES (452, 28, 1);
INSERT INTO `role_permission` VALUES (453, 29, 1);
INSERT INTO `role_permission` VALUES (454, 30, 1);
INSERT INTO `role_permission` VALUES (455, 23, 1);
INSERT INTO `role_permission` VALUES (456, 24, 1);
INSERT INTO `role_permission` VALUES (457, 25, 1);
INSERT INTO `role_permission` VALUES (458, 26, 1);
INSERT INTO `role_permission` VALUES (459, 19, 1);
INSERT INTO `role_permission` VALUES (460, 20, 1);
INSERT INTO `role_permission` VALUES (461, 21, 1);
INSERT INTO `role_permission` VALUES (462, 22, 1);
INSERT INTO `role_permission` VALUES (463, 32, 1);
INSERT INTO `role_permission` VALUES (464, 33, 1);
INSERT INTO `role_permission` VALUES (465, 34, 1);
INSERT INTO `role_permission` VALUES (466, 35, 1);
INSERT INTO `role_permission` VALUES (467, 31, 1);
INSERT INTO `role_permission` VALUES (468, 1, 1);
INSERT INTO `role_permission` VALUES (469, 2, 1);
INSERT INTO `role_permission` VALUES (470, 3, 1);
INSERT INTO `role_permission` VALUES (471, 4, 1);
INSERT INTO `role_permission` VALUES (472, 5, 1);
INSERT INTO `role_permission` VALUES (473, 6, 1);
INSERT INTO `role_permission` VALUES (474, 7, 1);
INSERT INTO `role_permission` VALUES (475, 8, 1);
INSERT INTO `role_permission` VALUES (476, 36, 2);
INSERT INTO `role_permission` VALUES (477, 37, 2);
INSERT INTO `role_permission` VALUES (478, 38, 2);
INSERT INTO `role_permission` VALUES (479, 39, 2);
INSERT INTO `role_permission` VALUES (480, 41, 2);
INSERT INTO `role_permission` VALUES (481, 48, 2);
INSERT INTO `role_permission` VALUES (482, 67, 2);
INSERT INTO `role_permission` VALUES (483, 42, 2);
INSERT INTO `role_permission` VALUES (484, 43, 2);
INSERT INTO `role_permission` VALUES (485, 44, 2);
INSERT INTO `role_permission` VALUES (487, 50, 2);
INSERT INTO `role_permission` VALUES (488, 57, 2);
INSERT INTO `role_permission` VALUES (489, 9, 2);
INSERT INTO `role_permission` VALUES (490, 13, 2);
INSERT INTO `role_permission` VALUES (491, 27, 2);
INSERT INTO `role_permission` VALUES (492, 23, 2);
INSERT INTO `role_permission` VALUES (493, 19, 2);
INSERT INTO `role_permission` VALUES (494, 32, 2);
INSERT INTO `role_permission` VALUES (495, 1, 2);
INSERT INTO `role_permission` VALUES (496, 5, 2);
INSERT INTO `role_permission` VALUES (504, 36, 3);
INSERT INTO `role_permission` VALUES (505, 39, 3);
INSERT INTO `role_permission` VALUES (506, 47, 3);
INSERT INTO `role_permission` VALUES (507, 42, 3);
INSERT INTO `role_permission` VALUES (508, 39, 5);
INSERT INTO `role_permission` VALUES (510, 16, 5);

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary`  (
  `sal_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sal_basic` float(8, 2) NULL DEFAULT NULL COMMENT '基本工资',
  `sal_job` float(8, 2) NULL DEFAULT NULL COMMENT '岗位工资',
  `sal_normal` float(8, 2) NULL DEFAULT NULL COMMENT '正常工作时间',
  `sal_all` float(8, 2) NULL DEFAULT NULL COMMENT '全勤奖',
  `sal_absenteeism` float(8, 2) NULL DEFAULT NULL COMMENT '旷工时间',
  `sal_absenteeism_money` float(8, 2) NULL DEFAULT NULL COMMENT '缺勤金额',
  `sal_endowmentint` float(8, 2) NULL DEFAULT NULL COMMENT '养老保险',
  `sal_hospitalizationint` float(8, 2) NULL DEFAULT NULL,
  `sal_unemploymentint` float(8, 2) NULL DEFAULT NULL,
  `sal_eateryfloat` float(8, 2) NOT NULL,
  `sal_trafficfloat` float(8, 2) NULL DEFAULT NULL,
  `sal_telephone` float(8, 2) NULL DEFAULT NULL,
  `sal_allowance` float(8, 2) NULL DEFAULT NULL COMMENT '其它补贴',
  `sal_revenue` float(8, 2) NULL DEFAULT NULL COMMENT '个税',
  `sal_money` float(8, 2) NULL DEFAULT NULL COMMENT '实际工资',
  `sal_year` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年份',
  `sal_release_person` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sal_release_date` date NULL DEFAULT NULL,
  `sal_check_person` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sal_check_date` date NULL DEFAULT NULL,
  `sal_month` int(2) NULL DEFAULT 0 COMMENT '月份',
  `sal_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`sal_id`) USING BTREE,
  INDEX `FK_emp_sal`(`emp_id`) USING BTREE,
  CONSTRAINT `FK_emp_sal` FOREIGN KEY (`emp_id`) REFERENCES `employee` (`emp_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of salary
-- ----------------------------
INSERT INTO `salary` VALUES (1, '0007', 4000.00, 1000.00, 100.00, 0.00, 4.00, 160.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 683.35, 4705.65, '2011', '孙七', '2011-02-24', NULL, NULL, 2, NULL);
INSERT INTO `salary` VALUES (2, '0008', 4000.00, 500.00, 100.00, 0.00, 5.00, 200.00, 80.00, 25.00, 6.00, 300.00, 100.00, 200.00, 0.00, 623.35, 4365.65, '2011', '孙七', '2011-03-10', NULL, NULL, 2, '');
INSERT INTO `salary` VALUES (3, '0007', 4000.00, 1000.00, 100.00, 0.00, 3.00, 120.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 683.35, 4705.65, '2011', '孙七', '2011-01-09', NULL, NULL, 1, '');
INSERT INTO `salary` VALUES (4, '0008', 4000.00, 500.00, 100.00, 100.00, 0.00, 0.00, 80.00, 25.00, 6.00, 300.00, 100.00, 200.00, 0.00, 623.35, 4365.65, '2011', '孙七', '2011-03-10', NULL, NULL, 1, '');
INSERT INTO `salary` VALUES (5, '0001', 4000.00, 4000.00, 120.00, 100.00, 0.00, 0.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 1302.80, 7086.20, '2011', '孙七', '2011-05-16', NULL, NULL, 5, '');
INSERT INTO `salary` VALUES (6, '0002', 3500.00, 6000.00, 100.00, 0.00, 4.00, 140.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 1602.80, 8286.20, '2011', '孙七', '2011-05-16', NULL, NULL, 4, '');
INSERT INTO `salary` VALUES (7, '0005', 3000.00, 6000.00, 100.00, 100.00, 0.00, 0.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 1502.80, 7886.20, '2011', '孙七', '2011-05-16', NULL, NULL, 3, '');
INSERT INTO `salary` VALUES (8, '0006', 4000.00, 4000.00, 100.00, 0.00, 2.00, 80.00, 80.00, 25.00, 6.00, 300.00, 100.00, 100.00, 0.00, 1286.80, 7022.20, '2011', '孙七', '2011-05-16', NULL, NULL, 4, '');

-- ----------------------------
-- Table structure for salary_basic
-- ----------------------------
DROP TABLE IF EXISTS `salary_basic`;
CREATE TABLE `salary_basic`  (
  `sb_id` int(11) NOT NULL,
  `emp_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sb_basic` float NULL DEFAULT 0 COMMENT '基本工资',
  `sb_endowment` int(1) NULL DEFAULT 0 COMMENT '养老保险',
  `sb_hospitalization` int(1) NULL DEFAULT 0 COMMENT '医疗保险',
  `sb_unemployment` int(1) NULL DEFAULT 0 COMMENT '失业保险',
  `sb_injury` int(1) NULL DEFAULT 0 COMMENT '工伤保险',
  `sb_maternity` int(1) NULL DEFAULT 0 COMMENT '生育保险',
  `sb_housing` int(1) NULL DEFAULT 0 COMMENT '住房公积金',
  `sb_traffic` float NULL DEFAULT 0 COMMENT '交通补贴',
  `sb_eatery` float NULL DEFAULT 0 COMMENT '餐饮补贴',
  `sb_telephone` float NULL DEFAULT 0 COMMENT '通信补贴',
  PRIMARY KEY (`sb_id`) USING BTREE,
  INDEX `FK_salary_basic`(`emp_id`) USING BTREE,
  CONSTRAINT `FK_salary_basic` FOREIGN KEY (`emp_id`) REFERENCES `employee` (`emp_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of salary_basic
-- ----------------------------
INSERT INTO `salary_basic` VALUES (1, '0007', 4000, 1, 1, 1, 1, 0, 1, 100, 300, 100);
INSERT INTO `salary_basic` VALUES (2, '0008', 4000, 1, 1, 0, 1, 1, 1, 100, 300, 200);
INSERT INTO `salary_basic` VALUES (3, '0006', 4000, 1, 1, 1, 1, 0, 1, 100, 300, 100);
INSERT INTO `salary_basic` VALUES (4, '0001', 4000, 1, 1, 1, 1, 1, 1, 100, 300, 100);
INSERT INTO `salary_basic` VALUES (6, '0003', 3000, 1, 1, 1, 1, 1, 1, 200, 300, 100);
INSERT INTO `salary_basic` VALUES (7, '0004', 4000, 1, 1, 1, 1, 1, 1, 100, 300, 200);
INSERT INTO `salary_basic` VALUES (8, '0005', 3500, 0, 1, 0, 1, 0, 1, 600, 500, 200);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NULL DEFAULT NULL,
  `emp_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_pwd` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `user_date` date NOT NULL,
  `user_last_ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_last_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  INDEX `FK_emp_user`(`emp_id`) USING BTREE,
  INDEX `FK_user_role`(`role_id`) USING BTREE,
  CONSTRAINT `FK_emp_user` FOREIGN KEY (`emp_id`) REFERENCES `employee` (`emp_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_user_role` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 1, '0005', 'admin', 'ISMvKXpXpadDiUoOSoAfww==', NULL, '2011-02-12', '0:0:0:0:0:0:0:1', '2020-06-15 08:28:55');
INSERT INTO `user` VALUES (3, 1, '0011', '右要', 'ICy5YqxZB1uWSwcVLSNLcA==', '00', '2011-03-26', NULL, NULL);
INSERT INTO `user` VALUES (4, 2, '0012', 'sum', 'ICy5YqxZB1uWSwcVLSNLcA==', '11', '2011-03-26', '0:0:0:0:0:0:0:1', '2018-05-15 20:37:05');
INSERT INTO `user` VALUES (5, 2, '0007', '李官', 'aVCqwteTLh8aTDz2raExbg==', '111', '2011-05-16', NULL, NULL);
INSERT INTO `user` VALUES (6, 2, '0006', '王八', 'f4uw/oszeAoI/mtgztFFKQ==', '23421111111', '2011-05-16', NULL, NULL);
INSERT INTO `user` VALUES (7, 1, '0005', '爸爸', '05k0zhEahkq/QDkfPanN9Q==', '54485', '2020-06-14', '0:0:0:0:0:0:0:1', '2018-05-16 21:19:12');
INSERT INTO `user` VALUES (8, 1, '0001', 'wcl', '4QrcOUm6Wau+VuBX8g+IPg==', '1', '2020-06-14', '0:0:0:0:0:0:0:1', '2020-06-14 22:00:49');
INSERT INTO `user` VALUES (9, 1, '0002', 'md', '4QrcOUm6Wau+VuBX8g+IPg==', '2', '2020-06-14', NULL, NULL);
INSERT INTO `user` VALUES (10, 1, '0003', 'pcl', '4QrcOUm6Wau+VuBX8g+IPg==', '3', '2020-06-14', NULL, NULL);
INSERT INTO `user` VALUES (11, 1, '0004', 'fyf', '4QrcOUm6Wau+VuBX8g+IPg==', '4', '2020-06-14', NULL, NULL);
INSERT INTO `user` VALUES (12, 1, '0006', 'hfl', '4QrcOUm6Wau+VuBX8g+IPg==', '6', '2020-06-14', NULL, NULL);
INSERT INTO `user` VALUES (13, 1, '0007', 'hzh', '4QrcOUm6Wau+VuBX8g+IPg==', '7', '2020-06-14', NULL, NULL);
INSERT INTO `user` VALUES (14, 1, '0008', 'lg', '4QrcOUm6Wau+VuBX8g+IPg==', '8', '2020-06-14', '0:0:0:0:0:0:0:1', '2020-06-14 16:49:35');

SET FOREIGN_KEY_CHECKS = 1;