-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 26, 2018 at 11:11 AM
-- Server version: 5.7.22-0ubuntu0.16.04.1
-- PHP Version: 7.0.28-0ubuntu0.16.04.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
--
-- Database: `letsshop`
--
-- --------------------------------------------------------
--
-- Table structure for table `address_book`
--
CREATE TABLE `address_book` (
`address_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`address_address1` varchar(255) NOT NULL,
`address_address2` varchar(255) DEFAULT NULL,
`address_city` varchar(255) NOT NULL,
`address_state` varchar(255) NOT NULL,
`address_postal_code` varchar(10) NOT NULL,
`address_country` tinyint(1) NOT NULL,
`is_default` tinyint(1) DEFAULT '0' COMMENT 'for default address',
`address_created_on` datetime NOT NULL,
`address_modified_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `add_register_user_payment`
--
CREATE TABLE `add_register_user_payment` (
`register_payment_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`payment_detail` text NOT NULL,
`auth_pay_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`auth_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`auth_shipping_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`created` datetime NOT NULL,
`stripe_customer_token` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`stripe_customer_profile_id` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`card_number` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`card_expiry` varchar(256) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `banner_images`
--
CREATE TABLE `banner_images` (
`banner_image_id` int(10) NOT NULL,
`group_id` int(11) NOT NULL,
`banner_type` tinyint(1) NOT NULL DEFAULT '1',
`banner_status` tinyint(1) NOT NULL COMMENT '1 for user defined 0 for default',
`banner_image_original` varchar(255) DEFAULT NULL,
`banner_mask_name` varchar(255) DEFAULT NULL,
`image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `banner_text`
--
CREATE TABLE `banner_text` (
`banner_text` int(11) NOT NULL,
`groups_id` tinyint(1) NOT NULL,
`main` varchar(255) NOT NULL,
`sub` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL,
`banner_text_created` datetime NOT NULL,
`banner_text_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `brands`
--
CREATE TABLE `brands` (
`brand_id` int(20) NOT NULL,
`brand_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_status` tinyint(1) NOT NULL COMMENT '0 for deactivate , 1 for activate',
`brand_created` datetime NOT NULL,
`brand_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `brands`
--
INSERT INTO `brands` (`brand_id`, `brand_name`, `brand_original_image`, `brand_mask_name`, `brand_status`, `brand_created`, `brand_modified`) VALUES
(61, 'General', '8c4d3a946a1fcde2ded7e17651fd0ed7.jpg', '7e81fba4cdc705aa6787f0a1e506f5fe.jpg', 1, '2017-10-25 12:38:33', '2018-04-25 12:04:40'),
(62, 'Apple', 'og.png', '5bc3c1d52024c150581c7651627304b7.png', 1, '2018-04-20 11:54:56', '2018-04-20 12:41:10'),
(63, 'Samsung', 'TB3J4HUUMS.png', 'aa34a51b37055cf15f0e23cb6b25f26c.png', 1, '2018-04-20 12:28:15', NULL),
(64, 'xiaomi', 'YJBL7482Z8.png', '22e95f50e6978154acd3668c8f97953f.png', 1, '2018-04-20 12:33:04', '2018-04-20 12:42:19');
-- --------------------------------------------------------
--
-- Table structure for table `cart_added`
--
CREATE TABLE `cart_added` (
`cart_added_id` bigint(11) NOT NULL,
`products_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`cart_added_product_quantity` int(10) NOT NULL,
`cart_added_created` datetime NOT NULL,
`cart_added_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`category_id` int(11) NOT NULL,
`category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_status` tinyint(1) NOT NULL,
`category_created` datetime NOT NULL,
`category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`category_id`, `category_name`, `category_slug`, `category_original_image`, `category_mask_name`, `category_status`, `category_created`, `category_modified`) VALUES
(24, 'General', 'general', 'images.png', '59b514174bffe4ae402b3d63aad79fe0.jpg', 1, '2017-10-25 13:26:00', NULL),
(29, 'Laptops', 'Laptop', 'MacBookAir-1140x380.jpg', 'fe4177a6efcc603ed8cdf8bff8fa5b01.jpg', 1, '2018-04-20 15:02:11', '2018-04-20 15:02:21'),
(32, 'Electronic Pad', 'Electronic-Pad', '810QbXRsL3L._SL1500_.jpg', 'fb0354241878a3d1071bf55b003b3b45._SL1500_', 1, '2018-04-20 12:16:13', '2018-04-20 12:55:45'),
(34, 'Mobiles', 'mobiles', 'phone.jpeg', 'f7a42fe7211f98ac7a60a285ac3a9e87.jpeg', 1, '2018-04-20 12:20:55', '2018-04-20 14:40:11');
-- --------------------------------------------------------
--
-- Table structure for table `color_settings`
--
CREATE TABLE `color_settings` (
`color_settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`color_code` varchar(255) NOT NULL,
`color_settings_created` datetime NOT NULL,
`color_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `contact_info`
--
CREATE TABLE `contact_info` (
`contact_info_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`address` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`state` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`postal_code` varchar(10) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`contact_info_created` datetime NOT NULL,
`contact_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `contact_info`
--
INSERT INTO `contact_info` (`contact_info_id`, `group_id`, `address`, `city`, `state`, `country`, `postal_code`, `email`, `phone`, `contact_info_created`, `contact_info_modified`) VALUES
(1, 1, '3719 Jadewood Farms', 'Passaic', 'New Jersey', 'U.S.A', '07055', 'email@email.com', '97336526', '2018-04-16 17:52:08', '2018-04-20 14:25:46');
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`country_id` int(10) NOT NULL,
`title` varchar(100) NOT NULL,
`iso_code` varchar(20) NOT NULL,
`country_code` varchar(20) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '"0"=>disable, "1"=>enable'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`country_id`, `title`, `iso_code`, `country_code`, `status`) VALUES
(1, 'United States', 'US', '+1', 1),
(2, 'Australia', 'AU', '+61', 1),
(3, 'Austria', 'AT', '+43 720', 1),
(4, 'Belgium', 'BE', '+32', 1),
(5, 'Canada', 'CA', '+1', 1),
(6, 'Czech Republic', 'CZ', '+420', 1),
(7, 'Denmark', 'DK', '+45', 1),
(8, 'Finland', 'FI', '+358', 1),
(9, 'France', 'FR', '+33 9', 1),
(10, 'Greece', 'GR', '+30', 1),
(11, 'Hong Kong', 'HK', '+852', 1),
(12, 'Ireland', 'IE', '+353 76', 1),
(13, 'Israel', 'IL', '+972', 1),
(14, 'Italy', 'IT', '+39', 1),
(15, 'Japan', 'JP', '+81', 1),
(16, 'Netherlands', 'NL', '+31 85', 1),
(17, 'New Zealand', 'NZ', '+64', 1),
(18, 'Poland', 'PL', '+48', 1),
(19, 'Portugal', 'PT', '+351', 1),
(20, 'Romania', 'RO', '+40', 1),
(21, 'Spain', 'ES', '+34', 1),
(22, 'Sweden', 'SE', '+46', 1),
(23, 'Switzerland', 'CH', '+41', 1),
(24, 'United Kingdom', 'GB', '+44', 1),
(25, 'India', 'IN', '+91', 1),
(26, 'Algeria', 'DZ', '+213', 1),
(27, 'Angola', 'AO', '+244', 1),
(28, 'Benin', 'BJ', '+229', 1),
(29, 'Botswana', 'BW', '+267', 1),
(30, 'Burkina Faso', 'BF', '+226', 1),
(31, 'Burundi', 'BI', '+257', 1),
(32, 'Cameroon', 'CM', '+237', 1),
(33, 'Cape Verde', 'CV', '+238', 1),
(34, 'Central African Republic', 'CF', '+236', 1),
(35, 'Chad', 'TD', '+235', 1),
(36, 'Comoros', 'KM', '+269', 1),
(37, 'Congo', 'CG', '+242', 1),
(38, 'Congo, The Democratic Republic of the', 'CD', '+243', 1),
(39, 'Cote D\'Ivoire', 'CI', '+225', 1),
(40, 'Djibouti', 'DJ', '+253', 1),
(41, 'Egypt', 'EG', '+20', 1),
(42, 'Equatorial Guinea', 'GQ', '+240', 1),
(43, 'Eritrea', 'ER', '+291', 1),
(44, 'Ethiopia', 'ET', '+251', 1),
(45, 'Gabon', 'GA', '+241', 1),
(46, 'Gambia', 'GM', '+220', 1),
(47, 'Ghana', 'GH', '+233', 1),
(48, 'Guinea', 'GN', '+224', 1),
(49, 'Guinea-Bissau', 'GW', '+245', 1),
(50, 'Kenya', 'KE', '+254', 1),
(51, 'Lesotho', 'LS', '+266', 1),
(52, 'Liberia', 'LR', '+231', 1),
(53, 'Libya', 'LY', '+218', 1),
(54, 'Madagascar', 'MG', '+261', 1),
(55, 'Malawi', 'MW', '+265', 1),
(56, 'Mali', 'ML', '+223', 1),
(57, 'Mauritania', 'MR', '+222', 1),
(58, 'Mauritius', 'MU', '+230', 1),
(59, 'Mayotte', 'YT', '+269', 1),
(60, 'Morocco', 'MA', '+212', 1),
(61, 'Mozambique', 'MZ', '+258', 1),
(62, 'Namibia', 'NA', '+264', 1),
(63, 'Niger', 'NE', '+227', 1),
(64, 'Nigeria', 'NG', '+234', 1),
(65, 'Rwanda', 'RW', '+250', 1),
(66, 'Saint Helena', 'SH', '+290', 1),
(67, 'Sao Tome and Principe', 'ST', '+239', 1),
(68, 'Senegal', 'SN', '+221', 1),
(69, 'Seychelles', 'SC', '+248', 1),
(70, 'Sierra Leone', 'SL', '+232', 1),
(71, 'Somalia', 'SO', '+252', 1),
(72, 'South Africa', 'ZA', '+27', 1),
(73, 'Sudan', 'SD', '+249', 1),
(74, 'Swaziland', 'SZ', '+268', 1),
(75, 'Tanzania, United Republic of', 'TZ', '+255', 1),
(76, 'Togo', 'TG', '+228', 1),
(77, 'Tunisia', 'TN', '+216', 1),
(78, 'Uganda', 'UG', '+256', 1),
(79, 'Zambia', 'ZM', '+260', 1),
(80, 'Zimbabwe', 'ZW', '+263', 1),
(81, 'Antarctica', 'AQ', '+672', 1),
(82, 'Afghanistan', 'AF', '+93', 1),
(83, 'Bahrain', 'BH', '+973', 1),
(84, 'Bangladesh', 'BD', '+880', 1),
(85, 'Bhutan', 'BT', '+975', 1),
(86, 'Brunei Darussalam', 'BN', '+673', 1),
(87, 'Cambodia', 'KH', '+855', 1),
(88, 'China', 'CN', '+86', 1),
(89, 'India', 'IN', '+91', 1),
(90, 'Indonesia', 'ID', '+62', 1),
(91, 'Iran, Islamic Republic of', 'IR', '+98', 1),
(92, 'Iraq', 'IQ', '+964', 1),
(93, 'Jordan', 'JO', '+962', 1),
(94, 'Kazakhstan', 'KZ', '+7', 1),
(95, 'Korea, Democratic People\'s Republic of', 'KP', '+850', 1),
(96, 'Korea, Republic of', 'KR', '+82', 1),
(97, 'Kuwait', 'KW', '+965', 1),
(98, 'Kyrgyzstan', 'KG', '+996', 1),
(99, 'Lao People\'s Democratic Republic', 'LA', '+856', 1),
(100, 'Lebanon', 'LB', '+961', 1),
(101, 'Macau', 'MO', '+853', 1),
(102, 'Malaysia', 'MY', '+60', 1),
(103, 'Maldives', 'MV', '+960', 1),
(104, 'Mongolia', 'MN', '+976', 1),
(105, 'Myanmar', 'MM', '+95', 1),
(106, 'Nepal', 'NP', '+977', 1),
(107, 'Oman', 'OM', '+968', 1),
(108, 'Pakistan', 'PK', '+92', 1),
(109, 'Philippines', 'PH', '+63', 1),
(110, 'Qatar', 'QA', '974', 1),
(111, 'Russian Federation', 'RU', '+7', 1),
(112, 'Saudi Arabia', 'SA', '+966', 1),
(113, 'Singapore', 'SG', '+65', 1),
(114, 'Sri Lanka', 'LK', '94', 1),
(115, 'Syrian Arab Republic', 'SY', '+963', 1),
(116, 'Taiwan', 'TW', '+886', 1),
(117, 'Tajikistan', 'TJ', '+992', 1),
(118, 'Thailand', 'TH', '+66', 1),
(119, 'Turkey', 'TR', '+90', 1),
(120, 'Turkmenistan', 'TM', '+993', 1),
(121, 'United Arab Emirates', 'AE', '+971', 1),
(122, 'Uzbekistan', 'UZ', '+998', 1),
(123, 'Vietnam', 'VN', '+84', 1),
(124, 'Yemen', 'YE', '+967', 1),
(125, 'Cook Islands', 'CK', '+682', 1),
(126, 'Fiji', 'FJ', '+679', 1),
(127, 'Guam', 'GU', '+1 671', 1),
(128, 'Kiribati', 'KI', '+686', 1),
(129, 'Marshall Islands', 'MH', '+692', 1),
(130, 'Micronesia, Federated States of', 'FM', '+691', 1),
(131, 'Nauru', 'NR', '+674', 1),
(132, 'New Caledonia', 'NC', '+687', 1),
(133, 'Niue', 'NU', '+683', 1),
(134, 'Norfolk Island', 'NF', '+672', 1),
(135, 'Northern Mariana Islands', 'MP', '+670', 1),
(136, 'Palau', 'PW', '+680', 1),
(137, 'Papua New Guinea', 'PG', '+675', 1),
(138, 'Reunion', 'RE', '+262', 1),
(139, 'Samoa', 'WS', '+684', 1),
(140, 'Solomon Islands', 'SB', '+677', 1),
(141, 'Tokelau', 'TK', '+690', 1),
(142, 'Tonga', 'TO', '+676', 1),
(143, 'Tuvalu', 'TV', '+688', 1),
(144, 'Vanuatu', 'VU', '+678', 1),
(145, 'Wallis and Futuna', 'WF', '+681', 1),
(146, 'Albania', 'AL', '+355', 1),
(147, 'Andorra', 'AD', '+376', 1),
(148, 'Armenia', 'AM', '+374', 1),
(149, 'Azerbaijan', 'AZ', '+994', 1),
(150, 'Belarus', 'BY', '+375', 1),
(151, 'Bosnia and Herzegovina', 'BA', '+387', 1),
(152, 'Bulgaria', 'BG', '+359', 1),
(153, 'Croatia', 'HR', '+385', 1),
(154, 'Cyprus', 'CY', '+357', 1),
(155, 'Estonia', 'EE', '+372', 1),
(156, 'Faroe Islands', 'FO', '+298', 1),
(157, 'Georgia', 'GE', '+995', 1),
(158, 'Germany', 'DE', '+49', 1),
(159, 'Gibraltar', 'GI', '+350', 1),
(160, 'Hungary', 'HU', '+36', 1),
(161, 'Iceland', 'IS', '+354', 1),
(162, 'Latvia', 'LV', '+371', 1),
(163, 'Liechtenstein', 'LI', '+423', 1),
(164, 'Lithuania', 'LT', '+370', 1),
(165, 'Luxembourg', 'LU', '+352', 1),
(166, 'Macedonia', 'MK', '+389', 1),
(167, 'Malta', 'MT', '+356', 1),
(168, 'Moldova, Republic of', 'MD', '+373', 1),
(169, 'Monaco', 'MC', '+377', 1),
(170, 'Montenegro', 'ME', '+382', 1),
(171, 'Norway', 'NO', '+47', 1),
(172, 'San Marino', 'SM', '+378', 1),
(173, 'Serbia', 'RS', '+381', 1),
(174, 'Slovakia', 'SK', '+421', 1),
(175, 'Slovenia', 'SI', '+386', 1),
(176, 'Ukraine', 'UA', '+380', 1),
(177, 'Vatican City', 'VA', '+39', 1),
(178, 'Antigua and Barbuda', 'AG', '+1 268', 1),
(179, 'American Samoa', 'AS', '+684', 1),
(180, 'Anguilla', 'AI', '+1 264', 1),
(181, 'Aruba', 'AW', '+297', 1),
(182, 'Bahamas', 'BS', '+1 242', 1),
(183, 'Barbados', 'BB', '+1 246', 1),
(184, 'Belize', 'BZ', '+501', 1),
(185, 'Bermuda', 'BM', '+1 441', 1),
(186, 'Costa Rica', 'CR', '+506', 1),
(187, 'Cayman Islands', 'KY', '+1 345', 1),
(188, 'Cuba', 'CU', '+53', 1),
(189, 'Dominica', 'DM', '+1 767', 1),
(190, 'Dominican Republic', 'DO', '+809', 1),
(191, 'El Salvador', 'SV', '+503', 1),
(192, 'Greenland', 'GL', '+299', 1),
(193, 'Grenada', 'GD', '+1 473', 1),
(194, 'Guatemala', 'GT', '+502', 1),
(195, 'Guadeloupe', 'GP', '+590', 1),
(196, 'Haiti', 'HT', '+509', 1),
(197, 'Honduras', 'HN', '+504', 1),
(198, 'Jamaica', 'JM', '+1 876', 1),
(199, 'Martinique', 'MQ', '+596', 1),
(200, 'Mexico', 'MX', '+52', 1),
(201, 'Montserrat', 'MS', '+1 664', 1),
(202, 'Nicaragua', 'NI', '+505', 1),
(203, 'Panama', 'PA', '+507', 1),
(204, 'Puerto Rico', 'PR', '+1 787', 1),
(205, 'Saint Kitts and Nevis', 'KN', '+1 869', 1),
(206, 'Saint Lucia', 'LC', '+1 758', 1),
(207, 'Saint Pierre and Miquelon', 'PM', '508', 1),
(208, 'Saint Vincent and the Grenadines', 'VC', '+1 784', 1),
(209, 'Trinidad and Tobago', 'TT', '+1 868', 1),
(210, 'Turks and Caicos Islands', 'TC', '+1 649', 1),
(211, 'Virgin Islands, British', 'VG', '+1 284', 1),
(212, 'Virgin Islands, U.S.', 'VI', '+1 340', 1),
(213, 'Argentina', 'AR', '+54', 1),
(214, 'Bolivia', 'BO', '+591', 1),
(215, 'Brazil', 'BR', '+55', 1),
(216, 'Chile', 'CL', '+56', 1),
(217, 'Colombia', 'CO', '+57', 1),
(218, 'Ecuador', 'EC', '+593', 1),
(219, 'Falkland Islands (Malvinas)', 'FK', '+500', 1),
(220, 'French Guiana', 'GF', '+594', 1),
(221, 'Guyana', 'GY', '+592', 1),
(222, 'Paraguay', 'PY', '+595', 1),
(223, 'Peru', 'PE', '+51', 1),
(224, 'Suriname', 'SR', '+597', 1),
(225, 'Uruguay', 'UY', '+598', 1),
(226, 'Venezuela', 'VE', '+58', 1);
-- --------------------------------------------------------
--
-- Table structure for table `coupons`
--
CREATE TABLE `coupons` (
`coupon_id` int(11) NOT NULL,
`coupon_code` varchar(30) NOT NULL,
`no_of_times` tinyint(4) NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`discount_type` varchar(10) NOT NULL COMMENT '1 for flat;2 for percentage',
`amount` decimal(10,2) NOT NULL,
`coupon_status` tinyint(4) NOT NULL COMMENT '1 for active;0 for inactive',
`coupon_created` datetime NOT NULL,
`coupon_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `coupon_applied`
--
CREATE TABLE `coupon_applied` (
`coupon_applied_id` int(11) NOT NULL,
`coupons_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`to_be_paid` decimal(10,2) NOT NULL,
`coupon_applied_created` datetime NOT NULL,
`coupon_applied_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `cron_cards`
--
CREATE TABLE `cron_cards` (
`cron_card_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`mode` tinyint(1) NOT NULL,
`order_num` text NOT NULL,
`card_num` varchar(256) DEFAULT NULL,
`card_month` int(11) DEFAULT NULL,
`card_year` int(11) DEFAULT NULL,
`card_address` varchar(256) DEFAULT NULL,
`card_city` varchar(256) DEFAULT NULL,
`card_state` varchar(256) DEFAULT NULL,
`card_pincode` varchar(256) DEFAULT NULL,
`card_country` tinyint(10) DEFAULT NULL,
`card_response` text NOT NULL,
`card_status` tinyint(1) NOT NULL,
`card_auth_profile_id` varchar(256) DEFAULT NULL,
`card_auth_pay_profile_id` varchar(256) DEFAULT NULL,
`card_auth_shipping_id` varchar(256) DEFAULT NULL,
`card_stripe_customer_token` varchar(256) DEFAULT NULL,
`card_stripe_customer_id` varchar(256) DEFAULT NULL,
`cron_card_created` datetime NOT NULL,
`cron_card_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cron_payments`
--
CREATE TABLE `cron_payments` (
`cron_payment_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`product_order_num` text NOT NULL COMMENT 'customer_order details id',
`price` decimal(10,2) NOT NULL,
`duration` tinyint(1) NOT NULL COMMENT '0 for week , 1 for month , 2 for year',
`infinite` tinyint(1) NOT NULL COMMENT '0 for no , 1 for yes',
`excecution_time` tinyint(1) NOT NULL COMMENT 'no of times cron to be excecuted',
`new_cron_date` date NOT NULL COMMENT 'when cron will run again',
`cron_created` datetime NOT NULL,
`cron_status` tinyint(1) NOT NULL COMMENT '1 for still excecute , 0 for over '
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cron_payment_logs`
--
CREATE TABLE `cron_payment_logs` (
`cron_payment_log_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`cron_id` int(11) NOT NULL,
`product_order_number` text CHARACTER SET utf8 NOT NULL,
`payment_response` text CHARACTER SET utf8 NOT NULL,
`status` tinyint(1) NOT NULL,
`cron_payment_log_created` datetime NOT NULL,
`pay_mode` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `cron_stop`
--
CREATE TABLE `cron_stop` (
`cron_stop_id` int(11) NOT NULL,
`cron_order_num` text NOT NULL,
`cron_status` tinyint(1) NOT NULL,
`stop_reason` text NOT NULL,
`customers_id` int(11) NOT NULL,
`cron_stop_created` datetime NOT NULL,
`cron_stop_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `currencies`
--
CREATE TABLE `currencies` (
`currency_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`currency_used` varchar(255) CHARACTER SET utf8 NOT NULL,
`use_conversion` tinyint(1) NOT NULL DEFAULT '0',
`USD` decimal(10,2) DEFAULT NULL,
`GBP` decimal(10,2) DEFAULT NULL,
`EUR` decimal(10,2) DEFAULT NULL,
`currency_created` datetime NOT NULL,
`currency_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `currencies`
--
INSERT INTO `currencies` (`currency_id`, `group_id`, `currency_used`, `use_conversion`, `USD`, `GBP`, `EUR`, `currency_created`, `currency_modified`) VALUES
(1, 1, 'USD', 0, NULL, NULL, NULL, '2018-04-10 17:43:00', '2018-04-11 15:16:23');
-- --------------------------------------------------------
--
-- Table structure for table `currency_symbols`
--
CREATE TABLE `currency_symbols` (
`symbol_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`currency_name` varchar(255) NOT NULL,
`symbol` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `currency_symbols`
--
INSERT INTO `currency_symbols` (`symbol_id`, `group_id`, `currency_name`, `symbol`) VALUES
(5, 1, 'USD', '$'),
(6, 1, 'GBP', '£'),
(7, 1, 'EUR', '€');
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`customer_id` int(10) NOT NULL,
`customer_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
`customer_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
`customer_email` varchar(100) CHARACTER SET utf8 NOT NULL,
`customer_phone` varchar(15) CHARACTER SET utf8 NOT NULL,
`customer_password` varchar(200) CHARACTER SET utf8 NOT NULL,
`password_change_request` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 for yes , 0 for no ',
`customer_status` tinyint(1) NOT NULL COMMENT '1for active;0 for deactive',
`customer_register_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
`customer_created` datetime NOT NULL,
`customer_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `customer_orders`
--
CREATE TABLE `customer_orders` (
`customer_order_id` int(11) NOT NULL,
`total_amount` float(10,2) NOT NULL,
`coupons_code` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`customers_id` int(11) NOT NULL,
`customer_order_created` datetime NOT NULL,
`customer_number` varchar(256) CHARACTER SET utf8 NOT NULL,
`shipment_id` int(11) NOT NULL,
`orders_status` tinyint(4) NOT NULL COMMENT '1 for pending , 2 for procssed , 3 for shipped , 4 for delivered',
`discount` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `customer_order_details`
--
CREATE TABLE `customer_order_details` (
`customer_order_detail_id` int(11) NOT NULL,
`customer_orders_id` int(11) NOT NULL,
`products_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`price` float(10,2) NOT NULL,
`order_mrp_price` decimal(10,2) NOT NULL,
`order_shipping` decimal(10,2) NOT NULL DEFAULT '0.00',
`customer_order_details_created` datetime NOT NULL,
`order_number` varchar(256) CHARACTER SET utf8 NOT NULL,
`order_status` tinyint(1) NOT NULL COMMENT '1 for pending , 2 for processed , 3 for shipped , 4 for delivered , 5 for returned'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `email_logs`
--
CREATE TABLE `email_logs` (
`email_log_id` bigint(20) NOT NULL,
`email_to` varchar(256) CHARACTER SET utf8 NOT NULL,
`email_to_user_id` int(11) NOT NULL,
`email_log_subject` varchar(255) CHARACTER SET utf8 NOT NULL,
`email_body` text CHARACTER SET utf8 NOT NULL,
`email_message_id` varchar(500) CHARACTER SET utf8 NOT NULL,
`email_request_id` varchar(500) CHARACTER SET utf8 NOT NULL,
`email_status` tinyint(1) NOT NULL,
`email_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `email_settings`
--
CREATE TABLE `email_settings` (
`email_settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`outgoing_server_name` varchar(255) DEFAULT NULL,
`smtp_port_no` int(2) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`amazon_email` varchar(255) DEFAULT NULL,
`access_key` varchar(255) DEFAULT NULL,
`secret_access_key` varchar(255) DEFAULT NULL,
`method` tinyint(1) NOT NULL COMMENT '1 for default , 2 for smtp , 3 for amazon',
`email_settings_created` datetime NOT NULL,
`email_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `email_templates`
--
CREATE TABLE `email_templates` (
`email_template_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`template_slug` varchar(255) NOT NULL,
`template_name` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`email_used_for` text NOT NULL,
`template_type_id` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '1 for active 0 for inactive',
`template_created` datetime NOT NULL,
`template_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `email_templates`
--
INSERT INTO `email_templates` (`email_template_id`, `group_id`, `template_slug`, `template_name`, `subject`, `body`, `email_used_for`, `template_type_id`, `status`, `template_created`, `template_modified`) VALUES
(1, 1, 'register_email', 'Register Email (Welcome)', 'Congratulations - Your Registration Is Successful', 'Hello [first name] [Last name],
\r\n\r\nThank you for registering with Letshop.
\r\n\r\nTo gain access, [url]
\r\n\r\nThen sign in using these credentials:
\r\n\r\nEmail: [licence email]
\r\n\r\nPassword: you have set at time of account opening
\r\n\r\nBe sure to save these details securely to facilitate
\r\nlogging in the future.
\r\n\r\nThe system is simple to access and operate. If you have
\r\nany trouble or any questions, please feel free to contact
\r\nus
\r\n\r\nOnce again, thank you for choosing us!
\r\n\r\n
\r\n\r\nRegards
\r\n\r\n
', 'Email Used when user Register with us. Sends this mail to welcome them
\r\n', 1, 1, '2017-11-10 00:00:00', '2018-01-16 17:16:01'),
(2, 1, 'forget_password', 'Forget Password', 'Request for new password', 'Hi [first name] [last name] ,
\r\n\r\n
\r\nClick here to reset pasword: [reset link]
\r\n
\r\nYour login email is [licence email]
\r\n\r\nBest regards
', 'If user forgets their password and request for new one ', 3, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:20'),
(3, 1, 'reset_password', 'Reset Password Successfully', 'Reset Password Successfully', 'Hi [first name] [last name] ,
\r\n\r\n
\r\n\r\nYou have successfully reset your password.
\r\n\r\nPlease now login with
\r\n\r\nemail : [licence email]
\r\n\r\nand password which you heve recently set
', 'Confirms their password reset request is successful.', 2, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:19'),
(4, 1, 'contact_us', 'Contact Us', 'Request for Contacting us', 'Hello [first name] [Last name],
\r\n\r\ntried to contact with Letshop.
\r\n\r\nPlease reply on mail: [licence email]
\r\n\r\nfor the following query
\r\n\r\n[message]
\r\n\r\n
\r\n\r\n
', 'This email is used when user wants to contact with the admin and posts their query.', 4, 1, '2017-11-13 00:00:00', '2017-12-28 15:57:52'),
(5, 1, 'subscription', 'Subcription', 'Subscribe with Letsshop', 'Hello
\r\n\r\nThank you for your subscription with the mail [licence email]
\r\n\r\non [date and time]
\r\n\r\nWe will update you regularly with our offers and discount
', 'Confirmation that user is successfully subscribed
\r\n', 5, 1, '2017-11-13 00:00:00', '2018-01-08 15:23:06'),
(6, 1, 'guest_register', 'Guest Registration', 'Congratulations You are registered', 'Hello [first name] [Last name],
\r\n\r\nThank you for registering with Letshop.
\r\n\r\nTo gain access, [url]
\r\n\r\nThen sign in using these credentials:
\r\n\r\nEmail: [licence email]
\r\n\r\nPassword: [password]
\r\n\r\nBe sure to save these details securely to facilitate
\r\nlogging in the future.
\r\n\r\nThe system is simple to access and operate. If you have
\r\nany trouble or any questions, please feel free to contact
\r\nus
\r\n\r\nOnce again, thank you for choosing us!
\r\n\r\nBest Regards
\r\n\r\n
', 'If account is created for guest user . This email is used to send the credentials to the user for their account.', 6, 1, '2017-11-15 00:00:00', '2017-12-21 18:43:18'),
(7, 1, 'order_summary', 'Order Summary', 'Your Order details are', 'Hello [first name] [Last name]
\r\n\r\nOrder Details are
\r\n\r\n [product details]
\r\n\r\nShipping Details are
\r\n\r\nCity [city] , State [state]
\r\n\r\nCountry [country]
\r\n\r\n [zipcode]
\r\n\r\nSummary
\r\n\r\nTotal amount to be paid is [amount]
\r\n\r\nOrdered on [date and time]
\r\n\r\nThank You for shopping with us
', 'Details of the orders including its shipping details order details and payment details', 7, 1, '2017-11-16 00:00:00', '2017-12-21 18:43:17'),
(8, 1, 'status_of_product', 'Status Of Product', 'Your Product Status is', 'Hello [first name] [Last name]
\r\n\r\nYour order [product name]
\r\n\r\nQuantity - [product quantity] ordered on [date and time]
\r\n\r\nHas been [status]
\r\n\r\nAmount Paid [product price]
\r\n\r\nThank You for shopping with us
', 'This email is send to update the user about the current status of their order', 8, 1, '2017-11-21 00:00:00', '2017-12-21 18:43:17'),
(9, 1, 'recurring_payment', 'Recurring Payment', 'Payment Succcessfull', 'Hello [first name] [Last name]
\r\n\r\nThe scheduled payment for the product is successful. on [date and time]
\r\n\r\nHere are the details
\r\n\r\nProduct Name: [product name]
\r\n\r\nPrice: [recurring_price]
\r\n\r\nProduct Quantity: [product quantity]
\r\n\r\nThe Payment is scheduled for [duration]
\r\n\r\nFor [times] times
\r\n\r\nTotal Amount Paid : [total]
\r\n\r\nThe amount is paid by using [mode]
\r\n\r\nYou can check by login from [licence email]
\r\n\r\nThank You
', 'This is to notify the user about their scheduled recurring payments is successful', 9, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'),
(10, 1, 'recurring_payment_failure', 'Recurring Payment Failure', 'Failure of Payment Update Card', 'Hello [first name] [Last name]
\r\n\r\nYour payment for the last scheduled order
\r\n\r\n[product name] : x [product quantity] price [recurring_price]
\r\n\r\ntotal = [total]
\r\n\r\nusing [mode]
\r\n\r\nis failed.
\r\n\r\nPlease click on below link to update your credentials.
\r\n\r\n[url]
\r\n\r\n
\r\n\r\nThank you
', 'This is to notify that the payment for their recurring order is failed.Kindly update their cards', 10, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'),
(11, 1, 'refund_successful', 'Refund Successful', 'Order Refund Successfull', 'Hello [first name] [Last name]
\n\nYour refund for the order
\n\nProduct Name: [product name]
\n\nQuantity: [product quantity]
\n\nProduct Price : [product price]
\n\nis successful.
\n\nYou can check your order status in your account associated with [licence email]
\n\nOrder again
\n\nHave a nice day
\n\nThank You
\n', 'This is to notify users refund request is successful and we have refunded for their order', 8, 1, '2017-12-21 00:00:00', '2017-12-21 18:57:04'),
(12, 1, 'forget_password_admin', 'Admin Forget Password', 'Forget Password', 'Hi [first name] [last name] ,
\r\n\r\n
\r\nClick here to reset pasword: [reset link]
\r\n
\r\nYour login email is [licence email]
\r\n\r\nBest regards
', 'Admin password reset request ', 3, 1, '2018-01-01 00:00:00', NULL),
(13, 1, 'canceled_refund_request', 'Canceled Refund Request', 'Your refund request is Canceled', 'Hello [first name] [Last name]
\n\nYour request for [product name] [product price] [product quantity] is cancelled by the admin.
\n\nThank you
\n\n[licence email]
\n', 'cancelled refund request
\r\n', 8, 1, '2018-01-11 00:00:00', '2018-01-11 17:27:24');
-- --------------------------------------------------------
--
-- Table structure for table `email_template_type`
--
CREATE TABLE `email_template_type` (
`email_template_type_id` int(11) NOT NULL,
`token` varchar(255) NOT NULL,
`msg_token` varchar(255) NOT NULL,
`template_type_status` tinyint(1) NOT NULL,
`template_type_created` datetime NOT NULL,
`template_type_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `email_template_type`
--
INSERT INTO `email_template_type` (`email_template_type_id`, `token`, `msg_token`, `template_type_status`, `template_type_created`, `template_type_modified`) VALUES
(1, '[licence email],[first name],[Last name],[url]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-10 00:00:00', NULL),
(2, '[licence email],[first name],[last name],[date and time]', '[licence email],[first name],[last name],[date and time]', 1, '2017-11-10 00:00:00', NULL),
(3, '[licence email],[first name],[last name],[reset link],[date and time]', '[licence email],[first name],[last name],[reset link],[date and time]', 1, '2017-11-10 00:00:00', NULL),
(4, '[licence email],[first name],[Last name],[date and time],[message]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-13 00:00:00', NULL),
(5, '[licence email],[date and time]', '[licence email],[date and time]', 1, '2017-11-13 00:00:00', NULL),
(6, '[licence email],[first name],[Last name],[url],[password]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-15 00:00:00', NULL),
(7, '[licence email],[first name],[Last name],[amount],[date and time],[city],[state],[country],[zipcode],[product details]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-16 00:00:00', NULL),
(8, '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity],[status]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-11-21 00:00:00', NULL),
(9, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-12-21 00:00:00', NULL),
(10, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode],[url]', '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', 1, '2017-12-21 00:00:00', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `faqs`
--
CREATE TABLE `faqs` (
`faq_id` int(11) NOT NULL,
`products_id` int(11) NOT NULL,
`faq_question` varchar(1000) NOT NULL,
`faq_answer` text NOT NULL,
`faq_status` tinyint(1) NOT NULL COMMENT '0 for inactive 1 for active',
`faq_created` datetime NOT NULL,
`faq_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `faqs`
--
INSERT INTO `faqs` (`faq_id`, `products_id`, `faq_question`, `faq_answer`, `faq_status`, `faq_created`, `faq_modified`) VALUES
(1, 61, 'What about Durability of product?', 'Philips is a brand, who always gives best in Home Appliances and serving the community. As always this o=product is also come with it\'s best.', 1, '2018-04-20 12:11:00', '2018-04-20 13:22:13'),
(2, 62, 'How much is the breadth and the height?', 'W*D*H = 675*668*1715 (mm)', 1, '2018-04-20 12:30:55', NULL),
(3, 62, 'Does this require stabiliser?', 'No', 1, '2018-04-20 12:31:14', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `footer_tabs`
--
CREATE TABLE `footer_tabs` (
`footer_tab_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`tab_1` varchar(255) NOT NULL,
`tab_2` varchar(255) NOT NULL,
`footer_tab_created` datetime NOT NULL,
`footer_tab_modified` datetime DEFAULT NULL,
`tab_3` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`group_id` int(11) NOT NULL,
`group_name` varchar(20) NOT NULL,
`group_status` tinyint(1) NOT NULL,
`group_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`group_id`, `group_name`, `group_status`, `group_created`) VALUES
(1, 'admin', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `group_pages`
--
CREATE TABLE `group_pages` (
`group_page_id` int(11) NOT NULL,
`group_page_name` varchar(30) NOT NULL,
`group_page_status` tinyint(1) NOT NULL COMMENT '0 for deactive;1 for active',
`group_pages_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `group_pages`
--
INSERT INTO `group_pages` (`group_page_id`, `group_page_name`, `group_page_status`, `group_pages_created`) VALUES
(1, 'Policy', 1, '2018-04-16 00:00:00'),
(2, 'Company', 1, '2018-04-16 05:06:17'),
(3, 'Our Businesss', 1, '2018-04-16 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `headings_info`
--
CREATE TABLE `headings_info` (
`heading_info_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`popular` varchar(255) NOT NULL,
`products` varchar(255) NOT NULL,
`product_image_original` varchar(255) NOT NULL,
`product_mask_name` varchar(255) NOT NULL,
`product_status` tinyint(1) NOT NULL,
`heading_info_created` datetime NOT NULL,
`heading_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `login_logs`
--
CREATE TABLE `login_logs` (
`users_id` int(10) NOT NULL,
`login_log_from` int(10) NOT NULL,
`login_log_mode` varchar(256) NOT NULL,
`login_log_ip_address` varchar(256) NOT NULL,
`login_log_user_agent` varchar(256) NOT NULL,
`login_log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `login_logs`
--
INSERT INTO `login_logs` (`users_id`, `login_log_from`, `login_log_mode`, `login_log_ip_address`, `login_log_user_agent`, `login_log_created`) VALUES
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '2018-04-26 11:11:42');
-- --------------------------------------------------------
--
-- 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-23 13:01:15'),
(3, 1, 3, 'set_2', 2, 1, '2018-04-02 00:00:00', '2018-04-23 13:01:15'),
(5, 1, 2, 'set_4', 4, 1, '2018-04-02 00:00:00', '2018-04-23 13:01:15'),
(6, 1, 5, 'set_5', 5, 1, '2018-04-02 00:00:00', '2018-04-23 13:01:15'),
(7, 1, 4, 'set_6', 6, 1, '2018-04-02 00:00:00', '2018-04-23 13:01:15');
-- --------------------------------------------------------
--
-- 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', '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.
', 'How it Works', 'How it Works', 1, '2017-10-13 00:00:00', '2018-04-16 17:02:05'),
(2, 1, 1, 'Terms & Conditions', 'terms_conditions', '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.
', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:12'),
(3, 1, 1, 'Privacy Policy', 'privacy_policy', '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.
', 'Privacy Policy', 'Privacy Policy', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:28'),
(4, 2, 2, 'About us', 'about_us', 'accompanied by English versions from the 1914 translation by H. Rackham.
', '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', '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\nnm,
', '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', '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.
', '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', '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.
', 'Core Values', 'Core Values', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:23'),
(8, 2, 3, 'Careers', 'careers', '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.
', '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', '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.
', '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', ''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
', 'Sell on Online', 'Sell on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(13, 3, 3, 'Advertise on Online', 'advertise_on_online', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Advertise on Online', 'Advertise on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'),
(14, 3, 3, 'Media Enquiries', 'media_enquiries', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Media Enquiries', 'Media Enquiries', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11'),
(15, 3, 3, 'Be an Affiliate ', 'be_an_affiliate ', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Be an Affiliate ', 'Be an Affiliate ', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11');
-- --------------------------------------------------------
--
-- Table structure for table `payment_details`
--
CREATE TABLE `payment_details` (
`payment_detail_id` int(11) NOT NULL,
`customer_orders_id` int(11) DEFAULT NULL,
`customers_id` int(11) NOT NULL,
`description` text NOT NULL,
`paid_amount` decimal(10,2) NOT NULL,
`currency` varchar(255) NOT NULL,
`payment_status` int(11) NOT NULL,
`payment_mode` tinyint(1) NOT NULL COMMENT '1 for paypal , 2 for authorise , 3 for stripe',
`payment_details_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `plans`
--
CREATE TABLE `plans` (
`plan_logs_id` int(11) NOT NULL,
`plans_id` int(11) NOT NULL,
`product_limit` varchar(255) CHARACTER SET utf8 NOT NULL,
`plan_log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`product_id` int(10) NOT NULL,
`product_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`product_description` text CHARACTER SET utf8 NOT NULL,
`mrp_price` decimal(10,2) NOT NULL,
`sale_price` decimal(10,2) DEFAULT '0.00',
`shipping_price` decimal(10,2) NOT NULL DEFAULT '0.00',
`recurring` tinyint(1) NOT NULL,
`duration` tinyint(1) DEFAULT NULL,
`returning` int(10) NOT NULL,
`recurring_price` varchar(255) DEFAULT NULL,
`infinite` tinyint(1) DEFAULT '0',
`times` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`brands_id` int(10) DEFAULT NULL,
`categories_id` int(11) DEFAULT NULL,
`product_status` tinyint(1) NOT NULL COMMENT '1 for active , 0 for Inactive',
`product_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
`video_link` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`meta_tags` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`keywords` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`meta_description` text CHARACTER SET utf8,
`product_tag` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`is_featured` tinyint(1) DEFAULT '0',
`product_created` datetime NOT NULL,
`product_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`product_id`, `product_name`, `product_description`, `mrp_price`, `sale_price`, `shipping_price`, `recurring`, `duration`, `returning`, `recurring_price`, `infinite`, `times`, `brands_id`, `categories_id`, `product_status`, `product_slug`, `video_link`, `meta_tags`, `keywords`, `meta_description`, `product_tag`, `is_featured`, `product_created`, `product_modified`) VALUES
(61, 'Philips MMS-2550F/94 2.1 Channel Multimedia Speakers System (Black)', 'Technical Details
\r\n\r\n\r\n \r\n \r\n | Brand | \r\n Philips | \r\n
\r\n \r\n | Model | \r\n MMS2550F/94 | \r\n
\r\n \r\n | Model Name | \r\n MMS-2550F/94 | \r\n
\r\n \r\n | Model Year | \r\n 2015 | \r\n
\r\n \r\n | Item Weight | \r\n 3.58 Kg | \r\n
\r\n \r\n | Package Dimensions | \r\n 37.4 x 31.4 x 20.2 cm | \r\n
\r\n \r\n | Item model number | \r\n MMS2550F/94 | \r\n
\r\n \r\n | Additional Features | \r\n Bass Reflex Speakers deliver deep and powerful bass, Designed for style - looks as good as it sounds, Wooden housing for quality bass reproduction, Input-RCA Jack,FM Radio, USB/SD, Remote Control, Speaker-3" satellite, 4" woofer, 2500W PMPO | \r\n
\r\n \r\n | Number Of Items | \r\n 1 | \r\n
\r\n \r\n | Speaker Surround Sound Channel Configuration | \r\n 2.1 Channel | \r\n
\r\n \r\n | Speaker Connectivity | \r\n wired | \r\n
\r\n \r\n | Audio Wattage | \r\n 20 Watts | \r\n
\r\n \r\n | Voltage | \r\n 230 Volts | \r\n
\r\n \r\n | Wattage | \r\n 20 Watts | \r\n
\r\n \r\n | Batteries Included | \r\n No | \r\n
\r\n \r\n | Batteries Required | \r\n No | \r\n
\r\n \r\n | Signal To Noise Ratio | \r\n 65 dB | \r\n
\r\n \r\n | Total Usb Ports | \r\n 1 | \r\n
\r\n \r\n | Connector Type | \r\n USB | \r\n
\r\n \r\n | Includes Remote | \r\n Yes | \r\n
\r\n \r\n
', '2399.00', '0.00', '0.00', 0, 0, 15, '', 1, '', 61, 24, 1, 'godrej-255-l-direct-cool-single-door-4-star-refrigerator-erica-blue-rd-edge-duo-255-pd-inv42', NULL, ' Philips MMS-2550F/94 2.1 Channel Multimedia Speakers System (Black) ', ' Philips MMS-2550F/94 2.1 Channel Multimedia Speakers System (Black) ', ' Philips MMS-2550F/94 2.1 Channel Multimedia Speakers System (Black) ', ' Philips MMS-2550F/94 2.1 Channel Multimedia Speakers System (Black) ', 1, '2018-04-20 11:53:42', '2018-04-20 13:18:03'),
(62, 'MacBook', 'Intel Core 2 Duo processor
\r\n\r\nPowered by an Intel Core 2 Duo processor at speeds up to 2.16GHz, the new MacBook is the fastest ever.
\r\n\r\n1GB memory, larger hard drives
\r\n\r\nThe new MacBook now comes with 1GB of memory standard and larger hard drives for the entire line perfect for running more of your favorite applications and storing growing media collections.
\r\n\r\nSleek, 1.08-inch-thin design
\r\n\r\nMacBook makes it easy to hit the road thanks to its tough polycarbonate case, built-in wireless technologies, and innovative MagSafe Power Adapter that releases automatically if someone accidentally trips on the cord.
\r\n\r\nBuilt-in iSight camera
\r\n\r\nRight out of the box, you can have a video chat with friends or family,2 record a video at your desk, or take fun pictures with Photo Booth
', '4990.00', '0.00', '50.00', 0, 0, 15, '', 1, '', 62, 29, 1, 'samsung-394-l-3-star-frost-free-double-door-refrigerator-rt39m5538s8tl-elegant-inox-5-in-1-convertibleinverter-compressor', NULL, 'MacBook', 'MacBook', 'MacBook', 'MacBook', 1, '2018-04-20 12:27:06', '2018-04-20 13:08:57'),
(63, 'Redmi 4 (Black, 32 GB)', '\r\n - 13MP primary camera with 5-elements lens, f/2.2 aperture, PDAF, high dynamic range (HDR), panaroma, 1080p full HD video recording and 5MP front facing camera
\r\n - 12.7 centimeters (5-inch) display with 1280 x 720 pixels resolution and 293 ppi pixel density
\r\n - Android v6.0.1 Marshmallow operating system with up to 1.4GHz Qualcomm Snapdragon 435 octa core processor with Adreno 505 GPU, 3GB RAM, 32GB internal memory expandable up to 128GB and dual SIM (micro+nano) dual-standby (4G+4G), Hybrid SIM slot
\r\n - 4100mAH lithium-ion battery providing talk-time of 36 hours and standby time of 432 hours
\r\n - 1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase
\r\n
', '949.00', '840.00', '5.00', 0, 0, 15, '', 1, '', 64, 34, 1, 'redmi-4-black-32-gb', NULL, NULL, NULL, NULL, NULL, 1, '2018-04-20 12:32:25', '2018-04-20 13:04:08'),
(64, 'HP LP3065', 'Stop your co-workers in their tracks with the stunning new 30-inch diagonal HP LP3065 Flat Panel Monitor. This flagship monitor features best-in-class performance and presentation features on a huge wide-aspect screen while letting you work as comfortably as possible - you might even forget you're at the office
', '3900.00', '3800.00', '10.00', 0, 1, 15, '0', 1, '0', 61, 29, 1, 'hp-lp3065', NULL, 'HP LP3065', 'HP LP3065', NULL, 'HP LP3065', 1, '2018-04-20 13:24:37', NULL),
(65, 'Apple iPad Tablet (9.7 inch, 32GB, Wi-Fi), Space Grey', '\r\n - 8MP primary camera with auto focus, panorama, HDR, exposure control, burst mode, tap to focus, timer mode, f/2.4 aperture, five-element lens, hybrid IR filter, backside illumination, auto image stabilisation, face detection, photo geotagging, video image stabilisation, slow motion (120 fps), 3X video zoom, video geotagging and 1.2MP front facing camera
\r\n - 24.64 centimeters (9.7-inch) LED Backlit Display with IPS Technology, Fingerprint-resistant Oleophobic Coating with 2048 x 1536 pixels resolution and 264 ppi pixel density
\r\n - iOS v10 operating system with A9 Chip with 64-bit Architecture with Embedded M9 Co-processor processor, 32GB internal memory
\r\n - 32.4mAH lithium-polymer battery
\r\n - 1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase
\r\n
', '3500.00', '3000.00', '50.00', 0, 1, 45, '0', 1, '0', 61, 32, 1, 'apple-ipad-tablet-97-inch-32gb-wi-fi-space-grey', NULL, 'Apple iPad Tablet (9.7 inch, 32GB, Wi-Fi), Space Grey ', 'Apple iPad Tablet (9.7 inch, 32GB, Wi-Fi), Space Grey ', NULL, 'Apple iPad Tablet (9.7 inch, 32GB, Wi-Fi), Space Grey ', 1, '2018-04-20 14:32:40', NULL),
(66, 'HP 15-bs145tu 15.6-inch FHD Laptop (8th Gen Intel Core i5-8250U/8GB/1TB/Free DOS/Integrated Graphics), Sparkling Black', '\r\n - 8th Gen Intel Core i5 - 8250U Processor (1.6 GHz base frequency, up to 3.4 GHz with Intel Turbo Boost Technology, 6 MB cache, 4 cores)
\r\n - 8 GB DDR4 RAM
\r\n - 1TB 5400rpm Serial ATA hard drive
\r\n - 15.6-inch Full HD (1920 x 1080) Display
\r\n - Intel UHD 620 Graphics
\r\n - Free DOS Operating System
\r\n - Weighs only 2.1 Kg
\r\n
', '37990.00', '0.00', '0.00', 0, 1, 0, '0', 1, '0', 61, 29, 1, 'hp-15-bs145tu-156-inch-fhd-laptop-8th-gen-intel-core-i5-8250u8gb1tbfree-dosintegrated-graphics-sparkling-black', '', 'HP 15-bs145tu 15.6-inch FHD Laptop (8th Gen Intel Core i5-8250U/8GB/1TB/Free DOS/Integrated Graphics), Sparkling Black', 'HP 15-bs145tu 15.6-inch FHD Laptop (8th Gen Intel Core i5-8250U/8GB/1TB/Free DOS/Integrated Graphics), Sparkling Black', NULL, 'HP 15-bs145tu 15.6-inch FHD Laptop (8th Gen Intel Core i5-8250U/8GB/1TB/Free DOS/Integrated Graphics), Sparkling Black', 1, '2018-04-23 12:32:42', '2018-04-24 12:51:30');
-- --------------------------------------------------------
--
-- 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
(4, 62, 'Silver', '2018-04-20 12:29:54', NULL),
(5, 62, 'Black', '2018-04-20 12:29:54', NULL),
(6, 62, 'Brown', '2018-04-20 12:29:54', NULL),
(7, 62, 'NavyBlue', '2018-04-20 12:29:54', NULL),
(8, 61, 'Black', '2018-04-20 13:21:06', NULL),
(9, 64, 'Black', '2018-04-20 13:31:21', NULL),
(10, 65, 'silver', '2018-04-20 14:35:50', NULL),
(11, 65, 'Gold', '2018-04-20 14:46:03', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `product_csv_files`
--
CREATE TABLE `product_csv_files` (
`csv_file_id` int(11) NOT NULL,
`csv_file_original` varchar(255) NOT NULL,
`csv_mask_name` text NOT NULL,
`csv_file_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `product_dimensions`
--
CREATE TABLE `product_dimensions` (
`product_dimensions_id` int(10) NOT NULL,
`products_id` int(10) NOT NULL,
`height` decimal(10,2) DEFAULT NULL,
`width` decimal(10,2) DEFAULT NULL,
`weight` decimal(10,2) DEFAULT NULL,
`dimensions_created` datetime NOT NULL,
`dimensions_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_dimensions`
--
INSERT INTO `product_dimensions` (`product_dimensions_id`, `products_id`, `height`, `width`, `weight`, `dimensions_created`, `dimensions_modified`) VALUES
(1, 61, '37.40', '31.40', '3500.00', '2018-04-20 12:02:18', '2018-04-20 13:21:07'),
(2, 62, '198.00', '90.00', '60000.00', '2018-04-20 12:29:54', NULL),
(3, 64, '37.40', '31.40', '3500.00', '2018-04-20 13:31:21', NULL),
(4, 65, '0.00', '15.60', '2100.00', '2018-04-20 14:35:50', '2018-04-23 12:38:46');
-- --------------------------------------------------------
--
-- Table structure for table `product_images`
--
CREATE TABLE `product_images` (
`product_image_id` int(10) NOT NULL,
`products_id` int(10) NOT NULL,
`product_image_original` varchar(256) NOT NULL,
`product_mask_name` varchar(256) NOT NULL,
`image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_images`
--
INSERT INTO `product_images` (`product_image_id`, `products_id`, `product_image_original`, `product_mask_name`, `image_created`) VALUES
(201, 59, '260c8d0454b4b03ca573ee4730c7fd1b.jpg', '072a068cf8d3c99e5f7954ad5296da31.jpg', '2018-04-13 13:44:57'),
(202, 58, 'f4ac2515ed82a343e7a45b6ebf986c3d.jpg', '1d9be41ad2ec862ea394d6cede7bfadb.jpg', '2018-04-13 13:45:13'),
(203, 57, 'eeea355f874be87000beae8e2db2def6.jpg', 'bb9f2f2318d1a762418727a8920b2653.jpg', '2018-04-13 13:45:30'),
(204, 60, 'c353498c74d7673ba202b9cb2334b1cb.jpg', 'f41b5f789314d10212b86f9d27d94e10.jpg', '2018-04-13 13:50:18'),
(225, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '5ad93adafdeb6ea72372d5bdbd3c3e6d.jpeg', '2018-04-20 13:00:14'),
(226, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '7a1a73874c84c9cee3ae466f24696507.jpeg', '2018-04-20 13:00:41'),
(227, 63, '201609280114371436xrnv.JPG', '3ed962da9f337453c81218490454fc82.JPG', '2018-04-20 13:00:56'),
(228, 63, '1F3455FF-B5FC-4553-7C1C-94C8E8325D0A.jpg', 'dcacce655ab825b4ba89646f70144011.jpg', '2018-04-20 13:01:41'),
(229, 62, 'MacBookAir-1140x380.jpg', '62f14fa84abb764645c87fb206266b06.jpg', '2018-04-20 13:10:46'),
(230, 62, 'og123.png', '2cc63435d21c95f1230e50f4e79120c8.png', '2018-04-20 13:11:58'),
(231, 61, 'BTM2180_37-IMS-en_US.jpeg', '8e0cd7aa36c02af0c1e657e22028dc33.jpeg', '2018-04-20 13:19:21'),
(232, 61, 'AZ1852_98-IMS-en_IN.jpeg', 'a10b98eea2db097837e27044f32abfca.jpeg', '2018-04-20 13:19:47'),
(233, 64, 'laptop1.jpg', '079c35a62ee3b58a08c028ebd3153029.jpg', '2018-04-20 13:27:26'),
(234, 64, 'l.png', '44ea7af342b11a27218189ece99db83a.png', '2018-04-20 13:28:08'),
(235, 65, '1490128260000_img_7734001_result_1.jpg', '121b42ea0910f86ba0eb7c2d14b7aa86.jpg', '2018-04-20 14:44:10'),
(236, 65, 'apple-ipad-pro.jpg', '6680240d853324070c254b94bb2b9331.jpg', '2018-04-20 14:45:18'),
(239, 66, '81wMY-Ba6iL._SL1500_.jpg', '74cb688b106c8a20890eaf4b476f1d63._SL1500_', '2018-04-23 12:39:58'),
(240, 66, '81cHuixGMwL._SL1500_.jpg', '498166d81e98afb7c3f088abe8f9dd5c._SL1500_', '2018-04-23 12:39:58'),
(241, 68, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', '1b2e10862908331b01fb967cddb410f6.jpg', '2018-04-25 14:28:44'),
(242, 68, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', 'fceaa3472d2b983f8cf4e20eee89a000.jpg', '2018-04-25 14:28:45'),
(243, 68, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', 'fceaa3472d2b983f8cf4e20eee89a000.jpg', '2018-04-25 14:28:45'),
(244, 69, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '623615f74dcc2bc4e98ba8cd79134a9a.jpg', '2018-04-25 14:28:46'),
(245, 69, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '9bd5b289f7ec173925be195ef9adeb29.jpg', '2018-04-25 14:28:47'),
(246, 69, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '362b3590f58feb71e0074a15620eab6f.jpg', '2018-04-25 14:28:48'),
(247, 70, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', '109e6ed2caff2a6cd0d5647accc392ff.jpg', '2018-04-25 14:28:49'),
(248, 70, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', '109e6ed2caff2a6cd0d5647accc392ff.jpg', '2018-04-25 14:28:49'),
(249, 70, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', 'a316c2f2435e4e50d5a84133f55e2192.jpg', '2018-04-25 14:28:50'),
(250, 71, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', '390dea7ed170ee1cf45124b1eb2b7c63.jpg', '2018-04-25 14:32:46'),
(251, 71, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', '390dea7ed170ee1cf45124b1eb2b7c63.jpg', '2018-04-25 14:32:46'),
(252, 71, 'Taidian-Ceramic-Seed-beads-Neon-Orange-Delica-beads-For-Beading-made-in-Japan-DB722-1-6MM.jpg', '390dea7ed170ee1cf45124b1eb2b7c63.jpg', '2018-04-25 14:32:46'),
(253, 72, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '8e9e5ad9d1dac0f36042ac23daaa2dfc.jpg', '2018-04-25 14:32:47'),
(254, 72, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '8e9e5ad9d1dac0f36042ac23daaa2dfc.jpg', '2018-04-25 14:32:47'),
(255, 72, 'Taidian-Hot-Sale-Japanese-Delica-Beads-for-DIY-Christams-Charm-Bracelet-Making-Accessories-1-6mm-10g.jpg', '8e9e5ad9d1dac0f36042ac23daaa2dfc.jpg', '2018-04-25 14:32:47'),
(256, 73, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', '0b4c3c9094d46a3034cd0ae5ed373f5d.jpg', '2018-04-25 14:32:48'),
(257, 73, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', '0b4c3c9094d46a3034cd0ae5ed373f5d.jpg', '2018-04-25 14:32:48'),
(258, 73, 'Taidian-New-Arrival-Silver-Delica-Beads-for-DIY-Christmas-Bracelets-Jewelry-Making-1-6mm-Metal-Color.jpg', '0b4c3c9094d46a3034cd0ae5ed373f5d.jpg', '2018-04-25 14:32:48');
-- --------------------------------------------------------
--
-- 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
(71, 60, 29, NULL),
(84, 63, 36, NULL),
(85, 62, 41, NULL),
(86, 61, 26, NULL),
(90, 65, 43, '2018-04-20 14:32:50'),
(93, 64, 42, NULL),
(95, 66, 42, '2018-04-23 12:32:52');
-- --------------------------------------------------------
--
-- 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
(3, 62, 61, '2018-04-20 12:30:03'),
(4, 64, 62, '2018-04-20 13:28:19'),
(5, 65, 62, '2018-04-20 14:38:06'),
(6, 65, 64, '2018-04-20 14:45:36');
-- --------------------------------------------------------
--
-- Table structure for table `return_cancel_orders`
--
CREATE TABLE `return_cancel_orders` (
`return_cancel_order_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`order_numbers` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '0, for no action , 1 for refunded , 2 for cancelled',
`ip_address` varchar(255) NOT NULL,
`single` tinyint(1) NOT NULL,
`reason` text,
`action` tinyint(1) NOT NULL COMMENT '0 for cancel order and 1 for return order , 2 for recurring refund',
`recurring_id` int(11) DEFAULT NULL,
`return_cancel_orders_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `reviews`
--
CREATE TABLE `reviews` (
`review_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`orders_num` varchar(256) NOT NULL,
`products_id` int(11) NOT NULL,
`rating` tinyint(1) NOT NULL DEFAULT '0',
`reviews` text,
`review_status` tinyint(1) NOT NULL,
`review_created` datetime NOT NULL,
`review_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `save_cards`
--
CREATE TABLE `save_cards` (
`save_card_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`method` tinyint(1) NOT NULL,
`name_on_card` varchar(255) DEFAULT NULL,
`card_number` varchar(255) DEFAULT NULL,
`authorise_address` varchar(255) DEFAULT NULL,
`authorise_city` varchar(255) DEFAULT NULL,
`authorise_state` varchar(255) DEFAULT NULL,
`authorise_postal_code` varchar(255) DEFAULT NULL,
`authorise_country` varchar(255) DEFAULT NULL,
`stripe_month` tinyint(4) DEFAULT NULL,
`stripe_year` varchar(4) DEFAULT NULL,
`save_cards_created` datetime NOT NULL,
`save_cards_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`site_name` varchar(255) NOT NULL,
`site_keyword` varchar(255) DEFAULT NULL,
`site_description` text,
`blog_page` varchar(255) NOT NULL,
`google_analytic_code` text,
`facebook_tracking` text,
`facebook_id` varchar(255) DEFAULT NULL,
`twitter_user_id` varchar(255) DEFAULT NULL,
`youtube_channel_id` varchar(255) DEFAULT NULL,
`instagram_user_id` varchar(255) DEFAULT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(255) NOT NULL,
`settings_created` datetime NOT NULL,
`settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`settings_id`, `group_id`, `site_name`, `site_keyword`, `site_description`, `blog_page`, `google_analytic_code`, `facebook_tracking`, `facebook_id`, `twitter_user_id`, `youtube_channel_id`, `instagram_user_id`, `email`, `phone`, `settings_created`, `settings_modified`) VALUES
(1, 1, 'Lets Shop', '', '', '', ' ', '', 'https://www.facebook.com/asd', 'https://www.twitter.com/', 'https://www.youtube.com/sadsad', 'https://www.instagram.com/sdad', 'email@email.com', '8956121446', '2018-04-23 12:27:51', '2018-04-25 18:16:55');
-- --------------------------------------------------------
--
-- Table structure for table `status`
--
CREATE TABLE `status` (
`status_id` int(11) NOT NULL,
`status` varchar(256) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `status`
--
INSERT INTO `status` (`status_id`, `status`) VALUES
(1, 'Pending'),
(2, 'Processed'),
(3, 'Shipped'),
(4, 'Delivered'),
(5, 'Returned'),
(6, 'Refunded'),
(7, 'Stopped');
-- --------------------------------------------------------
--
-- Table structure for table `status_logs`
--
CREATE TABLE `status_logs` (
`status_log_id` int(11) NOT NULL,
`users_id` int(11) NOT NULL,
`customer_order_details_id` int(11) NOT NULL,
`order_status` tinyint(1) NOT NULL,
`log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `subscribers`
--
CREATE TABLE `subscribers` (
`subscriber_id` int(11) NOT NULL,
`customers_email` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`subscribed_on` datetime NOT NULL,
`subscriber_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `sub_categories`
--
CREATE TABLE `sub_categories` (
`sub_category_id` int(11) NOT NULL,
`categories_id` int(11) NOT NULL,
`sub_category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`sub_category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
`sub_category_status` tinyint(1) NOT NULL COMMENT '1 for active 0 for unactive',
`sub_category_created` datetime NOT NULL,
`sub_category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sub_categories`
--
INSERT INTO `sub_categories` (`sub_category_id`, `categories_id`, `sub_category_name`, `sub_category_slug`, `sub_category_status`, `sub_category_created`, `sub_category_modified`) VALUES
(26, 24, 'General', 'general', 1, '2017-10-25 00:00:00', NULL),
(36, 29, 'Smartphones', 'smartphones_', 1, '2018-04-20 12:24:15', '2018-04-24 11:50:20'),
(41, 29, 'MAC Book', 'mac-book', 1, '2018-04-20 12:58:33', '2018-04-20 15:02:36'),
(42, 29, 'Windows', 'windows', 1, '2018-04-20 12:58:33', '2018-04-20 15:02:36'),
(43, 32, 'Ipad', 'ipad', 1, '2018-04-20 12:58:50', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `sub_menu`
--
CREATE TABLE `sub_menu` (
`sub_menu_id` int(11) NOT NULL,
`categories_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`sub_menu_created` datetime NOT NULL,
`sub_menu_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sub_menu`
--
INSERT INTO `sub_menu` (`sub_menu_id`, `categories_id`, `groups_id`, `sub_menu_created`, `sub_menu_updated`) VALUES
(5, 29, 1, '2018-04-23 17:39:21', NULL),
(6, 34, 1, '2018-04-23 17:39:21', 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, 1, '2018-03-23 17:47:13', '2018-04-25 16:51:34');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int(10) NOT NULL,
`groups_id` int(11) NOT NULL DEFAULT '1',
`group_slug` varchar(20) CHARACTER SET utf8 NOT NULL,
`user_email` varchar(256) CHARACTER SET utf8 NOT NULL,
`user_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
`user_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
`user_password` varchar(256) CHARACTER SET utf8 NOT NULL,
`user_status` tinyint(1) NOT NULL COMMENT '0 for deactivate and 1 for activate',
`user_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
`user_created` datetime NOT NULL,
`user_update` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `groups_id`, `group_slug`, `user_email`, `user_firstname`, `user_lastname`, `user_password`, `user_status`, `user_ip`, `user_created`, `user_update`) VALUES
(1, 1, 'admin', 'test@gmail.com', 'Testing_server', 'Testing', 'e10adc3949ba59abbe56e057f20f883e', 1, '192.168.0.108', '2017-09-14 00:00:00', '2018-04-25 14:40:45');
-- --------------------------------------------------------
--
-- Table structure for table `user_credentials`
--
CREATE TABLE `user_credentials` (
`user_credential_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`no_of_days` int(11) NOT NULL DEFAULT '15',
`user_stripe_key` varchar(255) DEFAULT NULL,
`user_auth_login_name` varchar(255) DEFAULT NULL,
`user_auth_transaction_key` varchar(255) DEFAULT NULL,
`user_paypal_method_type` tinyint(1) DEFAULT NULL COMMENT '1 for standard; 2 for recurring bussiness ; 3 for paypal recurring',
`paypal_standard_email` varchar(255) DEFAULT NULL,
`paypal_api_name` varchar(255) DEFAULT NULL,
`paypal_api_password` varchar(255) DEFAULT NULL,
`paypal_signature` text,
`use_stripe` tinyint(1) NOT NULL DEFAULT '0',
`use_authorise` tinyint(1) NOT NULL DEFAULT '0',
`use_paypal` tinyint(1) NOT NULL DEFAULT '0',
`user_credentials_updation_on` datetime DEFAULT NULL,
`user_credential_created_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `versions`
--
CREATE TABLE `versions` (
`version_id` int(11) NOT NULL,
`version_no` decimal(10,2) NOT NULL,
`version_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `versions`
--
INSERT INTO `versions` (`version_id`, `version_no`, `version_created`) VALUES
(1, '1.00', '2018-02-22 00:00:00');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `address_book`
--
ALTER TABLE `address_book`
ADD PRIMARY KEY (`address_id`),
ADD KEY `customers_id` (`customers_id`),
ADD KEY `customers_id_2` (`customers_id`),
ADD KEY `address_city` (`address_city`),
ADD KEY `address_country` (`address_country`),
ADD KEY `is_default` (`is_default`);
--
-- Indexes for table `add_register_user_payment`
--
ALTER TABLE `add_register_user_payment`
ADD PRIMARY KEY (`register_payment_id`);
--
-- Indexes for table `banner_images`
--
ALTER TABLE `banner_images`
ADD PRIMARY KEY (`banner_image_id`);
--
-- Indexes for table `banner_text`
--
ALTER TABLE `banner_text`
ADD PRIMARY KEY (`banner_text`);
--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
ADD PRIMARY KEY (`brand_id`);
--
-- Indexes for table `cart_added`
--
ALTER TABLE `cart_added`
ADD PRIMARY KEY (`cart_added_id`),
ADD KEY `products_id` (`products_id`),
ADD KEY `customers_id` (`customers_id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`category_id`);
--
-- Indexes for table `color_settings`
--
ALTER TABLE `color_settings`
ADD PRIMARY KEY (`color_settings_id`);
--
-- Indexes for table `contact_info`
--
ALTER TABLE `contact_info`
ADD PRIMARY KEY (`contact_info_id`),
ADD KEY `users_id` (`group_id`),
ADD KEY `postal_code` (`postal_code`);
--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
ADD PRIMARY KEY (`country_id`);
--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
ADD PRIMARY KEY (`coupon_id`),
ADD KEY `coupon_code` (`coupon_code`),
ADD KEY `discount_type` (`discount_type`);
--
-- Indexes for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
ADD PRIMARY KEY (`coupon_applied_id`);
--
-- Indexes for table `cron_cards`
--
ALTER TABLE `cron_cards`
ADD PRIMARY KEY (`cron_card_id`);
--
-- Indexes for table `cron_payments`
--
ALTER TABLE `cron_payments`
ADD PRIMARY KEY (`cron_payment_id`);
--
-- Indexes for table `cron_payment_logs`
--
ALTER TABLE `cron_payment_logs`
ADD PRIMARY KEY (`cron_payment_log_id`);
--
-- Indexes for table `cron_stop`
--
ALTER TABLE `cron_stop`
ADD PRIMARY KEY (`cron_stop_id`);
--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
ADD PRIMARY KEY (`currency_id`);
--
-- Indexes for table `currency_symbols`
--
ALTER TABLE `currency_symbols`
ADD PRIMARY KEY (`symbol_id`);
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`customer_id`),
ADD KEY `customer_status` (`customer_status`),
ADD KEY `customer_email` (`customer_email`),
ADD KEY `customer_phone` (`customer_phone`),
ADD KEY `customer_firstname` (`customer_firstname`),
ADD KEY `customer_id` (`customer_id`);
--
-- Indexes for table `customer_orders`
--
ALTER TABLE `customer_orders`
ADD PRIMARY KEY (`customer_order_id`),
ADD KEY `customer_order_id` (`customer_order_id`),
ADD KEY `customers_id` (`customers_id`),
ADD KEY `customer_number` (`customer_number`),
ADD KEY `coupons_code` (`coupons_code`);
--
-- Indexes for table `customer_order_details`
--
ALTER TABLE `customer_order_details`
ADD PRIMARY KEY (`customer_order_detail_id`),
ADD KEY `customer_orders_id` (`customer_orders_id`),
ADD KEY `order_number` (`order_number`),
ADD KEY `products_id` (`products_id`);
--
-- Indexes for table `email_logs`
--
ALTER TABLE `email_logs`
ADD PRIMARY KEY (`email_log_id`);
--
-- Indexes for table `email_settings`
--
ALTER TABLE `email_settings`
ADD PRIMARY KEY (`email_settings_id`);
--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
ADD PRIMARY KEY (`email_template_id`),
ADD KEY `user_id` (`group_id`),
ADD KEY `template_name` (`template_name`);
--
-- Indexes for table `email_template_type`
--
ALTER TABLE `email_template_type`
ADD PRIMARY KEY (`email_template_type_id`);
--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
ADD PRIMARY KEY (`faq_id`);
--
-- Indexes for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
ADD PRIMARY KEY (`footer_tab_id`);
--
-- Indexes for table `group_pages`
--
ALTER TABLE `group_pages`
ADD PRIMARY KEY (`group_page_id`);
--
-- Indexes for table `headings_info`
--
ALTER TABLE `headings_info`
ADD PRIMARY KEY (`heading_info_id`);
--
-- Indexes for table `logo_images`
--
ALTER TABLE `logo_images`
ADD PRIMARY KEY (`logo_image_id`);
--
-- Indexes for table `menu_positions`
--
ALTER TABLE `menu_positions`
ADD PRIMARY KEY (`menu_position_id`),
ADD KEY `menu_status` (`menu_status`),
ADD KEY `menu_type` (`menu_type`),
ADD KEY `positioning` (`positioning`),
ADD KEY `groups_id` (`groups_id`);
--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`page_id`),
ADD KEY `page_name` (`page_name`),
ADD KEY `page_status` (`page_status`);
--
-- Indexes for table `payment_details`
--
ALTER TABLE `payment_details`
ADD PRIMARY KEY (`payment_detail_id`),
ADD KEY `payment_status` (`payment_status`),
ADD KEY `payment_mode` (`payment_mode`),
ADD KEY `customer_orders_id` (`customer_orders_id`),
ADD KEY `customers_id` (`customers_id`);
--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
ADD PRIMARY KEY (`plan_logs_id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`product_id`),
ADD KEY `product_name` (`product_name`),
ADD KEY `product_price` (`mrp_price`),
ADD KEY `brands_id` (`brands_id`),
ADD KEY `sale_price` (`sale_price`),
ADD KEY `is_featured` (`is_featured`),
ADD KEY `product_status` (`product_status`),
ADD KEY `product_slug` (`product_slug`);
--
-- Indexes for table `product_colors`
--
ALTER TABLE `product_colors`
ADD PRIMARY KEY (`product_colors_id`);
--
-- Indexes for table `product_csv_files`
--
ALTER TABLE `product_csv_files`
ADD PRIMARY KEY (`csv_file_id`);
--
-- Indexes for table `product_dimensions`
--
ALTER TABLE `product_dimensions`
ADD PRIMARY KEY (`product_dimensions_id`);
--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
ADD PRIMARY KEY (`product_image_id`);
--
-- Indexes for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
ADD PRIMARY KEY (`product_sub_category_id`),
ADD KEY `products_id` (`products_id`),
ADD KEY `subcategory_id` (`sub_categories_id`);
--
-- Indexes for table `refund_payments`
--
ALTER TABLE `refund_payments`
ADD PRIMARY KEY (`refund_payment_id`);
--
-- Indexes for table `related_products`
--
ALTER TABLE `related_products`
ADD PRIMARY KEY (`related_product_id`);
--
-- Indexes for table `return_cancel_orders`
--
ALTER TABLE `return_cancel_orders`
ADD PRIMARY KEY (`return_cancel_order_id`);
--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
ADD PRIMARY KEY (`review_id`);
--
-- Indexes for table `save_cards`
--
ALTER TABLE `save_cards`
ADD PRIMARY KEY (`save_card_id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`settings_id`),
ADD KEY `users_id` (`group_id`),
ADD KEY `facebook_id` (`facebook_id`),
ADD KEY `site_name` (`site_name`),
ADD KEY `email` (`email`);
--
-- Indexes for table `status`
--
ALTER TABLE `status`
ADD PRIMARY KEY (`status_id`);
--
-- Indexes for table `status_logs`
--
ALTER TABLE `status_logs`
ADD PRIMARY KEY (`status_log_id`);
--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
ADD PRIMARY KEY (`subscriber_id`);
--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
ADD PRIMARY KEY (`sub_category_id`),
ADD KEY `categories_id` (`categories_id`);
--
-- Indexes for table `sub_menu`
--
ALTER TABLE `sub_menu`
ADD PRIMARY KEY (`sub_menu_id`);
--
-- Indexes for table `templates`
--
ALTER TABLE `templates`
ADD PRIMARY KEY (`template_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
--
-- Indexes for table `user_credentials`
--
ALTER TABLE `user_credentials`
ADD PRIMARY KEY (`user_credential_id`),
ADD UNIQUE KEY `users_id` (`group_id`) USING BTREE;
--
-- Indexes for table `versions`
--
ALTER TABLE `versions`
ADD PRIMARY KEY (`version_id`),
ADD KEY `version_no` (`version_no`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `address_book`
--
ALTER TABLE `address_book`
MODIFY `address_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `add_register_user_payment`
--
ALTER TABLE `add_register_user_payment`
MODIFY `register_payment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `banner_images`
--
ALTER TABLE `banner_images`
MODIFY `banner_image_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `banner_text`
--
ALTER TABLE `banner_text`
MODIFY `banner_text` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
MODIFY `brand_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
--
-- AUTO_INCREMENT for table `cart_added`
--
ALTER TABLE `cart_added`
MODIFY `cart_added_id` bigint(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT for table `color_settings`
--
ALTER TABLE `color_settings`
MODIFY `color_settings_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_info`
--
ALTER TABLE `contact_info`
MODIFY `contact_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
MODIFY `country_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=227;
--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
MODIFY `coupon_applied_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_cards`
--
ALTER TABLE `cron_cards`
MODIFY `cron_card_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_payments`
--
ALTER TABLE `cron_payments`
MODIFY `cron_payment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_payment_logs`
--
ALTER TABLE `cron_payment_logs`
MODIFY `cron_payment_log_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_stop`
--
ALTER TABLE `cron_stop`
MODIFY `cron_stop_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `currency_symbols`
--
ALTER TABLE `currency_symbols`
MODIFY `symbol_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customer_orders`
--
ALTER TABLE `customer_orders`
MODIFY `customer_order_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customer_order_details`
--
ALTER TABLE `customer_order_details`
MODIFY `customer_order_detail_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_logs`
--
ALTER TABLE `email_logs`
MODIFY `email_log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_settings`
--
ALTER TABLE `email_settings`
MODIFY `email_settings_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `email_template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `email_template_type`
--
ALTER TABLE `email_template_type`
MODIFY `email_template_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
MODIFY `footer_tab_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `group_pages`
--
ALTER TABLE `group_pages`
MODIFY `group_page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `headings_info`
--
ALTER TABLE `headings_info`
MODIFY `heading_info_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `logo_images`
--
ALTER TABLE `logo_images`
MODIFY `logo_image_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `menu_positions`
--
ALTER TABLE `menu_positions`
MODIFY `menu_position_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `payment_details`
--
ALTER TABLE `payment_details`
MODIFY `payment_detail_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
MODIFY `plan_logs_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT for table `product_colors`
--
ALTER TABLE `product_colors`
MODIFY `product_colors_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `product_csv_files`
--
ALTER TABLE `product_csv_files`
MODIFY `csv_file_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `product_dimensions`
--
ALTER TABLE `product_dimensions`
MODIFY `product_dimensions_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
MODIFY `product_image_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=259;
--
-- AUTO_INCREMENT for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
MODIFY `product_sub_category_id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;
--
-- 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=7;
--
-- 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 for table `reviews`
--
ALTER TABLE `reviews`
MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `save_cards`
--
ALTER TABLE `save_cards`
MODIFY `save_card_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `status_logs`
--
ALTER TABLE `status_logs`
MODIFY `status_log_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT for table `sub_menu`
--
ALTER TABLE `sub_menu`
MODIFY `sub_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_credentials`
--
ALTER TABLE `user_credentials`
MODIFY `user_credential_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `versions`
--
ALTER TABLE `versions`
MODIFY `version_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
COMMIT;