-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 04, 2026 at 02:29 PM
-- Server version: 11.4.12-MariaDB
-- PHP Version: 8.4.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `websparkit_webspark_methsisila2`
--

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

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

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`) VALUES
(1, 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');

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

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

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `destination` varchar(100) NOT NULL,
  `travel_date` date NOT NULL,
  `persons` int(11) NOT NULL,
  `package_id` int(11) DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `bookings` (`id`, `customer_name`, `phone_number`, `destination`, `travel_date`, `persons`, `package_id`, `status`, `created_at`) VALUES
(1, 'lanka', '0777291189', 'CHINA GROUP TOUR', '2026-07-22', 1, 42, 'Pending', '2026-05-18 17:05:09'),
(2, 'lanka', '0777291189', 'CHINA GROUP TOUR', '2026-08-22', 1, NULL, 'Pending', '2026-05-19 11:41:13');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `subject`, `message`, `created_at`) VALUES
(1, 'Rebekah Julius', 'domains@search-methsisilatours.com', 'methsisilatours.com results', 'Hey\r\n\r\nFeature methsisilatours.com in GoogleSearchIndex so it can be displayed in online search results!\r\n\r\nRegister methsisilatours.com now: https://searchregister.net\r\n\r\n', '2026-05-12 16:39:29'),
(2, 'Buddy Tweddle', 'domains@search-methsisilatours.com', 'methsisilatours.com results', 'Greetings\r\n\r\nInsert methsisilatours.com in GoogleSearchIndex so it can show up in google search results!\r\n\r\nAdd methsisilatours.com now: https://searchregister.org\r\n\r\n', '2026-05-13 17:08:53'),
(3, 'Danish | Growth Specialist', 'leads.scrapper@gmail.com', 'Issue found regarding your business\'s lead flow', 'Hi,\n\nI was just looking at your site\'s performance and noticed a few gaps where you\'re likely losing leads compared to your competitors.\n\nI specialize in scaling companies to **200â€“1200+ qualified leads/month** using SEO and data-backed Ads. I\'ve prepared a brief video audit showing exactly where your revenue is leaking.\n\n**See our results here:** https://t.me/websiteseoandads\n\nDirect contact:\nWhatsApp: +19137357607\nTelegram: @websiteseoandads\n\nBest,\nDanish | Growth Specialist', '2026-05-14 16:59:45'),
(4, 'Bernadine Soul', 'domains@search-methsisilatours.com', 'methsisilatours.com results', 'Dear Sir/Madam\r\n\r\nSubmit methsisilatours.com in GoogleSearchIndex to be displayed in web search results!\r\n\r\nPlace methsisilatours.com now: https://searchregister.live\r\n\r\n', '2026-05-14 17:22:40'),
(5, 'Danish | Growth Specialist', 'leads.scrapper@gmail.com', 'Issue found regarding your website\'s lead flow', 'Hi,\n\nI was just looking at your website and noticed a few missed opportunities where you\'re likely paying too much for traffic compared to your competitors.\n\nI specialize in scaling companies to **200â€“1200+ qualified leads/month** using SEO and data-backed Ads. I\'ve prepared a brief video audit showing exactly where your traffic is leaking.\n\n**See our results here:** https://t.me/websiteseoandads\n\nDirect contact:\nWhatsApp: +19137357607\nTelegram: @websiteseoandads\n\nBest,\nDanish | Growth Specialist', '2026-05-18 02:00:11'),
(6, 'lanka', 'methsisilatours@gmail.com', 'china', 'need details', '2026-05-18 16:26:40'),
(7, 'Zenaida Draper', 'domains@search-methsisilatours.com', 'methsisilatours.com results', 'Hey\r\n\r\nRegister methsisilatours.com in GoogleSearchIndex to be displayed in online search results!\r\n\r\nList methsisilatours.com now: https://searchregister.org\r\n\r\n', '2026-05-24 16:42:24'),
(8, 'myiddfkqzv', 'egtuhokn@immenseignite.info', 'tmdxfsnhny', 'svisnqmlzmqgkegflmhyvmynhfgzsx', '2026-05-25 21:07:18'),
(9, 'pxfrfihhii', 'psjnszvm@immenseignite.info', 'tdhdrqqtdm', 'jwirfeuqiyqkigefleklkhyhfvnjxi', '2026-05-25 21:07:18'),
(10, 'mdwmymesxf', 'ndsfpzhd@immenseignite.info', 'muziuehhht', 'voeokmnzfeleggehmnwlieyoghsykx', '2026-05-25 21:07:18'),
(11, 'ilxnrijjjs', 'lrtwnsnq@immenseignite.info', 'hnixzetqpx', 'pzhrlmemtzqrxzpvjxhhshikdruxmz', '2026-05-25 21:07:35'),
(12, 'fkjjlwvlul', 'qevojrqx@immenseignite.info', 'fdoipyrmmw', 'nujuszwtxfqutyqolqgtjvrsklhkzo', '2026-05-25 21:08:03'),
(13, 'uekyduordv', 'ltnhnmui@ immenseignite.info', 'soltzmlnsr', 'kopgttnuxexxjhikjnemmdzuxjejip', '2026-05-25 21:09:14'),
(14, 'Ashwani Sharma', 'ashwani@rocketdigitaltech.com', 'Get Your Website on Googleâ€™s First Page', 'Hello http://methsisilatours.com,\r\n \r\nI hope youâ€™re doing well. I came across your business online and thought you might be interested in improving your visibility and traffic on search engines.\r\n \r\nWe specialize in helping businesses strengthen their online presence through effective SEO strategies.\r\n \r\nOnce you share your target keywords and target market, Iâ€™ll send a full proposal.\r\n \r\nWarm regards,\r\nAshwani', '2026-05-25 21:52:40'),
(15, 'Davidwipsy', 'no.reply.PerMoreau@gmail.com', 'Are you striving to draw in more customers for your business?', 'Greetings! methsisilatours.com, \r\nWhile browsing online resources I noticed methsisilatours.com. \r\nOur  businesses connect with website owners. \r\nMany businesses use similar tools to reach website owners online. \r\n  \r\n  \r\nIf you are curious, just contact us and we will share more information. \r\n \r\nThanks for taking a moment to read this. \r\nContact us. \r\nTelegram - https://t.me/FeedbackFormEU \r\nWhatsApp - +375259112693 \r\nWhatsApp  https://wa.me/+375259112693', '2026-05-26 20:46:10'),
(16, 'Nathan Bodiford', 'domains@search-methsisilatours.com', 'Results for methsisilatours.com', 'Dear Sir/Madam\r\n\r\nEnlist methsisilatours.com in GoogleSearchIndex and have it be visible in google search results!\r\n\r\nEnlist methsisilatours.com now: https://searchregister.info', '2026-06-03 17:24:19');

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

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

CREATE TABLE `destinations` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `country_code` varchar(5) DEFAULT '',
  `description` text DEFAULT NULL,
  `show_home` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `title`, `image`) VALUES
(1, 'SOUTH INDIAN TOUR', '1778911495_603759862_863812099913056_2875452075071667822_n.jpg'),
(3, 'EGYPT TOUR', '1778913211_WhatsApp Image 2025-10-17 at 11.58.09 AM.jpeg'),
(4, 'Dubai', '1779087233_3.jfif'),
(5, 'Dubai', '1779087271_13.jfif'),
(6, 'Dubai', '1779087299_22.jfif'),
(7, 'China', '1779087364_2.jpg'),
(8, 'Vietnam-Ha long Bay', '1779087434_31.jfif'),
(9, 'Malaysia', '1779087479_28.jfif'),
(10, 'Cambodia', '1779087515_19.jfif'),
(11, 'myanmar', '1779087543_7.jfif'),
(12, 'China', '1779087573_1.jpg'),
(13, 'Singapore', '1779087610_38.jfif'),
(14, 'India', '1779087649_16.jfif'),
(15, 'Egypt', '1779087693_46.jfif'),
(16, 'Thailand', '1779087742_56.jfif'),
(17, 'Singapore', '1779087778_59.jfif'),
(19, 'Vietnam', '1779087881_15.jfif'),
(20, 'Thailand', '1779087934_78.jpg'),
(21, 'Egypt-Pyramid', '1779088029_35.jfif'),
(22, 'China Tour', '1779112021_WhatsApp Image 2026-05-18 at 7.13.19 PM.jpeg'),
(23, 'China Tour customer review', '1779551938_88.jpg');

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

--
-- Table structure for table `local_tours`
--

CREATE TABLE `local_tours` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `main_image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `local_tours`
--

INSERT INTO `local_tours` (`id`, `title`, `location`, `description`, `price`, `main_image`, `created_at`) VALUES
(1, 'Sigiriya Rock Fortress', 'Sri Lanka', 'The 8th Wonder of the World, an ancient rock fortress and palace built by King Kashyapa.', 0.00, '1778328772_WhatsApp Image 2026-05-09 at 17.41.00.jpeg', '2026-05-09 10:57:00'),
(2, 'Polonnaruwa Ancient City', 'Sri Lanka', 'The second capital of Sri Lanka, a UNESCO World Heritage site with remarkably preserved ruins.', 0.00, '1778328809_WhatsApp Image 2026-05-09 at 17.43.11.jpeg', '2026-05-09 10:57:00'),
(4, 'Dambulla Cave Temple', 'Sri Lanka', 'The largest and best-preserved cave temple complex in Sri Lanka, featuring stunning Buddhist murals.', 0.00, '1778328940_WhatsApp Image 2026-05-09 at 17.45.25.jpeg', '2026-05-09 10:57:00'),
(5, 'CULTURAL TOUR', 'Sri Lanka', 'DAY 1 - ARRIVAL / SIGIRIYA\r\nArrive in Sri Lanka and transfer to Sigiriya.\r\n\r\nDAY 2 -  SIGIRIYA- POLONNARUWA - SIGIRIYA\r\nDiscover the ancient city of Polonnaruwa, known for its well-preserved ruins and historical significance. Then explore the Sigiriya Rock Fortress, a UNESCO World Heritage Site, with its stunning frescoes and panoramic views.\r\n\r\nDAY 3 - SIGIRIYA - KANDY\r\nTravel to Kandy. Visit the famous Dambulla Royal Cave Temple, adorned with ancient Buddhist murals and statues. In the evening, explore the Temple of the Tooth Relic, a spiritual center of great importance to Buddhists worldwide.\r\n\r\nDAY 4 - KANDY - NUWARA ELIYA\r\nTravel from Kandy to Nuwara Eliya, enjoying stunning views of tea plantations and rolling hills. \r\n\r\nDAY 5 - NUWARA ELIYA - ELLA - GALLE \r\nTravel to Galle. En-route visit Ella.\r\n\r\nDAY 6 - GALLE\r\nGalle city tour and relax.\r\n\r\nDAY 7 - COLOMBO\r\nTravel to Colombo. City tour and shopping.\r\n\r\nDAY 8 - COLOMBO- DEPARTURE\r\nTransfer to Airport for onward flight.\r\n\r\n', 0.00, '1778328973_WhatsApp Image 2026-05-09 at 17.45.54.jpeg', '2026-05-09 10:57:00'),
(6, 'RAMAYAN TOUR', 'Sri Lanka', 'DAY 1 - ARRIVAL- CHILAW -DAMBULLA\r\nâ€¢       Arrive at Katunayake Bandaranayake International Airport and clear immigration and custom formalities.\r\nâ€¢	Meet & Greet by Walkers tours representative or English speaking guide and transfer to Kandy via chilaw en route visit Munneshwarm Temple.\r\nâ€¢	Then proceed for Dambulla and check in to hotel and relax.\r\nâ€¢	Dinner & Overnight stay at Hotel in Dambulla.\r\n\r\nDAY 2 - DAMBULLA - SIGIRIYA- TRINCOMALEE \r\nâ€¢	After early breakfast checkout for Sigirya and visit world heritage Sigiriya Rock Fortress.\r\nâ€¢	Transfer to Trincomalee.\r\nâ€¢	Evening check in to Hotel and relax rest of the day.\r\nâ€¢	Dinner & Overnight stay at Hotel in Trincomalee.\r\n\r\nDAY 3 -  TRINCOMALEE\r\nâ€¢	After breakfast leave for visit Koneshwaram Temple and Hot well spring\r\n\r\nDAY 4 - TRINCOMALEE- DAMBULLA- KANDY\r\nâ€¢	After breakfast leave for Kandy via Dambulla. En route visit Dambulla Cave Temple and Herbal / spice Garden.\r\nâ€¢	Arriving to Kandy and do city tour.\r\nâ€¢	Check in to Hotel and relax rest of the day.\r\n\r\nDAY 5- KANDY- RAMBODA- NUWARA ELIYA\r\nâ€¢	After breakfast leave for visit most sacred Kandy Temple of Tooth Relic and transfer to Nuwara Eliya.\r\nâ€¢	En route stop at Ramboda and visit Sri Baktha Hanuman Temple and lush green Tea Plantation.\r\nâ€¢	Check in to Hotel and relax.\r\n\r\nDAY 6 - NUWARA ELIYA\r\nâ€¢	Day at Leisure. After breakfast leave for visit Divurumpola and then visit Sita Amman Temple & Ashoka Vatika. If client preference will have visit Hakkgala Botanical Garden. (optional)\r\nâ€¢	Afterwards visit Sita Amman Temple and Ashoka vatika and evening arriving to Nuwara Eliya and visit Gayathri Peedam.\r\nâ€¢	Do brief city tour in Nuwara Eliya and return to Hotel.\r\n\r\nDAY 7 - UWARA ELIYA - BENTOTA\r\nâ€¢	After Breakfast proceed to Bentota.\r\nâ€¢	Arriving to Bentota in the evening and check in to Hotel.\r\nâ€¢	Dinner & Overnight stay at Hotel in Bentota.\r\n\r\nDAY 8 - ENTOTA- UNAWATUNA - GALLE - BENTOTA\r\nâ€¢	After breakfast leave for visit Roomassala Temple and Galle city.\r\nâ€¢	Evening return to Bentota.\r\n\r\nDAY 9- BENTOTA - COLOMBO\r\nâ€¢	After breakfast check out and leave for Colombo.\r\nâ€¢	Arriving to Colombo and visit Panchamuga Anjaneyar Temple and do Colombo city tour and shopping.\r\nâ€¢	Then check in to Hotel and relax and dinner will be served at outside Restaurant.\r\n\r\nDAY 10- COLOMBO- AIRPORT\r\nâ€¢      Transfer to airport.\r\n\r\n', 0.00, '1779293313_85.jpg', '2026-05-20 15:08:36');

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

--
-- Table structure for table `local_tour_gallery`
--

CREATE TABLE `local_tour_gallery` (
  `id` int(11) NOT NULL,
  `tour_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `country_id` int(11) NOT NULL,
  `tour_name` varchar(255) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `travel_period` varchar(100) NOT NULL,
  `landmarks` text NOT NULL,
  `includes` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `main_image` varchar(255) DEFAULT NULL,
  `brochure_pdf` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `sort_order` int(11) DEFAULT 0,
  `tour_type` varchar(20) DEFAULT 'group'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `title`, `country_id`, `tour_name`, `duration`, `travel_period`, `landmarks`, `includes`, `price`, `main_image`, `brochure_pdf`, `created_at`, `sort_order`, `tour_type`) VALUES
(23, '14 DAYS PILGRIMAGE TOUR', 1, 'Dambadiva Vandana Pilgrimage', '14 Days/ 13 Nights', 'August, September, October, November', 'Sanchi, Kosambi, Varanasi, Bodhgaya, Rajgir, Vaishali, Kushinagar, Lumbini (Nepal), Kapilawastu, Sravasti, Sankassa, Agra, Delhi etc.\r\n\r\nObserve sil at Bodhgaya\r\nAlms giving at Buddhagaya, Varnasi and Savathnuwara\r\nRelics pooja at Savathnuwara\r\nSpecial Lamps and flower pooja at Savathnuwara \r\nAll sightseeing explanations by well experienced Buddhist Monk', 'Return Air Ticket-(CMB/DEL/CMB)\r\nIndian &amp; Nepal Visa\r\nEntrance Tickets \r\nAll Meals-(Sri Lankan foods)\r\nAccommodation\r\nAll Transfers\r\nWater bottles\r\nTraveling Bags\r\nHat \r\nUmbrella \r\nAccompany by Local Tour Manager', 225000.00, '1779197090_Mahabodhitemple.jpg.webp', '1779797606_14 days tour.pdf', '2026-05-06 09:07:21', 19, 'group'),
(24, '18 DAYS DAMBADIVAPILGRIMAGE TOUR', 1, 'Extended pilgrimage tour', '18 Days/ 17 Nights', '17 AUGUST 2026', 'Sanchi\r\nKosambi\r\nVaranasi\r\nBodhgaya\r\nRajgir \r\nVaishali\r\nKushinagar\r\nLumbini (Nepal)\r\nKapilawastu\r\nSravasti\r\nSankassa \r\nAgra\r\nDelhi', 'Return Air Ticket\r\nTwo way Train tickets-(Sleeping Birth)\r\nIndian &amp; Nepal Visa\r\nTrain Tickets\r\nEntrance Ticket\r\nMeals (Sri Lankan style)\r\nAccommodation \r\nWater\r\nTraveling Bags\r\nHat\r\nUmbrella\r\nAccompany by Local Tour Leader', 185000.00, '1779197045_Mahabodhitemple.jpg.webp', '1779797926_18 days train tour.pdf', '2026-05-06 09:07:21', 15, 'group'),
(25, '25 DAYS DAMBADIVA PILGRIMAGE TOUR', 1, 'Complete pilgrimage experience', '25 Days/ 24 Nights', '01 FEBRUARY 2027', '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', 240000.00, '1779197073_Mahabodhitemple.jpg.webp', NULL, '2026-05-06 09:07:21', 16, 'group'),
(26, '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', 330000.00, '1778325906_WhatsApp Image 2026-05-09 at 13.13.07 (1).jpeg', NULL, '2026-05-06 09:07:21', 5, 'group'),
(27, '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', 155000.00, '1778325864_WhatsApp Image 2026-05-09 at 13.12.33.jpeg', NULL, '2026-05-06 09:07:21', 7, 'group'),
(28, 'SOUTH INDIAN GROUP TOUR', 1, 'Group Tour - South Indian exploration', '07 Days/ 06 Nights', '25 JULY 2026', 'Tirupathi - Kovil, \r\nBangalore\r\nMysore\r\nOoty\r\nChennai -shopping(T-  Nagar,Mannady, etc,)', 'Indian Visa\r\nReturn Air Ticket\r\n6 Nights A/C Accommodation on Double/Triple shared rooms\r\nAll entrance tickets with vip pass to Thirupathi kovil\r\nAll Meals from hotels &amp; restaurants \r\nAccompany by Local Tour Leader\r\nAll sightseeing fees as program', 225000.00, '1780420021_Mysuru-Palace-banner-1920_1100.jpg', '1779252273_South india.pdf', '2026-05-06 09:07:21', 22, 'group'),
(29, 'BANGKOK TOUR', 2, 'City and temple exploration Group Tour ', '06 Days/ 05 Nights', '27 JUNE 2026', 'Bangkok City Tour with Three Temples, \r\nSafari World with Marine Park \r\nAyuttaya\r\nDhammakaya\r\nDinner Cruise\r\nDream World or  Floating Market, Putthamanthon  \r\nUnlimited Shopping', 'Return Air Ticket\r\n05 Nights\r\nAccommodation on Double/Triple shared rooms\r\nMeals\r\nAccompany by Local Tour Leader\r\nAll sightseeing fees as program', 239000.00, '1779270347_WhatsApp Image 2026-05-19 at 16.38.11.jpeg', NULL, '2026-05-06 09:07:21', 18, 'group'),
(30, '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', 268000.00, '1778332252_Home-2 (1).jpeg', NULL, '2026-05-06 09:07:21', 9, 'group'),
(31, '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.00, '1778326231_WhatsApp Image 2026-05-09 at 13.18.05 (1).jpeg', NULL, '2026-05-06 09:07:21', 11, 'group'),
(32, 'MALAYSIA TOUR', 3, 'Malaysia highlights', '04Days/ 03Nights', 'Seasonal', 'City Tour, Batu Caves, Genting Highland, Sunway Lagoon, Shopping', 'Malaysia Tourist Visa\r\n43 - Nights Accommodation at 3* Hotel Based on Twin/ Double shared rooms with breakfast All sightseeing fees as program\r\nUnlimited shopping', 105000.00, '1779853207_71.jfif', NULL, '2026-05-06 09:07:21', 14, 'private'),
(33, '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', 275000.00, '1778328500_WhatsApp Image 2026-05-09 at 17.38.09.jpeg', NULL, '2026-05-06 09:07:21', 13, 'group'),
(34, 'SINGAPORE & MALAYSIA TOUR ', 4, 'Group tour with Two Countries-Singapore & Malaysia', '06 Days/ 05 Nights', '16th September 2026', 'Changi Airport Jewel tour\r\nGardens by the Bay\r\nSingapore City Tour\r\nSingapore Merlion\r\nWater fountain show\r\nMalaysia City Tour\r\nBatu Caves\r\nGenting Highland with return cable car\r\nSunway Lagoon', 'Malaysian Tourist Visa \r\nReturn Air Ticket\r\n6 Nights Accommodation at 3* Hotel based on Twin/Double/Triple shared room \r\nBreakfast, Lunch & Dinner(As per Itinerary)\r\nAccompany by Local Tour Leader \r\nAll sightseeing fees as program', 298500.00, '1778326999_WhatsApp Image 2026-05-09 at 13.21.59.jpeg', '1779274659_SIN & MAL ITINERARY.pdf', '2026-05-06 09:07:21', 21, 'group'),
(35, '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', 194000.00, '1778896330_WhatsApp Image 2026-05-15 at 22.13.56.jpeg', NULL, '2026-05-06 09:07:21', 10, 'group'),
(36, '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', 384000.00, '1779122381_19.jfif', NULL, '2026-05-06 09:07:21', 12, 'group'),
(37, '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', 418000.00, '1778331986_Schwegadon Pagoda, Myanmar.jpeg', NULL, '2026-05-06 09:07:21', 8, 'group'),
(38, ' VIETNAM 8 DAYS GROUP TOUR', 8, 'HO CHI MINH , DA NANG, HANOI, HALONG BAY, HOI AN', '08 Days/ 07 Nights', '22 AUGUST 2026', '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, 2 Domestic Air Tickets - Hanoi to Da Nang and Da Nang to Saigon, Airport Transfers, 7 Nightsï¿½ Accommodation at 4 * Hotel based on Double/Triple shared rooms, English Speaking Tour guides, Accompany by Local Tour Manager, All sightseeing fees as programme, 1 Night in 5 star Cruise 1 in Ha Long Bay', 456000.00, '1778328591_WhatsApp Image 2026-05-09 at 17.39.38.jpeg', NULL, '2026-05-06 09:07:21', 20, 'group'),
(39, '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', 398000.00, '1778326668_WhatsApp Image 2026-05-09 at 13.25.02.jpeg', NULL, '2026-05-06 09:07:21', 6, 'group'),
(40, 'EGYPT GROUP 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', 674000.00, '1778326602_WhatsApp Image 2026-05-09 at 13.24.49.jpeg', NULL, '2026-05-06 09:07:21', 4, 'group'),
(41, 'AZERBAIJAN GROUP 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, Quba tour, Absheron & Gobustan Tour', 'Azerbaijan E Visa, Return Air Ticket, Airport Transfer,5 Nightsï¿½ Accommodation at Baku & 1 Nightsï¿½ Accommodation at Gabala, Breakfast & Dinner, Private Transfer, English Speaking Tour Guide, Accompanying by Methsisila Tour Guide, All sightseeing fee as programme', 445000.00, '1778327650_akjbjlgn.jpeg', NULL, '2026-05-06 09:07:21', 2, 'group'),
(42, 'CHINA GROUP TOUR', 6, 'SHANGHAI, BEIJIN ', '07 Days/ 06 Nights', '07 AUGUST 2026', 'Great Wall, Acrobatic Show, Wangfujing street,  Bird 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 Huangpu River', 'Tourist Visa\r\nReturn Air Ticket\r\nBullet Train Ticket,\r\n7  Nights Accommodation  at  4 *  Hotel based on Double/Triple shared rooms\r\nAll Meals \r\nAll sightseeing fees as programme\r\nEnglish Speaking Tour guides\r\nAccompany by Local Tour Manager\r\n', 525000.00, '1778326375_WhatsApp Image 2026-05-09 at 13.23.43.jpeg', NULL, '2026-05-06 09:07:21', 23, 'group'),
(43, 'DUBAI GROUP TOUR', 5, 'Dubai luxury tour', '05 Nights/ 06 Days', 'October,November,December,January,February,March', 'VIP Desert Safari, Miracle Garden, Global Village, Marina Cruise, Dubai City Tour, Water Fountain show,  Burj Kalifa', 'Tourist Visa, Return Air Ticket, Airport Transport, 5 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', 319000.00, '1778326340_WhatsApp Image 2026-05-09 at 13.23.13.jpeg', NULL, '2026-05-06 09:07:21', 3, 'group'),
(44, 'MALDIVES TOUR', 13, 'Maldives island hopping', '04 Days/ 03 Nights', 'GROUP/ PRIVATE', 'Resort Tour, 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, 3Nightsï¿½  Accommodation  at  4 *  Hotel based on Double/Triple shared rooms, Breakfast, Lunch, Dinner, Private transfer with experienced drivers, All sightseeing fees as programme', 289000.00, '1778327506_mmmm.jpeg', NULL, '2026-05-06 09:07:21', 1, 'group'),
(45, 'MALAYSIA GROUP TOUR', 3, 'KULA LUMPUR CITY TOUR WITH KL TOWER, TWIN TOWERS, KING\'S PALACE, INDEPENDENCE SQUARE ETC.\r\n\r\nBATU CAVES\r\nGENTING HIGHLAND WITH CABLE CAR\r\nSUNWAY LAGOON\r\n', '05 Days/ 04 Nights', '17 SEPTEMBER 2026', 'KULA LUMPUR CITY TOUR WITH KL TOWER, TWIN TOWERS, KING\'S PALACE, INDEPENDENCE SQUARE ETC.\r\n\r\nBATU CAVES\r\nGENTING HIGHLAND WITH CABLE CAR\r\nSUNWAY LAGOON\r\n', 'AIR TICKET\r\nVISA\r\n4NIGHTS HOTEL ACCOMMODATION WITH BREAKFAST\r\nALL TRANSFERS\r\nALL ENTRANCE TICKETS\r\nACCOMMOPANY BY LOCAL TOUR MANAGER', 209000.00, '1779383934_6.jfif', '', '2026-05-21 17:18:54', 17, 'group'),
(46, 'KERALA TOUR', 1, 'KOCHIN\r\nALLAPY HOUSEBOAT\r\nTEKKADY\r\nMUNNAR\r\n', '7 Days /6 Nights', '02 OCTOBER 2026', 'KOCHIN\r\nALLAPY HOUSEBOAT\r\nTEKKADY\r\nMUNNAR', 'AIR TICKET\r\nVISA\r\n5* 4* 3* HOTEL ACCOMMODATION\r\nALL MEALS \r\nALL ENTRANCE FEE\r\n1 NIGHT IN HOUSEBOAT\r\nACCOMMPONY BY TOUR MANAGER', 274000.00, '1780419208_kerala-main-scaled.jpg', '', '2026-06-02 16:53:28', 25, 'group'),
(47, 'VIETNAM 07 DAYS TOUR ', 8, 'EXPLORE THE BEAUTY OF VIETNAM...', '7 Days /6 Nights', '19 SEPTEMBER 2026', 'HO CHI MINH (SAIGON) \r\nHANOI\r\nHALONG BAY\r\nNINH BINH ', 'INTERNATIONAL AIR TICKET\r\nDOMESTIC AIR TICKET\r\nTOURIST VISA\r\n4 STAR HOTEL ACCOMMODATION\r\n5 STAR CRUISE IN HALONG BAY\r\nALL ENTRANCE FEE\r\nALL TRANSFERS\r\nACCOMMOPANY BY TOUR MANAGER\r\nENGLISH SPEAKING TOUR GUIDE\r\n', 385000.00, '1780419798_03.jpg', '', '2026-06-02 17:03:18', 24, 'group');

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

--
-- Table structure for table `package_gallery`
--

CREATE TABLE `package_gallery` (
  `id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `package_gallery`
--

INSERT INTO `package_gallery` (`id`, `package_id`, `image`) VALUES
(1, 40, '1778913264_WhatsApp Image 2025-10-17 at 8.18.43 PM.jpeg'),
(2, 40, '1778913264_WhatsApp Image 2025-10-17 at 11.58.03 AM (1).jpeg'),
(3, 40, '1778913264_WhatsApp Image 2025-10-17 at 11.58.14 AM (2).jpeg'),
(4, 40, '1778913264_WhatsApp Image 2025-10-20 at 12.46.31 PM (1).jpeg'),
(5, 40, '1778913264_WhatsApp Image 2025-10-20 at 12.46.35 PM.jpeg'),
(6, 40, '1778913264_WhatsApp Image 2025-10-20 at 12.46.57 PM.jpeg'),
(7, 40, '1778913264_WhatsApp Image 2025-10-20 at 12.47.29 PM.jpeg'),
(8, 28, '1779120285_52.jfif'),
(9, 38, '1779120630_24.jfif'),
(10, 38, '1779120630_32.jfif'),
(11, 38, '1779120630_49.jfif'),
(12, 38, '1779120630_53.jfif'),
(13, 42, '1779121300_2.jpg'),
(14, 43, '1779121878_3.jfif'),
(15, 43, '1779121878_13.jfif'),
(16, 43, '1779121878_22.jfif'),
(17, 43, '1779121878_51.jfif'),
(18, 43, '1779121878_62.jfif'),
(19, 45, '1779383934_28.jfif');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `whatsapp_number` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `whatsapp_number`, `email`, `phone`, `address`, `facebook`, `instagram`) VALUES
(1, '94771957420', 'methsisilatours@gmail.com', 'Office: +94382289880', 'No 14, Sangamittarama road, Ramukkana, Bandaragama, Sri lanka', NULL, NULL);

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

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

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sliders`
--

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

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

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

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `client_name` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `rating` int(11) NOT NULL DEFAULT 5
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `client_name`, `message`, `rating`) VALUES
(1, 'John Doe', 'Methsisila Tours made our trip to India unforgettable. Everything was perfectly planned and executed.', 5),
(2, 'Sarah Smith', 'The pilgrimage tour was a life-changing experience. Highly recommend their professional service.', 5),
(3, 'David Wilson', 'Professional, friendly, and very well organized. Looking forward to our next trip with them!', 4);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `package_gallery`
--
ALTER TABLE `package_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_id` (`package_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `destinations`
--
ALTER TABLE `destinations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `local_tours`
--
ALTER TABLE `local_tours`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `local_tour_gallery`
--
ALTER TABLE `local_tour_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `package_gallery`
--
ALTER TABLE `package_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `local_tour_gallery`
--
ALTER TABLE `local_tour_gallery`
  ADD CONSTRAINT `local_tour_gallery_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `local_tours` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `destinations` (`id`);

--
-- Constraints for table `package_gallery`
--
ALTER TABLE `package_gallery`
  ADD CONSTRAINT `package_gallery_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
