You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by la...@apache.org on 2015/02/06 17:05:56 UTC
[43/53] [abbrv] airavata git commit: adding useremails to experiment
and task models - AIRAVATA-1563
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/gfac-storm
Commit: 1ec53801d6a3ed040b44689fbf7a308fd7a0da0b
Parents: 7a6fbdb
Author: Chathuri Wimalasena <ka...@gmail.com>
Authored: Wed Feb 4 12:17:52 2015 -0500
Committer: Chathuri Wimalasena <ka...@gmail.com>
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,