Home Explore Help
Register Sign In
SG
/
pigx-wx-ui38
4
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 33b50b694b
Branches Tags
pigx-wx-ui38
/
pigx-visual
/
pigx-codegen
/
src
/
main
/
resources
/
template
/
menu.sql.vm

menu.sql.vm 1.5 KB
History Raw

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

  2. 

  3. -- 菜单SQL
    4. 

  4. insert into `pigx`.`sys_menu` ( `parent_id`, `component`, `permission`, `type`, `path`, `icon`, `menu_id`, `del_flag`, `create_time`, `sort`, `update_time`, `name`)
    5. 

  5.     values ( '父菜单ID', 'views/${moduleName}/${pathName}/index', '菜单ID', '0', '${pathName}', 'icon-bangzhushouji', '8', '0', '2018-01-20 13:17:19', '8', '2018-07-29 13:38:19', '${comments}管理');
    6. 

  6. 

  7. -- 菜单对应按钮SQL
    8. 

  8. insert into `pigx`.`sys_menu` ( `parent_id`, `component`, `permission`, `type`, `path`, `icon`, `menu_id`, `del_flag`, `create_time`, `sort`, `update_time`, `name`)
    9. 

  9.     values ( '子按钮ID1', null, '${moduleName}_${pathName}_add', '1', null, '1', '菜单ID', '0', '2018-05-15 21:35:18', '0', '2018-07-29 13:38:59', '${comments}新增');
    10. 

  10. insert into `pigx`.`sys_menu` ( `parent_id`, `component`, `permission`, `type`, `path`, `icon`, `menu_id`, `del_flag`, `create_time`, `sort`, `update_time`, `name`)
    11. 

  11.     values ( '子按钮ID2', null, '${moduleName}_${pathName}_edit', '1', null, '1', '菜单ID', '0', '2018-05-15 21:35:18', '1', '2018-07-29 13:38:59', '${comments}修改');
    12. 

  12. insert into `pigx`.`sys_menu` ( `parent_id`, `component`, `permission`, `type`, `path`, `icon`, `menu_id`, `del_flag`, `create_time`, `sort`, `update_time`, `name`)
    13. 

  13.     values ( '子按钮ID3', null, '${moduleName}_${pathName}_del', '1', null, '1', '菜单ID', '0', '2018-05-15 21:35:18', '2', '2018-07-29 13:38:59', '${comments}删除');
    14.