From 3571ca272b5c4d0b9df0d3e2c99f0384ba203797 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期日, 02 七月 2023 12:42:05 +0800 Subject: [PATCH] Merge branch 'wvp-28181-2.0' into main-dev --- sql/2.6.8升级2.6.9.sql | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git "a/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" "b/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" index a398cb8..7b16c35 100644 --- "a/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" +++ "b/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" @@ -455,6 +455,23 @@ rename table user to wvp_user; rename table user_role to wvp_user_role; +alter table wvp_device add column broadcast_push_after_ack bool default false; +alter table wvp_device_channel add column custom_name varchar(255) null ; +alter table wvp_device_channel add column custom_longitude double null ; +alter table wvp_device_channel add column custom_latitude double null ; +alter table wvp_device_channel add column custom_ptz_type int null ; + +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) +); + + -- Gitblit v1.8.0