代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : yuhaixia
Source Server Version : 50532
Source Host : localhost:3306
Source Database : db_oa_system
Target Server Type : MYSQL
Target Server Version : 50532
File Encoding : 65001
Date: 2021-05-11 21:33:07
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for announcement
-- ----------------------------
DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`auther_id` int(32) NOT NULL,
`title` varchar(32) NOT NULL,
`text` text,
`pic` varchar(32) DEFAULT NULL,
`target_id` int(32) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of announcement
-- ----------------------------
INSERT INTO `announcement` VALUES ('20', '58', '关于12', '1223', null, '73', '2021-04-08 19:50:19');
INSERT INTO `announcement` VALUES ('21', '64', '', null, null, '0', '2021-04-08 19:57:08');
INSERT INTO `announcement` VALUES ('22', '58', '关于XXXXX的通知', '关于XXXXX的通知', null, '73', '2021-04-08 23:54:29');
INSERT INTO `announcement` VALUES ('23', '58', '关于XXXXX的通知', '关于XXXXX的通知', null, '74', '2021-04-08 23:54:37');
INSERT INTO `announcement` VALUES ('24', '58', '关于XXXXX的通知', '关于XXXXX的通知', null, '72', '2021-04-08 23:54:45');
INSERT INTO `announcement` VALUES ('25', '58', '关于XXXXX的通知', '关于XXXXX的通知', null, '71', '2021-04-08 23:54:53');
-- ----------------------------
-- Table structure for attendance
-- ----------------------------
DROP TABLE IF EXISTS `attendance`;
CREATE TABLE `attendance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`employee_id` int(32) NOT NULL,
`date` date NOT NULL,
`on_time` timestamp NULL DEFAULT NULL,
`off_time` timestamp NULL DEFAULT NULL,
`state` int(2) DEFAULT NULL COMMENT '0正常 1加班 2迟到早退',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of attendance
-- ----------------------------
INSERT INTO `attendance` VALUES ('94', '58', '2021-04-08', '2021-04-08 19:49:31', '2021-04-08 20:35:08', '2');
INSERT INTO `attendance` VALUES ('95', '62', '2021-04-08', '2021-04-08 19:54:47', null, null);
INSERT INTO `attendance` VALUES ('96', '63', '2021-04-08', '2021-04-08 19:55:31', null, null);
INSERT INTO `attendance` VALUES ('97', '64', '2021-04-08', '2021-04-08 19:57:00', null, null);
INSERT INTO `attendance` VALUES ('98', '65', '2021-04-08', '2021-04-08 20:40:41', '2021-04-08 20:41:51', '2');
INSERT INTO `attendance` VALUES ('99', '58', '2021-04-09', '2021-04-09 00:01:22', '2021-04-09 11:30:59', '1');
INSERT INTO `attendance` VALUES ('100', '58', '2021-04-28', '2021-04-28 10:00:48', null, null);
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`sex` int(1) NOT NULL,
`pic` varchar(64) DEFAULT NULL,
`department_id` int(10) NOT NULL,
`position_id` int(10) DEFAULT '0',
`username` varchar(32) NOT NULL,
`password` varchar(32) NOT NULL,
`salt` varchar(32) DEFAULT NULL,
`working_state` int(1) DEFAULT '0' COMMENT '状态:在线/离线',
`locked` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('58', 'admin', '1', '7f33626d-dca8-41d6-9747-b029ff526245.png', '70', '0', 'admin', 'c657540d5b315892f950ff30e1394480', 'salt', '1', '0');
INSERT INTO `employee` VALUES ('59', 'lj', '0', '9319e5f0-332c-46b8-9ce6-70a7a8e4b1b7.jpg', '71', '0', 'lj', '8c4fb7bf681156b52fea93442c7dffc9', 'salt', '0', '0');
INSERT INTO `employee` VALUES ('60', 'admin1', '1', '530f89a4-64eb-4530-91fc-7e9e4a6aad54.jpg', '31', '0', 'zhangtao', '8c4fb7bf681156b52fea93442c7dffc9', 'salt', '0', '0');
INSERT INTO `employee` VALUES ('61', 'liujing', '0', 'bae4dfeb-0535-496e-b485-dfb036784953.jpg', '70', '0', 'liujing', '8c4fb7bf681156b52fea93442c7dffc9', 'salt', '0', '0');
INSERT INTO `employee` VALUES ('62', '采购1', '0', '', '73', '0', '采购1', 'f51703256a38e6bab3d9410a070c32ea', 'salt', '1', '0');
INSERT INTO `employee` VALUES ('63', '财务', '1', '', '74', '0', '财务', 'f51703256a38e6bab3d9410a070c32ea', 'salt', '1', '0');
INSERT INTO `employee` VALUES ('64', '全体', '1', '', '70', '0', '全体', 'f51703256a38e6bab3d9410a070c32ea', 'salt', '1', '0');
INSERT INTO `employee` VALUES ('65', 'test', '1', '', '72', '0', 'test', 'c657540d5b315892f950ff30e1394480', 'salt', '0', '0');
-- ----------------------------
-- Table structure for mail
-- ----------------------------
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`sendtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`server_id` int(32) NOT NULL,
`reciever_id` int(32) NOT NULL,
`title` varchar(32) DEFAULT NULL,
`text` text,
`pic` varchar(64) DEFAULT NULL,
`read` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of mail
-- ----------------------------
INSERT INTO `mail` VALUES ('35', '2021-04-08 20:09:45', '58', '64', '你好啊', '你好啊', '11a4831e-7cc2-4844-ad72-67c370433c40.exe', '0');
INSERT INTO `mail` VALUES ('36', '2021-04-08 20:41:26', '65', '58', '测试邮件', '关于XXXXXX邮件', '7cb1fdd3-9f4f-4b53-a698-7c11dbaacbb4.exe', '1');
-- ----------------------------
-- Table structure for mission
-- ----------------------------
DROP TABLE IF EXISTS `mission`;
CREATE TABLE `mission` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`auther_id` int(32) NOT NULL,
`title` varchar(32) NOT NULL,
`text` text,
`pic` varchar(64) DEFAULT NULL,
`target_id` int(32) NOT NULL,
`progress` int(10) DEFAULT '0' COMMENT '进度 满是10',
`comment` text COMMENT '员工id:#评论文本:&员工id:#评论文本:&',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of mission
-- ----------------------------
INSERT INTO `mission` VALUES ('16', '61', '关于学习十九大思想报告的总结', '请大家尽快学习十九大思想，并上交学习总结心得报告。', null, '0', '15', '61:#已上交:&58:#已上交:&', '2019-09-24 16:35:51');
INSERT INTO `mission` VALUES ('20', '58', '1234', '12345', null, '73', '0', '58:#测试:&', '2021-04-08 19:51:28');
INSERT INTO `mission` VALUES ('21', '58', '关于XXX的任务', '关于XXX的任务', '9116aa8c-f92c-4747-9083-a4bc2a48d1f2.exe', '71', '0', '58:#123:&58:#测试:&', '2021-04-08 23:59:00');
INSERT INTO `mission` VALUES ('22', '58', '测试', '测试数据', '8d8581a2-3cfc-44d8-8e74-ad1123bf061d.conf', '71', '0', null, '2021-04-09 10:38:30');
INSERT INTO `mission` VALUES ('23', '58', '测试数据', '测试数据', '4e4d7c40-4d8c-4ddf-b855-6ff521643b16.jpg', '71', '0', null, '2021-04-09 10:39:17');
INSERT INTO `mission` VALUES ('24', '58', '测试数据', '测试数据', '26062685-a1e1-4097-a405-809c111f4b66.jpg', '71', '0', null, '2021-04-09 11:25:36');
INSERT INTO `mission` VALUES ('25', '58', '12', null, null, '71', '0', '58:#123:&', '2021-04-09 11:33:12');
INSERT INTO `mission` VALUES ('26', '58', '', '测试', null, '70', '0', null, '2021-04-28 10:04:43');
-- ----------------------------
-- Table structure for post
-- ----------------------------
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`post_name` varchar(50) NOT NULL,
`pre` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of post
-- ----------------------------
-- ----------------------------
-- Table structure for sys_department
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE `sys_department` (
`department_id` int(10) NOT NULL,
`department_name` varchar(32) NOT NULL,
`available` int(1) DEFAULT '1',
PRIMARY KEY (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_department
-- ----------------------------
INSERT INTO `sys_department` VALUES ('0', '全体', '0');
INSERT INTO `sys_department` VALUES ('10', '总经理', '0');
INSERT INTO `sys_department` VALUES ('20', '副总经理', '0');
INSERT INTO `sys_department` VALUES ('30', '业务部', '1');
INSERT INTO `sys_department` VALUES ('31', '业务部 销售', '1');
INSERT INTO `sys_department` VALUES ('32', '业务部 市场开发', '1');
INSERT INTO `sys_department` VALUES ('33', '业务部 售后服务', '1');
INSERT INTO `sys_department` VALUES ('40', '工程部', '1');
INSERT INTO `sys_department` VALUES ('41', '工程部 产品开发', '1');
INSERT INTO `sys_department` VALUES ('42', '工程部 产品设计', '1');
INSERT INTO `sys_department` VALUES ('50', '生产部', '1');
INSERT INTO `sys_department` VALUES ('51', '生产部 生产计划', '1');
INSERT INTO `sys_department` VALUES ('52', '生产部 设备制造', '1');
INSERT INTO `sys_department` VALUES ('53', '生产部 工程安装', '1');
INSERT INTO `sys_department` VALUES ('60', '品质部', '1');
INSERT INTO `sys_department` VALUES ('61', '品质部 品质管理', '1');
INSERT INTO `sys_department` VALUES ('62', '品质部 过程控制', '1');
INSERT INTO `sys_department` VALUES ('70', '管理部', '1');
INSERT INTO `sys_department` VALUES ('71', '管理部 人事', '1');
INSERT INTO `sys_department` VALUES ('72', '管理部 行政', '1');
INSERT INTO `sys_department` VALUES ('73', '管理部 采购', '1');
INSERT INTO `sys_department` VALUES ('74', '管理部 财务', '1');
-- ----------------------------
-- Table structure for sys_employee_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_employee_position`;
CREATE TABLE `sys_employee_position` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`employee_id` int(32) NOT NULL,
`position_id` int(32) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_employee_position
-- ----------------------------
INSERT INTO `sys_employee_position` VALUES ('28', '58', '2');
INSERT INTO `sys_employee_position` VALUES ('29', '59', '1');
INSERT INTO `sys_employee_position` VALUES ('30', '60', '0');
INSERT INTO `sys_employee_position` VALUES ('31', '61', '3');
INSERT INTO `sys_employee_position` VALUES ('32', '62', '0');
INSERT INTO `sys_employee_position` VALUES ('33', '63', '0');
INSERT INTO `sys_employee_position` VALUES ('34', '64', '3');
INSERT INTO `sys_employee_position` VALUES ('35', '65', '1');
-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
`id` bigint(20) NOT NULL COMMENT '主键',
`name` varchar(128) NOT NULL COMMENT '资源名称',
`type` varchar(32) NOT NULL COMMENT '资源类型：menu,button,',
`url` varchar(128) DEFAULT NULL COMMENT '访问url地址',
`percode` varchar(128) DEFAULT NULL COMMENT '权限代码字符串',
`parentid` bigint(20) DEFAULT NULL COMMENT '父结点id',
`parentids` varchar(128) DEFAULT NULL COMMENT '父结点id列表串',
`sortstring` varchar(128) DEFAULT NULL COMMENT '排序号',
`available` char(1) DEFAULT NULL COMMENT '是否可用,1：可用，0不可用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES ('1', '权限', '', '', null, '0', '0/', '0', '1');
INSERT INTO `sys_permission` VALUES ('11', '公告', 'menu', '', 'announce:query', '1', '0/1/', '1.', '1');
INSERT INTO `sys_permission` VALUES ('12', '发布公告', 'permission', '/announce.action', 'announce:create', '11', '0/1/11/', '', '1');
INSERT INTO `sys_permission` VALUES ('13', '删除公告', 'permission', '/delete_announce.action', 'announce:delete', '11', '0/1/11/', '', '1');
INSERT INTO `sys_permission` VALUES ('21', '任务', 'menu', '/mission', 'mission:query', '1', '0/1/', '2.', '1');
INSERT INTO `sys_permission` VALUES ('22', '发布任务', 'permission', '/mission/post_mission.action', 'mission:create', '21', '0/1/21/', '', '1');
INSERT INTO `sys_permission` VALUES ('23', '删除任务', 'permission', '/mission/delete_mission.action', 'mission:delete', '21', '0/1/21/', '', '1');
INSERT INTO `sys_permission` VALUES ('24', '删除评论', 'permission', '/mission/delete_comment.action', 'mission:comment_delete', '21', '0/1/21/', '', '1');
INSERT INTO `sys_permission` VALUES ('121', '发布全体公告', 'permission', '/announce.action', 'announce:create:all', '12', '0/1/11/12', '1.1', '1');
INSERT INTO `sys_permission` VALUES ('122', '发布大部门公告', 'permission', '/announce.action', 'announce:create:main', '12', '0/1/11/12', null, '1');
INSERT INTO `sys_permission` VALUES ('123', '发布子部门公告', 'permission', '/announce.action', 'announce:create:sub', '12', '0/1/11/12', null, '1');
INSERT INTO `sys_permission` VALUES ('221', '发布全体任务', 'permission', '/mission/post_mission.action', 'mission:create:all', '22', '0/1/21/22', '2.1', '1');
INSERT INTO `sys_permission` VALUES ('222', '发布大部门任务', 'permission', '/mission/post_mission.action', 'mission:create:main', '22', '0/1/21/22', null, '1');
INSERT INTO `sys_permission` VALUES ('223', '发布子部门任务', 'permission', '/mission/post_mission.action', 'mission:create:sub', '22', '0/1/21/22', null, '1');
-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_position`;
CREATE TABLE `sys_position` (
`position_id` int(32) NOT NULL,
`position_name` varchar(32) DEFAULT NULL,
`available` int(1) DEFAULT '1',
PRIMARY KEY (`position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_position
-- ----------------------------
INSERT INTO `sys_position` VALUES ('0', '无', '1');
INSERT INTO `sys_position` VALUES ('1', '组长', '1');
INSERT INTO `sys_position` VALUES ('2', '部门经理', '1');
INSERT INTO `sys_position` VALUES ('3', '总监', '1');
INSERT INTO `sys_position` VALUES ('4', '特殊', '0');
-- ----------------------------
-- Table structure for sys_position_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_position_permission`;
CREATE TABLE `sys_position_permission` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`posision_id` int(32) NOT NULL,
`permission_id` int(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_position_permission
-- ----------------------------
INSERT INTO `sys_position_permission` VALUES ('1', '0', '11');
INSERT INTO `sys_position_permission` VALUES ('2', '0', '21');
INSERT INTO `sys_position_permission` VALUES ('3', '1', '11');
INSERT INTO `sys_position_permission` VALUES ('4', '1', '21');
INSERT INTO `sys_position_permission` VALUES ('5', '1', '123');
INSERT INTO `sys_position_permission` VALUES ('6', '1', '223');
INSERT INTO `sys_position_permission` VALUES ('7', '2', '11');
INSERT INTO `sys_position_permission` VALUES ('8', '2', '21');
INSERT INTO `sys_position_permission` VALUES ('9', '2', '222');
INSERT INTO `sys_position_permission` VALUES ('10', '2', '122');
INSERT INTO `sys_position_permission` VALUES ('11', '3', '11');
INSERT INTO `sys_position_permission` VALUES ('12', '3', '21');
INSERT INTO `sys_position_permission` VALUES ('13', '3', '121');
INSERT INTO `sys_position_permission` VALUES ('14', '3', '221');
INSERT INTO `sys_position_permission` VALUES ('15', '3', '13');
INSERT INTO `sys_position_permission` VALUES ('16', '3', '23');
INSERT INTO `sys_position_permission` VALUES ('17', '3', '122');
INSERT INTO `sys_position_permission` VALUES ('18', '3', '222');
INSERT INTO `sys_position_permission` VALUES ('19', '4', '11');
INSERT INTO `sys_position_permission` VALUES ('21', '4', '21');
INSERT INTO `sys_position_permission` VALUES ('22', '4', '121');
INSERT INTO `sys_position_permission` VALUES ('23', '4', '221');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手