-- MySQL dump 10.16  Distrib 10.1.20-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: localhost
-- ------------------------------------------------------
-- Server version	10.1.20-MariaDB

/*!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 */;

--
-- Table structure for table `alembic_version`
--

DROP TABLE IF EXISTS `alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alembic_version` (
  `version_num` varchar(32) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`version_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `data`
--

DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `key` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `value` longblob,
  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `playbook_id` (`playbook_id`,`key`),
  CONSTRAINT `data_ibfk_1` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `file_contents`
--

DROP TABLE IF EXISTS `file_contents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_contents` (
  `id` varchar(40) COLLATE utf8_bin NOT NULL,
  `content` longblob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `files` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `content_id` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `is_playbook` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `playbook_id` (`playbook_id`,`path`),
  KEY `content_id` (`content_id`),
  CONSTRAINT `files_ibfk_1` FOREIGN KEY (`content_id`) REFERENCES `file_contents` (`id`),
  CONSTRAINT `files_ibfk_2` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `host_facts`
--

DROP TABLE IF EXISTS `host_facts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `host_facts` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `host_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  `values` longtext COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  KEY `host_id` (`host_id`),
  CONSTRAINT `host_facts_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hosts`
--

DROP TABLE IF EXISTS `hosts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hosts` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `playbook_id` (`playbook_id`,`name`),
  KEY `ix_hosts_name` (`name`),
  CONSTRAINT `hosts_ibfk_1` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `playbooks`
--

DROP TABLE IF EXISTS `playbooks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playbooks` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `time_start` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL,
  `complete` tinyint(1) DEFAULT NULL,
  `ansible_version` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `plays`
--

DROP TABLE IF EXISTS `plays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plays` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `name` text COLLATE utf8_bin,
  `sortkey` int(11) DEFAULT NULL,
  `time_start` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `playbook_id` (`playbook_id`),
  CONSTRAINT `plays_ibfk_1` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stats`
--

DROP TABLE IF EXISTS `stats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `host_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `changed` int(11) DEFAULT NULL,
  `failed` int(11) DEFAULT NULL,
  `ok` int(11) DEFAULT NULL,
  `skipped` int(11) DEFAULT NULL,
  `unreachable` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `host_id` (`host_id`),
  KEY `playbook_id` (`playbook_id`),
  CONSTRAINT `stats_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`),
  CONSTRAINT `stats_ibfk_2` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `task_results`
--

DROP TABLE IF EXISTS `task_results`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `task_results` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `task_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `host_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `status` enum('ok','failed','skipped','unreachable') COLLATE utf8_bin DEFAULT NULL,
  `changed` tinyint(1) DEFAULT NULL,
  `failed` tinyint(1) DEFAULT NULL,
  `skipped` tinyint(1) DEFAULT NULL,
  `unreachable` tinyint(1) DEFAULT NULL,
  `ignore_errors` tinyint(1) DEFAULT NULL,
  `result` longblob,
  `time_start` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `host_id` (`host_id`),
  KEY `task_id` (`task_id`),
  CONSTRAINT `task_results_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`),
  CONSTRAINT `task_results_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tasks` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `playbook_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `play_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `name` text COLLATE utf8_bin,
  `sortkey` int(11) DEFAULT NULL,
  `action` text COLLATE utf8_bin,
  `is_handler` tinyint(1) DEFAULT NULL,
  `file_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `lineno` int(11) DEFAULT NULL,
  `time_start` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `play_id` (`play_id`),
  KEY `playbook_id` (`playbook_id`),
  CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`),
  CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`play_id`) REFERENCES `plays` (`id`),
  CONSTRAINT `tasks_ibfk_3` FOREIGN KEY (`playbook_id`) REFERENCES `playbooks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!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 2017-03-14 23:00:02