-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 31, 2025 at 03:10 AM -- Server version: 10.6.22-MariaDB -- PHP Version: 8.3.21 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `delixcourier` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE `accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'income and expense', `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL, `method` varchar(191) DEFAULT NULL, `account_holder_name` varchar(191) DEFAULT NULL, `account_no` varchar(191) DEFAULT NULL, `bank_name` varchar(191) DEFAULT NULL, `bank_branch` varchar(191) DEFAULT NULL, `number` varchar(191) DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'merchant, personal', `balance` decimal(8,2) NOT NULL DEFAULT 0.00, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `activations` -- CREATE TABLE `activations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `code` varchar(191) NOT NULL, `completed` tinyint(1) NOT NULL DEFAULT 0, `completed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `activations` -- INSERT INTO `activations` (`id`, `user_id`, `code`, `completed`, `completed_at`, `created_at`, `updated_at`) VALUES (1, 1, 'UkA63m8LTy8ENmvaYrjfIRIP5MWRlyUb', 1, '2025-05-31 05:10:08', '2025-05-31 05:10:08', '2025-05-31 05:10:08'); -- -------------------------------------------------------- -- -- Table structure for table `api_keys` -- CREATE TABLE `api_keys` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `key` varchar(191) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `user_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 `api_key_languages` -- CREATE TABLE `api_key_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `api_key_id` varchar(191) NOT NULL, `title` varchar(191) DEFAULT NULL, `lang` varchar(10) NOT NULL DEFAULT 'en', `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 `branches` -- CREATE TABLE `branches` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'in charge user', `name` varchar(191) NOT NULL, `address` text DEFAULT NULL, `phone_number` varchar(191) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `default` tinyint(4) NOT NULL DEFAULT 0, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `charges` -- CREATE TABLE `charges` ( `id` bigint(20) UNSIGNED NOT NULL, `weight` varchar(191) DEFAULT NULL, `same_day` decimal(8,2) NOT NULL DEFAULT 0.00, `next_day` decimal(8,2) NOT NULL DEFAULT 0.00, `sub_city` decimal(8,2) NOT NULL DEFAULT 0.00, `sub_urban_area` decimal(8,2) NOT NULL DEFAULT 0.00, `frozen` decimal(8,2) NOT NULL DEFAULT 0.00, `third_party_booking` decimal(8,2) NOT NULL DEFAULT 0.00, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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; -- -- Dumping data for table `charges` -- INSERT INTO `charges` (`id`, `weight`, `same_day`, `next_day`, `sub_city`, `sub_urban_area`, `frozen`, `third_party_booking`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1, '1', 100.00, 60.00, 100.00, 130.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (2, '2', 120.00, 75.00, 115.00, 160.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (3, '3', 140.00, 90.00, 130.00, 190.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (4, '4', 160.00, 105.00, 145.00, 220.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (5, '5', 180.00, 120.00, 160.00, 250.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (6, '6', 200.00, 135.00, 175.00, 280.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (7, '7', 220.00, 150.00, 190.00, 310.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (8, '8', 240.00, 165.00, 205.00, 340.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (9, '9', 260.00, 180.00, 220.00, 370.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (10, '10', 280.00, 195.00, 235.00, 400.00, 0.00, 0.00, 'active', NULL, NULL, '2021-05-27 18:00:02', '2021-05-27 18:00:02'), (11, '11', 290.00, 205.00, 240.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (12, '12', 305.00, 220.00, 255.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (13, '13', 420.00, 235.00, 270.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (14, '14', 435.00, 240.00, 285.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (15, '15', 450.00, 255.00, 300.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (16, '16', 465.00, 270.00, 315.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (17, '17', 480.00, 295.00, 330.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (18, '18', 595.00, 305.00, 345.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (19, '19', 605.00, 420.00, 360.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL), (20, '20', 290.00, 205.00, 240.00, 0.00, 0.00, 0.00, 'active', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `cod_charges` -- CREATE TABLE `cod_charges` ( `id` bigint(20) UNSIGNED NOT NULL, `location` varchar(191) NOT NULL, `charge` decimal(8,2) NOT NULL DEFAULT 0.00, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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; -- -- Dumping data for table `cod_charges` -- INSERT INTO `cod_charges` (`id`, `location`, `charge`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1, 'city', 0.00, 'active', NULL, NULL, '2025-05-31 05:10:06', '2025-05-31 05:10:06'), (2, 'sub_city', 1.00, 'active', NULL, NULL, '2025-05-31 05:10:06', '2025-05-31 05:10:06'), (3, 'sub_urban_area', 1.00, 'active', NULL, NULL, '2025-05-31 05:10:06', '2025-05-31 05:10:06'), (4, 'third_party_booking', 1.00, 'active', NULL, NULL, '2025-05-31 05:10:06', '2025-05-31 05:10:06'); -- -------------------------------------------------------- -- -- Table structure for table `company_accounts` -- CREATE TABLE `company_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `source` varchar(191) DEFAULT NULL, `details` text DEFAULT NULL, `date` date DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'income/credit, expense/debit', `amount` decimal(8,2) DEFAULT NULL COMMENT 'positive and negative amount define by type', `balance` decimal(8,2) DEFAULT NULL COMMENT 'grand balance', `create_type` varchar(191) DEFAULT NULL COMMENT 'user_defined for admin create', `receipt` text DEFAULT NULL COMMENT 'any receipt uploaded', `reject_reason` text DEFAULT NULL COMMENT 'if request rejected', `transaction_id` text DEFAULT NULL COMMENT 'if request processed', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `merchant_id` bigint(20) UNSIGNED DEFAULT NULL, `parcel_id` bigint(20) UNSIGNED DEFAULT NULL, `merchant_withdraw_id` bigint(20) UNSIGNED DEFAULT NULL, `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `account_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'bank method/account wise cash collection', `date_time` datetime DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `updated_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 `contacts` -- CREATE TABLE `contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) DEFAULT NULL, `email` varchar(191) DEFAULT NULL, `phone` varchar(191) DEFAULT NULL, `message` 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 `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `iso3` varchar(191) DEFAULT NULL, `iso2` varchar(191) DEFAULT NULL, `phonecode` varchar(191) DEFAULT NULL, `currency` varchar(191) DEFAULT NULL, `currency_symbol` varchar(191) DEFAULT NULL, `latitude` varchar(191) DEFAULT NULL, `longitude` varchar(191) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `name`, `iso3`, `iso2`, `phonecode`, `currency`, `currency_symbol`, `latitude`, `longitude`, `status`, `created_at`, `updated_at`) VALUES (1, 'Afghanistan', 'AFG', 'AF', '93', 'AFN', '؋', '33.00000000', '65.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (2, 'Aland Islands', 'ALA', 'AX', '+358-18', 'EUR', '€', '60.11666700', '19.90000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (3, 'Albania', 'ALB', 'AL', '355', 'ALL', 'Lek', '41.00000000', '20.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (4, 'Algeria', 'DZA', 'DZ', '213', 'DZD', 'دج', '28.00000000', '3.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (5, 'American Samoa', 'ASM', 'AS', '+1-684', 'USD', '$', '-14.33333333', '-170.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (6, 'Andorra', 'AND', 'AD', '376', 'EUR', '€', '42.50000000', '1.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (7, 'Angola', 'AGO', 'AO', '244', 'AOA', 'Kz', '-12.50000000', '18.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (8, 'Anguilla', 'AIA', 'AI', '+1-264', 'XCD', '$', '18.25000000', '-63.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (9, 'Antarctica', 'ATA', 'AQ', '672', 'AAD', '$', '-74.65000000', '4.48000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (10, 'Antigua And Barbuda', 'ATG', 'AG', '+1-268', 'XCD', '$', '17.05000000', '-61.80000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (11, 'Argentina', 'ARG', 'AR', '54', 'ARS', '$', '-34.00000000', '-64.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (12, 'Armenia', 'ARM', 'AM', '374', 'AMD', '֏', '40.00000000', '45.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (13, 'Aruba', 'ABW', 'AW', '297', 'AWG', 'ƒ', '12.50000000', '-69.96666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (14, 'Australia', 'AUS', 'AU', '61', 'AUD', '$', '-27.00000000', '133.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (15, 'Austria', 'AUT', 'AT', '43', 'EUR', '€', '47.33333333', '13.33333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (16, 'Azerbaijan', 'AZE', 'AZ', '994', 'AZN', 'm', '40.50000000', '47.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (17, 'Bahamas The', 'BHS', 'BS', '+1-242', 'BSD', 'B$', '24.25000000', '-76.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (18, 'Bahrain', 'BHR', 'BH', '973', 'BHD', '.د.ب', '26.00000000', '50.55000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (19, 'Bangladesh', 'BGD', 'BD', '880', 'BDT', '৳', '24.00000000', '90.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (20, 'Barbados', 'BRB', 'BB', '+1-246', 'BBD', 'Bds$', '13.16666666', '-59.53333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (21, 'Belarus', 'BLR', 'BY', '375', 'BYN', 'Br', '53.00000000', '28.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (22, 'Belgium', 'BEL', 'BE', '32', 'EUR', '€', '50.83333333', '4.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (23, 'Belize', 'BLZ', 'BZ', '501', 'BZD', '$', '17.25000000', '-88.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (24, 'Benin', 'BEN', 'BJ', '229', 'XOF', 'CFA', '9.50000000', '2.25000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (25, 'Bermuda', 'BMU', 'BM', '+1-441', 'BMD', '$', '32.33333333', '-64.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (26, 'Bhutan', 'BTN', 'BT', '975', 'BTN', 'Nu.', '27.50000000', '90.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (27, 'Bolivia', 'BOL', 'BO', '591', 'BOB', 'Bs.', '-17.00000000', '-65.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (28, 'Bosnia and Herzegovina', 'BIH', 'BA', '387', 'BAM', 'KM', '44.00000000', '18.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (29, 'Botswana', 'BWA', 'BW', '267', 'BWP', 'P', '-22.00000000', '24.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (30, 'Bouvet Island', 'BVT', 'BV', '0055', 'NOK', 'kr', '-54.43333333', '3.40000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (31, 'Brazil', 'BRA', 'BR', '55', 'BRL', 'R$', '-10.00000000', '-55.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (32, 'British Indian Ocean Territory', 'IOT', 'IO', '246', 'USD', '$', '-6.00000000', '71.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (33, 'Brunei', 'BRN', 'BN', '673', 'BND', 'B$', '4.50000000', '114.66666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (34, 'Bulgaria', 'BGR', 'BG', '359', 'BGN', 'Лв.', '43.00000000', '25.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (35, 'Burkina Faso', 'BFA', 'BF', '226', 'XOF', 'CFA', '13.00000000', '-2.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (36, 'Burundi', 'BDI', 'BI', '257', 'BIF', 'FBu', '-3.50000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (37, 'Cambodia', 'KHM', 'KH', '855', 'KHR', 'KHR', '13.00000000', '105.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (38, 'Cameroon', 'CMR', 'CM', '237', 'XAF', 'FCFA', '6.00000000', '12.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (39, 'Canada', 'CAN', 'CA', '1', 'CAD', '$', '60.00000000', '-95.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (40, 'Cape Verde', 'CPV', 'CV', '238', 'CVE', '$', '16.00000000', '-24.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (41, 'Cayman Islands', 'CYM', 'KY', '+1-345', 'KYD', '$', '19.50000000', '-80.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (42, 'Central African Republic', 'CAF', 'CF', '236', 'XAF', 'FCFA', '7.00000000', '21.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (43, 'Chad', 'TCD', 'TD', '235', 'XAF', 'FCFA', '15.00000000', '19.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (44, 'Chile', 'CHL', 'CL', '56', 'CLP', '$', '-30.00000000', '-71.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (45, 'China', 'CHN', 'CN', '86', 'CNY', '¥', '35.00000000', '105.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (46, 'Christmas Island', 'CXR', 'CX', '61', 'AUD', '$', '-10.50000000', '105.66666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (47, 'Cocos (Keeling) Islands', 'CCK', 'CC', '61', 'AUD', '$', '-12.50000000', '96.83333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (48, 'Colombia', 'COL', 'CO', '57', 'COP', '$', '4.00000000', '-72.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (49, 'Comoros', 'COM', 'KM', '269', 'KMF', 'CF', '-12.16666666', '44.25000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (50, 'Congo', 'COG', 'CG', '242', 'XAF', 'FC', '-1.00000000', '15.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (51, 'Democratic Republic of the Congo', 'COD', 'CD', '243', 'CDF', 'FC', '0.00000000', '25.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (52, 'Cook Islands', 'COK', 'CK', '682', 'NZD', '$', '-21.23333333', '-159.76666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (53, 'Costa Rica', 'CRI', 'CR', '506', 'CRC', '₡', '10.00000000', '-84.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (54, 'Cote D\'Ivoire (Ivory Coast)', 'CIV', 'CI', '225', 'XOF', 'CFA', '8.00000000', '-5.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (55, 'Croatia', 'HRV', 'HR', '385', 'HRK', 'kn', '45.16666666', '15.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (56, 'Cuba', 'CUB', 'CU', '53', 'CUP', '$', '21.50000000', '-80.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (57, 'Cyprus', 'CYP', 'CY', '357', 'EUR', '€', '35.00000000', '33.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (58, 'Czech Republic', 'CZE', 'CZ', '420', 'CZK', 'Kč', '49.75000000', '15.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (59, 'Denmark', 'DNK', 'DK', '45', 'DKK', 'Kr.', '56.00000000', '10.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (60, 'Djibouti', 'DJI', 'DJ', '253', 'DJF', 'Fdj', '11.50000000', '43.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (61, 'Dominica', 'DMA', 'DM', '+1-767', 'XCD', '$', '15.41666666', '-61.33333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (62, 'Dominican Republic', 'DOM', 'DO', '+1-809 and 1-829', 'DOP', '$', '19.00000000', '-70.66666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (63, 'East Timor', 'TLS', 'TL', '670', 'USD', '$', '-8.83333333', '125.91666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (64, 'Ecuador', 'ECU', 'EC', '593', 'USD', '$', '-2.00000000', '-77.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (65, 'Egypt', 'EGY', 'EG', '20', 'EGP', 'ج.م', '27.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (66, 'El Salvador', 'SLV', 'SV', '503', 'USD', '$', '13.83333333', '-88.91666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (67, 'Equatorial Guinea', 'GNQ', 'GQ', '240', 'XAF', 'FCFA', '2.00000000', '10.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (68, 'Eritrea', 'ERI', 'ER', '291', 'ERN', 'Nfk', '15.00000000', '39.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (69, 'Estonia', 'EST', 'EE', '372', 'EUR', '€', '59.00000000', '26.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (70, 'Ethiopia', 'ETH', 'ET', '251', 'ETB', 'Nkf', '8.00000000', '38.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (71, 'Falkland Islands', 'FLK', 'FK', '500', 'FKP', '£', '-51.75000000', '-59.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (72, 'Faroe Islands', 'FRO', 'FO', '298', 'DKK', 'Kr.', '62.00000000', '-7.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (73, 'Fiji Islands', 'FJI', 'FJ', '679', 'FJD', 'FJ$', '-18.00000000', '175.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (74, 'Finland', 'FIN', 'FI', '358', 'EUR', '€', '64.00000000', '26.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (75, 'France', 'FRA', 'FR', '33', 'EUR', '€', '46.00000000', '2.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (76, 'French Guiana', 'GUF', 'GF', '594', 'EUR', '€', '4.00000000', '-53.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (77, 'French Polynesia', 'PYF', 'PF', '689', 'XPF', '₣', '-15.00000000', '-140.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (78, 'French Southern Territories', 'ATF', 'TF', '262', 'EUR', '€', '-49.25000000', '69.16700000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (79, 'Gabon', 'GAB', 'GA', '241', 'XAF', 'FCFA', '-1.00000000', '11.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (80, 'Gambia The', 'GMB', 'GM', '220', 'GMD', 'D', '13.46666666', '-16.56666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (81, 'Georgia', 'GEO', 'GE', '995', 'GEL', 'ლ', '42.00000000', '43.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (82, 'Germany', 'DEU', 'DE', '49', 'EUR', '€', '51.00000000', '9.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (83, 'Ghana', 'GHA', 'GH', '233', 'GHS', 'GH₵', '8.00000000', '-2.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (84, 'Gibraltar', 'GIB', 'GI', '350', 'GIP', '£', '36.13333333', '-5.35000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (85, 'Greece', 'GRC', 'GR', '30', 'EUR', '€', '39.00000000', '22.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (86, 'Greenland', 'GRL', 'GL', '299', 'DKK', 'Kr.', '72.00000000', '-40.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (87, 'Grenada', 'GRD', 'GD', '+1-473', 'XCD', '$', '12.11666666', '-61.66666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (88, 'Guadeloupe', 'GLP', 'GP', '590', 'EUR', '€', '16.25000000', '-61.58333300', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (89, 'Guam', 'GUM', 'GU', '+1-671', 'USD', '$', '13.46666666', '144.78333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (90, 'Guatemala', 'GTM', 'GT', '502', 'GTQ', 'Q', '15.50000000', '-90.25000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (91, 'Guernsey and Alderney', 'GGY', 'GG', '+44-1481', 'GBP', '£', '49.46666666', '-2.58333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (92, 'Guinea', 'GIN', 'GN', '224', 'GNF', 'FG', '11.00000000', '-10.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (93, 'Guinea-Bissau', 'GNB', 'GW', '245', 'XOF', 'CFA', '12.00000000', '-15.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (94, 'Guyana', 'GUY', 'GY', '592', 'GYD', '$', '5.00000000', '-59.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (95, 'Haiti', 'HTI', 'HT', '509', 'HTG', 'G', '19.00000000', '-72.41666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (96, 'Heard Island and McDonald Islands', 'HMD', 'HM', '672', 'AUD', '$', '-53.10000000', '72.51666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (97, 'Honduras', 'HND', 'HN', '504', 'HNL', 'L', '15.00000000', '-86.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (98, 'Hong Kong S.A.R.', 'HKG', 'HK', '852', 'HKD', '$', '22.25000000', '114.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (99, 'Hungary', 'HUN', 'HU', '36', 'HUF', 'Ft', '47.00000000', '20.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (100, 'Iceland', 'ISL', 'IS', '354', 'ISK', 'kr', '65.00000000', '-18.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (101, 'India', 'IND', 'IN', '91', 'INR', '₹', '20.00000000', '77.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (102, 'Indonesia', 'IDN', 'ID', '62', 'IDR', 'Rp', '-5.00000000', '120.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (103, 'Iran', 'IRN', 'IR', '98', 'IRR', '﷼', '32.00000000', '53.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (104, 'Iraq', 'IRQ', 'IQ', '964', 'IQD', 'د.ع', '33.00000000', '44.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (105, 'Ireland', 'IRL', 'IE', '353', 'EUR', '€', '53.00000000', '-8.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (106, 'Israel', 'ISR', 'IL', '972', 'ILS', '₪', '31.50000000', '34.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (107, 'Italy', 'ITA', 'IT', '39', 'EUR', '€', '42.83333333', '12.83333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (108, 'Jamaica', 'JAM', 'JM', '+1-876', 'JMD', 'J$', '18.25000000', '-77.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (109, 'Japan', 'JPN', 'JP', '81', 'JPY', '¥', '36.00000000', '138.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (110, 'Jersey', 'JEY', 'JE', '+44-1534', 'GBP', '£', '49.25000000', '-2.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (111, 'Jordan', 'JOR', 'JO', '962', 'JOD', 'ا.د', '31.00000000', '36.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (112, 'Kazakhstan', 'KAZ', 'KZ', '7', 'KZT', 'лв', '48.00000000', '68.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (113, 'Kenya', 'KEN', 'KE', '254', 'KES', 'KSh', '1.00000000', '38.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (114, 'Kiribati', 'KIR', 'KI', '686', 'AUD', '$', '1.41666666', '173.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (115, 'North Korea', 'PRK', 'KP', '850', 'KPW', '₩', '40.00000000', '127.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (116, 'South Korea', 'KOR', 'KR', '82', 'KRW', '₩', '37.00000000', '127.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (117, 'Kuwait', 'KWT', 'KW', '965', 'KWD', 'ك.د', '29.50000000', '45.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (118, 'Kyrgyzstan', 'KGZ', 'KG', '996', 'KGS', 'лв', '41.00000000', '75.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (119, 'Laos', 'LAO', 'LA', '856', 'LAK', '₭', '18.00000000', '105.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (120, 'Latvia', 'LVA', 'LV', '371', 'EUR', '€', '57.00000000', '25.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (121, 'Lebanon', 'LBN', 'LB', '961', 'LBP', '£', '33.83333333', '35.83333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (122, 'Lesotho', 'LSO', 'LS', '266', 'LSL', 'L', '-29.50000000', '28.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (123, 'Liberia', 'LBR', 'LR', '231', 'LRD', '$', '6.50000000', '-9.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (124, 'Libya', 'LBY', 'LY', '218', 'LYD', 'د.ل', '25.00000000', '17.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (125, 'Liechtenstein', 'LIE', 'LI', '423', 'CHF', 'CHf', '47.26666666', '9.53333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (126, 'Lithuania', 'LTU', 'LT', '370', 'EUR', '€', '56.00000000', '24.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (127, 'Luxembourg', 'LUX', 'LU', '352', 'EUR', '€', '49.75000000', '6.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (128, 'Macau S.A.R.', 'MAC', 'MO', '853', 'MOP', '$', '22.16666666', '113.55000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (129, 'Macedonia', 'MKD', 'MK', '389', 'MKD', 'ден', '41.83333333', '22.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (130, 'Madagascar', 'MDG', 'MG', '261', 'MGA', 'Ar', '-20.00000000', '47.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (131, 'Malawi', 'MWI', 'MW', '265', 'MWK', 'MK', '-13.50000000', '34.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (132, 'Malaysia', 'MYS', 'MY', '60', 'MYR', 'RM', '2.50000000', '112.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (133, 'Maldives', 'MDV', 'MV', '960', 'MVR', 'Rf', '3.25000000', '73.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (134, 'Mali', 'MLI', 'ML', '223', 'XOF', 'CFA', '17.00000000', '-4.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (135, 'Malta', 'MLT', 'MT', '356', 'EUR', '€', '35.83333333', '14.58333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (136, 'Man (Isle of)', 'IMN', 'IM', '+44-1624', 'GBP', '£', '54.25000000', '-4.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (137, 'Marshall Islands', 'MHL', 'MH', '692', 'USD', '$', '9.00000000', '168.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (138, 'Martinique', 'MTQ', 'MQ', '596', 'EUR', '€', '14.66666700', '-61.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (139, 'Mauritania', 'MRT', 'MR', '222', 'MRO', 'MRU', '20.00000000', '-12.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (140, 'Mauritius', 'MUS', 'MU', '230', 'MUR', '₨', '-20.28333333', '57.55000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (141, 'Mayotte', 'MYT', 'YT', '262', 'EUR', '€', '-12.83333333', '45.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (142, 'Mexico', 'MEX', 'MX', '52', 'MXN', '$', '23.00000000', '-102.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (143, 'Micronesia', 'FSM', 'FM', '691', 'USD', '$', '6.91666666', '158.25000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (144, 'Moldova', 'MDA', 'MD', '373', 'MDL', 'L', '47.00000000', '29.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (145, 'Monaco', 'MCO', 'MC', '377', 'EUR', '€', '43.73333333', '7.40000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (146, 'Mongolia', 'MNG', 'MN', '976', 'MNT', '₮', '46.00000000', '105.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (147, 'Montenegro', 'MNE', 'ME', '382', 'EUR', '€', '42.50000000', '19.30000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (148, 'Montserrat', 'MSR', 'MS', '+1-664', 'XCD', '$', '16.75000000', '-62.20000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (149, 'Morocco', 'MAR', 'MA', '212', 'MAD', 'DH', '32.00000000', '-5.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (150, 'Mozambique', 'MOZ', 'MZ', '258', 'MZN', 'MT', '-18.25000000', '35.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (151, 'Myanmar', 'MMR', 'MM', '95', 'MMK', 'K', '22.00000000', '98.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (152, 'Namibia', 'NAM', 'NA', '264', 'NAD', '$', '-22.00000000', '17.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (153, 'Nauru', 'NRU', 'NR', '674', 'AUD', '$', '-0.53333333', '166.91666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (154, 'Nepal', 'NPL', 'NP', '977', 'NPR', '₨', '28.00000000', '84.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (155, 'Bonaire, Sint Eustatius and Saba', 'BES', 'BQ', '599', 'USD', '$', '12.15000000', '-68.26666700', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (156, 'Netherlands', 'NLD', 'NL', '31', 'EUR', '€', '52.50000000', '5.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (157, 'New Caledonia', 'NCL', 'NC', '687', 'XPF', '₣', '-21.50000000', '165.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (158, 'New Zealand', 'NZL', 'NZ', '64', 'NZD', '$', '-41.00000000', '174.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (159, 'Nicaragua', 'NIC', 'NI', '505', 'NIO', 'C$', '13.00000000', '-85.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (160, 'Niger', 'NER', 'NE', '227', 'XOF', 'CFA', '16.00000000', '8.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (161, 'Nigeria', 'NGA', 'NG', '234', 'NGN', '₦', '10.00000000', '8.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (162, 'Niue', 'NIU', 'NU', '683', 'NZD', '$', '-19.03333333', '-169.86666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (163, 'Norfolk Island', 'NFK', 'NF', '672', 'AUD', '$', '-29.03333333', '167.95000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (164, 'Northern Mariana Islands', 'MNP', 'MP', '+1-670', 'USD', '$', '15.20000000', '145.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (165, 'Norway', 'NOR', 'NO', '47', 'NOK', 'kr', '62.00000000', '10.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (166, 'Oman', 'OMN', 'OM', '968', 'OMR', '.ع.ر', '21.00000000', '57.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (167, 'Pakistan', 'PAK', 'PK', '92', 'PKR', '₨', '30.00000000', '70.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (168, 'Palau', 'PLW', 'PW', '680', 'USD', '$', '7.50000000', '134.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (169, 'Palestinian Territory Occupied', 'PSE', 'PS', '970', 'ILS', '₪', '31.90000000', '35.20000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (170, 'Panama', 'PAN', 'PA', '507', 'PAB', 'B/.', '9.00000000', '-80.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (171, 'Papua new Guinea', 'PNG', 'PG', '675', 'PGK', 'K', '-6.00000000', '147.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (172, 'Paraguay', 'PRY', 'PY', '595', 'PYG', '₲', '-23.00000000', '-58.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (173, 'Peru', 'PER', 'PE', '51', 'PEN', 'S/.', '-10.00000000', '-76.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (174, 'Philippines', 'PHL', 'PH', '63', 'PHP', '₱', '13.00000000', '122.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (175, 'Pitcairn Island', 'PCN', 'PN', '870', 'NZD', '$', '-25.06666666', '-130.10000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (176, 'Poland', 'POL', 'PL', '48', 'PLN', 'zł', '52.00000000', '20.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (177, 'Portugal', 'PRT', 'PT', '351', 'EUR', '€', '39.50000000', '-8.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (178, 'Puerto Rico', 'PRI', 'PR', '+1-787 and 1-939', 'USD', '$', '18.25000000', '-66.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (179, 'Qatar', 'QAT', 'QA', '974', 'QAR', 'ق.ر', '25.50000000', '51.25000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (180, 'Reunion', 'REU', 'RE', '262', 'EUR', '€', '-21.15000000', '55.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (181, 'Romania', 'ROU', 'RO', '40', 'RON', 'lei', '46.00000000', '25.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (182, 'Russia', 'RUS', 'RU', '7', 'RUB', '₽', '60.00000000', '100.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (183, 'Rwanda', 'RWA', 'RW', '250', 'RWF', 'FRw', '-2.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (184, 'Saint Helena', 'SHN', 'SH', '290', 'SHP', '£', '-15.95000000', '-5.70000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (185, 'Saint Kitts And Nevis', 'KNA', 'KN', '+1-869', 'XCD', '$', '17.33333333', '-62.75000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (186, 'Saint Lucia', 'LCA', 'LC', '+1-758', 'XCD', '$', '13.88333333', '-60.96666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (187, 'Saint Pierre and Miquelon', 'SPM', 'PM', '508', 'EUR', '€', '46.83333333', '-56.33333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (188, 'Saint Vincent And The Grenadines', 'VCT', 'VC', '+1-784', 'XCD', '$', '13.25000000', '-61.20000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (189, 'Saint-Barthelemy', 'BLM', 'BL', '590', 'EUR', '€', '18.50000000', '-63.41666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (190, 'Saint-Martin (French part)', 'MAF', 'MF', '590', 'EUR', '€', '18.08333333', '-63.95000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (191, 'Samoa', 'WSM', 'WS', '685', 'WST', 'SAT', '-13.58333333', '-172.33333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (192, 'San Marino', 'SMR', 'SM', '378', 'EUR', '€', '43.76666666', '12.41666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (193, 'Sao Tome and Principe', 'STP', 'ST', '239', 'STD', 'Db', '1.00000000', '7.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (194, 'Saudi Arabia', 'SAU', 'SA', '966', 'SAR', '﷼', '25.00000000', '45.00000000', 'active', '2018-07-20 08:11:03', '2021-09-26 01:09:09'), (195, 'Senegal', 'SEN', 'SN', '221', 'XOF', 'CFA', '14.00000000', '-14.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (196, 'Serbia', 'SRB', 'RS', '381', 'RSD', 'din', '44.00000000', '21.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (197, 'Seychelles', 'SYC', 'SC', '248', 'SCR', 'SRe', '-4.58333333', '55.66666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (198, 'Sierra Leone', 'SLE', 'SL', '232', 'SLL', 'Le', '8.50000000', '-11.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (199, 'Singapore', 'SGP', 'SG', '65', 'SGD', '$', '1.36666666', '103.80000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (200, 'Slovakia', 'SVK', 'SK', '421', 'EUR', '€', '48.66666666', '19.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (201, 'Slovenia', 'SVN', 'SI', '386', 'EUR', '€', '46.11666666', '14.81666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (202, 'Solomon Islands', 'SLB', 'SB', '677', 'SBD', 'Si$', '-8.00000000', '159.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (203, 'Somalia', 'SOM', 'SO', '252', 'SOS', 'Sh.so.', '10.00000000', '49.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (204, 'South Africa', 'ZAF', 'ZA', '27', 'ZAR', 'R', '-29.00000000', '24.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (205, 'South Georgia', 'SGS', 'GS', '500', 'GBP', '£', '-54.50000000', '-37.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (206, 'South Sudan', 'SSD', 'SS', '211', 'SSP', '£', '7.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (207, 'Spain', 'ESP', 'ES', '34', 'EUR', '€', '40.00000000', '-4.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (208, 'Sri Lanka', 'LKA', 'LK', '94', 'LKR', 'Rs', '7.00000000', '81.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (209, 'Sudan', 'SDN', 'SD', '249', 'SDG', '.س.ج', '15.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (210, 'Suriname', 'SUR', 'SR', '597', 'SRD', '$', '4.00000000', '-56.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (211, 'Svalbard And Jan Mayen Islands', 'SJM', 'SJ', '47', 'NOK', 'kr', '78.00000000', '20.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (212, 'Swaziland', 'SWZ', 'SZ', '268', 'SZL', 'E', '-26.50000000', '31.50000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (213, 'Sweden', 'SWE', 'SE', '46', 'SEK', 'kr', '62.00000000', '15.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (214, 'Switzerland', 'CHE', 'CH', '41', 'CHF', 'CHf', '47.00000000', '8.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (215, 'Syria', 'SYR', 'SY', '963', 'SYP', 'LS', '35.00000000', '38.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (216, 'Taiwan', 'TWN', 'TW', '886', 'TWD', '$', '23.50000000', '121.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (217, 'Tajikistan', 'TJK', 'TJ', '992', 'TJS', 'SM', '39.00000000', '71.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (218, 'Tanzania', 'TZA', 'TZ', '255', 'TZS', 'TSh', '-6.00000000', '35.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (219, 'Thailand', 'THA', 'TH', '66', 'THB', '฿', '15.00000000', '100.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (220, 'Togo', 'TGO', 'TG', '228', 'XOF', 'CFA', '8.00000000', '1.16666666', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (221, 'Tokelau', 'TKL', 'TK', '690', 'NZD', '$', '-9.00000000', '-172.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (222, 'Tonga', 'TON', 'TO', '676', 'TOP', '$', '-20.00000000', '-175.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (223, 'Trinidad And Tobago', 'TTO', 'TT', '+1-868', 'TTD', '$', '11.00000000', '-61.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (224, 'Tunisia', 'TUN', 'TN', '216', 'TND', 'ت.د', '34.00000000', '9.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (225, 'Turkey', 'TUR', 'TR', '90', 'TRY', '₺', '39.00000000', '35.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (226, 'Turkmenistan', 'TKM', 'TM', '993', 'TMT', 'T', '40.00000000', '60.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (227, 'Turks And Caicos Islands', 'TCA', 'TC', '+1-649', 'USD', '$', '21.75000000', '-71.58333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (228, 'Tuvalu', 'TUV', 'TV', '688', 'AUD', '$', '-8.00000000', '178.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (229, 'Uganda', 'UGA', 'UG', '256', 'UGX', 'USh', '1.00000000', '32.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (230, 'Ukraine', 'UKR', 'UA', '380', 'UAH', '₴', '49.00000000', '32.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (231, 'United Arab Emirates', 'ARE', 'AE', '971', 'AED', 'إ.د', '24.00000000', '54.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (232, 'United Kingdom', 'GBR', 'GB', '44', 'GBP', '£', '54.00000000', '-2.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (233, 'United States', 'USA', 'US', '1', 'USD', '$', '38.00000000', '-97.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (234, 'United States Minor Outlying Islands', 'UMI', 'UM', '1', 'USD', '$', '0.00000000', '0.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (235, 'Uruguay', 'URY', 'UY', '598', 'UYU', '$', '-33.00000000', '-56.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (236, 'Uzbekistan', 'UZB', 'UZ', '998', 'UZS', 'лв', '41.00000000', '64.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (237, 'Vanuatu', 'VUT', 'VU', '678', 'VUV', 'VT', '-16.00000000', '167.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (238, 'Vatican City State (Holy See)', 'VAT', 'VA', '379', 'EUR', '€', '41.90000000', '12.45000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (239, 'Venezuela', 'VEN', 'VE', '58', 'VEF', 'Bs', '8.00000000', '-66.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (240, 'Vietnam', 'VNM', 'VN', '84', 'VND', '₫', '16.16666666', '107.83333333', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (241, 'Virgin Islands (British)', 'VGB', 'VG', '+1-284', 'USD', '$', '18.43138300', '-64.62305000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (242, 'Virgin Islands (US)', 'VIR', 'VI', '+1-340', 'USD', '$', '18.34000000', '-64.93000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (243, 'Wallis And Futuna Islands', 'WLF', 'WF', '681', 'XPF', '₣', '-13.30000000', '-176.20000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (244, 'Western Sahara', 'ESH', 'EH', '212', 'MAD', 'MAD', '24.50000000', '-13.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (245, 'Yemen', 'YEM', 'YE', '967', 'YER', '﷼', '15.00000000', '48.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (246, 'Zambia', 'ZMB', 'ZM', '260', 'ZMW', 'ZK', '-15.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (247, 'Zimbabwe', 'ZWE', 'ZW', '263', 'ZWL', '$', '-20.00000000', '30.00000000', 'active', '2018-07-20 08:11:03', '2021-08-01 02:37:27'), (248, 'Kosovo', 'XKX', 'XK', '383', 'EUR', '€', '42.56129090', '20.34030350', 'active', '2020-08-15 03:33:50', '2021-08-01 02:37:57'), (249, 'Curaçao', 'CUW', 'CW', '599', 'ANG', 'ƒ', '12.11666700', '-68.93333300', 'active', '2020-10-25 02:54:20', '2021-08-01 02:37:27'), (250, 'Sint Maarten (Dutch part)', 'SXM', 'SX', '1721', 'ANG', 'ƒ', '18.03333300', '-63.05000000', 'active', '2020-12-05 01:03:39', '2021-08-01 02:37:27'); -- -------------------------------------------------------- -- -- Table structure for table `customer_parcel_sms_templates` -- CREATE TABLE `customer_parcel_sms_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(191) DEFAULT NULL, `content` longtext DEFAULT NULL, `sms_to_customer` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `masking` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customer_parcel_sms_templates` -- INSERT INTO `customer_parcel_sms_templates` (`id`, `subject`, `content`, `sms_to_customer`, `masking`, `created_at`, `updated_at`) VALUES (1, 'parcel_create_event', 'Your parcel {parcel_id} from {merchant_name} has been created successfully at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (2, 'assign_pickup_man_event', 'A pickup man has been assigned for pickup your parcel {parcel_id} from {merchant_name} at {pickup_date_time}. Pickup man: {pickup_man_name}, {pickup_man_phone}. \r\n{our_company_name}', 0, 0, NULL, NULL), (3, 'parcel_re_schedule_pickup_event', 'Your parcel {parcel_id} has been re-schedule for pickup at {re_pickup_date_time} from {merchant_name}. Pickup man: {pickup_man_name}, {pickup_man_phone}.\r\n{our_company_name}', 0, 0, NULL, NULL), (4, 'parcel_received_by_pickup_man_event', 'A pickup man have collected your parcel {parcel_id} from {merchant_name}. We will inform you while dispatching the parcel for delivery. \r\n{our_company_name}', 0, 0, NULL, NULL), (5, 'parcel_received_event', 'We have collected your parcel {parcel_id} from {merchant_name}. We will inform you while dispatching the parcel for delivery. \r\n{our_company_name}', 0, 0, NULL, NULL), (6, 'parcel_transferred_to_branch_assigned_event', 'Your parcel {parcel_id} has been assigned to transfer on another branch.\r\n{our_company_name}', 0, 0, NULL, NULL), (7, 'parcel_transferred_to_branch_event', 'Your parcel {parcel_id} has been successfully transfer on another branch.\r\n{our_company_name}', 0, 0, NULL, NULL), (8, 'assign_delivery_man_event', 'Pre-Delivery Info:\r\nParcel No: {parcel_id}\r\nCompany: {merchant_name}\r\nPrice: BDT {price} \r\nDelivery Person: {delivery_man_name}\r\nContact: {delivery_man_phone}. For Track: {short_url}\r\n{our_company_name}', 0, 0, NULL, NULL), (9, 'parcel_re_schedule_delivery_event', 'Your parcel {parcel_id} has been re-scheduled for delivery at {re_delivery_date_time}.\r\nRe-schedule delivery Info:\r\nParcel No: {parcel_id}\r\nCompany: {merchant_name}\r\nPrice: BDT {price} \r\nDelivery Person: {delivery_man_name}\r\nContact: {delivery_man_phone}\r\n{our_company_name}', 0, 0, NULL, NULL), (10, 'parcel_delivered_event', 'Your parcel {parcel_id} has been successfully delivered to you from {merchant_name} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (11, 'parcel_return_to_wirehouse', 'Your parcel {parcel_id} from {merchant_name} has been return to {our_company_name} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (12, 'parcel_return_assign_to_merchant_event', 'Your parcel {parcel_id} has been assigned for returning to {merchant_name} at {current_date_time}. Delivery Man: {delivery_man_name}, {delivery_man_phone}.\r\n{our_company_name}', 0, 0, NULL, NULL), (13, 'parcel_returned_to_merchant_event', 'Your parcel {parcel_id} has been successfully returned to {merchant_name} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (14, 'parcel_cancel_event', 'Your parcel {parcel_id} from {merchant_name} has been cancelled for delivery at {current_date_time}. Reason: {cancel_note}\r\n{our_company_name}', 0, 0, NULL, NULL), (15, 'parcel_re_request_event', 'Your parcel {parcel_id} from {merchant_name} has been re-requested for delivery at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (16, 'parcel_update_event', 'Your parcel {parcel_id} from {merchant_name} has been updated at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (17, 'delivery_confirm_otp', 'Please share, this OTP: {otp} with the delivery hero to confirm your parcel successfully delivered to you. Do not share this OTP with anyone else.\r\n{our_company_name}', 0, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `delivery_man_accounts` -- CREATE TABLE `delivery_man_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `source` varchar(191) DEFAULT NULL, `details` text DEFAULT NULL, `date` date DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'income/credit, expense/debit', `amount` decimal(8,2) DEFAULT NULL COMMENT 'positive and negative amount define by type', `balance` decimal(8,2) DEFAULT NULL COMMENT 'grand balance', `parcel_id` bigint(20) UNSIGNED DEFAULT NULL, `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `company_account_id` bigint(20) UNSIGNED DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `delivery_men` -- CREATE TABLE `delivery_men` ( `id` bigint(20) UNSIGNED NOT NULL, `phone_number` varchar(30) NOT NULL, `city` varchar(100) DEFAULT NULL, `zip` varchar(15) DEFAULT NULL COMMENT 'postal code', `address` text DEFAULT NULL, `driving_license` text DEFAULT NULL, `pick_up_fee` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '1', `delivery_fee` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '1', `return_fee` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '1', `user_id` bigint(20) UNSIGNED NOT NULL, `balance` decimal(8,2) DEFAULT NULL, `is_vertual` int(11) NOT NULL DEFAULT 0, `is_shuttle` int(11) NOT NULL DEFAULT 0, `sip_extension` varchar(151) DEFAULT NULL, `sip_password` varchar(151) DEFAULT NULL, `dial_enable` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `district_zilas` -- CREATE TABLE `district_zilas` ( `id` bigint(20) UNSIGNED NOT NULL, `point_code` varchar(20) DEFAULT NULL, `point_name` varchar(100) DEFAULT NULL, `union_para_name` varchar(191) DEFAULT NULL, `thana_name` varchar(191) DEFAULT NULL, `district_name` 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 `email_templates` -- CREATE TABLE `email_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(191) NOT NULL, `identifier` varchar(191) NOT NULL, `title` varchar(191) DEFAULT NULL, `body` text DEFAULT NULL, `short_codes` varchar(191) DEFAULT NULL, `email_type` varchar(191) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`id`, `subject`, `identifier`, `title`, `body`, `short_codes`, `email_type`, `status`, `created_at`, `updated_at`) VALUES (1, 'Email Confirmation', 'Email Confirmation', 'email_confirmation', '

Hi {name},

Please confirm your email by clicking the link below:

{confirmation_link}


Thanks

{site_name}

', '{name},{email},{site_name},{confirmation_link}', 'authentication', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (2, 'Welcome Email', 'Welcome Email', 'welcome_email', 'Thank you for joining us at {site_name}! We are thrilled to have you onboard.', '{site_name}', 'authentication', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (3, 'Password Reset Mail', 'Password Reset Mail', 'password_reset', 'We received a request to reset your password. Click the button below to set a new password:', '{site_name}', 'authentication', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (4, 'Recovery Successful Mail', 'Recovery Successful Mail', 'recovery_mail', 'Your password has been successfully updated! You can now log in with your new credentials.', '{site_name}', 'authentication', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'); -- -------------------------------------------------------- -- -- 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 `flag_icons` -- CREATE TABLE `flag_icons` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(50) NOT NULL, `title` varchar(10) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `flag_icons` -- INSERT INTO `flag_icons` (`id`, `image`, `title`, `created_at`, `updated_at`) VALUES (1, 'images/flags/ad.png', 'AD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (2, 'images/flags/ae.png', 'AE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (3, 'images/flags/af.png', 'AF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (4, 'images/flags/ag.png', 'AG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (5, 'images/flags/ai.png', 'AI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (6, 'images/flags/al.png', 'AL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (7, 'images/flags/am.png', 'AM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (8, 'images/flags/ao.png', 'AO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (9, 'images/flags/ar.png', 'AR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (10, 'images/flags/as.png', 'AS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (11, 'images/flags/at.png', 'AT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (12, 'images/flags/au.png', 'AU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (13, 'images/flags/aw.png', 'AW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (14, 'images/flags/ax.png', 'AX', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (15, 'images/flags/az.png', 'AZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (16, 'images/flags/ba.png', 'BA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (17, 'images/flags/bb.png', 'BB', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (18, 'images/flags/bd.png', 'BD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (19, 'images/flags/be.png', 'BE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (20, 'images/flags/bf.png', 'BF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (21, 'images/flags/bg.png', 'BG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (22, 'images/flags/bh.png', 'BH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (23, 'images/flags/bi.png', 'BI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (24, 'images/flags/bj.png', 'BJ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (25, 'images/flags/bm.png', 'BM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (26, 'images/flags/bn.png', 'BN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (27, 'images/flags/bo.png', 'BO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (28, 'images/flags/br.png', 'BR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (29, 'images/flags/bs.png', 'BS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (30, 'images/flags/bt.png', 'BT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (31, 'images/flags/bv.png', 'BV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (32, 'images/flags/bw.png', 'BW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (33, 'images/flags/by.png', 'BY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (34, 'images/flags/bz.png', 'BZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (35, 'images/flags/ca.png', 'CA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (36, 'images/flags/cc.png', 'CC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (37, 'images/flags/cd.png', 'CD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (38, 'images/flags/cf.png', 'CF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (39, 'images/flags/cg.png', 'CG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (40, 'images/flags/ch.png', 'CH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (41, 'images/flags/ci.png', 'CI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (42, 'images/flags/ck.png', 'CK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (43, 'images/flags/cl.png', 'CL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (44, 'images/flags/cm.png', 'CM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (45, 'images/flags/cn.png', 'CN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (46, 'images/flags/co.png', 'CO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (47, 'images/flags/cr.png', 'CR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (48, 'images/flags/cv.png', 'CV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (49, 'images/flags/cv.png', 'CV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (50, 'images/flags/cx.png', 'CX', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (51, 'images/flags/cy.png', 'CY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (52, 'images/flags/cz.png', 'CZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (53, 'images/flags/de.png', 'DE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (54, 'images/flags/dj.png', 'DJ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (55, 'images/flags/dk.png', 'DK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (56, 'images/flags/dm.png', 'DM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (57, 'images/flags/do.png', 'DO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (58, 'images/flags/dz.png', 'DZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (59, 'images/flags/ec.png', 'EC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (60, 'images/flags/ee.png', 'EE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (61, 'images/flags/eg.png', 'EG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (62, 'images/flags/eh.png', 'EH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (63, 'images/flags/er.png', 'ER', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (64, 'images/flags/es.png', 'ES', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (65, 'images/flags/et.png', 'ET', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (66, 'images/flags/fi.png', 'FI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (67, 'images/flags/fj.png', 'FJ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (68, 'images/flags/fk.png', 'FK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (69, 'images/flags/fm.png', 'FM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (70, 'images/flags/fo.png', 'FO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (71, 'images/flags/fr.png', 'FR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (72, 'images/flags/ga.png', 'GA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (73, 'images/flags/gb.png', 'GB', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (74, 'images/flags/gd.png', 'GD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (75, 'images/flags/ge.png', 'GE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (76, 'images/flags/gf.png', 'GF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (77, 'images/flags/gh.png', 'GH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (78, 'images/flags/gi.png', 'GI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (79, 'images/flags/gl.png', 'GL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (80, 'images/flags/gm.png', 'GM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (81, 'images/flags/gn.png', 'GN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (82, 'images/flags/gn.png', 'GN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (83, 'images/flags/gp.png', 'GP', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (84, 'images/flags/gq.png', 'GQ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (85, 'images/flags/gr.png', 'GR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (86, 'images/flags/gs.png', 'GS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (87, 'images/flags/gt.png', 'GT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (88, 'images/flags/gu.png', 'GU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (89, 'images/flags/gw.png', 'GW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (90, 'images/flags/gy.png', 'GY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (91, 'images/flags/hk.png', 'HK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (92, 'images/flags/hm.png', 'HM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (93, 'images/flags/hn.png', 'HN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (94, 'images/flags/hr.png', 'HR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (95, 'images/flags/ht.png', 'HT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (96, 'images/flags/hu.png', 'HU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (97, 'images/flags/id.png', 'ID', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (98, 'images/flags/ie.png', 'IE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (99, 'images/flags/il.png', 'IL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (100, 'images/flags/in.png', 'IN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (101, 'images/flags/io.png', 'IO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (102, 'images/flags/iq.png', 'IQ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (103, 'images/flags/ir.png', 'IR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (104, 'images/flags/is.png', 'IS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (105, 'images/flags/it.png', 'IT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (106, 'images/flags/jm.png', 'JM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (107, 'images/flags/jo.png', 'JO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (108, 'images/flags/jp.png', 'JP', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (109, 'images/flags/ke.png', 'KE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (110, 'images/flags/kg.png', 'KG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (111, 'images/flags/kh.png', 'KH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (112, 'images/flags/ki.png', 'KI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (113, 'images/flags/km.png', 'KM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (114, 'images/flags/kn.png', 'KN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (115, 'images/flags/kp.png', 'KP', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (116, 'images/flags/kr.png', 'KR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (117, 'images/flags/kw.png', 'KW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (118, 'images/flags/ky.png', 'KY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (119, 'images/flags/kz.png', 'KZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (120, 'images/flags/la.png', 'LA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (121, 'images/flags/lb.png', 'LB', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (122, 'images/flags/lc.png', 'LC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (123, 'images/flags/li.png', 'LI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (124, 'images/flags/lk.png', 'LK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (125, 'images/flags/lr.png', 'LR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (126, 'images/flags/ls.png', 'LS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (127, 'images/flags/lt.png', 'LT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (128, 'images/flags/lu.png', 'LU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (129, 'images/flags/lv.png', 'LV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (130, 'images/flags/ly.png', 'LY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (131, 'images/flags/ma.png', 'MA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (132, 'images/flags/mc.png', 'MC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (133, 'images/flags/md.png', 'MD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (134, 'images/flags/me.png', 'ME', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (135, 'images/flags/mg.png', 'MG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (136, 'images/flags/mh.png', 'MH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (137, 'images/flags/mk.png', 'MK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (138, 'images/flags/ml.png', 'ML', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (139, 'images/flags/mm.png', 'MM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (140, 'images/flags/mn.png', 'MN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (141, 'images/flags/mo.png', 'MO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (142, 'images/flags/mp.png', 'MP', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (143, 'images/flags/mq.png', 'MQ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (144, 'images/flags/mr.png', 'MR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (145, 'images/flags/ms.png', 'MS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (146, 'images/flags/mt.png', 'MT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (147, 'images/flags/mu.png', 'MU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (148, 'images/flags/mv.png', 'MV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (149, 'images/flags/mw.png', 'MW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (150, 'images/flags/mx.png', 'MX', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (151, 'images/flags/my.png', 'MY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (152, 'images/flags/mz.png', 'MZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (153, 'images/flags/na.png', 'NA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (154, 'images/flags/nc.png', 'NC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (155, 'images/flags/ne.png', 'NE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (156, 'images/flags/nf.png', 'NF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (157, 'images/flags/ng.png', 'NG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (158, 'images/flags/ni.png', 'NI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (159, 'images/flags/nl.png', 'NL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (160, 'images/flags/no.png', 'NO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (161, 'images/flags/np.png', 'NP', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (162, 'images/flags/nr.png', 'NR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (163, 'images/flags/nu.png', 'NU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (164, 'images/flags/nz.png', 'NZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (165, 'images/flags/om.png', 'OM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (166, 'images/flags/pa.png', 'PA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (167, 'images/flags/pe.png', 'PE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (168, 'images/flags/pf.png', 'PF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (169, 'images/flags/pg.png', 'PG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (170, 'images/flags/ph.png', 'PH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (171, 'images/flags/pk.png', 'PK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (172, 'images/flags/pl.png', 'PL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (173, 'images/flags/pm.png', 'PM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (174, 'images/flags/pn.png', 'PN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (175, 'images/flags/pr.png', 'PR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (176, 'images/flags/ps.png', 'PS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (177, 'images/flags/pt.png', 'PT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (178, 'images/flags/pw.png', 'PW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (179, 'images/flags/py.png', 'PY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (180, 'images/flags/qa.png', 'QA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (181, 'images/flags/re.png', 'RE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (182, 'images/flags/ro.png', 'RO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (183, 'images/flags/rs.png', 'RS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (184, 'images/flags/ru.png', 'RU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (185, 'images/flags/rw.png', 'RW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (186, 'images/flags/sa.png', 'SA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (187, 'images/flags/sb.png', 'SB', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (188, 'images/flags/sc.png', 'SC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (189, 'images/flags/sd.png', 'SD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (190, 'images/flags/se.png', 'SE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (191, 'images/flags/sg.png', 'SG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (192, 'images/flags/sh.png', 'SH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (193, 'images/flags/si.png', 'SI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (194, 'images/flags/sj.png', 'SJ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (195, 'images/flags/sk.png', 'SK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (196, 'images/flags/sl.png', 'SL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (197, 'images/flags/sm.png', 'SM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (198, 'images/flags/sn.png', 'SN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (199, 'images/flags/so.png', 'SO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (200, 'images/flags/sr.png', 'SR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (201, 'images/flags/st.png', 'ST', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (202, 'images/flags/sv.png', 'SV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (203, 'images/flags/sy.png', 'SY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (204, 'images/flags/sz.png', 'SZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (205, 'images/flags/tc.png', 'TC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (206, 'images/flags/td.png', 'TD', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (207, 'images/flags/tf.png', 'TF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (208, 'images/flags/tg.png', 'TG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (209, 'images/flags/th.png', 'TH', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (210, 'images/flags/tj.png', 'TJ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (211, 'images/flags/tk.png', 'TK', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (212, 'images/flags/tl.png', 'TL', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (213, 'images/flags/tm.png', 'TM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (214, 'images/flags/tn.png', 'TN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (215, 'images/flags/to.png', 'TO', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (216, 'images/flags/tr.png', 'TR', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (217, 'images/flags/tt.png', 'TT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (218, 'images/flags/tv.png', 'TV', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (219, 'images/flags/tw.png', 'TW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (220, 'images/flags/tz.png', 'TZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (221, 'images/flags/ua.png', 'UA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (222, 'images/flags/us.png', 'US', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (223, 'images/flags/ug.png', 'UG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (224, 'images/flags/um.png', 'UM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (225, 'images/flags/uy.png', 'UY', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (226, 'images/flags/uz.png', 'UZ', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (227, 'images/flags/va.png', 'VA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (228, 'images/flags/vc.png', 'VC', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (229, 'images/flags/ve.png', 'VE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (230, 'images/flags/vg.png', 'VG', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (231, 'images/flags/vi.png', 'VI', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (232, 'images/flags/vn.png', 'VN', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (233, 'images/flags/vu.png', 'VU', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (234, 'images/flags/wf.png', 'WF', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (235, 'images/flags/ws.png', 'WS', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (236, 'images/flags/ye.png', 'YE', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (237, 'images/flags/yt.png', 'YT', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (238, 'images/flags/za.png', 'ZA', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (239, 'images/flags/zm.png', 'ZM', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (240, 'images/flags/zw.png', 'ZW', '2025-05-31 05:10:08', '2025-05-31 05:10:08'); -- -------------------------------------------------------- -- -- Table structure for table `fund_transfers` -- CREATE TABLE `fund_transfers` ( `id` bigint(20) UNSIGNED NOT NULL, `from_account_id` bigint(20) UNSIGNED DEFAULT NULL, `to_account_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date DEFAULT NULL, `note` text DEFAULT NULL, `amount` decimal(8,2) NOT NULL DEFAULT 0.00, `date_time` datetime DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1 COMMENT '0=pending, 1=accept, 2=decline', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `govt_vats` -- CREATE TABLE `govt_vats` ( `id` bigint(20) UNSIGNED NOT NULL, `source` varchar(191) DEFAULT NULL COMMENT 'I will use it to make the description more meaningful', `date` date DEFAULT NULL, `details` text DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'income/credit, expense/debit', `amount` decimal(8,2) DEFAULT NULL, `parcel_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 `images` -- CREATE TABLE `images` ( `id` bigint(20) UNSIGNED NOT NULL, `original_image` varchar(191) DEFAULT NULL, `image_small_one` varchar(191) DEFAULT NULL COMMENT '32x32', `image_small_two` varchar(191) DEFAULT NULL COMMENT '40x40', `image_small_three` varchar(191) DEFAULT NULL COMMENT '80X80', `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 `images` -- INSERT INTO `images` (`id`, `original_image`, `image_small_one`, `image_small_two`, `image_small_three`, `created_at`, `updated_at`) VALUES (2, 'admin/profile-images/20231116095840_original_23.PNG', 'admin/profile-images/20231116095840image_small_one28.PNG', 'admin/profile-images/20231116095840image_small_two23.PNG', 'admin/profile-images/20231116095840image_small_three18.PNG', '2023-11-16 03:58:41', '2023-11-16 03:58:41'), (3, 'admin/profile-images/20231213111031_original_29.PNG', 'admin/profile-images/20231213111031image_small_one8.PNG', 'admin/profile-images/20231213111031image_small_two16.PNG', 'admin/profile-images/20231213111031image_small_three34.PNG', '2023-11-16 04:29:56', '2023-12-13 05:10:31'), (5, 'admin/profile-images/20240122111426_original_4.png', 'admin/profile-images/20240122111426image_small_one3.png', 'admin/profile-images/20240122111426image_small_two10.png', 'admin/profile-images/20240122111426image_small_three20.png', '2023-12-19 11:27:10', '2024-01-22 05:14:26'), (6, 'admin/profile-images/20231220120438_original_47.PNG', 'admin/profile-images/20231220120438image_small_one3.PNG', 'admin/profile-images/20231220120438image_small_two26.PNG', 'admin/profile-images/20231220120438image_small_three11.PNG', '2023-12-20 06:04:39', '2023-12-20 06:04:39'), (7, 'admin/profile-images/20231220122159_original_36.PNG', 'admin/profile-images/20231220122159image_small_one36.PNG', 'admin/profile-images/20231220122159image_small_two24.PNG', 'admin/profile-images/20231220122159image_small_three23.PNG', '2023-12-20 06:22:00', '2023-12-20 06:22:00'), (8, 'admin/profile-images/20240102151627_original_18.png', 'admin/profile-images/20240102151627image_small_one43.png', 'admin/profile-images/20240102151627image_small_two10.png', 'admin/profile-images/20240102151627image_small_three29.png', '2023-12-20 07:12:25', '2024-01-02 09:16:27'), (9, 'admin/profile-images/20231221104812_original_21.PNG', 'admin/profile-images/20231221104812image_small_one17.PNG', 'admin/profile-images/20231221104812image_small_two31.PNG', 'admin/profile-images/20231221104812image_small_three31.PNG', '2023-12-21 04:48:13', '2023-12-21 04:48:13'), (10, 'admin/profile-images/20231221105952_original_17.PNG', 'admin/profile-images/20231221105952image_small_one22.PNG', 'admin/profile-images/20231221105952image_small_two1.PNG', 'admin/profile-images/20231221105952image_small_three34.PNG', '2023-12-21 04:59:53', '2023-12-21 04:59:53'), (11, 'admin/profile-images/20231221111244_original_7.PNG', 'admin/profile-images/20231221111244image_small_one14.PNG', 'admin/profile-images/20231221111244image_small_two25.PNG', 'admin/profile-images/20231221111244image_small_three16.PNG', '2023-12-21 05:12:44', '2023-12-21 05:12:44'), (12, 'admin/profile-images/20231224171337_original_42.jpg', 'admin/profile-images/20231224171337image_small_one2.jpg', 'admin/profile-images/20231224171337image_small_two10.jpg', 'admin/profile-images/20231224171337image_small_three43.jpg', '2023-12-24 11:13:38', '2023-12-24 11:13:38'), (13, 'admin/profile-images/20231224172059_original_30.jpg', 'admin/profile-images/20231224172059image_small_one35.jpg', 'admin/profile-images/20231224172059image_small_two9.jpg', 'admin/profile-images/20231224172059image_small_three45.jpg', '2023-12-24 11:21:00', '2023-12-24 11:21:00'), (14, 'admin/profile-images/20231226111227_original_42.jpg', 'admin/profile-images/20231226111227image_small_one33.jpg', 'admin/profile-images/20231226111227image_small_two14.jpg', 'admin/profile-images/20231226111227image_small_three5.jpg', '2023-12-26 05:12:27', '2023-12-26 05:12:27'), (15, 'admin/profile-images/20240101182823_original_28.png', 'admin/profile-images/20240101182823image_small_one8.png', 'admin/profile-images/20240101182823image_small_two5.png', 'admin/profile-images/20240101182823image_small_three30.png', '2024-01-01 12:28:23', '2024-01-01 12:28:23'), (16, 'admin/profile-images/20240102150946_original_26.png', 'admin/profile-images/20240102150946image_small_one39.png', 'admin/profile-images/20240102150946image_small_two43.png', 'admin/profile-images/20240102150946image_small_three49.png', '2024-01-02 09:09:47', '2024-01-02 09:09:47'), (17, 'admin/profile-images/20240102151822_original_18.png', 'admin/profile-images/20240102151822image_small_one22.png', 'admin/profile-images/20240102151822image_small_two22.png', 'admin/profile-images/20240102151822image_small_three29.png', '2024-01-02 09:18:22', '2024-01-02 09:18:22'), (18, 'admin/profile-images/20240110173312_original_9.png', 'admin/profile-images/20240110173312image_small_one14.png', 'admin/profile-images/20240110173312image_small_two28.png', 'admin/profile-images/20240110173312image_small_three46.png', '2024-01-10 11:33:12', '2024-01-10 11:33:12'), (19, 'admin/profile-images/20240110182712_original_12.png', 'admin/profile-images/20240110182712image_small_one29.png', 'admin/profile-images/20240110182712image_small_two15.png', 'admin/profile-images/20240110182712image_small_three16.png', '2024-01-10 12:27:12', '2024-01-10 12:27:12'), (20, 'admin/profile-images/20240111152120_original_22.png', 'admin/profile-images/20240111152120image_small_one7.png', 'admin/profile-images/20240111152120image_small_two49.png', 'admin/profile-images/20240111152120image_small_three14.png', '2024-01-11 09:21:21', '2024-01-11 09:21:21'), (21, 'admin/profile-images/20240115144908_original_20.png', 'admin/profile-images/20240115144908image_small_one14.png', 'admin/profile-images/20240115144908image_small_two6.png', 'admin/profile-images/20240115144908image_small_three13.png', '2024-01-13 09:21:41', '2024-01-15 08:49:09'), (22, 'admin/profile-images/20240118173933_original_20.png', 'admin/profile-images/20240118173933image_small_one18.png', 'admin/profile-images/20240118173933image_small_two4.png', 'admin/profile-images/20240118173933image_small_three46.png', '2024-01-14 09:48:39', '2024-01-18 11:39:33'), (23, 'admin/profile-images/20240117102509_original_35.png', 'admin/profile-images/20240117102509image_small_one26.png', 'admin/profile-images/20240117102509image_small_two40.png', 'admin/profile-images/20240117102509image_small_three23.png', '2024-01-17 04:23:13', '2024-01-17 04:25:09'), (24, 'admin/profile-images/20240117115217_original_41.png', 'admin/profile-images/20240117115217image_small_one25.png', 'admin/profile-images/20240117115217image_small_two11.png', 'admin/profile-images/20240117115217image_small_three30.png', '2024-01-17 05:52:18', '2024-01-17 05:52:18'), (25, 'admin/profile-images/20240117143635_original_38.png', 'admin/profile-images/20240117143635image_small_one12.png', 'admin/profile-images/20240117143635image_small_two9.png', 'admin/profile-images/20240117143635image_small_three44.png', '2024-01-17 08:36:36', '2024-01-17 08:36:36'), (26, 'admin/profile-images/20240117155755_original_30.png', 'admin/profile-images/20240117155755image_small_one41.png', 'admin/profile-images/20240117155755image_small_two28.png', 'admin/profile-images/20240117155755image_small_three18.png', '2024-01-17 09:57:55', '2024-01-17 09:57:55'), (28, 'admin/profile-images/20240118155853_original_11.png', 'admin/profile-images/20240118155853image_small_one40.png', 'admin/profile-images/20240118155853image_small_two6.png', 'admin/profile-images/20240118155853image_small_three30.png', '2024-01-18 09:58:54', '2024-01-18 09:58:54'), (29, 'admin/profile-images/20240118160238_original_29.png', 'admin/profile-images/20240118160238image_small_one14.png', 'admin/profile-images/20240118160238image_small_two7.png', 'admin/profile-images/20240118160238image_small_three50.png', '2024-01-18 10:02:39', '2024-01-18 10:02:39'), (30, 'admin/profile-images/20240118163508_original_22.png', 'admin/profile-images/20240118163508image_small_one47.png', 'admin/profile-images/20240118163508image_small_two49.png', 'admin/profile-images/20240118163508image_small_three26.png', '2024-01-18 10:35:08', '2024-01-18 10:35:08'), (31, 'admin/profile-images/20240118182203_original_34.png', 'admin/profile-images/20240118182203image_small_one19.png', 'admin/profile-images/20240118182203image_small_two40.png', 'admin/profile-images/20240118182203image_small_three36.png', '2024-01-18 11:12:02', '2024-01-18 12:22:04'); -- -------------------------------------------------------- -- -- Table structure for table `languages` -- CREATE TABLE `languages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `locale` varchar(30) NOT NULL, `flag` varchar(50) DEFAULT NULL, `text_direction` varchar(30) DEFAULT 'ltr', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `languages` -- INSERT INTO `languages` (`id`, `name`, `locale`, `flag`, `text_direction`, `status`, `created_at`, `updated_at`) VALUES (1, 'English', 'en', 'images/flags/us.png', 'ltr', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'), (2, 'Bengali', 'bn', 'images/flags/bd.png', 'ltr', 'active', '2025-05-31 05:10:08', '2025-05-31 05:10:08'); -- -------------------------------------------------------- -- -- Table structure for table `language_configs` -- CREATE TABLE `language_configs` ( `id` bigint(20) UNSIGNED NOT NULL, `language_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `script` varchar(191) DEFAULT NULL, `native` varchar(191) DEFAULT NULL, `regional` 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 `log_activities` -- CREATE TABLE `log_activities` ( `id` bigint(20) UNSIGNED NOT NULL, `url` varchar(191) NOT NULL, `method` varchar(191) NOT NULL, `ip` varchar(191) NOT NULL, `browser` varchar(191) DEFAULT NULL, `platform` varchar(191) DEFAULT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `log_activities` -- INSERT INTO `log_activities` (`id`, `url`, `method`, `ip`, `browser`, `platform`, `user_id`, `created_at`, `updated_at`) VALUES (1, 'https://dev1.savadata.top/login', 'POST', '14.226.94.180', 'Google Chrome', 'mac', 1, '2025-05-31 05:10:23', '2025-05-31 05:10:23'); -- -------------------------------------------------------- -- -- Table structure for table `merchants` -- CREATE TABLE `merchants` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `company` varchar(191) NOT NULL, `api_key` varchar(191) DEFAULT NULL, `secret_key` varchar(191) DEFAULT NULL, `vat` varchar(191) DEFAULT NULL, `phone_number` varchar(191) NOT NULL, `city` varchar(191) DEFAULT NULL, `zip` varchar(191) DEFAULT NULL, `address` text DEFAULT NULL, `website` varchar(191) DEFAULT NULL, `billing_street` varchar(191) DEFAULT NULL, `billing_city` varchar(191) DEFAULT NULL, `billing_zip` varchar(191) DEFAULT NULL, `registration_confirmed` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'true confirmed, false not confirmed', `trade_license` text DEFAULT NULL, `nid` text DEFAULT NULL, `balance` decimal(8,2) NOT NULL DEFAULT 0.00, `key_account_id` int(11) DEFAULT NULL, `sales_agent_id` int(11) DEFAULT NULL, `mig_done` int(11) NOT NULL DEFAULT 0, `withdraw` enum('daily','weekly','monthly') NOT NULL DEFAULT 'monthly', `charges` longtext DEFAULT NULL, `cod_charges` longtext DEFAULT NULL, `default_account_id` bigint(20) UNSIGNED DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `merchant_accounts` -- CREATE TABLE `merchant_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `source` varchar(191) DEFAULT NULL, `merchant_withdraw_id` bigint(20) UNSIGNED DEFAULT NULL, `payment_withdraw_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'withdraw_id on which this amount got calculated', `is_paid` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'true for payment completed', `parcel_withdraw_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'withdraw_id upon which this parcel got reverse', `details` text DEFAULT NULL, `date` date DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'income/credit, expense/debit', `amount` decimal(8,2) DEFAULT NULL COMMENT 'positive and negative amount define by type', `balance` decimal(8,2) DEFAULT NULL COMMENT 'grand balance', `merchant_id` bigint(20) UNSIGNED DEFAULT NULL, `parcel_id` bigint(20) UNSIGNED DEFAULT NULL, `company_account_id` bigint(20) UNSIGNED DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `merchant_payment_accounts` -- CREATE TABLE `merchant_payment_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `merchant_id` bigint(20) UNSIGNED NOT NULL, `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL, `selected_bank` varchar(191) DEFAULT NULL COMMENT 'for bank account', `bank_branch` varchar(50) DEFAULT NULL COMMENT 'selected bank branch name', `bank_ac_name` varchar(50) DEFAULT NULL COMMENT 'bank account owner name', `bank_ac_number` varchar(50) DEFAULT NULL COMMENT 'bank account number', `routing_no` varchar(50) DEFAULT NULL COMMENT 'bank routing number', `mfs_number` varchar(20) DEFAULT NULL COMMENT 'mfs account number', `mfs_ac_type` enum('personal','merchant') DEFAULT NULL COMMENT 'mfs account type', `type` enum('mfs','bank','cash') NOT NULL DEFAULT 'cash', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `merchant_withdraws` -- CREATE TABLE `merchant_withdraws` ( `id` bigint(20) UNSIGNED NOT NULL, `withdraw_id` varchar(191) DEFAULT NULL COMMENT 'auto generated 10-digit id', `merchant_id` bigint(20) UNSIGNED NOT NULL, `withdraw_batch_id` bigint(20) UNSIGNED DEFAULT NULL, `payment_method_type` enum('bank','mfs','cash') NOT NULL DEFAULT 'bank', `withdraw_to` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'in which account type gets withdraw-- merchant_payment_accounts', `note` text DEFAULT NULL, `amount` decimal(8,2) DEFAULT NULL, `status` varchar(191) NOT NULL DEFAULT 'pending' COMMENT 'pending, approved, processed, rejected', `account_details` text NOT NULL COMMENT 'account in which merchant withdraws his money', `date` date DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `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_01_01_082754_create_images_table', 1), (2, '2014_01_02_112613_create_timezones_table', 1), (3, '2014_07_02_230147_migration_cartalyst_sentinel', 1), (4, '2014_10_12_100000_create_password_resets_table', 1), (5, '2019_08_19_000000_create_failed_jobs_table', 1), (6, '2021_02_15_112814_create_permissions_table', 1), (7, '2021_02_22_064136_create_merchants_table', 1), (8, '2021_02_24_095151_create_log_activities_table', 1), (9, '2021_02_25_104523_create_delivery_men_table', 1), (10, '2021_02_28_152737_create_payment_methods_table', 1), (11, '2021_02_28_152738_create_merchant_payment_accounts_table', 1), (12, '2021_02_29_162415_create_branches_table', 1), (13, '2021_03_01_113001_create_merchant_withdraws_table', 1), (14, '2021_03_01_121214_create_third_parties_table', 1), (15, '2021_03_01_173643_create_shops_table', 1), (16, '2021_03_01_173644_create_parcels_table', 1), (17, '2021_03_01_173645_create_parcel_events_table', 1), (18, '2021_03_01_194058_create_charges_table', 1), (19, '2021_03_01_194154_create_cod_charges_table', 1), (20, '2021_03_04_094654_create_temp_stores_table', 1), (21, '2021_03_06_104329_create_accounts_table', 1), (22, '2021_03_07_113033_create_company_accounts_table', 1), (23, '2021_03_08_112706_create_merchant_accounts_table', 1), (24, '2021_03_08_112756_create_delivery_man_accounts_table', 1), (25, '2021_03_08_112836_create_govt_vats_table', 1), (26, '2021_03_24_173539_create_sms_templates_table', 1), (27, '2021_04_10_190444_create_fund_transfers_table', 1), (28, '2021_04_11_173936_create_customer_parcel_sms_templates_table', 1), (29, '2021_04_11_174654_create_withdraw_sms_templates_table', 1), (30, '2021_04_20_145625_create_staff_accounts_table', 1), (31, '2021_07_17_124901_create_settings_table', 1), (32, '2021_07_28_120542_create_package_and_charges_table', 1), (33, '2021_07_31_231110_create_preferences_table', 1), (34, '2021_08_02_112610_create_notices_table', 1), (35, '2021_12_02_165943_create_withdraw_batches_table', 1), (36, '2021_12_12_162724_create_district_zilas_table', 1), (37, '2023_01_29_051134_create_languages_table', 1), (38, '2023_01_29_052118_create_email_templates_table', 1), (39, '2023_02_02_111008_create_api_keys_table', 1), (40, '2023_02_02_111527_create_api_key_languages_table', 1), (41, '2023_02_02_111739_create_countries_table', 1), (42, '2023_02_12_040457_create_pages_table', 1), (43, '2023_02_12_042334_create_page_languages_table', 1), (44, '2023_03_02_113712_create_flag_icons_table', 1), (45, '2023_03_11_034029_create_testimonial_languages_table', 1), (46, '2023_03_19_091107_create_language_configs_table', 1), (47, '2024_02_07_161309_create_notifications_table', 1), (48, '2024_02_08_160137_create_notification_users_table', 1), (49, '2024_02_22_100729_create_website_partner_logos_table', 1), (50, '2024_02_22_100749_create_website_testimonials_table', 1), (51, '2024_04_21_132648_create_website_news_and_events_table', 1), (52, '2024_04_21_132707_create_website_news_and_event_languages_table', 1), (53, '2024_04_21_135802_create_website_abouts_table', 1), (54, '2024_04_21_135812_create_website_about_languages_table', 1), (55, '2024_04_21_140240_create_website_features_table', 1), (56, '2024_04_21_140250_create_website_feature_languages_table', 1), (57, '2024_04_22_141838_create_website_statistics_table', 1), (58, '2024_04_22_141851_create_website_statistic_languages_table', 1), (59, '2024_04_22_142249_create_website_services_table', 1), (60, '2024_04_22_142300_create_website_service_languages_table', 1), (61, '2024_05_28_054116_create_contacts_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `notices` -- CREATE TABLE `notices` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `details` text NOT NULL, `start_time` datetime NOT NULL, `end_time` datetime NOT NULL, `staff` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `merchant` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `alert_class` varchar(191) NOT NULL DEFAULT 'alert-warning', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `notifications` -- CREATE TABLE `notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) DEFAULT NULL, `description` text DEFAULT NULL, `url` varchar(191) DEFAULT NULL, `user_id` bigint(20) UNSIGNED 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 `notification_users` -- CREATE TABLE `notification_users` ( `id` bigint(20) UNSIGNED NOT NULL, `notification_id` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `is_read` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=read, 0=unread', `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 `package_and_charges` -- CREATE TABLE `package_and_charges` ( `id` bigint(20) UNSIGNED NOT NULL, `package_type` varchar(191) DEFAULT NULL, `charge` decimal(8,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `package_and_charges` -- INSERT INTO `package_and_charges` (`id`, `package_type`, `charge`, `created_at`, `updated_at`) VALUES (1, 'Poly', 5.00, '2021-07-29 05:29:16', '2021-07-29 05:29:16'), (2, 'Bubble Poly', 10.00, '2021-07-29 05:29:16', '2021-07-29 05:29:16'), (3, 'Box', 15.00, '2021-07-29 05:29:16', '2021-07-29 05:29:16'), (4, 'Box Poly', 20.00, '2021-07-29 05:29:16', '2021-07-29 05:29:16'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `content` text DEFAULT NULL, `type` varchar(100) DEFAULT NULL, `link` varchar(191) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `meta_title` varchar(191) DEFAULT NULL, `meta_keywords` varchar(191) DEFAULT NULL, `meta_description` text DEFAULT NULL, `meta_image_id` bigint(20) UNSIGNED DEFAULT NULL, `meta_image` text DEFAULT NULL, `status` tinyint(4) 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 `page_languages` -- CREATE TABLE `page_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `page_id` bigint(20) UNSIGNED DEFAULT NULL, `lang` varchar(50) DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `content` text DEFAULT NULL, `meta_title` varchar(191) DEFAULT NULL, `meta_keywords` varchar(191) DEFAULT NULL, `meta_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 `parcels` -- CREATE TABLE `parcels` ( `id` bigint(20) UNSIGNED NOT NULL, `parcel_no` varchar(50) NOT NULL COMMENT 'used for each merchant invoice tracking', `tracking_number` varchar(50) NOT NULL COMMENT 'used for paperfly parcel tracking', `short_url` varchar(50) NOT NULL COMMENT 'short-link for tracking', `packaging` varchar(191) NOT NULL DEFAULT 'no' COMMENT '1 yes, 0 no', `packaging_charge` decimal(8,2) DEFAULT NULL COMMENT 'recorded for future reference', `fragile` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'recorded for previous reference', `fragile_charge` decimal(8,2) DEFAULT NULL COMMENT 'recorded for future reference', `open_box` varchar(191) NOT NULL DEFAULT 'no' COMMENT '1 yes, 0 no', `home_delivery` varchar(191) NOT NULL DEFAULT 'no' COMMENT '1 yes, 0 no', `parcel_type` varchar(191) DEFAULT NULL COMMENT 'parcel type or parcel service', `weight` varchar(191) DEFAULT NULL, `charge` decimal(8,2) DEFAULT NULL COMMENT 'weight delivery charge from merchant table', `cod_charge` decimal(8,2) DEFAULT NULL COMMENT 'COD charge direct from merchant table', `vat` decimal(8,2) DEFAULT NULL COMMENT 'customer wise vat from merchant table', `location` varchar(191) DEFAULT NULL COMMENT 'for future reference', `total_delivery_charge` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'vat + cod + delivery charge', `payable` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'total payable to Merchant', `return_charge` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'parcel return charge if get returned', `price` decimal(8,2) NOT NULL DEFAULT 0.00, `merchant_id` bigint(20) UNSIGNED NOT NULL, `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `pickup_man_id` bigint(20) UNSIGNED DEFAULT NULL, `return_delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `transfer_delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `branch_id` bigint(20) UNSIGNED DEFAULT NULL, `pickup_branch_id` bigint(20) UNSIGNED DEFAULT NULL, `transfer_to_branch_id` bigint(20) UNSIGNED DEFAULT NULL, `third_party_id` bigint(20) UNSIGNED DEFAULT NULL, `shop_id` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'created by', `delivery_fee` decimal(8,2) NOT NULL DEFAULT 0.00, `pickup_fee` decimal(8,2) NOT NULL DEFAULT 0.00, `return_fee` decimal(8,2) NOT NULL DEFAULT 0.00, `customer_name` varchar(100) NOT NULL, `customer_invoice_no` varchar(50) NOT NULL, `customer_phone_number` varchar(30) NOT NULL, `customer_address` text NOT NULL, `pickup_date` date DEFAULT NULL, `pickup_time` time DEFAULT NULL, `delivery_date` date DEFAULT NULL, `delivery_time` time DEFAULT NULL, `date` date DEFAULT NULL COMMENT 'date added to get specific date data on where clause', `pickup_shop_phone_number` varchar(191) DEFAULT NULL, `pickup_address` text DEFAULT NULL, `note` varchar(191) DEFAULT NULL, `status` enum('pending','pickup-assigned','re-schedule-pickup','received-by-pickup-man','received','transferred-to-branch','transferred-received-by-branch','delivery-assigned','re-schedule-delivery','returned-to-warehouse','return-assigned-to-merchant','partially-delivered','delivered','returned-to-merchant','re-request','cancel','deleted') NOT NULL DEFAULT 'pending' COMMENT 'current status of parcel, re-request for after cancel by staff the merchant can re request parcel.', `status_before_cancel` varchar(191) DEFAULT NULL COMMENT 'status before cancel the parcel, it will use when re-request parcel', `is_partially_delivered` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'true for partially delivered', `price_before_delivery` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'parcel price before partially delivered', `otp` int(11) DEFAULT NULL COMMENT 'to verify parcel successfully delivered to customer', `selling_price` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'parcel actual price for damage of parcel money return purpose', `withdraw_id` bigint(20) UNSIGNED DEFAULT NULL, `is_paid` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'true for payment completed', `merchant_otp` int(11) DEFAULT NULL, `delivered_date` datetime DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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_events` -- CREATE TABLE `parcel_events` ( `id` bigint(20) UNSIGNED NOT NULL, `parcel_id` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'created by', `delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `pickup_man_id` bigint(20) UNSIGNED DEFAULT NULL, `return_delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `transfer_delivery_man_id` bigint(20) UNSIGNED DEFAULT NULL, `branch_id` bigint(20) UNSIGNED DEFAULT NULL, `third_party_id` bigint(20) UNSIGNED DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `reverse_status` varchar(191) DEFAULT NULL COMMENT 'if reversed than it will be set as reversed', `cancel_note` text DEFAULT NULL COMMENT 'events note', `additional_info` longtext DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `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 `payment_methods` -- CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `type` enum('bank','mfs','cash') NOT NULL DEFAULT 'bank', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `image` text DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `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, 'users', '{\"read\":\"user_read\",\"create\":\"user_create\",\"update\":\"user_update\",\"delete\":\"user_delete\",\"account_activity_read\":\"user_account_activity_read\",\"payment_logs_read\":\"user_payment_logs_read\",\"logout_from_devices\":\"user_logout_from_devices\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (2, 'roles', '{\"read\":\"role_read\",\"create\":\"role_create\",\"update\":\"role_update\",\"delete\":\"role_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (3, 'permissions', '{\"read\":\"permission_read\",\"create\":\"permission_create\",\"update\":\"permission_update\",\"delete\":\"permission_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (4, 'merchant', '{\"read\":\"merchant_read\",\"read_all\":\"read_all_merchant\",\"use_all\":\"use_all_merchant\",\"create\":\"merchant_create\",\"update\":\"merchant_update\",\"delete\":\"merchant_delete\",\"shop_read\":\"merchant_shop_read\",\"shop_create\":\"merchant_shop_create\",\"shop_delete\":\"merchant_shop_delete\",\"shop_update\":\"merchant_shop_update\",\"staff_read\":\"merchant_staff_read\",\"staff_create\":\"merchant_staff_create\",\"staff_update\":\"merchant_staff_update\",\"payment_account_read\":\"merchant_payment_account_read\",\"payment_account_update\":\"merchant_payment_account_update\",\"account_activity_read\":\"merchant_account_activity_read\",\"cod_charge_read\":\"merchant_cod_charge_read\",\"charge_read\":\"merchant_charge_read\",\"payment_logs_read\":\"merchant_payment_logs_read\",\"api_credentials_read\":\"merchant_api_credentials_read\",\"api_credentials_update\":\"merchant_api_credentials_update\",\"download_closing_report\":\"download_closing_report\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (5, 'delivery_man', '{\"read\":\"deliveryman_read\",\"read_all\":\"read_all_delivery_man\",\"use_all\":\"use_all_delivery_man\",\"create\":\"deliveryman_create\",\"update\":\"deliveryman_update\",\"delete\":\"deliveryman_delete\",\"account_activity_read\":\"deliveryman_account_activity_read\",\"payment_logs_read\":\"deliveryman_payment_logs_read\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (6, 'parcel', '{\"read\":\"parcel_read\",\"read_all\":\"read_all_parcel\",\"create\":\"parcel_create\",\"update\":\"parcel_update\",\"delete\":\"parcel_delete\",\"pickup_assigned\":\"parcel_pickup_assigned\",\"reschedule_pickup\":\"parcel_reschedule_pickup\",\"received_by_pickup_man\":\"parcel_received_by_pickup_man\",\"received_to_warehouse\":\"parcel_received\",\"transfer_to_branch\":\"parcel_transfer_to_branch\",\"transfer_receive_to_branch\":\"parcel_transfer_receive_to_branch\",\"delivery_assigned\":\"parcel_delivery_assigned\",\"reschedule_delivery\":\"parcel_reschedule_delivery\",\"returned_to_warehouse\":\"parcel_returned_to_warehouse\",\"return_assigned_to_merchant\":\"parcel_return_assigned_to_merchant\",\"delivered\":\"parcel_delivered\",\"delivery_backward\":\"parcel_backward\",\"returned_to_merchant\":\"parcel_returned_to_merchant\",\"cancel\":\"parcel_cancel\",\"send_to_paperfly\":\"send_to_paperfly\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (7, 'income', '{\"read\":\"income_read\",\"read_all\":\"read_all_income\",\"create\":\"income_create\",\"update\":\"income_update\",\"delete\":\"income_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (8, 'expense', '{\"read\":\"expense_read\",\"read_all\":\"read_all_expense\",\"create\":\"expense_create\",\"update\":\"expense_update\",\"delete\":\"expense_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (9, 'withdraw', '{\"read\":\"withdraw_read\",\"read_all\":\"read_all_withdraw\",\"create\":\"withdraw_create\",\"update\":\"withdraw_update\",\"process\":\"withdraw_process\",\"reject\":\"withdraw_reject\",\"add_to_bulk_withdraw\":\"add_to_bulk_withdraw\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (10, 'bulk_withdraw', '{\"read\":\"bulk_withdraw_read\",\"read_all\":\"read_all_bulk_withdraw\",\"create\":\"bulk_withdraw_create\",\"update\":\"bulk_withdraw_update\",\"process\":\"bulk_withdraw_process\",\"download_payment_sheet\":\"download_payment_sheet\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (11, 'sms_setting', '{\"read\":\"sms_setting_read\",\"update\":\"sms_setting_update\",\"send_bulk_sms\":\"sms_campaign_message_send\",\"send_sms\":\"custom_sms_send\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (12, 'report', '{\"read\":\"report_read\",\"transaction_history_read\":\"transaction_history_read\",\"parcels_summary_read\":\"parcels_summary_read\",\"total_summary_read\":\"total_summary_read\",\"income_expense_report_read\":\"income_expense_report_read\",\"profit_summary_report_read\":\"profit_summary_report_read\",\"merchant_summary_report_read\":\"merchant_summary_report_read\",\"dashboard_statistics_read\":\"dashboard_statistics_read\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (13, 'account', '{\"read\":\"account_read\",\"read_all\":\"read_all_account\",\"create\":\"account_create\",\"update\":\"account_update\",\"statement\":\"account_statement\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (14, 'fund_transfer', '{\"read\":\"fund_transfer_read\",\"read_all\":\"read_all_fund_transfer\",\"create\":\"fund_transfer_create\",\"update\":\"fund_transfer_update\",\"delete\":\"fund_transfer_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (15, 'branch', '{\"read\":\"branch_read\",\"create\":\"branch_create\",\"update\":\"branch_update\",\"delete\":\"branch_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (16, 'third_party', '{\"read\":\"third_party_read\",\"create\":\"third_party_create\",\"update\":\"third_party_update\",\"delete\":\"third_party_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (17, 'notice', '{\"read\":\"notice_read\",\"create\":\"notice_create\",\"update\":\"notice_update\",\"delete\":\"notice_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (18, 'settings', '{\"read\":\"settings_read\",\"sms_settings_update\":\"sms_settings_update\",\"charge_update\":\"charge_setting_update\",\"pickup_and_delivery_time_update\":\"pickup_and_delivery_time_setting_update\",\"preference_update\":\"preference_setting_update\",\"panel_setting\":\"panel_setting\",\"preference\":\"preference\",\"payment_method\":\"payment_method\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (19, 'email_template', '{\"read\":\"email_template_read\",\"create\":\"email_template_create\",\"update\":\"email_template_update\",\"delete\":\"email_template_delete\",\"server_configuration_update\":\"server_configuration_update\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (20, 'currency', '{\"read\":\"currency_read\",\"create\":\"currency_create\",\"update\":\"currency_update\",\"delete\":\"currency_delete\",\"0\":\"default_currency\",\"1\":\"currency_format\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (21, 'country', '{\"read\":\"country_read\",\"create\":\"country_create\",\"update\":\"country_update\",\"delete\":\"country_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (22, 'utility', '{\"read\":\"server_info\",\"update\":\"system_update\",\"extension_library\":\"extension_library\",\"filesystem\":\"filesystem\",\"system_info\":\"system_info\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (23, 'payment_method', '{\"read\":\"payment_method_read\",\"create\":\"payment_method_create\",\"update\":\"payment_method_update\",\"delete\":\"payment_method_delete\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (24, 'apikeys', '{\"view\":\"apikeys.index\",\"create\":\"apikeys.create\",\"edit\":\"apikeys.edit\",\"revoke\":\"apikeys.revoke\",\"delete\":\"apikeys.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (25, 'website setting', '{\"website_themes\":\"website.themes\",\"website_menu\":\"website.menu\",\"section_title\":\"section.title\",\"hero_section\":\"hero.section\",\"price_section\":\"price.section\",\"contact_section\":\"contact.section\",\"call_to_action\":\"website.cta\",\"footer_content\":\"footer.content\",\"website_seo\":\"website_setting.seo\",\"custom_js\":\"website_setting.custom_js\",\"custom_css\":\"website_setting.custom_css\",\"google_setup\":\"website_setting.google_setup\",\"facebook_pixel\":\"website_setting.fb_pixel\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (26, 'partner_logo', '{\"view\":\"partner_logo.index\",\"create\":\"partner_logo.create\",\"edit\":\"partner_logo.edit\",\"delete\":\"partner_logo.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (27, 'news_and_event', '{\"view\":\"news_and_event.index\",\"create\":\"news_and_event.create\",\"edit\":\"news_and_event.edit\",\"delete\":\"news_and_event.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (28, 'about', '{\"view\":\"about.index\",\"create\":\"about.create\",\"edit\":\"about.edit\",\"delete\":\"about.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (29, 'service', '{\"view\":\"service.index\",\"create\":\"service.create\",\"edit\":\"service.edit\",\"delete\":\"service.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (30, 'feature', '{\"view\":\"feature.index\",\"create\":\"feature.create\",\"edit\":\"feature.edit\",\"delete\":\"feature.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (31, 'statistic', '{\"view\":\"statistic.index\",\"create\":\"statistic.create\",\"edit\":\"statistic.edit\",\"delete\":\"statistic.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (32, 'testimonial', '{\"view\":\"testimonial.index\",\"create\":\"testimonial.create\",\"edit\":\"testimonial.edit\",\"delete\":\"testimonial.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (33, 'faq', '{\"view\":\"faq.index\",\"create\":\"faq.create\",\"edit\":\"faq.edit\",\"delete\":\"faq.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'), (34, 'pages', '{\"view\":\"pages.index\",\"create\":\"pages.create\",\"edit\":\"pages.edit\",\"delete\":\"pages.destroy\"}', '2025-05-31 05:10:04', '2025-05-31 05:10:04'); -- -------------------------------------------------------- -- -- Table structure for table `persistences` -- CREATE TABLE `persistences` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `code` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `persistences` -- INSERT INTO `persistences` (`id`, `user_id`, `code`, `created_at`, `updated_at`) VALUES (1, 1, '8UDoC1vwezsMSqKuRyQdgy2nH3wSbMtt', '2025-05-31 05:10:23', '2025-05-31 05:10:23'); -- -------------------------------------------------------- -- -- Table structure for table `preferences` -- CREATE TABLE `preferences` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) DEFAULT NULL, `staff` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `merchant` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `preferences` -- INSERT INTO `preferences` (`id`, `title`, `staff`, `merchant`, `created_at`, `updated_at`) VALUES (1, 'read_merchant_api', 1, 1, NULL, NULL), (2, 'merchant_api_update', 1, 1, NULL, NULL), (3, 'create_parcel', 1, 1, NULL, '2021-07-31 17:10:09'), (4, 'create_payment_request', 1, 1, NULL, '2021-07-31 17:10:10'), (5, 'same_day', 1, 1, NULL, '2021-08-13 16:15:13'), (6, 'next_day', 1, 1, NULL, '2021-07-31 17:10:10'), (7, 'sub_city', 1, 1, NULL, '2021-07-31 17:10:10'), (8, 'sub_urban_area', 1, 1, NULL, '2021-07-31 17:10:10'); -- -------------------------------------------------------- -- -- Table structure for table `reminders` -- CREATE TABLE `reminders` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `code` varchar(191) NOT NULL, `completed` tinyint(1) NOT NULL DEFAULT 0, `completed_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 `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `slug` varchar(191) NOT NULL, `name` varchar(191) NOT NULL, `permissions` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `created_at`, `updated_at`, `status`) VALUES (1, 'superadmin', 'Superadmin', '[\"user_create\",\"user_read\",\"user_update\",\"user_delete\",\"user_account_activity_read\",\"user_payment_logs_read\",\"user_logout_from_devices\",\"role_create\",\"role_read\",\"role_update\",\"role_delete\",\"permission_read\",\"permission_create\",\"permission_update\",\"permission_delete\",\"apikeys.index\",\"apikeys.create\",\"apikeys.edit\",\"apikeys.revoke\",\"apikeys.destroy\",\"merchant_create\",\"merchant_read\",\"use_all_merchant\",\"read_all_merchant\",\"merchant_update\",\"merchant_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_delete\",\"merchant_shop_update\",\"merchant_payment_account_read\",\"merchant_payment_account_update\",\"merchant_account_activity_read\",\"merchant_cod_charge_read\",\"merchant_charge_read\",\"merchant_payment_logs_read\",\"merchant_api_credentials_read\",\"merchant_api_credentials_update\",\"merchant_staff_read\",\"merchant_staff_create\",\"merchant_staff_update\",\"download_closing_report\",\"deliveryman_create\",\"deliveryman_read\",\"read_all_delivery_man\",\"use_all_delivery_man\",\"deliveryman_update\",\"deliveryman_delete\",\"deliveryman_account_activity_read\",\"deliveryman_payment_logs_read\",\"parcel_create\",\"parcel_read\",\"parcel_update\",\"parcel_delete\",\"read_all_parcel\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received_by_pickup_man\",\"parcel_received\",\"parcel_transfer_to_branch\",\"parcel_transfer_receive_to_branch\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_backward\",\"parcel_returned_to_merchant\",\"parcel_cancel\",\"parcel_delete\",\"send_to_paperfly\",\"income_create\",\"income_read\",\"read_all_income\",\"income_update\",\"income_delete\",\"expense_create\",\"expense_read\",\"read_all_expense\",\"expense_update\",\"expense_delete\",\"withdraw_read\",\"read_all_withdraw\",\"withdraw_create\",\"withdraw_update\",\"withdraw_process\",\"withdraw_reject\",\"add_to_bulk_withdraw\",\"sms_setting_read\",\"sms_setting_update\",\"sms_campaign_message_send\",\"custom_sms_send\",\"report_read\",\"transaction_history_read\",\"parcels_summary_read\",\"total_summary_read\",\"income_expense_report_read\",\"profit_summary_report_read\",\"merchant_summary_report_read\",\"dashboard_statistics_read\",\"account_read\",\"account_create\",\"account_update\",\"read_all_account\",\"account_statement\",\"fund_transfer_read\",\"read_all_fund_transfer\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"branch_read\",\"branch_create\",\"branch_update\",\"branch_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"server_configuration_update\",\"third_party_read\",\"third_party_create\",\"third_party_update\",\"third_party_delete\",\"language_read\",\"language_create\",\"language_update\",\"language_delete\",\"payment_method_read\",\"payment_method_create\",\"payment_method_update\",\"payment_method_delete\",\"country_read\",\"country_create\",\"country_update\",\"country_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"notice_read\",\"notice_create\",\"notice_update\",\"notice_delete\",\"server_info\",\"system_update\",\"extension_library\",\"filesystem\",\"settings_read\",\"sms_settings_update\",\"charge_setting_update\",\"pickup_and_delivery_time_setting_update\",\"preference_setting_update\",\"panel_setting\",\"preference\",\"payment_method\",\"general_setting\",\"bulk_withdraw_read\",\"read_all_bulk_withdraw\",\"bulk_withdraw_create\",\"bulk_withdraw_update\",\"bulk_withdraw_process\",\"download_payment_sheet\",\"news_and_event.index\",\"news_and_event.create\",\"news_and_event.edit\",\"news_and_event.destroy\",\"about.index\",\"about.create\",\"about.edit\",\"about.destroy\",\"service.index\",\"service.create\",\"service.edit\",\"service.destroy\",\"feature.index\",\"feature.create\",\"feature.edit\",\"feature.destroy\",\"statistic.index\",\"statistic.create\",\"statistic.edit\",\"statistic.destroy\",\"price.section\",\"contact.section\",\"website.themes\",\"website.menu\",\"section.title\",\"hero.section\",\"website.cta\",\"footer.content\",\"website_setting.seo\",\"website_setting.custom_js\",\"website_setting.custom_css\",\"website_setting.google_setup\",\"website_setting.fb_pixel\",\"website_setting.gdpr\",\"partner_logo.index\",\"partner_logo.create\",\"partner_logo.edit\",\"partner_logo.destroy\",\"testimonial.index\",\"testimonial.create\",\"testimonial.edit\",\"testimonial.destroy\",\"faq.index\",\"faq.create\",\"faq.destroy\",\"faq.edit\",\"pages.index\",\"pages.create\",\"pages.edit\",\"pages.destroy\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'), (2, 'admin', 'Admin', '[\"user_create\",\"user_read\",\"user_update\",\"user_delete\",\"user_account_activity_read\",\"user_payment_logs_read\",\"user_logout_from_devices\",\"role_create\",\"role_read\",\"role_update\",\"role_delete\",\"permission_read\",\"permission_create\",\"permission_update\",\"permission_delete\",\"apikeys.index\",\"apikeys.create\",\"apikeys.edit\",\"apikeys.revoke\",\"apikeys.destroy\",\"merchant_create\",\"merchant_read\",\"use_all_merchant\",\"read_all_merchant\",\"merchant_update\",\"merchant_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_delete\",\"merchant_shop_update\",\"merchant_payment_account_read\",\"merchant_payment_account_update\",\"merchant_account_activity_read\",\"merchant_cod_charge_read\",\"merchant_charge_read\",\"merchant_payment_logs_read\",\"merchant_api_credentials_read\",\"merchant_api_credentials_update\",\"merchant_staff_read\",\"merchant_staff_create\",\"merchant_staff_update\",\"download_closing_report\",\"deliveryman_create\",\"deliveryman_read\",\"read_all_delivery_man\",\"use_all_delivery_man\",\"deliveryman_update\",\"deliveryman_delete\",\"deliveryman_account_activity_read\",\"deliveryman_payment_logs_read\",\"parcel_create\",\"parcel_read\",\"parcel_update\",\"parcel_delete\",\"read_all_parcel\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received_by_pickup_man\",\"parcel_received\",\"parcel_transfer_to_branch\",\"parcel_transfer_receive_to_branch\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_backward\",\"parcel_returned_to_merchant\",\"parcel_cancel\",\"parcel_delete\",\"send_to_paperfly\",\"income_create\",\"income_read\",\"read_all_income\",\"income_update\",\"income_delete\",\"expense_create\",\"expense_read\",\"read_all_expense\",\"expense_update\",\"expense_delete\",\"withdraw_read\",\"read_all_withdraw\",\"withdraw_create\",\"withdraw_update\",\"withdraw_process\",\"withdraw_reject\",\"add_to_bulk_withdraw\",\"sms_setting_read\",\"sms_setting_update\",\"sms_campaign_message_send\",\"custom_sms_send\",\"report_read\",\"transaction_history_read\",\"parcels_summary_read\",\"total_summary_read\",\"income_expense_report_read\",\"profit_summary_report_read\",\"merchant_summary_report_read\",\"dashboard_statistics_read\",\"account_read\",\"account_create\",\"account_update\",\"read_all_account\",\"account_statement\",\"fund_transfer_read\",\"read_all_fund_transfer\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"branch_read\",\"branch_create\",\"branch_update\",\"branch_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"server_configuration_update\",\"third_party_read\",\"third_party_create\",\"third_party_update\",\"third_party_delete\",\"language_read\",\"language_create\",\"language_update\",\"language_delete\",\"payment_method_read\",\"payment_method_create\",\"payment_method_update\",\"payment_method_delete\",\"country_read\",\"country_create\",\"country_update\",\"country_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"notice_read\",\"notice_create\",\"notice_update\",\"notice_delete\",\"server_info\",\"system_update\",\"extension_library\",\"filesystem\",\"settings_read\",\"sms_settings_update\",\"charge_setting_update\",\"pickup_and_delivery_time_setting_update\",\"preference_setting_update\",\"panel_setting\",\"preference\",\"payment_method\",\"general_setting\",\"bulk_withdraw_read\",\"read_all_bulk_withdraw\",\"bulk_withdraw_create\",\"bulk_withdraw_update\",\"bulk_withdraw_process\",\"download_payment_sheet\",\"news_and_event.index\",\"news_and_event.create\",\"news_and_event.edit\",\"news_and_event.destroy\",\"about.index\",\"about.create\",\"about.edit\",\"about.destroy\",\"service.index\",\"service.create\",\"service.edit\",\"service.destroy\",\"feature.index\",\"feature.create\",\"feature.edit\",\"feature.destroy\",\"statistic.index\",\"statistic.create\",\"statistic.edit\",\"statistic.destroy\",\"price.section\",\"contact.section\",\"website.themes\",\"website.menu\",\"section.title\",\"hero.section\",\"website.cta\",\"footer.content\",\"website_setting.seo\",\"website_setting.custom_js\",\"website_setting.custom_css\",\"website_setting.google_setup\",\"website_setting.fb_pixel\",\"website_setting.gdpr\",\"partner_logo.index\",\"partner_logo.create\",\"partner_logo.edit\",\"partner_logo.destroy\",\"testimonial.index\",\"testimonial.create\",\"testimonial.edit\",\"testimonial.destroy\",\"faq.index\",\"faq.create\",\"faq.destroy\",\"faq.edit\",\"pages.index\",\"pages.create\",\"pages.edit\",\"pages.destroy\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'), (3, 'branch-manager', 'Branch Manager', '[\"merchant_read\",\"use_all_merchant\",\"deliveryman_read\",\"parcel_read\",\"parcel_create\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_returned_to_merchant\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'), (4, 'account-manager', 'Account Manager', '[\"merchant_read\",\"use_all_merchant\",\"deliveryman_read\",\"use_all_delivery_man\",\"parcel_read\",\"read_all_parcel\",\"parcel_create\",\"parcel_update\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received_by_pickup_man\",\"parcel_received\",\"parcel_transfer_to_hub\",\"parcel_transfer_receive_to_hub\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_returned_to_merchant\",\"parcel_cancel\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'), (5, 'support-executive', 'Support Executive', '[\"manage_parcel\",\"all_parcel\",\"manage_payment\",\"all_parcel_payment\",\"read_logs\",\"all_parcel_logs\",\"all_payment_logs\",\"manage_company_information\",\"manage_payment_accounts\",\"manage_shops\",\"delivery_charge\",\"cash_on_delivery_charge\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'), (6, 'administrator', 'Administrator', '[\"user_create\",\"user_read\",\"user_update\",\"user_delete\",\"user_account_activity_read\",\"user_payment_logs_read\",\"user_logout_from_devices\",\"role_create\",\"role_read\",\"role_update\",\"role_delete\",\"permission_read\",\"permission_create\",\"permission_update\",\"permission_delete\",\"apikeys.index\",\"apikeys.create\",\"apikeys.edit\",\"apikeys.revoke\",\"apikeys.destroy\",\"merchant_create\",\"merchant_read\",\"use_all_merchant\",\"read_all_merchant\",\"merchant_update\",\"merchant_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_delete\",\"merchant_shop_update\",\"merchant_payment_account_read\",\"merchant_payment_account_update\",\"merchant_account_activity_read\",\"merchant_cod_charge_read\",\"merchant_charge_read\",\"merchant_payment_logs_read\",\"merchant_api_credentials_read\",\"merchant_api_credentials_update\",\"merchant_staff_read\",\"merchant_staff_create\",\"merchant_staff_update\",\"download_closing_report\",\"deliveryman_create\",\"deliveryman_read\",\"read_all_delivery_man\",\"use_all_delivery_man\",\"deliveryman_update\",\"deliveryman_delete\",\"deliveryman_account_activity_read\",\"deliveryman_payment_logs_read\",\"parcel_create\",\"parcel_read\",\"parcel_update\",\"parcel_delete\",\"read_all_parcel\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received_by_pickup_man\",\"parcel_received\",\"parcel_transfer_to_branch\",\"parcel_transfer_receive_to_branch\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_backward\",\"parcel_returned_to_merchant\",\"parcel_cancel\",\"parcel_delete\",\"send_to_paperfly\",\"income_create\",\"income_read\",\"read_all_income\",\"income_update\",\"income_delete\",\"expense_create\",\"expense_read\",\"read_all_expense\",\"expense_update\",\"expense_delete\",\"withdraw_read\",\"read_all_withdraw\",\"withdraw_create\",\"withdraw_update\",\"withdraw_process\",\"withdraw_reject\",\"add_to_bulk_withdraw\",\"sms_setting_read\",\"sms_setting_update\",\"sms_campaign_message_send\",\"custom_sms_send\",\"report_read\",\"transaction_history_read\",\"parcels_summary_read\",\"total_summary_read\",\"income_expense_report_read\",\"profit_summary_report_read\",\"merchant_summary_report_read\",\"dashboard_statistics_read\",\"account_read\",\"account_create\",\"account_update\",\"read_all_account\",\"account_statement\",\"fund_transfer_read\",\"read_all_fund_transfer\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"branch_read\",\"branch_create\",\"branch_update\",\"branch_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"server_configuration_update\",\"third_party_read\",\"third_party_create\",\"third_party_update\",\"third_party_delete\",\"language_read\",\"language_create\",\"language_update\",\"language_delete\",\"payment_method_read\",\"payment_method_create\",\"payment_method_update\",\"payment_method_delete\",\"country_read\",\"country_create\",\"country_update\",\"country_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"notice_read\",\"notice_create\",\"notice_update\",\"notice_delete\",\"server_info\",\"system_update\",\"extension_library\",\"filesystem\",\"settings_read\",\"sms_settings_update\",\"charge_setting_update\",\"pickup_and_delivery_time_setting_update\",\"preference_setting_update\",\"panel_setting\",\"preference\",\"payment_method\",\"general_setting\",\"bulk_withdraw_read\",\"read_all_bulk_withdraw\",\"bulk_withdraw_create\",\"bulk_withdraw_update\",\"bulk_withdraw_process\",\"download_payment_sheet\",\"news_and_event.index\",\"news_and_event.create\",\"news_and_event.edit\",\"news_and_event.destroy\",\"about.index\",\"about.create\",\"about.edit\",\"about.destroy\",\"service.index\",\"service.create\",\"service.edit\",\"service.destroy\",\"feature.index\",\"feature.create\",\"feature.edit\",\"feature.destroy\",\"statistic.index\",\"statistic.create\",\"statistic.edit\",\"statistic.destroy\",\"price.section\",\"contact.section\",\"website.themes\",\"website.menu\",\"section.title\",\"hero.section\",\"website.cta\",\"footer.content\",\"website_setting.seo\",\"website_setting.custom_js\",\"website_setting.custom_css\",\"website_setting.google_setup\",\"website_setting.fb_pixel\",\"website_setting.gdpr\",\"partner_logo.index\",\"partner_logo.create\",\"partner_logo.edit\",\"partner_logo.destroy\",\"testimonial.index\",\"testimonial.create\",\"testimonial.edit\",\"testimonial.destroy\",\"faq.index\",\"faq.create\",\"faq.destroy\",\"faq.edit\",\"pages.index\",\"pages.create\",\"pages.edit\",\"pages.destroy\"]', '2025-05-31 05:10:04', '2025-05-31 05:10:04', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `role_users` -- CREATE TABLE `role_users` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `role_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 `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) DEFAULT NULL, `value` text DEFAULT NULL, `lang` varchar(191) DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `title`, `value`, `lang`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1, 'return_charge', '40', NULL, NULL, NULL, '2021-07-23 17:22:58', '2021-07-23 17:22:58'), (2, 'fragile_charge', '20', NULL, NULL, NULL, '2021-07-23 17:22:58', '2024-01-09 19:39:17'), (3, 'pickup_accept_start', '18', NULL, NULL, NULL, '2021-07-23 17:23:04', '2021-07-23 17:23:04'), (4, 'pickup_accept_end', '24', NULL, NULL, NULL, '2021-07-23 17:23:04', '2021-07-23 17:23:04'), (5, 'outside_dhaka_days', '8', NULL, NULL, NULL, '2021-07-23 17:23:04', '2024-01-21 20:54:23'), (6, 'paginate_all_list', '20', NULL, NULL, NULL, '2021-07-24 03:41:14', '2021-07-24 03:41:14'), (7, 'paginate_parcel_merchant_list', '50', NULL, NULL, NULL, '2021-07-24 04:11:01', '2021-07-24 04:11:01'), (8, 'paginate_api_list', '15', NULL, NULL, NULL, '2021-07-24 03:41:14', '2021-07-24 08:56:11'), (11, 'sms_cli', '', NULL, NULL, NULL, '2021-07-24 06:15:32', '2021-07-24 06:15:32'), (21, 'api_key', 'xxxxxxxxxxx', NULL, NULL, NULL, '2021-08-04 12:09:26', '2021-08-04 16:54:44'), (22, 'return_charge_dhaka', '50', NULL, NULL, NULL, '2021-08-04 16:52:57', '2024-01-08 19:22:46'), (23, 'return_charge_sub_city', '90', NULL, NULL, NULL, '2021-08-04 16:52:57', '2021-09-04 06:55:39'), (24, 'return_charge_outside_dhaka', '120', NULL, NULL, NULL, '2021-08-04 16:52:57', '2021-09-04 06:55:39'), (25, 'return_charge_type', 'on_demand', NULL, NULL, NULL, '2021-12-15 05:54:15', '2024-01-08 19:22:46'), (26, 'delivery_otp', 'none', NULL, NULL, NULL, NULL, '2023-01-30 02:33:07'), (28, 'delivery_otp', 'all', NULL, NULL, NULL, NULL, NULL), (29, 'sip_domain', '103.103.35.164:3939', NULL, NULL, NULL, NULL, '2023-01-18 06:31:49'), (30, 'current_version', '190', NULL, NULL, NULL, NULL, '2025-05-31 05:10:08'), (31, 'update_skipable', 'true', NULL, NULL, NULL, NULL, '2023-01-18 06:31:27'), (32, 'update_url', '#', NULL, NULL, NULL, NULL, NULL), (33, 'phone_visible', 'true', NULL, NULL, NULL, NULL, '2023-01-18 06:31:27'), (34, 'admin_panel_title', 'DeliX', 'en', NULL, NULL, '2024-01-27 22:58:58', '2024-01-27 22:58:58'), (35, 'system_short_name', 'DeliX', 'en', NULL, NULL, '2024-01-27 22:58:58', '2024-01-27 22:58:58'), (36, 'admin_panel_copyright_text', 'Copyright @2024 by SpaGreen Creative', 'en', NULL, NULL, '2024-01-27 22:58:58', '2024-01-27 22:58:58'), (37, 'admin_logo', 'a:6:{s:7:\"storage\";s:5:\"local\";s:14:\"original_image\";s:39:\"images/20240128113929-admin_logo488.png\";s:11:\"image_80X80\";s:44:\"images/20240128113929-admin_logo-80X8077.png\";s:13:\"image_500x500\";s:0:\"\";s:12:\"image_100x36\";s:46:\"images/20240128113929-admin_logo-100x36160.png\";s:14:\"image_1200x630\";s:0:\"\";}', 'en', NULL, NULL, '2024-01-27 22:58:59', '2024-01-27 23:39:29'), (38, 'admin_mini_logo', 'a:6:{s:7:\"storage\";s:5:\"local\";s:14:\"original_image\";s:44:\"images/20240128105859-admin_mini_logo361.png\";s:11:\"image_80X80\";s:50:\"images/20240128105859-admin_mini_logo-80X80234.png\";s:13:\"image_500x500\";s:0:\"\";s:12:\"image_100x36\";s:51:\"images/20240128105859-admin_mini_logo-100x36125.png\";s:14:\"image_1200x630\";s:0:\"\";}', 'en', NULL, NULL, '2024-01-27 22:58:59', '2024-01-27 22:58:59'), (39, 'version_code', '1.9.0', 'en', NULL, NULL, '2024-01-27 23:37:07', '2025-05-31 05:10:08'), (232, 'system_name', 'DeliX', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-31 07:22:06'), (233, 'company_name', 'DeliX', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-31 07:22:06'), (234, 'tagline', 'Parcel Delivery System', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (235, 'phone', '1515232921', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (236, 'phone_country_id', '19', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (237, 'email_address', 'info@delix.cloud', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (238, 'activation_code', 'spagreen674fc1460ab30', 'en', NULL, NULL, '2024-01-27 23:37:07', '2025-05-31 05:10:08'), (239, 'time_zone', '1', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (240, 'default_language', 'en', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (241, 'default_country', '19', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (242, 'default_weight', 'KG', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:39:51'), (243, 'currency_postion', 'before', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:37:07'), (245, 'address', 'Road-1, Block-B\r\nMirpur-1, Dhaka 1216, Bangladesh', 'en', NULL, NULL, '2024-01-31 06:21:22', '2024-01-31 06:21:22'), (246, 'system_name', 'DeliX', 'bn', NULL, NULL, '2024-01-31 08:56:34', '2024-01-31 08:56:34'), (247, 'deliX', 'deliX', 'bn', NULL, NULL, '2024-01-31 08:56:34', '2024-01-31 08:56:34'), (249, 'default_currency', '$', 'en', NULL, NULL, '2024-01-27 23:37:07', '2024-01-27 23:39:51'), (250, 'default_language', 'en', NULL, NULL, NULL, '2025-05-31 05:10:08', '2025-05-31 05:10:08'); -- -------------------------------------------------------- -- -- Table structure for table `shops` -- CREATE TABLE `shops` ( `id` bigint(20) UNSIGNED NOT NULL, `shop_name` varchar(191) NOT NULL, `shop_phone_number` varchar(191) NOT NULL, `contact_number` varchar(191) DEFAULT NULL, `pickup_branch_id` bigint(20) UNSIGNED DEFAULT NULL, `address` text DEFAULT NULL, `merchant_id` bigint(20) UNSIGNED DEFAULT NULL, `default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 not default, 1 default shop used for creating parcel request/pickup', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `sms_templates` -- CREATE TABLE `sms_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(191) DEFAULT NULL, `content` longtext DEFAULT NULL, `sms_to_merchant` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `masking` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sms_templates` -- INSERT INTO `sms_templates` (`id`, `subject`, `content`, `sms_to_merchant`, `masking`, `created_at`, `updated_at`) VALUES (1, 'parcel_create_event', 'Your parcel {parcel_id} has been created successfully at {current_date_time}. For Track: {short_url}\r\n{our_company_name}', 0, 0, NULL, '2021-04-10 16:33:47'), (2, 'assign_pickup_man_event', 'A pickup man has been assigned for pickup your parcel {parcel_id} at {pickup_date_time}. Pickup man: {pickup_man_name}, {pickup_man_phone}.\r\n{our_company_name}', 0, 0, NULL, NULL), (3, 'parcel_re_schedule_pickup_event', 'Your parcel {parcel_id} has been re-schedule for pickup at {re_pickup_date_time}. Pickup man: {pickup_man_name}, {pickup_man_phone}.\r\n{our_company_name}', 0, 0, NULL, NULL), (4, 'parcel_received_by_pickup_man_event', 'Your parcel {parcel_id} has been successfully received by our pickup man at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (5, 'parcel_received_event', 'Your parcel {parcel_id} has been successfully received by {our_company_name} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (6, 'parcel_transferred_to_branch_assigned_event', 'Your parcel {parcel_id} has been assigned to transfer on another branch.\r\n{our_company_name}', 0, 0, NULL, NULL), (7, 'parcel_transferred_to_branch_event', 'Your parcel {parcel_id} has been successfully transfer on another branch.\r\n{our_company_name}', 0, 0, NULL, NULL), (8, 'assign_delivery_man_event', 'A delivery man has been assigned for delivery your parcel {parcel_id} at {delivery_date_time}. Delivery man: {delivery_man_name}, {delivery_man_phone}\r\n{our_company_name}', 0, 0, NULL, NULL), (9, 'parcel_re_schedule_delivery_event', 'Your parcel {parcel_id} has been re-schedule for delivery at {re_delivery_date_time}. Delivery man: {delivery_man_name}, {delivery_man_phone}\r\n{our_company_name}', 0, 0, NULL, NULL), (10, 'parcel_delivered_event', 'Your parcel {parcel_id} has been successfully delivered to customer at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (11, 'parcel_return_to_wirehouse', 'Your parcel {parcel_id} has been return to {our_company_name} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (12, 'parcel_return_assign_to_merchant_event', 'Your parcel {parcel_id} has been assigned for returning to you at {current_date_time}. Delivery Man: {delivery_man_name}, {delivery_man_phone}\r\n{our_company_name}', 0, 0, NULL, NULL), (13, 'parcel_returned_to_merchant_event', 'Your parcel {parcel_id} has been successfully returned to you at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (14, 'parcel_cancel_event', 'Your parcel {parcel_id} has been cancelled for delivery at {current_date_time}. Reason: {cancel_note}\r\n{our_company_name}', 0, 0, NULL, NULL), (15, 'parcel_re_request_event', 'Your parcel {parcel_id} has been re-requested for delivery at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (16, 'parcel_update_event', 'Your parcel {parcel_id} has been updated at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `staff_accounts` -- CREATE TABLE `staff_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `source` varchar(191) DEFAULT NULL COMMENT 'I will use it to make the description more meaningful', `details` text DEFAULT NULL, `date` date DEFAULT NULL, `type` varchar(191) DEFAULT NULL COMMENT 'income/credit, expense/debit', `amount` decimal(8,2) DEFAULT NULL COMMENT 'Positive and negative amount defined by type', `balance` decimal(8,2) DEFAULT NULL COMMENT 'Grand balance', `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Staff ID for easy retrieval', `account_id` bigint(20) UNSIGNED DEFAULT NULL, `company_account_id` bigint(20) UNSIGNED DEFAULT NULL, `fund_transfer_id` bigint(20) UNSIGNED DEFAULT NULL, `from_account_id` bigint(20) UNSIGNED DEFAULT NULL, `to_account_id` bigint(20) UNSIGNED DEFAULT NULL, `date_time` datetime DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `temp_stores` -- CREATE TABLE `temp_stores` ( `id` bigint(20) UNSIGNED NOT NULL, `company` varchar(191) NOT NULL, `first_name` varchar(191) DEFAULT NULL, `last_name` varchar(191) DEFAULT NULL, `email` varchar(191) NOT NULL, `phone_number` varchar(191) NOT NULL, `address` text NOT NULL, `password` varchar(191) NOT NULL, `otp` varchar(191) NOT NULL COMMENT 'for phone number verification', `ip` varchar(191) DEFAULT NULL, `platform` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `browser` varchar(191) DEFAULT NULL, `user_agent` varchar(191) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `testimonial_languages` -- CREATE TABLE `testimonial_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `testimonial_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `name` varchar(191) NOT NULL, `title` varchar(191) NOT NULL, `designation` varchar(191) NOT 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 `third_parties` -- CREATE TABLE `third_parties` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `address` varchar(191) NOT NULL, `phone_number` varchar(191) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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 `throttle` -- CREATE TABLE `throttle` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `type` varchar(191) NOT NULL, `ip` 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 `timezones` -- CREATE TABLE `timezones` ( `id` bigint(20) UNSIGNED NOT NULL, `country_code` varchar(191) NOT NULL, `timezone` varchar(191) DEFAULT NULL, `gmt_offset` varchar(191) DEFAULT NULL, `dst_offset` varchar(191) DEFAULT NULL, `raw_offset` 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 `timezones` -- INSERT INTO `timezones` (`id`, `country_code`, `timezone`, `gmt_offset`, `dst_offset`, `raw_offset`, `created_at`, `updated_at`) VALUES (1, 'AD', 'Europe/Andorra', '1.00', '2.00', '1.00', NULL, NULL), (2, 'AE', 'Asia/Dubai', '4.00', '4.00', '4.00', NULL, NULL), (3, 'AF', 'Asia/Kabul', '4.50', '4.50', '4.50', NULL, NULL), (4, 'AG', 'America/Antigua', '-4.00', '-4.00', '-4.00', NULL, NULL), (5, 'AI', 'America/Anguilla', '-4.00', '-4.00', '-4.00', NULL, NULL), (6, 'AL', 'Europe/Tirane', '1.00', '2.00', '1.00', NULL, NULL), (7, 'AM', 'Asia/Yerevan', '4.00', '4.00', '4.00', NULL, NULL), (8, 'AO', 'Africa/Luanda', '1.00', '1.00', '1.00', NULL, NULL), (9, 'AQ', 'Antarctica/Casey', '8.00', '8.00', '8.00', NULL, NULL), (10, 'AQ', 'Antarctica/Davis', '7.00', '7.00', '7.00', NULL, NULL), (11, 'AQ', 'Antarctica/DumontDUrville', '10.00', '10.00', '10.00', NULL, NULL), (12, 'AQ', 'Antarctica/Mawson', '5.00', '5.00', '5.00', NULL, NULL), (13, 'AQ', 'Antarctica/McMurdo', '13.00', '12.00', '12.00', NULL, NULL), (14, 'AQ', 'Antarctica/Palmer', '-3.00', '-4.00', '-4.00', NULL, NULL), (15, 'AQ', 'Antarctica/Rothera', '-3.00', '-3.00', '-3.00', NULL, NULL), (16, 'AQ', 'Antarctica/South_Pole', '13.00', '12.00', '12.00', NULL, NULL), (17, 'AQ', 'Antarctica/Syowa', '3.00', '3.00', '3.00', NULL, NULL), (18, 'AQ', 'Antarctica/Vostok', '6.00', '6.00', '6.00', NULL, NULL), (19, 'AR', 'America/Argentina/Buenos_Aires', '-3.00', '-3.00', '-3.00', NULL, NULL), (20, 'AR', 'America/Argentina/Catamarca', '-3.00', '-3.00', '-3.00', NULL, NULL), (21, 'AR', 'America/Argentina/Cordoba', '-3.00', '-3.00', '-3.00', NULL, NULL), (22, 'AR', 'America/Argentina/Jujuy', '-3.00', '-3.00', '-3.00', NULL, NULL), (23, 'AR', 'America/Argentina/La_Rioja', '-3.00', '-3.00', '-3.00', NULL, NULL), (24, 'AR', 'America/Argentina/Mendoza', '-3.00', '-3.00', '-3.00', NULL, NULL), (25, 'AR', 'America/Argentina/Rio_Gallegos', '-3.00', '-3.00', '-3.00', NULL, NULL), (26, 'AR', 'America/Argentina/Salta', '-3.00', '-3.00', '-3.00', NULL, NULL), (27, 'AR', 'America/Argentina/San_Juan', '-3.00', '-3.00', '-3.00', NULL, NULL), (28, 'AR', 'America/Argentina/San_Luis', '-3.00', '-3.00', '-3.00', NULL, NULL), (29, 'AR', 'America/Argentina/Tucuman', '-3.00', '-3.00', '-3.00', NULL, NULL), (30, 'AR', 'America/Argentina/Ushuaia', '-3.00', '-3.00', '-3.00', NULL, NULL), (31, 'AS', 'Pacific/Pago_Pago', '-11.00', '-11.00', '-11.00', NULL, NULL), (32, 'AT', 'Europe/Vienna', '1.00', '2.00', '1.00', NULL, NULL), (33, 'AU', 'Antarctica/Macquarie', '11.00', '11.00', '11.00', NULL, NULL), (34, 'AU', 'Australia/Adelaide', '10.50', '9.50', '9.50', NULL, NULL), (35, 'AU', 'Australia/Brisbane', '10.00', '10.00', '10.00', NULL, NULL), (36, 'AU', 'Australia/Broken_Hill', '10.50', '9.50', '9.50', NULL, NULL), (37, 'AU', 'Australia/Currie', '11.00', '10.00', '10.00', NULL, NULL), (38, 'AU', 'Australia/Darwin', '9.50', '9.50', '9.50', NULL, NULL), (39, 'AU', 'Australia/Eucla', '8.75', '8.75', '8.75', NULL, NULL), (40, 'AU', 'Australia/Hobart', '11.00', '10.00', '10.00', NULL, NULL), (41, 'AU', 'Australia/Lindeman', '10.00', '10.00', '10.00', NULL, NULL), (42, 'AU', 'Australia/Lord_Howe', '11.00', '10.50', '10.50', NULL, NULL), (43, 'AU', 'Australia/Melbourne', '11.00', '10.00', '10.00', NULL, NULL), (44, 'AU', 'Australia/Perth', '8.00', '8.00', '8.00', NULL, NULL), (45, 'AU', 'Australia/Sydney', '11.00', '10.00', '10.00', NULL, NULL), (46, 'AW', 'America/Aruba', '-4.00', '-4.00', '-4.00', NULL, NULL), (47, 'AX', 'Europe/Mariehamn', '2.00', '3.00', '2.00', NULL, NULL), (48, 'AZ', 'Asia/Baku', '4.00', '5.00', '4.00', NULL, NULL), (49, 'BA', 'Europe/Sarajevo', '1.00', '2.00', '1.00', NULL, NULL), (50, 'BB', 'America/Barbados', '-4.00', '-4.00', '-4.00', NULL, NULL), (51, 'BD', 'Asia/Dhaka', '6.00', '6.00', '6.00', NULL, NULL), (52, 'BE', 'Europe/Brussels', '1.00', '2.00', '1.00', NULL, NULL), (53, 'BF', 'Africa/Ouagadougou', '0.00', '0.00', '0.00', NULL, NULL), (54, 'BG', 'Europe/Sofia', '2.00', '3.00', '2.00', NULL, NULL), (55, 'BH', 'Asia/Bahrain', '3.00', '3.00', '3.00', NULL, NULL), (56, 'BI', 'Africa/Bujumbura', '2.00', '2.00', '2.00', NULL, NULL), (57, 'BJ', 'Africa/Porto-Novo', '1.00', '1.00', '1.00', NULL, NULL), (58, 'BL', 'America/St_Barthelemy', '-4.00', '-4.00', '-4.00', NULL, NULL), (59, 'BM', 'Atlantic/Bermuda', '-4.00', '-3.00', '-4.00', NULL, NULL), (60, 'BN', 'Asia/Brunei', '8.00', '8.00', '8.00', NULL, NULL), (61, 'BO', 'America/La_Paz', '-4.00', '-4.00', '-4.00', NULL, NULL), (62, 'BQ', 'America/Kralendijk', '-4.00', '-4.00', '-4.00', NULL, NULL), (63, 'BR', 'America/Araguaina', '-3.00', '-3.00', '-3.00', NULL, NULL), (64, 'BR', 'America/Bahia', '-3.00', '-3.00', '-3.00', NULL, NULL), (65, 'BR', 'America/Belem', '-3.00', '-3.00', '-3.00', NULL, NULL), (66, 'BR', 'America/Boa_Vista', '-4.00', '-4.00', '-4.00', NULL, NULL), (67, 'BR', 'America/Campo_Grande', '-3.00', '-4.00', '-4.00', NULL, NULL), (68, 'BR', 'America/Cuiaba', '-3.00', '-4.00', '-4.00', NULL, NULL), (69, 'BR', 'America/Eirunepe', '-5.00', '-5.00', '-5.00', NULL, NULL), (70, 'BR', 'America/Fortaleza', '-3.00', '-3.00', '-3.00', NULL, NULL), (71, 'BR', 'America/Maceio', '-3.00', '-3.00', '-3.00', NULL, NULL), (72, 'BR', 'America/Manaus', '-4.00', '-4.00', '-4.00', NULL, NULL), (73, 'BR', 'America/Noronha', '-2.00', '-2.00', '-2.00', NULL, NULL), (74, 'BR', 'America/Porto_Velho', '-4.00', '-4.00', '-4.00', NULL, NULL), (75, 'BR', 'America/Recife', '-3.00', '-3.00', '-3.00', NULL, NULL), (76, 'BR', 'America/Rio_Branco', '-5.00', '-5.00', '-5.00', NULL, NULL), (77, 'BR', 'America/Santarem', '-3.00', '-3.00', '-3.00', NULL, NULL), (78, 'BR', 'America/Sao_Paulo', '-2.00', '-3.00', '-3.00', NULL, NULL), (79, 'BS', 'America/Nassau', '-5.00', '-4.00', '-5.00', NULL, NULL), (80, 'BT', 'Asia/Thimphu', '6.00', '6.00', '6.00', NULL, NULL), (81, 'BW', 'Africa/Gaborone', '2.00', '2.00', '2.00', NULL, NULL), (82, 'BY', 'Europe/Minsk', '3.00', '3.00', '3.00', NULL, NULL), (83, 'BZ', 'America/Belize', '-6.00', '-6.00', '-6.00', NULL, NULL), (84, 'CA', 'America/Atikokan', '-5.00', '-5.00', '-5.00', NULL, NULL), (85, 'CA', 'America/Blanc-Sablon', '-4.00', '-4.00', '-4.00', NULL, NULL), (86, 'CA', 'America/Cambridge_Bay', '-7.00', '-6.00', '-7.00', NULL, NULL), (87, 'CA', 'America/Creston', '-7.00', '-7.00', '-7.00', NULL, NULL), (88, 'CA', 'America/Dawson', '-8.00', '-7.00', '-8.00', NULL, NULL), (89, 'CA', 'America/Dawson_Creek', '-7.00', '-7.00', '-7.00', NULL, NULL), (90, 'CA', 'America/Edmonton', '-7.00', '-6.00', '-7.00', NULL, NULL), (91, 'CA', 'America/Glace_Bay', '-4.00', '-3.00', '-4.00', NULL, NULL), (92, 'CA', 'America/Goose_Bay', '-4.00', '-3.00', '-4.00', NULL, NULL), (93, 'CA', 'America/Halifax', '-4.00', '-3.00', '-4.00', NULL, NULL), (94, 'CA', 'America/Inuvik', '-7.00', '-6.00', '-7.00', NULL, NULL), (95, 'CA', 'America/Iqaluit', '-5.00', '-4.00', '-5.00', NULL, NULL), (96, 'CA', 'America/Moncton', '-4.00', '-3.00', '-4.00', NULL, NULL), (97, 'CA', 'America/Montreal', '-5.00', '-4.00', '-5.00', NULL, NULL), (98, 'CA', 'America/Nipigon', '-5.00', '-4.00', '-5.00', NULL, NULL), (99, 'CA', 'America/Pangnirtung', '-5.00', '-4.00', '-5.00', NULL, NULL), (100, 'CA', 'America/Rainy_River', '-6.00', '-5.00', '-6.00', NULL, NULL), (101, 'CA', 'America/Rankin_Inlet', '-6.00', '-5.00', '-6.00', NULL, NULL), (102, 'CA', 'America/Regina', '-6.00', '-6.00', '-6.00', NULL, NULL), (103, 'CA', 'America/Resolute', '-6.00', '-5.00', '-6.00', NULL, NULL), (104, 'CA', 'America/St_Johns', '-3.50', '-2.50', '-3.50', NULL, NULL), (105, 'CA', 'America/Swift_Current', '-6.00', '-6.00', '-6.00', NULL, NULL), (106, 'CA', 'America/Thunder_Bay', '-5.00', '-4.00', '-5.00', NULL, NULL), (107, 'CA', 'America/Toronto', '-5.00', '-4.00', '-5.00', NULL, NULL), (108, 'CA', 'America/Vancouver', '-8.00', '-7.00', '-8.00', NULL, NULL), (109, 'CA', 'America/Whitehorse', '-8.00', '-7.00', '-8.00', NULL, NULL), (110, 'CA', 'America/Winnipeg', '-6.00', '-5.00', '-6.00', NULL, NULL), (111, 'CA', 'America/Yellowknife', '-7.00', '-6.00', '-7.00', NULL, NULL), (112, 'CC', 'Indian/Cocos', '6.50', '6.50', '6.50', NULL, NULL), (113, 'CD', 'Africa/Kinshasa', '1.00', '1.00', '1.00', NULL, NULL), (114, 'CD', 'Africa/Lubumbashi', '2.00', '2.00', '2.00', NULL, NULL), (115, 'CF', 'Africa/Bangui', '1.00', '1.00', '1.00', NULL, NULL), (116, 'CG', 'Africa/Brazzaville', '1.00', '1.00', '1.00', NULL, NULL), (117, 'CH', 'Europe/Zurich', '1.00', '2.00', '1.00', NULL, NULL), (118, 'CI', 'Africa/Abidjan', '0.00', '0.00', '0.00', NULL, NULL), (119, 'CK', 'Pacific/Rarotonga', '-10.00', '-10.00', '-10.00', NULL, NULL), (120, 'CL', 'America/Santiago', '-3.00', '-4.00', '-4.00', NULL, NULL), (121, 'CL', 'Pacific/Easter', '-5.00', '-6.00', '-6.00', NULL, NULL), (122, 'CM', 'Africa/Douala', '1.00', '1.00', '1.00', NULL, NULL), (123, 'CN', 'Asia/Chongqing', '8.00', '8.00', '8.00', NULL, NULL), (124, 'CN', 'Asia/Harbin', '8.00', '8.00', '8.00', NULL, NULL), (125, 'CN', 'Asia/Kashgar', '8.00', '8.00', '8.00', NULL, NULL), (126, 'CN', 'Asia/Shanghai', '8.00', '8.00', '8.00', NULL, NULL), (127, 'CN', 'Asia/Urumqi', '8.00', '8.00', '8.00', NULL, NULL), (128, 'CO', 'America/Bogota', '-5.00', '-5.00', '-5.00', NULL, NULL), (129, 'CR', 'America/Costa_Rica', '-6.00', '-6.00', '-6.00', NULL, NULL), (130, 'CU', 'America/Havana', '-5.00', '-4.00', '-5.00', NULL, NULL), (131, 'CV', 'Atlantic/Cape_Verde', '-1.00', '-1.00', '-1.00', NULL, NULL), (132, 'CW', 'America/Curacao', '-4.00', '-4.00', '-4.00', NULL, NULL), (133, 'CX', 'Indian/Christmas', '7.00', '7.00', '7.00', NULL, NULL), (134, 'CY', 'Asia/Nicosia', '2.00', '3.00', '2.00', NULL, NULL), (135, 'CZ', 'Europe/Prague', '1.00', '2.00', '1.00', NULL, NULL), (136, 'DE', 'Europe/Berlin', '1.00', '2.00', '1.00', NULL, NULL), (137, 'DE', 'Europe/Busingen', '1.00', '2.00', '1.00', NULL, NULL), (138, 'DJ', 'Africa/Djibouti', '3.00', '3.00', '3.00', NULL, NULL), (139, 'DK', 'Europe/Copenhagen', '1.00', '2.00', '1.00', NULL, NULL), (140, 'DM', 'America/Dominica', '-4.00', '-4.00', '-4.00', NULL, NULL), (141, 'DO', 'America/Santo_Domingo', '-4.00', '-4.00', '-4.00', NULL, NULL), (142, 'DZ', 'Africa/Algiers', '1.00', '1.00', '1.00', NULL, NULL), (143, 'EC', 'America/Guayaquil', '-5.00', '-5.00', '-5.00', NULL, NULL), (144, 'EC', 'Pacific/Galapagos', '-6.00', '-6.00', '-6.00', NULL, NULL), (145, 'EE', 'Europe/Tallinn', '2.00', '3.00', '2.00', NULL, NULL), (146, 'EG', 'Africa/Cairo', '2.00', '2.00', '2.00', NULL, NULL), (147, 'EH', 'Africa/El_Aaiun', '0.00', '0.00', '0.00', NULL, NULL), (148, 'ER', 'Africa/Asmara', '3.00', '3.00', '3.00', NULL, NULL), (149, 'ES', 'Africa/Ceuta', '1.00', '2.00', '1.00', NULL, NULL), (150, 'ES', 'Atlantic/Canary', '0.00', '1.00', '0.00', NULL, NULL), (151, 'ES', 'Europe/Madrid', '1.00', '2.00', '1.00', NULL, NULL), (152, 'ET', 'Africa/Addis_Ababa', '3.00', '3.00', '3.00', NULL, NULL), (153, 'FI', 'Europe/Helsinki', '2.00', '3.00', '2.00', NULL, NULL), (154, 'FJ', 'Pacific/Fiji', '13.00', '12.00', '12.00', NULL, NULL), (155, 'FK', 'Atlantic/Stanley', '-3.00', '-3.00', '-3.00', NULL, NULL), (156, 'FM', 'Pacific/Chuuk', '10.00', '10.00', '10.00', NULL, NULL), (157, 'FM', 'Pacific/Kosrae', '11.00', '11.00', '11.00', NULL, NULL), (158, 'FM', 'Pacific/Pohnpei', '11.00', '11.00', '11.00', NULL, NULL), (159, 'FO', 'Atlantic/Faroe', '0.00', '1.00', '0.00', NULL, NULL), (160, 'FR', 'Europe/Paris', '1.00', '2.00', '1.00', NULL, NULL), (161, 'GA', 'Africa/Libreville', '1.00', '1.00', '1.00', NULL, NULL), (162, 'GB', 'Europe/London', '0.00', '1.00', '0.00', NULL, NULL), (163, 'GD', 'America/Grenada', '-4.00', '-4.00', '-4.00', NULL, NULL), (164, 'GE', 'Asia/Tbilisi', '4.00', '4.00', '4.00', NULL, NULL), (165, 'GF', 'America/Cayenne', '-3.00', '-3.00', '-3.00', NULL, NULL), (166, 'GG', 'Europe/Guernsey', '0.00', '1.00', '0.00', NULL, NULL), (167, 'GH', 'Africa/Accra', '0.00', '0.00', '0.00', NULL, NULL), (168, 'GI', 'Europe/Gibraltar', '1.00', '2.00', '1.00', NULL, NULL), (169, 'GL', 'America/Danmarkshavn', '0.00', '0.00', '0.00', NULL, NULL), (170, 'GL', 'America/Godthab', '-3.00', '-2.00', '-3.00', NULL, NULL), (171, 'GL', 'America/Scoresbysund', '-1.00', '0.00', '-1.00', NULL, NULL), (172, 'GL', 'America/Thule', '-4.00', '-3.00', '-4.00', NULL, NULL), (173, 'GM', 'Africa/Banjul', '0.00', '0.00', '0.00', NULL, NULL), (174, 'GN', 'Africa/Conakry', '0.00', '0.00', '0.00', NULL, NULL), (175, 'GP', 'America/Guadeloupe', '-4.00', '-4.00', '-4.00', NULL, NULL), (176, 'GQ', 'Africa/Malabo', '1.00', '1.00', '1.00', NULL, NULL), (177, 'GR', 'Europe/Athens', '2.00', '3.00', '2.00', NULL, NULL), (178, 'GS', 'Atlantic/South_Georgia', '-2.00', '-2.00', '-2.00', NULL, NULL), (179, 'GT', 'America/Guatemala', '-6.00', '-6.00', '-6.00', NULL, NULL), (180, 'GU', 'Pacific/Guam', '10.00', '10.00', '10.00', NULL, NULL), (181, 'GW', 'Africa/Bissau', '0.00', '0.00', '0.00', NULL, NULL), (182, 'GY', 'America/Guyana', '-4.00', '-4.00', '-4.00', NULL, NULL), (183, 'HK', 'Asia/Hong_Kong', '8.00', '8.00', '8.00', NULL, NULL), (184, 'HN', 'America/Tegucigalpa', '-6.00', '-6.00', '-6.00', NULL, NULL), (185, 'HR', 'Europe/Zagreb', '1.00', '2.00', '1.00', NULL, NULL), (186, 'HT', 'America/Port-au-Prince', '-5.00', '-4.00', '-5.00', NULL, NULL), (187, 'HU', 'Europe/Budapest', '1.00', '2.00', '1.00', NULL, NULL), (188, 'ID', 'Asia/Jakarta', '7.00', '7.00', '7.00', NULL, NULL), (189, 'ID', 'Asia/Jayapura', '9.00', '9.00', '9.00', NULL, NULL), (190, 'ID', 'Asia/Makassar', '8.00', '8.00', '8.00', NULL, NULL), (191, 'ID', 'Asia/Pontianak', '7.00', '7.00', '7.00', NULL, NULL), (192, 'IE', 'Europe/Dublin', '0.00', '1.00', '0.00', NULL, NULL), (193, 'IL', 'Asia/Jerusalem', '2.00', '3.00', '2.00', NULL, NULL), (194, 'IM', 'Europe/Isle_of_Man', '0.00', '1.00', '0.00', NULL, NULL), (195, 'IN', 'Asia/Kolkata', '5.50', '5.50', '5.50', NULL, NULL), (196, 'IO', 'Indian/Chagos', '6.00', '6.00', '6.00', NULL, NULL), (197, 'IQ', 'Asia/Baghdad', '3.00', '3.00', '3.00', NULL, NULL), (198, 'IR', 'Asia/Tehran', '3.50', '4.50', '3.50', NULL, NULL), (199, 'IS', 'Atlantic/Reykjavik', '0.00', '0.00', '0.00', NULL, NULL), (200, 'IT', 'Europe/Rome', '1.00', '2.00', '1.00', NULL, NULL), (201, 'JE', 'Europe/Jersey', '0.00', '1.00', '0.00', NULL, NULL), (202, 'JM', 'America/Jamaica', '-5.00', '-5.00', '-5.00', NULL, NULL), (203, 'JO', 'Asia/Amman', '2.00', '3.00', '2.00', NULL, NULL), (204, 'JP', 'Asia/Tokyo', '9.00', '9.00', '9.00', NULL, NULL), (205, 'KE', 'Africa/Nairobi', '3.00', '3.00', '3.00', NULL, NULL), (206, 'KG', 'Asia/Bishkek', '6.00', '6.00', '6.00', NULL, NULL), (207, 'KH', 'Asia/Phnom_Penh', '7.00', '7.00', '7.00', NULL, NULL), (208, 'KI', 'Pacific/Enderbury', '13.00', '13.00', '13.00', NULL, NULL), (209, 'KI', 'Pacific/Kiritimati', '14.00', '14.00', '14.00', NULL, NULL), (210, 'KI', 'Pacific/Tarawa', '12.00', '12.00', '12.00', NULL, NULL), (211, 'KM', 'Indian/Comoro', '3.00', '3.00', '3.00', NULL, NULL), (212, 'KN', 'America/St_Kitts', '-4.00', '-4.00', '-4.00', NULL, NULL), (213, 'KP', 'Asia/Pyongyang', '9.00', '9.00', '9.00', NULL, NULL), (214, 'KR', 'Asia/Seoul', '9.00', '9.00', '9.00', NULL, NULL), (215, 'KW', 'Asia/Kuwait', '3.00', '3.00', '3.00', NULL, NULL), (216, 'KY', 'America/Cayman', '-5.00', '-5.00', '-5.00', NULL, NULL), (217, 'KZ', 'Asia/Almaty', '6.00', '6.00', '6.00', NULL, NULL), (218, 'KZ', 'Asia/Aqtau', '5.00', '5.00', '5.00', NULL, NULL), (219, 'KZ', 'Asia/Aqtobe', '5.00', '5.00', '5.00', NULL, NULL), (220, 'KZ', 'Asia/Oral', '5.00', '5.00', '5.00', NULL, NULL), (221, 'KZ', 'Asia/Qyzylorda', '6.00', '6.00', '6.00', NULL, NULL), (222, 'LA', 'Asia/Vientiane', '7.00', '7.00', '7.00', NULL, NULL), (223, 'LB', 'Asia/Beirut', '2.00', '3.00', '2.00', NULL, NULL), (224, 'LC', 'America/St_Lucia', '-4.00', '-4.00', '-4.00', NULL, NULL), (225, 'LI', 'Europe/Vaduz', '1.00', '2.00', '1.00', NULL, NULL), (226, 'LK', 'Asia/Colombo', '5.50', '5.50', '5.50', NULL, NULL), (227, 'LR', 'Africa/Monrovia', '0.00', '0.00', '0.00', NULL, NULL), (228, 'LS', 'Africa/Maseru', '2.00', '2.00', '2.00', NULL, NULL), (229, 'LT', 'Europe/Vilnius', '2.00', '3.00', '2.00', NULL, NULL), (230, 'LU', 'Europe/Luxembourg', '1.00', '2.00', '1.00', NULL, NULL), (231, 'LV', 'Europe/Riga', '2.00', '3.00', '2.00', NULL, NULL), (232, 'LY', 'Africa/Tripoli', '2.00', '2.00', '2.00', NULL, NULL), (233, 'MA', 'Africa/Casablanca', '0.00', '0.00', '0.00', NULL, NULL), (234, 'MC', 'Europe/Monaco', '1.00', '2.00', '1.00', NULL, NULL), (235, 'MD', 'Europe/Chisinau', '2.00', '3.00', '2.00', NULL, NULL), (236, 'ME', 'Europe/Podgorica', '1.00', '2.00', '1.00', NULL, NULL), (237, 'MF', 'America/Marigot', '-4.00', '-4.00', '-4.00', NULL, NULL), (238, 'MG', 'Indian/Antananarivo', '3.00', '3.00', '3.00', NULL, NULL), (239, 'MH', 'Pacific/Kwajalein', '12.00', '12.00', '12.00', NULL, NULL), (240, 'MH', 'Pacific/Majuro', '12.00', '12.00', '12.00', NULL, NULL), (241, 'MK', 'Europe/Skopje', '1.00', '2.00', '1.00', NULL, NULL), (242, 'ML', 'Africa/Bamako', '0.00', '0.00', '0.00', NULL, NULL), (243, 'MM', 'Asia/Rangoon', '6.50', '6.50', '6.50', NULL, NULL), (244, 'MN', 'Asia/Choibalsan', '8.00', '8.00', '8.00', NULL, NULL), (245, 'MN', 'Asia/Hovd', '7.00', '7.00', '7.00', NULL, NULL), (246, 'MN', 'Asia/Ulaanbaatar', '8.00', '8.00', '8.00', NULL, NULL), (247, 'MO', 'Asia/Macau', '8.00', '8.00', '8.00', NULL, NULL), (248, 'MP', 'Pacific/Saipan', '10.00', '10.00', '10.00', NULL, NULL), (249, 'MQ', 'America/Martinique', '-4.00', '-4.00', '-4.00', NULL, NULL), (250, 'MR', 'Africa/Nouakchott', '0.00', '0.00', '0.00', NULL, NULL), (251, 'MS', 'America/Montserrat', '-4.00', '-4.00', '-4.00', NULL, NULL), (252, 'MT', 'Europe/Malta', '1.00', '2.00', '1.00', NULL, NULL), (253, 'MU', 'Indian/Mauritius', '4.00', '4.00', '4.00', NULL, NULL), (254, 'MV', 'Indian/Maldives', '5.00', '5.00', '5.00', NULL, NULL), (255, 'MW', 'Africa/Blantyre', '2.00', '2.00', '2.00', NULL, NULL), (256, 'MX', 'America/Bahia_Banderas', '-6.00', '-5.00', '-6.00', NULL, NULL), (257, 'MX', 'America/Cancun', '-6.00', '-5.00', '-6.00', NULL, NULL), (258, 'MX', 'America/Chihuahua', '-7.00', '-6.00', '-7.00', NULL, NULL), (259, 'MX', 'America/Hermosillo', '-7.00', '-7.00', '-7.00', NULL, NULL), (260, 'MX', 'America/Matamoros', '-6.00', '-5.00', '-6.00', NULL, NULL), (261, 'MX', 'America/Mazatlan', '-7.00', '-6.00', '-7.00', NULL, NULL), (262, 'MX', 'America/Merida', '-6.00', '-5.00', '-6.00', NULL, NULL), (263, 'MX', 'America/Mexico_City', '-6.00', '-5.00', '-6.00', NULL, NULL), (264, 'MX', 'America/Monterrey', '-6.00', '-5.00', '-6.00', NULL, NULL), (265, 'MX', 'America/Ojinaga', '-7.00', '-6.00', '-7.00', NULL, NULL), (266, 'MX', 'America/Santa_Isabel', '-8.00', '-7.00', '-8.00', NULL, NULL), (267, 'MX', 'America/Tijuana', '-8.00', '-7.00', '-8.00', NULL, NULL), (268, 'MY', 'Asia/Kuala_Lumpur', '8.00', '8.00', '8.00', NULL, NULL), (269, 'MY', 'Asia/Kuching', '8.00', '8.00', '8.00', NULL, NULL), (270, 'MZ', 'Africa/Maputo', '2.00', '2.00', '2.00', NULL, NULL), (271, 'NA', 'Africa/Windhoek', '2.00', '1.00', '1.00', NULL, NULL), (272, 'NC', 'Pacific/Noumea', '11.00', '11.00', '11.00', NULL, NULL), (273, 'NE', 'Africa/Niamey', '1.00', '1.00', '1.00', NULL, NULL), (274, 'NF', 'Pacific/Norfolk', '11.50', '11.50', '11.50', NULL, NULL), (275, 'NG', 'Africa/Lagos', '1.00', '1.00', '1.00', NULL, NULL), (276, 'NI', 'America/Managua', '-6.00', '-6.00', '-6.00', NULL, NULL), (277, 'NL', 'Europe/Amsterdam', '1.00', '2.00', '1.00', NULL, NULL), (278, 'NO', 'Europe/Oslo', '1.00', '2.00', '1.00', NULL, NULL), (279, 'NP', 'Asia/Kathmandu', '5.75', '5.75', '5.75', NULL, NULL), (280, 'NR', 'Pacific/Nauru', '12.00', '12.00', '12.00', NULL, NULL), (281, 'NU', 'Pacific/Niue', '-11.00', '-11.00', '-11.00', NULL, NULL), (282, 'NZ', 'Pacific/Auckland', '13.00', '12.00', '12.00', NULL, NULL), (283, 'NZ', 'Pacific/Chatham', '13.75', '12.75', '12.75', NULL, NULL), (284, 'OM', 'Asia/Muscat', '4.00', '4.00', '4.00', NULL, NULL), (285, 'PA', 'America/Panama', '-5.00', '-5.00', '-5.00', NULL, NULL), (286, 'PE', 'America/Lima', '-5.00', '-5.00', '-5.00', NULL, NULL), (287, 'PF', 'Pacific/Gambier', '-9.00', '-9.00', '-9.00', NULL, NULL), (288, 'PF', 'Pacific/Marquesas', '-9.50', '-9.50', '-9.50', NULL, NULL), (289, 'PF', 'Pacific/Tahiti', '-10.00', '-10.00', '-10.00', NULL, NULL), (290, 'PG', 'Pacific/Port_Moresby', '10.00', '10.00', '10.00', NULL, NULL), (291, 'PH', 'Asia/Manila', '8.00', '8.00', '8.00', NULL, NULL), (292, 'PK', 'Asia/Karachi', '5.00', '5.00', '5.00', NULL, NULL), (293, 'PL', 'Europe/Warsaw', '1.00', '2.00', '1.00', NULL, NULL), (294, 'PM', 'America/Miquelon', '-3.00', '-2.00', '-3.00', NULL, NULL), (295, 'PN', 'Pacific/Pitcairn', '-8.00', '-8.00', '-8.00', NULL, NULL), (296, 'PR', 'America/Puerto_Rico', '-4.00', '-4.00', '-4.00', NULL, NULL), (297, 'PS', 'Asia/Gaza', '2.00', '3.00', '2.00', NULL, NULL), (298, 'PS', 'Asia/Hebron', '2.00', '3.00', '2.00', NULL, NULL), (299, 'PT', 'Atlantic/Azores', '-1.00', '0.00', '-1.00', NULL, NULL), (300, 'PT', 'Atlantic/Madeira', '0.00', '1.00', '0.00', NULL, NULL), (301, 'PT', 'Europe/Lisbon', '0.00', '1.00', '0.00', NULL, NULL), (302, 'PW', 'Pacific/Palau', '9.00', '9.00', '9.00', NULL, NULL), (303, 'PY', 'America/Asuncion', '-3.00', '-4.00', '-4.00', NULL, NULL), (304, 'QA', 'Asia/Qatar', '3.00', '3.00', '3.00', NULL, NULL), (305, 'RE', 'Indian/Reunion', '4.00', '4.00', '4.00', NULL, NULL), (306, 'RO', 'Europe/Bucharest', '2.00', '3.00', '2.00', NULL, NULL), (307, 'RS', 'Europe/Belgrade', '1.00', '2.00', '1.00', NULL, NULL), (308, 'RU', 'Asia/Anadyr', '12.00', '12.00', '12.00', NULL, NULL), (309, 'RU', 'Asia/Irkutsk', '9.00', '9.00', '9.00', NULL, NULL), (310, 'RU', 'Asia/Kamchatka', '12.00', '12.00', '12.00', NULL, NULL), (311, 'RU', 'Asia/Khandyga', '10.00', '10.00', '10.00', NULL, NULL), (312, 'RU', 'Asia/Krasnoyarsk', '8.00', '8.00', '8.00', NULL, NULL), (313, 'RU', 'Asia/Magadan', '12.00', '12.00', '12.00', NULL, NULL), (314, 'RU', 'Asia/Novokuznetsk', '7.00', '7.00', '7.00', NULL, NULL), (315, 'RU', 'Asia/Novosibirsk', '7.00', '7.00', '7.00', NULL, NULL), (316, 'RU', 'Asia/Omsk', '7.00', '7.00', '7.00', NULL, NULL), (317, 'RU', 'Asia/Sakhalin', '11.00', '11.00', '11.00', NULL, NULL), (318, 'RU', 'Asia/Ust-Nera', '11.00', '11.00', '11.00', NULL, NULL), (319, 'RU', 'Asia/Vladivostok', '11.00', '11.00', '11.00', NULL, NULL), (320, 'RU', 'Asia/Yakutsk', '10.00', '10.00', '10.00', NULL, NULL), (321, 'RU', 'Asia/Yekaterinburg', '6.00', '6.00', '6.00', NULL, NULL), (322, 'RU', 'Europe/Kaliningrad', '3.00', '3.00', '3.00', NULL, NULL), (323, 'RU', 'Europe/Moscow', '4.00', '4.00', '4.00', NULL, NULL), (324, 'RU', 'Europe/Samara', '4.00', '4.00', '4.00', NULL, NULL), (325, 'RU', 'Europe/Volgograd', '4.00', '4.00', '4.00', NULL, NULL), (326, 'RW', 'Africa/Kigali', '2.00', '2.00', '2.00', NULL, NULL), (327, 'SA', 'Asia/Riyadh', '3.00', '3.00', '3.00', NULL, NULL), (328, 'SB', 'Pacific/Guadalcanal', '11.00', '11.00', '11.00', NULL, NULL), (329, 'SC', 'Indian/Mahe', '4.00', '4.00', '4.00', NULL, NULL), (330, 'SD', 'Africa/Khartoum', '3.00', '3.00', '3.00', NULL, NULL), (331, 'SE', 'Europe/Stockholm', '1.00', '2.00', '1.00', NULL, NULL), (332, 'SG', 'Asia/Singapore', '8.00', '8.00', '8.00', NULL, NULL), (333, 'SH', 'Atlantic/St_Helena', '0.00', '0.00', '0.00', NULL, NULL), (334, 'SI', 'Europe/Ljubljana', '1.00', '2.00', '1.00', NULL, NULL), (335, 'SJ', 'Arctic/Longyearbyen', '1.00', '2.00', '1.00', NULL, NULL), (336, 'SK', 'Europe/Bratislava', '1.00', '2.00', '1.00', NULL, NULL), (337, 'SL', 'Africa/Freetown', '0.00', '0.00', '0.00', NULL, NULL), (338, 'SM', 'Europe/San_Marino', '1.00', '2.00', '1.00', NULL, NULL), (339, 'SN', 'Africa/Dakar', '0.00', '0.00', '0.00', NULL, NULL), (340, 'SO', 'Africa/Mogadishu', '3.00', '3.00', '3.00', NULL, NULL), (341, 'SR', 'America/Paramaribo', '-3.00', '-3.00', '-3.00', NULL, NULL), (342, 'SS', 'Africa/Juba', '3.00', '3.00', '3.00', NULL, NULL), (343, 'ST', 'Africa/Sao_Tome', '0.00', '0.00', '0.00', NULL, NULL), (344, 'SV', 'America/El_Salvador', '-6.00', '-6.00', '-6.00', NULL, NULL), (345, 'SX', 'America/Lower_Princes', '-4.00', '-4.00', '-4.00', NULL, NULL), (346, 'SY', 'Asia/Damascus', '2.00', '3.00', '2.00', NULL, NULL), (347, 'SZ', 'Africa/Mbabane', '2.00', '2.00', '2.00', NULL, NULL), (348, 'TC', 'America/Grand_Turk', '-5.00', '-4.00', '-5.00', NULL, NULL), (349, 'TD', 'Africa/Ndjamena', '1.00', '1.00', '1.00', NULL, NULL), (350, 'TF', 'Indian/Kerguelen', '5.00', '5.00', '5.00', NULL, NULL), (351, 'TG', 'Africa/Lome', '0.00', '0.00', '0.00', NULL, NULL), (352, 'TH', 'Asia/Bangkok', '7.00', '7.00', '7.00', NULL, NULL), (353, 'TJ', 'Asia/Dushanbe', '5.00', '5.00', '5.00', NULL, NULL), (354, 'TK', 'Pacific/Fakaofo', '13.00', '13.00', '13.00', NULL, NULL), (355, 'TL', 'Asia/Dili', '9.00', '9.00', '9.00', NULL, NULL), (356, 'TM', 'Asia/Ashgabat', '5.00', '5.00', '5.00', NULL, NULL), (357, 'TN', 'Africa/Tunis', '1.00', '1.00', '1.00', NULL, NULL), (358, 'TO', 'Pacific/Tongatapu', '13.00', '13.00', '13.00', NULL, NULL), (359, 'TR', 'Europe/Istanbul', '2.00', '3.00', '2.00', NULL, NULL), (360, 'TT', 'America/Port_of_Spain', '-4.00', '-4.00', '-4.00', NULL, NULL), (361, 'TV', 'Pacific/Funafuti', '12.00', '12.00', '12.00', NULL, NULL), (362, 'TW', 'Asia/Taipei', '8.00', '8.00', '8.00', NULL, NULL), (363, 'TZ', 'Africa/Dar_es_Salaam', '3.00', '3.00', '3.00', NULL, NULL), (364, 'UA', 'Europe/Kiev', '2.00', '3.00', '2.00', NULL, NULL), (365, 'UA', 'Europe/Simferopol', '2.00', '4.00', '4.00', NULL, NULL), (366, 'UA', 'Europe/Uzhgorod', '2.00', '3.00', '2.00', NULL, NULL), (367, 'UA', 'Europe/Zaporozhye', '2.00', '3.00', '2.00', NULL, NULL), (368, 'UG', 'Africa/Kampala', '3.00', '3.00', '3.00', NULL, NULL), (369, 'UM', 'Pacific/Johnston', '-10.00', '-10.00', '-10.00', NULL, NULL), (370, 'UM', 'Pacific/Midway', '-11.00', '-11.00', '-11.00', NULL, NULL), (371, 'UM', 'Pacific/Wake', '12.00', '12.00', '12.00', NULL, NULL), (372, 'US', 'America/Adak', '-10.00', '-9.00', '-10.00', NULL, NULL), (373, 'US', 'America/Anchorage', '-9.00', '-8.00', '-9.00', NULL, NULL), (374, 'US', 'America/Boise', '-7.00', '-6.00', '-7.00', NULL, NULL), (375, 'US', 'America/Chicago', '-6.00', '-5.00', '-6.00', NULL, NULL), (376, 'US', 'America/Denver', '-7.00', '-6.00', '-7.00', NULL, NULL), (377, 'US', 'America/Detroit', '-5.00', '-4.00', '-5.00', NULL, NULL), (378, 'US', 'America/Indiana/Indianapolis', '-5.00', '-4.00', '-5.00', NULL, NULL), (379, 'US', 'America/Indiana/Knox', '-6.00', '-5.00', '-6.00', NULL, NULL), (380, 'US', 'America/Indiana/Marengo', '-5.00', '-4.00', '-5.00', NULL, NULL), (381, 'US', 'America/Indiana/Petersburg', '-5.00', '-4.00', '-5.00', NULL, NULL), (382, 'US', 'America/Indiana/Tell_City', '-6.00', '-5.00', '-6.00', NULL, NULL), (383, 'US', 'America/Indiana/Vevay', '-5.00', '-4.00', '-5.00', NULL, NULL), (384, 'US', 'America/Indiana/Vincennes', '-5.00', '-4.00', '-5.00', NULL, NULL), (385, 'US', 'America/Indiana/Winamac', '-5.00', '-4.00', '-5.00', NULL, NULL), (386, 'US', 'America/Juneau', '-9.00', '-8.00', '-9.00', NULL, NULL), (387, 'US', 'America/Kentucky/Louisville', '-5.00', '-4.00', '-5.00', NULL, NULL), (388, 'US', 'America/Kentucky/Monticello', '-5.00', '-4.00', '-5.00', NULL, NULL), (389, 'US', 'America/Los_Angeles', '-8.00', '-7.00', '-8.00', NULL, NULL), (390, 'US', 'America/Menominee', '-6.00', '-5.00', '-6.00', NULL, NULL), (391, 'US', 'America/Metlakatla', '-8.00', '-8.00', '-8.00', NULL, NULL), (392, 'US', 'America/New_York', '-5.00', '-4.00', '-5.00', NULL, NULL), (393, 'US', 'America/Nome', '-9.00', '-8.00', '-9.00', NULL, NULL), (394, 'US', 'America/North_Dakota/Beulah', '-6.00', '-5.00', '-6.00', NULL, NULL), (395, 'US', 'America/North_Dakota/Center', '-6.00', '-5.00', '-6.00', NULL, NULL), (396, 'US', 'America/North_Dakota/New_Salem', '-6.00', '-5.00', '-6.00', NULL, NULL), (397, 'US', 'America/Phoenix', '-7.00', '-7.00', '-7.00', NULL, NULL), (398, 'US', 'America/Shiprock', '-7.00', '-6.00', '-7.00', NULL, NULL), (399, 'US', 'America/Sitka', '-9.00', '-8.00', '-9.00', NULL, NULL), (400, 'US', 'America/Yakutat', '-9.00', '-8.00', '-9.00', NULL, NULL), (401, 'US', 'Pacific/Honolulu', '-10.00', '-10.00', '-10.00', NULL, NULL), (402, 'UY', 'America/Montevideo', '-2.00', '-3.00', '-3.00', NULL, NULL), (403, 'UZ', 'Asia/Samarkand', '5.00', '5.00', '5.00', NULL, NULL), (404, 'UZ', 'Asia/Tashkent', '5.00', '5.00', '5.00', NULL, NULL), (405, 'VA', 'Europe/Vatican', '1.00', '2.00', '1.00', NULL, NULL), (406, 'VC', 'America/St_Vincent', '-4.00', '-4.00', '-4.00', NULL, NULL), (407, 'VE', 'America/Caracas', '-4.50', '-4.50', '-4.50', NULL, NULL), (408, 'VG', 'America/Tortola', '-4.00', '-4.00', '-4.00', NULL, NULL), (409, 'VI', 'America/St_Thomas', '-4.00', '-4.00', '-4.00', NULL, NULL), (410, 'VN', 'Asia/Ho_Chi_Minh', '7.00', '7.00', '7.00', NULL, NULL), (411, 'VU', 'Pacific/Efate', '11.00', '11.00', '11.00', NULL, NULL), (412, 'WF', 'Pacific/Wallis', '12.00', '12.00', '12.00', NULL, NULL), (413, 'WS', 'Pacific/Apia', '14.00', '13.00', '13.00', NULL, NULL), (414, 'YE', 'Asia/Aden', '3.00', '3.00', '3.00', NULL, NULL), (415, 'YT', 'Indian/Mayotte', '3.00', '3.00', '3.00', NULL, NULL), (416, 'ZA', 'Africa/Johannesburg', '2.00', '2.00', '2.00', NULL, NULL), (417, 'ZM', 'Africa/Lusaka', '2.00', '2.00', '2.00', NULL, NULL), (418, 'ZW', 'Africa/Harare', '2.00', '2.00', '2.00', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(191) NOT NULL, `phone_number` varchar(191) DEFAULT NULL COMMENT 'for merchant login instead of email', `password` varchar(191) NOT NULL, `permissions` text DEFAULT NULL, `shops` text DEFAULT NULL COMMENT 'will be used for merchant staff', `last_login` timestamp NULL DEFAULT NULL, `first_name` varchar(191) DEFAULT NULL, `last_name` varchar(191) DEFAULT NULL, `user_type` enum('staff','delivery','merchant','merchant_staff') NOT NULL DEFAULT 'staff' COMMENT 'staff for all super admin and admin type all', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `otp` int(11) DEFAULT NULL COMMENT 'used for reset password request confirmation from app', `is_primary` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'May it will use for merchant', `merchant_id` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `last_ip` varchar(191) DEFAULT NULL, `last_password_change` timestamp NULL DEFAULT NULL, `image_id` text DEFAULT NULL, `branch_id` bigint(20) UNSIGNED DEFAULT NULL, `dashboard` varchar(191) DEFAULT NULL, `balance` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT 'cash amount when register for company staff', `lang` varchar(191) NOT NULL DEFAULT 'en', `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_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; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `email`, `phone_number`, `password`, `permissions`, `shops`, `last_login`, `first_name`, `last_name`, `user_type`, `status`, `otp`, `is_primary`, `merchant_id`, `user_id`, `last_ip`, `last_password_change`, `image_id`, `branch_id`, `dashboard`, `balance`, `lang`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1, 'admin@spagreen.net', NULL, '$2y$10$1ZJHOXshZucQELyUu44tpO9U85w.8Zi.7tU8/R4cAV.1kiYiJbcoO', '[\"user_create\",\"user_read\",\"user_update\",\"user_delete\",\"user_account_activity_read\",\"user_payment_logs_read\",\"user_logout_from_devices\",\"role_create\",\"role_read\",\"role_update\",\"role_delete\",\"permission_read\",\"permission_create\",\"permission_update\",\"permission_delete\",\"apikeys.index\",\"apikeys.create\",\"apikeys.edit\",\"apikeys.revoke\",\"apikeys.destroy\",\"merchant_create\",\"merchant_read\",\"use_all_merchant\",\"read_all_merchant\",\"merchant_update\",\"merchant_delete\",\"merchant_shop_read\",\"merchant_shop_create\",\"merchant_shop_delete\",\"merchant_shop_update\",\"merchant_payment_account_read\",\"merchant_payment_account_update\",\"merchant_account_activity_read\",\"merchant_cod_charge_read\",\"merchant_charge_read\",\"merchant_payment_logs_read\",\"merchant_api_credentials_read\",\"merchant_api_credentials_update\",\"merchant_staff_read\",\"merchant_staff_create\",\"merchant_staff_update\",\"download_closing_report\",\"deliveryman_create\",\"deliveryman_read\",\"read_all_delivery_man\",\"use_all_delivery_man\",\"deliveryman_update\",\"deliveryman_delete\",\"deliveryman_account_activity_read\",\"deliveryman_payment_logs_read\",\"parcel_create\",\"parcel_read\",\"parcel_update\",\"parcel_delete\",\"read_all_parcel\",\"parcel_pickup_assigned\",\"parcel_reschedule_pickup\",\"parcel_received_by_pickup_man\",\"parcel_received\",\"parcel_transfer_to_branch\",\"parcel_transfer_receive_to_branch\",\"parcel_delivery_assigned\",\"parcel_reschedule_delivery\",\"parcel_returned_to_warehouse\",\"parcel_return_assigned_to_merchant\",\"parcel_delivered\",\"parcel_backward\",\"parcel_returned_to_merchant\",\"parcel_cancel\",\"parcel_delete\",\"send_to_paperfly\",\"income_create\",\"income_read\",\"read_all_income\",\"income_update\",\"income_delete\",\"expense_create\",\"expense_read\",\"read_all_expense\",\"expense_update\",\"expense_delete\",\"withdraw_read\",\"read_all_withdraw\",\"withdraw_create\",\"withdraw_update\",\"withdraw_process\",\"withdraw_reject\",\"add_to_bulk_withdraw\",\"sms_setting_read\",\"sms_setting_update\",\"sms_campaign_message_send\",\"custom_sms_send\",\"report_read\",\"transaction_history_read\",\"parcels_summary_read\",\"total_summary_read\",\"income_expense_report_read\",\"profit_summary_report_read\",\"merchant_summary_report_read\",\"dashboard_statistics_read\",\"account_read\",\"account_create\",\"account_update\",\"read_all_account\",\"account_statement\",\"fund_transfer_read\",\"read_all_fund_transfer\",\"fund_transfer_create\",\"fund_transfer_update\",\"fund_transfer_delete\",\"branch_read\",\"branch_create\",\"branch_update\",\"branch_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"server_configuration_update\",\"third_party_read\",\"third_party_create\",\"third_party_update\",\"third_party_delete\",\"language_read\",\"language_create\",\"language_update\",\"language_delete\",\"payment_method_read\",\"payment_method_create\",\"payment_method_update\",\"payment_method_delete\",\"country_read\",\"country_create\",\"country_update\",\"country_delete\",\"email_template_read\",\"email_template_create\",\"email_template_update\",\"email_template_delete\",\"notice_read\",\"notice_create\",\"notice_update\",\"notice_delete\",\"server_info\",\"system_update\",\"extension_library\",\"filesystem\",\"settings_read\",\"sms_settings_update\",\"charge_setting_update\",\"pickup_and_delivery_time_setting_update\",\"preference_setting_update\",\"panel_setting\",\"preference\",\"payment_method\",\"general_setting\",\"bulk_withdraw_read\",\"read_all_bulk_withdraw\",\"bulk_withdraw_create\",\"bulk_withdraw_update\",\"bulk_withdraw_process\",\"download_payment_sheet\",\"news_and_event.index\",\"news_and_event.create\",\"news_and_event.edit\",\"news_and_event.destroy\",\"about.index\",\"about.create\",\"about.edit\",\"about.destroy\",\"service.index\",\"service.create\",\"service.edit\",\"service.destroy\",\"feature.index\",\"feature.create\",\"feature.edit\",\"feature.destroy\",\"statistic.index\",\"statistic.create\",\"statistic.edit\",\"statistic.destroy\",\"price.section\",\"contact.section\",\"website.themes\",\"website.menu\",\"section.title\",\"website.cta\",\"footer.content\",\"website_setting.seo\",\"website_setting.custom_js\",\"website_setting.custom_css\",\"website_setting.google_setup\",\"website_setting.fb_pixel\",\"website_setting.gdpr\",\"section.title\",\"partner_logo.index\",\"partner_logo.create\",\"partner_logo.edit\",\"partner_logo.destroy\",\"testimonial.index\",\"testimonial.create\",\"testimonial.edit\",\"testimonial.destroy\",\"faq.index\",\"faq.create\",\"faq.destroy\",\"faq.edit\",\"pages.index\",\"pages.create\",\"pages.edit\",\"pages.destroy\"]', NULL, '2025-05-31 05:10:23', 'Delix', 'Admin', 'staff', 'active', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'admin', 0.00, 'en', NULL, 1, '2025-05-31 05:10:08', '2025-05-31 05:10:23'); -- -------------------------------------------------------- -- -- Table structure for table `website_abouts` -- CREATE TABLE `website_abouts` ( `id` bigint(20) UNSIGNED NOT NULL, `icon` text DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_about_languages` -- CREATE TABLE `website_about_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `website_about_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `title` varchar(191) NOT 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 `website_features` -- CREATE TABLE `website_features` ( `id` bigint(20) UNSIGNED NOT NULL, `icon` text DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_feature_languages` -- CREATE TABLE `website_feature_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `website_feature_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `title` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_news_and_events` -- CREATE TABLE `website_news_and_events` ( `id` bigint(20) UNSIGNED NOT NULL, `image` text DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_news_and_event_languages` -- CREATE TABLE `website_news_and_event_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `website_news_and_event_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `title` varchar(191) NOT 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 `website_partner_logos` -- CREATE TABLE `website_partner_logos` ( `id` bigint(20) UNSIGNED NOT NULL, `image` text NOT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_services` -- CREATE TABLE `website_services` ( `id` bigint(20) UNSIGNED NOT NULL, `image` text DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_service_languages` -- CREATE TABLE `website_service_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `website_service_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `title` varchar(191) NOT 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 `website_statistics` -- CREATE TABLE `website_statistics` ( `id` bigint(20) UNSIGNED NOT NULL, `icon` text DEFAULT NULL, `number` text DEFAULT NULL, `title` text DEFAULT NULL, `sub_title` varchar(191) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_statistic_languages` -- CREATE TABLE `website_statistic_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `website_statistic_id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(191) NOT NULL, `number` varchar(191) NOT NULL, `title` varchar(191) NOT NULL, `sub_title` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `website_testimonials` -- CREATE TABLE `website_testimonials` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `title` varchar(191) DEFAULT NULL, `designation` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `media_id` bigint(20) UNSIGNED DEFAULT NULL, `image` text DEFAULT NULL, `rating` varchar(191) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `withdraw_batches` -- CREATE TABLE `withdraw_batches` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'created by', `account_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'processed from account', `batch_type` varchar(191) DEFAULT NULL, `batch_no` varchar(191) DEFAULT NULL COMMENT 'auto generated 10-digit id', `title` varchar(191) DEFAULT NULL, `note` mediumtext DEFAULT NULL, `status` enum('pending','processed') NOT NULL DEFAULT 'pending', `receipt` text DEFAULT NULL COMMENT 'any receipt uploaded', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_by` bigint(20) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `withdraw_sms_templates` -- CREATE TABLE `withdraw_sms_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(191) DEFAULT NULL, `content` longtext DEFAULT NULL, `sms_to_merchant` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `masking` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `withdraw_sms_templates` -- INSERT INTO `withdraw_sms_templates` (`id`, `subject`, `content`, `sms_to_merchant`, `masking`, `created_at`, `updated_at`) VALUES (1, 'payment_create_event', 'A payment request to {account_details} of BDT {amount}, Payment ID: {payment_id} has been placed successfully at {current_date_time}. \r\n{our_company_name}', 0, 0, NULL, '2021-04-11 23:19:01'), (2, 'payment_update_event', 'Payment ID: {payment_id} to {account_details} of BDT {amount} has been updated to {new_account_details} successfully at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, '2021-04-11 23:20:45'), (3, 'payment_cancelled_event', 'Payment ID: {payment_id} to {account_details} of BDT {amount} has been cancelled at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, NULL), (4, 'payment_processed_event', 'Payment ID: {payment_id} to {account_details} of BDT {amount} has been processed successfully at {current_date_time}. \r\n{our_company_name}', 0, 0, NULL, NULL), (5, 'payment_rejected_event', 'Payment ID: {payment_id} to {account_details} of BDT {amount} has been rejected due to {reject_reason} at {current_date_time}.\r\n{our_company_name}', 0, 0, NULL, '2021-04-11 23:20:50'); -- -- Indexes for dumped tables -- -- -- Indexes for table `accounts` -- ALTER TABLE `accounts` ADD PRIMARY KEY (`id`), ADD KEY `accounts_user_id_foreign` (`user_id`), ADD KEY `accounts_payment_method_id_foreign` (`payment_method_id`), ADD KEY `accounts_created_by_foreign` (`created_by`), ADD KEY `accounts_updated_by_foreign` (`updated_by`); -- -- Indexes for table `activations` -- ALTER TABLE `activations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `api_keys` -- ALTER TABLE `api_keys` ADD PRIMARY KEY (`id`); -- -- Indexes for table `api_key_languages` -- ALTER TABLE `api_key_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `branches` -- ALTER TABLE `branches` ADD PRIMARY KEY (`id`), ADD KEY `branches_user_id_foreign` (`user_id`), ADD KEY `branches_created_by_foreign` (`created_by`), ADD KEY `branches_updated_by_foreign` (`updated_by`); -- -- Indexes for table `charges` -- ALTER TABLE `charges` ADD PRIMARY KEY (`id`), ADD KEY `charges_created_by_foreign` (`created_by`), ADD KEY `charges_updated_by_foreign` (`updated_by`); -- -- Indexes for table `cod_charges` -- ALTER TABLE `cod_charges` ADD PRIMARY KEY (`id`), ADD KEY `cod_charges_created_by_foreign` (`created_by`), ADD KEY `cod_charges_updated_by_foreign` (`updated_by`); -- -- Indexes for table `company_accounts` -- ALTER TABLE `company_accounts` ADD PRIMARY KEY (`id`), ADD KEY `company_accounts_created_by_foreign` (`created_by`), ADD KEY `company_accounts_user_id_foreign` (`user_id`), ADD KEY `company_accounts_updated_by_foreign` (`updated_by`), ADD KEY `company_accounts_merchant_id_foreign` (`merchant_id`), ADD KEY `company_accounts_parcel_id_foreign` (`parcel_id`), ADD KEY `company_accounts_merchant_withdraw_id_foreign` (`merchant_withdraw_id`), ADD KEY `company_accounts_delivery_man_id_foreign` (`delivery_man_id`), ADD KEY `company_accounts_account_id_foreign` (`account_id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_parcel_sms_templates` -- ALTER TABLE `customer_parcel_sms_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `delivery_man_accounts` -- ALTER TABLE `delivery_man_accounts` ADD PRIMARY KEY (`id`), ADD KEY `delivery_man_accounts_parcel_id_foreign` (`parcel_id`), ADD KEY `delivery_man_accounts_delivery_man_id_foreign` (`delivery_man_id`), ADD KEY `delivery_man_accounts_company_account_id_foreign` (`company_account_id`), ADD KEY `delivery_man_accounts_created_by_foreign` (`created_by`), ADD KEY `delivery_man_accounts_updated_by_foreign` (`updated_by`); -- -- Indexes for table `delivery_men` -- ALTER TABLE `delivery_men` ADD PRIMARY KEY (`id`), ADD KEY `delivery_men_user_id_foreign` (`user_id`), ADD KEY `delivery_men_created_by_foreign` (`created_by`), ADD KEY `delivery_men_updated_by_foreign` (`updated_by`); -- -- Indexes for table `district_zilas` -- ALTER TABLE `district_zilas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `email_templates` -- ALTER TABLE `email_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `flag_icons` -- ALTER TABLE `flag_icons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `fund_transfers` -- ALTER TABLE `fund_transfers` ADD PRIMARY KEY (`id`), ADD KEY `fund_transfers_from_account_id_foreign` (`from_account_id`), ADD KEY `fund_transfers_to_account_id_foreign` (`to_account_id`), ADD KEY `fund_transfers_created_by_foreign` (`created_by`), ADD KEY `fund_transfers_updated_by_foreign` (`updated_by`); -- -- Indexes for table `govt_vats` -- ALTER TABLE `govt_vats` ADD PRIMARY KEY (`id`), ADD KEY `govt_vats_parcel_id_foreign` (`parcel_id`); -- -- Indexes for table `images` -- ALTER TABLE `images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `languages` -- ALTER TABLE `languages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `languages_locale_unique` (`locale`), ADD KEY `languages_name_index` (`name`); -- -- Indexes for table `language_configs` -- ALTER TABLE `language_configs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `log_activities` -- ALTER TABLE `log_activities` ADD PRIMARY KEY (`id`), ADD KEY `log_activities_user_id_foreign` (`user_id`); -- -- Indexes for table `merchants` -- ALTER TABLE `merchants` ADD PRIMARY KEY (`id`), ADD KEY `merchants_user_id_foreign` (`user_id`), ADD KEY `merchants_created_by_foreign` (`created_by`), ADD KEY `merchants_updated_by_foreign` (`updated_by`); -- -- Indexes for table `merchant_accounts` -- ALTER TABLE `merchant_accounts` ADD PRIMARY KEY (`id`), ADD KEY `merchant_accounts_merchant_withdraw_id_foreign` (`merchant_withdraw_id`), ADD KEY `merchant_accounts_payment_withdraw_id_foreign` (`payment_withdraw_id`), ADD KEY `merchant_accounts_parcel_withdraw_id_foreign` (`parcel_withdraw_id`), ADD KEY `merchant_accounts_merchant_id_foreign` (`merchant_id`), ADD KEY `merchant_accounts_parcel_id_foreign` (`parcel_id`), ADD KEY `merchant_accounts_company_account_id_foreign` (`company_account_id`), ADD KEY `merchant_accounts_created_by_foreign` (`created_by`), ADD KEY `merchant_accounts_updated_by_foreign` (`updated_by`); -- -- Indexes for table `merchant_payment_accounts` -- ALTER TABLE `merchant_payment_accounts` ADD PRIMARY KEY (`id`), ADD KEY `merchant_payment_accounts_payment_method_id_foreign` (`payment_method_id`), ADD KEY `merchant_payment_accounts_created_by_foreign` (`created_by`), ADD KEY `merchant_payment_accounts_updated_by_foreign` (`updated_by`), ADD KEY `merchant_payment_accounts_merchant_id_index` (`merchant_id`); -- -- Indexes for table `merchant_withdraws` -- ALTER TABLE `merchant_withdraws` ADD PRIMARY KEY (`id`), ADD KEY `merchant_withdraws_merchant_id_foreign` (`merchant_id`), ADD KEY `merchant_withdraws_withdraw_to_foreign` (`withdraw_to`), ADD KEY `merchant_withdraws_created_by_foreign` (`created_by`), ADD KEY `merchant_withdraws_updated_by_foreign` (`updated_by`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notices` -- ALTER TABLE `notices` ADD PRIMARY KEY (`id`), ADD KEY `notices_created_by_foreign` (`created_by`), ADD KEY `notices_updated_by_foreign` (`updated_by`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notification_users` -- ALTER TABLE `notification_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package_and_charges` -- ALTER TABLE `package_and_charges` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `page_languages` -- ALTER TABLE `page_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `parcels` -- ALTER TABLE `parcels` ADD PRIMARY KEY (`id`), ADD KEY `parcels_created_by_foreign` (`created_by`), ADD KEY `parcels_updated_by_foreign` (`updated_by`), ADD KEY `parcels_merchant_id_index` (`merchant_id`), ADD KEY `parcels_delivery_man_id_index` (`delivery_man_id`), ADD KEY `parcels_pickup_man_id_index` (`pickup_man_id`), ADD KEY `parcels_return_delivery_man_id_index` (`return_delivery_man_id`), ADD KEY `parcels_user_id_index` (`user_id`), ADD KEY `parcels_parcel_no_index` (`parcel_no`), ADD KEY `parcels_branch_id_index` (`branch_id`), ADD KEY `parcels_transfer_to_branch_id_index` (`transfer_to_branch_id`), ADD KEY `parcels_transfer_delivery_man_id_index` (`transfer_delivery_man_id`), ADD KEY `parcels_withdraw_id_index` (`withdraw_id`), ADD KEY `parcels_pickup_branch_id_index` (`pickup_branch_id`), ADD KEY `parcels_third_party_id_index` (`third_party_id`), ADD KEY `parcels_shop_id_index` (`shop_id`), ADD KEY `parcels_tracking_number_index` (`tracking_number`), ADD KEY `parcels_short_url_index` (`short_url`); -- -- 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_user_id_foreign` (`user_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_return_delivery_man_id_foreign` (`return_delivery_man_id`), ADD KEY `parcel_events_transfer_delivery_man_id_foreign` (`transfer_delivery_man_id`), ADD KEY `parcel_events_branch_id_foreign` (`branch_id`), ADD KEY `parcel_events_third_party_id_foreign` (`third_party_id`), ADD KEY `parcel_events_created_by_foreign` (`created_by`), ADD KEY `parcel_events_updated_by_foreign` (`updated_by`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payment_methods` -- ALTER TABLE `payment_methods` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `payment_methods_name_unique` (`name`), ADD KEY `payment_methods_created_by_foreign` (`created_by`), ADD KEY `payment_methods_updated_by_foreign` (`updated_by`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `persistences` -- ALTER TABLE `persistences` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `persistences_code_unique` (`code`); -- -- Indexes for table `preferences` -- ALTER TABLE `preferences` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reminders` -- ALTER TABLE `reminders` ADD PRIMARY KEY (`id`), ADD KEY `reminders_user_id_foreign` (`user_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_slug_unique` (`slug`); -- -- Indexes for table `role_users` -- ALTER TABLE `role_users` ADD PRIMARY KEY (`id`), ADD KEY `role_users_user_id_foreign` (`user_id`), ADD KEY `role_users_role_id_foreign` (`role_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD KEY `settings_created_by_foreign` (`created_by`), ADD KEY `settings_updated_by_foreign` (`updated_by`); -- -- Indexes for table `shops` -- ALTER TABLE `shops` ADD PRIMARY KEY (`id`), ADD KEY `shops_merchant_id_foreign` (`merchant_id`), ADD KEY `shops_created_by_foreign` (`created_by`), ADD KEY `shops_updated_by_foreign` (`updated_by`); -- -- Indexes for table `sms_templates` -- ALTER TABLE `sms_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `staff_accounts` -- ALTER TABLE `staff_accounts` ADD PRIMARY KEY (`id`), ADD KEY `staff_accounts_user_id_foreign` (`user_id`), ADD KEY `staff_accounts_account_id_foreign` (`account_id`), ADD KEY `staff_accounts_company_account_id_foreign` (`company_account_id`), ADD KEY `staff_accounts_fund_transfer_id_foreign` (`fund_transfer_id`), ADD KEY `staff_accounts_from_account_id_foreign` (`from_account_id`), ADD KEY `staff_accounts_to_account_id_foreign` (`to_account_id`), ADD KEY `staff_accounts_created_by_foreign` (`created_by`), ADD KEY `staff_accounts_updated_by_foreign` (`updated_by`); -- -- Indexes for table `temp_stores` -- ALTER TABLE `temp_stores` ADD PRIMARY KEY (`id`); -- -- Indexes for table `testimonial_languages` -- ALTER TABLE `testimonial_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `third_parties` -- ALTER TABLE `third_parties` ADD PRIMARY KEY (`id`), ADD KEY `third_parties_created_by_foreign` (`created_by`), ADD KEY `third_parties_updated_by_foreign` (`updated_by`); -- -- Indexes for table `throttle` -- ALTER TABLE `throttle` ADD PRIMARY KEY (`id`), ADD KEY `throttle_user_id_index` (`user_id`); -- -- Indexes for table `timezones` -- ALTER TABLE `timezones` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_created_by_foreign` (`created_by`), ADD KEY `users_updated_by_foreign` (`updated_by`); -- -- Indexes for table `website_abouts` -- ALTER TABLE `website_abouts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_about_languages` -- ALTER TABLE `website_about_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_features` -- ALTER TABLE `website_features` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_feature_languages` -- ALTER TABLE `website_feature_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_news_and_events` -- ALTER TABLE `website_news_and_events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_news_and_event_languages` -- ALTER TABLE `website_news_and_event_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_partner_logos` -- ALTER TABLE `website_partner_logos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_services` -- ALTER TABLE `website_services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_service_languages` -- ALTER TABLE `website_service_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_statistics` -- ALTER TABLE `website_statistics` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_statistic_languages` -- ALTER TABLE `website_statistic_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `website_testimonials` -- ALTER TABLE `website_testimonials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw_batches` -- ALTER TABLE `withdraw_batches` ADD PRIMARY KEY (`id`), ADD KEY `withdraw_batches_user_id_foreign` (`user_id`), ADD KEY `withdraw_batches_account_id_foreign` (`account_id`), ADD KEY `withdraw_batches_created_by_foreign` (`created_by`), ADD KEY `withdraw_batches_updated_by_foreign` (`updated_by`); -- -- Indexes for table `withdraw_sms_templates` -- ALTER TABLE `withdraw_sms_templates` ADD PRIMARY KEY (`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 `activations` -- ALTER TABLE `activations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `api_keys` -- ALTER TABLE `api_keys` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `api_key_languages` -- ALTER TABLE `api_key_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `branches` -- ALTER TABLE `branches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `charges` -- ALTER TABLE `charges` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `cod_charges` -- ALTER TABLE `cod_charges` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `company_accounts` -- ALTER TABLE `company_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251; -- -- AUTO_INCREMENT for table `customer_parcel_sms_templates` -- ALTER TABLE `customer_parcel_sms_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `delivery_man_accounts` -- ALTER TABLE `delivery_man_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `delivery_men` -- ALTER TABLE `delivery_men` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `district_zilas` -- ALTER TABLE `district_zilas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_templates` -- ALTER TABLE `email_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `flag_icons` -- ALTER TABLE `flag_icons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241; -- -- AUTO_INCREMENT for table `fund_transfers` -- ALTER TABLE `fund_transfers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `govt_vats` -- ALTER TABLE `govt_vats` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `images` -- ALTER TABLE `images` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- AUTO_INCREMENT for table `languages` -- ALTER TABLE `languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `language_configs` -- ALTER TABLE `language_configs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `log_activities` -- ALTER TABLE `log_activities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `merchants` -- ALTER TABLE `merchants` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `merchant_accounts` -- ALTER TABLE `merchant_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `merchant_payment_accounts` -- ALTER TABLE `merchant_payment_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `merchant_withdraws` -- ALTER TABLE `merchant_withdraws` 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=62; -- -- AUTO_INCREMENT for table `notices` -- ALTER TABLE `notices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notifications` -- ALTER TABLE `notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notification_users` -- ALTER TABLE `notification_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `package_and_charges` -- ALTER TABLE `package_and_charges` 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 for table `page_languages` -- ALTER TABLE `page_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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 `payment_methods` -- ALTER TABLE `payment_methods` 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=35; -- -- AUTO_INCREMENT for table `persistences` -- ALTER TABLE `persistences` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `preferences` -- ALTER TABLE `preferences` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `reminders` -- ALTER TABLE `reminders` 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=7; -- -- AUTO_INCREMENT for table `role_users` -- ALTER TABLE `role_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251; -- -- AUTO_INCREMENT for table `shops` -- ALTER TABLE `shops` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sms_templates` -- ALTER TABLE `sms_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `staff_accounts` -- ALTER TABLE `staff_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `temp_stores` -- ALTER TABLE `temp_stores` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `testimonial_languages` -- ALTER TABLE `testimonial_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `third_parties` -- ALTER TABLE `third_parties` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `throttle` -- ALTER TABLE `throttle` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timezones` -- ALTER TABLE `timezones` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=419; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `website_abouts` -- ALTER TABLE `website_abouts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_about_languages` -- ALTER TABLE `website_about_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_features` -- ALTER TABLE `website_features` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_feature_languages` -- ALTER TABLE `website_feature_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_news_and_events` -- ALTER TABLE `website_news_and_events` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_news_and_event_languages` -- ALTER TABLE `website_news_and_event_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_partner_logos` -- ALTER TABLE `website_partner_logos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_services` -- ALTER TABLE `website_services` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_service_languages` -- ALTER TABLE `website_service_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_statistics` -- ALTER TABLE `website_statistics` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_statistic_languages` -- ALTER TABLE `website_statistic_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `website_testimonials` -- ALTER TABLE `website_testimonials` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `withdraw_batches` -- ALTER TABLE `withdraw_batches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `withdraw_sms_templates` -- ALTER TABLE `withdraw_sms_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- Constraints for dumped tables -- -- -- Constraints for table `accounts` -- ALTER TABLE `accounts` ADD CONSTRAINT `accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `accounts_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `branches` -- ALTER TABLE `branches` ADD CONSTRAINT `branches_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `branches_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `branches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `charges` -- ALTER TABLE `charges` ADD CONSTRAINT `charges_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `charges_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `cod_charges` -- ALTER TABLE `cod_charges` ADD CONSTRAINT `cod_charges_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `cod_charges_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `company_accounts` -- ALTER TABLE `company_accounts` ADD CONSTRAINT `company_accounts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_merchant_withdraw_id_foreign` FOREIGN KEY (`merchant_withdraw_id`) REFERENCES `merchant_withdraws` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `company_accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `company_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `delivery_man_accounts` -- ALTER TABLE `delivery_man_accounts` ADD CONSTRAINT `delivery_man_accounts_company_account_id_foreign` FOREIGN KEY (`company_account_id`) REFERENCES `company_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `delivery_man_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `delivery_man_accounts_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `delivery_man_accounts_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `delivery_man_accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `delivery_men` -- ALTER TABLE `delivery_men` ADD CONSTRAINT `delivery_men_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `delivery_men_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `delivery_men_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `fund_transfers` -- ALTER TABLE `fund_transfers` ADD CONSTRAINT `fund_transfers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fund_transfers_from_account_id_foreign` FOREIGN KEY (`from_account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fund_transfers_to_account_id_foreign` FOREIGN KEY (`to_account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fund_transfers_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `govt_vats` -- ALTER TABLE `govt_vats` ADD CONSTRAINT `govt_vats_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `log_activities` -- ALTER TABLE `log_activities` ADD CONSTRAINT `log_activities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `merchants` -- ALTER TABLE `merchants` ADD CONSTRAINT `merchants_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchants_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchants_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `merchant_accounts` -- ALTER TABLE `merchant_accounts` ADD CONSTRAINT `merchant_accounts_company_account_id_foreign` FOREIGN KEY (`company_account_id`) REFERENCES `company_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchant_accounts_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_merchant_withdraw_id_foreign` FOREIGN KEY (`merchant_withdraw_id`) REFERENCES `merchant_withdraws` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_parcel_withdraw_id_foreign` FOREIGN KEY (`parcel_withdraw_id`) REFERENCES `merchant_withdraws` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_payment_withdraw_id_foreign` FOREIGN KEY (`payment_withdraw_id`) REFERENCES `merchant_withdraws` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `merchant_payment_accounts` -- ALTER TABLE `merchant_payment_accounts` ADD CONSTRAINT `merchant_payment_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchant_payment_accounts_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_payment_accounts_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchant_payment_accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `merchant_withdraws` -- ALTER TABLE `merchant_withdraws` ADD CONSTRAINT `merchant_withdraws_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchant_withdraws_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `merchant_withdraws_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `merchant_withdraws_withdraw_to_foreign` FOREIGN KEY (`withdraw_to`) REFERENCES `merchant_payment_accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `notices` -- ALTER TABLE `notices` ADD CONSTRAINT `notices_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `notices_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `parcels` -- ALTER TABLE `parcels` ADD CONSTRAINT `parcels_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcels_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `parcels_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcels_pickup_branch_id_foreign` FOREIGN KEY (`pickup_branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcels_pickup_man_id_foreign` FOREIGN KEY (`pickup_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcels_return_delivery_man_id_foreign` FOREIGN KEY (`return_delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcels_shop_id_foreign` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcels_third_party_id_foreign` FOREIGN KEY (`third_party_id`) REFERENCES `third_parties` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcels_transfer_delivery_man_id_foreign` FOREIGN KEY (`transfer_delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcels_transfer_to_branch_id_foreign` FOREIGN KEY (`transfer_to_branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcels_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `parcels_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcels_withdraw_id_foreign` FOREIGN KEY (`withdraw_id`) REFERENCES `merchant_withdraws` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `parcel_events` -- ALTER TABLE `parcel_events` ADD CONSTRAINT `parcel_events_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `parcel_events_delivery_man_id_foreign` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_parcel_id_foreign` FOREIGN KEY (`parcel_id`) REFERENCES `parcels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_pickup_man_id_foreign` FOREIGN KEY (`pickup_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_return_delivery_man_id_foreign` FOREIGN KEY (`return_delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_third_party_id_foreign` FOREIGN KEY (`third_party_id`) REFERENCES `third_parties` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_transfer_delivery_man_id_foreign` FOREIGN KEY (`transfer_delivery_man_id`) REFERENCES `delivery_men` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `parcel_events_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `parcel_events_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `payment_methods` -- ALTER TABLE `payment_methods` ADD CONSTRAINT `payment_methods_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `payment_methods_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `reminders` -- ALTER TABLE `reminders` ADD CONSTRAINT `reminders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `role_users` -- ALTER TABLE `role_users` ADD CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `settings` -- ALTER TABLE `settings` ADD CONSTRAINT `settings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `settings_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `shops` -- ALTER TABLE `shops` ADD CONSTRAINT `shops_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `shops_merchant_id_foreign` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `shops_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `staff_accounts` -- ALTER TABLE `staff_accounts` ADD CONSTRAINT `staff_accounts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_accounts_company_account_id_foreign` FOREIGN KEY (`company_account_id`) REFERENCES `company_accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `staff_accounts_from_account_id_foreign` FOREIGN KEY (`from_account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_accounts_fund_transfer_id_foreign` FOREIGN KEY (`fund_transfer_id`) REFERENCES `fund_transfers` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_accounts_to_account_id_foreign` FOREIGN KEY (`to_account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `staff_accounts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `staff_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `third_parties` -- ALTER TABLE `third_parties` ADD CONSTRAINT `third_parties_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `third_parties_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `throttle` -- ALTER TABLE `throttle` ADD CONSTRAINT `throttle_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `users_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `withdraw_batches` -- ALTER TABLE `withdraw_batches` ADD CONSTRAINT `withdraw_batches_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `withdraw_batches_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `withdraw_batches_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `withdraw_batches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;