-- Table structure for table `product_sessions`
--

CREATE TABLE `product_sessions` (
  `id` bigint UNSIGNED NOT NULL,
  `user1_id` int UNSIGNED NOT NULL,
  `vendor_id` int UNSIGNED NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `block` tinyint(1) NOT NULL DEFAULT '0',
  `blocked_by` int UNSIGNED DEFAULT NULL,
  `dashboard_read_at` date DEFAULT NULL,
  `customer_dashboard_read_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sessions`
--

INSERT INTO `product_sessions` (`id`, `user1_id`, `vendor_id`, `type`, `product_id`, `block`, `blocked_by`, `dashboard_read_at`, `customer_dashboard_read_at`, `created_at`, `updated_at`) VALUES
(1, 2, 3, NULL, 5, 0, NULL, '2023-07-31', '2023-05-20', '2023-05-15 15:20:37', '2023-07-31 16:07:54'),
(2, 20, 3, NULL, 3, 0, NULL, '2023-07-31', '2023-06-01', '2023-05-19 16:31:07', '2023-07-31 16:07:54'),
(3, 33, 3, NULL, 1, 0, NULL, '2023-07-31', '2023-05-25', '2023-05-25 19:23:37', '2023-07-31 16:07:54'),
(4, 33, 3, NULL, 3, 0, NULL, '2023-07-31', '2023-05-25', '2023-05-25 19:24:34', '2023-07-31 16:07:54'),
(5, 33, 16, NULL, 7, 0, NULL, NULL, NULL, '2023-05-25 19:28:45', '2023-05-25 19:28:45'),
(6, 194, 3, NULL, 5, 0, NULL, '2023-07-31', '2023-06-19', '2023-06-15 21:06:14', '2023-07-31 16:07:54'),
(7, 194, 16, NULL, 7, 0, NULL, NULL, '2023-06-19', '2023-06-15 21:50:59', '2023-06-19 16:37:05'),
(8, 194, 3, NULL, 3, 0, NULL, '2023-07-31', '2023-06-19', '2023-06-19 16:14:24', '2023-07-31 16:07:54'),
(9, 195, 3, NULL, 8, 0, NULL, '2023-07-31', NULL, '2023-06-19 18:50:57', '2023-07-31 16:07:54'),
(10, 20, 3, NULL, 8, 0, NULL, '2023-07-31', NULL, '2023-06-21 14:08:57', '2023-07-31 16:07:54'),
(11, 194, 3, NULL, 8, 0, NULL, '2023-07-31', '2023-06-23', '2023-06-23 16:08:15', '2023-07-31 16:07:54'),
(12, 194, 3, NULL, 19, 0, NULL, '2023-07-31', '2023-07-05', '2023-06-26 21:57:22', '2023-07-31 16:07:54'),
(13, 194, 3, NULL, 1, 0, NULL, '2023-07-31', '2023-07-05', '2023-07-01 19:55:57', '2023-07-31 16:07:54'),
(14, 194, 3, NULL, 13, 0, NULL, '2023-07-31', NULL, '2023-07-05 20:57:23', '2023-07-31 16:07:54'),
(15, 203, 3, NULL, 18, 0, NULL, '2023-07-31', NULL, '2023-07-07 03:07:56', '2023-07-31 16:07:54'),
(16, 203, 3, NULL, 34, 0, NULL, '2023-07-31', NULL, '2023-07-07 23:15:06', '2023-07-31 16:07:54'),
(17, 20, 3, NULL, 74, 0, NULL, NULL, NULL, '2023-08-02 19:28:56', '2023-08-02 19:28:56'),
(18, 13, 3, NULL, 79, 0, NULL, NULL, '2023-08-31', '2023-08-05 16:33:28', '2023-08-31 19:06:16'),
(19, 13, 3, NULL, 78, 0, NULL, NULL, '2023-08-31', '2023-08-05 17:26:48', '2023-08-31 19:06:16'),
(20, 2, 3, NULL, 108, 0, NULL, NULL, NULL, '2024-07-18 05:00:05', '2024-07-18 05:00:05');

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

--
-- Table structure for table `refund_requests`
--

CREATE TABLE `refund_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Pending','Complete') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `transaction_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refund_requests`
--

INSERT INTO `refund_requests` (`id`, `order_id`, `user_id`, `item_id`, `order_type`, `amount`, `status`, `transaction_id`, `transaction_method`, `created_at`, `updated_at`) VALUES
(1, '539', '194', '641', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-07 22:14:20', '2023-10-07 22:14:20'),
(2, '540', '194', '642', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-07 22:28:45', '2023-10-07 22:28:45'),
(3, '541', '194', '644', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-07 22:37:24', '2023-10-07 22:37:24'),
(4, '542', '194', '645', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-09 15:06:49', '2023-10-09 15:06:49'),
(5, '544', '194', '647', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-09 15:14:46', '2023-10-09 15:14:46'),
(6, '543', '194', '646', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-09 15:18:05', '2023-10-09 15:18:05'),
(7, '545', '194', '648', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-09 15:22:17', '2023-10-09 15:22:17'),
(8, '546', '194', '649', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-09 16:22:15', '2023-10-09 16:22:15'),
(9, '557', '259', '664', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-13 17:09:01', '2023-10-13 17:09:01'),
(10, '558', '259', '665', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-13 21:33:09', '2023-10-13 21:33:09'),
(11, '588', '259', '696', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-14 20:27:40', '2023-10-14 20:27:40'),
(12, '553', '259', '657', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-14 20:28:28', '2023-10-14 20:28:28'),
(13, '553', '259', '658', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-14 20:28:28', '2023-10-14 20:28:28'),
(14, '594', '269', '706', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-17 17:27:46', '2023-10-17 17:27:46'),
(15, '596', '268', '713', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-17 21:52:15', '2023-10-17 21:52:15'),
(16, '597', '194', '714', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-17 22:12:10', '2023-10-17 22:12:10'),
(17, '598', '194', '715', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-17 22:29:09', '2023-10-17 22:29:09'),
(18, '593', '267', '705', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-18 14:21:47', '2023-10-18 14:21:47'),
(19, '601', '267', '719', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-18 14:28:48', '2023-10-18 14:28:48'),
(20, '642', '259', '768', 'Cancel', NULL, 'Pending', NULL, NULL, '2023-10-18 21:31:28', '2023-10-18 21:31:28');

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

--
-- Table structure for table `requirements`
--

CREATE TABLE `requirements` (
  `id` bigint UNSIGNED NOT NULL,
  `cat_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `dashboard_read_at` date 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 UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_super` tinyint NOT NULL DEFAULT '0' COMMENT '0-No,1-Yes',
  `is_admin` tinyint NOT NULL DEFAULT '0' COMMENT '0-No,1-Yes',
  `is_default` tinyint NOT NULL DEFAULT '0' COMMENT '0-No,1-Yes',
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `title`, `description`, `is_super`, `is_admin`, `is_default`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super-admin', 'Super Admin', 'Super Admin Role', 1, 1, 1, 'web', '2021-01-11 01:37:02', '2021-01-11 01:37:02'),
(2, 'admin', 'Admin', 'Admin Role', 0, 1, 1, 'web', '2021-01-11 01:37:02', '2021-01-11 01:37:02'),
(3, 'vendor', 'Vendor', 'Vendor Role', 0, 0, 1, 'web', '2021-01-11 01:37:02', '2021-01-11 01:37:02'),
(4, 'customer', 'Customer', 'Customers Role', 0, 0, 1, 'web', '2021-01-11 01:37:02', '2021-01-11 01:37:02');

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

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

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

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

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

CREATE TABLE `sessions` (
  `id` int UNSIGNED NOT NULL,
  `user1_id` int UNSIGNED NOT NULL,
  `user2_id` int UNSIGNED NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `block` tinyint(1) NOT NULL DEFAULT '0',
  `blocked_by` int UNSIGNED DEFAULT NULL,
  `dashboard_read_at` date DEFAULT NULL,
  `customer_dashboard_read_at` date 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 `sessions`
--

INSERT INTO `sessions` (`id`, `user1_id`, `user2_id`, `type`, `block`, `blocked_by`, `dashboard_read_at`, `customer_dashboard_read_at`, `created_at`, `updated_at`) VALUES
(1, 197, 1, NULL, 0, NULL, NULL, NULL, '2023-09-09 16:07:03', '2023-09-09 16:07:03'),
(2, 13, 1, NULL, 0, NULL, NULL, NULL, '2023-09-26 15:56:45', '2023-09-26 15:56:45'),
(3, 3, 1, NULL, 0, NULL, NULL, NULL, '2023-10-26 23:02:39', '2023-10-26 23:02:39'),
(4, 229, 1, NULL, 0, NULL, NULL, NULL, '2024-07-15 00:32:50', '2024-07-15 00:32:50');

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

--
-- Table structure for table `shipments`
--

CREATE TABLE `shipments` (
  `id` bigint UNSIGNED NOT NULL,
  `shipment_master_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `courier_data` json DEFAULT NULL,
  `product_data` json DEFAULT NULL,
  `request_response` json DEFAULT NULL,
  `response` json DEFAULT NULL,
  `shipment_status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipments`
--

INSERT INTO `shipments` (`id`, `shipment_master_id`, `order_id`, `status`, `tracking_number`, `delivery_date`, `amount`, `label_url`, `courier_data`, `product_data`, `request_response`, `response`, `shipment_status`, `created_at`, `updated_at`) VALUES
(1, NULL, 5, 'Processing', 'X84154037', NULL, '67.3', NULL, '{\"id\": 334311604, \"cod\": 1, \"edd\": \"\", \"etd\": \"Jul 23, 2023\", \"city\": \"UDAIPUR\", \"cost\": \"\", \"mode\": 1, \"rank\": \"\", \"rate\": 100, \"zone\": \"z_a\", \"metro\": 0, \"state\": \"RAJASTHAN\", \"others\": \"{\\\"cancel_real_time\\\": true}\", \"rating\": 4.2, \"region\": 1, \"blocked\": 0, \"odablock\": false, \"postcode\": \"313001\", \"entry_tax\": 0, \"etd_hours\": 59, \"ship_type\": 1, \"is_surface\": false, \"min_weight\": 0.5, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 32.7, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 76.4, \"courier_name\": \"DTDC 500GMS\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.5, \"charge_weight\": 1, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"On Request\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"32.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 67.3, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 5, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 196, \"pickup_performance\": 4.4, \"surface_max_weight\": \"0.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Not Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 5, \"pickup_supress_hours\": 0, \"tracking_performance\": 2.2, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"3\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"1\", \"length\": \"2\", \"weight\": \"1\", \"breadth\": \"2\", \"order_total\": 550, \"chargeable_weight\": 10, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Iphone 14\", \"height\": 1, \"length\": 1, \"weight\": 10, \"breadth\": 1}]}', '{\"order_data\": {\"height\": \"1\", \"length\": \"2\", \"weight\": \"1\", \"breadth\": \"2\", \"comment\": \"\", \"order_id\": \"55878692\", \"sub_total\": 550, \"channel_id\": \"\", \"order_date\": \"2023-07-20\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"Iphone 14\", \"tax\": \"\", \"name\": \"Iphone 14\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Udaipur\", \"billing_email\": \"yesh123@gmail.com\", \"billing_phone\": \"7897894561\", \"billing_state\": \"rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"Prepaid\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Ashok Nagar\", \"billing_country\": \"india\", \"billing_pincode\": \"313001\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Ashok Nagar\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"yogesh\", \"shipping_customer_name\": \"\"}, \"shipment_request_data\": {\"courier_id\": 196, \"shipment_id\": 376666190}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 377300330, \"shipment_id\": 376666190, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}, \"shipment_data\": {\"response\": {\"data\": {\"cod\": 0, \"awb_code\": \"X84154037\", \"order_id\": 377300330, \"company_id\": 3486923, \"invoice_no\": \"Retail00068\", \"shipped_by\": {\"lat\": null, \"long\": null, \"rto_city\": \"udaipur\", \"rto_email\": \"test.vendor@gmail.com\", \"rto_phone\": \"8094364617\", \"rto_state\": \"raj\", \"extra_info\": {\"source\": 3, \"boat_delhivery_clientware_id\": \"BOAT SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_trent_clientware_id\": \"kartrocket-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_clientware_id\": \"IDAM SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_zomato_2kg_clientware_id\": \"ZOMATO SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_2kg_clientware_id\": \"IDAM SR 2KG-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_5kg_clientware_id\": \"IDAM SR 5KG-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_documents_2kg_clientware_id\": \"SHIPROCKET-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_secured_documents_clientware_id\": \"SHIPROCKET-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\"}, \"rto_country\": \"india\", \"rto_postcode\": \"313001\", \"shipper_city\": \"udaipur\", \"rto_address_1\": \"flat no 42\", \"rto_address_2\": \"udaipur ambamata\", \"shipper_email\": \"test.vendor@gmail.com\", \"shipper_phone\": \"8094364617\", \"shipper_state\": \"raj\", \"shipper_country\": \"india\", \"rto_company_name\": \"test vendor\", \"shipper_postcode\": \"313001\", \"shipper_address_1\": \"flat no 42\", \"shipper_address_2\": \"udaipur ambamata\", \"shipper_company_name\": \"test vendor\", \"shipper_first_mile_activated\": 0}, \"shipment_id\": 376666190, \"courier_name\": \"DTDC 500GMS\", \"applied_weight\": 1, \"transporter_id\": \"88AAACD8017H1ZX\", \"awb_code_status\": 1, \"freight_charges\": 67.3, \"transporter_name\": \"\", \"assigned_date_time\": {\"date\": \"2023-07-20 19:22:29.000000\", \"timezone\": \"Asia/Kolkata\", \"timezone_type\": 3}, \"child_courier_name\": null, \"courier_company_id\": 196}}, \"quick_pick\": 0, \"no_pickup_popup\": 0, \"awb_assign_status\": 1}}', 'pickup_created', '2023-07-20 23:22:18', '2023-07-20 23:22:41'),
(2, NULL, 6, 'Cancelled', '624003178', NULL, '128.96', NULL, '{\"id\": 333405117, \"cod\": 1, \"edd\": \"\", \"etd\": \"Jul 23, 2023\", \"city\": \"UDAIPUR RJ\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 174.34, \"zone\": \"z_a\", \"metro\": 0, \"state\": \"Rajasthan\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 3.4, \"region\": 1, \"blocked\": 0, \"odablock\": false, \"postcode\": \"313001\", \"entry_tax\": 0, \"etd_hours\": 55, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 2, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 45.38, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 166.08, \"courier_name\": \"Ecom Express Surface 2kg\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.5, \"charge_weight\": 3.888, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 128.96, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 2.5, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 19, \"pickup_performance\": 3.8, \"surface_max_weight\": \"30.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 2.5, \"pickup_supress_hours\": 0, \"tracking_performance\": 5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"3\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"24\", \"length\": \"30\", \"weight\": \"1\", \"breadth\": \"27\", \"order_total\": 1652.9, \"chargeable_weight\": 4, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Blue jeans\", \"height\": 13, \"length\": 15, \"weight\": 2, \"breadth\": 14}, {\"qty\": 1, \"name\": \"Men\'s Hoodies\", \"height\": 11, \"length\": 15, \"weight\": 4, \"breadth\": 13}]}', '{\"order_data\": {\"height\": \"24\", \"length\": \"30\", \"weight\": \"1\", \"breadth\": \"27\", \"comment\": \"\", \"order_id\": \"66049600\", \"sub_total\": 1652.9, \"channel_id\": \"\", \"order_date\": \"2023-07-20\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"Men\'s Hoodies\", \"tax\": \"\", \"name\": \"Men\'s Hoodies\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Udaipur\", \"billing_email\": \"yesh123@gmail.com\", \"billing_phone\": \"7897894561\", \"billing_state\": \"rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"Prepaid\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Ashok Nagar\", \"billing_country\": \"india\", \"billing_pincode\": \"313001\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Ashok Nagar\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"yogesh\", \"shipping_customer_name\": \"\"}, \"shipment_request_data\": {\"courier_id\": 19, \"shipment_id\": 376669887}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 377304027, \"shipment_id\": 376669887, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}, \"shipment_data\": {\"response\": {\"data\": {\"cod\": 0, \"awb_code\": \"624003178\", \"order_id\": 377304027, \"company_id\": 3486923, \"invoice_no\": \"Retail00069\", \"shipped_by\": {\"lat\": null, \"long\": null, \"rto_city\": \"udaipur\", \"rto_email\": \"test.vendor@gmail.com\", \"rto_phone\": \"8094364617\", \"rto_state\": \"raj\", \"extra_info\": {\"source\": 3, \"boat_delhivery_clientware_id\": \"BOAT SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_trent_clientware_id\": \"kartrocket-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_clientware_id\": \"IDAM SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_zomato_2kg_clientware_id\": \"ZOMATO SR SURFACE-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_2kg_clientware_id\": \"IDAM SR 2KG-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_bellavita_5kg_clientware_id\": \"IDAM SR 5KG-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_documents_2kg_clientware_id\": \"SHIPROCKET-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\", \"delhivery_secured_documents_clientware_id\": \"SHIPROCKET-udaipur-313001-Courv Innovations Private Limited-3486923-3892642\"}, \"rto_country\": \"india\", \"rto_postcode\": \"313001\", \"shipper_city\": \"udaipur\", \"rto_address_1\": \"flat no 42\", \"rto_address_2\": \"udaipur ambamata\", \"shipper_email\": \"test.vendor@gmail.com\", \"shipper_phone\": \"8094364617\", \"shipper_state\": \"raj\", \"shipper_country\": \"india\", \"rto_company_name\": \"test vendor\", \"shipper_postcode\": \"313001\", \"shipper_address_1\": \"flat no 42\", \"shipper_address_2\": \"udaipur ambamata\", \"shipper_company_name\": \"test vendor\", \"shipper_first_mile_activated\": 0}, \"shipment_id\": 376669887, \"courier_name\": \"Ecom Express Surface 2kg\", \"applied_weight\": 3.888, \"transporter_id\": \"07AADCE1344F1Z2\", \"awb_code_status\": 1, \"freight_charges\": 128.96, \"transporter_name\": \"Ecom Express\", \"assigned_date_time\": {\"date\": \"2023-07-20 19:33:57.000000\", \"timezone\": \"Asia/Kolkata\", \"timezone_type\": 3}, \"child_courier_name\": null, \"courier_company_id\": 19}}, \"quick_pick\": 0, \"no_pickup_popup\": 0, \"awb_assign_status\": 1}}', 'pickup_created', '2023-07-20 23:33:46', '2023-07-21 13:55:01'),
(4, '4', 300, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-08-01 19:59:32', '2023-08-01 19:59:32'),
(5, '2', 327, 'Cancelled', '14344985140376', NULL, '64', 'https://xb-files.s3.amazonaws.com/labels/20230801195935-24.pdf', '{\"id\": \"1\", \"name\": \"Surface Xpressbees 0.5 K.G\", \"min_weight\": 500, \"cod_charges\": 32, \"total_charges\": 64, \"freight_charges\": 32, \"chargeable_weight\": 500}', '{\"height\": \"2\", \"length\": \"2\", \"weight\": \"20\", \"breadth\": \"2\", \"order_total\": 550, \"chargeable_weight\": 20, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"Iphone 14\", \"height\": 2, \"length\": 2, \"weight\": 20, \"breadth\": 2}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"Udaipur\", \"name\": \"ramesh\", \"phone\": \"3214569870\", \"state\": \"rajasthan\", \"address\": \"Ashok Nagar\", \"pincode\": \"313001\", \"address_2\": \"Ashok Nagar\"}, \"courier_id\": \"1\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 1, \"sku\": \"Iphone 14\", \"name\": \"Iphone 14\", \"price\": 5}], \"order_amount\": \"1100\", \"order_number\": \"3278431550\", \"payment_type\": \"cod\", \"package_height\": \"2\", \"package_length\": \"2\", \"package_weight\": \"20\", \"package_breadth\": \"2\", \"shipping_charges\": 0, \"collectable_amount\": \"1100\", \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230801195935-24.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230801195935-26.pdf\", \"order_id\": 13642055, \"awb_number\": \"14344985140376\", \"courier_id\": \"1\", \"shipment_id\": 7076499, \"courier_name\": \"Surface Xpressbees 0.5 K.G\", \"payment_type\": \"cod\", \"additional_info\": \"\", \"fwd_destination_code\": \"N/S-18/1A/001\"}, \"status\": true}}', 'shipment_created', '2023-08-01 23:56:10', '2023-08-01 23:59:46'),
(7, '2', 337, 'Cancelled', '152489881342462', NULL, '89', 'https://xb-files.s3.amazonaws.com/labels/20230802113705-56.pdf', '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 32, \"total_charges\": 89, \"freight_charges\": 57, \"chargeable_weight\": 1000}', '{\"height\": \"13\", \"length\": \"15\", \"weight\": \"2\", \"breadth\": \"14\", \"order_total\": 11.2, \"chargeable_weight\": 2, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Blue jeans\", \"height\": 13, \"length\": 15, \"weight\": 2, \"breadth\": 14}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"ud\", \"name\": \"abcd\", \"phone\": \"1231231231\", \"state\": \"rj\", \"address\": \"101,asfsf\", \"pincode\": \"313002\", \"address_2\": \"101,asfsf\"}, \"courier_id\": \"12298\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 1, \"sku\": \"Blue jeans\", \"name\": \"Blue jeans\", \"price\": 5}], \"order_amount\": \"111\", \"order_number\": \"3377238926\", \"payment_type\": \"prepaid\", \"package_height\": \"13\", \"package_length\": \"15\", \"package_weight\": \"2\", \"package_breadth\": \"14\", \"shipping_charges\": 0, \"collectable_amount\": 0, \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230802113705-56.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230802113705-62.pdf\", \"order_id\": 13657144, \"awb_number\": \"152489881342462\", \"courier_id\": \"12298\", \"shipment_id\": 7083819, \"courier_name\": \"Xpressbees 1 K.G\", \"payment_type\": \"prepaid\", \"additional_info\": \"\", \"fwd_destination_code\": \"\"}, \"status\": true}}', 'shipment_created', '2023-08-02 15:29:09', '2023-08-02 15:37:38'),
(8, '2', 338, 'Cancelled', '152489881342464', NULL, '89', 'https://xb-files.s3.amazonaws.com/labels/20230802113908-84.pdf', '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 32, \"total_charges\": 89, \"freight_charges\": 57, \"chargeable_weight\": 1000}', '{\"height\": \"11\", \"length\": \"18\", \"weight\": \"3\", \"breadth\": \"19\", \"order_total\": 1356, \"chargeable_weight\": 3, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"height\": 11, \"length\": 18, \"weight\": 3, \"breadth\": 19}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"ud\", \"name\": \"abcd\", \"phone\": \"1231231231\", \"state\": \"rj\", \"address\": \"101,asfsf\", \"pincode\": \"313002\", \"address_2\": \"101,asfsf\"}, \"courier_id\": \"12298\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 1, \"sku\": \"Rimo Navy Organic Cotton Sweatshirt\", \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"price\": 5}], \"order_amount\": 1936, \"order_number\": \"3384067272\", \"payment_type\": \"cod\", \"package_height\": \"11\", \"package_length\": \"18\", \"package_weight\": \"3\", \"package_breadth\": \"19\", \"shipping_charges\": 0, \"collectable_amount\": 1936, \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230802113908-84.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230802113908-13.pdf\", \"order_id\": 13657200, \"awb_number\": \"152489881342464\", \"courier_id\": \"12298\", \"shipment_id\": 7083907, \"courier_name\": \"Xpressbees 1 K.G\", \"payment_type\": \"cod\", \"additional_info\": \"\", \"fwd_destination_code\": \"\"}, \"status\": true}}', 'shipment_created', '2023-08-02 15:38:46', '2023-08-02 15:40:10'),
(9, '2', 339, 'Cancelled', '152489881342474', NULL, '89', 'https://xb-files.s3.amazonaws.com/labels/20230802114258-36.pdf', '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 32, \"total_charges\": 89, \"freight_charges\": 57, \"chargeable_weight\": 1000}', '{\"height\": \"11\", \"length\": \"18\", \"weight\": \"3\", \"breadth\": \"19\", \"order_total\": 1356, \"chargeable_weight\": 3, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"height\": 11, \"length\": 18, \"weight\": 3, \"breadth\": 19}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"ud\", \"name\": \"abcd\", \"phone\": \"1231231231\", \"state\": \"rj\", \"address\": \"101,asfsf\", \"pincode\": \"313002\", \"address_2\": \"101,asfsf\"}, \"courier_id\": \"12298\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 1, \"sku\": \"Rimo Navy Organic Cotton Sweatshirt\", \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"price\": 5}], \"order_amount\": \"2825\", \"order_number\": \"3392452526\", \"payment_type\": \"cod\", \"package_height\": \"11\", \"package_length\": \"18\", \"package_weight\": \"3\", \"package_breadth\": \"19\", \"shipping_charges\": 0, \"collectable_amount\": 1825, \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230802114258-36.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230802114258-57.pdf\", \"order_id\": 13657330, \"awb_number\": \"152489881342474\", \"courier_id\": \"12298\", \"shipment_id\": 7084012, \"courier_name\": \"Xpressbees 1 K.G\", \"payment_type\": \"cod\", \"additional_info\": \"\", \"fwd_destination_code\": \"\"}, \"status\": true}}', 'shipment_created', '2023-08-02 15:42:43', '2023-08-02 15:48:18'),
(11, '2', 341, 'Cancelled', '152489881342487', NULL, '89', 'https://xb-files.s3.amazonaws.com/labels/20230802115905-79.pdf', '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 32, \"total_charges\": 89, \"freight_charges\": 57, \"chargeable_weight\": 1000}', '{\"height\": \"22\", \"length\": \"15\", \"weight\": \"1\", \"breadth\": \"15\", \"order_total\": 1356, \"chargeable_weight\": 6.0192, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"height\": 22, \"length\": 36, \"weight\": 6, \"breadth\": 38}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"ud\", \"name\": \"abcd\", \"phone\": \"1231231231\", \"state\": \"rj\", \"address\": \"101,asfsf\", \"pincode\": \"313002\", \"address_2\": \"101,asfsf\"}, \"courier_id\": \"12298\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 1, \"sku\": \"Rimo Navy Organic Cotton Sweatshirt\", \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"price\": \"2825\"}], \"order_amount\": \"5650\", \"order_number\": \"3413847019\", \"payment_type\": \"cod\", \"package_height\": \"22\", \"package_length\": \"15\", \"package_weight\": \"1\", \"package_breadth\": \"15\", \"shipping_charges\": 0, \"collectable_amount\": 4650, \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230802115905-79.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230802115905-49.pdf\", \"order_id\": 13657774, \"awb_number\": \"152489881342487\", \"courier_id\": \"12298\", \"shipment_id\": 7084292, \"courier_name\": \"Xpressbees 1 K.G\", \"payment_type\": \"cod\", \"additional_info\": \"\", \"fwd_destination_code\": \"\"}, \"status\": true}}', 'shipment_created', '2023-08-02 15:57:58', '2023-08-02 16:00:34'),
(12, '2', 342, 'Cancelled', '152489881342491', NULL, '89', 'https://xb-files.s3.amazonaws.com/labels/20230802120234-40.pdf', '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 32, \"total_charges\": 89, \"freight_charges\": 57, \"chargeable_weight\": 1000}', '{\"height\": \"15\", \"length\": \"15\", \"weight\": \"1\", \"breadth\": \"15\", \"order_total\": 1356, \"chargeable_weight\": 6.0192, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"height\": 22, \"length\": 36, \"weight\": 6, \"breadth\": 38}]}', '{\"order_data\": {\"pickup\": {\"city\": \"udaipur\", \"name\": \"Fashion Leo Admin\", \"phone\": \"7014283142\", \"state\": \"Rajasthan\", \"address\": \"Udaipur\", \"pincode\": \"313001\", \"address_2\": \"Udaipur\", \"warehouse_name\": \"Fashion Leo Admin\"}, \"discount\": 0, \"consignee\": {\"city\": \"ud\", \"name\": \"abcd\", \"phone\": \"1231231231\", \"state\": \"rj\", \"address\": \"101,asfsf\", \"pincode\": \"313002\", \"address_2\": \"101,asfsf\"}, \"courier_id\": \"12298\", \"cod_charges\": \"\", \"order_items\": [{\"qty\": 2, \"sku\": \"Rimo Navy Organic Cotton Sweatshirt\", \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"price\": \"2825\"}], \"order_amount\": \"5650\", \"order_number\": \"3424989338\", \"payment_type\": \"cod\", \"package_height\": \"15\", \"package_length\": \"15\", \"package_weight\": \"1\", \"package_breadth\": \"15\", \"shipping_charges\": 0, \"collectable_amount\": 4650, \"request_auto_pickup\": \"yes\"}}', '{\"order_data\": {\"data\": {\"label\": \"https://xb-files.s3.amazonaws.com/labels/20230802120234-40.pdf\", \"status\": \"booked\", \"manifest\": \"https://xb-files.s3.amazonaws.com/manifest/20230802120235-46.pdf\", \"order_id\": 13657878, \"awb_number\": \"152489881342491\", \"courier_id\": \"12298\", \"shipment_id\": 7084311, \"courier_name\": \"Xpressbees 1 K.G\", \"payment_type\": \"cod\", \"additional_info\": \"\", \"fwd_destination_code\": \"\"}, \"status\": true}}', 'shipment_created', '2023-08-02 16:01:30', '2023-08-02 16:02:55'),
(13, '1', 340, 'Cancelled', '14326389021233', NULL, '206.52', NULL, '{\"id\": 350914963, \"cod\": 1, \"edd\": \"\", \"etd\": \"Aug 14, 2023\", \"city\": \"Udaipur\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 251.9, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"RAJASTHAN\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"prefetch_enabled\\\": 0, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 4.9, \"region\": 1, \"blocked\": 0, \"odablock\": false, \"postcode\": \"313002\", \"entry_tax\": 0, \"etd_hours\": 115, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 2, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 45.38, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 192, \"courier_name\": \"Xpressbees 2kg\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.5, \"charge_weight\": 3, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.03, \"freight_charge\": 206.52, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 4.9, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 24, \"pickup_performance\": 4.9, \"surface_max_weight\": \"4.00\", \"pickup_availability\": \"1\", \"call_before_delivery\": \"Not Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 4.9, \"pickup_supress_hours\": 0, \"tracking_performance\": 4.9, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 2090, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"11\", \"length\": \"18\", \"weight\": \"3\", \"breadth\": \"19\", \"order_total\": 1356, \"chargeable_weight\": 3, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"height\": 11, \"length\": 18, \"weight\": 3, \"breadth\": 19}]}', '{\"order_data\": {\"height\": \"11\", \"length\": \"18\", \"weight\": \"3\", \"breadth\": \"19\", \"comment\": \"\", \"order_id\": \"3401812702\", \"sub_total\": 1825, \"channel_id\": \"\", \"order_date\": \"2023-08-09\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"Rimo Navy Organic Cotton Sweatshirt\", \"tax\": \"\", \"name\": \"Rimo Navy Organic Cotton Sweatshirt\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"ud\", \"billing_email\": \"fl@gmail.com\", \"billing_phone\": \"1231231231\", \"billing_state\": \"rj\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"101,asfsf\", \"billing_country\": \"India\", \"billing_pincode\": \"313002\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"101,asfsf\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"abcd\", \"shipping_customer_name\": \"\"}, \"shipment_request_data\": {\"courier_id\": 24, \"shipment_id\": 385966768}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 386606605, \"shipment_id\": 385966768, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}, \"shipment_data\": {\"response\": {\"data\": {\"cod\": 1, \"awb_code\": \"14326389021233\", \"order_id\": 386606605, \"company_id\": 3453435, \"invoice_no\": \"Retail00004\", \"shipped_by\": {\"lat\": null, \"long\": null, \"rto_city\": \"Bengaluru\", \"rto_email\": \"srikanthn@hemalstore.com\", \"rto_phone\": \"8919921719\", \"rto_state\": \"karnataka\", \"extra_info\": {\"source\": 3, \"boat_delhivery_clientware_id\": \"BOAT SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_trent_clientware_id\": \"kartrocket-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_clientware_id\": \"IDAM SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_zomato_2kg_clientware_id\": \"ZOMATO SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_2kg_clientware_id\": \"IDAM SR 2KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_5kg_clientware_id\": \"IDAM SR 5KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_documents_2kg_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_secured_documents_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\"}, \"rto_country\": \"india\", \"rto_postcode\": \"560003\", \"shipper_city\": \"Bengaluru\", \"rto_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"rto_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_email\": \"srikanthn@hemalstore.com\", \"shipper_phone\": \"8919921719\", \"shipper_state\": \"karnataka\", \"shipper_country\": \"india\", \"rto_company_name\": \"HEMALSTORE\", \"shipper_postcode\": \"560003\", \"shipper_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_company_name\": \"HEMALSTORE\", \"shipper_first_mile_activated\": 0}, \"shipment_id\": 385966768, \"courier_name\": \"Xpressbees 2kg\", \"applied_weight\": 3, \"transporter_id\": \"27AAGCB3904P2ZC\", \"awb_code_status\": 1, \"freight_charges\": 206.52, \"transporter_name\": \"Xpressbees\", \"assigned_date_time\": {\"date\": \"2023-08-09 10:25:34.000000\", \"timezone\": \"Asia/Kolkata\", \"timezone_type\": 3}, \"child_courier_name\": null, \"courier_company_id\": 24}}, \"quick_pick\": 0, \"no_pickup_popup\": 0, \"awb_assign_status\": 1}}', 'shipment_created', '2023-08-09 14:25:03', '2023-08-09 14:26:40'),
(15, '2', 370, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-09-01 15:05:27', '2023-09-01 15:05:27'),
(16, '1', 643, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-20 16:44:18', '2023-10-20 16:44:18'),
(17, '1', 640, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-20 16:50:59', '2023-10-26 15:30:27'),
(18, '1', 665, 'Cancelled', '141123857249339', NULL, '62.09', NULL, '{\"id\": 390362986, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 25, 2023\", \"city\": \"BANSWARA\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 358.98, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"RAJASTHAN\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"prefetch_enabled\\\": 0, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 3.8, \"region\": 1, \"blocked\": 0, \"odablock\": false, \"postcode\": \"312604\", \"entry_tax\": 0, \"etd_hours\": 125, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 0.5, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 296.89, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 62.09, \"courier_name\": \"Xpressbees Surface\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.6, \"charge_weight\": 0.5, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 62.09, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 5, \"coverage_charges\": 100.01, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 51, \"pickup_performance\": 4.6, \"surface_max_weight\": \"1.50\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Available\", \"delivery_performance\": 2.3, \"pickup_supress_hours\": 0, \"tracking_performance\": 4.1, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"2\", \"length\": \"1\", \"weight\": \".5\", \"breadth\": \"2\", \"order_total\": 12118, \"chargeable_weight\": 2, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"testing product\", \"height\": 11, \"length\": 12, \"weight\": 2, \"breadth\": 12}]}', '{\"order_data\": {\"height\": \"2\", \"length\": \"1\", \"weight\": \".5\", \"breadth\": \"2\", \"comment\": \"\", \"order_id\": \"6652131829\", \"sub_total\": \"16158\", \"channel_id\": \"\", \"order_date\": \"2023-10-20\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"testing product\", \"tax\": \"\", \"name\": \"testing product\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Chhoti sadri\", \"billing_email\": \"Hozefa7744@gmail.com\", \"billing_phone\": \"9660598862\", \"billing_state\": \"Rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Nearby\", \"billing_country\": \"India\", \"billing_pincode\": \"312604\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Nearby\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"Abbas\", \"shipping_customer_name\": \"\"}, \"shipment_request_data\": {\"courier_id\": 51, \"shipment_id\": 422227861}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 424051159, \"shipment_id\": 422227861, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}, \"shipment_data\": {\"response\": {\"data\": {\"cod\": 1, \"awb_code\": \"141123857249339\", \"order_id\": 424051159, \"company_id\": 3453435, \"invoice_no\": \"Retail00007\", \"shipped_by\": {\"lat\": null, \"long\": null, \"rto_city\": \"Bengaluru\", \"rto_email\": \"srikanthn@hemalstore.com\", \"rto_phone\": \"8919921719\", \"rto_state\": \"karnataka\", \"extra_info\": {\"source\": 3, \"boat_delhivery_clientware_id\": \"BOAT SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_trent_clientware_id\": \"kartrocket-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_clientware_id\": \"IDAM SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_zomato_2kg_clientware_id\": \"ZOMATO SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_2kg_clientware_id\": \"IDAM SR 2KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_5kg_clientware_id\": \"IDAM SR 5KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_documents_2kg_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_secured_documents_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\"}, \"rto_country\": \"india\", \"rto_postcode\": \"560003\", \"shipper_city\": \"Bengaluru\", \"rto_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"rto_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_email\": \"srikanthn@hemalstore.com\", \"shipper_phone\": \"8919921719\", \"shipper_state\": \"karnataka\", \"shipper_country\": \"india\", \"rto_company_name\": \"HEMALSTORE\", \"shipper_postcode\": \"560003\", \"shipper_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_company_name\": \"HEMALSTORE\", \"shipper_first_mile_activated\": 0}, \"shipment_id\": 422227861, \"courier_name\": \"Xpressbees Surface\", \"routing_code\": \"\", \"applied_weight\": 0.5, \"transporter_id\": \"27AAGCB3904P2ZC\", \"awb_code_status\": 1, \"freight_charges\": 62.09, \"rto_routing_code\": \"\", \"transporter_name\": \"Xpressbees\", \"assigned_date_time\": {\"date\": \"2023-10-20 13:22:22.000000\", \"timezone\": \"Asia/Kolkata\", \"timezone_type\": 3}, \"child_courier_name\": null, \"courier_company_id\": 51}}, \"quick_pick\": 0, \"no_pickup_popup\": 0, \"awb_assign_status\": 1}}', 'shipment_created', '2023-10-20 17:00:45', '2023-10-20 17:26:21'),
(19, '1', 595, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-20 17:15:16', '2023-10-20 17:15:16'),
(20, '1', 665, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, '{\"order_data\": {\"height\": \"2\", \"length\": \"1\", \"weight\": \".5\", \"breadth\": \"2\", \"comment\": \"\", \"order_id\": \"6652131829\", \"sub_total\": \"16158\", \"channel_id\": \"\", \"order_date\": \"2023-10-20\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"testing product\", \"tax\": \"\", \"name\": \"testing product\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Chhoti sadri\", \"billing_email\": \"Hozefa7744@gmail.com\", \"billing_phone\": \"9660598862\", \"billing_state\": \"Rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Nearby\", \"billing_country\": \"India\", \"billing_pincode\": \"312604\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Nearby\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"Abbas\", \"shipping_customer_name\": \"\"}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 424051159, \"shipment_id\": 422227861, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}}', 'order_created', '2023-10-20 17:19:39', '2023-10-20 17:22:06'),
(21, '2', 606, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-20 17:27:06', '2023-10-20 17:27:06'),
(22, '2', 661, 'Pending', NULL, NULL, '184.1', NULL, '{\"id\": \"12298\", \"name\": \"Xpressbees 1 K.G\", \"min_weight\": 1000, \"cod_charges\": 89.1, \"total_charges\": 184.1, \"freight_charges\": 95, \"chargeable_weight\": 1000}', '{\"height\": \"2\", \"length\": \"2\", \"weight\": \"144\", \"breadth\": \"2\", \"order_total\": 4950, \"chargeable_weight\": 144, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"replicate product\", \"height\": 2, \"length\": 2, \"weight\": 144, \"breadth\": 2}]}', NULL, NULL, 'courier_created', '2023-10-26 15:19:39', '2023-10-26 15:20:41'),
(23, '1', 599, 'Pending', NULL, NULL, '10221.45', NULL, '{\"id\": 388823691, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 31, 2023\", \"city\": \"Udaipur\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 10221.45, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Rajasthan\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 3.6, \"region\": 2, \"blocked\": 0, \"message\": \"Alert! Weight limit exceeding threshold.\", \"odablock\": false, \"postcode\": \"313001\", \"entry_tax\": 0, \"etd_hours\": 125, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 20, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 182.89, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 10493.28, \"courier_name\": \"Delhivery Surface 20 Kgs\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.6, \"charge_weight\": 216, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.03, \"freight_charge\": 10038.56, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 1, \"coverage_charges\": 46.3, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 101, \"pickup_performance\": 4.8, \"surface_max_weight\": \"500.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 5, \"pickup_supress_hours\": 0, \"tracking_performance\": 5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"5\", \"length\": \"22\", \"weight\": \"216\", \"breadth\": \"3\", \"order_total\": 5610, \"chargeable_weight\": 216, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"replicate product\", \"height\": 2, \"length\": 2, \"weight\": 144, \"breadth\": 2}, {\"qty\": 1, \"name\": \"asdasdasdasd\", \"height\": 3, \"length\": 20, \"weight\": 216, \"breadth\": 1}]}', '{\"order_data\": {\"height\": \"5\", \"length\": \"22\", \"weight\": \"216\", \"breadth\": \"3\", \"comment\": \"\", \"order_id\": \"5993966042\", \"sub_total\": \"27060\", \"channel_id\": \"\", \"order_date\": \"2023-10-26\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"asdasdasdasd\", \"tax\": \"\", \"name\": \"asdasdasdasd\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Udaipur\", \"billing_email\": \"haha@gmail.com\", \"billing_phone\": \"7976281007\", \"billing_state\": \"rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"near post office\", \"billing_country\": \"India\", \"billing_pincode\": \"313001\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"near post office\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"juber\", \"shipping_customer_name\": \"\"}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 426665707, \"shipment_id\": 424841998, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}}', 'order_created', '2023-10-26 15:35:40', '2023-10-26 15:36:54'),
(24, '2', 592, 'Pending', NULL, NULL, '5787.7', NULL, '{\"id\": \"6\", \"name\": \"Air Xpressbees 0.5 K.G\", \"min_weight\": 500, \"cod_charges\": 353.7, \"total_charges\": 5787.7, \"freight_charges\": 5434, \"chargeable_weight\": 33500}', '{\"height\": \"52\", \"length\": \"70\", \"weight\": \"513\", \"breadth\": \"46\", \"order_total\": 19650, \"chargeable_weight\": 513, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"Fleece Medium & Large Mens Casual Blazer\", \"height\": 30, \"length\": 42, \"weight\": 6, \"breadth\": 26}, {\"qty\": 1, \"name\": \"Fleece Medium & Large Mens Casual Blazer\", \"height\": 15, \"length\": 21, \"weight\": 9, \"breadth\": 13}, {\"qty\": 3, \"name\": \"replicate product\", \"height\": 3, \"length\": 3, \"weight\": 225, \"breadth\": 3}, {\"qty\": 1, \"name\": \"replicate product\", \"height\": 1, \"length\": 1, \"weight\": 297, \"breadth\": 1}, {\"qty\": 3, \"name\": \"replicate product\", \"height\": 3, \"length\": 3, \"weight\": 513, \"breadth\": 3}]}', NULL, NULL, 'courier_created', '2023-10-26 15:38:11', '2023-10-26 15:41:06'),
(25, '1', 586, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-26 15:45:57', '2023-10-26 15:48:41'),
(26, '1', 605, 'Pending', NULL, NULL, '6869.21', NULL, '{\"id\": 388823676, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 31, 2023\", \"city\": \"Chittorgarh\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 6869.21, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Rajasthan\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 4.4, \"region\": 2, \"blocked\": 0, \"message\": \"Alert! Weight limit exceeding threshold.\", \"odablock\": false, \"postcode\": \"312604\", \"entry_tax\": 0, \"etd_hours\": 125, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 20, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 161.37, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 6995.52, \"courier_name\": \"Delhivery Surface 20 Kgs\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.2, \"charge_weight\": 144, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.03, \"freight_charge\": 6707.84, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 4.4, \"coverage_charges\": 40.86, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 101, \"pickup_performance\": 4.4, \"surface_max_weight\": \"500.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 4.5, \"pickup_supress_hours\": 0, \"tracking_performance\": 4.5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"2\", \"length\": \"2\", \"weight\": \"144\", \"breadth\": \"2\", \"order_total\": 4950, \"chargeable_weight\": 144, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 2, \"name\": \"replicate product\", \"height\": 2, \"length\": 2, \"weight\": 144, \"breadth\": 2}]}', '{\"order_data\": {\"height\": \"2\", \"length\": \"2\", \"weight\": \"144\", \"breadth\": \"2\", \"comment\": \"\", \"order_id\": \"6055671845\", \"sub_total\": \"9900\", \"channel_id\": \"\", \"order_date\": \"2023-10-26\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"replicate product\", \"tax\": \"\", \"name\": \"replicate product\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Chhoti sadri\", \"billing_email\": \"Hozefa7744@gmail.com\", \"billing_phone\": \"9660598862\", \"billing_state\": \"Rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Nearby\", \"billing_country\": \"India\", \"billing_pincode\": \"312604\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Nearby\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"Abbas\", \"shipping_customer_name\": \"\"}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 426811584, \"shipment_id\": 424987868, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}}', 'order_created', '2023-10-26 16:05:15', '2023-10-26 19:38:23'),
(27, '2', 600, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-26 18:25:49', '2023-10-26 18:25:49');
INSERT INTO `shipments` (`id`, `shipment_master_id`, `order_id`, `status`, `tracking_number`, `delivery_date`, `amount`, `label_url`, `courier_data`, `product_data`, `request_response`, `response`, `shipment_status`, `created_at`, `updated_at`) VALUES
(28, '1', 590, 'Pending', NULL, NULL, '196.5', NULL, '{\"id\": 391973210, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 31, 2023\", \"city\": \"MANDSAUR\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 196.5, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Madhya Pradesh\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 4.9, \"region\": 6, \"blocked\": 0, \"odablock\": false, \"postcode\": \"458001\", \"entry_tax\": 0, \"etd_hours\": 124, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 2, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 45.38, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 151.12, \"courier_name\": \"Ecom Express Surface 2kg\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.6, \"charge_weight\": 2, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 151.12, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 5, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 19, \"pickup_performance\": 4.9, \"surface_max_weight\": \"30.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 5, \"pickup_supress_hours\": 0, \"tracking_performance\": 4.1, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"3\", \"length\": \"20\", \"weight\": \"2\", \"breadth\": \"1\", \"order_total\": 660, \"chargeable_weight\": 72, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"asdasdasdasd\", \"height\": 3, \"length\": 20, \"weight\": 72, \"breadth\": 1}]}', NULL, NULL, 'courier_created', '2023-10-26 18:36:29', '2023-10-26 18:38:31'),
(30, '1', 552, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shipment_selected', '2023-10-26 18:57:08', '2023-10-26 18:57:43'),
(31, '1', 589, 'Pending', NULL, NULL, '187.35', NULL, '{\"id\": 391452646, \"cod\": 1, \"edd\": \"\", \"etd\": \"Nov 01, 2023\", \"city\": \"MANDSAUR / DASPURKUNJ\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 187.35, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"MADHYA PRADESH\", \"others\": \"{\\\"cancel_real_time\\\": true}\", \"rating\": 4.6, \"region\": 6, \"blocked\": 0, \"odablock\": false, \"postcode\": \"458001\", \"entry_tax\": 0, \"etd_hours\": 130, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 2, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 31.23, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 156.12, \"courier_name\": \"DTDC 2kg\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.5, \"charge_weight\": 2, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"On Request\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 156.12, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 5, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": {\"action_on\": \"2023-10-24 08:54:34\", \"block_reason\": \"This pincode is blocked for pickup due to Operational Issues\"}, \"courier_company_id\": 82, \"pickup_performance\": 4.4, \"surface_max_weight\": \"4.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Not Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 5, \"pickup_supress_hours\": 0, \"tracking_performance\": 3.9, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"6\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"3\", \"length\": \"20\", \"weight\": \"2\", \"breadth\": \"1\", \"order_total\": 660, \"chargeable_weight\": 72, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"asdasdasdasd\", \"height\": 3, \"length\": 20, \"weight\": 72, \"breadth\": 1}]}', NULL, NULL, 'courier_created', '2023-10-26 19:25:02', '2023-10-26 19:25:50'),
(32, '1', 591, 'Pending', NULL, NULL, '196.5', NULL, '{\"id\": 391967629, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 31, 2023\", \"city\": \"BARI SADRI\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 196.5, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Rajasthan\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 4.4, \"region\": 1, \"blocked\": 0, \"odablock\": false, \"postcode\": \"312604\", \"entry_tax\": 0, \"etd_hours\": 124, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 2, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 45.38, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 151.12, \"courier_name\": \"Ecom Express Surface 2kg\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.2, \"charge_weight\": 2, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 151.12, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 4.4, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 19, \"pickup_performance\": 4.4, \"surface_max_weight\": \"30.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 4.5, \"pickup_supress_hours\": 0, \"tracking_performance\": 4.5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"5.8\", \"length\": \"1\", \"weight\": \"2\", \"breadth\": \"2\", \"order_total\": 345, \"chargeable_weight\": 72, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"asdasdsdasdasdasdasasdasd\", \"height\": 5.8, \"length\": 1, \"weight\": 72, \"breadth\": 1}]}', '{\"order_data\": {\"height\": \"5.8\", \"length\": \"1\", \"weight\": \"2\", \"breadth\": \"2\", \"comment\": \"\", \"order_id\": \"5914887384\", \"sub_total\": 245, \"channel_id\": \"\", \"order_date\": \"2023-10-26\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"asdasdsdasdasdasdasasdasd\", \"tax\": \"\", \"name\": \"asdasdsdasdasdasdasasdasd\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"Chhoti sadri\", \"billing_email\": \"Hozefa7744@gmail.com\", \"billing_phone\": \"9660598862\", \"billing_state\": \"Rajasthan\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"Nearby\", \"billing_country\": \"India\", \"billing_pincode\": \"312604\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"Nearby\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"Abbas\", \"shipping_customer_name\": \"\"}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 426908531, \"shipment_id\": 425084805, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}}', 'order_created', '2023-10-26 22:44:25', '2023-10-26 22:45:14'),
(33, '1', 452, 'Cancelled', '10163848004', NULL, '141.43', NULL, '{\"id\": 391945365, \"cod\": 1, \"edd\": \"\", \"etd\": \"Nov 01, 2023\", \"city\": \"INDORE - IND\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 186.81, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Madhya Pradesh\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 3.7, \"region\": 6, \"blocked\": 0, \"odablock\": false, \"postcode\": \"452001\", \"entry_tax\": 0, \"etd_hours\": 138, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 0.5, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 45.38, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 145.02, \"courier_name\": \"Ecom Express Surface\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.6, \"charge_weight\": 1, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.02, \"freight_charge\": 141.43, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 3.6, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 14, \"pickup_performance\": 4.9, \"surface_max_weight\": \"30.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 3.5, \"pickup_supress_hours\": 0, \"tracking_performance\": 3.5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"6\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"11\", \"length\": \"12\", \"weight\": \"1\", \"breadth\": \"11\", \"order_total\": 1100, \"chargeable_weight\": 3, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"Red T-shirt\", \"height\": 11, \"length\": 12, \"weight\": 3, \"breadth\": 11}]}', '{\"order_data\": {\"height\": \"11\", \"length\": \"12\", \"weight\": \"1\", \"breadth\": \"11\", \"comment\": \"\", \"order_id\": \"4522966324\", \"sub_total\": \"1100\", \"channel_id\": \"\", \"order_date\": \"2023-10-26\", \"order_items\": [{\"hsn\": \"\", \"sku\": \"Red T-shirt\", \"tax\": \"\", \"name\": \"Red T-shirt\", \"units\": 1, \"discount\": \"\", \"selling_price\": 5}], \"billing_city\": \"faridabad\", \"billing_email\": \"fl@gmail.com\", \"billing_phone\": \"1231231231\", \"billing_state\": \"UP\", \"shipping_city\": \"\", \"payment_method\": \"COD\", \"shipping_email\": \"\", \"shipping_phone\": \"\", \"shipping_state\": \"\", \"total_discount\": 0, \"billing_address\": \"faridabad\", \"billing_country\": \"India\", \"billing_pincode\": \"452001\", \"pickup_location\": \"1\", \"giftwrap_charges\": 0, \"shipping_address\": \"\", \"shipping_charges\": 0, \"shipping_country\": \"\", \"shipping_pincode\": \"\", \"billing_address_2\": \"faridabad\", \"billing_last_name\": \"\", \"shipping_address_2\": \"\", \"shipping_last_name\": \"\", \"shipping_is_billing\": true, \"transaction_charges\": 0, \"billing_customer_name\": \"Tushar\", \"shipping_customer_name\": \"\"}, \"shipment_request_data\": {\"courier_id\": 14, \"shipment_id\": 425085132}}', '{\"order_data\": {\"status\": \"NEW\", \"awb_code\": \"\", \"order_id\": 426908858, \"shipment_id\": 425085132, \"status_code\": 1, \"courier_name\": \"\", \"courier_company_id\": \"\", \"onboarding_completed_now\": 0}, \"shipment_data\": {\"response\": {\"data\": {\"cod\": 1, \"awb_code\": \"10163848004\", \"order_id\": 426908858, \"company_id\": 3453435, \"invoice_no\": \"Retail00008\", \"shipped_by\": {\"lat\": null, \"long\": null, \"rto_city\": \"Bengaluru\", \"rto_email\": \"srikanthn@hemalstore.com\", \"rto_phone\": \"8919921719\", \"rto_state\": \"karnataka\", \"extra_info\": {\"source\": 3, \"boat_delhivery_clientware_id\": \"BOAT SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_trent_clientware_id\": \"kartrocket-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_clientware_id\": \"IDAM SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_zomato_2kg_clientware_id\": \"ZOMATO SR SURFACE-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_2kg_clientware_id\": \"IDAM SR 2KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_bellavita_5kg_clientware_id\": \"IDAM SR 5KG-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_documents_2kg_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\", \"delhivery_secured_documents_clientware_id\": \"SHIPROCKET-Bengaluru-560003-FASHION LEO ENTERPRISES-3453435-4005378\"}, \"rto_country\": \"india\", \"rto_postcode\": \"560003\", \"shipper_city\": \"Bengaluru\", \"rto_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"rto_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_email\": \"srikanthn@hemalstore.com\", \"shipper_phone\": \"8919921719\", \"shipper_state\": \"karnataka\", \"shipper_country\": \"india\", \"rto_company_name\": \"HEMALSTORE\", \"shipper_postcode\": \"560003\", \"shipper_address_1\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_address_2\": \"46 1,1st floor, 2nd Main road, Near vinayaka circle, palace Guttahalli, Bengaluru   560003\", \"shipper_company_name\": \"HEMALSTORE\", \"shipper_first_mile_activated\": 0}, \"shipment_id\": 425085132, \"courier_name\": \"Ecom Express Surface\", \"routing_code\": \"\", \"applied_weight\": 1, \"transporter_id\": \"07AADCE1344F1Z2\", \"awb_code_status\": 1, \"freight_charges\": 141.43, \"rto_routing_code\": \"\", \"transporter_name\": \"Ecom Express\", \"assigned_date_time\": {\"date\": \"2023-10-26 18:46:10.000000\", \"timezone\": \"Asia/Kolkata\", \"timezone_type\": 3}, \"child_courier_name\": null, \"courier_company_id\": 14}}, \"quick_pick\": 0, \"no_pickup_popup\": 0, \"awb_assign_status\": 1}}', 'shipment_created', '2023-10-26 22:44:54', '2023-10-26 22:47:10'),
(34, '1', 579, 'Pending', NULL, NULL, '3443.17', NULL, '{\"id\": 388823691, \"cod\": 1, \"edd\": \"\", \"etd\": \"Oct 31, 2023\", \"city\": \"Udaipur\", \"cost\": \"\", \"mode\": 0, \"rank\": \"\", \"rate\": 3443.17, \"zone\": \"z_d\", \"metro\": 0, \"state\": \"Rajasthan\", \"others\": \"{\\\"cancel_real_time\\\": true, \\\"allow_postcode_auto_sync\\\": 1}\", \"rating\": 3.6, \"region\": 2, \"blocked\": 0, \"odablock\": false, \"postcode\": \"313001\", \"entry_tax\": 0, \"etd_hours\": 125, \"ship_type\": 1, \"is_surface\": true, \"min_weight\": 20, \"qc_courier\": 0, \"base_weight\": \"\", \"cod_charges\": 66.05, \"cutoff_time\": \"11:00\", \"description\": \"\", \"rto_charges\": 3497.76, \"courier_name\": \"Delhivery Surface 20 Kgs\", \"courier_type\": \"0\", \"local_region\": 0, \"weight_cases\": 4.6, \"charge_weight\": 72, \"is_hyperlocal\": false, \"other_charges\": 0, \"pod_available\": \"Instant\", \"suppress_date\": \"\", \"suppress_text\": \"\", \"air_max_weight\": \"0.00\", \"assured_amount\": 0, \"cod_multiplier\": 0.03, \"freight_charge\": 3377.12, \"is_custom_rate\": 0, \"base_courier_id\": null, \"pickup_priority\": \"\", \"rto_performance\": 1, \"coverage_charges\": 0, \"is_international\": 0, \"realtime_tracking\": \"Real Time\", \"suppression_dates\": [], \"courier_company_id\": 101, \"pickup_performance\": 4.8, \"surface_max_weight\": \"500.00\", \"pickup_availability\": \"0\", \"call_before_delivery\": \"Available\", \"delivery_boy_contact\": \"Not Available\", \"delivery_performance\": 5, \"pickup_supress_hours\": 0, \"tracking_performance\": 5, \"volumetric_max_weight\": null, \"estimated_delivery_days\": \"5\", \"seconds_left_for_pickup\": 0, \"is_rto_address_available\": true, \"secure_shipment_disabled\": false}', '{\"height\": \"5.8\", \"length\": \"1\", \"weight\": \"72\", \"breadth\": \"2\", \"order_total\": 345, \"chargeable_weight\": 72, \"volumetric_weight\": null, \"products_total_dimension\": [{\"qty\": 1, \"name\": \"asdasdsdasdasdasdasasdasd\", \"height\": 5.8, \"length\": 1, \"weight\": 72, \"breadth\": 1}]}', NULL, NULL, 'courier_created', '2023-10-26 22:45:58', '2023-10-26 22:49:18');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `sliders`
--

INSERT INTO `sliders` (`id`, `name`, `type`, `link`, `image`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(11, 'All men', 'App', NULL, 'uploads/slider/ef16e9252008b4d42aa2f5cec9da5968.jfif', 'Active', '2021-12-08 19:39:14', '2023-05-06 20:18:52', NULL),
(19, 'Women', 'App', NULL, 'uploads/slider/dc6bf32b75b6ed9ad861b9e188832356.jfif', 'Active', '2023-04-29 12:41:18', '2023-05-06 20:20:17', NULL),
(20, 'kids fashion', 'App', NULL, 'uploads/slider/6cd42710a05ef7fcec283536a299c387.jfif', 'Active', '2023-05-06 20:21:54', '2023-05-06 20:21:54', NULL),
(21, 'Mens fashion', 'Web', NULL, 'uploads/slider/8e99c044b588b8c392600729c4443d5b.jpg', 'Active', '2023-05-10 19:14:05', '2023-05-10 19:14:05', NULL),
(22, 'Women fashion', 'Web', NULL, 'uploads/slider/1deffdacf96f14d65d9d74222ceb6845.jpg', 'Active', '2023-05-10 19:20:38', '2023-05-10 19:20:38', NULL);

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `country_id` bigint UNSIGNED DEFAULT NULL,
  `status` varchar(20) DEFAULT 'Active' COMMENT 'Active,Inactive',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`, `country_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Andhra Pradesh', 1, 'Active', NULL, NULL, NULL),
(2, 'Arunachal Pradesh', 1, 'Active', NULL, NULL, NULL),
(3, 'Assam', 1, 'Active', NULL, NULL, NULL),
(4, 'Bihar', 1, 'Active', NULL, NULL, NULL),
(5, 'Chhattisgarh', 1, 'Active', NULL, NULL, NULL),
(6, 'Goa', 1, 'Active', NULL, NULL, NULL),
(7, 'Gujarat', 1, 'Active', NULL, NULL, NULL),
(8, 'Haryana', 1, 'Active', NULL, NULL, NULL),
(9, 'Himachal Pradesh', 1, 'Active', NULL, NULL, NULL),
(10, 'Jharkhand', 1, 'Active', NULL, NULL, NULL),
(11, 'Karnataka', 1, 'Active', NULL, NULL, NULL),
(12, 'Kerala', 1, 'Active', NULL, NULL, NULL),
(13, 'Madhya Pradesh', 1, 'Active', NULL, NULL, NULL),
(14, 'Maharashtra', 1, 'Active', NULL, NULL, NULL),
(15, 'Manipur', 1, 'Active', NULL, NULL, NULL),
(16, 'Meghalaya', 1, 'Active', NULL, NULL, NULL),
(17, 'Mizoram', 1, 'Active', NULL, NULL, NULL),
(18, 'Nagaland', 1, 'Active', NULL, NULL, NULL),
(19, 'Odisha', 1, 'Active', NULL, NULL, NULL),
(20, 'Punjab', 1, 'Active', NULL, NULL, NULL),
(21, 'Rajasthan', 1, 'Active', NULL, NULL, NULL),
(22, 'Sikkim', 1, 'Active', NULL, NULL, NULL),
(23, 'Tamil Nadu', 1, 'Active', NULL, NULL, NULL),
(24, 'Telangana', 1, 'Active', NULL, NULL, NULL),
(25, 'Tripura', 1, 'Active', NULL, NULL, NULL),
(26, 'Uttar Pradesh', 1, 'Active', NULL, NULL, NULL),
(27, 'Uttarakhand', 1, 'Active', NULL, NULL, NULL),
(28, 'West Bengal', 1, 'Active', NULL, NULL, NULL),
(29, 'Andaman and Nicobar Islands', 1, 'Active', NULL, NULL, NULL),
(30, 'Chandigarh', 1, 'Active', NULL, NULL, NULL),
(31, 'Dadra and Nagar Haveli and Daman and Diu', 1, 'Active', NULL, NULL, NULL),
(32, 'Lakshadweep', 1, 'Active', NULL, NULL, NULL),
(33, 'Delhi', 1, 'Active', NULL, NULL, NULL),
(34, 'Puducherry', 1, 'Active', NULL, NULL, NULL);

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `client_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_name_hi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_message_hi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Designation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `client_name`, `client_name_hi`, `client_email`, `client_message`, `client_message_hi`, `image`, `Designation`, `sort`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Arjun', NULL, 'a@gmail.com', 'Nily is providing very nice products on its platform.', NULL, 'uploads/Testimonial/c63d5bb57fb3893fe22b237aa1d27772.jpg', 'Customer', '1', 'Active', '2022-11-03 09:41:55', '2022-11-03 09:41:55');

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` bigint UNSIGNED NOT NULL,
  `font_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `theme_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `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 `themes`
--

INSERT INTO `themes` (`id`, `font_color`, `theme_color`, `status`, `created_at`, `updated_at`) VALUES
(5, '#ffffff', '#0a51f5', 'Deleted', '2022-10-26 15:20:59', '2023-05-11 19:59:37'),
(6, '#000000', '#000000', 'Active', '2023-05-11 20:00:00', '2023-05-11 20:00:00'),
(7, '#ff0000', '#6805e1', 'Active', '2023-05-17 00:51:15', '2023-05-17 00:51:15');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `payable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payable_id` bigint UNSIGNED NOT NULL,
  `wallet_id` bigint UNSIGNED NOT NULL,
  `type` enum('deposit','withdraw') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(64,0) NOT NULL,
  `confirmed` tinyint(1) NOT NULL,
  `meta` json DEFAULT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `transactions`
--

INSERT INTO `transactions` (`id`, `payable_type`, `payable_id`, `wallet_id`, `type`, `amount`, `confirmed`, `meta`, `uuid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'App\\Models\\User', 2, 2, 'deposit', '32', 1, '{\"type\": \"cashback\"}', '7b1e567e-aeb5-41e4-aae4-0fd6b5451f2f', '2023-05-10 16:26:38', '2023-05-10 16:26:38', NULL),
(2, 'App\\Models\\User', 83, 72, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": 100, \"description\": null}', '3c562305-5903-448f-b7fc-8357c34d4b6d', '2023-05-23 21:56:19', '2023-05-23 21:56:19', NULL),
(3, 'App\\Models\\User', 221, 187, 'withdraw', '-376', 1, '{\"id\": null, \"type\": null, \"amount\": 376, \"description\": null}', 'bb90f8a4-a049-4909-9c93-1c380c8681b6', '2023-08-01 17:20:55', '2023-08-01 17:20:55', NULL),
(4, 'App\\Models\\User', 221, 187, 'withdraw', '-124', 1, '{\"id\": null, \"type\": null, \"amount\": 124, \"description\": null}', '67004b90-61b0-4c8f-a89a-5f13b1e2d4f8', '2023-08-01 18:26:38', '2023-08-01 18:26:38', NULL),
(5, 'App\\Models\\User', 217, 183, 'withdraw', '-650', 1, '{\"id\": null, \"type\": null, \"amount\": \"650.00\", \"description\": null}', 'a57aa0a5-fdec-4007-b23f-46cbaeeab437', '2023-08-01 18:52:11', '2023-08-01 18:52:11', NULL),
(6, 'App\\Models\\User', 221, 187, 'withdraw', '-376', 1, '{\"id\": null, \"type\": null, \"amount\": 376, \"description\": null}', '5e78d224-0bab-444a-82f3-a970c683c1aa', '2023-08-01 18:59:32', '2023-08-01 18:59:32', NULL),
(7, 'App\\Models\\User', 221, 187, 'withdraw', '-5520', 1, '{\"id\": null, \"type\": null, \"amount\": 5520, \"description\": null}', 'ffe8ec36-670f-40cf-8f83-c2116f1be4cd', '2023-08-01 19:01:16', '2023-08-01 19:01:16', NULL),
(8, 'App\\Models\\User', 221, 187, 'withdraw', '-4104', 1, '{\"id\": null, \"type\": null, \"amount\": 4104, \"description\": null}', 'f8467a29-08e0-4a22-9f34-c4ee84883e36', '2023-08-01 19:36:38', '2023-08-01 19:36:38', NULL),
(9, 'App\\Models\\User', 217, 183, 'withdraw', '-111', 1, '{\"id\": null, \"type\": null, \"amount\": \"111.20\", \"description\": null}', '2a47081c-767c-417e-903e-64b69a2aa8d0', '2023-08-01 19:51:17', '2023-08-01 19:51:17', NULL),
(10, 'App\\Models\\User', 217, 183, 'withdraw', '-212', 1, '{\"id\": null, \"type\": null, \"amount\": \"212.00\", \"description\": null}', 'd4a4c3d7-1306-437b-bb13-a9325325fb68', '2023-08-01 20:32:11', '2023-08-01 20:32:11', NULL),
(11, 'App\\Models\\User', 217, 183, 'withdraw', '-27', 1, '{\"id\": null, \"type\": null, \"amount\": \"27\", \"description\": null}', '29cebbf8-92dd-4a48-96b6-b88932ce077e', '2023-08-01 20:42:45', '2023-08-01 20:42:45', NULL),
(12, 'App\\Models\\User', 217, 183, 'withdraw', '-111', 1, '{\"id\": null, \"type\": null, \"amount\": \"111\", \"description\": null}', '3a820aeb-81dc-4f17-b4cb-a4d962ed97b7', '2023-08-01 20:59:39', '2023-08-01 20:59:39', NULL),
(13, 'App\\Models\\User', 217, 183, 'withdraw', '-650', 1, '{\"id\": null, \"type\": null, \"amount\": \"650.00\", \"description\": null}', '843fcf3f-b515-4e19-a736-c9dd768dda6e', '2023-08-01 21:37:13', '2023-08-01 21:37:13', NULL),
(14, 'App\\Models\\User', 221, 187, 'withdraw', '-111', 1, '{\"id\": null, \"type\": null, \"amount\": 111, \"description\": null}', '8b98c1b2-cef0-4bb3-93f2-330e2d7f51e5', '2023-08-01 21:38:33', '2023-08-01 21:38:33', NULL),
(15, 'App\\Models\\User', 217, 183, 'withdraw', '-350', 1, '{\"id\": null, \"type\": null, \"amount\": \"350\", \"description\": null}', '09b2e127-620c-4575-9333-5d0c8f3464de', '2023-08-01 21:38:44', '2023-08-01 21:38:44', NULL),
(16, 'App\\Models\\User', 217, 183, 'withdraw', '-1558', 1, '{\"id\": null, \"type\": null, \"amount\": \"1558.00\", \"description\": null}', '08a6731d-1a66-40ee-9299-6ed1274a759d', '2023-08-01 21:44:06', '2023-08-01 21:44:06', NULL),
(17, 'App\\Models\\User', 217, 183, 'withdraw', '-998442', 1, '{\"id\": null, \"type\": null, \"amount\": \"998442\", \"description\": null}', 'a7e1df6c-3b01-4ad5-9086-f6cddbdee4ba', '2023-08-01 21:46:46', '2023-08-01 21:46:46', NULL),
(18, 'App\\Models\\User', 217, 183, 'withdraw', '-650', 1, '{\"id\": null, \"type\": null, \"amount\": \"650.00\", \"description\": null}', 'c4cb712b-1ca5-4e61-9f6a-741d83c95e6e', '2023-08-01 21:53:43', '2023-08-01 21:53:43', NULL),
(19, 'App\\Models\\User', 221, 187, 'withdraw', '-2825', 1, '{\"id\": null, \"type\": null, \"amount\": 2825, \"description\": null}', 'd18cd4d1-721a-4b47-91ec-7add3462916e', '2023-08-01 23:08:21', '2023-08-01 23:08:21', NULL),
(20, 'App\\Models\\User', 221, 187, 'withdraw', '-2175', 1, '{\"id\": null, \"type\": null, \"amount\": 2175, \"description\": null}', '2cdd650d-7aa9-47b9-92ce-65eebfb8d335', '2023-08-01 23:21:11', '2023-08-01 23:21:11', NULL),
(21, 'App\\Models\\User', 221, 187, 'withdraw', '-2727', 1, '{\"id\": null, \"type\": null, \"amount\": 2727.2, \"description\": null}', '69a8cf9c-7a4c-4dd9-92c4-e81e52c0b3c0', '2023-08-01 23:42:19', '2023-08-01 23:42:19', NULL),
(22, 'App\\Models\\User', 221, 187, 'withdraw', '-2825', 1, '{\"id\": null, \"type\": null, \"amount\": 2825, \"description\": null}', '563960d3-1512-4939-a78a-bac3f220a03b', '2023-08-01 23:57:17', '2023-08-01 23:57:17', NULL),
(23, 'App\\Models\\User', 221, 187, 'withdraw', '-2530', 1, '{\"id\": null, \"type\": null, \"amount\": 2530, \"description\": null}', '5c738d9b-3650-4e31-8f40-6cc0127870f3', '2023-08-02 15:15:06', '2023-08-02 15:15:06', NULL),
(24, 'App\\Models\\User', 13, 10, 'withdraw', '-1000', 1, '{\"id\": null, \"type\": null, \"amount\": 1000, \"description\": null}', 'bc3cf356-114c-4515-b3f3-b991ae7bbc07', '2023-08-02 15:19:22', '2023-08-02 15:19:22', NULL),
(25, 'App\\Models\\User', 13, 10, 'withdraw', '-111', 1, '{\"id\": null, \"type\": null, \"amount\": 111.2, \"description\": null}', 'e4dbe38a-4089-4617-98db-53f8073e4a51', '2023-08-02 15:28:42', '2023-08-02 15:28:42', NULL),
(26, 'App\\Models\\User', 13, 10, 'withdraw', '-889', 1, '{\"id\": null, \"type\": null, \"amount\": 889, \"description\": null}', '38ff08ba-381e-4417-86a7-638b9e6d28cf', '2023-08-02 15:38:27', '2023-08-02 15:38:27', NULL),
(27, 'App\\Models\\User', 13, 10, 'withdraw', '-1000', 1, '{\"id\": null, \"type\": null, \"amount\": 1000, \"description\": null}', 'f3efaf32-29ac-40dd-a7be-078422902b0f', '2023-08-02 15:42:15', '2023-08-02 15:42:15', NULL),
(28, 'App\\Models\\User', 13, 10, 'withdraw', '-1000', 1, '{\"id\": null, \"type\": null, \"amount\": 1000, \"description\": null}', '4064d515-3330-4d41-a9a0-a3fd0af5b209', '2023-08-02 15:49:30', '2023-08-02 15:49:30', NULL),
(29, 'App\\Models\\User', 13, 10, 'withdraw', '-1000', 1, '{\"id\": null, \"type\": null, \"amount\": 1000, \"description\": null}', '690699e4-4c99-4208-8585-36998f2d1119', '2023-08-02 15:52:19', '2023-08-02 15:52:19', NULL),
(30, 'App\\Models\\User', 13, 10, 'withdraw', '-1000', 1, '{\"id\": null, \"type\": null, \"amount\": 1000, \"description\": null}', '8cf49535-878f-4f42-9198-aaf364198a9a', '2023-08-02 16:00:56', '2023-08-02 16:00:56', NULL),
(31, 'App\\Models\\User', 221, 187, 'withdraw', '-2760', 1, '{\"id\": null, \"type\": null, \"amount\": 2760, \"description\": null}', '8adcca7d-6e94-4c98-9f46-9a0743833874', '2023-08-03 14:17:10', '2023-08-03 14:17:10', NULL),
(32, 'App\\Models\\User', 230, 196, 'deposit', '50', 1, '{\"id\": null, \"type\": null, \"amount\": \"50\", \"description\": null}', '5773d0ff-26f8-4e17-90ae-df984fb8bc42', '2023-08-22 15:01:42', '2023-08-22 15:01:42', NULL),
(33, 'App\\Models\\User', 231, 197, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'b90e9c30-e9d2-4f2c-9f93-555c52c0ee08', '2023-08-29 14:33:14', '2023-08-29 14:33:14', NULL),
(34, 'App\\Models\\User', 232, 198, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '5c8f5238-2431-4bf1-a7bd-073ec0a6f280', '2023-08-29 22:11:08', '2023-08-29 22:11:08', NULL),
(35, 'App\\Models\\User', 233, 199, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'c93354f8-421a-4e98-8ada-114196b7cc0e', '2023-08-31 18:45:43', '2023-08-31 18:45:43', NULL),
(36, 'App\\Models\\User', 233, 199, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '85264681-6507-4105-90de-0ee973f37337', '2023-08-31 19:04:23', '2023-08-31 19:04:23', NULL),
(37, 'App\\Models\\User', 234, 200, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'ca3e696d-5331-4ff1-a135-1fd0714a5b85', '2023-08-31 19:10:56', '2023-08-31 19:10:56', NULL),
(38, 'App\\Models\\User', 235, 201, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '23d5d798-e28c-4dbd-878a-c2e75b528b5b', '2023-09-02 21:44:04', '2023-09-02 21:44:04', NULL),
(39, 'App\\Models\\User', 236, 202, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '84d7ecd0-5a15-4ddf-afa3-45d8af55dc7e', '2023-09-04 14:51:02', '2023-09-04 14:51:02', NULL),
(40, 'App\\Models\\User', 237, 203, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '2300c774-a983-4d96-af06-62cd2fb88dbd', '2023-09-04 16:05:24', '2023-09-04 16:05:24', NULL),
(41, 'App\\Models\\User', 238, 204, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '4fc94a6e-62c2-4ec4-8daf-fba32b247012', '2023-09-04 17:06:08', '2023-09-04 17:06:08', NULL),
(42, 'App\\Models\\User', 239, 205, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '34bb563b-3345-4bd8-8f45-9140017ce435', '2023-09-06 14:20:02', '2023-09-06 14:20:02', NULL),
(43, 'App\\Models\\User', 240, 206, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '77e355e9-7ec9-46e3-a255-7e2b3183b068', '2023-09-06 15:57:49', '2023-09-06 15:57:49', NULL),
(44, 'App\\Models\\User', 241, 207, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'fe9663bb-99fa-4173-a7ee-d930ab69d635', '2023-09-06 16:23:05', '2023-09-06 16:23:05', NULL),
(45, 'App\\Models\\User', 242, 208, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'e28211ab-36ee-4091-94ec-3ec675656890', '2023-09-06 16:31:42', '2023-09-06 16:31:42', NULL),
(46, 'App\\Models\\User', 243, 209, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '3aaa88d4-e614-4392-8d8f-6f979e45dd70', '2023-09-06 16:34:19', '2023-09-06 16:34:19', NULL),
(47, 'App\\Models\\User', 244, 210, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'ae1a9687-60e7-4aa1-a2d6-593b564d7370', '2023-09-06 17:18:58', '2023-09-06 17:18:58', NULL),
(48, 'App\\Models\\User', 244, 210, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '848f0dac-290c-4a32-a685-561e47ca116e', '2023-09-06 19:26:23', '2023-09-06 19:26:23', NULL),
(49, 'App\\Models\\User', 236, 202, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '8bdeb312-7065-4458-af1b-aee70ec2b6ec', '2023-09-07 16:11:26', '2023-09-07 16:11:26', NULL),
(50, 'App\\Models\\User', 245, 211, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'f69a6015-1dec-4a74-baf9-70e6f8fd74e7', '2023-09-08 14:27:01', '2023-09-08 14:27:01', NULL),
(51, 'App\\Models\\User', 246, 212, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '0def644f-ef53-4c9c-b873-e5428dd2e2da', '2023-09-08 15:51:00', '2023-09-08 15:51:00', NULL),
(52, 'App\\Models\\User', 247, 213, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'a1012555-b042-4553-8dfc-273d0fdb06a8', '2023-09-08 16:02:47', '2023-09-08 16:02:47', NULL),
(53, 'App\\Models\\User', 248, 214, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '81816156-9ee5-48e6-8ace-63f15b1a4d0a', '2023-09-08 16:08:00', '2023-09-08 16:08:00', NULL),
(54, 'App\\Models\\User', 248, 214, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'a549a8bf-ccca-41da-ab1f-d831b11fa555', '2023-09-08 22:24:30', '2023-09-08 22:24:30', NULL),
(55, 'App\\Models\\User', 253, 218, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '54f7e603-e889-40b8-8d3b-96aa17224f45', '2023-09-09 14:26:30', '2023-09-09 14:26:30', NULL),
(56, 'App\\Models\\User', 253, 218, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '087197f4-2807-46fe-bfa8-1f8369c1da40', '2023-09-12 21:23:15', '2023-09-12 21:23:15', NULL),
(57, 'App\\Models\\User', 246, 212, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '09664ba0-1fdd-4870-a7cc-1c8bebc0906f', '2023-09-26 18:53:35', '2023-09-26 18:53:35', NULL),
(58, 'App\\Models\\User', 255, 220, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '3ff437fc-cadf-4e01-a730-392a85a024ab', '2023-09-27 16:10:51', '2023-09-27 16:10:51', NULL),
(59, 'App\\Models\\User', 255, 220, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '4fc8e113-889f-42fa-b65c-86c0bc2d27cb', '2023-09-28 19:48:39', '2023-09-28 19:48:39', NULL),
(60, 'App\\Models\\User', 256, 221, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '8b726dd6-0452-452b-be88-d41e3587446b', '2023-10-04 19:06:44', '2023-10-04 19:06:44', NULL),
(61, 'App\\Models\\User', 257, 222, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'b0fa3a51-3622-4179-8b63-e4ac9c7b2b7d', '2023-10-10 15:14:08', '2023-10-10 15:14:08', NULL),
(62, 'App\\Models\\User', 258, 223, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'cc744ff6-7f24-470b-966d-49fd0561107c', '2023-10-10 15:43:45', '2023-10-10 15:43:45', NULL),
(63, 'App\\Models\\User', 259, 224, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '4acc71e9-63d3-4f4f-8d81-e18eadcb0649', '2023-10-11 20:05:29', '2023-10-11 20:05:29', NULL),
(64, 'App\\Models\\User', 261, 225, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '69436baf-b1ec-4a03-97ab-c049e328b574', '2023-10-13 20:18:06', '2023-10-13 20:18:06', NULL),
(65, 'App\\Models\\User', 262, 226, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '961f21d2-6b9f-4293-a4b6-b7c927e61bcd', '2023-10-13 20:20:30', '2023-10-13 20:20:30', NULL),
(66, 'App\\Models\\User', 263, 227, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '7f97d4e6-5f58-46ae-a462-a62de46f9750', '2023-10-13 20:25:26', '2023-10-13 20:25:26', NULL),
(67, 'App\\Models\\User', 264, 228, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '5f50e8b5-c2df-4dcb-aeb5-d43cf2ceeded', '2023-10-13 20:33:53', '2023-10-13 20:33:53', NULL),
(68, 'App\\Models\\User', 265, 229, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '1ac3f81c-80c9-4909-bee7-c7f022363215', '2023-10-13 20:35:04', '2023-10-13 20:35:04', NULL),
(69, 'App\\Models\\User', 266, 230, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '5977ba6b-2c2a-48b8-ac8b-ac666273bf0c', '2023-10-13 20:35:46', '2023-10-13 20:35:46', NULL),
(70, 'App\\Models\\User', 266, 230, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": 100, \"description\": null}', '13ae4a3d-2d54-4d8a-b9fe-505f04f90146', '2023-10-14 14:58:50', '2023-10-14 14:58:50', NULL),
(71, 'App\\Models\\User', 267, 231, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '74d7a97d-810a-4f5e-ada1-2650ad819d0e', '2023-10-14 15:16:29', '2023-10-14 15:16:29', NULL),
(72, 'App\\Models\\User', 268, 232, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '1350e42b-68aa-4eff-8412-729f8dc9f668', '2023-10-14 20:38:44', '2023-10-14 20:38:44', NULL),
(73, 'App\\Models\\User', 259, 224, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '9724fc12-12a9-4083-9acc-e056c68ce3f6', '2023-10-17 14:12:35', '2023-10-17 14:12:35', NULL),
(74, 'App\\Models\\User', 269, 233, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', 'ae69977b-dc18-42ac-b871-bda372b3770c', '2023-10-17 17:03:53', '2023-10-17 17:03:53', NULL),
(75, 'App\\Models\\User', 267, 231, 'withdraw', '-100', 1, '{\"id\": null, \"type\": null, \"amount\": 100, \"description\": null}', 'c16b8792-8cef-425f-9af4-37802ebf33e8', '2023-10-18 14:27:07', '2023-10-18 14:27:07', NULL),
(77, 'App\\Models\\User', 271, 235, 'deposit', '100', 1, '{\"id\": null, \"type\": null, \"amount\": \"100\", \"description\": null}', '103c3ef2-563e-46d6-9a4f-4b3ae25b43aa', '2024-07-15 01:42:18', '2024-07-15 01:42:18', NULL);

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` bigint UNSIGNED NOT NULL,
  `from_id` bigint UNSIGNED NOT NULL,
  `to_id` bigint UNSIGNED NOT NULL,
  `status` enum('exchange','transfer','paid','refund','gift') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'transfer',
  `status_last` enum('exchange','transfer','paid','refund','gift') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deposit_id` bigint UNSIGNED NOT NULL,
  `withdraw_id` bigint UNSIGNED NOT NULL,
  `discount` decimal(64,0) NOT NULL DEFAULT '0',
  `fee` decimal(64,0) NOT NULL DEFAULT '0',
  `extra` json DEFAULT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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` int NOT NULL,
  `user_id` int NOT NULL,
  `address_type` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `dialing_code` varchar(191) DEFAULT NULL,
  `pincode` varchar(50) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `country` varchar(191) DEFAULT NULL,
  `landmark` varchar(255) DEFAULT NULL,
  `alternate_number` varchar(50) DEFAULT NULL,
  `document` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `country_code` varchar(191) DEFAULT NULL,
  `state_code` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_addresses`
--

INSERT INTO `user_addresses` (`id`, `user_id`, `address_type`, `name`, `mobile`, `dialing_code`, `pincode`, `address`, `city`, `state`, `country`, `landmark`, `alternate_number`, `document`, `latitude`, `longitude`, `updated_at`, `country_code`, `state_code`) VALUES
(1, 82, 'Home', 'Diwakar', '8005562358', '+91', '313001', '359 University Road  Court Choraha', 'udaipur', 'Rajasthan', 'India', 'Shakti Nagar udaipur', NULL, NULL, NULL, NULL, '2023-05-19 14:15:08', NULL, NULL),
(2, 6, 'Office', 'Diwakar Vashisth', '8005562358', '+91', '313001', 'Post Office Road  ,Ashok Nagar', 'Udaipur Division', 'Rajasthan', 'India', 'Ashok Nagar', NULL, NULL, NULL, NULL, '2023-05-11 22:35:52', 'IN', 'RJ'),
(3, 6, 'Office', 'shahrukh', '9999999999', '+91', '313001', 'B.P.Joshi Marg  Bhupalpura', 'Udaipur Division', 'Rajasthan', 'India', 'poles', NULL, NULL, NULL, NULL, '2023-05-11 22:37:36', 'IN', 'RJ'),
(4, 6, 'Office', 'Rakesh sharma', '9999999999', '+91', '313001', 'Shakti Nagar Road  ,Shakti Nagar', 'Udaipur Division', 'Rajasthan', 'India', 'Shakti Nagar', NULL, NULL, NULL, NULL, '2023-05-11 22:37:17', 'IN', 'RJ'),
(5, 14, 'Office', 'harish kumar', '99988877771', '+91', '313003', '0000    ,Manksok', 'Udaipur Division', 'Rajasthan', 'India', 'Manksok', NULL, NULL, NULL, NULL, '2023-05-13 22:27:06', 'IN', 'RJ'),
(6, 15, 'Home', 'arjun', '9998887772', '+91', '313324', 'Varma petrol pump Bhagwandas Market,Kankroli', 'Udaipur Division', 'Rajasthan', 'India', 'Kankroli', NULL, NULL, NULL, NULL, '2023-05-15 04:14:51', 'IN', 'RJ'),
(9, 9, 'office', 'Rupendra', '1234567890', '+91', '313001', 'sector 14 dkshin vihar near main road', 'udaipur', 'Rajasthan', 'India', 'clocktower', NULL, NULL, NULL, NULL, '2023-05-17 20:25:50', 'india', 'RJ'),
(11, 8, 'Office', 'rakesh', '6363636363', '+91', '1234567', 'bandra road', 'mumbai', 'Maharastra', 'India', 'hospital', NULL, NULL, NULL, NULL, '2023-05-19 16:20:57', 'IN', 'MH'),
(12, 20, 'Office', 'vimal', '9929545422', '+91', '313001', '214B    Sardarpura,Panchwati', 'Udaipur Division', 'Rajasthan', 'India', 'Panchwati', NULL, NULL, NULL, NULL, '2023-05-19 16:33:25', 'IN', 'RJ'),
(15, 81, 'home', 'raj singhania', '9998887777', '+91', '123456', 'hathipole outside', 'udaipur', 'rajasthan', 'India', 'shopiing mall', NULL, NULL, NULL, NULL, '2023-05-23 18:29:33', NULL, NULL),
(16, 76, 'home', 'dknksjdfnk', '46444949498', '+91', '313001', 'delhi gate', 'udaipur', 'rajasthan', 'India', 'pole', NULL, NULL, NULL, NULL, '2023-05-24 14:07:11', 'IN', 'RJ'),
(17, 82, 'office', 'Nanci Kabra', '9521867740', '+91', '313003', 'Antrim', 'Udaipur', 'Rajasthan', 'India', 'Lodha Complex', NULL, NULL, NULL, NULL, '2023-05-24 14:39:19', '+91', '08'),
(18, 68, 'home', 'rakesh ji', '9998887776', '+91', '313001', 'my test address', 'udaipur', 'rajasthan', 'India', 'electric board', NULL, NULL, NULL, NULL, '2023-05-25 14:16:39', 'IN', 'rj'),
(19, 33, 'home', 'nskdfnijf', '25164564151', '+91', '313001', 'addresss data', 'rajkot', 'gujrat', 'India', 'shop', NULL, NULL, NULL, NULL, '2023-05-25 21:39:48', 'IN', 'rajasthan'),
(21, 194, 'Home', 'yesh', '7014327528', '+91', '313001', 'ashok Nagar', 'udaipur', 'Rajasthan', 'india', 'udaipur', NULL, NULL, NULL, NULL, '2023-06-15 21:18:49', 'IND', 'RJ'),
(23, 194, 'Home', 'Sunny', '9856321456', '+91', '452001', 'udaipur', 'udr', 'rj', 'Ins', 'udr', NULL, NULL, NULL, NULL, '2023-06-26 15:23:44', '08', 'rj'),
(24, 194, 'Office', 'Alhilesh', '9856321456', '+91', '400080', 'udr', 'udr', 'rj', 'Ind', 'udr', NULL, NULL, NULL, NULL, '2023-06-26 15:31:16', '91', '08'),
(25, 200, 'Home', 'yogesh', '7897894561', '+91', '313001', 'Ashok Nagar', 'Udaipur', 'rajasthan', 'india', 'Ashok Nagar', NULL, NULL, NULL, NULL, '2023-07-06 13:26:06', 'ind', 'rj'),
(26, 1, 'home', 'Suraj', '9877898778', '+91', '452001', 'Shimla', 'Udaipur', 'Rajasthan', 'India', 'near temple', NULL, NULL, NULL, NULL, '2023-07-06 19:12:26', 'IND', '08'),
(27, 203, 'Home', 'rohan', '8523694535', '+91', '313001', 'Ashok Nagar', 'Udaipur', 'rajasthan', 'india', 'Udaipur', NULL, NULL, NULL, NULL, '2023-07-06 21:56:53', 'ind', 'rj'),
(28, 206, 'office', 'Mohit', '8769337612', NULL, '313001', 'Sector-14 Hiran Magri', 'Udaipur', 'Rajasthan', 'India', 'Sector-14', NULL, NULL, NULL, NULL, '2023-07-07 16:17:32', 'IND', '27'),
(29, 207, 'home', 'Amar', '7865498765', '+91', '462001', 'Bhopal', 'Bhopal', 'MP', 'India', 'Beside temple', NULL, NULL, NULL, NULL, '2023-07-07 21:51:15', 'Ind', 'Rajasthan'),
(30, 209, 'Home', 'Gaurav', '9857286032', '+91', '543008', 'udr', 'udr', 'raj', 'India', 'behind temple', NULL, NULL, NULL, NULL, '2023-07-08 16:49:18', 'Ind', '08'),
(31, 212, 'office', 'abc', '1234567890', '+91', '313001', 'delhi gate', 'udaipur', 'rajasthan', 'India', 'abc', NULL, NULL, NULL, NULL, '2023-07-10 16:48:06', '12345', '123456'),
(33, 200, 'Home', 'yesh', '7897894561', '+91', '341510', 'Ashok Nagar', 'Udaipur', 'rajasthan', 'india', 'shastri circle', NULL, NULL, NULL, NULL, '2023-07-15 16:04:20', 'ind', 'rj'),
(42, 194, 'home', 'abxfsdfsd', '1234567890', '+91', '313001', 'sfsfsdf', 'ud', 'rj', 'India', 'abs', NULL, NULL, NULL, NULL, '2023-07-19 15:55:41', '123432', '32112'),
(43, 194, 'home', 'sas', '12345678901', '+91', '313001', 'asasasa', 'ud', 'rj', 'India', 'qswedfg', NULL, NULL, NULL, NULL, '2023-07-19 16:04:33', '324523', '333214'),
(44, 213, 'home', 'abcd', '1234567891', '+91', '313002', 'addfder', 'udr', 'rj', 'India', 'asdfsdfs', NULL, NULL, NULL, NULL, '2023-07-20 19:21:08', '645', '321'),
(45, 194, 'home', 'Harshad', '7014327528', '+91', '452001', 'Udaipur', 'Udaipur', 'Rajasthan', 'India', 'Temple', NULL, NULL, NULL, NULL, '2023-07-21 21:56:03', 'IND', 'RJ'),
(47, 217, 'home', 'mno', '1231231233', '+91', '313002', '101,mno', 'Udaipur', 'Rajasthan', 'India', '9454', NULL, NULL, NULL, NULL, '2023-07-24 14:45:17', '22', '11'),
(48, 13, 'home', 'abcd', '1231231233', '+91', '313002', '101,asfsf', 'ud', 'rj', 'India', '101', NULL, NULL, NULL, NULL, '2023-07-24 15:39:55', 'cc01', 'sc01'),
(49, 217, 'home', 'abcdefgh', '1231231231', '+91', '313001', '20,delhi gate', 'UD', 'Rj', 'India', '101', NULL, NULL, NULL, NULL, '2023-07-25 20:30:08', 'cc101', 'sc101'),
(50, 216, 'Office', 'ffg', '9856321452', '+91', '313002', 'ff', 'ffjk', 'bbjk', 'bbbb', 'fgjj', NULL, NULL, NULL, NULL, '2023-07-28 22:10:03', 'hhhb', 'fhjj'),
(51, 219, 'home', 'rohanmohan', '2587456942', '+91', '313001', '1330,abckd address', 'UD', 'RJ', 'India', 'UDRJ', NULL, NULL, NULL, NULL, '2023-07-28 22:12:27', 'CC', 'SC'),
(52, 221, 'Home', 'ramesh', '3214569870', '+91', '313001', 'Ashok Nagar', 'Udaipur', 'rajasthan', 'india', 'sastri cercle', NULL, NULL, NULL, NULL, '2023-07-29 13:32:34', 'ind', 'rj'),
(53, 13, 'home', 'Tushar', '7867867865', '+91', '452001', 'faridabad', 'faridabad', 'UP', 'India', 'Sai temple', NULL, NULL, NULL, NULL, '2023-08-04 20:51:31', 'dd', '09'),
(54, 217, 'office', 'abcd', '1236547895', '+91', '313001', '200, abcdef', 'udz', 'raj', 'India', '12abc', NULL, NULL, NULL, NULL, '2023-08-09 21:18:53', '3232323', '3232fdf'),
(55, 221, 'Home', 'yesh', '3214569870', '+91', '341510', 'sastri cercle', 'Udaipur', 'rajasthan', 'india', 'sastri cercle', NULL, NULL, NULL, NULL, '2023-08-11 15:29:48', 'ind', 'rj'),
(56, 220, 'Home', 'Devendra', '1234567890', '+91', '452001', 'udr', 'udr', 'rj', 'India', 'behind temple', NULL, NULL, NULL, NULL, '2023-08-12 15:23:15', 'IN', 'rj'),
(57, 221, 'Home', 'yesh', '1234567890', '+91', '341510', 'ashok travels', 'udaipur', 'Rajasthan', 'india', 'sastri cercle', NULL, NULL, NULL, NULL, '2023-08-12 16:39:56', 'ind', 'rj'),
(58, 227, 'Home', 'Taj', '9874563217', '+91', '452001', 'udr', 'udr', 'rj', 'Ind', 'Behind temple', NULL, NULL, NULL, NULL, '2023-08-12 18:32:23', 'IN', 'rj'),
(59, 228, 'Home', 'dudud', '6059874563', '+91', '452001', 'jxxud', 'gghhh', 'ghh', 'huh', 'hhhhh', NULL, NULL, NULL, NULL, '2023-08-12 22:02:18', '555', 'yyy'),
(60, 221, 'Home', 'yeshvi', '3214569870', '+91', '313001', 'Ashok Nagar', 'Udaipur', 'rajasthan', 'india', 'sastri cercle', NULL, NULL, NULL, NULL, '2023-08-17 16:33:04', NULL, NULL),
(64, 233, 'home', 'Rahul', '7555193211', '+91', '312604', 'near mandir', 'Chhoti Sadri', 'rajasthan', 'India', 'near school', NULL, NULL, NULL, NULL, '2023-08-31 19:01:50', '+91', '312604'),
(65, 234, 'office', 'abc', '1234567890', NULL, '313001', 'adres acb', 'udz', 'raj', 'india', 'aerelt', NULL, NULL, NULL, NULL, '2023-08-31 22:00:19', 'abc1234', 'abc123'),
(66, 231, 'Home', 'Abbas', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-02 15:08:49', 'india', 'RJ'),
(68, 235, 'home', 'puja', '7428730894', '+91', '312604', 'new colony', 'chhoti sadri', 'rajasthan', 'India', 'near school', NULL, NULL, NULL, NULL, '2023-09-02 21:48:06', 'India', 'Rajasthan'),
(70, 236, 'home', 'Puja', '9090307842', '+91', '312604', 'new colony road', 'chhoti sadri', 'rajasthan', 'India', 'near mandir', NULL, NULL, NULL, NULL, '2023-09-04 16:38:23', '+91', 'RJ'),
(71, 237, 'Home', 'Abbas', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-04 16:47:38', 'india', 'RJ'),
(72, 238, 'Home', 'Abbas', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-04 17:11:43', 'india', 'RJ'),
(73, 239, 'Home', 'Abbas Bohra', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-06 14:22:12', 'india', 'RJ'),
(74, 240, 'home', 'Abbas Bohra', '8890972919', '+91', '312604', 'Bohar mata road', 'Chhoti Sadri', 'Rajasthan', 'India', 'near mandir', NULL, NULL, NULL, NULL, '2023-09-06 16:00:56', '+91', 'RJ'),
(75, 241, 'home', 'rahul', '7073197917', '+91', '313001', 'old city', 'udaipur', 'rajasthan', 'India', 'near cafe', NULL, NULL, NULL, NULL, '2023-09-06 16:44:22', '+91', 'RJ'),
(76, 243, 'Home', 'Mohit', '88909726369', '+91', '313001', 'Basti ram ji badi', 'Udaipur', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-06 16:46:03', 'india', 'RJ'),
(77, 244, 'Home', 'Abbas Bohra', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-06 17:23:26', 'india', 'RJ'),
(78, 236, 'home', 'ABBAS BOHRA', '8890972919', '+91', '312604', 'NEW COLONY ROAD', 'CHHOTI SADRI', 'RAJASTHAN', 'India', 'NEAR MANDIR', NULL, NULL, NULL, NULL, '2023-09-06 19:00:40', 'india', 'RJ'),
(79, 248, 'Home', 'Abbas Bohra', '8890972919', '+91', '312604', 'New abadi', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-08 16:10:10', 'india', 'RJ'),
(80, 248, 'Office', 'mustafa bohra', '7726830053', '+91', '313201', 'dholapani dawaza', 'bari sadri', 'rajasthan', 'india', 'near school', NULL, NULL, NULL, NULL, '2023-09-08 19:10:56', 'india', 'RJ'),
(81, 253, 'Home', 'Priya', '9680324648', '+91', '313001', 'Basti ram ji badi', 'Udaipur', 'Rajasthan', 'india', 'Near nai wada chowk', NULL, NULL, NULL, NULL, '2023-09-09 17:05:41', 'india', 'RJ'),
(82, 13, 'office', 'imroz', '1234567890', NULL, '313001', 'udaipur', 'udaipur', 'rajasthan', 'IN', 'abc', NULL, NULL, NULL, NULL, '2023-09-26 15:46:47', '+91', '123456'),
(83, 246, 'Home', 'Abbas', '8890972919', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-09-26 16:57:55', 'india', 'RJ'),
(87, 255, 'Home', 'Rahul', '9001710089', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-10-04 18:59:03', 'india', 'RJ'),
(88, 256, 'Home', 'Priya', '8529069305', '+91', '312604', 'Aajad pura.', 'Barisadri', 'Rajasthan', 'india', 'Near talab', NULL, NULL, NULL, NULL, '2023-10-04 19:13:35', 'india', 'RJ'),
(89, 256, 'Home', 'Abbas', '8824064290', '+91', '312604', 'Bhawar mata road', 'Chhoti sadri', 'Rajasthan', 'india', 'Near mandir', NULL, NULL, NULL, NULL, '2023-10-07 16:42:05', NULL, NULL),
(90, 246, 'Home', 'rahul', '8890972919', '+91', '312604', 'bhawar mata road', 'chhoti sadri', 'Rajasthan', 'India', 'near mandir', NULL, NULL, NULL, NULL, '2023-10-11 19:32:30', 'india', 'RJ'),
(91, 246, 'Home', 'priya', '9680355253', '+91', '313001', 'hathi pole basti ram ji ki badi', 'udaipur', 'Rajasthan', 'India', 'nai wada chowk', NULL, NULL, NULL, NULL, '2023-10-11 19:36:58', 'india', 'RJ'),
(92, 246, 'Home', 'prakash', '9685741325', '+91', '322015', 'nera mandir', 'bhilwara', 'Haryana', 'India', 'near road', NULL, NULL, NULL, NULL, '2023-10-11 19:51:37', 'india', 'HR'),
(93, 259, 'Home', 'Hozefa', '9660598862', '+91', '312604', 'School road', 'Chhoti sadri', 'Rajasthan', 'India', 'Near school', NULL, NULL, NULL, NULL, '2023-10-11 20:08:29', 'india', 'RJ'),
(95, 259, 'Home', 'Abbas', '8990972919', '+91', '312604', 'Nearby', 'Chhoti sadri', 'Rajasthan', 'India', 'Near mandir', NULL, NULL, NULL, NULL, '2023-10-11 20:18:47', 'india', 'RJ'),
(96, 266, 'Office', 'juber Sheikh', '7976280867', '+91', '313001', 'near court cohraha', 'Udaipur', 'rajasthan', 'India', 'Lodha complex', NULL, NULL, NULL, NULL, '2023-10-14 13:54:57', 'in', 'RJ'),
(97, 267, 'Home', 'dd', '8888888888', '+91', '458001', 'fhnnm', 'ghj', 'Haryana', NULL, 'ghh', NULL, NULL, NULL, NULL, '2023-10-14 15:18:29', NULL, NULL),
(98, 268, 'Home', 'juber', '7976280867', '+91', '313001', 'near post office', 'Udaipur', 'rajasthan', 'India', 'near court cohraha', NULL, NULL, NULL, NULL, '2023-10-17 14:36:39', 'In', 'RJ'),
(99, 269, 'Home', 'Aditya kumar', '6377181950', '+91', '312604', 'Loadha comlex', 'Udaipur', 'Chhattisgarh', 'India', 'Near court', NULL, NULL, NULL, NULL, '2023-10-17 17:21:46', 'india', 'GJ');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint UNSIGNED NOT NULL,
  `holder_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `holder_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` json DEFAULT NULL,
  `balance` decimal(64,0) NOT NULL DEFAULT '0',
  `decimal_places` smallint UNSIGNED NOT NULL 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;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `holder_type`, `holder_id`, `name`, `slug`, `uuid`, `description`, `meta`, `balance`, `decimal_places`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'App\\Models\\User', 3, 'Default Wallet', 'default', '0bb1b706-cbb5-4d55-be10-f9b3bd815627', NULL, '[]', '0', 2, '2023-05-10 15:24:00', '2023-05-10 15:24:00', NULL),
(2, 'App\\Models\\User', 2, 'Default Wallet', 'default', 'e5090dff-4212-4b8a-be14-84fbafe66948', NULL, '[]', '32', 2, '2023-05-10 15:24:00', '2023-05-10 16:26:38', NULL),
(3, 'App\\Models\\User', 1, 'Default Wallet', 'default', 'f58de052-4324-4044-a4cd-d9eaa1808c68', NULL, '[]', '0', 2, '2023-05-10 15:30:03', '2023-05-10 15:30:03', NULL),
(4, 'App\\Models\\User', 4, 'Default Wallet', 'default', '1ee6d0bb-4310-4407-a498-818b9d6f3ea7', NULL, '[]', '0', 2, '2023-05-10 16:16:53', '2023-05-10 16:16:53', NULL),
(5, 'App\\Models\\User', 5, 'Default Wallet', 'default', '82742410-d19d-4681-9d2f-8379f1a862e4', NULL, '[]', '0', 2, '2023-05-11 19:11:53', '2023-05-11 19:11:53', NULL),
(6, 'App\\Models\\User', 6, 'Default Wallet', 'default', '53639cbf-ced7-44be-ab24-e276dabe1195', NULL, '[]', '0', 2, '2023-05-11 22:34:26', '2023-05-11 22:34:26', NULL),
(7, 'App\\Models\\User', 7, 'Default Wallet', 'default', 'b67b0527-b800-4071-8fdf-b755bcc11126', NULL, '[]', '0', 2, '2023-05-12 16:44:51', '2023-05-12 16:44:51', NULL),
(8, 'App\\Models\\User', 8, 'Default Wallet', 'default', 'e3ccf100-d841-4423-aa53-724f08ae19fe', NULL, '[]', '0', 2, '2023-05-12 19:00:00', '2023-05-12 19:00:00', NULL),
(9, 'App\\Models\\User', 9, 'Default Wallet', 'default', '6e5f899d-2485-44f9-94b4-bf9cf8f78e96', NULL, '[]', '0', 2, '2023-05-12 19:19:59', '2023-05-12 19:19:59', NULL),
(10, 'App\\Models\\User', 13, 'Default Wallet', 'default', '173b0848-e13b-45ed-9bbb-fad12c6c9df5', NULL, '[]', '0', 2, '2023-05-13 20:49:54', '2023-08-02 16:00:56', NULL),
(11, 'App\\Models\\User', 14, 'Default Wallet', 'default', '9b33fae6-ed61-4e73-ac1a-938dca33e6e6', NULL, '[]', '0', 2, '2023-05-13 22:25:23', '2023-05-13 22:25:23', NULL),
(12, 'App\\Models\\User', 12, 'Default Wallet', 'default', 'db2343c6-d14b-4543-a679-d20658f23e7b', NULL, '[]', '0', 2, '2023-05-15 03:29:36', '2023-05-15 03:29:36', NULL),
(13, 'App\\Models\\User', 11, 'Default Wallet', 'default', '19251fc9-d0f5-472a-8076-d2a7bdc760a7', NULL, '[]', '0', 2, '2023-05-15 03:29:36', '2023-05-15 03:29:36', NULL),
(14, 'App\\Models\\User', 10, 'Default Wallet', 'default', 'da99f2e2-255c-4cea-8e22-be0fa5668327', NULL, '[]', '0', 2, '2023-05-15 03:29:36', '2023-05-15 03:29:36', NULL),
(15, 'App\\Models\\User', 15, 'Default Wallet', 'default', 'c7880cf5-1fe3-4085-a5da-05eeda3b9c04', NULL, '[]', '0', 2, '2023-05-15 04:12:44', '2023-05-15 04:12:44', NULL),
(16, 'App\\Models\\User', 16, 'Default Wallet', 'default', 'f255d86c-9f5a-49e3-890f-2fb244622125', NULL, '[]', '0', 2, '2023-05-16 15:11:35', '2023-05-16 15:11:35', NULL),
(17, 'App\\Models\\User', 17, 'Default Wallet', 'default', '460ace87-972e-4f3c-b80a-4e9723f1ba26', NULL, '[]', '0', 2, '2023-05-17 15:31:43', '2023-05-17 15:31:43', NULL),
(18, 'App\\Models\\User', 18, 'Default Wallet', 'default', '6f6e8bf7-ca04-45f3-b4fb-edac43b10dcb', NULL, '[]', '0', 2, '2023-05-17 15:36:17', '2023-05-17 15:36:17', NULL),
(19, 'App\\Models\\User', 19, 'Default Wallet', 'default', 'b2dc7f6a-6a2f-4127-8565-ca30f772c6f7', NULL, '[]', '0', 2, '2023-05-19 16:00:31', '2023-05-19 16:00:31', NULL),
(20, 'App\\Models\\User', 20, 'Default Wallet', 'default', 'b1c033d9-5ab6-4544-bcbe-5651077e10f3', NULL, '[]', '0', 2, '2023-05-19 16:27:01', '2023-05-19 16:27:01', NULL),
(21, 'App\\Models\\User', 21, 'Default Wallet', 'default', '06423a59-4bcb-4215-a515-c26da6bd4c84', NULL, '[]', '0', 2, '2023-05-19 16:27:27', '2023-05-19 16:27:27', NULL),
(22, 'App\\Models\\User', 22, 'Default Wallet', 'default', 'f24b87e8-1f60-4e13-9025-714c991550e1', NULL, '[]', '0', 2, '2023-05-19 16:31:07', '2023-05-19 16:31:07', NULL),
(23, 'App\\Models\\User', 23, 'Default Wallet', 'default', '0689affd-63c3-4b01-b962-2467ae865d27', NULL, '[]', '0', 2, '2023-05-19 16:35:53', '2023-05-19 16:35:53', NULL),
(24, 'App\\Models\\User', 24, 'Default Wallet', 'default', 'ce2164f0-5a4d-4423-b69a-35b5bc0c0e29', NULL, '[]', '0', 2, '2023-05-19 17:31:07', '2023-05-19 17:31:07', NULL),
(25, 'App\\Models\\User', 26, 'Default Wallet', 'default', '5e316447-04e0-4dd4-b212-6c562cd0cea7', NULL, '[]', '0', 2, '2023-05-19 19:20:40', '2023-05-19 19:20:40', NULL),
(26, 'App\\Models\\User', 27, 'Default Wallet', 'default', '4b9ef76e-15ee-4403-b98d-4eca0a73a641', NULL, '[]', '0', 2, '2023-05-19 19:29:34', '2023-05-19 19:29:34', NULL),
(27, 'App\\Models\\User', 31, 'Default Wallet', 'default', '8a16ecbc-6cfa-41c9-932c-fef6ffe3f1ac', NULL, '[]', '0', 2, '2023-05-19 20:43:19', '2023-05-19 20:43:19', NULL),
(28, 'App\\Models\\User', 32, 'Default Wallet', 'default', '1cd7b636-e395-45b6-9d9b-cf02e723f692', NULL, '[]', '0', 2, '2023-05-19 20:46:01', '2023-05-19 20:46:01', NULL),
(29, 'App\\Models\\User', 33, 'Default Wallet', 'default', '76c7f1cd-b3aa-4bd9-8076-f88372d67329', NULL, '[]', '0', 2, '2023-05-19 22:18:48', '2023-05-19 22:18:48', NULL),
(30, 'App\\Models\\User', 34, 'Default Wallet', 'default', '234e919b-1669-4b86-9459-f5792ce322e5', NULL, '[]', '0', 2, '2023-05-19 22:44:30', '2023-05-19 22:44:30', NULL),
(31, 'App\\Models\\User', 35, 'Default Wallet', 'default', 'cca1e3e5-bcec-4289-8f9a-c51f1d3d817a', NULL, '[]', '0', 2, '2023-05-20 13:25:08', '2023-05-20 13:25:08', NULL),
(32, 'App\\Models\\User', 36, 'Default Wallet', 'default', 'f7abf33a-fb20-453f-8cca-bb8fcba58b31', NULL, '[]', '0', 2, '2023-05-20 13:25:52', '2023-05-20 13:25:52', NULL),
(33, 'App\\Models\\User', 37, 'Default Wallet', 'default', '8358700f-1b4a-439c-a294-67ac74e7bcd5', NULL, '[]', '0', 2, '2023-05-20 13:26:37', '2023-05-20 13:26:37', NULL),
(34, 'App\\Models\\User', 38, 'Default Wallet', 'default', 'b47b93a4-6bcf-4d4d-a5bd-68c677cee0c0', NULL, '[]', '0', 2, '2023-05-20 13:27:20', '2023-05-20 13:27:20', NULL),
(35, 'App\\Models\\User', 39, 'Default Wallet', 'default', 'd2db28d7-7e19-4cd5-927e-283eb8a2e075', NULL, '[]', '0', 2, '2023-05-20 13:28:57', '2023-05-20 13:28:57', NULL),
(36, 'App\\Models\\User', 40, 'Default Wallet', 'default', '38e96d00-a9b9-43c3-a40e-5a2b93ac00bb', NULL, '[]', '0', 2, '2023-05-20 14:00:16', '2023-05-20 14:00:16', NULL),
(37, 'App\\Models\\User', 41, 'Default Wallet', 'default', '7c24ee87-18f1-48c6-83e1-baa452d922a7', NULL, '[]', '0', 2, '2023-05-20 14:16:11', '2023-05-20 14:16:11', NULL),
(38, 'App\\Models\\User', 42, 'Default Wallet', 'default', '8f1a8292-0908-4817-8148-da14dfca7430', NULL, '[]', '0', 2, '2023-05-20 14:37:56', '2023-05-20 14:37:56', NULL),
(39, 'App\\Models\\User', 43, 'Default Wallet', 'default', 'e1205e4f-8e3e-46ba-b5db-75ef542c1ba2', NULL, '[]', '0', 2, '2023-05-20 14:38:49', '2023-05-20 14:38:49', NULL),
(40, 'App\\Models\\User', 44, 'Default Wallet', 'default', 'f7c9bc6a-2ed9-451f-b399-bc62257439f1', NULL, '[]', '0', 2, '2023-05-20 14:52:04', '2023-05-20 14:52:04', NULL),
(41, 'App\\Models\\User', 45, 'Default Wallet', 'default', '692dc667-5b27-4ceb-837e-52a1a2f3b74d', NULL, '[]', '0', 2, '2023-05-20 14:53:25', '2023-05-20 14:53:25', NULL),
(42, 'App\\Models\\User', 46, 'Default Wallet', 'default', '9102f6c3-cb4e-45f9-96fa-1202061541e8', NULL, '[]', '0', 2, '2023-05-20 14:55:30', '2023-05-20 14:55:30', NULL),
(43, 'App\\Models\\User', 47, 'Default Wallet', 'default', '9ba51a0e-bd46-4036-a124-b192c9dba8b9', NULL, '[]', '0', 2, '2023-05-20 14:57:05', '2023-05-20 14:57:05', NULL),
(44, 'App\\Models\\User', 48, 'Default Wallet', 'default', '8b148984-450b-4330-bf58-f1731b3a51ce', NULL, '[]', '0', 2, '2023-05-20 15:13:15', '2023-05-20 15:13:15', NULL),
(45, 'App\\Models\\User', 49, 'Default Wallet', 'default', '8cd4d041-41af-4cb2-a5d4-7ef2299fb7bf', NULL, '[]', '0', 2, '2023-05-20 15:14:27', '2023-05-20 15:14:27', NULL),
(46, 'App\\Models\\User', 50, 'Default Wallet', 'default', 'fd7400c5-d174-48f1-b851-c42c3eaca47a', NULL, '[]', '0', 2, '2023-05-20 15:18:51', '2023-05-20 15:18:51', NULL),
(47, 'App\\Models\\User', 51, 'Default Wallet', 'default', 'ee4c3d8a-4813-4741-b69a-7a47849318ec', NULL, '[]', '0', 2, '2023-05-20 15:25:02', '2023-05-20 15:25:02', NULL),
(48, 'App\\Models\\User', 52, 'Default Wallet', 'default', 'f25d4bbe-85cd-4353-b6c5-3f753b0cea52', NULL, '[]', '0', 2, '2023-05-20 15:28:10', '2023-05-20 15:28:10', NULL),
(49, 'App\\Models\\User', 53, 'Default Wallet', 'default', '39582611-b9d1-4d38-8a8d-554d9411be67', NULL, '[]', '0', 2, '2023-05-20 15:31:25', '2023-05-20 15:31:25', NULL),
(50, 'App\\Models\\User', 54, 'Default Wallet', 'default', 'e31f62fc-1170-40d2-8569-db5dff54ab89', NULL, '[]', '0', 2, '2023-05-20 15:36:24', '2023-05-20 15:36:24', NULL),
(51, 'App\\Models\\User', 55, 'Default Wallet', 'default', '6b3ef382-2f58-47f5-bcd2-86538a4ca831', NULL, '[]', '0', 2, '2023-05-20 16:04:47', '2023-05-20 16:04:47', NULL),
(52, 'App\\Models\\User', 56, 'Default Wallet', 'default', '302ee4bf-df89-4501-b371-9545753449b4', NULL, '[]', '0', 2, '2023-05-20 16:06:11', '2023-05-20 16:06:11', NULL),
(53, 'App\\Models\\User', 60, 'Default Wallet', 'default', 'a7242d62-570e-4bf2-bcac-351c9aca79ee', NULL, '[]', '0', 2, '2023-05-20 16:24:08', '2023-05-20 16:24:08', NULL),
(54, 'App\\Models\\User', 61, 'Default Wallet', 'default', 'c3bbe3a0-b660-4946-9a6c-e2fca447fba4', NULL, '[]', '0', 2, '2023-05-20 16:24:38', '2023-05-20 16:24:38', NULL),
(55, 'App\\Models\\User', 62, 'Default Wallet', 'default', 'bec9a492-75f7-4965-a686-b509d41f6db3', NULL, '[]', '0', 2, '2023-05-20 16:27:07', '2023-05-20 16:27:07', NULL),
(56, 'App\\Models\\User', 63, 'Default Wallet', 'default', 'a1ba8f0d-9b2c-46b2-b595-dd82eebfdef2', NULL, '[]', '0', 2, '2023-05-20 16:33:43', '2023-05-20 16:33:43', NULL),
(57, 'App\\Models\\User', 64, 'Default Wallet', 'default', '18fab624-de21-4892-95a6-aad7303e5a5a', NULL, '[]', '0', 2, '2023-05-20 16:43:00', '2023-05-20 16:43:00', NULL),
(58, 'App\\Models\\User', 65, 'Default Wallet', 'default', '8d52a697-fc44-4644-8f46-4cb3a02ae8bb', NULL, '[]', '0', 2, '2023-05-20 17:05:04', '2023-05-20 17:05:04', NULL),
(59, 'App\\Models\\User', 66, 'Default Wallet', 'default', 'a8a58925-096b-4ca7-bfea-47cbaebd9108', NULL, '[]', '0', 2, '2023-05-20 17:05:39', '2023-05-20 17:05:39', NULL),
(60, 'App\\Models\\User', 67, 'Default Wallet', 'default', '50082e58-d675-4fa6-90a2-6073ea4c1033', NULL, '[]', '0', 2, '2023-05-20 17:23:35', '2023-05-20 17:23:35', NULL),
(61, 'App\\Models\\User', 59, 'Default Wallet', 'default', 'd0d4e1ea-cde7-46a5-829f-f2530b2688f5', NULL, '[]', '0', 2, '2023-05-20 18:39:50', '2023-05-20 18:39:50', NULL),
(62, 'App\\Models\\User', 58, 'Default Wallet', 'default', '40f51465-d5e7-45d2-8465-51495395709b', NULL, '[]', '0', 2, '2023-05-20 18:39:50', '2023-05-20 18:39:50', NULL),
(63, 'App\\Models\\User', 57, 'Default Wallet', 'default', '94399268-493b-402d-87ee-0f0d305c99a8', NULL, '[]', '0', 2, '2023-05-20 18:39:50', '2023-05-20 18:39:50', NULL),
(64, 'App\\Models\\User', 68, 'Default Wallet', 'default', 'b4a3dfb5-1ff7-4314-9446-2c5b5d17bff8', NULL, '[]', '0', 2, '2023-05-20 19:18:50', '2023-05-20 19:18:50', NULL),
(65, 'App\\Models\\User', 69, 'Default Wallet', 'default', '5c94f35d-cab0-460c-b6f0-25b4ba9b6701', NULL, '[]', '0', 2, '2023-05-20 19:22:01', '2023-05-20 19:22:01', NULL),
(66, 'App\\Models\\User', 70, 'Default Wallet', 'default', '593b0a7d-0e3d-4e16-a8a4-7651bfac6425', NULL, '[]', '0', 2, '2023-05-20 19:23:26', '2023-05-20 19:23:26', NULL),
(67, 'App\\Models\\User', 72, 'Default Wallet', 'default', '79ccf718-a0cc-492c-ad93-957a045979d8', NULL, '[]', '0', 2, '2023-05-20 21:00:26', '2023-05-20 21:00:26', NULL),
(68, 'App\\Models\\User', 76, 'Default Wallet', 'default', 'ed4b9738-94ed-49f0-81f6-4d4e6a8bb671', NULL, '[]', '0', 2, '2023-05-20 21:05:46', '2023-05-20 21:05:46', NULL),
(69, 'App\\Models\\User', 80, 'Default Wallet', 'default', 'd754b6f9-23d8-4a59-aa63-5426185e0ea6', NULL, '[]', '0', 2, '2023-05-22 19:46:15', '2023-05-22 19:46:15', NULL),
(70, 'App\\Models\\User', 81, 'Default Wallet', 'default', '7e6da11d-7eff-4874-9601-c600d412433c', NULL, '[]', '0', 2, '2023-05-23 18:21:47', '2023-05-23 18:21:47', NULL),
(71, 'App\\Models\\User', 82, 'Default Wallet', 'default', 'e4cc91ce-414f-4c88-93a2-0ed2e1762c7c', NULL, '[]', '1000', 2, '2023-05-23 19:17:53', '2023-05-23 19:17:53', NULL),
(72, 'App\\Models\\User', 83, 'Default Wallet', 'default', '2df6dfa9-4704-41da-b0c9-add3fcf1f7da', NULL, '[]', '100', 2, '2023-05-23 21:48:00', '2023-05-23 21:56:19', NULL),
(73, 'App\\Models\\User', 84, 'Default Wallet', 'default', 'c85e481f-b9e8-4035-b15f-49d6442565a6', NULL, '[]', '0', 2, '2023-05-24 14:07:07', '2023-05-24 14:07:07', NULL),
(74, 'App\\Models\\User', 85, 'Default Wallet', 'default', '5b9ac751-0f29-41fb-8a40-fe1c30fe45eb', NULL, '[]', '0', 2, '2023-05-24 14:10:30', '2023-05-24 14:10:30', NULL),
(75, 'App\\Models\\User', 86, 'Default Wallet', 'default', 'e3f69d02-468e-4081-a587-e6c8dd121ec3', NULL, '[]', '0', 2, '2023-05-24 14:11:10', '2023-05-24 14:11:10', NULL),
(76, 'App\\Models\\User', 87, 'Default Wallet', 'default', 'f607b401-d652-4b8a-9ccd-c4fb83ac0b5a', NULL, '[]', '1000', 2, '2023-05-24 14:12:10', '2023-05-24 14:12:10', NULL),
(77, 'App\\Models\\User', 88, 'Default Wallet', 'default', 'da1faff8-870c-4ef0-8307-20b52a14a53b', NULL, '[]', '0', 2, '2023-05-24 14:15:53', '2023-05-24 14:15:53', NULL),
(78, 'App\\Models\\User', 89, 'Default Wallet', 'default', '98347db2-ad69-46a8-85b3-f6c0c1ebfd70', NULL, '[]', '0', 2, '2023-05-24 14:19:09', '2023-05-24 14:19:09', NULL),
(79, 'App\\Models\\User', 90, 'Default Wallet', 'default', 'e8349d6e-5f88-414e-a756-73afcbe306af', NULL, '[]', '0', 2, '2023-05-24 14:21:03', '2023-05-24 14:21:03', NULL),
(80, 'App\\Models\\User', 91, 'Default Wallet', 'default', 'cdaad112-e912-40a0-bf5d-bd26d51b55ff', NULL, '[]', '0', 2, '2023-05-24 14:22:35', '2023-05-24 14:22:35', NULL),
(81, 'App\\Models\\User', 92, 'Default Wallet', 'default', '76fd5162-9efa-480e-94cc-0af369693ad3', NULL, '[]', '0', 2, '2023-05-24 14:24:21', '2023-05-24 14:24:21', NULL),
(82, 'App\\Models\\User', 93, 'Default Wallet', 'default', 'dcaee27a-1ecc-4daf-afcf-765a81003f71', NULL, '[]', '0', 2, '2023-05-24 14:27:41', '2023-05-24 14:27:41', NULL),
(83, 'App\\Models\\User', 94, 'Default Wallet', 'default', '8837f749-39f2-44e9-93ef-b789f1ea294d', NULL, '[]', '0', 2, '2023-05-24 14:28:36', '2023-05-24 14:28:36', NULL),
(84, 'App\\Models\\User', 95, 'Default Wallet', 'default', 'be6ff248-d370-4e51-8a5c-410cc3722cae', NULL, '[]', '0', 2, '2023-05-24 14:29:46', '2023-05-24 14:29:46', NULL),
(85, 'App\\Models\\User', 96, 'Default Wallet', 'default', 'e42d2b5d-b610-4fbf-9980-9258073b48bf', NULL, '[]', '0', 2, '2023-05-24 14:34:49', '2023-05-24 14:34:49', NULL),
(86, 'App\\Models\\User', 97, 'Default Wallet', 'default', '0f1afa83-c0a2-477c-8190-52156a0ff342', NULL, '[]', '0', 2, '2023-05-24 14:35:16', '2023-05-24 14:35:16', NULL),
(87, 'App\\Models\\User', 98, 'Default Wallet', 'default', 'ccd4d4ba-ce5f-4168-bc66-6b559f32c475', NULL, '[]', '0', 2, '2023-05-24 14:47:09', '2023-05-24 14:47:09', NULL),
(88, 'App\\Models\\User', 99, 'Default Wallet', 'default', '05e4eb2d-b9c1-47e1-b240-3fca09601160', NULL, '[]', '0', 2, '2023-05-24 14:47:39', '2023-05-24 14:47:39', NULL),
(89, 'App\\Models\\User', 100, 'Default Wallet', 'default', '6d98ca6e-9b9a-4a38-a7b4-2deed0383939', NULL, '[]', '0', 2, '2023-05-24 14:49:35', '2023-05-24 14:49:35', NULL),
(90, 'App\\Models\\User', 101, 'Default Wallet', 'default', 'fe81141f-767b-4ee9-b3a6-a1347c8567a0', NULL, '[]', '0', 2, '2023-05-24 14:56:38', '2023-05-24 14:56:38', NULL),
(91, 'App\\Models\\User', 102, 'Default Wallet', 'default', '8201da6d-86af-4e5b-ae40-7c73a78090a1', NULL, '[]', '0', 2, '2023-05-24 15:03:33', '2023-05-24 15:03:33', NULL),
(92, 'App\\Models\\User', 103, 'Default Wallet', 'default', 'c4f87d72-e9ae-4ca1-96b4-ac0339dd12d7', NULL, '[]', '0', 2, '2023-05-24 15:06:26', '2023-05-24 15:06:26', NULL),
(93, 'App\\Models\\User', 104, 'Default Wallet', 'default', '88129758-f690-4d52-85ab-76dfe22e598a', NULL, '[]', '0', 2, '2023-05-24 15:09:06', '2023-05-24 15:09:06', NULL),
(94, 'App\\Models\\User', 105, 'Default Wallet', 'default', '0b95bf03-53a3-4a99-bfaa-2918966d94ad', NULL, '[]', '0', 2, '2023-05-24 15:11:19', '2023-05-24 15:11:19', NULL),
(95, 'App\\Models\\User', 106, 'Default Wallet', 'default', 'fa7f285f-4bb7-4915-9a00-7d1ec256ade6', NULL, '[]', '0', 2, '2023-05-24 15:11:46', '2023-05-24 15:11:46', NULL),
(96, 'App\\Models\\User', 107, 'Default Wallet', 'default', '03453df4-09a5-41e7-ba2e-02c5301c6b83', NULL, '[]', '0', 2, '2023-05-24 15:55:14', '2023-05-24 15:55:14', NULL),
(97, 'App\\Models\\User', 108, 'Default Wallet', 'default', 'd0474a5e-ec16-42c2-8edb-efb310f796b8', NULL, '[]', '0', 2, '2023-05-24 15:55:50', '2023-05-24 15:55:50', NULL),
(98, 'App\\Models\\User', 109, 'Default Wallet', 'default', '1ebed6fc-c488-4332-9af2-cb69819ac103', NULL, '[]', '0', 2, '2023-05-24 15:57:39', '2023-05-24 15:57:39', NULL),
(99, 'App\\Models\\User', 110, 'Default Wallet', 'default', 'f05e03cb-5571-4077-937c-e4a4d1ee7c11', NULL, '[]', '0', 2, '2023-05-24 15:58:12', '2023-05-24 15:58:12', NULL),
(100, 'App\\Models\\User', 111, 'Default Wallet', 'default', '8458e951-4349-4435-8ac6-17c18b5552d4', NULL, '[]', '0', 2, '2023-05-24 16:06:45', '2023-05-24 16:06:45', NULL),
(101, 'App\\Models\\User', 115, 'Default Wallet', 'default', '7a45d093-41b8-4c90-93d7-799dec1aecdf', NULL, '[]', '0', 2, '2023-05-24 16:20:19', '2023-05-24 16:20:19', NULL),
(102, 'App\\Models\\User', 122, 'Default Wallet', 'default', '46d25bdb-d32b-4b5c-b107-0fb9081e6c70', NULL, '[]', '0', 2, '2023-05-24 16:42:32', '2023-05-24 16:42:32', NULL),
(103, 'App\\Models\\User', 123, 'Default Wallet', 'default', 'f0cabca5-bf4f-41ef-8fc8-87180f3f17c1', NULL, '[]', '0', 2, '2023-05-24 16:51:06', '2023-05-24 16:51:06', NULL),
(104, 'App\\Models\\User', 130, 'Default Wallet', 'default', '3b6f687f-8840-463b-8bcb-ebc2a1333ed2', NULL, '[]', '0', 2, '2023-05-24 17:11:23', '2023-05-24 17:11:23', NULL),
(105, 'App\\Models\\User', 131, 'Default Wallet', 'default', 'a9e090b8-6685-41c5-84c2-7884b592a0c5', NULL, '[]', '0', 2, '2023-05-24 17:15:38', '2023-05-24 17:15:38', NULL),
(106, 'App\\Models\\User', 137, 'Default Wallet', 'default', '057e5b55-81b4-4fb8-a1eb-5a0c7b108925', NULL, '[]', '0', 2, '2023-05-24 17:30:56', '2023-05-24 17:30:56', NULL),
(107, 'App\\Models\\User', 139, 'Default Wallet', 'default', 'afb7e707-3bd1-4622-80cb-2c6b6e7473c0', NULL, '[]', '0', 2, '2023-05-24 19:33:50', '2023-05-24 19:33:50', NULL),
(108, 'App\\Models\\User', 140, 'Default Wallet', 'default', '70827a33-4453-4106-b31e-514d8fafc468', NULL, '[]', '0', 2, '2023-05-24 19:35:03', '2023-05-24 19:35:03', NULL),
(109, 'App\\Models\\User', 142, 'Default Wallet', 'default', '5d48a88f-a143-413f-9540-277e9465cdd9', NULL, '[]', '0', 2, '2023-05-24 19:39:53', '2023-05-24 19:39:53', NULL),
(110, 'App\\Models\\User', 143, 'Default Wallet', 'default', '1aa8ca50-e644-4bd3-918a-7960a850f6f5', NULL, '[]', '0', 2, '2023-05-24 19:42:40', '2023-05-24 19:42:40', NULL),
(111, 'App\\Models\\User', 144, 'Default Wallet', 'default', 'c35639ca-1d9f-41b9-9c9e-4f3abad83ca6', NULL, '[]', '0', 2, '2023-05-25 03:15:42', '2023-05-25 03:15:42', NULL),
(112, 'App\\Models\\User', 145, 'Default Wallet', 'default', 'b01acc1d-ee6d-4268-9d90-9ae1f1589da7', NULL, '[]', '0', 2, '2023-05-25 03:16:22', '2023-05-25 03:16:22', NULL),
(113, 'App\\Models\\User', 146, 'Default Wallet', 'default', 'ad3a4e83-2caa-4dec-82cb-573056262ee6', NULL, '[]', '0', 2, '2023-05-25 03:16:54', '2023-05-25 03:16:54', NULL),
(114, 'App\\Models\\User', 147, 'Default Wallet', 'default', '1d2deb21-fcff-4579-88ba-a3792cf22ff6', NULL, '[]', '0', 2, '2023-05-25 17:09:46', '2023-05-25 17:09:46', NULL),
(115, 'App\\Models\\User', 148, 'Default Wallet', 'default', '446d3e6b-d807-49af-8f2c-e2ac6d49dec7', NULL, '[]', '0', 2, '2023-05-25 17:12:04', '2023-05-25 17:12:04', NULL),
(116, 'App\\Models\\User', 149, 'Default Wallet', 'default', 'a98cece4-7689-4986-8c8e-e20faed3735e', NULL, '[]', '0', 2, '2023-05-25 17:14:04', '2023-05-25 17:14:04', NULL),
(117, 'App\\Models\\User', 150, 'Default Wallet', 'default', '0f633ecf-e801-4b17-8de9-1d176ab533e8', NULL, '[]', '0', 2, '2023-05-25 17:16:13', '2023-05-25 17:16:13', NULL),
(118, 'App\\Models\\User', 151, 'Default Wallet', 'default', 'f129ee10-41db-48b4-96e8-c172dc3b5e02', NULL, '[]', '0', 2, '2023-05-25 19:36:40', '2023-05-25 19:36:40', NULL),
(119, 'App\\Models\\User', 152, 'Default Wallet', 'default', 'e130ff8d-e2d9-4a05-90c4-20d7af623799', NULL, '[]', '0', 2, '2023-05-25 19:39:08', '2023-05-25 19:39:08', NULL),
(120, 'App\\Models\\User', 153, 'Default Wallet', 'default', '631a9537-2c35-4b73-a588-1f3566e65746', NULL, '[]', '0', 2, '2023-05-25 19:40:47', '2023-05-25 19:40:47', NULL),
(121, 'App\\Models\\User', 154, 'Default Wallet', 'default', '9d38c792-b97b-4ead-9b07-b493701d8b7d', NULL, '[]', '0', 2, '2023-05-25 19:42:12', '2023-05-25 19:42:12', NULL),
(122, 'App\\Models\\User', 155, 'Default Wallet', 'default', '46d0df13-ca2d-4ad5-80bd-2cd19fe496a2', NULL, '[]', '0', 2, '2023-05-25 19:52:51', '2023-05-25 19:52:51', NULL),
(123, 'App\\Models\\User', 156, 'Default Wallet', 'default', '999682a8-9c5c-43cb-a324-8fd9016d501f', NULL, '[]', '0', 2, '2023-05-25 20:09:15', '2023-05-25 20:09:15', NULL),
(124, 'App\\Models\\User', 157, 'Default Wallet', 'default', '9bcaeb58-08be-4223-969d-f430e1efa029', NULL, '[]', '0', 2, '2023-05-25 20:27:24', '2023-05-25 20:27:24', NULL),
(125, 'App\\Models\\User', 158, 'Default Wallet', 'default', '3facc340-33d5-41d4-b2b7-367600a8a7aa', NULL, '[]', '0', 2, '2023-05-25 20:27:53', '2023-05-25 20:27:53', NULL),
(126, 'App\\Models\\User', 159, 'Default Wallet', 'default', '4b068ca5-f9ec-407b-9add-bcc022ada6e4', NULL, '[]', '0', 2, '2023-05-25 20:40:14', '2023-05-25 20:40:14', NULL),
(127, 'App\\Models\\User', 160, 'Default Wallet', 'default', '0e0c5b3b-042d-42e2-a74f-fb201e6851fe', NULL, '[]', '0', 2, '2023-05-25 20:46:02', '2023-05-25 20:46:02', NULL),
(128, 'App\\Models\\User', 161, 'Default Wallet', 'default', 'ae3e325f-b502-4134-bd81-9cb1c88d8634', NULL, '[]', '0', 2, '2023-05-25 21:43:44', '2023-05-25 21:43:44', NULL),
(129, 'App\\Models\\User', 162, 'Default Wallet', 'default', '11d13c12-7186-4dbe-a1da-f53e6e2670a8', NULL, '[]', '0', 2, '2023-05-25 22:07:54', '2023-05-25 22:07:54', NULL),
(130, 'App\\Models\\User', 163, 'Default Wallet', 'default', '1f1e0d22-691f-4b4e-9583-9b00cfb84363', NULL, '[]', '0', 2, '2023-05-25 22:10:06', '2023-05-25 22:10:06', NULL),
(131, 'App\\Models\\User', 164, 'Default Wallet', 'default', 'c8bcde39-be79-4a9d-8d13-788b37282ec9', NULL, '[]', '0', 2, '2023-05-25 22:12:58', '2023-05-25 22:12:58', NULL),
(132, 'App\\Models\\User', 165, 'Default Wallet', 'default', '12b875a6-2456-4809-99bc-8090c632a668', NULL, '[]', '0', 2, '2023-05-26 14:14:50', '2023-05-26 14:14:50', NULL),
(133, 'App\\Models\\User', 166, 'Default Wallet', 'default', '7a20e255-6782-4f7e-91e4-0df61778199c', NULL, '[]', '0', 2, '2023-05-26 14:24:00', '2023-05-26 14:24:00', NULL),
(134, 'App\\Models\\User', 167, 'Default Wallet', 'default', 'ee2924fd-7708-4612-a319-45d9c1d819d9', NULL, '[]', '0', 2, '2023-05-26 15:04:17', '2023-05-26 15:04:17', NULL),
(135, 'App\\Models\\User', 168, 'Default Wallet', 'default', 'da1b515a-1070-4463-9a53-b273232eade5', NULL, '[]', '0', 2, '2023-05-26 15:07:58', '2023-05-26 15:07:58', NULL),
(136, 'App\\Models\\User', 169, 'Default Wallet', 'default', '19999a84-e2c5-4ff2-bfba-658624d125c1', NULL, '[]', '0', 2, '2023-05-26 15:08:34', '2023-05-26 15:08:34', NULL),
(137, 'App\\Models\\User', 170, 'Default Wallet', 'default', '644367df-b72f-457c-9e6f-f18559a7f1c1', NULL, '[]', '0', 2, '2023-05-26 15:31:08', '2023-05-26 15:31:08', NULL),
(138, 'App\\Models\\User', 171, 'Default Wallet', 'default', 'c1d8343f-db6e-4b11-83e3-ca8ca9f8b4d3', NULL, '[]', '0', 2, '2023-05-26 15:31:32', '2023-05-26 15:31:32', NULL),
(139, 'App\\Models\\User', 172, 'Default Wallet', 'default', '4a891664-b475-4eec-a9a0-9b905d53e46a', NULL, '[]', '0', 2, '2023-05-26 15:32:14', '2023-05-26 15:32:14', NULL),
(140, 'App\\Models\\User', 173, 'Default Wallet', 'default', 'd4852275-35b2-4c7b-bc84-fd4e54fe0ab3', NULL, '[]', '0', 2, '2023-05-26 16:09:32', '2023-05-26 16:09:32', NULL),
(141, 'App\\Models\\User', 30, 'Default Wallet', 'default', 'c6925723-761c-44b4-8838-581273f71c95', NULL, '[]', '0', 2, '2023-05-26 17:03:03', '2023-05-26 17:03:03', NULL),
(142, 'App\\Models\\User', 29, 'Default Wallet', 'default', 'a95b9731-7b7b-4e19-96a8-6c1085bef48c', NULL, '[]', '0', 2, '2023-05-26 17:03:04', '2023-05-26 17:03:04', NULL),
(143, 'App\\Models\\User', 28, 'Default Wallet', 'default', '457b93bf-0c2c-48fc-9fab-13b8fc88d526', NULL, '[]', '0', 2, '2023-05-26 17:03:04', '2023-05-26 17:03:04', NULL),
(144, 'App\\Models\\User', 25, 'Default Wallet', 'default', '0dfeec97-b871-4123-879c-6c68dfb643d6', NULL, '[]', '0', 2, '2023-05-26 17:03:04', '2023-05-26 17:03:04', NULL),
(145, 'App\\Models\\User', 179, 'Default Wallet', 'default', '942ffc5c-efe9-40de-b361-257ab7675d0a', NULL, '[]', '0', 2, '2023-05-26 17:06:30', '2023-05-26 17:06:30', NULL),
(146, 'App\\Models\\User', 180, 'Default Wallet', 'default', '77d4c12c-88ec-451f-8215-38f3caf453bd', NULL, '[]', '0', 2, '2023-05-26 17:12:16', '2023-05-26 17:12:16', NULL),
(147, 'App\\Models\\User', 181, 'Default Wallet', 'default', '179095e5-554c-4ef6-90d4-9995981d94d0', NULL, '[]', '0', 2, '2023-05-26 18:21:44', '2023-05-26 18:21:44', NULL),
(148, 'App\\Models\\User', 182, 'Default Wallet', 'default', '9505a70b-92d8-4e1b-bb13-130cae40f95f', NULL, '[]', '0', 2, '2023-05-26 18:59:39', '2023-05-26 18:59:39', NULL),
(149, 'App\\Models\\User', 183, 'Default Wallet', 'default', 'bf95cda1-51a3-4b36-a6df-be9d9a682e35', NULL, '[]', '0', 2, '2023-05-26 19:03:44', '2023-05-26 19:03:44', NULL),
(150, 'App\\Models\\User', 184, 'Default Wallet', 'default', '0c897f1c-3ee5-4ba1-b3ec-b3eb150b53b6', NULL, '[]', '0', 2, '2023-05-26 20:06:33', '2023-05-26 20:06:33', NULL),
(151, 'App\\Models\\User', 185, 'Default Wallet', 'default', '2a97154f-bb48-4a62-b08a-912ba810d948', NULL, '[]', '0', 2, '2023-05-26 20:18:41', '2023-05-26 20:18:41', NULL),
(152, 'App\\Models\\User', 186, 'Default Wallet', 'default', '5b707653-11fd-400a-9e79-4e941e54a37d', NULL, '[]', '0', 2, '2023-05-26 20:31:13', '2023-05-26 20:31:13', NULL),
(153, 'App\\Models\\User', 187, 'Default Wallet', 'default', '40e6d135-53e8-4a8f-b1b7-53a8f4db6341', NULL, '[]', '0', 2, '2023-05-26 20:43:00', '2023-05-26 20:43:00', NULL),
(154, 'App\\Models\\User', 188, 'Default Wallet', 'default', '6bdb5734-ccd2-47f0-aed0-bb6dcd87d770', NULL, '[]', '0', 2, '2023-05-26 21:20:32', '2023-05-26 21:20:32', NULL),
(155, 'App\\Models\\User', 189, 'Default Wallet', 'default', 'f6b6e521-5e5f-4ec6-b40f-904dc4a64f98', NULL, '[]', '0', 2, '2023-05-26 21:26:35', '2023-05-26 21:26:35', NULL),
(156, 'App\\Models\\User', 190, 'Default Wallet', 'default', 'd1914b99-b6e1-4db9-9844-a71d4b1118a0', NULL, '[]', '0', 2, '2023-05-26 21:30:54', '2023-05-26 21:30:54', NULL),
(157, 'App\\Models\\User', 191, 'Default Wallet', 'default', '863980e1-4c18-408d-be74-089e477f2bd4', NULL, '[]', '0', 2, '2023-05-26 21:35:33', '2023-05-26 21:35:33', NULL),
(158, 'App\\Models\\User', 192, 'Default Wallet', 'default', 'fd8e664a-7246-49aa-b68c-509b23573944', NULL, '[]', '0', 2, '2023-05-26 22:32:14', '2023-05-26 22:32:14', NULL),
(159, 'App\\Models\\User', 193, 'Default Wallet', 'default', 'da0e102a-9157-4ea6-a067-571839f63867', NULL, '[]', '0', 2, '2023-05-26 22:43:11', '2023-05-26 22:43:11', NULL),
(160, 'App\\Models\\User', 194, 'Default Wallet', 'default', '82db7913-d1c6-4c06-a3ae-6d8b46fda806', NULL, '[]', '1000', 2, '2023-06-15 20:43:59', '2023-06-15 20:43:59', NULL),
(161, 'App\\Models\\User', 195, 'Default Wallet', 'default', '39b2c425-2cb3-4c71-a98e-58cdf764f6f7', NULL, '[]', '0', 2, '2023-06-19 17:15:26', '2023-06-19 17:15:26', NULL),
(162, 'App\\Models\\User', 196, 'Default Wallet', 'default', '720fdbc6-7d19-46fc-83c9-4676943c5877', NULL, '[]', '0', 2, '2023-07-03 21:25:50', '2023-07-03 21:25:50', NULL),
(163, 'App\\Models\\User', 197, 'Default Wallet', 'default', '81935838-a2fe-459b-9913-2df5fb448263', NULL, '[]', '0', 2, '2023-07-04 14:51:19', '2023-07-04 14:51:19', NULL),
(164, 'App\\Models\\User', 198, 'Default Wallet', 'default', '14b65817-7445-4c95-a5f8-fd8469a05b98', NULL, '[]', '0', 2, '2023-07-04 18:56:24', '2023-07-04 18:56:24', NULL),
(165, 'App\\Models\\User', 199, 'Default Wallet', 'default', '5afd6603-210c-4a3c-be12-0bd0b15f5f36', NULL, '[]', '0', 2, '2023-07-04 18:59:07', '2023-07-04 18:59:07', NULL),
(166, 'App\\Models\\User', 200, 'Default Wallet', 'default', 'd0c09f71-59c1-46ae-b54f-f34aad490443', NULL, '[]', '0', 2, '2023-07-04 19:12:54', '2023-07-04 19:12:54', NULL),
(167, 'App\\Models\\User', 201, 'Default Wallet', 'default', '1dff7e05-88d4-4829-96ed-76bbe5bc62e3', NULL, '[]', '0', 2, '2023-07-05 14:46:26', '2023-07-05 14:46:26', NULL),
(168, 'App\\Models\\User', 202, 'Default Wallet', 'default', '63bbc430-95c8-47d9-8551-3e761ab88628', NULL, '[]', '0', 2, '2023-07-06 14:27:01', '2023-07-06 14:27:01', NULL),
(169, 'App\\Models\\User', 203, 'Default Wallet', 'default', '576aa091-4b9e-4d1c-9408-0152bcd8d5fb', NULL, '[]', '0', 2, '2023-07-06 21:54:34', '2023-07-06 21:54:34', NULL),
(170, 'App\\Models\\User', 204, 'Default Wallet', 'default', '893330b1-1250-4042-b1f4-cd9e0fcf3e53', NULL, '[]', '0', 2, '2023-07-07 01:46:59', '2023-07-07 01:46:59', NULL),
(171, 'App\\Models\\User', 205, 'Default Wallet', 'default', '086f95b0-8063-433d-a648-72fbe5c19c77', NULL, '[]', '0', 2, '2023-07-07 15:51:58', '2023-07-07 15:51:58', NULL),
(172, 'App\\Models\\User', 206, 'Default Wallet', 'default', '9a7ed4c9-3220-4015-a595-09ea4afc007d', NULL, '[]', '0', 2, '2023-07-07 16:13:44', '2023-07-07 16:13:44', NULL),
(173, 'App\\Models\\User', 207, 'Default Wallet', 'default', 'dd9ed0ec-acc4-4c1d-82b6-1c98ad9f7806', NULL, '[]', '0', 2, '2023-07-07 21:42:51', '2023-07-07 21:42:51', NULL),
(174, 'App\\Models\\User', 208, 'Default Wallet', 'default', 'a17e002c-7d07-41a2-9afc-23868baa156f', NULL, '[]', '0', 2, '2023-07-07 22:29:42', '2023-07-07 22:29:42', NULL),
(175, 'App\\Models\\User', 209, 'Default Wallet', 'default', 'b27f6b5f-3b09-40c3-a82e-73d902d03df7', NULL, '[]', '0', 2, '2023-07-07 23:24:45', '2023-07-07 23:24:45', NULL),
(176, 'App\\Models\\User', 210, 'Default Wallet', 'default', '8bd8f1f1-abb0-43ae-8a17-6083f4fcaa0b', NULL, '[]', '0', 2, '2023-07-08 19:09:28', '2023-07-08 19:09:28', NULL),
(177, 'App\\Models\\User', 211, 'Default Wallet', 'default', '57ba970b-594e-48a5-aba0-68a9a8528317', NULL, '[]', '0', 2, '2023-07-08 19:26:37', '2023-07-08 19:26:37', NULL),
(178, 'App\\Models\\User', 212, 'Default Wallet', 'default', '5be3f595-c79b-45c6-add6-fe87f48d3a41', NULL, '[]', '0', 2, '2023-07-10 16:32:37', '2023-07-10 16:32:37', NULL),
(179, 'App\\Models\\User', 213, 'Default Wallet', 'default', '14fff32f-72fb-429a-8bcd-d4594258bb16', NULL, '[]', '0', 2, '2023-07-14 18:55:54', '2023-07-14 18:55:54', NULL),
(180, 'App\\Models\\User', 214, 'Default Wallet', 'default', '1d95968f-d85d-4686-94f5-7a3814a6f984', NULL, '[]', '0', 2, '2023-07-21 19:20:22', '2023-07-21 19:20:22', NULL),
(181, 'App\\Models\\User', 215, 'Default Wallet', 'default', '486b4128-f3c3-4d33-9396-a1b4f79c37b9', NULL, '[]', '0', 2, '2023-07-21 19:27:31', '2023-07-21 19:27:31', NULL),
(182, 'App\\Models\\User', 216, 'Default Wallet', 'default', '47a124c6-358d-4344-8f7d-9ce5554fff5a', NULL, '[]', '0', 2, '2023-07-24 14:13:02', '2023-07-24 14:13:02', NULL),
(183, 'App\\Models\\User', 217, 'Default Wallet', 'default', 'ed6e9f17-64d9-4456-86aa-6f8827561716', NULL, '[]', '1000', 2, '2023-07-24 14:42:08', '2023-08-01 21:53:43', NULL),
(184, 'App\\Models\\User', 218, 'Default Wallet', 'default', '28a8b0c6-a178-47fa-9f52-36d7d12af555', NULL, '[]', '0', 2, '2023-07-28 22:05:46', '2023-07-28 22:05:46', NULL),
(185, 'App\\Models\\User', 219, 'Default Wallet', 'default', '7939a760-995a-4d38-b450-8da43d2855c4', NULL, '[]', '0', 2, '2023-07-28 22:10:40', '2023-07-28 22:10:40', NULL),
(186, 'App\\Models\\User', 220, 'Default Wallet', 'default', 'bc2127cb-6098-4d8a-9dfb-92f1c8c872ef', NULL, '[]', '10000', 2, '2023-07-28 22:45:44', '2023-07-28 22:45:44', NULL),
(187, 'App\\Models\\User', 221, 'Default Wallet', 'default', '295f887c-7e2e-4c27-af11-fd0b44f93e14', NULL, '[]', '9989158', 2, '2023-07-29 13:29:28', '2023-08-03 14:17:10', NULL),
(188, 'App\\Models\\User', 222, 'Default Wallet', 'default', '3c639b37-4df5-4db3-942c-dde53bbaeb2c', NULL, '[]', '0', 2, '2023-08-01 16:05:38', '2023-08-01 16:05:38', NULL),
(189, 'App\\Models\\User', 223, 'Default Wallet', 'default', 'f90a8517-cbf3-4988-9bea-e3be71702952', NULL, '[]', '1000', 2, '2023-08-08 16:04:20', '2023-08-08 16:04:20', NULL),
(190, 'App\\Models\\User', 224, 'Default Wallet', 'default', 'b766691a-53fe-4984-a564-1abe95410eea', NULL, '[]', '0', 2, '2023-08-08 16:24:38', '2023-08-08 16:24:38', NULL),
(191, 'App\\Models\\User', 225, 'Default Wallet', 'default', '74ff54d5-f155-4e46-bba6-dea5fd2936a6', NULL, '[]', '0', 2, '2023-08-09 18:52:14', '2023-08-09 18:52:14', NULL),
(192, 'App\\Models\\User', 226, 'Default Wallet', 'default', '3b23b4c1-2b19-4a39-92fc-845477e403cf', NULL, '[]', '0', 2, '2023-08-09 18:54:35', '2023-08-09 18:54:35', NULL),
(193, 'App\\Models\\User', 227, 'Default Wallet', 'default', 'a97ba325-01bd-4e52-8285-a7672f9d1c67', NULL, '[]', '1000', 2, '2023-08-12 16:41:49', '2023-08-12 16:41:49', NULL),
(194, 'App\\Models\\User', 228, 'Default Wallet', 'default', '8c2ed33f-f5ac-4f55-b945-627a7b1ccd61', NULL, '[]', '10000', 2, '2023-08-12 21:39:07', '2023-08-12 21:39:07', NULL),
(195, 'App\\Models\\User', 229, 'Default Wallet', 'default', '447c5b2e-7e29-446e-92f6-2eeaf6d0a3a2', NULL, '[]', '0', 2, '2023-08-18 22:06:39', '2023-08-18 22:06:39', NULL),
(196, 'App\\Models\\User', 230, 'Default Wallet', 'default', '150e8541-5f82-4204-9cc0-6e68c3000926', NULL, '[]', '50', 2, '2023-08-22 15:01:42', '2023-08-22 15:01:42', NULL),
(197, 'App\\Models\\User', 231, 'Default Wallet', 'default', '273cb004-f546-4ebf-851e-9cfe2fa7eaff', NULL, '[]', '100', 2, '2023-08-29 14:33:14', '2023-08-29 14:33:14', NULL),
(198, 'App\\Models\\User', 232, 'Default Wallet', 'default', '4f81baf1-c7a3-4451-a364-e24db18ef8bb', NULL, '[]', '100', 2, '2023-08-29 22:11:08', '2023-08-29 22:11:08', NULL),
(199, 'App\\Models\\User', 233, 'Default Wallet', 'default', 'cac8e509-1154-452e-837d-56f6c48cc414', NULL, '[]', '0', 2, '2023-08-31 18:45:43', '2023-08-31 19:04:23', NULL),
(200, 'App\\Models\\User', 234, 'Default Wallet', 'default', '367ae0b7-15ed-4be5-bf70-ba3fdacf4d9d', NULL, '[]', '100', 2, '2023-08-31 19:10:56', '2023-08-31 19:10:56', NULL),
(201, 'App\\Models\\User', 235, 'Default Wallet', 'default', '52bee7ff-6a8e-437b-8ed9-d8ed37fcdfdd', NULL, '[]', '100', 2, '2023-09-02 21:44:04', '2023-09-02 21:44:04', NULL),
(202, 'App\\Models\\User', 236, 'Default Wallet', 'default', 'cb737a4d-af8a-4454-9069-8a140553874b', NULL, '[]', '0', 2, '2023-09-04 14:51:02', '2023-09-07 16:11:26', NULL),
(203, 'App\\Models\\User', 237, 'Default Wallet', 'default', '0830e411-ac03-4286-bf37-fa9981bbbdf3', NULL, '[]', '100', 2, '2023-09-04 16:05:24', '2023-09-04 16:05:24', NULL),
(204, 'App\\Models\\User', 238, 'Default Wallet', 'default', '53086a46-f944-4573-946f-f59c9d603800', NULL, '[]', '100', 2, '2023-09-04 17:06:08', '2023-09-04 17:06:08', NULL),
(205, 'App\\Models\\User', 239, 'Default Wallet', 'default', '0c67e637-8f11-478b-a2a8-9d788f02be9f', NULL, '[]', '100', 2, '2023-09-06 14:20:02', '2023-09-06 14:20:02', NULL),
(206, 'App\\Models\\User', 240, 'Default Wallet', 'default', '8df51eba-d33c-4acc-a34b-adc3a2b6d866', NULL, '[]', '100', 2, '2023-09-06 15:57:49', '2023-09-06 15:57:49', NULL),
(207, 'App\\Models\\User', 241, 'Default Wallet', 'default', 'b377992b-ab06-4ff2-bfd6-22d820a99d66', NULL, '[]', '100', 2, '2023-09-06 16:23:05', '2023-09-06 16:23:05', NULL),
(208, 'App\\Models\\User', 242, 'Default Wallet', 'default', '145c2df0-772c-4725-87f8-5d8923f32a74', NULL, '[]', '100', 2, '2023-09-06 16:31:42', '2023-09-06 16:31:42', NULL),
(209, 'App\\Models\\User', 243, 'Default Wallet', 'default', 'a17642cd-e516-495a-a5cc-e4f85b0c8cf4', NULL, '[]', '100', 2, '2023-09-06 16:34:19', '2023-09-06 16:34:19', NULL),
(210, 'App\\Models\\User', 244, 'Default Wallet', 'default', '3407c8ea-2269-4d9f-94a7-3db4f6b2d918', NULL, '[]', '0', 2, '2023-09-06 17:18:58', '2023-09-06 19:26:23', NULL),
(211, 'App\\Models\\User', 245, 'Default Wallet', 'default', '523c3edd-7e29-43fc-82ae-c32c68be2d42', NULL, '[]', '100', 2, '2023-09-08 14:27:01', '2023-09-08 14:27:01', NULL),
(212, 'App\\Models\\User', 246, 'Default Wallet', 'default', '3e63a9a8-768b-4cf6-ba67-3f87aa45718e', NULL, '[]', '0', 2, '2023-09-08 15:51:00', '2023-09-26 18:53:35', NULL),
(213, 'App\\Models\\User', 247, 'Default Wallet', 'default', '2083b65d-e07b-438a-ba4a-d39fe5adb1e5', NULL, '[]', '100', 2, '2023-09-08 16:02:47', '2023-09-08 16:02:47', NULL),
(214, 'App\\Models\\User', 248, 'Default Wallet', 'default', '4a1e84b4-51be-4986-b3f5-69012f57f6da', NULL, '[]', '0', 2, '2023-09-08 16:08:00', '2023-09-08 22:24:30', NULL),
(215, 'App\\Models\\User', 250, 'Default Wallet', 'default', '9f98788b-20db-4d2d-b97e-2bcf102306a3', NULL, '[]', '0', 2, '2023-09-08 23:49:41', '2023-09-08 23:49:41', NULL),
(216, 'App\\Models\\User', 251, 'Default Wallet', 'default', '71eab9da-b6f3-42ff-b41b-2bdce34e51b8', NULL, '[]', '0', 2, '2023-09-09 00:02:36', '2023-09-09 00:02:36', NULL),
(217, 'App\\Models\\User', 252, 'Default Wallet', 'default', 'c0f4411d-4831-49f6-b765-c75c301545e5', NULL, '[]', '0', 2, '2023-09-09 00:05:46', '2023-09-09 00:05:46', NULL),
(218, 'App\\Models\\User', 253, 'Default Wallet', 'default', 'adb9e3f8-6fdb-45c3-8625-24677e9c67f0', NULL, '[]', '0', 2, '2023-09-09 14:26:30', '2023-09-12 21:23:15', NULL),
(219, 'App\\Models\\User', 254, 'Default Wallet', 'default', 'f2eb4918-b9e3-4782-bd4e-b8d46fd854e9', NULL, '[]', '0', 2, '2023-09-09 15:33:47', '2023-09-09 15:33:47', NULL),
(220, 'App\\Models\\User', 255, 'Default Wallet', 'default', 'd0f44aa7-4198-4cd8-bd67-79679706fefc', NULL, '[]', '0', 2, '2023-09-27 16:10:51', '2023-09-28 19:48:39', NULL),
(221, 'App\\Models\\User', 256, 'Default Wallet', 'default', '4387c5ab-cc04-42cc-8035-d64c05e3223b', NULL, '[]', '100', 2, '2023-10-04 19:06:44', '2023-10-04 19:06:44', NULL),
(222, 'App\\Models\\User', 257, 'Default Wallet', 'default', 'eb6ae8bd-2abe-4e5a-8b64-87cac04cc26f', NULL, '[]', '100', 2, '2023-10-10 15:14:08', '2023-10-10 15:14:08', NULL),
(223, 'App\\Models\\User', 258, 'Default Wallet', 'default', 'a32ec8f9-e04e-4e30-8ccb-1648c2f19ad2', NULL, '[]', '100', 2, '2023-10-10 15:43:45', '2023-10-10 15:43:45', NULL),
(224, 'App\\Models\\User', 259, 'Default Wallet', 'default', '8dd1b5ef-121d-4f17-844c-be2c2767a8a8', NULL, '[]', '0', 2, '2023-10-11 20:05:29', '2023-10-17 14:12:35', NULL),
(225, 'App\\Models\\User', 261, 'Default Wallet', 'default', 'd7dc6880-a22a-4770-979d-83354f6afeb0', NULL, '[]', '100', 2, '2023-10-13 20:18:06', '2023-10-13 20:18:06', NULL),
(226, 'App\\Models\\User', 262, 'Default Wallet', 'default', '0751aa5d-68ed-451b-940b-06771d73a2b3', NULL, '[]', '100', 2, '2023-10-13 20:20:30', '2023-10-13 20:20:30', NULL),
(227, 'App\\Models\\User', 263, 'Default Wallet', 'default', 'a2495ed5-7d7b-452b-a4bf-d8005e25a079', NULL, '[]', '100', 2, '2023-10-13 20:25:26', '2023-10-13 20:25:26', NULL),
(228, 'App\\Models\\User', 264, 'Default Wallet', 'default', '831084f2-01ff-4830-b7ca-d7b36332a486', NULL, '[]', '100', 2, '2023-10-13 20:33:53', '2023-10-13 20:33:53', NULL),
(229, 'App\\Models\\User', 265, 'Default Wallet', 'default', '0c92e17f-7f49-4528-b21a-0ed8831242dd', NULL, '[]', '100', 2, '2023-10-13 20:35:04', '2023-10-13 20:35:04', NULL),
(230, 'App\\Models\\User', 266, 'Default Wallet', 'default', 'ac6e16c1-8db2-4ac8-8e2e-c02fc6c4ed8d', NULL, '[]', '0', 2, '2023-10-13 20:35:46', '2023-10-14 14:58:50', NULL),
(231, 'App\\Models\\User', 267, 'Default Wallet', 'default', '1fcbaa47-62bc-4e30-8ef9-6080c38f3655', NULL, '[]', '0', 2, '2023-10-14 15:16:29', '2023-10-18 14:27:07', NULL),
(232, 'App\\Models\\User', 268, 'Default Wallet', 'default', 'e2225991-302d-4726-9c93-bd464a2690ed', NULL, '[]', '100', 2, '2023-10-14 20:38:44', '2023-10-14 20:38:44', NULL),
(233, 'App\\Models\\User', 269, 'Default Wallet', 'default', '63331224-4374-45eb-bc6c-690ade853467', NULL, '[]', '100', 2, '2023-10-17 17:03:52', '2023-10-17 17:03:53', NULL),
(234, 'App\\Models\\User', 270, 'Default Wallet', 'default', '67eb36c2-7123-42f6-b7c7-621a02b943de', NULL, '[]', '0', 2, '2024-07-15 01:36:12', '2024-07-15 01:36:12', NULL),
(235, 'App\\Models\\User', 271, 'Default Wallet', 'default', 'bba4bffd-aaab-4444-b0a0-696c9376f291', NULL, '[]', '100', 2, '2024-07-15 01:42:18', '2024-07-15 01:42:18', NULL);

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

--
-- Table structure for table `websockets_statistics_entries`
--

CREATE TABLE `websockets_statistics_entries` (
  `id` int UNSIGNED NOT NULL,
  `app_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `peak_connection_count` int NOT NULL,
  `websocket_message_count` int NOT NULL,
  `api_message_count` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdrawal_requests`
--

CREATE TABLE `withdrawal_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','accept','reject') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `admin_transcation_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_payment_method` enum('bankaccount','upi') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawal_requests`
--

INSERT INTO `withdrawal_requests` (`id`, `user_id`, `amount`, `status`, `admin_transcation_id`, `admin_payment_method`, `created_at`, `updated_at`) VALUES
(1, '200', '101', 'pending', NULL, NULL, '2023-05-23 22:18:54', '2023-05-23 22:18:54'),
(2, '200', '10', 'accept', '6464646464645646', 'upi', '2023-05-24 21:39:06', '2023-08-05 23:18:34');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `audits`
--
ALTER TABLE `audits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `audits_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`),
  ADD KEY `audits_user_id_user_type_index` (`user_id`,`user_type`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `countries_code_unique` (`code`),
  ADD UNIQUE KEY `countries_code_iso_unique` (`code_iso`);

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

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `currencies_code_unique` (`title`);

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

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

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

--
-- Indexes for table `enquires`
--
ALTER TABLE `enquires`
  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 `fedexes`
--
ALTER TABLE `fedexes`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `images_user_id_foreign` (`user_id`),
  ADD KEY `images_imageable_type_imageable_id_index` (`imageable_type`,`imageable_id`),
  ADD KEY `images_category_id_foreign` (`category_id`),
  ADD KEY `images_service_id_foreign` (`service_id`);

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_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 `newsletters`
--
ALTER TABLE `newsletters`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `payment_orders`
--
ALTER TABLE `payment_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_orders_paymentable_type_paymentable_id_index` (`paymentable_type`,`paymentable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_uuid_unique` (`uuid`),
  ADD KEY `transactions_payable_type_payable_id_index` (`payable_type`,`payable_id`),
  ADD KEY `payable_type_payable_id_ind` (`payable_type`,`payable_id`),
  ADD KEY `payable_type_ind` (`payable_type`,`payable_id`,`type`),
  ADD KEY `payable_confirmed_ind` (`payable_type`,`payable_id`,`confirmed`),
  ADD KEY `payable_type_confirmed_ind` (`payable_type`,`payable_id`,`type`,`confirmed`),
  ADD KEY `transactions_type_index` (`type`),
  ADD KEY `transactions_wallet_id_foreign` (`wallet_id`);

--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transfers_uuid_unique` (`uuid`),
  ADD KEY `transfers_deposit_id_foreign` (`deposit_id`),
  ADD KEY `transfers_withdraw_id_foreign` (`withdraw_id`),
  ADD KEY `transfers_from_id_index` (`from_id`),
  ADD KEY `transfers_to_id_index` (`to_id`);

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

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wallets_holder_type_holder_id_slug_unique` (`holder_type`,`holder_id`,`slug`),
  ADD UNIQUE KEY `wallets_uuid_unique` (`uuid`),
  ADD KEY `wallets_holder_type_holder_id_index` (`holder_type`,`holder_id`),
  ADD KEY `wallets_slug_index` (`slug`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `actions`
--
ALTER TABLE `actions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=221;

--
-- AUTO_INCREMENT for table `advertisements`
--
ALTER TABLE `advertisements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `advertises`
--
ALTER TABLE `advertises`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `adv_modules`
--
ALTER TABLE `adv_modules`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `appcontactuses`
--
ALTER TABLE `appcontactuses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `audits`
--
ALTER TABLE `audits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6831;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `cancleorders`
--
ALTER TABLE `cancleorders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=157;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `configs`
--
ALTER TABLE `configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;

--
-- AUTO_INCREMENT for table `customer_jobs`
--
ALTER TABLE `customer_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `c_m_s`
--
ALTER TABLE `c_m_s`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `discount_sliders`
--
ALTER TABLE `discount_sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `enquires`
--
ALTER TABLE `enquires`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `fedexes`
--
ALTER TABLE `fedexes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_uploads`
--
ALTER TABLE `file_uploads`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flash_sales`
--
ALTER TABLE `flash_sales`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flash_sale_mains`
--
ALTER TABLE `flash_sale_mains`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=266;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_apllies`
--
ALTER TABLE `job_apllies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;

--
-- AUTO_INCREMENT for table `newsletters`
--
ALTER TABLE `newsletters`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `new_currencies`
--
ALTER TABLE `new_currencies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `options_items`
--
ALTER TABLE `options_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=666;

--
-- AUTO_INCREMENT for table `order_checkout_masters`
--
ALTER TABLE `order_checkout_masters`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=309;

--
-- AUTO_INCREMENT for table `order_histories`
--
ALTER TABLE `order_histories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1998;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=793;

--
-- AUTO_INCREMENT for table `order_returns`
--
ALTER TABLE `order_returns`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `package_paments`
--
ALTER TABLE `package_paments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `payment_orders`
--
ALTER TABLE `payment_orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=404;

--
-- AUTO_INCREMENT for table `payouts`
--
ALTER TABLE `payouts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `pickups`
--
ALTER TABLE `pickups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `product_deal`
--
ALTER TABLE `product_deal`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1005;

--
-- AUTO_INCREMENT for table `product_options`
--
ALTER TABLE `product_options`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=600;

--
-- AUTO_INCREMENT for table `product_ratings`
--
ALTER TABLE `product_ratings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `product_sab_categories`
--
ALTER TABLE `product_sab_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36686;

--
-- AUTO_INCREMENT for table `product_sessions`
--
ALTER TABLE `product_sessions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `refund_requests`
--
ALTER TABLE `refund_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `requirements`
--
ALTER TABLE `requirements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sessions`
--
ALTER TABLE `sessions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `shipments`
--
ALTER TABLE `shipments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `transfers`
--
ALTER TABLE `transfers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_addresses`
--
ALTER TABLE `user_addresses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;

--
-- AUTO_INCREMENT for table `websockets_statistics_entries`
--
ALTER TABLE `websockets_statistics_entries`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdrawal_requests`
--
ALTER TABLE `withdrawal_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`);

--
-- 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 `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 `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transfers`
--
ALTER TABLE `transfers`
  ADD CONSTRAINT `transfers_deposit_id_foreign` FOREIGN KEY (`deposit_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfers_withdraw_id_foreign` FOREIGN KEY (`withdraw_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;
COMMIT;

