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 812e0b9478 [type:fix] fix oracle schema.sql (#6162)
812e0b9478 is described below
commit 812e0b9478980613cd10403981b0a8002eb4e9ed
Author: eye-gu <[email protected]>
AuthorDate: Mon Sep 22 19:29:02 2025 +0800
[type:fix] fix oracle schema.sql (#6162)
---
db/init/mysql/schema.sql | 2 +-
db/init/ob/schema.sql | 2 +-
db/init/og/create-table.sql | 4 +-
db/init/oracle/schema.sql | 236 ++++++++++-----------
db/init/pg/create-table.sql | 4 +-
db/upgrade/2.7.0-upgrade-2.7.1-mysql.sql | 2 +
db/upgrade/2.7.0-upgrade-2.7.1-ob.sql | 4 +-
db/upgrade/2.7.0-upgrade-2.7.1-og.sql | 4 +-
db/upgrade/2.7.0-upgrade-2.7.1-oracle.sql | 2 +
db/upgrade/2.7.0-upgrade-2.7.1-pg.sql | 2 +
.../shenyu/admin/model/entity/DiscoveryDO.java | 42 ++--
.../admin/service/impl/DiscoveryServiceImpl.java | 6 +-
.../service/impl/ProxySelectorServiceImpl.java | 4 +-
.../admin/service/impl/SelectorServiceImpl.java | 2 +-
.../shenyu/admin/transfer/DiscoveryTransfer.java | 4 +-
.../main/resources/mappers/discovery-sqlmap.xml | 28 +--
.../src/main/resources/sql-script/h2/schema.sql | 2 +-
17 files changed, 180 insertions(+), 170 deletions(-)
diff --git a/db/init/mysql/schema.sql b/db/init/mysql/schema.sql
index b53b60f703..03f36aa718 100644
--- a/db/init/mysql/schema.sql
+++ b/db/init/mysql/schema.sql
@@ -2337,7 +2337,7 @@ CREATE TABLE `discovery`
(
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'primary key id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'the discovery name',
- `level` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1 plugin 2 global',
+ `discovery_level` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1 plugin 2 global',
`plugin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci COMMENT 'the plugin name',
`namespace_id` varchar(50) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'namespace id',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'local,zookeeper,etcd,consul,nacos',
diff --git a/db/init/ob/schema.sql b/db/init/ob/schema.sql
index af8844e1eb..f63cdc5a79 100644
--- a/db/init/ob/schema.sql
+++ b/db/init/ob/schema.sql
@@ -2253,7 +2253,7 @@ CREATE TABLE `discovery`
(
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'primary key id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'the discovery name',
- `level` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1 plugin 2 global',
+ `discovery_level` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1 plugin 2 global',
`plugin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci COMMENT 'the plugin name',
`namespace_id` varchar(50) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'namespace id',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NOT NULL COMMENT 'local,zookeeper,etcd,consul,nacos',
diff --git a/db/init/og/create-table.sql b/db/init/og/create-table.sql
index dab3540cdd..00b07a50fc 100644
--- a/db/init/og/create-table.sql
+++ b/db/init/og/create-table.sql
@@ -2388,7 +2388,7 @@ DROP TABLE IF EXISTS "public"."discovery";
CREATE TABLE "public"."discovery" (
"id" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
"name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
- "level" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "discovery_level" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"plugin_name" varchar(255) COLLATE "pg_catalog"."default",
"type" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"server_list" varchar(255) COLLATE "pg_catalog"."default",
@@ -2400,7 +2400,7 @@ CREATE TABLE "public"."discovery" (
;
COMMENT ON COLUMN "public"."discovery"."id" IS 'primary key id';
COMMENT ON COLUMN "public"."discovery"."name" IS 'the discovery name';
-COMMENT ON COLUMN "public"."discovery"."level" IS '0 selector,1 plugin 2
global';
+COMMENT ON COLUMN "public"."discovery"."discovery_level" IS '0 selector,1
plugin 2 global';
COMMENT ON COLUMN "public"."discovery"."plugin_name" IS 'the plugin name';
COMMENT ON COLUMN "public"."discovery"."type" IS
'local,zookeeper,etcd,consul,nacos';
COMMENT ON COLUMN "public"."discovery"."server_list" IS 'register server url
(,)';
diff --git a/db/init/oracle/schema.sql b/db/init/oracle/schema.sql
index 94abe6e059..47533be3eb 100644
--- a/db/init/oracle/schema.sql
+++ b/db/init/oracle/schema.sql
@@ -2474,7 +2474,7 @@ comment
on column TAG.id
is 'primary key id';
comment
-on column TAG.name
+on column TAG.tag_name
is 'tag name';
comment
on column TAG.tag_desc
@@ -2519,7 +2519,7 @@ create table discovery
(
id VARCHAR2(128) not null,
name VARCHAR2(255) not null,
- level VARCHAR2(64) not null,
+ discovery_level VARCHAR2(64) not null,
plugin_name VARCHAR2(255),
namespace_id VARCHAR2(50) not null,
type VARCHAR2(64) not null,
@@ -2534,7 +2534,7 @@ comment on column DISCOVERY.id
is 'primary key id';
comment on column DISCOVERY.name
is 'the discovery name';
-comment on column DISCOVERY.level
+comment on column DISCOVERY.discovery_level
is '0 selector,1 plugin 2 global';
comment on column DISCOVERY.plugin_name
is 'the plugin name';
@@ -2693,22 +2693,22 @@ create table alert_template
;
-- Add comments to the columns
comment
-on column ALTER_TEMPLATE.id
+on column ALERT_TEMPLATE.id
is 'primary key id';
comment
-on column ALTER_TEMPLATE.name
+on column ALERT_TEMPLATE.name
is 'alert template name';
comment
-on column ALTER_TEMPLATE.strategy_name
+on column ALERT_TEMPLATE.strategy_name
is 'alert template strategy name';
comment
-on column ALTER_TEMPLATE.content
+on column ALERT_TEMPLATE.content
is 'alert template content';
comment
-on column ALTER_TEMPLATE.date_created
+on column ALERT_TEMPLATE.date_created
is 'create time';
comment
-on column ALTER_TEMPLATE.date_updated
+on column ALERT_TEMPLATE.date_updated
is 'update time';
-- ----------------------------
@@ -2770,7 +2770,7 @@ comment
on column alert_receiver.levels
is 'alarm levels';
comment
-on column lert_receiver.namespace_id
+on column alert_receiver.namespace_id
is 'namespace id';
comment
on column alert_receiver.date_created
@@ -2816,22 +2816,22 @@ create table cluster_master
;
-- Add comments to the columns
comment
-on column alert_receiver.id
+on column cluster_master.id
is 'primary key id';
comment
-on column alert_receiver.master_host
+on column cluster_master.master_host
is 'master host';
comment
-on column alert_receiver.master_port
+on column cluster_master.master_port
is 'master port';
comment
-on column alert_receiver.context_path
+on column cluster_master.context_path
is 'master context_path';
comment
-on column alert_receiver.date_created
+on column cluster_master.date_created
is 'create time';
comment
-on column alert_receiver.date_updated
+on column cluster_master.date_updated
is 'update time';
@@ -2868,16 +2868,16 @@ COMMENT ON COLUMN namespace.description IS 'namespace
desc';
COMMENT ON COLUMN namespace.date_created IS 'create time';
COMMENT ON COLUMN namespace.date_updated IS 'update time';
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace(id)) */ INTO `namespace`
(`id`, `namespace_id`, `name`, `description`) VALUES ('1',
'649330b6-c2d7-4edc-be8e-8a54df9eb385', 'default', 'default-namespace');
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace(id)) */ INTO namespace (id,
namespace_id, name, description) VALUES ('1',
'649330b6-c2d7-4edc-be8e-8a54df9eb385', 'default', 'default-namespace');
CREATE TABLE namespace_plugin_rel (
- id VARCHAR2(128) COLLATE utf8mb4_unicode_ci NOT
NULL,
- namespace_id VARCHAR2(50) COLLATE
utf8mb4_unicode_ci NOT NULL,
- plugin_id VARCHAR2(128) COLLATE
utf8mb4_unicode_ci NOT NULL,
- config CLOB COLLATE utf8mb4_unicode_ci,
+ id VARCHAR2(128) NOT NULL,
+ namespace_id VARCHAR2(50) NOT NULL,
+ plugin_id VARCHAR2(128) NOT NULL,
+ config CLOB,
sort NUMBER(11),
- enabled NUMBER(4,0) NOT NULL DEFAULT 0 CHECK
(enabled IN (0, 1)),
+ enabled NUMBER(4,0) DEFAULT 0 NOT NULL CHECK
(enabled IN (0, 1)),
date_created timestamp(3) default SYSDATE
not null,
date_updated timestamp(3) default SYSDATE
not null,
CONSTRAINT pk_namespace_plugin_rel PRIMARY KEY
(id)
@@ -2990,9 +2990,9 @@ comment on column SCALE_POLICY.date_created
comment on column SCALE_POLICY.date_updated
is 'update time';
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('1', 3, 0, 10, NULL, NULL, '2024-07-31 20:00:00.000', '2024-07-31
20:00:00.000');
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('2', 2, 0, 10, '2024-07-31 20:00:00.000', '2024-08-01 20:00:00.000',
'2024-07-31 20:00:00.000', '2024-07-31 20:00:00.000');
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('3', 1, 0, NULL, NULL, NULL, '2024-07-31 20:00:00.000', '2024-07-31
20:00:00.000');
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('1', 3, 0, 10, NULL, NULL, to_timestamp('2024-07-31 20:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3'), to_timestamp('2024-07-31 20:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('2', 2, 0, 10, to_timestamp('2024-07-31 20:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2024-08-01 20:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2024-07-31 20:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2024-07-31 20:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (scale_policy(id)) */ INTO scale_policy
(id, sort, status, num, begin_time, end_time, date_created, date_updated)
VALUES ('3', 1, 0, NULL, NULL, NULL, to_timestamp('2024-07-31 20:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3'), to_timestamp('2024-07-31 20:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3'));
create table scale_rule
(
@@ -3074,34 +3074,34 @@ comment on column NAMESPACE_USER_REL.date_updated
is 'update time';
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534849', '1346775491550474240', 'aiProxy', 'aiProxy',
'/plug/aiProxy', 'aiProxy', 1, 0, 'pic-center', 0, 0, '', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534850', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxySelector:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534851', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxySelector:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534852', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxySelector:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534853', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxySelector:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534854', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxyRule:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534855', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxyRule:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534856', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxyRule:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534857', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxyRule:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534858', '1844026099075534849',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiProxy:modify', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(permission(id)) */ INTO permission (id,
object_id, resource_id)
@@ -3259,109 +3259,109 @@ VALUES ('1722804548510507142', '52', 'append',
'append', 2, 3, 3, '{"required":"
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin_handle(id)) */ INTO plugin_handle
(id, plugin_id, field, label, data_type, type, sort, ext_obj, date_created,
date_updated)
VALUES ('1722804548510507143', '52', 'postRole', 'postRole', 3, 3, 4,
'{"required":"0","rule":""}', to_timestamp('2024-01-02 17:20:50.233',
'YYYY-MM-DD HH24:MI:SS.FF3'), to_timestamp('2024-01-02 17:20:50.233',
'YYYY-MM-DD HH24:MI:SS.FF3'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554850', '1346775491550474240', 'aiPrompt', 'aiPrompt',
'/plug/aiPrompt', 'aiPrompt', 1, 0, 'pic-center', 0, 0, '', 1,
to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'),
to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554851', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptSelector:add', 1, to_timestamp('2022-05-25 18:02:58',
'YYYY-MM-DD HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554852', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptSelector:query', 1, to_timestamp('2022-05-25 18:02:58',
'YYYY-MM-DD HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554853', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptSelector:edit', 1, to_timestamp('2022-05-25 18:02:58',
'YYYY-MM-DD HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554854', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptSelector:delete', 1, to_timestamp('2022-05-25 18:02:58',
'YYYY-MM-DD HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554855', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptRule:add', 1, to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554856', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptRule:query', 1, to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554857', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptRule:edit', 1, to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554858', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPromptRule:delete', 1, to_timestamp('2022-05-25 18:02:58',
'YYYY-MM-DD HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026099075554859', '1844026099075554850',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiPrompt:modify', 1, to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2022-05-25 18:02:58', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565000', '1346775491550474240', 'aiResponseTransformer',
'aiResponseTransformer', '/plug/aiResponseTransformer',
'aiResponseTransformer', 1, 0, 'pic-center', 0, 0, '', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565001', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerSelector:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565002', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerSelector:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565003', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerSelector:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565004', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerSelector:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565005', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerRule:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565006', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerRule:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565007', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerRule:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565008', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformerRule:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075565009', '1844026099075565000',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiResponseTransformer:modify', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, desc, sort, enabled, date_created,
date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, "desc", sort, enabled,
date_created, date_updated)
VALUES ('1679002911061737580', 'preRole', 'ROLE_TYPE_SYSTEM', 'SYSTEM',
'system', 'system', 0, 1, to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, desc, sort, enabled, date_created,
date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, "desc", sort, enabled,
date_created, date_updated)
VALUES ('1679002911061737581', 'preRole', 'ROLE_TYPE_USER', 'USER', 'user',
'user', 1, 1, to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'),
to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, desc, sort, enabled, date_created,
date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, "desc", sort, enabled,
date_created, date_updated)
VALUES ('1679002911061737582', 'postRole', 'ROLE_TYPE_SYSTEM', 'SYSTEM',
'system', 'system', 0, 1, to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD
HH24:MI:SS'), to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, desc, sort, enabled, date_created,
date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(shenyu_dict(id)) */ INTO shenyu_dict
(id, type, dict_code, dict_name, dict_value, "desc", sort, enabled,
date_created, date_updated)
VALUES ('1679002911061737583', 'postRole', 'ROLE_TYPE_USER', 'USER', 'user',
'user', 1, 1, to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'),
to_timestamp('2024-02-07 14:31:49', 'YYYY-MM-DD HH24:MI:SS'));
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id, namespace_id, plugin_id, config, sort, enabled,
date_created, date_updated)
VALUES ('1801816010882822189', '649330b6-c2d7-4edc-be8e-8a54df9eb385', '52',
NULL, 171, 0, to_timestamp('2022-05-25 18:02:53', 'YYYY-MM-DD HH24:MI:SS'),
to_timestamp('2022-05-25 18:02:53', 'YYYY-MM-DD HH24:MI:SS'));
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534859', '1346775491550474240', 'aiTokenLimiter',
'aiTokenLimiter', '/plug/aiTokenLimiter', 'aiTokenLimiter', 1, 0, 'pic-center',
0, 0, '', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534860', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterSelector:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534861', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterSelector:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534862', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterSelector:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534863', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterSelector:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534864', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterRule:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534865', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterRule:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534866', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterRule:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534867', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiterRule:delete', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075534868', '1844026099075534859',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiTokenLimiter:modify', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(permission(id)) */ INTO permission (id,
object_id, resource_id)
@@ -3479,34 +3479,34 @@ VALUES ('1899702472330051584', '51', 'keyName',
'keyName', 2, 2, 2, '{"required"
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin_handle(id)) */ INTO plugin_handle
(id, plugin_id, field, label, data_type, type, sort, ext_obj, date_created,
date_updated)
VALUES ('1899702529972371456', '51', 'tokenLimit', 'tokenLimit', 1, 2, 3,
'{"required":"0","rule":""}', sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564859', '1346775491550474240', 'aiRequestTransformer',
'aiRequestTransformer', '/plug/aiRequestTransformer', 'aiRequestTransformer',
1, 0, 'pic-center', 0, 0, '', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564860', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerSelector:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564861', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerSelector:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564862', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerSelector:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564863', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerSelector:delete',1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564864', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerRule:add', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564865', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerRule:query', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564866', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerRule:edit', 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564867', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformerRule:delete',1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status)
VALUES ('1844026099075564868', '1844026099075564859',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:aiRequestTransformer:modify', 1);
@@ -3573,7 +3573,7 @@ VALUES ('1722804548510507249', '53', 'content',
'content', 2, 2, 4, '{"required"
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin_handle(id)) */ INTO plugin_handle
(id, plugin_id, field, label, data_type, type, sort, ext_obj, date_created,
date_updated)
VALUES ('1722804548510507240', '53', 'provider', 'provider', 3, 3, 0,
'{"required":"0","rule":""}', sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin(id)) */ INTO plugin (id, name,
ext_obj, type, sort, enabled, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin(id)) */ INTO plugin (id, name,
config, role, sort, enabled, date_created, date_updated)
VALUES ('61', 'mcpServer', NULL, 'MCP', 180, 0, sysdate, sysdate);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id, namespace_id, plugin_id, config, sort, enabled,
date_created, date_updated)
@@ -3582,39 +3582,39 @@ VALUES ('1801816010882832189',
'649330b6-c2d7-4edc-be8e-8a54df9eb385', '61', NUL
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(plugin_handle(id)) */ INTO plugin_handle
(id, plugin_id, field, label, data_type, type, sort, ext_obj, date_created,
date_updated)
VALUES ('1942847622591684608', '61', 'messageEndpoint', 'messageEndpoint', 2,
1, 0, '{"required":"0","defaultValue":"/message","rule":""}', sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534860', '1346775491550474240', 'mcpServer',
'mcpServer', '/plug/mcpServer', 'mcpServer', 1, 0, 'pic-left', 0, 0, '', 1,
sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534861', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.SELECTOR.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerSelector:add', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534862', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.SELECTOR.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerSelector:query', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534863', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.SELECTOR.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerSelector:edit', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534864', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.SELECTOR.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerSelector:delete', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534865', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.RULE.ADD', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerRule:add', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534866', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.RULE.QUERY', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerRule:query', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534867', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.RULE.EDIT', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerRule:edit', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534868', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.RULE.DELETE', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServerRule:delete', 1, sysdate, sysdate);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO resource (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ INTO "resource" (id,
parent_id, title, name, url, component, resource_type, sort, icon, is_leaf,
is_route, perms, status, date_created, date_updated)
VALUES ('1844026199075534869', '1844026199075534860',
'SHENYU.BUTTON.PLUGIN.SYNCHRONIZE', '', '', '', 2, 0, '', 1, 0,
'plugin:mcpServer:modify', 1, sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542751', '1346358560427216896', '1844026199075534860',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542752', '1346358560427216896', '1844026199075534861',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542753', '1346358560427216896', '1844026199075534862',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542754', '1346358560427216896', '1844026199075534863',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542755', '1346358560427216896', '1844026199075534864',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542756', '1346358560427216896', '1844026199075534865',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542757', '1346358560427216896', '1844026199075534866',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542758', '1346358560427216896', '1844026199075534867',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542759', '1346358560427216896', '1844026199075534868',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1697146861569542760', '1346358560427216896', '1844026199075534869',
sysdate, sysdate);
-
-CREATE TABLE "public"."registry_config" (
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542751', '1346358560427216896',
'1844026199075534860', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542752', '1346358560427216896',
'1844026199075534861', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542753', '1346358560427216896',
'1844026199075534862', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542754', '1346358560427216896',
'1844026199075534863', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542755', '1346358560427216896',
'1844026199075534864', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542756', '1346358560427216896',
'1844026199075534865', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542757', '1346358560427216896',
'1844026199075534866', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542758', '1346358560427216896',
'1844026199075534867', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542759', '1346358560427216896',
'1844026199075534868', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1697146861569542760', '1346358560427216896',
'1844026199075534869', sysdate, sysdate);
+
+CREATE TABLE registry_config (
id varchar2(128) NOT NULL,
registry_id varchar2(50) NOT NULL,
protocol varchar2(128) NOT NULL,
@@ -3640,19 +3640,19 @@ COMMENT ON COLUMN registry_config.registry_group IS
'group';
COMMENT ON COLUMN registry_config.date_created IS 'create time';
COMMENT ON COLUMN registry_config.date_updated IS 'update time';
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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 INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1953049887387303901', '1346358560427216896', '1953048313980116900',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1953049887387303902', '1346358560427216896', '1953048313980116901',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1953049887387303903', '1346358560427216896', '1953048313980116902',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1953049887387303904', '1346358560427216896', '1953048313980116903',
sysdate, sysdate);
-INSERT INTO permission (id, role_id, resource_id, date_created, date_updated)
VALUES ('1953049887387303905', '1346358560427216896', '1953048313980116904',
sysdate, sysdate);
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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, to_timestamp('2025-08-06
17:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF3'), to_timestamp('2025-08-06
17:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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, to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF3'),
to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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, to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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,to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'));
+INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(resource(id)) */ 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, to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'), to_timestamp('2025-08-06 17:00:00.000', 'YYYY-MM-DD
HH24:MI:SS.FF3'));
+
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1953049887387303901', '1346358560427216896',
'1953048313980116900', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1953049887387303902', '1346358560427216896',
'1953048313980116901', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1953049887387303903', '1346358560427216896',
'1953048313980116902', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1953049887387303904', '1346358560427216896',
'1953048313980116903', sysdate, sysdate);
+INSERT INTO permission (id, object_id, resource_id, date_created,
date_updated) VALUES ('1953049887387303905', '1346358560427216896',
'1953048313980116904', sysdate, sysdate);
\ No newline at end of file
diff --git a/db/init/pg/create-table.sql b/db/init/pg/create-table.sql
index fe6dddb901..a9afbf0f63 100644
--- a/db/init/pg/create-table.sql
+++ b/db/init/pg/create-table.sql
@@ -2515,7 +2515,7 @@ DROP TABLE IF EXISTS "public"."discovery";
CREATE TABLE "public"."discovery" (
"id" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
"name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
- "level" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "discovery_level" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"plugin_name" varchar(255) COLLATE "pg_catalog"."default",
"namespace_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
"type" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
@@ -2527,7 +2527,7 @@ CREATE TABLE "public"."discovery" (
;
COMMENT ON COLUMN "public"."discovery"."id" IS 'primary key id';
COMMENT ON COLUMN "public"."discovery"."name" IS 'the discovery name';
-COMMENT ON COLUMN "public"."discovery"."level" IS '0 selector,1 plugin 2
global';
+COMMENT ON COLUMN "public"."discovery"."discovery_level" IS '0 selector,1
plugin 2 global';
COMMENT ON COLUMN "public"."discovery"."plugin_name" IS 'the plugin name';
COMMENT ON COLUMN "public"."discovery"."namespace_id" IS 'the namespace id';
COMMENT ON COLUMN "public"."discovery"."type" IS
'local,zookeeper,etcd,consul,nacos';
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 9a600251b9..125bb16dd6 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
@@ -282,3 +282,5 @@ ALTER TABLE `rule` CHANGE COLUMN `sort` `sort_code` int(0)
NOT NULL COMMENT 'sor
ALTER TABLE `rule` CHANGE COLUMN `name` `rule_name` varchar(128) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'rule name';
ALTER TABLE `discovery_upstream` CHANGE COLUMN `url` `upstream_url`
varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT
'ip:port';
ALTER TABLE `discovery_upstream` CHANGE COLUMN `status` `upstream_status`
int(0) NOT NULL COMMENT 'type (0, healthy, 1 unhealthy)';
+
+ALTER TABLE `discovery` CHANGE COLUMN `level` `discovery_level` varchar(64)
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1
plugin 2 global';
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 5f24de28f8..157fdea787 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
@@ -276,4 +276,6 @@ ALTER TABLE `tag` CHANGE COLUMN `name` `tag_name`
varchar(128) CHARACTER SET utf
ALTER TABLE `rule` CHANGE COLUMN `sort` `sort_code` int(0) NOT NULL COMMENT
'sort';
ALTER TABLE `rule` CHANGE COLUMN `name` `rule_name` varchar(128) CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'rule name';
ALTER TABLE `discovery_upstream` CHANGE COLUMN `url` `upstream_url`
varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT
'ip:port';
-ALTER TABLE `discovery_upstream` CHANGE COLUMN `status` `upstream_status`
int(0) NOT NULL COMMENT 'type (0, healthy, 1 unhealthy)';
\ No newline at end of file
+ALTER TABLE `discovery_upstream` CHANGE COLUMN `status` `upstream_status`
int(0) NOT NULL COMMENT 'type (0, healthy, 1 unhealthy)';
+
+ALTER TABLE `discovery` CHANGE COLUMN `level` `discovery_level` varchar(64)
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 selector,1
plugin 2 global';
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 8477fb75dc..2d2b7fff7a 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
@@ -301,4 +301,6 @@ ALTER TABLE "public"."tag" RENAME COLUMN "name" TO
"tag_name";
ALTER TABLE "public"."rule" RENAME COLUMN "sort" TO "sort_code";
ALTER TABLE "public"."rule" RENAME COLUMN "name" TO "rule_name";
ALTER TABLE "public"."discovery_upstream" RENAME COLUMN "url" TO
"upstream_url";
-ALTER TABLE "public"."discovery_upstream" RENAME COLUMN "status" TO
"upstream_status";
\ No newline at end of file
+ALTER TABLE "public"."discovery_upstream" RENAME COLUMN "status" TO
"upstream_status";
+
+ALTER TABLE "public"."discovery" RENAME COLUMN "level" TO "discovery_level";
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 0925b3ebd2..d1c796bf9d 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
@@ -590,3 +590,5 @@ ALTER TABLE rule RENAME COLUMN "sort" TO "sort_code";
ALTER TABLE rule RENAME COLUMN "name" TO "rule_name";
ALTER TABLE discovery_upstream RENAME COLUMN "url" TO "upstream_url";
ALTER TABLE discovery_upstream RENAME COLUMN "status" TO "upstream_status";
+
+ALTER TABLE discovery RENAME COLUMN "level" TO discovery_level;
\ No newline at end of file
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 8973d36445..4e2d1f6ea2 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
@@ -298,3 +298,5 @@ ALTER TABLE "public"."rule" RENAME COLUMN "sort" TO
"sort_code";
ALTER TABLE "public"."rule" RENAME COLUMN "name" TO "rule_name";
ALTER TABLE "public"."discovery_upstream" RENAME COLUMN "url" TO
"upstream_url";
ALTER TABLE "public"."discovery_upstream" RENAME COLUMN "status" TO
"upstream_status";
+
+ALTER TABLE "public"."discovery" RENAME COLUMN "level" TO "discovery_level";
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/DiscoveryDO.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/DiscoveryDO.java
index c7fb20af2d..f88f140183 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/DiscoveryDO.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/model/entity/DiscoveryDO.java
@@ -29,7 +29,7 @@ public final class DiscoveryDO extends BaseDO {
private String type;
- private String level;
+ private String discoveryLevel;
private String serverList;
@@ -43,23 +43,23 @@ public final class DiscoveryDO extends BaseDO {
}
- public DiscoveryDO(final String name, final String type, final String
level, final String serverList,
+ public DiscoveryDO(final String name, final String type, final String
discoveryLevel, final String serverList,
final String pluginName, final String props) {
this.name = name;
this.type = type;
- this.level = level;
+ this.discoveryLevel = discoveryLevel;
this.serverList = serverList;
this.pluginName = pluginName;
this.props = props;
}
public DiscoveryDO(final String id, final Timestamp dateCreated, final
Timestamp dateUpdated, final String name,
- final String type, final String level, final String
serverList, final String pluginName,
+ final String type, final String discoveryLevel, final
String serverList, final String pluginName,
final String props) {
super(id, dateCreated, dateUpdated);
this.name = name;
this.type = type;
- this.level = level;
+ this.discoveryLevel = discoveryLevel;
this.serverList = serverList;
this.pluginName = pluginName;
this.props = props;
@@ -102,21 +102,21 @@ public final class DiscoveryDO extends BaseDO {
}
/**
- * get the level.
+ * get the discovery level.
*
- * @return the level.
+ * @return the discovery level.
*/
- public String getLevel() {
- return level;
+ public String getDiscoveryLevel() {
+ return discoveryLevel;
}
/**
- * set the level.
+ * set the discovery level.
*
- * @param level the level.
+ * @param discoveryLevel the level.
*/
- public void setLevel(final String level) {
- this.level = level;
+ public void setDiscoveryLevel(final String discoveryLevel) {
+ this.discoveryLevel = discoveryLevel;
}
/**
@@ -214,7 +214,7 @@ public final class DiscoveryDO extends BaseDO {
DiscoveryDO discoveryDO = (DiscoveryDO) o;
return Objects.equals(name, discoveryDO.name)
&& Objects.equals(type, discoveryDO.type)
- && Objects.equals(level, discoveryDO.level)
+ && Objects.equals(discoveryLevel, discoveryDO.discoveryLevel)
&& Objects.equals(serverList, discoveryDO.serverList)
&& Objects.equals(pluginName, discoveryDO.pluginName)
&& Objects.equals(props, discoveryDO.props)
@@ -223,7 +223,7 @@ public final class DiscoveryDO extends BaseDO {
@Override
public int hashCode() {
- return Objects.hash(super.hashCode(), name, type, level, serverList,
pluginName, props, namespaceId);
+ return Objects.hash(super.hashCode(), name, type, discoveryLevel,
serverList, pluginName, props, namespaceId);
}
public static final class DiscoveryDOBuilder {
@@ -238,7 +238,7 @@ public final class DiscoveryDO extends BaseDO {
private String type;
- private String level;
+ private String discoveryLevel;
private String serverList;
@@ -308,13 +308,13 @@ public final class DiscoveryDO extends BaseDO {
}
/**
- * level.
+ * discovery level.
*
- * @param level the level.
+ * @param discoveryLevel the discovery level.
* @return DiscoveryDOBuilder.
*/
- public DiscoveryDOBuilder level(final String level) {
- this.level = level;
+ public DiscoveryDOBuilder discoveryLevel(final String discoveryLevel) {
+ this.discoveryLevel = discoveryLevel;
return this;
}
@@ -375,7 +375,7 @@ public final class DiscoveryDO extends BaseDO {
discoveryDO.setDateUpdated(dateUpdated);
discoveryDO.setName(name);
discoveryDO.setType(type);
- discoveryDO.setLevel(level);
+ discoveryDO.setDiscoveryLevel(discoveryLevel);
discoveryDO.setServerList(serverList);
discoveryDO.setPluginName(pluginName);
discoveryDO.setProps(props);
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/DiscoveryServiceImpl.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/DiscoveryServiceImpl.java
index f253c89abc..dc4264aab6 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/DiscoveryServiceImpl.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/DiscoveryServiceImpl.java
@@ -155,7 +155,7 @@ public class DiscoveryServiceImpl implements
DiscoveryService {
.id(UUIDUtils.getInstance().generateShortUuid())
.name(discoveryConfigRegisterDTO.getName())
.pluginName(discoveryConfigRegisterDTO.getPluginName())
- .level(DiscoveryLevel.PLUGIN.getCode())
+ .discoveryLevel(DiscoveryLevel.PLUGIN.getCode())
.type(discoveryConfigRegisterDTO.getDiscoveryType())
.serverList(discoveryConfigRegisterDTO.getServerList())
.props(GsonUtils.getInstance().toJson(Optional.ofNullable(discoveryConfigRegisterDTO.getProps()).orElse(new
Properties())))
@@ -212,7 +212,7 @@ public class DiscoveryServiceImpl implements
DiscoveryService {
.name(discoveryDTO.getName())
.pluginName(discoveryDTO.getPluginName())
.namespaceId(discoveryDTO.getNamespaceId())
- .level(discoveryDTO.getLevel())
+ .discoveryLevel(discoveryDTO.getLevel())
.type(discoveryDTO.getType())
.serverList(discoveryDTO.getServerList())
.props(discoveryDTO.getProps())
@@ -369,7 +369,7 @@ public class DiscoveryServiceImpl implements
DiscoveryService {
}
DiscoveryDO discoveryDO = new DiscoveryDO();
String discoveryId = UUIDUtils.getInstance().generateShortUuid();
- discoveryDO.setLevel(DiscoveryLevel.SELECTOR.getCode());
+ discoveryDO.setDiscoveryLevel(DiscoveryLevel.SELECTOR.getCode());
discoveryDO.setName(pluginName + "_default_discovery");
discoveryDO.setPluginName(pluginName);
discoveryDO.setType(DiscoveryMode.LOCAL.name().toLowerCase());
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/ProxySelectorServiceImpl.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/ProxySelectorServiceImpl.java
index ec0d932c49..0bf4fa71fe 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/ProxySelectorServiceImpl.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/ProxySelectorServiceImpl.java
@@ -179,7 +179,7 @@ public class ProxySelectorServiceImpl implements
ProxySelectorService {
DiscoveryDO discoveryDO =
discoveryMapper.selectById(discoveryHandlerDO.getDiscoveryId());
DiscoveryProcessor discoveryProcessor =
discoveryProcessorHolder.chooseProcessor(discoveryDO.getType());
discoveryProcessor.removeProxySelector(DiscoveryTransfer.INSTANCE.mapToDTO(discoveryHandlerDO),
DiscoveryTransfer.INSTANCE.mapToDTO(proxySelectorDO));
- if
(DiscoveryLevel.SELECTOR.getCode().equals(discoveryDO.getLevel())) {
+ if
(DiscoveryLevel.SELECTOR.getCode().equals(discoveryDO.getDiscoveryLevel())) {
discoveryProcessor.removeDiscovery(discoveryDO);
discoveryMapper.delete(discoveryDO.getId());
}
@@ -286,7 +286,7 @@ public class ProxySelectorServiceImpl implements
ProxySelectorService {
.serverList(proxySelectorAddDTO.getDiscovery().getServerList())
.pluginName(proxySelectorAddDTO.getPluginName())
.namespaceId(proxySelectorAddDTO.getNamespaceId())
- .level(DiscoveryLevel.SELECTOR.getCode())
+ .discoveryLevel(DiscoveryLevel.SELECTOR.getCode())
.dateCreated(currentTime)
.dateUpdated(currentTime)
.props(proxySelectorAddDTO.getDiscovery().getProps())
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/SelectorServiceImpl.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/SelectorServiceImpl.java
index db4422515d..23e95abe90 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/SelectorServiceImpl.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/service/impl/SelectorServiceImpl.java
@@ -306,7 +306,7 @@ public class SelectorServiceImpl implements SelectorService
{
proxySelectorDTO.setPluginName(pluginMap.getOrDefault(selector.getPluginId(),
""));
proxySelectorDTO.setNamespaceId(selector.getNamespaceId());
discoveryProcessor.removeProxySelector(DiscoveryTransfer.INSTANCE.mapToDTO(discoveryHandlerDO),
proxySelectorDTO);
- if
(DiscoveryLevel.SELECTOR.getCode().equals(discoveryDO.getLevel())) {
+ if
(DiscoveryLevel.SELECTOR.getCode().equals(discoveryDO.getDiscoveryLevel())) {
discoveryProcessor.removeDiscovery(discoveryDO);
discoveryProcessor.removeSelectorUpstream(proxySelectorDTO);
discoveryMapper.delete(discoveryDO.getId());
diff --git
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/DiscoveryTransfer.java
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/DiscoveryTransfer.java
index 068b8eca81..faf2249036 100644
---
a/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/DiscoveryTransfer.java
+++
b/shenyu-admin/src/main/java/org/apache/shenyu/admin/transfer/DiscoveryTransfer.java
@@ -136,7 +136,7 @@ public enum DiscoveryTransfer {
discoveryVO.setName(data.getName());
discoveryVO.setNamespaceId(data.getNamespaceId());
discoveryVO.setType(data.getType());
- discoveryVO.setLevel(data.getLevel());
+ discoveryVO.setLevel(data.getDiscoveryLevel());
discoveryVO.setServerList(data.getServerList());
discoveryVO.setPluginName(data.getPluginName());
discoveryVO.setProps(data.getProps());
@@ -150,7 +150,7 @@ public enum DiscoveryTransfer {
discoveryDTO.setId(data.getId());
discoveryDTO.setName(data.getName());
discoveryDTO.setType(data.getType());
- discoveryDTO.setLevel(data.getLevel());
+ discoveryDTO.setLevel(data.getDiscoveryLevel());
discoveryDTO.setServerList(data.getServerList());
discoveryDTO.setPluginName(data.getPluginName());
discoveryDTO.setProps(data.getProps());
diff --git a/shenyu-admin/src/main/resources/mappers/discovery-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/discovery-sqlmap.xml
index a1f8b34799..56cfbf0328 100644
--- a/shenyu-admin/src/main/resources/mappers/discovery-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/discovery-sqlmap.xml
@@ -24,7 +24,7 @@
<result column="date_updated" jdbcType="TIMESTAMP"
property="dateUpdated"/>
<result column="name" jdbcType="VARCHAR" property="name"/>
<result column="type" jdbcType="VARCHAR" property="type"/>
- <result column="level" jdbcType="VARCHAR" property="level"/>
+ <result column="discovery_level" jdbcType="VARCHAR"
property="discoveryLevel"/>
<result column="server_list" jdbcType="VARCHAR" property="serverList"/>
<result column="plugin_name" jdbcType="VARCHAR" property="pluginName"/>
<result column="props" jdbcType="LONGVARCHAR" property="props"/>
@@ -37,7 +37,7 @@
date_updated,
name,
type,
- level,
+ discovery_level,
server_list,
plugin_name,
props,
@@ -61,14 +61,14 @@
SELECT
<include refid="Base_Column_List"/>
FROM discovery
- WHERE plugin_name = #{pluginName, jdbcType=VARCHAR} AND level =
#{level, jdbcType=VARCHAR} AND namespace_id = #{namespaceId, jdbcType=VARCHAR}
+ WHERE plugin_name = #{pluginName, jdbcType=VARCHAR} AND
discovery_level = #{level, jdbcType=VARCHAR} AND namespace_id = #{namespaceId,
jdbcType=VARCHAR}
</select>
<select id="selectByPluginNameAndLevelAndNamespaceIdAndType"
parameterType="java.lang.String" resultMap="BaseResultMap">
SELECT
<include refid="Base_Column_List"/>
FROM discovery
- WHERE plugin_name = #{pluginName, jdbcType=VARCHAR} AND level =
#{level, jdbcType=VARCHAR} AND namespace_id = #{namespaceId, jdbcType=VARCHAR}
+ WHERE plugin_name = #{pluginName, jdbcType=VARCHAR} AND
discovery_level = #{level, jdbcType=VARCHAR} AND namespace_id = #{namespaceId,
jdbcType=VARCHAR}
AND type = #{discoveryType, jdbcType=VARCHAR}
</select>
@@ -102,7 +102,7 @@
d.date_updated,
d.name,
d.type,
- d.level,
+ d.discovery_level,
d.server_list,
d.plugin_name,
d.props,
@@ -122,7 +122,7 @@
date_updated,
name,
type,
- level,
+ discovery_level,
server_list,
plugin_name,
props,
@@ -133,7 +133,7 @@
#{dateUpdated, jdbcType=TIMESTAMP},
#{name, jdbcType=VARCHAR},
#{type, jdbcType=VARCHAR},
- #{level, jdbcType=VARCHAR},
+ #{discoveryLevel, jdbcType=VARCHAR},
#{serverList, jdbcType=VARCHAR},
#{pluginName, jdbcType=VARCHAR},
#{props, jdbcType=LONGVARCHAR},
@@ -156,8 +156,8 @@
<if test="type != null">
type,
</if>
- <if test="level != null">
- level,
+ <if test="discoveryLevel != null">
+ discovery_level,
</if>
<if test="serverList != null">
server_list,
@@ -186,8 +186,8 @@
<if test="type != null">
#{type, jdbcType=VARCHAR},
</if>
- <if test="level != null">
- #{level, jdbcType=VARCHAR},
+ <if test="discoveryLevel != null">
+ #{discoveryLevel, jdbcType=VARCHAR},
</if>
<if test="serverList != null">
#{serverList, jdbcType=VARCHAR},
@@ -210,7 +210,7 @@
date_updated = #{dateUpdated, jdbcType=TIMESTAMP},
name = #{name, jdbcType=VARCHAR},
type = #{type, jdbcType=VARCHAR},
- level = #{level, jdbcType=VARCHAR},
+ discovery_level = #{discoveryLevel, jdbcType=VARCHAR},
server_list = #{serverList, jdbcType=VARCHAR},
plugin_name = #{pluginName, jdbcType=VARCHAR},
props = #{props, jdbcType=LONGVARCHAR}
@@ -232,8 +232,8 @@
<if test="type != null">
type = #{type, jdbcType=VARCHAR},
</if>
- <if test="level != null">
- level = #{level, jdbcType=VARCHAR},
+ <if test="discoveryLevel != null">
+ discovery_level = #{discoveryLevel, jdbcType=VARCHAR},
</if>
<if test="serverList != null">
server_list = #{serverList, jdbcType=VARCHAR},
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 a15878ad26..7e6ddaf5fb 100644
--- a/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
+++ b/shenyu-admin/src/main/resources/sql-script/h2/schema.sql
@@ -1186,7 +1186,7 @@ CREATE TABLE IF NOT EXISTS `discovery`
(
`id` varchar(128) NOT NULL COMMENT 'primary key id',
`name` varchar(255) NOT NULL COMMENT 'the discovery name',
- `level` varchar(64) NOT NULL COMMENT '0 selector,1 plugin 2
global',
+ `discovery_level` varchar(64) NOT NULL COMMENT '0 selector,1
plugin 2 global',
`plugin_name` varchar(255) COMMENT 'the plugin name',
`namespace_id` varchar(50) NOT NULL COMMENT 'namespace id',
`type` varchar(64) NOT NULL COMMENT
'local,zookeeper,etcd,consul,nacos',
