- 添加模型参数配置主菜单(菜单ID: 2082) - 添加模型参数查询按钮权限(菜单ID: 2083) - 添加模型参数保存按钮权限(菜单ID: 2084) - 父菜单: 信息维护(菜单ID: 2000)
32 lines
1.0 KiB
SQL
32 lines
1.0 KiB
SQL
-- 模型参数配置菜单权限
|
|
-- 创建时间: 2026-02-26
|
|
|
|
-- 添加模型参数配置菜单(父菜单为信息维护)
|
|
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
|
|
VALUES (
|
|
'模型参数配置',
|
|
2000,
|
|
10,
|
|
'modelParam',
|
|
'ccdi/modelParam/index',
|
|
1,
|
|
0,
|
|
'C',
|
|
'0',
|
|
'0',
|
|
'ccdi:modelParam:list',
|
|
'edit',
|
|
'admin',
|
|
NOW(),
|
|
'模型参数配置菜单'
|
|
);
|
|
|
|
-- 获取刚插入的菜单ID
|
|
SET @model_param_menu_id = LAST_INSERT_ID();
|
|
|
|
-- 添加按钮权限
|
|
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
|
|
VALUES
|
|
('模型参数查询', @model_param_menu_id, 1, '#', '', 1, 0, 'F', '0', '0', 'ccdi:modelParam:query', '#', 'admin', NOW(), ''),
|
|
('模型参数保存', @model_param_menu_id, 2, '#', '', 1, 0, 'F', '0', '0', 'ccdi:modelParam:save', '#', 'admin', NOW(), '');
|