QihuAI Design
771c8456b8
Root-cause fix for mixed CRLF/LF in the repo (no .gitattributes previously). Adds '* text=auto eol=lf' and explicit binary rules so all future checkouts are LF. Renormalizes all tracked text files (no logical content change). Backup tags: image qihuaiflow:backup-lineend-20260725-121632, git backup-lineend-pre-20260725-121632.
21 lines
1.2 KiB
SQL
21 lines
1.2 KiB
SQL
-- 018: 将 market_apps.capability 从旧的「AI 技术能力」取值规范为「业务场景」取值
|
||
-- 旧的 text/thinking/vision/tool/image/audio/asr/ocr/embedding/rerank/video 已不再使用，
|
||
-- 统一置空，后续由 AI 验证 / 导入阶段按业务场景重新归类。
|
||
-- 幂等：执行一次后不再有匹配行，可安全每次重启重跑。
|
||
-- 注意：当前业务场景标准 = 前台「应用市场」14 类 (MARKET_SCENES)：
|
||
-- design, frontend, mobile, backend, qa, search, docs, marketing,
|
||
-- workflow, secops, learning, video, collab, ai
|
||
-- 这些为合法取值，必须保留，不得置空（#707 修复：此前 allowlist 不含 14 类导致重启被清空）。
|
||
UPDATE market_apps
|
||
SET capability = NULL
|
||
WHERE capability IS NOT NULL
|
||
AND capability NOT IN (
|
||
'design', 'frontend', 'mobile', 'backend', 'qa', 'search', 'docs', 'marketing',
|
||
'workflow', 'secops', 'learning', 'video', 'collab', 'ai',
|
||
'freelance_content', 'freelance_client', 'freelance_finance',
|
||
'office_doc', 'office_data', 'office_email', 'office_pm',
|
||
'edu_prepare', 'edu_grade', 'edu_tutor', 'edu_home',
|
||
'biz_product', 'biz_service', 'biz_ops',
|
||
'general_write', 'general_research', 'general_agent'
|
||
);
|