water/server/plugin/saiadmin/db/20260818_add_device_management_menu.sql

-- Device management menu. This statement is safe to run repeatedly.
INSERT INTO `sa_system_menu` (
    `parent_id`, `name`, `code`, `slug`, `type`, `path`, `component`, `method`, `icon`, `sort`,
    `link_url`, `is_iframe`, `is_keep_alive`, `is_hidden`, `is_fixed_tab`, `is_full_page`,
    `generate_id`, `generate_key`, `status`, `remark`, `created_by`, `updated_by`, `create_time`, `update_time`, `delete_time`
)
SELECT
    0, CONVERT(0xE8AEBEE5A487E7AEA1E79086 USING utf8mb4), 'Device', NULL, 2, '/device', '/device/index', NULL, 'ri:router-line', 90,
    NULL, 2, 2, 2, 2, 2,
    0, NULL, 1, CONVERT(0xE8AEBEE5A487204D51545420E7AEA1E79086E585A5E58FA3 USING utf8mb4), 1, 1, NOW(), NOW(), NULL
WHERE NOT EXISTS (
    SELECT 1
    FROM `sa_system_menu`
    WHERE `path` = '/device' AND `delete_time` IS NULL
);