/*
Navicat MySQL Data Transfer

Source Server         : gaojintian
Source Server Version : 50562
Source Host           : localhost:3306
Source Database       : personnel

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

Date: 2021-09-05 11:39:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dept_inf
-- ----------------------------
DROP TABLE IF EXISTS `dept_inf`;
CREATE TABLE `dept_inf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `remark` varchar(300) DEFAULT NULL,
  `percount` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dept_inf
-- ----------------------------
INSERT INTO `dept_inf` VALUES ('1', '项目一部', '公司一楼101', '3');
INSERT INTO `dept_inf` VALUES ('2', '项目二部', '公司一楼103', '2');
INSERT INTO `dept_inf` VALUES ('3', '项目三部', '公司一楼105', '2');
INSERT INTO `dept_inf` VALUES ('4', '市场一部', '公司一楼107', '2');
INSERT INTO `dept_inf` VALUES ('5', '市场二部', '公司二楼201', '2');
INSERT INTO `dept_inf` VALUES ('6', '技术一部', '公司二楼203', '2');
INSERT INTO `dept_inf` VALUES ('7', '技术二部', '公司二楼205', '2');
INSERT INTO `dept_inf` VALUES ('8', '技术三部', '公司二楼207', '1');
INSERT INTO `dept_inf` VALUES ('9', '人力一部', '公司三楼301', '2');
INSERT INTO `dept_inf` VALUES ('10', '人力二部', '公司三楼303', '2');
INSERT INTO `dept_inf` VALUES ('11', '董事部', '公司四楼401', '1');
INSERT INTO `dept_inf` VALUES ('12', '经理部', '公司四楼407', '2');

-- ----------------------------
-- Table structure for files
-- ----------------------------
DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `fileId` int(11) NOT NULL AUTO_INCREMENT,
  `fileName` char(255) DEFAULT NULL,
  `fileUrl` char(255) DEFAULT NULL,
  `fileDate` date DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`fileId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of files
-- ----------------------------
INSERT INTO `files` VALUES ('1', 'files.sql', 'D:\\IDEA\\upload\\files.sql', '2021-08-21', '1');
INSERT INTO `files` VALUES ('2', 'commons-io-2.11.0-bin.zip', 'D:\\IDEA\\upload\\commons-io-2.11.0-bin.zip', '2021-08-21', '1');
INSERT INTO `files` VALUES ('3', 'api-ms-win-core-interlocked-l1-1-0.dll', 'D:\\IDEA\\upload\\api-ms-win-core-interlocked-l1-1-0.dll', '2021-08-22', '1');
INSERT INTO `files` VALUES ('5', 'api-ms-win-core-handle-l1-1-0.dll', 'D:\\IDEA\\upload\\api-ms-win-core-handle-l1-1-0.dll', '2021-08-22', '1');
INSERT INTO `files` VALUES ('11', 'Personnel.rar', 'D:\\IDEA\\upload\\Personnel.rar', '2021-08-26', '1');
INSERT INTO `files` VALUES ('16', 'files.sql', 'D:\\IDEA\\upload\\files.sql', '2021-08-26', '1');

-- ----------------------------
-- Table structure for job_inf
-- ----------------------------
DROP TABLE IF EXISTS `job_inf`;
CREATE TABLE `job_inf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `remark` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of job_inf
-- ----------------------------
INSERT INTO `job_inf` VALUES ('1', '系统管理员', '系统管理员');
INSERT INTO `job_inf` VALUES ('2', 'Java开发工程师', 'Java开发工程师');
INSERT INTO `job_inf` VALUES ('3', 'Java中级开发工程师', 'Java中级开发工程师');
INSERT INTO `job_inf` VALUES ('4', 'Java高级开发工程师', 'Java高级开发工程师');
INSERT INTO `job_inf` VALUES ('5', '系统管理员', '系统管理员');
INSERT INTO `job_inf` VALUES ('6', '架构师', '架构师');
INSERT INTO `job_inf` VALUES ('7', '主管', '主管');
INSERT INTO `job_inf` VALUES ('9', '总经理', '总经理');

-- ----------------------------
-- Table structure for leave_info
-- ----------------------------
DROP TABLE IF EXISTS `leave_info`;
CREATE TABLE `leave_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of leave_info
-- ----------------------------
INSERT INTO `leave_info` VALUES ('1', '高锦添', '病假', '2021-08-25', '2021-08-26', '1', '生病', '2');
INSERT INTO `leave_info` VALUES ('2', '周伟', '病假', '2021-08-25', '2021-08-26', '1', '生病很难受', '1');
INSERT INTO `leave_info` VALUES ('3', '张存哲', '事假', '2021-08-24', '2021-08-25', '1', '出门约会了', '2');
INSERT INTO `leave_info` VALUES ('7', '高锦添', '事假', '2021-08-04', '2021-08-05', '1', '家里有事', '1');
INSERT INTO `leave_info` VALUES ('8', '高锦添', '病假', '2021-08-23', '2021-08-26', '3', '生病了', '1');
INSERT INTO `leave_info` VALUES ('9', '张存哲', '产假', '2021-08-01', '2021-08-31', '31', '生孩子', '2');
INSERT INTO `leave_info` VALUES ('10', '杨兆通', '事假', '2021-08-26', '2021-08-28', '2', '有事出门', '0');
INSERT INTO `leave_info` VALUES ('11', '周伟', '事假', '2021-08-25', '2021-08-27', '2', '出门吃饭去了', '0');
INSERT INTO `leave_info` VALUES ('13', '张存哲', '产假', '2021-08-01', '2021-08-31', '31', '生产了要', '1');
INSERT INTO `leave_info` VALUES ('14', '张存哲', '事假', '2021-08-11', '2021-08-27', '16', '有大事', '0');
INSERT INTO `leave_info` VALUES ('15', '张存哲', '事假', '2021-08-04', '2021-08-06', '2', '打游戏', '1');
INSERT INTO `leave_info` VALUES ('16', '张存哲', '病假', '2021-08-26', '2021-08-29', '3', '生病了很难受', '0');
INSERT INTO `leave_info` VALUES ('17', '张存哲', '事假', '2021-08-01', '2021-08-10', '9', '123', '0');
INSERT INTO `leave_info` VALUES ('18', '张存哲', '事假', '2021-08-18', '2021-08-20', '2', '出门', '0');

-- ----------------------------
-- Table structure for notice_inf
-- ----------------------------
DROP TABLE IF EXISTS `notice_inf`;
CREATE TABLE `notice_inf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `content` text,
  `create_date` char(20) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of notice_inf
-- ----------------------------
INSERT INTO `notice_inf` VALUES ('1', '更新公告', '更新得更加高级', null, '2');
INSERT INTO `notice_inf` VALUES ('2', '通知', '张存哲粉丝群满了', null, '3');
INSERT INTO `notice_inf` VALUES ('4', '放假通知', '国庆假期为10.1-10.7', null, '1');
INSERT INTO `notice_inf` VALUES ('5', '中秋假期', '中秋假期为3天', null, '2');
INSERT INTO `notice_inf` VALUES ('6', '工资发放', '即将发放工资，请注意查收', null, '1');
INSERT INTO `notice_inf` VALUES ('7', '添加部门通知', '添加了新的部门', null, '1');

-- ----------------------------
-- Table structure for role_info
-- ----------------------------
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_info
-- ----------------------------
INSERT INTO `role_info` VALUES ('1', '系统管理员');
INSERT INTO `role_info` VALUES ('2', '用户');

-- ----------------------------
-- Table structure for users_info
-- ----------------------------
DROP TABLE IF EXISTS `users_info`;
CREATE TABLE `users_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `joindate` datetime DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users_info
-- ----------------------------
INSERT INTO `users_info` VALUES ('1', 'admin', 'admin', '高锦添', '男', '17306984576', '[email protected]', '福建', '三明市', '大田县', '南山路9号202', '2021-08-19 11:19:58', '1');
INSERT INTO `users_info` VALUES ('2', '123', '123', '周伟', '男', '12345678945', '[email protected]', '福建', '宁德市', '霞浦县', '霞浦一中', '2021-08-20 11:28:45', '1');
INSERT INTO `users_info` VALUES ('3', '3', '3', '张存哲', '男', '123456789', '123456798', '山东', '枣庄市', '市中区', '123号', '2021-08-21 10:12:31', '2');
INSERT INTO `users_info` VALUES ('4', '4', '4', '杨兆通', '男', '123123123', '123123123', '山东', '枣庄市', '台儿庄区', '马尾123', '2021-08-21 12:57:58', '2');
INSERT INTO `users_info` VALUES ('5', '5', '5', '景斌', '男', '123123124', '[email protected]', '福建', '福州市', '闽侯县', '福建工程学院', '2021-08-21 12:58:01', '2');
INSERT INTO `users_info` VALUES ('6', '6', '6', '喜羊羊', '男', '1234654654', '[email protected]', '福建', '福州', '马尾区', '羊村', '2021-08-26 23:14:24', '2');
INSERT INTO `users_info` VALUES ('11', '123', '123', '张顺飞', '男', '123123123', '123123123', '福建', '福州', '马尾区', '中软', '2021-08-27 09:39:31', '1');

-- ----------------------------
-- Table structure for wages_info
-- ----------------------------
DROP TABLE IF EXISTS `wages_info`;
CREATE TABLE `wages_info` (
  `wid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `deptid` int(11) DEFAULT NULL,
  `jobid` int(11) DEFAULT NULL,
  `year` int(255) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `wagescount` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`wid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wages_info
-- ----------------------------
INSERT INTO `wages_info` VALUES ('1', '1', '1', '1', '2021', '8', '10000', '0');
INSERT INTO `wages_info` VALUES ('2', '2', '2', '1', '2021', '8', '10000', '0');
INSERT INTO `wages_info` VALUES ('3', '3', '3', '2', '2021', '8', '6000', '0');
INSERT INTO `wages_info` VALUES ('4', '4', '5', '3', '2021', '8', '9000', '0');
INSERT INTO `wages_info` VALUES ('5', '5', '5', '1', '2021', '8', '10000', '0');
INSERT INTO `wages_info` VALUES ('6', '6', '6', '1', '2021', '8', '10000', '0');
INSERT INTO `wages_info` VALUES ('7', '11', '2', '3', '2021', '8', '8500', '0');