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


--
-- Table structure for table `category_post`
--

CREATE TABLE `category_post` (
  `category_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `category_post_category_id_foreign` (`category_id`),
  KEY `category_post_post_id_foreign` (`post_id`),
  CONSTRAINT `category_post_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `post_categories` (`id`),
  CONSTRAINT `category_post_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_post`
--

INSERT INTO `category_post` VALUES (1,6),(4,6),(1,7),(6,7),(1,8),(6,8),(1,3),(4,3),(3,1),(5,9),(4,10),(4,1),(4,5),(1,4),(3,4),(2,5),(4,2),(4,11),(8,11),(3,12),(4,12),(4,13);

--
-- 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=15 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');

--
-- 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(50) 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=56 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'),(13,'4684c58e8c3f783efa6063104674b938.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','image',1,'App\\Models\\Post',1,'2022-09-12 11:40:02','2022-09-12 11:40:02'),(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'),(17,'1c8692d7c804c2fe4e2b812db02e26c6.jpg','breakfast_at_tiffany_s.jpg',167814,'image/jpeg','image',2,'App\\Models\\Post',1,'2022-09-13 11:13:49','2022-09-13 11:13:49'),(19,'c3e3c5b554c894bcfb38b5a82f140822.jpg','Emma-Stone-300.jpg',49669,'image/jpeg','photo',2,'App\\Models\\User',1,'2022-09-14 04:58:48','2022-09-14 04:58:48'),(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\\LayoutItem',1,'2022-10-26 05:17:05','2022-10-26 05:17:05'),(45,'0bcfb3012d43d95c9d9105698e26632e.jpg','breakfast_at_tiffany_s.jpg',167814,'image/jpeg','image',12,'App\\Models\\LayoutItem',1,'2022-10-26 05:36:35','2022-10-26 05:36:35'),(47,'e457288f836c83055c750ae53505526b.jpg','Planet-of-the-Apes.jpg',114287,'image/jpeg','image',5,'App\\Models\\Post\\Category',1,'2022-11-04 09:17:01','2022-11-04 09:17:01'),(48,'86ac3bdba5b0e5428ddc20f40e96edb6.jpg','donald-sutherland.jpg',19644,'image/jpeg','image',9,'App\\Models\\Post\\Category',1,'2022-11-04 09:29:21','2022-11-04 09:29:21'),(49,'65dc99a32d1f20e681d19bdf261e027e.jpg','breakfast_at_tiffany_s.jpg',167814,'image/jpeg','image',22,'App\\Models\\LayoutItem',1,'2022-11-23 08:54:46','2022-11-23 08:54:46'),(50,'6f26963275d5d462024bab60645c4379.jpeg','in_cold_blood.jpeg',26809,'image/jpeg','image',3,'App\\Models\\Post',1,'2022-11-23 09:15:56','2022-11-23 09:15:56'),(51,'2ca77225d9a13c785313bae2de6b2713.jpeg','in_cold_blood.jpeg',26809,'image/jpeg','image',34,'App\\Models\\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\\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\\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\\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');

--
-- 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=3 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','2022-09-14 05:06:35'),(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,NULL,'2022-07-14 19:17:12','2022-07-14 19:17:12');

--
-- 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);

--
-- 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);

--
-- 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',NULL,'public_ro','read_only',NULL,NULL,1,1,'2022-09-14 04:52:47','2022-09-14 04:52:47'),(2,'private-team',NULL,'private','read_write',NULL,NULL,1,1,'2022-09-14 04:53:46','2022-09-14 04:53:46');

--
-- 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=49 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 laborum.</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 qui officia deserunt mollit anim id est laborum.</p>',NULL,11),(11,1,'App\\Models\\Post',10,'group_end',NULL,'{\"parent_id\": \"9\"}',12),(12,1,'App\\Models\\Post',12,'image','sunt in culpa qui officia deserunt mollit anim id est laborum','{\"url\": \"/storage/0bcfb3012d43d95c9d9105698e26632e.jpg\", \"thumbnail\": \"/storage/thumbnails/0bcfb3012d43d95c9d9105698e26632e.jpg\"}',8),(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 laborum.</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/65dc99a32d1f20e681d19bdf261e027e.jpg\", \"thumbnail\": \"/storage/thumbnails/65dc99a32d1f20e681d19bdf261e027e.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);

--
-- 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=9 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,16,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','{plugin}/{category}/2/genre','Post',NULL,NULL,'published',4,13,1,NULL,NULL,1,'2022-07-15 09:06:29','2022-07-15 09:15:18'),(4,'Drama','main-menu','{plugin}/{category}/3/drama','Post',NULL,NULL,'published',5,6,3,NULL,NULL,1,'2022-07-15 11:57:04','2022-12-11 07:38:40'),(5,'Classics','main-menu','{plugin}/{category}/4/classics','Post',NULL,NULL,'published',7,8,3,NULL,NULL,1,'2022-07-15 11:57:58','2022-07-15 12:06:11'),(6,'Science-fiction','main-menu','{plugin}/{category}/5/science-fiction','Post',NULL,NULL,'published',9,10,3,NULL,NULL,1,'2022-07-18 14:57:55','2022-09-14 05:02:04'),(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','{plugin}/{category}/8/heroic-fantasy','Post',NULL,NULL,'published',11,12,3,NULL,NULL,1,'2022-09-14 05:02:55','2022-09-14 05:04:29');

--
-- 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','2022-09-14 05:05:08');

--
-- 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=27 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);

--
-- 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),(3,'App\\Models\\User',2);

--
-- Table structure for table `ordering_category_post`
--

CREATE TABLE `ordering_category_post` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_order` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ordering_category_post`
--

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

--
-- 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-user','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(2,'update-user','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(3,'delete-user','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(4,'create-group','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(5,'update-group','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(6,'delete-group','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(7,'create-role','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(8,'update-role','web','2022-07-14 19:17:12','2022-07-14 19:17:12'),(9,'delete-role','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(10,'create-menu','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(11,'update-menu','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(12,'delete-menu','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(13,'create-post','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(14,'update-post','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(15,'delete-post','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(16,'create-post-category','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(17,'update-post-category','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(18,'delete-post-category','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(19,'global-settings','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(20,'post-settings','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(21,'update-email','web','2022-07-14 19:17:13','2022-07-14 19:17:13'),(22,'access-dashboard','web','2022-07-14 19:17:13','2022-07-14 19:17:13');

--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_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,
  `_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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_categories`
--

INSERT INTO `post_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\": \"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\": \"fr_FR\", \"meta_og_title\": null, \"meta_page_title\": \"Starter CMS\", \"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_search\": \"1\", \"post_ordering\": \"no_ordering\", \"show_post_image\": \"1\", \"show_description\": \"1\", \"show_post_excerpt\": \"1\", \"show_subcategories\": \"1\", \"show_post_categories\": \"1\"}',1,2,NULL,NULL,NULL,1,1,'2022-07-15 05:13:24','2022-09-13 08:43:35'),(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',NULL,'{\"meta_og_url\": null, \"meta_og_type\": null, \"meta_og_image\": null, \"meta_og_title\": null, \"meta_page_title\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',3,14,NULL,NULL,NULL,1,1,'2022-07-15 05:13:52','2022-07-17 11:20:26'),(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 laborum.</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\": null, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',4,5,2,NULL,NULL,1,1,'2022-07-15 05:14:15','2022-11-04 09:08:46'),(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 culpa qui officia deserunt mollit 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, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',6,7,2,NULL,NULL,1,1,'2022-07-15 05:14:55','2022-10-23 09:21:13'),(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, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',8,9,2,NULL,NULL,1,1,'2022-07-15 05:15:19','2022-11-04 09:17:01'),(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_title\": null, \"meta_page_title\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',10,11,2,NULL,NULL,1,1,'2022-07-15 05:15:43','2022-07-18 14:39:14'),(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_title\": null, \"meta_page_title\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',15,18,NULL,NULL,NULL,1,1,'2022-07-18 15:10:18','2022-07-18 15:10:18'),(8,'Heroic fantasy','heroic-fantasy',NULL,'<p>Script that checks fields values will say value is 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 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, \"meta_page_title\": \"Heroic fantasy\", \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',12,13,2,NULL,NULL,1,1,'2022-09-13 08:44:33','2022-09-14 05:00:57'),(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>',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, \"meta_page_title\": null, \"meta_name_robots\": null, \"meta_og_description\": null, \"meta_name_description\": null}','{\"show_name\": \"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\"}',16,17,7,NULL,NULL,1,1,'2022-11-04 09:29:21','2022-11-04 09:29:21');

--
-- Table structure for table `post_category_group`
--

CREATE TABLE `post_category_group` (
  `category_id` bigint unsigned NOT NULL,
  `group_id` bigint unsigned NOT NULL,
  KEY `post_category_group_category_id_foreign` (`category_id`),
  KEY `post_category_group_group_id_foreign` (`group_id`),
  CONSTRAINT `post_category_group_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `post_categories` (`id`),
  CONSTRAINT `post_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 `post_category_group`
--


--
-- 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=14 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 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.\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 qui officia deserunt mollit anim id est laborum. ','<p>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 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\": \"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\": \"website\", \"meta_og_image\": null, \"meta_og_local\": \"en_US\", \"meta_og_title\": \"Excepteur sint occaecat cupidatat non proident, sunt in culpa qu\", \"meta_page_title\": \"The Planet of the Apes\", \"meta_name_robots\": null, \"meta_og_description\": \"Excepteur sint occaecat cupidatat non proident, sunt in culpa qu\", \"meta_name_description\": null}','{\"show_image\": \"1\", \"show_owner\": \"1\", \"show_excerpt\": \"1\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:12:08','2022-12-12 06:26:54'),(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 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. 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','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur','post-layout','{\"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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:17:27','2022-12-12 06:23:46'),(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 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 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',4,'public_ro','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laboru.','post-layout','{\"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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:20:54','2022-12-12 07:03:58'),(4,'A Prayer for Owen Meany','a-prayer-for-owen-meany','<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',1,'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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:22:52','2022-12-12 07:04:20'),(5,'Foam of the Days','foam-of-the-days','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod termpor 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. Excepteur 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 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. Excepteur 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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:23:56','2022-12-12 07:04:25'),(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',1,'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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:24:59','2022-12-12 07:04:33'),(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',1,'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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:26:07','2022-12-12 07:04:38'),(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',1,'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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-15 05:27:10','2022-12-12 07:04:45'),(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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-18 14:44:15','2022-12-12 07:04:51'),(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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-07-25 14:16:13','2022-12-12 07:04:56'),(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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-09-13 08:28:20','2022-12-12 07:28:24'),(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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,2,1,'2022-10-22 09:08:15','2022-12-12 07:08:53'),(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, \"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\", \"show_categories\": \"1\", \"show_created_at\": \"1\"}',NULL,NULL,1,1,'2022-11-23 10:14:01','2022-12-12 07:07:02');

--
-- 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),(1,6),(2,6),(4,6),(5,6),(13,6),(14,6),(15,6),(22,6);

--
-- 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','2022-09-14 04:56:19');


