當前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

nacos 适配达梦、人大金仓数据库

發(fā)布時間：2024/9/27 数据库 29 豆豆

生活随笔收集整理的這篇文章主要介紹了 nacos 适配达梦、人大金仓数据库小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.

文章目錄

- - - - 一、準備工作
      - 1. 閱讀官網文檔
        2. 下載源碼，按官網更詳細
        3. 下載達夢、人大金倉數(shù)據(jù)庫驅動
      - 二、修改nacos源碼
      - 2.1. 引入驅動依賴
        2.2. 引用數(shù)據(jù)庫
        2.3. 修改配置
        2.4. 添加屬性
        2.5. 指定驅動名稱
      - 三、構建
      - 3.1. 進入源代碼目錄
        3.2. 執(zhí)行構建
        3.3. 查看構建包
        3.4. 最后啟動
        3.5. 最后檢查
        3.6. 補充
        3.7. 初始化腳本

背景
Nacos 提供了文件存儲和mysql存儲兩種方式，本文記錄了如何增加對達夢數(shù)據(jù)庫的支持。

實現(xiàn)思路
采用的方式：修改nacos源碼增加對達夢數(shù)據(jù)庫的支持

一、準備工作

1. 閱讀官網文檔

下載nacos源碼、編譯，官網更詳細
https://nacos.io/zh-cn/docs/quick-start.html

2. 下載源碼，按官網更詳細

git地址：https://github.com/alibaba/nacos.git

git clone https://github.com/alibaba/nacos.git cd nacos/ mvn -Prelease-nacos -Dmaven.test.skip=true clean install -U ls -al distribution/target/// change the $version to your actual path cd distribution/target/nacos-server-$version/nacos/bin

3. 下載達夢、人大金倉數(shù)據(jù)庫驅動

我下載的是：Dm、Kingbase依賴

dm: https://download.csdn.net/download/qq_24101357/20677620
kingbase: https://download.csdn.net/download/qq_24101357/20677646

二、修改nacos源碼

2.1. 引入驅動依賴

引入達夢數(shù)據(jù)庫驅動依賴
修改項目根目錄下nacos-all的pom.xml

<dm-connector-java.version>1.8</dm-connector-java.version> <kingbase-connector-java.version>8.2.0</kingbase-connector-java.version> <dependency><groupId>com.dameng</groupId><artifactId>Dm8JdbcDriver18</artifactId><version>${dm-connector-java.version}</version> </dependency><dependency><groupId>com.kingbase</groupId><artifactId>kingbase8</artifactId><version>${kingbase-connector-java.version}</version> </dependency>

2.2. 引用數(shù)據(jù)庫

在 nacos-config 模塊直接引用驅動庫，修改 nacos-config的pom.xml

<dependency><groupId>com.dameng</groupId><artifactId>Dm8JdbcDriver18</artifactId> </dependency> <dependency><groupId>com.kingbase</groupId><artifactId>kingbase8</artifactId> </dependency>

2.3. 修改配置

nacos-console模塊的application.properties：

### Count of DB: 這里打開，并新增 dm.jdbc.driver.DmDriver 的驅動 db.num=1 db.jdbcDriverName=dm.jdbc.driver.DmDriver### Connect URL of DB: 打開并指定 url 連接字符串 #db.url.0=jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC db.url.0=jdbc:dm://192.168.1.22:5236/NACOS?STU&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8 db.user.0=NACOS db.password.0=xxxxxxxx#人大金倉 #spring.datasource.platform=mysql #db.num=1 #db.jdbcDriverName=com.kingbase8.Driver #db.url.0=jdbc:kingbase8://127.0.0.1:54321/nacos #db.user.0=root #db.password.0=root#mysql #spring.datasource.platform=mysql #db.jdbcDriverName=com.mysql.cj.jdbc.Driver #db.num=1 #db.url.0=jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC #db.use.0r=root #db.password.0=root

2.4. 添加屬性

nacos-config模塊：
com.alibaba.nacos.config.server.service.datasource.ExternalDataSourceProperties.java
其實就改了可以通過配置文件指定數(shù)據(jù)庫驅動
添加屬性

/*** 數(shù)據(jù)庫驅動* 增加對達夢、人大金倉數(shù)據(jù)庫的支持*/private String jdbcDriverName;public String getJdbcDriverName() {return jdbcDriverName;}public void setJdbcDriverName(String jdbcDriverName) {this.jdbcDriverName = jdbcDriverName;}

2.5. 指定驅動名稱

為 HikariDataSource 對象指定驅動名稱，調動 setDriverClassName 方法，見下：
修改build方法或者直接替換（下面有代碼）
修改部分為紅框部分

變更代碼部分

//update StartSystem.out.println("#################################");System.out.println("jdbcDriverName=" + jdbcDriverName);if (StringUtils.isNotEmpty(jdbcDriverName)) {// 增加其他數(shù)據(jù)庫驅動的支持ds.setDriverClassName(jdbcDriverName);} else {//默認使用mysql驅動ds.setDriverClassName(JDBC_DRIVER_NAME);}System.out.println("#################################");System.out.println("dataSources=" + dataSources);dataSources.add(ds);callback.accept(ds);System.out.println("dataSources=" + dataSources);//update End

修改后的方法

/*** Build serveral HikariDataSource.** @param environment {@link Environment}* @param callback Callback function when constructing data source* @return List of {@link HikariDataSource}*/List<HikariDataSource> build(Environment environment, Callback<HikariDataSource> callback) {List<HikariDataSource> dataSources = new ArrayList<>();Binder.get(environment).bind("db", Bindable.ofInstance(this));Preconditions.checkArgument(Objects.nonNull(num), "db.num is null");Preconditions.checkArgument(CollectionUtils.isNotEmpty(user), "db.user or db.user.[index] is null");Preconditions.checkArgument(CollectionUtils.isNotEmpty(password), "db.password or db.password.[index] is null");for (int index = 0; index < num; index++) {int currentSize = index + 1;Preconditions.checkArgument(url.size() >= currentSize, "db.url.%s is null", index);DataSourcePoolProperties poolProperties = DataSourcePoolProperties.build(environment);poolProperties.setDriverClassName(JDBC_DRIVER_NAME);poolProperties.setJdbcUrl(url.get(index).trim());poolProperties.setUsername(getOrDefault(user, index, user.get(0)).trim());poolProperties.setPassword(getOrDefault(password, index, password.get(0)).trim());HikariDataSource ds = poolProperties.getDataSource();ds.setConnectionTestQuery(TEST_QUERY);ds.setIdleTimeout(TimeUnit.MINUTES.toMillis(10L));ds.setConnectionTimeout(TimeUnit.SECONDS.toMillis(3L));System.out.println("#################################");System.out.println("jdbcDriverName=" + jdbcDriverName);if (StringUtils.isNotEmpty(jdbcDriverName)) {// 增加其他數(shù)據(jù)庫驅動的支持ds.setDriverClassName(jdbcDriverName);} else {//默認使用mysql驅動ds.setDriverClassName(JDBC_DRIVER_NAME);}System.out.println("#################################");System.out.println("dataSources=" + dataSources);dataSources.add(ds);callback.accept(ds);}Preconditions.checkArgument(CollectionUtils.isNotEmpty(dataSources), "no datasource available");return dataSources;}

三、構建

3.1. 進入源代碼目錄

cd nacos-2.0.4

3.2. 執(zhí)行構建

mvn -Prelease-nacos -Dmaven.test.skip=true -Dpmd.skip=true -Dcheckstyle.skip=true clean install -U

或者

mvn -Prelease-nacos -Dmaven.test.skip=true clean install -U

（注：可以查看nacos文件夾，目錄里面有一個BUILDING文件中說明）

3.3. 查看構建包

獲得構建完成后的工程
構建后，在進入到源代碼目錄中的文件夾：
distribution/target/nacos-server-$version 下的 nacos 文件夾就是最終的輸出物。

nacos-server-2.1.0-SNAPSHOT.tar.gz 是linux環(huán)境的
nacos-server-2.1.0-SNAPSHOT.zip 是windows環(huán)境的

3.4. 最后啟動

啟動 nacos查看啟動日志

sh startup.sh -m standalone

tail -f /app/支持達夢改造后的Nacos/nacos/logs/start.out

3.5. 最后檢查

看看數(shù)據(jù)庫中，Nacos 已經使用達夢數(shù)據(jù)庫來存儲了。

3.6. 補充

如果遇到這個異常請參考這篇博客
Too many files with unapproved license: 2 See RAT report

3.7. 初始化腳本

達夢數(shù)據(jù)庫中初始化 Nacos 語句.sql

注意需要修改對應的用戶，以下腳本默認試NACOS

/*################################################################################ # 2021-09-03 記錄遺留問題： # (1) 達夢的 bigint 最大是20，而 mysql是64，因此：his_config_info 表的 `id` bigint(64) 只得改為 bitint，但愿自增列別用盡 # (2) 達夢不支持 unsigned ,而 mysql 支持，因此：只得在達夢放棄 unsigned ################################################################################*/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, NOT CLUSTER PRIMARY KEY("ID"), CONSTRAINT "UK_CONFIGINFO_DATAGROUPTENANT" UNIQUE("DATA_ID", "GROUP_ID", "TENANT_ID")) STORAGE(ON "nacos_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."CONFIG_INFO" IS 'config_info'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."ID" IS 'id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."DATA_ID" IS 'data_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."CONTENT" IS 'content'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."MD5" IS 'md5'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."GMT_MODIFIED" IS '修改時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."SRC_USER" IS 'source user'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."SRC_IP" IS 'source ip'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."TENANT_ID" IS '租戶字段';CREATE UNIQUE INDEX "INDEX16097400477400" ON "NACOS"."CONFIG_INFO"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;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_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."CONFIG_INFO_AGGR" IS '增加租戶字段'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."ID" IS 'id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."DATA_ID" IS 'data_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."GROUP_ID" IS 'group_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."DATUM_ID" IS 'datum_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."CONTENT" IS '內容'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."GMT_MODIFIED" IS '修改時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."TENANT_ID" IS '租戶字段';CREATE UNIQUE INDEX "INDEX16097305729100" ON "NACOS"."CONFIG_INFO_AGGR"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;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 '', NOT CLUSTER PRIMARY KEY("ID"), CONSTRAINT "UK_CONFIGINFOBETA_DATAGROUPTENANT" UNIQUE("DATA_ID", "GROUP_ID", "TENANT_ID")) STORAGE(ON "nacos_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."CONFIG_INFO_BETA" IS 'config_info_beta'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."ID" IS 'id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."DATA_ID" IS 'data_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GROUP_ID" IS 'group_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."APP_NAME" IS 'app_name'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."CONTENT" IS 'content'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."BETA_IPS" IS 'betaIps'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."MD5" IS 'md5'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GMT_MODIFIED" IS '修改時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."SRC_USER" IS 'source user'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."SRC_IP" IS 'source ip'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."TENANT_ID" IS '租戶字段';CREATE UNIQUE INDEX "INDEX16097203229000" ON "NACOS"."CONFIG_INFO_BETA"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;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_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."CONFIG_INFO_TAG" IS 'config_info_tag'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."ID" IS 'id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."DATA_ID" IS 'data_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GROUP_ID" IS 'group_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."TENANT_ID" IS 'tenant_id'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."TAG_ID" IS 'tag_id'; 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"."MD5" IS 'md5'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GMT_MODIFIED" IS '修改時間'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."SRC_USER" IS 'source user'; COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."SRC_IP" IS 'source ip';CREATE UNIQUE INDEX "INDEX16096985471400" ON "NACOS"."CONFIG_INFO_TAG"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;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_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."CONFIG_TAGS_RELATION" IS 'config_tag_relation'; 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"."DATA_ID" IS 'data_id'; COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."GROUP_ID" IS 'group_id'; COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."TENANT_ID" IS 'tenant_id';CREATE INDEX "INDEX16096890650200" ON "NACOS"."CONFIG_TAGS_RELATION"("TENANT_ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; CREATE UNIQUE INDEX "INDEX16096909541100" ON "NACOS"."CONFIG_TAGS_RELATION"("NID" ASC) STORAGE(ON "nacos_db", 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_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."GROUP_CAPACITY" IS '集群、各Group容量信息表'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."ID" IS '主鍵ID'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GROUP_ID" IS 'Group ID，空字符表示整個集群'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."QUOTA" IS '配額，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."USAGE" IS '使用量'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_SIZE" IS '單個配置大小上限，單位為字節(jié)，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大個數(shù)，，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_AGGR_SIZE" IS '單個聚合數(shù)據(jù)的子配置大小上限，單位為字節(jié)，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_HISTORY_COUNT" IS '最大變更歷史數(shù)量'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GMT_MODIFIED" IS '修改時間';CREATE UNIQUE INDEX "INDEX16096746763900" ON "NACOS"."GROUP_CAPACITY"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."HIS_CONFIG_INFO" ( "ID" BIGINT NOT NULL, "NID" 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, "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), "OP_TYPE" CHAR(10), "TENANT_ID" VARCHAR(128) DEFAULT '', NOT CLUSTER PRIMARY KEY("NID")) STORAGE(ON "nacos_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."HIS_CONFIG_INFO" IS '多租戶改造'; COMMENT ON COLUMN "NACOS"."HIS_CONFIG_INFO"."APP_NAME" IS 'app_name'; COMMENT ON COLUMN "NACOS"."HIS_CONFIG_INFO"."TENANT_ID" IS '租戶字段';CREATE INDEX "IDX_GMT_CREATE" ON "NACOS"."HIS_CONFIG_INFO"("GMT_CREATE" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; CREATE INDEX "IDX_DID" ON "NACOS"."HIS_CONFIG_INFO"("DATA_ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; CREATE INDEX "IDX_GMT_MODIFIED" ON "NACOS"."HIS_CONFIG_INFO"("GMT_MODIFIED" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; CREATE UNIQUE INDEX "INDEX16096449256900" ON "NACOS"."HIS_CONFIG_INFO"("NID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."PERMISSIONS" ( "ROLE" VARCHAR(50) NOT NULL, "RESOURCE" VARCHAR(255) NOT NULL, "ACTION" VARCHAR(8) NOT NULL, CONSTRAINT "UK_ROLE_PERMISSION" UNIQUE("ROLE", "RESOURCE", "ACTION")) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."ROLES" ( "USERNAME" VARCHAR(50) NOT NULL, "ROLE" VARCHAR(50) NOT NULL, CONSTRAINT "IDX_USER_ROLE" UNIQUE("USERNAME", "ROLE")) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."TENANT_CAPACITY" ( "ID" BIGINT IDENTITY(1, 1) NOT NULL, "TENANT_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_TENANT_ID" UNIQUE("TENANT_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_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."TENANT_CAPACITY" IS '租戶容量信息表'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."ID" IS '主鍵ID'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."TENANT_ID" IS 'Tenant ID'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."QUOTA" IS '配額，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."USAGE" IS '使用量'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_SIZE" IS '單個配置大小上限，單位為字節(jié)，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大個數(shù)'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_AGGR_SIZE" IS '單個聚合數(shù)據(jù)的子配置大小上限，單位為字節(jié)，0表示使用默認值'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_HISTORY_COUNT" IS '最大變更歷史數(shù)量'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."GMT_MODIFIED" IS '修改時間';CREATE UNIQUE INDEX "INDEX16096046055000" ON "NACOS"."TENANT_CAPACITY"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."TENANT_INFO" ( "ID" BIGINT IDENTITY(1, 1) NOT NULL, "KP" VARCHAR(128) NOT NULL, "TENANT_ID" VARCHAR(128) DEFAULT '', "TENANT_NAME" VARCHAR(128) DEFAULT '', "TENANT_DESC" VARCHAR(256), "CREATE_SOURCE" VARCHAR(32), "GMT_CREATE" BIGINT NOT NULL, "GMT_MODIFIED" BIGINT NOT NULL, NOT CLUSTER PRIMARY KEY("ID"), CONSTRAINT "UK_TENANT_INFO_KPTENANTID" UNIQUE("KP", "TENANT_ID")) STORAGE(ON "nacos_db", CLUSTERBTR) ;COMMENT ON TABLE "NACOS"."TENANT_INFO" IS 'tenant_info'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."ID" IS 'id'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."KP" IS 'kp'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_ID" IS 'tenant_id'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_NAME" IS 'tenant_name'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_DESC" IS 'tenant_desc'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."CREATE_SOURCE" IS 'create_source'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."GMT_CREATE" IS '創(chuàng)建時間'; COMMENT ON COLUMN "NACOS"."TENANT_INFO"."GMT_MODIFIED" IS '修改時間';CREATE INDEX "IDX_TENANT_ID" ON "NACOS"."TENANT_INFO"("TENANT_ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; CREATE UNIQUE INDEX "INDEX16095846853300" ON "NACOS"."TENANT_INFO"("ID" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE TABLE "NACOS"."USERS" ( "USERNAME" VARCHAR(50) NOT NULL, "PASSWORD" VARCHAR(500) NOT NULL, "ENABLED" TINYINT NOT NULL, NOT CLUSTER PRIMARY KEY("USERNAME")) STORAGE(ON "nacos_db", CLUSTERBTR) ;CREATE UNIQUE INDEX "PRIMARY" ON "NACOS"."USERS"("USERNAME" ASC) STORAGE(ON "nacos_db", CLUSTERBTR) ; 創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎勵來咯，堅持創(chuàng)作打卡瓜分現(xiàn)金大獎

總結

以上是生活随笔為你收集整理的nacos 适配达梦、人大金仓数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： FTP多用户权限 linux环境一站式
下一篇： Gitlab14.x 安装、配置、启动