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/94629e16 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/94629e16 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/94629e16 Branch: refs/heads/develop Commit: 94629e1691dc262a97abf703bd442ce85743223c Parents: 5e4eb57 Author: Chathuri Wimalasena <[email protected]> Authored: Tue Jan 5 10:57:02 2016 -0500 Committer: Chathuri Wimalasena <[email protected]> Committed: Tue Jan 5 10:57:02 2016 -0500 ---------------------------------------------------------------------- .../registry-core/src/main/resources/expcatalog-mysql.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/94629e16/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 af1d495..47e6134 100644 --- a/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql +++ b/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql @@ -239,7 +239,7 @@ CREATE TABLE PROCESS_STATUS ( STATUS_ID varchar(255), PROCESS_ID varchar(255), STATE varchar(255), - TIME_OF_STATE_CHANGE DEFAULT NOW() ON UPDATE NOW(), + TIME_OF_STATE_CHANGE TIMESTAMP DEFAULT NOW() ON UPDATE NOW(), REASON LONGTEXT, PRIMARY KEY (STATUS_ID, PROCESS_ID), FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE @@ -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 '0000-00-00 00:00:00', + LAST_UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00', TASK_DETAIL text, TASK_INTERNAL_STORE tinyint(4), PRIMARY KEY (TASK_ID), @@ -287,7 +287,7 @@ CREATE TABLE TASK_STATUS ( STATUS_ID varchar(255), TASK_ID varchar(255), STATE varchar(255), - TIME_OF_STATE_CHANGE DEFAULT NOW() ON UPDATE NOW(), + TIME_OF_STATE_CHANGE TIMESTAMP DEFAULT NOW() ON UPDATE NOW(), REASON LONGTEXT, PRIMARY KEY (STATUS_ID, TASK_ID), FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE @@ -327,7 +327,7 @@ CREATE TABLE JOB_STATUS ( JOB_ID varchar(255), TASK_ID varchar(255), STATE varchar(255), - TIME_OF_STATE_CHANGE DEFAULT NOW() ON UPDATE NOW(), + TIME_OF_STATE_CHANGE TIMESTAMP DEFAULT NOW() ON UPDATE NOW(), REASON LONGTEXT, PRIMARY KEY (STATUS_ID, JOB_ID, TASK_ID), FOREIGN KEY (JOB_ID, TASK_ID) REFERENCES JOB(JOB_ID, TASK_ID) ON DELETE CASCADE
