From 04f3511fb3f3598cfb1646ba7ab58bf20e1a0de3 Mon Sep 17 00:00:00 2001
From: panlinlin <648540858@qq.com>
Date: 星期三, 28 四月 2021 17:52:11 +0800
Subject: [PATCH] 优化mysql建库脚本
---
sql/mysql.sql | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/sql/mysql.sql b/sql/mysql.sql
index bfed62e..6dec217 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)
);
@@ -100,7 +100,7 @@
characterSet varchar(50) null,
ptz int null,
rtcp int null,
- status tinyint(1) null
+ status bit(1) null
);
create table platform_gb_channel
@@ -131,9 +131,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