-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 03, 2023 at 01:21 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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


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

--
-- Database: `touristica_travels`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `name`, `username`, `email`, `password`, `image`, `date`) VALUES
(1, 'admin', 'admin', 'admin@gmail.com', '$2y$10$.dXwLiT9LlmC0AjSjLzFGuJqA7uYGeYtkSom.quFVG/.FHfbMim9W', 'images/admin.png', '02-05-2019');

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

--
-- Table structure for table `admission`
--

CREATE TABLE `admission` (
  `id` int(11) NOT NULL,
  `code_no` varchar(255) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `dob` text NOT NULL,
  `sex` varchar(255) NOT NULL,
  `qualification` varchar(255) NOT NULL,
  `caste` varchar(255) NOT NULL,
  `income` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `teacher` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `branch` varchar(255) NOT NULL,
  `course_fee` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `joining_date` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `admission`
--

INSERT INTO `admission` (`id`, `code_no`, `student_name`, `father_name`, `dob`, `sex`, `qualification`, `caste`, `income`, `address`, `phone`, `class`, `teacher`, `date`, `time`, `course`, `branch`, `course_fee`, `duration`, `joining_date`, `image`) VALUES
(2, 'AKI/19/1', 'rajat', 'anup', '12/6/2000', 'Male', 'M.A', 'OBC', '72000', 'home', '8617271211', 'DTP', 'Ranajit', '14/07/2019', '11.00 AM', 'DTP', '', '5000', '6 month', '16/06/2019', 'images/246Koala.jpg'),
(3, 'AKI/19/2', 'Soumen', 'ram', '12/6/2000', 'Male', 'M.A', 'OBC', '72000', 'home', '9123879229', 'Phootoshop', 'Siraj Mondal', '14-11-2019', '2.00 PM', 'Photoshop', 'Baguiati Jyangra Kalitala', '5000', '9 month', '16/06/2019', 'images/173Penguins.jpg'),
(4, 'AKI/19/3', 'Subhankar', 'ram', '12/6/2000', 'Male', 'M.A', 'OBC', '72000', 'home', '9830851928', 'Phootoshop', 'Siraj Mondal', '14-11-2019', '2.00 PM', 'Photoshop', '', '5000', '9 month', '16/06/2019', 'images/180Penguins.jpg'),
(8, 'AKI/BJK/19/7', 'hori', 'kartik', '12/6/2019', 'Male', 'ma', 'OBC', '72000', 'kolkata', '07686945931', 'vxzv', 'Ranajit Saha', '22-11-2019', '11.00 AM', 'Photoshop', 'Baguiati Jyangra Kalitala', '5000', '6 month', '18/06/2019', 'images/8582e1c2028-c9ed-47b5-9656-057b01cd9911.jpg');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `details` longtext NOT NULL,
  `category` longtext NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `name`, `image`, `details`, `category`, `date`) VALUES
(14, '', 'category/young-woman-hiker-taking-427.jpg', '<p><b>Unveiling Journeys, Creating Memories</b><br>\nWelcome to a world of wanderlust, where every journey is an enchanting tale waiting to be written. At\nTouristica India Private Limited, we are not just travel enthusiasts; we are storytellers, weaving the threads\nof your adventures into unforgettable narratives.</p><p><b>Our Odyssey Begins</b><br>\nIn the heart of our company beats the passion to explore, the yearning to connect, and the desire to\nignite your wanderlust. Established in 2017, formally known as N B Travels, which was incorporated at\n2023 and is known as Touristica India Private Limited was born from a shared dream of transforming\nordinary vacations into extraordinary odysseys.</p><p><b>Guided by Purpose</b><br>\nOur compass is set by a singular purpose: to introduce you to the worlds wonders, one immersive\nexperience at a time. We believe in travel that leaves footprints on hearts, not on nature is delicate path.\n</p><p><b>The Touristica India Way</b><br>\nWhat sets us apart is our commitment to curate journeys that reflect your unique spirit. Whether you\ncrave the thrill of off-grid adventures or the serenity of hidden escapes, we tailor every detail to your\ndesires.\n</p><p><b>Meet Your Fellow Adventurers</b><br>\nBehind the scenes, our team of globetrotters, explorers, and travel connoisseurs is dedicated to crafting\nthe perfect itinerary for your dreams. We live and breathe travel, and our expertise shines through\nevery destination we unveil.\n</p><p><b>Stories from the Trail</b><br>\nWe are immensely proud of the stories our travelers bring back. Dive into our Travelers Journal to read\nfirsthand accounts of laughter, wonder, and discovery. Your story could be the next chapter.</p><p>\n<b>Embark on Your Journey</b><br>\nYour adventure awaits. Contact us at info@touristicaindia.com or give us a call at <b>+91-9046307793</b> to\nstart planning your next expedition. Join us as we paint the world with your wanderlust.\nAt Touristica India it is not just travel; it is a tapestry of memories waiting to be woven. Lets embark on\nthis extraordinary journey together.\n</p>', '<p><b>Unveiling Journeys, Creating Memories</b><br>\nWelcome to a world of wanderlust, where every journey is an enchanting tale waiting to be written. At\nTouristica India Private Limited, we are not just travel enthusiasts; we are storytellers, weaving the threads\nof your adventures into unforgettable narratives.</p><p><b>Our Odyssey Begins</b><br>\nIn the heart of our company beats the passion to explore, the yearning to connect, and the desire to\nignite your wanderlust. Established in 2017, formally known as N B Travels, which was incorporated at\n2023 and is known as Touristica India Private Limited was born from a shared dream of transforming\nordinary vacations into extraordinary odysseys.</p><p><b>Guided by Purpose</b><br>\nOur compass is set by a singular purpose: to introduce you to the worlds wonders, one immersive\nexperience at a time. We believe in travel that leaves footprints on hearts, not on nature is delicate path.\n</p>', '25/10/2020');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` varchar(2550) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `name`, `details`, `image`, `date`) VALUES
(3, 'Contrary to popular belief ipsum is not simply ', '<p>Quickly predominate enabled technology and web-enabled schemas. Completely evisculate diverse communities whereas pandemic data. Quickly build covalent data after turnkey content. Distinctively reconceptualize customized growth strategies via prospective potentialities. Professionally pursue cutting-edge web-readiness vis-a-vis just in time infrastructures.<br></p><p>Conveniently target client-based systems with turnkey sources. Collaboratively syndicate focused opportunities for interactive deliverables. Assertively initiate client-based infomediaries through collaborative mindshare. Completely create bleeding-edge meta-services through compelling functionalities. Distinctively redefine timely initiatives rather than resource maximizing value.</p>', 'images/820760cadd-centre-new-alipore-new-alipur-kolkata-autocad-training-institutes-6oup4h70sj.avif', '13-09-2023');

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

--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `career`
--

INSERT INTO `career` (`id`, `name`, `email`, `course`, `phone`, `address`, `message`, `date`) VALUES
(4, 'Trisha Roy', 'trisha@gmail. com', 'Expert Certificate in Product Design and Analysis', '8961500903', 'rewr', 'erer', '19/08/2023'),
(5, 'demo', 'demo@gmail.com', 'Proficient in AutoCAD', '8910566319', 'demo', 'demo', '12/09/2023'),
(6, 'demo', 'demo@gmail.com', 'Proficient in AutoCAD', '8961500903', 'demo', 'demo', '12/09/2023');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category_name`, `image`) VALUES
(3, 'Daily Needs', 'category/harvest.png'),
(5, 'Dance', 'category/dancer-with-music.png');

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

--
-- Table structure for table `certificate`
--

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

--
-- Dumping data for table `certificate`
--

INSERT INTO `certificate` (`id`, `name`, `image`, `date`) VALUES
(8, 'Certificate 1', 'images/755certificate1.JPG', '12-09-2023'),
(9, 'Certificate 2', 'images/36certificate2.JPG', '12-09-2023'),
(10, 'Certificate 3', 'images/233certificate3.JPG', '12-09-2023'),
(11, 'Certificate 4', 'images/26certificate4.JPG', '12-09-2023'),
(12, 'Certificate 5', 'images/37certificate5.JPG', '12-09-2023'),
(13, 'Certificate 6', 'images/676certificate6.JPG', '12-09-2023'),
(14, 'Certificate 7', 'images/396certificate7.JPG', '12-09-2023');

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `ph1` varchar(15) NOT NULL,
  `ph2` varchar(15) NOT NULL,
  `wp` varchar(15) NOT NULL,
  `email` varchar(222) NOT NULL,
  `fb` varchar(255) NOT NULL,
  `you` varchar(255) NOT NULL,
  `insta` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `name`, `logo`, `address`, `ph1`, `ph2`, `wp`, `email`, `fb`, `you`, `insta`, `date`, `time`) VALUES
(4, 'Touristica India Pvt. Ltd.', 'images/798logo.jpg', 'A-8/22 Kalyani,  Nadia, West Bengal, India, 741235.', '90463 07793', '90463 07793', '90463 07793', 'info@touristicaindia.com', 'https://www.facebook.com/', 'https://youtube.com', 'https://instagram.com', '18-09-2023', '10:00am - 10:00pm ( Monday - Saturday )  Sunday-open 24 hours');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `email`, `phone`, `subject`, `message`, `date`) VALUES
(3, 'Nick', 'nick@gmail.com', 'null', '', 'GOOD', '29/09/2023');

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

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `details` varchar(1000) NOT NULL,
  `teacher` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`id`, `name`, `image`, `details`, `teacher`, `duration`, `date`) VALUES
(18, '', 'category/cadd-centre-new-alipur-kolkata-autocad-training-institutes-ptdnzza8s3.jpg', '', '', '', '07-08-2023'),
(19, '', 'category/cadd-centre-new-alipur-kolkata-autocad-training-institutes-lbu89lyeek.avif', '', '', '', '07-08-2023');

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

--
-- Table structure for table `date`
--

CREATE TABLE `date` (
  `id` int(11) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `message` varchar(25555) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `date`
--

INSERT INTO `date` (`id`, `fname`, `lname`, `email`, `subject`, `phone`, `city`, `message`, `date`) VALUES
(1, 'sumanta', '', 'adsy@gmail.com', 'test', '903859156', 'kolkata', '', '20-12-2021'),
(2, 'sumanta', '', 'tset@gmail.com', '', '9038591598', '', 'sad', '30-12-2021'),
(3, 'dsada', '', 'test@gmail.com', 'Kolkat a bba  an  apkeiiy lanal e 563211', '3092356897', '', 'adsad', '30-12-2021');

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

--
-- Table structure for table `destination`
--

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

--
-- Dumping data for table `destination`
--

INSERT INTO `destination` (`id`, `destination_name`, `image`, `date`) VALUES
(1, 'Malali Hills', 'images/791Untitled.jpg', '27-09-2023'),
(2, 'Darjeeling Hill', 'images/557Untitled.jpg', '27-09-2023'),
(3, 'Puri Beach', 'images/373Untitled3.jpg', '27-09-2023'),
(4, 'Simla Hill', 'images/673Untitled52.jpg', '27-09-2023'),
(5, 'Andaman Beach', 'images/194Untitled6.jpg', '27-09-2023');

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

--
-- Table structure for table `enquiry_message`
--

CREATE TABLE `enquiry_message` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `enquiry_message`
--

INSERT INTO `enquiry_message` (`id`, `name`, `email`, `course`, `message`, `date`) VALUES
(6, 'demo', 'demo@gmail.com', 'Expert Certificate in Product Design and Analysis', 'demo', '12/09/2023'),
(7, 'demo', 'demo@gmail.com', 'Masters Certificate in Product Design', 'demo', '12/09/2023');

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `area` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `image2` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`id`, `name`, `image`, `description`, `area`, `date`, `image2`) VALUES
(59, 'Your Trusted Advisor', 'images/1388521985.png', ' We will answer your every question. Our experienced travel experts and real-time on field know-how gives us this advantage. ', 'null', '18-09-2023', 'null'),
(60, 'We Love Listening', 'images/4549339554.png', 'Your holiday, your terms. We will fill in the blanks to plan the perfect trip in the blink of an eye.', 'null', '18-09-2023', 'null'),
(61, 'Memorable Experiences', 'images/8328439091.png', ' Do everything or do nothing. Either way, your holiday will be nothing less than extraordinary.', 'null', '18-09-2023', 'null'),
(62, 'Easy as ABC', 'images/14110315613.png', 'Travel smooth and stress-free. That is how easy we make it because that is how your holiday should be.', 'null', '18-09-2023', 'null'),
(63, 'Handcrafted Holidays', 'images/2123976049.png', ' We interact with our loyal customers to co-create unique experiences that will take your holiday to the next level. ', 'null', '18-09-2023', 'null');

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

--
-- Table structure for table `exam`
--

CREATE TABLE `exam` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` mediumtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `exam`
--

INSERT INTO `exam` (`id`, `name`, `details`, `image`, `date`) VALUES
(57, 'Royal', 'Headquartered in Kolkata, India Royal takes pride in providing technical expertise and customize sealing solutions for all your hydraulic and pneumatic cylinder applications. From Mining machineries to construction equipment, from agricultural machinery to material handling equipment.', 'images/841logo.svg', '13-09-2023'),
(58, 'Six Fold', 'Six Fold Technology Pvt. Ltd. was incepted with the mission and vision of providing cost effective engineering and technology solutions to the Industry and Society and establish itself into a reliable Engineering House catering to the diverse sectors of Developing India. ', 'images/224logo2.png', '13-09-2023'),
(59, 'Harsh Implex', 'Harsh Impex & Ishaan Plastics (P) Ltd are the Indian group of Company Manufacturing PET fridge bottles, jars, containers, perform & caps situated in Kolkata.', 'images/25main-logo.png', '13-09-2023'),
(60, 'ipsen india', 'Excellence in thermal processing allows you to push the boundaries of what is possible: whether it is transforming space exploration, crafting better medical implants or developing more efficient cars and jet engines. Backed by more than 75 years of experience, our global team works in concert so that manufacturers and commercial heat treaters can innovate with confidence.', 'images/668Ipsen-75th-Logo-e1672847431985.png', '0000-00-00'),
(61, 'SMS India Pvt Ltd', '<p>All over the world, SMS group stands for future-oriented technology and \r\noutstanding service in plant construction and mechanical engineering for\r\n the metals industry. We use our 150 years of experience and our unique \r\nexpertise in metallurgy, industrial processes, and digitalization to \r\ncreate new perspectives for our industry through continuous innovation –\r\n also beyond our core business. We are the right partner for challenging\r\n projects and consistently harness new potential for our customers \r\nthroughout the entire life cycle of their plant and equipment.</p>', 'images/523514.png', '2023-09-02');

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

--
-- Table structure for table `exam_reminder`
--

CREATE TABLE `exam_reminder` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `student_code` varchar(255) NOT NULL,
  `msg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `exam_reminder`
--

INSERT INTO `exam_reminder` (`id`, `student_name`, `course`, `student_code`, `msg`) VALUES
(86, 'Subhankar', 'Photoshop', 'AKI/19/2', '	\r\n	hello'),
(87, 'Subhankar', 'Photoshop', 'AKI/19/3', '	\r\n	hello'),
(88, 'rajat', 'DTP', 'AKI/19/1', '	\r\n	hi');

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

--
-- Table structure for table `expence`
--

CREATE TABLE `expence` (
  `id` int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `expence`
--

INSERT INTO `expence` (`id`, `amount`, `reason`, `date`) VALUES
(1, '100', 'Eletric', '2019-11-13'),
(2, '150', 'Cable', '2019-11-15');

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

--
-- Table structure for table `fees_reminder`
--

CREATE TABLE `fees_reminder` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `student_code` varchar(255) NOT NULL,
  `msg` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `fees_reminder`
--

INSERT INTO `fees_reminder` (`id`, `student_name`, `course`, `student_code`, `msg`, `date`) VALUES
(17, 'Subhankar', 'Photoshop', 'AKI/19/2', '	\r\n	fees', '15-11-2019'),
(18, 'Subhankar', 'Photoshop', 'AKI/19/3', '	\r\n	fees', '15-11-2019'),
(19, 'Subhankar', 'Photoshop', 'AKI/19/2', '	\r\n	fees', '15-11-2019'),
(20, 'Subhankar', 'Photoshop', 'AKI/19/3', '	\r\n	fees', '15-11-2019'),
(21, 'Soumen', 'Photoshop', 'AKI/19/2', '	Yor Are not paid Fees for this month in Photoshop.\r\n	', '20-11-2019'),
(22, '', '', '', '	\r\n	You Not Paid the fees for the month march . Please paid this to  continue the course.', '20-11-2019'),
(23, '', '', '', 'not pad for march	', '20-11-2019'),
(24, '', '', '', 'not pad for march	', '20-11-2019'),
(25, 'Subhankar', 'Photoshop', 'AKI/19/3', 'not pad for march	', '20-11-2019'),
(26, 'Subhankar', 'Photoshop', 'AKI/19/3', 'not pad for march	', '20-11-2019'),
(27, 'Subhankar', 'Photoshop', 'AKI/19/3', '	you not paid\r\n	', '20-11-2019');

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

--
-- Table structure for table `fees_table`
--

CREATE TABLE `fees_table` (
  `id` int(255) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `branch` varchar(255) NOT NULL,
  `student_code` varchar(255) NOT NULL,
  `month` varchar(255) NOT NULL,
  `fees` varchar(255) NOT NULL,
  `fees_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `fees_table`
--

INSERT INTO `fees_table` (`id`, `student_name`, `course`, `branch`, `student_code`, `month`, `fees`, `fees_date`) VALUES
(1, 'Soumen', 'Photoshop', 'Baguiati Jyangra Kalitala', 'AKI/19/2', 'January', '500', '2019-11-10'),
(3, 'Soumen', 'Photoshop', 'Baguiati Jyangra Kalitala', 'AKI/19/2', 'February', '500', '2019-11-15'),
(9, 'hori', 'Photoshop', 'Baguiati Jyangra Kalitala', 'AKI/BJK/19/7', 'January', '500', '2019-11-22');

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

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

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

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

INSERT INTO `gallery` (`id`, `name`, `image`, `date`) VALUES
(28, 'gl1', 'gallery/gl1.jpg', '16-09-2023'),
(29, 'gl2', 'gallery/gl2.jpg', '16-09-2023'),
(30, 'gl3', 'gallery/gl3.jpg', '16-09-2023'),
(31, 'gl4', 'gallery/gl4.jpg', '16-09-2023'),
(32, 'gl5', 'gallery/gl5.jpg', '16-09-2023'),
(33, 'gl6', 'gallery/gl6.jpg', '16-09-2023'),
(34, 'gl7', 'gallery/gl7.jpg', '16-09-2023'),
(35, 'gl8', 'gallery/gl8.jpg', '16-09-2023'),
(36, 'gl9', 'gallery/gl9.jpg', '16-09-2023');

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

--
-- Table structure for table `image_details`
--

CREATE TABLE `image_details` (
  `id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `tid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `image_details`
--

INSERT INTO `image_details` (`id`, `package_name`, `image`, `date`, `tid`) VALUES
(23, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'images/842Untitled1.jpg', '2023-09-30', '315'),
(24, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'images/880Untitled2.jpg', '2023-09-30', '315'),
(25, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'images/802images3.jpg', '2023-09-30', '315'),
(26, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'images/152images4.jpg', '2023-09-30', '315'),
(27, 'Weekend in Spain', 'images/559Untitled4.jpg', '2023-10-25', '197'),
(28, 'Weekend in Spain', 'images/581Untitled5.jpg', '2023-10-25', '197'),
(29, 'Weekend in Spain', 'images/7616.jpg', '2023-10-25', '197'),
(30, 'Weekend in Spain', 'images/478Untitled7.jpg', '2023-10-25', '197'),
(31, 'Spectacular Greece 6Nights', 'images/3131.jpg', '2023-11-02', '191'),
(32, 'Spectacular Greece 6Nights', 'images/8102.jpg', '2023-11-02', '191'),
(33, 'Spectacular Greece 6Nights', 'images/8204.jpg', '2023-11-02', '191'),
(34, 'Spectacular Greece 6Nights', 'images/9233.jpg', '2023-11-02', '191'),
(35, 'Fantastic France', 'images/895.jpg', '2023-11-07', '386'),
(36, 'Fantastic France', 'images/126.jpg', '2023-11-07', '386'),
(37, 'Fantastic France', 'images/3557.jpg', '2023-11-07', '386'),
(38, 'Fantastic France', 'images/5768.jpg', '2023-11-07', '386'),
(39, 'Take off from Mumbai to Goa', 'images/38211.jpg', '2023-11-23', '397'),
(40, 'Take off from Mumbai to Goa', 'images/17512.jpg', '2023-11-23', '397'),
(41, 'Take off from Mumbai to Goa', 'images/13613.jpg', '2023-11-23', '397'),
(42, 'Take off from Mumbai to Goa', 'images/31814.jpg', '2023-11-23', '397'),
(43, 'Take a trip to the Ravishing North India', 'images/26615.jpg', '2023-11-03', '363'),
(44, 'Take a trip to the Ravishing North India', 'images/40316.jpg', '2023-11-03', '363'),
(45, 'Take a trip to the Ravishing North India', 'images/12617.jpg', '2023-11-03', '363'),
(46, 'Take a trip to the Ravishing North India', 'images/73718.jpg', '2023-11-03', '363'),
(47, 'Divine Do Dham Yatra 2023', 'images/92019.jpg', '2023-12-08', '389'),
(48, 'Divine Do Dham Yatra 2023', 'images/42620.jpg', '2023-12-08', '389'),
(49, 'Divine Do Dham Yatra 2023', 'images/15521.jpg', '2023-12-08', '389'),
(50, 'Divine Do Dham Yatra 2023', 'images/33222.jpg', '2023-12-08', '389');

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

--
-- Table structure for table `isat`
--

CREATE TABLE `isat` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `isat`
--

INSERT INTO `isat` (`id`, `image`, `date`) VALUES
(3, 'event/carousel-1.jpg', '02-06-2023');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `name`, `image`, `description`, `date`) VALUES
(7, 'Class V', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/J-c-3Dl3cPg\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '18-05-2023'),
(8, 'CLASS 5 to 10', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/_Gr5y1_v9DA\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '23-05-2023'),
(9, 'CLASS 5 to 10', 'Mathematics', 'https://youtu.be/_Gr5y1_v9DA', '23-05-2023'),
(10, 'CLASS 5 to 10', 'Mathematics', 'https://www.youtube.com/watch?v=_Gr5y1_v9DA', '23-05-2023'),
(11, 'CLASS 11 ', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/y3C0VuN2DKc\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '24-05-2023'),
(12, 'CLASS 11 ', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/y3C0VuN2DKc\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '24-05-2023'),
(13, 'CLASS 11 ', 'Chemistry', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/dCubjfbbz6M\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '29-05-2023'),
(14, 'CLASS 5 to 10', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/dCubjfbbz6M\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '29-05-2023'),
(15, 'CLASS 5 to 10', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/y3C0VuN2DKc\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '29-05-2023'),
(16, 'C lass VIII', 'Mathematics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/y3C0VuN2DKc\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '29-05-2023'),
(17, 'Class IX', 'Physics', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/y3C0VuN2DKc\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></ifr', '29-05-2023'),
(18, 'JEE ', 'Chemistry', '<iframe width=\"100%\" height=\"100%\" src=\"https://www.youtube.com/embed/G8nNGk6LHaM\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></i', '31-05-2023');

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

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `pax` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `tour_type` varchar(255) NOT NULL,
  `date_of_journey` varchar(255) NOT NULL,
  `tid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `package_name`, `image`, `duration`, `price`, `pax`, `destination`, `tour_type`, `date_of_journey`, `tid`) VALUES
(6, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'images/474677p-alpha6.png', '3 Day & 2 night', '79000', '4 Minimum', 'Malali Hills', 'international', '2023-09-30', '315'),
(7, 'Weekend in Spain', 'images/81SightSeeingPfGSiK.jpg', '4 Nights / 5 Days', '38000', '4 Minimum', 'Select Destination', 'international', '2023-10-25', '197'),
(8, 'Spectacular Greece 6Nights', 'images/842Attractionmm5Mf3.jpg', '6 Nights / 7 Days', '58000', '6 Person', 'Select Destination', 'international', '2023-11-02', '191'),
(9, 'Fantastic France', 'images/324SightSeeingIb2zsC.jpg', '5 Nights / 6 Days', '68000', '6 Person', 'Select Destination', 'international', '2023-11-07', '386'),
(10, 'Take off from Mumbai to Goa', 'images/380SightSeeinglzZc0z.jpg', '4 Nights / 5 Days', '14000', '6 Person', 'Select Destination', 'domestic', '2023-11-23', '397'),
(11, 'Take a trip to the Ravishing North India', 'images/475SightSeeingyiYeYk.jpg', '6 Nights / 7 Days', '19000', '6 Person', 'Select Destination', 'domestic', '2023-11-03', '363'),
(12, 'Divine Do Dham Yatra 2023', 'images/312SightSeeing7mdZ3d.jpg', '4 Nights / 5 Days', '21000', '4 Minimum', 'Select Destination', 'domestic', '2023-12-08', '389');

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

--
-- Table structure for table `package_details`
--

CREATE TABLE `package_details` (
  `id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `tid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `package_details`
--

INSERT INTO `package_details` (`id`, `package_name`, `details`, `date`, `tid`) VALUES
(2, 'Weekend in Spain', 'Spain is a beautiful, interesting, and dynamic country with a lot of regional uniqueness and variety. Madrid and Barcelona are hip and energetic cities, Granada has a Moorish touch, Basque Country up north contrast itself to Southern living.The Spaniards ', '2023-10-25', '197'),
(3, 'Spectacular Greece 6Nights', 'Experience the best of Greece in just six nights with the Spectacular Greece 6 Nights package offered by EaseMyTrip. You will explore Athens, Santorini, and Mykonos with expert guides, enjoying comfortable accommodations and unforgettable experiences.\r\n\r\n', '2023-11-02', '191'),
(4, 'Take off from Mumbai to Goa', 'Mumbai, also known as the \"City of Dreams,\" is a busy metropolis that never ceases to enchant visitors with its vivid vitality. The city is a cultural melting pot where tradition and modernity coexist. Mumbai provides a broad range of experiences, from re', '2023-11-23', '397'),
(5, 'Take a trip to the Ravishing North India', 'Come on an exciting 7-day tour to three great Indian cities: Delhi, Jaipur, and Agra. Delhi, Indias capital, is known for its lost empire artefacts, vibrant markets, and mouthwatering cuisine. Visit the intriguing mediaeval city of Jaipur, the capital of ', '2023-11-03', '363'),
(6, 'Divine Do Dham Yatra 2023', 'Avail our Do Dham, Char Dham, Badrinath, Kedarnath Yatra via helicopter service and give your elderly family members a relief from completing the difficult journey all by road.', '2023-12-08', '389'),
(7, 'San Francisco Golden Gate Bridge, cable cars & fog.', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-09-30', '315'),
(8, 'Fantastic France', 'Home to the Mona Lisa, The Eiffel Tower, Red Wine and much more, France is a cultural haven! With its language being spoken across the world, learning French is popular amongst millions of people!', '2023-11-07', '386');

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

--
-- Table structure for table `pdf`
--

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

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `extra` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `register`
--

CREATE TABLE `register` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register`
--

INSERT INTO `register` (`id`, `name`, `password`, `phone`, `email`, `gender`, `dob`, `father_name`, `address`, `date`) VALUES
(8, 'Nick', '123456', '8910566319', 'nick@gmail.com', 'male', '2023-10-02', 'FGRTG', 'dfsfdfdfdf', '03/10/2023');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(2500) NOT NULL,
  `details` varchar(2550) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `name`, `image`, `details`, `date`) VALUES
(28, 'Provision of Travel Information', 'images/626istockphoto-1392494719-612x612.jpg', 'One of the primary functions of a retail travel agent from the point of view of the tourists or the general public is to provide necessary information about travel.', '30-09-2023'),
(29, 'Preparation of Itineraries', 'images/282young-people-together-planning-trip-europe-top-view-empty-white-space-notebook-where-you-time-plan-text-travel-concept_292052-1627.avif', 'Tourists itineraries are a composition of a series of operations that are a result of the study of the market. ', '30-09-2023'),
(30, 'Travel Facilitation', 'images/378images.jpg', 'Tourists need information about what is available at the destination in order to get the most from the leisure holiday or a business trip. ', '30-09-2023'),
(31, 'Tour planning and costing', 'images/54istockphoto-891573112-612x612.jpg', 'Once, the contracts and arrangements having been entered into, the next task is of planning and costing tours, both for inclusive programmes and to meet individual requirements.', '30-09-2023'),
(32, 'Accommodation', 'images/322istockphoto-1448506100-170667a.webp', 'Wide range of accommodation in the form of hotels and also supplementary accommodation catering to every budget and preference must be available with the travel agency.', '30-09-2023'),
(33, 'Communication', 'images/855depositphotos_295658090-stock-photo-partial-view-multiethnic-businesspeople-table.webp', 'Every tourist visiting a country, away from home would like to be in touch with people back home.', '30-09-2023');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `name`, `details`, `image`, `date`) VALUES
(99, 'Welcome to Touristica India', 'Where do you want to go? A new island? Country?', 'images/655845slider2.jpg', '18-09-2023'),
(100, 'Welcome to Touristica India', 'New destinations complete your soul.', 'images/19193slider3.jpg', '18-09-2023'),
(101, 'Welcome to Touristica India', 'Spreading smiles across the globe.', 'images/859139slider4.jpg', '18-09-2023'),
(102, 'Welcome to Touristica India', 'The travel agency that really cares.', 'images/428700slider5.jpg', '18-09-2023'),
(103, 'Welcome to Touristica India', 'Travel does not have to be expensive.', 'images/452734slider6.jpg', '18-09-2023');

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `name`, `email`, `phone`, `password`) VALUES
(3, 'kartik', 'abc@example.com', '86562', '123456'),
(4, 'sourav', 'sourav@gmail.com', '86562', '12345');

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `subcategory_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`id`, `category`, `subcategory_name`, `image`) VALUES
(3, 'Daily Needs', 'Chemists', 'category/medicine.png'),
(5, 'Dance', 'Bollywood Dance', 'category/karaoke.png');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `comment` mediumtext NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `student_name`, `image`, `comment`, `date`) VALUES
(20, 'A Karmakar', 'testimonial/png-clipart-computer-icons-user-profile-info-miscellaneous-face.png', 'I am very satisfied with Mobilewala, no one can repair like this. Just one hour and my phone repaired like new condition. I can not believe in my eyes.', '19/08/2023'),
(22, 'Arka Joti Paul', 'testimonial/imagest.jpg', 'Mobilewala actually saved my phone with half of price than the service centre and surprisingly they also give service warranty. Just wow!', '19/08/2023'),
(24, 'Mitul Bera', 'testimonial/imageskk.jpg', 'Very helpful customer service, all very happy members of staff! Told me the time my phone would be done and it was ready when I collected. ', '02-Sep-2023');

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

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

CREATE TABLE `tours` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `adult` varchar(255) NOT NULL,
  `child` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `tours` (`id`, `name`, `email`, `phone`, `adult`, `child`, `date`, `message`) VALUES
(1, 'Nick', 'nick@gmail.com', '8910566319', '3', '2', '2023-09-30', ''),
(2, 'Nick', 'nick@gmail.com', '8910566319', '3', '2', '2023-09-30', ''),
(3, 'Nick', 'nick@gmail.com', '8910566319', '3', '2', '2023-09-30', ''),
(4, 'Nick', 'nick@gmail.com', '8910566319', '3', '2', '2023-09-30', 'gertg');

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

--
-- Table structure for table `tour_plan`
--

CREATE TABLE `tour_plan` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `details` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `tid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tour_plan`
--

INSERT INTO `tour_plan` (`id`, `plan_name`, `package_name`, `details`, `date`, `tid`) VALUES
(7, 'Day1', 'San Francisco Golden Gate Bridge, cable cars & fog.', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-09-30', '315'),
(8, 'Day2', 'San Francisco Golden Gate Bridge, cable cars & fog.', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-09-30', '315'),
(9, 'Day3', 'San Francisco Golden Gate Bridge, cable cars & fog.', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-09-30', '315'),
(10, 'Day4', 'San Francisco Golden Gate Bridge, cable cars & fog.', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-09-30', '315'),
(11, 'Day1', 'Weekend in Spain', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-10-25', '197'),
(12, 'Day2', 'Weekend in Spain', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-10-25', '197'),
(13, 'Day3', 'Weekend in Spain', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-10-25', '197'),
(14, 'Day4', 'Weekend in Spain', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-10-25', '197'),
(15, 'Day1', 'Spectacular Greece 6Nights', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-02', '191'),
(16, 'Day2', 'Spectacular Greece 6Nights', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-02', '191'),
(17, 'Day3', 'Spectacular Greece 6Nights', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-02', '191'),
(18, 'Day4', 'Spectacular Greece 6Nights', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-02', '191'),
(19, 'Day1', 'Fantastic France', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-07', '386'),
(20, 'Day2', 'Fantastic France', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-07', '386'),
(21, 'Day3', 'Fantastic France', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-07', '386'),
(22, 'Day4', 'Fantastic France', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-07', '386'),
(23, 'Day1', 'Take off from Mumbai to Goa', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-23', '397'),
(24, 'Day2', 'Take off from Mumbai to Goa', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-23', '397'),
(25, 'Day3', 'Take off from Mumbai to Goa', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-23', '397'),
(26, 'Day4', 'Take off from Mumbai to Goa', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-23', '397'),
(27, 'Day1', 'Take a trip to the Ravishing North India', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-03', '363'),
(28, 'Day2', 'Take a trip to the Ravishing North India', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-03', '363'),
(29, 'Day3', 'Take a trip to the Ravishing North India', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-03', '363'),
(30, 'Day4', 'Take a trip to the Ravishing North India', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-11-03', '363'),
(31, 'Day1', 'Divine Do Dham Yatra 2023', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-12-08', '389'),
(32, 'Day2', 'Divine Do Dham Yatra 2023', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-12-08', '389'),
(33, 'Day3', 'Divine Do Dham Yatra 2023', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-12-08', '389'),
(34, 'Day4', 'Divine Do Dham Yatra 2023', 'Pellentesque accumsan magna in augue sagittis, non fringilla eros molestie. Sed feugiat mi nec ex vehicula, nec vestibulum orci semper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Donec tristique commodo fri', '2023-12-08', '389');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `fees_table`
--
ALTER TABLE `fees_table`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tour_plan`
--
ALTER TABLE `tour_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
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 */;