| | |
| | | comment on column lf.sys_menu.update_time is '更新时间'; |
| | | comment on column lf.sys_menu.bak is '备注'; |
| | | --alter table lf.sys_menu alter column bak type varchar(1024); |
| | | --alter sequence lf.sys_menu_id_seq restart with 45; |
| | | --alter sequence lf.sys_menu_id_seq restart with 44; |
| | | |
| | | select * from lf.sys_menu order by order_num; |
| | | ----------------------------------------------------------------------------------------------------- 2.单位表 |
| | |
| | | id,pid,cn_name,en_name,url,perms,type,icon,level,order_num,is_show,create_user,create_time,update_user,update_time,bak |
| | | 1,0,管道基础大数据平台,Pipeline Basic Big Data Platform,,,0,,0,1,0,1,,,, |
| | | 1,0,管道基础大数据平台,Pipeline Basic Big Data Platform,,/perms,0,,0,1,0,1,,,, |
| | | 2,1,综合展示,Comprehensive Display,,,1,,1,2,1,1,,,, |
| | | 3,2,综合展示,Comprehensive Display,Synthesis,,1,,2,3,1,1,,,, |
| | | 3,2,综合展示,Comprehensive Display,Synthesis,/comprehensive,1,,2,3,1,1,,,, |
| | | 4,3,图层,Coverage,,,2,,3,4,1,1,,,, |
| | | 5,3,视图,Viewport,,,2,,3,5,1,1,,,, |
| | | 6,3,漫游,Wander,,,2,,3,6,1,1,,,, |
| | |
| | | 9,3,定位,Orientation,,,2,,3,9,1,1,,,, |
| | | 10,3,测量,Measurement,,,2,,3,10,1,1,,,, |
| | | 11,3,标绘,Plotting,,,2,,3,11,1,1,,,, |
| | | 12,2,专题图,Thematic Maps,Thematic,,1,,2,12,1,1,,,, |
| | | 13,2,资料馆,Data Library,Archive,,1,,2,13,1,1,,,, |
| | | 12,2,专题图,Thematic Maps,Thematic,/thematic,1,,2,12,1,1,,,, |
| | | 13,2,资料馆,Data Library,Archive,/dataLib,1,,2,13,1,1,,,, |
| | | 14,1,数据管理,Data Manage,,,1,,1,14,1,1,,,, |
| | | 15,6,数据上传,Data Updata,dataUpdata,,1,,2,15,1,1,,,, |
| | | 16,6,目录管理,Catalogue Management,catalogueManage,,1,,2,16,1,1,,,, |
| | | 17,6,数据检索,Data Query,,,1,,2,17,1,1,,,, |
| | | 18,6,版本管理,Version Management,versionManage,,1,,2,18,1,1,,,, |
| | | 19,6,字典管理,Dictionary Management,dictionaryManage,,1,,2,19,1,1,,,, |
| | | 20,6,元数据管理,Metadata Management,metadataManage,,1,,2,20,1,1,,,, |
| | | 21,6,样式管理,Style Management,styleManage,,1,,2,21,1,1,,,, |
| | | 15,6,数据上传,Data Updata,dataUpdata,/uploader,1,,2,15,1,1,,,, |
| | | 16,6,目录管理,Catalogue Management,catalogueManage,/dir,1,,2,16,1,1,,,, |
| | | 17,6,数据检索,Data Query,SpatialData,/dataQuery,1,,2,17,1,1,,,, |
| | | 18,6,版本管理,Version Management,versionManage,/ver,1,,2,18,1,1,,,, |
| | | 19,6,字典管理,Dictionary Management,dictionaryManage,/dict,1,,2,19,1,1,,,, |
| | | 20,6,元数据管理,Metadata Management,metadataManage,/meta,1,,2,20,1,1,,,, |
| | | 21,6,样式管理,Style Management,styleManage,/style,1,,2,21,1,1,,,, |
| | | 22,1,运维管理,Operat Management,,,1,,1,22,1,1,,,, |
| | | 23,22,系统管理,System Management,,,1,,2,23,1,1,,,, |
| | | 24,23,菜单管理,Menu Management,menuSettings,,1,,3,24,1,1,,,, |
| | | 25,23,用户管理,User Management,userInfoManage,,1,,3,25,1,1,,,, |
| | | 26,23,单位管理,Organization Management,orgManage,,1,,3,26,1,1,,,, |
| | | 27,23,资源管理,Resource Management,,,1,,3,27,0,1,,,, |
| | | 28,23,角色管理,Role Management,roleManage,,1,,3,28,1,1,,,, |
| | | 29,23,权限管理,Permission Management,authorityManage,,1,,3,29,1,1,,,, |
| | | 24,23,菜单管理,Menu Management,menuSettings,/menu,1,,3,24,1,1,,,, |
| | | 25,23,用户管理,User Management,userInfoManage,/user,1,,3,25,1,1,,,, |
| | | 26,23,单位管理,Organization Management,orgManage,/dep,1,,3,26,1,1,,,, |
| | | 27,23,资源管理,Resource Management,resourceManage,/res,1,,3,27,0,1,,,, |
| | | 28,23,角色管理,Role Management,roleManage,/role,1,,3,28,1,1,,,, |
| | | 29,23,权限管理,Permission Management,authorityManage,/auth,1,,3,29,1,1,,,, |
| | | 30,22,授权管理,Authorization Management,,,1,,2,30,1,1,,,, |
| | | 31,30,用户角色授权,User Role Authorization,,,1,,3,31,1,1,,,, |
| | | 32,30,角色菜单授权,Role Menu Authorization,,,1,,3,32,1,1,,,, |
| | | 33,30,菜单权限授权,Menu Permission Authorization,,,1,,3,33,1,1,,,, |
| | | 34,30,角色资源授权,Role Resource Authorization,,,1,,3,34,0,1,,,, |
| | | 35,22,运维监控,Operation And Monitoring,,,1,,2,35,1,1,,,, |
| | | 36,35,登录日志,Login Log,logLog,,1,,3,36,1,1,,,, |
| | | 37,35,操作日志,Operation Log,eventlogManage,,1,,3,37,1,1,,,, |
| | | 38,35,资源日志,Resource Log,operationLog,,1,,3,38,1,1,,,, |
| | | 39,35,令牌管理,Token Management,tokentool,,1,,3,39,1,1,,,, |
| | | 40,35,黑/白名单,Black/White List,http://192.168.20.39:12316/sign/toDruid?token=,,1,,3,40,1,1,,,,blackwhiteList |
| | | 41,35,数据库监控,Database Monitoring,databaseMonitoring,,1,,3,41,1,1,,,, |
| | | 42,35,系统监控,System Monitoring,systemMonitoring,,1,,3,42,1,1,,,, |
| | | 43,22,系统配置,System Configuration,parameterConfiguration,,1,,2,43,1,1,,,, |
| | | 31,30,用户角色授权,User Role Authorization,userRoleAuthorization,/roleUser,1,,3,31,1,1,,,, |
| | | 32,30,角色菜单授权,Role Menu Authorization,roleMenuAuthorization,/roleMenuAuth,1,,3,32,1,1,,,, |
| | | 33,30,菜单权限授权,Menu Permission Authorization,menuRoleAuthorization,/menuAuth,1,,3,33,1,1,,,, |
| | | 34,30,角色资源授权,Role Resource Authorization,roleResAuthorization,/roleRes,1,,3,34,0,1,,,, |
| | | 35,22,运维监控,Operation And Monitoring,,/ctrl,1,,2,35,1,1,,,, |
| | | 36,35,登录日志,Login Log,logLog,/login,1,,3,36,1,1,,,, |
| | | 37,35,操作日志,Operation Log,eventlogManage,/operate,1,,3,37,1,1,,,, |
| | | 38,35,资源日志,Resource Log,operationLog,/resOp,1,,3,38,1,1,,,, |
| | | 39,35,令牌管理,Token Management,tokentool,/token,1,,3,39,1,1,,,, |
| | | 40,35,黑/白名单,Black/White List,blackwhiteList,/blacklist,1,,3,40,1,1,,,, |
| | | 41,35,数据库监控,Database Monitoring,http://192.168.20.39:12316/sign/toDruid?token=,/sign/toDruid,1,,3,41,1,1,,,, |
| | | 42,35,系统监控,System Monitoring,systemMonitoring,/ws,1,,3,42,1,1,,,, |
| | | 43,22,系统配置,System Configuration,parameterConfiguration,/args,1,,2,43,1,1,,,, |