This is an automated email from the ASF dual-hosted git repository.
dimuthuupe 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 22f216a Adding initial database dump
22f216a is described below
commit 22f216a145be2d3aa7d8382b8ed3634b035f96f8
Author: Dimuthu Wannipurage <[email protected]>
AuthorDate: Mon Mar 11 15:18:23 2019 -0400
Adding initial database dump
---
.../ide-integration/src/main/resources/.gitignore | 1 +
.../database_scripts/init/01-databases.sql | 3596 +++++++++++++++++++-
2 files changed, 3590 insertions(+), 7 deletions(-)
diff --git a/modules/ide-integration/src/main/resources/.gitignore
b/modules/ide-integration/src/main/resources/.gitignore
new file mode 100644
index 0000000..69c3559
--- /dev/null
+++ b/modules/ide-integration/src/main/resources/.gitignore
@@ -0,0 +1 @@
+database_data/
diff --git
a/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
b/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
index bc6272f..ba3716c 100644
---
a/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
+++
b/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
@@ -1,7 +1,3589 @@
-CREATE DATABASE IF NOT EXISTS `experiment_catalog`;
-CREATE DATABASE IF NOT EXISTS `app_catalog`;
-CREATE DATABASE IF NOT EXISTS `workflow_catalog`;
-CREATE DATABASE IF NOT EXISTS `replica_catalog`;
-CREATE DATABASE IF NOT EXISTS `credential_store`;
-CREATE DATABASE IF NOT EXISTS `sharing_catalog`;
-CREATE DATABASE IF NOT EXISTS `profile_service`;
+-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
+--
+-- Host: localhost Database: app_catalog
+-- ------------------------------------------------------
+-- Server version 5.7.21
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Current Database: `app_catalog`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `app_catalog` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `app_catalog`;
+
+--
+-- Table structure for table `APPLICATION_DEPLOYMENT`
+--
+
+DROP TABLE IF EXISTS `APPLICATION_DEPLOYMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPLICATION_DEPLOYMENT` (
+ `DEPLOYMENT_ID` varchar(255) NOT NULL,
+ `APP_MODULE_ID` varchar(255) NOT NULL,
+ `COMPUTE_HOSTID` varchar(255) NOT NULL,
+ `EXECUTABLE_PATH` varchar(255) DEFAULT NULL,
+ `PARALLELISM` varchar(255) DEFAULT NULL,
+ `APPLICATION_DESC` varchar(255) DEFAULT NULL,
+ `ENV_MODULE_LOAD_CMD` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `DEFAULT_QUEUE_NAME` varchar(255) DEFAULT NULL,
+ `DEFAULT_NODE_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_CPU_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_WALLTIME` int(11) DEFAULT NULL,
+ `EDITABLE_BY_USER` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`DEPLOYMENT_ID`),
+ KEY `COMPUTE_HOSTID` (`COMPUTE_HOSTID`),
+ KEY `APP_MODULE_ID` (`APP_MODULE_ID`),
+ CONSTRAINT `application_deployment_ibfk_1` FOREIGN KEY (`COMPUTE_HOSTID`)
REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE,
+ CONSTRAINT `application_deployment_ibfk_2` FOREIGN KEY (`APP_MODULE_ID`)
REFERENCES `APPLICATION_MODULE` (`MODULE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APPLICATION_DEPLOYMENT`
+--
+
+LOCK TABLES `APPLICATION_DEPLOYMENT` WRITE;
+/*!40000 ALTER TABLE `APPLICATION_DEPLOYMENT` DISABLE KEYS */;
+INSERT INTO `APPLICATION_DEPLOYMENT` VALUES
('js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','/home/grid_user/apps/echo_wrapper.sh','SERIAL','',NULL,'2019-02-26
10:42:01','2019-02-26 10:42:01','default','cloud',1,2,0,0);
+/*!40000 ALTER TABLE `APPLICATION_DEPLOYMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APPLICATION_INPUT`
+--
+
+DROP TABLE IF EXISTS `APPLICATION_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPLICATION_INPUT` (
+ `INTERFACE_ID` varchar(255) NOT NULL,
+ `INPUT_KEY` varchar(255) NOT NULL,
+ `INPUT_VALUE` varchar(255) DEFAULT NULL,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `METADATA` varchar(4096) DEFAULT NULL,
+ `APP_ARGUMENT` varchar(255) DEFAULT NULL,
+ `STANDARD_INPUT` smallint(6) DEFAULT NULL,
+ `USER_FRIENDLY_DESC` varchar(255) DEFAULT NULL,
+ `INPUT_ORDER` int(11) DEFAULT NULL,
+ `IS_REQUIRED` smallint(6) DEFAULT NULL,
+ `REQUIRED_TO_COMMANDLINE` smallint(6) DEFAULT NULL,
+ `DATA_STAGED` smallint(6) DEFAULT NULL,
+ `IS_READ_ONLY` smallint(6) DEFAULT NULL,
+ PRIMARY KEY (`INTERFACE_ID`,`INPUT_KEY`),
+ CONSTRAINT `application_input_ibfk_1` FOREIGN KEY (`INTERFACE_ID`)
REFERENCES `APPLICATION_INTERFACE` (`INTERFACE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APPLICATION_INPUT`
+--
+
+LOCK TABLES `APPLICATION_INPUT` WRITE;
+/*!40000 ALTER TABLE `APPLICATION_INPUT` DISABLE KEYS */;
+INSERT INTO `APPLICATION_INPUT` VALUES
('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Input-To-Echo','','STRING',NULL,'',0,'',0,1,1,0,0);
+/*!40000 ALTER TABLE `APPLICATION_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APPLICATION_INTERFACE`
+--
+
+DROP TABLE IF EXISTS `APPLICATION_INTERFACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPLICATION_INTERFACE` (
+ `INTERFACE_ID` varchar(255) NOT NULL,
+ `APPLICATION_NAME` varchar(255) DEFAULT NULL,
+ `APPLICATION_DESCRIPTION` varchar(500) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `ARCHIVE_WORKING_DIRECTORY` smallint(6) DEFAULT NULL,
+ `HAS_OPTIONAL_FILE_INPUTS` tinyint(1) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`INTERFACE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APPLICATION_INTERFACE`
+--
+
+LOCK TABLES `APPLICATION_INTERFACE` WRITE;
+/*!40000 ALTER TABLE `APPLICATION_INTERFACE` DISABLE KEYS */;
+INSERT INTO `APPLICATION_INTERFACE` VALUES
('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Echo','A Simple Echo
Application','default',1,0,'2019-02-25 18:57:38','2019-02-25 18:57:38');
+/*!40000 ALTER TABLE `APPLICATION_INTERFACE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APPLICATION_MODULE`
+--
+
+DROP TABLE IF EXISTS `APPLICATION_MODULE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPLICATION_MODULE` (
+ `MODULE_ID` varchar(255) NOT NULL,
+ `MODULE_NAME` varchar(255) DEFAULT NULL,
+ `MODULE_VERSION` varchar(255) DEFAULT NULL,
+ `MODULE_DESC` varchar(500) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`MODULE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APPLICATION_MODULE`
+--
+
+LOCK TABLES `APPLICATION_MODULE` WRITE;
+/*!40000 ALTER TABLE `APPLICATION_MODULE` DISABLE KEYS */;
+INSERT INTO `APPLICATION_MODULE` VALUES
('Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','Echo','','','default','2019-02-25
18:53:41','2019-02-25 18:53:41');
+/*!40000 ALTER TABLE `APPLICATION_MODULE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APPLICATION_OUTPUT`
+--
+
+DROP TABLE IF EXISTS `APPLICATION_OUTPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPLICATION_OUTPUT` (
+ `INTERFACE_ID` varchar(255) NOT NULL,
+ `OUTPUT_KEY` varchar(255) NOT NULL,
+ `OUTPUT_VALUE` varchar(255) DEFAULT NULL,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `IS_REQUIRED` smallint(6) DEFAULT NULL,
+ `REQUIRED_TO_COMMANDLINE` smallint(6) DEFAULT NULL,
+ `DATA_MOVEMENT` smallint(6) DEFAULT NULL,
+ `DATA_NAME_LOCATION` varchar(255) DEFAULT NULL,
+ `SEARCH_QUERY` varchar(255) DEFAULT NULL,
+ `APP_ARGUMENT` varchar(255) DEFAULT NULL,
+ `OUTPUT_STREAMING` smallint(6) DEFAULT NULL,
+ PRIMARY KEY (`INTERFACE_ID`,`OUTPUT_KEY`),
+ CONSTRAINT `application_output_ibfk_1` FOREIGN KEY (`INTERFACE_ID`)
REFERENCES `APPLICATION_INTERFACE` (`INTERFACE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APPLICATION_OUTPUT`
+--
+
+LOCK TABLES `APPLICATION_OUTPUT` WRITE;
+/*!40000 ALTER TABLE `APPLICATION_OUTPUT` DISABLE KEYS */;
+INSERT INTO `APPLICATION_OUTPUT` VALUES
('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Echo-Standard-Error','','STDERR',1,0,0,NULL,'','',0),('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Echo-Standard-Out','','STDOUT',1,0,0,NULL,'','',0);
+/*!40000 ALTER TABLE `APPLICATION_OUTPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APP_ENVIRONMENT`
+--
+
+DROP TABLE IF EXISTS `APP_ENVIRONMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APP_ENVIRONMENT` (
+ `DEPLOYMENT_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `VALUE` varchar(255) DEFAULT NULL,
+ `ENV_ORDER` int(11) DEFAULT NULL,
+ PRIMARY KEY (`DEPLOYMENT_ID`,`NAME`),
+ CONSTRAINT `app_environment_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID`) REFERENCES
`APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APP_ENVIRONMENT`
+--
+
+LOCK TABLES `APP_ENVIRONMENT` WRITE;
+/*!40000 ALTER TABLE `APP_ENVIRONMENT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `APP_ENVIRONMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `APP_MODULE_MAPPING`
+--
+
+DROP TABLE IF EXISTS `APP_MODULE_MAPPING`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APP_MODULE_MAPPING` (
+ `INTERFACE_ID` varchar(255) NOT NULL,
+ `MODULE_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`INTERFACE_ID`,`MODULE_ID`),
+ KEY `MODULE_ID` (`MODULE_ID`),
+ CONSTRAINT `app_module_mapping_ibfk_1` FOREIGN KEY (`INTERFACE_ID`)
REFERENCES `APPLICATION_INTERFACE` (`INTERFACE_ID`) ON DELETE CASCADE,
+ CONSTRAINT `app_module_mapping_ibfk_2` FOREIGN KEY (`MODULE_ID`) REFERENCES
`APPLICATION_MODULE` (`MODULE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `APP_MODULE_MAPPING`
+--
+
+LOCK TABLES `APP_MODULE_MAPPING` WRITE;
+/*!40000 ALTER TABLE `APP_MODULE_MAPPING` DISABLE KEYS */;
+INSERT INTO `APP_MODULE_MAPPING` VALUES
('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84');
+/*!40000 ALTER TABLE `APP_MODULE_MAPPING` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `BATCH_QUEUE`
+--
+
+DROP TABLE IF EXISTS `BATCH_QUEUE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BATCH_QUEUE` (
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `MAX_RUNTIME` int(11) DEFAULT NULL,
+ `MAX_JOB_IN_QUEUE` int(11) DEFAULT NULL,
+ `QUEUE_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `QUEUE_NAME` varchar(255) NOT NULL,
+ `MAX_PROCESSORS` int(11) DEFAULT NULL,
+ `MAX_NODES` int(11) DEFAULT NULL,
+ `MAX_MEMORY` int(11) DEFAULT NULL,
+ `CPU_PER_NODE` int(11) DEFAULT NULL,
+ `DEFAULT_NODE_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_CPU_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_WALLTIME` int(11) DEFAULT NULL,
+ `QUEUE_SPECIFIC_MACROS` varchar(255) DEFAULT NULL,
+ `IS_DEFAULT_QUEUE` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`COMPUTE_RESOURCE_ID`,`QUEUE_NAME`),
+ CONSTRAINT `batch_queue_ibfk_1` FOREIGN KEY (`COMPUTE_RESOURCE_ID`)
REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `BATCH_QUEUE`
+--
+
+LOCK TABLES `BATCH_QUEUE` WRITE;
+/*!40000 ALTER TABLE `BATCH_QUEUE` DISABLE KEYS */;
+INSERT INTO `BATCH_QUEUE` VALUES
('js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61',180,300,'cloud
partition','cloud',4,2,0,2,1,2,30,'',0);
+/*!40000 ALTER TABLE `BATCH_QUEUE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `BATCH_QUEUE_RESOURCE_POLICY`
+--
+
+DROP TABLE IF EXISTS `BATCH_QUEUE_RESOURCE_POLICY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BATCH_QUEUE_RESOURCE_POLICY` (
+ `RESOURCE_POLICY_ID` varchar(255) NOT NULL,
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) NOT NULL,
+ `QUEUE_NAME` varchar(255) NOT NULL,
+ `MAX_ALLOWED_NODES` int(11) DEFAULT NULL,
+ `MAX_ALLOWED_CORES` int(11) DEFAULT NULL,
+ `MAX_ALLOWED_WALLTIME` int(11) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_POLICY_ID`),
+ KEY `COMPUTE_RESOURCE_ID` (`COMPUTE_RESOURCE_ID`),
+ KEY `GROUP_RESOURCE_PROFILE_ID` (`GROUP_RESOURCE_PROFILE_ID`),
+ CONSTRAINT `batch_queue_resource_policy_ibfk_1` FOREIGN KEY
(`COMPUTE_RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE
CASCADE,
+ CONSTRAINT `batch_queue_resource_policy_ibfk_2` FOREIGN KEY
(`GROUP_RESOURCE_PROFILE_ID`) REFERENCES `GROUP_RESOURCE_PROFILE`
(`GROUP_RESOURCE_PROFILE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `BATCH_QUEUE_RESOURCE_POLICY`
+--
+
+LOCK TABLES `BATCH_QUEUE_RESOURCE_POLICY` WRITE;
+/*!40000 ALTER TABLE `BATCH_QUEUE_RESOURCE_POLICY` DISABLE KEYS */;
+/*!40000 ALTER TABLE `BATCH_QUEUE_RESOURCE_POLICY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `CLOUD_JOB_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `CLOUD_JOB_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CLOUD_JOB_SUBMISSION` (
+ `JOB_SUBMISSION_INTERFACE_ID` varchar(255) NOT NULL,
+ `EXECUTABLE_TYPE` varchar(255) DEFAULT NULL,
+ `NODE_ID` varchar(255) DEFAULT NULL,
+ `PROVIDER_NAME` varchar(255) DEFAULT NULL,
+ `SECURITY_PROTOCOL` varchar(255) DEFAULT NULL,
+ `USER_ACCOUNT_NAME` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`JOB_SUBMISSION_INTERFACE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CLOUD_JOB_SUBMISSION`
+--
+
+LOCK TABLES `CLOUD_JOB_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `CLOUD_JOB_SUBMISSION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `CLOUD_JOB_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `COMPUTE_RESOURCE`
+--
+
+DROP TABLE IF EXISTS `COMPUTE_RESOURCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMPUTE_RESOURCE` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `HOST_NAME` varchar(255) NOT NULL,
+ `RESOURCE_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `MAX_MEMORY_NODE` int(11) DEFAULT NULL,
+ `CPUS_PER_NODE` int(11) DEFAULT NULL,
+ `DEFAULT_NODE_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_CPU_COUNT` int(11) DEFAULT NULL,
+ `DEFAULT_WALLTIME` int(11) DEFAULT NULL,
+ `ENABLED` smallint(6) DEFAULT NULL,
+ `GATEWAY_USAGE_REPORTING` tinyint(1) DEFAULT NULL,
+ `GATEWAY_USAGE_MODULE_LOAD_CMD` varchar(500) DEFAULT NULL,
+ `GATEWAY_USAGE_EXECUTABLE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMPUTE_RESOURCE`
+--
+
+LOCK TABLES `COMPUTE_RESOURCE` WRITE;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE` DISABLE KEYS */;
+INSERT INTO `COMPUTE_RESOURCE` VALUES
('js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','js-156-93.jetstream-cloud.org','','2019-02-25
23:50:45','2019-02-25 23:50:45',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL);
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `COMPUTE_RESOURCE_FILE_SYSTEM`
+--
+
+DROP TABLE IF EXISTS `COMPUTE_RESOURCE_FILE_SYSTEM`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMPUTE_RESOURCE_FILE_SYSTEM` (
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `PATH` varchar(255) DEFAULT NULL,
+ `FILE_SYSTEM` varchar(255) NOT NULL,
+ PRIMARY KEY (`COMPUTE_RESOURCE_ID`,`FILE_SYSTEM`),
+ CONSTRAINT `compute_resource_file_system_ibfk_1` FOREIGN KEY
(`COMPUTE_RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE
CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMPUTE_RESOURCE_FILE_SYSTEM`
+--
+
+LOCK TABLES `COMPUTE_RESOURCE_FILE_SYSTEM` WRITE;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_FILE_SYSTEM` DISABLE KEYS */;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_FILE_SYSTEM` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `COMPUTE_RESOURCE_POLICY`
+--
+
+DROP TABLE IF EXISTS `COMPUTE_RESOURCE_POLICY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMPUTE_RESOURCE_POLICY` (
+ `RESOURCE_POLICY_ID` varchar(255) NOT NULL,
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`RESOURCE_POLICY_ID`),
+ KEY `COMPUTE_RESOURCE_ID` (`COMPUTE_RESOURCE_ID`),
+ KEY `GROUP_RESOURCE_PROFILE_ID` (`GROUP_RESOURCE_PROFILE_ID`),
+ CONSTRAINT `compute_resource_policy_ibfk_1` FOREIGN KEY
(`COMPUTE_RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE
CASCADE,
+ CONSTRAINT `compute_resource_policy_ibfk_2` FOREIGN KEY
(`GROUP_RESOURCE_PROFILE_ID`) REFERENCES `GROUP_RESOURCE_PROFILE`
(`GROUP_RESOURCE_PROFILE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMPUTE_RESOURCE_POLICY`
+--
+
+LOCK TABLES `COMPUTE_RESOURCE_POLICY` WRITE;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_POLICY` DISABLE KEYS */;
+INSERT INTO `COMPUTE_RESOURCE_POLICY` VALUES
('ae1b950e-b714-4d59-949b-338c6d6cf640','js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','af03c63d-a40e-4ed1-aee0-759a6ed0202c');
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_POLICY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `COMPUTE_RESOURCE_POLICY_QUEUES`
+--
+
+DROP TABLE IF EXISTS `COMPUTE_RESOURCE_POLICY_QUEUES`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMPUTE_RESOURCE_POLICY_QUEUES` (
+ `RESOURCE_POLICY_ID` varchar(255) NOT NULL,
+ `QUEUE_NAME` varchar(255) NOT NULL,
+ PRIMARY KEY (`RESOURCE_POLICY_ID`,`QUEUE_NAME`),
+ CONSTRAINT `compute_resource_policy_queues_ibfk_1` FOREIGN KEY
(`RESOURCE_POLICY_ID`) REFERENCES `COMPUTE_RESOURCE_POLICY`
(`RESOURCE_POLICY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMPUTE_RESOURCE_POLICY_QUEUES`
+--
+
+LOCK TABLES `COMPUTE_RESOURCE_POLICY_QUEUES` WRITE;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_POLICY_QUEUES` DISABLE KEYS */;
+INSERT INTO `COMPUTE_RESOURCE_POLICY_QUEUES` VALUES
('ae1b950e-b714-4d59-949b-338c6d6cf640','cloud');
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_POLICY_QUEUES` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `COMPUTE_RESOURCE_PREFERENCE`
+--
+
+DROP TABLE IF EXISTS `COMPUTE_RESOURCE_PREFERENCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMPUTE_RESOURCE_PREFERENCE` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `OVERRIDE_BY_AIRAVATA` smallint(6) DEFAULT NULL,
+ `PREFERED_JOB_SUB_PROTOCOL` varchar(255) DEFAULT NULL,
+ `PREFERED_DATA_MOVE_PROTOCOL` varchar(255) DEFAULT NULL,
+ `PREFERED_BATCH_QUEUE` varchar(255) DEFAULT NULL,
+ `SCRATCH_LOCATION` varchar(255) DEFAULT NULL,
+ `ALLOCATION_PROJECT_NUMBER` varchar(255) DEFAULT NULL,
+ `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
+ `RESOURCE_CS_TOKEN` varchar(255) DEFAULT NULL,
+ `USAGE_REPORTING_GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `QUALITY_OF_SERVICE` varchar(255) DEFAULT NULL,
+ `RESERVATION` varchar(255) DEFAULT NULL,
+ `RESERVATION_START_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
+ `RESERVATION_END_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `SSH_ACCOUNT_PROVISIONER` varchar(255) DEFAULT NULL,
+ `SSH_ACCOUNT_PROVISIONER_ADDITIONAL_INFO` varchar(1000) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`RESOURCE_ID`),
+ KEY `RESOURCE_ID` (`RESOURCE_ID`),
+ CONSTRAINT `compute_resource_preference_ibfk_1` FOREIGN KEY (`RESOURCE_ID`)
REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE,
+ CONSTRAINT `compute_resource_preference_ibfk_2` FOREIGN KEY (`GATEWAY_ID`)
REFERENCES `GATEWAY_PROFILE` (`GATEWAY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMPUTE_RESOURCE_PREFERENCE`
+--
+
+LOCK TABLES `COMPUTE_RESOURCE_PREFERENCE` WRITE;
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_PREFERENCE` DISABLE KEYS */;
+INSERT INTO `COMPUTE_RESOURCE_PREFERENCE` VALUES
('default','js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61',1,'SSH','SCP','cloud','/home/grid_user/airavata-workdirs','','grid_user','46a99a5a-8b55-4982-bfd7-90fe72b00d46',NULL,'','','2010-12-31
19:00:00','2030-12-31 19:00:00',NULL,NULL);
+/*!40000 ALTER TABLE `COMPUTE_RESOURCE_PREFERENCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) NOT NULL,
+ `CONFIG_VAL` varchar(255) NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VAL`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('app_catalog_version','0.16');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DATA_MOVEMENT_INTERFACE`
+--
+
+DROP TABLE IF EXISTS `DATA_MOVEMENT_INTERFACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATA_MOVEMENT_INTERFACE` (
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `DATA_MOVEMENT_PROTOCOL` varchar(255) NOT NULL,
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ `PRIORITY_ORDER` int(11) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`COMPUTE_RESOURCE_ID`,`DATA_MOVEMENT_INTERFACE_ID`),
+ CONSTRAINT `data_movement_interface_ibfk_1` FOREIGN KEY
(`COMPUTE_RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE
CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DATA_MOVEMENT_INTERFACE`
+--
+
+LOCK TABLES `DATA_MOVEMENT_INTERFACE` WRITE;
+/*!40000 ALTER TABLE `DATA_MOVEMENT_INTERFACE` DISABLE KEYS */;
+INSERT INTO `DATA_MOVEMENT_INTERFACE` VALUES
('js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','SCP','SCP_1e775974-c405-4793-9e6c-a88d98013a28',0,'2019-02-25
23:53:15','2019-02-25 23:53:15');
+/*!40000 ALTER TABLE `DATA_MOVEMENT_INTERFACE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GATEWAY_GROUPS`
+--
+
+DROP TABLE IF EXISTS `GATEWAY_GROUPS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GATEWAY_GROUPS` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `ADMINS_GROUP_ID` varchar(255) DEFAULT NULL,
+ `READ_ONLY_ADMINS_GROUP_ID` varchar(255) DEFAULT NULL,
+ `DEFAULT_GATEWAY_USERS_GROUP_ID` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GATEWAY_GROUPS`
+--
+
+LOCK TABLES `GATEWAY_GROUPS` WRITE;
+/*!40000 ALTER TABLE `GATEWAY_GROUPS` DISABLE KEYS */;
+INSERT INTO `GATEWAY_GROUPS` VALUES
('default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','Gateway_Users_2e4e6eb4-05ad-4a0f-92d1-02aa26c56004');
+/*!40000 ALTER TABLE `GATEWAY_GROUPS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GATEWAY_PROFILE`
+--
+
+DROP TABLE IF EXISTS `GATEWAY_PROFILE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GATEWAY_PROFILE` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `CS_TOKEN` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_TENANT` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_PWD_CRED_TOKEN` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GATEWAY_PROFILE`
+--
+
+LOCK TABLES `GATEWAY_PROFILE` WRITE;
+/*!40000 ALTER TABLE `GATEWAY_PROFILE` DISABLE KEYS */;
+INSERT INTO `GATEWAY_PROFILE` VALUES ('default','2019-02-26
15:15:34','2019-02-26
10:15:34',NULL,'default','daf89639-bf92-4161-9c54-34571372d092');
+/*!40000 ALTER TABLE `GATEWAY_PROFILE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GLOBUS_GK_ENDPOINT`
+--
+
+DROP TABLE IF EXISTS `GLOBUS_GK_ENDPOINT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GLOBUS_GK_ENDPOINT` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `ENDPOINT` varchar(255) NOT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`,`ENDPOINT`),
+ CONSTRAINT `globus_gk_endpoint_ibfk_1` FOREIGN KEY (`SUBMISSION_ID`)
REFERENCES `GLOBUS_SUBMISSION` (`SUBMISSION_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GLOBUS_GK_ENDPOINT`
+--
+
+LOCK TABLES `GLOBUS_GK_ENDPOINT` WRITE;
+/*!40000 ALTER TABLE `GLOBUS_GK_ENDPOINT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GLOBUS_GK_ENDPOINT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GLOBUS_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `GLOBUS_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GLOBUS_SUBMISSION` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `RESOURCE_JOB_MANAGER` varchar(255) DEFAULT NULL,
+ `SECURITY_PROTOCAL` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GLOBUS_SUBMISSION`
+--
+
+LOCK TABLES `GLOBUS_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `GLOBUS_SUBMISSION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GLOBUS_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GRIDFTP_DATA_MOVEMENT`
+--
+
+DROP TABLE IF EXISTS `GRIDFTP_DATA_MOVEMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GRIDFTP_DATA_MOVEMENT` (
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ `SECURITY_PROTOCOL` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`DATA_MOVEMENT_INTERFACE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GRIDFTP_DATA_MOVEMENT`
+--
+
+LOCK TABLES `GRIDFTP_DATA_MOVEMENT` WRITE;
+/*!40000 ALTER TABLE `GRIDFTP_DATA_MOVEMENT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GRIDFTP_DATA_MOVEMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GRIDFTP_ENDPOINT`
+--
+
+DROP TABLE IF EXISTS `GRIDFTP_ENDPOINT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GRIDFTP_ENDPOINT` (
+ `ENDPOINT` varchar(255) NOT NULL,
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`DATA_MOVEMENT_INTERFACE_ID`,`ENDPOINT`),
+ CONSTRAINT `gridftp_endpoint_ibfk_1` FOREIGN KEY
(`DATA_MOVEMENT_INTERFACE_ID`) REFERENCES `GRIDFTP_DATA_MOVEMENT`
(`DATA_MOVEMENT_INTERFACE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GRIDFTP_ENDPOINT`
+--
+
+LOCK TABLES `GRIDFTP_ENDPOINT` WRITE;
+/*!40000 ALTER TABLE `GRIDFTP_ENDPOINT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GRIDFTP_ENDPOINT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GROUP_COMPUTE_RESOURCE_PREFERENCE`
+--
+
+DROP TABLE IF EXISTS `GROUP_COMPUTE_RESOURCE_PREFERENCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GROUP_COMPUTE_RESOURCE_PREFERENCE` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) NOT NULL,
+ `OVERRIDE_BY_AIRAVATA` smallint(6) DEFAULT NULL,
+ `PREFERED_JOB_SUB_PROTOCOL` varchar(255) DEFAULT NULL,
+ `PREFERED_DATA_MOVE_PROTOCOL` varchar(255) DEFAULT NULL,
+ `PREFERED_BATCH_QUEUE` varchar(255) DEFAULT NULL,
+ `SCRATCH_LOCATION` varchar(255) DEFAULT NULL,
+ `ALLOCATION_PROJECT_NUMBER` varchar(255) DEFAULT NULL,
+ `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
+ `RESOURCE_CS_TOKEN` varchar(255) DEFAULT NULL,
+ `USAGE_REPORTING_GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `QUALITY_OF_SERVICE` varchar(255) DEFAULT NULL,
+ `RESERVATION` varchar(255) DEFAULT NULL,
+ `RESERVATION_START_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
+ `RESERVATION_END_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `SSH_ACCOUNT_PROVISIONER` varchar(255) DEFAULT NULL,
+ `SSH_ACCOUNT_PROVISIONER_ADDITIONAL_INFO` varchar(1000) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_ID`,`GROUP_RESOURCE_PROFILE_ID`),
+ KEY `GROUP_RESOURCE_PROFILE_ID` (`GROUP_RESOURCE_PROFILE_ID`),
+ CONSTRAINT `group_compute_resource_preference_ibfk_1` FOREIGN KEY
(`RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE,
+ CONSTRAINT `group_compute_resource_preference_ibfk_2` FOREIGN KEY
(`GROUP_RESOURCE_PROFILE_ID`) REFERENCES `GROUP_RESOURCE_PROFILE`
(`GROUP_RESOURCE_PROFILE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GROUP_COMPUTE_RESOURCE_PREFERENCE`
+--
+
+LOCK TABLES `GROUP_COMPUTE_RESOURCE_PREFERENCE` WRITE;
+/*!40000 ALTER TABLE `GROUP_COMPUTE_RESOURCE_PREFERENCE` DISABLE KEYS */;
+INSERT INTO `GROUP_COMPUTE_RESOURCE_PREFERENCE` VALUES
('js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','af03c63d-a40e-4ed1-aee0-759a6ed0202c',1,NULL,NULL,NULL,'/home/grid_user/airavata-workdirs',NULL,'grid_user',NULL,NULL,NULL,NULL,'2019-03-11
15:41:14','2019-03-11 15:41:14',NULL,NULL);
+/*!40000 ALTER TABLE `GROUP_COMPUTE_RESOURCE_PREFERENCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GROUP_RESOURCE_PROFILE`
+--
+
+DROP TABLE IF EXISTS `GROUP_RESOURCE_PROFILE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GROUP_RESOURCE_PROFILE` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_NAME` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` bigint(20) NOT NULL,
+ `UPDATE_TIME` bigint(20) NOT NULL,
+ `DEFAULT_CREDENTIAL_STORE_TOKEN` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GROUP_RESOURCE_PROFILE_ID`),
+ UNIQUE KEY `GATEWAY_ID` (`GATEWAY_ID`,`GROUP_RESOURCE_PROFILE_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GROUP_RESOURCE_PROFILE`
+--
+
+LOCK TABLES `GROUP_RESOURCE_PROFILE` WRITE;
+/*!40000 ALTER TABLE `GROUP_RESOURCE_PROFILE` DISABLE KEYS */;
+INSERT INTO `GROUP_RESOURCE_PROFILE` VALUES
('default','af03c63d-a40e-4ed1-aee0-759a6ed0202c','Default-Group-Resource-Profile',1552318871758,1552318871760,'46a99a5a-8b55-4982-bfd7-90fe72b00d46');
+/*!40000 ALTER TABLE `GROUP_RESOURCE_PROFILE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GRP_SSH_ACC_PROV_CONFIG`
+--
+
+DROP TABLE IF EXISTS `GRP_SSH_ACC_PROV_CONFIG`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GRP_SSH_ACC_PROV_CONFIG` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) NOT NULL,
+ `CONFIG_NAME` varchar(255) NOT NULL,
+ `CONFIG_VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_ID`,`CONFIG_NAME`,`GROUP_RESOURCE_PROFILE_ID`),
+ KEY `RESOURCE_ID` (`RESOURCE_ID`,`GROUP_RESOURCE_PROFILE_ID`),
+ CONSTRAINT `grp_ssh_acc_prov_config_ibfk_1` FOREIGN KEY (`RESOURCE_ID`,
`GROUP_RESOURCE_PROFILE_ID`) REFERENCES `GROUP_COMPUTE_RESOURCE_PREFERENCE`
(`RESOURCE_ID`, `GROUP_RESOURCE_PROFILE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GRP_SSH_ACC_PROV_CONFIG`
+--
+
+LOCK TABLES `GRP_SSH_ACC_PROV_CONFIG` WRITE;
+/*!40000 ALTER TABLE `GRP_SSH_ACC_PROV_CONFIG` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GRP_SSH_ACC_PROV_CONFIG` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GSISSH_EXPORT`
+--
+
+DROP TABLE IF EXISTS `GSISSH_EXPORT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GSISSH_EXPORT` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `EXPORT` varchar(255) NOT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`,`EXPORT`),
+ CONSTRAINT `gsissh_export_ibfk_1` FOREIGN KEY (`SUBMISSION_ID`) REFERENCES
`GSISSH_SUBMISSION` (`SUBMISSION_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GSISSH_EXPORT`
+--
+
+LOCK TABLES `GSISSH_EXPORT` WRITE;
+/*!40000 ALTER TABLE `GSISSH_EXPORT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GSISSH_EXPORT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GSISSH_POSTJOBCOMMAND`
+--
+
+DROP TABLE IF EXISTS `GSISSH_POSTJOBCOMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GSISSH_POSTJOBCOMMAND` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) NOT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`,`COMMAND`),
+ CONSTRAINT `gsissh_postjobcommand_ibfk_1` FOREIGN KEY (`SUBMISSION_ID`)
REFERENCES `GSISSH_SUBMISSION` (`SUBMISSION_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GSISSH_POSTJOBCOMMAND`
+--
+
+LOCK TABLES `GSISSH_POSTJOBCOMMAND` WRITE;
+/*!40000 ALTER TABLE `GSISSH_POSTJOBCOMMAND` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GSISSH_POSTJOBCOMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GSISSH_PREJOBCOMMAND`
+--
+
+DROP TABLE IF EXISTS `GSISSH_PREJOBCOMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GSISSH_PREJOBCOMMAND` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) NOT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`,`COMMAND`),
+ CONSTRAINT `gsissh_prejobcommand_ibfk_1` FOREIGN KEY (`SUBMISSION_ID`)
REFERENCES `GSISSH_SUBMISSION` (`SUBMISSION_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GSISSH_PREJOBCOMMAND`
+--
+
+LOCK TABLES `GSISSH_PREJOBCOMMAND` WRITE;
+/*!40000 ALTER TABLE `GSISSH_PREJOBCOMMAND` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GSISSH_PREJOBCOMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GSISSH_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `GSISSH_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GSISSH_SUBMISSION` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `RESOURCE_JOB_MANAGER` varchar(255) DEFAULT NULL,
+ `SSH_PORT` int(11) DEFAULT NULL,
+ `INSTALLED_PATH` varchar(255) DEFAULT NULL,
+ `MONITOR_MODE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GSISSH_SUBMISSION`
+--
+
+LOCK TABLES `GSISSH_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `GSISSH_SUBMISSION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GSISSH_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `HOST_ALIAS`
+--
+
+DROP TABLE IF EXISTS `HOST_ALIAS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `HOST_ALIAS` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `ALIAS` varchar(255) NOT NULL,
+ PRIMARY KEY (`RESOURCE_ID`,`ALIAS`),
+ CONSTRAINT `host_alias_ibfk_1` FOREIGN KEY (`RESOURCE_ID`) REFERENCES
`COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `HOST_ALIAS`
+--
+
+LOCK TABLES `HOST_ALIAS` WRITE;
+/*!40000 ALTER TABLE `HOST_ALIAS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `HOST_ALIAS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `HOST_IPADDRESS`
+--
+
+DROP TABLE IF EXISTS `HOST_IPADDRESS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `HOST_IPADDRESS` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `IP_ADDRESS` varchar(255) NOT NULL,
+ PRIMARY KEY (`RESOURCE_ID`,`IP_ADDRESS`),
+ CONSTRAINT `host_ipaddress_ibfk_1` FOREIGN KEY (`RESOURCE_ID`) REFERENCES
`COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `HOST_IPADDRESS`
+--
+
+LOCK TABLES `HOST_IPADDRESS` WRITE;
+/*!40000 ALTER TABLE `HOST_IPADDRESS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `HOST_IPADDRESS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `JOB_MANAGER_COMMAND`
+--
+
+DROP TABLE IF EXISTS `JOB_MANAGER_COMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `JOB_MANAGER_COMMAND` (
+ `RESOURCE_JOB_MANAGER_ID` varchar(255) NOT NULL,
+ `COMMAND_TYPE` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_JOB_MANAGER_ID`,`COMMAND_TYPE`),
+ CONSTRAINT `job_manager_command_ibfk_1` FOREIGN KEY
(`RESOURCE_JOB_MANAGER_ID`) REFERENCES `RESOURCE_JOB_MANAGER`
(`RESOURCE_JOB_MANAGER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `JOB_MANAGER_COMMAND`
+--
+
+LOCK TABLES `JOB_MANAGER_COMMAND` WRITE;
+/*!40000 ALTER TABLE `JOB_MANAGER_COMMAND` DISABLE KEYS */;
+INSERT INTO `JOB_MANAGER_COMMAND` VALUES
('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','CHECK_JOB','squeue'),('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','DELETION','scancel'),('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','JOB_MONITORING','squeue
-t all'),('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','SUBMISSION','sbatch');
+/*!40000 ALTER TABLE `JOB_MANAGER_COMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `JOB_SUBMISSION_INTERFACE`
+--
+
+DROP TABLE IF EXISTS `JOB_SUBMISSION_INTERFACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `JOB_SUBMISSION_INTERFACE` (
+ `JOB_SUBMISSION_INTERFACE_ID` varchar(255) NOT NULL,
+ `COMPUTE_RESOURCE_ID` varchar(255) NOT NULL,
+ `JOB_SUBMISSION_PROTOCOL` varchar(255) NOT NULL,
+ `PRIORITY_ORDER` int(11) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`COMPUTE_RESOURCE_ID`,`JOB_SUBMISSION_INTERFACE_ID`),
+ CONSTRAINT `job_submission_interface_ibfk_1` FOREIGN KEY
(`COMPUTE_RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE` (`RESOURCE_ID`) ON DELETE
CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `JOB_SUBMISSION_INTERFACE`
+--
+
+LOCK TABLES `JOB_SUBMISSION_INTERFACE` WRITE;
+/*!40000 ALTER TABLE `JOB_SUBMISSION_INTERFACE` DISABLE KEYS */;
+INSERT INTO `JOB_SUBMISSION_INTERFACE` VALUES
('SSH_8cdb13a9-130b-4527-96fe-dcd0c5ffd185','js-156-93.jetstream-cloud.org_f0813875-de5b-4abb-b56f-eb9237809c61','SSH',0,'2019-02-25
23:52:55','2019-02-25 23:52:55');
+/*!40000 ALTER TABLE `JOB_SUBMISSION_INTERFACE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `LIBRARY_APEND_PATH`
+--
+
+DROP TABLE IF EXISTS `LIBRARY_APEND_PATH`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `LIBRARY_APEND_PATH` (
+ `DEPLOYMENT_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`DEPLOYMENT_ID`,`NAME`),
+ CONSTRAINT `library_apend_path_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID`)
REFERENCES `APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `LIBRARY_APEND_PATH`
+--
+
+LOCK TABLES `LIBRARY_APEND_PATH` WRITE;
+/*!40000 ALTER TABLE `LIBRARY_APEND_PATH` DISABLE KEYS */;
+/*!40000 ALTER TABLE `LIBRARY_APEND_PATH` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `LIBRARY_PREPAND_PATH`
+--
+
+DROP TABLE IF EXISTS `LIBRARY_PREPAND_PATH`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `LIBRARY_PREPAND_PATH` (
+ `DEPLOYMENT_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`DEPLOYMENT_ID`,`NAME`),
+ CONSTRAINT `library_prepand_path_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID`)
REFERENCES `APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `LIBRARY_PREPAND_PATH`
+--
+
+LOCK TABLES `LIBRARY_PREPAND_PATH` WRITE;
+/*!40000 ALTER TABLE `LIBRARY_PREPAND_PATH` DISABLE KEYS */;
+/*!40000 ALTER TABLE `LIBRARY_PREPAND_PATH` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `LOCAL_DATA_MOVEMENT`
+--
+
+DROP TABLE IF EXISTS `LOCAL_DATA_MOVEMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `LOCAL_DATA_MOVEMENT` (
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`DATA_MOVEMENT_INTERFACE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `LOCAL_DATA_MOVEMENT`
+--
+
+LOCK TABLES `LOCAL_DATA_MOVEMENT` WRITE;
+/*!40000 ALTER TABLE `LOCAL_DATA_MOVEMENT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `LOCAL_DATA_MOVEMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `LOCAL_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `LOCAL_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `LOCAL_SUBMISSION` (
+ `RESOURCE_JOB_MANAGER_ID` varchar(255) NOT NULL,
+ `JOB_SUBMISSION_INTERFACE_ID` varchar(255) NOT NULL,
+ `SECURITY_PROTOCOL` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`JOB_SUBMISSION_INTERFACE_ID`),
+ KEY `RESOURCE_JOB_MANAGER_ID` (`RESOURCE_JOB_MANAGER_ID`),
+ CONSTRAINT `local_submission_ibfk_1` FOREIGN KEY (`RESOURCE_JOB_MANAGER_ID`)
REFERENCES `RESOURCE_JOB_MANAGER` (`RESOURCE_JOB_MANAGER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `LOCAL_SUBMISSION`
+--
+
+LOCK TABLES `LOCAL_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `LOCAL_SUBMISSION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `LOCAL_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `MODULE_LOAD_CMD`
+--
+
+DROP TABLE IF EXISTS `MODULE_LOAD_CMD`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `MODULE_LOAD_CMD` (
+ `CMD` varchar(255) NOT NULL,
+ `APP_DEPLOYMENT_ID` varchar(255) NOT NULL,
+ `COMMAND_ORDER` int(11) DEFAULT NULL,
+ PRIMARY KEY (`APP_DEPLOYMENT_ID`,`CMD`),
+ CONSTRAINT `module_load_cmd_ibfk_1` FOREIGN KEY (`APP_DEPLOYMENT_ID`)
REFERENCES `APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `MODULE_LOAD_CMD`
+--
+
+LOCK TABLES `MODULE_LOAD_CMD` WRITE;
+/*!40000 ALTER TABLE `MODULE_LOAD_CMD` DISABLE KEYS */;
+/*!40000 ALTER TABLE `MODULE_LOAD_CMD` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARALLELISM_COMMAND`
+--
+
+DROP TABLE IF EXISTS `PARALLELISM_COMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARALLELISM_COMMAND` (
+ `RESOURCE_JOB_MANAGER_ID` varchar(255) NOT NULL,
+ `COMMAND_TYPE` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`RESOURCE_JOB_MANAGER_ID`,`COMMAND_TYPE`),
+ CONSTRAINT `parallelism_command_ibfk_1` FOREIGN KEY
(`RESOURCE_JOB_MANAGER_ID`) REFERENCES `RESOURCE_JOB_MANAGER`
(`RESOURCE_JOB_MANAGER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARALLELISM_COMMAND`
+--
+
+LOCK TABLES `PARALLELISM_COMMAND` WRITE;
+/*!40000 ALTER TABLE `PARALLELISM_COMMAND` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARALLELISM_COMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSER`
+--
+
+DROP TABLE IF EXISTS `PARSER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSER` (
+ `PARSER_ID` varchar(255) NOT NULL,
+ `IMAGE_NAME` varchar(255) NOT NULL,
+ `OUTPUT_DIR_PATH` varchar(255) NOT NULL,
+ `INPUT_DIR_PATH` varchar(255) NOT NULL,
+ `EXECUTION_COMMAND` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSER`
+--
+
+LOCK TABLES `PARSER` WRITE;
+/*!40000 ALTER TABLE `PARSER` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSER_CONNECTOR`
+--
+
+DROP TABLE IF EXISTS `PARSER_CONNECTOR`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSER_CONNECTOR` (
+ `PARSER_CONNECTOR_ID` varchar(255) NOT NULL,
+ `PARENT_PARSER_ID` varchar(255) NOT NULL,
+ `CHILD_PARSER_ID` varchar(255) NOT NULL,
+ `PARSING_TEMPLATE_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSER_CONNECTOR_ID`),
+ KEY `PARENT_PARSER_ID` (`PARENT_PARSER_ID`),
+ KEY `CHILD_PARSER_ID` (`CHILD_PARSER_ID`),
+ KEY `PARSING_TEMPLATE_ID` (`PARSING_TEMPLATE_ID`),
+ CONSTRAINT `parser_connector_ibfk_1` FOREIGN KEY (`PARENT_PARSER_ID`)
REFERENCES `PARSER` (`PARSER_ID`) ON DELETE CASCADE,
+ CONSTRAINT `parser_connector_ibfk_2` FOREIGN KEY (`CHILD_PARSER_ID`)
REFERENCES `PARSER` (`PARSER_ID`) ON DELETE CASCADE,
+ CONSTRAINT `parser_connector_ibfk_3` FOREIGN KEY (`PARSING_TEMPLATE_ID`)
REFERENCES `PARSING_TEMPLATE` (`PARSING_TEMPLATE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSER_CONNECTOR`
+--
+
+LOCK TABLES `PARSER_CONNECTOR` WRITE;
+/*!40000 ALTER TABLE `PARSER_CONNECTOR` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSER_CONNECTOR` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSER_CONNECTOR_INPUT`
+--
+
+DROP TABLE IF EXISTS `PARSER_CONNECTOR_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSER_CONNECTOR_INPUT` (
+ `PARSER_CONNECTOR_INPUT_ID` varchar(255) NOT NULL,
+ `PARSER_INPUT_ID` varchar(255) NOT NULL,
+ `PARSER_OUTPUT_ID` varchar(255) DEFAULT NULL,
+ `VALUE` varchar(255) DEFAULT NULL,
+ `PARSER_CONNECTOR_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSER_CONNECTOR_INPUT_ID`),
+ KEY `PARSER_INPUT_ID` (`PARSER_INPUT_ID`),
+ KEY `PARSER_OUTPUT_ID` (`PARSER_OUTPUT_ID`),
+ KEY `PARSER_CONNECTOR_ID` (`PARSER_CONNECTOR_ID`),
+ CONSTRAINT `parser_connector_input_ibfk_1` FOREIGN KEY (`PARSER_INPUT_ID`)
REFERENCES `PARSER_INPUT` (`PARSER_INPUT_ID`) ON DELETE CASCADE,
+ CONSTRAINT `parser_connector_input_ibfk_2` FOREIGN KEY (`PARSER_OUTPUT_ID`)
REFERENCES `PARSER_OUTPUT` (`PARSER_OUTPUT_ID`) ON DELETE CASCADE,
+ CONSTRAINT `parser_connector_input_ibfk_3` FOREIGN KEY
(`PARSER_CONNECTOR_ID`) REFERENCES `PARSER_CONNECTOR` (`PARSER_CONNECTOR_ID`)
ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSER_CONNECTOR_INPUT`
+--
+
+LOCK TABLES `PARSER_CONNECTOR_INPUT` WRITE;
+/*!40000 ALTER TABLE `PARSER_CONNECTOR_INPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSER_CONNECTOR_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSER_INPUT`
+--
+
+DROP TABLE IF EXISTS `PARSER_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSER_INPUT` (
+ `PARSER_INPUT_ID` varchar(255) NOT NULL,
+ `PARSER_INPUT_NAME` varchar(255) NOT NULL,
+ `PARSER_INPUT_REQUIRED` tinyint(1) NOT NULL,
+ `PARSER_ID` varchar(255) NOT NULL,
+ `INPUT_TYPE` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSER_INPUT_ID`),
+ KEY `PARSER_ID` (`PARSER_ID`),
+ CONSTRAINT `parser_input_ibfk_1` FOREIGN KEY (`PARSER_ID`) REFERENCES
`PARSER` (`PARSER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSER_INPUT`
+--
+
+LOCK TABLES `PARSER_INPUT` WRITE;
+/*!40000 ALTER TABLE `PARSER_INPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSER_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSER_OUTPUT`
+--
+
+DROP TABLE IF EXISTS `PARSER_OUTPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSER_OUTPUT` (
+ `PARSER_OUTPUT_ID` varchar(255) NOT NULL,
+ `PARSER_OUTPUT_NAME` varchar(255) NOT NULL,
+ `PARSER_OUTPUT_REQUIRED` tinyint(1) NOT NULL,
+ `PARSER_ID` varchar(255) NOT NULL,
+ `OUTPUT_TYPE` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSER_OUTPUT_ID`),
+ KEY `PARSER_ID` (`PARSER_ID`),
+ CONSTRAINT `parser_output_ibfk_1` FOREIGN KEY (`PARSER_ID`) REFERENCES
`PARSER` (`PARSER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSER_OUTPUT`
+--
+
+LOCK TABLES `PARSER_OUTPUT` WRITE;
+/*!40000 ALTER TABLE `PARSER_OUTPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSER_OUTPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSING_TEMPLATE`
+--
+
+DROP TABLE IF EXISTS `PARSING_TEMPLATE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSING_TEMPLATE` (
+ `PARSING_TEMPLATE_ID` varchar(255) NOT NULL,
+ `APP_INTERFACE_ID` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSING_TEMPLATE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSING_TEMPLATE`
+--
+
+LOCK TABLES `PARSING_TEMPLATE` WRITE;
+/*!40000 ALTER TABLE `PARSING_TEMPLATE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSING_TEMPLATE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PARSING_TEMPLATE_INPUT`
+--
+
+DROP TABLE IF EXISTS `PARSING_TEMPLATE_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PARSING_TEMPLATE_INPUT` (
+ `PARSING_TEMPLATE_INPUT_ID` varchar(255) NOT NULL,
+ `TARGET_PARSER_INPUT_ID` varchar(255) NOT NULL,
+ `APPLICATION_OUTPUT_NAME` varchar(255) DEFAULT NULL,
+ `VALUE` varchar(255) DEFAULT NULL,
+ `PARSING_TEMPLATE_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`PARSING_TEMPLATE_INPUT_ID`),
+ KEY `TARGET_PARSER_INPUT_ID` (`TARGET_PARSER_INPUT_ID`),
+ KEY `PARSING_TEMPLATE_ID` (`PARSING_TEMPLATE_ID`),
+ CONSTRAINT `parsing_template_input_ibfk_1` FOREIGN KEY
(`TARGET_PARSER_INPUT_ID`) REFERENCES `PARSER_INPUT` (`PARSER_INPUT_ID`) ON
DELETE CASCADE,
+ CONSTRAINT `parsing_template_input_ibfk_2` FOREIGN KEY
(`PARSING_TEMPLATE_ID`) REFERENCES `PARSING_TEMPLATE` (`PARSING_TEMPLATE_ID`)
ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PARSING_TEMPLATE_INPUT`
+--
+
+LOCK TABLES `PARSING_TEMPLATE_INPUT` WRITE;
+/*!40000 ALTER TABLE `PARSING_TEMPLATE_INPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PARSING_TEMPLATE_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `POSTJOB_COMMAND`
+--
+
+DROP TABLE IF EXISTS `POSTJOB_COMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `POSTJOB_COMMAND` (
+ `APPDEPLOYMENT_ID` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) NOT NULL,
+ `COMMAND_ORDER` int(11) DEFAULT NULL,
+ PRIMARY KEY (`APPDEPLOYMENT_ID`,`COMMAND`),
+ CONSTRAINT `postjob_command_ibfk_1` FOREIGN KEY (`APPDEPLOYMENT_ID`)
REFERENCES `APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `POSTJOB_COMMAND`
+--
+
+LOCK TABLES `POSTJOB_COMMAND` WRITE;
+/*!40000 ALTER TABLE `POSTJOB_COMMAND` DISABLE KEYS */;
+/*!40000 ALTER TABLE `POSTJOB_COMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PREJOB_COMMAND`
+--
+
+DROP TABLE IF EXISTS `PREJOB_COMMAND`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PREJOB_COMMAND` (
+ `APPDEPLOYMENT_ID` varchar(255) NOT NULL,
+ `COMMAND` varchar(255) NOT NULL,
+ `COMMAND_ORDER` int(11) DEFAULT NULL,
+ PRIMARY KEY (`APPDEPLOYMENT_ID`,`COMMAND`),
+ CONSTRAINT `prejob_command_ibfk_1` FOREIGN KEY (`APPDEPLOYMENT_ID`)
REFERENCES `APPLICATION_DEPLOYMENT` (`DEPLOYMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PREJOB_COMMAND`
+--
+
+LOCK TABLES `PREJOB_COMMAND` WRITE;
+/*!40000 ALTER TABLE `PREJOB_COMMAND` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PREJOB_COMMAND` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `RESOURCE_JOB_MANAGER`
+--
+
+DROP TABLE IF EXISTS `RESOURCE_JOB_MANAGER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `RESOURCE_JOB_MANAGER` (
+ `RESOURCE_JOB_MANAGER_ID` varchar(255) NOT NULL,
+ `PUSH_MONITORING_ENDPOINT` varchar(255) DEFAULT NULL,
+ `JOB_MANAGER_BIN_PATH` varchar(255) DEFAULT NULL,
+ `RESOURCE_JOB_MANAGER_TYPE` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`RESOURCE_JOB_MANAGER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `RESOURCE_JOB_MANAGER`
+--
+
+LOCK TABLES `RESOURCE_JOB_MANAGER` WRITE;
+/*!40000 ALTER TABLE `RESOURCE_JOB_MANAGER` DISABLE KEYS */;
+INSERT INTO `RESOURCE_JOB_MANAGER` VALUES
('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','','/bin','SLURM','2019-02-25
23:52:55','2019-02-25 23:52:55');
+/*!40000 ALTER TABLE `RESOURCE_JOB_MANAGER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `SCP_DATA_MOVEMENT`
+--
+
+DROP TABLE IF EXISTS `SCP_DATA_MOVEMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SCP_DATA_MOVEMENT` (
+ `QUEUE_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ `SECURITY_PROTOCOL` varchar(255) NOT NULL,
+ `ALTERNATIVE_SCP_HOSTNAME` varchar(255) DEFAULT NULL,
+ `SSH_PORT` int(11) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`DATA_MOVEMENT_INTERFACE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `SCP_DATA_MOVEMENT`
+--
+
+LOCK TABLES `SCP_DATA_MOVEMENT` WRITE;
+/*!40000 ALTER TABLE `SCP_DATA_MOVEMENT` DISABLE KEYS */;
+INSERT INTO `SCP_DATA_MOVEMENT` VALUES
(NULL,'DO_NOT_SET_AT_CLIENTS','SSH_KEYS','',22222,'2019-02-26
15:12:00','2019-02-26
10:12:01'),(NULL,'SCP_1e775974-c405-4793-9e6c-a88d98013a28','SSH_KEYS','',0,'2019-02-25
23:53:15','2019-02-25
23:53:15'),(NULL,'SCP_e6fa0ccf-6dcd-4361-be09-1fd7df7f7a3c','SSH_KEYS','',0,'2019-02-26
00:27:42','2019-02-26 00:27:42');
+/*!40000 ALTER TABLE `SCP_DATA_MOVEMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `SSH_ACCOUNT_PROVISIONER_CONFIG`
+--
+
+DROP TABLE IF EXISTS `SSH_ACCOUNT_PROVISIONER_CONFIG`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SSH_ACCOUNT_PROVISIONER_CONFIG` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `CONFIG_NAME` varchar(255) NOT NULL,
+ `CONFIG_VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`RESOURCE_ID`,`CONFIG_NAME`),
+ CONSTRAINT `ssh_account_provisioner_config_ibfk_1` FOREIGN KEY
(`GATEWAY_ID`, `RESOURCE_ID`) REFERENCES `COMPUTE_RESOURCE_PREFERENCE`
(`GATEWAY_ID`, `RESOURCE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `SSH_ACCOUNT_PROVISIONER_CONFIG`
+--
+
+LOCK TABLES `SSH_ACCOUNT_PROVISIONER_CONFIG` WRITE;
+/*!40000 ALTER TABLE `SSH_ACCOUNT_PROVISIONER_CONFIG` DISABLE KEYS */;
+/*!40000 ALTER TABLE `SSH_ACCOUNT_PROVISIONER_CONFIG` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `SSH_JOB_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `SSH_JOB_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SSH_JOB_SUBMISSION` (
+ `RESOURCE_JOB_MANAGER_ID` varchar(255) NOT NULL,
+ `JOB_SUBMISSION_INTERFACE_ID` varchar(255) NOT NULL,
+ `ALTERNATIVE_SSH_HOSTNAME` varchar(255) DEFAULT NULL,
+ `SECURITY_PROTOCOL` varchar(255) NOT NULL,
+ `SSH_PORT` int(11) DEFAULT NULL,
+ `MONITOR_MODE` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`JOB_SUBMISSION_INTERFACE_ID`),
+ KEY `RESOURCE_JOB_MANAGER_ID` (`RESOURCE_JOB_MANAGER_ID`),
+ CONSTRAINT `ssh_job_submission_ibfk_1` FOREIGN KEY
(`RESOURCE_JOB_MANAGER_ID`) REFERENCES `RESOURCE_JOB_MANAGER`
(`RESOURCE_JOB_MANAGER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `SSH_JOB_SUBMISSION`
+--
+
+LOCK TABLES `SSH_JOB_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `SSH_JOB_SUBMISSION` DISABLE KEYS */;
+INSERT INTO `SSH_JOB_SUBMISSION` VALUES
('RJM_11132688-7ff1-48fb-802a-0203f8d8b14b','SSH_8cdb13a9-130b-4527-96fe-dcd0c5ffd185','','SSH_KEYS',0,'JOB_EMAIL_NOTIFICATION_MONITOR','2019-02-25
23:52:55','2019-02-25 23:52:55');
+/*!40000 ALTER TABLE `SSH_JOB_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `STORAGE_INTERFACE`
+--
+
+DROP TABLE IF EXISTS `STORAGE_INTERFACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `STORAGE_INTERFACE` (
+ `STORAGE_RESOURCE_ID` varchar(255) NOT NULL,
+ `DATA_MOVEMENT_INTERFACE_ID` varchar(255) NOT NULL,
+ `DATA_MOVEMENT_PROTOCOL` varchar(255) NOT NULL,
+ `PRIORITY_ORDER` int(11) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`STORAGE_RESOURCE_ID`,`DATA_MOVEMENT_INTERFACE_ID`),
+ CONSTRAINT `storage_interface_ibfk_1` FOREIGN KEY (`STORAGE_RESOURCE_ID`)
REFERENCES `STORAGE_RESOURCE` (`STORAGE_RESOURCE_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `STORAGE_INTERFACE`
+--
+
+LOCK TABLES `STORAGE_INTERFACE` WRITE;
+/*!40000 ALTER TABLE `STORAGE_INTERFACE` DISABLE KEYS */;
+INSERT INTO `STORAGE_INTERFACE` VALUES
('airavata.host_77116e91-f042-4d3a-ab9c-3e7b4ebcd5bd','SCP_e6fa0ccf-6dcd-4361-be09-1fd7df7f7a3c','SCP',0,'2019-02-26
00:27:42','2019-02-26 00:27:42');
+/*!40000 ALTER TABLE `STORAGE_INTERFACE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `STORAGE_PREFERENCE`
+--
+
+DROP TABLE IF EXISTS `STORAGE_PREFERENCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `STORAGE_PREFERENCE` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) NOT NULL,
+ `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
+ `FS_ROOT_LOCATION` varchar(255) DEFAULT NULL,
+ `RESOURCE_CS_TOKEN` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`STORAGE_RESOURCE_ID`),
+ CONSTRAINT `storage_preference_ibfk_1` FOREIGN KEY (`GATEWAY_ID`) REFERENCES
`GATEWAY_PROFILE` (`GATEWAY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `STORAGE_PREFERENCE`
+--
+
+LOCK TABLES `STORAGE_PREFERENCE` WRITE;
+/*!40000 ALTER TABLE `STORAGE_PREFERENCE` DISABLE KEYS */;
+INSERT INTO `STORAGE_PREFERENCE` VALUES
('default','airavata.host_77116e91-f042-4d3a-ab9c-3e7b4ebcd5bd','root','/var/www/portals/gateway-user-data','46a99a5a-8b55-4982-bfd7-90fe72b00d46');
+/*!40000 ALTER TABLE `STORAGE_PREFERENCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `STORAGE_RESOURCE`
+--
+
+DROP TABLE IF EXISTS `STORAGE_RESOURCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `STORAGE_RESOURCE` (
+ `STORAGE_RESOURCE_ID` varchar(255) NOT NULL,
+ `HOST_NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `ENABLED` smallint(6) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`STORAGE_RESOURCE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `STORAGE_RESOURCE`
+--
+
+LOCK TABLES `STORAGE_RESOURCE` WRITE;
+/*!40000 ALTER TABLE `STORAGE_RESOURCE` DISABLE KEYS */;
+INSERT INTO `STORAGE_RESOURCE` VALUES
('airavata.host_77116e91-f042-4d3a-ab9c-3e7b4ebcd5bd','airavata.host','',1,'2019-02-25
19:27:15','2019-02-26 10:11:53');
+/*!40000 ALTER TABLE `STORAGE_RESOURCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `UNICORE_DATAMOVEMENT`
+--
+
+DROP TABLE IF EXISTS `UNICORE_DATAMOVEMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UNICORE_DATAMOVEMENT` (
+ `DATAMOVEMENT_ID` varchar(255) NOT NULL,
+ `SECURITY_PROTOCAL` varchar(255) DEFAULT NULL,
+ `UNICORE_ENDPOINT_URL` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`DATAMOVEMENT_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `UNICORE_DATAMOVEMENT`
+--
+
+LOCK TABLES `UNICORE_DATAMOVEMENT` WRITE;
+/*!40000 ALTER TABLE `UNICORE_DATAMOVEMENT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `UNICORE_DATAMOVEMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `UNICORE_SUBMISSION`
+--
+
+DROP TABLE IF EXISTS `UNICORE_SUBMISSION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UNICORE_SUBMISSION` (
+ `SUBMISSION_ID` varchar(255) NOT NULL,
+ `SECURITY_PROTOCAL` varchar(255) DEFAULT NULL,
+ `UNICORE_ENDPOINT_URL` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`SUBMISSION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `UNICORE_SUBMISSION`
+--
+
+LOCK TABLES `UNICORE_SUBMISSION` WRITE;
+/*!40000 ALTER TABLE `UNICORE_SUBMISSION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `UNICORE_SUBMISSION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_COMPUTE_RESOURCE_PREFERENCE`
+--
+
+DROP TABLE IF EXISTS `USER_COMPUTE_RESOURCE_PREFERENCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_COMPUTE_RESOURCE_PREFERENCE` (
+ `RESOURCE_ID` varchar(255) NOT NULL,
+ `USER_ID` varchar(255) NOT NULL,
+ `PREFERED_BATCH_QUEUE` varchar(255) DEFAULT NULL,
+ `RESOURCE_CS_TOKEN` varchar(255) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
+ `ALLOCATION_PROJECT_NUMBER` varchar(255) DEFAULT NULL,
+ `QUALITY_OF_SERVICE` varchar(255) DEFAULT NULL,
+ `RESERVATION` varchar(255) DEFAULT NULL,
+ `RESERVATION_END_TIME` datetime DEFAULT NULL,
+ `RESERVATION_START_TIME` datetime DEFAULT NULL,
+ `SCRATCH_LOCATION` varchar(255) DEFAULT NULL,
+ `VALIDATED` tinyint(1) DEFAULT '0',
+ PRIMARY KEY (`RESOURCE_ID`,`USER_ID`,`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_COMPUTE_RESOURCE_PREFERENCE`
+--
+
+LOCK TABLES `USER_COMPUTE_RESOURCE_PREFERENCE` WRITE;
+/*!40000 ALTER TABLE `USER_COMPUTE_RESOURCE_PREFERENCE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_COMPUTE_RESOURCE_PREFERENCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_RESOURCE_PROFILE`
+--
+
+DROP TABLE IF EXISTS `USER_RESOURCE_PROFILE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_RESOURCE_PROFILE` (
+ `USER_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` datetime DEFAULT NULL,
+ `CS_TOKEN` varchar(255) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `IDENTITY_SERVER_PWD_CRED_TOKEN` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_TENANT` varchar(255) DEFAULT NULL,
+ `UPDATE_TIME` datetime DEFAULT NULL,
+ PRIMARY KEY (`USER_ID`,`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_RESOURCE_PROFILE`
+--
+
+LOCK TABLES `USER_RESOURCE_PROFILE` WRITE;
+/*!40000 ALTER TABLE `USER_RESOURCE_PROFILE` DISABLE KEYS */;
+INSERT INTO `USER_RESOURCE_PROFILE` VALUES
('default-admin',NULL,NULL,'default',NULL,NULL,'2019-03-11 14:16:13');
+/*!40000 ALTER TABLE `USER_RESOURCE_PROFILE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_STORAGE_PREFERENCE`
+--
+
+DROP TABLE IF EXISTS `USER_STORAGE_PREFERENCE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_STORAGE_PREFERENCE` (
+ `STORAGE_RESOURCE_ID` varchar(255) NOT NULL,
+ `USER_ID` varchar(255) NOT NULL,
+ `RESOURCE_CS_TOKEN` varchar(255) DEFAULT NULL,
+ `FS_ROOT_LOCATION` varchar(255) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `LOGIN_USERNAME` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`STORAGE_RESOURCE_ID`,`USER_ID`,`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_STORAGE_PREFERENCE`
+--
+
+LOCK TABLES `USER_STORAGE_PREFERENCE` WRITE;
+/*!40000 ALTER TABLE `USER_STORAGE_PREFERENCE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_STORAGE_PREFERENCE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `credential_store`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `credential_store` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `credential_store`;
+
+--
+-- Table structure for table `COMMUNITY_USER`
+--
+
+DROP TABLE IF EXISTS `COMMUNITY_USER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `COMMUNITY_USER` (
+ `GATEWAY_ID` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `COMMUNITY_USER_NAME` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `TOKEN_ID` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `COMMUNITY_USER_EMAIL` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`COMMUNITY_USER_NAME`,`TOKEN_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `COMMUNITY_USER`
+--
+
+LOCK TABLES `COMMUNITY_USER` WRITE;
+/*!40000 ALTER TABLE `COMMUNITY_USER` DISABLE KEYS */;
+/*!40000 ALTER TABLE `COMMUNITY_USER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `CONFIG_VAL` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VAL`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('credential_store_version','0.16');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `CREDENTIALS`
+--
+
+DROP TABLE IF EXISTS `CREDENTIALS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CREDENTIALS` (
+ `GATEWAY_ID` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `TOKEN_ID` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `CREDENTIAL` blob NOT NULL,
+ `PORTAL_USER_ID` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `TIME_PERSISTED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `DESCRIPTION` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `CREDENTIAL_OWNER_TYPE` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL
DEFAULT 'GATEWAY',
+ PRIMARY KEY (`GATEWAY_ID`,`TOKEN_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CREDENTIALS`
+--
+
+LOCK TABLES `CREDENTIALS` WRITE;
+/*!40000 ALTER TABLE `CREDENTIALS` DISABLE KEYS */;
+INSERT INTO `CREDENTIALS` VALUES
('default','46a99a5a-8b55-4982-bfd7-90fe72b00d46',0x149D247A85EEF670D6919C6F2367E979799D210452590F82AE36956A6C3E303D4BAF4BCC5D3CAE6FC169132BDAF79C5B2D96C37105B1F2565A65B44494051300D51F1A6EE17BDA9E1097D3D95631D60ED2223ECE5C6F6FB518F578F6FE2C6A81BF1E971F58A2CA37933A857133B6BCEE12BE13D9D3A74334C2D5101C69E5279EE6C70623FFB80AC49611E37BC02A6ABC8287814E24D872BC2198D257730526415B65FE1097BC805145242B6113AF55EDD71F855F8D915E40C6FEC204E289BEAF2E24C95DD7E6B79AA90B387
[...]
+/*!40000 ALTER TABLE `CREDENTIALS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `experiment_catalog`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `experiment_catalog` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `experiment_catalog`;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) NOT NULL,
+ `CONFIG_VAL` varchar(255) NOT NULL,
+ `EXPIRE_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ `CATEGORY_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VAL`,`CATEGORY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('registry.version','0.16','2019-02-25
23:40:05','SYSTEM');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `EXPERIMENT`
+--
+
+DROP TABLE IF EXISTS `EXPERIMENT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EXPERIMENT` (
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `PROJECT_ID` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `EXPERIMENT_TYPE` varchar(255) DEFAULT NULL,
+ `USER_NAME` varchar(255) DEFAULT NULL,
+ `EXPERIMENT_NAME` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `EXECUTION_ID` varchar(255) DEFAULT NULL,
+ `GATEWAY_EXECUTION_ID` varchar(255) DEFAULT NULL,
+ `GATEWAY_INSTANCE_ID` varchar(255) DEFAULT NULL,
+ `ENABLE_EMAIL_NOTIFICATION` tinyint(1) DEFAULT NULL,
+ `EMAIL_ADDRESSES` text,
+ PRIMARY KEY (`EXPERIMENT_ID`),
+ KEY `PROJECT_ID` (`PROJECT_ID`),
+ CONSTRAINT `experiment_ibfk_1` FOREIGN KEY (`PROJECT_ID`) REFERENCES
`PROJECT` (`PROJECT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `EXPERIMENT`
+--
+
+LOCK TABLES `EXPERIMENT` WRITE;
+/*!40000 ALTER TABLE `EXPERIMENT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `EXPERIMENT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `EXPERIMENT_ERROR`
+--
+
+DROP TABLE IF EXISTS `EXPERIMENT_ERROR`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EXPERIMENT_ERROR` (
+ `ERROR_ID` varchar(255) NOT NULL,
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `ACTUAL_ERROR_MESSAGE` text,
+ `USER_FRIENDLY_MESSAGE` text,
+ `TRANSIENT_OR_PERSISTENT` tinyint(1) DEFAULT NULL,
+ `ROOT_CAUSE_ERROR_ID_LIST` text,
+ PRIMARY KEY (`ERROR_ID`,`EXPERIMENT_ID`),
+ KEY `EXPERIMENT_ID` (`EXPERIMENT_ID`),
+ CONSTRAINT `experiment_error_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`)
REFERENCES `EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `EXPERIMENT_ERROR`
+--
+
+LOCK TABLES `EXPERIMENT_ERROR` WRITE;
+/*!40000 ALTER TABLE `EXPERIMENT_ERROR` DISABLE KEYS */;
+/*!40000 ALTER TABLE `EXPERIMENT_ERROR` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `EXPERIMENT_INPUT`
+--
+
+DROP TABLE IF EXISTS `EXPERIMENT_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EXPERIMENT_INPUT` (
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `INPUT_NAME` varchar(255) NOT NULL,
+ `INPUT_VALUE` text,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `APPLICATION_ARGUMENT` varchar(255) DEFAULT NULL,
+ `STANDARD_INPUT` tinyint(1) DEFAULT NULL,
+ `USER_FRIENDLY_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `METADATA` varchar(4096) DEFAULT NULL,
+ `INPUT_ORDER` int(11) DEFAULT NULL,
+ `IS_REQUIRED` tinyint(1) DEFAULT NULL,
+ `REQUIRED_TO_ADDED_TO_CMD` tinyint(1) DEFAULT NULL,
+ `DATA_STAGED` tinyint(1) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `IS_READ_ONLY` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`EXPERIMENT_ID`,`INPUT_NAME`),
+ CONSTRAINT `experiment_input_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`)
REFERENCES `EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `EXPERIMENT_INPUT`
+--
+
+LOCK TABLES `EXPERIMENT_INPUT` WRITE;
+/*!40000 ALTER TABLE `EXPERIMENT_INPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `EXPERIMENT_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `EXPERIMENT_OUTPUT`
+--
+
+DROP TABLE IF EXISTS `EXPERIMENT_OUTPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EXPERIMENT_OUTPUT` (
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `OUTPUT_NAME` varchar(255) NOT NULL,
+ `OUTPUT_VALUE` text,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `APPLICATION_ARGUMENT` varchar(255) DEFAULT NULL,
+ `IS_REQUIRED` tinyint(1) DEFAULT NULL,
+ `REQUIRED_TO_ADDED_TO_CMD` tinyint(1) DEFAULT NULL,
+ `DATA_MOVEMENT` tinyint(1) DEFAULT NULL,
+ `LOCATION` varchar(255) DEFAULT NULL,
+ `SEARCH_QUERY` varchar(255) DEFAULT NULL,
+ `OUTPUT_STREAMING` smallint(6) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`EXPERIMENT_ID`,`OUTPUT_NAME`),
+ CONSTRAINT `experiment_output_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`)
REFERENCES `EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `EXPERIMENT_OUTPUT`
+--
+
+LOCK TABLES `EXPERIMENT_OUTPUT` WRITE;
+/*!40000 ALTER TABLE `EXPERIMENT_OUTPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `EXPERIMENT_OUTPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `EXPERIMENT_STATUS`
+--
+
+DROP TABLE IF EXISTS `EXPERIMENT_STATUS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EXPERIMENT_STATUS` (
+ `STATUS_ID` varchar(255) NOT NULL,
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `STATE` varchar(255) DEFAULT NULL,
+ `TIME_OF_STATE_CHANGE` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON
UPDATE CURRENT_TIMESTAMP(6),
+ `REASON` longtext,
+ PRIMARY KEY (`STATUS_ID`,`EXPERIMENT_ID`),
+ KEY `EXPERIMENT_ID` (`EXPERIMENT_ID`),
+ CONSTRAINT `experiment_status_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`)
REFERENCES `EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `EXPERIMENT_STATUS`
+--
+
+LOCK TABLES `EXPERIMENT_STATUS` WRITE;
+/*!40000 ALTER TABLE `EXPERIMENT_STATUS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `EXPERIMENT_STATUS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GATEWAY`
+--
+
+DROP TABLE IF EXISTS `GATEWAY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GATEWAY` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `GATEWAY_NAME` varchar(255) DEFAULT NULL,
+ `DOMAIN` varchar(255) DEFAULT NULL,
+ `EMAIL_ADDRESS` varchar(255) DEFAULT NULL,
+ `GATEWAY_ACRONYM` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_EMAIL` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_FIRST_NAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_APPROVAL_STATUS` varchar(255) DEFAULT NULL,
+ `GATEWAY_PUBLIC_ABSTRACT` varchar(255) DEFAULT NULL,
+ `GATEWAY_URL` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_LAST_NAME` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_PASSWORD_TOKEN` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_USERNAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_REVIEW_PROPOSAL_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `DECLINED_REASON` varchar(255) DEFAULT NULL,
+ `OAUTH_CLIENT_SECRET` varchar(255) DEFAULT NULL,
+ `OAUTH_CLIENT_ID` varchar(255) DEFAULT NULL,
+ `REQUEST_CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `REQUESTER_USERNAME` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GATEWAY`
+--
+
+LOCK TABLES `GATEWAY` WRITE;
+/*!40000 ALTER TABLE `GATEWAY` DISABLE KEYS */;
+INSERT INTO `GATEWAY` VALUES
('default',NULL,NULL,NULL,NULL,NULL,NULL,'APPROVED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9790c8c4-7d9b-4ccc-a820-ca5aac38d2ad','pga','2019-02-25
18:40:06',NULL);
+/*!40000 ALTER TABLE `GATEWAY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GATEWAY_WORKER`
+--
+
+DROP TABLE IF EXISTS `GATEWAY_WORKER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GATEWAY_WORKER` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) NOT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`USER_NAME`),
+ CONSTRAINT `gateway_worker_ibfk_1` FOREIGN KEY (`GATEWAY_ID`) REFERENCES
`GATEWAY` (`GATEWAY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GATEWAY_WORKER`
+--
+
+LOCK TABLES `GATEWAY_WORKER` WRITE;
+/*!40000 ALTER TABLE `GATEWAY_WORKER` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GATEWAY_WORKER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `JOB`
+--
+
+DROP TABLE IF EXISTS `JOB`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `JOB` (
+ `JOB_ID` varchar(255) NOT NULL,
+ `TASK_ID` varchar(255) NOT NULL,
+ `PROCESS_ID` varchar(255) DEFAULT NULL,
+ `JOB_DESCRIPTION` longtext NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `COMPUTE_RESOURCE_CONSUMED` varchar(255) DEFAULT NULL,
+ `JOB_NAME` varchar(255) DEFAULT NULL,
+ `WORKING_DIR` varchar(255) DEFAULT NULL,
+ `STD_OUT` longtext,
+ `STD_ERR` longtext,
+ `EXIT_CODE` int(11) DEFAULT NULL,
+ PRIMARY KEY (`JOB_ID`,`TASK_ID`),
+ KEY `TASK_ID` (`TASK_ID`),
+ CONSTRAINT `job_ibfk_1` FOREIGN KEY (`TASK_ID`) REFERENCES `TASK`
(`TASK_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `JOB`
+--
+
+LOCK TABLES `JOB` WRITE;
+/*!40000 ALTER TABLE `JOB` DISABLE KEYS */;
+/*!40000 ALTER TABLE `JOB` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `JOB_STATUS`
+--
+
+DROP TABLE IF EXISTS `JOB_STATUS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `JOB_STATUS` (
+ `STATUS_ID` varchar(255) NOT NULL,
+ `JOB_ID` varchar(255) NOT NULL,
+ `TASK_ID` varchar(255) NOT NULL,
+ `STATE` varchar(255) DEFAULT NULL,
+ `TIME_OF_STATE_CHANGE` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON
UPDATE CURRENT_TIMESTAMP(6),
+ `REASON` longtext,
+ PRIMARY KEY (`STATUS_ID`,`JOB_ID`,`TASK_ID`),
+ KEY `JOB_ID` (`JOB_ID`,`TASK_ID`),
+ CONSTRAINT `job_status_ibfk_1` FOREIGN KEY (`JOB_ID`, `TASK_ID`) REFERENCES
`JOB` (`JOB_ID`, `TASK_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `JOB_STATUS`
+--
+
+LOCK TABLES `JOB_STATUS` WRITE;
+/*!40000 ALTER TABLE `JOB_STATUS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `JOB_STATUS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `NOTIFICATION`
+--
+
+DROP TABLE IF EXISTS `NOTIFICATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NOTIFICATION` (
+ `NOTIFICATION_ID` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `TITLE` varchar(255) DEFAULT NULL,
+ `PRIORITY` varchar(255) DEFAULT NULL,
+ `NOTIFICATION_MESSAGE` varchar(4096) NOT NULL,
+ `PUBLISHED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ `EXPIRATION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `CREATION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`NOTIFICATION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `NOTIFICATION`
+--
+
+LOCK TABLES `NOTIFICATION` WRITE;
+/*!40000 ALTER TABLE `NOTIFICATION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `NOTIFICATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS`
+--
+
+DROP TABLE IF EXISTS `PROCESS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS` (
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `LAST_UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `PROCESS_DETAIL` text,
+ `APPLICATION_INTERFACE_ID` varchar(255) DEFAULT NULL,
+ `TASK_DAG` text,
+ `APPLICATION_DEPLOYMENT_ID` varchar(255) DEFAULT NULL,
+ `COMPUTE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `GATEWAY_EXECUTION_ID` varchar(255) DEFAULT NULL,
+ `ENABLE_EMAIL_NOTIFICATION` tinyint(1) DEFAULT NULL,
+ `EMAIL_ADDRESSES` text,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `USER_DN` varchar(255) DEFAULT NULL,
+ `GENERATE_CERT` smallint(6) DEFAULT NULL,
+ `EXPERIMENT_DATA_DIR` varchar(512) DEFAULT NULL,
+ `USERNAME` varchar(255) DEFAULT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL,
+ `USE_USER_CR_PREF` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`PROCESS_ID`),
+ KEY `EXPERIMENT_ID` (`EXPERIMENT_ID`),
+ CONSTRAINT `process_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`) REFERENCES
`EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS`
+--
+
+LOCK TABLES `PROCESS` WRITE;
+/*!40000 ALTER TABLE `PROCESS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS_ERROR`
+--
+
+DROP TABLE IF EXISTS `PROCESS_ERROR`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS_ERROR` (
+ `ERROR_ID` varchar(255) NOT NULL,
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `ACTUAL_ERROR_MESSAGE` text,
+ `USER_FRIENDLY_MESSAGE` text,
+ `TRANSIENT_OR_PERSISTENT` tinyint(1) DEFAULT NULL,
+ `ROOT_CAUSE_ERROR_ID_LIST` text,
+ PRIMARY KEY (`ERROR_ID`,`PROCESS_ID`),
+ KEY `PROCESS_ID` (`PROCESS_ID`),
+ CONSTRAINT `process_error_ibfk_1` FOREIGN KEY (`PROCESS_ID`) REFERENCES
`PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS_ERROR`
+--
+
+LOCK TABLES `PROCESS_ERROR` WRITE;
+/*!40000 ALTER TABLE `PROCESS_ERROR` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS_ERROR` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS_INPUT`
+--
+
+DROP TABLE IF EXISTS `PROCESS_INPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS_INPUT` (
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `INPUT_NAME` varchar(255) NOT NULL,
+ `INPUT_VALUE` text,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `APPLICATION_ARGUMENT` varchar(255) DEFAULT NULL,
+ `STANDARD_INPUT` tinyint(1) DEFAULT NULL,
+ `USER_FRIENDLY_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `METADATA` varchar(4096) DEFAULT NULL,
+ `INPUT_ORDER` int(11) DEFAULT NULL,
+ `IS_REQUIRED` tinyint(1) DEFAULT NULL,
+ `REQUIRED_TO_ADDED_TO_CMD` tinyint(1) DEFAULT NULL,
+ `DATA_STAGED` tinyint(1) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `IS_READ_ONLY` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`PROCESS_ID`,`INPUT_NAME`),
+ CONSTRAINT `process_input_ibfk_1` FOREIGN KEY (`PROCESS_ID`) REFERENCES
`PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS_INPUT`
+--
+
+LOCK TABLES `PROCESS_INPUT` WRITE;
+/*!40000 ALTER TABLE `PROCESS_INPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS_INPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS_OUTPUT`
+--
+
+DROP TABLE IF EXISTS `PROCESS_OUTPUT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS_OUTPUT` (
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `OUTPUT_NAME` varchar(255) NOT NULL,
+ `OUTPUT_VALUE` longtext,
+ `DATA_TYPE` varchar(255) DEFAULT NULL,
+ `APPLICATION_ARGUMENT` varchar(255) DEFAULT NULL,
+ `IS_REQUIRED` tinyint(1) DEFAULT NULL,
+ `REQUIRED_TO_ADDED_TO_CMD` tinyint(1) DEFAULT NULL,
+ `DATA_MOVEMENT` tinyint(1) DEFAULT NULL,
+ `LOCATION` varchar(255) DEFAULT NULL,
+ `SEARCH_QUERY` varchar(255) DEFAULT NULL,
+ `OUTPUT_STREAMING` smallint(6) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`PROCESS_ID`,`OUTPUT_NAME`),
+ CONSTRAINT `process_output_ibfk_1` FOREIGN KEY (`PROCESS_ID`) REFERENCES
`PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS_OUTPUT`
+--
+
+LOCK TABLES `PROCESS_OUTPUT` WRITE;
+/*!40000 ALTER TABLE `PROCESS_OUTPUT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS_OUTPUT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS_RESOURCE_SCHEDULE`
+--
+
+DROP TABLE IF EXISTS `PROCESS_RESOURCE_SCHEDULE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS_RESOURCE_SCHEDULE` (
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `RESOURCE_HOST_ID` varchar(255) DEFAULT NULL,
+ `TOTAL_CPU_COUNT` int(11) DEFAULT NULL,
+ `NODE_COUNT` int(11) DEFAULT NULL,
+ `NUMBER_OF_THREADS` int(11) DEFAULT NULL,
+ `QUEUE_NAME` varchar(255) DEFAULT NULL,
+ `WALL_TIME_LIMIT` int(11) DEFAULT NULL,
+ `TOTAL_PHYSICAL_MEMORY` int(11) DEFAULT NULL,
+ `STATIC_WORKING_DIR` varchar(255) DEFAULT NULL,
+ `OVERRIDE_ALLOCATION_PROJECT_NUMBER` varchar(255) DEFAULT NULL,
+ `OVERRIDE_LOGIN_USER_NAME` varchar(255) DEFAULT NULL,
+ `OVERRIDE_SCRATCH_LOCATION` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`PROCESS_ID`),
+ CONSTRAINT `process_resource_schedule_ibfk_1` FOREIGN KEY (`PROCESS_ID`)
REFERENCES `PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS_RESOURCE_SCHEDULE`
+--
+
+LOCK TABLES `PROCESS_RESOURCE_SCHEDULE` WRITE;
+/*!40000 ALTER TABLE `PROCESS_RESOURCE_SCHEDULE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS_RESOURCE_SCHEDULE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROCESS_STATUS`
+--
+
+DROP TABLE IF EXISTS `PROCESS_STATUS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROCESS_STATUS` (
+ `STATUS_ID` varchar(255) NOT NULL,
+ `PROCESS_ID` varchar(255) NOT NULL,
+ `STATE` varchar(255) DEFAULT NULL,
+ `TIME_OF_STATE_CHANGE` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON
UPDATE CURRENT_TIMESTAMP(6),
+ `REASON` longtext,
+ PRIMARY KEY (`STATUS_ID`,`PROCESS_ID`),
+ KEY `PROCESS_ID` (`PROCESS_ID`),
+ CONSTRAINT `process_status_ibfk_1` FOREIGN KEY (`PROCESS_ID`) REFERENCES
`PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROCESS_STATUS`
+--
+
+LOCK TABLES `PROCESS_STATUS` WRITE;
+/*!40000 ALTER TABLE `PROCESS_STATUS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROCESS_STATUS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROJECT`
+--
+
+DROP TABLE IF EXISTS `PROJECT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROJECT` (
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) DEFAULT NULL,
+ `PROJECT_NAME` varchar(255) DEFAULT NULL,
+ `PROJECT_ID` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (`PROJECT_ID`),
+ KEY `GATEWAY_ID` (`GATEWAY_ID`),
+ CONSTRAINT `project_ibfk_1` FOREIGN KEY (`GATEWAY_ID`) REFERENCES `GATEWAY`
(`GATEWAY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROJECT`
+--
+
+LOCK TABLES `PROJECT` WRITE;
+/*!40000 ALTER TABLE `PROJECT` DISABLE KEYS */;
+INSERT INTO `PROJECT` VALUES ('default','default-admin','Default
Project','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','This is the
default project for user default-admin','2019-02-25 18:46:45');
+/*!40000 ALTER TABLE `PROJECT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PROJECT_USER`
+--
+
+DROP TABLE IF EXISTS `PROJECT_USER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PROJECT_USER` (
+ `PROJECT_ID` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) NOT NULL,
+ PRIMARY KEY (`PROJECT_ID`,`USER_NAME`),
+ CONSTRAINT `project_user_ibfk_1` FOREIGN KEY (`PROJECT_ID`) REFERENCES
`PROJECT` (`PROJECT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PROJECT_USER`
+--
+
+LOCK TABLES `PROJECT_USER` WRITE;
+/*!40000 ALTER TABLE `PROJECT_USER` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PROJECT_USER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `QUEUE_STATUS`
+--
+
+DROP TABLE IF EXISTS `QUEUE_STATUS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `QUEUE_STATUS` (
+ `HOST_NAME` varchar(255) NOT NULL,
+ `QUEUE_NAME` varchar(255) NOT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `QUEUE_UP` tinyint(1) DEFAULT NULL,
+ `RUNNING_JOBS` int(11) DEFAULT NULL,
+ `QUEUED_JOBS` int(11) DEFAULT NULL,
+ PRIMARY KEY (`HOST_NAME`,`QUEUE_NAME`,`CREATED_TIME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `QUEUE_STATUS`
+--
+
+LOCK TABLES `QUEUE_STATUS` WRITE;
+/*!40000 ALTER TABLE `QUEUE_STATUS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `QUEUE_STATUS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `TASK`
+--
+
+DROP TABLE IF EXISTS `TASK`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TASK` (
+ `TASK_ID` varchar(255) NOT NULL,
+ `TASK_TYPE` varchar(255) DEFAULT NULL,
+ `PARENT_PROCESS_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `LAST_UPDATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `TASK_DETAIL` text,
+ `SUB_TASK_MODEL` blob,
+ PRIMARY KEY (`TASK_ID`),
+ KEY `PARENT_PROCESS_ID` (`PARENT_PROCESS_ID`),
+ CONSTRAINT `task_ibfk_1` FOREIGN KEY (`PARENT_PROCESS_ID`) REFERENCES
`PROCESS` (`PROCESS_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `TASK`
+--
+
+LOCK TABLES `TASK` WRITE;
+/*!40000 ALTER TABLE `TASK` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TASK` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `TASK_ERROR`
+--
+
+DROP TABLE IF EXISTS `TASK_ERROR`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TASK_ERROR` (
+ `ERROR_ID` varchar(255) NOT NULL,
+ `TASK_ID` varchar(255) NOT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `ACTUAL_ERROR_MESSAGE` text,
+ `USER_FRIENDLY_MESSAGE` text,
+ `TRANSIENT_OR_PERSISTENT` tinyint(1) DEFAULT NULL,
+ `ROOT_CAUSE_ERROR_ID_LIST` text,
+ PRIMARY KEY (`ERROR_ID`,`TASK_ID`),
+ KEY `TASK_ID` (`TASK_ID`),
+ CONSTRAINT `task_error_ibfk_1` FOREIGN KEY (`TASK_ID`) REFERENCES `TASK`
(`TASK_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `TASK_ERROR`
+--
+
+LOCK TABLES `TASK_ERROR` WRITE;
+/*!40000 ALTER TABLE `TASK_ERROR` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TASK_ERROR` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `TASK_STATUS`
+--
+
+DROP TABLE IF EXISTS `TASK_STATUS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TASK_STATUS` (
+ `STATUS_ID` varchar(255) NOT NULL,
+ `TASK_ID` varchar(255) NOT NULL,
+ `STATE` varchar(255) DEFAULT NULL,
+ `TIME_OF_STATE_CHANGE` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON
UPDATE CURRENT_TIMESTAMP(6),
+ `REASON` longtext,
+ PRIMARY KEY (`STATUS_ID`,`TASK_ID`),
+ KEY `TASK_ID` (`TASK_ID`),
+ CONSTRAINT `task_status_ibfk_1` FOREIGN KEY (`TASK_ID`) REFERENCES `TASK`
(`TASK_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `TASK_STATUS`
+--
+
+LOCK TABLES `TASK_STATUS` WRITE;
+/*!40000 ALTER TABLE `TASK_STATUS` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TASK_STATUS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USERS`
+--
+
+DROP TABLE IF EXISTS `USERS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USERS` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) NOT NULL,
+ `PASSWORD` varchar(255) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`GATEWAY_ID`,`USER_NAME`),
+ UNIQUE KEY `AIRAVATA_INTERNAL_USER_ID` (`AIRAVATA_INTERNAL_USER_ID`),
+ CONSTRAINT `users_ibfk_1` FOREIGN KEY (`GATEWAY_ID`) REFERENCES `GATEWAY`
(`GATEWAY_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USERS`
+--
+
+LOCK TABLES `USERS` WRITE;
+/*!40000 ALTER TABLE `USERS` DISABLE KEYS */;
+INSERT INTO `USERS` VALUES
('DO_NOT_SET_AT_CLIENTS','default-admin',NULL,'default');
+/*!40000 ALTER TABLE `USERS` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_CONFIGURATION_DATA`
+--
+
+DROP TABLE IF EXISTS `USER_CONFIGURATION_DATA`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_CONFIGURATION_DATA` (
+ `EXPERIMENT_ID` varchar(255) NOT NULL,
+ `AIRAVATA_AUTO_SCHEDULE` tinyint(1) DEFAULT NULL,
+ `OVERRIDE_MANUAL_SCHEDULED_PARAMS` tinyint(1) DEFAULT NULL,
+ `SHARE_EXPERIMENT_PUBLICALLY` tinyint(1) DEFAULT NULL,
+ `THROTTLE_RESOURCES` tinyint(1) DEFAULT NULL,
+ `USER_DN` varchar(255) DEFAULT NULL,
+ `GENERATE_CERT` tinyint(1) DEFAULT NULL,
+ `RESOURCE_HOST_ID` varchar(255) DEFAULT NULL,
+ `TOTAL_CPU_COUNT` int(11) DEFAULT NULL,
+ `NODE_COUNT` int(11) DEFAULT NULL,
+ `NUMBER_OF_THREADS` int(11) DEFAULT NULL,
+ `QUEUE_NAME` varchar(255) DEFAULT NULL,
+ `WALL_TIME_LIMIT` int(11) DEFAULT NULL,
+ `TOTAL_PHYSICAL_MEMORY` int(11) DEFAULT NULL,
+ `STATIC_WORKING_DIR` varchar(255) DEFAULT NULL,
+ `OVERRIDE_LOGIN_USER_NAME` varchar(255) DEFAULT NULL,
+ `OVERRIDE_SCRATCH_LOCATION` varchar(255) DEFAULT NULL,
+ `OVERRIDE_ALLOCATION_PROJECT_NUMBER` varchar(255) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `EXPERIMENT_DATA_DIR` varchar(512) DEFAULT NULL,
+ `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL,
+ `IS_USE_USER_CR_PREF` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`EXPERIMENT_ID`),
+ CONSTRAINT `user_configuration_data_ibfk_1` FOREIGN KEY (`EXPERIMENT_ID`)
REFERENCES `EXPERIMENT` (`EXPERIMENT_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_CONFIGURATION_DATA`
+--
+
+LOCK TABLES `USER_CONFIGURATION_DATA` WRITE;
+/*!40000 ALTER TABLE `USER_CONFIGURATION_DATA` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_CONFIGURATION_DATA` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Temporary table structure for view `experiment_summary`
+--
+
+DROP TABLE IF EXISTS `experiment_summary`;
+/*!50001 DROP VIEW IF EXISTS `experiment_summary`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `experiment_summary` AS SELECT
+ 1 AS `EXPERIMENT_ID`,
+ 1 AS `PROJECT_ID`,
+ 1 AS `GATEWAY_ID`,
+ 1 AS `USER_NAME`,
+ 1 AS `EXECUTION_ID`,
+ 1 AS `EXPERIMENT_NAME`,
+ 1 AS `CREATION_TIME`,
+ 1 AS `DESCRIPTION`,
+ 1 AS `STATE`,
+ 1 AS `RESOURCE_HOST_ID`,
+ 1 AS `TIME_OF_STATE_CHANGE`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Temporary table structure for view `latest_experiment_status`
+--
+
+DROP TABLE IF EXISTS `latest_experiment_status`;
+/*!50001 DROP VIEW IF EXISTS `latest_experiment_status`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `latest_experiment_status` AS SELECT
+ 1 AS `EXPERIMENT_ID`,
+ 1 AS `STATE`,
+ 1 AS `TIME_OF_STATE_CHANGE`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Current Database: `profile_service`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `profile_service` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `profile_service`;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) NOT NULL,
+ `CONFIG_VAL` varchar(255) NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VAL`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('user_profile_catalog_version','0.17');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `CUSTOMIZED_DASHBOARD`
+--
+
+DROP TABLE IF EXISTS `CUSTOMIZED_DASHBOARD`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CUSTOMIZED_DASHBOARD` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `ENABLED_EXPERIMENT_ID` varchar(255) DEFAULT NULL,
+ `ENABLED_NAME` varchar(255) DEFAULT NULL,
+ `ENABLED_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `ENABLED_PROJECT` varchar(255) DEFAULT NULL,
+ `ENABLED_OWNER` varchar(255) DEFAULT NULL,
+ `ENABLED_APPLICATION` varchar(255) DEFAULT NULL,
+ `ENABLED_COMPUTE_RESOURCE` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_NAME` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_ID` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_STATUS` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_CREATION_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_NOTIFICATIONS_TO` varchar(255) DEFAULT NULL,
+ `ENABLED_WORKING_DIR` varchar(255) DEFAULT NULL,
+ `ENABLED_JOB_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `ENABLED_CREATION_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_LAST_MODIFIED_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_WALL_TIME` varchar(255) DEFAULT NULL,
+ `ENABLED_CPU_COUNT` varchar(255) DEFAULT NULL,
+ `ENABLED_NODE_COUNT` varchar(255) DEFAULT NULL,
+ `ENABLED_QUEUE` varchar(255) DEFAULT NULL,
+ `ENABLED_INPUTS` varchar(255) DEFAULT NULL,
+ `ENABLED_OUTPUTS` varchar(255) DEFAULT NULL,
+ `ENABLED_STORAGE_DIR` varchar(255) DEFAULT NULL,
+ `ENABLED_ERRORS` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`),
+ CONSTRAINT `customized_dashboard_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CUSTOMIZED_DASHBOARD`
+--
+
+LOCK TABLES `CUSTOMIZED_DASHBOARD` WRITE;
+/*!40000 ALTER TABLE `CUSTOMIZED_DASHBOARD` DISABLE KEYS */;
+/*!40000 ALTER TABLE `CUSTOMIZED_DASHBOARD` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GATEWAY`
+--
+
+DROP TABLE IF EXISTS `GATEWAY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GATEWAY` (
+ `AIRAVATA_INTERNAL_GATEWAY_ID` varchar(255) NOT NULL,
+ `DECLINED_REASON` varchar(255) DEFAULT NULL,
+ `GATEWAY_DOMAIN` varchar(255) DEFAULT NULL,
+ `EMAIL_ADDRESS` varchar(255) DEFAULT NULL,
+ `GATEWAY_ACRONYM` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_EMAIL` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_FIRST_NAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_ADMIN_LAST_NAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_APPROVAL_STATUS` varchar(255) DEFAULT NULL,
+ `GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `GATEWAY_NAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_PUBLIC_ABSTRACT` varchar(255) DEFAULT NULL,
+ `GATEWAY_URL` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_PASSWORD_TOKEN` varchar(255) DEFAULT NULL,
+ `IDENTITY_SERVER_USERNAME` varchar(255) DEFAULT NULL,
+ `OAUTH_CLIENT_ID` varchar(255) DEFAULT NULL,
+ `OAUTH_CLIENT_SECRET` varchar(255) DEFAULT NULL,
+ `REQUEST_CREATION_TIME` bigint(20) DEFAULT NULL,
+ `REQUESTER_USERNAME` varchar(255) DEFAULT NULL,
+ `GATEWAY_REVIEW_PROPOSAL_DESCRIPTION` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_GATEWAY_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GATEWAY`
+--
+
+LOCK TABLES `GATEWAY` WRITE;
+/*!40000 ALTER TABLE `GATEWAY` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GATEWAY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `NSF_DEMOGRAPHIC`
+--
+
+DROP TABLE IF EXISTS `NSF_DEMOGRAPHIC`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NSF_DEMOGRAPHIC` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `GENDER` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`),
+ CONSTRAINT `nsf_demographic_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `NSF_DEMOGRAPHIC`
+--
+
+LOCK TABLES `NSF_DEMOGRAPHIC` WRITE;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC` DISABLE KEYS */;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `NSF_DEMOGRAPHIC_DISABILITY`
+--
+
+DROP TABLE IF EXISTS `NSF_DEMOGRAPHIC_DISABILITY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NSF_DEMOGRAPHIC_DISABILITY` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `DISABILITY` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`DISABILITY`),
+ CONSTRAINT `nsf_demographic_disability_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `NSF_DEMOGRAPHIC`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `NSF_DEMOGRAPHIC_DISABILITY`
+--
+
+LOCK TABLES `NSF_DEMOGRAPHIC_DISABILITY` WRITE;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_DISABILITY` DISABLE KEYS */;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_DISABILITY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `NSF_DEMOGRAPHIC_ETHNICITY`
+--
+
+DROP TABLE IF EXISTS `NSF_DEMOGRAPHIC_ETHNICITY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NSF_DEMOGRAPHIC_ETHNICITY` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `ETHNICITY` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`ETHNICITY`),
+ CONSTRAINT `nsf_demographic_ethnicity_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `NSF_DEMOGRAPHIC`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `NSF_DEMOGRAPHIC_ETHNICITY`
+--
+
+LOCK TABLES `NSF_DEMOGRAPHIC_ETHNICITY` WRITE;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_ETHNICITY` DISABLE KEYS */;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_ETHNICITY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `NSF_DEMOGRAPHIC_RACE`
+--
+
+DROP TABLE IF EXISTS `NSF_DEMOGRAPHIC_RACE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NSF_DEMOGRAPHIC_RACE` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `RACE` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`RACE`),
+ CONSTRAINT `nsf_demographic_race_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `NSF_DEMOGRAPHIC`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `NSF_DEMOGRAPHIC_RACE`
+--
+
+LOCK TABLES `NSF_DEMOGRAPHIC_RACE` WRITE;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_RACE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `NSF_DEMOGRAPHIC_RACE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_PROFILE`
+--
+
+DROP TABLE IF EXISTS `USER_PROFILE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_PROFILE` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `USER_ID` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) NOT NULL,
+ `USER_MODEL_VERSION` varchar(255) DEFAULT NULL,
+ `FIRST_NAME` varchar(255) DEFAULT NULL,
+ `LAST_NAME` varchar(255) DEFAULT NULL,
+ `MIDDLE_NAME` varchar(255) DEFAULT NULL,
+ `NAME_PREFIX` varchar(255) DEFAULT NULL,
+ `NAME_SUFFIX` varchar(255) DEFAULT NULL,
+ `ORCID_ID` varchar(255) DEFAULT NULL,
+ `COUNTRY` varchar(255) DEFAULT NULL,
+ `HOME_ORGANIZATION` varchar(255) DEFAULT NULL,
+ `ORIGINATION_AFFILIATION` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `LAST_ACCESS_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `VALID_UNTIL` datetime DEFAULT NULL,
+ `STATE` varchar(255) DEFAULT NULL,
+ `COMMENTS` text,
+ `GPG_KEY` text,
+ `TIME_ZONE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_PROFILE`
+--
+
+LOCK TABLES `USER_PROFILE` WRITE;
+/*!40000 ALTER TABLE `USER_PROFILE` DISABLE KEYS */;
+INSERT INTO `USER_PROFILE` VALUES
('default-admin@default','default-admin','default','1.0','dim','Upe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-02-25
18:46:43','2019-02-25 18:46:43','1969-12-31 19:00:00','ACTIVE',NULL,NULL,NULL);
+/*!40000 ALTER TABLE `USER_PROFILE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_PROFILE_EMAIL`
+--
+
+DROP TABLE IF EXISTS `USER_PROFILE_EMAIL`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_PROFILE_EMAIL` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `EMAIL` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`EMAIL`),
+ CONSTRAINT `user_profile_email_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_PROFILE_EMAIL`
+--
+
+LOCK TABLES `USER_PROFILE_EMAIL` WRITE;
+/*!40000 ALTER TABLE `USER_PROFILE_EMAIL` DISABLE KEYS */;
+INSERT INTO `USER_PROFILE_EMAIL` VALUES
('default-admin@default','[email protected]');
+/*!40000 ALTER TABLE `USER_PROFILE_EMAIL` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_PROFILE_LABELED_URI`
+--
+
+DROP TABLE IF EXISTS `USER_PROFILE_LABELED_URI`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_PROFILE_LABELED_URI` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `LABELED_URI` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`LABELED_URI`),
+ CONSTRAINT `user_profile_labeled_uri_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_PROFILE_LABELED_URI`
+--
+
+LOCK TABLES `USER_PROFILE_LABELED_URI` WRITE;
+/*!40000 ALTER TABLE `USER_PROFILE_LABELED_URI` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_PROFILE_LABELED_URI` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_PROFILE_NATIONALITY`
+--
+
+DROP TABLE IF EXISTS `USER_PROFILE_NATIONALITY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_PROFILE_NATIONALITY` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `NATIONALITY` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`NATIONALITY`),
+ CONSTRAINT `user_profile_nationality_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_PROFILE_NATIONALITY`
+--
+
+LOCK TABLES `USER_PROFILE_NATIONALITY` WRITE;
+/*!40000 ALTER TABLE `USER_PROFILE_NATIONALITY` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_PROFILE_NATIONALITY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_PROFILE_PHONE`
+--
+
+DROP TABLE IF EXISTS `USER_PROFILE_PHONE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_PROFILE_PHONE` (
+ `AIRAVATA_INTERNAL_USER_ID` varchar(255) NOT NULL,
+ `PHONE` varchar(255) NOT NULL,
+ PRIMARY KEY (`AIRAVATA_INTERNAL_USER_ID`,`PHONE`),
+ CONSTRAINT `user_profile_phone_ibfk_1` FOREIGN KEY
(`AIRAVATA_INTERNAL_USER_ID`) REFERENCES `USER_PROFILE`
(`AIRAVATA_INTERNAL_USER_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_PROFILE_PHONE`
+--
+
+LOCK TABLES `USER_PROFILE_PHONE` WRITE;
+/*!40000 ALTER TABLE `USER_PROFILE_PHONE` DISABLE KEYS */;
+/*!40000 ALTER TABLE `USER_PROFILE_PHONE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `replica_catalog`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `replica_catalog` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `replica_catalog`;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) NOT NULL,
+ `CONFIG_VAL` varchar(255) NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VAL`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('data_catalog_version','0.16');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DATA_PRODUCT`
+--
+
+DROP TABLE IF EXISTS `DATA_PRODUCT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATA_PRODUCT` (
+ `PRODUCT_URI` varchar(255) NOT NULL,
+ `GATEWAY_ID` varchar(255) DEFAULT NULL,
+ `PRODUCT_NAME` varchar(255) DEFAULT NULL,
+ `PRODUCT_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `OWNER_NAME` varchar(255) DEFAULT NULL,
+ `PARENT_PRODUCT_URI` varchar(255) DEFAULT NULL,
+ `PRODUCT_SIZE` int(11) DEFAULT NULL,
+ `CREATION_TIME` timestamp NULL DEFAULT '0000-00-00 00:00:00',
+ `LAST_MODIFIED_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ `PRODUCT_TYPE` varchar(10) DEFAULT NULL,
+ PRIMARY KEY (`PRODUCT_URI`),
+ KEY `PARENT_PRODUCT_URI` (`PARENT_PRODUCT_URI`),
+ CONSTRAINT `data_product_ibfk_1` FOREIGN KEY (`PARENT_PRODUCT_URI`)
REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DATA_PRODUCT`
+--
+
+LOCK TABLES `DATA_PRODUCT` WRITE;
+/*!40000 ALTER TABLE `DATA_PRODUCT` DISABLE KEYS */;
+/*!40000 ALTER TABLE `DATA_PRODUCT` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DATA_PRODUCT_METADATA`
+--
+
+DROP TABLE IF EXISTS `DATA_PRODUCT_METADATA`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATA_PRODUCT_METADATA` (
+ `PRODUCT_URI` varchar(255) NOT NULL,
+ `METADATA_KEY` varchar(255) NOT NULL,
+ `METADATA_VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`PRODUCT_URI`,`METADATA_KEY`),
+ CONSTRAINT `data_product_metadata_ibfk_1` FOREIGN KEY (`PRODUCT_URI`)
REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DATA_PRODUCT_METADATA`
+--
+
+LOCK TABLES `DATA_PRODUCT_METADATA` WRITE;
+/*!40000 ALTER TABLE `DATA_PRODUCT_METADATA` DISABLE KEYS */;
+/*!40000 ALTER TABLE `DATA_PRODUCT_METADATA` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DATA_REPLICA_LOCATION`
+--
+
+DROP TABLE IF EXISTS `DATA_REPLICA_LOCATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATA_REPLICA_LOCATION` (
+ `REPLICA_ID` varchar(255) NOT NULL,
+ `PRODUCT_URI` varchar(255) NOT NULL,
+ `REPLICA_NAME` varchar(255) DEFAULT NULL,
+ `REPLICA_DESCRIPTION` varchar(255) DEFAULT NULL,
+ `STORAGE_RESOURCE_ID` varchar(255) DEFAULT NULL,
+ `FILE_PATH` varchar(255) DEFAULT NULL,
+ `CREATION_TIME` timestamp NULL DEFAULT '0000-00-00 00:00:00',
+ `LAST_MODIFIED_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ `VALID_UNTIL_TIME` timestamp NULL DEFAULT '0000-00-00 00:00:00',
+ `REPLICA_LOCATION_CATEGORY` varchar(26) DEFAULT NULL,
+ `REPLICA_PERSISTENT_TYPE` varchar(10) DEFAULT NULL,
+ PRIMARY KEY (`REPLICA_ID`),
+ KEY `PRODUCT_URI` (`PRODUCT_URI`),
+ CONSTRAINT `data_replica_location_ibfk_1` FOREIGN KEY (`PRODUCT_URI`)
REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DATA_REPLICA_LOCATION`
+--
+
+LOCK TABLES `DATA_REPLICA_LOCATION` WRITE;
+/*!40000 ALTER TABLE `DATA_REPLICA_LOCATION` DISABLE KEYS */;
+/*!40000 ALTER TABLE `DATA_REPLICA_LOCATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DATA_REPLICA_METADATA`
+--
+
+DROP TABLE IF EXISTS `DATA_REPLICA_METADATA`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATA_REPLICA_METADATA` (
+ `REPLICA_ID` varchar(255) NOT NULL,
+ `METADATA_KEY` varchar(255) NOT NULL,
+ `METADATA_VALUE` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`REPLICA_ID`,`METADATA_KEY`),
+ CONSTRAINT `data_replica_metadata_ibfk_1` FOREIGN KEY (`REPLICA_ID`)
REFERENCES `DATA_REPLICA_LOCATION` (`REPLICA_ID`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DATA_REPLICA_METADATA`
+--
+
+LOCK TABLES `DATA_REPLICA_METADATA` WRITE;
+/*!40000 ALTER TABLE `DATA_REPLICA_METADATA` DISABLE KEYS */;
+/*!40000 ALTER TABLE `DATA_REPLICA_METADATA` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `sharing_catalog`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sharing_catalog` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `sharing_catalog`;
+
+--
+-- Table structure for table `CONFIGURATION`
+--
+
+DROP TABLE IF EXISTS `CONFIGURATION`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CONFIGURATION` (
+ `CONFIG_KEY` varchar(255) NOT NULL,
+ `CONFIG_VALUE` varchar(255) NOT NULL,
+ PRIMARY KEY (`CONFIG_KEY`,`CONFIG_VALUE`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `CONFIGURATION`
+--
+
+LOCK TABLES `CONFIGURATION` WRITE;
+/*!40000 ALTER TABLE `CONFIGURATION` DISABLE KEYS */;
+INSERT INTO `CONFIGURATION` VALUES ('sharing_reg_version','0.17');
+/*!40000 ALTER TABLE `CONFIGURATION` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DOMAIN`
+--
+
+DROP TABLE IF EXISTS `DOMAIN`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DOMAIN` (
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`DOMAIN_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DOMAIN`
+--
+
+LOCK TABLES `DOMAIN` WRITE;
+/*!40000 ALTER TABLE `DOMAIN` DISABLE KEYS */;
+INSERT INTO `DOMAIN` VALUES ('default','default','Domain entry for
default',1551138011532,1551138011532);
+/*!40000 ALTER TABLE `DOMAIN` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ENTITY`
+--
+
+DROP TABLE IF EXISTS `ENTITY`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ENTITY` (
+ `ENTITY_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `ENTITY_TYPE_ID` varchar(255) NOT NULL,
+ `OWNER_ID` varchar(255) NOT NULL,
+ `PARENT_ENTITY_ID` varchar(255) DEFAULT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `BINARY_DATA` blob,
+ `FULL_TEXT` text,
+ `SHARED_COUNT` bigint(20) DEFAULT '0',
+ `ORIGINAL_ENTITY_CREATION_TIME` bigint(20) NOT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`ENTITY_ID`,`DOMAIN_ID`),
+ KEY `ENTITY_TYPE_ID` (`ENTITY_TYPE_ID`,`DOMAIN_ID`),
+ KEY `OWNER_ID` (`OWNER_ID`,`DOMAIN_ID`),
+ KEY `PARENT_ENTITY_ID` (`PARENT_ENTITY_ID`,`DOMAIN_ID`),
+ FULLTEXT KEY `FULL_TEXT_INDEX` (`FULL_TEXT`),
+ CONSTRAINT `entity_ibfk_1` FOREIGN KEY (`ENTITY_TYPE_ID`, `DOMAIN_ID`)
REFERENCES `ENTITY_TYPE` (`ENTITY_TYPE_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON
UPDATE NO ACTION,
+ CONSTRAINT `entity_ibfk_2` FOREIGN KEY (`OWNER_ID`, `DOMAIN_ID`) REFERENCES
`SHARING_USER` (`USER_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
+ CONSTRAINT `entity_ibfk_3` FOREIGN KEY (`PARENT_ENTITY_ID`, `DOMAIN_ID`)
REFERENCES `ENTITY` (`ENTITY_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO
ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ENTITY`
+--
+
+LOCK TABLES `ENTITY` WRITE;
+/*!40000 ALTER TABLE `ENTITY` DISABLE KEYS */;
+INSERT INTO `ENTITY` VALUES
('46a99a5a-8b55-4982-bfd7-90fe72b00d46','default','default:CREDENTIAL_TOKEN','default-admin@default',NULL,'46a99a5a-8b55-4982-bfd7-90fe72b00d46','Default',NULL,NULL,0,1551139607733,1551139607733,1551139607733),('af03c63d-a40e-4ed1-aee0-759a6ed0202c','default','default:GROUP_RESOURCE_PROFILE','default-admin@default',NULL,'Default-Group-Resource-Profile',NULL,NULL,NULL,3,1552318871908,1552318871908,1552318871908),('Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM
[...]
+/*!40000 ALTER TABLE `ENTITY` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ENTITY_TYPE`
+--
+
+DROP TABLE IF EXISTS `ENTITY_TYPE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ENTITY_TYPE` (
+ `ENTITY_TYPE_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`ENTITY_TYPE_ID`,`DOMAIN_ID`),
+ KEY `DOMAIN_ID` (`DOMAIN_ID`),
+ CONSTRAINT `entity_type_ibfk_1` FOREIGN KEY (`DOMAIN_ID`) REFERENCES
`DOMAIN` (`DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ENTITY_TYPE`
+--
+
+LOCK TABLES `ENTITY_TYPE` WRITE;
+/*!40000 ALTER TABLE `ENTITY_TYPE` DISABLE KEYS */;
+INSERT INTO `ENTITY_TYPE` VALUES
('default:APPLICATION_DEPLOYMENT','default','APPLICATION-DEPLOYMENT','Application
Deployment entity
type',1551138011706,1551138011706),('default:CREDENTIAL_TOKEN','default','CREDENTIAL_TOKEN','Credential
Store Token entity
type',1551138011735,1551138011735),('default:EXPERIMENT','default','EXPERIMENT','Experiment
entity
type',1551138011685,1551138011685),('default:FILE','default','FILE','File
entity type',1551138011696,1551138011696),('default:GROUP_RESOU [...]
+/*!40000 ALTER TABLE `ENTITY_TYPE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GROUP_ADMIN`
+--
+
+DROP TABLE IF EXISTS `GROUP_ADMIN`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GROUP_ADMIN` (
+ `ADMIN_ID` varchar(255) NOT NULL,
+ `GROUP_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ PRIMARY KEY (`ADMIN_ID`,`GROUP_ID`,`DOMAIN_ID`),
+ KEY `ADMIN_ID` (`ADMIN_ID`,`DOMAIN_ID`),
+ CONSTRAINT `group_admin_ibfk_1` FOREIGN KEY (`ADMIN_ID`, `DOMAIN_ID`)
REFERENCES `SHARING_USER` (`USER_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE
NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GROUP_ADMIN`
+--
+
+LOCK TABLES `GROUP_ADMIN` WRITE;
+/*!40000 ALTER TABLE `GROUP_ADMIN` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GROUP_ADMIN` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `GROUP_MEMBERSHIP`
+--
+
+DROP TABLE IF EXISTS `GROUP_MEMBERSHIP`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GROUP_MEMBERSHIP` (
+ `PARENT_ID` varchar(255) NOT NULL,
+ `CHILD_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `CHILD_TYPE` varchar(255) NOT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`PARENT_ID`,`CHILD_ID`,`DOMAIN_ID`),
+ KEY `PARENT_ID` (`PARENT_ID`,`DOMAIN_ID`),
+ KEY `CHILD_ID` (`CHILD_ID`,`DOMAIN_ID`),
+ CONSTRAINT `group_membership_ibfk_1` FOREIGN KEY (`PARENT_ID`, `DOMAIN_ID`)
REFERENCES `USER_GROUP` (`GROUP_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE
NO ACTION,
+ CONSTRAINT `group_membership_ibfk_2` FOREIGN KEY (`CHILD_ID`, `DOMAIN_ID`)
REFERENCES `USER_GROUP` (`GROUP_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE
NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `GROUP_MEMBERSHIP`
+--
+
+LOCK TABLES `GROUP_MEMBERSHIP` WRITE;
+/*!40000 ALTER TABLE `GROUP_MEMBERSHIP` DISABLE KEYS */;
+INSERT INTO `GROUP_MEMBERSHIP` VALUES
('Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','default-admin@default','default','USER',1551138405079,1551138405079),('Gateway_Users_2e4e6eb4-05ad-4a0f-92d1-02aa26c56004','default-admin@default','default','USER',1551138405029,1551138405029),('Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','default-admin@default','default','USER',1551138405107,1551138405107);
+/*!40000 ALTER TABLE `GROUP_MEMBERSHIP` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PERMISSION_TYPE`
+--
+
+DROP TABLE IF EXISTS `PERMISSION_TYPE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PERMISSION_TYPE` (
+ `PERMISSION_TYPE_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`PERMISSION_TYPE_ID`,`DOMAIN_ID`),
+ KEY `DOMAIN_ID` (`DOMAIN_ID`),
+ CONSTRAINT `permission_type_ibfk_1` FOREIGN KEY (`DOMAIN_ID`) REFERENCES
`DOMAIN` (`DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PERMISSION_TYPE`
+--
+
+LOCK TABLES `PERMISSION_TYPE` WRITE;
+/*!40000 ALTER TABLE `PERMISSION_TYPE` DISABLE KEYS */;
+INSERT INTO `PERMISSION_TYPE` VALUES
('default:OWNER','default','OWNER','GLOBAL permission to
default',1551138011561,1551138011561),('default:READ','default','READ','Read
permission
type',1551138011783,1551138011783),('default:WRITE','default','WRITE','Write
permission type',1551138011808,1551138011808);
+/*!40000 ALTER TABLE `PERMISSION_TYPE` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `SHARING`
+--
+
+DROP TABLE IF EXISTS `SHARING`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SHARING` (
+ `PERMISSION_TYPE_ID` varchar(255) NOT NULL,
+ `ENTITY_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `GROUP_ID` varchar(255) NOT NULL,
+ `SHARING_TYPE` varchar(255) NOT NULL,
+ `INHERITED_PARENT_ID` varchar(255) NOT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY
(`PERMISSION_TYPE_ID`,`ENTITY_ID`,`GROUP_ID`,`DOMAIN_ID`,`INHERITED_PARENT_ID`),
+ KEY `SHARING_PERMISSION_TYPE_ID_DOMAIN_ID_FK`
(`PERMISSION_TYPE_ID`,`DOMAIN_ID`),
+ KEY `SHARING_ENTITY_ID_DOMAIN_ID_FK` (`ENTITY_ID`,`DOMAIN_ID`),
+ KEY `SHARING_INHERITED_PARENT_ID_DOMAIN_ID_FK`
(`INHERITED_PARENT_ID`,`DOMAIN_ID`),
+ KEY `SHARING_GROUP_ID_DOMAIN_ID_FK` (`GROUP_ID`,`DOMAIN_ID`),
+ CONSTRAINT `SHARING_ENTITY_ID_DOMAIN_ID_FK` FOREIGN KEY (`ENTITY_ID`,
`DOMAIN_ID`) REFERENCES `ENTITY` (`ENTITY_ID`, `DOMAIN_ID`) ON DELETE CASCADE
ON UPDATE NO ACTION,
+ CONSTRAINT `SHARING_GROUP_ID_DOMAIN_ID_FK` FOREIGN KEY (`GROUP_ID`,
`DOMAIN_ID`) REFERENCES `USER_GROUP` (`GROUP_ID`, `DOMAIN_ID`) ON DELETE
CASCADE ON UPDATE NO ACTION,
+ CONSTRAINT `SHARING_INHERITED_PARENT_ID_DOMAIN_ID_FK` FOREIGN KEY
(`INHERITED_PARENT_ID`, `DOMAIN_ID`) REFERENCES `ENTITY` (`ENTITY_ID`,
`DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
+ CONSTRAINT `SHARING_PERMISSION_TYPE_ID_DOMAIN_ID_FK` FOREIGN KEY
(`PERMISSION_TYPE_ID`, `DOMAIN_ID`) REFERENCES `PERMISSION_TYPE`
(`PERMISSION_TYPE_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `SHARING`
+--
+
+LOCK TABLES `SHARING` WRITE;
+/*!40000 ALTER TABLE `SHARING` DISABLE KEYS */;
+INSERT INTO `SHARING` VALUES
('default:OWNER','46a99a5a-8b55-4982-bfd7-90fe72b00d46','default','default-admin@default','DIRECT_CASCADING','46a99a5a-8b55-4982-bfd7-90fe72b00d46',1551139607745,1551139607745),('default:OWNER','af03c63d-a40e-4ed1-aee0-759a6ed0202c','default','default-admin@default','DIRECT_CASCADING','af03c63d-a40e-4ed1-aee0-759a6ed0202c',1552318871935,1552318871935),('default:OWNER','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b','defa
[...]
+/*!40000 ALTER TABLE `SHARING` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `SHARING_USER`
+--
+
+DROP TABLE IF EXISTS `SHARING_USER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SHARING_USER` (
+ `USER_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) NOT NULL,
+ `FIRST_NAME` varchar(255) DEFAULT NULL,
+ `LAST_NAME` varchar(255) DEFAULT NULL,
+ `EMAIL` varchar(255) DEFAULT NULL,
+ `ICON` blob,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`USER_ID`,`DOMAIN_ID`),
+ KEY `DOMAIN_ID` (`DOMAIN_ID`),
+ CONSTRAINT `sharing_user_ibfk_1` FOREIGN KEY (`DOMAIN_ID`) REFERENCES
`DOMAIN` (`DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `SHARING_USER`
+--
+
+LOCK TABLES `SHARING_USER` WRITE;
+/*!40000 ALTER TABLE `SHARING_USER` DISABLE KEYS */;
+INSERT INTO `SHARING_USER` VALUES ('default-admin@default','default','dim
Upe',NULL,NULL,'[email protected]',NULL,1551138011603,1551138404868);
+/*!40000 ALTER TABLE `SHARING_USER` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `USER_GROUP`
+--
+
+DROP TABLE IF EXISTS `USER_GROUP`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `USER_GROUP` (
+ `GROUP_ID` varchar(255) NOT NULL,
+ `DOMAIN_ID` varchar(255) NOT NULL,
+ `NAME` varchar(255) NOT NULL,
+ `DESCRIPTION` varchar(255) DEFAULT NULL,
+ `OWNER_ID` varchar(255) NOT NULL,
+ `GROUP_TYPE` varchar(255) NOT NULL,
+ `GROUP_CARDINALITY` varchar(255) NOT NULL,
+ `CREATED_TIME` bigint(20) NOT NULL,
+ `UPDATED_TIME` bigint(20) NOT NULL,
+ PRIMARY KEY (`GROUP_ID`,`DOMAIN_ID`),
+ KEY `OWNER_ID` (`OWNER_ID`,`DOMAIN_ID`),
+ CONSTRAINT `user_group_ibfk_1` FOREIGN KEY (`OWNER_ID`, `DOMAIN_ID`)
REFERENCES `SHARING_USER` (`USER_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE
NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `USER_GROUP`
+--
+
+LOCK TABLES `USER_GROUP` WRITE;
+/*!40000 ALTER TABLE `USER_GROUP` DISABLE KEYS */;
+INSERT INTO `USER_GROUP` VALUES
('Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','default','Admin
Users','Admin users
group.','default-admin@default','DOMAIN_LEVEL_GROUP','MULTI_USER',1551138405064,1551138405064),('default-admin@default','default','dim
Upe','user dim Upe
group','default-admin@default','USER_LEVEL_GROUP','SINGLE_USER',0,1551138404890),('Gateway_Users_2e4e6eb4-05ad-4a0f-92d1-02aa26c56004','default','Gateway
Users','Default group for users of the gateway.','default-admin [...]
+/*!40000 ALTER TABLE `USER_GROUP` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `workflow_catalog`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `workflow_catalog` /*!40100 DEFAULT
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
+
+USE `workflow_catalog`;
+
+--
+-- Current Database: `app_catalog`
+--
+
+USE `app_catalog`;
+
+--
+-- Current Database: `credential_store`
+--
+
+USE `credential_store`;
+
+--
+-- Current Database: `experiment_catalog`
+--
+
+USE `experiment_catalog`;
+
+--
+-- Final view structure for view `experiment_summary`
+--
+
+/*!50001 DROP VIEW IF EXISTS `experiment_summary`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8mb4 */;
+/*!50001 SET character_set_results = utf8mb4 */;
+/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
+/*!50001 VIEW `experiment_summary` AS select `E`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`E`.`PROJECT_ID` AS `PROJECT_ID`,`E`.`GATEWAY_ID` AS
`GATEWAY_ID`,`E`.`USER_NAME` AS `USER_NAME`,`E`.`EXECUTION_ID` AS
`EXECUTION_ID`,`E`.`EXPERIMENT_NAME` AS `EXPERIMENT_NAME`,`E`.`CREATION_TIME`
AS `CREATION_TIME`,`E`.`DESCRIPTION` AS `DESCRIPTION`,`es`.`STATE` AS
`STATE`,`UD`.`RESOURCE_HOST_ID` AS
`RESOURCE_HOST_ID`,`es`.`TIME_OF_STATE_CHANGE` AS `TIME_OF_STATE_CHANGE` from
((`experiment` `E` left join [...]
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
+-- Final view structure for view `latest_experiment_status`
+--
+
+/*!50001 DROP VIEW IF EXISTS `latest_experiment_status`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8mb4 */;
+/*!50001 SET character_set_results = utf8mb4 */;
+/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
+/*!50001 VIEW `latest_experiment_status` AS select `ES1`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`ES1`.`STATE` AS `STATE`,`ES1`.`TIME_OF_STATE_CHANGE` AS
`TIME_OF_STATE_CHANGE` from (`experiment_status` `ES1` left join
`experiment_status` `ES2` on(((`ES1`.`EXPERIMENT_ID` = `ES2`.`EXPERIMENT_ID`)
and (`ES1`.`TIME_OF_STATE_CHANGE` < `ES2`.`TIME_OF_STATE_CHANGE`)))) where
isnull(`ES2`.`TIME_OF_STATE_CHANGE`) */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
+-- Current Database: `profile_service`
+--
+
+USE `profile_service`;
+
+--
+-- Current Database: `replica_catalog`
+--
+
+USE `replica_catalog`;
+
+--
+-- Current Database: `sharing_catalog`
+--
+
+USE `sharing_catalog`;
+
+--
+-- Current Database: `workflow_catalog`
+--
+
+USE `workflow_catalog`;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2019-03-11 19:13:25
