This is an automated email from the ASF dual-hosted git repository.

peacewong pushed a commit to branch dev-1.0.3
in repository https://gitbox.apache.org/repos/asf/incubator-linkis.git


The following commit(s) were added to refs/heads/dev-1.0.3 by this push:
     new 72af38e  fix ddl datatime(3) default value
     new 353b50b  Merge pull request #1242 from casionone/dev-1.0.3
72af38e is described below

commit 72af38e8c3369a851a538d732b2f533d79b2abfd
Author: casionone <[email protected]>
AuthorDate: Tue Dec 28 10:14:58 2021 +0800

    fix ddl datatime(3) default value
---
 db/linkis_ddl.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/db/linkis_ddl.sql b/db/linkis_ddl.sql
index 42f7740..bac8527 100644
--- a/db/linkis_ddl.sql
+++ b/db/linkis_ddl.sql
@@ -88,8 +88,8 @@ CREATE TABLE `linkis_ps_job_history_group_history` (
   `log_path` varchar(200) DEFAULT NULL COMMENT 'File path of the job log',
   `error_code` int DEFAULT NULL COMMENT 'Error code. Generated when the 
execution of the script fails',
   `error_desc` varchar(1000) DEFAULT NULL COMMENT 'Execution description. 
Generated when the execution of script fails',
-  `created_time` datetime(3) DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time',
-  `updated_time` datetime(3) DEFAULT CURRENT_TIMESTAMP COMMENT 'Update time',
+  `created_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'Creation 
time',
+  `updated_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'Update 
time',
   `instances` varchar(250) DEFAULT NULL COMMENT 'Entrance instances',
   `metrics` text DEFAULT NULL COMMENT   'Job Metrics',
   `engine_type` varchar(32) DEFAULT NULL COMMENT 'Engine type',
@@ -108,8 +108,8 @@ CREATE TABLE `linkis_ps_job_history_detail` (
   `execution_content` text DEFAULT NULL COMMENT 'The script code or other 
execution content executed by this Job',
   `result_array_size` int(4) DEFAULT 0 COMMENT 'size of result array',
   `job_group_info` text DEFAULT NULL COMMENT 'Job group info/path',
-  `created_time` datetime(3) DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time',
-  `updated_time` datetime(3) DEFAULT CURRENT_TIMESTAMP COMMENT 'Update time',
+  `created_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'Creation 
time',
+  `updated_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'Update 
time',
   `status` varchar(32) DEFAULT NULL COMMENT 'status',
   `priority` int(4) DEFAULT 0 COMMENT 'order of subjob',
   PRIMARY KEY (`id`)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to