nacos适配postgresql数据库

/* Navicat Premium Data Transfer Source Server : vastdata Source Server Type : PostgreSQL Source Server Version : 90204 Source Host : 192.168.4.52:5432 Source Catalog : jxbp Source Schema : jxbp_nacos Target Server Type : PostgreSQL Target Server Version : 90204 File Encoding : 65001 Date: 18/02/2022 10:36:30 */ -- ---------------------------- -- Sequence structure for config_info_aggr_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "config_info_aggr_id_seq"; CREATE SEQUENCE "config_info_aggr_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for config_info_beta_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "config_info_beta_id_seq"; CREATE SEQUENCE "config_info_beta_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for config_info_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "config_info_id_seq"; CREATE SEQUENCE "config_info_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for config_info_tag_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "config_info_tag_id_seq"; CREATE SEQUENCE "config_info_tag_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for config_tags_relation_nid_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "config_tags_relation_nid_seq"; CREATE SEQUENCE "config_tags_relation_nid_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for group_capacity_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "group_capacity_id_seq"; CREATE SEQUENCE "group_capacity_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for his_config_info_nid_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "his_config_info_nid_seq"; CREATE SEQUENCE "his_config_info_nid_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for tenant_capacity_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "tenant_capacity_id_seq"; CREATE SEQUENCE "tenant_capacity_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Sequence structure for tenant_info_id_seq -- ---------------------------- DROP SEQUENCE IF EXISTS "tenant_info_id_seq"; CREATE SEQUENCE "tenant_info_id_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; -- ---------------------------- -- Table structure for config_info -- ---------------------------- DROP TABLE IF EXISTS "config_info"; CREATE TABLE "config_info" ( "id" int8 NOT NULL DEFAULT nextval('config_info_id_seq'::regclass), "data_id" varchar(765) COLLATE "pg_catalog"."default" NOT NULL, "group_id" varchar(765) COLLATE "pg_catalog"."default", "content" text COLLATE "pg_catalog"."default" NOT NULL, "md5" varchar(96) COLLATE "pg_catalog"."default", "gmt_create" timestamp(0) NOT NULL DEFAULT pg_systimestamp(), "gmt_modified" timestamp(0) NOT NULL DEFAULT pg_systimestamp(), "src_user" text COLLATE "pg_catalog"."default", "src_ip" varchar(150) COLLATE "pg_catalog"."default", "app_name" varchar(384) COLLATE "pg_catalog"."default", "tenant_id" varchar(384) COLLATE "pg_catalog"."default" DEFAULT NULL::varchar, "c_desc" varchar(768) COLLATE "pg_catalog"."default", "c_use" varchar(192) COLLATE "pg_catalog"."default", "effect" varchar(192) COLLATE "pg_catalog"."default", "type" varchar(192) COLLATE "pg_catalog"."default", "c_schema" text COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "config_info"."id" IS 'id'; COMMENT ON COLUMN "config_info"."data_id" IS 'data_id'; COMMENT ON COLUMN "config_info"."content" IS 'content'; COMMENT ON COLUMN "config_info"."md5" IS 'md5'; COMMENT ON COLUMN "config_info"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "config_info"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "config_info"."src_user" IS 'source user'; COMMENT ON COLUMN "config_info"."src_ip" IS 'source ip'; COMMENT ON COLUMN "config_info"."tenant_id" IS '租户字段'; COMMENT ON TABLE "config_info" IS 'config_info'; -- ---------------------------- -- Table structure for config_info_aggr -- ---------------------------- DROP TABLE IF EXISTS "config_info_aggr"; CREATE TABLE "config_info_aggr" ( "id" int8 NOT NULL DEFAULT nextval('config_info_aggr_id_seq'::regclass), "data_id" varchar(765) COLLATE "pg_catalog"."default" NOT NULL, "group_id" varchar(765) COLLATE "pg_catalog"."default" NOT NULL, "datum_id" varchar(765) COLLATE "pg_catalog"."default" NOT NULL, "content" text COLLATE "pg_catalog"."default" NOT NULL, "gmt_modified" timestamp(0) NOT NULL, "app_name" varchar(384) COLLATE "pg_catalog"."default", "tenant_id" varchar(384) COLLATE "pg_catalog"."default" DEFAULT NULL::varchar ) ; COMMENT ON COLUMN "config_info_aggr"."id" IS 'id'; COMMENT ON COLUMN "config_info_aggr"."data_id" IS 'data_id'; COMMENT ON COLUMN "config_info_aggr"."group_id" IS 'group_id'; COMMENT ON COLUMN "config_info_aggr"."datum_id" IS 'datum_id'; COMMENT ON COLUMN "config_info_aggr"."content" IS '内容'; COMMENT ON COLUMN "config_info_aggr"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "config_info_aggr"."tenant_id" IS '租户字段'; COMMENT ON TABLE "config_info_aggr" IS '增加租户字段'; -- ---------------------------- -- Table structure for config_info_beta -- ---------------------------- DROP TABLE IF EXISTS "config_info_beta"; CREATE TABLE "config_info_beta" ( "id" int8 NOT NULL DEFAULT nextval('config_info_beta_id_seq'::regclass), "data_id" varchar(765) COLLATE "pg_catalog"."default" NOT NULL, "group_id" varchar(384) COLLATE "pg_catalog"."default" NOT NULL, "app_name" varchar(384) COLLATE "pg_catalog"."default", "content" text COLLATE "pg_catalog"."default" NOT NULL, "beta_ips" varchar(3072) COLLATE "pg_catalog"."default", "md5" varchar(96) COLLATE "pg_catalog"."default", "gmt_create" timestamp(0) NOT NULL DEFAULT pg_systimestamp(), "gmt_modified" timestamp(0) NOT NULL DEFAULT pg_systimestamp(), "src_user" text COLLATE "pg_catalog"."default", "src_ip" varchar(150) COLLATE "pg_catalog"."default", "tenant_id" varchar(384) COLLATE "pg_catalog"."default" DEFAULT NULL::varchar ) ; COMMENT ON COLUMN "config_info_beta"."id" IS 'id'; COMMENT ON COLUMN "config_info_beta"."data_id" IS 'data_id'; COMMENT ON COLUMN "config_info_beta"."group_id" IS 'group_id'; COMMENT ON COLUMN "config_info_beta"."app_name" IS 'app_name'; COMMENT ON COLUMN "config_info_beta"."content" IS 'content'; COMMENT ON COLUMN "config_info_beta"."beta_ips" IS 'betaIps'; COMMENT ON COLUMN "config_info_beta"."md5" IS 'md5'; COMMENT ON COLUMN "config_info_beta"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "config_info_beta"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "config_info_beta"."src_user" IS 'source user'; COMMENT ON COLUMN "config_info_beta"."src_ip" IS 'source ip'; COMMENT ON COLUMN "config_info_beta"."tenant_id" IS '租户字段'; COMMENT ON TABLE "config_info_beta" IS 'config_info_beta'; -- ---------------------------- -- Table structure for config_info_tag -- ---------------------------- DROP TABLE IF EXISTS "config_info_tag"; CREATE TABLE "config_info_tag" ( "id" int8 NOT NULL DEFAULT nextval('config_info_tag_id_seq'::regclass), "data_id" varchar(765) COLLATE "pg_catalog"."default"