/* 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_2 Target Server Type : MySQL Target Server Version : 50716 File Encoding : 65001 Date: 05/03/2024 09:47:40 */ 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', 32); 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 ('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;