Repository: airavata Updated Branches: refs/heads/master 7a6fbdb25 -> 1ec53801d
adding useremails to experiment and task models - AIRAVATA-1563 Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/1ec53801 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/1ec53801 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/1ec53801 Branch: refs/heads/master Commit: 1ec53801d6a3ed040b44689fbf7a308fd7a0da0b Parents: 7a6fbdb Author: Chathuri Wimalasena <[email protected]> Authored: Wed Feb 4 12:17:52 2015 -0500 Committer: Chathuri Wimalasena <[email protected]> Committed: Wed Feb 4 12:17:52 2015 -0500 ---------------------------------------------------------------------- .../src/test/resources/registry-derby.sql | 20 +++++++++++++------- 1 file changed, 13 insertions(+), 7 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/1ec53801/modules/registry/airavata-jpa-registry/src/test/resources/registry-derby.sql ---------------------------------------------------------------------- diff --git a/modules/registry/airavata-jpa-registry/src/test/resources/registry-derby.sql b/modules/registry/airavata-jpa-registry/src/test/resources/registry-derby.sql index cb9fc44..c3d7b3a 100644 --- a/modules/registry/airavata-jpa-registry/src/test/resources/registry-derby.sql +++ b/modules/registry/airavata-jpa-registry/src/test/resources/registry-derby.sql @@ -122,13 +122,7 @@ CREATE TABLE EXPERIMENT FOREIGN KEY (PROJECT_ID) REFERENCES PROJECT(PROJECT_ID) ON DELETE CASCADE ); -CREATE TABLE NOTIFICATION_EMAIL -( - EXPERIMENT_ID VARCHAR(255), - EMAIL_ADDRESS VARCHAR(255), - PRIMARY KEY(EXPERIMENT_ID,EMAIL_ADDRESS), - FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE -); + CREATE TABLE EXPERIMENT_INPUT ( @@ -185,10 +179,22 @@ CREATE TABLE TASK_DETAIL APPLICATION_ID VARCHAR(255), APPLICATION_VERSION VARCHAR(255), APPLICATION_DEPLOYMENT_ID VARCHAR(255), + ALLOW_NOTIFICATION SMALLINT, PRIMARY KEY(TASK_ID), FOREIGN KEY (NODE_INSTANCE_ID) REFERENCES WORKFLOW_NODE_DETAIL(NODE_INSTANCE_ID) ON DELETE CASCADE ); +CREATE TABLE NOTIFICATION_EMAIL +( + EMAIL_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY, + EXPERIMENT_ID VARCHAR(255), + TASK_ID VARCHAR(255), + EMAIL_ADDRESS VARCHAR(255), + PRIMARY KEY(EMAIL_ID), + FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE, + FOREIGN KEY (TASK_ID) REFERENCES TASK_DETAIL(TASK_ID) ON DELETE CASCADE +); + CREATE TABLE ERROR_DETAIL ( ERROR_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
