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