-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- 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 `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', '<h3><span style=\"color: rgb(36, 39, 58);\">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!</span></h3><p><br></p><p><img src=\"data:image/jpeg;base64,[BLOB]\"></p><p><br></p><p><br></p><h3>A powerful blog name should do more than sound good—it should work strategically for your goals! The best blog names:</h3><h3>Instantly tell readers&nbsp;<strong>what value they’ll find</strong></h3><h3><strong>Feel natural to share</strong>&nbsp;and easy to remember</h3><h3>Have&nbsp;<strong>available domains</strong>&nbsp;and&nbsp;<a href=\"https://saudivapecenter.com\" target=\"_blank\">social media handles</a></h3><h3>Align with your broader business or&nbsp;<a href=\"https://looka.com/blog/personal-branding/\" target=\"_blank\" style=\"color: rgb(36, 39, 58);\"><strong>personal brand</strong></a></h3><h3>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:</h3>', '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', '<p>                        </p><p>Business blogging has become a valuable – nearly essential – asset to a successful marketing strategy in 2019.</p><p><a href=\"https://www.bluleadz.com/blog/how-to-start-a-successful-blog\" target=\"_blank\" style=\"background-color: transparent; color: rgb(241, 138, 33);\">When starting a business blog</a>, it\'s important to strategize and consider everything that has to do with your blog, even the&nbsp;most overlooked things.&nbsp;</p><p>Cue the blog tag.</p><p><br></p><p><img src=\"data:image/jpeg;base64,[BLOB]\"></p><p><br></p><p>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.</p><p>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&nbsp;create&nbsp;with a strong blog tagging strategy, this afterthought should quickly become another priority in your&nbsp;<a href=\"https://www.bluleadz.com/blog/how-to-plan-your-content-marketing-strategy\" target=\"_blank\" style=\"background-color: transparent; color: rgb(241, 138, 33);\">content marketing strategy</a>.&nbsp;</p><p>In this post, we will:</p><p>Define what a blog tag is.</p><p>Explain the differences between a tag and a category.</p><p>Highlight how tags can improve your SEO efforts.</p><p>Touch on blog tags best practices.</p><p>Provide step-by-step instructions for adding tags in both HubSpot and WordPress.</p><p><br></p><p>\r\n                    </p>', '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');

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

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

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

