You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
925 B
17 lines
925 B
-- 菜单SQL
|
|
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `order_num`)
|
|
VALUES ('0', '${comments}', 'admin/${pathName}.html', NULL, '1', '6');
|
|
|
|
-- 按钮父菜单ID
|
|
set @parentId = @@identity;
|
|
|
|
-- 菜单对应按钮SQL
|
|
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
|
SELECT @parentId, '查看', null, '${pathName}:list,${pathName}:info', '2', null, '6';
|
|
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
|
SELECT @parentId, '新增', null, '${pathName}:save', '2', null, '6';
|
|
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
|
SELECT @parentId, '修改', null, '${pathName}:update', '2', null, '6';
|
|
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
|
SELECT @parentId, '删除', null, '${pathName}:delete', '2', null, '6';
|