airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chath...@apache.org
Subject airavata git commit: adding useremails to experiment and task models - AIRAVATA-1563
Date Wed, 04 Feb 2015 17:17:58 GMT
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 <kamalasini@gmail.com>
Authored: Wed Feb 4 12:17:52 2015 -0500
Committer: Chathuri Wimalasena <kamalasini@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,


Mime
View raw message