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/03/31 23:16:11 UTC

airavata git commit: fixed a bug in app catalog mysql script

Repository: airavata
Updated Branches:
  refs/heads/master 1f9ac846a -> 26cf7edd4


fixed a bug in app catalog mysql script


Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/26cf7edd
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/26cf7edd
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/26cf7edd

Branch: refs/heads/master
Commit: 26cf7edd45dac3909f5caf27ca6f93e9369bb8d4
Parents: 1f9ac84
Author: Chathuri Wimalasena <ka...@gmail.com>
Authored: Tue Mar 31 17:16:06 2015 -0400
Committer: Chathuri Wimalasena <ka...@gmail.com>
Committed: Tue Mar 31 17:16:06 2015 -0400

----------------------------------------------------------------------
 .../app-catalog-data/src/main/resources/appcatalog-mysql.sql     | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/26cf7edd/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 cfb8022..2dcc119 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
@@ -244,7 +244,7 @@ CREATE TABLE PREJOB_COMMAND
          APPDEPLOYMENT_ID VARCHAR(255),
          COMMAND VARCHAR(255),
          PRIMARY KEY(APPDEPLOYMENT_ID, COMMAND),
-         FOREIGN KEY (APPDEPLOYMENT_ID) REFERENCES APPLICATION_DEPLOYMENT(APPDEPLOYMENT_ID) ON DELETE CASCADE
+         FOREIGN KEY (APPDEPLOYMENT_ID) REFERENCES APPLICATION_DEPLOYMENT(DEPLOYMENT_ID) ON DELETE CASCADE
 );
 
 CREATE TABLE POSTJOB_COMMAND
@@ -252,7 +252,7 @@ CREATE TABLE POSTJOB_COMMAND
          APPLICATION_DEPLOYMENT VARCHAR(255),
          COMMAND VARCHAR(255),
          PRIMARY KEY(APPLICATION_DEPLOYMENT, COMMAND),
-         FOREIGN KEY (APPLICATION_DEPLOYMENT) REFERENCES APPLICATION_DEPLOYMENT(APPLICATION_DEPLOYMENT) ON DELETE CASCADE
+         FOREIGN KEY (APPLICATION_DEPLOYMENT) REFERENCES APPLICATION_DEPLOYMENT(DEPLOYMENT_ID) ON DELETE CASCADE
 );
 
 CREATE TABLE APPLICATION_INTERFACE