代码拉取完成,页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : 1
Source Server Version : 50727
Source Host : localhost:3306
Source Database : oa_db
Target Server Type : MYSQL
Target Server Version : 50727
File Encoding : 65001
Date: 2020-11-25 18:56:19
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `sys_department`
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE `sys_department` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`ParentDepartmentId` int(11) DEFAULT NULL,
`Name` varchar(25) DEFAULT NULL,
`Sort` int(11) DEFAULT NULL,
`Description` varchar(500) DEFAULT NULL,
`type` varchar(25) DEFAULT NULL COMMENT '机构类型',
`area` varchar(500) DEFAULT NULL COMMENT '所属区域',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=111127 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_department
-- ----------------------------
INSERT INTO `sys_department` VALUES ('1', '0', '公司部门组织结构', '1', '根节点', '组织', '广州');
INSERT INTO `sys_department` VALUES ('11', '1', '总公司', '1', '总公司', '总管', '广州');
INSERT INTO `sys_department` VALUES ('12', '1', '子公司', '2', '子公司', '销售', '深圳');
INSERT INTO `sys_department` VALUES ('111', '11', '研发部', '1', '负责研发新框架', '技术', '广州');
INSERT INTO `sys_department` VALUES ('112', '11', '人事部', '2', '负责做招人、加薪', '行政', '广州');
INSERT INTO `sys_department` VALUES ('121', '12', '子公司1', '1', '我是第一个子公司', '管理', '广州');
INSERT INTO `sys_department` VALUES ('122', '12', '子公司2', '2', '子公司2', '管理', '深圳');
INSERT INTO `sys_department` VALUES ('111112', '111', '财务部', '1', '收钱,发公粮,收税部', '行政', '杭州');
INSERT INTO `sys_department` VALUES ('111113', '111', '计算机部', '2', '计算机与科学1', '技术', '广州');
INSERT INTO `sys_department` VALUES ('111114', '111', '软件工程', '3', '软件学部', '技术分支', '广州');
INSERT INTO `sys_department` VALUES ('111115', '111114', '计算机2部', '2', '计算机与科学', '技术', '广州');
INSERT INTO `sys_department` VALUES ('111116', '111114', '软件工程小专业', '1', '小软工专业', '技术小分支', '广州');
INSERT INTO `sys_department` VALUES ('111121', '111114', '小软工', '1', '小软工', '技术分支', '广州');
INSERT INTO `sys_department` VALUES ('111122', '111114', '软件2分院', '1', '软件2分院222', '技术分支2', '广州');
INSERT INTO `sys_department` VALUES ('111123', '111114', '软工三分院', '1', '软工三分院', '技术分支3', '广州');
INSERT INTO `sys_department` VALUES ('111124', '111114', '软件四分院', '1', '软件四分院', '技术四分支', '广州');
INSERT INTO `sys_department` VALUES ('111125', '111114', '小小小分院', '1', '小小小分院', '技术', '广州');
INSERT INTO `sys_department` VALUES ('111126', '12', '子公司3', '1', '子公司3', '管理', '深圳');
-- ----------------------------
-- Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL COMMENT '菜单名称',
`icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
`href` varchar(255) DEFAULT NULL COMMENT 'url',
`spread` char(1) DEFAULT '0' COMMENT '是否展开,1展开 0不展开',
`sort` int(10) DEFAULT NULL COMMENT '排序',
`is_top` varchar(1) DEFAULT '0' COMMENT '是否是顶级菜单 1:是 0 不是',
`del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
`level` int(10) DEFAULT NULL COMMENT '层级',
`type` varchar(12) DEFAULT NULL COMMENT '菜单类型:0:目录菜单 1:权限菜单',
`permission` varchar(200) DEFAULT NULL COMMENT '权限标识',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='菜单表';
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', '75', '系统管理', 'fa-desktop', 'https://www.layui.com/admin/std/dist/views/set/system/website.html', '0', '1', '1', '0', '1', '0', '1');
INSERT INTO `sys_menu` VALUES ('3', '1', '我的面板', 'fa-television', 'https://www.layui.com/admin/std/dist/views/template/personalpage.html', '0', '2', '0', '0', '2', '0', '2');
INSERT INTO `sys_menu` VALUES ('4', '3', '个人信息', 'fa-vcard-o', 'https://www.layui.com/admin/std/dist/views/set/user/info.html', '0', '1', '0', '0', '3', '0', '3');
INSERT INTO `sys_menu` VALUES ('5', '3', '修改密码', 'fa-gear', 'https://www.layui.com/admin/std/dist/views/set/user/password.html', '0', '2', '0', '0', '3', '0', '4');
INSERT INTO `sys_menu` VALUES ('6', '1', '系统设置', 'fa-cogs', 'https://www.layui.com/admin/std/dist/views/set/system/website.html', '0', '3', '0', '0', '2', '0', '5');
INSERT INTO `sys_menu` VALUES ('7', '6', '用户管理', 'fa-user-o', '/toSysUserList', '0', '1', '0', '0', '3', '0', '6');
INSERT INTO `sys_menu` VALUES ('8', '6', '角色管理', 'fa-user-circle', '/toSysRoleList', '0', '2', '0', '0', '3', '0', '7');
INSERT INTO `sys_menu` VALUES ('9', '6', '菜单管理', 'fa-window-restore', '/toSysMenuList', '0', '3', '0', '0', '3', '0', '8');
INSERT INTO `sys_menu` VALUES ('24', '75', '内容管理', 'fa-file-word-o', 'https://www.layui.com/admin/std/dist/views/app/forum/list.html', '0', '2', '1', '0', '1', '0', '9');
INSERT INTO `sys_menu` VALUES ('25', '24', '网站管理', 'fa-window-maximize', 'https://www.layui.com/admin/std/dist/views/app/workorder/list.html', '0', '1', '0', '0', '2', '0', '10');
INSERT INTO `sys_menu` VALUES ('75', '0', 'OA后台管理系统', '', '', '1', '1', '0', '0', '0', '0', '11');
INSERT INTO `sys_menu` VALUES ('76', '25', '友链管理', 'fa-link', 'https://www.layui.com/admin/std/dist/views/app/workorder/list.html', '0', '7', '0', '0', '3', '0', '12');
INSERT INTO `sys_menu` VALUES ('80', '1', '系统监控', 'fa-eye', 'https://www.layui.com/admin/std/dist/views/home/homepage2.html', '0', '3', '0', '0', '2', '0', '13');
INSERT INTO `sys_menu` VALUES ('81', '80', '连接池监视', 'fa-chain-broken', 'https://www.layui.com/admin/std/dist/views/home/homepage2.html', '0', '2', '0', '0', '3', '0', '14');
INSERT INTO `sys_menu` VALUES ('84', '6', '文件管理', 'fa-file-word-o', '/res/ckfinder/_samples/standalone_v1.html', '0', '5', '0', '0', '3', '0', '15');
INSERT INTO `sys_menu` VALUES ('85', '25', '会员管理', 'fa-users', '/user/list.do', '0', '2', '0', '0', '3', '0', '16');
INSERT INTO `sys_menu` VALUES ('87', '6', '字典管理', 'fa-file-o', 'https://www.layui.com/admin/std/dist/views/app/content/comment.html', '0', '6', '0', '0', '3', '0', '17');
INSERT INTO `sys_menu` VALUES ('88', '1', '系统工具', 'fa-steam-square', 'https://www.layui.com/admin/std/dist/views/home/homepage1.html', '0', '4', '0', '0', '2', '0', '18');
INSERT INTO `sys_menu` VALUES ('89', '88', '代码生成', 'fa-cc', 'https://www.layui.com/admin/std/dist/views/template/tips/404.html', '0', '0', '0', '0', '3', '0', '19');
INSERT INTO `sys_menu` VALUES ('90', '88', '生成测试', 'fa-hand-peace-o', 'https://www.layui.com/admin/std/dist/views/template/personalpage.html', '0', '2', '0', '0', '3', '0', '20');
INSERT INTO `sys_menu` VALUES ('91', '88', '网站设置', 'fa-hourglass-2', 'https://www.layui.com/admin/std/dist/views/set/system/website.html', '0', '3', '0', '0', '3', '0', '21');
INSERT INTO `sys_menu` VALUES ('92', '88', 'Cron生成器', 'fa-file-excel-o', '/res/cron/index.htm', '0', '4', '0', '0', '3', '0', '22');
INSERT INTO `sys_menu` VALUES ('94', '76', '新增', '', '', '0', '0', '0', '0', '4', '1', 'sysuser:add');
INSERT INTO `sys_menu` VALUES ('95', '76', '删除', '', '', '0', '5', '0', '0', '4', '1', 'sysuser:delete');
INSERT INTO `sys_menu` VALUES ('96', '76', '修改', '', '', '0', '0', '0', '0', '4', '1', 'sysuser:update');
INSERT INTO `sys_menu` VALUES ('97', '6', '机构管理', 'fa-university', '/toSysDepartMentList', '0', '4', '0', '0', '3', '0', '23');
INSERT INTO `sys_menu` VALUES ('99', '6', '蓝天小云自定义', 'fa-gear', '/toSysMenuList', '0', '1', '0', '0', '2', '0', '24');
-- ----------------------------
-- Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '角色名称',
`useable` varchar(64) DEFAULT '0' COMMENT '是否可用 0:可用 1:不可用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='角色表';
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('4', '内容管理员', '0');
INSERT INTO `sys_role` VALUES ('5', '超级管理员', '0');
INSERT INTO `sys_role` VALUES ('7', '系统管理员', '0');
INSERT INTO `sys_role` VALUES ('8', '幕后交易员', '1');
INSERT INTO `sys_role` VALUES ('9', '前台人员', '0');
-- ----------------------------
-- Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`role_id` varchar(255) NOT NULL COMMENT '角色编号',
`menu_id` varchar(255) NOT NULL COMMENT '菜单编号',
PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单关联表';
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('4', '24');
INSERT INTO `sys_role_menu` VALUES ('4', '25');
INSERT INTO `sys_role_menu` VALUES ('4', '85');
INSERT INTO `sys_role_menu` VALUES ('5', '1');
INSERT INTO `sys_role_menu` VALUES ('5', '24');
INSERT INTO `sys_role_menu` VALUES ('5', '25');
INSERT INTO `sys_role_menu` VALUES ('5', '3');
INSERT INTO `sys_role_menu` VALUES ('5', '4');
INSERT INTO `sys_role_menu` VALUES ('5', '5');
INSERT INTO `sys_role_menu` VALUES ('5', '6');
INSERT INTO `sys_role_menu` VALUES ('5', '7');
INSERT INTO `sys_role_menu` VALUES ('5', '76');
INSERT INTO `sys_role_menu` VALUES ('5', '8');
INSERT INTO `sys_role_menu` VALUES ('5', '80');
INSERT INTO `sys_role_menu` VALUES ('5', '81');
INSERT INTO `sys_role_menu` VALUES ('5', '84');
INSERT INTO `sys_role_menu` VALUES ('5', '87');
INSERT INTO `sys_role_menu` VALUES ('5', '88');
INSERT INTO `sys_role_menu` VALUES ('5', '89');
INSERT INTO `sys_role_menu` VALUES ('5', '9');
INSERT INTO `sys_role_menu` VALUES ('5', '90');
INSERT INTO `sys_role_menu` VALUES ('5', '91');
INSERT INTO `sys_role_menu` VALUES ('5', '92');
INSERT INTO `sys_role_menu` VALUES ('5', '94');
INSERT INTO `sys_role_menu` VALUES ('5', '95');
INSERT INTO `sys_role_menu` VALUES ('5', '96');
INSERT INTO `sys_role_menu` VALUES ('5', '97');
INSERT INTO `sys_role_menu` VALUES ('5', '99');
INSERT INTO `sys_role_menu` VALUES ('7', '1');
INSERT INTO `sys_role_menu` VALUES ('7', '3');
INSERT INTO `sys_role_menu` VALUES ('7', '4');
INSERT INTO `sys_role_menu` VALUES ('7', '5');
INSERT INTO `sys_role_menu` VALUES ('7', '6');
INSERT INTO `sys_role_menu` VALUES ('7', '7');
INSERT INTO `sys_role_menu` VALUES ('7', '8');
INSERT INTO `sys_role_menu` VALUES ('7', '9');
INSERT INTO `sys_role_menu` VALUES ('8', '1');
INSERT INTO `sys_role_menu` VALUES ('8', '24');
INSERT INTO `sys_role_menu` VALUES ('8', '25');
INSERT INTO `sys_role_menu` VALUES ('8', '80');
INSERT INTO `sys_role_menu` VALUES ('8', '81');
INSERT INTO `sys_role_menu` VALUES ('8', '85');
INSERT INTO `sys_role_menu` VALUES ('8', '88');
INSERT INTO `sys_role_menu` VALUES ('8', '89');
INSERT INTO `sys_role_menu` VALUES ('8', '90');
INSERT INTO `sys_role_menu` VALUES ('8', '91');
INSERT INTO `sys_role_menu` VALUES ('8', '92');
INSERT INTO `sys_role_menu` VALUES ('9', '1');
INSERT INTO `sys_role_menu` VALUES ('9', '3');
INSERT INTO `sys_role_menu` VALUES ('9', '4');
INSERT INTO `sys_role_menu` VALUES ('9', '5');
INSERT INTO `sys_role_menu` VALUES ('9', '6');
INSERT INTO `sys_role_menu` VALUES ('9', '7');
INSERT INTO `sys_role_menu` VALUES ('9', '8');
INSERT INTO `sys_role_menu` VALUES ('9', '80');
INSERT INTO `sys_role_menu` VALUES ('9', '81');
INSERT INTO `sys_role_menu` VALUES ('9', '84');
INSERT INTO `sys_role_menu` VALUES ('9', '9');
-- ----------------------------
-- Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login_name` varchar(255) NOT NULL,
`pwd` varchar(255) DEFAULT NULL,
`img` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`sex` varchar(2) DEFAULT NULL,
`mobile` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
`status` char(1) DEFAULT '0' COMMENT '可用状态:0可用 1不可用',
`name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
`role_id` int(11) DEFAULT NULL COMMENT '角色id',
`org_id` int(11) DEFAULT NULL COMMENT '机构id',
PRIMARY KEY (`id`),
UNIQUE KEY `login_name_unique` (`login_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '/layuiadmin/xx.jpg', '15751123456@163.com', '男', '15751123456', '0', 'admin', '5', '4');
INSERT INTO `sys_user` VALUES ('2', '格式化记忆', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751123456@qq.com', '女', '15751123456', '1', 'admin', '5', '1');
INSERT INTO `sys_user` VALUES ('6', 'test_1', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751123456@163.com', '男', '15751123456', '1', 'test', '7', '0');
INSERT INTO `sys_user` VALUES ('7', 'test2', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三1', '4', '111');
INSERT INTO `sys_user` VALUES ('8', 'test3', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '幕后交易员3', '4', '111');
INSERT INTO `sys_user` VALUES ('9', 'test4', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@126.com', '女', '15751155391', '3', '前台人员', '5', '112');
INSERT INTO `sys_user` VALUES ('13', 'test8', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('14', 'test9', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('15', 'test10', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('16', 'test11', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('17', 'test12', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('18', 'test13', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('19', 'test14', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('20', 'test15', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('21', 'test16', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('22', 'test17', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('23', 'test18', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('24', 'test19', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('25', 'test20', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '女', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('26', 'test21', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '15751155385@163.com', '男', '15751155390', '0', '张三', '4', '111');
INSERT INTO `sys_user` VALUES ('27', '123456', 'e10adc3949ba59abbe56e057f20f883e', '/layuiadmin/xx.jpg', '973463717@qq.com', '男', '13533355333', '0', '蓝景钊', '4', '112');
INSERT INTO `sys_user` VALUES ('28', '12345', 'd31d0d1cb1ff386ba40b4cecf5dbb802', '/layuiadmin/xx.jpg', '973463717@qq.com', '女', '13233233332', '0', '蓝景', '4', '112');
INSERT INTO `sys_user` VALUES ('29', '973463717', 'd31d0d1cb1ff386ba40b4cecf5dbb802', '/layuiadmin/xx.jpg', '973463717@qq.com', '男', '15751155391', '0', '蓝景钊', '5', '121');
INSERT INTO `sys_user` VALUES ('30', 'lanjz', 'd31d0d1cb1ff386ba40b4cecf5dbb802', '/layuiadmin/xx.jpg', '973463717@qq.com', '男', '15751155391', '0', '蓝景钊', '5', '11');
INSERT INTO `sys_user` VALUES ('31', 'lanjjz', 'd31d0d1cb1ff386ba40b4cecf5dbb802', '/layuiadmin/xx.jpg', '973463717@qq.com', '男', '15751155391', '0', '蓝景钊', '5', '122');
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。