huginn-database-schema-dump.txt

-- MySQL dump 10.13  Distrib 5.5.62, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: huginn_production
-- ------------------------------------------------------
-- Server version	5.5.62-0ubuntu0.14.04.1

/*!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: `huginn_production`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `huginn_production` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `huginn_production`;

--
-- Table structure for table `agent_logs`
--

DROP TABLE IF EXISTS `agent_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent_id` int(11) NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `level` int(11) NOT NULL DEFAULT '3',
  `inbound_event_id` int(11) DEFAULT NULL,
  `outbound_event_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent_logs`
--

LOCK TABLES `agent_logs` WRITE;
/*!40000 ALTER TABLE `agent_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `agent_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agents`
--

DROP TABLE IF EXISTS `agents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `type` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `schedule` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `events_count` int(11) NOT NULL DEFAULT '0',
  `last_check_at` datetime DEFAULT NULL,
  `last_receive_at` datetime DEFAULT NULL,
  `last_checked_event_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `memory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `last_web_request_at` datetime DEFAULT NULL,
  `keep_events_for` int(11) NOT NULL DEFAULT '0',
  `last_event_at` datetime DEFAULT NULL,
  `last_error_log_at` datetime DEFAULT NULL,
  `propagate_immediately` tinyint(1) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  `service_id` int(11) DEFAULT NULL,
  `guid` varchar(191) CHARACTER SET utf8mb4 NOT NULL,
  `deactivated` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `index_agents_on_user_id_and_created_at` (`user_id`,`created_at`),
  KEY `index_agents_on_type` (`type`),
  KEY `index_agents_on_schedule` (`schedule`),
  KEY `index_agents_on_guid` (`guid`),
  KEY `index_agents_on_disabled_and_deactivated` (`disabled`,`deactivated`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agents`
--

LOCK TABLES `agents` WRITE;
/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
INSERT INTO `agents` VALUES (1,1,'{\"expected_receive_period_in_days\":\"2\",\"rules\":[{\"type\":\"regex\",\"value\":\"rain|storm\",\"path\":\"conditions\"}],\"message\":\"Just so you know, it looks like \'{{conditions}}\' tomorrow in {{location}}\"}','Agents::TriggerAgent','Rain Notifier',NULL,0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'361ee2e955d4726b52c8b044d4f75e25',0),(2,1,'{\"url\":\"https://xkcd.com\",\"mode\":\"on_change\",\"expected_update_period_in_days\":5,\"extract\":{\"url\":{\"css\":\"#comic img\",\"value\":\"@src\"},\"title\":{\"css\":\"#comic img\",\"value\":\"@alt\"},\"hovertext\":{\"css\":\"#comic img\",\"value\":\"@title\"}}}','Agents::WebsiteAgent','XKCD Source','every_1d',0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'505c9bba65507c40e5786afff36f688c',0),(3,1,'{\"subject\":\"Your Afternoon Digest\",\"expected_receive_period_in_days\":\"7\"}','Agents::EmailDigestAgent','Afternoon Digest','5pm',0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'65e8ae4533881537de3c346b5178b75d',0),(4,1,'{\"subject\":\"Your Morning Digest\",\"expected_receive_period_in_days\":\"30\"}','Agents::EmailDigestAgent','Morning Digest','6am',0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'b34eaee75d8dc67843c3bd257c213852',0),(5,1,'{\"location\":\"94103\",\"api_key\":\"put-your-key-here\"}','Agents::WeatherAgent','SF Weather Agent','10pm',0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'bdae6dfdf9d01a123ddd513e695fd466',0),(6,1,'{\"url\":\"https://trailers.apple.com/trailers/home/rss/newtrailers.rss\",\"mode\":\"on_change\",\"type\":\"xml\",\"expected_update_period_in_days\":5,\"extract\":{\"title\":{\"css\":\"item title\",\"value\":\"string(.)\"},\"url\":{\"css\":\"item link\",\"value\":\"string(.)\"}}}','Agents::WebsiteAgent','iTunes Trailer Source','every_1d',0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,0,NULL,NULL,0,0,NULL,'e9afa65457d0a736b9ec20a8dd452fc8',0),(7,1,'{\"instructions\":{\"message\":\"<h2>{{title}}</h2><img src=\\\"https:{{url}}\\\"/> <p>{{hovertext}}</p>\"},\"matchers\":[],\"mode\":\"clean\"}','Agents::EventFormattingAgent','Comic Formatter',NULL,0,NULL,NULL,NULL,'2019-04-06 04:01:17','2019-04-06 04:01:17',NULL,NULL,2592000,NULL,NULL,0,0,NULL,'d86b069650edadfc61db9df767c8b65c',0);
/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ar_internal_metadata`
--

DROP TABLE IF EXISTS `ar_internal_metadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ar_internal_metadata` (
  `key` varchar(191) CHARACTER SET utf8 NOT NULL,
  `value` varchar(191) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ar_internal_metadata`
--

LOCK TABLES `ar_internal_metadata` WRITE;
/*!40000 ALTER TABLE `ar_internal_metadata` DISABLE KEYS */;
INSERT INTO `ar_internal_metadata` VALUES ('environment','production','2019-04-06 04:01:15','2019-04-06 04:01:15');
/*!40000 ALTER TABLE `ar_internal_metadata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `control_links`
--

DROP TABLE IF EXISTS `control_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `control_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `controller_id` int(11) NOT NULL,
  `control_target_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_control_links_on_controller_id_and_control_target_id` (`controller_id`,`control_target_id`),
  KEY `index_control_links_on_control_target_id` (`control_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `control_links`
--

LOCK TABLES `control_links` WRITE;
/*!40000 ALTER TABLE `control_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `control_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delayed_jobs`
--

DROP TABLE IF EXISTS `delayed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delayed_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `priority` int(11) DEFAULT '0',
  `attempts` int(11) DEFAULT '0',
  `handler` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `last_error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `run_at` datetime DEFAULT NULL,
  `locked_at` datetime DEFAULT NULL,
  `failed_at` datetime DEFAULT NULL,
  `locked_by` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delayed_jobs_priority` (`priority`,`run_at`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delayed_jobs`
--

LOCK TABLES `delayed_jobs` WRITE;
/*!40000 ALTER TABLE `delayed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `delayed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `lat` decimal(15,10) DEFAULT NULL,
  `lng` decimal(15,10) DEFAULT NULL,
  `payload` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_events_on_user_id_and_created_at` (`user_id`,`created_at`),
  KEY `index_events_on_agent_id_and_created_at` (`agent_id`,`created_at`),
  KEY `index_events_on_expires_at` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `event_id_at_creation` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `index_links_on_source_id_and_receiver_id` (`source_id`,`receiver_id`),
  KEY `index_links_on_receiver_id_and_source_id` (`receiver_id`,`source_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `links`
--

LOCK TABLES `links` WRITE;
/*!40000 ALTER TABLE `links` DISABLE KEYS */;
INSERT INTO `links` VALUES (1,1,4,'2019-04-06 04:01:17','2019-04-06 04:01:17',0),(2,2,7,'2019-04-06 04:01:17','2019-04-06 04:01:17',0),(3,5,1,'2019-04-06 04:01:17','2019-04-06 04:01:17',0),(4,6,3,'2019-04-06 04:01:17','2019-04-06 04:01:17',0),(5,7,3,'2019-04-06 04:01:17','2019-04-06 04:01:17',0);
/*!40000 ALTER TABLE `links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scenario_memberships`
--

DROP TABLE IF EXISTS `scenario_memberships`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scenario_memberships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent_id` int(11) NOT NULL,
  `scenario_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_scenario_memberships_on_agent_id` (`agent_id`),
  KEY `index_scenario_memberships_on_scenario_id` (`scenario_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scenario_memberships`
--

LOCK TABLES `scenario_memberships` WRITE;
/*!40000 ALTER TABLE `scenario_memberships` DISABLE KEYS */;
INSERT INTO `scenario_memberships` VALUES (1,1,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(2,2,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(3,3,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(4,4,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(5,5,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(6,6,1,'2019-04-06 04:01:17','2019-04-06 04:01:17'),(7,7,1,'2019-04-06 04:01:17','2019-04-06 04:01:17');
/*!40000 ALTER TABLE `scenario_memberships` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scenarios`
--

DROP TABLE IF EXISTS `scenarios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scenarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `guid` varchar(191) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `source_url` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag_bg_color` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag_fg_color` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_scenarios_on_user_id_and_guid` (`user_id`,`guid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scenarios`
--

LOCK TABLES `scenarios` WRITE;
/*!40000 ALTER TABLE `scenarios` DISABLE KEYS */;
INSERT INTO `scenarios` VALUES (1,'default-scenario',1,'2019-04-06 04:01:17','2019-04-06 04:01:17','This scenario has a few agents to get you started. Feel free to change them or delete them as you see fit!',0,'ee4299225e6531c401a8bbbce0771ce4',NULL,'#5bc0de','#ffffff',NULL);
/*!40000 ALTER TABLE `scenarios` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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(191) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schema_migrations`
--

LOCK TABLES `schema_migrations` WRITE;
/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
INSERT INTO `schema_migrations` VALUES ('20120728210244'),('20120728215449'),('20120919061122'),('20120919063304'),('20121216025930'),('20121220053905'),('20121222074732'),('20121223203701'),('20121231170705'),('20130107050049'),('20130124050117'),('20130126080736'),('20130509053743'),('20130819160603'),('20131105063248'),('20131222211558'),('20131223032112'),('20131227000021'),('20140121075418'),('20140127164931'),('20140210062747'),('20140213053001'),('20140216201250'),('20140403043556'),('20140408150825'),('20140505201716'),('20140509170420'),('20140509170443'),('20140515211100'),('20140525150040'),('20140525150140'),('20140531232016'),('20140602014917'),('20140603104211'),('20140605032822'),('20140722131220'),('20140723110551'),('20140730005210'),('20140809211540'),('20140811200922'),('20140813110107'),('20140820003139'),('20140901143732'),('20140906030139'),('20150219213604'),('20150507153436'),('20150808115436'),('20160108221620'),('20160224120316'),('20160301113717'),('20160302095413'),('20160307084729'),('20160307085545'),('20160405072512'),('20160419150930'),('20160423163416'),('20160607055850'),('20160807000122'),('20160823151303'),('20161004120214'),('20161007030910'),('20161124061256'),('20161124065838'),('20170307190555'),('20170419073748'),('20170731191002');
/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `provider` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` text NOT NULL,
  `secret` text,
  `refresh_token` text,
  `expires_at` datetime DEFAULT NULL,
  `global` tinyint(1) DEFAULT '0',
  `options` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `uid` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_services_on_user_id_and_global` (`user_id`,`global`),
  KEY `index_services_on_uid` (`uid`),
  KEY `index_services_on_provider` (`provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `services`
--

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_credentials`
--

DROP TABLE IF EXISTS `user_credentials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_credentials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `credential_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `credential_value` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `mode` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'text',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_user_credentials_on_user_id_and_credential_name` (`user_id`,`credential_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_credentials`
--

LOCK TABLES `user_credentials` WRITE;
/*!40000 ALTER TABLE `user_credentials` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_credentials` 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` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `encrypted_password` varchar(191) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  `reset_password_token` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `reset_password_sent_at` datetime DEFAULT NULL,
  `remember_created_at` datetime DEFAULT NULL,
  `sign_in_count` int(11) DEFAULT '0',
  `current_sign_in_at` datetime DEFAULT NULL,
  `last_sign_in_at` datetime DEFAULT NULL,
  `current_sign_in_ip` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_sign_in_ip` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `failed_attempts` int(11) DEFAULT '0',
  `unlock_token` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locked_at` datetime DEFAULT NULL,
  `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invitation_code` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `scenario_count` int(11) NOT NULL DEFAULT '0',
  `confirmation_token` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `confirmation_sent_at` datetime DEFAULT NULL,
  `unconfirmed_email` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deactivated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_users_on_email` (`email`),
  UNIQUE KEY `index_users_on_username` (`username`),
  UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`),
  UNIQUE KEY `index_users_on_unlock_token` (`unlock_token`),
  UNIQUE KEY `index_users_on_confirmation_token` (`confirmation_token`),
  KEY `index_users_on_deactivated_at` (`deactivated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!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 (1,'admin@example.com','$2a$10$c04S2MYhuV2eBA8cWcckqu0lkMwSUSt5ldQ7csCqdhWo4Fbbzy6n6',NULL,NULL,NULL,1,'2019-04-06 04:02:08','2019-04-06 04:02:08','172.17.0.1','172.17.0.1','2019-04-06 04:01:17','2019-04-06 04:02:08',1,0,NULL,NULL,'admin','try-huginn',1,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-04-06  4:12:17