-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 19, 2026 at 09:44 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `portfoliodb` -- -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` bigint(20) UNSIGNED NOT NULL, `post_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `parent_id` bigint(20) UNSIGNED DEFAULT NULL, `user_name` varchar(255) DEFAULT NULL, `user_email` varchar(255) DEFAULT NULL, `body` text NOT NULL, `is_approved` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` text NOT NULL, `message` text NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `is_replied` tinyint(1) NOT NULL DEFAULT 0, `additional_info` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `contacts` -- INSERT INTO `contacts` (`id`, `name`, `email`, `subject`, `message`, `is_read`, `is_replied`, `additional_info`, `created_at`, `updated_at`) VALUES (1, 'Deacon Berg', 'fytakop@mailinator.com', 'Quia voluptatem Necessitatibus et quia numquam aspernatur excepteur exercitation sint do omnis corrupti qui', 'At ut quod do voluptas et esse autem pariatur In voluptas ut', 0, 0, NULL, '2026-04-18 13:57:24', '2026-04-18 13:57:24'), (2, 'Hedy Maldonado', 'relal@mailinator.com', 'Voluptatem Provident quaerat quo sit', 'Dolor illum maxime pariatur Perspiciatis ducimus hic ut', 0, 0, NULL, '2026-04-18 13:58:58', '2026-04-18 13:58:58'), (3, 'Cullen Hunt', 'cyne@mailinator.com', 'Nihil veniam maxime velit tenetur cum animi elit qui cumque aperiam fugiat est', 'Reiciendis unde aspernatur ut sed maxime cum dignissimos consequat Consectetur rerum laudantium et ipsa dicta voluptas', 0, 0, NULL, '2026-04-18 13:59:44', '2026-04-18 13:59:44'), (4, 'Gwendolyn Oneal', 'duxi@mailinator.com', 'Eum id consequatur illum veritatis voluptatem in aut soluta praesentium quisquam do neque architecto eius dolore sunt', 'Odio ut assumenda similique magnam nihil impedit animi quaerat', 0, 0, NULL, '2026-04-18 14:00:46', '2026-04-18 14:00:46'); -- -------------------------------------------------------- -- -- Table structure for table `experiences` -- CREATE TABLE `experiences` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `company` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `is_current` tinyint(1) NOT NULL DEFAULT 0, `description` longtext DEFAULT NULL, `experience_type` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `experiences` -- INSERT INTO `experiences` (`id`, `user_id`, `title`, `company`, `location`, `photo_path`, `start_date`, `end_date`, `is_current`, `description`, `experience_type`, `designation`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'Senior UI/UX Designer at PixelCraft Studios (2018-2020)', 'Bruce Blake Traders', 'Rampura, Dhaka', 'experiences/7eXpap0RCVsrVSILRQPhjQQ3KrWitMvvJcHK1niF.png', '2021-11-05', '2022-05-16', 0, 'Led UI/UX design at PixelCraft Studios, crafting innovative digital experiences in collaboration with cross-functional teams.', 'work', NULL, 1, '2026-04-18 06:34:24', '2026-04-18 06:34:24'), (2, 1, 'Freelance Digital Designer (2010-2012)', 'Kajira', 'Rampura, Dhaka', 'experiences/P2Y6tnQxOi9wyadqlpToJdJ5ugIw3ddxtLDtTVHr.jpg', '2010-02-01', '2012-12-16', 0, 'As a freelance digital designer, I gained diverse experience in web, graphic, and branding projects, honing skills and building client relationships.', 'work', NULL, 1, '2026-04-18 06:35:53', '2026-04-18 06:35:53'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `galleries` -- CREATE TABLE `galleries` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `gallery_category_id` bigint(20) UNSIGNED DEFAULT NULL, `short_description` text DEFAULT NULL, `description` longtext DEFAULT NULL, `thumbnail_path` varchar(255) DEFAULT NULL, `image_path` varchar(255) NOT NULL, `photo_year` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `photographer` varchar(255) DEFAULT NULL, `additional_image_paths` varchar(255) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `galleries` -- INSERT INTO `galleries` (`id`, `title`, `gallery_category_id`, `short_description`, `description`, `thumbnail_path`, `image_path`, `photo_year`, `location`, `photographer`, `additional_image_paths`, `status`, `created_at`, `updated_at`) VALUES (1, 'Boishak-22', 1, 'Album structures contain the album names and album categories created by you', 'You can share album structures with others by exporting or importing them. For example, you have a set of albums representing different museums you’ve visited with friends. By saving and exporting your album set, your friends, who have also visited those museums, can import that album structure (not the photos in it) and use it for their photos. Alternately, you can import the album structure of one of your friends and apply it to your photos.', 'galleries/thumbnails/tjapz5gpPPvOGy4WCiJ6Kdlqu214KAIgdYxo0LV2.jpg', 'galleries/mI3R5iJjnooPWgVZ6jlbj1L8BIUXQRd2NkrIjn9j.png', '2024', 'Rampura, Dhaka', 'Nitin Mukesh', '[\"galleries\\/additional\\/btr2Hm3JZtNjG0XFICgzqU7uNvbl6lZ1NVO127G4.png\",\"galleries\\/additional\\/1kfUPfr6SKNJquA4MN6tFzXrf4hUVYdM4Z32uZpE.png\",\"galleries\\/additional\\/8457JiriTTFv3jxneIzOssoKHy7aLiTMgJlpDfNu.jpg\"]', 1, '2026-04-17 12:56:40', '2026-04-18 00:59:29'); -- -------------------------------------------------------- -- -- Table structure for table `gallery_categories` -- CREATE TABLE `gallery_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `is_default` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `gallery_categories` -- INSERT INTO `gallery_categories` (`id`, `name`, `slug`, `is_default`, `created_at`, `updated_at`) VALUES (1, 'Default', 'default', 1, '2026-04-17 12:51:30', '2026-04-17 12:51:30'), (2, 'Eating', 'eating', 0, '2026-04-17 12:51:46', '2026-04-17 12:51:46'), (3, 'Walking', 'walking', 0, '2026-04-17 12:51:57', '2026-04-17 12:51:57'), (4, 'Dance', 'dance', 0, '2026-04-17 12:52:07', '2026-04-17 12:52:07'), (5, 'Tour', 'tour', 0, '2026-04-17 12:52:29', '2026-04-17 12:52:29'), (6, 'Debate', 'debate', 0, '2026-04-17 12:54:52', '2026-04-17 12:54:52'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `likes` -- CREATE TABLE `likes` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `likeable_type` varchar(255) NOT NULL, `likeable_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2026_04_14_115501_create_experiences_table', 1), (5, '2026_04_14_122333_create_tags_table', 1), (6, '2026_04_14_122416_create_posts_table', 1), (7, '2026_04_14_122443_create_comments_table', 1), (8, '2026_04_14_122507_create_likes_table', 1), (9, '2026_04_14_194214_create_contacts_table', 1), (10, '2026_04_14_194229_create_galleries_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `posts` -- CREATE TABLE `posts` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `title` text NOT NULL, `slug` text NOT NULL, `thumbnail` varchar(255) DEFAULT NULL, `content` longtext NOT NULL, `status` enum('draft','published') NOT NULL DEFAULT 'draft', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `posts` -- INSERT INTO `posts` (`id`, `user_id`, `title`, `slug`, `thumbnail`, `content`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'Creative Blog Name Ideas to Launch or Rebrand Your Blog in 2026', 'creative-blog-name-ideas-to-launch-or-rebrand-your-blog-in-2026', 'thumbnails/WMlQRxJYSvbL0cNjnriHCLynAVIX44cApRDkoN2S.jpg', '

Choosing the right name for your blog is an important part of branding, ranking online, and attracting an audience in 2025. But, sometimes it can take a while to come up with blog name ideas!




A powerful blog name should do more than sound good—it should work strategically for your goals! The best blog names:

Instantly tell readers what value they’ll find

Feel natural to share and easy to remember

Have available domains and social media handles

Align with your broader business or personal brand

Still scratching your head? You’re not alone! We’ve created this comprehensive guide to help you choose a blog name (and find blog name ideas) that sets you up for success in 2025. Here’s what we’ll cover:

', 'published', '2026-04-17 10:19:01', '2026-04-17 10:19:01'); INSERT INTO `posts` (`id`, `user_id`, `title`, `slug`, `thumbnail`, `content`, `status`, `created_at`, `updated_at`) VALUES (2, 1, 'What Are Blog Tags? The All-Encompassing Guide You Always Wanted', 'what-are-blog-tags-the-all-encompassing-guide-you-always-wanted', 'thumbnails/Js0S23tTUGLC3rjzanoZUmhEHUhU3vOENEmUaly2.png', '

Business blogging has become a valuable – nearly essential – asset to a successful marketing strategy in 2019.

When starting a business blog, it\'s important to strategize and consider everything that has to do with your blog, even the most overlooked things. 

Cue the blog tag.



More often than not, businesses overlook the use and importance of blog tags. They\'re often an afterthought for marketing teams. And when this bad habit of adding and creating tags goes unchecked, your content management system (CMS) becomes messy.

From a user experience standpoint, this makes sorting and navigating through blog topics a frustrating ordeal. And when you consider the SEO impact you can create with a strong blog tagging strategy, this afterthought should quickly become another priority in your content marketing strategy. 

In this post, we will:

Define what a blog tag is.

Explain the differences between a tag and a category.

Highlight how tags can improve your SEO efforts.

Touch on blog tags best practices.

Provide step-by-step instructions for adding tags in both HubSpot and WordPress.


\r\n

', 'published', '2026-04-17 10:20:48', '2026-04-18 01:57:29'); -- -------------------------------------------------------- -- -- Table structure for table `post_tag` -- CREATE TABLE `post_tag` ( `id` bigint(20) UNSIGNED NOT NULL, `post_id` bigint(20) UNSIGNED NOT NULL, `tag_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `post_tag` -- INSERT INTO `post_tag` (`id`, `post_id`, `tag_id`) VALUES (1, 1, 2), (2, 2, 4); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('4p6lnSPlG1L3vT0Yu1gkKG8cMpkEdl8yHaojYOEJ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicXR4aFR3bVBJM3ozSkZTU2gzQnJkdDFubzF0Rk1sWkdlM1BQeHlJaCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyOToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL3Byb2ZpbGUiO31zOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoyNzoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1776539740), ('8vMeNopkLtsVsrGFfY1ClFzUXODWTYDgXDzwBFa4', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicFBGeHRTRHR3QnVCWWxwUUxJY091QmN6Y216VDZVcTUwZmpLdFhKNiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC93b3JrLXByb2Nlc3NlcyI7czo1OiJyb3V0ZSI7czoxODoid29yay1wcm9jZXNzLmluZGV4Ijt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1776535629), ('FnecxopYK3vt8LLw5yeOA4my6THkK8GZbotQaD8d', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRFJTUTRMeU1FNjYxcm9PbWhGQWNwVmZrT1FvOG5LZ2p3U0ttVjVnVCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jb250YWN0cy8zIjtzOjU6InJvdXRlIjtzOjEzOiJjb250YWN0cy5zaG93Ijt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1776542561), ('jovII7dabwXWD1LoomlXELHatDYAaiFKlGSIjeVt', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieWNyVkxVRnVubExBekVGc2R6T05kNGxjMFM4eFJ6OTdJNkhGd0p6NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODA4MC9hYm91dCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1776539531), ('qMcSiP37PiceW718ukUB9JTN8eslbwjeN40aPzbR', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic3RIcmNXRTBEY2JTbEtLcjd4c3BzeWhjcG9uSUdFOU9jcGRRelh3YSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODA4MCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1776538206), ('qxPIJIujrFq1DASy6sCi1pALoHwZWp0Qc3F8YKYZ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicFNTUGpRRGo4a2phZm5MbmU0VE1GQ2NjRWptOFBDZ0NVR3FHamFtZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODA4MCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1776539672), ('RbIKNcIzxx84rFFyyJgf0WhhRCVUK1taSnGgOIcm', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoib3R6TElIZXpEVndxdmtxQ2ZDR1VacVFWNXR0cG11TFh3M3hMRTduVSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjI5OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvcHJvZmlsZSI7czo1OiJyb3V0ZSI7czoxMjoicHJvZmlsZS5lZGl0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1776539043), ('vevTA2aFQYIzHpGcKyMNBWnuMX72MaA01SBFaPo3', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZlUwc0k2U2xZMGJrb3VRTnJJeUpXbHo1UmxNaGRpYk1DY3FZU2FiZyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjI5OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvcHJvZmlsZSI7czo1OiJyb3V0ZSI7czoxMjoicHJvZmlsZS5lZGl0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1776539581), ('XMp0qR7TDphufNANFkY0aY9VOD3Szb2xH7Cj2Bmt', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNnF3dTY5cGFHN2FyNXJ5NkpxUHdaRnBhMEdHU3BONm1nNGtCTWpOOSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODA4MC9jb250YWN0IjtzOjU6InJvdXRlIjtOO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1776542478); -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tags` -- INSERT INTO `tags` (`id`, `name`, `slug`, `status`, `created_at`, `updated_at`) VALUES (1, 'Tutorial', 'tutorial', 1, '2026-04-17 10:15:37', '2026-04-17 10:15:37'), (2, 'Events', 'events', 1, '2026-04-17 10:15:45', '2026-04-17 10:15:45'), (3, 'News', 'news', 1, '2026-04-17 10:15:54', '2026-04-17 10:15:54'), (4, 'Awards', 'awards', 1, '2026-04-17 10:16:15', '2026-04-17 10:16:15'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `full_name` varchar(255) DEFAULT NULL, `nickname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role` varchar(255) NOT NULL DEFAULT 'user', `is_active` tinyint(1) NOT NULL DEFAULT 1, `job_title` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `short_bio` longtext DEFAULT NULL, `full_bio` longtext DEFAULT NULL, `profile_photo_path` varchar(255) DEFAULT NULL, `cover_photo_path` varchar(255) DEFAULT NULL, `birth_date` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `whatsapp` varchar(255) DEFAULT NULL, `linkedin` varchar(255) DEFAULT NULL, `github` varchar(255) DEFAULT NULL, `facebook` varchar(255) DEFAULT NULL, `instagram` varchar(255) DEFAULT NULL, `twitter` varchar(255) DEFAULT NULL, `dribbble` varchar(255) DEFAULT NULL, `tiktok` varchar(255) DEFAULT NULL, `youtube` varchar(255) DEFAULT NULL, `discord` varchar(255) DEFAULT NULL, `cv_link` varchar(255) DEFAULT NULL, `additional_info` longtext DEFAULT NULL, `achievements` longtext DEFAULT NULL, `what_ido` longtext DEFAULT NULL, `work_process` longtext DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `full_name`, `nickname`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `job_title`, `city`, `company`, `short_bio`, `full_bio`, `profile_photo_path`, `cover_photo_path`, `birth_date`, `phone`, `address`, `whatsapp`, `linkedin`, `github`, `facebook`, `instagram`, `twitter`, `dribbble`, `tiktok`, `youtube`, `discord`, `cv_link`, `additional_info`, `achievements`, `what_ido`, `work_process`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Anika Ibnat Tuba', 'Anika', 'anika94@gmail.com', '2026-04-17 10:12:11', '$2y$12$JVIQ4YD4HRYL5heRLg5j3uim31VyPf8Pw7WGPdOshx5JjdYYPIsxW', 'user', 1, 'Assistant Professor', 'Bloomington', 'Bruce Blake Traders', 'A paragraph is a series of sentences that are organized and coherent, and are all related to a single topic. Almost every piece of writing you do that is longer than a few sentences should be organized into paragraphs. This is because paragraphs show a reader where the subdivisions of an essay begin and end, and thus help the reader see the organization of the essay and grasp its main points.', 'A well-organized paragraph supports or develops a single controlling idea, which is expressed in a sentence called the topic sentence. A topic sentence has several important functions: it substantiates or supports an essay’s thesis statement; it unifies the content of a paragraph and directs the order of the sentences; and it advises the reader of the subject to be discussed and how the paragraph will discuss it. Readers generally look to the first few sentences in a paragraph to determine the subject and perspective of the paragraph. That’s why it’s often best to put the topic sentence at the very beginning of the paragraph. In some cases, however, it’s more effective to place another sentence before the topic sentence—for example, a sentence linking the current paragraph to the previous one, or one providing background information.\r\n\r\nAlthough most paragraphs should have a topic sentence, there are a few situations when a paragraph might not need a topic sentence. For example, you might be able to omit a topic sentence in a paragraph that narrates a series of events, if a paragraph continues developing an idea that you introduced (with a topic sentence) in the previous paragraph, or if all the sentences and details in a paragraph clearly refer—perhaps indirectly—to a main point. The vast majority of your paragraphs, however, should have a topic sentence.', 'profile-photos/MGWsiSCCrde2FqPbBaAgAPRBrXAGVOVCuuJF9O5X.png', 'cover-photos/QT0WXKODTRoaw9jIDvNEbzGJjicOQRIrcqyDFhLa.png', '1995-12-11', '01567856768', 'Wells Library | 1320 E. 10th St. | Bloomington, IN 47405', '+966 50 912 8562', 'https://www.zazi.ca', 'https://www.hobihynizyreqi.org.uk', 'https://www.facebook.com/saudivapercenter', 'https://www.instagram.com/saudivapercenter', 'https://www.ryz.info', 'https://www.tacifeh.me', NULL, 'https://www.youtube.com/@saudivapercenter', NULL, 'cv-files/oEcrdNynhAvN6Y19XKe9DNRkz2EDkjCpN0OVqjXo.pdf', '{\"work_processes\":[{\"number\":\"01\",\"title\":\"Exploration\",\"description\":\"In the exploration phase, I dive deep into understanding the project requirements, client expectations, and the target audience. Through research, brainstorming sessions, and discussions with stakeholders, I uncover insights that will shape the direction of the design. This is where ideas are born, and concepts start to take shape.\"},{\"number\":\"02\",\"title\":\"Design\",\"description\":\"With a solid concept in place, I roll up my sleeves and get to work on the actual design. This phase involves creating high-fidelity mockups, refining visual elements, and fine-tuning the user interface. I pay close attention to every detail, ensuring that the design not only looks great but also functions seamlessly across different devices and platforms.\"},{\"number\":\"03\",\"title\":\"Feedback\",\"description\":\"Feedback is crucial in the design process, and I welcome input from clients, colleagues, and end-users. During this phase, I gather feedback on the initial designs, incorporating suggestions and making revisions as needed. Whether it\'s tweaking the color scheme, adjusting layout elements, or refining interactions, the goal is to refine the design until it meets or exceeds expectations.\"},{\"number\":\"04\",\"title\":\"Delivery\",\"description\":\"The delivery phase marks the culmination of the design process, as the final product is prepared for launch. This involves preparing design assets, collaborating with developers to ensure seamless integration, and conducting final quality assurance checks. Whether it\'s a website, mobile app, or digital campaign, I take pride in delivering a polished product that exceeds expectations and delights users.\"}],\"achievements\":[{\"title\":\"Years of Experience\",\"years\":\"15\"},{\"title\":\"Design Awards\",\"years\":\"23\"},{\"title\":\"Successful Projects\",\"years\":\"50\"},{\"title\":\"Happy customers\",\"years\":\"45\"}],\"what_ido\":[{\"title\":\"Branding\",\"description\":\"Craft logos and visuals; develop brand guidelines for consistency\"},{\"title\":\"Reporting\",\"description\":\"I build tailored solutions using cutting-edge tech to meet client needs\"},{\"title\":\"Strategy\",\"description\":\"Customized solutions, results-driven: Market research, strategy, execution\"}]}', '[{\"title\":\"Years of Experience\",\"years\":\"15\"},{\"title\":\"Design Awards\",\"years\":\"23\"},{\"title\":\"Successful Projects\",\"years\":\"50\"},{\"title\":\"Happy customers\",\"years\":\"45\"}]', '[{\"title\":\"Branding\",\"description\":\"Craft logos and visuals; develop brand guidelines for consistency\"},{\"title\":\"Reporting\",\"description\":\"I build tailored solutions using cutting-edge tech to meet client needs\"},{\"title\":\"Strategy\",\"description\":\"Customized solutions, results-driven: Market research, strategy, execution\"}]', '[{\"number\":\"01\",\"title\":\"Exploration\",\"description\":\"In the exploration phase, I dive deep into understanding the project requirements, client expectations, and the target audience. Through research, brainstorming sessions, and discussions with stakeholders, I uncover insights that will shape the direction of the design. This is where ideas are born, and concepts start to take shape.\"},{\"number\":\"02\",\"title\":\"Design\",\"description\":\"With a solid concept in place, I roll up my sleeves and get to work on the actual design. This phase involves creating high-fidelity mockups, refining visual elements, and fine-tuning the user interface. I pay close attention to every detail, ensuring that the design not only looks great but also functions seamlessly across different devices and platforms.\"},{\"number\":\"03\",\"title\":\"Feedback\",\"description\":\"Feedback is crucial in the design process, and I welcome input from clients, colleagues, and end-users. During this phase, I gather feedback on the initial designs, incorporating suggestions and making revisions as needed. Whether it\'s tweaking the color scheme, adjusting layout elements, or refining interactions, the goal is to refine the design until it meets or exceeds expectations.\"},{\"number\":\"04\",\"title\":\"Delivery\",\"description\":\"The delivery phase marks the culmination of the design process, as the final product is prepared for launch. This involves preparing design assets, collaborating with developers to ensure seamless integration, and conducting final quality assurance checks. Whether it\'s a website, mobile app, or digital campaign, I take pride in delivering a polished product that exceeds expectations and delights users.\"}]', 'K5avmDjeAP', '2026-04-17 10:12:11', '2026-04-18 12:06:58'); -- -- Indexes for dumped tables -- -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`), ADD KEY `cache_expiration_index` (`expiration`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`), ADD KEY `cache_locks_expiration_index` (`expiration`); -- -- Indexes for table `comments` -- ALTER TABLE `comments` ADD PRIMARY KEY (`id`), ADD KEY `comments_post_id_foreign` (`post_id`), ADD KEY `comments_user_id_foreign` (`user_id`), ADD KEY `comments_parent_id_foreign` (`parent_id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `experiences` -- ALTER TABLE `experiences` ADD PRIMARY KEY (`id`), ADD KEY `experiences_user_id_foreign` (`user_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `galleries` -- ALTER TABLE `galleries` ADD PRIMARY KEY (`id`), ADD KEY `galleries_gallery_category_id_foreign` (`gallery_category_id`), ADD KEY `galleries_title_index` (`title`), ADD KEY `galleries_status_index` (`status`), ADD KEY `galleries_created_at_index` (`created_at`); -- -- Indexes for table `gallery_categories` -- ALTER TABLE `gallery_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `gallery_categories_slug_unique` (`slug`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `likes` -- ALTER TABLE `likes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `likes_user_id_likeable_id_likeable_type_unique` (`user_id`,`likeable_id`,`likeable_type`), ADD KEY `likes_likeable_type_likeable_id_index` (`likeable_type`,`likeable_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `posts_slug_unique` (`slug`) USING HASH, ADD KEY `posts_user_id_foreign` (`user_id`), ADD KEY `posts_status_index` (`status`), ADD KEY `posts_title_index` (`title`(768)); -- -- Indexes for table `post_tag` -- ALTER TABLE `post_tag` ADD PRIMARY KEY (`id`), ADD KEY `post_tag_post_id_foreign` (`post_id`), ADD KEY `post_tag_tag_id_foreign` (`tag_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tags_name_unique` (`name`), ADD UNIQUE KEY `tags_slug_unique` (`slug`), ADD KEY `tags_name_index` (`name`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `comments` -- ALTER TABLE `comments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `experiences` -- ALTER TABLE `experiences` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `galleries` -- ALTER TABLE `galleries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `gallery_categories` -- ALTER TABLE `gallery_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `likes` -- ALTER TABLE `likes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `posts` -- ALTER TABLE `posts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `post_tag` -- ALTER TABLE `post_tag` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tags` -- ALTER TABLE `tags` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `comments` -- ALTER TABLE `comments` ADD CONSTRAINT `comments_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `comments_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `experiences` -- ALTER TABLE `experiences` ADD CONSTRAINT `experiences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `galleries` -- ALTER TABLE `galleries` ADD CONSTRAINT `galleries_gallery_category_id_foreign` FOREIGN KEY (`gallery_category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE SET NULL; -- -- Constraints for table `likes` -- ALTER TABLE `likes` ADD CONSTRAINT `likes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `posts` -- ALTER TABLE `posts` ADD CONSTRAINT `posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `post_tag` -- ALTER TABLE `post_tag` ADD CONSTRAINT `post_tag_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `post_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;