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 | 40 ++++++++++++++++++++++++++++++++++++----
1 files changed, 36 insertions(+), 4 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 b4db185..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"
@@ -24,7 +24,6 @@
charset character varying(50),
ssrc_check bool default false,
geo_coord_sys character varying(50),
- tree_type character varying(50),
media_server_id character varying(50),
custom_name character varying(255),
sdp_ip character varying(50),
@@ -32,6 +31,8 @@
password character varying(255),
as_message_channel bool default false,
keepalive_interval_time integer,
+ switch_primary_sub_stream bool default false,
+ broadcast_push_after_ack bool default false,
constraint uk_device_device unique (device_id)
);
@@ -53,6 +54,7 @@
id serial primary key ,
channel_id character varying(50) not null,
name character varying(255),
+ custom_name character varying(255),
manufacture character varying(50),
model character varying(50),
owner character varying(50),
@@ -71,10 +73,13 @@
port integer,
password character varying(255),
ptz_type integer,
+ custom_ptz_type integer,
status bool default false,
longitude double precision,
+ custom_longitude double precision,
latitude double precision,
- stream_id character varying(50),
+ custom_latitude double precision,
+ stream_id character varying(255),
device_id character varying(50) not null,
parental character varying(50),
has_audio bool default false,
@@ -153,6 +158,7 @@
secret character varying(50),
rtp_enable bool default false,
rtp_port_range character varying(50),
+ send_rtp_port_range character varying(50),
record_assist_port integer,
default_server bool default false,
create_time character varying(50),
@@ -187,8 +193,8 @@
catalog_group integer,
create_time character varying(50),
update_time character varying(50),
- tree_type 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)
);
@@ -238,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)
);
@@ -252,13 +259,28 @@
create_time character varying(50),
alive_second integer,
media_server_id character varying(50),
- server_id character varying(50),
push_time character varying(50),
status bool default false,
update_time character varying(50),
push_ing bool default false,
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 (
@@ -279,6 +301,16 @@
create_time character varying(50),
update_time character varying(50)
);
+create table wvp_resources_tree (
+ id serial primary key ,
+ is_catalog bool default true,
+ device_channel_id integer ,
+ gb_stream_id integer,
+ name character varying(255),
+ parentId integer,
+ path character varying(255)
+);
+
/*鍒濆鏁版嵁*/
INSERT INTO wvp_user VALUES (1, 'admin','21232f297a57a5a743894a0e4a801fc3',1,'2021-04-13 14:14:57','2021-04-13 14:14:57','3e80d1762a324d5b0ff636e0bd16f1e3');
--
Gitblit v1.8.0