casic-wvp-gb/数据库/sys-video.sql at c11599d0bb7d251f85d6e694e735af0edf591eee

Fork: 0
casic2.0 / casic-wvp-gb
Find file
Newer
Older
casic-wvp-gb / 数据库 / sys-video.sql
liwenhao on 21 Jun 2024 42 KB 神舟通用sql脚本更新
Raw Blame History
/*
 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
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wvp_cloud_record
-- ----------------------------
DROP TABLE IF EXISTS 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;

-- ----------------------------
-- Records of wvp_cloud_record
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_device
-- ----------------------------
DROP TABLE IF EXISTS wvp_device;
CREATE TABLE wvp_device  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  device_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,
  manufacturer varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  model varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  firmware varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  transport varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream_mode varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  on_line tinyint(1) NULL DEFAULT 0,
  register_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  keepalive_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  ip 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,
  port int NULL DEFAULT NULL,
  expires int NULL DEFAULT NULL,
  subscribe_cycle_for_catalog int NULL DEFAULT 0,
  subscribe_cycle_for_mobile_position int NULL DEFAULT 0,
  mobile_position_submission_interval int NULL DEFAULT 5,
  subscribe_cycle_for_alarm int NULL DEFAULT 0,
  host_address varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  charset varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  ssrc_check tinyint(1) NULL DEFAULT 0,
  geo_coord_sys 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,
  custom_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  sdp_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  local_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  password varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  as_message_channel tinyint(1) NULL DEFAULT 0,
  keepalive_interval_time int NULL DEFAULT NULL,
  broadcast_push_after_ack tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_device_device(device_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_device
-- ----------------------------
INSERT INTO wvp_device VALUES (12, '34020000001110000002', 'DeepinMind', 'HIKVISION', 'iDS-6708NX/AI-V2', 'V4.41.105', 'UDP', 'TCP-ACTIVE', 1, '2024-06-21 09:53:41', '2024-06-21 10:11:41', '192.168.83.41', '2024-05-23 19:04:53', '2024-06-21 10:11:41', 5060, 86400, 0, 0, 5, 0, '192.168.83.41:5060', 'GB2312', 0, 'WGS84', NULL, 'DeepinMind', NULL, '192.168.83.41', NULL, 0, 59, 0);
INSERT INTO wvp_device VALUES (13, '41010500002000000003', 'DH-NVR402-I', 'Dahua', 'DH-NVR402-I', '4.000.0000000.1,2019-08-09', 'UDP', 'TCP-ACTIVE', 1, '2024-06-21 09:52:29', '2024-06-21 10:12:29', '192.168.83.171', '2024-06-04 17:18:55', '2024-06-21 10:12:29', 5060, 3600, 0, 0, 5, 0, '192.168.83.171:5060', 'GB2312', 0, 'WGS84', NULL, 'DH-NVR402-I', NULL, '192.168.83.171', NULL, 0, 60, 0);

-- ----------------------------
-- Table structure for wvp_device_alarm
-- ----------------------------
DROP TABLE IF EXISTS 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_channel
-- ----------------------------
DROP TABLE IF EXISTS wvp_device_channel;
CREATE TABLE wvp_device_channel  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  channel_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,
  custom_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  manufacture varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  model varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  owner 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,
  block varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  address varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  parent_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  safety_way int NULL DEFAULT NULL,
  register_way int NULL DEFAULT NULL,
  cert_num varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  certifiable int NULL DEFAULT NULL,
  err_code int NULL DEFAULT NULL,
  end_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  secrecy varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  ip_address varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  port int NULL DEFAULT NULL,
  password varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  ptz_type int NULL DEFAULT NULL,
  custom_ptz_type int NULL DEFAULT NULL,
  status tinyint(1) NULL DEFAULT 0,
  longitude double NULL DEFAULT NULL,
  custom_longitude double NULL DEFAULT NULL,
  latitude double NULL DEFAULT NULL,
  custom_latitude double NULL DEFAULT NULL,
  stream_id varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  device_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  parental varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  has_audio tinyint(1) NULL DEFAULT 0,
  create_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  update_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  sub_count int 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,
  business_group_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  gps_time varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream_identification varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_wvp_device_channel_unique_device_channel(device_id, channel_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_device_channel
-- ----------------------------
INSERT INTO wvp_device_channel VALUES (22, '34020000001320000001', 'casic04', NULL, 'Manufacturer', 'Camera', 'Owner', NULL, NULL, '192.168.83.44', NULL, 0, 1, NULL, 0, 0, NULL, '0', NULL, 0, NULL, 3, NULL, 0, 0, 0, 0, 0, NULL, '34020000001110000002', '0', 0, '2024-05-23 11:04:53', '2024-06-21 09:52:38', 0, 0, 0, 0, 0, NULL, '2024-06-21 09:52:38', NULL);
INSERT INTO wvp_device_channel VALUES (23, '34020000001320000003', 'casic01', NULL, 'Manufacturer', 'Camera', 'Owner', NULL, NULL, '192.168.83.170', NULL, 0, 1, NULL, 0, 0, NULL, '0', NULL, 0, NULL, 3, NULL, 1, 0, 0, 0, 0, NULL, '34020000001110000002', '0', 0, '2024-05-23 11:04:53', '2024-06-21 09:52:38', 0, 0, 0, 0, 0, NULL, '2024-06-21 09:52:38', NULL);
INSERT INTO wvp_device_channel VALUES (24, '34020000001320000006', 'casic02', NULL, 'Manufacturer', 'Camera', 'Owner', NULL, NULL, '192.168.83.169', NULL, 0, 1, NULL, 0, 0, NULL, '0', NULL, 0, NULL, 3, NULL, 0, 0, 0, 0, 0, NULL, '34020000001110000002', '0', 0, '2024-05-23 11:04:53', '2024-06-21 09:52:38', 0, 0, 0, 0, 0, NULL, '2024-06-21 09:52:38', NULL);
INSERT INTO wvp_device_channel VALUES (25, '34020000001110000013', 'IPC', NULL, 'Dahua', 'DH-NVR402-I', '0', '340200', NULL, 'axy', '41010500002000000003', 0, 1, NULL, 0, 0, NULL, '0', '192.168.83.172', 37777, NULL, 3, NULL, 1, 0, 0, 0, 0, NULL, '41010500002000000003', '0', 0, '2024-06-04 09:18:55', '2024-06-21 09:45:47', 0, 0, 0, 0, 0, NULL, '2024-06-21 09:45:47', 'stream:1');
INSERT INTO wvp_device_channel VALUES (29, '34020000001310000033', 'GB_Chn_033', NULL, 'Dahua', 'DH-NVR402-I', '0', '340200', NULL, 'axy', '41010500002000000003', 0, 1, NULL, 0, 0, NULL, '0', NULL, 0, NULL, 3, NULL, 1, 0, 0, 0, 0, NULL, '41010500002000000003', '0', 0, '2024-06-04 10:43:35', '2024-06-21 09:45:47', 0, 0, 0, 0, 0, NULL, '2024-06-21 09:45:47', NULL);

-- ----------------------------
-- Table structure for wvp_device_mobile_position
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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');

-- ----------------------------
-- Table structure for wvp_media_server
-- ----------------------------
DROP TABLE IF EXISTS wvp_media_server;
CREATE TABLE wvp_media_server  (
  id varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  hook_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  sdp_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  stream_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  http_port int NULL DEFAULT NULL,
  http_ssl_port int NULL DEFAULT NULL,
  rtmp_port int NULL DEFAULT NULL,
  rtmp_ssl_port int NULL DEFAULT NULL,
  rtp_proxy_port int NULL DEFAULT NULL,
  rtsp_port int NULL DEFAULT NULL,
  rtsp_ssl_port int NULL DEFAULT NULL,
  flv_port int NULL DEFAULT NULL,
  flv_ssl_port int NULL DEFAULT NULL,
  ws_flv_port int NULL DEFAULT NULL,
  ws_flv_ssl_port int NULL DEFAULT NULL,
  auto_config tinyint(1) NULL DEFAULT 0,
  secret varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  type varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'zlm',
  rtp_enable tinyint(1) NULL DEFAULT 0,
  rtp_port_range varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  send_rtp_port_range varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  record_assist_port int NULL DEFAULT NULL,
  default_server tinyint(1) NULL DEFAULT 0,
  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,
  hook_alive_interval int NULL DEFAULT NULL,
  record_path varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  record_day int NULL DEFAULT 7,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX uk_media_server_unique_ip_http_port(ip, http_port) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_media_server
-- ----------------------------
INSERT INTO wvp_media_server VALUES ('your_server_id', '192.168.83.42', '192.168.83.37', '192.168.83.42', '192.168.83.42', 8080, 443, 1935, 0, 10000, 554, 0, 8080, 0, 8080, 0, 1, 'vcOhVPzPUgfcvDLLWTFjgBgVNrCkvi7P', 'zlm', 1, '30000,30050', '56502,56506', 0, 1, '2024-05-14 09:01:57', '2024-06-21 09:52:11', 10, '', 7);

-- ----------------------------
-- Table structure for wvp_platform
-- ----------------------------
DROP TABLE IF EXISTS wvp_platform;
CREATE TABLE wvp_platform  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  enable tinyint(1) NULL DEFAULT 0,
  name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  server_gb_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  server_gb_domain varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  server_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  server_port int NULL DEFAULT NULL,
  device_gb_id varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  device_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  device_port varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  username varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  password varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  expires varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  keep_timeout varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  transport varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  character_set 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,
  ptz tinyint(1) NULL DEFAULT 0,
  rtcp tinyint(1) NULL DEFAULT 0,
  status tinyint(1) NULL DEFAULT 0,
  start_offline_push tinyint(1) NULL DEFAULT 0,
  administrative_division varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  catalog_group int 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,
  as_message_channel tinyint(1) NULL DEFAULT 0,
  auto_push_channel tinyint(1) NULL DEFAULT 0,
  send_stream_ip varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_platform_unique_server_gb_id(server_gb_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for wvp_platform_catalog
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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
-- ----------------------------
DROP TABLE IF EXISTS 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_stream_push
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_user
-- ----------------------------
DROP TABLE IF EXISTS wvp_user;
CREATE TABLE wvp_user  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  username varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  password varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  role_id int 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,
  push_key varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE,
  UNIQUE INDEX id(id) USING BTREE,
  UNIQUE INDEX uk_user_username(username) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wvp_user
-- ----------------------------
INSERT INTO wvp_user VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '2021-04-13 14:14:57', '2021-04-13 14:14:57', '3e80d1762a324d5b0ff636e0bd16f1e3');

-- ----------------------------
-- Table structure for wvp_user_api_key
-- ----------------------------
DROP TABLE IF EXISTS wvp_user_api_key;
CREATE TABLE wvp_user_api_key  (
  id bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id bigint NULL DEFAULT NULL,
  app varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  api_key text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  expired_at bigint NULL DEFAULT NULL,
  remark varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  enable tinyint(1) NULL DEFAULT 1,
  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_api_key
-- ----------------------------

-- ----------------------------
-- Table structure for wvp_user_role
-- ----------------------------
DROP TABLE IF EXISTS 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');

SET FOREIGN_KEY_CHECKS = 1;