process_sheet/fastadmin/application/sql/ps_llm_online.sql

-- 线上大模型配置（可重复执行）
-- 本地 Ollama 保留，仅用于简单任务；识版优先走线上视觉模型

UPDATE `fa_config` SET
  `title`='本地驱动',
  `tip`='本地 Ollama，用于简单文本任务。识版请改用上方线上模型。',
  `content`='{"ollama":"Ollama 本地"}'
WHERE `name`='llm_driver';

UPDATE `fa_config` SET `title`='本地 Ollama 地址', `tip`='例如 http://127.0.0.1:11434 或内网 Ollama' WHERE `name`='llm_base_url';
UPDATE `fa_config` SET `title`='本地 API Key', `tip`='Ollama 一般留空' WHERE `name`='llm_api_key';
UPDATE `fa_config` SET `title`='本地超时秒数', `tip`='本地模型超时' WHERE `name`='llm_timeout';
UPDATE `fa_config` SET `title`='本地文本模型', `tip`='简单文本 / PDF 抽字，如 qwen2.5:7b-instruct' WHERE `name`='llm_text_model';
UPDATE `fa_config` SET `title`='本地视觉模型', `tip`='仅作备用。复杂拆版请用线上视觉模型。' WHERE `name`='llm_vision_model';
UPDATE `fa_config` SET `title`='本地视觉备用', `tip`='本地主视觉失败时使用' WHERE `name`='llm_vision_complex';

INSERT IGNORE INTO `fa_config` (`name`,`group`,`title`,`tip`,`type`,`visible`,`value`,`content`,`rule`,`extend`,`setting`) VALUES
('llm_online_enable','llm','启用线上模型','开启后，AI 拆版走线上视觉模型；本地模型仍用于简单任务','switch','','0','','','',''),
('llm_online_provider','llm','线上服务商','选好后会带出兼容地址，也可改成自定义网关','select','','dashscope','{"dashscope":"阿里云通义","openai":"OpenAI","moonshot":"月之暗面 Kimi","zhipu":"智谱 GLM","siliconflow":"硅基流动","volcengine":"火山方舟","deepseek":"DeepSeek（仅文本）","custom":"自定义兼容接口"}','','',''),
('llm_online_base_url','llm','线上接口地址','OpenAI 兼容 /v1 或 /compatible-mode/v1','string','','https://dashscope.aliyuncs.com/compatible-mode/v1','','','',''),
('llm_online_api_key','llm','线上 API Key','各平台控制台里的 Key，仅管理员可见','password','','','','','',''),
('llm_online_model','llm','线上文本模型','简单文本任务也可走线上，如 qwen-plus、gpt-4o-mini','string','','qwen-plus','','','',''),
('llm_online_vision_model','llm','线上视觉模型','拆版必须用带视觉的模型，如 qwen-vl-max、gpt-4o、glm-4v','string','','qwen-vl-max','','','',''),
('llm_online_timeout','llm','线上超时秒数','识版建议 120～180','number','','180','','','','');

UPDATE `fa_config` SET `value`='{"basic":"基础配置","email":"邮件配置","dictionary":"字典配置","user":"会员配置","example":"示例分组","ps":"流程单","llm":"大模型"}' WHERE `name`='configgroup';