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 <[email protected]> Authored: Fri Jul 3 17:18:57 2015 +0530 Committer: Supun Nakandala <[email protected]> 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
