You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by sc...@apache.org on 2016/01/12 23:04:26 UTC
[15/50] [abbrv] airavata git commit: fixing bug in sql script
fixing bug in sql script
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/5e4eb57a
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/5e4eb57a
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/5e4eb57a
Branch: refs/heads/data-manager
Commit: 5e4eb57a0ae53daab4ea6e0170a79f2a1b00ca59
Parents: 1d9eaf8
Author: Chathuri Wimalasena <ch...@apache.org>
Authored: Tue Jan 5 10:51:11 2016 -0500
Committer: Chathuri Wimalasena <ch...@apache.org>
Committed: Tue Jan 5 10:51:11 2016 -0500
----------------------------------------------------------------------
.../registry-core/src/main/resources/expcatalog-mysql.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/airavata/blob/5e4eb57a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql b/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql
index bf8bf5a..af1d495 100644
--- a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql
+++ b/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql
@@ -183,7 +183,7 @@ CREATE TABLE PROCESS (
PROCESS_ID varchar(255),
EXPERIMENT_ID varchar(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- LAST_UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
+ LAST_UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
PROCESS_DETAIL text,
APPLICATION_INTERFACE_ID varchar(255),
TASK_DAG TEXT,
@@ -276,7 +276,7 @@ CREATE TABLE TASK (
TASK_TYPE varchar(255),
PARENT_PROCESS_ID varchar(255),
CREATION_TIME timestamp DEFAULT NOW(),
- LAST_UPDATE_TIME DEFAULT NOW() ON UPDATE NOW(),
+ LAST_UPDATE_TIME DEFAULT '0000-00-00 00:00:00',
TASK_DETAIL text,
TASK_INTERNAL_STORE tinyint(4),
PRIMARY KEY (TASK_ID),