You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@streampark.apache.org by be...@apache.org on 2023/09/01 15:31:56 UTC
[incubator-streampark] branch dev updated: Modify pgsql-schema.sql (#2942)
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 7d76fc0c4 Modify pgsql-schema.sql (#2942)
7d76fc0c4 is described below
commit 7d76fc0c4c0f0fbddacf95515b5fc2fe2f630497
Author: ChengJie1053 <18...@163.com>
AuthorDate: Fri Sep 1 23:31:49 2023 +0800
Modify pgsql-schema.sql (#2942)
---
.../main/assembly/script/schema/pgsql-schema.sql | 3 +++
.../main/assembly/script/upgrade/pgsql/2.2.0.sql | 25 ++++++++++++----------
2 files changed, 17 insertions(+), 11 deletions(-)
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 b1b8d1b1d..a9e5ffa24 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
@@ -617,11 +617,14 @@ create table "public"."t_resource" (
"id" int8 not null default nextval('streampark_t_resource_id_seq'::regclass),
"resource_name" varchar(128) collate "pg_catalog"."default" not null,
"resource_type" int4,
+ "resource_path" varchar(255) default null,
"resource" text collate "pg_catalog"."default",
"engine_type" int4,
"main_class" varchar(255) collate "pg_catalog"."default",
"description" text collate "pg_catalog"."default" default null,
"creator_id" int8 not null,
+ "connector_required_options" text default null,
+ "connector_optional_options" text default null,
"team_id" int8 not null,
"create_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone),
"modify_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone)
diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.2.0.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.2.0.sql
index 7f5a54f7d..4e7a43b2f 100644
--- a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.2.0.sql
+++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.2.0.sql
@@ -22,17 +22,20 @@ create sequence "public"."streampark_t_resource_id_seq"
increment 1 start 10000 cache 1 minvalue 10000 maxvalue 9223372036854775807;
create table "public"."t_resource" (
-"id" int8 not null default nextval('streampark_t_resource_id_seq'::regclass),
-"resource_name" varchar(128) collate "pg_catalog"."default" not null,
-"resource_type" int4,
-"resource" text collate "pg_catalog"."default",
-"engine_type" int4,
-"main_class" varchar(255) collate "pg_catalog"."default",
-"description" text collate "pg_catalog"."default" default null,
-"creator_id" int8 not null,
-"team_id" int8 not null,
-"create_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone),
-"modify_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone)
+ "id" int8 not null default nextval('streampark_t_resource_id_seq'::regclass),
+ "resource_name" varchar(128) collate "pg_catalog"."default" not null,
+ "resource_type" int4,
+ "resource_path" varchar(255) default null,
+ "resource" text collate "pg_catalog"."default",
+ "engine_type" int4,
+ "main_class" varchar(255) collate "pg_catalog"."default",
+ "description" text collate "pg_catalog"."default" default null,
+ "creator_id" int8 not null,
+ "connector_required_options" text default null,
+ "connector_optional_options" text default null,
+ "team_id" int8 not null,
+ "create_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone),
+ "modify_time" timestamp(6) not null default timezone('UTC-8'::text, (now())::timestamp(0) without time zone)
)
;
comment on column "public"."t_resource"."id" is 'Resource id';