-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 24, 2018 at 08:41 PM
-- Server version: 5.7.21-0ubuntu0.16.04.1
-- PHP Version: 7.0.28-0ubuntu0.16.04.1

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

--
-- Database: `jewellery`
--

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

--
-- Table structure for table `address_book`
--

CREATE TABLE `address_book` (
  `address_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `address_address1` varchar(255) NOT NULL,
  `address_address2` varchar(255) DEFAULT NULL,
  `address_city` varchar(255) NOT NULL,
  `address_state` varchar(255) NOT NULL,
  `address_postal_code` varchar(10) NOT NULL,
  `address_country` tinyint(1) NOT NULL,
  `is_default` tinyint(1) DEFAULT '0' COMMENT 'for default address',
  `address_created_on` datetime NOT NULL,
  `address_modified_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `add_register_user_payment`
--

CREATE TABLE `add_register_user_payment` (
  `register_payment_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `payment_detail` text NOT NULL,
  `auth_pay_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `auth_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `auth_shipping_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created` datetime NOT NULL,
  `stripe_customer_token` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `stripe_customer_profile_id` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `card_number` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `card_expiry` varchar(256) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `banner_images`
--

CREATE TABLE `banner_images` (
  `banner_image_id` int(10) NOT NULL,
  `group_id` int(11) NOT NULL,
  `banner_type` tinyint(1) NOT NULL DEFAULT '1',
  `banner_status` tinyint(1) NOT NULL COMMENT '1 for user defined 0 for default',
  `banner_image_original` varchar(255) DEFAULT NULL,
  `banner_mask_name` varchar(255) DEFAULT NULL,
  `image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banner_images`
--

INSERT INTO `banner_images` (`banner_image_id`, `group_id`, `banner_type`, `banner_status`, `banner_image_original`, `banner_mask_name`, `image_created`) VALUES
(1, 1, 2, 1, 'home-slider3.jpg', 'o_1cbhdeuv41sblbjq14m8jm21bm3a.jpg', '2018-04-20 17:06:39'),
(2, 1, 2, 1, 'home-slider2.jpg', 'o_1cbhdeuv4shm1r8bm9k8mdl5cb.jpg', '2018-04-20 17:06:39'),
(3, 1, 2, 1, 'home-slider1.jpg', 'o_1cbhdeuv4kv21mn3d7ejjpialc.jpg', '2018-04-20 17:06:39'),
(4, 1, 2, 1, 'banner2nd.jpg', 'o_1cbhdeuv41nedpa11cs81g331so6d.jpg', '2018-04-20 17:06:39');

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

--
-- Table structure for table `banner_text`
--

CREATE TABLE `banner_text` (
  `banner_text` int(11) NOT NULL,
  `groups_id` tinyint(1) NOT NULL,
  `main` varchar(255) NOT NULL,
  `sub` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `banner_text_created` datetime NOT NULL,
  `banner_text_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banner_text`
--

INSERT INTO `banner_text` (`banner_text`, `groups_id`, `main`, `sub`, `color`, `banner_text_created`, `banner_text_modified`) VALUES
(1, 1, 'Jewellery Stores', 'Jewellery Stores', '#204467', '2018-04-20 17:38:29', NULL);

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `brand_id` int(20) NOT NULL,
  `brand_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `brand_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
  `brand_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `brand_status` tinyint(1) NOT NULL COMMENT '0 for deactivate , 1 for activate',
  `brand_created` datetime NOT NULL,
  `brand_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`brand_id`, `brand_name`, `brand_original_image`, `brand_mask_name`, `brand_status`, `brand_created`, `brand_modified`) VALUES
(61, 'General', 'brand.png', '8c4d3a946a1fcde2ded7e17651fd0ed7.jpg', 1, '2017-10-25 12:38:33', NULL),
(62, 'Tanishq', 'aveer_LC020118.jpg', '172fa4fa9eff6ae8591575351ca559bf.jpg', 1, '2018-04-20 12:23:27', NULL);

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

--
-- Table structure for table `cart_added`
--

CREATE TABLE `cart_added` (
  `cart_added_id` bigint(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `cart_added_product_quantity` int(10) NOT NULL,
  `cart_added_created` datetime NOT NULL,
  `cart_added_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
  `category_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
  `category_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `category_status` tinyint(1) NOT NULL,
  `category_created` datetime NOT NULL,
  `category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`category_id`, `category_name`, `category_slug`, `category_original_image`, `category_mask_name`, `category_status`, `category_created`, `category_modified`) VALUES
(24, 'General', 'general', 'images.png', '59b514174bffe4ae402b3d63aad79fe0.jpg', 1, '2017-10-25 13:26:00', NULL),
(25, 'Earring', 'category-1', 'gold-earrings-gold-chand-bali-earrings-with-rubies-emeralds-and-pearls-jl-au-109-1_1024x1024.jpg', 'aa7e010338cc102af81907f592fd926d.jpg', 1, '2018-03-20 15:49:02', '2018-04-20 11:23:37'),
(26, 'Neckwear', 'category-2', '501758NCJAAA02.jpg', '46f5a74ed7b8be1c4a1757e451a8deeb.jpg', 1, '2018-03-21 14:58:14', '2018-04-20 11:25:05'),
(27, 'Pendant', 'catehory-3', '503117PHVAAA22.jpg', 'acc67c36b3fb1e0f27a6462344eef169.jpg', 1, '2018-03-21 14:59:00', '2018-04-20 11:26:05'),
(28, 'Bangle', 'category-4', '512414VGWQ2A00.jpg', '4291fecb35f245ec42334b03cd6ddfa1.jpg', 1, '2018-03-21 14:59:20', '2018-04-20 11:27:59');

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

--
-- Table structure for table `color_settings`
--

CREATE TABLE `color_settings` (
  `color_settings_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `color_code` varchar(255) NOT NULL,
  `color_settings_created` datetime NOT NULL,
  `color_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `color_settings`
--

INSERT INTO `color_settings` (`color_settings_id`, `group_id`, `color_code`, `color_settings_created`, `color_settings_modified`) VALUES
(1, 1, '#ae9e9e', '2018-04-23 14:49:17', NULL);

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

--
-- Table structure for table `contact_info`
--

CREATE TABLE `contact_info` (
  `contact_info_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `postal_code` varchar(10) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `contact_info_created` datetime NOT NULL,
  `contact_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_info`
--

INSERT INTO `contact_info` (`contact_info_id`, `group_id`, `address`, `city`, `state`, `country`, `postal_code`, `email`, `phone`, `contact_info_created`, `contact_info_modified`) VALUES
(1, 1, '3719 Jadewood Farms', 'Passaic', 'New Jersey', 'U.S.A', '07055', 'email@email.com', '97336526', '2018-04-16 17:52:08', '2018-04-20 14:25:22');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `country_id` int(10) NOT NULL,
  `title` varchar(100) NOT NULL,
  `iso_code` varchar(20) NOT NULL,
  `country_code` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '"0"=>disable, "1"=>enable'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`country_id`, `title`, `iso_code`, `country_code`, `status`) VALUES
(1, 'United States', 'US', '+1', 1),
(2, 'Australia', 'AU', '+61', 1),
(3, 'Austria', 'AT', '+43 720', 1),
(4, 'Belgium', 'BE', '+32', 1),
(5, 'Canada', 'CA', '+1', 1),
(6, 'Czech Republic', 'CZ', '+420', 1),
(7, 'Denmark', 'DK', '+45', 1),
(8, 'Finland', 'FI', '+358', 1),
(9, 'France', 'FR', '+33 9', 1),
(10, 'Greece', 'GR', '+30', 1),
(11, 'Hong Kong', 'HK', '+852', 1),
(12, 'Ireland', 'IE', '+353 76', 1),
(13, 'Israel', 'IL', '+972', 1),
(14, 'Italy', 'IT', '+39', 1),
(15, 'Japan', 'JP', '+81', 1),
(16, 'Netherlands', 'NL', '+31 85', 1),
(17, 'New Zealand', 'NZ', '+64', 1),
(18, 'Poland', 'PL', '+48', 1),
(19, 'Portugal', 'PT', '+351', 1),
(20, 'Romania', 'RO', '+40', 1),
(21, 'Spain', 'ES', '+34', 1),
(22, 'Sweden', 'SE', '+46', 1),
(23, 'Switzerland', 'CH', '+41', 1),
(24, 'United Kingdom', 'GB', '+44', 1),
(25, 'India', 'IN', '+91', 1),
(26, 'Algeria', 'DZ', '+213', 1),
(27, 'Angola', 'AO', '+244', 1),
(28, 'Benin', 'BJ', '+229', 1),
(29, 'Botswana', 'BW', '+267', 1),
(30, 'Burkina Faso', 'BF', '+226', 1),
(31, 'Burundi', 'BI', '+257', 1),
(32, 'Cameroon', 'CM', '+237', 1),
(33, 'Cape Verde', 'CV', '+238', 1),
(34, 'Central African Republic', 'CF', '+236', 1),
(35, 'Chad', 'TD', '+235', 1),
(36, 'Comoros', 'KM', '+269', 1),
(37, 'Congo', 'CG', '+242', 1),
(38, 'Congo, The Democratic Republic of the', 'CD', '+243', 1),
(39, 'Cote D\'Ivoire', 'CI', '+225', 1),
(40, 'Djibouti', 'DJ', '+253', 1),
(41, 'Egypt', 'EG', '+20', 1),
(42, 'Equatorial Guinea', 'GQ', '+240', 1),
(43, 'Eritrea', 'ER', '+291', 1),
(44, 'Ethiopia', 'ET', '+251', 1),
(45, 'Gabon', 'GA', '+241', 1),
(46, 'Gambia', 'GM', '+220', 1),
(47, 'Ghana', 'GH', '+233', 1),
(48, 'Guinea', 'GN', '+224', 1),
(49, 'Guinea-Bissau', 'GW', '+245', 1),
(50, 'Kenya', 'KE', '+254', 1),
(51, 'Lesotho', 'LS', '+266', 1),
(52, 'Liberia', 'LR', '+231', 1),
(53, 'Libya', 'LY', '+218', 1),
(54, 'Madagascar', 'MG', '+261', 1),
(55, 'Malawi', 'MW', '+265', 1),
(56, 'Mali', 'ML', '+223', 1),
(57, 'Mauritania', 'MR', '+222', 1),
(58, 'Mauritius', 'MU', '+230', 1),
(59, 'Mayotte', 'YT', '+269', 1),
(60, 'Morocco', 'MA', '+212', 1),
(61, 'Mozambique', 'MZ', '+258', 1),
(62, 'Namibia', 'NA', '+264', 1),
(63, 'Niger', 'NE', '+227', 1),
(64, 'Nigeria', 'NG', '+234', 1),
(65, 'Rwanda', 'RW', '+250', 1),
(66, 'Saint Helena', 'SH', '+290', 1),
(67, 'Sao Tome and Principe', 'ST', '+239', 1),
(68, 'Senegal', 'SN', '+221', 1),
(69, 'Seychelles', 'SC', '+248', 1),
(70, 'Sierra Leone', 'SL', '+232', 1),
(71, 'Somalia', 'SO', '+252', 1),
(72, 'South Africa', 'ZA', '+27', 1),
(73, 'Sudan', 'SD', '+249', 1),
(74, 'Swaziland', 'SZ', '+268', 1),
(75, 'Tanzania, United Republic of', 'TZ', '+255', 1),
(76, 'Togo', 'TG', '+228', 1),
(77, 'Tunisia', 'TN', '+216', 1),
(78, 'Uganda', 'UG', '+256', 1),
(79, 'Zambia', 'ZM', '+260', 1),
(80, 'Zimbabwe', 'ZW', '+263', 1),
(81, 'Antarctica', 'AQ', '+672', 1),
(82, 'Afghanistan', 'AF', '+93', 1),
(83, 'Bahrain', 'BH', '+973', 1),
(84, 'Bangladesh', 'BD', '+880', 1),
(85, 'Bhutan', 'BT', '+975', 1),
(86, 'Brunei Darussalam', 'BN', '+673', 1),
(87, 'Cambodia', 'KH', '+855', 1),
(88, 'China', 'CN', '+86', 1),
(89, 'India', 'IN', '+91', 1),
(90, 'Indonesia', 'ID', '+62', 1),
(91, 'Iran, Islamic Republic of', 'IR', '+98', 1),
(92, 'Iraq', 'IQ', '+964', 1),
(93, 'Jordan', 'JO', '+962', 1),
(94, 'Kazakhstan', 'KZ', '+7', 1),
(95, 'Korea, Democratic People\'s Republic of', 'KP', '+850', 1),
(96, 'Korea, Republic of', 'KR', '+82', 1),
(97, 'Kuwait', 'KW', '+965', 1),
(98, 'Kyrgyzstan', 'KG', '+996', 1),
(99, 'Lao People\'s Democratic Republic', 'LA', '+856', 1),
(100, 'Lebanon', 'LB', '+961', 1),
(101, 'Macau', 'MO', '+853', 1),
(102, 'Malaysia', 'MY', '+60', 1),
(103, 'Maldives', 'MV', '+960', 1),
(104, 'Mongolia', 'MN', '+976', 1),
(105, 'Myanmar', 'MM', '+95', 1),
(106, 'Nepal', 'NP', '+977', 1),
(107, 'Oman', 'OM', '+968', 1),
(108, 'Pakistan', 'PK', '+92', 1),
(109, 'Philippines', 'PH', '+63', 1),
(110, 'Qatar', 'QA', '974', 1),
(111, 'Russian Federation', 'RU', '+7', 1),
(112, 'Saudi Arabia', 'SA', '+966', 1),
(113, 'Singapore', 'SG', '+65', 1),
(114, 'Sri Lanka', 'LK', '94', 1),
(115, 'Syrian Arab Republic', 'SY', '+963', 1),
(116, 'Taiwan', 'TW', '+886', 1),
(117, 'Tajikistan', 'TJ', '+992', 1),
(118, 'Thailand', 'TH', '+66', 1),
(119, 'Turkey', 'TR', '+90', 1),
(120, 'Turkmenistan', 'TM', '+993', 1),
(121, 'United Arab Emirates', 'AE', '+971', 1),
(122, 'Uzbekistan', 'UZ', '+998', 1),
(123, 'Vietnam', 'VN', '+84', 1),
(124, 'Yemen', 'YE', '+967', 1),
(125, 'Cook Islands', 'CK', '+682', 1),
(126, 'Fiji', 'FJ', '+679', 1),
(127, 'Guam', 'GU', '+1 671', 1),
(128, 'Kiribati', 'KI', '+686', 1),
(129, 'Marshall Islands', 'MH', '+692', 1),
(130, 'Micronesia, Federated States of', 'FM', '+691', 1),
(131, 'Nauru', 'NR', '+674', 1),
(132, 'New Caledonia', 'NC', '+687', 1),
(133, 'Niue', 'NU', '+683', 1),
(134, 'Norfolk Island', 'NF', '+672', 1),
(135, 'Northern Mariana Islands', 'MP', '+670', 1),
(136, 'Palau', 'PW', '+680', 1),
(137, 'Papua New Guinea', 'PG', '+675', 1),
(138, 'Reunion', 'RE', '+262', 1),
(139, 'Samoa', 'WS', '+684', 1),
(140, 'Solomon Islands', 'SB', '+677', 1),
(141, 'Tokelau', 'TK', '+690', 1),
(142, 'Tonga', 'TO', '+676', 1),
(143, 'Tuvalu', 'TV', '+688', 1),
(144, 'Vanuatu', 'VU', '+678', 1),
(145, 'Wallis and Futuna', 'WF', '+681', 1),
(146, 'Albania', 'AL', '+355', 1),
(147, 'Andorra', 'AD', '+376', 1),
(148, 'Armenia', 'AM', '+374', 1),
(149, 'Azerbaijan', 'AZ', '+994', 1),
(150, 'Belarus', 'BY', '+375', 1),
(151, 'Bosnia and Herzegovina', 'BA', '+387', 1),
(152, 'Bulgaria', 'BG', '+359', 1),
(153, 'Croatia', 'HR', '+385', 1),
(154, 'Cyprus', 'CY', '+357', 1),
(155, 'Estonia', 'EE', '+372', 1),
(156, 'Faroe Islands', 'FO', '+298', 1),
(157, 'Georgia', 'GE', '+995', 1),
(158, 'Germany', 'DE', '+49', 1),
(159, 'Gibraltar', 'GI', '+350', 1),
(160, 'Hungary', 'HU', '+36', 1),
(161, 'Iceland', 'IS', '+354', 1),
(162, 'Latvia', 'LV', '+371', 1),
(163, 'Liechtenstein', 'LI', '+423', 1),
(164, 'Lithuania', 'LT', '+370', 1),
(165, 'Luxembourg', 'LU', '+352', 1),
(166, 'Macedonia', 'MK', '+389', 1),
(167, 'Malta', 'MT', '+356', 1),
(168, 'Moldova, Republic of', 'MD', '+373', 1),
(169, 'Monaco', 'MC', '+377', 1),
(170, 'Montenegro', 'ME', '+382', 1),
(171, 'Norway', 'NO', '+47', 1),
(172, 'San Marino', 'SM', '+378', 1),
(173, 'Serbia', 'RS', '+381', 1),
(174, 'Slovakia', 'SK', '+421', 1),
(175, 'Slovenia', 'SI', '+386', 1),
(176, 'Ukraine', 'UA', '+380', 1),
(177, 'Vatican City', 'VA', '+39', 1),
(178, 'Antigua and Barbuda', 'AG', '+1 268', 1),
(179, 'American Samoa', 'AS', '+684', 1),
(180, 'Anguilla', 'AI', '+1 264', 1),
(181, 'Aruba', 'AW', '+297', 1),
(182, 'Bahamas', 'BS', '+1 242', 1),
(183, 'Barbados', 'BB', '+1 246', 1),
(184, 'Belize', 'BZ', '+501', 1),
(185, 'Bermuda', 'BM', '+1 441', 1),
(186, 'Costa Rica', 'CR', '+506', 1),
(187, 'Cayman Islands', 'KY', '+1 345', 1),
(188, 'Cuba', 'CU', '+53', 1),
(189, 'Dominica', 'DM', '+1 767', 1),
(190, 'Dominican Republic', 'DO', '+809', 1),
(191, 'El Salvador', 'SV', '+503', 1),
(192, 'Greenland', 'GL', '+299', 1),
(193, 'Grenada', 'GD', '+1 473', 1),
(194, 'Guatemala', 'GT', '+502', 1),
(195, 'Guadeloupe', 'GP', '+590', 1),
(196, 'Haiti', 'HT', '+509', 1),
(197, 'Honduras', 'HN', '+504', 1),
(198, 'Jamaica', 'JM', '+1 876', 1),
(199, 'Martinique', 'MQ', '+596', 1),
(200, 'Mexico', 'MX', '+52', 1),
(201, 'Montserrat', 'MS', '+1 664', 1),
(202, 'Nicaragua', 'NI', '+505', 1),
(203, 'Panama', 'PA', '+507', 1),
(204, 'Puerto Rico', 'PR', '+1 787', 1),
(205, 'Saint Kitts and Nevis', 'KN', '+1 869', 1),
(206, 'Saint Lucia', 'LC', '+1 758', 1),
(207, 'Saint Pierre and Miquelon', 'PM', '508', 1),
(208, 'Saint Vincent and the Grenadines', 'VC', '+1 784', 1),
(209, 'Trinidad and Tobago', 'TT', '+1 868', 1),
(210, 'Turks and Caicos Islands', 'TC', '+1 649', 1),
(211, 'Virgin Islands, British', 'VG', '+1 284', 1),
(212, 'Virgin Islands, U.S.', 'VI', '+1 340', 1),
(213, 'Argentina', 'AR', '+54', 1),
(214, 'Bolivia', 'BO', '+591', 1),
(215, 'Brazil', 'BR', '+55', 1),
(216, 'Chile', 'CL', '+56', 1),
(217, 'Colombia', 'CO', '+57', 1),
(218, 'Ecuador', 'EC', '+593', 1),
(219, 'Falkland Islands (Malvinas)', 'FK', '+500', 1),
(220, 'French Guiana', 'GF', '+594', 1),
(221, 'Guyana', 'GY', '+592', 1),
(222, 'Paraguay', 'PY', '+595', 1),
(223, 'Peru', 'PE', '+51', 1),
(224, 'Suriname', 'SR', '+597', 1),
(225, 'Uruguay', 'UY', '+598', 1),
(226, 'Venezuela', 'VE', '+58', 1);

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `coupon_id` int(11) NOT NULL,
  `coupon_code` varchar(30) NOT NULL,
  `no_of_times` tinyint(4) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `discount_type` varchar(10) NOT NULL COMMENT '1 for flat;2 for percentage',
  `amount` decimal(10,2) NOT NULL,
  `coupon_status` tinyint(4) NOT NULL COMMENT '1 for active;0 for inactive',
  `coupon_created` datetime NOT NULL,
  `coupon_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `coupon_applied`
--

CREATE TABLE `coupon_applied` (
  `coupon_applied_id` int(11) NOT NULL,
  `coupons_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `to_be_paid` decimal(10,2) NOT NULL,
  `coupon_applied_created` datetime NOT NULL,
  `coupon_applied_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cron_cards`
--

CREATE TABLE `cron_cards` (
  `cron_card_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `mode` tinyint(1) NOT NULL,
  `order_num` text NOT NULL,
  `card_num` varchar(256) DEFAULT NULL,
  `card_month` int(11) DEFAULT NULL,
  `card_year` int(11) DEFAULT NULL,
  `card_address` varchar(256) DEFAULT NULL,
  `card_city` varchar(256) DEFAULT NULL,
  `card_state` varchar(256) DEFAULT NULL,
  `card_pincode` varchar(256) DEFAULT NULL,
  `card_country` tinyint(10) DEFAULT NULL,
  `card_response` text NOT NULL,
  `card_status` tinyint(1) NOT NULL,
  `card_auth_profile_id` varchar(256) DEFAULT NULL,
  `card_auth_pay_profile_id` varchar(256) DEFAULT NULL,
  `card_auth_shipping_id` varchar(256) DEFAULT NULL,
  `card_stripe_customer_token` varchar(256) DEFAULT NULL,
  `card_stripe_customer_id` varchar(256) DEFAULT NULL,
  `cron_card_created` datetime NOT NULL,
  `cron_card_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cron_payments`
--

CREATE TABLE `cron_payments` (
  `cron_payment_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `product_order_num` text NOT NULL COMMENT 'customer_order details id',
  `price` decimal(10,2) NOT NULL,
  `duration` tinyint(1) NOT NULL COMMENT '0 for week , 1 for month , 2 for year',
  `infinite` tinyint(1) NOT NULL COMMENT '0 for no , 1 for yes',
  `excecution_time` tinyint(1) NOT NULL COMMENT 'no of times cron to be excecuted',
  `new_cron_date` date NOT NULL COMMENT 'when cron will run again',
  `cron_created` datetime NOT NULL,
  `cron_status` tinyint(1) NOT NULL COMMENT '1 for still excecute , 0 for over '
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cron_payment_logs`
--

CREATE TABLE `cron_payment_logs` (
  `cron_payment_log_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `cron_id` int(11) NOT NULL,
  `product_order_number` text CHARACTER SET utf8 NOT NULL,
  `payment_response` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `cron_payment_log_created` datetime NOT NULL,
  `pay_mode` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cron_stop`
--

CREATE TABLE `cron_stop` (
  `cron_stop_id` int(11) NOT NULL,
  `cron_order_num` text NOT NULL,
  `cron_status` tinyint(1) NOT NULL,
  `stop_reason` text NOT NULL,
  `customers_id` int(11) NOT NULL,
  `cron_stop_created` datetime NOT NULL,
  `cron_stop_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `currency_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `currency_used` varchar(255) CHARACTER SET utf8 NOT NULL,
  `use_conversion` tinyint(1) NOT NULL DEFAULT '0',
  `USD` decimal(10,2) DEFAULT NULL,
  `GBP` decimal(10,2) DEFAULT NULL,
  `EUR` decimal(10,2) DEFAULT NULL,
  `currency_created` datetime NOT NULL,
  `currency_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`currency_id`, `group_id`, `currency_used`, `use_conversion`, `USD`, `GBP`, `EUR`, `currency_created`, `currency_modified`) VALUES
(1, 1, 'USD', 1, '1.00', '0.50', '0.50', '2018-04-10 17:43:00', '2018-04-20 16:56:17');

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

--
-- Table structure for table `currency_symbols`
--

CREATE TABLE `currency_symbols` (
  `symbol_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `currency_name` varchar(255) NOT NULL,
  `symbol` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `currency_symbols`
--

INSERT INTO `currency_symbols` (`symbol_id`, `group_id`, `currency_name`, `symbol`) VALUES
(5, 1, 'USD', '$'),
(6, 1, 'GBP', '£'),
(7, 1, 'EUR', '€');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` int(10) NOT NULL,
  `customer_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
  `customer_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
  `customer_email` varchar(100) CHARACTER SET utf8 NOT NULL,
  `customer_phone` varchar(15) CHARACTER SET utf8 NOT NULL,
  `customer_password` varchar(200) CHARACTER SET utf8 NOT NULL,
  `password_change_request` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 for yes , 0 for no ',
  `customer_status` tinyint(1) NOT NULL COMMENT '1for active;0 for deactive',
  `customer_register_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
  `customer_created` datetime NOT NULL,
  `customer_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_orders`
--

CREATE TABLE `customer_orders` (
  `customer_order_id` int(11) NOT NULL,
  `total_amount` float(10,2) NOT NULL,
  `coupons_code` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `customers_id` int(11) NOT NULL,
  `customer_order_created` datetime NOT NULL,
  `customer_number` varchar(256) CHARACTER SET utf8 NOT NULL,
  `shipment_id` int(11) NOT NULL,
  `orders_status` tinyint(4) NOT NULL COMMENT '1 for pending , 2 for procssed , 3 for shipped , 4 for delivered',
  `discount` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_order_details`
--

CREATE TABLE `customer_order_details` (
  `customer_order_detail_id` int(11) NOT NULL,
  `customer_orders_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` float(10,2) NOT NULL,
  `order_mrp_price` decimal(10,2) NOT NULL,
  `order_shipping` decimal(10,2) NOT NULL DEFAULT '0.00',
  `customer_order_details_created` datetime NOT NULL,
  `order_number` varchar(256) CHARACTER SET utf8 NOT NULL,
  `order_status` tinyint(1) NOT NULL COMMENT '1 for pending , 2 for processed , 3 for shipped , 4 for delivered , 5 for returned'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `email_logs`
--

CREATE TABLE `email_logs` (
  `email_log_id` bigint(20) NOT NULL,
  `email_to` varchar(256) CHARACTER SET utf8 NOT NULL,
  `email_to_user_id` int(11) NOT NULL,
  `email_log_subject` varchar(255) CHARACTER SET utf8 NOT NULL,
  `email_body` text CHARACTER SET utf8 NOT NULL,
  `email_message_id` varchar(500) CHARACTER SET utf8 NOT NULL,
  `email_request_id` varchar(500) CHARACTER SET utf8 NOT NULL,
  `email_status` tinyint(1) NOT NULL,
  `email_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `email_settings_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `outgoing_server_name` varchar(255) DEFAULT NULL,
  `smtp_port_no` int(2) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `amazon_email` varchar(255) DEFAULT NULL,
  `access_key` varchar(255) DEFAULT NULL,
  `secret_access_key` varchar(255) DEFAULT NULL,
  `method` tinyint(1) NOT NULL COMMENT '1 for default , 2 for smtp , 3 for amazon',
  `email_settings_created` datetime NOT NULL,
  `email_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`email_settings_id`, `group_id`, `username`, `password`, `outgoing_server_name`, `smtp_port_no`, `email`, `amazon_email`, `access_key`, `secret_access_key`, `method`, `email_settings_created`, `email_settings_modified`) VALUES
(1, 1, NULL, NULL, NULL, NULL, 'email@email.com', NULL, NULL, NULL, 1, '2018-04-20 16:02:39', '2018-04-23 14:48:45');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `email_template_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `template_slug` varchar(255) NOT NULL,
  `template_name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `email_used_for` text NOT NULL,
  `template_type_id` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '1 for active 0 for inactive',
  `template_created` datetime NOT NULL,
  `template_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`email_template_id`, `group_id`, `template_slug`, `template_name`, `subject`, `body`, `email_used_for`, `template_type_id`, `status`, `template_created`, `template_modified`) VALUES
(1, 1, 'register_email', 'Register Email (Welcome)', 'Congratulations - Your Registration Is Successful', '<p>Hello [first name] [Last name],</p>\r\n\r\n<p>Thank you for registering with Letshop.</p>\r\n\r\n<p>To gain access, [url]</p>\r\n\r\n<p>Then sign in using these credentials:</p>\r\n\r\n<p>Email: [licence email]</p>\r\n\r\n<p>Password: <em>you have set at time of account opening</em></p>\r\n\r\n<p>Be sure to save these details securely to facilitate<br />\r\nlogging in the future.</p>\r\n\r\n<p>The system is simple to access and operate. If you have<br />\r\nany trouble or any questions, please feel free to contact<br />\r\nus</p>\r\n\r\n<p>Once again, thank you for choosing us!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Regards</p>\r\n\r\n<p>&nbsp;</p>', '<p>Email Used when user Register with us. Sends this mail to welcome them</p>\r\n', 1, 1, '2017-11-10 00:00:00', '2018-01-16 17:16:01'),
(2, 1, 'forget_password', 'Forget Password', 'Request for new password', '<p>Hi&nbsp; [first name] [last name] ,</p>\r\n\r\n<p><br />\r\nClick here to reset pasword: &nbsp; [reset link]&nbsp;<br />\r\n<br />\r\nYour login email is [licence email]&nbsp;</p>\r\n\r\n<p>Best regards</p>', 'If user forgets their password and request for new one ', 3, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:20'),
(3, 1, 'reset_password', 'Reset Password Successfully', 'Reset Password Successfully', '<p>Hi [first name] [last name] ,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>You have successfully reset your password.</p>\r\n\r\n<p>Please now login with</p>\r\n\r\n<p>email :&nbsp; [licence email]</p>\r\n\r\n<p>and password which you heve recently set</p>', 'Confirms their password reset request is successful.', 2, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:19'),
(4, 1, 'contact_us', 'Contact Us', 'Request for Contacting us', '<p>Hello [first name] [Last name],</p>\r\n\r\n<p>tried to contact with Letshop.</p>\r\n\r\n<p>Please reply on mail: [licence email]</p>\r\n\r\n<p>for the following query</p>\r\n\r\n<p>[message]</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', 'This email is used when user wants to contact with the admin and posts their query.', 4, 1, '2017-11-13 00:00:00', '2017-12-28 15:57:52'),
(5, 1, 'subscription', 'Subcription', 'Subscribe with Letsshop', '<p>Hello</p>\r\n\r\n<p>Thank you for your subscription with the mail&nbsp; [licence email]</p>\r\n\r\n<p>on [date and time]</p>\r\n\r\n<p>We will update you regularly with our offers and discount</p>', '<p>Confirmation that user is successfully subscribed</p>\r\n', 5, 1, '2017-11-13 00:00:00', '2018-01-08 15:23:06'),
(6, 1, 'guest_register', 'Guest Registration', 'Congratulations You are registered', '<p>Hello [first name] [Last name],</p>\r\n\r\n<p>Thank you for registering with Letshop.</p>\r\n\r\n<p>To gain access, [url]</p>\r\n\r\n<p>Then sign in using these credentials:</p>\r\n\r\n<p>Email: [licence email]</p>\r\n\r\n<p>Password:  [password]</p>\r\n\r\n<p>Be sure to save these details securely to facilitate<br />\r\nlogging in the future.</p>\r\n\r\n<p>The system is simple to access and operate. If you have<br />\r\nany trouble or any questions, please feel free to contact<br />\r\nus</p>\r\n\r\n<p>Once again, thank you for choosing us!</p>\r\n\r\n<p>Best Regards</p>\r\n\r\n<p>&nbsp;</p>', 'If account is created for guest user . This email is used to send the credentials to the user for their account.', 6, 1, '2017-11-15 00:00:00', '2017-12-21 18:43:18'),
(7, 1, 'order_summary', 'Order Summary', 'Your Order details are', '<p><strong>Hello&nbsp;</strong> [first name] [Last name]</p>\r\n\r\n<div style=\"background:#eeeeee;border:1px solid #cccccc;padding:5px 10px;\"><strong>Order Details are</strong></div>\r\n\r\n<p>&nbsp;&nbsp; [product details]</p>\r\n\r\n<div style=\"background:#eeeeee; border:1px solid #cccccc; padding:5px 10px\"><strong>Shipping Details are</strong></div>\r\n\r\n<p><strong>City</strong> [city]&nbsp; , <strong>State</strong> [state]</p>\r\n\r\n<p><strong>Country</strong> [country]</p>\r\n\r\n<p>&nbsp;[zipcode]</p>\r\n\r\n<div style=\"background:#eeeeee;border:1px solid #cccccc;padding:5px 10px;\"><strong>Summary</strong></div>\r\n\r\n<p><strong>Total amount to be paid is</strong>&nbsp; [amount]</p>\r\n\r\n<p><strong>Ordered on </strong>[date and time]</p>\r\n\r\n<p><em><strong>Thank You for shopping with us</strong></em></p>', 'Details of the orders including its shipping details order details and payment details', 7, 1, '2017-11-16 00:00:00', '2017-12-21 18:43:17'),
(8, 1, 'status_of_product', 'Status Of Product', 'Your Product Status is', '<p>Hello <strong>[first name] [Last name]</strong></p>\r\n\r\n<p>Your order<strong> [product name]&nbsp;</strong></p>\r\n\r\n<p>Quantity - <strong>[product quantity]&nbsp;</strong> ordered on [date and time]</p>\r\n\r\n<p>Has been<strong> [status]</strong></p>\r\n\r\n<p>Amount&nbsp; Paid <strong>[product price] </strong></p>\r\n\r\n<p>Thank You for shopping with us</p>', 'This email is send to update the user about the current status of their order', 8, 1, '2017-11-21 00:00:00', '2017-12-21 18:43:17'),
(9, 1, 'recurring_payment', 'Recurring Payment', 'Payment Succcessfull', '<p>Hello [first name] [Last name]</p>\r\n\r\n<p><strong>The scheduled payment for the product is successful. on </strong> [date and time]</p>\r\n\r\n<p>Here are the details</p>\r\n\r\n<p>Product Name: [product name]</p>\r\n\r\n<p>Price: [recurring_price]</p>\r\n\r\n<p>Product Quantity: [product quantity]</p>\r\n\r\n<p>The Payment is scheduled for [duration]</p>\r\n\r\n<p>For [times] times</p>\r\n\r\n<p>Total Amount Paid : [total]</p>\r\n\r\n<p><strong>The amount is paid by using [mode] </strong></p>\r\n\r\n<p><strong>You can check by login from [licence email]</strong></p>\r\n\r\n<p>Thank You</p>', 'This is to notify the user about their scheduled recurring payments is successful', 9, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'),
(10, 1, 'recurring_payment_failure', 'Recurring Payment Failure', 'Failure of Payment Update Card', '<p>Hello [first name] [Last name]</p>\r\n\r\n<p>Your payment for the last scheduled order</p>\r\n\r\n<p>[product name] : x [product quantity] price [recurring_price]</p>\r\n\r\n<p>total = [total]</p>\r\n\r\n<p>using [mode]</p>\r\n\r\n<p>is failed.</p>\r\n\r\n<p><strong>Please click on below link to update your credentials. </strong></p>\r\n\r\n<p><a href=\"[url]\">[url]</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you</p>', 'This is to notify that the payment for their recurring order is failed.Kindly update their cards', 10, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'),
(11, 1, 'refund_successful', 'Refund Successful', 'Order Refund Successfull', '<p>Hello [first name] [Last name]</p>\n\n<p><strong>Your refund for the order</strong></p>\n\n<p>Product Name: [product name]</p>\n\n<p>Quantity: [product quantity]</p>\n\n<p>Product Price : [product price]</p>\n\n<p><strong>is successful.</strong></p>\n\n<p>You can check your order status in your account associated with [licence email]</p>\n\n<p>Order again</p>\n\n<p>Have a nice day</p>\n\n<p>Thank You</p>\n', 'This is to notify users refund request is successful and we have refunded for their order', 8, 1, '2017-12-21 00:00:00', '2017-12-21 18:57:04'),
(12, 1, 'forget_password_admin', 'Admin Forget Password', 'Forget Password', '<p>Hi&nbsp; [first name] [last name] ,</p>\r\n\r\n<p><br />\r\nClick here to reset pasword: &nbsp; [reset link]&nbsp;<br />\r\n<br />\r\nYour login email is [licence email]&nbsp;</p>\r\n\r\n<p>Best regards</p>', 'Admin password reset request ', 3, 1, '2018-01-01 00:00:00', NULL),
(13, 1, 'canceled_refund_request', 'Canceled Refund Request', 'Your refund request is Canceled', '<p>Hello [first name] [Last name]</p>\n\n<p>Your request for [product name] [product price] [product quantity]&nbsp; is cancelled by the admin.</p>\n\n<p>Thank you</p>\n\n<p>[licence email]</p>\n', '<p>cancelled refund request</p>\r\n', 8, 1, '2018-01-11 00:00:00', '2018-01-11 17:27:24');

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

--
-- Table structure for table `email_template_type`
--

CREATE TABLE `email_template_type` (
  `email_template_type_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `msg_token` varchar(255) NOT NULL,
  `template_type_status` tinyint(1) NOT NULL,
  `template_type_created` datetime NOT NULL,
  `template_type_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_template_type`
--

INSERT INTO `email_template_type` (`email_template_type_id`, `token`, `msg_token`, `template_type_status`, `template_type_created`, `template_type_modified`) VALUES
(1, '[licence email],[first name],[Last name],[url]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-10 00:00:00', NULL),
(2, '[licence email],[first name],[last name],[date and time]', '[licence email],[first name],[last name],[date and time]', 1, '2017-11-10 00:00:00', NULL),
(3, '[licence email],[first name],[last name],[reset link],[date and time]', '[licence email],[first name],[last name],[reset link],[date and time]', 1, '2017-11-10 00:00:00', NULL),
(4, '[licence email],[first name],[Last name],[date and time],[message]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-13 00:00:00', NULL),
(5, '[licence email],[date and time]', '[licence email],[date and time]', 1, '2017-11-13 00:00:00', NULL),
(6, '[licence email],[first name],[Last name],[url],[password]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-15 00:00:00', NULL),
(7, '[licence email],[first name],[Last name],[amount],[date and time],[city],[state],[country],[zipcode],[product details]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-16 00:00:00', NULL),
(8, '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity],[status]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-11-21 00:00:00', NULL),
(9, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-12-21 00:00:00', NULL),
(10, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode],[url]', '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', 1, '2017-12-21 00:00:00', NULL);

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `faq_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `faq_question` varchar(1000) NOT NULL,
  `faq_answer` text NOT NULL,
  `faq_status` tinyint(1) NOT NULL COMMENT '0 for inactive  1 for active',
  `faq_created` datetime NOT NULL,
  `faq_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `footer_tabs`
--

CREATE TABLE `footer_tabs` (
  `footer_tab_id` int(11) NOT NULL,
  `groups_id` int(11) NOT NULL,
  `tab_1` varchar(255) NOT NULL,
  `tab_2` varchar(255) NOT NULL,
  `footer_tab_created` datetime NOT NULL,
  `footer_tab_modified` datetime DEFAULT NULL,
  `tab_3` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(20) NOT NULL,
  `group_status` tinyint(1) NOT NULL,
  `group_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`group_id`, `group_name`, `group_status`, `group_created`) VALUES
(1, 'admin', 1, NULL);

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

--
-- Table structure for table `group_pages`
--

CREATE TABLE `group_pages` (
  `group_page_id` int(11) NOT NULL,
  `group_page_name` varchar(30) NOT NULL,
  `group_page_status` tinyint(1) NOT NULL COMMENT '0 for deactive;1 for active',
  `group_pages_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_pages`
--

INSERT INTO `group_pages` (`group_page_id`, `group_page_name`, `group_page_status`, `group_pages_created`) VALUES
(1, 'Policy', 1, '2018-04-16 00:00:00'),
(2, 'Company', 1, '2018-04-16 05:06:17'),
(3, 'Our Businesss', 1, '2018-04-16 00:00:00');

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

--
-- Table structure for table `headings_info`
--

CREATE TABLE `headings_info` (
  `heading_info_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `popular` varchar(255) NOT NULL,
  `products` varchar(255) NOT NULL,
  `product_image_original` varchar(255) NOT NULL,
  `product_mask_name` varchar(255) NOT NULL,
  `product_status` tinyint(1) NOT NULL,
  `heading_info_created` datetime NOT NULL,
  `heading_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `login_logs`
--

CREATE TABLE `login_logs` (
  `users_id` int(10) NOT NULL,
  `login_log_from` int(10) NOT NULL,
  `login_log_mode` varchar(256) NOT NULL,
  `login_log_ip_address` varchar(256) NOT NULL,
  `login_log_user_agent` varchar(256) NOT NULL,
  `login_log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login_logs`
--

INSERT INTO `login_logs` (`users_id`, `login_log_from`, `login_log_mode`, `login_log_ip_address`, `login_log_user_agent`, `login_log_created`) VALUES
(2, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 15:16:52'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 15:33:10'),
(2, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 18:12:10'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 18:15:01'),
(2, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 18:15:44'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-16 18:26:18'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-17 11:38:03'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-17 12:19:06'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-17 16:39:18'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-18 15:45:10'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-23 18:25:11'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-23 19:13:56'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-24 11:16:37'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-24 13:03:57'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-24 13:46:37'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0', '2018-01-24 17:37:25'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-01-29 10:56:45'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-01-29 12:34:49'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-01-29 15:04:12'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-01-30 10:57:52'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-01-31 11:49:00'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-01-31 12:40:44'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-01-31 16:49:31'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-02-01 11:01:02'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-01 11:14:22'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-01 17:03:21'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-02-02 10:42:10'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-02 11:12:03'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-02-02 16:24:08'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-02 17:04:37'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-05 15:53:41'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-06 11:04:01'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-06 18:28:39'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-07 15:35:07'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-07 19:09:59'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-08 10:54:03'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-08 19:31:35'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-09 10:37:52'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-09 18:57:38'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-12 12:06:31'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-13 10:53:45'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-14 11:18:56'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-14 19:10:25'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-15 11:04:29'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-15 16:27:21'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-16 11:14:52'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-19 10:59:02'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-19 18:07:52'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-20 10:51:59'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-20 15:22:29'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-20 19:19:25'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-21 10:40:40'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-21 16:06:09'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-21 17:50:22'),
(1, 1, 'WEB', '192.168.0.110', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36', '2018-02-21 17:59:07'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 11:16:12'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 15:49:33'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 16:36:14'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 16:37:57'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 16:40:17'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 18:13:14'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-22 19:38:00'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 11:30:18'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 15:07:13'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 16:58:38'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 17:08:48'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 17:10:12'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 17:27:09'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 18:00:27'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 18:04:20'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-23 18:17:18'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-02-26 19:11:35'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-08 10:41:25'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-09 17:28:41'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-12 12:49:12'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-12 14:43:05'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-12 18:42:37'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-13 12:00:53'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-13 12:09:27'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-13 16:59:45'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-14 11:34:20'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-14 14:02:32'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-15 19:22:02'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-19 12:49:43'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-19 17:13:31'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-20 10:57:01'),
(1, 1, 'WEB', '192.168.0.106', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-20 18:21:35'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-21 10:43:23'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-22 11:46:33'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-03-22 18:59:21'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-23 11:00:00'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-23 16:57:04'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-23 19:05:41'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-23 19:06:04'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-26 10:48:15'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-26 16:19:30'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-26 16:51:11'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-26 17:20:45'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-26 19:10:19'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-27 12:26:12'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-27 16:38:19'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-28 10:33:58'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-28 14:13:37'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-28 18:52:16'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-29 11:39:49'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-29 16:15:33'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-03-30 11:58:21'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-02 11:53:09'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-02 19:23:14'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-02 19:34:46'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-03 12:22:50'),
(1, 1, 'WEB', '192.168.0.113', 'Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-03 16:13:51'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-03 16:14:09'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-03 16:26:11'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-03 16:55:25'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-03 17:23:35'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-03 17:32:16'),
(1, 1, 'WEB', '192.168.0.106', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-03 18:38:04'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-04 11:17:01'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-05 12:20:41'),
(1, 1, 'WEB', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/58.0.3029.110 Chrome/58.0.3029.110 Safari/537.36', '2018-04-05 16:56:23'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-05 16:57:36'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-06 11:05:54'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-06 15:21:02'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-09 11:18:27'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-10 11:34:24'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-11 10:28:49'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-11 18:17:08'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-12 11:15:07'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-12 11:44:53'),
(1, 1, 'WEB', '192.168.0.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-12 16:55:07'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-12 17:28:37'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-13 11:33:46'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-16 11:12:11'),
(1, 1, 'WEB', '192.168.0.113', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.79 Safari/537.36', '2018-04-16 11:13:16'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-16 11:16:32'),
(1, 1, 'WEB', '192.168.0.113', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.79 Safari/537.36', '2018-04-16 11:18:05'),
(1, 1, 'WEB', '192.168.0.113', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.79 Safari/537.36', '2018-04-16 11:28:15'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-16 15:35:53'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-17 10:57:55'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-17 11:03:11'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-17 11:15:22'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-17 15:18:31'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-18 11:29:22'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-18 16:00:45'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-18 17:26:16'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-18 19:05:47'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-19 10:37:19'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-19 17:42:50'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-20 11:00:51'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-20 12:40:31'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-20 12:51:25'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-20 18:05:52'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-23 12:21:01'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-23 12:36:33'),
(1, 1, 'WEB', '192.168.0.111', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.167 Safari/537.36', '2018-04-23 12:52:19'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-23 14:46:28');

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

--
-- Table structure for table `logo_images`
--

CREATE TABLE `logo_images` (
  `logo_image_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `logo_type` tinyint(1) DEFAULT NULL,
  `logo_status` tinyint(1) DEFAULT NULL,
  `logo_image_original` varchar(255) DEFAULT NULL,
  `logo_mask_name` varchar(255) DEFAULT NULL,
  `logo_image_created` datetime DEFAULT NULL,
  `logo_modified` datetime DEFAULT NULL,
  `favicon_image_original` varchar(255) DEFAULT NULL,
  `favicon_mask_name` varchar(255) DEFAULT NULL,
  `favicon_type` tinyint(1) DEFAULT NULL,
  `favicon_status` tinyint(1) DEFAULT NULL,
  `favicon_created` datetime DEFAULT NULL,
  `favicon_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `menu_positions`
--

CREATE TABLE `menu_positions` (
  `menu_position_id` int(11) NOT NULL,
  `groups_id` int(11) NOT NULL,
  `positioning` tinyint(1) NOT NULL,
  `menu_name` varchar(5) NOT NULL,
  `menu_type` tinyint(4) NOT NULL COMMENT '1 home, 2 product,3 categories,4 brands,5 for blog , 6 contact',
  `menu_status` tinyint(4) NOT NULL COMMENT '1 for show , 0 for hide',
  `menu_position_created` datetime NOT NULL,
  `menu_position_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu_positions`
--

INSERT INTO `menu_positions` (`menu_position_id`, `groups_id`, `positioning`, `menu_name`, `menu_type`, `menu_status`, `menu_position_created`, `menu_position_updated`) VALUES
(2, 1, 1, 'set_1', 1, 1, '2018-04-02 00:00:00', '2018-04-20 12:24:26'),
(3, 1, 3, 'set_2', 2, 1, '2018-04-02 00:00:00', '2018-04-20 12:24:27'),
(5, 1, 2, 'set_4', 4, 1, '2018-04-02 00:00:00', '2018-04-20 12:24:27'),
(6, 1, 4, 'set_5', 5, 1, '2018-04-02 00:00:00', '2018-04-20 12:24:27'),
(7, 1, 5, 'set_6', 6, 1, '2018-04-02 00:00:00', '2018-04-20 12:24:27');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `group_pages_id` int(11) NOT NULL,
  `page_type` tinyint(1) NOT NULL COMMENT '1 for policy , 2 for company , 3 for buissness',
  `page_name` varchar(50) NOT NULL,
  `page_slug` varchar(255) NOT NULL,
  `page_body` text NOT NULL,
  `page_metakeyword` varchar(1000) NOT NULL,
  `page_metadescription` varchar(1000) NOT NULL,
  `page_status` tinyint(1) NOT NULL DEFAULT '1',
  `page_created` datetime NOT NULL,
  `page_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `group_pages_id`, `page_type`, `page_name`, `page_slug`, `page_body`, `page_metakeyword`, `page_metadescription`, `page_status`, `page_created`, `page_modified`) VALUES
(1, 1, 0, 'How It Works', 'how_it_works', '<p>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. 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. 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>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. 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. 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>', 'How it Works', 'How it Works', 1, '2017-10-13 00:00:00', '2018-04-20 16:29:02'),
(2, 1, 1, 'Terms & Conditions', 'terms_conditions', '<p>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. 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. 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>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. 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. 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>', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:12'),
(3, 1, 1, 'Privacy Policy', 'privacy_policy', '<p>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. 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. 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>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. 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. 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>', 'Privacy Policy', 'Privacy Policy', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:28'),
(4, 2, 2, 'About us', 'about_us', '<p>accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'About us', 'About us', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:21'),
(5, 1, 1, 'Terms of Sale ', 'terms_of_sale', '<p>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. 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. 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>nm,</p>', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:16'),
(6, 1, 1, 'Terms of Use', 'terms_of_use', '<p>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. 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. 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>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. 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. 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>', 'Terms of Use', 'Terms of Use', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:19'),
(7, 2, 2, 'Core Values', 'core_values', '<p>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. 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. 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>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. 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. 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>', 'Core Values', 'Core Values', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:23'),
(8, 2, 3, 'Careers', 'careers', '<p>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. 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. 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>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. 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. 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>', 'Careers', 'Careers', 1, '2017-10-13 16:35:48', '2018-04-17 18:49:19'),
(9, 1, 1, 'Report Abuse', 'report_abuse', '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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Report Abuse', 'Report Abuse', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:40'),
(10, 2, 2, 'Engineering', 'engineering', '<p>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. 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>', 'Engineering', 'Engineering', 1, '2017-10-24 00:00:00', '2018-04-16 16:59:32'),
(11, 3, 3, 'Online Shopping', 'online_shopping', '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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Online Shopping', 'Online Shopping', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:14'),
(12, 3, 3, 'Sell on Online', 'sell_on_online', '<p>&#39;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. 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. The standard chunk of Lorem</p>', 'Sell on Online', 'Sell on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(13, 3, 3, 'Advertise on Online', 'advertise_on_online', '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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Advertise on Online', 'Advertise on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(14, 3, 3, 'Media Enquiries', 'media_enquiries', '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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Media Enquiries', 'Media Enquiries', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11'),
(15, 3, 3, 'Be an Affiliate ', 'be_an_affiliate ', '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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\r\n\r\nContrary 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. 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 \"de Finibus Bonorum et Malorum\" (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, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. 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 \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Be an Affiliate ', 'Be an Affiliate ', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11');

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

--
-- Table structure for table `payment_details`
--

CREATE TABLE `payment_details` (
  `payment_detail_id` int(11) NOT NULL,
  `customer_orders_id` int(11) DEFAULT NULL,
  `customers_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `paid_amount` decimal(10,2) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `payment_status` int(11) NOT NULL,
  `payment_mode` tinyint(1) NOT NULL COMMENT '1 for paypal , 2 for authorise , 3 for stripe',
  `payment_details_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `plan_logs_id` int(11) NOT NULL,
  `plans_id` int(11) NOT NULL,
  `product_limit` varchar(255) CHARACTER SET utf8 NOT NULL,
  `plan_log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(10) NOT NULL,
  `product_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `product_description` text CHARACTER SET utf8 NOT NULL,
  `mrp_price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) DEFAULT '0.00',
  `shipping_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `recurring` tinyint(1) NOT NULL,
  `duration` tinyint(1) DEFAULT NULL,
  `returning` int(10) NOT NULL,
  `recurring_price` varchar(255) DEFAULT NULL,
  `infinite` tinyint(1) DEFAULT '0',
  `times` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `brands_id` int(10) DEFAULT NULL,
  `categories_id` int(11) DEFAULT NULL,
  `product_status` tinyint(1) NOT NULL COMMENT '1 for active , 0 for Inactive',
  `product_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
  `video_link` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `meta_tags` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `keywords` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8,
  `product_tag` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `is_featured` tinyint(1) DEFAULT '0',
  `product_created` datetime NOT NULL,
  `product_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`product_id`, `product_name`, `product_description`, `mrp_price`, `sale_price`, `shipping_price`, `recurring`, `duration`, `returning`, `recurring_price`, `infinite`, `times`, `brands_id`, `categories_id`, `product_status`, `product_slug`, `video_link`, `meta_tags`, `keywords`, `meta_description`, `product_tag`, `is_featured`, `product_created`, `product_modified`) VALUES
(57, '22KT Gold Bangle', '<p>22KT Gold Bangle</p>\r\n\r\n<p>This 22KT yellow gold bangle features intricate machine cut designs. The bangle showcases a high-polished finish and fine-cut designs, embellishing the bangle. The high-polished finish and the machine cut designs of the bangle makes it a perfect match for any occasion and any attire.</p>', '3300.00', '3250.00', '0.00', 0, 0, 15, '', 1, '', 62, 28, 1, 'radio', '', '22KT Gold Bangle', '22KT Gold Bangle', '22KT Gold Bangle', '22KT Gold Bangle', 1, '2018-03-13 16:19:33', '2018-04-20 12:28:57'),
(58, '4KT Yellow And White Gold Diamond Necklace with Floral Pendant', '<p>4KT Yellow And White Gold Diamond Necklace with Floral Pendant</p>\r\n\r\n<p>This 14KT yellow and white gold necklace features a snake chain and a pendant adorned with diamonds. The diamonds are of SI2 clarity and fall within the I-J colour range. The pendant is suspended from the chain and highlights two white gold open, floral motifs of the upper and lower part; and a yellow gold floral element in between. While the diamonds on the white gold elements are interspersed, the ones on the yellow gold are arranged at the centre. All diamonds are secured in shared prong settings. Due to a high-polished finish, the necklace looks shiny.</p>', '3600.00', '3400.00', '10.00', 0, 0, 15, '', 1, '', 62, 26, 1, 'jbl-c100si-in-ear-headphones-with-mic-black', NULL, '4KT Yellow And White Gold Diamond Necklace with Floral Pendant', '4KT Yellow And White Gold Diamond Necklace with Floral Pendant', '4KT Yellow And White Gold Diamond Necklace with Floral Pendant', '4KT Yellow And White Gold Diamond Necklace with Floral Pendant', 1, '2018-03-14 12:41:27', '2018-04-20 12:27:07'),
(59, '22KT Gold Drops', '<p>This pair of 22KT yellow gold drop earrings features circular base studs and inverted heart-shaped danglers. The base studs display green enamel work at the centre and are adorned with floral clusters of Rawa balls. A red teardrop-shaped element and twisted wire structures along with two paisley motifs embellish the dangler. A set of three clappers are suspended from the lower end of the danglers with a wide O-ring. Fitted with Bombay screws, these earrings ensure safety and comfort. These ornate earrings will add a special touch to any formal, ethnic apparel.</p>', '2600.00', '2500.00', '20.00', 0, 0, 12, '', 1, '', 62, 25, 1, 'fogg-stainless-steel-day-and-date-blue-dial-analog-mens-watch-2038-bl', NULL, '22KT Gold Drops', '22KT Gold Drops', '22KT Gold Drops', '22KT Gold Drops', 1, '2018-03-14 12:49:39', '2018-04-20 12:27:35'),
(60, 'Mangalam 18KT Rose Gold Diamond Pendant with Floral Design', '<p>Tanishq Mangalam 18KT Rose Gold Diamond Pendant with Floral Design<br />\r\nDrawing inspiration from the bounteous beauty of nature, this stunning pendant comes alive with the cluster of sparkling diamonds at its crown. The design captures the delicate symmetry of a majestic flower in full bloom. The pendant is crafted from 18KT rose gold.</p>', '3000.00', '2900.00', '15.00', 0, 0, 15, '', 1, '', 61, 27, 1, 'inkovy-full-sleeve-mens-cotton-hooded-t-shirt', NULL, '18KT Rose Gold Diamond ', '18KT Rose Gold Diamond ', 'Mangalam 18KT Rose Gold Diamond Pendant with Floral Design', 'Gold Diamond', 1, '2018-03-21 14:56:11', '2018-04-20 16:19:52'),
(61, 'Tanishq Mangalam 22KT Yellow Gold Finger Ring', '<p>Illustrating the beauty of a swan, this finger ring is the epitome of grace and elegance. A satin finish along with openwork on the swan&#39;s body casts an enchanting spell. This ring is forged from 22KT gold.</p>\r\n\r\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:500px\">\r\n	<tbody>\r\n		<tr>\r\n			<td><strong>Brand</strong></td>\r\n			<td><strong>Tanishq</strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td>Collection</td>\r\n			<td>Mangalam</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Metal</td>\r\n			<td>Gold</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Jewellery Type</td>\r\n			<td>Plain Jewellery</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Gold Karatage</td>\r\n			<td>22KT</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Metal Color</td>\r\n			<td>Yellow</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Category</td>\r\n			<td>Finger Ring</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Gender</td>\r\n			<td>Women</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Size</td>\r\n			<td>L</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Product</td>\r\n			<td>Finger Ring</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>', '7000.00', '6000.00', '0.00', 0, 1, 0, '0', 1, '0', 61, 24, 1, 'tanishq-mangalam-22kt-yellow-gold-finger-ring', NULL, 'Tanishq Mangalam Finger Ring', 'Tanishq Mangalam Finger Ring', NULL, 'Gold Finger Ring', 1, '2018-04-20 14:30:34', '2018-04-20 16:19:58'),
(62, 'Ring', '<ul>\r\n	<li>Construct of High Hardness Tungsten Carbide, Excellent Scratch Resistant Performance, Longer Using Time.</li>\r\n	<li>Great Workmanship on Brushed Matte Surface, Add on High Polish Smooth Inner Face, Bring You Both the Elegance and Comfort.</li>\r\n	<li>Perfect 6mm Width, Suitable for Both Men and Women.</li>\r\n	<li>Durable and Weighty Tungsten Carbide.</li>\r\n	<li>Provide with Life-time Guarantee</li>\r\n</ul>', '50.00', '50.00', '0.00', 0, 1, 15, '0', 1, '0', 61, 24, 1, 'ring', NULL, 'Tungary Tungsten Rings for Men Wedding Engagement Band Brushed Black 6mm Size 6-14', 'Tungary Tungsten Rings for Men Wedding Engagement Band Brushed Black 6mm Size 6-14', NULL, 'Tungary Tungsten Rings for Men Wedding Engagement Band Brushed Black 6mm Size 6-14', 1, '2018-04-20 15:39:18', '2018-04-20 16:19:57'),
(63, 'Tie Clip', '<ul>\r\n	<li>Add that extra touch of perfection with this fine alloy tie clip featuring gold foamed mustache shaped silver body with impressive details .</li>\r\n	<li>Dimensions : Width : 8 mm, Length : 5 cms .Weight : 6 grams.</li>\r\n	<li>Material : High quality steel alloy with superior gold foaming.</li>\r\n	<li>Arrives in a complimentary gift box.</li>\r\n	<li>Pattern : Mustache</li>\r\n</ul>', '600.00', '599.00', '50.00', 0, 1, 10, '0', 1, '0', 61, 24, 1, 'tie-clip', 'https://www.youtube.com/watch?v=xCz3wuGL-E8', NULL, NULL, NULL, NULL, 1, '2018-04-20 16:42:05', '2018-04-20 17:20:03');

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

--
-- Table structure for table `product_colors`
--

CREATE TABLE `product_colors` (
  `product_colors_id` bigint(20) NOT NULL,
  `products_id` int(10) NOT NULL,
  `colors_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `product_color_created` datetime NOT NULL,
  `product_color_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_colors`
--

INSERT INTO `product_colors` (`product_colors_id`, `products_id`, `colors_name`, `product_color_created`, `product_color_modified`) VALUES
(1, 62, 'Grey', '2018-04-20 15:40:08', NULL),
(2, 62, 'Black', '2018-04-20 15:40:08', NULL);

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

--
-- Table structure for table `product_csv_files`
--

CREATE TABLE `product_csv_files` (
  `csv_file_id` int(11) NOT NULL,
  `csv_file_original` varchar(255) NOT NULL,
  `csv_mask_name` text NOT NULL,
  `csv_file_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `product_dimensions`
--

CREATE TABLE `product_dimensions` (
  `product_dimensions_id` int(10) NOT NULL,
  `products_id` int(10) NOT NULL,
  `height` decimal(10,2) DEFAULT NULL,
  `width` decimal(10,2) DEFAULT NULL,
  `weight` decimal(10,6) DEFAULT NULL,
  `dimensions_created` datetime NOT NULL,
  `dimensions_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_dimensions`
--

INSERT INTO `product_dimensions` (`product_dimensions_id`, `products_id`, `height`, `width`, `weight`, `dimensions_created`, `dimensions_modified`) VALUES
(1, 60, '0.00', '0.00', '0.924000', '2018-04-20 11:43:38', NULL),
(2, 59, '0.00', '0.00', '4.264000', '2018-04-20 12:17:48', NULL),
(3, 58, '0.00', '0.00', '6.908000', '2018-04-20 12:26:19', NULL),
(4, 57, '0.00', '0.00', '8.224000', '2018-04-20 12:30:38', NULL),
(5, 62, '15.00', '15.00', '1.500000', '2018-04-20 15:40:08', NULL);

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `product_image_id` int(10) NOT NULL,
  `products_id` int(10) NOT NULL,
  `product_image_original` varchar(256) NOT NULL,
  `product_mask_name` varchar(256) NOT NULL,
  `image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`product_image_id`, `products_id`, `product_image_original`, `product_mask_name`, `image_created`) VALUES
(205, 60, '502999PAFAAA02.jpg', '77d9f482fac2ec96359b2dbc08c687ee.jpg', '2018-04-20 11:37:22'),
(206, 60, '503117PHVAAA22.jpg', 'd04099f2d05be0d39e3375fe521c5104.jpg', '2018-04-20 11:37:30'),
(207, 59, 'pen.jpg', 'f52442e5037db7c2689642b4868f233b.jpg', '2018-04-20 11:52:25'),
(208, 59, '511300DAIABA00.jpg', '631dee878150f2457d37ad9df7b1265e.jpg', '2018-04-20 11:52:29'),
(209, 58, '552811NJBAAA22.jpg', '951bcff812516e6ac6fe02d182c99204.jpg', '2018-04-20 12:25:25'),
(210, 58, 'bronze_copper.jpg', 'a1236233132e5848880736c87739122f.jpg', '2018-04-20 12:25:42'),
(211, 57, '512216VIVM2A00.jpg', '59f8bd6784d66119394bd9419d83f70f.jpg', '2018-04-20 12:29:59'),
(212, 57, '512216VIVM2A00.jpg', 'e6bb1b4247f7eaf86f61f32521104867.jpg', '2018-04-20 12:30:16'),
(213, 61, '513017FMMLAA00 (2).jpg', '78c7cc35da319629034641bd82929814.jpg', '2018-04-20 14:34:10'),
(214, 61, '513017FMMLAA00 (1).jpg', '5fb5c08a303c62ae681cd728adaeb8ab.jpg', '2018-04-20 14:34:11'),
(215, 61, '513017FMMLAA00.jpg', '5238bd8524938103c4836d8b450dd74a.jpg', '2018-04-20 14:34:13'),
(216, 62, '61Uk-Rud8NL._UY575_.jpg', 'ea89c9c4fe9ebfb9cd301376db950305._UY575_', '2018-04-20 15:39:47'),
(218, 63, '61i7QBN9IfL._UL1500_.jpg', '754997c357361fac887c9ac7b499a567._UL1500_', '2018-04-20 16:42:59'),
(220, 63, '71yorfypVSL._UL1500_.jpg', 'c7896a3074b3e6d1ed9168fc38a2be57._UL1500_', '2018-04-20 17:20:01');

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

--
-- Table structure for table `product_subcategories`
--

CREATE TABLE `product_subcategories` (
  `product_sub_category_id` bigint(10) NOT NULL,
  `products_id` int(10) NOT NULL,
  `sub_categories_id` int(10) NOT NULL,
  `product_sub_category_created_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_subcategories`
--

INSERT INTO `product_subcategories` (`product_sub_category_id`, `products_id`, `sub_categories_id`, `product_sub_category_created_on`) VALUES
(77, 60, 29, NULL),
(80, 58, 28, NULL),
(81, 57, 30, NULL),
(82, 59, 27, NULL),
(84, 61, 26, '2018-04-20 14:30:41'),
(86, 62, 26, '2018-04-20 15:39:26'),
(87, 63, 26, NULL);

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

--
-- Table structure for table `refund_payments`
--

CREATE TABLE `refund_payments` (
  `refund_payment_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `order_numbers` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `refundtransactioniId` varchar(255) DEFAULT NULL,
  `refundfeesamout` decimal(10,2) DEFAULT NULL,
  `refundresponse` text NOT NULL,
  `netrefundamt` decimal(10,2) DEFAULT NULL,
  `refund_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 0 for default orders, 1 for recurring orders',
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `related_products`
--

CREATE TABLE `related_products` (
  `related_product_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `product_related_id` int(11) NOT NULL,
  `related_product_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `related_products`
--

INSERT INTO `related_products` (`related_product_id`, `products_id`, `product_related_id`, `related_product_created`) VALUES
(2, 59, 57, '2018-03-14 12:52:09'),
(3, 59, 59, '2018-04-20 12:18:03'),
(4, 58, 59, '2018-04-20 12:25:57'),
(5, 58, 60, '2018-04-20 12:26:01'),
(6, 57, 58, '2018-04-20 12:30:43'),
(7, 57, 60, '2018-04-20 12:30:45'),
(8, 61, 61, '2018-04-20 14:37:26'),
(9, 61, 60, '2018-04-20 14:37:30'),
(10, 61, 58, '2018-04-20 14:37:31'),
(11, 62, 61, '2018-04-20 15:40:16'),
(12, 62, 62, '2018-04-20 15:40:17');

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

--
-- Table structure for table `return_cancel_orders`
--

CREATE TABLE `return_cancel_orders` (
  `return_cancel_order_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `order_numbers` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '0, for no action , 1 for refunded , 2 for cancelled',
  `ip_address` varchar(255) NOT NULL,
  `single` tinyint(1) NOT NULL,
  `reason` text,
  `action` tinyint(1) NOT NULL COMMENT '0 for cancel order and 1 for return order , 2 for recurring refund',
  `recurring_id` int(11) DEFAULT NULL,
  `return_cancel_orders_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `review_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `orders_num` varchar(256) NOT NULL,
  `products_id` int(11) NOT NULL,
  `rating` tinyint(1) NOT NULL DEFAULT '0',
  `reviews` text,
  `review_status` tinyint(1) NOT NULL,
  `review_created` datetime NOT NULL,
  `review_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`review_id`, `customers_id`, `orders_num`, `products_id`, `rating`, `reviews`, `review_status`, `review_created`, `review_modified`) VALUES
(1, 3, 'DZQYZLH3757FL8G', 62, 4, 'Nice product, having the quality better than expectations', 1, '2018-04-20 16:24:39', '2018-04-20 17:00:27');

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

--
-- Table structure for table `save_cards`
--

CREATE TABLE `save_cards` (
  `save_card_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `method` tinyint(1) NOT NULL,
  `name_on_card` varchar(255) DEFAULT NULL,
  `card_number` varchar(255) DEFAULT NULL,
  `authorise_address` varchar(255) DEFAULT NULL,
  `authorise_city` varchar(255) DEFAULT NULL,
  `authorise_state` varchar(255) DEFAULT NULL,
  `authorise_postal_code` varchar(255) DEFAULT NULL,
  `authorise_country` varchar(255) DEFAULT NULL,
  `stripe_month` tinyint(4) DEFAULT NULL,
  `stripe_year` varchar(4) DEFAULT NULL,
  `save_cards_created` datetime NOT NULL,
  `save_cards_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `save_cards`
--

INSERT INTO `save_cards` (`save_card_id`, `customers_id`, `method`, `name_on_card`, `card_number`, `authorise_address`, `authorise_city`, `authorise_state`, `authorise_postal_code`, `authorise_country`, `stripe_month`, `stripe_year`, `save_cards_created`, `save_cards_modified`) VALUES
(1, 3, 3, NULL, '4242424242424242', NULL, NULL, NULL, NULL, NULL, 4, '2022', '2018-04-23 12:24:07', NULL);

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

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

CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `site_name` varchar(255) NOT NULL,
  `site_keyword` varchar(255) DEFAULT NULL,
  `site_description` text,
  `blog_page` varchar(255) NOT NULL,
  `google_analytic_code` text,
  `facebook_tracking` text,
  `facebook_id` varchar(255) DEFAULT NULL,
  `twitter_user_id` varchar(255) DEFAULT NULL,
  `youtube_channel_id` varchar(255) DEFAULT NULL,
  `instagram_user_id` varchar(255) DEFAULT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `settings_created` datetime NOT NULL,
  `settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`settings_id`, `group_id`, `site_name`, `site_keyword`, `site_description`, `blog_page`, `google_analytic_code`, `facebook_tracking`, `facebook_id`, `twitter_user_id`, `youtube_channel_id`, `instagram_user_id`, `email`, `phone`, `settings_created`, `settings_modified`) VALUES
(1, 1, 'Jewellery Store', 'Jewellery Store', 'Best Jewellery Store in you area, since 1960', '', '      ', '', '', '', '', '', 'email@email.com', '97336526', '2018-04-20 15:51:45', '2018-04-23 14:47:22');

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

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `status_id` int(11) NOT NULL,
  `status` varchar(256) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`status_id`, `status`) VALUES
(1, 'Pending'),
(2, 'Processed'),
(3, 'Shipped'),
(4, 'Delivered'),
(5, 'Returned'),
(6, 'Refunded'),
(7, 'Stopped');

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

--
-- Table structure for table `status_logs`
--

CREATE TABLE `status_logs` (
  `status_log_id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `customer_order_details_id` int(11) NOT NULL,
  `order_status` tinyint(1) NOT NULL,
  `log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status_logs`
--

INSERT INTO `status_logs` (`status_log_id`, `users_id`, `customer_order_details_id`, `order_status`, `log_created`) VALUES
(1, 1, 5, 2, '2018-04-18 16:33:11'),
(2, 1, 6, 2, '2018-04-18 16:47:43'),
(3, 1, 18, 2, '2018-04-20 16:17:25'),
(4, 1, 18, 3, '2018-04-20 16:18:38'),
(5, 1, 18, 4, '2018-04-20 16:18:52'),
(6, 1, 17, 5, '2018-04-20 16:56:30'),
(7, 1, 17, 4, '2018-04-20 16:56:42'),
(8, 1, 19, 3, '2018-04-20 17:53:42'),
(9, 1, 19, 1, '2018-04-20 17:54:28'),
(10, 1, 21, 2, '2018-04-20 18:05:02'),
(11, 1, 21, 3, '2018-04-20 18:06:34');

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `subscriber_id` int(11) NOT NULL,
  `customers_email` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `subscribed_on` datetime NOT NULL,
  `subscriber_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `sub_category_id` int(11) NOT NULL,
  `categories_id` int(11) NOT NULL,
  `sub_category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `sub_category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
  `sub_category_status` tinyint(1) NOT NULL COMMENT '1 for active 0 for unactive',
  `sub_category_created` datetime NOT NULL,
  `sub_category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`sub_category_id`, `categories_id`, `sub_category_name`, `sub_category_slug`, `sub_category_status`, `sub_category_created`, `sub_category_modified`) VALUES
(26, 24, 'General', 'general', 1, '2017-10-25 00:00:00', NULL),
(27, 25, 'Stud', 'stud_', 1, '2018-03-20 15:49:55', '2018-04-20 11:30:30'),
(28, 26, 'Neckwear', 'neckwear_', 1, '2018-03-21 14:59:48', '2018-04-20 11:31:47'),
(29, 27, 'Gold', 'gold_', 1, '2018-03-21 14:59:59', '2018-04-20 11:49:16'),
(30, 28, 'Plain Gold', 'plain-gold_', 1, '2018-03-21 15:00:10', '2018-04-20 11:31:40');

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

--
-- Table structure for table `sub_menu`
--

CREATE TABLE `sub_menu` (
  `sub_menu_id` int(11) NOT NULL,
  `categories_id` int(11) NOT NULL,
  `groups_id` int(11) NOT NULL,
  `sub_menu_created` datetime NOT NULL,
  `sub_menu_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_menu`
--

INSERT INTO `sub_menu` (`sub_menu_id`, `categories_id`, `groups_id`, `sub_menu_created`, `sub_menu_updated`) VALUES
(1, 28, 1, '2018-04-23 14:43:55', NULL),
(2, 26, 1, '2018-04-23 14:43:55', NULL),
(3, 27, 1, '2018-04-23 14:43:55', NULL);

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `template_id` int(11) NOT NULL,
  `groups_id` int(11) NOT NULL,
  `value` tinyint(1) NOT NULL,
  `template_created` datetime NOT NULL,
  `template_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` (`template_id`, `groups_id`, `value`, `template_created`, `template_updated`) VALUES
(2, 1, 3, '2018-03-23 17:47:13', '2018-04-18 19:06:47');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(10) NOT NULL,
  `groups_id` int(11) NOT NULL DEFAULT '1',
  `group_slug` varchar(20) CHARACTER SET utf8 NOT NULL,
  `user_email` varchar(256) CHARACTER SET utf8 NOT NULL,
  `user_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
  `user_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
  `user_password` varchar(256) CHARACTER SET utf8 NOT NULL,
  `user_status` tinyint(1) NOT NULL COMMENT '0 for deactivate and 1 for activate',
  `user_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
  `user_created` datetime NOT NULL,
  `user_update` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `groups_id`, `group_slug`, `user_email`, `user_firstname`, `user_lastname`, `user_password`, `user_status`, `user_ip`, `user_created`, `user_update`) VALUES
(1, 1, 'admin', 'agent@wpgateway.com', 'agent@wpgateway.com', ' ', '21232f297a57a5a743894a0e4a801fc3', 1, '192.168.0.105', '2017-09-14 00:00:00', '2018-03-29 14:53:37');

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

--
-- Table structure for table `user_credentials`
--

CREATE TABLE `user_credentials` (
  `user_credential_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `no_of_days` int(11) NOT NULL DEFAULT '15',
  `user_stripe_key` varchar(255) DEFAULT NULL,
  `user_auth_login_name` varchar(255) DEFAULT NULL,
  `user_auth_transaction_key` varchar(255) DEFAULT NULL,
  `user_paypal_method_type` tinyint(1) DEFAULT NULL COMMENT '1 for standard; 2 for recurring bussiness ; 3 for paypal recurring',
  `paypal_standard_email` varchar(255) DEFAULT NULL,
  `paypal_api_name` varchar(255) DEFAULT NULL,
  `paypal_api_password` varchar(255) DEFAULT NULL,
  `paypal_signature` text,
  `use_stripe` tinyint(1) NOT NULL DEFAULT '0',
  `use_authorise` tinyint(1) NOT NULL DEFAULT '0',
  `use_paypal` tinyint(1) NOT NULL DEFAULT '0',
  `user_credentials_updation_on` datetime DEFAULT NULL,
  `user_credential_created_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_credentials`
--

INSERT INTO `user_credentials` (`user_credential_id`, `group_id`, `no_of_days`, `user_stripe_key`, `user_auth_login_name`, `user_auth_transaction_key`, `user_paypal_method_type`, `paypal_standard_email`, `paypal_api_name`, `paypal_api_password`, `paypal_signature`, `use_stripe`, `use_authorise`, `use_paypal`, `user_credentials_updation_on`, `user_credential_created_on`) VALUES
(1, 1, 15, 'sk_test_gak3Xe918xKaWRzQj4SM0a2k', NULL, NULL, 1, 'birender.rana-facilitator@ajdevtech.com', 'kapoor.asr-facilitator_api1.gmail.com', '1362989870', 'AZEe4wgrm-F1vcutfSbC2IAiHuOTA4h-Bpkf20-vmDFz6ZqiZfkul0SL', 1, 0, 1, '2018-04-23 12:23:38', '2018-04-20 11:33:23');

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

--
-- Table structure for table `versions`
--

CREATE TABLE `versions` (
  `version_id` int(11) NOT NULL,
  `version_no` decimal(10,2) NOT NULL,
  `version_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `versions`
--

INSERT INTO `versions` (`version_id`, `version_no`, `version_created`) VALUES
(1, '1.00', '2018-02-22 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `address_book`
--
ALTER TABLE `address_book`
  ADD PRIMARY KEY (`address_id`),
  ADD KEY `customers_id` (`customers_id`),
  ADD KEY `customers_id_2` (`customers_id`),
  ADD KEY `address_city` (`address_city`),
  ADD KEY `address_country` (`address_country`),
  ADD KEY `is_default` (`is_default`);

--
-- Indexes for table `add_register_user_payment`
--
ALTER TABLE `add_register_user_payment`
  ADD PRIMARY KEY (`register_payment_id`);

--
-- Indexes for table `banner_images`
--
ALTER TABLE `banner_images`
  ADD PRIMARY KEY (`banner_image_id`);

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

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`brand_id`);

--
-- Indexes for table `cart_added`
--
ALTER TABLE `cart_added`
  ADD PRIMARY KEY (`cart_added_id`),
  ADD KEY `products_id` (`products_id`),
  ADD KEY `customers_id` (`customers_id`);

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

--
-- Indexes for table `color_settings`
--
ALTER TABLE `color_settings`
  ADD PRIMARY KEY (`color_settings_id`);

--
-- Indexes for table `contact_info`
--
ALTER TABLE `contact_info`
  ADD PRIMARY KEY (`contact_info_id`),
  ADD KEY `users_id` (`group_id`),
  ADD KEY `postal_code` (`postal_code`);

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

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`coupon_id`),
  ADD KEY `coupon_code` (`coupon_code`),
  ADD KEY `discount_type` (`discount_type`);

--
-- Indexes for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
  ADD PRIMARY KEY (`coupon_applied_id`);

--
-- Indexes for table `cron_cards`
--
ALTER TABLE `cron_cards`
  ADD PRIMARY KEY (`cron_card_id`);

--
-- Indexes for table `cron_payments`
--
ALTER TABLE `cron_payments`
  ADD PRIMARY KEY (`cron_payment_id`);

--
-- Indexes for table `cron_payment_logs`
--
ALTER TABLE `cron_payment_logs`
  ADD PRIMARY KEY (`cron_payment_log_id`);

--
-- Indexes for table `cron_stop`
--
ALTER TABLE `cron_stop`
  ADD PRIMARY KEY (`cron_stop_id`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`currency_id`);

--
-- Indexes for table `currency_symbols`
--
ALTER TABLE `currency_symbols`
  ADD PRIMARY KEY (`symbol_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customer_id`),
  ADD KEY `customer_status` (`customer_status`),
  ADD KEY `customer_email` (`customer_email`),
  ADD KEY `customer_phone` (`customer_phone`),
  ADD KEY `customer_firstname` (`customer_firstname`),
  ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `customer_orders`
--
ALTER TABLE `customer_orders`
  ADD PRIMARY KEY (`customer_order_id`),
  ADD KEY `customer_order_id` (`customer_order_id`),
  ADD KEY `customers_id` (`customers_id`),
  ADD KEY `customer_number` (`customer_number`),
  ADD KEY `coupons_code` (`coupons_code`);

--
-- Indexes for table `customer_order_details`
--
ALTER TABLE `customer_order_details`
  ADD PRIMARY KEY (`customer_order_detail_id`),
  ADD KEY `customer_orders_id` (`customer_orders_id`),
  ADD KEY `order_number` (`order_number`),
  ADD KEY `products_id` (`products_id`);

--
-- Indexes for table `email_logs`
--
ALTER TABLE `email_logs`
  ADD PRIMARY KEY (`email_log_id`);

--
-- Indexes for table `email_settings`
--
ALTER TABLE `email_settings`
  ADD PRIMARY KEY (`email_settings_id`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`email_template_id`),
  ADD KEY `user_id` (`group_id`),
  ADD KEY `template_name` (`template_name`);

--
-- Indexes for table `email_template_type`
--
ALTER TABLE `email_template_type`
  ADD PRIMARY KEY (`email_template_type_id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`faq_id`);

--
-- Indexes for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
  ADD PRIMARY KEY (`footer_tab_id`);

--
-- Indexes for table `group_pages`
--
ALTER TABLE `group_pages`
  ADD PRIMARY KEY (`group_page_id`);

--
-- Indexes for table `headings_info`
--
ALTER TABLE `headings_info`
  ADD PRIMARY KEY (`heading_info_id`);

--
-- Indexes for table `logo_images`
--
ALTER TABLE `logo_images`
  ADD PRIMARY KEY (`logo_image_id`);

--
-- Indexes for table `menu_positions`
--
ALTER TABLE `menu_positions`
  ADD PRIMARY KEY (`menu_position_id`),
  ADD KEY `menu_status` (`menu_status`),
  ADD KEY `menu_type` (`menu_type`),
  ADD KEY `positioning` (`positioning`),
  ADD KEY `groups_id` (`groups_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`),
  ADD KEY `page_name` (`page_name`),
  ADD KEY `page_status` (`page_status`);

--
-- Indexes for table `payment_details`
--
ALTER TABLE `payment_details`
  ADD PRIMARY KEY (`payment_detail_id`),
  ADD KEY `payment_status` (`payment_status`),
  ADD KEY `payment_mode` (`payment_mode`),
  ADD KEY `customer_orders_id` (`customer_orders_id`),
  ADD KEY `customers_id` (`customers_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`plan_logs_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`product_id`),
  ADD KEY `product_name` (`product_name`),
  ADD KEY `product_price` (`mrp_price`),
  ADD KEY `brands_id` (`brands_id`),
  ADD KEY `sale_price` (`sale_price`),
  ADD KEY `is_featured` (`is_featured`),
  ADD KEY `product_status` (`product_status`),
  ADD KEY `product_slug` (`product_slug`);

--
-- Indexes for table `product_colors`
--
ALTER TABLE `product_colors`
  ADD PRIMARY KEY (`product_colors_id`);

--
-- Indexes for table `product_csv_files`
--
ALTER TABLE `product_csv_files`
  ADD PRIMARY KEY (`csv_file_id`);

--
-- Indexes for table `product_dimensions`
--
ALTER TABLE `product_dimensions`
  ADD PRIMARY KEY (`product_dimensions_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`product_image_id`);

--
-- Indexes for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
  ADD PRIMARY KEY (`product_sub_category_id`),
  ADD KEY `products_id` (`products_id`),
  ADD KEY `subcategory_id` (`sub_categories_id`);

--
-- Indexes for table `refund_payments`
--
ALTER TABLE `refund_payments`
  ADD PRIMARY KEY (`refund_payment_id`);

--
-- Indexes for table `related_products`
--
ALTER TABLE `related_products`
  ADD PRIMARY KEY (`related_product_id`);

--
-- Indexes for table `return_cancel_orders`
--
ALTER TABLE `return_cancel_orders`
  ADD PRIMARY KEY (`return_cancel_order_id`);

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

--
-- Indexes for table `save_cards`
--
ALTER TABLE `save_cards`
  ADD PRIMARY KEY (`save_card_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`settings_id`),
  ADD KEY `users_id` (`group_id`),
  ADD KEY `facebook_id` (`facebook_id`),
  ADD KEY `site_name` (`site_name`),
  ADD KEY `email` (`email`);

--
-- Indexes for table `status`
--
ALTER TABLE `status`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `status_logs`
--
ALTER TABLE `status_logs`
  ADD PRIMARY KEY (`status_log_id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`subscriber_id`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`sub_category_id`),
  ADD KEY `categories_id` (`categories_id`);

--
-- Indexes for table `sub_menu`
--
ALTER TABLE `sub_menu`
  ADD PRIMARY KEY (`sub_menu_id`);

--
-- Indexes for table `templates`
--
ALTER TABLE `templates`
  ADD PRIMARY KEY (`template_id`);

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

--
-- Indexes for table `user_credentials`
--
ALTER TABLE `user_credentials`
  ADD PRIMARY KEY (`user_credential_id`),
  ADD UNIQUE KEY `users_id` (`group_id`) USING BTREE;

--
-- Indexes for table `versions`
--
ALTER TABLE `versions`
  ADD PRIMARY KEY (`version_id`),
  ADD KEY `version_no` (`version_no`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `add_register_user_payment`
--
ALTER TABLE `add_register_user_payment`
  MODIFY `register_payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `banner_images`
--
ALTER TABLE `banner_images`
  MODIFY `banner_image_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `banner_text`
--
ALTER TABLE `banner_text`
  MODIFY `banner_text` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `brand_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `cart_added`
--
ALTER TABLE `cart_added`
  MODIFY `cart_added_id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `color_settings`
--
ALTER TABLE `color_settings`
  MODIFY `color_settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact_info`
--
ALTER TABLE `contact_info`
  MODIFY `contact_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `country_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=227;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
  MODIFY `coupon_applied_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `cron_cards`
--
ALTER TABLE `cron_cards`
  MODIFY `cron_card_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_payments`
--
ALTER TABLE `cron_payments`
  MODIFY `cron_payment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_payment_logs`
--
ALTER TABLE `cron_payment_logs`
  MODIFY `cron_payment_log_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_stop`
--
ALTER TABLE `cron_stop`
  MODIFY `cron_stop_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `customer_orders`
--
ALTER TABLE `customer_orders`
  MODIFY `customer_order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `customer_order_details`
--
ALTER TABLE `customer_order_details`
  MODIFY `customer_order_detail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `email_logs`
--
ALTER TABLE `email_logs`
  MODIFY `email_log_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_settings`
--
ALTER TABLE `email_settings`
  MODIFY `email_settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `email_template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `email_template_type`
--
ALTER TABLE `email_template_type`
  MODIFY `email_template_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
  MODIFY `footer_tab_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `headings_info`
--
ALTER TABLE `headings_info`
  MODIFY `heading_info_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `logo_images`
--
ALTER TABLE `logo_images`
  MODIFY `logo_image_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `plan_logs_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `product_colors`
--
ALTER TABLE `product_colors`
  MODIFY `product_colors_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `product_csv_files`
--
ALTER TABLE `product_csv_files`
  MODIFY `csv_file_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_dimensions`
--
ALTER TABLE `product_dimensions`
  MODIFY `product_dimensions_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `product_image_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=221;

--
-- AUTO_INCREMENT for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
  MODIFY `product_sub_category_id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `refund_payments`
--
ALTER TABLE `refund_payments`
  MODIFY `refund_payment_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `save_cards`
--
ALTER TABLE `save_cards`
  MODIFY `save_card_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `status_logs`
--
ALTER TABLE `status_logs`
  MODIFY `status_log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_credentials`
--
ALTER TABLE `user_credentials`
  MODIFY `user_credential_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `versions`
--
ALTER TABLE `versions`
  MODIFY `version_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
COMMIT;

