| -- 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 |
