Skip to content

Instantly share code, notes, and snippets.

@cmrd-senya
Created April 22, 2016 17:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cmrd-senya/0683ab0c8c024620392a9e525ed5f025 to your computer and use it in GitHub Desktop.
Save cmrd-senya/0683ab0c8c024620392a9e525ed5f025 to your computer and use it in GitHub Desktop.
buggy db dump
-- MySQL dump 10.13 Distrib 5.5.47, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: diaspora_test
-- ------------------------------------------------------
-- Server version 5.5.47-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 */;
--
-- Table structure for table `account_deletions`
--
DROP TABLE IF EXISTS `account_deletions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_deletions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`diaspora_handle` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`completed_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_deletions`
--
LOCK TABLES `account_deletions` WRITE;
/*!40000 ALTER TABLE `account_deletions` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_deletions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `aspect_memberships`
--
DROP TABLE IF EXISTS `aspect_memberships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aspect_memberships` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`aspect_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_aspect_memberships_on_aspect_id_and_contact_id` (`aspect_id`,`contact_id`) USING BTREE,
KEY `index_aspect_memberships_on_aspect_id` (`aspect_id`) USING BTREE,
KEY `index_aspect_memberships_on_contact_id` (`contact_id`) USING BTREE,
CONSTRAINT `aspect_memberships_contact_id_fk` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
CONSTRAINT `aspect_memberships_aspect_id_fk` FOREIGN KEY (`aspect_id`) REFERENCES `aspects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aspect_memberships`
--
LOCK TABLES `aspect_memberships` WRITE;
/*!40000 ALTER TABLE `aspect_memberships` DISABLE KEYS */;
INSERT INTO `aspect_memberships` VALUES (12,12,12,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(13,10,13,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(14,12,14,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(15,11,15,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(16,14,16,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(17,14,17,'2016-04-22 17:28:17','2016-04-22 17:28:17'),(18,16,18,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(19,17,19,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(20,17,20,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(21,16,21,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(22,18,22,'2016-04-22 17:28:18','2016-04-22 17:28:18');
/*!40000 ALTER TABLE `aspect_memberships` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `aspect_visibilities`
--
DROP TABLE IF EXISTS `aspect_visibilities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aspect_visibilities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shareable_id` int(11) NOT NULL,
`aspect_id` int(11) NOT NULL,
`shareable_type` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT 'Post',
PRIMARY KEY (`id`),
KEY `index_aspect_visibilities_on_aspect_id` (`aspect_id`) USING BTREE,
KEY `shareable_and_aspect_id` (`shareable_id`,`shareable_type`(189),`aspect_id`) USING BTREE,
KEY `index_aspect_visibilities_on_shareable_id_and_shareable_type` (`shareable_id`,`shareable_type`(190)) USING BTREE,
CONSTRAINT `aspect_visibilities_aspect_id_fk` FOREIGN KEY (`aspect_id`) REFERENCES `aspects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aspect_visibilities`
--
LOCK TABLES `aspect_visibilities` WRITE;
/*!40000 ALTER TABLE `aspect_visibilities` DISABLE KEYS */;
INSERT INTO `aspect_visibilities` VALUES (5,23,14,'Post'),(6,23,14,'Post'),(7,27,14,'Post'),(8,27,14,'Post');
/*!40000 ALTER TABLE `aspect_visibilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `aspects`
--
DROP TABLE IF EXISTS `aspects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aspects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`contacts_visible` tinyint(1) NOT NULL DEFAULT '1',
`order_id` int(11) DEFAULT NULL,
`chat_enabled` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_aspects_on_user_id_and_contacts_visible` (`user_id`,`contacts_visible`) USING BTREE,
KEY `index_aspects_on_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aspects`
--
LOCK TABLES `aspects` WRITE;
/*!40000 ALTER TABLE `aspects` DISABLE KEYS */;
INSERT INTO `aspects` VALUES (10,'generic',9,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1,0),(11,'generic',10,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1,0),(12,'generic',11,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1,0),(13,'empty',11,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,2,0),(14,'generic',12,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1,0),(15,'generic',13,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1,0),(16,'generic',14,'2016-04-22 17:28:18','2016-04-22 17:28:18',1,1,0),(17,'generic',15,'2016-04-22 17:28:18','2016-04-22 17:28:18',1,1,0),(18,'generic',16,'2016-04-22 17:28:18','2016-04-22 17:28:18',1,1,0);
/*!40000 ALTER TABLE `aspects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `authorizations`
--
DROP TABLE IF EXISTS `authorizations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authorizations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`o_auth_application_id` int(11) DEFAULT NULL,
`refresh_token` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`redirect_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`nonce` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`scopes` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`code_used` tinyint(1) DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_authorizations_on_o_auth_application_id` (`o_auth_application_id`) USING BTREE,
KEY `index_authorizations_on_user_id` (`user_id`) USING BTREE,
CONSTRAINT `fk_rails_4ecef5b8c5` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `fk_rails_e166644de5` FOREIGN KEY (`o_auth_application_id`) REFERENCES `o_auth_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `authorizations`
--
LOCK TABLES `authorizations` WRITE;
/*!40000 ALTER TABLE `authorizations` DISABLE KEYS */;
INSERT INTO `authorizations` VALUES (2,12,2,'417a88be89c8dc67a11fb348918baa2be126bf8c50f17e550f1e53df1a72e27b',NULL,NULL,NULL,'[\"openid\",\"sub\",\"aud\",\"profile\",\"picture\",\"nickname\",\"name\",\"read\",\"write\"]',0,'2016-04-22 17:28:20','2016-04-22 17:28:20');
/*!40000 ALTER TABLE `authorizations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `blocks`
--
DROP TABLE IF EXISTS `blocks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blocks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `blocks`
--
LOCK TABLES `blocks` WRITE;
/*!40000 ALTER TABLE `blocks` DISABLE KEYS */;
INSERT INTO `blocks` VALUES (3,12,28),(4,10,30);
/*!40000 ALTER TABLE `blocks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat_contacts`
--
DROP TABLE IF EXISTS `chat_contacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`jid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`ask` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
`subscription` varchar(128) COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_chat_contacts_on_user_id_and_jid` (`user_id`,`jid`(190)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat_contacts`
--
LOCK TABLES `chat_contacts` WRITE;
/*!40000 ALTER TABLE `chat_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_contacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat_fragments`
--
DROP TABLE IF EXISTS `chat_fragments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_fragments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`root` varchar(256) COLLATE utf8mb4_bin NOT NULL,
`namespace` varchar(256) COLLATE utf8mb4_bin NOT NULL,
`xml` text COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_chat_fragments_on_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat_fragments`
--
LOCK TABLES `chat_fragments` WRITE;
/*!40000 ALTER TABLE `chat_fragments` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_fragments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat_offline_messages`
--
DROP TABLE IF EXISTS `chat_offline_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_offline_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`to` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`message` text COLLATE utf8mb4_bin NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat_offline_messages`
--
LOCK TABLES `chat_offline_messages` WRITE;
/*!40000 ALTER TABLE `chat_offline_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_offline_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `comments`
--
DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8mb4_bin NOT NULL,
`commentable_id` int(11) NOT NULL,
`author_id` int(11) NOT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`author_signature` text COLLATE utf8mb4_bin,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`likes_count` int(11) NOT NULL DEFAULT '0',
`commentable_type` varchar(60) COLLATE utf8mb4_bin NOT NULL DEFAULT 'Post',
PRIMARY KEY (`id`),
UNIQUE KEY `index_comments_on_guid` (`guid`(191)) USING BTREE,
KEY `index_comments_on_person_id` (`author_id`) USING BTREE,
KEY `index_comments_on_commentable_id_and_commentable_type` (`commentable_id`,`commentable_type`) USING BTREE,
CONSTRAINT `comments_author_id_fk` FOREIGN KEY (`author_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `comments`
--
LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
INSERT INTO `comments` VALUES (5,'here are some thoughts on your post',21,30,'87244d00eadd0133edfe00163eb8ca07','zcVORd3zxoEPeufJ3wI+31Nnl3inj0jCYkmfRFkZ1VtIf6P9G8dH2znyWcbLOrxrZq+FFqO3E4rEoWHb4CG4t6cAabaROqvfx6+vl8R18p6QZVBc60WJE1V3OUaBOXYtRgf2GauqQVwUD46ADbcjA+XKysRVIo8B4IOS4ewKDRY=','2016-04-22 17:28:18','2016-04-22 17:28:18',0,'Post'),(6,'1 cats',24,37,'87832730eadd0133edfe00163eb8ca07',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,'Post'),(7,'2 cats',25,40,'879ef890eadd0133edfe00163eb8ca07',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,'Post'),(8,'3 cats',26,43,'87b53e00eadd0133edfe00163eb8ca07',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,'Post');
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contacts`
--
DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sharing` tinyint(1) NOT NULL DEFAULT '0',
`receiving` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_contacts_on_user_id_and_person_id` (`user_id`,`person_id`) USING BTREE,
KEY `index_contacts_on_person_id` (`person_id`) USING BTREE,
CONSTRAINT `contacts_person_id_fk` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contacts`
--
LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
INSERT INTO `contacts` VALUES (12,11,27,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(13,9,29,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(14,11,28,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(15,10,29,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(16,12,31,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(17,13,30,'2016-04-22 17:28:17','2016-04-22 17:28:17',1,1),(18,14,33,'2016-04-22 17:28:18','2016-04-22 17:28:18',1,1),(19,15,32,'2016-04-22 17:28:18','2016-04-22 17:28:18',1,1),(20,15,34,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0),(21,14,34,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0),(22,16,27,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,1);
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `conversation_visibilities`
--
DROP TABLE IF EXISTS `conversation_visibilities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conversation_visibilities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`conversation_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
`unread` int(11) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_conversation_visibilities_usefully` (`conversation_id`,`person_id`) USING BTREE,
KEY `index_conversation_visibilities_on_conversation_id` (`conversation_id`) USING BTREE,
KEY `index_conversation_visibilities_on_person_id` (`person_id`) USING BTREE,
CONSTRAINT `conversation_visibilities_person_id_fk` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`) ON DELETE CASCADE,
CONSTRAINT `conversation_visibilities_conversation_id_fk` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `conversation_visibilities`
--
LOCK TABLES `conversation_visibilities` WRITE;
/*!40000 ALTER TABLE `conversation_visibilities` DISABLE KEYS */;
INSERT INTO `conversation_visibilities` VALUES (11,6,30,0,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(12,6,31,0,'2016-04-22 17:28:18','2016-04-22 17:28:18'),(13,7,31,0,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(14,7,30,0,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(15,8,30,0,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(16,8,31,0,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(17,9,33,0,'2016-04-22 17:28:21','2016-04-22 17:28:21'),(18,9,34,0,'2016-04-22 17:28:21','2016-04-22 17:28:21'),(19,10,34,0,'2016-04-22 17:28:21','2016-04-22 17:28:21'),(20,10,33,0,'2016-04-22 17:28:21','2016-04-22 17:28:21');
/*!40000 ALTER TABLE `conversation_visibilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `conversations`
--
DROP TABLE IF EXISTS `conversations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conversations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`author_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `conversations_author_id_fk` (`author_id`) USING BTREE,
CONSTRAINT `conversations_author_id_fk` FOREIGN KEY (`author_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `conversations`
--
LOCK TABLES `conversations` WRITE;
/*!40000 ALTER TABLE `conversations` DISABLE KEYS */;
INSERT INTO `conversations` VALUES (6,'Subject','873718d0eadd0133edfe00163eb8ca07',30,'2016-04-22 17:28:18','2016-04-22 17:28:19'),(7,'Subject','8839ed90eadd0133edfe00163eb8ca07',31,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(8,'Subject','88448bb0eadd0133edfe00163eb8ca07',30,'2016-04-22 17:28:20','2016-04-22 17:28:20'),(9,'Subject','8880de50eadd0133edfe00163eb8ca07',33,'2016-04-22 17:28:21','2016-04-22 17:28:21'),(10,'Subject','8887e7b0eadd0133edfe00163eb8ca07',34,'2016-04-22 17:28:21','2016-04-22 17:28:21');
/*!40000 ALTER TABLE `conversations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `id_tokens`
--
DROP TABLE IF EXISTS `id_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `id_tokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authorization_id` int(11) DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
`nonce` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_id_tokens_on_authorization_id` (`authorization_id`) USING BTREE,
CONSTRAINT `fk_rails_a461603753` FOREIGN KEY (`authorization_id`) REFERENCES `authorizations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `id_tokens`
--
LOCK TABLES `id_tokens` WRITE;
/*!40000 ALTER TABLE `id_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `id_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invitation_codes`
--
DROP TABLE IF EXISTS `invitation_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invitation_codes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invitation_codes`
--
LOCK TABLES `invitation_codes` WRITE;
/*!40000 ALTER TABLE `invitation_codes` DISABLE KEYS */;
INSERT INTO `invitation_codes` VALUES (2,'3e1380a28f70',12,25,'2016-04-22 17:28:20','2016-04-22 17:28:20');
/*!40000 ALTER TABLE `invitation_codes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invitations`
--
DROP TABLE IF EXISTS `invitations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invitations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` text COLLATE utf8mb4_bin,
`sender_id` int(11) DEFAULT NULL,
`recipient_id` int(11) DEFAULT NULL,
`aspect_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`service` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`identifier` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`admin` tinyint(1) DEFAULT '0',
`language` varchar(255) COLLATE utf8mb4_bin DEFAULT 'en',
PRIMARY KEY (`id`),
KEY `index_invitations_on_aspect_id` (`aspect_id`) USING BTREE,
KEY `index_invitations_on_recipient_id` (`recipient_id`) USING BTREE,
KEY `index_invitations_on_sender_id` (`sender_id`) USING BTREE,
CONSTRAINT `invitations_sender_id_fk` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `invitations_recipient_id_fk` FOREIGN KEY (`recipient_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invitations`
--
LOCK TABLES `invitations` WRITE;
/*!40000 ALTER TABLE `invitations` DISABLE KEYS */;
/*!40000 ALTER TABLE `invitations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `likes`
--
DROP TABLE IF EXISTS `likes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`positive` tinyint(1) DEFAULT '1',
`target_id` int(11) DEFAULT NULL,
`author_id` int(11) DEFAULT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`author_signature` text COLLATE utf8mb4_bin,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`target_type` varchar(60) COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_likes_on_target_id_and_author_id_and_target_type` (`target_id`,`author_id`,`target_type`) USING BTREE,
UNIQUE KEY `index_likes_on_guid` (`guid`(191)) USING BTREE,
KEY `likes_author_id_fk` (`author_id`) USING BTREE,
KEY `index_likes_on_post_id` (`target_id`) USING BTREE,
CONSTRAINT `likes_author_id_fk` FOREIGN KEY (`author_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `likes`
--
LOCK TABLES `likes` WRITE;
/*!40000 ALTER TABLE `likes` DISABLE KEYS */;
INSERT INTO `likes` VALUES (2,1,21,30,'870eabe0eadd0133edfe00163eb8ca07','x1TLbkFt7zfrCkjR4/uNyeIBsANDcdFiqJHEoJM6/5glHh/e1AHKwCDEtzlpC1yCqS+KPHBsP3msx2MhYaogVzWMYlk+4YOq9yQ+s3BHjAOjevaw+cH+FLeK6s+RjJE5e2ok1w9945mheQq/sUEWxV5NeAq2XlW1YhvlSPFYZEw=','2016-04-22 17:28:18','2016-04-22 17:28:18','Post');
/*!40000 ALTER TABLE `likes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `locations`
--
DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`lat` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`lng` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`status_message_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `locations`
--
LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mentions`
--
DROP TABLE IF EXISTS `mentions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mentions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_mentions_on_person_id_and_post_id` (`person_id`,`post_id`) USING BTREE,
KEY `index_mentions_on_person_id` (`person_id`) USING BTREE,
KEY `index_mentions_on_post_id` (`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mentions`
--
LOCK TABLES `mentions` WRITE;
/*!40000 ALTER TABLE `mentions` DISABLE KEYS */;
INSERT INTO `mentions` VALUES (8,21,30),(9,32,30),(10,33,30),(11,34,30),(12,38,34),(13,39,34),(14,40,34);
/*!40000 ALTER TABLE `mentions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`conversation_id` int(11) NOT NULL,
`author_id` int(11) NOT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`text` text COLLATE utf8mb4_bin NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`author_signature` text COLLATE utf8mb4_bin,
PRIMARY KEY (`id`),
KEY `index_messages_on_author_id` (`author_id`) USING BTREE,
KEY `messages_conversation_id_fk` (`conversation_id`) USING BTREE,
CONSTRAINT `messages_author_id_fk` FOREIGN KEY (`author_id`) REFERENCES `people` (`id`) ON DELETE CASCADE,
CONSTRAINT `messages_conversation_id_fk` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (6,6,30,'87370fe0eadd0133edfe00163eb8ca07','Hey debora','2016-04-22 17:28:18','2016-04-22 17:28:18','OwauJgpwIE+pFx9ieweahwDgL+KcPW2oy/eEiomaOJesdJxQtNXQUNb5XNO+hdm8bMFt3jvq2oi8TUVEOB83KG0U+wQ3R+lpSFLES64wBTiARwXxig3RsbyYthtK8IYOlC2qInuO09V9auK0TRqrEjVSUmSn9rcoYn42GEgUgXE='),(7,7,31,'8839e6e0eadd0133edfe00163eb8ca07','Hey carol','2016-04-22 17:28:20','2016-04-22 17:28:20','vO7AJ1PYWiWl7K0WEXM6Uyi98ySuR1KcMxRpfqR0WXSBwoTgrkLwat1KatJOjqy4O+xicG1IdP/yWL5bTAsKGJgRk1TfFDo4fKSCWP9eagnxC612hOTrO6wfzp0lEXhDamZsZpn4YKEd05OW9/UmithkWs+gEH6BAD4hEHJs1bE='),(8,8,30,'88448610eadd0133edfe00163eb8ca07','Hey carol','2016-04-22 17:28:20','2016-04-22 17:28:20','jQ9l0SQu9z3RJ8HeCYhLQeLeMnfRDn/AAvNU85rN7Q3g8bHyzkBeep4EbCfvTgqmgTUQ5aLfDcPT2C5kM3TUPVXf4C8NT4P5wkK46r1U/NK1A++uEp8euq46T+i3NwGPCKsZTzrVhr/8mQSO3ajlvXbPbisDc6UMEDBuJEbge04='),(9,9,33,'8880d320eadd0133edfe00163eb8ca07','Hey carol','2016-04-22 17:28:21','2016-04-22 17:28:21','eNEsLmzNdVyTxh0sZzYXqm8S+AaaD5HdFoRiICWBiVfbecBXWyxZiHiP1ZxBRxX1tXLN5RM2f8YOZnJkK9o99v5P0gr4d0NAxVXo/jb53J0nxcydiU2vDqJqKfil0Ii62TIPm+ZW9jt9IiYUVBvl/quDlpumDRSS82N1TWG8yHM='),(10,10,34,'8887e190eadd0133edfe00163eb8ca07','Hey carol','2016-04-22 17:28:21','2016-04-22 17:28:21',NULL);
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notification_actors`
--
DROP TABLE IF EXISTS `notification_actors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_actors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`notification_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_notification_actors_on_notification_id_and_person_id` (`notification_id`,`person_id`) USING BTREE,
KEY `index_notification_actors_on_notification_id` (`notification_id`) USING BTREE,
KEY `index_notification_actors_on_person_id` (`person_id`) USING BTREE,
CONSTRAINT `notification_actors_notification_id_fk` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notification_actors`
--
LOCK TABLES `notification_actors` WRITE;
/*!40000 ALTER TABLE `notification_actors` DISABLE KEYS */;
INSERT INTO `notification_actors` VALUES (4,4,39,'2016-04-22 17:28:19','2016-04-22 17:28:19'),(5,5,42,'2016-04-22 17:28:19','2016-04-22 17:28:19'),(6,6,45,'2016-04-22 17:28:19','2016-04-22 17:28:19');
/*!40000 ALTER TABLE `notification_actors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`target_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`target_id` int(11) DEFAULT NULL,
`recipient_id` int(11) NOT NULL,
`unread` tinyint(1) NOT NULL DEFAULT '1',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_notifications_on_recipient_id` (`recipient_id`) USING BTREE,
KEY `index_notifications_on_target_id` (`target_id`) USING BTREE,
KEY `index_notifications_on_target_type_and_target_id` (`target_type`(190),`target_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notifications`
--
LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (4,'Comment',6,12,1,'2016-04-22 17:28:19','2016-04-22 17:28:19','Notifications::AlsoCommented'),(5,'Comment',7,12,1,'2016-04-22 17:28:19','2016-04-22 17:28:19','Notifications::AlsoCommented'),(6,'Comment',8,12,1,'2016-04-22 17:28:19','2016-04-22 17:28:19','Notifications::AlsoCommented');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `o_auth_access_tokens`
--
DROP TABLE IF EXISTS `o_auth_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `o_auth_access_tokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authorization_id` int(11) DEFAULT NULL,
`token` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_o_auth_access_tokens_on_token` (`token`(191)) USING BTREE,
KEY `index_o_auth_access_tokens_on_authorization_id` (`authorization_id`) USING BTREE,
CONSTRAINT `fk_rails_5debabcff3` FOREIGN KEY (`authorization_id`) REFERENCES `authorizations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `o_auth_access_tokens`
--
LOCK TABLES `o_auth_access_tokens` WRITE;
/*!40000 ALTER TABLE `o_auth_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `o_auth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `o_auth_applications`
--
DROP TABLE IF EXISTS `o_auth_applications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `o_auth_applications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`client_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`client_secret` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`client_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`redirect_uris` text COLLATE utf8mb4_bin,
`response_types` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`grant_types` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`application_type` varchar(255) COLLATE utf8mb4_bin DEFAULT 'web',
`contacts` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`logo_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`client_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`policy_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`tos_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`sector_identifier_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`token_endpoint_auth_method` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`jwks` text COLLATE utf8mb4_bin,
`jwks_uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`ppid` tinyint(1) DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_o_auth_applications_on_client_id` (`client_id`(191)) USING BTREE,
KEY `index_o_auth_applications_on_user_id` (`user_id`) USING BTREE,
CONSTRAINT `fk_rails_ad75323da2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `o_auth_applications`
--
LOCK TABLES `o_auth_applications` WRITE;
/*!40000 ALTER TABLE `o_auth_applications` DISABLE KEYS */;
INSERT INTO `o_auth_applications` VALUES (2,NULL,'1beb3d06a3dce22fc9a29b473f4d3a2c','2a5e5f473aed3529b16b9c51d835692ce553b161a99cea9b41a264e00829bc88','Diaspora Test Client 1be5ffd','[\"http://localhost:3000/\"]',NULL,NULL,'web',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2016-04-22 17:28:20','2016-04-22 17:28:20');
/*!40000 ALTER TABLE `o_auth_applications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `o_embed_caches`
--
DROP TABLE IF EXISTS `o_embed_caches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `o_embed_caches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(1024) COLLATE utf8mb4_bin NOT NULL,
`data` text COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `index_o_embed_caches_on_url` (`url`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `o_embed_caches`
--
LOCK TABLES `o_embed_caches` WRITE;
/*!40000 ALTER TABLE `o_embed_caches` DISABLE KEYS */;
/*!40000 ALTER TABLE `o_embed_caches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_graph_caches`
--
DROP TABLE IF EXISTS `open_graph_caches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `open_graph_caches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`ob_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`image` text COLLATE utf8mb4_bin,
`url` text COLLATE utf8mb4_bin,
`description` text COLLATE utf8mb4_bin,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_graph_caches`
--
LOCK TABLES `open_graph_caches` WRITE;
/*!40000 ALTER TABLE `open_graph_caches` DISABLE KEYS */;
/*!40000 ALTER TABLE `open_graph_caches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `participations`
--
DROP TABLE IF EXISTS `participations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `participations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`target_id` int(11) DEFAULT NULL,
`target_type` varchar(60) COLLATE utf8mb4_bin NOT NULL,
`author_id` int(11) DEFAULT NULL,
`author_signature` text COLLATE utf8mb4_bin,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`count` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `index_participations_on_author_id` (`author_id`) USING BTREE,
KEY `index_participations_on_guid` (`guid`(191)) USING BTREE,
KEY `index_participations_on_target_id_and_target_type_and_author_id` (`target_id`,`target_type`,`author_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `participations`
--
LOCK TABLES `participations` WRITE;
/*!40000 ALTER TABLE `participations` DISABLE KEYS */;
INSERT INTO `participations` VALUES (3,'871714b0eadd0133edfe00163eb8ca07',21,'Post',30,'ALKXmsnGP5ce+jUMxSVMI8lP1SFZeYIsKlqBLxCEBfTzXHzIZ3N8kpcCkRui7GvXc4oqa88NI1kVhlb7Arz1W4yMS3zY2YtBE+r/72pLf9DQ4iBoAt0OHYmTljtq8Nqgy2k+LRJk+zxZsinTv98/0cMzEZxStXEsS2HyzkMobpU=','2016-04-22 17:28:18','2016-04-22 17:28:18',2),(4,'87587f30eadd0133edfe00163eb8ca07',22,'Post',30,'v3/0E9397Ox/SYveQ494qCL6X+vWB2M0QFCPxdXBG6Lu1Om4P+ULd6noI9NY6ynkV3HgZt3NXbObAtSSYt49snsEpJ72U/ptpTGwYaOzE1Mdgmq5DzK8aUgxo/6E/nHQUFl/sp8N+cP1fKtt3kuNk3wK2uNSYtkh6DdOghHjk7Y=','2016-04-22 17:28:19','2016-04-22 17:28:19',1);
/*!40000 ALTER TABLE `participations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `people`
--
DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`diaspora_handle` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`serialized_public_key` text COLLATE utf8mb4_bin NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`closed_account` tinyint(1) DEFAULT '0',
`fetch_status` int(11) DEFAULT '0',
`pod_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_people_on_diaspora_handle` (`diaspora_handle`(191)) USING BTREE,
UNIQUE KEY `index_people_on_guid` (`guid`(191)) USING BTREE,
UNIQUE KEY `index_people_on_owner_id` (`owner_id`) USING BTREE,
KEY `people_pod_id_fk` (`pod_id`) USING BTREE,
CONSTRAINT `people_pod_id_fk` FOREIGN KEY (`pod_id`) REFERENCES `pods` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people`
--
LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT INTO `people` VALUES (27,'864cdc20eadd0133edfe00163eb8ca07','alice@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',9,'2016-04-22 17:28:17','2016-04-22 17:28:17',0,0,NULL),(28,'86655f80eadd0133edfe00163eb8ca07','eve@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',10,'2016-04-22 17:28:17','2016-04-22 17:28:17',0,0,NULL),(29,'866f40e0eadd0133edfe00163eb8ca07','bob@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',11,'2016-04-22 17:28:17','2016-04-22 17:28:17',0,0,NULL),(30,'867a5f20eadd0133edfe00163eb8ca07','carol@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',12,'2016-04-22 17:28:17','2016-04-22 17:28:17',0,0,NULL),(31,'86856030eadd0133edfe00163eb8ca07','debora@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',13,'2016-04-22 17:28:17','2016-04-22 17:28:17',0,0,NULL),(32,'86a7a2b0eadd0133edfe00163eb8ca07','luke@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',14,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0,NULL),(33,'86b264a0eadd0133edfe00163eb8ca07','leia@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',15,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0,NULL),(34,'86c06780eadd0133edfe00163eb8ca07','raphael@remote.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0,2),(35,'86d58280eadd0133edfe00163eb8ca07','peter@localhost:9887','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDTH4rdJst2yuTyyFcity/aWR6Q\nr3xI0Q0rg7R1xPuaPho199It4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qf\nsIfb2aEjwg7NiCmrpCH5x5xrABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wq\na2e6CgVMMF8zQSej4QIDAQAB\n-----END PUBLIC KEY-----\n',16,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,0,NULL),(36,'87415090eadd0133edfe00163eb8ca07','bob-person-1fe90a1@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(37,'8776d4b0eadd0133edfe00163eb8ca07','bob-person-2021dc8@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(38,'877b6950eadd0133edfe00163eb8ca07','bob-person-3eef69b@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(39,'878c3430eadd0133edfe00163eb8ca07','bob-person-405e1e8@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(40,'8792d6a0eadd0133edfe00163eb8ca07','bob-person-5d30f14@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(41,'87975d20eadd0133edfe00163eb8ca07','bob-person-6129561@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(42,'87a33520eadd0133edfe00163eb8ca07','bob-person-72f90ee@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(43,'87a89e50eadd0133edfe00163eb8ca07','bob-person-899df37@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(44,'87ac9370eadd0133edfe00163eb8ca07','bob-person-955e646@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(45,'87bac690eadd0133edfe00163eb8ca07','bob-person-106cd2aa@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',0,0,2),(46,'87e3d6f0eadd0133edfe00163eb8ca07','bob-person-11a0093b@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(47,'88183f30eadd0133edfe00163eb8ca07','bob-person-12b3e8ee@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(48,'88262d50eadd0133edfe00163eb8ca07','bob-person-13761b8c@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(49,'88306f00eadd0133edfe00163eb8ca07','bob-person-14fa20d7@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(50,'8861e280eadd0133edfe00163eb8ca07','bob-person-153a89f5@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(51,'886c1c40eadd0133edfe00163eb8ca07','bob-person-160b05dc@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',0,0,2),(52,'88767280eadd0133edfe00163eb8ca07','bob-person-17f575dd@example.net','-----BEGIN PUBLIC KEY-----\nMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDn0lL/tBgLNCiARPbE/eo5r7xy\ntz12uAYr+PQswGNHbw1k2rnf9xV5Ia7GDy2BcTrzAn99JLtL8t7JCQSfIMJ3fTXi\nf3pVKhjQj/FkPn0IAMy/T6HNcTKc+QbXYmRslmw234P53eAY75nHgGK7JwktHBno\nsJrOxR0aDO77kWY41wIDAQAB\n-----END PUBLIC KEY-----\n',NULL,'2016-04-22 17:28:21','2016-04-22 17:28:21',0,0,2);
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `photos`
--
DROP TABLE IF EXISTS `photos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `photos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author_id` int(11) NOT NULL,
`public` tinyint(1) NOT NULL DEFAULT '0',
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`pending` tinyint(1) NOT NULL DEFAULT '0',
`text` text COLLATE utf8mb4_bin,
`remote_photo_path` text COLLATE utf8mb4_bin,
`remote_photo_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`random_string` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`processed_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`unprocessed_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`status_message_guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`comments_count` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_photos_on_status_message_guid` (`status_message_guid`(191)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `photos`
--
LOCK TABLES `photos` WRITE;
/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
INSERT INTO `photos` VALUES (28,28,1,'dbc8b310eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','b7853f01725cebfe0eb0.png','b7853f01725cebfe0eb0',NULL,'2016-04-22 17:16:20','2016-04-22 17:16:21',NULL,NULL,NULL,NULL,NULL),(29,28,1,'dbdc3770eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','83bd05ecc453b4e900c7.png','83bd05ecc453b4e900c7',NULL,'2016-04-22 17:16:21','2016-04-22 17:16:22',NULL,NULL,NULL,NULL,NULL),(30,28,1,'dbec7900eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','f83aa03fa234f7bc9e9e.png','f83aa03fa234f7bc9e9e',NULL,'2016-04-22 17:16:22','2016-04-22 17:16:23',NULL,NULL,NULL,NULL,NULL),(31,28,1,'dca22180eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','2b8d1e6a5bc0db75a41c.png','2b8d1e6a5bc0db75a41c',NULL,'2016-04-22 17:16:22','2016-04-22 17:16:23',NULL,NULL,NULL,NULL,NULL),(32,28,1,'dcfb3990eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','6437b4eadc6c565e12a4.png','6437b4eadc6c565e12a4',NULL,'2016-04-22 17:16:22','2016-04-22 17:16:23',NULL,NULL,NULL,NULL,NULL),(33,28,1,'dd09a370eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','6b06271341cdb318169c.png','6b06271341cdb318169c',NULL,'2016-04-22 17:16:23','2016-04-22 17:16:24',NULL,NULL,NULL,NULL,NULL),(34,28,1,'dd23a4d0eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','0493dd6179a022d6d565.png','0493dd6179a022d6d565',NULL,'2016-04-22 17:16:23','2016-04-22 17:16:24',NULL,NULL,NULL,NULL,NULL),(35,28,1,'dd50bea0eadb0133edf800163eb8ca07',0,NULL,'http://localhost:9887/uploads/images/','bb8ac84251cebe0fc637.png','bb8ac84251cebe0fc637',NULL,'2016-04-22 17:16:26','2016-04-22 17:16:27',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pods`
--
DROP TABLE IF EXISTS `pods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`host` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`ssl` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`status` int(11) DEFAULT '0',
`checked_at` datetime DEFAULT '1970-01-01 00:00:00',
`offline_since` datetime DEFAULT NULL,
`response_time` int(11) DEFAULT '-1',
`software` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`error` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`port` int(11) DEFAULT NULL,
`blocked` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_pods_on_host_and_port` (`host`(190),`port`) USING BTREE,
KEY `index_pods_on_checked_at` (`checked_at`) USING BTREE,
KEY `index_pods_on_offline_since` (`offline_since`) USING BTREE,
KEY `index_pods_on_status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pods`
--
LOCK TABLES `pods` WRITE;
/*!40000 ALTER TABLE `pods` DISABLE KEYS */;
INSERT INTO `pods` VALUES (2,'example.net',0,'2016-04-22 17:28:18','2016-04-22 17:28:18',0,'1970-01-01 00:00:00',NULL,-1,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `pods` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `poll_answers`
--
DROP TABLE IF EXISTS `poll_answers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_answers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`answer` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`poll_id` int(11) NOT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`vote_count` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_poll_answers_on_poll_id` (`poll_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `poll_answers`
--
LOCK TABLES `poll_answers` WRITE;
/*!40000 ALTER TABLE `poll_answers` DISABLE KEYS */;
INSERT INTO `poll_answers` VALUES (3,'1 questionmarks',2,'874891b0eadd0133edfe00163eb8ca07',1),(4,'2 questionmarks',2,'8748a7f0eadd0133edfe00163eb8ca07',0);
/*!40000 ALTER TABLE `poll_answers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `poll_participations`
--
DROP TABLE IF EXISTS `poll_participations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_participations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poll_answer_id` int(11) NOT NULL,
`author_id` int(11) NOT NULL,
`poll_id` int(11) NOT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`author_signature` text COLLATE utf8mb4_bin,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_poll_participations_on_poll_id` (`poll_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `poll_participations`
--
LOCK TABLES `poll_participations` WRITE;
/*!40000 ALTER TABLE `poll_participations` DISABLE KEYS */;
INSERT INTO `poll_participations` VALUES (2,3,30,2,'87552480eadd0133edfe00163eb8ca07','0x9NPlq7K9tjKf/Y3iLs8dYirzTqT8k5jY/7rFS9/8D3HLyZPqGGxZjoUOWPLHgMvWXLVw09SWveSW5ake7GIZwHenAruiUZUU6l9VcCEI2cJRYfa+bt6GLx2sKS9YE0TFEd1zFr0IbBpalaL2K1/A3qmshxpTwuXolJzaWc6DQ=','2016-04-22 17:28:19','2016-04-22 17:28:19');
/*!40000 ALTER TABLE `poll_participations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `polls`
--
DROP TABLE IF EXISTS `polls`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `polls` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`question` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`status_message_id` int(11) NOT NULL,
`status` tinyint(1) DEFAULT NULL,
`guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_polls_on_status_message_id` (`status_message_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `polls`
--
LOCK TABLES `polls` WRITE;
/*!40000 ALTER TABLE `polls` DISABLE KEYS */;
INSERT INTO `polls` VALUES (2,'What do you think about 1 ninjas?',22,NULL,'87478310eadd0133edfe00163eb8ca07','2016-04-22 17:28:19','2016-04-22 17:28:19');
/*!40000 ALTER TABLE `polls` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `posts`
--
DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author_id` int(11) NOT NULL,
`public` tinyint(1) NOT NULL DEFAULT '0',
`guid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`pending` tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(40) COLLATE utf8mb4_bin NOT NULL,
`text` text COLLATE utf8mb4_bin,
`remote_photo_path` text COLLATE utf8mb4_bin,
`remote_photo_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`random_string` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`processed_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`unprocessed_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`object_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`image_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`image_height` int(11) DEFAULT NULL,
`image_width` int(11) DEFAULT NULL,
`provider_display_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`actor_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`objectId` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`root_guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`status_message_guid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`likes_count` int(11) DEFAULT '0',
`comments_count` int(11) DEFAULT '0',
`o_embed_cache_id` int(11) DEFAULT NULL,
`reshares_count` int(11) DEFAULT '0',
`interacted_at` datetime DEFAULT NULL,
`frame_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`facebook_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`tweet_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`open_graph_cache_id` int(11) DEFAULT NULL,
`tumblr_ids` text COLLATE utf8mb4_bin,
PRIMARY KEY (`id`),
UNIQUE KEY `index_posts_on_guid` (`guid`(191)) USING BTREE,
UNIQUE KEY `index_posts_on_author_id_and_root_guid` (`author_id`,`root_guid`(190)) USING BTREE,
KEY `index_posts_on_person_id` (`author_id`) USING BTREE,
KEY `index_posts_on_id_and_type_and_created_at` (`id`,`type`,`created_at`) USING BTREE,
KEY `index_posts_on_root_guid` (`root_guid`(191)) USING BTREE,
KEY `index_posts_on_status_message_guid_and_pending` (`status_message_guid`(190),`pending`) USING BTREE,
KEY `index_posts_on_status_message_guid` (`status_message_guid`(191)) USING BTREE,
KEY `index_posts_on_tweet_id` (`tweet_id`(191)) USING BTREE,
KEY `index_posts_on_type_and_pending_and_id` (`type`,`pending`,`id`) USING BTREE,
CONSTRAINT `posts_author_id_fk` FOREIGN KEY (`author_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `posts`
--
LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES (21,31,0,'86f283f0eadd0133edfe00163eb8ca07',0,'StatusMessage','@{carol; carol@localhost:9887} you are silly',NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,0,'2016-04-22 17:28:18',NULL,NULL,NULL,NULL,NULL),(22,36,0,'87465ab0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 1 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(23,30,0,'875c3520eadd0133edfe00163eb8ca07',0,'StatusMessage','asldkfjs',NULL,NULL,NULL,NULL,'2016-04-22 17:28:18','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(24,38,0,'877f5a30eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 2 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(25,41,0,'879c12d0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 3 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(26,44,0,'87b250d0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 4 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:19','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(27,30,0,'87c00810eadd0133edfe00163eb8ca07',0,'StatusMessage','[Robert229187b Grimm208ef82](/u/eve)',NULL,NULL,NULL,NULL,'2016-04-22 17:28:18','2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:19',NULL,NULL,NULL,NULL,NULL),(28,46,0,'87e918c0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 5 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(29,30,0,'8803a950eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 6 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(30,30,0,'8807b990eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 7 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(31,30,0,'880ab210eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 8 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(32,47,0,'881d4700eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 9 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(33,48,0,'882ad890eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 10 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(34,49,0,'8833e720eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 11 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(35,34,0,'884d70c0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 12 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(36,34,0,'885121a0eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 13 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(37,34,0,'8853b210eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 14 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(38,50,0,'88659680eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 15 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:20','2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:20',NULL,NULL,NULL,NULL,NULL),(39,51,0,'88704750eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 16 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:21','2016-04-22 17:28:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:21',NULL,NULL,NULL,NULL,NULL),(40,52,0,'887a7d40eadd0133edfe00163eb8ca07',0,'StatusMessage','jimmy\'s 17 whales',NULL,NULL,NULL,NULL,'2016-04-22 17:28:21','2016-04-22 17:28:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,'2016-04-22 17:28:21',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ppid`
--
DROP TABLE IF EXISTS `ppid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ppid` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`o_auth_application_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`guid` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
`string` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
`identifier` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_ppid_on_o_auth_application_id` (`o_auth_application_id`) USING BTREE,
KEY `index_ppid_on_user_id` (`user_id`) USING BTREE,
CONSTRAINT `fk_rails_e6b8e5264f` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `fk_rails_150457f962` FOREIGN KEY (`o_auth_application_id`) REFERENCES `o_auth_applications` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ppid`
--
LOCK TABLES `ppid` WRITE;
/*!40000 ALTER TABLE `ppid` DISABLE KEYS */;
/*!40000 ALTER TABLE `ppid` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `profiles`
--
DROP TABLE IF EXISTS `profiles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`diaspora_handle` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`first_name` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`last_name` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`image_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`image_url_small` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`image_url_medium` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`birthday` date DEFAULT NULL,
`gender` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`bio` text COLLATE utf8mb4_bin,
`searchable` tinyint(1) NOT NULL DEFAULT '1',
`person_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`full_name` varchar(70) COLLATE utf8mb4_bin DEFAULT NULL,
`nsfw` tinyint(1) DEFAULT '0',
`public_details` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_profiles_on_full_name_and_searchable` (`full_name`,`searchable`) USING BTREE,
KEY `index_profiles_on_full_name` (`full_name`) USING BTREE,
KEY `index_profiles_on_person_id` (`person_id`) USING BTREE,
CONSTRAINT `profiles_person_id_fk` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `profiles`
--
LOCK TABLES `profiles` WRITE;
/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
INSERT INTO `profiles` VALUES (27,NULL,'Robert1688bac','Grimm19ea4fe',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,27,'2016-04-22 17:28:17','2016-04-22 17:28:17','Earth','robert1688bac grimm19ea4fe',0,0),(28,NULL,'Robert229187b','Grimm208ef82',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,28,'2016-04-22 17:28:17','2016-04-22 17:28:17','Earth','robert229187b grimm208ef82',0,0),(29,NULL,'Robert394a021','Grimm3318010',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,29,'2016-04-22 17:28:17','2016-04-22 17:28:17','Earth','robert394a021 grimm3318010',0,0),(30,NULL,'Robert4773efe','Grimm43f73d7',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,30,'2016-04-22 17:28:17','2016-04-22 17:28:17','Earth','robert4773efe grimm43f73d7',0,0),(31,NULL,'Robert53dd61e','Grimm59e8bde',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,31,'2016-04-22 17:28:17','2016-04-22 17:28:17','Earth','robert53dd61e grimm59e8bde',0,0),(32,NULL,'Robert6594541','Grimm60a4c18',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,32,'2016-04-22 17:28:18','2016-04-22 17:28:18','Earth','robert6594541 grimm60a4c18',0,0),(33,NULL,'Robert79427ef','Grimm737d853',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,33,'2016-04-22 17:28:18','2016-04-22 17:28:18','Earth','robert79427ef grimm737d853',0,0),(34,NULL,'Robert859303a','Grimm80def3b',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,34,'2016-04-22 17:28:18','2016-04-22 17:28:18','Earth','robert859303a grimm80def3b',0,0),(35,NULL,'Robert93921d9','Grimm9198c4c',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,35,'2016-04-22 17:28:18','2016-04-22 17:28:18','Earth','robert93921d9 grimm9198c4c',0,0),(36,NULL,'Robert1092f765','Grimm1087d4ab',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,36,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert1092f765 grimm1087d4ab',0,0),(37,NULL,'Robert1114f008','Grimm111848f7',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,37,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert1114f008 grimm111848f7',0,0),(38,NULL,'Robert126ac9ea','Grimm129e9da9',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,38,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert126ac9ea grimm129e9da9',0,0),(39,NULL,'Robert13d8b603','Grimm131bf9f2',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,39,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert13d8b603 grimm131bf9f2',0,0),(40,NULL,'Robert14eff435','Grimm14390844',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,40,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert14eff435 grimm14390844',0,0),(41,NULL,'Robert1524435d','Grimm15659c1b',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,41,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert1524435d grimm15659c1b',0,0),(42,NULL,'Robert167f35db','Grimm1669e13b',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,42,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert167f35db grimm1669e13b',0,0),(43,NULL,'Robert17d4a100','Grimm1712606d',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,43,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert17d4a100 grimm1712606d',0,0),(44,NULL,'Robert189987f5','Grimm18b5d782',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,44,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert189987f5 grimm18b5d782',0,0),(45,NULL,'Robert1965e10c','Grimm195f186d',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,45,'2016-04-22 17:28:19','2016-04-22 17:28:19','Earth','robert1965e10c grimm195f186d',0,0),(46,NULL,'Robert2092eaf7','Grimm20ef167e',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,46,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert2092eaf7 grimm20ef167e',0,0),(47,NULL,'Robert2149c899','Grimm210f13ac',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,47,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert2149c899 grimm210f13ac',0,0),(48,NULL,'Robert22f8c62d','Grimm229c378c',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,48,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert22f8c62d grimm229c378c',0,0),(49,NULL,'Robert23614fec','Grimm23b82145',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,49,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert23614fec grimm23b82145',0,0),(50,NULL,'Robert241b0bbe','Grimm247810c8',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,50,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert241b0bbe grimm247810c8',0,0),(51,NULL,'Robert25459e86','Grimm258ed7ea',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,51,'2016-04-22 17:28:20','2016-04-22 17:28:20','Earth','robert25459e86 grimm258ed7ea',0,0),(52,NULL,'Robert264172df','Grimm269e2bf1',NULL,NULL,NULL,'2016-04-22','robot','I am a cat lover and I love to run',1,52,'2016-04-22 17:28:21','2016-04-22 17:28:21','Earth','robert264172df grimm269e2bf1',0,0);
/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rails_admin_histories`
--
DROP TABLE IF EXISTS `rails_admin_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rails_admin_histories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` text COLLATE utf8mb4_bin,
`username` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`item` int(11) DEFAULT NULL,
`table` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`month` smallint(6) DEFAULT NULL,
`year` bigint(20) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_rails_admin_histories` (`item`,`table`(188),`month`,`year`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rails_admin_histories`
--
LOCK TABLES `rails_admin_histories` WRITE;
/*!40000 ALTER TABLE `rails_admin_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `rails_admin_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reports`
--
DROP TABLE IF EXISTS `reports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`item_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`reviewed` tinyint(1) DEFAULT '0',
`text` text COLLATE utf8mb4_bin,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_reports_on_item_id` (`item_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reports`
--
LOCK TABLES `reports` WRITE;
/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
INSERT INTO `reports` VALUES (2,28,'Post',0,'1 offensive content','2016-04-22 17:28:20','2016-04-22 17:28:20',12);
/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (2,30,'moderator','2016-04-22 17:28:20','2016-04-22 17:28:20');
/*!40000 ALTER TABLE `roles` 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) COLLATE utf8mb4_bin NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!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 ('0'),('20130207231310'),('20130404211624'),('20130429073928'),('20130608171134'),('20130613203350'),('20130717104359'),('20130801063213'),('20131017093025'),('20131213171804'),('20140121132816'),('20140214104217'),('20140222162826'),('20140308154022'),('20140422134050'),('20140422134627'),('20140601102543'),('20140801101230'),('20140801101352'),('20140824230505'),('20140826165533'),('20140906192846'),('20141001162851'),('20141007003922'),('20141024170120'),('20141209041241'),('20141216213423'),('20141227120907'),('20141230214830'),('20150106050733'),('20150209230946'),('20150220001357'),('20150403192408'),('20150403212139'),('20150404193023'),('20150523004437'),('20150531005120'),('20150607143809'),('20150613202109'),('20150630221004'),('20150708153926'),('20150708153928'),('20150714055110'),('20150724152052'),('20150731123113'),('20150731123114'),('20150828132451'),('20151003142048'),('20151210213023'),('20160124234712'),('20160225232049'),('20160302025129'),('20160307142216'),('20160327103605');
/*!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,
`type` varchar(127) COLLATE utf8mb4_bin NOT NULL,
`user_id` int(11) NOT NULL,
`uid` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`access_token` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`access_secret` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`nickname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_services_on_type_and_uid` (`type`(64),`uid`) USING BTREE,
KEY `index_services_on_user_id` (`user_id`) USING BTREE,
CONSTRAINT `services_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `services`
--
LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES (4,'Services::Twitter',12,'000001','123451','987651','sirrobertking','2016-04-22 17:28:20','2016-04-22 17:28:20'),(5,'Services::Twitter',12,'000002','123452','987652','sirrobertking','2016-04-22 17:28:20','2016-04-22 17:28:20'),(6,'Services::Twitter',12,'000003','123453','987653','sirrobertking','2016-04-22 17:28:20','2016-04-22 17:28:20');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `share_visibilities`
--
DROP TABLE IF EXISTS `share_visibilities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `share_visibilities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shareable_id` int(11) NOT NULL,
`hidden` tinyint(1) NOT NULL DEFAULT '0',
`shareable_type` varchar(60) COLLATE utf8mb4_bin NOT NULL DEFAULT 'Post',
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `shareable_and_hidden_and_user_id` (`shareable_id`,`shareable_type`,`hidden`,`user_id`) USING BTREE,
KEY `shareable_and_user_id` (`shareable_id`,`shareable_type`,`user_id`) USING BTREE,
KEY `index_post_visibilities_on_post_id` (`shareable_id`) USING BTREE,
KEY `index_share_visibilities_on_user_id` (`user_id`) USING BTREE,
CONSTRAINT `share_visibilities_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `share_visibilities`
--
LOCK TABLES `share_visibilities` WRITE;
/*!40000 ALTER TABLE `share_visibilities` DISABLE KEYS */;
INSERT INTO `share_visibilities` VALUES (15,23,0,'Post',12),(14,23,0,'Post',13),(17,27,0,'Post',12),(16,27,0,'Post',13),(18,29,0,'Post',13),(19,30,0,'Post',13),(20,31,0,'Post',13),(22,35,0,'Post',14),(21,35,0,'Post',15),(24,36,0,'Post',14),(23,36,0,'Post',15),(26,37,0,'Post',14),(25,37,0,'Post',15);
/*!40000 ALTER TABLE `share_visibilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `simple_captcha_data`
--
DROP TABLE IF EXISTS `simple_captcha_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `simple_captcha_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(40) COLLATE utf8mb4_bin DEFAULT NULL,
`value` varchar(12) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_key` (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `simple_captcha_data`
--
LOCK TABLES `simple_captcha_data` WRITE;
/*!40000 ALTER TABLE `simple_captcha_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `simple_captcha_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tag_followings`
--
DROP TABLE IF EXISTS `tag_followings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tag_followings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_tag_followings_on_tag_id_and_user_id` (`tag_id`,`user_id`) USING BTREE,
KEY `index_tag_followings_on_tag_id` (`tag_id`) USING BTREE,
KEY `index_tag_followings_on_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tag_followings`
--
LOCK TABLES `tag_followings` WRITE;
/*!40000 ALTER TABLE `tag_followings` DISABLE KEYS */;
INSERT INTO `tag_followings` VALUES (2,2,12,'2016-04-22 17:28:19','2016-04-22 17:28:19');
/*!40000 ALTER TABLE `tag_followings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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(127) COLLATE utf8mb4_bin DEFAULT NULL,
`tagger_id` int(11) DEFAULT NULL,
`tagger_type` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`context` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_taggings_uniquely` (`taggable_id`,`taggable_type`,`tag_id`) USING BTREE,
KEY `index_taggings_on_created_at` (`created_at`) USING BTREE,
KEY `index_taggings_on_tag_id` (`tag_id`) USING BTREE,
KEY `index_taggings_on_taggable_id_and_taggable_type_and_context` (`taggable_id`,`taggable_type`(95),`context`(95)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taggings`
--
LOCK TABLES `taggings` WRITE;
/*!40000 ALTER TABLE `taggings` DISABLE KEYS */;
/*!40000 ALTER TABLE `taggings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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 utf8mb4_bin DEFAULT NULL,
`taggings_count` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_tags_on_name` (`name`(191)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tags`
--
LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` VALUES (2,'partytimeexcellent2',0);
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_preferences`
--
DROP TABLE IF EXISTS `user_preferences`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_preferences` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_preferences`
--
LOCK TABLES `user_preferences` WRITE;
/*!40000 ALTER TABLE `user_preferences` DISABLE KEYS */;
INSERT INTO `user_preferences` VALUES (4,'mentioned',12,'2016-04-22 17:28:19','2016-04-22 17:28:19'),(5,'liked',12,'2016-04-22 17:28:19','2016-04-22 17:28:19'),(6,'reshared',12,'2016-04-22 17:28:19','2016-04-22 17:28:19');
/*!40000 ALTER TABLE `user_preferences` 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,
`username` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`serialized_private_key` text COLLATE utf8mb4_bin,
`getting_started` tinyint(1) NOT NULL DEFAULT '1',
`disable_mail` tinyint(1) NOT NULL DEFAULT '0',
`language` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`encrypted_password` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`invitation_token` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
`invitation_sent_at` datetime DEFAULT NULL,
`reset_password_token` varchar(255) COLLATE utf8mb4_bin 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(255) COLLATE utf8mb4_bin DEFAULT NULL,
`last_sign_in_ip` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`invitation_service` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`invitation_identifier` varchar(127) COLLATE utf8mb4_bin DEFAULT NULL,
`invitation_limit` int(11) DEFAULT NULL,
`invited_by_id` int(11) DEFAULT NULL,
`invited_by_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`authentication_token` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
`unconfirmed_email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`confirm_email_token` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
`locked_at` datetime DEFAULT NULL,
`show_community_spotlight_in_stream` tinyint(1) NOT NULL DEFAULT '1',
`auto_follow_back` tinyint(1) DEFAULT '0',
`auto_follow_back_aspect_id` int(11) DEFAULT NULL,
`hidden_shareables` text COLLATE utf8mb4_bin,
`reset_password_sent_at` datetime DEFAULT NULL,
`last_seen` datetime DEFAULT NULL,
`remove_after` datetime DEFAULT NULL,
`export` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`exported_at` datetime DEFAULT NULL,
`exporting` tinyint(1) DEFAULT '0',
`strip_exif` tinyint(1) DEFAULT '1',
`exported_photos_file` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`exported_photos_at` datetime DEFAULT NULL,
`exporting_photos` tinyint(1) DEFAULT '0',
`color_theme` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_authentication_token` (`authentication_token`) USING BTREE,
UNIQUE KEY `index_users_on_invitation_service_and_invitation_identifier` (`invitation_service`(64),`invitation_identifier`) USING BTREE,
UNIQUE KEY `index_users_on_username` (`username`(191)) USING BTREE,
KEY `index_users_on_email` (`email`(191)) USING BTREE,
KEY `index_users_on_invitation_token` (`invitation_token`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!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 (9,'alice','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob151f078@pivotallabs.com','$2a$04$acc98iRbowJhXqnH3I1SNuLI.MaVUAdj2/MyRC40GVAzB00sLwWe2',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'alice_diaspora_data_i-YlfKsk9vQLKIhtUvYpIA.json.gz',NULL,0,0,NULL,NULL,0,'original'),(10,'eve','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob20d25d6@pivotallabs.com','$2a$04$GZReLqLhTFkGu0/gDzLs1eCzH2RQj4Q.gpbDlnVABtxhyal59OrC6',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'eve_diaspora_data_JVcwGMM0IJA2zsxQwEobrg.json.gz',NULL,0,1,NULL,NULL,0,'original'),(11,'bob','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob306f886@pivotallabs.com','$2a$04$4OQMG2Y51XkEJWknf95Z9Ovj4bDGvzNNC0qWFCwl7Mj7oj7DHHcMO',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'bob_diaspora_data_e3R_ZwZT_U6YqvfuhkEiqQ.json.gz',NULL,0,1,NULL,NULL,0,'original'),(12,'carol','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob41f144f@pivotallabs.com','$2a$04$TPWR.skTuYcCSBjROKGId.naY8gdKjuMu2DPGCP69LF87RgreGaG.',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'carol_diaspora_data_TDHIMrQWY5ZXTkwU7pZjzA.json.gz',NULL,0,1,NULL,NULL,0,'original'),(13,'debora','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob50b16e3@pivotallabs.com','$2a$04$3zM8XhwVWuaJxVmpXnZXEu7WJsC2SefnqoVjng53dL7bpq6C7cAA2',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:17','2016-04-22 17:28:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'debora_diaspora_data_GnuZLrmFdUI3VwmPLy-x3w.json.gz',NULL,0,1,NULL,NULL,0,'original'),(14,'luke','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob69e30e1@pivotallabs.com','$2a$04$q8s6WVGxG2DgmrkAlmlgAOAuH4/UCJlLD6uLSMGktnFTsiKfgx9fy',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:18','2016-04-22 17:28:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'luke_diaspora_data_C5W85cJEiBei9l5qd1_0mA.json.gz',NULL,0,1,NULL,NULL,0,'original'),(15,'leia','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob73cd30b@pivotallabs.com','$2a$04$y9y6dUvYxPwh8/HbBegx/uZVNJwyO1NMZxWHhuKLvmUxdGe5Q.14m',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:18','2016-04-22 17:28:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'leia_diaspora_data__qOVzi8_vhV3ROkGeSdwEg.json.gz',NULL,0,1,NULL,NULL,0,'original'),(16,'peter','-----BEGIN RSA PRIVATE KEY-----\nMIICWwIBAAKBgQDTH4rdJst2yuTyyFcity/aWR6Qr3xI0Q0rg7R1xPuaPho199It\n4RRLJaqYwNRdn3Zhlj/8cLPBD5lIROQjm6w5L9qfsIfb2aEjwg7NiCmrpCH5x5xr\nABatA3KHnZx7bTgSnPyom7TYHnFVg89j5AmgQ9wqa2e6CgVMMF8zQSej4QIDAQAB\nAoGAW5rQEe0HU1/tvzoWNMXvSXppvLWn46BxanQXFRKHaQGRNeF1nNqQh5qsTuM8\nQfMy1lzvHoV4OUifZbAenSSqsMvEhWtTHTdrTxfHeipdxg1q1kfmwaQBA9kae4MQ\n4gFJyWL/Ytn8Y9Fbu6zACmDs/d2m60lQn37CudAfarS1E1ECQQDrBULALChkvjho\nr4siLGwGnP7CzDBBMJwbMohyGnAn8CrnGel5EIAQAvmZbcOoGHY4vAv8gOYjji+Y\nscBG2AcvAkEA5fgsuNMt+mjI0rR6qqBNFzEK1r8TErUqNCO5Cw8NYC7IFgb+JETv\ndzCzDpxUyHYgZ6E+qSG74vz+iK+ezTpB7wJAYeVwF6KNNOGzl4+/0f1VBjAxQq1R\nUGZSMFYNVhJDM6+r/1Xg1egUoBbNJ6b8QDHoVNun1odO1fKtStqH8DqeSwJAOWPE\nrV8uMzahH0wg7KHSez4m6U6H0PxbCuX7UNIx0VX7Ytvd4mk9pW4G0VecJOat0Y7A\n125uuAfQ8YV6SNcICwJAbrA0smxjEpAGLgISadTixWAji+Ct6ejj6BDQkWblImrO\ngzdAj74lMtPVkavrF+gVPmqUWrbGw6SBZlcCOmx5IQ==\n-----END RSA PRIVATE KEY-----\n',0,0,'en','bob882bec4@pivotallabs.com','$2a$04$aS9Kx8jYUl.Fo9Und4ynaurn4eBqeWg4jBm/iNwH53QP4yi6zXKYa',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2016-04-22 17:28:18','2016-04-22 17:28:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'peter_diaspora_data_F4nbPcSHP7Zgc1Ttcqgejw.json.gz',NULL,0,1,NULL,NULL,0,'original');
/*!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 2016-04-22 17:44:47
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment