Fork: 0
codedev / casic-production-safety
Transfer to URL with SHA Find file
Newer
Older
casic-production-safety / sql / WVP_USER_1720774471162.SQL
liwenhao on 15 Jul 2024 120 KB 1.风险点初版及神通适配sql提交
Raw Blame History 
---------------------  SEQUENCE DDL  ---------------------
CREATE SEQUENCE "WVP_USER"."SEQ_GB_STREAM_ID" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE SEQUENCE "WVP_USER"."SEQ_WVP_LOG_ID" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 6549 CACHE 1;
CREATE SEQUENCE "WVP_USER"."SEQ_WVP_RESOURCES_TREE_ID" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE SEQUENCE "WVP_USER"."SEQ_WVP_USER_API_KEY_ID" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE SEQUENCE "WVP_USER"."SEQ_WVP_USER_ROLE_ID" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE SEQUENCE "WVP_USER"."WVP_CLOUD_RECORD_INDEX" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_DEVICE_ALARM_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 281 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_DEVICE_CHANNEL_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_DEVICE_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_DEVICE_MOBILE_POSITION_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_PLATFORM_GB_CHANNEL_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_PLATFORM_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_STREAM_PROXY_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_STREAM_PUSH_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
CREATE SEQUENCE "WVP_USER"."WVP_USER_ID_SEQ" INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 1 CACHE 10;
---------------------TABLE DDL: WVP_CLOUD_RECORD---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_CLOUD_RECORD---------------------
---------------------INDEX DDL: UK_STREAM_PUSH_APP_STREAM_PATH---------------------
CREATE UNIQUE INDEX UK_STREAM_PUSH_APP_STREAM_PATH ON WVP_USER.WVP_CLOUD_RECORD USING BTREE("APP","STREAM","FILE_PATH");
---------------------TABLE DDL: WVP_DEVICE---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_DEVICE---------------------
INSERT INTO WVP_USER.WVP_DEVICE ( ID,DEVICE_ID,NAME,MANUFACTURER,MODEL,FIRMWARE,TRANSPORT,STREAM_MODE,ON_LINE,REGISTER_TIME,KEEPALIVE_TIME,IP,CREATE_TIME,UPDATE_TIME,PORT,EXPIRES,SUBSCRIBE_CYCLE_FOR_CATALOG,SUBSCRIBE_CYCLE_FOR_MOBILE_POSITION,MOBILE_POSITION_SUBMISSION_INTERVAL,SUBSCRIBE_CYCLE_FOR_ALARM,HOST_ADDRESS,CHARSET,SSRC_CHECK,GEO_COORD_SYS,MEDIA_SERVER_ID,CUSTOM_NAME,SDP_IP,LOCAL_IP,PASSWORD,AS_MESSAGE_CHANNEL,KEEPALIVE_INTERVAL_TIME,BROADCAST_PUSH_AFTER_ACK) VALUES ('12','34020000001110000002','DeepinMind','HIKVISION','iDS-6708NX/AI-V2','V4.41.105','UDP','TCP-ACTIVE','0','2024-06-24 09:05:09','2024-06-24 09:41:09','192.168.83.41','2024-05-23 19:04:53','2024-06-24 09:41:09','5060','86400','0','0','5','0','192.168.83.41:5060','GB2312','0','WGS84',null,'DeepinMind',null,'192.168.83.41',null,'0','0','0' ); 

INSERT INTO WVP_USER.WVP_DEVICE ( ID,DEVICE_ID,NAME,MANUFACTURER,MODEL,FIRMWARE,TRANSPORT,STREAM_MODE,ON_LINE,REGISTER_TIME,KEEPALIVE_TIME,IP,CREATE_TIME,UPDATE_TIME,PORT,EXPIRES,SUBSCRIBE_CYCLE_FOR_CATALOG,SUBSCRIBE_CYCLE_FOR_MOBILE_POSITION,MOBILE_POSITION_SUBMISSION_INTERVAL,SUBSCRIBE_CYCLE_FOR_ALARM,HOST_ADDRESS,CHARSET,SSRC_CHECK,GEO_COORD_SYS,MEDIA_SERVER_ID,CUSTOM_NAME,SDP_IP,LOCAL_IP,PASSWORD,AS_MESSAGE_CHANNEL,KEEPALIVE_INTERVAL_TIME,BROADCAST_PUSH_AFTER_ACK) VALUES ('13','41010500002000000003','DH-NVR402-I','Dahua','DH-NVR402-I','4.000.0000000.1,2019-08-09','UDP','TCP-ACTIVE','1','2024-07-09 18:10:08','2024-07-09 18:48:14','192.168.83.171','2024-06-04 17:18:55','2024-07-09 18:48:14','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' ); 

---------------------INDEX DDL: UK_DEVICE_DEVICE---------------------
CREATE UNIQUE INDEX UK_DEVICE_DEVICE ON WVP_USER.WVP_DEVICE USING BTREE("DEVICE_ID");
---------------------TABLE DDL: WVP_DEVICE_ALARM---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_DEVICE_ALARM---------------------
INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('1','34020000001110000002','34020000001320000003','4','5','2024-05-07 14:07:45',null,'0','0','2','2024-05-07 14:08:17' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('2','34020000001110000002','34020000001320000001','4','5','2024-05-07 14:08:27',null,'0','0','2','2024-05-07 14:08:36' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('3','34020000001110000002','34020000001320000001','4','5','2024-05-07 14:09:03',null,'0','0','2','2024-05-07 14:09:04' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('4','34020000001110000002','34020000001320000001','4','5','2024-05-07 14:09:27',null,'0','0','2','2024-05-07 14:09:28' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('5','34020000001110000002','34020000001320000001','4','5','2024-05-07 14:10:37',null,'0','0','2','2024-05-07 14:10:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('21','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:40:18',null,'0','0','2','2024-06-21 17:40:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('22','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:40:40',null,'0','0','2','2024-06-21 17:40:42' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('23','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:41:15',null,'0','0','2','2024-06-21 17:41:17' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('24','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:42:56',null,'0','0','2','2024-06-21 17:42:58' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('81','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:33',null,'0','0','2','2024-06-21 17:57:39' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('121','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:44:32',null,'0','0','2','2024-06-22 10:44:33' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('122','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:48:10',null,'0','0','2','2024-06-22 10:48:11' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('123','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:04:40',null,'0','0','2','2024-06-22 11:04:41' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('124','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:17:50',null,'0','0','2','2024-06-22 11:17:51' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('11','34020000001110000002','34020000001320000003','4','5','2024-06-21 15:56:53',null,'0','0','2','2024-06-21 15:56:54' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('12','34020000001110000002','34020000001320000003','4','5','2024-06-21 16:06:30',null,'0','0','2','2024-06-21 16:06:31' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('41','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:40:40',null,'0','0','2','2024-06-21 17:40:42' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('42','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:41:15',null,'0','0','2','2024-06-21 17:41:18' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('43','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:47:42',null,'0','0','2','2024-06-21 17:47:43' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('44','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:49:25',null,'0','0','2','2024-06-21 17:49:26' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('45','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:50:36',null,'0','0','2','2024-06-21 17:50:37' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('46','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:51:37',null,'0','0','2','2024-06-21 17:51:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('61','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:55:59',null,'0','0','2','2024-06-21 17:56:01' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('62','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:15',null,'0','0','2','2024-06-21 17:57:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('63','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:33',null,'0','0','2','2024-06-21 17:57:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('64','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:33',null,'0','0','2','2024-06-21 17:57:39' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('101','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:31:06',null,'0','0','2','2024-06-22 10:31:07' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('102','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:41:30',null,'0','0','2','2024-06-22 10:41:32' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('181','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:17:37',null,'0','0','2','2024-06-22 12:17:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('211','34020000001110000002','34020000001320000003','4','5','2024-06-22 14:41:58',null,'0','0','2','2024-06-22 14:41:59' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('212','34020000001110000002','34020000001320000003','4','5','2024-06-22 14:57:27',null,'0','0','2','2024-06-22 14:57:28' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('213','34020000001110000002','34020000001320000003','4','5','2024-06-22 15:00:41',null,'0','0','2','2024-06-22 15:00:42' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('261','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:11:17',null,'0','0','2','2024-06-24 09:11:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('51','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:48:30',null,'0','0','2','2024-06-21 17:48:31' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('71','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:15',null,'0','0','2','2024-06-21 17:57:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('72','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:15',null,'0','0','2','2024-06-21 17:57:20' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('73','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:57:33',null,'0','0','2','2024-06-21 17:57:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('111','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:36:01',null,'0','0','2','2024-06-22 10:36:02' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('112','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:40:16',null,'0','0','2','2024-06-22 10:40:18' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('113','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:02:20',null,'0','0','2','2024-06-22 11:02:21' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('114','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:20:06',null,'0','0','2','2024-06-22 11:20:07' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('6','34020000001110000002','34020000001320000003','4','5','2024-06-21 16:02:22',null,'0','0','2','2024-06-21 16:02:23' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('31','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:40:18',null,'0','0','2','2024-06-21 17:40:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('91','34020000001110000002','34020000001320000003','4','5','2024-06-21 17:58:35',null,'0','0','2','2024-06-21 17:58:37' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('131','34020000001110000002','34020000001320000003','4','5','2024-06-22 10:45:36',null,'0','0','2','2024-06-22 10:45:37' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('132','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:25:14',null,'0','0','2','2024-06-22 11:25:15' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('133','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:28:18',null,'0','0','2','2024-06-22 11:28:20' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('151','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:32:48',null,'0','0','2','2024-06-22 11:32:50' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('152','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:36:08',null,'0','0','2','2024-06-22 11:36:09' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('153','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:40:02',null,'0','0','2','2024-06-22 11:40:03' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('154','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:48:43',null,'0','0','2','2024-06-22 11:48:45' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('155','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:56:11',null,'0','0','2','2024-06-22 11:56:13' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('156','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:01:33',null,'0','0','2','2024-06-22 12:01:34' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('157','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:01:46',null,'0','0','2','2024-06-22 12:01:47' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('158','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:02:52',null,'0','0','2','2024-06-22 12:02:53' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('171','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:08:18',null,'0','0','2','2024-06-22 12:08:19' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('172','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:11:38',null,'0','0','2','2024-06-22 12:11:40' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('173','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:13:20',null,'0','0','2','2024-06-22 12:13:21' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('191','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:28:36',null,'0','0','2','2024-06-22 12:28:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('192','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:34:10',null,'0','0','2','2024-06-22 12:34:11' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('193','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:34:19',null,'0','0','2','2024-06-22 12:34:21' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('194','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:35:25',null,'0','0','2','2024-06-22 12:35:26' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('195','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:38:01',null,'0','0','2','2024-06-22 12:38:02' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('196','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:50:55',null,'0','0','2','2024-06-22 12:50:57' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('197','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:54:49',null,'0','0','2','2024-06-22 12:54:51' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('231','34020000001110000002','34020000001320000003','4','5','2024-06-22 15:10:41',null,'0','0','2','2024-06-22 15:10:51' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('251','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:06:40',null,'0','0','2','2024-06-24 09:06:41' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('252','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:20:30',null,'0','0','2','2024-06-24 09:20:31' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('253','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:30:05',null,'0','0','2','2024-06-24 09:30:06' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('254','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:37:11',null,'0','0','2','2024-06-24 09:37:12' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('255','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:41:08',null,'0','0','2','2024-06-24 09:41:09' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('161','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:38:02',null,'0','0','2','2024-06-22 11:38:03' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('162','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:38:15',null,'0','0','2','2024-06-22 11:38:16' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('163','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:43:41',null,'0','0','2','2024-06-22 11:43:43' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('164','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:47:38',null,'0','0','2','2024-06-22 11:47:40' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('165','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:51:03',null,'0','0','2','2024-06-22 11:51:04' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('166','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:51:39',null,'0','0','2','2024-06-22 11:51:40' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('167','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:56:26',null,'0','0','2','2024-06-22 11:56:28' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('168','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:56:53',null,'0','0','2','2024-06-22 11:56:54' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('169','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:59:03',null,'0','0','2','2024-06-22 11:59:05' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('221','34020000001110000002','34020000001320000003','4','5','2024-06-22 14:51:42',null,'0','0','2','2024-06-22 14:51:42' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('222','34020000001110000002','34020000001320000003','4','5','2024-06-22 14:59:59',null,'0','0','2','2024-06-22 15:00:00' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('223','34020000001110000002','34020000001320000003','4','5','2024-06-22 15:09:19',null,'0','0','2','2024-06-22 15:09:20' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('224','34020000001110000002','34020000001320000003','4','5','2024-06-22 15:09:53',null,'0','0','2','2024-06-22 15:09:54' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('201','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:32:51',null,'0','0','2','2024-06-22 12:32:52' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('202','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:33:05',null,'0','0','2','2024-06-22 12:33:06' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('203','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:33:14',null,'0','0','2','2024-06-22 12:33:15' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('204','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:33:35',null,'0','0','2','2024-06-22 12:33:36' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('205','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:36:45',null,'0','0','2','2024-06-22 12:36:46' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('206','34020000001110000002','34020000001320000003','4','5','2024-06-22 12:49:42',null,'0','0','2','2024-06-22 12:49:43' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('241','34020000001110000002','34020000001320000003','4','5','2024-06-22 15:11:20',null,'0','0','2','2024-06-22 15:11:22' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('271','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:20:46',null,'0','0','2','2024-06-24 09:20:47' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('272','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:21:27',null,'0','0','2','2024-06-24 09:21:28' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('273','34020000001110000002','34020000001320000003','4','5','2024-06-24 09:31:36',null,'0','0','2','2024-06-24 09:31:38' ); 

INSERT INTO WVP_USER.WVP_DEVICE_ALARM ( ID,DEVICE_ID,CHANNEL_ID,ALARM_PRIORITY,ALARM_METHOD,ALARM_TIME,ALARM_DESCRIPTION,LONGITUDE,LATITUDE,ALARM_TYPE,CREATE_TIME) VALUES ('141','34020000001110000002','34020000001320000003','4','5','2024-06-22 11:29:54',null,'0','0','2','2024-06-22 11:29:55' ); 

---------------------TABLE DDL: WVP_DEVICE_CHANNEL---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_DEVICE_CHANNEL---------------------
INSERT INTO WVP_USER.WVP_DEVICE_CHANNEL ( ID,CHANNEL_ID,NAME,CUSTOM_NAME,MANUFACTURE,MODEL,OWNER,CIVIL_CODE,BLOCK,ADDRESS,PARENT_ID,SAFETY_WAY,REGISTER_WAY,CERT_NUM,CERTIFIABLE,ERR_CODE,END_TIME,SECRECY,IP_ADDRESS,PORT,PASSWORD,PTZ_TYPE,CUSTOM_PTZ_TYPE,STATUS,LONGITUDE,CUSTOM_LONGITUDE,LATITUDE,CUSTOM_LATITUDE,STREAM_ID,DEVICE_ID,PARENTAL,HAS_AUDIO,CREATE_TIME,UPDATE_TIME,SUB_COUNT,LONGITUDE_GCJ02,LATITUDE_GCJ02,LONGITUDE_WGS84,LATITUDE_WGS84,BUSINESS_GROUP_ID,GPS_TIME,STREAM_IDENTIFICATION) 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-24 09:05:10','0','0','0','0','0',null,'2024-06-24 09:05:09',null ); 

INSERT INTO WVP_USER.WVP_DEVICE_CHANNEL ( ID,CHANNEL_ID,NAME,CUSTOM_NAME,MANUFACTURE,MODEL,OWNER,CIVIL_CODE,BLOCK,ADDRESS,PARENT_ID,SAFETY_WAY,REGISTER_WAY,CERT_NUM,CERTIFIABLE,ERR_CODE,END_TIME,SECRECY,IP_ADDRESS,PORT,PASSWORD,PTZ_TYPE,CUSTOM_PTZ_TYPE,STATUS,LONGITUDE,CUSTOM_LONGITUDE,LATITUDE,CUSTOM_LATITUDE,STREAM_ID,DEVICE_ID,PARENTAL,HAS_AUDIO,CREATE_TIME,UPDATE_TIME,SUB_COUNT,LONGITUDE_GCJ02,LATITUDE_GCJ02,LONGITUDE_WGS84,LATITUDE_WGS84,BUSINESS_GROUP_ID,GPS_TIME,STREAM_IDENTIFICATION) 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-24 09:05:10','0','0','0','0','0',null,'2024-06-24 09:05:09',null ); 

INSERT INTO WVP_USER.WVP_DEVICE_CHANNEL ( ID,CHANNEL_ID,NAME,CUSTOM_NAME,MANUFACTURE,MODEL,OWNER,CIVIL_CODE,BLOCK,ADDRESS,PARENT_ID,SAFETY_WAY,REGISTER_WAY,CERT_NUM,CERTIFIABLE,ERR_CODE,END_TIME,SECRECY,IP_ADDRESS,PORT,PASSWORD,PTZ_TYPE,CUSTOM_PTZ_TYPE,STATUS,LONGITUDE,CUSTOM_LONGITUDE,LATITUDE,CUSTOM_LATITUDE,STREAM_ID,DEVICE_ID,PARENTAL,HAS_AUDIO,CREATE_TIME,UPDATE_TIME,SUB_COUNT,LONGITUDE_GCJ02,LATITUDE_GCJ02,LONGITUDE_WGS84,LATITUDE_WGS84,BUSINESS_GROUP_ID,GPS_TIME,STREAM_IDENTIFICATION) 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-24 09:05:10','0','0','0','0','0',null,'2024-06-24 09:05:09',null ); 

INSERT INTO WVP_USER.WVP_DEVICE_CHANNEL ( ID,CHANNEL_ID,NAME,CUSTOM_NAME,MANUFACTURE,MODEL,OWNER,CIVIL_CODE,BLOCK,ADDRESS,PARENT_ID,SAFETY_WAY,REGISTER_WAY,CERT_NUM,CERTIFIABLE,ERR_CODE,END_TIME,SECRECY,IP_ADDRESS,PORT,PASSWORD,PTZ_TYPE,CUSTOM_PTZ_TYPE,STATUS,LONGITUDE,CUSTOM_LONGITUDE,LATITUDE,CUSTOM_LATITUDE,STREAM_ID,DEVICE_ID,PARENTAL,HAS_AUDIO,CREATE_TIME,UPDATE_TIME,SUB_COUNT,LONGITUDE_GCJ02,LATITUDE_GCJ02,LONGITUDE_WGS84,LATITUDE_WGS84,BUSINESS_GROUP_ID,GPS_TIME,STREAM_IDENTIFICATION) 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-07-09 16:16:39','0','0','0','0','0',null,'2024-07-09 16:16:39','stream:1' ); 

INSERT INTO WVP_USER.WVP_DEVICE_CHANNEL ( ID,CHANNEL_ID,NAME,CUSTOM_NAME,MANUFACTURE,MODEL,OWNER,CIVIL_CODE,BLOCK,ADDRESS,PARENT_ID,SAFETY_WAY,REGISTER_WAY,CERT_NUM,CERTIFIABLE,ERR_CODE,END_TIME,SECRECY,IP_ADDRESS,PORT,PASSWORD,PTZ_TYPE,CUSTOM_PTZ_TYPE,STATUS,LONGITUDE,CUSTOM_LONGITUDE,LATITUDE,CUSTOM_LATITUDE,STREAM_ID,DEVICE_ID,PARENTAL,HAS_AUDIO,CREATE_TIME,UPDATE_TIME,SUB_COUNT,LONGITUDE_GCJ02,LATITUDE_GCJ02,LONGITUDE_WGS84,LATITUDE_WGS84,BUSINESS_GROUP_ID,GPS_TIME,STREAM_IDENTIFICATION) 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-07-09 16:16:39','0','0','0','0','0',null,'2024-07-09 16:16:39',null ); 

---------------------INDEX DDL: UK_WVP_DEVICE_CHANNEL_UNIQUE_DEVICE_CHANNEL---------------------
CREATE UNIQUE INDEX UK_WVP_DEVICE_CHANNEL_UNIQUE_DEVICE_CHANNEL ON WVP_USER.WVP_DEVICE_CHANNEL USING BTREE("DEVICE_ID","CHANNEL_ID");
---------------------TABLE DDL: WVP_DEVICE_MOBILE_POSITION---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_DEVICE_MOBILE_POSITION---------------------
---------------------TABLE DDL: WVP_GB_STREAM---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_GB_STREAM---------------------
---------------------TABLE DDL: WVP_LOG---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_LOG---------------------
INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6291',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','169',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6292',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','229',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6294',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','9',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6296',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','70',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6298',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','2',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6299',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','75',null,'2024-06-22 10:31:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6305','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','86',null,'2024-06-22 10:31:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6306','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','155',null,'2024-06-22 10:31:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6321','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','8758',null,'2024-06-22 10:37:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6324','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','8817',null,'2024-06-22 10:37:59' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6333','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','67',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6334','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','126',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6338','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','144',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6340','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','173',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6343','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','445',null,'2024-06-22 10:41:42' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6381',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','4',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6385',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','110',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6387',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','2',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6390',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','99',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6391',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','151',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6397',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','12',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6399',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','95',null,'2024-06-24 09:13:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6403',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','213',null,'2024-06-24 09:39:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6404',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','307',null,'2024-06-24 09:39:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6405',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','3',null,'2024-06-24 09:39:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6407',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','100',null,'2024-06-24 09:39:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6409',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','1',null,'2024-06-24 09:39:23' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6410',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','90',null,'2024-06-24 09:39:23' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6412',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','1',null,'2024-06-24 09:39:24' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6265','[设备查询] 同步设备通道','GET','/api/device/query/devices/34020000001110000002/sync','127.0.0.1','200 OK','100',null,'2024-06-21 15:53:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6266','[设备查询] 同步设备通道','GET','/api/device/query/devices/34020000001110000002/sync','127.0.0.1','200 OK','196',null,'2024-06-21 15:53:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6267',null,'GET','/api/device/query/34020000001110000002/sync_status/','127.0.0.1','200 OK','2',null,'2024-06-21 15:53:08' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6268',null,'GET','/api/device/query/34020000001110000002/sync_status/','127.0.0.1','200 OK','88',null,'2024-06-21 15:53:08' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6269',null,'GET','/api/device/query/34020000001110000002/sync_status/','127.0.0.1','200 OK','2',null,'2024-06-21 15:53:08' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6270',null,'GET','/api/device/query/34020000001110000002/sync_status/','127.0.0.1','200 OK','102',null,'2024-06-21 15:53:09' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6271',null,'GET','/api/device/query/tree/34020000001110000002','127.0.0.1','200 OK','228',null,'2024-06-21 15:54:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6272',null,'GET','/api/device/query/tree/34020000001110000002','127.0.0.1','200 OK','318',null,'2024-06-21 15:54:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6273','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','214',null,'2024-06-21 15:54:20' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6274','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','311',null,'2024-06-21 15:54:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6277',null,'GET','/api/push/list','127.0.0.1','200 OK','181',null,'2024-06-21 15:54:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6278',null,'GET','/api/push/list','127.0.0.1','200 OK','252',null,'2024-06-21 15:54:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6279',null,'GET','/api/cloud/record/list','127.0.0.1','200 OK','94',null,'2024-06-21 15:54:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6280',null,'GET','/api/cloud/record/list','127.0.0.1','200 OK','183',null,'2024-06-21 15:54:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6281',null,'GET','/api/platform/query/15/1','127.0.0.1','500 INTERNAL_SERVER_ERROR','72',null,'2024-06-21 15:55:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6282',null,'GET','/api/platform/query/15/1','127.0.0.1','500 INTERNAL_SERVER_ERROR','149',null,'2024-06-21 15:55:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6383',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','4',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6386',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','111',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6389',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','3',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6392',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','158',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6393',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','227',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6394',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','307',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6395',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','6',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6396',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','83',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6398',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','3',null,'2024-06-24 09:13:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6400',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','97',null,'2024-06-24 09:13:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6401',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','1',null,'2024-06-24 09:13:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6402',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','105',null,'2024-06-24 09:13:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6293',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','8',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6295',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','65',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6297',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','3',null,'2024-06-22 10:31:44' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6300',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','75',null,'2024-06-22 10:31:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6465',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','20',null,'2024-07-09 16:24:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6466',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','25',null,'2024-07-09 16:24:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6470',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6471',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','8',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6473',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','6',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6474',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6476',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','6',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6477','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','28',null,'2024-07-09 16:25:28' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6478','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','34',null,'2024-07-09 16:25:28' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6484',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6486',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','5',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6488',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6489',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','6',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6502',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6504',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','5',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6509',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','2',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6510',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6512',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','2',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6513',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6517',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','19',null,'2024-07-09 16:43:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6518',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','26',null,'2024-07-09 16:43:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6519',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','16',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6520',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','22',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6521',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','1',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6524',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','7',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6525',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','1',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6526',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6527',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6528',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6532',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','17',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6533',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','23',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6535',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','8',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6536',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','8',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6541',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','25',null,'2024-07-09 17:08:02' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6542',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','30',null,'2024-07-09 17:08:02' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6547','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','20',null,'2024-07-09 17:35:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6548','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','26',null,'2024-07-09 17:35:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6285',null,'GET','/api/user/users','127.0.0.1','200 OK','153',null,'2024-06-21 15:55:01' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6286',null,'GET','/api/user/users','127.0.0.1','200 OK','238',null,'2024-06-21 15:55:01' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6287',null,'GET','/api/user/users','127.0.0.1','200 OK','132',null,'2024-06-21 15:55:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6288',null,'GET','/api/user/users','127.0.0.1','200 OK','221',null,'2024-06-21 15:55:11' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6289',null,'GET','/api/user/users','127.0.0.1','200 OK','160',null,'2024-06-21 15:55:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6290',null,'GET','/api/user/users','127.0.0.1','200 OK','257',null,'2024-06-21 15:55:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6317','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','73',null,'2024-06-22 10:36:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6318','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','141',null,'2024-06-22 10:36:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6322','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','91',null,'2024-06-22 10:37:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6323','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','154',null,'2024-06-22 10:37:59' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6335','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','69',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6336','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','126',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6337','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','283',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6341','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','417',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6345','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','273',null,'2024-06-22 10:41:42' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6346','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','408',null,'2024-06-22 10:41:42' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6353',null,'GET','/api/device/query/tree/41010500002000000003','127.0.0.1','200 OK','135',null,'2024-06-22 10:42:15' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6354',null,'GET','/api/device/query/tree/41010500002000000003','127.0.0.1','200 OK','205',null,'2024-06-22 10:42:15' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6357','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','134',null,'2024-06-22 11:02:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6358','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','196',null,'2024-06-22 11:02:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6362',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','13',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6363',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','75',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6367',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','2',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6368',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','60',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6372',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','11',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6373',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','103',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6376',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','3',null,'2024-06-24 09:07:06' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6377',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','89',null,'2024-06-24 09:07:06' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6379',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','178',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6380',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','288',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6414',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','125',null,'2024-06-24 09:39:24' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6415','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','423',null,'2024-06-24 09:39:24' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6416','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','536',null,'2024-06-24 09:39:25' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6417',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','250',null,'2024-06-24 09:39:30' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6418',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','348',null,'2024-06-24 09:39:30' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6419','停止点播','GET','/api/play/stop/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','412',null,'2024-06-24 09:41:47' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6420','停止点播','GET','/api/play/stop/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','659',null,'2024-06-24 09:41:47' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6421',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','215',null,'2024-06-24 09:41:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6422',null,'GET','/api/device/query/devices/34020000001110000002/channels','127.0.0.1','200 OK','439',null,'2024-06-24 09:41:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6423','登录','GET','/api/user/login','192.168.83.200','200 OK','731','admin','2024-07-09 16:16:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6424','登录','GET','/api/user/login','192.168.83.200','200 OK','744','admin','2024-07-09 16:16:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6425',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','57',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6426',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','64',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6427',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','15',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6429',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','18',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6432',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','8',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6433',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','12',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6435','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','107',null,'2024-07-09 16:16:46' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6436','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','114',null,'2024-07-09 16:16:46' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6446',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6447',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','7',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6449',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6452',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','6',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6453',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','52',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6454',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','67',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6455',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','14',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6458',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','18',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6459',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6462',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','9',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6463','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','125',null,'2024-07-09 16:24:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6464','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','131',null,'2024-07-09 16:24:21' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6428',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','15',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6430',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','18',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6431',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','8',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6434',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','13',null,'2024-07-09 16:16:45' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6437',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','29',null,'2024-07-09 16:16:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6438',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','37',null,'2024-07-09 16:16:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6439','停止点播','GET','/api/play/stop/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','103',null,'2024-07-09 16:16:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6440','停止点播','GET','/api/play/stop/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','108',null,'2024-07-09 16:16:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6441',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','35',null,'2024-07-09 16:16:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6442',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','40',null,'2024-07-09 16:16:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6443',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','22',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6444',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','29',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6445',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','3',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6448',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','5',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6450',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6451',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','6',null,'2024-07-09 16:17:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6456',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','14',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6457',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','18',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6460',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6461',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','9',null,'2024-07-09 16:24:19' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6467',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','20',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6468',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','27',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6469',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6472',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','8',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6475',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','10',null,'2024-07-09 16:25:26' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6479',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','17',null,'2024-07-09 16:25:29' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6480',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','22',null,'2024-07-09 16:25:29' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6481',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','16',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6482',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','21',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6483',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6485',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','5',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6487',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6490',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','6',null,'2024-07-09 16:25:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6491','停止点播','GET','/api/play/stop/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','55',null,'2024-07-09 16:25:40' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6492','停止点播','GET','/api/play/stop/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','57',null,'2024-07-09 16:25:40' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6493',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','18',null,'2024-07-09 16:25:40' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6494',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','20',null,'2024-07-09 16:25:40' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6495',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','15',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6496',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','20',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6497',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6498',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6499',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','3',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6500',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','4',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6501',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','2',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6503',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','5',null,'2024-07-09 16:25:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6505',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','25',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6506',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','32',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6507',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6508',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6511',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6514',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','4',null,'2024-07-09 16:43:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6515','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','23',null,'2024-07-09 16:43:09' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6516','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','30',null,'2024-07-09 16:43:09' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6522',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','2',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6523',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','6',null,'2024-07-09 16:57:39' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6529',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','59',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6530',null,'GET','/api/device/query/devices/41010500002000000003/channels','192.168.83.200','200 OK','74',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6531',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','16',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6301','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','214',null,'2024-06-22 10:31:46' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6302','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','289',null,'2024-06-22 10:31:46' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6303',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','157',null,'2024-06-22 10:31:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6304',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','228',null,'2024-06-22 10:31:48' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6307','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','80',null,'2024-06-22 10:31:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6308','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','148',null,'2024-06-22 10:31:54' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6309','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','66',null,'2024-06-22 10:36:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6310','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','141',null,'2024-06-22 10:36:10' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6311','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','90',null,'2024-06-22 10:36:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6312','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','167',null,'2024-06-22 10:36:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6313','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','72',null,'2024-06-22 10:36:25' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6314','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','139',null,'2024-06-22 10:36:25' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6315','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','68',null,'2024-06-22 10:36:36' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6316','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','126',null,'2024-06-22 10:36:36' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6319','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','11609',null,'2024-06-22 10:37:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6320','通用前端控制命令','POST','/api/ptz/front_end_command/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','11670',null,'2024-06-22 10:37:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6325','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','217',null,'2024-06-22 10:40:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6326','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','298',null,'2024-06-22 10:40:52' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6327',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','194',null,'2024-06-22 10:40:53' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6328',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','255',null,'2024-06-22 10:40:53' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6329','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','71',null,'2024-06-22 10:41:34' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6330','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','133',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6331','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','66',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6332','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','125',null,'2024-06-22 10:41:35' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6339','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','155',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6342','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','556',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6344','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','358',null,'2024-06-22 10:41:41' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6347','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','167',null,'2024-06-22 10:41:42' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6348','云台控制','POST','/api/ptz/control/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','302',null,'2024-06-22 10:41:42' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6349',null,'GET','/api/device/query/tree/34020000001110000002','127.0.0.1','200 OK','191',null,'2024-06-22 10:42:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6350',null,'GET','/api/device/query/tree/34020000001110000002','127.0.0.1','200 OK','252',null,'2024-06-22 10:42:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6351','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','166',null,'2024-06-22 10:42:06' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6352','开始点播','GET','/api/play/start/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','247',null,'2024-06-22 10:42:07' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6355','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','193',null,'2024-06-22 10:42:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6356','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','127.0.0.1','200 OK','299',null,'2024-06-22 10:42:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6359',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','207',null,'2024-06-22 11:20:15' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6360',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','276',null,'2024-06-22 11:20:15' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6361',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','13',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6364',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','81',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6365',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','1',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6366',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','63',null,'2024-06-22 11:20:16' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6369',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','211',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6370',null,'GET','/api/device/query/devices/41010500002000000003/channels','127.0.0.1','200 OK','291',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6371',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','11',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6374',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','96',null,'2024-06-24 09:07:05' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6375',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','2',null,'2024-06-24 09:07:06' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6378',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','127.0.0.1','200 OK','86',null,'2024-06-24 09:07:06' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6382',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000001','127.0.0.1','200 OK','2',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6384',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','110',null,'2024-06-24 09:12:17' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6388',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000003','127.0.0.1','200 OK','3',null,'2024-06-24 09:12:18' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6406',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','4',null,'2024-06-24 09:39:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6408',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','119',null,'2024-06-24 09:39:22' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6411',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','1',null,'2024-06-24 09:39:24' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6413',null,'GET','/api/device/query/snap/34020000001110000002/34020000001320000006','127.0.0.1','200 OK','91',null,'2024-06-24 09:39:24' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6275',null,'GET','/api/push/list','127.0.0.1','200 OK','83',null,'2024-06-21 15:54:50' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6276',null,'GET','/api/push/list','127.0.0.1','200 OK','180',null,'2024-06-21 15:54:50' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6283',null,'GET','/api/role/all','127.0.0.1','200 OK','110',null,'2024-06-21 15:55:01' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6284',null,'GET','/api/role/all','127.0.0.1','200 OK','202',null,'2024-06-21 15:55:01' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6534',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','22',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6537',null,'GET','/api/device/query/snap/41010500002000000003/34020000001310000033','192.168.83.200','200 OK','12',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6538',null,'GET','/api/device/query/snap/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','12',null,'2024-07-09 17:07:58' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6539','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','290',null,'2024-07-09 17:08:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6540','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','296',null,'2024-07-09 17:08:00' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6543',null,'GET','/api/device/query/tree/41010500002000000003','192.168.83.200','200 OK','71',null,'2024-07-09 17:30:32' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6544',null,'GET','/api/device/query/tree/41010500002000000003','192.168.83.200','200 OK','78',null,'2024-07-09 17:30:32' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6545','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','27',null,'2024-07-09 17:30:33' ); 

INSERT INTO WVP_USER.WVP_LOG ( ID,NAME,TYPE,URI,ADDRESS,RESULT,TIMING,USERNAME,CREATE_TIME) VALUES ('6546','开始点播','GET','/api/play/start/41010500002000000003/34020000001110000013','192.168.83.200','200 OK','47',null,'2024-07-09 17:30:33' ); 

---------------------TABLE DDL: WVP_MEDIA_SERVER---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_MEDIA_SERVER---------------------
INSERT INTO WVP_USER.WVP_MEDIA_SERVER ( ID,IP,HOOK_IP,SDP_IP,STREAM_IP,HTTP_PORT,HTTP_SSL_PORT,RTMP_PORT,RTMP_SSL_PORT,RTP_PROXY_PORT,RTSP_PORT,RTSP_SSL_PORT,FLV_PORT,FLV_SSL_PORT,WS_FLV_PORT,WS_FLV_SSL_PORT,AUTO_CONFIG,SECRET,TYPE,RTP_ENABLE,RTP_PORT_RANGE,SEND_RTP_PORT_RANGE,RECORD_ASSIST_PORT,DEFAULT_SERVER,CREATE_TIME,UPDATE_TIME,HOOK_ALIVE_INTERVAL,RECORD_PATH,RECORD_DAY) VALUES ('your_server_id','192.168.83.200','192.168.83.200','192.168.83.200','192.168.83.200','8080','8443','1935','0','10000','8554','0','8080','0','8080','0','1','vcOhVPzPUgfcvDLLWTFjgBgVNrCkvi7P','zlm','1','30010,30050','30000,30009','0','1','2024-05-14 09:01:57','2024-07-09 17:07:44','10',null,'7' ); 

---------------------INDEX DDL: UK_MEDIA_SERVER_UNIQUE_IP_HTTP_PORT---------------------
CREATE UNIQUE INDEX UK_MEDIA_SERVER_UNIQUE_IP_HTTP_PORT ON WVP_USER.WVP_MEDIA_SERVER USING BTREE("IP","HTTP_PORT");
---------------------TABLE DDL: WVP_PLATFORM---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_PLATFORM---------------------
---------------------TABLE DDL: WVP_PLATFORM_CATALOG---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_PLATFORM_CATALOG---------------------
---------------------TABLE DDL: WVP_PLATFORM_GB_CHANNEL---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_PLATFORM_GB_CHANNEL---------------------
---------------------TABLE DDL: WVP_RESOURCES_TREE---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_RESOURCES_TREE---------------------
---------------------TABLE DDL: WVP_STREAM_PROXY---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_STREAM_PROXY---------------------
---------------------TABLE DDL: WVP_STREAM_PUSH---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_STREAM_PUSH---------------------
---------------------TABLE DDL: WVP_USER---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_USER---------------------
INSERT INTO WVP_USER.WVP_USER ( ID,USERNAME,PASSWORD,ROLE_ID,CREATE_TIME,UPDATE_TIME,PUSH_KEY) VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3','1','2021-04-13 14:14:57','2021-04-13 14:14:57','3e80d1762a324d5b0ff636e0bd16f1e3' ); 

---------------------TABLE DDL: WVP_USER_API_KEY---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_USER_API_KEY---------------------
---------------------TABLE DDL: WVP_USER_ROLE---------------------
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 ;
---------------------TABLE INSERT SQL: WVP_USER_ROLE---------------------
INSERT INTO WVP_USER.WVP_USER_ROLE ( ID,NAME,AUTHORITY,CREATE_TIME,UPDATE_TIME) VALUES ('1','admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57' );