This is an automated email from the ASF dual-hosted git repository.
benjobs pushed a commit to branch dev-2.1.2
in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git
The following commit(s) were added to refs/heads/dev-2.1.2 by this push:
new 91922855e [bug] Fixed the bug where the modify_time of the task
changes with th… (#3359)
91922855e is described below
commit 91922855e76fa3fdb6fe514998c928989bc89948
Author: charonjiang <[email protected]>
AuthorDate: Sun Nov 26 23:22:05 2023 +0800
[bug] Fixed the bug where the modify_time of the task changes with th…
(#3359)
* [bug] Fixed the bug where the modify_time of the task changes with the
current time
---------
Co-authored-by: benjobs <[email protected]>
---
.../src/main/assembly/script/schema/mysql-schema.sql | 2 +-
.../src/main/assembly/script/upgrade/mysql/2.1.2.sql | 3 ++-
2 files changed, 3 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 284992ff5..5a7c1e1ea 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
@@ -87,7 +87,7 @@ create table `t_flink_app` (
`option_state` tinyint default null,
`tracking` tinyint default null,
`create_time` datetime not null default current_timestamp comment 'create
time',
- `modify_time` datetime not null default current_timestamp on update
current_timestamp comment 'modify time',
+ `modify_time` datetime not null default current_timestamp comment 'modify
time',
`option_time` datetime default null,
`release` tinyint default 1,
`build` tinyint default 1,
diff --git
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql
index 2205a8fbb..c0fafc641 100644
---
a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql
+++
b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql
@@ -21,6 +21,7 @@ set names utf8mb4;
set foreign_key_checks = 0;
alter table `t_flink_app`
- add column `dependency` text collate utf8mb4_general_ci default null after
`main_class`;
+ add column `dependency` text collate utf8mb4_general_ci default null after
`main_class`,
+ modify column `modify_time` datetime not null comment 'modify time';
set foreign_key_checks = 1;
