-- =========================================================
-- Smart Job Travels & Tours (smartjobtours.lk)
-- Database: `smartjobdb` (MySQL / phpMyAdmin Compatible)
-- Currency: LKR (Sri Lankan Rupee)
-- Generated: 2026-11-16 12:53:13
-- =========================================================

SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
SET time_zone = '+00:00';
START TRANSACTION;

CREATE DATABASE IF NOT EXISTS `smartjobdb` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `smartjobdb`;

-- Table structure for table `cache`
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `cache_locks`
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `destination_activities`
DROP TABLE IF EXISTS `destination_activities`;
CREATE TABLE `destination_activities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `destination_id` bigint(20) unsigned NOT NULL,
  `activity` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_dact_dest` (`destination_id`),
  CONSTRAINT `fk_dact_dest` FOREIGN KEY (`destination_id`) REFERENCES `destinations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `destination_activities` (`id`, `destination_id`, `activity`, `sort_order`, `created_at`, `updated_at`) VALUES
('1', '1', 'Climbing the rock at early morning to beat the heat', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', '1', 'Hiking Pidurangala Rock for sunrise photography', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', '1', 'Taking an afternoon 4x4 open-top jeep safari at Minneriya', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', '1', 'Experiencing a traditional rural bullock cart & lake catamaran village tour', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', '1', 'Exploring the ancient cave murals with a knowledgeable local guide', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', '2', 'Photographing the blue train crossing the Nine Arch Bridge', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', '2', 'Hiking Little Adam\'s Peak at sunrise or golden hour', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', '2', 'Swimming at the natural rock pools of Diyaluma Falls', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', '2', 'Visiting a working tea plantation and sampling fresh Pekoe tea', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', '2', 'Relaxing at open-air hillside bistros and cafes in Ella town', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', '3', 'Embarking on a sunrise cruise to observe blue whales & dolphins', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', '3', 'Catching the sunset and ocean breezes at Coconut Tree Hill', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', '3', 'Taking a beginner surf lesson in Weligama Bay', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('14', '3', 'Snorkeling with wild sea turtles at Polhena or Turtle Beach', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('15', '3', 'Savoring grilled ocean catch at beachfront candlelit restaurants', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('36', '9', 'Taking a morning or afternoon 4x4 Jeep Safari with certified naturalist', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('37', '9', 'Watching rehabilitated baby elephants feed at Elephant Transit Home', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('38', '9', 'Photographing majestic bull elephants with the reservoir mountain backdrop', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('43', '8', 'Navigating through mangrove tunnels on a river cruise', '1', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('44', '8', 'Holding baby sea turtles and learning about marine conservation', '2', '2026-11-16 18:18:28', '2026-11-16 18:18:28');
INSERT INTO `destination_activities` (`id`, `destination_id`, `activity`, `sort_order`, `created_at`, `updated_at`) VALUES
('45', '8', 'Enjoying adrenaline-packed jet-skiing and windsurfing', '3', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('46', '8', 'Dining on fresh lagoon prawns and rock lobster by sunset', '4', '2026-11-16 18:18:28', '2026-11-16 18:18:28');

-- Table structure for table `destination_attractions`
DROP TABLE IF EXISTS `destination_attractions`;
CREATE TABLE `destination_attractions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `destination_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_da_dest` (`destination_id`),
  CONSTRAINT `fk_da_dest` FOREIGN KEY (`destination_id`) REFERENCES `destinations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `destination_attractions` (`id`, `destination_id`, `name`, `description`, `sort_order`, `created_at`, `updated_at`) VALUES
('1', '1', 'Sigiriya Rock Citadel', 'The crowning palace fortress and archaeological marvel.', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', '1', 'Pidurangala Rock', 'Adjacent rocky peak offering the most iconic sunrise view of Sigiriya.', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', '1', 'Dambulla Royal Cave Temple', 'Five sacred sanctuaries filled with intricate mural paintings and statues.', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', '1', 'Minneriya National Park', 'Famous for \'The Gathering\' of hundreds of wild Asian elephants at the reservoir.', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', '2', 'Nine Arch Bridge', 'Viaduct built entirely of solid stone and brick without steel.', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', '2', 'Little Adam\'s Peak', 'An easy 45-minute trek rewarding climbers with panoramic vistas.', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', '2', 'Ella Rock', 'Challenging morning hike through eucalyptus forests and tea terraces.', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', '2', 'Ravana Falls & Caves', 'Mythological waterfall linked to the ancient Ramayana epic.', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', '3', 'Coconut Tree Hill', 'Dramatic promontory of tall palm trees jutting into the Indian Ocean.', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', '3', 'Mirissa Main Beach', 'Golden sands safe for swimming and vibrant evening beach dining.', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', '3', 'Weligama Bay', 'Gentle sandy breaks ideal for learning to surf with certified instructors.', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', '3', 'Secret Beach', 'Hidden cove with calm natural rock tide pools.', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('33', '9', 'Udawalawe Reservoir', 'Vast water body where elephants bathe and fish eagles hunt.', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('34', '9', 'Elephant Transit Home (ETH)', 'Renowned rehabilitation center caring for orphaned elephant calves.', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('35', '9', 'Katuwewa & Mau Ara Plains', 'Open savannah expanses ideal for photography.', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('40', '8', 'Madu Ganga Mangrove River', 'Must-visit landmark in Bentota & Madu River', '1', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('41', '8', 'Kosgoda Sea Turtle Hatchery', 'Must-visit landmark in Bentota & Madu River', '2', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('42', '8', 'Lunuganga Estate', 'Must-visit landmark in Bentota & Madu River', '3', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('43', '8', 'Bentota Beach Spit', 'Must-visit landmark in Bentota & Madu River', '4', '2026-11-16 18:18:28', '2026-11-16 18:18:28');

-- Table structure for table `destination_highlights`
DROP TABLE IF EXISTS `destination_highlights`;
CREATE TABLE `destination_highlights` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `destination_id` bigint(20) unsigned NOT NULL,
  `highlight` text NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_dh_dest` (`destination_id`),
  CONSTRAINT `fk_dh_dest` FOREIGN KEY (`destination_id`) REFERENCES `destinations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `destination_highlights` (`id`, `destination_id`, `highlight`, `sort_order`, `created_at`, `updated_at`) VALUES
('1', '1', 'The monumental Lion\'s Paw entrance stairway carved from solid rock', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', '1', 'Ancient 5th-century frescoes depicting celestial maidens', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', '1', 'The polished Mirror Wall preserving ancient graffiti poetry', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', '1', 'Hydraulic water gardens and boulder landscaped terraces', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', '1', 'Panoramic 360-degree vistas over the emerald dry-zone jungle canopy', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', '1', 'Nearby Dambulla Cave Temple complex containing 153 Buddha statues', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', '2', 'The architectural wonder of Demodara Nine Arch Bridge', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', '2', 'Little Adam\'s Peak scenic hike with 360-degree mountain gap vistas', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', '2', 'The dramatic 25-meter cascade of Ravana Falls', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', '2', 'The world\'s most scenic blue train ride through tea plantations', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', '2', 'Flying Ravana Mega Zipline for thrill seekers', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', '2', 'Cozy mountain cafes, wellness retreats, and tea tasting rooms', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', '3', 'Ethical blue whale and spinner dolphin watching boat safaris', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('14', '3', 'Iconic sunset photography at the top of Coconut Tree Hill', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('15', '3', 'Surfing for beginners and intermediates in neighboring Weligama Bay', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('16', '3', 'Secluded, pristine sands at Secret Beach', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('17', '3', 'Snorkeling alongside gentle green sea turtles at Turtle Point', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('18', '3', 'Fresh seafood barbecues directly on the sand under fairy lights', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('44', '9', 'Guaranteed encounters with wild Asian elephants roaming open grasslands', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('45', '9', 'Visiting the Udawalawe Elephant Transit Home (ETH) milk feeding sessions', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16');
INSERT INTO `destination_highlights` (`id`, `destination_id`, `highlight`, `sort_order`, `created_at`, `updated_at`) VALUES
('46', '9', 'Water buffaloes, spotted deer, wild boars, and marsh crocodiles', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('47', '9', 'Spectacular birdwatching: white-bellied sea eagles, crested serpent eagles, and painted storks', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('48', '9', 'Scenic reservoir backdrop framed by distant misty mountain ranges', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('54', '8', 'Jet skiing, water skiing, wakeboarding, and banana boating on the lagoon', '1', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('55', '8', 'Madu River boat safari through 64 mangrove islets and fish spas', '2', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('56', '8', 'Releasing baby sea turtles to the ocean at Kosgoda Hatchery', '3', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('57', '8', 'Architectural brilliance at Geoffrey Bawa\'s Brief Garden and Lunuganga', '4', '2026-11-16 18:18:28', '2026-11-16 18:18:28'),
('58', '8', 'Wide, quiet sandy beach ideal for ocean swimming and sunbathing', '5', '2026-11-16 18:18:28', '2026-11-16 18:18:28');

-- Table structure for table `destinations`
DROP TABLE IF EXISTS `destinations`;
CREATE TABLE `destinations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `region` varchar(150) NOT NULL,
  `category` varchar(100) NOT NULL,
  `rating` decimal(3,2) NOT NULL DEFAULT 4.80,
  `reviews_count` int(11) NOT NULL DEFAULT 0,
  `duration` varchar(50) DEFAULT NULL,
  `starting_price` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `overview` longtext DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `destinations` (`id`, `slug`, `name`, `region`, `category`, `rating`, `reviews_count`, `duration`, `starting_price`, `image`, `overview`, `is_featured`, `is_active`, `created_at`, `updated_at`) VALUES
('1', 'sigiriya', 'Sigiriya & Dambulla', 'Cultural Triangle', 'cultural', '4.90', '240', '1-2 Days', 'From LKR 45', 'assets/img/destination/destination_1_1.jpg', 'Rising dramatically 200 meters above the central plains, Sigiriya is an awe-inspiring 5th-century palace citadel built atop a monolithic granite pillar by King Kashyapa. Renowned worldwide for its ancient mirror wall, colorful cloud maiden frescoes, and royal water pleasure gardens, it is designated a UNESCO World Heritage site and often hailed as the Eighth Wonder of the World.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 18:23:13'),
('2', 'ella', 'Ella & Demodara', 'Central Highlands', 'hillcountry', '5.00', '310', '2-3 Days', 'From LKR 55', 'assets/img/destination/destination_1_2.jpg', 'Ella is a peaceful hillside enclave nestled amidst cloud-capped mountain peaks, rolling tea estates, and rushing waterfalls. Famous worldwide for the spectacular colonial Nine Arch Bridge, hiking trails with breathtaking valley panoramas, and the legendary Main Line scenic train ride, Ella is Sri Lanka\'s ultimate hill country sanctuary.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 18:23:13'),
('3', 'mirissa', 'Mirissa & Weligama', 'Southern Coast', 'beaches', '4.90', '280', '2-4 Days', 'From LKR 50', 'assets/img/destination/destination_1_3.jpg', 'Mirissa is Sri Lanka\'s premier coastal haven, celebrated for its crescent-shaped golden swimming beach, vibrant beachfront dining, and worldwide fame as one of the best locations on earth to encounter the colossal Blue Whale in its natural ocean habitat.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 18:23:13'),
('8', 'bentota', 'Bentota & Madu River', 'Southwestern Coast', 'beaches', '4.80', '160', '1-2 Days', 'From LKR 40', 'assets/img/destination/destination_1_8.jpg', 'Bentota is Sri Lanka\'s watersports capital, where a tranquil coastal lagoon runs parallel to long stretches of golden sand. It is internationally celebrated for boat safaris through mangrove tunnels on the Madu Ganga, sea turtle conservation hatcheries, and luxury beach resorts.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 18:23:13'),
('9', 'udawalawe', 'Udawalawe National Park', 'Southern Wildlife Plains', 'wildlife', '4.90', '140', '1 Day', 'From LKR 60', 'assets/img/hero/hero_bg_1_3.jpg', 'Centering on a vast scenic reservoir with the dramatic backdrop of the Horton Plains mountain range, Udawalawe is reminiscent of an East African savannah. It is one of the world\'s most reliable places to witness wild Asian elephants in open terrain, with herds often numbering over 20-30 individuals.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 18:23:13');

-- Table structure for table `enquiries`
DROP TABLE IF EXISTS `enquiries`;
CREATE TABLE `enquiries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'general',
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `travel_date` varchar(100) DEFAULT NULL,
  `travellers` varchar(50) DEFAULT NULL,
  `transfer_type` varchar(100) DEFAULT NULL,
  `airport` varchar(150) DEFAULT NULL,
  `flight_number` varchar(100) DEFAULT NULL,
  `flight_time` varchar(100) DEFAULT NULL,
  `pickup_location` varchar(255) DEFAULT NULL,
  `dropoff_location` varchar(255) DEFAULT NULL,
  `vehicle_type` varchar(255) DEFAULT NULL,
  `luggage` varchar(50) DEFAULT NULL,
  `duration_days` varchar(50) DEFAULT NULL,
  `accommodation` varchar(100) DEFAULT NULL,
  `interests` text DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `status` enum('New','Contacted','Confirmed','Completed','Cancelled') NOT NULL DEFAULT 'New',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_no` (`reference_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `enquiries` (`id`, `reference_no`, `type`, `name`, `email`, `phone`, `subject`, `travel_date`, `travellers`, `transfer_type`, `airport`, `flight_number`, `flight_time`, `pickup_location`, `dropoff_location`, `vehicle_type`, `luggage`, `duration_days`, `accommodation`, `interests`, `country`, `message`, `status`, `created_at`, `updated_at`) VALUES
('1', 'ENQ-1001', 'tour', 'David Watson', 'david.watson@gmail.com', '+44 7911 123456', '10-Day Heritage, Wildlife & Southern Beach Odyssey', '2026-12-10', '2 Adults', 'Round Tour Private Chauffeur', 'Bandaranaike International (CMB)', 'BA-2159', '07:45 AM', 'CMB Airport Arrivals Hall', 'CMB Airport Departures', 'Comfort Sedan (Toyota Prius / Axio)', '2 Large Bags', '10 Days', '4-Star Boutique Hotels & Eco Resorts', 'Wildlife Safaris, Cultural Heritage, Tea Trails, Scenic Train', 'United Kingdom', 'Celebrating our 10th anniversary. We would love ocean view rooms in Mirissa and guaranteed observation class train tickets.', 'Confirmed', '2026-11-04 14:20:00', '2026-11-16 17:52:16'),
('2', 'ENQ-1002', 'airport', 'Marcus Lindqvist', 'marcus.l@stockholm-tech.se', '+46 70 123 4567', 'Airport Transfer CMB to Galle Fort', '2026-11-20', '2 Passengers', 'One-Way Airport Arrival Transfer', 'Bandaranaike International (CMB)', 'QR-664', '08:30 AM', 'CMB Airport Terminal', 'Fort Bazaar Hotel, Galle Fort', 'Comfort Sedan (Toyota Prius / Axio)', '2 Suitcases', '1 Day', 'N/A (Transfer Only)', 'Express Highway Transit', 'Sweden', 'Please provide driver details on WhatsApp prior to arrival.', 'Confirmed', '2026-11-08 09:15:00', '2026-11-16 17:52:16'),
('3', 'ENQ-1003', 'plan', 'Sophie Moreau', 'sophie.moreau@paris-design.fr', '+33 6 12 34 56 78', 'Custom 8-Day Family Itinerary (With 2 Children)', '2026-12-24', '4 Passengers (2 Adults, 2 Kids)', 'Full Private Tour with Driver', 'Bandaranaike International (CMB)', 'AF-244', '15:20 PM', 'CMB Airport', 'Colombo City Hotel', 'Luxury KDH Van (Toyota HiAce) - 4 to 8 Pax', '4 Bags', '8 Days', 'Family Suites / 4-Star Resort with Pool', 'Sigiriya Rock, Elephant Orphanage, Ella Nine Arch Bridge, Yala Safari', 'France', 'Our kids are 7 and 10 years old. We prefer child-friendly activity pacing without overly strenuous hikes.', 'Contacted', '2026-11-10 11:45:00', '2026-11-16 17:52:16'),
('4', 'ENQ-1004', 'tour', 'Alexander Schmidt', 'a.schmidt@berlin-consult.de', '+49 151 2345678', '7-Day Classic Sri Lanka Discovery', '2027-01-15', '2 Adults', 'Round Tour Private Chauffeur', 'Bandaranaike International (CMB)', 'LH-760', '10:00 AM', 'CMB Airport', 'CMB Airport', 'Comfort Sedan (Toyota Prius / Axio)', '2 Bags', '7 Days', '5-Star Luxury Heritage Hotels', 'Culture, Photography, Ceylon Tea Factories', 'Germany', 'Please quote with 5-star hotel options included.', 'New', '2026-11-12 16:30:00', '2026-11-16 17:52:16'),
('5', 'ENQ-1005', 'transport', 'Sarah Jenkins', 'sarah.j@sydney-travels.com.au', '+61 412 345 678', 'Private Chauffeur & Van Hire for 6 Days', '2027-02-01', '5 Adults', 'Dedicated Chauffeur & Van', 'Bandaranaike International (CMB)', 'SQ-468', '23:10 PM', 'Cinnamon Grand Colombo', 'Heritance Tea Factory, Nuwara Eliya', 'Luxury KDH Van (Toyota HiAce)', '5 Suitcases', '6 Days', 'Pre-booked by ourselves', 'Flexible stopping, photography, waterfalls', 'Australia', 'Need an English-fluent driver experienced with mountain driving.', 'New', '2026-11-15 08:00:00', '2026-11-16 17:52:16');

-- Table structure for table `failed_jobs`
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `gallery_items`
DROP TABLE IF EXISTS `gallery_items`;
CREATE TABLE `gallery_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_code` varchar(100) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  `location` varchar(150) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `gallery_items` (`id`, `code`, `title`, `category_code`, `category_name`, `location`, `image`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
('1', 'gal-1794823914-490', 'tesds', 'cultural', 'Cultural Heritage', 'vsdv', 'uploads/gallery/gal_1794823914_3401.jpeg', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'gal-1', 'Sigiriya Rock Citadel & Gardens', 'cultural', 'Cultural Heritage', 'Sigiriya', 'assets/img/destination/destination_1_1.jpg', '2', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'gal-2', 'Demodara Nine Arch Bridge', 'hillcountry', 'Scenic Hill Country', 'Ella', 'assets/img/hero/hero_bg_1_2.jpg', '3', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'gal-3', 'Mirissa Coconut Tree Hill', 'beaches', 'Beaches & Coast', 'Mirissa', 'assets/img/hero/hero_bg_1_1.jpg', '4', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', 'gal-4', 'Wild Elephants in Natural Habitat', 'wildlife', 'Wildlife & Safaris', 'Yala National Park', 'assets/img/hero/hero_bg_1_3.jpg', '5', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', 'gal-5', 'Historic Galle Fort Lighthouse', 'cultural', 'Cultural Heritage', 'Galle', 'assets/img/destination/destination_1_5.jpg', '6', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', 'gal-6', 'Lush Highland Ceylon Tea Plantations', 'hillcountry', 'Scenic Hill Country', 'Nuwara Eliya', 'assets/img/destination/destination_1_7.jpg', '7', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', 'gal-7', 'Yala Safari Leopard Country', 'wildlife', 'Wildlife & Safaris', 'Yala', 'assets/img/destination/destination_1_4.jpg', '8', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', 'gal-8', 'Golden Sands & Palm Shores', 'beaches', 'Beaches & Coast', 'Bentota', 'assets/img/destination/destination_1_8.jpg', '9', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', 'gal-9', 'Traditional Ceylon Tea Plucking', 'hillcountry', 'Scenic Hill Country', 'Central Highlands', 'assets/img/normal/about_1_1.jpg', '10', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', 'gal-10', 'Sacred Temple of the Tooth Relic', 'cultural', 'Cultural Heritage', 'Kandy', 'assets/img/destination/destination_1_6.jpg', '11', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', 'gal-11', 'Tropical Island Sunset & Ocean Waves', 'beaches', 'Beaches & Coast', 'Southern Coast', 'assets/img/gallery/gallery_1_1.jpg', '12', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', 'gal-12', 'Scenic Highland Mountain Train Ride', 'hillcountry', 'Scenic Hill Country', 'Nanu Oya - Ella', 'assets/img/gallery/gallery_1_4.jpg', '13', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `job_batches`
DROP TABLE IF EXISTS `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `jobs`
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `package_destinations`
DROP TABLE IF EXISTS `package_destinations`;
CREATE TABLE `package_destinations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `destination_id` bigint(20) unsigned NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `fk_pd_pkg` (`package_id`),
  KEY `fk_pd_dest` (`destination_id`),
  CONSTRAINT `fk_pd_dest` FOREIGN KEY (`destination_id`) REFERENCES `destinations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pd_pkg` FOREIGN KEY (`package_id`) REFERENCES `tour_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `package_destinations` (`id`, `package_id`, `destination_id`, `sort_order`) VALUES
('1', '1', '1', '1'),
('2', '2', '1', '2'),
('3', '5', '1', '3'),
('4', '1', '2', '1'),
('5', '2', '2', '2'),
('6', '3', '2', '3'),
('7', '2', '3', '1'),
('8', '4', '3', '2'),
('9', '6', '3', '3'),
('22', '4', '8', '1'),
('23', '1', '8', '2'),
('24', '2', '8', '3'),
('25', '2', '9', '1'),
('26', '6', '9', '2');

-- Table structure for table `package_features`
DROP TABLE IF EXISTS `package_features`;
CREATE TABLE `package_features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `type` enum('inclusion','exclusion') NOT NULL,
  `feature_text` text NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_pf_pkg` (`package_id`),
  CONSTRAINT `fk_pf_pkg` FOREIGN KEY (`package_id`) REFERENCES `tour_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `package_features` (`id`, `package_id`, `type`, `feature_text`, `sort_order`, `created_at`, `updated_at`) VALUES
('1', '1', 'inclusion', 'Private air-conditioned vehicle with English-speaking chauffeur guide', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', '1', 'inclusion', 'Airport meet & greet with complimentary chilled water & wet wipes', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', '1', 'inclusion', 'All fuel, highway toll charges, parking fees, and driver allowances', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', '1', 'inclusion', 'Scenic train tickets from Nuwara Eliya to Ella (subject to availability)', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', '1', 'inclusion', 'Ceylon tea factory visit with complimentary tea tasting', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', '1', 'inclusion', '24/7 dedicated local island travel assistance', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', '1', 'exclusion', 'International flight tickets & Sri Lanka tourist visa (ETA)', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', '1', 'exclusion', 'Hotel accommodation (can be packaged upon request)', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', '1', 'exclusion', 'Monument and national park entrance fees', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', '1', 'exclusion', 'Personal expenses, laundry, telephone calls, and gratuities', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', '2', 'inclusion', 'Dedicated luxury AC vehicle with licensed private chauffeur', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', '2', 'inclusion', 'Airport pickup & drop-off with 24/7 flight monitoring', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', '2', 'inclusion', 'All fuel, highway expressway tolls, and driver board/lodging', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('14', '2', 'inclusion', 'Yala National Park private 4x4 safari jeep arrangement', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('15', '2', 'inclusion', 'Scenic train tickets (Nuwara Eliya - Ella)', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('16', '2', 'inclusion', '24/7 WhatsApp emergency and itinerary support', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('17', '2', 'exclusion', 'International flights and visa fees', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('18', '2', 'exclusion', 'Park tickets and monument entrance fees', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('19', '2', 'exclusion', 'Meals other than specified', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('20', '2', 'exclusion', 'Tips and personal expenses', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16');
INSERT INTO `package_features` (`id`, `package_id`, `type`, `feature_text`, `sort_order`, `created_at`, `updated_at`) VALUES
('21', '3', 'inclusion', 'Private air-conditioned car/van with English-speaking chauffeur', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('22', '3', 'inclusion', 'Scenic train tickets between mountain stations', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('23', '3', 'inclusion', 'Highland tea tasting and factory tour', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('24', '3', 'inclusion', 'All road tolls, fuel, and parking charges', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('25', '3', 'exclusion', 'Horton Plains National Park entrance ticket', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('26', '3', 'exclusion', 'Hotels and meals', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('27', '3', 'exclusion', 'Personal items and gratuities', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('28', '4', 'inclusion', 'Private AC transport with licensed driver guide', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('29', '4', 'inclusion', 'Expressway tolls, fuel, and parking fees', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('30', '4', 'inclusion', '24/7 on-tour customer support', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('31', '4', 'exclusion', 'Whale watching boat tickets', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('32', '4', 'exclusion', 'Water sports equipment hire', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('33', '4', 'exclusion', 'Meals and accommodation', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('34', '5', 'inclusion', 'Private air-conditioned vehicle with driver guide', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('35', '5', 'inclusion', 'All fuel, highway charges, and driver expenses', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('36', '5', 'inclusion', 'Flexible itinerary pacing', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('37', '5', 'exclusion', 'Site entry fees and safari jeep hire', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('38', '5', 'exclusion', 'Accommodation and meals', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('39', '6', 'inclusion', 'Exclusive luxury AC vehicle and senior chauffeur guide for 14 days', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('40', '6', 'inclusion', 'All fuel, highway tolls, parking fees, and driver expenses', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16');
INSERT INTO `package_features` (`id`, `package_id`, `type`, `feature_text`, `sort_order`, `created_at`, `updated_at`) VALUES
('41', '6', 'inclusion', 'Scenic train tickets (highland segment)', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('42', '6', 'inclusion', 'Round-the-clock VIP guest coordination', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('43', '6', 'exclusion', 'Hotels and meals (available as custom add-on)', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('44', '6', 'exclusion', 'Park and monument entry tickets', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('45', '6', 'exclusion', 'Personal expenses and gratuities', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `package_itineraries`
DROP TABLE IF EXISTS `package_itineraries`;
CREATE TABLE `package_itineraries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `day_number` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `location_name` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `morning_plan` text DEFAULT NULL,
  `afternoon_plan` text DEFAULT NULL,
  `evening_plan` text DEFAULT NULL,
  `stay_location` varchar(255) DEFAULT NULL,
  `meals` varchar(150) DEFAULT NULL,
  `drive_time` varchar(150) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_pi_pkg` (`package_id`),
  CONSTRAINT `fk_pi_pkg` FOREIGN KEY (`package_id`) REFERENCES `tour_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `package_itineraries` (`id`, `package_id`, `day_number`, `title`, `description`, `latitude`, `longitude`, `location_name`, `photo`, `morning_plan`, `afternoon_plan`, `evening_plan`, `stay_location`, `meals`, `drive_time`, `created_at`, `updated_at`) VALUES
('1', '1', '1', 'Airport Arrival & Transfer to Sigiriya via Pinnawala', 'Warm welcome at Bandaranaike International Airport (CMB) by your private chauffeur guide. Journey into the Cultural Triangle with optional elephant transit visit.', '7.1808000', '79.8841000', 'Bandaranaike Airport (CMB)', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Bandaranaike Airport (CMB)', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', '1', '2', 'Sigiriya Rock Fortress & Dambulla Golden Temple', 'Morning climb of the ancient Sigiriya Lion Rock fortress. Afternoon exploration of the five sacred rock cave temples at Dambulla.', '7.9570000', '80.7603000', 'Sigiriya Rock Fortress', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Sigiriya Rock Fortress', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', '1', '3', 'Kandy Sacred City & Temple of the Tooth', 'Drive to Kandy via a spice garden. Visit the Sacred Temple of the Tooth Relic, stroll Kandy Lake, and experience a cultural dance performance.', '7.2906000', '80.6337000', 'Kandy Sacred City', 'assets/img/destination/destination_1_6.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Kandy Sacred City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', '1', '4', 'Peradeniya Royal Gardens & Nuwara Eliya Tea Country', 'Tour the lush Royal Botanical Gardens. Ascend into misty tea country, visit a functioning Ceylon tea factory, and view Ramboda Falls.', '6.9497000', '80.7891000', 'Nuwara Eliya Tea Country', 'assets/img/destination/destination_1_7.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Nuwara Eliya Tea Country', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', '1', '5', 'Scenic Blue Train Ride to Ella & Nine Arch Bridge', 'Board the iconic mountain railway to Ella. Trek to the famous Nine Arch Bridge and catch panoramic mountain views from Little Adam\'s Peak.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', '1', '6', 'Ella to Galle Dutch Fort via Ravana Falls', 'Descend to the southern coast via Ravana Falls. Explore UNESCO-listed Galle Dutch Fort\'s cobblestone streets, boutiques, and lighthouse.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', '1', '7', 'Bentota Coastal Drive & Departure Colombo Airport', 'Leisurely coastal drive with optional mangrove river boat safari. Transfer to Colombo airport for your departure flight.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', '2', '1', 'Arrival & Transfer to Negombo / Sigiriya', 'Airport greeting and scenic drive to your hotel.', '7.1808000', '79.8841000', 'Bandaranaike Airport (CMB)', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Bandaranaike Airport (CMB)', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', '2', '2', 'Sigiriya Rock & Minneriya Elephant Safari', 'Early climb of Sigiriya Rock Fortress. Afternoon open-top Jeep Safari at Minneriya to witness wild elephant herds.', '7.9570000', '80.7603000', 'Sigiriya Rock Fortress', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Sigiriya Rock Fortress', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', '2', '3', 'Polonnaruwa Ancient Kingdom & Dambulla Caves', 'Bicycle or car tour of Polonnaruwa\'s carved stone Buddhas, followed by Dambulla cave temples.', '7.8742000', '80.6511000', 'Dambulla Golden Cave Temple', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Dambulla Golden Cave Temple', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', '2', '4', 'Drive to Kandy & Cultural Dancing', 'Matale spice gardens, Tooth Relic Temple, and evening traditional Kandyan drumming and fire walking.', '7.2906000', '80.6337000', 'Kandy Sacred City', 'assets/img/destination/destination_1_6.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Kandy Sacred City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', '2', '5', 'Nuwara Eliya Tea Gardens & Waterfalls', 'Drive through lush tea plantations, factory tour, Gregory Lake stroll, and colonial architecture.', '6.9497000', '80.7891000', 'Nuwara Eliya Tea Country', 'assets/img/destination/destination_1_7.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Nuwara Eliya Tea Country', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', '2', '6', 'Scenic Train to Ella & Little Adam\'s Peak', 'Spectacular rail journey through mountain tunnels and tea plantations. Trek Little Adam\'s Peak.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('14', '2', '7', 'Ella to Yala National Park Leopard Safari', 'Morning at Nine Arch Bridge. Afternoon 4x4 game drive in Yala searching for leopards, bears, and elephants.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('15', '2', '8', 'Yala to Mirissa Beach & Coconut Tree Hill', 'Travel to Mirissa\'s golden crescent beach. Sunset photography at Coconut Tree Hill.', '6.3683000', '81.5168000', 'Yala National Park Safari', 'assets/img/destination/destination_1_4.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Yala National Park Safari', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('16', '2', '9', 'Whale Watching & Galle Dutch Fort', 'Early morning boat safari to spot blue whales. Afternoon exploration of UNESCO Galle Fort.', '6.0329000', '80.2168000', 'Galle Dutch Fort', 'assets/img/destination/destination_1_5.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Galle Dutch Fort', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('17', '2', '10', 'Colombo City Highlights & Airport Drop', 'Colombo shopping and sightseeing before airport departure transfer.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('18', '3', '1', 'Colombo to Kandy', 'Pick up and drive to Kandy. Visit Temple of the Tooth and lake drive.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('19', '3', '2', 'Kandy to Nuwara Eliya', 'Royal Botanical Gardens, Ramboda Falls, and tea plantation tour.', '7.2906000', '80.6337000', 'Kandy Sacred City', 'assets/img/destination/destination_1_6.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Kandy Sacred City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('20', '3', '3', 'Horton Plains World\'s End & Little England', 'Early morning trek through cloud forests to Baker\'s Falls and World\'s End. Afternoon at Lake Gregory.', '6.8028000', '80.8044000', 'Horton Plains & World\'s End', 'assets/img/destination/destination_1_7.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Horton Plains & World\'s End', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16');
INSERT INTO `package_itineraries` (`id`, `package_id`, `day_number`, `title`, `description`, `latitude`, `longitude`, `location_name`, `photo`, `morning_plan`, `afternoon_plan`, `evening_plan`, `stay_location`, `meals`, `drive_time`, `created_at`, `updated_at`) VALUES
('21', '3', '4', 'Iconic Train Journey to Ella', 'Ride the tea country train. Visit Nine Arch Bridge and Little Adam\'s Peak.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('22', '3', '5', 'Ella to Colombo / Airport', 'Ravana Falls photo stop and scenic drive down to Colombo or CMB airport.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('23', '4', '1', 'Colombo to Bentota Beach', 'Pick up, drive to Bentota. Madu River boat safari and turtle hatchery.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('24', '4', '2', 'Bentota to Galle Fort & Mirissa', 'Walk the historical ramparts of Galle Fort, lighthouse visit, and transfer to Mirissa.', '5.9482000', '80.4578000', 'Mirissa Beach & Whale Watching', 'assets/img/destination/destination_1_3.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Mirissa Beach & Whale Watching', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('25', '4', '3', 'Mirissa Blue Whale Watching Safari', 'Morning ocean cruise to observe blue whales. Afternoon relaxing at Mirissa Beach or surfing in Weligama.', '5.9482000', '80.4578000', 'Mirissa Beach & Whale Watching', 'assets/img/destination/destination_1_3.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Mirissa Beach & Whale Watching', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('26', '4', '4', 'Coconut Tree Hill & Return to Colombo', 'Morning photo shoot at Coconut Tree Hill. Return via Southern Expressway to Colombo/Airport.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('27', '5', '1', 'Colombo to Sigiriya via Dambulla', 'Pick up and drive to Dambulla. Explore the 5 cave sanctuaries.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('28', '5', '2', 'Sigiriya Lion Rock & Elephant Safari', 'Morning climb of Sigiriya. Afternoon 4x4 Jeep Safari at Minneriya.', '7.9570000', '80.7603000', 'Sigiriya Rock Fortress', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Sigiriya Rock Fortress', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('29', '5', '3', 'Village Tour & Return to Colombo', 'Traditional rural village experience with lake boat ride and local lunch. Return to Colombo.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('30', '6', '1', 'Arrival CMB to Anuradhapura', 'Airport pickup and drive to Sri Lanka\'s first ancient kingdom.', '7.1808000', '79.8841000', 'Bandaranaike Airport (CMB)', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Bandaranaike Airport (CMB)', 'Dinner Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('31', '6', '2', 'Anuradhapura to Jaffna', 'Ruwanwelisaya, Bodhi tree, and scenic drive across Elephant Pass to Jaffna.', '8.3114000', '80.4037000', 'Anuradhapura Ancient Capital', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Anuradhapura Ancient Capital', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('32', '6', '3', 'Jaffna Heritage Exploration', 'Nallur Kovil, Jaffna Fort, Casuarina Beach, and vibrant northern culture.', '9.6615000', '80.0255000', 'Jaffna Peninsula & Fort', 'assets/img/destination/destination_1_5.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Jaffna Peninsula & Fort', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('33', '6', '4', 'Jaffna to Trincomalee', 'Drive to eastern coast. Visit Koneswaram Temple overlooking Swami Rock.', '8.5874000', '81.2152000', 'Trincomalee & Pigeon Island', 'assets/img/destination/destination_1_8.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Trincomalee & Pigeon Island', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('34', '6', '5', 'Pigeon Island Snorkeling', 'Boat trip to Pigeon Island National Park for reef snorkeling with turtles.', '6.9271000', '79.8612000', 'Colombo City', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Colombo City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('35', '6', '6', 'Trincomalee to Sigiriya', 'Travel to Cultural Triangle. Sunset at Pidurangala Rock.', '7.9570000', '80.7603000', 'Sigiriya Rock Fortress', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Sigiriya Rock Fortress', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('36', '6', '7', 'Sigiriya Fortress & Minneriya Safari', 'Morning climb of Lion Rock and afternoon elephant safari.', '7.9570000', '80.7603000', 'Sigiriya Rock Fortress', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Sigiriya Rock Fortress', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('37', '6', '8', 'Dambulla to Kandy', 'Cave temple tour and drive to Kandy for Tooth Temple and cultural show.', '7.8742000', '80.6511000', 'Dambulla Golden Cave Temple', 'assets/img/destination/destination_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Dambulla Golden Cave Temple', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('38', '6', '9', 'Kandy to Nuwara Eliya', 'Botanical gardens, Ramboda Falls, and highland Ceylon tea estate.', '7.2906000', '80.6337000', 'Kandy Sacred City', 'assets/img/destination/destination_1_6.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Kandy Sacred City', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('39', '6', '10', 'Horton Plains & Blue Train to Ella', 'Morning World\'s End trek, afternoon train ride across Demodara.', '6.8028000', '80.8044000', 'Horton Plains & World\'s End', 'assets/img/destination/destination_1_7.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Horton Plains & World\'s End', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('40', '6', '11', 'Ella to Yala National Park', 'Nine Arch Bridge and afternoon 4x4 Jeep Safari in Yala.', '6.8667000', '81.0466000', 'Ella & Nine Arch Bridge', 'assets/img/destination/destination_1_2.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Ella & Nine Arch Bridge', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16');
INSERT INTO `package_itineraries` (`id`, `package_id`, `day_number`, `title`, `description`, `latitude`, `longitude`, `location_name`, `photo`, `morning_plan`, `afternoon_plan`, `evening_plan`, `stay_location`, `meals`, `drive_time`, `created_at`, `updated_at`) VALUES
('41', '6', '12', 'Yala to Mirissa & Weligama', 'Coastal drive to Mirissa. Sunset at Coconut Tree Hill.', '6.3683000', '81.5168000', 'Yala National Park Safari', 'assets/img/destination/destination_1_4.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Yala National Park Safari', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('42', '6', '13', 'Whale Watching & Galle Dutch Fort', 'Blue whale cruise in morning, afternoon walking tour of Galle Fort.', '6.0329000', '80.2168000', 'Galle Dutch Fort', 'assets/img/destination/destination_1_5.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Galle Dutch Fort', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('43', '6', '14', 'Bentota Coastal Drive to Airport', 'River safari and transfer to airport for departure.', '7.1808000', '79.8841000', 'Bandaranaike Airport (CMB)', 'assets/img/hero/hero_bg_1_1.jpg', 'Breakfast at hotel and meet your private chauffeur guide to start today\'s journey.', 'Guided sightseeing and authentic local exploration with photo opportunities.', 'Relax at your resort, enjoy authentic Sri Lankan cuisine, and unwind for the night.', 'Bandaranaike Airport (CMB)', 'Breakfast Included', '~2 to 3 hrs scenic transit', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `password_reset_tokens`
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `reviews`
DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `country` varchar(100) NOT NULL,
  `tour_title` varchar(255) DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 5,
  `review` text NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 1,
  `review_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `reviews` (`id`, `name`, `country`, `tour_title`, `rating`, `review`, `avatar`, `is_featured`, `review_date`, `created_at`, `updated_at`) VALUES
('1', 'David & Emma Watson', 'United Kingdom', '10-Day Heritage, Wildlife & Southern Beach Odyssey', '5', 'Our 10-day tour with Smart Job Travels was beyond extraordinary! Our chauffeur guide was attentive, knowledgeable, and made us feel safe throughout. The private tea plantation visit in Nuwara Eliya and the leopard safari in Yala were unforgettable highlights.', 'assets/img/testimonial/testi_1_1.jpg', '1', '2026-10-14', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'Marcus Lindqvist', 'Sweden', 'Scenic Hill Country & Ceylon Tea Trails', '5', 'Booking directly with a local Sri Lankan agency made all the difference. Transparent prices, modern luxury van, and seamless CMB airport transfers. Highly recommend Smart Job Travels to anyone visiting Sri Lanka!', 'assets/img/testimonial/testi_1_2.jpg', '1', '2026-10-28', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'Sophie Moreau', 'France', 'Tailor-Made Family Island Discovery', '5', 'Superb experience! The custom itinerary they designed for our family of four was perfectly paced. The kids loved the Sigiriya climb and the elephant transit home in Udawalawe. Thank you so much!', 'assets/img/testimonial/testi_1_3.jpg', '1', '2026-11-02', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'Alexander Schmidt', 'Germany', '7-Day Classic Sri Lanka Discovery', '5', 'Everything worked like clockwork. The private chauffeur was punctual every single morning, the vehicle was spotless, and the hotels chosen were top tier. We will definitely return!', 'assets/img/testimonial/testi_1_1.jpg', '1', '2026-11-08', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', 'Liam & Olivia Brown', 'Australia', 'Southern Coast & Whale Watching Escapade', '5', 'Seeing blue whales breach in Mirissa was a bucket-list dream fulfilled. Smart Job Travels organized our VIP boat charter and our driver Sunil showed us the best local seafood spots in Galle.', 'assets/img/testimonial/testi_1_2.jpg', '1', '2026-11-12', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `services`
DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `short_desc` text DEFAULT NULL,
  `full_desc` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `services` (`id`, `slug`, `title`, `icon`, `short_desc`, `full_desc`, `image`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
('1', 'tailor-made-holiday-packages', 'Tailor-Made Holiday Packages', 'fa-solid fa-route', 'Complete multi-day holiday round tours designed to match your individual preferences, pace, and interests.', 'Whether you dream of scaling ancient UNESCO rock citadels, hiking misty tea country mountains, embarking on thrilling wildlife safaris, or lounging on golden tropical beaches, we design every day to perfection.', 'assets/img/service/service_1.jpg', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'airport-transfers-chauffeur', 'Airport Transfers & Chauffeur Hire', 'fa-solid fa-car-rear', '24/7 seamless airport pick-up & drop-off from Bandaranaike International Airport (CMB) with private air-conditioned vehicles.', 'Enjoy effortless, punctual private transit directly from the arrivals terminal to any resort or hotel across Sri Lanka, backed by licensed, courteous chauffeur drivers.', 'assets/img/service/service_2.jpg', '1', '2', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'cultural-heritage-tours', 'Cultural & Heritage Tours', 'fa-solid fa-landmark-dome', 'Step back millennia across Sri Lanka\'s UNESCO Cultural Triangle — Anuradhapura, Polonnaruwa, Sigiriya, and Kandy.', 'Explore the sacred Temple of the Sacred Tooth Relic, majestic monolithic stupas, royal water gardens, and intricate ancient cave mural temples accompanied by knowledgeable historian guides.', 'assets/img/service/service_3.jpg', '1', '3', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'wildlife-safari-expeditions', 'Wildlife & Safari Expeditions', 'fa-solid fa-binoculars', 'Thrilling 4x4 open-top jeep safaris tracking leopards, wild Asian elephants, and sloth bears across top national parks.', 'Experience the world-renowned wildlife reserves of Yala, Udawalawe, Minneriya, and Wilpattu with licensed safari trackers and top-tier safari vehicles.', 'assets/img/service/service_4.jpg', '1', '4', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', 'scenic-train-ticket-booking', 'Scenic Train Ticket Bookings', 'fa-solid fa-train', 'Reserved observation & 1st class train seats along the world-famous Kandy to Nuwara Eliya and Ella route.', 'Avoid the stress of sold-out tickets. We pre-book guaranteed reserved seats on the blue mountain train crossing the iconic Nine Arch Bridge and verdant highland tea plantations.', 'assets/img/service/service_5.jpg', '1', '5', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', 'hotel-resort-reservations', 'Hotel & Luxury Resort Reservations', 'fa-solid fa-hotel', 'Handpicked boutique villas, heritage colonial tea bungalows, beach resorts, and luxury 5-star accommodations.', 'Leverage our exclusive agency partnerships to enjoy preferred room rates, free breakfast upgrades, and authentic Sri Lankan hospitality wherever you rest.', 'assets/img/service/service_6.jpg', '1', '6', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `sessions`
DROP TABLE IF EXISTS `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,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('dhsr7IGLMl4zPnOEvs31ZwEByFXSIHG9x0IC0FsD', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/157.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiI3cERXbktGWFprME9UVWlobzFvQ3paOFhnTTgyOU1VRno5aUpzRUpqIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1794832517');

-- Table structure for table `settings`
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `value` text DEFAULT NULL,
  `group_name` varchar(50) NOT NULL DEFAULT 'general',
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`id`, `key`, `value`, `group_name`, `description`, `created_at`, `updated_at`) VALUES
('1', 'company_name', 'Smart Job Travels', 'general', 'Company name', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'company_tagline', 'Your Trusted Inbound Sri Lanka Tour Specialist', 'general', 'Company tagline', '2026-11-16 17:52:16', '2026-11-16 18:04:41'),
('3', 'phone', '+94 78 254 4477', 'general', 'Phone', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'whatsapp', '+94 78 254 4477', 'general', 'Whatsapp', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', 'email', 'info@smartjobtour.lk', 'general', 'Email', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', 'email_booking', 'bookings@smartjobtour.lk', 'general', 'Email booking', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('7', 'address', 'No. 127-1/1, Mihindu Mawatha, Colombo 12, Sri Lanka', 'general', 'Address', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('8', 'working_hours', 'Mon - Sat: 8:30 AM - 6:30 PM | 24/7 Dedicated Tour Support', 'general', 'Working hours', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('9', 'facebook', 'https://facebook.com/', 'social', 'Facebook', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('10', 'instagram', 'https://instagram.com/', 'social', 'Instagram', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('11', 'twitter', 'https://twitter.com/', 'social', 'Twitter', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('12', 'linkedin', 'https://linkedin.com/', 'social', 'Linkedin', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('13', 'currency', 'LKR', 'general', 'Default Display Currency', '2026-11-16 17:52:16', '2026-11-16 18:23:13'),
('14', 'emergency_phone', '+94 78 254 4477', 'contact', '24/7 Emergency Support Hotline', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('15', 'meta_description', 'Smart Job Travels - Premier Sri Lanka Tour Operator providing tailor-made round tours, airport transfers, luxury chauffeur hire, and authentic holiday packages.', 'seo', 'Site Meta Description', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `site_contents`
DROP TABLE IF EXISTS `site_contents`;
CREATE TABLE `site_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `section_key` varchar(100) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content_json` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `section_key` (`section_key`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `site_contents` (`id`, `section_key`, `title`, `content_json`, `created_at`, `updated_at`) VALUES
('1', 'hero_slides', 'Homepage Hero Slides', '[{\"id\":\"hero-1\",\"badge\":\"Tropical Southern Paradise • Mirissa Beach\",\"title\":\"Golden Sands, Coconut Tree Hill & Blue Whale Watching in Mirissa\",\"text\":\"Bask in the tropical warmth of Mirissa\'s world-famous beaches, climb the iconic Coconut Tree Hill at sunset, and embark on unforgettable blue whale watching voyages.\",\"btn_text\":\"Explore Beach Tours\",\"btn_link\":\"#packages-sec\",\"img\":\"assets\\/img\\/hero\\/hero_bg_1_1.jpg\"},{\"id\":\"hero-2\",\"badge\":\"Majestic Hill Country & Tea Trails\",\"title\":\"Misty Mountain Ranges, Nuwara Eliya & Rolling Ceylon Tea Valleys\",\"text\":\"Journey through emerald tea plantations, cross the legendary Nine Arch Bridge in Ella, witness roaring waterfalls, and relax in the cool mountain breeze of Little England.\",\"btn_text\":\"View Hill Country Tours\",\"btn_link\":\"#packages-sec\",\"img\":\"assets\\/img\\/hero\\/hero_bg_1_2.jpg\"},{\"id\":\"hero-3\",\"badge\":\"Wild Safari Expeditions • Yala National Park\",\"title\":\"Thrilling Wildlife Safaris, Wild Elephants & Elusive Sri Lankan Leopards\",\"text\":\"Venture deep into Yala National Park on an exhilarating 4x4 open-jeep safari to track majestic leopards, sloth bears, wild elephants, and exotic tropical birds.\",\"btn_text\":\"Book Yala Safari\",\"btn_link\":\"#packages-sec\",\"img\":\"assets\\/img\\/hero\\/hero_bg_1_3.jpg\"}]', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'home_intro', 'Homepage Introduction', '{\"badge\":\"Introduction to Tourism Services\",\"title\":\"Discover The Magic of Sri Lanka With Expert Travel Curators\",\"text\":\"Smart Job Travels is your premier Sri Lankan travel agency, dedicated to creating immersive, safe, and unforgettable journeys across the Pearl of the Indian Ocean.\",\"feature1_title\":\"Exclusive Sri Lanka Tours\",\"feature1_desc\":\"Cultural Triangle heritage, iconic blue train rides, wildlife safaris, and pristine southern beaches.\",\"feature2_title\":\"Certified Tourist Drivers & Guides\",\"feature2_desc\":\"Government-licensed, English-speaking chauffeurs with modern air-conditioned vehicle fleet and 24\\/7 support.\",\"img1\":\"assets\\/img\\/normal\\/about_1_1.jpg\",\"img2\":\"assets\\/img\\/normal\\/about_1_2.jpg\",\"img3\":\"assets\\/img\\/normal\\/about_1_3.jpg\"}', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'special_offer', 'Special Promotional Offer', '{\"badge\":\"SRI LANKA HOLIDAY PROMOTION\",\"title\":\"Special Season Offers — Save Up to 25% on Family & Group Tours Across Sri Lanka!\",\"desc\":\"Plan your paradise island vacation with Smart Job Travels. Enjoy free airport pickup & drop-off from Bandaranaike International Airport (CMB), complimentary tea factory visits, and luxury vehicle upgrades.\",\"box1_title\":\"25% OFF\",\"box1_desc\":\"Group Bookings (3+ Pax)\",\"box2_title\":\"FREE\",\"box2_desc\":\"CMB Airport Transfers\",\"box3_title\":\"FREE\",\"box3_desc\":\"Sigiriya Guided Tour\",\"promo_code\":\"CEYLON2026\"}', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'about_content', 'About Us Page Content', '{\"story\":{\"subtitle\":\"Welcome To Smart Job Travels\",\"title\":\"Your Trusted Inbound Sri Lanka Tour Specialist\",\"p1\":\"Based in Colombo, Smart Job Travels is a premier Sri Lankan tour operator dedicated to crafting authentic, seamless, and deeply memorable island holidays. Whether you seek ancient UNESCO world heritage wonders, misty hill country tea estates, exhilarating wildlife safaris, or sun-drenched tropical coastlines, we turn your Sri Lankan dream into reality.\",\"p2\":\"Every journey is curated by our passionate local destination specialists and accompanied by government-licensed, English-speaking private chauffeur guides, ensuring total safety, flexibility, and personalized comfort at every turn.\",\"feature1_title\":\"Tailor-Made Itineraries\",\"feature1_desc\":\"Fully customized private tours designed around your travel pace, budget, and personal passions.\",\"feature2_title\":\"Certified Chauffeur Guides\",\"feature2_desc\":\"Licensed, courteous driver-guides with years of route expertise and modern, air-conditioned vehicles.\",\"feature3_title\":\"24\\/7 Island-Wide Assistance\",\"feature3_desc\":\"Round-the-clock ground coordination from airport pickup until departure, with zero hidden charges.\",\"img1\":\"assets\\/img\\/normal\\/about_3_1.jpg\",\"img2\":\"assets\\/img\\/normal\\/about_3_2.jpg\",\"img3\":\"assets\\/img\\/normal\\/about_3_3.jpg\"},\"vision_mission\":{\"vision\":\"To be recognized globally as Sri Lanka\'s most trusted, innovative, and sustainable inbound tour operator, connecting worldwide travelers to the authentic heritage, nature, and heartwarming hospitality of our paradise island.\",\"mission\":\"To deliver handcrafted, safe, and transparent travel experiences tailored to every guest\'s individual desires, while championing sustainable community tourism, environmental conservation, and the highest standards of private chauffeur service.\",\"commitment_items\":[\"100% Licensed Chauffeurs & Guides\",\"Modern, air-conditioned vehicle fleet\",\"Transparent pricing with zero hidden fees\",\"24\\/7 dedicated on-road guest support\"]},\"counters\":{\"stat1_number\":\"12\",\"stat1_label\":\"Years Experience\",\"stat2_number\":\"5000\",\"stat2_label\":\"Happy Travelers\",\"stat3_number\":\"150\",\"stat3_label\":\"Handcrafted Tours\",\"stat4_number\":\"100\",\"stat4_label\":\"Satisfaction & Safety\"}}', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `tour_packages`
DROP TABLE IF EXISTS `tour_packages`;
CREATE TABLE `tour_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `badge` varchar(100) DEFAULT NULL,
  `duration` varchar(100) NOT NULL,
  `duration_days` int(11) NOT NULL DEFAULT 1,
  `duration_nights` int(11) NOT NULL DEFAULT 0,
  `price` decimal(10,2) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `destinations_route` varchar(500) DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tour_packages` (`id`, `slug`, `title`, `badge`, `duration`, `duration_days`, `duration_nights`, `price`, `image`, `destinations_route`, `summary`, `is_featured`, `is_active`, `created_at`, `updated_at`) VALUES
('1', 'classic-7-days', '7-Day Classic Sri Lanka Discovery', 'Best Seller', '7 Days / 6 Nights', '7', '6', '490.00', 'assets/img/tour/tour_box_1.jpg', 'Colombo - Sigiriya - Kandy - Nuwara Eliya - Ella - Galle', 'The quintessential Sri Lankan round tour featuring UNESCO world heritage fortresses, sacred Buddhist temples, scenic mountain train journeys, emerald tea valleys, and colonial ocean ramparts.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'heritage-wildlife-10-days', '10-Day Heritage, Wildlife & Southern Beach Odyssey', 'Top Rated', '10 Days / 9 Nights', '10', '9', '720.00', 'assets/img/tour/tour_box_2.jpg', 'Sigiriya - Polonnaruwa - Kandy - Nuwara Eliya - Ella - Yala - Mirissa - Galle', 'An all-encompassing private island voyage combining ancient royal citadels, high-altitude tea trails, exhilarating 4x4 leopard safaris in Yala, and sun-kissed beaches in Mirissa.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'hill-country-5-days', '5-Day Scenic Hill Country & Ceylon Tea Trails', 'Scenic Special', '5 Days / 4 Nights', '5', '4', '380.00', 'assets/img/tour/tour_box_3.jpg', 'Kandy - Nuwara Eliya - Horton Plains - Ella', 'Experience the cool mountain breezes, cascading waterfalls, world-famous Ceylon tea estates, and dramatic precipices of Sri Lanka\'s Central Highlands.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'southern-beach-4-days', '4-Day Southern Coast & Whale Watching Escapade', 'Beach & Ocean', '4 Days / 3 Nights', '4', '3', '310.00', 'assets/img/tour/tour_box_4.jpg', 'Bentota - Galle Fort - Mirissa - Weligama', 'Sun, surf, blue whales, and colonial charm. A rejuvenating coastal escape along Sri Lanka\'s turquoise Indian Ocean shores.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('5', 'cultural-triangle-3-days', '3-Day Cultural Triangle & Sigiriya Wonder', 'Quick Tour', '3 Days / 2 Nights', '3', '2', '250.00', 'assets/img/tour/tour_box_5.jpg', 'Sigiriya - Dambulla - Minneriya', 'The perfect short getaway exploring Sri Lanka\'s greatest ancient architectural feats and elephant wilderness in just 3 days.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('6', 'grand-island-14-days', '14-Day Grand Island Odyssey (Comprehensive)', 'Ultimate Tour', '14 Days / 13 Nights', '14', '13', '980.00', 'assets/img/tour/tour_box_6.jpg', 'Anuradhapura - Jaffna - Trincomalee - Sigiriya - Kandy - Nuwara Eliya - Ella - Yala - Galle', 'The ultimate expedition uncovering the complete tapestry of Sri Lanka: from the historic Tamil north in Jaffna to Pigeon Island coral reefs, central mountains, wildlife parks, and southern shores.', '1', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `users`
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','manager','agent') NOT NULL DEFAULT 'agent',
  `phone` varchar(50) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone`, `remember_token`, `created_at`, `updated_at`) VALUES
('1', 'Administrator', 'admin@smartjobtours.lk', '2026-11-16 17:52:16', '$2y$12$QdBX9q0CCrHXqgGRGhbDEOq9rIQjuZWd.fhPnZ6uV3qdgxiqz2gXq', 'admin', '+94 78 254 4477', NULL, '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'Nisal Fernando (Operations Manager)', 'manager@smartjobtours.lk', '2026-11-16 17:52:16', '$2y$12$QdBX9q0CCrHXqgGRGhbDEOq9rIQjuZWd.fhPnZ6uV3qdgxiqz2gXq', 'manager', '+94 77 123 4567', NULL, '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'Kavindi Jayawardena (Tour Consultant)', 'consultant@smartjobtours.lk', '2026-11-16 17:52:16', '$2y$12$QdBX9q0CCrHXqgGRGhbDEOq9rIQjuZWd.fhPnZ6uV3qdgxiqz2gXq', 'agent', '+94 71 987 6543', NULL, '2026-11-16 17:52:16', '2026-11-16 17:52:16');

-- Table structure for table `vehicles`
DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE `vehicles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(100) NOT NULL,
  `passenger_capacity` int(11) NOT NULL,
  `luggage_capacity` int(11) NOT NULL,
  `daily_rate_usd` decimal(8,2) DEFAULT NULL,
  `airport_transfer_usd` decimal(8,2) DEFAULT NULL,
  `features` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `vehicles` (`id`, `code`, `name`, `category`, `passenger_capacity`, `luggage_capacity`, `daily_rate_usd`, `airport_transfer_usd`, `features`, `description`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
('1', 'sedan-comfort', 'Comfort Sedan (Toyota Prius / Axio / Premio)', 'Sedan', '3', '2', '55.00', '35.00', '[\"Full Air Conditioning\",\"English-Speaking Driver\",\"Complimentary Bottled Water\",\"Highway Tolls Included\",\"Fuel & Parking Included\"]', 'Ideal for couples, solo travelers, and business executives. Smooth, fuel-efficient, and comfortable for cross-country highway travel.', 'assets/img/fleet/sedan.jpg', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('2', 'kdh-luxury-van', 'Luxury KDH High-Roof Van (Toyota HiAce Super GL)', 'Van', '8', '6', '80.00', '55.00', '[\"Dual Zone Air Conditioning\",\"Luxury Reclining Seats\",\"High Ceiling & Large Windows\",\"WiFi on Board (On Request)\",\"Experienced Chauffeur Guide\"]', 'Our most popular vehicle for families and small groups. Extremely spacious interior with panoramic sightseeing views.', 'assets/img/fleet/kdh_van.jpg', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('3', 'prado-suv-4wd', 'Premium 4WD SUV (Toyota Land Cruiser Prado)', 'SUV', '4', '4', '125.00', '85.00', '[\"4x4 All-Terrain Capability\",\"Leather Heated\\/Cooled Seats\",\"Panoramic Sunroof\",\"VIP Chauffeur Service\",\"Complimentary Refreshments\"]', 'Ultimate luxury and rugged reliability. Engineered for rough safari terrain, mountainous hill country climbs, and VIP executive travel.', 'assets/img/fleet/prado_suv.jpg', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16'),
('4', 'coaster-mini-coach', 'Tourist Mini Coach (Toyota Coaster / Rosa)', 'Mini Coach', '20', '15', '150.00', '110.00', '[\"Individual Air Ducts\",\"Microphone PA System for Tour Guide\",\"Spacious Luggage Bay\",\"Reclining High-Back Seats\",\"Professional Driver & Assistant\"]', 'Tailored for large tour groups, corporate outings, wedding delegations, and extended island round tours.', 'assets/img/fleet/mini_coach.jpg', '1', '2026-11-16 17:52:16', '2026-11-16 17:52:16');

SET FOREIGN_KEY_CHECKS = 1;
COMMIT;
