西安cms模板建站,免费网站申请,网站线上运营,网站建设 邯郸网站制作文章目录一、准备工作1. 阅读官网文档2. 下载源码#xff0c;按官网更详细3. 下载达梦、人大金仓数据库驱动二、修改nacos源码2.1. 引入驱动依赖2.2. 引用数据库2.3. 修改配置2.4. 添加属性2.5. 指定驱动名称三、构建3.1. 进入源代码目录3.2. 执行构建3.3. 查看构建包3.4. 最后…
文章目录一、准备工作1. 阅读官网文档2. 下载源码按官网更详细3. 下载达梦、人大金仓数据库驱动二、修改nacos源码2.1. 引入驱动依赖2.2. 引用数据库2.3. 修改配置2.4. 添加属性2.5. 指定驱动名称三、构建3.1. 进入源代码目录3.2. 执行构建3.3. 查看构建包3.4. 最后启动3.5. 最后检查3.6. 补充3.7. 初始化脚本背景 Nacos 提供了文件存储和mysql存储两种方式本文记录了如何增加对 达梦数据库的支持。实现思路 采用的方式修改nacos源码增加对达梦数据库的支持 一、准备工作
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.skiptrue clean install -U
ls -al distribution/target/// change the $version to your actual path
cd distribution/target/nacos-server-$version/nacos/bin3. 下载达梦、人大金仓数据库驱动
我下载的是Dm、Kingbase依赖
dm: https://download.csdn.net/download/qq_24101357/20677620 kingbase: https://download.csdn.net/download/qq_24101357/20677646
二、修改nacos源码
2.1. 引入驱动依赖
引入达梦数据库驱动依赖 修改项目根目录下nacos-all的pom.xml
!--达梦、人大金仓 版本管理--
dm-connector-java.version1.8/dm-connector-java.version
kingbase-connector-java.version8.2.0/kingbase-connector-java.versiondependencygroupIdcom.dameng/groupIdartifactIdDm8JdbcDriver18/artifactIdversion${dm-connector-java.version}/version
/dependencydependencygroupIdcom.kingbase/groupIdartifactIdkingbase8/artifactIdversion${kingbase-connector-java.version}/version
/dependency2.2. 引用数据库
在 nacos-config 模块直接引用驱动库修改 nacos-config的pom.xml !-- 达梦数据库驱动--
dependencygroupIdcom.dameng/groupIdartifactIdDm8JdbcDriver18/artifactId
/dependency!-- 人大金仓数据库驱动--
dependencygroupIdcom.kingbase/groupIdartifactIdkingbase8/artifactId
/dependency2.3. 修改配置
nacos-console模块的application.properties
### Count of DB: 这里打开并新增 dm.jdbc.driver.DmDriver 的驱动
db.num1
db.jdbcDriverNamedm.jdbc.driver.DmDriver### Connect URL of DB: 打开并指定 url 连接字符串
#db.url.0jdbc:mysql://127.0.0.1:3306/nacos?characterEncodingutf8connectTimeout1000socketTimeout3000autoReconnecttrueuseUnicodetrueuseSSLfalseserverTimezoneUTC
db.url.0jdbc:dm://192.168.1.22:5236/NACOS?STUzeroDateTimeBehaviorconvertToNulluseUnicodetruecharacterEncodingutf-8
db.user.0NACOS
db.password.0xxxxxxxx#人大金仓
#spring.datasource.platformmysql
#db.num1
#db.jdbcDriverNamecom.kingbase8.Driver
#db.url.0jdbc:kingbase8://127.0.0.1:54321/nacos
#db.user.0root
#db.password.0root#mysql
#spring.datasource.platformmysql
#db.jdbcDriverNamecom.mysql.cj.jdbc.Driver
#db.num1
#db.url.0jdbc:mysql://127.0.0.1:3306/nacos?characterEncodingutf8connectTimeout1000socketTimeout3000autoReconnecttrueuseUnicodetrueuseSSLfalseserverTimezoneUTC
#db.use.0rroot
#db.password.0root2.4. 添加属性
nacos-config模块 com.alibaba.nacos.config.server.service.datasource.ExternalDataSourceProperties.java 其实就改了可以通过配置文件指定数据库驱动 添加属性 /*** 数据库驱动* 增加对达梦、人大金仓数据库的支持*/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)) {// 增加其他数据库驱动的支持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}*/ListHikariDataSource build(Environment environment, CallbackHikariDataSource callback) {ListHikariDataSource 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)) {// 增加其他数据库驱动的支持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.43.2. 执行构建
mvn -Prelease-nacos -Dmaven.test.skiptrue -Dpmd.skiptrue -Dcheckstyle.skiptrue clean install -U或者
mvn -Prelease-nacos -Dmaven.test.skiptrue clean install -U注可以查看nacos文件夹目录里面有一个BUILDING文件中说明 3.3. 查看构建包
获得构建完成后的工程 构建后在 进入到源代码目录 中的 文件夹 distribution/target/nacos-server-$version 下的 nacos 文件夹 就是最终的输出物。 nacos-server-2.1.0-SNAPSHOT.tar.gz 是linux环境的 nacos-server-2.1.0-SNAPSHOT.zip 是windows环境的
3.4. 最后启动
启动 nacos查看启动日志
sh startup.sh -m standalonetail -f /app/支持达梦改造后的Nacos/nacos/logs/start.out
3.5. 最后检查
看看数据库中Nacos 已经使用 达梦数据库来存储了。
3.6. 补充
如果遇到这个异常请参考这篇博客 Too many files with unapproved license: 2 See RAT report
3.7. 初始化脚本
达梦数据库中初始化 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 创建时间;
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 创建时间;
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 创建时间;
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 单个配置大小上限单位为字节0表示使用默认值;
COMMENT ON COLUMN NACOS.GROUP_CAPACITY.MAX_AGGR_COUNT IS 聚合子配置最大个数0表示使用默认值;
COMMENT ON COLUMN NACOS.GROUP_CAPACITY.MAX_AGGR_SIZE IS 单个聚合数据的子配置大小上限单位为字节0表示使用默认值;
COMMENT ON COLUMN NACOS.GROUP_CAPACITY.MAX_HISTORY_COUNT IS 最大变更历史数量;
COMMENT ON COLUMN NACOS.GROUP_CAPACITY.GMT_CREATE IS 创建时间;
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 单个配置大小上限单位为字节0表示使用默认值;
COMMENT ON COLUMN NACOS.TENANT_CAPACITY.MAX_AGGR_COUNT IS 聚合子配置最大个数;
COMMENT ON COLUMN NACOS.TENANT_CAPACITY.MAX_AGGR_SIZE IS 单个聚合数据的子配置大小上限单位为字节0表示使用默认值;
COMMENT ON COLUMN NACOS.TENANT_CAPACITY.MAX_HISTORY_COUNT IS 最大变更历史数量;
COMMENT ON COLUMN NACOS.TENANT_CAPACITY.GMT_CREATE IS 创建时间;
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 创建时间;
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) ;
