From 8fab1ed0e8d6535a1ec68ddb62c2999e0f5ab791 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期一, 21 八月 2023 09:29:56 +0800
Subject: [PATCH] Merge pull request #1017 from AlphaWu/Zafu-Dev-20230820

---
 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