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

START TRANSACTION;

--
-- Database: `furniture`
--

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

--
-- 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;

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

--
-- 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;

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

--
-- 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, 'Greenwich Sofa', 'FNSF51AGCM1_-_main_1.jpg', '88c827dbc0cf230baa93494183059b55.jpg', 0, '2018-04-20 15:58:47', '2018-04-20 15:55:51'),
(65, 'Universal Furniture', 'UNI-Zepher-Sitebanner.jpg', '40495f9ce8b78c08cbc133e6eac52ee2.jpg', 1, '2018-04-20 15:42:56', 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),
(29, 'Sofa', 'Sofa', 'Apollo_Modern_Convertible_Futon_Sofabed_Sleeper_Bark_lrg_1.jpg', 'ed15bce4ed61fbd85e2c029ad3a1be45.jpg', 1, '2018-04-20 15:02:11', '2018-04-20 16:02:14'),
(32, 'Storage', 'Storage', '25-Pair+Shoe+Storage+Cabinet.jpg', '400e062e11e60b89c8940a949e8eb715.jpg', 1, '2018-04-20 12:16:13', '2018-04-20 16:03:27'),
(35, 'Study', 'study', 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_01.jpg', '5c3be349490004f82b7325df8a02b3a5.jpg', 1, '2018-04-20 16:24:40', NULL);

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

--
-- 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;

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

--
-- 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:46');

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

--
-- 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', 0, NULL, NULL, NULL, '2018-04-10 17:43:00', '2018-04-11 15:16:23');

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

--
-- 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;

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

--
-- 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;



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

--
-- 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;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`faq_id`, `products_id`, `faq_question`, `faq_answer`, `faq_status`, `faq_created`, `faq_modified`) VALUES
(1, 61, 'What about Durability of product?', 'Philips is a brand, who always gives best in Home Appliances and serving the community. As always this o=product is also come with it\'s best.', 1, '2018-04-20 12:11:00', '2018-04-20 13:22:13');

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

--
-- 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
(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-26 11:26: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-26 11:26:26');

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

--
-- 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;

--
-- Dumping data for table `logo_images`
--

INSERT INTO `logo_images` (`logo_image_id`, `group_id`, `logo_type`, `logo_status`, `logo_image_original`, `logo_mask_name`, `logo_image_created`, `logo_modified`, `favicon_image_original`, `favicon_mask_name`, `favicon_type`, `favicon_status`, `favicon_created`, `favicon_modified`) VALUES
(1, 1, 1, 0, 'Apps-Home-icon.png', '515531ee3c3ccaa210629813d658f088.png', NULL, '2018-04-23 14:41:23', NULL, NULL, 1, 0, '2018-04-23 14:41:23', NULL);

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

--
-- 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 11:48:17'),
(3, 1, 3, 'set_2', 2, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'),
(5, 1, 2, 'set_4', 4, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:17'),
(6, 1, 5, 'set_5', 5, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'),
(7, 1, 4, 'set_6', 6, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18');

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

--
-- 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-16 17:02:05'),
(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>', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 16:35:48', '2018-04-23 14:33:03'),
(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
(61, 'Austen Compact - Aurelio Study Sets', '<p><strong>Technical Details</strong></p>\r\n\r\n<ul>\r\n	<li>Love your desk job! The Austen Compact Desk Desk&nbsp;and Aurelio Study Chair&nbsp;make the perfect pair for your study or home office</li>\r\n	<li>The Austen Compact Desk and Aurelio Study Chair&nbsp;are also both available individually</li>\r\n	<li>Please refer to the images for details of dimensions</li>\r\n	<li>The product will be assembled and installed by the UL team</li>\r\n	<li>For indoor use only</li>\r\n</ul>', '239.00', '0.00', '0.00', 0, 0, 15, '', 1, '', 61, 35, 1, 'godrej-255-l-direct-cool-single-door-4-star-refrigerator-erica-blue-rd-edge-duo-255-pd-inv42', NULL, ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', 1, '2018-04-20 11:53:42', '2018-04-23 14:34:15'),
(62, 'Finn Double Futon Sofa Cum Bed', '<ul>\r\n	<li>So perfect for the lazy, Huck Finn would approve. Unfussy and amenable, the Finn double futon is an excuse to cancel plans and sleep in. Got company? Lock it in place as a sofa with one easy push. Broad slats keep your fingers from getting caught and prevent sagging. Vibrant colours and prints give it a jaunty feel that sits well in any room.</li>\r\n	<li>Frame made from MDF</li>\r\n	<li>Foam mattress with removable and washable zip cover</li>\r\n	<li>Wheels attached for easy movement, plastic bush attached to protect the floor and the finish from scratches</li>\r\n	<li>Rounded edges for safety</li>\r\n	<li>Please refer to images for dimension details</li>\r\n	<li>Any assembly or installation required will be done by the UL team at the time of delivery</li>\r\n	<li>Indoor use only</li>\r\n</ul>', '490.00', '0.00', '50.00', 0, 0, 15, '', 1, '', 61, 29, 1, 'samsung-394-l-3-star-frost-free-double-door-refrigerator-rt39m5538s8tl-elegant-inox-5-in-1-convertibleinverter-compressor', NULL, 'MacBook', 'MacBook', 'MacBook', 'MacBook', 1, '2018-04-20 12:27:06', '2018-04-20 16:22:49'),
(63, 'Redmi 4 (Black, 32 GB)', '<ul>\r\n	<li>13MP primary camera with 5-elements lens, f/2.2 aperture, PDAF, high dynamic range (HDR), panaroma, 1080p full HD video recording and 5MP front facing camera</li>\r\n	<li>12.7 centimeters (5-inch) display with 1280 x 720 pixels resolution and 293 ppi pixel density</li>\r\n	<li>Android v6.0.1 Marshmallow operating system with up to 1.4GHz Qualcomm Snapdragon 435 octa core processor with Adreno 505 GPU, 3GB RAM, 32GB internal memory expandable up to 128GB and dual SIM (micro+nano) dual-standby (4G+4G), Hybrid SIM slot</li>\r\n	<li>4100mAH lithium-ion battery providing talk-time of 36 hours and standby time of 432 hours</li>\r\n	<li>1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase</li>\r\n</ul>', '949.00', '840.00', '5.00', 0, 0, 15, '', 1, '', 64, 34, 1, 'redmi-4-black-32-gb', NULL, NULL, NULL, NULL, NULL, 1, '2018-04-20 12:32:25', '2018-04-20 13:04:08'),
(64, 'Murano Single-Door Display Cabinet (55-book capacity)', '<ul>\r\n	<li>With clean classic lines, this elegant glass-front display cabinet will suit any room it stands in. Living rooms, hallways, and dining rooms the multi-purpose Murano will be at home anywhere.</li>\r\n	<li>A great option for additional storage, use it to display travel souvenirs, curios, and photographs; china; or books. With three tall and sturdy wooden shelves, there&rsquo;s room for everything you want to put on show.</li>\r\n	<li>Made of high quality Sheesham wood. Glass panel cabinet door. MDF back panel.</li>\r\n	<li>Refer to images for dimensions</li>\r\n	<li>The UL Team will assemble the product at the time of delivery</li>\r\n	<li>Indoor use only</li>\r\n</ul>', '1900.00', '1800.00', '10.00', 0, 0, 15, '', 1, '', 65, 32, 1, 'hp-lp3065', NULL, ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', 1, '2018-04-20 13:24:37', '2018-04-20 16:13:13'),
(65, 'Domenico Wardrobe', '<ul>\r\n	<li>Thoughtful! One word that summarizes our wardrobes. Designed with complete understanding of your bedroom requirements, our wardrobes will surely offer the most comprehensive storage solution for your bedroom, all the while looking absolutely great!&nbsp;</li>\r\n	<li>Textured finish - self design on the wardrobe to give it a premium look and feel</li>\r\n	<li>Made from high quality particle board of 18 mm thickness.</li>\r\n	<li>Soft closing hinges have been added to ensure smooth daily usage and long life</li>\r\n	<li>Refer to the images for dimension details</li>\r\n	<li>Any assembly or installation required will be done by the UL team at the time of delivery</li>\r\n	<li>Indoor use only</li>\r\n</ul>', '1500.00', '1000.00', '50.00', 0, 0, 45, '', 1, '', 65, 32, 1, 'apple-ipad-tablet-97-inch-32gb-wi-fi-space-grey', NULL, ' Domenico Wardrobe ', ' Domenico Wardrobe ', '', ' Domenico Wardrobe ', 1, '2018-04-20 14:32:40', '2018-04-20 16:08:32'),
(66, 'Charles Study Chair - 2 Axis Adjustable', '<ul>\r\n	<li>Curves ahead! The Charles study chair is designed to mirror your spine, and the slight S shape supports your back comfortably, so you can work easy, all day (or night) long. Use it at your desk at work, at home, or use it in multiples in the conference room.</li>\r\n	<li>The cushioned seat and back are comfortable and low maintenance</li>\r\n	<li>Adjustable height,&nbsp;seat tilt and and free rolling castors make it practical as well as stylish</li>\r\n	<li>Please refer to the images for details of dimensions</li>\r\n	<li>The product will be assembled and installed by the UL team</li>\r\n	<li>For indoor use only</li>\r\n</ul>', '400.00', '0.00', '20.00', 0, 1, 15, '0', 1, '0', 61, 35, 1, 'charles-study-chair-2-axis-adjustable', 'https://www.youtube.com/watch?v=IO2M3cBj8-s', ' Charles Study Chair - 2 Axis Adjustable ', ' Charles Study Chair - 2 Axis Adjustable ', NULL, ' Charles Study Chair - 2 Axis Adjustable ', 1, '2018-04-20 16:45:13', '2018-04-20 17:04:26');

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

--
-- 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
(12, 64, 'Brown', '2018-04-20 16:14:40', NULL),
(13, 61, 'brown', '2018-04-20 16:37:53', 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,2) 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, 61, '0.00', '0.00', '0.00', '2018-04-20 12:02:18', '2018-04-20 16:37:53'),
(2, 62, '759.50', '939.80', '0.00', '2018-04-20 12:29:54', '2018-04-20 16:21:42'),
(3, 64, '0.00', '0.00', '0.00', '2018-04-20 13:31:21', '2018-04-20 16:14:41'),
(4, 65, '0.00', '0.00', '0.00', '2018-04-20 14:35:50', '2018-04-20 14:46:03');

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

--
-- 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
(201, 59, '260c8d0454b4b03ca573ee4730c7fd1b.jpg', '072a068cf8d3c99e5f7954ad5296da31.jpg', '2018-04-13 13:44:57'),
(202, 58, 'f4ac2515ed82a343e7a45b6ebf986c3d.jpg', '1d9be41ad2ec862ea394d6cede7bfadb.jpg', '2018-04-13 13:45:13'),
(203, 57, 'eeea355f874be87000beae8e2db2def6.jpg', 'bb9f2f2318d1a762418727a8920b2653.jpg', '2018-04-13 13:45:30'),
(204, 60, 'c353498c74d7673ba202b9cb2334b1cb.jpg', 'f41b5f789314d10212b86f9d27d94e10.jpg', '2018-04-13 13:50:18'),
(225, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '5ad93adafdeb6ea72372d5bdbd3c3e6d.jpeg', '2018-04-20 13:00:14'),
(226, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '7a1a73874c84c9cee3ae466f24696507.jpeg', '2018-04-20 13:00:41'),
(227, 63, '201609280114371436xrnv.JPG', '3ed962da9f337453c81218490454fc82.JPG', '2018-04-20 13:00:56'),
(228, 63, '1F3455FF-B5FC-4553-7C1C-94C8E8325D0A.jpg', 'dcacce655ab825b4ba89646f70144011.jpg', '2018-04-20 13:01:41'),
(237, 65, 'Domenico_3_Door_Wardrobe_DO_10_10.jpg', '13478920fe1d3585cfff8de9bf0971ef.jpg', '2018-04-20 16:09:35'),
(238, 65, 'Domenico_3_Door_Wardrobe_DO_810.jpg', '134f7f24e383e70ebf581f83ade2573e.jpg', '2018-04-20 16:10:04'),
(239, 65, 'Domenico_3_Door_Wardrobe_DO_06_7.jpg', 'a3dfbe0fec13e81656bcba7800acfc21.jpg', '2018-04-20 16:10:39'),
(240, 65, 'Domenico_3_Door_Wardrobe_DO_03_4.jpg', '344b2c1440e5404801c1f4e8aadd5d5b.jpg', '2018-04-20 16:10:39'),
(241, 64, 'Murano_Single_Door_Display_Cabinet_MH_Dimensrion.jpg', '3b684f15e12844f141a75f8f8f48d425.jpg', '2018-04-20 16:13:38'),
(242, 64, 'Murano_Single_Door_Display_Cabinet_Mahogany_5.jpg', '70aef5e4249f62be0f68f479622a6a34.jpg', '2018-04-20 16:15:28'),
(243, 62, 'Finn_Double_Futon_Mattress_Castle_8.jpg', 'e2f91140776f08dbe2d820bd46cb0f25.jpg', '2018-04-20 16:18:36'),
(244, 62, 'Finn_Double_Futon_Mattress_Castle_7.jpg', 'bd738cbfc221856900277d52e18ba299.jpg', '2018-04-20 16:19:09'),
(245, 62, 'Finn_Double_Futon_Mattress_Castle_1.jpg', '48b1f23056fa27309b93e6edb60718a7.jpg', '2018-04-20 16:20:24'),
(246, 62, 'Finn_Double_Futon_Mattress_Castle_9.jpg', 'a49ee64bf72446e40c4e3d4e52b19e0e.jpg', '2018-04-20 16:20:43'),
(247, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_01.jpg', '808325eecee23dc29050dc85f1586fd6.jpg', '2018-04-20 16:35:22'),
(248, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_05.jpg', '8be052e18429f8250c84543af4e9a995.jpg', '2018-04-20 16:35:40'),
(249, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_03.jpg', '34d1a8af6b8c38d9b19854e8a2572336.jpg', '2018-04-20 16:36:31'),
(250, 66, 'charles_010_55.jpg', 'eb37b01558bd85984646ef0f5121be15.jpg', '2018-04-20 16:51:12'),
(251, 66, 'charles_09_55.jpg', '6cb068d0a580d8f29160afaf8fd282dd.jpg', '2018-04-20 16:51:30'),
(252, 66, 'charles_02_55.jpg', '69e9fc51611b4ec2e06810613024ada2.jpg', '2018-04-20 16:51:49');

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

--
-- 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
(84, 63, 36, NULL),
(95, 65, 47, NULL),
(96, 64, 43, NULL),
(97, 62, 41, NULL),
(98, 61, 48, NULL),
(100, 66, 49, '2018-04-20 16:47:11');

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

--
-- 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
(1, 59, 58, '2018-03-14 12:52:08'),
(2, 59, 57, '2018-03-14 12:52:09'),
(3, 62, 61, '2018-04-20 12:30:03'),
(5, 65, 62, '2018-04-20 14:38:06'),
(6, 65, 64, '2018-04-20 14:45:36'),
(7, 64, 65, '2018-04-20 16:12:52'),
(8, 62, 64, '2018-04-20 16:21:55'),
(9, 66, 61, '2018-04-20 16:52:45'),
(10, 66, 62, '2018-04-20 16:52:46');

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

--
-- 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;

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

--
-- 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;

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

--
-- 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, 'Lets Shop', 'Lets Shop', 'Lets Shop', '', '  ', '', 'Https://Facebook.Com', 'Https://Facebook.Com', 'Https://Facebook.Com', 'Https://Facebook.Com', 'bhavneesh_goyal@ajdevtech.com', '8968029004', '2018-04-23 14:42:49', NULL);

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

--
-- 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;

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

--
-- 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),
(36, 34, 'Smartphones', 'smartphones', 1, '2018-04-20 12:24:15', NULL),
(41, 29, 'Futon', 'futon_', 1, '2018-04-20 12:58:33', '2018-04-20 16:04:43'),
(42, 29, 'Leather Sofa Set', 'leather-sofa-set_', 1, '2018-04-20 12:58:33', '2018-04-20 16:05:00'),
(43, 32, 'Bookshelves', 'bookshelves_', 1, '2018-04-20 12:58:50', '2018-04-20 16:12:01'),
(46, 29, 'Modular Sofa Sets', 'modular-sofa-sets', 1, '2018-04-20 16:05:33', NULL),
(47, 32, 'Wardrobes', 'wardrobes', 1, '2018-04-20 16:06:34', NULL),
(48, 35, 'Study Table', 'study-table', 1, '2018-04-20 16:31:59', NULL),
(49, 35, 'Study Chair', 'study-chair', 1, '2018-04-20 16:31:59', NULL);

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

--
-- 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, 29, 1, '2018-04-23 14:36:22', NULL),
(2, 32, 1, '2018-04-23 14:36:22', NULL),
(3, 35, 1, '2018-04-23 14:36:22', 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, 4, '2018-03-23 17:47:13', '2018-04-20 15:31:22');

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

--
-- 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;

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

--
-- 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 `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 `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 for table `add_register_user_payment`
--
ALTER TABLE `add_register_user_payment`
  MODIFY `register_payment_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

--
-- 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 for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
  MODIFY `coupon_applied_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 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 for table `customer_orders`
--
ALTER TABLE `customer_orders`
  MODIFY `customer_order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 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 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 `faqs`
--
ALTER TABLE `faqs`
  MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- 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=2;

--
-- 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 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=67;

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

--
-- 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=5;

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

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

--
-- 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=11;

--
-- 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=2;

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

--
-- 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=4;

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

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

--
-- 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 `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;

