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 <[email protected]> Authored: Thu Jan 15 11:41:06 2015 -0500 Committer: Chathuri Wimalasena <[email protected]> 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) );
