nacos2.2.0 oracle 建表语句

已于 2024-10-31 10:09:10 修改
阅读量292 收藏 2
点赞数 4
文章标签： oracle android 数据库
于 2024-10-30 15:53:20 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_58620140/article/details/143367289
版权

1、删表语句

drop table  config_info;
drop table  config_info_aggr;
drop table  config_info_beta;
drop table  config_info_tag;
drop table  config_tags_relation;
drop table  group_capacity;
drop table  his_config_info;
drop table  permissions;
drop table  roles;
drop table  tenant_capacity;
drop table  tenant_info;
drop table  users;

2、建表语句

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80403 (8.4.3)
 Source Host           : 127.0.0.1:3306
 Source Schema         : nacos

 Target Server Type    : Oracle
 Target Server Version : 190100
 File Encoding         : 65001

 Date: 30/10/2024 15:35:57
*/


-- ----------------------------
-- Table structure for config_info
-- ----------------------------
CREATE TABLE "CONFIG_INFO" (
                               "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                               "DATA_ID" NVARCHAR2(255) NOT NULL,
                               "GROUP_ID" NVARCHAR2(128),
                               "CONTENT" CLOB NOT NULL,
                               "MD5" NVARCHAR2(32),
                               "GMT_CREATE" DATE NOT NULL,
                               "GMT_MODIFIED" DATE NOT NULL,
                               "SRC_USER" CLOB,
                               "SRC_IP" NVARCHAR2(20),
                               "APP_NAME" NVARCHAR2(128),
                               "TENANT_ID" NVARCHAR2(128) DEFAULT '',
                               "C_DESC" NVARCHAR2(256),
                               "C_USE" NVARCHAR2(64),
                               "EFFECT" NVARCHAR2(64),
                               "TYPE" NVARCHAR2(64),
                               "C_SCHEMA" CLOB,
                               "ENCRYPTED_DATA_KEY" CLOB
)
;
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 COLUMN "CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '秘钥';
COMMENT ON TABLE "CONFIG_INFO" IS 'config_info';

-- ----------------------------
-- Records of config_info
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------

CREATE TABLE "CONFIG_INFO_AGGR" (
                                    "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                    "DATA_ID" NVARCHAR2(255) NOT NULL,
                                    "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                    "DATUM_ID" NVARCHAR2(255) NOT NULL,
                                    "CONTENT" CLOB NOT NULL,
                                    "GMT_MODIFIED" DATE NOT NULL,
                                    "APP_NAME" NVARCHAR2(128),
                                    "TENANT_ID" NVARCHAR2(128)
)
;
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 '增加租户字段';

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
CREATE TABLE "CONFIG_INFO_BETA" (
                                    "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                    "DATA_ID" NVARCHAR2(255) NOT NULL,
                                    "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                    "APP_NAME" NVARCHAR2(128),
                                    "CONTENT" CLOB NOT NULL,
                                    "BETA_IPS" CLOB,
                                    "MD5" NVARCHAR2(32),
                                    "GMT_CREATE" DATE NOT NULL,
                                    "GMT_MODIFIED" DATE NOT NULL,
                                    "SRC_USER" CLOB,
                                    "SRC_IP" NVARCHAR2(20),
                                    "TENANT_ID" NVARCHAR2(128),
                                    "ENCRYPTED_DATA_KEY" CLOB
)
;
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 COLUMN "CONFIG_INFO_BETA"."ENCRYPTED_DATA_KEY" IS '秘钥';
COMMENT ON TABLE "CONFIG_INFO_BETA" IS 'config_info_beta';

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
CREATE TABLE "CONFIG_INFO_TAG" (
                                   "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                   "DATA_ID" NVARCHAR2(255) NOT NULL,
                                   "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                   "TENANT_ID" NVARCHAR2(128),
                                   "TAG_ID" NVARCHAR2(128) NOT NULL,
                                   "APP_NAME" NVARCHAR2(128),
                                   "CONTENT" CLOB NOT NULL,
                                   "MD5" NVARCHAR2(32),
                                   "GMT_CREATE" DATE NOT NULL,
                                   "GMT_MODIFIED" DATE NOT NULL,
                                   "SRC_USER" CLOB,
                                   "SRC_IP" NVARCHAR2(20)
)
;
COMMENT ON COLUMN "CONFIG_INFO_TAG"."ID" IS 'id';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."DATA_ID" IS 'data_id';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GROUP_ID" IS 'group_id';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."TENANT_ID" IS 'tenant_id';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."TAG_ID" IS 'tag_id';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."APP_NAME" IS 'app_name';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."CONTENT" IS 'content';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."MD5" IS 'md5';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_CREATE" IS '创建时间';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_MODIFIED" IS '修改时间';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_USER" IS 'source user';
COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_IP" IS 'source ip';
COMMENT ON TABLE "CONFIG_INFO_TAG" IS 'config_info_tag';

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
CREATE TABLE "CONFIG_TAGS_RELATION" (
                                        "ID" NUMBER(20) NOT NULL,
                                        "TAG_NAME" NVARCHAR2(128) NOT NULL,
                                        "TAG_TYPE" NVARCHAR2(64),
                                        "DATA_ID" NVARCHAR2(255) NOT NULL,
                                        "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                        "TENANT_ID" NVARCHAR2(128),
                                        "NID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY
)
;
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."ID" IS 'id';
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_NAME" IS 'tag_name';
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_TYPE" IS 'tag_type';
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."DATA_ID" IS 'data_id';
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."GROUP_ID" IS 'group_id';
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TENANT_ID" IS 'tenant_id';
COMMENT ON TABLE "CONFIG_TAGS_RELATION" IS 'config_tag_relation';

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
CREATE TABLE "GROUP_CAPACITY" (
                                  "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                  "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                  "QUOTA" NUMBER(11) NOT NULL,
                                  "USAGE" NUMBER(11) NOT NULL,
                                  "MAX_SIZE" NUMBER(11) NOT NULL,
                                  "MAX_AGGR_COUNT" NUMBER(11) NOT NULL,
                                  "MAX_AGGR_SIZE" NUMBER(11) NOT NULL,
                                  "MAX_HISTORY_COUNT" NUMBER(11) NOT NULL,
                                  "GMT_CREATE" DATE NOT NULL,
                                  "GMT_MODIFIED" DATE NOT NULL
)
;
COMMENT ON COLUMN "GROUP_CAPACITY"."ID" IS '主键ID';
COMMENT ON COLUMN "GROUP_CAPACITY"."GROUP_ID" IS 'Group ID，空字符表示整个集群';
COMMENT ON COLUMN "GROUP_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';
COMMENT ON COLUMN "GROUP_CAPACITY"."USAGE" IS '使用量';
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数，，0表示使用默认值';
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';
COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_CREATE" IS '创建时间';
COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_MODIFIED" IS '修改时间';
COMMENT ON TABLE "GROUP_CAPACITY" IS '集群、各Group容量信息表';

-- ----------------------------
-- Records of group_capacity
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
CREATE TABLE "HIS_CONFIG_INFO" (
                                   "ID" NUMBER(20) NOT NULL,
                                   "NID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                   "DATA_ID" NVARCHAR2(255) NOT NULL,
                                   "GROUP_ID" NVARCHAR2(128) NOT NULL,
                                   "APP_NAME" NVARCHAR2(128),
                                   "CONTENT" CLOB NOT NULL,
                                   "MD5" NVARCHAR2(32),
                                   "GMT_CREATE" DATE DEFAULT SYSDATE NOT NULL,  -- 默认值为当前时间
                                   "GMT_MODIFIED" DATE DEFAULT SYSDATE NOT NULL,
                                   "SRC_USER" CLOB,
                                   "SRC_IP" NVARCHAR2(20),
                                   "OP_TYPE" NCHAR(10),
                                   "TENANT_ID" NVARCHAR2(128),
                                   "ENCRYPTED_DATA_KEY" CLOB
)
;
COMMENT ON COLUMN "HIS_CONFIG_INFO"."APP_NAME" IS 'app_name';
COMMENT ON COLUMN "HIS_CONFIG_INFO"."TENANT_ID" IS '租户字段';
COMMENT ON COLUMN "HIS_CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '秘钥';
COMMENT ON TABLE "HIS_CONFIG_INFO" IS '多租户改造';

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE "PERMISSIONS" (
                               "ROLE" NVARCHAR2(50) NOT NULL,
                               "RESOURCE" NVARCHAR2(512) NOT NULL,
                               "ACTION" NVARCHAR2(8) NOT NULL
)
;

-- ----------------------------
-- Records of permissions
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE "ROLES" (
                         "USERNAME" NVARCHAR2(50) NOT NULL,
                         "ROLE" NVARCHAR2(50) NOT NULL
)
;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO "ROLES" ("USERNAME", "ROLE") VALUES ('nacos', 'ROLE_ADMIN');
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
CREATE TABLE "TENANT_CAPACITY" (
                                   "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                                   "TENANT_ID" NVARCHAR2(128) NOT NULL,
                                   "QUOTA" NUMBER(11) NOT NULL,
                                   "USAGE" NUMBER(11) NOT NULL,
                                   "MAX_SIZE" NUMBER(11) NOT NULL,
                                   "MAX_AGGR_COUNT" NUMBER(11) NOT NULL,
                                   "MAX_AGGR_SIZE" NUMBER(11) NOT NULL,
                                   "MAX_HISTORY_COUNT" NUMBER(11) NOT NULL,
                                   "GMT_CREATE" DATE NOT NULL,
                                   "GMT_MODIFIED" DATE NOT NULL
)
;
COMMENT ON COLUMN "TENANT_CAPACITY"."ID" IS '主键ID';
COMMENT ON COLUMN "TENANT_CAPACITY"."TENANT_ID" IS 'Tenant ID';
COMMENT ON COLUMN "TENANT_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';
COMMENT ON COLUMN "TENANT_CAPACITY"."USAGE" IS '使用量';
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数';
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';
COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_CREATE" IS '创建时间';
COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_MODIFIED" IS '修改时间';
COMMENT ON TABLE "TENANT_CAPACITY" IS '租户容量信息表';

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for tenant_info
CREATE TABLE "TENANT_INFO" (
                               "ID" NUMBER(20) GENERATED BY DEFAULT AS IDENTITY,
                               "KP" NVARCHAR2(128) NOT NULL,
                               "TENANT_ID" NVARCHAR2(128),
                               "TENANT_NAME" NVARCHAR2(128),
                               "TENANT_DESC" NVARCHAR2(256),
                               "CREATE_SOURCE" NVARCHAR2(32),
                               "GMT_CREATE" NUMBER(20) NOT NULL,
                               "GMT_MODIFIED" NUMBER(20) NOT NULL
)
;
COMMENT ON COLUMN "TENANT_INFO"."ID" IS 'id';
COMMENT ON COLUMN "TENANT_INFO"."KP" IS 'kp';
COMMENT ON COLUMN "TENANT_INFO"."TENANT_ID" IS 'tenant_id';
COMMENT ON COLUMN "TENANT_INFO"."TENANT_NAME" IS 'tenant_name';
COMMENT ON COLUMN "TENANT_INFO"."TENANT_DESC" IS 'tenant_desc';
COMMENT ON COLUMN "TENANT_INFO"."CREATE_SOURCE" IS 'create_source';
COMMENT ON COLUMN "TENANT_INFO"."GMT_CREATE" IS '创建时间';
COMMENT ON COLUMN "TENANT_INFO"."GMT_MODIFIED" IS '修改时间';
COMMENT ON TABLE "TENANT_INFO" IS 'tenant_info';

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
COMMIT;
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE "USERS" (
                         "USERNAME" NVARCHAR2(50) NOT NULL,
                         "PASSWORD" NVARCHAR2(500) NOT NULL,
                         "ENABLED" NUMBER(4) NOT NULL
)
;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO "USERS" ("USERNAME", "PASSWORD", "ENABLED") VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', '1');
COMMIT;
COMMIT;

-- ----------------------------
-- Primary Key structure for table config_info
-- ----------------------------
ALTER TABLE "CONFIG_INFO" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table config_info
-- ----------------------------
CREATE UNIQUE INDEX "UK_CONFIGINFO_DATAGROUPTENANT"
    ON "CONFIG_INFO" ("DATA_ID" ASC, "GROUP_ID" ASC, "TENANT_ID" ASC);

-- ----------------------------
-- Primary Key structure for table config_info_aggr
-- ----------------------------
ALTER TABLE "CONFIG_INFO_AGGR" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table config_info_aggr
-- ----------------------------
CREATE UNIQUE INDEX "UK_CONFIGINFOAGGR_DATAGROUPTENANTDATUM"
    ON "CONFIG_INFO_AGGR" ("DATA_ID" ASC, "GROUP_ID" ASC, "TENANT_ID" ASC, "DATUM_ID" ASC);

-- ----------------------------
-- Primary Key structure for table config_info_beta
-- ----------------------------
ALTER TABLE "CONFIG_INFO_BETA" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table config_info_beta
-- ----------------------------
CREATE UNIQUE INDEX "UK_CONFIGINFOBETA_DATAGROUPTENANT"
    ON "CONFIG_INFO_BETA" ("DATA_ID" ASC, "GROUP_ID" ASC, "TENANT_ID" ASC);

-- ----------------------------
-- Primary Key structure for table config_info_tag
-- ----------------------------
ALTER TABLE "CONFIG_INFO_TAG" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table config_info_tag
-- ----------------------------
CREATE UNIQUE INDEX "UK_CONFIGINFOTAG_DATAGROUPTENANTTAG"
    ON "CONFIG_INFO_TAG" ("DATA_ID" ASC, "GROUP_ID" ASC, "TENANT_ID" ASC, "TAG_ID" ASC);

-- ----------------------------
-- Primary Key structure for table config_tags_relation
-- ----------------------------
ALTER TABLE "CONFIG_TAGS_RELATION" ADD PRIMARY KEY ("NID");

-- ----------------------------
-- Indexes structure for table config_tags_relation
-- ----------------------------
CREATE UNIQUE INDEX "UK_CONFIGTAGRELATION_CONFIGIDTAG"
    ON "CONFIG_TAGS_RELATION" ("ID" ASC, "TAG_NAME" ASC, "TAG_TYPE" ASC);
CREATE INDEX "IDX_TENANT_ID"
    ON "CONFIG_TAGS_RELATION" ("TENANT_ID" ASC);

-- ----------------------------
-- Primary Key structure for table group_capacity
-- ----------------------------
ALTER TABLE "GROUP_CAPACITY" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table group_capacity
-- ----------------------------
CREATE UNIQUE INDEX "UK_GROUP_ID"
    ON "GROUP_CAPACITY" ("GROUP_ID" ASC);

-- ----------------------------
-- Primary Key structure for table his_config_info
-- ----------------------------
ALTER TABLE "HIS_CONFIG_INFO" ADD PRIMARY KEY ("NID");

-- ----------------------------
-- Indexes structure for table his_config_info
-- ----------------------------
CREATE INDEX "IDX_GMT_CREATE"
    ON "HIS_CONFIG_INFO" ("GMT_CREATE" ASC);
CREATE INDEX "IDX_GMT_MODIFIED"
    ON "HIS_CONFIG_INFO" ("GMT_MODIFIED" ASC);
CREATE INDEX "IDX_DID"
    ON "HIS_CONFIG_INFO" ("DATA_ID" ASC);

-- ----------------------------
-- Indexes structure for table permissions
-- ----------------------------
CREATE UNIQUE INDEX "UK_ROLE_PERMISSION"
    ON "PERMISSIONS" ("ROLE" ASC, "RESOURCE" ASC, "ACTION" ASC);

-- ----------------------------
-- Indexes structure for table roles
-- ----------------------------
CREATE UNIQUE INDEX "UK_USERNAME_ROLE"
    ON "ROLES" ("USERNAME" ASC, "ROLE" ASC);

-- ----------------------------
-- Primary Key structure for table tenant_capacity
-- ----------------------------
ALTER TABLE "TENANT_CAPACITY" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table tenant_capacity
-- ----------------------------
CREATE UNIQUE INDEX "UK_TENANT_ID"
    ON "TENANT_CAPACITY" ("TENANT_ID" ASC);

-- ----------------------------
-- Primary Key structure for table tenant_info
-- ----------------------------
ALTER TABLE "TENANT_INFO" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table tenant_info
-- ----------------------------
CREATE UNIQUE INDEX "UK_TENANT_INFO_KPTENANTID"
    ON "TENANT_INFO" ("KP" ASC, "TENANT_ID" ASC);
CREATE INDEX "IDX_TENANT_INFO_TENANT_ID"
    ON "TENANT_INFO" ("TENANT_ID" ASC);

-- ----------------------------
-- Primary Key structure for table users
-- ----------------------------
ALTER TABLE "USERS" ADD PRIMARY KEY ("USERNAME");

Nacos2.2.0适配金仓Kingbase8数据源
weixin_45726578的博客
04-27 1371
Nacos 从 2.2.0 版本开始,可通过 SPI 机制注入多数据源实现插件,并在引入对应数据源实现后,便可在 Nacos 启动时通过读取 application.properties 配置文件中 spring.datasource.platform 配置项选择加载对应多数据源插件.
Nacos2.3.2适配Oracle和PostgreSQL
Retsyo_的博客
04-30 3982
本文参考了和，请配合使用。以下更改均基于。
Nacos2.1.2适配达梦8数据库
10-21
nacos2.1.2修复上一个版本中注册服务及配置无分页功能 增加国产数据库达梦8的适配 需在conf/application.properties 文件中更新数据库配置，配置如下： db.jdbcDriverName=dm.jdbc.driver.DmDriver db.url.0=jdbc:dm://127.0.0.1:5236
Nacos2.2.0适配DM8建表ddl语句
weixin_45726578的博客
03-29 549
【代码】Nacos2.2.0适配DM8建表ddl语句。
nacos 外置mysql数据库操作（docker 环境）
最新发布
kzf_studyhard的博客
03-29 982
详解如何将mysql作为nacos的外置数据库
Nacos数据库建表语句
ordinary_eagle的博客
07-04 363
Nacos建表语句
【Nacos2.2.0适配达梦DM8数据源】
weixin_45726578的博客
03-29 2112
Nacos2.2.0适配达梦DM8数据源 Nacos 从 2.2.0 版本开始,可通过 SPI 机制注入多数据源实现插件,并在引入对应数据源实现后,便可在 Nacos 启动时通过读取 application.properties 配置文件中 spring.datasource.platform 配置项选择加载对应多数据源插件. Nacos 官方默认实现 MySQL、Derby ，其他类型数据库接入需要参考下文自己扩展。 一、Nacos官方文档 Nacos整体介绍可看Nacos官方文档 二、实现步骤 下面
Nacos适配oracle11g-建表ddl语句
小蜗牛的博客
06-21 929
Nacos适配oracle11g-建表ddl语句
nacos 适配 oracle 11g版本 ，附带oracle 脚本，亲测可用
02-01
例如，可能有一个名为`nacos-schema.sql`的文件，包含了创建表的语句。 3. **安全考虑**： - 在生产环境中，建议对Nacos的数据库连接信息进行加密处理，避免明文存储敏感信息。 - 定期备份Nacos的数据，以防意外...
nacos2.2.3配置oracle源码
10-18
7. **适配Oracle特性**：由于Oracle数据库的特性和SQL语法可能与默认的MySQL有所不同，你可能需要调整Nacos的一些内置SQL语句以适应Oracle。这通常涉及读取和写入Nacos内部表的操作。 8. **监控和优化**：为了确保...
nacos2.2.3 适配南大通用数据库Gbase 8S
08-10
在2.2.3版本中，它已经具备了对多种数据库的兼容性，包括MySQL、Oracle等，而现在我们探讨的是如何扩展其适配范围，增加对Gbase 8S的支持。 Gbase 8S数据库，基于MPP（大规模并行处理）架构，擅长处理海量数据的...
nacos-mysql.sql
02-05
nacos默认使用嵌入式数据库实现数据的存储，若想使用外部mysql存储nacos数据，需进行文件配置，此文件为生成nacos的数据库表的脚本。
nacos适配oracle数据库
03-01
1.nacos服务，适配oracle数据库11g。 2.提供nacos，oracle的创建nacos数据库脚本。 3.nacos-dm/conf/nacos-oracle-11g.sql文件。 4.nacos版本1.4.2
数据库建表操作SQL语句大全
01-28
数据库建表操作SQL语句大全，对sql有初步的了解，适合新手初步学习
nacos2.0.2版本依赖数据库sql脚本
07-17
nacos2.0.2版本依赖数据库sql脚本
nacos-dm.zip
04-01
NACOS集成达梦数据库
【Nacos2.1.1适配瀚高数据库建表ddl语句】
weixin_45726578的博客
04-21 500
【代码】【Nacos2.1.1适配瀚高数据库建表ddl语句】
Nacos
qq_40298175的博客
10-28 8986
一：微服务 1.0：单体架构 MVC架构，分层开发，所有的功能都在一个系统里面 优点： 1：部署简单: 由于是完整的结构体，可以直接部署在一个服务器上即可。 2：技术单一: 项目不需要复杂的技术栈，往往一套熟悉的技术栈就可以完成开发。 3：用人成本低: 单个程序员可以完成业务接口到数据库的整个流程。 缺点： 1：系统启动慢， 一个进程包含了所有的业务逻辑，涉及到的启动模块过多，导致系统的启动、重启时间周期过长; 2：系统错误隔离性差、可用性差，任何一个模块的错误均可能造成整个系统的宕机; 3：可伸缩性
nacos2.1集成达梦数据库DM8
qq_38618691的博客
10-08 2411
1、下载源码 git clone https://github.com/alibaba/nacos.git 2、主pom.xml添加 达梦8的JDBC驱动类库的 声明 <dependencyManagement> <dependencies> <dependency> <groupId>com.dameng</groupId> <a
nacos配置mysql建表语句
09-01
nacos配置mysql的建表语句可以在使用mysql作为数据源时使用。根据引用[2]中提供的资料，nacos数据库的建表语句如下： CREATE TABLE `config_info` ( `data_id` varchar(255) NOT NULL, `group_id` varchar(32) NOT NULL, `content` mediumtext NOT NULL, `md5` varchar(32) DEFAULT NULL, `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP, `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `src_user` varchar(64) DEFAULT NULL, `src_ip` varchar(64) DEFAULT NULL, `app_name` varchar(128) DEFAULT NULL, `tenant_id` varchar(32) DEFAULT NULL, PRIMARY KEY (`data_id`,`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 这是nacos中用于存储配置信息的表结构。你可以在mysql中执行以上建表语句来创建nacos的配置信息表。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *3* [Mysql表结构转Postgresql建表语句快速操作](https://blog.csdn.net/qq_42105629/article/details/123526928)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *2* [NACOS以MySQL为数据源的SQL导入文件](https://download.csdn.net/download/AlexanderRon/84270909)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值