--
--Table DDL
--
CREATE TABLE WVP_USER.WVP_CLOUD_RECORD
(
ID bigint DEFAULT NEXTVAL('wvp_cloud_record_index'::text) NOT NULL,
"APP" character varying(255) DEFAULT NULL ,
STREAM character varying(255) DEFAULT NULL ,
CALL_ID character varying(255) DEFAULT NULL ,
START_TIME bigint DEFAULT NULL ,
END_TIME bigint DEFAULT NULL ,
MEDIA_SERVER_ID character varying(50) DEFAULT NULL ,
FILE_NAME character varying(255) DEFAULT NULL ,
FOLDER character varying(255) DEFAULT NULL ,
FILE_PATH character varying(255) DEFAULT NULL ,
COLLECT tinyint DEFAULT 0 ,
FILE_SIZE bigint DEFAULT NULL ,
TIME_LEN bigint DEFAULT NULL ,
CONSTRAINT WVP_CLOUD_RECORD_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
--Indexes DDL
CREATE UNIQUE INDEX UK_STREAM_PUSH_APP_STREAM_PATH ON WVP_USER.WVP_CLOUD_RECORD USING BTREE ("APP", STREAM, FILE_PATH) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE;
CREATE TABLE WVP_USER.WVP_DEVICE
(
ID bigint DEFAULT NEXTVAL('wvp_device_id_seq'::text) NOT NULL,
DEVICE_ID character varying(50) NOT NULL,
"NAME" character varying(255) DEFAULT NULL ,
MANUFACTURER character varying(255) DEFAULT NULL ,
MODEL character varying(255) DEFAULT NULL ,
FIRMWARE character varying(255) DEFAULT NULL ,
TRANSPORT character varying(50) DEFAULT NULL ,
STREAM_MODE character varying(50) DEFAULT NULL ,
ON_LINE tinyint DEFAULT 0 ,
REGISTER_TIME character varying(50) DEFAULT NULL ,
KEEPALIVE_TIME character varying(50) DEFAULT NULL ,
"IP" character varying(50) DEFAULT NULL ,
CREATE_TIME character varying(50) DEFAULT NULL ,
UPDATE_TIME character varying(50) DEFAULT NULL ,
"PORT" integer DEFAULT NULL ,
EXPIRES integer DEFAULT NULL ,
SUBSCRIBE_CYCLE_FOR_CATALOG integer DEFAULT 0 ,
SUBSCRIBE_CYCLE_FOR_MOBILE_POSITION integer DEFAULT 0 ,
MOBILE_POSITION_SUBMISSION_INTERVAL integer DEFAULT 5 ,
SUBSCRIBE_CYCLE_FOR_ALARM integer DEFAULT 0 ,
HOST_ADDRESS character varying(50) DEFAULT NULL ,
CHARSET character varying(50) DEFAULT NULL ,
SSRC_CHECK tinyint DEFAULT 0 ,
GEO_COORD_SYS character varying(50) DEFAULT NULL ,
MEDIA_SERVER_ID character varying(50) DEFAULT NULL ,
CUSTOM_NAME character varying(255) DEFAULT NULL ,
SDP_IP character varying(50) DEFAULT NULL ,
LOCAL_IP character varying(50) DEFAULT NULL ,
"PASSWORD" character varying(255) DEFAULT NULL ,
AS_MESSAGE_CHANNEL tinyint DEFAULT 0 ,
KEEPALIVE_INTERVAL_TIME integer DEFAULT NULL ,
BROADCAST_PUSH_AFTER_ACK tinyint DEFAULT 0 ,
CONSTRAINT WVP_DEVICE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
--Indexes DDL
CREATE UNIQUE INDEX UK_DEVICE_DEVICE ON WVP_USER.WVP_DEVICE USING BTREE (DEVICE_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE;
CREATE TABLE WVP_USER.WVP_DEVICE_ALARM
(
ID bigint DEFAULT NEXTVAL('wvp_device_alarm_id_seq'::text) NOT NULL,
DEVICE_ID character varying(50) NOT NULL,
CHANNEL_ID character varying(50) NOT NULL,
ALARM_PRIORITY character varying(50) DEFAULT NULL ,
ALARM_METHOD character varying(50) DEFAULT NULL ,
ALARM_TIME character varying(50) DEFAULT NULL ,
ALARM_DESCRIPTION character varying(255) DEFAULT NULL ,
LONGITUDE float(53) DEFAULT NULL ,
LATITUDE float(53) DEFAULT NULL ,
ALARM_TYPE character varying(50) DEFAULT NULL ,
CREATE_TIME character varying(50) NOT NULL,
CONSTRAINT WVP_DEVICE_ALARM_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_DEVICE_CHANNEL
(
ID bigint DEFAULT NEXTVAL('wvp_device_channel_id_seq'::text) NOT NULL,
CHANNEL_ID character varying(50) NOT NULL,
"NAME" character varying(255) DEFAULT NULL ,
CUSTOM_NAME character varying(255) DEFAULT NULL ,
MANUFACTURE character varying(50) DEFAULT NULL ,
MODEL character varying(50) DEFAULT NULL ,
"OWNER" character varying(50) DEFAULT NULL ,
CIVIL_CODE character varying(50) DEFAULT NULL ,
"BLOCK" character varying(50) DEFAULT NULL ,
ADDRESS character varying(50) DEFAULT NULL ,
PARENT_ID character varying(50) DEFAULT NULL ,
SAFETY_WAY integer DEFAULT NULL ,
REGISTER_WAY integer DEFAULT NULL ,
CERT_NUM character varying(50) DEFAULT NULL ,
CERTIFIABLE integer DEFAULT NULL ,
ERR_CODE integer DEFAULT NULL ,
END_TIME character varying(50) DEFAULT NULL ,
SECRECY character varying(50) DEFAULT NULL ,
IP_ADDRESS character varying(50) DEFAULT NULL ,
"PORT" integer DEFAULT NULL ,
"PASSWORD" character varying(255) DEFAULT NULL ,
PTZ_TYPE integer DEFAULT NULL ,
CUSTOM_PTZ_TYPE integer DEFAULT NULL ,
STATUS tinyint DEFAULT 0 ,
LONGITUDE float(53) DEFAULT NULL ,
CUSTOM_LONGITUDE float(53) DEFAULT NULL ,
LATITUDE float(53) DEFAULT NULL ,
CUSTOM_LATITUDE float(53) DEFAULT NULL ,
STREAM_ID character varying(255) DEFAULT NULL ,
DEVICE_ID character varying(50) NOT NULL,
PARENTAL character varying(50) DEFAULT NULL ,
HAS_AUDIO tinyint DEFAULT 0 ,
CREATE_TIME character varying(50) NOT NULL,
UPDATE_TIME character varying(50) NOT NULL,
SUB_COUNT integer DEFAULT NULL ,
LONGITUDE_GCJ02 float(53) DEFAULT NULL ,
LATITUDE_GCJ02 float(53) DEFAULT NULL ,
LONGITUDE_WGS84 float(53) DEFAULT NULL ,
LATITUDE_WGS84 float(53) DEFAULT NULL ,
BUSINESS_GROUP_ID character varying(50) DEFAULT NULL ,
GPS_TIME character varying(50) DEFAULT NULL ,
STREAM_IDENTIFICATION character varying(50) DEFAULT NULL ,
CONSTRAINT WVP_DEVICE_CHANNEL_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
--Indexes DDL
CREATE UNIQUE INDEX UK_WVP_DEVICE_CHANNEL_UNIQUE_DEVICE_CHANNEL ON WVP_USER.WVP_DEVICE_CHANNEL USING BTREE (DEVICE_ID, CHANNEL_ID) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE;
CREATE TABLE WVP_USER.WVP_DEVICE_MOBILE_POSITION
(
ID bigint DEFAULT NEXTVAL('wvp_device_mobile_position_id_seq'::text) NOT NULL,
DEVICE_ID character varying(50) NOT NULL,
CHANNEL_ID character varying(50) NOT NULL,
DEVICE_NAME character varying(255) DEFAULT NULL ,
"TIME" character varying(50) DEFAULT NULL ,
LONGITUDE float(53) DEFAULT NULL ,
LATITUDE float(53) DEFAULT NULL ,
ALTITUDE float(53) DEFAULT NULL ,
SPEED float(53) DEFAULT NULL ,
DIRECTION float(53) DEFAULT NULL ,
REPORT_SOURCE character varying(50) DEFAULT NULL ,
LONGITUDE_GCJ02 float(53) DEFAULT NULL ,
LATITUDE_GCJ02 float(53) DEFAULT NULL ,
LONGITUDE_WGS84 float(53) DEFAULT NULL ,
LATITUDE_WGS84 float(53) DEFAULT NULL ,
CREATE_TIME character varying(50) DEFAULT NULL ,
CONSTRAINT WVP_DEVICE_MOBILE_POSITION_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_GB_STREAM
(
GB_STREAM_ID bigint DEFAULT NEXTVAL('seq_gb_stream_id'::text) NOT NULL,
"APP" character varying(255) NOT NULL,
STREAM character varying(255) NOT NULL,
GB_ID character varying(50) NOT NULL,
"NAME" character varying(255) ,
LONGITUDE float(53) ,
LATITUDE float(53) ,
STREAM_TYPE character varying(50) ,
MEDIA_SERVER_ID character varying(50) ,
CREATE_TIME character varying(50) ,
CONSTRAINT WVP_GB_STREAM_PKEY PRIMARY KEY (GB_STREAM_ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_LOG
(
ID bigint DEFAULT NEXTVAL('seq_wvp_log_id'::text) NOT NULL,
"NAME" character varying(50) ,
"TYPE" character varying(50) ,
URI character varying(200) ,
ADDRESS character varying(50) ,
"RESULT" character varying(50) ,
TIMING bigint ,
USERNAME character varying(50) ,
CREATE_TIME character varying(50) ,
CONSTRAINT WVP_LOG_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_MEDIA_SERVER
(
ID character varying(255) NOT NULL,
"IP" character varying(50) ,
HOOK_IP character varying(50) ,
SDP_IP character varying(50) ,
STREAM_IP character varying(50) ,
HTTP_PORT integer ,
HTTP_SSL_PORT integer ,
RTMP_PORT integer ,
RTMP_SSL_PORT integer ,
RTP_PROXY_PORT integer ,
RTSP_PORT integer ,
RTSP_SSL_PORT integer ,
FLV_PORT integer ,
FLV_SSL_PORT integer ,
WS_FLV_PORT integer ,
WS_FLV_SSL_PORT integer ,
AUTO_CONFIG tinyint ,
SECRET character varying(50) ,
"TYPE" character varying(50) DEFAULT 'zlm' ,
RTP_ENABLE tinyint ,
RTP_PORT_RANGE character varying(50) ,
SEND_RTP_PORT_RANGE character varying(50) ,
RECORD_ASSIST_PORT integer ,
DEFAULT_SERVER tinyint ,
CREATE_TIME character varying(50) ,
UPDATE_TIME character varying(50) ,
HOOK_ALIVE_INTERVAL integer ,
RECORD_PATH character varying(255) ,
RECORD_DAY integer DEFAULT 7 ,
CONSTRAINT WVP_MEDIA_SERVER_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
--Indexes DDL
CREATE UNIQUE INDEX UK_MEDIA_SERVER_UNIQUE_IP_HTTP_PORT ON WVP_USER.WVP_MEDIA_SERVER USING BTREE ("IP", HTTP_PORT) PRIORITY 0 TABLESPACE "SYSTEM" LOGGING INIT 64K NEXT 64K PCTINCREASE 50 FILL 70 SPLIT 50 VISIBLE;
CREATE TABLE WVP_USER.WVP_PLATFORM
(
ID bigint DEFAULT NEXTVAL('wvp_platform_id_seq'::text) NOT NULL,
"ENABLE" tinyint DEFAULT 0 ,
"NAME" character varying(255) DEFAULT NULL ,
SERVER_GB_ID character varying(50) DEFAULT NULL ,
SERVER_GB_DOMAIN character varying(50) DEFAULT NULL ,
SERVER_IP character varying(50) DEFAULT NULL ,
SERVER_PORT integer DEFAULT NULL ,
DEVICE_GB_ID character varying(50) DEFAULT NULL ,
DEVICE_IP character varying(50) DEFAULT NULL ,
DEVICE_PORT character varying(50) DEFAULT NULL ,
USERNAME character varying(255) DEFAULT NULL ,
"PASSWORD" character varying(50) DEFAULT NULL ,
EXPIRES character varying(50) DEFAULT NULL ,
KEEP_TIMEOUT character varying(50) DEFAULT NULL ,
TRANSPORT character varying(50) DEFAULT NULL ,
CHARACTER_SET character varying(50) DEFAULT NULL ,
CATALOG_ID character varying(50) DEFAULT NULL ,
PTZ tinyint DEFAULT 0 ,
RTCP tinyint DEFAULT 0 ,
STATUS tinyint DEFAULT 0 ,
START_OFFLINE_PUSH tinyint DEFAULT 0 ,
ADMINISTRATIVE_DIVISION character varying(50) DEFAULT NULL ,
CATALOG_GROUP integer DEFAULT NULL ,
CREATE_TIME character varying(50) DEFAULT NULL ,
UPDATE_TIME character varying(50) DEFAULT NULL ,
AS_MESSAGE_CHANNEL tinyint DEFAULT 0 ,
AUTO_PUSH_CHANNEL tinyint DEFAULT 0 ,
SEND_STREAM_IP character varying(50) DEFAULT NULL ,
CONSTRAINT WVP_PLATFORM_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_PLATFORM_CATALOG
(
ID character varying(50) DEFAULT NULL NOT NULL,
PLATFORM_ID character varying(50) DEFAULT NULL NOT NULL,
"NAME" character varying(255) DEFAULT NULL ,
PARENT_ID character varying(50) DEFAULT NULL ,
CIVIL_CODE character varying(50) DEFAULT NULL ,
BUSINESS_GROUP_ID character varying(50) DEFAULT NULL ,
CONSTRAINT WVP_PLATFORM_CATALOG_PKEY PRIMARY KEY (ID, PLATFORM_ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_PLATFORM_GB_CHANNEL
(
ID bigint DEFAULT NEXTVAL('wvp_platform_gb_channel_id_seq'::text) NOT NULL,
PLATFORM_ID character varying(50) DEFAULT NULL ,
CATALOG_ID character varying(50) DEFAULT NULL ,
DEVICE_CHANNEL_ID integer DEFAULT NULL ,
CONSTRAINT WVP_PLATFORM_GB_CHANNEL_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_RESOURCES_TREE
(
ID bigint DEFAULT NEXTVAL('seq_wvp_resources_tree_id'::text) NOT NULL,
IS_CATALOG boolean ,
DEVICE_CHANNEL_ID integer ,
GB_STREAM_ID integer ,
"NAME" character varying(255) ,
PARENTID integer ,
"PATH" character varying(255) ,
CONSTRAINT WVP_RESOURCES_TREE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_STREAM_PROXY
(
ID bigint DEFAULT NEXTVAL('wvp_stream_proxy_id_seq'::text) NOT NULL,
"TYPE" character varying(50) DEFAULT NULL ,
"APP" character varying(255) DEFAULT NULL ,
STREAM character varying(255) DEFAULT NULL ,
URL character varying(255) DEFAULT NULL ,
SRC_URL character varying(255) DEFAULT NULL ,
DST_URL character varying(255) DEFAULT NULL ,
TIMEOUT_MS integer DEFAULT NULL ,
FFMPEG_CMD_KEY character varying(255) DEFAULT NULL ,
RTP_TYPE character varying(50) DEFAULT NULL ,
MEDIA_SERVER_ID character varying(50) DEFAULT NULL ,
ENABLE_AUDIO tinyint DEFAULT 0 ,
ENABLE_MP4 tinyint DEFAULT 0 ,
"ENABLE" tinyint DEFAULT 0 ,
STATUS tinyint DEFAULT NULL ,
ENABLE_REMOVE_NONE_READER tinyint DEFAULT 0 ,
CREATE_TIME character varying(50) DEFAULT NULL ,
"NAME" character varying(255) DEFAULT NULL ,
UPDATE_TIME character varying(50) DEFAULT NULL ,
STREAM_KEY character varying(255) DEFAULT NULL ,
ENABLE_DISABLE_NONE_READER tinyint DEFAULT 0 ,
CONSTRAINT WVP_STREAM_PROXY_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_STREAM_PUSH
(
ID bigint DEFAULT NEXTVAL('wvp_stream_push_id_seq'::text) NOT NULL,
"APP" character varying(255) DEFAULT NULL ,
STREAM character varying(255) DEFAULT NULL ,
TOTAL_READER_COUNT character varying(50) DEFAULT NULL ,
ORIGIN_TYPE integer DEFAULT NULL ,
ORIGIN_TYPE_STR character varying(50) DEFAULT NULL ,
CREATE_TIME character varying(50) DEFAULT NULL ,
ALIVE_SECOND integer DEFAULT NULL ,
MEDIA_SERVER_ID character varying(50) DEFAULT NULL ,
SERVER_ID character varying(50) DEFAULT NULL ,
PUSH_TIME character varying(50) DEFAULT NULL ,
STATUS tinyint DEFAULT 0 ,
UPDATE_TIME character varying(50) DEFAULT NULL ,
PUSH_ING tinyint DEFAULT 0 ,
SELF tinyint DEFAULT 0 ,
CONSTRAINT WVP_STREAM_PUSH_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_USER
(
ID bigint DEFAULT NEXTVAL('wvp_user_id_seq'::text) NOT NULL,
USERNAME character varying(255) DEFAULT NULL ,
"PASSWORD" character varying(255) DEFAULT NULL ,
ROLE_ID integer DEFAULT NULL ,
CREATE_TIME character varying(50) DEFAULT NULL ,
UPDATE_TIME character varying(50) DEFAULT NULL ,
PUSH_KEY character varying(50) DEFAULT NULL ,
CONSTRAINT WVP_USER_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_USER_API_KEY
(
ID bigint DEFAULT NEXTVAL('seq_wvp_user_api_key_id'::text) NOT NULL,
USER_ID bigint ,
"APP" character varying(255) ,
API_KEY text ,
EXPIRED_AT bigint ,
REMARK character varying(255) ,
"ENABLE" boolean ,
CREATE_TIME character varying(50) ,
UPDATE_TIME character varying(50) ,
CONSTRAINT WVP_USER_API_KEY_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
CREATE TABLE WVP_USER.WVP_USER_ROLE
(
ID bigint DEFAULT NEXTVAL('seq_wvp_user_role_id'::text) NOT NULL,
"NAME" character varying(50) ,
AUTHORITY character varying(50) ,
CREATE_TIME character varying(50) ,
UPDATE_TIME character varying(50) ,
CONSTRAINT WVP_USER_ROLE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
--
--Sequence DDL
--
CREATE SEQUENCE WVP_USER.SEQ_GB_STREAM_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.SEQ_WVP_LOG_ID INCREMENT 1 MINVALUE 1 START 6234 NO CACHE NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.SEQ_WVP_RESOURCES_TREE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_API_KEY_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.SEQ_WVP_USER_ROLE_ID INCREMENT 1 MINVALUE 1 START 2 NO CACHE NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_CLOUD_RECORD_INDEX INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_DEVICE_ALARM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_DEVICE_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_DEVICE_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_DEVICE_MOBILE_POSITION_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_PLATFORM_GB_CHANNEL_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_PLATFORM_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_STREAM_PROXY_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_STREAM_PUSH_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON
CREATE SEQUENCE WVP_USER.WVP_USER_ID_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 999999999999 START 2 CACHE 10 NO CYCLE BINLOG ON;
INSERT INTO wvp_user VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '2021-04-13 14:14:57', '2021-04-13 14:14:57', '3e80d1762a324d5b0ff636e0bd16f1e3');
INSERT INTO wvp_user_role VALUES (1, 'admin', '0', '2021-04-13 14:14:57', '2021-04-13 14:14:57');
