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/develop Commit: 5e4eb57a0ae53daab4ea6e0170a79f2a1b00ca59 Parents: 1d9eaf8 Author: Chathuri Wimalasena <[email protected]> Authored: Tue Jan 5 10:51:11 2016 -0500 Committer: Chathuri Wimalasena <[email protected]> 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),
