This is an automated email from the ASF dual-hosted git repository.
benjobs pushed a commit to branch dev-2.1.5
in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git
The following commit(s) were added to refs/heads/dev-2.1.5 by this push:
new ebdd735be fix: change link url to text (#3999)
ebdd735be is described below
commit ebdd735be52eec5817edc569e0ae59836af12c80
Author: Darcy <[email protected]>
AuthorDate: Wed Aug 28 17:02:56 2024 +0800
fix: change link url to text (#3999)
---
.../main/assembly/script/schema/mysql-schema.sql | 2 +-
.../main/assembly/script/schema/pgsql-schema.sql | 2 +-
.../main/assembly/script/upgrade/mysql/2.1.5.sql | 21 +++++++++++++++++++++
.../main/assembly/script/upgrade/pgsql/2.1.5.sql | 19 +++++++++++++++++++
4 files changed, 42 insertions(+), 2 deletions(-)
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql
index 95024ed79..c7958e792 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql
@@ -486,7 +486,7 @@ CREATE TABLE `t_external_link` (
`badge_label` varchar(64) collate utf8mb4_general_ci default null,
`badge_name` varchar(64) collate utf8mb4_general_ci default null,
`badge_color` varchar(64) collate utf8mb4_general_ci default null,
- `link_url` varchar(255) collate utf8mb4_general_ci default null,
+ `link_url` text collate utf8mb4_general_ci default null,
`create_time` datetime default null COMMENT 'create time',
`modify_time` datetime default null COMMENT 'modify time'
) engine = innodb default charset=utf8mb4 collate=utf8mb4_general_ci;
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 a523c04a4..9feeef00b 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
@@ -738,7 +738,7 @@ create table "public"."t_external_link" (
"badge_label" varchar(64) collate "pg_catalog"."default",
"badge_name" varchar(64) collate "pg_catalog"."default",
"badge_color" varchar(64) collate "pg_catalog"."default",
- "link_url" varchar(255) collate "pg_catalog"."default",
+ "link_url" text collate "pg_catalog"."default",
"create_time" timestamp(6),
"modify_time" timestamp(6))
;
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.5.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.5.sql
new file mode 100644
index 000000000..bc13c069f
--- /dev/null
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.5.sql
@@ -0,0 +1,21 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+use streampark;
+
+ALTER TABLE `t_external_link`
+ MODIFY `link_url` text collate utf8mb4_general_ci default null;
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.5.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.5.sql
new file mode 100644
index 000000000..f8f753f99
--- /dev/null
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.5.sql
@@ -0,0 +1,19 @@
+/*
+* Licensed to the Apache Software Foundation (ASF) under one or more
+* contributor license agreements. See the NOTICE file distributed with
+* this work for additional information regarding copyright ownership.
+* The ASF licenses this file to You under the Apache License, Version 2.0
+* (the "License"); you may not use this file except in compliance with
+* the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+*/
+
+ALTER TABLE "public"."t_external_link"
+ ALTER COLUMN "link_url" TYPE text collate "pg_catalog"."default";
