--
-- Host: localhost    Database: kyuso
-- ------------------------------------------------------


--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `show_top` tinyint(1) NOT NULL DEFAULT '0',
  `show_search` smallint NOT NULL DEFAULT '0',
  `parent_id` int NOT NULL DEFAULT '0',
  `position` int NOT NULL DEFAULT '0',
  `is_activated` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `areas`
--


--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `editor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'gutenberg',
  `gu_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `allow_amp` tinyint(1) NOT NULL DEFAULT '0',
  `seo_robots` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_at` datetime DEFAULT NULL,
  `important` int NOT NULL DEFAULT '0',
  `shop_id` int DEFAULT NULL,
  `fortune_teller_id` int DEFAULT NULL,
  `view_number` int NOT NULL DEFAULT '0',
  `user_id` int DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'article',
  `question_status` int NOT NULL DEFAULT '0',
  `created_by` int NOT NULL DEFAULT '1',
  `is_activated` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` VALUES (1,'2322323232','2322323232',NULL,'gutenberg','<!-- wp:paragraph -->\n<p>2322323232</p>\n<!-- /wp:paragraph -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>2322323232</p>\n<!-- /wp:paragraph --></div>','b78cc28f95940fc8335a4015b4358ad7.png',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2022-08-29 15:48:48',0,NULL,NULL,0,1,1,'article',0,1,1,0,'2022-08-29 01:49:01','2022-08-29 03:04:55'),(2,'23232 232323 wwwwwwwww','23232-232323-wwwwwwwww','This is content demo','gutenberg','<!-- wp:paragraph -->\n<p>3454454</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>wew</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>2323232</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong>Data of post</strong> and this is <a href=\"http://google.com.vn\">link</a> of data </p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong><a href=\"https://uramori.jp/\">占い</a>スクール</strong>・<strong><a href=\"https://uramori.jp/\">占い</a>教室</strong>では、<a href=\"https://uramori.jp/\">占い師</a>を目指そうと決めても実際にはどのように勉強したりレールを作って良いかを学べます。<a href=\"https://uramori.jp/\">占い師</a>の知識はあっても<a href=\"https://uramori.jp/\">占い師</a>になっていくためのスキルの学び方がわからなかったり、流れなども未知になります。スクールでは実際にどのように<a href=\"https://uramori.jp/\">占い師</a>をしていったら良いのかなども教えてくれるので、即現場に出れるプロセスをスクールで学ぶことが出来ます。スクールによってもカラーが違いますし、掛かるお金や学ぶ時間もそれぞれなので、今回は<a href=\"https://uramori.jp/\">占い</a>を学ぶスクールにフォーカスしてお伝えしていきたいと思いますので、興味のある方は是非参考にしてみてください。</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\n<figure class=\"wp-block-image size-large\"><img src=\"https://uramori.jp/column/wp-content/uploads/2021/01/image-1024x946.jpg\" alt=\"\"/></figure>\n<!-- /wp:image -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>3454454</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>wew</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>2323232</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong>Data of post</strong> and this is <a href=\"http://google.com.vn\">link</a> of data </p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong><a href=\"https://uramori.jp/\">占い</a>スクール</strong>・<strong><a href=\"https://uramori.jp/\">占い</a>教室</strong>では、<a href=\"https://uramori.jp/\">占い師</a>を目指そうと決めても実際にはどのように勉強したりレールを作って良いかを学べます。<a href=\"https://uramori.jp/\">占い師</a>の知識はあっても<a href=\"https://uramori.jp/\">占い師</a>になっていくためのスキルの学び方がわからなかったり、流れなども未知になります。スクールでは実際にどのように<a href=\"https://uramori.jp/\">占い師</a>をしていったら良いのかなども教えてくれるので、即現場に出れるプロセスをスクールで学ぶことが出来ます。スクールによってもカラーが違いますし、掛かるお金や学ぶ時間もそれぞれなので、今回は<a href=\"https://uramori.jp/\">占い</a>を学ぶスクールにフォーカスしてお伝えしていきたいと思いますので、興味のある方は是非参考にしてみてください。</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\n<figure class=\"wp-block-image size-large\"><img src=\"https://uramori.jp/column/wp-content/uploads/2021/01/image-1024x946.jpg\" alt=\"\"/></figure>\n<!-- /wp:image --></div>','283a4ac94d8fd07afaaadb005239857d.jpeg',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2022-08-29 15:51:31',0,NULL,NULL,0,1,1,'article',0,1,1,0,'2022-08-29 01:52:35','2022-09-06 13:55:27'),(3,'This is top question','this-is-top-question','This is top question','gutenberg','<!-- wp:paragraph -->\n<p>awewwewe</p>\n<!-- /wp:paragraph -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>awewwewe</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'3cb30efef3fb3ea1440ab7aa58601317','2022-09-07 01:04:40',0,NULL,NULL,0,1,1,'article',0,1,1,0,'2022-09-06 11:05:51','2022-09-06 11:06:05'),(4,'23232','23232','23223','gutenberg','<!-- wp:paragraph -->\n<p>23232</p>\n<!-- /wp:paragraph -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>23232</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'3a77767490423d26b1dce295dc362c05','2022-09-07 01:10:10',0,NULL,NULL,0,1,0,'article',0,1,0,0,'2022-09-06 11:10:21','2022-09-13 10:51:11'),(5,'434343','434343','wwwwwwwwwwwww','tinymce',NULL,'',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2022-09-07 01:12:40',0,NULL,NULL,0,1,1,'question',3,1,1,0,'2022-09-06 11:12:46','2022-09-13 12:51:48'),(6,'5465555555','5465555555','565565','tinymce',NULL,'<div class=\"gutenberg__content wp-embed-responsive\"><!-- wp:paragraph -->\n<p>3433</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2022-09-07 01:13:24',0,NULL,NULL,0,1,1,'question',1,1,1,0,'2022-09-06 11:13:31','2022-09-13 12:50:46'),(7,'676767','676767','67676','gutenberg','<!-- wp:paragraph -->\n<p>6766</p>\n<!-- /wp:paragraph -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>6766</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2022-09-07 01:13:39',0,NULL,NULL,0,1,1,'news',0,1,1,0,'2022-09-06 11:13:46','2022-09-06 11:13:46'),(8,'32323','32323','2323','tinymce',NULL,'<p>2222222222</p>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'c2b7c5e1d888605db905c04cd6e2ac91','2022-09-06 22:14:47',5,NULL,NULL,0,1,0,'question',3,1,0,0,'2022-09-06 15:14:47','2022-09-13 12:54:13'),(9,'11111111111','11111111111','111111111111111','tinymce',NULL,'<div class=\"gutenberg__content wp-embed-responsive\">\n<p>11111111111111111</p>\n</div>','f61b9f4453441fefb4c281cc398410f2.png',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'4c7c529f5340b2eb24772a6c9aa4d2bd','2022-09-06 22:15:13',5,NULL,NULL,0,1,1,'question',1,1,1,0,'2022-09-06 15:15:13','2022-09-13 12:54:26'),(10,'tote jkaoiw','tote-jkaoiw','ajpoew','gutenberg',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'d54d1165698ecb4a7aeaf7b0f251c088','2022-09-06 22:34:51',5,NULL,NULL,0,1,0,'question',0,1,0,0,'2022-09-06 15:34:51','2022-09-06 15:34:51'),(11,'2322','2322','2322','tinymce','2222222222222','<div class=\"gutenberg__content wp-embed-responsive\"><!-- wp:paragraph -->\n<p>ewewwwe wewe wew</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'d61b3ce53bcef1f57dd6a8a91b4f977a','2022-09-06 22:35:43',5,NULL,NULL,0,112,1,'question',1,1,1,0,'2022-09-06 15:35:43','2022-11-08 21:02:50'),(12,'3343','3343','34343','gutenberg','<!-- wp:paragraph -->\n<p>343433</p>\n<!-- /wp:paragraph -->','<div class=\'gutenberg__content wp-embed-responsive\'><!-- wp:paragraph -->\n<p>343433</p>\n<!-- /wp:paragraph --></div>',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'3958b213fe39bc9fbe0aa3c221a53462','2022-09-14 00:51:27',0,NULL,NULL,0,1,0,'article',0,1,0,0,'2022-09-13 10:51:32','2022-09-13 10:51:32'),(13,'22 555888 88888 8888','22-555888-88888-8888','22 555888 88888 8888','tinymce',NULL,'<div class=\"gutenberg__content wp-embed-responsive\"><!-- wp:paragraph -->\n<p>22222222222222 awawe</p>\n<p>wew</p>\n<p><img class=\"wscnph\" src=\"data:image/png;base64,[encoded data, 512714 characters]