From a26b31cc9f3ee9b21b1a754e80fa7359e8a7a8f8 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期四, 25 六月 2026 16:22:04 +0800 Subject: [PATCH] 初始化项目 --- sql/mysql/ai.sql | 332 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 332 insertions(+), 0 deletions(-) diff --git a/sql/mysql/ai.sql b/sql/mysql/ai.sql new file mode 100644 index 0000000..7e97bf7 --- /dev/null +++ b/sql/mysql/ai.sql @@ -0,0 +1,332 @@ +-- AI 澶фā鍨嬫ā鍧楀缓琛� SQL + +-- ---------------------------- +-- 1. AI API 绉橀挜琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_api_key`; +CREATE TABLE `ai_api_key` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '鍚嶇О', + `api_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '瀵嗛挜', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'API 鍦板潃', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI API 绉橀挜琛�'; + +-- ---------------------------- +-- 2. AI 妯″瀷琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_model`; +CREATE TABLE `ai_model` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `key_id` bigint NOT NULL COMMENT 'API 绉橀挜缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '妯″瀷鍚嶇О', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '妯″瀷鏍囧織', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `type` tinyint NOT NULL COMMENT '绫诲瀷', + `sort` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍊�', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `temperature` double DEFAULT NULL COMMENT '娓╁害鍙傛暟', + `max_tokens` int DEFAULT NULL COMMENT '鍗曟潯鍥炲鐨勬渶澶� Token 鏁伴噺', + `max_contexts` int DEFAULT NULL COMMENT '涓婁笅鏂囩殑鏈�澶� Message 鏁伴噺', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 妯″瀷琛�'; + +-- ---------------------------- +-- 3. AI 鑱婂ぉ瑙掕壊琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_chat_role`; +CREATE TABLE `ai_chat_role` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '瑙掕壊鍚嶇О', + `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '瑙掕壊澶村儚', + `category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '瑙掕壊鍒嗙被', + `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '瑙掕壊鎻忚堪', + `system_message` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '瑙掕壊璁惧畾', + `user_id` bigint DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `knowledge_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '寮曠敤鐨勭煡璇嗗簱缂栧彿鍒楄〃', + `tool_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '寮曠敤鐨勫伐鍏风紪鍙峰垪琛�', + `mcp_client_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '寮曠敤鐨� MCP Client 鍚嶅瓧鍒楄〃', + `public_status` bit(1) NOT NULL DEFAULT b'1' COMMENT '鏄惁鍏紑', + `sort` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍊�', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鑱婂ぉ瑙掕壊琛�'; + +-- ---------------------------- +-- 4. AI 宸ュ叿琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_tool`; +CREATE TABLE `ai_tool` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '宸ュ叿缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '宸ュ叿鍚嶇О', + `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '宸ュ叿鎻忚堪', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 宸ュ叿琛�'; + +-- ---------------------------- +-- 5. AI Chat 瀵硅瘽琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_chat_conversation`; +CREATE TABLE `ai_chat_conversation` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID 缂栧彿', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '鏂板璇�' COMMENT '瀵硅瘽鏍囬', + `pinned` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁缃《', + `pinned_time` datetime DEFAULT NULL COMMENT '缃《鏃堕棿', + `role_id` bigint DEFAULT NULL COMMENT '瑙掕壊缂栧彿', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷鏍囧織', + `system_message` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '瑙掕壊璁惧畾', + `temperature` double DEFAULT NULL COMMENT '娓╁害鍙傛暟', + `max_tokens` int DEFAULT NULL COMMENT '鍗曟潯鍥炲鐨勬渶澶� Token 鏁伴噺', + `max_contexts` int DEFAULT NULL COMMENT '涓婁笅鏂囩殑鏈�澶� Message 鏁伴噺', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI Chat 瀵硅瘽琛�'; + +-- ---------------------------- +-- 6. AI Chat 娑堟伅琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_chat_message`; +CREATE TABLE `ai_chat_message` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `conversation_id` bigint NOT NULL COMMENT '瀵硅瘽缂栧彿', + `reply_id` bigint DEFAULT NULL COMMENT '鍥炲娑堟伅缂栧彿', + `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '娑堟伅绫诲瀷', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `role_id` bigint DEFAULT NULL COMMENT '瑙掕壊缂栧彿', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷鏍囧織', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鑱婂ぉ鍐呭', + `reasoning_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鎺ㄧ悊鍐呭', + `use_context` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鎼哄甫涓婁笅鏂�', + `segment_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鐭ヨ瘑搴撴钀界紪鍙锋暟缁�', + `web_search_pages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鑱旂綉鎼滅储鐨勭綉椤靛唴瀹规暟缁�', + `attachment_urls` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '闄勪欢 URL 鏁扮粍', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI Chat 娑堟伅琛�'; + +-- ---------------------------- +-- 7. AI 缁樼敾琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_image`; +CREATE TABLE `ai_image` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鎻愮ず璇�', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷鏍囪瘑', + `width` int DEFAULT NULL COMMENT '鍥剧墖瀹藉害', + `height` int DEFAULT NULL COMMENT '鍥剧墖楂樺害', + `status` tinyint NOT NULL COMMENT '鐢熸垚鐘舵��', + `finish_time` datetime DEFAULT NULL COMMENT '瀹屾垚鏃堕棿', + `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '缁樼敾閿欒淇℃伅', + `pic_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍥剧墖鍦板潃', + `public_status` bit(1) NOT NULL DEFAULT b'1' COMMENT '鏄惁鍏紑', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '缁樺埗鍙傛暟', + `buttons` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'mj buttons 鎸夐挳', + `task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浠诲姟缂栧彿', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 缁樼敾琛�'; + +-- ---------------------------- +-- 8. AI 鐭ヨ瘑搴撹〃 +-- ---------------------------- +DROP TABLE IF EXISTS `ai_knowledge`; +CREATE TABLE `ai_knowledge` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '鐭ヨ瘑搴撳悕绉�', + `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鐭ヨ瘑搴撴弿杩�', + `embedding_model_id` bigint DEFAULT NULL COMMENT '鍚戦噺妯″瀷缂栧彿', + `embedding_model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷鏍囪瘑', + `top_k` int DEFAULT NULL COMMENT 'topK', + `similarity_threshold` double DEFAULT NULL COMMENT '鐩镐技搴﹂槇鍊�', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鐭ヨ瘑搴撹〃'; + +-- ---------------------------- +-- 9. AI 鐭ヨ瘑搴撴枃妗ｈ〃 +-- ---------------------------- +DROP TABLE IF EXISTS `ai_knowledge_document`; +CREATE TABLE `ai_knowledge_document` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `knowledge_id` bigint NOT NULL COMMENT '鐭ヨ瘑搴撶紪鍙�', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '鏂囨。鍚嶇О', + `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏂囦欢 URL', + `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鍐呭', + `content_length` int DEFAULT NULL COMMENT '鏂囨。闀垮害', + `tokens` int DEFAULT NULL COMMENT '鏂囨。 token 鏁伴噺', + `segment_max_tokens` int DEFAULT NULL COMMENT '鍒嗙墖鏈�澶� Token 鏁�', + `retrieval_count` int NOT NULL DEFAULT 0 COMMENT '鍙洖娆℃暟', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鐭ヨ瘑搴撴枃妗ｈ〃'; + +-- ---------------------------- +-- 10. AI 鐭ヨ瘑搴撴枃妗ｅ垎娈佃〃 +-- ---------------------------- +DROP TABLE IF EXISTS `ai_knowledge_segment`; +CREATE TABLE `ai_knowledge_segment` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `knowledge_id` bigint NOT NULL COMMENT '鐭ヨ瘑搴撶紪鍙�', + `document_id` bigint NOT NULL COMMENT '鏂囨。缂栧彿', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鍒囩墖鍐呭', + `content_length` int DEFAULT NULL COMMENT '鍒囩墖鍐呭闀垮害', + `vector_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍚戦噺搴撶殑缂栧彿', + `tokens` int DEFAULT NULL COMMENT 'token 鏁伴噺', + `retrieval_count` int NOT NULL DEFAULT 0 COMMENT '鍙洖娆℃暟', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鐭ヨ瘑搴撴枃妗ｅ垎娈佃〃'; + +-- ---------------------------- +-- 11. AI 鎬濈淮瀵煎浘琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_mind_map`; +CREATE TABLE `ai_mind_map` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷', + `prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鐢熸垚鍐呭鎻愮ず', + `generated_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鐢熸垚鐨勫唴瀹�', + `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閿欒淇℃伅', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鎬濈淮瀵煎浘琛�'; + +-- ---------------------------- +-- 12. AI 闊充箰琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_music`; +CREATE TABLE `ai_music` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '闊充箰鍚嶇О', + `lyric` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '姝岃瘝', + `image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍥剧墖鍦板潃', + `audio_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '闊抽鍦板潃', + `video_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '瑙嗛鍦板潃', + `status` tinyint NOT NULL COMMENT '闊充箰鐘舵��', + `generate_mode` tinyint NOT NULL COMMENT '鐢熸垚妯″紡', + `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎻忚堪璇�', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷', + `tags` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '闊充箰椋庢牸鏍囩', + `duration` double DEFAULT NULL COMMENT '闊充箰鏃堕暱', + `public_status` bit(1) NOT NULL DEFAULT b'1' COMMENT '鏄惁鍏紑', + `task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浠诲姟缂栧彿', + `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閿欒淇℃伅', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 闊充箰琛�'; + +-- ---------------------------- +-- 13. AI 鍐欎綔琛� +-- ---------------------------- +DROP TABLE IF EXISTS `ai_write`; +CREATE TABLE `ai_write` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', + `type` tinyint NOT NULL COMMENT '鍐欎綔绫诲瀷', + `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '骞冲彴', + `model_id` bigint DEFAULT NULL COMMENT '妯″瀷缂栧彿', + `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妯″瀷', + `prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鐢熸垚鍐呭鎻愮ず', + `generated_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鐢熸垚鐨勫唴瀹�', + `original_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '鍘熸枃', + `length` tinyint DEFAULT NULL COMMENT '闀垮害鎻愮ず璇�', + `format` tinyint DEFAULT NULL COMMENT '鏍煎紡鎻愮ず璇�', + `tone` tinyint DEFAULT NULL COMMENT '璇皵鎻愮ず璇�', + `language` tinyint DEFAULT NULL COMMENT '璇█鎻愮ず璇�', + `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閿欒淇℃伅', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 鍐欎綔琛�'; + +-- ---------------------------- +-- 14. AI 宸ヤ綔娴佽〃 +-- ---------------------------- +DROP TABLE IF EXISTS `ai_workflow`; +CREATE TABLE `ai_workflow` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '宸ヤ綔娴佸悕绉�', + `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '宸ヤ綔娴佹爣璇�', + `graph` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '宸ヤ綔娴佹ā鍨� JSON 鏁版嵁', + `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵��', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI 宸ヤ綔娴佽〃'; \ No newline at end of file -- Gitblit v1.9.3