From daac0010b16fc03ef72b6b0712b5ba38dde2801d Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 19 十月 2023 17:52:19 +0800
Subject: [PATCH] 优化云端录像定时清理
---
sql/2.6.9更新.sql | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git "a/sql/2.6.9\346\233\264\346\226\260.sql" "b/sql/2.6.9\346\233\264\346\226\260.sql"
index 103dcbb..6532d32 100644
--- "a/sql/2.6.9\346\233\264\346\226\260.sql"
+++ "b/sql/2.6.9\346\233\264\346\226\260.sql"
@@ -5,7 +5,7 @@
add auto_push_channel bool default false
alter table wvp_stream_proxy
- add stream_key varying(255)
+ add stream_key character varying(255)
create table wvp_cloud_record (
id serial primary key,
@@ -18,8 +18,17 @@
file_name character varying(255),
folder character varying(255),
file_path character varying(255),
- collect_type character varying(255),
+ collect bool default false,
+ reserve bool default false,
file_size integer,
time_len integer,
constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
);
+
+alter table wvp_media_server
+ add record_path character varying(255);
+
+alter table wvp_media_server
+ add record_date integer default 7;
+
+
--
Gitblit v1.8.0