[Bug] Field 'modify_time' doesn't have a default value

Search before asking

[X] I had searched in the issues and found no similar issues.

Java Version

No response

Scala Version

2.12.x

StreamPark Version

2.1.2

Flink Version

1.17.1

deploy mode

yarn-application

What happened

After upgrading from 2.1.1 to 2.1.2, when I added a new application and submitted it, streampark told me that the field "modify_time" had no default value. I found that modify_time has a default value in script/schema/mysql-schema.sql, but not in script/upgrade/mysql/2.1.2.sql.

Error Exception

2023-12-19 13:19:17 | INFO  | XNIO-1 task-6 | org.apache.streampark.console.base.handler.GlobalExceptionHandler:54] Internal server error：
org.springframework.dao.DataIntegrityViolationException: 
### Error updating database.  Cause: java.sql.SQLException: Field 'modify_time' doesn't have a default value
### The error may exist in org/apache/streampark/console/core/mapper/ApplicationMapper.java (best guess)
### The error may involve org.apache.streampark.console.core.mapper.ApplicationMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO t_flink_app  ( team_id, job_type,  user_id, job_name,    version_id,   k8s_namespace, state, `release`, build,   option_state,    options,  resolve_order, execution_mode,  app_type, tracking,                   create_time )  VALUES  ( ?, ?,  ?, ?
,    ?,   ?, ?, ?, ?,   ?,    ?,  ?, ?,  ?, ?,                   ? )
### Cause: java.sql.SQLException: Field 'modify_time' doesn't have a default value
; Field 'modify_time' doesn't have a default value; nested exception is java.sql.SQLException: Field 'modify_time' doesn't have a default value

Screenshots