-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 09, 2019 at 02:16 PM
-- Server version: 10.1.24-MariaDB
-- PHP Version: 7.1.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `foodiee`
--

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

--
-- Table structure for table `hs_banner_slider`
--

CREATE TABLE `hs_banner_slider` (
  `slider_id` int(11) NOT NULL,
  `slider_heading` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_subtitle` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_button1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `button1_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_button2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `button2_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_backimage` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_image` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `slider_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hs_banner_slider`
--

INSERT INTO `hs_banner_slider` (`slider_id`, `slider_heading`, `slider_title`, `slider_subtitle`, `slider_button1`, `button1_url`, `slider_button2`, `button2_url`, `slider_backimage`, `slider_image`, `slider_status`) VALUES
(14, 'Welcome To Foodiee', 'We serve', 'FRESH SEASONAL FOOD', 'View Menu', 'http://hostingsites.co.in/developer33/foodiee/menus', 'Reservation', 'http://hostingsites.co.in/developer33/foodiee/home/reservation', 'uploads/website_images/banner11.jpg', 'uploads/website_images/chef1.png', 1),
(16, 'so tasty & delicious', 'We don’t Serve Food.', 'we serve happiness', 'View Menu', 'http://hostingsites.co.in/developer33/foodiee/menus', 'Reservation', 'http://hostingsites.co.in/developer33/foodiee/home/reservation', 'uploads/website_images/Layer-10081.png', 'uploads/website_images/chef23.png', 1);

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

--
-- Table structure for table `hs_blogs`
--

CREATE TABLE `hs_blogs` (
  `blog_id` int(11) NOT NULL,
  `blog_userid` int(11) NOT NULL,
  `blog_title` varchar(250) NOT NULL,
  `blog_category` varchar(250) NOT NULL,
  `blog_content` varchar(250) NOT NULL,
  `blog_longcontent` longtext NOT NULL,
  `blog_image` varchar(250) NOT NULL,
  `blogsingle_image` varchar(250) NOT NULL,
  `blog_date` varchar(50) NOT NULL,
  `blog_status` int(11) NOT NULL DEFAULT '1',
  `blog_slug` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_blog_category`
--

CREATE TABLE `hs_blog_category` (
  `cate_id` int(11) NOT NULL,
  `cate_name` varchar(50) NOT NULL,
  `cate_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_category`
--

CREATE TABLE `hs_category` (
  `category_id` int(10) NOT NULL,
  `category_name` varchar(50) NOT NULL,
  `category_description` varchar(250) NOT NULL,
  `category_image` varchar(250) NOT NULL,
  `category_featured` int(11) NOT NULL DEFAULT '1',
  `category_status` int(10) NOT NULL DEFAULT '1',
  `category_slug` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_chef_team`
--

CREATE TABLE `hs_chef_team` (
  `chef_id` int(11) NOT NULL,
  `chef_name` varchar(50) NOT NULL,
  `chef_desig` varchar(50) NOT NULL,
  `chef_image` varchar(250) NOT NULL,
  `chef_status` int(11) NOT NULL DEFAULT '1',
  `chef_facebook` varchar(100) NOT NULL,
  `chef_youtube` varchar(100) NOT NULL,
  `chef_twitter` varchar(100) NOT NULL,
  `chef_linkedin` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_comment`
--

CREATE TABLE `hs_comment` (
  `comment_id` int(11) NOT NULL,
  `comment_name` varchar(50) NOT NULL,
  `comment_email` varchar(50) NOT NULL,
  `comment_content` varchar(250) NOT NULL,
  `comment_date` varchar(50) NOT NULL,
  `comment_blog_id` int(11) NOT NULL,
  `comment_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_contact`
--

CREATE TABLE `hs_contact` (
  `contact_id` int(11) NOT NULL,
  `contact_fname` varchar(50) NOT NULL,
  `contact_lname` varchar(50) NOT NULL,
  `contact_email` varchar(50) NOT NULL,
  `contact_subject` varchar(250) NOT NULL,
  `contact_comment` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_occasions`
--

CREATE TABLE `hs_occasions` (
  `occasion_id` int(11) NOT NULL,
  `occasion_name` varchar(50) NOT NULL,
  `occasion_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_offers`
--

CREATE TABLE `hs_offers` (
  `offer_id` int(11) NOT NULL,
  `offer_heading` varchar(250) NOT NULL,
  `offer_title` varchar(250) NOT NULL,
  `offer_description` varchar(250) NOT NULL,
  `coupen_code` varchar(250) NOT NULL,
  `coupen_uses_limt` varchar(50) NOT NULL,
  `discount_type` varchar(50) NOT NULL,
  `discount_amount` varchar(50) NOT NULL,
  `apply_discount_to` varchar(50) NOT NULL,
  `discounted_product` varchar(50) NOT NULL,
  `coupen_expire_date` varchar(50) NOT NULL,
  `create_at` varchar(50) NOT NULL,
  `offer_image` varchar(250) NOT NULL,
  `offer_status` int(11) NOT NULL DEFAULT '1',
  `offer_featured` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hs_offers`
--

INSERT INTO `hs_offers` (`offer_id`, `offer_heading`, `offer_title`, `offer_description`, `coupen_code`, `coupen_uses_limt`, `discount_type`, `discount_amount`, `apply_discount_to`, `discounted_product`, `coupen_expire_date`, `create_at`, `offer_image`, `offer_status`, `offer_featured`) VALUES
(1, 'Today Offers', '', ' USE Promo Code:- 123456    For 15% off on chicken tikka today only.   ', '123456', '10', '1', '15', 'single_product', '31', '2019-04-05', '30 Mar 2019 07:02:07', 'uploads/offer_images/adv1.jpg', 1, 0),
(2, 'Exculusive Offer ', '', 'USE  PROMO CODE: - 12345678  To  Flat  $ 15 off on total amount  today only', '12345678', '8', '2', '15', 'Total_amount', '0', '2019-04-05', '30 Mar 2019 07:03:53', 'uploads/offer_images/adv2.jpg', 1, 0);

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

--
-- Table structure for table `hs_opening_schedule`
--

CREATE TABLE `hs_opening_schedule` (
  `schedule_id` int(11) NOT NULL,
  `schedule_name` varchar(250) NOT NULL,
  `schedule_time` varchar(50) NOT NULL,
  `schedule_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hs_opening_schedule`
--

INSERT INTO `hs_opening_schedule` (`schedule_id`, `schedule_name`, `schedule_time`, `schedule_status`) VALUES
(1, 'opening section heading', 'OPENING HOURS', 1),
(2, 'Monday-Tueday', '10:00 - 20:00 ', 1),
(3, 'Wednesday-Thursday', '09:00 - 19:00', 1),
(4, 'Friday-Saturday', '09:00 - 23:00', 1),
(5, 'Sunday', '10:00 - 20:00', 1);

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

--
-- Table structure for table `hs_pages`
--

CREATE TABLE `hs_pages` (
  `page_id` int(11) NOT NULL,
  `page_heading` varchar(250) NOT NULL,
  `page_title` varchar(250) NOT NULL,
  `page_image` varchar(250) NOT NULL,
  `page_shortcontent` varchar(500) NOT NULL,
  `page_massage` longtext NOT NULL,
  `page_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hs_pages`
--

INSERT INTO `hs_pages` (`page_id`, `page_heading`, `page_title`, `page_image`, `page_shortcontent`, `page_massage`, `page_status`) VALUES
(1, 'About Restaurant', 'WELCOME TO RESTAURANT                                                                                        ', 'uploads/pagesimage/about.jpg', 'Lorem ipsum dolor sit amet ensectetur adipii sed eod tempor incididunt utiabore et dolore magnaim ad imveniam exerc.Lorem ipsum dolor sit amet ensectetur adipii sed eod tempor incididunt utiabore et dolore magnaim ad imveniam exerc.Lorem ipsum dolor sit amet ensectetur adipii sed eod tempor incididunt utiabore et dolore magnaim ad imveniam exerc.Lorem ipsum dolor sit amet ensectetur adipii sed eod tempor incididunt utiabore et dolore magnaim ad imveniam exerc.', '<div class=\"fd_heading\">\r\n<h2>why choose us</h2>\r\n\r\n<h1>About our work</h1>\r\n</div>\r\n\r\n<h3>We combine our recipes With emphasis on comfort Taste and relaxation</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmodncididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis trud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse.</p>\r\n\r\n<p>dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium i ipsa quae ab illo</p>\r\n', 1);

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

--
-- Table structure for table `hs_partners`
--

CREATE TABLE `hs_partners` (
  `partner_id` int(11) NOT NULL,
  `partner_image` varchar(250) NOT NULL,
  `partner_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_portfolio`
--

CREATE TABLE `hs_portfolio` (
  `portfolio_id` int(11) NOT NULL,
  `portfolio_image` varchar(250) NOT NULL,
  `portfolio_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_products`
--

CREATE TABLE `hs_products` (
  `prod_id` int(11) NOT NULL,
  `prod_name` varchar(100) NOT NULL,
  `prod_cateid` int(11) NOT NULL,
  `prod_subcateid` int(11) NOT NULL,
  `prod_status` int(11) NOT NULL DEFAULT '1',
  `prod_featured` int(11) NOT NULL DEFAULT '1',
  `prod_description` varchar(250) NOT NULL,
  `prod_image` varchar(100) NOT NULL,
  `prod_specialmenu_img` varchar(250) NOT NULL,
  `prod_date` varchar(50) NOT NULL,
  `prod_price` varchar(100) NOT NULL,
  `prod_quantity` varchar(100) NOT NULL,
  `prod_code` varchar(10) NOT NULL,
  `prod_availability` int(11) NOT NULL,
  `prod_slug` varchar(250) NOT NULL,
  `prod_longdescription` longtext NOT NULL,
  `prod_singleimg` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_rating`
--

CREATE TABLE `hs_rating` (
  `rating_id` int(11) NOT NULL,
  `rating_uid` int(11) NOT NULL,
  `rating_prod_id` int(11) NOT NULL,
  `rating_star` int(11) NOT NULL,
  `rating_review` varchar(250) NOT NULL,
  `rating_status` int(11) NOT NULL DEFAULT '1',
  `rating_date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_reservation_details`
--

CREATE TABLE `hs_reservation_details` (
  `reservation_id` int(11) NOT NULL,
  `reservation_uniqid` varchar(50) NOT NULL,
  `reservation_date` varchar(20) NOT NULL,
  `reservation_time` varchar(20) NOT NULL,
  `people` int(11) NOT NULL,
  `booked_table` int(11) NOT NULL,
  `occasion` varchar(50) NOT NULL,
  `preferred_food` varchar(50) NOT NULL,
  `massage` varchar(250) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `reserv_receivedate` varchar(50) NOT NULL,
  `reservation_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_setting`
--

CREATE TABLE `hs_setting` (
  `uniq_id` int(11) NOT NULL,
  `text_name` varchar(250) NOT NULL,
  `key_text` varchar(250) NOT NULL,
  `value_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hs_setting`
--

INSERT INTO `hs_setting` (`uniq_id`, `text_name`, `key_text`, `value_text`) VALUES
(1, 'site title', 'sitetitle_text', 'Foodiee'),
(2, 'site author', 'siteauthor_text', 'Kamleshyadav'),
(3, 'site description', 'sitedescr_text', 'Food Order And Table Booking Web App'),
(4, 'matatags keyword', 'metatags_text', 'Restaurant '),
(5, 'favicon image', 'favicon_img', 'uploads/website_images/favicon2.png'),
(6, 'logo image', 'logo_img', 'uploads/website_images/logo1.png'),
(7, 'booking section image', 'bookingsection_img', 'uploads/website_images/book_img.jpg'),
(8, 'banner section image', 'bannersection_img', 'uploads/website_images/shaif.png'),
(9, 'footer logo image', 'footerlogo_img', 'uploads/website_images/footer_logo.png'),
(10, 'contact heading ', 'contactheading_foot', 'Contact Us '),
(11, 'facebook link', 'facebooklink_foot', ' Https://facebook.com'),
(12, 'youtube link', 'youtubelink_foot', ' Https://youtube.com'),
(13, 'twitter link', 'twitterlink_foot', 'Https://twitter.com'),
(14, 'linkedin link', 'linkedinlink_foot', 'Https://in.linkedin.com/'),
(15, 'address ', 'address_foot', '512, Your Street , City, Your Country'),
(16, 'email 1', 'email1_foot', 'Example123@mail.com '),
(17, 'email 2', 'email2_foot', ' Restoexample@mail.com'),
(18, 'contact 1', 'contact1_foot', '+1800-124-1426'),
(19, 'contact 2', 'contact2_foot', ' +1800-124-1425'),
(20, 'copyright ', 'copyright_foot', ' All Right Reserved.'),
(21, 'banner section', 'banner_section', '1'),
(22, 'category section', 'category_section', '1'),
(23, 'about us page section', 'aboutpage_section', '1'),
(24, 'special menu section', 'specialmenu_section', '1'),
(25, 'video section', 'video_section', '1'),
(26, 'booking section', 'booking_section', '1'),
(27, 'all day food solution section', 'alldayfood_section', '1'),
(28, 'gallery section', 'gallery_section', '1'),
(29, 'mobile app section', 'mobileapp_section', '0'),
(30, 'testimonial section', 'testimonial_section', '1'),
(31, 'blog section', 'blog_section', '1'),
(32, 'partner section', 'partner_section', '1'),
(33, 'chef member team section', 'chefmemberteam_section', '1'),
(34, 'contact heading', 'contactheading_show', '1'),
(35, 'facebook link', 'facebooklink_show', '1'),
(36, 'youtube link', 'youtubelink_show', '1'),
(37, 'twitter link', 'twitterlink_show', '1'),
(38, 'linkedin link', 'linkedinlink_show', '1'),
(39, 'address', 'address_show', '1'),
(40, 'email1', 'email1_show', '1'),
(41, 'email2', 'email2_show', '1'),
(42, 'contact1', 'contact1_show', '1'),
(43, 'contact2', 'contact2_show', '1'),
(44, 'copyright', 'copyright_show', '1'),
(45, 'booking section button ', 'bookingbutton_text', 'Book Now'),
(46, 'home', 'home_hmenu', '1'),
(47, 'about us', 'about_us_hmenu', '1'),
(48, 'menu', 'foodmenu_hmenu', '1'),
(49, 'reservation', 'reservation_hmenu', '1'),
(50, 'gallery', 'gallery_hmenu', '1'),
(51, 'blog', 'blog_hmenu', '1'),
(52, 'contact', 'contact_hmenu', '1'),
(53, 'search bar', 'searchbar_hmenu', '1'),
(54, 'contact us form section', 'contactus_section', '1'),
(55, 'google map section ', 'map_section', '1'),
(56, 'google map ap[ key', 'map_apikey', 'AIzaSyAYh9WxsbEDdI1nH7HSiFzZISk5y-5qcV4'),
(60, 'banner scroll Button', 'bannerscrol_text', 'Scroll'),
(61, 'spacial menu section heading', 'specialmenuheading_text', 'Random Dishes'),
(62, 'spacial menu section title', 'specialmenutitle_text', 'OUR SPECIAL MENU'),
(63, 'video section heading', 'videosectionheading_text', 'Prepare The Best Dishes'),
(64, 'video section title', 'videosectiontitle_text', 'OUR RESTAURANT AND THE FOOD THEY SERVE THEIR GUESTS'),
(65, 'booking section heading', 'bookingheading_text', 'Booking Now'),
(66, 'booking section title', 'bookingtitle_text', 'BOOK YOUR TABLE NOW'),
(67, 'food section heading ', 'foodsectionheading_text', 'Complete Your Day'),
(68, 'food section title', 'foodsectiontitle_text', 'ALL DAY FOOD SOLUTION'),
(69, 'gallery section heading ', 'galleryheading_text', 'Gallery'),
(70, 'gallery section title', 'gallerytitle_text', 'OUR PORTFOLIO'),
(71, 'testimonial section heading ', 'testimonialheading_text', ' Testimonial '),
(72, 'testimonial section title', 'testimonialtitle_text', 'CUSTOMER FEEDBACK'),
(73, 'blog section heading', 'blogheading_text', 'Our Blog'),
(74, 'blog section title', 'blogtitle_text', 'LATEST FROM BLOG'),
(75, 'partner section heading ', 'partnerheading_text', 'Our Partner’s'),
(76, 'partner section title', 'partnertitle_text', 'TRUSTED BY GREAT TEAM'),
(77, 'chef team section heading', 'teamsectionheading_text', 'Our Team'),
(78, 'chef team section title', 'teamsectiontitle_text', 'BEST CELEBRITY CHEF'),
(79, 'header section ', 'header_section', '1'),
(80, 'footer section', 'footer_section', '1'),
(81, 'site title show', 'sitetitle_show', '1'),
(82, 'site author show', 'siteauthor_show', '1'),
(83, 'site description show', 'sitedescr_show', '1'),
(84, 'matatags keyword show', 'metatags_show', '1'),
(91, 'banner scrol button show', 'bannerscrol_show', '1'),
(92, 'special menu heading show', 'specialmenuheading_show', '1'),
(93, 'special menu title show', 'specialmenutitle_show', '1'),
(94, 'video section heading show', 'videosectionheading_show', '1'),
(95, 'video section title show', 'videosectiontitle_show', '1'),
(96, 'booking section heading show', 'bookingheading_show', '1'),
(97, 'booking section title show', 'bookingtitle_show', '1'),
(98, 'food section heading show', 'foodsectionheading_show', '1'),
(99, 'food section  title show', 'foodsectiontitle_show', '1'),
(100, 'gallery heading show', 'galleryheading_show', '1'),
(101, 'gallery title show', 'gallerytitle_show', '1'),
(102, 'testimonial heading show', 'testimonialheading_show', '1'),
(103, 'testimonial title', 'testimonialtitle_show', '1'),
(104, 'blog heading show', 'blogheading_show', '1'),
(105, 'blog title show ', 'blogtitle_show', '1'),
(106, 'partner heading show', 'partnerheading_show', '1'),
(107, 'partner title show', 'partnertitle_show', '1'),
(108, 'team section heading show', 'teamsectionheading_show', '1'),
(109, 'team section title show', 'teamsectiontitle_show', '1'),
(110, 'booking form heading', 'bookingformheading_text', 'Select Your Dining Space'),
(111, 'booking form heading show', 'bookingformheading_show', '1'),
(112, 'mobile app section heading', 'mobileappheading_text', 'Online Food Delivery App'),
(113, 'mobile app heading show', 'mobileappheading_show', '1'),
(114, 'mobile app section title', 'mobileapptitle_text', 'EXPERIENCE THE FINEST QUALITY FOOD'),
(115, 'mobile app title show', 'mobileapptitle_show', '1'),
(116, 'mobile app section description', 'mobileappdescr_text', 'Lorem Ipsum Dolor Sit Amet, Consectetur Adipisicing Elitiusmod Tempor Incididunt Ut Labore Et Dolore Magna Aliqua. Ut Enim Ad Minim Veniam, Quis Nud Exercitation Ullamco Laboris Nisi Ut Aliquip Ex Ea Commodo Consequat.'),
(117, 'mobile app description show', 'mobileappdescr_show', '1'),
(118, 'mobile app download heading', 'mobileappdownload_text', ' Download Our App Now'),
(119, 'mobile app download heading show', 'mobileappdownload_show', '1'),
(120, 'mobile app image ', 'mobileapp_img', 'uploads/website_images/app.png'),
(121, 'mobile app store image 1', 'googlestore_img', 'uploads/website_images/google_play1.png'),
(122, 'mobile app store image 2', 'iosstore_img', 'uploads/website_images/app_store2.png'),
(123, 'booking button show', 'bookingbutton_show', '1'),
(124, 'video section url ', 'videourl_text', 'Https://www.youtube.com/watch?v=b8d0gpsXzEk'),
(125, 'video section show', 'videourl_show', '1'),
(126, 'contact page heading', 'contactpageheading_text', 'GET IN TOUCH'),
(127, 'contact page heading show ', 'contactpageheading_show', '1'),
(128, 'contact form heading ', 'contactformheading_text', 'HOW CAN WE HELP YOU ?'),
(129, 'contact form heading show', 'contactformheading_show', '1'),
(130, 'comment section heading', 'commentheading_text', ' COMMENTS'),
(131, 'comment section heading show', 'commentheading_show', '1'),
(132, 'comment form Heading ', 'commentformheading_text', 'LEAVE A COMMENT'),
(133, 'comment form heading show', 'commentformheading_show', '1'),
(134, 'related product section heading', 'relatedprodheading_text', 'Related Products'),
(135, 'related product section heading show', 'relatedprodheading_show', '1'),
(136, 'related product section title ', 'relatedprodtitle_text', 'YOU MAY ALSO BE INTERESTED IN'),
(137, 'related product section title show', 'relatedprodtitle_show', '1'),
(138, 'google play store url', 'googleplayurl_text', 'Https://play.google.com/store'),
(139, 'Ios mobile store url', 'iosstoreurl_text', 'Https://www.apple.com/in/ios/app-store/'),
(140, 'google play store url show', 'googleplayurl_show', '1'),
(141, 'Ios mobile store url show', 'iosstoreurl_show', '1'),
(142, 'Send mail from this mail address', 'sendermaiilid_mail', 'modinitesh15@gmail.com                              '),
(143, 'map location latitude', 'map_latitude', '22.7195687'),
(144, 'map location longitude', 'map_longitude', '75.85772580000003'),
(145, 'term & condition page', 'termcondition_page', '<p style=\"text-align:justify\">&nbsp;</p>\r\n\r\n<p style=\"text-align:justify\"><strong>What is Lorem Ipsum?</strong></p>\r\n\r\n<p style=\"text-align:justify\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p style=\"text-align:justify\">1.&nbsp;It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</p>\r\n\r\n<p style=\"text-align:justify\">2.&nbsp;All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet.</p>\r\n\r\n<p style=\"text-align:justify\">3.&nbsp;The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.</p>\r\n\r\n<p style=\"text-align:justify\">4.&nbsp;It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Where does it come from?</strong></p>\r\n\r\n<p style=\"text-align:justify\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</p>\r\n\r\n<p style=\"text-align:justify\">Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n\r\n<p style=\"text-align:justify\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Why do we use it?</strong></p>\r\n\r\n<p style=\"text-align:justify\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.</p>\r\n\r\n<p style=\"text-align:justify\">Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Where can I get some?</strong></p>\r\n\r\n<p style=\"text-align:justify\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don&#39;t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn&#39;t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>\r\n'),
(146, 'privacy policy page', 'privacy_page', '<p style=\"text-align:justify\"><strong>What is Lorem Ipsum?</strong></p>\r\n\r\n<p style=\"text-align:justify\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Where does it come from?</strong></p>\r\n\r\n<p style=\"text-align:justify\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.</p>\r\n\r\n<p style=\"text-align:justify\">Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n\r\n<p style=\"text-align:justify\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Why do we use it?</strong></p>\r\n\r\n<p style=\"text-align:justify\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English.</p>\r\n\r\n<p style=\"text-align:justify\">Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Where can I get some?</strong></p>\r\n\r\n<p style=\"text-align:justify\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don&#39;t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn&#39;t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>\r\n'),
(147, 'term & condition update date', 'termupdate_date', '09 Jan 2019'),
(148, 'privacy update date', 'privacyupdate_date', '15 Jan 2019'),
(149, 'gdpr cookie title', 'gdpr_title', 'Cookie Notice'),
(150, 'gdpr cookie massage', 'gdpr_msg', 'Please Accept These To Continuous Enjoying Our Site!'),
(151, 'gdpr link title', 'gdprlink_title', 'Read Cookies and Privacy Policy '),
(152, 'gdpr link ', 'gdpr_link', 'http://hostingsites.co.in/developer33/foodiee/home/policy'),
(153, 'gdpr botton title', 'gdprbutton_title', 'Accept'),
(154, 'gdpr popup image', 'gdpr_image', 'uploads/website_images/cook1.png'),
(155, 'paypal email', 'paypal_email', 'syinfotech333-facilitator1cvx@gmail.com'),
(156, 'currency symbol', 'currency_symbol', '$'),
(157, 'payumoney merchant key', 'payumoney_key', 'cxsCFyuxhlcx'),
(158, 'payumoney merchant salt', 'payumoney_salt', 'cxl1hMFGsCMlzx'),
(159, 'paypal status', 'paypal_status', '1'),
(160, 'payumoney status ', 'payumoney_status', '1'),
(161, 'currency code', 'currency_code', 'USD'),
(162, 'wallet status', 'wallet_status', '1'),
(163, 'cod status', 'cod_status', '1'),
(164, 'send email from name', 'sender_name', 'foodiee'),
(165, 'send email from email id', 'sender_mailid', 'abc@gmail.com'),
(166, 'email verification subject', 'everifi_subject', 'E-Mail Verification'),
(167, 'email verification template text', 'everifi_template', 'Hello  [username] , [break]  \r\nyou are registered successfully. Click on below link to activate your account.  [break]  [break] [link]  [break]  [break] \r\nThanks,[break][break] \r\nTeam Foodiee'),
(168, 'email verification link text', 'everifi_link', 'Click  To Verify'),
(169, 'table booking subject', 'tablebook_subject', 'Table Booked  Successful'),
(170, 'table booking template text', 'tablebook_template', 'Hello , [username] ,[break]\r\nyou  booked a table. [break] \r\nBooking Number : [booking_number][break]\r\nBooking Date :  [booking_date] [break] \r\nBooking Time : [booking_time] [break] \r\nTable number : [table_number] [break] [break] \r\nThanks,[break][break] \r\nTeam Foodiee.'),
(171, 'order booking subject ', 'orderbook_subject', 'Order Book Successful'),
(172, 'order booking template text', 'orderbook_template', 'Hello , [username] ,[break] \r\nyou  booked a order.[break] \r\nDate : [order_date] [break]\r\nOrder number : [order_number] [break] \r\nOrder amount : [order_amount] [break] [break] \r\nThanks,[break][break] \r\nTeam Foodiee'),
(173, 'forgot password subject', 'forgotpwd_mailsubject', 'Reset your password'),
(174, 'forgot password template text', 'forgotpwd_template', 'Hello  [username] , [break] \r\nclick  on below link  to reset your password.  [break]  [break] \r\n[link]  [break]  [break] \r\nThanks,[break][break]\r\nTeam Foodiee'),
(175, 'forgot password template link text', 'forgotpwd_link', ' Reset Password'),
(176, 'invoice mail subject', 'invoice_subject', 'Invoice Details'),
(177, 'invoice mail template', 'invoice_template', 'invoice'),
(178, 'table booking canceled subject', 'tbcancel_subject', 'Table Booking canceled'),
(179, 'table booking canceled template text', 'tbcancel_template', 'Hello  [username] ,[break] \r\nyour table booking number [booking_number]  is canceled.  \r\n[break] [break] \r\nThanks,[break][break] \r\nTeam Foodiee'),
(180, 'order intransit subject', 'odr_intransit_subject', 'Order Dispatch'),
(181, 'order intransit template text', 'odr_intransit_template', 'Hello [username], [break]\r\nYour order number  [order_number], [break]  is successfully prepared and dispatch and will be available to you shortly. [break] [break]\r\nThanks,[break]\r\nTeam Foodiee.'),
(182, 'order canceled subject', 'odr_canceled_subject', 'Canceled Order'),
(183, 'order canceled template text', 'odr_canceled_template', 'Hello [username],[break]\r\nYour Order number :  [order_number], was Canceled please try again later .  [break] [break]\r\nThanks,[break]\r\nTeam Foodiee.'),
(184, 'order delivered subject', 'odr_delivered_subject', 'Order Delivered'),
(185, 'order delivered template text', 'odr_delivered_template', 'Hello [username],[break]\r\nYour order number  [order_number], is succefully  Delivered To Your Place.  [break] [break]\r\nThanks,[break]\r\nTeam Foodiee.'),
(186, 'table booking confirmed subject', 'tbconfirm_subject', 'Your Table Booking  Confirmed'),
(187, 'table booking confirmed template', 'tbconfirm_tamplate', 'Hello  [username] ,[break]\r\nyour table booking number [booking_number]  has been confirmed .  \r\n[break] [break] \r\nThanks,[break][break] \r\nTeam Foodiee'),
(188, 'order booking subject for admin', 'adminodr_subject', 'Order Booked'),
(189, 'order booking template for admin', 'adminodr_template', 'Hi Admin, [break]\r\n[username],[break] has  booked a order.[break] \r\nDate : [order_date] [break] \r\nOrder number : [order_number] [break] [break] \r\nThanks,[break][break] \r\nTeam Foodiee\r\n'),
(190, 'table booking subject for admin', 'admintbook_subject', 'Table Booked'),
(191, 'table booking template for admin', 'admintbook_template', 'Hi Admin, [break]\r\n[username],[break] has  booked a table. [break] \r\nBooking Number : [booking_number] [break] \r\nDate : [booking_date] [break]  \r\nBooking Time [booking_time] [break] \r\nTable Number : [table_number][break] [break]\r\nThanks,[break][break] \r\nTeam Foodiee'),
(192, 'preloader image', 'preloader_img', 'uploads/website_images/loader5.gif'),
(193, 'user register by admin subject', 'register_subject', 'Your Account Create Successfully By Foodiee'),
(194, 'user register by admin template', 'register_template', 'Hi [username],[break][break]\r\nCongratulation. We create  your account. [break]\r\nHere are your login details .[break]\r\nUser Email ID : [Email] [break]\r\nPassword : [password] [break]\r\n[break][break]\r\nThanks,[break]\r\nTeam Foodiee'),
(195, 'Currency convert api key', 'currency_convert_api', 'chfsb692f11c4d93d89416722xccxc'),
(196, 'smtp mail status', 'smtp_status', '0'),
(197, 'smtp host', 'smtp_host', 'localhost'),
(198, 'smtp port', 'smtp_port', ''),
(199, 'smtp username', 'smtp_username', ''),
(200, 'smtp password', 'smtp_password', '');

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

--
-- Table structure for table `hs_table_details`
--

CREATE TABLE `hs_table_details` (
  `table_id` int(11) NOT NULL,
  `table_name` varchar(50) NOT NULL,
  `table_no` int(11) NOT NULL,
  `table_capacity` varchar(11) NOT NULL,
  `table_image` varchar(250) NOT NULL,
  `table_status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_testimonial`
--

CREATE TABLE `hs_testimonial` (
  `testi_id` int(11) NOT NULL,
  `testi_name` varchar(250) NOT NULL,
  `testi_desig` varchar(250) NOT NULL,
  `testi_msg` varchar(250) NOT NULL,
  `testi_showdesig` int(11) NOT NULL,
  `testi_image` varchar(250) NOT NULL,
  `testi_status` int(11) NOT NULL DEFAULT '1',
  `testi_facebook_link` varchar(100) NOT NULL,
  `testi_youtube_link` varchar(100) NOT NULL,
  `testi_twitter_link` varchar(100) NOT NULL,
  `testi_linkedin_link` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hs_user`
--

CREATE TABLE `hs_user` (
  `user_id` int(10) NOT NULL,
  `user_name` varchar(50) NOT NULL,
  `user_fname` varchar(250) NOT NULL,
  `user_lname` varchar(250) NOT NULL,
  `user_email` varchar(50) NOT NULL,
  `user_mobile` varchar(20) NOT NULL,
  `user_password` varchar(50) NOT NULL,
  `user_country` varchar(250) NOT NULL,
  `user_state` varchar(250) NOT NULL,
  `user_city` varchar(250) NOT NULL,
  `user_zipcode` varchar(250) NOT NULL,
  `user_address` varchar(100) NOT NULL,
  `user_status` int(10) NOT NULL,
  `registration_date` varchar(50) NOT NULL,
  `user_type` int(11) NOT NULL,
  `passreset_code` varchar(100) DEFAULT NULL,
  `user_image` varchar(250) NOT NULL,
  `user_email_verify_code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hs_user`
--

INSERT INTO `hs_user` (`user_id`, `user_name`, `user_fname`, `user_lname`, `user_email`, `user_mobile`, `user_password`, `user_country`, `user_state`, `user_city`, `user_zipcode`, `user_address`, `user_status`, `registration_date`, `user_type`, `passreset_code`, `user_image`, `user_email_verify_code`) VALUES
(1, 'Admin', 'john', 'doe', 'admin@foodiee.com', '7879544547', 'e10adc3949ba59abbe56e057f20f883e', 'india', 'm.p.', 'indore', '4550014', 'Lorem Ipsum Dolor Sit Amet, Consectetur Adipisicing Elitiusmod Tempor', 1, '01 Nov 2018 09:34:15', 1, NULL, '', '');

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

--
-- Table structure for table `hs_user_orders`
--

CREATE TABLE `hs_user_orders` (
  `order_id` int(11) NOT NULL,
  `order_uniqid` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `order_uid` int(11) NOT NULL,
  `order_pid` text COLLATE utf8_unicode_ci NOT NULL,
  `order_date` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `order_contact` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `order_amount` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `payment_mode` int(11) NOT NULL,
  `order_email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `delivery_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `order_city` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `city_pincode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `payment_status` int(11) NOT NULL,
  `order_status` int(11) NOT NULL,
  `payment_txnid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `used_coupen_code` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `hs_user_wallet`
--

CREATE TABLE `hs_user_wallet` (
  `wallet_id` int(11) NOT NULL,
  `wallet_uid` int(11) NOT NULL,
  `wallet_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `hs_uwallet_credit`
--

CREATE TABLE `hs_uwallet_credit` (
  `wcredit_id` int(11) NOT NULL,
  `wcredit_uid` int(11) NOT NULL,
  `wcredit_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `wcredit_note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `wcredit_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `hs_banner_slider`
--
ALTER TABLE `hs_banner_slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `hs_blogs`
--
ALTER TABLE `hs_blogs`
  ADD PRIMARY KEY (`blog_id`);

--
-- Indexes for table `hs_blog_category`
--
ALTER TABLE `hs_blog_category`
  ADD PRIMARY KEY (`cate_id`);

--
-- Indexes for table `hs_category`
--
ALTER TABLE `hs_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `hs_chef_team`
--
ALTER TABLE `hs_chef_team`
  ADD PRIMARY KEY (`chef_id`);

--
-- Indexes for table `hs_comment`
--
ALTER TABLE `hs_comment`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `hs_contact`
--
ALTER TABLE `hs_contact`
  ADD PRIMARY KEY (`contact_id`);

--
-- Indexes for table `hs_occasions`
--
ALTER TABLE `hs_occasions`
  ADD PRIMARY KEY (`occasion_id`);

--
-- Indexes for table `hs_offers`
--
ALTER TABLE `hs_offers`
  ADD PRIMARY KEY (`offer_id`);

--
-- Indexes for table `hs_opening_schedule`
--
ALTER TABLE `hs_opening_schedule`
  ADD PRIMARY KEY (`schedule_id`);

--
-- Indexes for table `hs_pages`
--
ALTER TABLE `hs_pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `hs_partners`
--
ALTER TABLE `hs_partners`
  ADD PRIMARY KEY (`partner_id`);

--
-- Indexes for table `hs_portfolio`
--
ALTER TABLE `hs_portfolio`
  ADD PRIMARY KEY (`portfolio_id`);

--
-- Indexes for table `hs_products`
--
ALTER TABLE `hs_products`
  ADD PRIMARY KEY (`prod_id`);

--
-- Indexes for table `hs_rating`
--
ALTER TABLE `hs_rating`
  ADD PRIMARY KEY (`rating_id`);

--
-- Indexes for table `hs_reservation_details`
--
ALTER TABLE `hs_reservation_details`
  ADD PRIMARY KEY (`reservation_id`);

--
-- Indexes for table `hs_setting`
--
ALTER TABLE `hs_setting`
  ADD PRIMARY KEY (`uniq_id`);

--
-- Indexes for table `hs_table_details`
--
ALTER TABLE `hs_table_details`
  ADD PRIMARY KEY (`table_id`);

--
-- Indexes for table `hs_testimonial`
--
ALTER TABLE `hs_testimonial`
  ADD PRIMARY KEY (`testi_id`);

--
-- Indexes for table `hs_user`
--
ALTER TABLE `hs_user`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `hs_user_orders`
--
ALTER TABLE `hs_user_orders`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `hs_user_wallet`
--
ALTER TABLE `hs_user_wallet`
  ADD PRIMARY KEY (`wallet_id`);

--
-- Indexes for table `hs_uwallet_credit`
--
ALTER TABLE `hs_uwallet_credit`
  ADD PRIMARY KEY (`wcredit_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `hs_banner_slider`
--
ALTER TABLE `hs_banner_slider`
  MODIFY `slider_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `hs_blogs`
--
ALTER TABLE `hs_blogs`
  MODIFY `blog_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_blog_category`
--
ALTER TABLE `hs_blog_category`
  MODIFY `cate_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_category`
--
ALTER TABLE `hs_category`
  MODIFY `category_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_chef_team`
--
ALTER TABLE `hs_chef_team`
  MODIFY `chef_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_comment`
--
ALTER TABLE `hs_comment`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_contact`
--
ALTER TABLE `hs_contact`
  MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_occasions`
--
ALTER TABLE `hs_occasions`
  MODIFY `occasion_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_offers`
--
ALTER TABLE `hs_offers`
  MODIFY `offer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `hs_opening_schedule`
--
ALTER TABLE `hs_opening_schedule`
  MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `hs_pages`
--
ALTER TABLE `hs_pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `hs_partners`
--
ALTER TABLE `hs_partners`
  MODIFY `partner_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_portfolio`
--
ALTER TABLE `hs_portfolio`
  MODIFY `portfolio_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_products`
--
ALTER TABLE `hs_products`
  MODIFY `prod_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_rating`
--
ALTER TABLE `hs_rating`
  MODIFY `rating_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_reservation_details`
--
ALTER TABLE `hs_reservation_details`
  MODIFY `reservation_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_setting`
--
ALTER TABLE `hs_setting`
  MODIFY `uniq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=201;
--
-- AUTO_INCREMENT for table `hs_table_details`
--
ALTER TABLE `hs_table_details`
  MODIFY `table_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_testimonial`
--
ALTER TABLE `hs_testimonial`
  MODIFY `testi_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_user`
--
ALTER TABLE `hs_user`
  MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `hs_user_orders`
--
ALTER TABLE `hs_user_orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `hs_user_wallet`
--
ALTER TABLE `hs_user_wallet`
  MODIFY `wallet_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `hs_uwallet_credit`
--
ALTER TABLE `hs_uwallet_credit`
  MODIFY `wcredit_id` int(11) NOT NULL AUTO_INCREMENT;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 */;
