You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by sc...@apache.org on 2015/07/03 13:53:01 UTC
airavata git commit: Fixing experiment catalog warnings
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 <sc...@apache.org>
Authored: Fri Jul 3 17:18:57 2015 +0530
Committer: Supun Nakandala <sc...@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