wvp-pro.git - Gitblit

			@@ -1,8 +1,8 @@
			-- MySQL dump 10.13 Distrib 8.0.27, for Linux (x86_64)
			-- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64)
			--
			-- Host: 192.168.1.242 Database: wvp
			-- Host: 127.0.0.1 Database: wvp
			-- ------------------------------------------------------
			-- Server version 5.7.22
			-- Server version 8.0.28-0ubuntu0.20.04.3

			/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
			/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
			@@ -23,26 +23,28 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device` (
			`deviceId` varchar(50) NOT NULL,
			`name` varchar(255) DEFAULT NULL,
			`manufacturer` varchar(255) DEFAULT NULL,
			`model` varchar(255) DEFAULT NULL,
			`firmware` varchar(255) DEFAULT NULL,
			`transport` varchar(50) DEFAULT NULL,
			`streamMode` varchar(50) DEFAULT NULL,
			`online` varchar(50) DEFAULT NULL,
			`registerTime` varchar(50) DEFAULT NULL,
			`keepaliveTime` varchar(50) DEFAULT NULL,
			`ip` varchar(50) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			`updateTime` varchar(50) NOT NULL,
			`port` int(11) NOT NULL,
			`expires` int(11) NOT NULL,
			`subscribeCycleForCatalog` int(11) NOT NULL,
			`hostAddress` varchar(50) NOT NULL,
			`charset` varchar(50) NOT NULL,
			PRIMARY KEY (`deviceId`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`deviceId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`manufacturer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`model` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`firmware` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`transport` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`streamMode` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`online` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`registerTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`keepaliveTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`ip` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`updateTime` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`port` int NOT NULL,
			`expires` int NOT NULL,
			`subscribeCycleForCatalog` int NOT NULL,
			`hostAddress` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`charset` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `device_deviceId_uindex` (`deviceId`)
			) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -62,18 +64,18 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device_alarm` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`deviceId` varchar(50) NOT NULL,
			`channelId` varchar(50) NOT NULL,
			`alarmPriority` varchar(50) NOT NULL,
			`alarmMethod` varchar(50) DEFAULT NULL,
			`alarmTime` varchar(50) NOT NULL,
			`alarmDescription` varchar(255) DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`alarmType` varchar(50) DEFAULT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`channelId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`alarmPriority` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`alarmMethod` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`alarmTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`alarmDescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`alarmType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -93,37 +95,41 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device_channel` (
			`channelId` varchar(50) NOT NULL,
			`name` varchar(255) DEFAULT NULL,
			`manufacture` varchar(50) DEFAULT NULL,
			`model` varchar(50) DEFAULT NULL,
			`owner` varchar(50) DEFAULT NULL,
			`civilCode` varchar(50) DEFAULT NULL,
			`block` varchar(50) DEFAULT NULL,
			`address` varchar(50) DEFAULT NULL,
			`parentId` varchar(50) DEFAULT NULL,
			`safetyWay` int(11) DEFAULT NULL,
			`registerWay` int(11) DEFAULT NULL,
			`certNum` varchar(50) DEFAULT NULL,
			`certifiable` int(11) DEFAULT NULL,
			`errCode` int(11) DEFAULT NULL,
			`endTime` varchar(50) DEFAULT NULL,
			`secrecy` varchar(50) DEFAULT NULL,
			`ipAddress` varchar(50) DEFAULT NULL,
			`port` int(11) DEFAULT NULL,
			`password` varchar(255) DEFAULT NULL,
			`PTZType` int(11) DEFAULT NULL,
			`status` int(11) DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`streamId` varchar(50) DEFAULT NULL,
			`deviceId` varchar(50) NOT NULL,
			`parental` varchar(50) DEFAULT NULL,
			`hasAudio` bit(1) DEFAULT NULL,
			`createTime` varchar(50) NOT NULL,
			`updateTime` varchar(50) NOT NULL,
			PRIMARY KEY (`channelId`,`deviceId`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`channelId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`manufacture` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`model` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`owner` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`civilCode` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`block` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`address` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`parentId` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`safetyWay` int DEFAULT NULL,
			`registerWay` int DEFAULT NULL,
			`certNum` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`certifiable` int DEFAULT NULL,
			`errCode` int DEFAULT NULL,
			`endTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`secrecy` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`ipAddress` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`port` int DEFAULT NULL,
			`password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`PTZType` int DEFAULT NULL,
			`status` int DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`streamId` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`deviceId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`parental` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`hasAudio` bit(1) DEFAULT NULL,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`updateTime` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`subCount` int DEFAULT '0',
			PRIMARY KEY (`id`),
			UNIQUE KEY `device_channel_id_uindex` (`id`),
			UNIQUE KEY `device_channel_pk` (`channelId`,`deviceId`)
			) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -143,21 +149,22 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device_mobile_position` (
			`deviceId` varchar(50) NOT NULL,
			`channelId` varchar(50) NOT NULL,
			`deviceName` varchar(255) DEFAULT NULL,
			`time` varchar(50) NOT NULL,
			`longitude` double NOT NULL,
			`latitude` double NOT NULL,
			`altitude` double DEFAULT NULL,
			`speed` double DEFAULT NULL,
			`direction` double DEFAULT NULL,
			`reportSource` varchar(50) DEFAULT NULL,
			`geodeticSystem` varchar(50) DEFAULT NULL,
			`cnLng` varchar(50) DEFAULT NULL,
			`cnLat` varchar(50) DEFAULT NULL,
			PRIMARY KEY (`deviceId`,`time`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`deviceId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`channelId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`deviceName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`time` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`longitude` double NOT NULL,
			`latitude` double NOT NULL,
			`altitude` double DEFAULT NULL,
			`speed` double DEFAULT NULL,
			`direction` double DEFAULT NULL,
			`reportSource` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`geodeticSystem` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`cnLng` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`cnLat` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -177,21 +184,21 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `gb_stream` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`app` varchar(255) NOT NULL,
			`stream` varchar(255) NOT NULL,
			`gbId` varchar(50) NOT NULL,
			`name` varchar(255) DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`streamType` varchar(50) DEFAULT NULL,
			`mediaServerId` varchar(50) DEFAULT NULL,
			`status` int(11) DEFAULT NULL,
			`createStamp` bigint(20) DEFAULT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `app` (`app`,`stream`),
			UNIQUE KEY `gbId` (`gbId`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`gbStreamId` int NOT NULL AUTO_INCREMENT,
			`app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`gbId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`streamType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`mediaServerId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`status` int DEFAULT NULL,
			`createStamp` bigint DEFAULT NULL,
			PRIMARY KEY (`gbStreamId`) USING BTREE,
			UNIQUE KEY `app` (`app`,`stream`) USING BTREE,
			UNIQUE KEY `gbId` (`gbId`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=300766 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -211,17 +218,17 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `log` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`name` varchar(50) NOT NULL,
			`type` varchar(50) NOT NULL,
			`uri` varchar(200) NOT NULL,
			`address` varchar(50) NOT NULL,
			`result` varchar(50) NOT NULL,
			`timing` bigint(20) NOT NULL,
			`username` varchar(50) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`uri` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`timing` bigint NOT NULL,
			`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=962 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -241,32 +248,32 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `media_server` (
			`id` varchar(255) NOT NULL,
			`ip` varchar(50) NOT NULL,
			`hookIp` varchar(50) NOT NULL,
			`sdpIp` varchar(50) NOT NULL,
			`streamIp` varchar(50) NOT NULL,
			`httpPort` int(11) NOT NULL,
			`httpSSlPort` int(11) NOT NULL,
			`rtmpPort` int(11) NOT NULL,
			`rtmpSSlPort` int(11) NOT NULL,
			`rtpProxyPort` int(11) NOT NULL,
			`rtspPort` int(11) NOT NULL,
			`rtspSSLPort` int(11) NOT NULL,
			`autoConfig` int(11) NOT NULL,
			`secret` varchar(50) NOT NULL,
			`streamNoneReaderDelayMS` int(11) NOT NULL,
			`rtpEnable` int(11) NOT NULL,
			`rtpPortRange` varchar(50) NOT NULL,
			`sendRtpPortRange` varchar(50) NOT NULL,
			`recordAssistPort` int(11) NOT NULL,
			`defaultServer` int(11) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			`updateTime` varchar(50) NOT NULL,
			`hookAliveInterval` int(11) NOT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `media_server_i` (`ip`,`httpPort`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`hookIp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`sdpIp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`streamIp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`httpPort` int NOT NULL,
			`httpSSlPort` int NOT NULL,
			`rtmpPort` int NOT NULL,
			`rtmpSSlPort` int NOT NULL,
			`rtpProxyPort` int NOT NULL,
			`rtspPort` int NOT NULL,
			`rtspSSLPort` int NOT NULL,
			`autoConfig` int NOT NULL,
			`secret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`streamNoneReaderDelayMS` int 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,
			`updateTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`hookAliveInterval` int NOT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `media_server_i` (`ip`,`httpPort`) USING BTREE
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -286,29 +293,31 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `parent_platform` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`enable` int(11) DEFAULT NULL,
			`name` varchar(255) DEFAULT NULL,
			`serverGBId` varchar(50) NOT NULL,
			`serverGBDomain` varchar(50) DEFAULT NULL,
			`serverIP` varchar(50) DEFAULT NULL,
			`serverPort` int(11) DEFAULT NULL,
			`deviceGBId` varchar(50) NOT NULL,
			`deviceIp` varchar(50) DEFAULT NULL,
			`devicePort` varchar(50) DEFAULT NULL,
			`username` varchar(255) DEFAULT NULL,
			`password` varchar(50) DEFAULT NULL,
			`expires` varchar(50) DEFAULT NULL,
			`keepTimeout` varchar(50) DEFAULT NULL,
			`transport` varchar(50) DEFAULT NULL,
			`characterSet` varchar(50) DEFAULT NULL,
			`catalogId` varchar(50) NOT NULL,
			`ptz` int(11) DEFAULT NULL,
			`rtcp` int(11) DEFAULT NULL,
			`status` bit(1) DEFAULT NULL,
			`shareAllLiveStream` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`,`serverGBId`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`enable` int DEFAULT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`serverGBId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`serverGBDomain` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`serverIP` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`serverPort` int DEFAULT NULL,
			`deviceGBId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`deviceIp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`devicePort` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`expires` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`keepTimeout` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`transport` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`characterSet` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`catalogId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`ptz` int DEFAULT NULL,
			`rtcp` int DEFAULT NULL,
			`status` bit(1) DEFAULT NULL,
			`shareAllLiveStream` int DEFAULT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `parent_platform_id_uindex` (`id`),
			UNIQUE KEY `parent_platform_pk` (`serverGBId`)
			) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -328,12 +337,12 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `platform_catalog` (
			`id` varchar(50) NOT NULL,
			`platformId` varchar(50) NOT NULL,
			`name` varchar(255) NOT NULL,
			`parentId` varchar(50) DEFAULT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`platformId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`parentId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -353,13 +362,12 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `platform_gb_channel` (
			`channelId` varchar(50) NOT NULL,
			`deviceId` varchar(50) NOT NULL,
			`platformId` varchar(50) NOT NULL,
			`deviceAndChannelId` varchar(50) NOT NULL,
			`catalogId` varchar(50) NOT NULL,
			PRIMARY KEY (`deviceAndChannelId`,`platformId`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`platformId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`catalogId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`deviceChannelId` int NOT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -379,12 +387,13 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `platform_gb_stream` (
			`platformId` varchar(50) NOT NULL,
			`app` varchar(255) NOT NULL,
			`stream` varchar(255) NOT NULL,
			`catalogId` varchar(50) NOT NULL,
			PRIMARY KEY (`platformId`,`app`,`stream`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`platformId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`catalogId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`gbStreamId` int NOT NULL,
			`id` int NOT NULL AUTO_INCREMENT,
			PRIMARY KEY (`id`),
			UNIQUE KEY `platform_gb_stream_pk` (`platformId`,`catalogId`,`gbStreamId`)
			) ENGINE=InnoDB AUTO_INCREMENT=301207 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -397,33 +406,6 @@
			UNLOCK TABLES;

			--
			-- Table structure for table `user_role`
			--

			DROP TABLE IF EXISTS `user_role`;
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `user_role` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`name` varchar(50) NOT NULL,
			`authority` varchar(50) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			`updateTime` varchar(50) NOT NULL,
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			-- Dumping data for table `user_role`
			--

			LOCK TABLES `user_role` WRITE;
			/!40000 ALTER TABLE `user_role` DISABLE KEYS /;
			INSERT INTO `user_role` VALUES (1,'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57');
			/!40000 ALTER TABLE `user_role` ENABLE KEYS /;
			UNLOCK TABLES;

			--
			-- Table structure for table `stream_proxy`
			--

			@@ -431,24 +413,27 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `stream_proxy` (
			`type` varchar(50) NOT NULL,
			`app` varchar(255) NOT NULL,
			`stream` varchar(255) NOT NULL,
			`url` varchar(255) DEFAULT NULL,
			`src_url` varchar(255) DEFAULT NULL,
			`dst_url` varchar(255) DEFAULT NULL,
			`timeout_ms` int(11) DEFAULT NULL,
			`ffmpeg_cmd_key` varchar(255) DEFAULT NULL,
			`rtp_type` varchar(50) DEFAULT NULL,
			`mediaServerId` varchar(50) DEFAULT NULL,
			`enable_hls` bit(1) DEFAULT NULL,
			`enable_mp4` bit(1) DEFAULT NULL,
			`enable` bit(1) NOT NULL,
			`status` bit(1) NOT NULL,
			`enable_remove_none_reader` bit(1) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			PRIMARY KEY (`app`,`stream`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`type` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`app` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
			`stream` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
			`url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`src_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`dst_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`timeout_ms` int DEFAULT NULL,
			`ffmpeg_cmd_key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`rtp_type` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`mediaServerId` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`enable_hls` bit(1) DEFAULT NULL,
			`enable_mp4` bit(1) DEFAULT NULL,
			`enable` bit(1) NOT NULL,
			`status` bit(1) NOT NULL,
			`enable_remove_none_reader` bit(1) NOT NULL,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `stream_proxy_pk` (`app`,`stream`)
			) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -468,16 +453,18 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `stream_push` (
			`app` varchar(255) NOT NULL,
			`stream` varchar(255) NOT NULL,
			`totalReaderCount` varchar(50) DEFAULT NULL,
			`originType` int(11) DEFAULT NULL,
			`originTypeStr` varchar(50) DEFAULT NULL,
			`createStamp` bigint(20) DEFAULT NULL,
			`aliveSecond` int(11) DEFAULT NULL,
			`mediaServerId` varchar(50) DEFAULT NULL,
			PRIMARY KEY (`app`,`stream`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`app` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
			`stream` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
			`totalReaderCount` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`originType` int DEFAULT NULL,
			`originTypeStr` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`createStamp` bigint DEFAULT NULL,
			`aliveSecond` int DEFAULT NULL,
			`mediaServerId` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `stream_push_pk` (`app`,`stream`)
			) ENGINE=InnoDB AUTO_INCREMENT=300799 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -497,15 +484,15 @@
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `user` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`username` varchar(255) NOT NULL,
			`password` varchar(255) NOT NULL,
			`roleId` int(11) NOT NULL,
			`createTime` varchar(50) NOT NULL,
			`updateTime` varchar(50) NOT NULL,
			PRIMARY KEY (`id`),
			UNIQUE KEY `user_username_uindex` (`username`)
			) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
			`id` int NOT NULL AUTO_INCREMENT,
			`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`roleId` int NOT NULL,
			`createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`updateTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `user_username_uindex` (`username`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -514,8 +501,35 @@

			LOCK TABLES `user` WRITE;
			/!40000 ALTER TABLE `user` DISABLE KEYS /;
			INSERT INTO `user` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',1,'2021-04-13 14:14:57','2021-04-13 14:14:57');
			INSERT INTO `user` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',1,'2021 - 04 - 13 14:14:57','2021 - 04 - 13 14:14:57');
			/!40000 ALTER TABLE `user` ENABLE KEYS /;
			UNLOCK TABLES;

			--
			-- Table structure for table `user_role`
			--

			DROP TABLE IF EXISTS `user_role`;
			/!40101 SET @saved_cs_client = @@character_set_client /;
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `user_role` (
			`id` int NOT NULL AUTO_INCREMENT,
			`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`authority` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`updateTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			-- Dumping data for table `user_role`
			--

			LOCK TABLES `user_role` WRITE;
			/!40000 ALTER TABLE `user_role` DISABLE KEYS /;
			INSERT INTO `user_role` VALUES (1,'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57');
			/!40000 ALTER TABLE `user_role` ENABLE KEYS /;
			UNLOCK TABLES;
			/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;

			@@ -527,4 +541,4 @@
			/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
			/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;

			-- Dump completed on 2022-01-25 15:36:42
			-- Dump completed on 2022-03-07 8:26:30