From 33ddf707b56c305d131e59a2c8a1833ac7ba627d Mon Sep 17 00:00:00 2001
From: lawrencehj <65707521+lawrencehj@users.noreply.github.com>
Date: 星期三, 29 十二月 2021 18:08:33 +0800
Subject: [PATCH] 界面删除设备后同时删除Redis的对应条目，避免其它设备用同样IP登录时出现信息错误
---
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