-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 26, 2018 at 11:27 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: `furniture`
--
-- --------------------------------------------------------
--
-- Table structure for table `address_book`
--
CREATE TABLE `address_book` (
`address_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`address_address1` varchar(255) NOT NULL,
`address_address2` varchar(255) DEFAULT NULL,
`address_city` varchar(255) NOT NULL,
`address_state` varchar(255) NOT NULL,
`address_postal_code` varchar(10) NOT NULL,
`address_country` tinyint(1) NOT NULL,
`is_default` tinyint(1) DEFAULT '0' COMMENT 'for default address',
`address_created_on` datetime NOT NULL,
`address_modified_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `add_register_user_payment`
--
CREATE TABLE `add_register_user_payment` (
`register_payment_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`payment_detail` text NOT NULL,
`auth_pay_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`auth_profile_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`auth_shipping_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`created` datetime NOT NULL,
`stripe_customer_token` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`stripe_customer_profile_id` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`card_number` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`card_expiry` varchar(256) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `banner_images`
--
CREATE TABLE `banner_images` (
`banner_image_id` int(10) NOT NULL,
`group_id` int(11) NOT NULL,
`banner_type` tinyint(1) NOT NULL DEFAULT '1',
`banner_status` tinyint(1) NOT NULL COMMENT '1 for user defined 0 for default',
`banner_image_original` varchar(255) DEFAULT NULL,
`banner_mask_name` varchar(255) DEFAULT NULL,
`image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `banner_text`
--
CREATE TABLE `banner_text` (
`banner_text` int(11) NOT NULL,
`groups_id` tinyint(1) NOT NULL,
`main` varchar(255) NOT NULL,
`sub` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL,
`banner_text_created` datetime NOT NULL,
`banner_text_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `brands`
--
CREATE TABLE `brands` (
`brand_id` int(20) NOT NULL,
`brand_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`brand_status` tinyint(1) NOT NULL COMMENT '0 for deactivate , 1 for activate',
`brand_created` datetime NOT NULL,
`brand_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `brands`
--
INSERT INTO `brands` (`brand_id`, `brand_name`, `brand_original_image`, `brand_mask_name`, `brand_status`, `brand_created`, `brand_modified`) VALUES
(61, 'General', 'brand.png', '8c4d3a946a1fcde2ded7e17651fd0ed7.jpg', 1, '2017-10-25 12:38:33', NULL),
(62, 'Greenwich Sofa', 'FNSF51AGCM1_-_main_1.jpg', '88c827dbc0cf230baa93494183059b55.jpg', 0, '2018-04-20 15:58:47', '2018-04-20 15:55:51'),
(65, 'Universal Furniture', 'UNI-Zepher-Sitebanner.jpg', '40495f9ce8b78c08cbc133e6eac52ee2.jpg', 1, '2018-04-20 15:42:56', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cart_added`
--
CREATE TABLE `cart_added` (
`cart_added_id` bigint(11) NOT NULL,
`products_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`cart_added_product_quantity` int(10) NOT NULL,
`cart_added_created` datetime NOT NULL,
`cart_added_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`category_id` int(11) NOT NULL,
`category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_original_image` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_mask_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`category_status` tinyint(1) NOT NULL,
`category_created` datetime NOT NULL,
`category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`category_id`, `category_name`, `category_slug`, `category_original_image`, `category_mask_name`, `category_status`, `category_created`, `category_modified`) VALUES
(24, 'General', 'general', 'images.png', '59b514174bffe4ae402b3d63aad79fe0.jpg', 1, '2017-10-25 13:26:00', NULL),
(29, 'Sofa', 'Sofa', 'Apollo_Modern_Convertible_Futon_Sofabed_Sleeper_Bark_lrg_1.jpg', 'ed15bce4ed61fbd85e2c029ad3a1be45.jpg', 1, '2018-04-20 15:02:11', '2018-04-20 16:02:14'),
(32, 'Storage', 'Storage', '25-Pair+Shoe+Storage+Cabinet.jpg', '400e062e11e60b89c8940a949e8eb715.jpg', 1, '2018-04-20 12:16:13', '2018-04-20 16:03:27'),
(35, 'Study', 'study', 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_01.jpg', '5c3be349490004f82b7325df8a02b3a5.jpg', 1, '2018-04-20 16:24:40', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `color_settings`
--
CREATE TABLE `color_settings` (
`color_settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`color_code` varchar(255) NOT NULL,
`color_settings_created` datetime NOT NULL,
`color_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `contact_info`
--
CREATE TABLE `contact_info` (
`contact_info_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`address` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`state` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`postal_code` varchar(10) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`contact_info_created` datetime NOT NULL,
`contact_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `contact_info`
--
INSERT INTO `contact_info` (`contact_info_id`, `group_id`, `address`, `city`, `state`, `country`, `postal_code`, `email`, `phone`, `contact_info_created`, `contact_info_modified`) VALUES
(1, 1, '3719 Jadewood Farms', 'Passaic', 'New Jersey', 'U.S.A', '07055', 'email@email.com', '97336526', '2018-04-16 17:52:08', '2018-04-20 14:25:46');
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`country_id` int(10) NOT NULL,
`title` varchar(100) NOT NULL,
`iso_code` varchar(20) NOT NULL,
`country_code` varchar(20) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '"0"=>disable, "1"=>enable'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`country_id`, `title`, `iso_code`, `country_code`, `status`) VALUES
(1, 'United States', 'US', '+1', 1),
(2, 'Australia', 'AU', '+61', 1),
(3, 'Austria', 'AT', '+43 720', 1),
(4, 'Belgium', 'BE', '+32', 1),
(5, 'Canada', 'CA', '+1', 1),
(6, 'Czech Republic', 'CZ', '+420', 1),
(7, 'Denmark', 'DK', '+45', 1),
(8, 'Finland', 'FI', '+358', 1),
(9, 'France', 'FR', '+33 9', 1),
(10, 'Greece', 'GR', '+30', 1),
(11, 'Hong Kong', 'HK', '+852', 1),
(12, 'Ireland', 'IE', '+353 76', 1),
(13, 'Israel', 'IL', '+972', 1),
(14, 'Italy', 'IT', '+39', 1),
(15, 'Japan', 'JP', '+81', 1),
(16, 'Netherlands', 'NL', '+31 85', 1),
(17, 'New Zealand', 'NZ', '+64', 1),
(18, 'Poland', 'PL', '+48', 1),
(19, 'Portugal', 'PT', '+351', 1),
(20, 'Romania', 'RO', '+40', 1),
(21, 'Spain', 'ES', '+34', 1),
(22, 'Sweden', 'SE', '+46', 1),
(23, 'Switzerland', 'CH', '+41', 1),
(24, 'United Kingdom', 'GB', '+44', 1),
(25, 'India', 'IN', '+91', 1),
(26, 'Algeria', 'DZ', '+213', 1),
(27, 'Angola', 'AO', '+244', 1),
(28, 'Benin', 'BJ', '+229', 1),
(29, 'Botswana', 'BW', '+267', 1),
(30, 'Burkina Faso', 'BF', '+226', 1),
(31, 'Burundi', 'BI', '+257', 1),
(32, 'Cameroon', 'CM', '+237', 1),
(33, 'Cape Verde', 'CV', '+238', 1),
(34, 'Central African Republic', 'CF', '+236', 1),
(35, 'Chad', 'TD', '+235', 1),
(36, 'Comoros', 'KM', '+269', 1),
(37, 'Congo', 'CG', '+242', 1),
(38, 'Congo, The Democratic Republic of the', 'CD', '+243', 1),
(39, 'Cote D\'Ivoire', 'CI', '+225', 1),
(40, 'Djibouti', 'DJ', '+253', 1),
(41, 'Egypt', 'EG', '+20', 1),
(42, 'Equatorial Guinea', 'GQ', '+240', 1),
(43, 'Eritrea', 'ER', '+291', 1),
(44, 'Ethiopia', 'ET', '+251', 1),
(45, 'Gabon', 'GA', '+241', 1),
(46, 'Gambia', 'GM', '+220', 1),
(47, 'Ghana', 'GH', '+233', 1),
(48, 'Guinea', 'GN', '+224', 1),
(49, 'Guinea-Bissau', 'GW', '+245', 1),
(50, 'Kenya', 'KE', '+254', 1),
(51, 'Lesotho', 'LS', '+266', 1),
(52, 'Liberia', 'LR', '+231', 1),
(53, 'Libya', 'LY', '+218', 1),
(54, 'Madagascar', 'MG', '+261', 1),
(55, 'Malawi', 'MW', '+265', 1),
(56, 'Mali', 'ML', '+223', 1),
(57, 'Mauritania', 'MR', '+222', 1),
(58, 'Mauritius', 'MU', '+230', 1),
(59, 'Mayotte', 'YT', '+269', 1),
(60, 'Morocco', 'MA', '+212', 1),
(61, 'Mozambique', 'MZ', '+258', 1),
(62, 'Namibia', 'NA', '+264', 1),
(63, 'Niger', 'NE', '+227', 1),
(64, 'Nigeria', 'NG', '+234', 1),
(65, 'Rwanda', 'RW', '+250', 1),
(66, 'Saint Helena', 'SH', '+290', 1),
(67, 'Sao Tome and Principe', 'ST', '+239', 1),
(68, 'Senegal', 'SN', '+221', 1),
(69, 'Seychelles', 'SC', '+248', 1),
(70, 'Sierra Leone', 'SL', '+232', 1),
(71, 'Somalia', 'SO', '+252', 1),
(72, 'South Africa', 'ZA', '+27', 1),
(73, 'Sudan', 'SD', '+249', 1),
(74, 'Swaziland', 'SZ', '+268', 1),
(75, 'Tanzania, United Republic of', 'TZ', '+255', 1),
(76, 'Togo', 'TG', '+228', 1),
(77, 'Tunisia', 'TN', '+216', 1),
(78, 'Uganda', 'UG', '+256', 1),
(79, 'Zambia', 'ZM', '+260', 1),
(80, 'Zimbabwe', 'ZW', '+263', 1),
(81, 'Antarctica', 'AQ', '+672', 1),
(82, 'Afghanistan', 'AF', '+93', 1),
(83, 'Bahrain', 'BH', '+973', 1),
(84, 'Bangladesh', 'BD', '+880', 1),
(85, 'Bhutan', 'BT', '+975', 1),
(86, 'Brunei Darussalam', 'BN', '+673', 1),
(87, 'Cambodia', 'KH', '+855', 1),
(88, 'China', 'CN', '+86', 1),
(89, 'India', 'IN', '+91', 1),
(90, 'Indonesia', 'ID', '+62', 1),
(91, 'Iran, Islamic Republic of', 'IR', '+98', 1),
(92, 'Iraq', 'IQ', '+964', 1),
(93, 'Jordan', 'JO', '+962', 1),
(94, 'Kazakhstan', 'KZ', '+7', 1),
(95, 'Korea, Democratic People\'s Republic of', 'KP', '+850', 1),
(96, 'Korea, Republic of', 'KR', '+82', 1),
(97, 'Kuwait', 'KW', '+965', 1),
(98, 'Kyrgyzstan', 'KG', '+996', 1),
(99, 'Lao People\'s Democratic Republic', 'LA', '+856', 1),
(100, 'Lebanon', 'LB', '+961', 1),
(101, 'Macau', 'MO', '+853', 1),
(102, 'Malaysia', 'MY', '+60', 1),
(103, 'Maldives', 'MV', '+960', 1),
(104, 'Mongolia', 'MN', '+976', 1),
(105, 'Myanmar', 'MM', '+95', 1),
(106, 'Nepal', 'NP', '+977', 1),
(107, 'Oman', 'OM', '+968', 1),
(108, 'Pakistan', 'PK', '+92', 1),
(109, 'Philippines', 'PH', '+63', 1),
(110, 'Qatar', 'QA', '974', 1),
(111, 'Russian Federation', 'RU', '+7', 1),
(112, 'Saudi Arabia', 'SA', '+966', 1),
(113, 'Singapore', 'SG', '+65', 1),
(114, 'Sri Lanka', 'LK', '94', 1),
(115, 'Syrian Arab Republic', 'SY', '+963', 1),
(116, 'Taiwan', 'TW', '+886', 1),
(117, 'Tajikistan', 'TJ', '+992', 1),
(118, 'Thailand', 'TH', '+66', 1),
(119, 'Turkey', 'TR', '+90', 1),
(120, 'Turkmenistan', 'TM', '+993', 1),
(121, 'United Arab Emirates', 'AE', '+971', 1),
(122, 'Uzbekistan', 'UZ', '+998', 1),
(123, 'Vietnam', 'VN', '+84', 1),
(124, 'Yemen', 'YE', '+967', 1),
(125, 'Cook Islands', 'CK', '+682', 1),
(126, 'Fiji', 'FJ', '+679', 1),
(127, 'Guam', 'GU', '+1 671', 1),
(128, 'Kiribati', 'KI', '+686', 1),
(129, 'Marshall Islands', 'MH', '+692', 1),
(130, 'Micronesia, Federated States of', 'FM', '+691', 1),
(131, 'Nauru', 'NR', '+674', 1),
(132, 'New Caledonia', 'NC', '+687', 1),
(133, 'Niue', 'NU', '+683', 1),
(134, 'Norfolk Island', 'NF', '+672', 1),
(135, 'Northern Mariana Islands', 'MP', '+670', 1),
(136, 'Palau', 'PW', '+680', 1),
(137, 'Papua New Guinea', 'PG', '+675', 1),
(138, 'Reunion', 'RE', '+262', 1),
(139, 'Samoa', 'WS', '+684', 1),
(140, 'Solomon Islands', 'SB', '+677', 1),
(141, 'Tokelau', 'TK', '+690', 1),
(142, 'Tonga', 'TO', '+676', 1),
(143, 'Tuvalu', 'TV', '+688', 1),
(144, 'Vanuatu', 'VU', '+678', 1),
(145, 'Wallis and Futuna', 'WF', '+681', 1),
(146, 'Albania', 'AL', '+355', 1),
(147, 'Andorra', 'AD', '+376', 1),
(148, 'Armenia', 'AM', '+374', 1),
(149, 'Azerbaijan', 'AZ', '+994', 1),
(150, 'Belarus', 'BY', '+375', 1),
(151, 'Bosnia and Herzegovina', 'BA', '+387', 1),
(152, 'Bulgaria', 'BG', '+359', 1),
(153, 'Croatia', 'HR', '+385', 1),
(154, 'Cyprus', 'CY', '+357', 1),
(155, 'Estonia', 'EE', '+372', 1),
(156, 'Faroe Islands', 'FO', '+298', 1),
(157, 'Georgia', 'GE', '+995', 1),
(158, 'Germany', 'DE', '+49', 1),
(159, 'Gibraltar', 'GI', '+350', 1),
(160, 'Hungary', 'HU', '+36', 1),
(161, 'Iceland', 'IS', '+354', 1),
(162, 'Latvia', 'LV', '+371', 1),
(163, 'Liechtenstein', 'LI', '+423', 1),
(164, 'Lithuania', 'LT', '+370', 1),
(165, 'Luxembourg', 'LU', '+352', 1),
(166, 'Macedonia', 'MK', '+389', 1),
(167, 'Malta', 'MT', '+356', 1),
(168, 'Moldova, Republic of', 'MD', '+373', 1),
(169, 'Monaco', 'MC', '+377', 1),
(170, 'Montenegro', 'ME', '+382', 1),
(171, 'Norway', 'NO', '+47', 1),
(172, 'San Marino', 'SM', '+378', 1),
(173, 'Serbia', 'RS', '+381', 1),
(174, 'Slovakia', 'SK', '+421', 1),
(175, 'Slovenia', 'SI', '+386', 1),
(176, 'Ukraine', 'UA', '+380', 1),
(177, 'Vatican City', 'VA', '+39', 1),
(178, 'Antigua and Barbuda', 'AG', '+1 268', 1),
(179, 'American Samoa', 'AS', '+684', 1),
(180, 'Anguilla', 'AI', '+1 264', 1),
(181, 'Aruba', 'AW', '+297', 1),
(182, 'Bahamas', 'BS', '+1 242', 1),
(183, 'Barbados', 'BB', '+1 246', 1),
(184, 'Belize', 'BZ', '+501', 1),
(185, 'Bermuda', 'BM', '+1 441', 1),
(186, 'Costa Rica', 'CR', '+506', 1),
(187, 'Cayman Islands', 'KY', '+1 345', 1),
(188, 'Cuba', 'CU', '+53', 1),
(189, 'Dominica', 'DM', '+1 767', 1),
(190, 'Dominican Republic', 'DO', '+809', 1),
(191, 'El Salvador', 'SV', '+503', 1),
(192, 'Greenland', 'GL', '+299', 1),
(193, 'Grenada', 'GD', '+1 473', 1),
(194, 'Guatemala', 'GT', '+502', 1),
(195, 'Guadeloupe', 'GP', '+590', 1),
(196, 'Haiti', 'HT', '+509', 1),
(197, 'Honduras', 'HN', '+504', 1),
(198, 'Jamaica', 'JM', '+1 876', 1),
(199, 'Martinique', 'MQ', '+596', 1),
(200, 'Mexico', 'MX', '+52', 1),
(201, 'Montserrat', 'MS', '+1 664', 1),
(202, 'Nicaragua', 'NI', '+505', 1),
(203, 'Panama', 'PA', '+507', 1),
(204, 'Puerto Rico', 'PR', '+1 787', 1),
(205, 'Saint Kitts and Nevis', 'KN', '+1 869', 1),
(206, 'Saint Lucia', 'LC', '+1 758', 1),
(207, 'Saint Pierre and Miquelon', 'PM', '508', 1),
(208, 'Saint Vincent and the Grenadines', 'VC', '+1 784', 1),
(209, 'Trinidad and Tobago', 'TT', '+1 868', 1),
(210, 'Turks and Caicos Islands', 'TC', '+1 649', 1),
(211, 'Virgin Islands, British', 'VG', '+1 284', 1),
(212, 'Virgin Islands, U.S.', 'VI', '+1 340', 1),
(213, 'Argentina', 'AR', '+54', 1),
(214, 'Bolivia', 'BO', '+591', 1),
(215, 'Brazil', 'BR', '+55', 1),
(216, 'Chile', 'CL', '+56', 1),
(217, 'Colombia', 'CO', '+57', 1),
(218, 'Ecuador', 'EC', '+593', 1),
(219, 'Falkland Islands (Malvinas)', 'FK', '+500', 1),
(220, 'French Guiana', 'GF', '+594', 1),
(221, 'Guyana', 'GY', '+592', 1),
(222, 'Paraguay', 'PY', '+595', 1),
(223, 'Peru', 'PE', '+51', 1),
(224, 'Suriname', 'SR', '+597', 1),
(225, 'Uruguay', 'UY', '+598', 1),
(226, 'Venezuela', 'VE', '+58', 1);
-- --------------------------------------------------------
--
-- Table structure for table `coupons`
--
CREATE TABLE `coupons` (
`coupon_id` int(11) NOT NULL,
`coupon_code` varchar(30) NOT NULL,
`no_of_times` tinyint(4) NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`discount_type` varchar(10) NOT NULL COMMENT '1 for flat;2 for percentage',
`amount` decimal(10,2) NOT NULL,
`coupon_status` tinyint(4) NOT NULL COMMENT '1 for active;0 for inactive',
`coupon_created` datetime NOT NULL,
`coupon_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `coupon_applied`
--
CREATE TABLE `coupon_applied` (
`coupon_applied_id` int(11) NOT NULL,
`coupons_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`to_be_paid` decimal(10,2) NOT NULL,
`coupon_applied_created` datetime NOT NULL,
`coupon_applied_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `cron_cards`
--
CREATE TABLE `cron_cards` (
`cron_card_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`mode` tinyint(1) NOT NULL,
`order_num` text NOT NULL,
`card_num` varchar(256) DEFAULT NULL,
`card_month` int(11) DEFAULT NULL,
`card_year` int(11) DEFAULT NULL,
`card_address` varchar(256) DEFAULT NULL,
`card_city` varchar(256) DEFAULT NULL,
`card_state` varchar(256) DEFAULT NULL,
`card_pincode` varchar(256) DEFAULT NULL,
`card_country` tinyint(10) DEFAULT NULL,
`card_response` text NOT NULL,
`card_status` tinyint(1) NOT NULL,
`card_auth_profile_id` varchar(256) DEFAULT NULL,
`card_auth_pay_profile_id` varchar(256) DEFAULT NULL,
`card_auth_shipping_id` varchar(256) DEFAULT NULL,
`card_stripe_customer_token` varchar(256) DEFAULT NULL,
`card_stripe_customer_id` varchar(256) DEFAULT NULL,
`cron_card_created` datetime NOT NULL,
`cron_card_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cron_payments`
--
CREATE TABLE `cron_payments` (
`cron_payment_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`product_order_num` text NOT NULL COMMENT 'customer_order details id',
`price` decimal(10,2) NOT NULL,
`duration` tinyint(1) NOT NULL COMMENT '0 for week , 1 for month , 2 for year',
`infinite` tinyint(1) NOT NULL COMMENT '0 for no , 1 for yes',
`excecution_time` tinyint(1) NOT NULL COMMENT 'no of times cron to be excecuted',
`new_cron_date` date NOT NULL COMMENT 'when cron will run again',
`cron_created` datetime NOT NULL,
`cron_status` tinyint(1) NOT NULL COMMENT '1 for still excecute , 0 for over '
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cron_payment_logs`
--
CREATE TABLE `cron_payment_logs` (
`cron_payment_log_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`cron_id` int(11) NOT NULL,
`product_order_number` text CHARACTER SET utf8 NOT NULL,
`payment_response` text CHARACTER SET utf8 NOT NULL,
`status` tinyint(1) NOT NULL,
`cron_payment_log_created` datetime NOT NULL,
`pay_mode` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `cron_stop`
--
CREATE TABLE `cron_stop` (
`cron_stop_id` int(11) NOT NULL,
`cron_order_num` text NOT NULL,
`cron_status` tinyint(1) NOT NULL,
`stop_reason` text NOT NULL,
`customers_id` int(11) NOT NULL,
`cron_stop_created` datetime NOT NULL,
`cron_stop_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `currencies`
--
CREATE TABLE `currencies` (
`currency_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`currency_used` varchar(255) CHARACTER SET utf8 NOT NULL,
`use_conversion` tinyint(1) NOT NULL DEFAULT '0',
`USD` decimal(10,2) DEFAULT NULL,
`GBP` decimal(10,2) DEFAULT NULL,
`EUR` decimal(10,2) DEFAULT NULL,
`currency_created` datetime NOT NULL,
`currency_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `currencies`
--
INSERT INTO `currencies` (`currency_id`, `group_id`, `currency_used`, `use_conversion`, `USD`, `GBP`, `EUR`, `currency_created`, `currency_modified`) VALUES
(1, 1, 'USD', 0, NULL, NULL, NULL, '2018-04-10 17:43:00', '2018-04-11 15:16:23');
-- --------------------------------------------------------
--
-- Table structure for table `currency_symbols`
--
CREATE TABLE `currency_symbols` (
`symbol_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`currency_name` varchar(255) NOT NULL,
`symbol` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `currency_symbols`
--
INSERT INTO `currency_symbols` (`symbol_id`, `group_id`, `currency_name`, `symbol`) VALUES
(5, 1, 'USD', '$'),
(6, 1, 'GBP', '£'),
(7, 1, 'EUR', '€');
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`customer_id` int(10) NOT NULL,
`customer_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
`customer_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
`customer_email` varchar(100) CHARACTER SET utf8 NOT NULL,
`customer_phone` varchar(15) CHARACTER SET utf8 NOT NULL,
`customer_password` varchar(200) CHARACTER SET utf8 NOT NULL,
`password_change_request` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 for yes , 0 for no ',
`customer_status` tinyint(1) NOT NULL COMMENT '1for active;0 for deactive',
`customer_register_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
`customer_created` datetime NOT NULL,
`customer_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `customer_orders`
--
CREATE TABLE `customer_orders` (
`customer_order_id` int(11) NOT NULL,
`total_amount` float(10,2) NOT NULL,
`coupons_code` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
`customers_id` int(11) NOT NULL,
`customer_order_created` datetime NOT NULL,
`customer_number` varchar(256) CHARACTER SET utf8 NOT NULL,
`shipment_id` int(11) NOT NULL,
`orders_status` tinyint(4) NOT NULL COMMENT '1 for pending , 2 for procssed , 3 for shipped , 4 for delivered',
`discount` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `customer_order_details`
--
CREATE TABLE `customer_order_details` (
`customer_order_detail_id` int(11) NOT NULL,
`customer_orders_id` int(11) NOT NULL,
`products_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`price` float(10,2) NOT NULL,
`order_mrp_price` decimal(10,2) NOT NULL,
`order_shipping` decimal(10,2) NOT NULL DEFAULT '0.00',
`customer_order_details_created` datetime NOT NULL,
`order_number` varchar(256) CHARACTER SET utf8 NOT NULL,
`order_status` tinyint(1) NOT NULL COMMENT '1 for pending , 2 for processed , 3 for shipped , 4 for delivered , 5 for returned'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `email_logs`
--
CREATE TABLE `email_logs` (
`email_log_id` bigint(20) NOT NULL,
`email_to` varchar(256) CHARACTER SET utf8 NOT NULL,
`email_to_user_id` int(11) NOT NULL,
`email_log_subject` varchar(255) CHARACTER SET utf8 NOT NULL,
`email_body` text CHARACTER SET utf8 NOT NULL,
`email_message_id` varchar(500) CHARACTER SET utf8 NOT NULL,
`email_request_id` varchar(500) CHARACTER SET utf8 NOT NULL,
`email_status` tinyint(1) NOT NULL,
`email_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `email_settings`
--
CREATE TABLE `email_settings` (
`email_settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`outgoing_server_name` varchar(255) DEFAULT NULL,
`smtp_port_no` int(2) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`amazon_email` varchar(255) DEFAULT NULL,
`access_key` varchar(255) DEFAULT NULL,
`secret_access_key` varchar(255) DEFAULT NULL,
`method` tinyint(1) NOT NULL COMMENT '1 for default , 2 for smtp , 3 for amazon',
`email_settings_created` datetime NOT NULL,
`email_settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `email_templates`
--
CREATE TABLE `email_templates` (
`email_template_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`template_slug` varchar(255) NOT NULL,
`template_name` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`email_used_for` text NOT NULL,
`template_type_id` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '1 for active 0 for inactive',
`template_created` datetime NOT NULL,
`template_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 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');
-- --------------------------------------------------------
--
-- Table structure for table `footer_tabs`
--
CREATE TABLE `footer_tabs` (
`footer_tab_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`tab_1` varchar(255) NOT NULL,
`tab_2` varchar(255) NOT NULL,
`footer_tab_created` datetime NOT NULL,
`footer_tab_modified` datetime DEFAULT NULL,
`tab_3` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`group_id` int(11) NOT NULL,
`group_name` varchar(20) NOT NULL,
`group_status` tinyint(1) NOT NULL,
`group_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`group_id`, `group_name`, `group_status`, `group_created`) VALUES
(1, 'admin', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `group_pages`
--
CREATE TABLE `group_pages` (
`group_page_id` int(11) NOT NULL,
`group_page_name` varchar(30) NOT NULL,
`group_page_status` tinyint(1) NOT NULL COMMENT '0 for deactive;1 for active',
`group_pages_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `group_pages`
--
INSERT INTO `group_pages` (`group_page_id`, `group_page_name`, `group_page_status`, `group_pages_created`) VALUES
(1, 'Policy', 1, '2018-04-16 00:00:00'),
(2, 'Company', 1, '2018-04-16 05:06:17'),
(3, 'Our Businesss', 1, '2018-04-16 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `headings_info`
--
CREATE TABLE `headings_info` (
`heading_info_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`popular` varchar(255) NOT NULL,
`products` varchar(255) NOT NULL,
`product_image_original` varchar(255) NOT NULL,
`product_mask_name` varchar(255) NOT NULL,
`product_status` tinyint(1) NOT NULL,
`heading_info_created` datetime NOT NULL,
`heading_info_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `login_logs`
--
CREATE TABLE `login_logs` (
`users_id` int(10) NOT NULL,
`login_log_from` int(10) NOT NULL,
`login_log_mode` varchar(256) NOT NULL,
`login_log_ip_address` varchar(256) NOT NULL,
`login_log_user_agent` varchar(256) NOT NULL,
`login_log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `login_logs`
--
INSERT INTO `login_logs` (`users_id`, `login_log_from`, `login_log_mode`, `login_log_ip_address`, `login_log_user_agent`, `login_log_created`) VALUES
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-26 11:26:02'),
(1, 1, 'WEB', '192.168.0.112', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0', '2018-04-26 11:26:26');
-- --------------------------------------------------------
--
-- Table structure for table `logo_images`
--
CREATE TABLE `logo_images` (
`logo_image_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`logo_type` tinyint(1) DEFAULT NULL,
`logo_status` tinyint(1) DEFAULT NULL,
`logo_image_original` varchar(255) DEFAULT NULL,
`logo_mask_name` varchar(255) DEFAULT NULL,
`logo_image_created` datetime DEFAULT NULL,
`logo_modified` datetime DEFAULT NULL,
`favicon_image_original` varchar(255) DEFAULT NULL,
`favicon_mask_name` varchar(255) DEFAULT NULL,
`favicon_type` tinyint(1) DEFAULT NULL,
`favicon_status` tinyint(1) DEFAULT NULL,
`favicon_created` datetime DEFAULT NULL,
`favicon_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `logo_images`
--
INSERT INTO `logo_images` (`logo_image_id`, `group_id`, `logo_type`, `logo_status`, `logo_image_original`, `logo_mask_name`, `logo_image_created`, `logo_modified`, `favicon_image_original`, `favicon_mask_name`, `favicon_type`, `favicon_status`, `favicon_created`, `favicon_modified`) VALUES
(1, 1, 1, 0, 'Apps-Home-icon.png', '515531ee3c3ccaa210629813d658f088.png', NULL, '2018-04-23 14:41:23', NULL, NULL, 1, 0, '2018-04-23 14:41:23', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `menu_positions`
--
CREATE TABLE `menu_positions` (
`menu_position_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`positioning` tinyint(1) NOT NULL,
`menu_name` varchar(5) NOT NULL,
`menu_type` tinyint(4) NOT NULL COMMENT '1 home, 2 product,3 categories,4 brands,5 for blog , 6 contact',
`menu_status` tinyint(4) NOT NULL COMMENT '1 for show , 0 for hide',
`menu_position_created` datetime NOT NULL,
`menu_position_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `menu_positions`
--
INSERT INTO `menu_positions` (`menu_position_id`, `groups_id`, `positioning`, `menu_name`, `menu_type`, `menu_status`, `menu_position_created`, `menu_position_updated`) VALUES
(2, 1, 1, 'set_1', 1, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:17'),
(3, 1, 3, 'set_2', 2, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'),
(5, 1, 2, 'set_4', 4, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:17'),
(6, 1, 5, 'set_5', 5, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'),
(7, 1, 4, 'set_6', 6, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18');
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE `pages` (
`page_id` int(11) NOT NULL,
`group_pages_id` int(11) NOT NULL,
`page_type` tinyint(1) NOT NULL COMMENT '1 for policy , 2 for company , 3 for buissness',
`page_name` varchar(50) NOT NULL,
`page_slug` varchar(255) NOT NULL,
`page_body` text NOT NULL,
`page_metakeyword` varchar(1000) NOT NULL,
`page_metadescription` varchar(1000) NOT NULL,
`page_status` tinyint(1) NOT NULL DEFAULT '1',
`page_created` datetime NOT NULL,
`page_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `pages`
--
INSERT INTO `pages` (`page_id`, `group_pages_id`, `page_type`, `page_name`, `page_slug`, `page_body`, `page_metakeyword`, `page_metadescription`, `page_status`, `page_created`, `page_modified`) VALUES
(1, 1, 0, 'How It Works', 'how_it_works', '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.
', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 16:35:48', '2018-04-23 14:33:03'),
(6, 1, 1, 'Terms of Use', 'terms_of_use', '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, 'Austen Compact - Aurelio Study Sets', 'Technical Details
\r\n\r\n\r\n - Love your desk job! The Austen Compact Desk Desk and Aurelio Study Chair make the perfect pair for your study or home office
\r\n - The Austen Compact Desk and Aurelio Study Chair are also both available individually
\r\n - Please refer to the images for details of dimensions
\r\n - The product will be assembled and installed by the UL team
\r\n - For indoor use only
\r\n
', '239.00', '0.00', '0.00', 0, 0, 15, '', 1, '', 61, 35, 1, 'godrej-255-l-direct-cool-single-door-4-star-refrigerator-erica-blue-rd-edge-duo-255-pd-inv42', NULL, ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', ' Austen Compact - Aurelio Study Sets ', 1, '2018-04-20 11:53:42', '2018-04-23 14:34:15'),
(62, 'Finn Double Futon Sofa Cum Bed', '\r\n - So perfect for the lazy, Huck Finn would approve. Unfussy and amenable, the Finn double futon is an excuse to cancel plans and sleep in. Got company? Lock it in place as a sofa with one easy push. Broad slats keep your fingers from getting caught and prevent sagging. Vibrant colours and prints give it a jaunty feel that sits well in any room.
\r\n - Frame made from MDF
\r\n - Foam mattress with removable and washable zip cover
\r\n - Wheels attached for easy movement, plastic bush attached to protect the floor and the finish from scratches
\r\n - Rounded edges for safety
\r\n - Please refer to images for dimension details
\r\n - Any assembly or installation required will be done by the UL team at the time of delivery
\r\n - Indoor use only
\r\n
', '490.00', '0.00', '50.00', 0, 0, 15, '', 1, '', 61, 29, 1, 'samsung-394-l-3-star-frost-free-double-door-refrigerator-rt39m5538s8tl-elegant-inox-5-in-1-convertibleinverter-compressor', NULL, 'MacBook', 'MacBook', 'MacBook', 'MacBook', 1, '2018-04-20 12:27:06', '2018-04-20 16:22:49'),
(63, 'Redmi 4 (Black, 32 GB)', '\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, 'Murano Single-Door Display Cabinet (55-book capacity)', '\r\n - With clean classic lines, this elegant glass-front display cabinet will suit any room it stands in. Living rooms, hallways, and dining rooms the multi-purpose Murano will be at home anywhere.
\r\n - A great option for additional storage, use it to display travel souvenirs, curios, and photographs; china; or books. With three tall and sturdy wooden shelves, there’s room for everything you want to put on show.
\r\n - Made of high quality Sheesham wood. Glass panel cabinet door. MDF back panel.
\r\n - Refer to images for dimensions
\r\n - The UL Team will assemble the product at the time of delivery
\r\n - Indoor use only
\r\n
', '1900.00', '1800.00', '10.00', 0, 0, 15, '', 1, '', 65, 32, 1, 'hp-lp3065', NULL, ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', ' Murano Single-Door Display Cabinet (55-book capacity) ', 1, '2018-04-20 13:24:37', '2018-04-20 16:13:13'),
(65, 'Domenico Wardrobe', '\r\n - Thoughtful! One word that summarizes our wardrobes. Designed with complete understanding of your bedroom requirements, our wardrobes will surely offer the most comprehensive storage solution for your bedroom, all the while looking absolutely great!
\r\n - Textured finish - self design on the wardrobe to give it a premium look and feel
\r\n - Made from high quality particle board of 18 mm thickness.
\r\n - Soft closing hinges have been added to ensure smooth daily usage and long life
\r\n - Refer to the images for dimension details
\r\n - Any assembly or installation required will be done by the UL team at the time of delivery
\r\n - Indoor use only
\r\n
', '1500.00', '1000.00', '50.00', 0, 0, 45, '', 1, '', 65, 32, 1, 'apple-ipad-tablet-97-inch-32gb-wi-fi-space-grey', NULL, ' Domenico Wardrobe ', ' Domenico Wardrobe ', '', ' Domenico Wardrobe ', 1, '2018-04-20 14:32:40', '2018-04-20 16:08:32'),
(66, 'Charles Study Chair - 2 Axis Adjustable', '\r\n - Curves ahead! The Charles study chair is designed to mirror your spine, and the slight S shape supports your back comfortably, so you can work easy, all day (or night) long. Use it at your desk at work, at home, or use it in multiples in the conference room.
\r\n - The cushioned seat and back are comfortable and low maintenance
\r\n - Adjustable height, seat tilt and and free rolling castors make it practical as well as stylish
\r\n - Please refer to the images for details of dimensions
\r\n - The product will be assembled and installed by the UL team
\r\n - For indoor use only
\r\n
', '400.00', '0.00', '20.00', 0, 1, 15, '0', 1, '0', 61, 35, 1, 'charles-study-chair-2-axis-adjustable', 'https://www.youtube.com/watch?v=IO2M3cBj8-s', ' Charles Study Chair - 2 Axis Adjustable ', ' Charles Study Chair - 2 Axis Adjustable ', NULL, ' Charles Study Chair - 2 Axis Adjustable ', 1, '2018-04-20 16:45:13', '2018-04-20 17:04:26');
-- --------------------------------------------------------
--
-- Table structure for table `product_colors`
--
CREATE TABLE `product_colors` (
`product_colors_id` bigint(20) NOT NULL,
`products_id` int(10) NOT NULL,
`colors_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`product_color_created` datetime NOT NULL,
`product_color_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_colors`
--
INSERT INTO `product_colors` (`product_colors_id`, `products_id`, `colors_name`, `product_color_created`, `product_color_modified`) VALUES
(12, 64, 'Brown', '2018-04-20 16:14:40', NULL),
(13, 61, 'brown', '2018-04-20 16:37:53', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `product_csv_files`
--
CREATE TABLE `product_csv_files` (
`csv_file_id` int(11) NOT NULL,
`csv_file_original` varchar(255) NOT NULL,
`csv_mask_name` text NOT NULL,
`csv_file_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `product_dimensions`
--
CREATE TABLE `product_dimensions` (
`product_dimensions_id` int(10) NOT NULL,
`products_id` int(10) NOT NULL,
`height` decimal(10,2) DEFAULT NULL,
`width` decimal(10,2) DEFAULT NULL,
`weight` decimal(10,2) DEFAULT NULL,
`dimensions_created` datetime NOT NULL,
`dimensions_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_dimensions`
--
INSERT INTO `product_dimensions` (`product_dimensions_id`, `products_id`, `height`, `width`, `weight`, `dimensions_created`, `dimensions_modified`) VALUES
(1, 61, '0.00', '0.00', '0.00', '2018-04-20 12:02:18', '2018-04-20 16:37:53'),
(2, 62, '759.50', '939.80', '0.00', '2018-04-20 12:29:54', '2018-04-20 16:21:42'),
(3, 64, '0.00', '0.00', '0.00', '2018-04-20 13:31:21', '2018-04-20 16:14:41'),
(4, 65, '0.00', '0.00', '0.00', '2018-04-20 14:35:50', '2018-04-20 14:46:03');
-- --------------------------------------------------------
--
-- Table structure for table `product_images`
--
CREATE TABLE `product_images` (
`product_image_id` int(10) NOT NULL,
`products_id` int(10) NOT NULL,
`product_image_original` varchar(256) NOT NULL,
`product_mask_name` varchar(256) NOT NULL,
`image_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_images`
--
INSERT INTO `product_images` (`product_image_id`, `products_id`, `product_image_original`, `product_mask_name`, `image_created`) VALUES
(201, 59, '260c8d0454b4b03ca573ee4730c7fd1b.jpg', '072a068cf8d3c99e5f7954ad5296da31.jpg', '2018-04-13 13:44:57'),
(202, 58, 'f4ac2515ed82a343e7a45b6ebf986c3d.jpg', '1d9be41ad2ec862ea394d6cede7bfadb.jpg', '2018-04-13 13:45:13'),
(203, 57, 'eeea355f874be87000beae8e2db2def6.jpg', 'bb9f2f2318d1a762418727a8920b2653.jpg', '2018-04-13 13:45:30'),
(204, 60, 'c353498c74d7673ba202b9cb2334b1cb.jpg', 'f41b5f789314d10212b86f9d27d94e10.jpg', '2018-04-13 13:50:18'),
(225, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '5ad93adafdeb6ea72372d5bdbd3c3e6d.jpeg', '2018-04-20 13:00:14'),
(226, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '7a1a73874c84c9cee3ae466f24696507.jpeg', '2018-04-20 13:00:41'),
(227, 63, '201609280114371436xrnv.JPG', '3ed962da9f337453c81218490454fc82.JPG', '2018-04-20 13:00:56'),
(228, 63, '1F3455FF-B5FC-4553-7C1C-94C8E8325D0A.jpg', 'dcacce655ab825b4ba89646f70144011.jpg', '2018-04-20 13:01:41'),
(237, 65, 'Domenico_3_Door_Wardrobe_DO_10_10.jpg', '13478920fe1d3585cfff8de9bf0971ef.jpg', '2018-04-20 16:09:35'),
(238, 65, 'Domenico_3_Door_Wardrobe_DO_810.jpg', '134f7f24e383e70ebf581f83ade2573e.jpg', '2018-04-20 16:10:04'),
(239, 65, 'Domenico_3_Door_Wardrobe_DO_06_7.jpg', 'a3dfbe0fec13e81656bcba7800acfc21.jpg', '2018-04-20 16:10:39'),
(240, 65, 'Domenico_3_Door_Wardrobe_DO_03_4.jpg', '344b2c1440e5404801c1f4e8aadd5d5b.jpg', '2018-04-20 16:10:39'),
(241, 64, 'Murano_Single_Door_Display_Cabinet_MH_Dimensrion.jpg', '3b684f15e12844f141a75f8f8f48d425.jpg', '2018-04-20 16:13:38'),
(242, 64, 'Murano_Single_Door_Display_Cabinet_Mahogany_5.jpg', '70aef5e4249f62be0f68f479622a6a34.jpg', '2018-04-20 16:15:28'),
(243, 62, 'Finn_Double_Futon_Mattress_Castle_8.jpg', 'e2f91140776f08dbe2d820bd46cb0f25.jpg', '2018-04-20 16:18:36'),
(244, 62, 'Finn_Double_Futon_Mattress_Castle_7.jpg', 'bd738cbfc221856900277d52e18ba299.jpg', '2018-04-20 16:19:09'),
(245, 62, 'Finn_Double_Futon_Mattress_Castle_1.jpg', '48b1f23056fa27309b93e6edb60718a7.jpg', '2018-04-20 16:20:24'),
(246, 62, 'Finn_Double_Futon_Mattress_Castle_9.jpg', 'a49ee64bf72446e40c4e3d4e52b19e0e.jpg', '2018-04-20 16:20:43'),
(247, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_01.jpg', '808325eecee23dc29050dc85f1586fd6.jpg', '2018-04-20 16:35:22'),
(248, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_05.jpg', '8be052e18429f8250c84543af4e9a995.jpg', '2018-04-20 16:35:40'),
(249, 61, 'Austen_Compact_Aurelio_Study_Sets_Olive_Mahogany_03.jpg', '34d1a8af6b8c38d9b19854e8a2572336.jpg', '2018-04-20 16:36:31'),
(250, 66, 'charles_010_55.jpg', 'eb37b01558bd85984646ef0f5121be15.jpg', '2018-04-20 16:51:12'),
(251, 66, 'charles_09_55.jpg', '6cb068d0a580d8f29160afaf8fd282dd.jpg', '2018-04-20 16:51:30'),
(252, 66, 'charles_02_55.jpg', '69e9fc51611b4ec2e06810613024ada2.jpg', '2018-04-20 16:51:49');
-- --------------------------------------------------------
--
-- Table structure for table `product_subcategories`
--
CREATE TABLE `product_subcategories` (
`product_sub_category_id` bigint(10) NOT NULL,
`products_id` int(10) NOT NULL,
`sub_categories_id` int(10) NOT NULL,
`product_sub_category_created_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product_subcategories`
--
INSERT INTO `product_subcategories` (`product_sub_category_id`, `products_id`, `sub_categories_id`, `product_sub_category_created_on`) VALUES
(84, 63, 36, NULL),
(95, 65, 47, NULL),
(96, 64, 43, NULL),
(97, 62, 41, NULL),
(98, 61, 48, NULL),
(100, 66, 49, '2018-04-20 16:47:11');
-- --------------------------------------------------------
--
-- Table structure for table `refund_payments`
--
CREATE TABLE `refund_payments` (
`refund_payment_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`order_numbers` varchar(255) NOT NULL,
`transaction_id` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`method` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL,
`refundtransactioniId` varchar(255) DEFAULT NULL,
`refundfeesamout` decimal(10,2) DEFAULT NULL,
`refundresponse` text NOT NULL,
`netrefundamt` decimal(10,2) DEFAULT NULL,
`refund_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 0 for default orders, 1 for recurring orders',
`created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `related_products`
--
CREATE TABLE `related_products` (
`related_product_id` int(11) NOT NULL,
`products_id` int(11) NOT NULL,
`product_related_id` int(11) NOT NULL,
`related_product_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `related_products`
--
INSERT INTO `related_products` (`related_product_id`, `products_id`, `product_related_id`, `related_product_created`) VALUES
(1, 59, 58, '2018-03-14 12:52:08'),
(2, 59, 57, '2018-03-14 12:52:09'),
(3, 62, 61, '2018-04-20 12:30:03'),
(5, 65, 62, '2018-04-20 14:38:06'),
(6, 65, 64, '2018-04-20 14:45:36'),
(7, 64, 65, '2018-04-20 16:12:52'),
(8, 62, 64, '2018-04-20 16:21:55'),
(9, 66, 61, '2018-04-20 16:52:45'),
(10, 66, 62, '2018-04-20 16:52:46');
-- --------------------------------------------------------
--
-- Table structure for table `return_cancel_orders`
--
CREATE TABLE `return_cancel_orders` (
`return_cancel_order_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`order_numbers` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '0, for no action , 1 for refunded , 2 for cancelled',
`ip_address` varchar(255) NOT NULL,
`single` tinyint(1) NOT NULL,
`reason` text,
`action` tinyint(1) NOT NULL COMMENT '0 for cancel order and 1 for return order , 2 for recurring refund',
`recurring_id` int(11) DEFAULT NULL,
`return_cancel_orders_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `reviews`
--
CREATE TABLE `reviews` (
`review_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`orders_num` varchar(256) NOT NULL,
`products_id` int(11) NOT NULL,
`rating` tinyint(1) NOT NULL DEFAULT '0',
`reviews` text,
`review_status` tinyint(1) NOT NULL,
`review_created` datetime NOT NULL,
`review_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `save_cards`
--
CREATE TABLE `save_cards` (
`save_card_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL,
`method` tinyint(1) NOT NULL,
`name_on_card` varchar(255) DEFAULT NULL,
`card_number` varchar(255) DEFAULT NULL,
`authorise_address` varchar(255) DEFAULT NULL,
`authorise_city` varchar(255) DEFAULT NULL,
`authorise_state` varchar(255) DEFAULT NULL,
`authorise_postal_code` varchar(255) DEFAULT NULL,
`authorise_country` varchar(255) DEFAULT NULL,
`stripe_month` tinyint(4) DEFAULT NULL,
`stripe_year` varchar(4) DEFAULT NULL,
`save_cards_created` datetime NOT NULL,
`save_cards_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`settings_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`site_name` varchar(255) NOT NULL,
`site_keyword` varchar(255) DEFAULT NULL,
`site_description` text,
`blog_page` varchar(255) NOT NULL,
`google_analytic_code` text,
`facebook_tracking` text,
`facebook_id` varchar(255) DEFAULT NULL,
`twitter_user_id` varchar(255) DEFAULT NULL,
`youtube_channel_id` varchar(255) DEFAULT NULL,
`instagram_user_id` varchar(255) DEFAULT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(255) NOT NULL,
`settings_created` datetime NOT NULL,
`settings_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`settings_id`, `group_id`, `site_name`, `site_keyword`, `site_description`, `blog_page`, `google_analytic_code`, `facebook_tracking`, `facebook_id`, `twitter_user_id`, `youtube_channel_id`, `instagram_user_id`, `email`, `phone`, `settings_created`, `settings_modified`) VALUES
(1, 1, 'Lets Shop', 'Lets Shop', 'Lets Shop', '', ' ', '', 'Https://Facebook.Com', 'Https://Facebook.Com', 'Https://Facebook.Com', 'Https://Facebook.Com', 'bhavneesh_goyal@ajdevtech.com', '8968029004', '2018-04-23 14:42:49', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `status`
--
CREATE TABLE `status` (
`status_id` int(11) NOT NULL,
`status` varchar(256) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `status`
--
INSERT INTO `status` (`status_id`, `status`) VALUES
(1, 'Pending'),
(2, 'Processed'),
(3, 'Shipped'),
(4, 'Delivered'),
(5, 'Returned'),
(6, 'Refunded'),
(7, 'Stopped');
-- --------------------------------------------------------
--
-- Table structure for table `status_logs`
--
CREATE TABLE `status_logs` (
`status_log_id` int(11) NOT NULL,
`users_id` int(11) NOT NULL,
`customer_order_details_id` int(11) NOT NULL,
`order_status` tinyint(1) NOT NULL,
`log_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `subscribers`
--
CREATE TABLE `subscribers` (
`subscriber_id` int(11) NOT NULL,
`customers_email` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`subscribed_on` datetime NOT NULL,
`subscriber_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `sub_categories`
--
CREATE TABLE `sub_categories` (
`sub_category_id` int(11) NOT NULL,
`categories_id` int(11) NOT NULL,
`sub_category_name` varchar(256) CHARACTER SET utf8 NOT NULL,
`sub_category_slug` varchar(256) CHARACTER SET utf8 NOT NULL,
`sub_category_status` tinyint(1) NOT NULL COMMENT '1 for active 0 for unactive',
`sub_category_created` datetime NOT NULL,
`sub_category_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sub_categories`
--
INSERT INTO `sub_categories` (`sub_category_id`, `categories_id`, `sub_category_name`, `sub_category_slug`, `sub_category_status`, `sub_category_created`, `sub_category_modified`) VALUES
(26, 24, 'General', 'general', 1, '2017-10-25 00:00:00', NULL),
(36, 34, 'Smartphones', 'smartphones', 1, '2018-04-20 12:24:15', NULL),
(41, 29, 'Futon', 'futon_', 1, '2018-04-20 12:58:33', '2018-04-20 16:04:43'),
(42, 29, 'Leather Sofa Set', 'leather-sofa-set_', 1, '2018-04-20 12:58:33', '2018-04-20 16:05:00'),
(43, 32, 'Bookshelves', 'bookshelves_', 1, '2018-04-20 12:58:50', '2018-04-20 16:12:01'),
(46, 29, 'Modular Sofa Sets', 'modular-sofa-sets', 1, '2018-04-20 16:05:33', NULL),
(47, 32, 'Wardrobes', 'wardrobes', 1, '2018-04-20 16:06:34', NULL),
(48, 35, 'Study Table', 'study-table', 1, '2018-04-20 16:31:59', NULL),
(49, 35, 'Study Chair', 'study-chair', 1, '2018-04-20 16:31:59', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `sub_menu`
--
CREATE TABLE `sub_menu` (
`sub_menu_id` int(11) NOT NULL,
`categories_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`sub_menu_created` datetime NOT NULL,
`sub_menu_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sub_menu`
--
INSERT INTO `sub_menu` (`sub_menu_id`, `categories_id`, `groups_id`, `sub_menu_created`, `sub_menu_updated`) VALUES
(1, 29, 1, '2018-04-23 14:36:22', NULL),
(2, 32, 1, '2018-04-23 14:36:22', NULL),
(3, 35, 1, '2018-04-23 14:36:22', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `templates`
--
CREATE TABLE `templates` (
`template_id` int(11) NOT NULL,
`groups_id` int(11) NOT NULL,
`value` tinyint(1) NOT NULL,
`template_created` datetime NOT NULL,
`template_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `templates`
--
INSERT INTO `templates` (`template_id`, `groups_id`, `value`, `template_created`, `template_updated`) VALUES
(2, 1, 4, '2018-03-23 17:47:13', '2018-04-20 15:31:22');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int(10) NOT NULL,
`groups_id` int(11) NOT NULL DEFAULT '1',
`group_slug` varchar(20) CHARACTER SET utf8 NOT NULL,
`user_email` varchar(256) CHARACTER SET utf8 NOT NULL,
`user_firstname` varchar(50) CHARACTER SET utf8 NOT NULL,
`user_lastname` varchar(50) CHARACTER SET utf8 NOT NULL,
`user_password` varchar(256) CHARACTER SET utf8 NOT NULL,
`user_status` tinyint(1) NOT NULL COMMENT '0 for deactivate and 1 for activate',
`user_ip` varchar(20) CHARACTER SET utf8 NOT NULL,
`user_created` datetime NOT NULL,
`user_update` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `groups_id`, `group_slug`, `user_email`, `user_firstname`, `user_lastname`, `user_password`, `user_status`, `user_ip`, `user_created`, `user_update`) VALUES
(1, 1, 'admin', 'agent@wpgateway.com', 'agent@wpgateway.com', ' ', '21232f297a57a5a743894a0e4a801fc3', 1, '192.168.0.105', '2017-09-14 00:00:00', '2018-03-29 14:53:37');
-- --------------------------------------------------------
--
-- Table structure for table `user_credentials`
--
CREATE TABLE `user_credentials` (
`user_credential_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`no_of_days` int(11) NOT NULL DEFAULT '15',
`user_stripe_key` varchar(255) DEFAULT NULL,
`user_auth_login_name` varchar(255) DEFAULT NULL,
`user_auth_transaction_key` varchar(255) DEFAULT NULL,
`user_paypal_method_type` tinyint(1) DEFAULT NULL COMMENT '1 for standard; 2 for recurring bussiness ; 3 for paypal recurring',
`paypal_standard_email` varchar(255) DEFAULT NULL,
`paypal_api_name` varchar(255) DEFAULT NULL,
`paypal_api_password` varchar(255) DEFAULT NULL,
`paypal_signature` text,
`use_stripe` tinyint(1) NOT NULL DEFAULT '0',
`use_authorise` tinyint(1) NOT NULL DEFAULT '0',
`use_paypal` tinyint(1) NOT NULL DEFAULT '0',
`user_credentials_updation_on` datetime DEFAULT NULL,
`user_credential_created_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 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=66;
--
-- AUTO_INCREMENT for table `cart_added`
--
ALTER TABLE `cart_added`
MODIFY `cart_added_id` bigint(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `color_settings`
--
ALTER TABLE `color_settings`
MODIFY `color_settings_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_info`
--
ALTER TABLE `contact_info`
MODIFY `contact_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
MODIFY `country_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=227;
--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `coupon_applied`
--
ALTER TABLE `coupon_applied`
MODIFY `coupon_applied_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_cards`
--
ALTER TABLE `cron_cards`
MODIFY `cron_card_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_payments`
--
ALTER TABLE `cron_payments`
MODIFY `cron_payment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_payment_logs`
--
ALTER TABLE `cron_payment_logs`
MODIFY `cron_payment_log_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cron_stop`
--
ALTER TABLE `cron_stop`
MODIFY `cron_stop_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `currency_symbols`
--
ALTER TABLE `currency_symbols`
MODIFY `symbol_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customer_orders`
--
ALTER TABLE `customer_orders`
MODIFY `customer_order_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customer_order_details`
--
ALTER TABLE `customer_order_details`
MODIFY `customer_order_detail_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_logs`
--
ALTER TABLE `email_logs`
MODIFY `email_log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_settings`
--
ALTER TABLE `email_settings`
MODIFY `email_settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `email_template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `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=2;
--
-- AUTO_INCREMENT for table `footer_tabs`
--
ALTER TABLE `footer_tabs`
MODIFY `footer_tab_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `group_pages`
--
ALTER TABLE `group_pages`
MODIFY `group_page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `headings_info`
--
ALTER TABLE `headings_info`
MODIFY `heading_info_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `logo_images`
--
ALTER TABLE `logo_images`
MODIFY `logo_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `menu_positions`
--
ALTER TABLE `menu_positions`
MODIFY `menu_position_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `payment_details`
--
ALTER TABLE `payment_details`
MODIFY `payment_detail_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
MODIFY `plan_logs_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
--
-- AUTO_INCREMENT for table `product_colors`
--
ALTER TABLE `product_colors`
MODIFY `product_colors_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `product_csv_files`
--
ALTER TABLE `product_csv_files`
MODIFY `csv_file_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `product_dimensions`
--
ALTER TABLE `product_dimensions`
MODIFY `product_dimensions_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
MODIFY `product_image_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;
--
-- AUTO_INCREMENT for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
MODIFY `product_sub_category_id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- AUTO_INCREMENT for table `refund_payments`
--
ALTER TABLE `refund_payments`
MODIFY `refund_payment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `related_products`
--
ALTER TABLE `related_products`
MODIFY `related_product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `return_cancel_orders`
--
ALTER TABLE `return_cancel_orders`
MODIFY `return_cancel_order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `save_cards`
--
ALTER TABLE `save_cards`
MODIFY `save_card_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `status_logs`
--
ALTER TABLE `status_logs`
MODIFY `status_log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
--
-- AUTO_INCREMENT for table `sub_menu`
--
ALTER TABLE `sub_menu`
MODIFY `sub_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `templates`
--
ALTER TABLE `templates`
MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `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;