text: --
  -- Table structure for table `bookmarks`
  --
  
  DROP TABLE IF EXISTS `bookmarks`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bookmarks` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `slug` varchar(100) NOT NULL,
    `host` varchar(100) NOT NULL,
    `is_external` tinyint(4) DEFAULT '0',
    `title` varchar(100) NOT NULL,
    `category` varchar(20) DEFAULT NULL,
    `authors` varchar(10000) DEFAULT NULL,
    `pub_date` int(10) unsigned DEFAULT NULL,
    `desc` varchar(250) DEFAULT NULL,
    `thumbnail` varchar(1024) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uix_bookmarks_slug_host` (`slug`,`host`),
    KEY `idx_bookmarks_deleted_at` (`deleted_at`)
  ) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- 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(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `email` varchar(100) DEFAULT NULL,
    `first_name` varchar(50) DEFAULT NULL,
    `last_name` varchar(50) DEFAULT NULL,
    `security_id` varchar(20) DEFAULT NULL,
    `passport_id` varchar(30) DEFAULT NULL,
    `city` varchar(45) DEFAULT NULL,
    `state` varchar(45) DEFAULT NULL,
    `country` varchar(45) DEFAULT NULL,
    `zip` varchar(20) DEFAULT NULL,
    `address` varchar(255) DEFAULT NULL,
    `phone` varchar(20) DEFAULT NULL,
    `privilege` int(5) NOT NULL,
    `registration_date` timestamp NULL DEFAULT NULL,
    `birthday` timestamp NULL DEFAULT NULL,
    `gender` varchar(2) DEFAULT NULL,
    `education` varchar(20) DEFAULT NULL,
    `enable_email` int(5) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=790 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `o_auth_accounts`
  --
  
  DROP TABLE IF EXISTS `o_auth_accounts`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `o_auth_accounts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `type` varchar(10) DEFAULT NULL,
    `a_id` varchar(255) NOT NULL,
    `email` varchar(100) DEFAULT NULL,
    `name` varchar(80) DEFAULT NULL,
    `first_name` varchar(50) DEFAULT NULL,
    `last_name` varchar(50) DEFAULT NULL,
    `gender` varchar(20) DEFAULT NULL,
    `picture` varchar(255) DEFAULT NULL,
    `birthday` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_o_auth_accounts_deleted_at` (`deleted_at`),
    KEY `fk_o_auth_accounts_users1_idx` (`user_id`),
    CONSTRAINT `fk_o_auth_accounts_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=758 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- 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(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `name` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uix_services_name` (`name`),
    KEY `idx_services_deleted_at` (`deleted_at`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `registrations`
  --
  
  DROP TABLE IF EXISTS `registrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `registrations` (
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `email` varchar(100) NOT NULL,
    `active` tinyint(1) DEFAULT '0',
    `activate_token` varchar(20) DEFAULT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `services_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`email`),
    KEY `fk_registrations_users1_idx` (`user_id`),
    KEY `fk_registrations_services1_idx` (`services_id`),
    CONSTRAINT `fk_registrations_services1` FOREIGN KEY (`services_id`) REFERENCES `services` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_registrations_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `reporter_accounts`
  --
  
  DROP TABLE IF EXISTS `reporter_accounts`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `reporter_accounts` (
    `user_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(100) NOT NULL,
    `activate_token` varchar(50) DEFAULT NULL,
    `act_exp_time` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uix_reporter_accounts_email` (`email`),
    KEY `fk_reporter_accounts_users1_idx` (`user_id`),
    CONSTRAINT `fk_reporter_accounts_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `users_bookmarks`
  --
  
  DROP TABLE IF EXISTS `users_bookmarks`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users_bookmarks` (
    `user_id` int(10) unsigned NOT NULL,
    `bookmark_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`user_id`,`bookmark_id`),
    KEY `fk_users_has_bookmarks_bookmarks1_idx` (`bookmark_id`),
    KEY `fk_users_has_bookmarks_users1_idx` (`user_id`),
    CONSTRAINT `fk_users_has_bookmarks_bookmarks1` FOREIGN KEY (`bookmark_id`) REFERENCES `bookmarks` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
    CONSTRAINT `fk_users_has_bookmarks_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  