From 0acf13445a2e3120f3d3599238401c9f2885d711 Mon Sep 17 00:00:00 2001
From: lawrencehj <1934378145@qq.com>
Date: 星期三, 23 六月 2021 16:21:12 +0800
Subject: [PATCH] 改为fmp4截图
---
sql/mysql.sql | 23 +++++++++++++++--------
1 files changed, 15 insertions(+), 8 deletions(-)
diff --git a/sql/mysql.sql b/sql/mysql.sql
index bfed62e..7055edd 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -12,9 +12,13 @@
transport varchar(50) null,
streamMode varchar(50) null,
online varchar(50) null,
- registerTimeMillis int null,
+ registerTime varchar(50) null,
+ keepaliveTime varchar(50) null,
ip varchar(50) not null,
+ createTime varchar(50) not null,
+ updateTime varchar(50) not null,
port int not null,
+ expires int not null,
hostAddress varchar(50) not null
);
@@ -46,7 +50,9 @@
streamId varchar(50) null,
deviceId varchar(50) not null,
parental varchar(50) null,
- hasAudio tinyint(1) null,
+ hasAudio bit(1) null,
+ createTime varchar(50) not null,
+ updateTime varchar(50) not null,
primary key (channelId, deviceId)
);
@@ -82,10 +88,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 +106,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 +138,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