[airavata] branch develop updated: Adding metascheduler migration script

[machristie]

This is an automated email from the ASF dual-hosted git repository.

machristie pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/airavata.git


The following commit(s) were added to refs/heads/develop by this push:
     new a8ac0ca3a7 Adding metascheduler migration script
a8ac0ca3a7 is described below

commit a8ac0ca3a70e5a3d9f1697ba5390e64084fab4ba
Author: Marcus Christie <machris...@apache.org>
AuthorDate: Tue May 30 10:55:28 2023 -0400

    Adding metascheduler migration script
---
 .../DeltaScripts/experimentCatalog_schema_delta.sql   | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

diff --git 
a/modules/registry/release-migration-scripts/next/DeltaScripts/experimentCatalog_schema_delta.sql
 
b/modules/registry/release-migration-scripts/next/DeltaScripts/experimentCatalog_schema_delta.sql
index 256ecf0189..95290b3e75 100644
--- 
a/modules/registry/release-migration-scripts/next/DeltaScripts/experimentCatalog_schema_delta.sql
+++ 
b/modules/registry/release-migration-scripts/next/DeltaScripts/experimentCatalog_schema_delta.sql
@@ -17,5 +17,22 @@
 -- specific language governing permissions and limitations
 -- under the License.
 --
+USE experiment_catalog;
 
-use experiment_catalog;
+CREATE TABLE IF NOT EXISTS COMPUTE_RESOURCE_SCHEDULING (
+    EXPERIMENT_ID varchar(255) NOT NULL,
+    RESOURCE_HOST_ID varchar(255) NOT NULL,
+    TOTAL_CPU_COUNT INT,
+    NODE_COUNT INT,
+    NUMBER_OF_THREADS INT,
+    QUEUE_NAME varchar(255) NOT NULL,
+    WALL_TIME_LIMIT INT,
+    TOTAL_PHYSICAL_MEMORY INT,
+    STATIC_WORKING_DIR varchar(255),
+    OVERRIDE_LOGIN_USER_NAME varchar(255),
+    OVERRIDE_SCRATCH_LOCATION varchar(255),
+    OVERRIDE_ALLOCATION_PROJECT_NUMBER varchar(255),
+    PARALLEL_GROUP_COUNT INT,
+    PRIMARY KEY (EXPERIMENT_ID, RESOURCE_HOST_ID, QUEUE_NAME),
+    FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT(EXPERIMENT_ID) ON DELETE 
CASCADE
+) ENGINE = InnoDB DEFAULT CHARSET = latin1;