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

START TRANSACTION;



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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `storeowner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `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;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text DEFAULT NULL,
  `fixed_charges` double DEFAULT 0,
  `cancel_charges` double DEFAULT 0,
  `min_distance` double DEFAULT 0,
  `min_weight` double DEFAULT 0,
  `per_distance_charges` double DEFAULT 0,
  `per_weight_charges` double DEFAULT 0,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `commission_type` varchar(255) DEFAULT NULL COMMENT 'fixed, percentage',
  `admin_commission` double DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `country_id`, `address`, `fixed_charges`, `cancel_charges`, `min_distance`, `min_weight`, `per_distance_charges`, `per_weight_charges`, `status`, `created_at`, `updated_at`, `deleted_at`, `commission_type`, `admin_commission`) VALUES
(1, 'Mumbai', 1, NULL, 1000, 1000, 1000, 1, 1, 1, 1, '2024-08-01 03:27:29', '2024-08-01 03:27:29', NULL, 'fixed', 1),
(2, 'New York', 2, NULL, 1000, 1000, 1000, 1, 1, 1, 1, '2024-08-01 07:10:55', '2024-08-01 07:10:55', NULL, 'fixed', 1000),
(3, 'Fredericka Galloway', 3, NULL, 0, 36, 83, 57, 31, 95, 1, '2024-08-01 09:01:18', '2024-08-01 09:01:18', NULL, 'percentage', 81),
(4, 'Cynthia Blanchard', 5, NULL, 77, 4, 99, 2, 64, 2, 1, '2024-08-01 09:01:32', '2024-08-01 09:01:32', NULL, 'percentage', 18),
(5, 'Quamar Young', 2, NULL, 63, 79, 45, 36, 3, 82, 1, '2024-08-01 09:01:44', '2024-08-01 09:01:44', NULL, 'fixed', 77),
(6, 'Noelani Tanner', 2, NULL, 14, 41, 31, 64, 35, 3, 1, '2024-08-01 09:02:03', '2024-08-01 09:02:03', NULL, 'fixed', 40),
(7, 'Anika Moon', 2, NULL, 24, 38, 91, 15, 10, 94, 1, '2024-08-01 09:02:13', '2024-08-01 09:02:26', NULL, 'fixed', 63),
(8, 'Wanda Green', 2, NULL, 18, 77, 98, 74, 74, 24, 1, '2024-08-01 09:02:23', '2024-08-01 09:02:23', NULL, 'fixed', 53),
(9, 'Lucas Jensen', 1, NULL, 96, 88, 2, 95, 42, 89, 1, '2024-08-01 09:02:38', '2024-08-01 09:02:38', NULL, 'percentage', 48),
(10, 'Kuame Aguirre', 1, NULL, 55, 1, 89, 93, 100, 38, 1, '2024-08-01 09:02:54', '2024-08-01 09:02:54', NULL, 'percentage', 6),
(11, 'Declan Russo', 1, NULL, 65, 97, 35, 59, 55, 84, 1, '2024-08-01 09:03:06', '2024-08-01 09:03:06', NULL, 'fixed', 50),
(12, 'Kyra Cruz', 1, NULL, 60, 24, 92, 68, 22, 19, 1, '2024-08-01 09:03:20', '2024-08-01 09:03:20', NULL, 'fixed', 42),
(13, 'Gloria Atkinson', 3, NULL, 75, 23, 62, 34, 81, 75, 1, '2024-08-01 09:03:37', '2024-08-01 09:03:37', NULL, 'fixed', 0),
(14, 'Simon Cooper', 3, NULL, 69, 84, 33, 83, 29, 26, 1, '2024-08-01 09:03:53', '2024-08-01 09:03:56', NULL, 'percentage', 31),
(15, 'Hakeem Bennett', 4, NULL, 73, 57, 10, 36, 39, 90, 1, '2024-08-01 09:04:16', '2024-08-01 09:04:21', NULL, 'percentage', 27),
(16, 'Molly Payne', 5, NULL, 88, 50, 82, 78, 23, 79, 1, '2024-08-01 09:04:43', '2024-08-01 09:04:43', NULL, 'fixed', 18),
(17, 'Gray Nash', 6, NULL, 10, 94, 68, 99, 93, 69, 1, '2024-08-01 09:04:56', '2024-08-01 09:04:56', NULL, 'percentage', 25);

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `distance_type` varchar(255) DEFAULT NULL,
  `weight_type` varchar(255) DEFAULT NULL,
  `links` longtext DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `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 `countries`
--

INSERT INTO `countries` (`id`, `name`, `code`, `distance_type`, `weight_type`, `links`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'India', 'IN', 'km', 'kg', NULL, 1, '2024-08-01 02:36:10', '2024-08-01 02:36:10', NULL),
(2, 'United States of America', 'US', 'km', 'kg', NULL, 1, '2024-08-01 02:36:43', '2024-08-01 02:36:43', NULL),
(3, 'Russia', 'RU', 'km', 'kg', NULL, 1, '2024-08-01 02:37:01', '2024-08-01 08:12:34', NULL),
(4, 'Afghanistan', 'AF', 'miles', 'pound', NULL, 1, '2024-08-01 09:00:09', '2024-08-01 09:00:09', NULL),
(5, 'Andorra', 'AD', 'km', 'kg', NULL, 1, '2024-08-01 09:00:24', '2024-08-01 09:00:24', NULL),
(6, 'American Samoa', 'AS', 'miles', 'kg', NULL, 1, '2024-08-01 09:00:36', '2024-08-01 09:00:36', NULL),
(7, 'Anguilla', 'AI', 'km', 'pound', NULL, 1, '2024-08-01 09:00:47', '2024-08-01 09:00:47', NULL);

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

--
-- Table structure for table `default_keywords`
--

CREATE TABLE `default_keywords` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `screen_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'screens screenID',
  `keyword_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'app keyword',
  `keyword_name` varchar(255) DEFAULT NULL,
  `keyword_value` varchar(255) 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 `delivery_man_documents`
--

CREATE TABLE `delivery_man_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `document_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_verified` tinyint(4) DEFAULT 2,
  `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;

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `is_required` tinyint(4) DEFAULT 0,
  `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;

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

--
-- Table structure for table `extra_charges`
--

CREATE TABLE `extra_charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `charges_type` varchar(255) NOT NULL COMMENT 'fixed, percentage',
  `charges` double DEFAULT 0,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0-inactive , 1 - active',
  `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 `extra_charges`
--

INSERT INTO `extra_charges` (`id`, `title`, `charges_type`, `charges`, `country_id`, `city_id`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Test Extra Charge', 'fixed', 1000, 2, 2, 1, '2024-08-01 07:11:25', '2024-08-01 08:37:06', NULL),
(2, 'Chaim Contreras', 'fixed', 64, 1, 1, 1, '2024-08-01 09:13:56', '2024-08-01 09:13:56', NULL),
(3, 'Marcia Bird', 'fixed', 20, 3, 3, 1, '2024-08-01 09:14:13', '2024-08-01 09:14:13', NULL),
(4, 'Ursa Willis', 'fixed', 33, 2, 2, 1, '2024-08-01 09:14:23', '2024-08-01 09:14:28', NULL),
(5, 'Hyacinth Solis', 'fixed', 22, 1, 10, 1, '2024-08-01 09:14:38', '2024-08-01 09:14:41', NULL),
(6, 'Ashton Mclaughlin', 'fixed', 12, 3, 3, 1, '2024-08-01 09:14:53', '2024-08-01 09:14:53', NULL),
(7, 'Kirby Hansen', 'percentage', 51, 5, 16, 1, '2024-08-01 09:15:03', '2024-08-01 09:15:03', NULL),
(8, 'Barry Rice', 'fixed', 45, 4, 15, 1, '2024-08-01 09:15:16', '2024-08-01 09:15:16', NULL),
(9, 'Winter Cleveland', 'percentage', 11, 6, 17, 1, '2024-08-01 09:15:28', '2024-08-01 09:15:30', NULL),
(10, 'Ahmed Daniels', 'fixed', 88, 6, 17, 1, '2024-08-01 09:15:41', '2024-08-01 09:15:41', NULL),
(11, 'Samuel Wolf', 'percentage', 49, 1, 12, 1, '2024-08-01 09:15:56', '2024-08-01 09:15:56', NULL),
(12, 'Imogene Mcguire', 'percentage', 6, 6, 17, 1, '2024-08-01 09:16:17', '2024-08-01 09:16:17', NULL),
(13, 'popu', 'percentage', 5, 4, 15, 1, '2024-08-14 07:55:54', '2024-08-14 07:55:54', NULL),
(14, 'raju', 'percentage', 15, 1, 1, 1, '2024-08-16 03:19:24', '2024-08-16 03:19:24', NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `frontend_data`
--

CREATE TABLE `frontend_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL COMMENT 'why_choose, partner_benefits, client_review',
  `description` longtext 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 `frontend_data`
--

INSERT INTO `frontend_data` (`id`, `title`, `subtitle`, `type`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Time-Saving', 'Ordering food through an app saves time, especially during busy workdays or when you do', 'why_choose', NULL, '2024-08-01 04:03:37', '2024-08-13 12:05:42'),
(2, 'Sachin', 'Sachin10@demo.com', 'client_review', '\"The interface is user-friendly, and I love the option to customize my orders. But However, the delivery charges can be a bit high at times.\"', '2024-08-01 04:10:02', '2024-08-14 04:15:44'),
(3, 'Shekhar', 'Shekhar@demo.com', 'client_review', '\"I had a great experience with the customer service, but the app could use some improvements in speed. Sometimes it lags while placing an order.\"', '2024-08-01 04:12:46', '2024-08-14 04:13:30'),
(4, 'Paru', 'Paru33@demo.com', 'client_review', 'I appreciate the frequent discounts and promotions, but the app crashes occasionally. It\'s a good service, just needs a bit more stability.\"', '2024-08-01 07:06:42', '2024-08-14 04:15:00'),
(5, 'Quality Assurance', 'The house has many fine qualities. His music has a primitive quality. They offer quality at a reason', 'why_choose', NULL, '2024-08-01 08:39:45', '2024-08-13 13:09:20'),
(6, 'Free delivery on First order', 'Get your order free and Amazing Offers', 'why_choose', NULL, '2024-08-01 08:53:38', '2024-08-14 02:56:14'),
(8, 'Benefits', 'of on time delivery', 'partner_benefits', NULL, '2024-08-01 09:28:30', '2024-08-01 09:28:30'),
(9, 'Benefits of On time delivery', 'Brings you more bonus', 'partner_benefits', NULL, '2024-08-01 09:28:33', '2024-08-01 09:35:49'),
(10, 'Cash on delivery', 'Card payments and Cash are Acceptable', 'partner_benefits', NULL, '2024-08-01 09:28:38', '2024-08-01 09:36:29'),
(11, 'Raju', 'Raj@demo.com', 'client_review', '\"The variety of restaurants available is fantastic, but I\'ve had a few issues with late deliveries. Overall, still a convenient app for quick meals.\"', '2024-08-14 03:17:37', '2024-08-14 03:17:37');

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

--
-- Table structure for table `language_default_lists`
--

CREATE TABLE `language_default_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `languageName` varchar(255) DEFAULT NULL,
  `languageCode` varchar(255) DEFAULT NULL,
  `countryCode` varchar(255) 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 `language_default_lists`
--

INSERT INTO `language_default_lists` (`id`, `languageName`, `languageCode`, `countryCode`, `created_at`, `updated_at`) VALUES
(1, 'Afrikaans (South Africa)', 'af', 'af-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(2, 'Albanian (Albania)', 'sq', 'sq-AL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(3, 'Alsatian (France)', 'gsw', 'gsw-FR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(4, 'Amharic (Ethiopia)', 'am', 'am-ET', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(5, 'Arabic (Algeria)', 'ar', 'ar-DZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(6, 'Arabic (Bahrain)', 'ar', 'ar-BH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(7, 'Arabic (Egypt)', 'ar', 'ar-EG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(8, 'Arabic (Iraq)', 'ar', 'ar-IQ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(9, 'Arabic (Jordan)', 'ar', 'ar-JO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(10, 'Arabic (Kuwait)', 'ar', 'ar-KW', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(11, 'Arabic (Lebanon)', 'ar', 'ar-LB', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(12, 'Arabic (Libya)', 'ar', 'ar-LY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(13, 'Arabic (Morocco)', 'ar', 'ar-MA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(14, 'Arabic (Oman)', 'ar', 'ar-OM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(15, 'Arabic (Qatar)', 'ar', 'ar-QA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(16, 'Arabic (Saudi Arabia)', 'ar', 'ar-SA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(17, 'Arabic (Syria)', 'ar', 'ar-SY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(18, 'Arabic (Tunisia)', 'ar', 'ar-TN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(19, 'Arabic (U.A.E.)', 'ar', 'ar-AE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(20, 'Arabic (Yemen)', 'ar', 'ar-YE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(21, 'Armenian (Armenia)', 'hy', 'hy-AM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(22, 'Assamese (India)', 'as', 'as-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(23, 'Azerbaijani (Cyrillic)', 'az', 'az-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(24, 'Azerbaijani (Cyrillic, Azerbaijan)', 'az', 'az-Cyrl-AZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(25, 'Azerbaijani (Latin)', 'az', 'az-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(26, 'Azerbaijani (Latin, Azerbaijan)', 'az', 'az-Latn-AZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(27, 'Bangla (Bangladesh)', 'bn', 'bn-BD', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(28, 'Bangla (India)', 'bn', 'bn-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(29, 'Bashkir (Russia)', 'ba', 'ba-RU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(30, 'Basque (Spain)', 'eu', 'eu-ES', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(31, 'Belarusian (Belarus)', 'be', 'be-BY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(32, 'Bosnian (Cyrillic)', 'bs', 'bs-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(33, 'Bosnian (Cyrillic, Bosnia and Herzegovina)', 'bs', 'bs-Cyrl-BA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(34, 'Bosnian (Latin)', 'bs', 'bs-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(35, 'Bosnian (Latin, Bosnia and Herzegovina)', 'bs', 'bs-Latn-BA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(36, 'Breton (France)', 'br', 'br-FR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(37, 'Bulgarian (Bulgaria)', 'bg', 'bg-BG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(38, 'Burmese (Myanmar)', 'my', 'my-MM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(39, 'Catalan (Spain)', 'ca', 'ca-ES', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(40, 'Central Atlas Tamazight (Arabic, Morocco)', 'tzm', 'tzm-Arab-MA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(41, 'Central Kurdish', 'ku', 'ku-Arab', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(42, 'Central Kurdish (Iraq)', 'ku', 'ku-Arab-IQ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(43, 'Cherokee', 'chr', 'chr-Cher', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(44, 'Cherokee (United States)', 'chr', 'chr-Cher-US', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(45, 'Chinese (Simplified) (zh-Hans)', 'zh', 'zh-Hans', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(46, 'Chinese (Simplified, People\'s Republic of China)', 'zh', 'zh-CN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(47, 'Chinese (Simplified, Singapore)', 'zh', 'zh-SG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(48, 'Chinese (Traditional) (zh-Hant)', 'zh', 'zh-Hant', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(49, 'Chinese (Traditional, Hong Kong S.A.R.)', 'zh', 'zh-HK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(50, 'Chinese (Traditional, Macao S.A.R.)', 'zh', 'zh-MO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(51, 'Chinese (Traditional, Taiwan)', 'zh', 'zh-TW', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(52, 'Corsican (France)', 'co', 'co-FR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(53, 'Croatian (Croatia)', 'hr', 'hr-HR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(54, 'Croatian (Latin, Bosnia and Herzegovina)', 'hr', 'hr-BA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(55, 'Czech (Czech Republic)', 'cs', 'cs-CZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(56, 'Danish (Denmark)', 'da', 'da-DK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(57, 'Dari (Afghanistan)', 'prs', 'prs-AF', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(58, 'Divehi (Maldives)', 'dv', 'dv-MV', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(59, 'Dutch (Belgium)', 'nl', 'nl-BE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(60, 'Dutch (Netherlands)', 'nl', 'nl-NL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(61, 'Dzongkha (Bhutan)', 'dz', 'dz-BT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(62, 'English (Australia)', 'en', 'en-AU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(63, 'English (Belize)', 'en', 'en-BZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(64, 'English (Canada)', 'en', 'en-CA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(65, 'English (Caribbean)', 'en', 'en-029', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(66, 'English (Hong Kong)', 'en', 'en-HK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(67, 'English (India)', 'en', 'en-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(68, 'English (Ireland)', 'en', 'en-IE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(69, 'English (Jamaica)', 'en', 'en-JM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(70, 'English (Malaysia)', 'en', 'en-MY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(71, 'English (New Zealand)', 'en', 'en-NZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(72, 'English (Republic of the Philippines)', 'en', 'en-PH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(73, 'English (Singapore)', 'en', 'en-SG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(74, 'English (South Africa)', 'en', 'en-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(75, 'English (Trinidad and Tobago)', 'en', 'en-TT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(76, 'English (United Arab Emirates)', 'en', 'en-AE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(77, 'English (United Kingdom)', 'en', 'en-GB', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(78, 'English (United States)', 'en', 'en-US', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(79, 'English (Zimbabwe)', 'en', 'en-ZW', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(80, 'Estonian (Estonia)', 'et', 'et-EE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(81, 'Faroese (Faroe Islands)', 'fo', 'fo-FO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(82, 'Filipino (Philippines)', 'fi', 'fil-PH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(83, 'Finnish (Finland)', 'fi', 'fi-FI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(84, 'French (Belgium)', 'fr', 'fr-BE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(85, 'French (Côte d’Ivoire)', 'fr', 'fr-CI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(86, 'French (Cameroon)', 'fr', 'fr-CM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(87, 'French (Canada)', 'fr', 'fr-CA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(88, 'French (Caribbean)', 'fr', 'fr-029', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(89, 'French (Congo, DRC)', 'fr', 'fr-CD', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(90, 'French (France)', 'fr', 'fr-FR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(91, 'French (Haiti)', 'fr', 'fr-HT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(92, 'French (Luxembourg)', 'fr', 'fr-LU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(93, 'French (Mali)', 'fr', 'fr-ML', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(94, 'French (Morocco)', 'fr', 'fr-MA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(95, 'French (Principality of Monaco)', 'fr', 'fr-MC', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(96, 'French (Réunion)', 'fr', 'fr-RE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(97, 'French (Senegal)', 'fr', 'fr-SN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(98, 'French (Switzerland)', 'fr', 'fr-CH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(99, 'Frisian (Netherlands)', 'fy', 'fy-NL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(100, 'Fulah (Latin)', 'ff', 'ff-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(101, 'Fulah (Latin, Nigeria)', 'ff', 'ff-Latn-NG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(102, 'Fulah (Latin, Senegal)', 'ff', 'ff-Latn-SN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(103, 'Galician (Spain)', 'gl', 'gl-ES', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(104, 'Georgian (Georgia)', 'ka', 'ka-GE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(105, 'German (Austria)', 'de', 'de-AT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(106, 'German (Germany)', 'de', 'de-DE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(107, 'German (Liechtenstein)', 'de', 'de-LI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(108, 'German (Luxembourg)', 'de', 'de-LU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(109, 'German (Switzerland)', 'de', 'de-CH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(110, 'Greek', 'el', 'el-GR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(111, 'Greenlandic (Greenland)', 'kl', 'kl-GL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(112, 'Guarani (Paraguay)', 'gn', 'gn-PY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(113, 'Gujarati', 'gu', 'gu-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(114, 'Hausa (Latin)', 'ha', 'ha-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(115, 'Hausa (Latin, Nigeria)', 'ha', 'ha-Latn-NG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(116, 'Hawaiian (United States)', 'haw', 'haw-US', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(117, 'Hebrew (Israel)', 'he', 'he-IL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(118, 'Hindi', 'hi', 'hi-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(119, 'Hungarian (Hungary)', 'hu', 'hu-HU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(120, 'Icelandic (Iceland)', 'is', 'is-IS', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(121, 'Igbo (Nigeria)', 'ig', 'ig-NG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(122, 'Indonesian (Indonesia)', 'id', 'id-ID', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(123, 'Inuktitut (Latin)', 'iu', 'iu-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(124, 'Inuktitut (Latin, Canada)', 'iu', 'iu-Latn-CA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(125, 'Inuktitut (Syllabics)', 'iu', 'iu-Cans', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(126, 'Inuktitut (Syllabics, Canada)', 'iu', 'iu-Cans-CA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(127, 'Irish (Ireland)', 'ga', 'ga-IE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(128, 'Italian (Italy)', 'it', 'it-IT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(129, 'Italian (Switzerland)', 'it', 'it-CH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(130, 'Japanese', 'ja', 'ja-JP', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(131, 'Kannada (India)', 'kn', 'kn-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(132, 'Kanuri (Latin, Nigeria)', 'kr', 'kr-Latn-NG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(133, 'Kashmiri (Devanagari, India)', 'ks', 'ks-Deva-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(134, 'Kashmiri (Perso-Arabic)', 'ks', 'ks-Arab', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(135, 'Kazakh (Kazakhstan)', 'kk', 'kk-KZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(136, 'Khmer (Cambodia)', 'km', 'km-KH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(137, 'K\'iche (Guatemala)', 'qut', 'qut-GT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(138, 'K\'iche (Latin, Guatemala)', 'quc', 'quc-Latn-GT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(139, 'Kinyarwanda (Rwanda)', 'rw', 'rw-RW', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(140, 'Kiswahili (Kenya)', 'sw', 'sw-KE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(141, 'Konkani (India)', 'kok', 'kok-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(142, 'Korean (Korea)', 'ko', 'ko-KR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(143, 'Kyrgyz (Kyrgyzstan)', 'ky', 'ky-KG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(144, 'Lao (Lao P.D.R.)', 'lo', 'lo-LA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(145, 'Latin (Vatican City)', 'la', 'la-VA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(146, 'Latvian (Latvia)', 'lv', 'lv-LV', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(147, 'Lithuanian (Lithuania)', 'lt', 'lt-LT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(148, 'Lower Sorbian (Germany)', 'dsb', 'dsb-DE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(149, 'Luxembourgish (Luxembourg)', 'lb', 'lb-LU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(150, 'Macedonian (North Macedonia)', 'mk', 'mk-MK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(151, 'Malay (Brunei Darussalam)', 'ms', 'ms-BN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(152, 'Malay (Malaysia)', 'ms', 'ms-MY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(153, 'Malayalam (India)', 'ml', 'ml-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(154, 'Maltese (Malta)', 'mt', 'mt-MT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(155, 'Maori (New Zealand)', 'mi', 'mi-NZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(156, 'Mapudungun (Chile)', 'arn', 'arn-CL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(157, 'Marathi (India)', 'mr', 'mr-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(158, 'Mohawk (Canada)', 'moh', 'moh-CA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(159, 'Mongolian (Cyrillic)', 'mn', 'mn-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(160, 'Mongolian (Cyrillic, Mongolia)', 'mn', 'mn-MN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(161, 'Mongolian (Traditional Mongolian)', 'mn', 'mn-Mong', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(162, 'Mongolian (Traditional Mongolian, Mongolia)', 'mn', 'mn-Mong-MN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(163, 'Mongolian (Traditional Mongolian, People\'s Republic of China)', 'mn', 'mn-Mong-CN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(164, 'Nepali (India)', 'ne', 'ne-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(165, 'Nepali (Nepal)', 'ne', 'ne-NP', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(166, 'Norwegian, Bokmål (Norway)', 'nb', 'nb-NO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(167, 'Norwegian, Nynorsk (Norway)', 'nn', 'nn-NO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(168, 'Occitan (France)', 'oc', 'oc-FR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(169, 'Odia (India)', 'or', 'or-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(170, 'Oromo (Ethiopia)', 'om', 'om-ET', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(171, 'Pashto (Afghanistan)', 'ps', 'ps-AF', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(172, 'Persian (Iran)', 'fa', 'fa-IR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(173, 'Polish (Poland)', 'pl', 'pl-PL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(174, 'Portuguese (Brazil)', 'pt', 'pt-BR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(175, 'Portuguese (Portugal)', 'pt', 'pt-PT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(176, 'Punjabi - Arab', 'pa', 'pa-Arab', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(177, 'Punjabi (India)', 'pa', 'pa-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(178, 'Punjabi (Islamic Republic of Pakistan)', 'pa', 'pa-Arab-PK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(179, 'Quechua (Bolivia)', 'quz', 'quz-BO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(180, 'Quechua (Ecuador)', 'quz', 'quz-EC', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(181, 'Quechua (Peru)', 'quz', 'quz-PE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(182, 'Romanian (Moldova)', 'ro', 'ro-MD', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(183, 'Romanian (Romania)', 'ro', 'ro-RO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(184, 'Romansh (Switzerland)', 'rm', 'rm-CH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(185, 'Russian (Moldova)', 'ru', 'ru-MD', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(186, 'Russian (Russia)', 'ru', 'ru-RU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(187, 'Sakha (Russia)', 'sah', 'sah-RU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(188, 'Sami, Inari (Finland)', 'smn', 'smn-FI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(189, 'Sami, Lule (Norway)', 'smj', 'smj-NO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(190, 'Sami, Lule (Sweden)', 'smj', 'smj-SE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(191, 'Sami, Northern (Finland)', 'se', 'se-FI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(192, 'Sami, Northern (Norway)', 'se', 'se-NO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(193, 'Sami, Northern (Sweden)', 'se', 'se-SE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(194, 'Sami, Skolt (Finland)', 'sm', 'sms-FI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(195, 'Sami, Southern (Norway)', 'sm', 'sma-NO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(196, 'Sami, Southern (Sweden)', 'sm', 'sma-SE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(197, 'Sanskrit (India)', 'sa', 'sa-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(198, 'Scottish Gaelic (United Kingdom)', 'gd', 'gd-GB', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(199, 'Serbian (Cyrillic)', 'sr', 'sr-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(200, 'Serbian (Cyrillic, Bosnia and Herzegovina)', 'sr', 'sr-Cyrl-BA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(201, 'Serbian (Cyrillic, Montenegro)', 'sr', 'sr-Cyrl-ME', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(202, 'Serbian (Cyrillic, Serbia and Montenegro (Former))', 'sr', 'sr-Cyrl-CS', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(203, 'Serbian (Cyrillic, Serbia)', 'sr', 'sr-Cyrl-RS', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(204, 'Serbian (Latin)', 'sr', 'sr-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(205, 'Serbian (Latin, Bosnia and Herzegovina)', 'sr', 'sr-Latn-BA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(206, 'Serbian (Latin, Montenegro)', 'sr', 'sr-Latn-ME', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(207, 'Serbian (Latin, Serbia and Montenegro (Former))', 'sr', 'sr-Latn-CS', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(208, 'Serbian (Latin, Serbia)', 'sr', 'sr-Latn-RS', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(209, 'Sesotho sa Leboa (South Africa)', 'nso', 'nso-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(210, 'Setswana (Botswana)', 'tn', 'tn-BW', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(211, 'Setswana (South Africa)', 'tn', 'tn-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(212, 'Sindhi', 'sd', 'sd-Arab', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(213, 'Sindhi (Islamic Republic of Pakistan)', 'sd', 'sd-Arab-PK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(214, 'Sinhala (Sri Lanka)', 'si', 'si-LK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(215, 'Slovak (Slovakia)', 'sk', 'sk-SK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(216, 'Slovenian (Slovenia)', 'sl', 'sl-SI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(217, 'Somali (Somalia)', 'so', 'so-SO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(218, 'Sotho (South Africa)', 'st', 'st-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(219, 'Spanish (Argentina)', 'es', 'es-AR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(220, 'Spanish (Bolivarian Republic of Venezuela)', 'es', 'es-VE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(221, 'Spanish (Bolivia)', 'es', 'es-BO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(222, 'Spanish (Chile)', 'es', 'es-CL', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(223, 'Spanish (Colombia)', 'es', 'es-CO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(224, 'Spanish (Costa Rica)', 'es', 'es-CR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(225, 'Spanish (Cuba)', 'es', 'es-CU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(226, 'Spanish (Dominican Republic)', 'es', 'es-DO', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(227, 'Spanish (Ecuador)', 'es', 'es-EC', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(228, 'Spanish (El Salvador)', 'es', 'es-SV', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(229, 'Spanish (Guatemala)', 'es', 'es-GT', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(230, 'Spanish (Honduras)', 'es', 'es-HN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(231, 'Spanish (Latin America)', 'es', 'es-419', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(232, 'Spanish (Mexico)', 'es', 'es-MX', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(233, 'Spanish (Nicaragua)', 'es', 'es-NI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(234, 'Spanish (Panama)', 'es', 'es-PA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(235, 'Spanish (Paraguay)', 'es', 'es-PY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(236, 'Spanish (Peru)', 'es', 'es-PE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(237, 'Spanish (Puerto Rico)', 'es', 'es-PR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(238, 'Spanish (Spain, International Sort)', 'es', 'es-ES', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(239, 'Spanish (Traditional Sort)', 'es', 'es-ES', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(240, 'Spanish (United States)', 'es', 'es-US', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(241, 'Spanish (Uruguay)', 'es', 'es-UY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(242, 'Swedish (Finland)', 'sv', 'sv-FI', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(243, 'Swedish (Sweden)', 'sv', 'sv-SE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(244, 'Syriac (Syria)', 'syr', 'syr-SY', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(245, 'Tajik (Cyrillic)', 'tg', 'tg-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(246, 'Tajik (Cyrillic, Tajikistan)', 'tg', 'tg-Cyrl-TJ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(247, 'Tamazight (Latin)', 'tzm', 'tzm-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(248, 'Tamazight (Latin, Algeria)', 'tzm', 'tzm-Latn-DZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(249, 'Tamil (India)', 'ta', 'ta-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(250, 'Tamil (Sri Lanka)', 'ta', 'ta-LK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(251, 'Tatar (Russia)', 'tt', 'tt-RU', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(252, 'Telugu (India)', 'te', 'te-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(253, 'Thai (Thailand)', 'th', 'th-TH', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(254, 'Tibetan (People\'s Republic of China)', 'bo', 'bo-CN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(255, 'Tigrinya (Eritrea)', 'ti', 'ti-ER', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(256, 'Tigrinya (Ethiopia)', 'ti', 'ti-ET', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(257, 'Tsonga (South Africa)', 'ts', 'ts-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(258, 'Turkish (Turkey)', 'tr', 'tr-TR', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(259, 'Turkmen (Turkmenistan)', 'tk', 'tk-TM', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(260, 'Ukrainian (Ukraine)', 'uk', 'uk-UA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(261, 'Upper Sorbian (Germany)', 'hsb', 'hsb-DE', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(262, 'Urdu (India)', 'ur', 'ur-IN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(263, 'Urdu (Islamic Republic of Pakistan)', 'ur', 'ur-PK', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(264, 'Uyghur (People\'s Republic of China)', 'ug', 'ug-CN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(265, 'Uzbek (Cyrillic)', 'uz', 'uz-Cyrl', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(266, 'Uzbek (Cyrillic, Uzbekistan)', 'uz', 'uz-Cyrl-UZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(267, 'Uzbek (Latin)', 'uz', 'uz-Latn', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(268, 'Uzbek (Latin, Uzbekistan)', 'uz', 'uz-Latn-UZ', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(269, 'Valencian (Spain)', 'ca', 'ca-ES-valencia', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(270, 'Venda (South Africa)', 've', 've-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(271, 'Vietnamese (Vietnam)', 'vi', 'vi-VN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(272, 'Welsh (United Kingdom)', 'cy', 'cy-GB', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(273, 'Wolof (Senegal)', 'wo', 'wo-SN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(274, 'Xhosa (South Africa)', 'xh', 'xh-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(275, 'Yi (People\'s Republic of China)', 'ii', 'ii-CN', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(276, 'Yiddish (World)', 'yi', 'yi-001', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(277, 'Yoruba (Nigeria)', 'yo', 'yo-NG', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(278, 'Zulu (South Africa)', 'zu', 'zu-ZA', '2024-08-01 02:14:59', '2024-08-01 02:14:59');

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

--
-- Table structure for table `language_lists`
--

CREATE TABLE `language_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_name` varchar(255) DEFAULT NULL,
  `language_code` varchar(255) DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `language_flag` varchar(255) DEFAULT NULL,
  `is_rtl` tinyint(4) DEFAULT 0,
  `is_default` tinyint(4) DEFAULT 0 COMMENT '0-no, 1-yes',
  `status` tinyint(4) 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 `language_version_details`
--

CREATE TABLE `language_version_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `default_language_id` bigint(20) UNSIGNED DEFAULT NULL,
  `version_no` bigint(20) UNSIGNED 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 `language_version_details`
--

INSERT INTO `language_version_details` (`id`, `default_language_id`, `version_no`, `created_at`, `updated_at`) VALUES
(1, NULL, 3, '2024-08-01 02:15:02', '2024-08-14 07:27:31');

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

--
-- Table structure for table `language_with_keywords`
--

CREATE TABLE `language_with_keywords` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL,
  `keyword_id` bigint(20) UNSIGNED DEFAULT NULL,
  `screen_id` bigint(20) UNSIGNED DEFAULT NULL,
  `keyword_value` varchar(255) 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 `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin 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=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(21, 'App\\Models\\Vehicle', 1, 'd3bbbe5f-c198-4fab-bc44-544b69f330a3', 'vehicle_image', 'download (4)', 'download-(4).jpg', 'image/jpeg', 'public', 'public', 13713, '[]', '[]', '[]', '[]', 18, '2024-08-01 04:09:28', '2024-08-01 04:09:28'),
(23, 'App\\Models\\FrontendData', 3, '87ee8c7f-1b4f-42bd-b17e-13e09e64de1d', 'frontend_data_image', 'mf', 'mf.jpg', 'image/jpeg', 'public', 'public', 101424, '[]', '[]', '[]', '[]', 20, '2024-08-01 04:12:46', '2024-08-01 04:12:46'),
(48, 'App\\Models\\FrontendData', 4, '8caf2084-172f-4f07-904b-99776c951268', 'frontend_data_image', '2023-11-01-65421ad4b92c0', '2023-11-01-65421ad4b92c0.png', 'image/jpeg', 'public', 'public', 7627, '[]', '[]', '[]', '[]', 37, '2024-08-01 08:46:16', '2024-08-01 08:46:16'),
(58, 'App\\Models\\Vehicle', 2, 'fa3c508c-f323-4464-a834-9eea72a6c21c', 'vehicle_image', '1', '1.jpg', 'image/jpeg', 'public', 'public', 1675541, '[]', '[]', '[]', '[]', 46, '2024-08-01 09:11:55', '2024-08-01 09:11:55'),
(59, 'App\\Models\\Vehicle', 3, '2214b5aa-a6f1-4c5b-9a1b-24faabce33a9', 'vehicle_image', '2', '2.jpg', 'image/jpeg', 'public', 'public', 193546, '[]', '[]', '[]', '[]', 47, '2024-08-01 09:12:12', '2024-08-01 09:12:12'),
(60, 'App\\Models\\Vehicle', 4, '09e6b8bc-e77a-4a1a-9b3b-12ad2b4cf2f3', 'vehicle_image', '3', '3.png', 'image/jpeg', 'public', 'public', 339368, '[]', '[]', '[]', '[]', 48, '2024-08-01 09:12:27', '2024-08-01 09:12:27'),
(62, 'App\\Models\\Vehicle', 5, 'f0aef045-00e9-4c22-8a7e-fcdc60c289ab', 'vehicle_image', '5', '5.jpg', 'image/jpeg', 'public', 'public', 41709, '[]', '[]', '[]', '[]', 50, '2024-08-01 09:12:59', '2024-08-01 09:12:59'),
(63, 'App\\Models\\Vehicle', 6, '9afd7251-5097-449a-99b9-d96189d002e2', 'vehicle_image', '4', '4.png', 'image/png', 'public', 'public', 182281, '[]', '[]', '[]', '[]', 51, '2024-08-01 09:13:20', '2024-08-01 09:13:20'),
(65, 'App\\Models\\Setting', 24, '2091038e-5a42-4ee8-a808-71f579ee8902', 'about_us_app_ss', 'ff', 'ff.png', 'image/png', 'public', 'public', 440001, '[]', '[]', '[]', '[]', 53, '2024-08-01 09:20:44', '2024-08-01 09:20:44'),
(71, 'App\\Models\\FrontendData', 9, '5853e167-f117-4245-a0de-b40b87632f8a', 'frontend_data_image', 'er1', 'er1.jpg', 'image/jpeg', 'public', 'public', 202527, '[]', '[]', '[]', '[]', 57, '2024-08-01 09:30:39', '2024-08-01 09:30:39'),
(73, 'App\\Models\\FrontendData', 10, '5fdb83c8-2209-4dc7-95c9-8b2bea4970f6', 'frontend_data_image', 'hh', 'hh.jpeg', 'image/jpeg', 'public', 'public', 6876, '[]', '[]', '[]', '[]', 59, '2024-08-01 09:33:24', '2024-08-01 09:33:24'),
(76, 'App\\Models\\Setting', 30, '3062818d-71c1-47c8-a71e-77260124fed5', 'contact_us_app_ss', 'tt-Photoroom', 'tt-Photoroom.png', 'image/png', 'public', 'public', 61094, '[]', '[]', '[]', '[]', 61, '2024-08-01 09:42:40', '2024-08-01 09:42:40'),
(99, 'App\\Models\\Setting', 27, '48df7a10-5fea-450c-b015-6e144ec2bc89', 'delivery_partner_image', 'foodora-3402507_640', 'foodora-3402507_640.jpg', 'image/jpeg', 'public', 'public', 96107, '[]', '[]', '[]', '[]', 79, '2024-08-01 10:25:28', '2024-08-01 10:25:28'),
(102, 'App\\Models\\FrontendData', 8, '5379e51e-7371-4c9a-9459-29a0a7c942cf', 'frontend_data_image', 'er (1)', 'er-(1).jpg', 'image/jpeg', 'public', 'public', 9313, '[]', '[]', '[]', '[]', 81, '2024-08-01 10:31:22', '2024-08-01 10:31:22'),
(105, 'App\\Models\\Setting', 8, '150b8e05-9297-485a-bd37-fac79a941625', 'delivery_road_image', 'road (1) (1)', 'road-(1)-(1).jpg', 'image/jpeg', 'public', 'public', 108719, '[]', '[]', '[]', '[]', 82, '2024-08-01 10:44:00', '2024-08-01 10:44:00'),
(125, 'App\\Models\\User', 16, '4d13b4cb-55a7-43c3-9e7d-da7c5b489631', 'profile_image', 'czNmcy1wcml2YXRlL3Jhd3BpeGVsX2ltYWdlcy93ZWJzaXRlX2NvbnRlbnQvam9iNjgwLTE2Ni1wLWwxZGJ1cTN2LnBuZw', 'czNmcy1wcml2YXRlL3Jhd3BpeGVsX2ltYWdlcy93ZWJzaXRlX2NvbnRlbnQvam9iNjgwLTE2Ni1wLWwxZGJ1cTN2LnBuZw.png', 'image/jpeg', 'public', 'public', 100532, '[]', '[]', '[]', '[]', 91, '2024-08-12 08:34:01', '2024-08-12 08:34:01'),
(153, 'App\\Models\\FrontendData', 6, 'ebaf681f-0af4-4a95-8669-6916b5fe0248', 'frontend_data_image', 'gggg-Photoroom', 'gggg-Photoroom.png', 'image/png', 'public', 'public', 204244, '[]', '[]', '[]', '[]', 108, '2024-08-13 13:07:50', '2024-08-13 13:07:50'),
(155, 'App\\Models\\FrontendData', 5, 'dbf5369a-cf16-4add-b4fe-d6191ade397c', 'frontend_data_image', 'yii (1)', 'yii-(1).png', 'image/png', 'public', 'public', 148361, '[]', '[]', '[]', '[]', 109, '2024-08-13 13:11:44', '2024-08-13 13:11:44'),
(163, 'App\\Models\\FrontendData', 1, 'e1127f98-f7cb-408a-b018-453184e817ca', 'frontend_data_image', '9485586', '9485586.png', 'image/png', 'public', 'public', 14128, '[]', '[]', '[]', '[]', 114, '2024-08-14 02:52:17', '2024-08-14 02:52:17'),
(167, 'App\\Models\\Setting', 34, 'f3e6e240-4ef2-4e04-b16d-1e0de83e6166', 'company_logo', 'mxunzo  (173 x 40 px)', 'mxunzo--(173-x-40-px).png', 'image/png', 'public', 'public', 9893, '[]', '[]', '[]', '[]', 118, '2024-08-14 03:00:25', '2024-08-14 03:00:25'),
(168, 'App\\Models\\Setting', 9, '87d004f7-6087-40e0-8f5e-aa64da297458', 'app_logo_image', 'mxunzo(195 x 45 px)', 'mxunzo(195-x-45-px).png', 'image/png', 'public', 'public', 10851, '[]', '[]', '[]', '[]', 119, '2024-08-14 03:00:39', '2024-08-14 03:00:39'),
(169, 'App\\Models\\FrontendData', 11, '34c06bcd-1983-405f-99af-40c565d737f1', 'frontend_data_image', 'op', 'op.jpg', 'image/webp', 'public', 'public', 18268, '[]', '[]', '[]', '[]', 120, '2024-08-14 03:17:37', '2024-08-14 03:17:37'),
(170, 'App\\Models\\FrontendData', 2, '19924768-1a55-4650-bd09-b88f4eb0718c', 'frontend_data_image', 'ff', 'ff.jpg', 'image/jpeg', 'public', 'public', 23666, '[]', '[]', '[]', '[]', 121, '2024-08-14 04:14:15', '2024-08-14 04:14:15'),
(171, 'App\\Models\\Setting', 20, '55368135-a63f-4770-a4ac-149ba6889f78', 'download_app_logo', 'MXUNZO delievery boy', 'MXUNZO-delievery-boy.png', 'image/png', 'public', 'public', 145509, '[]', '[]', '[]', '[]', 122, '2024-08-14 04:20:08', '2024-08-14 04:20:08'),
(172, 'App\\Models\\Setting', 7, '332056be-a4cd-4d94-8993-7ad5db9c7523', 'delivery_man_image', 'jjjj', 'jjjj.jpeg', 'image/jpeg', 'public', 'public', 95064, '[]', '[]', '[]', '[]', 123, '2024-08-14 05:57:29', '2024-08-14 05:57:29'),
(174, 'App\\Models\\AppSetting', 1, '6d589c35-2722-46ba-ba93-fed4b3d59d5e', 'site_logo', 'kkkk', 'kkkk.png', 'image/png', 'public', 'public', 9893, '[]', '[]', '[]', '[]', 124, '2024-08-14 06:47:00', '2024-08-14 06:47:00'),
(175, 'App\\Models\\AppSetting', 1, '6b340642-b5ea-4b76-bcff-f53106bf804a', 'site_dark_logo', 'kkkk', 'kkkk.png', 'image/png', 'public', 'public', 9893, '[]', '[]', '[]', '[]', 125, '2024-08-14 06:47:14', '2024-08-14 06:47:14'),
(176, 'App\\Models\\AppSetting', 1, 'd89ef313-ac1a-4d5a-b57d-d217f4ef4f84', 'site_favicon', 'fevicon mxunzo', 'fevicon-mxunzo.png', 'image/png', 'public', 'public', 2784, '[]', '[]', '[]', '[]', 126, '2024-08-14 06:56:27', '2024-08-14 06:56:27'),
(182, 'App\\Models\\User', 12, '61814eb9-e81a-4508-acbb-8627d6697716', 'profile_image', 'sir-pic (1)', 'sir-pic-(1).png', 'image/png', 'public', 'public', 85837, '[]', '[]', '[]', '[]', 127, '2024-08-16 02:25:14', '2024-08-16 02:25:14'),
(184, 'App\\Models\\Vehicle', 8, '9121fa56-8118-463d-8693-00903b0eb39d', 'vehicle_image', 'metro1', 'metro1.jpg', 'image/jpeg', 'public', 'public', 512379, '[]', '[]', '[]', '[]', 128, '2024-08-16 03:18:36', '2024-08-16 03:18:36'),
(185, 'App\\Models\\User', 1, 'be70094a-ac23-4f29-94a4-6b5326cde0d3', 'profile_image', 'sir-pic (1)', 'sir-pic-(1).png', 'image/png', 'public', 'public', 85837, '[]', '[]', '[]', '[]', 129, '2024-08-16 10:01:34', '2024-08-16 10:01:34');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2022_01_08_103820_create_sessions_table', 1),
(7, '2022_01_10_051714_create_countries_table', 1),
(8, '2022_01_10_070509_create_cities_table', 1),
(9, '2022_01_10_101903_create_extra_charges_table', 1),
(10, '2022_01_10_112023_create_app_settings_table', 1),
(11, '2022_01_11_090450_create_media_table', 1),
(12, '2022_01_13_074756_create_orders_table', 1),
(13, '2022_01_13_095310_create_static_data_table', 1),
(14, '2022_01_15_084527_create_order_histories_table', 1),
(15, '2022_01_18_100915_create_payment_gateways_table', 1),
(16, '2022_01_19_060358_create_payments_table', 1),
(17, '2022_01_24_104630_create_notifications_table', 1),
(18, '2022_04_14_084202_create_documents_table', 1),
(19, '2022_04_14_084351_create_delivery_man_documents_table', 1),
(20, '2022_05_02_120722_create_permission_tables', 1),
(21, '2022_05_11_080007_add_total_parcel_orders_table', 1),
(22, '2022_05_30_063501_add_fcm_token_to_users_table', 1),
(23, '2022_05_31_101332_add_auto_assign_to_orders', 1),
(24, '2022_06_02_065520_add_distance_to_app_settings', 1),
(25, '2022_06_27_131039_add_otp_verify_on_pickup_delivery', 1),
(26, '2022_12_05_111707_alter_cities_table', 1),
(27, '2022_12_05_140929_create_wallets_table', 1),
(28, '2022_12_05_140954_create_wallet_histories_table', 1),
(29, '2022_12_05_141107_create_user_bank_accounts_table', 1),
(30, '2022_12_06_061753_alter_payments_table', 1),
(31, '2022_12_10_054128_create_withdraw_requests_table', 1),
(32, '2023_01_30_121805_create_vehicles_table', 1),
(33, '2023_01_30_131633_add_is_vehicle_in_order_in_app_settings_table', 1),
(34, '2023_01_30_132224_add_vehicle_data_in_orders_table', 1),
(35, '2023_05_05_111042_create_settings_table', 1),
(36, '2023_05_19_100843_add_otp_verify_at_in_users_table', 1),
(37, '2023_05_22_101819_create_user_addresses_table', 1),
(38, '2023_06_30_054429_create_verification_codes_table', 1),
(39, '2023_07_06_114913_add_login_type_in_users_table', 1),
(40, '2024_03_11_053118_create_push_notifications_table', 1),
(41, '2024_03_18_111624_create_frontend_data_table', 1),
(42, '2024_03_22_103006_add_app_verison_in_users_table', 1),
(43, '2024_05_07_101914_create_language_default_lists_table', 1),
(44, '2024_05_07_101955_create_language_lists_table', 1),
(45, '2024_05_07_102016_create_screens_table', 1),
(46, '2024_05_07_102106_create_default_keywords_table', 1),
(47, '2024_05_07_102158_create_language_with_keywords_table', 1),
(48, '2024_05_07_102229_create_language_version_details_table', 1),
(49, '2024_06_08_070850_create_store_types_table', 1),
(50, '2024_06_08_102521_create_categories_table', 1),
(51, '2024_06_08_102551_create_stores_table', 1),
(52, '2024_06_08_102613_create_sub_categories_table', 1),
(53, '2024_06_10_045551_create_products_table', 1),
(54, '2024_06_10_053444_create_work_hour_manages_table', 1),
(55, '2024_06_12_084458_create_order_item_mappings_table', 1),
(56, '2024_06_20_071407_create_ratings_table', 1),
(57, '2024_06_20_104536_create_user_favourite_stores_table', 1),
(58, '2024_06_21_085508_create_store_items_table', 1),
(59, '2024_06_28_085435_create_store_manages_table', 1),
(60, '2024_07_13_060748_add_columns_to_users_table', 1),
(61, '2024_07_16_051333_create_pages_table', 1),
(62, '2024_07_23_123915_add_language_option_in_app_settings_table', 1),
(63, '2024_07_25_123845_alter_orders_table', 1),
(64, '2024_07_25_124146_add_columns_to_user_bank_accounts_table', 1),
(65, '2024_07_25_124245_add_column_to_vehicles_table', 1),
(66, '2024_07_25_124352_add_column_to_user_addresses_table', 1);

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

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) 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` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) 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
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 3),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 5),
(2, 'App\\Models\\User', 12),
(2, 'App\\Models\\User', 16),
(2, 'App\\Models\\User', 21),
(3, 'App\\Models\\User', 2),
(3, 'App\\Models\\User', 6),
(3, 'App\\Models\\User', 7),
(3, 'App\\Models\\User', 8),
(3, 'App\\Models\\User', 9),
(3, 'App\\Models\\User', 10),
(3, 'App\\Models\\User', 11),
(3, 'App\\Models\\User', 15);

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

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

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text 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;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('00a4dced-c2bd-4e1f-b731-a750f6defe6e', 'App\\Notifications\\OrderNotification', 'App\\Models\\User', 1, '{\"id\":1,\"type\":\"create\",\"subject\":\"Order #1\",\"message\":\"New order has been created.\"}', NULL, '2024-08-01 08:59:51', '2024-08-01 08:59:51'),
('044a1689-d022-444a-84f2-b97c5ad4b7bd', 'App\\Notifications\\OrderNotification', 'App\\Models\\User', 1, '{\"id\":2,\"type\":\"create\",\"subject\":\"Order #2\",\"message\":\"New order has been created.\"}', NULL, '2024-08-01 09:53:04', '2024-08-01 09:53:04'),
('71f7f0ed-6eda-47b0-a8ad-57432165693c', 'App\\Notifications\\OrderNotification', 'App\\Models\\User', 1, '{\"id\":6,\"type\":\"create\",\"subject\":\"Order #6\",\"message\":\"New order has been created.\"}', NULL, '2024-08-16 02:37:54', '2024-08-16 02:37:54'),
('906ee7e6-8dc8-4f06-846a-cca136ad5455', 'App\\Notifications\\OrderNotification', 'App\\Models\\User', 1, '{\"id\":7,\"type\":\"create\",\"subject\":\"Order #7\",\"message\":\"New order has been created.\"}', NULL, '2024-08-16 03:01:40', '2024-08-16 03:01:40'),
('f5e598ef-ae36-4278-b41e-9b6b71a33b4c', 'App\\Notifications\\OrderNotification', 'App\\Models\\User', 1, '{\"id\":3,\"type\":\"create\",\"subject\":\"Order #3\",\"message\":\"New order has been created.\"}', NULL, '2024-08-12 08:33:36', '2024-08-12 08:33:36');

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pickup_point` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `delivery_point` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parcel_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_weight` double DEFAULT 0,
  `total_distance` double DEFAULT 0,
  `date` datetime DEFAULT NULL,
  `pickup_datetime` datetime DEFAULT NULL,
  `delivery_datetime` datetime DEFAULT NULL,
  `assign_datetime` datetime DEFAULT NULL,
  `parent_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_collect_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'on_pickup, on_delivery',
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fixed_charges` double DEFAULT 0,
  `weight_charge` double DEFAULT 0,
  `distance_charge` double DEFAULT 0,
  `extra_charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `total_amount` double DEFAULT 0,
  `pickup_confirm_by_client` tinyint(4) DEFAULT 0 COMMENT '0-not confirm , 1 - confirm',
  `pickup_confirm_by_delivery_man` tinyint(4) DEFAULT 0 COMMENT '0-not confirm , 1 - confirm',
  `total_parcel` double DEFAULT NULL,
  `vehicle_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vehicle_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `auto_assign` tinyint(4) DEFAULT NULL,
  `cancelled_delivery_man_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `client_id`, `pickup_point`, `delivery_point`, `country_id`, `store_detail_id`, `city_id`, `parcel_type`, `total_weight`, `total_distance`, `date`, `pickup_datetime`, `delivery_datetime`, `assign_datetime`, `parent_order_id`, `payment_id`, `reason`, `description`, `status`, `payment_collect_from`, `delivery_man_id`, `fixed_charges`, `weight_charge`, `distance_charge`, `extra_charges`, `total_amount`, `pickup_confirm_by_client`, `pickup_confirm_by_delivery_man`, `total_parcel`, `vehicle_id`, `vehicle_data`, `auto_assign`, `cancelled_delivery_man_ids`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 16, '{\"start_time\":\"2024-08-12 16:05:20.085235\",\"end_time\":null,\"address\":\"1600 Amphitheatre Pkwy Building 43, Mountain View, CA 94043, USA\",\"latitude\":\"37.4215304\",\"longitude\":\"-122.0840833\",\"description\":\"ghgh\",\"contact_number\":\"+911234567890\"}', '{\"start_time\":null,\"end_time\":null,\"address\":\"1600 Amphitheatre Pkwy Building 43, Mountain View, CA 94043, USA\",\"latitude\":\"37.4215304\",\"longitude\":\"-122.0840833\",\"description\":\"gffgfg\",\"contact_number\":\"+91 3214567899\"}', 1, NULL, 1, 'Bubble Wrap', 2, 1, '2024-08-12 10:33:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'create', 'on_pickup', NULL, 1000, 1, 0, '[{\"key\":\"fixed_charges\",\"value\":1000,\"value_type\":null},{\"key\":\"min_distance\",\"value\":1000,\"value_type\":null},{\"key\":\"min_weight\",\"value\":1,\"value_type\":null},{\"key\":\"per_distance_charges\",\"value\":1,\"value_type\":null},{\"key\":\"per_weight_charges\",\"value\":1,\"value_type\":null},{\"key\":\"chaim_contreras\",\"value\":64,\"value_type\":\"fixed\"}]', 1065, 0, 0, 2, NULL, NULL, NULL, NULL, '2024-08-12 08:33:35', '2024-08-12 08:33:35', NULL),
(5, 16, '{\"start_time\":\"2024-08-13 18:13:45.757770\",\"end_time\":null,\"address\":null,\"latitude\":null,\"longitude\":null,\"description\":null,\"contact_number\":\"IN\"}', '{\"start_time\":null,\"end_time\":null,\"address\":null,\"latitude\":null,\"longitude\":null,\"description\":null,\"contact_number\":\"IN\"}', 1, NULL, 1, NULL, 1, 0, '2024-08-13 12:43:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'draft', 'on_pickup', NULL, 1000, 0, 0, '[{\"key\":\"fixed_charges\",\"value\":1000,\"value_type\":null},{\"key\":\"min_distance\",\"value\":1000,\"value_type\":null},{\"key\":\"min_weight\",\"value\":1,\"value_type\":null},{\"key\":\"per_distance_charges\",\"value\":1,\"value_type\":null},{\"key\":\"per_weight_charges\",\"value\":1,\"value_type\":null},{\"key\":\"chaim_contreras\",\"value\":64,\"value_type\":\"fixed\"}]', 0, 0, 0, 1, NULL, NULL, NULL, NULL, '2024-08-13 10:43:47', '2024-08-16 02:48:03', NULL),
(7, 1, '{\"start_time\":null,\"end_time\":null,\"address\":\"Mumbra, Thane, Maharashtra, India\",\"latitude\":\"19.1760819\",\"longitude\":\"73.02288949999999\",\"contact_number\":\"+919876143215\",\"description\":\"Safe pickup\",\"instruction\":\"Handle with care\"}', '{\"start_time\":null,\"end_time\":null,\"address\":\"Indore, Madhya Pradesh, India\",\"latitude\":\"22.7195687\",\"longitude\":\"75.8577258\",\"contact_number\":\"+916879543121\",\"description\":\"Drop safely\",\"instruction\":\"Deliver on time\"}', 1, NULL, 1, 'Plastic', 5, 563.53, '2024-08-16 05:01:38', NULL, NULL, NULL, NULL, NULL, NULL, 'Toys', 'create', 'on_delivery', NULL, 1000, 1, 1000, '[{\"key\":\"Chaim Contreras\",\"value\":64,\"value_type\":\"fixed\"}]', 2001, 0, 0, 1, 3, '{\"id\":3,\"title\":\"Ishmael Riggs\",\"type\":\"all\",\"size\":\"Id molestias et at\",\"city_ids\":null,\"capacity\":\"Quae saepe totam et\",\"status\":1,\"description\":\"Libero esse consequ\",\"price\":628,\"created_at\":\"2024-08-01T11:12:12.000000Z\",\"updated_at\":\"2024-08-01T11:12:12.000000Z\",\"deleted_at\":null}', 0, '[]', '2024-08-16 03:01:38', '2024-08-16 03:01:40', NULL);

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

--
-- Table structure for table `order_histories`
--

CREATE TABLE `order_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `datetime` datetime DEFAULT NULL,
  `history_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `order_histories`
--

INSERT INTO `order_histories` (`id`, `order_id`, `datetime`, `history_type`, `history_message`, `history_data`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 3, '2024-08-12 10:33:35', 'create', 'New order has been created.', '{\"client_id\":16,\"client_name\":\"gta\"}', '2024-08-12 08:33:36', '2024-08-12 08:33:36', NULL),
(5, 5, '2024-08-13 12:43:47', 'draft', 'Order Draft', '{\"client_id\":16,\"client_name\":\"gta\"}', '2024-08-13 10:43:48', '2024-08-16 02:48:03', NULL),
(7, 7, '2024-08-16 05:01:38', 'create', 'New order has been created.', '{\"client_id\":1,\"client_name\":\"Admin\"}', '2024-08-16 03:01:39', '2024-08-16 03:01:39', NULL);

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

--
-- Table structure for table `order_item_mappings`
--

CREATE TABLE `order_item_mappings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_price` double DEFAULT 0,
  `total_price` double DEFAULT 0,
  `discount_price` double DEFAULT 0,
  `extra_charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `order_item_mappings`
--

INSERT INTO `order_item_mappings` (`id`, `order_id`, `product_id`, `city_id`, `product_price`, `total_price`, `discount_price`, `extra_charges`, `created_at`, `updated_at`) VALUES
(3, 3, 'null', 1, NULL, NULL, NULL, '[{\"key\":\"fixed_charges\",\"value\":1000,\"value_type\":null},{\"key\":\"min_distance\",\"value\":1000,\"value_type\":null},{\"key\":\"min_weight\",\"value\":1,\"value_type\":null},{\"key\":\"per_distance_charges\",\"value\":1,\"value_type\":null},{\"key\":\"per_weight_charges\",\"value\":1,\"value_type\":null},{\"key\":\"chaim_contreras\",\"value\":64,\"value_type\":\"fixed\"}]', '2024-08-12 08:33:35', '2024-08-12 08:33:35'),
(5, 5, 'null', 1, NULL, NULL, NULL, '[{\"key\":\"fixed_charges\",\"value\":1000,\"value_type\":null},{\"key\":\"min_distance\",\"value\":1000,\"value_type\":null},{\"key\":\"min_weight\",\"value\":1,\"value_type\":null},{\"key\":\"per_distance_charges\",\"value\":1,\"value_type\":null},{\"key\":\"per_weight_charges\",\"value\":1,\"value_type\":null},{\"key\":\"chaim_contreras\",\"value\":64,\"value_type\":\"fixed\"}]', '2024-08-13 10:43:47', '2024-08-13 10:43:47'),
(7, 7, 'null', 1, NULL, NULL, NULL, '\"[{\\\"id\\\":2,\\\"title\\\":\\\"Chaim Contreras\\\",\\\"charges_type\\\":\\\"fixed\\\",\\\"charges\\\":64,\\\"country_id\\\":1,\\\"city_id\\\":1,\\\"status\\\":1,\\\"created_at\\\":\\\"2024-08-01T11:13:56.000000Z\\\",\\\"updated_at\\\":\\\"2024-08-01T11:13:56.000000Z\\\",\\\"deleted_at\\\":null},{\\\"title\\\":\\\"fixed_charges\\\",\\\"charges\\\":1000},{\\\"title\\\":\\\"per_weight_charges\\\",\\\"charges\\\":1},{\\\"title\\\":\\\"min_weight\\\",\\\"charges\\\":1},{\\\"title\\\":\\\"min_distance\\\",\\\"charges\\\":1000},{\\\"title\\\":\\\"per_distance_charges\\\",\\\"charges\\\":1}]\"', '2024-08-16 03:01:38', '2024-08-16 03:01:38');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `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 `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `datetime` datetime DEFAULT NULL,
  `total_amount` double DEFAULT 0,
  `payment_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `txn_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'pending, paid, failed',
  `transaction_detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `cancel_charges` double DEFAULT 0,
  `admin_commission` double DEFAULT 0,
  `delivery_man_commission` double DEFAULT 0,
  `received_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_man_fee` double DEFAULT 0,
  `delivery_man_tip` double DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1 COMMENT '0- InActive, 1- Active',
  `is_test` tinyint(4) DEFAULT 1 COMMENT '0-  No, 1- Yes',
  `test_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `live_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `parent_id` bigint(20) 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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `parent_id`, `created_at`, `updated_at`) VALUES
(1, 'role', 'web', NULL, '2024-08-01 02:14:58', NULL),
(2, 'role-add', 'web', 1, '2024-08-01 02:14:58', NULL),
(3, 'role-list', 'web', 1, '2024-08-01 02:14:58', NULL),
(4, 'permission', 'web', NULL, '2024-08-01 02:14:58', NULL),
(5, 'permission-add', 'web', 4, '2024-08-01 02:14:58', NULL),
(6, 'permission-list', 'web', 4, '2024-08-01 02:14:58', NULL),
(7, 'users', 'web', NULL, '2024-08-01 02:14:58', NULL),
(8, 'users-list', 'web', 7, '2024-08-01 02:14:58', NULL),
(9, 'users-add', 'web', 7, '2024-08-01 02:14:58', NULL),
(10, 'users-edit', 'web', 7, '2024-08-01 02:14:58', NULL),
(11, 'users-show', 'web', 7, '2024-08-01 02:14:58', NULL),
(12, 'users-delete', 'web', 7, '2024-08-01 02:14:58', NULL),
(13, 'deliveryman', 'web', NULL, '2024-08-01 02:14:58', NULL),
(14, 'deliveryman-add', 'web', 13, '2024-08-01 02:14:58', NULL),
(15, 'deliveryman-edit', 'web', 13, '2024-08-01 02:14:58', NULL),
(16, 'deliveryman-list', 'web', 13, '2024-08-01 02:14:58', NULL),
(17, 'deliveryman-show', 'web', 13, '2024-08-01 02:14:58', NULL),
(18, 'deliveryman-delete', 'web', 13, '2024-08-01 02:14:58', NULL),
(19, 'document', 'web', NULL, '2024-08-01 02:14:58', NULL),
(20, 'document-add', 'web', 19, '2024-08-01 02:14:58', NULL),
(21, 'document-edit', 'web', 19, '2024-08-01 02:14:58', NULL),
(22, 'document-list', 'web', 19, '2024-08-01 02:14:58', NULL),
(23, 'document-delete', 'web', 19, '2024-08-01 02:14:58', NULL),
(24, 'city', 'web', NULL, '2024-08-01 02:14:58', NULL),
(25, 'city-add', 'web', 24, '2024-08-01 02:14:58', NULL),
(26, 'city-edit', 'web', 24, '2024-08-01 02:14:58', NULL),
(27, 'city-list', 'web', 24, '2024-08-01 02:14:58', NULL),
(28, 'city-show', 'web', 24, '2024-08-01 02:14:58', NULL),
(29, 'city-delete', 'web', 24, '2024-08-01 02:14:58', NULL),
(30, 'country', 'web', NULL, '2024-08-01 02:14:58', NULL),
(31, 'country-add', 'web', 30, '2024-08-01 02:14:58', NULL),
(32, 'country-edit', 'web', 30, '2024-08-01 02:14:58', NULL),
(33, 'country-list', 'web', 30, '2024-08-01 02:14:58', NULL),
(34, 'country-delete', 'web', 30, '2024-08-01 02:14:58', NULL),
(35, 'vehicle', 'web', NULL, '2024-08-01 02:14:58', NULL),
(36, 'vehicle-add', 'web', 35, '2024-08-01 02:14:58', NULL),
(37, 'vehicle-edit', 'web', 35, '2024-08-01 02:14:58', NULL),
(38, 'vehicle-list', 'web', 35, '2024-08-01 02:14:58', NULL),
(39, 'vehicle-show', 'web', 35, '2024-08-01 02:14:58', NULL),
(40, 'vehicle-delete', 'web', 35, '2024-08-01 02:14:58', NULL),
(41, 'extacharge', 'web', NULL, '2024-08-01 02:14:58', NULL),
(42, 'extracharge-add', 'web', 41, '2024-08-01 02:14:58', NULL),
(43, 'extracharge-edit', 'web', 41, '2024-08-01 02:14:58', NULL),
(44, 'extracharge-list', 'web', 41, '2024-08-01 02:14:58', NULL),
(45, 'extracharge-delete', 'web', 41, '2024-08-01 02:14:58', NULL),
(46, 'deliverymandocument', 'web', NULL, '2024-08-01 02:14:58', NULL),
(47, 'deliverymandocument-add', 'web', 46, '2024-08-01 02:14:58', NULL),
(48, 'staticdata', 'web', NULL, '2024-08-01 02:14:58', NULL),
(49, 'staticdata-add', 'web', 48, '2024-08-01 02:14:58', NULL),
(50, 'staticdata-edit', 'web', 48, '2024-08-01 02:14:58', NULL),
(51, 'staticdata-delete', 'web', 48, '2024-08-01 02:14:58', NULL),
(52, 'staticdata-list', 'web', 48, '2024-08-01 02:14:58', NULL),
(53, 'order', 'web', NULL, '2024-08-01 02:14:58', NULL),
(54, 'order-list', 'web', 53, '2024-08-01 02:14:58', NULL),
(55, 'order-show', 'web', 53, '2024-08-01 02:14:58', NULL),
(56, 'order-delete', 'web', 53, '2024-08-01 02:14:58', NULL),
(57, 'order-add', 'web', 53, '2024-08-01 02:14:58', NULL),
(58, 'order-edit', 'web', 53, '2024-08-01 02:14:58', NULL),
(59, 'withdrawrequest', 'web', NULL, '2024-08-01 02:14:58', NULL),
(60, 'withdrawrequest-show', 'web', 59, '2024-08-01 02:14:58', NULL),
(61, 'screen', 'web', NULL, '2024-08-01 02:14:58', NULL),
(62, 'screen-list', 'web', 61, '2024-08-01 02:14:58', NULL),
(63, 'defaultkeyword', 'web', NULL, '2024-08-01 02:14:58', NULL),
(64, 'defaultkeyword-list', 'web', 63, '2024-08-01 02:14:58', NULL),
(65, 'defaultkeyword-add', 'web', 63, '2024-08-01 02:14:58', NULL),
(66, 'defaultkeyword-edit', 'web', 63, '2024-08-01 02:14:58', NULL),
(67, 'languagelist', 'web', NULL, '2024-08-01 02:14:58', NULL),
(68, 'languagelist-list', 'web', 67, '2024-08-01 02:14:58', NULL),
(69, 'languagelist-add', 'web', 67, '2024-08-01 02:14:58', NULL),
(70, 'languagelist-edit', 'web', 67, '2024-08-01 02:14:58', NULL),
(71, 'languagelist-delete', 'web', 67, '2024-08-01 02:14:58', NULL),
(72, 'languagewithkeyword', 'web', NULL, '2024-08-01 02:14:58', NULL),
(73, 'languagewithkeyword-list', 'web', 72, '2024-08-01 02:14:58', NULL),
(74, 'languagewithkeyword-edit', 'web', 72, '2024-08-01 02:14:58', NULL),
(75, 'bulkimport', 'web', NULL, '2024-08-01 02:14:58', NULL),
(76, 'bulkimport-list', 'web', 75, '2024-08-01 02:14:58', NULL),
(77, 'push notification', 'web', NULL, '2024-08-01 02:14:58', NULL),
(78, 'push notification-list', 'web', 77, '2024-08-01 02:14:58', NULL),
(79, 'push notification-add', 'web', 77, '2024-08-01 02:14:58', NULL),
(80, 'push notification-delete', 'web', 77, '2024-08-01 02:14:58', NULL),
(81, 'withdrawrequest-list', 'web', 59, '2024-08-01 02:14:58', NULL),
(82, 'withdrawrequest-add', 'web', 59, '2024-08-01 02:14:58', NULL),
(83, 'pages', 'web', NULL, '2024-08-01 02:14:58', NULL),
(84, 'pages-list', 'web', 112, '2024-08-01 02:14:58', NULL),
(85, 'pages-add', 'web', 112, '2024-08-01 02:14:58', NULL),
(86, 'pages-edit', 'web', 112, '2024-08-01 02:14:58', NULL),
(87, 'pages-delete', 'web', 112, '2024-08-01 02:14:58', NULL);

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `storeowner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subcategory_id` bigint(20) UNSIGNED DEFAULT NULL,
  `storetype_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` double DEFAULT 0,
  `status` tinyint(4) DEFAULT 1,
  `description` text 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;

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

--
-- Table structure for table `push_notifications`
--

CREATE TABLE `push_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `for_client` tinyint(1) DEFAULT 0,
  `for_delivery_man` tinyint(1) DEFAULT 0,
  `for_all` tinyint(1) DEFAULT 0,
  `notification_count` bigint(20) 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 `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `rating` double NOT NULL DEFAULT 0,
  `review` text 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 `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `status` tinyint(4) 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', 1, '2024-08-01 02:14:58', NULL),
(2, 'client', 'web', 1, '2024-08-01 02:14:58', '2024-08-01 08:23:57'),
(3, 'delivery_man', 'web', 1, '2024-08-01 02:14:58', '2024-08-01 08:20:21'),
(4, 'moderator', 'web', 1, '2024-08-01 08:10:05', '2024-08-01 08:23:40'),
(5, 'super_admin', 'web', 1, '2024-08-01 08:24:08', '2024-08-01 08:24:08');

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

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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) 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, 1),
(2, 1),
(2, 5),
(3, 1),
(3, 4),
(3, 5),
(4, 1),
(5, 1),
(5, 5),
(6, 1),
(6, 4),
(6, 5),
(7, 1),
(8, 1),
(8, 5),
(9, 1),
(9, 5),
(10, 1),
(10, 5),
(11, 1),
(11, 5),
(12, 1),
(12, 5),
(13, 1),
(14, 1),
(14, 5),
(15, 1),
(15, 5),
(16, 1),
(16, 5),
(17, 1),
(17, 5),
(18, 1),
(18, 5),
(19, 1),
(20, 1),
(20, 5),
(21, 1),
(21, 5),
(22, 1),
(22, 5),
(23, 1),
(23, 5),
(24, 1),
(25, 1),
(25, 5),
(26, 1),
(26, 5),
(27, 1),
(27, 5),
(28, 1),
(28, 5),
(29, 1),
(29, 5),
(30, 1),
(31, 1),
(31, 5),
(32, 1),
(32, 5),
(33, 1),
(33, 5),
(34, 1),
(34, 5),
(35, 1),
(36, 1),
(36, 5),
(37, 1),
(37, 5),
(38, 1),
(38, 5),
(39, 1),
(39, 5),
(40, 1),
(40, 5),
(41, 1),
(42, 1),
(42, 5),
(43, 1),
(43, 5),
(44, 1),
(44, 5),
(45, 1),
(45, 5),
(46, 1),
(47, 1),
(47, 5),
(48, 1),
(49, 1),
(49, 5),
(50, 1),
(50, 5),
(51, 1),
(51, 5),
(52, 1),
(52, 5),
(53, 1),
(54, 1),
(54, 5),
(55, 1),
(55, 5),
(56, 1),
(56, 5),
(57, 1),
(57, 5),
(58, 1),
(58, 5),
(59, 1),
(60, 1),
(60, 5),
(61, 1),
(62, 1),
(62, 5),
(63, 1),
(64, 1),
(64, 5),
(65, 1),
(65, 5),
(66, 1),
(66, 5),
(67, 1),
(68, 1),
(68, 5),
(69, 1),
(69, 5),
(70, 1),
(70, 5),
(71, 1),
(71, 5),
(72, 1),
(73, 1),
(73, 5),
(74, 1),
(74, 5),
(75, 1),
(76, 1),
(76, 5),
(77, 1),
(78, 1),
(78, 5),
(79, 1),
(79, 5),
(80, 1),
(80, 5),
(81, 1),
(81, 5),
(82, 1),
(82, 5),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(87, 1);

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

--
-- Table structure for table `screens`
--

CREATE TABLE `screens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `screenId` varchar(255) DEFAULT NULL,
  `screenName` varchar(255) 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 `screens`
--

INSERT INTO `screens` (`id`, `screenId`, `screenName`, `created_at`, `updated_at`) VALUES
(1, '1', 'WalkThroughScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(2, '2', 'SplashScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(3, '3', 'LoginScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(4, '4', 'ErrorMessages', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(5, '5', 'RegisterScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(6, '6', 'ForgotPasswordScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(7, '7', 'AboutUsScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(8, '8', 'BankDetailScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(9, '9', 'ChangePasswordScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(10, '10', 'EditProfileScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(11, '11', 'EmailVerificationScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(12, '12', 'LanguageScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(13, '13', 'NotificationScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(14, '14', 'ThemeScreen', '2024-08-01 02:14:59', '2024-08-01 02:14:59'),
(15, '15', 'UserCitySelectScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(16, '16', 'VerificationScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(17, '17', 'ChatScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(18, '18', 'AddAddressScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(19, '19', 'CreateOrderScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(20, '20', 'DashboardScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(21, '21', 'AccountFragment', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(22, '22', 'DeleteAccountScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(23, '23', 'DraftOrderListScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(24, '24', 'GoogleMapScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(25, '25', 'MyAddressListScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(26, '27', 'OrderDetailScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(27, '26', 'OrderHistoryScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(28, '28', 'OrderTrackingScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(29, '29', 'PaymentScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(30, '30', 'ReturnOrderScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(31, '31', 'UserDetailsScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(32, '32', 'WalletScreen', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(33, '33', 'DeliveryDashbord', '2024-08-01 02:15:00', '2024-08-01 02:15:00'),
(34, '34', 'EarningHistoryScreen', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(35, '35', 'ReceivedScreenOrderScreen', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(36, '36', 'TrackingScreen', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(37, '37', 'VerifyDeliveryPersonScreen', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(38, '38', 'WithDrawScreen', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(39, '39', 'OrderFragment', '2024-08-01 02:15:01', '2024-08-01 02:15:01'),
(40, '40', 'StoreListScreen', '2024-08-01 02:15:02', '2024-08-01 02:15:02'),
(41, '41', 'ProductListScreen', '2024-08-01 02:15:02', '2024-08-01 02:15:02'),
(42, '42', 'VerificationListScreen', '2024-08-01 02:15:02', '2024-08-01 02:15:02'),
(43, '43', 'DHomeFragment', '2024-08-01 02:15:02', '2024-08-01 02:15:02');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('0412hlITpfOHioIiuQXocEJGxUYnXaWYYZNh0ZoT', NULL, '49.43.0.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', '[encoded data, 16160 characters]', 1723818190),
('5BThrbCWq0oBGHZGehc0MBQWaJylFD3Sy6CLzYvw', 1, '152.58.42.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 28904 characters]', 1723799773);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('5kFdmE5pW0LzpbuUjFjpbUkXTOX9SIxPDrnt5zWP', NULL, '27.56.231.60', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16160 characters]', 1723808572),
('Iwytj8tuh9HJWEPpd31bPngrBiE7sW0X3AZH02r7', NULL, '117.207.214.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16180 characters]', 1723815736),
('Jlljd1Sah5T5Me7eE1Hm5EmO38VhGYERr4m3DSKz', NULL, '106.219.120.140', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16160 characters]', 1723870138);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('LNFD5JQgmEa0Sy9pH8TAhV9A61cwoVwzsC7aKPih', NULL, '152.58.42.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16184 characters]', 1723788049),
('OTIhCzIXDJFNWg3lNfK1wM8fEgcJtlhpJpGsJJT9', NULL, '27.56.231.60', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16176 characters]', 1723804421);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('ULt6m5v3CABwQZNDrkoIpogyh7TK72iL3XEdl7fZ', 1, '152.58.4.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 28948 characters]', 1723812734),
('uuY3lzOqTjdZP3om0zoIRKyiu2en52Rxjr6HggAE', NULL, '152.58.42.37', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '[encoded data, 16180 characters]', 1723787695);
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('WhgKMg2INgI5j68EQH6HeNhW51yMhewIACp5ersr', 12, '106.219.120.140', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', '[encoded data, 16260 characters]', 1723792924);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `key` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `type`, `key`, `value`) VALUES
(1, 'track_order', 'track_order_title', 'Order tracking'),
(2, 'track_order', 'track_order_subtitle', 'Track every step'),
(3, 'track_order', 'track_page_title', 'Order Tracking'),
(4, 'track_order', 'track_page_description', 'Add your tracking Id'),
(5, 'app_content', 'app_name', 'Become a delivery superhero and start earning'),
(6, 'app_content', 'create_order_description', 'MXunzo\r\nmore than just a reliable e-commerce platform , Delivers within 10 mins\r\nOffers Awaits!'),
(7, 'app_content', 'delivery_man_image', 'https://mxunzo.mimeld.com/storage/172/jjjj.jpeg'),
(8, 'app_content', 'delivery_road_image', 'https://mxunzo.mimeld.com/storage/105/road-(1)-(1).jpg'),
(9, 'app_content', 'app_logo_image', 'https://mxunzo.mimeld.com/storage/168/mxunzo(195-x-45-px).png'),
(10, 'app_content', 'play_store_link', '#'),
(11, 'app_content', 'app_store_link', '#'),
(12, 'why_choose', 'title', 'Delivery from MXUnzo'),
(13, 'why_choose', 'description', 'Delivery with in 15 mins within your area, Fast commerce businesses satisfy a major customer desire: the ability to get what they want, when they want it. And they almost always want “it” immediately.'),
(14, 'client_review', 'client_review_title', 'Customer Review'),
(15, 'terms_condition', 'terms_condition', '<h3>1. Introduction</h3>\r\n<p>Welcome to mxunzo! These Terms and Conditions govern your use of our website and services. By accessing or using our website, you agree to comply with and be bound by these terms. If you disagree with any part of these terms, you may not use our services.</p>\r\n<h3>2. Definitions</h3>\r\n<ul>\r\n<li><strong>\"We,\" \"us,\" \"our,\"</strong> refers to mxunzo.</li>\r\n<li><strong>\"You,\" \"your,\"</strong> refers to the user or viewer of our website.</li>\r\n<li><strong>\"Service(s),\"</strong> refers to all services provided by mxunzo, including booking and salon management.</li>\r\n</ul>\r\n<h3>3. Use of Our Services</h3>\r\n<ul>\r\n<li>You must be at least 18 years old to use our services.</li>\r\n<li>You agree to provide accurate and complete information when using our services.</li>\r\n<li>You are responsible for maintaining the confidentiality of your account information and for all activities that occur under your account.</li>\r\n</ul>\r\n<h3>4. Booking and Payments</h3>\r\n<ul>\r\n<li>All bookings made through mxunzo are subject to availability.</li>\r\n<li>Payment for services must be made at the time of booking, unless otherwise specified.</li>\r\n<li>We reserve the right to cancel or refuse any booking at our discretion.</li>\r\n</ul>\r\n<h3>5. Cancellations and Refunds</h3>\r\n<ul>\r\n<li>Cancellations must be made at least 24 hours in advance to receive a full refund.</li>\r\n<li>No refunds will be issued for cancellations made less than 24 hours before the scheduled appointment.</li>\r\n<li>In case of a no-show, the full amount will be charged.</li>\r\n</ul>\r\n<h3>6. Intellectual Property</h3>\r\n<ul>\r\n<li>All content on mxunzo, including text, graphics, logos, and images, is the property of mxunzo or its content suppliers and is protected by intellectual property laws.</li>\r\n<li>You may not reproduce, distribute, or create derivative works from any content on our website without our explicit permission.</li>\r\n</ul>\r\n<h3>7. User Conduct</h3>\r\n<ul>\r\n<li>You agree not to use our services for any unlawful or prohibited activities.</li>\r\n<li>You must not upload, post, or transmit any material that is offensive, defamatory, or infringes on the rights of others.</li>\r\n</ul>\r\n<h3>8. Limitation of Liability</h3>\r\n<ul>\r\n<li>mxunzo shall not be liable for any indirect, incidental, or consequential damages arising out of your use of our services.</li>\r\n<li>Our total liability to you for any claim arising out of or relating to our services shall not exceed the amount paid by you for the service in question.</li>\r\n</ul>\r\n<h3>9. Changes to Terms and Conditions</h3>\r\n<ul>\r\n<li>We reserve the right to update or modify these terms at any time without prior notice.</li>\r\n<li>Your continued use of our services after any changes indicates your acceptance of the new terms.</li>\r\n</ul>\r\n<h3>10. Contact Information</h3>\r\n<p>If you have any questions or concerns about these terms, please contact us at <a class=\"contact-info__info\" href=\"tel:+919903909333\">+919903909333</a></p>'),
(16, 'privacy_policy', 'privacy_policy', '<h3>1. Introduction</h3>\r\n<p>Welcome to mxunzo! This Privacy Policy explains how we collect, use, disclose, and protect your information when you visit our website and use our services. By accessing or using our website, you agree to the terms of this Privacy Policy.</p>\r\n<h3>2. Information We Collect</h3>\r\n<ul>\r\n<li><strong>Personal Information:</strong> We may collect personal information such as your name, email address, phone number, and payment information when you create an account, book a service, or contact us.</li>\r\n<li><strong>Non-Personal Information:</strong> We may collect non-personal information such as browser type, operating system, and browsing behavior through cookies and other tracking technologies.</li>\r\n</ul>\r\n<h3>3. How We Use Your Information</h3>\r\n<ul>\r\n<li><strong>To Provide Services:</strong> We use your personal information to process bookings, manage accounts, and provide customer support.</li>\r\n<li><strong>To Improve Our Services:</strong> We use non-personal information to analyze website usage, improve our services, and enhance user experience.</li>\r\n<li><strong>Marketing:</strong> With your consent, we may use your information to send promotional materials and updates about our services.</li>\r\n</ul>\r\n<h3>4. Sharing Your Information</h3>\r\n<ul>\r\n<li><strong>Third-Party Service Providers:</strong> We may share your information with third-party service providers who assist us in providing our services, such as payment processors and email marketing platforms.</li>\r\n<li><strong>Legal Requirements:</strong> We may disclose your information if required by law or in response to valid requests by public authorities.</li>\r\n</ul>\r\n<h3>5. Cookies and Tracking Technologies</h3>\r\n<ul>\r\n<li><strong>Cookies:</strong> We use cookies to enhance your browsing experience and analyze website traffic. You can control the use of cookies through your browser settings.</li>\r\n<li><strong>Analytics:</strong> We use third-party analytics services to track and report website traffic.</li>\r\n</ul>\r\n<h3>6. Data Security</h3>\r\n<ul>\r\n<li><strong>Protection Measures:</strong> We implement appropriate security measures to protect your information from unauthorized access, alteration, disclosure, or destruction.</li>\r\n<li><strong>No Guarantee:</strong> While we strive to protect your information, we cannot guarantee its absolute security.</li>\r\n</ul>\r\n<h3>7. Your Rights</h3>\r\n<ul>\r\n<li><strong>Access and Correction:</strong> You have the right to access and correct your personal information.</li>\r\n<li><strong>Opt-Out:</strong> You can opt-out of receiving marketing communications by following the unsubscribe instructions in our emails or contacting us directly.</li>\r\n<li><strong>Deletion:</strong> You have the right to request the deletion of your personal information, subject to certain legal obligations.</li>\r\n</ul>\r\n<h3>8. Children\'s Privacy</h3>\r\n<p>Our services are not intended for individuals under the age of 18. We do not knowingly collect personal information from children. If we become aware that we have collected personal information from a child, we will take steps to delete it.</p>\r\n<h3>9. Changes to This Privacy Policy</h3>\r\n<p>We may update this Privacy Policy from time to time. We will notify you of any changes by posting the new Privacy Policy on our website. Your continued use of our services after any changes indicates your acceptance of the updated Privacy Policy.</p>\r\n<h3>10. Contact Us</h3>\r\n<p>If you have any questions or concerns about this Privacy Policy, please contact us at <a class=\"contact-info__info\" href=\"tel:+919903909333\">+919903909333</a></p>'),
(17, 'download_app', 'download_title', 'All this from the convenience of your phone.'),
(18, 'download_app', 'download_description', 'Download the MXUNZO app now to easily book appointments, receive exclusive offers, and stay updated with the latest trends. Enjoy a seamless salon experience at your fingertips.'),
(19, 'download_app', 'download_footer_content', NULL),
(20, 'download_app', 'download_app_logo', 'https://mxunzo.atharvatek.com/storage/171/MXUNZO-delievery-boy.png'),
(21, 'about_us', 'download_title', 'MXUnzo Food & Groceries delivery app'),
(22, 'about_us', 'download_subtitle', 'Mxunzo provides robust customer support to assist with any issues or inquiries. By saving users time and effort, promoting safety through reduced need for going out, and offering a diverse product range, Mxunzo enhances the convenience and efficiency of daily shopping. Its focus on rapid delivery, extensive variety of products, and excellent customer experience positions it as a strong competitor in the on-demand delivery market.'),
(23, 'about_us', 'long_des', 'ABOUT US'),
(24, 'about_us', 'about_us_app_ss', 'https://mxunzo.atharvatek.com//storage/65/ff.png'),
(25, 'delivery_partner', 'title', 'Join Us, As delivery partner'),
(26, 'delivery_partner', 'subtitle', 'Deliver fast and Earn More'),
(27, 'delivery_partner', 'delivery_partner_image', 'https://mxunzo.atharvatek.com/storage/99/foodora-3402507_640.jpg'),
(28, 'contact_us', 'contact_title', 'Contact MXUNZO'),
(29, 'contact_us', 'contact_subtitle', 'customer care'),
(30, 'contact_us', 'contact_us_app_ss', 'https://mxunzo.atharvatek.com//storage/76/tt-Photoroom.png'),
(31, 'order_invoice', 'company_name', 'MXUNZO'),
(32, 'order_invoice', 'company_contact_number', '+91 9903909333'),
(33, 'order_invoice', 'company_address', 'Global'),
(34, 'order_invoice', 'company_logo', 'https://mxunzo.atharvatek.com/storage/167/mxunzo--(173-x-40-px).png'),
(35, 'mobile_verification', 'mobile_verification', '0'),
(36, 'document_verification', 'document_verification', '0'),
(37, 'email_verification', 'email_verification', '0');

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

--
-- Table structure for table `static_data`
--

CREATE TABLE `static_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `value` varchar(255) 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 `static_data`
--

INSERT INTO `static_data` (`id`, `type`, `label`, `value`, `created_at`, `updated_at`) VALUES
(2, NULL, 'Test Parcel', 'test_parcel', '2024-08-01 07:12:15', '2024-08-01 07:12:15'),
(3, NULL, 'Bags', 'bags', '2024-08-01 09:16:44', '2024-08-01 09:16:44'),
(4, NULL, 'Paper', 'paper', '2024-08-01 09:16:59', '2024-08-01 09:16:59'),
(5, NULL, 'Bubble Wrap', 'bubble_wrap', '2024-08-01 09:17:05', '2024-08-01 09:17:05'),
(6, NULL, 'Cartons', 'cartons', '2024-08-01 09:17:18', '2024-08-01 09:17:18'),
(7, NULL, 'Plastic', 'plastic', '2024-08-01 09:17:25', '2024-08-01 09:17:25'),
(8, NULL, 'Plastic containers', 'plastic_containers', '2024-08-01 09:17:33', '2024-08-01 09:17:33'),
(9, NULL, 'Pouches', 'pouches', '2024-08-01 09:17:40', '2024-08-01 09:17:40'),
(10, NULL, 'Shrink wrap', 'shrink_wrap', '2024-08-01 09:17:47', '2024-08-01 09:17:47'),
(11, NULL, 'Grocery', 'grocery', '2024-08-14 07:56:44', '2024-08-14 07:56:44');

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `storeowner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_name` varchar(255) DEFAULT NULL,
  `contact_number` varchar(255) DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `description` longtext 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 `store_items`
--

CREATE TABLE `store_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `total_amount` double NOT NULL DEFAULT 0,
  `quantity` double 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 `store_manages`
--

CREATE TABLE `store_manages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `storetype_id` longtext DEFAULT NULL,
  `storeowner_id` bigint(20) 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 `store_types`
--

CREATE TABLE `store_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `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 `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `storeowner_id` bigint(20) UNSIGNED 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;

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

--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `address_type` text DEFAULT NULL,
  `contact_number` varchar(255) 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 `user_addresses`
--

INSERT INTO `user_addresses` (`id`, `user_id`, `country_id`, `city_id`, `address`, `latitude`, `longitude`, `address_type`, `contact_number`, `created_at`, `updated_at`) VALUES
(2, 12, NULL, NULL, 'Mumbai', NULL, NULL, NULL, '+911234567890', '2024-08-12 04:24:23', '2024-08-12 04:24:23'),
(3, 16, 1, 1, '1600 Amphitheatre Pkwy Building 43, Mountain View, CA 94043, USA', '37.4215304', '-122.0840833', NULL, '+91 3214567899', '2024-08-12 08:32:26', '2024-08-12 08:32:26'),
(4, 16, 1, 1, '1600 Amphitheatre Pkwy Building 43, Mountain View, CA 94043, USA', '37.4215304', '-122.0840833', NULL, '+91 1234567890', '2024-08-12 08:33:00', '2024-08-12 08:33:00'),
(5, 12, NULL, NULL, '324,Local heights , Richard street , Royal nagar , Mumbai', NULL, NULL, NULL, '+917352526733', '2024-08-14 07:17:52', '2024-08-14 07:17:52'),
(6, 12, NULL, NULL, 'WW street , house 12 , bandra west , mumbai', NULL, NULL, NULL, '+917896541230', '2024-08-16 02:24:09', '2024-08-16 02:24:09');

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

--
-- Table structure for table `user_favourite_stores`
--

CREATE TABLE `user_favourite_stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_detail_id` bigint(20) 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 `vehicles`
--

CREATE TABLE `vehicles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL COMMENT 'all,city_wise',
  `size` varchar(255) DEFAULT NULL,
  `city_ids` text DEFAULT NULL,
  `capacity` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `description` text DEFAULT NULL,
  `price` double DEFAULT 0,
  `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 `vehicles`
--

INSERT INTO `vehicles` (`id`, `title`, `type`, `size`, `city_ids`, `capacity`, `status`, `description`, `price`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Bike', 'city_wise', '1500cc', '[\"1\"]', '1500cc', 1, 'This is a bike test description', 1000, '2024-08-01 04:09:28', '2024-08-01 04:09:28', NULL),
(2, 'Violet Colon', 'all', 'Quam sit sequi asper', 'null', 'Ab quo consequatur', 1, 'Quas voluptas obcaec', 863, '2024-08-01 09:11:55', '2024-08-01 09:11:55', NULL),
(3, 'Ishmael Riggs', 'all', 'Id molestias et at', 'null', 'Quae saepe totam et', 1, 'Libero esse consequ', 628, '2024-08-01 09:12:12', '2024-08-01 09:12:12', NULL),
(4, 'Peter Townsend', 'city_wise', 'Laborum Nostrud dol', '[\"3\"]', 'Incidunt aspernatur', 1, 'Porro duis et conseq', 241, '2024-08-01 09:12:27', '2024-08-01 09:12:27', NULL),
(5, 'Jason Fuller', 'city_wise', 'Ut tempor libero sun', '[\"2\",\"1\",\"3\",\"4\",\"5\"]', 'Nisi delectus magna', 1, 'Assumenda aute odit', 43, '2024-08-01 09:12:59', '2024-08-01 09:12:59', NULL),
(6, 'Bert Owen', 'city_wise', 'Impedit exercitatio', '[\"3\",\"2\",\"5\"]', 'Iusto tempore magna', 1, 'Praesentium magna vo', 691, '2024-08-01 09:13:20', '2024-08-01 09:13:20', NULL),
(8, 'Mangesh', 'all', '1.5', 'null', '6', 1, 'Super car', 1234, '2024-08-16 03:18:35', '2024-08-16 03:18:35', NULL);

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

--
-- Table structure for table `verification_codes`
--

CREATE TABLE `verification_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `datetime` datetime 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 `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `total_amount` double DEFAULT 0,
  `online_received` double DEFAULT 0,
  `collected_cash` double DEFAULT 0,
  `manual_received` double DEFAULT 0,
  `total_withdrawn` double DEFAULT 0,
  `currency` varchar(255) 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 `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `total_amount`, `online_received`, `collected_cash`, `manual_received`, `total_withdrawn`, `currency`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 12, -10000, 0, 0, 0, 0, 'usd', '2024-08-12 04:21:32', '2024-08-12 04:21:32', NULL);

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

--
-- Table structure for table `wallet_histories`
--

CREATE TABLE `wallet_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL COMMENT 'credit,debit',
  `transaction_type` varchar(255) DEFAULT NULL COMMENT 'topup,withdraw,order_fee,admin_commision,correction',
  `currency` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT 0,
  `balance` double DEFAULT 0,
  `datetime` datetime DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text DEFAULT NULL,
  `data` text 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 `wallet_histories`
--

INSERT INTO `wallet_histories` (`id`, `user_id`, `type`, `transaction_type`, `currency`, `amount`, `balance`, `datetime`, `order_id`, `description`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 12, 'debit', 'correction', NULL, 10000, -10000, '2024-08-12 06:21:32', NULL, NULL, NULL, '2024-08-12 04:21:32', '2024-08-12 04:21:32', NULL);

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

--
-- Table structure for table `withdraw_requests`
--

CREATE TABLE `withdraw_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double DEFAULT 0,
  `currency` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT 'requested' COMMENT 'requested,approved,decline',
  `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;

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

--
-- Table structure for table `work_hour_manages`
--

CREATE TABLE `work_hour_manages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `storeowner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_detail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `day` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 0,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Indexes for table `delivery_man_documents`
--
ALTER TABLE `delivery_man_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `delivery_man_documents_document_id_foreign` (`document_id`),
  ADD KEY `delivery_man_documents_delivery_man_id_foreign` (`delivery_man_id`);

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- Indexes for table `language_lists`
--
ALTER TABLE `language_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language_lists_language_id_foreign` (`language_id`);

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

--
-- Indexes for table `language_with_keywords`
--
ALTER TABLE `language_with_keywords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language_with_keywords_language_id_foreign` (`language_id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

--
-- 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_id_model_type_index` (`model_id`,`model_type`);

--
-- 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_id_model_type_index` (`model_id`,`model_type`);

--
-- 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 `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_client_id_foreign` (`client_id`);

--
-- Indexes for table `order_histories`
--
ALTER TABLE `order_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_histories_order_id_foreign` (`order_id`);

--
-- Indexes for table `order_item_mappings`
--
ALTER TABLE `order_item_mappings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_item_mappings_order_id_foreign` (`order_id`);

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_client_id_foreign` (`client_id`),
  ADD KEY `payments_order_id_foreign` (`order_id`);

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_storeowner_id_foreign` (`storeowner_id`),
  ADD KEY `products_subcategory_id_foreign` (`subcategory_id`),
  ADD KEY `products_storetype_id_foreign` (`storetype_id`),
  ADD KEY `products_store_detail_id_foreign` (`store_detail_id`);

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

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ratings_store_detail_id_foreign` (`store_detail_id`),
  ADD KEY `ratings_user_id_foreign` (`user_id`),
  ADD KEY `ratings_order_id_foreign` (`order_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- 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 `screens`
--
ALTER TABLE `screens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

--
-- Indexes for table `stores`
--
ALTER TABLE `stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stores_storeowner_id_foreign` (`storeowner_id`),
  ADD KEY `stores_country_id_foreign` (`country_id`),
  ADD KEY `stores_city_id_foreign` (`city_id`);

--
-- Indexes for table `store_items`
--
ALTER TABLE `store_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_items_order_id_foreign` (`order_id`),
  ADD KEY `store_items_product_id_foreign` (`product_id`);

--
-- Indexes for table `store_manages`
--
ALTER TABLE `store_manages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_manages_storeowner_id_foreign` (`storeowner_id`);

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_categories_category_id_foreign` (`category_id`);

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

--
-- Indexes for table `user_favourite_stores`
--
ALTER TABLE `user_favourite_stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_favourite_stores_user_id_foreign` (`user_id`),
  ADD KEY `user_favourite_stores_store_detail_id_foreign` (`store_detail_id`);

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

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

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

--
-- Indexes for table `wallet_histories`
--
ALTER TABLE `wallet_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallet_histories_user_id_foreign` (`user_id`),
  ADD KEY `wallet_histories_order_id_foreign` (`order_id`);

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

--
-- Indexes for table `work_hour_manages`
--
ALTER TABLE `work_hour_manages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `work_hour_manages_storeowner_id_foreign` (`storeowner_id`),
  ADD KEY `work_hour_manages_store_detail_id_foreign` (`store_detail_id`);

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `default_keywords`
--
ALTER TABLE `default_keywords`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=412;

--
-- AUTO_INCREMENT for table `delivery_man_documents`
--
ALTER TABLE `delivery_man_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extra_charges`
--
ALTER TABLE `extra_charges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frontend_data`
--
ALTER TABLE `frontend_data`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `language_default_lists`
--
ALTER TABLE `language_default_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=279;

--
-- AUTO_INCREMENT for table `language_lists`
--
ALTER TABLE `language_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `language_version_details`
--
ALTER TABLE `language_version_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `language_with_keywords`
--
ALTER TABLE `language_with_keywords`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=186;

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

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `order_histories`
--
ALTER TABLE `order_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `order_item_mappings`
--
ALTER TABLE `order_item_mappings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `push_notifications`
--
ALTER TABLE `push_notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `screens`
--
ALTER TABLE `screens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `static_data`
--
ALTER TABLE `static_data`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `stores`
--
ALTER TABLE `stores`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `store_items`
--
ALTER TABLE `store_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `store_manages`
--
ALTER TABLE `store_manages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `store_types`
--
ALTER TABLE `store_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_addresses`
--
ALTER TABLE `user_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `user_favourite_stores`
--
ALTER TABLE `user_favourite_stores`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `verification_codes`
--
ALTER TABLE `verification_codes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wallet_histories`
--
ALTER TABLE `wallet_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `withdraw_requests`
--
ALTER TABLE `withdraw_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_hour_manages`
--
ALTER TABLE `work_hour_manages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `delivery_man_documents`
--
ALTER TABLE `delivery_man_documents`
  ADD CONSTRAINT `delivery_man_documents_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_man_documents_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `language_lists`
--
ALTER TABLE `language_lists`
  ADD CONSTRAINT `language_lists_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `language_default_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `language_with_keywords`
--
ALTER TABLE `language_with_keywords`
  ADD CONSTRAINT `language_with_keywords_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `language_lists` (`id`) ON DELETE 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 `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_histories`
--
ALTER TABLE `order_histories`
  ADD CONSTRAINT `order_histories_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_item_mappings`
--
ALTER TABLE `order_item_mappings`
  ADD CONSTRAINT `order_item_mappings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_store_detail_id_foreign` FOREIGN KEY (`store_detail_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_storeowner_id_foreign` FOREIGN KEY (`storeowner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_storetype_id_foreign` FOREIGN KEY (`storetype_id`) REFERENCES `store_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ratings`
--
ALTER TABLE `ratings`
  ADD CONSTRAINT `ratings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ratings_store_detail_id_foreign` FOREIGN KEY (`store_detail_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ratings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE 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 `stores`
--
ALTER TABLE `stores`
  ADD CONSTRAINT `stores_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stores_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stores_storeowner_id_foreign` FOREIGN KEY (`storeowner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `store_items`
--
ALTER TABLE `store_items`
  ADD CONSTRAINT `store_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `store_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `store_manages`
--
ALTER TABLE `store_manages`
  ADD CONSTRAINT `store_manages_storeowner_id_foreign` FOREIGN KEY (`storeowner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `sub_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `user_favourite_stores`
--
ALTER TABLE `user_favourite_stores`
  ADD CONSTRAINT `user_favourite_stores_store_detail_id_foreign` FOREIGN KEY (`store_detail_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_favourite_stores_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `wallet_histories`
--
ALTER TABLE `wallet_histories`
  ADD CONSTRAINT `wallet_histories_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wallet_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `work_hour_manages`
--
ALTER TABLE `work_hour_manages`
  ADD CONSTRAINT `work_hour_manages_store_detail_id_foreign` FOREIGN KEY (`store_detail_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `work_hour_manages_storeowner_id_foreign` FOREIGN KEY (`storeowner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

