| 提交 | 用户 | 时间 | ||
| e7c126 | 1 | -- 菜单 SQL |
| H | 2 | INSERT INTO system_menu( |
| 3 | name, permission, type, sort, parent_id, | |
| 4 | path, icon, component, status, component_name | |
| 5 | ) | |
| 6 | VALUES ( | |
| 7 | '分类管理', '', 2, 0, 888, | |
| 8 | 'category', '', 'infra/demo/index', 0, 'InfraCategory' | |
| 9 | ); | |
| 10 | ||
| 11 | -- 按钮父菜单ID | |
| 12 | -- 暂时只支持 MySQL。如果你是 Oracle、PostgreSQL、SQLServer 的话，需要手动修改 @parentId 的部分的代码 | |
| 13 | SELECT @parentId := LAST_INSERT_ID(); | |
| 14 | ||
| 15 | -- 按钮 SQL | |
| 16 | INSERT INTO system_menu( | |
| 17 | name, permission, type, sort, parent_id, | |
| 18 | path, icon, component, status | |
| 19 | ) | |
| 20 | VALUES ( | |
| 21 | '分类查询', 'infra:category:query', 3, 1, @parentId, | |
| 22 | '', '', '', 0 | |
| 23 | ); | |
| 24 | INSERT INTO system_menu( | |
| 25 | name, permission, type, sort, parent_id, | |
| 26 | path, icon, component, status | |
| 27 | ) | |
| 28 | VALUES ( | |
| 29 | '分类创建', 'infra:category:create', 3, 2, @parentId, | |
| 30 | '', '', '', 0 | |
| 31 | ); | |
| 32 | INSERT INTO system_menu( | |
| 33 | name, permission, type, sort, parent_id, | |
| 34 | path, icon, component, status | |
| 35 | ) | |
| 36 | VALUES ( | |
| 37 | '分类更新', 'infra:category:update', 3, 3, @parentId, | |
| 38 | '', '', '', 0 | |
| 39 | ); | |
| 40 | INSERT INTO system_menu( | |
| 41 | name, permission, type, sort, parent_id, | |
| 42 | path, icon, component, status | |
| 43 | ) | |
| 44 | VALUES ( | |
| 45 | '分类删除', 'infra:category:delete', 3, 4, @parentId, | |
| 46 | '', '', '', 0 | |
| 47 | ); | |
| 48 | INSERT INTO system_menu( | |
| 49 | name, permission, type, sort, parent_id, | |
| 50 | path, icon, component, status | |
| 51 | ) | |
| 52 | VALUES ( | |
| 53 | '分类导出', 'infra:category:export', 3, 5, @parentId, | |
| 54 | '', '', '', 0 | |
| 55 | ); | |
