From 3c1b294efb41e318645625493547830ee87af079 Mon Sep 17 00:00:00 2001 From: jhc <2991879965@qq.com> Date: 星期一, 18 十一月 2024 12:08:32 +0800 Subject: [PATCH] 上传日志、数据库表、数据库 --- Server/冀浩昶/log/日志_冀浩昶_1118.doc | 0 zhulongAI.sql | 16 ++++++++++++++-- 数据库表.docx | 0 3 files changed, 14 insertions(+), 2 deletions(-) diff --git "a/Server/\345\206\200\346\265\251\346\230\266/log/\346\227\245\345\277\227_\345\206\200\346\265\251\346\230\266_1118.doc" "b/Server/\345\206\200\346\265\251\346\230\266/log/\346\227\245\345\277\227_\345\206\200\346\265\251\346\230\266_1118.doc" new file mode 100644 index 0000000..0b6002c --- /dev/null +++ "b/Server/\345\206\200\346\265\251\346\230\266/log/\346\227\245\345\277\227_\345\206\200\346\265\251\346\230\266_1118.doc" Binary files differ diff --git a/zhulongAI.sql b/zhulongAI.sql index 5582f33..f077022 100644 --- a/zhulongAI.sql +++ b/zhulongAI.sql @@ -40,7 +40,6 @@ `status` varchar(50) NOT NULL COMMENT '鐘舵��', `ip` varchar(50) NOT NULL COMMENT 'ip', `mark_time` varchar(50) NOT NULL COMMENT '鏍囨敞鏃堕棿', - `mark_status` varchar(50) NOT NULL COMMENT '鏍囨敞鐘舵��', `buy_time` varchar(50) NOT NULL COMMENT '璐拱鏃堕棿', `install_time` varchar(50) NOT NULL COMMENT '瀹夎鏃堕棿', `camera_number` varchar(50) NOT NULL COMMENT '鎽勫儚澶寸紪鐮�', @@ -48,13 +47,26 @@ `longitude` double NOT NULL COMMENT '缁忓害', `latitude` double NOT NULL COMMENT '绾害', `belong_to` varchar(50) NOT NULL COMMENT '鎵�灞炵粍缁�/閮ㄩ棬', - `url` varchar(128) NOT NULL COMMENT '缃戝潃', `factory` varchar(128) NOT NULL COMMENT '鍘傚', + `notes` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '澶囨敞', + `live_url` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鎽勫儚澶寸鐞嗚〃'; -- 姝ｅ湪瀵煎嚭琛� zhulongai.camera_mark_manage 鐨勬暟鎹細~0 rows (澶х害) +-- 瀵煎嚭 琛� zhulongai.camera_url 缁撴瀯 +CREATE TABLE IF NOT EXISTS `camera_url` ( + `id` int DEFAULT NULL, + `camera_name` varchar(128) DEFAULT NULL, + `file_name` varchar(128) DEFAULT NULL, + `local_url` varchar(128) DEFAULT NULL, + KEY `id` (`id`), + CONSTRAINT `FK_camera_url_camera_mark_manage` FOREIGN KEY (`id`) REFERENCES `camera_mark_manage` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.camera_url 鐨勬暟鎹細~0 rows (澶х害) + -- 瀵煎嚭 琛� zhulongai.parsed_logs 缁撴瀯 CREATE TABLE IF NOT EXISTS `parsed_logs` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭锛岃嚜澧�', diff --git "a/\346\225\260\346\215\256\345\272\223\350\241\250.docx" "b/\346\225\260\346\215\256\345\272\223\350\241\250.docx" index 2c57a1b..0d99bb5 100644 --- "a/\346\225\260\346\215\256\345\272\223\350\241\250.docx" +++ "b/\346\225\260\346\215\256\345\272\223\350\241\250.docx" Binary files differ -- Gitblit v1.8.0