payment-platform/java/sql/003_service_provider_menu.sql

WITH system_menu AS (
    SELECT id FROM sys_menu WHERE name = '系统管理' AND type = 1 AND status = '0' LIMIT 1
),
inserted AS (
    INSERT INTO sys_menu (name, type, "order", permission, icon, route_name, route_path, component_path,
                          redirect, hidden, keep_alive, always_show, affix, title, params,
                          uuid, parent_id, status, created_time, updated_time)
    SELECT '服务商管理', 2, 99,
           'module_system:service_provider:list',
           'provider', 'ServiceProvider', '/service-provider', 'views/module_system/service_provider/index.vue',
           null, false, true, false, false, '服务商管理', null,
           gen_random_uuid(),
           system_menu.id, '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
    FROM system_menu
    WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE name = '服务商管理' AND status = '0')
    RETURNING id
)
INSERT INTO sys_role_menu (role_id, menu_id)
SELECT 1, id FROM inserted;