You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ch...@apache.org on 2016/02/15 20:50:40 UTC
airavata git commit: mysql previous versions does not allow two now()
functions
Repository: airavata
Updated Branches:
refs/heads/develop 24587f9f8 -> 614f8bbf5
mysql previous versions does not allow two now() functions
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/614f8bbf
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/614f8bbf
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/614f8bbf
Branch: refs/heads/develop
Commit: 614f8bbf5c22290d7a57f4cc11403285e3bac0b9
Parents: 24587f9
Author: Chathuri Wimalasena <ch...@apache.org>
Authored: Mon Feb 15 14:53:01 2016 -0500
Committer: Chathuri Wimalasena <ch...@apache.org>
Committed: Mon Feb 15 14:53:01 2016 -0500
----------------------------------------------------------------------
.../registry-core/src/main/resources/workflowcatalog-mysql.sql | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/airavata/blob/614f8bbf/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 5a8ef97..2cc10c6 100644
--- a/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
+++ b/modules/registry/registry-core/src/main/resources/workflowcatalog-mysql.sql
@@ -28,7 +28,8 @@ CREATE TABLE WORKFLOW
GRAPH LONGTEXT,
IMAGE BLOB,
CREATION_TIME timestamp DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+-- UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
PRIMARY KEY (TEMPLATE_ID)
);