sql/init.sql · senvon/启路框架-用户权限模块

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 1 Fork 1

senvon/启路框架-用户权限模块

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

dev

分支 (3)

管理

dev

master

1.0.0_release

该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。

项目仓库所选许可证以仓库主分支所使用许可证为准

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 3

标签 0

user

sql

init.sql

init.sql 16.48 KB

insert into sys_user_info (id, tenant_code, dept_code, login_name, user_name, email, phone_number, sex, password, salt, status, create_by, create_time, update_by, update_time, remark) 
values('1',null,null,'admin','超级管理员','11@11.j','13111111111','2','24cad132637992f78ed216fd957b6256b64c95e8bea39e4b','4d27282f56645b34','1','admin','2019年07月30日 16:21:34','','2019年08月08日 17:01:12',null);

insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('1','COMMON_BOOL_YES','1','是','1','COMMON_BOOL','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('2','COMMON_BOOLEAN_NO','2','否','2','COMMON_BOOL','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('3','COMMON_SEX_MALE','1','男','1','COMMON_SEX','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('4','COMMON_SEX_FEMALE','2','女','2','COMMON_SEX','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('5','MENU_TYPE_BUTTON','3','功能','3','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('6','MENU_TYPE_MENU','2','菜单','2','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('7','MENU_TYPE_DIC','1','目录','1','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('8','COMMON_STATUS_S','1','成功','1','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('9','COMMON_STATUS_F','2','失败','2','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('10','COMMON_STATUS_P','3','处理中','3','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('11','LOG_TYPE_IN','1','登录','1','LOG_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('12','LOG_TYPE_OUT','2','登出','2','LOG_TYPE','','0','',null,'',null,'');

/*data for the table sys_dict_type_info */

insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('1','通用布尔','COMMON_BOOL','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('2','性别','COMMON_SEX','1','',Null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('3','菜单类型','MENU_TYPE','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('4','通用状态','COMMON_STATUS','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('5','登录类型','LOG_TYPE','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('6','身份类型','CREDENTIAL_TYPE','1','',null,'',null,'');

/*data for the table sys_menu_info */

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1','系统管理','0','1','#','/system','layout','1','1','','fa fa-gear','admin','2018年03月16日 11:33:00','ry','2018年03月16日 11:33:00','系统管理目录');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('100','配置管理','1','1','s/configInfo/showList','configInfo', 'system/configinfo/index','2','1','user:configInfo:search','#','admin','2018年03月16日 11:33:00','ry','2018年03月16日 11:33:00','配置管理');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1001','配置新增','100','1','#','#','#','3','1','user:configInfo:add','#','admin','2018年03月16日 11:33:00','ry','2018年03月16日 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1002','配置修改','100','2','#','#','#','3','1','user:configInfo:edit','#','admin','2018年03月16日 11:33:00','ry','2018年03月16日 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1003','配置删除','100','3','#','#','#','3','1','user:configInfo:remove','#','admin','2018年03月16日 11:33:00','ry','2018年03月16日 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('102','菜单管理','1','3','s/menuInfo/showList', 'menuInfo', 'system/menuinfo/index','2','1','user:menuInfo:search','#','admin',null,'ry',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1021','菜单查询','102','1','#','#','#','3','0','','','',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1022','菜单新增','102','2','#','#','#','3','1','user:menuInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1023','菜单编辑','102','3','#','#','#','3','1','user:menuInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1024','菜单删除','102','4','#','#','#','3','1','user:menuInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('103','字典管理','1','4','s/dictInfo/showList', 'dictInfo', 'system/dictinfo/index','2','1','user:dictInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1031','字典新增','103','1','#','#','#','3','1','user:dictInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1032','字典编辑','103','2','#','#','#','3','1','user:dictInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1033','字典删除','103','3','#','#','#','3','1','user:dictInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('104','操作日志','1','5','s/operLogInfo/showList', 'operLogInfo', 'system/log/operloginfo/index','2','1','user:operLog:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1041','日志删除','104','1','#','#','#','3','1','user:operLog:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1042','日志查看','104','2','#','#','#','3','1','user:operLog:detail','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1043','日志清除','104','3','#','#','#','3','1','user:operLog:clear','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('105','在线用户','1','6','s/onlineInfo/showList','onlineinfo', 'system/monitoring/onlineinfo/index','2','1','user:onlineInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1051','强制退出','105','1','#','#','#','3','1','user:onlineInfo:forceLogout','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1052','批量强制退出','105','2','#','#','#','3','1','user:onlineInfo:batchForceLogout','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('106','登录日志','1','7','s/loginInfo/showList', 'onlineInfo', 'system/log/logininfo/index','2','1','user:loginInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1061','删除日志','106','1','#','#','#','3','1','user:onlineInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('107','组织管理','1','8','s/deptInfo/showList','deptInfo', 'system/deptinfo/index','2','1','user:deptInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1071','新增组织','107','1','#','#','#','3','1','user:deptInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1072','修改组织','107','2','#','#','#','3','1','user:deptInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1073','删除组织','107','3','#','#','#','3','1','user:deptInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('108','角色管理','1','9','s/roleInfo/showList', 'roleInfo', 'system/roleinfo/index','2','1','user:roleInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1081','新增角色','108','1','#','#','#','3','1','user:roleInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1082','修改角色','108','2','#','#','#','3','1','user:roleInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1083','删除角色','108','3','#','#','#','3','1','user:roleInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('109','用户管理','1','10','s/userInfo/showList', 'userInfo', 'system/userinfo/index','2','1','user:userInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1091','新增用户','109','1','#','#','#','3','1','user:userInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1092','修改用户','109','2','#','#','#','3','1','user:userInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1093','删除用户','109','3','#','#','#','3','1','user:userInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1094','修改密码','109','4','#','#','#','3','1','user:userInfo:resetPwd','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1095','委派','109','5','#','#','#','3','1','user:userInfo:credential','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('110','身份管理','1','11','s/userCredential/showList', 'userCredential', 'system/usercredential/index','2','1','user:userCredential:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1101','删除身份','110','1','#','#','#','3','1','user:userCredential:remove','#','admin',null,'',null,'');

insert into sys_config_info (id , config_name,config_key,config_value,create_by,remark) values(1 , '菜单显示方式' , 'MENU_SHOW_TYPE' , 'left' , 'admin','菜单显示方式,left:显示在左边,top:显示在上面');

一键复制编辑原始数据按行查看历史

senvon 提交于 2024年04月17日 10:37 +08:00 . 1.1.0提交

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80

insert into sys_user_info (id, tenant_code, dept_code, login_name, user_name, email, phone_number, sex, password, salt, status, create_by, create_time, update_by, update_time, remark) 
values('1',null,null,'admin','超级管理员','11@11.j','13111111111','2','24cad132637992f78ed216fd957b6256b64c95e8bea39e4b','4d27282f56645b34','1','admin','2019-07-30 16:21:34','','2019-08-08 17:01:12',null);

insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('1','COMMON_BOOL_YES','1','是','1','COMMON_BOOL','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('2','COMMON_BOOLEAN_NO','2','否','2','COMMON_BOOL','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('3','COMMON_SEX_MALE','1','男','1','COMMON_SEX','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('4','COMMON_SEX_FEMALE','2','女','2','COMMON_SEX','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('5','MENU_TYPE_BUTTON','3','功能','3','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('6','MENU_TYPE_MENU','2','菜单','2','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('7','MENU_TYPE_DIC','1','目录','1','MENU_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('8','COMMON_STATUS_S','1','成功','1','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('9','COMMON_STATUS_F','2','失败','2','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('10','COMMON_STATUS_P','3','处理中','3','COMMON_STATUS','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('11','LOG_TYPE_IN','1','登录','1','LOG_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('12','LOG_TYPE_OUT','2','登出','2','LOG_TYPE','','0','',null,'',null,'');

insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('13','CREDENTIAL_TYPE_OWNER','1','本职','1','CREDENTIAL_TYPE','','0','',null,'',null,'');
insert into sys_dict_data_info(id,dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,status,create_by,create_time,update_by,update_time,remark) values ('14','CREDENTIAL_TYPE_OUTTER','2','委派','2','CREDENTIAL_TYPE','','0','',null,'',null,'');


/*data for the table sys_dict_type_info */

insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('1','通用布尔','COMMON_BOOL','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('2','性别','COMMON_SEX','1','',Null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('3','菜单类型','MENU_TYPE','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('4','通用状态','COMMON_STATUS','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('5','登录类型','LOG_TYPE','1','',null,'',null,'');
insert into sys_dict_type_info(id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) values ('6','身份类型','CREDENTIAL_TYPE','1','',null,'',null,'');

/*data for the table sys_menu_info */

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1','系统管理','0','1','#','/system','layout','1','1','','fa fa-gear','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统管理目录');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('100','配置管理','1','1','s/configInfo/showList','configInfo', 'system/configinfo/index','2','1','user:configInfo:search','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','配置管理');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1001','配置新增','100','1','#','#','#','3','1','user:configInfo:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1002','配置修改','100','2','#','#','#','3','1','user:configInfo:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1003','配置删除','100','3','#','#','#','3','1','user:configInfo:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('102','菜单管理','1','3','s/menuInfo/showList', 'menuInfo', 'system/menuinfo/index','2','1','user:menuInfo:search','#','admin',null,'ry',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1021','菜单查询','102','1','#','#','#','3','0','','','',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1022','菜单新增','102','2','#','#','#','3','1','user:menuInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1023','菜单编辑','102','3','#','#','#','3','1','user:menuInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1024','菜单删除','102','4','#','#','#','3','1','user:menuInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('103','字典管理','1','4','s/dictInfo/showList', 'dictInfo', 'system/dictinfo/index','2','1','user:dictInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1031','字典新增','103','1','#','#','#','3','1','user:dictInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1032','字典编辑','103','2','#','#','#','3','1','user:dictInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1033','字典删除','103','3','#','#','#','3','1','user:dictInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('104','操作日志','1','5','s/operLogInfo/showList', 'operLogInfo', 'system/log/operloginfo/index','2','1','user:operLog:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1041','日志删除','104','1','#','#','#','3','1','user:operLog:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1042','日志查看','104','2','#','#','#','3','1','user:operLog:detail','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1043','日志清除','104','3','#','#','#','3','1','user:operLog:clear','#','admin',null,'',null,'');


insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('105','在线用户','1','6','s/onlineInfo/showList','onlineinfo', 'system/monitoring/onlineinfo/index','2','1','user:onlineInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1051','强制退出','105','1','#','#','#','3','1','user:onlineInfo:forceLogout','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1052','批量强制退出','105','2','#','#','#','3','1','user:onlineInfo:batchForceLogout','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('106','登录日志','1','7','s/loginInfo/showList', 'onlineInfo', 'system/log/logininfo/index','2','1','user:loginInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1061','删除日志','106','1','#','#','#','3','1','user:onlineInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('107','组织管理','1','8','s/deptInfo/showList','deptInfo', 'system/deptinfo/index','2','1','user:deptInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1071','新增组织','107','1','#','#','#','3','1','user:deptInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1072','修改组织','107','2','#','#','#','3','1','user:deptInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1073','删除组织','107','3','#','#','#','3','1','user:deptInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('108','角色管理','1','9','s/roleInfo/showList', 'roleInfo', 'system/roleinfo/index','2','1','user:roleInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1081','新增角色','108','1','#','#','#','3','1','user:roleInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1082','修改角色','108','2','#','#','#','3','1','user:roleInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1083','删除角色','108','3','#','#','#','3','1','user:roleInfo:remove','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('109','用户管理','1','10','s/userInfo/showList', 'userInfo', 'system/userinfo/index','2','1','user:userInfo:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1091','新增用户','109','1','#','#','#','3','1','user:userInfo:add','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1092','修改用户','109','2','#','#','#','3','1','user:userInfo:edit','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1093','删除用户','109','3','#','#','#','3','1','user:userInfo:remove','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1094','修改密码','109','4','#','#','#','3','1','user:userInfo:resetPwd','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1095','委派','109','5','#','#','#','3','1','user:userInfo:credential','#','admin',null,'',null,'');

insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('110','身份管理','1','11','s/userCredential/showList', 'userCredential', 'system/usercredential/index','2','1','user:userCredential:search','#','admin',null,'',null,'');
insert into sys_menu_info(id,menu_name,parent_id,order_num,url,vue_path,vue_component,menu_type,visible,perms,icon,create_by,create_time,update_by,update_time,remark) values ('1101','删除身份','110','1','#','#','#','3','1','user:userCredential:remove','#','admin',null,'',null,'');


insert into sys_config_info (id , config_name,config_key,config_value,create_by,remark) values(1 , '菜单显示方式' , 'MENU_SHOW_TYPE' , 'left' , 'admin','菜单显示方式,left:显示在左边,top:显示在上面');