This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new eefa5699ce0 Refactor template dir (#20481)
eefa5699ce0 is described below
commit eefa5699ce0b80e32c059b4d6a3e3d64d3bd99f4
Author: Chuxin Chen <[email protected]>
AuthorDate: Wed Aug 24 15:09:52 2022 +0800
Refactor template dir (#20481)
---
.../PostgreSQLCreateTableSQLGenerator.java | 4 ++--
.../PostgresColumnPropertiesAppender.java | 8 ++++----
.../PostgresConstraintsPropertiesAppender.java | 22 +++++++++++-----------
.../ddlgenerator/PostgresIndexSQLGenerator.java | 12 ++++++------
.../PostgresTablePropertiesLoader.java | 8 ++++----
.../check_constraint/9.2_plus/properties.ftl | 0
.../{ => component}/columns/10_plus/properties.ftl | 0
.../{ => component}/columns/12_plus/properties.ftl | 0
.../columns/default/edit_mode_types_multi.ftl | 0
.../11_plus/get_constraint_include.ftl | 0
.../exclusion_constraint/11_plus/properties.ftl | 0
.../9.2_plus/get_constraint_cols.ftl | 0
.../exclusion_constraint/default/properties.ftl | 0
.../foreign_key/9.1_plus/properties.ftl | 0
.../foreign_key/default/get_cols.ftl | 0
.../foreign_key/default/get_constraint_cols.ftl | 0
.../foreign_key/default/get_constraints.ftl | 0
.../foreign_key/default/get_parent.ftl | 0
.../11_plus/get_constraint_include.ftl | 0
.../index_constraint/11_plus/properties.ftl | 0
.../default/get_costraint_cols.ftl | 0
.../index_constraint/default/properties.ftl | 0
.../indexes/11_plus/column_details.ftl | 0
.../{ => component}/indexes/11_plus/create.ftl | 0
.../indexes/11_plus/include_details.ftl | 0
.../{ => component}/indexes/default/alter.ftl | 0
.../indexes/default/column_details.ftl | 0
.../{ => component}/indexes/default/create.ftl | 0
.../{ => component}/indexes/default/nodes.ftl | 0
.../{ => component}/indexes/default/properties.ftl | 0
.../{ => component}/table/10_plus/create.ftl | 2 +-
.../table/10_plus/get_columns_for_table.ftl | 0
.../{ => component}/table/10_plus/get_inherits.ftl | 2 +-
.../{ => component}/table/10_plus/properties.ftl | 0
.../{ => component}/table/11_plus/create.ftl | 2 +-
.../{ => component}/table/11_plus/properties.ftl | 0
.../{ => component}/table/12_plus/create.ftl | 2 +-
.../{ => component}/table/12_plus/properties.ftl | 0
.../table/default/get_database_id.ftl | 0
.../table/default/get_schema_id.ftl | 0
.../{ => component}/table/default/get_table_id.ftl | 0
41 files changed, 31 insertions(+), 31 deletions(-)
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgreSQLCreateTableSQLGenerator.java
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgreSQLCreateTableSQLGen
[...]
index a0e5fe78b00..bab6a47a94c 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgreSQLCreateTableSQLGenerator.java
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgreSQLCreateTableSQLGenerator.java
@@ -17,8 +17,8 @@
package org.apache.shardingsphere.data.pipeline.postgresql.ddlgenerator;
-import
org.apache.shardingsphere.data.pipeline.spi.ddlgenerator.CreateTableSQLGenerator;
import
org.apache.shardingsphere.data.pipeline.postgresql.util.PostgreSQLPipelineFreemarkerManager;
+import
org.apache.shardingsphere.data.pipeline.spi.ddlgenerator.CreateTableSQLGenerator;
import javax.sql.DataSource;
import java.sql.Connection;
@@ -57,7 +57,7 @@ public final class PostgreSQLCreateTableSQLGenerator
implements CreateTableSQLGe
}
private String generateCreateTableSQL(final int majorVersion, final int
minorVersion, final Map<String, Object> materials) {
- return PostgreSQLPipelineFreemarkerManager.getSQLByVersion(materials,
"table/%s/create.ftl", majorVersion, minorVersion).trim();
+ return PostgreSQLPipelineFreemarkerManager.getSQLByVersion(materials,
"component/table/%s/create.ftl", majorVersion, minorVersion).trim();
}
private String generateCreateIndexSQL(final Connection connection, final
int majorVersion, final int minorVersion, final Map<String, Object> materials) {
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresColumnPropertiesAppender.java
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresColumnPropertiesAppe
[...]
index f3d71180ac3..da43824a01d 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresColumnPropertiesAppender.java
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresColumnPropertiesAppender.java
@@ -57,7 +57,7 @@ public final class PostgresColumnPropertiesAppender extends
AbstractPostgresDDLA
@SneakyThrows
public void append(final Map<String, Object> context) {
Collection<Map<String, Object>> typeAndInheritedColumns =
getTypeAndInheritedColumns(context);
- Collection<Map<String, Object>> allColumns =
executeByTemplate(context, "columns/%s/properties.ftl");
+ Collection<Map<String, Object>> allColumns =
executeByTemplate(context, "component/columns/%s/properties.ftl");
for (Map<String, Object> each : allColumns) {
for (Map<String, Object> column : typeAndInheritedColumns) {
if (each.get("name").equals(column.get("name"))) {
@@ -90,7 +90,7 @@ public final class PostgresColumnPropertiesAppender extends
AbstractPostgresDDLA
private Collection<Map<String, Object>> getColumnFromInherits(final
Collection<String> collInherits) {
Collection<Map<String, Object>> result = new LinkedList<>();
- for (Map<String, Object> each : executeByTemplate(new
LinkedHashMap<>(), "table/%s/get_inherits.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(new
LinkedHashMap<>(), "component/table/%s/get_inherits.ftl")) {
if (collInherits.contains((String) each.get("inherits"))) {
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("tid", each.get("oid"));
@@ -103,7 +103,7 @@ public final class PostgresColumnPropertiesAppender extends
AbstractPostgresDDLA
private Collection<Map<String, Object>> getColumnFromType(final
Map<String, Object> context) {
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("tid", context.get("typoid"));
- return executeByTemplate(parameters,
"table/%s/get_columns_for_table.ftl");
+ return executeByTemplate(parameters,
"component/table/%s/get_columns_for_table.ftl");
}
@SuppressWarnings("unchecked")
@@ -126,7 +126,7 @@ public final class PostgresColumnPropertiesAppender extends
AbstractPostgresDDLA
Map<String, Collection<String>> result = new LinkedHashMap<>();
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("type_ids", allColumns.stream().map(each ->
each.get("atttypid").toString()).collect(Collectors.joining(",")));
- for (Map<String, Object> each : executeByTemplate(parameters,
"columns/%s/edit_mode_types_multi.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(parameters,
"component/columns/%s/edit_mode_types_multi.ftl")) {
result.put(each.get("main_oid").toString(),
covertPgArrayAndSort(each.get("edit_types")));
}
return result;
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresConstraintsPropertiesAppender.java
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresConstraintsProp
[...]
index db73ced2664..4cb35e44522 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresConstraintsPropertiesAppender.java
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresConstraintsPropertiesAppender.java
@@ -96,7 +96,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
parameters.put("cid", constraintsProp.get("oid"));
Collection<Object> includes = new LinkedList<>();
if (getMajorVersion() >= PG_CONSTRAINTS_INCLUDE_VERSION) {
- for (Map<String, Object> each : executeByTemplate(parameters,
"index_constraint/%s/get_constraint_include.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(parameters,
"component/index_constraint/%s/get_constraint_include.ftl")) {
includes.add(each.get("colname"));
}
}
@@ -118,7 +118,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
Map<String, Object> parameters = new HashMap<>();
parameters.put("cid", constraintColProps.get("oid"));
parameters.put("colcnt", constraintColProps.get("col_count"));
- return executeByTemplate(parameters,
"index_constraint/%s/get_costraint_cols.ftl");
+ return executeByTemplate(parameters,
"component/index_constraint/%s/get_costraint_cols.ftl");
}
private Collection<Map<String, Object>> fetchConstraintsProperties(final
Map<String, Object> context, final String constraintType) {
@@ -127,14 +127,14 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
parameters.put("tid", context.get("tid"));
parameters.put("cid", context.get("cid"));
parameters.put("constraint_type", constraintType);
- return executeByTemplate(parameters,
"index_constraint/%s/properties.ftl");
+ return executeByTemplate(parameters,
"component/index_constraint/%s/properties.ftl");
}
private Collection<Map<String, Object>> getExclusionConstraints(final
Map<String, Object> context) {
Map<String, Object> parameters = new HashMap<>();
parameters.put("tid", context.get("tid"));
parameters.put("did", context.get("did"));
- Collection<Map<String, Object>> result = executeByTemplate(parameters,
"exclusion_constraint/%s/properties.ftl");
+ Collection<Map<String, Object>> result = executeByTemplate(parameters,
"component/exclusion_constraint/%s/properties.ftl");
for (Map<String, Object> each : result) {
getExclusionConstraintsColumns(each);
}
@@ -146,7 +146,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
parameters.put("cid", exclusionConstraintsProps.get("oid"));
parameters.put("col_count",
exclusionConstraintsProps.get("col_count"));
Collection<Map<String, Object>> columns = new LinkedList<>();
- for (Map<String, Object> each : executeByTemplate(parameters,
"exclusion_constraint/%s/get_constraint_cols.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(parameters,
"component/exclusion_constraint/%s/get_constraint_cols.ftl")) {
boolean order = (((int) each.get("options")) & 1) == 0;
boolean nullsOrder = (((int) each.get("options")) & 2) != 0;
Map<String, Object> col = new HashMap<>();
@@ -174,7 +174,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
private Collection<Map<String, Object>> getForeignKeys(final Long tid) {
Map<String, Object> parameters = new HashMap<>();
parameters.put("tid", tid);
- Collection<Map<String, Object>> result = executeByTemplate(parameters,
"foreign_key/%s/properties.ftl");
+ Collection<Map<String, Object>> result = executeByTemplate(parameters,
"component/foreign_key/%s/properties.ftl");
for (Map<String, Object> each : result) {
Collection<Map<String, Object>> columns = new LinkedList<>();
Set<String> cols = new HashSet<>();
@@ -200,7 +200,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
private void setRemoteName(final Map<String, Object> foreignKey, final
Collection<Map<String, Object>> columns) {
Map<String, Object> parameters = new HashMap<>();
parameters.put("tid", columns.iterator().next().get("references"));
- Collection<Map<String, Object>> parents =
executeByTemplate(parameters, "foreign_key/%s/get_parent.ftl");
+ Collection<Map<String, Object>> parents =
executeByTemplate(parameters, "component/foreign_key/%s/get_parent.ftl");
for (Map<String, Object> each : parents) {
foreignKey.put("remote_schema", each.get("schema"));
foreignKey.put("remote_table", each.get("table"));
@@ -217,7 +217,7 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
key.put("conkey", foreignKeyProps.get("conkey"));
keys.add(key);
parameters.put("keys", keys);
- return executeByTemplate(parameters,
"foreign_key/%s/get_constraint_cols.ftl");
+ return executeByTemplate(parameters,
"component/foreign_key/%s/get_constraint_cols.ftl");
}
private boolean isPartitionAndConstraintInherited(final Map<String,
Object> constraint, final Map<String, Object> context) {
@@ -227,11 +227,11 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
private Optional<String> searchCoveringIndex(final Long tid, final
Set<String> cols) {
Map<String, Object> parameters = new HashMap<>();
parameters.put("tid", tid);
- for (Map<String, Object> each : executeByTemplate(parameters,
"foreign_key/%s/get_constraints.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(parameters,
"component/foreign_key/%s/get_constraints.ftl")) {
Map<String, Object> map = new HashMap<>();
map.put("cid", each.get("oid"));
map.put("colcnt", each.get("col_count"));
- Collection<Map<String, Object>> rows = executeByTemplate(map,
"foreign_key/%s/get_cols.ftl");
+ Collection<Map<String, Object>> rows = executeByTemplate(map,
"component/foreign_key/%s/get_cols.ftl");
Set<String> indexCols = new HashSet<>();
for (Map<String, Object> row : rows) {
indexCols.add(strip(row.get("column").toString()));
@@ -267,6 +267,6 @@ public final class PostgresConstraintsPropertiesAppender
extends AbstractPostgre
private Collection<Map<String, Object>> getCheckConstraints(final Long
tid) {
Map<String, Object> parameters = new HashMap<>();
parameters.put("tid", tid);
- return executeByTemplate(parameters,
"check_constraint/%s/properties.ftl");
+ return executeByTemplate(parameters,
"component/check_constraint/%s/properties.ftl");
}
}
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresIndexSQLGenerator.java
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresIndexSQLGenerator.java
index f2227af5c32..ba31c7644a2 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresIndexSQLGenerator.java
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresIndexSQLGenerator.java
@@ -61,7 +61,7 @@ public final class PostgresIndexSQLGenerator extends
AbstractPostgresDDLAdapter
private Collection<Map<String, Object>> getIndexNodes(final Map<String,
Object> context) {
Map<String, Object> param = new LinkedHashMap<>();
param.put("tid", context.get("tid"));
- return executeByTemplate(param, "indexes/%s/nodes.ftl");
+ return executeByTemplate(param, "component/indexes/%s/nodes.ftl");
}
private String getIndexSql(final Map<String, Object> context, final
Map<String, Object> indexNode) throws SQLException {
@@ -74,9 +74,9 @@ public final class PostgresIndexSQLGenerator extends
AbstractPostgresDDLAdapter
}
private String doGenerateIndexSql(final Map<String, Object> indexData) {
- String result =
PostgreSQLPipelineFreemarkerManager.getSQLByVersion(indexData,
"indexes/%s/create.ftl", getMajorVersion(), getMinorVersion());
+ String result =
PostgreSQLPipelineFreemarkerManager.getSQLByVersion(indexData,
"component/indexes/%s/create.ftl", getMajorVersion(), getMinorVersion());
result += System.lineSeparator();
- result +=
PostgreSQLPipelineFreemarkerManager.getSQLByVersion(indexData,
"indexes/%s/alter.ftl", getMajorVersion(), getMinorVersion());
+ result +=
PostgreSQLPipelineFreemarkerManager.getSQLByVersion(indexData,
"component/indexes/%s/alter.ftl", getMajorVersion(), getMinorVersion());
return result;
}
@@ -94,7 +94,7 @@ public final class PostgresIndexSQLGenerator extends
AbstractPostgresDDLAdapter
param.put("tid", context.get("tid"));
param.put("idx", indexNode.get("oid"));
param.put("datlastsysoid", context.get("datlastsysoid"));
- return executeByTemplate(param, "indexes/%s/properties.ftl");
+ return executeByTemplate(param, "component/indexes/%s/properties.ftl");
}
private void appendColumnDetails(final Map<String, Object> indexData,
final Long indexId) throws SQLException {
@@ -140,7 +140,7 @@ public final class PostgresIndexSQLGenerator extends
AbstractPostgresDDLAdapter
private Collection<Map<String, Object>> fetchColumnDetails(final Long
indexId) {
Map<String, Object> param = new LinkedHashMap<>();
param.put("idx", indexId);
- return executeByTemplate(param, "indexes/%s/column_details.ftl");
+ return executeByTemplate(param,
"component/indexes/%s/column_details.ftl");
}
private String getColumnPropertyDisplayData(final Map<String, Object>
each, final Map<String, Object> indexData) throws SQLException {
@@ -167,7 +167,7 @@ public final class PostgresIndexSQLGenerator extends
AbstractPostgresDDLAdapter
Map<String, Object> param = new LinkedHashMap<>();
param.put("idx", oid);
Collection<Object> includes = new LinkedList<>();
- for (Map<String, Object> each : executeByTemplate(param,
"indexes/%s/include_details.ftl")) {
+ for (Map<String, Object> each : executeByTemplate(param,
"component/indexes/%s/include_details.ftl")) {
includes.add(each.get("colname"));
}
indexData.put("include", includes);
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresTablePropertiesLoader.java
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresTablePropertiesLoader.java
index 76b60bfd36a..751f86149cc 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresTablePropertiesLoader.java
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/java/org/apache/shardingsphere/data/pipeline/postgresql/ddlgenerator/PostgresTablePropertiesLoader.java
@@ -57,24 +57,24 @@ public final class PostgresTablePropertiesLoader extends
AbstractPostgresDDLAdap
private void fetchDataBaseId(final Map<String, Object> context) throws
SQLException {
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("databaseName", getConnection().getCatalog());
- appendFirstRow(executeByTemplate(parameters,
"table/%s/get_database_id.ftl"), context);
+ appendFirstRow(executeByTemplate(parameters,
"component/table/%s/get_database_id.ftl"), context);
}
private void fetchTableId(final Map<String, Object> context) {
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("schemaName", schemaName);
parameters.put("tableName", tableName);
- appendFirstRow(executeByTemplate(parameters,
"table/%s/get_table_id.ftl"), context);
+ appendFirstRow(executeByTemplate(parameters,
"component/table/%s/get_table_id.ftl"), context);
}
private void fetchSchemaId(final Map<String, Object> context) {
Map<String, Object> parameters = new LinkedHashMap<>();
parameters.put("schemaName", schemaName);
- appendFirstRow(executeByTemplate(parameters,
"table/%s/get_schema_id.ftl"), context);
+ appendFirstRow(executeByTemplate(parameters,
"component/table/%s/get_schema_id.ftl"), context);
}
private void fetchTableProperties(final Map<String, Object> context)
throws SQLException {
- appendFirstRow(executeByTemplate(context, "table/%s/properties.ftl"),
context);
+ appendFirstRow(executeByTemplate(context,
"component/table/%s/properties.ftl"), context);
updateAutovacuumProperties(context);
checkRlspolicySupport(context);
formatSecurityLabels(context);
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/check_constraint/9.2_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/check_constraint/9.2_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/check_constraint/9.2_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/check_constraint/9.2_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/10_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/10_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/10_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/10_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/12_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/12_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/12_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/12_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/default/edit_mode_types_multi.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/default/edit_mode_types_multi.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/columns/default/edit_mode_types_multi.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/columns/default/edit_mode_types_multi.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/11_plus/get_constraint_include.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/11_plus/get_constraint_include.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/11_plus/get_constraint_include.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/11_plus/get_constraint_include.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/11_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/11_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/11_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/11_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/9.2_plus/get_constraint_cols.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/9.2_plus/get_constraint_cols.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/9.2_plus/get_constraint_cols.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/9.2_plus/get_constraint_cols.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/default/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/default/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/exclusion_constraint/default/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/exclusion_constraint/default/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/9.1_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/9.1_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/9.1_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/9.1_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_cols.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_cols.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_cols.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_cols.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_constraint_cols.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_constraint_cols.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_constraint_cols.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_constraint_cols.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_constraints.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_constraints.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_constraints.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_constraints.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_parent.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_parent.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/foreign_key/default/get_parent.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/foreign_key/default/get_parent.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/11_plus/get_constraint_include.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/11_plus/get_constraint_include.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/11_plus/get_constraint_include.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/11_plus/get_constraint_include.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/11_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/11_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/11_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/11_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/default/get_costraint_cols.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/default/get_costraint_cols.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/default/get_costraint_cols.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/default/get_costraint_cols.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/default/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/default/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/index_constraint/default/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/index_constraint/default/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/column_details.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/column_details.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/column_details.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/column_details.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/create.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/create.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/create.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/create.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/include_details.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/include_details.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/11_plus/include_details.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/11_plus/include_details.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/alter.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/alter.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/alter.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/alter.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/column_details.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/column_details.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/column_details.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/column_details.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/create.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/create.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/create.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/create.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/nodes.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/nodes.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/nodes.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/nodes.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/indexes/default/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/indexes/default/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/create.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/create.ftl
similarity index 99%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/create.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/create.ftl
index f7ab015dc90..a4379054c22 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/create.ftl
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/create.ftl
@@ -15,7 +15,7 @@
~ limitations under the License.
-->
-<#import "../../macro/constraints.ftl" as CONSTRAINTS>
+<#import "../../../macro/constraints.ftl" as CONSTRAINTS>
CREATE <#if relpersistence!false >UNLOGGED </#if>TABLE IF NOT EXISTS
${schema}.${name}
<#if typname?? >
OF ${typname }
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/get_columns_for_table.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/get_columns_for_table.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/get_columns_for_table.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/get_columns_for_table.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/get_inherits.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/get_inherits.ftl
similarity index 95%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/get_inherits.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/get_inherits.ftl
index 524279bdddb..0dee99b79cd 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/get_inherits.ftl
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/get_inherits.ftl
@@ -15,7 +15,7 @@
~ limitations under the License.
-->
-<#import "../../macro/db_catalogs.ftl" as CATALOG>
+<#import "../../../macro/db_catalogs.ftl" as CATALOG>
SELECT c.oid, c.relname , nspname,
CASE WHEN nspname NOT LIKE 'pg\_%' THEN
pg_catalog.quote_ident(nspname)||'.'||pg_catalog.quote_ident(c.relname)
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/10_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/10_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/11_plus/create.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/11_plus/create.ftl
similarity index 99%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/11_plus/create.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/11_plus/create.ftl
index afe8d860a98..0aaca4ab6c3 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/11_plus/create.ftl
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/11_plus/create.ftl
@@ -15,7 +15,7 @@
~ limitations under the License.
-->
-<#import "../../macro/constraints.ftl" as CONSTRAINTS>
+<#import "../../../macro/constraints.ftl" as CONSTRAINTS>
CREATE <#if relpersistence!false >UNLOGGED </#if>TABLE IF NOT EXISTS
${schema}.${name}
<#if typname?? >
OF ${typname }
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/11_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/11_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/11_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/11_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/12_plus/create.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/12_plus/create.ftl
similarity index 99%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/12_plus/create.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/12_plus/create.ftl
index 8a2e47855d0..b2d9ee95829 100644
---
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/12_plus/create.ftl
+++
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/12_plus/create.ftl
@@ -15,7 +15,7 @@
~ limitations under the License.
-->
-<#import "../../macro/constraints.ftl" as CONSTRAINTS>
+<#import "../../../macro/constraints.ftl" as CONSTRAINTS>
<#assign with_clause = false>
<#if fillfactor!false || parallel_workers!false || toast_tuple_target!false ||
(autovacuum_custom!false && add_vacuum_settings_in_sql!false) ||
autovacuum_enabled == 't' || autovacuum_enabled == 'f' ||
(toast_autovacuum!false && add_vacuum_settings_in_sql!false) ||
toast_autovacuum_enabled == 't' || toast_autovacuum_enabled == 'f' >
<#assign with_clause = true>
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/12_plus/properties.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/12_plus/properties.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/12_plus/properties.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/12_plus/properties.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_database_id.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_database_id.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_database_id.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_database_id.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_schema_id.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_schema_id.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_schema_id.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_schema_id.ftl
diff --git
a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_table_id.ftl
b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_table_id.ftl
similarity index 100%
rename from
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/table/default/get_table_id.ftl
rename to
shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-dialect/shardingsphere-data-pipeline-postgresql/src/main/resources/template/component/table/default/get_table_id.ftl
