This is an automated email from the ASF dual-hosted git repository.
xiaoyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new 2fd6618 [ISSUE #2947] Fix pg schema.sql . (#2948)
2fd6618 is described below
commit 2fd6618886745dbfae23b3b364fa25133a38ac1f
Author: Shawn Jim <[email protected]>
AuthorDate: Tue Mar 1 11:04:41 2022 +0800
[ISSUE #2947] Fix pg schema.sql . (#2948)
---
shenyu-admin/src/main/resources/sql-script/pg/schema.sql | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/shenyu-admin/src/main/resources/sql-script/pg/schema.sql
b/shenyu-admin/src/main/resources/sql-script/pg/schema.sql
index 0e941fc..ba0d5e2 100644
--- a/shenyu-admin/src/main/resources/sql-script/pg/schema.sql
+++ b/shenyu-admin/src/main/resources/sql-script/pg/schema.sql
@@ -394,8 +394,7 @@ ELSE
PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES
(''' || '8' || ''', ''' || 'springCloud' || ''', NULL, ''' || 'Proxy' || ''',
200, 0, ''' || '2018-06-25 13:47:57' || ''', ''' || '2018-06-25 13:47:57' ||
''');');
PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES
(''' || '9' || ''', ''' || 'hystrix' || ''', NULL, ''' || 'FaultTolerance' ||
''', 130, 0, ''' || '2020-01-15 10:19:10' || ''', ''' || '2020-01-15 10:19:10'
|| ''');');
PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES
(''' || '27' || ''', ''' || 'generalContext' || ''', NULL, ''' || 'Common' ||
''', 125, 0, ''' || '2021-11-24 21:38:48' || ''', ''' || '2021-11-24 21:38:48'
|| ''');');
- PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES ('''
|| '28' || ''', ''' || 'mqtt' || ''', ''' || 'Proxy' || ''', 125, 0, ''' ||
'2022-01-12 20:33:50' || ''', ''' || '2022-01-12 20:34:07' || ''');');
- PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES ('''
|| '28' || ''', ''' || 'mqtt' || ''', ''' || '{"port":
9500,"bossGroupThreadCount": 1,"maxPayloadSize":
65536,"workerGroupThreadCount": 12,"userName": "shenyu","password":
"shenyu","isEncryptPassword": false,"encryptMode": "","leakDetectorLevel":
"DISABLED"}' || ''', ''' || 'Proxy' || ''', 310, 0, ''' || '2022-01-12
20:33:50' || ''', ''' || '2022-01-12 20:33:50' || ''');');
+ PERFORM public.dblink_exec('init_conn', 'INSERT INTO "plugin" VALUES ('''
|| '28' || ''', ''' || 'mqtt' || ''', ''' || '{"port":
9500,"bossGroupThreadCount": 1,"maxPayloadSize":
65536,"workerGroupThreadCount": 12,"userName": "shenyu","password":
"shenyu","isEncryptPassword": false,"encryptMode": "","leakDetectorLevel":
"DISABLED"}' || ''', ''' || 'Proxy' || ''', 125, 0, ''' || '2022-01-12
20:33:50' || ''', ''' || '2022-01-12 20:33:50' || ''');');
PERFORM public.dblink_exec('init_conn', 'COMMIT');
@@ -1067,7 +1066,7 @@ ELSE
PERFORM public.dblink_exec('init_conn', 'INSERT INTO shenyu_dict ( type
, dict_code , dict_name , dict_value , "desc" , sort , enabled ) VALUES
(''' || 'gray' || ''', ''' || 'GRAY_STATUS' || ''', ''' || 'open' || ''', '''
|| 'true' || ''', ''' || 'open' || ''', ''' || '0' || ''', ''' || '1' ||
''');');
/* insert dict for init resource,permission table */
- PERFORM public.dblink_exec('init_conn', 'INSERT INTO shenyu_dict ( type
, dict_code , dict_name , dict_value , "desc" , sort , enabled ) VALUES
(''' || 'table'|| ''', ''' || 'INIT_FLAG' || ''', ''' || 'status' || ''',''' ||
'false' ||''',''' || 'table(resource,permission) init status' ||''',''' || '0'
|| ''',''' || '1' || ''');');;
+ PERFORM public.dblink_exec('init_conn', 'INSERT INTO shenyu_dict ( type
, dict_code , dict_name , dict_value , "desc" , sort , enabled ) VALUES
(''' || 'table'|| ''', ''' || 'INIT_FLAG' || ''', ''' || 'status' || ''',''' ||
'false' ||''',''' || 'table(resource,permission) init status' ||''',''' || '0'
|| ''',''' || '1' || ''');');
PERFORM public.dblink_exec('init_conn', 'COMMIT');
END IF;
