56 lines
4.1 KiB
SQL
56 lines
4.1 KiB
SQL
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
|
||
VALUES (2422, '质检配置表', 2421, 0, 'fiihconfig', 'mes/fiih/index', NULL, 1, 0, 'C', '0', '0', 'fiih:config:list', '#', 'YAVII', '2025-11-01 16:21:41', 'YAVII', '2025-11-01 16:26:31', '');
|
||
|
||
|
||
|
||
-- =============================================
|
||
-- FIIH数据管理按钮权限（parent_id = 2426）
|
||
-- =============================================
|
||
|
||
-- 4. FIIH数据查询按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2423, 'FIIH数据查询', 2421, 1, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:query', '#', 'admin', NOW());
|
||
|
||
-- 5. FIIH数据新增按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2424, 'FIIH数据新增', 2421, 2, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:add', '#', 'admin', NOW());
|
||
|
||
-- 6. FIIH数据修改按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2425, 'FIIH数据修改', 2421, 3, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:edit', '#', 'admin', NOW());
|
||
|
||
-- 7. FIIH数据删除按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2426, 'FIIH数据删除', 2421, 4, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:remove', '#', 'admin', NOW());
|
||
|
||
-- 8. FIIH数据导出按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2427, 'FIIH数据导出', 2421, 5, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:export', '#', 'admin', NOW());
|
||
|
||
-- 9. FIIH数据列表
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2428, 'FIIH数据列表', 2421, 6, '#', '', 1, 0, 'F', '0', '0', 'fiih:data:list', '#', 'admin', NOW());
|
||
|
||
-- =============================================
|
||
-- 质检配置表按钮权限（parent_id = 2422）
|
||
-- =============================================
|
||
|
||
-- 9. 质检配置查询按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2429, '质检配置查询', 2422, 1, '#', '', 1, 0, 'F', '0', '0', 'fiih:config:query', '#', 'admin', NOW());
|
||
|
||
-- 10. 质检配置新增按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2430, '质检配置新增', 2422, 2, '#', '', 1, 0, 'F', '0', '0', 'fiih:config:add', '#', 'admin', NOW());
|
||
|
||
-- 11. 质检配置修改按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2431, '质检配置修改', 2422, 3, '#', '', 1, 0, 'F', '0', '0', 'fiih:config:edit', '#', 'admin', NOW());
|
||
|
||
-- 12. 质检配置删除按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2432, '质检配置删除', 2422, 4, '#', '', 1, 0, 'F', '0', '0', 'fiih:config:remove', '#', 'admin', NOW());
|
||
|
||
-- 13. 质检配置导出按钮
|
||
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time)
|
||
VALUES (2433, '质检配置导出', 2422, 5, '#', '', 1, 0, 'F', '0', '0', 'fiih:config:export', '#', 'admin', NOW()); |