From daac0010b16fc03ef72b6b0712b5ba38dde2801d Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 19 十月 2023 17:52:19 +0800
Subject: [PATCH] 优化云端录像定时清理
---
sql/初始化.sql | 31 +++++++++++++++++--------------
1 files changed, 17 insertions(+), 14 deletions(-)
diff --git "a/sql/\345\210\235\345\247\213\345\214\226.sql" "b/sql/\345\210\235\345\247\213\345\214\226.sql"
index 4395d03..42798e4 100644
--- "a/sql/\345\210\235\345\247\213\345\214\226.sql"
+++ "b/sql/\345\210\235\345\247\213\345\214\226.sql"
@@ -164,6 +164,8 @@
create_time character varying(50),
update_time character varying(50),
hook_alive_interval integer,
+ record_path character varying(255),
+ record_date integer default 7,
constraint uk_media_server_unique_ip_http_port unique (ip, http_port)
);
@@ -267,20 +269,21 @@
constraint uk_stream_push_app_stream unique (app, stream)
);
create table wvp_cloud_record (
- id serial primary key,
- app character varying(255),
- stream character varying(255),
- call_id character varying(255),
- start_time integer,
- end_time integer,
- media_server_id character varying(50),
- file_name character varying(255),
- folder character varying(255),
- file_path character varying(255),
- collect_type character varying(255),
- file_size integer,
- time_len integer,
- constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
+ id serial primary key,
+ app character varying(255),
+ stream character varying(255),
+ call_id character varying(255),
+ start_time integer,
+ end_time integer,
+ media_server_id character varying(50),
+ file_name character varying(255),
+ folder character varying(255),
+ file_path 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)
);
create table wvp_user (
--
Gitblit v1.8.0