From 298a9f4280458062ed0fc32084d5bcce8bbf196c Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 12 十月 2023 18:34:16 +0800
Subject: [PATCH] 开始重构云端录像
---
sql/初始化.sql | 21 +++++++++++++++++++--
1 files changed, 19 insertions(+), 2 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 273da91..9fcbe36 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"
@@ -79,7 +79,7 @@
custom_longitude double precision,
latitude double precision,
custom_latitude double precision,
- stream_id character varying(50),
+ stream_id character varying(255),
device_id character varying(50) not null,
parental character varying(50),
has_audio bool default false,
@@ -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,21 @@
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,
+ mediaServerId character varying(50),
+ file_name character varying(50),
+ folder character varying(50),
+ file_path 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,
@@ -283,7 +300,6 @@
create_time character varying(50),
update_time character varying(50)
);
-
create table wvp_resources_tree (
id serial primary key ,
is_catalog bool default true,
@@ -294,6 +310,7 @@
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');
INSERT INTO wvp_user_role VALUES (1, 'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57');
--
Gitblit v1.8.0