apiview
/
apiviewmenu.sql

-- 增加主菜单
INSERT INTO ry.sys_menu (menu_id, menu_name, parent_id, order_num, url, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
VALUES (2006, '接口文档', 0, 5, '#', 'M', '0', '', 'fa fa-anchor', 'admin', '2018-09-10 23:37:06', '', null, '');

-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('域名管理', '2006', '1', '/module/domain', 'C', '0', 'module:domain:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '域名管理菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('域名管理查询', @parentId, '1',  '#',  'F', '0', 'module:domain:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('域名管理新增', @parentId, '2',  '#',  'F', '0', 'module:domain:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('域名管理修改', @parentId, '3',  '#',  'F', '0', 'module:domain:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('域名管理删除', @parentId, '4',  '#',  'F', '0', 'module:domain:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口项目', '2006', '1', '/module/project', 'C', '0', 'module:project:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '接口项目菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口项目查询', @parentId, '1',  '#',  'F', '0', 'module:project:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口项目新增', @parentId, '2',  '#',  'F', '0', 'module:project:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口项目修改', @parentId, '3',  '#',  'F', '0', 'module:project:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口项目删除', @parentId, '4',  '#',  'F', '0', 'module:project:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');


-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口模块', '2006', '1', '/module/connector', 'C', '0', 'module:connector:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '接口模块菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口模块查询', @parentId, '1',  '#',  'F', '0', 'module:connector:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口模块新增', @parentId, '2',  '#',  'F', '0', 'module:connector:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口模块修改', @parentId, '3',  '#',  'F', '0', 'module:connector:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口模块删除', @parentId, '4',  '#',  'F', '0', 'module:connector:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');


-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('错误代码', '2006', '1', '/module/errorcode', 'C', '0', 'module:errorcode:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '错误代码菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('错误代码查询', @parentId, '1',  '#',  'F', '0', 'module:errorcode:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('错误代码新增', @parentId, '2',  '#',  'F', '0', 'module:errorcode:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('错误代码修改', @parentId, '3',  '#',  'F', '0', 'module:errorcode:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('错误代码删除', @parentId, '4',  '#',  'F', '0', 'module:errorcode:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');


-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('请求参数', '2006', '1', '/module/parameter', 'C', '0', 'module:parameter:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '请求参数菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('请求参数查询', @parentId, '1',  '#',  'F', '0', 'module:parameter:list',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('请求参数新增', @parentId, '2',  '#',  'F', '0', 'module:parameter:add',          '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('请求参数修改', @parentId, '3',  '#',  'F', '0', 'module:parameter:edit',         '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');

insert into sys_menu  (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('请求参数删除', @parentId, '4',  '#',  'F', '0', 'module:parameter:remove',       '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '');


insert into sys_menu (menu_name, parent_id, order_num, url,menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('接口查看', '2006', '1', '/module/apiview', 'C', '0', 'module:apiview:view', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '接口查看菜单');