-- MySQL dump 10.13 Distrib 8.0.22, for Linux (x86_64) -- -- Host: localhost Database: go_admin -- ------------------------------------------------------ -- Server version 8.0.22 -- device manage system init data. BEGIN; /*!40000 ALTER TABLE `sys_casbin_rule` DISABLE KEYS */; INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/dict/databytype/','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/sysUser/','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/user/profile','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/menurole','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/roleMenuTreeselect/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/menuTreeselect','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/dict/databytype/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/menuids','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/getinfo','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/roledatascope','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/roleDeptTreeselect/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/deptTree','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/configKey/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/logout','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/user/avatar','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/user/pwd','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/dict/typeoptionselect','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/syssettingList','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/syssetting/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/syssetting','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/syssetting','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/syssetting/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/devicelist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list/:deviceId','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/monitorlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/monitor/log/:deviceId','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/loglist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/log/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/log/download/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/upgradefilelist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile/upload','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile/download','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list/:deviceId','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/upgradefile/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/applicationlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/application/:appid','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/application','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/application/:appid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/application','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list/:deviceId','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/grouplist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/group/manage/:groupid','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/group/manage','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/group/manage/:groupid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/group/manage','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/device/bindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/group/bindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/device/unbindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/group/unbindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/device/bind','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/device/unbind/:bindid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/group/bind','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/group/unbind/:bindid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/monitor/reboot/:deviceId','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/publish/device','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/app/publish/group','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','normal','/api/v1/device/list/import','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menulist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menu','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/databytype/','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menu','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menu/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUserList','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUser/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUser/','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUser','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUser','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysUser/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/user/profile','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/rolelist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/role/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/role','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/role','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/role/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/configList','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/config/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/config','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/config','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/config/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menurole','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/roleMenuTreeselect/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menuTreeselect','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/rolemenu','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/rolemenu','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/rolemenu/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/deptList','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dept/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dept','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dept','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dept/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/datalist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/data/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/databytype/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/data','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/data/','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/data/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/typelist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/type/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/type','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/type','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/type/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/postlist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/post/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/post','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/post','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/post/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menu/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/menuids','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/loginloglist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/loginlog/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/operloglist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/getinfo','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/roledatascope','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/roleDeptTreeselect/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/deptTree','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/configKey/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/logout','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/user/avatar','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/user/pwd','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/dict/typeoptionselect','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysjob','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysjob/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysjob','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysjob','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/sysjob/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/syssettingList','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/syssetting/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/syssetting','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/syssetting','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/syssetting/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/devicelist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list/:deviceId','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/monitorlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/monitor/log/:deviceId','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/loglist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/log/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/log/download','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/black/list','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/black/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/upgradefilelist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/videolist','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video/upload','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video/download/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/menu','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/menu','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/menu/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile/upload','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile/download','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list/:deviceId','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/upgradefile/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video/upload/form','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/visit/cover/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/visit/video/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/visit/picture/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/video','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/menu','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/item/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/item/:id','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/item','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/attri/:id','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/attri','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/media/publish/:id','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/applicationlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/application/:appid','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/application','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/application/:appid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/application','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list/:deviceId','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/grouplist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/group/manage/:groupid','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/group/manage','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/group/manage/:groupid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/group/manage','PUT',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/device/bindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/group/bindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/device/unbindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/group/unbindlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/device/bind','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/device/unbind/:bindid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/group/bind','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/group/unbind/:bindid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/monitor/reboot/:deviceId','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/publish/device','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/app/publish/group','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list/import','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/usual/upgradefile/download','GET',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/usual/log/upload','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/recordlist','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/record','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/record/:recordid','DELETE',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/list/statistics','POST',NULL,NULL,NULL); INSERT INTO `sys_casbin_rule` VALUES ('p','admin','/api/v1/device/log/list','POST',NULL,NULL,NULL); /*!40000 ALTER TABLE `sys_casbin_rule` ENABLE KEYS */; COMMIT; -- -- Dumping data for table `sys_dept` BEGIN; /*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */; INSERT INTO `sys_menu` VALUES (2,'Upms','系统管理','example','/upms','/0/2','M','无','',0,1,'','Layout',1,'0','1','1','1','2020-04-11 15:52:48.000','2021-03-15 20:22:07.990',NULL); INSERT INTO `sys_menu` VALUES (3,'Sysuser','用户管理','user','sysuser','/0/2/3','C','无','system:sysuser:list',2,NULL,NULL,'/sysuser/index',1,'0','1','1','0','2020-04-11 15:52:48.000','2020-04-12 11:10:42.000',NULL); INSERT INTO `sys_menu` VALUES (43,'','新增用户','','/api/v1/sysuser','/0/2/3/43','F','POST','system:sysuser:add',3,NULL,NULL,NULL,0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (44,'','查询用户','','/api/v1/sysuser','/0/2/3/44','F','GET','system:sysuser:query',3,NULL,NULL,NULL,0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (45,'','修改用户','','/api/v1/sysuser/','/0/2/3/45','F','PUT','system:sysuser:edit',3,NULL,NULL,NULL,0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (46,'','删除用户','','/api/v1/sysuser/','/0/2/3/46','F','DELETE','system:sysuser:remove',3,NULL,NULL,NULL,0,'0','1','1','0','2020-04-11 15:52:48.000','2020-04-12 15:32:45.000',NULL); INSERT INTO `sys_menu` VALUES (51,'Menu','菜单管理','tree-table','menu','/0/2/51','C','无','system:sysmenu:list',2,1,'','/menu/index',3,'0','1','1','0','2020-04-11 15:52:48.000','2020-04-12 11:16:30.000',NULL); INSERT INTO `sys_menu` VALUES (52,'Role','角色管理','peoples','role','/0/2/52','C','无','system:sysrole:list',2,1,'','/role/index',2,'0','1','1','0','2020-04-11 15:52:48.000','2020-04-12 11:16:19.000',NULL); INSERT INTO `sys_menu` VALUES (56,'Dept','部门管理','tree','dept','/0/2/56','C','无','system:sysdept:list',2,0,'','/dept/index',4,'1','1','1','0','2020-04-11 15:52:48.000','2021-06-10 21:10:47.481',NULL); INSERT INTO `sys_menu` VALUES (57,'post','岗位管理','pass','post','/0/2/57','C','无','system:syspost:list',2,0,'','/post/index',5,'1','1','1','0','2020-04-11 15:52:48.000','2021-06-10 21:10:52.352',NULL); INSERT INTO `sys_menu` VALUES (58,'Dict','字典管理','education','dict','/0/2/58','C','无','system:sysdicttype:list',2,0,'','/dict/index',6,'1','1','1','0','2020-04-11 15:52:48.000','2021-06-10 21:10:42.049',NULL); INSERT INTO `sys_menu` VALUES (59,'DictData','字典数据','education','dict/data/:dictId','/0/2/59','C','无','system:sysdictdata:list',2,0,'','/dict/data',100,'1','1','1','0','2020-04-11 15:52:48.000','2020-04-12 11:17:25.000',NULL); INSERT INTO `sys_menu` VALUES (60,'Tools','系统工具','component','/tools','/0/60','M','无','',0,0,'','Layout',3,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (61,'Swagger','系统接口','guide','swagger','/0/60/61','C','无','',60,0,'','/tools/swagger/index',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (62,'Config','参数设置','list','/config','/0/2/62','C','无','system:sysconfig:list',2,0,'','/config/index',7,'1','1','1','0','2020-04-11 15:52:48.000','2021-06-10 21:11:13.987',NULL); INSERT INTO `sys_menu` VALUES (63,'','接口权限','bug','','/0/63','M','','',0,0,'','',99,'1','1','1','0','2020-04-11 15:52:48.000','2020-04-12 16:39:32.000',NULL); INSERT INTO `sys_menu` VALUES (64,'','用户管理','user','','/0/63/64','M','','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (66,'','菜单管理','tree-table','','/0/63/66','C','','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (67,'','菜单列表','tree-table','/api/v1/menulist','/0/63/66/67','A','GET','',66,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (68,'','新建菜单','tree','/api/v1/menu','/0/63/66/68','A','POST','',66,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (69,'','字典','dict','','/0/63/69','M','','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (70,'','类型','dict','','/0/63/69/70','C','','',69,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (71,'','字典类型获取','tree','/api/v1/dict/databytype/','/0/63/256/71','A','GET','',256,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (72,'','修改菜单','bug','/api/v1/menu','/0/63/66/72','A','PUT','',66,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (73,'','删除菜单','bug','/api/v1/menu/:id','/0/63/66/73','A','DELETE','',66,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (74,'','管理员列表','bug','/api/v1/sysUserList','/0/63/64/74','A','GET',NULL,64,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (75,'','根据id获取管理员','bug','/api/v1/sysUser/:id','/0/63/64/75','A','GET',NULL,64,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (76,'','获取管理员','bug','/api/v1/sysUser/','/0/63/256/76','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000','2020-07-18 14:30:28.000',NULL); INSERT INTO `sys_menu` VALUES (77,'','创建管理员','bug','/api/v1/sysUser','/0/63/64/77','A','POST',NULL,64,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (78,'','修改管理员','bug','/api/v1/sysUser','/0/63/64/78','A','PUT',NULL,64,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (79,'','删除管理员','bug','/api/v1/sysUser/:id','/0/63/64/79','A','DELETE',NULL,64,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (80,'','当前用户个人信息','bug','/api/v1/user/profile','/0/63/256/267/80','A','GET',NULL,267,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000','2020-05-03 20:50:40.000',NULL); INSERT INTO `sys_menu` VALUES (81,'','角色列表','bug','/api/v1/rolelist','/0/63/201/81','A','GET',NULL,201,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (82,'','获取角色信息','bug','/api/v1/role/:id','/0/63/201/82','A','GET',NULL,201,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (83,'','创建角色','bug','/api/v1/role','/0/63/201/83','A','POST',NULL,201,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (84,'','修改角色','bug','/api/v1/role','/0/63/201/84','A','PUT',NULL,201,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (85,'','删除角色','bug','/api/v1/role/:id','/0/63/201/85','A','DELETE',NULL,201,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (86,'','参数列表','bug','/api/v1/configList','/0/63/202/86','A','GET',NULL,202,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (87,'','根据id获取参数','bug','/api/v1/config/:id','/0/63/202/87','A','GET',NULL,202,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (89,'','创建参数','bug','/api/v1/config','/0/63/202/89','A','POST',NULL,202,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (90,'','修改参数','bug','/api/v1/config','/0/63/202/90','A','PUT',NULL,202,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (91,'','删除参数','bug','/api/v1/config/:id','/0/63/202/91','A','DELETE',NULL,202,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (92,'','获取角色菜单','bug','/api/v1/menurole','/0/63/256/92','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000','2020-07-10 20:47:39.000',NULL); INSERT INTO `sys_menu` VALUES (93,'','根据角色id获取角色','bug','/api/v1/roleMenuTreeselect/:id','/0/63/256/93','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000','2020-07-10 20:47:52.000',NULL); INSERT INTO `sys_menu` VALUES (94,'','获取菜单树','bug','/api/v1/menuTreeselect','/0/63/256/94','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000','2020-05-03 20:52:11.000',NULL); INSERT INTO `sys_menu` VALUES (95,'','获取角色菜单','bug','/api/v1/rolemenu','/0/63/205/95','A','GET',NULL,205,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (96,'','创建角色菜单','bug','/api/v1/rolemenu','/0/63/205/96','A','POST',NULL,205,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (97,'','删除用户菜单数据','bug','/api/v1/rolemenu/:id','/0/63/205/97','A','DELETE',NULL,205,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (103,'','部门菜单列表','bug','/api/v1/deptList','/0/63/203/103','A','GET',NULL,203,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (104,'','根据id获取部门信息','bug','/api/v1/dept/:id','/0/63/203/104','A','GET',NULL,203,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (105,'','创建部门','bug','/api/v1/dept','/0/63/203/105','A','POST',NULL,203,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (106,'','修改部门','bug','/api/v1/dept','/0/63/203/106','A','PUT',NULL,203,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (107,'','删除部门','bug','/api/v1/dept/:id','/0/63/203/107','A','DELETE',NULL,203,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (108,'','字典数据列表','bug','/api/v1/dict/datalist','/0/63/69/206/108','A','GET',NULL,206,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (109,'','通过编码获取字典数据','bug','/api/v1/dict/data/:id','/0/63/69/206/109','A','GET',NULL,206,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (110,'','通过字典类型获取字典数据','bug','/api/v1/dict/databytype/:id','/0/63/256/110','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (111,'','创建字典数据','bug','/api/v1/dict/data','/0/63/69/206/111','A','POST',NULL,206,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (112,'','修改字典数据','bug','/api/v1/dict/data/','/0/63/69/206/112','A','PUT',NULL,206,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (113,'','删除字典数据','bug','/api/v1/dict/data/:id','/0/63/69/206/113','A','DELETE',NULL,206,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (114,'','字典类型列表','bug','/api/v1/dict/typelist','/0/63/69/70/114','A','GET',NULL,70,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (115,'','通过id获取字典类型','bug','/api/v1/dict/type/:id','/0/63/69/70/115','A','GET',NULL,70,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (116,'','创建字典类型','bug','/api/v1/dict/type','/0/63/69/70/116','A','POST',NULL,70,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (117,'','修改字典类型','bug','/api/v1/dict/type','/0/63/69/70/117','A','PUT',NULL,70,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (118,'','删除字典类型','bug','/api/v1/dict/type/:id','/0/63/69/70/118','A','DELETE',NULL,70,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (119,'','获取岗位列表','bug','/api/v1/postlist','/0/63/204/119','A','GET',NULL,204,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (120,'','通过id获取岗位信息','bug','/api/v1/post/:id','/0/63/204/120','A','GET',NULL,204,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (121,'','创建岗位','bug','/api/v1/post','/0/63/204/121','A','POST',NULL,204,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (122,'','修改岗位','bug','/api/v1/post','/0/63/204/122','A','PUT',NULL,204,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (123,'','删除岗位','bug','/api/v1/post/:id','/0/63/204/123','A','DELETE',NULL,204,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (138,'','获取根据id菜单信息','bug','/api/v1/menu/:id','/0/63/66/138','A','GET',NULL,66,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (142,'','获取角色对应的菜单id数组','bug','/api/v1/menuids','/0/63/256/142','A','GET',NULL,256,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (201,'','角色管理','peoples','','/0/63/201','C','GET','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (202,'','参数设置','list','','/0/63/202','C','DELETE','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (203,'','部门管理','tree','','/0/63/203','C','POST','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (204,'','岗位管理','pass','','/0/63/204','C','','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (205,'','角色菜单管理','nested','','/0/63/205','C','','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (206,'','数据','','','/0/63/69/206','C','PUT','',69,0,'','',2,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (211,'Log','系统日志','log','/log','/0/2/211','M','','',2,0,'','/log/index',8,'0','1','1','0','2020-04-11 15:52:48.000','2021-06-10 21:12:12.155',NULL); INSERT INTO `sys_menu` VALUES (212,'LoginLog','登录日志','logininfor','/loginlog','/0/2/211/212','C','','system:sysloginlog:list',211,0,'','/loginlog/index',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (213,'','获取登录日志','bug','/api/v1/loginloglist','/0/63/214/213','A','GET',NULL,214,NULL,NULL,NULL,0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (214,'','日志管理','log','','/0/63/214','M','GET','',63,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (215,'','删除日志','bug','/api/v1/loginlog/:id','/0/63/214/215','A','DELETE','',214,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (216,'OperLog','操作日志','skill','/operlog','/0/2/211/216','C','','system:sysoperlog:list',211,0,'','/operlog/index',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (217,'','获取操作日志','bug','/api/v1/operloglist','/0/63/214/217','A','GET','',214,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (220,'','新增菜单','','','/0/2/51/220','F','','system:sysmenu:add',51,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (221,'','修改菜单','edit','','/0/2/51/221','F','','system:sysmenu:edit',51,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (222,'','查询菜单','search','','/0/2/51/222','F','','system:sysmenu:query',51,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (223,'','删除菜单','','','/0/2/51/223','F','','system:sysmenu:remove',51,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (224,'','新增角色','','','/0/2/52/224','F','','system:sysrole:add',52,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (225,'','查询角色','','','/0/2/52/225','F','','system:sysrole:query',52,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (226,'','修改角色','','','/0/2/52/226','F','','system:sysrole:edit',52,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (227,'','删除角色','','','/0/2/52/227','F','','system:sysrole:remove',52,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (228,'','查询部门','','','/0/2/56/228','F','','system:sysdept:query',56,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (229,'','新增部门','','','/0/2/56/229','F','','system:sysdept:add',56,0,'','',1,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (230,'','修改部门','','','/0/2/56/230','F','','system:sysdept:edit',56,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (231,'','删除部门','','','/0/2/56/231','F','','system:sysdept:remove',56,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (232,'','查询岗位','','','/0/2/57/232','F','','system:syspost:query',57,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (233,'','新增岗位','','','/0/2/57/233','F','','system:syspost:add',57,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (234,'','修改岗位','','','/0/2/57/234','F','','system:syspost:edit',57,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (235,'','删除岗位','','','/0/2/57/235','F','','system:syspost:remove',57,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (236,'','字典查询','','','/0/2/58/236','F','','system:sysdicttype:query',58,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (237,'','新增类型','','','/0/2/58/237','F','','system:sysdicttype:add',58,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (238,'','修改类型','','','/0/2/58/238','F','','system:sysdicttype:edit',58,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (239,'','删除类型','','','/0/2/58/239','F','','system:sysdicttype:remove',58,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (240,'','查询数据','','','/0/2/59/240','F','','system:sysdictdata:query',59,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (241,'','新增数据','','','/0/2/59/241','F','','system:sysdictdata:add',59,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (242,'','修改数据','','','/0/2/59/242','F','','system:sysdictdata:edit',59,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (243,'','删除数据','','','/0/2/59/243','F','','system:sysdictdata:remove',59,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (244,'','查询参数','','','/0/2/62/244','F','','system:sysconfig:query',62,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (245,'','新增参数','','','/0/2/62/245','F','','system:sysconfig:add',62,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (246,'','修改参数','','','/0/2/62/246','F','','system:sysconfig:edit',62,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (247,'','删除参数','','','/0/2/62/247','F','','system:sysconfig:remove',62,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (248,'','查询登录日志','','','/0/2/211/212/248','F','','system:sysloginlog:query',212,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (249,'','删除登录日志','','','/0/2/211/212/249','F','','system:sysloginlog:remove',212,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (250,'','查询操作日志','','','/0/2/211/216/250','F','','system:sysoperlog:query',216,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (251,'','删除操作日志','','','/0/2/211/216/251','F','','system:sysoperlog:remove',216,0,'','',0,'0','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (252,'','获取登录用户信息','','/api/v1/getinfo','/0/63/256/252','A','GET','',256,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (253,'','角色数据权限','','/api/v1/roledatascope','/0/63/256/253','A','PUT','',256,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000','2020-07-10 20:47:58.000',NULL); INSERT INTO `sys_menu` VALUES (254,'','部门树接口【数据权限】','','/api/v1/roleDeptTreeselect/:id','/0/63/256/254','A','GET','',256,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (255,'','部门树【用户列表】','','/api/v1/deptTree','/0/63/256/255','A','GET','',256,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (256,'','必开接口','','','/0/63/256','M','GET','',63,0,'','',0,'1','1','','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (257,'','通过key获取参数','bug','/api/v1/configKey/:id','/0/63/256/257','A','GET','',256,0,'','',1,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (258,'','退出登录','','/api/v1/logout','/0/63/256/258','A','POST','',256,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (259,'','头像上传','','/api/v1/user/avatar','/0/63/256/267/259','A','POST','',267,0,'','',0,'1','1','1','0','2020-04-11 15:52:48.000','2020-05-03 20:50:05.000',NULL); INSERT INTO `sys_menu` VALUES (260,'','修改密码','','/api/v1/user/pwd','/0/63/256/260','A','PUT','',256,0,'','',0,'1','1','','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (261,'Gen','代码生成','code','gen','/0/60/261','C','','',60,0,'','/tools/gen/index',2,'0','1','1','0','2020-04-11 15:52:48.000','2020-04-12 11:18:12.000',NULL); INSERT INTO `sys_menu` VALUES (262,'EditTable','代码生成修改','build','editTable','/0/60/262','C','','',60,0,'','/tools/gen/editTable',100,'1','1','1','0','2020-04-11 15:52:48.000','2020-05-03 20:38:36.000',NULL); INSERT INTO `sys_menu` VALUES (263,'','字典类型下拉框【生成功能】','','/api/v1/dict/typeoptionselect','/0/63/256/263','A','GET','',256,0,'','',0,'1','1','','0','2020-04-11 15:52:48.000',NULL,NULL); INSERT INTO `sys_menu` VALUES (264,'Build','表单构建','build','build','/0/60/264','C','','',60,0,'','/tools/build/index',1,'0','1','1','1','2020-04-11 15:52:48.000','2020-07-18 13:51:47.000',NULL); INSERT INTO `sys_menu` VALUES (267,'','个人中心','','','/0/63/256/267','M','','',256,0,'','',0,'1','1','','1','2020-05-03 20:49:39.000','2020-05-03 20:49:39.000',NULL); INSERT INTO `sys_menu` VALUES (269,'Server','服务监控','druid','system/monitor','/0/60/269','C','','monitor:server:list',60,0,'','/system/monitor',0,'0','1','1','1','2020-04-14 00:28:19.000','2020-08-09 02:07:53.000',NULL); INSERT INTO `sys_menu` VALUES (459,'sys_job管理','定时任务','time-range','/sys_job','/0/459','M','无','',0,0,'','Layout',2,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-09 01:27:11.000',NULL); INSERT INTO `sys_menu` VALUES (460,'sys_job管理','定时任务','tool','sys_job','/0/459/460','C','无','sysjob:sysjob:list',459,0,'','/sysjob/index',0,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-04 15:18:32.000',NULL); INSERT INTO `sys_menu` VALUES (461,'sys_job','分页获取定时任务','pass','sys_job','/0/459/460/461','F','无','sysjob:sysjob:query',460,0,'','',0,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (462,'sys_job','创建定时任务','pass','sys_job','/0/459/460/462','F','无','sysjob:sysjob:add',460,0,'','',0,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (463,'sys_job','修改定时任务','pass','sys_job','/0/459/460/463','F','无','sysjob:sysjob:edit',460,0,'','',0,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (464,'sys_job','删除定时任务','pass','sys_job','/0/459/460/464','F','无','sysjob:sysjob:remove',460,0,'','',0,'0','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (465,'sys_job','定时任务','bug','sys_job','/0/63/465','M','无','',63,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (466,'sys_job','分页获取定时任务','bug','/api/v1/sysjob','/0/63/465/466','A','GET','',465,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (467,'sys_job','根据id获取定时任务','bug','/api/v1/sysjob/:id','/0/63/465/467','A','GET','',465,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (468,'sys_job','创建定时任务','bug','/api/v1/sysjob','/0/63/465/468','A','POST','',465,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (469,'sys_job','修改定时任务','bug','/api/v1/sysjob','/0/63/465/469','A','PUT','',465,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (470,'sys_job','删除定时任务','bug','/api/v1/sysjob/:id','/0/63/465/470','A','DELETE','',465,0,'','',0,'1','1','1','0','2020-08-03 09:17:37.000','2020-08-03 09:17:37.000',NULL); INSERT INTO `sys_menu` VALUES (471,'job_log','日志','bug','job_log','/0/459/471','C','','',459,0,'','/sysjob/log',0,'1','1','1','1','2020-08-05 21:24:46.000','2020-08-06 00:02:20.000',NULL); INSERT INTO `sys_menu` VALUES (473,'sysSetting','系统配置','form','syssettings','/0/60/473','C','无','syssetting:syssetting:list',60,0,'','/system/settings',0,'0','1','1','0','2020-08-09 01:05:22.000','2020-08-09 02:17:10.000',NULL); INSERT INTO `sys_menu` VALUES (474,'sys_setting','分页获取SysSetting','pass','sys_setting','/0/60/473/474','F','无','syssetting:syssetting:query',473,0,'','',0,'0','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (475,'sys_setting','创建SysSetting','pass','sys_setting','/0/60/473/475','F','无','syssetting:syssetting:add',473,0,'','',0,'0','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (476,'sys_setting','修改SysSetting','pass','sys_setting','/0/60/473/476','F','无','syssetting:syssetting:edit',473,0,'','',0,'0','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (477,'sys_setting','删除SysSetting','pass','sys_setting','/0/60/473/477','F','无','syssetting:syssetting:remove',473,0,'','',0,'0','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (478,'sys_setting','SysSetting','bug','sys_setting','/0/63/478','M','无','',63,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (479,'sys_setting','分页获取SysSetting','bug','/api/v1/syssettingList','/0/63/478/479','A','GET','',478,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (480,'sys_setting','根据id获取SysSetting','bug','/api/v1/syssetting/:id','/0/63/478/480','A','GET','',478,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (481,'sys_setting','创建SysSetting','bug','/api/v1/syssetting','/0/63/478/481','A','POST','',478,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (482,'sys_setting','修改SysSetting','bug','/api/v1/syssetting','/0/63/478/482','A','PUT','',478,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (483,'sys_setting','删除SysSetting','bug','/api/v1/syssetting/:id','/0/63/478/483','A','DELETE','',478,0,'','',0,'1','1','1','0','2020-08-09 01:05:22.000','2020-08-09 01:05:22.000',NULL); INSERT INTO `sys_menu` VALUES (496,'Sources','资源管理','network','/sources','/0/496','M','无','',0,1,'','Layout',3,'0','1','1','1','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (497,'File','文件管理','documentation','file-manage','/0/496/497','C','','',496,1,'','/fileManage/index',0,'0','1','1','1','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (498,'','内容管理','pass','/content','/0/498','M','无','',0,1,'','Layout',4,'0','1','1','1','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (499,'SysCategory','分类','pass','syscategory','/0/498/499','C','无','syscategory:syscategory:list',498,1,'','/syscategory/index',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (500,'','分页获取分类','pass','','/0/498/499/500','F','无','syscategory:syscategory:query',499,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (501,'','创建分类','pass','','/0/498/499/501','F','无','syscategory:syscategory:add',499,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (502,'','修改分类','pass','','/0/498/499/502','F','无','syscategory:syscategory:edit',499,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (503,'','删除分类','pass','','/0/498/499/503','F','无','syscategory:syscategory:remove',499,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (504,'Category','分类','bug','category','/0/63/504','M','无','',63,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (505,'','分页获取分类','bug','/api/v1/syscategoryList','/0/63/504/505','A','GET','',504,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (506,'','根据id获取分类','bug','/api/v1/syscategory/:id','/0/63/504/506','A','GET','',504,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (507,'','创建分类','bug','/api/v1/syscategory','/0/63/504/507','A','POST','',504,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (508,'','修改分类','bug','/api/v1/syscategory','/0/63/504/508','A','PUT','',504,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (509,'','删除分类','bug','/api/v1/syscategory/:id','/0/63/504/509','A','DELETE','',504,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (511,'SysContent','内容管理','pass','syscontent','/0/498/511','C','无','syscontent:syscontent:list',498,1,'','/syscontent/index',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (512,'','分页获取内容管理','pass','','/0/510/511/512','F','无','syscontent:syscontent:query',511,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (513,'','创建内容管理','pass','','/0/510/511/513','F','无','syscontent:syscontent:add',511,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (514,'','修改内容管理','pass','','/0/510/511/514','F','无','syscontent:syscontent:edit',511,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (515,'','删除内容管理','pass','','/0/510/511/515','F','无','syscontent:syscontent:remove',511,1,'','',0,'0','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (516,'Content','内容管理','bug','content','/0/63/516','M','无','',63,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (517,'','分页获取内容管理','bug','/api/v1/syscontentList','/0/63/516/517','A','GET','',516,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (518,'','根据id获取内容管理','bug','/api/v1/syscontent/:id','/0/63/516/518','A','GET','',516,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (519,'','创建内容管理','bug','/api/v1/syscontent','/0/63/516/519','A','POST','',516,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (520,'','修改内容管理','bug','/api/v1/syscontent','/0/63/516/520','A','PUT','',516,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (521,'','删除内容管理','bug','/api/v1/syscontent/:id','/0/63/516/521','A','DELETE','',516,1,'','',0,'1','1','1','0','2021-03-04 09:26:11.396','2021-03-04 09:26:11.396',NULL); INSERT INTO `sys_menu` VALUES (524,'','sdfddd','chart','/test','/0/523/524','A','GET','',523,0,'','/test',0,'0','1','1','1','2021-03-11 18:57:56.231','2021-03-11 19:26:25.490',NULL); INSERT INTO `sys_menu` VALUES (525,'','sddddddd','','/test/2','/0/523/525','A','POST','',523,0,'','',0,'0','2','','1','2021-03-11 19:37:42.013','2021-03-11 19:37:42.013',NULL); INSERT INTO `sys_menu` VALUES (526,'','assssss','','/test/ccc','/0/523/526','A','PUT','',523,0,'','',0,'0','2','','1','2021-03-11 19:45:48.387','2021-03-11 19:45:48.387',NULL); INSERT INTO `sys_menu` VALUES (529,'Device','设备管理','phone','/device','/0/529','M','','',0,0,'','Layout',2,'0','1','1','1','2021-03-15 20:21:37.342','2021-06-10 09:03:57.381',NULL); INSERT INTO `sys_menu` VALUES (530,'DeviceList','设备列表','list','devicelist','/0/529/530','C','','',529,0,'','/devicelist/index',0,'0','1','1','1','2021-03-15 20:24:55.397','2021-03-16 20:27:03.138',NULL); INSERT INTO `sys_menu` VALUES (531,'Monitor','设备监控','monitor','monitor','/0/529/531','C','','',529,0,'','/monitor/index',1,'0','1','','1','2021-03-15 20:27:31.230','2021-03-15 20:27:31.230',NULL); INSERT INTO `sys_menu` VALUES (532,'Log','设备日志','log','devicelog','/0/529/532','C','','',529,0,'','/devicelog/index',2,'0','1','1','1','2021-03-15 20:31:01.415','2021-03-16 20:40:04.334',NULL); INSERT INTO `sys_menu` VALUES (533,'Media','媒体管理','textarea','/media','/0/533','M','','',0,0,'','Layout',4,'0','1','','1','2021-03-15 20:37:24.667','2021-03-15 20:37:24.667',NULL); INSERT INTO `sys_menu` VALUES (534,'Video','视频管理','server','video','/0/533/534','C','','',533,0,'','/video/index',0,'0','1','','1','2021-03-15 20:38:51.653','2021-03-15 20:38:51.653',NULL); INSERT INTO `sys_menu` VALUES (535,'Playlist','播放列表','icon','playlist','/0/533/535','C','','',533,0,'','/playlist/index',1,'0','1','1','1','2021-03-15 20:41:10.794','2021-04-09 19:23:29.241',NULL); INSERT INTO `sys_menu` VALUES (538,'application','应用管理','component','/application','/0/538','M','','',0,0,'','Layout',2,'0','1','1','1','2021-03-15 20:50:10.542','2021-06-10 09:03:48.842',NULL); INSERT INTO `sys_menu` VALUES (539,'Version','升级文件','build','/upgradefile','/0/538/539','C','','',538,0,'','/upgradefile/index',1,'0','1','1','1','2021-03-15 20:51:10.627','2021-06-07 18:53:38.851',NULL); INSERT INTO `sys_menu` VALUES (540,'','设备列表','list','','/0/63/540','M','','',63,0,'','',1,'1','1','1','1','2021-03-16 18:08:40.764','2021-03-16 18:08:53.551',NULL); INSERT INTO `sys_menu` VALUES (541,'','获取设备列表','','/api/v1/devicelist','/0/63/540/541','A','POST','',540,0,'','',0,'1','1','1','1','2021-03-16 18:10:35.042','2021-07-28 09:57:28.405',NULL); INSERT INTO `sys_menu` VALUES (542,'','更改设备信息','','/api/v1/device/list','/0/63/540/542','A','PUT','',540,0,'','',1,'1','1','','1','2021-03-16 18:30:15.544','2021-03-16 18:30:15.544',NULL); INSERT INTO `sys_menu` VALUES (543,'','把设备加入黑名单','','/api/v1/device/list/:deviceId','/0/63/540/543','A','POST','',540,0,'','',1,'1','1','1','1','2021-03-16 18:33:36.270','2021-03-20 14:35:47.795',NULL); INSERT INTO `sys_menu` VALUES (544,'','设备监控','monitor','','/0/63/544','M','','',63,0,'','',1,'1','1','','1','2021-03-16 18:48:41.140','2021-03-16 18:48:41.140',NULL); INSERT INTO `sys_menu` VALUES (545,'','获取监控设备列表','','/api/v1/monitorlist','/0/63/544/545','A','POST','',544,0,'','',0,'1','1','1','1','2021-03-16 18:50:40.583','2021-07-28 10:28:27.460',NULL); INSERT INTO `sys_menu` VALUES (547,'','获取设备日志','','/api/v1/device/monitor/log/:deviceId','/0/63/544/547','A','GET','',544,0,'','',1,'1','1','1','1','2021-03-16 18:55:42.248','2021-03-20 15:51:49.765',NULL); INSERT INTO `sys_menu` VALUES (548,'','设备日志','log','','/0/63/548','M','','',63,0,'','',2,'1','1','','1','2021-03-16 18:57:56.827','2021-03-16 18:57:56.827',NULL); INSERT INTO `sys_menu` VALUES (549,'','获取日志列表','','/api/v1/loglist','/0/63/548/549','A','POST','',548,0,'','',0,'1','1','1','1','2021-03-16 18:58:35.558','2021-07-28 14:08:29.107',NULL); INSERT INTO `sys_menu` VALUES (550,'','删除日志','','/api/v1/device/log/:id','/0/63/548/550','A','DELETE','',548,0,'','',0,'1','1','','1','2021-03-16 18:59:40.716','2021-03-16 18:59:40.716',NULL); INSERT INTO `sys_menu` VALUES (551,'','下载日志','','/api/v1/device/log/download','/0/63/548/551','A','GET','',548,0,'','',1,'1','1','1','1','2021-03-16 19:02:19.436','2021-08-12 21:18:11.302',NULL); INSERT INTO `sys_menu` VALUES (552,'','设备黑名单','','','/0/63/552','M','GET','',63,0,'','',1,'1','1','','1','2021-03-16 19:03:42.063','2021-03-16 19:03:42.063',NULL); INSERT INTO `sys_menu` VALUES (553,'','获取黑名单列表','','/api/v1/device/black/list','/0/63/552/553','A','GET','',552,0,'','',0,'1','1','','1','2021-03-16 19:05:58.090','2021-03-16 19:05:58.090',NULL); INSERT INTO `sys_menu` VALUES (554,'','移除黑名单','','/api/v1/device/black/:id','/0/63/552/554','A','DELETE','',552,0,'','',0,'1','1','','1','2021-03-16 19:07:18.730','2021-03-16 19:07:18.730',NULL); INSERT INTO `sys_menu` VALUES (555,'','升级文件','','','/0/63/555','M','DELETE','',63,0,'','',2,'1','1','1','1','2021-03-16 19:09:01.562','2021-06-05 17:59:09.521',NULL); INSERT INTO `sys_menu` VALUES (556,'','获取版本列表','','/api/v1/upgradefilelist','/0/63/555/556','A','POST','',555,0,'','',0,'1','1','1','1','2021-03-16 19:10:14.668','2021-07-28 11:35:05.165',NULL); INSERT INTO `sys_menu` VALUES (557,'','修改版本信息','','/api/v1/app/upgradefile','/0/63/555/557','A','PUT','',555,0,'','',1,'1','1','1','1','2021-03-16 19:11:32.588','2021-07-06 18:54:02.647',NULL); INSERT INTO `sys_menu` VALUES (558,'','删除版本','','/api/v1/app/upgradefile/:id','/0/63/555/558','A','DELETE','',555,0,'','',1,'1','1','1','1','2021-03-16 19:14:04.556','2021-07-06 18:54:11.166',NULL); INSERT INTO `sys_menu` VALUES (559,'','发布版本','','/api/v1/app/upgradefile','/0/63/555/559','A','POST','',555,0,'','',1,'1','1','1','1','2021-03-16 19:14:59.562','2021-07-06 18:54:18.732',NULL); INSERT INTO `sys_menu` VALUES (560,'','视频管理','','','/0/63/560','M','','',63,0,'','',2,'1','1','','1','2021-03-16 19:19:43.311','2021-03-16 19:19:43.311',NULL); INSERT INTO `sys_menu` VALUES (561,'','播放列表和发布管理','','','/0/63/561','M','','',63,0,'','',2,'1','1','1','1','2021-03-16 19:20:02.530','2021-04-25 19:31:13.453',NULL); INSERT INTO `sys_menu` VALUES (562,'','获取视频列表','','/api/v1/videolist','/0/63/560/562','A','GET','',560,0,'','',0,'1','1','1','1','2021-03-16 19:20:59.139','2021-04-07 18:48:57.902',NULL); INSERT INTO `sys_menu` VALUES (563,'','获取单个视频信息','','/api/v1/media/video/:id','/0/63/560/563','A','GET','',560,0,'','',0,'1','1','1','1','2021-03-16 19:22:02.624','2021-04-08 20:41:39.284',NULL); INSERT INTO `sys_menu` VALUES (564,'','删除视频','','/api/v1/media/video/:id','/0/63/560/564','A','DELETE','',560,0,'','',0,'1','1','','1','2021-03-16 19:22:21.477','2021-03-16 19:22:21.477',NULL); INSERT INTO `sys_menu` VALUES (565,'','上传视频','','/api/v1/media/video/upload','/0/63/560/565','A','POST','',560,0,'','',0,'1','1','','1','2021-03-16 19:26:36.410','2021-03-16 19:26:36.410',NULL); INSERT INTO `sys_menu` VALUES (566,'','下载视频','','/api/v1/media/video/download/:id','/0/63/560/566','A','GET','',560,0,'','',0,'1','1','','1','2021-03-16 19:27:20.003','2021-03-16 19:27:20.003',NULL); INSERT INTO `sys_menu` VALUES (567,'','获取播放列表菜单','','/api/v1/media/menu','/0/63/561/567','A','GET','',561,0,'','',0,'1','1','1','1','2021-03-16 19:29:14.710','2021-04-12 17:58:49.044',NULL); INSERT INTO `sys_menu` VALUES (568,'','编辑菜单','','/api/v1/media/menu','/0/63/561/568','A','PUT','',561,0,'','',0,'1','1','1','1','2021-03-16 19:29:51.020','2021-04-12 17:59:09.358',NULL); INSERT INTO `sys_menu` VALUES (569,'','删除菜单','','/api/v1/media/menu/:id','/0/63/561/569','A','DELETE','',561,0,'','',0,'1','1','1','1','2021-03-16 19:30:19.345','2021-04-12 17:59:40.090',NULL); INSERT INTO `sys_menu` VALUES (572,'','上传应用','','/api/v1/app/upgradefile/upload','/0/63/555/572','A','POST','',555,0,'','',0,'1','1','1','1','2021-03-16 19:36:38.561','2021-07-06 18:53:38.315',NULL); INSERT INTO `sys_menu` VALUES (573,'','下载应用','','/api/v1/app/upgradefile/download','/0/63/555/573','A','GET','',555,0,'','',0,'1','1','1','1','2021-03-16 19:37:19.137','2021-07-08 19:59:49.952',NULL); INSERT INTO `sys_menu` VALUES (579,'','获取设备信息','','/api/v1/device/list/:deviceId','/0/63/540/579','A','GET','',540,0,'','',0,'1','1','1','1','2021-03-20 14:35:30.044','2021-03-20 14:35:53.098',NULL); INSERT INTO `sys_menu` VALUES (580,'','查询版本','','/api/v1/app/upgradefile/:id','/0/63/555/580','A','GET','',555,0,'','',0,'1','1','1','1','2021-03-22 19:23:46.330','2021-07-06 18:53:56.489',NULL); INSERT INTO `sys_menu` VALUES (581,'','保存上传视频信息','','/api/v1/media/video/upload/form','/0/63/560/581','A','POST','',560,0,'','',0,'1','1','','1','2021-03-29 18:54:34.810','2021-03-29 18:54:34.810',NULL); INSERT INTO `sys_menu` VALUES (582,'','媒体访问接口','','','/0/63/582','M','','',63,0,'','',2,'1','1','1','1','2021-04-06 19:29:07.966','2021-04-06 19:29:16.215',NULL); INSERT INTO `sys_menu` VALUES (583,'','访问视频封面','','/api/v1/media/visit/cover/:id','/0/63/582/583','A','GET','',582,0,'','',0,'1','1','1','1','2021-04-06 19:29:53.067','2021-04-06 19:35:24.235',NULL); INSERT INTO `sys_menu` VALUES (584,'','访问视频接口','','/api/v1/media/visit/video/:id','/0/63/582/584','A','GET','',582,0,'','',0,'1','1','1','1','2021-04-06 19:30:32.485','2021-04-06 19:35:31.867',NULL); INSERT INTO `sys_menu` VALUES (585,'','访问图片接口','','/api/v1/media/visit/picture/:id','/0/63/582/585','A','GET','',582,0,'','',0,'1','1','1','1','2021-04-06 19:31:10.384','2021-04-06 19:35:38.669',NULL); INSERT INTO `sys_menu` VALUES (586,'','修改视频信息','','/api/v1/media/video','/0/63/560/586','A','PUT','',560,0,'','',0,'1','1','','1','2021-04-08 20:42:06.942','2021-04-08 20:42:06.942',NULL); INSERT INTO `sys_menu` VALUES (587,'/api/v1/media/menu','添加菜单','','/api/v1/media/menu','/0/63/561/587','A','POST','',561,0,'','',0,'1','1','1','1','2021-04-12 18:00:24.909','2021-04-13 21:01:29.682',NULL); INSERT INTO `sys_menu` VALUES (588,'','获取单个菜单视频列表','','/api/v1/media/item/:id','/0/63/561/588','A','GET','',561,0,'','',0,'1','1','1','1','2021-04-12 18:01:24.299','2021-04-12 21:07:47.042',NULL); INSERT INTO `sys_menu` VALUES (589,'','移除列表视频','','/api/v1/media/item/:id','/0/63/561/589','A','DELETE','',561,0,'','',0,'1','1','1','1','2021-04-12 18:01:58.430','2021-04-12 18:02:49.450',NULL); INSERT INTO `sys_menu` VALUES (590,'','添加视频到列表','','/api/v1/media/item','/0/63/561/590','A','POST','',561,0,'','',0,'1','1','1','1','2021-04-12 18:02:29.991','2021-04-12 21:56:22.597',NULL); INSERT INTO `sys_menu` VALUES (591,'','获取播放属性','','/api/v1/media/attri/:id','/0/63/561/591','A','GET','',561,0,'','',0,'1','1','1','1','2021-04-24 12:23:06.202','2021-04-24 17:21:19.490',NULL); INSERT INTO `sys_menu` VALUES (592,'','更新播放属性','','/api/v1/media/attri','/0/63/561/592','A','PUT','',561,0,'','',0,'1','1','1','1','2021-04-24 12:25:28.248','2021-04-24 17:21:27.485',NULL); INSERT INTO `sys_menu` VALUES (593,'','发布媒体信息到设备','','/api/v1/media/publish/:id','/0/63/561/593','A','POST','',561,0,'','',0,'1','1','','1','2021-04-25 19:34:52.684','2021-04-25 19:34:52.684',NULL); INSERT INTO `sys_menu` VALUES (594,'Application','应用管理','list','application','/0/538/594','C','','',538,0,'','/application/index',0,'0','1','1','1','2021-06-05 13:57:07.095','2021-06-05 14:02:48.098',NULL); INSERT INTO `sys_menu` VALUES (595,'','应用管理','','','/0/63/595','M','','',63,0,'','',2,'1','1','1','1','2021-06-05 15:04:59.101','2021-06-05 17:44:38.131',NULL); INSERT INTO `sys_menu` VALUES (596,'','获取应用列表','','/api/v1/applicationlist','/0/63/595/596','A','POST','',595,0,'','',0,'1','1','1','1','2021-06-05 17:46:18.993','2021-07-28 11:18:10.950',NULL); INSERT INTO `sys_menu` VALUES (597,'','获取应用信息','','/api/v1/app/application/:appid','/0/63/595/597','A','GET','',595,0,'','',0,'1','1','','1','2021-06-05 17:56:11.514','2021-06-05 17:56:11.514',NULL); INSERT INTO `sys_menu` VALUES (598,'','更改应用信息','','/api/v1/app/application','/0/63/595/598','A','PUT','',595,0,'','',0,'1','1','','1','2021-06-05 17:57:36.569','2021-06-05 17:57:36.569',NULL); INSERT INTO `sys_menu` VALUES (599,'','删除应用','','/api/v1/app/application/:appid','/0/63/595/599','A','DELETE','',595,0,'','',0,'1','1','','1','2021-06-05 17:58:01.357','2021-06-05 17:58:01.357',NULL); INSERT INTO `sys_menu` VALUES (600,'','添加应用','','/api/v1/app/application','/0/63/595/600','A','POST','',595,0,'','',0,'1','1','','1','2021-06-07 19:33:40.341','2021-06-07 19:33:40.341',NULL); INSERT INTO `sys_menu` VALUES (601,'','添加设备','','/api/v1/device/list','/0/63/540/601','A','POST','',540,0,'','',0,'1','1','','1','2021-06-08 16:37:40.104','2021-06-08 16:37:40.104',NULL); INSERT INTO `sys_menu` VALUES (602,'','删除设备','','/api/v1/device/list/:deviceId','/0/63/540/602','A','DELETE','',540,0,'','',0,'1','1','1','1','2021-06-08 16:38:22.745','2021-06-08 16:40:00.193',NULL); INSERT INTO `sys_menu` VALUES (603,'group','群组管理','tree','/group','/0/603','M','','',0,0,'','Layout',3,'0','1','1','1','2021-06-09 18:50:18.447','2021-06-09 18:50:35.877',NULL); INSERT INTO `sys_menu` VALUES (604,'Group','群组管理','tree-table','group','/0/603/604','C','','',603,0,'','/group/index',0,'0','1','1','1','2021-06-09 18:51:52.954','2021-06-09 18:52:08.599',NULL); INSERT INTO `sys_menu` VALUES (605,'','群组管理','','','/0/63/605','M','','',63,0,'','',2,'1','1','1','1','2021-06-09 18:54:30.039','2021-06-09 18:55:06.911',NULL); INSERT INTO `sys_menu` VALUES (606,'','获取群组列表','','/api/v1/grouplist','/0/63/605/606','A','POST','',605,0,'','',0,'1','1','1','1','2021-06-09 18:55:54.293','2021-07-28 14:08:40.902',NULL); INSERT INTO `sys_menu` VALUES (607,'','获取群组信息','','/api/v1/group/manage/:groupid','/0/63/605/607','A','GET','',605,0,'','',0,'1','1','1','1','2021-06-09 18:56:45.560','2021-06-09 18:58:40.672',NULL); INSERT INTO `sys_menu` VALUES (608,'','增加群组','','/api/v1/group/manage','/0/63/605/608','A','POST','',605,0,'','',0,'1','1','','1','2021-06-09 18:59:15.496','2021-06-09 18:59:15.496',NULL); INSERT INTO `sys_menu` VALUES (609,'','删除群组','','/api/v1/group/manage/:groupid','/0/63/605/609','A','DELETE','',605,0,'','',0,'1','1','','1','2021-06-09 18:59:39.926','2021-06-09 18:59:39.926',NULL); INSERT INTO `sys_menu` VALUES (610,'','修改群组信息','','/api/v1/group/manage','/0/63/605/610','A','PUT','',605,0,'','',0,'1','1','','1','2021-06-09 19:00:24.775','2021-06-09 19:00:24.775',NULL); INSERT INTO `sys_menu` VALUES (611,'','应用设备绑定列表','','/api/v1/app/device/bindlist','/0/63/595/611','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-01 19:15:00.888','2021-07-28 15:04:33.599',NULL); INSERT INTO `sys_menu` VALUES (612,'','应用群组绑定列表','','/api/v1/app/group/bindlist','/0/63/595/612','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-01 19:15:38.593','2021-07-28 15:04:39.758',NULL); INSERT INTO `sys_menu` VALUES (613,'','未绑定应用设备列表','','/api/v1/app/device/unbindlist','/0/63/595/613','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-01 19:18:02.383','2021-07-28 12:23:28.612',NULL); INSERT INTO `sys_menu` VALUES (614,'','未绑定应用群组列表','','/api/v1/app/group/unbindlist','/0/63/595/614','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-01 19:18:35.535','2021-07-28 12:23:36.451',NULL); INSERT INTO `sys_menu` VALUES (615,'','绑定应用和设备','','/api/v1/app/device/bind','/0/63/595/615','A','POST','',595,0,'','',0,'1','1','','1','2021-07-01 20:15:39.500','2021-07-01 20:15:39.500',NULL); INSERT INTO `sys_menu` VALUES (616,'','解绑定应用和设备','','/api/v1/app/device/unbind/:bindid','/0/63/595/616','A','DELETE','',595,0,'','',0,'1','1','1','1','2021-07-01 20:16:39.722','2021-07-05 17:21:05.272',NULL); INSERT INTO `sys_menu` VALUES (617,'','绑定应用和群组','','/api/v1/app/group/bind','/0/63/595/617','A','POST','',595,0,'','',0,'1','1','','1','2021-07-01 20:17:10.932','2021-07-01 20:17:10.932',NULL); INSERT INTO `sys_menu` VALUES (618,'','解绑定应用和群组','','/api/v1/app/group/unbind/:bindid','/0/63/595/618','A','DELETE','',595,0,'','',0,'1','1','1','1','2021-07-01 20:17:44.688','2021-07-05 17:21:21.211',NULL); INSERT INTO `sys_menu` VALUES (619,'','重启设备','','/api/v1/device/monitor/reboot/:deviceId','/0/63/544/619','A','POST','',544,0,'','',0,'1','1','1','1','2021-07-14 16:23:35.059','2021-07-14 16:24:58.706',NULL); INSERT INTO `sys_menu` VALUES (620,'','推送应用或配置到设备','','/api/v1/app/publish/device','/0/63/595/620','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-14 18:54:48.540','2021-07-14 19:26:47.033',NULL); INSERT INTO `sys_menu` VALUES (621,'','推送应用或配置到群组','','/api/v1/app/publish/group','/0/63/595/621','A','POST','',595,0,'','',0,'1','1','1','1','2021-07-14 18:55:22.264','2021-07-14 19:26:55.049',NULL); INSERT INTO `sys_menu` VALUES (622,'','导入设备','','/api/v1/device/list/import','/0/63/540/622','A','POST','',540,0,'','',0,'1','1','','1','2021-07-21 17:14:55.848','2021-07-21 17:14:55.848',NULL); INSERT INTO `sys_menu` VALUES (623,'','设备调用接口','','','/0/63/623','M','','',63,0,'','',2,'1','1','1','1','2021-08-11 18:09:43.393','2021-08-11 18:09:54.299',NULL); INSERT INTO `sys_menu` VALUES (624,'','升级文件下载','','/api/v1/device/usual/upgradefile/download','/0/63/623/624','A','GET','',623,0,'','',0,'1','1','1','1','2021-08-11 18:14:33.181','2021-08-11 18:14:49.629',NULL); INSERT INTO `sys_menu` VALUES (625,'','日志文件上传','','/api/v1/device/usual/log/upload','/0/63/623/625','A','POST','',623,0,'','',0,'1','1','','1','2021-08-11 18:15:59.133','2021-08-11 18:15:59.133',NULL); INSERT INTO `sys_menu` VALUES (626,'Upgraderecord','升级记录','calendar','upgraderecord','/0/529/626','C','','',529,0,'','/upgraderecord/index',3,'0','1','1','1','2021-08-13 10:01:28.004','2021-08-13 10:03:50.609',NULL); INSERT INTO `sys_menu` VALUES (627,'','升级记录','','','/0/63/627','M','','',63,0,'','',2,'1','1','1','1','2021-08-13 13:16:23.307','2021-08-13 13:16:29.655',NULL); INSERT INTO `sys_menu` VALUES (628,'','获取升级记录','','/api/v1/recordlist','/0/63/627/628','A','POST','',627,0,'','',0,'1','1','','1','2021-08-13 13:18:18.842','2021-08-13 13:18:18.842',NULL); INSERT INTO `sys_menu` VALUES (629,'','删除记录','','/api/v1/device/record','/0/529/626/629','A','DELETE','',626,0,'','',0,'1','1','1','1','2021-08-13 13:19:25.608','2021-08-13 13:19:56.126',NULL); INSERT INTO `sys_menu` VALUES (630,'','删除升级记录','','/api/v1/device/record/:recordid','/0/63/627/630','A','DELETE','',627,0,'','',0,'1','1','','1','2021-08-13 13:24:52.853','2021-08-13 13:24:52.853',NULL); INSERT INTO `sys_menu` VALUES (631,'','设备统计','','/api/v1/device/list/statistics','/0/63/540/631','A','POST','',540,0,'','',1,'1','1','1','1','2021-08-14 12:32:46.197','2021-08-14 12:49:16.359',NULL); INSERT INTO `sys_menu` VALUES (632,'','获取指定设备日志列表','','/api/v1/device/log/list','/0/63/548/632','A','POST','',548,0,'','',1,'1','1','','1','2021-08-14 15:20:39.232','2021-08-14 15:20:39.232',NULL); /*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */; COMMIT; BEGIN; INSERT INTO `sys_role_menu` VALUES (2,63,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,71,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,76,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,80,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,92,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,93,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,94,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,110,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,142,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,252,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,253,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,254,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,255,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,256,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,257,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,258,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,259,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,260,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,263,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,267,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,478,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,479,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,480,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,481,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,482,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,483,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,529,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,530,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,531,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,532,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,538,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,539,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,540,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,541,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,542,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,543,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,544,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,545,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,547,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,548,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,549,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,550,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,551,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,555,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,556,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,557,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,558,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,559,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,572,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,573,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,579,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,580,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,594,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,595,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,596,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,597,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,598,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,599,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,600,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,601,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,602,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,603,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,604,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,605,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,606,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,607,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,608,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,609,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,610,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,611,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,612,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,613,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,614,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,615,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,616,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,617,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,618,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,619,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,620,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,621,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (2,622,'normal',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,2,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,3,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,43,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,44,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,45,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,46,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,51,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,52,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,56,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,57,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,58,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,59,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,62,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,63,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,64,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,66,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,67,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,68,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,69,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,70,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,71,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,72,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,73,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,74,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,75,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,76,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,77,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,78,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,79,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,80,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,81,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,82,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,83,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,84,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,85,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,86,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,87,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,89,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,90,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,91,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,92,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,93,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,94,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,95,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,96,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,97,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,103,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,104,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,105,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,106,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,107,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,108,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,109,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,110,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,111,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,112,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,113,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,114,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,115,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,116,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,117,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,118,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,119,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,120,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,121,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,122,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,123,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,138,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,142,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,201,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,202,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,203,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,204,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,205,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,206,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,211,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,212,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,213,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,214,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,215,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,216,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,217,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,220,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,221,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,222,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,223,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,224,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,225,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,226,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,227,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,228,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,229,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,230,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,231,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,232,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,233,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,234,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,235,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,236,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,237,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,238,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,239,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,240,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,241,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,242,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,243,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,244,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,245,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,246,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,247,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,248,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,249,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,250,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,251,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,252,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,253,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,254,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,255,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,256,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,257,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,258,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,259,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,260,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,263,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,267,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,465,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,466,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,467,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,468,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,469,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,470,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,478,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,479,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,480,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,481,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,482,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,483,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,529,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,530,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,531,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,532,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,538,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,539,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,540,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,541,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,542,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,543,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,544,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,545,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,547,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,548,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,549,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,550,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,551,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,552,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,553,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,554,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,555,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,556,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,557,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,558,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,559,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,560,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,561,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,562,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,563,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,564,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,565,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,566,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,567,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,568,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,569,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,572,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,573,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,579,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,580,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,581,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,582,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,583,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,584,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,585,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,586,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,587,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,588,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,589,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,590,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,591,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,592,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,593,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,594,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,595,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,596,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,597,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,598,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,599,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,600,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,601,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,602,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,603,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,604,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,605,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,606,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,607,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,608,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,609,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,610,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,611,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,612,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,613,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,614,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,615,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,616,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,617,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,618,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,619,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,620,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,621,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,622,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,623,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,624,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,625,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,626,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,627,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,628,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,629,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,630,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,631,'admin',NULL,NULL); INSERT INTO `sys_role_menu` VALUES (1,632,'admin',NULL,NULL); /*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */; COMMIT; BEGIN; INSERT INTO `sys_config` VALUES (1,'主框架页-默认皮肤样式名称','sys_index_skinName','skin-blue','Y','蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow','1','1','2021-03-20 13:31:12.721','2021-03-20 13:31:12.721',NULL); INSERT INTO `sys_config` VALUES (2,'用户管理-账号初始密码','sys.user.initPassword','123456','Y','初始化密码 123456','1','1','2021-03-20 13:31:12.721','2021-03-20 13:31:12.721',NULL); INSERT INTO `sys_config` VALUES (3,'主框架页-侧边栏主题','sys_index_sideTheme','theme-dark','Y','深色主题theme-dark，浅色主题theme-light','1','1','2021-03-20 13:31:12.721','2021-03-20 13:31:12.721',NULL); COMMIT; -- -- Table structure for table `sys_role` -- BEGIN; INSERT INTO `sys_role` VALUES (1,'系统管理员','0','admin',1,'','1','','',1,'','2021-03-20 13:31:12.721','2021-08-16 18:56:36.987',NULL); INSERT INTO `sys_role` VALUES (2,'普通用户','0','normal',1,'','19','','',0,'','2021-07-29 09:46:08.396','2021-07-29 15:53:49.686',NULL); /*!40000 ALTER TABLE `sys_role` ENABLE KEYS */; COMMIT; BEGIN; /*!40000 ALTER TABLE `sys_user` DISABLE KEYS */; INSERT INTO `sys_user` VALUES (1,0,'admin','$2a$10$PNyjE./amTBTtu5HVBl5o.GkhUcMLsZYgYNbrdKKaIXMMPCiZH1Pe','admin','13818888888',1,'','','0','2222222222@qq.com',1,1,'1','1','','0','2021-03-20 13:31:12.721','2021-07-29 15:50:07.630',NULL); COMMIT; BEGIN; INSERT INTO `sys_setting` VALUES (1,'Redux设备管理系统','https://gitee.com/mydearzwj/image/raw/master/img/device-manage.png','2021-03-20 13:31:12.721','2021-03-20 13:31:12.721',NULL); /*!40000 ALTER TABLE `sys_setting` ENABLE KEYS */; COMMIT; -- -- Dumping data for table `bus_group` -- BEGIN; /*!40000 ALTER TABLE `bus_group` DISABLE KEYS */; INSERT INTO `bus_group` VALUES (1,'basegroup',0,1,'base group of all.','1','1','2021-06-19 15:28:58.320','2021-06-19 15:28:58.320',1); /*!40000 ALTER TABLE `bus_group` ENABLE KEYS */; COMMIT; -- Dump completed on 2021-08-16 19:04:41