This is an automated email from the ASF dual-hosted git repository.
benjobs 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 173a9d6b9 [Bug] postgresql syntax error #2645 (#2646)
173a9d6b9 is described below
commit 173a9d6b9e09ce61f872eb3cbda5666f4a89d7cc
Author: macksonmu <[email protected]>
AuthorDate: Mon Apr 17 22:26:05 2023 +0800
[Bug] postgresql syntax error #2645 (#2646)
---
.../src/main/assembly/script/data/pgsql-data.sql | 162 ++++++++++----------
.../main/assembly/script/schema/pgsql-schema.sql | 4 +-
.../main/assembly/script/upgrade/pgsql/2.1.0.sql | 164 ++++++++++-----------
3 files changed, 165 insertions(+), 165 deletions(-)
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql
index 15da80803..eed4bd335 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql
@@ -46,87 +46,87 @@ insert into "public"."t_flink_sql" values (100000, 100000,
'eNqlUUtPhDAQvu+vmFs1
-- ----------------------------
-- Records of t_menu
-- ----------------------------
-insert into "public"."t_menu" values (110000, 0, 'menu.system', '/system',
'PageView', null, 'desktop', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (120000, 0, 'StreamPark', '/flink',
'PageView', null, 'build', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (130000, 0, 'menu.setting', '/setting',
'PageView', null, 'setting', '0', 1, 5, now(), now());
-insert into "public"."t_menu" values (110100, 110000, 'menu.userManagement',
'/system/user', 'system/user/User', null, 'user', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (110200, 110000, 'menu.roleManagement',
'/system/role', 'system/role/Role', null, 'smile', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (110300, 110000, 'menu.menuManagement',
'/system/menu', 'system/menu/Menu', 'menu:view', 'bars', '0', 1, 3, now(),
now());
-insert into "public"."t_menu" values (110400, 110000, 'menu.tokenManagement',
'/system/token', 'system/token/Token', null, 'lock', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (110500, 110000, 'menu.teamManagement',
'/system/team', 'system/team/Team', null, 'team', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (110600, 110000, 'menu.memberManagement',
'/system/member', 'system/member/Member', null, 'usergroup-add', '0', 1, 2,
now(), now());
-insert into "public"."t_menu" values (120100, 120000, 'menu.project',
'/flink/project', 'flink/project/View', null, 'github', '0', 1, 1, now(),
now());
-insert into "public"."t_menu" values (120200, 120000, 'menu.application',
'/flink/app', 'flink/app/View', null, 'mobile', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (120300, 120000, 'menu.variable',
'/flink/variable', 'flink/variable/View', null, 'code', '0', 1, 3, now(),
now());
-insert into "public"."t_menu" values (130100, 130000, 'setting.system',
'/setting/system', 'setting/System/index', null, 'database', '0', 1, 1, now(),
now());
-insert into "public"."t_menu" values (130200, 130000, 'setting.alarm',
'/setting/alarm', 'setting/Alarm/index', null, 'alert', '0', 1, 2, now(),
now());
-insert into "public"."t_menu" values (130300, 130000, 'setting.flinkHome',
'/setting/flinkHome', 'setting/FlinkHome/index', null, 'desktop', '0', 1, 3,
now(), now());
-insert into "public"."t_menu" values (130400, 130000, 'setting.flinkCluster',
'/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster',
'0', 1, 4, now(), now());
-insert into "public"."t_menu" values (130500, 130000, 'setting.externalLink',
'/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link',
'0', 1, 5, now(), now());
-insert into "public"."t_menu" values (130600, 130000, 'setting.yarnQueue',
'/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', 1,
6, now(), now());
-insert into "public"."t_menu" values (110101, 110100, 'add', null, null,
'user:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110102, 110100, 'update', null, null,
'user:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110103, 110100, 'delete', null, null,
'user:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110104, 110100, 'reset', null, null,
'user:reset', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110105, 110100, 'types', null, null,
'user:types', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110106, 110100, 'view', null, null,
'user:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110201, 110200, 'add', null, null,
'role:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110202, 110200, 'update', null, null,
'role:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110203, 110200, 'delete', null, null,
'role:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110204, 110200, 'view', null, null,
'role:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110401, 110400, 'add', null, null,
'token:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110402, 110400, 'delete', null, null,
'token:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110403, 110400, 'view', null, null,
'token:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110501, 110500, 'add', null, null,
'team:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110502, 110500, 'update', null, null,
'team:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110503, 110500, 'delete', null, null,
'team:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110504, 110500, 'view', null, null,
'team:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110601, 110600, 'add', null, null,
'member:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110602, 110600, 'update', null, null,
'member:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110603, 110600, 'delete', null, null,
'member:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110604, 110600, 'role view', null, null,
'role:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110605, 110600, 'view', null, null,
'member:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120101, 120100, 'add',
'/flink/project/add', 'flink/project/Add', 'project:create', '', '0', 0, null,
now(), now());
-insert into "public"."t_menu" values (120102, 120100, 'build', null, null,
'project:build', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120103, 120100, 'delete', null, null,
'project:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120104, 120100, 'edit',
'/flink/project/edit', 'flink/project/Edit', 'project:update', null, '0', 0,
null, now(), now());
-insert into "public"."t_menu" values (120105, 120100, 'view', null, null,
'project:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120201, 120200, 'add', '/flink/app/add',
'flink/app/Add', 'app:create', '', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (120202, 120200, 'detail app',
'/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', 0, null, now(),
now());
-insert into "public"."t_menu" values (120203, 120200, 'edit flink',
'/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', 0, null,
now(), now());
-insert into "public"."t_menu" values (120204, 120200, 'edit streampark',
'/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '',
'0', 0, null, now(), now());
-insert into "public"."t_menu" values (120205, 120200, 'mapping', null, null,
'app:mapping', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120206, 120200, 'release', null, null,
'app:release', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120207, 120200, 'start', null, null,
'app:start', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120208, 120200, 'clean', null, null,
'app:clean', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120209, 120200, 'cancel', null, null,
'app:cancel', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120210, 120200, 'savepoint delete',
null, null, 'savepoint:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120211, 120200, 'backup rollback', null,
null, 'backup:rollback', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120212, 120200, 'backup delete', null,
null, 'backup:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120213, 120200, 'conf delete', null,
null, 'conf:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120214, 120200, 'delete', null, null,
'app:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120215, 120200, 'copy', null, null,
'app:copy', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120216, 120200, 'view', null, null,
'app:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120217, 120200, 'savepoint trigger',
null, null, 'savepoint:trigger', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120218, 120200, 'sql delete', null,
null, 'sql:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120301, 120300, 'add', NULL, NULL,
'variable:add', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120302, 120300, 'update', NULL, NULL,
'variable:update', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120303, 120300, 'delete', NULL, NULL,
'variable:delete', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120304, 120300, 'depend apps',
'/flink/variable/depend_apps', 'flink/variable/DependApps',
'variable:depend_apps', '', '0', 0, NULL, now(), now());
-insert into "public"."t_menu" values (120305, 120300, 'show original', NULL,
NULL, 'variable:show_original', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120306, 120300, 'view', NULL, NULL,
'variable:view', NULL, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120307, 120300, 'depend view', null,
null, 'variable:depend_apps', null, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (130101, 130100, 'view', null, null,
'setting:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130102, 130100, 'setting update', null,
null, 'setting:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130401, 130400, 'add cluster',
'/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create',
'', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (130402, 130400, 'edit cluster',
'/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update',
'', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (130501, 130500, 'link view', null, null,
'externalLink:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130502, 130500, 'link create', null,
null, 'externalLink:create', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130503, 130500, 'link update', null,
null, 'externalLink:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130504, 130500, 'link delete', null,
null, 'externalLink:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130601, 130600, 'add yarn queue', null,
null, 'yarnQueue:create', '', '1', 0, null, now(), now());
-insert into "public"."t_menu" values (130602, 130600, 'edit yarn queue', null,
null, 'yarnQueue:update', '', '1', 0, null, now(), now());
-insert into "public"."t_menu" values (130603, 130600, 'delete yarn queue',
null, null, 'yarnQueue:delete', '', '1', 0, null, now(), now());
+insert into "public"."t_menu" values (110000, 0, 'menu.system', '/system',
'PageView', null, 'desktop', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (120000, 0, 'StreamPark', '/flink',
'PageView', null, 'build', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (130000, 0, 'menu.setting', '/setting',
'PageView', null, 'setting', '0', '1', 5, now(), now());
+insert into "public"."t_menu" values (110100, 110000, 'menu.userManagement',
'/system/user', 'system/user/User', null, 'user', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (110200, 110000, 'menu.roleManagement',
'/system/role', 'system/role/Role', null, 'smile', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (110300, 110000, 'menu.menuManagement',
'/system/menu', 'system/menu/Menu', 'menu:view', 'bars', '0', '1', 3, now(),
now());
+insert into "public"."t_menu" values (110400, 110000, 'menu.tokenManagement',
'/system/token', 'system/token/Token', null, 'lock', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (110500, 110000, 'menu.teamManagement',
'/system/team', 'system/team/Team', null, 'team', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (110600, 110000, 'menu.memberManagement',
'/system/member', 'system/member/Member', null, 'usergroup-add', '0', '1', 2,
now(), now());
+insert into "public"."t_menu" values (120100, 120000, 'menu.project',
'/flink/project', 'flink/project/View', null, 'github', '0', '1', 1, now(),
now());
+insert into "public"."t_menu" values (120200, 120000, 'menu.application',
'/flink/app', 'flink/app/View', null, 'mobile', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (120300, 120000, 'menu.variable',
'/flink/variable', 'flink/variable/View', null, 'code', '0', '1', 3, now(),
now());
+insert into "public"."t_menu" values (130100, 130000, 'setting.system',
'/setting/system', 'setting/System/index', null, 'database', '0', '1', 1,
now(), now());
+insert into "public"."t_menu" values (130200, 130000, 'setting.alarm',
'/setting/alarm', 'setting/Alarm/index', null, 'alert', '0', '1', 2, now(),
now());
+insert into "public"."t_menu" values (130300, 130000, 'setting.flinkHome',
'/setting/flinkHome', 'setting/FlinkHome/index', null, 'desktop', '0', '1', 3,
now(), now());
+insert into "public"."t_menu" values (130400, 130000, 'setting.flinkCluster',
'/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster',
'0', '1', 4, now(), now());
+insert into "public"."t_menu" values (130500, 130000, 'setting.externalLink',
'/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link',
'0', '1', 5, now(), now());
+insert into "public"."t_menu" values (130600, 130000, 'setting.yarnQueue',
'/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', '1',
6, now(), now());
+insert into "public"."t_menu" values (110101, 110100, 'add', null, null,
'user:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110102, 110100, 'update', null, null,
'user:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110103, 110100, 'delete', null, null,
'user:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110104, 110100, 'reset', null, null,
'user:reset', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110105, 110100, 'types', null, null,
'user:types', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110106, 110100, 'view', null, null,
'user:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110201, 110200, 'add', null, null,
'role:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110202, 110200, 'update', null, null,
'role:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110203, 110200, 'delete', null, null,
'role:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110204, 110200, 'view', null, null,
'role:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110401, 110400, 'add', null, null,
'token:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110402, 110400, 'delete', null, null,
'token:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110403, 110400, 'view', null, null,
'token:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110501, 110500, 'add', null, null,
'team:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110502, 110500, 'update', null, null,
'team:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110503, 110500, 'delete', null, null,
'team:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110504, 110500, 'view', null, null,
'team:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110601, 110600, 'add', null, null,
'member:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110602, 110600, 'update', null, null,
'member:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110603, 110600, 'delete', null, null,
'member:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110604, 110600, 'role view', null, null,
'role:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110605, 110600, 'view', null, null,
'member:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120101, 120100, 'add',
'/flink/project/add', 'flink/project/Add', 'project:create', '', '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120102, 120100, 'build', null, null,
'project:build', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120103, 120100, 'delete', null, null,
'project:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120104, 120100, 'edit',
'/flink/project/edit', 'flink/project/Edit', 'project:update', null, '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120105, 120100, 'view', null, null,
'project:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120201, 120200, 'add', '/flink/app/add',
'flink/app/Add', 'app:create', '', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (120202, 120200, 'detail app',
'/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', '0', null,
now(), now());
+insert into "public"."t_menu" values (120203, 120200, 'edit flink',
'/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120204, 120200, 'edit streampark',
'/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '',
'0', '0', null, now(), now());
+insert into "public"."t_menu" values (120205, 120200, 'mapping', null, null,
'app:mapping', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120206, 120200, 'release', null, null,
'app:release', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120207, 120200, 'start', null, null,
'app:start', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120208, 120200, 'clean', null, null,
'app:clean', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120209, 120200, 'cancel', null, null,
'app:cancel', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120210, 120200, 'savepoint delete',
null, null, 'savepoint:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120211, 120200, 'backup rollback', null,
null, 'backup:rollback', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120212, 120200, 'backup delete', null,
null, 'backup:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120213, 120200, 'conf delete', null,
null, 'conf:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120214, 120200, 'delete', null, null,
'app:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120215, 120200, 'copy', null, null,
'app:copy', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120216, 120200, 'view', null, null,
'app:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120217, 120200, 'savepoint trigger',
null, null, 'savepoint:trigger', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120218, 120200, 'sql delete', null,
null, 'sql:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120301, 120300, 'add', NULL, NULL,
'variable:add', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120302, 120300, 'update', NULL, NULL,
'variable:update', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120303, 120300, 'delete', NULL, NULL,
'variable:delete', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120304, 120300, 'depend apps',
'/flink/variable/depend_apps', 'flink/variable/DependApps',
'variable:depend_apps', '', '0', '0', NULL, now(), now());
+insert into "public"."t_menu" values (120305, 120300, 'show original', NULL,
NULL, 'variable:show_original', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120306, 120300, 'view', NULL, NULL,
'variable:view', NULL, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120307, 120300, 'depend view', null,
null, 'variable:depend_apps', null, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (130101, 130100, 'view', null, null,
'setting:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130102, 130100, 'setting update', null,
null, 'setting:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130401, 130400, 'add cluster',
'/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create',
'', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (130402, 130400, 'edit cluster',
'/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update',
'', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (130501, 130500, 'link view', null, null,
'externalLink:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130502, 130500, 'link create', null,
null, 'externalLink:create', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130503, 130500, 'link update', null,
null, 'externalLink:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130504, 130500, 'link delete', null,
null, 'externalLink:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130601, 130600, 'add yarn queue', null,
null, 'yarnQueue:create', '', '1', '0', null, now(), now());
+insert into "public"."t_menu" values (130602, 130600, 'edit yarn queue', null,
null, 'yarnQueue:update', '', '1', '0', null, now(), now());
+insert into "public"."t_menu" values (130603, 130600, 'delete yarn queue',
null, null, 'yarnQueue:delete', '', '1', '0', null, now(), now());
-- ----------------------------
-- Records of t_role
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/schema/pgsql-schema.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/schema/pgsql-schema.sql
index a5a00e827..4f27373f2 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/schema/pgsql-schema.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/schema/pgsql-schema.sql
@@ -214,7 +214,7 @@ create table "public"."t_flink_app" (
"cluster_id" varchar(255) collate "pg_catalog"."default",
"k8s_namespace" varchar(255) collate "pg_catalog"."default",
"flink_image" varchar(255) collate "pg_catalog"."default",
- "state" int4 collate "pg_catalog"."default",
+ "state" int2,
"restart_size" int4,
"restart_count" int4,
"cp_threshold" int4,
@@ -256,7 +256,7 @@ create index "inx_job_type" on "public"."t_flink_app" using
btree (
"job_type" "pg_catalog"."int2_ops" asc nulls last
);
create index "inx_state" on "public"."t_flink_app" using btree (
- "state" collate "pg_catalog"."default" "pg_catalog"."text_ops" asc nulls last
+ "state" "pg_catalog"."int2_ops" asc nulls last
);
create index "inx_track" on "public"."t_flink_app" using btree (
"tracking" "pg_catalog"."int2_ops" asc nulls last
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 f2d6f66fd..f4813d526 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
@@ -39,7 +39,7 @@ create sequence "public"."streampark_t_yarn_queue_id_seq"
increment 1 start 1000
create table "public"."t_yarn_queue" (
"id" int8 not null default
nextval('streampark_t_yarn_queue_id_seq'::regclass),
- `team_id` int8 not null comment 'team id',
+ "team_id" int8 not null,
"queue_label" varchar(255) not null collate "pg_catalog"."default",
"description" varchar(512) collate "pg_catalog"."default",
"create_time" timestamp(6) not null default timezone('UTC-8'::text,
(now())::timestamp(0) without time zone),
@@ -61,87 +61,87 @@ ALTER TABLE public.t_flink_app ALTER COLUMN state TYPE int4
USING state::int4;
drop table if exists "public"."t_flink_tutorial";
delete from "public"."t_menu";
-insert into "public"."t_menu" values (110000, 0, 'menu.system', '/system',
'PageView', null, 'desktop', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (120000, 0, 'StreamPark', '/flink',
'PageView', null, 'build', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (130000, 0, 'menu.setting', '/setting',
'PageView', null, 'setting', '0', 1, 5, now(), now());
-insert into "public"."t_menu" values (110100, 110000, 'menu.userManagement',
'/system/user', 'system/user/User', null, 'user', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (110200, 110000, 'menu.roleManagement',
'/system/role', 'system/role/Role', null, 'smile', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (110300, 110000, 'menu.menuManagement',
'/system/menu', 'system/menu/Menu', 'menu:view', 'bars', '0', 1, 3, now(),
now());
-insert into "public"."t_menu" values (110400, 110000, 'menu.tokenManagement',
'/system/token', 'system/token/Token', null, 'lock', '0', 1, 1, now(), now());
-insert into "public"."t_menu" values (110500, 110000, 'menu.teamManagement',
'/system/team', 'system/team/Team', null, 'team', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (110600, 110000, 'menu.memberManagement',
'/system/member', 'system/member/Member', null, 'usergroup-add', '0', 1, 2,
now(), now());
-insert into "public"."t_menu" values (120100, 120000, 'menu.project',
'/flink/project', 'flink/project/View', null, 'github', '0', 1, 1, now(),
now());
-insert into "public"."t_menu" values (120200, 120000, 'menu.application',
'/flink/app', 'flink/app/View', null, 'mobile', '0', 1, 2, now(), now());
-insert into "public"."t_menu" values (120300, 120000, 'menu.variable',
'/flink/variable', 'flink/variable/View', null, 'code', '0', 1, 3, now(),
now());
-insert into "public"."t_menu" values (130100, 130000, 'setting.system',
'/setting/system', 'setting/System/index', null, 'database', '0', 1, 1, now(),
now());
-insert into "public"."t_menu" values (130200, 130000, 'setting.alarm',
'/setting/alarm', 'setting/Alarm/index', null, 'alert', '0', 1, 2, now(),
now());
-insert into "public"."t_menu" values (130300, 130000, 'setting.flinkHome',
'/setting/flinkHome', 'setting/FlinkHome/index', null, 'desktop', '0', 1, 3,
now(), now());
-insert into "public"."t_menu" values (130400, 130000, 'setting.flinkCluster',
'/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster',
'0', 1, 4, now(), now());
-insert into "public"."t_menu" values (130500, 130000, 'setting.externalLink',
'/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link',
'0', 1, 5, now(), now());
-insert into "public"."t_menu" values (130600, 130000, 'setting.yarnQueue',
'/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', 1,
6, now(), now());
-insert into "public"."t_menu" values (110101, 110100, 'add', null, null,
'user:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110102, 110100, 'update', null, null,
'user:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110103, 110100, 'delete', null, null,
'user:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110104, 110100, 'reset', null, null,
'user:reset', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110105, 110100, 'types', null, null,
'user:types', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110106, 110100, 'view', null, null,
'user:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110201, 110200, 'add', null, null,
'role:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110202, 110200, 'update', null, null,
'role:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110203, 110200, 'delete', null, null,
'role:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110204, 110200, 'view', null, null,
'role:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110401, 110400, 'add', null, null,
'token:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110402, 110400, 'delete', null, null,
'token:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110403, 110400, 'view', null, null,
'token:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110501, 110500, 'add', null, null,
'team:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110502, 110500, 'update', null, null,
'team:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110503, 110500, 'delete', null, null,
'team:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110504, 110500, 'view', null, null,
'team:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110601, 110600, 'add', null, null,
'member:add', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110602, 110600, 'update', null, null,
'member:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110603, 110600, 'delete', null, null,
'member:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110604, 110600, 'role view', null, null,
'role:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (110605, 110600, 'view', null, null,
'member:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120101, 120100, 'add',
'/flink/project/add', 'flink/project/Add', 'project:create', '', '0', 0, null,
now(), now());
-insert into "public"."t_menu" values (120102, 120100, 'build', null, null,
'project:build', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120103, 120100, 'delete', null, null,
'project:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120104, 120100, 'edit',
'/flink/project/edit', 'flink/project/Edit', 'project:update', null, '0', 0,
null, now(), now());
-insert into "public"."t_menu" values (120105, 120100, 'view', null, null,
'project:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120201, 120200, 'add', '/flink/app/add',
'flink/app/Add', 'app:create', '', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (120202, 120200, 'detail app',
'/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', 0, null, now(),
now());
-insert into "public"."t_menu" values (120203, 120200, 'edit flink',
'/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', 0, null,
now(), now());
-insert into "public"."t_menu" values (120204, 120200, 'edit streampark',
'/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '',
'0', 0, null, now(), now());
-insert into "public"."t_menu" values (120205, 120200, 'mapping', null, null,
'app:mapping', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120206, 120200, 'release', null, null,
'app:release', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120207, 120200, 'start', null, null,
'app:start', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120208, 120200, 'clean', null, null,
'app:clean', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120209, 120200, 'cancel', null, null,
'app:cancel', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120210, 120200, 'savepoint delete',
null, null, 'savepoint:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120211, 120200, 'backup rollback', null,
null, 'backup:rollback', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120212, 120200, 'backup delete', null,
null, 'backup:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120213, 120200, 'conf delete', null,
null, 'conf:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120214, 120200, 'delete', null, null,
'app:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120215, 120200, 'copy', null, null,
'app:copy', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120216, 120200, 'view', null, null,
'app:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120217, 120200, 'savepoint trigger',
null, null, 'savepoint:trigger', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120218, 120200, 'sql delete', null,
null, 'sql:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120301, 120300, 'add', NULL, NULL,
'variable:add', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120302, 120300, 'update', NULL, NULL,
'variable:update', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120303, 120300, 'delete', NULL, NULL,
'variable:delete', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120304, 120300, 'depend apps',
'/flink/variable/depend_apps', 'flink/variable/DependApps',
'variable:depend_apps', '', '0', 0, NULL, now(), now());
-insert into "public"."t_menu" values (120305, 120300, 'show original', NULL,
NULL, 'variable:show_original', NULL, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (120306, 120300, 'view', NULL, NULL,
'variable:view', NULL, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (120307, 120300, 'depend view', null,
null, 'variable:depend_apps', null, '1', 1, NULL, now(), now());
-insert into "public"."t_menu" values (130101, 130100, 'view', null, null,
'setting:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130102, 130100, 'setting update', null,
null, 'setting:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130401, 130400, 'add cluster',
'/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create',
'', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (130402, 130400, 'edit cluster',
'/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update',
'', '0', 0, null, now(), now());
-insert into "public"."t_menu" values (130501, 130500, 'link view', null, null,
'externalLink:view', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130502, 130500, 'link create', null,
null, 'externalLink:create', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130503, 130500, 'link update', null,
null, 'externalLink:update', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130504, 130500, 'link delete', null,
null, 'externalLink:delete', null, '1', 1, null, now(), now());
-insert into "public"."t_menu" values (130601, 130600, 'add yarn queue', null,
null, 'yarnQueue:create', '', '1', 0, null, now(), now());
-insert into "public"."t_menu" values (130602, 130600, 'edit yarn queue', null,
null, 'yarnQueue:update', '', '1', 0, null, now(), now());
-insert into "public"."t_menu" values (130603, 130600, 'delete yarn queue',
null, null, 'yarnQueue:delete', '', '1', 0, null, now(), now());
+insert into "public"."t_menu" values (110000, 0, 'menu.system', '/system',
'PageView', null, 'desktop', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (120000, 0, 'StreamPark', '/flink',
'PageView', null, 'build', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (130000, 0, 'menu.setting', '/setting',
'PageView', null, 'setting', '0', '1', 5, now(), now());
+insert into "public"."t_menu" values (110100, 110000, 'menu.userManagement',
'/system/user', 'system/user/User', null, 'user', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (110200, 110000, 'menu.roleManagement',
'/system/role', 'system/role/Role', null, 'smile', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (110300, 110000, 'menu.menuManagement',
'/system/menu', 'system/menu/Menu', 'menu:view', 'bars', '0', '1', 3, now(),
now());
+insert into "public"."t_menu" values (110400, 110000, 'menu.tokenManagement',
'/system/token', 'system/token/Token', null, 'lock', '0', '1', 1, now(), now());
+insert into "public"."t_menu" values (110500, 110000, 'menu.teamManagement',
'/system/team', 'system/team/Team', null, 'team', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (110600, 110000, 'menu.memberManagement',
'/system/member', 'system/member/Member', null, 'usergroup-add', '0', '1', 2,
now(), now());
+insert into "public"."t_menu" values (120100, 120000, 'menu.project',
'/flink/project', 'flink/project/View', null, 'github', '0', '1', 1, now(),
now());
+insert into "public"."t_menu" values (120200, 120000, 'menu.application',
'/flink/app', 'flink/app/View', null, 'mobile', '0', '1', 2, now(), now());
+insert into "public"."t_menu" values (120300, 120000, 'menu.variable',
'/flink/variable', 'flink/variable/View', null, 'code', '0', '1', 3, now(),
now());
+insert into "public"."t_menu" values (130100, 130000, 'setting.system',
'/setting/system', 'setting/System/index', null, 'database', '0', '1', 1,
now(), now());
+insert into "public"."t_menu" values (130200, 130000, 'setting.alarm',
'/setting/alarm', 'setting/Alarm/index', null, 'alert', '0', '1', 2, now(),
now());
+insert into "public"."t_menu" values (130300, 130000, 'setting.flinkHome',
'/setting/flinkHome', 'setting/FlinkHome/index', null, 'desktop', '0', '1', 3,
now(), now());
+insert into "public"."t_menu" values (130400, 130000, 'setting.flinkCluster',
'/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster',
'0', '1', 4, now(), now());
+insert into "public"."t_menu" values (130500, 130000, 'setting.externalLink',
'/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link',
'0', '1', 5, now(), now());
+insert into "public"."t_menu" values (130600, 130000, 'setting.yarnQueue',
'/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', '1',
6, now(), now());
+insert into "public"."t_menu" values (110101, 110100, 'add', null, null,
'user:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110102, 110100, 'update', null, null,
'user:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110103, 110100, 'delete', null, null,
'user:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110104, 110100, 'reset', null, null,
'user:reset', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110105, 110100, 'types', null, null,
'user:types', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110106, 110100, 'view', null, null,
'user:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110201, 110200, 'add', null, null,
'role:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110202, 110200, 'update', null, null,
'role:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110203, 110200, 'delete', null, null,
'role:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110204, 110200, 'view', null, null,
'role:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110401, 110400, 'add', null, null,
'token:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110402, 110400, 'delete', null, null,
'token:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110403, 110400, 'view', null, null,
'token:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110501, 110500, 'add', null, null,
'team:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110502, 110500, 'update', null, null,
'team:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110503, 110500, 'delete', null, null,
'team:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110504, 110500, 'view', null, null,
'team:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110601, 110600, 'add', null, null,
'member:add', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110602, 110600, 'update', null, null,
'member:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110603, 110600, 'delete', null, null,
'member:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110604, 110600, 'role view', null, null,
'role:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (110605, 110600, 'view', null, null,
'member:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120101, 120100, 'add',
'/flink/project/add', 'flink/project/Add', 'project:create', '', '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120102, 120100, 'build', null, null,
'project:build', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120103, 120100, 'delete', null, null,
'project:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120104, 120100, 'edit',
'/flink/project/edit', 'flink/project/Edit', 'project:update', null, '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120105, 120100, 'view', null, null,
'project:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120201, 120200, 'add', '/flink/app/add',
'flink/app/Add', 'app:create', '', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (120202, 120200, 'detail app',
'/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', '0', null,
now(), now());
+insert into "public"."t_menu" values (120203, 120200, 'edit flink',
'/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', '0',
null, now(), now());
+insert into "public"."t_menu" values (120204, 120200, 'edit streampark',
'/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '',
'0', '0', null, now(), now());
+insert into "public"."t_menu" values (120205, 120200, 'mapping', null, null,
'app:mapping', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120206, 120200, 'release', null, null,
'app:release', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120207, 120200, 'start', null, null,
'app:start', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120208, 120200, 'clean', null, null,
'app:clean', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120209, 120200, 'cancel', null, null,
'app:cancel', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120210, 120200, 'savepoint delete',
null, null, 'savepoint:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120211, 120200, 'backup rollback', null,
null, 'backup:rollback', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120212, 120200, 'backup delete', null,
null, 'backup:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120213, 120200, 'conf delete', null,
null, 'conf:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120214, 120200, 'delete', null, null,
'app:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120215, 120200, 'copy', null, null,
'app:copy', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120216, 120200, 'view', null, null,
'app:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120217, 120200, 'savepoint trigger',
null, null, 'savepoint:trigger', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120218, 120200, 'sql delete', null,
null, 'sql:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120301, 120300, 'add', NULL, NULL,
'variable:add', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120302, 120300, 'update', NULL, NULL,
'variable:update', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120303, 120300, 'delete', NULL, NULL,
'variable:delete', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120304, 120300, 'depend apps',
'/flink/variable/depend_apps', 'flink/variable/DependApps',
'variable:depend_apps', '', '0', '0', NULL, now(), now());
+insert into "public"."t_menu" values (120305, 120300, 'show original', NULL,
NULL, 'variable:show_original', NULL, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (120306, 120300, 'view', NULL, NULL,
'variable:view', NULL, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (120307, 120300, 'depend view', null,
null, 'variable:depend_apps', null, '1', '1', NULL, now(), now());
+insert into "public"."t_menu" values (130101, 130100, 'view', null, null,
'setting:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130102, 130100, 'setting update', null,
null, 'setting:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130401, 130400, 'add cluster',
'/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create',
'', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (130402, 130400, 'edit cluster',
'/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update',
'', '0', '0', null, now(), now());
+insert into "public"."t_menu" values (130501, 130500, 'link view', null, null,
'externalLink:view', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130502, 130500, 'link create', null,
null, 'externalLink:create', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130503, 130500, 'link update', null,
null, 'externalLink:update', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130504, 130500, 'link delete', null,
null, 'externalLink:delete', null, '1', '1', null, now(), now());
+insert into "public"."t_menu" values (130601, 130600, 'add yarn queue', null,
null, 'yarnQueue:create', '', '1', '0', null, now(), now());
+insert into "public"."t_menu" values (130602, 130600, 'edit yarn queue', null,
null, 'yarnQueue:update', '', '1', '0', null, now(), now());
+insert into "public"."t_menu" values (130603, 130600, 'delete yarn queue',
null, null, 'yarnQueue:delete', '', '1', '0', null, now(), now());
-- role menu script
update "public"."t_role_menu" set menu_id=110000 where menu_id=100000;
