This is an automated email from the ASF dual-hosted git repository.
liuhongyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new d2705ef19d feat:refactor registry reserved keyword fields (#6139)
d2705ef19d is described below
commit d2705ef19d14630955e869e4f0479156a65a6e10
Author: Wweiei <[email protected]>
AuthorDate: Mon Sep 8 11:11:32 2025 +0800
feat:refactor registry reserved keyword fields (#6139)
* feat:refactor registry reserved keyword fields
* feat:refactor registry reserved keyword fields
---------
Co-authored-by: aias00 <[email protected]>
---
db/init/mysql/schema.sql | 2 +-
db/init/ob/schema.sql | 2 +-
db/init/og/create-table.sql | 2 +-
db/init/oracle/schema.sql | 2 +-
db/init/pg/create-table.sql | 2 +-
db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql | 2 +-
db/upgrade/2.7.0-upgrade-2.7.1-ob.sql | 2 +-
db/upgrade/2.7.0-upgrade-2.7.1-og.sql | 2 +-
db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql | 2 +-
db/upgrade/2.7.0-upgrade-2.7.1-pg.sql | 2 +-
.../apache/shenyu/admin/model/dto/RegistryDTO.java | 6 ++---
.../shenyu/admin/model/entity/RegistryDO.java | 20 ++++++++---------
.../admin/service/impl/RegistryServiceImpl.java | 4 ++--
.../shenyu/admin/transfer/RegistryTransfer.java | 2 +-
.../src/main/resources/mappers/registry-sqlmap.xml | 22 +++++++++---------
.../src/main/resources/sql-script/h2/schema.sql | 26 ++++++++++++++++++++++
16 files changed, 63 insertions(+), 37 deletions(-)
diff --git a/db/init/mysql/schema.sql b/db/init/mysql/schema.sql
index 9452eee712..e86c4d76b0 100644
--- a/db/init/mysql/schema.sql
+++ b/db/init/mysql/schema.sql
@@ -2714,7 +2714,7 @@ CREATE TABLE `registry_config` (
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'username',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'password',
`namespace` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'namespace',
- `group` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'group',
+ `registry_group` varchar(20) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON
UPDATE CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE
diff --git a/db/init/ob/schema.sql b/db/init/ob/schema.sql
index f3ae75408e..2a86382b22 100644
--- a/db/init/ob/schema.sql
+++ b/db/init/ob/schema.sql
@@ -2630,7 +2630,7 @@ CREATE TABLE `registry_config` (
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'username',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'password',
`namespace` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT 'namespace',
- `group` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL
DEFAULT NULL COMMENT 'group',
+ `registry_group` varchar(20) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
`date_created` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT
'create time',
`date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON
UPDATE CURRENT_TIMESTAMP(3) COMMENT 'update time',
PRIMARY KEY (`id`) USING BTREE
diff --git a/db/init/og/create-table.sql b/db/init/og/create-table.sql
index a752390255..bc2863dfc2 100644
--- a/db/init/og/create-table.sql
+++ b/db/init/og/create-table.sql
@@ -3024,7 +3024,7 @@ CREATE TABLE "public"."registry_config" (
"username" varchar(50),
"password" varchar(100),
"namespace" varchar(100),
- "group" varchar(20),
+ "registry_group" varchar(20),
"date_created" timestamp(3) NOT NULL DEFAULT timezone('UTC-8'::text,
(now())::timestamp(0) without time zone),
"date_updated" timestamp(3) NOT NULL DEFAULT timezone('UTC-8'::text,
(now())::timestamp(0) without time zone),
PRIMARY KEY ("id")
diff --git a/db/init/oracle/schema.sql b/db/init/oracle/schema.sql
index 917ea5df56..fd02a8501f 100644
--- a/db/init/oracle/schema.sql
+++ b/db/init/oracle/schema.sql
@@ -3616,7 +3616,7 @@ CREATE TABLE "public"."registry_config" (
username varchar2(50),
password varchar2(100),
namespace varchar2(100),
- group varchar2(20),
+ registry_group varchar2(20),
date_created timestamp(3) DEFAULT SYSTIMESTAMP NOT NULL,
date_updated timestamp(3) DEFAULT SYSTIMESTAMP NOT NULL,
CONSTRAINT registry_config_pk PRIMARY KEY (id)
diff --git a/db/init/pg/create-table.sql b/db/init/pg/create-table.sql
index f8f454730e..ce388bf0fc 100644
--- a/db/init/pg/create-table.sql
+++ b/db/init/pg/create-table.sql
@@ -3159,7 +3159,7 @@ CREATE TABLE "public"."registry_config" (
"username" varchar(50),
"password" varchar(100),
"namespace" varchar(100),
- "group" varchar(20),
+ "registry_group" varchar(20),
"date_created" timestamp(3) NOT NULL DEFAULT timezone('UTC-8'::text,
(now())::timestamp(0) without time zone),
"date_updated" timestamp(3) NOT NULL DEFAULT timezone('UTC-8'::text,
(now())::timestamp(0) without time zone),
PRIMARY KEY ("id")
diff --git a/db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql
b/db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql
index cb443e7257..fbd17de958 100755
--- a/db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql
+++ b/db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql
@@ -248,7 +248,7 @@ CREATE TABLE `registry_config` (
`username` varchar(50) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'username',
`password` varchar(100) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'password',
`namespace` varchar(100) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'namespace',
- `group` varchar(20) CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
+ `registry_group` varchar(20) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
`date_created` timestamp(3) NOT NULL
DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'create time',
`date_updated` timestamp(3) NOT NULL
DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT 'update
time',
PRIMARY KEY (`id`) USING BTREE
diff --git a/db/upgrade/2.7.0-upgrade-2.7.1-ob.sql
b/db/upgrade/2.7.0-upgrade-2.7.1-ob.sql
index 982383beb4..50c519f01a 100755
--- a/db/upgrade/2.7.0-upgrade-2.7.1-ob.sql
+++ b/db/upgrade/2.7.0-upgrade-2.7.1-ob.sql
@@ -241,7 +241,7 @@ CREATE TABLE `registry_config` (
`username` varchar(50) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'username',
`password` varchar(100) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'password',
`namespace` varchar(100) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'namespace',
- `group` varchar(20) CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
+ `registry_group` varchar(20) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'group',
`date_created` timestamp(3) NOT NULL
DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'create time',
`date_updated` timestamp(3) NOT NULL
DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT 'update
time',
PRIMARY KEY (`id`) USING BTREE
diff --git a/db/upgrade/2.7.0-upgrade-2.7.1-og.sql
b/db/upgrade/2.7.0-upgrade-2.7.1-og.sql
index 33f7e0e19d..041d8ba605 100644
--- a/db/upgrade/2.7.0-upgrade-2.7.1-og.sql
+++ b/db/upgrade/2.7.0-upgrade-2.7.1-og.sql
@@ -254,7 +254,7 @@ CREATE TABLE "public"."registry_config" (
"username" varchar(50),
"password" varchar(100),
"namespace" varchar(100),
- "group" varchar(20),
+ "registry_group"
varchar(20),
"date_created" timestamp(3)
NOT NULL DEFAULT timezone('UTC-8'::text, (now())::timestamp(0) without time
zone),
"date_updated" timestamp(3)
NOT NULL DEFAULT timezone('UTC-8'::text, (now())::timestamp(0) without time
zone),
PRIMARY KEY ("id")
diff --git a/db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql
b/db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql
index d3f167223a..16a3cbd7e3 100755
--- a/db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql
+++ b/db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql
@@ -533,7 +533,7 @@ CREATE TABLE registry_config (
username varchar2(50),
password varchar2(100),
namespace varchar2(100),
- group varchar2(20),
+ registry_group varchar2(20),
date_created timestamp(3) DEFAULT SYSTIMESTAMP NOT NULL,
date_updated timestamp(3) DEFAULT SYSTIMESTAMP NOT NULL,
CONSTRAINT registry_config_pk PRIMARY KEY (id)
diff --git a/db/upgrade/2.7.0-upgrade-2.7.1-pg.sql
b/db/upgrade/2.7.0-upgrade-2.7.1-pg.sql
index 19b8c945fb..9daa2ee16f 100755
--- a/db/upgrade/2.7.0-upgrade-2.7.1-pg.sql
+++ b/db/upgrade/2.7.0-upgrade-2.7.1-pg.sql
@@ -253,7 +253,7 @@ CREATE TABLE "public"."registry_config" (
"username" varchar(50),
"password" varchar(100),
"namespace" varchar(100),
- "group" varchar(20),
+ "registry_group"
varchar(20),
"date_created" timestamp(3)
NOT NULL DEFAULT timezone('UTC-8'::text, (now())::timestamp(0) without time
zone),
"date_updated" timestamp(3)
NOT NULL DEFAULT timezone('UTC-8'::text, (now())::timestamp(0) without time
zone),
PRIMARY KEY ("id")
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/dto/RegistryDTO.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/dto/RegistryDTO.java
index 20d47b24f8..fe8fc59a6b 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/dto/RegistryDTO.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/dto/RegistryDTO.java
@@ -29,15 +29,15 @@ public class RegistryDTO implements Serializable {
private String id;
- @Length(max = 128, message = "The maximum length is 128")
+ @Length(max = 50, message = "The maximum length is 50")
@NotNull(message = "registry code not null")
private String registryId;
- @Length(max = 128, message = "The maximum length is 128")
+ @Length(max = 50, message = "The maximum length is 50")
@NotNull(message = "registry protocol not null")
private String protocol;
- @Length(max = 100, message = "The maximum length is 100")
+ @Length(max = 256, message = "The maximum length is 256")
@NotNull(message = "address null")
private String address;
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/RegistryDO.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/RegistryDO.java
index d84e775a33..18784a6ccd 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/RegistryDO.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/RegistryDO.java
@@ -57,7 +57,7 @@ public class RegistryDO extends BaseDO {
/**
* the model group.
*/
- private String group;
+ private String registryGroup;
/**
* Gets the value of registryId.
@@ -172,17 +172,17 @@ public class RegistryDO extends BaseDO {
*
* @return the value of group
*/
- public String getGroup() {
- return group;
+ public String getRegistryGroup() {
+ return registryGroup;
}
/**
* Sets the group.
*
- * @param group group
+ * @param registryGroup registryGroup
*/
- public void setGroup(final String group) {
- this.group = group;
+ public void setRegistryGroup(final String registryGroup) {
+ this.registryGroup = registryGroup;
}
/**
@@ -214,7 +214,7 @@ public class RegistryDO extends BaseDO {
private String namespace;
- private String group;
+ private String registryGroup;
private RegistryDOBuilder() {
}
@@ -324,8 +324,8 @@ public class RegistryDO extends BaseDO {
* @param group the group.
* @return RegistryDOBuilder.
*/
- public RegistryDOBuilder group(final String group) {
- this.group = group;
+ public RegistryDOBuilder registryGroup(final String group) {
+ this.registryGroup = group;
return this;
}
@@ -345,7 +345,7 @@ public class RegistryDO extends BaseDO {
registryDO.setUsername(username);
registryDO.setPassword(password);
registryDO.setNamespace(namespace);
- registryDO.setGroup(group);
+ registryDO.setRegistryGroup(registryGroup);
return registryDO;
}
}
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/RegistryServiceImpl.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/RegistryServiceImpl.java
index ae5e3ce6a1..9ab506933c 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/RegistryServiceImpl.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/RegistryServiceImpl.java
@@ -99,7 +99,7 @@ public class RegistryServiceImpl implements RegistryService {
.namespace(registryDTO.getNamespace())
.username(registryDTO.getUsername())
.password(registryDTO.getPassword())
- .group(registryDTO.getGroup())
+ .registryGroup(registryDTO.getGroup())
.dateCreated(currentTime)
.dateUpdated(currentTime)
.build();
@@ -125,7 +125,7 @@ public class RegistryServiceImpl implements RegistryService
{
.namespace(registryDTO.getNamespace())
.username(registryDTO.getUsername())
.password(registryDTO.getPassword())
- .group(registryDTO.getGroup())
+ .registryGroup(registryDTO.getGroup())
.dateUpdated(currentTime)
.build();
return registryMapper.updateSelective(registryDO) > 0
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/RegistryTransfer.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/RegistryTransfer.java
index 514c6ffc1a..3ea5bac863 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/RegistryTransfer.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/RegistryTransfer.java
@@ -43,7 +43,7 @@ public enum RegistryTransfer {
vo.setAddress(data.getAddress());
vo.setUsername(data.getUsername());
vo.setPassword(data.getPassword());
- vo.setGroup(data.getGroup());
+ vo.setGroup(data.getRegistryGroup());
vo.setNamespace(data.getNamespace());
return vo;
}).orElse(null);
diff --git a/shenyu-admin/src/main/resources/mappers/registry-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/registry-sqlmap.xml
index 7728cd9920..a52517e61e 100644
--- a/shenyu-admin/src/main/resources/mappers/registry-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/registry-sqlmap.xml
@@ -26,7 +26,7 @@
<result column="username" jdbcType="VARCHAR" property="username"/>
<result column="password" jdbcType="VARCHAR" property="password"/>
<result column="namespace" jdbcType="VARCHAR" property="namespace"/>
- <result column="group" jdbcType="VARCHAR" property="group"/>
+ <result column="registry_group" jdbcType="VARCHAR"
property="registryGroup"/>
<result column="date_created" jdbcType="TIMESTAMP"
property="dateCreated"/>
<result column="date_updated" jdbcType="TIMESTAMP"
property="dateUpdated"/>
</resultMap>
@@ -39,7 +39,7 @@
username,
password,
namespace,
- `group`,
+ registry_group,
date_created,
date_updated
</sql>
@@ -80,7 +80,7 @@
username,
password,
namespace,
- `group`,
+ registry_group,
date_created,
date_updated
)
@@ -92,7 +92,7 @@
#{username, jdbcType=VARCHAR},
#{password, jdbcType=VARCHAR},
#{namespace, jdbcType=VARCHAR},
- #{group, jdbcType=VARCHAR},
+ #{registryGroup, jdbcType=VARCHAR},
#{dateCreated, jdbcType=TIMESTAMP},
#{dateUpdated, jdbcType=TIMESTAMP}
)
@@ -120,8 +120,8 @@
<if test="namespace != null">
namespace,
</if>
- <if test="group != null">
- `group`,
+ <if test="registryGroup != null">
+ registry_group,
</if>
<if test="dateCreated != null">
date_created,
@@ -150,8 +150,8 @@
<if test="namespace != null">
#{namespace, jdbcType=VARCHAR},
</if>
- <if test="group != null">
- #{group, jdbcType=VARCHAR},
+ <if test="registryGroup != null">
+ #{registryGroup, jdbcType=VARCHAR},
</if>
<if test="dateCreated != null">
#{dateCreated, jdbcType=TIMESTAMP},
@@ -170,7 +170,7 @@
username = #{username, jdbcType=VARCHAR},
password = #{password, jdbcType=VARCHAR},
namespace = #{namespace, jdbcType=VARCHAR},
- `group` = #{group, jdbcType=VARCHAR},
+ registry_group = #{registryGroup, jdbcType=VARCHAR},
date_created = #{dateCreated, jdbcType=TIMESTAMP},
date_updated = #{dateUpdated, jdbcType=TIMESTAMP}
WHERE id = #{id, jdbcType=VARCHAR}
@@ -197,8 +197,8 @@
<if test="namespace != null">
namespace = #{namespace, jdbcType=VARCHAR},
</if>
- <if test="group != null">
- `group` = #{group, jdbcType=VARCHAR},
+ <if test="registryGroup != null">
+ registry_group = #{registryGroup, jdbcType=VARCHAR},
</if>
<if test="dateCreated != null">
date_created = #{dateCreated, jdbcType=TIMESTAMP},
diff --git a/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
b/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
index 0551ffce16..1bd941c1ec 100644
--- a/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
+++ b/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
@@ -1535,3 +1535,29 @@ INSERT IGNORE INTO `permission` (`id`, `object_id`,
`resource_id`, `date_created
INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1697141926281382723',
'1346358560427216896', '1346778036402483303', '2023-08-31 07:22:07',
'2023-08-31 07:22:07');
INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1697141926281382724',
'1346358560427216896', '1346778036402483304', '2023-08-31 07:18:37',
'2023-08-31 07:18:37');
INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1697141926281382725',
'1346358560427216896', '1346778036402483305', '2023-08-31 07:18:37',
'2023-08-31 07:18:37');
+
+CREATE TABLE IF NOT EXISTS `registry_config` (
+ `id` varchar(128) NOT NULL COMMENT 'primary key id',
+ `registry_id` varchar(50) NOT NULL COMMENT 'registry_id',
+ `protocol` varchar(128) NOT NULL COMMENT 'protocol',
+ `address` varchar(512) NOT NULL COMMENT 'address',
+ `username` varchar(50) COMMENT 'username',
+ `password` varchar(100) COMMENT 'password',
+ `namespace` varchar(100) COMMENT 'namespace',
+ `registry_group` varchar(20) COMMENT 'group',
+ `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT
'date_created',
+ `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT 'date_updated',
+ PRIMARY KEY (`id`)
+);
+
+INSERT IGNORE INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1953048313980116900',
'1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.REGISTRY', 'registry',
'/config/registry', 'registry', 1, 7, 'ordered-list', 0, 0, '', 1, '2025-08-06
17:00:00.000', '2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1953048313980116901',
'1953048313980116900', 'SHENYU.BUTTON.SYSTEM.ADD', '', '', '', 2, 0, '', 1, 0,
'system:registry:add', 1, '2025-08-06 17:00:00.000', '2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1953048313980116902',
'1953048313980116900', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 1, '', 1, 0,
'system:registry:list', 1, '2025-08-06 17:00:00.000', '2025-08-06
17:00:00.000');
+INSERT IGNORE INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1953048313980116903',
'1953048313980116900', 'SHENYU.BUTTON.SYSTEM.DELETE', '', '', '', 2, 2, '', 1,
0, 'system:registry:delete', 1,'2025-08-06 17:00:00.000', '2025-08-06
17:00:00.000');
+INSERT IGNORE INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1953048313980116904',
'1953048313980116900', 'SHENYU.BUTTON.SYSTEM.EDIT', '', '', '', 2, 3, '', 1, 0,
'system:registry:edit', 1, '2025-08-06 17:00:00.000', '2025-08-06
17:00:00.000');
+
+INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1953049887387303901',
'1346358560427216896', '1953048313980116900', '2025-08-06 17:00:00.000',
'2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1953049887387303902',
'1346358560427216896', '1953048313980116901', '2025-08-06 17:00:00.000',
'2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1953049887387303903',
'1346358560427216896', '1953048313980116902', '2025-08-06 17:00:00.000',
'2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1953049887387303904',
'1346358560427216896', '1953048313980116903', '2025-08-06 17:00:00.000',
'2025-08-06 17:00:00.000');
+INSERT IGNORE INTO `permission` (`id`, `object_id`, `resource_id`,
`date_created`, `date_updated`) VALUES ('1953049887387303905',
'1346358560427216896', '1953048313980116904', '2025-08-06 17:00:00.000',
'2025-08-06 17:00:00.000');
