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


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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `quantity` int(10) 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;

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

--
-- Table structure for table `cart_options`
--

CREATE TABLE `cart_options` (
  `option_id` int(10) UNSIGNED NOT NULL,
  `cart_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Tools', 'Quas provident quis voluptatem sit aut sed. Officiis aspernatur quia aliquam quisquam enim. Repudiandae distinctio blanditiis earum hic itaque aut. Rerum ad possimus amet voluptatem eligendi maiores suscipit et. In omnis inventore laudantium consectetur alias velit non.', '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(2, 'Vegetables', 'Placeat iure corrupti nulla non omnis vitae amet voluptatem. Quia est inventore sed saepe. Placeat eius ea rerum atque praesentium corporis eaque. Tenetur sed sit repudiandae aut labore repudiandae quia. Accusamus exercitationem nulla quia iusto tenetur.', '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(3, 'Medicines', 'Non magni et placeat quod. Aut et iure voluptatem quaerat rerum ut sunt. Labore nulla vero rerum a. Incidunt nemo nihil laborum rerum. Placeat eos et dolore corporis cupiditate ex.', '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(4, 'Medicines', 'Impedit culpa dignissimos voluptatem illo autem quisquam est. Ex porro qui aperiam ab et ut aut. Vero laudantium tempora et. Doloremque deserunt ipsa distinctio quia repudiandae. Ut quas repellat atque assumenda vitae.', '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(5, 'Vegetables', 'Sed ad architecto voluptatem at commodi fugit qui quas. Architecto molestiae dolores et in ratione. Consectetur et delectus tenetur quia dicta facere est. Enim consequatur delectus sed repudiandae mollitia. Et quae nostrum perspiciatis enim eos nobis tempore adipisci.', '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(6, 'Fish', 'Nulla voluptatibus odio quae officiis et laborum. Eum tempora illum est occaecati et. Et non a sed eos quasi voluptatem et repellendus. Quod tempore debitis veniam accusantium minima aspernatur unde. Eveniet reprehenderit et molestias esse dolorem iste quibusdam.', '2020-11-04 04:34:58', '2020-11-04 04:34:58');

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

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

CREATE TABLE `coupons` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` double(8,2) NOT NULL DEFAULT '0.00',
  `discount_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percent',
  `description` text COLLATE utf8mb4_unicode_ci,
  `expires_at` datetime DEFAULT NULL,
  `enabled` tinyint(1) 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;

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

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

CREATE TABLE `currencies` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `decimal_digits` tinyint(3) UNSIGNED DEFAULT NULL,
  `rounding` tinyint(3) UNSIGNED 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 `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `symbol`, `code`, `decimal_digits`, `rounding`, `created_at`, `updated_at`) VALUES
(1, 'US Dollar', '$', 'USD', 2, 0, '2019-10-22 10:20:48', '2019-10-22 10:20:48'),
(2, 'Euro', '€', 'EUR', 2, 0, '2019-10-22 10:21:39', '2019-10-22 10:21:39'),
(3, 'Indian Rupee', 'টকা', 'INR', 2, 0, '2019-10-22 10:22:50', '2019-10-22 10:22:50'),
(4, 'Indonesian Rupiah', 'Rp', 'IDR', 0, 0, '2019-10-22 10:23:22', '2019-10-22 10:23:22'),
(5, 'Brazilian Real', 'R$', 'BRL', 2, 0, '2019-10-22 10:24:00', '2019-10-22 10:24:00'),
(6, 'Cambodian Riel', '៛', 'KHR', 2, 0, '2019-10-22 10:25:51', '2019-10-22 10:25:51'),
(7, 'Vietnamese Dong', '₫', 'VND', 0, 0, '2019-10-22 10:26:26', '2019-10-22 10:26:26');

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

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(56) COLLATE utf8mb4_unicode_ci NOT NULL,
  `values` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  `required` tinyint(1) DEFAULT NULL,
  `in_table` tinyint(1) DEFAULT NULL,
  `bootstrap_column` tinyint(4) DEFAULT NULL,
  `order` tinyint(4) DEFAULT NULL,
  `custom_field_model` varchar(127) 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 `custom_fields`
--

INSERT INTO `custom_fields` (`id`, `name`, `type`, `values`, `disabled`, `required`, `in_table`, `bootstrap_column`, `order`, `custom_field_model`, `created_at`, `updated_at`) VALUES
(4, 'phone', 'text', NULL, 0, 0, 0, 6, 2, 'App\\Models\\User', '2019-09-06 16:00:00', '2019-09-06 16:01:47'),
(5, 'bio', 'textarea', NULL, 0, 0, 0, 6, 1, 'App\\Models\\User', '2019-09-06 16:13:58', '2019-09-06 16:13:58'),
(6, 'address', 'text', NULL, 0, 0, 0, 6, 3, 'App\\Models\\User', '2019-09-06 16:19:22', '2019-09-06 16:19:22');

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

--
-- Table structure for table `custom_field_values`
--

CREATE TABLE `custom_field_values` (
  `id` int(10) UNSIGNED NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  `view` longtext COLLATE utf8mb4_unicode_ci,
  `custom_field_id` int(10) UNSIGNED NOT NULL,
  `customizable_type` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customizable_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 `custom_field_values`
--

INSERT INTO `custom_field_values` (`id`, `value`, `view`, `custom_field_id`, `customizable_type`, `customizable_id`, `created_at`, `updated_at`) VALUES
(29, '+136 226 5669', '+136 226 5669', 4, 'App\\Models\\User', 2, '2019-09-06 16:22:30', '2019-09-06 16:22:30'),
(30, 'Lobortis mattis aliquam faucibus purus. Habitasse platea dictumst vestibulum rhoncus est pellentesque elit. Nunc vel risus commodo viverra maecenas accumsan lacus vel.', 'Lobortis mattis aliquam faucibus purus. Habitasse platea dictumst vestibulum rhoncus est pellentesque elit. Nunc vel risus commodo viverra maecenas accumsan lacus vel.', 5, 'App\\Models\\User', 2, '2019-09-06 16:22:30', '2019-10-16 14:02:35'),
(31, '2911 Corpening Drive South Lyon, MI 48178', '2911 Corpening Drive South Lyon, MI 48178', 6, 'App\\Models\\User', 2, '2019-09-06 16:22:30', '2019-10-16 14:02:35'),
(32, '+136 226 5660', '+136 226 5660', 4, 'App\\Models\\User', 1, '2019-09-06 16:23:58', '2019-09-27 02:42:04'),
(33, 'Faucibus ornare suspendisse sed nisi lacus sed. Pellentesque sit amet porttitor eget dolor morbi non arcu. Eu scelerisque felis imperdiet proin fermentum leo vel orci porta', 'Faucibus ornare suspendisse sed nisi lacus sed. Pellentesque sit amet porttitor eget dolor morbi non arcu. Eu scelerisque felis imperdiet proin fermentum leo vel orci porta', 5, 'App\\Models\\User', 1, '2019-09-06 16:23:58', '2019-10-16 13:53:53'),
(34, '569 Braxton Street Cortland, IL 60112', '569 Braxton Street Cortland, IL 60112', 6, 'App\\Models\\User', 1, '2019-09-06 16:23:58', '2019-10-16 13:53:53'),
(35, '+1 098-6543-236', '+1 098-6543-236', 4, 'App\\Models\\User', 3, '2019-10-15 11:51:32', '2019-10-17 17:51:43'),
(36, 'Aliquet porttitor lacus luctus accumsan tortor posuere ac ut. Tortor pretium viverra suspendisse', 'Aliquet porttitor lacus luctus accumsan tortor posuere ac ut. Tortor pretium viverra suspendisse', 5, 'App\\Models\\User', 3, '2019-10-15 11:51:32', '2019-10-17 17:51:12'),
(37, '1850 Big Elm Kansas City, MO 64106', '1850 Big Elm Kansas City, MO 64106', 6, 'App\\Models\\User', 3, '2019-10-15 11:51:32', '2019-10-17 17:51:43'),
(38, '+1 248-437-7610', '+1 248-437-7610', 4, 'App\\Models\\User', 4, '2019-10-16 14:01:46', '2019-10-16 14:01:46'),
(39, 'Faucibus ornare suspendisse sed nisi lacus sed. Pellentesque sit amet porttitor eget dolor morbi non arcu. Eu scelerisque felis imperdiet proin fermentum leo vel orci porta', 'Faucibus ornare suspendisse sed nisi lacus sed. Pellentesque sit amet porttitor eget dolor morbi non arcu. Eu scelerisque felis imperdiet proin fermentum leo vel orci porta', 5, 'App\\Models\\User', 4, '2019-10-16 14:01:46', '2019-10-16 14:01:46'),
(40, '1050 Frosty Lane Sidney, NY 13838', '1050 Frosty Lane Sidney, NY 13838', 6, 'App\\Models\\User', 4, '2019-10-16 14:01:46', '2019-10-16 14:01:46'),
(41, '+136 226 5669', '+136 226 5669', 4, 'App\\Models\\User', 5, '2019-12-15 13:19:44', '2019-12-15 13:19:44'),
(42, '<p>Short Bio</p>', 'Short Bio', 5, 'App\\Models\\User', 5, '2019-12-15 13:19:44', '2019-12-15 13:19:44'),
(43, '4722 Villa Drive', '4722 Villa Drive', 6, 'App\\Models\\User', 5, '2019-12-15 13:19:44', '2019-12-15 13:19:44'),
(44, '+136 955 6525', '+136 955 6525', 4, 'App\\Models\\User', 6, '2020-03-29 11:58:04', '2020-03-29 11:58:04'),
(45, '<p>Short bio for this driver</p>', 'Short bio for this driver', 5, 'App\\Models\\User', 6, '2020-03-29 11:58:05', '2020-03-29 11:58:05'),
(46, '4722 Villa Drive', '4722 Villa Drive', 6, 'App\\Models\\User', 6, '2020-03-29 11:58:05', '2020-03-29 11:58:05');

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

--
-- Table structure for table `delivery_addresses`
--

CREATE TABLE `delivery_addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `user_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 `delivery_addresses`
--

INSERT INTO `delivery_addresses` (`id`, `description`, `address`, `latitude`, `longitude`, `is_default`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Eligendi assumenda fugit et non animi.', '47779 Carey Forge Suite 733\nAmericashire, IL 73687-1515', '23.654687', '22.355413', 0, 2, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(2, 'Nostrum asperiores aspernatur tenetur dolorum praesentium cumque.', '77095 Roselyn Bridge\nJoannebury, DC 46011', '56.191285', '111.538605', 1, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(3, 'Non sunt consequatur illo iste dolores magni voluptates sit.', '497 Mertie Centers Apt. 661\nNorth Luciano, TN 31718-5688', '3.798833', '154.889719', 0, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(4, 'Atque fuga quisquam velit rerum voluptates.', '907 Karen Pass Suite 843\nAnnabelside, LA 77379', '72.870561', '-122.396538', 0, 6, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(5, 'Et est ut reprehenderit repellat tempora fuga ullam magni.', '3894 Windler Creek Apt. 524\nSouth Odessa, WI 26147-2294', '27.679434', '24.051022', 0, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(6, 'Non eum at quaerat unde et vero velit.', '9873 D\'Amore Bypass Apt. 974\nEast Jerrold, ID 35703-7513', '62.290475', '57.338357', 0, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(7, 'Veritatis voluptas hic corporis.', '742 Cassandra Court Suite 549\nSchambergerville, IL 76443-6215', '6.999935', '-85.954748', 0, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(8, 'Et dolorem laudantium labore ut libero sint omnis.', '4688 Turcotte Ferry Apt. 248\nPort Gust, MD 97766-2520', '-43.394537', '-30.381321', 1, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(9, 'Cupiditate nihil asperiores est unde consequatur.', '46439 Javon Crescent\nBeckerbury, NY 27883-7052', '7.334126', '59.180046', 1, 5, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(10, 'Cupiditate totam in impedit.', '9012 Abshire Causeway\nAlainachester, KS 90390-3733', '-12.298635', '147.227516', 1, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(11, 'Alias harum neque inventore dolorem debitis.', '942 Konopelski Mission Apt. 509\nEast Lloyd, DC 74848-4727', '35.136528', '152.477951', 1, 5, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(12, 'Ut ea quidem natus nemo.', '207 Osinski Island\nNew Brandoshire, WI 83095-2901', '52.73259', '43.589202', 1, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(13, 'Qui ea debitis beatae vitae eligendi officiis qui.', '53540 Morgan Street\nMorarshire, MT 17088-8907', '-78.283976', '71.495788', 0, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(14, 'Ullam sed et impedit possimus et exercitationem voluptatem.', '101 Boyle Fields\nMohrhaven, DE 21744', '23.511627', '-151.501187', 0, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(15, 'Est quidem unde voluptates dolore.', '2359 Strosin Pines\nWest Claudiaborough, DC 71204-8050', '39.770252', '-1.477809', 1, 6, '2020-11-04 04:35:00', '2020-11-04 04:35:00');

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

--
-- Table structure for table `discountables`
--

CREATE TABLE `discountables` (
  `id` int(10) UNSIGNED NOT NULL,
  `coupon_id` int(10) UNSIGNED NOT NULL,
  `discountable_type` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discountable_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `drivers`
--

CREATE TABLE `drivers` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `delivery_fee` double(5,2) NOT NULL DEFAULT '0.00',
  `total_orders` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `earning` double(9,2) NOT NULL DEFAULT '0.00',
  `available` tinyint(1) 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;

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

--
-- Table structure for table `drivers_payouts`
--

CREATE TABLE `drivers_payouts` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `method` varchar(127) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double(9,2) NOT NULL DEFAULT '0.00',
  `paid_date` datetime DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `driver_markets`
--

CREATE TABLE `driver_markets` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `market_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `driver_markets`
--

INSERT INTO `driver_markets` (`user_id`, `market_id`) VALUES
(5, 1),
(5, 2),
(6, 2),
(6, 3),
(5, 4),
(6, 4);

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

--
-- Table structure for table `earnings`
--

CREATE TABLE `earnings` (
  `id` int(10) UNSIGNED NOT NULL,
  `market_id` int(10) UNSIGNED NOT NULL,
  `total_orders` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `total_earning` double(9,2) NOT NULL DEFAULT '0.00',
  `admin_earning` double(9,2) NOT NULL DEFAULT '0.00',
  `market_earning` double(9,2) NOT NULL DEFAULT '0.00',
  `delivery_fee` double(9,2) NOT NULL DEFAULT '0.00',
  `tax` double(9,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(10) UNSIGNED NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  `faq_category_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 `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `faq_category_id`, `created_at`, `updated_at`) VALUES
(1, 'Quasi aut molestiae dolorum vitae et numquam et. Omnis ipsa aliquid nesciunt.', 'She is such a fall as this, I shall be a book written about me, that there ought! And when I got up in a large plate came skimming out, straight at the Hatter, and, just as she could. The next thing.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(2, 'Et sequi maxime aut fugit. Culpa id odio consequatur ipsa iste ut.', 'I can\'t show it you myself,\' the Mock Turtle. So she set the little golden key was too much overcome to do next, when suddenly a footman in livery, with a round face, and large eyes full of tears.', 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(3, 'Et nam perspiciatis veniam maiores et voluptatem. Fugiat eius et assumenda sed.', 'How she longed to change the subject,\' the March Hare, \'that \"I breathe when I got up this morning, but I grow up, I\'ll write one--but I\'m grown up now,\' she said, without even looking round. \'I\'ll.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(4, 'Repellat perspiciatis sint est quisquam harum eveniet voluptas et. Odio et qui at id.', 'Alice caught the baby violently up and down in a furious passion, and went on in these words: \'Yes, we went to school in the sea. But they HAVE their tails in their mouths; and the baby joined).', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(5, 'Commodi ea eveniet non quia eum ullam in. Sint ratione vitae tempore.', 'Alice, who always took a minute or two to think about stopping herself before she had a bone in his confusion he bit a large pool all round her, calling out in a low, trembling voice. \'There\'s more.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(6, 'Ipsum odio illum non ex eaque deleniti. Enim officiis sed aliquam temporibus ducimus.', 'Duchess; \'I never thought about it,\' said Alice hastily; \'but I\'m not looking for them, but they began solemnly dancing round and look up and said, without even looking round. \'I\'ll fetch the.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(7, 'Dolorum quo enim illo qui consequatur et nobis. Corrupti eos unde fugiat illo in.', 'Caterpillar. Alice thought to herself, for this time she heard a voice of the goldfish kept running in her life before, and she was now about two feet high: even then she walked down the middle.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(8, 'Non quod ducimus fugit. Qui quibusdam aperiam aut qui. Voluptas nam distinctio facere quaerat.', 'I know THAT well enough; don\'t be nervous, or I\'ll have you got in as well,\' the Hatter and the moment they saw Alice coming. \'There\'s PLENTY of room!\' said Alice to herself, \'Why, they\'re only a.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(9, 'Aut fuga velit illum vitae architecto eum. Excepturi ducimus quo ut.', 'Alice ventured to remark. \'Tut, tut, child!\' said the Caterpillar. Alice thought she might find another key on it, for she could remember about ravens and writing-desks, which wasn\'t much. The.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(10, 'Quo adipisci incidunt beatae voluptas. Eligendi et facilis a fugiat adipisci aut qui.', 'White Rabbit with pink eyes ran close by her. There was certainly too much frightened to say when I was going off into a line along the course, here and there was a little timidly, for she had.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(11, 'Tenetur quo officia quae aliquid delectus illum. Repellat ipsa et minus id perspiciatis et hic.', 'Come on!\' So they began running about in a solemn tone, only changing the order of the reeds--the rattling teacups would change to tinkling sheep-bells, and the soldiers remaining behind to execute.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(12, 'Quod ratione nihil ipsa aliquam. Iste quam ducimus eos consequatur earum dignissimos.', 'It sounded an excellent plan, no doubt, and very soon had to do it! Oh dear! I shall fall right THROUGH the earth! How funny it\'ll seem, sending presents to one\'s own feet! And how odd the.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(13, 'Aut ut quisquam animi ratione. Eos sunt provident quam doloremque suscipit iste.', 'Gryphon: and it set to work throwing everything within her reach at the stick, and tumbled head over heels in its hurry to change the subject. \'Go on with the lobsters, out to her daughter \'Ah, my.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(14, 'Totam blanditiis incidunt eos maiores. Magni molestias molestiae odit enim aut ad laudantium ullam.', 'As for pulling me out of the wood for fear of their hearing her; and the jury eagerly wrote down all three to settle the question, and they sat down, and nobody spoke for some time without hearing.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(15, 'Suscipit sed ratione quo. Tenetur quia laudantium et voluptatem nulla sed.', 'With gently smiling jaws!\' \'I\'m sure those are not attending!\' said the Duchess; \'I never thought about it,\' added the Dormouse. \'Write that down,\' the King said, with a sigh. \'I only took the watch.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(16, 'Nam delectus est est voluptas. Est ut et quia odio eius dolorem voluptatum.', 'They all returned from him to be listening, so she went hunting about, and crept a little door about fifteen inches high: she tried her best to climb up one of these cakes,\' she thought, and looked.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(17, 'Nam beatae molestiae similique qui enim cum. Molestiae quidem ipsum quos officiis error.', 'Dodo had paused as if his heart would break. She pitied him deeply. \'What is his sorrow?\' she asked the Gryphon, before Alice could hear him sighing as if she were looking over their shoulders, that.', 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(18, 'Odio enim doloremque voluptas quas et at sit. Ab dolore at sed.', 'Gryphon. \'I\'ve forgotten the Duchess replied, in a tone of this pool? I am very tired of being all alone here!\' As she said to herself, as well say,\' added the Hatter, it woke up again as quickly as.', 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(19, 'Et sapiente sint sunt ab itaque. Provident et architecto aut natus minus ratione.', 'Shakespeare, in the window, and one foot up the fan and a bright brass plate with the end of every line: \'Speak roughly to your little boy, And beat him when he sneezes; For he can thoroughly enjoy.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(20, 'Labore illo sint illum. Molestiae vel error sapiente dolor odio.', 'Pigeon in a low, timid voice, \'If you do. I\'ll set Dinah at you!\' There was a long time with great emphasis, looking hard at Alice for protection. \'You shan\'t be beheaded!\' said Alice, and she tried.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(21, 'Facilis est excepturi voluptatem culpa. Repudiandae repellat maxime aliquid iste sed voluptate.', 'Cat. \'--so long as it was over at last, more calmly, though still sobbing a little startled when she found that her shoulders were nowhere to be managed? I suppose it were white, but there were no.', 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(22, 'Aut rerum vel aliquam et nobis sed eius. Eum nesciunt repellat qui eveniet.', 'Owl, as a cushion, resting their elbows on it, and finding it very hard indeed to make out at the end of the song. \'What trial is it?\' The Gryphon sat up and leave the court; but on the whole pack.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(23, 'Et dolore autem dicta magni. Eum dolor vero voluptas.', 'It was, no doubt: only Alice did not answer, so Alice soon came to the Hatter. Alice felt dreadfully puzzled. The Hatter\'s remark seemed to have lessons to learn! No, I\'ve made up my mind about it.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(24, 'Dolore deserunt nostrum blanditiis quo. Neque animi est animi placeat quisquam.', 'And he got up and to her in the world! Oh, my dear paws! Oh my dear paws! Oh my dear paws! Oh my fur and whiskers! She\'ll get me executed, as sure as ferrets are ferrets! Where CAN I have done.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(25, 'Est sapiente quisquam voluptas. Optio et eos qui minima nihil nihil.', 'Gryphon, and, taking Alice by the little dears came jumping merrily along hand in hand, in couples: they were IN the well,\' Alice said to herself, for this time she found this a good deal frightened.', 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(26, 'Enim ipsam minus autem incidunt in illum recusandae. Vitae nostrum itaque occaecati et sit.', 'ALL RETURNED FROM HIM TO YOU,\"\' said Alice. \'Then it doesn\'t matter much,\' thought Alice, as she stood still where she was, and waited. When the Mouse was bristling all over, and she jumped up and.', 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(27, 'Iure fugit sint et. Ut molestiae quo laudantium. Rem dolorem quo quis similique neque ab quis.', 'Alice for protection. \'You shan\'t be able! I shall see it pop down a good many little girls eat eggs quite as safe to stay in here any longer!\' She waited for some time without hearing anything.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(28, 'Maxime alias animi nobis et laboriosam. Et labore commodi iste et voluptate id ea amet.', 'The long grass rustled at her rather inquisitively, and seemed to think about stopping herself before she came upon a low voice, to the Mock Turtle said with some difficulty, as it happens; and if.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(29, 'Deleniti in ullam natus aut. Nulla ea inventore cupiditate quisquam pariatur fugiat.', 'Alice could think of nothing better to say anything. \'Why,\' said the Gryphon. \'We can do no more, whatever happens. What WILL become of it; and as Alice could not remember ever having heard of one,\'.', 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(30, 'Non est sed quo voluptatem. Minima rerum molestiae quibusdam qui.', 'You gave us three or more; They all returned from him to be a comfort, one way--never to be lost, as she spoke, but no result seemed to think to herself, \'to be going messages for a minute, trying.', 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01');

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

--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) 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 `faq_categories`
--

INSERT INTO `faq_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Products', '2019-08-31 07:01:52', '2019-08-31 07:01:52'),
(2, 'Services', '2019-08-31 07:02:03', '2019-08-31 07:02:03'),
(3, 'Delivery', '2019-08-31 07:02:11', '2019-08-31 07:02:11'),
(4, 'Misc', '2019-08-31 07:02:17', '2019-08-31 07:02:17');

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

--
-- Table structure for table `favorites`
--

CREATE TABLE `favorites` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `user_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 `favorites`
--

INSERT INTO `favorites` (`id`, `product_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 25, 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(2, 23, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(3, 29, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(4, 5, 6, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(5, 2, 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(6, 22, 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(7, 18, 3, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(8, 14, 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(9, 10, 6, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(10, 7, 5, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(11, 18, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(12, 28, 6, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(13, 9, 5, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(14, 15, 5, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(15, 15, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(16, 29, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(17, 27, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(18, 24, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(19, 9, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(20, 20, 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(21, 16, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(22, 6, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(23, 11, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(24, 13, 2, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(25, 14, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(26, 10, 5, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(27, 25, 6, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(28, 7, 4, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(29, 19, 6, '2020-11-04 04:35:01', '2020-11-04 04:35:01'),
(30, 16, 1, '2020-11-04 04:35:01', '2020-11-04 04:35:01');

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

--
-- Table structure for table `favorite_options`
--

CREATE TABLE `favorite_options` (
  `option_id` int(10) UNSIGNED NOT NULL,
  `favorite_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favorite_options`
--

INSERT INTO `favorite_options` (`option_id`, `favorite_id`) VALUES
(1, 1),
(3, 2),
(5, 3),
(1, 5),
(2, 6);

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

--
-- Table structure for table `fields`
--

CREATE TABLE `fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `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 `fields`
--

INSERT INTO `fields` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Grocery', 'Eum similique maiores atque quia explicabo. Dolores quia placeat consequatur id quis perspiciatis. Ducimus sit ducimus officia labore maiores et porro. Est iusto natus nesciunt debitis consequuntur totam. Et illo et autem inventore earum corrupti.', '2020-04-11 09:33:21', '2020-04-11 09:33:21'),
(2, 'Pharmacy', 'Eaque et aut natus. Minima blanditiis ut sunt distinctio ad. Quasi doloremque rerum ex rerum. Molestias similique similique aut rerum delectus blanditiis et. Dolorem et quas nostrum est nobis.', '2020-04-11 09:33:21', '2020-04-11 09:33:21'),
(3, 'Restaurant', 'Est nihil omnis natus ducimus ducimus excepturi quos. Et praesentium in quia veniam. Tempore aut nesciunt consequatur pariatur recusandae. Voluptatem commodi eius quaerat est deleniti impedit. Qui quo harum est sequi incidunt labore eligendi cum.', '2020-04-11 09:33:21', '2020-04-11 09:33:21'),
(4, 'Store', 'Ex nostrum suscipit aut et labore. Ut dolor ut eum eum voluptatem ex. Sapiente in tempora soluta voluptatem. Officia accusantium quae sit. Rerum esse ipsa molestias dolorem et est autem consequatur.', '2020-04-11 09:33:21', '2020-04-11 09:33:21'),
(5, 'Electronics', 'Dolorum earum ut blanditiis blanditiis. Facere quis voluptates assumenda saepe. Ab aspernatur voluptatibus rem doloremque cum impedit. Itaque blanditiis commodi repudiandae asperiores. Modi atque placeat consectetur et aut blanditiis.', '2020-04-11 09:33:21', '2020-04-11 09:33:21'),
(6, 'Furniture', 'Est et iste enim. Quam repudiandae commodi rerum non esse. Et in aut sequi est aspernatur. Facere non modi expedita asperiores. Ipsa laborum saepe deserunt qui consequatur voluptas inventore dolorum.', '2020-04-11 09:33:21', '2020-04-11 09:33:21');

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` int(10) UNSIGNED NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `market_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 `galleries`
--

INSERT INTO `galleries` (`id`, `description`, `market_id`, `created_at`, `updated_at`) VALUES
(1, 'Pariatur tempora ut sequi.', 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(2, 'At non debitis officia est.', 9, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(3, 'Ut et neque et facilis temporibus voluptatem.', 10, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(4, 'Aut numquam enim minus sed fugiat.', 9, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(5, 'Omnis ex aliquid rerum corrupti.', 10, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(6, 'Repudiandae odio est id ullam occaecati qui.', 10, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(7, 'Dolor sit ad sed nostrum minus est facilis.', 5, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(8, 'Nulla eligendi et et enim.', 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(9, 'Sint et beatae expedita deleniti deleniti.', 7, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(10, 'Perspiciatis et labore et veniam minus.', 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(11, 'Consequuntur in voluptatem ipsum non architecto sapiente.', 8, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(12, 'Eos ullam impedit est porro.', 7, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(13, 'Aliquid dicta nam sunt quae suscipit repellat.', 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(14, 'Voluptas distinctio minima cumque qui quos.', 10, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(15, 'Ducimus harum illum sed dolor vero cumque perferendis rerum.', 7, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(16, 'Cumque et rem nam expedita hic totam in.', 5, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(17, 'Sed ratione et eius omnis in dolore.', 10, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(18, 'Quo nobis nam porro labore sit quibusdam amet quis.', 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(19, 'Et consectetur voluptatem possimus officiis.', 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(20, 'Officiis alias nihil nisi nihil dicta excepturi impedit.', 1, '2020-11-04 04:34:59', '2020-11-04 04:34:59');

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

--
-- Table structure for table `markets`
--

CREATE TABLE `markets` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `information` text COLLATE utf8mb4_unicode_ci,
  `admin_commission` double(8,2) DEFAULT '0.00',
  `delivery_fee` double(8,2) DEFAULT '0.00',
  `delivery_range` double(8,2) DEFAULT '0.00',
  `default_tax` double(8,2) DEFAULT '0.00',
  `closed` tinyint(1) DEFAULT '0',
  `active` tinyint(1) DEFAULT '0',
  `available_for_delivery` tinyint(1) 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 `markets`
--

INSERT INTO `markets` (`id`, `name`, `description`, `address`, `latitude`, `longitude`, `phone`, `mobile`, `information`, `admin_commission`, `delivery_fee`, `delivery_range`, `default_tax`, `closed`, `active`, `available_for_delivery`, `created_at`, `updated_at`) VALUES
(1, 'Shop Green, Johnston and Rohan', 'Similique velit voluptatibus laboriosam et earum eum. At quasi labore voluptatem quo accusantium. Cupiditate a incidunt enim at.', '64174 Fadel Ford\nEast Stone, HI 31984', '48.158205', '7.17521', '1-346-790-2229 x1247', '(231) 558-1420', 'Et alias officiis et officia facere. Pariatur vel totam voluptas perferendis maiores accusantium. Cumque voluptatem quisquam saepe veniam vel.', 20.53, 5.54, 19.33, 27.11, 1, 1, 1, '2020-11-04 04:34:57', '2020-11-04 04:34:57'),
(2, 'Market Pouros-Haag', 'Voluptas incidunt iusto vitae ullam. Dolorum non tempora et ducimus et aut. Amet doloribus corporis consequatur saepe ea aut quia.', '24088 Korbin Walks\nTillmanside, MD 07628-1573', '52.737353', '10.562995', '468-923-3719', '1-983-772-9140 x28969', 'Velit sapiente veniam modi repellendus molestiae odio dolor. Voluptatem modi ex ut quos tenetur nisi harum quis. Eligendi doloremque magnam voluptates maxime at corrupti.', 18.49, 7.93, 24.37, 21.80, 0, 1, 0, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(3, 'Furniture Olson Group', 'Et nulla voluptate accusantium earum libero blanditiis. Repellendus dolorem dicta incidunt velit enim. Dolore officia eum aut est amet.', '287 Nestor Squares Suite 129\nBobury, DC 76332-4823', '49.973026', '9.673465', '510-586-6174', '792.788.2285', 'Officiis illo perspiciatis deleniti voluptatem. Facere dolorum explicabo blanditiis voluptas voluptatem tenetur. A est eligendi perferendis voluptas reiciendis quos at.', 21.90, 4.73, 8.85, 27.95, 1, 1, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(4, 'Mall Yost, Kub and Mayert', 'Ipsa voluptas mollitia a qui. Aut consequatur eligendi odit dolorum. Asperiores magnam nesciunt ullam laudantium aut ex perferendis. Animi at aut dolor itaque dolor.', '9296 Kuhic Greens Apt. 538\nZiemannfort, TN 81584-7172', '48.912674', '10.483163', '678-329-8578', '718-735-5866', 'Cum ullam eum facilis quia eveniet quo. Autem vel accusantium ipsam labore. Rerum quia est quod.', 23.50, 2.70, 14.28, 9.51, 0, 1, 0, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(5, 'Mall Friesen-Hoeger', 'Dignissimos aut quia perspiciatis debitis tenetur iste omnis. Rerum vel iure nobis deleniti id non.', '970 Mandy Summit\nDachshire, MS 65282', '49.392177', '11.208377', '670-551-5584', '+1 (294) 769-2892', 'Sequi ipsa eius culpa exercitationem inventore aut error. Et doloremque quia praesentium excepturi. Delectus et incidunt similique impedit odio doloribus voluptate beatae.', 43.65, 6.58, 73.06, 13.35, 0, 1, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(6, 'Furniture Kassulke and Sons', 'Enim enim vitae a consequatur. Eius aut excepturi dolorum adipisci molestias. Aut qui eligendi culpa deserunt sit.', '47994 Lenora Creek\nSouth Nellie, AL 89870-0017', '47.46644', '9.069887', '298-643-0143', '1-667-755-4590 x71072', 'Repellat natus dolores omnis voluptates qui iusto blanditiis. Sint facere voluptatibus magni aut eos quod. Odit magni voluptatem quae ullam nobis consectetur.', 15.39, 2.27, 82.41, 17.97, 1, 1, 0, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(7, 'Furniture Lebsack, Weber and Dickens', 'Eveniet voluptates reiciendis tempora suscipit. Nihil adipisci quisquam sed aut nobis. Et tempora perspiciatis incidunt iure. Blanditiis doloremque repudiandae dolor minima.', '82131 Arnold Square Apt. 808\nDawsonfurt, TX 04002-7932', '37.416559', '7.438145', '(395) 772-1826', '525-425-4784', 'Sit voluptatem facilis quod voluptas quam est. Quisquam nostrum quasi eaque reiciendis atque aliquam qui. Libero voluptate expedita eligendi ut.', 44.07, 2.03, 46.70, 22.31, 1, 1, 0, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(8, 'Market Pagac, Stracke and Brekke', 'Pariatur esse voluptatum repellat commodi. Quo debitis accusamus qui corrupti doloribus aperiam. Beatae et provident ea similique sunt earum. Fugit ullam quae et voluptas.', '52721 Romaguera Way\nPascalestad, ID 98338-6497', '53.839332', '10.44043', '971-602-9993', '997.772.7815 x10418', 'Praesentium ut qui consequatur commodi vel enim sit. Alias minus aut dolor provident eveniet sed ut. Quia et nihil rerum.', 13.56, 5.99, 71.24, 15.44, 0, 1, 0, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(9, 'Shop Lebsack-Reichert', 'Ad tenetur aut aperiam nihil. Dolore unde dolores et. Doloribus sunt voluptatum suscipit sed reiciendis quia.', '6474 Bette Trafficway Suite 287\nNorth Juston, LA 18233', '49.15197', '10.584199', '+1 (394) 444-0424', '1-592-820-1536', 'Sed et et quisquam dolorem. Blanditiis et nam numquam molestias. Et magnam ex ea eaque delectus.', 24.72, 5.73, 87.27, 11.86, 0, 1, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(10, 'Mall Boyle and Sons', 'Asperiores amet nam vitae qui quod ut eligendi velit. Culpa autem est ea ut porro aut. Ut nihil molestias voluptas et mollitia placeat. In ullam voluptas veritatis voluptas est.', '68689 Kolby Parkway Suite 384\nWest Kurtisberg, NV 47985', '49.606416', '10.868298', '(338) 814-2982 x03317', '(902) 891-9128 x88202', 'Dolorem molestiae quis quia reprehenderit excepturi. Assumenda dolores corporis quam vero laudantium tempora molestias. Possimus hic dolorem sed sunt.', 41.35, 9.94, 31.70, 19.70, 0, 1, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58');

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

--
-- Table structure for table `markets_payouts`
--

CREATE TABLE `markets_payouts` (
  `id` int(10) UNSIGNED NOT NULL,
  `market_id` int(10) UNSIGNED NOT NULL,
  `method` varchar(127) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double(9,2) NOT NULL DEFAULT '0.00',
  `paid_date` datetime DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `market_fields`
--

CREATE TABLE `market_fields` (
  `field_id` int(10) UNSIGNED NOT NULL,
  `market_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `market_fields`
--

INSERT INTO `market_fields` (`field_id`, `market_id`) VALUES
(2, 1),
(4, 1),
(2, 2),
(3, 2),
(4, 3),
(6, 5),
(3, 6),
(1, 7),
(2, 7),
(5, 8),
(1, 9),
(5, 10);

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

--
-- Table structure for table `market_reviews`
--

CREATE TABLE `market_reviews` (
  `id` int(10) UNSIGNED NOT NULL,
  `review` text COLLATE utf8mb4_unicode_ci,
  `rate` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL,
  `market_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 `market_reviews`
--

INSERT INTO `market_reviews` (`id`, `review`, `rate`, `user_id`, `market_id`, `created_at`, `updated_at`) VALUES
(1, 'Take your choice!\' The Duchess took her choice, and was gone across to the garden at once; but, alas for poor Alice! when she was terribly frightened all the right words,\' said poor Alice, \'it would.', 4, 5, 9, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(2, 'I\'m not Ada,\' she said, \'and see whether it\'s marked \"poison\" or not\'; for she was getting so used to read fairy-tales, I fancied that kind of serpent, that\'s all you know what to do, and in THAT.', 3, 1, 5, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(3, 'Alice took up the little magic bottle had now had its full effect, and she dropped it hastily, just in time to see it trying in a long, low hall, which was the matter worse. You MUST have meant some.', 4, 2, 8, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(4, 'Alice replied very gravely. \'What else have you executed on the top of its mouth, and its great eyes half shut. This seemed to rise like a sky-rocket!\' \'So you think you could keep it to half-past.', 4, 1, 10, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(5, 'Next came the royal children; there were a Duck and a long tail, certainly,\' said Alice, \'it\'s very easy to know your history, you know,\' Alice gently remarked; \'they\'d have been a RED rose-tree.', 5, 3, 5, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(6, 'There was a child,\' said the Cat, \'or you wouldn\'t keep appearing and vanishing so suddenly: you make one quite giddy.\' \'All right,\' said the Gryphon. \'It\'s all her fancy, that: he hasn\'t got no.', 3, 3, 10, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(7, 'I am in the world go round!\"\' \'Somebody said,\' Alice whispered, \'that it\'s done by everybody minding their own business,\' the Duchess began in a minute or two, and the poor little thing was to get.', 4, 1, 2, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(8, 'No accounting for tastes! Sing her \"Turtle Soup,\" will you, won\'t you, will you, won\'t you, will you join the dance? Will you, won\'t you, will you, old fellow?\' The Mock Turtle\'s Story \'You can\'t.', 4, 2, 10, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(9, 'Rabbit whispered in reply, \'for fear they should forget them before the officer could get away without being seen, when she noticed that the poor animal\'s feelings. \'I quite agree with you,\' said.', 1, 3, 8, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(10, 'Do come back in a day is very confusing.\' \'It isn\'t,\' said the King; and the sound of many footsteps, and Alice guessed who it was, and, as a partner!\' cried the Gryphon, with a sigh: \'it\'s always.', 1, 6, 2, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(11, 'Alice quite jumped; but she did not wish to offend the Dormouse shook its head impatiently, and said, without opening its eyes, \'Of course, of course; just what I say--that\'s the same side of the.', 2, 3, 8, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(12, 'The twelve jurors were all writing very busily on slates. \'What are tarts made of?\' Alice asked in a frightened tone. \'The Queen of Hearts, who only bowed and smiled in reply. \'Please come back and.', 2, 3, 10, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(13, 'Mary Ann, what ARE you doing out here? Run home this moment, and fetch me a good deal to ME,\' said Alice thoughtfully: \'but then--I shouldn\'t be hungry for it, she found a little wider. \'Come, it\'s.', 3, 2, 6, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(14, 'Alice; but she did not at all this time, and was going a journey, I should be like then?\' And she kept tossing the baby joined):-- \'Wow! wow! wow!\' While the Owl and the little crocodile Improve his.', 3, 1, 7, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(15, 'Queen. \'I haven\'t the least idea what you\'re doing!\' cried Alice, jumping up and ran till she got up, and there stood the Queen said to the beginning again?\' Alice ventured to taste it, and.', 2, 1, 6, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(16, 'I\'m better now--but I\'m a deal too far off to trouble myself about you: you must manage the best plan.\' It sounded an excellent opportunity for croqueting one of them.\' In another minute the whole.', 2, 3, 4, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(17, 'Alice ventured to say. \'What is his sorrow?\' she asked the Gryphon, sighing in his turn; and both the hedgehogs were out of the players to be no chance of getting up and walking off to other parts.', 4, 5, 4, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(18, 'I\'m perfectly sure I have dropped them, I wonder?\' And here Alice began to feel very sleepy and stupid), whether the blows hurt it or not. So she sat still and said nothing. \'This here young lady,\'.', 2, 1, 3, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(19, 'Duchess; \'and most things twinkled after that--only the March Hare, who had been wandering, when a cry of \'The trial\'s beginning!\' was heard in the wind, and the White Rabbit with pink eyes ran.', 1, 1, 1, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(20, 'And she tried another question. \'What sort of meaning in it.\' The jury all looked so grave and anxious.) Alice could hear the rattle of the lefthand bit. * * * * * * * * * * * * * * * \'Come, my.', 3, 3, 6, '2020-11-04 04:34:59', '2020-11-04 04:34:59');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `collection_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int(10) UNSIGNED NOT NULL,
  `manipulations` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_properties` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `responsive_images` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_05_26_175145_create_permission_tables', 1),
(4, '2018_06_12_140344_create_media_table', 1),
(5, '2018_06_13_035117_create_uploads_table', 1),
(6, '2018_07_17_180731_create_settings_table', 1),
(7, '2018_07_24_211308_create_custom_fields_table', 1),
(8, '2018_07_24_211327_create_custom_field_values_table', 1),
(9, '2019_08_29_213820_create_fields_table', 1),
(10, '2019_08_29_213821_create_markets_table', 1),
(11, '2019_08_29_213822_create_categories_table', 1),
(12, '2019_08_29_213826_create_option_groups_table', 1),
(13, '2019_08_29_213829_create_faq_categories_table', 1),
(14, '2019_08_29_213833_create_order_statuses_table', 1),
(15, '2019_08_29_213837_create_products_table', 1),
(16, '2019_08_29_213838_create_options_table', 1),
(17, '2019_08_29_213842_create_galleries_table', 1),
(18, '2019_08_29_213847_create_product_reviews_table', 1),
(19, '2019_08_29_213921_create_payments_table', 1),
(20, '2019_08_29_213922_create_delivery_addresses_table', 1),
(21, '2019_08_29_213926_create_faqs_table', 1),
(22, '2019_08_29_213940_create_market_reviews_table', 1),
(23, '2019_08_30_152927_create_favorites_table', 1),
(24, '2019_08_31_111104_create_orders_table', 1),
(25, '2019_09_04_153857_create_carts_table', 1),
(26, '2019_09_04_153858_create_favorite_options_table', 1),
(27, '2019_09_04_153859_create_cart_options_table', 1),
(28, '2019_09_04_153958_create_product_orders_table', 1),
(29, '2019_09_04_154957_create_product_order_options_table', 1),
(30, '2019_09_04_163857_create_user_markets_table', 1),
(31, '2019_10_22_144652_create_currencies_table', 1),
(32, '2019_12_14_134302_create_driver_markets_table', 1),
(33, '2020_03_25_094752_create_drivers_table', 1),
(34, '2020_03_25_094802_create_earnings_table', 1),
(35, '2020_03_25_094809_create_drivers_payouts_table', 1),
(36, '2020_03_25_094817_create_markets_payouts_table', 1),
(37, '2020_03_27_094855_create_notifications_table', 1),
(38, '2020_04_11_135804_create_market_fields_table', 1),
(39, '2020_08_23_181022_create_coupons_table', 1),
(40, '2020_08_23_181029_create_discountables_table', 1),
(41, '2020_09_01_192732_create_slides_table', 1);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\User', 1),
(3, 'App\\Models\\User', 2),
(4, 'App\\Models\\User', 3),
(4, 'App\\Models\\User', 4),
(5, 'App\\Models\\User', 5),
(5, 'App\\Models\\User', 6);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `product_id` int(10) UNSIGNED NOT NULL,
  `option_group_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 `options`
--

INSERT INTO `options` (`id`, `name`, `description`, `price`, `product_id`, `option_group_id`, `created_at`, `updated_at`) VALUES
(1, '1Kg', 'Natus laborum ut.', 20.50, 2, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(2, '5L', 'Nobis eos soluta reprehenderit quae.', 47.68, 6, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(3, 'L', 'Provident accusamus esse sint.', 40.58, 8, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(4, 'XL', 'Est adipisci perspiciatis autem non.', 20.98, 1, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(5, '1Kg', 'Debitis modi voluptas et.', 31.93, 25, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(6, '5L', 'Vel qui eos quam impedit.', 13.26, 7, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(7, 'L', 'Qui eum error ratione.', 13.18, 2, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(8, '2L', 'Illo explicabo animi eum facilis qui.', 31.61, 9, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(9, 'Green', 'Occaecati accusamus omnis et.', 38.62, 21, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(10, 'Tomato', 'Voluptatem temporibus enim inventore beatae.', 48.31, 14, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(11, '500g', 'Et magnam aut autem.', 32.22, 19, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(12, '1Kg', 'Amet ullam accusantium tenetur omnis.', 35.37, 7, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(13, '1Kg', 'Ratione cumque omnis.', 38.88, 13, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(14, 'Oil', 'Dolorem ea et.', 19.49, 9, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(15, 'L', 'Omnis optio facere quod facilis.', 38.29, 26, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(16, '5L', 'Ullam atque et non.', 38.50, 12, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(17, 'XL', 'Quas quia nemo corrupti.', 26.52, 2, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(18, '500g', 'Repellendus adipisci est ut rerum est.', 25.85, 15, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(19, 'Tomato', 'Molestiae consequuntur nisi autem.', 47.94, 12, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(20, 'Green', 'Atque a deserunt est fugit.', 16.15, 4, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(21, 'L', 'Sunt facilis optio et ut.', 40.47, 28, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(22, '2L', 'Quo qui optio soluta esse tempora.', 14.97, 2, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(23, 'XL', 'Vitae expedita adipisci id.', 30.88, 27, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(24, '1Kg', 'Eius velit dolores.', 48.45, 4, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(25, '500g', 'Est et aperiam distinctio ex.', 19.77, 8, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(26, 'Tomato', 'Earum voluptas alias quia.', 32.27, 22, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(27, 'Oil', 'Ea dolorem voluptatum sed.', 10.44, 20, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(28, 'XL', 'Fuga eos est reiciendis similique.', 13.92, 23, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(29, 'Oil', 'Saepe deserunt sit perferendis.', 23.82, 18, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(30, 'L', 'Corporis non dolorum eius ipsam.', 31.15, 23, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(31, '1Kg', 'Qui qui cumque.', 40.51, 30, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(32, 'L', 'Quasi cumque iusto ut.', 45.34, 30, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(33, '2L', 'Id aperiam odio sint deserunt et.', 23.29, 5, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(34, 'S', 'Assumenda quibusdam eum qui.', 48.73, 8, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(35, '1Kg', 'Non excepturi itaque dolorem quod.', 35.28, 4, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(36, 'White', 'Cumque libero minus mollitia.', 40.35, 3, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(37, 'XL', 'Esse vero eaque aut voluptatem.', 47.14, 5, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(38, 'White', 'Veniam cumque praesentium.', 26.45, 24, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(39, 'Oil', 'Sunt a aut minus corporis.', 33.74, 13, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(40, 'Green', 'Nostrum nesciunt qui eum assumenda.', 46.46, 30, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(41, '500g', 'Suscipit sit dolore voluptate velit.', 14.16, 8, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(42, 'S', 'Quidem est impedit occaecati dolores.', 42.32, 14, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(43, 'White', 'Nisi fuga voluptatibus nulla.', 42.22, 22, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(44, 'Red', 'Perferendis sapiente ratione illum omnis.', 38.51, 17, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(45, 'Tomato', 'Enim rerum ea.', 44.82, 25, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(46, 'XL', 'Nobis asperiores reprehenderit.', 47.48, 20, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(47, '1Kg', 'Nemo molestiae veritatis vel architecto rerum.', 38.03, 12, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(48, 'XL', 'Sit ipsum et qui aperiam dolorem.', 38.20, 3, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(49, 'Oil', 'Architecto cum natus deserunt.', 44.29, 6, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(50, '5L', 'Alias deleniti nulla.', 46.91, 14, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(51, 'L', 'Magni sint est ex soluta modi.', 29.05, 20, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(52, 'Green', 'Consequatur tempore et iste.', 35.91, 15, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(53, '5L', 'Magni ipsum dolores cumque.', 32.25, 13, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(54, 'White', 'Voluptatum libero in blanditiis impedit hic.', 43.46, 6, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(55, 'Red', 'Molestias hic reprehenderit illo consectetur.', 30.88, 5, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(56, 'Red', 'Eveniet possimus nesciunt qui exercitationem.', 16.08, 17, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(57, 'S', 'Molestiae dolore eos quibusdam iure hic.', 46.36, 16, 3, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(58, 'White', 'Esse voluptates aut.', 12.29, 19, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(59, '500g', 'Est officia eos et pariatur.', 34.54, 14, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(60, '2L', 'Consequatur soluta non non.', 32.38, 27, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(61, '5L', 'Doloremque aut et aut.', 18.76, 5, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(62, '1Kg', 'Et quod a beatae culpa molestiae.', 39.84, 12, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(63, 'White', 'Fugit rem ut maiores nesciunt vel.', 11.83, 29, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(64, 'XL', 'Qui soluta magni explicabo aut.', 32.22, 14, 2, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(65, 'White', 'Incidunt commodi sunt aliquid possimus.', 28.27, 23, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(66, 'Red', 'Animi sed voluptas quasi dicta odit.', 18.47, 20, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(67, 'Green', 'Quod deleniti nam ut quos.', 48.06, 2, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(68, '500g', 'Omnis aliquid hic quod.', 39.28, 2, 4, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(69, 'Tomato', 'Culpa laborum ad.', 14.48, 9, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00'),
(70, 'White', 'Qui accusantium autem.', 44.82, 22, 1, '2020-11-04 04:35:00', '2020-11-04 04:35:00');

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

--
-- Table structure for table `option_groups`
--

CREATE TABLE `option_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) 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 `option_groups`
--

INSERT INTO `option_groups` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Size', '2019-08-31 05:25:28', '2019-08-31 05:25:28'),
(2, 'Color', '2019-10-09 07:56:28', '2019-10-09 07:56:28'),
(3, 'Parfum', '2019-10-09 07:56:28', '2019-10-09 07:56:28'),
(4, 'Taste', '2019-10-09 07:56:28', '2019-10-09 07:56:28');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `order_status_id` int(10) UNSIGNED NOT NULL,
  `tax` double(5,2) DEFAULT '0.00',
  `delivery_fee` double(5,2) DEFAULT '0.00',
  `hint` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `driver_id` int(10) UNSIGNED DEFAULT NULL,
  `delivery_address_id` int(10) UNSIGNED DEFAULT NULL,
  `payment_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_statuses`
--

CREATE TABLE `order_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `status` varchar(127) 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 `order_statuses`
--

INSERT INTO `order_statuses` (`id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Order Received', '2019-08-30 11:09:28', '2019-10-15 12:33:14'),
(2, 'Preparing', '2019-10-15 12:33:50', '2019-10-15 12:33:50'),
(3, 'Ready', '2019-10-15 12:34:30', '2019-10-15 12:34:30'),
(4, 'On the Way', '2019-10-15 12:34:13', '2019-10-15 12:34:13'),
(5, 'Delivered', '2019-10-15 12:34:30', '2019-10-15 12:34:30');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(10) UNSIGNED NOT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` 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;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'users.profile', 'web', '2020-03-29 09:28:02', '2020-03-29 09:28:02', NULL),
(2, 'dashboard', 'web', '2020-03-29 09:28:02', '2020-03-29 09:28:02', NULL),
(3, 'medias.create', 'web', '2020-03-29 09:28:02', '2020-03-29 09:28:02', NULL),
(4, 'medias.delete', 'web', '2020-03-29 09:28:02', '2020-03-29 09:28:02', NULL),
(5, 'medias', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(6, 'permissions.index', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(7, 'permissions.edit', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(8, 'permissions.update', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(9, 'permissions.destroy', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(10, 'roles.index', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(11, 'roles.edit', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(12, 'roles.update', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(13, 'roles.destroy', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(14, 'customFields.index', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(15, 'customFields.create', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(16, 'customFields.store', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(17, 'customFields.show', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(18, 'customFields.edit', 'web', '2020-03-29 09:28:03', '2020-03-29 09:28:03', NULL),
(19, 'customFields.update', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(20, 'customFields.destroy', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(21, 'users.login-as-user', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(22, 'users.index', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(23, 'users.create', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(24, 'users.store', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(25, 'users.show', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(26, 'users.edit', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(27, 'users.update', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(28, 'users.destroy', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(29, 'app-settings', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(30, 'markets.index', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(31, 'markets.create', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(32, 'markets.store', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(33, 'markets.edit', 'web', '2020-03-29 09:28:04', '2020-03-29 09:28:04', NULL),
(34, 'markets.update', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(35, 'markets.destroy', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(36, 'categories.index', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(37, 'categories.create', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(38, 'categories.store', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(39, 'categories.edit', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(40, 'categories.update', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(41, 'categories.destroy', 'web', '2020-03-29 09:28:05', '2020-03-29 09:28:05', NULL),
(42, 'faqCategories.index', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(43, 'faqCategories.create', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(44, 'faqCategories.store', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(45, 'faqCategories.edit', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(46, 'faqCategories.update', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(47, 'faqCategories.destroy', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(48, 'orderStatuses.index', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(49, 'orderStatuses.show', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(50, 'orderStatuses.edit', 'web', '2020-03-29 09:28:06', '2020-03-29 09:28:06', NULL),
(51, 'orderStatuses.update', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(52, 'products.index', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(53, 'products.create', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(54, 'products.store', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(55, 'products.edit', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(56, 'products.update', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(57, 'products.destroy', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(58, 'galleries.index', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(59, 'galleries.create', 'web', '2020-03-29 09:28:07', '2020-03-29 09:28:07', NULL),
(60, 'galleries.store', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(61, 'galleries.edit', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(62, 'galleries.update', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(63, 'galleries.destroy', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(64, 'productReviews.index', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(65, 'productReviews.create', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(66, 'productReviews.store', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(67, 'productReviews.edit', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(68, 'productReviews.update', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(69, 'productReviews.destroy', 'web', '2020-03-29 09:28:08', '2020-03-29 09:28:08', NULL),
(76, 'options.index', 'web', '2020-03-29 09:28:09', '2020-03-29 09:28:09', NULL),
(77, 'options.create', 'web', '2020-03-29 09:28:09', '2020-03-29 09:28:09', NULL),
(78, 'options.store', 'web', '2020-03-29 09:28:09', '2020-03-29 09:28:09', NULL),
(79, 'options.show', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(80, 'options.edit', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(81, 'options.update', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(82, 'options.destroy', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(83, 'payments.index', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(84, 'payments.show', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(85, 'payments.update', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(86, 'faqs.index', 'web', '2020-03-29 09:28:10', '2020-03-29 09:28:10', NULL),
(87, 'faqs.create', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(88, 'faqs.store', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(89, 'faqs.edit', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(90, 'faqs.update', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(91, 'faqs.destroy', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(92, 'marketReviews.index', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(93, 'marketReviews.create', 'web', '2020-03-29 09:28:11', '2020-03-29 09:28:11', NULL),
(94, 'marketReviews.store', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(95, 'marketReviews.edit', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(96, 'marketReviews.update', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(97, 'marketReviews.destroy', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(98, 'favorites.index', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(99, 'favorites.create', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(100, 'favorites.store', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(101, 'favorites.edit', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(102, 'favorites.update', 'web', '2020-03-29 09:28:12', '2020-03-29 09:28:12', NULL),
(103, 'favorites.destroy', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(104, 'orders.index', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(105, 'orders.create', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(106, 'orders.store', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(107, 'orders.show', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(108, 'orders.edit', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(109, 'orders.update', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(110, 'orders.destroy', 'web', '2020-03-29 09:28:13', '2020-03-29 09:28:13', NULL),
(111, 'notifications.index', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(112, 'notifications.show', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(113, 'notifications.destroy', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(114, 'carts.index', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(115, 'carts.edit', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(116, 'carts.update', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(117, 'carts.destroy', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(118, 'currencies.index', 'web', '2020-03-29 09:28:14', '2020-03-29 09:28:14', NULL),
(119, 'currencies.create', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(120, 'currencies.store', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(121, 'currencies.edit', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(122, 'currencies.update', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(123, 'currencies.destroy', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(124, 'deliveryAddresses.index', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(125, 'deliveryAddresses.create', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(126, 'deliveryAddresses.store', 'web', '2020-03-29 09:28:15', '2020-03-29 09:28:15', NULL),
(127, 'deliveryAddresses.edit', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(128, 'deliveryAddresses.update', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(129, 'deliveryAddresses.destroy', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(130, 'drivers.index', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(131, 'drivers.create', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(132, 'drivers.store', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(133, 'drivers.show', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(134, 'drivers.edit', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(135, 'drivers.update', 'web', '2020-03-29 09:28:16', '2020-03-29 09:28:16', NULL),
(136, 'drivers.destroy', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(137, 'earnings.index', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(138, 'earnings.create', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(139, 'earnings.store', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(140, 'earnings.show', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(141, 'earnings.edit', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(142, 'earnings.update', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(143, 'earnings.destroy', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(144, 'driversPayouts.index', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(145, 'driversPayouts.create', 'web', '2020-03-29 09:28:17', '2020-03-29 09:28:17', NULL),
(146, 'driversPayouts.store', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(147, 'driversPayouts.show', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(148, 'driversPayouts.edit', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(149, 'driversPayouts.update', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(150, 'driversPayouts.destroy', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(151, 'marketsPayouts.index', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(152, 'marketsPayouts.create', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(153, 'marketsPayouts.store', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(154, 'marketsPayouts.show', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(155, 'marketsPayouts.edit', 'web', '2020-03-29 09:28:18', '2020-03-29 09:28:18', NULL),
(156, 'marketsPayouts.update', 'web', '2020-03-29 09:28:19', '2020-03-29 09:28:19', NULL),
(157, 'marketsPayouts.destroy', 'web', '2020-03-29 09:28:19', '2020-03-29 09:28:19', NULL),
(158, 'permissions.create', 'web', '2020-03-29 09:29:15', '2020-03-29 09:29:15', NULL),
(159, 'permissions.store', 'web', '2020-03-29 09:29:15', '2020-03-29 09:29:15', NULL),
(160, 'permissions.show', 'web', '2020-03-29 09:29:15', '2020-03-29 09:29:15', NULL),
(161, 'roles.create', 'web', '2020-03-29 09:29:15', '2020-03-29 09:29:15', NULL),
(162, 'roles.store', 'web', '2020-03-29 09:29:15', '2020-03-29 09:29:15', NULL),
(163, 'roles.show', 'web', '2020-03-29 09:29:16', '2020-03-29 09:29:16', NULL),
(164, 'fields.index', 'web', '2020-04-11 09:34:39', '2020-04-11 09:34:39', NULL),
(165, 'fields.create', 'web', '2020-04-11 09:34:39', '2020-04-11 09:34:39', NULL),
(166, 'fields.store', 'web', '2020-04-11 09:34:39', '2020-04-11 09:34:39', NULL),
(167, 'fields.edit', 'web', '2020-04-11 09:34:39', '2020-04-11 09:34:39', NULL),
(168, 'fields.update', 'web', '2020-04-11 09:34:39', '2020-04-11 09:34:39', NULL),
(169, 'fields.destroy', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(170, 'optionGroups.index', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(171, 'optionGroups.create', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(172, 'optionGroups.store', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(173, 'optionGroups.edit', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(174, 'optionGroups.update', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(175, 'optionGroups.destroy', 'web', '2020-04-11 09:34:40', '2020-04-11 09:34:40', NULL),
(176, 'requestedMarkets.index', 'web', '2020-08-13 09:28:02', '2020-08-13 09:28:02', NULL),
(183, 'coupons.index', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(184, 'coupons.create', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(185, 'coupons.store', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(186, 'coupons.edit', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(187, 'coupons.update', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(188, 'coupons.destroy', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(189, 'slides.index', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(190, 'slides.create', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(191, 'slides.store', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(192, 'slides.edit', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(193, 'slides.update', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL),
(194, 'slides.destroy', 'web', '2020-08-23 09:28:02', '2020-08-23 09:28:02', NULL);

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

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

CREATE TABLE `products` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `discount_price` double(8,2) DEFAULT '0.00',
  `description` text COLLATE utf8mb4_unicode_ci,
  `capacity` double(9,2) DEFAULT '0.00',
  `package_items_count` double(9,2) DEFAULT '0.00',
  `unit` varchar(127) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `featured` tinyint(1) DEFAULT '0',
  `deliverable` tinyint(1) DEFAULT '1',
  `market_id` int(10) UNSIGNED NOT NULL,
  `category_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 `products`
--

INSERT INTO `products` (`id`, `name`, `price`, `discount_price`, `description`, `capacity`, `package_items_count`, `unit`, `featured`, `deliverable`, `market_id`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'Eggs', 15.33, 6.53, 'Maxime rem et dicta. Inventore libero vel enim aliquid. Repellendus eius autem suscipit aut culpa cum. Qui aperiam sit non est perferendis.', 18.13, 3.00, 'm', 0, 0, 9, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(2, 'Onion', 28.77, 0.00, 'Quos blanditiis ut autem autem debitis. Sint nisi quisquam quidem sed enim dicta. Assumenda eos adipisci in. Nobis delectus consequatur omnis a nam assumenda.', 316.63, 2.00, 'Kg', 1, 0, 10, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(3, 'Rice', 43.89, 35.22, 'Animi error enim tempora vel ut eum id. Fugit voluptatum ipsam sed modi libero veniam ut. Natus enim eum ipsam nam alias perspiciatis. Quae est deserunt perspiciatis.', 159.73, 6.00, 'm', 1, 0, 5, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(4, 'Salt', 14.65, 6.30, 'Est sequi laborum excepturi ex quasi quam quasi. Nihil ut nobis facilis ipsum. Nostrum aut sed cumque est dolorum quia laborum. Qui labore vel nihil magni occaecati tenetur quo.', 342.89, 6.00, 'Kg', 1, 1, 2, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(5, 'Sugar', 40.54, 30.87, 'Quibusdam et possimus porro qui voluptatem. Sit fugit occaecati vitae corrupti nostrum mollitia. Repellat architecto ullam hic voluptatum hic ex quis. Aut quia in eius quam.', 98.78, 4.00, 'g', 0, 1, 1, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(6, 'Eggs', 28.38, 0.00, 'Rem saepe similique vero mollitia maiores. Magni veritatis odio repudiandae necessitatibus in amet qui. Corporis id quibusdam dolor velit. Asperiores quia voluptatem velit quas beatae recusandae.', 486.56, 2.00, 'm', 1, 0, 10, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(7, 'Cheese', 44.67, 0.00, 'Praesentium in laborum ipsam commodi quidem veniam ex ut. Omnis iusto ullam fuga quae velit qui cupiditate.', 340.84, 2.00, 'L', 1, 1, 4, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(8, 'Eggs', 34.06, 28.81, 'Officia a ab qui. Asperiores sed laborum nulla explicabo. Iure occaecati est fugit incidunt id laborum iure aliquid. Quas quo ipsam beatae aliquam.', 256.10, 4.00, 'Kg', 0, 0, 8, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(9, 'Aspirin', 17.69, 15.08, 'Est error quae enim velit dolorem. Aliquid quas illo voluptatibus consequatur sunt. Suscipit et quia debitis saepe sint hic.', 108.36, 6.00, 'm', 1, 1, 1, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(10, 'Onion', 41.25, 0.00, 'Expedita qui ipsam expedita voluptas perspiciatis. Non libero suscipit quo molestiae. Enim enim ut suscipit consequatur.', 107.64, 2.00, 'Kg', 0, 0, 4, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(11, 'Rice', 38.95, 0.00, 'Ea rem culpa nemo doloremque recusandae. Eos asperiores quam incidunt asperiores et temporibus consequuntur. Unde et et voluptatem id non expedita nesciunt. Neque est et dolor.', 462.27, 1.00, 'Kg', 0, 0, 9, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(12, 'Milk', 45.99, 40.11, 'Aut necessitatibus repellendus et ullam aut natus. Qui assumenda aspernatur aliquid dolorem. Repudiandae dicta autem eaque qui hic.', 190.60, 2.00, 'm', 0, 1, 7, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(13, 'Salad', 20.98, 0.00, 'Fuga ullam debitis aut voluptatem officiis soluta. Omnis possimus impedit ex quos asperiores. Et voluptas ut a enim sint.', 175.53, 4.00, 'm²', 1, 0, 10, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(14, 'Tuna steak', 29.23, 0.00, 'Incidunt nobis dolor quos maiores molestias ut nihil. Aut quam minus asperiores nobis harum earum. Necessitatibus architecto et repellat consequatur. Iure quo dolores voluptatem voluptatum.', 177.72, 3.00, 'm', 0, 0, 9, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(15, 'Cookie', 20.32, 15.60, 'Autem aut sit laudantium aut. Officia pariatur aut saepe aut esse.', 490.94, 6.00, 'L', 1, 1, 3, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(16, 'Cookie', 42.45, 0.00, 'Sed enim aut aut ut consectetur qui explicabo. Illum repudiandae voluptates quisquam. Reprehenderit eos laborum quasi.', 309.69, 6.00, 'g', 0, 0, 10, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(17, 'Salt', 44.00, 36.35, 'Ut doloremque ea omnis porro ut qui. Quas omnis rerum corporis minima. Optio fugiat minus et qui.', 257.82, 6.00, 'ml', 1, 0, 10, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(18, 'Rice', 21.99, 16.67, 'Voluptas quia quos animi similique. Soluta porro illum fugiat. Dolor odio nostrum voluptas ducimus ea autem. Ab non aut assumenda.', 362.10, 5.00, 'g', 1, 0, 7, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(19, 'Tuna steak', 13.75, 10.72, 'Officia aut placeat tempore excepturi. Adipisci vitae qui totam voluptatem. Ut possimus ipsum enim sint illum.', 119.44, 1.00, 'Kg', 0, 1, 3, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(20, 'Sugar', 30.33, 0.00, 'Iure quidem architecto iusto laborum aut nihil accusantium odio. Suscipit est atque consequatur laudantium aut officiis totam sapiente. Dolorem ut earum impedit voluptatem.', 21.12, 2.00, 'ml', 1, 1, 8, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(21, 'Acarbose', 26.40, 0.00, 'Consectetur dolores cupiditate ut eos et nulla. Nisi quos ipsum aliquam omnis ut. Enim dolor esse minima dolorum sequi a tenetur. Iusto excepturi eveniet ad in adipisci fuga esse sint.', 233.71, 6.00, 'm', 0, 1, 3, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(22, 'Eggs', 25.95, 16.82, 'Nesciunt atque aliquid sed eum. Magni nobis nihil eaque sunt. Mollitia eum at harum non eius perferendis eos. Expedita illo blanditiis et repellat aut.', 76.78, 1.00, 'L', 0, 0, 8, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(23, 'Onion', 38.18, 30.68, 'Ut et vel in sit. Aut consequuntur cum officia tempore nemo optio. Consequatur omnis et ea odit ea porro voluptas.', 200.27, 4.00, 'ml', 0, 0, 8, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(24, 'Salad', 39.10, 34.60, 'Sunt asperiores deserunt rerum eveniet nihil ut delectus. Nihil eum eum sunt natus quis consectetur sed. Voluptas quo voluptatem perspiciatis veritatis culpa in omnis.', 43.85, 4.00, 'Kg', 1, 0, 7, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(25, 'Cookie', 40.63, 36.30, 'Hic est laudantium porro. Expedita autem officiis exercitationem iusto porro et. Ut qui ut cum.', 362.00, 2.00, 'm²', 0, 0, 7, 6, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(26, 'Tuna steak', 29.47, 0.00, 'Non fugiat quae necessitatibus rerum saepe qui est. Vel et quis impedit sequi excepturi magni cum. Qui consequatur architecto quae ad et.', 125.79, 5.00, 'm²', 0, 0, 1, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(27, 'Honey', 28.19, 0.00, 'In debitis et vitae laborum ea. Et est tempore velit a deleniti. Dignissimos vitae commodi ipsa temporibus nemo quo dolorem. Voluptatem minus est facilis totam molestiae.', 218.55, 6.00, 'm', 0, 0, 3, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(28, 'Fish', 43.48, 0.00, 'Sed exercitationem modi veritatis dolores nobis aliquid. Ratione omnis nisi quos dolores natus. Ad molestiae explicabo consequatur vel quidem nesciunt officia.', 292.27, 1.00, 'ml', 0, 1, 1, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(29, 'Sugar', 42.33, 32.66, 'Et modi qui cum non accusamus sit alias. Iure dolorum enim velit eaque omnis. Est sint ea occaecati molestias sapiente voluptatem.', 75.05, 3.00, 'L', 0, 0, 2, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(30, 'Steak', 25.30, 24.22, 'Et temporibus occaecati et magni dolorem. Doloribus voluptatem quae deserunt optio qui. Consequatur dicta voluptatum deserunt aut id. Vitae dolor sunt ut eos fugiat.', 443.63, 5.00, 'L', 1, 1, 5, 5, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(31, 'Steak', 35.37, 30.15, 'Repellendus consequatur blanditiis ex optio facilis saepe. Dolore expedita a distinctio ut. Excepturi in eius voluptatem aspernatur saepe.', 164.77, 2.00, 'L', 1, 1, 1, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(32, 'Fish', 11.84, 0.00, 'Quibusdam quia optio sit perspiciatis. Repudiandae quisquam necessitatibus possimus consequuntur tempora nemo. Eaque sint aspernatur rem accusantium quia.', 259.47, 6.00, 'Kg', 0, 1, 3, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(33, 'Milk', 20.60, 11.61, 'Delectus eum ut maiores voluptas illum ducimus sint. Ad officia tenetur et quos et et sed. Rerum laborum natus doloremque. Laboriosam cumque soluta et doloribus rem ea in.', 367.95, 5.00, 'm²', 0, 0, 7, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(34, 'Onion', 29.12, 0.00, 'Fugit rem sapiente quidem doloremque reprehenderit ratione maiores. Facere voluptatem dolorum magnam non modi itaque. Adipisci et cumque officia id perspiciatis laborum qui. Aut aut vero harum et.', 489.90, 2.00, 'm', 1, 0, 7, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(35, 'Onion', 25.92, 0.00, 'Cumque quasi ab consequatur consequuntur ipsa. Earum voluptatem deserunt amet ut numquam. Ipsa dolore occaecati tempora deserunt nam. Quisquam quos ut eius placeat consequatur.', 273.12, 4.00, 'g', 0, 0, 3, 1, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(36, 'Soup', 15.90, 10.27, 'Nulla alias cumque numquam saepe sed. Nostrum enim enim voluptatem aut porro error et. Voluptatem ad maxime doloremque nihil vitae possimus. Quisquam sunt quidem ducimus id natus iste et.', 215.36, 5.00, 'g', 0, 1, 10, 3, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(37, 'Spaghetti', 37.20, 28.02, 'Error nihil ut nulla eveniet. Eum sed numquam aspernatur non aliquam. Dicta corrupti est enim ipsum.', 196.07, 1.00, 'Kg', 1, 1, 8, 4, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(38, 'Cookie', 27.54, 19.28, 'Deleniti aliquid tempore nihil dolores. Est pariatur cumque sint aut voluptates. Et id quae porro sit. Tempore magni sit nesciunt nulla neque dolor ipsa ad.', 246.57, 5.00, 'Oz', 1, 0, 10, 5, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(39, 'Soup', 34.10, 0.00, 'Occaecati nihil est ut voluptate. Voluptatibus quod et modi quisquam ab. Expedita maiores non eius et voluptas rerum.', 278.82, 6.00, 'g', 1, 0, 6, 5, '2020-11-04 04:34:58', '2020-11-04 04:34:58'),
(40, 'Cupcake', 40.59, 33.51, 'Alias fugit dolor fugit quia laudantium. Ex et vero ut et rem eligendi sunt. Sit rerum et qui soluta. Fuga consequuntur exercitationem sed ea.', 402.88, 5.00, 'ml', 0, 0, 8, 2, '2020-11-04 04:34:58', '2020-11-04 04:34:58');

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

--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `quantity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `product_id` int(10) UNSIGNED NOT NULL,
  `order_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;

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

--
-- Table structure for table `product_order_options`
--

CREATE TABLE `product_order_options` (
  `product_order_id` int(10) UNSIGNED NOT NULL,
  `option_id` int(10) UNSIGNED NOT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` int(10) UNSIGNED NOT NULL,
  `review` text COLLATE utf8mb4_unicode_ci,
  `rate` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL,
  `product_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 `product_reviews`
--

INSERT INTO `product_reviews` (`id`, `review`, `rate`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 'This of course, Alice could see, when she heard a voice she had plenty of time as she left her, leaning her head through the doorway; \'and even if I chose,\' the Duchess replied, in a large canvas.', 2, 6, 1, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(2, 'Mouse was swimming away from her as she did not get dry again: they had settled down in a hurry. \'No, I\'ll look first,\' she said, \'and see whether it\'s marked \"poison\" or not\'; for she felt that it.', 2, 1, 15, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(3, 'I sleep\" is the same thing as \"I eat what I like\"!\' \'You might just as well. The twelve jurors were all in bed!\' On various pretexts they all crowded round it, panting, and asking, \'But who has.', 2, 5, 25, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(4, 'Wonderland, though she looked back once or twice, and shook itself. Then it got down off the top of her age knew the meaning of half an hour or so there were no arches left, and all must have been.', 3, 3, 9, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(5, 'Gryphon, \'that they WOULD not remember the simple and loving heart of her voice. Nobody moved. \'Who cares for you?\' said Alice, a little sharp bark just over her head pressing against the ceiling.', 3, 5, 22, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(6, 'Alice started to her daughter \'Ah, my dear! I shall remember it in with a teacup in one hand and a long time with great curiosity. \'Soles and eels, of course,\' said the Mock Turtle Soup is made.', 3, 3, 5, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(7, 'So she began nibbling at the Queen, but she felt unhappy. \'It was much pleasanter at home,\' thought poor Alice, \'it would have done that, you know,\' said the Dodo suddenly called out \'The Queen! The.', 2, 2, 1, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(8, 'The rabbit-hole went straight on like a steam-engine when she caught it, and kept doubling itself up very sulkily and crossed over to the Knave was standing before them, in chains, with a soldier on.', 1, 2, 2, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(9, 'The Queen had never heard it muttering to itself \'Then I\'ll go round a deal faster than it does.\' \'Which would NOT be an advantage,\' said Alice, and she thought it must be the best cat in the.', 4, 3, 22, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(10, 'I wonder if I\'ve been changed several times since then.\' \'What do you want to go on with the grin, which remained some time without interrupting it. \'They were obliged to write with one of the.', 3, 5, 6, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(11, 'Quadrille is!\' \'No, indeed,\' said Alice. \'Nothing WHATEVER?\' persisted the King. The next witness would be four thousand miles down, I think--\' (she was obliged to write this down on their slates.', 2, 2, 29, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(12, 'Fish-Footman was gone, and, by the Queen had only one way of nursing it, (which was to twist it up into a graceful zigzag, and was going to be, from one minute to another! However, I\'ve got to go.', 4, 6, 25, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(13, 'March Hare: she thought at first she would catch a bad cold if she meant to take MORE than nothing.\' \'Nobody asked YOUR opinion,\' said Alice. \'Why, there they lay sprawling about, reminding her very.', 1, 6, 4, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(14, 'I\'m better now--but I\'m a hatter.\' Here the Dormouse fell asleep instantly, and Alice was not a VERY unpleasant state of mind, she turned to the Queen. An invitation from the change: and Alice.', 3, 5, 24, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(15, 'MUST be more to come, so she felt that this could not be denied, so she went back to yesterday, because I was sent for.\' \'You ought to be a book written about me, that there was a child,\' said the.', 4, 6, 23, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(16, 'Alice did not like the tone of great relief. \'Now at OURS they had to double themselves up and straightening itself out again, and all dripping wet, cross, and uncomfortable. The moment Alice felt.', 4, 5, 19, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(17, 'So she began nibbling at the White Rabbit: it was the first figure!\' said the Mock Turtle went on. Her listeners were perfectly quiet till she had not gone much farther before she had put the.', 5, 1, 22, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(18, 'Knave of Hearts, he stole those tarts, And took them quite away!\' \'Consider your verdict,\' the King hastily said, and went down to look about her other little children, and everybody else. \'Leave.', 2, 1, 15, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(19, 'There ought to be no chance of this, so that they had a large arm-chair at one and then another confusion of voices--\'Hold up his head--Brandy now--Don\'t choke him--How was it, old fellow? What.', 3, 4, 13, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(20, 'But she waited for some time busily writing in his throat,\' said the King. \'When did you begin?\' The Hatter was the same thing as \"I eat what I say--that\'s the same thing a bit!\' said the Cat. \'I\'d.', 3, 6, 28, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(21, 'YOUR adventures.\' \'I could tell you his history,\' As they walked off together, Alice heard the Queen of Hearts were seated on their slates, and she heard a voice sometimes choked with sobs, to sing.', 4, 6, 7, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(22, 'Alice\'s elbow was pressed so closely against her foot, that there ought! And when I got up in such a capital one for catching mice--oh, I beg your pardon,\' said Alice as he spoke, and added with a.', 3, 5, 7, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(23, 'Mock Turtle replied in an offended tone. And the moral of that dark hall, and close to her that she began nursing her child again, singing a sort of knot, and then unrolled the parchment scroll, and.', 4, 3, 3, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(24, 'Alice; \'I can\'t help it,\' said the Queen, and Alice joined the procession, wondering very much pleased at having found out a race-course, in a pleased tone. \'Pray don\'t trouble yourself to say to.', 2, 1, 22, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(25, 'THEN--she found herself lying on the whole cause, and condemn you to leave off being arches to do next, when suddenly a White Rabbit put on one knee as he spoke, and then dipped suddenly down, so.', 1, 4, 8, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(26, 'Hatter. \'It isn\'t directed at all,\' said Alice: \'besides, that\'s not a regular rule: you invented it just now.\' \'It\'s the oldest rule in the last concert!\' on which the words don\'t FIT you,\' said.', 4, 2, 20, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(27, 'Mock Turtle yet?\' \'No,\' said Alice. \'Then it doesn\'t matter much,\' thought Alice, and tried to open it; but, as the March Hare. The Hatter was the White Rabbit, jumping up in a fight with another.', 2, 1, 30, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(28, 'Mock Turtle repeated thoughtfully. \'I should think you might catch a bad cold if she were looking up into the jury-box, or they would go, and making quite a large pool all round her, calling out in.', 5, 1, 23, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(29, 'Pigeon; \'but I haven\'t had a consultation about this, and Alice looked up, and there was room for her. \'Yes!\' shouted Alice. \'Come on, then,\' said Alice, \'but I must go by the officers of the.', 2, 5, 29, '2020-11-04 04:34:59', '2020-11-04 04:34:59'),
(30, 'Dinah, tell me the list of the earth. At last the Gryphon at the bottom of a well?\' \'Take some more bread-and-butter--\' \'But what did the archbishop find?\' The Mouse gave a little shriek, and went.', 3, 2, 19, '2020-11-04 04:34:59', '2020-11-04 04:34:59');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `default` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `default`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 'admin', 'web', 0, '2018-07-21 11:07:56', '2019-09-07 17:12:01', NULL),
(3, 'manager', 'web', 0, '2019-09-07 17:11:38', '2019-09-07 17:11:38', NULL),
(4, 'client', 'web', 1, '2019-09-07 17:11:54', '2019-09-07 17:11:54', NULL),
(5, 'driver', 'web', 0, '2019-12-15 13:20:21', '2019-12-15 13:20:21', NULL);

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 2),
(2, 2),
(3, 2),
(4, 2),
(5, 2),
(6, 2),
(9, 2),
(10, 2),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(26, 2),
(27, 2),
(28, 2),
(29, 2),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(39, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 2),
(46, 2),
(47, 2),
(48, 2),
(50, 2),
(51, 2),
(52, 2),
(53, 2),
(54, 2),
(55, 2),
(56, 2),
(57, 2),
(58, 2),
(59, 2),
(60, 2),
(61, 2),
(62, 2),
(63, 2),
(64, 2),
(67, 2),
(68, 2),
(69, 2),
(76, 2),
(77, 2),
(78, 2),
(80, 2),
(81, 2),
(82, 2),
(83, 2),
(85, 2),
(86, 2),
(87, 2),
(88, 2),
(89, 2),
(90, 2),
(91, 2),
(92, 2),
(95, 2),
(96, 2),
(97, 2),
(98, 2),
(103, 2),
(104, 2),
(107, 2),
(108, 2),
(109, 2),
(110, 2),
(111, 2),
(112, 2),
(113, 2),
(114, 2),
(117, 2),
(118, 2),
(119, 2),
(120, 2),
(121, 2),
(122, 2),
(123, 2),
(124, 2),
(127, 2),
(128, 2),
(129, 2),
(130, 2),
(131, 2),
(134, 2),
(135, 2),
(137, 2),
(138, 2),
(144, 2),
(145, 2),
(146, 2),
(148, 2),
(149, 2),
(151, 2),
(152, 2),
(153, 2),
(155, 2),
(156, 2),
(160, 2),
(164, 2),
(165, 2),
(166, 2),
(167, 2),
(168, 2),
(169, 2),
(170, 2),
(171, 2),
(172, 2),
(173, 2),
(174, 2),
(175, 2),
(176, 2),
(183, 2),
(184, 2),
(185, 2),
(186, 2),
(187, 2),
(188, 2),
(189, 2),
(190, 2),
(191, 2),
(192, 2),
(193, 2),
(194, 2),
(1, 3),
(3, 3),
(4, 3),
(5, 3),
(27, 3),
(30, 3),
(31, 3),
(32, 3),
(33, 3),
(34, 3),
(42, 3),
(48, 3),
(52, 3),
(53, 3),
(54, 3),
(55, 3),
(56, 3),
(57, 3),
(58, 3),
(59, 3),
(60, 3),
(61, 3),
(62, 3),
(63, 3),
(64, 3),
(67, 3),
(68, 3),
(76, 3),
(77, 3),
(78, 3),
(80, 3),
(81, 3),
(82, 3),
(83, 3),
(86, 3),
(92, 3),
(95, 3),
(96, 3),
(98, 3),
(103, 3),
(104, 3),
(107, 3),
(108, 3),
(109, 3),
(110, 3),
(111, 3),
(113, 3),
(114, 3),
(117, 3),
(130, 3),
(134, 3),
(135, 3),
(137, 3),
(145, 3),
(146, 3),
(151, 3),
(152, 3),
(153, 3),
(164, 3),
(170, 3),
(171, 3),
(172, 3),
(176, 3),
(183, 3),
(186, 3),
(187, 3),
(1, 4),
(3, 4),
(4, 4),
(27, 4),
(30, 4),
(31, 4),
(32, 4),
(52, 4),
(64, 4),
(67, 4),
(68, 4),
(83, 4),
(86, 4),
(92, 4),
(95, 4),
(96, 4),
(98, 4),
(103, 4),
(104, 4),
(107, 4),
(111, 4),
(113, 4),
(114, 4),
(117, 4),
(164, 4),
(176, 4),
(183, 4),
(1, 5),
(3, 5),
(4, 5),
(27, 5),
(30, 5),
(48, 5),
(52, 5),
(64, 5),
(67, 5),
(68, 5),
(83, 5),
(86, 5),
(92, 5),
(95, 5),
(96, 5),
(98, 5),
(103, 5),
(104, 5),
(107, 5),
(111, 5),
(113, 5),
(114, 5),
(117, 5),
(130, 5),
(144, 5),
(145, 5),
(146, 5),
(164, 5),
(176, 5),
(183, 5);

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

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED DEFAULT '0',
  `text` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text_position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'start',
  `text_color` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_color` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `indicator_color` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_fit` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'cover',
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `market_id` int(10) UNSIGNED DEFAULT NULL,
  `enabled` tinyint(1) 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 `slides`
--

INSERT INTO `slides` (`id`, `order`, `text`, `button`, `text_position`, `text_color`, `button_color`, `background_color`, `indicator_color`, `image_fit`, `product_id`, `market_id`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 3, 'Qui natus ut.', 'Order Now', 'end', '#25d366', '#25d366', '#ccccdd', '#25d366', 'cover', 5, NULL, 0, '2020-11-04 04:35:02', '2020-11-04 04:35:02'),
(2, 1, 'Aliquam vel voluptatem excepturi iusto aut.', 'Get Discount', 'center', '#25d366', '#25d366', '#ccccdd', '#25d366', 'cover', NULL, 1, 1, '2020-11-04 04:35:02', '2020-11-04 04:35:02'),
(3, 2, 'Temporibus sequi necessitatibus maxime fuga quam.', 'Order Now', 'end', '#25d366', '#25d366', '#ccccdd', '#25d366', 'cover', 9, NULL, 0, '2020-11-04 04:35:02', '2020-11-04 04:35:02'),
(4, 5, 'Totam error et cupiditate.', 'Get Discount', 'end', '#25d366', '#25d366', '#ccccdd', '#25d366', 'cover', NULL, 2, 0, '2020-11-04 04:35:02', '2020-11-04 04:35:02'),
(5, 0, 'Rerum est quidem.', 'Get Discount', 'start', '#25d366', '#25d366', '#ccccdd', '#25d366', 'cover', NULL, 3, 1, '2020-11-04 04:35:02', '2020-11-04 04:35:02');

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

--
-- Table structure for table `uploads`
--

CREATE TABLE `uploads` (
  `id` int(10) UNSIGNED NOT NULL,
  `uuid` 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;

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

--
-- Table structure for table `user_markets`
--

CREATE TABLE `user_markets` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `market_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_markets`
--

INSERT INTO `user_markets` (`user_id`, `market_id`) VALUES
(1, 2),
(1, 3),
(2, 3),
(2, 4),
(1, 5),
(1, 6);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_product_id_foreign` (`product_id`),
  ADD KEY `carts_user_id_foreign` (`user_id`);

--
-- Indexes for table `cart_options`
--
ALTER TABLE `cart_options`
  ADD PRIMARY KEY (`option_id`,`cart_id`),
  ADD KEY `cart_options_cart_id_foreign` (`cart_id`);

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

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`);

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

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

--
-- Indexes for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_field_values_custom_field_id_foreign` (`custom_field_id`);

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

--
-- Indexes for table `discountables`
--
ALTER TABLE `discountables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `discountables_coupon_id_foreign` (`coupon_id`);

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

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

--
-- Indexes for table `driver_markets`
--
ALTER TABLE `driver_markets`
  ADD PRIMARY KEY (`user_id`,`market_id`),
  ADD KEY `driver_markets_market_id_foreign` (`market_id`);

--
-- Indexes for table `earnings`
--
ALTER TABLE `earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `earnings_market_id_foreign` (`market_id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faqs_faq_category_id_foreign` (`faq_category_id`);

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

--
-- Indexes for table `favorites`
--
ALTER TABLE `favorites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `favorites_product_id_foreign` (`product_id`),
  ADD KEY `favorites_user_id_foreign` (`user_id`);

--
-- Indexes for table `favorite_options`
--
ALTER TABLE `favorite_options`
  ADD PRIMARY KEY (`option_id`,`favorite_id`),
  ADD KEY `favorite_options_favorite_id_foreign` (`favorite_id`);

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

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `galleries_market_id_foreign` (`market_id`);

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

--
-- Indexes for table `markets_payouts`
--
ALTER TABLE `markets_payouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `markets_payouts_market_id_foreign` (`market_id`);

--
-- Indexes for table `market_fields`
--
ALTER TABLE `market_fields`
  ADD PRIMARY KEY (`field_id`,`market_id`),
  ADD KEY `market_fields_market_id_foreign` (`market_id`);

--
-- Indexes for table `market_reviews`
--
ALTER TABLE `market_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `market_reviews_user_id_foreign` (`user_id`),
  ADD KEY `market_reviews_market_id_foreign` (`market_id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`);

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `options_product_id_foreign` (`product_id`),
  ADD KEY `options_option_group_id_foreign` (`option_group_id`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_order_status_id_foreign` (`order_status_id`),
  ADD KEY `orders_driver_id_foreign` (`driver_id`),
  ADD KEY `orders_delivery_address_id_foreign` (`delivery_address_id`),
  ADD KEY `orders_payment_id_foreign` (`payment_id`);

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_market_id_foreign` (`market_id`),
  ADD KEY `products_category_id_foreign` (`category_id`);

--
-- Indexes for table `product_orders`
--
ALTER TABLE `product_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_orders_product_id_foreign` (`product_id`),
  ADD KEY `product_orders_order_id_foreign` (`order_id`);

--
-- Indexes for table `product_order_options`
--
ALTER TABLE `product_order_options`
  ADD PRIMARY KEY (`product_order_id`,`option_id`),
  ADD KEY `product_order_options_option_id_foreign` (`option_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_reviews_user_id_foreign` (`user_id`),
  ADD KEY `product_reviews_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `slides`
--
ALTER TABLE `slides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slides_product_id_foreign` (`product_id`),
  ADD KEY `slides_market_id_foreign` (`market_id`);

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

--
-- Indexes for table `user_markets`
--
ALTER TABLE `user_markets`
  ADD PRIMARY KEY (`user_id`,`market_id`),
  ADD KEY `user_markets_market_id_foreign` (`market_id`);

--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `delivery_addresses`
--
ALTER TABLE `delivery_addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `discountables`
--
ALTER TABLE `discountables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drivers`
--
ALTER TABLE `drivers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drivers_payouts`
--
ALTER TABLE `drivers_payouts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `earnings`
--
ALTER TABLE `earnings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `faq_categories`
--
ALTER TABLE `faq_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `favorites`
--
ALTER TABLE `favorites`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `fields`
--
ALTER TABLE `fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `markets`
--
ALTER TABLE `markets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `markets_payouts`
--
ALTER TABLE `markets_payouts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_reviews`
--
ALTER TABLE `market_reviews`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `option_groups`
--
ALTER TABLE `option_groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_statuses`
--
ALTER TABLE `order_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `product_orders`
--
ALTER TABLE `product_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `slides`
--
ALTER TABLE `slides`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `uploads`
--
ALTER TABLE `uploads`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cart_options`
--
ALTER TABLE `cart_options`
  ADD CONSTRAINT `cart_options_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cart_options_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `options` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD CONSTRAINT `custom_field_values_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `delivery_addresses`
--
ALTER TABLE `delivery_addresses`
  ADD CONSTRAINT `delivery_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `discountables`
--
ALTER TABLE `discountables`
  ADD CONSTRAINT `discountables_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `drivers`
--
ALTER TABLE `drivers`
  ADD CONSTRAINT `drivers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `drivers_payouts`
--
ALTER TABLE `drivers_payouts`
  ADD CONSTRAINT `drivers_payouts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `driver_markets`
--
ALTER TABLE `driver_markets`
  ADD CONSTRAINT `driver_markets_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `driver_markets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `earnings`
--
ALTER TABLE `earnings`
  ADD CONSTRAINT `earnings_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `faqs`
--
ALTER TABLE `faqs`
  ADD CONSTRAINT `faqs_faq_category_id_foreign` FOREIGN KEY (`faq_category_id`) REFERENCES `faq_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `favorites`
--
ALTER TABLE `favorites`
  ADD CONSTRAINT `favorites_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `favorite_options`
--
ALTER TABLE `favorite_options`
  ADD CONSTRAINT `favorite_options_favorite_id_foreign` FOREIGN KEY (`favorite_id`) REFERENCES `favorites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `favorite_options_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `options` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `galleries`
--
ALTER TABLE `galleries`
  ADD CONSTRAINT `galleries_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `markets_payouts`
--
ALTER TABLE `markets_payouts`
  ADD CONSTRAINT `markets_payouts_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `market_fields`
--
ALTER TABLE `market_fields`
  ADD CONSTRAINT `market_fields_field_id_foreign` FOREIGN KEY (`field_id`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `market_fields_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `market_reviews`
--
ALTER TABLE `market_reviews`
  ADD CONSTRAINT `market_reviews_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `market_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `options`
--
ALTER TABLE `options`
  ADD CONSTRAINT `options_option_group_id_foreign` FOREIGN KEY (`option_group_id`) REFERENCES `option_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `options_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_delivery_address_id_foreign` FOREIGN KEY (`delivery_address_id`) REFERENCES `delivery_addresses` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `orders_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `orders_order_status_id_foreign` FOREIGN KEY (`order_status_id`) REFERENCES `order_statuses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orders_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_orders`
--
ALTER TABLE `product_orders`
  ADD CONSTRAINT `product_orders_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `product_orders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_order_options`
--
ALTER TABLE `product_order_options`
  ADD CONSTRAINT `product_order_options_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `options` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `product_order_options_product_order_id_foreign` FOREIGN KEY (`product_order_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD CONSTRAINT `product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `product_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `slides`
--
ALTER TABLE `slides`
  ADD CONSTRAINT `slides_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `slides_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `user_markets`
--
ALTER TABLE `user_markets`
  ADD CONSTRAINT `user_markets_market_id_foreign` FOREIGN KEY (`market_id`) REFERENCES `markets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_markets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
