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

START TRANSACTION;



--
-- Database: `insight_tours_db`
--

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

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` int NOT NULL,
  `blog_id` int NOT NULL,
  `author_name` varchar(255) NOT NULL,
  `author_email` varchar(255) DEFAULT NULL,
  `comment` text NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `blog_comments`
--

INSERT INTO `blog_comments` (`id`, `blog_id`, `author_name`, `author_email`, `comment`, `status`, `created_at`, `updated_at`) VALUES
(1, 4, 'Ganza Eliphaz', 'ganzaeliphaz@gmail.com', 'This is inital comment\n', 'approved', '2025-10-21 06:34:43', '2025-10-21 06:39:51'),
(4, 6, 'wow', NULL, 'wow', 'approved', '2025-10-21 11:09:23', '2025-10-23 17:16:54');

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(500) NOT NULL,
  `excerpt` text,
  `content` text NOT NULL,
  `category` varchar(100) NOT NULL,
  `tags` json DEFAULT NULL,
  `status` enum('draft','published','scheduled','archived') DEFAULT 'draft',
  `author` varchar(255) NOT NULL,
  `featured_image` varchar(500) DEFAULT NULL,
  `read_time` varchar(50) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `featured` tinyint(1) DEFAULT '0',
  `views` int DEFAULT '0',
  `likes` int DEFAULT '0',
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `slug`, `title`, `excerpt`, `content`, `category`, `tags`, `status`, `author`, `featured_image`, `read_time`, `meta_title`, `meta_description`, `featured`, `views`, `likes`, `published_at`, `created_at`, `updated_at`) VALUES
(4, 'rwandas-iconic-gorilla-naming-ceremony', 'Rwanda’s Iconic Gorilla Naming Ceremony', 'Book your Rwanda adventure and witness the world-famous Kwita Izina Gorilla Naming Ceremony — a celebration of conservation, culture, and community unity at the foothills of the Volcanoes National Park.', ' Introduction\n\nEach year, Rwanda proudly hosts Kwita Izina, a cultural and conservation event where newborn mountain gorillas are officially given names. The ceremony takes place near Volcanoes National Park in Musanze District, the home of the endangered mountain gorillas.\n\nInspired by Rwanda’s traditional baby-naming rituals, Kwita Izina honors the connection between people, wildlife, and nature — highlighting the country’s global leadership in conservation tourism.\n\n\n Historical Background\n\nThe first Kwita Izina ceremony was held on September 23, 2005, in Kinigi, Musanze District. The idea was to build awareness and promote Rwanda’s conservation efforts after years of recovery from poaching and habitat loss.\n\nSince then, Kwita Izina has become a symbol of hope and sustainability, attracting thousands of visitors — from local communities to international celebrities, conservationists, and travelers.\n\n Meaning and Cultural Significance\n\nIn Kinyarwanda, “Kwita Izina” means “to give a name.” Traditionally, this ceremony marks the joy of welcoming a new member into the family. Rwanda extends this love and care to its mountain gorillas — recognizing each infant as part of the country’s natural heritage.\n\nEach gorilla is given a unique name that reflects its personality, family, or an environmental theme. The names are often chosen by distinguished guests such as scientists, park rangers, global artists, or Rwandan community heroes.\n\n The Venue: Volcanoes National Park\n\nKwita Izina is held at the foot of the Virunga Mountains, home to more than one-third of the world’s remaining mountain gorillas. The area offers breathtaking views of Mount Karisimbi, Mount Bisoke, and Mount Sabyinyo.\n\nVisitors can combine the ceremony with unforgettable activities like:\n\nGorilla trekking in Volcanoes National Park.\n\nGolden monkey tracking.\n\nCultural village visits to meet local communities.\n\nHiking and nature photography around the Virunga landscape.', 'Wildlife', '[]', 'published', 'NDAHIRO Benjamin', '/uploads/gallery/gallery-1761416394235-580614873.jpeg', '5 min read', 'Kwita Izina Gorilla Naming Ceremony | Rwanda’s Celebration of Conservation', 'Discover Rwanda’s Kwita Izina Gorilla Naming Ceremony — an annual event celebrating newborn gorillas, conservation, and cultural heritage near Volcanoes National Park.\nFocus Keyword: Kwita Izina gorilla naming', 1, 27, 4, '2025-10-25 18:20:00', '2025-10-20 18:46:04', '2025-10-25 18:19:59'),
(6, 'discover-lake-kivu-rwandas-hidden-gem-for-relaxation-and-adventure', 'Discover Lake Kivu: Rwanda’s Hidden Gem for Relaxation and Adventure', 'Book tours, city experiences, transportation, and accommodations — all in one place with expert guidance and competitive pricing. Discover Lake Kivu, Rwanda’s largest freshwater lake, where serene beaches meet volcanic backdrops and vibrant local culture.', ' Introduction\n\nNestled between Rwanda and the Democratic Republic of Congo, Lake Kivu is one of Africa’s most beautiful inland water bodies — a place where calm waves, lush green hills, and charming lakeside towns invite travelers to unwind and explore.\n\nThings to Do Around Lake Kivu\n\nBoat Cruises:\nSail across the peaceful waters and visit nearby islands like Napoleon Island, home to thousands of fruit bats and scenic viewpoints.\n\nSwimming & Relaxation:\nLake Kivu’s freshwater is free from dangerous animals, making it perfect for a refreshing swim or a lazy afternoon by the beach.\n\nWater Sports:\nTry kayaking, paddle boarding, or jet skiing at popular resorts in Gisenyi (Rubavu) and Kibuye (Karongi).\n\nCultural Tours:\nVisit local fishing communities to experience Rwanda’s lakeside traditions, music, and cuisine — especially grilled tilapia and sambaza (small fish).\n\nHiking & Nature:\nExplore nearby trails such as the Congo Nile Trail, which offers multi-day hikes and biking routes with stunning lake views.\n\n Where to Stay\n\nFrom luxury resorts to cozy guesthouses, accommodation options are plentiful:\n\nLake Kivu Serena Hotel (Rubavu): Perfect for upscale comfort.\n\nCormoran Lodge (Karongi): Built on a hillside with panoramic views.\n\nParadise Kivu Resort: Mid-range with private beaches.\n\nLocal Cuisine\n\nEnjoy lakeside dining with freshly caught fish, tropical fruits, and local Rwandan dishes like Isombe and Brochettes. Don’t miss the local coffee grown in the surrounding volcanic soil — it’s among the best in the world.\n\n How to Get There\n\nFrom Kigali: Around 3–4 hours by road (Rubavu or Karongi).\n\nBy Bus: Daily public transport from Nyabugogo Bus Park.\n\nBy Private Tour: Many travel companies offer guided tours with transfers, meals, and hotel booking.\n\n Best Time to Visit\n\nLake Kivu is ideal all year round, but the dry seasons (June–September and December–February) offer the best weather for swimming, hiking, and sig', 'Culture', '[]', 'published', 'Insight Tours Team', '/uploads/gallery/gallery-1761415912742-39473262.jpeg', '5 min read', 'Lake Kivu Travel Guide | Explore Rwanda’s Hidden Paradise', 'Discover Lake Kivu — Rwanda’s most serene lake destination. Enjoy boat rides, swimming, hiking, and cultural tours with our expert travel guides and best-price bookings.', 1, 2, 2, '2025-10-25 18:13:00', '2025-10-21 09:58:31', '2025-10-25 18:13:00');

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

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

CREATE TABLE `bookings` (
  `id` int NOT NULL,
  `tour_id` int NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `travel_date` date NOT NULL,
  `pax` int NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `currency` varchar(3) DEFAULT 'USD',
  `status` enum('pending','confirmed','cancelled','completed','expired') DEFAULT 'pending',
  `message` text,
  `special_requests` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `tour_id`, `customer_name`, `email`, `phone`, `travel_date`, `pax`, `total_amount`, `currency`, `status`, `message`, `special_requests`, `created_at`, `updated_at`) VALUES
(17, 25, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', '0794556595', '2025-10-23', 1, 530.00, 'USD', 'confirmed', NULL, NULL, '2025-10-23 18:21:02', '2025-10-24 07:18:12'),
(18, 25, 'GANZA Eliphaz', 'ganzae@gmail.com', '0794556595', '2025-10-24', 1, 530.00, 'USD', 'pending', NULL, NULL, '2025-10-23 18:21:34', '2025-10-23 18:21:34');

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

--
-- Table structure for table `car_rentals`
--

CREATE TABLE `car_rentals` (
  `id` int NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `whatsapp` varchar(20) DEFAULT NULL,
  `pickup_location` varchar(255) NOT NULL,
  `dropoff_location` varchar(255) DEFAULT NULL,
  `pickup_date` date NOT NULL,
  `pickup_time` time NOT NULL,
  `car_category` enum('small','premium','luxury') NOT NULL,
  `passengers` int DEFAULT '1',
  `driver_needed` tinyint(1) DEFAULT '1',
  `status` enum('pending','confirmed','cancelled','completed') DEFAULT 'pending',
  `total_amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(3) DEFAULT 'USD',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `car_rentals`
--

INSERT INTO `car_rentals` (`id`, `first_name`, `last_name`, `email`, `phone`, `whatsapp`, `pickup_location`, `dropoff_location`, `pickup_date`, `pickup_time`, `car_category`, `passengers`, `driver_needed`, `status`, `total_amount`, `currency`, `created_at`, `updated_at`) VALUES
(5, 'GANZA', 'Eliphaz', 'ganzaeliphaz@gmail.com', '078', NULL, 'sd', NULL, '2025-10-22', '17:24:00', 'small', 1, 1, 'cancelled', NULL, 'USD', '2025-10-21 12:25:00', '2025-10-23 17:16:04'),
(6, 'GANZA', 'Eliphaz', 'ganzaeliphaz@gmail.com', '078', NULL, 'sd', NULL, '2025-10-22', '17:24:00', 'small', 1, 1, 'pending', NULL, 'USD', '2025-10-21 12:25:09', '2025-10-21 12:25:09'),
(7, 'GANZA', 'Eliphaz', 'ganzaeliphaz@gmail.com', '078', NULL, 'sd', NULL, '2025-10-22', '17:24:00', 'small', 1, 1, 'pending', NULL, 'USD', '2025-10-21 12:25:15', '2025-10-21 12:25:15'),
(8, 'GANZA', 'Eliphaz', 'ganzaeliphaz@gmail.com', '0794556595', '0794556595', 'Huye - Karambi', 'Kigali - Cyivugiza', '2025-10-23', '09:00:00', 'luxury', 4, 1, 'pending', NULL, 'USD', '2025-10-23 13:52:46', '2025-10-23 13:52:46'),
(12, 'Romin', ' Digito', 'romin@gmail.com', '069778543', '069778543', 'sdfdf', 'gdfd', '2025-10-20', '20:28:00', 'small', 5, 1, 'confirmed', 150.00, 'USD', '2025-10-23 14:28:19', '2025-10-23 14:39:54'),
(13, 'GANZA', 'Eliphaz', 'ganzaeliphaz@gmail.com', '07900000000', '07900000000', 'Kigali', 'Huye', '2025-10-24', '10:30:00', 'luxury', 3, 1, 'confirmed', 300.00, 'USD', '2025-10-23 15:19:48', '2025-10-23 15:20:25'),
(14, 'kabanda', 'df', 'kaaj@gmail.com', '1234567', '34567', 'kanombe', 'asdf', '2025-10-23', '20:50:00', 'small', 1, 1, 'pending', 30.00, 'USD', '2025-10-25 18:47:53', '2025-10-25 18:47:53'),
(15, 'kabanda', 'df', 'kaaj@gmail.com', '1234567', '34567', 'kanombe', 'asdf', '2025-10-23', '20:50:00', 'small', 1, 1, 'pending', 30.00, 'USD', '2025-10-25 18:47:54', '2025-10-25 18:47:54'),
(16, 'kabanda', 'df', 'kaaj@gmail.com', '1234567', '34567', 'kanombe', 'asdf', '2025-10-23', '20:50:00', 'small', 1, 1, 'pending', 30.00, 'USD', '2025-10-25 18:47:55', '2025-10-25 18:47:55');

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

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

CREATE TABLE `destinations` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text,
  `country` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `featured_image` varchar(500) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `destinations`
--

INSERT INTO `destinations` (`id`, `name`, `slug`, `description`, `country`, `region`, `featured_image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Test Destination', 'test-destination', 'A test destination', 'Test Country', 'Test Region', '/uploads/featured_image-1761120668969-692616288.jpeg', 'inactive', '2025-10-21 15:09:33', '2025-10-22 19:10:22'),
(2, 'Updated tours', 'updated-tours', '', 'hds', 'initial', '/uploads/featured_image-1761120681081-748979167.jpeg', 'inactive', '2025-10-21 15:53:43', '2025-10-22 19:10:26'),
(3, 'initial', 'itial', 'ddf', 'initial', 'initial', '/uploads/featured_image-1761120588510-674873400.jpeg', 'inactive', '2025-10-21 15:57:16', '2025-10-22 19:05:50'),
(4, 'Akagera National Park', 'akagera-national-park', 'Rwanda’s only savannah park, located in the east, is home to the Big Five (lions, leopards, elephants, buffaloes, and rhinos). It offers thrilling game drives, boat rides on Lake Ihema, and birdwatching opportunities in a diverse ecosystem', 'Rwanda', 'Eastern Rwanda, bordering Tanzania', '/uploads/featured_image-1761159945614-336558238.jpeg', 'active', '2025-10-22 19:05:45', '2025-10-22 19:05:45'),
(5, 'Volcanoes National Park', 'volcanoes-national-park', 'Located in northern Rwanda, this park is famous for its misty mountains and rare mountain gorillas. It’s a premier destination for gorilla and golden monkey trekking, offering an intimate encounter with Rwanda’s wildlife and conservation legacy.', 'Rwanda', 'Karisimbi, Bisoke, Muhabura, Gahinga, and Sabyinyo.', '/uploads/featured_image-1761160213735-686565797.jpeg', 'active', '2025-10-22 19:10:13', '2025-10-22 19:10:13'),
(6, 'asd', 'asd', 'sdv', 'cv', 'sdf', '/uploads/featured_image-1761162228781-220971057.jpeg', 'inactive', '2025-10-22 19:43:48', '2025-10-22 19:43:54'),
(7, 'Lake Kivu', 'lake-kivu', 'One of Africa’s Great Lakes, Lake Kivu lies in western Rwanda, offering serene beaches, island exploration, and water-based activities', 'Rwanda', 'It is the sixth-largest lake', '/uploads/featured_image-1761162349333-191962266.jpeg', 'active', '2025-10-22 19:45:49', '2025-10-22 19:45:49'),
(8, 'Nyungwe National Park', 'nyungwe-national-park', 'A pristine rainforest in southern Rwanda, Nyungwe is renowned for its biodiversity, including chimpanzees, colobus monkeys, and over 300 bird species', 'Rwanda', 'rusizi near bukavu city', '/uploads/featured_image-1761162506744-976991895.jpeg', 'active', '2025-10-22 19:48:26', '2025-10-22 19:48:26'),
(9, 'Kigali', 'kigali', 'Kigali destination', 'Rwanda', 'kigali', '/uploads/featured_image-1761233201204-927092373.jpeg', 'active', '2025-10-23 15:26:41', '2025-10-23 15:26:41');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int NOT NULL,
  `title` varchar(500) NOT NULL,
  `description` text,
  `image_path` varchar(500) NOT NULL,
  `category` varchar(100) DEFAULT 'general',
  `location` varchar(100) DEFAULT NULL,
  `featured` tinyint(1) DEFAULT '0',
  `uploaded_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `gallery_collections`
--

CREATE TABLE `gallery_collections` (
  `id` int NOT NULL,
  `title` varchar(500) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text,
  `category` varchar(100) DEFAULT 'general',
  `location` varchar(255) DEFAULT NULL,
  `cover_image` varchar(500) DEFAULT NULL,
  `featured` tinyint(1) DEFAULT '0',
  `status` enum('active','inactive') DEFAULT 'active',
  `uploaded_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `gallery_collections`
--

INSERT INTO `gallery_collections` (`id`, `title`, `slug`, `description`, `category`, `location`, `cover_image`, `featured`, `status`, `uploaded_by`, `created_at`, `updated_at`) VALUES
(2, 'mountain gorilla', 'mountain gorilla', 'We was traveling with smooth smile, just contact us to have fun with us', 'wildlife', 'Nyungwe NP, kinigi', '/uploads/gallery/gallery-1760975204772-910407933.jpeg', 1, 'active', NULL, '2025-10-20 15:47:03', '2025-10-25 17:00:35'),
(3, 'Insight Tours and travel ', 'another-collection', '', 'general', 'nyungwe and akagera', '/uploads/gallery/gallery-1760975834177-2729651.JPG', 1, 'active', NULL, '2025-10-20 15:57:14', '2025-10-25 16:59:19'),
(4, 'Stunning images', 'stunning-images', '', 'general', '', '/uploads/gallery/gallery-1761040408622-317827556.jpeg', 0, 'active', NULL, '2025-10-21 09:53:34', '2025-10-21 09:53:34'),
(5, 'mountain and natural volcano', 'volcano and mountain', '', 'wildlife', 'kiningi , nyungwe , natural place', '/uploads/gallery/gallery-1761411460981-265549551.jpeg', 1, 'active', NULL, '2025-10-22 19:53:27', '2025-10-25 16:58:12'),
(6, 'welcome to kigali city ', 'welcome-to-kigali-city', 'Immerse yourself in Rwanda’s rich history, resilience, and vibrant culture on this full-day guided tour through Kigali — the country’s dynamic capital and heart of transformation', 'culture', 'kigali , nyanza , others place', '/uploads/gallery/gallery-1761411099309-779749215.jpeg', 1, 'active', NULL, '2025-10-25 16:54:02', '2025-10-25 16:54:02');

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

--
-- Table structure for table `gallery_images`
--

CREATE TABLE `gallery_images` (
  `id` int NOT NULL,
  `collection_id` int NOT NULL,
  `image_path` varchar(500) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `alt_text` varchar(255) DEFAULT NULL,
  `sort_order` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `gallery_images`
--

INSERT INTO `gallery_images` (`id`, `collection_id`, `image_path`, `title`, `description`, `alt_text`, `sort_order`, `created_at`) VALUES
(19, 4, '/uploads/gallery/gallery-1761040414786-946678916.jpeg', 'kigali-Rwanda.jpeg', '', '', 0, '2025-10-21 09:53:34'),
(20, 4, '/uploads/gallery/gallery-1761040414789-618949858.jpeg', 'download (12).jpeg', '', '', 1, '2025-10-21 09:53:34'),
(21, 4, '/uploads/gallery/gallery-1761040414798-632636762.jpeg', 'download (11).jpeg', '', '', 2, '2025-10-21 09:53:34'),
(22, 4, '/uploads/gallery/gallery-1761040414803-990044804.jpeg', 'download (10).jpeg', '', '', 3, '2025-10-21 09:53:34'),
(23, 4, '/uploads/gallery/gallery-1761040414811-457666059.jpeg', 'download (9).jpeg', '', '', 4, '2025-10-21 09:53:34'),
(28, 6, '/uploads/gallery/gallery-1761411242125-696128228.jpeg', 'Gasabo Kigali Rwanda.jpeg', '', '', 0, '2025-10-25 16:54:02'),
(29, 6, '/uploads/gallery/gallery-1761411242134-412155256.jpeg', 'KCC â¢ Rwanda ð·ð¼.jpeg', '', '', 1, '2025-10-25 16:54:02'),
(30, 6, '/uploads/gallery/gallery-1761411242141-766682163.jpeg', 'Rwanda ð·ð¼ (1).jpeg', '', '', 2, '2025-10-25 16:54:02'),
(31, 6, '/uploads/gallery/gallery-1761411242147-156698051.jpeg', 'Is Rwanda Worth Visiting_ Pros and Cons to Know Before You Go.jpeg', '', '', 3, '2025-10-25 16:54:02'),
(32, 6, '/uploads/gallery/gallery-1761411242153-153593039.jpeg', 'Hello from Mombasa! Weâre so happy and excited to be back and of course our first stop was at the market for lots and lots of fruit and veggies and a refreshing coconut (or two)! Next stop, Soko Kenya! See you soo.jpeg', '', '', 4, '2025-10-25 16:54:02'),
(33, 6, '/uploads/gallery/gallery-1761411242159-475731666.jpeg', 'Kigali - Rwanda ð·ð¼.jpeg', '', '', 5, '2025-10-25 16:54:02'),
(34, 6, '/uploads/gallery/gallery-1761411242163-15254183.jpeg', 'Cultural village experience.jpeg', '', '', 6, '2025-10-25 16:54:02'),
(35, 6, '/uploads/gallery/gallery-1761411242170-337747714.jpeg', 'download (23).jpeg', '', '', 7, '2025-10-25 16:54:02'),
(36, 5, '/uploads/gallery/gallery-1761411492533-729431158.jpeg', 'Volcanoes National Park.jpeg', '', '', 0, '2025-10-25 16:58:12'),
(37, 5, '/uploads/gallery/gallery-1761411492534-28982001.jpeg', 'Sisimbo Beach, Ghana.jpeg', '', '', 1, '2025-10-25 16:58:12'),
(38, 5, '/uploads/gallery/gallery-1761411492544-829946925.jpeg', 'enclos_ure.jpeg', '', '', 2, '2025-10-25 16:58:12'),
(39, 5, '/uploads/gallery/gallery-1761411492553-922136813.jpeg', 'Lake Kivu ð¨ð©ð·ð¼.jpeg', '', '', 3, '2025-10-25 16:58:12'),
(40, 5, '/uploads/gallery/gallery-1761411492563-843948469.jpeg', 'Dispatch from Rwanda_ Slice of Life Things to Do.jpeg', '', '', 4, '2025-10-25 16:58:12'),
(41, 5, '/uploads/gallery/gallery-1761162807283-723993387.jpeg', 'Mgahinga Gorilla National Park.jpeg', '', '', 5, '2025-10-25 16:58:12'),
(42, 3, '/uploads/gallery/gallery-1760975832989-553439648.JPG', '1Z5A9588.JPG', '', '', 0, '2025-10-25 16:59:19'),
(43, 3, '/uploads/gallery/gallery-1760975833174-973022639.JPG', '1Z5A8884.JPG', '', '', 1, '2025-10-25 16:59:19'),
(44, 3, '/uploads/gallery/gallery-1760975833392-595402351.JPG', '1Z5A9578.JPG', '', '', 2, '2025-10-25 16:59:19'),
(45, 3, '/uploads/gallery/gallery-1760975833488-123093664.JPG', '1Z5A9587.JPG', '', '', 3, '2025-10-25 16:59:19'),
(46, 3, '/uploads/gallery/gallery-1760975833564-142249064.JPG', 'guide-3.JPG', '', '', 4, '2025-10-25 16:59:19'),
(47, 3, '/uploads/gallery/gallery-1760975833639-430242578.JPG', '1Z5A9112.JPG', '', '', 5, '2025-10-25 16:59:19'),
(48, 3, '/uploads/gallery/gallery-1760975833855-588232382.JPG', '1Z5A9349.JPG', '', '', 6, '2025-10-25 16:59:19'),
(49, 3, '/uploads/gallery/gallery-1760975834177-2729651.JPG', 'team-2.JPG', '', '', 7, '2025-10-25 16:59:19'),
(50, 2, '/uploads/gallery/gallery-1761411635282-329461301.jpeg', 'abseil down waterfall.jpeg', '', '', 0, '2025-10-25 17:00:35'),
(51, 2, '/uploads/gallery/gallery-1761411635324-735646579.jpeg', 'Great Activities in 2022 Cape Town.jpeg', '', '', 1, '2025-10-25 17:00:35'),
(52, 2, '/uploads/gallery/gallery-1761411635339-62406529.jpeg', 'Ziplining in Ohio lets you \'fly\' above the trees.jpeg', '', '', 2, '2025-10-25 17:00:35'),
(53, 2, '/uploads/gallery/gallery-1760975223764-954990068.jpeg', 'gor.jpeg', '', '', 3, '2025-10-25 17:00:35'),
(54, 2, '/uploads/gallery/gallery-1760975223766-827509681.jpeg', 'water.jpeg', '', '', 4, '2025-10-25 17:00:35'),
(55, 2, '/uploads/gallery/gallery-1760975223777-658456154.jpeg', 'Kakum National Park.jpeg', '', '', 5, '2025-10-25 17:00:35'),
(56, 2, '/uploads/gallery/gallery-1760975223784-214087880.jpeg', 'Stargazer\'s Dream_ Camping in Nyungwe\'s Enchanted Forest ððï¸.jpeg', '', '', 6, '2025-10-25 17:00:35');

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

--
-- Table structure for table `newsletter_subscriptions`
--

CREATE TABLE `newsletter_subscriptions` (
  `id` int NOT NULL,
  `email` varchar(255) NOT NULL,
  `subscribed_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_active` tinyint(1) DEFAULT '1',
  `unsubscribed_at` timestamp NULL DEFAULT NULL,
  `source` varchar(100) DEFAULT 'website',
  `preferences` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `newsletter_subscriptions`
--

INSERT INTO `newsletter_subscriptions` (`id`, `email`, `subscribed_at`, `is_active`, `unsubscribed_at`, `source`, `preferences`) VALUES
(5, 'ganzaeliphaz@gmail.com', '2025-10-21 09:51:39', 1, NULL, 'footer', '{}'),
(7, 'ndahirobenjamin200@gmail.com', '2025-10-24 19:42:37', 1, NULL, 'footer', '{}');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int NOT NULL,
  `type` enum('user_action','admin_action','system') DEFAULT 'user_action',
  `action` enum('tour_booking','car_rental_booking','blog_like','blog_comment','blog_view','newsletter_subscribe','contact_form','gallery_upload','blog_create','blog_update','comment_approve','comment_reject') NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `user_id` int DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `item_type` varchar(50) DEFAULT NULL,
  `item_title` varchar(255) DEFAULT NULL,
  `metadata` json DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `priority` enum('low','medium','high','urgent') DEFAULT 'medium',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `action`, `title`, `message`, `user_id`, `user_name`, `user_email`, `item_id`, `item_type`, `item_title`, `metadata`, `is_read`, `priority`, `created_at`) VALUES
(53, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'GANZA Eliphaz booked a luxury car for 2025-10-23', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 8, 'car_rental', 'luxury Car Rental', '{\"passengers\": 4, \"pickup_date\": \"2025-10-23\", \"car_category\": \"luxury\", \"pickup_location\": \"Huye - Karambi\"}', 1, 'high', '2025-10-23 13:52:46'),
(54, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'GANZA Eliphaz booked a luxury car for 2025-10-24', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 9, 'car_rental', 'luxury Car Rental', '{\"amount\": 100, \"currency\": \"USD\", \"passengers\": 2, \"pickup_date\": \"2025-10-24\", \"car_category\": \"luxury\", \"pickup_location\": \"Kigali - Kimisagara\"}', 1, 'high', '2025-10-23 14:14:45'),
(55, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'GANZA Eliphaz booked a small car for 2025-10-16', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 10, 'car_rental', 'small Car Rental', '{\"amount\": 30, \"currency\": \"USD\", \"passengers\": 2, \"pickup_date\": \"2025-10-16\", \"car_category\": \"small\", \"pickup_location\": \"r\"}', 1, 'high', '2025-10-23 14:20:02'),
(56, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'GANZA Eliphaz booked a premium car for 2025-10-17', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 11, 'car_rental', 'premium Car Rental', '{\"amount\": 60, \"currency\": \"USD\", \"passengers\": 3, \"pickup_date\": \"2025-10-17\", \"car_category\": \"premium\", \"pickup_location\": \"tt\"}', 1, 'high', '2025-10-23 14:22:23'),
(57, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'Romin  Digito booked a small car for 2025-10-20', NULL, 'Romin  Digito', 'romin@gmail.com', 12, 'car_rental', 'small Car Rental', '{\"amount\": 150, \"currency\": \"USD\", \"passengers\": 5, \"pickup_date\": \"2025-10-20\", \"car_category\": \"small\", \"pickup_location\": \"sdfdf\"}', 1, 'high', '2025-10-23 14:28:19'),
(58, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'GANZA Eliphaz booked a luxury car for 2025-10-24', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 13, 'car_rental', 'luxury Car Rental', '{\"amount\": 300, \"currency\": \"USD\", \"passengers\": 3, \"pickup_date\": \"2025-10-24\", \"car_category\": \"luxury\", \"pickup_location\": \"Kigali\"}', 1, 'high', '2025-10-23 15:19:48'),
(59, 'admin_action', 'comment_reject', 'Comment Rejected', 'Comment by wow on \"DS\" has been rejected', NULL, 'wow', NULL, 4, 'blog_comment', 'DS', '{}', 1, 'medium', '2025-10-23 17:16:49'),
(60, 'admin_action', 'comment_approve', 'Comment Approved', 'Comment by wow on \"DS\" has been approved', NULL, 'wow', NULL, 4, 'blog_comment', 'DS', '{}', 1, 'medium', '2025-10-23 17:16:54'),
(61, 'user_action', 'tour_booking', 'New Tour Booking', 'GANZA Eliphaz booked \"Lake Kivu Experience \" for 2025-10-23', NULL, 'GANZA Eliphaz', 'ganzaeliphaz@gmail.com', 25, 'tour', 'Lake Kivu Experience ', '{\"pax\": 1, \"currency\": \"USD\", \"tour_slug\": \"lake-kivu-experience-\", \"travel_date\": \"2025-10-23\", \"total_amount\": 530}', 1, 'high', '2025-10-23 18:21:03'),
(62, 'user_action', 'tour_booking', 'New Tour Booking', 'GANZA Eliphaz booked \"Lake Kivu Experience \" for 2025-10-24', NULL, 'GANZA Eliphaz', 'ganzae@gmail.com', 25, 'tour', 'Lake Kivu Experience ', '{\"pax\": 1, \"currency\": \"USD\", \"tour_slug\": \"lake-kivu-experience-\", \"travel_date\": \"2025-10-24\", \"total_amount\": 530}', 1, 'high', '2025-10-23 18:21:34'),
(63, 'user_action', 'blog_like', 'New Blog Like', 'Someone liked \"DS\"', NULL, NULL, NULL, 6, 'blog_post', 'DS', '{}', 1, 'low', '2025-10-24 07:09:51'),
(64, 'user_action', 'blog_comment', 'New Blog Comment', 'y commented on \"DS\"', NULL, 'y', '', 6, 'blog_post', 'DS', '{}', 1, 'medium', '2025-10-24 07:10:08'),
(65, 'user_action', 'blog_comment', 'New Blog Comment', 'f commented on \"DS\"', NULL, 'f', '', 6, 'blog_post', 'DS', '{}', 1, 'medium', '2025-10-24 07:10:23'),
(66, 'admin_action', 'comment_reject', 'Comment Rejected', 'Comment by f on \"DS\" has been rejected', NULL, 'f', NULL, 6, 'blog_comment', 'DS', '{}', 1, 'medium', '2025-10-24 07:10:42'),
(67, 'admin_action', 'comment_reject', 'Comment Rejected', 'Comment by y on \"DS\" has been rejected', NULL, 'y', NULL, 5, 'blog_comment', 'DS', '{}', 1, 'medium', '2025-10-24 07:10:48'),
(68, 'user_action', 'newsletter_subscribe', 'Newsletter Subscription', 'ndahirobenjamin200@gmail.com subscribed to the newsletter', NULL, 'ndahirobenjamin200@gmail.com', 'ndahirobenjamin200@gmail.com', NULL, NULL, NULL, '{}', 1, 'low', '2025-10-24 19:42:37'),
(69, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"Book tours, city experiences, transportation, \" has been updated', NULL, NULL, NULL, 6, 'blog_post', 'Book tours, city experiences, transportation, ', '{}', 0, 'low', '2025-10-25 17:05:32'),
(70, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"happines and fully of joy\" has been updated', NULL, NULL, NULL, 4, 'blog_post', 'happines and fully of joy', '{}', 0, 'low', '2025-10-25 17:10:27'),
(71, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"Discover Lake Kivu: Rwanda’s Hidden Gem for Relaxation and Adventure\" has been updated', NULL, NULL, NULL, 6, 'blog_post', 'Discover Lake Kivu: Rwanda’s Hidden Gem for Relaxation and Adventure', '{}', 0, 'low', '2025-10-25 18:13:00'),
(72, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"Discover Lake Kivu — Rwanda’s most serene lake destination. Enjoy boat rides, swimming, hiking, and cultural tours with our expert travel guides and best-price bookings.\" has been updated', NULL, NULL, NULL, 4, 'blog_post', 'Discover Lake Kivu — Rwanda’s most serene lake destination. Enjoy boat rides, swimming, hiking, and cultural tours with our expert travel guides and best-price bookings.', '{}', 0, 'low', '2025-10-25 18:17:46'),
(73, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"Rwanda’s Iconic Gorilla Naming Ceremony\" has been updated', NULL, NULL, NULL, 4, 'blog_post', 'Rwanda’s Iconic Gorilla Naming Ceremony', '{}', 0, 'low', '2025-10-25 18:19:14'),
(74, 'admin_action', 'blog_update', 'Blog Post Updated', 'Blog post \"Rwanda’s Iconic Gorilla Naming Ceremony\" has been updated', NULL, NULL, NULL, 4, 'blog_post', 'Rwanda’s Iconic Gorilla Naming Ceremony', '{}', 0, 'low', '2025-10-25 18:19:59'),
(75, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'kabanda df booked a small car for 2025-10-23', NULL, 'kabanda df', 'kaaj@gmail.com', 14, 'car_rental', 'small Car Rental', '{\"amount\": 30, \"currency\": \"USD\", \"passengers\": 1, \"pickup_date\": \"2025-10-23\", \"car_category\": \"small\", \"pickup_location\": \"kanombe\"}', 0, 'high', '2025-10-25 18:47:53'),
(76, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'kabanda df booked a small car for 2025-10-23', NULL, 'kabanda df', 'kaaj@gmail.com', 15, 'car_rental', 'small Car Rental', '{\"amount\": 30, \"currency\": \"USD\", \"passengers\": 1, \"pickup_date\": \"2025-10-23\", \"car_category\": \"small\", \"pickup_location\": \"kanombe\"}', 0, 'high', '2025-10-25 18:47:54'),
(77, 'user_action', 'car_rental_booking', 'New Car Rental Booking', 'kabanda df booked a small car for 2025-10-23', NULL, 'kabanda df', 'kaaj@gmail.com', 16, 'car_rental', 'small Car Rental', '{\"amount\": 30, \"currency\": \"USD\", \"passengers\": 1, \"pickup_date\": \"2025-10-23\", \"car_category\": \"small\", \"pickup_location\": \"kanombe\"}', 0, 'high', '2025-10-25 18:47:55');

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

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

CREATE TABLE `tours` (
  `id` int NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `title` varchar(500) NOT NULL,
  `description` text,
  `full_description` text,
  `type` enum('adventure','cultural','relaxation','historical','wildlife') DEFAULT 'adventure',
  `destination_id` int DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `currency` varchar(3) DEFAULT 'USD',
  `days` int DEFAULT '1',
  `meeting_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `requirements` varchar(500) DEFAULT NULL,
  `difficulty` enum('easy','moderate','difficult','expert') DEFAULT NULL,
  `itinerary` json DEFAULT NULL,
  `includes` json DEFAULT NULL,
  `excludes` json DEFAULT NULL,
  `cover_image` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `images` json DEFAULT NULL,
  `featured_image` varchar(500) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tours`
--

INSERT INTO `tours` (`id`, `slug`, `title`, `description`, `full_description`, `type`, `destination_id`, `location`, `price`, `currency`, `days`, `meeting_point`, `requirements`, `difficulty`, `itinerary`, `includes`, `excludes`, `cover_image`, `images`, `featured_image`, `status`, `created_at`, `updated_at`) VALUES
(18, 'day-gorilla-trekking-day-trip', 'Day Gorilla Trekking day trip', 'Come face to face with mountain gorillas in their natural habitat during this private full-day gorilla-tracking excursion to Volcanoes National Park from Kigali.', 'Come face to face with mountain gorillas in their natural habitat during this private full-day gorilla-tracking excursion to Volcanoes National Park from Kigali.', 'wildlife', 5, 'wildlife Experience Volcanoes National Park ', 2450.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"04:00 Am –Departure from the hotel\"}, {\"day\": 1, \"order\": 1, \"activity\": \"07:00 Am- Arrival & Briefing\"}, {\"day\": 1, \"order\": 2, \"activity\": \"07:30 Am- Gorilla trekking (2-6 hours depending on the family you’re visiting)\"}, {\"day\": 1, \"order\": 3, \"activity\": \"Spend 1 magical hour with the Gorillas once found \"}, {\"day\": 1, \"order\": 4, \"activity\": \"02:00 Pm –Lunch in Musanze\"}, {\"day\": 1, \"order\": 5, \"activity\": \"04:00 Pm – Back to Kigali \"}]', '[\" 4x4 safari vehicle + professional Field guide\", \"Park entry fees\", \"Bottled water all included\", \"Meals (for multi-day safaris)\", \" Activities: Game drives, boat rides, night drives\"]', '[\"Excludes:All that was not mentioned above is not included in the packages \"]', 'blob:http://localhost:5173/47988ca2-1286-4dee-af96-17a7b4898a29', '[\"images-1761410820287-144489513.jpeg\", \"images-1761410820296-900816425.jpeg\", \"images-1761410820338-793367867.jpeg\", \"images-1761410820365-756244293.jpeg\"]', 'blob:http://localhost:5173/47988ca2-1286-4dee-af96-17a7b4898a29', 'active', '2025-10-22 17:02:26', '2025-10-25 16:47:00'),
(19, 'day-safari-day-trip-game-drive-', 'Day Safari (Day Trip Game drive )', 'Explore Rwanda’s only savannah park and home to the Big Five – lions, leopards, elephants,\r\nbuffaloes, and rhinos', 'Explore Rwanda’s only savannah park and home to the Big Five – lions, leopards, elephants,\r\nbuffaloes, and rhinos', 'wildlife', 4, 'Akagera National Park Safaris', 450.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"05:00 AM  – Pick-up from Kigali\"}, {\"day\": 1, \"order\": 1, \"activity\": \"07:30 AM  – Arrival & register at park reception\"}, {\"day\": 1, \"order\": 2, \"activity\": \"08:00 AM  – 01:00 PM – Southern circuit game drive\"}, {\"day\": 1, \"order\": 3, \"activity\": \"01:00 PM  – lunch at (choosen restaurant or coffe shop)\"}, {\"day\": 1, \"order\": 4, \"activity\": \"02:00 PM  – 04:30 PM – Catching sunset at Lake Ihema.\"}, {\"day\": 1, \"order\": 5, \"activity\": \"05:00 PM  – Exit park, drive to Kigali\"}, {\"day\": 1, \"order\": 6, \"activity\": \"07:30 PM  – Drop-off at hotel\"}]', '[\"4x4 safari vehicle + professional Field guide\", \"Park entry fees\", \"Bottled water all included\", \"Meals (for multi-day safaris)\", \"Activities: Game drives, boat rides, night drives\"]', '[\"All that was not mentioned above is not included in the packages \"]', 'blob:http://localhost:5173/a5addac4-c2dd-4bf8-be94-cc86b2390645', '[\"images-1761410476247-221710130.jpeg\", \"images-1761410476248-195671857.jpeg\", \"images-1761410476255-848279336.jpeg\", \"images-1761410476264-124140257.jpeg\"]', 'blob:http://localhost:5173/a5addac4-c2dd-4bf8-be94-cc86b2390645', 'active', '2025-10-22 17:12:57', '2025-10-25 16:41:16'),
(20, 'akagera-national-park-safaris-1-night-2-days', 'Akagera National Park Safaris (1 Night, 2 Days)', 'Explore Rwanda’s only savannah park and home to the Big Five – lions, leopards, elephants,\r\nbuffaloes, and rhinos', 'Explore Rwanda’s only savannah park and home to the Big Five – lions, leopards, elephants,\r\nbuffaloes, and rhinos', 'wildlife', 4, 'akagera national park', 560.00, 'USD', 2, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"05:00 AM  – Pick-up from Kigali\"}, {\"day\": 1, \"order\": 1, \"activity\": \"07:30 AM  – Arrival & register at park reception \"}, {\"day\": 1, \"order\": 2, \"activity\": \"08:00 AM  – 01:00 PM – Southern circuit game drive\"}, {\"day\": 1, \"order\": 3, \"activity\": \"01:00 PM  – lunch at (choosen restaurant or coffe shop)\"}, {\"day\": 1, \"order\": 4, \"activity\": \"2:00 PM  – 04:30 PM – Catching sunset at Lake Ihema\"}, {\"day\": 1, \"order\": 5, \"activity\": \"06:30 PM  – Drop-off at the hotel\"}, {\"day\": 2, \"order\": 0, \"activity\": \"05:00 AM  – Catching sunrise at the park hotel\"}, {\"day\": 2, \"order\": 1, \"activity\": \"06:00 AM  – Bird watching\"}, {\"day\": 2, \"order\": 2, \"activity\": \"08:30 AM  – Breakfast\"}, {\"day\": 2, \"order\": 3, \"activity\": \"10:00 AM  - Boat ride\"}, {\"day\": 2, \"order\": 4, \"activity\": \"12:00 AM –Lunch\"}, {\"day\": 2, \"order\": 5, \"activity\": \"01:00 PM  –Back to Kigali\"}]', '[\"4x4 safari vehicle + professional Field guide\", \"Park entry fees\", \" Bottled water all included\", \"Meals (for multi-day safaris)\", \"Activities: Game drives, boat rides, night drives\"]', '[\"All that was not mentioned above is not included in the packages \"]', 'blob:http://localhost:5173/39dfc158-d59e-4d7f-af50-54ebba6df0ad', '[\"images-1761409913097-129906362.jpeg\", \"images-1761409913106-477488948.jpeg\", \"images-1761409913111-842901891.jpeg\", \"images-1761409913112-325345635.jpeg\", \"images-1761409913122-526963116.jpeg\", \"images-1761409913152-545497104.jpeg\"]', 'blob:http://localhost:5173/39dfc158-d59e-4d7f-af50-54ebba6df0ad', 'active', '2025-10-22 17:21:14', '2025-10-25 16:31:53'),
(21, 'golden-monkey-trekking-', 'Golden monkey Trekking ', 'Come face to face with mountain gorillas in their natural habitat during this private full-day gorilla-tracking excursion to Volcanoes National Park from Kigali.', 'Come face to face with mountain gorillas in their natural habitat during this private full-day gorilla-tracking excursion to Volcanoes National Park from Kigali.', 'wildlife', 4, 'Akagera national park', 1050.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"04:00 Am –Departure from the hotel\"}, {\"day\": 1, \"order\": 1, \"activity\": \" 07:00 Am- Arrival & Briefing \"}, {\"day\": 1, \"order\": 2, \"activity\": \"07:30 Am- Golden monkey Trekking (2 hours depending on the Primates you’re visiting)\"}, {\"day\": 1, \"order\": 3, \"activity\": \" 10:00 Am -Spend 1 magical hour with the Golden monkeys \"}, {\"day\": 1, \"order\": 4, \"activity\": \" 01:00 Pm –Lunch in Musanze\"}, {\"day\": 1, \"order\": 5, \"activity\": \"03:00 Pm – Back to Kigali \"}]', '[]', '[]', 'blob:http://localhost:5173/68299902-ef81-400b-9685-d0f280aa416f', '[\"images-1761409543723-620214170.jpeg\", \"images-1761409543729-429658819.jpeg\", \"images-1761409543730-778214479.jpeg\"]', 'blob:http://localhost:5173/68299902-ef81-400b-9685-d0f280aa416f', 'active', '2025-10-22 17:32:54', '2025-10-25 16:25:43'),
(22, '1-day-dian-fossey-tomb-hike-karisoke-research-center-', '1-Day Dian Fossey tomb hike& karisoke research center ', 'Embark on an inspiring one-day adventure dedicated to the legacy of Dr. Dian Fossey, the world-renowned primatologist who dedicated her life to the protection of mountain gorillas in Rwanda’s Volcanoes National Park.', 'Embark on an inspiring one-day adventure dedicated to the legacy of Dr. Dian Fossey, the world-renowned primatologist who dedicated her life to the protection of mountain gorillas in Rwanda’s Volcanoes National Park.', 'wildlife', 5, 'initial', 975.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"04:00 Am –Departure from the hotel\"}, {\"day\": 1, \"order\": 1, \"activity\": \"07:00 Am- Arrival&Briefing \"}, {\"day\": 1, \"order\": 2, \"activity\": \"07:30 Am- Gorilla trekking(1-2 hours round trip )\"}, {\"day\": 1, \"order\": 3, \"activity\": \" Spend 1 Learning about Dian Fosey’conservation,work and Legacy \"}, {\"day\": 1, \"order\": 4, \"activity\": \"02:00 Pm –Lunch in Musanze\"}, {\"day\": 1, \"order\": 5, \"activity\": \"04:00 Pm – Back to Kigali \"}]', '[\"Activities: Game drives, boat rides, night drives\"]', '[]', 'blob:http://localhost:5173/03bd5b7a-6086-4fd2-95cb-a56d1c866ac1', '[\"images-1761407757498-812209680.jpeg\", \"images-1761407757501-399396572.jpeg\", \"images-1761407757510-781680033.jpeg\"]', 'blob:http://localhost:5173/03bd5b7a-6086-4fd2-95cb-a56d1c866ac1', 'active', '2025-10-22 17:39:33', '2025-10-25 15:55:57'),
(23, '-2-days-musanze--kinigi-1-night2days-', ' 2-Days Musanze & Kinigi (1 Night,2Days )', 'Discover the breathtaking beauty of Rwanda’s Volcanoes region through a two-day adventure combining the world-famous Gorilla Trekking in Kinigi and an authentic Bigogwe Farm Experience. ', 'Discover the breathtaking beauty of Rwanda’s Volcanoes region through a two-day adventure combining the world-famous Gorilla Trekking in Kinigi and an authentic Bigogwe Farm Experience. ', 'wildlife', 5, 'Volcanoes National Park , Musanze', 2760.00, 'USD', 2, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"04:00 Am –Departure from the hotel\"}, {\"day\": 1, \"order\": 1, \"activity\": \"07:00 Am- Arrival&Briefing \"}, {\"day\": 1, \"order\": 2, \"activity\": \"07:30 Am- Gorilla trekking(2-6 hours depending on the family you’re visiting)\"}, {\"day\": 1, \"order\": 3, \"activity\": \"Spend 1 magical hour with the Gorillas once found \"}, {\"day\": 1, \"order\": 4, \"activity\": \"03:00 Pm –Lunch in Musanze\"}, {\"day\": 1, \"order\": 5, \"activity\": \"04:00 Pm –Hotel check in \"}, {\"day\": 1, \"order\": 6, \"activity\": \"05:00 Pm –Sunset viewpoint visit with panoramic volcano views\"}, {\"day\": 1, \"order\": 7, \"activity\": \"06:00 Pm-Return to hotel for Relaxation \"}, {\"day\": 1, \"order\": 8, \"activity\": \"19:00 Pm –Dinner at the hotel\"}, {\"day\": 1, \"order\": 9, \"activity\": \"20:30 Pm-Optional bonfire/early rest\"}, {\"day\": 2, \"order\": 0, \"activity\": \"7:00 Am –Breakfast at the hotel\"}, {\"day\": 2, \"order\": 1, \"activity\": \"08:00 Am- Relaxing at the hotel \"}, {\"day\": 2, \"order\": 2, \"activity\": \"09:30 Am –Hotel depature \"}, {\"day\": 2, \"order\": 3, \"activity\": \"10:00 Am – Guided orientation walk around Musanze town /local market visit\"}, {\"day\": 2, \"order\": 4, \"activity\": \"12:00 Pm –Lunch in Musanze city \"}, {\"day\": 2, \"order\": 5, \"activity\": \"14:00 Pm Bigogwe Farm activities: cow milking, local traditions, local food testing \"}, {\"day\": 2, \"order\": 6, \"activity\": \"16:00 Pm –Back to Kigali \"}, {\"day\": 2, \"order\": 7, \"activity\": \"19:00 pm- Arrival at the hotel\"}]', '[\"4x4 safari vehicle + professional Field guide\", \"Park entry fees\", \"Bottled water all included\", \" Meals (for multi-day safaris)\", \"Activities: Game drives, boat rides, night drives\"]', '[\"All that was not mentioned above is not included in the packages\"]', 'blob:http://localhost:5173/499ffb72-efd4-46fa-9902-0f9a1ba22a8f', '[\"images-1761408143331-613847160.jpeg\", \"images-1761408143395-695661295.jpeg\", \"images-1761408143419-342788395.JPG\"]', 'blob:http://localhost:5173/499ffb72-efd4-46fa-9902-0f9a1ba22a8f', 'active', '2025-10-22 17:52:27', '2025-10-25 16:02:24'),
(24, 'day-trip-lake-kivu', 'Day Trip (Lake kivu)', 'Experience a rejuvenating day trip from Kigali to Lake Kivu, one of Africa’s most beautiful freshwater lakes.', 'Experience a rejuvenating day trip from Kigali to Lake Kivu, one of Africa’s most beautiful freshwater lakes.', 'relaxation', 7, 'Lake Kivu', 340.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"05:30-06:00 Am -depart from Kigali earlier \"}, {\"day\": 1, \"order\": 1, \"activity\": \"08:00 -08:15 Am – Stopover at Sokoo \"}, {\"day\": 1, \"order\": 2, \"activity\": \"09:30 -10:00 Am-Arrival \"}, {\"day\": 1, \"order\": 3, \"activity\": \"10:30 -11:30 Am Exploring public beach&visit la corniche border \"}, {\"day\": 1, \"order\": 4, \"activity\": \"12:30-13:30 Pm –Kayaking or canoeing on the lake to explore islands and lakeshore villages\"}, {\"day\": 1, \"order\": 5, \"activity\": \"15:00 Pm Lunch \"}, {\"day\": 1, \"order\": 6, \"activity\": \"14:00 Pm -15:00 Pm -Relaxing at the lake (Swimming or sunbathing )nature walk around shoreline ,birdwatching \"}, {\"day\": 1, \"order\": 7, \"activity\": \"03:00 -05:00 Pm – Sunset boat cruise or evening paddle ;watch the lake light chang\"}, {\"day\": 1, \"order\": 8, \"activity\": \"16:00 Pm – Going back to Kigali\"}]', '[]', '[]', '/uploads/images-1761406508286-146213926.jpeg', '[\"images-1761406508268-781419945.jpeg\", \"images-1761406508277-635431223.jpeg\", \"images-1761406508286-146213926.jpeg\", \"images-1761406508288-233131735.jpeg\"]', '/uploads/images-1761406508286-146213926.jpeg', 'active', '2025-10-22 18:04:33', '2025-10-25 16:07:57'),
(25, 'lake-kivu-experience-', 'Lake Kivu Experience ', 'A peaceful two-day getaway to Lake Kivu, combining relaxation, adventure, and scenic exploration — ideal for travelers seeking a refreshing escape amidst Rwanda’s stunning natural beauty', 'A peaceful two-day getaway to Lake Kivu, combining relaxation, adventure, and scenic exploration — ideal for travelers seeking a refreshing escape amidst Rwanda’s stunning natural beauty', 'relaxation', 7, 'Lake Kivu', 530.00, 'USD', 2, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"06:00 AM  05:30- -depart from Kigali earlier\"}, {\"day\": 1, \"order\": 1, \"activity\": \"08:15 AM  08:00 - – Stopover at Sooko\"}, {\"day\": 1, \"order\": 2, \"activity\": \"10:00 AM  09:30 --Arrival\"}, {\"day\": 1, \"order\": 3, \"activity\": \"10:30 -11:30 Check in at the hotel \"}, {\"day\": 1, \"order\": 4, \"activity\": \"12:30-01 :30 Pm – Lunch \"}, {\"day\": 1, \"order\": 5, \"activity\": \"14:00 PM  02:30 - –Kayaking or canoeing on the lake to explore islands and lakeshore villages\"}, {\"day\": 1, \"order\": 6, \"activity\": \"06:00 PM  05 :00 - – Sunset boat cruise or evening paddle ;watch the lake light change\"}, {\"day\": 1, \"order\": 7, \"activity\": \"06 :00 Pm – 19: 00 Pm Dinner at the hotel/Restaurent\"}, {\"day\": 2, \"order\": 0, \"activity\": \"07:30 AM  06:30--Morning birdwatch or Sunrise beach walk\"}, {\"day\": 2, \"order\": 1, \"activity\": \"08:30 AM  07:30- –Breakfast\"}, {\"day\": 2, \"order\": 2, \"activity\": \"11:00 AM  08:30- – Natural Massage at Hotspring\"}, {\"day\": 2, \"order\": 3, \"activity\": \"01:30 PM  12:30- – Lunch\"}, {\"day\": 2, \"order\": 4, \"activity\": \"03:30 PM  01:30-- Park, relax, maybe a final swim or lakeshore walk\"}, {\"day\": 2, \"order\": 5, \"activity\": \"03:30 PM -19-00 Pm –depart back to Kigali \"}]', '[]', '[]', '/uploads/images-1761406275869-102129563.jpeg', '[\"images-1761406275858-559129376.jpeg\", \"images-1761406275869-293747445.jpeg\", \"images-1761406275869-102129563.jpeg\"]', '/uploads/images-1761406275869-102129563.jpeg', 'active', '2025-10-22 18:14:07', '2025-10-27 06:05:42'),
(26, '2-day-nyungwe-national-park', '2-Day Nyungwe National park', 'Embark on an unforgettable day trip to Nyungwe National Park, one of Africa’s oldest and most biodiverse rainforests.', 'Embark on an unforgettable day trip to Nyungwe National Park, one of Africa’s oldest and most biodiverse rainforests.', 'wildlife', 8, 'Nyungwe National Park', 1040.00, 'USD', 2, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"Adventure day\"}, {\"day\": 1, \"order\": 1, \"activity\": \"Canopy walk\"}, {\"day\": 1, \"order\": 2, \"activity\": \"Zipline \"}, {\"day\": 1, \"order\": 3, \"activity\": \"Zipline \"}, {\"day\": 1, \"order\": 4, \"activity\": \"Rope course\"}, {\"day\": 2, \"order\": 0, \"activity\": \"Chimpanzee trekking\"}, {\"day\": 2, \"order\": 1, \"activity\": \"Tea plantation experience at Gisakura\"}, {\"day\": 2, \"order\": 2, \"activity\": \"Visit at kings Palace\"}, {\"day\": 2, \"order\": 3, \"activity\": \"Head back to Kigali\"}]', '[]', '[]', '/uploads/images-1761407348451-680375313.jpeg', '[\"images-1761407348407-350287351.jpeg\", \"images-1761407348451-680375313.jpeg\", \"images-1761407348482-743086849.jpeg\", \"images-1761407348496-934391141.jpeg\"]', '/uploads/images-1761407348451-680375313.jpeg', 'active', '2025-10-22 18:20:27', '2025-10-27 06:01:14'),
(27, 'day-nyungwe-experience-day-trip', 'Day Nyungwe Experience (Day Trip)', 'Discover the wonders of Nyungwe National Park, a pristine rainforest in southwestern Rwanda known for its rich biodiversity, adventure activities, and cultural experiences.', 'Discover the wonders of Nyungwe National Park, a pristine rainforest in southwestern Rwanda known for its rich biodiversity, adventure activities, and cultural experiences.', 'wildlife', 8, 'Nyungwe National Park', 539.00, 'USD', 1, '', NULL, 'moderate', '[{\"day\": 1, \"order\": 0, \"activity\": \"Canopy walk\"}, {\"day\": 1, \"order\": 1, \"activity\": \"Zipline (connecting with nature)\"}, {\"day\": 1, \"order\": 2, \"activity\": \"Ndambarare Waterfall\"}, {\"day\": 1, \"order\": 3, \"activity\": \"Rope course \"}, {\"day\": 1, \"order\": 4, \"activity\": \"Return to Kigali\"}]', '[]', '[]', '/uploads/images-1761215876179-72101238.jpeg', '[\"images-1761215876179-72101238.jpeg\", \"images-1761215876182-674888508.jpeg\", \"images-1761215876199-472551408.jpeg\", \"images-1761215876210-922766419.jpeg\"]', '/uploads/images-1761215876179-72101238.jpeg', 'active', '2025-10-22 18:29:03', '2025-10-25 15:44:34'),
(28, 'history--culture', 'History & Culture', 'Immerse yourself in Rwanda’s rich history, resilience, and vibrant culture on this full-day guided tour through Kigali — the country’s dynamic capital and heart of transformation', 'Immerse yourself in Rwanda’s rich history, resilience, and vibrant culture on this full-day guided tour through Kigali — the country’s dynamic capital and heart of transformation', 'historical', 9, 'Kigali', 100.00, 'USD', 1, '', NULL, 'easy', '[{\"day\": 1, \"order\": 0, \"activity\": \"Kigali Genocide Memorial\"}, {\"day\": 1, \"order\": 1, \"activity\": \"Campaign Against Genocide Museum\"}, {\"day\": 1, \"order\": 2, \"activity\": \"Niyo Arts Gallery \"}, {\"day\": 1, \"order\": 3, \"activity\": \"Lunch at a local restaurant \"}, {\"day\": 1, \"order\": 4, \"activity\": \"Nyamirambo Women’s center walking tour \"}, {\"day\": 1, \"order\": 5, \"activity\": \"Kimironko Market experience\"}, {\"day\": 1, \"order\": 6, \"activity\": \"Sunset catchup at Kigali convention center \"}]', '[]', '[]', '/uploads/images-1761409162021-527021969.jpeg', '[\"images-1761215713837-539504578.jpeg\", \"images-1761215713841-615644937.jpeg\", \"images-1761409161978-94003080.jpeg\", \"images-1761409161987-500606872.jpeg\", \"images-1761409161995-696151276.jpeg\", \"images-1761409162021-527021969.jpeg\", \"images-1761409162023-581999019.jpeg\"]', '/uploads/images-1761409162021-527021969.jpeg', 'active', '2025-10-22 18:43:41', '2025-10-27 06:10:08');

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

--
-- Table structure for table `trash`
--

CREATE TABLE `trash` (
  `id` int NOT NULL,
  `item_type` enum('user','tour','booking','blog','gallery','car_rental') NOT NULL,
  `item_id` int NOT NULL,
  `item_data` json NOT NULL,
  `deleted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trash`
--

INSERT INTO `trash` (`id`, `item_type`, `item_id`, `item_data`, `deleted_at`, `deleted_by`) VALUES
(1, 'booking', 2, '{\"id\": 2, \"email\": \"ndahirobenjamin200@gmail.com\", \"phone\": \"0785547758\", \"status\": \"confirmed\", \"message\": null, \"tour_id\": 3, \"currency\": \"USD\", \"created_at\": \"2025-10-20T16:30:27.000Z\", \"updated_at\": \"2025-10-20T16:30:50.000Z\", \"travel_date\": \"2025-10-22T22:00:00.000Z\", \"total_amount\": \"1400.00\", \"customer_name\": \"KABANDA Edward\", \"special_requests\": null}', '2025-10-20 16:33:09', NULL),
(2, 'car_rental', 1, '{\"id\": 1, \"email\": \"f@g\", \"phone\": \"d\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": null, \"last_name\": \"b\", \"created_at\": \"2025-10-20T17:15:38.000Z\", \"first_name\": \"g\", \"passengers\": 1, \"updated_at\": \"2025-10-20T17:16:26.000Z\", \"pickup_date\": \"2025-10-13T22:00:00.000Z\", \"pickup_time\": \"19:18:00\", \"car_category\": \"premium\", \"total_amount\": null, \"driver_needed\": 1, \"pickup_location\": \"d\", \"dropoff_location\": \"d\"}', '2025-10-20 17:20:29', NULL),
(3, 'booking', 4, '{\"id\": 4, \"email\": \"ndahirobenjamin200@gmail.com\", \"phone\": \"0785547758\", \"status\": \"confirmed\", \"message\": null, \"tour_id\": 3, \"currency\": \"USD\", \"created_at\": \"2025-10-20T16:36:52.000Z\", \"updated_at\": \"2025-10-20T17:36:39.000Z\", \"travel_date\": \"2025-11-06T22:00:00.000Z\", \"total_amount\": \"200.00\", \"customer_name\": \"NDAHIRO Benjamin\", \"special_requests\": null}', '2025-10-20 17:36:46', NULL),
(4, 'booking', 5, '{\"id\": 5, \"pax\": 0, \"email\": \"romin@gmail.com\", \"phone\": \"0790000000\", \"status\": \"confirmed\", \"message\": \"We want something special\", \"tour_id\": 4, \"currency\": \"RWF\", \"created_at\": \"2025-10-21T08:26:59.000Z\", \"updated_at\": \"2025-10-21T08:47:11.000Z\", \"travel_date\": \"2025-10-28T22:00:00.000Z\", \"total_amount\": \"8000.00\", \"customer_name\": \"Romin Digital ltd\", \"special_requests\": null}', '2025-10-21 08:52:42', NULL),
(5, 'car_rental', 2, '{\"id\": 2, \"email\": \"ndahirobenjamin200@gmail.com\", \"phone\": \"0785547758\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": \"0785547758\", \"last_name\": \"NDAHIRO\", \"created_at\": \"2025-10-20T17:17:39.000Z\", \"first_name\": \"Benjamin\", \"passengers\": 4, \"updated_at\": \"2025-10-20T17:25:18.000Z\", \"pickup_date\": \"2025-10-20T22:00:00.000Z\", \"pickup_time\": \"15:30:00\", \"car_category\": \"small\", \"total_amount\": null, \"driver_needed\": 1, \"pickup_location\": \"Kigali\", \"dropoff_location\": \"Huye - Butare\"}', '2025-10-23 11:29:24', NULL),
(6, 'car_rental', 3, '{\"id\": 3, \"email\": \"ganzaeliphaz@gmail.com\", \"phone\": \"0794556595\", \"status\": \"pending\", \"currency\": \"USD\", \"whatsapp\": \"0794556595\", \"last_name\": \"Eliphaz\", \"created_at\": \"2025-10-20T18:59:26.000Z\", \"first_name\": \"Ganza \", \"passengers\": 2, \"updated_at\": \"2025-10-20T18:59:26.000Z\", \"pickup_date\": \"2025-10-20T22:00:00.000Z\", \"pickup_time\": \"15:20:00\", \"car_category\": \"luxury\", \"total_amount\": null, \"driver_needed\": 1, \"pickup_location\": \"Kigali\", \"dropoff_location\": \"Huye\"}', '2025-10-23 11:29:28', NULL),
(7, 'car_rental', 4, '{\"id\": 4, \"email\": \"ganzaeliphaz@gmail.com\", \"phone\": \"0794556595\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": \"0794556595\", \"last_name\": \"Eliphaz\", \"created_at\": \"2025-10-21T07:35:22.000Z\", \"first_name\": \"GANZA\", \"passengers\": 1, \"updated_at\": \"2025-10-21T07:38:57.000Z\", \"pickup_date\": \"2025-10-21T22:00:00.000Z\", \"pickup_time\": \"09:30:00\", \"car_category\": \"premium\", \"total_amount\": null, \"driver_needed\": 1, \"pickup_location\": \"Huye - Karambi\", \"dropoff_location\": \"Kigali - Nyamirambo, Tapi rouge\"}', '2025-10-23 11:29:32', NULL),
(8, 'car_rental', 11, '{\"id\": 11, \"email\": \"ganzaeliphaz@gmail.com\", \"phone\": \"yt\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": null, \"last_name\": \"Eliphaz\", \"created_at\": \"2025-10-23T14:22:23.000Z\", \"first_name\": \"GANZA\", \"passengers\": 3, \"updated_at\": \"2025-10-23T14:22:23.000Z\", \"pickup_date\": \"2025-10-16T22:00:00.000Z\", \"pickup_time\": \"20:22:00\", \"car_category\": \"premium\", \"total_amount\": \"60.00\", \"driver_needed\": 1, \"pickup_location\": \"tt\", \"dropoff_location\": \"tty\"}', '2025-10-23 14:28:58', NULL),
(9, 'car_rental', 10, '{\"id\": 10, \"email\": \"ganzaeliphaz@gmail.com\", \"phone\": \"f\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": null, \"last_name\": \"Eliphaz\", \"created_at\": \"2025-10-23T14:20:02.000Z\", \"first_name\": \"GANZA\", \"passengers\": 2, \"updated_at\": \"2025-10-23T14:20:02.000Z\", \"pickup_date\": \"2025-10-15T22:00:00.000Z\", \"pickup_time\": \"16:54:00\", \"car_category\": \"small\", \"total_amount\": \"30.00\", \"driver_needed\": 1, \"pickup_location\": \"r\", \"dropoff_location\": \"f\"}', '2025-10-23 14:29:02', NULL),
(10, 'car_rental', 9, '{\"id\": 9, \"email\": \"ganzaeliphaz@gmail.com\", \"phone\": \"0780005523\", \"status\": \"confirmed\", \"currency\": \"USD\", \"whatsapp\": \"0780005523\", \"last_name\": \"Eliphaz\", \"created_at\": \"2025-10-23T14:14:45.000Z\", \"first_name\": \"GANZA\", \"passengers\": 2, \"updated_at\": \"2025-10-23T14:14:45.000Z\", \"pickup_date\": \"2025-10-23T22:00:00.000Z\", \"pickup_time\": \"22:10:00\", \"car_category\": \"luxury\", \"total_amount\": \"100.00\", \"driver_needed\": 1, \"pickup_location\": \"Kigali - Kimisagara\", \"dropoff_location\": \"Nyaruguru - Kitabi\"}', '2025-10-23 14:29:06', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_id` (`blog_id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `idx_blog_posts_slug` (`slug`),
  ADD KEY `idx_blog_posts_status` (`status`),
  ADD KEY `idx_blog_posts_category` (`category`),
  ADD KEY `idx_blog_posts_published_at` (`published_at`);

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

--
-- Indexes for table `car_rentals`
--
ALTER TABLE `car_rentals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_car_rentals_status` (`status`),
  ADD KEY `idx_car_rentals_pickup_date` (`pickup_date`),
  ADD KEY `idx_car_rentals_email` (`email`);

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

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uploaded_by` (`uploaded_by`),
  ADD KEY `idx_gallery_category` (`category`);

--
-- Indexes for table `gallery_collections`
--
ALTER TABLE `gallery_collections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `uploaded_by` (`uploaded_by`),
  ADD KEY `idx_gallery_collections_slug` (`slug`),
  ADD KEY `idx_gallery_collections_category` (`category`),
  ADD KEY `idx_gallery_collections_status` (`status`);

--
-- Indexes for table `gallery_images`
--
ALTER TABLE `gallery_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_gallery_images_collection_id` (`collection_id`);

--
-- Indexes for table `newsletter_subscriptions`
--
ALTER TABLE `newsletter_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `idx_newsletter_email` (`email`),
  ADD KEY `idx_newsletter_active` (`is_active`),
  ADD KEY `idx_newsletter_subscribed_at` (`subscribed_at`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `tours`
--
ALTER TABLE `tours`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `idx_tours_slug` (`slug`),
  ADD KEY `idx_tours_type` (`type`),
  ADD KEY `idx_tours_status` (`status`),
  ADD KEY `fk_tours_destination_id` (`destination_id`);

--
-- Indexes for table `trash`
--
ALTER TABLE `trash`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deleted_by` (`deleted_by`),
  ADD KEY `idx_trash_item_type` (`item_type`),
  ADD KEY `idx_trash_deleted_at` (`deleted_at`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `car_rentals`
--
ALTER TABLE `car_rentals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `destinations`
--
ALTER TABLE `destinations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gallery_collections`
--
ALTER TABLE `gallery_collections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `gallery_images`
--
ALTER TABLE `gallery_images`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `newsletter_subscriptions`
--
ALTER TABLE `newsletter_subscriptions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `tours`
--
ALTER TABLE `tours`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `trash`
--
ALTER TABLE `trash`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD CONSTRAINT `blog_comments_ibfk_1` FOREIGN KEY (`blog_id`) REFERENCES `blog_posts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `gallery`
--
ALTER TABLE `gallery`
  ADD CONSTRAINT `gallery_ibfk_1` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `gallery_collections`
--
ALTER TABLE `gallery_collections`
  ADD CONSTRAINT `gallery_collections_ibfk_1` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `gallery_images`
--
ALTER TABLE `gallery_images`
  ADD CONSTRAINT `gallery_images_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `gallery_collections` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `tours`
--
ALTER TABLE `tours`
  ADD CONSTRAINT `fk_tours_destination_id` FOREIGN KEY (`destination_id`) REFERENCES `destinations` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `trash`
--
ALTER TABLE `trash`
  ADD CONSTRAINT `trash_ibfk_1` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

