airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scnakand...@apache.org
Subject airavata git commit: Fixing experiment catalog warnings
Date Fri, 03 Jul 2015 11:53:01 GMT
Repository: airavata
Updated Branches:
  refs/heads/master 953feec6b -> 2dee81be6


Fixing experiment catalog warnings


Project: http://git-wip-us.apache.org/repos/asf/airavata/repo
Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/2dee81be
Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/2dee81be
Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/2dee81be

Branch: refs/heads/master
Commit: 2dee81be62b625503afff881b1c11e4612379f45
Parents: 953feec
Author: Supun Nakandala <scnakandala@apache.org>
Authored: Fri Jul 3 17:18:57 2015 +0530
Committer: Supun Nakandala <scnakandala@apache.org>
Committed: Fri Jul 3 17:18:57 2015 +0530

----------------------------------------------------------------------
 .../experiment/catalog/model/Experiment.java    |  1 +
 .../catalog/model/ExperimentError.java          |  3 ++
 .../catalog/model/ExperimentInput.java          |  1 +
 .../catalog/model/ExperimentOutput.java         |  1 +
 .../core/experiment/catalog/model/Process.java  |  2 +
 .../experiment/catalog/model/ProcessError.java  |  3 ++
 .../experiment/catalog/model/ProcessInput.java  |  1 +
 .../experiment/catalog/model/ProcessOutput.java |  1 +
 .../core/experiment/catalog/model/Task.java     |  1 +
 .../experiment/catalog/model/TaskError.java     |  3 ++
 .../src/main/resources/expcatalog-derby.sql     | 48 ++++++++++----------
 .../src/test/resources/expcatalog-derby.sql     | 48 ++++++++++----------
 12 files changed, 65 insertions(+), 48 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Experiment.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Experiment.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Experiment.java
index 9ff073d..00ca2bc 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Experiment.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Experiment.java
@@ -163,6 +163,7 @@ public class Experiment {
     }
 
     @Basic
+    @Lob
     @Column(name = "EMAIL_ADDRESSES")
     public String getEmailAddresses() {
         return emailAddresses;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentError.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentError.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentError.java
index 7bf9745..af410cc 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentError.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentError.java
@@ -71,6 +71,7 @@ public class ExperimentError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ACTUAL_ERROR_MESSAGE")
     public String getActualErrorMessage() {
         return actualErrorMessage;
@@ -81,6 +82,7 @@ public class ExperimentError {
     }
 
     @Basic
+    @Lob
     @Column(name = "USER_FRIENDLY_MESSAGE")
     public String getUserFriendlyMessage() {
         return userFriendlyMessage;
@@ -101,6 +103,7 @@ public class ExperimentError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ROOT_CAUSE_ERROR_ID_LIST")
     public String getRootCauseErrorIdList() {
         return rootCauseErrorIdList;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentInput.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentInput.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentInput.java
index dbd57ab..cb425bb 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentInput.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentInput.java
@@ -65,6 +65,7 @@ public class ExperimentInput {
     }
 
     @Basic
+    @Lob
     @Column(name = "INPUT_VALUE")
     public String getInputValue() {
         return inputValue;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentOutput.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentOutput.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentOutput.java
index 98c1d44..af81ea2 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentOutput.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ExperimentOutput.java
@@ -63,6 +63,7 @@ public class ExperimentOutput {
     }
 
     @Basic
+    @Lob
     @Column(name = "OUTPUT_VALUE")
     public String getOutputValue() {
         return outputValue;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Process.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Process.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Process.java
index 4226a85..83c45a7 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Process.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Process.java
@@ -92,6 +92,7 @@ public class Process {
     }
 
     @Basic
+    @Lob
     @Column(name = "PROCESS_DETAIL")
     public String getProcessDetail() {
         return processDetail;
@@ -163,6 +164,7 @@ public class Process {
     }
 
     @Basic
+    @Lob
     @Column(name = "EMAIL_ADDRESSES")
     public String getEmailAddresses() {
         return emailAddresses;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessError.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessError.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessError.java
index 141c4bb..14af4f5 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessError.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessError.java
@@ -72,6 +72,7 @@ public class ProcessError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ACTUAL_ERROR_MESSAGE")
     public String getActualErrorMessage() {
         return actualErrorMessage;
@@ -82,6 +83,7 @@ public class ProcessError {
     }
 
     @Basic
+    @Lob
     @Column(name = "USER_FRIENDLY_MESSAGE")
     public String getUserFriendlyMessage() {
         return userFriendlyMessage;
@@ -102,6 +104,7 @@ public class ProcessError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ROOT_CAUSE_ERROR_ID_LIST")
     public String getRootCauseErrorIdList() {
         return rootCauseErrorIdList;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessInput.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessInput.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessInput.java
index d176d1f..70dc3d1 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessInput.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessInput.java
@@ -66,6 +66,7 @@ public class ProcessInput {
     }
 
     @Basic
+    @Lob
     @Column(name = "INPUT_VALUE")
     public String getInputValue() {
         return inputValue;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessOutput.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessOutput.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessOutput.java
index 3bc8689..628b153 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessOutput.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/ProcessOutput.java
@@ -64,6 +64,7 @@ public class ProcessOutput {
     }
 
     @Basic
+    @Lob
     @Column(name = "OUTPUT_VALUE")
     public String getOutputValue() {
         return outputValue;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Task.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Task.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Task.java
index b6386c3..57814d0 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Task.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Task.java
@@ -94,6 +94,7 @@ public class Task {
     }
 
     @Basic
+    @Lob
     @Column(name = "TASK_DETAIL")
     public String getTaskDetail() {
         return taskDetail;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskError.java
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskError.java
b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskError.java
index a96c392..ad6dccd 100644
--- a/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskError.java
+++ b/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/TaskError.java
@@ -71,6 +71,7 @@ public class TaskError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ACTUAL_ERROR_MESSAGE")
     public String getActualErrorMessage() {
         return actualErrorMessage;
@@ -81,6 +82,7 @@ public class TaskError {
     }
 
     @Basic
+    @Lob
     @Column(name = "USER_FRIENDLY_MESSAGE")
     public String getUserFriendlyMessage() {
         return userFriendlyMessage;
@@ -101,6 +103,7 @@ public class TaskError {
     }
 
     @Basic
+    @Lob
     @Column(name = "ROOT_CAUSE_ERROR_ID_LIST")
     public String getRootCauseErrorIdList() {
         return rootCauseErrorIdList;

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql b/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql
index 2f49394..ac8c913 100644
--- a/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql
+++ b/modules/registry/registry-core/src/main/resources/expcatalog-derby.sql
@@ -76,7 +76,7 @@ CREATE TABLE EXPERIMENT (
   DESCRIPTION varchar(255),
   EXECUTION_ID varchar(255),
   GATEWAY_EXECUTION_ID varchar(255),
-  ENABLE_EMAIL_NOTIFICATION BOOLEAN,
+  ENABLE_EMAIL_NOTIFICATION SMALLINT,
   EMAIL_ADDRESSES CLOB,
   PRIMARY KEY (EXPERIMENT_ID),
   FOREIGN KEY (USER_NAME) REFERENCES USERS(USER_NAME) ON DELETE CASCADE,
@@ -91,13 +91,13 @@ CREATE TABLE EXPERIMENT_INPUT
     INPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    STANDARD_INPUT BOOLEAN,
+    STANDARD_INPUT SMALLINT,
     USER_FRIENDLY_DESCRIPTION varchar(255),
     METADATA varchar(255),
     INPUT_ORDER INT,
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_STAGED BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_STAGED SMALLINT,
     PRIMARY KEY(EXPERIMENT_ID,INPUT_NAME),
     FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
 );
@@ -109,9 +109,9 @@ CREATE TABLE EXPERIMENT_OUTPUT
     OUTPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_MOVEMENT BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_MOVEMENT SMALLINT,
     LOCATION varchar(255),
     SEARCH_QUERY varchar(255),
     PRIMARY KEY(EXPERIMENT_ID,OUTPUT_NAME),
@@ -136,7 +136,7 @@ CREATE TABLE EXPERIMENT_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, EXPERIMENT_ID),
   FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
@@ -144,12 +144,12 @@ CREATE TABLE EXPERIMENT_ERROR (
 
 CREATE TABLE USER_CONFIGURATION_DATA (
   EXPERIMENT_ID varchar(255),
-  AIRAVATA_AUTO_SCHEDULE BOOLEAN,
-  OVERRIDE_MANUAL_SCHEDULED_PARAMS BOOLEAN,
-  SHARE_EXPERIMENT_PUBLICALLY BOOLEAN,
-  THROTTLE_RESOURCES BOOLEAN,
+  AIRAVATA_AUTO_SCHEDULE SMALLINT,
+  OVERRIDE_MANUAL_SCHEDULED_PARAMS SMALLINT,
+  SHARE_EXPERIMENT_PUBLICALLY SMALLINT,
+  THROTTLE_RESOURCES SMALLINT,
   USER_DN varchar(255),
-  GENERATE_CERT BOOLEAN,
+  GENERATE_CERT SMALLINT,
   RESOURCE_HOST_ID varchar(255),
   TOTAL_CPU_COUNT INT,
   NODE_COUNT INT,
@@ -185,7 +185,7 @@ CREATE TABLE PROCESS (
   APPLICATION_DEPLOYMENT_ID varchar(255),
   COMPUTE_RESOURCE_ID varchar(255),
   GATEWAY_EXECUTION_ID varchar(255),
-  ENABLE_EMAIL_NOTIFICATION BOOLEAN,
+  ENABLE_EMAIL_NOTIFICATION SMALLINT,
   EMAIL_ADDRESSES CLOB,
   PRIMARY KEY (PROCESS_ID),
   FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
@@ -198,13 +198,13 @@ CREATE TABLE PROCESS_INPUT
     INPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    STANDARD_INPUT BOOLEAN,
+    STANDARD_INPUT SMALLINT,
     USER_FRIENDLY_DESCRIPTION varchar(255),
     METADATA varchar(255),
     INPUT_ORDER INT,
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_STAGED BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_STAGED SMALLINT,
     PRIMARY KEY(PROCESS_ID,INPUT_NAME),
     FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE
 );
@@ -216,9 +216,9 @@ CREATE TABLE PROCESS_OUTPUT
     OUTPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_MOVEMENT BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_MOVEMENT SMALLINT,
     LOCATION varchar(255),
     SEARCH_QUERY varchar(255),
     PRIMARY KEY(PROCESS_ID,OUTPUT_NAME),
@@ -243,7 +243,7 @@ CREATE TABLE PROCESS_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, PROCESS_ID),
   FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE
@@ -291,7 +291,7 @@ CREATE TABLE TASK_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, TASK_ID),
   FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE

http://git-wip-us.apache.org/repos/asf/airavata/blob/2dee81be/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql
----------------------------------------------------------------------
diff --git a/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql b/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql
index 2f49394..ac8c913 100644
--- a/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql
+++ b/modules/registry/registry-core/src/test/resources/expcatalog-derby.sql
@@ -76,7 +76,7 @@ CREATE TABLE EXPERIMENT (
   DESCRIPTION varchar(255),
   EXECUTION_ID varchar(255),
   GATEWAY_EXECUTION_ID varchar(255),
-  ENABLE_EMAIL_NOTIFICATION BOOLEAN,
+  ENABLE_EMAIL_NOTIFICATION SMALLINT,
   EMAIL_ADDRESSES CLOB,
   PRIMARY KEY (EXPERIMENT_ID),
   FOREIGN KEY (USER_NAME) REFERENCES USERS(USER_NAME) ON DELETE CASCADE,
@@ -91,13 +91,13 @@ CREATE TABLE EXPERIMENT_INPUT
     INPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    STANDARD_INPUT BOOLEAN,
+    STANDARD_INPUT SMALLINT,
     USER_FRIENDLY_DESCRIPTION varchar(255),
     METADATA varchar(255),
     INPUT_ORDER INT,
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_STAGED BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_STAGED SMALLINT,
     PRIMARY KEY(EXPERIMENT_ID,INPUT_NAME),
     FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
 );
@@ -109,9 +109,9 @@ CREATE TABLE EXPERIMENT_OUTPUT
     OUTPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_MOVEMENT BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_MOVEMENT SMALLINT,
     LOCATION varchar(255),
     SEARCH_QUERY varchar(255),
     PRIMARY KEY(EXPERIMENT_ID,OUTPUT_NAME),
@@ -136,7 +136,7 @@ CREATE TABLE EXPERIMENT_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, EXPERIMENT_ID),
   FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
@@ -144,12 +144,12 @@ CREATE TABLE EXPERIMENT_ERROR (
 
 CREATE TABLE USER_CONFIGURATION_DATA (
   EXPERIMENT_ID varchar(255),
-  AIRAVATA_AUTO_SCHEDULE BOOLEAN,
-  OVERRIDE_MANUAL_SCHEDULED_PARAMS BOOLEAN,
-  SHARE_EXPERIMENT_PUBLICALLY BOOLEAN,
-  THROTTLE_RESOURCES BOOLEAN,
+  AIRAVATA_AUTO_SCHEDULE SMALLINT,
+  OVERRIDE_MANUAL_SCHEDULED_PARAMS SMALLINT,
+  SHARE_EXPERIMENT_PUBLICALLY SMALLINT,
+  THROTTLE_RESOURCES SMALLINT,
   USER_DN varchar(255),
-  GENERATE_CERT BOOLEAN,
+  GENERATE_CERT SMALLINT,
   RESOURCE_HOST_ID varchar(255),
   TOTAL_CPU_COUNT INT,
   NODE_COUNT INT,
@@ -185,7 +185,7 @@ CREATE TABLE PROCESS (
   APPLICATION_DEPLOYMENT_ID varchar(255),
   COMPUTE_RESOURCE_ID varchar(255),
   GATEWAY_EXECUTION_ID varchar(255),
-  ENABLE_EMAIL_NOTIFICATION BOOLEAN,
+  ENABLE_EMAIL_NOTIFICATION SMALLINT,
   EMAIL_ADDRESSES CLOB,
   PRIMARY KEY (PROCESS_ID),
   FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE CASCADE
@@ -198,13 +198,13 @@ CREATE TABLE PROCESS_INPUT
     INPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    STANDARD_INPUT BOOLEAN,
+    STANDARD_INPUT SMALLINT,
     USER_FRIENDLY_DESCRIPTION varchar(255),
     METADATA varchar(255),
     INPUT_ORDER INT,
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_STAGED BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_STAGED SMALLINT,
     PRIMARY KEY(PROCESS_ID,INPUT_NAME),
     FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE
 );
@@ -216,9 +216,9 @@ CREATE TABLE PROCESS_OUTPUT
     OUTPUT_VALUE CLOB,
     DATA_TYPE varchar(255),
     APPLICATION_ARGUMENT varchar(255),
-    IS_REQUIRED BOOLEAN,
-    REQUIRED_TO_ADDED_TO_CMD BOOLEAN,
-    DATA_MOVEMENT BOOLEAN,
+    IS_REQUIRED SMALLINT,
+    REQUIRED_TO_ADDED_TO_CMD SMALLINT,
+    DATA_MOVEMENT SMALLINT,
     LOCATION varchar(255),
     SEARCH_QUERY varchar(255),
     PRIMARY KEY(PROCESS_ID,OUTPUT_NAME),
@@ -243,7 +243,7 @@ CREATE TABLE PROCESS_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, PROCESS_ID),
   FOREIGN KEY (PROCESS_ID) REFERENCES PROCESS(PROCESS_ID) ON DELETE CASCADE
@@ -291,7 +291,7 @@ CREATE TABLE TASK_ERROR (
   CREATION_TIME timestamp DEFAULT CURRENT_TIMESTAMP,
   ACTUAL_ERROR_MESSAGE CLOB,
   USER_FRIENDLY_MESSAGE CLOB,
-  TRANSIENT_OR_PERSISTENT BOOLEAN,
+  TRANSIENT_OR_PERSISTENT SMALLINT,
   ROOT_CAUSE_ERROR_ID_LIST CLOB,
   PRIMARY KEY (ERROR_ID, TASK_ID),
   FOREIGN KEY (TASK_ID) REFERENCES TASK(TASK_ID) ON DELETE CASCADE


Mime
View raw message