
SET FOREIGN_KEY_CHECKS = 0;
DELETE FROM package_gallery;
DELETE FROM bookings;
DELETE FROM packages;
DELETE FROM destinations;
DELETE FROM sliders;
SET FOREIGN_KEY_CHECKS = 1;

-- Insert Destinations
INSERT INTO `destinations` (`id`, `name`, `image`) VALUES
(1, 'India', 'india_tour.png'), 
(2, 'Thailand', 'thailand_tour.png'), 
(3, 'Malaysia', 'malaysia_tour.png'), 
(4, 'Singapore', 'singapore_tour.png'), 
(5, 'Dubai', 'dubai_tour.png'), 
(6, 'China', 'china_tour.png'), 
(7, 'Egypt', 'egypt_tour.png'), 
(8, 'Vietnam', 'vietnam_tour.png'), 
(9, 'Cambodia', 'cambodia_tour.png'), 
(10, 'Azerbaijan', 'azerbaijan_tour.png'), 
(11, 'Japan', 'india_tour.png'), 
(12, 'Bali', 'thailand_tour.png'), 
(13, 'Maldives', 'maldives_tour.png'), 
(14, 'Kerala', 'india_tour.png'), 
(15, 'Abu Dhabi', 'dubai_tour.png'), 
(16, 'Turkey', 'azerbaijan_tour.png'), 
(17, 'Europe', 'china_tour.png'), 
(18, 'Laos', 'vietnam_tour.png'), 
(19, 'Myanmar', 'myanmar_tour.png');

-- Insert Hero Sliders
INSERT INTO `sliders` (`title`, `subtitle`, `image`) VALUES
('Discover the Maldives', 'Luxury overwater bungalows and turquoise waters', 'hero1.png'),
('Majestic Taj Mahal', 'Experience the timeless beauty of India', 'hero2.png'),
('Modern Dubai', 'Futuristic architecture and vibrant city lights', 'hero3.png');

-- Insert Group Tours (Packages)
INSERT INTO `packages` (`title`, `country_id`, `tour_name`, `duration`, `travel_period`, `landmarks`, `includes`, `price`, `main_image`) VALUES
('14DAYS PILGRIMAGE TOUR', 1, 'Pilgrimage tour through holy sites', '14 Days/ 13 Nights', 'Seasonal', 'Sanchi, Kosambi, Varanasi, Bodhgaya, Rajgir, Vaishali, Kushinagar, Lumbini (Nepal), Kapilawastu, Sravasti, Sankassa, Agra, Delhi', 'Return Air Ticket, Indian & Nepal Visa, Entrance Tickets, Meals, Accommodation, All Transfers, Water, Traveling Bags, Hat, Umbrella, Accompany by Local Tour Leader', 0, 'india_pilgrimage.png'),
('18DAYS PILGRIMAGE TOUR', 1, 'Extended pilgrimage tour', '18 Days/ 17 Nights', 'Seasonal', 'Sanchi, Kosambi, Varanasi, Bodhgaya, Rajgir, Vaishali, Kushinagar, Lumbini (Nepal), Kapilawastu, Sravasti, Sankassa, Agra, Delhi', 'Return Air Ticket, Indian & Nepal Visa, Train Tickets, Entrance Tickets, Meals, Accommodation, Water, Traveling Bags, Hat, Umbrella, Accompany by Local Tour Leader', 0, 'india_pilgrimage.png'),
('25 DAYS PILGRIMAGE TOUR', 1, 'Complete pilgrimage experience', '25 Days/ 24 Nights', 'Seasonal', 'Tirupati, Ajantha, Ellora, Sanchi, Agra, New Delhi, Sankassa, Sravasti, Lumbini, Kushinagar, Kapilawastu, Vaishali, Bodhgaya, Rajgir, Varanasi, Kosambi, Nagpur, Nagarjun Konda, Amarawathi', 'Return Air Ticket, Indian & Nepal Visa, Entrance Tickets, Meals, Accommodation, Water, Traveling Bags, Hat, Umbrella, Accompany by Local Tour Leader', 0, 'india_pilgrimage.png'),
('SHIMLA & MANALI TOUR', 1, 'Scenic mountain tour', '07 Days/ 06 Nights', 'Seasonal', 'Delhi, Shimla, Hanuman Temple, Kufri, Kullu, Chandigar, Rothang Pass, Sissu Snow Point', 'Return Air Ticket, Indian Visa, Entrance Ticket, Meals, 4*/3*Accommodation, Accompany by Local Tour Leader', 0, 'india_tour.png'),
('CHENNAI & THIRUPATHI TOUR', 1, 'Cultural and spiritual tour', '04 Days/ 03 Nights', 'Seasonal', 'Tirupati Kovil, Chennai Museum, Mylapore Kovil, Parthasarathy Temple, Marina Beach, T Nagar, Mannadi and Purasawalkam Shopping', 'Return Air Ticket, Indian Visa, Meals, 4*/3*Accommodation, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'india_temple.png'),
('SOUTH INDIAN TOUR', 1, 'South Indian exploration', '07 Days/ 06 Nights', 'Seasonal', 'Chennai, Tirupati Kovil, Bangalore, Mysore Palace & Brindavan Garden, Mysore Zoo & Nandi Hill, Ooty', 'Indian Visa, Return Air Ticket, 6 Nights’ A/C Accommodation on Double/Triple shared rooms, Meals, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'south_india.png'),
('BANGKOK TOUR', 2, 'City and temple exploration', '06 Days/ 05 Nights', 'Seasonal', 'Bangkok City Tour with Three Temples, Safari World, Ayuttaya, Dhammakaya, Dinner Cruise, Dream World or Floating Market, Puttamanthon, Shopping', 'Return Air Ticket, 05 Nights’ Accommodation on Double/Triple shared rooms, Meals, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'thailand_tour.png'),
('BANGKOK & PATTAYA TOUR', 2, 'City and beach experience', '07 Days/ 06 Nights', 'Seasonal', 'Pattaua Coral Island, Pattaya View Point, Big Buddha, Dinner Cruise, city tour Including Golden Buddha, Marble Temple, Wat Inda temples, Safari World, Ayuttaya, Dhammakaya, Floating Market, Puttamanthon, Nakkon Patton', 'Return Air Ticket, 6 Nights’ Accommodation at 3* Hotel based on Twin/ Double shared rooms, Meals, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'thailand_tour.png'),
('BANGKOK & PHUKET TOUR', 2, 'Bangkok and Island tour', '6 Days/ 05 Nights', 'Seasonal', 'Phi Phi Island, Tiger Park, Big Buddha Phuket, Wat Chalong Temple, Old Phuket, Dinner Cruise, city tour Including Golden Buddha, Marble Temple, Wat Inda temples, Safari World, Ayuttaya, Dhammakaya, Floating Market, Puttamanthon, Nakkon Patton', 'Return Air Ticket, 5 Nights’ Accommodation at 3* Hotel based on Twin/ Double shared rooms, Meals, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'thailand_tour.png'),
('MALAYSIA TOUR', 3, 'Malaysia highlights', '05 Days/ 04 Nights', 'Seasonal', 'City Tour, Batu Caves, Genting Highland, Sunway Lagoon, Shopping', 'Return Air Ticket, Tourist Visa, 3Nights’ Accommodation at 3* Hotel Based on Twin/ Double shared rooms, Meals, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'malaysia_tour.png'),
('SINGAPORE TOUR', 4, 'Singapore city tour', '04 Days/ 03 Nights', 'Seasonal', 'Singapore City Tour, Universal Studio, Sentosa Island, Garden by The Bay (Cloud Forest, Jurassic World, Flower Dome), Cable Car Ride, Madam Tussauds', 'Tourist Visa, Return Air Ticket, 4 Nights’ Accommodation at 3* Hotel Based on Twin/ Double shared rooms with Breakfast, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'singapore_tour.png'),
('SINGAPORE & MALAYSIA TOUR', 4, 'Dual country tour', '07 Days/ 06 Nights', 'Seasonal', 'Garden by the Bay, Sentosa Island, Singapore City Tour, Malaysia City Tour, Batu Caves, Genting Highland, Sunway Lagoon', 'Tourist Visa, Return Air Ticket, Airport Transfer, 6 Nights’ Accommodation at 3* Hotel based on Twin/Double/Triple shared room, Breakfast & Dinner, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'singapore_malaysia.png'),
('GENTING DREAM CRUISE TOUR', 4, 'Singapore to Phuket Cruise', '05 Days/ 04 Nights', 'Seasonal', 'Enjoying a world of onboard excitement while cruising the vibrant seas from Singapore to Phuket', '3 nights Cruise Cabin with Balcony, 1 Night 3* hotel with Breakfast, Airport Transfers, All Meals in the Cruise', 0, 'cruise_tour.png'),
('CAMBODIA TOUR', 9, 'Cambodia historical tour', '07 Days/ 06 Nights', 'Seasonal', 'Phnom Penh’s Past & Present, Siem Reap, Floating Village by Road, Angkor Thom, Angkor wat Temple, National Park of Kullen Mountain ‘1000 Lingas’', 'E Visa, Return Air Ticket on Economy Class, Airport Transport, 6 Nights’ Accommodation at 4* Hotel Based on Twin/ Double shared room, Meals', 0, 'cambodia_tour.png'),
('MYANMAR TOUR', 19, 'Myanmar cultural tour', '10 Days/ 09 Nights', 'Seasonal', 'Yangon, Bago, Kyaikthiyoe, Mandalay, Bagan, Pindaya, Inle lake', 'Tourist Visa, International Air Ticket, Airport Transfer, 3/4* Hotel Accommodation based on Twin/ Double & Triple shared rooms, Privet Transfer with experience drivers, English speaking local Tour Guide, Breakfast, Lunch & Dinner, Entry & zone fees as per itinerary', 0, 'myanmar_tour.png'),
('VIETNAM TOUR 01', 8, 'Vietnam North & Central', '07 Days/ 06 Nights', 'Seasonal', 'Monkey Mountain, The Giant Lady Buddha Statue, Ba Na Hills, Golden Bridge, Cam Thanh Coconut, Mable Mountain, Water Mountain, Hoi An Ancient town, Ho Chi Minh Mausoleum, Ba Dinh Square/ Ngoc Son Temple, Hoan Kiem Lake, Ha Long Bay Cruise, Green Car Tour around Hanoi Old Quarter', 'Vietnam E visa, International Return Air Ticket, Domestic Air Ticket, Airport Transfer, 6 Nights’ Accommodation at 4 * Hotel based on Double/Triple shared rooms, Private transfer with experienced drivers, English Speaking Tour guides, Accompany by Local Tour Leader, All sightseeing fees as program, Overnight cruising package 2D 1N in Ha Long Bay', 0, 'vietnam_tour.png'),
('VIETNAM TOUR 02', 8, 'Vietnam South & North', '07 Days/ 06 Nights', 'Seasonal', 'Ho Chi Minh City Tour, Reunification Palace, Notre Dame Cathedral, General Post Office, Ben Thanh market, Mekong Delta, Cu Chi Tunnels, Ho Chi Minh Mausoleum, Ba Dinh Square/ Ngoc Son Temple, Hoan Kiem Lake, Ha Long Bay Cruise, Green Car Tour around Hanoi Old Quarter', 'International Air Ticket, Domestic Air Ticket, Airport Transfer, 4* Hotel accommodation based on Twin/ Double/ Triple shared rooms, Private transfer with experienced drivers, English speaking local tour guides, Meals without drinks as indicated: B = Breakfast; L = Lunch; D = Dinner, All sightseeing fees as program', 0, 'vietnam_tour.png'),
('EGYPT TOUR', 7, 'Egypt historical tour', '10 Days/ 09 Nights', 'Seasonal', 'Saqqara, Great Pyramid Giza, The Great Sphinx, The Valley Temple of Mummification, Hanging Church, National Museum of Egyptian Civilization, High Dam, Philae temple, Abu Simbel Temple, Kom Ombo, Edfu Temple, Valley of the Kings, Egypt museum, Khan El-Khalil Market, Pompeii pillar', 'Egypt Visa, Return Air Ticket, Domestic Air Ticket, Airport Transport, 6 Nights’ Accommodation at 4* Hotel based on Double/Triple shared rooms. And 3 Nights’ Accommodation at 5* Cruise, Breakfast, Lunch & Dinner, Private transfer with experienced drivers, English Speaking Tour guides, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'egypt_tour.png'),
('AZERBAIJAN TOUR', 10, 'Azerbaijan adventure', '07 Days/ 06 Nights', 'Seasonal', 'Flame Tower, Highland Park, Alley of Mystery, Mini Venice, Azerbaijan National Carpet Museum, Old City Baku, Tufandang Complex, Nohur Lake, Yeddi Gozel Waterfall, Gabala Shooting Club, shaki Tour, shahdag, guba tour, Absheron & Gobustan Tour', 'Azerbaijan E Visa, Return Air Ticket, Airport Transfer, 5 Nights’ Accommodation at Baku & 1 Nights’ Accommodation at Gabala, Breakfast & Dinner, Privet Transfer, English Speaking Tour Guide, Accompanying by Methsisila Tour Guide, All sightseeing fee as program', 0, 'azerbaijan_tour.png'),
('CHINA TOUR', 6, 'China discovery', '07 Days/ 08 Nights', 'Seasonal', 'Shilinxia Glass Bridge, Acrobatic Show, Wangfujing street, Great Wall, Bird\'s Nest\' and Water Cube, Summer palace, Panda Zoo, Forbidden City, bullet train to Shanghai, Disneyland, Yu Garden, Yu Bazaar, Jade Buddha Temple, Oriental TV Tower (2nd Sphere), The Bund, Experience a scenic cruise on Shanghai\'s Huangpu River', 'Tourist Visa, Return Air Ticket, Bullet Train Ticket, Airport Transport, 6  Nights’  Accommodation  at  4  *  Hotel based on Double/Triple shared rooms, Breakfast, Lunch & Dinner, Private transfer with experienced drivers, English Speaking Tour guides, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'china_tour.png'),
('DUBAI TOUR', 5, 'Dubai luxury tour', '05 Days/ 04 Days', 'Seasonal', 'VIP Desert Safari, Miracle Garden, Global Village, Marina Cruise, Dubai City Tour, Water Fountain show, Dubai City tour, Burj Kalifa', 'Tourist Visa, Return Air Ticket, Airport Transport, 4 Nights’  Accommodation  at  3  *  Hotel based on Double/Triple shared rooms, Private transfer with experienced drivers, Breakfast, Dinner, Private transfer with experienced drivers, English Speaking Tour guides, Accompany by Local Tour Leader, All sightseeing fees as program', 0, 'dubai_tour.png'),
('MALDIVES TOUR', 13, 'Maldives island hopping', '05 Days/ 04 Nights', 'Seasonal', 'Submarine Ride, Male City Tour, Victory Monument, Republic square, Muliaage, male Friday Mosque, King Salman Mosque, Tsunami Monument, National Museum Maldives Islamic Center, Villingili Island, Mandhii Island, Hulumale', 'Return Air Ticket, Submarine Tour, 4 Nights’  Accommodation  at  3  *  Hotel based on Double/Triple shared rooms, Breakfast, Lunch, Dinner, English Speaking Tour guides, Private transfer with experienced drivers, All sightseeing fees as program', 0, 'maldives_tour.png');
-- Insert Testimonials
INSERT INTO `testimonials` (`client_name`, `message`, `rating`) VALUES
('John Doe', 'Methsisila Tours made our trip to India unforgettable. Everything was perfectly planned and executed.', 5),
('Sarah Smith', 'The pilgrimage tour was a life-changing experience. Highly recommend their professional service.', 5),
('David Wilson', 'Professional, friendly, and very well organized. Looking forward to our next trip with them!', 4);
