/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = config_info */
/******************************************/
CREATE TABLE config_info (
id number(20) NOT NULL,
data_id varchar2(255) NOT NULL,
group_id varchar2(255) DEFAULT NULL,
content varchar2(4000) NOT NULL ,
md5 varchar2(32) DEFAULT NULL ,
gmt_create timestamp DEFAULT sysdate ,
gmt_modified timestamp DEFAULT sysdate ,
src_user varchar2(4000) ,
src_ip varchar2(50) DEFAULT NULL ,
app_name varchar2(128) DEFAULT NULL,
tenant_id varchar2(128) DEFAULT '' ,
c_desc varchar2(256) DEFAULT NULL,
c_use varchar2(64) DEFAULT NULL,
effect varchar2(64) DEFAULT NULL,
type varchar2(64) DEFAULT NULL,
c_schema varchar2(4000),
PRIMARY KEY (id),
CONSTRAINT uk_configinfo_datagrouptenant UNIQUE (data_id,group_id,tenant_id)
) ;
create sequence SEQ_CONFIG_INFO maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = config_info_aggr */
/******************************************/
CREATE TABLE config_info_aggr (
id number(20) NOT NULL ,
data_id varchar2(255) NOT NULL,
group_id varchar2(255) NOT NULL ,
datum_id varchar2(255) NOT NULL ,
content varchar2(4000) NOT NULL ,
gmt_modified timestamp NOT NULL ,
app_name varchar2(128) DEFAULT NULL,
tenant_id varchar2(128) DEFAULT '',
PRIMARY KEY (id),
CONSTRAINT uk_config_datagrouptenantdatum UNIQUE (data_id,group_id,tenant_id,datum_id)
) ;
create sequence SEQ_CONFIG_INFO_AGGR maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = config_info_beta */
/******************************************/
CREATE TABLE config_info_beta (
id number(20) NOT NULL,
data_id varchar2(255) NOT NULL,
group_id varchar2(128) NOT NULL,
app_name varchar2(128) DEFAULT NULL,
content varchar2(4000) NOT NULL ,
beta_ips varchar2(1024) DEFAULT NULL ,
md5 varchar2(32) DEFAULT NULL,
gmt_create timestamp DEFAULT sysdate,
gmt_modified timestamp DEFAULT sysdate ,
src_user varchar2(4000),
src_ip varchar2(50) DEFAULT NULL ,
tenant_id varchar2(128) DEFAULT '' ,
PRIMARY KEY (id),
CONSTRAINT uk_configin_datagrouptenant UNIQUE (data_id,group_id,tenant_id)
) ;
create sequence SEQ_CONFIG_INFO_BETA maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = config_info_tag */
/******************************************/
CREATE TABLE config_info_tag (
id number(20) NOT NULL,
data_id varchar2(255) NOT NULL ,
group_id varchar2(128) NOT NULL ,
tenant_id varchar2(128) DEFAULT '' ,
tag_id varchar2(128) NOT NULL ,
app_name varchar2(128) DEFAULT NULL ,
content varchar2(4000) NOT NULL ,
md5 varchar2(32) DEFAULT NULL,
gmt_create timestamp DEFAULT sysdate ,
gmt_modified timestamp DEFAULT sysdate ,
src_user varchar2(4000),
src_ip varchar2(50) DEFAULT NULL ,
PRIMARY KEY (id),
CONSTRAINT uk_configi_datagrouptenanttag UNIQUE (data_id,group_id,tenant_id,tag_id)
) ;
create sequence SEQ_CONFIG_INFO_TAG maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = config_tags_relation */
/******************************************/
CREATE TABLE config_tags_relation (
id number(20) NOT NULL,
tag_name varchar2(128) NOT NULL ,
tag_type varchar2(64) DEFAULT NULL ,
data_id varchar2(255) NOT NULL ,
group_id varchar2(128) NOT NULL ,
tenant_id varchar2(128) DEFAULT '',
nid number(20) NOT NULL,
PRIMARY KEY (nid),
CONSTRAINT uk_config_configidtag UNIQUE (id,tag_name,tag_type)
) ;
CREATE INDEX idx_tenant_id ON config_tags_relation (tenant_id);
create sequence SEQ_CONFIG_TAGS_RELATION maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = group_capacity */
/******************************************/
CREATE TABLE group_capacity (
id number(20) NOT NULL ,
group_id varchar2(128) DEFAULT '' ,
quota number(10) DEFAULT '0' ,
usage number(10) DEFAULT '0' ,
max_size number(10) DEFAULT '0' ,
max_aggr_count number(10) DEFAULT '0' ,
max_aggr_size number(10) DEFAULT '0' ,
max_history_count number(10) DEFAULT '0' ,
gmt_create timestamp DEFAULT sysdate,
gmt_modified timestamp DEFAULT sysdate ,
PRIMARY KEY (id),
CONSTRAINT uk_group_id UNIQUE (group_id)
);
create sequence SEQ_CAPACITY_ENTITY maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = his_config_info */
/******************************************/
CREATE TABLE his_config_info (
id number(20) NOT NULL,
nid number(20) NOT NULL ,
data_id varchar2(255) NOT NULL,
group_id varchar2(128) NOT NULL,
app_name varchar2(128) DEFAULT NULL,
content varchar2(4000) NOT NULL,
md5 varchar2(32) DEFAULT NULL,
gmt_create timestamp DEFAULT sysdate,
gmt_modified timestamp DEFAULT sysdate,
src_user varchar2(4000),
src_ip varchar2(50) DEFAULT NULL,
op_type char(10) DEFAULT NULL,
tenant_id varchar2(128) DEFAULT '' ,
PRIMARY KEY (nid)
);
CREATE INDEX idx_gmt_create ON his_config_info (gmt_create);
CREATE INDEX idx_gmt_modified ON his_config_info (gmt_modified);
CREATE INDEX idx_did ON his_config_info (data_id);
create sequence SEQ_HIS_CONFIG_INFO maxvalue 999999999999;
/******************************************/
/* 数据库全名 = nacos_config */
/* 表名称 = tenant_capacity */
/******************************************/
CREATE TABLE tenant_capacity (
id number(20) NOT NULL ,
tenant_id varchar2(128) DEFAULT '' ,
quota number(10) DEFAULT '0' ,
usage number(10) DEFAULT '0' ,
max_size number(10) DEFAULT '0' ,
max_aggr_count number(10) DEFAULT '0',
max_aggr_size number(10) DEFAULT '0' ,
max_history_count number(10) DEFAULT '0' ,
gmt_create timestamp DEFAULT sysdate,
gmt_modified timestamp DEFAULT sysdate ,
PRIMARY KEY (id),
CONSTRAINT uk_tenant_id UNIQUE (tenant_id)
) ;
CREATE TABLE tenant_info (
id number(20) NOT NULL ,
kp varchar2(128) NOT NULL ,
tenant_id varchar2(128) default '' ,
tenant_name varchar2(128) default '' ,
tenant_desc varchar2(256) DEFAULT NULL ,
create_source varchar2(32) DEFAULT NULL ,
gmt_create number(20) NOT NULL ,
gmt_modified number(20) NOT NULL ,
PRIMARY KEY (id),
CONSTRAINT uk_tenant_info_kptenantid UNIQUE (kp,tenant_id)
) ;
CREATE INDEX idx_info_tenant_id ON tenant_info (tenant_id);
create sequence SEQ_TENANT_INFO maxvalue 999999999999;
CREATE TABLE users (
username varchar2(50) NOT NULL PRIMARY KEY,
password varchar2(500) NOT NULL,
enabled char(1) NOT NULL
);
CREATE TABLE roles (
username varchar2(50) NOT NULL,
role varchar2(50) NOT NULL,
CONSTRAINT idx_user_role UNIQUE (username,role)
);
CREATE TABLE permissions (
role varchar2(50) NOT NULL,
resources varchar2(255) NOT NULL,
action varchar2(8) NOT NULL,
CONSTRAINT uk_role_permission UNIQUE (role,resources,action)
);
INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', '1');
INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
Nacos适配oracle11g-建表ddl语句
最新推荐文章于 2024-07-04 11:26:03 发布