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

START TRANSACTION;



--
-- Database: `indiansc_deeshari_demo`
--

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `uname` varchar(20) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `utype` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `admin` (`id`, `uname`, `pass`, `utype`) VALUES
(1, 'admin', 'admin', 'master'),
(2, 'userEnd', '625fa0bfdb706073072b1d52884d47c6', 'author'),
(3, 'abc@gmail.com', '3eb2f1a06667bfb9daba7f7effa0284b', 'author'),
(4, 'abhi', '3eb2f1a06667bfb9daba7f7effa0284b', 'author');

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

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

CREATE TABLE `category` (
  `cat_id` bigint(155) NOT NULL,
  `type` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `catname` varchar(255) NOT NULL,
  `parent` int(11) NOT NULL DEFAULT 0,
  `content` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `category` (`cat_id`, `type`, `image`, `url`, `catname`, `parent`, `content`) VALUES
(15, '', '', 'india', 'India', 0, ''),
(16, '', '', 'international', 'International', 0, '');

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

--
-- Table structure for table `cmslinks`
--

CREATE TABLE `cmslinks` (
  `link_id` int(11) NOT NULL,
  `postdate` date NOT NULL,
  `token` varchar(155) NOT NULL,
  `post_type` varchar(155) NOT NULL,
  `parent` varchar(255) NOT NULL,
  `cat` varchar(255) NOT NULL,
  `subcat` varchar(255) NOT NULL,
  `url` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `pdf` varchar(255) NOT NULL,
  `heading` longtext NOT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `pagetitle` longtext NOT NULL,
  `keywords` longtext NOT NULL,
  `description` longtext NOT NULL,
  `template` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cmslinks`
--

INSERT INTO `cmslinks` (`link_id`, `postdate`, `token`, `post_type`, `parent`, `cat`, `subcat`, `url`, `image`, `pdf`, `heading`, `content`, `status`, `pagetitle`, `keywords`, `description`, `template`) VALUES
(29, '2023-02-21', '', 'page', '', '', '', 'about-us', 'about-us.jpg', '', 'About Us', '<p style=\"text-align: justify;\"><strong>Deeshari Tourist Hub Pvt. Ltd.</strong> is a Travel Specialist based in Kolkata in West Bengal, India. It established at 2011 by Mr. Amit Kumar Jana, a Travel Professional. With these 12 years ofexperience, Deeshari has proved itself a reliable and efficient travel company among its guests as well as B2b partners.</p>\r\n<p style=\"text-align: justify;\">In Deeshari, there is a team of experienced professionals to take care of all your travel requirements and assure to provide best quality of services. You can avail all the travel solutions under one roof.We have Pan India Network and also have a network of worldwide partners to provide best products and services to you at best rates available. With the past years field experiences, we learnt how toserve you best ways.</p>\r\n<p style=\"text-align: justify;\">&nbsp;</p>\r\n<p style=\"text-align: justify;\"><span style=\"font-size: large;\"><strong>We Arrange:</strong></span></p>\r\n<ul class=\"fonts\">\r\n<li style=\"text-align: justify;\">Rail Tickets (Tatkal &amp; General)</li>\r\n<li style=\"text-align: justify;\">Air Tickets (Domestic &amp; International)</li>\r\n<li style=\"text-align: justify;\">Domestic &amp; International Tour Packages</li>\r\n<li style=\"text-align: justify;\">Visa Assistance for all countries</li>\r\n<li style=\"text-align: justify;\">Travel Insurance</li>\r\n<li style=\"text-align: justify;\">Passport Assistance</li>\r\n</ul>', NULL, '', '', '', ''),
(30, '0000-00-00', '', 'page', '', '', '', 'index', '', '', 'Welcome to Deeshari Tourist Hub', '<p style=\"text-align: justify;\">Deeshari Tourist Hub Pvt. Ltd. is a Travel Specialist based in Kolkata in West Bengal, India. It established at 2011 by Mr. Amit Kumar Jana, a Travel Professional. With these 12 years of experience, Deeshari has proved itself a reliable and efficient travel company among its guests as well as B2b partners.</p>\r\n<p style=\"text-align: justify;\">In Deeshari, there is a team of experienced professionals to take care of all your travel requirements and assure to provide best quality of services. You can avail all the travel solutions under one roof. We have Pan India Network and also have a network of worldwide partners to provide best products and services to you at best rates available. With the past years field experiences, we learnt how to serve you best ways.</p>', NULL, 'Deeshari Tourist Hub', 'Deeshari Tourist Hub', 'Deeshari Tourist Hub', ''),
(32, '2022-12-15', '', 'page', '', '', '', 'image-gallery', '', '', 'Image Gallery', '', NULL, '', '', '', ''),
(33, '2022-12-15', '', 'page', '', '', '', 'contact-us', '', '', 'Contact Us', '<p><strong>Rail Tickets (Tatkal &amp; General):</strong> <br />&nbsp;+91 9836722953<br />+ 91 6291488251</p>\r\n<p><strong>Air Tickets (Domestic &amp; International):</strong> <br />+ 91 6291488251<br />&nbsp;+91 9836722953<br /><strong><br />Visa Assistance:</strong> <br />+91 6291494818 <br />+91 9836722941<br /><strong><br />Travel Insurance:</strong> +91 9836722953<strong><br />Passport Assistance:</strong> + 91 6291488251<strong><br />Domestic &amp; International Packages:</strong> +91-9330045615,&nbsp;9903253398<br /><strong>Email:&nbsp;</strong>tours@deesharitouristhub.com</p>', NULL, '', '', '', ''),
(73, '2022-12-27', '', 'page', '', '', '', 'india-tour', 'india-tour.png', '', 'India Tour', '<p><span><strong>Tour Package</strong></span></p>\r\n<div class=\"flex-1 overflow-hidden\">\r\n<div class=\"react-scroll-to-bottom--css-kjagn-79elbk h-full dark:bg-gray-800\">\r\n<div class=\"react-scroll-to-bottom--css-kjagn-1n7m0yu\">\r\n<div class=\"flex flex-col items-center text-sm dark:bg-gray-800\">\r\n<div class=\"w-full border-b border-black/10 dark:border-gray-900/50 text-gray-800 dark:text-gray-100 group bg-gray-50 dark:bg-[#444654]\">\r\n<div class=\"text-base gap-4 md:gap-6 m-auto md:max-w-2xl lg:max-w-2xl xl:max-w-3xl p-4 md:py-6 flex lg:px-0\">\r\n<div class=\"relative flex w-[calc(100%-50px)] flex-col gap-1 md:gap-3 lg:w-[calc(100%-115px)]\">\r\n<div class=\"flex flex-grow flex-col gap-3\">\r\n<div class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">\r\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\r\n<p>Tour packages are pre-planned itineraries that include transportation, accommodations, and activities for travelers who want to explore a new destination without the hassle of planning every detail themselves. In this article, we will discuss the benefits of tour packages, the different types of tours available, and what to consider when choosing a tour package.</p>\r\n<p><strong>Benefits of Tour Packages:</strong></p>\r\n<ol>\r\n<li>\r\n<p>Convenience: Tour packages are convenient for travelers because they eliminate the need to plan transportation, accommodations, and activities themselves.</p>\r\n</li>\r\n<li>\r\n<p>Cost-Effective: Tour packages can be cost-effective because they include bulk rates for transportation, accommodations, and activities, which can be more expensive if purchased separately.</p>\r\n</li>\r\n<li>\r\n<p>Expertise: Tour packages are usually organized by experienced tour operators who have extensive knowledge of the destination and can provide expert guidance and assistance throughout the trip.</p>\r\n</li>\r\n<li>\r\n<p>Safety: Tour packages offer added safety because they are usually organized by reputable tour operators who prioritize the safety and security of their travelers.</p>\r\n</li>\r\n</ol>\r\n<p><strong>Types of Tours:</strong></p>\r\n<ol>\r\n<li>\r\n<p>Group Tours: Group tours are pre-planned itineraries that are designed for a group of people to travel together. Group tours are usually more affordable because the cost is shared among the group.</p>\r\n</li>\r\n<li>\r\n<p>Private Tours: Private tours are customized itineraries that are designed for a single traveler or a small group of people. Private tours offer more flexibility and can be tailored to the traveler\'s specific needs and preferences.</p>\r\n</li>\r\n<li>\r\n<p>Adventure Tours: Adventure tours are designed for travelers who want to experience a destination through outdoor activities such as hiking, biking, or kayaking.</p>\r\n</li>\r\n<li>\r\n<p>Cultural Tours: Cultural tours are designed for travelers who want to experience a destination\'s culture through activities such as visiting historical landmarks, attending cultural events, or trying local cuisine.</p>\r\n</li>\r\n</ol></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p><span><strong>Rail Ticket (Tatkal &amp; General)</strong></span></p>\r\n<p>As a Rail Ticket Booking Service Agency, our primary focus is to provide a convenient and hassle-free booking experience to our customers. Our agency has tie-ups with Indian Railways, enabling us to offer real-time availability of trains and provide our customers with the best possible travel options.</p>\r\n<p><strong>Here are some of the key features of our Rail Ticket Booking Service:</strong></p>\r\n<ol>\r\n<li>\r\n<p>Wide Range of Options: Our agency offers a wide range of travel options, including different classes of travel, trains, and routes. We cater to the needs of all types of travelers, from those who prefer to travel in luxury to those who need to travel on a budget.</p>\r\n</li>\r\n<li>\r\n<p>Easy Booking Process: Our Rail Ticket Booking Service Agency provides a simple and easy-to-use interface that makes it easy for customers to search for trains, check availability, and book tickets with just a few clicks.</p>\r\n</li>\r\n<li>\r\n<p>Expert Guidance: We have a team of experts who are well-versed in the intricacies of train travel and can provide customers with expert guidance and advice on travel options, routes, and train schedules.</p>\r\n</li>\r\n<li>\r\n<p>Secure Transactions: Our website uses state-of-the-art technology to ensure that all transactions are safe and secure. We offer a variety of payment options, including debit cards, credit cards, net banking, and e-wallets, to make the booking process as convenient as possible for our customers.</p>\r\n</li>\r\n<li>\r\n<p>24/7 Customer Support: Our agency provides round-the-clock customer support to help customers with any queries or issues they may face while booking their rail tickets.</p>\r\n</li>\r\n</ol>\r\n<p>&nbsp;</p>\r\n<p><strong><span>Air Ticket</span></strong></p>\r\n<p>As an Air Ticket Booking Service Agency, our primary focus is to provide a seamless and hassle-free booking experience for our customers. Our agency has partnerships with major airlines, enabling us to offer a wide range of flight options and provide our customers with the best possible travel experience.</p>\r\n<p><strong>Here are some of the key features of our Air Ticket Booking Service:</strong></p>\r\n<ol>\r\n<li>\r\n<p>Wide Range of Options: Our agency offers a wide range of flight options, including different airlines, classes, and routes. We cater to the needs of all types of travelers, from those who prefer to travel in luxury to those who need to travel on a budget.</p>\r\n</li>\r\n<li>\r\n<p>Easy Booking Process: Our Air Ticket Booking Service Agency provides a simple and easy-to-use interface that makes it easy for customers to search for flights, check availability, and book tickets with just a few clicks.</p>\r\n</li>\r\n<li>\r\n<p>Expert Guidance: We have a team of experts who are well-versed in the intricacies of air travel and can provide customers with expert guidance and advice on travel options, routes, and flight schedules.</p>\r\n</li>\r\n</ol>\r\n<p>&nbsp;</p>\r\n<ul>\r\n</ul>', NULL, 'India Tour', 'India Tour', 'India Tour', ''),
(74, '0000-00-00', '', 'page', '', '', '', 'video-gallery', '', '', 'Video Gallery', '', NULL, '', '', '', ''),
(75, '2022-12-27', '', 'page', '', '', '', 'international-tour', 'international-tours.png', '', 'International Tour', '<p style=\"text-align: justify;\"><span><strong>Tour Package</strong></span></p>\r\n<p style=\"text-align: justify;\">We specialize in creating unforgettable travel experiences that take you around the world. Whether you\'re looking for a relaxing beach vacation, an adventurous hiking trip, or a cultural immersion in a new city, we\'ve got you covered.</p>\r\n<p style=\"text-align: justify;\">Our team of experienced travel experts carefully curates each package to ensure that you get the most out of your trip. We work with top-rated hotels, local guides, and transportation providers to ensure that you have a seamless and comfortable journey. From the moment you book your tour with us, you can relax and let us take care of the rest.</p>\r\n<p style=\"text-align: justify;\">Our international tour packages cover a wide range of destinations across the globe. Explore the vibrant cities of Europe, relax on the white sand beaches of the Caribbean, or trek through the stunning natural landscapes of Asia. We offer tours to all of the continents, so no matter where you\'re interested in visiting, we\'ve got a package that will suit your needs.</p>\r\n<p style=\"text-align: justify;\">Our tour packages are designed to provide you with a comprehensive experience of each destination. We include guided tours of top attractions, as well as opportunities to immerse yourself in the local culture through food, music, and art. We also provide free time for you to explore on your own and create your own memories.</p>\r\n<p style=\"text-align: justify;\">We understand that travel can be expensive, which is why we offer competitive pricing for our tour packages. We also provide flexible payment options, so you can pay for your trip in installments that work for you. Our goal is to make international travel accessible to everyone, regardless of their budget.</p>\r\n<p style=\"text-align: justify;\">If you\'re ready to embark on an unforgettable international adventure, browse our tour packages today and find the perfect trip for you. Our team is always available to answer any questions you may have and help you plan your dream vacation.</p>\r\n<p style=\"text-align: justify;\"><strong>We also provide&nbsp;</strong></p>\r\n<ul class=\"fonts\">\r\n<li style=\"text-align: justify;\">Air Ticket</li>\r\n<li style=\"text-align: justify;\">Visa &ndash; All Countries</li>\r\n<li style=\"text-align: justify;\">Passport Assistance</li>\r\n<li style=\"text-align: justify;\">Travel Insurance<br /><br /></li>\r\n</ul>', NULL, 'International Tour', 'International Tour', 'International Tour', ''),
(76, '2022-12-27', '', 'page', '', '', '', 'affiliation', '', '', 'Affiliation', '<p><span>Affiliation and certification are two important aspects of building a successful business. Affiliation refers to partnering with other companies or individuals to promote products or services, while certification validates a business\'s expertise and credentials in a particular industry.</span></p>', NULL, 'Affiliation', 'Affiliation', 'Affiliation', ''),
(77, '2022-12-27', '', 'page', '', '', '', 'packages', '', '', 'Packages', '<p>Packages</p>', NULL, '', '', '', ''),
(79, '0000-00-00', '684210', 'portfolio', '', '', '', 'andaman-tour', '5.jpeg', '', 'Andaman Tour', '', NULL, '', '', '', ''),
(81, '2023-04-08', '', 'place', '', '15', '', 'exotic-andaman', 'exotic-andaman.jpg', '', 'EXOTIC ANDAMAN', '<p>EX &ndash; PORT BLAIR</p>\r\n<p>4N / 5D</p>\r\n<p>PORT BLAIR 2N &ndash; HAVELOCK 2N &ndash; NEIL ISLAND 1N</p>\r\n<p>STARTING FROM @ RS 20,500/- PER PERSON</p>', NULL, '', '', '', ''),
(82, '2023-04-08', '', 'place', '', '15', '', 'enchanting-kerala', 'enchanting-kerala.jpg', '', 'ENCHANTING KERALA', '<p>EX &ndash; COCHIN / TRIVANDRAM</p>\r\n<p>7N / 8D</p>\r\n<p>COCHIN 1N &ndash; MUNNAR 2N &ndash; THEKKEDY 1N &ndash; ALLEPPY HOUSEBOAT 1N &ndash; KOVALAM 2N</p>\r\n<p>STARTING FROM @ RS 29,500/- PER PERSON</p>', NULL, '', '', '', ''),
(83, '2023-04-08', '', 'place', '', '15', '', 'glimpses-of-south', 'glimpses-of-south.jpg', '', 'GLIMPSES OF SOUTH', '<p>EX &ndash; BANGALORE</p>\r\n<p>6N / 7D</p>\r\n<p>MYSORE 1N &ndash; OOTY 2N &ndash; COORG 2N &ndash; BANGALORE 1N</p>\r\n<p>STARTING FROM @ RS 29,500/- PER PERSON</p>', NULL, '', '', '', ''),
(84, '2023-04-08', '', 'place', '', '15', '', 'unforgatable-kashmir', 'unforgatable-kashmir.jpg', '', 'UNFORGATABLE KASHMIR', '<p>EX &ndash; SRINAGAR</p>\r\n<p>7N / 8D</p>\r\n<p>SRINAGAR HOUSEBOAT 1N &ndash; SRINAGAR HOTEL 2N &ndash; GULMARG 1N &ndash; PAHALGAM 2N</p>\r\n<p>STARTING FROM @ RS 21,500/- PER PERSON</p>', NULL, '', '', '', ''),
(85, '2023-04-08', '', 'place', '', '15', '', 'peacefull-himachal', 'peacefull-himachal.jpg', '', 'PEACEFULL HIMACHAL', '<p>EX &ndash; DELHI</p>\r\n<p>6N / 7D</p>\r\n<p>SHIMLA 2N &ndash; MANALI 3N &ndash; CHANDIGARH 1N</p>\r\n<p>STARTING FROM @ RS 21,500/- PER PERSON</p>', NULL, '', '', '', ''),
(86, '2023-04-08', '', 'place', '', '16', '', 'thailand-tour-1', 'thailand-tour-1.jpg', '', 'THAILAND TOUR 1', '<p>EX &ndash; BANGKOK INT AIRPORT</p>\r\n<p>4N / 5D</p>\r\n<p>STARTING FROM @ RS 14,500/- PER PERSON</p>', NULL, '', '', '', ''),
(87, '2023-04-08', '', 'place', '', '16', '', 'thailand-tour-2', 'thailand-tour-2.jpg', '', 'THAILAND TOUR 2', '<p>EX &ndash; PHUKET INT AIRPORT</p>\r\n<p>4N / 5D</p>\r\n<p>STARTING FROM @ RS 18,500/- PER PERSON</p>', NULL, '', '', '', ''),
(88, '2023-04-08', '', 'place', '', '16', '', 'bali-tour', 'bali-tour.jpg', '', 'BALI TOUR ', '<p>EX &ndash; DENPASAR INT&nbsp;AIRPORT</p>\r\n<p>4N / 5D</p>\r\n<p>STARTING FROM @ RS 18,500/- PER PERSON</p>', NULL, '', '', '', ''),
(89, '2023-04-08', '', 'place', '', '16', '', 'dubai-tour', 'dubai-tour.jpg', '', 'DUBAI TOUR ', '<p>EX &ndash; DUBAI INT&nbsp;AIRPORT</p>\r\n<p>4N / 5D</p>\r\n<p>STARTING FROM @ RS 30,500/- PER PERSON</p>', NULL, '', '', '', ''),
(90, '2023-04-08', '', 'place', '', '16', '', 'singapore-tour', 'singapore-tour.jpg', '', 'SINGAPORE TOUR', '<p>EX &ndash; CHANGI INT AIRPORT</p>\r\n<p>4N / 5D</p>\r\n<p>STARTING FROM @ RS 25,000/- PER PERSON</p>', NULL, '', '', '', ''),
(91, '2023-04-08', '', 'place', '', '16', '', 'europe-tour', 'europe-tour.jpg', '', 'EUROPE TOUR', '<p>11N / 12D</p>\r\n<p>STARTING FROM @ RS 1,75,000/- PER PERSON</p>', NULL, '', '', '', '');

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

--
-- Table structure for table `moreimages`
--

CREATE TABLE `moreimages` (
  `id` bigint(155) NOT NULL,
  `title` varchar(300) NOT NULL,
  `image` varchar(300) NOT NULL,
  `parent_id` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `portfolio_img`
--

CREATE TABLE `portfolio_img` (
  `id` bigint(155) NOT NULL,
  `image` varchar(255) NOT NULL,
  `token` varchar(23) NOT NULL,
  `status` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `portfolio_img`
--

INSERT INTO `portfolio_img` (`id`, `image`, `token`, `status`) VALUES
(30, '1672151016instagram-1-83x83.jpg', '', ''),
(31, '1672151016instagram-2-83x83.jpg', '', ''),
(32, '1672151017instagram-3-83x83.jpg', '', ''),
(33, '16771445925.jpg', '', ''),
(34, '16771445926.jpg', '', ''),
(35, '16771446874.jpg', '', ''),
(36, '16771446875.jpg', '', ''),
(37, '16771447495.jpg', '', ''),
(38, '16771447717.jpg', '', ''),
(39, '16771589805.jpg', '', ''),
(40, '16771589806.jpg', '', ''),
(41, '16771593156.jpg', '393556', ''),
(42, '16771593157.jpg', '393556', ''),
(43, '16772364765.jpeg', '684210', ''),
(44, '16772364763.jpg', '684210', ''),
(45, '16772364762.jpg', '684210', ''),
(46, '16772364781.png', '684210', '');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `themecolor` varchar(255) NOT NULL DEFAULT '2a71e9',
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `contactus` longtext DEFAULT NULL,
  `welcom_txt` longtext DEFAULT NULL,
  `why` longtext DEFAULT NULL,
  `mission` longtext DEFAULT NULL,
  `ourvalue` longtext DEFAULT NULL,
  `latest_project` longtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `slider` (
  `id` bigint(155) NOT NULL,
  `type` int(2) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `targetlink` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `slider` (`id`, `type`, `image`, `title`, `detail`, `targetlink`) VALUES
(10, NULL, '1672144381kerala3.jpg', 'You will find innumerable holiday packages, but very few that match your requirement', '', ''),
(15, 1, '1677078896Banner_1.1.jpg', 'It\'s Time to Travel', '', ''),
(16, 1, '16770672541672149290pa4.jpg', 'Adventure awaits for you', '', ''),
(20, 1, '1677078630Banner_3.jpg', 'Travel to the Hill stations', '', ''),
(24, 1, '1677078454Banner_2.jpg', 'Honeymoon Tip for you', '', ''),
(28, 2, '1677237850IRCTC_Logo.jpg', '', '', '');

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE `tbl_gallery` (
  `id` bigint(20) NOT NULL,
  `imgurl` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `youtube`
--

CREATE TABLE `youtube` (
  `id` bigint(133) NOT NULL,
  `homepage` int(5) NOT NULL DEFAULT 0,
  `youtubecode` varchar(233) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `youtube`
--

INSERT INTO `youtube` (`id`, `homepage`, `youtubecode`) VALUES
(4, 0, 'iKPwDhMk2BI');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `cmslinks`
--
ALTER TABLE `cmslinks`
  ADD PRIMARY KEY (`link_id`);

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cat_id` bigint(155) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cmslinks`
--
ALTER TABLE `cmslinks`
  MODIFY `link_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- AUTO_INCREMENT for table `moreimages`
--
ALTER TABLE `moreimages`
  MODIFY `id` bigint(155) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portfolio_img`
--
ALTER TABLE `portfolio_img`
  MODIFY `id` bigint(155) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

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

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` bigint(155) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `youtube`
--
ALTER TABLE `youtube`
  MODIFY `id` bigint(133) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

