From 1b677c6dc79b8e3b650acd94da7fc770c3d2718d Mon Sep 17 00:00:00 2001
From: 64850858 <648540858@qq.com>
Date: 星期五, 04 六月 2021 16:31:45 +0800
Subject: [PATCH] 增加zlm代理的secret自动添加， 增加配置文件的默认值，缺少非关键参数不会无法启动，简化配置文件给新手带来的压力，前端使用wvp代理流。
---
sql/mysql.sql | 15 ++++++++-------
1 files changed, 8 insertions(+), 7 deletions(-)
diff --git a/sql/mysql.sql b/sql/mysql.sql
index bfed62e..3f3b876 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -46,7 +46,7 @@
streamId varchar(50) null,
deviceId varchar(50) not null,
parental varchar(50) null,
- hasAudio tinyint(1) null,
+ hasAudio bit(1) null,
primary key (channelId, deviceId)
);
@@ -82,10 +82,10 @@
create table parent_platform
(
+ id int auto_increment,
enable int null,
name varchar(50) null,
- serverGBId varchar(50) not null
- primary key,
+ serverGBId varchar(50) not null,
serverGBDomain varchar(50) null,
serverIP varchar(50) null,
serverPort int null,
@@ -100,7 +100,8 @@
characterSet varchar(50) null,
ptz int null,
rtcp int null,
- status tinyint(1) null
+ status bit(1) null,
+ primary key (id, serverGBId)
);
create table platform_gb_channel
@@ -131,9 +132,9 @@
timeout_ms int null,
ffmpeg_cmd_key varchar(50) null,
rtp_type varchar(50) null,
- enable_hls tinyint(1) null,
- enable_mp4 tinyint(1) null,
- enable tinyint(1) not null,
+ enable_hls bit(1) null,
+ enable_mp4 bit(1) null,
+ enable bit(1) not null,
primary key (app, stream)
);
--
Gitblit v1.8.0