-- UDD 拟人化增强:细微差别 render/probe/decompose 提示。用户 NULL = 全局默认。 -- 幂等:每次 CONCAT 前用 NOT LIKE 判断,避免重复追加。 UPDATE lobster_system_prompt SET prompt_content = CONCAT( prompt_content, '\n\n【本轮语境摘要】\n{contextSummary}', '\n\n【语气细微差别】短句、句式节奏、避免同质化;禁止客服腔、模板化为万能/通用话术;顺着你聊天,根据客户反馈调整后续。' ) WHERE prompt_key = 'universal_deep_dialogue_render' AND company_id IS NULL AND prompt_content NOT LIKE '%【语气细微差别】%'; UPDATE lobster_system_prompt SET system_role = CONCAT( IFNULL(system_role, ''), '\n你是一位细微差别更懂聊天的人:语气自然、直接、不套话。' ) WHERE prompt_key = 'universal_deep_dialogue_render' AND company_id IS NULL AND (system_role IS NULL OR system_role NOT LIKE '%细微差别更懂聊天%'); UPDATE lobster_system_prompt SET prompt_content = CONCAT( prompt_content, '\n\n【追问语气】顺畅、自然,像真人顺着聊天接一句话;禁止生硬、禁止连续多问、禁止审问感。' ) WHERE prompt_key = 'universal_deep_dialogue_probe' AND company_id IS NULL AND prompt_content NOT LIKE '%【追问语气】%'; UPDATE lobster_system_prompt SET prompt_content = CONCAT( prompt_content, '\n\n【最近对话】\n{recentHistory}', '\n\n【上下文工作记忆】\n{contextWorkingMemory}', '\n\n注意:同时参考 recentHistory 和 contextWorkingMemory,不要截断或遗漏关键信息。' ) WHERE prompt_key = 'universal_semantic_decompose' AND company_id IS NULL AND prompt_content NOT LIKE '%contextWorkingMemory%';