Galosys.Foundation.Yarp.Database 25.10.30.5

Gateway

CREATE SCHEMA docking_center;
-- [foundation-admin].docking_center.docking_log definition

-- Drop table

-- DROP TABLE [foundation-admin].docking_center.docking_log;

CREATE TABLE [foundation-admin].docking_center.docking_log (
	id bigint NOT NULL,
	request_path varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NOT NULL,
	request_url varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NOT NULL,
	request_method varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	request_query_params varchar(200) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	request_headers varchar(1000) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	request_body varchar(500) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	response_body varchar(2000) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	router_template_id bigint NULL,
	execute_result bit DEFAULT 0 NOT NULL,
	occurred_on datetime2 NULL,
	CONSTRAINT PK_docking_center_docking_log PRIMARY KEY (id)
);


-- [foundation-admin].docking_center.router_template definition

-- Drop table

-- DROP TABLE [foundation-admin].docking_center.router_template;

CREATE TABLE [foundation-admin].docking_center.router_template (
	id bigint NOT NULL,
	template_code varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NOT NULL,
	request_path varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NOT NULL,
	router_uri varchar(512) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	path_prefix varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	path_remove_prefix varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	request_headers_copy bit DEFAULT 1 NOT NULL,
	deleted bit DEFAULT 0 NOT NULL,
	creator_id bigint DEFAULT 1 NULL,
	creator_name varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 DEFAULT '1' NOT NULL,
	created_at datetime2 NOT NULL,
	last_modifier_id bigint NULL,
	last_modifier_name varchar(64) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	last_modified_at datetime2 NULL,
	remark varchar(128) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	max_retries int DEFAULT 5 NOT NULL,
	[source] varchar(255) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	target varchar(255) COLLATE Chinese_PRC_90_CI_AI_SC_UTF8 NULL,
	CONSTRAINT PK_docking_center_router_template PRIMARY KEY (id)
);
 CREATE  UNIQUE NONCLUSTERED INDEX UIDX_router_template_code ON cc.router_template (  template_code ASC  )  
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ] ;