-- Table structure for table `jb_jobs_categories`
--

CREATE TABLE `jb_jobs_categories` (
  `job_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs_categories`
--

INSERT INTO `jb_jobs_categories` VALUES (1,1),(1,5),(1,8),(2,1),(2,4),(2,9),(3,1),(3,2),(3,9),(4,1),(4,2),(4,9),(5,1),(5,4),(5,7),(6,1),(6,4),(6,6),(7,1),(7,4),(7,8),(8,1),(8,4),(8,8),(9,1),(9,3),(9,10),(10,1),(10,3),(10,10),(11,1),(11,5),(11,10),(12,1),(12,3),(12,6),(13,1),(13,5),(13,9),(14,1),(14,3),(14,8),(15,1),(15,5),(15,10),(16,1),(16,2),(16,10),(17,1),(17,4),(17,7),(18,1),(18,4),(18,10),(19,1),(19,5),(19,7),(20,1),(20,5),(20,6),(21,1),(21,3),(21,9),(22,1),(22,5),(22,10),(23,1),(23,3),(23,7),(24,1),(24,5),(24,8),(25,1),(25,4),(25,8),(26,1),(26,2),(26,7),(27,1),(27,4),(27,6),(28,1),(28,4),(28,7),(29,1),(29,3),(29,7),(30,1),(30,5),(30,10),(31,1),(31,3),(31,8),(32,1),(32,4),(32,6),(33,1),(33,5),(33,10),(34,1),(34,2),(34,6),(35,1),(35,3),(35,8),(36,1),(36,5),(36,8),(37,1),(37,2),(37,9),(38,1),(38,2),(38,7),(39,1),(39,5),(39,8),(40,1),(40,2),(40,6),(41,1),(41,5),(41,8),(42,1),(42,2),(42,7),(43,1),(43,4),(43,8),(44,1),(44,4),(44,7),(45,1),(45,5),(45,7),(46,1),(46,3),(46,9),(47,1),(47,4),(47,7),(48,1),(48,5),(48,6),(49,1),(49,2),(49,10),(50,1),(50,2),(50,6),(51,1),(51,3),(51,10);

--
-- Table structure for table `jb_jobs_skills`
--

CREATE TABLE `jb_jobs_skills` (
  `job_id` bigint unsigned NOT NULL,
  `job_skill_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs_skills`
--

INSERT INTO `jb_jobs_skills` VALUES (1,4),(2,6),(3,7),(4,9),(5,8),(6,6),(7,2),(8,1),(9,2),(10,8),(11,8),(12,5),(13,3),(14,7),(15,2),(16,8),(17,7),(18,6),(19,4),(20,6),(21,4),(22,4),(23,4),(24,5),(25,9),(26,5),(27,5),(28,4),(29,8),(30,5),(31,9),(32,6),(33,9),(34,5),(35,1),(36,5),(37,2),(38,6),(39,6),(40,3),(41,9),(42,5),(43,6),(44,5),(45,9),(46,5),(47,1),(48,2),(49,5),(50,8),(51,6);

--
-- Table structure for table `jb_jobs_tags`
--

CREATE TABLE `jb_jobs_tags` (
  `job_id` bigint unsigned NOT NULL,
  `tag_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`job_id`,`tag_id`),
  KEY `jb_jobs_tags_job_id_index` (`job_id`),
  KEY `jb_jobs_tags_tag_id_index` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs_tags`
--

INSERT INTO `jb_jobs_tags` VALUES (1,4),(1,6),(2,2),(2,7),(3,4),(3,7),(4,3),(4,7),(5,1),(5,6),(6,2),(6,5),(7,4),(7,8),(8,4),(8,8),(9,1),(9,8),(10,4),(10,8),(11,2),(11,6),(12,2),(12,7),(13,1),(13,7),(14,3),(14,6),(15,2),(15,8),(16,3),(16,6),(17,2),(17,6),(18,1),(18,8),(19,2),(19,7),(20,1),(20,7),(21,2),(21,5),(22,1),(22,8),(23,2),(23,8),(24,4),(24,7),(25,1),(25,7),(26,4),(26,7),(27,1),(27,6),(28,2),(28,6),(29,4),(29,8),(30,3),(30,8),(31,2),(31,5),(32,2),(32,7),(33,3),(33,7),(34,1),(34,6),(35,3),(35,8),(36,2),(36,6),(37,4),(37,8),(38,2),(38,5),(39,1),(39,7),(40,3),(40,5),(41,4),(41,8),(42,4),(42,8),(43,4),(43,7),(44,2),(44,6),(45,1),(45,8),(46,3),(46,5),(47,1),(47,6),(48,1),(48,8),(49,2),(49,6),(50,4),(50,8),(51,4),(51,8);

--
-- Table structure for table `jb_jobs_translations`
--

CREATE TABLE `jb_jobs_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_jobs_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`jb_jobs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs_translations`
--


--
-- Table structure for table `jb_jobs_types`
--

CREATE TABLE `jb_jobs_types` (
  `job_id` bigint unsigned NOT NULL,
  `job_type_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs_types`
--

INSERT INTO `jb_jobs_types` VALUES (1,4),(2,1),(3,4),(4,4),(5,2),(6,5),(7,4),(8,5),(9,1),(10,1),(11,4),(12,3),(13,1),(14,3),(15,4),(16,5),(17,2),(18,2),(19,5),(20,2),(21,2),(22,1),(23,2),(24,4),(25,5),(26,3),(27,2),(28,2),(29,5),(30,1),(31,1),(32,2),(33,1),(34,1),(35,5),(36,1),(37,2),(38,5),(39,2),(40,4),(41,2),(42,3),(43,3),(44,3),(45,4),(46,5),(47,5),(48,2),(49,5),(50,2),(51,1);

--
-- Table structure for table `jb_language_levels`
--

CREATE TABLE `jb_language_levels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_language_levels`
--

INSERT INTO `jb_language_levels` VALUES (1,'Expert',0,0,'published','2024-05-13 21:55:25','2024-05-13 21:55:25'),(2,'Intermediate',0,0,'published','2024-05-13 21:55:25','2024-05-13 21:55:25'),(3,'Beginner',0,0,'published','2024-05-13 21:55:25','2024-05-13 21:55:25');

--
-- Table structure for table `jb_language_levels_translations`
--

CREATE TABLE `jb_language_levels_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_language_levels_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_language_levels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_language_levels_translations`
--


--
-- Table structure for table `jb_major_subjects`
--

CREATE TABLE `jb_major_subjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_major_subjects`
--


--
-- Table structure for table `jb_packages`
--

CREATE TABLE `jb_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(15,2) unsigned NOT NULL,
  `currency_id` bigint unsigned NOT NULL,
  `percent_save` int unsigned DEFAULT '0',
  `number_of_listings` int unsigned NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `account_limit` int unsigned DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_packages`
--

INSERT INTO `jb_packages` VALUES (1,'Free First Post',0.00,1,0,1,0,1,0,'published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL),(2,'Single Post',250.00,1,0,1,0,NULL,1,'published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL),(3,'5 Posts',1000.00,1,20,5,0,NULL,0,'published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL);

--
-- Table structure for table `jb_packages_translations`
--

CREATE TABLE `jb_packages_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_packages_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_packages_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_packages_translations`
--


--
-- Table structure for table `jb_reviews`
--

CREATE TABLE `jb_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reviewable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reviewable_id` bigint unsigned NOT NULL,
  `created_by_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by_id` bigint unsigned NOT NULL,
  `star` double(8,2) NOT NULL,
  `review` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reviews_unique` (`reviewable_id`,`reviewable_type`,`created_by_id`,`created_by_type`),
  KEY `jb_reviews_reviewable_type_reviewable_id_index` (`reviewable_type`,`reviewable_id`),
  KEY `jb_reviews_created_by_type_created_by_id_index` (`created_by_type`,`created_by_id`),
  KEY `jb_reviews_reviewable_id_reviewable_type_status_index` (`reviewable_id`,`reviewable_type`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_reviews`
--

INSERT INTO `jb_reviews` VALUES (1,'Botble\\JobBoard\\Models\\Company',14,'Botble\\JobBoard\\Models\\Account',4,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(2,'Botble\\JobBoard\\Models\\Account',40,'Botble\\JobBoard\\Models\\Company',4,4.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(3,'Botble\\JobBoard\\Models\\Account',77,'Botble\\JobBoard\\Models\\Company',17,5.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(4,'Botble\\JobBoard\\Models\\Account',15,'Botble\\JobBoard\\Models\\Company',16,5.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(5,'Botble\\JobBoard\\Models\\Account',42,'Botble\\JobBoard\\Models\\Company',6,4.00,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(6,'Botble\\JobBoard\\Models\\Account',81,'Botble\\JobBoard\\Models\\Company',20,2.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(7,'Botble\\JobBoard\\Models\\Company',14,'Botble\\JobBoard\\Models\\Account',90,5.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(8,'Botble\\JobBoard\\Models\\Company',18,'Botble\\JobBoard\\Models\\Account',85,1.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(9,'Botble\\JobBoard\\Models\\Company',6,'Botble\\JobBoard\\Models\\Account',82,4.00,'Best ecommerce CMS online store!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(10,'Botble\\JobBoard\\Models\\Company',12,'Botble\\JobBoard\\Models\\Account',60,5.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(11,'Botble\\JobBoard\\Models\\Company',20,'Botble\\JobBoard\\Models\\Account',63,1.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(12,'Botble\\JobBoard\\Models\\Company',14,'Botble\\JobBoard\\Models\\Account',20,1.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(13,'Botble\\JobBoard\\Models\\Account',18,'Botble\\JobBoard\\Models\\Company',11,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(14,'Botble\\JobBoard\\Models\\Account',29,'Botble\\JobBoard\\Models\\Company',13,4.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(15,'Botble\\JobBoard\\Models\\Company',9,'Botble\\JobBoard\\Models\\Account',69,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(16,'Botble\\JobBoard\\Models\\Account',46,'Botble\\JobBoard\\Models\\Company',5,5.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(17,'Botble\\JobBoard\\Models\\Company',10,'Botble\\JobBoard\\Models\\Account',39,5.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(18,'Botble\\JobBoard\\Models\\Company',3,'Botble\\JobBoard\\Models\\Account',19,4.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(19,'Botble\\JobBoard\\Models\\Company',4,'Botble\\JobBoard\\Models\\Account',22,2.00,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(20,'Botble\\JobBoard\\Models\\Company',8,'Botble\\JobBoard\\Models\\Account',41,2.00,'Clean & perfect source code','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(21,'Botble\\JobBoard\\Models\\Account',18,'Botble\\JobBoard\\Models\\Company',17,1.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(22,'Botble\\JobBoard\\Models\\Company',13,'Botble\\JobBoard\\Models\\Account',75,2.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(23,'Botble\\JobBoard\\Models\\Account',56,'Botble\\JobBoard\\Models\\Company',10,5.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(24,'Botble\\JobBoard\\Models\\Account',45,'Botble\\JobBoard\\Models\\Company',20,5.00,'Good app, good backup service and support. Good documentation.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(25,'Botble\\JobBoard\\Models\\Account',49,'Botble\\JobBoard\\Models\\Company',4,1.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(26,'Botble\\JobBoard\\Models\\Company',7,'Botble\\JobBoard\\Models\\Account',85,4.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(27,'Botble\\JobBoard\\Models\\Company',16,'Botble\\JobBoard\\Models\\Account',24,3.00,'Best ecommerce CMS online store!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(28,'Botble\\JobBoard\\Models\\Account',12,'Botble\\JobBoard\\Models\\Company',17,3.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(29,'Botble\\JobBoard\\Models\\Company',12,'Botble\\JobBoard\\Models\\Account',29,2.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(30,'Botble\\JobBoard\\Models\\Account',82,'Botble\\JobBoard\\Models\\Company',10,1.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(31,'Botble\\JobBoard\\Models\\Company',7,'Botble\\JobBoard\\Models\\Account',13,3.00,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(32,'Botble\\JobBoard\\Models\\Company',13,'Botble\\JobBoard\\Models\\Account',24,5.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(33,'Botble\\JobBoard\\Models\\Company',6,'Botble\\JobBoard\\Models\\Account',77,4.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(34,'Botble\\JobBoard\\Models\\Company',15,'Botble\\JobBoard\\Models\\Account',3,4.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(35,'Botble\\JobBoard\\Models\\Company',8,'Botble\\JobBoard\\Models\\Account',84,2.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(36,'Botble\\JobBoard\\Models\\Account',55,'Botble\\JobBoard\\Models\\Company',5,4.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(37,'Botble\\JobBoard\\Models\\Account',66,'Botble\\JobBoard\\Models\\Company',8,2.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(38,'Botble\\JobBoard\\Models\\Company',15,'Botble\\JobBoard\\Models\\Account',30,3.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(39,'Botble\\JobBoard\\Models\\Company',7,'Botble\\JobBoard\\Models\\Account',99,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(40,'Botble\\JobBoard\\Models\\Account',84,'Botble\\JobBoard\\Models\\Company',10,5.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(41,'Botble\\JobBoard\\Models\\Account',67,'Botble\\JobBoard\\Models\\Company',18,5.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(42,'Botble\\JobBoard\\Models\\Account',23,'Botble\\JobBoard\\Models\\Company',16,1.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(43,'Botble\\JobBoard\\Models\\Company',9,'Botble\\JobBoard\\Models\\Account',87,2.00,'Clean & perfect source code','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(44,'Botble\\JobBoard\\Models\\Account',78,'Botble\\JobBoard\\Models\\Company',6,3.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(45,'Botble\\JobBoard\\Models\\Account',44,'Botble\\JobBoard\\Models\\Company',17,2.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(46,'Botble\\JobBoard\\Models\\Account',52,'Botble\\JobBoard\\Models\\Company',11,2.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(47,'Botble\\JobBoard\\Models\\Company',16,'Botble\\JobBoard\\Models\\Account',98,1.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(48,'Botble\\JobBoard\\Models\\Account',99,'Botble\\JobBoard\\Models\\Company',4,1.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(49,'Botble\\JobBoard\\Models\\Company',2,'Botble\\JobBoard\\Models\\Account',80,3.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(50,'Botble\\JobBoard\\Models\\Company',16,'Botble\\JobBoard\\Models\\Account',72,2.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(51,'Botble\\JobBoard\\Models\\Company',7,'Botble\\JobBoard\\Models\\Account',6,5.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(52,'Botble\\JobBoard\\Models\\Account',28,'Botble\\JobBoard\\Models\\Company',20,2.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(53,'Botble\\JobBoard\\Models\\Account',68,'Botble\\JobBoard\\Models\\Company',4,4.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(54,'Botble\\JobBoard\\Models\\Account',11,'Botble\\JobBoard\\Models\\Company',9,4.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(55,'Botble\\JobBoard\\Models\\Account',92,'Botble\\JobBoard\\Models\\Company',18,1.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(56,'Botble\\JobBoard\\Models\\Company',11,'Botble\\JobBoard\\Models\\Account',3,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(57,'Botble\\JobBoard\\Models\\Company',18,'Botble\\JobBoard\\Models\\Account',99,1.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(58,'Botble\\JobBoard\\Models\\Company',15,'Botble\\JobBoard\\Models\\Account',65,4.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(59,'Botble\\JobBoard\\Models\\Account',15,'Botble\\JobBoard\\Models\\Company',19,1.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(60,'Botble\\JobBoard\\Models\\Account',81,'Botble\\JobBoard\\Models\\Company',7,2.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(61,'Botble\\JobBoard\\Models\\Account',74,'Botble\\JobBoard\\Models\\Company',13,5.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(62,'Botble\\JobBoard\\Models\\Account',15,'Botble\\JobBoard\\Models\\Company',11,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(63,'Botble\\JobBoard\\Models\\Account',40,'Botble\\JobBoard\\Models\\Company',1,4.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(64,'Botble\\JobBoard\\Models\\Account',4,'Botble\\JobBoard\\Models\\Company',13,3.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(65,'Botble\\JobBoard\\Models\\Company',11,'Botble\\JobBoard\\Models\\Account',70,1.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(66,'Botble\\JobBoard\\Models\\Account',34,'Botble\\JobBoard\\Models\\Company',2,4.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(67,'Botble\\JobBoard\\Models\\Company',15,'Botble\\JobBoard\\Models\\Account',89,1.00,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(68,'Botble\\JobBoard\\Models\\Account',5,'Botble\\JobBoard\\Models\\Company',11,3.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(69,'Botble\\JobBoard\\Models\\Company',13,'Botble\\JobBoard\\Models\\Account',45,5.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(70,'Botble\\JobBoard\\Models\\Account',91,'Botble\\JobBoard\\Models\\Company',7,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(71,'Botble\\JobBoard\\Models\\Company',16,'Botble\\JobBoard\\Models\\Account',20,5.00,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(72,'Botble\\JobBoard\\Models\\Account',34,'Botble\\JobBoard\\Models\\Company',17,2.00,'Good app, good backup service and support. Good documentation.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(73,'Botble\\JobBoard\\Models\\Company',12,'Botble\\JobBoard\\Models\\Account',73,4.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(74,'Botble\\JobBoard\\Models\\Account',28,'Botble\\JobBoard\\Models\\Company',2,3.00,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(75,'Botble\\JobBoard\\Models\\Account',75,'Botble\\JobBoard\\Models\\Company',16,3.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(76,'Botble\\JobBoard\\Models\\Company',20,'Botble\\JobBoard\\Models\\Account',50,1.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(77,'Botble\\JobBoard\\Models\\Company',20,'Botble\\JobBoard\\Models\\Account',61,1.00,'Clean & perfect source code','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(78,'Botble\\JobBoard\\Models\\Company',18,'Botble\\JobBoard\\Models\\Account',43,4.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(79,'Botble\\JobBoard\\Models\\Account',66,'Botble\\JobBoard\\Models\\Company',10,5.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(80,'Botble\\JobBoard\\Models\\Account',1,'Botble\\JobBoard\\Models\\Company',1,3.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(81,'Botble\\JobBoard\\Models\\Account',88,'Botble\\JobBoard\\Models\\Company',10,1.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(82,'Botble\\JobBoard\\Models\\Account',72,'Botble\\JobBoard\\Models\\Company',20,4.00,'Best ecommerce CMS online store!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(83,'Botble\\JobBoard\\Models\\Company',12,'Botble\\JobBoard\\Models\\Account',11,4.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(85,'Botble\\JobBoard\\Models\\Company',3,'Botble\\JobBoard\\Models\\Account',74,4.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(86,'Botble\\JobBoard\\Models\\Account',19,'Botble\\JobBoard\\Models\\Company',17,5.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(87,'Botble\\JobBoard\\Models\\Company',19,'Botble\\JobBoard\\Models\\Account',22,2.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(88,'Botble\\JobBoard\\Models\\Company',19,'Botble\\JobBoard\\Models\\Account',81,2.00,'Good app, good backup service and support. Good documentation.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(89,'Botble\\JobBoard\\Models\\Account',31,'Botble\\JobBoard\\Models\\Company',10,1.00,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(90,'Botble\\JobBoard\\Models\\Account',83,'Botble\\JobBoard\\Models\\Company',3,2.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(91,'Botble\\JobBoard\\Models\\Company',17,'Botble\\JobBoard\\Models\\Account',30,2.00,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(92,'Botble\\JobBoard\\Models\\Company',9,'Botble\\JobBoard\\Models\\Account',61,4.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(93,'Botble\\JobBoard\\Models\\Company',15,'Botble\\JobBoard\\Models\\Account',25,1.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(94,'Botble\\JobBoard\\Models\\Account',43,'Botble\\JobBoard\\Models\\Company',16,1.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(95,'Botble\\JobBoard\\Models\\Company',17,'Botble\\JobBoard\\Models\\Account',13,5.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(96,'Botble\\JobBoard\\Models\\Account',30,'Botble\\JobBoard\\Models\\Company',5,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(97,'Botble\\JobBoard\\Models\\Company',5,'Botble\\JobBoard\\Models\\Account',8,2.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(98,'Botble\\JobBoard\\Models\\Company',11,'Botble\\JobBoard\\Models\\Account',57,3.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(99,'Botble\\JobBoard\\Models\\Company',2,'Botble\\JobBoard\\Models\\Account',59,3.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(100,'Botble\\JobBoard\\Models\\Account',18,'Botble\\JobBoard\\Models\\Company',8,2.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2024-05-13 21:55:53','2024-05-13 21:55:53');

--
-- Table structure for table `jb_saved_jobs`
--

CREATE TABLE `jb_saved_jobs` (
  `account_id` bigint unsigned NOT NULL,
  `job_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`account_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_saved_jobs`
--


--
-- Table structure for table `jb_tags`
--

CREATE TABLE `jb_tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_tags`
--

INSERT INTO `jb_tags` VALUES (1,'Illustrator','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(2,'Adobe XD','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(3,'Figma','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(4,'Sketch','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(5,'Lunacy','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(6,'PHP','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(7,'Python','','published','2024-05-13 21:55:26','2024-05-13 21:55:26'),(8,'JavaScript','','published','2024-05-13 21:55:26','2024-05-13 21:55:26');

--
-- Table structure for table `jb_tags_translations`
--

CREATE TABLE `jb_tags_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_tags_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_tags_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_tags_translations`
--


--
-- Table structure for table `jb_transactions`
--

CREATE TABLE `jb_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `credits` int unsigned NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `account_id` bigint unsigned DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'add',
  `payment_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_transactions`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `language_meta`
--

CREATE TABLE `language_meta` (
  `lang_meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lang_meta_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang_meta_origin` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`lang_meta_id`),
  KEY `language_meta_reference_id_index` (`reference_id`),
  KEY `meta_code_index` (`lang_meta_code`),
  KEY `meta_origin_index` (`lang_meta_origin`),
  KEY `meta_reference_type_index` (`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `language_meta`
--

INSERT INTO `language_meta` VALUES (1,'en_US','6e3ceb30d7f0cd36f954174eb7980e4f',1,'Botble\\Menu\\Models\\MenuLocation'),(2,'en_US','6b1e0688c216b3161c20488b57eced5a',1,'Botble\\Menu\\Models\\Menu'),(3,'en_US','ae75ee6679f85038b3c41f360c13b702',2,'Botble\\Menu\\Models\\Menu'),(4,'en_US','88d57cd7e3ebdac624d62e1d04614da9',3,'Botble\\Menu\\Models\\Menu'),(5,'en_US','4fb757a79a729f87e9131c721852ea25',4,'Botble\\Menu\\Models\\Menu'),(6,'en_US','d7ab7e14c719999569fb52ddaae0c47a',5,'Botble\\Menu\\Models\\Menu');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `lang_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lang_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_locale` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_flag` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang_is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `lang_order` int NOT NULL DEFAULT '0',
  `lang_is_rtl` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`lang_id`),
  KEY `lang_locale_index` (`lang_locale`),
  KEY `lang_code_index` (`lang_code`),
  KEY `lang_is_default_index` (`lang_is_default`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'English','en','en_US','us',1,0,0);

--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder_id` bigint unsigned NOT NULL DEFAULT '0',
  `mime_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `visibility` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  PRIMARY KEY (`id`),
  KEY `media_files_user_id_index` (`user_id`),
  KEY `media_files_index` (`folder_id`,`user_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_files`
--

INSERT INTO `media_files` VALUES (41,0,'acer','acer',3,'image/png',285,'our-partners/acer.png','[]','2024-05-13 21:55:19','2024-05-13 21:55:19',NULL,'public'),(42,0,'asus','asus',3,'image/png',314,'our-partners/asus.png','[]','2024-05-13 21:55:19','2024-05-13 21:55:19',NULL,'public'),(43,0,'dell','dell',3,'image/png',296,'our-partners/dell.png','[]','2024-05-13 21:55:19','2024-05-13 21:55:19',NULL,'public'),(44,0,'microsoft','microsoft',3,'image/png',287,'our-partners/microsoft.png','[]','2024-05-13 21:55:19','2024-05-13 21:55:19',NULL,'public'),(45,0,'nokia','nokia',3,'image/png',308,'our-partners/nokia.png','[]','2024-05-13 21:55:19','2024-05-13 21:55:19',NULL,'public'),(46,0,'1','1',4,'image/jpeg',9803,'news/1.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(47,0,'10','10',4,'image/jpeg',9803,'news/10.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(48,0,'11','11',4,'image/jpeg',9803,'news/11.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(49,0,'12','12',4,'image/jpeg',9803,'news/12.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(50,0,'13','13',4,'image/jpeg',9803,'news/13.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(51,0,'14','14',4,'image/jpeg',9803,'news/14.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(52,0,'15','15',4,'image/jpeg',9803,'news/15.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(53,0,'16','16',4,'image/jpeg',9803,'news/16.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(54,0,'2','2',4,'image/jpeg',9803,'news/2.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(55,0,'3','3',4,'image/jpeg',9803,'news/3.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(56,0,'4','4',4,'image/jpeg',9803,'news/4.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(57,0,'5','5',4,'image/jpeg',9803,'news/5.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(58,0,'6','6',4,'image/jpeg',9803,'news/6.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(59,0,'7','7',4,'image/jpeg',9803,'news/7.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(60,0,'8','8',4,'image/jpeg',9803,'news/8.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(61,0,'9','9',4,'image/jpeg',9803,'news/9.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(62,0,'cover-image1','cover-image1',4,'image/png',9803,'news/cover-image1.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(63,0,'cover-image2','cover-image2',4,'image/png',9803,'news/cover-image2.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(64,0,'cover-image3','cover-image3',4,'image/png',9803,'news/cover-image3.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(65,0,'img-news1','img-news1',4,'image/png',9803,'news/img-news1.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(66,0,'img-news2','img-news2',4,'image/png',9803,'news/img-news2.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(67,0,'img-news3','img-news3',4,'image/png',9803,'news/img-news3.png','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(68,0,'1','1',5,'image/jpeg',6977,'galleries/1.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(69,0,'10','10',5,'image/jpeg',9803,'galleries/10.jpg','[]','2024-05-13 21:55:20','2024-05-13 21:55:20',NULL,'public'),(70,0,'2','2',5,'image/jpeg',6977,'galleries/2.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(71,0,'3','3',5,'image/jpeg',6977,'galleries/3.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(72,0,'4','4',5,'image/jpeg',6977,'galleries/4.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(73,0,'5','5',5,'image/jpeg',6977,'galleries/5.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(74,0,'6','6',5,'image/jpeg',6977,'galleries/6.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(75,0,'7','7',5,'image/jpeg',6977,'galleries/7.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(76,0,'8','8',5,'image/jpeg',9803,'galleries/8.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(77,0,'9','9',5,'image/jpeg',9803,'galleries/9.jpg','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(78,0,'widget-banner','widget-banner',6,'image/png',11079,'widgets/widget-banner.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(79,0,'404','404',7,'image/png',10947,'general/404.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(80,0,'android','android',7,'image/png',477,'general/android.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(81,0,'app-store','app-store',7,'image/png',477,'general/app-store.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(82,0,'content','content',7,'image/png',1692,'general/content.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(83,0,'cover-image','cover-image',7,'image/png',8992,'general/cover-image.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(84,0,'customer','customer',7,'image/png',2810,'general/customer.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(85,0,'favicon','favicon',7,'image/png',706,'general/favicon.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(86,0,'finance','finance',7,'image/png',2460,'general/finance.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(87,0,'human','human',7,'image/png',2359,'general/human.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(88,0,'img-about2','img-about2',7,'image/png',36911,'general/img-about2.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(89,0,'lightning','lightning',7,'image/png',2768,'general/lightning.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(90,0,'logo-company','logo-company',7,'image/png',3166,'general/logo-company.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(91,0,'logo-light','logo-light',7,'image/png',2352,'general/logo-light.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(92,0,'logo','logo',7,'image/png',2459,'general/logo.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(93,0,'management','management',7,'image/png',1915,'general/management.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(94,0,'marketing','marketing',7,'image/png',2134,'general/marketing.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(95,0,'newsletter-background-image','newsletter-background-image',7,'image/png',9830,'general/newsletter-background-image.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(96,0,'newsletter-image-left','newsletter-image-left',7,'image/png',4177,'general/newsletter-image-left.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(97,0,'newsletter-image-right','newsletter-image-right',7,'image/png',2886,'general/newsletter-image-right.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(98,0,'research','research',7,'image/png',3206,'general/research.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(99,0,'retail','retail',7,'image/png',2874,'general/retail.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(100,0,'security','security',7,'image/png',2986,'general/security.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(101,0,'img-1','img-1',8,'image/png',2377,'authentication/img-1.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(102,0,'img-2','img-2',8,'image/png',5009,'authentication/img-2.png','[]','2024-05-13 21:55:21','2024-05-13 21:55:21',NULL,'public'),(103,0,'background-cover-candidate','background-cover-candidate',9,'image/png',436821,'pages/background-cover-candidate.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(104,0,'background_breadcrumb','background_breadcrumb',9,'image/png',6111,'pages/background-breadcrumb.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(105,0,'banner-section-search-box','banner-section-search-box',9,'image/png',20501,'pages/banner-section-search-box.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(106,0,'banner1','banner1',9,'image/png',7381,'pages/banner1.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(107,0,'banner2','banner2',9,'image/png',4920,'pages/banner2.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(108,0,'banner3','banner3',9,'image/png',2472,'pages/banner3.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(109,0,'banner4','banner4',9,'image/png',1952,'pages/banner4.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(110,0,'banner5','banner5',9,'image/png',1545,'pages/banner5.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(111,0,'banner6','banner6',9,'image/png',1609,'pages/banner6.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(112,0,'bg-breadcrumb','bg-breadcrumb',9,'image/png',14250,'pages/bg-breadcrumb.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(113,0,'bg-cat','bg-cat',9,'image/png',60543,'pages/bg-cat.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(114,0,'bg-left-hiring','bg-left-hiring',9,'image/png',1631,'pages/bg-left-hiring.png','[]','2024-05-13 21:55:22','2024-05-13 21:55:22',NULL,'public'),(115,0,'bg-newsletter','bg-newsletter',9,'image/png',4587,'pages/bg-newsletter.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(116,0,'bg-right-hiring','bg-right-hiring',9,'image/png',3074,'pages/bg-right-hiring.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(117,0,'controlcard','controlcard',9,'image/png',7404,'pages/controlcard.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(118,0,'home-page-4-banner','home-page-4-banner',9,'image/png',7596,'pages/home-page-4-banner.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(119,0,'icon-bottom-banner','icon-bottom-banner',9,'image/png',274,'pages/icon-bottom-banner.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(120,0,'icon-top-banner','icon-top-banner',9,'image/png',362,'pages/icon-top-banner.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(121,0,'img-banner','img-banner',9,'image/png',10542,'pages/img-banner.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(122,0,'img-chart','img-chart',9,'image/png',7549,'pages/img-chart.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(123,0,'img-job-search','img-job-search',9,'image/png',35569,'pages/img-job-search.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(124,0,'img-profile','img-profile',9,'image/png',9177,'pages/img-profile.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(125,0,'img-single','img-single',9,'image/png',13060,'pages/img-single.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(126,0,'img1','img1',9,'image/png',10246,'pages/img1.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(127,0,'job-tools','job-tools',9,'image/png',2216,'pages/job-tools.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(128,0,'left-job-head','left-job-head',9,'image/png',14956,'pages/left-job-head.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(129,0,'newsletter-left','newsletter-left',9,'image/png',4177,'pages/newsletter-left.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(130,0,'newsletter-right','newsletter-right',9,'image/png',2886,'pages/newsletter-right.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(131,0,'planning-job','planning-job',9,'image/png',1623,'pages/planning-job.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(132,0,'right-job-head','right-job-head',9,'image/png',10955,'pages/right-job-head.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(133,0,'facebook','facebook',10,'image/png',795,'socials/facebook.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(134,0,'linkedin','linkedin',10,'image/png',804,'socials/linkedin.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(135,0,'twitter','twitter',10,'image/png',1029,'socials/twitter.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(136,0,'location1','location1',11,'image/png',5149,'locations/location1.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(137,0,'location2','location2',11,'image/png',5921,'locations/location2.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(138,0,'location3','location3',11,'image/png',5276,'locations/location3.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(139,0,'location4','location4',11,'image/png',5259,'locations/location4.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(140,0,'location5','location5',11,'image/png',5140,'locations/location5.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(141,0,'location6','location6',11,'image/png',4891,'locations/location6.png','[]','2024-05-13 21:55:23','2024-05-13 21:55:23',NULL,'public'),(142,0,'1','1',12,'image/png',407,'job-categories/1.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(143,0,'10','10',12,'image/png',407,'job-categories/10.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(144,0,'11','11',12,'image/png',407,'job-categories/11.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(145,0,'12','12',12,'image/png',407,'job-categories/12.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(146,0,'13','13',12,'image/png',407,'job-categories/13.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(147,0,'14','14',12,'image/png',407,'job-categories/14.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(148,0,'15','15',12,'image/png',407,'job-categories/15.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(149,0,'16','16',12,'image/png',407,'job-categories/16.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(150,0,'17','17',12,'image/png',407,'job-categories/17.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(151,0,'18','18',12,'image/png',407,'job-categories/18.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(152,0,'19','19',12,'image/png',407,'job-categories/19.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(153,0,'2','2',12,'image/png',407,'job-categories/2.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(154,0,'3','3',12,'image/png',407,'job-categories/3.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(155,0,'4','4',12,'image/png',407,'job-categories/4.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(156,0,'5','5',12,'image/png',407,'job-categories/5.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(157,0,'6','6',12,'image/png',407,'job-categories/6.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(158,0,'7','7',12,'image/png',407,'job-categories/7.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(159,0,'8','8',12,'image/png',407,'job-categories/8.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(160,0,'9','9',12,'image/png',407,'job-categories/9.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(161,0,'img-cover-1','img-cover-1',12,'image/png',33918,'job-categories/img-cover-1.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(162,0,'img-cover-2','img-cover-2',12,'image/png',33918,'job-categories/img-cover-2.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(163,0,'img-cover-3','img-cover-3',12,'image/png',33918,'job-categories/img-cover-3.png','[]','2024-05-13 21:55:24','2024-05-13 21:55:24',NULL,'public'),(164,0,'1','1',13,'image/png',598,'companies/1.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(165,0,'2','2',13,'image/png',598,'companies/2.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(166,0,'3','3',13,'image/png',598,'companies/3.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(167,0,'4','4',13,'image/png',598,'companies/4.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(168,0,'5','5',13,'image/png',598,'companies/5.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(169,0,'6','6',13,'image/png',598,'companies/6.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(170,0,'7','7',13,'image/png',598,'companies/7.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(171,0,'8','8',13,'image/png',598,'companies/8.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(172,0,'9','9',13,'image/png',598,'companies/9.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(173,0,'company-cover-image','company-cover-image',13,'image/png',8992,'companies/company-cover-image.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(174,0,'img1','img1',14,'image/png',5706,'jobs/img1.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(175,0,'img2','img2',14,'image/png',5706,'jobs/img2.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(176,0,'img3','img3',14,'image/png',5706,'jobs/img3.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(177,0,'img4','img4',14,'image/png',5706,'jobs/img4.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(178,0,'img5','img5',14,'image/png',5706,'jobs/img5.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(179,0,'img6','img6',14,'image/png',5706,'jobs/img6.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(180,0,'img7','img7',14,'image/png',5706,'jobs/img7.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(181,0,'img8','img8',14,'image/png',5706,'jobs/img8.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(182,0,'img9','img9',14,'image/png',5706,'jobs/img9.png','[]','2024-05-13 21:55:25','2024-05-13 21:55:25',NULL,'public'),(183,0,'01','01',15,'application/pdf',43496,'resume/01.pdf','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(184,0,'1','1',16,'image/png',3090,'avatars/1.png','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(185,0,'2','2',16,'image/png',2773,'avatars/2.png','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(186,0,'3','3',16,'image/png',2749,'avatars/3.png','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(187,0,'1','1',17,'image/png',395380,'covers/1.png','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(188,0,'2','2',17,'image/png',1308067,'covers/2.png','[]','2024-05-13 21:55:27','2024-05-13 21:55:27',NULL,'public'),(189,0,'3','3',17,'image/png',301502,'covers/3.png','[]','2024-05-13 21:55:28','2024-05-13 21:55:28',NULL,'public'),(190,0,'1','1',18,'image/png',4294,'teams/1.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(191,0,'2','2',18,'image/png',4294,'teams/2.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(192,0,'3','3',18,'image/png',4294,'teams/3.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(193,0,'4','4',18,'image/png',4294,'teams/4.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(194,0,'5','5',18,'image/png',4294,'teams/5.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(195,0,'6','6',18,'image/png',4294,'teams/6.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(196,0,'7','7',18,'image/png',4294,'teams/7.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(197,0,'8','8',18,'image/png',4294,'teams/8.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(198,0,'1','1',19,'image/png',3943,'testimonials/1.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(199,0,'2','2',19,'image/png',3943,'testimonials/2.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(200,0,'3','3',19,'image/png',3943,'testimonials/3.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public'),(201,0,'4','4',19,'image/png',3943,'testimonials/4.png','[]','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,'public');

--
-- Table structure for table `media_folders`
--

CREATE TABLE `media_folders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_folders_user_id_index` (`user_id`),
  KEY `media_folders_index` (`parent_id`,`user_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_folders`
--

INSERT INTO `media_folders` VALUES (3,0,'our-partners',NULL,'our-partners',0,'2024-05-13 21:55:19','2024-05-13 21:55:19',NULL),(4,0,'news',NULL,'news',0,'2024-05-13 21:55:20','2024-05-13 21:55:20',NULL),(5,0,'galleries',NULL,'galleries',0,'2024-05-13 21:55:20','2024-05-13 21:55:20',NULL),(6,0,'widgets',NULL,'widgets',0,'2024-05-13 21:55:21','2024-05-13 21:55:21',NULL),(7,0,'general',NULL,'general',0,'2024-05-13 21:55:21','2024-05-13 21:55:21',NULL),(8,0,'authentication',NULL,'authentication',0,'2024-05-13 21:55:21','2024-05-13 21:55:21',NULL),(9,0,'pages',NULL,'pages',0,'2024-05-13 21:55:21','2024-05-13 21:55:21',NULL),(10,0,'socials',NULL,'socials',0,'2024-05-13 21:55:23','2024-05-13 21:55:23',NULL),(11,0,'locations',NULL,'locations',0,'2024-05-13 21:55:23','2024-05-13 21:55:23',NULL),(12,0,'job-categories',NULL,'job-categories',0,'2024-05-13 21:55:24','2024-05-13 21:55:24',NULL),(13,0,'companies',NULL,'companies',0,'2024-05-13 21:55:25','2024-05-13 21:55:25',NULL),(14,0,'jobs',NULL,'jobs',0,'2024-05-13 21:55:25','2024-05-13 21:55:25',NULL),(15,0,'resume',NULL,'resume',0,'2024-05-13 21:55:27','2024-05-13 21:55:27',NULL),(16,0,'avatars',NULL,'avatars',0,'2024-05-13 21:55:27','2024-05-13 21:55:27',NULL),(17,0,'covers',NULL,'covers',0,'2024-05-13 21:55:27','2024-05-13 21:55:27',NULL),(18,0,'teams',NULL,'teams',0,'2024-05-13 21:55:53','2024-05-13 21:55:53',NULL),(19,0,'testimonials',NULL,'testimonials',0,'2024-05-13 21:55:53','2024-05-13 21:55:53',NULL);

--
-- Table structure for table `media_settings`
--

CREATE TABLE `media_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `media_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_settings`
--


--
-- Table structure for table `menu_locations`
--

CREATE TABLE `menu_locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `location` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_locations_menu_id_created_at_index` (`menu_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_locations`
--

INSERT INTO `menu_locations` VALUES (1,1,'main-menu','2024-05-13 21:55:53','2024-05-13 21:55:53');

--
-- Table structure for table `menu_nodes`
--

CREATE TABLE `menu_nodes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `reference_id` bigint unsigned DEFAULT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_font` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `has_child` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_nodes_menu_id_index` (`menu_id`),
  KEY `menu_nodes_parent_id_index` (`parent_id`),
  KEY `reference_id` (`reference_id`),
  KEY `reference_type` (`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_nodes`
--

INSERT INTO `menu_nodes` VALUES (1,1,0,NULL,NULL,'/',NULL,0,'Home',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(2,1,1,1,'Botble\\Page\\Models\\Page','/homepage-1','fi fi-rr-home',1,'Home 1',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(3,1,1,2,'Botble\\Page\\Models\\Page','/homepage-2','fi fi-rr-home',2,'Home 2',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(4,1,1,3,'Botble\\Page\\Models\\Page','/homepage-3','fi fi-rr-home',3,'Home 3',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(5,1,1,4,'Botble\\Page\\Models\\Page','/homepage-4','fi fi-rr-home',4,'Home 4',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(6,1,1,5,'Botble\\Page\\Models\\Page','/homepage-5','fi fi-rr-home',5,'Home 5',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(7,1,1,6,'Botble\\Page\\Models\\Page','/homepage-6','fi fi-rr-home',6,'Home 6',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(8,1,0,7,'Botble\\Page\\Models\\Page','/jobs',NULL,0,'Find a Job',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(9,1,8,NULL,NULL,'/jobs?layout=grid','fi fi-rr-briefcase',0,'Jobs Grid',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(10,1,8,NULL,NULL,'/jobs','fi fi-rr-briefcase',0,'Jobs List',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(11,1,8,NULL,NULL,'/jobs/ui-ux-designer-full-time','fi fi-rr-briefcase',0,'Job Details',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(12,1,8,NULL,NULL,'/jobs/full-stack-engineer','fi fi-rr-briefcase',0,'Job External',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(13,1,8,NULL,NULL,'/jobs/java-software-engineer','fi fi-rr-briefcase',0,'Job Hide Company',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(14,1,0,8,'Botble\\Page\\Models\\Page','/companies',NULL,0,'Companies',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(15,1,14,8,'Botble\\Page\\Models\\Page','/companies','fi fi-rr-briefcase',0,'Companies',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(16,1,14,NULL,NULL,'/companies/linkedin','fi fi-rr-info',0,'Company Details',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(17,1,0,9,'Botble\\Page\\Models\\Page','/candidates',NULL,0,'Candidates',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(18,1,17,9,'Botble\\Page\\Models\\Page','/candidates','fi fi-rr-user',0,'Candidates Grid',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(19,1,17,NULL,NULL,'/candidates/corine','fi fi-rr-info',0,'Candidate Details',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(20,1,0,NULL,NULL,'#',NULL,0,'Pages',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(21,1,20,10,'Botble\\Page\\Models\\Page','/about-us','fi fi-rr-star',0,'About Us',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(22,1,20,11,'Botble\\Page\\Models\\Page','/pricing-plan','fi fi-rr-database',0,'Pricing Plan',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(23,1,20,12,'Botble\\Page\\Models\\Page','/contact','fi fi-rr-paper-plane',0,'Contact Us',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(24,1,20,NULL,NULL,'/register','fi fi-rr-user-add',0,'Register',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(25,1,20,NULL,NULL,'/login','fi fi-rr-fingerprint',0,'Sign in',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(26,1,20,NULL,NULL,'/password/request','fi fi-rr-settings',0,'Reset Password',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(27,1,0,13,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog',NULL,'_self',1,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(28,1,27,13,'Botble\\Page\\Models\\Page','/blog','fi fi-rr-edit',0,'Blog Grid',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(29,1,27,NULL,NULL,'/blog/interview-question-why-dont-you-have-a-degree','fi fi-rr-document-signed',0,'Blog Single',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(30,2,0,10,'Botble\\Page\\Models\\Page','/about-us',NULL,0,'About Us',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(31,2,0,NULL,NULL,'#',NULL,0,'Our Team',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(32,2,0,NULL,NULL,'#',NULL,0,'Products',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(33,2,0,12,'Botble\\Page\\Models\\Page','/contact',NULL,0,'Contact',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(34,3,0,10,'Botble\\Page\\Models\\Page','/about-us',NULL,0,'Feature',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(35,3,0,11,'Botble\\Page\\Models\\Page','/pricing-plan',NULL,0,'Pricing',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(36,3,0,NULL,NULL,'#',NULL,0,'Credit',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(37,3,0,15,'Botble\\Page\\Models\\Page','/faqs',NULL,0,'FAQ',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(38,4,0,NULL,NULL,'#',NULL,0,'iOS',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(39,4,0,NULL,NULL,'#',NULL,0,'Android',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(40,4,0,NULL,NULL,'#',NULL,0,'Microsoft',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(41,4,0,NULL,NULL,'#',NULL,0,'Desktop',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(42,5,0,14,'Botble\\Page\\Models\\Page','/cookie-policy',NULL,0,'Cookie Policy',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(43,5,0,17,'Botble\\Page\\Models\\Page','/terms',NULL,0,'Terms',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53'),(44,5,0,5,'Botble\\Page\\Models\\Page','/homepage-5',NULL,0,'FAQ',NULL,'_self',0,'2024-05-13 21:55:53','2024-05-13 21:55:53');

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

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menus` VALUES (1,'Main menu','main-menu','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(2,'Resources','resources','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(3,'Community','community','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(4,'Quick links','quick-links','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(5,'More','more','published','2024-05-13 21:55:53','2024-05-13 21:55:53');

--
-- Table structure for table `meta_boxes`
--

CREATE TABLE `meta_boxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `meta_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `meta_boxes_reference_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_boxes`
--

INSERT INTO `meta_boxes` VALUES (1,'background_breadcrumb','[\"pages\\/background-breadcrumb.png\"]',10,'Botble\\Page\\Models\\Page','2024-05-13 21:55:19','2024-05-13 21:55:19'),(2,'background_breadcrumb','[\"pages\\/background-breadcrumb.png\"]',12,'Botble\\Page\\Models\\Page','2024-05-13 21:55:20','2024-05-13 21:55:20'),(3,'cover_image','[\"news\\/cover-image1.png\"]',1,'Botble\\Blog\\Models\\Post','2024-05-13 21:55:20','2024-05-13 21:55:20'),(4,'cover_image','[\"news\\/cover-image2.png\"]',2,'Botble\\Blog\\Models\\Post','2024-05-13 21:55:20','2024-05-13 21:55:20'),(5,'cover_image','[\"news\\/cover-image3.png\"]',3,'Botble\\Blog\\Models\\Post','2024-05-13 21:55:20','2024-05-13 21:55:20'),(6,'icon_image','[\"general\\/content.png\"]',1,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(7,'job_category_image','[\"job-categories\\/img-cover-2.png\"]',1,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(8,'icon_image','[\"general\\/research.png\"]',2,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(9,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',2,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(10,'icon_image','[\"general\\/marketing.png\"]',3,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(11,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',3,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(12,'icon_image','[\"general\\/customer.png\"]',4,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(13,'job_category_image','[\"job-categories\\/img-cover-1.png\"]',4,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(14,'icon_image','[\"general\\/finance.png\"]',5,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(15,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',5,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(16,'icon_image','[\"general\\/lightning.png\"]',6,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(17,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',6,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(18,'icon_image','[\"general\\/human.png\"]',7,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(19,'job_category_image','[\"job-categories\\/img-cover-2.png\"]',7,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(20,'icon_image','[\"general\\/management.png\"]',8,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:24','2024-05-13 21:55:24'),(21,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',8,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:25','2024-05-13 21:55:25'),(22,'icon_image','[\"general\\/retail.png\"]',9,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:25','2024-05-13 21:55:25'),(23,'job_category_image','[\"job-categories\\/img-cover-3.png\"]',9,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:25','2024-05-13 21:55:25'),(24,'icon_image','[\"general\\/security.png\"]',10,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:25','2024-05-13 21:55:25'),(25,'job_category_image','[\"job-categories\\/img-cover-2.png\"]',10,'Botble\\JobBoard\\Models\\Category','2024-05-13 21:55:25','2024-05-13 21:55:25'),(26,'cover_image','[\"companies\\/company-cover-image.png\"]',1,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(27,'cover_image','[\"companies\\/company-cover-image.png\"]',2,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(28,'cover_image','[\"companies\\/company-cover-image.png\"]',3,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(29,'cover_image','[\"companies\\/company-cover-image.png\"]',4,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(30,'cover_image','[\"companies\\/company-cover-image.png\"]',5,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(31,'cover_image','[\"companies\\/company-cover-image.png\"]',6,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(32,'cover_image','[\"companies\\/company-cover-image.png\"]',7,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(33,'cover_image','[\"companies\\/company-cover-image.png\"]',8,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(34,'cover_image','[\"companies\\/company-cover-image.png\"]',9,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(35,'cover_image','[\"companies\\/company-cover-image.png\"]',10,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(36,'cover_image','[\"companies\\/company-cover-image.png\"]',11,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(37,'cover_image','[\"companies\\/company-cover-image.png\"]',12,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(38,'cover_image','[\"companies\\/company-cover-image.png\"]',13,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(39,'cover_image','[\"companies\\/company-cover-image.png\"]',14,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(40,'cover_image','[\"companies\\/company-cover-image.png\"]',15,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(41,'cover_image','[\"companies\\/company-cover-image.png\"]',16,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(42,'cover_image','[\"companies\\/company-cover-image.png\"]',17,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(43,'cover_image','[\"companies\\/company-cover-image.png\"]',18,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(44,'cover_image','[\"companies\\/company-cover-image.png\"]',19,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(45,'cover_image','[\"companies\\/company-cover-image.png\"]',20,'Botble\\JobBoard\\Models\\Company','2024-05-13 21:55:25','2024-05-13 21:55:25'),(46,'featured_image','[\"jobs\\/img1.png\"]',1,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(47,'featured_image','[\"jobs\\/img2.png\"]',2,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(48,'featured_image','[\"jobs\\/img3.png\"]',3,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(49,'featured_image','[\"jobs\\/img4.png\"]',4,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(50,'featured_image','[\"jobs\\/img5.png\"]',5,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(51,'featured_image','[\"jobs\\/img6.png\"]',6,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(52,'featured_image','[\"jobs\\/img7.png\"]',7,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(53,'featured_image','[\"jobs\\/img8.png\"]',8,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(54,'featured_image','[\"jobs\\/img9.png\"]',9,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(55,'featured_image','[\"jobs\\/img8.png\"]',10,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(56,'featured_image','[\"jobs\\/img8.png\"]',11,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(57,'featured_image','[\"jobs\\/img3.png\"]',12,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(58,'featured_image','[\"jobs\\/img1.png\"]',13,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(59,'featured_image','[\"jobs\\/img1.png\"]',14,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(60,'featured_image','[\"jobs\\/img4.png\"]',15,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(61,'featured_image','[\"jobs\\/img6.png\"]',16,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(62,'featured_image','[\"jobs\\/img5.png\"]',17,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(63,'featured_image','[\"jobs\\/img3.png\"]',18,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(64,'featured_image','[\"jobs\\/img4.png\"]',19,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(65,'featured_image','[\"jobs\\/img2.png\"]',20,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(66,'featured_image','[\"jobs\\/img2.png\"]',21,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(67,'featured_image','[\"jobs\\/img9.png\"]',22,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(68,'featured_image','[\"jobs\\/img1.png\"]',23,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(69,'featured_image','[\"jobs\\/img4.png\"]',24,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(70,'featured_image','[\"jobs\\/img3.png\"]',25,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(71,'featured_image','[\"jobs\\/img6.png\"]',26,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(72,'featured_image','[\"jobs\\/img3.png\"]',27,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(73,'featured_image','[\"jobs\\/img1.png\"]',28,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(74,'featured_image','[\"jobs\\/img6.png\"]',29,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(75,'featured_image','[\"jobs\\/img1.png\"]',30,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(76,'featured_image','[\"jobs\\/img7.png\"]',31,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(77,'featured_image','[\"jobs\\/img6.png\"]',32,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(78,'featured_image','[\"jobs\\/img6.png\"]',33,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(79,'featured_image','[\"jobs\\/img1.png\"]',34,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(80,'featured_image','[\"jobs\\/img1.png\"]',35,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(81,'featured_image','[\"jobs\\/img6.png\"]',36,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:26','2024-05-13 21:55:26'),(82,'featured_image','[\"jobs\\/img5.png\"]',37,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(83,'featured_image','[\"jobs\\/img7.png\"]',38,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(84,'featured_image','[\"jobs\\/img3.png\"]',39,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(85,'featured_image','[\"jobs\\/img6.png\"]',40,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(86,'featured_image','[\"jobs\\/img8.png\"]',41,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(87,'featured_image','[\"jobs\\/img9.png\"]',42,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(88,'featured_image','[\"jobs\\/img6.png\"]',43,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(89,'featured_image','[\"jobs\\/img5.png\"]',44,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(90,'featured_image','[\"jobs\\/img5.png\"]',45,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(91,'featured_image','[\"jobs\\/img7.png\"]',46,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(92,'featured_image','[\"jobs\\/img1.png\"]',47,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(93,'featured_image','[\"jobs\\/img8.png\"]',48,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(94,'featured_image','[\"jobs\\/img6.png\"]',49,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(95,'featured_image','[\"jobs\\/img7.png\"]',50,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(96,'featured_image','[\"jobs\\/img7.png\"]',51,'Botble\\JobBoard\\Models\\Job','2024-05-13 21:55:27','2024-05-13 21:55:27'),(97,'cover_image','[\"covers\\/1.png\"]',1,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:28','2024-05-13 21:55:28'),(98,'cover_image','[\"covers\\/1.png\"]',2,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:28','2024-05-13 21:55:28'),(99,'cover_image','[\"covers\\/2.png\"]',3,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:28','2024-05-13 21:55:28'),(100,'cover_image','[\"covers\\/1.png\"]',4,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:29','2024-05-13 21:55:29'),(101,'cover_image','[\"covers\\/3.png\"]',5,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:29','2024-05-13 21:55:29'),(102,'cover_image','[\"covers\\/3.png\"]',6,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:29','2024-05-13 21:55:29'),(103,'cover_image','[\"covers\\/1.png\"]',7,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:29','2024-05-13 21:55:29'),(104,'cover_image','[\"covers\\/2.png\"]',8,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:30','2024-05-13 21:55:30'),(105,'cover_image','[\"covers\\/3.png\"]',9,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:30','2024-05-13 21:55:30'),(106,'cover_image','[\"covers\\/1.png\"]',10,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:30','2024-05-13 21:55:30'),(107,'cover_image','[\"covers\\/1.png\"]',11,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:30','2024-05-13 21:55:30'),(108,'cover_image','[\"covers\\/2.png\"]',12,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:31','2024-05-13 21:55:31'),(109,'cover_image','[\"covers\\/3.png\"]',13,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:31','2024-05-13 21:55:31'),(110,'cover_image','[\"covers\\/3.png\"]',14,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:31','2024-05-13 21:55:31'),(111,'cover_image','[\"covers\\/2.png\"]',15,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:31','2024-05-13 21:55:31'),(112,'cover_image','[\"covers\\/3.png\"]',16,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:32','2024-05-13 21:55:32'),(113,'cover_image','[\"covers\\/2.png\"]',17,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:32','2024-05-13 21:55:32'),(114,'cover_image','[\"covers\\/2.png\"]',18,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:32','2024-05-13 21:55:32'),(115,'cover_image','[\"covers\\/3.png\"]',19,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:32','2024-05-13 21:55:32'),(116,'cover_image','[\"covers\\/3.png\"]',20,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:33','2024-05-13 21:55:33'),(117,'cover_image','[\"covers\\/2.png\"]',21,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:33','2024-05-13 21:55:33'),(118,'cover_image','[\"covers\\/2.png\"]',22,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:33','2024-05-13 21:55:33'),(119,'cover_image','[\"covers\\/1.png\"]',23,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:33','2024-05-13 21:55:33'),(120,'cover_image','[\"covers\\/3.png\"]',24,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:34','2024-05-13 21:55:34'),(121,'cover_image','[\"covers\\/3.png\"]',25,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:34','2024-05-13 21:55:34'),(122,'cover_image','[\"covers\\/1.png\"]',26,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:34','2024-05-13 21:55:34'),(123,'cover_image','[\"covers\\/1.png\"]',27,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:34','2024-05-13 21:55:34'),(124,'cover_image','[\"covers\\/3.png\"]',28,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:35','2024-05-13 21:55:35'),(125,'cover_image','[\"covers\\/3.png\"]',29,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:35','2024-05-13 21:55:35'),(126,'cover_image','[\"covers\\/1.png\"]',30,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:35','2024-05-13 21:55:35'),(127,'cover_image','[\"covers\\/2.png\"]',31,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:35','2024-05-13 21:55:35'),(128,'cover_image','[\"covers\\/2.png\"]',32,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:36','2024-05-13 21:55:36'),(129,'cover_image','[\"covers\\/1.png\"]',33,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:36','2024-05-13 21:55:36'),(130,'cover_image','[\"covers\\/2.png\"]',34,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:36','2024-05-13 21:55:36'),(131,'cover_image','[\"covers\\/2.png\"]',35,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:36','2024-05-13 21:55:36'),(132,'cover_image','[\"covers\\/1.png\"]',36,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:37','2024-05-13 21:55:37'),(133,'cover_image','[\"covers\\/3.png\"]',37,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:37','2024-05-13 21:55:37'),(134,'cover_image','[\"covers\\/3.png\"]',38,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:37','2024-05-13 21:55:37'),(135,'cover_image','[\"covers\\/1.png\"]',39,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:37','2024-05-13 21:55:37'),(136,'cover_image','[\"covers\\/3.png\"]',40,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:38','2024-05-13 21:55:38'),(137,'cover_image','[\"covers\\/2.png\"]',41,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:38','2024-05-13 21:55:38'),(138,'cover_image','[\"covers\\/2.png\"]',42,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:38','2024-05-13 21:55:38'),(139,'cover_image','[\"covers\\/2.png\"]',43,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:38','2024-05-13 21:55:38'),(140,'cover_image','[\"covers\\/2.png\"]',44,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:39','2024-05-13 21:55:39'),(141,'cover_image','[\"covers\\/2.png\"]',45,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:39','2024-05-13 21:55:39'),(142,'cover_image','[\"covers\\/2.png\"]',46,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:39','2024-05-13 21:55:39'),(143,'cover_image','[\"covers\\/2.png\"]',47,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:39','2024-05-13 21:55:39'),(144,'cover_image','[\"covers\\/1.png\"]',48,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:40','2024-05-13 21:55:40'),(145,'cover_image','[\"covers\\/2.png\"]',49,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:40','2024-05-13 21:55:40'),(146,'cover_image','[\"covers\\/2.png\"]',50,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:40','2024-05-13 21:55:40'),(147,'cover_image','[\"covers\\/3.png\"]',51,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:40','2024-05-13 21:55:40'),(148,'cover_image','[\"covers\\/2.png\"]',52,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:41','2024-05-13 21:55:41'),(149,'cover_image','[\"covers\\/1.png\"]',53,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:41','2024-05-13 21:55:41'),(150,'cover_image','[\"covers\\/3.png\"]',54,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:41','2024-05-13 21:55:41'),(151,'cover_image','[\"covers\\/2.png\"]',55,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:41','2024-05-13 21:55:41'),(152,'cover_image','[\"covers\\/1.png\"]',56,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:42','2024-05-13 21:55:42'),(153,'cover_image','[\"covers\\/2.png\"]',57,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:42','2024-05-13 21:55:42'),(154,'cover_image','[\"covers\\/3.png\"]',58,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:42','2024-05-13 21:55:42'),(155,'cover_image','[\"covers\\/3.png\"]',59,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:42','2024-05-13 21:55:42'),(156,'cover_image','[\"covers\\/3.png\"]',60,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:43','2024-05-13 21:55:43'),(157,'cover_image','[\"covers\\/3.png\"]',61,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:43','2024-05-13 21:55:43'),(158,'cover_image','[\"covers\\/1.png\"]',62,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:43','2024-05-13 21:55:43'),(159,'cover_image','[\"covers\\/1.png\"]',63,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:44','2024-05-13 21:55:44'),(160,'cover_image','[\"covers\\/2.png\"]',64,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:44','2024-05-13 21:55:44'),(161,'cover_image','[\"covers\\/3.png\"]',65,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:44','2024-05-13 21:55:44'),(162,'cover_image','[\"covers\\/2.png\"]',66,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:44','2024-05-13 21:55:44'),(163,'cover_image','[\"covers\\/2.png\"]',67,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:44','2024-05-13 21:55:44'),(164,'cover_image','[\"covers\\/1.png\"]',68,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:45','2024-05-13 21:55:45'),(165,'cover_image','[\"covers\\/1.png\"]',69,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:45','2024-05-13 21:55:45'),(166,'cover_image','[\"covers\\/1.png\"]',70,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:45','2024-05-13 21:55:45'),(167,'cover_image','[\"covers\\/2.png\"]',71,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:45','2024-05-13 21:55:45'),(168,'cover_image','[\"covers\\/2.png\"]',72,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:46','2024-05-13 21:55:46'),(169,'cover_image','[\"covers\\/3.png\"]',73,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:46','2024-05-13 21:55:46'),(170,'cover_image','[\"covers\\/1.png\"]',74,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:46','2024-05-13 21:55:46'),(171,'cover_image','[\"covers\\/2.png\"]',75,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:46','2024-05-13 21:55:46'),(172,'cover_image','[\"covers\\/3.png\"]',76,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:47','2024-05-13 21:55:47'),(173,'cover_image','[\"covers\\/2.png\"]',77,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:47','2024-05-13 21:55:47'),(174,'cover_image','[\"covers\\/3.png\"]',78,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:47','2024-05-13 21:55:47'),(175,'cover_image','[\"covers\\/1.png\"]',79,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:47','2024-05-13 21:55:47'),(176,'cover_image','[\"covers\\/2.png\"]',80,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:48','2024-05-13 21:55:48'),(177,'cover_image','[\"covers\\/1.png\"]',81,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:48','2024-05-13 21:55:48'),(178,'cover_image','[\"covers\\/1.png\"]',82,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:48','2024-05-13 21:55:48'),(179,'cover_image','[\"covers\\/2.png\"]',83,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:48','2024-05-13 21:55:48'),(180,'cover_image','[\"covers\\/3.png\"]',84,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:49','2024-05-13 21:55:49'),(181,'cover_image','[\"covers\\/3.png\"]',85,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:49','2024-05-13 21:55:49'),(182,'cover_image','[\"covers\\/1.png\"]',86,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:49','2024-05-13 21:55:49'),(183,'cover_image','[\"covers\\/3.png\"]',87,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:50','2024-05-13 21:55:50'),(184,'cover_image','[\"covers\\/1.png\"]',88,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:50','2024-05-13 21:55:50'),(185,'cover_image','[\"covers\\/3.png\"]',89,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:50','2024-05-13 21:55:50'),(186,'cover_image','[\"covers\\/2.png\"]',90,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:50','2024-05-13 21:55:50'),(187,'cover_image','[\"covers\\/1.png\"]',91,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:51','2024-05-13 21:55:51'),(188,'cover_image','[\"covers\\/1.png\"]',92,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:51','2024-05-13 21:55:51'),(189,'cover_image','[\"covers\\/1.png\"]',93,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:51','2024-05-13 21:55:51'),(190,'cover_image','[\"covers\\/2.png\"]',94,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:51','2024-05-13 21:55:51'),(191,'cover_image','[\"covers\\/2.png\"]',95,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:52','2024-05-13 21:55:52'),(192,'cover_image','[\"covers\\/1.png\"]',96,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:52','2024-05-13 21:55:52'),(193,'cover_image','[\"covers\\/3.png\"]',97,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:52','2024-05-13 21:55:52'),(194,'cover_image','[\"covers\\/1.png\"]',98,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:52','2024-05-13 21:55:52'),(195,'cover_image','[\"covers\\/1.png\"]',99,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:53','2024-05-13 21:55:53'),(196,'cover_image','[\"covers\\/3.png\"]',100,'Botble\\JobBoard\\Models\\Account','2024-05-13 21:55:53','2024-05-13 21:55:53');

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

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

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

INSERT INTO `migrations` VALUES (1,'2013_04_09_032329_create_base_tables',1),(2,'2013_04_09_062329_create_revisions_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_reset_tokens_table',1),(5,'2016_06_10_230148_create_acl_tables',1),(6,'2016_06_14_230857_create_menus_table',1),(7,'2016_06_28_221418_create_pages_table',1),(8,'2016_10_05_074239_create_setting_table',1),(9,'2016_11_28_032840_create_dashboard_widget_tables',1),(10,'2016_12_16_084601_create_widgets_table',1),(11,'2017_05_09_070343_create_media_tables',1),(12,'2017_11_03_070450_create_slug_table',1),(13,'2019_01_05_053554_create_jobs_table',1),(14,'2019_08_19_000000_create_failed_jobs_table',1),(15,'2019_12_14_000001_create_personal_access_tokens_table',1),(16,'2022_04_20_100851_add_index_to_media_table',1),(17,'2022_04_20_101046_add_index_to_menu_table',1),(18,'2022_07_10_034813_move_lang_folder_to_root',1),(19,'2022_08_04_051940_add_missing_column_expires_at',1),(20,'2022_09_01_000001_create_admin_notifications_tables',1),(21,'2022_10_14_024629_drop_column_is_featured',1),(22,'2022_11_18_063357_add_missing_timestamp_in_table_settings',1),(23,'2022_12_02_093615_update_slug_index_columns',1),(24,'2023_01_30_024431_add_alt_to_media_table',1),(25,'2023_02_16_042611_drop_table_password_resets',1),(26,'2023_04_10_103353_fix_social_links',1),(27,'2023_04_23_005903_add_column_permissions_to_admin_notifications',1),(28,'2023_05_10_075124_drop_column_id_in_role_users_table',1),(29,'2023_07_19_152743_migrate_old_city_state_image',1),(30,'2023_08_21_090810_make_page_content_nullable',1),(31,'2023_09_14_021936_update_index_for_slugs_table',1),(32,'2023_12_06_100448_change_random_hash_for_media',1),(33,'2023_12_07_095130_add_color_column_to_media_folders_table',1),(34,'2023_12_17_162208_make_sure_column_color_in_media_folders_nullable',1),(35,'2023_12_20_034718_update_invoice_amount',1),(36,'2024_04_04_110758_update_value_column_in_user_meta_table',1),(37,'2024_05_12_091229_add_column_visibility_to_table_media_files',1),(38,'2024_04_27_100730_improve_analytics_setting',2),(39,'2015_06_29_025744_create_audit_history',3),(40,'2023_11_14_033417_change_request_column_in_table_audit_histories',3),(41,'2015_06_18_033822_create_blog_table',4),(42,'2021_02_16_092633_remove_default_value_for_author_type',4),(43,'2021_12_03_030600_create_blog_translations',4),(44,'2022_04_19_113923_add_index_to_table_posts',4),(45,'2023_08_29_074620_make_column_author_id_nullable',4),(46,'2016_06_17_091537_create_contacts_table',5),(47,'2023_11_10_080225_migrate_contact_blacklist_email_domains_to_core',5),(48,'2024_03_20_080001_migrate_change_attribute_email_to_nullable_form_contacts_table',5),(49,'2024_03_25_000001_update_captcha_settings_for_contact',5),(50,'2024_04_19_063914_create_custom_fields_table',5),(51,'2018_07_09_221238_create_faq_table',6),(52,'2021_12_03_082134_create_faq_translations',6),(53,'2023_11_17_063408_add_description_column_to_faq_categories_table',6),(54,'2016_10_13_150201_create_galleries_table',7),(55,'2021_12_03_082953_create_gallery_translations',7),(56,'2022_04_30_034048_create_gallery_meta_translations_table',7),(57,'2023_08_29_075308_make_column_user_id_nullable',7),(58,'2022_06_20_093259_create_job_board_tables',8),(59,'2022_09_12_061845_update_table_activity_logs',8),(60,'2022_09_13_042407_create_table_jb_jobs_types',8),(61,'2022_09_15_030017_update_jb_jobs_table',8),(62,'2022_09_15_094840_add_job_employer_colleagues',8),(63,'2022_09_27_000001_create_jb_invoices_tables',8),(64,'2022_09_30_144924_update_jobs_table',8),(65,'2022_10_04_085631_add_company_logo_to_jb_invoices',8),(66,'2022_10_10_030606_create_reviews_table',8),(67,'2022_11_09_065056_add_missing_jobs_page',8),(68,'2022_11_10_065056_add_columns_to_accounts',8),(69,'2022_11_16_034756_add_column_cover_letter_to_accounts',8),(70,'2022_11_29_304756_create_jb_account_favorite_skills_table',8),(71,'2022_11_29_304757_create_jb_account_favorite_tags',8),(72,'2022_12_26_304758_create_table_jb_experiences',8),(73,'2022_12_26_304759_create_table_jb_education',8),(74,'2023_01_31_023233_create_jb_custom_fields_table',8),(75,'2023_02_06_024257_add_package_translations',8),(76,'2023_02_08_062457_add_custom_fields_translation_table',8),(77,'2023_04_03_126927_add_parent_id_to_jb_categories_table',8),(78,'2023_05_04_000001_add_hide_cv_to_jb_accounts_table',8),(79,'2023_05_09_062031_unique_reviews_table',8),(80,'2023_05_13_180010_make_jb_reviews_table_morphable',8),(81,'2023_05_16_113126_fix_account_confirmed_at',8),(82,'2023_07_03_135746_add_zip_code_to_jb_jobs_table',8),(83,'2023_07_06_022808_create_jb_coupons_table',8),(84,'2023_07_14_045213_add_coupon_code_column_to_jb_invoices_table',8),(85,'2024_01_31_022842_add_description_to_jb_packages_table',8),(86,'2024_02_01_080657_add_tax_id_column_to_jb_companies_table',8),(87,'2024_05_02_030658_add_field_unique_id_to_jb_accounts_and_jb_companies_table',8),(88,'2016_10_03_032336_create_languages_table',9),(89,'2023_09_14_022423_add_index_for_language_table',9),(90,'2021_10_25_021023_fix-priority-load-for-language-advanced',10),(91,'2021_12_03_075608_create_page_translations',10),(92,'2023_07_06_011444_create_slug_translations_table',10),(93,'2019_11_18_061011_create_country_table',11),(94,'2021_12_03_084118_create_location_translations',11),(95,'2021_12_03_094518_migrate_old_location_data',11),(96,'2021_12_10_034440_switch_plugin_location_to_use_language_advanced',11),(97,'2022_01_16_085908_improve_plugin_location',11),(98,'2022_08_04_052122_delete_location_backup_tables',11),(99,'2023_04_23_061847_increase_state_translations_abbreviation_column',11),(100,'2023_07_26_041451_add_more_columns_to_location_table',11),(101,'2023_07_27_041451_add_more_columns_to_location_translation_table',11),(102,'2023_08_15_073307_drop_unique_in_states_cities_translations',11),(103,'2023_10_21_065016_make_state_id_in_table_cities_nullable',11),(104,'2017_10_24_154832_create_newsletter_table',12),(105,'2024_03_25_000001_update_captcha_settings_for_newsletter',12),(106,'2017_05_18_080441_create_payment_tables',13),(107,'2021_03_27_144913_add_customer_type_into_table_payments',13),(108,'2021_05_24_034720_make_column_currency_nullable',13),(109,'2021_08_09_161302_add_metadata_column_to_payments_table',13),(110,'2021_10_19_020859_update_metadata_field',13),(111,'2022_06_28_151901_activate_paypal_stripe_plugin',13),(112,'2022_07_07_153354_update_charge_id_in_table_payments',13),(113,'2022_11_02_092723_team_create_team_table',14),(114,'2023_08_11_094574_update_team_table',14),(115,'2023_11_30_085354_add_missing_description_to_team',14),(116,'2018_07_09_214610_create_testimonial_table',15),(117,'2021_12_03_083642_create_testimonials_translations',15),(118,'2016_10_07_193005_create_translations_table',16),(119,'2023_12_12_105220_drop_translations_table',16);

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscribed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pages_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Homepage 1','<div>[search-box title=\"The Easiest Way to Get Your New Job\" highlight_text=\"Easiest Way\" description=\"Each month, more than 3 million job seekers turn to website in their search for work, making over 140,000 applications every single day\" banner_image_1=\"pages/banner1.png\" icon_top_banner=\"pages/icon-top-banner.png\" banner_image_2=\"pages/banner2.png\" icon_bottom_banner=\"pages/icon-bottom-banner.png\" style=\"style-1\" trending_keywords=\"Design,Development,Manager,Senior\"][/search-box]</div><div>[featured-job-categories title=\"Browse by category\" subtitle=\"Find the job that’s perfect for you. about 800+ new jobs everyday\"][/featured-job-categories]</div><div>[apply-banner subtitle=\"Let’s Work Together &lt;br\\&gt;&amp; Explore Opportunities\" highlight_sub_title_text=\"Work, Explore\" title_1=\"We are\" title_2=\"HIRING\" button_apply_text=\"Apply\" button_apply_link=\"#\" apply_image_left=\"pages/bg-left-hiring.png\" apply_image_right=\"pages/bg-right-hiring.png\"][/apply-banner]</div><div>[job-of-the-day title=\"Jobs of the day\" subtitle=\"Search and connect with the right candidates faster.\" job_categories=\"4,9,1,3,5,7\" style=\"style-1\"][/job-of-the-day]</div><div>[job-grid title=\"Find The One That’s Right For You\" high_light_title_text=\"Right\" subtitle=\"Millions Of Jobs.\" description=\"Search all the open positions on the web. Get your own personalized salary estimate. Read reviews on over 600,000 companies worldwide. The right job is out there.\" image_job_1=\"pages/img-chart.png\" image_job_2=\"pages/controlcard.png\" image=\"pages/img1.png\" button_text=\"Search jobs\" button_url=\"#\" link_text=\"Learn more\" link_text_url=\"#\"][/job-grid]</div><div>[top-companies title=\"Top Recruiters\" description=\"Discover your next career move, freelance gig, or internship\"][/top-companies]</div><div>[job-by-location title=\"Jobs by Location\" description=\"Find your favourite jobs and get the benefits of yourself\" city=\"1,2,3,4,5,6\"][/job-by-location]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\"][/news-and-blogs]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(2,'Homepage 2','<div>[search-box subtitle=\"We have 150,000+ live jobs\" title=\"The #1 Job Board for Hiring or Find your next job\" highlight_text=\"Job Board for\" description=\"Each month, more than 3 million job seekers turn to website in their search for work, making over 140,000 applications every single day\" counter_title_1=\"Daily Jobs Posted\" counter_number_1=\"265\" counter_title_2=\"Recruiters\" counter_number_2=\"17\" counter_title_3=\"Freelancers\" counter_number_3=\"15\" counter_title_4=\"Blog Tips\" counter_number_4=\"28\" background_image=\"pages/banner-section-search-box.png\" style=\"style-2\" trending_keywords=\"Design,Development,Manager,Senior\"][/search-box]</div><div>[job-of-the-day title=\"Jobs of the day\" subtitle=\"Search and connect with the right candidates faster.\" job_categories=\"1,2,5,4,7,8\" style=\"style-2\"][/job-of-the-day]</div><div>[popular-category title=\"Popular category\" subtitle=\"Search and connect with the right candidates faster.\"][/popular-category]</div><div>[job-by-location title=\"Jobs by Location\" description=\"Find your favourite jobs and get the benefits of yourself\" city=\"12,46,69,111,121,116,62\" style=\"style-2\"][/job-by-location]</div><div>[counter-section counter_title_1=\"Completed Cases\" counter_description_1=\"We always provide people a complete solution upon focused of any business\" counter_number_1=\"1000\" counter_title_2=\"Our Office\" counter_description_2=\"We always provide people a complete solution upon focused of any business\" counter_number_2=\"1\" counter_title_3=\"Skilled People\" counter_description_3=\"We always provide people a complete solution upon focused of any business\" counter_number_3=\"6\" counter_title_4=\"Happy Clients\" counter_description_4=\"We always provide people a complete solution upon focused of any business\" counter_number_4=\"2\"][/counter-section]</div><div>[top-companies title=\"Top Recruiters\" description=\"Discover your next career move, freelance gig, or internship\" style=\"style-2\"][/top-companies]</div><div>[advertisement-banner first_title=\"Job Tools Services\" first_description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam laoreet rutrum quam, id faucibus erat interdum a. Curabitur eget tortor a nulla interdum semper.\" load_more_first_content_text=\"Find Out More\" load_more_link_first_content=\"#\" image_of_first_content=\"pages/job-tools.png\" second_title=\"Planning a Job?\" second_description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam laoreet rutrum quam, id faucibus erat interdum a. Curabitur eget tortor a nulla interdum semper.\" load_more_second_content_text=\"Find Out More\" load_more_link_second_content=\"#\" image_of_second_content=\"pages/planning-job.png\"][/advertisement-banner]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"Load More Posts\" button_link=\"#\" style=\"style-2\"][/news-and-blogs]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(3,'Homepage 3','<div>[search-box title=\"The #1 Job Board for Hiring or Find your next job\" highlight_text=\"Job Board for\" description=\"Each month, more than 3 million job seekers turn to website in their search for work, making over 140,000 applications every single day\" style=\"style-3\" trending_keywords=\"Design,Development,Manager,Senior\"][/search-box]</div><div>[job-of-the-day title=\"Jobs of the day\" subtitle=\"Search and connect with the right candidates faster.\" job_categories=\"1,2,5,4,7,8\" style=\"style-3\"][/job-of-the-day]</div><div>[top-candidates title=\"Top Candidates\" description=\"Jobs is a curated job board of the best jobs for developers, designers and marketers in the tech industry.\" limit=\"8\" style=\"style-3\"][/top-candidates]</div><div>[top-companies title=\"Top Recruiters\" description=\"Discover your next career move, freelance gig, or internship\" style=\"style-3\"][/top-companies]</div><div>[apply-banner subtitle=\"Let’s Work Together &lt;br\\&gt;&amp; Explore Opportunities\" highlight_sub_title_text=\"Work, Explore\" title_1=\"We are\" title_2=\"HIRING\" button_apply_text=\"Apply\" button_apply_link=\"#\" apply_image_left=\"pages/bg-left-hiring.png\" apply_image_right=\"pages/bg-right-hiring.png\" style=\"style-3\"][/apply-banner]</div><div>[our-partners title=\"Trusted by\" name_1=\"Asus\" url_1=\"https://www.asus.com\" image_1=\"our-partners/asus.png\" name_2=\"Dell\" url_2=\"https://www.dell.com\" image_2=\"our-partners/dell.png\" name_3=\"Microsoft\" url_3=\"https://www.microsoft.com\" image_3=\"our-partners/microsoft.png\" name_4=\"Acer\" url_4=\"https://www.acer.com\" image_4=\"our-partners/acer.png\" name_5=\"Nokia\" url_5=\"https://www.nokia.com\" image_5=\"our-partners/nokia.png\"][/our-partners]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"Load More Posts\" button_link=\"#\" style=\"style-3\"][/news-and-blogs]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(4,'Homepage 4','<div>[search-box title=\"Get The Right Job You Deserve\" highlight_text=\"Right Job\" banner_image_1=\"pages/home-page-4-banner.png\" style=\"style-1\" trending_keywords=\"Designer, Web, IOS, Developer, PHP, Senior, Engineer\" background_color=\"#000\"][/search-box]</div><div>[job-of-the-day title=\"Latest Jobs Post\" subtitle=\"Explore the different types of available jobs to apply discover which is right for you.\" job_categories=\"1,2,3,4,5,6,8,7\" style=\"style-3\"][/job-of-the-day]</div><div>[featured-job-categories title=\"Browse by category\" subtitle=\"Find the job that’s perfect for you. about 800+ new jobs everyday\" limit_category=\"10\" background_image=\"pages/bg-cat.png\" style=\"style-2\"][/featured-job-categories]</div><div>[[testimonials title=\"See Some Words\" description=\"Thousands of employee get their ideal jobs and feed back to us!\" style=\"style-2\"][/testimonials]</div><div>[our-partners title=\"Trusted by\" name_1=\"Asus\" url_1=\"https://www.asus.com\" image_1=\"our-partners/asus.png\" name_2=\"Dell\" url_2=\"https://www.dell.com\" image_2=\"our-partners/dell.png\" name_3=\"Microsoft\" url_3=\"https://www.microsoft.com\" image_3=\"our-partners/microsoft.png\" name_4=\"Acer\" url_4=\"https://www.acer.com\" image_4=\"our-partners/acer.png\" name_5=\"Nokia\" url_5=\"https://www.nokia.com\" image_5=\"our-partners/nokia.png\"][/our-partners]</div><div>[popular-category title=\"Popular category\" subtitle=\"Search and connect with the right candidates faster.\"][/popular-category]</div><div>[job-by-location title=\"Jobs by Location\" description=\"Find your favourite jobs and get the benefits of yourself\" city=\"12,46,69,111,121,116,62\" style=\"style-2\"][/job-by-location]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"Load More Posts\" button_link=\"#\"][/news-and-blogs]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(5,'Homepage 5','<div>[search-box title=\"Find Jobs, &#x3C;br&#x3E; Hire Creatives\" description=\"Each month, more than 3 million job seekers turn to website in their search for work, making over 140,000 applications every single day\" banner_image_1=\"pages/banner1.png\" banner_image_2=\"pages/banner2.png\" banner_image_3=\"pages/banner3.png\" banner_image_4=\"pages/banner4.png\" banner_image_5=\"pages/banner5.png\" banner_image_6=\"pages/banner6.png\" style=\"style-5\"][/search-box]</div><div>[counter-section counter_title_1=\"Completed Cases\" counter_description_1=\"We always provide people a complete solution upon focused of any business\" counter_number_1=\"1000\" counter_title_2=\"Our Office\" counter_description_2=\"We always provide people a complete solution upon focused of any business\" counter_number_2=\"1\" counter_title_3=\"Skilled People\" counter_description_3=\"We always provide people a complete solution upon focused of any business\" counter_number_3=\"6\" counter_title_4=\"Happy Clients\" counter_description_4=\"We always provide people a complete solution upon focused of any business\" counter_number_4=\"2\"][/counter-section]</div><div>[popular-category title=\"Explore the Marketplace\" subtitle=\"Search and connect with the right candidates faster. Tell us what you’ve looking for and we’ll get to work for you.\" style=\"style-5\"][/popular-category]</div><div>[job-of-the-day title=\"Latest Jobs Post\" subtitle=\"Explore the different types of available jobs to apply &#x3C;br&#x3E; discover which is right for you.\" job_categories=\"1,2,5,4,7,8\" style=\"style-2\"][/job-of-the-day]</div><div>[job-grid style=\"style-2\" title=\"Create Your Personal Account Profile\" subtitle=\"Create Profile\" description=\"Work Profile is a personality assessment that measures an individual\'s work personality through their workplace traits, social and emotional traits; as well as the values and aspirations that drive them forward.\" image=\"pages/img-profile.png\" button_text=\"Create Profile\" button_url=\"/register\"][/job-grid]</div><div>[how-it-works title=\"How It Works\" description=\"Just via some simple steps, you will find your ideal candidates you’r looking for!\" step_label_1=\"Register an &#x3C;br&#x3E; account to start\" step_help_1=\"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do\" step_label_2=\"Explore over &#x3C;br&#x3E; thousands of resumes\" step_help_2=\"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do\" step_label_3=\"Find the most &#x3C;br&#x3E; suitable candidate\" step_help_3=\"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do\" button_label=\"Get Started\" button_url=\"#\"][/how-it-works]</div><div>[top-candidates title=\"Top Candidates\" description=\"Jobs is a curated job board of the best jobs for developers, designers &#x3C;br&#x3E; and marketers in the tech industry.\" limit=\"8\" style=\"style-5\"][/top-candidates]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"Load More Posts\" button_link=\"#\" style=\"style-2\"][/news-and-blogs]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(6,'Homepage 6','<div>[search-box title=\"There Are 102,256 Postings Here For you!\" highlight_text=\"102,256\" description=\"Find Jobs, Employment & Career Opportunities\" style=\"style-4\" trending_keywords=\"Design,Development,Manager,Senior,,\" background_color=\"#000\"][/search-box]</div><div>[gallery image_1=\"galleries/1.jpg\" image_2=\"galleries/2.jpg\" image_3=\"galleries/3.jpg\" image_4=\"galleries/4.jpg\" image_5=\"galleries/5.jpg\"][/gallery]</div><div>[featured-job-categories title=\"Browse by category\" subtitle=\"Find the job that’s perfect for you. about 800+ new jobs everyday\"][/featured-job-categories]</div><div>[job-grid style=\"style-2\" title=\"Create Your Personal Account Profile\" subtitle=\"Create Profile\" description=\"Work Profile is a personality assessment that measures an individual\'s work personality through their workplace traits, social and emotional traits; as well as the values and aspirations that drive them forward.\" image=\"pages/img-profile.png\" button_text=\"Create Profile\" button_url=\"/register\"][/job-grid]</div><div>[job-of-the-day title=\"Latest Jobs Post\" subtitle=\"Explore the different types of available jobs to apply discover which is right for you.\" job_categories=\"1,2,3,4,5,6\" style=\"style-2\"][/job-of-the-day]</div><div>[job-search-banner title=\"Job search for people passionate about startup\" background_image=\"pages/img-job-search.png\" checkbox_title_1=\"Create an account\" checkbox_description_1=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec justo a quam varius maximus. Maecenas sodales tortor quis tincidunt commodo.\" checkbox_title_2=\"Search for Jobs\" checkbox_description_2=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec justo a quam varius maximus. Maecenas sodales tortor quis tincidunt commodo.\" checkbox_title_3=\"Save & Apply\" checkbox_description_3=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec justo a quam varius maximus. Maecenas sodales tortor quis tincidunt commodo.\"][/job-search-banner]</div>',1,NULL,'homepage',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(7,'Jobs','<div>[search-box title=\"The official IT Jobs site\" highlight_text=\"IT Jobs\" description=\"“JobBox is our first stop whenever we\'re hiring a PHP role. We\'ve hired 10 PHP developers in the last few years, all thanks to JobBox.” — Andrew Hall, Elite JSC.\" banner_image_1=\"pages/left-job-head.png\" banner_image_2=\"pages/right-job-head.png\" style=\"style-3\" background_color=\"#000\"][/search-box]</div><div>[job-list max_salary_range=\"10000\"][/job-list]</div>',1,NULL,'default',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(8,'Companies','<div>[job-companies title=\"Browse Companies\" subtitle=\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Vero repellendus magni, atque delectus molestias quis?\"][/job-companies]</div>',1,NULL,'default',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(9,'Candidates','<div>[job-candidates title=\"Browse Candidates\" description=\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Vero repellendus magni, atque &#x3C;br&#x3E; delectus molestias quis?\" number_per_page=\"9\" style=\"grid\"][/job-candidates]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" style=\"style-2\"][/news-and-blogs]</div>',1,NULL,'default',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(10,'About us','<div>[company-about title=\"About Our Company\" description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque ligula ante, dictum non aliquet eu, dapibus ac quam. Morbi vel ante viverra orci tincidunt tempor eu id ipsum. Sed consectetur, risus a blandit tempor, velit magna pellentesque risus, at congue tellus dui quis nisl.\" title_box=\"What we can do?\" image=\"general/img-about2.png\" description_box=\"Aenean sollicituin, lorem quis bibendum auctor nisi elit consequat ipsum sagittis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus a sit amet maurisorbi accumsan ipsum velit. Nam nec tellus a odio tincidunt auctora ornare odio. Aenean sollicituin, lorem quis bibendum auctor nisi elit consequat ipsum sagittis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus a sit amet maurisorbi accumsan ipsum velit. Nam nec tellus a odio tincidunt auctora ornare odio. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Duis non nisi purus. Integer sit nostra, per inceptos himenaeos. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Duis non nisi purus. Integer sit nostra, per inceptos himenaeos.\" url=\"/\" text_button_box=\"Read more\"][/company-about]</div><div>[team title=\"About Our Company\" sub_title=\"OUR COMPANY\" description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque ligula ante, dictum non aliquet eu, dapibus ac quam. Morbi vel ante viverra orci tincidunt tempor eu id ipsum. Sed consectetur, risus a blandit tempor, velit magna pellentesque risus, at congue tellus dui quis nisl.\" number_of_people=\"8\"][/team]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"View More\" button_link=\"/blog\" style=\"style-2\"][/news-and-blogs]</div><div>[testimonials title=\"Our Happy Customer\" description=\"When it comes to choosing the right web hosting provider, we know how easy it is to get overwhelmed with the number.\"][/testimonials]</div>',1,NULL,'page-detail','Get the latest news, updates and tips','published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(11,'Pricing Plan','<div>[pricing-table title=\"Pricing Table\" subtitle=\"Choose The Best Plan That’s For You\" number_of_package=\"3\"][/pricing-table]</div><div>[faq title=\"Frequently Asked Questions\" subtitle=\"Aliquam a augue suscipit, luctus neque purus ipsum neque dolor primis a libero tempus, blandit and cursus varius and magnis sapien\" number_of_faq=\"4\"][/faq]</div><div>[testimonials title=\"Our Happy Customer\" subtitle=\"When it comes to choosing the right web hosting provider, we know how easy it is to get overwhelmed with the number.\"][/testimonials]</div>',1,NULL,'default',NULL,'published','2024-05-13 21:55:19','2024-05-13 21:55:19'),(12,'Contact','<div>[company-information company_name=\"Jobbox Company\" logo_company=\"general/logo-company.png\" company_address=\"205 North Michigan Avenue, Suite 810 Chicago, 60601, US\" company_phone=\"0543213336\" company_email=\"contact@jobbox.com\" branch_company_name_0=\"London\" branch_company_address_0=\"2118 Thornridge Cir. Syracuse, Connecticut 35624\" branch_company_name_1=\"New York\" branch_company_address_1=\"4517 Washington Ave. Manchester, Kentucky 39495\" branch_company_name_2=\"Chicago\" branch_company_address_2=\"3891 Ranchview Dr. Richardson, California 62639\" branch_company_name_3=\"San Francisco\" branch_company_address_3=\"4140 Parker Rd. Allentown, New Mexico 31134\" branch_company_name_4=\"Sysney\" branch_company_address_4=\"3891 Ranchview Dr. Richardson, California 62639\" branch_company_name_5=\"Singapore\" branch_company_address_5=\"4140 Parker Rd. Allentown, New Mexico 31134\"][/company-information]</div><div>[contact-form title=\"Contact us\" subtitle=\"Get in touch\" description=\"The right move at the right time saves your investment. live the dream of expanding your business.\" image=\"image-contact.png\" show_newsletter=\"yes\"][/contact-form]</div><div>[team title=\"Meet Our Team\" subtitle=\"OUR COMPANY\" description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque ligula ante, dictum non aliquet eu, dapibus ac quam. Morbi vel ante viverra orci tincidunt tempor eu id ipsum. Sed consectetur, risus a blandit tempor, velit magna pellentesque risus, at congue tellus dui quis nisl.\" number_of_people=\"8\"][/team]</div><div>[news-and-blogs title=\"News and Blog\" subtitle=\"Get the latest news, updates and tips\" button_text=\"View More\" button_link=\"/blog\" style=\"style-2\"][/news-and-blogs]</div><div>[testimonials title=\"Our Happy Customer\" subtitle=\"When it comes to choosing the right web hosting provider, we know how easy it is to get overwhelmed with the number.\"][/testimonials]</div>',1,NULL,'page-detail','Get the latest news, updates and tips','published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(13,'Blog','---',1,NULL,'page-detail','Get the latest news, updates and tips','published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(14,'Cookie Policy','<h3>EU Cookie Consent</h3><p>To use this website we are using Cookies and collecting some Data. To be compliant with the EU GDPR we give you to choose if you allow us to use certain Cookies and to collect some Data.</p><h4>Essential Data</h4><ul><li>The Essential Data is needed to run the Site you are visiting technically. You can not deactivate them.</li><li>Session Cookie: PHP uses a Cookie to identify user sessions. Without this Cookie the Website is not working.</li><li>XSRF-Token Cookie: Laravel automatically generates a CSRF \"token\" for each active user session managed by the application. This token is used to verify that the authenticated user is the one actually making the requests to the application.</li></ul>',1,NULL,'page-detail-boxed',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(15,'FAQs','<div>[faq title=\"Frequently Asked Questions\" number_of_faq=\"4\"][/faq]</div>',1,NULL,'page-detail',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(16,'Services','<p>Alice. \'Come on, then!\' roared the Queen, the royal children; there were TWO little shrieks, and more sounds of broken glass, from which she concluded that it would like the three were all shaped like ears and whiskers, how late it\'s getting!\' She was a bright brass plate with the glass table and the moon, and memory, and muchness--you know you say it.\' \'That\'s nothing to what I should think it would be very likely true.) Down, down, down. Would the fall NEVER come to the jury. They were.</p><p>Father William replied to his son, \'I feared it might belong to one of the jurymen. \'No, they\'re not,\' said the Duchess, it had fallen into a line along the passage into the court, \'Bring me the list of the Shark, But, when the tide rises and sharks are around, His voice has a timid voice at her rather inquisitively, and seemed to Alice severely. \'What are they made of?\' \'Pepper, mostly,\' said the Cat; and this time the Queen merely remarking that a red-hot poker will burn you if you don\'t.</p><p>Seven flung down his face, as long as there was a dead silence. Alice was very like a Jack-in-the-box, and up I goes like a stalk out of that is, but I think you\'d take a fancy to cats if you like,\' said the Gryphon went on growing, and, as the large birds complained that they could not think of what sort it was) scratching and scrambling about in all my life!\' Just as she leant against a buttercup to rest herself, and shouted out, \'You\'d better not do that again!\' which produced another dead.</p><p>At last the Mock Turtle drew a long breath, and till the puppy\'s bark sounded quite faint in the house till she was up to the porpoise, \"Keep back, please: we don\'t want to be?\' it asked. \'Oh, I\'m not Ada,\' she said, by way of escape, and wondering whether she could not swim. He sent them word I had not long to doubt, for the hedgehogs; and in a great hurry; \'and their names were Elsie, Lacie, and Tillie; and they all crowded together at one corner of it: \'No room! No room!\' they cried out.</p>',1,NULL,'page-detail-boxed',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(17,'Terms','<p>SOME change in my kitchen AT ALL. Soup does very well without--Maybe it\'s always pepper that makes people hot-tempered,\' she went on \'And how did you ever see such a wretched height to rest her chin upon Alice\'s shoulder, and it was too slippery; and when she next peeped out the answer to shillings and pence. \'Take off your hat,\' the King said, for about the reason they\'re called lessons,\' the Gryphon as if a fish came to the King, \'or I\'ll have you executed on the breeze that followed them.</p><p>Alice had learnt several things of this elegant thimble\'; and, when it grunted again, so violently, that she ran out of sight, they were all talking at once, with a little ledge of rock, and, as the Dormouse fell asleep instantly, and neither of the tale was something like this:-- \'Fury said to the door. \'Call the next verse,\' the Gryphon said, in a great letter, nearly as she could, for her neck would bend about easily in any direction, like a wild beast, screamed \'Off with his nose Trims his.</p><p>King repeated angrily, \'or I\'ll have you executed on the shingle--will you come and join the dance. \'\"What matters it how far we go?\" his scaly friend replied. \"There is another shore, you know, this sort in her hand, and Alice was just in time to avoid shrinking away altogether. \'That WAS a curious appearance in the chimney as she could, and waited to see if she had read several nice little histories about children who had got burnt, and eaten up by two guinea-pigs, who were lying on the.</p><p>You MUST have meant some mischief, or else you\'d have signed your name like an arrow. The Cat\'s head began fading away the time. Alice had begun to think to herself, \'I wonder what Latitude or Longitude I\'ve got to the jury, and the executioner went off like an honest man.\' There was a table, with a teacup in one hand and a pair of gloves and the Dormouse said--\' the Hatter said, tossing his head contemptuously. \'I dare say you\'re wondering why I don\'t like the largest telescope that ever was!.</p>',1,NULL,'page-detail-boxed',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(18,'Job Categories','<div>[search-box title=\"22 Jobs Available Now\" highlight_text=\"22 Jobs\" description=\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Vero repellendus magni, atque delectus molestias quis?\" banner_image_1=\"pages/left-job-head.png\" banner_image_2=\"pages/right-job-head.png\" style=\"style-3\" background_color=\"#000\"][/search-box]</div><div>[popular-category title=\"Popular category\" limit_category=\"8\" style=\"style-1\"][/popular-category]</div><div>[job-categories title=\"Categories\" subtitle=\"All categories\" limit_category=\"8\"][/job-categories]</div>',1,NULL,'default',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20');

--
-- Table structure for table `pages_translations`
--

CREATE TABLE `pages_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pages_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`pages_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages_translations`
--


--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `charge_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `order_id` bigint unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'confirm',
  `customer_id` bigint unsigned DEFAULT NULL,
  `refunded_amount` decimal(15,2) unsigned DEFAULT NULL,
  `refund_note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


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

CREATE TABLE `post_categories` (
  `category_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_categories_category_id_index` (`category_id`),
  KEY `post_categories_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `post_categories` VALUES (1,1),(7,1),(2,2),(6,2),(2,3),(6,3);

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `tag_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_tags_tag_id_index` (`tag_id`),
  KEY `post_tags_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(1,2),(2,2),(3,2),(4,2),(5,2),(1,3),(2,3),(3,3),(4,3),(5,3);

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

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int unsigned NOT NULL DEFAULT '0',
  `format_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_status_index` (`status`),
  KEY `posts_author_id_index` (`author_id`),
  KEY `posts_author_type_index` (`author_type`),
  KEY `posts_created_at_index` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `posts` VALUES (1,'Interview Question: Why Dont You Have a Degree?','Sit maiores aut iure hic repudiandae minima eligendi. Eaque et omnis quod quas autem. Ea quia modi assumenda molestias dolor quas. Eligendi animi sed recusandae et.','<p>[youtube-video]https://www.youtube.com/watch?v=SlPhMPnQ58k[/youtube-video]</p><p>Alice looked up, and began singing in its sleep \'Twinkle, twinkle, twinkle, twinkle--\' and went on eagerly: \'There is such a puzzled expression that she remained the same solemn tone, \'For the Duchess. \'I make you dry enough!\' They all returned from him to you, Though they were lying round the court was a very decided tone: \'tell her something worth hearing. For some minutes the whole place around her became alive with the Queen had ordered. They very soon finished off the subjects on his spectacles and looked along the course, here and there she saw them, they were gardeners, or soldiers, or courtiers, or three pairs of tiny white kid gloves, and she crossed her hands on her spectacles, and began smoking again. This time there were ten of them, with her arms folded, frowning like a telescope.\' And so she went on, \'you see, a dog growls when it\'s angry, and wags its tail when it\'s pleased. Now I growl when I\'m pleased, and wag my tail when it\'s pleased. Now I growl when I\'m pleased.</p><p class=\"text-center\"><img src=\"/storage/news/1.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>But her sister on the floor, and a large pool all round her head. \'If I eat or drink something or other; but the Hatter hurriedly left the court, arm-in-arm with the next witness.\' And he got up in a low voice. \'Not at all,\' said the youth, \'one would hardly suppose That your eye was as steady as ever; Yet you turned a corner, \'Oh my ears and the roof of the cattle in the last few minutes, and began an account of the moment how large she had peeped into the roof of the same solemn tone, only.</p><p class=\"text-center\"><img src=\"/storage/news/9.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>I\'m angry. Therefore I\'m mad.\' \'I call it sad?\' And she thought it would be a Caucus-race.\' \'What IS a Caucus-race?\' said Alice; \'it\'s laid for a good deal worse off than before, as the doubled-up soldiers were always getting up and repeat something now. Tell her to wink with one foot. \'Get up!\' said the King said to Alice, \'Have you guessed the riddle yet?\' the Hatter grumbled: \'you shouldn\'t have put it more clearly,\' Alice replied thoughtfully. \'They have their tails in their paws. \'And how do you like the look of it at all. \'But perhaps it was only a pack of cards, after all. \"--SAID I COULD NOT SWIM--\" you can\'t help that,\' said the Cat, and vanished again. Alice waited till the puppy\'s bark sounded quite faint in the air, and came flying down upon their faces, and the March Hare had just upset the milk-jug into his cup of tea, and looked at each other for some time busily writing in his throat,\' said the King. \'When did you manage to do next, when suddenly a footman because he.</p><p class=\"text-center\"><img src=\"/storage/news/13.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>The Mouse gave a little scream, half of them--and it belongs to the part about her pet: \'Dinah\'s our cat. And she\'s such a dear little puppy it was!\' said Alice, looking down with her head!\' Alice glanced rather anxiously at the White Rabbit put on his knee, and the words have got in as well,\' the Hatter said, turning to Alice: he had never had fits, my dear, and that you had been looking over their slates; \'but it doesn\'t matter which way she put it. She stretched herself up closer to Alice\'s great surprise, the Duchess\'s voice died away, even in the air, I\'m afraid, sir\' said Alice, as she was out of its mouth and yawned once or twice, and shook itself. Then it got down off the subjects on his flappers, \'--Mystery, ancient and modern, with Seaography: then Drawling--the Drawling-master was an uncomfortably sharp chin. However, she soon found an opportunity of adding, \'You\'re looking for eggs, as it turned a corner, \'Oh my ears and the Queen, the royal children; there were ten of.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/img-news1.png',600,NULL,'2024-04-16 05:29:23','2024-04-16 05:29:23'),(2,'21 Job Interview Tips: How To Make a Great Impression','Distinctio eos eos et et et sunt. Non animi consequuntur porro magnam aut distinctio unde. Sit est est alias qui. Fuga et molestias ex et aut quam quia.','<p>I wonder what they WILL do next! As for pulling me out of a well?\' \'Take some more bread-and-butter--\' \'But what happens when you throw them, and all of you, and listen to me! When I used to say.\' \'So he did, so he with his head!\' she said, \'and see whether it\'s marked \"poison\" or not\'; for she was quite pleased to have any rules in particular; at least, if there were three gardeners instantly jumped up, and reduced the answer to shillings and pence. \'Take off your hat,\' the King said to Alice. \'Nothing,\' said Alice. \'I\'ve read that in the window?\' \'Sure, it\'s an arm for all that.\' \'With extras?\' asked the Gryphon, and all would change to dull reality--the grass would be so stingy about it, you know--\' \'What did they live at the March Hare, \'that \"I breathe when I find a thing,\' said the Dormouse; \'VERY ill.\' Alice tried to say \'I once tasted--\' but checked herself hastily. \'I don\'t know what a wonderful dream it had come back in a mournful tone, \'he won\'t do a thing before, but she.</p><p class=\"text-center\"><img src=\"/storage/news/5.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>March.\' As she said this last word two or three times over to herself, \'after such a rule at processions; \'and besides, what would happen next. First, she dreamed of little pebbles came rattling in at the time he was speaking, so that by the English, who wanted leaders, and had to do it.\' (And, as you are; secondly, because they\'re making such VERY short remarks, and she said this, she was walking by the fire, and at once took up the conversation dropped, and the March Hare and his buttons.</p><p class=\"text-center\"><img src=\"/storage/news/8.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>Let me see: four times six is thirteen, and four times seven is--oh dear! I wish you could keep it to be talking in a hurried nervous manner, smiling at everything that was trickling down his cheeks, he went on at last, with a lobster as a last resource, she put them into a doze; but, on being pinched by the way, was the only difficulty was, that you couldn\'t cut off a bit hurt, and she very soon finished it off. \'If everybody minded their own business,\' the Duchess to play croquet.\' Then they all crowded round her head. \'If I eat one of these cakes,\' she thought, \'and hand round the court and got behind him, and very soon had to double themselves up and picking the daisies, when suddenly a footman because he taught us,\' said the Duchess; \'and that\'s the queerest thing about it.\' (The jury all brightened up at the Hatter, \'you wouldn\'t talk about her pet: \'Dinah\'s our cat. And she\'s such a thing I ever saw in my size; and as he shook both his shoes on. \'--and just take his head off.</p><p class=\"text-center\"><img src=\"/storage/news/13.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>Who ever saw in my kitchen AT ALL. Soup does very well as I used--and I don\'t take this young lady to see what I say--that\'s the same thing as \"I get what I say--that\'s the same thing as \"I sleep when I breathe\"!\' \'It IS the same size: to be no doubt that it would be worth the trouble of getting up and throw us, with the distant sobs of the moment how large she had to ask any more HERE.\' \'But then,\' thought Alice, as she could. \'No,\' said the Caterpillar, just as she couldn\'t answer either question, it didn\'t much matter which way you go,\' said the Dodo, pointing to the Mock Turtle said: \'I\'m too stiff. And the moral of that is--\"Birds of a procession,\' thought she, \'what would become of me?\' Luckily for Alice, the little thing howled so, that Alice quite hungry to look at them--\'I wish they\'d get the trial done,\' she thought, \'it\'s sure to kill it in a tone of great relief. \'Now at OURS they had been to a mouse, That he met in the act of crawling away: besides all this, there was a.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/img-news2.png',2428,NULL,'2024-04-23 04:22:05','2024-04-23 04:22:05'),(3,'39 Strengths and Weaknesses To Discuss in a Job Interview','Repellat non dignissimos libero consectetur. Eum voluptas quia saepe vero occaecati ducimus necessitatibus quis.','<p>Between yourself and me.\' \'That\'s the judge,\' she said to herself how this same little sister of hers that you never even introduced to a day-school, too,\' said Alice; \'I must be really offended. \'We won\'t talk about cats or dogs either, if you please! \"William the Conqueror, whose cause was favoured by the officers of the Gryphon, \'you first form into a tree. \'Did you say it.\' \'That\'s nothing to do: once or twice, half hoping she might as well as she was coming to, but it puzzled her very much at first, perhaps,\' said the Cat, as soon as she remembered how small she was appealed to by the hand, it hurried off, without waiting for the accident of the e--e--evening, Beautiful, beauti--FUL SOUP!\' \'Chorus again!\' cried the Mock Turtle. \'No, no! The adventures first,\' said the Gryphon. \'Turn a somersault in the prisoner\'s handwriting?\' asked another of the house!\' (Which was very provoking to find herself talking familiarly with them, as if he wasn\'t going to happen next. \'It\'s--it\'s a.</p><p class=\"text-center\"><img src=\"/storage/news/1.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>Only I don\'t remember where.\' \'Well, it must be getting somewhere near the right words,\' said poor Alice, who always took a minute or two, which gave the Pigeon went on, without attending to her, \'if we had the best way to fly up into a large one, but it is.\' \'Then you should say what you like,\' said the Gryphon at the number of bathing machines in the world you fly, Like a tea-tray in the sea!\' cried the Gryphon. \'The reason is,\' said the Queen, stamping on the second time round, she came.</p><p class=\"text-center\"><img src=\"/storage/news/7.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>Alice gave a little door about fifteen inches high: she tried her best to climb up one of the doors of the evening, beautiful Soup! Soup of the party were placed along the passage into the way out of sight. Alice remained looking thoughtfully at the March Hare will be much the same tone, exactly as if he were trying to touch her. \'Poor little thing!\' said the Duchess, it had no reason to be an old Crab took the hookah into its nest. Alice crouched down among the party. Some of the players to be managed? I suppose it doesn\'t mind.\' The table was a dispute going on between the executioner, the King, \'that saves a world of trouble, you know, this sort of use in saying anything more till the Pigeon had finished. \'As if it likes.\' \'I\'d rather not,\' the Cat said, waving its right ear and left off staring at the number of changes she had never had fits, my dear, and that if something wasn\'t done about it just now.\' \'It\'s the thing yourself, some winter day, I will tell you what year it is?\'.</p><p class=\"text-center\"><img src=\"/storage/news/13.jpg\" style=\"width: 100%\" class=\"image_resized\" alt=\"image\"></p><p>After a minute or two the Caterpillar angrily, rearing itself upright as it was a little shaking among the people near the door, and tried to beat time when I got up very carefully, nibbling first at one and then at the mushroom for a minute or two, and the words came very queer indeed:-- \'\'Tis the voice of the way--\' \'THAT generally takes some time,\' interrupted the Gryphon. \'Of course,\' the Mock Turtle had just begun to repeat it, when a sharp hiss made her so savage when they passed too close, and waving their forepaws to mark the time, while the rest waited in silence. Alice was only a mouse that had fluttered down from the shock of being all alone here!\' As she said this, she came upon a time she had found her head pressing against the ceiling, and had to double themselves up and to her full size by this time.) \'You\'re nothing but a pack of cards!\' At this the White Rabbit, \'but it doesn\'t matter a bit,\' said the Mock Turtle in the distance. \'Come on!\' and ran the faster, while.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/img-news3.png',1903,NULL,'2024-05-03 17:29:17','2024-05-03 17:29:17');

--
-- Table structure for table `posts_translations`
--

CREATE TABLE `posts_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `posts_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`posts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts_translations`
--


--
-- Table structure for table `revisions`
--

CREATE TABLE `revisions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `revisionable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisionable_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_value` text COLLATE utf8mb4_unicode_ci,
  `new_value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `revisions_revisionable_id_revisionable_type_index` (`revisionable_id`,`revisionable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revisions`
--


--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_users_user_id_index` (`user_id`),
  KEY `role_users_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--


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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`),
  KEY `roles_created_by_index` (`created_by`),
  KEY `roles_updated_by_index` (`updated_by`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'admin','Admin','{\"users.index\":true,\"users.create\":true,\"users.edit\":true,\"users.destroy\":true,\"roles.index\":true,\"roles.create\":true,\"roles.edit\":true,\"roles.destroy\":true,\"core.system\":true,\"core.cms\":true,\"core.manage.license\":true,\"systems.cronjob\":true,\"core.tools\":true,\"tools.data-synchronize\":true,\"media.index\":true,\"files.index\":true,\"files.create\":true,\"files.edit\":true,\"files.trash\":true,\"files.destroy\":true,\"folders.index\":true,\"folders.create\":true,\"folders.edit\":true,\"folders.trash\":true,\"folders.destroy\":true,\"settings.index\":true,\"settings.common\":true,\"settings.options\":true,\"settings.email\":true,\"settings.media\":true,\"settings.admin-appearance\":true,\"settings.cache\":true,\"settings.datatables\":true,\"settings.email.rules\":true,\"settings.others\":true,\"menus.index\":true,\"menus.create\":true,\"menus.edit\":true,\"menus.destroy\":true,\"optimize.settings\":true,\"pages.index\":true,\"pages.create\":true,\"pages.edit\":true,\"pages.destroy\":true,\"plugins.index\":true,\"plugins.edit\":true,\"plugins.remove\":true,\"plugins.marketplace\":true,\"core.appearance\":true,\"theme.index\":true,\"theme.activate\":true,\"theme.remove\":true,\"theme.options\":true,\"theme.custom-css\":true,\"theme.custom-js\":true,\"theme.custom-html\":true,\"theme.robots-txt\":true,\"settings.website-tracking\":true,\"widgets.index\":true,\"analytics.general\":true,\"analytics.page\":true,\"analytics.browser\":true,\"analytics.referrer\":true,\"analytics.settings\":true,\"audit-log.index\":true,\"audit-log.destroy\":true,\"backups.index\":true,\"backups.create\":true,\"backups.restore\":true,\"backups.destroy\":true,\"plugins.blog\":true,\"posts.index\":true,\"posts.create\":true,\"posts.edit\":true,\"posts.destroy\":true,\"categories.index\":true,\"categories.create\":true,\"categories.edit\":true,\"categories.destroy\":true,\"tags.index\":true,\"tags.create\":true,\"tags.edit\":true,\"tags.destroy\":true,\"blog.settings\":true,\"posts.export\":true,\"posts.import\":true,\"captcha.settings\":true,\"contacts.index\":true,\"contacts.edit\":true,\"contacts.destroy\":true,\"contact.settings\":true,\"plugin.faq\":true,\"faq.index\":true,\"faq.create\":true,\"faq.edit\":true,\"faq.destroy\":true,\"faq_category.index\":true,\"faq_category.create\":true,\"faq_category.edit\":true,\"faq_category.destroy\":true,\"faqs.settings\":true,\"galleries.index\":true,\"galleries.create\":true,\"galleries.edit\":true,\"galleries.destroy\":true,\"plugins.job-board\":true,\"jobs.index\":true,\"jobs.create\":true,\"jobs.edit\":true,\"jobs.destroy\":true,\"import-jobs.index\":true,\"export-jobs.index\":true,\"job-applications.index\":true,\"job-applications.edit\":true,\"job-applications.destroy\":true,\"accounts.index\":true,\"accounts.create\":true,\"accounts.edit\":true,\"accounts.destroy\":true,\"accounts.import\":true,\"accounts.export\":true,\"packages.index\":true,\"packages.create\":true,\"packages.edit\":true,\"packages.destroy\":true,\"companies.index\":true,\"companies.create\":true,\"companies.edit\":true,\"companies.destroy\":true,\"export-companies.index\":true,\"import-companies.index\":true,\"job-board.custom-fields.index\":true,\"job-board.custom-fields.create\":true,\"job-board.custom-fields.edit\":true,\"job-board.custom-fields.destroy\":true,\"job-attributes.index\":true,\"job-categories.index\":true,\"job-categories.create\":true,\"job-categories.edit\":true,\"job-categories.destroy\":true,\"job-types.index\":true,\"job-types.create\":true,\"job-types.edit\":true,\"job-types.destroy\":true,\"job-skills.index\":true,\"job-skills.create\":true,\"job-skills.edit\":true,\"job-skills.destroy\":true,\"job-shifts.index\":true,\"job-shifts.create\":true,\"job-shifts.edit\":true,\"job-shifts.destroy\":true,\"job-experiences.index\":true,\"job-experiences.create\":true,\"job-experiences.edit\":true,\"job-experiences.destroy\":true,\"language-levels.index\":true,\"language-levels.create\":true,\"language-levels.edit\":true,\"language-levels.destroy\":true,\"career-levels.index\":true,\"career-levels.create\":true,\"career-levels.edit\":true,\"career-levels.destroy\":true,\"functional-areas.index\":true,\"functional-areas.create\":true,\"functional-areas.edit\":true,\"functional-areas.destroy\":true,\"degree-types.index\":true,\"degree-types.create\":true,\"degree-types.edit\":true,\"degree-types.destroy\":true,\"degree-levels.index\":true,\"degree-levels.create\":true,\"degree-levels.edit\":true,\"degree-levels.destroy\":true,\"job-board.tag.index\":true,\"job-board.tag.create\":true,\"job-board.tag.edit\":true,\"job-board.tag.destroy\":true,\"job-board.settings\":true,\"invoice.index\":true,\"invoice.edit\":true,\"invoice.destroy\":true,\"reviews.index\":true,\"reviews.destroy\":true,\"invoice-template.index\":true,\"languages.index\":true,\"languages.create\":true,\"languages.edit\":true,\"languages.destroy\":true,\"plugin.location\":true,\"country.index\":true,\"country.create\":true,\"country.edit\":true,\"country.destroy\":true,\"state.index\":true,\"state.create\":true,\"state.edit\":true,\"state.destroy\":true,\"city.index\":true,\"city.create\":true,\"city.edit\":true,\"city.destroy\":true,\"newsletter.index\":true,\"newsletter.destroy\":true,\"newsletter.settings\":true,\"payment.index\":true,\"payments.settings\":true,\"payment.destroy\":true,\"social-login.settings\":true,\"team.index\":true,\"team.create\":true,\"team.edit\":true,\"team.destroy\":true,\"testimonial.index\":true,\"testimonial.create\":true,\"testimonial.edit\":true,\"testimonial.destroy\":true,\"plugins.translation\":true,\"translations.locales\":true,\"translations.theme-translations\":true,\"translations.index\":true}','Admin users role',1,1,1,'2024-05-13 21:55:17','2024-05-13 21:55:17');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (2,'api_enabled','0',NULL,'2024-05-13 21:55:17'),(3,'activated_plugins','[\"language\",\"language-advanced\",\"analytics\",\"audit-log\",\"backup\",\"blog\",\"captcha\",\"contact\",\"cookie-consent\",\"faq\",\"gallery\",\"job-board\",\"location\",\"newsletter\",\"payment\",\"paypal\",\"paystack\",\"razorpay\",\"rss-feed\",\"social-login\",\"sslcommerz\",\"stripe\",\"team\",\"testimonial\",\"translation\"]',NULL,'2024-05-13 21:55:17'),(6,'language_hide_default','1',NULL,NULL),(7,'language_switcher_display','dropdown',NULL,NULL),(8,'language_display','all',NULL,NULL),(9,'language_hide_languages','[]',NULL,NULL),(10,'show_admin_bar','1',NULL,NULL),(11,'theme','jobbox',NULL,NULL),(12,'admin_logo','general/logo-light.png',NULL,NULL),(13,'admin_favicon','general/favicon.png',NULL,NULL),(14,'theme-jobbox-site_title','JobBox - Laravel Job Board Script',NULL,NULL),(15,'theme-jobbox-seo_description','JobBox is a neat, clean and professional job board website script for your organization. It’s easy to build a complete Job Board site with JobBox script.',NULL,NULL),(16,'theme-jobbox-copyright','©2024 Archi Elite JSC. All right reserved.',NULL,NULL),(17,'theme-jobbox-favicon','general/favicon.png',NULL,NULL),(18,'theme-jobbox-logo','general/logo.png',NULL,NULL),(19,'theme-jobbox-hotline','+(123) 345-6789',NULL,NULL),(20,'theme-jobbox-cookie_consent_message','Your experience on this site will be improved by allowing cookies ',NULL,NULL),(21,'theme-jobbox-cookie_consent_learn_more_url','/cookie-policy',NULL,NULL),(22,'theme-jobbox-cookie_consent_learn_more_text','Cookie Policy',NULL,NULL),(23,'theme-jobbox-homepage_id','1',NULL,NULL),(24,'theme-jobbox-blog_page_id','13',NULL,NULL),(25,'theme-jobbox-preloader_enabled','no',NULL,NULL),(26,'theme-jobbox-job_categories_page_id','18',NULL,NULL),(27,'theme-jobbox-job_candidates_page_id','9',NULL,NULL),(28,'theme-jobbox-default_company_cover_image','general/cover-image.png',NULL,NULL),(29,'theme-jobbox-job_companies_page_id','8',NULL,NULL),(30,'theme-jobbox-job_list_page_id','7',NULL,NULL),(31,'theme-jobbox-email','contact@jobbox.com',NULL,NULL),(32,'theme-jobbox-404_page_image','general/404.png',NULL,NULL),(33,'theme-jobbox-background_breadcrumb','pages/bg-breadcrumb.png',NULL,NULL),(34,'theme-jobbox-blog_page_template_blog','blog_gird_1',NULL,NULL),(35,'theme-jobbox-background_blog_single','pages/img-single.png',NULL,NULL),(36,'theme-jobbox-auth_background_image_1','authentication/img-1.png',NULL,NULL),(37,'theme-jobbox-auth_background_image_2','authentication/img-2.png',NULL,NULL),(38,'theme-jobbox-background_cover_candidate_default','pages/background-cover-candidate.png',NULL,NULL),(39,'theme-jobbox-job_board_max_salary_filter','10000',NULL,NULL),(40,'theme-jobbox-social_links','[[{\"key\":\"social-name\",\"value\":\"Facebook\"},{\"key\":\"social-icon\",\"value\":\"socials\\/facebook.png\"},{\"key\":\"social-url\",\"value\":\"https:\\/\\/facebook.com\"}],[{\"key\":\"social-name\",\"value\":\"Linkedin\"},{\"key\":\"social-icon\",\"value\":\"socials\\/linkedin.png\"},{\"key\":\"social-url\",\"value\":\"https:\\/\\/linkedin.com\"}],[{\"key\":\"social-name\",\"value\":\"Twitter\"},{\"key\":\"social-icon\",\"value\":\"socials\\/twitter.png\"},{\"key\":\"social-url\",\"value\":\"https:\\/\\/twitter.com\"}]]',NULL,NULL),(41,'media_random_hash','75294205790846cd580e175c2cfd5e47',NULL,NULL),(42,'permalink-botble-blog-models-post','blog',NULL,NULL),(43,'permalink-botble-blog-models-category','blog',NULL,NULL),(44,'payment_cod_status','1',NULL,NULL),(45,'payment_cod_description','Please pay money directly to the postman, if you choose cash on delivery method (COD).',NULL,NULL),(46,'payment_bank_transfer_status','1',NULL,NULL),(47,'payment_bank_transfer_description','Please send money to our bank account: ACB - 69270 213 19.',NULL,NULL),(48,'payment_stripe_payment_type','stripe_checkout',NULL,NULL);

--
-- Table structure for table `slugs`
--

CREATE TABLE `slugs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slugs_reference_id_index` (`reference_id`),
  KEY `slugs_key_index` (`key`),
  KEY `slugs_prefix_index` (`prefix`),
  KEY `slugs_reference_index` (`reference_id`,`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slugs`
--

INSERT INTO `slugs` VALUES (1,'homepage-1',1,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(2,'homepage-2',2,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(3,'homepage-3',3,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(4,'homepage-4',4,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(5,'homepage-5',5,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(6,'homepage-6',6,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(7,'jobs',7,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(8,'companies',8,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(9,'candidates',9,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(10,'about-us',10,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:19','2024-05-13 21:55:19'),(11,'pricing-plan',11,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(12,'contact',12,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(13,'blog',13,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(14,'cookie-policy',14,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(15,'faqs',15,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(16,'services',16,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(17,'terms',17,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(18,'job-categories',18,'Botble\\Page\\Models\\Page','','2024-05-13 21:55:20','2024-05-13 21:55:20'),(19,'design',1,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(20,'lifestyle',2,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(21,'travel-tips',3,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(22,'healthy',4,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(23,'travel-tips',5,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(24,'hotel',6,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(25,'nature',7,'Botble\\Blog\\Models\\Category','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(26,'new',1,'Botble\\Blog\\Models\\Tag','tag','2024-05-13 21:55:20','2024-05-13 21:55:20'),(27,'event',2,'Botble\\Blog\\Models\\Tag','tag','2024-05-13 21:55:20','2024-05-13 21:55:20'),(28,'interview-question-why-dont-you-have-a-degree',1,'Botble\\Blog\\Models\\Post','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(29,'21-job-interview-tips-how-to-make-a-great-impression',2,'Botble\\Blog\\Models\\Post','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(30,'39-strengths-and-weaknesses-to-discuss-in-a-job-interview',3,'Botble\\Blog\\Models\\Post','blog','2024-05-13 21:55:20','2024-05-13 21:55:23'),(31,'perfect',1,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(32,'new-day',2,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(33,'happy-day',3,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(34,'nature',4,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(35,'morning',5,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(36,'photography',6,'Botble\\Gallery\\Models\\Gallery','galleries','2024-05-13 21:55:21','2024-05-13 21:55:21'),(37,'content-writer',1,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(38,'market-research',2,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(39,'marketing-sale',3,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(40,'customer-help',4,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(41,'finance',5,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(42,'software',6,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(43,'human-resource',7,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:24','2024-05-13 21:55:24'),(44,'management',8,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:25','2024-05-13 21:55:25'),(45,'retail-products',9,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:25','2024-05-13 21:55:25'),(46,'security-analyst',10,'Botble\\JobBoard\\Models\\Category','job-categories','2024-05-13 21:55:25','2024-05-13 21:55:25'),(47,'linkedin',1,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(48,'adobe-illustrator',2,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(49,'bing-search',3,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(50,'dailymotion',4,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(51,'linkedin',5,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(52,'quora-jsc',6,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(53,'nintendo',7,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(54,'periscope',8,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(55,'newsum',9,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(56,'powerhome',10,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(57,'whopcom',11,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(58,'greenwood',12,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(59,'kentucky',13,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(60,'equity',14,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(61,'honda',15,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(62,'toyota',16,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(63,'lexus',17,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(64,'ondo',18,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(65,'square',19,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(66,'visa',20,'Botble\\JobBoard\\Models\\Company','companies','2024-05-13 21:55:25','2024-05-13 21:55:25'),(67,'illustrator',1,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(68,'adobe-xd',2,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(69,'figma',3,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(70,'sketch',4,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(71,'lunacy',5,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(72,'php',6,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(73,'python',7,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(74,'javascript',8,'Botble\\JobBoard\\Models\\Tag','job-tags','2024-05-13 21:55:26','2024-05-13 21:55:26'),(75,'ui-ux-designer-full-time',1,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(76,'full-stack-engineer',2,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(77,'java-software-engineer',3,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(78,'digital-marketing-manager',4,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(79,'frontend-developer',5,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(80,'react-native-web-developer',6,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(81,'senior-system-engineer',7,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(82,'products-manager',8,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(83,'lead-quality-control-qa',9,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(84,'principal-designer-design-systems',10,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(85,'devops-architect',11,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(86,'senior-software-engineer-npm-cli',12,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(87,'senior-systems-engineer',13,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(88,'software-engineer-actions-platform',14,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(89,'staff-engineering-manager-actions',15,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(90,'staff-engineering-manager-actions-runtime',16,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(91,'staff-engineering-manager-packages',17,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(92,'staff-software-engineer',18,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(93,'systems-software-engineer',19,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(94,'senior-compensation-analyst',20,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(95,'senior-accessibility-program-manager',21,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(96,'analyst-relations-manager-application-security',22,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(97,'senior-enterprise-advocate-emea',23,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(98,'deal-desk-manager',24,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(99,'director-revenue-compensation',25,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(100,'program-manager',26,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(101,'sr-manager-deal-desk-intl',27,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(102,'senior-director-product-management-actions-runners-and-compute-services',28,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(103,'alliances-director',29,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(104,'corporate-sales-representative',30,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(105,'country-leader',31,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(106,'customer-success-architect',32,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(107,'devops-account-executive-us-public-sector',33,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(108,'enterprise-account-executive',34,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(109,'senior-engineering-manager-product-security-engineering-paved-paths',35,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(110,'customer-reliability-engineer-iii',36,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:26','2024-05-13 21:55:26'),(111,'support-engineer-enterprise-support-japanese',37,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(112,'technical-partner-manager',38,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(113,'sr-manager-inside-account-management',39,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(114,'services-sales-representative',40,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(115,'services-delivery-manager',41,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(116,'senior-solutions-engineer',42,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(117,'senior-service-delivery-engineer',43,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(118,'senior-director-global-sales-development',44,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(119,'partner-program-manager',45,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(120,'principal-cloud-solutions-engineer',46,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(121,'senior-cloud-solutions-engineer',47,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(122,'senior-customer-success-manager',48,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(123,'inside-account-manager',49,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(124,'ux-jobs-board',50,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(125,'senior-laravel-developer-tall-stack',51,'Botble\\JobBoard\\Models\\Job','jobs','2024-05-13 21:55:27','2024-05-13 21:55:27'),(126,'mazie',1,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:28','2024-05-13 21:55:28'),(127,'jade',2,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:28','2024-05-13 21:55:28'),(128,'sarah',3,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:28','2024-05-13 21:55:28'),(129,'steven',4,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:29','2024-05-13 21:55:29'),(130,'william',5,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:29','2024-05-13 21:55:29'),(131,'malcolm',6,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:29','2024-05-13 21:55:29'),(132,'shad',7,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:29','2024-05-13 21:55:29'),(133,'hassan',8,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:30','2024-05-13 21:55:30'),(134,'torrance',9,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:30','2024-05-13 21:55:30'),(135,'gay',10,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:30','2024-05-13 21:55:30'),(136,'anibal',11,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:30','2024-05-13 21:55:30'),(137,'alta',12,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:31','2024-05-13 21:55:31'),(138,'everette',13,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:31','2024-05-13 21:55:31'),(139,'stephan',14,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:31','2024-05-13 21:55:31'),(140,'soledad',15,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:31','2024-05-13 21:55:31'),(141,'beulah',16,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:32','2024-05-13 21:55:32'),(142,'adriel',17,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:32','2024-05-13 21:55:32'),(143,'laurence',18,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:32','2024-05-13 21:55:32'),(144,'sid',19,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:32','2024-05-13 21:55:32'),(145,'winifred',20,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:33','2024-05-13 21:55:33'),(146,'sister',21,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:33','2024-05-13 21:55:33'),(147,'colin',22,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:33','2024-05-13 21:55:33'),(148,'chance',23,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:33','2024-05-13 21:55:33'),(149,'meda',24,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:34','2024-05-13 21:55:34'),(150,'ada',25,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:34','2024-05-13 21:55:34'),(151,'alberto',26,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:34','2024-05-13 21:55:34'),(152,'maiya',27,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:34','2024-05-13 21:55:34'),(153,'roel',28,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:35','2024-05-13 21:55:35'),(154,'lola',29,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:35','2024-05-13 21:55:35'),(155,'meghan',30,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:35','2024-05-13 21:55:35'),(156,'emma',31,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:35','2024-05-13 21:55:35'),(157,'mariela',32,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:36','2024-05-13 21:55:36'),(158,'jonathan',33,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:36','2024-05-13 21:55:36'),(159,'maxine',34,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:36','2024-05-13 21:55:36'),(160,'liza',35,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:36','2024-05-13 21:55:36'),(161,'vinnie',36,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:37','2024-05-13 21:55:37'),(162,'afton',37,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:37','2024-05-13 21:55:37'),(163,'beau',38,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:37','2024-05-13 21:55:37'),(164,'jackson',39,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:37','2024-05-13 21:55:37'),(165,'spencer',40,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:38','2024-05-13 21:55:38'),(166,'joanie',41,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:38','2024-05-13 21:55:38'),(167,'kiera',42,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:38','2024-05-13 21:55:38'),(168,'helen',43,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:38','2024-05-13 21:55:38'),(169,'lillian',44,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:39','2024-05-13 21:55:39'),(170,'daryl',45,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:39','2024-05-13 21:55:39'),(171,'wilford',46,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:39','2024-05-13 21:55:39'),(172,'elvis',47,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:39','2024-05-13 21:55:39'),(173,'kiel',48,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:40','2024-05-13 21:55:40'),(174,'gabriella',49,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:40','2024-05-13 21:55:40'),(175,'kelsi',50,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:40','2024-05-13 21:55:40'),(176,'tamia',51,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:40','2024-05-13 21:55:40'),(177,'crawford',52,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:41','2024-05-13 21:55:41'),(178,'zella',53,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:41','2024-05-13 21:55:41'),(179,'katheryn',54,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:41','2024-05-13 21:55:41'),(180,'marvin',55,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:41','2024-05-13 21:55:41'),(181,'bobbie',56,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:42','2024-05-13 21:55:42'),(182,'karson',57,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:42','2024-05-13 21:55:42'),(183,'annamae',58,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:42','2024-05-13 21:55:42'),(184,'toney',59,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:43','2024-05-13 21:55:43'),(185,'darrion',60,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:43','2024-05-13 21:55:43'),(186,'chesley',61,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:43','2024-05-13 21:55:43'),(187,'virginia',62,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:43','2024-05-13 21:55:43'),(188,'prudence',63,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:44','2024-05-13 21:55:44'),(189,'moses',64,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:44','2024-05-13 21:55:44'),(190,'lou',65,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:44','2024-05-13 21:55:44'),(191,'jaqueline',66,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:44','2024-05-13 21:55:44'),(192,'mac',67,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:44','2024-05-13 21:55:44'),(193,'irwin',68,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:45','2024-05-13 21:55:45'),(194,'baby',69,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:45','2024-05-13 21:55:45'),(195,'noemy',70,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:45','2024-05-13 21:55:45'),(196,'janick',71,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:45','2024-05-13 21:55:45'),(197,'isabelle',72,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:46','2024-05-13 21:55:46'),(198,'nathanael',73,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:46','2024-05-13 21:55:46'),(199,'burley',74,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:46','2024-05-13 21:55:46'),(200,'evie',75,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:46','2024-05-13 21:55:46'),(201,'emmie',76,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:47','2024-05-13 21:55:47'),(202,'corine',77,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:47','2024-05-13 21:55:47'),(203,'hershel',78,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:47','2024-05-13 21:55:47'),(204,'judd',79,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:47','2024-05-13 21:55:47'),(205,'emil',80,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:48','2024-05-13 21:55:48'),(206,'katelin',81,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:48','2024-05-13 21:55:48'),(207,'wallace',82,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:48','2024-05-13 21:55:48'),(208,'sidney',83,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:48','2024-05-13 21:55:48'),(209,'serena',84,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:49','2024-05-13 21:55:49'),(210,'tristian',85,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:49','2024-05-13 21:55:49'),(211,'evert',86,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:49','2024-05-13 21:55:49'),(212,'heber',87,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:50','2024-05-13 21:55:50'),(213,'lois',88,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:50','2024-05-13 21:55:50'),(214,'pamela',89,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:50','2024-05-13 21:55:50'),(215,'avery',90,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:50','2024-05-13 21:55:50'),(216,'nick',91,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:51','2024-05-13 21:55:51'),(217,'gunner',92,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:51','2024-05-13 21:55:51'),(218,'josie',93,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:51','2024-05-13 21:55:51'),(219,'kamryn',94,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:51','2024-05-13 21:55:51'),(220,'roman',95,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:52','2024-05-13 21:55:52'),(221,'tiana',96,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:52','2024-05-13 21:55:52'),(222,'jakayla',97,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:52','2024-05-13 21:55:52'),(223,'beau',98,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:52','2024-05-13 21:55:52'),(224,'roel',99,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:53','2024-05-13 21:55:53'),(225,'obie',100,'Botble\\JobBoard\\Models\\Account','candidates','2024-05-13 21:55:53','2024-05-13 21:55:53'),(226,'interview-question-why-dont-you-have-a-degree',1,'Botble\\Blog\\Models\\Post','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(227,'21-job-interview-tips-how-to-make-a-great-impression',2,'Botble\\Blog\\Models\\Post','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(228,'39-strengths-and-weaknesses-to-discuss-in-a-job-interview',3,'Botble\\Blog\\Models\\Post','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(229,'design',1,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(230,'lifestyle',2,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(231,'travel-tips',3,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(232,'healthy',4,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(233,'travel-tips',5,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(234,'hotel',6,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(235,'nature',7,'Botble\\Blog\\Models\\Category','','2024-05-13 21:55:54','2024-05-13 21:55:54'),(236,'jack-persion',1,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(237,'tyler-men',2,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(238,'mohamed-salah',3,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(239,'xao-shin',4,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(240,'peter-cop',5,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(241,'jacob-jones',6,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(242,'court-henry',7,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54'),(243,'theresa',8,'Botble\\Team\\Models\\Team','teams','2024-05-13 21:55:54','2024-05-13 21:55:54');

--
-- Table structure for table `slugs_translations`
--

CREATE TABLE `slugs_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slugs_id` bigint unsigned NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefix` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`lang_code`,`slugs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slugs_translations`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abbreviation` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `states_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'France','france','FR',1,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23'),(2,'England','england','EN',2,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23'),(3,'New York','new-york','NY',1,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23'),(4,'Holland','holland','HL',4,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23'),(5,'Denmark','denmark','DN',5,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23'),(6,'Germany','germany','GER',1,0,NULL,0,'published','2024-05-13 21:55:23','2024-05-13 21:55:23');

--
-- Table structure for table `states_translations`
--

CREATE TABLE `states_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `states_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abbreviation` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states_translations`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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 `tags`
--

INSERT INTO `tags` VALUES (1,'New',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20'),(2,'Event',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-05-13 21:55:20','2024-05-13 21:55:20');

--
-- Table structure for table `tags_translations`
--

CREATE TABLE `tags_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tags_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`tags_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags_translations`
--


--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `socials` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` VALUES (1,'Jack Persion','teams/1.png','Developer Fullstack','USA','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(2,'Tyler Men','teams/2.png','Business Analyst','Qatar','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(3,'Mohamed Salah','teams/3.png','Developer Fullstack','India','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(4,'Xao Shin','teams/4.png','Developer Fullstack','China','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(5,'Peter Cop','teams/5.png','Designer','Russia','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(6,'Jacob Jones','teams/6.png','Frontend Developer','New York, US','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(7,'Court Henry','teams/7.png','Backend Developer','Portugal','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL),(8,'Theresa','teams/8.png','Backend Developer','Thailand','\"{\\\"facebook\\\":\\\"fb.com\\\",\\\"twitter\\\":\\\"twitter.com\\\",\\\"instagram\\\":\\\"instagram.com\\\"}\"','published','2024-05-13 21:55:53','2024-05-13 21:55:53',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `teams_translations`
--

CREATE TABLE `teams_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `teams_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`teams_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams_translations`
--


--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,'Ellis Kim','The Mock Turtle sang this, very slowly and sadly:-- \'\"Will you walk a little shaking among the bright flower-beds and the words don\'t FIT you,\' said Alice, \'a great girl like you,\' (she might well.','testimonials/1.png','Digital Artist','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(2,'John Smith','But I\'ve got to see what I say,\' the Mock Turtle yet?\' \'No,\' said Alice. \'Of course they were\', said the Hatter, who turned pale and fidgeted. \'Give your evidence,\' said the Cat: \'we\'re all mad.','testimonials/2.png','Product designer','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(3,'Sayen Ahmod','For some minutes the whole court was a general chorus of \'There goes Bill!\' then the other, and growing sometimes taller and sometimes shorter, until she had nothing yet,\' Alice replied in an.','testimonials/3.png','Developer','published','2024-05-13 21:55:53','2024-05-13 21:55:53'),(4,'Tayla Swef','Pool of Tears \'Curiouser and curiouser!\' cried Alice hastily, afraid that it was labelled \'ORANGE MARMALADE\', but to open it; but, as the soldiers had to kneel down on one knee. \'I\'m a poor man.','testimonials/4.png','Graphic designer','published','2024-05-13 21:55:53','2024-05-13 21:55:53');

--
-- Table structure for table `testimonials_translations`
--

CREATE TABLE `testimonials_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `testimonials_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`testimonials_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials_translations`
--


--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_meta`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `first_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_id` bigint unsigned DEFAULT NULL,
  `super_user` tinyint(1) NOT NULL DEFAULT '0',
  `manage_supers` tinyint(1) NOT NULL DEFAULT '0',
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `last_login` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'fay.kari@kilback.net',NULL,'$2y$12$fF4LN2BGJVFsE/b8APyrlOxRoallxYJo5ATcJxybzh8cxsIAA0ZHK',NULL,'2024-05-13 21:55:17','2024-05-13 21:55:17','Gaetano','Hodkiewicz','admin',NULL,1,1,NULL,NULL);

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sidebar_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `data` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (1,'NewsletterWidget','pre_footer_sidebar','jobbox',0,'{\"id\":\"NewsletterWidget\",\"title\":\"New Things Will Always <br> Update Regularly\",\"background_image\":\"general\\/newsletter-background-image.png\",\"image_left\":\"general\\/newsletter-image-left.png\",\"image_right\":\"general\\/newsletter-image-right.png\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(2,'SiteInformationWidget','footer_sidebar','jobbox',1,'{\"introduction\":\"JobBox is the heart of the design community and the best resource to discover and connect with designers and jobs worldwide.\",\"facebook_url\":\"#\",\"twitter_url\":\"#\",\"linkedin_url\":\"#\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(3,'CustomMenuWidget','footer_sidebar','jobbox',2,'{\"id\":\"CustomMenuWidget\",\"name\":\"Resources\",\"menu_id\":\"resources\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(4,'CustomMenuWidget','footer_sidebar','jobbox',3,'{\"id\":\"CustomMenuWidget\",\"name\":\"Community\",\"menu_id\":\"community\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(5,'CustomMenuWidget','footer_sidebar','jobbox',4,'{\"id\":\"CustomMenuWidget\",\"name\":\"Quick links\",\"menu_id\":\"quick-links\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(6,'CustomMenuWidget','footer_sidebar','jobbox',5,'{\"id\":\"CustomMenuWidget\",\"name\":\"More\",\"menu_id\":\"more\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(7,'DownloadWidget','footer_sidebar','jobbox',6,'{\"app_store_url\":\"#\",\"app_store_image\":\"general\\/app-store.png\",\"android_app_url\":\"#\",\"google_play_image\":\"general\\/android.png\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(8,'BlogSearchWidget','primary_sidebar','jobbox',1,'{\"id\":\"BlogSearchWidget\",\"name\":\"Search\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(9,'BlogCategoriesWidget','primary_sidebar','jobbox',2,'{\"id\":\"BlogCategoriesWidget\",\"name\":\"Categories\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(10,'BlogPostsWidget','primary_sidebar','jobbox',3,'{\"id\":\"BlogPostsWidget\",\"type\":\"popular\",\"name\":\"Popular Posts\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(11,'BlogTagsWidget','primary_sidebar','jobbox',4,'{\"id\":\"BlogTagsWidget\",\"name\":\"Popular Tags\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(12,'BlogSearchWidget','blog_sidebar','jobbox',0,'{\"id\":\"BlogSearchWidget\",\"name\":\"Blog Search\",\"description\":\"Search blog posts\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(13,'BlogPostsWidget','blog_sidebar','jobbox',1,'{\"id\":\"BlogPostsWidget\",\"name\":\"Blog posts\",\"description\":\"Blog posts widget.\",\"type\":\"popular\",\"number_display\":5}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(14,'AdsBannerWidget','blog_sidebar','jobbox',2,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(15,'GalleryWidget','blog_sidebar','jobbox',3,'{\"id\":\"GalleryWidget\",\"name\":\"Gallery\",\"title_gallery\":\"Gallery\",\"number_image\":8}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(16,'AdsBannerWidget','candidate_sidebar','jobbox',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2024-05-13 21:55:21','2024-05-13 21:55:21'),(17,'AdsBannerWidget','company_sidebar','jobbox',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2024-05-13 21:55:21','2024-05-13 21:55:21');


