[incubator-streampark] branch dev updated: [Bug] The mysql 1.2.4 upgrade script has the problem of incorrect fields and few fields #1932 (#1933)

[benjobs]

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 9f88a04ea [Bug] The mysql 1.2.4 upgrade script has the problem of 
incorrect fields and few fields #1932 (#1933)
9f88a04ea is described below

commit 9f88a04ea4aad32702edd65e6ac702398b0f0d2d
Author: macksonmu <mackson...@gmail.com>
AuthorDate: Mon Oct 31 20:30:29 2022 +0800

    [Bug] The mysql 1.2.4 upgrade script has the problem of incorrect fields 
and few fields #1932 (#1933)
---
 .../src/assembly/script/upgrade/mysql/1.2.4.sql                        | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git 
a/streampark-console/streampark-console-service/src/assembly/script/upgrade/mysql/1.2.4.sql
 
b/streampark-console/streampark-console-service/src/assembly/script/upgrade/mysql/1.2.4.sql
index cfb2d9928..45012f18c 100644
--- 
a/streampark-console/streampark-console-service/src/assembly/script/upgrade/mysql/1.2.4.sql
+++ 
b/streampark-console/streampark-console-service/src/assembly/script/upgrade/mysql/1.2.4.sql
@@ -62,7 +62,7 @@ where alert_type = 1;
 -- t_flink_app
 alter table `t_flink_app`
     drop column alert_email,
-    change column dynamic_option properties text comment 'allows specifying 
multiple generic configuration options',
+    change column dynamic_options properties text comment 'allows specifying 
multiple generic configuration options',
     add column `job_manager_url` varchar(255) default null after `job_id`,
     add column `option_time` datetime default null after `create_time`,
     add column `ingress_template` text collate utf8mb4_general_ci comment 
'ingress模版文件',
@@ -79,6 +79,7 @@ alter table `t_flink_project`
     add column `modify_time` datetime not null default current_timestamp on 
update current_timestamp after `create_time`,
     add index `inx_team` (`team_id`) using btree;
 
+alter table `t_flink_cluster` add column `properties` text comment 'allows 
specifying multiple generic configuration options' after `flink_image`;
 
 -- change `update_time` to `modify_time`
 alter table `t_app_build_pipe` change column `update_time` `modify_time` 
datetime not null default current_timestamp on update current_timestamp;