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

-- Convert the device page into a menu directory and add its child menus.
UPDATE `sa_system_menu`
SET `type` = 1, `component` = NULL, `update_time` = NOW()
WHERE `path` = '/device' AND `delete_time` IS NULL;

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
    (SELECT `id` FROM `sa_system_menu` WHERE `path` = '/device' AND `delete_time` IS NULL LIMIT 1),
    CONVERT(0xE68891E79A84E8AEBEE5A487 USING utf8mb4), 'MyDevice', NULL, 2, 'my-devices', '/device/my-devices', NULL, 'ri:hard-drive-2-line', 100,
    NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL
WHERE NOT EXISTS (
    SELECT 1 FROM `sa_system_menu` WHERE `component` = '/device/my-devices' AND `delete_time` IS NULL
);

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
    (SELECT `id` FROM `sa_system_menu` WHERE `path` = '/device' AND `delete_time` IS NULL LIMIT 1),
    CONVERT(0xE4B88BE7BAA7E8AEBEE5A487 USING utf8mb4), 'SubordinateDevice', NULL, 2, 'subordinate-devices', '/device/subordinate-devices', NULL, 'ri:git-branch-line', 90,
    NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL
WHERE NOT EXISTS (
    SELECT 1 FROM `sa_system_menu` WHERE `component` = '/device/subordinate-devices' AND `delete_time` IS NULL
);

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
    (SELECT `id` FROM `sa_system_menu` WHERE `path` = '/device' AND `delete_time` IS NULL LIMIT 1),
    CONVERT(0xE8AEBEE5A487E4BA8CE7BBB4E7A081 USING utf8mb4), 'DeviceQrcode', NULL, 2, 'qrcode', '/device/qrcode', NULL, 'ri:qr-code-line', 80,
    NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL
WHERE NOT EXISTS (
    SELECT 1 FROM `sa_system_menu` WHERE `component` = '/device/qrcode' AND `delete_time` IS NULL
);