-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 13, 2019 at 11:34 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
--

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

--
-- Table structure for table `tbl_address`
--

CREATE TABLE `tbl_address` (
  `address_id` int(11) NOT NULL,
  `address` varchar(2000) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` varchar(500) NOT NULL,
  `phone` varchar(400) NOT NULL,
  `city` varchar(400) NOT NULL,
  `zipcode` varchar(400) NOT NULL,
  `name` varchar(400) NOT NULL,
  `add_category` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_address`
--

INSERT INTO `tbl_address` (`address_id`, `address`, `date_time`, `user_id`, `phone`, `city`, `zipcode`, `name`, `add_category`) VALUES
(1, 'Gali No : 3, Gandhi Market Main Sagarpur', '2017-11-16 05:37:13', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'shipping'),
(2, 'Sec -4 , Rohini west', '2017-11-16 05:37:24', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'shipping'),
(3, 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '2017-11-22 11:51:57', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'billing'),
(4, 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '2017-11-17 08:06:06', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'shipping'),
(16, 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '2017-11-22 11:51:57', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'billing'),
(17, '', '2017-11-22 11:45:34', '83', '', '', '', '', 'shipping'),
(18, 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '2017-11-22 11:51:57', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'billing'),
(19, 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '2017-11-22 11:51:04', '83', '8285784867', 'New Delhi', '110046', 'Krishna Kant', 'billing');

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `uid` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `apassword` varchar(400) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `image` text,
  `last_login_date_time` varchar(100) NOT NULL,
  `designation` varchar(400) DEFAULT NULL,
  `member_since` varchar(200) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `user_cat` varchar(100) DEFAULT NULL,
  `alt_email` varchar(200) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `whatsup_no` varchar(100) NOT NULL,
  `password` varchar(200) NOT NULL,
  `address` varchar(3000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`uid`, `parent_id`, `name`, `email`, `username`, `apassword`, `status`, `image`, `last_login_date_time`, `designation`, `member_since`, `phone`, `user_cat`, `alt_email`, `mobile`, `whatsup_no`, `password`, `address`) VALUES
(1, 0, 'Mr. Krishna Kant', 'support@pureshop.com', 'admin@self', '5e8edd851d2fdfbd7415232c67367cc3', 'Active', '1505722334admin.jpg', '2018-01-31 11:59:51', 'CEO', 'Nov. 2012', '9999999999', 'Super_admin', '', '', '', 'developer', ''),
(3, 1, 'Ajay', 'ajay.brandbugle@gmail.com', 'ajay', '0fe90ff7501094dbbd19de2855384add', 'Active', 'admin.jpg', '', 'ADMIN', '06/09/2017', '8527977677', 'Sub_admin', '', '8527977677', '8527977677', 'ajay123', 'ranibagh');

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

--
-- Table structure for table `tbl_banner`
--

CREATE TABLE `tbl_banner` (
  `banner_id` int(11) NOT NULL,
  `banner_title` varchar(200) NOT NULL,
  `banner_position` int(11) NOT NULL,
  `banner_link` varchar(400) NOT NULL,
  `banner_alt` varchar(200) NOT NULL,
  `banner_image` varchar(300) NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `banner_category` varchar(400) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_banner`
--

INSERT INTO `tbl_banner` (`banner_id`, `banner_title`, `banner_position`, `banner_link`, `banner_alt`, `banner_image`, `pg_status`, `date_time`, `banner_category`) VALUES
(1, 'banner1', 1, '', 'banner1', '1547138696dining.jpg', 'Active', '2019-01-10 16:54:51', ''),
(4, 'Banner2', 2, '', 'banner2', '1547139302Fortune-home.jpg', 'Active', '2019-01-10 16:55:06', ''),
(5, 'banner3', 0, '', 'banner3', '1547139320Fortune-home1.jpg', 'Active', '2019-01-10 16:55:20', ''),
(6, 'banner4', 0, '', 'banner4', '1547139351standard-rooms.jpg', 'Active', '2019-01-10 16:55:51', '');

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

--
-- Table structure for table `tbl_blog`
--

CREATE TABLE `tbl_blog` (
  `blog_id` int(11) NOT NULL,
  `blog_category` int(11) NOT NULL,
  `blog_title` varchar(250) NOT NULL,
  `pg_url` varchar(300) NOT NULL,
  `blog_by` varchar(200) NOT NULL,
  `date` varchar(100) NOT NULL,
  `image` varchar(300) NOT NULL,
  `sort_description` varchar(400) NOT NULL,
  `description` text NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pg_meta_title` varchar(200) NOT NULL,
  `pg_meta_keyword` varchar(400) NOT NULL,
  `pg_meta_desc` varchar(600) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_blog`
--

INSERT INTO `tbl_blog` (`blog_id`, `blog_category`, `blog_title`, `pg_url`, `blog_by`, `date`, `image`, `sort_description`, `description`, `pg_status`, `date_time`, `pg_meta_title`, `pg_meta_keyword`, `pg_meta_desc`) VALUES
(1, 1, 'Voluptatem accusantium doloremque laudantium', 'voluptatem-accusantium-doloremque-laudantium', 'Krishna', '10 July  2017', '1509707582smbg2.jpg', 'Sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.', '<p>&nbsp;Sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.Sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.Sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>', 'Active', '2017-11-03 11:13:02', 'Voluptatem accusantium doloremque laudantium', '', ''),
(2, 1, 'Dolorem eum fugiat quo voluptas nulla pariatur', 'dolorem-eum-fugiat-quo-voluptas-nulla-pariatur', 'Ajay', '10 July 2017', '1499669005blog_big_03.jpg', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '<p>&nbsp;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum...</p>', 'Active', '2017-11-03 10:46:25', 'Dolorem eum fugiat quo voluptas nulla pariatur', '', ''),
(3, 3, 'Blog3', 'blog3', 'Rashmi', '10 July 2017', '1499669900post2.jpg', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '<p>&nbsp;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum...</p>', 'Active', '2017-11-03 10:46:31', 'Blog3', '', ''),
(4, 3, 'Blog4', 'blog4', 'Mukesh Rana', '10 July 2017', '1499669331blog_big_02.jpg', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. ', '<p>&nbsp;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum...</p>', 'Active', '2017-11-03 10:46:40', 'Blog4', '', '');

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

--
-- Table structure for table `tbl_blog_category`
--

CREATE TABLE `tbl_blog_category` (
  `blog_cat_id` int(11) NOT NULL,
  `blog_category` varchar(500) NOT NULL,
  `pg_url` varchar(500) NOT NULL,
  `pg_status` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_blog_category`
--

INSERT INTO `tbl_blog_category` (`blog_cat_id`, `blog_category`, `pg_url`, `pg_status`) VALUES
(1, 'Gems', 'gems', 'Active'),
(2, 'Gemstone', 'gemstone', 'Active'),
(3, 'jewellery', 'jewellery', 'Active');

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

--
-- Table structure for table `tbl_blog_comment`
--

CREATE TABLE `tbl_blog_comment` (
  `comment_id` int(11) NOT NULL,
  `blog_id` varchar(400) NOT NULL,
  `name` varchar(500) NOT NULL,
  `company` varchar(500) NOT NULL,
  `comment` text NOT NULL,
  `pg_status` varchar(400) NOT NULL,
  `date` date NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_blog_comment`
--

INSERT INTO `tbl_blog_comment` (`comment_id`, `blog_id`, `name`, `company`, `comment`, `pg_status`, `date`, `date_time`, `time`) VALUES
(1, '1', 'Krishna Kant', 'Brand bugle', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.', 'Active', '2017-11-06', '2017-11-06 09:53:01', '15:15:57'),
(2, '1', 'Himanshu', 'Brand bugle', 'data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. ', 'Active', '2017-11-06', '2017-11-06 10:30:14', '15:59:50'),
(3, '1', 'Ajay', '', 'data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon.', 'Active', '2017-11-06', '2017-11-06 10:32:39', '16:02:29'),
(4, '1', 'Raman', '', 'data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.data is coming soon. data is coming soon. data is coming soon.', 'Active', '2017-11-06', '2017-11-06 10:35:39', '16:05:20');

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

--
-- Table structure for table `tbl_color`
--

CREATE TABLE `tbl_color` (
  `color_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `color_title` varchar(400) NOT NULL,
  `color_code` varchar(400) NOT NULL,
  `image` varchar(500) NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `data_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_color`
--

INSERT INTO `tbl_color` (`color_id`, `product_id`, `color_title`, `color_code`, `image`, `pg_status`, `data_time`) VALUES
(1, 1, 'Gray', '#ccc', '1499937962p29.jpg', 'Active', '2017-07-13 09:26:02'),
(2, 1, 'Brown', '#RRGGBB', '1499937830p30.jpg', 'Active', '2017-07-13 09:23:50');

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

--
-- Table structure for table `tbl_compare`
--

CREATE TABLE `tbl_compare` (
  `compare_id` int(11) NOT NULL,
  `product_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `b_url` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_compare`
--

INSERT INTO `tbl_compare` (`compare_id`, `product_id`, `user_id`, `date_time`, `b_url`) VALUES
(1, '2', '83', '2017-11-03 07:32:23', 'pukhraj/natural-ceylon-pukhraj'),
(2, '9', '83', '2017-11-03 07:32:43', 'pukhraj/natural-ceylon-pukhraj'),
(3, '4', '83', '2017-11-03 07:33:00', 'pukhraj'),
(4, '18', '83', '2017-11-03 07:33:19', 'pukhraj/natural-heated-ceylon-pukhraj'),
(5, '8', '83', '2017-11-03 07:33:31', 'pukhraj/natural-ceylon-pukhraj'),
(6, '11', '83', '2017-11-03 08:04:11', 'pukhraj');

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

--
-- Table structure for table `tbl_contact`
--

CREATE TABLE `tbl_contact` (
  `contact_id` int(11) NOT NULL,
  `contact_person` varchar(200) NOT NULL,
  `mobile_no` varchar(100) NOT NULL,
  `whatsapp_no` varchar(100) NOT NULL,
  `phone_no` varchar(100) NOT NULL,
  `email_id` varchar(400) NOT NULL,
  `alt_email` varchar(400) NOT NULL,
  `address` varchar(3000) NOT NULL,
  `google_map` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contact`
--

INSERT INTO `tbl_contact` (`contact_id`, `contact_person`, `mobile_no`, `whatsapp_no`, `phone_no`, `email_id`, `alt_email`, `address`, `google_map`, `date_time`) VALUES
(1, 'The River Crescent Resort', '+91-98888 98888', '9888888888', '01111-242424', 'sambhavsawhney@gmail.com', '', '2558-1, V.P.O., Rangri, Manali, District Kullu, H.P. - 175131, India', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3375.6303257906156!2d77.1863717151678!3d32.214190481145586!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39048806ccbb0e8f%3A0xc9c1ff748d719f70!2sThe+River+Crescent+Resort!5e0!3m2!1sen!2sin!4v1546493604204" width="100%" height="200" frameborder="0" style="border:0" allowfullscreen></iframe>', '2019-01-10 16:31:48');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `country_id` int(11) NOT NULL,
  `country_code` varchar(400) NOT NULL,
  `country_name` varchar(1000) NOT NULL,
  `pg_status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`country_id`, `country_code`, `country_name`, `pg_status`) VALUES
(1, 'ad', 'Andorra', 'Active'),
(2, 'ae', 'United Arab Emirates', 'Active'),
(3, 'af', 'Afghanistan', 'Active'),
(4, 'ag', 'Antigua and Barbuda', 'Active'),
(5, 'ai', 'Anguilla', 'Active'),
(6, 'al', 'Albania', 'Active'),
(7, 'am', 'Armenia', 'Active'),
(8, 'an', 'Netherlands Antilles', 'Active'),
(9, 'ao', 'Angola', 'Active'),
(10, 'aq', 'Antarctica', 'Active'),
(11, 'ar', 'Argentina', 'Active'),
(12, 'arpa', 'Old style Arpanet', 'Active'),
(13, 'as', 'American Samoa', 'Active'),
(14, 'at', 'Austria', 'Active'),
(15, 'au', 'Australia', 'Active'),
(16, 'aw', 'Aruba', 'Active'),
(17, 'az', 'Azerbaidjan', 'Active'),
(18, 'ba', 'Bosnia-Herzegovina', 'Active'),
(19, 'bb', 'Barbados', 'Active'),
(20, 'bd', 'Bangladesh', 'Active'),
(21, 'be', 'Belgium', 'Active'),
(22, 'bf', 'Burkina Faso', 'Active'),
(23, 'bg', 'Bulgaria', 'Active'),
(24, 'bh', 'Bahrain', 'Active'),
(25, 'bi', 'Burundi', 'Active'),
(26, 'bj', 'Benin', 'Active'),
(27, 'bm', 'Bermuda', 'Active'),
(28, 'bn', 'Brunei Darussalam', 'Active'),
(29, 'bo', 'Bolivia', 'Active'),
(30, 'br', 'Brazil', 'Active'),
(31, 'bs', 'Bahamas', 'Active'),
(32, 'bt', 'Bhutan', 'Active'),
(33, 'bv', 'Bouvet Island', 'Active'),
(34, 'bw', 'Botswana', 'Active'),
(35, 'by', 'Belarus', 'Active'),
(36, 'bz', 'Belize', 'Active'),
(37, 'ca', 'Canada', 'Active'),
(38, 'cc', 'Cocos (Keeling) Islands', 'Active'),
(39, 'cf', 'Central African Republic', 'Active'),
(40, 'cg', 'Congo', 'Active'),
(41, 'ch', 'Switzerland', 'Active'),
(42, 'ck', 'Cook Islands', 'Active'),
(43, 'cl', 'Chile', 'Active'),
(44, 'cm', 'Cameroon', 'Active'),
(45, 'cn', 'China', 'Active'),
(46, 'co', 'Colombia', 'Active'),
(47, 'com', 'Commercial', 'Active'),
(48, 'cr', 'Costa Rica', 'Active'),
(49, 'cs', 'Former Czechoslovakia', 'Active'),
(50, 'cu', 'Cuba', 'Active'),
(51, 'cv', 'Cape Verde', 'Active'),
(52, 'cx', 'Christmas Island', 'Active'),
(53, 'cy', 'Cyprus', 'Active'),
(54, 'cz', 'Czech Republic', 'Active'),
(55, 'de', 'Germany', 'Active'),
(56, 'dj', 'Djibouti', 'Active'),
(57, 'dk', 'Denmark', 'Active'),
(58, 'dm', 'Dominica', 'Active'),
(59, 'do', 'Dominican Republic', 'Active'),
(60, 'dz', 'Algeria', 'Active'),
(61, 'ec', 'Ecuador', 'Active'),
(62, 'edu', 'USA Educational', 'Active'),
(63, 'ee', 'Estonia', 'Active'),
(64, 'eg', 'Egypt', 'Active'),
(65, 'eh', 'Western Sahara', 'Active'),
(66, 'er', 'Eritrea', 'Active'),
(67, 'es', 'Spain', 'Active'),
(68, 'et', 'Ethiopia', 'Active'),
(69, 'fi', 'Finland', 'Active'),
(70, 'fj', 'Fiji', 'Active'),
(71, 'fk', 'Falkland Islands', 'Active'),
(72, 'fm', 'Micronesia', 'Active'),
(73, 'fo', 'Faroe Islands', 'Active'),
(74, 'fr', 'France', 'Active'),
(75, 'fx', 'France (European Territory)', 'Active'),
(76, 'ga', 'Gabon', 'Active'),
(77, 'gb', 'Great Britain', 'Active'),
(78, 'gd', 'Grenada', 'Active'),
(79, 'ge', 'Georgia', 'Active'),
(80, 'gf', 'French Guyana', 'Active'),
(81, 'gh', 'Ghana', 'Active'),
(82, 'gi', 'Gibraltar', 'Active'),
(83, 'gl', 'Greenland', 'Active'),
(84, 'gm', 'Gambia', 'Active'),
(85, 'gn', 'Guinea', 'Active'),
(86, 'gov', 'USA Government', 'Active'),
(87, 'gp', 'Guadeloupe (French)', 'Active'),
(88, 'gq', 'Equatorial Guinea', 'Active'),
(89, 'gr', 'Greece', 'Active'),
(90, 'gs', 'S. Georgia & S. Sandwich Isls.', 'Active'),
(91, 'gt', 'Guatemala', 'Active'),
(92, 'gu', 'Guam (USA)', 'Active'),
(93, 'gw', 'Guinea Bissau', 'Active'),
(94, 'gy', 'Guyana', 'Active'),
(95, 'hk', 'Hong Kong', 'Active'),
(96, 'hm', 'Heard and McDonald Islands', 'Active'),
(97, 'hn', 'Honduras', 'Active'),
(98, 'hr', 'Croatia', 'Active'),
(99, 'ht', 'Haiti', 'Active'),
(100, 'hu', 'Hungary', 'Active'),
(101, 'id', 'Indonesia', 'Active'),
(102, 'ie', 'Ireland', 'Active'),
(103, 'il', 'Israel', 'Active'),
(104, 'in', 'India', 'Active'),
(105, 'int', 'International', 'Active'),
(106, 'io', 'British Indian Ocean Territory', 'Active'),
(107, 'iq', 'Iraq', 'Active'),
(108, 'ir', 'Iran', 'Active'),
(109, 'is', 'Iceland', 'Active'),
(110, 'it', 'Italy', 'Active'),
(111, 'jm', 'Jamaica', 'Active'),
(112, 'jo', 'Jordan', 'Active'),
(113, 'jp', 'Japan', 'Active'),
(114, 'ke', 'Kenya', 'Active'),
(115, 'kg', 'Kyrgyzstan', 'Active'),
(116, 'kh', 'Cambodia', 'Active'),
(117, 'ki', 'Kiribati', 'Active'),
(118, 'km', 'Comoros', 'Active'),
(119, 'kn', 'Saint Kitts & Nevis Anguilla', 'Active'),
(120, 'kp', 'North Korea', 'Active'),
(121, 'kr', 'South Korea', 'Active'),
(122, 'kw', 'Kuwait', 'Active'),
(123, 'ky', 'Cayman Islands', 'Active'),
(124, 'kz', 'Kazakhstan', 'Active'),
(125, 'la', 'Laos', 'Active'),
(126, 'lb', 'Lebanon', 'Active'),
(127, 'lc', 'Saint Lucia', 'Active'),
(128, 'li', 'Liechtenstein', 'Active'),
(129, 'lk', 'Sri Lanka', 'Active'),
(130, 'lr', 'Liberia', 'Active'),
(131, 'ls', 'Lesotho', 'Active'),
(132, 'lt', 'Lithuania', 'Active'),
(133, 'lu', 'Luxembourg', 'Active'),
(134, 'lv', 'Latvia', 'Active'),
(135, 'ly', 'Libya', 'Active'),
(136, 'ma', 'Morocco', 'Active'),
(137, 'mc', 'Monaco', 'Active'),
(138, 'md', 'Moldavia', 'Active'),
(139, 'mg', 'Madagascar', 'Active'),
(140, 'mh', 'Marshall Islands', 'Active'),
(141, 'mil', 'USA Military', 'Active'),
(142, 'mk', 'Macedonia', 'Active'),
(143, 'ml', 'Mali', 'Active'),
(144, 'mm', 'Myanmar', 'Active'),
(145, 'mn', 'Mongolia', 'Active'),
(146, 'mo', 'Macau', 'Active'),
(147, 'mp', 'Northern Mariana Islands', 'Active'),
(148, 'mq', 'Martinique (French)', 'Active'),
(149, 'mr', 'Mauritania', 'Active'),
(150, 'ms', 'Montserrat', 'Active'),
(151, 'mt', 'Malta', 'Active'),
(152, 'mu', 'Mauritius', 'Active'),
(153, 'mv', 'Maldives', 'Active'),
(154, 'mw', 'Malawi', 'Active'),
(155, 'mx', 'Mexico', 'Active'),
(156, 'my', 'Malaysia', 'Active'),
(157, 'mz', 'Mozambique', 'Active'),
(158, 'na', 'Namibia', 'Active'),
(159, 'nato', 'NATO (this was purged in 1996 - see hq.nato.int)', 'Active'),
(160, 'nc', 'New Caledonia (French)', 'Active'),
(161, 'ne', 'Niger', 'Active'),
(162, 'net', 'Network', 'Active'),
(163, 'nf', 'Norfolk Island', 'Active'),
(164, 'ng', 'Nigeria', 'Active'),
(165, 'ni', 'Nicaragua', 'Active'),
(166, 'nl', 'Netherlands', 'Active'),
(167, 'no', 'Norway', 'Active'),
(168, 'np', 'Nepal', 'Active'),
(169, 'nr', 'Nauru', 'Active'),
(170, 'nt', 'Neutral Zone', 'Active'),
(171, 'nu', 'Niue', 'Active'),
(172, 'nz', 'New Zealand', 'Active'),
(173, 'om', 'Oman', 'Active'),
(174, 'org', 'Non-Profit Making Organisations (sic)', 'Active'),
(175, 'pa', 'Panama', 'Active'),
(176, 'pe', 'Peru', 'Active'),
(177, 'pf', 'Polynesia (French)', 'Active'),
(178, 'pg', 'Papua New Guinea', 'Active'),
(179, 'ph', 'Philippines', 'Active'),
(180, 'pk', 'Pakistan', 'Active'),
(181, 'pl', 'Poland', 'Active'),
(182, 'pm', 'Saint Pierre and Miquelon', 'Active'),
(183, 'pn', 'Pitcairn Island', 'Active'),
(184, 'pr', 'Puerto Rico', 'Active'),
(185, 'pt', 'Portugal', 'Active'),
(186, 'pw', 'Palau', 'Active'),
(187, 'py', 'Paraguay', 'Active'),
(188, 'qa', 'Qatar', 'Active'),
(189, 're', 'Reunion (French)', 'Active'),
(190, 'ro', 'Romania', 'Active'),
(191, 'ru', 'Russian Federation', 'Active'),
(192, 'rw', 'Rwanda', 'Active'),
(193, 'sa', 'Saudi Arabia', 'Active'),
(194, 'sb', 'Solomon Islands', 'Active'),
(195, 'sc', 'Seychelles', 'Active'),
(196, 'sd', 'Sudan', 'Active'),
(197, 'se', 'Sweden', 'Active'),
(198, 'sg', 'Singapore', 'Active'),
(199, 'sh', 'Saint Helena', 'Active'),
(200, 'si', 'Slovenia', 'Active'),
(201, 'sj', 'Svalbard and Jan Mayen Islands', 'Active'),
(202, 'sk', 'Slovak Republic', 'Active'),
(203, 'sl', 'Sierra Leone', 'Active'),
(204, 'sm', 'San Marino', 'Active'),
(205, 'sn', 'Senegal', 'Active'),
(206, 'so', 'Somalia', 'Active'),
(207, 'sr', 'Suriname', 'Active'),
(208, 'st', 'Saint Tome (Sao Tome) and Principe', 'Active'),
(209, 'su', 'Former USSR', 'Active'),
(210, 'sv', 'El Salvador', 'Active'),
(211, 'sy', 'Syria', 'Active'),
(212, 'sz', 'Swaziland', 'Active'),
(213, 'tc', 'Turks and Caicos Islands', 'Active'),
(214, 'td', 'Chad', 'Active'),
(215, 'tf', 'French Southern Territories', 'Active'),
(216, 'tg', 'Togo', 'Active'),
(217, 'th', 'Thailand', 'Active'),
(218, 'tj', 'Tadjikistan', 'Active'),
(219, 'tk', 'Tokelau', 'Active'),
(220, 'tm', 'Turkmenistan', 'Active'),
(221, 'tn', 'Tunisia', 'Active'),
(222, 'to', 'Tonga', 'Active'),
(223, 'tp', 'East Timor', 'Active'),
(224, 'tr', 'Turkey', 'Active'),
(225, 'tt', 'Trinidad and Tobago', 'Active'),
(226, 'tv', 'Tuvalu', 'Active'),
(227, 'tw', 'Taiwan', 'Active'),
(228, 'tz', 'Tanzania', 'Active'),
(229, 'ua', 'Ukraine', 'Active'),
(230, 'ug', 'Uganda', 'Active'),
(231, 'uk', 'United Kingdom', 'Active'),
(232, 'um', 'USA Minor Outlying Islands', 'Active'),
(233, 'us', 'United States', 'Active'),
(234, 'uy', 'Uruguay', 'Active'),
(235, 'uz', 'Uzbekistan', 'Active'),
(236, 'va', 'Vatican City State', 'Active'),
(237, 'vc', 'Saint Vincent & Grenadines', 'Active'),
(238, 've', 'Venezuela', 'Active'),
(239, 'vg', 'Virgin Islands (British)', 'Active'),
(240, 'vi', 'Virgin Islands (USA)', 'Active'),
(241, 'vn', 'Vietnam', 'Active'),
(242, 'vu', 'Vanuatu', 'Active'),
(243, 'wf', 'Wallis and Futuna Islands', 'Active'),
(244, 'ws', 'Samoa', 'Active'),
(245, 'ye', 'Yemen', 'Active'),
(246, 'yt', 'Mayotte', 'Active'),
(247, 'yu', 'Yugoslavia', 'Active'),
(248, 'za', 'South Africa', 'Active'),
(249, 'zm', 'Zambia', 'Active'),
(250, 'zr', 'Zaire', 'Active'),
(251, 'zw', 'Zimbabwe', 'Active');

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

--
-- Table structure for table `tbl_cuser`
--

CREATE TABLE `tbl_cuser` (
  `cuser_id` double NOT NULL,
  `user_session_id` varchar(500) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_ip` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cuser`
--

INSERT INTO `tbl_cuser` (`cuser_id`, `user_session_id`, `date_time`, `user_ip`) VALUES
(1, 'sbl94cbc5nlm084rcnau6rnj80', '2017-10-12 11:27:53', '::1'),
(2, 'onivoejlqrlh6m2gjb6hm3v6q7', '2017-10-13 05:22:29', '::1'),
(3, 't46ec55qvuscbpjebh3ojbghp3', '2017-10-14 08:09:54', '::1'),
(4, 'r7rjvrj5u5neqf3c8q6eu30i23', '2017-10-31 06:06:34', '::1'),
(5, 'r7rjvrj5u5neqf3c8q6eu30i23', '2017-10-31 11:12:48', '::1'),
(6, 'j1dmi71qqccfqpfjfv103pce84', '2017-11-01 05:08:06', '::1'),
(7, 't8pjl56usm81ju9lh86aop59q7', '2017-11-01 10:27:42', '::1'),
(8, 't8pjl56usm81ju9lh86aop59q7', '2017-11-01 10:30:52', '::1'),
(9, 't8pjl56usm81ju9lh86aop59q7', '2017-11-01 11:47:15', '::1'),
(10, 'g7721hpjg085419gedjcbbpj27', '2017-11-02 05:22:29', '::1'),
(11, 'g7721hpjg085419gedjcbbpj27', '2017-11-02 06:24:19', '::1'),
(12, 'g7721hpjg085419gedjcbbpj27', '2017-11-02 06:35:11', '::1'),
(13, 'g7721hpjg085419gedjcbbpj27', '2017-11-02 06:35:40', '::1'),
(14, 'g7721hpjg085419gedjcbbpj27', '2017-11-02 06:53:10', '::1'),
(15, 'punsevcdn68k2q1v1nui4oa315', '2017-11-03 07:32:54', '::1'),
(16, '9qoe1v85bluhev6v5nglk141m7', '2017-11-07 07:39:04', '::1'),
(17, '73r0dc6tdvlv0jgq2q6mte7jj0', '2017-11-08 07:28:50', '::1'),
(18, 'ecu9tipcdvo5g6quggdvctgtj6', '2017-11-13 07:46:57', '::1'),
(19, 'ecu9tipcdvo5g6quggdvctgtj6', '2017-11-13 10:34:12', '::1'),
(20, '0lg1eq4okvnrbo2jba759lict5', '2017-11-14 08:11:52', '::1'),
(21, '3onhs64ouls5or19lte4946jr7', '2017-11-15 07:44:12', '::1'),
(22, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:05:09', '::1'),
(23, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:08:38', '::1'),
(24, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:12:58', '::1'),
(25, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:18:32', '::1'),
(26, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:22:11', '::1'),
(27, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:28:03', '::1'),
(28, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 08:37:31', '::1'),
(29, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 09:39:31', '::1'),
(30, 'gspvkqd1cpdr4d3ntnkm0iog41', '2017-11-17 09:42:05', '::1'),
(31, '6qa1k8ferkt6gvvffm9e8gfsm3', '2017-11-18 11:46:40', '::1'),
(32, '2l0brei99j6n0ivodgdf6sph63', '2017-11-22 11:41:52', '::1'),
(33, '2l0brei99j6n0ivodgdf6sph63', '2017-11-22 11:50:52', '::1'),
(34, '2l0brei99j6n0ivodgdf6sph63', '2017-11-22 12:12:54', '::1'),
(35, 'i2hvu234qiod3n1rcmepshcjs7', '2017-11-27 11:59:29', '::1'),
(36, 'tc8ec1t0ptcuhdbuaf8mhn5be2', '2017-12-07 07:40:41', '::1'),
(37, 'tc8ec1t0ptcuhdbuaf8mhn5be2', '2017-12-07 09:49:43', '::1'),
(38, 'pbulnjuk16oootknbbmusou576', '2017-12-08 11:08:10', '::1'),
(39, 'gldtok8cavq5avu97b5in0a2a6', '2017-12-09 06:19:20', '::1'),
(40, '977c6k2bmsk0jtr824tgma5id3', '2017-12-29 11:19:46', '::1'),
(41, 'dtq8a16b0r9kkse1jai7aqpo32', '2018-01-03 08:38:18', '::1');

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

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

CREATE TABLE `tbl_gallery` (
  `gallery_id` int(11) NOT NULL,
  `gallery_category` int(11) NOT NULL,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_link` text,
  `gallery_position` varchar(300) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `pg_status` varchar(200) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gallery_alt` varchar(300) DEFAULT NULL,
  `logo_image` varchar(400) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`gallery_id`, `gallery_category`, `gallery_title`, `gallery_link`, `gallery_position`, `gallery_image`, `pg_status`, `date_time`, `gallery_alt`, `logo_image`) VALUES
(1, 0, 'g1', '', '', '15471416761.jpg', 'Active', '2019-01-10 17:34:36', 'g1', ''),
(2, 0, 'g2', '', '', '15471423182.jpg', 'Active', '2019-01-10 17:45:18', 'g2', ''),
(3, 0, 'g3', '', '', '15471423283.jpg', 'Active', '2019-01-10 17:45:28', 'g3', ''),
(4, 0, 'g4', '', '', '15471423374.jpg', 'Active', '2019-01-10 17:45:37', 'g4', ''),
(5, 0, 'g5', '', '', '15471423465.jpg', 'Active', '2019-01-10 17:45:46', 'g5', ''),
(6, 0, 'g6', '', '', '15471423546.jpg', 'Active', '2019-01-10 17:45:54', 'g6', ''),
(7, 0, 'g7', '', '', '15471423647.jpg', 'Active', '2019-01-10 17:46:04', 'g7', ''),
(8, 0, 'g8', '', '', '15471423738.jpg', 'Active', '2019-01-10 17:46:13', 'g8', '');

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

--
-- Table structure for table `tbl_gallery_category`
--

CREATE TABLE `tbl_gallery_category` (
  `gallery_cat_id` int(11) NOT NULL,
  `gallery_category_title` varchar(300) DEFAULT NULL,
  `pg_url` text NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `image` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_gallery_category`
--

INSERT INTO `tbl_gallery_category` (`gallery_cat_id`, `gallery_category_title`, `pg_url`, `status`, `date_time`, `image`) VALUES
(1, 'Gallery', '', 'Active', '2017-01-21 07:32:56', ''),
(2, 'Banner', '', 'Active', '2017-01-21 07:33:05', '');

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

--
-- Table structure for table `tbl_inquiry`
--

CREATE TABLE `tbl_inquiry` (
  `inquiry_id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `email` varchar(300) NOT NULL,
  `message` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_location`
--

CREATE TABLE `tbl_location` (
  `location_id` int(11) NOT NULL,
  `location_title` varchar(500) NOT NULL,
  `location_map` varchar(5000) NOT NULL,
  `pg_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `default_location` enum('Yes','No') NOT NULL DEFAULT 'No',
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `image` varchar(1000) NOT NULL,
  `location_category` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_location`
--

INSERT INTO `tbl_location` (`location_id`, `location_title`, `location_map`, `pg_status`, `default_location`, `date_time`, `image`, `location_category`) VALUES
(1, 'New delhi', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d448183.73912804417!2d76.8130664011526!3d28.646677246352574!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x390cfd5b347eb62d%3A0x37205b715389640!2sDelhi!5e0!3m2!1sen!2sin!4v1500886199200', 'Active', 'Yes', '2017-09-04 11:20:26', '150088751811delhi.jpg', '1'),
(2, 'Agra', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d113579.63202937754!2d77.90997189214747!3d27.176309823512476!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39740d857c2f41d9%3A0x784aef38a9523b42!2sAgra%2C+Uttar+Pradesh!5e0!3m2!1sen!2sin!4v1500887750084', 'Active', 'No', '2017-09-04 11:21:20', '1500887814agra.jpg', '1'),
(3, 'Mumbai', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d241316.2826149831!2d72.74111790713515!3d19.082769888237923!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3be7c6306644edc1%3A0x5da4ed8f8d648c69!2sMumbai%2C+Maharashtra!5e0!3m2!1sen!2sin!4v1500888186054', 'Active', 'No', '2017-09-04 11:21:26', '1500888217mumbai.jpg', '1'),
(4, 'Kolkata', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d471219.3180239025!2d88.05200813208788!3d22.676114411006232!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39f882db4908f667%3A0x43e330e68f6c2cbc!2sKolkata%2C+West+Bengal!5e0!3m2!1sen!2sin!4v1500888602941', 'Active', 'No', '2017-09-04 11:21:33', '1500888708kolkata.jpg', '1'),
(5, 'Shimla', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d54674.09294737104!2d77.12400155219835!3d31.07828818084553!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x390578e3e35d6e67%3A0x1f7e7ff6ff9f54b7!2sShimla%2C+Himachal+Pradesh!5e0!3m2!1sen!2sin!4v1500888790488', 'Active', 'No', '2017-09-04 11:21:51', '1500888943shim;la.jpg', '1');

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

--
-- Table structure for table `tbl_member`
--

CREATE TABLE `tbl_member` (
  `member_id` int(11) NOT NULL,
  `member_name` varchar(500) NOT NULL,
  `member_designation` varchar(500) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pg_status` varchar(300) NOT NULL,
  `image` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_member`
--

INSERT INTO `tbl_member` (`member_id`, `member_name`, `member_designation`, `date_time`, `pg_status`, `image`, `description`) VALUES
(1, 'Gaurav Sabhlok', 'Managing director', '2018-01-29 12:04:19', 'Active', '1517227459user_man.png', '<p>To build a great company, sometimes you have to stand up against conventional wisdom.</p>\r\n'),
(2, 'Nagender Chhabra', 'Managing director', '2018-01-29 12:05:09', 'Active', '1517227509user_man.png', '<p>At first they will ask, why you are doing it. Later they will ask how you did it.</p>\r\n'),
(3, 'Ajay Kumar', 'Digital Manager', '2018-01-29 12:05:59', 'Active', '1517227559Ajay.jpg', '<p>Good management consists in showing average people how to do the work of superior people.</p>\r\n'),
(4, 'Vishal Goel', 'Sales Manager', '2018-01-29 12:09:11', 'Active', '1517227751vishal.jpg', '<p>Sometimes you don&#39;t realize your strength until you come face to face with your greatest strength.</p>\r\n'),
(5, 'Aastha Makkar', 'Account Manager', '2018-01-29 12:10:17', 'Active', '1517227817femail-icon.png', '<p>Sometimes you don&#39;t realize your strength until you come face to face with your greatest strength.</p>\r\n'),
(6, 'Krishna Kant Kumar', 'Web developer', '2018-01-29 12:10:58', 'Active', '1517227858user_man.png', '<p>Sometimes you don&#39;t realize your strength until you come face to face with your greatest strength.</p>\r\n'),
(7, 'Ankush Chawla', 'Sales Executive', '2018-01-29 12:12:12', 'Active', '1517227932Ankush.jpg', '<p>It&rsquo;s not about having the right opportunities. It&rsquo;s about handling the opportunities right.</p>\r\n'),
(8, 'Ramandeep Singh', 'Sales Executive', '2018-01-29 12:13:02', 'Active', '1517227982user_man.png', '<p>Sometimes you don&#39;t realize your strength until you come face to face with your greatest strength.</p>\r\n'),
(9, 'Avtar Singh', 'Video Editor', '2018-01-29 12:14:26', 'Active', '1517228066Avtar.jpg', '<p>Social media is not about the exploitation of technology but service to community.</p>\r\n'),
(10, 'Sanjna Gupta', 'Creative Designer', '2018-01-29 12:15:28', 'Active', '1517228128Sanjana.jpg', '<p>Create your own visual style let it be unique for yourself and yet identifiable for others.</p>\r\n'),
(11, 'Somi Ali', 'SEO Executive', '2018-01-29 12:16:11', 'Active', '1517228171somi.jpg', '<p>SEO is not about Search Engine Optimization, it&#39;s all about User Experience optimization.</p>\r\n'),
(12, 'Sonali Kohli', 'Content Writer', '2018-01-29 12:17:03', 'Active', '1517228223Sonali.jpg', '<p>When something can be&nbsp; read without effort,&nbsp; great effort has gone into its writing.</p>\r\n'),
(13, 'Kehkasha Salmani', 'Creative Designer', '2018-01-29 12:17:36', 'Active', '1517228256Kehkasha.jpg', '<p>SEO is not about Search Engine Optimization, it&#39;s all about User Experience optimization.</p>\r\n'),
(14, 'Shubham', 'Account Assistant', '2018-01-29 12:18:08', 'Active', '1517228288Shubham.jpg', '<p>Sometimes you don&#39;t realize your strength until you come face to face with your greatest strength.</p>\r\n'),
(15, 'Pankaj Paul', 'Social Media Executive', '2018-01-29 12:18:41', 'Active', '1517228321Pankaj.jpg', '<p>Social media is not about the exploitation of technology but service to community.</p>\r\n'),
(16, 'Himanshu Mittal', 'Web Developer', '2018-01-29 12:19:19', 'Active', '1517228359Himanshu.JPG', '<p>Social media is not about the exploitation of technology but service to community.</p>\r\n');

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

--
-- Table structure for table `tbl_more_url`
--

CREATE TABLE `tbl_more_url` (
  `pg_id` int(11) NOT NULL,
  `pg_name` varchar(300) NOT NULL,
  `pg_url` varchar(300) NOT NULL,
  `pg_meta_title` varchar(300) NOT NULL,
  `pg_meta_keyword` varchar(500) NOT NULL,
  `pg_meta_desc` varchar(700) NOT NULL,
  `description` text NOT NULL,
  `pg_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  `pg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pg_type` text NOT NULL,
  `video_url1` text NOT NULL,
  `video_url2` text NOT NULL,
  `video_url3` text NOT NULL,
  `video_url4` text NOT NULL,
  `image` varchar(500) NOT NULL,
  `prod_cat_id` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_more_url`
--

INSERT INTO `tbl_more_url` (`pg_id`, `pg_name`, `pg_url`, `pg_meta_title`, `pg_meta_keyword`, `pg_meta_desc`, `description`, `pg_status`, `pg_date`, `pg_type`, `video_url1`, `video_url2`, `video_url3`, `video_url4`, `image`, `prod_cat_id`) VALUES
(1, 'kk designer in delhi', 'kk-designer-in-delhi', 'kk designer in delhi', '', '', '<p>kk designer in delhikk designer in delhikk designer in delhikk designer in delhikk designer in delhikk designer in delhi</p>\r\n', 'Active', '2018-01-31 07:18:19', '', '', '', '', '', '', '1');

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

--
-- Table structure for table `tbl_newsletter`
--

CREATE TABLE `tbl_newsletter` (
  `newsletter_id` int(11) NOT NULL,
  `email` varchar(500) NOT NULL,
  `pg_status` varchar(200) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_newsletter`
--

INSERT INTO `tbl_newsletter` (`newsletter_id`, `email`, `pg_status`, `date_time`) VALUES
(1, 'iandu445@gmail.com', 'Active', '2017-09-16 07:09:13'),
(2, 'somi.brandbugle@gmail.com', 'Active', '2017-09-16 07:10:15'),
(3, 'iandu445@gmail.com', '', '2017-11-22 05:58:38'),
(4, 'iandu445@gmail.com', '', '2017-11-22 06:00:32'),
(5, 'iandu445@gmail.com', '', '2017-11-22 06:06:28');

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

--
-- Table structure for table `tbl_order`
--

CREATE TABLE `tbl_order` (
  `odr_id` int(11) NOT NULL,
  `order_by` varchar(400) NOT NULL,
  `payment_status` varchar(100) NOT NULL,
  `payment_method` varchar(400) NOT NULL,
  `userid` varchar(400) NOT NULL,
  `cuser_session_id` varchar(500) NOT NULL,
  `cuser` varchar(500) NOT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `order_status` varchar(500) NOT NULL,
  `order_action` varchar(100) NOT NULL,
  `order_status_remarks` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_order`
--

INSERT INTO `tbl_order` (`odr_id`, `order_by`, `payment_status`, `payment_method`, `userid`, `cuser_session_id`, `cuser`, `order_date`, `order_time`, `date_time`, `order_status`, `order_action`, `order_status_remarks`) VALUES
(1, 'GS10029', 'Pending', '2', '83', 'gspvkqd1cpdr4d3ntnkm0iog41', 'GS10029', '2017-11-17', '03:10:00', '2017-11-17 12:02:20', '2', '', 'DRYRTY'),
(2, 'GS10030', 'Pending', '3', '83', 'gspvkqd1cpdr4d3ntnkm0iog41', 'GS10030', '2017-11-17', '03:12:00', '2017-11-18 07:37:23', '1', '', 'wrrt'),
(3, 'GS10032', 'Pending', '2', '83', '2l0brei99j6n0ivodgdf6sph63', 'GS10032', '2017-11-22', '05:12:00', '2017-11-22 11:42:16', '1', '', ''),
(4, '', 'Pending', '2', '83', '', '', '2017-11-22', '05:13:00', '2017-11-22 11:43:06', '1', '', ''),
(5, '', 'Pending', '', '83', '', '', '2017-11-22', '05:15:00', '2017-11-22 11:45:34', '1', '', ''),
(6, '', 'Pending', '', '83', '', '', '2017-11-22', '05:17:00', '2017-11-22 11:47:16', '1', '', ''),
(7, 'GS10033', 'Pending', '2', '83', '2l0brei99j6n0ivodgdf6sph63', 'GS10033', '2017-11-22', '05:21:00', '2017-11-22 11:51:04', '1', '', ''),
(8, '', 'Pending', '2', '83', '', '', '2017-11-22', '05:21:00', '2017-11-22 11:51:57', '1', '', ''),
(9, 'GS10035', 'Pending', '3', '83', 'i2hvu234qiod3n1rcmepshcjs7', 'GS10035', '2017-11-27', '05:29:00', '2017-11-27 12:00:10', '3', '', 'Expected delivery time is too long');

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

--
-- Table structure for table `tbl_page`
--

CREATE TABLE `tbl_page` (
  `pg_id` int(11) NOT NULL,
  `pg_name` varchar(300) NOT NULL,
  `pg_url` varchar(300) NOT NULL,
  `pg_meta_title` varchar(300) NOT NULL,
  `pg_meta_keyword` varchar(500) NOT NULL,
  `pg_meta_desc` varchar(700) NOT NULL,
  `description` text NOT NULL,
  `pg_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  `pg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pg_type` text NOT NULL,
  `video_url1` text NOT NULL,
  `video_url2` text NOT NULL,
  `video_url3` text NOT NULL,
  `video_url4` text NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_page`
--

INSERT INTO `tbl_page` (`pg_id`, `pg_name`, `pg_url`, `pg_meta_title`, `pg_meta_keyword`, `pg_meta_desc`, `description`, `pg_status`, `pg_date`, `pg_type`, `video_url1`, `video_url2`, `video_url3`, `video_url4`, `image`) VALUES
(1, 'Welcome to Our Website', 'index', 'The River Crescent Resort', '', '', '<p>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', 'Active', '2019-01-12 16:32:59', '', '', '', '', '', ''),
(2, 'About Us', 'about-us', 'About Us', '', '', '<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', 'Active', '2019-01-10 15:46:19', '', '', '', '', '', '1517313208download.png'),
(4, 'Places of Interest', 'place-of-interest', 'Places of Interest', '', '', '<p>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', 'Active', '2019-01-12 18:32:59', '', '', '', '', '', ''),
(10, 'Contact Us', 'contact-us', 'Contact Us', 'Contact Us', '', '<p>We recently helped a from small to large scale of landscaping service so if you need and landscaping service or any suggession please ask our experts they will guide you as soon as possible.</p>\r\n', 'Active', '2018-01-30 12:20:11', '', '', '', '', '', ''),
(34, 'Gallery', 'gallery', 'Gallery', '', '', '', 'Active', '2019-01-12 18:51:23', '', '', '', '', '', ''),
(14, 'Pricing', 'pricing', 'Pricing', '', '', '<div class="container" style="box-sizing: border-box; padding-right: 15px; padding-left: 15px; margin-right: auto; margin-left: auto; width: 1170px;">\r\n<div class="col-md-12 right" style="box-sizing: border-box; position: relative; min-height: 1px; padding-right: 15px; padding-left: 15px; float: left; width: 1140px;">\r\n<div class="section" style="box-sizing: border-box;">\r\n<div class="title top-title" style="box-sizing: border-box; margin-top: 0px;">&nbsp;</div>\r\n\r\n<table class="table table-bordered" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(221, 221, 221); box-sizing:border-box; font-family:arial,helvetica,sans-serif; margin:0px 0px 20px; max-width:100%; padding:0px; width:1110px">\r\n	<thead>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:bottom">&nbsp;</th>\r\n			<th style="text-align:center; vertical-align:bottom">CP PER NIGHT</th>\r\n			<th colspan="3" style="text-align:center; vertical-align:bottom">MAP - 3NTS/4DAYS</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center; vertical-align:top"><strong>Room Category</strong></td>\r\n			<td style="text-align:center; vertical-align:top"><strong>Sgl./Dbl</strong></td>\r\n			<td style="text-align:center; vertical-align:top"><strong>Sgl./Dbl</strong></td>\r\n			<td style="text-align:center; vertical-align:top"><strong>E. Adult ( Above 12 yrs)</strong></td>\r\n			<td style="text-align:center; vertical-align:top"><strong>E. Child ( Between 6-12 yrs)</strong></td>\r\n		</tr>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:top">CHANCELLOR</th>\r\n			<th style="text-align:center; vertical-align:top">7333</th>\r\n			<th style="text-align:center; vertical-align:top">24999</th>\r\n			<th style="text-align:center; vertical-align:top">35 % OF THE TARIFF</th>\r\n			<th style="text-align:center; vertical-align:top">25 % OF THE TARIFF</th>\r\n		</tr>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:top">CHANCELLOR</th>\r\n			<th style="text-align:center; vertical-align:top">7333</th>\r\n			<th style="text-align:center; vertical-align:top">24999</th>\r\n			<th style="text-align:center; vertical-align:top">35 % OF THE TARIFF</th>\r\n			<th style="text-align:center; vertical-align:top">25 % OF THE TARIFF</th>\r\n		</tr>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:top">CHANCELLOR</th>\r\n			<th style="text-align:center; vertical-align:top">7333</th>\r\n			<th style="text-align:center; vertical-align:top">24999</th>\r\n			<th style="text-align:center; vertical-align:top">35 % OF THE TARIFF</th>\r\n			<th style="text-align:center; vertical-align:top">25 % OF THE TARIFF</th>\r\n		</tr>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:top">CHANCELLOR</th>\r\n			<th style="text-align:center; vertical-align:top">7333</th>\r\n			<th style="text-align:center; vertical-align:top">24999</th>\r\n			<th style="text-align:center; vertical-align:top">35 % OF THE TARIFF</th>\r\n			<th style="text-align:center; vertical-align:top">25 % OF THE TARIFF</th>\r\n		</tr>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:top">CHANCELLOR</th>\r\n			<th style="text-align:center; vertical-align:top">7333</th>\r\n			<th style="text-align:center; vertical-align:top">24999</th>\r\n			<th style="text-align:center; vertical-align:top">35 % OF THE TARIFF</th>\r\n			<th style="text-align:center; vertical-align:top">25 % OF THE TARIFF</th>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<table class="table table-bordered" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(221, 221, 221); box-sizing:border-box; font-family:arial,helvetica,sans-serif; margin:0px 0px 20px; max-width:100%; padding:0px; width:1110px">\r\n	<thead>\r\n		<tr>\r\n			<th style="text-align:center; vertical-align:bottom">THE SAID OFF SEASON TARIFF IS NOT APPLICABLE ON THE FESTIVAL DATES, CHRISTMAS &amp; NEW YEAR PERIOD</th>\r\n		</tr>\r\n	</thead>\r\n</table>\r\n\r\n<table class="table table-bordered" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(221, 221, 221); box-sizing:border-box; font-family:arial,helvetica,sans-serif; margin:0px 0px 20px; max-width:100%; padding:0px; width:1110px">\r\n	<thead>\r\n		<tr>\r\n			<th style="text-align:left; vertical-align:bottom"><strong>INCLUSIONS FOR 3 NIGHTS PACKAGE</strong><br />\r\n			&diams; WELCOME DRINK ON ARRIVAL - NON ALCOHOLIC<br />\r\n			&diams; ACCOMMODATION FOR 3 NIGHTS &amp; 4 DAYS<br />\r\n			&diams; FRUIT BASKET / COOKIES ON THE DAY OF ARRIVAL<br />\r\n			&diams; VEG. BUFFET BREAKFAST &amp; VEG. BUFFET DINNER<br />\r\n			&diams; TEA/COFFEE MAKER IN THE ROOM<br />\r\n			&diams; FREE USE OF INDOOR GAMES EXCEPT POOL TABLE<br />\r\n			&diams; EXTENDABLE ON PRO-RATA BASIS<br />\r\n			INCLUSIVE ALL APPLICABLE TAXES</th>\r\n			<th style="text-align:left; vertical-align:bottom"><strong>HONEYMOON SUPPLEMENT - RS3000/-</strong><br />\r\n			&diams; FLOWER DECORATION<br />\r\n			&diams; CANDLE LIGHT DINNER<br />\r\n			&diams; ONE HALF DAY SIGHT SEEING<br />\r\n			&diams; ALMOND MILK EVERY NIGHT<br />\r\n			&diams; GOODNIGHT MINTS</th>\r\n		</tr>\r\n	</thead>\r\n</table>\r\n</div>\r\n</div>\r\n</div>\r\n', 'Active', '2019-01-10 16:35:36', '', '', '', '', '', '');

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

--
-- Table structure for table `tbl_payment_method`
--

CREATE TABLE `tbl_payment_method` (
  `payment_method_id` int(11) NOT NULL,
  `payment_method_title` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `pg_status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_payment_method`
--

INSERT INTO `tbl_payment_method` (`payment_method_id`, `payment_method_title`, `description`, `pg_status`) VALUES
(2, 'Direct Bank Transfer', '<p>YOU MAY DEPOSIT CHEQUE OR DD ELECTRONIC TRANSFER TO</p>\r\n<div>&nbsp;</div>\r\n<div>Khanna Gems Private Limited,</div>\r\n<div>Punjab &amp; Sind Bank,</div>\r\n<div>A/c No. 08681300000642</div>\r\n<div>IFSC Code: PSIB0000963</div>', 'Active'),
(3, 'Cheque Payment', '<p>SEND A CHEQUE IN FAVOUR OF&nbsp;</p>\r\n<div>Khanna Gems Private Limited</div>\r\n<div>&nbsp;</div>\r\n<div>SHOP NO. 8, A-3 DDA MARKET.&nbsp;</div>\r\n<div>Janakpuri,</div>\r\n<div>New Delhi - 110058</div>\r\n<div>(Near St. Marks School</div>', 'Active'),
(4, 'Net Banking', '', 'Active');

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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `product_id` int(11) NOT NULL,
  `product_title` varchar(200) NOT NULL,
  `product_cat` varchar(200) NOT NULL,
  `product_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `pg_url` varchar(300) NOT NULL,
  `page_url_link` varchar(400) NOT NULL,
  `page_url_link_id` varchar(500) NOT NULL,
  `sort_description` varchar(600) NOT NULL,
  `description` text NOT NULL,
  `pg_meta_title` varchar(200) NOT NULL,
  `pg_meta_keyword` varchar(300) NOT NULL,
  `pg_meta_desc` varchar(600) NOT NULL,
  `banner` varchar(300) NOT NULL,
  `image` varchar(300) NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `quantity` varchar(200) NOT NULL,
  `availability` varchar(100) NOT NULL,
  `mrp_price` double NOT NULL,
  `discounted_price` double NOT NULL,
  `discount` double NOT NULL,
  `default_image` varchar(400) NOT NULL,
  `vender` varchar(200) NOT NULL,
  `sku_code` varchar(3000) NOT NULL,
  `brand` varchar(3000) NOT NULL,
  `hindi_url` varchar(500) NOT NULL,
  `weight_ratti` double NOT NULL,
  `weight_carat` varchar(200) NOT NULL,
  `origin` varchar(200) NOT NULL,
  `certificate` varchar(3000) NOT NULL,
  `certified` varchar(200) NOT NULL,
  `cents` varchar(200) NOT NULL,
  `is_this_product_gem_stone` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_product_category`
--

CREATE TABLE `tbl_product_category` (
  `product_cat_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `product_category_title` varchar(500) DEFAULT NULL,
  `pg_url` text,
  `page_url_link` varchar(400) NOT NULL,
  `pg_status` varchar(400) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `image` text NOT NULL,
  `position` varchar(2000) DEFAULT NULL,
  `banner` varchar(400) NOT NULL,
  `description` text NOT NULL,
  `sort_description` varchar(500) NOT NULL,
  `pg_meta_title` varchar(300) NOT NULL,
  `pg_meta_keyword` varchar(600) NOT NULL,
  `pg_meta_desc` varchar(800) NOT NULL,
  `hindi_url` varchar(500) NOT NULL,
  `hindi_title` varchar(500) NOT NULL,
  `hindi_video` varchar(2000) NOT NULL,
  `product_information` text NOT NULL,
  `home_page_visible` varchar(200) NOT NULL,
  `home_page_visible_with_text` varchar(300) NOT NULL,
  `hindi_description` text NOT NULL,
  `pg_hindi_meta_title` varchar(500) NOT NULL,
  `price` varchar(400) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product_category`
--

INSERT INTO `tbl_product_category` (`product_cat_id`, `parent_id`, `product_category_title`, `pg_url`, `page_url_link`, `pg_status`, `date_time`, `image`, `position`, `banner`, `description`, `sort_description`, `pg_meta_title`, `pg_meta_keyword`, `pg_meta_desc`, `hindi_url`, `hindi_title`, `hindi_video`, `product_information`, `home_page_visible`, `home_page_visible_with_text`, `hindi_description`, `pg_hindi_meta_title`, `price`) VALUES
(1, 0, 'Accommodation', 'accommodation', 'accommodation', 'Active', '2019-01-10 15:23:46', '1547314033standard-rooms.jpg', NULL, '1547314034standard-rooms.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Accommodation', '', '', '', '5421', '', '', 'Yes', 'No', '', '', NULL),
(2, 0, 'Dining', 'dining', 'dining', 'Active', '2019-01-10 15:25:02', '1547313901image1.jpg', NULL, '', '<p>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', '', 'Dining', '', '', '', '4523', '', '', 'No', 'No', '', '', NULL),
(3, 0, 'Plan And Event', 'plan and event', 'plan-and-event', 'Active', '2019-01-10 15:26:04', '1547313977image2.jpg', NULL, '1547313977image2.jpg', '<p>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', '', 'Plan And Event', '', '', '', '34667', '', '', 'No', 'No', '', '', NULL),
(4, 1, 'Chancellor Rooms', 'chancellor rooms', 'chancellor-rooms', 'Active', '2019-01-10 15:37:33', '1547142514Standard-Rooms30_52.jpg', NULL, '1547142515Standard-Rooms30_52.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Chancellor Rooms', '', '', '', '1200', '', '', 'Yes', 'No', '', '', NULL),
(5, 1, 'Duke Rooms', 'duke rooms', 'duke-rooms', 'Active', '2019-01-10 15:38:00', '1547143067Fortune-Club-Rooms31_07.jpg', NULL, '1547143067Fortune-Club-Rooms31_07.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Duke Rooms', '', '', '', '3400', '', '', 'Yes', 'No', '', '', NULL),
(6, 1, 'Monarch Rooms', 'monarch rooms', 'monarch-rooms', 'Active', '2019-01-10 15:38:21', '1547143103Junior-Suite31_19.jpg', NULL, '1547143103Junior-Suite31_19.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Monarch Rooms', '', '', '', '4000', '', '', 'Yes', 'No', '', '', NULL),
(7, 2, 'Restaurant', 'restaurant', 'restaurant', 'Active', '2019-01-10 15:38:51', '1547143199Fortune-Deli01_43.jpg', NULL, '1547143199Fortune-Deli01_43.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Restaurant', '', '', '', '', '', '', 'No', 'No', '', '', NULL),
(8, 3, 'Conference', 'conference', 'conference', 'Active', '2019-01-10 15:39:13', '1547143461Conference02_30.jpg', NULL, '1547143461Conference02_30.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Conference', '', '', '', '', '', '', 'No', 'No', '', '', NULL),
(9, 3, 'Wedding', 'wedding', 'wedding', 'Active', '2019-01-10 15:39:27', '1547143483Neptune-Lounge00_44.jpg', NULL, '1547143484Neptune-Lounge00_44.jpg', '<p>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>&nbsp;</p>\r\n', '', 'Wedding', '', '', '', '', '', '', 'No', 'No', '', '', NULL);

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

--
-- Table structure for table `tbl_product_image`
--

CREATE TABLE `tbl_product_image` (
  `prod_img_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image_title` varchar(400) NOT NULL,
  `image` varchar(500) NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `data_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product_image`
--

INSERT INTO `tbl_product_image` (`prod_img_id`, `product_id`, `image_title`, `image`, `pg_status`, `data_time`) VALUES
(1, 1, 'Image2', '1499938088Cuddly-Choco-Combo-A.jpg', 'Active', '2017-07-13 09:28:23'),
(2, 1, 'image1', '1499937199Sweet-Gesture_0.jpg', 'Active', '2017-07-13 09:13:19'),
(3, 4, 'img1', '15067567423.jpg', 'Active', '2017-09-30 07:32:42');

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

--
-- Table structure for table `tbl_recently_viewed`
--

CREATE TABLE `tbl_recently_viewed` (
  `product_id` int(11) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_review`
--

CREATE TABLE `tbl_review` (
  `review_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `review_title` varchar(400) NOT NULL,
  `quality_star` varchar(200) NOT NULL,
  `price_star` varchar(200) NOT NULL,
  `value_star` varchar(200) NOT NULL,
  `gross_star` varchar(200) NOT NULL,
  `review_by` varchar(400) NOT NULL,
  `review_text` varchar(1000) NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `email` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_review`
--

INSERT INTO `tbl_review` (`review_id`, `product_id`, `review_title`, `quality_star`, `price_star`, `value_star`, `gross_star`, `review_by`, `review_text`, `pg_status`, `date_time`, `email`) VALUES
(1, 5, '', '3', '4', '5', '4', 'Krishna Kant', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.Aliquam suscipit.', 'Active', '2017-07-13 11:51:03', ''),
(2, 4, '', '3', '4', '5', '4', 'Krishna Kant', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.Aliquam suscipit', 'Active', '2017-07-13 11:51:07', ''),
(3, 4, '', '2', '2', '3', '2', 'Ajay', 'data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. data is coming soon. ', 'Active', '2017-07-13 12:02:54', ''),
(4, 4, '', '', '', '', '4', 'Krishna Kant', 'sfdgfdhfgdhfgdh', 'Active', '2017-10-03 09:48:32', 'iandu445@gmail.com'),
(7, 4, '', '', '', '', '4', 'minakshi', 'fdgfdghfdhfdh', 'Inactive', '2017-10-03 09:45:19', 'minak@gmail.com');

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

--
-- Table structure for table `tbl_shipping_billing_info`
--

CREATE TABLE `tbl_shipping_billing_info` (
  `_ship_bil_id` int(11) NOT NULL,
  `ship_name` varchar(200) NOT NULL,
  `ship_email` varchar(100) NOT NULL,
  `ship_phone` varchar(100) NOT NULL,
  `ship_lmark` varchar(300) NOT NULL,
  `ship_address` varchar(500) NOT NULL,
  `ship_city` varchar(200) NOT NULL,
  `ship_state` varchar(200) NOT NULL,
  `ship_country` varchar(200) NOT NULL,
  `ship_pin` varchar(100) NOT NULL,
  `bil_name` varchar(200) NOT NULL,
  `bil_email` varchar(100) NOT NULL,
  `bil_phone` varchar(100) NOT NULL,
  `bil_lmark` varchar(300) NOT NULL,
  `bil_address` varchar(500) NOT NULL,
  `bil_pin` varchar(200) NOT NULL,
  `bil_city` varchar(300) NOT NULL,
  `bil_state` varchar(300) NOT NULL,
  `bil_country` varchar(300) NOT NULL,
  `Remarks` varchar(1000) NOT NULL,
  `usertype` varchar(400) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cuser` varchar(400) NOT NULL,
  `userid` varchar(400) NOT NULL,
  `cuser_session_id` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_shipping_billing_info`
--

INSERT INTO `tbl_shipping_billing_info` (`_ship_bil_id`, `ship_name`, `ship_email`, `ship_phone`, `ship_lmark`, `ship_address`, `ship_city`, `ship_state`, `ship_country`, `ship_pin`, `bil_name`, `bil_email`, `bil_phone`, `bil_lmark`, `bil_address`, `bil_pin`, `bil_city`, `bil_state`, `bil_country`, `Remarks`, `usertype`, `date_time`, `cuser`, `userid`, `cuser_session_id`) VALUES
(1, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Delhi', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Delhi', 'India', '', '', '2017-11-17 09:40:13', 'GS10029', '83', 'gspvkqd1cpdr4d3ntnkm0iog41'),
(2, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 3, Gandhi Market Main Sagarpur', 'New Delhi', 'Delhi', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 3, Gandhi Market Main Sagarpur', '110046', 'New Delhi', 'Delhi', 'India', '', '', '2017-11-17 09:42:37', 'GS10030', '83', 'gspvkqd1cpdr4d3ntnkm0iog41'),
(3, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Delhi', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Delhi', 'India', '', '', '2017-11-22 11:42:16', 'GS10032', '83', '2l0brei99j6n0ivodgdf6sph63'),
(4, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Delhi', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Delhi', 'India', '', '', '2017-11-22 11:43:06', '', '83', ''),
(5, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2017-11-22 11:45:34', '', '83', ''),
(6, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2017-11-22 11:47:16', '', '83', ''),
(7, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Assam', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Assam', 'India', 'df', '', '2017-11-22 11:51:04', 'GS10033', '83', '2l0brei99j6n0ivodgdf6sph63'),
(8, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Assam', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Assam', 'India', 'df', '', '2017-11-22 11:51:57', '', '83', ''),
(9, 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', 'New Delhi', 'Jammu and Kashmir', 'India', '110046', 'Krishna Kant', 'iandu445@gmail.com', '8285784867', 'Delhi', 'Gali No : 4, Gandhi Market Main Sagarpur West , New delhi.', '110046', 'New Delhi', 'Jammu and Kashmir', 'India', '', '', '2017-11-27 11:59:45', 'GS10035', '83', 'i2hvu234qiod3n1rcmepshcjs7');

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

--
-- Table structure for table `tbl_size_weight`
--

CREATE TABLE `tbl_size_weight` (
  `size_weight_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `size_weight_title` varchar(200) NOT NULL,
  `mrp_price` double NOT NULL,
  `discounted_price` double NOT NULL,
  `pg_status` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `discount` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_size_weight`
--

INSERT INTO `tbl_size_weight` (`size_weight_id`, `product_id`, `size_weight_title`, `mrp_price`, `discounted_price`, `pg_status`, `date_time`, `discount`) VALUES
(1, 1, 'S', 400, 320, 'Active', '2017-07-13 07:49:31', 20),
(2, 1, 'L', 600, 560, 'Active', '2017-07-13 09:15:43', 7);

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

--
-- Table structure for table `tbl_state`
--

CREATE TABLE `tbl_state` (
  `state_id` int(11) NOT NULL,
  `country_id` varchar(200) NOT NULL,
  `state_code` varchar(200) NOT NULL,
  `state_name` varchar(500) NOT NULL,
  `state_category` varchar(400) NOT NULL,
  `pg_status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_state`
--

INSERT INTO `tbl_state` (`state_id`, `country_id`, `state_code`, `state_name`, `state_category`, `pg_status`) VALUES
(1, '104', 'IN-AP', 'Andhra Pradesh', 'Andhra Pradesh', 'Active'),
(2, '104', 'IN-AR', 'Arunachal Pradesh', 'Arunachal Pradesh', 'Active'),
(3, '104', 'IN-AS', 'Assam', 'Assam', 'Active'),
(4, '104', 'IN-BR', 'Bihar', 'Bihar', 'Active'),
(5, '104', 'IN-CT', 'Chhattisgarh[note 1]', 'Chhattisgarh[note 1]', 'Active'),
(6, '104', 'IN-GA', 'Goa', 'Goa', 'Active'),
(7, '104', 'IN-GJ', 'Gujarat', 'Gujarat', 'Active'),
(8, '104', 'IN-HR', 'Haryana', 'Haryana', 'Active'),
(9, '104', 'IN-HP', 'Himachal Pradesh', 'Himachal Pradesh', 'Active'),
(10, '104', 'IN-JK', 'Jammu and Kashmir', 'Jammu and Kashmir', 'Active'),
(11, '104', 'IN-JH', 'Jharkhand', 'Jharkhand', 'Active'),
(12, '104', 'IN-KA', 'Karnataka', 'Karnataka', 'Active'),
(13, '104', 'IN-KL', 'Kerala', 'Kerala', 'Active'),
(14, '104', 'IN-MP', 'Madhya Pradesh', 'Madhya Pradesh', 'Active'),
(15, '104', 'IN-MH', 'Maharashtra', 'Maharashtra', 'Active'),
(16, '104', 'IN-MN', 'Manipur', 'Manipur', 'Active'),
(17, '104', 'IN-ML', 'Meghalaya', 'Meghalaya', 'Active'),
(18, '104', 'IN-MZ', 'Mizoram', 'Mizoram', 'Active'),
(19, '104', 'IN-NL', 'Nagaland', 'Nagaland', 'Active'),
(20, '104', 'IN-OR', 'Odisha[note 2]', 'Odisha[note 2]', 'Active'),
(21, '104', 'IN-PB', 'Punjab', 'Punjab', 'Active'),
(22, '104', 'IN-RJ', 'Rajasthan', 'Rajasthan', 'Active'),
(23, '104', 'IN-SK', 'Sikkim', 'Sikkim', 'Active'),
(24, '104', 'IN-TN', 'Tamil Nadu', 'Tamil Nadu', 'Active'),
(25, '104', 'IN-TG', 'Telangana[note 3]', 'Telangana[note 3]', 'Active'),
(26, '104', 'IN-TR', 'Tripura', 'Tripura', 'Active'),
(27, '104', 'IN-UT', 'Uttarakhand[note 4]', 'Uttarakhand[note 4]', 'Active'),
(28, '104', 'IN-UP', 'Uttar Pradesh', 'Uttar Pradesh', 'Active'),
(29, '104', 'IN-WB', 'West Bengal', 'West Bengal', 'Active'),
(30, '104', 'IN-AN', 'Andaman and Nicobar Islands', 'Andaman and Nicobar Islands', 'Active'),
(31, '104', 'IN-CH', 'Chandigarh', 'Chandigarh', 'Active'),
(32, '104', 'IN-DN', 'Dadra and Nagar Haveli', 'Dadra and Nagar Haveli', 'Active'),
(33, '104', 'IN-DD', 'Daman and Diu', 'Daman and Diu', 'Active'),
(34, '104', 'IN-DL', 'Delhi', 'Delhi', 'Active'),
(35, '104', 'IN-LD', 'Lakshadweep', 'Lakshadweep', 'Active'),
(36, '104', 'IN-PY', 'Puducherry', 'Puducherry', 'Active');

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

--
-- Table structure for table `tbl_temp_cart`
--

CREATE TABLE `tbl_temp_cart` (
  `temp_id` double NOT NULL,
  `product_id` int(11) NOT NULL,
  `user_session_id` varchar(400) NOT NULL,
  `user_ip` varchar(300) NOT NULL,
  `size` varchar(200) NOT NULL,
  `color` varchar(200) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cuser` varchar(3000) NOT NULL,
  `quantity` text NOT NULL,
  `product_url` text NOT NULL,
  `order_sub_id` varchar(400) NOT NULL,
  `order_status` varchar(400) NOT NULL,
  `order_status_remarks` varchar(2000) NOT NULL,
  `order_cancel_reason` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_temp_cart`
--

INSERT INTO `tbl_temp_cart` (`temp_id`, `product_id`, `user_session_id`, `user_ip`, `size`, `color`, `date_time`, `cuser`, `quantity`, `product_url`, `order_sub_id`, `order_status`, `order_status_remarks`, `order_cancel_reason`) VALUES
(1, 1, 'gspvkqd1cpdr4d3ntnkm0iog41', '::1', '', '', '2017-11-17 12:02:20', 'GS10029', '1', 'sapphire', 'GS100292', '2', 'DRYRTY', ''),
(2, 2, 'gspvkqd1cpdr4d3ntnkm0iog41', '::1', '', '', '2017-11-17 12:38:44', 'GS10029', '1', 'sapphire', 'GS100290', '3', 'sdgsfg', ''),
(3, 3, 'gspvkqd1cpdr4d3ntnkm0iog41', '::1', '', '', '2017-11-17 12:02:20', 'GS10029', '1', 'sapphire', 'GS100291', '2', 'DRYRTY', ''),
(4, 6, 'gspvkqd1cpdr4d3ntnkm0iog41', '::1', '', '', '2017-11-18 07:41:14', 'GS10030', '1', 'sapphire', 'GS100304', '3', 'sdfsdgg', 'Expected delivery time is too long'),
(5, 8, 'gspvkqd1cpdr4d3ntnkm0iog41', '::1', '', '', '2017-11-18 07:32:56', 'GS10030', '1', 'sapphire', 'GS100300', '2', 'rtwt', 'Expected delivery time is too long'),
(6, 1, '2l0brei99j6n0ivodgdf6sph63', '::1', '', '', '2017-11-22 11:41:53', 'GS10032', '1', 'sapphire/natural-ceylon-pukhraj', 'GS100320', '1', '', ''),
(7, 2, '2l0brei99j6n0ivodgdf6sph63', '::1', '', '', '2017-11-22 11:50:53', 'GS10033', '1', 'sapphire', 'GS100330', '1', '', ''),
(8, 1, '2l0brei99j6n0ivodgdf6sph63', '::1', '', '', '2017-11-22 12:12:55', 'GS10034', '1', 'sapphire', 'GS100340', '1', '', ''),
(9, 1, 'i2hvu234qiod3n1rcmepshcjs7', '::1', '', '', '2017-11-27 12:00:10', 'GS10035', '1', 'yellow-sapphire', 'GS100350', '3', 'sda', 'Expected delivery time is too long'),
(10, 1, 'tc8ec1t0ptcuhdbuaf8mhn5be2', '::1', '', '', '2017-12-07 07:40:41', 'GS10036', '1', 'yellow-sapphire', 'GS100360', '1', '', ''),
(11, 1, 'tc8ec1t0ptcuhdbuaf8mhn5be2', '::1', '', '', '2017-12-07 09:49:44', 'GS10037', '1', 'yellow-sapphire', 'GS100370', '1', '', ''),
(12, 3, 'tc8ec1t0ptcuhdbuaf8mhn5be2', '::1', '', '', '2017-12-07 09:49:50', 'GS10037', '1', 'yellow-sapphire', 'GS1003711', '1', '', ''),
(13, 2, 'pbulnjuk16oootknbbmusou576', '::1', '', '', '2017-12-08 11:08:10', 'GS10038', '1', 'yellow-sapphire', 'GS100380', '1', '', ''),
(14, 2, 'gldtok8cavq5avu97b5in0a2a6', '::1', '', '', '2017-12-09 06:19:20', 'GS10039', '1', 'yellow-sapphire', 'GS100390', '1', '', ''),
(15, 2, 'dtq8a16b0r9kkse1jai7aqpo32', '::1', '', '', '2018-01-03 08:38:18', 'GS10041', '1', 'yellow-sapphire', 'GS100410', '1', '', '');

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

--
-- Table structure for table `tbl_testimonial`
--

CREATE TABLE `tbl_testimonial` (
  `testimonial_id` int(11) NOT NULL,
  `client_name` varchar(300) NOT NULL,
  `client_company` varchar(400) NOT NULL,
  `client_designation` varchar(400) NOT NULL,
  `pg_url` varchar(300) NOT NULL,
  `pg_meta_title` varchar(300) NOT NULL,
  `pg_meta_keyword` varchar(500) NOT NULL,
  `pg_meta_desc` varchar(700) NOT NULL,
  `description` text NOT NULL,
  `pg_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  `pg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `image` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_testimonial`
--

INSERT INTO `tbl_testimonial` (`testimonial_id`, `client_name`, `client_company`, `client_designation`, `pg_url`, `pg_meta_title`, `pg_meta_keyword`, `pg_meta_desc`, `description`, `pg_status`, `pg_date`, `image`) VALUES
(16, 'Mukesh Khanna', 'New delhi', 'ceo', '', 'About Us', 'About Us', 'About Us', '<p>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.</p>\r\n', 'Active', '2019-01-12 17:45:50', '1547315150testimonial.png'),
(20, 'Puja Thakur', 'Gurugram', 'ceo', '', '', '', '', '<p>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.</p>\r\n', 'Active', '2019-01-12 17:46:10', '1547315170femal.png'),
(18, 'Shalini Mishra', 'Noida', 'Cheaf', '', '', '', '', '<p>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.</p>\r\n', 'Active', '2019-01-12 17:46:25', '15473151851547315170femal.png'),
(19, 'Mayank Solanki', 'Narela', 'doctor', '', '', '', '', '<p>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.</p>\r\n', 'Active', '2019-01-12 17:46:44', '1547315204testimonial.png');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `user_id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `password` text NOT NULL,
  `country` text NOT NULL,
  `state` text NOT NULL,
  `city` text NOT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  `zipcode` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uname` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `name`, `email`, `password`, `country`, `state`, `city`, `phone`, `address`, `zipcode`, `date`, `uname`, `status`) VALUES
(83, 'Krishna Kant', 'iandu445@gmail.com', 'developer', '104', '34', 'New Delhi', '8285784867', 'sagarpur', '110046', '2017-11-15 05:48:29', 'krishna', 'Active'),
(84, 'Ajay', 'ajay.brandbugle@gmail.com', 'Ajay@123', '', '', 'delhi', '8527977677', 'Pitampura', '', '2017-06-28 07:07:37', 'Ajay', 'Active'),
(85, 'kk', 'krishnakant@gmail.com', '1234', '', '', '', '8787867676', '', '', '2017-10-14 06:32:49', '', 'Inactive'),
(94, 'Guest', '', 'Guest@85', '', '', '', '', '', '', '2017-10-31 09:23:56', '', 'Active'),
(95, 'Guest', '', 'Guest@94', '', '', '', '', '', '', '2017-11-01 11:48:30', '', 'Active'),
(96, 'Guest', '', 'Guest@95', '', '', '', '', '', '', '2017-11-02 06:35:54', '', 'Active');

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

--
-- Table structure for table `tbl_website_management`
--

CREATE TABLE `tbl_website_management` (
  `website_id` int(11) NOT NULL,
  `website_title` varchar(300) DEFAULT NULL,
  `website_domain` varchar(200) NOT NULL,
  `website_url` varchar(300) DEFAULT NULL,
  `website_logo` varchar(400) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `website_facebook` varchar(500) DEFAULT NULL,
  `website_twitor` varchar(500) DEFAULT NULL,
  `website_gplus` varchar(500) DEFAULT NULL,
  `website_linkedin` varchar(500) DEFAULT NULL,
  `website_instagram` varchar(500) DEFAULT NULL,
  `website_printest` varchar(500) DEFAULT NULL,
  `website_youtube` varchar(500) NOT NULL,
  `tin_no` varchar(200) NOT NULL,
  `webmail1` varchar(100) NOT NULL,
  `webmail2` varchar(100) NOT NULL,
  `webmail3` varchar(100) NOT NULL,
  `webmail4` varchar(100) NOT NULL,
  `google_map` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_website_management`
--

INSERT INTO `tbl_website_management` (`website_id`, `website_title`, `website_domain`, `website_url`, `website_logo`, `date_time`, `website_facebook`, `website_twitor`, `website_gplus`, `website_linkedin`, `website_instagram`, `website_printest`, `website_youtube`, `tin_no`, `webmail1`, `webmail2`, `webmail3`, `webmail4`, `google_map`) VALUES
(1, 'The River Crescent Resort', 'resort.com', 'http://localhost/vishalji/resort', '1547059568logo.jpg', '2017-01-19 14:27:59', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `tbl_wishlist`
--

CREATE TABLE `tbl_wishlist` (
  `wishlist_id` int(11) NOT NULL,
  `product_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `b_url` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_wishlist`
--

INSERT INTO `tbl_wishlist` (`wishlist_id`, `product_id`, `user_id`, `date_time`, `b_url`) VALUES
(1, '5', '83', '2017-11-03 07:25:48', 'pukhraj/natural-ceylon-pukhraj');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_address`
--
ALTER TABLE `tbl_address`
  ADD PRIMARY KEY (`address_id`);

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`uid`);

--
-- Indexes for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  ADD PRIMARY KEY (`banner_id`);

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

--
-- Indexes for table `tbl_blog_category`
--
ALTER TABLE `tbl_blog_category`
  ADD PRIMARY KEY (`blog_cat_id`);

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

--
-- Indexes for table `tbl_color`
--
ALTER TABLE `tbl_color`
  ADD PRIMARY KEY (`color_id`);

--
-- Indexes for table `tbl_compare`
--
ALTER TABLE `tbl_compare`
  ADD PRIMARY KEY (`compare_id`);

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

--
-- Indexes for table `tbl_country`
--
ALTER TABLE `tbl_country`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `tbl_cuser`
--
ALTER TABLE `tbl_cuser`
  ADD PRIMARY KEY (`cuser_id`);

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

--
-- Indexes for table `tbl_gallery_category`
--
ALTER TABLE `tbl_gallery_category`
  ADD PRIMARY KEY (`gallery_cat_id`);

--
-- Indexes for table `tbl_inquiry`
--
ALTER TABLE `tbl_inquiry`
  ADD PRIMARY KEY (`inquiry_id`);

--
-- Indexes for table `tbl_location`
--
ALTER TABLE `tbl_location`
  ADD PRIMARY KEY (`location_id`);

--
-- Indexes for table `tbl_member`
--
ALTER TABLE `tbl_member`
  ADD PRIMARY KEY (`member_id`);

--
-- Indexes for table `tbl_more_url`
--
ALTER TABLE `tbl_more_url`
  ADD PRIMARY KEY (`pg_id`);

--
-- Indexes for table `tbl_newsletter`
--
ALTER TABLE `tbl_newsletter`
  ADD PRIMARY KEY (`newsletter_id`);

--
-- Indexes for table `tbl_order`
--
ALTER TABLE `tbl_order`
  ADD PRIMARY KEY (`odr_id`);

--
-- Indexes for table `tbl_page`
--
ALTER TABLE `tbl_page`
  ADD PRIMARY KEY (`pg_id`);

--
-- Indexes for table `tbl_payment_method`
--
ALTER TABLE `tbl_payment_method`
  ADD PRIMARY KEY (`payment_method_id`);

--
-- Indexes for table `tbl_product`
--
ALTER TABLE `tbl_product`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `tbl_product_category`
--
ALTER TABLE `tbl_product_category`
  ADD PRIMARY KEY (`product_cat_id`);

--
-- Indexes for table `tbl_product_image`
--
ALTER TABLE `tbl_product_image`
  ADD PRIMARY KEY (`prod_img_id`);

--
-- Indexes for table `tbl_review`
--
ALTER TABLE `tbl_review`
  ADD PRIMARY KEY (`review_id`);

--
-- Indexes for table `tbl_shipping_billing_info`
--
ALTER TABLE `tbl_shipping_billing_info`
  ADD PRIMARY KEY (`_ship_bil_id`);

--
-- Indexes for table `tbl_size_weight`
--
ALTER TABLE `tbl_size_weight`
  ADD PRIMARY KEY (`size_weight_id`);

--
-- Indexes for table `tbl_state`
--
ALTER TABLE `tbl_state`
  ADD PRIMARY KEY (`state_id`);

--
-- Indexes for table `tbl_temp_cart`
--
ALTER TABLE `tbl_temp_cart`
  ADD PRIMARY KEY (`temp_id`);

--
-- Indexes for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  ADD PRIMARY KEY (`testimonial_id`);

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

--
-- Indexes for table `tbl_website_management`
--
ALTER TABLE `tbl_website_management`
  ADD PRIMARY KEY (`website_id`);

--
-- Indexes for table `tbl_wishlist`
--
ALTER TABLE `tbl_wishlist`
  ADD PRIMARY KEY (`wishlist_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_address`
--
ALTER TABLE `tbl_address`
  MODIFY `address_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tbl_blog`
--
ALTER TABLE `tbl_blog`
  MODIFY `blog_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_blog_category`
--
ALTER TABLE `tbl_blog_category`
  MODIFY `blog_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_blog_comment`
--
ALTER TABLE `tbl_blog_comment`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_color`
--
ALTER TABLE `tbl_color`
  MODIFY `color_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_compare`
--
ALTER TABLE `tbl_compare`
  MODIFY `compare_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tbl_contact`
--
ALTER TABLE `tbl_contact`
  MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_country`
--
ALTER TABLE `tbl_country`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252;
--
-- AUTO_INCREMENT for table `tbl_cuser`
--
ALTER TABLE `tbl_cuser`
  MODIFY `cuser_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
--
-- AUTO_INCREMENT for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  MODIFY `gallery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tbl_gallery_category`
--
ALTER TABLE `tbl_gallery_category`
  MODIFY `gallery_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_inquiry`
--
ALTER TABLE `tbl_inquiry`
  MODIFY `inquiry_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_location`
--
ALTER TABLE `tbl_location`
  MODIFY `location_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tbl_member`
--
ALTER TABLE `tbl_member`
  MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `tbl_more_url`
--
ALTER TABLE `tbl_more_url`
  MODIFY `pg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_newsletter`
--
ALTER TABLE `tbl_newsletter`
  MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tbl_order`
--
ALTER TABLE `tbl_order`
  MODIFY `odr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tbl_page`
--
ALTER TABLE `tbl_page`
  MODIFY `pg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT for table `tbl_payment_method`
--
ALTER TABLE `tbl_payment_method`
  MODIFY `payment_method_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_product_category`
--
ALTER TABLE `tbl_product_category`
  MODIFY `product_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tbl_product_image`
--
ALTER TABLE `tbl_product_image`
  MODIFY `prod_img_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_review`
--
ALTER TABLE `tbl_review`
  MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tbl_shipping_billing_info`
--
ALTER TABLE `tbl_shipping_billing_info`
  MODIFY `_ship_bil_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tbl_size_weight`
--
ALTER TABLE `tbl_size_weight`
  MODIFY `size_weight_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_state`
--
ALTER TABLE `tbl_state`
  MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `tbl_temp_cart`
--
ALTER TABLE `tbl_temp_cart`
  MODIFY `temp_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  MODIFY `testimonial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;
--
-- AUTO_INCREMENT for table `tbl_website_management`
--
ALTER TABLE `tbl_website_management`
  MODIFY `website_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_wishlist`
--
ALTER TABLE `tbl_wishlist`
  MODIFY `wishlist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!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 */;
