From bc431e429026d5efb9d404767f76a0724978d40d Mon Sep 17 00:00:00 2001 From: Cloud User <liaobin143@gmail.com> Date: 星期五, 15 九月 2023 22:39:08 +0800 Subject: [PATCH] fix-use-source-ip-as-stream-ip --- sql/初始化.sql | 18 +++++++++++++++++- 1 files changed, 17 insertions(+), 1 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 3eed0dd..93eef4e 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" @@ -32,6 +32,7 @@ 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), @@ -277,6 +283,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