yvjia/db/ai_chat_model.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `ai_chat_model`;
CREATE TABLE `ai_chat_model` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    `label` VARCHAR(255) COMMENT '模型名称',
    `value` VARCHAR(255) COMMENT '模型 (HUNYUAN-混元, DEEPSEEK_API, DEEPSEEK_R1)',
    `tag` VARCHAR(255) COMMENT '模型组 (OLLAMA, API)',
    `disabled` TINYINT(1) DEFAULT '1' COMMENT '是否禁用 (-1可用, 1禁用)',
    `status` TINYINT(1) DEFAULT '1' COMMENT '状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='AI助手模型表';

INSERT INTO ai_chat_model(id, parent_id, label, value, tag, disabled, status) VALUES
    (1, -1, 'DeepSeek R1', 'DEEPSEEK_R1', 'OLLAMA', -1, 1),
        (2, 1, 'deepseek-r1:1.5b', 'deepseek-r1:1.5b', 'OLLAMA', -1, 1),
        (3, 1, 'deepseek-r1:70b', 'deepseek-r1:70b', 'OLLAMA', -1, 1),
        (4, 1, 'deepseek-r1:671b', 'deepseek-r1:671b', 'OLLAMA', -1, 1),
    (5, -1, 'DeepSeek API', 'DEEPSEEK_API', 'API', -1, 1),
        (6, 5, 'deepseek-chat', 'deepseek-chat', 'API', -1, 1),
        (7, 5, 'deepseek-reasoner', 'deepseek-reasoner', 'API', -1, 1),
    (8, -1, '混元大模型', 'HUNYUAN', 'API', -1, 1),
    (9, -1, 'Gemma3', 'GEMMA', 'OLLAMA', -1, 1),
        (10, 9, 'gemma3:27b', 'gemma3:27b', 'OLLAMA', -1, 1),
    (11, -1, '通义千问', 'QwQ', 'OLLAMA', -1, 1),
        (12, 11, 'qwq:32b', 'qwq:32b', 'OLLAMA', -1, 1)
;