You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by sm...@apache.org on 2017/04/03 16:50:22 UTC
[49/50] airavata git commit: AIRAVATA-2335 Instead of default of 0,
use NOW() for UPDATE_TIME
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/master
Commit: de5692c52901b059cf302a26c14cfc691fcad47c
Parents: 570bc5d
Author: Marcus Christie <ma...@apache.org>
Authored: Fri Mar 31 10:05:06 2017 -0400
Committer: Marcus Christie <ma...@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)
);