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

START TRANSACTION;

--
-- Database: `jewellery`
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `email_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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `pages` (`page_id`, `group_pages_id`, `page_type`, `page_name`, `page_slug`, `page_body`, `page_metakeyword`, `page_metadescription`, `page_status`, `page_created`, `page_modified`) VALUES
(1, 1, 0, 'How It Works', 'how_it_works', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'How it Works', 'How it Works', 1, '2017-10-13 00:00:00', '2018-04-20 16:29:02'),
(2, 1, 1, 'Terms & Conditions', 'terms_conditions', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:12'),
(3, 1, 1, 'Privacy Policy', 'privacy_policy', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'Privacy Policy', 'Privacy Policy', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:28'),
(4, 2, 2, 'About us', 'about_us', '<p>accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'About us', 'About us', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:21'),
(5, 1, 1, 'Terms of Sale ', 'terms_of_sale', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>nm,</p>', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:16'),
(6, 1, 1, 'Terms of Use', 'terms_of_use', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'Terms of Use', 'Terms of Use', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:19'),
(7, 2, 2, 'Core Values', 'core_values', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'Core Values', 'Core Values', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:23'),
(8, 2, 3, 'Careers', 'careers', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', 'Careers', 'Careers', 1, '2017-10-13 16:35:48', '2018-04-17 18:49:19'),
(9, 1, 1, 'Report Abuse', 'report_abuse', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Report Abuse', 'Report Abuse', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:40'),
(10, 2, 2, 'Engineering', 'engineering', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>', 'Engineering', 'Engineering', 1, '2017-10-24 00:00:00', '2018-04-16 16:59:32'),
(11, 3, 3, 'Online Shopping', 'online_shopping', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Online Shopping', 'Online Shopping', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:14'),
(12, 3, 3, 'Sell on Online', 'sell_on_online', '<p>&#39;Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\&quot;de Finibus Bonorum et Malorum\\&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\&quot;Lorem ipsum dolor sit amet..\\&quot;, comes from a line in section 1.10.32. The standard chunk of Lorem</p>', 'Sell on Online', 'Sell on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(13, 3, 3, 'Advertise on Online', 'advertise_on_online', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Advertise on Online', 'Advertise on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(14, 3, 3, 'Media Enquiries', 'media_enquiries', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Media Enquiries', 'Media Enquiries', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11'),
(15, 3, 3, 'Be an Affiliate ', 'be_an_affiliate ', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Be an Affiliate ', 'Be an Affiliate ', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `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_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 `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 `versions`
--
ALTER TABLE `versions`
  ADD PRIMARY KEY (`version_id`),
  ADD KEY `version_no` (`version_no`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `email_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 for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
  MODIFY `footer_tab_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

