From 744988ab6d7d68231b14506c006104d244958c09 Mon Sep 17 00:00:00 2001 From: zyf <2786722087@qq.com> Date: 星期四, 03 四月 2025 10:01:43 +0800 Subject: [PATCH] 更新SQL文件 --- Server/张怡帆/SQL文件/AI_datas.sql | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git "a/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql" "b/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql" index 5bc14b6..7f9c9ed 100644 --- "a/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql" +++ "b/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql" @@ -68,6 +68,21 @@ -- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆� +-- 瀵煎嚭 琛� ai_datas.version_info 缁撴瀯 +CREATE TABLE IF NOT EXISTS `version_info` ( + `employee_id` int DEFAULT NULL, + `version_number` varchar(50) DEFAULT NULL, + `file_name` varchar(50) DEFAULT NULL, + `file_size` int DEFAULT NULL, + `file_md5` varchar(50) DEFAULT NULL, + `update_time` date DEFAULT NULL, + `server_path` varchar(50) DEFAULT NULL, + `client_path` varchar(50) DEFAULT NULL, + `file_type` int DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆� + -- 瀵煎嚭 琛� ai_datas.videostorage 缁撴瀯 CREATE TABLE IF NOT EXISTS `videostorage` ( `VideoID` int NOT NULL AUTO_INCREMENT, -- Gitblit v1.8.0