Created
April 6, 2019 04:15
-
-
Save pauldotknopf/6c9e31fe301cc7e4c97c1a0385787015 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment