airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From machris...@apache.org
Subject airavata git commit: AIRAVATA-2335 Instead of default of 0, use NOW() for UPDATE_TIME
Date Fri, 31 Mar 2017 14:08:19 GMT
Repository: airavata
Updated Branches:
  refs/heads/develop 570bc5d1b -> de5692c52


AIRAVATA-2335 Instead of default of 0, use NOW() for UPDATE_TIME

MariaDB/MySQL running in strict mode doesn't allow a 0 date as a default
value for a TIMESTAMP column.  Also, there is no longer the restriction
that only one TIMESTAMP column on a table can default to NOW().


Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/de5692c5
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/de5692c5
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/de5692c5

Branch: refs/heads/develop
Commit: de5692c52901b059cf302a26c14cfc691fcad47c
Parents: 570bc5d
Author: Marcus Christie <machristie@apache.org>
Authored: Fri Mar 31 10:05:06 2017 -0400
Committer: Marcus Christie <machristie@apache.org>
Committed: Fri Mar 31 10:05:06 2017 -0400

----------------------------------------------------------------------
 .../registry-core/src/main/resources/workflowcatalog-mysql.sql    | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/de5692c5/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql b/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
index 2cc10c6..5a8ef97 100644
--- a/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
+++ b/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
@@ -28,8 +28,7 @@ CREATE TABLE WORKFLOW
         GRAPH LONGTEXT,
         IMAGE BLOB,
         CREATION_TIME timestamp DEFAULT NOW(),
-        UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
---         UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
+        UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
         PRIMARY KEY (TEMPLATE_ID)
 );
 


Mime
View raw message