From ce44d803b73a65b2cc31db5bcc662139029463d3 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期五, 03 七月 2026 10:07:32 +0800
Subject: [PATCH] 海康电表维护

---
 server/db/business.collection_media.sql |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/server/db/business.collection_media.sql b/server/db/business.collection_media.sql
index 217091c..866575e 100644
--- a/server/db/business.collection_media.sql
+++ b/server/db/business.collection_media.sql
@@ -15,6 +15,9 @@
   `file_path_local` varchar(512) DEFAULT NULL COMMENT 'FTP鏈湴鐩稿璺緞',
   `download_status` int(11) DEFAULT '0' COMMENT '0寰呬笅杞� 1宸蹭笅杞� 2澶辫触 3涓嬭浇涓�',
   `download_time` datetime DEFAULT NULL COMMENT '涓嬭浇瀹屾垚鏃堕棿',
+  `snapshot_status` int(11) DEFAULT '0' COMMENT '0鏈垎鏋� 1鍒嗘瀽涓� 2瀹屾垚 3澶辫触',
+  `snapshot_time` datetime DEFAULT NULL COMMENT '蹇収鍒嗘瀽瀹屾垚鏃堕棿',
+  `snapshot_message` varchar(512) DEFAULT NULL COMMENT '蹇収鍒嗘瀽澶辫触鍘熷洜',
   `create_date` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
   `isdeleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎0鍚� 1鏄�',
   PRIMARY KEY (`id`),

--
Gitblit v1.9.3