--
-- Host: localhost    Database: starter_cms
-- ------------------------------------------------------


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `alt_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extra_fields` json DEFAULT NULL,
  `meta_data` json NOT NULL,
  `settings` json NOT NULL,
  `collection_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `_lft` int unsigned NOT NULL DEFAULT '0',
  `_rgt` int unsigned NOT NULL DEFAULT '0',
  `parent_id` int unsigned DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_categories__lft__rgt_parent_id_index` (`_lft`,`_rgt`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Home','home',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit animoo id est laborum.</p>',NULL,'published','public_ro','{\"extra_field_1\": \"Paris\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": \"fr_FR\", \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"Starter CMS\", \"structured_data\": \"[\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"Organization\\\"\\r\\n  },\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"BreadcrumbList\\\"\\r\\n  }\\r\\n]\", \"meta_name_robots\": null, \"meta_og_description\": \"I am aware that i am using the robots.txt generator at my own risk. No liability will be accepted by Ryte for errors or missing indexing of the website.\", \"meta_name_description\": \"I am aware that i am using the robots.txt generator at my own risk. No liability will be accepted by Ryte for errors or missing indexing of the website.\"}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',1,2,NULL,NULL,NULL,1,1,'2022-07-15 05:13:24','2023-12-03 09:53:15'),(2,'Genre','genre',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,'published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',3,14,NULL,NULL,NULL,1,1,'2022-07-15 05:13:52','2023-12-08 10:03:59'),(3,'Drama','drama',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboroum.</p>','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboru.','published','public_ro','{\"extra_field_1\": \"Happy reading\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"Drama\", \"canonical_link\": \"https://sites.codalia.fr/starter-cms/public/blog/category/3/drama\", \"meta_page_title\": \"Drama\", \"structured_data\": \"[\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"Organization\\\"\\r\\n  },\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"BreadcrumbList\\\"\\r\\n  }\\r\\n]\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": \"Duis aute irure dolor in reprehenderit ien voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa\", \"meta_name_description\": \"Duis aute irure dolor in reprehenderit ien voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa\"}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"title_asc\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',4,5,2,NULL,NULL,1,1,'2022-07-15 05:14:15','2023-12-08 10:03:59'),(4,'Classics','classics',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpat qui officia deserunt molliit anim id est laaaborum.</p>',NULL,'published','public_ro','{\"extra_field_1\": \"Marketing\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"order_asc\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',6,7,2,NULL,NULL,1,1,'2022-07-15 05:14:55','2023-09-05 14:11:22'),(5,'Science fiction','science-fiction',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Ecrans de différentes tailles montrant l\'aspect responsive d\'un site internet créé par Codalia','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',8,9,2,NULL,NULL,1,1,'2022-07-15 05:15:19','2023-12-08 10:03:59'),(6,'Thriller','thriller',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,'published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',10,11,2,NULL,NULL,1,1,'2022-07-15 05:15:43','2023-08-30 09:38:29'),(7,'Authors','authors',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,'published','public_ro','{\"extra_field_1\": \"The authors of the books\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"title_asc\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',15,28,NULL,NULL,NULL,1,1,'2022-07-18 15:10:18','2023-08-30 09:40:30'),(8,'Heroic fantasy','heroic-fantasy',NULL,'<p>Script that checks fields values will say value is pretty null, which is even more confusing for the user as s/he can see text is there, and can assume it is valid, leading to confusing delete-one insert one small character.</p>',NULL,'published','public_ro','{\"extra_field_1\": \"Duis aute irure dolor in reprehenderit\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"Heroic fantasy\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"global_setting\", \"show_image\": \"global_setting\", \"show_search\": \"global_setting\", \"post_ordering\": \"title_asc\", \"show_post_image\": \"global_setting\", \"show_description\": \"global_setting\", \"show_post_excerpt\": \"global_setting\", \"show_subcategories\": \"global_setting\", \"show_post_categories\": \"global_setting\"}','post',12,13,2,NULL,NULL,1,1,'2022-09-13 08:44:33','2023-09-02 04:44:53'),(9,'Boris Vian','boris-vian',NULL,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</p>','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',16,17,7,NULL,NULL,1,1,'2022-11-04 09:29:21','2023-08-30 09:40:33'),(10,'Georges Orwell','georges-orwell',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p>','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"Georges Orwell\", \"canonical_link\": null, \"meta_page_title\": \"Georges Orwell\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\", \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',18,19,7,NULL,NULL,1,1,'2023-07-01 14:49:22','2023-08-30 09:40:37'),(11,'Albert Camus','albert-camus',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": \"https://codalia.fr/blog/17/cms-vs-framework\", \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"Albert Camus\", \"canonical_link\": null, \"meta_page_title\": \"Albert Camus\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\", \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',20,21,7,NULL,NULL,1,1,'2023-07-15 08:01:58','2023-08-30 09:40:42'),(12,'Truman Capote','truman-capote',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumum.</p>','velit esse cillum dolore eu fugiat nulla pariatur. Excepteur','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"Truman Capote\", \"canonical_link\": null, \"meta_page_title\": \"Truman Capote\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',22,23,7,NULL,NULL,2,2,'2023-08-18 14:24:31','2023-09-01 15:11:26'),(13,'John Irving','john-irving',NULL,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia','published','public_ro','{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"1\", \"show_image\": \"1\", \"show_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}','post',26,27,7,NULL,NULL,2,1,'2023-08-30 13:36:53','2023-12-08 10:03:59');

--
-- Table structure for table `categorizables`
--

CREATE TABLE `categorizables` (
  `category_id` int unsigned DEFAULT NULL,
  `categorizable_id` int unsigned DEFAULT NULL,
  `categorizable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categorizables`
--

INSERT INTO `categorizables` VALUES (3,1,'App\\Models\\Post'),(4,1,'App\\Models\\Post'),(4,2,'App\\Models\\Post'),(1,3,'App\\Models\\Post'),(3,3,'App\\Models\\Post'),(4,3,'App\\Models\\Post'),(1,4,'App\\Models\\Post'),(3,4,'App\\Models\\Post'),(2,5,'App\\Models\\Post'),(4,5,'App\\Models\\Post'),(1,6,'App\\Models\\Post'),(4,6,'App\\Models\\Post'),(1,7,'App\\Models\\Post'),(6,7,'App\\Models\\Post'),(1,8,'App\\Models\\Post'),(6,8,'App\\Models\\Post'),(5,9,'App\\Models\\Post'),(4,10,'App\\Models\\Post'),(10,10,'App\\Models\\Post'),(4,11,'App\\Models\\Post'),(8,11,'App\\Models\\Post'),(3,12,'App\\Models\\Post'),(4,12,'App\\Models\\Post'),(4,13,'App\\Models\\Post'),(3,14,'App\\Models\\Post'),(4,14,'App\\Models\\Post'),(4,15,'App\\Models\\Post'),(3,16,'App\\Models\\Post'),(4,16,'App\\Models\\Post'),(3,17,'App\\Models\\Post'),(4,17,'App\\Models\\Post'),(4,18,'App\\Models\\Post');

--
-- Table structure for table `category_group`
--

CREATE TABLE `category_group` (
  `category_id` bigint unsigned NOT NULL,
  `group_id` bigint unsigned NOT NULL,
  KEY `category_group_category_id_foreign` (`category_id`),
  KEY `category_group_group_id_foreign` (`group_id`),
  CONSTRAINT `category_group_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `category_group_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_group`
--

INSERT INTO `category_group` VALUES (3,1),(5,1),(2,1),(13,1);

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `text` text COLLATE utf8mb4_unicode_ci,
  `owned_by` bigint unsigned NOT NULL,
  `commentable_id` int unsigned DEFAULT NULL,
  `commentable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES (1,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',3,6,'App\\Models\\Post','2023-08-25 08:53:56','2023-08-25 08:53:56'),(2,'<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',3,5,'App\\Models\\Post','2023-08-25 09:00:57','2023-08-25 09:00:57');

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `contacts`
--

INSERT INTO `contacts` VALUES (1,'Marcel Bergeron','codalia.dubya+levesque@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-19 09:35:23','2022-08-19 09:35:23'),(2,'Brigitte Lévesque','codalia.dubya+levesque@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-19 13:01:41','2022-08-19 13:01:41'),(3,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-19 13:25:00','2022-08-19 13:25:00'),(4,'Brigitte Lévesque','codalia.dubya+levesque@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-19 13:36:25','2022-08-19 13:36:25'),(5,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-19 13:44:27','2022-08-19 13:44:27'),(6,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-26 08:57:01','2022-08-26 08:57:01'),(7,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-26 08:58:27','2022-08-26 08:58:27'),(8,'Brigitte Lévesque','codalia.dubya+levesque@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread',NULL,NULL),(9,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-26 12:08:32','2022-08-26 12:08:32'),(10,'Albert Camus','lucas.sanner+camus@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-26 12:19:18','2022-08-26 12:19:18'),(11,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-31 12:06:42','2022-08-31 12:06:42'),(12,'Brigitte Lévesque','codalia.dubya+levesque@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-31 12:11:27','2022-08-31 12:11:27'),(13,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-08-31 13:27:00','2022-08-31 13:27:00'),(14,'Marcel Bergeron','codalia.dubya+bergeron@gmail.com','Lorem ipsum dolor sit ameet','L\'ordre du tableau renvoyé par cette méthode ne dépend pas de la façon dont l\'objet est défini. S\'il faut garantir un certain ordre, on pourra utiliser la méthode','unread','2022-09-06 09:13:53','2022-09-06 09:13:53'),(15,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 07:36:22','2022-12-25 07:36:22'),(16,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 07:40:14','2022-12-25 07:40:14'),(17,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:12:19','2022-12-25 10:12:19'),(18,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:19:17','2022-12-25 10:19:17'),(19,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:23:28','2022-12-25 10:23:28'),(20,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:24:37','2022-12-25 10:24:37'),(21,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:34:53','2022-12-25 10:34:53'),(22,'Lucas Sanner','codalia.dubya@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2022-12-25 10:36:28','2022-12-25 10:36:28'),(23,'Elaine Benes','codalia.dubya+benes@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2023-07-10 05:11:05','2023-07-10 05:11:05'),(24,'Brigitte Levesque','codalia.dubya+levesque@gmail.com','Web site','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2023-07-10 05:12:59','2023-07-10 05:12:59'),(25,'Elaine Benes','codalia.dubya+benes@gmail.com','Test email','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2023-07-10 05:13:53','2023-07-10 05:13:53'),(26,'Elaine Benes','codalia.dubya+benes@gmail.com','Web site','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2023-07-29 04:46:14','2023-07-29 04:46:14'),(27,'Elaine Benes','codalia.dubya+benes@gmail.com','Web site','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','unread','2023-09-05 14:14:12','2023-09-05 14:14:12');

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `disk_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` int unsigned DEFAULT NULL,
  `content_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `field` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `documentable_id` int unsigned DEFAULT NULL,
  `documentable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES (4,'c87b6ba0df7f685df57faaefab47ae18.jpeg','220px-PrayerForOwenMeany.jpeg',30562,'image/jpeg','image',4,'App\\Models\\Post',1,'2022-07-15 05:22:52','2022-07-15 05:22:52'),(5,'8c02a2922e8adf0fd034c440a3071b2e.jpg','Foam-of-the-Days.jpg',102741,'image/jpeg','image',5,'App\\Models\\Post',1,'2022-07-15 05:23:56','2022-07-15 05:23:56'),(6,'3d0d30c8b2fdd5d02c2cd6525f17e330.jpg','alice_in_wonderland.jpg',71324,'image/jpeg','image',6,'App\\Models\\Post',1,'2022-07-15 05:25:00','2022-07-15 05:25:00'),(7,'2a8d8dddb0518ed051fea460773ebe3e.jpg','death_on_the_nile.jpg',29123,'image/jpeg','image',7,'App\\Models\\Post',1,'2022-07-15 05:26:07','2022-07-15 05:26:07'),(8,'8942efa7de0092001e344dfb45f7cdf9.jpg','the_shinning.jpg',22582,'image/jpeg','image',8,'App\\Models\\Post',1,'2022-07-15 05:27:10','2022-07-15 05:27:10'),(9,'feeeaa14a80e4852889c28860fbb5b24.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','file_manager',1,'App\\Models\\User',1,'2022-07-16 11:51:20','2022-07-16 11:51:20'),(10,'e0290c77c38eeb141b6352d4ecf9f680.jpg','BraveNewWorld_FirstEdition.jpg',26171,'image/jpeg','image',9,'App\\Models\\Post',1,'2022-07-18 14:44:15','2022-07-18 14:44:15'),(11,'b36060914b0e9306a672dbf1caf0613d.png','love-not-war-vietnam.png',329489,'image/png','file_manager',1,'App\\Models\\User',1,'2022-08-01 11:55:19','2022-08-01 11:55:19'),(15,'29aae92c3d02915996a4c5254877b1dc.jpg','the-lord-of-the-rings.jpg',70010,'image/jpeg','image',11,'App\\Models\\Post',1,'2022-09-13 08:30:53','2022-09-13 08:30:53'),(20,'ec1b313cc00ae6b7b5f48d23ac770b29.jpg','harrison_ford.jpg',63465,'image/jpeg','photo',1,'App\\Models\\User',1,'2022-09-16 04:59:12','2022-09-16 04:59:12'),(40,'3b3023a29fef6584a91746262eea5b43.jpg','the-catcher-in-the-rye.jpg',67863,'image/jpeg','image',12,'App\\Models\\Post',1,'2022-10-22 09:08:16','2022-10-22 09:08:16'),(44,'e2e56b95e41f22435a59f537484ac871.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','image',6,'App\\Models\\Cms\\LayoutItem',1,'2022-10-26 05:17:05','2022-10-26 05:17:05'),(47,'e457288f836c83055c750ae53505526b.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','image',5,'App\\Models\\Cms\\Category',1,'2022-11-04 09:17:01','2022-11-04 09:17:01'),(51,'2ca77225d9a13c785313bae2de6b2713.jpeg','in_cold_blood.jpeg',26809,'image/jpeg','image',34,'App\\Models\\Cms\\LayoutItem',1,'2022-11-23 09:20:18','2022-11-23 09:20:18'),(52,'3d0181a365dd8546a293798d0ecd7a1e.jpg','death_on_the_nile.jpg',29123,'image/jpeg','image',35,'App\\Models\\Cms\\LayoutItem',1,'2022-11-23 09:20:19','2022-11-23 09:20:19'),(53,'71e551da3edf0e12c58868f9358f7df5.jpg','the-little-prince.jpg',52061,'image/jpeg','image',47,'App\\Models\\Cms\\LayoutItem',1,'2022-11-23 10:14:01','2022-11-23 10:14:01'),(54,'b1c09ffda690b133e35be2441e773922.jpg','the-lord-of-the-rings.jpg',70010,'image/jpeg','image',48,'App\\Models\\Cms\\LayoutItem',1,'2022-11-23 10:14:01','2022-11-23 10:14:01'),(55,'6a6817b973138f8704431ca75683e7b6.jpg','the-little-prince.jpg',52061,'image/jpeg','image',13,'App\\Models\\Post',1,'2022-11-23 10:14:01','2022-11-23 10:14:01'),(56,'ec55ebfc6d268662f2f11d1a5c957cce.jpg','in-search-of-lost-time.jpg',53831,'image/jpeg','image',14,'App\\Models\\Post',1,'2023-06-24 11:16:39','2023-06-24 11:16:39'),(57,'d6961f42b84239c1a42717d8d58f2a9b.jpg','the-divine-comedy.jpg',105744,'image/jpeg','image',15,'App\\Models\\Post',1,'2023-06-24 11:57:07','2023-06-24 11:57:07'),(58,'59fb717bd78fd5ad63f66289ac1002e8.jpg','lolita.jpg',32086,'image/jpeg','image',16,'App\\Models\\Post',1,'2023-07-01 14:41:30','2023-07-01 14:41:30'),(59,'689ca1cbb8a57b44bac930b6ab65abeb.jpeg','george-orwell.jpeg',32557,'image/jpeg','image',10,'App\\Models\\Cms\\Category',1,'2023-07-01 14:49:22','2023-07-01 14:49:22'),(61,'098c883eb78b5b8bf86453a72733c8b8.jpg','Vian.jpg',5106,'image/jpeg','image',9,'App\\Models\\Cms\\Category',1,'2023-07-15 07:56:27','2023-07-15 07:56:27'),(62,'b45a2a8eb1d45444e38e9bf4ce49db71.jpg','camus.jpg',12270,'image/jpeg','image',11,'App\\Models\\Cms\\Category',1,'2023-07-15 08:01:58','2023-07-15 08:01:58'),(63,'89e95971584cda51b5ed590f43a22b22.jpg','the-divine-comedy.jpg',105744,'image/jpeg','image',54,'App\\Models\\Cms\\LayoutItem',1,'2023-08-17 13:53:01','2023-08-17 13:53:01'),(64,'398ba1a362e56e0f456add90246aa4f7.jpeg','george-orwell.jpeg',32557,'image/jpeg','image',17,'App\\Models\\Post',1,'2023-08-17 13:53:01','2023-08-17 13:53:01'),(71,'568d1e23edabc7689587525ae301ebf0.jpg','lolita.jpg',32086,'image/jpeg','image',55,'App\\Models\\Cms\\LayoutItem',1,'2023-08-18 09:27:08','2023-08-18 09:27:08'),(83,'b0cc829c8aa80a8df5893ec40847a8eb.jpeg','in_cold_blood.jpeg',26809,'image/jpeg','image',3,'App\\Models\\Post',1,'2023-08-18 11:35:12','2023-08-18 11:35:12'),(87,'d8bf6f9818a5e8d615fd32eff994d7b0.jpg','Breakfast at Tiffany\'s.jpg',42265,'image/jpeg','image',22,'App\\Models\\Cms\\LayoutItem',1,'2023-08-18 14:02:05','2023-08-18 14:02:05'),(88,'6797f66d4cd809421cc920d2f2fb1db2.jpg','breakfast_at_tiffany_s.jpg',167814,'image/jpeg','image',2,'App\\Models\\Post',1,'2023-08-18 14:03:32','2023-08-18 14:03:32'),(89,'b0953eb68bcce2b916a198b8e9550d7c.jpg','the-catcher-in-the-rye.jpg',67863,'image/jpeg','image',3,'App\\Models\\Cms\\Category',1,'2023-08-18 14:18:20','2023-08-18 14:18:20'),(90,'20fe07db2a3b0ddc05938c6f7de9e283.jpg','truman-capote.jpg',21282,'image/jpeg','image',12,'App\\Models\\Cms\\Category',1,'2023-08-18 14:30:43','2023-08-18 14:30:43'),(92,'c0676601e9ab08693ceb2c98ff24dc8e.jpg','brad_pitt.jpg',30954,'image/jpeg','photo',3,'App\\Models\\User',1,'2023-08-18 14:50:22','2023-08-18 14:50:22'),(93,'674107661bb8a5e00a97c1cffac45e4f.jpg','emma-stone.jpg',35830,'image/jpeg','photo',2,'App\\Models\\User',1,'2023-08-18 16:12:50','2023-08-18 16:12:50'),(94,'a56d9ad7f81097b3938e6d46c3a5a2e7.jpeg','John_Irving.jpeg',27333,'image/jpeg','image',13,'App\\Models\\Cms\\Category',1,'2023-08-30 13:36:53','2023-08-30 13:36:53'),(95,'99aa57efd0bd11a938ec68c3945f7560.jpg','emma-stone.jpg',35830,'image/jpeg','file_manager',1,'App\\Models\\User',1,'2023-09-05 14:13:26','2023-09-05 14:13:26'),(96,'ffe688dffc6e490e636b600d5286b61b.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','image',1,'App\\Models\\Post',1,'2023-10-10 11:08:46','2023-10-10 11:08:46'),(97,'2d909d501c2bb3da0cf7ed01ca2a63d1.jpg','the-prophet.jpg',78022,'image/jpeg','image',18,'App\\Models\\Post',1,'2023-11-13 10:05:24','2023-11-13 10:05:24');

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body_html` text COLLATE utf8mb4_unicode_ci,
  `body_text` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plain_text` tinyint(1) DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `emails_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` VALUES (1,'user-registration','Welcome {{ $data->name }}','<p>Hello {{ $data->name }}</p>\r\n<p>Welcome to Starter CMS !!<br />A user account has been created for you.</p>\r\n<p>login: {{ $data->email }}<br />Please use the password you chose during your registration.</p>\r\n<p>Best regard,<br />The Starter CMS team.</p>',NULL,NULL,0,NULL,NULL,1,'2022-07-14 19:17:12','2023-08-18 14:45:05'),(2,'new-message','New message','<p>Hello administrator<br /><br />A user has sent a message.<br />Name: {{ $data->name }}<br />Email: {{ $data->email }}<br />Object: {{ $data->object }}<br />Message: {{ $data->message }}<br /><br />Best regard, <br />The Starter CMS team.</p>',NULL,NULL,0,NULL,NULL,1,'2022-07-14 19:17:12','2022-12-25 07:32:15'),(3,'comment-alert','Comment alert','<p>Hello {{ $data->post_author }}<br />The user {{ $data->comment_author }} has left a comment regarding your post {{ $data->title }}. <br />You can check it out here: {{ $data->post_url }}</p>\r\n<p>Best regard, The Starter CMS team.</p>',NULL,NULL,0,NULL,NULL,1,'2023-08-23 13:29:28','2023-08-23 13:53:04');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `group_menu`
--

CREATE TABLE `group_menu` (
  `group_id` bigint unsigned NOT NULL,
  `menu_id` bigint unsigned NOT NULL,
  KEY `group_menu_group_id_foreign` (`group_id`),
  KEY `group_menu_menu_id_foreign` (`menu_id`),
  CONSTRAINT `group_menu_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_menu_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_menu`
--


--
-- Table structure for table `group_post`
--

CREATE TABLE `group_post` (
  `group_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `group_post_group_id_foreign` (`group_id`),
  KEY `group_post_post_id_foreign` (`post_id`),
  CONSTRAINT `group_post_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_post_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_post`
--

INSERT INTO `group_post` VALUES (1,12),(2,3),(1,10),(1,1);

--
-- Table structure for table `group_user`
--

CREATE TABLE `group_user` (
  `group_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `group_user_group_id_foreign` (`group_id`),
  KEY `group_user_user_id_foreign` (`user_id`),
  CONSTRAINT `group_user_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_user`
--

INSERT INTO `group_user` VALUES (1,1),(2,2),(1,2),(1,3);

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` tinytext COLLATE utf8mb4_unicode_ci,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1,'public-team','test once again','public_ro','read_only',NULL,NULL,1,1,'2022-09-14 04:52:47','2023-08-18 14:52:14'),(2,'private-team','Test group','private','read_write',NULL,NULL,1,1,'2022-09-14 04:53:46','2023-07-15 15:02:18');

--
-- Table structure for table `layout_items`
--

CREATE TABLE `layout_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `layout_itemable_id` bigint unsigned DEFAULT NULL,
  `layout_itemable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_nb` smallint unsigned NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `data` json DEFAULT NULL,
  `order` tinyint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `layout_items`
--

INSERT INTO `layout_items` VALUES (1,1,'App\\Models\\Post',2,'group_start',NULL,'{\"class\": \"col-lg-10 text-block\", \"groups_in_row\": \"2\"}',1),(2,1,'App\\Models\\Post',1,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboruuum.</p>',NULL,2),(3,1,'App\\Models\\Post',3,'group_end',NULL,'{\"parent_id\": \"2\"}',3),(4,1,'App\\Models\\Post',5,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"\"}',4),(5,1,'App\\Models\\Post',6,'group_end',NULL,'{\"parent_id\": \"5\"}',6),(6,1,'App\\Models\\Post',4,'image','consectetur adipiscing elit, sed do eiusmod tempor incididunt','{\"url\": \"/storage/e2e56b95e41f22435a59f537484ac871.jpg\", \"thumbnail\": \"/storage/thumbnails/e2e56b95e41f22435a59f537484ac871.jpg\"}',5),(7,1,'App\\Models\\Post',7,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"2\"}',7),(8,1,'App\\Models\\Post',8,'group_end',NULL,'{\"parent_id\": \"7\"}',9),(9,1,'App\\Models\\Post',9,'group_start',NULL,'{\"class\": \"col-lg-10 text-block\", \"groups_in_row\": \"\"}',10),(10,1,'App\\Models\\Post',11,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa quiza officia deserunt mollit anim id est laborum.</p>',NULL,11),(11,1,'App\\Models\\Post',10,'group_end',NULL,'{\"parent_id\": \"9\"}',12),(13,2,'App\\Models\\Post',1,'group_start',NULL,'{\"class\": \"col-lg-9\", \"groups_in_row\": \"1\"}',1),(15,2,'App\\Models\\Post',6,'text_block','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumousse.</p>',NULL,2),(16,2,'App\\Models\\Post',2,'group_end',NULL,'{\"parent_id\": \"1\"}',3),(17,2,'App\\Models\\Post',3,'group_start',NULL,'{\"class\": \"col-lg-5\", \"groups_in_row\": \"2\"}',4),(18,2,'App\\Models\\Post',7,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,5),(19,2,'App\\Models\\Post',4,'group_end',NULL,'{\"parent_id\": \"3\"}',6),(20,2,'App\\Models\\Post',9,'group_start',NULL,'{\"class\": \"col-lg-5\", \"groups_in_row\": \"\"}',7),(21,2,'App\\Models\\Post',10,'group_end',NULL,'{\"parent_id\": \"9\"}',9),(22,2,'App\\Models\\Post',8,'image','Lorem ipsum dolor sit amet, consectetur adipiscing elit','{\"url\": \"/storage/d8bf6f9818a5e8d615fd32eff994d7b0.jpg\", \"thumbnail\": \"/storage/thumbnails/d8bf6f9818a5e8d615fd32eff994d7b0.jpg\"}',8),(23,3,'App\\Models\\Post',1,'group_start',NULL,'{\"class\": \"col-lg-10\", \"groups_in_row\": \"2\"}',1),(24,3,'App\\Models\\Post',3,'title','Duis aute irure dolor in reprehenderit in voluptate',NULL,2),(25,3,'App\\Models\\Post',4,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,3),(26,3,'App\\Models\\Post',2,'group_end',NULL,'{\"parent_id\": \"1\"}',4),(27,3,'App\\Models\\Post',5,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"\"}',5),(28,3,'App\\Models\\Post',6,'group_end',NULL,'{\"parent_id\": \"5\"}',7),(29,3,'App\\Models\\Post',8,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"2\"}',8),(30,3,'App\\Models\\Post',9,'group_end',NULL,'{\"parent_id\": \"8\"}',10),(31,3,'App\\Models\\Post',11,'group_start',NULL,'{\"class\": \"col-lg-10\", \"groups_in_row\": \"\"}',11),(32,3,'App\\Models\\Post',10,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,12),(33,3,'App\\Models\\Post',12,'group_end',NULL,'{\"parent_id\": \"11\"}',13),(34,3,'App\\Models\\Post',7,'image','my reminders table uses polymorphism','{\"url\": \"/storage/2ca77225d9a13c785313bae2de6b2713.jpeg\", \"thumbnail\": \"/storage/thumbnails/2ca77225d9a13c785313bae2de6b2713.jpeg\"}',6),(35,3,'App\\Models\\Post',13,'image','culpa qui officia deserunt mollit anim id est laborum','{\"url\": \"/storage/3d0181a365dd8546a293798d0ecd7a1e.jpg\", \"thumbnail\": \"/storage/thumbnails/3d0181a365dd8546a293798d0ecd7a1e.jpg\"}',9),(36,13,'App\\Models\\Post',1,'group_start',NULL,'{\"class\": \"col-lg-10\", \"groups_in_row\": \"2\"}',1),(37,13,'App\\Models\\Post',3,'title','Duis aute irure dolor in reprehenderit in voluptate',NULL,2),(38,13,'App\\Models\\Post',4,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer.</p>',NULL,3),(39,13,'App\\Models\\Post',2,'group_end',NULL,'{\"parent_id\": \"1\"}',4),(40,13,'App\\Models\\Post',5,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"\"}',5),(41,13,'App\\Models\\Post',6,'group_end',NULL,'{\"parent_id\": \"5\"}',7),(42,13,'App\\Models\\Post',8,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"2\"}',8),(43,13,'App\\Models\\Post',9,'group_end',NULL,'{\"parent_id\": \"8\"}',10),(44,13,'App\\Models\\Post',11,'group_start',NULL,'{\"class\": \"col-lg-10\", \"groups_in_row\": \"\"}',11),(45,13,'App\\Models\\Post',13,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer.</p>',NULL,12),(46,13,'App\\Models\\Post',12,'group_end',NULL,'{\"parent_id\": \"11\"}',13),(47,13,'App\\Models\\Post',7,'image','my reminders table uses polymorphism','{\"url\": \"/storage/71e551da3edf0e12c58868f9358f7df5.jpg\", \"thumbnail\": \"/storage/thumbnails/71e551da3edf0e12c58868f9358f7df5.jpg\"}',6),(48,13,'App\\Models\\Post',10,'image','culpa qui officia deserunt mollit anim id est laborum','{\"url\": \"/storage/b1c09ffda690b133e35be2441e773922.jpg\", \"thumbnail\": \"/storage/thumbnails/b1c09ffda690b133e35be2441e773922.jpg\"}',9),(49,17,'App\\Models\\Post',1,'group_start',NULL,'{\"class\": \"col-lg-10 text-block\", \"groups_in_row\": \"2\"}',1),(50,17,'App\\Models\\Post',5,'text_block','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboruum.</p>',NULL,2),(51,17,'App\\Models\\Post',2,'group_end',NULL,'{\"parent_id\": \"1\"}',3),(52,17,'App\\Models\\Post',3,'group_start',NULL,'{\"class\": \"col-lg-2\", \"groups_in_row\": \"\"}',4),(53,17,'App\\Models\\Post',4,'group_end',NULL,'{\"parent_id\": \"3\"}',6),(54,17,'App\\Models\\Post',6,'image','proident, sunt in culpa qui officia deserunt mollit anim id est laborum','{\"url\": \"/storage/89e95971584cda51b5ed590f43a22b22.jpg\", \"thumbnail\": \"/storage/thumbnails/89e95971584cda51b5ed590f43a22b22.jpg\"}',5),(55,1,'App\\Models\\Post',13,'image','consectetur adipiscing elit, sed do eiusmod tempor incididunt','{\"url\": \"/storage/568d1e23edabc7689587525ae301ebf0.jpg\", \"thumbnail\": \"/storage/thumbnails/568d1e23edabc7689587525ae301ebf0.jpg\"}',8);

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anchor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `_lft` int unsigned NOT NULL DEFAULT '0',
  `_rgt` int unsigned NOT NULL DEFAULT '0',
  `parent_id` int unsigned DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_items__lft__rgt_parent_id_index` (`_lft`,`_rgt`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` VALUES (1,'Root','root','root',NULL,NULL,NULL,'published',1,20,NULL,NULL,NULL,NULL,'2022-07-14 19:17:12','2022-07-14 19:17:12'),(2,'Home','main-menu','/',NULL,NULL,NULL,'published',2,3,1,NULL,NULL,NULL,'2022-07-14 19:17:12','2022-07-14 19:17:12'),(3,'Genre','main-menu','{posts}/{categories}/2/genre','Post',NULL,NULL,'published',4,13,1,NULL,NULL,1,'2022-07-15 09:06:29','2023-07-15 05:32:51'),(4,'Drama','main-menu','{posts}/{categories}/3/drama','Post',NULL,NULL,'published',11,12,3,NULL,NULL,1,'2022-07-15 11:57:04','2023-08-18 14:42:45'),(5,'Classics','main-menu','{posts}/{categories}/4/classics','Post',NULL,NULL,'published',5,6,3,NULL,NULL,1,'2022-07-15 11:57:58','2023-07-15 16:08:25'),(6,'Science-fiction','main-menu','{posts}/{categories}/5/science-fiction','Post',NULL,NULL,'published',9,10,3,NULL,NULL,1,'2022-07-18 14:57:55','2023-07-15 05:33:38'),(7,'Search','main-menu','/search',NULL,NULL,NULL,'published',14,15,1,NULL,NULL,1,'2022-07-25 15:57:19','2022-07-25 15:57:19'),(8,'Heroic fantasy','main-menu','{posts}/{categories}/8/heroic-fantasy','Post',NULL,NULL,'published',7,8,3,NULL,NULL,1,'2022-09-14 05:02:55','2023-07-15 05:33:28'),(9,'Book of the month','main-menu','/{posts}/1/the-planet-of-the-apes','Post',NULL,NULL,'published',16,17,1,NULL,NULL,1,'2023-01-01 08:05:02','2023-07-14 08:51:42'),(10,'Contact','main-menu','/contact',NULL,NULL,NULL,'published',18,19,1,NULL,NULL,NULL,'2023-08-04 08:18:17','2023-08-04 08:18:17');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Main menu','main-menu','published','public_rw',NULL,NULL,1,1,'2022-07-14 19:17:12','2023-08-18 14:39:17');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2020_05_05_060229_create_permission_tables',1),(6,'2021_05_30_051729_create_groups_table',1),(7,'2021_05_31_051829_create_group_user_table',1),(8,'2021_06_16_045540_create_settings_table',1),(9,'2021_06_24_151612_create_documents_table',1),(10,'2021_07_05_091208_create_emails_table',1),(11,'2021_08_01_115731_update_roles_table',1),(12,'2021_08_25_075701_create_posts_table',1),(13,'2021_08_25_120132_create_post_categories_table',1),(14,'2021_08_26_052946_create_category_post_table',1),(15,'2021_09_04_063252_create_group_post_table',1),(16,'2021_09_16_142151_create_post_category_group_table',1),(17,'2021_09_25_083336_create_menus_table',1),(18,'2021_09_25_083350_create_menu_items_table',1),(19,'2021_09_26_073254_create_group_menu_table',1),(20,'2021_10_29_050634_create_post_settings_table',1),(21,'2021_11_12_084927_update_users_table',1),(22,'2021_11_27_062746_api_token_users_table',1),(23,'2022_04_04_140355_add_login_fields_to_users_table',1),(24,'2022_06_24_152055_create_messages_table',1),(25,'2022_07_12_044526_create_ordering_category_post_table',2),(26,'2022_10_07_091428_create_layouts_table',3),(27,'2022_12_29_055945_create_comments_table',4),(28,'2022_12_29_055945_create_post_comments_table',5),(29,'2023_08_25_073024_create_comments_table',6),(30,'2023_08_27_043244_create_orders_table',7),(31,'2023_08_26_150950_create_categorizables_table',8),(32,'2023_08_26_152956_create_category_group_table',9);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(5,'App\\Models\\User',3);

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `orderable_id` int unsigned DEFAULT NULL,
  `orderable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_order` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,3,1,'App\\Models\\Post','The Planet of the Apes',2),(2,4,1,'App\\Models\\Post','The Planet of the Apes',1),(3,4,2,'App\\Models\\Post','Breakfast at Tiffany\'s',2),(4,1,3,'App\\Models\\Post','In Cold Blood',1),(5,3,3,'App\\Models\\Post','In Cold Blood',1),(6,4,3,'App\\Models\\Post','In Cold Blood',3),(7,1,4,'App\\Models\\Post','A Prayer for Owen Meany',2),(8,3,4,'App\\Models\\Post','A Prayer for Owen Meany',4),(9,2,5,'App\\Models\\Post','Foam of the Days',1),(10,4,5,'App\\Models\\Post','Foam of the Days',4),(11,1,6,'App\\Models\\Post','Alice in Wonderland',3),(12,4,6,'App\\Models\\Post','Alice in Wonderland',5),(13,1,7,'App\\Models\\Post','Death on the Nile',4),(14,6,7,'App\\Models\\Post','Death on the Nile',1),(15,1,8,'App\\Models\\Post','The Shining',5),(16,6,8,'App\\Models\\Post','The Shining',2),(17,5,9,'App\\Models\\Post','A Brave New World',1),(18,4,10,'App\\Models\\Post','1984',6),(19,10,10,'App\\Models\\Post','1984',1),(20,4,11,'App\\Models\\Post','The Lord of the Rings',7),(21,8,11,'App\\Models\\Post','The Lord of the Rings',1),(22,3,12,'App\\Models\\Post','The Catcher in the Rye',3),(23,4,12,'App\\Models\\Post','The Catcher in the Rye',8),(24,4,13,'App\\Models\\Post','The Little Prince',9),(25,3,14,'App\\Models\\Post','In Search of Lost Time',5),(26,4,14,'App\\Models\\Post','In Search of Lost Time',10),(27,4,15,'App\\Models\\Post','The Divine Comedy',11),(28,3,16,'App\\Models\\Post','Lolita',6),(29,4,16,'App\\Models\\Post','Lolita',12),(30,3,17,'App\\Models\\Post','The Sun Also Rises',7),(31,4,17,'App\\Models\\Post','The Sun Also Rises',13),(32,4,18,'App\\Models\\Post','The Prophet',14);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'create-users','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(2,'update-users','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(3,'delete-users','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(4,'create-user-groups','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(5,'update-user-groups','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(6,'delete-user-groups','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(7,'create-user-roles','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(8,'update-user-roles','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(9,'delete-user-roles','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(10,'create-menus','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(11,'update-menus','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(12,'delete-menus','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(13,'create-posts','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(14,'update-posts','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(15,'delete-posts','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(16,'create-post-categories','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(17,'update-post-categories','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(18,'delete-post-categories','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(19,'global-settings','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(20,'post-settings','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(21,'update-emails','web','2023-09-11 04:54:10','2023-09-11 04:54:10'),(22,'access-dashboard','web','2023-09-11 04:54:10','2023-09-11 04:54:10');

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `raw_content` text COLLATE utf8mb4_unicode_ci,
  `excerpt` text COLLATE utf8mb4_unicode_ci,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `main_cat_id` bigint unsigned DEFAULT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_img` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extra_fields` json DEFAULT NULL,
  `meta_data` json DEFAULT NULL,
  `settings` json NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1,'The Planet of the Apes','the-planet-of-the-apes',NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboruuum. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa quiza officia deserunt mollit anim id est laborum. ','<p>Duis aute irure dolores in reprehenderit ien voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est lfoo aborum.</p>','published',3,'public_ro','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur','post-layout','{\"extra_field_1\": \"english, spanish, japanese\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": \"website\", \"meta_og_image\": null, \"meta_og_local\": \"en_US\", \"meta_og_title\": \"Excepteur sint occaecat cupidatat non proident, sunt in culpa qu\", \"canonical_link\": \"https://sites.codalia.fr/starter-cms/public/post/1/the-planet-of-the-apes\", \"meta_page_title\": \"The Planet of the Apes\", \"structured_data\": \"[\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"Organization\\\"\\r\\n  },\\r\\n  {\\r\\n     \\\"@context\\\": \\\"http://schema.org\\\",\\r\\n     \\\"@type\\\": \\\"BreadcrumbList\\\"\\r\\n  }\\r\\n]\", \"meta_name_robots\": null, \"meta_og_description\": \"Excepteur sint occaecat cupidatat non proident, sunt in culpa qu\", \"meta_name_description\": \"Duis aute irure dolor in reprehenderit ien voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',1,'2024-04-01 05:56:07',1,1,'2022-07-15 05:12:08','2023-12-08 10:03:59'),(2,'Breakfast at Tiffany\'s','breakfast-at-tiffanys','<p>Lorem ipsum dolor sit amét, consectetur adipiscing élit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumumu.</p>','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumousse. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ','<p>Duis auteur irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'private','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur','post-layout','{\"extra_field_1\": \"uis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"Breakfast at Tiffany\'s\", \"structured_data\": \"{\\r\\n\\\"@context\\\": \\\"https://schema.org\\\",\\r\\n      \\\"@type\\\": \\\"NewsArticle\\\",\\r\\n      \\\"headline\\\": \\\"Title of a News Article\\\",\\r\\n      \\\"image\\\": [\\r\\n        \\\"https://example.com/photos/1x1/photo.jpg\\\",\\r\\n        \\\"https://example.com/photos/4x3/photo.jpg\\\",\\r\\n        \\\"https://example.com/photos/16x9/photo.jpg\\\"\\r\\n       ],\\r\\n      \\\"datePublished\\\": \\\"2015-02-05T08:00:00+08:00\\\",\\r\\n      \\\"dateModified\\\": \\\"2015-02-05T09:20:00+08:00\\\",\\r\\n      \\\"author\\\": [{\\r\\n          \\\"@type\\\": \\\"Person\\\",\\r\\n          \\\"name\\\": \\\"Jane Doe\\\",\\r\\n          \\\"url\\\": \\\"https://example.com/profile/janedoe123\\\"\\r\\n        },{\\r\\n          \\\"@type\\\": \\\"Person\\\",\\r\\n          \\\"name\\\": \\\"John Doe\\\",\\r\\n          \\\"url\\\": \\\"https://example.com/profile/johndoe123\\\"\\r\\n      }]\\r\\n}\", \"meta_name_robots\": \"index,follow\", \"meta_og_description\": null, \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"global_setting\", \"show_created_at\": \"1\"}',NULL,NULL,2,1,'2022-07-15 05:17:27','2023-11-22 10:19:28'),(3,'In Cold Blood','in-cold-blood','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate veliter esse cillumes dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumuor.</p>','Duis aute irure dolor in reprehenderit in voluptate Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',3,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboru.','post-layout','{\"extra_field_1\": \"english, spanish, japanese\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"structured_data\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,2,1,'2022-07-15 05:20:54','2024-01-28 10:02:54'),(4,'A Prayer for Owen Meany','a-prayer-for-owen-meany','<p>Lorem ipsum dolor sit ametez, consectetur adipiscing elit, sed do meteo eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolores in reprehenderitum in voluptate veliter esse cillumen dolore eu fugiater nulla pariatur. Excepteur sint occaecat au \'vétérans\" du cupidatat none proident, sunt in culpa qui officia deserunt mollit anim id est laborumuù.</p>','Lorem ipsum dolor sit ametez, consectetur adipiscing elit, sed do meteo eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolores in reprehenderitum in voluptate veliter esse cillumen dolore eu fugiater nulla pariatur. Excepteur sint occaecat au \'vétérans\" du cupidatat none proident, sunt in culpa qui officia deserunt mollit anim id est laborumuù.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',3,'public_ro','sed do eiusmod tempor incididunt ut labore et dolore magna aliqua',NULL,'{\"extra_field_1\": \"Ceo & Founder\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"A Prayer for Owen Meany\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"0\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:22:52','2023-09-05 05:03:42'),(5,'Foam of the Days','foam-of-the-days','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod termpor météo incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit ine voluptate velit esse cillum dolore eu fugiat nulla pariatuer. Excepteuar l\'ete sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim hello id est test laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod termpor météo incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit ine voluptate velit esse cillum dolore eu fugiat nulla pariatuer. Excepteuar l\'ete sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim hello id est test laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','sed do eiusmod tempor incididunt ut labore et dolore magna aliqua',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"0\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:23:56','2023-10-10 12:31:05'),(6,'Alice in Wonderland','alice-in-wonderland','<p>Lorem ipsum dolor sit amet, <strong>consectetur adipiscing</strong> elit, sed do eiusmod tempor incididunt ut<em> labore et dolore</em> magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','sed do eiusmod tempor incididunt ut labore et dolore magna aliqua',NULL,'{\"extra_field_1\": \"Test 1\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:24:59','2023-08-30 09:26:32'),(7,'Death on the Nile','death-on-the-nile','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',6,'public_ro','sed do eiusmod tempor incididunt ut labore et dolore magna aliqua',NULL,'{\"extra_field_1\": \"Web Development\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"global_setting\"}',NULL,NULL,1,1,'2022-07-15 05:26:07','2023-08-30 09:27:07'),(8,'The Shining','the-shining','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',6,'public_ro','sed do eiusmod tempor incididunt ut labore et dolore magna aliqua',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:27:10','2023-08-30 09:27:27'),(9,'A Brave New World','a-brave-new-world','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',5,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboru.',NULL,'{\"extra_field_1\": \"A sci-fi classic\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-18 14:44:15','2023-08-30 09:27:46'),(10,'1984','1984','<p>Lorém ipsum dolor sit amét, consectétur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorém ipsum dolor sit amét, consectétur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Excépteur sint occaécat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro',NULL,NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-25 14:16:13','2023-12-08 10:03:59'),(11,'The Lord of the Rings','the-lord-of-the-rings','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur l\'été sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboroum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur l\'été sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboroum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboru.',NULL,'{\"extra_field_1\": \"Duis aute irure dolor in reprehenderit\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"The Lord of the Rings\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-09-13 08:28:20','2023-08-30 09:54:28'),(12,'The Catcher in the Rye','the-catcher-in-the-rye','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer.</p>','published',3,'public_ro',NULL,NULL,'{\"extra_field_1\": \"The Catcher in the Rye\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"The Catcher in the Rye\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,2,1,'2022-10-22 09:08:15','2023-12-08 10:03:59'),(13,'The Little Prince','the-little-prince',NULL,'Duis aute irure dolor in reprehenderit in voluptate Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumer. ','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','Horizon maritime avec reflets de soleil','post-layout','{\"extra_field_1\": \"The Little Prince\", \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"The Little Prince\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"global_setting\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-11-23 10:14:01','2023-08-30 09:36:26'),(14,'In Search of Lost Time','in-search-of-lost-time','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',3,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"In Search of Lost Time\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": null, \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2023-06-24 11:12:50','2023-08-30 09:36:38'),(15,'The Divine Comedy','the-divine-comedy','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"The Divine Comedy\", \"canonical_link\": null, \"meta_page_title\": \"The Divine Comedy\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": null, \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2023-06-24 11:44:43','2023-08-30 09:36:53'),(16,'Lolita','lolita','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do meteo eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat au \'vétérans\" du cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do meteo eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat au \'vétérans\" du cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p>','published',3,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"Lolita\", \"canonical_link\": null, \"meta_page_title\": \"Lolita\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\", \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,3,1,'2023-07-01 14:41:30','2023-08-30 09:37:06'),(17,'The Sun Also Rises','the-sun-also-rises',NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboruum. ','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>','published',3,'public_ro',NULL,NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": \"The Sun Also Rises\", \"canonical_link\": null, \"meta_page_title\": \"The Sun Also Rises\", \"meta_name_robots\": \"index, follow\", \"meta_og_description\": \"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\", \"meta_name_description\": \"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2023-08-17 13:53:01','2023-11-12 05:37:13'),(18,'The Prophet','the-prophet','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','<p>Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','published',4,'public_ro','voluptate velit esse cillum dolore eu fugiat nulla pariatur.',NULL,'{\"extra_field_1\": null, \"extra_field_2\": null, \"extra_field_3\": null, \"extra_field_4\": null, \"extra_field_5\": null, \"extra_field_6\": null, \"extra_field_7\": null, \"extra_field_8\": null, \"extra_field_9\": null, \"extra_field_10\": null}','{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_local\": null, \"meta_og_title\": null, \"canonical_link\": null, \"meta_page_title\": \"The Prophet\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": \"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"comment_alert\": \"1\", \"allow_comments\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,2,1,'2023-11-13 10:05:24','2023-11-22 07:28:15');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(22,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(13,3),(14,3),(15,3),(22,3),(13,4),(14,4),(15,4),(22,4),(13,5),(14,5),(15,5);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_level` tinyint DEFAULT NULL,
  `role_type` char(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super-admin','web','public_ro',5,'super-admin',NULL,NULL,1,NULL,'2022-07-14 19:17:13','2022-07-14 19:17:13'),(2,'admin','web','public_ro',4,'admin',NULL,NULL,1,NULL,'2022-07-14 19:17:13','2022-07-14 19:17:13'),(3,'manager','web','public_ro',3,'manager',NULL,NULL,1,NULL,'2022-07-14 19:17:13','2022-07-14 19:17:13'),(4,'assistant','web','public_ro',2,'assistant',NULL,NULL,1,NULL,'2022-07-14 19:17:13','2022-07-14 19:17:13'),(5,'registered','web','public_ro',1,'registered',NULL,NULL,1,NULL,'2022-07-14 19:17:13','2022-07-14 19:17:13'),(6,'restricted-manager','web','public_ro',3,'manager',NULL,NULL,1,1,'2022-09-14 04:56:19','2023-08-18 14:54:20');


