nacos2.3.0 接入pgsql或其他数据库

  首先尝试使用官方插件进行扩展，各种报错后放弃，不如本身修改源码吧。
一、官方解决方案

   1、nocos 文档地址：Nacos 配置中心简介, Nacos 是什么 | Nacos 官网
  2、官方解答：nacos支持postgresql数据库吗 | Nacos 官网
3、源码下载地址：Release 2.3.0 (Nov 30, 2023) · alibaba/nacos · GitHub
  4、Nacos的数据库插件仓库：nacos-plugin/nacos-datasource-plugin-ext at develop · nacos-group/nacos-plugin · GitHub
  按照官方的方案，下载插件后，更改pom文件中nacos的版本，之后将插件打成jar包，放到nacos的plugins目录下，更改配置，启动后各种报错找不到方法，遂放弃。
二、更改源码

1、在项目根(nacos-all)下的pom.xml文件中添加如下依靠：
  

1. <!--版本可修改-->
2. <postgresql.version>42.3.8</postgresql.version>

复制代码

1. <dependency>
2.     <groupId>org.postgresql</groupId>
3.     <artifactId>postgresql</artifactId>
4.     <version>${postgresql.version}</version>
5. </dependency>

复制代码

2、在项目的nacos-config-plugin、nacos-persistence模块的pom.xml文件中添加如下依靠:
  

1. <dependency>
2.     <groupId>org.postgresql</groupId>
3.     <artifactId>postgresql</artifactId>
4. </dependency>

复制代码

3、在项目的nacos-plugin模块的nacos-datasource-plugin模块com.alibaba.nacos.plugin.datasource.impl包下新建一个包,名为postgresql,拷贝同级包mysql下的所有文件到postgresql包下，修改类名和文件名为xxxByPostgresql，如图

4、将这几个类中LIMIT ?,?的写法为OFFSET ? LIMIT ? 如图

5、在改项目resource目录下，找到com.alibaba.nacos.plugin.datasource.mapper.Mapper文件，在背面追加：
  

1. com.alibaba.nacos.plugin.datasource.impl.postgresql.ConfigInfoAggrMapperByPostgresql
2. com.alibaba.nacos.plugin.datasource.impl.postgresql.ConfigInfoBetaMapperByPostgresql
3. com.alibaba.nacos.plugin.datasource.impl.postgresql.ConfigInfoMapperByPostgresql
4. com.alibaba.nacos.plugin.datasource.impl.postgresql.ConfigInfoTagMapperByPostgresql
5. com.alibaba.nacos.plugin.datasource.impl.postgresql.ConfigTagsRelationMapperByPostgresql
6. com.alibaba.nacos.plugin.datasource.impl.postgresql.HistoryConfigInfoMapperByPostgresql
7. com.alibaba.nacos.plugin.datasource.impl.postgresql.TenantInfoMapperByPostgresql
8. com.alibaba.nacos.plugin.datasource.impl.postgresql.TenantCapacityMapperByPostgresql
9. com.alibaba.nacos.plugin.datasource.impl.postgresql.GroupCapacityMapperByPostgresql

复制代码

如图：

6、在DataSourceConstant类中增加pgsql的常量

1.     public static final String POSTGRESQL = "postgresql";

复制代码

7、persistence模块，修改PersistenceConstant

1.     public static final String POSTGRESQL = "postgresql";

复制代码

修改ExternalDataSourceProperties类

代码如下，直接复制粘贴即可：

1. /*
2. * Copyright 1999-2023 Alibaba Group Holding Ltd.
3. *
4. * Licensed under the Apache License, Version 2.0 (the "License");
5. * you may not use this file except in compliance with the License.
6. * You may obtain a copy of the License at
7. *
8. *      http://www.apache.org/licenses/LICENSE-2.0
9. *
10. * Unless required by applicable law or agreed to in writing, software
11. * distributed under the License is distributed on an "AS IS" BASIS,
12. * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13. * See the License for the specific language governing permissions and
14. * limitations under the License.
15. */
17. package com.alibaba.nacos.persistence.datasource;
19. import com.alibaba.nacos.common.utils.CollectionUtils;
20. import com.alibaba.nacos.common.utils.Preconditions;
21. import com.alibaba.nacos.common.utils.StringUtils;
22. import com.zaxxer.hikari.HikariDataSource;
23. import org.springframework.boot.context.properties.bind.Bindable;
24. import org.springframework.boot.context.properties.bind.Binder;
25. import org.springframework.core.env.Environment;
27. import java.util.ArrayList;
28. import java.util.List;
29. import java.util.Objects;
31. import static com.alibaba.nacos.common.utils.CollectionUtils.getOrDefault;
33. /**
34. * Properties of external DataSource.
35. *
36. * @author Nacos
37. */
38. public class ExternalDataSourceProperties {
39.    
40.     private static final String JDBC_DRIVER_NAME = "com.mysql.cj.jdbc.Driver";
42.     private static final String TEST_QUERY = "SELECT 1";
43.    
44.     private Integer num;
45.    
46.     private List<String> url = new ArrayList<>();
47.    
48.     private List<String> user = new ArrayList<>();
49.    
50.     private List<String> password = new ArrayList<>();
51.     private String jdbcDriverName;
53.     public void setJdbcDriverName(String jdbcDriverName) {
54.         if (StringUtils.isBlank(jdbcDriverName)) {
55.             this.jdbcDriverName = JDBC_DRIVER_NAME;
56.         } else {
57.             this.jdbcDriverName = jdbcDriverName;
58.         }
59.     }
60.    
61.     public void setNum(Integer num) {
62.         this.num = num;
63.     }
64.    
65.     public void setUrl(List<String> url) {
66.         this.url = url;
67.     }
68.    
69.     public void setUser(List<String> user) {
70.         this.user = user;
71.     }
72.    
73.     public void setPassword(List<String> password) {
74.         this.password = password;
75.     }
77.     /**
78.      * Build serveral HikariDataSource.
79.      *
80.      * @param environment {@link Environment}
81.      * @param callback    Callback function when constructing data source
82.      * @return List of {@link HikariDataSource}
83.      */
84.     List<HikariDataSource> build(Environment environment, Callback<HikariDataSource> callback) {
85.         List<HikariDataSource> dataSources = new ArrayList<>();
86.         Binder.get(environment).bind("db", Bindable.ofInstance(this));
87.         Preconditions.checkArgument(Objects.nonNull(num), "db.num is null");
88.         Preconditions.checkArgument(CollectionUtils.isNotEmpty(user), "db.user or db.user.[index] is null");
89.         Preconditions.checkArgument(CollectionUtils.isNotEmpty(password), "db.password or db.password.[index] is null");
90.         for (int index = 0; index < num; index++) {
91.             int currentSize = index + 1;
92.             Preconditions.checkArgument(url.size() >= currentSize, "db.url.%s is null", index);
93.             DataSourcePoolProperties poolProperties = DataSourcePoolProperties.build(environment);
94.             if (StringUtils.isEmpty(poolProperties.getDataSource().getDriverClassName())) {
95.                 poolProperties.setDriverClassName(jdbcDriverName);
96.             }
97.             poolProperties.setJdbcUrl(url.get(index).trim());
98.             poolProperties.setUsername(getOrDefault(user, index, user.get(0)).trim());
99.             poolProperties.setPassword(getOrDefault(password, index, password.get(0)).trim());
100.             HikariDataSource ds = poolProperties.getDataSource();
101.             if (StringUtils.isEmpty(ds.getConnectionTestQuery())) {
102.                 ds.setConnectionTestQuery(TEST_QUERY);
103.             }
104.             
105.             dataSources.add(ds);
106.             callback.accept(ds);
107.         }
108.         Preconditions.checkArgument(CollectionUtils.isNotEmpty(dataSources), "no datasource available");
109.         return dataSources;
110.     }
111.    
112.     interface Callback<D> {
113.         
114.         /**
115.          * Perform custom logic.
116.          *
117.          * @param datasource dataSource.
118.          */
119.         void accept(D datasource);
120.     }
121. }

复制代码

8、plugins-defualt-impl模块，子模块nacos-default-auth-plugin中，修改AuthPageConstant，加入以下代码

1.     public static final String OFFSET_LIMIT = "OFFSET ? LIMIT ?";

复制代码

persistence.handler.support中新增PostgreSqlPageHandlerAdapter类，如图：

代码如下：

1. package com.alibaba.nacos.plugin.auth.impl.persistence.handler.support;
3. import com.alibaba.nacos.config.server.service.dump.DumpService;
4. import com.alibaba.nacos.persistence.constants.PersistenceConstant;
5. import com.alibaba.nacos.plugin.auth.impl.constant.AuthPageConstant;
6. import com.alibaba.nacos.plugin.auth.impl.model.OffsetFetchResult;
7. import com.alibaba.nacos.plugin.auth.impl.persistence.handler.PageHandlerAdapter;
8. import org.slf4j.Logger;
9. import org.slf4j.LoggerFactory;
11. import java.util.ArrayList;
12. import java.util.Arrays;
13. import java.util.List;
15. /**
16. * @author w
17. */
18. public class PostgreSqlPageHandlerAdapter implements PageHandlerAdapter {
20.     @Override
21.     public boolean supports(String dataSourceType) {
22.         return PersistenceConstant.POSTGRESQL.equals(dataSourceType);
23.     }
25.     @Override
26.     public OffsetFetchResult addOffsetAndFetchNext(String fetchSql, Object[] arg, int pageNo, int pageSize) {
27.         if (!fetchSql.contains(AuthPageConstant.LIMIT)) {
28.             fetchSql += " " + AuthPageConstant.OFFSET_LIMIT;
29.             List<Object> newArgsList = new ArrayList<>(Arrays.asList(arg));
30.             newArgsList.add((pageNo - 1) * pageSize);
31.             newArgsList.add(pageSize);
33.             Object[] newArgs = newArgsList.toArray(new Object[newArgsList.size()]);
34.             return new OffsetFetchResult(fetchSql, newArgs);
35.         }
37.         return new OffsetFetchResult(fetchSql, arg);
38.     }
39. }

复制代码

在 PageHandlerAdapterFactory 类中加入以下代码：

9、终极，执行打包命令
   mvn -Prelease-nacos clean install -Dmaven.test.skip=true -Dcheckstyle.skip=true -Dpmd.skip=true -Drat.skip=true -U
  根据需求，在 nacos-2.3.0\distribution\target 目录下找到打好的包

修改配置文件，记得将数据库ip、库名、schema名称、用户名、密码配置改成本身的：

1. spring.datasource.platform=postgresql
2. db.num=1
3. db.url.0=jdbc:postgresql://xxxx:5432/nacos?currentSchema=public&reWriteBatchedInserts=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
4. db.user.0=xxxx
5. db.password.0=xxxx
6. db.pool.config.driverClassName=org.postgresql.Driver
7. nacos.core.auth.plugin.nacos.token.secret.key=SecretKey012345678901234567890123456789012345678901234567890123456789
10. nacos.core.auth.enabled=true
11. nacos.core.auth.caching.enabled=false
12. nacos.core.auth.server.identity.key=nacos
13. nacos.core.auth.server.identity.value=nacos

复制代码

终极，祝各人乐成！！！
附上pg数据库脚本：

1. /*
2. * Copyright 1999-2018 Alibaba Group Holding Ltd.
3. *
4. * Licensed under the Apache License, Version 2.0 (the "License");
5. * you may not use this file except in compliance with the License.
6. * You may obtain a copy of the License at
7. *
8. *      http://www.apache.org/licenses/LICENSE-2.0
9. *
10. * Unless required by applicable law or agreed to in writing, software
11. * distributed under the License is distributed on an "AS IS" BASIS,
12. * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13. * See the License for the specific language governing permissions and
14. * limitations under the License.
15. */
17. -- ----------------------------
18. -- Table structure for config_info
19. -- ----------------------------
20. DROP TABLE IF EXISTS "config_info";
21. CREATE TABLE "config_info" (
22.   "id" bigserial NOT NULL,
23.   "data_id" varchar(255)  NOT NULL,
24.   "group_id" varchar(255) ,
25.   "content" text  NOT NULL,
26.   "md5" varchar(32) ,
27.   "gmt_create" timestamp(6) NOT NULL,
28.   "gmt_modified" timestamp(6) NOT NULL,
29.   "src_user" text ,
30.   "src_ip" varchar(20) ,
31.   "app_name" varchar(128) ,
32.   "tenant_id" varchar(128) ,
33.   "c_desc" varchar(256) ,
34.   "c_use" varchar(64) ,
35.   "effect" varchar(64) ,
36.   "type" varchar(64) ,
37.   "c_schema" text ,
38.   "encrypted_data_key" text  NOT NULL
39. )
40. ;
42. COMMENT ON COLUMN "config_info"."id" IS 'id';
43. COMMENT ON COLUMN "config_info"."data_id" IS 'data_id';
44. COMMENT ON COLUMN "config_info"."content" IS 'content';
45. COMMENT ON COLUMN "config_info"."md5" IS 'md5';
46. COMMENT ON COLUMN "config_info"."gmt_create" IS '创建时间';
47. COMMENT ON COLUMN "config_info"."gmt_modified" IS '修改时间';
48. COMMENT ON COLUMN "config_info"."src_user" IS 'source user';
49. COMMENT ON COLUMN "config_info"."src_ip" IS 'source ip';
50. COMMENT ON COLUMN "config_info"."tenant_id" IS '租户字段';
51. COMMENT ON COLUMN "config_info"."encrypted_data_key" IS '秘钥';
52. COMMENT ON TABLE "config_info" IS 'config_info';
55. -- ----------------------------
56. -- Table structure for config_info_aggr
57. -- ----------------------------
58. DROP TABLE IF EXISTS "config_info_aggr";
59. CREATE TABLE "config_info_aggr" (
60.   "id" bigserial NOT NULL,
61.   "data_id" varchar(255)  NOT NULL,
62.   "group_id" varchar(255)  NOT NULL,
63.   "datum_id" varchar(255)  NOT NULL,
64.   "content" text  NOT NULL,
65.   "gmt_modified" timestamp(6) NOT NULL,
66.   "app_name" varchar(128) ,
67.   "tenant_id" varchar(128)
68. )
69. ;
70. COMMENT ON COLUMN "config_info_aggr"."id" IS 'id';
71. COMMENT ON COLUMN "config_info_aggr"."data_id" IS 'data_id';
72. COMMENT ON COLUMN "config_info_aggr"."group_id" IS 'group_id';
73. COMMENT ON COLUMN "config_info_aggr"."datum_id" IS 'datum_id';
74. COMMENT ON COLUMN "config_info_aggr"."content" IS '内容';
75. COMMENT ON COLUMN "config_info_aggr"."gmt_modified" IS '修改时间';
76. COMMENT ON COLUMN "config_info_aggr"."tenant_id" IS '租户字段';
77. COMMENT ON TABLE "config_info_aggr" IS '增加租户字段';
79. -- ----------------------------
80. -- Records of config_info_aggr
81. -- ----------------------------
82. BEGIN;
83. COMMIT;
85. -- ----------------------------
86. -- Table structure for config_info_beta
87. -- ----------------------------
88. DROP TABLE IF EXISTS "config_info_beta";
89. CREATE TABLE "config_info_beta" (
90.   "id" bigserial NOT NULL,
91.   "data_id" varchar(255)  NOT NULL,
92.   "group_id" varchar(128)  NOT NULL,
93.   "app_name" varchar(128) ,
94.   "content" text  NOT NULL,
95.   "beta_ips" varchar(1024) ,
96.   "md5" varchar(32) ,
97.   "gmt_create" timestamp(6) NOT NULL,
98.   "gmt_modified" timestamp(6) NOT NULL,
99.   "src_user" text ,
100.   "src_ip" varchar(20) ,
101.   "tenant_id" varchar(128) ,
102.   "encrypted_data_key" text  NOT NULL
103. )
104. ;
105. COMMENT ON COLUMN "config_info_beta"."id" IS 'id';
106. COMMENT ON COLUMN "config_info_beta"."data_id" IS 'data_id';
107. COMMENT ON COLUMN "config_info_beta"."group_id" IS 'group_id';
108. COMMENT ON COLUMN "config_info_beta"."app_name" IS 'app_name';
109. COMMENT ON COLUMN "config_info_beta"."content" IS 'content';
110. COMMENT ON COLUMN "config_info_beta"."beta_ips" IS 'betaIps';
111. COMMENT ON COLUMN "config_info_beta"."md5" IS 'md5';
112. COMMENT ON COLUMN "config_info_beta"."gmt_create" IS '创建时间';
113. COMMENT ON COLUMN "config_info_beta"."gmt_modified" IS '修改时间';
114. COMMENT ON COLUMN "config_info_beta"."src_user" IS 'source user';
115. COMMENT ON COLUMN "config_info_beta"."src_ip" IS 'source ip';
116. COMMENT ON COLUMN "config_info_beta"."tenant_id" IS '租户字段';
117. COMMENT ON COLUMN "config_info_beta"."encrypted_data_key" IS '秘钥';
118. COMMENT ON TABLE "config_info_beta" IS 'config_info_beta';
120. -- ----------------------------
121. -- Records of config_info_beta
122. -- ----------------------------
123. BEGIN;
124. COMMIT;
126. -- ----------------------------
127. -- Table structure for config_info_tag
128. -- ----------------------------
129. DROP TABLE IF EXISTS "config_info_tag";
130. CREATE TABLE "config_info_tag" (
131.   "id" bigserial NOT NULL,
132.   "data_id" varchar(255)  NOT NULL,
133.   "group_id" varchar(128)  NOT NULL,
134.   "tenant_id" varchar(128) ,
135.   "tag_id" varchar(128)  NOT NULL,
136.   "app_name" varchar(128) ,
137.   "content" text  NOT NULL,
138.   "md5" varchar(32) ,
139.   "gmt_create" timestamp(6) NOT NULL,
140.   "gmt_modified" timestamp(6) NOT NULL,
141.   "src_user" text ,
142.   "src_ip" varchar(20)
143. )
144. ;
145. COMMENT ON COLUMN "config_info_tag"."id" IS 'id';
146. COMMENT ON COLUMN "config_info_tag"."data_id" IS 'data_id';
147. COMMENT ON COLUMN "config_info_tag"."group_id" IS 'group_id';
148. COMMENT ON COLUMN "config_info_tag"."tenant_id" IS 'tenant_id';
149. COMMENT ON COLUMN "config_info_tag"."tag_id" IS 'tag_id';
150. COMMENT ON COLUMN "config_info_tag"."app_name" IS 'app_name';
151. COMMENT ON COLUMN "config_info_tag"."content" IS 'content';
152. COMMENT ON COLUMN "config_info_tag"."md5" IS 'md5';
153. COMMENT ON COLUMN "config_info_tag"."gmt_create" IS '创建时间';
154. COMMENT ON COLUMN "config_info_tag"."gmt_modified" IS '修改时间';
155. COMMENT ON COLUMN "config_info_tag"."src_user" IS 'source user';
156. COMMENT ON COLUMN "config_info_tag"."src_ip" IS 'source ip';
157. COMMENT ON TABLE "config_info_tag" IS 'config_info_tag';
159. -- ----------------------------
160. -- Records of config_info_tag
161. -- ----------------------------
162. BEGIN;
163. COMMIT;
165. -- ----------------------------
166. -- Table structure for config_tags_relation
167. -- ----------------------------
168. DROP TABLE IF EXISTS "config_tags_relation";
169. CREATE TABLE "config_tags_relation" (
170.   "id" bigserial NOT NULL,
171.   "tag_name" varchar(128)  NOT NULL,
172.   "tag_type" varchar(64) ,
173.   "data_id" varchar(255)  NOT NULL,
174.   "group_id" varchar(128)  NOT NULL,
175.   "tenant_id" varchar(128) ,
176.   "nid" bigserial NOT NULL
177. )
178. ;
179. COMMENT ON COLUMN "config_tags_relation"."id" IS 'id';
180. COMMENT ON COLUMN "config_tags_relation"."tag_name" IS 'tag_name';
181. COMMENT ON COLUMN "config_tags_relation"."tag_type" IS 'tag_type';
182. COMMENT ON COLUMN "config_tags_relation"."data_id" IS 'data_id';
183. COMMENT ON COLUMN "config_tags_relation"."group_id" IS 'group_id';
184. COMMENT ON COLUMN "config_tags_relation"."tenant_id" IS 'tenant_id';
185. COMMENT ON TABLE "config_tags_relation" IS 'config_tag_relation';
187. -- ----------------------------
188. -- Records of config_tags_relation
189. -- ----------------------------
190. BEGIN;
191. COMMIT;
193. -- ----------------------------
194. -- Table structure for group_capacity
195. -- ----------------------------
196. DROP TABLE IF EXISTS "group_capacity";
197. CREATE TABLE "group_capacity" (
198.   "id" bigserial NOT NULL,
199.   "group_id" varchar(128)  NOT NULL,
200.   "quota" int4 NOT NULL,
201.   "usage" int4 NOT NULL,
202.   "max_size" int4 NOT NULL,
203.   "max_aggr_count" int4 NOT NULL,
204.   "max_aggr_size" int4 NOT NULL,
205.   "max_history_count" int4 NOT NULL,
206.   "gmt_create" timestamp(6) NOT NULL,
207.   "gmt_modified" timestamp(6) NOT NULL
208. )
209. ;
210. COMMENT ON COLUMN "group_capacity"."id" IS '主键ID';
211. COMMENT ON COLUMN "group_capacity"."group_id" IS 'Group ID，空字符表示整个集群';
212. COMMENT ON COLUMN "group_capacity"."quota" IS '配额，0表示使用默认值';
213. COMMENT ON COLUMN "group_capacity"."usage" IS '使用量';
214. COMMENT ON COLUMN "group_capacity"."max_size" IS '单个配置大小上限，单位为字节，0表示使用默认值';
215. COMMENT ON COLUMN "group_capacity"."max_aggr_count" IS '聚合子配置最大个数，，0表示使用默认值';
216. COMMENT ON COLUMN "group_capacity"."max_aggr_size" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';
217. COMMENT ON COLUMN "group_capacity"."max_history_count" IS '最大变更历史数量';
218. COMMENT ON COLUMN "group_capacity"."gmt_create" IS '创建时间';
219. COMMENT ON COLUMN "group_capacity"."gmt_modified" IS '修改时间';
220. COMMENT ON TABLE "group_capacity" IS '集群、各Group容量信息表';
222. -- ----------------------------
223. -- Records of group_capacity
224. -- ----------------------------
225. BEGIN;
226. COMMIT;
228. -- ----------------------------
229. -- Table structure for his_config_info
230. -- ----------------------------
231. DROP TABLE IF EXISTS "his_config_info";
232. CREATE TABLE "his_config_info" (
233.   "id" int8 NOT NULL,
234.   "nid" bigserial NOT NULL,
235.   "data_id" varchar(255)  NOT NULL,
236.   "group_id" varchar(128)  NOT NULL,
237.   "app_name" varchar(128) ,
238.   "content" text  NOT NULL,
239.   "md5" varchar(32) ,
240.   "gmt_create" timestamp(6) NOT NULL  DEFAULT '2010-05-05 00:00:00',
241.   "gmt_modified" timestamp(6) NOT NULL,
242.   "src_user" text ,
243.   "src_ip" varchar(20) ,
244.   "op_type" char(10) ,
245.   "tenant_id" varchar(128) ,
246.   "encrypted_data_key" text  NOT NULL
247. )
248. ;
249. COMMENT ON COLUMN "his_config_info"."app_name" IS 'app_name';
250. COMMENT ON COLUMN "his_config_info"."tenant_id" IS '租户字段';
251. COMMENT ON COLUMN "his_config_info"."encrypted_data_key" IS '秘钥';
252. COMMENT ON TABLE "his_config_info" IS '多租户改造';
255. -- ----------------------------
256. -- Table structure for permissions
257. -- ----------------------------
258. DROP TABLE IF EXISTS "permissions";
259. CREATE TABLE "permissions" (
260.   "role" varchar(50)  NOT NULL,
261.   "resource" varchar(512)  NOT NULL,
262.   "action" varchar(8)  NOT NULL
263. )
264. ;
266. -- ----------------------------
267. -- Records of permissions
268. -- ----------------------------
269. BEGIN;
270. COMMIT;
272. -- ----------------------------
273. -- Table structure for roles
274. -- ----------------------------
275. DROP TABLE IF EXISTS "roles";
276. CREATE TABLE "roles" (
277.   "username" varchar(50)  NOT NULL,
278.   "role" varchar(50)  NOT NULL
279. )
280. ;
282. -- ----------------------------
283. -- Records of roles
284. -- ----------------------------
285. BEGIN;
286. INSERT INTO "roles" VALUES ('nacos', 'ROLE_ADMIN');
287. COMMIT;
289. -- ----------------------------
290. -- Table structure for tenant_capacity
291. -- ----------------------------
292. DROP TABLE IF EXISTS "tenant_capacity";
293. CREATE TABLE "tenant_capacity" (
294.   "id" bigserial NOT NULL,
295.   "tenant_id" varchar(128)  NOT NULL,
296.   "quota" int4 NOT NULL,
297.   "usage" int4 NOT NULL,
298.   "max_size" int4 NOT NULL,
299.   "max_aggr_count" int4 NOT NULL,
300.   "max_aggr_size" int4 NOT NULL,
301.   "max_history_count" int4 NOT NULL,
302.   "gmt_create" timestamp(6) NOT NULL,
303.   "gmt_modified" timestamp(6) NOT NULL
304. )
305. ;
306. COMMENT ON COLUMN "tenant_capacity"."id" IS '主键ID';
307. COMMENT ON COLUMN "tenant_capacity"."tenant_id" IS 'Tenant ID';
308. COMMENT ON COLUMN "tenant_capacity"."quota" IS '配额，0表示使用默认值';
309. COMMENT ON COLUMN "tenant_capacity"."usage" IS '使用量';
310. COMMENT ON COLUMN "tenant_capacity"."max_size" IS '单个配置大小上限，单位为字节，0表示使用默认值';
311. COMMENT ON COLUMN "tenant_capacity"."max_aggr_count" IS '聚合子配置最大个数';
312. COMMENT ON COLUMN "tenant_capacity"."max_aggr_size" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';
313. COMMENT ON COLUMN "tenant_capacity"."max_history_count" IS '最大变更历史数量';
314. COMMENT ON COLUMN "tenant_capacity"."gmt_create" IS '创建时间';
315. COMMENT ON COLUMN "tenant_capacity"."gmt_modified" IS '修改时间';
316. COMMENT ON TABLE "tenant_capacity" IS '租户容量信息表';
318. -- ----------------------------
319. -- Records of tenant_capacity
320. -- ----------------------------
321. BEGIN;
322. COMMIT;
324. -- ----------------------------
325. -- Table structure for tenant_info
326. -- ----------------------------
327. DROP TABLE IF EXISTS "tenant_info";
328. CREATE TABLE "tenant_info" (
329.   "id" bigserial NOT NULL,
330.   "kp" varchar(128)  NOT NULL,
331.   "tenant_id" varchar(128) ,
332.   "tenant_name" varchar(128) ,
333.   "tenant_desc" varchar(256) ,
334.   "create_source" varchar(32) ,
335.   "gmt_create" int8 NOT NULL,
336.   "gmt_modified" int8 NOT NULL
337. )
338. ;
339. COMMENT ON COLUMN "tenant_info"."id" IS 'id';
340. COMMENT ON COLUMN "tenant_info"."kp" IS 'kp';
341. COMMENT ON COLUMN "tenant_info"."tenant_id" IS 'tenant_id';
342. COMMENT ON COLUMN "tenant_info"."tenant_name" IS 'tenant_name';
343. COMMENT ON COLUMN "tenant_info"."tenant_desc" IS 'tenant_desc';
344. COMMENT ON COLUMN "tenant_info"."create_source" IS 'create_source';
345. COMMENT ON COLUMN "tenant_info"."gmt_create" IS '创建时间';
346. COMMENT ON COLUMN "tenant_info"."gmt_modified" IS '修改时间';
347. COMMENT ON TABLE "tenant_info" IS 'tenant_info';
349. -- ----------------------------
350. -- Records of tenant_info
351. -- ----------------------------
352. BEGIN;
353. COMMIT;
355. -- ----------------------------
356. -- Table structure for users
357. -- ----------------------------
358. DROP TABLE IF EXISTS "users";
359. CREATE TABLE "users" (
360.   "username" varchar(50)  NOT NULL,
361.   "password" varchar(500)  NOT NULL,
362.   "enabled" boolean NOT NULL
363. )
364. ;
366. -- ----------------------------
367. -- Records of users
368. -- ----------------------------
369. BEGIN;
370. INSERT INTO "users" VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);
371. COMMIT;
373. -- ----------------------------
374. -- Indexes structure for table config_info
375. -- ----------------------------
376. CREATE UNIQUE INDEX "uk_configinfo_datagrouptenant" ON "config_info" ("data_id","group_id","tenant_id");
378. -- ----------------------------
379. -- Primary Key structure for table config_info
380. -- ----------------------------
381. ALTER TABLE "config_info" ADD CONSTRAINT "config_info_pkey" PRIMARY KEY ("id");
383. -- ----------------------------
384. -- Indexes structure for table config_info_aggr
385. -- ----------------------------
386. CREATE UNIQUE INDEX "uk_configinfoaggr_datagrouptenantdatum" ON "config_info_aggr" USING btree ("data_id","group_id","tenant_id","datum_id");
388. -- ----------------------------
389. -- Primary Key structure for table config_info_aggr
390. -- ----------------------------
391. ALTER TABLE "config_info_aggr" ADD CONSTRAINT "config_info_aggr_pkey" PRIMARY KEY ("id");
393. -- ----------------------------
394. -- Indexes structure for table config_info_beta
395. -- ----------------------------
396. CREATE UNIQUE INDEX "uk_configinfobeta_datagrouptenant" ON "config_info_beta" USING btree ("data_id","group_id","tenant_id");
398. -- ----------------------------
399. -- Primary Key structure for table config_info_beta
400. -- ----------------------------
401. ALTER TABLE "config_info_beta" ADD CONSTRAINT "config_info_beta_pkey" PRIMARY KEY ("id");
403. -- ----------------------------
404. -- Indexes structure for table config_info_tag
405. -- ----------------------------
406. CREATE UNIQUE INDEX "uk_configinfotag_datagrouptenanttag" ON "config_info_tag" USING btree ("data_id","group_id","tenant_id","tag_id");
408. -- ----------------------------
409. -- Primary Key structure for table config_info_tag
410. -- ----------------------------
411. ALTER TABLE "config_info_tag" ADD CONSTRAINT "config_info_tag_pkey" PRIMARY KEY ("id");
413. -- ----------------------------
414. -- Indexes structure for table config_tags_relation
415. -- ----------------------------
416. CREATE INDEX "idx_tenant_id" ON "config_tags_relation" USING btree (
417.   "tenant_id"
418. );
419. CREATE UNIQUE INDEX "uk_configtagrelation_configidtag" ON "config_tags_relation" USING btree (
420.   "id",
421.   "tag_name",
422.   "tag_type"
423. );
425. -- ----------------------------
426. -- Primary Key structure for table config_tags_relation
427. -- ----------------------------
428. ALTER TABLE "config_tags_relation" ADD CONSTRAINT "config_tags_relation_pkey" PRIMARY KEY ("nid");
430. -- ----------------------------
431. -- Indexes structure for table group_capacity
432. -- ----------------------------
433. CREATE UNIQUE INDEX "uk_group_id" ON "group_capacity" USING btree (
434.   "group_id"
435. );
437. -- ----------------------------
438. -- Primary Key structure for table group_capacity
439. -- ----------------------------
440. ALTER TABLE "group_capacity" ADD CONSTRAINT "group_capacity_pkey" PRIMARY KEY ("id");
442. -- ----------------------------
443. -- Indexes structure for table his_config_info
444. -- ----------------------------
445. CREATE INDEX "idx_did" ON "his_config_info" USING btree (
446.   "data_id"
447. );
448. CREATE INDEX "idx_gmt_create" ON "his_config_info" USING btree (
449.   "gmt_create"
450. );
451. CREATE INDEX "idx_gmt_modified" ON "his_config_info" USING btree (
452.   "gmt_modified"
453. );
455. -- ----------------------------
456. -- Primary Key structure for table his_config_info
457. -- ----------------------------
458. ALTER TABLE "his_config_info" ADD CONSTRAINT "his_config_info_pkey" PRIMARY KEY ("nid");
460. -- ----------------------------
461. -- Indexes structure for table permissions
462. -- ----------------------------
463. CREATE UNIQUE INDEX "uk_role_permission" ON "permissions" USING btree (
464.   "role",
465.   "resource",
466.   "action"
467. );
469. -- ----------------------------
470. -- Indexes structure for table roles
471. -- ----------------------------
472. CREATE UNIQUE INDEX "uk_username_role" ON "roles" USING btree (
473.   "username",
474.   "role"
475. );
477. -- ----------------------------
478. -- Indexes structure for table tenant_capacity
479. -- ----------------------------
480. CREATE UNIQUE INDEX "uk_tenant_id" ON "tenant_capacity" USING btree (
481.   "tenant_id"
482. );
484. -- ----------------------------
485. -- Primary Key structure for table tenant_capacity
486. -- ----------------------------
487. ALTER TABLE "tenant_capacity" ADD CONSTRAINT "tenant_capacity_pkey" PRIMARY KEY ("id");
489. -- ----------------------------
490. -- Indexes structure for table tenant_info
491. -- ----------------------------
492. CREATE UNIQUE INDEX "uk_tenant_info_kptenantid" ON "tenant_info" USING btree (
493.   "kp",
494.   "tenant_id"
495. );

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。