-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 24, 2026 at 01:35 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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: `Travel_system`
--

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

--
-- Table structure for table `about_items`
--

CREATE TABLE `about_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `feature_status` 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 `about_items`
--

INSERT INTO `about_items` (`id`, `feature_status`, `created_at`, `updated_at`) VALUES
(1, 'Show', '2025-01-10 15:32:47', '2025-01-10 15:32:47');

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `token` varchar(255) 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 `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `photo`, `password`, `token`, `created_at`, `updated_at`) VALUES
(1, 'Musa Shate', 'admin@gmail.com', 'admin_1740079305.jpg', '$2y$12$93Y8PbOWvjUFLQiyVnZYEe0FVgWc/6zYM4tnDSUQuFmnVWHTswp26', '', '2025-01-10 15:32:47', '2025-02-20 18:21:45');

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) 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 `amenities`
--

INSERT INTO `amenities` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Swimming Pool', '2025-01-11 17:12:03', '2025-01-11 17:12:03'),
(2, 'Free Wifi', '2025-01-11 17:12:14', '2025-01-11 17:12:14'),
(3, 'Gym', '2025-01-11 17:12:20', '2025-01-11 17:12:20'),
(4, 'Personal Guide', '2025-01-11 17:12:33', '2025-01-11 17:12:33'),
(5, 'Free Transportation', '2025-01-11 17:12:52', '2025-01-11 17:12:52'),
(6, 'Accommodation', '2025-01-13 19:08:36', '2025-01-13 19:08:36'),
(7, 'Personalized Travel Planning', '2025-01-13 19:09:07', '2025-01-13 19:09:07'),
(8, 'All-Inclusive Resort Packages', '2025-01-13 19:09:23', '2025-01-13 19:09:23'),
(9, 'Travel Insurance Coverage', '2025-01-13 19:09:36', '2025-01-13 19:09:36'),
(10, 'Car Rentals', '2025-01-13 19:09:59', '2025-01-13 19:09:59');

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) 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 `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(2, 'Turkey', 'blogistanbul', '2025-01-13 19:54:50', '2025-01-13 19:59:08');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tour_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `total_person` int(11) NOT NULL,
  `paid_amount` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `payment_status` varchar(255) DEFAULT NULL,
  `invoice_no` varchar(255) 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 `bookings`
--

INSERT INTO `bookings` (`id`, `tour_id`, `package_id`, `user_id`, `total_person`, `paid_amount`, `payment_method`, `payment_status`, `invoice_no`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 1, 1, '500', 'Stripe', 'Completed', '1738676326', '2025-02-04 12:38:46', '2025-02-04 12:38:46'),
(2, 2, 2, 1, 5, '2500', 'Stripe', 'Completed', '1739635476', '2025-02-15 15:04:36', '2025-02-15 15:04:36'),
(3, 2, 2, 1, 2, '1000', 'Stripe', 'Completed', '1739635715', '2025-02-15 15:08:35', '2025-02-15 15:08:35'),
(4, 2, 2, 2, 2, '500', 'Cash', 'Pending', '1740092049', '2025-02-20 21:54:09', '2025-02-20 21:54:09'),
(5, 2, 2, 2, 2, '1000', 'Stripe', 'Completed', '1740092127', '2025-02-20 21:55:27', '2025-02-20 21:55:27'),
(6, 2, 2, 2, 4, '2000', 'Stripe', 'Completed', '1740092478', '2025-02-20 22:01:18', '2025-02-20 22:01:18'),
(7, 3, 3, 2, 3, '900', 'Stripe', 'Completed', '1740094812', '2025-02-20 22:40:12', '2025-02-20 22:40:12'),
(8, 4, 4, 1, 1, '250', 'Stripe', 'Completed', '1748360246', '2025-05-27 13:37:26', '2025-05-27 13:37:26');

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

--
-- 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 `contact_items`
--

CREATE TABLE `contact_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `map_code` 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 `contact_items`
--

INSERT INTO `contact_items` (`id`, `map_code`, `created_at`, `updated_at`) VALUES
(1, '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d48044.783556670984!2d20.6807753!3d41.18255165000001!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1350e73de5f937d3%3A0x6aa0d08129c86a44!2sStruga!5e0!3m2!1sen!2smk!4v1736798363221!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '2025-01-10 15:32:47', '2025-01-13 18:59:33');

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

--
-- Table structure for table `counter_items`
--

CREATE TABLE `counter_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `item1_number` varchar(255) DEFAULT NULL,
  `item1_text` varchar(255) DEFAULT NULL,
  `item2_number` varchar(255) DEFAULT NULL,
  `item2_text` varchar(255) DEFAULT NULL,
  `item3_number` varchar(255) DEFAULT NULL,
  `item3_text` varchar(255) DEFAULT NULL,
  `item4_number` varchar(255) DEFAULT NULL,
  `item4_text` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `counter_items`
--

INSERT INTO `counter_items` (`id`, `item1_number`, `item1_text`, `item2_number`, `item2_text`, `item3_number`, `item3_text`, `item4_number`, `item4_text`, `status`, `created_at`, `updated_at`) VALUES
(1, '40', 'Destinations', '1200', 'Clients', '130', 'Packages', '60', 'Feedbacks', 'Show', '2025-01-10 15:32:47', '2025-01-10 15:32:47');

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

--
-- Table structure for table `destinations`
--

CREATE TABLE `destinations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `visa_requirement` text DEFAULT NULL,
  `activity` text DEFAULT NULL,
  `best_time` text DEFAULT NULL,
  `health_safety` text DEFAULT NULL,
  `map` text DEFAULT NULL,
  `featured_photo` varchar(255) DEFAULT NULL,
  `view_count` int(11) 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 `destinations`
--

INSERT INTO `destinations` (`id`, `name`, `slug`, `description`, `country`, `language`, `currency`, `area`, `timezone`, `visa_requirement`, `activity`, `best_time`, `health_safety`, `map`, `featured_photo`, `view_count`, `created_at`, `updated_at`) VALUES
(1, 'Australia', 'australia', '<p>Australia, the land Down Under, is a vast and diverse country known for its unique wildlife, stunning landscapes, and vibrant cities. From the iconic Sydney Opera House and Great Barrier Reef to the rugged Outback and lush rainforests, Australia offers endless opportunities for exploration. Visitors can enjoy world-class surfing, scuba diving, and hiking, or immerse themselves in the rich Indigenous culture and modern cosmopolitan life. With its laid-back atmosphere and incredible natural beauty, Australia is a dream destination for adventurers and relaxation seekers alike.</p>', 'Australia', 'English', 'Australian Dollar (AUD)', 'Approx 7.692 million km2', 'Australian Western Standard Time (AWST): UTC +8', '<p><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Visa in not needed for EU citizens. Everyone else needs a visa.</span></p>', '<p><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Surfing,</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Scuba Diving,</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Hiking,</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Camping,</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Skydiving,</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Wildlife Safari</span></p>', '<p><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Spring (September to November) and Autumn (March to May)</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Summer (December to February)</span><br style=\"box-sizing: border-box; color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\" /><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Winter (June to August)</span></p>', '<p><span style=\"color: #212529; font-family: Roboto, sans-serif; font-size: 16px; background-color: #ffffff;\">Stay hydrated, use sun protection, and be aware of wildlife safety guidelines.</span></p>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15264849.737523768!2d137.1313701951111!3d-25.200807913838023!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2b2bfd076787c5df%3A0x538267a1955b1352!2sAustralia!5e0!3m2!1sen!2smk!4v1736784637551!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', 'destination_featured_1736617604.jpg', 25, '2025-01-11 16:46:44', '2025-02-04 11:34:43'),
(2, 'Turkey', 'turkey', '<p>&nbsp;</p>\r\n<p>Turkey, where East meets West, is a fascinating country with a rich tapestry of cultures, history, and landscapes. From the bustling streets of Istanbul, home to the Hagia Sophia and the Blue Mosque, to the surreal landscapes of Cappadocia, Turkey offers something for every traveler. Visitors can relax on the turquoise coasts of Antalya, explore ancient ruins like Ephesus, or indulge in traditional Turkish delights and kebabs. With its warm hospitality and diverse attractions, Turkey seamlessly blends tradition with modernity.</p>', 'Istanbul', 'Turkish (official), English is commonly spoken in tourist areas.', 'Turkish Lira (TRY)', '783,562 km²', 'Turkey Time (TRT): UTC +3', '<p>Visa is not needed for EU citizens and many others for short stays. E-visas are available for several countries.</p>', '<ul>\r\n<li>Exploring historical sites (Hagia Sophia, Ephesus, Topkapi Palace)</li>\r\n<li>Hot air balloon rides in Cappadocia</li>\r\n<li>Visiting Pamukkale&rsquo;s thermal pools</li>\r\n<li>Beach activities in Antalya and Bodrum</li>\r\n<li>Turkish cuisine tasting</li>\r\n<li>Bosphorus cruises</li>\r\n<li>Skiing in Uludağ</li>\r\n</ul>', '<ul>\r\n<li>Spring (April to June) and Autumn (September to November) for mild weather and fewer crowds.</li>\r\n<li>Summer (June to August) for coastal destinations.</li>\r\n<li>Winter (December to February) for skiing and snow activities</li>\r\n</ul>', '<p>Drink bottled water, especially in rural areas. Follow food hygiene standards, and be cautious when swimming in open waters.</p>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d4711365.548773462!2d34.73732410819872!3d39.02954136122791!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x14b0155c964f2671%3A0x40d9dbd42a625f2a!2zVMO8cmtpeWU!5e0!3m2!1sen!2smk!4v1736786159623!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', 'destination_featured_1736721071.jpg', 11, '2025-01-12 21:05:47', '2025-05-27 07:43:41'),
(3, 'Greece', 'greece', '<p>Greece, the cradle of Western civilization, is a country where ancient history meets natural beauty. Renowned for its iconic ruins, including the Acropolis in Athens and the oracle of Delphi, it offers a glimpse into the world of the ancient Greeks. Greece boasts breathtaking islands like Santorini and Mykonos, turquoise beaches, and a rich culinary tradition featuring dishes like moussaka and baklava. Its warm Mediterranean climate, charming villages, and vibrant culture make it a top destination for travelers year-round.</p>', 'Greece', 'Greek (official), English is widely spoken in tourist areas.', 'Euro (EUR)', 'Approx 131,957 km²', 'Eastern European Time (EET): UTC +2', '<p>Visa is not needed for EU citizens and Schengen Area travelers. Citizens of many countries can visit visa-free for up to 90 days.</p>', '<p>&nbsp;</p>\r\n<ul>\r\n<li>Exploring ancient ruins (Acropolis, Delphi, Knossos)</li>\r\n<li>Island hopping (Santorini, Mykonos, Crete)</li>\r\n<li>Beaches and water sports</li>\r\n<li>Hiking in Meteora and Mount Olympus</li>\r\n<li>Sampling traditional Greek cuisine</li>\r\n<li>Sailing and yachting</li>\r\n<li>Visiting monasteries and historic churches</li>\r\n</ul>', '<p>&nbsp;</p>\r\n<ul>\r\n<li>Spring (April to June) and Autumn (September to October) for pleasant weather and fewer crowds.</li>\r\n<li>Summer (June to August) for beaches and island activities.</li>\r\n</ul>', '<p>&nbsp;</p>\r\n<p>Use sunscreen, stay hydrated, and be mindful of heat during summer. Follow local safety guidelines for swimming and hiking.</p>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3006757.0914311768!2d23.188903428298975!3d38.42700988129703!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x135b4ac711716c63%3A0x363a1775dc9a2d1d!2sGreece!5e0!3m2!1sen!2smk!4v1736790169182!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', 'destination_featured_1736721612.jpg', 2, '2025-01-12 21:40:12', '2025-01-13 16:47:38'),
(4, 'North Macedonia', 'northmacedonia', '<p>North Macedonia is a small yet culturally rich country located in the heart of the Balkans. Known for its stunning landscapes, ancient heritage, and warm hospitality, it offers visitors a mix of natural beauty and historical charm. From the serene waters of Lake Ohrid, one of Europe\'s oldest lakes, to the vibrant capital city of Skopje, North Macedonia blends traditional Balkan culture with modern influences.</p>', 'North Macedonia', 'Macedonian (official), Albanian (co-official in some regions), English is moderately spoken in urban areas and tourist locations.', 'Macedonian Denar (MKD)', '25,713 km²', 'Central European Time (CET): UTC +1', '<p>Visa is not needed for EU citizens and many other countries for short stays up to 90 days.</p>', '<p>&nbsp;</p>\r\n<ul>\r\n<li>Exploring Ohrid and its historic lake</li>\r\n<li>Visiting ancient sites like Heraclea Lyncestis</li>\r\n<li>Hiking in Mavrovo and Pelister National Parks</li>\r\n<li>Sampling traditional Macedonian cuisine</li>\r\n<li>Exploring Skopje&rsquo;s landmarks (Stone Bridge, Kale Fortress)</li>\r\n<li>Wine tasting in Tikve&scaron; region</li>\r\n<li>Boat trips on Lake Prespa</li>\r\n</ul>', '<ul>\r\n<li>Spring (April to June) and Autumn (September to October) for pleasant weather.</li>\r\n<li>Summer (June to August) for lakes and outdoor activities.</li>\r\n<li>Winter (December to February) for skiing in Mavrovo.</li>\r\n</ul>', '<p>&nbsp;</p>\r\n<p>Tap water is generally safe in cities, but bottled water is recommended in rural areas. Be prepared for varying road conditions if driving.</p>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d1539077.0164384148!2d20.916933516488044!3d41.112477089450564!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1354159f70bc4809%3A0xe0f25ad6c81fc5b1!2sNorth%20Macedonia!5e0!3m2!1sen!2smk!4v1736791453651!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', 'destination_featured_1736722108.jpg', 10, '2025-01-12 21:48:28', '2025-05-28 06:18:49');

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

--
-- Table structure for table `destination_photos`
--

CREATE TABLE `destination_photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destination_id` int(11) NOT NULL,
  `photo` varchar(255) 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 `destination_photos`
--

INSERT INTO `destination_photos` (`id`, `destination_id`, `photo`, `created_at`, `updated_at`) VALUES
(2, 1, 'destination_1736784325.jpg', '2025-01-13 15:05:25', '2025-01-13 15:05:25'),
(3, 1, 'destination_1736784336.jpg', '2025-01-13 15:05:36', '2025-01-13 15:05:36'),
(4, 1, 'destination_1736784341.jpg', '2025-01-13 15:05:41', '2025-01-13 15:05:41'),
(5, 1, 'destination_1736784592.jpg', '2025-01-13 15:09:52', '2025-01-13 15:09:52'),
(9, 2, 'destination_1736789750.jpg', '2025-01-13 16:35:50', '2025-01-13 16:35:50'),
(10, 2, 'destination_1736789757.jpg', '2025-01-13 16:35:57', '2025-01-13 16:35:57'),
(11, 2, 'destination_1736789765.jpg', '2025-01-13 16:36:05', '2025-01-13 16:36:05'),
(12, 2, 'destination_1736789773.jpg', '2025-01-13 16:36:13', '2025-01-13 16:36:13'),
(13, 3, 'destination_1736790354.jpg', '2025-01-13 16:45:54', '2025-01-13 16:45:54'),
(14, 3, 'destination_1736790361.jpg', '2025-01-13 16:46:01', '2025-01-13 16:46:01'),
(15, 3, 'destination_1736790368.jpg', '2025-01-13 16:46:08', '2025-01-13 16:46:08'),
(16, 3, 'destination_1736790375.jpg', '2025-01-13 16:46:15', '2025-01-13 16:46:15'),
(17, 4, 'destination_1736791719.jpg', '2025-01-13 17:08:39', '2025-01-13 17:08:39'),
(18, 4, 'destination_1736791733.jpg', '2025-01-13 17:08:53', '2025-01-13 17:08:53'),
(19, 4, 'destination_1736791739.jpg', '2025-01-13 17:08:59', '2025-01-13 17:08:59'),
(20, 4, 'destination_1736791746.jpg', '2025-01-13 17:09:06', '2025-01-13 17:09:06');

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

--
-- Table structure for table `destination_videos`
--

CREATE TABLE `destination_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destination_id` int(11) NOT NULL,
  `video` varchar(255) 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 `destination_videos`
--

INSERT INTO `destination_videos` (`id`, `destination_id`, `video`, `created_at`, `updated_at`) VALUES
(1, 1, 'gd6eliMgE6o', '2025-01-11 17:02:33', '2025-01-11 17:02:33'),
(2, 1, 'bQmzk05I3nw', '2025-01-13 15:21:58', '2025-01-13 15:21:58'),
(3, 2, 'kdBYvYJHyWM', '2025-01-13 16:37:09', '2025-01-13 16:37:09'),
(5, 2, '2vqvBzb0xJY', '2025-01-13 16:38:18', '2025-01-13 16:38:18'),
(6, 3, 'lepdqiCF-W8', '2025-01-13 16:46:55', '2025-01-13 16:46:55'),
(7, 3, '4zAEDLwl9HI', '2025-01-13 16:47:32', '2025-01-13 16:47:32'),
(8, 4, 'sRVL5k2lAFE', '2025-01-13 17:09:34', '2025-01-13 17:09:34'),
(9, 4, 'XdZtCujYMvw', '2025-01-13 17:09:50', '2025-01-13 17:09:50');

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

--
-- 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 `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) DEFAULT NULL,
  `answer` 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 `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(1, 'How to book a travel package online?', 'To book a travel package online, browse through our website’s offerings, select your desired destination and dates, and follow the prompts to customize your trip. Once you have chosen your options, proceed to the checkout page, enter your details, and make the payment securely. You will receive a confirmation email with your itinerary and booking details.', '2025-01-11 16:22:05', '2025-01-11 16:22:05'),
(2, 'What is included in travel packages?', 'Our travel packages typically include accommodation, transportation, and selected activities or tours. Some packages may also offer meals, travel insurance, and airport transfers. Each package is designed to provide a comprehensive travel experience, but you can always customize your package to include additional services or specific requests. Please check the package details for exact inclusions.', '2025-01-11 16:34:47', '2025-01-11 16:34:47'),
(3, 'Are there any travel discounts available?', 'Yes, we offer various travel discounts throughout the year, including early bird specials, last-minute deals, and seasonal promotions. To stay updated on our latest discounts, subscribe to our newsletter, follow us on social media, or check the “Deals” section of our website. We aim to provide affordable travel options without compromising quality.', '2025-01-11 16:35:13', '2025-01-11 16:35:51'),
(4, 'How to cancel or modify bookings?', 'To cancel or modify a booking, log into your account on our website and go to the “My Bookings” section. Here, you can view your current reservations and follow the prompts to make changes or cancellations. Please note that cancellation policies and modification fees may apply, depending on the terms and conditions of your booking. Contact our customer support for assistance if needed.', '2025-01-11 16:35:44', '2025-01-11 16:35:44');

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `description` 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 `features`
--

INSERT INTO `features` (`id`, `icon`, `heading`, `description`, `created_at`, `updated_at`) VALUES
(1, 'fas fa-briefcase', 'Explore Destinations', 'Discover amazing places to visit, from bustling cities to serene beaches, and plan your perfect adventure with our expert guides.', '2025-01-11 11:55:49', '2025-01-11 11:55:49'),
(2, 'fas fa-search', 'Custom Travel Packages', 'Create custom travel packages designed to your accommodations, activities & transportation for a smooth journey.', '2025-01-11 11:56:41', '2025-01-11 11:56:41'),
(3, 'fas fa-share-alt', 'Travel Deals & Discounts', 'Take advantage of our exclusive travel deals and discounts, ensuring you get the best value for your dream vacation.', '2025-01-11 11:57:11', '2025-01-11 11:57:11');

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

--
-- Table structure for table `home_items`
--

CREATE TABLE `home_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destination_heading` text DEFAULT NULL,
  `destination_subheading` text DEFAULT NULL,
  `destination_status` text DEFAULT NULL,
  `feature_status` text DEFAULT NULL,
  `package_heading` text DEFAULT NULL,
  `package_subheading` text DEFAULT NULL,
  `package_status` text DEFAULT NULL,
  `testimonial_heading` text DEFAULT NULL,
  `testimonial_subheading` text DEFAULT NULL,
  `testimonial_background` text DEFAULT NULL,
  `testimonial_status` text DEFAULT NULL,
  `blog_heading` text DEFAULT NULL,
  `blog_subheading` text DEFAULT NULL,
  `blog_status` 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 `home_items`
--

INSERT INTO `home_items` (`id`, `destination_heading`, `destination_subheading`, `destination_status`, `feature_status`, `package_heading`, `package_subheading`, `package_status`, `testimonial_heading`, `testimonial_subheading`, `testimonial_background`, `testimonial_status`, `blog_heading`, `blog_subheading`, `blog_status`, `created_at`, `updated_at`) VALUES
(1, 'Popular Destinations', 'Explore our most popular travel destinations around the world', 'Show', 'Show', 'Popular Packages', 'Explore our most popular travel packages around the world', 'Show', 'Client Testimonials', 'See what our clients have to say about their experience with us', 'testimonial_background_1736797450.jpg', 'Show', 'Latest News', 'Check out the latest news and updates from our blog post', 'Show', '2025-01-10 15:32:47', '2025-01-13 18:44:10');

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

--
-- 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 `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT 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 `messages`
--

INSERT INTO `messages` (`id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2025-01-11 20:54:51', '2025-01-11 20:54:51'),
(2, 2, '2025-02-20 17:29:40', '2025-02-20 17:29:40');

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

--
-- Table structure for table `message_comments`
--

CREATE TABLE `message_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `message_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `comment` text NOT 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 `message_comments`
--

INSERT INTO `message_comments` (`id`, `message_id`, `sender_id`, `type`, `comment`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'User', 'I have problem with payment?', '2025-02-15 15:41:36', '2025-02-15 15:41:36'),
(2, 2, 2, 'User', 'Do you offer any travel packages for North Macedonia in June?\"', '2025-02-20 17:47:38', '2025-02-20 17:47:38'),
(3, 2, 2, 'User', 'Hi, I\'m planning a trip to Italy next summer and would love some recommendations. Can you help me with a customized itinerary, including flights, hotels, and must-visit attractions? Also, do you offer any guided tours or special packages for first-time visitors?', '2025-02-20 21:49:10', '2025-02-20 21:49:10');

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

--
-- 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, '2024_06_03_094105_create_admins_table', 1),
(5, '2024_07_05_042854_create_sliders_table', 1),
(6, '2024_07_06_135626_create_welcome_items_table', 1),
(7, '2024_07_06_144401_create_features_table', 1),
(8, '2024_07_06_151550_create_counter_items_table', 1),
(9, '2024_07_06_161550_create_testimonials_table', 1),
(10, '2024_07_06_235532_create_team_members_table', 1),
(11, '2024_07_07_011132_create_faqs_table', 1),
(12, '2024_07_07_014641_create_blog_categories_table', 1),
(13, '2024_07_07_021516_create_posts_table', 1),
(14, '2024_07_07_083444_create_destinations_table', 1),
(15, '2024_07_07_122952_create_destination_photos_table', 1),
(16, '2024_07_07_165917_create_destination_videos_table', 1),
(17, '2024_07_08_003005_create_packages_table', 1),
(18, '2024_07_08_094141_create_amenities_table', 1),
(19, '2024_07_08_100244_create_package_amenities_table', 1),
(20, '2024_07_08_114905_create_package_itineraries_table', 1),
(21, '2024_07_08_123238_create_package_photos_table', 1),
(22, '2024_07_08_182407_create_package_videos_table', 1),
(23, '2024_07_09_032902_create_package_faqs_table', 1),
(24, '2024_07_09_090045_create_tours_table', 1),
(25, '2024_07_09_103000_create_bookings_table', 1),
(26, '2024_07_10_060338_create_reviews_table', 1),
(27, '2024_07_11_235532_create_wishlists_table', 1),
(28, '2024_07_12_025241_create_messages_table', 1),
(29, '2024_07_12_025342_create_message_comments_table', 1),
(30, '2024_07_12_043848_create_subscribers_table', 1),
(31, '2024_07_12_090352_create_home_items_table', 1),
(32, '2024_07_12_115523_create_about_items_table', 1),
(33, '2024_07_12_121009_create_contact_items_table', 1),
(34, '2024_07_12_122841_create_term_privacy_items_table', 1),
(35, '2024_07_12_172936_create_settings_table', 1);

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destination_id` int(11) NOT NULL,
  `featured_photo` varchar(255) DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `map` text DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `old_price` varchar(255) DEFAULT NULL,
  `total_rating` int(11) NOT NULL,
  `total_score` int(11) NOT 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 `packages`
--

INSERT INTO `packages` (`id`, `destination_id`, `featured_photo`, `banner`, `name`, `slug`, `description`, `map`, `price`, `old_price`, `total_rating`, `total_score`, `created_at`, `updated_at`) VALUES
(2, 2, 'package_featured_1736799377.jpg', 'package_banner_1736799377.jpg', 'Istanbul', 'Istanbul', '<p>Istanbul, the vibrant cultural and historical hub of Turkey, uniquely straddles two continents&mdash;Europe and Asia&mdash;separated by the stunning Bosphorus Strait. The city is a treasure trove of historical landmarks, including the iconic Hagia Sophia, the Blue Mosque, and the Topkapi Palace, which reflect its rich Byzantine and Ottoman heritage. The bustling Grand Bazaar and the Spice Bazaar offer an immersive experience into Turkey\'s colorful markets and local craftsmanship.</p>\r\n<p>Istanbul\'s dynamic atmosphere is complemented by its culinary delights, such as kebabs, baklava, and Turkish tea, which are best enjoyed in traditional cafes and street-side eateries. Visitors can also take a relaxing Bosphorus cruise to witness the city&rsquo;s skyline, blending ancient architecture with modern skyscrapers. Its unique position and rich cultural tapestry make Istanbul a must-visit destination.</p>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d385396.6059676668!2d29.01217945!3d41.0053215!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x14caa7040068086b%3A0xe1ccfe98bc01b0d0!2zxLBzdGFuYnVsLCBUw7xya2l5ZQ!5e0!3m2!1sen!2smk!4v1736800043126!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '500', '850', 2, 7, '2025-01-13 19:16:17', '2025-02-20 22:45:25'),
(3, 4, 'package_featured_1740066415.jpg', 'package_banner_1740066415.jpg', 'Ohrid', 'ohrid', '<div class=\"pointer-events-none h-px w-px\" aria-hidden=\"true\" data-edge=\"true\">&nbsp;</div>\r\n<article class=\"w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]\" dir=\"auto\" data-testid=\"conversation-turn-37\" data-scroll-anchor=\"true\">\r\n<div class=\"m-auto text-base py-[18px] px-6\">\r\n<div class=\"mx-auto flex flex-1 text-base gap-4 md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\r\n<div class=\"group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn @xs/thread:px-0 @sm/thread:px-1.5 @md/thread:px-4\">\r\n<div class=\"flex-col gap-1 md:gap-3\">\r\n<div class=\"flex max-w-full flex-col flex-grow\">\r\n<div class=\"min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words text-start [.text-message+&amp;]:mt-5\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"d38c5a14-f55b-4051-9322-659ae5d8fb99\" data-message-model-slug=\"gpt-4o\">\r\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\r\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\r\n<p data-start=\"0\" data-end=\"63\"><strong data-start=\"0\" data-end=\"61\">Discover the Beauty of Ohrid: A Hidden Gem of the Balkans</strong></p>\r\n<p data-start=\"65\" data-end=\"521\" data-is-last-node=\"\" data-is-only-node=\"\">Explore the enchanting city of Ohrid, a UNESCO World Heritage Site known for its stunning lake, rich history, and picturesque landscapes. This travel package includes guided tours of ancient churches, the medieval Samuel&rsquo;s Fortress, and the scenic Ohrid Lake. Enjoy boat trips, traditional Macedonian cuisine, and breathtaking sunset views. Perfect for history lovers and nature enthusiasts, this trip promises a blend of relaxation and cultural discovery.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</article>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d48095.0023678069!2d20.750683937965686!3d41.11405279739578!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1350db6587ea6657%3A0xc46cfc65390bc9d3!2sOhrid!5e0!3m2!1sen!2smk!4v1740066253942!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '300', '450', 1, 5, '2025-02-20 14:46:55', '2025-02-20 22:43:05'),
(4, 4, 'package_featured_1740097717.jpg', 'package_banner_1740097717.jpg', 'Struga', 'struga', '<div class=\"pointer-events-none h-px w-px\" aria-hidden=\"true\" data-edge=\"true\"><strong style=\"font-family: -apple-system, BlinkMacSystemFont, \'Segoe UI\', Roboto, Oxygen, Ubuntu, Cantarell, \'Open Sans\', \'Helvetica Neue\', sans-serif;\" data-start=\"0\" data-end=\"65\">Experience the Charm of Struga: The City of Poetry and Rivers</strong></div>\r\n<article class=\"w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]\" dir=\"auto\" data-testid=\"conversation-turn-43\" data-scroll-anchor=\"true\">\r\n<div class=\"m-auto text-base py-[18px] px-6\">\r\n<div class=\"mx-auto flex flex-1 text-base gap-4 md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\r\n<div class=\"group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn @xs/thread:px-0 @sm/thread:px-1.5 @md/thread:px-4\">\r\n<div class=\"flex-col gap-1 md:gap-3\">\r\n<div class=\"flex max-w-full flex-col flex-grow\">\r\n<div class=\"min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words text-start [.text-message+&amp;]:mt-5\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"fc7f53f4-0a49-4ee1-a7a9-77d54c386893\" data-message-model-slug=\"gpt-4o\">\r\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\r\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\r\n<p data-start=\"69\" data-end=\"544\" data-is-last-node=\"\" data-is-only-node=\"\">Discover the tranquil beauty of Struga, a picturesque town on the shores of <strong data-start=\"145\" data-end=\"159\">Lake Ohrid</strong>. This package includes visits to the <strong data-start=\"197\" data-end=\"219\">Drim River springs</strong>, the famous <strong data-start=\"232\" data-end=\"249\">Poetry Bridge</strong>, and the serene <strong data-start=\"266\" data-end=\"288\">Kalishta Monastery</strong>. Enjoy a relaxing boat ride, explore traditional markets, and savor authentic Macedonian cuisine. Perfect for travelers seeking a mix of nature, culture, and relaxation, Struga offers a peaceful retreat with stunning landscapes and a rich poetic heritage.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</article>', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d96089.61019806554!2d20.59837447154448!3d41.182522286124154!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1350e73de5f937d3%3A0x6aa0d08129c86a44!2sStruga!5e0!3m2!1sen!2smk!4v1740097649957!5m2!1sen!2smk\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '250', '350', 0, 0, '2025-02-20 23:28:12', '2025-02-25 22:54:14');

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

--
-- Table structure for table `package_amenities`
--

CREATE TABLE `package_amenities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `amenity_id` int(11) NOT NULL,
  `type` varchar(255) 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 `package_amenities`
--

INSERT INTO `package_amenities` (`id`, `package_id`, `amenity_id`, `type`, `created_at`, `updated_at`) VALUES
(9, 2, 8, 'Include', '2025-01-13 19:16:39', '2025-01-13 19:16:39'),
(10, 2, 5, 'Include', '2025-01-13 19:16:44', '2025-01-13 19:16:44'),
(11, 2, 2, 'Include', '2025-01-13 19:16:48', '2025-01-13 19:16:48'),
(12, 2, 3, 'Include', '2025-01-13 19:16:51', '2025-01-13 19:16:51'),
(13, 2, 7, 'Include', '2025-01-13 19:16:56', '2025-01-13 19:16:56'),
(14, 2, 1, 'Exclude', '2025-01-13 19:17:03', '2025-01-13 19:17:03'),
(16, 2, 6, 'Include', '2025-01-13 19:17:17', '2025-01-13 19:17:17'),
(17, 2, 9, 'Exclude', '2025-01-13 19:17:33', '2025-01-13 19:17:33'),
(18, 3, 2, 'Include', '2025-02-20 14:49:37', '2025-02-20 14:49:37'),
(19, 3, 7, 'Include', '2025-02-20 14:49:53', '2025-02-20 14:49:53'),
(20, 3, 5, 'Include', '2025-02-20 14:49:58', '2025-02-20 14:49:58'),
(21, 3, 6, 'Include', '2025-02-20 14:50:04', '2025-02-20 14:50:04'),
(22, 3, 8, 'Exclude', '2025-02-20 14:50:13', '2025-02-20 14:50:13'),
(23, 3, 1, 'Exclude', '2025-02-20 14:50:19', '2025-02-20 14:50:19');

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

--
-- Table structure for table `package_faqs`
--

CREATE TABLE `package_faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `question` varchar(255) DEFAULT NULL,
  `answer` 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 `package_faqs`
--

INSERT INTO `package_faqs` (`id`, `package_id`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(1, 2, 'What is the best time to visit Istanbul?', 'The best time to visit Istanbul is during spring (April to June) and autumn (September to November) when the weather is mild and ideal for sightseeing. Summer can be hot and crowded, while winter is colder but less busy.', '2025-01-13 19:23:45', '2025-01-13 19:23:45'),
(2, 2, 'Is Istanbul safe for tourists?', 'Yes, Istanbul is generally safe for tourists. However, like in any major city, you should remain cautious of pickpockets in crowded areas and take standard travel precautions.', '2025-01-13 19:24:06', '2025-01-13 19:24:06'),
(3, 3, 'What is the best time to visit Ohrid?', 'The best time to visit is from May to September when the weather is warm, and you can enjoy the lake and outdoor activities.', '2025-02-20 15:45:55', '2025-02-20 15:45:55'),
(4, 3, 'How can I get to Ohrid?', 'You can reach Ohrid by flight via Ohrid St. Paul the Apostle Airport, by bus from major Balkan cities, or by car.', '2025-02-20 15:46:17', '2025-02-20 15:46:17'),
(5, 3, 'What are the must-visit attractions in Ohrid?', 'Top attractions include Lake Ohrid, Samuel’s Fortress, St. Naum Monastery, and the Ancient Theatre of Ohrid.', '2025-02-20 15:46:28', '2025-02-20 15:46:28');

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

--
-- Table structure for table `package_itineraries`
--

CREATE TABLE `package_itineraries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` 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 `package_itineraries`
--

INSERT INTO `package_itineraries` (`id`, `package_id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(2, 2, 'Day 1', '<p><strong>Morning:</strong></p>\r\n<ol>\r\n<li>Arrive in Istanbul and check into your hotel.</li>\r\n<li>Welcome meeting with your tour guide and fellow travelers at the hotel.</li>\r\n<li>Brief introduction to Istanbul\'s history and culture.</li>\r\n</ol>\r\n<p><strong>Afternoon:</strong></p>\r\n<ol>\r\n<li>Lunch at a traditional Turkish restaurant.</li>\r\n<li>Explore the historic Sultanahmet district, visiting:\r\n<ul>\r\n<li><strong>Hagia Sophia</strong>: Marvel at the grandeur of this architectural masterpiece.</li>\r\n<li><strong>Blue Mosque</strong>: Admire the stunning blue tiles and Ottoman architecture.</li>\r\n</ul>\r\n</li>\r\n<li>Visit the <strong>Hippodrome</strong> and learn about its historical significance.</li>\r\n</ol>', '2025-01-13 19:19:34', '2025-01-13 19:19:34'),
(6, 2, 'Day 2', '<p><strong>Morning:</strong></p>\r\n<ol>\r\n<li>Breakfast at the hotel.</li>\r\n<li>Depart for a guided tour of <strong>Topkapi Palace</strong>, the former residence of Ottoman sultans.</li>\r\n<li>Visit the <strong>Basilica Cistern</strong>, an underground marvel of Byzantine engineering.</li>\r\n</ol>\r\n<p><strong>Afternoon:</strong></p>\r\n<p>&nbsp;</p>\r\n<ol>\r\n<li>Lunch at a restaurant specializing in Turkish kebabs and mezes.</li>\r\n<li>Explore the bustling <strong>Grand Bazaar</strong>, one of the largest and oldest covered markets in the world.</li>\r\n<li>Optional stop at the <strong>Spice Bazaar</strong> for aromatic spices, teas, and local sweets.</li>\r\n</ol>', '2025-01-13 19:22:34', '2025-01-13 19:22:34'),
(7, 2, 'Day 3', '<p><strong>Morning:</strong></p>\r\n<ol>\r\n<li>Breakfast at the hotel.</li>\r\n<li>Take a ferry to the Asian side of Istanbul and visit <strong>Kadık&ouml;y</strong>:\r\n<ul>\r\n<li>Stroll through the local markets.</li>\r\n<li>Visit the <strong>Moda District</strong> for a more modern vibe.</li>\r\n</ul>\r\n</li>\r\n<li>Tour the <strong>&Ccedil;amlıca Hill</strong> for panoramic views of the city.</li>\r\n</ol>\r\n<p><strong>Afternoon:</strong></p>\r\n<p>&nbsp;</p>\r\n<ol>\r\n<li>Lunch at a waterfront restaurant along the Bosphorus.</li>\r\n<li>Return to the European side to visit <strong>Dolmabah&ccedil;e Palace</strong>, a symbol of modern Ottoman luxury.</li>\r\n</ol>', '2025-01-13 19:35:19', '2025-01-13 19:35:19'),
(9, 3, 'Day 1', '<h3 data-start=\"63\" data-end=\"119\"><strong data-start=\"67\" data-end=\"117\">Discovering Ohrid&rsquo;s History and Culture</strong></h3>\r\n<p data-start=\"120\" data-end=\"134\"><strong data-start=\"120\" data-end=\"132\">Morning:</strong></p>\r\n<ul data-start=\"135\" data-end=\"383\">\r\n<li data-start=\"135\" data-end=\"181\">Arrive in Ohrid and check into your hotel.</li>\r\n<li data-start=\"182\" data-end=\"292\">Start your day with a guided tour of <strong data-start=\"221\" data-end=\"242\">Samuel&rsquo;s Fortress</strong>, offering panoramic views of the city and lake.</li>\r\n<li data-start=\"293\" data-end=\"383\">Visit the <strong data-start=\"305\" data-end=\"329\">Church of St. Sophia</strong>, one of Ohrid&rsquo;s most significant medieval churches.</li>\r\n</ul>\r\n<p data-start=\"385\" data-end=\"401\"><strong data-start=\"385\" data-end=\"399\">Afternoon:</strong></p>\r\n<ul data-start=\"402\" data-end=\"641\">\r\n<li data-start=\"402\" data-end=\"468\">Enjoy a traditional Macedonian lunch at a lakeside restaurant.</li>\r\n<li data-start=\"469\" data-end=\"551\">Explore the <strong data-start=\"483\" data-end=\"511\">Ancient Theatre of Ohrid</strong>, a well-preserved Roman amphitheater.</li>\r\n<li data-start=\"552\" data-end=\"641\">Stroll through the old town&rsquo;s charming cobbled streets and visit local artisan shops.</li>\r\n</ul>\r\n<p data-start=\"643\" data-end=\"657\"><strong data-start=\"643\" data-end=\"655\">Evening:</strong></p>\r\n<ul data-start=\"658\" data-end=\"838\">\r\n<li data-start=\"658\" data-end=\"717\">Relax with a scenic sunset boat ride on <strong data-start=\"700\" data-end=\"714\">Lake Ohrid</strong>.</li>\r\n<li data-start=\"718\" data-end=\"838\">Dinner at a local restaurant, trying specialties like <strong data-start=\"774\" data-end=\"790\">Tavče Gravče</strong> (Macedonian baked beans) and <strong data-start=\"820\" data-end=\"835\">Ohrid trout</strong>.</li>\r\n</ul>', '2025-02-20 14:53:47', '2025-02-20 14:53:47'),
(10, 3, 'Day 2', '<h3 data-start=\"63\" data-end=\"119\"><strong data-start=\"67\" data-end=\"117\">Discovering Ohrid&rsquo;s History and Culture</strong></h3>\r\n<p data-start=\"120\" data-end=\"134\"><strong data-start=\"120\" data-end=\"132\">Morning:</strong></p>\r\n<ul data-start=\"135\" data-end=\"383\">\r\n<li data-start=\"135\" data-end=\"181\">Arrive in Ohrid and check into your hotel.</li>\r\n<li data-start=\"182\" data-end=\"292\">Start your day with a guided tour of <strong data-start=\"221\" data-end=\"242\">Samuel&rsquo;s Fortress</strong>, offering panoramic views of the city and lake.</li>\r\n<li data-start=\"293\" data-end=\"383\">Visit the <strong data-start=\"305\" data-end=\"329\">Church of St. Sophia</strong>, one of Ohrid&rsquo;s most significant medieval churches.</li>\r\n</ul>\r\n<p data-start=\"385\" data-end=\"401\"><strong data-start=\"385\" data-end=\"399\">Afternoon:</strong></p>\r\n<ul data-start=\"402\" data-end=\"641\">\r\n<li data-start=\"402\" data-end=\"468\">Enjoy a traditional Macedonian lunch at a lakeside restaurant.</li>\r\n<li data-start=\"469\" data-end=\"551\">Explore the <strong data-start=\"483\" data-end=\"511\">Ancient Theatre of Ohrid</strong>, a well-preserved Roman amphitheater.</li>\r\n<li data-start=\"552\" data-end=\"641\">Stroll through the old town&rsquo;s charming cobbled streets and visit local artisan shops.</li>\r\n</ul>\r\n<p data-start=\"643\" data-end=\"657\"><strong data-start=\"643\" data-end=\"655\">Evening:</strong></p>\r\n<ul data-start=\"658\" data-end=\"838\">\r\n<li data-start=\"658\" data-end=\"717\">Relax with a scenic sunset boat ride on <strong data-start=\"700\" data-end=\"714\">Lake Ohrid</strong>.</li>\r\n<li data-start=\"718\" data-end=\"838\">Dinner at a local restaurant, trying specialties like <strong data-start=\"774\" data-end=\"790\">Tavče Gravče</strong> (Macedonian baked beans) and <strong data-start=\"820\" data-end=\"835\">Ohrid trout</strong>.</li>\r\n</ul>', '2025-02-20 14:54:09', '2025-02-20 14:54:09'),
(13, 4, 'Day 1', '<p data-start=\"61\" data-end=\"75\"><strong data-start=\"61\" data-end=\"73\">Morning:</strong></p>\r\n<ul data-start=\"76\" data-end=\"331\">\r\n<li data-start=\"76\" data-end=\"165\">Arrive in Struga and start the day with a scenic walk along the <strong data-start=\"142\" data-end=\"162\">Black Drim River</strong>.</li>\r\n<li data-start=\"166\" data-end=\"240\">Visit the <strong data-start=\"178\" data-end=\"195\">Poetry Bridge</strong>, a symbol of the town&rsquo;s literary heritage.</li>\r\n<li data-start=\"241\" data-end=\"331\">Explore the <strong data-start=\"255\" data-end=\"277\">Kalishta Monastery</strong>, a peaceful lakeside retreat with ancient frescoes.</li>\r\n</ul>\r\n<p data-start=\"333\" data-end=\"349\"><strong data-start=\"333\" data-end=\"347\">Afternoon:</strong></p>\r\n<ul data-start=\"350\" data-end=\"596\">\r\n<li data-start=\"350\" data-end=\"416\">Enjoy a traditional Macedonian lunch at a lakeside restaurant.</li>\r\n<li data-start=\"417\" data-end=\"503\">Take a <strong data-start=\"426\" data-end=\"453\">boat ride on Lake Ohrid</strong>, discovering the beauty of Struga&rsquo;s waterfront.</li>\r\n<li data-start=\"504\" data-end=\"596\">Stroll through the <strong data-start=\"525\" data-end=\"542\">Struga Bazaar</strong>, where you can shop for local crafts and souvenirs.</li>\r\n</ul>', '2025-02-22 21:49:28', '2025-02-22 21:49:28');

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

--
-- Table structure for table `package_photos`
--

CREATE TABLE `package_photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `photo` varchar(255) 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 `package_photos`
--

INSERT INTO `package_photos` (`id`, `package_id`, `photo`, `created_at`, `updated_at`) VALUES
(1, 2, 'package_1736799998.jpg', '2025-01-13 19:26:38', '2025-01-13 19:26:38'),
(3, 2, 'package_1736800202.jpg', '2025-01-13 19:30:02', '2025-01-13 19:30:02'),
(4, 2, 'package_1736800211.jpg', '2025-01-13 19:30:11', '2025-01-13 19:30:11'),
(5, 2, 'package_1736800382.jpg', '2025-01-13 19:33:02', '2025-01-13 19:33:02'),
(6, 3, 'package_1740070030.jpg', '2025-02-20 15:47:10', '2025-02-20 15:47:10'),
(7, 3, 'package_1740070130.jpg', '2025-02-20 15:48:50', '2025-02-20 15:48:50'),
(8, 3, 'package_1740070144.jpg', '2025-02-20 15:49:04', '2025-02-20 15:49:04');

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

--
-- Table structure for table `package_videos`
--

CREATE TABLE `package_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `video` varchar(255) 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 `package_videos`
--

INSERT INTO `package_videos` (`id`, `package_id`, `video`, `created_at`, `updated_at`) VALUES
(2, 2, 'r6YBIR2bMss', '2025-01-13 19:31:47', '2025-01-13 19:31:47'),
(3, 3, 'BBiZYJW7wbQ', '2025-02-20 15:50:04', '2025-02-20 15:50:04');

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

--
-- 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,
  `blog_category_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `photo` varchar(255) 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 `posts`
--

INSERT INTO `posts` (`id`, `blog_category_id`, `title`, `slug`, `short_description`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(2, 2, 'New travelers guide', 'blogistanbul', 'Begin your journey in the historic Sultanahmet district, home to the Hagia Sophia,explore the Topkapi Palace, once the opulent residence of Ottoman sultans, and marvel at its intricately decorated rooms and priceless artifacts. Don’t forget to descend into the Basilica Cistern, an underground marvel of Byzantine engineering with atmospheric lighting and ancient columns.', '<h3 data-pm-slice=\"1 3 []\"><strong>Practical Tips for Travelers</strong></h3>\r\n<ul data-spread=\"false\">\r\n<li>\r\n<p><strong>Best Time to Visit:</strong> Spring (April to June) and autumn (September to November) offer pleasant weather and fewer crowds.</p>\r\n</li>\r\n<li>\r\n<p><strong>Getting Around:</strong> Istanbul has an efficient public transport system, including trams, ferries, and buses. Walking is also a great way to explore its neighborhoods.</p>\r\n</li>\r\n<li>\r\n<p><strong>Currency:</strong> The local currency is the Turkish Lira (TRY). Credit cards are widely accepted, but it&rsquo;s good to carry cash for smaller vendors.</p>\r\n</li>\r\n</ul>', 'post_1736801794.jpg', '2025-01-13 19:56:34', '2025-01-13 20:04:16');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `comment` 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 `reviews`
--

INSERT INTO `reviews` (`id`, `user_id`, `package_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 4, 'We had fun, everything was ok, flight delayed that\'s why 4 star', '2025-02-15 15:43:45', '2025-02-15 15:43:45'),
(2, 2, 3, 5, 'I recently had the pleasure of taking a guided tour of Ohrid, and it was absolutely fantastic! From start to finish, everything was perfectly organized, and the experience exceeded my expectations.', '2025-02-20 22:43:05', '2025-02-20 22:43:05'),
(3, 2, 2, 3, 'The Istanbul tour was a mixed experience for me. While I enjoyed visiting iconic landmarks like the Hagia Sophia, Blue Mosque, and Grand Bazaar, there were some aspects that could have been better.On the positive side, the food recommendations were great, and Istanbul itself is a breathtaking city with so much history and culture. If the tour was better paced and more organized, it would have been a 5-star experience.\r\nOverall, it was an average tour—good for first-time visitors but with room for improvement.', '2025-02-20 22:45:24', '2025-02-20 22:45:24');

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

--
-- 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
('5iuKb04rdq45xPWmyBA7G3LFK0WbT1Axpr7X1L6x', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTDdJajhMY3hGdDlGbjJieDZVcFozaUs3S0NwRTlMTzZLVHM1TktLTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9wYWNrYWdlL3N0cnVnYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTI6ImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1749555182),
('88QV3YbT2EYF9nbUODkI0V1ovDL5shXEPTMC8ekD', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSFNOQmdXY0FUa0hHem1PWXJYTGxvWkt6TzFKTUR3MDVnQ21Ud0RFNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHA6Ly90cmF2ZWxzeXN0ZW1fbGFyYXZlbC50ZXN0Lz9oZXJkPXByZXZpZXciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1764187479),
('aklfF4tUdlYiKIYf0cI3mo8HN1sLJ0Bxu0QSFamu', 1, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUTBaaG5lZWp3cFYzdG0wZ0JNS29TeGZTSVZ5ZHRPYWpwWE1WdUZPZCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9kYXNoYm9hcmQiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6NTI6ImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1748420686),
('dvsTz39OGHqJ2TFGRaRhrrtmxNN0l6oUHNczhLQz', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWUliZVg3dTljUXRQOXNGdVdDUDRYY1JtcWZ1ZXBVNWlmNHhRSGtTWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUyOiJsb2dpbl9hZG1pbl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1758755057),
('NCbFgR20NrimVY9cl84pvj4IFkkqTV6EJRc6kW5Q', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMmlKTUxmWDhFSjBXbjJhU3Y3MnFPMFhlRkRPdTFzSFczMXJnNmVXeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHA6Ly90cmF2ZWxzeXN0ZW1fbGFyYXZlbC50ZXN0Lz9oZXJkPXByZXZpZXciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1765293188);

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `top_bar_phone` varchar(255) DEFAULT NULL,
  `top_bar_email` varchar(255) DEFAULT NULL,
  `footer_address` varchar(255) DEFAULT NULL,
  `footer_phone` varchar(255) DEFAULT NULL,
  `footer_email` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `banner` varchar(255) 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 `settings`
--

INSERT INTO `settings` (`id`, `logo`, `favicon`, `top_bar_phone`, `top_bar_email`, `footer_address`, `footer_phone`, `footer_email`, `facebook`, `twitter`, `youtube`, `linkedin`, `instagram`, `copyright`, `banner`, `created_at`, `updated_at`) VALUES
(1, 'logo_1737059420.png', 'favicon_1737059431.png', '111-222-3333', 'contact@example.com', 'Struga,6330,North Macedonia', '111-222-3333', 'contact@example.com', '#', '#', '#', '#', '#', NULL, 'banner_1736600501.jpg', '2025-01-10 15:32:47', '2025-01-16 19:30:31');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `photo` varchar(255) 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 `sliders`
--

INSERT INTO `sliders` (`id`, `heading`, `text`, `button_text`, `button_link`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Welcome to HopnFly', 'At HopnFly, our mission is to turn travel dreams into reality by providing personalized and memorable experiences. We leverage our expertise and trusted partners to ensure every trip is seamless and enjoyable.\r\nWe believe travel fosters personal growth and cultural understanding. Our goal is to help clients explore new destinations and connect with diverse cultures. We promote sustainable travel to positively impact communities and preserve our planet’s beauty.', 'Read More', '#', 'slider_1736803135.jpg', '2025-01-10 15:39:48', '2025-02-15 15:28:44'),
(2, 'Explore Destinations', 'Check our newest destinations', 'Read More', '#', 'slider_1736802932.jpg', '2025-01-10 15:41:20', '2025-01-13 20:15:32');

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `subscribers`
--

INSERT INTO `subscribers` (`id`, `email`, `token`, `status`, `created_at`, `updated_at`) VALUES
(1, 'subscriber1@gmail.com', '', 'Active', '2025-02-04 12:59:34', '2025-02-04 16:28:57'),
(2, 'musa.shate@gmail.com', '', 'Active', '2025-02-20 18:07:50', '2025-02-20 18:09:54');

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

--
-- Table structure for table `team_members`
--

CREATE TABLE `team_members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `biography` text DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) 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 `team_members`
--

INSERT INTO `team_members` (`id`, `name`, `slug`, `designation`, `address`, `email`, `phone`, `biography`, `photo`, `facebook`, `twitter`, `linkedin`, `instagram`, `created_at`, `updated_at`) VALUES
(1, 'Daniel Carter', 'testdaniel', 'Managing Director', 'Marks i Engels', 'danielcarter@outlook.com', '12345678', '<p>test1</p>', 'team_member_1739991195.jpg', '#', '#', '#', '#', '2025-01-11 14:29:02', '2025-02-19 17:53:15'),
(2, 'Ethan Mitchell', 'EthanMitchell', 'Senior Travel Consultant', 'Marks i Engels', 'ethanmitchell@outlook.com', '12345', '<p>BIO...</p>', 'team_member_1736615538.jpg', '#', '#', '#', '#', '2025-01-11 16:12:18', '2025-01-11 16:12:18'),
(3, 'Lucas Turner', 'LucasTurner', 'Booking Assistant', 'Marks i Engels', 'lucasturner@outlook.com', '075249777', '<p>bio...</p>', 'team_member_1736615617.jpg', '#', '#', '#', '#', '2025-01-11 16:13:37', '2025-01-11 16:13:37'),
(4, 'Oliver Clarke', 'OliverClarke', 'Web Developer', 'Marks i Engels', 'oliverclarke@outlook.com', '075249777', '<p>bio...</p>', 'team_member_1736615714.jpg', '#', '#', '#', '#', '2025-01-11 16:15:14', '2025-01-11 16:15:14');

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

--
-- Table structure for table `term_privacy_items`
--

CREATE TABLE `term_privacy_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `term` text DEFAULT NULL,
  `privacy` 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 `term_privacy_items`
--

INSERT INTO `term_privacy_items` (`id`, `term`, `privacy`, `created_at`, `updated_at`) VALUES
(1, '<h3 data-pm-slice=\"1 1 []\"><strong>1. Acceptance of Terms</strong></h3>\r\n<p>You must be at least 18 years old or have legal guardian consent to use the Site.</p>\r\n<h3><strong>2. Changes to Terms</strong></h3>\r\n<p>We may update these Terms at any time. The latest version will be available here.</p>\r\n<h3><strong>3. Site Use</strong></h3>\r\n<ul data-spread=\"false\">\r\n<li>\r\n<p>Use the Site for personal, non-commercial purposes only.</p>\r\n</li>\r\n<li>\r\n<p>Do not use the Site for unlawful activities or disrupt its operations.</p>\r\n</li>\r\n</ul>\r\n<h3><strong>4. Intellectual Property</strong></h3>\r\n<p>Content on the Site is owned by [Your Travel Agency Name] or licensors. Unauthorized use is prohibited.</p>\r\n<h3><strong>5. Third-Party Links</strong></h3>\r\n<p>We are not responsible for content or practices of linked third-party websites.</p>\r\n<h3><strong>6. Limitation of Liability</strong></h3>\r\n<p>We are not liable for damages arising from your use of the Site.</p>\r\n<h3><strong>7. Governing Law</strong></h3>\r\n<p>These Terms are governed by the laws of [Your Jurisdiction].</p>', '<h3 data-pm-slice=\"1 1 []\"><strong>1. Data We Collect</strong></h3>\r\n<ul data-spread=\"false\">\r\n<li>\r\n<p>Personal details (name, email, etc.) for inquiries or bookings.</p>\r\n</li>\r\n<li>\r\n<p>Payment information for transactions.</p>\r\n</li>\r\n<li>\r\n<p>Website usage data via cookies.</p>\r\n</li>\r\n</ul>\r\n<h3><strong>2. How We Use Data</strong></h3>\r\n<ul data-spread=\"false\">\r\n<li>\r\n<p>Process bookings and payments.</p>\r\n</li>\r\n<li>\r\n<p>Improve our services.</p>\r\n</li>\r\n<li>\r\n<p>Send promotional offers (only with your consent).</p>\r\n</li>\r\n</ul>\r\n<h3><strong>3. Data Sharing</strong></h3>\r\n<p>We only share data with trusted partners (e.g., hotels, airlines) to facilitate bookings or as required by law.</p>\r\n<h3><strong>4. Data Security</strong></h3>\r\n<p>We take steps to protect your data but cannot guarantee absolute security.</p>\r\n<h3><strong>5. Your Rights</strong></h3>\r\n<p>You can access, update, or request deletion of your data. You can also opt out of marketing communications.</p>\r\n<h3><strong>6. Contact Us</strong></h3>\r\n<p>For concerns, email us at [Your Contact Email].</p>\r\n<h3><strong>7. Updates to this Policy</strong></h3>\r\n<p>We may update this policy and will post changes here.</p>\r\n<p>&nbsp;</p>\r\n<div><hr /></div>', '2025-01-10 15:32:47', '2025-01-13 19:52:05');

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

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

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `photo` varchar(255) 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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `designation`, `comment`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Will Smithh', '\"An Unforgettable Experience!\"', '\"Our trip to Greece was absolutely magical! From the perfectly planned itinerary to the personalized service, everything was seamless. Exploring the ancient ruins and relaxing on Santorini’s beaches were highlights of our journey. We can’t wait to book our next adventure with this agency!\"\r\n– Emily & James, USA', 'testimonial_1736602619.jpg', '2025-01-11 12:36:59', '2025-01-13 18:39:05'),
(2, 'Brent Henderson', '\"Highly Recommended!\"', '\"Traveling to Australia was a dream come true, thanks to this amazing agency! They helped us explore the Great Barrier Reef, enjoy a safari, and even experience the vibrant city life in Sydney. Every detail was taken care of, making our vacation stress-free and unforgettable.\"\r\n– Priya & Rahul, Germany', 'testimonial_1739989751.jpg', '2025-01-11 12:38:35', '2025-02-19 17:29:11');

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

--
-- Table structure for table `tours`
--

CREATE TABLE `tours` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` int(11) NOT NULL,
  `tour_start_date` varchar(255) DEFAULT NULL,
  `tour_end_date` varchar(255) DEFAULT NULL,
  `booking_end_date` varchar(255) DEFAULT NULL,
  `total_seat` varchar(255) 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 `tours`
--

INSERT INTO `tours` (`id`, `package_id`, `tour_start_date`, `tour_end_date`, `booking_end_date`, `total_seat`, `created_at`, `updated_at`) VALUES
(2, 2, '2025-03-01', '2025-03-03', '2025-02-25', '25', '2025-01-13 19:34:13', '2025-01-13 19:35:59'),
(3, 3, '2025-05-30', '2025-06-08', '2025-05-30', '40', '2025-02-20 16:39:48', '2025-05-27 08:06:25'),
(4, 4, '2025-05-31', '2025-06-08', '2025-05-30', '40', '2025-05-27 08:05:26', '2025-05-27 08:05:26');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0' COMMENT '0=pending, 1=active, 2=suspended',
  `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`, `name`, `email`, `photo`, `password`, `phone`, `country`, `address`, `state`, `city`, `zip`, `token`, `status`, `created_at`, `updated_at`) VALUES
(1, 'usertest', 'usertest@gmail.com', NULL, '$2y$12$qiLWLwlNjxMtfh6GYG35F.Cw5fmWzCf6baWQidUjCtG4yydS4pFha', '075249821', 'North Macedonia', 'Marks i Engels', 'Struga', 'Struga', '6330', '', '1', '2025-01-10 15:40:21', '2025-02-20 22:53:19'),
(2, 'Musa Shate', 'musa.shate@gmail.com', 'user_1740075835.jpg', '$2y$12$CqG5NbEsV4QyMuPhKyF6xuSNEjc/jpXpF5LyfpMD52wYN0jLCa0MC', '075249721', 'North Macedonia', 'Marks i Engels', 'Struga', 'Struga', '6330', NULL, '1', '2025-02-20 17:23:55', '2025-02-20 22:46:55');

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

--
-- Table structure for table `welcome_items`
--

CREATE TABLE `welcome_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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 `welcome_items`
--

INSERT INTO `welcome_items` (`id`, `heading`, `description`, `button_text`, `button_link`, `photo`, `video`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Welcome to HopnFly', '<p>At <strong>Hop</strong>nFLy, our mission is to turn travel dreams into reality by providing personalized and memorable experiences. We leverage our expertise and trusted partners to ensure every trip is seamless and enjoyable. <br />We believe travel fosters personal growth and cultural understanding. Our goal is to help clients explore new destinations and connect with diverse cultures. We promote sustainable travel to positively impact communities and preserve our planet&rsquo;s beauty.</p>', 'Read More', '#', 'welcome_item_1736529422.jpg', 'S4DI3Bve_bQ', 'Show', '2025-01-10 15:32:47', '2025-02-15 15:29:14');

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT 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 `wishlists`
--

INSERT INTO `wishlists` (`id`, `user_id`, `package_id`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '2025-02-15 15:40:53', '2025-02-15 15:40:53'),
(2, 1, 3, '2025-02-20 16:15:48', '2025-02-20 16:15:48'),
(3, 2, 3, '2025-02-20 18:22:42', '2025-02-20 18:22:42'),
(4, 2, 2, '2025-02-20 18:22:44', '2025-02-20 18:22:44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_items`
--
ALTER TABLE `about_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `amenities`
--
ALTER TABLE `amenities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `contact_items`
--
ALTER TABLE `contact_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `counter_items`
--
ALTER TABLE `counter_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `destinations`
--
ALTER TABLE `destinations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `destination_photos`
--
ALTER TABLE `destination_photos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `destination_videos`
--
ALTER TABLE `destination_videos`
  ADD PRIMARY KEY (`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 `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_items`
--
ALTER TABLE `home_items`
  ADD PRIMARY KEY (`id`);

--
-- 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 `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `message_comments`
--
ALTER TABLE `message_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_amenities`
--
ALTER TABLE `package_amenities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_faqs`
--
ALTER TABLE `package_faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_itineraries`
--
ALTER TABLE `package_itineraries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_photos`
--
ALTER TABLE `package_photos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_videos`
--
ALTER TABLE `package_videos`
  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`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`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 `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `team_members`
--
ALTER TABLE `team_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `term_privacy_items`
--
ALTER TABLE `term_privacy_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tours`
--
ALTER TABLE `tours`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `welcome_items`
--
ALTER TABLE `welcome_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_items`
--
ALTER TABLE `about_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `contact_items`
--
ALTER TABLE `contact_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `counter_items`
--
ALTER TABLE `counter_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `destinations`
--
ALTER TABLE `destinations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `destination_photos`
--
ALTER TABLE `destination_photos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `destination_videos`
--
ALTER TABLE `destination_videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `features`
--
ALTER TABLE `features`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `home_items`
--
ALTER TABLE `home_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `message_comments`
--
ALTER TABLE `message_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `package_amenities`
--
ALTER TABLE `package_amenities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `package_faqs`
--
ALTER TABLE `package_faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `package_itineraries`
--
ALTER TABLE `package_itineraries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `package_photos`
--
ALTER TABLE `package_photos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `package_videos`
--
ALTER TABLE `package_videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `team_members`
--
ALTER TABLE `team_members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `term_privacy_items`
--
ALTER TABLE `term_privacy_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tours`
--
ALTER TABLE `tours`
  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=3;

--
-- AUTO_INCREMENT for table `welcome_items`
--
ALTER TABLE `welcome_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;
