This is an automated email from the ASF dual-hosted git repository.
lvshaokang pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git
The following commit(s) were added to refs/heads/dev by this push:
new bc8d06de3 [Improve] Improve the permissions corresponding to roles in
the upgrade script #2654 (#2655)
bc8d06de3 is described below
commit bc8d06de3bef9d98bebaead3f85196c30b960a61
Author: macksonmu <[email protected]>
AuthorDate: Wed Apr 19 10:54:01 2023 +0800
[Improve] Improve the permissions corresponding to roles in the upgrade
script #2654 (#2655)
---
.../main/assembly/script/upgrade/mysql/2.1.0.sql | 118 ++++++++++++++++++++-
.../main/assembly/script/upgrade/pgsql/2.1.0.sql | 116 ++++++++++++++++++++
2 files changed, 233 insertions(+), 1 deletion(-)
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
index 2c965ce40..4a0ae0b7d 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
@@ -50,7 +50,7 @@ alter table `t_flink_log` add column `option_name` tinyint
default null;
alter table `t_flink_savepoint` modify column `path` varchar(1024) collate
utf8mb4_general_ci default null;
-- menu script
-delete from t_menu;
+delete from `t_menu`;
-- menu level 1
insert into `t_menu` values (110000, 0, 'menu.system', '/system', 'PageView',
null, 'desktop', '0', 1, 1, now(), now());
insert into `t_menu` values (120000, 0, 'StreamPark', '/flink', 'PageView',
null, 'build', '0', 1, 2, now(), now());
@@ -204,18 +204,76 @@ update `t_role_menu` set menu_id=130000 where
menu_id=100033;
update `t_role_menu` set menu_id=130401 where menu_id=100040;
update `t_role_menu` set menu_id=130402 where menu_id=100041;
+delete from `t_role_menu` where role_id=100001 and menu_id=120000;
+delete from `t_role_menu` where role_id=100001 and menu_id=120100;
+delete from `t_role_menu` where role_id=100001 and menu_id=120101;
+delete from `t_role_menu` where role_id=100001 and menu_id=120102;
delete from `t_role_menu` where role_id=100001 and menu_id=120104;
+delete from `t_role_menu` where role_id=100001 and menu_id=120105;
+delete from `t_role_menu` where role_id=100001 and menu_id=120200;
+delete from `t_role_menu` where role_id=100001 and menu_id=120201;
+delete from `t_role_menu` where role_id=100001 and menu_id=120202;
+delete from `t_role_menu` where role_id=100001 and menu_id=120203;
+delete from `t_role_menu` where role_id=100001 and menu_id=120204;
+delete from `t_role_menu` where role_id=100001 and menu_id=120206;
+delete from `t_role_menu` where role_id=100001 and menu_id=120207;
+delete from `t_role_menu` where role_id=100001 and menu_id=120208;
+delete from `t_role_menu` where role_id=100001 and menu_id=120209;
+delete from `t_role_menu` where role_id=100001 and menu_id=120210;
+delete from `t_role_menu` where role_id=100001 and menu_id=120211;
+delete from `t_role_menu` where role_id=100001 and menu_id=120212;
+delete from `t_role_menu` where role_id=100001 and menu_id=120213;
delete from `t_role_menu` where role_id=100001 and menu_id=120215;
+delete from `t_role_menu` where role_id=100001 and menu_id=120216;
delete from `t_role_menu` where role_id=100001 and menu_id=120217;
+delete from `t_role_menu` where role_id=100001 and menu_id=120300;
+delete from `t_role_menu` where role_id=100001 and menu_id=120304;
+delete from `t_role_menu` where role_id=100001 and menu_id=120306;
+delete from `t_role_menu` where role_id=100001 and menu_id=120307;
delete from `t_role_menu` where role_id=100001 and menu_id=130000;
delete from `t_role_menu` where role_id=100001 and menu_id=130100;
delete from `t_role_menu` where role_id=100001 and menu_id=130101;
+delete from `t_role_menu` where role_id=100002 and menu_id=110000;
+delete from `t_role_menu` where role_id=100002 and menu_id=110600;
+delete from `t_role_menu` where role_id=100002 and menu_id=110601;
+delete from `t_role_menu` where role_id=100002 and menu_id=110602;
+delete from `t_role_menu` where role_id=100002 and menu_id=110603;
+delete from `t_role_menu` where role_id=100002 and menu_id=110604;
+delete from `t_role_menu` where role_id=100002 and menu_id=110605;
+delete from `t_role_menu` where role_id=100002 and menu_id=120000;
+delete from `t_role_menu` where role_id=100002 and menu_id=120100;
+delete from `t_role_menu` where role_id=100002 and menu_id=120101;
+delete from `t_role_menu` where role_id=100002 and menu_id=120102;
delete from `t_role_menu` where role_id=100002 and menu_id=120103;
delete from `t_role_menu` where role_id=100002 and menu_id=120104;
+delete from `t_role_menu` where role_id=100002 and menu_id=120105;
+delete from `t_role_menu` where role_id=100002 and menu_id=120200;
+delete from `t_role_menu` where role_id=100002 and menu_id=120201;
+delete from `t_role_menu` where role_id=100002 and menu_id=120202;
+delete from `t_role_menu` where role_id=100002 and menu_id=120203;
+delete from `t_role_menu` where role_id=100002 and menu_id=120204;
delete from `t_role_menu` where role_id=100002 and menu_id=120205;
+delete from `t_role_menu` where role_id=100002 and menu_id=120206;
+delete from `t_role_menu` where role_id=100002 and menu_id=120207;
+delete from `t_role_menu` where role_id=100002 and menu_id=120208;
+delete from `t_role_menu` where role_id=100002 and menu_id=120209;
+delete from `t_role_menu` where role_id=100002 and menu_id=120210;
+delete from `t_role_menu` where role_id=100002 and menu_id=120211;
+delete from `t_role_menu` where role_id=100002 and menu_id=120212;
+delete from `t_role_menu` where role_id=100002 and menu_id=120213;
+delete from `t_role_menu` where role_id=100002 and menu_id=120214;
delete from `t_role_menu` where role_id=100002 and menu_id=120215;
+delete from `t_role_menu` where role_id=100002 and menu_id=120216;
delete from `t_role_menu` where role_id=100002 and menu_id=120217;
delete from `t_role_menu` where role_id=100002 and menu_id=120218;
+delete from `t_role_menu` where role_id=100002 and menu_id=120300;
+delete from `t_role_menu` where role_id=100002 and menu_id=120301;
+delete from `t_role_menu` where role_id=100002 and menu_id=120302;
+delete from `t_role_menu` where role_id=100002 and menu_id=120303;
+delete from `t_role_menu` where role_id=100002 and menu_id=120304;
+delete from `t_role_menu` where role_id=100002 and menu_id=120305;
+delete from `t_role_menu` where role_id=100002 and menu_id=120306;
+delete from `t_role_menu` where role_id=100002 and menu_id=120307;
delete from `t_role_menu` where role_id=100002 and menu_id=130000;
delete from `t_role_menu` where role_id=100002 and menu_id=130100;
delete from `t_role_menu` where role_id=100002 and menu_id=130101;
@@ -234,18 +292,76 @@ delete from `t_role_menu` where role_id=100002 and
menu_id=130601;
delete from `t_role_menu` where role_id=100002 and menu_id=130602;
delete from `t_role_menu` where role_id=100002 and menu_id=130603;
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120000);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120100);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120101);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120102);
insert into `t_role_menu` (role_id, menu_id) values (100001, 120104);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120105);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120200);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120201);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120202);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120203);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120204);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120206);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120207);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120208);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120209);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120210);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120211);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120212);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120213);
insert into `t_role_menu` (role_id, menu_id) values (100001, 120215);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120216);
insert into `t_role_menu` (role_id, menu_id) values (100001, 120217);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120300);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120304);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120306);
+insert into `t_role_menu` (role_id, menu_id) values (100001, 120307);
insert into `t_role_menu` (role_id, menu_id) values (100001, 130000);
insert into `t_role_menu` (role_id, menu_id) values (100001, 130100);
insert into `t_role_menu` (role_id, menu_id) values (100001, 130101);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110000);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110600);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110601);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110602);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110603);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110604);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 110605);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120000);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120100);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120101);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120102);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120103);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120104);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120105);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120200);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120201);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120202);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120203);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120204);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120205);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120206);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120207);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120208);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120209);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120210);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120211);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120212);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120213);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120214);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120215);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120216);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120217);
insert into `t_role_menu` (role_id, menu_id) values (100002, 120218);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120300);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120301);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120302);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120303);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120304);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120305);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120306);
+insert into `t_role_menu` (role_id, menu_id) values (100002, 120307);
insert into `t_role_menu` (role_id, menu_id) values (100002, 130000);
insert into `t_role_menu` (role_id, menu_id) values (100002, 130100);
insert into `t_role_menu` (role_id, menu_id) values (100002, 130101);
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
index f4813d526..192b60cad 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
@@ -211,18 +211,76 @@ update "public"."t_role_menu" set menu_id=130000 where
menu_id=100033;
update "public"."t_role_menu" set menu_id=130401 where menu_id=100040;
update "public"."t_role_menu" set menu_id=130402 where menu_id=100041;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120000;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120100;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120101;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120102;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=120104;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120105;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120200;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120201;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120202;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120203;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120204;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120206;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120207;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120208;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120209;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120210;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120211;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120212;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120213;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=120215;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120216;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=120217;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120300;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120304;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120306;
+delete from "public"."t_role_menu" where role_id=100001 and menu_id=120307;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=130000;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=130100;
delete from "public"."t_role_menu" where role_id=100001 and menu_id=130101;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110000;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110600;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110601;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110602;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110603;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110604;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=110605;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120000;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120100;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120101;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120102;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120103;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120104;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120105;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120200;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120201;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120202;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120203;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120204;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120205;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120206;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120207;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120208;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120209;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120210;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120211;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120212;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120213;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120214;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120215;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120216;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120217;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=120218;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120300;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120301;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120302;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120303;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120304;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120305;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120306;
+delete from "public"."t_role_menu" where role_id=100002 and menu_id=120307;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=130000;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=130100;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=130101;
@@ -241,18 +299,76 @@ delete from "public"."t_role_menu" where role_id=100002
and menu_id=130601;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=130602;
delete from "public"."t_role_menu" where role_id=100002 and menu_id=130603;
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120000);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120100);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120101);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120102);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120104);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120105);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120200);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120201);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120202);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120203);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120204);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120206);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120207);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120208);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120209);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120210);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120211);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120212);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120213);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120215);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120216);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120217);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120300);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120304);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120306);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 120307);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 130000);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 130100);
insert into "public"."t_role_menu" (role_id, menu_id) values (100001, 130101);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110000);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110600);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110601);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110602);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110603);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110604);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 110605);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120000);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120100);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120101);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120102);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120103);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120104);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120105);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120200);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120201);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120202);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120203);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120204);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120205);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120206);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120207);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120208);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120209);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120210);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120211);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120212);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120213);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120214);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120215);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120216);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120217);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120218);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120300);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120301);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120302);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120303);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120304);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120305);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120306);
+insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 120307);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 130000);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 130100);
insert into "public"."t_role_menu" (role_id, menu_id) values (100002, 130101);
