صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
lxb
/
chf_imcs
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
شاخه: master
شاخه‌ها تگ‌ها
chf_imcs
/
doc
/
部署相关文件
/
c_auth_menu.sql

c_auth_menu.sql 8.8 KB
لینک دائمی تاريخچه خام

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 
  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_defaults_yj
    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:52:30
    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 COMMENT '前端页面路由',
    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 ROW_FORMAT=DYNAMIC COMMENT='菜单';
    42. 

  42. 

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

  44. -- Records of c_auth_menu
    45. 

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

  46. INSERT INTO `c_auth_menu` VALUES ('104', '企业中心', '开发者', '\0', '/enterpriseMgr', 'enterpriseMgr/Index', '', '4', 'el-icon-user-solid', '', '0', '1', '2019-11-11 14:38:34', '3', '2020-10-11 21:57:55', null, '');
    47. 

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

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

  49. INSERT INTO `c_auth_menu` VALUES ('113', '企业分类', '', '\0', '/enterpriseMgr/enterpriseType', 'zuihou/enterpriseMgr/enterpriseType/Index', '', '2', '', '', '104', '3', '2020-10-12 14:44:33', '3', '2020-10-12 15:41:26', null, '');
    50. 

  50. INSERT INTO `c_auth_menu` VALUES ('114', '企业角色管理', '', '\0', '/enterpriseMgr/enterpriseRole', 'zuihou/enterpriseMgr/enterpriseRole/Index', '', '3', '', '', '104', '3', '2020-10-12 14:49:50', '3', '2020-10-14 13:28:35', null, '');
    51. 

  51. INSERT INTO `c_auth_menu` VALUES ('115', '功能权限更改日志', '', '\0', '/enterpriseMgr/permissionLog', 'zuihou/enterpriseMgr/permissionLog/Index', '', '4', '', '', '104', '3', '2020-10-12 14:50:46', '3', '2020-10-14 13:28:48', null, '');
    52. 

  52. INSERT INTO `c_auth_menu` VALUES ('116', '企业菜单规则', '', '\0', '/enterpriseMgr/menuRules', 'zuihou/enterpriseMgr/menuRules/Index', '', '5', '', '', '104', '3', '2020-10-12 14:51:42', '3', '2020-10-14 13:28:40', null, '');
    53. 

  53. INSERT INTO `c_auth_menu` VALUES ('117', '互联中心', '', '\0', '/internetCenter', 'zuihou/internetCenter/Index', '', '14', 'el-icon-odometer', '', '0', '3', '2020-10-12 14:53:07', '3', '2020-10-12 19:45:18', null, '');
    54. 

  54. INSERT INTO `c_auth_menu` VALUES ('118', '模型管理', '', '\0', '/internetCenter/moduleMgr', 'zuihou/internetCenter/moduleMgr/Index', '', '1', '', '', '117', '3', '2020-10-12 14:55:08', '3', '2020-10-12 20:06:20', null, '');
    55. 

  55. INSERT INTO `c_auth_menu` VALUES ('119', '生产资源', '', '\0', '/internetCenter/productionResourcesMgr', 'zuihou/internetCenter/productionResourcesMgr/Index', '', '2', '', '', '117', '3', '2020-10-12 14:56:10', '3', '2020-10-12 19:47:06', null, '');
    56. 

  56. INSERT INTO `c_auth_menu` VALUES ('120', '通信协议管理', '', '\0', '/internetCenter/communicationProtocol', 'zuihou/internetCenter/communicationProtocol/Index', '', '3', '', '', '117', '3', '2020-10-12 14:56:10', '3', '2020-10-16 11:22:52', null, '');
    57. 

  57. INSERT INTO `c_auth_menu` VALUES ('121', '数据中心', '', '\0', '/internetCenter/dataCenter', 'zuihou/internetCenter/dataCenter/Index', '', '4', '', '', '117', '3', '2020-10-12 14:56:10', '3', '2020-10-16 13:31:19', null, '');
    58. 

  58. INSERT INTO `c_auth_menu` VALUES ('122', '第三方接口中心', '', '\0', '/interfaceCenter', 'zuihou/interfaceCenter/Index', '', '15', 'el-icon-place', '', '0', '3', '2020-10-12 14:53:07', '3', '2020-10-15 09:05:22', null, '');
    59. 

  59. INSERT INTO `c_auth_menu` VALUES ('123', '模型管理', '', '\0', '/interfaceCenter/moduleMgr', 'zuihou/interfaceCenter/moduleMgr/Index', '', '1', '', '', '122', '3', '2020-10-12 14:56:10', '3', '2020-10-15 09:06:53', null, '');
    60. 

  60. INSERT INTO `c_auth_menu` VALUES ('124', '接口实例管理', '', '\0', '/interfaceCenter/interfaceInstanceMgr', 'zuihou/interfaceCenter/interfaceInstanceMgr/Index', '', '2', '', '', '122', '3', '2020-10-12 14:56:10', '3', '2020-10-15 09:08:31', null, '');
    61. 

  61. INSERT INTO `c_auth_menu` VALUES ('125', '可视化面板中心', '', '\0', '/ksh', 'zuihou/ksh/Index', '', '16', 'el-icon-eleme', '', '0', '3', '2020-10-12 14:53:07', '3', '2020-10-12 22:38:33', null, '');
    62. 

  62. INSERT INTO `c_auth_menu` VALUES ('126', '企业产线仿真管理', '', '\0', '/fzgl', 'zuihou/fzgl/Index', '', '1', '', '', '125', '3', '2020-10-12 14:56:10', '3', '2020-10-12 22:38:45', null, '');
    63. 

  63. INSERT INTO `c_auth_menu` VALUES ('127', '组件管理', '', '\0', '/zjgl', 'zuihou/zjgl/Index', '', '2', '', '', '125', '3', '2020-10-12 14:56:10', '3', '2020-10-12 22:38:55', null, '');
    64. 

  64. INSERT INTO `c_auth_menu` VALUES ('128', '系统管理', '', '\0', '/systemMgr', 'zuihou/systemMgr/Index', '', '17', 'el-icon-set-up', '', '0', '3', '2020-10-12 14:53:07', '3', '2020-10-29 14:00:08', null, '');
    65. 

  65. INSERT INTO `c_auth_menu` VALUES ('129', '配置管理', '', '\0', '/base/parameter', 'zuihou/base/parameter/Index', '', '5', '', '', '128', '3', '2020-10-12 14:56:10', null, null, null, '');
    66. 

  66. INSERT INTO `c_auth_menu` VALUES ('130', '部门管理', '', '\0', '/user/org', 'zuihou/user/org/Index', '', '7', '', '', '128', '3', '2020-10-13 14:20:44', null, null, null, '');
    67. 

  67. INSERT INTO `c_auth_menu` VALUES ('131', '登录日志', '', '\0', '/developer/loginLog', 'zuihou/developer/loginLog/Index', '', '4', '', '', '105', '3', '2019-11-16 10:54:59', '3', '2019-11-16 10:54:59', null, '');
    68. 

  68. INSERT INTO `c_auth_menu` VALUES ('603976297063910529', '菜单管理', '', '\0', '/auth/menu', 'zuihou/auth/menu/Index', '', '0', '', '', '128', '1', '2019-07-25 15:46:11', '3', '2019-11-11 14:31:52', null, '');
    69. 

  69. INSERT INTO `c_auth_menu` VALUES ('603981723864141121', '角色管理', '', '\0', '/auth/role', 'zuihou/auth/role/Index', '', '1', '', '', '128', '1', '2019-07-25 16:07:45', '3', '2019-11-11 14:31:57', null, '');
    70. 

  70. INSERT INTO `c_auth_menu` VALUES ('603982713849908801', '岗位管理', '', '\0', '/user/station', 'zuihou/user/station/Index', '', '6', '', '', '128', '3', '2019-07-25 16:11:41', '3', '2019-11-11 14:28:43', null, '');
    71. 

  71. INSERT INTO `c_auth_menu` VALUES ('603983082961243905', '用户管理', '', '\0', '/user/user', 'zuihou/user/user/Index', '', '2', '', '', '128', '1', '2019-07-25 16:13:09', '3', '2019-11-11 14:28:49', null, '');
    72. 

  72. INSERT INTO `c_auth_menu` VALUES ('605078371293987105', '字典管理', '', '\0', '/base/dict', 'zuihou/base/dict/Index', '', '0', '', '', '128', '1', '2019-07-28 16:45:26', '3', '2019-11-11 14:34:23', null, '');
    73. 

  73. INSERT INTO `c_auth_menu` VALUES ('605078371293987106', '编码规则', '', '\0', '/systemMgr/codeStandard', 'zuihou/systemMgr/codeStandard/Index', '', '0', '', '', '128', '1', '2019-07-28 16:45:26', '3', '2020-10-29 16:31:11', null, '');
    74. 

  74. INSERT INTO `c_auth_menu` VALUES ('605078672772170209', '操作日志', '', '\0', '/developer/optLog', 'zuihou/developer/optLog/Index', '', '3', '', '', '105', '1', '2019-07-28 16:46:38', '3', '2019-11-11 14:35:14', null, '');
    75. 

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

  76. INSERT INTO `c_auth_menu` VALUES ('645215230518909025', '企业管理', '', '\0', '/enterpriseMgr/enterpriseMgr', 'zuihou/enterpriseMgr/enterpriseMgr/Index', '', '1', '', '', '104', '3', '2019-11-16 10:54:59', '3', '2020-10-11 22:00:44', null, '');
    77. 

  77. INSERT INTO `c_auth_menu` VALUES ('1334305029317722112', '资源品牌规格管理', '', '\0', '/internetCenter/brandSpecifications', 'zuihou/internetCenter/brandSpecifications/Index', '', '5', '', '', '117', '3', '2020-12-03 09:14:43', '3', '2020-12-03 09:15:52', null, '');
    78.