/*
Navicat MySQL Data Transfer

Source Server         : 192.168.170.22
Source Server Version : 80027
Source Host           : 192.168.170.22:3306
Source Database       : zuihou_base_yj_0000

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

Date: 2022-01-12 10:53:05
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for c_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `c_auth_menu`;
CREATE TABLE `c_auth_menu` (
  `id` bigint NOT NULL COMMENT '主键',
  `label` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
  `describe_` varchar(200) DEFAULT '' COMMENT '描述',
  `is_public` bit(1) DEFAULT b'0' COMMENT '公共菜单\nTrue是无需分配所有人就可以访问的',
  `path` varchar(255) DEFAULT '' COMMENT '路径',
  `component` varchar(255) DEFAULT NULL COMMENT '组件',
  `is_enable` bit(1) DEFAULT b'1' COMMENT '状态',
  `sort_value` int DEFAULT '1' COMMENT '排序',
  `icon` varchar(255) DEFAULT '' COMMENT '菜单图标',
  `group_` varchar(20) DEFAULT '' COMMENT '分组',
  `parent_id` bigint DEFAULT '0' COMMENT '父级菜单ID',
  `create_user` bigint DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `name` varchar(200) DEFAULT NULL,
  `no_cache` bit(1) DEFAULT b'1' COMMENT '是否缓存',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单';

-- ----------------------------
-- Records of c_auth_menu
-- ----------------------------
INSERT INTO `c_auth_menu` VALUES ('101', '用户中心', '用户组织机构', '\0', '/user', 'Layout', '', '1', 'el-icon-user-solid', '', '0', '1', '2019-07-25 15:35:12', '3', '2019-11-11 14:32:02', null, '');
INSERT INTO `c_auth_menu` VALUES ('102', '权限管理', '管理权限相关', '\0', '/auth', 'Layout', '', '2', 'el-icon-lock', '', '0', '1', '2019-07-27 11:48:49', '3', '2019-11-11 14:35:39', null, '');
INSERT INTO `c_auth_menu` VALUES ('103', '基础配置', '基础的配置', '\0', '/base', 'Layout', '', '3', 'el-icon-set-up', '', '0', '1', '2019-11-11 14:38:29', '3', '2019-11-11 14:35:42', null, '');
INSERT INTO `c_auth_menu` VALUES ('104', '开发者管理', '开发者', '\0', '/developer', 'Layout', '', '4', 'el-icon-user-solid', '', '0', '1', '2019-11-11 14:38:34', '3', '2019-11-11 14:35:44', null, '');
INSERT INTO `c_auth_menu` VALUES ('105', '消息中心', '站内信', '\0', '/msgs', 'Layout', '', '5', 'el-icon-chat-line-square', '', '0', '1', '2019-11-11 14:38:32', '3', '2019-11-11 14:35:47', null, '');
INSERT INTO `c_auth_menu` VALUES ('106', '短信中心', '短信接口', '\0', '/sms', 'Layout', '', '6', 'el-icon-chat-line-round', '', '0', '1', '2019-11-11 14:38:36', '3', '2019-11-11 14:35:49', null, '');
INSERT INTO `c_auth_menu` VALUES ('107', '文件中心', '附件接口', '\0', '/file', 'Layout', '', '7', 'el-icon-folder-add', '', '0', '1', '2019-11-11 14:38:38', '3', '2019-11-11 14:35:51', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659394', '多级菜单', '演示专用', '', '/nested', 'Layout', '', '13', 'nested', '', '0', '3', '2020-09-27 20:30:26', '3', '2020-09-27 20:32:34', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659399', '菜单1', '', '', '/nested/menu1', 'Layout', '', '1', 'bug', '', '4769114505659394', '3', '2020-09-27 20:31:17', '3', '2020-09-27 20:40:11', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659475', '菜单2', '', '', '/nested/menu2', 'zuihou/nested/menu2/index', '', '2', 'el-icon-eleme', '', '4769114505659394', '3', '2020-09-27 20:39:57', '3', '2020-09-27 20:41:13', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659482', '菜单1-1', '', '', '/nested/menu1/menu1-1', 'zuihou/nested/menu1/menu1-1/index', '', '1', '', '', '4769114505659399', '3', '2020-09-27 20:41:04', '3', '2020-09-27 20:41:04', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659489', '菜单1-2', '', '', '/nested/menu1/menu1-2', 'Layout', '', '2', '', '', '4769114505659399', '3', '2020-09-27 20:41:39', '3', '2020-09-27 20:42:04', null, '');
INSERT INTO `c_auth_menu` VALUES ('[REDACTED]', '菜单1-3', '', '', '/nested/menu1/menu1-3', 'zuihou/nested/menu1/menu1-3/index', '', '3', '', '', '4769114505659399', '3', '2020-09-27 20:42:33', '3', '2020-09-27 20:42:33', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659504', '菜单1-2-1', '', '', '/nested/menu1/menu1-2/menu1-2-1', 'zuihou/nested/menu1/menu1-2/menu1-2-1/index', '', '1', '', '', '4769114505659489', '3', '2020-09-27 20:43:11', '3', '2020-09-27 20:43:11', null, '');
INSERT INTO `c_auth_menu` VALUES ('4769114505659507', '菜单1-2-2', '', '', '/nested/menu1/menu1-2/menu1-2-2', 'zuihou/nested/menu1/menu1-2/menu1-2-2/index', '', '2', '', '', '4769114505659489', '3', '2020-09-27 20:43:34', '3', '2020-09-27 20:43:34', null, '');
INSERT INTO `c_auth_menu` VALUES ('603976297063910529', '菜单配置', '', '\0', '/auth/menu', 'zuihou/auth/menu/Index', '', '0', '', '', '102', '1', '2019-07-25 15:46:11', '3', '2019-11-11 14:31:52', null, '');
INSERT INTO `c_auth_menu` VALUES ('603981723864141121', '角色管理', '', '\0', '/auth/role', 'zuihou/auth/role/Index', '', '1', '', '', '102', '1', '2019-07-25 16:07:45', '3', '2019-11-11 14:31:57', null, '');
INSERT INTO `c_auth_menu` VALUES ('603982542332235201', '组织管理', '', '\0', '/user/org', 'zuihou/user/org/Index', '', '0', '', '', '101', '1', '2019-07-25 16:11:00', '3', '2019-11-11 14:28:40', null, '');
INSERT INTO `c_auth_menu` VALUES ('603982713849908801', '岗位管理', '', '\0', '/user/station', 'zuihou/user/station/Index', '', '1', '', '', '101', '1', '2019-07-25 16:11:41', '3', '2019-11-11 14:28:43', null, '');
INSERT INTO `c_auth_menu` VALUES ('603983082961243905', '用户管理', '', '\0', '/user/user', 'zuihou/user/user/Index', '', '2', '', '', '101', '1', '2019-07-25 16:13:09', '3', '2019-11-11 14:28:49', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078371293987105', '数据字典维护', '', '\0', '/base/dict', 'zuihou/base/dict/Index', '', '0', '', '', '103', '1', '2019-07-28 16:45:26', '3', '2019-11-11 14:34:23', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078371293987106', '编码规则', '', '\0', '/systemMgr/codeStandard', 'zuihou/systemMgr/codeStandard/Index', '', '0', '', '', '103', '1', '2019-07-28 16:45:26', '3', '2020-10-29 16:31:11', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078463069552993', '地区信息维护', '', '\0', '/base/area', 'zuihou/base/area/Index', '', '1', '', '', '103', '1', '2019-07-28 16:45:48', '3', '2019-11-11 14:34:26', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078538881597857', '应用管理', '', '\0', '/developer/application', 'zuihou/developer/application/Index', '', '0', '', '', '104', '1', '2019-07-28 16:46:06', '3', '2019-12-25 16:19:43', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078672772170209', '操作日志', '', '\0', '/developer/optLog', 'zuihou/developer/optLog/Index', '', '3', '', '', '104', '1', '2019-07-28 16:46:38', '3', '2019-11-11 14:35:14', null, '');
INSERT INTO `c_auth_menu` VALUES ('605078979149300257', '数据库监控', '', '\0', '/developer/db', 'zuihou/developer/db/Index', '', '2', '', '', '104', '1', '2019-07-28 16:47:51', '3', '2019-11-16 16:35:50', null, '');
INSERT INTO `c_auth_menu` VALUES ('605079239015793249', '接口文档', '', '\0', 'http://127.0.0.1:8760/api/gate/doc.html', 'Layout', '', '5', '', '', '104', '1', '2019-07-28 16:48:53', '3', '2019-11-16 10:55:03', null, '');
INSERT INTO `c_auth_menu` VALUES ('605079411338773153', '注册&配置中心', '', '\0', 'http://127.0.0.1:8848/nacos', 'Layout', '', '6', '', '', '104', '1', '2019-07-28 16:49:34', '3', '2019-11-16 10:55:06', null, '');
INSERT INTO `c_auth_menu` VALUES ('605079545585861345', '缓存监控', '', '\0', 'http://www.baidu.com', 'Layout', '', '7', '', '', '104', '1', '2019-07-28 16:50:06', '3', '2019-11-16 10:55:08', null, '');
INSERT INTO `c_auth_menu` VALUES ('605079658416833313', '服务器监控', '', '\0', 'http://127.0.0.1:8762/zuihou-monitor', 'Layout', '', '8', '', '', '104', '1', '2019-07-28 16:50:33', '3', '2019-11-16 10:55:15', null, '');
INSERT INTO `c_auth_menu` VALUES ('605079751035454305', '消息推送', '', '\0', '/msgs/sendMsgs', 'zuihou/msgs/sendMsgs/Index', '', '0', '', '', '105', '1', '2019-07-28 16:50:55', '3', '2019-11-11 14:28:30', null, '');
INSERT INTO `c_auth_menu` VALUES ('605080023753294753', '我的消息', '', '\0', '/msgs/myMsgs', 'zuihou/msgs/myMsgs/Index', '', '1', '', '', '105', '1', '2019-07-28 16:52:00', '3', '2019-11-11 14:28:27', null, '');
INSERT INTO `c_auth_menu` VALUES ('605080107379327969', '账号配置', '', '\0', '/sms/template', 'zuihou/sms/template/Index', '', '1', '', '', '106', '1', '2019-07-28 16:52:20', '3', '2019-11-21 19:53:17', null, '');
INSERT INTO `c_auth_menu` VALUES ('605080359394083937', '短信管理', '', '\0', '/sms/manage', 'zuihou/sms/manage/Index', '', '0', '', '', '106', '1', '2019-07-28 16:53:20', '3', '2019-11-21 19:53:09', null, '');
INSERT INTO `c_auth_menu` VALUES ('605080648767505601', '附件列表', '', '\0', '/file/attachment', 'zuihou/file/attachment/Index', '', '0', '', '', '107', '1', '2019-07-28 16:54:29', '3', '2019-11-11 14:28:07', null, '');
INSERT INTO `c_auth_menu` VALUES ('605080816296396097', '定时调度中心', '', '\0', 'http://127.0.0.1:8767/zuihou-jobs-server', 'Layout', '', '9', '', '', '104', '1', '2019-07-28 16:55:09', '3', '2019-11-16 10:55:18', null, '');
INSERT INTO `c_auth_menu` VALUES ('643464272629728001', '务必详看', '', '', '/doc', 'zuihou/doc/Index', '', '0', 'el-icon-notebook-1', '', '0', '3', '2019-11-11 14:57:18', '3', '2019-11-11 15:01:31', null, '');
INSERT INTO `c_auth_menu` VALUES ('643464392888812545', '后端代码', '', '', 'https://github.com/zuihou/zuihou-admin-cloud', 'Layout', '', '1', '', '', '643464272629728001', '3', '2019-11-11 14:57:46', '3', '2019-11-11 15:00:05', null, '');
INSERT INTO `c_auth_menu` VALUES ('643464517879071841', '租户平台-前端代码', '', '', 'https://github.com/zuihou/zuihou-ui', 'Layout', '', '2', '', '', '643464272629728001', '3', '2019-11-11 14:58:16', '3', '2019-11-11 15:00:09', null, '');
INSERT INTO `c_auth_menu` VALUES ('643464706228487361', '运营平台-前端代码', '', '', 'https://github.com/zuihou/zuihou-admin-ui', 'Layout', '', '3', '', '', '643464272629728001', '3', '2019-11-11 14:59:01', '3', '2019-11-11 15:00:11', null, '');
INSERT INTO `c_auth_menu` VALUES ('643464953478514081', '在线文档', '', '', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud', 'Layout', '', '0', '', '', '643464272629728001', '3', '2019-11-11 15:00:00', '3', '2019-11-11 15:01:36', null, '');
INSERT INTO `c_auth_menu` VALUES ('643874916004790785', '运营平台演示地址', null, '', 'http://127.0.0.1:8081/zuihou-admin-ui', 'Layout', '', '4', null, null, '643464272629728001', '3', '2019-11-12 18:09:03', '641577229343523041', '2019-12-04 16:20:13', null, '');
INSERT INTO `c_auth_menu` VALUES ('644111530555611361', '链路调用监控', '', '\0', 'http://127.0.0.1:8772/zipkin', 'Layout', '', '10', '', '', '104', '3', '2019-11-13 09:49:16', '3', '2019-11-13 09:56:51', null, '');
INSERT INTO `c_auth_menu` VALUES ('645215230518909025', '登录日志', '', '\0', '/developer/loginLog', 'zuihou/developer/loginLog/Index', '', '4', '', '', '104', '3', '2019-11-16 10:54:59', '3', '2019-11-16 10:54:59', null, '');
INSERT INTO `c_auth_menu` VALUES ('1225042542827929600', '参数配置', '', '\0', '/base/parameter', 'zuihou/base/parameter/Index', '', '3', '', '', '103', '3', '2020-02-05 21:04:37', '3', '2020-02-05 21:04:37', null, '');
INSERT INTO `c_auth_menu` VALUES ('1291625710699413504', '网关管理', '', '\0', '/gateway', 'zuihou/gateway/Index', '', '10', 'el-icon-odometer', '', '0', '3', '2020-08-07 14:42:21', '3', '2020-08-07 14:42:21', null, '');
INSERT INTO `c_auth_menu` VALUES ('1291625997229096960', '限流规则', '', '\0', '/gateway/ratelimiter', 'zuihou/gateway/ratelimiter/Index', '', '1', '', '', '1291625710699413504', '3', '2020-08-07 14:43:30', '3', '2020-08-07 14:57:56', null, '');
INSERT INTO `c_auth_menu` VALUES ('1291626135842455552', '阻止访问', '', '\0', '/gateway/blocklist', 'zuihou/gateway/blocklist/Index', '', '2', '', '', '1291625710699413504', '3', '2020-08-07 14:44:03', '3', '2020-08-07 14:44:03', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303978131115212800', '流程管理', '', '\0', '/activiti', 'zuihou/activiti/Index', '', '11', 'el-icon-set-up', '', '0', '3', '2020-09-10 16:46:28', '3', '2020-09-10 16:52:17', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303979491734847488', '模型管理', '', '\0', '/activiti/modelManager', 'zuihou/activiti/modelManager/Index', '', '1', 'el-icon-ship', '', '1303978131115212800', '3', '2020-09-10 16:51:52', '3', '2020-09-10 16:51:52', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303980213637480448', '流程部署', '', '\0', '/activiti/deploymentManager', 'zuihou/activiti/deploymentManager/Index', '', '2', 'el-icon-place', '', '1303978131115212800', '3', '2020-09-10 16:54:44', '3', '2020-09-10 17:09:21', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303980518802456576', '请假流程', '', '\0', '/activiti/leave', 'zuihou/activiti/leave/Index', '', '3', 'el-icon-date', '', '1303978131115212800', '3', '2020-09-10 16:55:57', '3', '2020-09-10 17:09:38', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303980730522533888', '报销流程', '', '\0', '/activiti/reimbursement', 'zuihou/activiti/reimbursement/Index', '', '4', 'el-icon-coin', '', '1303978131115212800', '3', '2020-09-10 16:56:48', '3', '2020-09-10 17:10:03', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303981611234099200', '请假管理', '', '\0', '/activiti/leave/instantManager', 'zuihou/activiti/leave/instantManager/Index', '', '1', 'el-icon-edit', '', '1303980518802456576', '3', '2020-09-10 17:00:18', '3', '2020-09-10 17:00:18', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303981798207782912', '请假任务', '', '\0', '/activiti/leave/ruTask', 'zuihou/activiti/leave/ruTask/Index', '', '2', 'skill', '', '1303980518802456576', '3', '2020-09-10 17:01:02', '3', '2020-09-26 23:18:14', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303982140681093120', '报销管理', '', '\0', '/activiti/reimbursement/instantManager', 'zuihou/activiti/reimbursement/instantManager/Index', '', '0', 'el-icon-edit', '', '1303980730522533888', '3', '2020-09-10 17:02:24', '3', '2020-09-10 17:02:24', null, '');
INSERT INTO `c_auth_menu` VALUES ('1303982265327419392', '报销任务', '', '\0', '/activiti/reimbursement/ruTask', 'zuihou/activiti/reimbursement/ruTask/Index', '', '2', 'el-icon-tickets', '', '1303980730522533888', '3', '2020-09-10 17:02:54', '3', '2020-09-10 17:02:54', null, '');
INSERT INTO `c_auth_menu` VALUES ('1362960926927486976', '仓储管理', '用于管理仓库', '\0', '/wms', 'zuihou/wms/Index', '', '4', 'el-icon-s-home', '', '0', '3', '2021-02-20 11:03:02', '3', '2021-02-20 11:03:02', null, '');
INSERT INTO `c_auth_menu` VALUES ('1362961009668521984', '仓储管理', '', '\0', '/wms', 'zuihou/wms/Index', '', '4', 'el-icon-s-home', '', '0', '3', '2021-02-20 11:03:22', '3', '2021-02-20 11:03:22', null, '');
INSERT INTO `c_auth_menu` VALUES ('1362962049147076608', '仓储管理', '', '\0', '/wms', 'zuihou/wms/Index', '', '4', 'el-icon-s-home', '', '0', '3', '2021-02-20 11:07:30', '3', '2021-02-20 11:07:30', null, '');
INSERT INTO `c_auth_menu` VALUES ('1362963199929876480', '仓储管理', '', '\0', '/wms', 'zuihou/wms/Index', '', '0', 'el-icon-s-home', '', '0', '3', '2021-02-20 11:12:04', '3', '2021-02-20 11:12:04', null, '');
INSERT INTO `c_auth_menu` VALUES ('1362963201062338560', '仓储管理', '', '\0', '/wms', 'zuihou/wms/Index', '', '0', 'el-icon-s-home', '', '0', '3', '2021-02-20 11:12:04', '3', '2021-02-20 11:12:04', null, '');
INSERT INTO `c_auth_menu` VALUES ('1471647810083356672', '调度对话记录', '', '\0', '/dispatchRecord', 'zuihou/dispatchRecord/Index', '', '8', 'el-icon-notebook-1', '', '0', '3', '2021-12-17 09:05:54', '3', '2021-12-17 09:05:54', null, '');
