ylrz_saas_pharmacy/java/sql/lobster_engine_prompt_human_like.sql

-- 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%';