db-migration-2025-20250224-more-ds.sql

-- This script is converted from https://github.com/sdcb/chats/blob/3c72c1cea2e3b87a7f4dba71061f89fb65f087f1/src/scripts/db-migration/2025/20250224-more-ds.sql using ChatGPT

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.hunyuan.cloud.tencent.com/v1', `InitialSecret` = 'sk-'
WHERE `Id` = 2;

UPDATE `ModelKey`
SET `host` = 'https://api.hunyuan.cloud.tencent.com/v1'
WHERE `ModelProviderId` = 2;

-- Region Parameters
INSERT INTO `FinishReason`(`Id`, `Name`)
VALUES (107, 'InternalConfigIssue');

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://qianfan.baidubce.com/v2', `InitialSecret` = '{"appId": "app-***", "apiKey":"bce-v3/***"}'
WHERE `Id` = 6;

UPDATE `ModelKey`
SET `host` = 'https://qianfan.baidubce.com/v2'
WHERE `ModelProviderId` = 6;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://dashscope.aliyuncs.com/compatible-mode/v1', `InitialSecret` = 'sk-***'
WHERE `Id` = 7;

UPDATE `ModelKey`
SET `host` = 'https://dashscope.aliyuncs.com/compatible-mode/v1'
WHERE `ModelProviderId` = 7;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://generativelanguage.googleapis.com/v1beta/openai/'
WHERE `Id` = 13;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.lingyiwanwu.com/v1'
WHERE `Id` = 3;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.moonshot.cn/v1'
WHERE `Id` = 4;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://spark-api-open.xf-yun.com/v1'
WHERE `Id` = 8;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://open.bigmodel.cn/api/paas/v4/'
WHERE `Id` = 9;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.deepseek.com/v1'
WHERE `Id` = 10;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.x.ai/v1'
WHERE `Id` = 11;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://models.inference.ai.azure.com'
WHERE `Id` = 12;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.minimax.chat/v1'
WHERE `Id` = 15;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://ark.cn-beijing.volces.com/api/v3/'
WHERE `Id` = 16;

-- Region Parameters
UPDATE `ModelProvider`
SET `InitialHost` = 'https://api.siliconflow.cn/v1'
WHERE `Id` = 17;

UPDATE `ModelReference`
SET 
    `Name` = CASE 
        WHEN `Id` = 600 THEN 'ernie-4.0-turbo-128k'
        WHEN `Id` = 601 THEN 'ernie-4.0-8k'
        WHEN `Id` = 602 THEN 'ernie-3.5-8k'
        WHEN `Id` = 607 THEN 'ernie-speed-8k'
        ELSE `Name`
    END,
    `DisplayName` = CASE 
        WHEN `Id` = 600 THEN 'ERNIE-4.0-Turbo'
        WHEN `Id` = 601 THEN 'ERNIE-4.0'
        WHEN `Id` = 602 THEN 'ERNIE-3.5'
        WHEN `Id` = 603 THEN 'ERNIE-3.5'
        WHEN `Id` = 604 THEN 'ERNIE-Speed-Pro'
        WHEN `Id` = 605 THEN 'ERNIE-Novel'
        WHEN `Id` = 606 THEN 'ERNIE-Speed'
        WHEN `Id` = 607 THEN 'ERNIE-Speed'
        WHEN `Id` = 609 THEN 'ERNIE-Lite'
        WHEN `Id` = 611 THEN 'ERNIE-Tiny'
        WHEN `Id` = 614 THEN 'ERNIE-Lite-Pro'
        ELSE `DisplayName`
    END,
    `InputTokenPrice1M` = CASE 
        WHEN `Id` = 600 THEN 20
        WHEN `Id` = 601 THEN 30
        ELSE `InputTokenPrice1M`
    END,
    `OutputTokenPrice1M` = CASE 
        WHEN `Id` = 600 THEN 60
        WHEN `Id` = 601 THEN 90
        ELSE `OutputTokenPrice1M`
    END
WHERE `Id` BETWEEN 600 AND 614;

INSERT INTO `ModelReference`(
    `Id`, `ProviderId`, `Name`, `DisplayName`, `PublishDate`, `MinTemperature`, `MaxTemperature`, 
    `AllowSearch`, `AllowVision`, `AllowSystemPrompt`, `AllowStreaming`, `ReasoningResponseKindId`, 
    `ContextWindow`, `MaxResponseTokens`, `TokenizerId`, `InputTokenPrice1M`, `OutputTokenPrice1M`, `CurrencyCode`
)
VALUES 
    (615, 6, 'deepseek-v3', 'DeepSeek-V3', NULL, 0, 2, 0, 0, 1, 1, 0, 64000, 8192, NULL, 0.8, 1.6, 'RMB'),
    (616, 6, 'deepseek-r1', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 64000, 8192, NULL, 2, 8, 'RMB'),
    (617, 6, 'deepseek-r1-distill-qwen-32b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 64000, 8192, NULL, 1.5, 6, 'RMB'),
    (618, 6, 'deepseek-r1-distill-qwen-14b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 64000, 8192, NULL, 0.6, 2.4, 'RMB'),
    (619, 6, 'deepseek-r1-distill-qwen-7b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 64000, 8192, NULL, 0, 0, 'RMB'),
    (620, 6, 'deepseek-r1-distill-llama-70b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 64000, 8192, NULL, 2, 8, 'RMB');

-- Region Parameters
UPDATE `ModelReference`
SET `AllowSearch` = 0
WHERE `Id` = 204;

-- Region Parameters
UPDATE `ModelReference`
SET `Name` = 'gemini-2.0-flash-lite', `PublishDate` = '2025-02-26', `InputTokenPrice1M` = 0.075, `OutputTokenPrice1M` = 0.3
WHERE `Id` = 1303;

INSERT INTO `ModelReference`(
    `Id`, `ProviderId`, `Name`, `DisplayName`, `PublishDate`, `MinTemperature`, `MaxTemperature`,
    `AllowSearch`, `AllowVision`, `AllowSystemPrompt`, `AllowStreaming`, `ReasoningResponseKindId`,
    `ContextWindow`, `MaxResponseTokens`, `TokenizerId`, `InputTokenPrice1M`, `OutputTokenPrice1M`, `CurrencyCode`
)
VALUES
    (727, 7, 'deepseek-v3', 'DeepSeek-V3', NULL, 0, 2, 0, 0, 1, 1, 0, 65792, 8192, NULL, 2, 8, 'RMB'),
    (728, 7, 'deepseek-r1', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 65792, 8192, NULL, 4, 16, 'RMB'),
    (729, 7, 'deepseek-r1-distill-qwen-32b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 2, 6, 'RMB'),
    (730, 7, 'deepseek-r1-distill-qwen-14b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 1, 3, 'RMB'),
    (731, 7, 'deepseek-r1-distill-qwen-7b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 0.5, 1, 'RMB'),
    (732, 7, 'deepseek-r1-distill-qwen-1.5b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 0, 0, 'RMB'),
    (733, 7, 'deepseek-r1-distill-llama-70b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 0, 0, 'RMB'),
    (734, 7, 'deepseek-r1-distill-llama-8b', 'DeepSeek-R1', NULL, 0, 2, 0, 0, 1, 1, 1, 32768, 16384, NULL, 0, 0, 'RMB');

INSERT INTO `ModelReference`(
    `Id`, `ProviderId`, `Name`, `DisplayName`, `PublishDate`, `MinTemperature`, `MaxTemperature`, 
    `AllowSearch`, `AllowVision`, `AllowSystemPrompt`, `AllowStreaming`, `ReasoningResponseKindId`, 
    `ContextWindow`, `MaxResponseTokens`, `TokenizerId`, `InputTokenPrice1M`, `OutputTokenPrice1M`, `CurrencyCode`
)
VALUES 
    (1600, 16, 'doubao-1.5-pro-32k-250115', 'Doubao-1.5-Pro', '2025-01-15', 0, 1, 0, 0, 1, 1, 0, 32000, 12288, NULL, 0.8, 2.0, 'RMB'),
    (1601, 16, 'doubao-1.5-pro-256k-250115', 'Doubao-1.5-Pro', '2025-01-15', 0, 1, 0, 0, 1, 1, 0, 256000, 12288, NULL, 5, 9, 'RMB'),
    (1602, 16, 'doubao-1.5-lite-32k-250115', 'Doubao-1.5-Lite', '2025-01-15', 0, 1, 0, 0, 1, 1, 0, 32000, 12288, NULL, 0.3, 0.6, 'RMB'),
    (1603, 16, 'deepseek-r1-250120', 'DeepSeek-R1', '2025-01-20', 0, 1, 0, 0, 1, 1, 1, 64000, 16384, NULL, 4, 16, 'RMB'),
    (1604, 16, 'deepseek-r1-distill-qwen-32b-250120', 'DeepSeek-R1', '2025-01-20', 0, 1, 0, 0, 1, 1, 1, 32000, 8192, NULL, 1.5, 6, 'RMB'),
    (1605, 16, 'deepseek-r1-distill-qwen-7b-250120', 'DeepSeek-R1', '2025-01-20', 0, 1, 0, 0, 1, 1, 1, 32000, 8192, NULL, 0.6, 2.4, 'RMB'),
    (1606, 16, 'deepseek-v3-241226', 'DeepSeek-V3', '2025-01-20', 0, 1, 0, 0, 1, 1, 0, 64000, 16384, NULL, 2, 8, 'RMB'),
    (1607, 16, 'doubao-1.5-vision-pro-32k-250115', 'Doubao-1.5-Vision-Pro', '2025-01-15', 0, 1, 0, 1, 1, 1, 0, 32000, 12288, NULL, 3, 9, 'RMB');