-- MySQL dump 10.13 Distrib 5.7.44, for osx10.19 (x86_64) -- -- Host: 127.0.0.1 Database: zelio -- ------------------------------------------------------ -- Server version 8.0.36 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `activations` -- DROP TABLE IF EXISTS `activations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `code` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `completed` tinyint(1) NOT NULL DEFAULT '0', `completed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activations_user_id_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activations` -- LOCK TABLES `activations` WRITE; /*!40000 ALTER TABLE `activations` DISABLE KEYS */; INSERT INTO `activations` VALUES (1,1,'QfDihFTQ6V5gXdTyHywgXHWB4TYF1JkJ',1,'2024-10-20 21:49:01','2024-10-20 21:49:01','2024-10-20 21:49:01'); /*!40000 ALTER TABLE `activations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `admin_notifications` -- DROP TABLE IF EXISTS `admin_notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin_notifications` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `action_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `permission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin_notifications` -- LOCK TABLES `admin_notifications` WRITE; /*!40000 ALTER TABLE `admin_notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `admin_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_histories` -- DROP TABLE IF EXISTS `audit_histories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `audit_histories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `request` longtext COLLATE utf8mb4_unicode_ci, `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_user` bigint unsigned NOT NULL, `reference_id` bigint unsigned NOT NULL, `reference_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `audit_histories_user_id_index` (`user_id`), KEY `audit_histories_module_index` (`module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_histories` -- LOCK TABLES `audit_histories` WRITE; /*!40000 ALTER TABLE `audit_histories` DISABLE KEYS */; /*!40000 ALTER TABLE `audit_histories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `parent_id` bigint unsigned NOT NULL DEFAULT '0', `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `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', `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int unsigned NOT NULL DEFAULT '0', `is_featured` tinyint NOT NULL DEFAULT '0', `is_default` tinyint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `categories_parent_id_index` (`parent_id`), KEY `categories_status_index` (`status`), KEY `categories_created_at_index` (`created_at`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'Web Development',0,'Suscipit fugiat sint expedita quia pariatur maxime rem. Eum accusantium dolores accusantium laborum blanditiis. Nam cupiditate et blanditiis. Modi tempore quo voluptas fuga libero sed alias.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(2,'Open Source Contributions',0,'Tempora non voluptatum quia modi quia et. Dolorem voluptatum a incidunt qui illo et quod. Quidem et voluptas velit molestiae. Ducimus repellat odio est ut qui.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(3,'Tutorials',0,'Ut eum dignissimos fugiat architecto consequuntur placeat. Fugiat sed sequi omnis rerum dolor sed animi. Iusto autem saepe molestias id.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(4,'Technology Reviews',0,'Nostrum adipisci et labore dolorem tenetur molestias et. Consequatur quia qui modi et ut et debitis temporibus. Nihil aut aut quasi et nemo maiores non.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(5,'Personal Blog',0,'Assumenda soluta sed recusandae qui. Ex odio qui quia quia qui. Cum eum veritatis et ut porro quis.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(6,'Career Journey',0,'Natus nemo rem iusto voluptatem. Et est doloribus sit. Recusandae eos beatae qui occaecati.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(7,'Coding Challenges',0,'Voluptatem ad est ut sit. Sequi tempora officiis quisquam necessitatibus error sint voluptatem assumenda. Est debitis porro natus eaque amet molestiae.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(8,'Design Portfolio',0,'Aut non sunt modi eius recusandae. Ut sequi quis ea aut aperiam. Eum illum voluptas aliquid voluptas et. Qui sunt consequatur quia distinctio.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'),(9,'Collaborations',0,'Corrupti nihil fuga inventore dolor iusto autem aspernatur et. Sunt et cupiditate nesciunt voluptas atque magni temporibus. Illum voluptatem ad quasi quibusdam reprehenderit nihil.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:02','2024-10-20 21:49:02'); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories_translations` -- DROP TABLE IF EXISTS `categories_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categories_translations` ( `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `categories_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`,`categories_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories_translations` -- LOCK TABLES `categories_translations` WRITE; /*!40000 ALTER TABLE `categories_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `categories_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_custom_field_options` -- DROP TABLE IF EXISTS `contact_custom_field_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_custom_field_options` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `custom_field_id` bigint unsigned NOT NULL, `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `order` int NOT NULL DEFAULT '999', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_custom_field_options` -- LOCK TABLES `contact_custom_field_options` WRITE; /*!40000 ALTER TABLE `contact_custom_field_options` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_custom_field_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_custom_field_options_translations` -- DROP TABLE IF EXISTS `contact_custom_field_options_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_custom_field_options_translations` ( `contact_custom_field_options_id` bigint unsigned NOT NULL, `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`lang_code`,`contact_custom_field_options_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_custom_field_options_translations` -- LOCK TABLES `contact_custom_field_options_translations` WRITE; /*!40000 ALTER TABLE `contact_custom_field_options_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_custom_field_options_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_custom_fields` -- DROP TABLE IF EXISTS `contact_custom_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_custom_fields` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `required` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int NOT NULL DEFAULT '999', `status` varchar(191) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_custom_fields` -- LOCK TABLES `contact_custom_fields` WRITE; /*!40000 ALTER TABLE `contact_custom_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_custom_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_custom_fields_translations` -- DROP TABLE IF EXISTS `contact_custom_fields_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_custom_fields_translations` ( `contact_custom_fields_id` bigint unsigned NOT NULL, `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`lang_code`,`contact_custom_fields_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_custom_fields_translations` -- LOCK TABLES `contact_custom_fields_translations` WRITE; /*!40000 ALTER TABLE `contact_custom_fields_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_custom_fields_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_replies` -- DROP TABLE IF EXISTS `contact_replies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_replies` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `contact_id` bigint unsigned NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_replies` -- LOCK TABLES `contact_replies` WRITE; /*!40000 ALTER TABLE `contact_replies` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_replies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `custom_fields` text COLLATE utf8mb4_unicode_ci, `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dashboard_widget_settings` -- DROP TABLE IF EXISTS `dashboard_widget_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dashboard_widget_settings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `settings` text COLLATE utf8mb4_unicode_ci, `user_id` bigint unsigned NOT NULL, `widget_id` bigint unsigned NOT NULL, `order` tinyint unsigned NOT NULL DEFAULT '0', `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `dashboard_widget_settings_user_id_index` (`user_id`), KEY `dashboard_widget_settings_widget_id_index` (`widget_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dashboard_widget_settings` -- LOCK TABLES `dashboard_widget_settings` WRITE; /*!40000 ALTER TABLE `dashboard_widget_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `dashboard_widget_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dashboard_widgets` -- DROP TABLE IF EXISTS `dashboard_widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dashboard_widgets` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dashboard_widgets` -- LOCK TABLES `dashboard_widgets` WRITE; /*!40000 ALTER TABLE `dashboard_widgets` DISABLE KEYS */; /*!40000 ALTER TABLE `dashboard_widgets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faq_categories` -- DROP TABLE IF EXISTS `faq_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faq_categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `order` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faq_categories` -- LOCK TABLES `faq_categories` WRITE; /*!40000 ALTER TABLE `faq_categories` DISABLE KEYS */; INSERT INTO `faq_categories` VALUES (1,'Service Offerings',0,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL),(2,'Cost and Billing',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL),(3,'Follow-Up Support',2,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL); /*!40000 ALTER TABLE `faq_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faq_categories_translations` -- DROP TABLE IF EXISTS `faq_categories_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faq_categories_translations` ( `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `faq_categories_id` bigint unsigned NOT NULL, `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`lang_code`,`faq_categories_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faq_categories_translations` -- LOCK TABLES `faq_categories_translations` WRITE; /*!40000 ALTER TABLE `faq_categories_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `faq_categories_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faqs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `question` text COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` bigint unsigned 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`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; INSERT INTO `faqs` VALUES (1,'What is business consulting?','Business consulting involves providing expert advice to organizations to help them improve their performance and achieve their business objectives.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(2,'How can consulting services benefit my business?','Consulting services can provide insights, strategies, and solutions to address specific challenges, improve efficiency, enhance decision-making, and ultimately contribute to the overall success of your business.',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(3,'What specific services do you provide?','We offer a range of services, including strategic planning, financial advisory, operations optimization, market research, and more. Our goal is to tailor our services to meet the unique needs of each client.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(4,'How do you structure your fees?','Our fees are structured based on the scope and complexity of the project. We offer different pricing models, including hourly rates, project-based fees, and retainer agreements. The specific fee structure will be discussed and agreed upon during the initial consultation.',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(5,'What industries do you specialize in?','We have experience and expertise across various industries, including but not limited to technology, finance, healthcare, and manufacturing. Our consultants work closely with clients to understand industry-specific challenges and provide tailored solutions.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(6,'Can you share any client testimonials or case studies?','Certainly! We have a collection of client testimonials and case studies that highlight the success stories of our consulting engagements. Please visit our \'Client Success Stories\' section for more details.',2,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(7,'How do you collaborate with clients during the consulting process?','We believe in a collaborative approach. Throughout the consulting process, we maintain open communication with our clients, involve key stakeholders, and ensure that the client\'s perspective is integral to the decision-making process.',2,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(8,'How long does a typical consulting engagement last?','The duration of a consulting engagement varies depending on the nature and scope of the project. During the initial consultation, we work with clients to define the timeline and milestones for the project, ensuring alignment with their goals and objectives.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(9,'Who are the key members of your consulting team?','Our consulting team consists of highly qualified and experienced professionals with diverse backgrounds. You can learn more about our team members on the \'Meet the Team\' page of our website.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(10,'How do you handle client information and sensitive data?','We take data privacy and confidentiality seriously. Our firm adheres to strict security protocols to protect client information. We have established measures to ensure the confidentiality and security of sensitive data throughout the consulting process.',2,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(11,'Is there ongoing support after the consulting engagement?','Yes, we provide ongoing support to our clients even after the completion of the consulting engagement. This may include follow-up meetings, additional training, and assistance with the implementation of recommended strategies to ensure sustained success.',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(12,'What is your policy regarding cancellations?','Our cancellation policy is outlined in the consulting agreement. Generally, we require advance notice for cancellations, and any associated fees or refunds will be discussed and agreed upon during the initial engagement negotiations.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(13,'What is your approach to sustainability consulting?','In sustainability consulting, we work with clients to develop environmentally responsible and socially conscious business practices. Our approach involves assessing current operations, identifying areas for improvement, and implementing sustainable strategies to reduce environmental impact and promote corporate social responsibility.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(14,'Do you offer remote consulting services?','Yes, we offer remote consulting services to clients worldwide. Our team is equipped to conduct virtual meetings, collaborate online, and deliver effective consulting services remotely. This allows us to work with clients regardless of geographical location.',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(15,'How can your technology integration services benefit my business?','Our technology integration services focus on streamlining business processes through the effective use of technology. By integrating the right technologies, we help businesses enhance efficiency, improve communication, and stay competitive in today\'s rapidly evolving digital landscape.',1,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(16,'What sets your leadership development programs apart?','Our leadership development programs are designed to empower individuals at all levels of an organization. We go beyond traditional training, focusing on personalized coaching, mentorship, and experiential learning to cultivate effective and inspiring leaders within your company.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(17,'How do you stay updated on industry trends and best practices?','We are committed to staying at the forefront of industry trends and best practices. Our team actively engages in continuous learning, participates in relevant conferences, and maintains a strong network of industry professionals to ensure that our consulting services are informed by the latest insights and innovations.',2,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(18,'What measures do you take to ensure the quality of your consulting services?','We prioritize the quality of our consulting services by implementing rigorous quality assurance processes. This includes regular reviews of our methodologies, ongoing training for our consultants, and soliciting feedback from clients to continuously improve our service delivery.',3,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs_translations` -- DROP TABLE IF EXISTS `faqs_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faqs_translations` ( `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `faqs_id` bigint unsigned NOT NULL, `question` text COLLATE utf8mb4_unicode_ci, `answer` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`lang_code`,`faqs_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs_translations` -- LOCK TABLES `faqs_translations` WRITE; /*!40000 ALTER TABLE `faqs_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `faqs_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fob_comments` -- DROP TABLE IF EXISTS `fob_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fob_comments` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `reply_to` bigint unsigned DEFAULT NULL, `author_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `author_id` bigint unsigned DEFAULT NULL, `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_id` bigint unsigned DEFAULT NULL, `reference_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `fob_comments_author_type_author_id_index` (`author_type`,`author_id`), KEY `fob_comments_reference_type_reference_id_index` (`reference_type`,`reference_id`), KEY `fob_comments_reply_to_index` (`reply_to`), KEY `fob_comments_reference_url_index` (`reference_url`), KEY `fob_comments_status_index` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fob_comments` -- LOCK TABLES `fob_comments` WRITE; /*!40000 ALTER TABLE `fob_comments` DISABLE KEYS */; INSERT INTO `fob_comments` VALUES (1,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',14,'http://zelio.test','Elaina Wolff III','snicolas@shields.net','https://friendsofbotble.com','This is really helpful, thank you!','approved','78.250.19.248','Opera/8.52 (Windows NT 5.2; nl-NL) Presto/2.12.235 Version/11.00','2024-09-22 22:16:57','2024-10-20 21:49:06'),(2,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Aiden Morissette','norberto09@yahoo.com','https://friendsofbotble.com','I found this article to be quite informative.','approved','126.8.244.13','Mozilla/5.0 (Windows NT 5.01) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/90.0.4161.52 Safari/532.0 Edg/90.01077.86','2024-10-02 15:23:19','2024-10-20 21:49:06'),(3,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',12,'http://zelio.test','Elwyn Borer','merl.gorczany@langworth.com','https://friendsofbotble.com','Wow, I never knew about this before!','approved','163.111.251.139','Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_7_0 rv:2.0) Gecko/20180703 Firefox/37.0','2024-10-08 18:35:46','2024-10-20 21:49:06'),(4,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Mr. Buford Ortiz','cartwright.leonard@gottlieb.com','https://friendsofbotble.com','Great job on explaining such a complex topic.','approved','102.100.27.149','Mozilla/5.0 (compatible; MSIE 7.0; Windows NT 5.01; Trident/3.0)','2024-10-04 00:59:26','2024-10-20 21:49:06'),(5,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',3,'http://zelio.test','Prof. Daphne Kuvalis Sr.','willms.randal@hotmail.com','https://friendsofbotble.com','I have a question about the third paragraph.','approved','201.60.31.128','Mozilla/5.0 (compatible; MSIE 8.0; Windows NT 5.01; Trident/4.0)','2024-09-24 02:25:17','2024-10-20 21:49:06'),(6,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Phoebe Howe','jaeden.sipes@muller.com','https://friendsofbotble.com','This article changed my perspective entirely.','approved','35.142.132.186','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_3) AppleWebKit/536.1 (KHTML, like Gecko) Chrome/84.0.4639.86 Safari/536.1 Edg/84.01058.20','2024-10-19 06:48:42','2024-10-20 21:49:06'),(7,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Lottie Schmeler','stremblay@yahoo.com','https://friendsofbotble.com','I appreciate the effort you put into this.','approved','139.11.97.86','Mozilla/5.0 (X11; Linux i686) AppleWebKit/5312 (KHTML, like Gecko) Chrome/37.0.867.0 Mobile Safari/5312','2024-10-17 01:11:13','2024-10-20 21:49:06'),(8,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Prof. Abraham Greenfelder III','jamaal82@ankunding.org','https://friendsofbotble.com','This is exactly what I was looking for, thank you!','approved','79.165.231.234','Opera/9.89 (Windows 98; Win 9x 4.90; en-US) Presto/2.12.207 Version/12.00','2024-10-17 05:36:03','2024-10-20 21:49:06'),(9,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',11,'http://zelio.test','Dr. Rory Beahan MD','gennaro.schowalter@reilly.info','https://friendsofbotble.com','I disagree with some points mentioned here, though.','approved','212.207.41.212','Mozilla/5.0 (iPhone; CPU iPhone OS 14_0 like Mac OS X) AppleWebKit/531.0 (KHTML, like Gecko) Version/15.0 EdgiOS/79.01115.21 Mobile/15E148 Safari/531.0','2024-09-26 11:36:48','2024-10-20 21:49:06'),(10,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Garnett Lynch','lschoen@white.com','https://friendsofbotble.com','Could you provide more examples to illustrate your point?','approved','241.10.144.179','Opera/9.27 (X11; Linux x86_64; nl-NL) Presto/2.8.240 Version/12.00','2024-10-02 11:57:55','2024-10-20 21:49:06'),(11,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Katheryn Marquardt','bartoletti.guiseppe@hotmail.com','https://friendsofbotble.com','I wish there were more articles like this out there.','approved','13.209.31.68','Mozilla/5.0 (compatible; MSIE 8.0; Windows 95; Trident/4.1)','2024-10-10 07:02:59','2024-10-20 21:49:06'),(12,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Ms. Sabina Bogisich','agnes97@yahoo.com','https://friendsofbotble.com','I\'m bookmarking this for future reference.','approved','34.157.144.125','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_7_3 rv:5.0) Gecko/20210430 Firefox/36.0','2024-10-14 04:55:34','2024-10-20 21:49:06'),(13,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Valentine O\'Hara III','lgibson@tromp.com','https://friendsofbotble.com','I\'ve shared this with my friends, they loved it!','approved','185.89.224.97','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/5322 (KHTML, like Gecko) Chrome/39.0.894.0 Mobile Safari/5322','2024-10-05 06:30:22','2024-10-20 21:49:06'),(14,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Bettie Grant','czboncak@gmail.com','https://friendsofbotble.com','This article is a must-read for everyone interested in the topic.','approved','72.198.203.206','Mozilla/5.0 (iPhone; CPU iPhone OS 13_0 like Mac OS X) AppleWebKit/532.0 (KHTML, like Gecko) Version/15.0 EdgiOS/81.01034.15 Mobile/15E148 Safari/532.0','2024-10-10 03:55:07','2024-10-20 21:49:06'),(15,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Haleigh Herzog','crippin@kassulke.info','https://friendsofbotble.com','Thank you for shedding light on this important issue.','approved','172.241.236.180','Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 5.0; Trident/3.0)','2024-10-05 09:43:27','2024-10-20 21:49:06'),(16,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Andres Gutkowski DDS','marty.koepp@yahoo.com','https://friendsofbotble.com','I\'ve been searching for information on this topic, glad I found this article.','approved','197.31.179.144','Mozilla/5.0 (Windows NT 5.01) AppleWebKit/5321 (KHTML, like Gecko) Chrome/37.0.899.0 Mobile Safari/5321','2024-09-30 17:36:52','2024-10-20 21:49:06'),(17,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',2,'http://zelio.test','Emerson Larson III','jward@heathcote.com','https://friendsofbotble.com','I\'m blown away by the insights shared in this article.','approved','8.54.97.75','Mozilla/5.0 (compatible; MSIE 11.0; Windows 98; Trident/5.1)','2024-09-21 05:07:10','2024-10-20 21:49:06'),(18,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Freda Lubowitz','mgerhold@hotmail.com','https://friendsofbotble.com','This article tackles a complex topic with clarity.','approved','37.90.174.68','Mozilla/5.0 (X11; Linux i686) AppleWebKit/5362 (KHTML, like Gecko) Chrome/37.0.875.0 Mobile Safari/5362','2024-10-19 18:27:25','2024-10-20 21:49:06'),(19,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Retha Veum','boehm.electa@jacobson.com','https://friendsofbotble.com','I\'m going to reflect on the ideas presented in this article.','approved','119.184.27.187','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_1 rv:2.0) Gecko/20110525 Firefox/36.0','2024-09-24 10:58:43','2024-10-20 21:49:06'),(20,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',6,'http://zelio.test','Rafael Pouros','xfritsch@yahoo.com','https://friendsofbotble.com','The author\'s passion for the subject shines through in this article.','approved','15.137.111.174','Mozilla/5.0 (iPad; CPU OS 8_2_2 like Mac OS X; nl-NL) AppleWebKit/534.11.1 (KHTML, like Gecko) Version/4.0.5 Mobile/8B116 Safari/6534.11.1','2024-10-12 01:33:50','2024-10-20 21:49:06'),(21,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Evalyn Macejkovic','bergstrom.stan@barrows.com','https://friendsofbotble.com','This article challenged my preconceptions in a thought-provoking way.','approved','33.111.240.43','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/5360 (KHTML, like Gecko) Chrome/38.0.837.0 Mobile Safari/5360','2024-10-11 10:46:05','2024-10-20 21:49:06'),(22,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Fatima Feil','monroe.halvorson@lang.biz','https://friendsofbotble.com','I\'ve added this article to my reading list, it\'s worth revisiting.','approved','185.158.160.241','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.1 (KHTML, like Gecko) Chrome/96.0.4436.81 Safari/536.1 Edg/96.01017.49','2024-10-12 16:56:04','2024-10-20 21:49:06'),(23,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Mr. Dylan Marks','smith.frieda@herman.com','https://friendsofbotble.com','This article offers practical advice that I can apply in real life.','approved','210.69.241.102','Mozilla/5.0 (compatible; MSIE 10.0; Windows 98; Trident/3.0)','2024-09-26 11:22:38','2024-10-20 21:49:06'),(24,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',3,'http://zelio.test','Alexa Kiehn II','everette.okeefe@kautzer.com','https://friendsofbotble.com','I\'m going to recommend this article to my study group.','approved','6.39.213.134','Mozilla/5.0 (X11; Linux i686) AppleWebKit/5352 (KHTML, like Gecko) Chrome/39.0.806.0 Mobile Safari/5352','2024-10-03 17:33:30','2024-10-20 21:49:06'),(25,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Eloise Nienow','bridget28@abshire.net','https://friendsofbotble.com','The examples provided really helped me understand the concept better.','approved','144.213.88.159','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_6 rv:5.0) Gecko/20120725 Firefox/35.0','2024-09-30 19:43:48','2024-10-20 21:49:06'),(26,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',14,'http://zelio.test','Christiana Funk','kassulke.wiley@yahoo.com','https://friendsofbotble.com','I resonate with the ideas presented here.','approved','49.195.79.6','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/534.2 (KHTML, like Gecko) Chrome/88.0.4728.46 Safari/534.2 Edg/88.01078.98','2024-09-29 18:17:52','2024-10-20 21:49:06'),(27,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Isabel Grant','bo84@hotmail.com','https://friendsofbotble.com','This article made me think critically about the topic.','approved','83.29.29.69','Mozilla/5.0 (Windows 98; Win 9x 4.90) AppleWebKit/5330 (KHTML, like Gecko) Chrome/36.0.829.0 Mobile Safari/5330','2024-09-24 02:35:18','2024-10-20 21:49:06'),(28,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',3,'http://zelio.test','Jaida Hill','rosenbaum.matteo@hotmail.com','https://friendsofbotble.com','I\'ll definitely come back to this article for reference.','approved','109.2.82.187','Mozilla/5.0 (X11; Linux i686) AppleWebKit/5351 (KHTML, like Gecko) Chrome/37.0.819.0 Mobile Safari/5351','2024-10-17 13:02:44','2024-10-20 21:49:06'),(29,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Dr. Florencio Predovic II','tcassin@pfeffer.info','https://friendsofbotble.com','I\'ve shared this on social media, it\'s too good not to share.','approved','1.194.196.222','Mozilla/5.0 (compatible; MSIE 7.0; Windows 98; Trident/5.1)','2024-10-05 08:36:16','2024-10-20 21:49:06'),(30,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Dock Lesch','jed96@kertzmann.info','https://friendsofbotble.com','This article presents a balanced view on a controversial topic.','approved','239.191.63.1','Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_2 like Mac OS X; en-US) AppleWebKit/533.10.7 (KHTML, like Gecko) Version/4.0.5 Mobile/8B111 Safari/6533.10.7','2024-10-19 14:38:51','2024-10-20 21:49:06'),(31,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',2,'http://zelio.test','Aurelia Keeling','wilma04@hotmail.com','https://friendsofbotble.com','I\'m glad I stumbled upon this article, it\'s a gem.','approved','186.15.122.55','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_6 rv:5.0; sl-SI) AppleWebKit/535.42.1 (KHTML, like Gecko) Version/4.0 Safari/535.42.1','2024-09-24 19:43:13','2024-10-20 21:49:06'),(32,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Eliza Hills','aurelia.nikolaus@hotmail.com','https://friendsofbotble.com','I\'ve been struggling with this, your article helped a lot.','approved','38.60.11.206','Mozilla/5.0 (Macintosh; PPC Mac OS X 10_7_5 rv:6.0; nl-NL) AppleWebKit/531.10.2 (KHTML, like Gecko) Version/4.0.2 Safari/531.10.2','2024-09-28 14:13:40','2024-10-20 21:49:06'),(33,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Mr. Winston Hermann V','umayert@bruen.com','https://friendsofbotble.com','I\'ve learned something new today, thanks to this article.','approved','183.64.6.69','Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 4.0; Trident/5.0)','2024-10-09 22:41:50','2024-10-20 21:49:06'),(34,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Angelita Fahey','amira34@gmail.com','https://friendsofbotble.com','Kudos to the author for a well-researched piece.','approved','5.89.175.64','Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 5.0; Trident/5.0)','2024-10-15 07:18:54','2024-10-20 21:49:06'),(35,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Dandre Goyette DDS','ujohnson@yahoo.com','https://friendsofbotble.com','I\'m impressed by the depth of knowledge demonstrated here.','approved','19.102.169.54','Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 6.0; Trident/3.0)','2024-10-13 04:06:59','2024-10-20 21:49:06'),(36,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',11,'http://zelio.test','Prof. Danny Carroll','karelle.kunde@wyman.biz','https://friendsofbotble.com','This article challenged my assumptions in a good way.','approved','110.141.94.21','Mozilla/5.0 (Windows; U; Windows 98; Win 9x 4.90) AppleWebKit/532.17.1 (KHTML, like Gecko) Version/5.1 Safari/532.17.1','2024-09-21 00:46:14','2024-10-20 21:49:06'),(37,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',14,'http://zelio.test','Leland Frami','wiegand.narciso@hotmail.com','https://friendsofbotble.com','I\'ve shared this with my colleagues, it\'s worth discussing.','approved','122.123.179.172','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/5330 (KHTML, like Gecko) Chrome/38.0.844.0 Mobile Safari/5330','2024-10-10 22:10:00','2024-10-20 21:49:06'),(38,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',11,'http://zelio.test','Alana Berge','mariane33@hotmail.com','https://friendsofbotble.com','The information presented here is very valuable.','approved','224.28.102.19','Opera/8.41 (Windows NT 5.0; sl-SI) Presto/2.11.234 Version/10.00','2024-10-12 16:25:50','2024-10-20 21:49:06'),(39,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Dortha Gislason','wemard@hotmail.com','https://friendsofbotble.com','You have a talent for explaining complex topics clearly.','approved','22.87.243.202','Mozilla/5.0 (X11; Linux i686; rv:5.0) Gecko/20151006 Firefox/35.0','2024-09-23 18:52:33','2024-10-20 21:49:06'),(40,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Jonathan Cormier','tyson03@gmail.com','https://friendsofbotble.com','I\'m inspired to learn more about this after reading your article.','approved','252.224.101.123','Opera/9.14 (Windows NT 6.2; en-US) Presto/2.8.330 Version/12.00','2024-10-02 18:12:35','2024-10-20 21:49:06'),(41,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Eudora Lemke','drew29@dach.com','https://friendsofbotble.com','This article deserves wider recognition.','approved','109.37.46.152','Mozilla/5.0 (Windows NT 6.1; en-US; rv:1.9.0.20) Gecko/20160529 Firefox/36.0','2024-10-15 10:00:35','2024-10-20 21:49:06'),(42,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Hildegard West PhD','padberg.edwardo@frami.org','https://friendsofbotble.com','I\'m grateful for the insights shared in this piece.','approved','207.196.74.12','Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 4.0; Trident/3.0)','2024-10-10 15:09:17','2024-10-20 21:49:06'),(43,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Mr. Davonte Wiegand','kaitlyn76@little.com','https://friendsofbotble.com','The author presents a balanced view on a controversial topic.','approved','2.240.89.246','Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 5.0; Trident/5.0)','2024-10-16 07:57:59','2024-10-20 21:49:06'),(44,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Barbara Zulauf','nannie.hoeger@gmail.com','https://friendsofbotble.com','I\'m glad I stumbled upon this article, it\'s','approved','40.139.142.241','Opera/9.44 (Windows 98; nl-NL) Presto/2.9.351 Version/10.00','2024-10-20 20:54:52','2024-10-20 21:49:06'),(45,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',11,'http://zelio.test','Luther White','kamren47@hotmail.com','https://friendsofbotble.com','I\'ve been searching for information on this topic, glad I found this article. It\'s incredibly insightful and provides a comprehensive overview of the subject matter. I appreciate the effort put into researching and writing this piece. It\'s truly eye-opening and has given me a new perspective. Thank you for sharing your knowledge with us!','approved','239.118.198.232','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_8_0) AppleWebKit/5332 (KHTML, like Gecko) Chrome/37.0.804.0 Mobile Safari/5332','2024-10-19 04:56:01','2024-10-20 21:49:06'),(46,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Mr. Patrick Nikolaus','forest.ritchie@hauck.com','https://friendsofbotble.com','This article is a masterpiece! It dives deep into the topic and offers valuable insights that are both thought-provoking and enlightening. The author\'s expertise is evident throughout, making it a compelling read from start to finish. I\'ll definitely be coming back to this for reference in the future.','approved','206.80.123.83','Opera/8.24 (Windows NT 5.2; sl-SI) Presto/2.10.170 Version/12.00','2024-09-29 06:36:17','2024-10-20 21:49:06'),(47,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Kaden Bradtke','nkerluke@yahoo.com','https://friendsofbotble.com','I\'m amazed by the depth of analysis in this article. It covers a wide range of aspects related to the topic, providing a comprehensive understanding. The clarity of explanation is commendable, making complex concepts easy to grasp. This article has enriched my understanding and sparked further curiosity. Kudos to the author!','approved','181.95.26.165','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/5340 (KHTML, like Gecko) Chrome/39.0.868.0 Mobile Safari/5340','2024-09-22 18:23:39','2024-10-20 21:49:06'); /*!40000 ALTER TABLE `fob_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `language_meta` -- DROP TABLE IF EXISTS `language_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `language_meta` -- LOCK TABLES `language_meta` WRITE; /*!40000 ALTER TABLE `language_meta` DISABLE KEYS */; INSERT INTO `language_meta` VALUES (1,'en_US','52d1deb76fde7cd5eca6c5ea487d7d91',1,'Botble\\Menu\\Models\\MenuLocation'),(2,'en_US','9598df715a6dddb52b804b8b0fd8661d',1,'Botble\\Menu\\Models\\Menu'); /*!40000 ALTER TABLE `language_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `languages` -- LOCK TABLES `languages` WRITE; /*!40000 ALTER TABLE `languages` DISABLE KEYS */; INSERT INTO `languages` VALUES (1,'English','en','en_US','us',1,0,0); /*!40000 ALTER TABLE `languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media_files` -- DROP TABLE IF EXISTS `media_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media_files` -- LOCK TABLES `media_files` WRITE; /*!40000 ALTER TABLE `media_files` DISABLE KEYS */; INSERT INTO `media_files` VALUES (1,0,'1','1',2,'image/png',9448,'main/posts/1.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(2,0,'10','10',2,'image/png',9448,'main/posts/10.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(3,0,'11','11',2,'image/png',9448,'main/posts/11.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(4,0,'12','12',2,'image/png',9448,'main/posts/12.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(5,0,'2','2',2,'image/png',9448,'main/posts/2.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(6,0,'3','3',2,'image/png',9448,'main/posts/3.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(7,0,'4','4',2,'image/png',9448,'main/posts/4.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(8,0,'5','5',2,'image/png',9448,'main/posts/5.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(9,0,'6','6',2,'image/png',9448,'main/posts/6.png','[]','2024-10-20 21:49:01','2024-10-20 21:49:01',NULL,'public'),(10,0,'7','7',2,'image/png',9448,'main/posts/7.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(11,0,'8','8',2,'image/png',9448,'main/posts/8.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(12,0,'9','9',2,'image/png',9448,'main/posts/9.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(13,0,'background','background',2,'image/png',9448,'main/posts/background.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(14,0,'1','1',3,'image/png',2100,'main/avatars/1.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(15,0,'2','2',3,'image/png',2100,'main/avatars/2.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(16,0,'man','man',3,'image/png',2100,'main/avatars/man.png','[]','2024-10-20 21:49:02','2024-10-20 21:49:02',NULL,'public'),(21,0,'1','1',5,'image/png',9448,'main/services/1.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(22,0,'2','2',5,'image/png',9448,'main/services/2.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(23,0,'3','3',5,'image/png',9448,'main/services/3.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(24,0,'4','4',5,'image/png',9448,'main/services/4.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(25,0,'1','1',4,'image/png',9448,'main/projects/1.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(26,0,'2','2',4,'image/png',9448,'main/projects/2.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(27,0,'3','3',4,'image/png',9448,'main/projects/3.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(28,0,'4','4',4,'image/png',9448,'main/projects/4.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(29,0,'favicon','favicon',6,'image/png',2457,'main/general/favicon.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(30,0,'footer-bg','footer-bg',6,'image/png',6888,'main/general/footer-bg.png','[]','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'public'),(31,0,'grid-bg','grid-bg',6,'image/png',284426,'main/general/grid-bg.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(32,0,'hero-bg','hero-bg',6,'image/png',17011,'main/general/hero-bg.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(33,0,'hero-decorate','hero-decorate',6,'image/png',161280,'main/general/hero-decorate.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(34,0,'hero-man','hero-man',6,'image/png',18294,'main/general/hero-man.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(35,0,'logo-dark','logo-dark',6,'image/png',4327,'main/general/logo-dark.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(36,0,'1','1',7,'image/png',1570,'main/brands/1.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(37,0,'10','10',7,'image/png',1570,'main/brands/10.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(38,0,'2','2',7,'image/png',1570,'main/brands/2.png','[]','2024-10-20 21:49:04','2024-10-20 21:49:04',NULL,'public'),(39,0,'3','3',7,'image/png',1570,'main/brands/3.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(40,0,'4','4',7,'image/png',1570,'main/brands/4.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(41,0,'5','5',7,'image/png',1570,'main/brands/5.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(42,0,'6','6',7,'image/png',1570,'main/brands/6.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(43,0,'7','7',7,'image/png',1570,'main/brands/7.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(44,0,'8','8',7,'image/png',1570,'main/brands/8.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(45,0,'9','9',7,'image/png',1570,'main/brands/9.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(46,0,'1','1',8,'image/png',1866,'main/skills/1.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(47,0,'2','2',8,'image/png',1866,'main/skills/2.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(48,0,'3','3',8,'image/png',1866,'main/skills/3.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(49,0,'4','4',8,'image/png',1866,'main/skills/4.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(50,0,'5','5',8,'image/png',1866,'main/skills/5.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(51,0,'6','6',8,'image/png',1866,'main/skills/6.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(52,0,'7','7',8,'image/png',1866,'main/skills/7.png','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'),(53,0,'cv','cv',9,'application/pdf',43496,'main/resume/cv.pdf','[]','2024-10-20 21:49:05','2024-10-20 21:49:05',NULL,'public'); /*!40000 ALTER TABLE `media_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media_folders` -- DROP TABLE IF EXISTS `media_folders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media_folders` -- LOCK TABLES `media_folders` WRITE; /*!40000 ALTER TABLE `media_folders` DISABLE KEYS */; INSERT INTO `media_folders` VALUES (1,0,'main',NULL,'main',0,'2024-10-20 21:49:01','2024-10-20 21:49:01',NULL),(2,0,'posts',NULL,'posts',1,'2024-10-20 21:49:01','2024-10-20 21:49:01',NULL),(3,0,'avatars',NULL,'avatars',1,'2024-10-20 21:49:02','2024-10-20 21:49:02',NULL),(4,0,'projects',NULL,'projects',1,'2024-10-20 21:49:02','2024-10-20 21:49:02',NULL),(5,0,'services',NULL,'services',1,'2024-10-20 21:49:03','2024-10-20 21:49:03',NULL),(6,0,'general',NULL,'general',1,'2024-10-20 21:49:03','2024-10-20 21:49:03',NULL),(7,0,'brands',NULL,'brands',1,'2024-10-20 21:49:04','2024-10-20 21:49:04',NULL),(8,0,'skills',NULL,'skills',1,'2024-10-20 21:49:05','2024-10-20 21:49:05',NULL),(9,0,'resume',NULL,'resume',1,'2024-10-20 21:49:05','2024-10-20 21:49:05',NULL); /*!40000 ALTER TABLE `media_folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media_settings` -- DROP TABLE IF EXISTS `media_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media_settings` -- LOCK TABLES `media_settings` WRITE; /*!40000 ALTER TABLE `media_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `media_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_locations` -- DROP TABLE IF EXISTS `menu_locations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `menu_locations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `menu_id` bigint unsigned NOT NULL, `location` varchar(191) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_locations` -- LOCK TABLES `menu_locations` WRITE; /*!40000 ALTER TABLE `menu_locations` DISABLE KEYS */; INSERT INTO `menu_locations` VALUES (1,1,'main-menu','2024-10-20 21:49:06','2024-10-20 21:49:06'); /*!40000 ALTER TABLE `menu_locations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_nodes` -- DROP TABLE IF EXISTS `menu_nodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icon_font` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `position` tinyint unsigned NOT NULL DEFAULT '0', `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `css_class` varchar(191) 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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_nodes` -- LOCK TABLES `menu_nodes` WRITE; /*!40000 ALTER TABLE `menu_nodes` DISABLE KEYS */; INSERT INTO `menu_nodes` VALUES (1,1,0,1,'Botble\\Page\\Models\\Page','/home',NULL,0,'Home',NULL,'_self',1,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(2,1,1,NULL,NULL,'https://zelio.botble.com',NULL,0,'Home 1 - Designer',NULL,'_blank',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(3,1,1,NULL,NULL,'https://zelio-developer.botble.com',NULL,0,'Home 2 - Developer',NULL,'_blank',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(4,1,1,NULL,NULL,'https://zelio-writer.botble.com',NULL,0,'Home 3 - Writer',NULL,'_blank',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(5,1,0,2,'Botble\\Page\\Models\\Page','/services',NULL,0,'Services',NULL,'_self',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(6,1,0,3,'Botble\\Page\\Models\\Page','/projects',NULL,0,'Portfolio',NULL,'_self',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(7,1,0,4,'Botble\\Page\\Models\\Page','/pricing',NULL,0,'Pricing',NULL,'_self',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(8,1,0,5,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog',NULL,'_self',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'),(9,1,0,6,'Botble\\Page\\Models\\Page','/contact',NULL,0,'Contact',NULL,'_self',0,'2024-10-20 21:49:06','2024-10-20 21:49:06'); /*!40000 ALTER TABLE `menu_nodes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menus` -- DROP TABLE IF EXISTS `menus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menus` -- LOCK TABLES `menus` WRITE; /*!40000 ALTER TABLE `menus` DISABLE KEYS */; INSERT INTO `menus` VALUES (1,'Main Menu','main-menu','published','2024-10-20 21:49:06','2024-10-20 21:49:06'); /*!40000 ALTER TABLE `menus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `meta_boxes` -- DROP TABLE IF EXISTS `meta_boxes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `meta_boxes` -- LOCK TABLES `meta_boxes` WRITE; /*!40000 ALTER TABLE `meta_boxes` DISABLE KEYS */; INSERT INTO `meta_boxes` VALUES (1,'link','[\"https:\\/\\/example.com\\/e-commerce\"]',1,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(2,'category_ids','[[1]]',1,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(3,'link','[\"https:\\/\\/example.com\\/mobile-app\"]',2,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(4,'category_ids','[[2]]',2,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(5,'link','[\"https:\\/\\/example.com\\/portfolio\"]',3,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(6,'category_ids','[[1,2]]',3,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(7,'link','[\"https:\\/\\/example.com\\/seo-marketing\"]',4,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'),(8,'category_ids','[[3,4]]',4,'Botble\\Portfolio\\Models\\Project','2024-10-20 21:49:03','2024-10-20 21:49:03'); /*!40000 ALTER TABLE `meta_boxes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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,'2015_06_18_033822_create_blog_table',1),(6,'2015_06_29_025744_create_audit_history',1),(7,'2016_05_28_112028_create_system_request_logs_table',1),(8,'2016_06_10_230148_create_acl_tables',1),(9,'2016_06_14_230857_create_menus_table',1),(10,'2016_06_17_091537_create_contacts_table',1),(11,'2016_06_28_221418_create_pages_table',1),(12,'2016_10_03_032336_create_languages_table',1),(13,'2016_10_05_074239_create_setting_table',1),(14,'2016_10_07_193005_create_translations_table',1),(15,'2016_11_28_032840_create_dashboard_widget_tables',1),(16,'2016_12_16_084601_create_widgets_table',1),(17,'2017_05_09_070343_create_media_tables',1),(18,'2017_10_24_154832_create_newsletter_table',1),(19,'2017_11_03_070450_create_slug_table',1),(20,'2018_07_09_214610_create_testimonial_table',1),(21,'2018_07_09_221238_create_faq_table',1),(22,'2019_01_05_053554_create_jobs_table',1),(23,'2019_08_19_000000_create_failed_jobs_table',1),(24,'2019_12_14_000001_create_personal_access_tokens_table',1),(25,'2021_02_16_092633_remove_default_value_for_author_type',1),(26,'2021_10_25_021023_fix-priority-load-for-language-advanced',1),(27,'2021_12_03_030600_create_blog_translations',1),(28,'2021_12_03_075608_create_page_translations',1),(29,'2021_12_03_082134_create_faq_translations',1),(30,'2021_12_03_083642_create_testimonials_translations',1),(31,'2022_04_19_113923_add_index_to_table_posts',1),(32,'2022_04_20_100851_add_index_to_media_table',1),(33,'2022_04_20_101046_add_index_to_menu_table',1),(34,'2022_07_10_034813_move_lang_folder_to_root',1),(35,'2022_08_04_051940_add_missing_column_expires_at',1),(36,'2022_09_01_000001_create_admin_notifications_tables',1),(37,'2022_10_14_024629_drop_column_is_featured',1),(38,'2022_11_18_063357_add_missing_timestamp_in_table_settings',1),(39,'2022_12_02_093615_update_slug_index_columns',1),(40,'2023_01_30_024431_add_alt_to_media_table',1),(41,'2023_02_16_042611_drop_table_password_resets',1),(42,'2023_04_23_005903_add_column_permissions_to_admin_notifications',1),(43,'2023_05_10_075124_drop_column_id_in_role_users_table',1),(44,'2023_07_06_011444_create_slug_translations_table',1),(45,'2023_07_25_072632_create_portfolio_tables',1),(46,'2023_08_21_090810_make_page_content_nullable',1),(47,'2023_08_29_074620_make_column_author_id_nullable',1),(48,'2023_09_11_023233_create_pf_custom_fields_table',1),(49,'2023_09_13_042633_add_columns_to_pf_projects_table',1),(50,'2023_09_13_044041_create_pf_project_categories_table',1),(51,'2023_09_14_021936_update_index_for_slugs_table',1),(52,'2023_09_14_022423_add_index_for_language_table',1),(53,'2023_09_22_061723_create_custom_fields_translations_table',1),(54,'2023_09_22_343531_remove_project_categories_table',1),(55,'2023_11_05_081701_fix_projects_table',1),(56,'2023_11_10_080225_migrate_contact_blacklist_email_domains_to_core',1),(57,'2023_11_14_033417_change_request_column_in_table_audit_histories',1),(58,'2023_11_17_063408_add_description_column_to_faq_categories_table',1),(59,'2023_12_07_095130_add_color_column_to_media_folders_table',1),(60,'2023_12_12_105220_drop_translations_table',1),(61,'2023_12_17_162208_make_sure_column_color_in_media_folders_nullable',1),(62,'2024_01_16_050056_create_comments_table',1),(63,'2024_03_20_080001_migrate_change_attribute_email_to_nullable_form_contacts_table',1),(64,'2024_03_25_000001_update_captcha_settings_for_contact',1),(65,'2024_03_25_000001_update_captcha_settings_for_newsletter',1),(66,'2024_04_04_110758_update_value_column_in_user_meta_table',1),(67,'2024_04_19_063914_create_custom_fields_table',1),(68,'2024_04_27_100730_improve_analytics_setting',1),(69,'2024_05_12_091229_add_column_visibility_to_table_media_files',1),(70,'2024_05_16_060328_add_projects_translations_table',1),(71,'2024_07_07_091316_fix_column_url_in_menu_nodes_table',1),(72,'2024_07_12_100000_change_random_hash_for_media',1),(73,'2024_07_30_091615_fix_order_column_in_categories_table',1),(74,'2024_09_09_075552_add_action_field_pf_packages_table',1),(75,'2024_09_30_024515_create_sessions_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletters` -- DROP TABLE IF EXISTS `newsletters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `newsletters` -- LOCK TABLES `newsletters` WRITE; /*!40000 ALTER TABLE `newsletters` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages` -- DROP TABLE IF EXISTS `pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pages` -- LOCK TABLES `pages` WRITE; /*!40000 ALTER TABLE `pages` DISABLE KEYS */; INSERT INTO `pages` VALUES (1,'Home','[hero-banner style="1" title="Crafting Intuitive <span class='text-primary'>Digital Experiences</span>" subtitle="? Hi there, I'm William" description="I assist individuals and brands in achieving their objectives by creating and developing user-focused digital products and interactive experiences." below_button_text="+ 12 years with professional design software" primary_button_text="Download CV" primary_button_link="/storage/main/resume/cv.pdf" primary_button_icon="ti ti-download" secondary_button_text="Hire Me" secondary_button_link="#contact" secondary_button_icon="ti ti-arrow-right" quantity="6" name_1="Figma" image_1="main/skills/1.png" name_2="Adobe XD" image_2="main/skills/2.png" name_3="Illustrator" image_3="main/skills/3.png" name_4="Sketch" image_4="main/skills/4.png" name_5="Photoshop" image_5="main/skills/5.png" name_6="Webflow" image_6="main/skills/6.png" background_image="main/general/hero-bg.png" right_image="main/general/hero-man.png" right_image_shape="main/general/hero-decorate.png" enable_lazy_loading="no"][/hero-banner]\n[stats-counter style="1" quantity="4" label_1="Years of" highlight_text_1="Experience" count_1="12" label_2="Projects" highlight_text_2="Completed" count_2="250" label_3="Satisfied" highlight_text_3="Happy Clients" count_3="680" label_4="Awards" highlight_text_4="Won Received" count_4="18" enable_lazy_loading="no"][/stats-counter]\n[services style="1" title="What do I offer?" subtitle="My journey started with a fascination for design and technology, leading me to specialize in UI/UX design" service_ids="1,4,2,3" enable_lazy_loading="yes"][/services]\n[projects style="1" title="My Latest Works" subtitle="I believe that working hard and trying to learn every day will <br> make me improve in satisfying my customers." project_ids="1,2,3,4" bottom_action_text="View all" bottom_action_link="/projects" enable_lazy_loading="yes"][/projects]\n[resume style="1" title="My Resume" subtitle="I believe that working hard and trying to learn every day will <br> make me improve in satisfying my customers." action_text="Get in touch" action_link="#contact" resume_1_title="Education" resume_1_title_icon="ti ti-school" resume_1_quantity="4" resume_1_time_1="2018 - 2019" resume_1_title_1="Certification in UX Design" resume_1_description_1="University of Stanford" resume_1_subtitle_1="4.9/5" resume_1_time_2="2017 - 2018" resume_1_title_2="Certification in Web Dev" resume_1_description_2="University of Stanford" resume_1_subtitle_2="5.0/5" resume_1_time_3="2014 - 2016" resume_1_title_3="Advanced UX/UI Bootcamp" resume_1_description_3="Design Academy" resume_1_subtitle_3="4.9/5" resume_1_time_4="2012 - 2013" resume_1_title_4="Certification in Graphic Design" resume_1_description_4="Coursera" resume_1_subtitle_4="4.8/5" resume_2_title="Experience" resume_2_title_icon="ti ti-stars" resume_2_quantity="4" resume_2_time_1="2019 - Present" resume_2_title_1="Senior UI/UX Designer" resume_2_description_1="Leader in Creative team" resume_2_time_2="2016 - 2019" resume_2_title_2="UI/UX Designer" resume_2_description_2="Tech Startup" resume_2_time_3="2014 - 2016" resume_2_title_3="Freelance UI/UX Designer" resume_2_description_3="Self-Employed" resume_2_time_4="2012 - 2014" resume_2_title_4="Junior UI Designer" resume_2_description_4="Web Solutions team" bottom_text="Branding . Marketing . User Interface" background_image="main/general/grid-bg.png" enable_lazy_loading="yes"][/resume]\n[skills style="1" title="My Skills" subtitle="I thrive on turning complex problems into simple, beautiful <br> solutions that enhance user satisfaction." quantity="7" name_1="Figma" image_1="main/skills/1.png" level_1="70%" name_2="Adobe XD" image_2="main/skills/2.png" level_2="75%" name_3="Illustrator" image_3="main/skills/3.png" level_3="87%" name_4="Sketch" image_4="main/skills/4.png" level_4="97%" name_5="Photoshop" image_5="main/skills/5.png" level_5="82%" name_6="Webflow" image_6="main/skills/6.png" level_6="82%" name_7="Framer" image_7="main/skills/7.png" level_7="85%" extra_content="In addition, I have some programming knowledge such as: <br> <span class='fs-5 fw-bold text-dark'>HTML, CSS, Javascript, Bootstrap, TailwindCSS</span>" enable_lazy_loading="yes"][/skills]\n[image-slider title="Trusted by industry leaders" subtitle="I have collaborated with many large corporations, companies, and agencies around <br> the world in many fields of design and consulting" quantity="10" name_1="Brave" image_1="main/brands/1.png" url_1="https://Brave.com" open_in_new_tab_1="1" name_2="Circle" image_2="main/brands/2.png" url_2="https://Circle.com" open_in_new_tab_2="1" name_3="Discord" image_3="main/brands/3.png" url_3="https://Discord.com" open_in_new_tab_3="1" name_4="Google" image_4="main/brands/4.png" url_4="https://Google.com" open_in_new_tab_4="1" name_5="jump_" image_5="main/brands/5.png" url_5="https://jump.com" open_in_new_tab_5="1" name_6="Magic Eden" image_6="main/brands/6.png" url_6="https://Magic Eden.com" open_in_new_tab_6="1" name_7="MetaMask" image_7="main/brands/7.png" url_7="https://MetaMask.com" open_in_new_tab_7="1" name_8="Shopify" image_8="main/brands/8.png" url_8="https://Shopify.com" open_in_new_tab_8="1" name_9="Stripe" image_9="main/brands/9.png" url_9="https://Stripe.com" open_in_new_tab_9="1" name_10="Lolliapaloza" image_10="main/brands/10.png" url_10="https://Lolliapaloza.com" open_in_new_tab_10="1" enable_lazy_loading="yes"][/image-slider]\n[testimonials title="Client's Testimonials" subtitle="I believe that working hard and trying to learn every day will make me <br> improve in satisfying my customers." testimonial_ids="1,2,3,4" shape_image="main/avatars/man.png" enable_lazy_loading="yes"][/testimonials]\n[blog-posts style="1" paginate="3" title="Recent blog" subtitle="Explore the insights and trends shaping our industry" action_text="View more" action_link="/blog" enable_lazy_loading="yes"][/blog-posts]\n[contact-form style="1" display_fields="phone,email,subject,address" mandatory_fields="email,subject" title="Get in touch" subtitle="I'm always excited to take on new projects and collaborate with innovative minds. If you <br> have a project in mind or just want to chat about design, feel free to reach out!" quantity="4" label_1="Phone" content_1="+1-234-567-8901" icon_1="ti ti-phone" url_1="tel:+1-234-567-8901" label_2="Email" content_2="contact@botble.com" icon_2="ti ti-mail" url_2="mailto:contact@botble.com" label_3="X (Twitter)" content_3="Botble Technologies" icon_3="ti ti-user" url_3="https://x.com/botble" label_4="Address" content_4="0811 Erdman Prairie, Joaville CA" icon_4="ti ti-map" url_4="https://google.com/maps"][/contact-form]',1,NULL,'default',NULL,'published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(2,'Services','[services style="4" enable_lazy_loading="no"][/services]',1,NULL,'has-heading','\n With expertise in mobile app and web design, I transform ideas into visually\n stunning and user-friendly interfaces that captivate and retain users.\n Explore my work and see design in action.','published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(3,'Projects','[projects style="4" enable_lazy_loading="no"][/projects]',1,NULL,'has-heading','\n With expertise in mobile app and web design, I transform ideas into visually\n stunning and user-friendly interfaces that captivate and retain users.\n Explore my work and see design in action.','published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(4,'Pricing','[pricing-plans package_ids="1,2" enable_lazy_loading="no"][/pricing-plans]\n[faqs title="Common Questions" category_ids="2" enable_lazy_loading="no"][/faqs]',1,NULL,'has-heading','Flexible Plans Tailored to Meet Your Unique Needs, Ensuring High-Quality Services\n Without Breaking the Bank','published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(5,'Blog','',1,NULL,'has-heading','Discover key insights and emerging trends shaping the future of design: a detailed\n examination of how these innovations are reshaping our industry','published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(6,'Contact','[contact-form style="1" display_fields="phone,email,subject,address" mandatory_fields="email,subject" title="Let's connect" quantity="4" label_1="Phone" content_1="+1-234-567-8901" icon_1="ti ti-phone" url_1="tel:+1-234-567-8901" label_2="Email" content_2="contact@botble.com" icon_2="ti ti-mail" url_2="mailto:contact@botble.com" label_3="X (Twitter)" content_3="Botble Technologies" icon_3="ti ti-user" url_3="https://x.com/botble" label_4="Address" content_4="0811 Erdman Prairie, Joaville CA" icon_4="ti ti-map" url_4="https://google.com/maps"][/contact-form]',1,NULL,'default',NULL,'published','2024-10-20 21:49:05','2024-10-20 21:49:05'),(7,'Cookie Policy','

EU Cookie Consent

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.

Essential Data

The Essential Data is needed to run the Site you are visiting technically. You can not deactivate them.

- Session Cookie: PHP uses a Cookie to identify user sessions. Without this Cookie the Website is not working.

- 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.

',1,NULL,'has-heading',NULL,'published','2024-10-20 21:49:05','2024-10-20 21:49:05'); /*!40000 ALTER TABLE `pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages_translations` -- DROP TABLE IF EXISTS `pages_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pages_translations` -- LOCK TABLES `pages_translations` WRITE; /*!40000 ALTER TABLE `pages_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pages_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_custom_field_options` -- DROP TABLE IF EXISTS `pf_custom_field_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_custom_field_options` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `custom_field_id` bigint unsigned NOT NULL, `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `order` int NOT NULL DEFAULT '999', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `pf_custom_field_options_custom_field_id_index` (`custom_field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_custom_field_options` -- LOCK TABLES `pf_custom_field_options` WRITE; /*!40000 ALTER TABLE `pf_custom_field_options` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_custom_field_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_custom_field_options_translations` -- DROP TABLE IF EXISTS `pf_custom_field_options_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_custom_field_options_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pf_custom_field_options_id` bigint unsigned NOT NULL, PRIMARY KEY (`lang_code`,`pf_custom_field_options_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_custom_field_options_translations` -- LOCK TABLES `pf_custom_field_options_translations` WRITE; /*!40000 ALTER TABLE `pf_custom_field_options_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_custom_field_options_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_custom_fields` -- DROP TABLE IF EXISTS `pf_custom_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_custom_fields` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `author_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `author_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `required` tinyint(1) NOT NULL DEFAULT '0', `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `order` int NOT NULL DEFAULT '999', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `pf_custom_fields_author_type_author_id_index` (`author_type`,`author_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_custom_fields` -- LOCK TABLES `pf_custom_fields` WRITE; /*!40000 ALTER TABLE `pf_custom_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_custom_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_custom_fields_translations` -- DROP TABLE IF EXISTS `pf_custom_fields_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_custom_fields_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pf_custom_fields_id` bigint unsigned NOT NULL, PRIMARY KEY (`lang_code`,`pf_custom_fields_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_custom_fields_translations` -- LOCK TABLES `pf_custom_fields_translations` WRITE; /*!40000 ALTER TABLE `pf_custom_fields_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_custom_fields_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_packages` -- DROP TABLE IF EXISTS `pf_packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_packages` ( `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` text COLLATE utf8mb4_unicode_ci NOT NULL, `price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `annual_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `duration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'monthly', `features` text COLLATE utf8mb4_unicode_ci, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published', `is_popular` tinyint(1) NOT NULL DEFAULT '0', `action_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_packages` -- LOCK TABLES `pf_packages` WRITE; /*!40000 ALTER TABLE `pf_packages` DISABLE KEYS */; INSERT INTO `pf_packages` VALUES (1,'Basic','For small businesses and startups.','','$49',NULL,'hourly','Require your wireframe\nDesign using Figma, Framer\nDevelop with Webflow, React, WordPress, Laravel/PHP\nRemote/Online collaboration\nAvailable on business days, no weekends\n6 months of support','published',0,'Get Started','/contact','2024-10-20 21:49:03','2024-10-20 21:49:03'),(2,'Business','For growing businesses and agencies.','','$99',NULL,'hourly','No wireframe needed\nDesign using Figma, Framer\nDevelop with Webflow, React, WordPress, Laravel/PHP\nRemote/Online collaboration\nAvailable on business days, no weekends\n12 months of support\nYour project is always a priority\nCustomer care gifts included','published',0,'Get Started','/contact','2024-10-20 21:49:03','2024-10-20 21:49:03'); /*!40000 ALTER TABLE `pf_packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_packages_translations` -- DROP TABLE IF EXISTS `pf_packages_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_packages_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `pf_packages_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text COLLATE utf8mb4_unicode_ci, `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `annual_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `features` text COLLATE utf8mb4_unicode_ci, `action_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`lang_code`,`pf_packages_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_packages_translations` -- LOCK TABLES `pf_packages_translations` WRITE; /*!40000 ALTER TABLE `pf_packages_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_packages_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_projects` -- DROP TABLE IF EXISTS `pf_projects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_projects` ( `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, `place` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `client` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_featured` tinyint(1) NOT NULL DEFAULT '0', `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `images` text COLLATE utf8mb4_unicode_ci, `views` int 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, `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_projects` -- LOCK TABLES `pf_projects` WRITE; /*!40000 ALTER TABLE `pf_projects` DISABLE KEYS */; INSERT INTO `pf_projects` VALUES (1,'E-Commerce Website','A full-featured e-commerce platform with a clean UI/UX, integrated payment systems, and advanced search features.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',NULL,'Retail Store',0,'main/projects/1.png',NULL,3286,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'2023-08-15'),(2,'Mobile App Design','A sleek mobile app design for a travel booking service, focusing on user-friendly navigation and visual appeal.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',NULL,'Travel Agency',1,'main/projects/2.png',NULL,9644,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'2023-05-20'),(3,'Portfolio Website','A minimalist portfolio website for showcasing creative work, with fast loading and responsive design.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',NULL,'Creative Professional',0,'main/projects/3.png',NULL,8736,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'2022-11-10'),(4,'SEO and Marketing Campaign','A successful SEO and digital marketing campaign, driving organic traffic and increasing conversion rates.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',NULL,'Tech Startup',0,'main/projects/4.png',NULL,8930,'published','2024-10-20 21:49:03','2024-10-20 21:49:03',NULL,'2023-02-05'); /*!40000 ALTER TABLE `pf_projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_projects_translations` -- DROP TABLE IF EXISTS `pf_projects_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_projects_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `pf_projects_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_projects_translations` -- LOCK TABLES `pf_projects_translations` WRITE; /*!40000 ALTER TABLE `pf_projects_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_projects_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_quotes` -- DROP TABLE IF EXISTS `pf_quotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_quotes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `fields` text COLLATE utf8mb4_unicode_ci, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_quotes` -- LOCK TABLES `pf_quotes` WRITE; /*!40000 ALTER TABLE `pf_quotes` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_quotes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_service_categories` -- DROP TABLE IF EXISTS `pf_service_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_service_categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `parent_id` bigint unsigned DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` tinyint NOT NULL DEFAULT '0', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `pf_service_categories_parent_id_index` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_service_categories` -- LOCK TABLES `pf_service_categories` WRITE; /*!40000 ALTER TABLE `pf_service_categories` DISABLE KEYS */; INSERT INTO `pf_service_categories` VALUES (1,NULL,'Development','All types of software and web development services.',NULL,0,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(2,NULL,'Design','Creative and intuitive design solutions for UI/UX and branding.',NULL,0,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(3,NULL,'Marketing','Digital marketing services, including SEO, social media, and more.',NULL,0,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(4,NULL,'Content','Content creation and management for blogs, websites, and media.',NULL,0,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'); /*!40000 ALTER TABLE `pf_service_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_service_categories_translations` -- DROP TABLE IF EXISTS `pf_service_categories_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_service_categories_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `pf_service_categories_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`lang_code`,`pf_service_categories_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_service_categories_translations` -- LOCK TABLES `pf_service_categories_translations` WRITE; /*!40000 ALTER TABLE `pf_service_categories_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_service_categories_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_services` -- DROP TABLE IF EXISTS `pf_services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_services` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci, `is_featured` tinyint(1) NOT NULL DEFAULT '0', `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `images` text COLLATE utf8mb4_unicode_ci, `views` int 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`), KEY `pf_services_category_id_index` (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_services` -- LOCK TABLES `pf_services` WRITE; /*!40000 ALTER TABLE `pf_services` DISABLE KEYS */; INSERT INTO `pf_services` VALUES (1,3,'Web Development','Building responsive and modern websites using cutting-edge
technologies.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',1,'main/services/1.png',NULL,1660,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(2,4,'UI/UX Design','Creating user-centered designs that provide intuitive and
engaging user experiences.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',0,'main/services/2.png',NULL,2884,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(3,4,'SEO Optimization','Improving website rankings on search engines to drive more
organic traffic.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',0,'main/services/3.png',NULL,8534,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'),(4,3,'Content Creation','Providing high-quality content tailored to your business
needs.','
Description
\n

Travila is a comprehensive travel booking app designed to provide users with a seamless and enjoyable booking experience. The project involved creating an intuitive and visually appealing user interface, ensuring that users can effortlessly book flights, hotels, and car rentals all within a single app. The primary goal was to enhance the overall user experience, making travel planning easy and enjoyable.

\n
Key Features
\n\n
Technologies Used
\n\n
Design Highlights
\n\n',0,'main/services/4.png',NULL,10000,'published','2024-10-20 21:49:03','2024-10-20 21:49:03'); /*!40000 ALTER TABLE `pf_services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pf_services_translations` -- DROP TABLE IF EXISTS `pf_services_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pf_services_translations` ( `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `pf_services_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`lang_code`,`pf_services_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pf_services_translations` -- LOCK TABLES `pf_services_translations` WRITE; /*!40000 ALTER TABLE `pf_services_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `pf_services_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `post_categories` -- DROP TABLE IF EXISTS `post_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `post_categories` -- LOCK TABLES `post_categories` WRITE; /*!40000 ALTER TABLE `post_categories` DISABLE KEYS */; INSERT INTO `post_categories` VALUES (7,1),(5,1),(9,2),(5,2),(7,3),(9,3),(8,4),(5,4),(3,5),(8,5),(2,6),(6,6),(4,7),(8,7),(4,8),(2,8),(3,9),(2,9),(1,10),(4,10),(2,11),(8,11),(7,12),(8,12),(7,13),(5,13),(6,14),(2,14),(2,15),(8,15); /*!40000 ALTER TABLE `post_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `post_tags` -- DROP TABLE IF EXISTS `post_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `post_tags` -- LOCK TABLES `post_tags` WRITE; /*!40000 ALTER TABLE `post_tags` DISABLE KEYS */; INSERT INTO `post_tags` VALUES (3,1),(1,1),(4,1),(4,2),(5,2),(3,2),(5,3),(7,3),(1,4),(7,4),(8,4),(7,5),(4,5),(6,5),(4,6),(2,6),(8,6),(4,7),(7,7),(8,7),(6,8),(4,8),(1,9),(6,9),(3,9),(3,10),(8,10),(4,10),(6,11),(7,11),(3,11),(7,12),(4,12),(3,12),(2,13),(7,13),(5,13),(1,14),(5,14),(1,15),(8,15); /*!40000 ALTER TABLE `post_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `posts` -- DROP TABLE IF EXISTS `posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `posts` -- LOCK TABLES `posts` WRITE; /*!40000 ALTER TABLE `posts` DISABLE KEYS */; INSERT INTO `posts` VALUES (1,'Building a Full-Stack App with the TALL Stack','Learn how to build a full-stack web application using the TALL stack, integrating Laravel, Alpine.js, Tailwind CSS, and Livewire for dynamic and responsive web development.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/3.png',834,NULL,'2024-04-12 10:32:40','2024-10-20 21:49:02'),(2,'My Journey in Open Source: 3 Years of Contributions','A personal reflection on my experiences contributing to open source projects over the past three years, sharing lessons learned and advice for aspiring contributors.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/9.png',1159,NULL,'2024-02-10 03:28:07','2024-10-20 21:49:02'),(3,'5 Essential Tools for Web Developers in 2024','Discover the top 5 tools that are essential for web developers in 2024, from frameworks and libraries to productivity boosters.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/9.png',1174,NULL,'2024-02-20 05:53:18','2024-10-20 21:49:02'),(4,'How I Built My Personal Portfolio Using Botble CMS','A detailed walkthrough on how I built my portfolio website using Botble CMS, customizing it with the Zelio template for an impressive online presence.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/3.png',2463,NULL,'2024-01-20 04:51:37','2024-10-20 21:49:02'),(5,'Creating Responsive UIs with Tailwind CSS','Learn how to create responsive user interfaces quickly and efficiently using the utility-first CSS framework, Tailwind CSS.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/8.png',2240,NULL,'2023-12-27 05:36:56','2024-10-20 21:49:02'),(6,'Why I Love Contributing to Open Source Projects','A deep dive into why open source matters to me, how it helped me grow as a developer, and why every developer should contribute to open source.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/4.png',1461,NULL,'2024-04-29 03:49:16','2024-10-20 21:49:02'),(7,'A Deep Dive into Laravel for Beginners','A comprehensive guide for beginners who want to learn Laravel, covering everything from installation to building a simple application.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/2.png',2370,NULL,'2024-06-28 00:46:23','2024-10-20 21:49:02'),(8,'Exploring the Benefits of MySQL for Large-Scale Projects','An exploration of why MySQL is a great choice for large-scale projects, highlighting features, scalability, and performance tips.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/12.png',1539,NULL,'2023-11-24 12:43:43','2024-10-20 21:49:02'),(9,'How to Integrate APIs in Node.js for Your Next Project','Learn how to seamlessly integrate third-party APIs in your Node.js applications for powerful data access and functionality.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/4.png',2312,NULL,'2023-11-03 13:07:32','2024-10-20 21:49:02'),(10,'Best Practices for Designing User-Friendly Websites','Discover the best practices for designing websites that are not only aesthetically pleasing but also user-friendly and accessible.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/6.png',2183,NULL,'2024-06-03 12:10:00','2024-10-20 21:49:02'),(11,'Lessons from My First Web Development Job','Reflecting on my first web development job, the lessons I learned, the challenges I faced, and how it shaped my career.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/3.png',2154,NULL,'2024-04-13 03:31:20','2024-10-20 21:49:02'),(12,'How to Contribute to Open Source: A Beginner’s Guide','A step-by-step guide on how beginners can start contributing to open source projects, with tips on finding the right project and making meaningful contributions.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/10.png',1482,NULL,'2024-09-11 08:54:21','2024-10-20 21:49:02'),(13,'Optimizing Web Performance with React.js','Learn how to optimize your React.js applications for better performance, focusing on code splitting, lazy loading, and efficient state management.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/2.png',2195,NULL,'2024-01-13 02:14:59','2024-10-20 21:49:02'),(14,'My Top 5 GitHub Projects','An overview of my top 5 GitHub projects, showcasing what I’ve built and how they’ve helped me grow as a developer.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',1,'main/posts/12.png',1098,NULL,'2024-10-04 17:39:12','2024-10-20 21:49:02'),(15,'Adapting to the New Web Development Trends in 2024','A look at the latest trends in web development for 2024, including new technologies, best practices, and what the future holds for developers.','
Prioritize User-Centric Design
\n
Understand Your Users
\n

Conduct thorough user research to understand your target audience’s needs, preferences, and pain points. Use surveys, interviews, and usability testing to gather valuable insights.

\n
Simplify Navigation
\n

Design a clean and intuitive navigation structure. Ensure users can easily find what they’re looking for without feeling overwhelmed. Use familiar icons and clear labels to guide them.

\n
Optimize Performance
\n
Fast Loading Times
\n

Optimize your app to load quickly. Users expect instant gratification, and slow load times can lead to frustration and app abandonment. Use efficient coding practices and minimize the use of heavy graphics.

\n
Smooth Animations
\n

Ensure animations and transitions are smooth and do not hinder the app’s performance. Well-executed animations can enhance the user experience by providing visual feedback and making interactions feel natural.

\n
Offline Access
\n

Provide offline capabilities for essential features. Allowing users to access certain functionalities without an internet connection can greatly improve their experience, especially in areas with poor connectivity.

\n
Ensure Robust Security
\n
Data Protection
\n

Implement strong security measures to protect user data. Use encryption, secure authentication methods, and regular security audits to safeguard sensitive information.

\n
Transparent Policies
\n

Be transparent about your data collection and usage policies. Provide users with clear information about how their data is used and give them control over their privacy settings.

\n
Regular Updates
\n

Keep your app updated with the latest security patches and improvements. Regular updates not only enhance security but also show users that you are actively maintaining and improving the app.

\n\n[highlighted-box title=\"Conclusion\" description=\"Creating a seamless mobile experience requires a user-centric approach, performance optimization, responsive design, user engagement strategies, and robust security measures. By focusing on these key areas, you can build a mobile app that not only meets user expectations but also stands out in the competitive app market. Remember, a great mobile experience can turn users into loyal advocates, driving the success of your app.\"][/highlighted-box]\n','published',1,'Botble\\ACL\\Models\\User',0,'main/posts/12.png',1566,NULL,'2024-04-07 07:07:07','2024-10-20 21:49:02'); /*!40000 ALTER TABLE `posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `posts_translations` -- DROP TABLE IF EXISTS `posts_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `posts_translations` -- LOCK TABLES `posts_translations` WRITE; /*!40000 ALTER TABLE `posts_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `posts_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `request_logs` -- DROP TABLE IF EXISTS `request_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `request_logs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `status_code` int DEFAULT NULL, `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `count` int unsigned NOT NULL DEFAULT '0', `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referrer` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `request_logs` -- LOCK TABLES `request_logs` WRITE; /*!40000 ALTER TABLE `request_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `request_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `revisions` -- DROP TABLE IF EXISTS `revisions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `revisions` -- LOCK TABLES `revisions` WRITE; /*!40000 ALTER TABLE `revisions` DISABLE KEYS */; /*!40000 ALTER TABLE `revisions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_users` -- DROP TABLE IF EXISTS `role_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_users` -- LOCK TABLES `role_users` WRITE; /*!40000 ALTER TABLE `role_users` DISABLE KEYS */; /*!40000 ALTER TABLE `role_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; 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,\"fob-comment.index\":true,\"fob-comment.comments.index\":true,\"fob-comment.comments.edit\":true,\"fob-comment.comments.destroy\":true,\"fob-comment.comments.reply\":true,\"fob-comment.settings\":true,\"languages.index\":true,\"languages.create\":true,\"languages.edit\":true,\"languages.destroy\":true,\"newsletter.index\":true,\"newsletter.destroy\":true,\"newsletter.settings\":true,\"plugins.portfolio\":true,\"portfolio.projects.index\":true,\"portfolio.projects.create\":true,\"portfolio.projects.edit\":true,\"portfolio.projects.destroy\":true,\"portfolio.service-categories.index\":true,\"portfolio.service-categories.create\":true,\"portfolio.service-categories.edit\":true,\"portfolio.service-categories.destroy\":true,\"portfolio.services.index\":true,\"portfolio.services.create\":true,\"portfolio.services.edit\":true,\"portfolio.services.destroy\":true,\"portfolio.packages.index\":true,\"portfolio.packages.create\":true,\"portfolio.packages.edit\":true,\"portfolio.packages.destroy\":true,\"portfolio.quotation-requests.index\":true,\"portfolio.quotation-requests.create\":true,\"portfolio.quotation-requests.edit\":true,\"portfolio.quotation-requests.destroy\":true,\"portfolio.custom-fields.index\":true,\"portfolio.custom-fields.create\":true,\"portfolio.custom-fields.edit\":true,\"portfolio.custom-fields.destroy\":true,\"request-log.index\":true,\"request-log.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,\"theme-translations.export\":true,\"other-translations.export\":true,\"theme-translations.import\":true,\"other-translations.import\":true}','Admin users role',1,1,1,'2024-10-20 21:49:01','2024-10-20 21:49:01'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'media_random_hash','0af8c70d53fdd4596723a02d084390e0',NULL,'2024-10-20 21:49:06'),(2,'api_enabled','0',NULL,'2024-10-20 21:49:06'),(3,'activated_plugins','[\"language\",\"language-advanced\",\"analytics\",\"audit-log\",\"backup\",\"blog\",\"captcha\",\"contact\",\"cookie-consent\",\"faq\",\"fob-comment\",\"newsletter\",\"portfolio\",\"request-log\",\"rss-feed\",\"testimonial\",\"translation\"]',NULL,'2024-10-20 21:49:06'),(4,'theme','zelio',NULL,'2024-10-20 21:49:06'),(5,'show_admin_bar','1',NULL,'2024-10-20 21:49:06'),(6,'language_hide_default','1',NULL,'2024-10-20 21:49:06'),(7,'language_switcher_display','dropdown',NULL,'2024-10-20 21:49:06'),(8,'language_display','all',NULL,'2024-10-20 21:49:06'),(9,'language_hide_languages','[]',NULL,'2024-10-20 21:49:06'),(10,'theme-zelio-favicon','main/general/favicon.png',NULL,NULL),(11,'theme-zelio-logo','main/general/favicon.png',NULL,NULL),(12,'theme-zelio-logo_dark','main/general/logo-dark.png',NULL,NULL),(13,'theme-zelio-site_title','Showcasing Creative Designs and Innovative Projects',NULL,NULL),(14,'theme-zelio-site_name','william.design',NULL,NULL),(15,'theme-zelio-seo_description','Discover innovative designs, creative projects, and unique artistic works. Showcasing the expertise and vision behind every creation.',NULL,NULL),(16,'theme-zelio-tp_primary_font','Urbanist',NULL,NULL),(17,'theme-zelio-primary_color','#6e4ef2',NULL,NULL),(18,'theme-zelio-gradient_color','#8c71ff',NULL,NULL),(19,'theme-zelio-homepage_id','1',NULL,NULL),(20,'theme-zelio-social_links','[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\"}],[{\"key\":\"name\",\"value\":\"X (Twitter)\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/x.com\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-linkedin\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.linkedin.com\"}]]',NULL,NULL),(21,'theme-zelio-copyright','© %Y All Rights Reserved by botble.com.',NULL,NULL),(22,'theme-zelio-preloader_enabled','yes',NULL,NULL),(23,'theme-zelio-preloader_version','v2',NULL,NULL),(24,'theme-zelio-footer_background','main/general/footer-bg.png',NULL,NULL),(25,'theme-zelio-header_style','1',NULL,NULL),(26,'theme-zelio-footer_style','1',NULL,NULL),(27,'theme-zelio-preloader_style','1',NULL,NULL),(28,'theme-zelio-blog_page_id','5',NULL,NULL),(29,'theme-zelio-post_item_style','1',NULL,NULL),(30,'theme-zelio-post_item_per_row','3',NULL,NULL),(31,'theme-zelio-cookie_consent_learn_more_url','/cookie-policy',NULL,NULL),(32,'theme-zelio-cookie_consent_learn_more_text','Cookie Policy',NULL,NULL); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `slugs` -- DROP TABLE IF EXISTS `slugs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `slugs` -- LOCK TABLES `slugs` WRITE; /*!40000 ALTER TABLE `slugs` DISABLE KEYS */; INSERT INTO `slugs` VALUES (1,'web-development',1,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(2,'open-source-contributions',2,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(3,'tutorials',3,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(4,'technology-reviews',4,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(5,'personal-blog',5,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(6,'career-journey',6,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(7,'coding-challenges',7,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(8,'design-portfolio',8,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(9,'collaborations',9,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(10,'botble-cms',1,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(11,'javascript',2,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(12,'open-source',3,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(13,'web-design',4,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(14,'api-development',5,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(15,'full-stack-development',6,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(16,'vietnam-developer',7,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(17,'github-projects',8,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:02','2024-10-20 21:49:02'),(18,'building-a-full-stack-app-with-the-tall-stack',1,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(19,'my-journey-in-open-source-3-years-of-contributions',2,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(20,'5-essential-tools-for-web-developers-in-2024',3,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(21,'how-i-built-my-personal-portfolio-using-botble-cms',4,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(22,'creating-responsive-uis-with-tailwind-css',5,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(23,'why-i-love-contributing-to-open-source-projects',6,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(24,'a-deep-dive-into-laravel-for-beginners',7,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(25,'exploring-the-benefits-of-mysql-for-large-scale-projects',8,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(26,'how-to-integrate-apis-in-nodejs-for-your-next-project',9,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(27,'best-practices-for-designing-user-friendly-websites',10,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(28,'lessons-from-my-first-web-development-job',11,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(29,'how-to-contribute-to-open-source-a-beginners-guide',12,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(30,'optimizing-web-performance-with-reactjs',13,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(31,'my-top-5-github-projects',14,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(32,'adapting-to-the-new-web-development-trends-in-2024',15,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:02','2024-10-20 21:49:02'),(33,'web-development',1,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:03','2024-10-20 21:49:03'),(34,'uiux-design',2,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:03','2024-10-20 21:49:03'),(35,'seo-optimization',3,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:03','2024-10-20 21:49:03'),(36,'content-creation',4,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:03','2024-10-20 21:49:03'),(37,'e-commerce-website',1,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:03','2024-10-20 21:49:03'),(38,'mobile-app-design',2,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:03','2024-10-20 21:49:03'),(39,'portfolio-website',3,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:03','2024-10-20 21:49:03'),(40,'seo-and-marketing-campaign',4,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:03','2024-10-20 21:49:03'),(41,'home',1,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(42,'services',2,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(43,'projects',3,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(44,'pricing',4,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(45,'blog',5,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(46,'contact',6,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'),(47,'cookie-policy',7,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:05','2024-10-20 21:49:05'); /*!40000 ALTER TABLE `slugs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `slugs_translations` -- DROP TABLE IF EXISTS `slugs_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `slugs_translations` -- LOCK TABLES `slugs_translations` WRITE; /*!40000 ALTER TABLE `slugs_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `slugs_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tags` -- LOCK TABLES `tags` WRITE; /*!40000 ALTER TABLE `tags` DISABLE KEYS */; INSERT INTO `tags` VALUES (1,'Botble CMS',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(2,'JavaScript',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(3,'Open Source',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(4,'Web Design',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(5,'API Development',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(6,'Full Stack Development',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(7,'Vietnam Developer',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(8,'GitHub Projects',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:02','2024-10-20 21:49:02'); /*!40000 ALTER TABLE `tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tags_translations` -- DROP TABLE IF EXISTS `tags_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tags_translations` -- LOCK TABLES `tags_translations` WRITE; /*!40000 ALTER TABLE `tags_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `tags_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials` -- LOCK TABLES `testimonials` WRITE; /*!40000 ALTER TABLE `testimonials` DISABLE KEYS */; INSERT INTO `testimonials` VALUES (1,'Jennifer Lee','Working with this team was an absolute pleasure. Their attention to detail, professionalism, and understanding of my needs made the entire home buying process stress-free and enjoyable.','main/avatars/2.png','Happy Home Seeker','published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(2,'Robert Evans','The guidance and insights provided by this team were invaluable in helping me secure profitable investments. Their market knowledge and dedication to client success are unmatched.','main/avatars/2.png','Property Investor','published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(3,'Jessica White','I couldn’t have asked for a smoother selling experience. Their expert advice, flawless staging, and negotiation skills resulted in a quick sale at a great price. Truly impressive!','main/avatars/1.png','Delighted Home Seller','published','2024-10-20 21:49:02','2024-10-20 21:49:02'),(4,'Daniel Miller','From start to finish, the home buying experience was handled with care and professionalism. The team listened to all my concerns and helped me find the perfect home in no time.','main/avatars/1.png','Happy New Homeowner','published','2024-10-20 21:49:02','2024-10-20 21:49:02'); /*!40000 ALTER TABLE `testimonials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials_translations` -- DROP TABLE IF EXISTS `testimonials_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials_translations` -- LOCK TABLES `testimonials_translations` WRITE; /*!40000 ALTER TABLE `testimonials_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `testimonials_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_meta` -- DROP TABLE IF EXISTS `user_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_meta` -- LOCK TABLES `user_meta` WRITE; /*!40000 ALTER TABLE `user_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `user_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'dianna.gorczany@keeling.info',NULL,'$2y$12$S75Jp2DfStXG6wR9R7FxJO8qFITrvmMh1Ht.b6m6ddXr.bQBYtCGu',NULL,'2024-10-20 21:49:01','2024-10-20 21:49:01','Sadye','Kunde','admin',NULL,1,1,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `widgets` -- DROP TABLE IF EXISTS `widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `widgets` -- LOCK TABLES `widgets` WRITE; /*!40000 ALTER TABLE `widgets` DISABLE KEYS */; INSERT INTO `widgets` VALUES (1,'ContactInformationWidget','sidebar_panel_sidebar','zelio',1,'{\"bio\":\"I\'m always excited to take on new projects and collaborate with innovative minds.\",\"details\":{\"Phone\":[{\"key\":\"label\",\"value\":\"Phone\"},{\"key\":\"value\",\"value\":\"+1 234 567 890\"}],\"Email\":[{\"key\":\"label\",\"value\":\"Email\"},{\"key\":\"value\",\"value\":\"contact@botble.com\"}],\"Website\":[{\"key\":\"label\",\"value\":\"Website\"},{\"key\":\"value\",\"value\":\"https:\\/\\/botble.com\"}],\"Address\":[{\"key\":\"label\",\"value\":\"Address\"},{\"key\":\"value\",\"value\":\"123 Main Street, New York, NY 10001\"}]}}','2024-10-20 21:49:06','2024-10-20 21:49:06'),(2,'SocialLinkWidget','sidebar_panel_sidebar','zelio',2,'{\"name\":\"Social\"}','2024-10-20 21:49:06','2024-10-20 21:49:06'),(3,'LanguageSwitcherWidget','sidebar_panel_sidebar','zelio',3,'[]','2024-10-20 21:49:06','2024-10-20 21:49:06'),(4,'SiteLogoWidget','footer_sidebar','zelio',1,'[]','2024-10-20 21:49:06','2024-10-20 21:49:06'),(5,'Botble\\Widget\\Widgets\\CoreSimpleMenu','footer_sidebar','zelio',2,'{\"id\":\"Botble\\\\Widget\\\\Widgets\\\\CoreSimpleMenu\",\"items\":[[{\"key\":\"label\",\"value\":\"Home\"},{\"key\":\"url\",\"value\":\"http:\\/\\/zelio.test\\/home\"}],[{\"key\":\"label\",\"value\":\"Services\"},{\"key\":\"url\",\"value\":\"http:\\/\\/zelio.test\\/services\"}],[{\"key\":\"label\",\"value\":\"Pricing\"},{\"key\":\"url\",\"value\":\"http:\\/\\/zelio.test\\/pricing\"}],[{\"key\":\"label\",\"value\":\"Blog\"},{\"key\":\"url\",\"value\":\"http:\\/\\/zelio.test\\/blog\"}],[{\"key\":\"label\",\"value\":\"Contact\"},{\"key\":\"url\",\"value\":\"http:\\/\\/zelio.test\\/contact\"}]]}','2024-10-20 21:49:06','2024-10-20 21:49:06'),(6,'SiteCopyrightWidget','footer_sidebar','zelio',3,'[]','2024-10-20 21:49:06','2024-10-20 21:49:06'); /*!40000 ALTER TABLE `widgets` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-10-21 11:49:06