From 92a25393f38d9877aeefca3bcc0f6574b7dff6d4 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期二, 17 十月 2023 17:55:40 +0800 Subject: [PATCH] 基于新的云端录像实现页面功能 --- sql/初始化.sql | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 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 93eef4e..4395d03 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" @@ -194,6 +194,7 @@ create_time character varying(50), update_time character varying(50), as_message_channel bool default false, + auto_push_channel bool default false, constraint uk_platform_unique_server_gb_id unique (server_gb_id) ); @@ -243,6 +244,7 @@ create_time character varying(50), name character varying(255), update_time character varying(50), + stream_key character varying(255), enable_disable_none_reader bool default false, constraint uk_stream_proxy_app_stream unique (app, stream) ); @@ -264,6 +266,22 @@ self bool default false, 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) +); create table wvp_user ( id serial primary key, -- Gitblit v1.8.0