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