From 206f47f42ac9c679da1a4154b58d37441360f068 Mon Sep 17 00:00:00 2001
From: shizy@yisa.com <shizy@yisa.com>
Date: 星期三, 29 十二月 2021 17:53:05 +0800
Subject: [PATCH] 修复获取设备信息信令Catalog不标准问题 PTZType，级联的Longitude、Latitude、PTZType等
---
sql/mysql.sql | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/sql/mysql.sql b/sql/mysql.sql
index 38cc881..5724342 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -1,7 +1,7 @@
-- auto-generated definition
-CREATE DATABASE `wvp` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin */;
+CREATE DATABASE IF NOT EXISTS `wvp` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin */;
use wvp;
@@ -148,6 +148,7 @@
defaultServer int not null,
createTime varchar(50) not null,
updateTime varchar(50) not null,
+ hookAliveInterval int not null,
constraint media_server_i
unique (ip, httpPort)
);
@@ -173,6 +174,7 @@
ptz int null,
rtcp int null,
status bit null,
+ shareAllLiveStream int null,
primary key (id, serverGBId)
);
--
Gitblit v1.8.0