From 22efd0f56c20e1aedb18fa7b9bcdc48007fcc954 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期一, 20 十二月 2021 09:51:51 +0800
Subject: [PATCH] 添加心跳到期时验证zlm是否真的离线。

---
 sql/mysql.sql |    6 +++++-
 1 files changed, 5 insertions(+), 1 deletions(-)

diff --git a/sql/mysql.sql b/sql/mysql.sql
index 4501257..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;
 
@@ -23,6 +23,7 @@
     updateTime    varchar(50)  not null,
     port          int          not null,
     expires       int          not null,
+    subscribeCycleForCatalog       int          not null,
     hostAddress   varchar(50)  not null,
     charset       varchar(50)  not null
 );
@@ -147,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)
 );
@@ -172,6 +174,7 @@
     ptz            int          null,
     rtcp           int          null,
     status         bit          null,
+    shareAllLiveStream         int          null,
     primary key (id, serverGBId)
 );
 
@@ -207,6 +210,7 @@
     enable_hls     bit          null,
     enable_mp4     bit          null,
     enable         bit          not null,
+    enable_remove_none_reader    bit          not null,
     createTime     varchar(50)  not null,
     primary key (app, stream)
 );

--
Gitblit v1.8.0