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

START TRANSACTION;



--
-- Database: `focusit1_courier2`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` int(11) DEFAULT NULL COMMENT '1=Admin, 2=User',
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gateway` tinyint(4) DEFAULT NULL,
  `balance` decimal(16,2) NOT NULL DEFAULT 0.00,
  `account_holder_name` varchar(191) DEFAULT NULL,
  `account_no` varchar(191) DEFAULT NULL,
  `bank` tinyint(4) DEFAULT NULL,
  `branch_name` varchar(191) DEFAULT NULL,
  `opening_balance` decimal(16,2) DEFAULT NULL,
  `mobile` varchar(191) DEFAULT NULL,
  `account_type` tinyint(4) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `account_heads`
--

CREATE TABLE `account_heads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` int(11) DEFAULT NULL COMMENT '1=Income, 2=Expense',
  `name` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `account_heads`
--

INSERT INTO `account_heads` (`id`, `type`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Payment received from Merchant', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 1, 'Cash received from delivery man', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 1, 'Others', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 2, 'Payment paid to merchant', 0, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 2, 'Commission paid to delivery man', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 2, 'Others', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(7, 1, 'Payment receive from hub', 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `log_name` varchar(191) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_type` varchar(191) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_type` varchar(191) DEFAULT NULL,
  `causer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `batch_uuid` char(36) 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 `activity_log`
--

INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
(1, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 1, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 2, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user2.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(3, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 3, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user3.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(4, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 4, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user4.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(5, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 5, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user5.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(6, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 6, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user6.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(7, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 7, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user7.png\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(8, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 1, NULL, NULL, '{\"attributes\":{\"name\":\"Mirpur-10\",\"phone\":\"01000000001\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(9, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 2, NULL, NULL, '{\"attributes\":{\"name\":\"Uttara\",\"phone\":\"01000000002\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(10, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 3, NULL, NULL, '{\"attributes\":{\"name\":\"Dhanmundi\",\"phone\":\"01000000003\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(11, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 4, NULL, NULL, '{\"attributes\":{\"name\":\"Old Dhaka\",\"phone\":\"01000000004\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(12, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 5, NULL, NULL, '{\"attributes\":{\"name\":\"Jatrabari\",\"phone\":\"01000000005\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(13, 'Hub', 'created', 'App\\Models\\Backend\\Hub', 'created', 6, NULL, NULL, '{\"attributes\":{\"name\":\"Badda\",\"phone\":\"01000000006\",\"address\":\"Dhaka, Bangladesh\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(14, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 1, NULL, NULL, '{\"attributes\":{\"title\":\"General Management\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(15, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 2, NULL, NULL, '{\"attributes\":{\"title\":\"Marketing\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(16, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 3, NULL, NULL, '{\"attributes\":{\"title\":\"Operations\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(17, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 4, NULL, NULL, '{\"attributes\":{\"title\":\"Finance\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(18, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 5, NULL, NULL, '{\"attributes\":{\"title\":\"Sales\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(19, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 6, NULL, NULL, '{\"attributes\":{\"title\":\"Human Resource\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(20, 'Department', 'created', 'App\\Models\\Backend\\Department', 'created', 7, NULL, NULL, '{\"attributes\":{\"title\":\"Purchase\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(21, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 1, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Executive Officer (CEO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(22, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 2, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Operating Officer (COO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(23, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 3, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Financial Officer (CFO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(24, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 4, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Technology Officer (CTO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(25, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 5, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Legal Officer (CLO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(26, 'Designation', 'created', 'App\\Models\\Backend\\Designation', 'created', 6, NULL, NULL, '{\"attributes\":{\"title\":\"Chief Marketing Officer (CMO)\"}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(27, 'Role', 'created', 'App\\Models\\Backend\\Role', 'created', 1, NULL, NULL, '{\"attributes\":{\"name\":\"Super Admin\",\"permissions\":[\"dashboard_read\",\"calendar_read\",\"total_parcel\",\"total_user\",\"total_merchant\",\"total_delivery_man\",\"total_hubs\",\"total_accounts\",\"total_parcels_pending\",\"total_pickup_assigned\",\"total_received_warehouse\",\"total_deliveryman_assigned\",\"total_partial_deliverd\",\"total_parcels_deliverd\",\"recent_accounts\",\"recent_salary\",\"recent_hub\",\"all_statements\",\"income_expense_charts\",\"merchant_revenue_charts\",\"deliveryman_revenue_charts\",\"courier_revenue_charts\",\"recent_parcels\",\"bank_transaction\",\"log_read\",\"hub_read\",\"hub_create\",\"hub_update\",\"hub_delete\",\"hub_incharge_read\",\"hub_incharge_create\",\"hub_incharge_update\",\"hub_incharge_delete\",\"hub_incharge_assigned\",\"account_read\",\"account_create\",\"account_update\",\"account_delete\",\"income_read\",\"income_create\",\"income_update\",\"income_delete\",\"expense_read\",\"expense_create\",\"expense_update\",\"expense_delete\",\"todo_read\",\"todo_create\",\"todo_update\",\"todo_delete\",\"fund_transfer_read\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"role_read\",\"role_create\",\"role_update\",\"role_delete\",\"designation_read\",\"designation_create\",\"designation_update\",\"designation_delete\",\"department_read\",\"department_create\",\"department_update\",\"department_delete\",\"user_read\",\"user_create\",\"user_update\",\"user_delete\",\"permission_update\",\"merchant_read\",\"merchant_create\",\"merchant_update\",\"merchant_delete\",\"merchant_view\",\"merchant_delivery_charge_read\",\"merchant_delivery_charge_create\",\"merchant_delivery_charge_update\",\"merchant_delivery_charge_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_update\",\"merchant_shop_delete\",\"merchant_payment_read\",\"merchant_payment_create\",\"merchant_payment_update\",\"merchant_payment_delete\",\"payment_read\",\"payment_create\",\"payment_update\",\"payment_delete\",\"payment_reject\",\"payment_process\",\"hub_payment_read\",\"hub_payment_create\",\"hub_payment_update\",\"hub_payment_delete\",\"hub_payment_reject\",\"hub_payment_process\",\"hub_payment_request_read\",\"hub_payment_request_create\",\"hub_payment_request_update\",\"hub_payment_request_delete\",\"parcel_read\",\"parcel_create\",\"parcel_update\",\"parcel_delete\",\"parcel_status_update\",\"delivery_man_read\",\"delivery_man_create\",\"delivery_man_update\",\"delivery_man_delete\",\"delivery_category_read\",\"delivery_category_create\",\"delivery_category_update\",\"delivery_category_delete\",\"delivery_charge_read\",\"delivery_charge_create\",\"delivery_charge_update\",\"delivery_charge_delete\",\"delivery_type_read\",\"delivery_type_status_change\",\"liquid_fragile_read\",\"liquid_fragile_update\",\"liquid_status_change\",\"packaging_read\",\"packaging_create\",\"packaging_update\",\"packaging_delete\",\"category_read\",\"category_create\",\"category_update\",\"category_delete\",\"account_heads_read\",\"database_backup_read\",\"salary_read\",\"salary_create\",\"salary_update\",\"salary_delete\",\"support_read\",\"support_create\",\"support_update\",\"support_delete\",\"support_reply\",\"support_status_update\",\"sms_settings_read\",\"sms_settings_create\",\"sms_settings_update\",\"sms_settings_delete\",\"sms_send_settings_read\",\"sms_send_settings_create\",\"sms_send_settings_update\",\"sms_send_settings_delete\",\"general_settings_read\",\"general_settings_update\",\"notification_settings_read\",\"notification_settings_update\",\"push_notification_read\",\"push_notification_create\",\"push_notification_update\",\"push_notification_delete\",\"asset_category_read\",\"asset_category_create\",\"asset_category_update\",\"asset_category_delete\",\"news_offer_read\",\"news_offer_create\",\"news_offer_update\",\"news_offer_delete\",\"parcel_status_reports\",\"parcel_wise_profit\",\"parcel_total_summery\",\"salary_reports\",\"merchant_hub_deliveryman\",\"salary_generate_read\",\"salary_generate_create\",\"salary_generate_update\",\"salary_generate_delete\",\"assets_read\",\"assets_create\",\"assets_update\",\"assets_delete\",\"fraud_read\",\"fraud_create\",\"fraud_update\",\"fraud_delete\",\"subscribe_read\",\"pickup_request_regular\",\"pickup_request_express\",\"invoice_read\",\"invoice_status_update\",\"social_login_settings_read\",\"social_login_settings_update\",\"payout_setup_settings_read\",\"payout_setup_settings_update\",\"online_payment_read\",\"payout_read\",\"payout_create\",\"hub_view\",\"paid_invoice_read\",\"invoice_generate_menually\",\"currency_read\",\"currency_create\",\"currency_update\",\"currency_delete\",\"social_link_read\",\"social_link_create\",\"social_link_update\",\"social_link_delete\",\"service_read\",\"service_create\",\"service_update\",\"service_delete\",\"why_courier_read\",\"why_courier_create\",\"why_courier_update\",\"why_courier_delete\",\"faq_read\",\"faq_create\",\"faq_update\",\"faq_delete\",\"partner_read\",\"partner_create\",\"partner_update\",\"partner_delete\",\"blogs_read\",\"blogs_create\",\"blogs_update\",\"blogs_delete\",\"pages_read\",\"pages_update\",\"section_read\",\"section_update\",\"wallet_request_read\",\"wallet_request_create\",\"wallet_request_delete\",\"wallet_request_approve\",\"wallet_request_reject\"]}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(28, 'Role', 'created', 'App\\Models\\Backend\\Role', 'created', 2, NULL, NULL, '{\"attributes\":{\"name\":\"Admin\",\"permissions\":[\"dashboard_read\",\"calendar_read\",\"total_parcel\",\"total_user\",\"total_merchant\",\"total_delivery_man\",\"total_hubs\",\"total_accounts\",\"total_parcels_pending\",\"total_pickup_assigned\",\"total_received_warehouse\",\"total_deliveryman_assigned\",\"total_partial_deliverd\",\"total_parcels_deliverd\",\"recent_accounts\",\"recent_salary\",\"recent_hub\",\"all_statements\",\"income_expense_charts\",\"merchant_revenue_charts\",\"deliveryman_revenue_charts\",\"courier_revenue_charts\",\"recent_parcels\",\"bank_transaction\",\"log_read\",\"hub_read\",\"hub_incharge_read\",\"account_read\",\"income_read\",\"expense_read\",\"todo_read\",\"sms_settings_read\",\"sms_send_settings_read\",\"general_settings_read\",\"notification_settings_read\",\"push_notification_read\",\"push_notification_create\",\"push_notification_update\",\"push_notification_delete\",\"account_heads_read\",\"salary_read\",\"support_read\",\"fund_transfer_read\",\"role_read\",\"designation_read\",\"department_read\",\"user_read\",\"merchant_read\",\"merchant_delivery_charge_read\",\"merchant_shop_read\",\"merchant_payment_read\",\"payment_read\",\"hub_payment_request_read\",\"hub_payment_read\",\"parcel_read\",\"delivery_man_read\",\"delivery_category_read\",\"delivery_charge_read\",\"delivery_type_read\",\"liquid_fragile_read\",\"packaging_read\",\"category_read\",\"asset_category_read\",\"news_offer_read\",\"sms_settings_status_change\",\"sms_send_settings_status_change\",\"bank_transaction_read\",\"database_backup_read\",\"parcel_status_reports\",\"parcel_wise_profit\",\"parcel_total_summery\",\"salary_reports\",\"merchant_hub_deliveryman\",\"salary_generate_read\",\"assets_read\",\"fraud_read\",\"subscribe_read\",\"pickup_request_regular\",\"pickup_request_express\",\"cash_received_from_delivery_man_read\",\"cash_received_from_delivery_man_create\",\"cash_received_from_delivery_man_update\",\"cash_received_from_delivery_man_delete\",\"invoice_read\",\"invoice_status_update\",\"social_login_settings_read\",\"social_login_settings_update\",\"payout_setup_settings_read\",\"online_payment_read\",\"payout_read\",\"hub_view\",\"paid_invoice_read\",\"invoice_generate_menually\",\"currency_read\"]}}', NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(29, 'User', 'created', 'App\\Models\\User', 'created', 1, NULL, NULL, '{\"attributes\":{\"name\":\"WemaxDevs\",\"email\":\"admin@wemaxdevs.com\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(30, 'User', 'created', 'App\\Models\\User', 'created', 2, NULL, NULL, '{\"attributes\":{\"name\":\"Branch\",\"email\":\"branch@wemaxdevs.com\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(31, 'User', 'created', 'App\\Models\\User', 'created', 3, NULL, NULL, '{\"attributes\":{\"name\":\"Delivery Man\",\"email\":\"deliveryman@wemaxit.com\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(32, 'DeliveryMan', 'created', 'App\\Models\\Backend\\DeliveryMan', 'created', 1, NULL, NULL, '{\"attributes\":{\"user.name\":\"Delivery Man\",\"current_balance\":\"0.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(33, 'InCharges', 'created', 'App\\Models\\Backend\\HubInCharge', 'created', 1, NULL, NULL, '{\"attributes\":{\"user.name\":\"Branch\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(34, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 1, NULL, NULL, '{\"attributes\":{\"title\":\"KG\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(35, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 2, NULL, NULL, '{\"attributes\":{\"title\":\"Mobile\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(36, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 3, NULL, NULL, '{\"attributes\":{\"title\":\"Laptop\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(37, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 4, NULL, NULL, '{\"attributes\":{\"title\":\"Tabs\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(38, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 5, NULL, NULL, '{\"attributes\":{\"title\":\"Gaming Kybord\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(39, 'Deliverycategory', 'created', 'App\\Models\\Backend\\Deliverycategory', 'created', 6, NULL, NULL, '{\"attributes\":{\"title\":\"Cosmetices\",\"description\":null}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(40, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 1, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"1\",\"same_day\":\"50.00\",\"next_day\":\"60.00\",\"sub_city\":\"70.00\",\"outside_city\":\"80.00\",\"position\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(41, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 2, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"2\",\"same_day\":\"90.00\",\"next_day\":\"100.00\",\"sub_city\":\"110.00\",\"outside_city\":\"120.00\",\"position\":\"2\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(42, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 3, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"3\",\"same_day\":\"130.00\",\"next_day\":\"140.00\",\"sub_city\":\"150.00\",\"outside_city\":\"160.00\",\"position\":\"3\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(43, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 4, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"4\",\"same_day\":\"170.00\",\"next_day\":\"180.00\",\"sub_city\":\"190.00\",\"outside_city\":\"200.00\",\"position\":\"4\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(44, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 5, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"5\",\"same_day\":\"210.00\",\"next_day\":\"220.00\",\"sub_city\":\"230.00\",\"outside_city\":\"240.00\",\"position\":\"5\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(45, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 6, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"6\",\"same_day\":\"250.00\",\"next_day\":\"260.00\",\"sub_city\":\"270.00\",\"outside_city\":\"280.00\",\"position\":\"6\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(46, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 7, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"7\",\"same_day\":\"290.00\",\"next_day\":\"300.00\",\"sub_city\":\"310.00\",\"outside_city\":\"320.00\",\"position\":\"7\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(47, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 8, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"8\",\"same_day\":\"340.00\",\"next_day\":\"350.00\",\"sub_city\":\"360.00\",\"outside_city\":\"370.00\",\"position\":\"8\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(48, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 9, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"9\",\"same_day\":\"380.00\",\"next_day\":\"390.00\",\"sub_city\":\"400.00\",\"outside_city\":\"410.00\",\"position\":\"9\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(49, 'DeliveryCharge', 'created', 'App\\Models\\Backend\\DeliveryCharge', 'created', 10, NULL, NULL, '{\"attributes\":{\"category.name\":null,\"weight\":\"10\",\"same_day\":\"420.00\",\"next_day\":\"430.00\",\"sub_city\":\"440.00\",\"outside_city\":\"450.00\",\"position\":\"10\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(50, 'User', 'created', 'App\\Models\\User', 'created', 4, NULL, NULL, '{\"attributes\":{\"name\":\"Merchant\",\"email\":\"merchant@wemaxdevs.com\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(51, 'Merchant', 'created', 'App\\Models\\Backend\\Merchant', 'created', 1, NULL, NULL, '{\"attributes\":{\"user.name\":\"Merchant\",\"business_name\":\"WemaxDevs\",\"current_balance\":\"0.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(52, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 1, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"1\",\"same_day\":\"50.00\",\"next_day\":\"60.00\",\"sub_city\":\"70.00\",\"outside_city\":\"80.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(53, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 2, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"2\",\"same_day\":\"90.00\",\"next_day\":\"100.00\",\"sub_city\":\"110.00\",\"outside_city\":\"120.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(54, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 3, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"3\",\"same_day\":\"130.00\",\"next_day\":\"140.00\",\"sub_city\":\"150.00\",\"outside_city\":\"160.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(55, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 4, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"4\",\"same_day\":\"170.00\",\"next_day\":\"180.00\",\"sub_city\":\"190.00\",\"outside_city\":\"200.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(56, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 5, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"5\",\"same_day\":\"210.00\",\"next_day\":\"220.00\",\"sub_city\":\"230.00\",\"outside_city\":\"240.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(57, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 6, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"6\",\"same_day\":\"250.00\",\"next_day\":\"260.00\",\"sub_city\":\"270.00\",\"outside_city\":\"280.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(58, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 7, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"7\",\"same_day\":\"290.00\",\"next_day\":\"300.00\",\"sub_city\":\"310.00\",\"outside_city\":\"320.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(59, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 8, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"8\",\"same_day\":\"340.00\",\"next_day\":\"350.00\",\"sub_city\":\"360.00\",\"outside_city\":\"370.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(60, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 9, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"9\",\"same_day\":\"380.00\",\"next_day\":\"390.00\",\"sub_city\":\"400.00\",\"outside_city\":\"410.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(61, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 10, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"deliveryCharge.category.title\":\"KG\",\"weight\":\"10\",\"same_day\":\"420.00\",\"next_day\":\"430.00\",\"sub_city\":\"440.00\",\"outside_city\":\"450.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(62, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 1, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"name\":\"Shop 1\",\"contact_no\":\"+88013000000\",\"address\":\"Wemaxdevs,Dhaka\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(63, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 2, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"name\":\"Shop 2\",\"contact_no\":\"+88013000000\",\"address\":\"Wemaxdevs,Dhaka\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(64, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 3, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"name\":\"Shop 3\",\"contact_no\":\"+88013000000\",\"address\":\"Wemaxdevs,Dhaka\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(65, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 4, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"name\":\"Shop 4\",\"contact_no\":\"+88013000000\",\"address\":\"Wemaxdevs,Dhaka\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(66, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 5, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"WemaxDevs\",\"name\":\"Shop 5\",\"contact_no\":\"+88013000000\",\"address\":\"Wemaxdevs,Dhaka\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(67, 'Config', 'created', 'App\\Models\\Config', 'created', 1, NULL, NULL, '{\"attributes\":{\"key\":\"fragile_liquid_status\",\"value\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(68, 'Config', 'created', 'App\\Models\\Config', 'created', 2, NULL, NULL, '{\"attributes\":{\"key\":\"fragile_liquid_charge\",\"value\":\"20\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(69, 'Config', 'created', 'App\\Models\\Config', 'created', 3, NULL, NULL, '{\"attributes\":{\"key\":\"same_day\",\"value\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(70, 'Config', 'created', 'App\\Models\\Config', 'created', 4, NULL, NULL, '{\"attributes\":{\"key\":\"next_day\",\"value\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(71, 'Config', 'created', 'App\\Models\\Config', 'created', 5, NULL, NULL, '{\"attributes\":{\"key\":\"sub_city\",\"value\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(72, 'Config', 'created', 'App\\Models\\Config', 'created', 6, NULL, NULL, '{\"attributes\":{\"key\":\"outside_City\",\"value\":\"1\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(73, 'Packaging', 'created', 'App\\Models\\Backend\\Packaging', 'created', 1, NULL, NULL, '{\"attributes\":{\"name\":\"Poly\",\"price\":\"10.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(74, 'Packaging', 'created', 'App\\Models\\Backend\\Packaging', 'created', 2, NULL, NULL, '{\"attributes\":{\"name\":\"Bubble Poly\",\"price\":\"20.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(75, 'Packaging', 'created', 'App\\Models\\Backend\\Packaging', 'created', 3, NULL, NULL, '{\"attributes\":{\"name\":\"Box\",\"price\":\"30.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(76, 'Packaging', 'created', 'App\\Models\\Backend\\Packaging', 'created', 4, NULL, NULL, '{\"attributes\":{\"name\":\"Box Poly\",\"price\":\"40.00\"}}', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(77, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 1, NULL, NULL, '{\"attributes\":{\"key\":\"reve_api_key\",\"value\":\"a7e4166cc9967d80\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(78, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 2, NULL, NULL, '{\"attributes\":{\"key\":\"reve_secret_key\",\"value\":\"e863dd2f\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(79, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 3, NULL, NULL, '{\"attributes\":{\"key\":\"reve_api_url\",\"value\":\"http:\\/\\/smpp.ajuratech.com:7788\\/sendtext\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(80, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 4, NULL, NULL, '{\"attributes\":{\"key\":\"reve_username\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(81, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 5, NULL, NULL, '{\"attributes\":{\"key\":\"reve_user_password\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(82, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 6, NULL, NULL, '{\"attributes\":{\"key\":\"reve_status\",\"value\":\"0\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(83, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 7, NULL, NULL, '{\"attributes\":{\"key\":\"twilio_sid\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(84, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 8, NULL, NULL, '{\"attributes\":{\"key\":\"twilio_token\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(85, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 9, NULL, NULL, '{\"attributes\":{\"key\":\"twilio_from\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(86, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 10, NULL, NULL, '{\"attributes\":{\"key\":\"twilio_status\",\"value\":\"0\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(87, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 11, NULL, NULL, '{\"attributes\":{\"key\":\"nexmo_key\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(88, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 12, NULL, NULL, '{\"attributes\":{\"key\":\"nexmo_secret_key\",\"value\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(89, 'smsSettings', 'created', 'App\\Models\\Backend\\SmsSetting', 'created', 13, NULL, NULL, '{\"attributes\":{\"key\":\"nexmo_status\",\"value\":\"0\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(90, 'SmsSendSetting', 'created', 'App\\Models\\Backend\\SmsSendSetting', 'created', 1, NULL, NULL, '{\"attributes\":{\"sms_send_status\":\"1\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(91, 'SmsSendSetting', 'created', 'App\\Models\\Backend\\SmsSendSetting', 'created', 2, NULL, NULL, '{\"attributes\":{\"sms_send_status\":\"2\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(92, 'SmsSendSetting', 'created', 'App\\Models\\Backend\\SmsSendSetting', 'created', 3, NULL, NULL, '{\"attributes\":{\"sms_send_status\":\"3\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(93, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 8, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user8.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(94, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 9, NULL, NULL, '{\"attributes\":{\"original\":\"uploads\\/users\\/user9.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(95, 'General Settings', 'created', 'App\\Models\\Backend\\GeneralSettings', 'created', 1, NULL, NULL, '{\"attributes\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(96, 'Notification Settings', 'created', 'App\\Models\\Backend\\NotificationSettings', 'created', 1, NULL, NULL, '{\"attributes\":{\"fcm_secret_key\":\"\",\"fcm_topic\":\"\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(97, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 10, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/services\\/truck.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(98, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 11, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/services\\/pick-drop.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(99, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 12, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/services\\/packageing.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(100, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 13, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/services\\/warehouse.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(101, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 14, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/timly-delivery.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(102, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 15, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/limitless-pickup.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(103, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 16, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/cash-on-delivery.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(104, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 17, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/payment.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(105, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 18, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/handling.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(106, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 19, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/whycourier\\/live-tracking.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(107, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 20, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/1.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(108, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 21, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/atom.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(109, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 22, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/digg.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(110, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 23, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/2.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(111, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 24, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/huawei.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(112, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 25, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/ups.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(113, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 26, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/1.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(114, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 27, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/atom.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(115, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 28, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/digg.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(116, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 29, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/2.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(117, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 30, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/huawei.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(118, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 31, NULL, NULL, '{\"attributes\":{\"original\":\"frontend\\/images\\/partner\\/ups.png\"}}', NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(119, 'User', 'updated', 'App\\Models\\User', 'updated', 1, NULL, NULL, '{\"attributes\":{\"name\":\"elitedes Hello\",\"email\":\"elitedesign.com.bd@gmail.com\"},\"old\":{\"name\":\"WemaxDevs\",\"email\":\"admin@wemaxdevs.com\"}}', NULL, '2025-01-31 00:26:10', '2025-01-31 00:26:10'),
(120, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 8, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/settings\\/202501311225443229.png\"},\"old\":{\"original\":\"uploads\\/users\\/user8.png\"}}', NULL, '2025-01-31 20:25:44', '2025-01-31 20:25:44'),
(121, 'General Settings', 'updated', 'App\\Models\\Backend\\GeneralSettings', 'updated', 1, 'App\\Models\\User', 1, '{\"attributes\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null},\"old\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-01-31 20:25:44', '2025-01-31 20:25:44'),
(122, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 9, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/settings\\/202501311325553739.png\"},\"old\":{\"original\":\"uploads\\/users\\/user9.png\"}}', NULL, '2025-01-31 21:25:55', '2025-01-31 21:25:55'),
(123, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 32, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/section\\/20250131154423.svg\"}}', NULL, '2025-01-31 23:44:23', '2025-01-31 23:44:23'),
(124, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 23, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/partner\\/20250131164347.png\"},\"old\":{\"original\":\"frontend\\/images\\/partner\\/2.png\"}}', NULL, '2025-02-01 00:43:47', '2025-02-01 00:43:47'),
(125, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 22, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/partner\\/20250131164406.png\"},\"old\":{\"original\":\"frontend\\/images\\/partner\\/digg.png\"}}', NULL, '2025-02-01 00:44:06', '2025-02-01 00:44:06'),
(126, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 21, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/partner\\/20250131164435.png\"},\"old\":{\"original\":\"frontend\\/images\\/partner\\/atom.png\"}}', NULL, '2025-02-01 00:44:35', '2025-02-01 00:44:35'),
(127, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 31, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/partner\\/20250131164456.png\"},\"old\":{\"original\":\"frontend\\/images\\/partner\\/ups.png\"}}', NULL, '2025-02-01 00:44:56', '2025-02-01 00:44:56'),
(128, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 30, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/partner\\/20250131164517.png\"},\"old\":{\"original\":\"frontend\\/images\\/partner\\/huawei.png\"}}', NULL, '2025-02-01 00:45:17', '2025-02-01 00:45:17'),
(129, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 10, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/service\\/20250202132016.png\"},\"old\":{\"original\":\"frontend\\/images\\/services\\/truck.png\"}}', NULL, '2025-02-02 21:20:17', '2025-02-02 21:20:17'),
(130, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 11, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/service\\/20250202132616.png\"},\"old\":{\"original\":\"frontend\\/images\\/services\\/pick-drop.png\"}}', NULL, '2025-02-02 21:26:16', '2025-02-02 21:26:16'),
(131, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 12, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/service\\/20250202132818.png\"},\"old\":{\"original\":\"frontend\\/images\\/services\\/packageing.png\"}}', NULL, '2025-02-02 21:28:18', '2025-02-02 21:28:18'),
(132, 'Upload', 'updated', 'App\\Models\\Backend\\Upload', 'updated', 13, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/service\\/20250202133030.png\"},\"old\":{\"original\":\"frontend\\/images\\/services\\/warehouse.png\"}}', NULL, '2025-02-02 21:30:30', '2025-02-02 21:30:30'),
(133, 'User', 'created', 'App\\Models\\User', 'created', 5, NULL, NULL, '{\"attributes\":{\"name\":\"vvv\",\"email\":null}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(134, 'Merchant', 'created', 'App\\Models\\Backend\\Merchant', 'created', 2, NULL, NULL, '{\"attributes\":{\"user.name\":\"vvv\",\"business_name\":\"vvvv\",\"current_balance\":\"0.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(135, 'MerchantShops', 'created', 'App\\Models\\MerchantShops', 'created', 6, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"name\":\"vvvv\",\"contact_no\":\"01775457008\",\"address\":\"gggg\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(136, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 11, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":1,\"same_day\":\"50.00\",\"next_day\":\"60.00\",\"sub_city\":\"70.00\",\"outside_city\":\"80.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(137, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 12, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":2,\"same_day\":\"90.00\",\"next_day\":\"100.00\",\"sub_city\":\"110.00\",\"outside_city\":\"120.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(138, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 13, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":3,\"same_day\":\"130.00\",\"next_day\":\"140.00\",\"sub_city\":\"150.00\",\"outside_city\":\"160.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(139, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 14, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":4,\"same_day\":\"170.00\",\"next_day\":\"180.00\",\"sub_city\":\"190.00\",\"outside_city\":\"200.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(140, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 15, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":5,\"same_day\":\"210.00\",\"next_day\":\"220.00\",\"sub_city\":\"230.00\",\"outside_city\":\"240.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(141, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 16, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":6,\"same_day\":\"250.00\",\"next_day\":\"260.00\",\"sub_city\":\"270.00\",\"outside_city\":\"280.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(142, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 17, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":7,\"same_day\":\"290.00\",\"next_day\":\"300.00\",\"sub_city\":\"310.00\",\"outside_city\":\"320.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(143, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 18, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":8,\"same_day\":\"340.00\",\"next_day\":\"350.00\",\"sub_city\":\"360.00\",\"outside_city\":\"370.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(144, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 19, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":9,\"same_day\":\"380.00\",\"next_day\":\"390.00\",\"sub_city\":\"400.00\",\"outside_city\":\"410.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(145, 'MerchantDeliveryCharge', 'created', 'App\\Models\\Backend\\MerchantDeliveryCharge', 'created', 20, NULL, NULL, '{\"attributes\":{\"merchant.business_name\":\"vvvv\",\"deliveryCharge.category.title\":\"KG\",\"weight\":10,\"same_day\":\"420.00\",\"next_day\":\"430.00\",\"sub_city\":\"440.00\",\"outside_city\":\"450.00\"}}', NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(146, 'Upload', 'created', 'App\\Models\\Backend\\Upload', 'created', 33, 'App\\Models\\User', 1, '{\"attributes\":{\"original\":\"uploads\\/settings\\/202502021604486190.png\"}}', NULL, '2025-02-03 00:04:48', '2025-02-03 00:04:48'),
(147, 'General Settings', 'updated', 'App\\Models\\Backend\\GeneralSettings', 'updated', 1, 'App\\Models\\User', 1, '{\"attributes\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null},\"old\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-02-03 00:04:48', '2025-02-03 00:04:48'),
(148, 'General Settings', 'updated', 'App\\Models\\Backend\\GeneralSettings', 'updated', 1, 'App\\Models\\User', 1, '{\"attributes\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null},\"old\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-02-03 00:06:28', '2025-02-03 00:06:28'),
(149, 'General Settings', 'updated', 'App\\Models\\Backend\\GeneralSettings', 'updated', 1, 'App\\Models\\User', 1, '{\"attributes\":{\"phone\":\"+8801849832178\",\"name\":\"Steadfast Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null},\"old\":{\"phone\":\"20022002\",\"name\":\"We Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-02-03 00:20:01', '2025-02-03 00:20:01'),
(150, 'General Settings', 'updated', 'App\\Models\\Backend\\GeneralSettings', 'updated', 1, 'App\\Models\\User', 1, '{\"attributes\":{\"phone\":\"+8801774846415\",\"name\":\"Steadfast Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null},\"old\":{\"phone\":\"+8801849832178\",\"name\":\"Steadfast Courier\",\"tracking_id\":null,\"details\":null,\"prefix\":null}}', NULL, '2025-10-09 12:17:12', '2025-10-09 12:17:12');

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

--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `unique_identifier` varchar(191) DEFAULT NULL,
  `version` varchar(191) DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `purchase_code` longtext DEFAULT NULL,
  `activated` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `assetcategories`
--

CREATE TABLE `assetcategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `position` varchar(191) 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 `assets`
--

CREATE TABLE `assets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `author` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `assetcategory_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supplyer_name` varchar(191) DEFAULT NULL,
  `quantity` varchar(191) DEFAULT NULL,
  `warranty` varchar(191) DEFAULT NULL,
  `invoice_no` varchar(191) DEFAULT NULL,
  `amount` decimal(13,2) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bank_transactions`
--

CREATE TABLE `bank_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_type` tinyint(3) UNSIGNED DEFAULT 1 COMMENT '1=Admin,5=hub',
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `expense_id` bigint(20) DEFAULT NULL,
  `fund_transfer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1, expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `cash_received_dvry` varchar(191) DEFAULT NULL,
  `income_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `views` varchar(191) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `image_id`, `description`, `position`, `status`, `created_by`, `views`, `created_at`, `updated_at`) VALUES
(1, 'Quasi in ut rerum repellendus velit totam ratione vel sint id consequuntur.', NULL, 'Iure voluptas facilis architecto et magnam illum nobis totam voluptate voluptatem corporis iusto ea porro excepturi eius magnam consequatur porro rem corrupti quo atque deleniti sed pariatur sint eos facilis aperiam sed et at repellendus ipsam pariatur culpa ex quis quo dolorem et at ad blanditiis quod id praesentium dicta rem vitae culpa animi nulla tempora accusamus rerum ex ut consequatur ipsam incidunt eum doloremque optio ipsum consectetur officia quasi praesentium consequatur sunt unde sed pariatur consequatur porro fugit voluptatibus dolorem fugit distinctio adipisci unde non.', '0', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(2, 'Eum dolores eligendi magni enim repudiandae molestiae alias.', NULL, 'Eaque sit ut accusamus quam qui quo maiores culpa accusantium excepturi dignissimos quidem qui est nihil minus blanditiis necessitatibus at autem placeat adipisci exercitationem sunt dolores id molestiae optio minus odio tenetur hic sunt dolore ducimus id aut laudantium in animi perspiciatis facere laudantium quasi nihil quis nihil nisi reiciendis voluptatem suscipit labore minima vero dolores omnis rerum culpa quidem ipsam voluptates sequi reiciendis ut repellat quisquam et dolorem voluptatum sed magni odit quas libero sed vitae enim ipsum molestiae autem est enim rem laudantium enim temporibus mollitia modi animi eos sint voluptas eum veritatis qui est at ipsam corporis odio autem exercitationem tenetur consequatur neque mollitia atque mollitia minus amet magnam et minus enim praesentium minima et illo aut aspernatur ut est non et minus commodi consequuntur sunt.', '1', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'Eum non quidem sit id ipsa et qui eligendi.', NULL, 'Veniam doloremque iure et non fugiat eum molestiae necessitatibus aut quis sed eos molestiae eaque vero eligendi quam enim vel ipsa vel autem sed qui itaque consequatur laudantium dolores odit illum pariatur accusantium corporis et ipsa aut labore fuga et consequatur rem ab est quis temporibus quas dolores veniam adipisci mollitia ea autem enim maxime consequatur nobis quae consequuntur inventore quaerat qui odit qui voluptas id assumenda alias quia.', '2', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'Perferendis qui sint possimus omnis rem consectetur eum perferendis.', NULL, 'Corrupti facilis voluptate molestiae maxime molestiae a voluptatem consequatur magnam rerum architecto commodi et illo sed maxime voluptas quaerat dolorum ea earum voluptatem non excepturi aut voluptatibus assumenda dolores quasi et ipsum asperiores dolores illo debitis aut autem qui quibusdam quidem mollitia ipsam repellendus aut doloremque ut et dolor corrupti iste voluptas qui unde sunt et quibusdam totam tempora voluptatem ad alias architecto nostrum incidunt rem ut deleniti deserunt magnam quia illum.', '3', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(5, 'Ea corrupti maiores aut mollitia impedit provident aut minus magnam incidunt iusto quia.', NULL, 'Eum officiis qui et accusantium dolore excepturi id temporibus repudiandae delectus commodi non ea eos consequuntur dolorum eos ipsam adipisci consequatur vitae sunt ut quod aut dolores aut quia quos molestiae eligendi nam non necessitatibus tenetur rerum voluptatem pariatur qui dolores nihil itaque fugit autem commodi sunt autem omnis fuga quidem error nemo placeat maiores ut ut ipsam quia at mollitia sequi qui consequatur expedita dolor libero explicabo similique recusandae voluptatem at.', '4', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(6, 'Necessitatibus aliquam ut voluptas et beatae modi qui corrupti eius et.', NULL, 'Minus et ea qui dolor qui delectus atque et quasi molestiae esse exercitationem enim animi ea rerum ab quo quam est quo quia ut ipsa rerum dolor quas deserunt qui aspernatur veritatis assumenda numquam et non quis consequatur a mollitia quaerat iusto sed et vel aliquid dolorem saepe et necessitatibus non nihil qui consequatur dolores consequatur delectus in omnis nihil voluptas voluptatem vel velit iste quis quas facere cumque recusandae inventore molestiae velit qui excepturi doloremque sed optio sequi nesciunt autem quasi magnam magni est qui facilis et est rerum earum fugiat quam.', '5', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(7, 'Impedit veniam ea porro libero numquam provident voluptatem.', NULL, 'Est quibusdam repellat odit sunt asperiores aut quidem doloremque unde fuga explicabo veniam voluptas aliquam dolorem quia sed repudiandae non alias ducimus ullam consequatur aut amet ut doloremque sed aperiam asperiores animi voluptatum odio officia voluptatem quod non qui recusandae quia aliquid totam ab veniam dolorem esse voluptatum ut quo qui fugiat molestiae totam dignissimos earum sit iste sint soluta recusandae qui molestiae nemo fuga inventore officiis perspiciatis tempora magni modi tempore ullam sunt voluptatem aspernatur ullam veritatis.', '6', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(8, 'Nihil necessitatibus iure culpa totam totam placeat nam eveniet.', NULL, 'Quo voluptatem sint assumenda dolor illum laboriosam qui eaque cumque aut et aut numquam eveniet accusantium qui consequatur autem consequatur nulla minus eos qui deserunt deserunt excepturi cum magni beatae sapiente doloremque consequatur itaque ea expedita consequatur ut ducimus impedit error minus iusto cupiditate qui aut consequatur ratione fuga rem quis aliquid sunt est et dolores quam autem velit ratione maiores sint soluta quod iste modi iure sequi itaque minima blanditiis quia a rerum dolor suscipit tenetur impedit officiis libero sunt autem aliquam sunt dolores iusto harum ducimus corporis cum sequi a dolores aut vero praesentium et quis dicta iusto debitis error aut voluptates velit autem earum dolorem occaecati recusandae tempore sint cumque earum sit quae corporis incidunt earum dolorum vitae occaecati ipsum omnis sapiente hic aut molestias reprehenderit quam dignissimos voluptatum animi est expedita placeat iusto aut modi.', '7', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(9, 'Facere corporis ipsum doloribus quaerat et rerum eaque ea minima excepturi voluptate.', NULL, 'Vel hic quos distinctio et esse inventore tempore delectus sint modi qui voluptas autem exercitationem repudiandae quam deleniti quas aliquam et vel deleniti dolorem voluptate dolorem iste sit qui doloremque inventore expedita voluptatem suscipit aut eius autem aperiam magni ipsam quod nobis est iusto voluptas voluptatum nostrum aut iste et fuga similique qui dolores et optio unde id architecto aut necessitatibus dicta corrupti fuga unde iure animi reiciendis et maiores aut fugit amet reprehenderit est voluptate recusandae enim similique minima voluptatum tempora molestiae ducimus iste et sit aut asperiores consectetur aliquam reprehenderit quis atque itaque quaerat consectetur qui dolorem.', '8', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(10, 'Repellat totam dolorem sint odio iusto voluptates voluptates est assumenda tempora ut placeat fugiat.', NULL, 'Et velit nihil blanditiis quis modi sapiente quaerat dolorem vitae perferendis consequuntur neque doloremque aut suscipit rerum veniam aut mollitia nostrum mollitia temporibus sint amet perspiciatis quo optio est nam est sit inventore quaerat nobis quo molestiae accusamus omnis ex expedita eos sunt sint ut et a molestias iusto aperiam quod ea et accusantium in repellendus esse optio sint dolorem soluta iste voluptatem vel debitis et voluptate aut ducimus quod et quaerat repellat labore ab est autem aut odio autem vel earum est blanditiis sunt iure quos vel est saepe nihil minima.', '9', 1, 1, '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `cash_received_from_deliverymen`
--

CREATE TABLE `cash_received_from_deliverymen` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `receipt` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categorys`
--

CREATE TABLE `categorys` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `configs`
--

CREATE TABLE `configs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) DEFAULT NULL,
  `value` varchar(191) 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 `configs`
--

INSERT INTO `configs` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'fragile_liquid_status', '1', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 'fragile_liquid_charge', '20', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 'same_day', '1', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 'next_day', '1', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 'sub_city', '1', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 'outside_City', '1', '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `courier_statements`
--

CREATE TABLE `courier_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `income_id` bigint(20) UNSIGNED DEFAULT NULL,
  `expense_id` bigint(20) DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1,expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `symbol` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `exchange_rate` decimal(16,2) DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `country`, `name`, `symbol`, `code`, `exchange_rate`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Albania', 'Leke', 'Lek', 'ALL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(2, 'America', 'Dollars', '$', 'USD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(3, 'Afghanistan', 'Afghanis', '؋', 'AF', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(4, 'Argentina', 'Pesos', '$', 'ARS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(5, 'Aruba', 'Guilders', 'ƒ', 'AWG', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(6, 'Australia', 'Dollars', '$', 'AUD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(7, 'Azerbaijan', 'New Manats', 'ман', 'AZ', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(8, 'Bahamas', 'Dollars', '$', 'BSD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(9, 'Barbados', 'Dollars', '$', 'BBD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(10, 'Belarus', 'Rubles', 'p.', 'BYR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(11, 'Belgium', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(12, 'Beliz', 'Dollars', 'BZ$', 'BZD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(13, 'Bermuda', 'Dollars', '$', 'BMD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(14, 'Bolivia', 'Bolivianos', '$b', 'BOB', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(15, 'Bosnia and Herzegovina', 'Convertible Marka', 'KM', 'BAM', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(16, 'Botswana', 'Pula\'s', 'P', 'BWP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(17, 'Bulgaria', 'Leva', 'лв', 'BG', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(18, 'Brazil', 'Reais', 'R$', 'BRL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(19, 'Britain [United Kingdom]', 'Pounds', '£', 'GBP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(20, 'Brunei Darussalam', 'Dollars', '$', 'BND', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(21, 'Cambodia', 'Riels', '៛', 'KHR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(22, 'Canada', 'Dollars', '$', 'CAD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(23, 'Cayman Islands', 'Dollars', '$', 'KYD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(24, 'Chile', 'Pesos', '$', 'CLP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(25, 'China', 'Yuan Renminbi', '¥', 'CNY', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(26, 'Colombia', 'Pesos', '$', 'COP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(27, 'Costa Rica', 'Colón', '₡', 'CRC', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(28, 'Croatia', 'Kuna', 'kn', 'HRK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(29, 'Cuba', 'Pesos', '₱', 'CUP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(30, 'Cyprus', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(31, 'Czech Republic', 'Koruny', 'Kč', 'CZK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(32, 'Denmark', 'Kroner', 'kr', 'DKK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(33, 'Dominican Republic', 'Pesos', 'RD$', 'DOP ', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(34, 'East Caribbean', 'Dollars', '$', 'XCD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(35, 'Egypt', 'Pounds', '£', 'EGP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(36, 'El Salvador', 'Colones', '$', 'SVC', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(37, 'England [United Kingdom]', 'Pounds', '£', 'GBP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(38, 'Euro', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(39, 'Falkland Islands', 'Pounds', '£', 'FKP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(40, 'Fiji', 'Dollars', '$', 'FJD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(41, 'France', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(42, 'Ghana', 'Cedis', '¢', 'GHS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(43, 'Gibraltar', 'Pounds', '£', 'GIP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(44, 'Greece', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(45, 'Guatemala', 'Quetzales', 'Q', 'GTQ', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(46, 'Guernsey', 'Pounds', '£', 'GGP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(47, 'Guyana', 'Dollars', '$', 'GYD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(48, 'Holland [Netherlands]', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(49, 'Honduras', 'Lempiras', 'L', 'HNL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(50, 'Hong Kong', 'Dollars', '$', 'HKD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(51, 'Hungary', 'Forint', 'Ft', 'HUF', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(52, 'Iceland', 'Kronur', 'kr', 'ISK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(53, 'India', 'Rupees', '₹', 'INR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(54, 'Indonesia', 'Rupiahs', 'Rp', 'IDR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(55, 'Iran', 'Rials', '﷼', 'IRR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(56, 'Ireland', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(57, 'Isle of Man', 'Pounds', '£', 'IMP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(58, 'Israel', 'New Shekels', '₪', 'ILS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(59, 'Italy', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(60, 'Jamaica', 'Dollars', 'J$', 'JMD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(61, 'Japan', 'Yen', '¥', 'JPY', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(62, 'Jersey', 'Pounds', '£', 'JEP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(63, 'Kazakhstan', 'Tenge', 'лв', 'KZT', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(64, 'Korea [North]', 'Won', '₩', 'KPW', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(65, 'Korea [South]', 'Won', '₩', 'KRW', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(66, 'Kyrgyzstan', 'Soms', 'лв', 'KGS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(67, 'Laos', 'Kips', '₭', 'LAK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(68, 'Latvia', 'Lati', 'Ls', 'LVL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(69, 'Lebanon', 'Pounds', '£', 'LBP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(70, 'Liberia', 'Dollars', '$', 'LRD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(71, 'Liechtenstein', 'Switzerland Francs', 'CHF', 'CHF', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(72, 'Lithuania', 'Litai', 'Lt', 'LTL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(73, 'Luxembourg', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(74, 'Macedonia', 'Denars', 'ден', 'MKD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(75, 'Malaysia', 'Ringgits', 'RM', 'MYR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(76, 'Malta', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(77, 'Mauritius', 'Rupees', '₨', 'MUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(78, 'Mexico', 'Pesos', '$', 'MXN', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(79, 'Mongolia', 'Tugriks', '₮', 'MNT', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(80, 'Mozambique', 'Meticais', 'MT', 'MZ', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(81, 'Namibia', 'Dollars', '$', 'NAD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(82, 'Nepal', 'Rupees', '₨', 'NPR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(83, 'Netherlands Antilles', 'Guilders', 'ƒ', 'ANG', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(84, 'Netherlands', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(85, 'New Zealand', 'Dollars', '$', 'NZD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(86, 'Nicaragua', 'Cordobas', 'C$', 'NIO', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(87, 'Nigeria', 'Nairas', '₦', 'NGN', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(88, 'North Korea', 'Won', '₩', 'KPW', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(89, 'Norway', 'Krone', 'kr', 'NOK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(90, 'Oman', 'Rials', '﷼', 'OMR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(91, 'Pakistan', 'Rupees', '₨', 'PKR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(92, 'Panama', 'Balboa', 'B/.', 'PAB', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(93, 'Paraguay', 'Guarani', 'Gs', 'PYG', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(94, 'Peru', 'Nuevos Soles', 'S/.', 'PE', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(95, 'Philippines', 'Pesos', 'Php', 'PHP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(96, 'Poland', 'Zlotych', 'zł', 'PL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(97, 'Qatar', 'Rials', '﷼', 'QAR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(98, 'Romania', 'New Lei', 'lei', 'RO', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(99, 'Russia', 'Rubles', 'руб', 'RUB', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(100, 'Saint Helena', 'Pounds', '£', 'SHP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(101, 'Saudi Arabia', 'Riyals', '﷼', 'SAR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(102, 'Serbia', 'Dinars', 'Дин.', 'RSD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(103, 'Seychelles', 'Rupees', '₨', 'SCR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(104, 'Singapore', 'Dollars', '$', 'SGD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(105, 'Slovenia', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(106, 'Solomon Islands', 'Dollars', '$', 'SBD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(107, 'Somalia', 'Shillings', 'S', 'SOS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(108, 'South Africa', 'Rand', 'R', 'ZAR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(109, 'South Korea', 'Won', '₩', 'KRW', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(110, 'Spain', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(111, 'Sri Lanka', 'Rupees', '₨', 'LKR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(112, 'Sweden', 'Kronor', 'kr', 'SEK', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(113, 'Switzerland', 'Francs', 'CHF', 'CHF', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(114, 'Suriname', 'Dollars', '$', 'SRD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(115, 'Syria', 'Pounds', '£', 'SYP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(116, 'Taiwan', 'New Dollars', 'NT$', 'TWD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(117, 'Thailand', 'Baht', '฿', 'THB', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(118, 'Trinidad and Tobago', 'Dollars', 'TT$', 'TTD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(119, 'Turkey', 'Lira', 'TL', 'TRY', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(120, 'Turkey', 'Liras', '£', 'TRL', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(121, 'Tuvalu', 'Dollars', '$', 'TVD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(122, 'Ukraine', 'Hryvnia', '₴', 'UAH', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(123, 'United Kingdom', 'Pounds', '£', 'GBP', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(124, 'United States of America', 'Dollars', '$', 'USD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(125, 'Uruguay', 'Pesos', '$U', 'UYU', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(126, 'Uzbekistan', 'Sums', 'лв', 'UZS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(127, 'Vatican City', 'Euro', '€', 'EUR', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(128, 'Venezuela', 'Bolivares Fuertes', 'Bs', 'VEF', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(129, 'Vietnam', 'Dong', '₫', 'VND', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(130, 'Yemen', 'Rials', '﷼', 'YER', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(131, 'Zimbabwe', 'Zimbabwe Dollars', 'Z$', 'ZWD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(132, 'Iraq', 'Iraqi dinar', 'د.ع', 'IQD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(133, 'Kenya', 'Kenyan shilling', 'KSh', 'KES', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(134, 'Bangladesh', 'Taka', '৳', 'BDT', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(135, 'Algerie', 'Algerian dinar', 'د.ج', 'DZD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(136, 'United Arab Emirates', 'United Arab Emirates dirham', 'د.إ', 'AED', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(137, 'Uganda', 'Uganda shillings', 'USh', 'UGX', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(138, 'Tanzania', 'Tanzanian shilling', 'TSh', 'TZS', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(139, 'Angola', 'Kwanza', 'Kz', 'AOA', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(140, 'Kuwait', 'Kuwaiti dinar', 'KD', 'KWD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09'),
(141, 'Bahrain', 'Bahraini dinar', 'BD', 'BHD', NULL, NULL, 1, '2022-12-14 02:30:09', '2022-12-14 02:30:09');

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

--
-- Table structure for table `deliverycategories`
--

CREATE TABLE `deliverycategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `position` int(11) 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 `deliverycategories`
--

INSERT INTO `deliverycategories` (`id`, `title`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'KG', 1, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 'Mobile', 1, 2, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 'Laptop', 1, 3, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 'Tabs', 1, 4, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 'Gaming Kybord', 1, 5, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 'Cosmetices', 1, 6, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `deliveryman_statements`
--

CREATE TABLE `deliveryman_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `expense_id` bigint(20) DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1,expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `cash_collection` tinyint(3) UNSIGNED DEFAULT 0 COMMENT 'true=1,false=0',
  `date` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `delivery_charges`
--

CREATE TABLE `delivery_charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `weight` tinyint(4) NOT NULL DEFAULT 0,
  `same_day` decimal(16,2) NOT NULL DEFAULT 0.00,
  `next_day` decimal(16,2) NOT NULL DEFAULT 0.00,
  `sub_city` decimal(16,2) NOT NULL DEFAULT 0.00,
  `outside_city` decimal(16,2) NOT NULL DEFAULT 0.00,
  `position` int(11) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_charges`
--

INSERT INTO `delivery_charges` (`id`, `category_id`, `weight`, `same_day`, `next_day`, `sub_city`, `outside_city`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 50.00, 60.00, 70.00, 80.00, 1, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 1, 2, 90.00, 100.00, 110.00, 120.00, 2, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 1, 3, 130.00, 140.00, 150.00, 160.00, 3, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 1, 4, 170.00, 180.00, 190.00, 200.00, 4, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 1, 5, 210.00, 220.00, 230.00, 240.00, 5, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 1, 6, 250.00, 260.00, 270.00, 280.00, 6, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(7, 1, 7, 290.00, 300.00, 310.00, 320.00, 7, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(8, 1, 8, 340.00, 350.00, 360.00, 370.00, 8, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(9, 1, 9, 380.00, 390.00, 400.00, 410.00, 9, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(10, 1, 10, 420.00, 430.00, 440.00, 450.00, 10, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `delivery_man`
--

CREATE TABLE `delivery_man` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `delivery_lat` varchar(191) DEFAULT NULL,
  `delivery_long` varchar(191) DEFAULT NULL,
  `delivery_charge` decimal(13,2) NOT NULL DEFAULT 0.00,
  `pickup_charge` decimal(13,2) NOT NULL DEFAULT 0.00,
  `return_charge` decimal(13,2) NOT NULL DEFAULT 0.00,
  `current_balance` decimal(13,2) NOT NULL DEFAULT 0.00,
  `opening_balance` decimal(13,2) NOT NULL DEFAULT 0.00,
  `driving_license_image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_man`
--

INSERT INTO `delivery_man` (`id`, `user_id`, `status`, `delivery_lat`, `delivery_long`, `delivery_charge`, `pickup_charge`, `return_charge`, `current_balance`, `opening_balance`, `driving_license_image_id`, `created_at`, `updated_at`) VALUES
(1, 3, 1, NULL, NULL, 30.00, 20.00, 10.00, 0.00, 0.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `departments`
--

INSERT INTO `departments` (`id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 'General Management', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'Marketing', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(3, 'Operations', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(4, 'Finance', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(5, 'Sales', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(6, 'Human Resource', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(7, 'Purchase', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07');

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `designations`
--

INSERT INTO `designations` (`id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Chief Executive Officer (CEO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'Chief Operating Officer (COO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(3, 'Chief Financial Officer (CFO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(4, 'Chief Technology Officer (CTO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(5, 'Chief Legal Officer (CLO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(6, 'Chief Marketing Officer (CMO)', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07');

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_head_id` bigint(20) UNSIGNED DEFAULT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `receipt` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(191) DEFAULT NULL,
  `answer` longtext DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 'What is wecourier Delivery?', 'Aliquid possimus animi aliquam eos quia commodi accusamus quae architecto esse fugit nobis iure non qui magnam qui et eligendi temporibus impedit et modi vel consectetur quia ad eveniet iure quos molestiae et aut eligendi exercitationem.', '1', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(2, 'How do I contact you?', 'Commodi modi dolorum accusantium inventore ex magni labore labore maiores exercitationem nam perspiciatis eum quisquam beatae reiciendis quia modi ea vero nihil esse ratione repudiandae quaerat beatae ex illo sed sit et.', '2', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'How can a merchant track their parcel delivery?', 'Hic blanditiis adipisci in sapiente maiores maxime voluptatem ab et quaerat odio et ratione harum natus voluptas sint dolores non saepe assumenda repudiandae autem autem ipsa dignissimos illum ipsa non qui earum rerum consequatur molestiae.', '3', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'How do I send a product/ courier via wecourier Delivery?', 'Dolor vel et alias earum esse adipisci sed ab dolore sit non provident non vero animi nobis et voluptatem eos quo id ut corrupti maxime corrupti reprehenderit eos mollitia incidunt harum.', '4', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(5, 'I want to hold a parcel for more than 3 days before home delivery. Is it possible?', 'Rerum repellendus non dignissimos incidunt aut ipsum fugit at quis doloremque voluptate enim dolor facere et qui aperiam rerum repudiandae ut enim nihil beatae voluptatem eveniet architecto officia impedit eum sit culpa.', '5', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(6, 'Can you do product exchange from customers?', 'Eos ea quia architecto est dolores pariatur accusantium veniam quibusdam unde alias culpa asperiores sapiente qui enim id voluptatibus quibusdam quia assumenda iure quae repellat impedit omnis ipsum et excepturi.', '6', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(7, 'Can you deliver to addresses inside Cantonment or other restricted areas?', 'Autem placeat at eum nam eos illum repellat vel ut dolore commodi accusamus sed numquam ea nostrum voluptatem qui nisi ut iste officia nesciunt aut voluptatibus vitae officiis ab consequatur consequuntur odio explicabo aut nam.', '7', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(8, 'I do not have a Facebook page, can I register as a merchant?', 'Molestias amet porro qui qui quia recusandae quas sit sunt qui dignissimos laudantium repellat voluptatum alias dolorum beatae quas omnis dolores occaecati voluptatem unde voluptatem expedita eaque dolores nisi est rerum libero aut.', '8', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(9, 'What kind of products does wecourier deliver?', 'Et voluptatem id aliquam itaque laudantium id aliquam ipsa sunt voluptas illo sint cupiditate et esse maiores architecto exercitationem ducimus cum eius corporis ex aspernatur sint.', '9', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `frauds`
--

CREATE TABLE `frauds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `tracking_id` varchar(191) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fund_transfers`
--

CREATE TABLE `fund_transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_account` bigint(20) UNSIGNED DEFAULT NULL,
  `to_account` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `currency` varchar(191) DEFAULT NULL,
  `copyright` varchar(191) DEFAULT NULL,
  `logo` int(11) DEFAULT NULL,
  `light_logo` int(11) DEFAULT NULL,
  `favicon` int(11) DEFAULT NULL,
  `current_version` varchar(191) DEFAULT NULL,
  `par_track_prefix` varchar(191) DEFAULT NULL,
  `invoice_prefix` varchar(191) DEFAULT NULL,
  `primary_color` varchar(191) DEFAULT '#7e0095',
  `text_color` varchar(191) DEFAULT '#ffffff',
  `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 `general_settings`
--

INSERT INTO `general_settings` (`id`, `name`, `phone`, `email`, `address`, `currency`, `copyright`, `logo`, `light_logo`, `favicon`, `current_version`, `par_track_prefix`, `invoice_prefix`, `primary_color`, `text_color`, `created_at`, `updated_at`) VALUES
(1, 'Steadfast Courier', '+8801774846415', 'info@focusitfarm.site', 'Lohagara – 7511, Lohagara, Narail.', '৳', '© 2016 - 2025 SteadFast Courier Ltd. All rights reserved.', 8, 33, 9, '1', 'ST', 'ST', '#349574', '#ffffff', '2025-01-31 00:26:09', '2025-10-09 12:17:12');

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

--
-- Table structure for table `google_map_settings`
--

CREATE TABLE `google_map_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `map_key` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hubs`
--

CREATE TABLE `hubs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `hub_lat` varchar(191) DEFAULT NULL,
  `hub_long` varchar(191) DEFAULT NULL,
  `current_balance` decimal(16,2) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `hubs`
--

INSERT INTO `hubs` (`id`, `name`, `phone`, `address`, `hub_lat`, `hub_long`, `current_balance`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mirpur-10', '01000000001', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'Uttara', '01000000002', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(3, 'Dhanmundi', '01000000003', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(4, 'Old Dhaka', '01000000004', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(5, 'Jatrabari', '01000000005', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(6, 'Badda', '01000000006', 'Dhaka, Bangladesh', NULL, NULL, 0.00, 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07');

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

--
-- Table structure for table `hub_incharges`
--

CREATE TABLE `hub_incharges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `hub_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `hub_incharges`
--

INSERT INTO `hub_incharges` (`id`, `user_id`, `hub_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `hub_payments`
--

CREATE TABLE `hub_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `from_account` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_file` bigint(20) UNSIGNED DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL COMMENT '1=admin,4=incharge',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 3 COMMENT '1= Reject,2=Approved , 3= Pending,4=Process, ',
  `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 `hub_statements`
--

CREATE TABLE `hub_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1,expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `incomes`
--

CREATE TABLE `incomes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_head_id` bigint(20) UNSIGNED DEFAULT NULL,
  `from` tinyint(3) UNSIGNED DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_user_account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `receipt` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` varchar(191) DEFAULT NULL,
  `invoice_date` varchar(191) DEFAULT NULL,
  `total_charge` decimal(16,2) DEFAULT NULL,
  `cash_collection` decimal(16,2) DEFAULT NULL,
  `current_payable` decimal(16,2) DEFAULT NULL,
  `parcels_id` longtext DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 2 COMMENT ' Unpaid      = 0, Processing  = 2, Paid        = 3',
  `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 `merchants`
--

CREATE TABLE `merchants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `business_name` varchar(191) NOT NULL,
  `merchant_unique_id` varchar(191) DEFAULT NULL,
  `current_balance` decimal(16,2) NOT NULL DEFAULT 0.00,
  `opening_balance` decimal(16,2) NOT NULL DEFAULT 0.00,
  `wallet_balance` decimal(16,2) NOT NULL DEFAULT 0.00,
  `vat` decimal(16,2) NOT NULL DEFAULT 0.00,
  `cod_charges` longtext DEFAULT NULL,
  `nid_id` bigint(20) UNSIGNED DEFAULT NULL,
  `trade_license` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_period` varchar(191) NOT NULL DEFAULT '2' COMMENT '2 = 2days , after every 2days will auto payment invoice generate',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `address` longtext DEFAULT NULL,
  `wallet_use_activation` tinyint(3) UNSIGNED DEFAULT 0,
  `return_charges` decimal(16,2) NOT NULL DEFAULT 100.00 COMMENT '100 = 100%  means full charge will received courier',
  `reference_name` varchar(191) DEFAULT NULL,
  `reference_phone` varchar(191) 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 `merchants`
--

INSERT INTO `merchants` (`id`, `user_id`, `business_name`, `merchant_unique_id`, `current_balance`, `opening_balance`, `wallet_balance`, `vat`, `cod_charges`, `nid_id`, `trade_license`, `payment_period`, `status`, `address`, `wallet_use_activation`, `return_charges`, `reference_name`, `reference_phone`, `created_at`, `updated_at`) VALUES
(1, 4, 'WemaxDevs', '251111', 0.00, 0.00, 0.00, 0.00, '{\"inside_city\":\"1\",\"sub_city\":\"2\",\"outside_city\":\"3\"}', 4, 5, '2', 1, 'Dhaka', 0, 100.00, NULL, NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 5, 'vvvv', '885482', 0.00, 0.00, 0.00, 0.00, '{\"inside_city\":\"0\",\"sub_city\":\"0\",\"outside_city\":\"0\"}', NULL, NULL, '2', 1, 'gggg', 0, 100.00, NULL, NULL, '2025-02-03 00:03:54', '2025-02-03 00:03:54');

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

--
-- Table structure for table `merchant_delivery_charges`
--

CREATE TABLE `merchant_delivery_charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_charge_id` bigint(20) UNSIGNED DEFAULT NULL,
  `weight` bigint(20) DEFAULT NULL,
  `category_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `same_day` decimal(16,2) DEFAULT NULL,
  `next_day` decimal(16,2) DEFAULT NULL,
  `sub_city` decimal(16,2) DEFAULT NULL,
  `outside_city` decimal(16,2) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `merchant_delivery_charges`
--

INSERT INTO `merchant_delivery_charges` (`id`, `merchant_id`, `delivery_charge_id`, `weight`, `category_id`, `same_day`, `next_day`, `sub_city`, `outside_city`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 50.00, 60.00, 70.00, 80.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 1, 2, 2, 1, 90.00, 100.00, 110.00, 120.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 1, 3, 3, 1, 130.00, 140.00, 150.00, 160.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 1, 4, 4, 1, 170.00, 180.00, 190.00, 200.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 1, 5, 5, 1, 210.00, 220.00, 230.00, 240.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 1, 6, 6, 1, 250.00, 260.00, 270.00, 280.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(7, 1, 7, 7, 1, 290.00, 300.00, 310.00, 320.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(8, 1, 8, 8, 1, 340.00, 350.00, 360.00, 370.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(9, 1, 9, 9, 1, 380.00, 390.00, 400.00, 410.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(10, 1, 10, 10, 1, 420.00, 430.00, 440.00, 450.00, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(11, 2, 1, 1, 1, 50.00, 60.00, 70.00, 80.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(12, 2, 2, 2, 1, 90.00, 100.00, 110.00, 120.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(13, 2, 3, 3, 1, 130.00, 140.00, 150.00, 160.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(14, 2, 4, 4, 1, 170.00, 180.00, 190.00, 200.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(15, 2, 5, 5, 1, 210.00, 220.00, 230.00, 240.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(16, 2, 6, 6, 1, 250.00, 260.00, 270.00, 280.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(17, 2, 7, 7, 1, 290.00, 300.00, 310.00, 320.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(18, 2, 8, 8, 1, 340.00, 350.00, 360.00, 370.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(19, 2, 9, 9, 1, 380.00, 390.00, 400.00, 410.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54'),
(20, 2, 10, 10, 1, 420.00, 430.00, 440.00, 450.00, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54');

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

--
-- Table structure for table `merchant_online_payments`
--

CREATE TABLE `merchant_online_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_type` tinyint(4) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `status` varchar(191) 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 `merchant_online_payment_receiveds`
--

CREATE TABLE `merchant_online_payment_receiveds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_type` tinyint(4) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `status` varchar(191) 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 `merchant_payments`
--

CREATE TABLE `merchant_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `holder_name` varchar(191) DEFAULT NULL,
  `account_no` varchar(191) DEFAULT NULL,
  `branch_name` varchar(191) DEFAULT NULL,
  `routing_no` varchar(191) DEFAULT NULL,
  `mobile_company` varchar(191) DEFAULT NULL,
  `mobile_no` varchar(191) DEFAULT NULL,
  `account_type` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `merchant_shops`
--

CREATE TABLE `merchant_shops` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `contact_no` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `merchant_lat` varchar(191) DEFAULT NULL,
  `merchant_long` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `default_shop` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1=Active, 0=Inactive',
  `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 `merchant_shops`
--

INSERT INTO `merchant_shops` (`id`, `merchant_id`, `name`, `contact_no`, `address`, `merchant_lat`, `merchant_long`, `status`, `default_shop`, `created_at`, `updated_at`) VALUES
(1, 1, 'Shop 1', '+88013000000', 'Wemaxdevs,Dhaka', NULL, NULL, 1, 1, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 1, 'Shop 2', '+88013000000', 'Wemaxdevs,Dhaka', NULL, NULL, 1, 0, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 1, 'Shop 3', '+88013000000', 'Wemaxdevs,Dhaka', NULL, NULL, 1, 0, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 1, 'Shop 4', '+88013000000', 'Wemaxdevs,Dhaka', NULL, NULL, 1, 0, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 1, 'Shop 5', '+88013000000', 'Wemaxdevs,Dhaka', NULL, NULL, 1, 0, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 2, 'vvvv', '01775457008', 'gggg', NULL, NULL, 1, 1, '2025-02-03 00:03:54', '2025-02-03 00:03:54');

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

--
-- Table structure for table `merchant_statements`
--

CREATE TABLE `merchant_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `expense_id` bigint(20) DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1,expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_09_12_000000_create_hubs_table', 1),
(2, '2014_09_12_000000_create_uploads_table', 1),
(3, '2014_10_10_040240_create_roles_table', 1),
(4, '2014_10_11_000000_create_deliverycategories_table', 1),
(5, '2014_10_11_000000_create_departments_table', 1),
(6, '2014_10_11_000000_create_designations_table', 1),
(7, '2014_10_11_000000_create_packagings_table', 1),
(8, '2014_10_11_000000_create_users_table', 1),
(9, '2014_10_11_000001_create_merchants_table', 1),
(10, '2014_10_12_100000_create_password_resets_table', 1),
(11, '2019_08_19_000000_create_failed_jobs_table', 1),
(12, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(13, '2022_02_15_122629_create_push_notifications_table', 1),
(14, '2022_03_20_060621_create_categories_table', 1),
(15, '2022_03_24_042455_create_activity_log_table', 1),
(16, '2022_03_24_042456_add_event_column_to_activity_log_table', 1),
(17, '2022_03_24_042457_add_batch_uuid_column_to_activity_log_table', 1),
(18, '2022_04_04_142330_create_delivery_man_table', 1),
(19, '2022_04_04_142330_create_hub_incharges_table', 1),
(20, '2022_04_04_142330_create_parcels_table', 1),
(21, '2022_04_09_101126_create_delivery_charges_table', 1),
(22, '2022_04_09_101126_create_merchant_delivery_charges_table', 1),
(23, '2022_04_10_050353_create_merchant_shops_table', 1),
(24, '2022_04_13_034848_create_merchant_payments_table', 1),
(25, '2022_04_13_054047_create_accounts_table', 1),
(26, '2022_04_14_045839_create_fund_transfers_table', 1),
(27, '2022_04_14_063624_create_payments_table', 1),
(28, '2022_04_17_061311_create_payment_accounts_table', 1),
(29, '2022_04_19_035758_create_configs_table', 1),
(30, '2022_04_20_053011_create_sessions_table', 1),
(31, '2022_04_23_032024_create_permissions_table', 1),
(32, '2022_04_24_045606_create_parcel_logs_table', 1),
(33, '2022_04_27_123343_create_parcel_events_table', 1),
(34, '2022_05_14_112714_create_account_heads_table', 1),
(35, '2022_05_14_112715_create_expenses_table', 1),
(36, '2022_05_14_112717_create_deliveryman_statements_table', 1),
(37, '2022_05_15_102801_create_merchant_statements_table', 1),
(38, '2022_05_17_124213_create_incomes_table', 1),
(39, '2022_05_17_132716_create_courier_statements_table', 1),
(40, '2022_05_18_113259_create_to_dos_table', 1),
(41, '2022_05_23_111055_create_supports_table', 1),
(42, '2022_05_23_122723_create_sms_send_settings_table', 1),
(43, '2022_05_23_122723_create_sms_settings_table', 1),
(44, '2022_05_24_141546_create_vat_statements_table', 1),
(45, '2022_05_26_093710_create_bank_transactions_table', 1),
(46, '2022_05_31_094551_create_general_settings_table', 1),
(47, '2022_05_31_094551_create_notification_settings_table', 1),
(48, '2022_05_31_122026_create_assets_table', 1),
(49, '2022_05_31_122655_create_assetcategories_table', 1),
(50, '2022_05_31_150039_create_salaries_table', 1),
(51, '2022_05_6_063624_create_hub_payments_table', 1),
(52, '2022_06_01_144229_create_news_offers_table', 1),
(53, '2022_06_02_125218_create_support_chats_table', 1),
(54, '2022_06_04_104751_create_hub_statements_table', 1),
(55, '2022_06_05_093107_create_frauds_table', 1),
(56, '2022_06_05_140650_create_cash_received_from_deliverymen_table', 1),
(57, '2022_06_12_111844_create_salary_generates_table', 1),
(58, '2022_08_17_145916_create_subscribes_table', 1),
(59, '2022_09_08_102027_create_pickup_requests_table', 1),
(60, '2022_10_11_121745_create_invoices_table', 1),
(61, '2022_10_17_102458_create_settings_table', 1),
(62, '2022_10_30_135339_create_merchant_online_payments_table', 1),
(63, '2022_11_02_105821_create_merchant_online_payment_receiveds_table', 1),
(64, '2022_11_02_113430_create_merchant_settings_table', 1),
(65, '2022_12_08_104319_create_addons_table', 1),
(66, '2022_12_08_104319_create_currencies_table', 1),
(67, '2023_06_11_172412_create_social_links_table', 1),
(68, '2023_06_12_144849_create_services_table', 1),
(69, '2023_06_13_111335_create_why_couriers_table', 1),
(70, '2023_06_13_122133_create_faqs_table', 1),
(71, '2023_06_13_133544_create_partners_table', 1),
(72, '2023_06_13_154945_create_blogs_table', 1),
(73, '2023_06_13_164933_create_pages_table', 1),
(74, '2023_06_13_180141_create_sections_table', 1),
(75, '2023_10_17_122352_create_wallets_table', 1),
(76, '2023_10_8_094551_create_google_map_settings_table', 1);

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

--
-- Table structure for table `news_offers`
--

CREATE TABLE `news_offers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `author` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `file` bigint(20) UNSIGNED DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'active       = 1,\r\n                inactive      = 0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `packagings`
--

CREATE TABLE `packagings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `price` decimal(16,2) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `position` varchar(191) DEFAULT NULL,
  `photo` varchar(191) 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 `packagings`
--

INSERT INTO `packagings` (`id`, `name`, `price`, `status`, `position`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Poly', 10.00, 1, '1', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 'Bubble Poly', 20.00, 1, '2', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 'Box', 30.00, 1, '3', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 'Box Poly', 40.00, 1, '4', NULL, '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `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 `pages`
--

INSERT INTO `pages` (`id`, `page`, `title`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'privacy_policy', 'Privacy & Policy', 'Deleniti magnam dignissimos similique a dolorem magni culpa vero voluptatem quia nostrum officia itaque velit reiciendis corporis quia officia labore odit maiores dolor aspernatur eum beatae alias sed et tempore dignissimos nesciunt iusto iste facere tenetur quod adipisci natus sint cumque quia cupiditate vitae rerum velit rerum quibusdam consequatur sed sequi aut qui incidunt qui repudiandae mollitia tenetur fuga inventore assumenda qui vitae molestiae consequatur aut et libero similique quidem eligendi vero mollitia dolores quos aut dolores molestias repellat quod tenetur voluptas impedit illo tempora voluptatem enim nulla voluptate qui est quo temporibus aperiam blanditiis commodi et et ut id quisquam ut suscipit cumque atque voluptas veritatis aut eligendi atque ut sunt tempora consequatur et soluta maxime nesciunt molestias est quam atque doloremque in quia aut est quasi qui minima modi explicabo sunt sit ipsa sit ipsum ipsum et quos beatae molestiae voluptas aliquid distinctio aut earum laborum libero omnis dolor voluptatem nobis aut ut ullam voluptatem labore magnam veniam voluptatum blanditiis eum unde laudantium atque aperiam a perspiciatis excepturi aperiam in quo ea ut sequi iste cumque illo iste natus rerum velit labore eum odit non eum voluptate voluptas expedita cupiditate a dolorem nulla rerum facilis illum officiis repellendus sed quis officiis rerum inventore molestias voluptatem expedita quia enim quo neque labore architecto quos vel in omnis saepe optio et et et nobis odio id suscipit vero nisi maxime ab magni est quos voluptatem adipisci illum quaerat delectus explicabo est laboriosam pariatur qui deleniti error aut aliquid et molestias animi facilis et perspiciatis ut ab incidunt incidunt maxime vel deleniti impedit voluptas labore et delectus id ipsam deleniti maiores excepturi esse aut iure ipsam vero officia fuga repellat molestias dolorem molestiae laboriosam repellendus nemo qui pariatur libero nisi recusandae aspernatur neque dolorum voluptatem magni quo quia sequi distinctio itaque cupiditate reiciendis ea quisquam nam ut vero ut non velit eveniet fuga voluptatibus molestias velit tenetur eos ex quam voluptatibus officiis dolorem non sit dolorem temporibus accusamus magni corrupti quia a saepe qui nam rerum culpa dicta quia et veniam cupiditate ut maiores aliquid eaque odio sint quia tempore ut nemo doloremque omnis expedita qui molestias deserunt repudiandae esse beatae et est eum praesentium dolor omnis cum laboriosam ipsa sit eos id sint minima alias molestiae sint voluptate exercitationem excepturi molestiae accusamus quia minima enim sunt nulla accusantium dolor voluptas nostrum et velit veritatis sunt cupiditate possimus quibusdam itaque repellendus eos officiis ipsum iusto qui cupiditate repellendus quod unde accusamus voluptatem sunt soluta eius molestiae neque ipsa molestiae dicta dolor placeat non sunt quidem molestiae aperiam sunt suscipit placeat ut sapiente molestiae suscipit velit aliquam dolores dolorem ex beatae ut aliquid quae repudiandae consequatur laudantium minima ut voluptatem dolorum iusto ea explicabo suscipit et at voluptatem autem mollitia fugiat modi sequi eum reiciendis aut quam suscipit ut aut cupiditate non non dolores dolorem tempore ut dolorem ex fugit est fugiat nesciunt fugit corrupti consequatur ut sit aliquid expedita illum quis quos necessitatibus voluptatem hic dolorum autem aut laborum quam fugiat veritatis mollitia voluptatem culpa ut consequuntur perferendis rerum sit nihil rerum voluptatem voluptatem sit autem hic omnis totam inventore incidunt laborum doloribus cumque esse consequuntur sed tempora vel dolor quisquam qui quaerat voluptas architecto sunt saepe at assumenda quisquam facere et dolorem accusamus quia aliquid dignissimos quis adipisci veniam nemo aut aperiam eum qui molestias voluptates ipsam illum quis accusamus qui illum illum illum possimus odit eius officiis perspiciatis quis soluta ad voluptatem odio sint nulla eum consectetur ut voluptatem veritatis fuga aut iusto repudiandae tempore qui qui sed molestias in aliquam dignissimos sint recusandae ab architecto voluptatem qui mollitia quae sed velit et corporis odit numquam nesciunt quis et et laudantium laboriosam quasi iure animi sit fugit temporibus dolorem alias reiciendis quibusdam nobis quaerat et quam aspernatur ullam laboriosam nesciunt nemo aut tempora consequatur rerum architecto quam maiores itaque necessitatibus molestias quisquam voluptas ut deleniti dolor reprehenderit aut voluptate aut voluptatem porro qui enim beatae minus aperiam qui accusamus cumque aspernatur est dignissimos illum alias quaerat ut earum qui expedita aut placeat hic ut repudiandae earum deleniti ut debitis autem tempora molestiae ea nostrum recusandae aliquid dignissimos qui est ut error laboriosam accusantium enim qui exercitationem illum commodi est quia sunt sit quia dolorem magni repudiandae ratione doloremque blanditiis reiciendis rerum qui fugit repudiandae debitis corrupti omnis maiores vel perspiciatis aliquid vero praesentium et qui ipsam non aliquam dolor incidunt quae eaque nostrum sit doloremque corrupti et nemo eius atque eos enim laborum ea et qui quia quia magni aut odit alias ullam quasi libero quisquam et aut architecto magni sit necessitatibus sint iusto omnis nisi atque voluptas animi natus laborum quia veritatis qui maxime itaque consequatur sapiente quas architecto rerum minus totam est non id quam repellat qui est animi ut omnis consectetur perferendis modi et vel et accusamus similique corporis ea sed est eveniet totam et sunt hic est consequatur repudiandae natus doloribus voluptas recusandae est nisi veniam esse itaque vitae molestiae perferendis fuga dicta nemo cum velit eos at maiores architecto et ducimus consequatur ut aliquid voluptatem nostrum quas exercitationem sed sed atque dolorem vel qui at est in esse et voluptate nemo necessitatibus sunt quia ut accusantium qui odit ex est et autem ex rerum quae sit quasi sit ducimus ipsa est dolores esse pariatur doloribus voluptates quam quaerat et quo accusantium rerum laudantium doloribus voluptatem nulla architecto quibusdam optio non earum a in ipsam adipisci ab aut laboriosam natus alias recusandae quia iure enim expedita in dolorem sint ab rem quia perferendis id soluta voluptatum est modi repudiandae incidunt exercitationem autem fugit itaque voluptatem doloribus aut reprehenderit unde repudiandae quasi aliquam ut impedit dolores in inventore odit deleniti voluptate perferendis quasi cum cumque eligendi corrupti ex quibusdam nulla ut modi modi omnis perferendis numquam qui sit dolorum ipsa sed vel fugiat molestiae architecto ut et voluptatem provident explicabo non autem blanditiis officiis qui occaecati qui in dolor illo voluptas dolore voluptatibus hic sapiente quis quaerat corrupti sequi dolorem illo odio dolore et iusto in sit in aliquam dicta esse sunt a eaque magnam quasi minus quasi a quidem est et excepturi et id nisi dolore ut et laboriosam quasi perspiciatis vitae expedita id quos reiciendis quod est qui numquam hic veniam incidunt qui dolorem aut iure nisi necessitatibus vel quia laudantium et cumque quas tempore totam ex suscipit sunt nulla eos at iusto saepe amet ad unde autem facere ullam nulla sed quidem tempora similique pariatur error ad est ullam voluptatum repudiandae quis aut aut dolorem odit commodi sequi culpa inventore doloribus voluptas molestiae sed aliquam molestias atque nulla animi modi eum ipsam magnam eligendi animi ducimus maxime eius totam et ex eius quis unde corrupti neque sequi eum quia impedit consequatur magni consequatur dolor officia quis praesentium quia veniam earum porro dolores quis quae fuga amet sit enim tenetur vero aut pariatur repellat voluptas consequatur perferendis eum odit vel adipisci explicabo dicta sit enim perferendis minus velit necessitatibus magni deserunt perspiciatis aut quae amet cumque voluptatibus earum doloremque neque esse maiores sed voluptates id magnam ipsa incidunt repellat officiis dolorem nulla mollitia et placeat perspiciatis sed enim harum quis ut nisi facilis architecto nobis et natus fuga dignissimos dignissimos adipisci quisquam molestias ex placeat sint magnam non autem laborum autem nihil quia est architecto tempora earum odit quos hic repellat beatae repudiandae suscipit numquam sapiente maxime laboriosam quia numquam et ea fugit numquam voluptatum sit dicta eum omnis recusandae nobis esse maiores architecto magnam rerum alias et et excepturi cupiditate autem et aut aspernatur reiciendis excepturi iusto sit natus dolores voluptatibus id numquam dolorum provident minima eligendi eum fuga nulla non enim iusto ullam id eum ratione dolores saepe beatae atque voluptatum quis earum perferendis aut accusantium omnis est quibusdam ipsum est voluptas provident.', 1, '2023-06-13 04:57:18', '2023-06-13 04:57:18'),
(2, 'terms_conditions', 'Terms & Conditions', 'Deleniti magnam dignissimos similique a dolorem magni culpa vero voluptatem quia nostrum officia itaque velit reiciendis corporis quia officia labore odit maiores dolor aspernatur eum beatae alias sed et tempore dignissimos nesciunt iusto iste facere tenetur quod adipisci natus sint cumque quia cupiditate vitae rerum velit rerum quibusdam consequatur sed sequi aut qui incidunt qui repudiandae mollitia tenetur fuga inventore assumenda qui vitae molestiae consequatur aut et libero similique quidem eligendi vero mollitia dolores quos aut dolores molestias repellat quod tenetur voluptas impedit illo tempora voluptatem enim nulla voluptate qui est quo temporibus aperiam blanditiis commodi et et ut id quisquam ut suscipit cumque atque voluptas veritatis aut eligendi atque ut sunt tempora consequatur et soluta maxime nesciunt molestias est quam atque doloremque in quia aut est quasi qui minima modi explicabo sunt sit ipsa sit ipsum ipsum et quos beatae molestiae voluptas aliquid distinctio aut earum laborum libero omnis dolor voluptatem nobis aut ut ullam voluptatem labore magnam veniam voluptatum blanditiis eum unde laudantium atque aperiam a perspiciatis excepturi aperiam in quo ea ut sequi iste cumque illo iste natus rerum velit labore eum odit non eum voluptate voluptas expedita cupiditate a dolorem nulla rerum facilis illum officiis repellendus sed quis officiis rerum inventore molestias voluptatem expedita quia enim quo neque labore architecto quos vel in omnis saepe optio et et et nobis odio id suscipit vero nisi maxime ab magni est quos voluptatem adipisci illum quaerat delectus explicabo est laboriosam pariatur qui deleniti error aut aliquid et molestias animi facilis et perspiciatis ut ab incidunt incidunt maxime vel deleniti impedit voluptas labore et delectus id ipsam deleniti maiores excepturi esse aut iure ipsam vero officia fuga repellat molestias dolorem molestiae laboriosam repellendus nemo qui pariatur libero nisi recusandae aspernatur neque dolorum voluptatem magni quo quia sequi distinctio itaque cupiditate reiciendis ea quisquam nam ut vero ut non velit eveniet fuga voluptatibus molestias velit tenetur eos ex quam voluptatibus officiis dolorem non sit dolorem temporibus accusamus magni corrupti quia a saepe qui nam rerum culpa dicta quia et veniam cupiditate ut maiores aliquid eaque odio sint quia tempore ut nemo doloremque omnis expedita qui molestias deserunt repudiandae esse beatae et est eum praesentium dolor omnis cum laboriosam ipsa sit eos id sint minima alias molestiae sint voluptate exercitationem excepturi molestiae accusamus quia minima enim sunt nulla accusantium dolor voluptas nostrum et velit veritatis sunt cupiditate possimus quibusdam itaque repellendus eos officiis ipsum iusto qui cupiditate repellendus quod unde accusamus voluptatem sunt soluta eius molestiae neque ipsa molestiae dicta dolor placeat non sunt quidem molestiae aperiam sunt suscipit placeat ut sapiente molestiae suscipit velit aliquam dolores dolorem ex beatae ut aliquid quae repudiandae consequatur laudantium minima ut voluptatem dolorum iusto ea explicabo suscipit et at voluptatem autem mollitia fugiat modi sequi eum reiciendis aut quam suscipit ut aut cupiditate non non dolores dolorem tempore ut dolorem ex fugit est fugiat nesciunt fugit corrupti consequatur ut sit aliquid expedita illum quis quos necessitatibus voluptatem hic dolorum autem aut laborum quam fugiat veritatis mollitia voluptatem culpa ut consequuntur perferendis rerum sit nihil rerum voluptatem voluptatem sit autem hic omnis totam inventore incidunt laborum doloribus cumque esse consequuntur sed tempora vel dolor quisquam qui quaerat voluptas architecto sunt saepe at assumenda quisquam facere et dolorem accusamus quia aliquid dignissimos quis adipisci veniam nemo aut aperiam eum qui molestias voluptates ipsam illum quis accusamus qui illum illum illum possimus odit eius officiis perspiciatis quis soluta ad voluptatem odio sint nulla eum consectetur ut voluptatem veritatis fuga aut iusto repudiandae tempore qui qui sed molestias in aliquam dignissimos sint recusandae ab architecto voluptatem qui mollitia quae sed velit et corporis odit numquam nesciunt quis et et laudantium laboriosam quasi iure animi sit fugit temporibus dolorem alias reiciendis quibusdam nobis quaerat et quam aspernatur ullam laboriosam nesciunt nemo aut tempora consequatur rerum architecto quam maiores itaque necessitatibus molestias quisquam voluptas ut deleniti dolor reprehenderit aut voluptate aut voluptatem porro qui enim beatae minus aperiam qui accusamus cumque aspernatur est dignissimos illum alias quaerat ut earum qui expedita aut placeat hic ut repudiandae earum deleniti ut debitis autem tempora molestiae ea nostrum recusandae aliquid dignissimos qui est ut error laboriosam accusantium enim qui exercitationem illum commodi est quia sunt sit quia dolorem magni repudiandae ratione doloremque blanditiis reiciendis rerum qui fugit repudiandae debitis corrupti omnis maiores vel perspiciatis aliquid vero praesentium et qui ipsam non aliquam dolor incidunt quae eaque nostrum sit doloremque corrupti et nemo eius atque eos enim laborum ea et qui quia quia magni aut odit alias ullam quasi libero quisquam et aut architecto magni sit necessitatibus sint iusto omnis nisi atque voluptas animi natus laborum quia veritatis qui maxime itaque consequatur sapiente quas architecto rerum minus totam est non id quam repellat qui est animi ut omnis consectetur perferendis modi et vel et accusamus similique corporis ea sed est eveniet totam et sunt hic est consequatur repudiandae natus doloribus voluptas recusandae est nisi veniam esse itaque vitae molestiae perferendis fuga dicta nemo cum velit eos at maiores architecto et ducimus consequatur ut aliquid voluptatem nostrum quas exercitationem sed sed atque dolorem vel qui at est in esse et voluptate nemo necessitatibus sunt quia ut accusantium qui odit ex est et autem ex rerum quae sit quasi sit ducimus ipsa est dolores esse pariatur doloribus voluptates quam quaerat et quo accusantium rerum laudantium doloribus voluptatem nulla architecto quibusdam optio non earum a in ipsam adipisci ab aut laboriosam natus alias recusandae quia iure enim expedita in dolorem sint ab rem quia perferendis id soluta voluptatum est modi repudiandae incidunt exercitationem autem fugit itaque voluptatem doloribus aut reprehenderit unde repudiandae quasi aliquam ut impedit dolores in inventore odit deleniti voluptate perferendis quasi cum cumque eligendi corrupti ex quibusdam nulla ut modi modi omnis perferendis numquam qui sit dolorum ipsa sed vel fugiat molestiae architecto ut et voluptatem provident explicabo non autem blanditiis officiis qui occaecati qui in dolor illo voluptas dolore voluptatibus hic sapiente quis quaerat corrupti sequi dolorem illo odio dolore et iusto in sit in aliquam dicta esse sunt a eaque magnam quasi minus quasi a quidem est et excepturi et id nisi dolore ut et laboriosam quasi perspiciatis vitae expedita id quos reiciendis quod est qui numquam hic veniam incidunt qui dolorem aut iure nisi necessitatibus vel quia laudantium et cumque quas tempore totam ex suscipit sunt nulla eos at iusto saepe amet ad unde autem facere ullam nulla sed quidem tempora similique pariatur error ad est ullam voluptatum repudiandae quis aut aut dolorem odit commodi sequi culpa inventore doloribus voluptas molestiae sed aliquam molestias atque nulla animi modi eum ipsam magnam eligendi animi ducimus maxime eius totam et ex eius quis unde corrupti neque sequi eum quia impedit consequatur magni consequatur dolor officia quis praesentium quia veniam earum porro dolores quis quae fuga amet sit enim tenetur vero aut pariatur repellat voluptas consequatur perferendis eum odit vel adipisci explicabo dicta sit enim perferendis minus velit necessitatibus magni deserunt perspiciatis aut quae amet cumque voluptatibus earum doloremque neque esse maiores sed voluptates id magnam ipsa incidunt repellat officiis dolorem nulla mollitia et placeat perspiciatis sed enim harum quis ut nisi facilis architecto nobis et natus fuga dignissimos dignissimos adipisci quisquam molestias ex placeat sint magnam non autem laborum autem nihil quia est architecto tempora earum odit quos hic repellat beatae repudiandae suscipit numquam sapiente maxime laboriosam quia numquam et ea fugit numquam voluptatum sit dicta eum omnis recusandae nobis esse maiores architecto magnam rerum alias et et excepturi cupiditate autem et aut aspernatur reiciendis excepturi iusto sit natus dolores voluptatibus id numquam dolorum provident minima eligendi eum fuga nulla non enim iusto ullam id eum ratione dolores saepe beatae atque voluptatum quis earum perferendis aut accusantium omnis est quibusdam ipsum est voluptas provident.', 1, '2023-06-13 04:57:18', '2023-06-13 04:57:18'),
(3, 'about_us', 'About Us', 'Deleniti magnam dignissimos similique a dolorem magni culpa vero voluptatem quia nostrum officia itaque velit reiciendis corporis quia officia labore odit maiores dolor aspernatur eum beatae alias sed et tempore dignissimos nesciunt iusto iste facere tenetur quod adipisci natus sint cumque quia cupiditate vitae rerum velit rerum quibusdam consequatur sed sequi aut qui incidunt qui repudiandae mollitia tenetur fuga inventore assumenda qui vitae molestiae consequatur aut et libero similique quidem eligendi vero mollitia dolores quos aut dolores molestias repellat quod tenetur voluptas impedit illo tempora voluptatem enim nulla voluptate qui est quo temporibus aperiam blanditiis commodi et et ut id quisquam ut suscipit cumque atque voluptas veritatis aut eligendi atque ut sunt tempora consequatur et soluta maxime nesciunt molestias est quam atque doloremque in quia aut est quasi qui minima modi explicabo sunt sit ipsa sit ipsum ipsum et quos beatae molestiae voluptas aliquid distinctio aut earum laborum libero omnis dolor voluptatem nobis aut ut ullam voluptatem labore magnam veniam voluptatum blanditiis eum unde laudantium atque aperiam a perspiciatis excepturi aperiam in quo ea ut sequi iste cumque illo iste natus rerum velit labore eum odit non eum voluptate voluptas expedita cupiditate a dolorem nulla rerum facilis illum officiis repellendus sed quis officiis rerum inventore molestias voluptatem expedita quia enim quo neque labore architecto quos vel in omnis saepe optio et et et nobis odio id suscipit vero nisi maxime ab magni est quos voluptatem adipisci illum quaerat delectus explicabo est laboriosam pariatur qui deleniti error aut aliquid et molestias animi facilis et perspiciatis ut ab incidunt incidunt maxime vel deleniti impedit voluptas labore et delectus id ipsam deleniti maiores excepturi esse aut iure ipsam vero officia fuga repellat molestias dolorem molestiae laboriosam repellendus nemo qui pariatur libero nisi recusandae aspernatur neque dolorum voluptatem magni quo quia sequi distinctio itaque cupiditate reiciendis ea quisquam nam ut vero ut non velit eveniet fuga voluptatibus molestias velit tenetur eos ex quam voluptatibus officiis dolorem non sit dolorem temporibus accusamus magni corrupti quia a saepe qui nam rerum culpa dicta quia et veniam cupiditate ut maiores aliquid eaque odio sint quia tempore ut nemo doloremque omnis expedita qui molestias deserunt repudiandae esse beatae et est eum praesentium dolor omnis cum laboriosam ipsa sit eos id sint minima alias molestiae sint voluptate exercitationem excepturi molestiae accusamus quia minima enim sunt nulla accusantium dolor voluptas nostrum et velit veritatis sunt cupiditate possimus quibusdam itaque repellendus eos officiis ipsum iusto qui cupiditate repellendus quod unde accusamus voluptatem sunt soluta eius molestiae neque ipsa molestiae dicta dolor placeat non sunt quidem molestiae aperiam sunt suscipit placeat ut sapiente molestiae suscipit velit aliquam dolores dolorem ex beatae ut aliquid quae repudiandae consequatur laudantium minima ut voluptatem dolorum iusto ea explicabo suscipit et at voluptatem autem mollitia fugiat modi sequi eum reiciendis aut quam suscipit ut aut cupiditate non non dolores dolorem tempore ut dolorem ex fugit est fugiat nesciunt fugit corrupti consequatur ut sit aliquid expedita illum quis quos necessitatibus voluptatem hic dolorum autem aut laborum quam fugiat veritatis mollitia voluptatem culpa ut consequuntur perferendis rerum sit nihil rerum voluptatem voluptatem sit autem hic omnis totam inventore incidunt laborum doloribus cumque esse consequuntur sed tempora vel dolor quisquam qui quaerat voluptas architecto sunt saepe at assumenda quisquam facere et dolorem accusamus quia aliquid dignissimos quis adipisci veniam nemo aut aperiam eum qui molestias voluptates ipsam illum quis accusamus qui illum illum illum possimus odit eius officiis perspiciatis quis soluta ad voluptatem odio sint nulla eum consectetur ut voluptatem veritatis fuga aut iusto repudiandae tempore qui qui sed molestias in aliquam dignissimos sint recusandae ab architecto voluptatem qui mollitia quae sed velit et corporis odit numquam nesciunt quis et et laudantium laboriosam quasi iure animi sit fugit temporibus dolorem alias reiciendis quibusdam nobis quaerat et quam aspernatur ullam laboriosam nesciunt nemo aut tempora consequatur rerum architecto quam maiores itaque necessitatibus molestias quisquam voluptas ut deleniti dolor reprehenderit aut voluptate aut voluptatem porro qui enim beatae minus aperiam qui accusamus cumque aspernatur est dignissimos illum alias quaerat ut earum qui expedita aut placeat hic ut repudiandae earum deleniti ut debitis autem tempora molestiae ea nostrum recusandae aliquid dignissimos qui est ut error laboriosam accusantium enim qui exercitationem illum commodi est quia sunt sit quia dolorem magni repudiandae ratione doloremque blanditiis reiciendis rerum qui fugit repudiandae debitis corrupti omnis maiores vel perspiciatis aliquid vero praesentium et qui ipsam non aliquam dolor incidunt quae eaque nostrum sit doloremque corrupti et nemo eius atque eos enim laborum ea et qui quia quia magni aut odit alias ullam quasi libero quisquam et aut architecto magni sit necessitatibus sint iusto omnis nisi atque voluptas animi natus laborum quia veritatis qui maxime itaque consequatur sapiente quas architecto rerum minus totam est non id quam repellat qui est animi ut omnis consectetur perferendis modi et vel et accusamus similique corporis ea sed est eveniet totam et sunt hic est consequatur repudiandae natus doloribus voluptas recusandae est nisi veniam esse itaque vitae molestiae perferendis fuga dicta nemo cum velit eos at maiores architecto et ducimus consequatur ut aliquid voluptatem nostrum quas exercitationem sed sed atque dolorem vel qui at est in esse et voluptate nemo necessitatibus sunt quia ut accusantium qui odit ex est et autem ex rerum quae sit quasi sit ducimus ipsa est dolores esse pariatur doloribus voluptates quam quaerat et quo accusantium rerum laudantium doloribus voluptatem nulla architecto quibusdam optio non earum a in ipsam adipisci ab aut laboriosam natus alias recusandae quia iure enim expedita in dolorem sint ab rem quia perferendis id soluta voluptatum est modi repudiandae incidunt exercitationem autem fugit itaque voluptatem doloribus aut reprehenderit unde repudiandae quasi aliquam ut impedit dolores in inventore odit deleniti voluptate perferendis quasi cum cumque eligendi corrupti ex quibusdam nulla ut modi modi omnis perferendis numquam qui sit dolorum ipsa sed vel fugiat molestiae architecto ut et voluptatem provident explicabo non autem blanditiis officiis qui occaecati qui in dolor illo voluptas dolore voluptatibus hic sapiente quis quaerat corrupti sequi dolorem illo odio dolore et iusto in sit in aliquam dicta esse sunt a eaque magnam quasi minus quasi a quidem est et excepturi et id nisi dolore ut et laboriosam quasi perspiciatis vitae expedita id quos reiciendis quod est qui numquam hic veniam incidunt qui dolorem aut iure nisi necessitatibus vel quia laudantium et cumque quas tempore totam ex suscipit sunt nulla eos at iusto saepe amet ad unde autem facere ullam nulla sed quidem tempora similique pariatur error ad est ullam voluptatum repudiandae quis aut aut dolorem odit commodi sequi culpa inventore doloribus voluptas molestiae sed aliquam molestias atque nulla animi modi eum ipsam magnam eligendi animi ducimus maxime eius totam et ex eius quis unde corrupti neque sequi eum quia impedit consequatur magni consequatur dolor officia quis praesentium quia veniam earum porro dolores quis quae fuga amet sit enim tenetur vero aut pariatur repellat voluptas consequatur perferendis eum odit vel adipisci explicabo dicta sit enim perferendis minus velit necessitatibus magni deserunt perspiciatis aut quae amet cumque voluptatibus earum doloremque neque esse maiores sed voluptates id magnam ipsa incidunt repellat officiis dolorem nulla mollitia et placeat perspiciatis sed enim harum quis ut nisi facilis architecto nobis et natus fuga dignissimos dignissimos adipisci quisquam molestias ex placeat sint magnam non autem laborum autem nihil quia est architecto tempora earum odit quos hic repellat beatae repudiandae suscipit numquam sapiente maxime laboriosam quia numquam et ea fugit numquam voluptatum sit dicta eum omnis recusandae nobis esse maiores architecto magnam rerum alias et et excepturi cupiditate autem et aut aspernatur reiciendis excepturi iusto sit natus dolores voluptatibus id numquam dolorum provident minima eligendi eum fuga nulla non enim iusto ullam id eum ratione dolores saepe beatae atque voluptatum quis earum perferendis aut accusantium omnis est quibusdam ipsum est voluptas provident.', 1, '2023-06-13 04:57:18', '2023-06-13 04:57:18'),
(4, 'faq', 'Have Question', 'Take a look at the most commonly asked questions.', 1, '2023-06-13 04:57:18', '2023-06-13 04:57:18'),
(5, 'contact', 'Contact Us', 'Take a look at the most commonly asked questions.', 1, '2023-06-13 04:57:18', '2023-06-13 04:57:18');

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

--
-- Table structure for table `parcels`
--

CREATE TABLE `parcels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED NOT NULL,
  `merchant_shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pickup_address` longtext DEFAULT NULL,
  `pickup_phone` varchar(191) DEFAULT NULL,
  `pickup_lat` varchar(191) DEFAULT NULL,
  `pickup_long` varchar(191) DEFAULT NULL,
  `customer_lat` varchar(191) DEFAULT NULL,
  `customer_long` varchar(191) DEFAULT NULL,
  `priority_type_id` varchar(191) DEFAULT NULL,
  `customer_name` varchar(191) DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `customer_address` longtext DEFAULT NULL,
  `invoice_no` varchar(191) DEFAULT NULL,
  `category_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `weight` bigint(20) DEFAULT 0,
  `delivery_type_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `packaging_id` bigint(20) DEFAULT NULL,
  `first_hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transfer_hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cash_collection` decimal(13,2) DEFAULT NULL,
  `old_cash_collection` decimal(13,2) DEFAULT NULL,
  `selling_price` decimal(13,2) DEFAULT NULL,
  `liquid_fragile_amount` decimal(13,2) DEFAULT NULL,
  `packaging_amount` decimal(13,2) DEFAULT NULL,
  `delivery_charge` decimal(13,2) DEFAULT NULL,
  `cod_charge` bigint(20) DEFAULT NULL,
  `cod_amount` decimal(13,2) DEFAULT NULL,
  `vat` bigint(20) DEFAULT NULL,
  `vat_amount` decimal(13,2) DEFAULT NULL,
  `total_delivery_amount` decimal(13,2) DEFAULT NULL,
  `current_payable` decimal(13,2) DEFAULT NULL,
  `tracking_id` varchar(191) DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `partial_delivered` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'no=0,yes=1',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'pending             = 1,\n                 picup_assign        = 2,\n                 received_warehouse  = 3,\n                 delivery_man_assign = 4,\n                 deliver             = 5,\n                 delivered           = 6,\n                 return_warehouse    = 7,\n                 assign_merchant     = 8,\n                 returned_merchant   = 9',
  `parcel_bank` varchar(191) DEFAULT NULL,
  `pickup_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `return_charges` decimal(13,2) DEFAULT NULL COMMENT 'received by merchant return charges',
  `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 `parcel_events`
--

CREATE TABLE `parcel_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parcel_id` bigint(20) UNSIGNED NOT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pickup_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transfer_delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text DEFAULT NULL,
  `parcel_status` tinyint(4) DEFAULT NULL,
  `delivery_lat` varchar(191) DEFAULT NULL,
  `delivery_long` varchar(191) DEFAULT NULL,
  `signature_image` longtext DEFAULT NULL,
  `delivered_image` longtext DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `parcel_logs`
--

CREATE TABLE `parcel_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `hub_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parcel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pickup_address` longtext DEFAULT NULL,
  `pickup_phone` varchar(191) DEFAULT NULL,
  `customer_name` varchar(191) DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `customer_address` longtext DEFAULT NULL,
  `invoice_no` varchar(191) DEFAULT NULL,
  `cash_collection` decimal(13,2) DEFAULT NULL,
  `selling_price` decimal(13,2) DEFAULT NULL,
  `total_delivery_amount` decimal(13,2) DEFAULT NULL,
  `current_payable` decimal(13,2) DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `link` varchar(191) DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `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 `partners`
--

INSERT INTO `partners` (`id`, `name`, `image_id`, `link`, `position`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Tromp-Carroll', 21, '#', '2', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'Stanton, Brakus and Bauch', 22, '#', '3', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'Runte-Jacobson', 23, '#', '4', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(11, 'Johnson-Gutmann', 30, '#', '11', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(12, 'Hessel Ltd', 31, '#', '12', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `password_resets`
--

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

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

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

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `merchant_account` tinyint(4) DEFAULT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `from_account` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_file` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL COMMENT '1=admin,2=merchant',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 3 COMMENT '1= Reject,2=Approved , 3= Pending,4=Process, ',
  `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 `payment_accounts`
--

CREATE TABLE `payment_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `holder_name` varchar(191) DEFAULT NULL,
  `account_no` varchar(191) DEFAULT NULL,
  `branch_name` varchar(191) DEFAULT NULL,
  `routing_no` varchar(191) DEFAULT NULL,
  `mobile_company` varchar(191) DEFAULT NULL,
  `mobile_no` varchar(191) DEFAULT NULL,
  `account_type` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `attribute` varchar(191) DEFAULT NULL,
  `keywords` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `attribute`, `keywords`, `created_at`, `updated_at`) VALUES
(1, 'dashboard', '{\"read\":\"dashboard_read\",\"calendar\":\"calendar_read\",\"total_Parcel\":\"total_parcel\",\"total_user\":\"total_user\",\"total_merchant\":\"total_merchant\",\"total_delivery_man\":\"total_delivery_man\",\"total_hubs\":\"total_hubs\",\"total_accounts\":\"total_accounts\",\"total_parcels_pending\":\"total_parcels_pending\",\"total_pickup_assigned\":\"total_pickup_assigned\",\"total_received_warehouse\":\"total_received_warehouse\",\"total_deliveryman_assigned\":\"total_deliveryman_assigned\",\"total_partial_deliverd\":\"total_partial_deliverd\",\"total_parcels_deliverd\":\"total_parcels_deliverd\",\"recent_accounts\":\"recent_accounts\",\"recent_salary\":\"recent_salary\",\"recent_hub\":\"recent_hub\",\"all_statements\":\"all_statements\",\"income_expense_charts\":\"income_expense_charts\",\"merchant_revenue_charts\":\"merchant_revenue_charts\",\"deliveryman_revenue_charts\":\"deliveryman_revenue_charts\",\"courier_revenue_charts\":\"courier_revenue_charts\",\"recent_parcels\":\"recent_parcels\",\"bank_transaction\":\"bank_transaction\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 'logs', '{\"read\":\"log_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(3, 'hubs', '{\"read\":\"hub_read\",\"create\":\"hub_create\",\"update\":\"hub_update\",\"delete\":\"hub_delete\",\"incharge_read\":\"hub_incharge_read\",\"incharge_create\":\"hub_incharge_create\",\"incharge_update\":\"hub_incharge_update\",\"incharge_delete\":\"hub_incharge_delete\",\"incharge_assigned\":\"hub_incharge_assigned\",\"view\":\"hub_view\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(4, 'accounts', '{\"read\":\"account_read\",\"create\":\"account_create\",\"update\":\"account_update\",\"delete\":\"account_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(5, 'income', '{\"read\":\"income_read\",\"create\":\"income_create\",\"update\":\"income_update\",\"delete\":\"income_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(6, 'expense', '{\"read\":\"expense_read\",\"create\":\"expense_create\",\"update\":\"expense_update\",\"delete\":\"expense_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(7, 'todo', '{\"read\":\"todo_read\",\"create\":\"todo_create\",\"update\":\"todo_update\",\"delete\":\"todo_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(8, 'fund_transfer', '{\"read\":\"fund_transfer_read\",\"create\":\"fund_transfer_create\",\"update\":\"fund_transfer_update\",\"delete\":\"fund_transfer_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(9, 'roles', '{\"read\":\"role_read\",\"create\":\"role_create\",\"update\":\"role_update\",\"delete\":\"role_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(10, 'designations', '{\"read\":\"designation_read\",\"create\":\"designation_create\",\"update\":\"designation_update\",\"delete\":\"designation_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(11, 'departments', '{\"read\":\"department_read\",\"create\":\"department_create\",\"update\":\"department_update\",\"delete\":\"department_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(12, 'users', '{\"read\":\"user_read\",\"create\":\"user_create\",\"update\":\"user_update\",\"delete\":\"user_delete\",\"permission_update\":\"permission_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(13, 'merchant', '{\"read\":\"merchant_read\",\"create\":\"merchant_create\",\"update\":\"merchant_update\",\"delete\":\"merchant_delete\",\"view\":\"merchant_view\",\"delivery_charge_read\":\"merchant_delivery_charge_read\",\"delivery_charge_create\":\"merchant_delivery_charge_create\",\"delivery_charge_update\":\"merchant_delivery_charge_update\",\"delivery_charge_delete\":\"merchant_delivery_charge_delete\",\"shop_read\":\"merchant_shop_read\",\"shop_create\":\"merchant_shop_create\",\"shop_update\":\"merchant_shop_update\",\"shop_delete\":\"merchant_shop_delete\",\"payment_read\":\"merchant_payment_read\",\"payment_create\":\"merchant_payment_create\",\"payment_update\":\"merchant_payment_update\",\"payment_delete\":\"merchant_payment_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(14, 'payments', '{\"read\":\"payment_read\",\"create\":\"payment_create\",\"update\":\"payment_update\",\"delete\":\"payment_delete\",\"reject\":\"payment_reject\",\"process\":\"payment_process\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(15, 'hub_payments', '{\"read\":\"hub_payment_read\",\"create\":\"hub_payment_create\",\"update\":\"hub_payment_update\",\"delete\":\"hub_payment_delete\",\"reject\":\"hub_payment_reject\",\"process\":\"hub_payment_process\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(16, 'hub_payments_request', '{\"read\":\"hub_payment_request_read\",\"create\":\"hub_payment_request_create\",\"update\":\"hub_payment_request_update\",\"delete\":\"hub_payment_request_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(17, 'liquid_fragile', '{\"read\":\"liquid_fragile_read\",\"update\":\"liquid_fragile_update\",\"status_change\":\"liquid_status_change\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(18, 'database_backup', '{\"read\":\"database_backup_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(19, 'sms_settings', '{\"read\":\"sms_settings_read\",\"create\":\"sms_settings_create\",\"update\":\"sms_settings_update\",\"delete\":\"sms_settings_delete\",\"status_change\":\"sms_settings_status_change\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(20, 'sms_send_settings', '{\"read\":\"sms_send_settings_read\",\"create\":\"sms_send_settings_create\",\"update\":\"sms_send_settings_update\",\"delete\":\"sms_send_settings_delete\",\"status_change\":\"sms_send_settings_status_change\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(21, 'general_settings', '{\"read\":\"general_settings_read\",\"update\":\"general_settings_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(22, 'notification_settings', '{\"read\":\"notification_settings_read\",\"update\":\"notification_settings_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(23, 'push_notification', '{\"read\":\"push_notification_read\",\"create\":\"push_notification_create\",\"update\":\"push_notification_update\",\"delete\":\"push_notification_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(24, 'parcel', '{\"read\":\"parcel_read\",\"create\":\"parcel_create\",\"update\":\"parcel_update\",\"delete\":\"parcel_delete\",\"status_update\":\"parcel_status_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(25, 'delivery_man', '{\"read\":\"delivery_man_read\",\"create\":\"delivery_man_create\",\"update\":\"delivery_man_update\",\"delete\":\"delivery_man_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(26, 'delivery_category', '{\"read\":\"delivery_category_read\",\"create\":\"delivery_category_create\",\"update\":\"delivery_category_update\",\"delete\":\"delivery_category_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(27, 'delivery_charge', '{\"read\":\"delivery_charge_read\",\"create\":\"delivery_charge_create\",\"update\":\"delivery_charge_update\",\"delete\":\"delivery_charge_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(28, 'delivery_type', '{\"read\":\"delivery_type_read\",\"status_change\":\"delivery_type_status_change\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(29, 'packaging', '{\"read\":\"packaging_read\",\"create\":\"packaging_create\",\"update\":\"packaging_update\",\"delete\":\"packaging_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(30, 'category', '{\"read\":\"category_read\",\"create\":\"category_create\",\"update\":\"category_update\",\"delete\":\"category_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(31, 'account_heads', '{\"read\":\"account_heads_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(32, 'salary', '{\"read\":\"salary_read\",\"create\":\"salary_create\",\"update\":\"salary_update\",\"delete\":\"salary_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(33, 'support', '{\"read\":\"support_read\",\"create\":\"support_create\",\"update\":\"support_update\",\"delete\":\"support_delete\",\"reply\":\"support_reply\",\"status_update\":\"support_status_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(34, 'asset_category', '{\"read\":\"asset_category_read\",\"create\":\"asset_category_create\",\"update\":\"asset_category_update\",\"delete\":\"asset_category_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(35, 'assets', '{\"read\":\"assets_read\",\"create\":\"assets_create\",\"update\":\"assets_update\",\"delete\":\"assets_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(36, 'news_offer', '{\"read\":\"news_offer_read\",\"create\":\"news_offer_create\",\"update\":\"news_offer_update\",\"delete\":\"news_offer_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(37, 'bank_transaction', '{\"read\":\"bank_transaction_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(38, 'cash_received_from_delivery_man', '{\"read\":\"cash_received_from_delivery_man_read\",\"create\":\"cash_received_from_delivery_man_create\",\"update\":\"cash_received_from_delivery_man_update\",\"delete\":\"cash_received_from_delivery_man_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(39, 'reports', '{\"parcel_status_reports\":\"parcel_status_reports\",\"parcel_wise_profit\":\"parcel_wise_profit\",\"parcel_total_summery\":\"parcel_total_summery\",\"salary_reports\":\"salary_reports\",\"merchant_hub_deliveryman\":\"merchant_hub_deliveryman\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(40, 'salary_generate', '{\"read\":\"salary_generate_read\",\"create\":\"salary_generate_create\",\"update\":\"salary_generate_update\",\"delete\":\"salary_generate_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(41, 'fraud', '{\"read\":\"fraud_read\",\"create\":\"fraud_create\",\"update\":\"fraud_update\",\"delete\":\"fraud_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(42, 'subscribe', '{\"read\":\"subscribe_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(43, 'pickup_request', '{\"regular\":\"pickup_request_regular\",\"express\":\"pickup_request_express\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(44, 'invoice', '{\"read\":\"invoice_read\",\"status_update\":\"invoice_status_update\",\"paid_invoice_read\":\"paid_invoice_read\",\"invoice_generate\":\"invoice_generate_menually\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(45, 'social_login_settings', '{\"read\":\"social_login_settings_read\",\"update\":\"social_login_settings_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(46, 'payout_setup_settings', '{\"read\":\"payout_setup_settings_read\",\"update\":\"payout_setup_settings_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(47, 'online_payment', '{\"read\":\"online_payment_read\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(48, 'payout', '{\"read\":\"payout_read\",\"create\":\"payout_create\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(49, 'currency', '{\"read\":\"currency_read\",\"create\":\"currency_create\",\"update\":\"currency_update\",\"delete\":\"currency_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(50, 'social_link', '{\"read\":\"social_link_read\",\"create\":\"social_link_create\",\"update\":\"social_link_update\",\"delete\":\"social_link_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(51, 'services', '{\"read\":\"service_read\",\"create\":\"service_create\",\"update\":\"service_update\",\"delete\":\"service_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(52, 'why_courier', '{\"read\":\"why_courier_read\",\"create\":\"why_courier_create\",\"update\":\"why_courier_update\",\"delete\":\"why_courier_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(53, 'faq', '{\"read\":\"faq_read\",\"create\":\"faq_create\",\"update\":\"faq_update\",\"delete\":\"faq_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(54, 'partner', '{\"read\":\"partner_read\",\"create\":\"partner_create\",\"update\":\"partner_update\",\"delete\":\"partner_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(55, 'blogs', '{\"read\":\"blogs_read\",\"create\":\"blogs_create\",\"update\":\"blogs_update\",\"delete\":\"blogs_delete\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(56, 'pages', '{\"read\":\"pages_read\",\"update\":\"pages_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(57, 'sections', '{\"read\":\"section_read\",\"update\":\"section_update\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(58, 'wallet_request', '{\"read\":\"wallet_request_read\",\"create\":\"wallet_request_create\",\"delete\":\"wallet_request_delete\",\"approve\":\"wallet_request_approve\",\"reject\":\"wallet_request_reject\"}', '2025-01-31 00:26:08', '2025-01-31 00:26:08');

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `expires_at` varchar(191) DEFAULT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pickup_requests`
--

CREATE TABLE `pickup_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_type` varchar(191) DEFAULT NULL COMMENT 'regular = 1,',
  `merchant_id` bigint(20) UNSIGNED NOT NULL,
  `address` text DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `parcel_quantity` bigint(20) NOT NULL DEFAULT 0,
  `name` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `cod_amount` decimal(16,2) DEFAULT 0.00,
  `invoice` varchar(191) DEFAULT NULL,
  `weight` bigint(20) DEFAULT 0,
  `exchange` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'yes = 1, no = 0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `push_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` longtext NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `merchant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `permissions` text DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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`, `slug`, `permissions`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'super-admin', '[\"dashboard_read\",\"calendar_read\",\"total_parcel\",\"total_user\",\"total_merchant\",\"total_delivery_man\",\"total_hubs\",\"total_accounts\",\"total_parcels_pending\",\"total_pickup_assigned\",\"total_received_warehouse\",\"total_deliveryman_assigned\",\"total_partial_deliverd\",\"total_parcels_deliverd\",\"recent_accounts\",\"recent_salary\",\"recent_hub\",\"all_statements\",\"income_expense_charts\",\"merchant_revenue_charts\",\"deliveryman_revenue_charts\",\"courier_revenue_charts\",\"recent_parcels\",\"bank_transaction\",\"log_read\",\"hub_read\",\"hub_create\",\"hub_update\",\"hub_delete\",\"hub_incharge_read\",\"hub_incharge_create\",\"hub_incharge_update\",\"hub_incharge_delete\",\"hub_incharge_assigned\",\"account_read\",\"account_create\",\"account_update\",\"account_delete\",\"income_read\",\"income_create\",\"income_update\",\"income_delete\",\"expense_read\",\"expense_create\",\"expense_update\",\"expense_delete\",\"todo_read\",\"todo_create\",\"todo_update\",\"todo_delete\",\"fund_transfer_read\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"role_read\",\"role_create\",\"role_update\",\"role_delete\",\"designation_read\",\"designation_create\",\"designation_update\",\"designation_delete\",\"department_read\",\"department_create\",\"department_update\",\"department_delete\",\"user_read\",\"user_create\",\"user_update\",\"user_delete\",\"permission_update\",\"merchant_read\",\"merchant_create\",\"merchant_update\",\"merchant_delete\",\"merchant_view\",\"merchant_delivery_charge_read\",\"merchant_delivery_charge_create\",\"merchant_delivery_charge_update\",\"merchant_delivery_charge_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_update\",\"merchant_shop_delete\",\"merchant_payment_read\",\"merchant_payment_create\",\"merchant_payment_update\",\"merchant_payment_delete\",\"payment_read\",\"payment_create\",\"payment_update\",\"payment_delete\",\"payment_reject\",\"payment_process\",\"hub_payment_read\",\"hub_payment_create\",\"hub_payment_update\",\"hub_payment_delete\",\"hub_payment_reject\",\"hub_payment_process\",\"hub_payment_request_read\",\"hub_payment_request_create\",\"hub_payment_request_update\",\"hub_payment_request_delete\",\"parcel_read\",\"parcel_create\",\"parcel_update\",\"parcel_delete\",\"parcel_status_update\",\"delivery_man_read\",\"delivery_man_create\",\"delivery_man_update\",\"delivery_man_delete\",\"delivery_category_read\",\"delivery_category_create\",\"delivery_category_update\",\"delivery_category_delete\",\"delivery_charge_read\",\"delivery_charge_create\",\"delivery_charge_update\",\"delivery_charge_delete\",\"delivery_type_read\",\"delivery_type_status_change\",\"liquid_fragile_read\",\"liquid_fragile_update\",\"liquid_status_change\",\"packaging_read\",\"packaging_create\",\"packaging_update\",\"packaging_delete\",\"category_read\",\"category_create\",\"category_update\",\"category_delete\",\"account_heads_read\",\"database_backup_read\",\"salary_read\",\"salary_create\",\"salary_update\",\"salary_delete\",\"support_read\",\"support_create\",\"support_update\",\"support_delete\",\"support_reply\",\"support_status_update\",\"sms_settings_read\",\"sms_settings_create\",\"sms_settings_update\",\"sms_settings_delete\",\"sms_send_settings_read\",\"sms_send_settings_create\",\"sms_send_settings_update\",\"sms_send_settings_delete\",\"general_settings_read\",\"general_settings_update\",\"notification_settings_read\",\"notification_settings_update\",\"push_notification_read\",\"push_notification_create\",\"push_notification_update\",\"push_notification_delete\",\"asset_category_read\",\"asset_category_create\",\"asset_category_update\",\"asset_category_delete\",\"news_offer_read\",\"news_offer_create\",\"news_offer_update\",\"news_offer_delete\",\"parcel_status_reports\",\"parcel_wise_profit\",\"parcel_total_summery\",\"salary_reports\",\"merchant_hub_deliveryman\",\"salary_generate_read\",\"salary_generate_create\",\"salary_generate_update\",\"salary_generate_delete\",\"assets_read\",\"assets_create\",\"assets_update\",\"assets_delete\",\"fraud_read\",\"fraud_create\",\"fraud_update\",\"fraud_delete\",\"subscribe_read\",\"pickup_request_regular\",\"pickup_request_express\",\"invoice_read\",\"invoice_status_update\",\"social_login_settings_read\",\"social_login_settings_update\",\"payout_setup_settings_read\",\"payout_setup_settings_update\",\"online_payment_read\",\"payout_read\",\"payout_create\",\"hub_view\",\"paid_invoice_read\",\"invoice_generate_menually\",\"currency_read\",\"currency_create\",\"currency_update\",\"currency_delete\",\"social_link_read\",\"social_link_create\",\"social_link_update\",\"social_link_delete\",\"service_read\",\"service_create\",\"service_update\",\"service_delete\",\"why_courier_read\",\"why_courier_create\",\"why_courier_update\",\"why_courier_delete\",\"faq_read\",\"faq_create\",\"faq_update\",\"faq_delete\",\"partner_read\",\"partner_create\",\"partner_update\",\"partner_delete\",\"blogs_read\",\"blogs_create\",\"blogs_update\",\"blogs_delete\",\"pages_read\",\"pages_update\",\"section_read\",\"section_update\",\"wallet_request_read\",\"wallet_request_create\",\"wallet_request_delete\",\"wallet_request_approve\",\"wallet_request_reject\"]', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'Admin', 'admin', '[\"dashboard_read\",\"calendar_read\",\"total_parcel\",\"total_user\",\"total_merchant\",\"total_delivery_man\",\"total_hubs\",\"total_accounts\",\"total_parcels_pending\",\"total_pickup_assigned\",\"total_received_warehouse\",\"total_deliveryman_assigned\",\"total_partial_deliverd\",\"total_parcels_deliverd\",\"recent_accounts\",\"recent_salary\",\"recent_hub\",\"all_statements\",\"income_expense_charts\",\"merchant_revenue_charts\",\"deliveryman_revenue_charts\",\"courier_revenue_charts\",\"recent_parcels\",\"bank_transaction\",\"log_read\",\"hub_read\",\"hub_incharge_read\",\"account_read\",\"income_read\",\"expense_read\",\"todo_read\",\"sms_settings_read\",\"sms_send_settings_read\",\"general_settings_read\",\"notification_settings_read\",\"push_notification_read\",\"push_notification_create\",\"push_notification_update\",\"push_notification_delete\",\"account_heads_read\",\"salary_read\",\"support_read\",\"fund_transfer_read\",\"role_read\",\"designation_read\",\"department_read\",\"user_read\",\"merchant_read\",\"merchant_delivery_charge_read\",\"merchant_shop_read\",\"merchant_payment_read\",\"payment_read\",\"hub_payment_request_read\",\"hub_payment_read\",\"parcel_read\",\"delivery_man_read\",\"delivery_category_read\",\"delivery_charge_read\",\"delivery_type_read\",\"liquid_fragile_read\",\"packaging_read\",\"category_read\",\"asset_category_read\",\"news_offer_read\",\"sms_settings_status_change\",\"sms_send_settings_status_change\",\"bank_transaction_read\",\"database_backup_read\",\"parcel_status_reports\",\"parcel_wise_profit\",\"parcel_total_summery\",\"salary_reports\",\"merchant_hub_deliveryman\",\"salary_generate_read\",\"assets_read\",\"fraud_read\",\"subscribe_read\",\"pickup_request_regular\",\"pickup_request_express\",\"cash_received_from_delivery_man_read\",\"cash_received_from_delivery_man_create\",\"cash_received_from_delivery_man_update\",\"cash_received_from_delivery_man_delete\",\"invoice_read\",\"invoice_status_update\",\"social_login_settings_read\",\"social_login_settings_update\",\"payout_setup_settings_read\",\"online_payment_read\",\"payout_read\",\"hub_view\",\"paid_invoice_read\",\"invoice_generate_menually\",\"currency_read\"]', 1, '2025-01-31 00:26:07', '2025-01-31 00:26:07');

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

--
-- Table structure for table `salaries`
--

CREATE TABLE `salaries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `month` varchar(191) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `date` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `salary_generates`
--

CREATE TABLE `salary_generates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `month` varchar(191) DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `status` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Unpaid=0,Paid=1,Partial Paid=2',
  `due` decimal(16,2) NOT NULL DEFAULT 0.00,
  `advance` decimal(16,2) NOT NULL DEFAULT 0.00,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `key` varchar(191) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `type`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 1, 'title_1', 'We', '2023-01-27 11:30:40', '2025-02-01 00:33:29'),
(2, 1, 'title_2', 'Deliver', '2023-01-27 11:30:40', '2025-02-01 00:33:29'),
(3, 1, 'title_3', 'Parcel on Time with no Hassle', '2023-01-27 11:30:40', '2025-02-01 00:33:29'),
(4, 1, 'sub_title', 'We Committed to delivery - Make easy Efficient and quality delivery.', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(5, 1, 'banner', '32', '2023-01-27 11:30:40', '2025-01-31 23:44:23'),
(6, 2, 'branch_icon', 'fa fa-user', '2023-01-27 11:30:40', '2025-01-31 23:39:59'),
(7, 2, 'branch_count', '3000', '2023-01-27 11:30:40', '2025-01-31 23:43:30'),
(8, 2, 'branch_title', 'Registered Merchant', '2023-01-27 11:30:40', '2025-01-31 23:37:39'),
(9, 2, 'parcel_icon', 'fa fa-motorcycle', '2023-01-27 11:30:40', '2025-01-31 23:39:59'),
(10, 2, 'parcel_count', '100', '2023-01-27 11:30:40', '2025-01-31 23:43:30'),
(11, 2, 'parcel_title', 'Delivery Man', '2023-01-27 11:30:40', '2025-01-31 23:37:39'),
(12, 2, 'merchant_icon', 'fa fa-map-marker', '2023-01-27 11:30:40', '2025-01-31 23:39:59'),
(13, 2, 'merchant_count', '5000', '2023-01-27 11:30:40', '2025-01-31 23:43:30'),
(14, 2, 'merchant_title', 'Delivery Point', '2023-01-27 11:30:40', '2025-01-31 23:37:39'),
(15, 2, 'reviews_icon', 'fa fa-thumbs-up', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(16, 2, 'reviews_count', '700', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(17, 2, 'reviews_title', 'Positive Reviews', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(18, 3, 'about_us', 'Fastest platform with all courier service features. Help you start, run and grow your courier service.', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(19, 4, 'subscribe_title', 'Subscribe Us', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(20, 4, 'subscribe_description', 'Get business news , tip and solutions to your problems our experts.', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(21, 5, 'playstore_icon', 'fa-brands fa-google-play', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(22, 5, 'playstore_link', 'https://drive.google.com/drive/folders/1jLe_s4F-HDSjI7dHPsen7vRUw2wv9SMi', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(23, 5, 'ios_icon', 'fa-brands fa-app-store-ios', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(24, 5, 'ios_link', 'https://drive.google.com/drive/folders/1jLe_s4F-HDSjI7dHPsen7vRUw2wv9SMi', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(25, 6, 'map_link', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d542.6581052086841!2d90.3516149889463!3d23.798889773393963!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3755c0e8a725cb8b%3A0x5a69b65edf9c7cf4!2sWemax%20IT!5e0!3m2!1sen!2sbd!4v1687082326781!5m2!1sen!2sbd', '2023-01-27 11:30:40', '2023-01-27 11:30:40'),
(26, 1, 'text_1', 'Easy Tracking, fast Payment, and safe Delivery across country.', NULL, '2025-02-01 00:33:29');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `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 `services`
--

INSERT INTO `services` (`id`, `title`, `image_id`, `description`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ecommerce Delivery', 10, '<span style=\"color: rgb(23, 23, 23); font-family: Poppins, sans-serif; font-size: 20px;\">Ecommerce Delivery</span>', '1', 1, '2025-01-31 00:26:09', '2025-02-02 21:20:17'),
(2, 'Pick & Drop', 11, '<span style=\"color: rgb(23, 23, 23); font-family: Poppins, sans-serif; font-size: 20px;\">Pick &amp; Drop</span>', '2', 1, '2025-01-31 00:26:09', '2025-02-02 21:26:16'),
(3, 'Packging', 12, '<span style=\"color: rgb(23, 23, 23); font-family: Poppins, sans-serif; font-size: 20px;\">Packging</span>', '3', 1, '2025-01-31 00:26:09', '2025-02-02 21:28:18'),
(4, 'Warehousing', 13, '<div class=\"container-fluid\" style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; font-family: Poppins, sans-serif; --bs-gutter-x: 0; --bs-gutter-y: 0; width: 1300px; color: rgb(33, 37, 41); font-size: 16px;\"><div class=\"service\" style=\"margin: 0px; padding: 0px 64px;\"><div class=\"row service-list d-flex\" style=\"margin: 0px; padding: 0px; --bs-gutter-x: 0; --bs-gutter-y: 0; row-gap: 34px;\"><div class=\"col-md-3 d-flex flex-column justify-content-center align-items-center gap-4\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px 17px; flex-basis: auto; width: 292.992px; max-width: 100%;\"><span style=\"margin: 0px; padding: 0px; font-size: 20px; line-height: 28px; color: var(--txt-neutral-900);\">Warehousing</span><div><br></div></div></div></div></div>', '4', 1, '2025-01-31 00:26:09', '2025-02-02 21:30:30');

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

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

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

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) DEFAULT NULL,
  `value` varchar(191) 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 `sms_send_settings`
--

CREATE TABLE `sms_send_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sms_send_status` tinyint(3) UNSIGNED NOT NULL COMMENT '1=Parcel Create, 2=Delivered Cancel Customer, 3=Delivered Cancel Merchant',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive',
  `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 `sms_send_settings`
--

INSERT INTO `sms_send_settings` (`id`, `sms_send_status`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 0, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(2, 2, 0, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 3, 0, '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `sms_settings`
--

CREATE TABLE `sms_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) DEFAULT NULL,
  `value` varchar(191) 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 `sms_settings`
--

INSERT INTO `sms_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'reve_api_key', 'a7e4166cc9967d80', '2025-01-31 00:26:08', '2025-01-31 00:26:08'),
(2, 'reve_secret_key', 'e863dd2f', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'reve_api_url', 'http://smpp.ajuratech.com:7788/sendtext', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'reve_username', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(5, 'reve_user_password', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(6, 'reve_status', '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(7, 'twilio_sid', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(8, 'twilio_token', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(9, 'twilio_from', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(10, 'twilio_status', '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(11, 'nexmo_key', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(12, 'nexmo_secret_key', '', '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(13, 'nexmo_status', '0', '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `social_links`
--

CREATE TABLE `social_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `link` varchar(191) DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `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 `social_links`
--

INSERT INTO `social_links` (`id`, `name`, `icon`, `link`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 'facebook', 'fab fa-facebook-square', 'https://www.facebook.com', '1', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(2, 'Instagram', 'fab fa-instagram', 'https://www.instagram.com', '2', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'Twitter', 'fab fa-twitter', 'https://www.twitter.com', '3', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'Youtube', 'fab fa-youtube', 'https://www.youtube.com', '4', 0, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(5, 'Whatsapp', 'fab fa-whatsapp', 'https://www.whatsapp.com', '5', 0, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(6, 'Skype', 'fab fa-skype', 'https://www.skype.com', '6', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09');

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

--
-- Table structure for table `subscribes`
--

CREATE TABLE `subscribes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(191) 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 `supports`
--

CREATE TABLE `supports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `service` varchar(191) DEFAULT NULL,
  `priority` varchar(191) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `date` date DEFAULT NULL,
  `attached_file` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Pending,2= Processing,3= Resolved,4= Closed',
  `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 `support_chats`
--

CREATE TABLE `support_chats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `attached_file` bigint(20) UNSIGNED DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `to_dos`
--

CREATE TABLE `to_dos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'pending= 1, procesing= 2,complete= 3',
  `note` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `uploads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `original` varchar(191) DEFAULT NULL,
  `one` varchar(191) DEFAULT NULL,
  `two` varchar(191) DEFAULT NULL,
  `three` varchar(191) 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 `uploads`
--

INSERT INTO `uploads` (`id`, `original`, `one`, `two`, `three`, `created_at`, `updated_at`) VALUES
(1, 'uploads/users/user.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(2, 'uploads/users/user2.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(3, 'uploads/users/user3.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(4, 'uploads/users/user4.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(5, 'uploads/users/user5.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(6, 'uploads/users/user6.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(7, 'uploads/users/user7.png', NULL, NULL, NULL, '2025-01-31 00:26:07', '2025-01-31 00:26:07'),
(8, 'uploads/settings/202501311225443229.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 20:25:44'),
(9, 'uploads/settings/202501311325553739.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 21:25:55'),
(10, 'uploads/service/20250202132016.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-02 21:20:16'),
(11, 'uploads/service/20250202132616.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-02 21:26:16'),
(12, 'uploads/service/20250202132818.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-02 21:28:18'),
(13, 'uploads/service/20250202133030.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-02 21:30:30'),
(14, 'frontend/images/whycourier/timly-delivery.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(15, 'frontend/images/whycourier/limitless-pickup.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(16, 'frontend/images/whycourier/cash-on-delivery.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(17, 'frontend/images/whycourier/payment.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(18, 'frontend/images/whycourier/handling.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(19, 'frontend/images/whycourier/live-tracking.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(20, 'frontend/images/partner/1.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(21, 'uploads/partner/20250131164435.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-01 00:44:35'),
(22, 'uploads/partner/20250131164406.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-01 00:44:06'),
(23, 'uploads/partner/20250131164347.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-01 00:43:47'),
(24, 'frontend/images/partner/huawei.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(25, 'frontend/images/partner/ups.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(26, 'frontend/images/partner/1.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(27, 'frontend/images/partner/atom.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(28, 'frontend/images/partner/digg.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(29, 'frontend/images/partner/2.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(30, 'uploads/partner/20250131164517.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-01 00:45:17'),
(31, 'uploads/partner/20250131164456.png', NULL, NULL, NULL, '2025-01-31 00:26:09', '2025-02-01 00:44:56'),
(32, 'uploads/section/20250131154423.svg', NULL, NULL, NULL, '2025-01-31 23:44:23', '2025-01-31 23:44:23'),
(33, 'uploads/settings/202502021604486190.png', NULL, NULL, NULL, '2025-02-03 00:04:48', '2025-02-03 00:04:48');

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

--
-- Table structure for table `vat_statements`
--

CREATE TABLE `vat_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parcel_id` bigint(20) UNSIGNED NOT NULL,
  `type` tinyint(3) UNSIGNED DEFAULT NULL COMMENT 'income=1,expense=2',
  `amount` decimal(16,2) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `source` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `merchant_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `amount` decimal(22,2) DEFAULT NULL,
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Income,2= Expense',
  `payment_method` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1 = Offline ',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1 = Pending , 2= Approved,3= Reject',
  `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 `why_couriers`
--

CREATE TABLE `why_couriers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1= Active, 0= Inactive',
  `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 `why_couriers`
--

INSERT INTO `why_couriers` (`id`, `title`, `image_id`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Timely Delivery ', 14, '1', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(2, 'Limitless Pickup', 15, '2', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(3, 'Cash on delivery (COD)', 16, '3', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(4, 'Get Payment Any Time ', 17, '4', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(5, 'Secure Handling ', 18, '5', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09'),
(6, 'Live Tracking Update', 19, '6', 1, '2025-01-31 00:26:09', '2025-01-31 00:26:09');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

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

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

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assets_author_foreign` (`author`),
  ADD KEY `assets_hub_id_foreign` (`hub_id`);

--
-- Indexes for table `bank_transactions`
--
ALTER TABLE `bank_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bank_transactions_hub_id_foreign` (`hub_id`),
  ADD KEY `bank_transactions_fund_transfer_id_foreign` (`fund_transfer_id`),
  ADD KEY `bank_transactions_account_id_foreign` (`account_id`),
  ADD KEY `bank_transactions_income_id_foreign` (`income_id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogs_image_id_foreign` (`image_id`),
  ADD KEY `blogs_created_by_foreign` (`created_by`);

--
-- Indexes for table `cash_received_from_deliverymen`
--
ALTER TABLE `cash_received_from_deliverymen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cash_received_from_deliverymen_user_id_foreign` (`user_id`),
  ADD KEY `cash_received_from_deliverymen_hub_id_foreign` (`hub_id`),
  ADD KEY `cash_received_from_deliverymen_account_id_foreign` (`account_id`),
  ADD KEY `cash_received_from_deliverymen_delivery_man_id_foreign` (`delivery_man_id`),
  ADD KEY `cash_received_from_deliverymen_receipt_foreign` (`receipt`);

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

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

--
-- Indexes for table `courier_statements`
--
ALTER TABLE `courier_statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `courier_statements_income_id_foreign` (`income_id`),
  ADD KEY `courier_statements_parcel_id_foreign` (`parcel_id`),
  ADD KEY `courier_statements_delivery_man_id_foreign` (`delivery_man_id`);

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

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

--
-- Indexes for table `deliveryman_statements`
--
ALTER TABLE `deliveryman_statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deliveryman_statements_parcel_id_foreign` (`parcel_id`),
  ADD KEY `deliveryman_statements_delivery_man_id_foreign` (`delivery_man_id`);

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

--
-- Indexes for table `delivery_man`
--
ALTER TABLE `delivery_man`
  ADD PRIMARY KEY (`id`),
  ADD KEY `delivery_man_user_id_foreign` (`user_id`),
  ADD KEY `delivery_man_driving_license_image_id_foreign` (`driving_license_image_id`);

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

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

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expenses_account_head_id_foreign` (`account_head_id`),
  ADD KEY `expenses_merchant_id_foreign` (`merchant_id`),
  ADD KEY `expenses_delivery_man_id_foreign` (`delivery_man_id`),
  ADD KEY `expenses_user_id_foreign` (`user_id`),
  ADD KEY `expenses_parcel_id_foreign` (`parcel_id`),
  ADD KEY `expenses_account_id_foreign` (`account_id`),
  ADD KEY `expenses_receipt_foreign` (`receipt`);

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

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

--
-- Indexes for table `frauds`
--
ALTER TABLE `frauds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `frauds_created_by_foreign` (`created_by`);

--
-- Indexes for table `fund_transfers`
--
ALTER TABLE `fund_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fund_transfers_from_account_foreign` (`from_account`),
  ADD KEY `fund_transfers_to_account_foreign` (`to_account`);

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

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

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

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

--
-- Indexes for table `hub_payments`
--
ALTER TABLE `hub_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hub_payments_hub_id_foreign` (`hub_id`),
  ADD KEY `hub_payments_from_account_foreign` (`from_account`),
  ADD KEY `hub_payments_reference_file_foreign` (`reference_file`);

--
-- Indexes for table `hub_statements`
--
ALTER TABLE `hub_statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hub_statements_user_id_foreign` (`user_id`),
  ADD KEY `hub_statements_hub_id_foreign` (`hub_id`),
  ADD KEY `hub_statements_account_id_foreign` (`account_id`),
  ADD KEY `hub_statements_delivery_man_id_foreign` (`delivery_man_id`);

--
-- Indexes for table `incomes`
--
ALTER TABLE `incomes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `incomes_account_head_id_foreign` (`account_head_id`),
  ADD KEY `incomes_user_id_foreign` (`user_id`),
  ADD KEY `incomes_merchant_id_foreign` (`merchant_id`),
  ADD KEY `incomes_delivery_man_id_foreign` (`delivery_man_id`),
  ADD KEY `incomes_parcel_id_foreign` (`parcel_id`),
  ADD KEY `incomes_account_id_foreign` (`account_id`),
  ADD KEY `incomes_hub_id_foreign` (`hub_id`),
  ADD KEY `incomes_hub_user_id_foreign` (`hub_user_id`),
  ADD KEY `incomes_hub_user_account_id_foreign` (`hub_user_account_id`),
  ADD KEY `incomes_receipt_foreign` (`receipt`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoices_invoice_id_unique` (`invoice_id`),
  ADD KEY `invoices_merchant_id_foreign` (`merchant_id`);

--
-- Indexes for table `merchants`
--
ALTER TABLE `merchants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchants_user_id_foreign` (`user_id`),
  ADD KEY `merchants_nid_id_foreign` (`nid_id`),
  ADD KEY `merchants_trade_license_foreign` (`trade_license`);

--
-- Indexes for table `merchant_delivery_charges`
--
ALTER TABLE `merchant_delivery_charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_delivery_charges_merchant_id_foreign` (`merchant_id`),
  ADD KEY `merchant_delivery_charges_delivery_charge_id_foreign` (`delivery_charge_id`);

--
-- Indexes for table `merchant_online_payments`
--
ALTER TABLE `merchant_online_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_online_payments_account_id_foreign` (`account_id`),
  ADD KEY `merchant_online_payments_merchant_id_foreign` (`merchant_id`);

--
-- Indexes for table `merchant_online_payment_receiveds`
--
ALTER TABLE `merchant_online_payment_receiveds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_online_payment_receiveds_account_id_foreign` (`account_id`),
  ADD KEY `merchant_online_payment_receiveds_merchant_id_foreign` (`merchant_id`);

--
-- Indexes for table `merchant_payments`
--
ALTER TABLE `merchant_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_payments_merchant_id_foreign` (`merchant_id`);

--
-- Indexes for table `merchant_shops`
--
ALTER TABLE `merchant_shops`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_shops_merchant_id_foreign` (`merchant_id`);

--
-- Indexes for table `merchant_statements`
--
ALTER TABLE `merchant_statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `merchant_statements_parcel_id_foreign` (`parcel_id`),
  ADD KEY `merchant_statements_merchant_id_foreign` (`merchant_id`),
  ADD KEY `merchant_statements_delivery_man_id_foreign` (`delivery_man_id`);

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

--
-- Indexes for table `news_offers`
--
ALTER TABLE `news_offers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_offers_author_foreign` (`author`),
  ADD KEY `news_offers_file_foreign` (`file`);

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pages_page_index` (`page`),
  ADD KEY `pages_status_index` (`status`);

--
-- Indexes for table `parcels`
--
ALTER TABLE `parcels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parcels_merchant_id_foreign` (`merchant_id`),
  ADD KEY `parcels_hub_id_foreign` (`hub_id`),
  ADD KEY `parcels_transfer_hub_id_foreign` (`transfer_hub_id`);

--
-- Indexes for table `parcel_events`
--
ALTER TABLE `parcel_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parcel_events_parcel_id_foreign` (`parcel_id`),
  ADD KEY `parcel_events_delivery_man_id_foreign` (`delivery_man_id`),
  ADD KEY `parcel_events_pickup_man_id_foreign` (`pickup_man_id`),
  ADD KEY `parcel_events_hub_id_foreign` (`hub_id`),
  ADD KEY `parcel_events_transfer_delivery_man_id_foreign` (`transfer_delivery_man_id`),
  ADD KEY `parcel_events_created_by_foreign` (`created_by`);

--
-- Indexes for table `parcel_logs`
--
ALTER TABLE `parcel_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parcel_logs_merchant_id_foreign` (`merchant_id`),
  ADD KEY `parcel_logs_hub_id_foreign` (`hub_id`),
  ADD KEY `parcel_logs_delivery_man_id_foreign` (`delivery_man_id`),
  ADD KEY `parcel_logs_parcel_id_foreign` (`parcel_id`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `partners_image_id_foreign` (`image_id`);

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_merchant_id_foreign` (`merchant_id`),
  ADD KEY `payments_from_account_foreign` (`from_account`),
  ADD KEY `payments_reference_file_foreign` (`reference_file`);

--
-- Indexes for table `payment_accounts`
--
ALTER TABLE `payment_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_accounts_merchant_id_foreign` (`merchant_id`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `pickup_requests`
--
ALTER TABLE `pickup_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pickup_requests_merchant_id_foreign` (`merchant_id`);

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

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

--
-- Indexes for table `salaries`
--
ALTER TABLE `salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salaries_user_id_foreign` (`user_id`),
  ADD KEY `salaries_account_id_foreign` (`account_id`);

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

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sections_type_index` (`type`),
  ADD KEY `sections_key_index` (`key`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_image_id_foreign` (`image_id`);

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

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

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

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

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

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

--
-- Indexes for table `supports`
--
ALTER TABLE `supports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supports_user_id_foreign` (`user_id`),
  ADD KEY `supports_department_id_foreign` (`department_id`);

--
-- Indexes for table `support_chats`
--
ALTER TABLE `support_chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_chats_support_id_foreign` (`support_id`),
  ADD KEY `support_chats_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `vat_statements`
--
ALTER TABLE `vat_statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vat_statements_parcel_id_foreign` (`parcel_id`);

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

--
-- Indexes for table `why_couriers`
--
ALTER TABLE `why_couriers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `why_couriers_image_id_foreign` (`image_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

--
-- Constraints for table `assets`
--
ALTER TABLE `assets`
  ADD CONSTRAINT `assets_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `assets_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`);

--
-- Constraints for table `bank_transactions`
--
ALTER TABLE `bank_transactions`
  ADD CONSTRAINT `bank_transactions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_transactions_fund_transfer_id_foreign` FOREIGN KEY (`fund_transfer_id`) REFERENCES `fund_transfers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_transactions_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bank_transactions_income_id_foreign` FOREIGN KEY (`income_id`) REFERENCES `incomes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `blogs_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cash_received_from_deliverymen`
--
ALTER TABLE `cash_received_from_deliverymen`
  ADD CONSTRAINT `cash_received_from_deliverymen_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_received_from_deliverymen_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_received_from_deliverymen_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_received_from_deliverymen_receipt_foreign` FOREIGN KEY (`receipt`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_received_from_deliverymen_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `courier_statements`
--
ALTER TABLE `courier_statements`
  ADD CONSTRAINT `courier_statements_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `courier_statements_income_id_foreign` FOREIGN KEY (`income_id`) REFERENCES `incomes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `courier_statements_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deliveryman_statements`
--
ALTER TABLE `deliveryman_statements`
  ADD CONSTRAINT `deliveryman_statements_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `deliveryman_statements_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `delivery_charges`
--
ALTER TABLE `delivery_charges`
  ADD CONSTRAINT `delivery_charges_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `deliverycategories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `delivery_man`
--
ALTER TABLE `delivery_man`
  ADD CONSTRAINT `delivery_man_driving_license_image_id_foreign` FOREIGN KEY (`driving_license_image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_man_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expenses`
--
ALTER TABLE `expenses`
  ADD CONSTRAINT `expenses_account_head_id_foreign` FOREIGN KEY (`account_head_id`) REFERENCES `account_heads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_receipt_foreign` FOREIGN KEY (`receipt`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `frauds`
--
ALTER TABLE `frauds`
  ADD CONSTRAINT `frauds_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `fund_transfers`
--
ALTER TABLE `fund_transfers`
  ADD CONSTRAINT `fund_transfers_from_account_foreign` FOREIGN KEY (`from_account`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fund_transfers_to_account_foreign` FOREIGN KEY (`to_account`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `hub_payments`
--
ALTER TABLE `hub_payments`
  ADD CONSTRAINT `hub_payments_from_account_foreign` FOREIGN KEY (`from_account`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hub_payments_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hub_payments_reference_file_foreign` FOREIGN KEY (`reference_file`) REFERENCES `uploads` (`id`);

--
-- Constraints for table `hub_statements`
--
ALTER TABLE `hub_statements`
  ADD CONSTRAINT `hub_statements_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hub_statements_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hub_statements_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hub_statements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `incomes`
--
ALTER TABLE `incomes`
  ADD CONSTRAINT `incomes_account_head_id_foreign` FOREIGN KEY (`account_head_id`) REFERENCES `account_heads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_hub_user_account_id_foreign` FOREIGN KEY (`hub_user_account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_hub_user_id_foreign` FOREIGN KEY (`hub_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_receipt_foreign` FOREIGN KEY (`receipt`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `incomes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `merchants`
--
ALTER TABLE `merchants`
  ADD CONSTRAINT `merchants_nid_id_foreign` FOREIGN KEY (`nid_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchants_trade_license_foreign` FOREIGN KEY (`trade_license`) REFERENCES `uploads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchants_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_delivery_charges`
--
ALTER TABLE `merchant_delivery_charges`
  ADD CONSTRAINT `merchant_delivery_charges_delivery_charge_id_foreign` FOREIGN KEY (`delivery_charge_id`) REFERENCES `delivery_charges` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchant_delivery_charges_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_online_payments`
--
ALTER TABLE `merchant_online_payments`
  ADD CONSTRAINT `merchant_online_payments_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchant_online_payments_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_online_payment_receiveds`
--
ALTER TABLE `merchant_online_payment_receiveds`
  ADD CONSTRAINT `merchant_online_payment_receiveds_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchant_online_payment_receiveds_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_payments`
--
ALTER TABLE `merchant_payments`
  ADD CONSTRAINT `merchant_payments_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_shops`
--
ALTER TABLE `merchant_shops`
  ADD CONSTRAINT `merchant_shops_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `merchant_statements`
--
ALTER TABLE `merchant_statements`
  ADD CONSTRAINT `merchant_statements_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchant_statements_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `merchant_statements_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `news_offers`
--
ALTER TABLE `news_offers`
  ADD CONSTRAINT `news_offers_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `news_offers_file_foreign` FOREIGN KEY (`file`) REFERENCES `uploads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `parcels`
--
ALTER TABLE `parcels`
  ADD CONSTRAINT `parcels_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`),
  ADD CONSTRAINT `parcels_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcels_transfer_hub_id_foreign` FOREIGN KEY (`transfer_hub_id`) REFERENCES `hubs` (`id`);

--
-- Constraints for table `parcel_events`
--
ALTER TABLE `parcel_events`
  ADD CONSTRAINT `parcel_events_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_events_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_events_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_events_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_events_pickup_man_id_foreign` FOREIGN KEY (`pickup_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_events_transfer_delivery_man_id_foreign` FOREIGN KEY (`transfer_delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `parcel_logs`
--
ALTER TABLE `parcel_logs`
  ADD CONSTRAINT `parcel_logs_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_man` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_logs_hub_id_foreign` FOREIGN KEY (`hub_id`) REFERENCES `hubs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_logs_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `parcel_logs_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `partners`
--
ALTER TABLE `partners`
  ADD CONSTRAINT `partners_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_from_account_foreign` FOREIGN KEY (`from_account`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_reference_file_foreign` FOREIGN KEY (`reference_file`) REFERENCES `uploads` (`id`);

--
-- Constraints for table `payment_accounts`
--
ALTER TABLE `payment_accounts`
  ADD CONSTRAINT `payment_accounts_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pickup_requests`
--
ALTER TABLE `pickup_requests`
  ADD CONSTRAINT `pickup_requests_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `push_notifications`
--
ALTER TABLE `push_notifications`
  ADD CONSTRAINT `push_notifications_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salaries`
--
ALTER TABLE `salaries`
  ADD CONSTRAINT `salaries_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `salaries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `supports`
--
ALTER TABLE `supports`
  ADD CONSTRAINT `supports_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_chats`
--
ALTER TABLE `support_chats`
  ADD CONSTRAINT `support_chats_support_id_foreign` FOREIGN KEY (`support_id`) REFERENCES `supports` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `support_chats_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `vat_statements`
--
ALTER TABLE `vat_statements`
  ADD CONSTRAINT `vat_statements_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `why_couriers`
--
ALTER TABLE `why_couriers`
  ADD CONSTRAINT `why_couriers_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `uploads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

