xps-server-jyprj/xps-doc/db/s_menu.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 134.175.84.106
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : 134.175.84.106:3306
 Source Schema         : paxy

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 21/06/2022 10:25:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for s_menu
-- ----------------------------
DROP TABLE IF EXISTS `s_menu`;
CREATE TABLE `s_menu`  (
  `menu_id` bigint(20) NOT NULL,
  `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_css` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_type` bigint(11) NULL DEFAULT NULL,
  `menu_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `menu_level` bigint(11) NULL DEFAULT NULL,
  `parent_id` bigint(11) NULL DEFAULT NULL,
  `root_id` bigint(11) NULL DEFAULT NULL,
  `sort_no` bigint(11) NULL DEFAULT NULL,
  `is_home` bigint(11) NULL DEFAULT 0,
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of s_menu
-- ----------------------------
INSERT INTO `s_menu` VALUES (100, 'system_dashboard', '我的工作台', 'icon-common_organization', 'system_dashboard', NULL, NULL, 1, '', 1, 0, 100, 10, 1);
INSERT INTO `s_menu` VALUES (300, 'company', '组织管理', 'icon-common_organization', 'company', NULL, NULL, 0, '', 1, 0, 300, 30, 0);
INSERT INTO `s_menu` VALUES (301, 'company_profile', '公司信息', '', 'company_profile', NULL, NULL, 1, '', 2, 300, 300, 1, 0);
INSERT INTO `s_menu` VALUES (302, 'company_user', '组织管理', '', 'company_user', NULL, NULL, 1, 'ddddd', 2, 300, 300, 2, 0);
INSERT INTO `s_menu` VALUES (303, 'company_position', '岗位管理', '', 'company_position', NULL, NULL, 1, '', 2, 300, 300, 4, 0);
INSERT INTO `s_menu` VALUES (400, 'authority', '权限管理', 'icon-common_organization', 'authority', NULL, NULL, 0, '', 1, 0, 400, 40, 0);
INSERT INTO `s_menu` VALUES (401, 'authority_role', '角色权限', '', 'authority_role', NULL, NULL, 1, '', 2, 400, 400, 1, 0);
INSERT INTO `s_menu` VALUES (402, 'authority_menu', '岗位权限', '', 'authority_position', NULL, NULL, 1, '', 2, 400, 400, 2, 0);
INSERT INTO `s_menu` VALUES (450, 'workflow', '流程管理', 'icon-common_organization', 'workflow', NULL, NULL, 1, '', 1, 0, 450, 45, 0);
INSERT INTO `s_menu` VALUES (451, 'workflow_def', '流程定义', '', 'workflow_def', NULL, NULL, 1, '', 2, 450, 450, 1, 0);
INSERT INTO `s_menu` VALUES (452, 'workflow_ins', '流程实例', '', 'workflow_ins', NULL, NULL, 1, '', 2, 450, 450, 2, 0);
INSERT INTO `s_menu` VALUES (453, 'workflow_example', '流程示例', '', 'workflow_example', NULL, NULL, 1, '', 2, 450, 450, 3, 0);
INSERT INTO `s_menu` VALUES (500, 'customer', '客户管理', 'icon-common_organization', 'customer', NULL, NULL, 0, '', 1, 0, 500, 50, 0);
INSERT INTO `s_menu` VALUES (501, 'customer_ent', '生产经营单位', '', 'customer_ent', NULL, NULL, 1, '', 2, 500, 500, 1, 0);
INSERT INTO `s_menu` VALUES (502, 'customer_org', '政府机构', '', 'customer_org', NULL, NULL, 1, '', 2, 500, 500, 2, 0);
INSERT INTO `s_menu` VALUES (503, 'customer_partner', '合作伙伴', '', 'customer_partner', NULL, NULL, 1, '', 2, 500, 500, 3, 0);
INSERT INTO `s_menu` VALUES (600, 'industry', '行业管理', 'icon-common_organization', 'industry', NULL, NULL, 0, '', 1, 0, 600, 60, 0);
INSERT INTO `s_menu` VALUES (601, 'industry_manage', '行业管理', '', 'industry_manage', '', NULL, 1, '', 2, 600, 600, 1, 0);
INSERT INTO `s_menu` VALUES (650, 'kms', '行业智库', 'icon-common_organization', 'kms', '/kms/index', NULL, 0, '', 1, 0, 650, 65, 0);
INSERT INTO `s_menu` VALUES (651, 'kms_checklist', '清单管理', '', 'kms_checklist', '', NULL, 1, '', 2, 650, 650, 1, 0);
INSERT INTO `s_menu` VALUES (652, 'kms_art', '内容管理', '', 'kms_art', '', NULL, 1, '', 2, 650, 650, 2, 0);
INSERT INTO `s_menu` VALUES (653, 'kms_doc', '文件管理', '', 'kms_doc', '', NULL, 1, '', 2, 650, 650, 3, 0);
INSERT INTO `s_menu` VALUES (654, 'kms_manage', '智库管理', '', 'kms_manage', '', NULL, 1, '', 2, 650, 650, 4, 0);
INSERT INTO `s_menu` VALUES (700, 'system_setting', '系统配置', 'icon-common_organization', 'system_setting', '/system/config/groupCat', NULL, 0, '', 1, 0, 700, 70, 0);
INSERT INTO `s_menu` VALUES (701, 'setting_ent_cat', '企业类别', '', 'system_setting_ent_cat', '', NULL, 1, '', 2, 700, 700, 1, 0);
INSERT INTO `s_menu` VALUES (702, 'setting_org_cat', '机构类别', '', 'system_setting_org_cat', '', NULL, 1, '', 2, 700, 700, 2, 0);
INSERT INTO `s_menu` VALUES (703, 'setting_partner_cat', '合作伙伴分类', '', 'system_setting_partner_cat', '', NULL, 1, '', 2, 700, 700, 3, 0);
INSERT INTO `s_menu` VALUES (704, 'setting_group_cat', '群组类别', '', 'system_setting_group_cat', '', NULL, 1, '', 2, 700, 700, 4, 0);
INSERT INTO `s_menu` VALUES (705, 'setting_task_cat', '任务类别', '', 'system_setting_task_cat', '', NULL, 1, '', 2, 700, 700, 5, 0);
INSERT INTO `s_menu` VALUES (706, 'setting_measure_type', '措施类别', '', 'system_setting_measure_type', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (707, 'setting_alert_type', '预警类别', '', 'system_setting_alert_type', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (708, 'system_setting_app_cat', '应用类别', '', 'system_setting_app_cat', '', '', NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (800, 'job', '作业管理', 'icon-common_organization', 'job', '/job/index', NULL, 0, '', 1, 0, 800, 80, 0);
INSERT INTO `s_menu` VALUES (801, 'job_def', '系统作业', '', 'job_def', '', NULL, 1, '', 2, 800, 800, 1, 0);
INSERT INTO `s_menu` VALUES (802, 'job_trigger', '作业触发器', '', 'job_trigger', '', NULL, 1, '', 2, 800, 800, 2, 0);
INSERT INTO `s_menu` VALUES (803, 'job_schedule', '作业调度', '', 'job_schedule', '', NULL, 1, '', 2, 800, 800, 3, 0);
INSERT INTO `s_menu` VALUES (900, 'app_center', '应用中心', 'icon-common_organization', 'app', '/app/index', NULL, 0, '', 1, 0, 900, 90, 0);
INSERT INTO `s_menu` VALUES (901, 'app_manage', '应用管理', '', 'app_manage', '', NULL, 1, '', 2, 900, 900, 1, 0);
INSERT INTO `s_menu` VALUES (902, 'app_cat', '应用类别', '', 'app_cat', '', NULL, 1, '', 2, 900, 900, 2, 0);
INSERT INTO `s_menu` VALUES (903, 'app_permit', '应用授权', '', 'app_permit', '', NULL, 1, '', 2, 900, 900, 3, 0);
INSERT INTO `s_menu` VALUES (1000, 'ent_panorama', '数字全景', '', 'ent_panorama', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1001, 'ent_alert_center', '预警中心', '', 'ent_alert_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1002, 'ent_workplace', '我的工作台', '', 'ent_workplace', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1003, 'ent_visualize', '可视化管理', '', 'ent_visualize', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1004, 'ent_monitor_center', '监控中心', '', 'ent_monitor_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1100, 'ent_app_center', '应用中心', '', 'ent_app_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1200, 'ent_management', '管理体系', '', 'ent_management', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1201, 'ent_management_leading_group', '领导小组', '', 'ent_management_leading_group', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1202, 'ent_management_regulation', '制度规范', '', 'ent_management_regulation', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1203, 'ent_management_hazard', '危险源库', '', 'ent_management_hazard', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1204, 'ent_management_checklist', '检查清单', '', 'ent_management_checklist', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1260, 'ent_scene', '网格化管理', '', 'ent_scene', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1261, 'ent_scene_grid', '网格', '', 'ent_scene_grid', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1262, 'ent_scene_riskpoint', '风险点', '', 'ent_scene_riskpoint', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1263, 'ent_scene_map', '地图', '', 'ent_scene_map', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1300, 'ent_task_center', '任务中心', '', 'ent_task_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1301, 'ent_task_plan', '任务计划', '', 'ent_task_plan', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1302, 'ent_task_manage', '任务管理', '', 'ent_task_manage', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1303, 'ent_task_record', '检查记录', '', 'ent_task_record', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1400, 'ent_danger', '隐患管理', '', 'ent_danger', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1450, 'ent_equipment', '设备中心', '', 'ent_equipment', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1480, 'ent_report_center', '台帐中心', '', 'ent_report', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1500, 'ent_file_center', '文件中心', '', 'ent_file_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1600, 'ent_art_center', '知识库', '', 'ent_art_center', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1800, 'ent_org_setting', '组织管理', '', 'ent_org_setting', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1801, 'ent_profile', '公司信息', '', 'ent_profile', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1802, 'ent_group_user', '组织人员', '', 'ent_group_user', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1803, 'ent_position', '岗位管理', '', 'ent_position', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1900, 'ent_setting', '系统配置', '', 'ent_setting', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1901, 'ent_setting_group_cat', '部门类别', '', 'ent_setting_group_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1902, 'ent_setting_task_cat', '任务类别', '', 'ent_setting_task_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1903, 'ent_setting_checklist_cat', '清单类别', '', 'ent_setting_checklist_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1904, 'ent_setting_riskpoint_cat', '风险点类别', '', 'ent_setting_riskpoint_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1905, 'ent_setting_ctrl_level', '风险管控层级', '', 'ent_setting_ctrl_level', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1906, 'ent_setting_danger_cat', '隐患类别', '', 'ent_setting_danger_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1907, 'ent_setting_equipment_cat', '设备类别', '', 'ent_setting_equipment_cat', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `s_menu` VALUES (1908, 'ent_setting_ctrl_level', '管控层级', '', 'ent_setting_ctrl_level', '', NULL, NULL, '', NULL, NULL, NULL, NULL, 0);

SET FOREIGN_KEY_CHECKS = 1;