diff --git a/pom.xml b/pom.xml index 4975e75..b782b42 100644 --- a/pom.xml +++ b/pom.xml @@ -10,7 +10,7 @@ com.genersoft - casic-sip-gb + casic-wvp-gb 2.7.2 web video platform 国标28181视频平台 @@ -146,7 +146,6 @@ postgresql 42.5.1 - com.github.pagehelper pagehelper-spring-boot-starter 1.4.6 - @@ -191,8 +188,6 @@ dynamic-datasource-spring-boot-starter 3.6.1 - - org.springdoc @@ -205,7 +200,6 @@ knife4j-springdoc-ui 3.0.3 - javax.validation diff --git a/pom.xml b/pom.xml index 4975e75..b782b42 100644 --- a/pom.xml +++ b/pom.xml @@ -10,7 +10,7 @@ com.genersoft - casic-sip-gb + casic-wvp-gb 2.7.2 web video platform 国标28181视频平台 @@ -146,7 +146,6 @@ postgresql 42.5.1 - com.github.pagehelper pagehelper-spring-boot-starter 1.4.6 - @@ -191,8 +188,6 @@ dynamic-datasource-spring-boot-starter 3.6.1 - - org.springdoc @@ -205,7 +200,6 @@ knife4j-springdoc-ui 3.0.3 - javax.validation diff --git "a/\346\225\260\346\215\256\345\272\223/shentong.sql" "b/\346\225\260\346\215\256\345\272\223/shentong.sql" new file mode 100644 index 0000000..4e42296 --- /dev/null +++ "b/\346\225\260\346\215\256\345\272\223/shentong.sql" @@ -0,0 +1,398 @@ + +-- +--Table DDL +-- +CREATE TABLE WVP_USER.WVP_CLOUD_RECORD +( + ID bigint DEFAULT NEXTVAL('wvp_cloud_record_index'::text) NOT NULL, + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + CALL_ID character varying(255) DEFAULT NULL , + START_TIME bigint DEFAULT NULL , + END_TIME bigint DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + FILE_NAME character varying(255) DEFAULT NULL , + FOLDER character varying(255) DEFAULT NULL , + FILE_PATH character varying(255) DEFAULT NULL , + COLLECT tinyint DEFAULT 0 , + FILE_SIZE bigint DEFAULT NULL , + TIME_LEN bigint DEFAULT NULL , + CONSTRAINT WVP_CLOUD_RECORD_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_STREAM_PUSH_APP_STREAM_PATH ON WVP_USER.WVP_CLOUD_RECORD USING BTREE ("APP", STREAM, FILE_PATH) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE +( + ID bigint DEFAULT NEXTVAL('wvp_device_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + MANUFACTURER character varying(255) DEFAULT NULL , + MODEL character varying(255) DEFAULT NULL , + FIRMWARE character varying(255) DEFAULT NULL , + TRANSPORT character varying(50) DEFAULT NULL , + STREAM_MODE character varying(50) DEFAULT NULL , + ON_LINE tinyint DEFAULT 0 , + REGISTER_TIME character varying(50) DEFAULT NULL , + KEEPALIVE_TIME character varying(50) DEFAULT NULL , + "IP" character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + "PORT" integer DEFAULT NULL , + EXPIRES integer DEFAULT NULL , + SUBSCRIBE_CYCLE_FOR_CATALOG integer DEFAULT 0 , + SUBSCRIBE_CYCLE_FOR_MOBILE_POSITION integer DEFAULT 0 , + MOBILE_POSITION_SUBMISSION_INTERVAL integer DEFAULT 5 , + SUBSCRIBE_CYCLE_FOR_ALARM integer DEFAULT 0 , + HOST_ADDRESS character varying(50) DEFAULT NULL , + CHARSET character varying(50) DEFAULT NULL , + SSRC_CHECK tinyint DEFAULT 0 , + GEO_COORD_SYS character varying(50) DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + CUSTOM_NAME character varying(255) DEFAULT NULL , + SDP_IP character varying(50) DEFAULT NULL , + LOCAL_IP character varying(50) DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + AS_MESSAGE_CHANNEL tinyint DEFAULT 0 , + KEEPALIVE_INTERVAL_TIME integer DEFAULT NULL , + BROADCAST_PUSH_AFTER_ACK tinyint DEFAULT 0 , + CONSTRAINT WVP_DEVICE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_DEVICE_DEVICE ON WVP_USER.WVP_DEVICE USING BTREE (DEVICE_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE_ALARM +( + ID bigint DEFAULT NEXTVAL('wvp_device_alarm_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + ALARM_PRIORITY character varying(50) DEFAULT NULL , + ALARM_METHOD character varying(50) DEFAULT NULL , + ALARM_TIME character varying(50) DEFAULT NULL , + ALARM_DESCRIPTION character varying(255) DEFAULT NULL , + LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + ALARM_TYPE character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) NOT NULL, + CONSTRAINT WVP_DEVICE_ALARM_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_DEVICE_CHANNEL +( + ID bigint DEFAULT NEXTVAL('wvp_device_channel_id_seq'::text) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + CUSTOM_NAME character varying(255) DEFAULT NULL , + MANUFACTURE character varying(50) DEFAULT NULL , + MODEL character varying(50) DEFAULT NULL , + "OWNER" character varying(50) DEFAULT NULL , + CIVIL_CODE character varying(50) DEFAULT NULL , + "BLOCK" character varying(50) DEFAULT NULL , + ADDRESS character varying(50) DEFAULT NULL , + PARENT_ID character varying(50) DEFAULT NULL , + SAFETY_WAY integer DEFAULT NULL , + REGISTER_WAY integer DEFAULT NULL , + CERT_NUM character varying(50) DEFAULT NULL , + CERTIFIABLE integer DEFAULT NULL , + ERR_CODE integer DEFAULT NULL , + END_TIME character varying(50) DEFAULT NULL , + SECRECY character varying(50) DEFAULT NULL , + IP_ADDRESS character varying(50) DEFAULT NULL , + "PORT" integer DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + PTZ_TYPE integer DEFAULT NULL , + CUSTOM_PTZ_TYPE integer DEFAULT NULL , + STATUS tinyint DEFAULT 0 , + LONGITUDE float(53) DEFAULT NULL , + CUSTOM_LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + CUSTOM_LATITUDE float(53) DEFAULT NULL , + STREAM_ID character varying(255) DEFAULT NULL , + DEVICE_ID character varying(50) NOT NULL, + PARENTAL character varying(50) DEFAULT NULL , + HAS_AUDIO tinyint DEFAULT 0 , + CREATE_TIME character varying(50) NOT NULL, + UPDATE_TIME character varying(50) NOT NULL, + SUB_COUNT integer DEFAULT NULL , + LONGITUDE_GCJ02 float(53) DEFAULT NULL , + LATITUDE_GCJ02 float(53) DEFAULT NULL , + LONGITUDE_WGS84 float(53) DEFAULT NULL , + LATITUDE_WGS84 float(53) DEFAULT NULL , + BUSINESS_GROUP_ID character varying(50) DEFAULT NULL , + GPS_TIME character varying(50) DEFAULT NULL , + STREAM_IDENTIFICATION character varying(50) DEFAULT NULL , + CONSTRAINT WVP_DEVICE_CHANNEL_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_WVP_DEVICE_CHANNEL_UNIQUE_DEVICE_CHANNEL ON WVP_USER.WVP_DEVICE_CHANNEL USING BTREE (DEVICE_ID, CHANNEL_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE_MOBILE_POSITION +( + ID bigint DEFAULT NEXTVAL('wvp_device_mobile_position_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + DEVICE_NAME character varying(255) DEFAULT NULL , + "TIME" character varying(50) DEFAULT NULL , + LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + ALTITUDE float(53) DEFAULT NULL , + SPEED float(53) DEFAULT NULL , + DIRECTION float(53) DEFAULT NULL , + REPORT_SOURCE character varying(50) DEFAULT NULL , + LONGITUDE_GCJ02 float(53) DEFAULT NULL , + LATITUDE_GCJ02 float(53) DEFAULT NULL , + LONGITUDE_WGS84 float(53) DEFAULT NULL , + LATITUDE_WGS84 float(53) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + CONSTRAINT WVP_DEVICE_MOBILE_POSITION_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_GB_STREAM +( + GB_STREAM_ID bigint DEFAULT NEXTVAL('seq_gb_stream_id'::text) NOT NULL, + "APP" character varying(255) NOT NULL, + STREAM character varying(255) NOT NULL, + GB_ID character varying(50) NOT NULL, + "NAME" character varying(255) , + LONGITUDE float(53) , + LATITUDE float(53) , + STREAM_TYPE character varying(50) , + MEDIA_SERVER_ID character varying(50) , + CREATE_TIME character varying(50) , + CONSTRAINT WVP_GB_STREAM_PKEY PRIMARY KEY (GB_STREAM_ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_LOG +( + ID bigint DEFAULT NEXTVAL('seq_wvp_log_id'::text) NOT NULL, + "NAME" character varying(50) , + "TYPE" character varying(50) , + URI character varying(200) , + ADDRESS character varying(50) , + "RESULT" character varying(50) , + TIMING bigint , + USERNAME character varying(50) , + CREATE_TIME character varying(50) , + CONSTRAINT WVP_LOG_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_MEDIA_SERVER +( + ID character varying(255) NOT NULL, + "IP" character varying(50) , + HOOK_IP character varying(50) , + SDP_IP character varying(50) , + STREAM_IP character varying(50) , + HTTP_PORT integer , + HTTP_SSL_PORT integer , + RTMP_PORT integer , + RTMP_SSL_PORT integer , + RTP_PROXY_PORT integer , + RTSP_PORT integer , + RTSP_SSL_PORT integer , + FLV_PORT integer , + FLV_SSL_PORT integer , + WS_FLV_PORT integer , + WS_FLV_SSL_PORT integer , + AUTO_CONFIG tinyint , + SECRET character varying(50) , + "TYPE" character varying(50) DEFAULT 'zlm' , + RTP_ENABLE tinyint , + RTP_PORT_RANGE character varying(50) , + SEND_RTP_PORT_RANGE character varying(50) , + RECORD_ASSIST_PORT integer , + DEFAULT_SERVER tinyint , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + HOOK_ALIVE_INTERVAL integer , + RECORD_PATH character varying(255) , + RECORD_DAY integer DEFAULT 7 , + CONSTRAINT WVP_MEDIA_SERVER_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_MEDIA_SERVER_UNIQUE_IP_HTTP_PORT ON WVP_USER.WVP_MEDIA_SERVER USING BTREE ("IP", HTTP_PORT) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_PLATFORM +( + ID bigint DEFAULT NEXTVAL('wvp_platform_id_seq'::text) NOT NULL, + "ENABLE" tinyint DEFAULT 0 , + "NAME" character varying(255) DEFAULT NULL , + SERVER_GB_ID character varying(50) DEFAULT NULL , + SERVER_GB_DOMAIN character varying(50) DEFAULT NULL , + SERVER_IP character varying(50) DEFAULT NULL , + SERVER_PORT integer DEFAULT NULL , + DEVICE_GB_ID character varying(50) DEFAULT NULL , + DEVICE_IP character varying(50) DEFAULT NULL , + DEVICE_PORT character varying(50) DEFAULT NULL , + USERNAME character varying(255) DEFAULT NULL , + "PASSWORD" character varying(50) DEFAULT NULL , + EXPIRES character varying(50) DEFAULT NULL , + KEEP_TIMEOUT character varying(50) DEFAULT NULL , + TRANSPORT character varying(50) DEFAULT NULL , + CHARACTER_SET character varying(50) DEFAULT NULL , + CATALOG_ID character varying(50) DEFAULT NULL , + PTZ tinyint DEFAULT 0 , + RTCP tinyint DEFAULT 0 , + STATUS tinyint DEFAULT 0 , + START_OFFLINE_PUSH tinyint DEFAULT 0 , + ADMINISTRATIVE_DIVISION character varying(50) DEFAULT NULL , + CATALOG_GROUP integer DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + AS_MESSAGE_CHANNEL tinyint DEFAULT 0 , + AUTO_PUSH_CHANNEL tinyint DEFAULT 0 , + SEND_STREAM_IP character varying(50) DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_PLATFORM_CATALOG +( + ID character varying(50) DEFAULT NULL NOT NULL, + PLATFORM_ID character varying(50) DEFAULT NULL NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + PARENT_ID character varying(50) DEFAULT NULL , + CIVIL_CODE character varying(50) DEFAULT NULL , + BUSINESS_GROUP_ID character varying(50) DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_CATALOG_PKEY PRIMARY KEY (ID, PLATFORM_ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_PLATFORM_GB_CHANNEL +( + ID bigint DEFAULT NEXTVAL('wvp_platform_gb_channel_id_seq'::text) NOT NULL, + PLATFORM_ID character varying(50) DEFAULT NULL , + CATALOG_ID character varying(50) DEFAULT NULL , + DEVICE_CHANNEL_ID integer DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_GB_CHANNEL_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_RESOURCES_TREE +( + ID bigint DEFAULT NEXTVAL('seq_wvp_resources_tree_id'::text) NOT NULL, + IS_CATALOG boolean , + DEVICE_CHANNEL_ID integer , + GB_STREAM_ID integer , + "NAME" character varying(255) , + PARENTID integer , + "PATH" character varying(255) , + CONSTRAINT WVP_RESOURCES_TREE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_STREAM_PROXY +( + ID bigint DEFAULT NEXTVAL('wvp_stream_proxy_id_seq'::text) NOT NULL, + "TYPE" character varying(50) DEFAULT NULL , + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + URL character varying(255) DEFAULT NULL , + SRC_URL character varying(255) DEFAULT NULL , + DST_URL character varying(255) DEFAULT NULL , + TIMEOUT_MS integer DEFAULT NULL , + FFMPEG_CMD_KEY character varying(255) DEFAULT NULL , + RTP_TYPE character varying(50) DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + ENABLE_AUDIO tinyint DEFAULT 0 , + ENABLE_MP4 tinyint DEFAULT 0 , + "ENABLE" tinyint DEFAULT 0 , + STATUS tinyint DEFAULT NULL , + ENABLE_REMOVE_NONE_READER tinyint DEFAULT 0 , + CREATE_TIME character varying(50) DEFAULT NULL , + "NAME" character varying(255) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + STREAM_KEY character varying(255) DEFAULT NULL , + ENABLE_DISABLE_NONE_READER tinyint DEFAULT 0 , + CONSTRAINT WVP_STREAM_PROXY_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_STREAM_PUSH +( + ID bigint DEFAULT NEXTVAL('wvp_stream_push_id_seq'::text) NOT NULL, + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + TOTAL_READER_COUNT character varying(50) DEFAULT NULL , + ORIGIN_TYPE integer DEFAULT NULL , + ORIGIN_TYPE_STR character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + ALIVE_SECOND integer DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + SERVER_ID character varying(50) DEFAULT NULL , + PUSH_TIME character varying(50) DEFAULT NULL , + STATUS tinyint DEFAULT 0 , + UPDATE_TIME character varying(50) DEFAULT NULL , + PUSH_ING tinyint DEFAULT 0 , + SELF tinyint DEFAULT 0 , + CONSTRAINT WVP_STREAM_PUSH_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER +( + ID bigint DEFAULT NEXTVAL('wvp_user_id_seq'::text) NOT NULL, + USERNAME character varying(255) DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + ROLE_ID integer DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + PUSH_KEY character varying(50) DEFAULT NULL , + CONSTRAINT WVP_USER_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER_API_KEY +( + ID bigint DEFAULT NEXTVAL('seq_wvp_user_api_key_id'::text) NOT NULL, + USER_ID bigint , + "APP" character varying(255) , + API_KEY text , + EXPIRED_AT bigint , + REMARK character varying(255) , + "ENABLE" boolean , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + CONSTRAINT WVP_USER_API_KEY_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER_ROLE +( + ID bigint DEFAULT NEXTVAL('seq_wvp_user_role_id'::text) NOT NULL, + "NAME" character varying(50) , + AUTHORITY character varying(50) , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + CONSTRAINT WVP_USER_ROLE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +-- +--Sequence DDL +-- +CREATE SEQUENCE WVP_USER.SEQ_GB_STREAM_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_LOG_ID INCREMENT 1 MINVALUE 1 START 6234 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_RESOURCES_TREE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_API_KEY_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_ROLE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_CLOUD_RECORD_INDEX INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_ALARM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_MOBILE_POSITION_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_PLATFORM_GB_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_PLATFORM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_STREAM_PROXY_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_STREAM_PUSH_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_USER_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON; +INSERT INTO wvp_user VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '2021-04-13 14:14:57', '2021-04-13 14:14:57', '3e80d1762a324d5b0ff636e0bd16f1e3'); +INSERT INTO wvp_user_role VALUES (1, 'admin', '0', '2021-04-13 14:14:57', '2021-04-13 14:14:57'); \ No newline at end of file diff --git a/pom.xml b/pom.xml index 4975e75..b782b42 100644 --- a/pom.xml +++ b/pom.xml @@ -10,7 +10,7 @@ com.genersoft - casic-sip-gb + casic-wvp-gb 2.7.2 web video platform 国标28181视频平台 @@ -146,7 +146,6 @@ postgresql 42.5.1 - com.github.pagehelper pagehelper-spring-boot-starter 1.4.6 - @@ -191,8 +188,6 @@ dynamic-datasource-spring-boot-starter 3.6.1 - - org.springdoc @@ -205,7 +200,6 @@ knife4j-springdoc-ui 3.0.3 - javax.validation diff --git "a/\346\225\260\346\215\256\345\272\223/shentong.sql" "b/\346\225\260\346\215\256\345\272\223/shentong.sql" new file mode 100644 index 0000000..4e42296 --- /dev/null +++ "b/\346\225\260\346\215\256\345\272\223/shentong.sql" @@ -0,0 +1,398 @@ + +-- +--Table DDL +-- +CREATE TABLE WVP_USER.WVP_CLOUD_RECORD +( + ID bigint DEFAULT NEXTVAL('wvp_cloud_record_index'::text) NOT NULL, + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + CALL_ID character varying(255) DEFAULT NULL , + START_TIME bigint DEFAULT NULL , + END_TIME bigint DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + FILE_NAME character varying(255) DEFAULT NULL , + FOLDER character varying(255) DEFAULT NULL , + FILE_PATH character varying(255) DEFAULT NULL , + COLLECT tinyint DEFAULT 0 , + FILE_SIZE bigint DEFAULT NULL , + TIME_LEN bigint DEFAULT NULL , + CONSTRAINT WVP_CLOUD_RECORD_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_STREAM_PUSH_APP_STREAM_PATH ON WVP_USER.WVP_CLOUD_RECORD USING BTREE ("APP", STREAM, FILE_PATH) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE +( + ID bigint DEFAULT NEXTVAL('wvp_device_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + MANUFACTURER character varying(255) DEFAULT NULL , + MODEL character varying(255) DEFAULT NULL , + FIRMWARE character varying(255) DEFAULT NULL , + TRANSPORT character varying(50) DEFAULT NULL , + STREAM_MODE character varying(50) DEFAULT NULL , + ON_LINE tinyint DEFAULT 0 , + REGISTER_TIME character varying(50) DEFAULT NULL , + KEEPALIVE_TIME character varying(50) DEFAULT NULL , + "IP" character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + "PORT" integer DEFAULT NULL , + EXPIRES integer DEFAULT NULL , + SUBSCRIBE_CYCLE_FOR_CATALOG integer DEFAULT 0 , + SUBSCRIBE_CYCLE_FOR_MOBILE_POSITION integer DEFAULT 0 , + MOBILE_POSITION_SUBMISSION_INTERVAL integer DEFAULT 5 , + SUBSCRIBE_CYCLE_FOR_ALARM integer DEFAULT 0 , + HOST_ADDRESS character varying(50) DEFAULT NULL , + CHARSET character varying(50) DEFAULT NULL , + SSRC_CHECK tinyint DEFAULT 0 , + GEO_COORD_SYS character varying(50) DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + CUSTOM_NAME character varying(255) DEFAULT NULL , + SDP_IP character varying(50) DEFAULT NULL , + LOCAL_IP character varying(50) DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + AS_MESSAGE_CHANNEL tinyint DEFAULT 0 , + KEEPALIVE_INTERVAL_TIME integer DEFAULT NULL , + BROADCAST_PUSH_AFTER_ACK tinyint DEFAULT 0 , + CONSTRAINT WVP_DEVICE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_DEVICE_DEVICE ON WVP_USER.WVP_DEVICE USING BTREE (DEVICE_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE_ALARM +( + ID bigint DEFAULT NEXTVAL('wvp_device_alarm_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + ALARM_PRIORITY character varying(50) DEFAULT NULL , + ALARM_METHOD character varying(50) DEFAULT NULL , + ALARM_TIME character varying(50) DEFAULT NULL , + ALARM_DESCRIPTION character varying(255) DEFAULT NULL , + LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + ALARM_TYPE character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) NOT NULL, + CONSTRAINT WVP_DEVICE_ALARM_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_DEVICE_CHANNEL +( + ID bigint DEFAULT NEXTVAL('wvp_device_channel_id_seq'::text) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + CUSTOM_NAME character varying(255) DEFAULT NULL , + MANUFACTURE character varying(50) DEFAULT NULL , + MODEL character varying(50) DEFAULT NULL , + "OWNER" character varying(50) DEFAULT NULL , + CIVIL_CODE character varying(50) DEFAULT NULL , + "BLOCK" character varying(50) DEFAULT NULL , + ADDRESS character varying(50) DEFAULT NULL , + PARENT_ID character varying(50) DEFAULT NULL , + SAFETY_WAY integer DEFAULT NULL , + REGISTER_WAY integer DEFAULT NULL , + CERT_NUM character varying(50) DEFAULT NULL , + CERTIFIABLE integer DEFAULT NULL , + ERR_CODE integer DEFAULT NULL , + END_TIME character varying(50) DEFAULT NULL , + SECRECY character varying(50) DEFAULT NULL , + IP_ADDRESS character varying(50) DEFAULT NULL , + "PORT" integer DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + PTZ_TYPE integer DEFAULT NULL , + CUSTOM_PTZ_TYPE integer DEFAULT NULL , + STATUS tinyint DEFAULT 0 , + LONGITUDE float(53) DEFAULT NULL , + CUSTOM_LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + CUSTOM_LATITUDE float(53) DEFAULT NULL , + STREAM_ID character varying(255) DEFAULT NULL , + DEVICE_ID character varying(50) NOT NULL, + PARENTAL character varying(50) DEFAULT NULL , + HAS_AUDIO tinyint DEFAULT 0 , + CREATE_TIME character varying(50) NOT NULL, + UPDATE_TIME character varying(50) NOT NULL, + SUB_COUNT integer DEFAULT NULL , + LONGITUDE_GCJ02 float(53) DEFAULT NULL , + LATITUDE_GCJ02 float(53) DEFAULT NULL , + LONGITUDE_WGS84 float(53) DEFAULT NULL , + LATITUDE_WGS84 float(53) DEFAULT NULL , + BUSINESS_GROUP_ID character varying(50) DEFAULT NULL , + GPS_TIME character varying(50) DEFAULT NULL , + STREAM_IDENTIFICATION character varying(50) DEFAULT NULL , + CONSTRAINT WVP_DEVICE_CHANNEL_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_WVP_DEVICE_CHANNEL_UNIQUE_DEVICE_CHANNEL ON WVP_USER.WVP_DEVICE_CHANNEL USING BTREE (DEVICE_ID, CHANNEL_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_DEVICE_MOBILE_POSITION +( + ID bigint DEFAULT NEXTVAL('wvp_device_mobile_position_id_seq'::text) NOT NULL, + DEVICE_ID character varying(50) NOT NULL, + CHANNEL_ID character varying(50) NOT NULL, + DEVICE_NAME character varying(255) DEFAULT NULL , + "TIME" character varying(50) DEFAULT NULL , + LONGITUDE float(53) DEFAULT NULL , + LATITUDE float(53) DEFAULT NULL , + ALTITUDE float(53) DEFAULT NULL , + SPEED float(53) DEFAULT NULL , + DIRECTION float(53) DEFAULT NULL , + REPORT_SOURCE character varying(50) DEFAULT NULL , + LONGITUDE_GCJ02 float(53) DEFAULT NULL , + LATITUDE_GCJ02 float(53) DEFAULT NULL , + LONGITUDE_WGS84 float(53) DEFAULT NULL , + LATITUDE_WGS84 float(53) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + CONSTRAINT WVP_DEVICE_MOBILE_POSITION_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_GB_STREAM +( + GB_STREAM_ID bigint DEFAULT NEXTVAL('seq_gb_stream_id'::text) NOT NULL, + "APP" character varying(255) NOT NULL, + STREAM character varying(255) NOT NULL, + GB_ID character varying(50) NOT NULL, + "NAME" character varying(255) , + LONGITUDE float(53) , + LATITUDE float(53) , + STREAM_TYPE character varying(50) , + MEDIA_SERVER_ID character varying(50) , + CREATE_TIME character varying(50) , + CONSTRAINT WVP_GB_STREAM_PKEY PRIMARY KEY (GB_STREAM_ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_LOG +( + ID bigint DEFAULT NEXTVAL('seq_wvp_log_id'::text) NOT NULL, + "NAME" character varying(50) , + "TYPE" character varying(50) , + URI character varying(200) , + ADDRESS character varying(50) , + "RESULT" character varying(50) , + TIMING bigint , + USERNAME character varying(50) , + CREATE_TIME character varying(50) , + CONSTRAINT WVP_LOG_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_MEDIA_SERVER +( + ID character varying(255) NOT NULL, + "IP" character varying(50) , + HOOK_IP character varying(50) , + SDP_IP character varying(50) , + STREAM_IP character varying(50) , + HTTP_PORT integer , + HTTP_SSL_PORT integer , + RTMP_PORT integer , + RTMP_SSL_PORT integer , + RTP_PROXY_PORT integer , + RTSP_PORT integer , + RTSP_SSL_PORT integer , + FLV_PORT integer , + FLV_SSL_PORT integer , + WS_FLV_PORT integer , + WS_FLV_SSL_PORT integer , + AUTO_CONFIG tinyint , + SECRET character varying(50) , + "TYPE" character varying(50) DEFAULT 'zlm' , + RTP_ENABLE tinyint , + RTP_PORT_RANGE character varying(50) , + SEND_RTP_PORT_RANGE character varying(50) , + RECORD_ASSIST_PORT integer , + DEFAULT_SERVER tinyint , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + HOOK_ALIVE_INTERVAL integer , + RECORD_PATH character varying(255) , + RECORD_DAY integer DEFAULT 7 , + CONSTRAINT WVP_MEDIA_SERVER_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; +--Indexes DDL +CREATE UNIQUE INDEX UK_MEDIA_SERVER_UNIQUE_IP_HTTP_PORT ON WVP_USER.WVP_MEDIA_SERVER USING BTREE ("IP", HTTP_PORT) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE; + +CREATE TABLE WVP_USER.WVP_PLATFORM +( + ID bigint DEFAULT NEXTVAL('wvp_platform_id_seq'::text) NOT NULL, + "ENABLE" tinyint DEFAULT 0 , + "NAME" character varying(255) DEFAULT NULL , + SERVER_GB_ID character varying(50) DEFAULT NULL , + SERVER_GB_DOMAIN character varying(50) DEFAULT NULL , + SERVER_IP character varying(50) DEFAULT NULL , + SERVER_PORT integer DEFAULT NULL , + DEVICE_GB_ID character varying(50) DEFAULT NULL , + DEVICE_IP character varying(50) DEFAULT NULL , + DEVICE_PORT character varying(50) DEFAULT NULL , + USERNAME character varying(255) DEFAULT NULL , + "PASSWORD" character varying(50) DEFAULT NULL , + EXPIRES character varying(50) DEFAULT NULL , + KEEP_TIMEOUT character varying(50) DEFAULT NULL , + TRANSPORT character varying(50) DEFAULT NULL , + CHARACTER_SET character varying(50) DEFAULT NULL , + CATALOG_ID character varying(50) DEFAULT NULL , + PTZ tinyint DEFAULT 0 , + RTCP tinyint DEFAULT 0 , + STATUS tinyint DEFAULT 0 , + START_OFFLINE_PUSH tinyint DEFAULT 0 , + ADMINISTRATIVE_DIVISION character varying(50) DEFAULT NULL , + CATALOG_GROUP integer DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + AS_MESSAGE_CHANNEL tinyint DEFAULT 0 , + AUTO_PUSH_CHANNEL tinyint DEFAULT 0 , + SEND_STREAM_IP character varying(50) DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_PLATFORM_CATALOG +( + ID character varying(50) DEFAULT NULL NOT NULL, + PLATFORM_ID character varying(50) DEFAULT NULL NOT NULL, + "NAME" character varying(255) DEFAULT NULL , + PARENT_ID character varying(50) DEFAULT NULL , + CIVIL_CODE character varying(50) DEFAULT NULL , + BUSINESS_GROUP_ID character varying(50) DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_CATALOG_PKEY PRIMARY KEY (ID, PLATFORM_ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_PLATFORM_GB_CHANNEL +( + ID bigint DEFAULT NEXTVAL('wvp_platform_gb_channel_id_seq'::text) NOT NULL, + PLATFORM_ID character varying(50) DEFAULT NULL , + CATALOG_ID character varying(50) DEFAULT NULL , + DEVICE_CHANNEL_ID integer DEFAULT NULL , + CONSTRAINT WVP_PLATFORM_GB_CHANNEL_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_RESOURCES_TREE +( + ID bigint DEFAULT NEXTVAL('seq_wvp_resources_tree_id'::text) NOT NULL, + IS_CATALOG boolean , + DEVICE_CHANNEL_ID integer , + GB_STREAM_ID integer , + "NAME" character varying(255) , + PARENTID integer , + "PATH" character varying(255) , + CONSTRAINT WVP_RESOURCES_TREE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_STREAM_PROXY +( + ID bigint DEFAULT NEXTVAL('wvp_stream_proxy_id_seq'::text) NOT NULL, + "TYPE" character varying(50) DEFAULT NULL , + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + URL character varying(255) DEFAULT NULL , + SRC_URL character varying(255) DEFAULT NULL , + DST_URL character varying(255) DEFAULT NULL , + TIMEOUT_MS integer DEFAULT NULL , + FFMPEG_CMD_KEY character varying(255) DEFAULT NULL , + RTP_TYPE character varying(50) DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + ENABLE_AUDIO tinyint DEFAULT 0 , + ENABLE_MP4 tinyint DEFAULT 0 , + "ENABLE" tinyint DEFAULT 0 , + STATUS tinyint DEFAULT NULL , + ENABLE_REMOVE_NONE_READER tinyint DEFAULT 0 , + CREATE_TIME character varying(50) DEFAULT NULL , + "NAME" character varying(255) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + STREAM_KEY character varying(255) DEFAULT NULL , + ENABLE_DISABLE_NONE_READER tinyint DEFAULT 0 , + CONSTRAINT WVP_STREAM_PROXY_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_STREAM_PUSH +( + ID bigint DEFAULT NEXTVAL('wvp_stream_push_id_seq'::text) NOT NULL, + "APP" character varying(255) DEFAULT NULL , + STREAM character varying(255) DEFAULT NULL , + TOTAL_READER_COUNT character varying(50) DEFAULT NULL , + ORIGIN_TYPE integer DEFAULT NULL , + ORIGIN_TYPE_STR character varying(50) DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + ALIVE_SECOND integer DEFAULT NULL , + MEDIA_SERVER_ID character varying(50) DEFAULT NULL , + SERVER_ID character varying(50) DEFAULT NULL , + PUSH_TIME character varying(50) DEFAULT NULL , + STATUS tinyint DEFAULT 0 , + UPDATE_TIME character varying(50) DEFAULT NULL , + PUSH_ING tinyint DEFAULT 0 , + SELF tinyint DEFAULT 0 , + CONSTRAINT WVP_STREAM_PUSH_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER +( + ID bigint DEFAULT NEXTVAL('wvp_user_id_seq'::text) NOT NULL, + USERNAME character varying(255) DEFAULT NULL , + "PASSWORD" character varying(255) DEFAULT NULL , + ROLE_ID integer DEFAULT NULL , + CREATE_TIME character varying(50) DEFAULT NULL , + UPDATE_TIME character varying(50) DEFAULT NULL , + PUSH_KEY character varying(50) DEFAULT NULL , + CONSTRAINT WVP_USER_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER_API_KEY +( + ID bigint DEFAULT NEXTVAL('seq_wvp_user_api_key_id'::text) NOT NULL, + USER_ID bigint , + "APP" character varying(255) , + API_KEY text , + EXPIRED_AT bigint , + REMARK character varying(255) , + "ENABLE" boolean , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + CONSTRAINT WVP_USER_API_KEY_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +CREATE TABLE WVP_USER.WVP_USER_ROLE +( + ID bigint DEFAULT NEXTVAL('seq_wvp_user_role_id'::text) NOT NULL, + "NAME" character varying(50) , + AUTHORITY character varying(50) , + CREATE_TIME character varying(50) , + UPDATE_TIME character varying(50) , + CONSTRAINT WVP_USER_ROLE_PKEY PRIMARY KEY (ID) +) + BINLOG ON ; + +-- +--Sequence DDL +-- +CREATE SEQUENCE WVP_USER.SEQ_GB_STREAM_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_LOG_ID INCREMENT 1 MINVALUE 1 START 6234 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_RESOURCES_TREE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_API_KEY_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_ROLE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_CLOUD_RECORD_INDEX INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_ALARM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_DEVICE_MOBILE_POSITION_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_PLATFORM_GB_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_PLATFORM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_STREAM_PROXY_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_STREAM_PUSH_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON +CREATE SEQUENCE WVP_USER.WVP_USER_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON; +INSERT INTO wvp_user VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '2021-04-13 14:14:57', '2021-04-13 14:14:57', '3e80d1762a324d5b0ff636e0bd16f1e3'); +INSERT INTO wvp_user_role VALUES (1, 'admin', '0', '2021-04-13 14:14:57', '2021-04-13 14:14:57'); \ No newline at end of file diff --git "a/\346\225\260\346\215\256\345\272\223/sys-video.sql" "b/\346\225\260\346\215\256\345\272\223/sys-video.sql" new file mode 100644 index 0000000..3afdf51 --- /dev/null +++ "b/\346\225\260\346\215\256\345\272\223/sys-video.sql" @@ -0,0 +1,622 @@ +/* + 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;