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 2015/01/15 17:41:20 UTC
airavata git commit: database script issues
Repository: airavata
Updated Branches:
refs/heads/master 0a85dfe02 -> dba25a407
database script issues
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/dba25a40
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/dba25a40
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/dba25a40
Branch: refs/heads/master
Commit: dba25a4078d9c9524523248615d885772f2f7b20
Parents: 0a85dfe
Author: Chathuri Wimalasena <ka...@gmail.com>
Authored: Thu Jan 15 11:41:06 2015 -0500
Committer: Chathuri Wimalasena <ka...@gmail.com>
Committed: Thu Jan 15 11:41:06 2015 -0500
----------------------------------------------------------------------
.../src/main/resources/appcatalog-mysql.sql | 28 ++++++++++----------
1 file changed, 14 insertions(+), 14 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/airavata/blob/dba25a40/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-mysql.sql
----------------------------------------------------------------------
diff --git a/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-mysql.sql b/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-mysql.sql
index b992959..f874b3c 100644
--- a/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-mysql.sql
+++ b/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-mysql.sql
@@ -24,7 +24,7 @@ CREATE TABLE COMPUTE_RESOURCE
HOST_NAME VARCHAR (255) NOT NULL,
RESOURCE_DESCRIPTION VARCHAR (255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
MAX_MEMORY_NODE INTEGER,
PRIMARY KEY (RESOURCE_ID)
);
@@ -108,7 +108,7 @@ CREATE TABLE RESOURCE_JOB_MANAGER
JOB_MANAGER_BIN_PATH VARCHAR (255),
RESOURCE_JOB_MANAGER_TYPE VARCHAR (255) NOT NULL,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (RESOURCE_JOB_MANAGER_ID)
);
@@ -120,7 +120,7 @@ CREATE TABLE SSH_JOB_SUBMISSION
SECURITY_PROTOCOL VARCHAR (255) NOT NULL,
SSH_PORT INTEGER,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY (JOB_SUBMISSION_INTERFACE_ID),
FOREIGN KEY (RESOURCE_JOB_MANAGER_ID) REFERENCES RESOURCE_JOB_MANAGER(RESOURCE_JOB_MANAGER_ID)
);
@@ -133,7 +133,7 @@ CREATE TABLE SCP_DATA_MOVEMENT
ALTERNATIVE_SCP_HOSTNAME VARCHAR (255),
SSH_PORT INTEGER,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY (DATA_MOVEMENT_INTERFACE_ID)
);
@@ -142,7 +142,7 @@ CREATE TABLE GRIDFTP_DATA_MOVEMENT
DATA_MOVEMENT_INTERFACE_ID VARCHAR (255) NOT NULL,
SECURITY_PROTOCOL VARCHAR (255) NOT NULL,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY (DATA_MOVEMENT_INTERFACE_ID)
);
@@ -152,7 +152,7 @@ CREATE TABLE GRIDFTP_ENDPOINT
DATA_MOVEMENT_INTERFACE_ID VARCHAR (255) NOT NULL,
PRIMARY KEY (DATA_MOVEMENT_INTERFACE_ID,ENDPOINT),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
FOREIGN KEY (DATA_MOVEMENT_INTERFACE_ID) REFERENCES GRIDFTP_DATA_MOVEMENT(DATA_MOVEMENT_INTERFACE_ID) ON DELETE CASCADE
);
@@ -181,7 +181,7 @@ CREATE TABLE APPLICATION_MODULE
MODULE_VERSION VARCHAR(255),
MODULE_DESC VARCHAR(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY(MODULE_ID)
);
@@ -195,7 +195,7 @@ CREATE TABLE APPLICATION_DEPLOYMENT
APPLICATION_DESC VARCHAR(255),
ENV_MODULE_LOAD_CMD VARCHAR(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY(DEPLOYMENT_ID),
FOREIGN KEY (COMPUTE_HOSTID) REFERENCES COMPUTE_RESOURCE(RESOURCE_ID) ON DELETE CASCADE,
FOREIGN KEY (APP_MODULE_ID) REFERENCES APPLICATION_MODULE(MODULE_ID) ON DELETE CASCADE
@@ -250,7 +250,7 @@ CREATE TABLE APPLICATION_INTERFACE
APPLICATION_NAME VARCHAR(255),
APPLICATION_DESCRIPTION VARCHAR(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY(INTERFACE_ID)
);
@@ -303,7 +303,7 @@ CREATE TABLE GATEWAY_PROFILE
GATEWAY_NAME VARCHAR(255),
GATEWAY_DESC VARCHAR(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY(GATEWAY_ID)
);
@@ -352,7 +352,7 @@ CREATE TABLE JOB_SUBMISSION_INTERFACE
JOB_SUBMISSION_PROTOCOL VARCHAR (255) NOT NULL,
PRIORITY_ORDER INTEGER,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (COMPUTE_RESOURCE_ID,JOB_SUBMISSION_INTERFACE_ID),
FOREIGN KEY (COMPUTE_RESOURCE_ID) REFERENCES COMPUTE_RESOURCE(RESOURCE_ID) ON DELETE CASCADE
);
@@ -364,7 +364,7 @@ CREATE TABLE DATA_MOVEMENT_INTERFACE
DATA_MOVEMENT_INTERFACE_ID VARCHAR (255) NOT NULL,
PRIORITY_ORDER INTEGER,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (COMPUTE_RESOURCE_ID,DATA_MOVEMENT_INTERFACE_ID),
FOREIGN KEY (COMPUTE_RESOURCE_ID) REFERENCES COMPUTE_RESOURCE(RESOURCE_ID) ON DELETE CASCADE
);
@@ -383,7 +383,7 @@ CREATE TABLE LOCAL_SUBMISSION
RESOURCE_JOB_MANAGER_ID VARCHAR (255) NOT NULL,
JOB_SUBMISSION_INTERFACE_ID VARCHAR (255) NOT NULL,
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (JOB_SUBMISSION_INTERFACE_ID),
FOREIGN KEY (RESOURCE_JOB_MANAGER_ID) REFERENCES RESOURCE_JOB_MANAGER(RESOURCE_JOB_MANAGER_ID)
);
@@ -401,7 +401,7 @@ CREATE TABLE WORKFLOW
GRAPH LONGTEXT,
OWNER VARCHAR(255),
CREATION_TIME TIMESTAMP DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00' ON UPDATE now(),
+ UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
IMAGE BLOB,
PRIMARY KEY (WF_TEMPLATE_ID)
);