text: -- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)
  --
  -- Host: app-db    Database: testmite
  -- ------------------------------------------------------
  -- Server version	5.7.24
  
  /*!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 */;
  
  --
  -- Create the database `testmite`
  --
  
  CREATE DATABASE testmite;
  USE testmite;
  
  --
  -- Table structure for table `results`
  --
  
  DROP TABLE IF EXISTS `results`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `results` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `test_definition_id` int(11) DEFAULT NULL,
    `run_id` int(11) DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `value` int(11) DEFAULT NULL,
    `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `output` text COLLATE utf8_unicode_ci,
    `started_at` datetime DEFAULT NULL,
    `finished_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `index_results_on_parent_id` (`parent_id`),
    KEY `index_results_on_run_id` (`run_id`),
    KEY `index_results_on_run_id_and_test_definition_id` (`run_id`,`test_definition_id`),
    KEY `index_results_on_test_definition_id` (`test_definition_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=18595903 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `runs`
  --
  
  DROP TABLE IF EXISTS `runs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `runs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `world_id` int(11) DEFAULT NULL,
    `owner` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `hive_job_id` int(11) DEFAULT NULL,
    `target` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `started_at` datetime DEFAULT NULL,
    `finished_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `index_runs_on_world_id` (`world_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=411184 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `schema_migrations`
  --
  
  DROP TABLE IF EXISTS `schema_migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `schema_migrations` (
    `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    UNIQUE KEY `unique_schema_migrations` (`version`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `suites`
  --
  
  DROP TABLE IF EXISTS `suites`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `suites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `project` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `runner` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `documentation` text COLLATE utf8_unicode_ci,
    `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `repo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `index_suites_on_project_and_name` (`project`,`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `taggings`
  --
  
  DROP TABLE IF EXISTS `taggings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `taggings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `tag_id` int(11) DEFAULT NULL,
    `taggable_id` int(11) DEFAULT NULL,
    `taggable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `tagger_id` int(11) DEFAULT NULL,
    `tagger_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `context` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `taggings_idx` (`tag_id`,`taggable_id`,`taggable_type`,`context`,`tagger_id`,`tagger_type`),
    KEY `index_taggings_on_taggable_id_and_taggable_type_and_context` (`taggable_id`,`taggable_type`,`context`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2018927 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `tags`
  --
  
  DROP TABLE IF EXISTS `tags`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `taggings_count` int(11) DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `index_tags_on_name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=196 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `test_definitions`
  --
  
  DROP TABLE IF EXISTS `test_definitions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `test_definitions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `node_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `line` int(11) DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `suite_id` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `lookup` (`name`,`suite_id`,`file`,`parent_id`),
    KEY `index_test_definitions_on_suite_id` (`suite_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=28045 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `worlds`
  --
  
  DROP TABLE IF EXISTS `worlds`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `worlds` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `project` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `component` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `index_worlds_on_project_and_component` (`project`,`component`),
    KEY `index_worlds_on_project_and_component_and_version` (`project`,`component`,`version`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19839 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!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 2018-11-29 11:21:43
  