ylrz_saas_his_scrm/sql/add_sms_device_menu.sql

-- =====================================================
-- adminUI 总后台菜单补充 - 设备管理(smsDevice)
-- 挂载到 通信管理(2400) 分组下，order_num=11(在卡管理之前)
-- =====================================================

-- 设备管理 (menu_id=2413)
INSERT INTO fs_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, is_frame, is_cache, create_by, create_time, remark)
VALUES (2413, '设备管理', 2400, 11, 'smsDevice', 'admin/smsDevice/index', 'C', 'el-icon-mobile-phone', '0', '0', 0, 0, 'admin', NOW(), '手机设备管理');

-- 设备管理按钮权限
INSERT INTO fs_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, perms, icon, visible, status, is_frame, is_cache, create_by, create_time)
VALUES
(24131, '设备查询', 2413, 1, '', '', 'F', 'platform:smsDevice:list',   '#', '0', '0', 0, 0, 'admin', NOW()),
(24132, '设备详情', 2413, 2, '', '', 'F', 'platform:smsDevice:query',  '#', '0', '0', 0, 0, 'admin', NOW()),
(24133, '设备新增', 2413, 3, '', '', 'F', 'platform:smsDevice:add',    '#', '0', '0', 0, 0, 'admin', NOW()),
(24134, '设备修改', 2413, 4, '', '', 'F', 'platform:smsDevice:edit',   '#', '0', '0', 0, 0, 'admin', NOW()),
(24135, '设备删除', 2413, 5, '', '', 'F', 'platform:smsDevice:remove', '#', '0', '0', 0, 0, 'admin', NOW());

-- 将新菜单关联到admin角色(role_id=1)
INSERT INTO fs_role_menu (role_id, menu_id) VALUES
(1, 2413),
(1, 24131),
(1, 24132),
(1, 24133),
(1, 24134),
(1, 24135);