CREATE TABLE nacos.config_info (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_config_info_id' :: regclass
) ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
255
) COLLATE pg_catalog."default" ,
content text NOT NULL COLLATE pg_catalog."default" ,
md5 character varying (
32
) COLLATE pg_catalog."default" ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
src_user text COLLATE pg_catalog."default" ,
src_ip character varying (
20
) COLLATE pg_catalog."default" ,
app_name character varying (
128
) COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
c_desc character varying (
256
) COLLATE pg_catalog."default" ,
c_use character varying (
64
) COLLATE pg_catalog."default" ,
effect character varying (
64
) COLLATE pg_catalog."default" ,
type character varying (
64
) COLLATE pg_catalog."default" ,
c_schema text COLLATE pg_catalog."default" ,
encrypted_data_key text COLLATE pg_catalog."default" ,
PRIMARY KEY (
id
) ,
CONSTRAINT config_info_uk_configinfo_datagrouptenant UNIQUE (
tenant_id ,
group_id ,
data_id
)
) ;
ALTER TABLE nacos.config_info OWNER TO sysdba ;
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 '租户字段' ;
COMMENT ON
TABLE nacos.config_info IS 'config_info' ;
CREATE TABLE nacos.config_info_aggr (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_config_info_aggr_id' :: regclass
) ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
datum_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
content text NOT NULL COLLATE pg_catalog."default" ,
gmt_modified timestamp without time zone NOT NULL ,
app_name character varying (
128
) COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
PRIMARY KEY (
id
) ,
CONSTRAINT config_info_aggr_uk_configinfoaggr_datagrouptenantdatum UNIQUE (
tenant_id ,
group_id ,
data_id ,
datum_id
)
) ;
ALTER TABLE nacos.config_info_aggr OWNER TO sysdba ;
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 '租户字段' ;
COMMENT ON
TABLE nacos.config_info_aggr IS '增加租户字段' ;
CREATE TABLE nacos.config_info_beta (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_config_info_beta_id' :: regclass
) ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
app_name character varying (
128
) COLLATE pg_catalog."default" ,
content text NOT NULL COLLATE pg_catalog."default" ,
beta_ips character varying (
1024
) COLLATE pg_catalog."default" ,
md5 character varying (
32
) COLLATE pg_catalog."default" ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
src_user text COLLATE pg_catalog."default" ,
src_ip character varying (
20
) COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
encrypted_data_key text COLLATE pg_catalog."default" ,
PRIMARY KEY (
id
) ,
CONSTRAINT config_info_beta_uk_configinfobeta_datagrouptenant UNIQUE (
tenant_id ,
group_id ,
data_id
)
) ;
ALTER TABLE nacos.config_info_beta OWNER TO sysdba ;
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 '租户字段' ;
COMMENT ON
TABLE nacos.config_info_beta IS 'config_info_beta' ;
CREATE TABLE nacos.config_info_tag (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_config_info_tag_id' :: regclass
) ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
tag_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
app_name character varying (
128
) COLLATE pg_catalog."default" ,
content text NOT NULL COLLATE pg_catalog."default" ,
md5 character varying (
32
) COLLATE pg_catalog."default" ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
src_user text COLLATE pg_catalog."default" ,
src_ip character varying (
20
) COLLATE pg_catalog."default" ,
PRIMARY KEY (
id
) ,
CONSTRAINT config_info_tag_uk_configinfotag_datagrouptenanttag UNIQUE (
tenant_id ,
group_id ,
data_id ,
tag_id
)
) ;
ALTER TABLE nacos.config_info_tag OWNER TO sysdba ;
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' ;
COMMENT ON
TABLE nacos.config_info_tag IS 'config_info_tag' ;
CREATE TABLE nacos.config_tags_relation (
id bigint NOT NULL ,
tag_name character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
tag_type character varying (
64
) COLLATE pg_catalog."default" ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
nid bigint NOT NULL DEFAULT nextval (
'nacos.seq_config_tags_relation_nid' :: regclass
) ,
PRIMARY KEY (
nid
) ,
CONSTRAINT config_tags_relation_uk_configtagrelation_configidtag UNIQUE (
tag_type ,
tag_name ,
id
)
) ;
ALTER TABLE nacos.config_tags_relation OWNER TO sysdba ;
CREATE INDEX config_tags_relationidx_tenant_id ON
nacos.config_tags_relation USING btree (
tenant_id
) TABLESPACE pg_default ;
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' ;
COMMENT ON
TABLE nacos.config_tags_relation IS 'config_tag_relation' ;
CREATE TABLE nacos.group_capacity (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_group_capacity_id' :: regclass
) ,
group_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
quota integer NOT NULL DEFAULT 0 ,
usage integer NOT NULL DEFAULT 0 ,
max_size integer NOT NULL DEFAULT 0 ,
max_aggr_count integer NOT NULL DEFAULT 0 ,
max_aggr_size integer NOT NULL DEFAULT 0 ,
max_history_count integer NOT NULL DEFAULT 0 ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
PRIMARY KEY (
id
) ,
CONSTRAINT group_capacity_uk_group_id UNIQUE (
group_id
)
) ;
ALTER TABLE nacos.group_capacity OWNER TO sysdba ;
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 '修改时间' ;
COMMENT ON
TABLE nacos.group_capacity IS '集群、各Group容量信息表' ;
CREATE TABLE nacos.his_config_info (
id bigint NOT NULL ,
nid bigint NOT NULL DEFAULT nextval (
'nacos.seq_his_config_info_nid' :: regclass
) ,
data_id character varying (
255
) NOT NULL COLLATE pg_catalog."default" ,
group_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
app_name character varying (
128
) COLLATE pg_catalog."default" ,
content text NOT NULL COLLATE pg_catalog."default" ,
md5 character varying (
32
) COLLATE pg_catalog."default" ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
src_user text COLLATE pg_catalog."default" ,
src_ip character varying (
20
) COLLATE pg_catalog."default" ,
op_type character (
10
) COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
encrypted_data_key text COLLATE pg_catalog."default" ,
PRIMARY KEY (
nid
)
) ;
ALTER TABLE nacos.his_config_info OWNER TO sysdba ;
CREATE INDEX his_config_infoidx_gmt_create ON
nacos.his_config_info USING btree (
gmt_create
) TABLESPACE pg_default ;
CREATE INDEX his_config_infoidx_gmt_modified ON
nacos.his_config_info USING btree (
gmt_modified
) TABLESPACE pg_default ;
CREATE INDEX his_config_infoidx_did ON
nacos.his_config_info USING btree (
data_id
) TABLESPACE pg_default ;
COMMENT ON
COLUMN nacos.his_config_info.app_name IS 'app_name' ;
COMMENT ON
COLUMN nacos.his_config_info.tenant_id IS '租户字段' ;
COMMENT ON
TABLE nacos.his_config_info IS '多租户改造' ;
CREATE TABLE nacos.permissions (
role character varying (
50
) NOT NULL COLLATE pg_catalog."default" ,
resource character varying (
512
) NOT NULL COLLATE pg_catalog."default" ,
action character varying (
8
) NOT NULL COLLATE pg_catalog."default" ,
CONSTRAINT permissions_uk_role_permission UNIQUE (
action ,
resource ,
role
)
) ;
ALTER TABLE nacos.permissions OWNER TO sysdba ;
CREATE TABLE nacos.roles (
username character varying (
50
) NOT NULL COLLATE pg_catalog."default" ,
role character varying (
50
) NOT NULL COLLATE pg_catalog."default" ,
CONSTRAINT roles_uk_username_role UNIQUE (
role ,
username
)
) ;
ALTER TABLE nacos.roles OWNER TO sysdba ;
CREATE TABLE nacos.tenant_capacity (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_tenant_capacity_id' :: regclass
) ,
tenant_id character varying (
128
) NOT NULL COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
quota integer NOT NULL DEFAULT 0 ,
usage integer NOT NULL DEFAULT 0 ,
max_size integer NOT NULL DEFAULT 0 ,
max_aggr_count integer NOT NULL DEFAULT 0 ,
max_aggr_size integer NOT NULL DEFAULT 0 ,
max_history_count integer NOT NULL DEFAULT 0 ,
gmt_create timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
gmt_modified timestamp without time zone NOT NULL DEFAULT '2010-05-05 00:00:00' :: timestamp without time zone ,
PRIMARY KEY (
id
) ,
CONSTRAINT tenant_capacity_uk_tenant_id UNIQUE (
tenant_id
)
) ;
ALTER TABLE nacos.tenant_capacity OWNER TO sysdba ;
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 '修改时间' ;
COMMENT ON
TABLE nacos.tenant_capacity IS '租户容量信息表' ;
CREATE TABLE nacos.tenant_info (
id bigint NOT NULL DEFAULT nextval (
'nacos.seq_tenant_info_id' :: regclass
) ,
kp character varying (
128
) NOT NULL COLLATE pg_catalog."default" ,
tenant_id character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
tenant_name character varying (
128
) COLLATE pg_catalog."default" DEFAULT '' :: character varying ,
tenant_desc character varying (
256
) COLLATE pg_catalog."default" ,
create_source character varying (
32
) COLLATE pg_catalog."default" ,
gmt_create bigint NOT NULL ,
gmt_modified bigint NOT NULL ,
PRIMARY KEY (
id
) ,
CONSTRAINT tenant_info_uk_tenant_info_kptenantid UNIQUE (
tenant_id ,
kp
)
) ;
ALTER TABLE nacos.tenant_info OWNER TO sysdba ;
CREATE INDEX tenant_infoidx_tenant_id ON
nacos.tenant_info USING btree (
tenant_id
) TABLESPACE pg_default ;
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 '修改时间' ;
COMMENT ON
TABLE nacos.tenant_info IS 'tenant_info' ;
CREATE TABLE nacos.users (
username character varying (
50
) NOT NULL COLLATE pg_catalog."default" ,
password character varying (
500
) NOT NULL COLLATE pg_catalog."default" ,
enabled smallint NOT NULL ,
PRIMARY KEY (
username
)
) ;
ALTER TABLE nacos.users OWNER TO sysdba ;
insert into nacos.users(username,password,enabled) values ('nacos','$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu','1');
insert into nacos.roles(username,role) values ('nacos','ROLE_ADMIN');