--
-- Host: localhost    Database: thejumar_thebd
-- ------------------------------------------------------


--
-- Current Database: `thejumar_thebd`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `thejumar_thebd` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `thejumar_thebd`;

--
-- Table structure for table `amenities_tbl`
--

CREATE TABLE `amenities_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(200) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amenities_tbl`
--

INSERT INTO `amenities_tbl` VALUES (2,'Private bathroom','amenities_18.png',1),(3,'Writing Desk & Chair','amenities_08.png',1),(4,'Parking','amenities_50.png',1),(5,'Gym','amenities_40.png',1),(6,'High Speed WiFi','amenities_29.png',1),(7,'Mountain & River View','amenities_22.png',1),(8,'Hot Cold Shower & Bathtub','amenities_46.png',1),(9,'Food Service','amenities_07.png',1),(10,'24 Hours Support','amenities_48.png',1);

--
-- Table structure for table `anniversary_tbl`
--

CREATE TABLE `anniversary_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(500) DEFAULT NULL,
  `gallery_order` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `anniversary_tbl`
--


--
-- Table structure for table `banner_tbl`
--

CREATE TABLE `banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `personName` varchar(80) NOT NULL DEFAULT '',
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `bannerImage` varchar(500) NOT NULL,
  `bannerCat` varchar(200) NOT NULL,
  `bannerSubcat` varchar(200) NOT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  `optimisation` varchar(1000) DEFAULT NULL,
  `tagline` varchar(250) DEFAULT NULL,
  `bannerText` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner_tbl`
--

INSERT INTO `banner_tbl` VALUES (1,'Welcome to The Jumar','','2022-08-21','Y','Welcome-to-The-Jumar48.jpg','','',NULL,NULL,NULL,'Art, Leisure, Romance, Culinary, and Wellness for those who are a blessing to your life.'),(2,'Luxury Hotel Suites','','2022-08-21','Y','Luxury-Hotel-Suites05.jpg','','',NULL,NULL,NULL,'Epitomize excellence in the craft of Hospitality. Time to split away from the ordinary.');

--
-- Table structure for table `birthday_tbl`
--

CREATE TABLE `birthday_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(500) DEFAULT NULL,
  `gallery_order` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `birthday_tbl`
--


--
-- Table structure for table `blog_tbl`
--

CREATE TABLE `blog_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) DEFAULT NULL,
  `blogDname` varchar(500) DEFAULT NULL,
  `blogDate` varchar(100) DEFAULT NULL,
  `blog_written` varchar(1000) DEFAULT NULL,
  `catDesc` text,
  `catDesc1` text,
  `catImage` varchar(1000) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` text,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `featureimage` varchar(1000) DEFAULT NULL,
  `banner1` varchar(250) DEFAULT NULL,
  `banner2` varchar(250) DEFAULT NULL,
  `banner3` varchar(250) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_tbl`
--


--
-- Table structure for table `brand_tbl`
--

CREATE TABLE `brand_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `brandName` varchar(200) NOT NULL DEFAULT '',
  `brandImage` varchar(200) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `brandTitle` text NOT NULL,
  `brandKeyword` text NOT NULL,
  `brandDesc` text NOT NULL,
  `brandHeading` text NOT NULL,
  `brandDetail` text NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand_tbl`
--


--
-- Table structure for table `category_tbl`
--

CREATE TABLE `category_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) DEFAULT NULL,
  `catIcon` varchar(200) DEFAULT NULL,
  `home_category` varchar(20) NOT NULL DEFAULT '0',
  `catDesc` text,
  `catDesc1` text,
  `catImage` varchar(500) DEFAULT NULL,
  `catBanner` varchar(500) DEFAULT NULL,
  `catVideo` varchar(250) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageDescription2` text,
  `pageKeywords1` text,
  `footerContent` text,
  `catalogImage` varchar(500) DEFAULT NULL,
  `catalogLink` varchar(600) DEFAULT NULL,
  `displayName` varchar(500) DEFAULT NULL,
  `faq_icon` varchar(500) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL,
  `bed` int(11) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `purpose` varchar(100) DEFAULT NULL,
  `ameniti_id` varchar(100) NOT NULL,
  `multi_image` text,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_tbl`
--

INSERT INTO `category_tbl` VALUES (3,'',NULL,0,'Rooms','','0','<p>It is common to refer to big, high-end establishments like The Jumar, and Luxury Rooms in Ranch<strong>i</strong>, as &quot;exceptional hotels,&quot; meaning that we have a dedicated staff, many amenities, and a high tag among all the Hotels in Ranchi.</p>\r\n','<p>It is common to refer to big, high-end establishments like The Jumar, and <strong>Luxury Rooms in Ranchi</strong>, as &quot;exceptional hotels,&quot; meaning that we have a dedicated staff, many amenities, and a high tag among all the Hotels in Ranchi.</p>\r\n\r\n<h2>Elegant Suites at 4 Star Hotels that provide Comfort&nbsp;</h2>\r\n\r\n<p>The Jumar has guard services, delectable food, several rooms and a Restaurant area, improved workout facilities, room service, parking facilities, and a selection of one-of-a-kind Family Suites.</p>\r\n\r\n<p>With the <strong>4 Star Luxury Rooms in Ranchi </strong>are tastefully appointed with luxury furniture and exquisite accents, such as plush bedding and high-quality bath amenities.</p>\r\n\r\n<h2>4 Star Hotel Rooms in Ranchi with Endless Possibilities</h2>\r\n\r\n<p>There are 46 opulent suites available at this Hotel plus Restaurant. From every room at The Jumar. With varieties of rooms to choose from, our <strong>Luxury Stay Rooms in Ranchi</strong> are quiet and relaxing, decorated in different colours.</p>\r\n\r\n<p>All rooms have LCD TVs, PlayStation, tea and coffee makers, bathtubs or shower cubicles, electronic safes, and 24-hour room service. Visit our <strong>King Rooms</strong> and <strong>Queen Rooms</strong> page to learn more about our spacious accommodation options.</p>\r\n\r\n<p>The high-end flats have all the most recent amenities. The also offers cottages with two bedrooms, complete with kitchens, living rooms, and private balconies perfect for taking in the sights and sounds of nature.</p>\r\n','','','','N',1,'Y','Affordable Hotel Rooms in Ranchi, Luxury Rooms for Family in Ranchi','Best Affordable Hotel Deluxe Rooms in Ranchi, Luxury Rooms for Couples in Ranchi, Luxury Hotels for Family in Ranchi, Best Affordable Hotel Deluxe Rooms in Ranchi','Looking for Affordable Hotel Rooms in Ranchi? Visit The Jumar and Book Luxury Rooms for Family in Ranchi at affordable prices. ✓Deluxe Rooms ✓Suites ✓24/7 Room Service. Book Now.',NULL,'','',NULL,'','','','Rooms','','',0,'','','',''),(4,'',NULL,3,'Single Rooms','','0','<p>The single rooms of our luxury hotel are ideal for individuals or couples. These rooms are equipped with all kinds of facilities to provide comfort. Our single rooms feature twin beds as well. Avail of single rooms from the best luxury hotel in Ranchi.</p>\r\n','<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n','Single-Rooms22.jpg','','','N',1,'Y','4 Star Single Rooms Hotel in Ranchi, Luxury Hotel Single Room in Ranchi','4 Star Single Rooms Hotel in Ranchi, Luxury Hotel Single Room in Ranchi, Single Room Hotel in Ranchi, Best Rooms in Ranchi','The Jumar Hotel offers 4 Star Single Rooms Hotel in Ranchi. Book Luxury Hotel Single Room in Ranchi for ✓Couples with ☆Recreation & Massage Facilities ☆Private Balcony etc. Visit Now!',NULL,'','',NULL,'','','','Single Rooms','','Ranchi',2,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg,Single-Rooms.jpg.'),(5,'',NULL,3,'Double Rooms','','0','<p>Our double rooms are well set with facilities like luxurious bath amenities and plush bedding. The aesthetic double rooms of our Hotel provide comfort and relaxation. You can even plan a romantic getaway in our spacious accommodation.</p>\r\n','','Double-Rooms32.jpg','','','N',2,'Y','4 Star Double Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Double Room in Ranchi','4 Star Double Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Double Room in Ranchi, Double room Hotels in Ranchi, Luxury Double Rooms in Ranchi','The Jumar Hotel offers 4 Star Double Rooms Hotel and Restaurant in Ranchi. Where you can Plan ✓Family Holidays ✓Honeymoon ✓Weekends ✓Parties at fair cost. ✓1000+Happy Visitors ✓Premium Facilities ✓Luxury Stay ☆Visit the Website Now!',NULL,'','',NULL,'','','','Double Rooms','','Ranchi',2,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg.'),(6,'',NULL,3,'Triple Rooms','','0','<p>Make your holidays memorable with our lavish and affordable triple rooms. These spacious rooms are perfect for a family of three people. The triple rooms of our Hotel include amenities like air conditioning, wifi, and 24-hour room service. Get triple rooms from the best luxury Hotel in Ranchi.</p>\r\n','','Triple-Rooms45.jpg','','','N',3,'Y','4 Star Triple Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Triple Room in Ranchi','4 Star Triple Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Triple Room in Ranchi, Triple Rooms in Ranchi, Luxury 4 Star Triple Rooms in Ranchi, Affordable Triple Rooms Set in Ranchi','The Jumar Hotel offers 4 Star Triple Rooms Hotel in Ranchi. Book Luxury Hotel and Restaurant Triple Room in Ranchi for ✓Friends Squid✓Family with ☆Premium Facility Visit Now!',NULL,'','',NULL,'','','','Triple Rooms','','Ranchi',3,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg'),(7,'',NULL,3,'Quad Rooms','','0','<p>Our quad rooms are comfortable and well-equipped with a variety of beds to accommodate four guests. These rooms are provided with twin beds and bunk beds to make room for a family with two kids. The quad rooms at our luxury hotel&nbsp;are designed beautifully with all the essential facilities to assure your stay is as pleasant as possible.</p>\r\n','','Quad-Rooms46.jpg','','','N',4,'Y','4 Star Quad Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Quad Room in Ranchi','4 Star Quad Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Quad Room in Ranchi, 4 Star Quad Rooms in Ranchi','The Jumar Hotel offers 4 Star Quad Rooms Hotel in Ranchi. Book Luxury Hotel and Restaurant Quad Room in Ranchi for ✓Friends Squid✓Family with ☆Premium Facility Visit Now!',NULL,'','',NULL,'','','','Quad Rooms','','Ranchi',2,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg'),(8,'',NULL,3,'Queen Rooms','','0','<p>The queen rooms of our hotel and restaurant are provided with queen-size beds to accommodate one or more guests. Our queen rooms are equipped with facilities to ensure that your stay is satisfying and memorable. Relax in our spacious luxury rooms including amenities like television, PlayStation, and many more.<br />\r\n&nbsp;</p>\r\n','','Queen-Rooms53.jpg','','','N',5,'Y','4 Star Queen Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Queen Room in Ranchi','4 Star Queen Rooms Hotel in Ranchi, Luxury Hotel and Restaurant Queen Room in Ranchi, Queen Rooms Booking in Ranchi, Best Luxury Queen Rooms in Ranchi','The Jumar Hotel offers 4 Star Queen Rooms Hotel in Ranchi. Book Luxury Hotel Queen Room in Ranchi for Your Luxury Stay with ☆Premium Facility ☆Warm Namaskar ☆Lobby View Visit Now!',NULL,'','',NULL,'','','','Queen Rooms','','Ranchi',1,'A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg'),(9,'',NULL,3,'King Rooms','','0','<p>Enjoy a relaxing time with your friends and family in the king rooms of our luxury hotel. These majestic 4-star king rooms are furnished with a dining area, sitting area, and a lavish bedroom. The king rooms are provided with luxurious furniture and exquisite decor to ensure a pleasurable stay.</p>\r\n','','King-Rooms08.jpg','','','N',6,'Y','4 Star King Rooms Hotel in Ranchi, Luxury Hotel and Restaurant King Room in Ranchi','4 Star King Rooms Hotel in Ranchi, Luxury Hotel and Restaurant King Room in Ranchi, King Rooms Hotels in Ranchi, Best Rooms Hotels in Ranchi','The Jumar Hotel offers 4 Star King Rooms Hotel and Restaurant in Ranchi. Book Luxury Hotel King Room in Ranchi for Your Honeymoon Stay with ✓1000+Happy Visitors ☆Premium Facility ☆Warm Namaskar ☆Lobby View',NULL,'','',NULL,'','','','King Rooms','','Ranchi',1,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg'),(10,'',NULL,3,'Family Suite','','0','<p>The extravagant rooms of our family suite are well-equipped with the latest amenities. The lavish suite of our hotel allows the family to relax and unwind. These accommodations are provided with elegant decor and furnishing to make your stay enjoyable and memorable. The family suites provide a home away from home experience.</p>\r\n','<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n','Family-Suite08.jpg','','','N',7,'Y','4 Star Family Suite in Ranchi, Luxury Family Suites in Ranchi','4 Star Family Suite in Ranchi, Luxury Family Suites in Ranchi, Family Suites in Ranchi','The Jumar Hotel offers a 4 Star Family Suite in Ranchi. Book Luxury Family Suites in Ranchi for Your Family Holiday with ✓1000+Happy Visitors ☆Premium Facility ☆Warm Namaskar ☆Mountains View Visit Now!',NULL,'','',NULL,'','','','Family Suite','','Ranchi',3,'Both A/C and Non A/C','Personal','','single-room1.jpg,single-room2.jpg,single-room3.jpg,single-room4.jpg,single-room5.jpg,single-room6.jpg,single-room7.jpg,single-room8.jpg.');

--
-- Table structure for table `catpro_tbl`
--

CREATE TABLE `catpro_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `catpro_tbl`
--


--
-- Table structure for table `catvideo_tbl`
--

CREATE TABLE `catvideo_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) NOT NULL,
  `product_code` varchar(700) NOT NULL,
  `product_image` text,
  `product_image1` varchar(500) DEFAULT NULL,
  `product_image2` varchar(500) DEFAULT NULL,
  `product_image3` varchar(500) DEFAULT NULL,
  `product_alt` varchar(500) NOT NULL,
  `product_desc` text NOT NULL,
  `product_metatitle` varchar(300) NOT NULL,
  `product_metadesc` varchar(800) NOT NULL,
  `product_metakeyword` varchar(800) NOT NULL,
  `product_cat` varchar(400) NOT NULL,
  `prodcut_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `product_date` varchar(400) NOT NULL,
  `prodcut_status` int(11) NOT NULL DEFAULT '0',
  `product_finalcat` varchar(600) NOT NULL,
  `product_min_order` varchar(400) NOT NULL,
  `product_supply` varchar(600) NOT NULL,
  `product_origin` varchar(600) NOT NULL,
  `product_pterms` varchar(600) NOT NULL,
  `product_price` varchar(600) NOT NULL,
  `product_swearType` varchar(100) NOT NULL,
  `product_supplyType` varchar(100) NOT NULL,
  `product_Gender` varchar(100) NOT NULL,
  `product_ageGroup` varchar(100) NOT NULL,
  `product_size` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `catvideo_tbl`
--


--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `cityID` int(5) NOT NULL AUTO_INCREMENT,
  `parentID` int(5) NOT NULL,
  `cityName` varchar(70) NOT NULL,
  `cityURL` varchar(70) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'Y',
  `hotstatus` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`cityID`),
  KEY `parentID` (`parentID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `city`
--


--
-- Table structure for table `client_tbl`
--

CREATE TABLE `client_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `logo_image` varchar(800) NOT NULL,
  `client_order` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_tbl`
--


--
-- Table structure for table `clinic_location_tbl`
--

CREATE TABLE `clinic_location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `parentID` varchar(30) DEFAULT NULL,
  `locationName` varchar(800) NOT NULL DEFAULT '',
  `locationtDesc` text NOT NULL,
  `locationImage` varchar(50) NOT NULL DEFAULT '',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) NOT NULL,
  `locationBanner` text,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clinic_location_tbl`
--


--
-- Table structure for table `colaboration_tbl`
--

CREATE TABLE `colaboration_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL,
  `mobile` varchar(300) DEFAULT NULL,
  `location` varchar(400) DEFAULT NULL,
  `qualification` varchar(400) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `specialisation` varchar(500) DEFAULT NULL,
  `address` text,
  `cv_file` text,
  `ip` varchar(300) DEFAULT NULL,
  `url` varchar(500) DEFAULT NULL,
  `enquiry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `colaboration_tbl`
--


--
-- Table structure for table `collar_tbl`
--

CREATE TABLE `collar_tbl` (
  `collar_id` int(11) NOT NULL AUTO_INCREMENT,
  `collar_name` varchar(600) NOT NULL,
  `collar_image` varchar(600) NOT NULL,
  PRIMARY KEY (`collar_id`),
  UNIQUE KEY `collar_id` (`collar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collar_tbl`
--


--
-- Table structure for table `corporate_tbl`
--

CREATE TABLE `corporate_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(500) DEFAULT NULL,
  `gallery_order` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `corporate_tbl`
--


--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `slno` int(6) NOT NULL AUTO_INCREMENT,
  `cont_code` varchar(2) DEFAULT NULL,
  `cont_name` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country`
--


--
-- Table structure for table `country_tbl`
--

CREATE TABLE `country_tbl` (
  `slno` int(6) NOT NULL AUTO_INCREMENT,
  `countryCode` varchar(2) DEFAULT NULL,
  `countryName` varchar(40) DEFAULT NULL,
  `countryFlag` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country_tbl`
--


--
-- Table structure for table `coupon_tbl`
--

CREATE TABLE `coupon_tbl` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_title` varchar(1000) NOT NULL DEFAULT '',
  `coupon_desc` varchar(1000) NOT NULL DEFAULT '',
  `coupon_date` date NOT NULL DEFAULT '0000-00-00',
  `coupon_status` char(1) NOT NULL DEFAULT 'N',
  `coupon_cat` varchar(100) NOT NULL,
  `coupon_subcat` varchar(100) NOT NULL,
  `coupon_type` varchar(100) NOT NULL,
  `coupon_link` varchar(600) NOT NULL,
  `coupon_exdate` date NOT NULL,
  `coupon_brand` varchar(100) NOT NULL,
  `coupon_code` varchar(500) NOT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coupon_tbl`
--


--
-- Table structure for table `faq_tbl`
--

CREATE TABLE `faq_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` longtext NOT NULL,
  `recvDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faqOrder` int(11) NOT NULL DEFAULT '0',
  `status` varchar(30) NOT NULL DEFAULT '1',
  `category_id` varchar(30) DEFAULT '0',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq_tbl`
--


--
-- Table structure for table `gal_tbl`
--

CREATE TABLE `gal_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gal_tbl`
--


--
-- Table structure for table `gallery_tbl`
--

CREATE TABLE `gallery_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery_tbl`
--

INSERT INTO `gallery_tbl` VALUES (17,'image1','gallery_11.jpg','image1','image1','1'),(18,'image2','gallery_32.jpg','image2','image2','2'),(19,'image3','gallery_13.jpg','image3','image3','3'),(20,'image4','gallery_24.jpg','image4','image4','4'),(21,'image5','gallery_57.jpg','image5','image5','5'),(22,'image6','gallery_51.jpg','image6','image6','6'),(25,'image9','gallery_41.jpg','image9','image9','9'),(26,'image10','gallery_53.jpg','image10','image10','10'),(27,'image11','gallery_08.jpg','image11','image11','10'),(30,'image14','gallery_06.jpg','image14','image14','10'),(31,'image15','gallery_18.jpg','image15','image15','10'),(32,'image16','gallery_33.jpg','image16','image16','10');

--
-- Table structure for table `homepage_pointer`
--

CREATE TABLE `homepage_pointer` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `web_type` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0= Hide factsheet, 1 = show Factsheet',
  `title1` varchar(255) DEFAULT NULL,
  `description1` varchar(500) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `description2` varchar(500) DEFAULT NULL,
  `title3` varchar(255) DEFAULT NULL,
  `description3` varchar(500) DEFAULT NULL,
  `title4` varchar(255) DEFAULT NULL,
  `description4` varchar(500) DEFAULT NULL,
  `title5` varchar(255) DEFAULT NULL,
  `description5` varchar(500) DEFAULT NULL,
  `title6` varchar(255) DEFAULT NULL,
  `description6` varchar(500) DEFAULT NULL,
  `title7` varchar(255) DEFAULT NULL,
  `description7` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `homepage_pointer`
--


--
-- Table structure for table `hotproduct_pages`
--

CREATE TABLE `hotproduct_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `hotKeyword1` varchar(500) NOT NULL,
  `hotKeyword2` varchar(500) NOT NULL,
  `hotKeyword3` varchar(500) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotproduct_pages`
--


--
-- Table structure for table `location_content_tbl`
--

CREATE TABLE `location_content_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(20) DEFAULT NULL,
  `category_id` varchar(20) DEFAULT NULL,
  `meta_title` varchar(300) DEFAULT NULL,
  `meta_description` text,
  `meta_keyword` text,
  `description` text,
  `short_description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `location_content_tbl`
--


--
-- Table structure for table `location_tbl`
--

CREATE TABLE `location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `locationType` varchar(11) DEFAULT NULL,
  `locationurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `locationName` varchar(800) DEFAULT NULL,
  `locationtDesc` text,
  `locationDesc1` text,
  `locationImage` varchar(50) DEFAULT NULL,
  `toplocation` char(1) NOT NULL DEFAULT 'N',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location_tbl`
--


--
-- Table structure for table `logfile`
--

CREATE TABLE `logfile` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `newsletter` text NOT NULL,
  `subject` text NOT NULL,
  `newsletterOther` text NOT NULL,
  `subjectOther` text NOT NULL,
  `flash_banner` varchar(50) NOT NULL DEFAULT '',
  `shippingPrice` float NOT NULL DEFAULT '0',
  `vat` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logfile`
--


--
-- Table structure for table `mailer_list`
--

CREATE TABLE `mailer_list` (
  `mailer_id` int(10) NOT NULL AUTO_INCREMENT,
  `mailer_title` varchar(200) NOT NULL,
  `mailer_reply` varchar(200) NOT NULL,
  `mailer_code` text NOT NULL,
  `message` varchar(500) NOT NULL,
  `country` varchar(100) NOT NULL,
  `memberType` varchar(10) NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `databasestatus` varchar(10) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mailer_list`
--


--
-- Table structure for table `mass_mail`
--

CREATE TABLE `mass_mail` (
  `mailID` int(20) NOT NULL AUTO_INCREMENT,
  `mailerID` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `companyName` varchar(150) NOT NULL,
  `memberName` varchar(150) NOT NULL,
  `memberID` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mass_mail`
--


--
-- Table structure for table `media_tbl`
--

CREATE TABLE `media_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `media_tbl`
--


--
-- Table structure for table `newsletter_member`
--

CREATE TABLE `newsletter_member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `snewsletter` char(1) NOT NULL DEFAULT 'N',
  `cnewsletter` char(1) NOT NULL DEFAULT 'N',
  `mType` char(1) NOT NULL DEFAULT 'B',
  `join_date` date NOT NULL DEFAULT '0000-00-00',
  `status` char(2) NOT NULL DEFAULT 'Y',
  `mail_status` char(2) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter_member`
--


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

CREATE TABLE `packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` int(250) NOT NULL,
  `start_date` varchar(100) NOT NULL,
  `expired_date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `party_tbl`
--

CREATE TABLE `party_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(500) DEFAULT NULL,
  `gallery_order` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `party_tbl`
--


--
-- Table structure for table `procategory_tbl`
--

CREATE TABLE `procategory_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `procategory_tbl`
--


--
-- Table structure for table `product_tbl`
--

CREATE TABLE `product_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_code` varchar(700) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_image1` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image2` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image3` varchar(500) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `product_alt` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_metatitle` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metadesc` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metakeyword` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_cat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prodcut_subcat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_subsubcat` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_specfi` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_video` varchar(150) DEFAULT NULL,
  `product_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_status` int(11) NOT NULL DEFAULT '1',
  `product_finalcat` varchar(600) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_min_order` varchar(400) DEFAULT NULL,
  `product_supply` varchar(600) DEFAULT NULL,
  `product_origin` varchar(600) DEFAULT NULL,
  `product_pterms` varchar(600) DEFAULT NULL,
  `product_price` varchar(600) DEFAULT NULL,
  `product_swearType` varchar(100) DEFAULT NULL,
  `product_supplyType` varchar(100) DEFAULT NULL,
  `product_Gender` varchar(100) DEFAULT NULL,
  `product_ageGroup` varchar(100) DEFAULT NULL,
  `product_size` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_tbl`
--


--
-- Table structure for table `productgallery_tbl`
--

CREATE TABLE `productgallery_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) NOT NULL,
  `product_code` varchar(700) NOT NULL,
  `product_image` varchar(500) NOT NULL,
  `product_alt` varchar(500) NOT NULL,
  `product_desc` text NOT NULL,
  `product_metatitle` varchar(300) NOT NULL,
  `product_metadesc` varchar(800) NOT NULL,
  `product_metakeyword` varchar(800) NOT NULL,
  `product_cat` varchar(400) NOT NULL,
  `prodcut_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `product_date` varchar(400) NOT NULL,
  `prodcut_status` int(11) NOT NULL DEFAULT '0',
  `product_finalcat` varchar(600) NOT NULL,
  `product_min_order` varchar(400) NOT NULL,
  `product_supply` varchar(600) NOT NULL,
  `product_origin` varchar(600) NOT NULL,
  `product_pterms` varchar(600) NOT NULL,
  `product_price` varchar(600) NOT NULL,
  `product_swearType` varchar(100) NOT NULL,
  `product_supplyType` varchar(100) NOT NULL,
  `product_Gender` varchar(100) NOT NULL,
  `product_ageGroup` varchar(100) NOT NULL,
  `product_size` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productgallery_tbl`
--


--
-- Table structure for table `safe_business_tbl`
--

CREATE TABLE `safe_business_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `designation` varchar(1000) DEFAULT NULL,
  `description` longtext NOT NULL,
  `sbtOrder` int(11) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `safe_business_tbl`
--


--
-- Table structure for table `slink_tbl`
--

CREATE TABLE `slink_tbl` (
  `slink_id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_icon` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  PRIMARY KEY (`slink_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slink_tbl`
--


--
-- Table structure for table `sponsor_banner_tbl`
--

CREATE TABLE `sponsor_banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL DEFAULT '0',
  `bannerPosition` varchar(50) NOT NULL,
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `bannerImage` varchar(50) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_banner_tbl`
--


--
-- Table structure for table `sponsor_tbl`
--

CREATE TABLE `sponsor_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL,
  `sponsoredCategories` varchar(250) NOT NULL,
  `sponsorDuration` int(11) NOT NULL,
  `sponsorStatus` char(1) NOT NULL DEFAULT 'N',
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `recvDate` date NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_tbl`
--


--
-- Table structure for table `standard_meta_tags_pages`
--

CREATE TABLE `standard_meta_tags_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard_meta_tags_pages`
--


--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `pageID` int(11) NOT NULL AUTO_INCREMENT,
  `pageBanner` varchar(500) DEFAULT NULL,
  `pageImage` varchar(500) DEFAULT NULL,
  `pageTitle` varchar(255) NOT NULL DEFAULT '',
  `page_url` varchar(200) DEFAULT NULL,
  `pageDesc` text NOT NULL,
  `pageDesc1` longtext NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `page_metatitle` varchar(500) NOT NULL,
  `page_keyword` varchar(500) NOT NULL,
  `page_metadesc` text NOT NULL,
  PRIMARY KEY (`pageID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` VALUES (1,'banner28.jpg','image35.jpg','Home',NULL,'<h1>Best Hotel in Ranchi</h1>\r\n\r\n<p>Ranchi is a highly travelled tourist destination that is gorgeous and tranquil. The Jumar is a <strong>Luxury Hotel in Ranchi </strong>that welcomes both local and foreign guests.&nbsp;</p>\r\n\r\n<p>The ideal location for <strong>Wedding Venues</strong> and <strong>Event Venues</strong>.</p>\r\n\r\n<p>Ranchi is the most popular destination in Jharkhand. And, despite being promoted, the shine and grace remain.</p>\r\n\r\n<h2>The Ultimate Luxury Hotels and Restaurants Nestled in Nature</h2>\r\n\r\n<p>Ranchi, the state capital of Jharkhand, is a beautiful city well-known for its attractive environment and abundance of waterfalls. Situated in the lap of nature, one of the best<strong> 4 Star Premium Hotels in Ranchi</strong> draws many visitors from far and wide due to the city&#39;s scenic landscapes and thriving economy.</p>\r\n\r\n<p>Here you can taste the finer things in life while taking in the breathtaking scenery.&nbsp;</p>\r\n\r\n<h2>Luxury Accommodations for Relaxing Views</h2>\r\n\r\n<p>The distant Johna Falls, Dassam Falls, Pahadi Mandir, and Birsa Zoological Park are travelled from here. Among the <strong>Premium Hotels in Ranchi</strong>, The Jumar is the best in Jharkhand and is situated in a gorgeous, peaceful area.</p>\r\n\r\n<p>Located in the heart of Ranchi, our hotel is surrounded by beautiful scenery, including hills and rushing waterfalls. A haven of splendour and relaxation in the middle of breathtaking scenery, where time can be taken just to relax, refresh, and enjoy one&#39;s surroundings.&nbsp;</p>\r\n\r\n<p>Avoid unnecessary travel and book a stay in our ideal <strong>Family Suite </strong>to create lifelong memories together.</p>\r\n','','Y','Luxury Hotel in Ranchi,  Premium Hotels in Ranchi','Luxury Hotel in Ranchi,  Premium Hotels in Ranchi','The Jumar Hotel is a Luxury Hotel in Ranchi that brings togetherness for Your Love! with Luxurious ☆Destination Wedding ☆Events ☆Premium Hotels in Ranchi. Visit Now!'),(2,NULL,'','About us',NULL,'<h1>Best Luxury Suites in Ranchi</h1>\r\n\r\n<p>Ranchi&#39;s spectacular waterfalls, lush hills, and wooded areas provide great picture opportunities and outdoor excursions. One of the <strong>Best Luxury Suites in Ranchi</strong>, The Jumar is located in Booti More at the Chotanagpur Valley at an elevation of 2,140 feet.&nbsp;</p>\r\n\r\n<p>Some of India&#39;s most beautiful urban settings can be found in Ranchi, the summer capital of Jharkhand. The Jumar in Booty More situated in the city of waterfalls is a picturesque city brimming with historical and cultural attractions, such as the enormous Rock Gardens and the literary refuge of Rabindranath Tagore on Tagore Hill.</p>\r\n\r\n<p>You can relax in the greatest luxury rooms while taking in the stunning scenery and do nothing at all if that&#39;s what you like.</p>\r\n\r\n<h2>Where Exceptional Style and Passion Meet</h2>\r\n\r\n<p>As you take in the untamed beauty of the outdoors, we will ensure your every need is met with the finest luxury suites and delectable dining meals. We want to provide you with <strong>Private Balcony Hotels &amp; Restaurants in Ranchi </strong>that successfully &quot;combines hospitality with the natural environment.&quot; The friendly staff at The Jumar will give you a warm Namaskar as you enter the hotel&#39;s vast lobby.</p>\r\n\r\n<p>The greatest luxury suites in town can be found at The Jumar, where the decor is purposefully subdued. There are different rooms available in a variety of configurations King and <strong>Queen Rooms</strong>, Single, Double, Triple, and <strong>Quad Rooms</strong>, as well as Family Suites, and they are all quiet and relaxing, decorated in soothing shades of colours.</p>\r\n\r\n<h2>What separates us from other 4 Star Premium Hotels in Ranchi</h2>\r\n\r\n<p>Guests can enjoy 24-hour room service, an LCD TV, a PlayStation, a tea/coffee maker, a beautiful and tidy washroom or a shower stall, an electronic safe, and more. All modern conveniences can be found in the <strong>Best Luxury Stay Hotels in Ranchi</strong>.</p>\r\n\r\n<p>For anyone travelling to Ranchi for business or leisure, our hotel is a top choice among the many excellent options available. Guests may bask in the winter sun while drinking coffee in one of the top luxury suites and restaurant spaces.</p>\r\n\r\n<p>Let your kids run in the play area&#39;s top luxury suites and on the playgrounds of its many exciting attractions. You might even surprise your significant other with a candlelight dinner for two in our Restaurant area.</p>\r\n','<p>Ranchi&#39;s spectacular waterfalls, lush hills, and wooded areas provide for great picture opportunities and outdoor excursions. Our one of the Best Luxury Suites in Ranchi, The Jumar located in the Chotanagpur Valley at an elevation of 2,140 feet.</p>\r\n','Y','Top 10 Party Banquet Halls in Booti, Ranchi','Top 10 Party Banquet Halls in Ranchi, Largest Event Venue in Ranchi, Top 10 Party Banquet Halls in Ranchi, Party Hall in Ranchi','The Jumar, Ranchi - Popular Top 10 Party Banquet Halls in Ranchi, Plan your Big Events in the Largest Event in Ranchi. Offers ✓Rooms ✓Event Venue ✓. Book now'),(4,NULL,NULL,'Event Venue',NULL,'<p>Ranchi, Jharkhand&#39;s capital and a dream destination for many, is where the majority of visitors and tourists begin their journey. Visitors, as well as residents, are all charmed and enamoured with the quirky nightlife of the<strong> Best Event Venue in Ranchi </strong>due to the city&#39;s many venues.</p>\r\n\r\n<h2>The Most Sought-After Luxurious Event Venues in Ranchi</h2>\r\n\r\n<p>At Ranchi, The Jumar offers everything from Event Venues to <strong>Birthday Venues</strong>, Wedding to <strong>Anniversary Celebration Venues</strong>. And being the top <strong>Event Party Venue in Ranchi</strong>, we provide you with a full list of all these happening in popular The Jumar Hotel in Ranchi.&nbsp;</p>\r\n\r\n<h2>Prominent Plans &amp; Events Venue in Ranchi&nbsp;</h2>\r\n\r\n<p>Are you spending an excessive amount of time and effort locating the ideal site for any party with the most alluring Event Venues? We have a group of individuals that work day and night to make your event experience the most exciting and unforgettable ever. All of your research has led you to the professionals in planning and coordinating the most exciting <strong>Event Packages in Ranchi</strong>.</p>\r\n','<p>Ranchi, Jharkhand&#39;s capital and a dream destination for many, is where the majority of visitors and tourists begin their journey. Visitors, as well as residents, are all charmed and enamoured with the quirky nightlife of the<strong> </strong>Best Event Venue in Ranchi<strong> </strong>due to the city&#39;s many venues.</p>\r\n','Y','Event Venue in Ranchi, Top Event Venues - Banquets, Hotel in Ranchi','Best Event Venue in Ranchi, Luxury Event Venues in Ranchi, Affordable Luxury Event Venue in Ranchi, Event Venues in Ranchi, Largest Marriage Venues/Banquets/Hotel in Ranchi','Book Event Venue in Ranchi - The Jumar. Find the Largest Marriage Venues Banquets, Hotels in Ranchi. ✓Affordable Event Halls ✓Air Conditioned. Book Now.'),(10,NULL,'image02.jpg','Birthday Venue',NULL,'<p>At Ranchi, The Jumar understands your want to relax, enjoy, and have fun when celebrating or attending a birthday celebration. Therefore, we provide a thorough and detailed list of <strong>Birthday Party Places in Ranchi</strong>.</p>\r\n\r\n<h2>Top Rated Birthday Party Place in Ranchi&nbsp;</h2>\r\n\r\n<p>The assistance of our venue specialists, who are highly qualified hospitality professionals, is available. Then, using our information, <strong>Birthday Party Venues in Ranchi</strong> will generate a very subjective and customized list of suggestions that is unique to you.</p>\r\n\r\n<h2>Luxurious Birthday Event Venues in Ranchi&nbsp;</h2>\r\n\r\n<p>Organizing a birthday party is one of the most fun and challenging jobs a person can do. Therefore, do not worry; just contact The Jumar to help you with planning an event. Connect with our venue specialists for effortless screening, browsing, and selection of the right <strong>Birthday Event in Ranchi</strong>.</p>\r\n','<p>At Ranchi, The Jumar understands your want to relax, enjoy, and have fun when celebrating or attending a birthday celebration. Therefore, we provide a thorough and detailed list of Birthday Party Places in Ranchi.</p>\r\n','Y','Birthday Venue in Ranchi, Birthday Party Places in Ranchi    ','Best Birthday Venues in Ranchi, Birthday Party Places in Ranchi, Luxury Birthday Venues in Ranchi, Affordable Luxury Birthday Venues in Ranchi, Birthday Venues in Ranchi, Largest Marriage Venues/Banquets/Hotel in Ranchi    ','Book Birthday Venues in Ranchi - The Jumar. Find the Largest Birthday Party Places and Hotels in Ranchi. ✓Affordable Birthday Halls ✓Air Conditioned. Book Now.'),(5,'','image51.jpg','Corporate Meetings',NULL,'<p>This an ideal opportunity for superiors and employees to break out of their workplace mindset and communicate in a pleasant tone at The Jumar. The less formal atmosphere of the <strong>Corporate Event Venues in Ranchi </strong>aids in breaking the ice.</p>\r\n\r\n<h2>The Most Well-known Corporate Events Venues in Ranchi&nbsp;</h2>\r\n\r\n<p>Each employee is treated with care and made to feel valued by the organization. These<strong> Corporate Venue Conferences in Ranchi</strong> provide amusing activities and games to relieve tension and make everyone feel comfortable in their own environment.&nbsp;</p>\r\n\r\n<h2>Leading Corporate Meetings Events in Ranchi&nbsp;</h2>\r\n\r\n<p>Corporate parties are also excellent for maintaining and forming new working relationships with employees and other businesses, as well as for launching new initiatives. If you are a resident of the capital of Jharkhand and would want to plan a fantastic workplace event, you&#39;ve come to the correct place. If you are looking for a decent place for <strong>Corporate Meetings in Ranchi</strong>, you should visit The Jumar.&nbsp;</p>\r\n','<p>This an ideal opportunity for superiors and employees to break out of their workplace mindset and communicate in a pleasant tone at The Jumar. The less formal atmosphere of the Corporate Event Venues in Ranchi<strong> </strong>aids in breaking the ice.</p>\r\n','Y','Best Corporate Meetings Venue in Ranchi, Company Meetings Venue in Ranchi','Book Corporate Meetings Venues in Ranchi, Book Corporate Meetings Venues in Ranchi, Best Corporate Meetings Destinations in Ranchi, Corporate Meetings Places / Venues in Ranchi, Corporate Meetings Places / Venues in Ranchi   ','Book Best Corporate Meetings Venues in Ranchi- The Jumar Ranchi. Find the Best Company Meetings Venue in Ranchi. ✓Easy Booking Venue ✓Affordable Price. Book now.'),(6,NULL,'image06.jpg','Wedding Venue','','<p>Do you want to celebrate wedding ceremonies such as engagement, Mehendi, Haldi, Roka, etc.? The Jumar is the one-stop destination you can reach out to for the best <strong>Wedding Venues in Ranchi</strong>.</p>\r\n\r\n<h2>Major Wedding Venues Event in Ranchi&nbsp;</h2>\r\n\r\n<p>If you are looking for a venue that fits your budget and is comfortable to commute to. The Jumar is the most appropriate spot for <strong>Wedding Party Venue in Ranchi</strong>. It is crucial that the wedding venues we ultimately book answer all of our questions and meet all of our needs.</p>\r\n\r\n<h2>Topmost Wedding Venues and Halls in Ranchi&nbsp;</h2>\r\n\r\n<p>This is when The Jumar enters the scene. Our venue specialists will carefully consider your questions and provide choices based on your chosen location, your budget, and the number of people you intend to invite. Here is information on the most amazing <strong>Wedding Events in Ranchi</strong>.</p>\r\n','<p>Do you want to celebrate wedding ceremonies such as engagement, Mehendi, Haldi, Roka, etc.? The Jumar is the one-stop destination you can reach out to for the best Wedding Venues in Ranchi.</p>\r\n','Y','Wedding Venue in Ranchi, Largest Marriage Venues - Banquets, Hotel in Ranchi    ','Best Wedding Venue in Ranchi, Luxury Wedding Venues in Ranchi,Affordable Luxury Wedding Venue in Ranchi, Wedding Venue in Ranchi, Largest Marriage Venue/Banquets/Hotels in Ranchi   ','Book Wedding Venue in Ranchi - The Jumar. Find the Largest Marriage Venues Banquets, Hotel in Ranchi. ✓Affordable Wedding Halls ✓Air Conditioned. Book Now.'),(7,NULL,'image50.jpg','Anniversary Celebration Venue','','<p>Are you in search of anniversary party locations in Ranchi? Consult The Jumar for the top <strong>Wedding/Anniversary Celebration Venues in Ranchi</strong>.</p>\r\n\r\n<h2>Lively Functions at the top Anniversary Celebration Venues in Ranchi&nbsp;</h2>\r\n\r\n<p>The Jumar is one of the best banquet halls/party halls for birthday anniversaries, wedding anniversaries such as 25th wedding anniversaries and 50th wedding anniversaries, etc. It does not matter what anniversary you are celebrating, so long as you are willing to do it at the premier <strong>Anniversary Event Venue in Ranchi</strong>.</p>\r\n\r\n<h2>Celebrate your Joy at the Top Anniversary Venues in Ranchi</h2>\r\n\r\n<p>All you have to do is choose a place and reserve it for a reasonable fee with unlimited food and beverages for three hours. In Ranchi, there is a party ideal for anniversaries. To reserve the <strong>Anniversary Celebration Venues in Ranchi</strong>, just contact The Jumar as soon as possible.</p>\r\n','<p>Are you in search of anniversary party locations in Ranchi? Consult The Jumar for the top Wedding/Anniversary Celebration Venues in Ranchi.</p>\r\n','Y','Venue for Anniversary Celebrations in Ranchi, Banquet Halls for Anniversary Celebrations in Ranchi     ','Book Venue for Anniversary Celebrations in Ranchi, Book Venue for Anniversary Celebrations in Ranchi, Best Banquet Halls for Anniversary Celebrations in Ranchi, Best Banquet Halls for Anniversary Celebrations in Ranchi ','Book Venue for Anniversary Celebrations in Ranchi - The Jumar. Find the Best Banquet Hall for Anniversary Celebrations in Ranchi. ✓Easy Booking ✓Affordable Price.'),(8,NULL,'image23.jpg','Party Venue','','<p>Ranchi, the capital of Jharkhand and a dream destination for many, serves as the starting point for the bulk of visitors and tourists. Visitors and locals alike are enchanted and captivated by the <strong>Best Party Places in Ranchi</strong> that offers unique nightlife owing to the city&#39;s abundance of venues.</p>\r\n\r\n<h2>Renowned Party Events in Ranchi&nbsp;</h2>\r\n\r\n<p>The Jumar is a group of individuals that work day and night to make your partying experience the most exciting and unforgettable ever. The Jumar provides you with all the assistance and facilities necessary to organize the ideal gathering event at the best <strong>Party Venues in Ranchi</strong>.</p>\r\n\r\n<h2>Party Places in Ranchi that Captivates you&nbsp;</h2>\r\n\r\n<p>We provide minimal, low-cost, and inexpensive party venues in Ranchi from which you can get the finest party venues. This is the most ideal <strong>Party Package in Ranchi</strong> available for selection.</p>\r\n','<p>Ranchi, the capital of Jharkhand and a dream destination for many, serves as the starting point for the bulk of visitors and tourists. Visitors and locals alike are enchanted and captivated by the Best Party Places in Ranchi that offers unique nightlife owing to the city&#39;s abundance of venues.</p>\r\n','Y','Party Venue in Ranchi, Cocktail Party Venue in Ranchi  ','Book Party Venue in Ranchi, Book Cocktail Party Venue in Ranchi, Best Cocktail Party Venue in Ranchi  ','Book Party Venue in Ranchi - The Jumar. Find the Best Cocktail Party Venue in Ranchi for Celebrations in Ranchi. ✓Easy Booking ✓Affordable Price.');

--
-- Table structure for table `subcontent_tbl`
--

CREATE TABLE `subcontent_tbl` (
  `subcontent_id` int(11) NOT NULL AUTO_INCREMENT,
  `subcontent_cat` varchar(400) NOT NULL,
  `subcontent_subcat` varchar(800) NOT NULL,
  `subcontent_desc` longtext,
  `subcontent_metatitle` text NOT NULL,
  `subcontent_mrtakey` text NOT NULL,
  `subcontent_metadesc` text NOT NULL,
  `subcontent_country` varchar(700) NOT NULL,
  `subcontent_date` varchar(300) NOT NULL,
  `short_desc` varchar(500) NOT NULL,
  `prodcut_subcat` varchar(200) NOT NULL,
  `product_subsubcat` varchar(200) NOT NULL,
  `product_finalcat` int(11) NOT NULL,
  `location` varchar(1000) NOT NULL,
  `product_subsubsubcat` varchar(1000) NOT NULL,
  PRIMARY KEY (`subcontent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcontent_tbl`
--


--
-- Table structure for table `subdomainmetatag_pages`
--

CREATE TABLE `subdomainmetatag_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `catDesc1` text NOT NULL,
  `catDesc` text NOT NULL,
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subdomainmetatag_pages`
--


--
-- Table structure for table `tbl_corder`
--

CREATE TABLE `tbl_corder` (
  `corder_id` int(11) NOT NULL AUTO_INCREMENT,
  `corder_name` varchar(600) NOT NULL,
  `corder_email` varchar(200) NOT NULL,
  `corder_mobile` varchar(100) NOT NULL,
  `corder_country` varchar(300) NOT NULL,
  `corder_product` varchar(500) NOT NULL,
  `corder_artwork` varchar(300) NOT NULL,
  `corder_plname` varchar(600) NOT NULL,
  `corder_plno` varchar(200) NOT NULL,
  `corder_plsize` varchar(300) NOT NULL,
  `corder_plqty` varchar(500) NOT NULL,
  `corder_date` varchar(200) NOT NULL,
  PRIMARY KEY (`corder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_corder`
--


--
-- Table structure for table `tbl_enquiry`
--

CREATE TABLE `tbl_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) NOT NULL,
  `en_mobile` varchar(100) NOT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_enquiry`
--

INSERT INTO `tbl_enquiry` VALUES (1,'test','6656565656',NULL,NULL,NULL,'2022-10-09 00:40:00','https://www.wpsbiz.com/thejumar/birthday-venue.htm',NULL,NULL,'49.37.75.254',NULL,NULL,NULL,NULL),(2,'test','5456645555','test23@gmail.com','test','hi ','2022-10-08 13:10:41','https://www.wpsbiz.com/thejumar/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'fgdf','1234567891','thtthh1345@gmail.com','test','vgh','2022-10-09 00:41:00','https://www.wpsbiz.com/thejumar/contact-us.htm',NULL,NULL,'49.37.75.254',NULL,NULL,NULL,NULL),(4,'er','1234567891','thtthh1345@gmail.com','test','vgh','2022-10-09 00:42:00','https://www.wpsbiz.com/thejumar/contact-us.htm',NULL,NULL,'49.37.75.254',NULL,NULL,NULL,NULL),(5,'test','1234567889',NULL,NULL,NULL,'2022-10-09 00:42:00','https://www.wpsbiz.com/thejumar/contact-us.htm',NULL,NULL,'49.37.75.254',NULL,NULL,NULL,NULL),(6,'test','1234567889',NULL,NULL,NULL,'2022-10-09 00:43:00','https://www.wpsbiz.com/thejumar/contact-us.htm',NULL,NULL,'49.37.75.254',NULL,NULL,NULL,NULL),(7,'Testing','6565656565','test@gmail.com','Delhi','Testing','2022-10-08 14:28:56','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'sudhanshu','8826692046','logicsg@gmail.com','Dumardaga, Ranchi','Need booking for the night of 20th November for 1 person. Please confirm. \r\nCheck in on 20th and Check out on 21st. ','2022-11-13 07:40:23','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'SG','9821793385',NULL,NULL,NULL,'2022-11-13 19:33:00','https://www.thejumar.in/rooms.htm',NULL,NULL,'165.225.125.73',NULL,NULL,NULL,NULL),(10,'Sulagna Bhattacharya ','8617089859',NULL,NULL,NULL,'2022-11-14 17:29:00','https://www.thejumar.in/',NULL,NULL,'49.37.53.117',NULL,NULL,NULL,NULL),(11,'Sulagna Bhattacharya ','8617089859',NULL,NULL,NULL,'2022-11-14 17:32:00','https://www.thejumar.in/',NULL,NULL,'49.37.53.117',NULL,NULL,NULL,NULL),(12,'Bharat','8405001717',NULL,NULL,NULL,'2022-12-09 02:34:00','https://www.thejumar.in/rooms.htm',NULL,NULL,'106.208.193.192',NULL,NULL,NULL,NULL),(13,'Snehashree','9886791123',NULL,NULL,NULL,'2023-03-04 22:36:00','https://www.thejumar.in/',NULL,NULL,'223.187.185.75',NULL,NULL,NULL,NULL),(14,'Praveen Kumar','8975485400','pra_s_3@yahoo.co.in','Pune','I want to book a large property from 29th April to 4th May for around 60 guests meaning 16 double rooms and 2 family and 2 queens suite. Also, if there is lawn and wedding area then its good.','2023-03-08 18:30:43','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Vikas Bansal','9434796772','mech73.bansal@gmail.com','Jhumar hotel booty','Room booking for 27-28','2023-05-26 05:09:00','https://thejumar.in/',NULL,NULL,'49.37.52.114',NULL,NULL,NULL,NULL),(16,'tezf','1312312312',NULL,NULL,NULL,'2023-06-09 23:21:00','https://thejumar.in/',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(17,'tezf','1312312312',NULL,NULL,NULL,'2023-06-09 23:21:00','https://thejumar.in/',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(18,'tezf','1312312312',NULL,NULL,NULL,'2023-06-09 23:21:00','https://thejumar.in/',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(19,'abc','1232131231',NULL,NULL,NULL,'2023-06-09 23:21:00','https://www.thejumar.in/',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(20,'abc','1232131231',NULL,NULL,NULL,'2023-06-09 23:23:00','https://www.thejumar.in/',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(21,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 11:56:24','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 11:57:00','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 11:59:19','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 11:59:30','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 12:02:36','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'test','4243234233','test@gmail.com','adsa','fgdfg','2023-06-09 12:03:12','https://www.thejumar.in/contact-us.htm',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'test','4534532234','test@gmail.com','asdsadff','adfsdf','2023-06-09 23:45:00','https://www.thejumar.in/contact-us.htm',NULL,NULL,'182.69.252.212',NULL,NULL,NULL,NULL),(28,'test','4234324231','test@gmail.com','dfdsfs','dfs','2023-06-09 23:54:00','https://www.thejumar.in/rooms.htm',NULL,'Single Rooms','182.69.252.212',NULL,NULL,NULL,NULL);

--
-- Table structure for table `team_group_tbl`
--

CREATE TABLE `team_group_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_group_tbl`
--


--
-- Table structure for table `team_tbl`
--

CREATE TABLE `team_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `team_group_id` varchar(20) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `short_description` text,
  `description` text,
  `designation` varchar(300) DEFAULT NULL,
  `facebook_link` varchar(500) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  `twitter_link` varchar(500) DEFAULT NULL,
  `instagram_link` varchar(500) DEFAULT NULL,
  `linkedin_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_tbl`
--


--
-- Table structure for table `technology_tbl`
--

CREATE TABLE `technology_tbl` (
  `technology_id` int(200) NOT NULL AUTO_INCREMENT,
  `technology_name` varchar(500) NOT NULL,
  `technology_detail` varchar(200) NOT NULL,
  `technology_images` varchar(200) NOT NULL,
  PRIMARY KEY (`technology_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technology_tbl`
--


--
-- Table structure for table `testimonial_tbl`
--

CREATE TABLE `testimonial_tbl` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `image` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `addedBy` varchar(10) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `replyStatus` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_tbl`
--


--
-- Table structure for table `transplant_result_tbl`
--

CREATE TABLE `transplant_result_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(300) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transplant_result_tbl`
--


--
-- Table structure for table `video_tbl`
--

CREATE TABLE `video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_tbl`
--


--
-- Table structure for table `wedding_tbl`
--

CREATE TABLE `wedding_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(500) DEFAULT NULL,
  `gallery_order` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wedding_tbl`
--


--
-- Table structure for table `whatsapp_enquiry`
--

CREATE TABLE `whatsapp_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whatsapp_enquiry`
--



