programs_info/微纳园_山水城综合管理平台/山水城信息/备份/frame_permission测试的2024年3月5日.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 1_山水城数据正式221.229.219.234
 Source Server Type    : MySQL
 Source Server Version : 50716
 Source Host           : 221.229.219.234:3306
 Source Schema         : idea_micronano_park

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

 Date: 05/03/2024 09:47:13
*/

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 '权限名称',
  `descripion` 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, '0', NULL, 0, 'fa fa-home', 1);
INSERT INTO `frame_permission` VALUES ('1038907581176741888', '园区进出台账', NULL, 'mnpRecord', '1038907362670280704', '/mnp/mnpRecord', 1, 'list', 7);
INSERT INTO `frame_permission` VALUES ('1038909969010786304', '疑似异常人员', NULL, 'mnpWarn', '1038907362670280704', '/mnp/mnpWarn', 1, 'peoples', 8);
INSERT INTO `frame_permission` VALUES ('1039107086178320384', '园区企业管理', NULL, 'CompanyIndex', '1038907362670280704', '/mnp/CompanyIndex', 1, 'nested', 4);
INSERT INTO `frame_permission` VALUES ('1039107443503661056', '企业员工备案库', NULL, 'EmployeeIndex', '1038907362670280704', '/mnp/EmployeeIndex', 1, 'form', 5);
INSERT INTO `frame_permission` VALUES ('1039107632540942336', '老载体管理', NULL, 'BuildingIndex', '1038907362670280704', '/mnp/BuildingIndex', 1, 'table', 6);
INSERT INTO `frame_permission` VALUES ('1039107852989366272', '企业账号管理', NULL, 'CompanyAccountIndex', '1038907362670280704', '/mnp/CompanyAccountIndex', 1, 'user', 10);
INSERT INTO `frame_permission` VALUES ('1062028759042883584', '访客管理', NULL, 'mnpVisit', '1038907362670280704', '/mnp/mnpVisit', 2, 'list', 11);
INSERT INTO `frame_permission` VALUES ('1071781254153633792', '短信发送记录', NULL, 'mnpSmsSend', '1038907362670280704', '/mnp/mnpSmsSend', 1, 'email', 12);
INSERT INTO `frame_permission` VALUES ('1099644932949278720', '资产盘点', NULL, 'parkAssets', '1', '', 1, 'example', 1);
INSERT INTO `frame_permission` VALUES ('1099645457577017344', '楼盘管理', NULL, 'parkInfo', '1099644932949278720', '/parkAssets/parkFloorDisc/index', 1, 'example', 1);
INSERT INTO `frame_permission` VALUES ('1099646155333042176', '楼栋管理', NULL, 'parkBuild', '1099644932949278720', '/parkAssets/parkBuild/index', 1, 'dashboard', 2);
INSERT INTO `frame_permission` VALUES ('1099646425060343808', '房间管理', NULL, 'parkRoom', '1099644932949278720', '/parkAssets/parkRoom/index', 1, 'dashboard', 5);
INSERT INTO `frame_permission` VALUES ('1100427348848672768', '应收账单', NULL, 'companyBill', '1100426930559123456', '/companyBill/companyBill', 1, 'money', 1);
INSERT INTO `frame_permission` VALUES ('1100428071711801344', '能耗费导入', NULL, 'energyBill', '1100426930559123456', '/companyBill/companyEnergyBill', 1, 'icon', 2);
INSERT INTO `frame_permission` VALUES ('1100428456006516736', '收款核销', NULL, 'billPay', '1100426930559123456', '/companyBill/companyBillPay', 1, 'international', 3);
INSERT INTO `frame_permission` VALUES ('1100431022190755840', '租赁管理', NULL, 'leaseManage', '1', '', 1, 'language', 5);
INSERT INTO `frame_permission` VALUES ('1100432056191549440', '合同管理', NULL, 'contractManage', '1100431022190755840', '/contract/contractManage', 1, 'form', 2);
INSERT INTO `frame_permission` VALUES ('1100745290714972160', '企业管理', NULL, 'business', '1', '', 1, 'theme', 3);
INSERT INTO `frame_permission` VALUES ('1100745549713244160', '企业库', NULL, 'bizMain', '1100745290714972160', '/company/index', 1, 'table', 1);
INSERT INTO `frame_permission` VALUES ('1101539841759248384', '企业入库审核', NULL, 'parkProveInfo', '1100745290714972160', '/company/examine', 1, 'language', 2);
INSERT INTO `frame_permission` VALUES ('1103632811027333120', '企业经发管理', NULL, '', '1', '', 1, 'email', 4);
INSERT INTO `frame_permission` VALUES ('1103633262116339712', '经发数据导入', NULL, 'statisticsImportRevenue', '1103632811027333120', '/ec/statisticsImportRevenue', 1, 'list', 4);
INSERT INTO `frame_permission` VALUES ('1103697877999288320', '企业预填报管理', NULL, 'economyReportDetail', '1103632811027333120', '/fill/fillInfo', 1, 'international', 3);
INSERT INTO `frame_permission` VALUES ('1110238974477074432', '入驻办理', NULL, 'settleInManage', '1100431022190755840', '/settleIn/index', 1, 'international', 2);
INSERT INTO `frame_permission` VALUES ('1110504655009349632', '招商管理', NULL, 'sale', '1', '', 1, 'shopping', 2);
INSERT INTO `frame_permission` VALUES ('1110506146134753280', '项目管理', NULL, 'saleManagement', '1110504655009349632', '/sale/saleManagement', 1, 'list', 1);
INSERT INTO `frame_permission` VALUES ('1110506278024642560', '房源管理', NULL, 'roomManagement', '1110504655009349632', '/sale/roomManagement', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1111623573321023488', '填报模板', NULL, 'fillTemplate', '1103632811027333120', '/fill/fillTemplate', 1, 'documentation', 1);
INSERT INTO `frame_permission` VALUES ('1111686339792732160', '企业预填报任务推送', NULL, 'fillTask', '1103632811027333120', '/fill/fillTask', 1, 'nested', 2);
INSERT INTO `frame_permission` VALUES ('1114226839175299072', '导入数据查询', NULL, 'statisticsImportRevenueList', '1103632811027333120', '/ec/statisticsImportRevenueList', 1, 'list', 5);
INSERT INTO `frame_permission` VALUES ('1115584908610240512', '企业标签管理', NULL, 'companyTags', '1100745290714972160', '/company/companyTags', 1, 'component', 4);
INSERT INTO `frame_permission` VALUES ('1116316435589627904', '采购管理', NULL, 'purchaseManage', '1', '', 1, 'user', 10);
INSERT INTO `frame_permission` VALUES ('1116316712791179264', '供应商管理', NULL, 'supplier', '1116316435589627904', '/purchase/supplier', 1, 'peoples', 1);
INSERT INTO `frame_permission` VALUES ('1116317050491371520', '采购订单', NULL, 'outOrderMain', '1116316435589627904', '/purchase/outOrderMain', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1116317377982627840', '付款台账', NULL, 'outOrderPay', '1116316435589627904', '/purchase/outOrderPay', 1, 'list', 3);
INSERT INTO `frame_permission` VALUES ('1116737557434990592', '报事报修查看', NULL, 'repair', '1100745290714972160', '/estate/parkRepair', 1, 'list', 14);
INSERT INTO `frame_permission` VALUES ('1116737777837277184', '园区活动', NULL, 'activity', '1100745290714972160', '/estate/activityInfo', 1, 'list', 7);
INSERT INTO `frame_permission` VALUES ('1116771376615653376', '活动模板', NULL, 'activityTemplate', '1100745290714972160', '/estate/activityTemplate', 1, 'list', 8);
INSERT INTO `frame_permission` VALUES ('1118559497229434880', '收款管理', NULL, 'billManagementCollect', '1118559130257195008', '/bill/billManagementCollect', 1, 'component', 2);
INSERT INTO `frame_permission` VALUES ('1118567341379026944', '收款核销', NULL, 'billManagementCollectReceipt', '1118559130257195008', '/bill/billManagementCollectReceipt', 1, 'component', 1);
INSERT INTO `frame_permission` VALUES ('1120705247317065728', '安全管理', NULL, 'safety', '1', '', 1, 'education', 13);
INSERT INTO `frame_permission` VALUES ('1120705520856989696', '企业安全信息库', NULL, 'safetyCompanyinfo', '1120705247317065728', '/safety/safetyCompanyinfo', 1, 'list', 4);
INSERT INTO `frame_permission` VALUES ('1120705956422877184', '安全管理知识库', NULL, 'safetyKnowledge', '1120705247317065728', '/safety/safetyKnowledge', 1, 'list', 3);
INSERT INTO `frame_permission` VALUES ('1122578317258522624', '安全台账', NULL, 'safetySelfCheckingManage', '1120705247317065728', '/safety/safetySelfCheckingManage', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1122588170475536384', '年度安全管理计划', NULL, 'safetySelfCheckingPlan', '1120705247317065728', '/safety/safetySelfCheckingPlan', 1, 'list', 1);
INSERT INTO `frame_permission` VALUES ('1122929420265324544', '整改任务管理', NULL, 'rectificationManagement', '1120705247317065728', '/rectification/rectificationManagement', 1, 'list', 1);
INSERT INTO `frame_permission` VALUES ('1123221735722713088', '会议室管理', NULL, 'meetingRoom', '1100745290714972160', '/meeting/meetingRoom/index', 1, 'people', 10);
INSERT INTO `frame_permission` VALUES ('1123221864433319936', '会议室预约记录', NULL, 'meetingAppoint', '1100745290714972160', '/meeting/meetingAppoint/index', 1, 'people', 11);
INSERT INTO `frame_permission` VALUES ('1123642561672511488', '通知公告', NULL, 'activityNotice', '1100745290714972160', '/estate/activityNotice', 1, 'list', 9);
INSERT INTO `frame_permission` VALUES ('1123990303221481472', '系统消息', NULL, 'sysMsg', '826724306569396224', '/sysMsg/index', 1, 'clipboard', 6);
INSERT INTO `frame_permission` VALUES ('1127958710631530496', '日志', NULL, 'opsLog', '1127958491575615488', '/system/opLog', 1, 'bug', 1);
INSERT INTO `frame_permission` VALUES ('1127959735174168576', '操作日志', NULL, 'opLog', '826724306569396224', '/system/opLog', 1, 'form', 7);
INSERT INTO `frame_permission` VALUES ('1127962299483553792', '系统日志', NULL, 'opsRecord', '826724306569396224', '/ops/record', 1, 'excel', 8);
INSERT INTO `frame_permission` VALUES ('1128363209573531648', '移动端角色', NULL, 'roleMobile', '666134442716168192', '/system/roleMobile', 1, 'user', 9);
INSERT INTO `frame_permission` VALUES ('1130536330695016448', '园区运营', NULL, 'overview', '1131909144626855936', '/Overview/overview', 1, 'dashboard', 6);
INSERT INTO `frame_permission` VALUES ('1131909144626855936', '统计报表', NULL, 'reportForms', '1', '', 1, 'chart', 31);
INSERT INTO `frame_permission` VALUES ('1131909968224583680', '重点企业管理', NULL, 'keynote', '1100745290714972160', '/companyKeynote/index', 1, 'language', 3);
INSERT INTO `frame_permission` VALUES ('1133039738140229632', '园区企业经发一览表', NULL, 'staticsCompanyInfo', '1131909144626855936', '/bill/staticsCompanyInfo', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1133419831039623168', '人流分布分析', NULL, 'mnpShow', '1038907362670280704', '/mnp/mnpDevice', 1, 'dashboard', 1);
INSERT INTO `frame_permission` VALUES ('1151179463308869632', '智慧党建', NULL, 'party', '1', '', 1, 'list', 15);
INSERT INTO `frame_permission` VALUES ('1151179550755913728', '党支部管理', NULL, 'partyBranch', '1151179463308869632', '/partyBranch/partyBranch', 1, 'list', 1);
INSERT INTO `frame_permission` VALUES ('1151179632007970816', '活跃度管理', NULL, 'activation', '1151179463308869632', '/partyBranch/partyBranchActivation', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1151897091686006784', '企业账号管理', NULL, 'CompanyAccountIndex', '1100745290714972160', '/mnp/CompanyAccountIndex', 1, 'user', 5);
INSERT INTO `frame_permission` VALUES ('1166327538264309760', '合同签订汇总表', NULL, 'contractSigning', '1131909144626855936', '/reportForms/contractSigningIndex.vue', 1, 'lock', 4);
INSERT INTO `frame_permission` VALUES ('1166327787976392704', '园区载体出租情况统计表', NULL, 'carrierRentalRateIndex', '1131909144626855936', '/reportForms/carrierRentalRateIndex', 1, 'chart', 5);
INSERT INTO `frame_permission` VALUES ('1189975018612719616', '可视化大屏', NULL, 'http://123.60.187.18:8181/appli/start?appliId=1183445144993529856&codeRate=100000&frameRate=60', '1131909144626855936', '', 1, 'list', 5);
INSERT INTO `frame_permission` VALUES ('1200433443800875008', '场馆', NULL, 'venueing', '1', '', 1, 'list', 12);
INSERT INTO `frame_permission` VALUES ('1200433548666863616', '场馆管理', NULL, 'venue', '1200433443800875008', '/venueing/venue/index', 1, 'list', 1);
INSERT INTO `frame_permission` VALUES ('1200433653750956032', '场馆预约记录', NULL, 'venueAppoint', '1200433443800875008', '/venueing/venueAppoint/index', 1, 'list', 2);
INSERT INTO `frame_permission` VALUES ('1212392128022315008', '自定义可视化数据', NULL, 'yuanquStatistics', '1131909144626855936', '/dashpanel/yuanquStatistics.vue', 1, 'list', 7);
INSERT INTO `frame_permission` VALUES ('1212432701563338752', '楼栋经发一览表', NULL, 'buildStatistics', '1131909144626855936', '/dashpanel/buildStatistics.vue', 1, 'list', 7);
INSERT INTO `frame_permission` VALUES ('1214506638577238016', '园区活动统计', NULL, 'activityInfoStatistics', '1131909144626855936', '/estate/activityInfoStatistics.vue', 1, 'list', 12);
INSERT INTO `frame_permission` VALUES ('1214506972653551616', '文明创建统计', NULL, 'rectificationManagementStatistics.vue', '1120705247317065728', '/rectification/rectificationManagementStatistics.vue', 1, 'list', 6);
INSERT INTO `frame_permission` VALUES ('1214507187158646784', '招商情况统计', NULL, 'saleManageStatistics.vue', '1131909144626855936', '/sale/saleManageStatistics.vue', 1, 'list', 3);
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', 40);
INSERT INTO `frame_permission` VALUES ('666134530431647744', '人员管理', NULL, 'user', '666134442716168192', '/system/userOld', 1, 'user', 1);
INSERT INTO `frame_permission` VALUES ('666134649822511104', '菜单管理', NULL, 'menu', '826724306569396224', '/system/menu', 1, 'tree-table', 6);
INSERT INTO `frame_permission` VALUES ('666134766948450304', '菜单角色', NULL, 'role', '666134442716168192', '/system/role', 1, 'size', 4);
INSERT INTO `frame_permission` VALUES ('666134847483281408', '字典管理', NULL, 'dict', '826724306569396224', '/system/dict', 1, 'education', 7);
INSERT INTO `frame_permission` VALUES ('666134977427013632', '参数管理', NULL, 'param', '826724306569396224', '/system/param', 1, 'skill', 9);
INSERT INTO `frame_permission` VALUES ('674737708815351808', '页面生成', NULL, 'gen', '826724306569396224', '/system/generate', 1, 'documentation', 10);
INSERT INTO `frame_permission` VALUES ('684206133207891968', '首页链接', NULL, 'homeLink', '826724306569396224', '/system/homeLink', 1, 'guide', 9);
INSERT INTO `frame_permission` VALUES ('687290634918166528', '组织机构', NULL, 'dept', '666134442716168192', '/system/department', 1, 'peoples', 2);
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', 41);

SET FOREIGN_KEY_CHECKS = 1;