搭配zgyw，实现gb28181
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
648540858
2022-11-25 dfb87c768538e280cf5e17d1d5ee5bbed1e1888d 
 sql/mysql.sql


@@ -48,6 +48,7 @@


                          `ssrcCheck` int DEFAULT '0',


                          `geoCoordSys` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


                          `treeType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


                          `mediaServerId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'auto',


                          `custom_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,


                          `password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,


                          PRIMARY KEY (`id`),


@@ -280,7 +281,6 @@


                                `secret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


                                `rtpEnable` int NOT NULL,


                                `rtpPortRange` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


                                `sendRtpPortRange` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


                                `recordAssistPort` int NOT NULL,


                                `defaultServer` int NOT NULL,


                                `createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,


@@ -446,7 +446,7 @@


                                `ffmpeg_cmd_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,


                                `rtp_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,


                                `mediaServerId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,


                                `enable_hls` bit(1) DEFAULT NULL,


                                `enable_audio` bit(1) DEFAULT NULL,


                                `enable_mp4` bit(1) DEFAULT NULL,


                                `enable` bit(1) NOT NULL,


                                `status` bit(1) NOT NULL,