insert into sys_menu (menu_name, menu_key, component, parent_id, target, order_num, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('${functionName}管理', '${businessName}', '${moduleName}/${ClassName}List','1', '', '1', 'C', '0', '${permissionPrefix}:view', '#', 'admin', '${nowDate}', 'ry', '${nowDate}', '${functionName}菜单');

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

-- 按钮 SQL
insert into sys_menu  (menu_name, menu_key, component, parent_id, target, order_num, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('${functionName}查询', '', NULL, @parentId, '', '1',  'F', '0', '${permissionPrefix}:list',         '#', 'admin', '${nowDate}', 'ry', '${nowDate}', '');

insert into sys_menu  (menu_name, menu_key, component, parent_id, target, order_num, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('${functionName}新增', '', NULL, @parentId, '', '2',  'F', '0', '${permissionPrefix}:add',          '#', 'admin', '${nowDate}', 'ry', '${nowDate}', '');

insert into sys_menu  (menu_name, menu_key, component, parent_id, target, order_num, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('${functionName}修改', '', NULL, @parentId, '', '3',  'F', '0', '${permissionPrefix}:edit',         '#', 'admin', '${nowDate}', 'ry', '${nowDate}', '');

insert into sys_menu  (menu_name, menu_key, component, parent_id, target, order_num, menu_type, visible, perms, icon, create_by, create_time, update_by, update_time, remark)
values('${functionName}删除', '', NULL, @parentId, '', '4',  'F', '0', '${permissionPrefix}:remove',       '#', 'admin', '${nowDate}', 'ry', '${nowDate}', '');
