mirror of
https://gitee.com/beifeng_java/gulimall.git
synced 2025-12-26 07:16:29 +08:00
17 lines
1.0 KiB
SQL
17 lines
1.0 KiB
SQL
-- 菜单SQL
|
||
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
||
VALUES ('1', '首页专题表【jd首页下面很多专题，每个专题链接新的页面，展示专题商品信息】', 'coupon/homesubject', NULL, '1', 'config', '6');
|
||
|
||
-- 按钮父菜单ID
|
||
set @parentId = @@identity;
|
||
|
||
-- 菜单对应按钮SQL
|
||
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
||
SELECT @parentId, '查看', null, 'coupon:homesubject:list,coupon:homesubject:info', '2', null, '6';
|
||
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
||
SELECT @parentId, '新增', null, 'coupon:homesubject:save', '2', null, '6';
|
||
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
||
SELECT @parentId, '修改', null, 'coupon:homesubject:update', '2', null, '6';
|
||
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
|
||
SELECT @parentId, '删除', null, 'coupon:homesubject:delete', '2', null, '6';
|