Repository: airavata Updated Branches: refs/heads/master 98f03190a -> 4e47079e0
missing app-catalog tables Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/4e47079e Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/4e47079e Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/4e47079e Branch: refs/heads/master Commit: 4e47079e0337cb347f54dde088c67a99107aabe9 Parents: 98f0319 Author: Chathuri Wimalasena <[email protected]> Authored: Mon Oct 20 14:15:37 2014 -0400 Committer: Chathuri Wimalasena <[email protected]> Committed: Mon Oct 20 14:15:37 2014 -0400 ---------------------------------------------------------------------- .../src/main/resources/appcatalog-derby.sql | 25 ++++++++++++++ .../src/test/resources/appcatalog-derby.sql | 34 ++++++++++++++++++++ 2 files changed, 59 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/4e47079e/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-derby.sql ---------------------------------------------------------------------- diff --git a/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-derby.sql b/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-derby.sql index f522274..7037508 100644 --- a/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-derby.sql +++ b/modules/app-catalog/app-catalog-data/src/main/resources/appcatalog-derby.sql @@ -389,9 +389,34 @@ CREATE TABLE WORKFLOW OWNER VARCHAR(255), CREATION_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00', + IMAGE BLOB, PRIMARY KEY (WF_TEMPLATE_ID) ); +CREATE TABLE WORKFLOW_INPUT +( + WF_TEMPLATE_ID VARCHAR(255), + INPUT_KEY VARCHAR(255), + INPUT_VALUE CLOB, + DATA_TYPE VARCHAR(255), + METADATA VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + STANDARD_INPUT SMALLINT, + USER_FRIENDLY_DESC VARCHAR(255), + PRIMARY KEY(WF_TEMPLATE_ID,INPUT_KEY), + FOREIGN KEY (WF_TEMPLATE_ID) REFERENCES WORKFLOW(WF_TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE WORKFLOW_OUTPUT +( + WF_TEMPLATE_ID VARCHAR(255), + OUTPUT_KEY VARCHAR(255), + OUTPUT_VALUE CLOB, + DATA_TYPE VARCHAR(255), + PRIMARY KEY(WF_TEMPLATE_ID,OUTPUT_KEY), + FOREIGN KEY (WF_TEMPLATE_ID) REFERENCES WORKFLOW(WF_TEMPLATE_ID) ON DELETE CASCADE +); + CREATE TABLE CONFIGURATION ( CONFIG_KEY VARCHAR(255), http://git-wip-us.apache.org/repos/asf/airavata/blob/4e47079e/modules/app-catalog/app-catalog-data/src/test/resources/appcatalog-derby.sql ---------------------------------------------------------------------- diff --git a/modules/app-catalog/app-catalog-data/src/test/resources/appcatalog-derby.sql b/modules/app-catalog/app-catalog-data/src/test/resources/appcatalog-derby.sql index 9129559..7037508 100644 --- a/modules/app-catalog/app-catalog-data/src/test/resources/appcatalog-derby.sql +++ b/modules/app-catalog/app-catalog-data/src/test/resources/appcatalog-derby.sql @@ -87,6 +87,15 @@ CREATE TABLE GLOBUS_SUBMISSION PRIMARY KEY(SUBMISSION_ID) ); +CREATE TABLE UNICORE_SUBMISSION +( + SUBMISSION_ID VARCHAR(255), + SECURITY_PROTOCAL VARCHAR(255), + UNICORE_ENDPOINT_URL VARCHAR(255), + PRIMARY KEY(SUBMISSION_ID) +); + + CREATE TABLE GLOBUS_GK_ENDPOINT ( SUBMISSION_ID VARCHAR(255), @@ -380,9 +389,34 @@ CREATE TABLE WORKFLOW OWNER VARCHAR(255), CREATION_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00', + IMAGE BLOB, PRIMARY KEY (WF_TEMPLATE_ID) ); +CREATE TABLE WORKFLOW_INPUT +( + WF_TEMPLATE_ID VARCHAR(255), + INPUT_KEY VARCHAR(255), + INPUT_VALUE CLOB, + DATA_TYPE VARCHAR(255), + METADATA VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + STANDARD_INPUT SMALLINT, + USER_FRIENDLY_DESC VARCHAR(255), + PRIMARY KEY(WF_TEMPLATE_ID,INPUT_KEY), + FOREIGN KEY (WF_TEMPLATE_ID) REFERENCES WORKFLOW(WF_TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE WORKFLOW_OUTPUT +( + WF_TEMPLATE_ID VARCHAR(255), + OUTPUT_KEY VARCHAR(255), + OUTPUT_VALUE CLOB, + DATA_TYPE VARCHAR(255), + PRIMARY KEY(WF_TEMPLATE_ID,OUTPUT_KEY), + FOREIGN KEY (WF_TEMPLATE_ID) REFERENCES WORKFLOW(WF_TEMPLATE_ID) ON DELETE CASCADE +); + CREATE TABLE CONFIGURATION ( CONFIG_KEY VARCHAR(255),
