From 64cd48a92b722153066befdc6bda2993fab5f001 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期日, 02 七月 2023 00:03:21 +0800
Subject: [PATCH] 增加备用字段
---
sql/2.6.8升级2.6.9.sql | 17 +++++++++++++++++
sql/初始化.sql | 15 +++++++++++++++
2 files changed, 32 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)
+);
+
+
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 421760f..273da91 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,9 +73,12 @@
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,
+ custom_latitude double precision,
stream_id character varying(50),
device_id character varying(50) not null,
parental character varying(50),
@@ -279,6 +284,16 @@
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');
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