/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80034
 Source Host           : localhost:3306
 Source Schema         : sys-video

 Target Server Type    : MySQL
 Target Server Version : 80034
 File Encoding         : 65001

 Date: 21/06/2024 11:20:39
*/


-- ----------------------------
-- Table structure for wvp_cloud_record
-- ----------------------------
CREATE TABLE wvp_cloud_record  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  app varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  call_id varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  start_time bigint NULL DEFAULT NULL,
  end_time bigint NULL DEFAULT NULL,
  media_server_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  file_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  folder varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  file_path varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  collect tinyint(1) NULL DEFAULT 0,
  file_size bigint NULL DEFAULT NULL,
  time_len bigint NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_stream_push_app_stream_path(app, stream, file_path) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wvp_device_alarm
-- ----------------------------
CREATE TABLE wvp_device_alarm  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  device_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  channel_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  alarm_priority varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  alarm_method varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  alarm_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  alarm_description varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  longitude double NULL DEFAULT NULL,
  latitude double NULL DEFAULT NULL,
  alarm_type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1258 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_device_alarm
-- ----------------------------
INSERT INTO wvp_device_alarm VALUES (1, '34020000001110000002', '34020000001320000003', '4', '5', '2024-05-07 14:07:45', '', 0, 0, '2', '2024-05-07 14:08:17');
INSERT INTO wvp_device_alarm VALUES (2, '34020000001110000002', '34020000001320000001', '4', '5', '2024-05-07 14:08:27', '', 0, 0, '2', '2024-05-07 14:08:36');
INSERT INTO wvp_device_alarm VALUES (3, '34020000001110000002', '34020000001320000001', '4', '5', '2024-05-07 14:09:03', '', 0, 0, '2', '2024-05-07 14:09:04');
INSERT INTO wvp_device_alarm VALUES (4, '34020000001110000002', '34020000001320000001', '4', '5', '2024-05-07 14:09:27', '', 0, 0, '2', '2024-05-07 14:09:28');
INSERT INTO wvp_device_alarm VALUES (5, '34020000001110000002', '34020000001320000001', '4', '5', '2024-05-07 14:10:37', '', 0, 0, '2', '2024-05-07 14:10:38');

-- ----------------------------
-- Table structure for wvp_device_mobile_position
-- ----------------------------
CREATE TABLE wvp_device_mobile_position  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  device_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  channel_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  device_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  longitude double NULL DEFAULT NULL,
  latitude double NULL DEFAULT NULL,
  altitude double NULL DEFAULT NULL,
  speed double NULL DEFAULT NULL,
  direction double NULL DEFAULT NULL,
  report_source varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  longitude_gcj02 double NULL DEFAULT NULL,
  latitude_gcj02 double NULL DEFAULT NULL,
  longitude_wgs84 double NULL DEFAULT NULL,
  latitude_wgs84 double NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_device_mobile_position
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_gb_stream
-- ----------------------------
CREATE TABLE wvp_gb_stream  (
  gb_stream_id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  app varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  stream varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  gb_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  longitude double NULL DEFAULT NULL,
  latitude double NULL DEFAULT NULL,
  stream_type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  media_server_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (gb_stream_id) USING BTREE,
  UNIQUE INDEX gb_stream_id(gb_stream_id) USING BTREE,
  UNIQUE INDEX uk_gb_stream_unique_gb_id(gb_id) USING BTREE,
  UNIQUE INDEX uk_gb_stream_unique_app_stream(app, stream) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_gb_stream
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_log
-- ----------------------------
CREATE TABLE wvp_log  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  name varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  uri varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  address varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  result varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  timing bigint NULL DEFAULT NULL,
  username varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6233 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_log
-- ----------------------------
INSERT INTO wvp_log VALUES (1, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 27, '', '2024-05-07 14:09:08');
INSERT INTO wvp_log VALUES (2, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 42, '', '2024-05-07 14:09:08');
INSERT INTO wvp_log VALUES (3, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 8, '', '2024-05-07 14:09:20');
INSERT INTO wvp_log VALUES (4, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 28, '', '2024-05-07 14:09:20');
INSERT INTO wvp_log VALUES (5, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 60, '', '2024-05-07 14:09:21');
INSERT INTO wvp_log VALUES (6, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 81, '', '2024-05-07 14:09:21');
INSERT INTO wvp_log VALUES (7, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 35, '', '2024-05-07 14:09:35');
INSERT INTO wvp_log VALUES (8, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 56, '', '2024-05-07 14:09:35');
INSERT INTO wvp_log VALUES (9, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-ACTIVE', '127.0.0.1', '200 OK', 37, '', '2024-05-07 14:10:07');
INSERT INTO wvp_log VALUES (10, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-ACTIVE', '127.0.0.1', '200 OK', 47, '', '2024-05-07 14:10:07');
INSERT INTO wvp_log VALUES (11, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001110000002/TCP-PASSIVE', '127.0.0.1', '200 OK', 20, '', '2024-05-07 14:10:09');
INSERT INTO wvp_log VALUES (12, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001110000002/TCP-PASSIVE', '127.0.0.1', '200 OK', 32, '', '2024-05-07 14:10:09');
INSERT INTO wvp_log VALUES (13, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-PASSIVE', '127.0.0.1', '200 OK', 29, '', '2024-05-07 14:10:11');
INSERT INTO wvp_log VALUES (14, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-PASSIVE', '127.0.0.1', '200 OK', 40, '', '2024-05-07 14:10:11');
INSERT INTO wvp_log VALUES (15, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000002/TCP-PASSIVE', '127.0.0.1', '200 OK', 22, '', '2024-05-07 14:10:12');
INSERT INTO wvp_log VALUES (16, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000002/TCP-PASSIVE', '127.0.0.1', '200 OK', 31, '', '2024-05-07 14:10:12');
INSERT INTO wvp_log VALUES (17, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 10, '', '2024-05-07 14:10:19');
INSERT INTO wvp_log VALUES (18, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 21, '', '2024-05-07 14:10:19');
INSERT INTO wvp_log VALUES (19, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 37, '', '2024-05-07 14:10:20');
INSERT INTO wvp_log VALUES (20, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 48, '', '2024-05-07 14:10:20');
INSERT INTO wvp_log VALUES (21, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 19, '', '2024-05-07 14:10:23');
INSERT INTO wvp_log VALUES (22, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 31, '', '2024-05-07 14:10:23');
INSERT INTO wvp_log VALUES (23, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 29, '', '2024-05-07 14:12:29');
INSERT INTO wvp_log VALUES (24, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 51, '', '2024-05-07 14:12:29');
INSERT INTO wvp_log VALUES (25, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 82, '', '2024-05-07 14:12:30');
INSERT INTO wvp_log VALUES (26, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 93, '', '2024-05-07 14:12:30');
INSERT INTO wvp_log VALUES (27, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-ACTIVE', '127.0.0.1', '200 OK', 20, '', '2024-05-07 14:12:52');
INSERT INTO wvp_log VALUES (28, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000001/TCP-ACTIVE', '127.0.0.1', '200 OK', 29, '', '2024-05-07 14:12:52');
INSERT INTO wvp_log VALUES (29, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001110000002/TCP-ACTIVE', '127.0.0.1', '200 OK', 17, '', '2024-05-07 14:12:53');
INSERT INTO wvp_log VALUES (30, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001110000002/TCP-ACTIVE', '127.0.0.1', '200 OK', 26, '', '2024-05-07 14:12:53');
INSERT INTO wvp_log VALUES (31, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000002/TCP-ACTIVE', '127.0.0.1', '200 OK', 17, '', '2024-05-07 14:12:55');
INSERT INTO wvp_log VALUES (32, '[设备查询] 修改数据流传输模式', 'POST', '/api/device/query/transport/34020000001320000002/TCP-ACTIVE', '127.0.0.1', '200 OK', 26, '', '2024-05-07 14:12:55');
INSERT INTO wvp_log VALUES (33, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 7, '', '2024-05-07 14:13:02');
INSERT INTO wvp_log VALUES (34, '', 'GET', '/api/device/query/tree/34020000001110000002', '127.0.0.1', '200 OK', 18, '', '2024-05-07 14:13:02');
INSERT INTO wvp_log VALUES (35, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 24, '', '2024-05-07 14:13:02');
INSERT INTO wvp_log VALUES (36, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 42, '', '2024-05-07 14:13:02');
INSERT INTO wvp_log VALUES (37, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 16, '', '2024-05-07 14:13:13');
INSERT INTO wvp_log VALUES (38, '开始点播', 'GET', '/api/play/start/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 34, '', '2024-05-07 14:13:13');
INSERT INTO wvp_log VALUES (39, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 13, '', '2024-05-07 14:14:38');
INSERT INTO wvp_log VALUES (40, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 23, '', '2024-05-07 14:14:38');
INSERT INTO wvp_log VALUES (41, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 7, '', '2024-05-07 14:14:39');
INSERT INTO wvp_log VALUES (42, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 17, '', '2024-05-07 14:14:39');
INSERT INTO wvp_log VALUES (43, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 10, '', '2024-05-07 14:14:40');
INSERT INTO wvp_log VALUES (44, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 28, '', '2024-05-07 14:14:40');
INSERT INTO wvp_log VALUES (45, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 15, '', '2024-05-07 14:14:41');
INSERT INTO wvp_log VALUES (46, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 26, '', '2024-05-07 14:14:41');
INSERT INTO wvp_log VALUES (47, '', 'GET', '/api/platform/query/15/1', '127.0.0.1', '200 OK', 13, '', '2024-05-07 14:14:42');
INSERT INTO wvp_log VALUES (48, '', 'GET', '/api/platform/query/15/1', '127.0.0.1', '200 OK', 22, '', '2024-05-07 14:14:42');
INSERT INTO wvp_log VALUES (49, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 6, '', '2024-05-07 14:15:02');
INSERT INTO wvp_log VALUES (50, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 15, '', '2024-05-07 14:15:02');
INSERT INTO wvp_log VALUES (51, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 7, '', '2024-05-07 14:15:04');
INSERT INTO wvp_log VALUES (52, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 16, '', '2024-05-07 14:15:04');
INSERT INTO wvp_log VALUES (53, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 8, '', '2024-05-07 14:15:05');
INSERT INTO wvp_log VALUES (54, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 21, '', '2024-05-07 14:15:05');
INSERT INTO wvp_log VALUES (55, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 8, '', '2024-05-07 14:15:13');
INSERT INTO wvp_log VALUES (56, '', 'GET', '/api/push/list', '127.0.0.1', '200 OK', 17, '', '2024-05-07 14:15:13');
INSERT INTO wvp_log VALUES (57, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 5, '', '2024-05-07 14:15:14');
INSERT INTO wvp_log VALUES (58, '', 'GET', '/api/proxy/list', '127.0.0.1', '200 OK', 15, '', '2024-05-07 14:15:14');
INSERT INTO wvp_log VALUES (59, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 5, '', '2024-05-07 14:15:14');
INSERT INTO wvp_log VALUES (60, '', 'GET', '/api/cloud/record/list', '127.0.0.1', '200 OK', 14, '', '2024-05-07 14:15:14');
INSERT INTO wvp_log VALUES (61, '', 'GET', '/api/platform/query/15/1', '127.0.0.1', '200 OK', 7, '', '2024-05-07 14:15:17');
INSERT INTO wvp_log VALUES (62, '', 'GET', '/api/platform/query/15/1', '127.0.0.1', '200 OK', 27, '', '2024-05-07 14:15:17');
INSERT INTO wvp_log VALUES (63, '', 'GET', '/api/role/all', '127.0.0.1', '200 OK', 7, '', '2024-05-07 14:15:19');
INSERT INTO wvp_log VALUES (6221, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 4, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6222, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 22, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6223, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 1, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6224, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 3, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6225, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000006', '127.0.0.1', '200 OK', 2, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6226, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000001', '127.0.0.1', '200 OK', 25, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6227, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000006', '127.0.0.1', '200 OK', 31, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6228, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 31, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6229, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000006', '127.0.0.1', '200 OK', 2, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6230, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000006', '127.0.0.1', '200 OK', 22, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6231, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 3, '', '2024-06-21 09:55:21');
INSERT INTO wvp_log VALUES (6232, '', 'GET', '/api/device/query/snap/34020000001110000002/34020000001320000003', '127.0.0.1', '200 OK', 21, '', '2024-06-21 09:55:21');

-- ----------------------------
-- Records of wvp_platform
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_platform_catalog
-- ----------------------------
CREATE TABLE wvp_platform_catalog  (
  id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  platform_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  parent_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  civil_code varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  business_group_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  UNIQUE INDEX uk_platform_catalog_id_platform_id(id, platform_id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_platform_catalog
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_platform_gb_channel
-- ----------------------------
CREATE TABLE wvp_platform_gb_channel  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  platform_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  catalog_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  device_channel_id int NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_platform_gb_channel_platform_id_catalog_id_device_channel_id(platform_id, catalog_id, device_channel_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_platform_gb_channel
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_platform_gb_stream
-- ----------------------------
CREATE TABLE wvp_platform_gb_stream  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  platform_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  catalog_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  gb_stream_id int NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_platform_gb_stream_platform_id_catalog_id_gb_stream_id(platform_id, catalog_id, gb_stream_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_platform_gb_stream
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_resources_tree
-- ----------------------------
CREATE TABLE wvp_resources_tree  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  is_catalog tinyint(1) NULL DEFAULT 1,
  device_channel_id int NULL DEFAULT NULL,
  gb_stream_id int NULL DEFAULT NULL,
  name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  parentId int NULL DEFAULT NULL,
  path varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_resources_tree
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_stream_proxy
-- ----------------------------
CREATE TABLE wvp_stream_proxy  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  app varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  url varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  src_url varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  dst_url varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  timeout_ms int NULL DEFAULT NULL,
  ffmpeg_cmd_key varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  rtp_type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  media_server_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  enable_audio tinyint(1) NULL DEFAULT 0,
  enable_mp4 tinyint(1) NULL DEFAULT 0,
  enable tinyint(1) NULL DEFAULT 0,
  status tinyint(1) NULL DEFAULT NULL,
  enable_remove_none_reader tinyint(1) NULL DEFAULT 0,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  update_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream_key varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  enable_disable_none_reader tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_stream_proxy_app_stream(app, stream) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_stream_proxy
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_stream_push
-- ----------------------------
CREATE TABLE wvp_stream_push  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  app varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  total_reader_count varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  origin_type int NULL DEFAULT NULL,
  origin_type_str varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  alive_second int NULL DEFAULT NULL,
  media_server_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  server_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  push_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  status tinyint(1) NULL DEFAULT 0,
  update_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  push_ing tinyint(1) NULL DEFAULT 0,
  self tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_stream_push_app_stream(app, stream) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_user_api_key
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_user_role
-- ----------------------------
CREATE TABLE wvp_user_role  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  name varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  authority varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  update_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_user_role
-- ----------------------------
INSERT INTO wvp_user_role VALUES (1, 'admin', '0', '2021-04-13 14:14:57', '2021-04-13 14:14:57');

