From 691d1735fc99029431f441a2716ca4126381ac8c Mon Sep 17 00:00:00 2001 From: winkey <wwwgto@qq.com> Date: 星期一, 07 四月 2025 22:42:06 +0800 Subject: [PATCH] 数据库更新 --- script/sql/update/updatdata20250407-2.sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/script/sql/update/updatdata20250407-2.sql b/script/sql/update/updatdata20250407-2.sql new file mode 100644 index 0000000..8ba9911 --- /dev/null +++ b/script/sql/update/updatdata20250407-2.sql @@ -0,0 +1,14 @@ +SET FOREIGN_KEY_CHECKS=0; + +ALTER TABLE `ruoyi-org`.`chat_gpts` ADD COLUMN `model_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '妯″瀷鍚嶇О' AFTER `tenant_id`; + +ALTER TABLE `ruoyi-org`.`chat_gpts` ADD COLUMN `system_prompt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '绯荤粺鎻愮ず璇�' AFTER `model_name`; + +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1810602934286237698, 'gpt-4-gizmo-g-RQAWjtI6u', '缈昏瘧鍔╂墜', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '涓嫳鍜岃嫳涓炕璇戜笓瀹�', 'winkey', 'winkey', 0, 0, 'vector', 103, '2024-07-09 17:12:34', '1', '1', '2025-04-07 21:44:11', 'Ms. Smith, the AI-powered Language Teacher, is a revolutionary GPT-based bot that offers personalized language learning experiences in over 20 languages, including Spanish, German, French, English, Chinese, Korean, Japanese, and more\n', NULL, '0', '127.0.0.1', 0, 'deepseek-r1:1.5b', '浣犳槸涓�浣嶇簿閫氬悇鍥借瑷�鐨勭炕璇戝ぇ甯圽r\n\r\n璇峰皢鐢ㄦ埛杈撳叆璇嶈缈昏瘧鎴愯嫳鏂囨垨涓枃\r\n\r\n==绀轰緥杈撳嚭==\r\n**鍘熸枃** : <杩欓噷鏄剧ず瑕佺炕璇戠殑鍘熸枃淇℃伅>\r\n**缈昏瘧** : <杩欓噷鏄剧ず缈昏瘧鎴愯嫳璇殑缁撴灉>\r\n==绀轰緥缁撴潫==\r\n\r\n娉ㄦ剰锛氳涓ユ牸鎸夌ず渚嬭繘琛岃緭鍑猴紝杩斿洖markdown鏍煎紡'); +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1811668415990931458, 'gpt-4-gizmo-g-XbReEL4Uq', '娓呭寳鍏ㄧ鍖荤敓', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '瀵屾湁鍚屾儏蹇冪殑鍏ㄧ鍖荤敓鎻愪緵鍋ュ悍鎸囧', NULL, NULL, 0, 0, NULL, 103, '2024-07-12 15:46:24', '1', '1', '2024-07-12 15:46:24', NULL, NULL, '0', NULL, 0, 'deepseek-r1:1.5b', '瀵屾湁鍚屾儏蹇冪殑鍏ㄧ鍖荤敓鎻愪緵鍋ュ悍鎸囧'); +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1811670922074988545, 'gpt-4-gizmo-g-AphhNRLxt', '鎻愮ず璇嶄紭鍖�', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '鎿呴暱涓篜rompt 鎻愬崌娓呮櫚搴﹀拰鍒涢�犲姏鐨勫ぇ甯�', NULL, NULL, 0, 0, NULL, 103, '2024-07-12 15:56:22', '1', '1', '2024-07-12 15:56:22', NULL, NULL, '0', NULL, 0, 'deepseek-r1:1.5b', '鎿呴暱涓篜rompt 鎻愬崌娓呮櫚搴﹀拰鍒涢�犲姏鐨勫ぇ甯�'); +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1811815442062188545, 'gpt-4-gizmo-g-ThuHxKi7e', '灏忕孩涔︽枃妗堢敓鎴愬櫒', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '灏忕孩涔︽枃妗堢敓鎴愬櫒', NULL, NULL, 0, 0, NULL, 103, '2024-07-13 01:30:38', '1', '1', '2024-07-13 01:30:38', NULL, NULL, '0', NULL, 0, 'deepseek-r1:1.5b', '灏忕孩涔︽枃妗堢敓鎴愬櫒'); +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1811817605668741121, 'gpt-4-gizmo-g-AsQCd3k8', '涓浗娉曞緥鍔╂墜', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '鍏ㄩ潰鎺屾彙涓浗娉曞緥鐨勬櫤鑳藉姪鎵嬶紝鍙府鍔╄捣鑽夋枃涔︼紝鍒嗘瀽妗堜欢锛岃繘琛屾硶寰嬪挩璇�', NULL, NULL, 0, 0, NULL, 103, '2024-07-13 01:39:14', '1', '1', '2024-07-13 01:39:14', NULL, NULL, '2', NULL, 0, 'deepseek-r1:1.5b', '鍏ㄩ潰鎺屾彙涓浗娉曞緥鐨勬櫤鑳藉姪鎵嬶紝鍙府鍔╄捣鑽夋枃涔︼紝鍒嗘瀽妗堜欢锛岃繘琛屾硶寰嬪挩璇�'); +INSERT INTO `ruoyi-ai`.`chat_gpts` (`id`, `gid`, `name`, `logo`, `info`, `author_id`, `author_name`, `use_cnt`, `bad`, `type`, `create_dept`, `create_time`, `create_by`, `update_by`, `update_time`, `remark`, `version`, `del_flag`, `update_ip`, `tenant_id`, `model_name`, `system_prompt`) VALUES (1811817605668741122, 'gpt-4-gizmo-g-IXwub6dJu', '鑻辫鑰佸笀', 'https://external-content.duckduckgo.com/ip3/chat.openai.com.ico', '鑻辫瀛︿範GPT鏄竴涓笓闂ㄨ璁℃潵甯姪鐢ㄦ埛鎻愰珮浠栦滑鐨勮嫳璇妧鑳界殑浜哄伐鏅鸿兘鍔╂墜', NULL, NULL, 0, 0, NULL, NULL, NULL, '', '', NULL, NULL, NULL, '0', NULL, 0, 'deepseek-r1:1.5b', '鑻辫瀛︿範GPT鏄竴涓笓闂ㄨ璁℃潵甯姪鐢ㄦ埛鎻愰珮浠栦滑鐨勮嫳璇妧鑳界殑浜哄伐鏅鸿兘鍔╂墜'); + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file -- Gitblit v1.9.3