-- phpMyAdmin SQL Dump -- version 4.9.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 11, 2020 at 10:43 AM -- Server version: 10.4.8-MariaDB -- PHP Version: 7.3.11 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `laravel_webcart_check` -- -- -------------------------------------------------------- -- -- Table structure for table `banners` -- CREATE TABLE `banners` ( `id` int(10) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photo_id` int(10) UNSIGNED DEFAULT NULL, `location_id` int(10) UNSIGNED DEFAULT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `category_id` int(10) UNSIGNED DEFAULT NULL, `brand_id` int(10) UNSIGNED DEFAULT NULL, `position_brand` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `position_category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `priority` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `banners` -- INSERT INTO `banners` (`id`, `title`, `description`, `link`, `photo_id`, `location_id`, `is_active`, `position`, `created_at`, `updated_at`, `category_id`, `brand_id`, `position_brand`, `position_category`, `priority`) VALUES (1, NULL, NULL, NULL, 10, 1, 1, 'Main Slider', '2019-03-11 06:19:21', '2019-03-25 13:12:23', NULL, NULL, NULL, NULL, 1), (3, NULL, NULL, NULL, 12, 1, 1, 'Main Slider', '2019-03-11 06:19:41', '2019-03-25 13:12:43', NULL, NULL, NULL, NULL, 1), (4, NULL, NULL, NULL, 6, 1, 1, 'Main Slider', '2019-03-25 13:07:34', '2019-03-25 13:07:34', NULL, 2, 'Main Slider', NULL, 1), (5, NULL, NULL, NULL, 7, 1, 1, 'Main Slider', '2019-03-25 13:07:52', '2019-03-25 13:07:52', 2, 1, 'Main Slider', 'Main Slider', 1), (6, NULL, NULL, NULL, 13, 1, 1, 'Below Main Slider', '2019-03-25 13:14:03', '2019-03-25 13:14:03', NULL, NULL, NULL, NULL, 2), (7, NULL, NULL, NULL, 161, 1, 1, 'Below Main Slider', '2019-03-25 13:14:20', '2019-05-28 13:01:46', NULL, NULL, NULL, NULL, 2), (8, NULL, NULL, NULL, 15, 1, 1, 'Below Main Slider', '2019-03-25 13:14:29', '2019-03-25 13:16:11', NULL, NULL, NULL, NULL, 2), (9, NULL, NULL, NULL, 162, 1, 1, 'Below Main Slider - Three Images Layout', '2019-03-25 13:14:49', '2019-05-28 13:04:14', NULL, NULL, NULL, NULL, 3), (10, NULL, NULL, NULL, 17, 1, 1, 'Below Main Slider - Three Images Layout', '2019-03-25 13:15:02', '2019-03-25 13:15:02', NULL, NULL, NULL, NULL, 4), (11, NULL, NULL, NULL, 18, 1, 1, 'Below Main Slider - Three Images Layout', '2019-03-25 13:15:18', '2019-03-25 13:15:18', NULL, NULL, NULL, NULL, 4), (12, NULL, NULL, NULL, 34, 1, 1, 'Right Side', '2019-03-25 13:35:19', '2019-03-25 13:35:19', NULL, NULL, NULL, NULL, 1), (13, NULL, NULL, NULL, 35, 1, 1, 'Right Side', '2019-03-25 13:35:41', '2019-03-25 13:35:41', NULL, NULL, NULL, NULL, 2), (14, NULL, NULL, NULL, 36, 1, 1, 'Right Side', '2019-03-25 13:36:00', '2019-03-25 13:36:00', NULL, NULL, NULL, NULL, 3); -- -------------------------------------------------------- -- -- Table structure for table `brands` -- CREATE TABLE `brands` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `photo_id` int(10) UNSIGNED DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `location_id` int(10) UNSIGNED DEFAULT NULL, `voucher_id` int(10) UNSIGNED DEFAULT NULL, `meta_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `priority` int(11) NOT NULL DEFAULT 1, `show_in_menu` tinyint(1) NOT NULL DEFAULT 0, `show_in_footer` tinyint(1) NOT NULL DEFAULT 0, `show_in_slider` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `brands` -- INSERT INTO `brands` (`id`, `name`, `is_active`, `created_at`, `updated_at`, `photo_id`, `slug`, `location_id`, `voucher_id`, `meta_desc`, `meta_keywords`, `meta_title`, `priority`, `show_in_menu`, `show_in_footer`, `show_in_slider`) VALUES (5, 'Sony', 1, '2019-03-26 08:29:58', '2019-05-28 13:08:29', 164, 'sony', 1, NULL, '', '', '', 1, 1, 1, 1), (6, 'Samsung', 1, '2019-03-26 08:30:57', '2019-05-28 13:08:57', 165, 'samsung', 1, NULL, '', '', '', 1, 1, 1, 1), (7, 'Apple', 1, '2019-03-26 08:32:08', '2019-03-26 08:32:08', 42, 'apple', 1, NULL, '', '', '', 1, 1, 1, 1), (8, 'HP', 1, '2019-03-26 08:34:27', '2019-03-26 08:34:27', 43, 'hp', 1, NULL, '', '', '', 1, 1, 1, 1), (9, 'Lenovo', 1, '2019-03-26 08:41:52', '2019-03-26 08:44:56', 45, 'lenovo', 1, NULL, '', '', '', 1, 1, 1, 1), (10, 'Dell', 1, '2019-03-26 08:52:21', '2019-05-28 13:06:32', 163, 'dell', 1, NULL, '', '', '', 1, 1, 0, 1), (11, 'Oneplus', 1, '2019-03-26 08:58:08', '2019-03-26 08:59:33', 48, 'oneplus', 1, NULL, '', '', '', 1, 1, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `category_id` int(10) UNSIGNED NOT NULL DEFAULT 0, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `location_id` int(10) UNSIGNED DEFAULT NULL, `voucher_id` int(10) UNSIGNED DEFAULT NULL, `photo_id` int(10) UNSIGNED DEFAULT NULL, `meta_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `priority` int(11) NOT NULL DEFAULT 1, `show_in_menu` tinyint(1) NOT NULL DEFAULT 0, `show_in_footer` tinyint(1) NOT NULL DEFAULT 0, `show_in_slider` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `is_active`, `created_at`, `updated_at`, `category_id`, `slug`, `location_id`, `voucher_id`, `photo_id`, `meta_desc`, `meta_keywords`, `meta_title`, `priority`, `show_in_menu`, `show_in_footer`, `show_in_slider`) VALUES (5, 'Laptops', 1, '2019-03-26 06:21:56', '2019-05-28 13:10:32', 0, 'laptops', 1, NULL, 166, '', '', '', 1, 1, 1, 1), (6, 'Dell', 1, '2019-03-26 06:35:27', '2019-03-26 06:37:50', 5, 'dell', 1, NULL, NULL, '', '', '', 1, 1, 1, 0), (7, 'HP', 1, '2019-03-26 06:39:02', '2019-03-26 06:43:52', 5, 'hp', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (8, 'Lenovo', 1, '2019-03-26 06:40:12', '2019-03-26 06:42:55', 5, 'lenovo', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (9, 'Apple Macbook', 1, '2019-03-26 06:42:33', '2019-03-26 06:42:33', 5, 'apple-macbook', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (10, 'Inspiron Laptops', 1, '2019-03-26 06:47:11', '2019-03-26 07:47:13', 6, 'inspiron-laptops', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (11, 'Gaming Laptops - G Series', 1, '2019-03-26 06:47:55', '2019-03-26 07:47:21', 6, 'gaming-laptops-g-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (12, 'XPS Laptops', 1, '2019-03-26 06:48:22', '2019-03-26 07:47:26', 6, 'xps-laptops', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (13, 'Alienware Laptops', 1, '2019-03-26 06:48:57', '2019-03-26 07:47:32', 6, 'alienware-laptops', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (14, 'Inspiron 2-in-1 Laptops', 1, '2019-03-26 06:49:25', '2019-03-26 07:47:38', 6, 'inspiron-2-in-1-laptops', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (15, 'Spectre', 1, '2019-03-26 06:53:35', '2019-03-26 07:47:44', 7, 'spectre', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (16, 'HP Omen', 1, '2019-03-26 06:54:44', '2019-03-26 07:47:49', 7, 'hp-omen', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (17, 'Envy', 1, '2019-03-26 06:56:22', '2019-03-26 07:47:54', 7, 'envy-laptops', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (18, 'Pavilion', 1, '2019-03-26 06:57:08', '2019-03-26 07:47:59', 7, 'pavilion', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (19, 'ELITE', 1, '2019-03-26 06:59:31', '2019-03-26 07:48:03', 7, 'elite', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (21, 'ProBook', 1, '2019-03-26 07:01:01', '2019-03-26 07:48:12', 7, 'probook', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (24, 'IDEAPAD', 1, '2019-03-26 07:05:19', '2019-03-26 07:48:29', 8, 'ideapad', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (25, 'YOGA', 1, '2019-03-26 07:05:50', '2019-03-26 07:48:40', 8, 'yoga', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (26, 'Lenovo V Series', 1, '2019-03-26 07:06:26', '2019-03-26 07:48:46', 8, 'lenovo-v-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (27, 'Lenovo Legion Y Series', 1, '2019-03-26 07:08:06', '2019-03-26 07:48:53', 8, 'lenovo-legion-y-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (28, 'MacBook Air', 1, '2019-03-26 07:12:18', '2019-03-26 07:48:59', 9, 'macbook-air', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (29, 'Mac mini', 1, '2019-03-26 07:12:36', '2019-03-26 07:49:04', 9, 'mac-mini', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (30, 'MacBook Pro', 1, '2019-03-26 07:12:56', '2019-03-26 07:49:29', 9, 'macbook-pro', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (34, 'Mobiles', 1, '2019-03-26 07:50:48', '2019-03-26 07:52:44', 0, 'mobiles', 1, NULL, 39, '', '', '', 1, 1, 1, 1), (35, 'Samsung', 1, '2019-03-26 07:55:03', '2019-03-26 08:02:28', 34, 'samsung', 1, NULL, NULL, '', '', '', 1, 1, 1, 0), (36, 'Lenovo', 1, '2019-03-26 07:56:03', '2019-03-26 08:02:23', 34, 'lenovo-1', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (37, 'Sony', 1, '2019-03-26 07:58:51', '2019-03-26 08:02:19', 34, 'sony', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (38, 'iphone', 1, '2019-03-26 07:59:30', '2019-03-26 08:02:14', 34, 'iphone', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (39, 'Oneplus', 1, '2019-03-26 08:01:12', '2019-03-26 08:03:02', 34, 'oneplus', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (40, 'Galaxy S', 1, '2019-03-26 08:06:04', '2019-03-26 08:06:04', 35, 'galaxy-s', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (41, 'Galaxy Note', 1, '2019-03-26 08:06:45', '2019-03-26 08:06:45', 35, 'galaxy-note', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (42, 'Galaxy A', 1, '2019-03-26 08:07:14', '2019-03-26 08:07:14', 35, 'galaxy-a', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (43, 'Galaxy M', 1, '2019-03-26 08:07:39', '2019-03-26 08:07:39', 35, 'galaxy-m', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (44, 'Galaxy J', 1, '2019-03-26 08:08:05', '2019-03-26 08:08:05', 35, 'galaxy-j', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (45, 'Galaxy On', 1, '2019-03-26 08:08:46', '2019-03-26 08:08:46', 35, 'galaxy-on', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (46, 'P Series', 1, '2019-03-26 08:10:26', '2019-03-26 08:10:26', 36, 'p-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (47, 'K Series', 1, '2019-03-26 08:10:42', '2019-03-26 08:10:42', 36, 'k-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (48, 'Zuk Series', 1, '2019-03-26 08:10:58', '2019-03-26 08:10:58', 36, 'zuk-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (49, 'A Series', 1, '2019-03-26 08:11:17', '2019-03-26 08:11:17', 36, 'a-series', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (51, 'Xperia XZ2', 1, '2019-03-26 08:15:20', '2019-05-08 12:49:06', 37, 'xperia-x', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (52, 'Xperia L2', 1, '2019-03-26 08:15:54', '2019-05-08 12:49:58', 37, 'xperia-xa', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (53, 'Xperia XA Ultra', 1, '2019-03-26 08:16:28', '2019-03-26 08:16:28', 37, 'xperia-xa-ultra', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (54, 'Xperia XZ', 1, '2019-03-26 08:17:02', '2019-03-26 08:17:02', 37, 'xperia-xz', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (59, 'iPhone XR', 1, '2019-03-26 08:21:49', '2019-05-08 12:51:53', 38, 'iphone-xr', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (60, 'iPhone 8', 1, '2019-03-26 08:22:04', '2019-03-26 08:22:04', 38, 'iphone-8', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (61, 'iPhone 7', 1, '2019-03-26 08:22:26', '2019-03-26 08:22:26', 38, 'iphone-7', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (63, 'OnePlus 5', 1, '2019-03-26 08:25:40', '2019-03-26 08:25:40', 39, 'oneplus-5', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (64, 'OnePlus 5T', 1, '2019-03-26 08:25:56', '2019-03-26 08:25:56', 39, 'oneplus-5t', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (65, 'OnePlus 6', 1, '2019-03-26 08:26:16', '2019-03-26 08:26:16', 39, 'oneplus-6', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (66, 'OnePlus 6T', 1, '2019-03-26 08:26:35', '2019-03-26 08:26:35', 39, 'oneplus-6t', 1, NULL, NULL, '', '', '', 1, 1, 0, 0), (67, 'Watches', 1, '2019-03-26 10:38:43', '2019-03-26 10:38:43', 0, 'watches', 1, NULL, 71, '', '', '', 1, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `category_specification_type` -- CREATE TABLE `category_specification_type` ( `id` int(10) UNSIGNED NOT NULL, `category_id` int(10) UNSIGNED NOT NULL, `specification_type_id` int(10) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_specification_type` -- INSERT INTO `category_specification_type` (`id`, `category_id`, `specification_type_id`, `created_at`, `updated_at`) VALUES (1, 6, 1, NULL, NULL), (2, 6, 2, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `comparision_groups` -- CREATE TABLE `comparision_groups` ( `cg_id` int(10) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `comparision_groups` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `comparision_groups` -- INSERT INTO `comparision_groups` (`cg_id`, `title`, `comparision_groups`, `created_at`, `updated_at`) VALUES (1, 'Mobile Compares', 'a:4:{i:0;a:2:{s:9:\"comp_type\";s:1:\"1\";s:8:\"photo_id\";i:169;}i:1;a:2:{s:9:\"comp_type\";s:1:\"2\";s:8:\"photo_id\";i:170;}i:2;a:2:{s:9:\"comp_type\";s:1:\"3\";s:8:\"photo_id\";i:174;}i:3;a:2:{s:9:\"comp_type\";s:1:\"4\";s:8:\"photo_id\";i:173;}}', '2020-02-06 18:55:31', '2020-02-06 18:55:31'); -- -------------------------------------------------------- -- -- Table structure for table `deals` -- CREATE TABLE `deals` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `priority` int(11) NOT NULL DEFAULT 1, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `location_id` int(10) UNSIGNED DEFAULT NULL, `meta_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `show_in_menu` tinyint(1) NOT NULL DEFAULT 0, `show_in_footer` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deals` -- INSERT INTO `deals` (`id`, `name`, `description`, `priority`, `slug`, `is_active`, `created_at`, `updated_at`, `location_id`, `meta_desc`, `meta_keywords`, `meta_title`, `show_in_menu`, `show_in_footer`) VALUES (1, 'Today\'s Deals', NULL, 1, 'today-s-deal', 1, '2019-03-25 13:11:47', '2019-11-13 01:45:47', 1, '', '', '', 1, 1), (2, 'Lightening Deals', NULL, 2, 'lightening-deal', 1, '2019-11-13 01:44:58', '2019-11-13 01:49:20', 1, '', '', '', 0, 1), (3, 'Deals on Laptops', NULL, 1, 'deals-on-laptops', 1, '2019-11-13 01:48:05', '2019-11-13 01:48:05', 1, '', '', '', 0, 1), (4, 'Deals on Mobiles', NULL, 1, 'deals-on-mobiles', 1, '2019-11-13 01:48:59', '2019-11-13 01:48:59', 1, '', '', '', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `deal_product` -- CREATE TABLE `deal_product` ( `id` int(10) UNSIGNED NOT NULL, `deal_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deal_product` -- INSERT INTO `deal_product` (`id`, `deal_id`, `product_id`, `created_at`, `updated_at`) VALUES (6, 1, 14, NULL, NULL), (7, 1, 15, NULL, NULL), (8, 1, 16, NULL, NULL), (9, 1, 17, NULL, NULL), (10, 1, 18, NULL, NULL), (11, 2, 8, NULL, NULL), (12, 2, 9, NULL, NULL), (13, 2, 10, NULL, NULL), (14, 2, 11, NULL, NULL), (15, 2, 12, NULL, NULL), (16, 2, 13, NULL, NULL), (17, 2, 14, NULL, NULL), (18, 3, 15, NULL, NULL), (19, 3, 16, NULL, NULL), (20, 3, 20, NULL, NULL), (21, 3, 29, NULL, NULL), (22, 3, 30, NULL, NULL), (23, 3, 31, NULL, NULL), (24, 4, 32, NULL, NULL), (25, 4, 33, NULL, NULL), (26, 4, 34, NULL, NULL), (27, 4, 35, NULL, NULL), (28, 4, 36, NULL, NULL), (29, 4, 37, NULL, NULL), (30, 4, 38, NULL, NULL), (31, 4, 39, NULL, NULL), (32, 4, 40, NULL, NULL), (33, 4, 41, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` int(10) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `meta_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `priority` int(11) NOT NULL DEFAULT 1, `show_in_menu` tinyint(1) NOT NULL DEFAULT 0, `show_in_footer` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `title`, `content`, `is_active`, `slug`, `created_at`, `updated_at`, `meta_desc`, `meta_keywords`, `meta_title`, `priority`, `show_in_menu`, `show_in_footer`) VALUES (1, 'About Us', '\r\n
\r\n
\r\n
\r\n

About Company Page

\r\n
\r\n

Web-cart is a term. Web-cart means a combination of different-different shopping stores with multi-vendor. And The multi-vendor shopping cart allows shop merchants to easily manage their multiple vendors in one single admin panel. Using of Multi-vendors shopping cart shopkeeper or merchants work manage easily. Instead of logging into several accounts in order to manage all of your stores, you can just log in to one account and set anything you want for each of your stores in the administrative area.

\r\n

Create an infinite range of online stores, share a shopping cart between multiple stores. “Webcart” is the entire solution for eCommerce business management. it’s all in one package for website management with backend admin panel to manage inventory, order, product, invoicing on.

\r\n

“Webcart” is a powerful solution to run your business properly & smoothly. Its lots of interesting features will helps you to increase your online business. It has Super Admin Panel: You Can manage the whole site by this admin panel. Admin can create user & store account & easily control the total business and multiple stores as well.

\r\n
\r\n
\"company\"
\r\n
\r\n
\r\n
\r\n
\r\n
\"values\"
\r\n
\r\n

Our Values

\r\n
\r\n

MISSION: Our mission lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

\r\n
\r\n

VISION: Our vision Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

\r\n
\r\n
\r\n
\r\n\r\n
\r\n

FEATURES

\r\n

Easy to Setup, Easy to Use, Smooth Experience, Outstanding Support

\r\n
\r\n
\r\n
\"multi\r\n

MULTI-STORE SHOPPING

\r\n
    \r\n
  • Easily switch between stores
    • \r\n
  • Easy to navigate Storefront
    • \r\n
  • Simple Checkouts
    • \r\n
  • Fully Responsive Design
    • \r\n
  • Smooth Experience
    • \r\n
  • User Friendly
    • \r\n
\r\n
\r\n
\"admin\r\n

ATTRACTIVE ADMIN PANEL

\r\n
    \r\n
  • Easy to use
    • \r\n
  • Easy to add / edit / delete records
    • \r\n
  • One click dashboard filtering by store’s
    • \r\n
  • Visualize records with charts and graphs
    • \r\n
  • Data tables with advanced search
    • \r\n
  • Export Data To PDF, CSV, Excel
    • \r\n
  • User Friendly
    • \r\n
\r\n
\r\n
\"deals\r\n

DEALS, COUPONS AND DISCOUNTS

\r\n
    \r\n
  • Unlimited Custom Deals
    • \r\n
  • Easy to add and manage coupon codes
    • \r\n
  • Easy to offer discounts on products
    • \r\n
\r\n
\r\n
\r\n

\r\n
\r\n
\"multiple\r\n

MULTIPLE PAYMENT OPTIONS

\r\n
    \r\n
  • Supports Paypal, Stripe, Razorpay, Instamojo and Cash on Delivery
    • \r\n
  • Easy to setup
    • \r\n
\r\n
\r\n
\"ajax\"\r\n

AJAX FILTERING, SORTING AND PAGINATION

\r\n
    \r\n
  • Price Range Filter
    • \r\n
  • Category, Brand, Specification Filters
    • \r\n
  • Sorting Products By Popularity, Ratings
    • \r\n
\r\n
\r\n
\"Subscribers\"\r\n

SUBSCRIBERS MANAGEMENT

\r\n
    \r\n
  • Collect Subscribers Using MailChimp
    • \r\n
  • Import Subscribers From CSV File
    • \r\n
\r\n
\r\n
\r\n
\r\n



\r\n
\r\n

WHY CHOOSE US ?

\r\n

Easy to Setup, Easy to Use, Smooth Experience, Outstanding Support

\r\n
\r\n
\r\n
\r\n
\"EFFORTLESS\r\n

EFFORTLESS CHECKOUT OPTIONS

\r\n

Making it as easy as possible for your customers to pay is essential for increasing conversions and sales.

\r\n
\r\n
\r\n
\r\n
\"MULTI-VENDOR\"\r\n

MULTI-VENDOR

\r\n

An admin is the head of a Multi-Vendor marketplace. He or she controls everything from the admin panel: vendors, orders, income, payouts, look and feel, and more.

\r\n
\r\n
\r\n
\r\n
\"USER\r\n

USER FRIENDLY SETTINGS

\r\n

Easy to configure admin panel options and much accessible user settings gives a seamless experience in setting up the cart and ordering from it.

\r\n
\r\n
\r\n
\r\n
', 1, 'about', '2020-02-04 20:47:10', '2020-02-05 00:36:21', '', '', '', 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `photos` -- CREATE TABLE `photos` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `product_id` int(10) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `photos` -- INSERT INTO `photos` (`id`, `name`, `created_at`, `updated_at`, `product_id`) VALUES (6, '15535192544.jpg', '2019-03-25 13:07:34', '2019-03-25 13:07:34', NULL), (7, '15535192725.jpg', '2019-03-25 13:07:52', '2019-03-25 13:07:52', NULL), (10, '15535195431.jpg', '2019-03-25 13:12:23', '2019-03-25 13:12:23', NULL), (11, '15535195532.jpg', '2019-03-25 13:12:33', '2019-03-25 13:12:33', NULL), (12, '15535195633.jpg', '2019-03-25 13:12:43', '2019-03-25 13:12:43', NULL), (13, '1553519643b1.jpg', '2019-03-25 13:14:03', '2019-03-25 13:14:03', NULL), (14, '1553519660b2.jpg', '2019-03-25 13:14:20', '2019-03-25 13:14:20', NULL), (15, '1553519669b3.jpg', '2019-03-25 13:14:29', '2019-03-25 13:14:29', NULL), (16, '1553519689a1.jpg', '2019-03-25 13:14:49', '2019-03-25 13:14:49', NULL), (17, '1553519702a2.jpg', '2019-03-25 13:15:02', '2019-03-25 13:15:02', NULL), (18, '1553519718a3.jpg', '2019-03-25 13:15:18', '2019-03-25 13:15:18', NULL), (34, '1553520919sb1.jpg', '2019-03-25 13:35:19', '2019-03-25 13:35:19', NULL), (35, '1553520941sb2.jpg', '2019-03-25 13:35:41', '2019-03-25 13:35:41', NULL), (36, '1553520960sb3.jpg', '2019-03-25 13:36:00', '2019-03-25 13:36:00', NULL), (38, '1553581316laptop_category.jpg', '2019-03-26 06:21:56', '2019-03-26 06:21:56', NULL), (39, '1553586764web-mobiles.jpg', '2019-03-26 07:52:44', '2019-03-26 07:52:44', NULL), (40, '1553588998sony.jpg', '2019-03-26 08:29:58', '2019-03-26 08:29:58', NULL), (41, '1553589057samsung.jpg', '2019-03-26 08:30:57', '2019-03-26 08:30:57', NULL), (42, '1553589127apple.jpg', '2019-03-26 08:32:07', '2019-03-26 08:32:07', NULL), (43, '1553589267hp.jpg', '2019-03-26 08:34:27', '2019-03-26 08:34:27', NULL), (45, '1553589896lenovo1.jpg', '2019-03-26 08:44:56', '2019-03-26 08:44:56', NULL), (46, '1553590341dell1.jpg', '2019-03-26 08:52:21', '2019-03-26 08:52:21', NULL), (48, '1553590773onplus2.png', '2019-03-26 08:59:33', '2019-03-26 08:59:33', NULL), (49, '1553592693dell_ins1.jpg', '2019-03-26 09:31:33', '2019-03-26 09:31:33', NULL), (50, 'alt_img_1553592693dell_ins2.jpg', '2019-03-26 09:31:33', '2019-03-26 09:31:33', 9), (51, 'alt_img_1553593237dellins4.jpg', '2019-03-26 09:40:37', '2019-03-26 09:40:37', 8), (52, '1553593271dellins3.jpg', '2019-03-26 09:41:11', '2019-03-26 09:41:11', NULL), (53, '1553593759dellins5.png', '2019-03-26 09:49:19', '2019-03-26 09:49:19', NULL), (54, 'alt_img_1553593759dellins6.png', '2019-03-26 09:49:19', '2019-03-26 09:49:19', 10), (55, '1553594388dell-ins7.jpeg', '2019-03-26 09:59:48', '2019-03-26 09:59:48', NULL), (56, 'alt_img_1553594388dell-ins8.jpeg', '2019-03-26 09:59:48', '2019-03-26 09:59:48', 11), (57, '1553594612dell-na-gaming-laptop1.jpeg', '2019-03-26 10:03:32', '2019-03-26 10:03:32', NULL), (58, 'alt_img_1553594612dell-na-gaming-laptop2.jpeg', '2019-03-26 10:03:32', '2019-03-26 10:03:32', 12), (59, '1553594869dell-na-thin1.jpeg', '2019-03-26 10:07:49', '2019-03-26 10:07:49', NULL), (60, 'alt_img_1553594869dell-na-thin2.jpeg', '2019-03-26 10:07:49', '2019-03-26 10:07:49', 13), (61, '1553595098dell-na-thin-3.jpeg', '2019-03-26 10:11:38', '2019-03-26 10:11:38', NULL), (62, 'alt_img_1553595098dell-na-thin-4.jpeg', '2019-03-26 10:11:38', '2019-03-26 10:11:38', 14), (63, '1553595369alienware-na-gaming5.jpeg', '2019-03-26 10:16:09', '2019-03-26 10:16:09', NULL), (64, 'alt_img_1553595369alienware-na-gaming6.jpeg', '2019-03-26 10:16:09', '2019-03-26 10:16:09', 15), (65, '1553595747alienware-na-gaming4.jpeg', '2019-03-26 10:22:27', '2019-03-26 10:22:27', NULL), (66, 'alt_img_1553595747alienware-na-gaming7.jpeg', '2019-03-26 10:22:27', '2019-03-26 10:22:27', 16), (67, '1553596085dell-new-inspiron-15.jpeg', '2019-03-26 10:28:05', '2019-03-26 10:28:05', NULL), (68, 'alt_img_1553596085dell-new-inspiron-15-1.jpeg', '2019-03-26 10:28:05', '2019-03-26 10:28:05', 17), (69, '1553596318dell-inspiron-15-2.jpeg', '2019-03-26 10:31:58', '2019-03-26 10:31:58', NULL), (70, 'alt_img_1553596319dell-inspiron-15-3.jpeg', '2019-03-26 10:31:59', '2019-03-26 10:31:59', 18), (71, '1553596723watches.jpg', '2019-03-26 10:38:43', '2019-03-26 10:38:43', NULL), (72, '1553598225hp-na-gaming-8.jpeg', '2019-03-26 11:03:45', '2019-03-26 11:03:45', NULL), (73, 'alt_img_1553598225hp-na-gaming-9.jpeg', '2019-03-26 11:03:45', '2019-03-26 11:03:45', 19), (74, '1553598553hp-na1.jpeg', '2019-03-26 11:09:13', '2019-03-26 11:09:13', NULL), (75, 'alt_img_1553598553hp-na2.jpeg', '2019-03-26 11:09:13', '2019-03-26 11:09:13', 20), (76, '1553598901hp-envy1.jpeg', '2019-03-26 11:15:01', '2019-03-26 11:15:01', NULL), (77, 'alt_img_1553598901hp-envy2.jpeg', '2019-03-26 11:15:01', '2019-03-26 11:15:01', 21), (78, '1553599116hp-pav1.jpeg', '2019-03-26 11:18:36', '2019-03-26 11:18:36', NULL), (79, 'alt_img_1553599116hp-pav2.jpeg', '2019-03-26 11:18:36', '2019-03-26 11:18:36', 22), (80, '1553599389hp-elite-1.jpeg', '2019-03-26 11:23:09', '2019-03-26 11:23:09', NULL), (81, 'alt_img_1553599389hp-elite-2-1.jpeg', '2019-03-26 11:23:09', '2019-03-26 11:23:09', 23), (82, '1553599809hp-probook-1.jpeg', '2019-03-26 11:30:09', '2019-03-26 11:30:09', NULL), (83, 'alt_img_1553599810hp-probook-3.jpeg', '2019-03-26 11:30:10', '2019-03-26 11:30:10', 24), (84, '1553600045lenovo-1.jpeg', '2019-03-26 11:34:05', '2019-03-26 11:34:05', NULL), (85, 'alt_img_1553600045lenovo-2.jpeg', '2019-03-26 11:34:05', '2019-03-26 11:34:05', 25), (86, '1553600380lenovo-na1.jpeg', '2019-03-26 11:39:40', '2019-03-26 11:39:40', NULL), (87, 'alt_img_1553600380lenovo-na2.jpeg', '2019-03-26 11:39:40', '2019-03-26 11:39:40', 26), (88, '1553600804testi1.jpg', '2019-03-26 11:46:44', '2019-03-26 11:46:44', NULL), (89, '1553600888test2.jpg', '2019-03-26 11:48:08', '2019-03-26 11:48:08', NULL), (90, 'alt_img_1557309047hp-probook-3.jpeg', '2019-05-08 09:50:47', '2019-05-08 09:50:47', 24), (91, '1557309054hp-probook-1.jpeg', '2019-05-08 09:50:54', '2019-05-08 09:50:54', NULL), (92, '1557309122hp-pav1.jpeg', '2019-05-08 09:52:02', '2019-05-08 09:52:02', NULL), (93, 'alt_img_1557309191hp-envy2.jpeg', '2019-05-08 09:53:11', '2019-05-08 09:53:11', 21), (94, '1557309194hp-envy1.jpeg', '2019-05-08 09:53:14', '2019-05-08 09:53:14', NULL), (95, 'alt_img_1557309294dell-inspiron-15-3.jpeg', '2019-05-08 09:54:54', '2019-05-08 09:54:54', 18), (96, '1557309295dell-inspiron-15-2.jpeg', '2019-05-08 09:54:55', '2019-05-08 09:54:55', NULL), (97, '1557309328dell-new-inspiron-15.jpeg', '2019-05-08 09:55:29', '2019-05-08 09:55:29', NULL), (98, 'alt_img_1557309380dell-na-thin2.jpeg', '2019-05-08 09:56:20', '2019-05-08 09:56:20', 13), (99, '1557309383dell-na-thin1.jpeg', '2019-05-08 09:56:23', '2019-05-08 09:56:23', NULL), (100, 'alt_img_1557309434dell_ins2.jpg', '2019-05-08 09:57:14', '2019-05-08 09:57:14', 9), (101, '1557309436dell_ins1.jpg', '2019-05-08 09:57:16', '2019-05-08 09:57:16', NULL), (102, '1557310581lenovo-v110.jpeg', '2019-05-08 10:16:21', '2019-05-08 10:16:21', NULL), (103, 'alt_img_1557310581lenovo-v110-1.jpeg', '2019-05-08 10:16:21', '2019-05-08 10:16:21', 27), (104, '1557310911lenovo-y.jpeg', '2019-05-08 10:21:51', '2019-05-08 10:21:51', NULL), (105, 'alt_img_1557310911lenovo-y1.jpeg', '2019-05-08 10:21:51', '2019-05-08 10:21:51', 28), (106, '1557311303apple-air1.jpeg', '2019-05-08 10:28:23', '2019-05-08 10:28:23', NULL), (107, 'alt_img_1557311303apple-air2.jpeg', '2019-05-08 10:28:23', '2019-05-08 10:28:23', 29), (108, '1557312039apple-mini_.jpg', '2019-05-08 10:40:39', '2019-05-08 10:40:39', NULL), (109, '1557312382apple-air-pro.jpeg', '2019-05-08 10:46:22', '2019-05-08 10:46:22', NULL), (110, 'alt_img_1557312382apple-air-pro1.jpeg', '2019-05-08 10:46:22', '2019-05-08 10:46:22', 31), (111, '1557313693samsung-galaxy-s10-1.jpeg', '2019-05-08 11:08:13', '2019-05-08 11:08:13', NULL), (112, 'alt_img_1557313693samsung-galaxy-s10-2.jpeg', '2019-05-08 11:08:13', '2019-05-08 11:08:13', 32), (113, '1557313978samsung-galaxy-s10-plus-1.jpeg', '2019-05-08 11:12:58', '2019-05-08 11:12:58', NULL), (114, 'alt_img_1557313978samsung-galaxy-s10-plus-2.jpeg', '2019-05-08 11:12:58', '2019-05-08 11:12:58', 33), (115, '1557314340samsung-galaxy-note-8-1.jpeg', '2019-05-08 11:19:00', '2019-05-08 11:19:00', NULL), (116, 'alt_img_1557314340samsung-galaxy-note-8-2.jpeg', '2019-05-08 11:19:00', '2019-05-08 11:19:00', 34), (117, '1557314556samsung-galaxy-note-9-1.jpeg', '2019-05-08 11:22:36', '2019-05-08 11:22:36', NULL), (118, 'alt_img_1557314556samsung-galaxy-note-9-2.jpeg', '2019-05-08 11:22:36', '2019-05-08 11:22:36', 35), (119, '1557315021samsung-galaxy-a50-1.jpeg', '2019-05-08 11:30:21', '2019-05-08 11:30:21', NULL), (120, 'alt_img_1557315021samsung-galaxy-a50-2.jpeg', '2019-05-08 11:30:21', '2019-05-08 11:30:21', 36), (121, '1557315381samsung-galaxy-a30-1.jpeg', '2019-05-08 11:36:21', '2019-05-08 11:36:21', NULL), (122, 'alt_img_1557315381samsung-galaxy-a30-2.jpeg', '2019-05-08 11:36:21', '2019-05-08 11:36:21', 37), (123, '1557315647samsung-galaxy-m30-1.jpeg', '2019-05-08 11:40:47', '2019-05-08 11:40:47', NULL), (124, 'alt_img_1557315647samsung-galaxy-m30-2.jpeg', '2019-05-08 11:40:47', '2019-05-08 11:40:47', 38), (125, '1557315979samsung-m20-1.jpeg', '2019-05-08 11:46:19', '2019-05-08 11:46:19', NULL), (126, 'alt_img_1557315979samsung-m20-2.jpeg', '2019-05-08 11:46:19', '2019-05-08 11:46:19', 39), (127, '1557316236samsung-galaxy-j8-1.jpeg', '2019-05-08 11:50:36', '2019-05-08 11:50:36', NULL), (128, 'alt_img_1557316236samsung-galaxy-j8-2.jpeg', '2019-05-08 11:50:36', '2019-05-08 11:50:36', 40), (129, '1557316487samsung-galaxy-j7-prime-1.jpeg', '2019-05-08 11:54:47', '2019-05-08 11:54:47', NULL), (130, 'alt_img_1557316487samsung-galaxy-j7-prime-2.jpeg', '2019-05-08 11:54:47', '2019-05-08 11:54:47', 41), (131, '1557317078samsung-galaxy-on8-1.jpeg', '2019-05-08 12:04:38', '2019-05-08 12:04:38', NULL), (132, 'alt_img_1557317078samsung-galaxy-on8-2.jpeg', '2019-05-08 12:04:38', '2019-05-08 12:04:38', 42), (133, '1557317332samsung-on-max-1.jpeg', '2019-05-08 12:08:52', '2019-05-08 12:08:52', NULL), (134, 'alt_img_1557317332samsung-on-max-2.jpeg', '2019-05-08 12:08:52', '2019-05-08 12:08:52', 43), (135, '1557317714lenovo-p2-1.jpeg', '2019-05-08 12:15:14', '2019-05-08 12:15:14', NULL), (136, 'alt_img_1557317714lenovo-p2-2.jpeg', '2019-05-08 12:15:14', '2019-05-08 12:15:14', 44), (137, '1557318030lenovo-vibe-p1-1.jpeg', '2019-05-08 12:20:30', '2019-05-08 12:20:30', NULL), (138, 'alt_img_1557318030lenovo-vibe-p1-2.jpeg', '2019-05-08 12:20:30', '2019-05-08 12:20:30', 45), (139, '1557318247lenovo-k8-plus-1.jpeg', '2019-05-08 12:24:07', '2019-05-08 12:24:07', NULL), (140, 'alt_img_1557318247lenovo-k8-plus-2.jpeg', '2019-05-08 12:24:07', '2019-05-08 12:24:07', 46), (141, '1557318423lenovo-k9-1.jpeg', '2019-05-08 12:27:03', '2019-05-08 12:27:03', NULL), (142, 'alt_img_1557318423lenovo-k9-2.jpeg', '2019-05-08 12:27:03', '2019-05-08 12:27:03', 47), (143, '1557318651lenovo-zuk-z1-1.jpeg', '2019-05-08 12:30:51', '2019-05-08 12:30:51', NULL), (144, 'alt_img_1557318651lenovo-zuk-z1-2.jpeg', '2019-05-08 12:30:51', '2019-05-08 12:30:51', 48), (145, '1557319029lenovo-a6000-shot-1.jpeg', '2019-05-08 12:37:09', '2019-05-08 12:37:09', NULL), (146, 'alt_img_1557319029lenovo-a6000-shot-2.jpeg', '2019-05-08 12:37:09', '2019-05-08 12:37:09', 49), (147, '1557319267lenovo-a5-1.jpeg', '2019-05-08 12:41:07', '2019-05-08 12:41:07', NULL), (148, 'alt_img_1557319268lenovo-a5-2.jpeg', '2019-05-08 12:41:08', '2019-05-08 12:41:08', 50), (149, '1557320124sony-xperia-xz2-1.jpeg', '2019-05-08 12:55:24', '2019-05-08 12:55:24', NULL), (150, 'alt_img_1557320124sony-xperia-xz2-2.jpeg', '2019-05-08 12:55:24', '2019-05-08 12:55:24', 51), (151, '1557320329sony-xperia-l2-1.jpeg', '2019-05-08 12:58:49', '2019-05-08 12:58:49', NULL), (152, 'alt_img_1557320329sony-xperia-l2-2.jpeg', '2019-05-08 12:58:49', '2019-05-08 12:58:49', 52), (153, '1557320482sony-xperia-xa-ultra-1.jpeg', '2019-05-08 13:01:22', '2019-05-08 13:01:22', NULL), (154, 'alt_img_1557320482sony-xperia-xa-ultra-2.jpeg', '2019-05-08 13:01:22', '2019-05-08 13:01:22', 53), (155, '1557320679sony-xperia-xz-1.jpeg', '2019-05-08 13:04:39', '2019-05-08 13:04:39', NULL), (156, 'alt_img_1557320679sony-xperia-xz2-2.jpeg', '2019-05-08 13:04:39', '2019-05-08 13:04:39', 54), (157, '1557320853apple-iphone-xr-1.jpeg', '2019-05-08 13:07:33', '2019-05-08 13:07:33', NULL), (158, 'alt_img_1557320853apple-iphone-xr-2.jpeg', '2019-05-08 13:07:33', '2019-05-08 13:07:33', 55), (159, '1557321106apple-iphone-8-1.jpeg', '2019-05-08 13:11:46', '2019-05-08 13:11:46', NULL), (160, 'alt_img_1557321106apple-iphone-8-2.jpeg', '2019-05-08 13:11:46', '2019-05-08 13:11:46', 56), (161, '15590485061553520941sb2.jpg', '2019-05-28 13:01:46', '2019-05-28 13:01:46', NULL), (162, '1559048654banner-3.jpg', '2019-05-28 13:04:14', '2019-05-28 13:04:14', NULL), (163, '1559048792brand1.jpg', '2019-05-28 13:06:32', '2019-05-28 13:06:32', NULL), (164, '1559048909sony.jpg', '2019-05-28 13:08:29', '2019-05-28 13:08:29', NULL), (165, '1559048937samsung.jpg', '2019-05-28 13:08:57', '2019-05-28 13:08:57', NULL), (166, '1559049032category.jpg', '2019-05-28 13:10:32', '2019-05-28 13:10:32', NULL), (167, '1577353231paytm.png', '2019-12-26 04:10:31', '2019-12-26 04:10:31', NULL), (168, 'alt_img_1577353231paytm.png', '2019-12-26 04:10:31', '2019-12-26 04:10:31', 58), (169, '1581333611weight_407329.png', '2020-02-10 05:50:11', '2020-02-10 05:50:11', NULL), (170, '1581333612839730-200.png', '2020-02-10 05:50:12', '2020-02-10 05:50:12', NULL), (171, '1581408976hardware_ram-memory-hardware-512.png', '2020-02-11 02:46:16', '2020-02-11 02:46:16', NULL), (172, '1581409176hardware_ram-memory-hardware-512.png', '2020-02-11 02:49:36', '2020-02-11 02:49:36', NULL), (173, '1581409190396-01-512.png', '2020-02-11 02:49:50', '2020-02-11 02:49:50', NULL), (174, '1581409257Ram-512.png', '2020-02-11 02:50:57', '2020-02-11 02:50:57', NULL); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0, `category_id` int(10) UNSIGNED DEFAULT NULL, `brand_id` int(10) UNSIGNED DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `in_stock` int(11) NOT NULL, `price` decimal(12,2) UNSIGNED NOT NULL, `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tax_rate` decimal(12,2) UNSIGNED NOT NULL DEFAULT 0.00, `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `photo_id` int(10) UNSIGNED DEFAULT NULL, `sales` int(10) UNSIGNED NOT NULL DEFAULT 0, `qty_per_order` int(10) UNSIGNED NOT NULL DEFAULT 2, `location_id` int(10) UNSIGNED DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `voucher_id` int(10) UNSIGNED DEFAULT NULL, `file_id` int(11) DEFAULT NULL, `virtual` tinyint(1) NOT NULL DEFAULT 0, `downloadable` tinyint(1) NOT NULL DEFAULT 0, `meta_desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `old_price` decimal(12,2) UNSIGNED DEFAULT NULL, `sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hsn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `custom_fields` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vendor_id` int(10) UNSIGNED DEFAULT NULL, `variants` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comp_group_id` int(10) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `user_id`, `category_id`, `brand_id`, `name`, `description`, `in_stock`, `price`, `model`, `tax_rate`, `barcode`, `is_active`, `created_at`, `updated_at`, `photo_id`, `sales`, `qty_per_order`, `location_id`, `slug`, `voucher_id`, `file_id`, `virtual`, `downloadable`, `meta_desc`, `meta_keywords`, `meta_title`, `old_price`, `sku`, `hsn`, `custom_fields`, `vendor_id`, `variants`, `comp_group_id`) VALUES (8, 3, 10, 10, 'Dell Inspiron 15 Core i3 7th gen', '', 298, '678.00', 'Inspiron 3567', '0.00', '1553581739', 1, '2019-03-26 06:28:59', '2019-12-19 02:21:49', 52, 3, 2, 1, 'test-product-1', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000002', '1-002', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (9, 3, 10, 10, 'Dell Inspiron 5370 Intel', '', 3000, '687.00', 'Inspiron 5370', '0.00', '1553592693', 1, '2019-03-26 09:31:33', '2019-05-08 09:57:16', 101, 0, 5, 1, 'dell-inspiron-5370-intel', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000001', '1-001', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (10, 3, 10, 10, 'Dell Inspiron 7570 15.6-inch', '', 299, '654.00', 'Inspiron 7570', '0.00', '1553593759', 1, '2019-03-26 09:49:19', '2019-03-26 11:49:36', 53, 1, 2, 1, 'dell-inspiron-7570-15-6-inch', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000003', '1-003', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (11, 3, 11, 10, 'Dell G3 Series Core i5 8th Gen', '', 300, '567.00', 'G3 3579', '0.00', '1553594388', 1, '2019-03-26 09:59:48', '2019-03-26 09:59:48', 55, 0, 2, 1, 'dell-g3-series-core-i5-8th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000004', '1-004', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (12, 3, 11, 10, 'Dell G7 15 7000 Series Core i9 8th Gen', '', 200, '678.00', 'G7-7588', '0.00', '1553594612', 1, '2019-03-26 10:03:32', '2019-03-26 10:03:32', 57, 0, 2, 1, 'dell-g7-15-7000-series-core-i9-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000005', '1-005', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (13, 3, 12, 10, 'Dell XPS 13 Core i5 8th Gen', '', 300, '567.00', '9370', '0.00', '1553594869', 1, '2019-03-26 10:07:49', '2020-02-11 02:38:38', 99, 0, 2, 1, 'dell-xps-13-core-i5-8th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000006', '1-006', 'a:1:{s:0:\"\";N;}', 1, 'a:0:{}', 1), (14, 3, 12, 10, 'Dell XPS 13 Core i7 8th Gen', '', 277, '654.00', '9370', '0.00', '1553595098', 1, '2019-03-26 10:11:38', '2020-01-20 06:43:20', 61, 23, 2, 1, 'dell-xps-13-core-i7-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000007', '1-007', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (15, 3, 13, 10, 'Alienware Core i7 7th Gen', '', 294, '567.00', '17', '0.00', '1553595369', 1, '2019-03-26 10:16:09', '2020-01-20 04:04:15', 63, 6, 2, 1, 'alienware-core-i7-7th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000008', '1-008', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (16, 3, 13, 10, 'Alienware 15 Core i9 8th Gen', '', 193, '687.00', 'AW159321TB8S', '0.00', '1553595747', 1, '2019-03-26 10:22:27', '2020-02-11 02:38:03', 65, 7, 4, 1, 'alienware-15-core-i9-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000009', '1-009', 'a:1:{s:0:\"\";N;}', 1, 'a:0:{}', 1), (17, 3, 14, 10, 'Dell Inspiron 15 3000 Core i3 7th Gen', '', 288, '678.00', '15 3576', '0.00', '1553596085', 1, '2019-03-26 10:28:05', '2020-02-10 22:43:02', 97, 12, 2, 1, 'dell-inspiron-15-3000-core-i3-7th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000010', '1-010', 'a:1:{s:0:\"\";N;}', 1, 'a:0:{}', 1), (18, 3, 14, 10, 'Dell Inspiron Core i5 7th Gen', '', 176, '564.00', '5567', '0.00', '1553596318', 1, '2019-03-26 10:31:59', '2020-01-21 02:48:03', 96, 24, 2, 1, 'dell-inspiron-core-i5-7th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000011', '1-011', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (19, 3, 16, 8, 'HP Omen Core i7 8th Gen', '', 200, '678.00', '15-dc1006TX', '0.00', '1553598225', 1, '2019-03-26 11:03:45', '2019-03-26 11:03:45', 72, 0, 2, 1, 'hp-omen-core-i7-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000013', '1-013', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (20, 3, 15, NULL, 'HP Spectre x360 Core i7 8th Gen', '', 197, '786.00', '13-ae503TU', '0.00', '1553598553', 1, '2019-03-26 11:09:13', '2019-03-26 11:53:29', 74, 3, 2, 1, 'hp-spectre-x360-core-i7-8th-gen', NULL, NULL, 0, 0, '', '', '', '800.00', '1-000012', '1-012', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (21, 3, 17, 8, 'HP Envy 13 Core i3 8th Gen', '', 200, '786.00', '13-ah0042tu', '0.00', '1553598901', 1, '2019-03-26 11:15:01', '2019-05-08 09:53:14', 94, 0, 2, 1, 'hp-envy-13-core-i3-8th-gen', NULL, NULL, 0, 0, '', '', '', '800.00', '1-000014', '1-014', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (22, 3, 18, 8, 'HP Pavilion Core i7 8th Gen', '', 199, '567.00', '15-cx0144TX', '0.00', '1553599116', 1, '2019-03-26 11:18:36', '2019-05-08 09:52:02', 92, 1, 2, 1, 'hp-pavilion-core-i7-8th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000015', '1-015', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (23, 3, 19, 8, 'HP Core M 6th Gen', '', 199, '765.00', 'X2', '0.00', '1553599389', 1, '2019-03-26 11:23:09', '2019-03-26 11:51:53', 80, 1, 2, 1, 'hp-core-m-6th-gen', NULL, NULL, 0, 0, '', '', '', '800.00', '1-000016', '1-016', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (24, 3, 21, 8, 'HP Probook Core i5 8th Gen', '', 200, '786.00', 'Probook 440G5', '0.00', '1553599809', 1, '2019-03-26 11:30:09', '2019-05-08 09:50:54', 91, 0, 2, 1, 'hp-probook-core-i5-8th-gen', NULL, NULL, 0, 0, '', '', '', '800.00', '1-0000017', '1-017', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (25, 3, 24, 9, 'Lenovo Ideapad 330 Core i5 8th Gen', '', 199, '675.00', '330-15IKB', '0.00', '1553600045', 1, '2019-03-26 11:34:05', '2019-03-26 11:54:32', 84, 1, 2, 1, 'lenovo-ideapad-330-core-i5-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000018', '1-018', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (26, 3, 25, 9, 'Lenovo Yoga 730 Core i7 8th Gen', '', 200, '756.00', '730-13IKB', '0.00', '1553600380', 1, '2019-03-26 11:39:40', '2019-03-26 11:43:52', 86, 0, 2, 1, 'lenovo-yoga-730-core-i7-8th-gen', NULL, NULL, 0, 0, '', '', '', '800.00', '1-000019', '1-019', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (27, 3, 26, 9, 'Lenovo V series Core i3 6th Gen', '', 200, '450.00', 'v110', '0.00', '1557310581', 1, '2019-05-08 10:16:21', '2019-05-08 10:22:16', 102, 0, 2, 1, 'lenovo-v-series-core-i3-6th-gen', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000020', '1-020', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (28, 3, 27, 9, 'Lenovo Legion Core i7 7th Gen', '', 200, '568.00', 'Y520', '0.00', '1557310911', 1, '2019-05-08 10:21:51', '2019-05-08 10:21:51', 104, 0, 2, 1, 'lenovo-legion-core-i7-7th-gen', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000021', '1-021', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (29, 3, 28, 7, 'Apple MacBook Air Core i5 8th Gen', '', 98, '698.00', 'MREF2HN/A', '0.00', '1557311303', 1, '2019-05-08 10:28:23', '2020-01-21 02:50:14', 106, 2, 2, 1, 'apple-macbook-air-core-i5-8th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000022', '1-022', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (30, 3, 29, 7, 'Apple Mac mini Dual-core i5', '', 150, '678.00', 'MGEQ2HN/A', '0.00', '1557312039', 1, '2019-05-08 10:40:39', '2019-05-08 10:40:39', 108, 0, 2, 1, 'apple-mac-mini-dual-core-i5', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000023', '1-023', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (31, 3, 30, 7, 'Apple MacBook Pro Core i5 7th Gen', '', 140, '678.00', 'MPXQ2HN/A', '0.00', '1557312382', 1, '2019-05-08 10:46:22', '2019-05-08 10:46:22', 109, 0, 1, 1, 'apple-macbook-pro-core-i5-7th-gen', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000024', '1-024', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (32, 3, 40, 6, 'Samsung Galaxy S10', '', 120, '670.00', 'SM-G973FZKDINS', '0.00', '1557313693', 1, '2019-05-08 11:08:13', '2019-05-08 11:08:13', 111, 0, 1, 1, 'samsung-galaxy-s10', NULL, NULL, 0, 0, '', '', '', '680.00', '1-000025', '1-025', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (33, 3, 40, 6, 'Samsung Galaxy S10 Plus', '', 100, '780.00', 'SM-G975FZWDINS', '0.00', '1557313978', 1, '2019-05-08 11:12:58', '2019-05-08 11:12:58', 113, 0, 1, 1, 'samsung-galaxy-s10-plus', NULL, NULL, 0, 0, '', '', '', '800.00', '1-000026', '1-026', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (34, 3, 41, 6, 'Samsung Galaxy Note 8', '', 118, '480.00', 'SM-N950FZDDINS', '0.00', '1557314340', 1, '2019-05-08 11:19:00', '2019-12-11 05:42:02', 115, 2, 1, 1, 'samsung-galaxy-note-8', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000027', '1-027', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (35, 3, 41, 6, 'Samsung Galaxy Note 9', '', 120, '680.00', 'SM-N960FZKDINS', '0.00', '1557314556', 1, '2019-05-08 11:22:36', '2019-05-08 11:22:36', 117, 0, 1, 1, 'samsung-galaxy-note-9', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000028', '1-028', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (36, 3, 42, 6, 'Samsung Galaxy A50', '', 100, '690.00', 'SM-A505FZWGINS', '0.00', '1557315021', 1, '2019-05-08 11:30:21', '2019-05-08 11:30:21', 119, 0, 1, 1, 'samsung-galaxy-a50', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000029', '1-029', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (37, 3, 42, 6, 'Samsung Galaxy A30', '', 120, '580.00', 'SM-A305FZBFINS', '0.00', '1557315381', 1, '2019-05-08 11:36:21', '2019-05-08 11:36:21', 121, 0, 1, 1, 'samsung-galaxy-a30', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000030', '1-030', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (38, 3, 43, 6, 'Samsung Galaxy M30', '', 100, '690.00', 'SM-M305FZKGINS', '0.00', '1557315647', 1, '2019-05-08 11:40:47', '2019-05-08 11:40:47', 123, 0, 1, 1, 'samsung-galaxy-m30', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000031', '1-031', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (39, 3, 43, 6, 'Samsung Galaxy M20', '', 120, '490.00', 'M20', '0.00', '1557315979', 1, '2019-05-08 11:46:19', '2019-05-08 11:46:19', 125, 0, 1, 1, 'samsung-galaxy-m20', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000032', '1-032', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (40, 3, 44, 6, 'Samsung Galaxy J8', '', 200, '470.00', 'SM-J810GZKGINS', '0.00', '1557316236', 1, '2019-05-08 11:50:36', '2019-05-08 11:50:36', 127, 0, 2, 1, 'samsung-galaxy-j8', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000033', '1-033', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (41, 3, 44, 6, 'Samsung Galaxy J7 Prime', '', 120, '580.00', 'SM-G610FZKDINS', '0.00', '1557316487', 1, '2019-05-08 11:54:47', '2019-05-08 11:54:47', 129, 0, 2, 1, 'samsung-galaxy-j7-prime', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000034', '1-034', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (42, 3, 45, 6, 'Samsung Galaxy On8', '', 120, '590.00', 'SM-J810GZKFINS', '0.00', '1557317078', 1, '2019-05-08 12:04:38', '2019-05-08 12:04:38', 131, 0, 2, 1, 'samsung-galaxy-on8', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000035', '1-035', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (43, 3, 45, 6, 'Samsung Galaxy On Max', '', 198, '470.00', 'SM-G615FZDUINS', '0.00', '1557317332', 1, '2019-05-08 12:08:52', '2019-11-26 06:54:51', 133, 0, 2, 1, 'samsung-galaxy-on-max', NULL, NULL, 0, 0, '', '', '', '480.00', '1-000036', '1-036', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (44, 3, 46, 9, 'Lenovo P2', '', 200, '490.00', 'P2a42', '0.00', '1557317714', 1, '2019-05-08 12:15:14', '2019-05-08 12:15:14', 135, 0, 2, 1, 'lenovo-p2', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000037', '1-037', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (45, 3, 46, 9, 'Lenovo VIBE P1', '', 200, '390.00', 'VIBE P1', '0.00', '1557318030', 1, '2019-05-08 12:20:30', '2019-05-08 12:20:30', 137, 0, 2, 1, 'lenovo-vibe-p1', NULL, NULL, 0, 0, '', '', '', '400.00', '1-000038', '1-038', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (46, 3, 47, 9, 'Lenovo K8 Plus', '', 200, '280.00', 'K8 Plus', '0.00', '1557318247', 1, '2019-05-08 12:24:07', '2019-05-08 12:24:07', 139, 0, 2, 1, 'lenovo-k8-plus', NULL, NULL, 0, 0, '', '', '', '300.00', '1-000039', '1-039', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (47, 3, 47, 9, 'Lenovo K9', '', 200, '290.00', 'K9', '0.00', '1557318423', 1, '2019-05-08 12:27:03', '2019-12-26 03:38:27', 141, 0, 2, 1, 'lenovo-k9', NULL, NULL, 0, 0, '', '', '', '300.00', '1-000040', '1-040', 'a:1:{s:0:\"\";N;}', 1, 'a:2:{i:0;a:3:{s:1:\"n\";s:5:\"Color\";s:1:\"c\";s:1:\"1\";s:1:\"v\";a:2:{i:0;a:2:{s:1:\"n\";s:4:\"PINK\";s:1:\"p\";s:3:\"100\";}i:1;a:2:{s:1:\"n\";s:6:\"ORANGE\";s:1:\"p\";s:2:\"50\";}}}i:1;a:3:{s:1:\"n\";s:5:\"Sizes\";s:1:\"c\";s:1:\"0\";s:1:\"v\";a:1:{i:0;a:2:{s:1:\"n\";s:2:\"XL\";s:1:\"p\";s:3:\"100\";}}}}', NULL), (48, 3, 48, 9, 'Lenovo ZUK Z1', '', 196, '10.00', 'Z1221', '0.00', '1557318651', 1, '2019-05-08 12:30:51', '2019-12-19 02:27:23', 143, 4, 2, 1, 'lenovo-zuk-z1', NULL, NULL, 0, 0, '', '', '', '5.00', '1-000041', '1-041', 'a:1:{s:0:\"\";N;}', 1, 'a:0:{}', NULL), (49, 3, 49, 9, 'Lenovo A6000 Shot', '', 200, '280.00', 'A6000 Shot', '0.00', '1557319029', 1, '2019-05-08 12:37:09', '2019-05-08 12:37:09', 145, 0, 2, 1, 'lenovo-a6000-shot', NULL, NULL, 0, 0, '', '', '', '300.00', '1-000042', '1-042', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (50, 3, 49, 9, 'Lenovo A5', '', 200, '260.00', 'A5', '0.00', '1557319267', 1, '2019-05-08 12:41:08', '2019-05-08 12:41:08', 147, 0, 2, 1, 'lenovo-a5', NULL, NULL, 0, 0, '', '', '', '280.00', '1-000043', '1-043', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (51, 3, 51, 5, 'Sony Xperia XZ2', '', 200, '679.00', 'Xperia XZ2', '0.00', '1557320124', 1, '2019-05-08 12:55:24', '2019-05-08 12:55:24', 149, 0, 2, 1, 'sony-xperia-xz2', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000044', '1-044', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (52, 3, 52, 5, 'Sony Xperia L2', '', 200, '580.00', 'Xperia L2', '0.00', '1557320329', 1, '2019-05-08 12:58:49', '2019-05-08 12:58:49', 151, 0, 2, 1, 'sony-xperia-l2', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000045', '1-045', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (53, 3, 53, 5, 'Sony Xperia XA Ultra', '', 200, '590.00', 'Xperia XA Ultra', '0.00', '1557320482', 1, '2019-05-08 13:01:22', '2019-05-08 13:01:22', 153, 0, 2, 1, 'sony-xperia-xa-ultra', NULL, NULL, 0, 0, '', '', '', '600.00', '1-000046', '1-046', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (54, 3, 54, 5, 'Sony Xperia XZ', '', 200, '480.00', 'Xperia XZ', '0.00', '1557320679', 1, '2019-05-08 13:04:39', '2019-05-08 13:04:39', 155, 0, 2, 1, 'sony-xperia-xz', NULL, NULL, 0, 0, '', '', '', '500.00', '1-000047', '1-047', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (55, 3, 59, 7, 'Apple iPhone XR', '', 193, '680.00', 'MRY42HN/A', '0.00', '1557320853', 1, '2019-05-08 13:07:33', '2019-12-13 01:45:55', 157, 6, 2, 1, 'apple-iphone-xr', NULL, NULL, 0, 0, '', '', '', '700.00', '1-000048', '1-048', 'a:1:{s:0:\"\";N;}', 1, NULL, NULL), (56, 3, 60, 7, 'Apple iPhone 8', '', 999, '689.00', 'MQ7F2HN/A', '0.00', '1557321106', 1, '2019-05-08 13:11:46', '2019-12-11 05:24:01', 159, 4, 1, 1, 'apple-iphone-8', NULL, 1, 1, 1, '', '', '', '700.00', '1-000049', '1-049', 'a:1:{s:0:\"\";N;}', 1, 'a:0:{}', NULL), (57, 1, 12, 10, 'Dell XPS 13 Core i5 8th Gen', '', 300, '567.00', '9370', '0.00', '1576556654', 1, '2019-12-16 22:54:14', '2019-12-16 22:54:14', NULL, 0, 2, 1, 'dell-xps-13-core-i5-8th-gen-1', NULL, NULL, 0, 0, '', '', '', '600.00', '000006', '006', 'a:1:{s:0:\"\";N;}', NULL, 'a:0:{}', NULL), (58, 1, 26, 5, 'Testing Prod', '

Testing Prod Testing Prod Testing Prod Testing Prod

', 10, '90.00', 'k9370', '0.00', '1577353231', 1, '2019-12-26 04:10:31', '2020-02-10 06:27:17', 167, 0, 3, 1, 'testing-prod', NULL, NULL, 0, 0, '', '', '', '100.00', '000040', '040', 'a:1:{s:4:\"Size\";s:6:\"6 inch\";}', NULL, 'a:2:{i:0;a:3:{s:1:\"n\";s:5:\"Color\";s:1:\"c\";s:1:\"1\";s:1:\"v\";a:3:{i:0;a:2:{s:1:\"n\";s:5:\"GREEN\";s:1:\"p\";s:2:\"10\";}i:1;a:2:{s:1:\"n\";s:6:\"ORANGE\";s:1:\"p\";s:2:\"30\";}i:2;a:2:{s:1:\"n\";s:4:\"BLUE\";s:1:\"p\";s:2:\"50\";}}}i:1;a:3:{s:1:\"n\";s:5:\"Sizes\";s:1:\"c\";s:1:\"0\";s:1:\"v\";a:1:{i:0;a:2:{s:1:\"n\";s:2:\"XL\";s:1:\"p\";s:2:\"10\";}}}}', 1); -- -------------------------------------------------------- -- -- Table structure for table `product_specification_type` -- CREATE TABLE `product_specification_type` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `specification_type_id` int(10) UNSIGNED NOT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_specification_type` -- INSERT INTO `product_specification_type` (`id`, `product_id`, `specification_type_id`, `value`, `unit`, `created_at`, `updated_at`) VALUES (8, 8, 1, '3.26', 'kg', NULL, NULL), (9, 8, 2, 'black', NULL, NULL, NULL), (10, 9, 1, '1.5', 'Kg', NULL, NULL), (11, 9, 2, 'Silver', NULL, NULL, NULL), (12, 10, 1, '2.1', 'kg', NULL, NULL), (13, 10, 2, 'silver', NULL, NULL, NULL), (14, 11, 1, '2.5', 'kg', NULL, NULL), (15, 11, 2, 'Black', NULL, NULL, NULL), (16, 12, 1, '2.63', 'kg', NULL, NULL), (17, 12, 2, 'Licorice Black', NULL, NULL, NULL), (18, 13, 2, 'Silver', NULL, NULL, NULL), (19, 13, 1, '1.21', 'kg', NULL, NULL), (20, 14, 2, 'Gold', NULL, NULL, NULL), (21, 14, 1, '1.21', 'kg', NULL, NULL), (22, 15, 2, 'Anodized Aluminum', NULL, NULL, NULL), (23, 15, 1, '4.42', 'kg', NULL, NULL), (24, 16, 2, 'Epic Silver', NULL, NULL, NULL), (25, 16, 1, '3.49', 'kg', NULL, NULL), (26, 17, 2, 'Black', NULL, NULL, NULL), (27, 18, 2, 'Black', NULL, NULL, NULL), (28, 19, 2, 'Shadow Black', NULL, NULL, NULL), (29, 19, 1, '2.38', 'kg', NULL, NULL), (30, 20, 2, 'Dark Ash SIlver', NULL, NULL, NULL), (31, 20, 1, '1.26', 'kg', NULL, NULL), (32, 21, 2, 'Natural Silver', NULL, NULL, NULL), (33, 21, 1, '1.21', 'kg', NULL, NULL), (34, 22, 1, 'Shadow Black', NULL, NULL, NULL), (35, 23, 2, 'SIlver', NULL, NULL, NULL), (36, 23, 1, '1.21', 'kg', NULL, NULL), (37, 24, 2, 'Silver', NULL, NULL, NULL), (38, 25, 2, 'Onyx Black', NULL, NULL, NULL), (39, 26, 2, 'Platinum', NULL, NULL, NULL), (40, 27, 1, '1.9', 'kg', NULL, NULL), (41, 27, 2, 'black', NULL, NULL, NULL), (42, 28, 2, 'black', NULL, NULL, NULL), (43, 28, 1, '2.4', 'kg', NULL, NULL), (44, 29, 2, 'Gold', NULL, NULL, NULL), (45, 29, 1, '1.25', 'kg', NULL, NULL), (46, 30, 2, 'Silver', NULL, NULL, NULL), (47, 30, 1, '1.22', 'kg', NULL, NULL), (48, 31, 1, '1.37', 'kg', NULL, NULL), (49, 31, 2, 'Space Grey', NULL, NULL, NULL), (50, 32, 2, 'Prism Black', NULL, NULL, NULL), (51, 32, 1, '157', 'g', NULL, NULL), (52, 33, 2, 'Prism White', NULL, NULL, NULL), (53, 33, 1, '175', 'g', NULL, NULL), (54, 34, 2, 'Maple Gold', NULL, NULL, NULL), (55, 34, 1, '195', 'g', NULL, NULL), (56, 35, 2, 'Midnight Black', NULL, NULL, NULL), (57, 35, 1, '201', 'g', NULL, NULL), (58, 36, 2, 'White', NULL, NULL, NULL), (59, 36, 1, '166', 'g', NULL, NULL), (60, 37, 2, 'Blue', NULL, NULL, NULL), (61, 37, 1, '165', 'g', NULL, NULL), (62, 38, 2, 'Gradation Black', NULL, NULL, NULL), (63, 39, 2, 'Ocean Blue', NULL, NULL, NULL), (64, 39, 1, '186', 'g', NULL, NULL), (65, 40, 2, 'black', NULL, NULL, NULL), (66, 40, 1, '191', 'g', NULL, NULL), (67, 41, 2, 'black', NULL, NULL, NULL), (68, 42, 2, 'Black', NULL, NULL, NULL), (69, 43, 2, 'Gold', NULL, NULL, NULL), (70, 44, 2, 'Gold', NULL, NULL, NULL), (71, 45, 2, 'Grey', NULL, NULL, NULL), (72, 46, 2, 'Fine Gold', NULL, NULL, NULL), (73, 47, 2, 'black', NULL, NULL, NULL), (74, 48, 2, 'Space Grey', NULL, NULL, NULL), (75, 49, 1, NULL, NULL, NULL, NULL), (76, 50, 2, 'black', NULL, NULL, NULL), (77, 51, 2, 'Liquid Black', NULL, NULL, NULL), (78, 52, 2, 'Gold', NULL, NULL, NULL), (79, 53, 2, 'Graphite Black', NULL, NULL, NULL), (80, 54, 2, 'Platinum', NULL, NULL, NULL), (81, 55, 2, 'black', NULL, NULL, NULL), (82, 56, 2, 'Space Grey', NULL, NULL, NULL), (83, 47, 1, '100', 'gm', NULL, NULL), (84, 57, 2, 'Silver', NULL, NULL, NULL), (85, 57, 1, '1.21', 'kg', NULL, NULL), (86, 58, 1, '100', 'kg', NULL, NULL), (87, 17, 1, '500', 'gm', NULL, NULL), (88, 13, 3, '512', 'GB', NULL, NULL), (89, 13, 4, '500', 'MAH', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `related_products` -- CREATE TABLE `related_products` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(11) NOT NULL, `related_product_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `related_products` -- INSERT INTO `related_products` (`id`, `product_id`, `related_product_id`, `created_at`, `updated_at`) VALUES (1, 58, 44, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `product_id` int(10) UNSIGNED DEFAULT NULL, `rating` tinyint(3) UNSIGNED DEFAULT NULL, `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `approved` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reviews` -- INSERT INTO `reviews` (`id`, `user_id`, `product_id`, `rating`, `comment`, `approved`, `created_at`, `updated_at`) VALUES (2, 1, 41, 5, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, '2019-11-26 04:33:25', '2019-11-26 04:35:53'), (3, 1, 56, 4, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, '2019-11-26 06:57:39', '2019-11-26 07:01:56'), (4, 1, 16, 4, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 0, '2019-11-26 07:01:31', '2020-02-06 01:09:23'); -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `date` datetime NOT NULL, `sales` int(10) UNSIGNED NOT NULL DEFAULT 0, `order_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `product_id`, `date`, `sales`, `order_id`) VALUES (17, 8, '2019-03-26 06:30:17', 1, 8), (18, 10, '2019-03-26 11:49:36', 1, 9), (19, 20, '2019-03-26 11:49:36', 1, 9), (22, 16, '2019-03-26 11:51:27', 1, 11), (23, 23, '2019-03-26 11:51:53', 1, 12), (24, 22, '2019-03-26 11:52:30', 1, 13), (25, 20, '2019-03-26 11:52:59', 1, 14), (26, 20, '2019-03-26 11:53:29', 1, 15), (27, 25, '2019-03-26 11:54:32', 1, 16), (28, 15, '2019-03-26 12:00:52', 1, 17), (30, 56, '2019-11-27 04:28:52', 1, 19), (31, 55, '2019-11-27 04:28:52', 1, 19), (32, 18, '2019-11-29 11:38:14', 1, 30), (33, 18, '2019-11-29 11:39:37', 1, 31), (34, 34, '2019-11-30 07:08:43', 1, 42), (35, 18, '2019-12-02 04:23:17', 1, 43), (36, 18, '2019-12-02 07:14:16', 1, 50), (37, 18, '2019-12-02 09:36:58', 1, 64), (38, 18, '2019-12-02 09:38:46', 1, 65), (39, 18, '2019-12-02 09:45:31', 1, 66), (40, 18, '2019-12-02 10:54:30', 1, 72), (41, 18, '2019-12-02 10:58:01', 1, 73), (42, 18, '2019-12-02 11:11:15', 1, 77), (43, 18, '2019-12-02 11:13:09', 1, 79), (44, 18, '2019-12-02 11:15:34', 1, 80), (45, 18, '2019-12-02 11:16:08', 1, 81), (46, 18, '2019-12-02 11:32:57', 1, 82), (47, 18, '2019-12-02 11:46:43', 1, 85), (48, 18, '2019-12-02 11:47:52', 1, 86), (49, 18, '2019-12-02 12:01:19', 1, 89), (50, 56, '2019-12-04 10:27:16', 1, 99), (51, 56, '2019-12-04 10:28:29', 1, 99), (52, 18, '2019-12-04 11:30:06', 1, 103), (53, 18, '2019-12-05 05:33:50', 1, 104), (54, 18, '2019-12-05 05:46:19', 1, 108), (56, 55, '2019-12-11 10:26:14', 1, 114), (57, 56, '2019-12-11 10:54:01', 1, 118), (58, 34, '2019-12-11 11:12:02', 1, 119), (59, 55, '2019-12-12 09:13:19', 1, 121), (60, 55, '2019-12-12 09:16:24', 1, 122), (61, 55, '2019-12-12 09:34:36', 1, 123), (62, 55, '2019-12-13 07:15:55', 1, 124), (63, 17, '2019-12-14 08:30:01', 1, 125), (64, 8, '2019-12-19 07:50:57', 1, 8), (65, 8, '2019-12-19 07:51:49', 1, 8), (66, 48, '2019-12-19 07:54:51', 1, 153), (67, 48, '2019-12-19 07:55:44', 1, 153), (68, 48, '2019-12-19 07:56:54', 1, 153), (69, 48, '2019-12-19 07:57:23', 1, 153), (70, 15, '2019-12-27 06:42:02', 1, 154), (71, 29, '2019-12-28 05:59:37', 1, 157), (72, 15, '2020-01-20 04:46:35', 1, 158), (73, 15, '2020-01-20 09:06:51', 1, 159), (74, 15, '2020-01-20 09:32:39', 1, 160), (75, 15, '2020-01-20 09:34:15', 1, 161), (76, 14, '2020-01-20 09:34:58', 1, 162), (77, 14, '2020-01-20 09:35:39', 1, 163), (78, 14, '2020-01-20 11:18:30', 1, 176), (79, 14, '2020-01-20 11:50:27', 1, 177), (80, 14, '2020-01-20 11:52:43', 1, 178), (81, 14, '2020-01-20 11:55:04', 1, 179), (82, 14, '2020-01-20 11:55:56', 1, 180), (83, 14, '2020-01-20 11:59:36', 1, 181), (84, 14, '2020-01-20 12:02:39', 2, 182), (85, 14, '2020-01-20 12:04:00', 1, 183), (86, 14, '2020-01-20 12:04:39', 1, 184), (87, 14, '2020-01-20 12:05:29', 2, 185), (88, 14, '2020-01-20 12:06:09', 1, 186), (89, 14, '2020-01-20 12:08:12', 1, 187), (90, 14, '2020-01-20 12:09:27', 1, 188), (91, 14, '2020-01-20 12:09:56', 1, 189), (92, 14, '2020-01-20 12:11:01', 2, 190), (93, 14, '2020-01-20 12:11:28', 1, 191), (94, 14, '2020-01-20 12:13:20', 1, 192), (95, 16, '2020-01-20 12:15:00', 1, 193), (96, 16, '2020-01-20 12:15:32', 1, 194), (97, 16, '2020-01-20 12:16:05', 1, 195), (98, 16, '2020-01-20 12:16:28', 1, 196), (99, 16, '2020-01-20 12:17:09', 2, 197), (100, 17, '2020-01-21 05:31:37', 1, 198), (101, 17, '2020-01-21 05:39:11', 1, 199), (102, 17, '2020-01-21 05:47:05', 1, 200), (103, 17, '2020-01-21 05:48:06', 1, 201), (104, 17, '2020-01-21 05:52:37', 2, 202), (105, 17, '2020-01-21 05:53:08', 2, 203), (106, 17, '2020-01-21 05:53:52', 1, 204), (107, 17, '2020-01-21 05:56:35', 2, 205), (108, 18, '2020-01-21 06:34:06', 1, 206), (109, 18, '2020-01-21 06:36:54', 1, 207), (110, 18, '2020-01-21 07:25:45', 1, 208), (111, 18, '2020-01-21 08:18:03', 1, 209), (112, 29, '2020-01-21 08:20:14', 1, 210); -- -------------------------------------------------------- -- -- Table structure for table `specification_types` -- CREATE TABLE `specification_types` ( `id` int(10) UNSIGNED NOT NULL, `location_id` int(10) UNSIGNED DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `specification_types` -- INSERT INTO `specification_types` (`id`, `location_id`, `name`, `created_at`, `updated_at`) VALUES (1, 1, 'Weight', '2019-03-11 08:37:17', '2019-03-11 08:37:17'), (2, 1, 'Color', '2019-03-11 08:37:21', '2019-03-11 08:37:21'), (3, 1, 'RAM', '2020-02-11 02:41:58', '2020-02-11 02:41:58'), (4, 1, 'Battery', '2020-02-11 02:42:06', '2020-02-11 02:42:06'); -- -------------------------------------------------------- -- -- Table structure for table `testimonials` -- CREATE TABLE `testimonials` ( `id` int(10) UNSIGNED NOT NULL, `photo_id` int(10) UNSIGNED DEFAULT NULL, `author` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `review` text COLLATE utf8mb4_unicode_ci NOT NULL, `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `priority` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `testimonials` -- INSERT INTO `testimonials` (`id`, `photo_id`, `author`, `review`, `designation`, `is_active`, `priority`, `created_at`, `updated_at`) VALUES (1, 88, 'Jones Smith', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '', 1, 1, '2019-03-26 11:46:44', '2019-03-26 11:46:44'), (2, 89, 'Daniel Craig', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', '', 1, 1, '2019-03-26 11:48:08', '2019-03-26 11:48:08'); -- -------------------------------------------------------- -- -- Table structure for table `vendor_amounts` -- CREATE TABLE `vendor_amounts` ( `id` int(10) UNSIGNED NOT NULL, `order_id` int(10) UNSIGNED DEFAULT NULL, `product_id` int(10) UNSIGNED DEFAULT NULL, `vendor_id` int(10) UNSIGNED DEFAULT NULL, `product_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_quantity` int(11) DEFAULT NULL, `unit_price` decimal(12,2) UNSIGNED DEFAULT NULL, `total_price` decimal(12,2) UNSIGNED DEFAULT NULL, `vendor_amount` decimal(12,2) UNSIGNED DEFAULT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'outstanding', `outstanding_date` datetime DEFAULT NULL, `earned_date` datetime DEFAULT NULL, `payment_date` datetime DEFAULT NULL, `cancel_date` datetime DEFAULT NULL, `processed` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `vendor_payment_id` int(10) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `vendor_amounts` -- INSERT INTO `vendor_amounts` (`id`, `order_id`, `product_id`, `vendor_id`, `product_name`, `product_quantity`, `unit_price`, `total_price`, `vendor_amount`, `currency`, `status`, `outstanding_date`, `earned_date`, `payment_date`, `cancel_date`, `processed`, `vendor_payment_id`) VALUES (17, 8, 8, 1, 'test product 1', 1, '10.00', '10.00', '6.00', 'USD', 'paid', '2019-03-26 06:30:17', '2019-03-26 11:55:46', '2019-03-26 12:00:16', NULL, 1, 1), (18, 9, 10, 1, 'Dell Inspiron 7570 15.6-inch', 1, '654.00', '654.00', '392.40', 'USD', 'paid', '2019-03-26 11:49:36', '2019-03-26 11:55:50', '2019-03-26 12:00:16', NULL, 1, 1), (19, 9, 20, 1, 'HP Spectre x360 Core i7 8th Gen', 1, '786.00', '786.00', '471.60', 'USD', 'paid', '2019-03-26 11:49:36', '2019-03-26 11:55:50', '2019-03-26 12:00:16', NULL, 1, 1), (20, 10, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'USD', 'cancelled', '2019-03-26 11:50:52', NULL, NULL, '2019-03-26 11:55:58', 0, NULL), (21, 10, 21, 1, 'HP Envy 13 Core i3 8th Gen', 1, '786.00', '786.00', '471.60', 'USD', 'cancelled', '2019-03-26 11:50:52', NULL, NULL, '2019-03-26 11:55:58', 0, NULL), (22, 11, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'USD', 'paid', '2019-03-26 11:51:27', '2019-03-26 11:56:09', '2019-03-26 12:00:16', NULL, 1, 1), (23, 12, 23, 1, 'HP Core M 6th Gen', 1, '765.00', '765.00', '459.00', 'USD', 'outstanding', '2019-03-26 11:51:53', NULL, NULL, NULL, 0, NULL), (24, 13, 22, 1, 'HP Pavilion Core i7 8th Gen', 1, '567.00', '567.00', '340.20', 'USD', 'paid', '2019-03-26 11:52:30', '2019-03-26 11:56:13', '2019-03-26 12:00:16', NULL, 1, 1), (25, 14, 20, 1, 'HP Spectre x360 Core i7 8th Gen', 1, '786.00', '786.00', '471.60', 'USD', 'outstanding', '2019-03-26 11:52:59', NULL, NULL, NULL, 0, NULL), (26, 15, 20, 1, 'HP Spectre x360 Core i7 8th Gen', 1, '786.00', '786.00', '471.60', 'USD', 'outstanding', '2019-03-26 11:53:29', NULL, NULL, NULL, 0, NULL), (27, 16, 25, 1, 'Lenovo Ideapad 330 Core i5 8th Gen', 1, '675.00', '675.00', '405.00', 'USD', 'paid', '2019-03-26 11:54:32', '2019-03-26 11:56:19', '2019-03-26 12:00:16', NULL, 1, 1), (28, 17, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'USD', 'paid', '2019-03-26 12:00:52', '2019-11-22 12:19:34', '2019-11-27 11:02:53', NULL, 1, 2), (30, 19, 56, 1, 'Apple iPhone 8', 1, '689.00', '689.00', '413.40', 'USD', 'outstanding', '2019-11-27 04:28:52', NULL, NULL, NULL, 0, NULL), (31, 19, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'USD', 'outstanding', '2019-11-27 04:28:52', NULL, NULL, NULL, 0, NULL), (32, 30, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'USD', 'earned', NULL, '2019-11-29 11:38:14', NULL, NULL, 0, NULL), (33, 31, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'USD', 'earned', NULL, '2019-11-29 11:39:37', NULL, NULL, 0, NULL), (34, 42, 34, 1, 'Samsung Galaxy Note 8', 1, '480.00', '480.00', '288.00', 'NGN', 'earned', NULL, '2019-11-30 07:08:43', NULL, NULL, 0, NULL), (35, 43, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'NGN', 'earned', NULL, '2019-12-02 04:23:17', NULL, NULL, 0, NULL), (36, 50, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'USD', 'earned', NULL, '2019-12-02 07:14:16', NULL, NULL, 0, NULL), (37, 64, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 09:36:58', NULL, NULL, 0, NULL), (38, 65, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 09:38:46', NULL, NULL, 0, NULL), (39, 66, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 09:45:31', NULL, NULL, 0, NULL), (40, 72, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 10:54:30', NULL, NULL, 0, NULL), (41, 73, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 10:58:01', NULL, NULL, 0, NULL), (42, 77, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 11:11:15', NULL, NULL, 0, NULL), (43, 79, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 11:13:09', NULL, NULL, 0, NULL), (44, 80, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 11:15:34', NULL, NULL, 0, NULL), (45, 81, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 11:16:08', NULL, NULL, 0, NULL), (46, 82, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 11:32:57', NULL, NULL, 0, NULL), (47, 85, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'USD', 'earned', NULL, '2019-12-02 11:46:43', NULL, NULL, 0, NULL), (48, 86, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'USD', 'earned', NULL, '2019-12-02 11:47:52', NULL, NULL, 0, NULL), (49, 89, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-02 12:01:19', NULL, NULL, 0, NULL), (50, 99, 56, 1, 'Apple iPhone 8', 1, '689.00', '689.00', '413.40', 'RSD', 'earned', NULL, '2019-12-04 10:27:17', NULL, NULL, 0, NULL), (51, 99, 56, 1, 'Apple iPhone 8', 1, '689.00', '689.00', '413.40', 'RSD', 'earned', NULL, '2019-12-04 10:28:29', NULL, NULL, 0, NULL), (52, 103, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'earned', NULL, '2019-12-04 11:30:06', NULL, NULL, 0, NULL), (53, 104, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'NGN', 'earned', NULL, '2019-12-05 05:33:50', NULL, NULL, 0, NULL), (54, 108, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'NGN', 'earned', NULL, '2019-12-05 05:46:19', NULL, NULL, 0, NULL), (55, NULL, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'USD', 'outstanding', '2019-12-11 07:57:20', NULL, NULL, NULL, 0, NULL), (56, 114, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'INR', 'earned', NULL, '2019-12-11 10:26:14', NULL, NULL, 0, NULL), (57, 118, 56, 1, 'Apple iPhone 8', 1, '689.00', '689.00', '413.40', 'INR', 'earned', NULL, '2019-12-11 10:54:01', NULL, NULL, 0, NULL), (58, 119, 34, 1, 'Samsung Galaxy Note 8', 1, '480.00', '480.00', '288.00', 'INR', 'outstanding', '2019-12-11 11:12:02', NULL, NULL, NULL, 0, NULL), (59, 121, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'INR', 'outstanding', '2019-12-12 09:13:18', NULL, NULL, NULL, 0, NULL), (60, 122, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'INR', 'earned', '2019-12-12 09:16:24', '2019-12-13 06:39:31', NULL, NULL, 0, NULL), (61, 123, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'INR', 'earned', '2019-12-12 09:34:36', '2019-12-12 09:38:40', NULL, NULL, 0, NULL), (62, 124, 55, 1, 'Apple iPhone XR', 1, '680.00', '680.00', '408.00', 'INR', 'outstanding', '2019-12-13 07:15:55', NULL, NULL, NULL, 0, NULL), (63, 125, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2019-12-14 08:30:01', NULL, NULL, NULL, 0, NULL), (64, 8, 8, 1, 'Dell Inspiron 15 Core i3 7th gen', 1, '10.00', '10.00', '6.00', 'USD', 'earned', NULL, '2019-12-19 07:50:58', NULL, NULL, 0, NULL), (65, 8, 8, 1, 'Dell Inspiron 15 Core i3 7th gen', 1, '10.00', '10.00', '6.00', 'USD', 'earned', NULL, '2019-12-19 07:51:49', NULL, NULL, 0, NULL), (66, 153, 48, 1, 'Lenovo ZUK Z1', 1, '10.00', '10.00', '6.00', 'KES', 'earned', NULL, '2019-12-19 07:54:51', NULL, NULL, 0, NULL), (67, 153, 48, 1, 'Lenovo ZUK Z1', 1, '10.00', '10.00', '6.00', 'KES', 'earned', NULL, '2019-12-19 07:55:44', NULL, NULL, 0, NULL), (68, 153, 48, 1, 'Lenovo ZUK Z1', 1, '10.00', '10.00', '6.00', 'KES', 'earned', NULL, '2019-12-19 07:56:54', NULL, NULL, 0, NULL), (69, 153, 48, 1, 'Lenovo ZUK Z1', 1, '10.00', '10.00', '6.00', 'KES', 'earned', NULL, '2019-12-19 07:57:23', NULL, NULL, 0, NULL), (70, 154, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'KES', 'outstanding', '2019-12-27 06:42:02', NULL, NULL, NULL, 0, NULL), (71, 157, 29, 1, 'Apple MacBook Air Core i5 8th Gen', 1, '698.00', '698.00', '418.80', 'KES', 'earned', '2019-12-28 05:59:37', '2019-12-28 06:03:15', NULL, NULL, 0, NULL), (72, 158, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'USD', 'outstanding', '2020-01-20 04:46:35', NULL, NULL, NULL, 0, NULL), (73, 159, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'INR', 'outstanding', '2020-01-20 09:06:51', NULL, NULL, NULL, 0, NULL), (74, 160, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'INR', 'outstanding', '2020-01-20 09:32:39', NULL, NULL, NULL, 0, NULL), (75, 161, 15, 1, 'Alienware Core i7 7th Gen', 1, '567.00', '567.00', '340.20', 'INR', 'outstanding', '2020-01-20 09:34:15', NULL, NULL, NULL, 0, NULL), (76, 162, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:34:58', NULL, NULL, NULL, 0, NULL), (77, 163, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:35:39', NULL, NULL, NULL, 0, NULL), (78, 164, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:37:20', NULL, NULL, NULL, 0, NULL), (79, 165, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:37:51', NULL, NULL, NULL, 0, NULL), (80, 166, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:41:14', NULL, NULL, NULL, 0, NULL), (81, 167, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:45:23', NULL, NULL, NULL, 0, NULL), (82, 168, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:48:00', NULL, NULL, NULL, 0, NULL), (83, 169, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 09:49:00', NULL, NULL, NULL, 0, NULL), (84, 170, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 2, '654.00', '1308.00', '784.80', 'INR', 'outstanding', '2020-01-20 09:55:05', NULL, NULL, NULL, 0, NULL), (85, 171, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 2, '654.00', '1308.00', '784.80', 'INR', 'outstanding', '2020-01-20 10:00:38', NULL, NULL, NULL, 0, NULL), (86, 172, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 10:13:55', NULL, NULL, NULL, 0, NULL), (87, 173, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 10:14:50', NULL, NULL, NULL, 0, NULL), (88, 174, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 10:25:30', NULL, NULL, NULL, 0, NULL), (89, 175, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 10:27:53', NULL, NULL, NULL, 0, NULL), (90, 176, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:18:30', NULL, NULL, NULL, 0, NULL), (91, 177, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:50:27', NULL, NULL, NULL, 0, NULL), (92, 178, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:52:43', NULL, NULL, NULL, 0, NULL), (93, 179, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:55:04', NULL, NULL, NULL, 0, NULL), (94, 180, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:55:56', NULL, NULL, NULL, 0, NULL), (95, 181, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 11:59:36', NULL, NULL, NULL, 0, NULL), (96, 182, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 2, '654.00', '1308.00', '784.80', 'INR', 'outstanding', '2020-01-20 12:02:39', NULL, NULL, NULL, 0, NULL), (97, 183, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:04:00', NULL, NULL, NULL, 0, NULL), (98, 184, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:04:39', NULL, NULL, NULL, 0, NULL), (99, 185, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 2, '654.00', '1308.00', '784.80', 'INR', 'outstanding', '2020-01-20 12:05:29', NULL, NULL, NULL, 0, NULL), (100, 186, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:06:09', NULL, NULL, NULL, 0, NULL), (101, 187, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:08:12', NULL, NULL, NULL, 0, NULL), (102, 188, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:09:27', NULL, NULL, NULL, 0, NULL), (103, 189, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:09:56', NULL, NULL, NULL, 0, NULL), (104, 190, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 2, '654.00', '1308.00', '784.80', 'INR', 'outstanding', '2020-01-20 12:11:01', NULL, NULL, NULL, 0, NULL), (105, 191, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:11:28', NULL, NULL, NULL, 0, NULL), (106, 192, 14, 1, 'Dell XPS 13 Core i7 8th Gen', 1, '654.00', '654.00', '392.40', 'INR', 'outstanding', '2020-01-20 12:13:20', NULL, NULL, NULL, 0, NULL), (107, 193, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'INR', 'outstanding', '2020-01-20 12:15:00', NULL, NULL, NULL, 0, NULL), (108, 194, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'INR', 'outstanding', '2020-01-20 12:15:32', NULL, NULL, NULL, 0, NULL), (109, 195, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'INR', 'outstanding', '2020-01-20 12:16:05', NULL, NULL, NULL, 0, NULL), (110, 196, 16, 1, 'Alienware 15 Core i9 8th Gen', 1, '687.00', '687.00', '412.20', 'INR', 'outstanding', '2020-01-20 12:16:28', NULL, NULL, NULL, 0, NULL), (111, 197, 16, 1, 'Alienware 15 Core i9 8th Gen', 2, '687.00', '1374.00', '824.40', 'INR', 'outstanding', '2020-01-20 12:17:09', NULL, NULL, NULL, 0, NULL), (112, 198, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2020-01-21 05:31:37', NULL, NULL, NULL, 0, NULL), (113, 199, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2020-01-21 05:39:11', NULL, NULL, NULL, 0, NULL), (114, 200, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2020-01-21 05:47:05', NULL, NULL, NULL, 0, NULL), (115, 201, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2020-01-21 05:48:06', NULL, NULL, NULL, 0, NULL), (116, 202, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 2, '678.00', '1356.00', '813.60', 'INR', 'outstanding', '2020-01-21 05:52:37', NULL, NULL, NULL, 0, NULL), (117, 203, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 2, '678.00', '1356.00', '813.60', 'INR', 'outstanding', '2020-01-21 05:53:08', NULL, NULL, NULL, 0, NULL), (118, 204, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 1, '678.00', '678.00', '406.80', 'INR', 'outstanding', '2020-01-21 05:53:52', NULL, NULL, NULL, 0, NULL), (119, 205, 17, 1, 'Dell Inspiron 15 3000 Core i3 7th Gen', 2, '678.00', '1356.00', '813.60', 'INR', 'outstanding', '2020-01-21 05:56:35', NULL, NULL, NULL, 0, NULL), (120, 206, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'outstanding', '2020-01-21 06:34:06', NULL, NULL, NULL, 0, NULL), (121, 207, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'outstanding', '2020-01-21 06:36:54', NULL, NULL, NULL, 0, NULL), (122, 208, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'outstanding', '2020-01-21 07:25:45', NULL, NULL, NULL, 0, NULL), (123, 209, 18, 1, 'Dell Inspiron Core i5 7th Gen', 1, '564.00', '564.00', '338.40', 'INR', 'outstanding', '2020-01-21 08:18:03', NULL, NULL, NULL, 0, NULL), (124, 210, 29, 1, 'Apple MacBook Air Core i5 8th Gen', 1, '698.00', '698.00', '418.80', 'INR', 'outstanding', '2020-01-21 08:20:14', NULL, NULL, NULL, 0, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `banners` -- ALTER TABLE `banners` ADD PRIMARY KEY (`id`), ADD KEY `banners_photo_id_index` (`photo_id`), ADD KEY `banners_location_id_index` (`location_id`), ADD KEY `banners_category_id_index` (`category_id`), ADD KEY `banners_brand_id_index` (`brand_id`); -- -- Indexes for table `brands` -- ALTER TABLE `brands` ADD PRIMARY KEY (`id`), ADD KEY `brands_photo_id_index` (`photo_id`), ADD KEY `brands_location_id_index` (`location_id`), ADD KEY `brands_voucher_id_index` (`voucher_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD KEY `categories_category_id_index` (`category_id`), ADD KEY `categories_location_id_index` (`location_id`), ADD KEY `categories_voucher_id_index` (`voucher_id`), ADD KEY `categories_photo_id_index` (`photo_id`); -- -- Indexes for table `category_specification_type` -- ALTER TABLE `category_specification_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comparision_groups` -- ALTER TABLE `comparision_groups` ADD PRIMARY KEY (`cg_id`); -- -- Indexes for table `deals` -- ALTER TABLE `deals` ADD PRIMARY KEY (`id`), ADD KEY `deals_location_id_index` (`location_id`); -- -- Indexes for table `deal_product` -- ALTER TABLE `deal_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `photos` -- ALTER TABLE `photos` ADD PRIMARY KEY (`id`), ADD KEY `photos_product_id_index` (`product_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `products_sku_unique` (`sku`), ADD KEY `products_user_id_index` (`user_id`), ADD KEY `products_category_id_index` (`category_id`), ADD KEY `products_brand_id_index` (`brand_id`), ADD KEY `products_photo_id_index` (`photo_id`), ADD KEY `products_location_id_index` (`location_id`), ADD KEY `products_voucher_id_index` (`voucher_id`), ADD KEY `products_vendor_id_index` (`vendor_id`), ADD KEY `products_comp_group_id_index` (`comp_group_id`); -- -- Indexes for table `product_specification_type` -- ALTER TABLE `product_specification_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `related_products` -- ALTER TABLE `related_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD KEY `reviews_user_id_index` (`user_id`), ADD KEY `reviews_product_id_index` (`product_id`); -- -- Indexes for table `sales` -- ALTER TABLE `sales` ADD PRIMARY KEY (`id`), ADD KEY `sales_product_id_index` (`product_id`), ADD KEY `sales_order_id_index` (`order_id`); -- -- Indexes for table `specification_types` -- ALTER TABLE `specification_types` ADD PRIMARY KEY (`id`), ADD KEY `specification_types_location_id_index` (`location_id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`), ADD KEY `testimonials_photo_id_index` (`photo_id`); -- -- Indexes for table `vendor_amounts` -- ALTER TABLE `vendor_amounts` ADD PRIMARY KEY (`id`), ADD KEY `vendor_amounts_order_id_index` (`order_id`), ADD KEY `vendor_amounts_product_id_index` (`product_id`), ADD KEY `vendor_amounts_vendor_id_index` (`vendor_id`), ADD KEY `vendor_amounts_vendor_payment_id_index` (`vendor_payment_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `banners` -- ALTER TABLE `banners` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `brands` -- ALTER TABLE `brands` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68; -- -- AUTO_INCREMENT for table `category_specification_type` -- ALTER TABLE `category_specification_type` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `comparision_groups` -- ALTER TABLE `comparision_groups` MODIFY `cg_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `deals` -- ALTER TABLE `deals` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `deal_product` -- ALTER TABLE `deal_product` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `photos` -- ALTER TABLE `photos` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59; -- -- AUTO_INCREMENT for table `product_specification_type` -- ALTER TABLE `product_specification_type` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90; -- -- AUTO_INCREMENT for table `related_products` -- ALTER TABLE `related_products` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sales` -- ALTER TABLE `sales` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113; -- -- AUTO_INCREMENT for table `specification_types` -- ALTER TABLE `specification_types` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `vendor_amounts` -- ALTER TABLE `vendor_amounts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125; -- -- Constraints for dumped tables -- -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `products_comp_group_id_foreign` FOREIGN KEY (`comp_group_id`) REFERENCES `comparision_groups` (`cg_id`) ON DELETE CASCADE, ADD CONSTRAINT `products_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE SET NULL; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `sales` -- ALTER TABLE `sales` ADD CONSTRAINT `sales_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `sales_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `vendor_amounts` -- ALTER TABLE `vendor_amounts` ADD CONSTRAINT `vendor_amounts_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `vendor_amounts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `vendor_amounts_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;