ホーム エクスプローラ ヘルプ
登録 サインイン
lxb
/
331_imcs
1
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 89103b9eb6
ブランチ タグ
331_imcs
/
doc
/
部署相关文件
/
c_auth_menu_0000.sql

c_auth_menu_0000.sql 16 KB
履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 192.168.170.22
    5. 

  5. Source Server Version : 80027
    6. 

  6. Source Host           : 192.168.170.22:3306
    7. 

  7. Source Database       : zuihou_base_yj_0000
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 80027
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2022-01-12 10:53:05
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

  18. -- ----------------------------
    19. 

  19. -- Table structure for c_auth_menu
    20. 

  20. -- ----------------------------
    21. 

  21. DROP TABLE IF EXISTS `c_auth_menu`;
    22. 

  22. CREATE TABLE `c_auth_menu` (
    23. 

  23.   `id` bigint NOT NULL COMMENT '主键',
    24. 

  24.   `label` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
    25. 

  25.   `describe_` varchar(200) DEFAULT '' COMMENT '描述',
    26. 

  26.   `is_public` bit(1) DEFAULT b'0' COMMENT '公共菜单\nTrue是无需分配所有人就可以访问的',
    27. 

  27.   `path` varchar(255) DEFAULT '' COMMENT '路径',
    28. 

  28.   `component` varchar(255) DEFAULT NULL COMMENT '组件',
    29. 

  29.   `is_enable` bit(1) DEFAULT b'1' COMMENT '状态',
    30. 

  30.   `sort_value` int DEFAULT '1' COMMENT '排序',
    31. 

  31.   `icon` varchar(255) DEFAULT '' COMMENT '菜单图标',
    32. 

  32.   `group_` varchar(20) DEFAULT '' COMMENT '分组',
    33. 

  33.   `parent_id` bigint DEFAULT '0' COMMENT '父级菜单ID',
    34. 

  34.   `create_user` bigint DEFAULT NULL COMMENT '创建人id',
    35. 

  35.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    36. 

  36.   `update_user` bigint DEFAULT NULL COMMENT '更新人id',
    37. 

  37.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    38. 

  38.   `name` varchar(200) DEFAULT NULL,
    39. 

  39.   `no_cache` bit(1) DEFAULT b'1' COMMENT '是否缓存',
    40. 

  40.   PRIMARY KEY (`id`) USING BTREE
    41. 

  41. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单';
    42. 

  42. 

  43. -- ----------------------------
    44. 

  44. -- Records of c_auth_menu
    45. 

  45. -- ----------------------------
    46. 

  46. 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, '');
    47. 

  47. 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, '');
    48. 

  48. 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, '');
    49. 

  49. 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, '');
    50. 

  50. 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, '');
    51. 

  51. 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, '');
    52. 

  52. 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, '');
    53. 

  53. 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, '');
    54. 

  54. 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, '');
    55. 

  55. 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, '');
    56. 

  56. 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, '');
    57. 

  57. 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, '');
    58. 

  58. INSERT INTO `c_auth_menu` VALUES ('4769114505659500', '菜单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, '');
    59. 

  59. 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, '');
    60. 

  60. 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, '');
    61. 

  61. 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, '');
    62. 

  62. 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, '');
    63. 

  63. 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, '');
    64. 

  64. 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, '');
    65. 

  65. 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, '');
    66. 

  66. 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, '');
    67. 

  67. 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, '');
    68. 

  68. 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, '');
    69. 

  69. 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, '');
    70. 

  70. 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, '');
    71. 

  71. 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, '');
    72. 

  72. 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, '');
    73. 

  73. 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, '');
    74. 

  74. 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, '');
    75. 

  75. 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, '');
    76. 

  76. 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, '');
    77. 

  77. 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, '');
    78. 

  78. 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, '');
    79. 

  79. 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, '');
    80. 

  80. 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, '');
    81. 

  81. 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, '');
    82. 

  82. 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, '');
    83. 

  83. 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, '');
    84. 

  84. 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, '');
    85. 

  85. 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, '');
    86. 

  86. 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, '');
    87. 

  87. 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, '');
    88. 

  88. 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, '');
    89. 

  89. 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, '');
    90. 

  90. 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, '');
    91. 

  91. 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, '');
    92. 

  92. 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, '');
    93. 

  93. 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, '');
    94. 

  94. 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, '');
    95. 

  95. 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, '');
    96. 

  96. 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, '');
    97. 

  97. 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, '');
    98. 

  98. 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, '');
    99. 

  99. 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, '');
    100. 

  100. 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, '');
    101. 

  101. 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, '');
    102. 

  102. 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, '');
    103. 

  103. 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, '');
    104. 

  104. 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, '');
    105. 

  105. 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, '');
    106. 

  106. 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, '');
    107. 

  107. 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, '');
    108. 

  108. 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, '');
    109.