CREATE TABLE public.hv_em_service (
	id bigserial NOT NULL,
	create_time timestamptz NULL,
	update_time timestamptz NULL,
	service_name text NULL,
	service_ip text NULL,
	port text NULL,
	description text NULL,
	"version" text NULL,
	service_type varchar(40) NULL,
	CONSTRAINT hv_em_service_pkey PRIMARY KEY (id)
)
WITH (
	orientation=row,
	compression=no
);
CREATE TABLE public.hv_em_server (
	id bigserial NOT NULL,
	create_time timestamptz NULL,
	update_time timestamptz NULL,
	server_name text NULL,
	server_ip text NULL,
	description text NULL,
	CONSTRAINT hv_em_server_pkey PRIMARY KEY (id)
)
WITH (
	orientation=row,
	compression=no
);

INSERT INTO public.hv_em_server (create_time,update_time,server_name,server_ip,description) VALUES
	 (NULL,NULL,'边缘节点服务器','10.60.16.29',NULL);
INSERT INTO public.hv_em_service (create_time,update_time,service_name,service_ip,port,description,"version",service_type) VALUES
	 (NULL,NULL,'edge-management','10.60.16.29','9700','边缘管理服务','2.5.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'nacos','10.60.16.29','8848','注册中心','v2.1.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'auth','10.60.16.29','9010','人员权限服务','1.31.2','BUSINESS_SERVICE'),
	 (NULL,NULL,'gateway-license','10.60.16.29','9000','网关服务','2.13.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'data-query-service','10.60.16.29','9812','数据查询服务','2.0.2','BUSINESS_SERVICE'),
	 (NULL,NULL,'data-storage-service','10.60.16.29','9814','数据存储服务','2.0.3','BUSINESS_SERVICE'),
	 (NULL,NULL,'data-process','10.60.16.29','9819','数据引擎服务','2.0.2','BUSINESS_SERVICE'),
	 (NULL,NULL,'hiper-matrix-web','10.60.16.29','9030','web服务','2.1.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'system-service','10.60.16.29','9850','系统服务','2.1.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'iot-alarm','10.60.16.29','9860','报警服务','2.0.1','BUSINESS_SERVICE');
     
INSERT INTO public.hv_em_service (create_time,update_time,service_name,service_ip,port,description,"version",service_type) VALUES
	 (NULL,NULL,'edge-connection','10.60.16.29','9800','边缘采集服务','2.5.1','BUSINESS_SERVICE'),
	 (NULL,NULL,'influxdb','10.60.16.29','8086','时序数据库服务',NULL,'MIDDLEWARE_SERVER'),
	 (NULL,NULL,'rabbitmq','10.60.16.29','5672','消息队列服务',NULL,'MIDDLEWARE_SERVER'),
	 (NULL,NULL,'redis','10.60.16.29','6379','缓存服务',NULL,'MIDDLEWARE_SERVER');
