generator/src/main/resources/template/menu.sql.vm

-- 该脚本不要执行，请完善 ID 对应关系,注意层级关系 !!!!

-- 菜单SQL
INSERT INTO `tz_sys_menu` (`parent_id`,`url`,`perms`,`type`,`icon`,`order_num`)
    VALUES (0, '${moduleName}/${classname}', '', '1', '', '0');

SET @yamiSysMenuLastInsertId = LAST_INSERT_ID();
INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
    VALUES (@yamiSysMenuLastInsertId, 0, '${comments}管理');
-- 菜单对应按钮SQL

INSERT INTO `tz_sys_menu` (`parent_id`,`url`,`perms`,`type`,`icon`,`order_num`)
    VALUES (@yamiSysMenuLastInsertId, '', '${moduleName}:${classname}:save', '2', '', '0');
SET @ChildInsertId = LAST_INSERT_ID();
INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
    VALUES (@ChildInsertId, 0, '新增${comments}');

INSERT INTO `tz_sys_menu` (`parent_id`,`url`,`perms`,`type`,`icon`,`order_num`)
    VALUES (@yamiSysMenuLastInsertId,  '', '${moduleName}:${classname}:update', '2', '', '0');
SET @ChildInsertId = LAST_INSERT_ID();
INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
    VALUES (@ChildInsertId, 0, '修改${comments}');

INSERT INTO `tz_sys_menu` (`parent_id`,`url`,`perms`,`type`,`icon`,`order_num`)
    VALUES (@yamiSysMenuLastInsertId, '', '${moduleName}:${classname}:delete', '2', '', '0');
SET @ChildInsertId = LAST_INSERT_ID();
INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
    VALUES (@ChildInsertId, 0, '删除${comments}');

SET @yamiSysMenuLastInsertId:=NULL;