--
-- Host: localhost    Database: aam
-- ------------------------------------------------------


--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_group_id` int(10) unsigned NOT NULL,
  `sequence` int(10) unsigned NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`article_id`),
  KEY `fk_article_article_group` (`article_group_id`),
  CONSTRAINT `fk_article_article_group` FOREIGN KEY (`article_group_id`) REFERENCES `article_group` (`article_group_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `article`
--

INSERT INTO `article` VALUES (1,1,0,'Core Concepts: Introduction','introduction','2016-05-26 16:23:25','2017-12-12 07:06:53'),(2,1,1,'Astro/Atomic Symmetry','astro-atomic-symmetry','2016-05-26 16:23:25','2017-12-12 17:00:00'),(3,1,2,'Nuclei and Star Systems','nuclei-and-star-systems','2016-05-26 16:23:25','2017-12-12 17:00:00'),(4,1,3,'Electrons and Star Satellites','electrons-and-star-satellites','2016-05-26 16:23:25','2017-12-12 17:00:00'),(5,4,0,'Common Misconceptions','common-misconceptions','2016-05-26 16:23:25','2017-12-12 16:54:48'),(6,4,1,'The Hydrogen Atom','the-hydrogen-atom','2016-05-26 16:23:25','2017-12-12 16:54:48'),(7,4,2,'Spectrography','spectrography','2016-05-26 16:23:25','2017-12-12 16:54:48'),(8,6,0,'Electrostatics','electrostatics','2016-05-26 16:23:25','2016-05-26 16:23:25'),(9,6,1,'Magnetism','magnetism','2016-05-26 16:23:25','2016-05-26 16:23:25'),(10,6,2,'Electric Current','electric-current','2016-05-26 16:23:25','2016-05-26 16:23:25'),(11,6,3,'Electrical Induction','electrical-induction','2016-05-26 16:23:25','2016-05-26 16:23:25'),(12,6,4,'Electromagnetic Waves','electromagnetic-waves','2016-05-26 16:23:25','2017-12-12 16:59:43'),(13,7,1,'Cathode Rays','cathode-rays','2016-05-26 16:23:25','2017-12-28 15:57:07'),(14,7,2,'Photoelectric Effect','photoelectric-effect','2016-05-26 16:23:25','2017-12-28 15:57:07'),(15,7,3,'Oil Drop Experiment','oil-drop-experiment','2016-05-26 16:23:25','2017-12-28 15:57:07'),(16,7,4,'Double Slit Experiment','double-slit-experiment','2016-05-26 16:23:25','2017-12-28 15:57:07'),(17,8,0,'Star System Evolution','star-system-evolution','2016-05-26 16:23:25','2016-05-26 16:23:25'),(18,8,1,'Globular Clusters','globular-clusters','2016-05-26 16:23:25','2016-05-26 16:23:25'),(19,9,0,'Single Star Systems','single-star-systems','2016-05-26 16:23:25','2016-05-26 16:23:25'),(20,9,1,'Binary Systems','binary-systems','2016-05-26 16:23:25','2016-05-26 16:23:25'),(21,9,2,'Double Binary Systems','double-binary-systems','2016-05-26 16:23:25','2016-05-26 16:23:25'),(23,1,4,'Gravity and Electronic Charge','gravity-and-electric-charge',NULL,'2017-12-12 17:00:00'),(24,7,0,'Gold Foil Experiment','gold-foil-experiment','2017-12-28 15:56:37','2017-12-28 15:57:07');

--
-- Table structure for table `article_comment`
--

CREATE TABLE `article_comment` (
  `article_comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_status_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`article_comment_id`),
  KEY `idx_article_comment_article_id` (`article_id`),
  KEY `idx_article_comment_parent_id` (`parent_id`),
  KEY `fk_article_comment_user_id` (`user_id`),
  KEY `fk_article_comment_comment_status_id` (`comment_status_id`),
  KEY `fk_article_comment_comment_type_id` (`comment_type_id`),
  CONSTRAINT `fk_article_comment_article_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`article_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_article_comment_comment_status_id` FOREIGN KEY (`comment_status_id`) REFERENCES `comment_status` (`comment_status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_article_comment_comment_type_id` FOREIGN KEY (`comment_type_id`) REFERENCES `comment_type` (`comment_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_article_comment_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `article_comment` (`article_comment_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_article_comment_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `article_comment`
--

INSERT INTO `article_comment` VALUES (105,0,2,1,17,NULL,NULL,'Repudiandae aut doloribus consequatur sint accusamus similique voluptas. Aut reprehenderit voluptatem occaecati ratione autem enim. Veniam voluptatem qui natus optio ut nostrum et totam.\n\nEst odio error a enim saepe commodi. Ipsum ut dolore autem soluta laboriosam quae qui.\n\nSunt ut ea nihil at quam. Similique ea qui commodi veniam officia velit temporibus. Libero vel qui placeat quaerat facilis perferendis at nihil. Non suscipit enim sit eaque eos.','2016-05-26 16:23:25','2016-05-26 16:23:25'),(106,0,2,1,18,NULL,NULL,'Saepe quos quis vel molestiae. Incidunt similique aut exercitationem molestiae quam consequatur ratione. Qui excepturi quia eos. Corporis neque quis est repellat totam dolor commodi.\n\nAutem ab facilis qui non enim. Debitis velit incidunt aspernatur eum mollitia iusto labore. Veniam saepe voluptatem aut pariatur. Quia autem temporibus et esse fugit ut officiis saepe.\n\nIncidunt ad sed omnis quia. Et enim odio quisquam amet rem.','2016-05-26 16:23:25','2016-05-26 16:23:25'),(162,0,2,55,23,NULL,NULL,'Test comment','2017-12-02 21:36:30','2017-12-02 21:37:44');

--
-- Table structure for table `article_group`
--

CREATE TABLE `article_group` (
  `article_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `segment` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `sequence` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`article_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `article_group`
--

INSERT INTO `article_group` VALUES (0,'Root','root',NULL,0,NULL,NULL),(1,'Core Concepts','core-concepts',0,0,NULL,'2017-12-10 22:09:51'),(2,'Atomic','atomic',0,1,NULL,NULL),(3,'Astro','astro',0,2,NULL,NULL),(4,'Core Concepts','core-concepts',2,0,NULL,NULL),(5,'Chemistry','chemistry',2,1,NULL,NULL),(6,'Electromagnetism','electromagnetism',2,2,NULL,NULL),(7,'Discoveries and Phenomena','discoveries-and-phenomena',2,3,NULL,NULL),(8,'Core Concepts','core-concepts',3,0,NULL,NULL),(9,'Star Systems','star-systems',3,1,NULL,NULL);

--
-- Table structure for table `article_tag`
--

CREATE TABLE `article_tag` (
  `article_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  KEY `idx_article_tag_article_id` (`article_id`),
  KEY `idx_article_tag_tag_id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `article_tag`
--


--
-- Table structure for table `comment_status`
--

CREATE TABLE `comment_status` (
  `comment_status_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`comment_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `comment_status`
--

INSERT INTO `comment_status` VALUES (1,'unverified','comment not verified',NULL,NULL),(2,'verified','comment verified',NULL,NULL);

--
-- Table structure for table `comment_type`
--

CREATE TABLE `comment_type` (
  `comment_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`comment_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `comment_type`
--

INSERT INTO `comment_type` VALUES (0,'article-comment',NULL),(1,'article-topic',NULL);

--
-- Table structure for table `login_provider_stats`
--

CREATE TABLE `login_provider_stats` (
  `login_provider_stats_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login_provider_id` int(10) unsigned NOT NULL,
  `access_count` int(10) unsigned NOT NULL,
  `last_accessed` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`login_provider_stats_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `login_provider_stats`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (42,'2016_01_10_002041_create_comment_type_table',1),(43,'2014_10_12_100000_create_password_resets_table',2),(44,'2016_01_09_000100_create_email_verification_table',2),(45,'2016_01_09_112309_create_article_group_table',2),(46,'2016_01_09_235703_create_article_table',2),(47,'2016_01_10_000600_create_user_status_table',2),(48,'2016_01_10_000650_create_user_role_table',2),(49,'2016_01_10_000754_create_user_table',2),(50,'2016_01_10_000800_add_foreign_keys_to_user_table',2),(51,'2016_01_10_000900_add_foreign_keys_to_email_verification_table',2),(52,'2016_01_10_000950_add_foreign_keys_to_password_resets_table',2),(53,'2016_01_10_000950_create_comment_status_table',2),(54,'2016_01_10_001833_create_topic_table',2),(55,'2016_01_10_001900_add_foreign_keys_to_topic_table',2),(56,'2016_01_10_002043_create_article_comment_table',2),(57,'2016_01_10_002044_add_foreign_keys_to_article_comment_table',2),(58,'2016_01_10_002103_create_topic_comment_table',2),(59,'2016_01_10_002104_add_foreign_keys_to_topic_comment_table',2),(60,'2016_02_16_112011_create_tag_table',2),(61,'2016_02_16_112819_create_article_tag_table',2),(62,'2016_05_20_101001_create_sessions_table',2),(63,'2017_01_05_124302_create_session_ubox',2),(72,'2018_05_24_081220_create_login_provider_table',3),(73,'2018_05_24_082759_create_login_provider_stats_table',3),(74,'2018_05_25_202821_create_socialite_user_table',3),(75,'2018_05_25_235334_add_foreign_keys_to_socialite_user',3);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8_unicode_ci,
  `payload` text COLLATE utf8_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('0xTwbst3TePhYZpPI4OjFAiG2LRlI5cvl62GjXNN',NULL,'139.162.119.197','Go-http-client/1.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT20yS3pvVWF5WXdWNDhPV1RKNjY2QUx2TkZVR3pvVzZyanhKcUlONCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527517358),('43t6SFb5bKma45Ddbk7hOQDtgJf9awO7Wi91aj3j',NULL,'180.76.15.148','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVjBVd24ydHk5VHEwMXRmUUxaUE5uUXZQTURDTWVIU2ZjNkRVSnhWdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly93d3cuYXN0cm9hdG9taWNtb2RlbC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527505446),('5YrKzTvvlxiKK22oEmfdgWviyEnB5f5G5MhOkUHc',NULL,'189.163.250.92','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWjFZZ2xGVDF5ak45cmZFTmJOSkxPaTljZTljc0ZKWWQzYk03bnhNNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527507849),('60Etyapuipbzah1AKxnPz3ngWaVcaT900tmaIPDt',NULL,'104.218.66.42','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicGdpZ2lVMmxEa2tHVW5nSllVY3lJSW9MWVF0c0YwNFFmcHlyd3Q2SSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527540812),('6dqu1tg9sWiwy7c9HO8JRTYsVupaDobT0w455tuh',NULL,'180.76.15.23','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaFpSQXY5S21oeWxqaThabE81bFoxVXJVdWVXYW5UVXUzZ3pjWG1oSCI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo2OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo4O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoxNzoiY29zKC14KSA9IC1jb3MoeCkiO31pOjE7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo5O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6MTtzOjY6ImFuc3dlciI7czoxNzoic2luKC14KSA9IC1zaW4oeCkiO31pOjI7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMDtzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MTc6InRhbigteCkgPSAtdGFuKHgpIjt9aTozO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MTE7czoxMToicXVlc3Rpb25faWQiO2k6MjtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aTo0O3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aTozO3M6NjoiYW5zd2VyIjtzOjE3OiJzZWMoLXgpID0gLXNlYyh4KSI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjEyO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6NDtzOjY6ImFuc3dlciI7czoxNzoiY3NjKC14KSA9IC1jc2MoeCkiO31pOjU7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMztzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MTc6ImNvdCgteCkgPSAtY290KHgpIjt9fXM6MTI6ImFuc3dlclR5cGVJRCI7aTo0O31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo3NToiaHR0cDovL21haWwueHBvcnRwcm8uY29tL2FydGljbGVzL2NvcmUtY29uY2VwdHMvZ3Jhdml0eS1hbmQtZWxlY3RyaWMtY2hhcmdlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527504974),('AhDDEtDTAak9Dvnzp45yhhnJAB1lf3MPJFHjsWar',NULL,'180.76.15.157','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMW5Ed01zbWlFSVZXVnVhNlhNMjN0WjU1d25oOEVwSVA0MkE2VDg3WiI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo2OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo4O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoxNzoiY29zKC14KSA9IC1jb3MoeCkiO31pOjE7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo5O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6MTtzOjY6ImFuc3dlciI7czoxNzoic2luKC14KSA9IC1zaW4oeCkiO31pOjI7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMDtzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MTc6InRhbigteCkgPSAtdGFuKHgpIjt9aTozO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MTE7czoxMToicXVlc3Rpb25faWQiO2k6MjtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aTo0O3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aTozO3M6NjoiYW5zd2VyIjtzOjE3OiJzZWMoLXgpID0gLXNlYyh4KSI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjEyO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6NDtzOjY6ImFuc3dlciI7czoxNzoiY3NjKC14KSA9IC1jc2MoeCkiO31pOjU7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMztzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MTc6ImNvdCgteCkgPSAtY290KHgpIjt9fXM6MTI6ImFuc3dlclR5cGVJRCI7aTo0O31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo3NDoiaHR0cDovL21haWwueHBvcnRwcm8uY29tL2FydGljbGVzL2F0b21pYy9lbGVjdHJvbWFnbmV0aXNtL2VsZWN0cmljLWN1cnJlbnQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527500974),('CDnuUcYll2qoBeSRzlk6Jqkl978NwirdR9iGNyRM',NULL,'83.211.85.37','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaFduRGwxQWNqSnVDcmZ2c0xINE1lR1ljZkVvcG1tbUpMcEp0WXkwSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527501954),('CHnxpMJC4Ofa2dc5OEVQiVSEt25ioTAWq1y6rfCp',NULL,'180.76.15.134','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiV01kNVF0SWdkblF0TXY4R2wweUF6cmVPNHJSbFBuS3VWdzdVUGpOeCI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo2OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo4O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoxNzoiY29zKC14KSA9IC1jb3MoeCkiO31pOjE7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo5O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6MTtzOjY6ImFuc3dlciI7czoxNzoic2luKC14KSA9IC1zaW4oeCkiO31pOjI7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMDtzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MTc6InRhbigteCkgPSAtdGFuKHgpIjt9aTozO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MTE7czoxMToicXVlc3Rpb25faWQiO2k6MjtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aTo0O3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aTozO3M6NjoiYW5zd2VyIjtzOjE3OiJzZWMoLXgpID0gLXNlYyh4KSI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjEyO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6NDtzOjY6ImFuc3dlciI7czoxNzoiY3NjKC14KSA9IC1jc2MoeCkiO31pOjU7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMztzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MTc6ImNvdCgteCkgPSAtY290KHgpIjt9fXM6MTI6ImFuc3dlclR5cGVJRCI7aTo0O31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo3NDoiaHR0cDovL21haWwueHBvcnRwcm8uY29tL2FydGljbGVzL2FzdHJvL3N0YXItc3lzdGVtcy9kb3VibGUtYmluYXJ5LXN5c3RlbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527502974),('dKElZoanpmsYHT7JiPrzS6WhuCKNsGgLQaO3yt8s',NULL,'66.249.65.197','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZEFJVTBzaWlkYkhmQWU3NENhNjB6d1RZWWc1azRHT1p2bEQxUzRlMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527516868),('DnurX7cE4UYonKRv2WPvsctrA5t5xalGNV8nhnxY',NULL,'180.76.15.23','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUThJaWZpWUJiSXlpNmNNY2VoODdHMThhUmIwNjlGUm5BbGtieEZDcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTY6Imh0dHA6Ly9jc3NtYW5hZ2VyLmNvbS91bml2ZXJzZS1zYW5kYm94L3NpbXVsYXRpb24tZWRpdG9yIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527516319),('GwA3AjKVmZ5LfX9b45jLBuT1RNlUhCJWzCDo7ioT',NULL,'184.94.240.92','Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOVBTd2hJU25YZG5yc3BrQ25nSnIzZGRiOWQ0ODYxVnNQQXFZUDhyUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly93d3cuYXN0cm9hdG9taWNtb2RlbC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527521434),('H4nCEa2fkC9tPFcvUlzens6Toy6z43CBbwpNNhgA',NULL,'5.255.250.180','Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVmpmQzdsbGgyWE8wb2lZUDFGSndxZmdjd3VEcTVvak4yeG5Edm56UyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9saTIxMy0xMzIubWVtYmVycy5saW5vZGUuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527540543),('h97QIagu6IBZlJbScLNtMsGRHY0wdBby0wywkdyQ',NULL,'201.103.178.2','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWHNuWnByNnRwY25ZMkVpM0J3SmNPYUFwTGo2WmFvWWZqd0ZZQ3VzaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527539067),('hLfPx15tkiuHE2Z9TJLW9HNjm7c0CCFvzonm63pt',NULL,'180.76.15.33','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMUt3N3NocW4zSWFMTmFEWmZGVnVDaDBlMnlOejZpMnVFUTNVazZZNCI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo2OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo4O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoxNzoiY29zKC14KSA9IC1jb3MoeCkiO31pOjE7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo5O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6MTtzOjY6ImFuc3dlciI7czoxNzoic2luKC14KSA9IC1zaW4oeCkiO31pOjI7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMDtzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MTc6InRhbigteCkgPSAtdGFuKHgpIjt9aTozO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MTE7czoxMToicXVlc3Rpb25faWQiO2k6MjtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aTo0O3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aTozO3M6NjoiYW5zd2VyIjtzOjE3OiJzZWMoLXgpID0gLXNlYyh4KSI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjEyO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6NDtzOjY6ImFuc3dlciI7czoxNzoiY3NjKC14KSA9IC1jc2MoeCkiO31pOjU7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMztzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MTc6ImNvdCgteCkgPSAtY290KHgpIjt9fXM6MTI6ImFuc3dlclR5cGVJRCI7aTo0O31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo4NzoiaHR0cDovL21haWwueHBvcnRwcm8uY29tL2FydGljbGVzL2F0b21pYy9kaXNjb3Zlcmllcy1hbmQtcGhlbm9tZW5hL2dvbGQtZm9pbC1leHBlcmltZW50Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527515800),('i3xZUf4rVkEX1xMLpzbIRolmLEdpmhgK0qYaUbyM',NULL,'106.11.156.208','YisouSpider','YTozOntzOjY6Il90b2tlbiI7czo0MDoiajFDekJ2ZUZpZUQ5eURHa3JDNDNyczZaSTEwMllQVUM5UXlzaFhHNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527517424),('lHWzfXaYeJYzN8u4kk0mfVZL5eNLZ9x5wbhC7EVN',NULL,'93.158.161.141','Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYkJ1SENaTHJ6M2k2YXFDeDhsOEVRTU9ObnYxaW5IVXA2dXBCNWFnNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly93d3cuYXN0cm9hdG9taWNtb2RlbC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527540542),('mS5uZnkEGzcX4DSIZ474ru73z3XVDYYJhgp4E8u5',NULL,'150.242.255.183','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkZXem80UWJSbGFhZkxlNmd4alFIbHpmQ2FtT0pwbUI3OU5WN2tQOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527523489),('oLJREtarVWVCOv8L5Wj2RMjjBFVAzSata00Ngz1O',NULL,'31.184.193.154','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0tRZG85TXVyQmpvWTBXTWozZUFlVW92Tmc1ZFBLNUphZXlPeXd2VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527516359),('Q6dkKearz96K4BUdeCamX25Rspm5tg0wQpieywry',NULL,'179.109.198.246','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlpyaVREMFJzS3JQZU9lN1p2bVNEck5jdDRsemFaY0k0MDlPNm05cyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527528564),('QgTwrEuhzUHMld3i9zwjI0lLeMVOABJLVaUYZdaI',NULL,'180.76.15.142','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2tlTllQVWl1SkZTMjZzeEdGQW5VV3VqTVd1MlFXNU5VU0JTUmtIYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZy9ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527513134),('qi6wDXCysDdm62Yoz3l3QA9c1Y8ZwwaOlkGKcIeT',NULL,'95.13.0.38','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoia21IdlA0dkZSS0pGY0tEV3dCQXcwenVYTEFrUXh6QlZ2R0g2QkpsQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527512365),('QK7vRtZGmKznrw39ZYSdwEREokrcBNTb3oxZCJ3y',NULL,'93.158.161.141','Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN3B1Z0RrUjBHdmJMQ0dVWGNteXQ1bEVnREtETFk3REg5SmtUNmtKcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527540542),('Qu3ZiaM8xRuN7rra9s7Pp9eAiUv3gRYaJ1zWcDWI',NULL,'17.58.101.124','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5 (Applebot/0.1; +http://www.apple.com/go/applebot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiczQxZzU5NmpwWVFNUFJUeHM4N0s0SEtBREVlendEaVBPVnA0NVJRNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly93d3cuYXN0cm9hdG9taWNtb2RlbC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527521239),('QyR4kRvwxHPGitPO5eQS68oi2DQcEGw3atCv85rJ',NULL,'189.78.15.253','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYlNaYkMzbEJUZUFTdW53Vk0xaFBBY0ZCRTVPcVFETWN5QnZMMU1YRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527540157),('RFYF3XeaBjsMrYwdvhYHCX2EmxGhtGYnk4RrYZ2u',NULL,'201.140.165.62','Mozilla/5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQzdPZDhWMTVjbU5mdFBDeE56T1pJSTNZb1BuRjZDZGZOT3Yyakx3dCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIvaW5kZXgucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1527533007),('RpOqitFeVyI2yRpwrv1F8ejENHAisnWVpX6z1rTR',NULL,'189.232.3.169','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDE0NllWWUZyWWxWTXk2Z283dGVXaXlsYnJtc0tuZUtlejBHckh6SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527535427),('Rr25SO6vSgBPZI37f5rAB4NHHCB0JukuOGFzwYpF',NULL,'180.76.15.151','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibnRUcmlESlpaWkMzV042Q0tzbzNmTjhsaGwxOWdwYmh5T3lvN0JmdiI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo3OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjE7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6MjtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoyOiIyMiI7fWk6MTthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjI7czoxMToicXVlc3Rpb25faWQiO2k6MTtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aToyO3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aToxO3M6NjoiYW5zd2VyIjtzOjI6IjI4Ijt9aToyO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MztzOjExOiJxdWVzdGlvbl9pZCI7aToxO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjI7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MDtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MjoiMzQiO31pOjM7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo0O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjE7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6MjtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MztzOjY6ImFuc3dlciI7czoyOiIzNyI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjU7czoxMToicXVlc3Rpb25faWQiO2k6MTtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aToyO3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjE7czo4OiJzZXF1ZW5jZSI7aTo0O3M6NjoiYW5zd2VyIjtzOjI6IjQ0Ijt9aTo1O2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6NjtzOjExOiJxdWVzdGlvbl9pZCI7aToxO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjI7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MDtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MjoiNDciO31pOjY7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo3O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjE7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6MjtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6NjtzOjY6ImFuc3dlciI7czoyOiI1MiI7fX1zOjEyOiJhbnN3ZXJUeXBlSUQiO2k6Mjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODU6Imh0dHA6Ly9tYWlsLndvcmt0aW1lc3R1ZGlvLmNvbS9hcnRpY2xlcy9hdG9taWMvZGlzY292ZXJpZXMtYW5kLXBoZW5vbWVuYS9jYXRob2RlLXJheXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527537843),('U7zkpnP0idRTbk4uFFTThZWjBT5y2VLFDyFrc2UR',NULL,'201.108.16.116','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNDFTRjJuSGlWU1ZqRlljQUJvS2tMRlJuRWpFMkxxZlQ0R2hncEdlbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527500757),('u9cwpoiEFTZ6dTxjKEmVvftnz7gJISseL41FBs94',NULL,'180.76.15.145','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTzRFWGZXa0xRWjNKRUE2UU9TcHhKcEhMcGhJajh0RW1UbnpabVZvTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527532528),('uyAGwSYSEYrMCt8zJViolPaoVnmosnVjZ6sUnkNa',NULL,'82.134.48.248','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVFQ4ZkFMUkFVYzFyWm1ZSDFVeWtFMXdKdGF2NTlLM2l6VU1zeFpCcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527504997),('VSCl0W5583Rd9gYlb64ug10gpeVhweCSIlV8eo2I',NULL,'139.162.119.197','Go-http-client/1.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkVXaldVU0pndlJXU255MnFGdm14NXZpS0NqSHJRdjhiamF2WTdFMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527532900),('WeeQn65bhYxzEicb2gVx6CkLIdJR6CTSGvRbwCuB',NULL,'207.46.13.98','Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidWZnOU1hU2RxaHZBdWZFZXVpSk1DdkR1RFVoOE1wTGVPdkdqOHZjdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527524119),('WFQI5o9EN7LTI0Af2kXe2k2RhBvbE6Rm5oTnTYaI',NULL,'138.36.188.27','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYXdjTVpSNEpjelF3d0RJZzFXaTJ6V0dVbHFuZXRRTGdSNzBjYXRlMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly8xNzMuMjU1LjIwMy4xMzIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527527780),('Xnit09TItFTIfXeMuPiPfswN1tEHZLt7xOI9rqQu',NULL,'77.88.47.83','Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY2U2RmlnbldhRzdacnlFczl4bmd6U0owSDFPR2c3anE4YU14U2hFcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527522130),('xQzbnp329sN0xepqq54alLobZpNo6Ltw2wKQ3Uhc',NULL,'157.55.39.135','Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMzlSdFFLUWZ0djVuczZ3NWRyVExDNEFmdjVVd0JpUTB1WDJaSGQxUSI7czoxNDoiY2FwdGNoYS1hbnN3ZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6MTI6ImF0dGVtcHRzTGVmdCI7aTozO3M6NzoiYW5zd2VycyI7YTo2OntpOjA7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo4O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aTowO3M6ODoic2VxdWVuY2UiO2k6MDtzOjY6ImFuc3dlciI7czoxNzoiY29zKC14KSA9IC1jb3MoeCkiO31pOjE7YTo2OntzOjk6ImFuc3dlcl9pZCI7aTo5O3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6MTtzOjY6ImFuc3dlciI7czoxNzoic2luKC14KSA9IC1zaW4oeCkiO31pOjI7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMDtzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjI7czo2OiJhbnN3ZXIiO3M6MTc6InRhbigteCkgPSAtdGFuKHgpIjt9aTozO2E6Njp7czo5OiJhbnN3ZXJfaWQiO2k6MTE7czoxMToicXVlc3Rpb25faWQiO2k6MjtzOjE0OiJhbnN3ZXJfdHlwZV9pZCI7aTo0O3M6MTQ6ImNvcnJlY3RfYW5zd2VyIjtpOjA7czo4OiJzZXF1ZW5jZSI7aTozO3M6NjoiYW5zd2VyIjtzOjE3OiJzZWMoLXgpID0gLXNlYyh4KSI7fWk6NDthOjY6e3M6OToiYW5zd2VyX2lkIjtpOjEyO3M6MTE6InF1ZXN0aW9uX2lkIjtpOjI7czoxNDoiYW5zd2VyX3R5cGVfaWQiO2k6NDtzOjE0OiJjb3JyZWN0X2Fuc3dlciI7aToxO3M6ODoic2VxdWVuY2UiO2k6NDtzOjY6ImFuc3dlciI7czoxNzoiY3NjKC14KSA9IC1jc2MoeCkiO31pOjU7YTo2OntzOjk6ImFuc3dlcl9pZCI7aToxMztzOjExOiJxdWVzdGlvbl9pZCI7aToyO3M6MTQ6ImFuc3dlcl90eXBlX2lkIjtpOjQ7czoxNDoiY29ycmVjdF9hbnN3ZXIiO2k6MTtzOjg6InNlcXVlbmNlIjtpOjU7czo2OiJhbnN3ZXIiO3M6MTc6ImNvdCgteCkgPSAtY290KHgpIjt9fXM6MTI6ImFuc3dlclR5cGVJRCI7aTo0O31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo5MjoiaHR0cDovL2FzdHJvYXRvbWljbW9kZWwub3JnL2FydGljbGVzL2F0b21pYy9kaXNjb3Zlcmllcy1hbmQtcGhlbm9tZW5hL2RvdWJsZS1zbGl0LWV4cGVyaW1lbnQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1527529729),('ZlwnzL7NsE6XVZ6IxSLNlGXwLO15QwQQCQw6wqH5',NULL,'180.76.15.7','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidDlEZHR5Ynl3czE4SGJ1eEg2Y0FjczA5WFoxNUNubkJRdFRISW5BTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527518635),('zYf8zBnxwZguqqwUqT9VaXHiuCpEDqHOKfFRofo6',NULL,'180.76.15.154','Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiU3E3WHRLc0VzYnM0am5mZTBuNUdrV3NNdjZUYkFwUFpOeXdWcWtLTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHA6Ly9tYWlsLnhwb3J0cHJvLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527519800),('Zz9gY2ebrOQmpHs9T9UNg1qYwkizq32DvYr8u4qL',NULL,'207.46.13.98','Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1dVajRMSlBLdE03M2FzQmp5OUNJU1JvTXdQMmZQMk5vYjRseFhFOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9hc3Ryb2F0b21pY21vZGVsLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1527528831);

--
-- Table structure for table `tag`
--

CREATE TABLE `tag` (
  `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tag`
--

INSERT INTO `tag` VALUES (1,'atomic physics','2018-01-08 03:29:33','2018-01-08 03:29:33'),(2,'atomic experiments','2018-01-08 03:29:33','2018-01-08 03:29:33'),(3,'astronomy','2018-01-08 03:29:33','2018-01-08 03:29:33'),(4,'astrophysics','2018-01-08 03:29:33','2018-01-08 03:29:33'),(5,'chemistry','2018-01-08 03:29:33','2018-01-08 03:29:33');

--
-- Table structure for table `topic`
--

CREATE TABLE `topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `title` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`topic_id`),
  KEY `idx_topic_user_id` (`user_id`),
  KEY `idx_topic_article_id` (`article_id`),
  CONSTRAINT `fk_topic_article_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`article_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_topic_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `topic`
--


--
-- Table structure for table `topic_comment`
--

CREATE TABLE `topic_comment` (
  `topic_comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `topic_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `comment_status_id` int(10) unsigned NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`topic_comment_id`),
  KEY `idx_topic_comment_user_id` (`user_id`),
  KEY `idx_topic_comment_topic_id` (`topic_id`),
  KEY `fk_topic_comment_parent_id_idx` (`parent_id`),
  KEY `fk_topic_comment_comment_status_id` (`comment_status_id`),
  CONSTRAINT `fk_topic_comment_comment_status_id` FOREIGN KEY (`comment_status_id`) REFERENCES `comment_status` (`comment_status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_topic_comment_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `topic_comment` (`topic_comment_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_topic_comment_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `topic` (`topic_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_topic_comment_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `topic_comment`
--


--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `user_role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` VALUES (1,'Subscriber','subscriber'),(2,'Contributor','contributor'),(3,'Author','author'),(4,'Editor','editor'),(5,'Administrator','administrator'),(6,'Super Admin','super_admin');

--
-- Table structure for table `user_status`
--

CREATE TABLE `user_status` (
  `user_status_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_status`
--

INSERT INTO `user_status` VALUES (1,'unverified','email not verified',NULL,NULL),(2,'verified','email verified',NULL,NULL),(4,'guest','guest',NULL,NULL),(8,'registered','registered user',NULL,NULL);


