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

START TRANSACTION;



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

--
-- Table structure for table `category_widget`
--

CREATE TABLE `category_widget` (
  `id` int(11) NOT NULL,
  `category_title` varchar(100) NOT NULL,
  `main_image` varchar(100) NOT NULL,
  `gallery` blob NOT NULL,
  `min_price` double NOT NULL,
  `url_string` varchar(255) NOT NULL,
  `button_caption` varchar(50) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `deleted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cms_banner`
--

CREATE TABLE `cms_banner` (
  `id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `banner_title` varchar(255) DEFAULT NULL,
  `banner_subtitle` varchar(255) DEFAULT NULL,
  `url_string` varchar(255) DEFAULT NULL,
  `url_label` varchar(255) DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `date_created` varchar(20) DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_banner`
--

INSERT INTO `cms_banner` (`id`, `group_id`, `banner_title`, `banner_subtitle`, `url_string`, `url_label`, `image`, `date_created`, `expired_date`, `start_date`, `is_active`, `description`) VALUES
(14, 1, 'Huawei Honor 8x | 8x Max', 'The Smart Power In Your Hand', 'https://globalmart.com', 'Leean More', '431313bab4f26e43197dc754213a9592.png', '1597193549679', '1970-01-01', '1970-01-01', 0, NULL),
(15, 1, 'Samsung Galaxy S9 | S9+', 'The Camera Re-Imagined', 'https://globalmart.com', 'Shop now', '7429fd539f388c514b56b4f7bbd8b635.png', '1597193619436', '1970-01-01', '1970-01-01', 0, NULL);

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

--
-- Table structure for table `cms_banner_group`
--

CREATE TABLE `cms_banner_group` (
  `id` int(11) NOT NULL,
  `group_name` varchar(100) NOT NULL,
  `width_px` int(11) NOT NULL,
  `height_px` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `active` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_banner_group`
--

INSERT INTO `cms_banner_group` (`id`, `group_name`, `width_px`, `height_px`, `description`, `active`) VALUES
(1, 'First screen Banners', 555, 440, NULL, 1);

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

--
-- Table structure for table `cms_section`
--

CREATE TABLE `cms_section` (
  `id` int(11) NOT NULL,
  `section_slug` varchar(100) NOT NULL,
  `section_image` varchar(255) DEFAULT NULL,
  `section_content` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_section`
--

INSERT INTO `cms_section` (`id`, `section_slug`, `section_image`, `section_content`) VALUES
(5, 'about-us', NULL, '<div class=\"\"><div class=\"content-box\"><h2>We Made The Easiest Possible Way To Buy Online</h2><p> Test here commodo viverra maecenas. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. </p></div><div class=\"content-box\"><h4>Our Mission</h4><p> Risus commodo viverra maecenas. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. </p></div><div class=\"content-box\"><h4>Our Vision</h4><p> Risus commodo viverra maecenas. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. </p></div><div class=\"content-box\"><h4>Our Goal</h4><p> Risus commodo viverra maecenas. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. </p></div></div>'),
(6, 'footer-text', NULL, '<h4>TALAR</h4>\n<p> Lorem ipsum dolor sit amet consectetur adipisicing elit. Sequi voluptatum enim veniam quaerat quia ab libero consequatur soluta aliquam ipsum. </p>');

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

--
-- Table structure for table `commine`
--

CREATE TABLE `commine` (
  `id` int(11) NOT NULL,
  `commune_name` varchar(100) DEFAULT NULL,
  `atribute` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `commine`
--

INSERT INTO `commine` (`id`, `commune_name`, `atribute`) VALUES
(1, 'muha', '1'),
(2, 'mukaza', '1'),
(3, 'Ntahangwa', '1');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `fullname`, `phone`, `email`, `message`) VALUES
(1, 'Test name', '0788348878', 'jon@gmail.com', 'This is a test message');

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

--
-- Table structure for table `country_list`
--

CREATE TABLE `country_list` (
  `id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `flag` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `country_list`
--

INSERT INTO `country_list` (`id`, `value`, `currency`, `flag`, `active`) VALUES
('AD', 'Andorra', NULL, NULL, 0),
('AE', 'United Arab Emirates', NULL, NULL, 0),
('AF', 'Afghanistan', NULL, NULL, 0),
('AG', 'Antigua & Barbuda', NULL, NULL, 0),
('AI', 'Anguilla', NULL, NULL, 0),
('AL', 'Albania', NULL, NULL, 0),
('AM', 'Armenia', NULL, NULL, 0),
('AO', 'Angola', NULL, NULL, 0),
('AQ', 'Antarctica', NULL, NULL, 0),
('AR', 'Argentina', NULL, NULL, 0),
('AS', 'American Samoa', NULL, NULL, 0),
('AT', 'Austria', NULL, NULL, 0),
('AU', 'Australia', NULL, NULL, 0),
('AW', 'Aruba', NULL, NULL, 0),
('AX', 'Åland Islands', NULL, NULL, 0),
('AZ', 'Azerbaijan', NULL, NULL, 0),
('BA', 'Bosnia & Herzegovina', NULL, NULL, 0),
('BB', 'Barbados', NULL, NULL, 0),
('BD', 'Bangladesh', NULL, NULL, 0),
('BE', 'Belgium', NULL, NULL, 0),
('BF', 'Burkina Faso', NULL, NULL, 0),
('BG', 'Bulgaria', NULL, NULL, 0),
('BH', 'Bahrain', NULL, NULL, 0),
('BI', 'Burundi', 'BIF', NULL, 1),
('BJ', 'Benin', NULL, NULL, 0),
('BL', 'St. Barthélemy', NULL, NULL, 0),
('BM', 'Bermuda', NULL, NULL, 0),
('BN', 'Brunei', NULL, NULL, 0),
('BO', 'Bolivia', NULL, NULL, 0),
('BQ', 'Caribbean Netherlands', NULL, NULL, 0),
('BR', 'Brazil', NULL, NULL, 0),
('BS', 'Bahamas', NULL, NULL, 0),
('BT', 'Bhutan', NULL, NULL, 0),
('BW', 'Botswana', NULL, NULL, 0),
('BY', 'Belarus', NULL, NULL, 0),
('BZ', 'Belize', NULL, NULL, 0),
('CA', 'Canada', NULL, NULL, 0),
('CC', 'Cocos (Keeling) Islands', NULL, NULL, 0),
('CD', 'Congo - Kinshasa', NULL, NULL, 0),
('CF', 'Central African Republic', NULL, NULL, 0),
('CG', 'Congo - Brazzaville', NULL, NULL, 0),
('CH', 'Switzerland', NULL, NULL, 0),
('CI', 'Côte d’Ivoire', NULL, NULL, 0),
('CK', 'Cook Islands', NULL, NULL, 0),
('CL', 'Chile', NULL, NULL, 0),
('CM', 'Cameroon', NULL, NULL, 0),
('CN', 'China', NULL, NULL, 0),
('CO', 'Colombia', NULL, NULL, 0),
('CR', 'Costa Rica', NULL, NULL, 0),
('CU', 'Cuba', NULL, NULL, 0),
('CV', 'Cape Verde', NULL, NULL, 0),
('CW', 'Curaçao', NULL, NULL, 0),
('CX', 'Christmas Island', NULL, NULL, 0),
('CY', 'Cyprus', NULL, NULL, 0),
('CZ', 'Czechia', NULL, NULL, 0),
('DE', 'Germany', NULL, NULL, 0),
('DG', 'Diego Garcia', NULL, NULL, 0),
('DJ', 'Djibouti', NULL, NULL, 0),
('DK', 'Denmark', NULL, NULL, 0),
('DM', 'Dominica', NULL, NULL, 0),
('DO', 'Dominican Republic', NULL, NULL, 0),
('DZ', 'Algeria', NULL, NULL, 0),
('EA', 'Ceuta & Melilla', NULL, NULL, 0),
('EC', 'Ecuador', NULL, NULL, 0),
('EE', 'Estonia', NULL, NULL, 0),
('EG', 'Egypt', NULL, NULL, 0),
('EH', 'Western Sahara', NULL, NULL, 0),
('ER', 'Eritrea', NULL, NULL, 0),
('ES', 'Spain', NULL, NULL, 0),
('ET', 'Ethiopia', NULL, NULL, 0),
('FI', 'Finland', NULL, NULL, 0),
('FJ', 'Fiji', NULL, NULL, 0),
('FK', 'Falkland Islands', NULL, NULL, 0),
('FM', 'Micronesia', NULL, NULL, 0),
('FO', 'Faroe Islands', NULL, NULL, 0),
('FR', 'France', NULL, NULL, 0),
('GA', 'Gabon', NULL, NULL, 0),
('GB', 'United Kingdom', NULL, NULL, 1),
('GD', 'Grenada', NULL, NULL, 0),
('GE', 'Georgia', NULL, NULL, 0),
('GF', 'French Guiana', NULL, NULL, 0),
('GG', 'Guernsey', NULL, NULL, 0),
('GH', 'Ghana', NULL, NULL, 1),
('GI', 'Gibraltar', NULL, NULL, 0),
('GL', 'Greenland', NULL, NULL, 0),
('GM', 'Gambia', NULL, NULL, 0),
('GN', 'Guinea', NULL, NULL, 0),
('GP', 'Guadeloupe', NULL, NULL, 0),
('GQ', 'Equatorial Guinea', NULL, NULL, 0),
('GR', 'Greece', NULL, NULL, 0),
('GS', 'South Georgia & South Sandwich Islands', NULL, NULL, 0),
('GT', 'Guatemala', NULL, NULL, 0),
('GU', 'Guam', NULL, NULL, 0),
('GW', 'Guinea-Bissau', NULL, NULL, 0),
('GY', 'Guyana', NULL, NULL, 0),
('HK', 'Hong Kong SAR China', NULL, NULL, 0),
('HN', 'Honduras', NULL, NULL, 0),
('HR', 'Croatia', NULL, NULL, 0),
('HT', 'Haiti', NULL, NULL, 0),
('HU', 'Hungary', NULL, NULL, 0),
('IC', 'Canary Islands', NULL, NULL, 0),
('ID', 'Indonesia', NULL, NULL, 0),
('IE', 'Ireland', NULL, NULL, 0),
('IL', 'Israel', NULL, NULL, 0),
('IM', 'Isle of Man', NULL, NULL, 0),
('IN', 'India', NULL, NULL, 0),
('IO', 'British Indian Ocean Territory', NULL, NULL, 0),
('IQ', 'Iraq', NULL, NULL, 0),
('IR', 'Iran', NULL, NULL, 0),
('IS', 'Iceland', NULL, NULL, 0),
('IT', 'Italy', NULL, NULL, 0),
('JE', 'Jersey', NULL, NULL, 0),
('JM', 'Jamaica', NULL, NULL, 0),
('JO', 'Jordan', NULL, NULL, 0),
('JP', 'Japan', NULL, NULL, 0),
('KE', 'Kenya', NULL, NULL, 1),
('KG', 'Kyrgyzstan', NULL, NULL, 0),
('KH', 'Cambodia', NULL, NULL, 0),
('KI', 'Kiribati', NULL, NULL, 0),
('KM', 'Comoros', NULL, NULL, 0),
('KN', 'St. Kitts & Nevis', NULL, NULL, 0),
('KP', 'North Korea', NULL, NULL, 0),
('KR', 'South Korea', NULL, NULL, 0),
('KW', 'Kuwait', NULL, NULL, 0),
('KY', 'Cayman Islands', NULL, NULL, 0),
('KZ', 'Kazakhstan', NULL, NULL, 0),
('LA', 'Laos', NULL, NULL, 0),
('LB', 'Lebanon', NULL, NULL, 0),
('LC', 'St. Lucia', NULL, NULL, 0),
('LI', 'Liechtenstein', NULL, NULL, 0),
('LK', 'Sri Lanka', NULL, NULL, 0),
('LR', 'Liberia', NULL, NULL, 0),
('LS', 'Lesotho', NULL, NULL, 0),
('LT', 'Lithuania', NULL, NULL, 0),
('LU', 'Luxembourg', NULL, NULL, 0),
('LV', 'Latvia', NULL, NULL, 0),
('LY', 'Libya', NULL, NULL, 0),
('MA', 'Morocco', NULL, NULL, 0),
('MC', 'Monaco', NULL, NULL, 0),
('MD', 'Moldova', NULL, NULL, 0),
('ME', 'Montenegro', NULL, NULL, 0),
('MF', 'St. Martin', NULL, NULL, 0),
('MG', 'Madagascar', NULL, NULL, 0),
('MH', 'Marshall Islands', NULL, NULL, 0),
('MK', 'North Macedonia', NULL, NULL, 0),
('ML', 'Mali', NULL, NULL, 0),
('MM', 'Myanmar (Burma)', NULL, NULL, 0),
('MN', 'Mongolia', NULL, NULL, 0),
('MO', 'Macao SAR China', NULL, NULL, 0),
('MP', 'Northern Mariana Islands', NULL, NULL, 0),
('MQ', 'Martinique', NULL, NULL, 0),
('MR', 'Mauritania', NULL, NULL, 0),
('MS', 'Montserrat', NULL, NULL, 0),
('MT', 'Malta', NULL, NULL, 0),
('MU', 'Mauritius', NULL, NULL, 0),
('MV', 'Maldives', NULL, NULL, 0),
('MW', 'Malawi', NULL, NULL, 0),
('MX', 'Mexico', NULL, NULL, 0),
('MY', 'Malaysia', NULL, NULL, 0),
('MZ', 'Mozambique', NULL, NULL, 0),
('NA', 'Namibia', NULL, NULL, 0),
('NC', 'New Caledonia', NULL, NULL, 0),
('NE', 'Niger', NULL, NULL, 0),
('NF', 'Norfolk Island', NULL, NULL, 0),
('NG', 'Nigeria', NULL, NULL, 1),
('NI', 'Nicaragua', NULL, NULL, 0),
('NL', 'Netherlands', NULL, NULL, 0),
('NO', 'Norway', NULL, NULL, 0),
('NP', 'Nepal', NULL, NULL, 0),
('NR', 'Nauru', NULL, NULL, 0),
('NU', 'Niue', NULL, NULL, 0),
('NZ', 'New Zealand', NULL, NULL, 0),
('OM', 'Oman', NULL, NULL, 0),
('PA', 'Panama', NULL, NULL, 0),
('PE', 'Peru', NULL, NULL, 0),
('PF', 'French Polynesia', NULL, NULL, 0),
('PG', 'Papua New Guinea', NULL, NULL, 0),
('PH', 'Philippines', NULL, NULL, 0),
('PK', 'Pakistan', NULL, NULL, 0),
('PL', 'Poland', NULL, NULL, 0),
('PM', 'St. Pierre & Miquelon', NULL, NULL, 0),
('PN', 'Pitcairn Islands', NULL, NULL, 0),
('PR', 'Puerto Rico', NULL, NULL, 0),
('PS', 'Palestinian Territories', NULL, NULL, 0),
('PT', 'Portugal', NULL, NULL, 0),
('PW', 'Palau', NULL, NULL, 0),
('PY', 'Paraguay', NULL, NULL, 0),
('QA', 'Qatar', NULL, NULL, 0),
('RE', 'Réunion', NULL, NULL, 0),
('RO', 'Romania', NULL, NULL, 0),
('RS', 'Serbia', NULL, NULL, 0),
('RU', 'Russia', NULL, NULL, 0),
('RW', 'Rwanda', 'RWF', NULL, 1),
('SA', 'Saudi Arabia', NULL, NULL, 0),
('SB', 'Solomon Islands', NULL, NULL, 0),
('SC', 'Seychelles', NULL, NULL, 0),
('SD', 'Sudan', NULL, NULL, 0),
('SE', 'Sweden', NULL, NULL, 0),
('SG', 'Singapore', NULL, NULL, 0),
('SH', 'St. Helena', NULL, NULL, 0),
('SI', 'Slovenia', NULL, NULL, 0),
('SJ', 'Svalbard & Jan Mayen', NULL, NULL, 0),
('SK', 'Slovakia', NULL, NULL, 0),
('SL', 'Sierra Leone', NULL, NULL, 0),
('SM', 'San Marino', NULL, NULL, 0),
('SN', 'Senegal', NULL, NULL, 0),
('SO', 'Somalia', NULL, NULL, 0),
('SR', 'Suriname', NULL, NULL, 0),
('SS', 'South Sudan', NULL, NULL, 0),
('ST', 'São Tomé & Príncipe', NULL, NULL, 0),
('SV', 'El Salvador', NULL, NULL, 0),
('SX', 'Sint Maarten', NULL, NULL, 0),
('SY', 'Syria', NULL, NULL, 0),
('SZ', 'Eswatini', NULL, NULL, 0),
('TA', 'Tristan da Cunha', NULL, NULL, 0),
('TC', 'Turks & Caicos Islands', NULL, NULL, 0),
('TD', 'Chad', NULL, NULL, 0),
('TF', 'French Southern Territories', NULL, NULL, 0),
('TG', 'Togo', NULL, NULL, 0),
('TH', 'Thailand', NULL, NULL, 0),
('TJ', 'Tajikistan', NULL, NULL, 0),
('TK', 'Tokelau', NULL, NULL, 0),
('TL', 'Timor-Leste', NULL, NULL, 0),
('TM', 'Turkmenistan', NULL, NULL, 0),
('TN', 'Tunisia', NULL, NULL, 0),
('TO', 'Tonga', NULL, NULL, 0),
('TR', 'Turkey', NULL, NULL, 0),
('TT', 'Trinidad & Tobago', NULL, NULL, 0),
('TV', 'Tuvalu', NULL, NULL, 0),
('TW', 'Taiwan', NULL, NULL, 0),
('TZ', 'Tanzania', NULL, NULL, 0),
('UA', 'Ukraine', NULL, NULL, 0),
('UG', 'Uganda', NULL, NULL, 1),
('UM', 'U.S. Outlying Islands', NULL, NULL, 0),
('US', 'United States', NULL, NULL, 1),
('UY', 'Uruguay', NULL, NULL, 0),
('UZ', 'Uzbekistan', NULL, NULL, 0),
('VA', 'Vatican City', NULL, NULL, 0),
('VC', 'St. Vincent & Grenadines', NULL, NULL, 0),
('VE', 'Venezuela', NULL, NULL, 0),
('VG', 'British Virgin Islands', NULL, NULL, 0),
('VI', 'U.S. Virgin Islands', NULL, NULL, 0),
('VN', 'Vietnam', NULL, NULL, 0),
('VU', 'Vanuatu', NULL, NULL, 0),
('WF', 'Wallis & Futuna', NULL, NULL, 0),
('WS', 'Samoa', NULL, NULL, 0),
('XA', 'Pseudo-Accents', NULL, NULL, 0),
('XB', 'Pseudo-Bidi', NULL, NULL, 0),
('XK', 'Kosovo', NULL, NULL, 0),
('YE', 'Yemen', NULL, NULL, 0),
('YT', 'Mayotte', NULL, NULL, 0),
('ZA', 'South Africa', NULL, NULL, 1),
('ZM', 'Zambia', NULL, NULL, 0),
('ZW', 'Zimbabwe', NULL, NULL, 0);

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

--
-- Table structure for table `duka_trash`
--

CREATE TABLE `duka_trash` (
  `id` int(21) NOT NULL,
  `date_trashed` datetime NOT NULL,
  `trash_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `duka_trash`
--

INSERT INTO `duka_trash` (`id`, `date_trashed`, `trash_title`) VALUES
(66, '2020-08-11 22:21:36', 'ea39d1a702368f6e3ec59cd5a6bef6ee.png'),
(70, '2020-08-12 02:31:53', '293d40d5f8fe93c2a015ef9fb9876f13.png'),
(74, '2020-08-12 02:36:46', '087d65b54c9ca55cf33a89fa74c6f80a.png'),
(77, '2020-08-12 02:43:45', '727dc9061776d983a67b274c39eb014a.png'),
(81, '2020-08-12 02:47:42', 'd48aecfc5c0dd014500d5fb6dc4d3cde.png'),
(85, '2020-08-12 02:52:13', '431313bab4f26e43197dc754213a9592.png'),
(86, '2020-08-12 02:53:34', '7429fd539f388c514b56b4f7bbd8b635.png'),
(87, '2020-08-16 09:26:44', '035f665283efc454e8e822c9870a26c2.png'),
(88, '2020-08-16 09:28:52', 'bbcabe31ca16bedc30b4fc59e4d52f4c.png'),
(89, '2020-08-16 09:31:05', 'ffd81daa260d793564a1f6af12fec77f.jpg'),
(90, '2020-08-16 09:34:52', '87faf8a5e425b3ee4c97dcb65766cdc4.png'),
(91, '2020-08-16 09:35:18', '83bcf1e4491d2aec0cc0ef31f2561f35.png'),
(92, '2020-08-16 10:49:09', 'e1ff073a681a3268d699085d8fa5c10e.jpg'),
(93, '2020-08-16 10:49:22', '59ffb8b4da7d7f922de5eccaad0305ae.jpg'),
(94, '2020-08-16 19:01:41', '98e99c993257b37788b52672042e033f.jpg'),
(99, '2020-08-16 22:36:31', '4eb51a45d904b78193e47ecfdf3e11e1.jpg'),
(103, '2020-08-16 22:40:23', '915ba0615d3c282fd73757dc6b65c514.jpg'),
(107, '2020-08-16 22:46:47', '67ce05c2d05dcd2f5b8b461dc90cf27e.jpg'),
(108, '2020-12-03 12:43:00', '25e8af18a78462fef0a9c16264e6a024.jpeg'),
(109, '2020-12-03 13:46:13', '13bdcadff993e3fabe5fa4cf62d99342.jpg');

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

--
-- Table structure for table `jb_address`
--

CREATE TABLE `jb_address` (
  `id` int(21) NOT NULL,
  `user_id` int(21) NOT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zip_code` varchar(50) DEFAULT NULL,
  `address_line_one` varchar(255) DEFAULT NULL,
  `address_line_two` varchar(255) DEFAULT NULL,
  `address_category` enum('shipping','billing') DEFAULT NULL,
  `commine` varchar(100) DEFAULT NULL,
  `quartier` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `jb_address`
--

INSERT INTO `jb_address` (`id`, `user_id`, `firstname`, `lastname`, `email`, `phone`, `company`, `country`, `city`, `zip_code`, `address_line_one`, `address_line_two`, `address_category`, `commine`, `quartier`) VALUES
(1, 70, 'innovation', 'innovation', NULL, '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'shipping', 'mukaza', 'Kabondo'),
(2, 96, 'innovation', 'ndayikeza', NULL, '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'shipping', 'mukaza', 'Kabondo'),
(3, 114, 'Aprosan', 'dede', NULL, '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'shipping', 'mukaza', 'Kabondo'),
(4, 1, 'Huddson', '50000', NULL, '0788548874', NULL, NULL, NULL, NULL, 'test', 'Test', 'shipping', NULL, NULL),
(5, 122, 'John Doe', 'Ltd', NULL, '0788214478', NULL, NULL, NULL, NULL, 'KN St 765 avenue South', 'KN St 765 avenue South', 'shipping', 'mukaza', 'Kabondo');

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

--
-- Table structure for table `live_message`
--

CREATE TABLE `live_message` (
  `id` int(21) NOT NULL,
  `message_date` datetime DEFAULT NULL,
  `chat_id` int(21) DEFAULT NULL,
  `message_sender` varchar(100) DEFAULT NULL,
  `message_body` text DEFAULT NULL,
  `message_seen` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(21) NOT NULL,
  `order_number` int(21) NOT NULL,
  `product_code` int(21) NOT NULL,
  `quantity_ordered` int(11) NOT NULL,
  `price_each` int(11) NOT NULL,
  `total_amount` int(21) NOT NULL,
  `ordered_options` blob DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`id`, `order_number`, `product_code`, `quantity_ordered`, `price_each`, `total_amount`, `ordered_options`) VALUES
(99, 74, 15, 1, 44500, 44500, 0x613a303a7b7d),
(100, 75, 15, 1, 44500, 44500, 0x613a303a7b7d),
(101, 1, 9, 1, 180000, 180000, 0x613a303a7b7d),
(102, 2, 11, 1, 664000, 664000, 0x613a303a7b7d),
(103, 3, 11, 1, 664000, 664000, 0x613a303a7b7d),
(104, 4, 10, 1, 48000, 48000, 0x613a303a7b7d),
(105, 5, 14, 1, 25500, 25500, 0x613a303a7b7d),
(106, 6, 17, 1, 5000000, 5000000, 0x613a303a7b7d),
(107, 5, 9, 6, 180000, 1080000, 0x613a303a7b7d),
(108, 5, 13, 4, 12000, 48000, 0x613a303a7b7d);

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

--
-- Table structure for table `order_tracking`
--

CREATE TABLE `order_tracking` (
  `id` int(21) NOT NULL,
  `order_number` int(11) NOT NULL,
  `order_code` varchar(100) NOT NULL,
  `track_date` datetime NOT NULL,
  `status_type` varchar(100) NOT NULL,
  `seller_comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order_tracking`
--

INSERT INTO `order_tracking` (`id`, `order_number`, `order_code`, `track_date`, `status_type`, `seller_comment`) VALUES
(77, 74, 'CNZ4JNOT2GGSC844', '2021-01-12 20:04:41', 'Awaiting Payment', NULL),
(78, 1, '8P6GI7QNJU4OWWOC', '2021-01-13 18:08:13', 'Awaiting Payment', NULL),
(79, 2, '1AZW3AR097XCCSCO', '2021-01-17 15:37:26', 'Awaiting Payment', NULL),
(80, 3, '15UZ7YJ9NS5CWCOS', '2021-01-20 13:12:30', 'Awaiting Payment', NULL),
(81, 4, 'D8YA7MPZ3280C0KG', '2021-01-24 10:50:05', 'Awaiting Payment', NULL),
(82, 5, '1PJ8GFHCT3NOOC0O', '2021-01-24 14:49:42', 'Awaiting Payment', NULL),
(83, 6, '1PJ8GFHCT3NOOC0O', '2021-01-24 14:49:42', 'Awaiting Payment', NULL);

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(21) NOT NULL,
  `product_code` varchar(100) NOT NULL,
  `product_type` varchar(10) DEFAULT 'Simple',
  `user_id` int(21) NOT NULL,
  `product_condition` varchar(15) DEFAULT NULL,
  `product_origin` varchar(100) DEFAULT NULL,
  `category_id` int(21) NOT NULL,
  `product_title` varchar(255) NOT NULL,
  `product_slug` varchar(255) DEFAULT NULL,
  `product_tags` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `regular_price` double NOT NULL,
  `sale_price` double NOT NULL,
  `discount_percentage` int(11) NOT NULL,
  `attributes` blob DEFAULT NULL,
  `variations` blob DEFAULT NULL,
  `variation_prices` blob DEFAULT NULL,
  `features` blob DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8 NOT NULL,
  `date_created` varchar(20) NOT NULL,
  `is_featured` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `product_code`, `product_type`, `user_id`, `product_condition`, `product_origin`, `category_id`, `product_title`, `product_slug`, `product_tags`, `description`, `quantity`, `regular_price`, `sale_price`, `discount_percentage`, `attributes`, `variations`, `variation_prices`, `features`, `image`, `date_created`, `is_featured`, `is_active`, `deleted`, `deleted_at`) VALUES
(8, '17AFCXB99I3KK08O', 'Simple', 2, 'New', 'America', 62, 'Samsung Smart Led Tv With Speaker', 'samsung-smart-led-tv-with-speaker-4010f6itra0wsc8w8owg0gc8c67b6f5f99ba6a130ac725f7779fd1fccb57a5709', 'phone sumsung smart', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda. Non, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas\n\naccusamus debitis illum distinctio nemo numquam obcaecati at itaque odio ducimus cupiditate minima labore libero! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda.\n\nNon, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas accusamus debitis illum distinctio nemo numquam obcaecati at itaque odio ducimus cupiditate.', 80, 3000000, 27000000, 10, 0x[BLOB], 0x613a303a7b7d, 0x613a303a7b7d, NULL, 'ea39d1a702368f6e3ec59cd5a6bef6ee.png', '2020-08-11 22:22:47', 0, 1, 0, NULL),
(9, 'G7YO7S86M144CSGS', 'Simple', 2, 'Used', 'Europe', 62, 'Samsung Smart Led Tv With Speaker', 'samsung-smart-led-tv-with-speaker-484h6hyzglmosgg4wg4kgks4o5103f0c5117e1b901ed25fede46d6745d5ac0dc3', 'tablets phone spaker', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda. Non, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas', NULL, 200000, 180000, 10, 0x[BLOB], 0x613a303a7b7d, 0x613a303a7b7d, NULL, '0302e0ca3a7d3fc241aafecb08e9d965.png', '2020-08-12 02:34:51', 0, 1, 0, NULL),
(10, 'C17AVA6C6GGSCS8S', 'Simple', 2, 'Used', 'Asia', 47, 'T-shirts Samsung Smart Led Tv With Speaker', 't-shirts-samsung-smart-led-tv-with-speaker-7izdn4gwsv40sk488co48sw8w48f0286cf6db0dd881f9bc281a3db040377b29ea', 'T-shirts clothes ', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda. Non, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas', NULL, 60000, 48000, 20, 0x613a313a7b693a303b4f3a383a22737464436c617373223a323a7b733a343a226e616d65223b733a343a2254657374223b733a353a2276616c7565223b733a31303a22746573742076616c7565223b7d7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '087d65b54c9ca55cf33a89fa74c6f80a.png', '2020-08-12 02:37:10', 0, 1, 0, NULL),
(11, 'ANMAVQ7GXZSCGC4S', 'Simple', 2, 'New', 'Africa', 84, 'Headphones Samsung Smart Led Tv With Speaker', 'headphones-samsung-smart-led-tv-with-speaker-8pto6ltav9wc40sskckg84sg059a35c36815ac852c7ccb3a85c0829a601398626', 'Headphones', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda. Non, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas\n\naccusamus debitis illum distinctio nemo numquam obcaecati at itaque odio ducimus cupiditate minima labore libero! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda.', NULL, 800000, 664000, 17, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '727dc9061776d983a67b274c39eb014a.png', '2020-08-12 02:44:14', 0, 1, 0, NULL),
(12, 'C01HKXWY3A8G0S4C', 'Simple', 2, 'New', 'Burundi', 55, 'Watch Samsung Smart Led Tv With Speaker', 'watch-samsung-smart-led-tv-with-speaker-5skcuvtrjbocks0cg4ss08s84a0a5b9d8ef54cc87ebfbc28b772e67c7b10cd206', 'Watch', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda. Non, quas, nihil! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat, necessitatibus, dicta iusto in, similique quas\n\naccusamus debitis illum distinctio nemo numquam obcaecati at itaque odio ducimus cupiditate minima labore libero! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Soluta consequatur, expedita, autem labore eos, totam rem quo similique est et qui quaerat cumque sed ab quae assumenda.', NULL, 25000, 19000, 21, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, 'd48aecfc5c0dd014500d5fb6dc4d3cde.png', '2020-08-12 02:48:22', 0, 1, 0, NULL),
(13, 'E07XMD7DNRSCCKO0', 'Simple', 2, 'New', 'Austraria', 55, 'Fitbit Ionic GPS Smart Watch, Charcoal/Smoke Gray, One Size', 'fitbit-ionic-gps-smart-watch-charcoalsmoke-gray-one-size-1zhbtk30304gcokw408owss4w04738ce15f308a1a14b344b5e2b387c5cdeffe75', 'Watch', 'The Gear 360 has evolved to let you record in 4K or broadcast live, and then make it your own with the Samsung Gear 360 app. And with the Gear 360\'s smaller size and redesigned, easy-to-grip body, memories aren\'t the only thing you\'ll want to hold onto.', NULL, 15000, 12000, 20, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '98e99c993257b37788b52672042e033f.jpg', '2020-08-16 19:02:15', 0, 1, 0, NULL),
(14, '712OSYPIYZK0OCGC', 'Simple', 2, 'New', 'America', 50, 'Acer R11 11.6\" Convertible 2-in-1 HD Touchscreen (2019)', 'acer-r11-116-convertible-2-in-1-hd-touchscreen-2019-898cjzuaed8gsk8cgw4kogs4g88ffd1ea995616aa2b157a980de38cd5a74ea3c8', 'acel computer', 'The Gear 360 has evolved to let you record in 4K or broadcast live, and then make it your own with the Samsung Gear 360 app. And with the Gear 360\'s smaller size and redesigned, easy-to-grip body, memories aren\'t the only thing you\'ll want to hold onto.', NULL, 30000, 25500, 15, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '4eb51a45d904b78193e47ecfdf3e11e1.jpg', '2020-08-16 22:36:54', 0, 1, 0, NULL),
(15, '8U4BQ5RNZ5S0OGGS', 'Simple', 2, 'Used', 'America', 48, 'SONY Smart TV LED 49\" Ultra HD 4K', 'sony-smart-tv-led-49-ultra-hd-4k-7yn5sr7tv1s8848wsckcskkco41870af519f0a8f6715ae65f19e3354d64b36a8b', 'TV electronics', 'The Gear 360 has evolved to let you record in 4K or broadcast live, and then make it your own with the Samsung Gear 360 app. And with the Gear 360\'s smaller size and redesigned, easy-to-grip body, memories aren\'t the only thing you\'ll want to hold onto.', NULL, 50000, 44500, 11, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '915ba0615d3c282fd73757dc6b65c514.jpg', '2020-08-16 22:40:39', 0, 1, 0, NULL),
(16, 'EF1ASTXQLM0OK84K', 'Simple', 2, 'New', 'Asia', 50, 'Apple iMac (27-inch Retina 5K display: 3.8GHz quad-core Intel Core i5, 8GB RAM, 2TB)', 'apple-imac-27-inch-retina-5k-display-38ghz-quad-core-intel-core-i5-8gb-ram-2tb-d2at2m5bm3soswo4wcwo0444kfc08f80a5286329babbfcfce14082c07caccc092', NULL, 'The Gear 360 has evolved to let you record in 4K or broadcast live, and then make it your own with the Samsung Gear 360 app. And with the Gear 360\'s smaller size and redesigned, easy-to-grip body, memories aren\'t the only thing you\'ll want to hold onto.', NULL, 4500000, 3645000, 19, 0x613a303a7b7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '67ce05c2d05dcd2f5b8b461dc90cf27e.jpg', '2020-08-16 22:47:04', 0, 1, 0, NULL),
(17, 'A41LFIK8LM8SS008', 'Simple', 3, 'New', 'Africa', 50, 'MacBook Pro 16-Inch', 'macbook-pro-16-inch-5jyit6ivlqg400gk8kog8k4s074e3cbb208de44124a3f3d7fd53ae0a65b1335cc', 'MacBook', 'With a larger display, a beefier graphics chip, and (vitally and finally!) an improved keyboard, Apple\'s 16-inch MacBook Pro is a beyond-capable', 1, 5000000, 5000000, 0, 0x613a313a7b693a303b4f3a383a22737464436c617373223a323a7b733a343a226e616d65223b4e3b733a353a2276616c7565223b4e3b7d7d, 0x613a303a7b7d, 0x613a303a7b7d, NULL, '25e8af18a78462fef0a9c16264e6a024.jpeg', '2020-12-03 12:43:04', 0, 1, 0, NULL);

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

--
-- Table structure for table `product_brand`
--

CREATE TABLE `product_brand` (
  `id` int(21) NOT NULL,
  `category_id` int(21) NOT NULL,
  `brand_name` varchar(100) DEFAULT NULL,
  `brand_logo` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `id` int(11) NOT NULL,
  `parent_id` int(21) DEFAULT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_slug` varchar(255) NOT NULL,
  `is_master` tinyint(1) NOT NULL DEFAULT 0,
  `level_index` int(11) DEFAULT NULL,
  `path_code` varchar(16) DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_category`
--

INSERT INTO `product_category` (`id`, `parent_id`, `category_name`, `category_slug`, `is_master`, `level_index`, `path_code`, `image`, `description`) VALUES
(46, NULL, 'Men\'s clothing', 'mens-clothing', 1, NULL, '153877621', NULL, NULL),
(47, NULL, 'Clothing', 'clothing', 1, NULL, '800670420', NULL, NULL),
(48, NULL, 'Electronics', 'electronics', 1, NULL, '883239762', NULL, NULL),
(49, NULL, 'Smartphones & Tablets', 'smartphones-tablets', 1, NULL, '406199252', NULL, NULL),
(50, NULL, 'Computer & Office', 'computer-office', 1, NULL, '438227857', NULL, NULL),
(51, NULL, 'Home Appliances', 'home-appliances', 1, NULL, '958293791', NULL, NULL),
(52, NULL, 'Leather & Shoes', 'leather-shoes', 1, NULL, '235741907', NULL, NULL),
(54, NULL, 'Kids & Babies', 'kids-babies', 1, NULL, '867737926', NULL, 'undefined'),
(55, NULL, 'Jewelary & Watches', 'jewelary-watches', 1, NULL, '926098036', NULL, NULL),
(56, NULL, 'Health & Beauty', 'health-beauty', 1, NULL, '152889200', NULL, NULL),
(57, NULL, 'Automobiles', 'automobiles', 1, NULL, '989509948', NULL, NULL),
(58, NULL, 'Sports & Outdoors', 'sports-outdoors', 1, NULL, '541433059', NULL, NULL),
(59, 49, 'Smartphones', 'smartphones', 0, 1, 'undefined', NULL, NULL),
(60, 49, 'Tablets', 'tablets', 0, 1, 'undefined', NULL, NULL),
(61, 49, 'Accessories', 'accessories', 0, 1, 'undefined', NULL, NULL),
(62, 59, 'Samsung', 'samsung', 0, 2, 'undefined', NULL, NULL),
(63, 59, 'Huawei', 'huawei', 0, 2, 'undefined', NULL, NULL),
(64, 59, 'Asus', 'asus', 0, 2, 'undefined', NULL, NULL),
(65, 59, 'Sony', 'sony', 0, 2, 'undefined', NULL, NULL),
(66, 59, 'Apple', 'apple', 0, 2, 'undefined', NULL, NULL),
(67, 59, 'Xiaomi', 'xiaomi', 0, 2, 'undefined', NULL, NULL),
(68, 59, 'Oppo', 'oppo', 0, 2, 'undefined', NULL, NULL),
(69, 59, 'One Plus', 'one-plus', 0, 2, 'undefined', NULL, NULL),
(70, 59, 'Nokia', 'nokia', 0, 2, 'undefined', NULL, NULL),
(71, 59, 'Htc', 'htc', 0, 2, 'undefined', NULL, NULL),
(72, 59, 'Vivo', 'vivo', 0, 2, 'undefined', NULL, NULL),
(73, 60, 'Samsung', 'samsung', 0, 2, 'undefined', NULL, NULL),
(74, 60, 'Huawei', 'huawei', 0, 2, 'undefined', NULL, NULL),
(75, 60, 'Apple', 'apple', 0, 2, 'undefined', NULL, NULL),
(76, 60, 'Xiaomi', 'xiaomi', 0, 2, 'undefined', NULL, NULL),
(77, 60, 'Sony', 'sony', 0, 2, 'undefined', NULL, NULL),
(78, 60, 'Asus', 'asus', 0, 2, 'undefined', NULL, NULL),
(79, 61, 'Power Bank', 'power-bank', 0, 2, 'undefined', NULL, NULL),
(80, 61, 'Battery & Charger', 'battery-charger', 0, 2, 'undefined', NULL, NULL),
(81, 61, 'Cables & Adapters', 'cables-adapters', 0, 2, 'undefined', NULL, NULL),
(82, 61, 'Back / Flip Cover', 'back-flip-cover', 0, 2, 'undefined', NULL, NULL),
(83, 61, 'Screen Protector', 'screen-protector', 0, 2, 'undefined', NULL, NULL),
(84, 61, 'Earphones', 'earphones', 0, 2, 'undefined', NULL, NULL),
(85, 61, 'Memory Card', 'memory-card', 0, 2, 'undefined', NULL, NULL),
(86, 61, 'Phone Cases', 'phone-cases', 0, 2, 'undefined', NULL, NULL);

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

--
-- Table structure for table `product_gallery`
--

CREATE TABLE `product_gallery` (
  `id` int(21) NOT NULL,
  `product_id` int(21) NOT NULL,
  `image` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_gallery`
--

INSERT INTO `product_gallery` (`id`, `product_id`, `image`) VALUES
(20, 8, '4036f48320b71639e2fba8a07de8f1e4.png'),
(21, 8, '980b92041d44f4293cd9410f9e88bc9a.png'),
(22, 8, '2510ba8fb80c290b988584621254a1f2.png'),
(23, 9, 'aa36d6d1d8762fdae27b7b609598f3c3.png'),
(24, 9, '0302e0ca3a7d3fc241aafecb08e9d965.png'),
(25, 9, 'e326df9a8fb91e18f36f076e9d10788a.png'),
(26, 10, '06b142be61304c64b97cbcdbde2ec4b5.png'),
(27, 10, 'd03d43a1718b1d9f4ae24fdd1153b5ae.png'),
(28, 11, 'ecd8af5318f19afc3b13591ed903067a.png'),
(29, 11, '855aec9d094f58acb9c01ea37616b55d.png'),
(30, 11, '221304a419b05820c9f6b329c98b44bd.png'),
(31, 12, '699ada1a32c31fff4e6b174a33318e04.png'),
(32, 12, '7c019ecbe0ecca432005022d657566a4.png'),
(33, 12, '9566fa1aa11e3a2b7674300640204936.png'),
(34, 13, 'a732e2157d4efea9cd074fe28af7fa7a.jpg'),
(35, 13, '31efad5ac6f8c5ca89dd63a77437f40e.jpg'),
(36, 13, 'b1eea74ae49dbaec325a599973e62b80.jpg'),
(37, 13, '9caa5752f38e49dacbaf6d1183471f2c.jpg'),
(38, 14, 'de27c8d4f65396b684878f60f1dc404c.jpg'),
(39, 14, 'b8635a5adeb2ecff3bdd5c09eaeef0e3.jpg'),
(40, 14, '02a58f2ea41fd96a5d93433af270fa0a.jpg'),
(41, 15, '6fa9a090ee53e9a50ab2283ec23b236f.jpg'),
(42, 15, '64961ca335f7846fbae4f1d9ee25dd4a.jpg'),
(43, 15, '2352d2702178d807769bc24a6da871b3.jpg'),
(44, 16, '936d60e245353c7ab8c1048eac0734d2.jpg'),
(45, 16, 'e72b2674dcc0ca04785208d098c57538.jpg'),
(46, 16, 'f99e41c40926c86c5c0ae71196eaf096.jpg');

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

--
-- Table structure for table `quartie`
--

CREATE TABLE `quartie` (
  `id` int(11) NOT NULL,
  `Quartie_name` varchar(200) DEFAULT NULL,
  `commune_id` varchar(11) DEFAULT NULL,
  `Priccing` varchar(100) DEFAULT NULL,
  `atribute` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `quartie`
--

INSERT INTO `quartie` (`id`, `Quartie_name`, `commune_id`, `Priccing`, `atribute`) VALUES
(1, 'Rohero', '2', '1000', '1'),
(2, 'Gatoke', '1', '1000', '1'),
(3, 'Kabondo', '2', '1000', ''),
(4, 'Asiatique', '2', '1000', ''),
(5, 'Kinanira3', '1', '1200', ''),
(6, 'kinanira2', '', '1000', ''),
(7, 'Zeiment', '1', '1200', '1'),
(8, 'Oua', '1', '1000', '1'),
(9, 'Kabondo', '2', '1200', '1'),
(10, 'Gasekebuye', '1', '1000', ''),
(11, 'Kinanira', '1', '1200', '1'),
(12, 'Musaga', '1', '1200', '1'),
(13, 'Kanyosha', '1', '1200', '1'),
(14, 'Gisyo', '3', '1000', '1');

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

--
-- Table structure for table `user_address`
--

CREATE TABLE `user_address` (
  `id` int(21) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `country` varchar(5) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `address_one` varchar(255) DEFAULT NULL,
  `address_two` varchar(255) DEFAULT NULL,
  `commine` varchar(100) DEFAULT NULL,
  `quartier` varchar(100) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_address`
--

INSERT INTO `user_address` (`id`, `user_id`, `firstname`, `lastname`, `phone`, `email`, `country`, `city`, `zip_code`, `address_one`, `address_two`, `commine`, `quartier`, `is_default`) VALUES
(1, 66, 'nova sofware company', '2', '68862628', NULL, NULL, NULL, NULL, 'avenue Ndadaye', 'b3', 'mukaza', 'Rohero', 0),
(2, 67, 'buja sayangana', '1', '7555555', NULL, NULL, NULL, NULL, 'hello test', 'none', 'mukaza', 'Rohero', 0),
(3, 68, 'nova sofware company', '2', '75323216', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Rohero', 0),
(4, 69, 'hello tech', '2', NULL, NULL, NULL, NULL, NULL, 'test', 'test', 'mukaza', 'Kabondo', 0),
(5, 70, 'innovation', 'innovation', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(6, 71, 'ingomac', '2', '75323216', NULL, NULL, NULL, NULL, 'avenue ntahondi', NULL, 'mukaza', 'Rohero', 0),
(7, 72, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(8, 73, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(9, 74, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(10, 75, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(11, 76, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(12, 77, 'innovation', '1', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(13, 78, 'innovation', '2', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(14, 80, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(15, 81, 'ngabo', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(16, 82, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(17, 83, 'innovation', '2', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(18, 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(19, 85, 'innovation', '2', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(20, 86, 'nova software company', '2', '75323216', NULL, NULL, NULL, NULL, 'avenue ndadaye', 'b3', 'mukaza', 'Rohero', 0),
(21, 87, 'innovation', '2', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(22, 88, 'nova sofware company', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(23, 89, 'ngabo', '1', '75323216', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(24, 90, 'test', '1', '5665656666', NULL, NULL, NULL, NULL, 'hello', NULL, 'muha', 'Kinanira3', 0),
(25, 91, 'akeza net', '2', '62642311', NULL, NULL, NULL, NULL, 'avenue ndadaye', 'b7', 'mukaza', 'Rohero', 0),
(26, 92, 'Aprosan', '2', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(27, 93, 'nono', '2', '7888888', NULL, NULL, NULL, NULL, NULL, NULL, 'mukaza', 'Rohero', 0),
(28, 94, 'innovation', '1', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(29, 95, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(30, 96, 'innovation', 'ndayikeza', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(31, 97, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(32, 98, 'nova sofware company', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(33, 99, 'innovation', '1', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(34, 100, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(35, 101, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(36, 102, 'ngabo', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(37, 103, 'ingomac', '2', '221515151', NULL, NULL, NULL, NULL, 'none', 'test', 'mukaza', 'Kabondo', 0),
(38, 104, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(39, 105, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(40, 106, 'nono', '2', '55555555', NULL, NULL, NULL, NULL, NULL, NULL, 'muha', 'Kinanira3', 0),
(41, 107, 'innovation', 'ndayikeza', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(42, 108, 'Aprosan', '2', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(43, 109, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(44, 110, 'test', '3', '676767676767', NULL, NULL, NULL, NULL, 'test', NULL, 'mukaza', 'Rohero', 0),
(45, 111, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(46, 112, 'Aprosan', '3', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(47, 113, 'innovation', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(48, 114, 'Aprosan', 'dede', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(49, 115, 'innovation', '1', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(50, 116, 'nova sofware', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(51, 117, 'ngabo', '3', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(52, 118, 'jhjhjhhjjh', 'kjkjkjk', '1', NULL, NULL, NULL, NULL, 'sdsdsd', 'sdddsdsads', 'mukaza', 'Rohero', 0),
(53, 119, 'Aprosan', '1', '6737373', NULL, NULL, NULL, NULL, 'avenue sanzu', 'none', 'mukaza', 'Kabondo', 0),
(54, 120, 'innovation', '1', '6122222223', NULL, NULL, NULL, NULL, 'mutanga', 'avenue sanzu no 19', 'mukaza', 'Kabondo', 0),
(55, 121, 'Huddson', '50000', '0788548874', NULL, NULL, NULL, NULL, 'test', 'Test', 'Ntahangwa', 'Gisyo', 0),
(56, 1, 'Huddson', '50000', '0788548874', NULL, NULL, NULL, NULL, 'test', 'Test', NULL, NULL, 0),
(57, 122, 'John Doe', 'Ltd', '0788214478', NULL, NULL, NULL, NULL, 'KN St 765 avenue South', 'KN St 765 avenue South', 'mukaza', 'Kabondo', 0);

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

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` int(21) NOT NULL,
  `user_id` int(21) DEFAULT NULL,
  `account_code` varchar(20) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `user_avatar` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`id`, `user_id`, `account_code`, `firstname`, `lastname`, `dob`, `gender`, `email`, `user_avatar`, `phone`, `country`) VALUES
(1, 1, NULL, 'Mark', 'Johnson Jr', NULL, NULL, 'kwizeravalens62@hotmail.com', NULL, '0788 351 158', 'RW'),
(21, 24, '970969', 'Angel', 'Kwizera', NULL, NULL, NULL, NULL, '0788342254', NULL),
(22, 25, '708994', 'Burundi Work ltd', NULL, NULL, NULL, 'business@email.com', NULL, '07722588000', 'Burundi'),
(23, 26, '596328', 'innovation', 'nono', NULL, NULL, NULL, NULL, '61222222', NULL),
(24, 27, '712079', 'innovation', 'ndayikeza', NULL, NULL, NULL, NULL, '61222222', NULL),
(25, 28, '579611', 'nova', NULL, NULL, NULL, 'nova@nova.bi', NULL, '75323216', 'Burundi'),
(26, 29, '631119', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(27, 30, '609096', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(28, 31, '174921', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(29, 32, '783089', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(30, 33, '989524', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(31, 34, '981411', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(32, 35, '942567', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(33, 36, '645085', 'nova', '3', NULL, NULL, NULL, NULL, '688828282828', NULL),
(34, 37, '854804', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(35, 38, '458960', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(36, 39, '997851', 'madodo', '2', NULL, NULL, NULL, NULL, '5747474747', NULL),
(37, 40, '866409', 'nova software company', '2', NULL, NULL, NULL, NULL, '75363616', NULL),
(38, 41, '252779', 'Aprosan burundi', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(39, 42, '465973', 'aprosan burundi', '1', NULL, NULL, NULL, NULL, '7535353', NULL),
(40, 43, '840445', 'immogreatlakes', '2', NULL, NULL, NULL, NULL, '5353535353', NULL),
(41, 44, '798247', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(42, 45, '354957', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(43, 46, '648653', 'ingoma soft center', '2', NULL, NULL, NULL, NULL, '747757575', NULL),
(44, 47, '244397', 'terimbere mugoboka', '2', NULL, NULL, NULL, NULL, '753535353', NULL),
(45, 48, '919036', 'immogreatlakes', '1', NULL, NULL, NULL, NULL, '75535353', NULL),
(46, 49, '199589', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(47, 50, '289174', 'nova', '3', NULL, NULL, NULL, NULL, '673737373', NULL),
(48, 51, '709754', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(49, 52, '112939', 'immogreatlakes', '2', NULL, NULL, NULL, NULL, '75323216', NULL),
(50, 53, '714267', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(51, 54, '675690', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(52, 55, '329697', 'innovation', 'nova', NULL, NULL, NULL, NULL, '6122222223', NULL),
(53, 56, '230842', 'innovation', 'nova', NULL, NULL, NULL, NULL, '6122222223', NULL),
(54, 57, '881678', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(55, 58, '392759', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(56, 59, '593447', 'hello test', '1', NULL, NULL, NULL, NULL, '7555555', NULL),
(57, 60, '147580', 'Aprosan burundi', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(58, 61, '504745', 'hello test', '1', NULL, NULL, NULL, NULL, '7555555', NULL),
(59, 62, '715850', 'hello test', '1', NULL, NULL, NULL, NULL, '7555555', NULL),
(60, 63, '795996', 'hello test', '1', NULL, NULL, NULL, NULL, '7555555', NULL),
(61, 64, '569490', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(62, 65, '866484', 'nova software company', '2', NULL, NULL, NULL, NULL, '7555555', NULL),
(63, 66, '473356', 'nova sofware company', '2', NULL, NULL, NULL, NULL, '68862628', NULL),
(64, 67, '370160', 'buja sayangana', '1', NULL, NULL, NULL, NULL, '7555555', NULL),
(65, 68, '929135', 'nova sofware company', '2', NULL, NULL, NULL, NULL, '75323216', NULL),
(66, 69, '433701', 'hello tech', '2', NULL, NULL, NULL, NULL, NULL, NULL),
(67, 70, '251198', 'innovation', 'innovation', NULL, NULL, NULL, NULL, '6122222223', NULL),
(68, 71, '595442', 'ingomac', '2', NULL, NULL, NULL, NULL, '75323216', NULL),
(69, 72, '457709', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(70, 73, '267667', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(71, 74, '313365', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(72, 75, '107778', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(73, 76, '396091', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(74, 77, '550560', 'innovation', '1', NULL, NULL, NULL, NULL, '6122222223', NULL),
(75, 78, '104513', 'innovation', '2', NULL, NULL, NULL, NULL, '6122222223', NULL),
(76, 79, '140594', 'ingoma soft center', NULL, NULL, NULL, 'softcenter@mail.com', NULL, '75424211', 'Burundi'),
(77, 80, '713008', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(78, 81, '221131', 'ngabo', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(79, 82, '749449', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(80, 83, '684811', 'innovation', '2', NULL, NULL, NULL, NULL, '6122222223', NULL),
(81, 84, '742747', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 85, '369160', 'innovation', '2', NULL, NULL, NULL, NULL, '6122222223', NULL),
(83, 86, '698398', 'nova software company', '2', NULL, NULL, NULL, NULL, '75323216', NULL),
(84, 87, '217395', 'innovation', '2', NULL, NULL, NULL, NULL, '6122222223', NULL),
(85, 88, '745665', 'nova sofware company', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(86, 89, '566610', 'ngabo', '1', NULL, NULL, NULL, NULL, '75323216', NULL),
(87, 90, '302823', 'test', '1', NULL, NULL, NULL, NULL, '5665656666', NULL),
(88, 91, '108648', 'akeza net', '2', NULL, NULL, NULL, NULL, '62642311', NULL),
(89, 92, '236600', 'Aprosan', '2', NULL, NULL, NULL, NULL, '6737373', NULL),
(90, 93, '877333', 'nono', '2', NULL, NULL, NULL, NULL, '7888888', NULL),
(91, 94, '369997', 'innovation', '1', NULL, NULL, NULL, NULL, '6122222223', NULL),
(92, 95, '447700', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(93, 96, '415659', 'innovation', 'ndayikeza', NULL, NULL, NULL, NULL, '6122222223', NULL),
(94, 97, '781939', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(95, 98, '596140', 'nova sofware company', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(96, 99, '678765', 'innovation', '1', NULL, NULL, NULL, NULL, '6122222223', NULL),
(97, 100, '954070', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(98, 101, '291118', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(99, 102, '737508', 'ngabo', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(100, 103, '587270', 'ingomac', '2', NULL, NULL, NULL, NULL, '221515151', NULL),
(101, 104, '937819', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(102, 105, '306976', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(103, 106, '873319', 'nono', '2', NULL, NULL, NULL, NULL, '55555555', NULL),
(104, 107, '300263', 'innovation', 'ndayikeza', NULL, NULL, NULL, NULL, '6122222223', NULL),
(105, 108, '357588', 'Aprosan', '2', NULL, NULL, NULL, NULL, '6737373', NULL),
(106, 109, '335120', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(107, 110, '910856', 'test', '3', NULL, NULL, NULL, NULL, '676767676767', NULL),
(108, 111, '400443', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(109, 112, '641391', 'Aprosan', '3', NULL, NULL, NULL, NULL, '6737373', NULL),
(110, 113, '734557', 'innovation', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(111, 114, '292120', 'Aprosan', 'dede', NULL, NULL, NULL, NULL, '6737373', NULL),
(112, 115, '729000', 'innovation', '1', NULL, NULL, NULL, NULL, '6122222223', NULL),
(113, 116, '418847', 'nova sofware', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(114, 117, '943925', 'ngabo', '3', NULL, NULL, NULL, NULL, '6122222223', NULL),
(115, 118, '598762', 'jhjhjhhjjh', 'kjkjkjk', NULL, NULL, NULL, NULL, '1', NULL),
(116, 119, '644727', 'Aprosan', '1', NULL, NULL, NULL, NULL, '6737373', NULL),
(117, 120, '710447', 'innovation', '1', NULL, NULL, NULL, NULL, '6122222223', NULL),
(118, 121, '644787', 'Huddson', '50000', NULL, NULL, NULL, NULL, '0788548874', NULL),
(119, 122, '488257', 'John Doe', 'Ltd', NULL, NULL, NULL, NULL, '0788214478', NULL);

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

--
-- Table structure for table `wolf_content`
--

CREATE TABLE `wolf_content` (
  `id` int(11) NOT NULL,
  `page_name` varchar(50) DEFAULT NULL,
  `ref_code` varchar(255) NOT NULL,
  `content` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `wolf_image`
--

CREATE TABLE `wolf_image` (
  `id` int(11) NOT NULL,
  `page_name` varchar(20) DEFAULT NULL,
  `ref_code` varchar(50) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `redirect_url` varchar(255) DEFAULT NULL,
  `path_name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `wolf_image`
--

INSERT INTO `wolf_image` (`id`, `page_name`, `ref_code`, `filename`, `redirect_url`, `path_name`) VALUES
(14, 'home_page', 'sb-1', '83bcf1e4491d2aec0cc0ef31f2561f35.png', NULL, 'widgets'),
(15, 'home_page', 'sb-2', 'sb-2.png', NULL, 'widgets'),
(16, 'home_page', 'sb-3', 'sb-3.png', NULL, 'widgets'),
(17, 'home_page', 'banner-1', 'e1ff073a681a3268d699085d8fa5c10e.jpg', NULL, 'widgets'),
(18, 'home_page', 'banner-2', '59ffb8b4da7d7f922de5eccaad0305ae.jpg', NULL, 'widgets'),
(19, 'home_page', 'promo-banner', 'promo-banner.jpg', NULL, 'widgets');

--
-- Indexes for table `category_widget`
--
ALTER TABLE `category_widget`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_banner`
--
ALTER TABLE `cms_banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_banner_group`
--
ALTER TABLE `cms_banner_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_section`
--
ALTER TABLE `cms_section`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `commine`
--
ALTER TABLE `commine`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `country_list`
--
ALTER TABLE `country_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `duka_trash`
--
ALTER TABLE `duka_trash`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jb_address`
--
ALTER TABLE `jb_address`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `live_message`
--
ALTER TABLE `live_message`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_number` (`order_number`),
  ADD KEY `product_code` (`product_code`);

--
-- Indexes for table `order_tracking`
--
ALTER TABLE `order_tracking`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_tracking_constraint` (`order_number`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_subcategory_constraint` (`category_id`),
  ADD KEY `producT-owner_id` (`user_id`);

--
-- Indexes for table `product_brand`
--
ALTER TABLE `product_brand`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_category`
--
ALTER TABLE `product_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_gallery`
--
ALTER TABLE `product_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_gallery_constraint` (`product_id`);

--
-- Indexes for table `quartie`
--
ALTER TABLE `quartie`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_address`
--
ALTER TABLE `user_address`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `User_details_constraint` (`user_id`);

--
-- Indexes for table `wolf_content`
--
ALTER TABLE `wolf_content`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wolf_image`
--
ALTER TABLE `wolf_image`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- AUTO_INCREMENT for table `cms_section`
--
ALTER TABLE `cms_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

--
-- AUTO_INCREMENT for table `duka_trash`
--
ALTER TABLE `duka_trash`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `jb_address`
--
ALTER TABLE `jb_address`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `live_message`
--
ALTER TABLE `live_message`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

--
-- AUTO_INCREMENT for table `order_tracking`
--
ALTER TABLE `order_tracking`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `product_brand`
--
ALTER TABLE `product_brand`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `product_gallery`
--
ALTER TABLE `product_gallery`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `quartie`
--
ALTER TABLE `quartie`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `user_address`
--
ALTER TABLE `user_address`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `user_details`
--
ALTER TABLE `user_details`
  MODIFY `id` int(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

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

--
-- AUTO_INCREMENT for table `wolf_image`
--
ALTER TABLE `wolf_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;

