programs_info/无锡市生命线项目/数据库备份/删除前备份/frame_permission测试更新到政务前备份.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 政务网生命线(mysql)2.21.138.148
 Source Server Type    : MySQL
 Source Server Version : 50743
 Source Host           : 2.21.138.148:3306
 Source Schema         : lifeline

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

 Date: 15/01/2024 09:59:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for frame_permission
-- ----------------------------
DROP TABLE IF EXISTS `frame_permission`;
CREATE TABLE `frame_permission`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限描述',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权链接',
  `pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父节点id',
  `perms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
  `type` int(11) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of frame_permission
-- ----------------------------
INSERT INTO `frame_permission` VALUES ('1', '所有功能', NULL, NULL, '0', NULL, 0, 'fa fa-home', 1);
INSERT INTO `frame_permission` VALUES ('1034894671920234496', '机构类型', NULL, 'deptAttr', '666134442716168192', '/system/deptAttr', 1, 'clipboard', 3);
INSERT INTO `frame_permission` VALUES ('1161695706486931456', '社会公众服务', NULL, 'socialPublic', '1', '', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1161696587370463232', '通知公告', NULL, 'notice', '1161695706486931456', '/socialPublic/notice', 1, '', 1);
INSERT INTO `frame_permission` VALUES ('1163489156496621568', '群众反馈', NULL, 'feedback', '1161695706486931456', '/socialPublic/feedback', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1163489903107899392', '安全培训', NULL, 'training', '1161695706486931456', '/socialPublic/training', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1163490001057480704', '案例分析', NULL, 'case', '1161695706486931456', '/socialPublic/case', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1166375199440896000', '大屏入口设置', NULL, 'thirdPartyLayer', '826724306569396224', '/thirdPartyStage/thirdPartyLayerIdex', 1, 'edit', 8);
INSERT INTO `frame_permission` VALUES ('1166375699792003072', '首页入口设置', NULL, 'thirdPartyStage', '826724306569396224', '/thirdPartyStage/thirdPartyStageRouteIndex', 1, 'drag', 9);
INSERT INTO `frame_permission` VALUES ('1166669453010665472', '视频设置管理', NULL, 'videoSet', '826724306569396224', '/platform/videoSet', 1, 'tab', 10);
INSERT INTO `frame_permission` VALUES ('1166741659321368576', '标签管理', NULL, 'companyTagManage', '826724306569396224', '/system/companyTagManage', 1, 'edit', 11);
INSERT INTO `frame_permission` VALUES ('1167909737128263680', '行业监督管理', NULL, 'industrySupervision', '1', '', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1167910274296971264', '行业通告', NULL, 'report', '1167909737128263680', '/industrySupervision/report', 1, '', 1);
INSERT INTO `frame_permission` VALUES ('1167910614555688960', '规划建设', NULL, 'plan', '1167909737128263680', '/industrySupervision/plan', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1167910782709530624', '督查督办', NULL, 'supervise', '1167909737128263680', '/industrySupervision/supervise', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1167910903434182656', '行业评价', NULL, 'evaluate', '1167909737128263680', '/industrySupervision/evaluate', 1, '', 8);
INSERT INTO `frame_permission` VALUES ('1167911488178880512', '应急知识管理', NULL, 'knowledge-all', '1186680736862699520', '/industrySupervision/knowledge-all', 1, '', 6);
INSERT INTO `frame_permission` VALUES ('1168626290048106496', '巡检巡查', NULL, 'patrol', '1167909737128263680', '/industrySupervision/patrol', 1, '', 6);
INSERT INTO `frame_permission` VALUES ('1168683919394996224', '隐患档案', NULL, 'pitfall', '1167909737128263680', '/archives/pitfall', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1169008159491096576', '运行维护管理', NULL, 'operationMaintain', '1', '', 1, '', 5);
INSERT INTO `frame_permission` VALUES ('1169009107768705024', '设备资产管理', NULL, 'monitorNew', '1169008159491096576', '/statisticAnalysis/monitorNew', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1169009300358561792', '设备绩效评价', NULL, 'performance', '1169008159491096576', '/operationMaintain/performance', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1169009422186315776', '平台手册', NULL, 'platform', '1169008159491096576', '/operationMaintain/platform', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1186610637514473472', '基础台账', NULL, 'statisticAnalysis', '1', '', 1, 'pdf', 1);
INSERT INTO `frame_permission` VALUES ('1186611060677804032', '基础设施', NULL, 'base', '1186610637514473472', '/statisticAnalysis/base', 1, 'edit', 1);
INSERT INTO `frame_permission` VALUES ('1186672790200123392', '事件档案', NULL, 'event', '1167909737128263680', '/archives/event', 1, '', 5);
INSERT INTO `frame_permission` VALUES ('1186673042646892544', '风险评估', NULL, 'risk', '1167909737128263680', '/archives/risk', 1, '', 7);
INSERT INTO `frame_permission` VALUES ('1186680269994721280', '监测设备', NULL, 'monitor', '1186610637514473472', '/statisticAnalysis/monitor', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1186680400605347840', '监测点', NULL, 'point', '1186610637514473472', '/statisticAnalysis/point', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1186680559296839680', '隐患报警', NULL, 'danger', '1186610637514473472', '/statisticAnalysis/danger', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1186680641756856320', '突发事件', NULL, 'burst', '1186610637514473472', '/statisticAnalysis/burst', 1, '', 5);
INSERT INTO `frame_permission` VALUES ('1186680736862699520', '应急联动处置', NULL, 'emergency', '1', '', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1186680940177391616', '交班日志', NULL, 'guard', '1186680736862699520', '/emergency/guard', 1, '', 1);
INSERT INTO `frame_permission` VALUES ('1186681067868782592', '预警管理', NULL, 'warn', '1186680736862699520', '/emergency/warn', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1186681227352997888', '联动协调', NULL, 'linkage', '1186680736862699520', '/emergency/linkage', 1, '', 3);
INSERT INTO `frame_permission` VALUES ('1186681323926847488', '应急资源', NULL, 'resource', '1186680736862699520', '/emergency/resource', 1, '', 4);
INSERT INTO `frame_permission` VALUES ('1186681408500793344', '应急专家', NULL, 'expert', '1186680736862699520', '/emergency/expert', 1, '', 5);
INSERT INTO `frame_permission` VALUES ('1186681845945729024', '重大危险源', NULL, 'dangerous', '1186680736862699520', '/emergency/dangerous', 1, '', 6);
INSERT INTO `frame_permission` VALUES ('1186681974740221952', '联动通讯录', NULL, 'personnel', '1186680736862699520', '/archives/personnel', 1, '', 8);
INSERT INTO `frame_permission` VALUES ('1186682169183961088', '主管运营单位', NULL, 'index', '1167909737128263680', '/management/index', 1, '', 10);
INSERT INTO `frame_permission` VALUES ('1186682322406080512', '值排班管理', NULL, 'duty', '1169008159491096576', '/duty/index', 1, '', 1);
INSERT INTO `frame_permission` VALUES ('1186682479394684928', '工单管理', NULL, 'workorder', '1169008159491096576', '/duty/workorder', 1, '', 2);
INSERT INTO `frame_permission` VALUES ('1187741745077551104', '燃气风险', NULL, 'ranqiFengxian', '1186610637514473472', '/statisticAnalysis/ranqiFengxian', 1, '', 15);
INSERT INTO `frame_permission` VALUES ('1187767019726962688', '桥梁风险', NULL, 'qiaoliangFengxian', '1186610637514473472', '/statisticAnalysis/qiaoliangFengxian', 1, '', 7);
INSERT INTO `frame_permission` VALUES ('1187767243669241856', '道路风险', NULL, 'daoluFengxian', '1186610637514473472', '/statisticAnalysis/daoluFengxian', 1, '', 8);
INSERT INTO `frame_permission` VALUES ('1187767448871370752', '供水风险', NULL, 'gongshuiFengxian', '1186610637514473472', '/statisticAnalysis/gongshuiFengxian', 1, '', 16);
INSERT INTO `frame_permission` VALUES ('1187767726668513280', '排水雨水风险', NULL, 'paishuiYuShuiFengxian', '1186610637514473472', '/statisticAnalysis/paishuiYuShuiFengxian', 1, '', 10);
INSERT INTO `frame_permission` VALUES ('1187767895510220800', '排水易涝点风险', NULL, 'paishuiYiLaoDianFengxian', '1186610637514473472', '/statisticAnalysis/paishuiYiLaoDianFengxian', 1, '', 11);
INSERT INTO `frame_permission` VALUES ('1188531920963633152', '行业资料库', NULL, 'data', '1167909737128263680', '/industrySupervision/data', 1, '', 9);
INSERT INTO `frame_permission` VALUES ('666132060531851264', '运营商管理', NULL, 'manageBiz', '666131946182541312', '/biz/main', 1, 'peoples', 1);
INSERT INTO `frame_permission` VALUES ('666132212621508608', '运营商用户', NULL, 'user', '666131946182541312', '/biz/user', 1, 'tree-table', 2);
INSERT INTO `frame_permission` VALUES ('666134442716168192', '平台管理', NULL, 'sys', '1', '', 1, 'component', 15);
INSERT INTO `frame_permission` VALUES ('666134530431647744', '人员管理', NULL, 'user', '666134442716168192', '/system/user', 1, 'user', 1);
INSERT INTO `frame_permission` VALUES ('666134649822511104', '菜单管理', NULL, 'menu', '666134442716168192', '/system/menu', 1, 'tree-table', 2);
INSERT INTO `frame_permission` VALUES ('666134766948450304', '菜单角色', NULL, 'role', '666134442716168192', '/system/role', 1, 'size', 4);
INSERT INTO `frame_permission` VALUES ('666134847483281408', '字典管理', NULL, 'dict', '666134442716168192', '/system/dict', 1, 'education', 3);
INSERT INTO `frame_permission` VALUES ('666134977427013632', '参数管理', NULL, 'param', '666134442716168192', '/system/param', 1, 'skill', 4);
INSERT INTO `frame_permission` VALUES ('674737708815351808', '页面生成', NULL, 'gen', '666134442716168192', '/system/generate', 1, 'documentation', 10);
INSERT INTO `frame_permission` VALUES ('684206133207891968', '首页链接', NULL, 'homeLink', '666134442716168192', '/system/homeLink', 1, 'guide', 9);
INSERT INTO `frame_permission` VALUES ('687290634918166528', '组织机构', NULL, 'dept', '666134442716168192', '/system/department', 1, 'peoples', 2);
INSERT INTO `frame_permission` VALUES ('752485500048113664', '学生管理（示例）', NULL, 'demoStudent', '752485235391725568', '/demo/demoStudent', 1, 'edit', 1);
INSERT INTO `frame_permission` VALUES ('755949565307256832', '权限角色', NULL, 'roleData', '666134442716168192', '/system/roleData', 1, 'skill', 5);
INSERT INTO `frame_permission` VALUES ('760548543604719616', '岗位管理', NULL, 'post', '666134442716168192', '/system/post', 1, 'tree', 3);
INSERT INTO `frame_permission` VALUES ('811292552622768128', '集团管理', NULL, 'group', '666134442716168192', '/system/group', 1, 'tree', 2);
INSERT INTO `frame_permission` VALUES ('826724306569396224', '系统设置', NULL, 'config', '1', '', 1, 'table', 14);
INSERT INTO `frame_permission` VALUES ('860168275395346432', '班级管理（从库示例）', NULL, 'demoClass', '752485235391725568', '/demo/demoClass', 1, 'edit', 2);
INSERT INTO `frame_permission` VALUES ('931517048440225792', '服务器管理', NULL, 'server', '931516921113739264', '/ops/server', 1, 'table', 1);
INSERT INTO `frame_permission` VALUES ('993179453590863872', '操作日志', NULL, 'opLog', '666134442716168192', '/system/opLog', 1, 'edit', 10);
INSERT INTO `frame_permission` VALUES ('993251044437786624', '工作日设定', NULL, 'holiday', '666134442716168192', '/system/holiday', 1, 'skill', 7);

SET FOREIGN_KEY_CHECKS = 1;