-- 系统管理-角色：补齐系统内置合作商类角色

INSERT INTO sys_role (role_name, role_key, data_scope, status, del_flag, create_by, create_time, remark)
SELECT '场地方', 'site_owner', '5', '0', '0', 'admin', NOW(), '系统内置角色'
WHERE NOT EXISTS (
    SELECT 1 FROM sys_role
    WHERE del_flag = '0' AND (role_name = '场地方' OR role_key = 'site_owner')
);

UPDATE sys_role
SET role_name = '场地方',
    role_key = 'site_owner',
    status = '0',
    del_flag = '0',
    remark = '系统内置角色',
    update_by = 'admin',
    update_time = NOW()
WHERE role_name = '场地方' OR role_key = 'site_owner';

INSERT INTO sys_role (role_name, role_key, data_scope, status, del_flag, create_by, create_time, remark)
SELECT '服务商', 'service_provider', '5', '0', '0', 'admin', NOW(), '系统内置角色'
WHERE NOT EXISTS (
    SELECT 1 FROM sys_role
    WHERE del_flag = '0' AND (role_name = '服务商' OR role_key = 'service_provider')
);

UPDATE sys_role
SET role_name = '服务商',
    role_key = 'service_provider',
    status = '0',
    del_flag = '0',
    remark = '系统内置角色',
    update_by = 'admin',
    update_time = NOW()
WHERE role_name = '服务商' OR role_key = 'service_provider';