text: -- 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,
    `METADATA` varchar(4096) 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, NULL),('Echo_661f23c7-eca7-49ba-987b-55f4202b60bb','Echo-Standard-Out','','STDOUT',1,0,0,NULL,'','',0, NULL);
  /*!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','',22222,'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',0x149D247A85EEF670D6919C6F2367E979799D210452590F82AE36956A6C3E303D4BAF4BCC5D3CAE6FC169132BDAF79C5B2D96C37105B1F2565A65B44494051300D51F1A6EE17BDA9E1097D3D95631D60ED2223ECE5C6F6FB518F578F6FE2C6A81BF1E971F58A2CA37933A857133B6BCEE12BE13D9D3A74334C2D5101C69E5279EE6C70623FFB80AC49611E37BC02A6ABC8287814E24D872BC2198D257730526415B65FE1097BC805145242B6113AF55EDD71F855F8D915E40C6FEC204E289BEAF2E24C95DD7E6B79AA90B3871AA9E80EDEA5F1E45BF899F94FFB14B404A300ECB7859D3A595FB7E0DE91645C6602CBDE8F5038A198B5F54ECC1592BBF50D1FEB4AE8AE220601FD22C5138F50DCCEBFD3FFEE64F4FCD2D85BFE055A35449E1926563BB6E2B8FC21E5137DF7F5E312BA7AE15CA4C8F58C3B782B7F4D65BDBDD6A2A4753FB5DEB02AF9C4EDC01A505FCA7F2DA38043024F0430FBBDD51CABE67F062969B419A5522FA9A36AB3D9E9A7B95C2A2BE44113044E574B01A00BF71D2E0C52D26C47AB6ED68A05686BECA2543615F267A74BD85DD240EB554DF4DEED2AA5B1CDCB264EE2F7810177576D47218FF721227C199CCE853F089BAF1AD908E6079A45A27AF53BD8AE4AFC45B6D97174E6985F6BCB1ECB324E5A09A3DB8A60EE401244B023ABAE3DA2DF553C7A286D01B7A9A632A4D11DDB27B9A506C8A1F3C65D5BDCBF270D8797401B34766A93A38B332DC91FA589D48098848E0A337374F6891470F1CBF50C34F53C2A984E908D7510353157DB914AA61246824C61223AF5DEDC4768DF5B110609D0D968F5C632952F854B95CF353F1F64214F6DE68FD08BA1A3C155C2A6DF09FCF2AED839B199F281BB117769ED57D4E34D304FAD2D779F4E98C573FA8850A28CF173709C694B38AEFC1165B3DB2F9DBECD7C97AFA302E5FCA30D74F6EB69ADA6C064D534D1C7F2A83AE1B6827AB6FE52848E70C057854FAC6B0651B1B57296505C4F43C1DCB9EC17F34EB36563829D9D74B720072F2258F65C67D5101521E8D150F9E2AC3FD731376830241B5FC637D326A4D2B5EBA218FCA40329A88717CBF7E9835FB13D2E710D8D4A69012541256C61CB61988368251D22EA443386010EFA40D77908EDE66970FC8D2EBF45111316AE6FB60C40619CAFD310F9D32B2A99FB62299D5A27F8E9919EE3A0A804940AA8D6D637BA857BE9CD56E7C07472317133A68B1E9E88D32C519547E60D5966D496D6D73CD2BDD8AD2F216A6D0817B86D8A2D45F56A51B6B0C05DA557BD186990F16E5F6863AA748195089665BB203F426C24A002B36B34659CB0AD044F51F778EFFECFDF01098C0CE99C4BC54942C962A6C1F3D1E2B5A5BCCB5A143CFEDD01D3C32E0AF08D99BB03485BDFB49465BE93D8A0507E21E52739863C958E752F7C892009BF4811532180630968718E1577B5BA4055B5CEB9FC55FE0F9DCF1598A8F7C6ACD13F8D3BDC13355B4D91F5C7CCA4C5EEC10EE974AEB0AC5E953763C64167AFC7A959B29F64BA1FAFF4FD119B5A526293A54F39C43772E7630FA3AD15D2C8A79ACF2BEE33A99F5EB5D3ACB3A9D7E8B0E013F3002D461356837C1BB2EE7C58E65EAD76A4D40CBFBA50D82CAD529AE5ACBE7256C32D565D4279299B6C0A12D81E584A8ED241163E35D8E5367920878BE6F86EDD469E54BA20AE4E09B5671396837E9CE58BC269A67AD7EFD85500421E21C5E6C7F60FE055CA6354CC3DCFC48A97183925BB994FA7307A037FC145FAE39F50C01714B2EBD5A996E88B8C92016AC1C84A8287AE55C792B377C2ABA76D1234FFA98AA1505E3C9B263C21C39E6F9A72E7CC41A74DD33CA7BBB83348665304E8022AA9A8365FE1315B314AB5500AF918629B05338FF5743BD2B2264AF5EF54BDF565209619A795D17B9AEE6F3D59B593E979013D122BECD00A97E440DFBD0F745CA2BFDE130E1A47DEC322518BE14AC38326898E418684086397B603279EF85D95142DEBCECF5E2EF51E2564E1B8C80ACBC825D7085354E6087A1F8A1559B1BAAAC720782F4B7E95604435E48C059D3822ED0AB522AEF0380DBB4552C83571D3D8FC015C4321AB7189FC37BB2D3551D4CF143EB0B92BE96FF8D9A47385A4F6DD095260F7C4DD697D42D19F51537ACBA6DE73836FA984B3764DD0F8DB3607BB4171CD2E9FC36D2307858A1735C6EE5E957EF92CC381F103C27A41F40CA6ACCC16D4D65308B91EF27C733B0A35DA553F1CE20E458A4328A3B1420D1B22A0E51907F2AD2569821B8AC196019AB3712779039051C1C8AC103894E69616C9535DC9BEE08B0A624A8F2A2CF5637A2609D67339458F34BBA9990092480025C75DE074FBBA485FB05B49DD17A64E8AA595DBFA47DEB0F6674A870656A90339B9DAD269CAC63CDAF4FFB4C5FB8387494CF1EE4A50821260538227E475D00E92DB62A5A70148692D2075B8F159999D7C6FDE20E8384FF82D09CD9485B39C1320093B4DA49123A0673D27AAD7FB64731B0E3F64E1149268F731F13EF57A1567161C4978285244E8DB4B063A95A34685DF843514B1B75F577606CE48F6D23352CA966C6545F7F78DD51124FA8B11C0A21BF97E7DF904752C8D251408A1E924A593447FE6CA96D95E2436068C36836B2A2AFDFF5C4826BDBE95661031DDAA5A19BD50B4CFAD6095D07E960C74EB86420B4F66F274DD1E11053B0D44ABA2AADC7018A0B3603CFDCC43AAAC42E35FA344D4CC6A233470775B944B62EEF5570DBC141BBB5B4D2C0FB70C9BC4FFD951338FA7D9C43735734BBB06B3A1C7D305EF2012D2718AE6AF9961015D27FD4FCFFD16845ABEC781A8D96A85588E5C1AA60EA6F3A241D39376E85D9B6A42E0F1E701E246A8EDEDB504500E00880992CCC88B158624C50BD1FCE1ED91EF2AE073EDA118135D9FABC26FC9581BE3F29E251579A40935BA5C40E424F737163AA2125D70DE593C8570E9D22BDFD9F7265A0CDD6A60A252F7FCD6F4685380ECC1715092A49FBC783FDC2DDA5A87195FC47CC3B24633DCDDC0D0E1E0304F8124A6D1C402E4DDE5307B405D040E00AC25DA7C85C2044DB2FE5A6F5E76709AD9824AFD4FA2A73D45E640FB263A21C16A4FCB9547071A48AE17C59C44ADDCFF7E3CF71CF1C6EDA6A3C51A89A4F33017834615969F469697DABB82B71D30F6FC1915BD4F9323BBEC3C21C68B5196CB4F79AF3FB4E03A10B4E03D47B9EFF02895707C5849ED13721AD99E723A7C57CDF20D046A7D693353A4EEBDC827C8464E9CADF664B8AED89E358F007CB16210653D60AB59A099FFA4AD76C08A10A771326F0E9D0C6E222A28527C3A2820477410BEB192EAC1BC34E5B443C476B1E6A717D57050B1E65D1CF5DABC8A811BF3D6EC73B67898F68795734FFC53D7B31DA2766BB369546E4DAACAE56CA70452132BE57BF7579B3911B7036F74E0930583D24CA805ADD23E02544300441F28784DE57C059290625F8265446F61F5C6D1458C260016895535B237C3EED76D6D613DD21D34B0561087061859F2C354BBFCB3E541F38946974D9243BDFF5524E5FE0EE9B86DC2F53249B5E157E9AC1190B296A860CDF9EC3832FAA6C48F5C00EFE338B432A5BCD5AF05AD35FDFA68B24352171D8C8368F6B0BA736308ED1C5417C3C81E501B67145E5EF0B7D40C31DFFB03822835E4E9226C5A508ABF7ACC27AB4CC8CBFC2334CFA742D320067706409D706520A04CF895FB582DF8053B0791D45F27D61C610AC99DC2CB08A1583976AF56C0E54E356B7EA7D0042DEB45285E72744C80AFBC08555AF1EF611EA7D6F1FE4BA5212EB7280E024CD677E52B60D2DE616D16E6616F0390A6C119AD4CE9298903D46C01E9E647B926072E2FFAD0801ED736DB4C54381E5642FC900F6F0A11EDCA22127E1F998C7A982296008B70A18E0F8327EFD1C8DA2CB7644408A91BE73608C08E6063B3588A36DEDCB6BD69AC3FD3DAE836B0AF192CB4E929607F4E1D349EAC6DA18FE943E5B76965E7634577877461B5D6A346FEE3E7CFF76DB,'default-admin','2019-02-25 19:06:48','Default','GATEWAY'),('default','daf89639-bf92-4161-9c54-34571372d092',0xFB5ECB6FB5AD8335BBB104326FC122571FA73D2CFFC26DD33D56952581215ED1A5DA2623FB4481BE5A1323E3DEAA58CF88F5B63C24D2FEE338A008E8DAB3A5F8ED478901C3517571E259B379E3B2DC5470F66819EBF7A71B652E8BDA2B75E17B225C5263EB0E53CA7057B8CD3BE3B33CCA0ACCCF3DAF4043E546BFFF8D61CEC3069DA041A5B0F2076581F7E98EDD81C4787D7B3F6F4AAB16AB36BBA8FC012B0F68E08FD41DBB724282883AE20616BF9209589ADAA9693DC5737654BC3D77C86AF4A6C66AF7DA4577F71D3F93BAF3B16BC57F559A1CE90585D35D2DC213EB07B16482F612EE1C63A070133C0B83FC7FF090358D9671585F627EC31C64C989C05328AA5867ED9C7D58531EC4244456353C4E616690D5639C9C4856896C817058C1DEEF08BF98ABF44D65D3791F616EE535C57F5DBE06E43BAEA45A470E13FE98F5DA2A98D0C14A07496696ABE51816CA1843B004B6D550D24CAE0E5E3A69ADBA8A93DB05951E9B9617CC8DB1D21043BAFCD3A4AA81DD7002456E6EFC83DFA3811EB894CA7D0D28BE5DDD8C62BA7FDC876BBE81BFE3D2A5E4D7D26C0F1598523EF6D00100C9551BF226471762FBDD39C76200BB8541A14518BB4F3C5C82DD570189646E140D469D3BA24180640E8F88A27EC7FCB1DF951A2486E9990448E18932EF75C95817797B7D4D93FA94E04E25EE0A0DBAADA3600A36A3A523B0DFC64B879BE386D0F1F0113DE64A1F6777CF1651269FDA5EB48E9095254672D1FC7F288CCE757CF7FA5BBAD39FF4E967866F3E1CCE6D51E0476F516605F8057F5482D12ED0AD9E280B1CF4EC2B66ED7F36ED4B2651F44C5F4101184F73FC6FAC2A24FA975D1E15FC92B2FEA2FA668A09F3D1865EA13C0A6DF37725A3F1D823B5AC0863EEE936D9EF593CA0EF48DA33DB12B0B8515B8619C1DA7900ABC9D8015A77C6D54F6629B233443182335C1B9BB6565CDCFBD986FA30569C6B183BB17E45221A2112AC6E399DF072A51A6C6F850ADD62EB22B954D1F5EDC213334D06E7C4DEA20384B2D001DFFBB1DBCF25452BAEE4962750F511380F7458BC5E825EC0CF483ACC6216067B5A7037C948D0F5DE35A5AD3A1C5CB3D0B1354D6FE9B7AEE6F54F265485470280E185A554D5CFE382BD88D3A9C9ED6CF0E2038C9402457111CB0E943BF39E1019FB7A20AB6042541D71714AAC5E10,'default-admin','2019-02-25 18:40:12','Credentials for default gateway','GATEWAY');
  /*!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,
    `METADATA` varchar(4096) 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,
    `METADATA` varchar(4096) 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;
  
  DROP TABLE IF EXISTS `PROCESS_WORKFLOW`;
  CREATE TABLE PROCESS_WORKFLOW
  (
    `PROCESS_ID` varchar(255) NOT NULL,
    `WORKFLOW_ID` varchar(255) NOT NULL,
    `TYPE` varchar(255) DEFAULT NULL,
    `CREATION_TIME` timestamp DEFAULT NOW(),
    PRIMARY KEY (`PROCESS_ID`, `WORKFLOW_ID`),
    FOREIGN KEY (`PROCESS_ID`) REFERENCES PROCESS(`PROCESS_ID`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  LOCK TABLES `PROCESS_WORKFLOW` WRITE;
  /*!40000 ALTER TABLE `PROCESS_WORKFLOW` DISABLE KEYS */;
  /*!40000 ALTER TABLE `PROCESS_WORKFLOW` 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','dimuthu.upeksha2@gmail.com');
  /*!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_9182a6b7-520d-4a8d-92e1-24463aae530b','default','default:EXPERIMENT','default-admin@default',NULL,'Clone of Clone of Echo on Mar 11, 2019 12:24 PM',NULL,NULL,NULL,3,1552323107891,1552323107891,1552323107891),('Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79','default','default:EXPERIMENT','default-admin@default',NULL,'Clone of Echo on Mar 11, 2019 12:02 PM',NULL,NULL,NULL,3,1552320576004,1552320576004,1552320576004),('Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd','default','default:EXPERIMENT','default-admin@default',NULL,'Clone of Echo on Mar 11, 2019 12:24 PM',NULL,NULL,NULL,3,1552322784306,1552322784306,1552322784306),('Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','default','default:PROJECT','default-admin@default',NULL,'Default Project','This is the default project for user default-admin',NULL,NULL,2,1551138405526,1551138405526,1551138405526),('echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','echo2',' ',NULL,NULL,5,1551200818680,1551200818680,1551200818680),('Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo2',' ',NULL,NULL,5,1551195758420,1551195758420,1551195758420),('Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo on Mar 11, 2019 11:47 AM',NULL,NULL,NULL,3,1552319249121,1552319249121,1552319249121),('Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo on Mar 11, 2019 11:59 AM',NULL,NULL,NULL,3,1552319973634,1552319973634,1552319973634),('Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo on Mar 11, 2019 12:02 PM',NULL,NULL,NULL,3,1552320158357,1552320158357,1552320158357),('Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo on Mar 11, 2019 12:11 PM',NULL,NULL,NULL,3,1552320714168,1552320714168,1552320714168),('Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','default:EXPERIMENT','default-admin@default','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','Echo on Mar 11, 2019 12:24 PM',NULL,NULL,NULL,3,1552321490571,1552321490571,1552321490571),('js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','default','default:APPLICATION_DEPLOYMENT','default-admin@default',NULL,'js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','',NULL,NULL,3,1551195720578,1551195720578,1551195720578);
  /*!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_RESOURCE_PROFILE','default','GROUP_RESOURCE_PROFILE','Group Resource Profile entity type',1551138011716,1551138011716),('default:PROJECT','default','PROJECT','Project entity type',1551138011665,1551138011665);
  /*!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),('default:MANAGE_SHARING','default','MANAGE_SHARING','Sharing permission type',1551138011853,1551138011853);
  /*!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','default','default-admin@default','DIRECT_CASCADING','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b',1552323107903,1552323107903),('default:OWNER','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79','default','default-admin@default','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79',1552320576016,1552320576016),('default:OWNER','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd','default','default-admin@default','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd',1552322784315,1552322784315),('default:OWNER','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','default','default-admin@default','DIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551138405554,1551138405554),('default:OWNER','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551200818759,1551200818759),('default:OWNER','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200818705,1551200818705),('default:OWNER','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551195758468,1551195758468),('default:OWNER','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195758430,1551195758430),('default:OWNER','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319249178,1552319249178),('default:OWNER','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','default-admin@default','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9',1552319249136,1552319249136),('default:OWNER','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319973685,1552319973685),('default:OWNER','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','default-admin@default','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f',1552319973651,1552319973651),('default:OWNER','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320158415,1552320158415),('default:OWNER','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','default-admin@default','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e',1552320158375,1552320158375),('default:OWNER','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320714215,1552320714215),('default:OWNER','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','default-admin@default','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1',1552320714184,1552320714184),('default:OWNER','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552321490609,1552321490609),('default:OWNER','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','default-admin@default','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387',1552321490586,1552321490586),('default:OWNER','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','default','default-admin@default','DIRECT_CASCADING','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84',1551195720607,1551195720607),('default:READ','af03c63d-a40e-4ed1-aee0-759a6ed0202c','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','af03c63d-a40e-4ed1-aee0-759a6ed0202c',1552318872021,1552318872021),('default:READ','af03c63d-a40e-4ed1-aee0-759a6ed0202c','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','af03c63d-a40e-4ed1-aee0-759a6ed0202c',1552318872021,1552318872021),('default:READ','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b',1552323107949,1552323107949),('default:READ','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b',1552323107949,1552323107949),('default:READ','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79',1552320576060,1552320576060),('default:READ','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79',1552320576060,1552320576060),('default:READ','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd',1552322784367,1552322784367),('default:READ','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd',1552322784367,1552322784367),('default:READ','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','default','default-admin@default','DIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551138406052,1551138406052),('default:READ','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200818860,1551200818860),('default:READ','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551200818736,1551200818736),('default:READ','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200819351,1551200819351),('default:READ','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200818860,1551200818860),('default:READ','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195758537,1551195758537),('default:READ','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551195758452,1551195758452),('default:READ','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195759028,1551195759028),('default:READ','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195758537,1551195758537),('default:READ','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9',1552319249231,1552319249231),('default:READ','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319249161,1552319249161),('default:READ','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9',1552319249231,1552319249231),('default:READ','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f',1552319973762,1552319973762),('default:READ','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319973669,1552319973669),('default:READ','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f',1552319973762,1552319973762),('default:READ','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e',1552320158500,1552320158500),('default:READ','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320158395,1552320158395),('default:READ','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e',1552320158500,1552320158500),('default:READ','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1',1552320714263,1552320714263),('default:READ','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320714198,1552320714198),('default:READ','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1',1552320714263,1552320714263),('default:READ','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387',1552321490657,1552321490657),('default:READ','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552321490595,1552321490595),('default:READ','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387',1552321490657,1552321490657),('default:READ','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84',1551195720704,1551195720704),('default:READ','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','default','Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','DIRECT_CASCADING','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84',1551195720704,1551195720704),('default:WRITE','af03c63d-a40e-4ed1-aee0-759a6ed0202c','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','af03c63d-a40e-4ed1-aee0-759a6ed0202c',1552318871972,1552318871972),('default:WRITE','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Clone_of_Echo_on_Mar_11,_2019_12:24_PM_9182a6b7-520d-4a8d-92e1-24463aae530b',1552323107921,1552323107921),('default:WRITE','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:02_PM_32bd2154-9dd1-46c4-87c1-cd3925174f79',1552320576035,1552320576035),('default:WRITE','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Clone_of_Echo_on_Mar_11,_2019_12:24_PM_96170feb-9202-458f-8494-5fea6e5598dd',1552322784331,1552322784331),('default:WRITE','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc','default','default-admin@default','DIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551138405837,1551138405837),('default:WRITE','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200818802,1551200818802),('default:WRITE','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551200818748,1551200818748),('default:WRITE','echo2_190926b0-f389-4394-864e-0b2f0782692c','default','default-admin@default','DIRECT_CASCADING','echo2_190926b0-f389-4394-864e-0b2f0782692c',1551200819185,1551200819185),('default:WRITE','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195758494,1551195758494),('default:WRITE','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1551195758461,1551195758461),('default:WRITE','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32','default','default-admin@default','DIRECT_CASCADING','Echo2_56e5b34d-5ce1-47db-9723-29244d41da32',1551195758871,1551195758871),('default:WRITE','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9',1552319249200,1552319249200),('default:WRITE','Echo_on_Mar_11,_2019_11:47_AM_40ff0d5e-5053-43f7-8f80-faa53f623ca9','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319249169,1552319249169),('default:WRITE','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f',1552319973716,1552319973716),('default:WRITE','Echo_on_Mar_11,_2019_11:59_AM_d17b5f17-f9d3-442a-82d2-b386c3a9eb6f','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552319973676,1552319973676),('default:WRITE','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e',1552320158451,1552320158451),('default:WRITE','Echo_on_Mar_11,_2019_12:02_PM_d7d67775-e7f6-4255-9c05-764b29ac9e3e','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320158405,1552320158405),('default:WRITE','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1',1552320714233,1552320714233),('default:WRITE','Echo_on_Mar_11,_2019_12:11_PM_f2576ab2-c3af-47e9-8fe2-099802ba25c1','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552320714207,1552320714207),('default:WRITE','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387',1552321490625,1552321490625),('default:WRITE','Echo_on_Mar_11,_2019_12:24_PM_e78780cb-35a5-467b-baea-e9df5f498387','default','default-admin@default','INDIRECT_CASCADING','Default_Project_93d9a30a-4299-44dd-9e48-a7b8961464dc',1552321490602,1552321490602),('default:WRITE','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84','default','Admin_Users_ba3e4af7-9b1d-4f46-b43a-2b44790f6868','DIRECT_CASCADING','js-156-93.jetstream-cloud.org_Echo_88202f35-beef-414a-84a4-6ee9dd4f5a84',1551195720648,1551195720648);
  /*!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,'dimuthu.upeksha2@gmail.com',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@default','DOMAIN_LEVEL_GROUP','MULTI_USER',1551138405011,1551138405011),('Read_Only_Admin_Users_68f97cb6-9d9a-4a41-a15e-1db24ec087b3','default','Read Only Admin Users','Group of admin users with read-only access.','default-admin@default','DOMAIN_LEVEL_GROUP','MULTI_USER',1551138405099,1551138405099);
  /*!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 `latest_experiment_status` `es` on((`E`.`EXPERIMENT_ID` = `es`.`EXPERIMENT_ID`))) left join `USER_CONFIGURATION_DATA` `UD` on((`E`.`EXPERIMENT_ID` = `UD`.`EXPERIMENT_ID`))) where 1 */;
  /*!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
  