-- 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,'nZ62a4XeaIY14NfoAeLGfP0RTgHvPrJ3',1,'2024-10-20 21:49:14','2024-10-20 21:49:14','2024-10-20 21:49:14'); /*!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,'Est quasi optio qui omnis omnis fuga harum. Rem voluptas doloribus autem sequi nam. Exercitationem ipsa harum aut. Rerum qui est libero aut optio.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(2,'Open Source Contributions',0,'Et dolores et id. Aut inventore velit nesciunt natus magnam officia. Labore cupiditate sint cumque minima.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(3,'Tutorials',0,'Nobis vel amet dolor et et sunt. Ea delectus ipsum qui quia. Provident aut non unde nihil vel ratione voluptatem cumque.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(4,'Technology Reviews',0,'Voluptatem est aut ipsam omnis velit enim. Dignissimos excepturi aut dolorem at sequi inventore qui. Commodi voluptatem labore est sit aut vero.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(5,'Personal Blog',0,'Dolore nisi facilis laudantium ut. Error ea eos nobis odit a assumenda quae ducimus. Unde eligendi odit maiores voluptas iste. Sed fuga aliquid exercitationem sequi ex architecto quisquam.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(6,'Career Journey',0,'Laudantium delectus et eveniet dolorum. Illo magnam qui sit cumque. Magni occaecati et iste distinctio est. Dicta doloremque consequatur quae dolorem dolores.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(7,'Coding Challenges',0,'Rerum sequi et id qui doloribus. Voluptatem et illum magni qui magnam incidunt. Eligendi tempore consequuntur est culpa eaque. Consequuntur facere ea velit qui.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(8,'Design Portfolio',0,'Ut voluptate adipisci praesentium et cupiditate nemo exercitationem. Dolor qui totam deserunt sed nihil eligendi hic recusandae. Eos et cupiditate sed commodi.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'),(9,'Collaborations',0,'Repudiandae quasi vel et molestiae rem aut quos. Consectetur laboriosam enim qui velit.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-10-20 21:49:15','2024-10-20 21:49:15'); /*!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:16','2024-10-20 21:49:16',NULL),(2,'Cost and Billing',1,'published','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL),(3,'Follow-Up Support',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16',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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',3,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',1,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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.',3,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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.',3,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',3,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'),(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.',3,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(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.',2,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'); /*!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',2,'http://zelio.test','Paula Larson PhD','elbert.mcclure@stehr.org','https://friendsofbotble.com','This is really helpful, thank you!','approved','81.181.132.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/5340 (KHTML, like Gecko) Chrome/37.0.845.0 Mobile Safari/5340','2024-10-09 12:31:13','2024-10-20 21:49:17'),(2,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',12,'http://zelio.test','Linnea Mayer DVM','spencer.andres@oconnell.com','https://friendsofbotble.com','I found this article to be quite informative.','approved','255.113.171.115','Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_5_7) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/99.0.4544.37 Safari/532.0 Edg/99.01066.45','2024-10-02 21:19:48','2024-10-20 21:49:17'),(3,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Lindsey Fadel','alessandra50@gmail.com','https://friendsofbotble.com','Wow, I never knew about this before!','approved','44.250.125.198','Mozilla/5.0 (compatible; MSIE 6.0; Windows 95; Trident/3.0)','2024-09-22 12:05:06','2024-10-20 21:49:17'),(4,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Sigrid Weimann','kbreitenberg@rosenbaum.com','https://friendsofbotble.com','Great job on explaining such a complex topic.','approved','210.53.230.155','Mozilla/5.0 (Windows; U; Windows NT 4.0) AppleWebKit/534.39.6 (KHTML, like Gecko) Version/5.0.3 Safari/534.39.6','2024-10-13 12:46:13','2024-10-20 21:49:17'),(5,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Prof. Theodora Haag','runte.gail@hotmail.com','https://friendsofbotble.com','I have a question about the third paragraph.','approved','43.186.116.129','Opera/9.81 (Windows NT 6.1; sl-SI) Presto/2.10.295 Version/11.00','2024-09-22 02:00:50','2024-10-20 21:49:17'),(6,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Ms. Kenyatta Walter Sr.','uheller@gottlieb.info','https://friendsofbotble.com','This article changed my perspective entirely.','approved','122.157.123.178','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_2 rv:2.0; nl-NL) AppleWebKit/535.19.2 (KHTML, like Gecko) Version/5.0 Safari/535.19.2','2024-10-04 22:51:00','2024-10-20 21:49:17'),(7,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Clement Nicolas','nitzsche.solon@bernhard.com','https://friendsofbotble.com','I appreciate the effort you put into this.','approved','130.189.128.85','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_8 rv:4.0) Gecko/20201230 Firefox/36.0','2024-10-02 10:44:02','2024-10-20 21:49:17'),(8,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Ms. Kenyatta Ebert MD','kendall.gerlach@yahoo.com','https://friendsofbotble.com','This is exactly what I was looking for, thank you!','approved','109.248.251.251','Opera/8.21 (Windows CE; sl-SI) Presto/2.9.253 Version/12.00','2024-10-13 22:10:43','2024-10-20 21:49:17'),(9,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Prof. Paul Rogahn I','gleason.alfred@hotmail.com','https://friendsofbotble.com','I disagree with some points mentioned here, though.','approved','208.125.196.208','Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/79.0.4116.21 Safari/535.2 EdgA/79.01092.25','2024-10-08 04:22:01','2024-10-20 21:49:17'),(10,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',14,'http://zelio.test','Stan Hoppe Jr.','karelle84@goyette.com','https://friendsofbotble.com','Could you provide more examples to illustrate your point?','approved','35.230.66.17','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/533.1 (KHTML, like Gecko) Chrome/99.0.4186.45 Safari/533.1 Edg/99.01058.55','2024-09-23 16:53:42','2024-10-20 21:49:17'),(11,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Godfrey Lehner PhD','iliana94@hessel.biz','https://friendsofbotble.com','I wish there were more articles like this out there.','approved','216.234.177.152','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_9 rv:3.0; sl-SI) AppleWebKit/534.9.3 (KHTML, like Gecko) Version/4.0 Safari/534.9.3','2024-10-15 11:58:23','2024-10-20 21:49:17'),(12,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Drake Roob','flatley.lydia@hotmail.com','https://friendsofbotble.com','I\'m bookmarking this for future reference.','approved','255.193.108.223','Mozilla/5.0 (iPad; CPU OS 8_0_2 like Mac OS X; nl-NL) AppleWebKit/533.37.2 (KHTML, like Gecko) Version/4.0.5 Mobile/8B118 Safari/6533.37.2','2024-10-13 00:01:47','2024-10-20 21:49:17'),(13,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Conner Dicki','upton.hortense@dach.biz','https://friendsofbotble.com','I\'ve shared this with my friends, they loved it!','approved','183.238.121.147','Opera/8.53 (X11; Linux i686; sl-SI) Presto/2.12.307 Version/12.00','2024-09-29 13:24:08','2024-10-20 21:49:17'),(14,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Prof. Joanny Greenfelder PhD','jakubowski.rod@mertz.info','https://friendsofbotble.com','This article is a must-read for everyone interested in the topic.','approved','86.249.252.150','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_4) AppleWebKit/5320 (KHTML, like Gecko) Chrome/40.0.816.0 Mobile Safari/5320','2024-10-06 00:26:15','2024-10-20 21:49:17'),(15,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',2,'http://zelio.test','Genesis Conroy','kaela59@hammes.biz','https://friendsofbotble.com','Thank you for shedding light on this important issue.','approved','4.77.187.21','Mozilla/5.0 (compatible; MSIE 11.0; Windows NT 5.01; Trident/3.1)','2024-10-19 21:42:54','2024-10-20 21:49:17'),(16,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',12,'http://zelio.test','Lila Hane Sr.','douglas.garfield@hotmail.com','https://friendsofbotble.com','I\'ve been searching for information on this topic, glad I found this article.','approved','231.56.145.117','Mozilla/5.0 (compatible; MSIE 5.0; Windows NT 5.01; Trident/3.1)','2024-10-19 07:19:29','2024-10-20 21:49:17'),(17,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Horace Robel III','zachariah.abshire@grady.com','https://friendsofbotble.com','I\'m blown away by the insights shared in this article.','approved','107.217.249.204','Mozilla/5.0 (Windows; U; Windows NT 4.0) AppleWebKit/534.25.5 (KHTML, like Gecko) Version/4.0.4 Safari/534.25.5','2024-09-21 14:08:27','2024-10-20 21:49:17'),(18,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Makenna Huel','nellie31@johnston.com','https://friendsofbotble.com','This article tackles a complex topic with clarity.','approved','199.61.74.37','Mozilla/5.0 (Windows; U; Windows NT 5.2) AppleWebKit/532.17.5 (KHTML, like Gecko) Version/4.0 Safari/532.17.5','2024-10-17 17:17:55','2024-10-20 21:49:17'),(19,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',2,'http://zelio.test','Henri Corkery','elockman@bahringer.com','https://friendsofbotble.com','I\'m going to reflect on the ideas presented in this article.','approved','221.199.105.230','Mozilla/5.0 (Windows CE; sl-SI; rv:1.9.0.20) Gecko/20240729 Firefox/35.0','2024-10-10 18:17:38','2024-10-20 21:49:17'),(20,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Dr. Christina Hoppe DVM','vstehr@reichel.net','https://friendsofbotble.com','The author\'s passion for the subject shines through in this article.','approved','126.33.85.23','Mozilla/5.0 (Windows 95) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/89.0.4627.90 Safari/535.1 Edg/89.01098.22','2024-10-20 07:37:01','2024-10-20 21:49:17'),(21,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Mckenzie Emard','layne.mcdermott@gmail.com','https://friendsofbotble.com','This article challenged my preconceptions in a thought-provoking way.','approved','91.62.231.225','Mozilla/5.0 (Windows 95) AppleWebKit/5330 (KHTML, like Gecko) Chrome/38.0.863.0 Mobile Safari/5330','2024-10-13 13:55:54','2024-10-20 21:49:17'),(22,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Francesco Wisozk','jacobi.saige@yahoo.com','https://friendsofbotble.com','I\'ve added this article to my reading list, it\'s worth revisiting.','approved','44.48.244.181','Mozilla/5.0 (compatible; MSIE 11.0; Windows NT 4.0; Trident/3.1)','2024-10-01 14:56:14','2024-10-20 21:49:17'),(23,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',6,'http://zelio.test','Martine Kassulke V','damaris19@ankunding.info','https://friendsofbotble.com','This article offers practical advice that I can apply in real life.','approved','159.27.246.232','Mozilla/5.0 (Windows; U; Windows 98) AppleWebKit/535.19.2 (KHTML, like Gecko) Version/5.1 Safari/535.19.2','2024-10-03 01:19:30','2024-10-20 21:49:17'),(24,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Vergie Hills','kautzer.bessie@turner.info','https://friendsofbotble.com','I\'m going to recommend this article to my study group.','approved','235.11.24.173','Opera/8.83 (X11; Linux x86_64; sl-SI) Presto/2.10.292 Version/10.00','2024-10-16 02:44:26','2024-10-20 21:49:17'),(25,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Dr. Marley Cronin','pagac.sister@schmitt.com','https://friendsofbotble.com','The examples provided really helped me understand the concept better.','approved','223.255.124.176','Mozilla/5.0 (Windows 98; en-US; rv:1.9.0.20) Gecko/20221018 Firefox/35.0','2024-10-14 02:59:54','2024-10-20 21:49:17'),(26,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',6,'http://zelio.test','Odie Leannon II','dbauch@yahoo.com','https://friendsofbotble.com','I resonate with the ideas presented here.','approved','129.58.32.104','Mozilla/5.0 (iPhone; CPU iPhone OS 14_1 like Mac OS X) AppleWebKit/533.0 (KHTML, like Gecko) Version/15.0 EdgiOS/87.01139.97 Mobile/15E148 Safari/533.0','2024-10-03 21:10:57','2024-10-20 21:49:17'),(27,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Stuart Ebert','schaefer.nestor@blanda.info','https://friendsofbotble.com','This article made me think critically about the topic.','approved','37.232.236.95','Opera/9.60 (Windows NT 5.2; nl-NL) Presto/2.8.204 Version/11.00','2024-09-29 09:39:37','2024-10-20 21:49:17'),(28,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Billie Hammes PhD','ashley.bergstrom@bechtelar.net','https://friendsofbotble.com','I\'ll definitely come back to this article for reference.','approved','161.123.122.152','Mozilla/5.0 (Windows; U; Windows 98) AppleWebKit/531.23.6 (KHTML, like Gecko) Version/4.0.4 Safari/531.23.6','2024-10-01 07:17:39','2024-10-20 21:49:17'),(29,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Dr. Clare Schaden II','ddooley@ritchie.com','https://friendsofbotble.com','I\'ve shared this on social media, it\'s too good not to share.','approved','129.81.54.183','Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) AppleWebKit/535.1 (KHTML, like Gecko) Version/15.0 EdgiOS/79.01076.75 Mobile/15E148 Safari/535.1','2024-09-23 16:22:25','2024-10-20 21:49:17'),(30,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Mrs. Sonya Funk','sherzog@fahey.com','https://friendsofbotble.com','This article presents a balanced view on a controversial topic.','approved','55.192.52.195','Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/5.1)','2024-10-08 04:02:43','2024-10-20 21:49:17'),(31,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',13,'http://zelio.test','Brent Welch','mable05@gmail.com','https://friendsofbotble.com','I\'m glad I stumbled upon this article, it\'s a gem.','approved','62.85.0.125','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8) AppleWebKit/5321 (KHTML, like Gecko) Chrome/37.0.812.0 Mobile Safari/5321','2024-09-27 15:39:40','2024-10-20 21:49:17'),(32,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',2,'http://zelio.test','Sallie Sipes','gankunding@deckow.com','https://friendsofbotble.com','I\'ve been struggling with this, your article helped a lot.','approved','4.200.230.124','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.2 (KHTML, like Gecko) Chrome/83.0.4818.99 Safari/536.2 EdgA/83.01024.35','2024-09-30 15:03:11','2024-10-20 21:49:17'),(33,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',10,'http://zelio.test','Mr. Coby Morar','roosevelt58@sipes.info','https://friendsofbotble.com','I\'ve learned something new today, thanks to this article.','approved','241.29.219.84','Mozilla/5.0 (X11; Linux x86_64; rv:5.0) Gecko/20150915 Firefox/36.0','2024-10-16 16:02:48','2024-10-20 21:49:17'),(34,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',5,'http://zelio.test','Crystel Lemke','camryn57@marquardt.com','https://friendsofbotble.com','Kudos to the author for a well-researched piece.','approved','167.53.150.14','Opera/9.96 (X11; Linux i686; en-US) Presto/2.12.270 Version/12.00','2024-10-03 12:45:18','2024-10-20 21:49:17'),(35,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Dr. Aliya Volkman Sr.','opollich@boyer.com','https://friendsofbotble.com','I\'m impressed by the depth of knowledge demonstrated here.','approved','150.161.29.36','Mozilla/5.0 (X11; Linux x86_64; rv:5.0) Gecko/20131128 Firefox/37.0','2024-09-25 21:59:26','2024-10-20 21:49:17'),(36,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',8,'http://zelio.test','Celine McKenzie PhD','skiles.manuel@gmail.com','https://friendsofbotble.com','This article challenged my assumptions in a good way.','approved','221.123.7.87','Opera/9.93 (X11; Linux i686; sl-SI) Presto/2.11.278 Version/12.00','2024-10-12 22:34:50','2024-10-20 21:49:17'),(37,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',9,'http://zelio.test','Miss Tamia Gusikowski','trowe@corwin.com','https://friendsofbotble.com','I\'ve shared this with my colleagues, it\'s worth discussing.','approved','10.96.75.65','Mozilla/5.0 (Windows NT 6.0) AppleWebKit/533.1 (KHTML, like Gecko) Chrome/90.0.4083.88 Safari/533.1 Edg/90.01105.52','2024-10-13 01:02:55','2024-10-20 21:49:17'),(38,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Dr. Ted Boyle DDS','cordelia.lemke@yahoo.com','https://friendsofbotble.com','The information presented here is very valuable.','approved','59.171.132.234','Mozilla/5.0 (Windows NT 5.2; sl-SI; rv:1.9.2.20) Gecko/20110514 Firefox/36.0','2024-10-01 23:48:26','2024-10-20 21:49:17'),(39,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',14,'http://zelio.test','Jean Brown Sr.','uschmidt@zboncak.com','https://friendsofbotble.com','You have a talent for explaining complex topics clearly.','approved','253.44.68.20','Mozilla/5.0 (X11; Linux i686) AppleWebKit/5351 (KHTML, like Gecko) Chrome/40.0.817.0 Mobile Safari/5351','2024-10-08 21:09:33','2024-10-20 21:49:17'),(40,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Erin Ankunding','amalia85@nolan.net','https://friendsofbotble.com','I\'m inspired to learn more about this after reading your article.','approved','231.193.52.114','Mozilla/5.0 (iPhone; CPU iPhone OS 15_2 like Mac OS X) AppleWebKit/536.1 (KHTML, like Gecko) Version/15.0 EdgiOS/84.01014.58 Mobile/15E148 Safari/536.1','2024-10-14 17:49:29','2024-10-20 21:49:17'),(41,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Mr. Devan Dibbert','ardella95@gmail.com','https://friendsofbotble.com','This article deserves wider recognition.','approved','222.161.179.217','Mozilla/5.0 (compatible; MSIE 8.0; Windows NT 6.2; Trident/3.0)','2024-10-08 22:33:51','2024-10-20 21:49:17'),(42,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',7,'http://zelio.test','Ms. Kathleen Kutch','ortiz.branson@trantow.com','https://friendsofbotble.com','I\'m grateful for the insights shared in this piece.','approved','28.45.245.100','Opera/8.13 (X11; Linux x86_64; nl-NL) Presto/2.10.344 Version/10.00','2024-09-24 21:03:57','2024-10-20 21:49:17'),(43,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',6,'http://zelio.test','Rozella Leffler','conrad81@yahoo.com','https://friendsofbotble.com','The author presents a balanced view on a controversial topic.','approved','70.35.127.112','Opera/9.56 (Windows CE; en-US) Presto/2.10.333 Version/12.00','2024-10-10 05:39:16','2024-10-20 21:49:17'),(44,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',6,'http://zelio.test','Guido Conn','sporer.german@sauer.com','https://friendsofbotble.com','I\'m glad I stumbled upon this article, it\'s','approved','200.85.15.84','Mozilla/5.0 (Windows 98; nl-NL; rv:1.9.0.20) Gecko/20240226 Firefox/36.0','2024-09-27 20:02:36','2024-10-20 21:49:17'),(45,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',4,'http://zelio.test','Ms. Izabella Windler II','blanche.bogan@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','206.239.234.48','Mozilla/5.0 (iPhone; CPU iPhone OS 8_0_2 like Mac OS X; nl-NL) AppleWebKit/532.16.2 (KHTML, like Gecko) Version/4.0.5 Mobile/8B116 Safari/6532.16.2','2024-09-25 10:12:40','2024-10-20 21:49:17'),(46,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',15,'http://zelio.test','Miss Burnice Wisozk II','reva41@gmail.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','57.167.85.134','Opera/8.39 (X11; Linux x86_64; nl-NL) Presto/2.12.274 Version/12.00','2024-09-27 08:48:38','2024-10-20 21:49:17'),(47,NULL,NULL,NULL,'Botble\\Blog\\Models\\Post',1,'http://zelio.test','Lyla Spinka','spinka.jedediah@gmail.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','249.68.168.107','Opera/8.79 (X11; Linux i686; en-US) Presto/2.9.289 Version/11.00','2024-09-27 19:50:42','2024-10-20 21:49:17'); /*!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','77ced85a6540a7e122b7b368299eed62',1,'Botble\\Menu\\Models\\MenuLocation'),(2,'en_US','2ef293a1c64ac076ad3af742f964bcf7',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=30 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,'avatar','avatar',2,'image/png',4436,'write/general/avatar.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(2,0,'favicon','favicon',2,'image/png',3465,'write/general/favicon.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(3,0,'signature','signature',2,'image/png',5289,'write/general/signature.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(4,0,'1','1',4,'image/png',9448,'main/posts/1.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(5,0,'10','10',4,'image/png',9448,'main/posts/10.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(6,0,'11','11',4,'image/png',9448,'main/posts/11.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(7,0,'12','12',4,'image/png',9448,'main/posts/12.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(8,0,'2','2',4,'image/png',9448,'main/posts/2.png','[]','2024-10-20 21:49:14','2024-10-20 21:49:14',NULL,'public'),(9,0,'3','3',4,'image/png',9448,'main/posts/3.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(10,0,'4','4',4,'image/png',9448,'main/posts/4.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(11,0,'5','5',4,'image/png',9448,'main/posts/5.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(12,0,'6','6',4,'image/png',9448,'main/posts/6.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(13,0,'7','7',4,'image/png',9448,'main/posts/7.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(14,0,'8','8',4,'image/png',9448,'main/posts/8.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(15,0,'9','9',4,'image/png',9448,'main/posts/9.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(16,0,'background','background',4,'image/png',9448,'main/posts/background.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(17,0,'1','1',5,'image/png',2100,'main/avatars/1.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(18,0,'2','2',5,'image/png',2100,'main/avatars/2.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(19,0,'man','man',5,'image/png',2100,'main/avatars/man.png','[]','2024-10-20 21:49:15','2024-10-20 21:49:15',NULL,'public'),(20,0,'1','1',6,'image/png',9448,'main/projects/1.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(21,0,'2','2',6,'image/png',9448,'main/projects/2.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(22,0,'3','3',6,'image/png',9448,'main/projects/3.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(23,0,'4','4',6,'image/png',9448,'main/projects/4.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(24,0,'1','1',7,'image/png',85636,'write/projects/1.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(25,0,'2','2',7,'image/png',146922,'write/projects/2.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(26,0,'3','3',7,'image/png',133396,'write/projects/3.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(27,0,'1','1',8,'image/png',4346,'write/education/1.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(28,0,'2','2',8,'image/png',4501,'write/education/2.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'public'),(29,0,'3','3',8,'image/png',3824,'write/education/3.png','[]','2024-10-20 21:49:16','2024-10-20 21:49:16',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=9 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,'write',NULL,'write',0,'2024-10-20 21:49:14','2024-10-20 21:49:14',NULL),(2,0,'general',NULL,'general',1,'2024-10-20 21:49:14','2024-10-20 21:49:14',NULL),(3,0,'main',NULL,'main',0,'2024-10-20 21:49:14','2024-10-20 21:49:14',NULL),(4,0,'posts',NULL,'posts',3,'2024-10-20 21:49:14','2024-10-20 21:49:14',NULL),(5,0,'avatars',NULL,'avatars',3,'2024-10-20 21:49:15','2024-10-20 21:49:15',NULL),(6,0,'projects',NULL,'projects',3,'2024-10-20 21:49:16','2024-10-20 21:49:16',NULL),(7,0,'projects',NULL,'projects',1,'2024-10-20 21:49:16','2024-10-20 21:49:16',NULL),(8,0,'education',NULL,'education',1,'2024-10-20 21:49:16','2024-10-20 21:49:16',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:17','2024-10-20 21:49:17'); /*!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:17','2024-10-20 21:49:17'),(2,1,1,NULL,NULL,'https://zelio.botble.com',NULL,0,'Home 1 - Designer',NULL,'_blank',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(3,1,1,NULL,NULL,'https://zelio-developer.botble.com',NULL,0,'Home 2 - Developer',NULL,'_blank',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(4,1,1,NULL,NULL,'https://zelio-writer.botble.com',NULL,0,'Home 3 - Writer',NULL,'_blank',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(5,1,0,2,'Botble\\Page\\Models\\Page','/services',NULL,0,'Services',NULL,'_self',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(6,1,0,3,'Botble\\Page\\Models\\Page','/projects',NULL,0,'Portfolio',NULL,'_self',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(7,1,0,4,'Botble\\Page\\Models\\Page','/pricing',NULL,0,'Pricing',NULL,'_self',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(8,1,0,5,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog',NULL,'_self',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'),(9,1,0,6,'Botble\\Page\\Models\\Page','/contact',NULL,0,'Contact',NULL,'_self',0,'2024-10-20 21:49:17','2024-10-20 21:49:17'); /*!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:17','2024-10-20 21:49:17'); /*!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 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 */; /*!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="3" title="Crafting Stories <span class='text-dark'>with Passion: Discover the Work</span> of Meisa" subtitle="Shaping Narratives, Igniting Minds" description="Welcome to the creative world of Meisa Rosie, where words are crafted into captivating stories and insightful content. Explore her journey as an award-winning writer and discover how she brings imagination to life through her unique voice and compelling narratives." primary_button_text="Download My 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" enable_lazy_loading="no"][/hero-banner]\n[projects style="3" title="Typical Works" project_ids="1,2,3" enable_lazy_loading="no"][/projects]\n[services style="3" title="My Services" service_ids="1,4,2,3" enable_lazy_loading="yes"][/services]\n[resume style="3" resume_1_title="Education" resume_1_display_type="default" resume_1_quantity="3" resume_1_time_1="2023 - 2024" resume_1_title_1="Certificates in Digital Content and SEO Writing" resume_1_subtitle_1="CM Institute" resume_1_image_1="write/education/1.png" resume_1_time_2="2019 - 2021" resume_1_title_2="Writing Workshops and Continuing Education" resume_1_subtitle_2="University of Iowa" resume_1_image_2="write/education/2.png" resume_1_time_3="2016 - 2018" resume_1_title_3="Bachelor of Arts in English Literature" resume_1_subtitle_3="Bachelor of Arts" resume_1_image_3="write/education/3.png" resume_2_title="Awards" resume_2_display_type="timeline" resume_2_quantity="3" resume_2_time_1="2018 - 2020" resume_2_title_1="Columnist for The New Yorker" resume_2_subtitle_1="NY Times" resume_2_description_1="Worked with various clients, including magazines, websites, and publishing houses, to produce high-quality content across multiple genres." resume_2_time_2="2016 - 2018" resume_2_title_2="Content Writer at GitHub" resume_2_subtitle_2="GitHub" resume_2_description_2="Created engaging articles, blog posts, and features for one of the leading literary websites." resume_2_time_3="2014 - 2016" resume_2_title_3="Editor at The Write Stuff" resume_2_subtitle_3="A.Lecturer" resume_2_description_3="Overseeing the editorial process, providing guidance, and ensuring the highest standards of content."][/resume]\n[blog-posts style="3" title="From Blog" enable_lazy_loading="yes"][/blog-posts]\n[testimonials style="2" title="Testimonials" testimonial_ids="1,2,3,4" enable_lazy_loading="yes"][/testimonials]\n[contact-form style="3" 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,'sidebar',NULL,'published','2024-10-20 21:49:17','2024-10-20 21:49:17'),(2,'Services','[services style="3" 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:17','2024-10-20 21:49:17'),(3,'Projects','[projects style="3" 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:17','2024-10-20 21:49:17'),(4,'Pricing','[pricing-plans package_ids="1,2" enable_lazy_loading="no"][/pricing-plans]\n[faqs title="Common Questions" category_ids="3" 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:17','2024-10-20 21:49:17'),(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:17','2024-10-20 21:49:17'),(6,'Contact','[contact-form style="3" 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,'sidebar',NULL,'published','2024-10-20 21:49:17','2024-10-20 21:49:17'),(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:17','2024-10-20 21:49:17'); /*!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:16','2024-10-20 21:49:16'),(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:16','2024-10-20 21:49:16'); /*!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=4 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,'Novels: Echoes of the Past','Set in a dystopian future, \"Reflections of Tomorrow\" is a thought-provoking novel that explores themes of identity, freedom, and resilience. Through its compelling storyline and well-drawn characters, the book invites readers to ponder the ethical dilemmas of technological advancement and societal change.','
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,'Corporate Client',0,'main/projects/1.png',NULL,7410,'published','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'2023-06-01'),(2,'Whispers in the Wind','Set in a dystopian future, \"Reflections of Tomorrow\" is a thought-provoking novel that explores themes of identity, freedom, and resilience. Through its compelling storyline and well-drawn characters, the book invites readers to ponder the ethical dilemmas of technological advancement and societal change.','
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,'Education Startup',1,'main/projects/2.png',NULL,398,'published','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'2023-03-15'),(3,'Reflections of Tomorrow','Set in a dystopian future, \"Reflections of Tomorrow\" is a thought-provoking novel that explores themes of identity, freedom, and resilience. Through its compelling storyline and well-drawn characters, the book invites readers to ponder the ethical dilemmas of technological advancement and societal change.','
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,'Finance Company',1,'main/projects/3.png',NULL,9174,'published','2024-10-20 21:49:16','2024-10-20 21:49:16',NULL,'2022-09-10'); /*!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=4 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,'Writing',NULL,NULL,0,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(2,NULL,'Editing',NULL,NULL,0,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(3,NULL,'SEO Writing',NULL,NULL,0,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'); /*!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,1,'Writing: Novels, Short Stories, and Poetry','Whether you\'re looking for an immersive novel, a captivating short story, or evocative poetry, I am your go-to writer. With a deep understanding of character development, plot structure, and lyrical prose, I craft stories that resonate and inspire.','
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,NULL,NULL,3202,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(2,3,'Articles, Blog Posts, and Website Content','Today\'s digital age, engaging content is crucial for capturing your audience\'s attention. I specialize in creating high-quality content that aligns with your brand\'s voice and objectives.','
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,NULL,NULL,6556,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(3,3,'Precision Proofreading and Editing','Enhance your brand with compelling stories and memorable content that resonates with your audience.','
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,NULL,NULL,9164,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(4,1,'SEO-Optimized Writing Services','Improve your online visibility with our SEO-focused content, designed to rank higher and attract more visitors.','
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,NULL,NULL,1237,'published','2024-10-20 21:49:16','2024-10-20 21:49:16'); /*!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 (6,1),(8,1),(8,2),(5,2),(7,3),(4,3),(7,4),(3,4),(6,5),(1,5),(5,6),(3,6),(3,7),(8,7),(8,8),(4,8),(1,9),(9,9),(8,10),(9,10),(6,11),(9,11),(1,12),(4,12),(4,13),(9,13),(1,14),(8,14),(7,15),(5,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 (8,1),(6,1),(4,1),(1,2),(7,2),(3,3),(7,3),(2,3),(2,4),(7,4),(6,4),(1,5),(6,5),(4,5),(5,6),(3,6),(6,6),(7,7),(5,7),(7,8),(3,8),(8,9),(3,9),(2,10),(4,10),(3,10),(1,11),(4,11),(6,11),(2,12),(4,12),(8,12),(7,13),(1,13),(2,13),(3,14),(5,14),(7,15),(6,15),(1,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/6.png',751,NULL,'2024-04-01 02:36:37','2024-10-20 21:49:15'),(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/8.png',2167,NULL,'2024-03-10 20:20:58','2024-10-20 21:49:15'),(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',0,'main/posts/1.png',1260,NULL,'2023-10-24 10:36:59','2024-10-20 21:49:15'),(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',513,NULL,'2024-09-23 01:16:18','2024-10-20 21:49:15'),(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/7.png',952,NULL,'2024-06-09 22:18:57','2024-10-20 21:49:15'),(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/12.png',1111,NULL,'2024-05-01 10:27:51','2024-10-20 21:49:15'),(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/8.png',422,NULL,'2024-02-28 15:03:05','2024-10-20 21:49:15'),(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/2.png',934,NULL,'2024-06-08 05:07:26','2024-10-20 21:49:15'),(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/11.png',555,NULL,'2024-01-18 00:32:47','2024-10-20 21:49:15'),(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',1,'main/posts/10.png',1772,NULL,'2024-01-15 16:23:04','2024-10-20 21:49:15'),(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',1,'main/posts/1.png',430,NULL,'2023-11-12 17:51:49','2024-10-20 21:49:15'),(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/5.png',673,NULL,'2024-10-01 15:30:41','2024-10-20 21:49:15'),(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/6.png',1168,NULL,'2024-05-23 06:36:58','2024-10-20 21:49:15'),(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/6.png',1968,NULL,'2023-10-30 03:21:28','2024-10-20 21:49:15'),(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',1,'main/posts/3.png',315,NULL,'2024-03-16 15:53:46','2024-10-20 21:49:15'); /*!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:14','2024-10-20 21:49:14'); /*!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=28 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','8d4b03234806726b4c585287f2d9d75b',NULL,'2024-10-20 21:49:17'),(2,'api_enabled','0',NULL,'2024-10-20 21:49:17'),(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:17'),(4,'theme','zelio',NULL,'2024-10-20 21:49:17'),(5,'show_admin_bar','1',NULL,'2024-10-20 21:49:17'),(6,'language_hide_default','1',NULL,'2024-10-20 21:49:17'),(7,'language_switcher_display','dropdown',NULL,'2024-10-20 21:49:17'),(8,'language_display','all',NULL,'2024-10-20 21:49:17'),(9,'language_hide_languages','[]',NULL,'2024-10-20 21:49:17'),(10,'theme-zelio-favicon','write/general/favicon.png',NULL,NULL),(11,'theme-zelio-logo','write/general/favicon.png',NULL,NULL),(12,'theme-zelio-seo_description','Discover innovative designs, creative projects, and unique artistic works. Showcasing the expertise and vision behind every creation.',NULL,NULL),(13,'theme-zelio-homepage_id','1',NULL,NULL),(14,'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),(15,'theme-zelio-copyright','© %Y All Rights Reserved by botble.com.',NULL,NULL),(16,'theme-zelio-site_name','Meisa',NULL,NULL),(17,'theme-zelio-site_title','Professional Content Creator',NULL,NULL),(18,'theme-zelio-primary_color','#fcc6e2',NULL,NULL),(19,'theme-zelio-gradient_color','#40363b',NULL,NULL),(20,'theme-zelio-tp_primary_font','Playfair Display',NULL,NULL),(21,'theme-zelio-tp_secondary_font','Urbanist',NULL,NULL),(22,'theme-zelio-header_style','3',NULL,NULL),(23,'theme-zelio-footer_style','3',NULL,NULL),(24,'theme-zelio-preloader_style','3',NULL,NULL),(25,'theme-zelio-blog_page_id','5',NULL,NULL),(26,'theme-zelio-post_item_style','3',NULL,NULL),(27,'theme-zelio-post_item_per_row','1',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=47 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:15','2024-10-20 21:49:15'),(2,'open-source-contributions',2,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(3,'tutorials',3,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(4,'technology-reviews',4,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(5,'personal-blog',5,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(6,'career-journey',6,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(7,'coding-challenges',7,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(8,'design-portfolio',8,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(9,'collaborations',9,'Botble\\Blog\\Models\\Category','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(10,'botble-cms',1,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(11,'javascript',2,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(12,'open-source',3,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(13,'web-design',4,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(14,'api-development',5,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(15,'full-stack-development',6,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(16,'vietnam-developer',7,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(17,'github-projects',8,'Botble\\Blog\\Models\\Tag','tag','2024-10-20 21:49:15','2024-10-20 21:49:15'),(18,'building-a-full-stack-app-with-the-tall-stack',1,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(19,'my-journey-in-open-source-3-years-of-contributions',2,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(20,'5-essential-tools-for-web-developers-in-2024',3,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(21,'how-i-built-my-personal-portfolio-using-botble-cms',4,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(22,'creating-responsive-uis-with-tailwind-css',5,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(23,'why-i-love-contributing-to-open-source-projects',6,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(24,'a-deep-dive-into-laravel-for-beginners',7,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(25,'exploring-the-benefits-of-mysql-for-large-scale-projects',8,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(26,'how-to-integrate-apis-in-nodejs-for-your-next-project',9,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(27,'best-practices-for-designing-user-friendly-websites',10,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(28,'lessons-from-my-first-web-development-job',11,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(29,'how-to-contribute-to-open-source-a-beginners-guide',12,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(30,'optimizing-web-performance-with-reactjs',13,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(31,'my-top-5-github-projects',14,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(32,'adapting-to-the-new-web-development-trends-in-2024',15,'Botble\\Blog\\Models\\Post','','2024-10-20 21:49:15','2024-10-20 21:49:15'),(33,'writing-novels-short-stories-and-poetry',1,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:16','2024-10-20 21:49:16'),(34,'articles-blog-posts-and-website-content',2,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:16','2024-10-20 21:49:16'),(35,'precision-proofreading-and-editing',3,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:16','2024-10-20 21:49:16'),(36,'seo-optimized-writing-services',4,'Botble\\Portfolio\\Models\\Service','services','2024-10-20 21:49:16','2024-10-20 21:49:16'),(37,'novels-echoes-of-the-past',1,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:16','2024-10-20 21:49:16'),(38,'whispers-in-the-wind',2,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:16','2024-10-20 21:49:16'),(39,'reflections-of-tomorrow',3,'Botble\\Portfolio\\Models\\Project','projects','2024-10-20 21:49:16','2024-10-20 21:49:16'),(40,'home',1,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(41,'services',2,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(42,'projects',3,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(43,'pricing',4,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(44,'blog',5,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(45,'contact',6,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'),(46,'cookie-policy',7,'Botble\\Page\\Models\\Page','','2024-10-20 21:49:17','2024-10-20 21:49:17'); /*!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:15','2024-10-20 21:49:15'),(2,'JavaScript',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(3,'Open Source',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(4,'Web Design',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(5,'API Development',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(6,'Full Stack Development',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(7,'Vietnam Developer',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'),(8,'GitHub Projects',NULL,'Botble\\ACL\\Models\\User',NULL,'published','2024-10-20 21:49:15','2024-10-20 21:49:15'); /*!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,'John Doe','Meisa\'s writing is simply magical. She has the ability to capture the essence of a story and preset it in the most captivating way.','main/avatars/2.png','Author','published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(2,'Jane Smith','Working with Meisa was a fantastic experience. Her attention to detail and commitment to quality are unparalleled.','main/avatars/2.png','Editor','published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(3,'David Brown','Meisa is a true professional. Her writing is engaging and thought-provoking, and she always delivers on time.','main/avatars/1.png','Publisher','published','2024-10-20 21:49:16','2024-10-20 21:49:16'),(4,'Emily White','I have been a fan of Meisa for years. Her stories are beautifully written and always leave me wanting more.','main/avatars/1.png','Reader','published','2024-10-20 21:49:16','2024-10-20 21:49:16'); /*!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,'cale83@runolfsson.com',NULL,'$2y$12$UJbrhKNJVwEVSr3VN4l2r./Qp9qVw8hKH.itynEF7/CYvebqtePQ6',NULL,'2024-10-20 21:49:14','2024-10-20 21:49:14','Chloe','Hintz','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=8 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:17','2024-10-20 21:49:17'),(2,'SocialLinkWidget','sidebar_panel_sidebar','zelio',2,'{\"name\":\"Social\"}','2024-10-20 21:49:17','2024-10-20 21:49:17'),(3,'LanguageSwitcherWidget','sidebar_panel_sidebar','zelio',3,'[]','2024-10-20 21:49:17','2024-10-20 21:49:17'),(4,'ContactInformationWidget','primary_sidebar','zelio',1,'{\"image\":\"write\\/general\\/avatar.png\",\"signature\":\"write\\/general\\/signature.png\",\"details\":[[{\"key\":\"label\",\"value\":\"Phone\"},{\"key\":\"value\",\"value\":\"+1 234 567 890\"},{\"key\":\"icon\",\"value\":\"ti ti-phone\"},{\"key\":\"url\",\"value\":\"tel:+1234567890\"}],[{\"key\":\"label\",\"value\":\"Email\"},{\"key\":\"value\",\"value\":\"contact@botble.com\"},{\"key\":\"icon\",\"value\":\"ti ti-mail\"},{\"key\":\"url\",\"value\":\"mailto:contact@botble.com\"}],[{\"key\":\"label\",\"value\":\"Website\"},{\"key\":\"value\",\"value\":\"botble.com\"},{\"key\":\"icon\",\"value\":\"ti ti-world\"},{\"key\":\"url\",\"value\":\"https:\\/\\/botble.com\"}],[{\"key\":\"label\",\"value\":\"Address\"},{\"key\":\"value\",\"value\":\"123 Main Street, New York, NY 10001\"},{\"key\":\"icon\",\"value\":\"ti ti-map\"},{\"key\":\"url\",\"value\":null}]],\"display_social_links\":true}','2024-10-20 21:49:17','2024-10-20 21:49:17'),(5,'SiteLogoWidget','footer_sidebar','zelio',1,'[]','2024-10-20 21:49:17','2024-10-20 21:49:17'),(6,'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:17','2024-10-20 21:49:17'),(7,'SocialLinkWidget','footer_sidebar','zelio',3,'{\"name\":\"Social\"}','2024-10-20 21:49:17','2024-10-20 21:49:17'); /*!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:18