nacos2.2.1达梦数据库版

CREATE TABLE "NACOS"."config_info" ( "id" BIGINT IDENTITY(1, 1) NOT NULL, "data_id" VARCHAR(255) NOT NULL, "group_id" VARCHAR(255), "content" CLOB NOT NULL, "md5" VARCHAR(32), "gmt_create" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "gmt_modified" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "src_user" TEXT, "src_ip" VARCHAR(50), "app_name" VARCHAR(128), "tenant_id" VARCHAR(128) DEFAULT '', "c_desc" VARCHAR(256), "c_use" VARCHAR(64), "effect" VARCHAR(64), "type" VARCHAR(64), "c_schema" TEXT, "encrypted_data_key" TEXT NOT NULL, NOT CLUSTER PRIMARY KEY("id"), CONSTRAINT "uk_configinfo_datagrouptenant" UNIQUE("data_id", "group_id", "tenant_id")) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."config_info" IS 'config_info'; COMMENT ON COLUMN "NACOS"."config_info"."content" IS 'content'; COMMENT ON COLUMN "NACOS"."config_info"."data_id" IS 'data_id'; COMMENT ON COLUMN "NACOS"."config_info"."encrypted_data_key" IS '秘钥'; COMMENT ON COLUMN "NACOS"."config_info"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "NACOS"."config_info"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "NACOS"."config_info"."id" IS 'id'; COMMENT ON COLUMN "NACOS"."config_info"."md5" IS 'md5'; COMMENT ON COLUMN "NACOS"."config_info"."src_ip" IS 'source ip'; COMMENT ON COLUMN "NACOS"."config_info"."src_user" IS 'source user'; COMMENT ON COLUMN "NACOS"."config_info"."tenant_id" IS '租户字段'; CREATE TABLE "NACOS"."config_info_aggr" ( "id" BIGINT IDENTITY(1, 1) NOT NULL, "data_id" VARCHAR(255) NOT NULL, "group_id" VARCHAR(255) NOT NULL, "datum_id" VARCHAR(255) NOT NULL, "content" CLOB NOT NULL, "gmt_modified" TIMESTAMP(0) NOT NULL, "app_name" VARCHAR(128), "tenant_id" VARCHAR(128) DEFAULT '', NOT CLUSTER PRIMARY KEY("id"), CONSTRAINT "uk_configinfoaggr_datagrouptenantdatum" UNIQUE("data_id", "group_id", "tenant_id", "datum_id")) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."config_info_aggr" IS '增加租户字段'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."content" IS '内容'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."data_id" IS 'data_id'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."datum_id" IS 'datum_id'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."group_id" IS 'group_id'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."id" IS 'id'; COMMENT ON COLUMN "NACOS"."config_info_aggr"."tenant_id" IS '租户字段'; CREATE TABLE "NACOS"."config_info_beta" ( "id" BIGINT IDENTITY(1, 1) NOT NULL, "data_id" VARCHAR(255) NOT NULL, "group_id" VARCHAR(128) NOT NULL, "app_name" VARCHAR(128), "content" CLOB NOT NULL, "beta_ips" VARCHAR(1024), "md5" VARCHAR(32), "gmt_create" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "gmt_modified" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "src_user" TEXT, "src_ip" VARCHAR(50), "tenant_id" VARCHAR(128) DEFAULT '', "encrypted_data_key" TEXT NOT NULL, NOT CLUSTER PRIMARY KEY("id"), CONSTRAINT "uk_configinfobeta_datagrouptenant" UNIQUE("data_id", "group_id", "tenant_id")) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."config_info_beta" IS 'config_info_beta'; COMMENT ON COLUMN "NACOS"."config_info_beta"."app_name" IS 'app_name'; COMMENT ON COLUMN "NACOS"."config_info_beta"."beta_ips" IS 'betaIps'; COMMENT ON COLUMN "NACOS"."config_info_beta"."content" IS 'content'; COMMENT ON COLUMN "NACOS"."config_info_beta"."data_id" IS 'data_id'; COMMENT ON COLUMN "NACOS"."config_info_beta"."encrypted_data_key" IS '秘钥'; COMMENT ON COLUMN "NACOS"."config_info_beta"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "NACOS"."config_info_beta"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "NACOS"."config_info_beta"."group_id" IS 'group_id'; COMMENT ON COLUMN "NACOS"."config_info_beta"."id" IS 'id'; COMMENT ON COLUMN "NACOS"."config_info_beta"."md5" IS 'md5'; COMMENT ON COLUMN "NACOS"."config_info_beta"."src_ip" IS 'source ip'; COMMENT ON COLUMN "NACOS"."config_info_beta"."src_user" IS 'source user'; COMMENT ON COLUMN "NACOS"."config_info_beta"."tenant_id" IS '租户字段'; CREATE TABLE "NACOS"."config_info_tag" ( "id" BIGINT IDENTITY(1, 1) NOT NULL, "data_id" VARCHAR(255) NOT NULL, "group_id" VARCHAR(128) NOT NULL, "tenant_id" VARCHAR(128) DEFAULT '', "tag_id" VARCHAR(128) NOT NULL, "app_name" VARCHAR(128), "content" CLOB NOT NULL, "md5" VARCHAR(32), "gmt_create" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "gmt_modified" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "src_user" TEXT, "src_ip" VARCHAR(50), NOT CLUSTER PRIMARY KEY("id"), CONSTRAINT "uk_configinfotag_datagrouptenanttag" UNIQUE("data_id", "group_id", "tenant_id", "tag_id")) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."config_info_tag" IS 'config_info_tag'; COMMENT ON COLUMN "NACOS"."config_info_tag"."app_name" IS 'app_name'; COMMENT ON COLUMN "NACOS"."config_info_tag"."content" IS 'content'; COMMENT ON COLUMN "NACOS"."config_info_tag"."data_id" IS 'data_id'; COMMENT ON COLUMN "NACOS"."config_info_tag"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "NACOS"."config_info_tag"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "NACOS"."config_info_tag"."group_id" IS 'group_id'; COMMENT ON COLUMN "NACOS"."config_info_tag"."id" IS 'id'; COMMENT ON COLUMN "NACOS"."config_info_tag"."md5" IS 'md5'; COMMENT ON COLUMN "NACOS"."config_info_tag"."src_ip" IS 'source ip'; COMMENT ON COLUMN "NACOS"."config_info_tag"."src_user" IS 'source user'; COMMENT ON COLUMN "NACOS"."config_info_tag"."tag_id" IS 'tag_id'; COMMENT ON COLUMN "NACOS"."config_info_tag"."tenant_id" IS 'tenant_id'; CREATE TABLE "NACOS"."config_tags_relation" ( "id" BIGINT NOT NULL, "tag_name" VARCHAR(128) NOT NULL, "tag_type" VARCHAR(64), "data_id" VARCHAR(255) NOT NULL, "group_id" VARCHAR(128) NOT NULL, "tenant_id" VARCHAR(128) DEFAULT '', "nid" BIGINT IDENTITY(1, 1) NOT NULL, NOT CLUSTER PRIMARY KEY("nid"), CONSTRAINT "uk_configtagrelation_configidtag" UNIQUE("id", "tag_name", "tag_type")) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."config_tags_relation" IS 'config_tag_relation'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."data_id" IS 'data_id'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."group_id" IS 'group_id'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."id" IS 'id'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."tag_name" IS 'tag_name'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."tag_type" IS 'tag_type'; COMMENT ON COLUMN "NACOS"."config_tags_relation"."tenant_id" IS 'tenant_id'; CREATE INDEX "INDEX27450417857800" ON "NACOS"."config_tags_relation"("tenant_id" ASC) STORAGE(ON "NACOS", CLUSTERBTR) ; CREATE TABLE "NACOS"."group_capacity" ( "id" BIGINT IDENTITY(1, 1) NOT NULL, "group_id" VARCHAR(128) DEFAULT '' NOT NULL, "quota" BIGINT DEFAULT 0 NOT NULL, "usage" BIGINT DEFAULT 0 NOT NULL, "max_size" BIGINT DEFAULT 0 NOT NULL, "max_aggr_count" BIGINT DEFAULT 0 NOT NULL, "max_aggr_size" BIGINT DEFAULT 0 NOT NULL, "max_history_count" BIGINT DEFAULT 0 NOT NULL, "gmt_create" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "gmt_modified" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, NOT CLUSTER PRIMARY KEY("id"), CONSTRAINT "uk_group_id" UNIQUE("group_id"), CHECK("quota" >= 0) ,CHECK("usage" >= 0) ,CHECK("max_size" >= 0) ,CHECK("max_aggr_count" >= 0) ,CHECK("max_aggr_size" >= 0) ,CHECK("max_history_count" >= 0)) STORAGE(ON "NACOS", CLUSTERBTR) ; COMMENT ON TABLE "NACOS"."group_capacity" IS '集群、各Group容量信息表'; COMMENT ON COLUMN "NACOS"."group_capacity"."gmt_create" IS '创建时间'; COMMENT ON COLUMN "NACOS"."group_capacity"."gmt_modified" IS '修改时间'; COMMENT ON COLUMN "NACOS"."group_capacity"."group_id" IS 'Group ID，空字符表示整个集群'; COMMENT ON COLUMN "NACOS"."group_capacity"."id" IS '主键ID'; C