airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shame...@apache.org
Subject [17/42] airavata git commit: fixing bug in sql script
Date Wed, 13 Jan 2016 17:02:54 GMT
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 <chathuri@apache.org>
Authored: Tue Jan 5 10:57:02 2016 -0500
Committer: Chathuri Wimalasena <chathuri@apache.org>
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


Mime
View raw message