wvp-pro.git - Gitblit

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

			/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
			/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
			@@ -24,27 +24,33 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device` (
			`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,
			`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`firmware` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`transport` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`streamMode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`online` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`registerTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`keepaliveTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`ip` 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,
			`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;
			`hostAddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`charset` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`subscribeCycleForMobilePosition` int DEFAULT NULL,
			`mobilePositionSubmissionInterval` int DEFAULT '5',
			`subscribeCycleForAlarm` int DEFAULT NULL,
			`ssrcCheck` int DEFAULT '0',
			`geoCoordSys` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`treeType` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `device_deviceId_uindex` (`deviceId`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -74,6 +80,7 @@
			`longitude` double DEFAULT NULL,
			`latitude` double DEFAULT NULL,
			`alarmType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`createTime` varchar(50) 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 /;
			@@ -96,40 +103,46 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device_channel` (
			`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,
			`channelId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`manufacture` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`owner` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`civilCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`block` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`parentId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`safetyWay` int DEFAULT NULL,
			`registerWay` int DEFAULT NULL,
			`certNum` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`certNum` varchar(50) CHARACTER SET utf8mb4 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,
			`endTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`secrecy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`ipAddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`port` int DEFAULT NULL,
			`password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`password` varchar(255) CHARACTER SET utf8mb4 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,
			`streamId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`parental` varchar(50) CHARACTER SET utf8mb4 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,
			`createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`updateTime` varchar(50) CHARACTER SET utf8mb4 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;
			`longitudeGcj02` double DEFAULT NULL,
			`latitudeGcj02` double DEFAULT NULL,
			`longitudeWgs84` double DEFAULT NULL,
			`latitudeWgs84` double DEFAULT NULL,
			`businessGroupId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`gpsTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `device_channel_id_uindex` (`id`) USING BTREE,
			UNIQUE KEY `device_channel_pk` (`channelId`,`deviceId`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=19331 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -150,21 +163,23 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `device_mobile_position` (
			`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,
			`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`channelId` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`deviceName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`time` varchar(50) CHARACTER SET utf8mb4 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;
			`reportSource` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`longitudeGcj02` double DEFAULT NULL,
			`latitudeGcj02` double DEFAULT NULL,
			`longitudeWgs84` double DEFAULT NULL,
			`latitudeWgs84` double DEFAULT NULL,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=6751 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -193,12 +208,12 @@
			`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,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`gpsTime` varchar(50) COLLATE utf8mb4_general_ci 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;
			) ENGINE=InnoDB AUTO_INCREMENT=301681 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -228,7 +243,7 @@
			`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;
			) ENGINE=InnoDB AUTO_INCREMENT=34997 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -314,10 +329,15 @@
			`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;
			`startOfflinePush` int DEFAULT '0',
			`administrativeDivision` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`catalogGroup` int DEFAULT '1',
			`createTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`updateTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `parent_platform_id_uindex` (`id`) USING BTREE,
			UNIQUE KEY `parent_platform_pk` (`serverGBId`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -363,11 +383,11 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `platform_gb_channel` (
			`id` int NOT NULL AUTO_INCREMENT,
			`platformId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`catalogId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`platformId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`catalogId` varchar(50) CHARACTER SET utf8mb4 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;
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=4889 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -391,9 +411,9 @@
			`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;
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `platform_gb_stream_pk` (`platformId`,`catalogId`,`gbStreamId`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=302077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -414,26 +434,27 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `stream_proxy` (
			`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,
			`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`src_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`dst_url` varchar(255) CHARACTER SET utf8mb4 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,
			`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_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;
			`createTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`updateTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `stream_proxy_pk` (`app`,`stream`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -454,17 +475,21 @@
			/!50503 SET character_set_client = utf8mb4 /;
			CREATE TABLE `stream_push` (
			`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,
			`app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
			`totalReaderCount` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`originType` int DEFAULT NULL,
			`originTypeStr` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`createStamp` bigint DEFAULT NULL,
			`originTypeStr` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`createTime` varchar(50) COLLATE utf8mb4_general_ci 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;
			`mediaServerId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
			`serverId` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
			`pushTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`updateTime` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
			`status` int DEFAULT NULL,
			PRIMARY KEY (`id`) USING BTREE,
			UNIQUE KEY `stream_push_pk` (`app`,`stream`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=305315 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
			/!40101 SET character_set_client = @saved_cs_client /;

			--
			@@ -490,6 +515,7 @@
			`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,
			`pushKey` varchar(50) COLLATE utf8mb4_general_ci DEFAULT 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;
			@@ -501,7 +527,7 @@

			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','453df297a57a5a7438934sda801fc3');
			/!40000 ALTER TABLE `user` ENABLE KEYS /;
			UNLOCK TABLES;

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

			-- Dump completed on 2022-03-07 8:26:30
			-- Dump completed on 2022-07-11 17:32:51