fixing app-catalog sql script issue in POSTJOB_COMMAND
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/d8df3d00 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/d8df3d00 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/d8df3d00 Branch: refs/heads/master Commit: d8df3d00c2cb701608866c39d61c02220f135378 Parents: ce79558 Author: scnakandala <[email protected]> Authored: Mon Feb 8 10:22:41 2016 -0500 Committer: scnakandala <[email protected]> Committed: Mon Feb 8 10:22:41 2016 -0500 ---------------------------------------------------------------------- .../registry-core/src/main/resources/appcatalog-mysql.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/d8df3d00/modules/registry/registry-core/src/main/resources/appcatalog-mysql.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/resources/appcatalog-mysql.sql b/modules/registry/registry-core/src/main/resources/appcatalog-mysql.sql index b0d53de..6695a81 100644 --- a/modules/registry/registry-core/src/main/resources/appcatalog-mysql.sql +++ b/modules/registry/registry-core/src/main/resources/appcatalog-mysql.sql @@ -252,10 +252,10 @@ CREATE TABLE PREJOB_COMMAND CREATE TABLE POSTJOB_COMMAND ( - APPLICATION_DEPLOYMENT VARCHAR(255), + APPDEPLOYMENT_ID VARCHAR(255), COMMAND VARCHAR(255), - PRIMARY KEY(APPLICATION_DEPLOYMENT, COMMAND), - FOREIGN KEY (APPLICATION_DEPLOYMENT) REFERENCES APPLICATION_DEPLOYMENT(DEPLOYMENT_ID) ON DELETE CASCADE + PRIMARY KEY(APPDEPLOYMENT_ID, COMMAND), + FOREIGN KEY (APPDEPLOYMENT_ID) REFERENCES APPLICATION_DEPLOYMENT(DEPLOYMENT_ID) ON DELETE CASCADE ); CREATE TABLE APPLICATION_INTERFACE
