Tool_Agent/data/tool_merge/fix_orphan_tool_ids.sql

-- 修复 capability_tool 表中的悬空 tool_id
-- 生成时间: 2026-04-22T13:51:24.263902
-- 总记录数: 200

-- UPDATE: Adobe Firefly -> tools/image_gen/adobe_firefly
UPDATE capability_tool SET tool_id = 'tools/image_gen/adobe_firefly' WHERE capability_id = 'CAP-5a1ac59d' AND tool_id = 'Adobe Firefly';
-- UPDATE: Adobe Photoshop -> tools/image_process/adobe_photoshop
UPDATE capability_tool SET tool_id = 'tools/image_process/adobe_photoshop' WHERE capability_id = 'CAP-3178172e' AND tool_id = 'Adobe Photoshop';
-- UPDATE: After Effects -> tools/image_process/after_effects
UPDATE capability_tool SET tool_id = 'tools/image_process/after_effects' WHERE capability_id = 'CAP-29e214e9' AND tool_id = 'After Effects';
-- UPDATE: After Effects -> tools/image_process/after_effects
UPDATE capability_tool SET tool_id = 'tools/image_process/after_effects' WHERE capability_id = 'CAP-a35e7966' AND tool_id = 'After Effects';
-- DELETE: AI色彩识别算法 -> (no mapping, remove)
DELETE FROM capability_tool WHERE capability_id = 'CAP-021' AND tool_id = 'AI色彩识别算法';
-- UPDATE: canva -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-20409fa6' AND tool_id = 'canva';
-- UPDATE: canva -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-60fe95a7' AND tool_id = 'canva';
-- UPDATE: Canva AI 模板推荐 -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-562d91c1' AND tool_id = 'Canva AI 模板推荐';
-- UPDATE: Canva 品牌色彩套件 -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-2bd87e28' AND tool_id = 'Canva 品牌色彩套件';
-- UPDATE: Canva 文本效果 -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-16c5174b' AND tool_id = 'Canva 文本效果';
-- UPDATE: Canva模板系统 -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-fe53515d' AND tool_id = 'Canva模板系统';
-- UPDATE: ChatGPT + Canva 组合 -> Canva
UPDATE capability_tool SET tool_id = 'Canva' WHERE capability_id = 'CAP-c75d7a0a' AND tool_id = 'ChatGPT + Canva 组合';
-- UPDATE: ChatGPT / Claude 提示词工程 -> ChatGPT 4o
UPDATE capability_tool SET tool_id = 'ChatGPT 4o' WHERE capability_id = 'CAP-562d91c1' AND tool_id = 'ChatGPT / Claude 提示词工程';
-- UPDATE: ChatGPT / Gemini -> ChatGPT 4o
UPDATE capability_tool SET tool_id = 'ChatGPT 4o' WHERE capability_id = 'CAP-13bb82f5' AND tool_id = 'ChatGPT / Gemini';
-- UPDATE: ChatGPT 提示词工程 -> ChatGPT 4o
UPDATE capability_tool SET tool_id = 'ChatGPT 4o' WHERE capability_id = 'CAP-067edd94' AND tool_id = 'ChatGPT 提示词工程';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-002' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-3bf86ae3' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-758922b1' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-a185d6d2' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-ed4b506e' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-ef0a4c0c' AND tool_id = 'ComfyUI';
-- UPDATE: ComfyUI + ControlNet -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-3c49ff0a' AND tool_id = 'ComfyUI + ControlNet';
-- UPDATE: ComfyUI + ControlNet -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-bbac5ce2' AND tool_id = 'ComfyUI + ControlNet';
-- UPDATE: ComfyUI + ControlNet Depth -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-3c49ff0a' AND tool_id = 'ComfyUI + ControlNet Depth';
-- UPDATE: ComfyUI + ControlNet Depth -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-5fb6dd66' AND tool_id = 'ComfyUI + ControlNet Depth';
-- UPDATE: ComfyUI + ControlNet Depth节点 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-d93a0ac2' AND tool_id = 'ComfyUI + ControlNet Depth节点';
-- UPDATE: ComfyUI + LivePortrait节点 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-a3b3ab31' AND tool_id = 'ComfyUI + LivePortrait节点';
-- UPDATE: ComfyUI + 国画LoRA -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-d23f2e35' AND tool_id = 'ComfyUI + 国画LoRA';
-- UPDATE: ComfyUI工作流 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-1000e70d' AND tool_id = 'ComfyUI工作流';
-- UPDATE: ComfyUI工作流 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-3a6bc8f3' AND tool_id = 'ComfyUI工作流';
-- UPDATE: ComfyUI工作流 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-6c14041c' AND tool_id = 'ComfyUI工作流';
-- UPDATE: ComfyUI工作流 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-792fd807' AND tool_id = 'ComfyUI工作流';
-- UPDATE: ComfyUI工作流 -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-ed4b506e' AND tool_id = 'ComfyUI工作流';
-- UPDATE: ComfyUI + 材质LoRA -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-56368e3a' AND tool_id = 'ComfyUI + 材质LoRA';
-- UPDATE: Coze 工作流 -> Coze工作流
UPDATE capability_tool SET tool_id = 'Coze工作流' WHERE capability_id = 'CAP-20409fa6' AND tool_id = 'Coze 工作流';
-- UPDATE: Coze 工作流 -> Coze工作流
UPDATE capability_tool SET tool_id = 'Coze工作流' WHERE capability_id = 'CAP-511c45c1' AND tool_id = 'Coze 工作流';
-- UPDATE: Coze扣子工作流 -> Coze 扣子工作流
UPDATE capability_tool SET tool_id = 'Coze 扣子工作流' WHERE capability_id = 'CAP-41ac8100' AND tool_id = 'Coze扣子工作流';
-- UPDATE: Coze扣子工作流 -> Coze 扣子工作流
UPDATE capability_tool SET tool_id = 'Coze 扣子工作流' WHERE capability_id = 'CAP-da51c2ec' AND tool_id = 'Coze扣子工作流';
-- UPDATE: D5 渲染器 -> D5 Render
UPDATE capability_tool SET tool_id = 'D5 Render' WHERE capability_id = 'CAP-3c49ff0a' AND tool_id = 'D5 渲染器';
-- UPDATE: D5 渲染器 -> D5 Render
UPDATE capability_tool SET tool_id = 'D5 Render' WHERE capability_id = 'CAP-758922b1' AND tool_id = 'D5 渲染器';
-- UPDATE: D5 渲染器 -> D5 Render
UPDATE capability_tool SET tool_id = 'D5 Render' WHERE capability_id = 'CAP-a597f297' AND tool_id = 'D5 渲染器';
-- UPDATE: Davinci Resolve 20 -> tools/image_process/davinci_resolve_studio
UPDATE capability_tool SET tool_id = 'tools/image_process/davinci_resolve_studio' WHERE capability_id = 'CAP-79590b09' AND tool_id = 'Davinci Resolve 20';
-- UPDATE: DeepSeek -> tools/other/deepseek
UPDATE capability_tool SET tool_id = 'tools/other/deepseek' WHERE capability_id = 'CAP-34f85267' AND tool_id = 'DeepSeek';
-- UPDATE: DeepSeek -> tools/other/deepseek
UPDATE capability_tool SET tool_id = 'tools/other/deepseek' WHERE capability_id = 'CAP-511c45c1' AND tool_id = 'DeepSeek';
-- UPDATE: DeepSeek -> tools/other/deepseek
UPDATE capability_tool SET tool_id = 'tools/other/deepseek' WHERE capability_id = 'CAP-da51c2ec' AND tool_id = 'DeepSeek';
-- UPDATE: Enhancor.ai -> tools/image_process/enhancor
UPDATE capability_tool SET tool_id = 'tools/image_process/enhancor' WHERE capability_id = 'CAP-005' AND tool_id = 'Enhancor.ai';
-- UPDATE: Enhancor.ai -> tools/image_process/enhancor
UPDATE capability_tool SET tool_id = 'tools/image_process/enhancor' WHERE capability_id = 'CAP-006' AND tool_id = 'Enhancor.ai';
-- UPDATE: Enhancor.ai -> tools/image_process/enhancor
UPDATE capability_tool SET tool_id = 'tools/image_process/enhancor' WHERE capability_id = 'CAP-3b0de1ce' AND tool_id = 'Enhancor.ai';
-- UPDATE: figma -> Figma
UPDATE capability_tool SET tool_id = 'Figma' WHERE capability_id = 'CAP-60fe95a7' AND tool_id = 'figma';
-- UPDATE: flux_generate / midjourney_submit_job -> flux_generate
UPDATE capability_tool SET tool_id = 'flux_generate' WHERE capability_id = 'CAP-16c5174b' AND tool_id = 'flux_generate / midjourney_submit_job';
-- UPDATE: Flux / Seedream -> flux_generate
UPDATE capability_tool SET tool_id = 'flux_generate' WHERE capability_id = 'CAP-0c30af82' AND tool_id = 'Flux / Seedream';
-- UPDATE: Gemini Nano Banana -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-4c471e0d' AND tool_id = 'Gemini Nano Banana';
-- UPDATE: Google AI Studio 构图选择器 -> tools/other/gemini_2_5_pro
UPDATE capability_tool SET tool_id = 'tools/other/gemini_2_5_pro' WHERE capability_id = 'CAP-562d91c1' AND tool_id = 'Google AI Studio 构图选择器';
-- UPDATE: Google AI Studio 网页应用 -> tools/other/gemini_2_5_pro
UPDATE capability_tool SET tool_id = 'tools/other/gemini_2_5_pro' WHERE capability_id = 'CAP-067edd94' AND tool_id = 'Google AI Studio 网页应用';
-- UPDATE: Google AI Studio 配色选择器 -> tools/other/gemini_2_5_pro
UPDATE capability_tool SET tool_id = 'tools/other/gemini_2_5_pro' WHERE capability_id = 'CAP-2de278d6' AND tool_id = 'Google AI Studio 配色选择器';
-- UPDATE: Google Gemini -> tools/other/gemini_2_5_pro
UPDATE capability_tool SET tool_id = 'tools/other/gemini_2_5_pro' WHERE capability_id = 'CAP-001' AND tool_id = 'Google Gemini';
-- UPDATE: Google Gemini -> tools/other/gemini_2_5_pro
UPDATE capability_tool SET tool_id = 'tools/other/gemini_2_5_pro' WHERE capability_id = 'CAP-da51c2ec' AND tool_id = 'Google Gemini';
-- UPDATE: Google Veo 3 -> tools/image_gen/veo
UPDATE capability_tool SET tool_id = 'tools/image_gen/veo' WHERE capability_id = 'CAP-9f24d1c7' AND tool_id = 'Google Veo 3';
-- UPDATE: Google Veo 3.1 -> tools/image_gen/veo
UPDATE capability_tool SET tool_id = 'tools/image_gen/veo' WHERE capability_id = 'CAP-13bb82f5' AND tool_id = 'Google Veo 3.1';
-- UPDATE: GPT-4o + 即梦AI -> ChatGPT 4o
UPDATE capability_tool SET tool_id = 'ChatGPT 4o' WHERE capability_id = 'CAP-024ac428' AND tool_id = 'GPT-4o + 即梦AI';
-- UPDATE: grokimagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-49175b92' AND tool_id = 'grokimagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-1649b549' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-26100ea8' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-3178172e' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-6c14041c' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-98490894' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-aaaef688' AND tool_id = 'Grok Imagine';
-- UPDATE: Grok Imagine -> tools/image_gen/grok_imagine
UPDATE capability_tool SET tool_id = 'tools/image_gen/grok_imagine' WHERE capability_id = 'CAP-e962c3ef' AND tool_id = 'Grok Imagine';
-- UPDATE: HeyGen -> tools/image_gen/heygen
UPDATE capability_tool SET tool_id = 'tools/image_gen/heygen' WHERE capability_id = 'CAP-98490894' AND tool_id = 'HeyGen';
-- UPDATE: Higgsfield -> tools/model/higgsfield
UPDATE capability_tool SET tool_id = 'tools/model/higgsfield' WHERE capability_id = 'CAP-3b8df701' AND tool_id = 'Higgsfield';
-- UPDATE: higgsfield_ai -> tools/model/higgsfield
UPDATE capability_tool SET tool_id = 'tools/model/higgsfield' WHERE capability_id = 'CAP-008' AND tool_id = 'higgsfield_ai';
-- UPDATE: Higgsfield AI -> tools/model/higgsfield
UPDATE capability_tool SET tool_id = 'tools/model/higgsfield' WHERE capability_id = 'CAP-49175b92' AND tool_id = 'Higgsfield AI';
-- UPDATE: Higgsfield AI -> tools/model/higgsfield
UPDATE capability_tool SET tool_id = 'tools/model/higgsfield' WHERE capability_id = 'CAP-98490894' AND tool_id = 'Higgsfield AI';
-- UPDATE: Higgsfield AI -> tools/model/higgsfield
UPDATE capability_tool SET tool_id = 'tools/model/higgsfield' WHERE capability_id = 'CAP-b5dc2a07' AND tool_id = 'Higgsfield AI';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-49175b92' AND tool_id = 'KLING 3.0';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-6a4f793a' AND tool_id = 'KLING 3.0';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-8467736a' AND tool_id = 'KLING 3.0';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-851ef56b' AND tool_id = 'KLING 3.0';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-eb71d416' AND tool_id = 'KLING 3.0';
-- UPDATE: KLING 3.0 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-ef0a4c0c' AND tool_id = 'KLING 3.0';
-- UPDATE: Kling 3.0 / Nano Banana 2 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-c2c42fc7' AND tool_id = 'Kling 3.0 / Nano Banana 2';
-- UPDATE: Kling 3.0 / Nano Banana 2 -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-c9426dcc' AND tool_id = 'Kling 3.0 / Nano Banana 2';
-- UPDATE: KlingAI -> tools/image_gen/kling_ai
UPDATE capability_tool SET tool_id = 'tools/image_gen/kling_ai' WHERE capability_id = 'CAP-49175b92' AND tool_id = 'KlingAI';
-- UPDATE: LivePortrait -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-009' AND tool_id = 'LivePortrait';
-- UPDATE: LTX-2.3 换装术工作流（RunningHub） -> runninghub 在线工作流
UPDATE capability_tool SET tool_id = 'runninghub 在线工作流' WHERE capability_id = 'CAP-98490894' AND tool_id = 'LTX-2.3 换装术工作流（RunningHub）';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-001' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-004' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-015' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-0151fa61' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-0c30af82' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-0dc2a15b' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-0e3d61ca' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-1649b549' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-1b3e966f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-1f898cd9' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-26100ea8' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-306c15fe' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-3086677b' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-3bf86ae3' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-3c49ff0a' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-4c471e0d' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-4eca62ec' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-4f15a85f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5326543f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5342ad19' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-56368e3a' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5a1ac59d' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5e371e70' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-677f2802' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-6c14041c' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-8531d74f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-96182b8f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-9b71604d' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-9cef0d0f' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-a185d6d2' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-aaaef688' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-c2c42fc7' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-c64131f1' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-d23f2e35' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-db22d1ad' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-ded93adb' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-e962c3ef' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-e9ebac4d' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-ed4b506e' AND tool_id = 'Midjourney';
-- UPDATE: Midjourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-ef0a4c0c' AND tool_id = 'Midjourney';
-- UPDATE: MidJourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-07a297a9' AND tool_id = 'MidJourney';
-- UPDATE: MidJourney -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-3bf86ae3' AND tool_id = 'MidJourney';
-- UPDATE: Midjourney/Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-07b56ca5' AND tool_id = 'Midjourney/Flux';
-- UPDATE: Midjourney/Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-14bd7a4d' AND tool_id = 'Midjourney/Flux';
-- UPDATE: Midjourney/Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5b469359' AND tool_id = 'Midjourney/Flux';
-- UPDATE: Midjourney/Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-6e503f51' AND tool_id = 'Midjourney/Flux';
-- UPDATE: Midjourney/Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-e8a77f70' AND tool_id = 'Midjourney/Flux';
-- UPDATE: MidJourney / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-56368e3a' AND tool_id = 'MidJourney / Flux';
-- UPDATE: MidJourney / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5fb6dd66' AND tool_id = 'MidJourney / Flux';
-- UPDATE: Midjourney/Flux/Stable Diffusion -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-26ac8133' AND tool_id = 'Midjourney/Flux/Stable Diffusion';
-- UPDATE: Midjourney / Nano Banana Pro / GPT Image / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-3b0de1ce' AND tool_id = 'Midjourney / Nano Banana Pro / GPT Image / Flux';
-- UPDATE: Midjourney / Nano Banana Pro / GPT Image / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-6c14041c' AND tool_id = 'Midjourney / Nano Banana Pro / GPT Image / Flux';
-- UPDATE: Midjourney / Nano Banana Pro / GPT Image / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-792fd807' AND tool_id = 'Midjourney / Nano Banana Pro / GPT Image / Flux';
-- UPDATE: Midjourney / Nano Banana Pro / GPT Image / Flux -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-ed4b506e' AND tool_id = 'Midjourney / Nano Banana Pro / GPT Image / Flux';
-- UPDATE: Midjourney --sref 参数 -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-2de278d6' AND tool_id = 'Midjourney --sref 参数';
-- UPDATE: Midjourney V7 -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-13bb82f5' AND tool_id = 'Midjourney V7';
-- UPDATE: Midjourney V7 -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-41ac8100' AND tool_id = 'Midjourney V7';
-- UPDATE: Midjourney V7 -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-5342ad19' AND tool_id = 'Midjourney V7';
-- UPDATE: Midjourney V7 -> midjourney_submit_job
UPDATE capability_tool SET tool_id = 'midjourney_submit_job' WHERE capability_id = 'CAP-b5dc2a07' AND tool_id = 'Midjourney V7';
-- UPDATE: Morpholio Trace（Studio Text 多图层） -> Figma
UPDATE capability_tool SET tool_id = 'Figma' WHERE capability_id = 'CAP-067edd94' AND tool_id = 'Morpholio Trace（Studio Text 多图层）';
-- UPDATE: Nano Banana -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-1649b549' AND tool_id = 'Nano Banana';
-- UPDATE: Nano Banana -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-306c15fe' AND tool_id = 'Nano Banana';
-- UPDATE: Nano Banana -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-3bf86ae3' AND tool_id = 'Nano Banana';
-- UPDATE: Nano Banana -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-758922b1' AND tool_id = 'Nano Banana';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-024ac428' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-0dc2a15b' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-3d809797' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-41ac8100' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-5342ad19' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-5a1ac59d' AND tool_id = 'Nano Banana 2';
-- UPDATE: Nano Banana 2 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-eee5aa08' AND tool_id = 'Nano Banana 2';
-- UPDATE: nanobanana pro -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-8d69865f' AND tool_id = 'nanobanana pro';
-- UPDATE: Nano Banana Pro排版系统 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-067edd94' AND tool_id = 'Nano Banana Pro排版系统';
-- UPDATE: Nano Banana Pro电影海报模式 -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-014' AND tool_id = 'Nano Banana Pro电影海报模式';
-- UPDATE: nano_banana（背景去除） -> nano_banana
UPDATE capability_tool SET tool_id = 'nano_banana' WHERE capability_id = 'CAP-3530bbb1' AND tool_id = 'nano_banana（背景去除）';
-- UPDATE: Pixellab（移动端） -> ProCCD
UPDATE capability_tool SET tool_id = 'ProCCD' WHERE capability_id = 'CAP-16c5174b' AND tool_id = 'Pixellab（移动端）';
-- UPDATE: Procreate -> tools/image_process/procreate
UPDATE capability_tool SET tool_id = 'tools/image_process/procreate' WHERE capability_id = 'CAP-e8a77f70' AND tool_id = 'Procreate';
-- UPDATE: Procreate -> tools/image_process/procreate
UPDATE capability_tool SET tool_id = 'tools/image_process/procreate' WHERE capability_id = 'CAP-eaf114b5' AND tool_id = 'Procreate';
-- UPDATE: Procreate -> tools/image_process/procreate
UPDATE capability_tool SET tool_id = 'tools/image_process/procreate' WHERE capability_id = 'CAP-ec45f9c7' AND tool_id = 'Procreate';
-- UPDATE: RunningHub 在线工作流 -> runninghub 在线工作流
UPDATE capability_tool SET tool_id = 'runninghub 在线工作流' WHERE capability_id = 'CAP-ee7df476' AND tool_id = 'RunningHub 在线工作流';
-- UPDATE: seedance_2 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-4f15a85f' AND tool_id = 'seedance_2';
-- UPDATE: seedance 2.0 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-9a2cc3d8' AND tool_id = 'seedance 2.0';
-- UPDATE: seedance2.0 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-92b0fd72' AND tool_id = 'seedance2.0';
-- UPDATE: Seedance_2.0 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-009' AND tool_id = 'Seedance_2.0';
-- UPDATE: Seedance_2.0 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-5b000814' AND tool_id = 'Seedance_2.0';
-- UPDATE: Seedance_2.0 -> tools/image_gen/seedance
UPDATE capability_tool SET tool_id = 'tools/image_gen/seedance' WHERE capability_id = 'CAP-a185d6d2' AND tool_id = 'Seedance_2.0';
-- UPDATE: Seedream 4 -> seedream_generate
UPDATE capability_tool SET tool_id = 'seedream_generate' WHERE capability_id = 'CAP-2608518c' AND tool_id = 'Seedream 4';
-- UPDATE: Seedream / Nano-banana -> seedream_generate
UPDATE capability_tool SET tool_id = 'seedream_generate' WHERE capability_id = 'CAP-6e77db54' AND tool_id = 'Seedream / Nano-banana';
-- DELETE: Somake AI -> (no mapping, remove)
DELETE FROM capability_tool WHERE capability_id = 'CAP-3086677b' AND tool_id = 'Somake AI';
-- UPDATE: Stable Diffusion -> tools/image_gen/stable_diffusion
UPDATE capability_tool SET tool_id = 'tools/image_gen/stable_diffusion' WHERE capability_id = 'CAP-002' AND tool_id = 'Stable Diffusion';
-- UPDATE: Stable Diffusion -> tools/image_gen/stable_diffusion
UPDATE capability_tool SET tool_id = 'tools/image_gen/stable_diffusion' WHERE capability_id = 'CAP-d043d289' AND tool_id = 'Stable Diffusion';
-- UPDATE: Stable Diffusion / ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-0c30af82' AND tool_id = 'Stable Diffusion / ComfyUI';
-- UPDATE: Stable Diffusion / ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-0e3d61ca' AND tool_id = 'Stable Diffusion / ComfyUI';
-- UPDATE: Stable Diffusion / ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-5326543f' AND tool_id = 'Stable Diffusion / ComfyUI';
-- UPDATE: Stable Diffusion / ComfyUI -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-db22d1ad' AND tool_id = 'Stable Diffusion / ComfyUI';
-- UPDATE: Stable Diffusion + Inpaint -> tools/image_gen/stable_diffusion
UPDATE capability_tool SET tool_id = 'tools/image_gen/stable_diffusion' WHERE capability_id = 'CAP-d92ffc99' AND tool_id = 'Stable Diffusion + Inpaint';
-- UPDATE: Stable Diffusion + LoRA训练 -> tools/image_gen/stable_diffusion
UPDATE capability_tool SET tool_id = 'tools/image_gen/stable_diffusion' WHERE capability_id = 'CAP-3a6bc8f3' AND tool_id = 'Stable Diffusion + LoRA训练';
-- UPDATE: tools/image_gen/comfyui -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-004' AND tool_id = 'tools/image_gen/comfyui';
-- UPDATE: tools/image_gen/comfyui -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-008' AND tool_id = 'tools/image_gen/comfyui';
-- UPDATE: tools/image_gen/comfyui -> ComfyUI 工作流
UPDATE capability_tool SET tool_id = 'ComfyUI 工作流' WHERE capability_id = 'CAP-94c648d6' AND tool_id = 'tools/image_gen/comfyui';
-- DELETE: Z-Image-Turbo -> (no mapping, remove)
DELETE FROM capability_tool WHERE capability_id = 'CAP-006' AND tool_id = 'Z-Image-Turbo';
-- UPDATE: 剪映 -> tools/image_process/jianying
UPDATE capability_tool SET tool_id = 'tools/image_process/jianying' WHERE capability_id = 'CAP-16c5174b' AND tool_id = '剪映';
-- UPDATE: 剪映 -> tools/image_process/jianying
UPDATE capability_tool SET tool_id = 'tools/image_process/jianying' WHERE capability_id = 'CAP-26fac738' AND tool_id = '剪映';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-1f898cd9' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-306c15fe' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-49175b92' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-5e371e70' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-5f9644fb' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-63c933bb' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-92b0fd72' AND tool_id = '即梦 AI';
-- UPDATE: 即梦 AI -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-e9ebac4d' AND tool_id = '即梦 AI';
-- UPDATE: 即梦AI + 结构化提示词 -> ji_meng_add_task
UPDATE capability_tool SET tool_id = 'ji_meng_add_task' WHERE capability_id = 'CAP-8d6ec160' AND tool_id = '即梦AI + 结构化提示词';
-- DELETE: 奇域AI -> (no mapping, remove)
DELETE FROM capability_tool WHERE capability_id = 'CAP-001' AND tool_id = '奇域AI';
-- DELETE: 智能背景融合技术 -> (no mapping, remove)
DELETE FROM capability_tool WHERE capability_id = 'CAP-021' AND tool_id = '智能背景融合技术';
-- UPDATE: 醒图 智能抠图 -> 醒图
UPDATE capability_tool SET tool_id = '醒图' WHERE capability_id = 'CAP-12d2aa10' AND tool_id = '醒图 智能抠图';

-- Summary:
--   UPDATE: 195
--   DELETE: 5
--   UNMAPPED: 0