-- Table structure for table `firebase_notifies`
--

CREATE TABLE `firebase_notifies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `server_key` varchar(255) DEFAULT NULL,
  `vapid_key` varchar(255) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `auth_domain` varchar(255) DEFAULT NULL,
  `project_id` varchar(255) DEFAULT NULL,
  `storage_bucket` varchar(255) DEFAULT NULL,
  `messaging_sender_id` varchar(255) DEFAULT NULL,
  `app_id` varchar(255) DEFAULT NULL,
  `measurement_id` varchar(255) DEFAULT NULL,
  `user_foreground` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=> off, 1=> on',
  `user_background` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=> off, 1=> on',
  `admin_foreground` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=> off, 1=> on',
  `admin_background` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=> off, 1=> on',
  `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 `firebase_notifies`
--

INSERT INTO `firebase_notifies` (`id`, `server_key`, `vapid_key`, `api_key`, `auth_domain`, `project_id`, `storage_bucket`, `messaging_sender_id`, `app_id`, `measurement_id`, `user_foreground`, `user_background`, `admin_foreground`, `admin_background`, `created_at`, `updated_at`) VALUES
(1, 'Your Server_KEY', 'Your_Vapid Key', 'Your_API Key', 'appSecret', 'Project_Id', 'Storage_Bucket', 'Sender_Id', 'App_Id', 'Measurement_Id', 0, 0, 0, 0, '2023-03-16 00:06:24', '2023-03-16 00:06:24');

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

--
-- Table structure for table `funds`
--

CREATE TABLE `funds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Deposit from admin',
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `percentage` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Percent of charge',
  `charge_percentage` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'After adding percent of charge',
  `charge_fixed` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `received_amount` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount add to receiver',
  `note` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=Success,0=Pending',
  `utr` char(36) DEFAULT NULL,
  `payment_id` varchar(61) DEFAULT NULL,
  `card_order_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `funds`
--

INSERT INTO `funds` (`id`, `user_id`, `admin_id`, `currency_id`, `percentage`, `charge_percentage`, `charge_fixed`, `charge`, `amount`, `received_amount`, `note`, `email`, `status`, `utr`, `payment_id`, `card_order_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 1, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 5000.00000000, 0.00000000, '', 'user1@demo.com', 1, '82f266ee-ff8a-453a-9fff-ff9762f4a970', NULL, NULL, '2023-05-03 17:15:04', '2023-05-03 17:15:04');

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

--
-- Table structure for table `gateways`
--

CREATE TABLE `gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `sort_by` int(11) DEFAULT 1,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0: inactive, 1: active',
  `parameters` text DEFAULT NULL,
  `currencies` text DEFAULT NULL,
  `extra_parameters` text DEFAULT NULL,
  `currency` varchar(191) NOT NULL,
  `symbol` varchar(191) NOT NULL,
  `is_sandbox` tinyint(1) NOT NULL DEFAULT 0,
  `environment` enum('test','live') NOT NULL DEFAULT 'live',
  `min_amount` decimal(18,8) NOT NULL,
  `max_amount` decimal(18,8) NOT NULL,
  `percentage_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `fixed_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `convention_rate` decimal(18,8) NOT NULL DEFAULT 1.00000000,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gateways`
--

INSERT INTO `gateways` (`id`, `code`, `name`, `sort_by`, `image`, `status`, `parameters`, `currencies`, `extra_parameters`, `currency`, `symbol`, `is_sandbox`, `environment`, `min_amount`, `max_amount`, `percentage_charge`, `fixed_charge`, `convention_rate`, `note`, `created_at`, `updated_at`) VALUES
(1, 'paypal', 'Paypal', 2, '6369f8a5aa4551667889317.jpg', 0, '{\"cleint_id\":\"\",\"secret\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"USD\"}}', NULL, 'USD', 'USD', 1, 'test', 1.00000000, 10000.00000000, 1.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(2, 'stripe', 'Stripe ', 4, '6369f8cb536811667889355.jpg', 0, '{\"secret_key\":\"\",\"publishable_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}}', NULL, 'USD', 'USD', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(3, 'skrill', 'Skrill', 6, '6369f81ab99a21667889178.jpg', 0, '{\"pay_to_email\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"MAD\":\"MAD\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"SAR\":\"SAR\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TND\":\"TND\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\",\"COP\":\"COP\"}}', NULL, 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(4, 'perfectmoney', 'Perfect Money', 31, '6369fa31e12df1667889713.jpg', 0, '{\"passphrase\":\"\",\"payee_account\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\"}}', NULL, 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(5, 'paytm', 'PayTM', 30, '6369f9afa42461667889583.jpg', 0, '{\"MID\":\"\",\"merchant_key\":\"\",\"WEBSITE\":\"\",\"INDUSTRY_TYPE_ID\":\"\",\"CHANNEL_ID\":\"\",\"environment_url\":\"\",\"process_transaction_url\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"ARS\":\"ARS\",\"BDT\":\"BDT\",\"BRL\":\"BRL\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"GEL\":\"GEL\",\"GHS\":\"GHS\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"NGN\":\"NGN\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"UGX\":\"UGX\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"GBP\":\"GBP\",\"USD\":\"USD\",\"VND\":\"VND\",\"XOF\":\"XOF\"}}', NULL, 'INR', 'INR', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(6, 'payeer', 'Payeer', 28, '6369f9a0071251667889568.jpg', 0, '{\"merchant_id\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\",\"RUB\":\"RUB\"}}', '{\"status\":\"ipn\"}', 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(7, 'paystack', 'PayStack', 29, '6369f9a838c321667889576.jpg', 0, '{\"public_key\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"NGN\":\"NGN\"}}', '{\"callback\":\"ipn\",\"webhook\":\"ipn\"}\r\n', 'NGN', 'NGN', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(8, 'voguepay', 'VoguePay', 35, '6369f9dd947711667889629.jpg', 0, '{\"merchant_id\":\"\"}', '{\"0\":{\"NGN\":\"NGN\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"ZAR\":\"ZAR\",\"JPY\":\"JPY\",\"INR\":\"INR\",\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PLN\":\"PLN\"}}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', NULL, 'NGN', 'NGN', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(9, 'flutterwave', 'Flutterwave', 24, '6369f9945993b1667889556.jpg', 0, '{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\"}', '{\"0\":{\"KES\":\"KES\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"USD\":\"USD\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"UGX\":\"UGX\",\"TZS\":\"TZS\"}}', NULL, 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(10, 'razorpay', 'RazorPay', 33, '6369f9be2e8f01667889598.jpg', 0, '{\"key_id\":\"\",\"key_secret\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, 'INR', 'INR', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(11, 'instamojo', 'instamojo', 13, '6369f90a5d0721667889418.jpg', 0, '{\"api_key\":\"\",\"auth_token\":\"\",\"salt\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, 'INR', 'INR', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 73.51000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(12, 'mollie', 'Mollie', 26, '62a02512f1c291654662418.png', 0, '{\"api_key\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}}', NULL, 'USD', 'USD', 0, 'live', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 73.51000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(13, 'twocheckout', '2checkout', 10, '6369f8fa28e6f1667889402.jpg', 0, '{\"merchant_code\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"DZD\":\"DZD\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AZN\":\"AZN\",\"BSD\":\"BSD\",\"BDT\":\"BDT\",\"BBD\":\"BBD\",\"BZD\":\"BZD\",\"BMD\":\"BMD\",\"BOB\":\"BOB\",\"BWP\":\"BWP\",\"BRL\":\"BRL\",\"GBP\":\"GBP\",\"BND\":\"BND\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"XCD\":\"XCD\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"GTQ\":\"GTQ\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JMD\":\"JMD\",\"JPY\":\"JPY\",\"KZT\":\"KZT\",\"KES\":\"KES\",\"LAK\":\"LAK\",\"MMK\":\"MMK\",\"LBP\":\"LBP\",\"LRD\":\"LRD\",\"MOP\":\"MOP\",\"MYR\":\"MYR\",\"MVR\":\"MVR\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PGK\":\"PGK\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"WST\":\"WST\",\"SAR\":\"SAR\",\"SCR\":\"SCR\",\"SGD\":\"SGD\",\"SBD\":\"SBD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"SYP\":\"SYP\",\"THB\":\"THB\",\"TOP\":\"TOP\",\"TTD\":\"TTD\",\"TRY\":\"TRY\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"USD\":\"USD\",\"VUV\":\"VUV\",\"VND\":\"VND\",\"XOF\":\"XOF\",\"YER\":\"YER\"}}', '{\"approved_url\":\"ipn\"}', 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(14, 'authorizenet', 'Authorize.Net', 8, '6369f8e57971e1667889381.jpg', 0, '{\"login_id\":\"\",\"current_transaction_key\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"USD\":\"USD\"}}', NULL, 'USD', 'USD', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(15, 'securionpay', 'SecurionPay', 34, '6369f9c78112c1667889607.jpg', 0, '{\"public_key\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"AFN\":\"AFN\", \"DZD\":\"DZD\", \"ARS\":\"ARS\", \"AUD\":\"AUD\", \"BHD\":\"BHD\", \"BDT\":\"BDT\", \"BYR\":\"BYR\", \"BAM\":\"BAM\", \"BWP\":\"BWP\", \"BRL\":\"BRL\", \"BND\":\"BND\", \"BGN\":\"BGN\", \"CAD\":\"CAD\", \"CLP\":\"CLP\", \"CNY\":\"CNY\", \"COP\":\"COP\", \"KMF\":\"KMF\", \"HRK\":\"HRK\", \"CZK\":\"CZK\", \"DKK\":\"DKK\", \"DJF\":\"DJF\", \"DOP\":\"DOP\", \"EGP\":\"EGP\", \"ETB\":\"ETB\", \"ERN\":\"ERN\", \"EUR\":\"EUR\", \"GEL\":\"GEL\", \"HKD\":\"HKD\", \"HUF\":\"HUF\", \"ISK\":\"ISK\", \"INR\":\"INR\", \"IDR\":\"IDR\", \"IRR\":\"IRR\", \"IQD\":\"IQD\", \"ILS\":\"ILS\", \"JMD\":\"JMD\", \"JPY\":\"JPY\", \"JOD\":\"JOD\", \"KZT\":\"KZT\", \"KES\":\"KES\", \"KWD\":\"KWD\", \"KGS\":\"KGS\", \"LVL\":\"LVL\", \"LBP\":\"LBP\", \"LTL\":\"LTL\", \"MOP\":\"MOP\", \"MKD\":\"MKD\", \"MGA\":\"MGA\", \"MWK\":\"MWK\", \"MYR\":\"MYR\", \"MUR\":\"MUR\", \"MXN\":\"MXN\", \"MDL\":\"MDL\", \"MAD\":\"MAD\", \"MZN\":\"MZN\", \"NAD\":\"NAD\", \"NPR\":\"NPR\", \"ANG\":\"ANG\", \"NZD\":\"NZD\", \"NOK\":\"NOK\", \"OMR\":\"OMR\", \"PKR\":\"PKR\", \"PEN\":\"PEN\", \"PHP\":\"PHP\", \"PLN\":\"PLN\", \"QAR\":\"QAR\", \"RON\":\"RON\", \"RUB\":\"RUB\", \"SAR\":\"SAR\", \"RSD\":\"RSD\", \"SGD\":\"SGD\", \"ZAR\":\"ZAR\", \"KRW\":\"KRW\", \"IKR\":\"IKR\", \"LKR\":\"LKR\", \"SEK\":\"SEK\", \"CHF\":\"CHF\", \"SYP\":\"SYP\", \"TWD\":\"TWD\", \"TZS\":\"TZS\", \"THB\":\"THB\", \"TND\":\"TND\", \"TRY\":\"TRY\", \"UAH\":\"UAH\", \"AED\":\"AED\", \"GBP\":\"GBP\", \"USD\":\"USD\", \"VEB\":\"VEB\", \"VEF\":\"VEF\", \"VND\":\"VND\", \"XOF\":\"XOF\", \"YER\":\"YER\", \"ZMK\":\"ZMK\"}}', NULL, 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(16, 'payumoney', 'PayUmoney', 32, '6369f9b5ef2411667889589.jpg', 0, '{\"merchant_key\":\"\",\"salt\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, 'INR', 'INR', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 73.51000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(17, 'mercadopago', 'Mercado Pago', 25, '6369f999dfb2e1667889561.jpg', 0, '{\"access_token\":\"\"}', '{\"0\":{\"ARS\":\"ARS\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"DOP\":\"DOP\",\"EUR\":\"EUR\",\"GTQ\":\"GTQ\",\"HNL\":\"HNL\",\"MXN\":\"MXN\",\"NIO\":\"NIO\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PYG\":\"PYG\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"VEF\":\"VEF\",\"VES\":\"VES\"}}', NULL, 'BRL', 'BRL', 0, '', 3715.12000000, 371500000.12000000, 0.00000000, 0.50000000, 3715.12000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(18, 'coingate', 'Coingate', 22, '6369f94f842d81667889487.jpg', 0, '{\"api_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\"}}', NULL, 'USD', 'USD', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(19, 'coinbasecommerce', 'Coinbase Commerce', 21, '6369f94339bf41667889475.jpg', 0, '{\"api_key\":\"\",\"secret\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AWG\":\"AWG\",\"AZN\":\"AZN\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYN\":\"BYN\",\"BZD\":\"BZD\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CHF\":\"CHF\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GBP\":\"GBP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHS\":\"GHS\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"INR\":\"INR\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"MZN\":\"MZN\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"RUB\":\"RUB\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDG\":\"SDG\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"SHP\":\"SHP\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SRD\":\"SRD\",\"SSP\":\"SSP\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMT\":\"TMT\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TRY\":\"TRY\",\"TTD\":\"TTD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZAR\":\"ZAR\",\"ZMW\":\"ZMW\",\"ZWL\":\"ZWL\"}}', '{\"webhook\":\"ipn\"}', 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(20, 'monnify', 'Monnify', 27, '62a0252654b071654662438.png', 0, '{\"api_key\":\"\",\"secret_key\":\"\",\"contract_code\":\"\"}', '{\"0\":{\"NGN\":\"NGN\"}}', NULL, 'NGN', 'NGN', 0, 'live', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(21, 'blockio', 'Block.io', 15, '63db63437ced41675322179.jpg', 0, '{\"api_key\":\"\",\"api_pin\":\"\"}', '{\"1\":{\"BTC\":\"BTC\",\"LTC\":\"LTC\",\"DOGE\":\"DOGE\"}}', '{\"cron\":\"ipn\"}', 'BTC', 'BTC', 0, '', 0.00004200, 10000.00000000, 0.00000000, 0.50000000, 0.00004200, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(22, 'coinpayments', 'CoinPayments', 23, '6369f9591a8d51667889497.jpg', 0, '{\"merchant_id\":\"\",\"private_key\":\"\",\"public_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\"},\"1\":{\"BTC\":\"Bitcoin\",\"BTC.LN\":\"Bitcoin (Lightning Network)\",\"LTC\":\"Litecoin\",\"CPS\":\"CPS Coin\",\"VLX\":\"Velas\",\"APL\":\"Apollo\",\"AYA\":\"Aryacoin\",\"BAD\":\"Badcoin\",\"BCD\":\"Bitcoin Diamond\",\"BCH\":\"Bitcoin Cash\",\"BCN\":\"Bytecoin\",\"BEAM\":\"BEAM\",\"BITB\":\"Bean Cash\",\"BLK\":\"BlackCoin\",\"BSV\":\"Bitcoin SV\",\"BTAD\":\"Bitcoin Adult\",\"BTG\":\"Bitcoin Gold\",\"BTT\":\"BitTorrent\",\"CLOAK\":\"CloakCoin\",\"CLUB\":\"ClubCoin\",\"CRW\":\"Crown\",\"CRYP\":\"CrypticCoin\",\"CRYT\":\"CryTrExCoin\",\"CURE\":\"CureCoin\",\"DASH\":\"DASH\",\"DCR\":\"Decred\",\"DEV\":\"DeviantCoin\",\"DGB\":\"DigiByte\",\"DOGE\":\"Dogecoin\",\"EBST\":\"eBoost\",\"EOS\":\"EOS\",\"ETC\":\"Ether Classic\",\"ETH\":\"Ethereum\",\"ETN\":\"Electroneum\",\"EUNO\":\"EUNO\",\"EXP\":\"EXP\",\"Expanse\":\"Expanse\",\"FLASH\":\"FLASH\",\"GAME\":\"GameCredits\",\"GLC\":\"Goldcoin\",\"GRS\":\"Groestlcoin\",\"KMD\":\"Komodo\",\"LOKI\":\"LOKI\",\"LSK\":\"LSK\",\"MAID\":\"MaidSafeCoin\",\"MUE\":\"MonetaryUnit\",\"NAV\":\"NAV Coin\",\"NEO\":\"NEO\",\"NMC\":\"Namecoin\",\"NVST\":\"NVO Token\",\"NXT\":\"NXT\",\"OMNI\":\"OMNI\",\"PINK\":\"PinkCoin\",\"PIVX\":\"PIVX\",\"POT\":\"PotCoin\",\"PPC\":\"Peercoin\",\"PROC\":\"ProCurrency\",\"PURA\":\"PURA\",\"QTUM\":\"QTUM\",\"RES\":\"Resistance\",\"RVN\":\"Ravencoin\",\"RVR\":\"RevolutionVR\",\"SBD\":\"Steem Dollars\",\"SMART\":\"SmartCash\",\"SOXAX\":\"SOXAX\",\"STEEM\":\"STEEM\",\"STRAT\":\"STRAT\",\"SYS\":\"Syscoin\",\"TPAY\":\"TokenPay\",\"TRIGGERS\":\"Triggers\",\"TRX\":\" TRON\",\"UBQ\":\"Ubiq\",\"UNIT\":\"UniversalCurrency\",\"USDT\":\"Tether USD (Omni Layer)\",\"VTC\":\"Vertcoin\",\"WAVES\":\"Waves\",\"XCP\":\"Counterparty\",\"XEM\":\"NEM\",\"XMR\":\"Monero\",\"XSN\":\"Stakenet\",\"XSR\":\"SucreCoin\",\"XVG\":\"VERGE\",\"XZC\":\"ZCoin\",\"ZEC\":\"ZCash\",\"ZEN\":\"Horizen\"}}', '{\"callback\":\"ipn\"}', 'BTC', 'BTC', 0, '', 0.00004200, 10000.00000000, 0.00000000, 0.50000000, 0.00004200, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(23, 'blockchain', 'Blockchain', 18, '6369f932cde211667889458.jpg', 0, '{\"api_key\":\"\",\"xpub_code\":\"\"}', '{\"1\":{\"BTC\":\"BTC\"}}', NULL, 'BTC', 'BTC', 0, '', 0.00000000, 10000.00000000, 0.00000000, 0.50000000, 0.00000000, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(24, 'midtrans', 'Midtrans', 16, '63db5ec76455b1675321031.png', 0, '{\"client_key\":\"\",\"server_key\":\"\"}', '{\"0\":{\"IDR\":\"IDR\"}}', '{\"payment_notification_url\":\"ipn\", \"finish redirect_url\":\"ipn\", \"unfinish redirect_url\":\"failed\",\"error redirect_url\":\"failed\"}', 'IDR', 'IDR', 1, 'test', 1.00000000, 10000.00000000, 0.00000000, 0.05000000, 14835.20000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(25, 'cashmaal', 'cashmaal', 20, '6369f9384f75d1667889464.jpg', 0, '{\"web_id\":\"\",\"ipn_key\":\"\"}', '{\"0\":{\"PKR\":\"PKR\",\"USD\":\"USD\"}}', '{\"ipn_url\":\"ipn\"}', 'PKR', 'PKR', 0, '', 1.00000000, 100.00000000, 0.00000000, 0.00000000, 1.00000000, NULL, NULL, '2023-03-16 00:16:29'),
(26, 'binance', 'Binance', 17, '63d8e062e2c5f1675157602.png', 0, '{\"mercent_api_key\":\"\",\"mercent_secret\":\"\"}', '{\"1\":{\"ADA\":\"ADA\",\"ATOM\":\"ATOM\",\"AVA\":\"AVA\",\"BCH\":\"BCH\",\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"BUSD\":\"BUSD\",\"CTSI\":\"CTSI\",\"DASH\":\"DASH\",\"DOGE\":\"DOGE\",\"DOT\":\"DOT\",\"EGLD\":\"EGLD\",\"EOS\":\"EOS\",\"ETC\":\"ETC\",\"ETH\":\"ETH\",\"FIL\":\"FIL\",\"FRONT\":\"FRONT\",\"FTM\":\"FTM\",\"GRS\":\"GRS\",\"HBAR\":\"HBAR\",\"IOTX\":\"IOTX\",\"LINK\":\"LINK\",\"LTC\":\"LTC\",\"MANA\":\"MANA\",\"MATIC\":\"MATIC\",\"NEO\":\"NEO\",\"OM\":\"OM\",\"ONE\":\"ONE\",\"PAX\":\"PAX\",\"QTUM\":\"QTUM\",\"STRAX\":\"STRAX\",\"SXP\":\"SXP\",\"TRX\":\"TRX\",\"TUSD\":\"TUSD\",\"UNI\":\"UNI\",\"USDC\":\"USDC\",\"USDT\":\"USDT\",\"WRX\":\"WRX\",\"XLM\":\"XLM\",\"XMR\":\"XMR\",\"XRP\":\"XRP\",\"XTZ\":\"XTZ\",\"XVS\":\"XVS\",\"ZEC\":\"ZEC\",\"ZIL\":\"ZIL\"}}', '', 'USDT', 'BTC', 0, '', 0.00004200, 10000.00000000, 0.00000000, 0.50000000, 0.00004200, NULL, '2020-09-10 09:05:02', '2023-03-16 00:16:29'),
(27, 'peachpayments', 'peachpayments', 14, '63db5f625d8051675321186.png', 0, '{\"Authorization_Bearer\":\"\",\"Entity_ID\":\"\",\"Recur_Channel\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AFA\":\"AFA\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AWG\":\"AWG\",\"AZM\":\"AZM\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYR\":\"BYR\",\"BZD\":\"BZD\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CYP\":\"CYP\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EEK\":\"EEK\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GBP\":\"GBP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHC\":\"GHC\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"INR\":\"INR\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LTL\":\"LTL\",\"LVL\":\"LVL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MTL\":\"MTL\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"MZM\":\"MZM\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PTS\":\"PTS\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDD\":\"SDD\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"SHP\":\"SHP\",\"SIT\":\"SIT\",\"SKK\":\"SKK\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SPL\":\"SPL\",\"SRD\":\"SRD\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMM\":\"TMM\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TRL\":\"TRL\",\"TRY\":\"TRY\",\"TTD\":\"TTD\",\"TVD\":\"TVD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZAR\":\"ZAR\",\"ZMK\":\"ZMK\",\"ZWD\":\"ZWD\"}}', NULL, 'USD', 'USD', 1, 'test', 100.00000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, '', '2020-09-09 15:05:02', '2023-03-16 00:16:29'),
(28, 'nowpayments', 'Nowpayments', 5, '63db5fe0ecda91675321312.jpg', 0, '{\"api_key\":\"\"}', '{\"1\":{\"BTC\":\"BTC\",\"LTC\":\"LTC\",\"DOGE\":\"DOGE\"}}', '{\"cron\":\"ipn\"}', 'BTC', 'BTC', 0, '', 10.10000000, 10000.00000000, 0.00000000, 0.50000000, 1.00000000, NULL, '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(29, 'khalti', 'Khalti Payment', 9, '63db601dc202b1675321373.webp', 0, '{\"secret_key\":\"\",\"public_key\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, 'NPR', 'NPR', 1, 'live', 100.00000000, 10000.00000000, 0.00000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(30, 'swagger', 'MAGUA PAY', 7, '63db60dd217751675321565.png', 0, '{\"MAGUA_PAY_ACCOUNT\":\"\",\"MerchantKey\":\"\",\"Secret\":\"\"}', '{\"0\":{\"EUR\":\"EUR\"}}', NULL, 'EUR', 'EUR', 1, 'test', 100.00000000, 10000.00000000, 0.00000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(31, 'freekassa', 'Free kassa', 3, '63db6113451f11675321619.jpg', 0, '{\"merchant_id\":\"\",\"merchant_key\":\"\",\"secret_word\":\"\",\"secret_word2\":\"\"}', '{\"0\":{\"RUB\":\"RUB\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"UAH\":\"UAH\",\"KZT\":\"KZT\"}}', '{\"ipn_url\":\"ipn\"}', 'USD', 'RUB', 0, '', 10.00000000, 10000.00000000, 0.10000000, 0.00000000, 1.00000000, NULL, '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(32, 'konnect', 'Konnect', 19, '63db613ccb4d41675321660.jpg', 0, '{\"api_key\":\"\",\"receiver_wallet_Id\":\"\"}', '{\"0\":{\"TND\":\"TND\",\"EUR\":\"EUR\",\"USD\":\"USD\"}}', '{\"webhook\":\"ipn\"}', 'USD', 'USD', 1, 'live', 1.00000000, 10000.00000000, 0.00000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(33, 'mxpay', 'Mxpay Np', 11, '63db615bdda911675321691.png', 0, '{\"merchant_username\":\"\",\"merchant_api_password\":\"\",\"merchant_id\":\"\",\"api_key\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, 'NPR', 'NPR', 1, 'live', 1.00000000, 100000.00000000, 1.50000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(34, 'paythrow', 'PayThrow', 36, '63db62709b79c1675321968.jpg', 0, '{\"client_id\":\"\",\"client_secret\":\"\"}', '{\"0\":{\"PKR\":\"PKR\",\"USD\":\"USD\"}}', '{\"ipn_url\":\"ipn\"}', 'USD', 'USD', 0, '', 1.00000000, 10000.00000000, 0.00000000, 0.50000000, 157.96000000, NULL, '2020-09-09 15:05:02', '2023-03-16 00:16:29'),
(35, 'imepay', 'IME PAY', 12, '63db61ffa1f641675321855.png', 0, '{\"MerchantModule\":\"\",\"MerchantCode\":\"\",\"username\":\"\",\"password\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, 'NPR', 'NPR', 0, '', 1.00000000, 100000.00000000, 1.50000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29'),
(36, 'fastPay', 'FastPay', 1, '63f218a53bab51676810405.png', 0, '{\"store_id\":\"\",\"store_password\":\"\"}', '{\"0\":{\"IQD\":\"IQD\"}}', '{\"ipn_url\":\"ipn\"}', 'IQD', 'IQD', 1, 'live', 1.00000000, 100000.00000000, 1.50000000, 0.00000000, 1.00000000, '', '2020-09-09 09:05:02', '2023-03-16 00:16:29');

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

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

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `recuring_invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `invoice_number` varchar(255) DEFAULT NULL,
  `subtotal` double DEFAULT NULL,
  `percentage` decimal(10,8) DEFAULT NULL COMMENT 'percebt value of charge',
  `charge_percentage` decimal(10,8) DEFAULT NULL COMMENT 'value after percent charge',
  `charge_fixed` decimal(10,8) DEFAULT NULL COMMENT 'fixed charge',
  `charge` decimal(10,8) DEFAULT NULL COMMENT 'overall charge for currency',
  `tax` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `tax_rate` double DEFAULT NULL,
  `vat_rate` double DEFAULT NULL,
  `grand_total` decimal(8,2) DEFAULT NULL,
  `frequency` varchar(255) DEFAULT NULL COMMENT '1=>one Time, 2=>weekly, 3=>monthly',
  `has_slug` varchar(255) DEFAULT NULL COMMENT '1',
  `due_date` timestamp NULL DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `charge_pay` tinyint(4) DEFAULT 0 COMMENT '0=> sender , 1 receiver',
  `status` varchar(255) DEFAULT NULL COMMENT 'paid , pending , rejected',
  `seen_at` timestamp NULL DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `rejected_at` timestamp NULL DEFAULT NULL,
  `mark_as_paid_at` timestamp NULL DEFAULT NULL,
  `reminder_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 `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"ed8e8d5e-251b-4c08-8b67-f4c80396b68d\",\"displayName\":\"App\\\\Mail\\\\SendMail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":13:{s:8:\\\"mailable\\\";O:17:\\\"App\\\\Mail\\\\SendMail\\\":31:{s:10:\\\"from_email\\\";s:15:\\\"demo@mimeld.com\\\";s:10:\\\"site_title\\\";s:6:\\\"MXPay\\\";s:7:\\\"subject\\\";s:27:\\\"Reset Password Notification\\\";s:7:\\\"message\\\";s:42876:\\\"<meta http-equiv=\\\"X-UA-Compatible\\\" content=\\\"IE=edge\\\">\\r\\n<meta name=\\\"viewport\\\" content=\\\"width=device-width\\\">\\r\\n<style type=\\\"text\\/css\\\">\\r\\n    @media only screen and (min-width: 620px) {\\r\\n        * [lang=x-wrapper] h1 {\\r\\n        }\\r\\n\\r\\n        * [lang=x-wrapper] h1 {\\r\\n            font-size: 26px !important;\\r\\n            line-height: 34px !important\\r\\n        }\\r\\n\\r\\n        * [lang=x-wrapper] h2 {\\r\\n        }\\r\\n\\r\\n        * [lang=x-wrapper] h2 {\\r\\n            font-size: 20px !important;\\r\\n            line-height: 28px !important\\r\\n        }\\r\\n\\r\\n        * [lang=x-wrapper] h3 {\\r\\n        }\\r\\n\\r\\n        * [lang=x-layout__inner] p,\\r\\n        * [lang=x-layout__inner] ol,\\r\\n        * [lang=x-layout__inner] ul {\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-8] {\\r\\n            font-size: 8px !important;\\r\\n            line-height: 14px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-9] {\\r\\n            font-size: 9px !important;\\r\\n            line-height: 16px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-10] {\\r\\n            font-size: 10px !important;\\r\\n            line-height: 18px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-11] {\\r\\n            font-size: 11px !important;\\r\\n            line-height: 19px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-12] {\\r\\n            font-size: 12px !important;\\r\\n            line-height: 19px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-13] {\\r\\n            font-size: 13px !important;\\r\\n            line-height: 21px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-14] {\\r\\n            font-size: 14px !important;\\r\\n            line-height: 21px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-15] {\\r\\n            font-size: 15px !important;\\r\\n            line-height: 23px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-16] {\\r\\n            font-size: 16px !important;\\r\\n            line-height: 24px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-17] {\\r\\n            font-size: 17px !important;\\r\\n            line-height: 26px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-18] {\\r\\n            font-size: 18px !important;\\r\\n            line-height: 26px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-18] {\\r\\n            font-size: 18px !important;\\r\\n            line-height: 26px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-20] {\\r\\n            font-size: 20px !important;\\r\\n            line-height: 28px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-22] {\\r\\n            font-size: 22px !important;\\r\\n            line-height: 31px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-24] {\\r\\n            font-size: 24px !important;\\r\\n            line-height: 32px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-26] {\\r\\n            font-size: 26px !important;\\r\\n            line-height: 34px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-28] {\\r\\n            font-size: 28px !important;\\r\\n            line-height: 36px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-30] {\\r\\n            font-size: 30px !important;\\r\\n            line-height: 38px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-32] {\\r\\n            font-size: 32px !important;\\r\\n            line-height: 40px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-34] {\\r\\n            font-size: 34px !important;\\r\\n            line-height: 43px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-36] {\\r\\n            font-size: 36px !important;\\r\\n            line-height: 43px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-40] {\\r\\n            font-size: 40px !important;\\r\\n            line-height: 47px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-44] {\\r\\n            font-size: 44px !important;\\r\\n            line-height: 50px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-48] {\\r\\n            font-size: 48px !important;\\r\\n            line-height: 54px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-56] {\\r\\n            font-size: 56px !important;\\r\\n            line-height: 60px !important\\r\\n        }\\r\\n\\r\\n        * div [lang=x-size-64] {\\r\\n            font-size: 64px !important;\\r\\n            line-height: 63px !important\\r\\n        }\\r\\n    }\\r\\n<\\/style>\\r\\n<style type=\\\"text\\/css\\\">\\r\\n    body {\\r\\n        margin: 0;\\r\\n        padding: 0;\\r\\n    }\\r\\n\\r\\n    table {\\r\\n        border-collapse: collapse;\\r\\n        table-layout: fixed;\\r\\n    }\\r\\n\\r\\n    * {\\r\\n        line-height: inherit;\\r\\n    }\\r\\n\\r\\n    [x-apple-data-detectors],\\r\\n    [href^=\\\"tel\\\"],\\r\\n    [href^=\\\"sms\\\"] {\\r\\n        color: inherit !important;\\r\\n        text-decoration: none !important;\\r\\n    }\\r\\n\\r\\n    .wrapper .footer__share-button a:hover,\\r\\n    .wrapper .footer__share-button a:focus {\\r\\n        color: #ffffff !important;\\r\\n    }\\r\\n\\r\\n    .btn a:hover,\\r\\n    .btn a:focus,\\r\\n    .footer__share-button a:hover,\\r\\n    .footer__share-button a:focus,\\r\\n    .email-footer__links a:hover,\\r\\n    .email-footer__links a:focus {\\r\\n        opacity: 0.8;\\r\\n    }\\r\\n\\r\\n    .preheader,\\r\\n    .header,\\r\\n    .layout,\\r\\n    .column {\\r\\n        transition: width 0.25s ease-in-out, max-width 0.25s ease-in-out;\\r\\n    }\\r\\n\\r\\n    .layout,\\r\\n    .header {\\r\\n        max-width: 400px !important;\\r\\n        -fallback-width: 95% !important;\\r\\n        width: calc(100% - 20px) !important;\\r\\n    }\\r\\n\\r\\n    div.preheader {\\r\\n        max-width: 360px !important;\\r\\n        -fallback-width: 90% !important;\\r\\n        width: calc(100% - 60px) !important;\\r\\n    }\\r\\n\\r\\n    .snippet,\\r\\n    .webversion {\\r\\n        Float: none !important;\\r\\n    }\\r\\n\\r\\n    .column {\\r\\n        max-width: 400px !important;\\r\\n        width: 100% !important;\\r\\n    }\\r\\n\\r\\n    .fixed-width.has-border {\\r\\n        max-width: 402px !important;\\r\\n    }\\r\\n\\r\\n    .fixed-width.has-border .layout__inner {\\r\\n        box-sizing: border-box;\\r\\n    }\\r\\n\\r\\n    .snippet,\\r\\n    .webversion {\\r\\n        width: 50% !important;\\r\\n    }\\r\\n\\r\\n    .ie .btn {\\r\\n        width: 100%;\\r\\n    }\\r\\n\\r\\n    .ie .column,\\r\\n    [owa] .column,\\r\\n    .ie .gutter,\\r\\n    [owa] .gutter {\\r\\n        display: table-cell;\\r\\n        float: none !important;\\r\\n        vertical-align: top;\\r\\n    }\\r\\n\\r\\n    .ie div.preheader,\\r\\n    [owa] div.preheader,\\r\\n    .ie .email-footer,\\r\\n    [owa] .email-footer {\\r\\n        max-width: 560px !important;\\r\\n        width: 560px !important;\\r\\n    }\\r\\n\\r\\n    .ie .snippet,\\r\\n    [owa] .snippet,\\r\\n    .ie .webversion,\\r\\n    [owa] .webversion {\\r\\n        width: 280px !important;\\r\\n    }\\r\\n\\r\\n    .ie .header,\\r\\n    [owa] .header,\\r\\n    .ie .layout,\\r\\n    [owa] .layout,\\r\\n    .ie .one-col .column,\\r\\n    [owa] .one-col .column {\\r\\n        max-width: 600px !important;\\r\\n        width: 600px !important;\\r\\n    }\\r\\n\\r\\n    .ie .fixed-width.has-border,\\r\\n    [owa] .fixed-width.has-border,\\r\\n    .ie .has-gutter.has-border,\\r\\n    [owa] .has-gutter.has-border {\\r\\n        max-width: 602px !important;\\r\\n        width: 602px !important;\\r\\n    }\\r\\n\\r\\n    .ie .two-col .column,\\r\\n    [owa] .two-col .column {\\r\\n        width: 300px !important;\\r\\n    }\\r\\n\\r\\n    .ie .three-col .column,\\r\\n    [owa] .three-col .column,\\r\\n    .ie .narrow,\\r\\n    [owa] .narrow {\\r\\n        width: 200px !important;\\r\\n    }\\r\\n\\r\\n    .ie .wide,\\r\\n    [owa] .wide {\\r\\n        width: 400px !important;\\r\\n    }\\r\\n\\r\\n    .ie .two-col.has-gutter .column,\\r\\n    [owa] .two-col.x_has-gutter .column {\\r\\n        width: 290px !important;\\r\\n    }\\r\\n\\r\\n    .ie .three-col.has-gutter .column,\\r\\n    [owa] .three-col.x_has-gutter .column,\\r\\n    .ie .has-gutter .narrow,\\r\\n    [owa] .has-gutter .narrow {\\r\\n        width: 188px !important;\\r\\n    }\\r\\n\\r\\n    .ie .has-gutter .wide,\\r\\n    [owa] .has-gutter .wide {\\r\\n        width: 394px !important;\\r\\n    }\\r\\n\\r\\n    .ie .two-col.has-gutter.has-border .column,\\r\\n    [owa] .two-col.x_has-gutter.x_has-border .column {\\r\\n        width: 292px !important;\\r\\n    }\\r\\n\\r\\n    .ie .three-col.has-gutter.has-border .column,\\r\\n    [owa] .three-col.x_has-gutter.x_has-border .column,\\r\\n    .ie .has-gutter.has-border .narrow,\\r\\n    [owa] .has-gutter.x_has-border .narrow {\\r\\n        width: 190px !important;\\r\\n    }\\r\\n\\r\\n    .ie .has-gutter.has-border .wide,\\r\\n    [owa] .has-gutter.x_has-border .wide {\\r\\n        width: 396px !important;\\r\\n    }\\r\\n\\r\\n    .ie .fixed-width .layout__inner {\\r\\n        border-left: 0 none white !important;\\r\\n        border-right: 0 none white !important;\\r\\n    }\\r\\n\\r\\n    .ie .layout__edges {\\r\\n        display: none;\\r\\n    }\\r\\n\\r\\n    .mso .layout__edges {\\r\\n        font-size: 0;\\r\\n    }\\r\\n\\r\\n    .layout-fixed-width,\\r\\n    .mso .layout-full-width {\\r\\n        background-color: #ffffff;\\r\\n    }\\r\\n\\r\\n    @media only screen and (min-width: 620px) {\\r\\n\\r\\n        .column,\\r\\n        .gutter {\\r\\n            display: table-cell;\\r\\n            Float: none !important;\\r\\n            vertical-align: top;\\r\\n        }\\r\\n\\r\\n        div.preheader,\\r\\n        .email-footer {\\r\\n            max-width: 560px !important;\\r\\n            width: 560px !important;\\r\\n        }\\r\\n\\r\\n        .snippet,\\r\\n        .webversion {\\r\\n            width: 280px !important;\\r\\n        }\\r\\n\\r\\n        .header,\\r\\n        .layout,\\r\\n        .one-col .column {\\r\\n            max-width: 600px !important;\\r\\n            width: 600px !important;\\r\\n        }\\r\\n\\r\\n        .fixed-width.has-border,\\r\\n        .fixed-width.ecxhas-border,\\r\\n        .has-gutter.has-border,\\r\\n        .has-gutter.ecxhas-border {\\r\\n            max-width: 602px !important;\\r\\n            width: 602px !important;\\r\\n        }\\r\\n\\r\\n        .two-col .column {\\r\\n            width: 300px !important;\\r\\n        }\\r\\n\\r\\n        .three-col .column,\\r\\n        .column.narrow {\\r\\n            width: 200px !important;\\r\\n        }\\r\\n\\r\\n        .column.wide {\\r\\n            width: 400px !important;\\r\\n        }\\r\\n\\r\\n        .two-col.has-gutter .column,\\r\\n        .two-col.ecxhas-gutter .column {\\r\\n            width: 290px !important;\\r\\n        }\\r\\n\\r\\n        .three-col.has-gutter .column,\\r\\n        .three-col.ecxhas-gutter .column,\\r\\n        .has-gutter .narrow {\\r\\n            width: 188px !important;\\r\\n        }\\r\\n\\r\\n        .has-gutter .wide {\\r\\n            width: 394px !important;\\r\\n        }\\r\\n\\r\\n        .two-col.has-gutter.has-border .column,\\r\\n        .two-col.ecxhas-gutter.ecxhas-border .column {\\r\\n            width: 292px !important;\\r\\n        }\\r\\n\\r\\n        .three-col.has-gutter.has-border .column,\\r\\n        .three-col.ecxhas-gutter.ecxhas-border .column,\\r\\n        .has-gutter.has-border .narrow,\\r\\n        .has-gutter.ecxhas-border .narrow {\\r\\n            width: 190px !important;\\r\\n        }\\r\\n\\r\\n        .has-gutter.has-border .wide,\\r\\n        .has-gutter.ecxhas-border .wide {\\r\\n            width: 396px !important;\\r\\n        }\\r\\n    }\\r\\n\\r\\n    @media only screen and (-webkit-min-device-pixel-ratio: 2), only screen and (min--moz-device-pixel-ratio: 2), only screen and (-o-min-device-pixel-ratio: 2\\/1), only screen and (min-device-pixel-ratio: 2), only screen and (min-resolution: 192dpi), only screen and (min-resolution: 2dppx) {\\r\\n        .fblike {\\r\\n            background-image: url(https:\\/\\/i3.createsend1.com\\/static\\/eb\\/customise\\/13-the-blueprint-3\\/images\\/fblike@2x.png) !important;\\r\\n        }\\r\\n\\r\\n        .tweet {\\r\\n            background-image: url(https:\\/\\/i4.createsend1.com\\/static\\/eb\\/customise\\/13-the-blueprint-3\\/images\\/tweet@2x.png) !important;\\r\\n        }\\r\\n\\r\\n        .linkedinshare {\\r\\n            background-image: url(https:\\/\\/i6.createsend1.com\\/static\\/eb\\/customise\\/13-the-blueprint-3\\/images\\/lishare@2x.png) !important;\\r\\n        }\\r\\n\\r\\n        .forwardtoafriend {\\r\\n            background-image: url(https:\\/\\/i5.createsend1.com\\/static\\/eb\\/customise\\/13-the-blueprint-3\\/images\\/forward@2x.png) !important;\\r\\n        }\\r\\n    }\\r\\n\\r\\n    @media (max-width: 321px) {\\r\\n        .fixed-width.has-border .layout__inner {\\r\\n            border-width: 1px 0 !important;\\r\\n        }\\r\\n\\r\\n        .layout,\\r\\n        .column {\\r\\n            min-width: 320px !important;\\r\\n            width: 320px !important;\\r\\n        }\\r\\n\\r\\n        .border {\\r\\n            display: none;\\r\\n        }\\r\\n    }\\r\\n\\r\\n    .mso div {\\r\\n        border: 0 none white !important;\\r\\n    }\\r\\n\\r\\n    .mso .w560 .divider {\\r\\n        margin-left: 260px !important;\\r\\n        margin-right: 260px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w360 .divider {\\r\\n        margin-left: 160px !important;\\r\\n        margin-right: 160px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w260 .divider {\\r\\n        margin-left: 110px !important;\\r\\n        margin-right: 110px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w160 .divider {\\r\\n        margin-left: 60px !important;\\r\\n        margin-right: 60px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w354 .divider {\\r\\n        margin-left: 157px !important;\\r\\n        margin-right: 157px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w250 .divider {\\r\\n        margin-left: 105px !important;\\r\\n        margin-right: 105px !important;\\r\\n    }\\r\\n\\r\\n    .mso .w148 .divider {\\r\\n        margin-left: 54px !important;\\r\\n        margin-right: 54px !important;\\r\\n    }\\r\\n\\r\\n    .mso .font-avenir,\\r\\n    .mso .font-cabin,\\r\\n    .mso .font-open-sans,\\r\\n    .mso .font-ubuntu {\\r\\n        font-family: sans-serif !important;\\r\\n    }\\r\\n\\r\\n    .mso .font-bitter,\\r\\n    .mso .font-merriweather,\\r\\n    .mso .font-pt-serif {\\r\\n        font-family: Georgia, serif !important;\\r\\n    }\\r\\n\\r\\n    .mso .font-lato,\\r\\n    .mso .font-roboto {\\r\\n        font-family: Tahoma, sans-serif !important;\\r\\n    }\\r\\n\\r\\n    .mso .font-pt-sans {\\r\\n        font-family: \\\"Trebuchet MS\\\", sans-serif !important;\\r\\n    }\\r\\n\\r\\n    .mso .footer__share-button p {\\r\\n        margin: 0;\\r\\n    }\\r\\n\\r\\n    @media only screen and (min-width: 620px) {\\r\\n        .wrapper .size-8 {\\r\\n            font-size: 8px !important;\\r\\n            line-height: 14px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-9 {\\r\\n            font-size: 9px !important;\\r\\n            line-height: 16px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-10 {\\r\\n            font-size: 10px !important;\\r\\n            line-height: 18px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-11 {\\r\\n            font-size: 11px !important;\\r\\n            line-height: 19px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-12 {\\r\\n            font-size: 12px !important;\\r\\n            line-height: 19px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-13 {\\r\\n            font-size: 13px !important;\\r\\n            line-height: 21px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-14 {\\r\\n            font-size: 14px !important;\\r\\n            line-height: 21px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-15 {\\r\\n            font-size: 15px !important;\\r\\n            line-height: 23px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-16 {\\r\\n            font-size: 16px !important;\\r\\n            line-height: 24px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-17 {\\r\\n            font-size: 17px !important;\\r\\n            line-height: 26px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-18 {\\r\\n            font-size: 18px !important;\\r\\n            line-height: 26px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-20 {\\r\\n            font-size: 20px !important;\\r\\n            line-height: 28px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-22 {\\r\\n            font-size: 22px !important;\\r\\n            line-height: 31px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-24 {\\r\\n            font-size: 24px !important;\\r\\n            line-height: 32px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-26 {\\r\\n            font-size: 26px !important;\\r\\n            line-height: 34px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-28 {\\r\\n            font-size: 28px !important;\\r\\n            line-height: 36px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-30 {\\r\\n            font-size: 30px !important;\\r\\n            line-height: 38px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-32 {\\r\\n            font-size: 32px !important;\\r\\n            line-height: 40px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-34 {\\r\\n            font-size: 34px !important;\\r\\n            line-height: 43px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-36 {\\r\\n            font-size: 36px !important;\\r\\n            line-height: 43px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-40 {\\r\\n            font-size: 40px !important;\\r\\n            line-height: 47px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-44 {\\r\\n            font-size: 44px !important;\\r\\n            line-height: 50px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-48 {\\r\\n            font-size: 48px !important;\\r\\n            line-height: 54px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-56 {\\r\\n            font-size: 56px !important;\\r\\n            line-height: 60px !important;\\r\\n        }\\r\\n\\r\\n        .wrapper .size-64 {\\r\\n            font-size: 64px !important;\\r\\n            line-height: 63px !important;\\r\\n        }\\r\\n    }\\r\\n\\r\\n    .mso .size-8,\\r\\n    .ie .size-8 {\\r\\n        font-size: 8px !important;\\r\\n        line-height: 14px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-9,\\r\\n    .ie .size-9 {\\r\\n        font-size: 9px !important;\\r\\n        line-height: 16px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-10,\\r\\n    .ie .size-10 {\\r\\n        font-size: 10px !important;\\r\\n        line-height: 18px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-11,\\r\\n    .ie .size-11 {\\r\\n        font-size: 11px !important;\\r\\n        line-height: 19px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-12,\\r\\n    .ie .size-12 {\\r\\n        font-size: 12px !important;\\r\\n        line-height: 19px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-13,\\r\\n    .ie .size-13 {\\r\\n        font-size: 13px !important;\\r\\n        line-height: 21px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-14,\\r\\n    .ie .size-14 {\\r\\n        font-size: 14px !important;\\r\\n        line-height: 21px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-15,\\r\\n    .ie .size-15 {\\r\\n        font-size: 15px !important;\\r\\n        line-height: 23px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-16,\\r\\n    .ie .size-16 {\\r\\n        font-size: 16px !important;\\r\\n        line-height: 24px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-17,\\r\\n    .ie .size-17 {\\r\\n        font-size: 17px !important;\\r\\n        line-height: 26px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-18,\\r\\n    .ie .size-18 {\\r\\n        font-size: 18px !important;\\r\\n        line-height: 26px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-20,\\r\\n    .ie .size-20 {\\r\\n        font-size: 20px !important;\\r\\n        line-height: 28px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-22,\\r\\n    .ie .size-22 {\\r\\n        font-size: 22px !important;\\r\\n        line-height: 31px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-24,\\r\\n    .ie .size-24 {\\r\\n        font-size: 24px !important;\\r\\n        line-height: 32px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-26,\\r\\n    .ie .size-26 {\\r\\n        font-size: 26px !important;\\r\\n        line-height: 34px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-28,\\r\\n    .ie .size-28 {\\r\\n        font-size: 28px !important;\\r\\n        line-height: 36px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-30,\\r\\n    .ie .size-30 {\\r\\n        font-size: 30px !important;\\r\\n        line-height: 38px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-32,\\r\\n    .ie .size-32 {\\r\\n        font-size: 32px !important;\\r\\n        line-height: 40px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-34,\\r\\n    .ie .size-34 {\\r\\n        font-size: 34px !important;\\r\\n        line-height: 43px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-36,\\r\\n    .ie .size-36 {\\r\\n        font-size: 36px !important;\\r\\n        line-height: 43px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-40,\\r\\n    .ie .size-40 {\\r\\n        font-size: 40px !important;\\r\\n        line-height: 47px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-44,\\r\\n    .ie .size-44 {\\r\\n        font-size: 44px !important;\\r\\n        line-height: 50px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-48,\\r\\n    .ie .size-48 {\\r\\n        font-size: 48px !important;\\r\\n        line-height: 54px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-56,\\r\\n    .ie .size-56 {\\r\\n        font-size: 56px !important;\\r\\n        line-height: 60px !important;\\r\\n    }\\r\\n\\r\\n    .mso .size-64,\\r\\n    .ie .size-64 {\\r\\n        font-size: 64px !important;\\r\\n        line-height: 63px !important;\\r\\n    }\\r\\n\\r\\n    .footer__share-button p {\\r\\n        margin: 0;\\r\\n    }\\r\\n<\\/style>\\r\\n\\r\\n<title><\\/title>\\r\\n<!--[if !mso]><!-->\\r\\n<style type=\\\"text\\/css\\\">\\r\\n    @import url(https:\\/\\/fonts.googleapis.com\\/css?family=Bitter:400,700,400italic|Cabin:400,700,400italic,700italic|Open+Sans:400italic,700italic,700,400);\\r\\n<\\/style>\\r\\n<link href=\\\"https:\\/\\/fonts.googleapis.com\\/css?family=Bitter:400,700,400italic|Cabin:400,700,400italic,700italic|Open+Sans:400italic,700italic,700,400\\\" rel=\\\"stylesheet\\\" type=\\\"text\\/css\\\">\\r\\n<!--<![endif]-->\\r\\n<style type=\\\"text\\/css\\\">\\r\\n    body {\\r\\n        background-color: #f5f7fa\\r\\n    }\\r\\n\\r\\n    .mso h1 {\\r\\n    }\\r\\n\\r\\n    .mso h1 {\\r\\n        font-family: sans-serif !important\\r\\n    }\\r\\n\\r\\n    .mso h2 {\\r\\n    }\\r\\n\\r\\n    .mso h3 {\\r\\n    }\\r\\n\\r\\n    .mso .column,\\r\\n    .mso .column__background td {\\r\\n    }\\r\\n\\r\\n    .mso .column,\\r\\n    .mso .column__background td {\\r\\n        font-family: sans-serif !important\\r\\n    }\\r\\n\\r\\n    .mso .btn a {\\r\\n    }\\r\\n\\r\\n    .mso .btn a {\\r\\n        font-family: sans-serif !important\\r\\n    }\\r\\n\\r\\n    .mso .webversion,\\r\\n    .mso .snippet,\\r\\n    .mso .layout-email-footer td,\\r\\n    .mso .footer__share-button p {\\r\\n    }\\r\\n\\r\\n    .mso .webversion,\\r\\n    .mso .snippet,\\r\\n    .mso .layout-email-footer td,\\r\\n    .mso .footer__share-button p {\\r\\n        font-family: sans-serif !important\\r\\n    }\\r\\n\\r\\n    .mso .logo {\\r\\n    }\\r\\n\\r\\n    .mso .logo {\\r\\n        font-family: Tahoma, sans-serif !important\\r\\n    }\\r\\n\\r\\n    .logo a:hover,\\r\\n    .logo a:focus {\\r\\n        color: #859bb1 !important\\r\\n    }\\r\\n\\r\\n    .mso .layout-has-border {\\r\\n        border-top: 1px solid #b1c1d8;\\r\\n        border-bottom: 1px solid #b1c1d8\\r\\n    }\\r\\n\\r\\n    .mso .layout-has-bottom-border {\\r\\n        border-bottom: 1px solid #b1c1d8\\r\\n    }\\r\\n\\r\\n    .mso .border,\\r\\n    .ie .border {\\r\\n        background-color: #b1c1d8\\r\\n    }\\r\\n\\r\\n    @media only screen and (min-width: 620px) {\\r\\n        .wrapper h1 {\\r\\n        }\\r\\n\\r\\n        .wrapper h1 {\\r\\n            font-size: 26px !important;\\r\\n            line-height: 34px !important\\r\\n        }\\r\\n\\r\\n        .wrapper h2 {\\r\\n        }\\r\\n\\r\\n        .wrapper h2 {\\r\\n            font-size: 20px !important;\\r\\n            line-height: 28px !important\\r\\n        }\\r\\n\\r\\n        .wrapper h3 {\\r\\n        }\\r\\n\\r\\n        .column p,\\r\\n        .column ol,\\r\\n        .column ul {\\r\\n        }\\r\\n    }\\r\\n\\r\\n    .mso h1,\\r\\n    .ie h1 {\\r\\n    }\\r\\n\\r\\n    .mso h1,\\r\\n    .ie h1 {\\r\\n        font-size: 26px !important;\\r\\n        line-height: 34px !important\\r\\n    }\\r\\n\\r\\n    .mso h2,\\r\\n    .ie h2 {\\r\\n    }\\r\\n\\r\\n    .mso h2,\\r\\n    .ie h2 {\\r\\n        font-size: 20px !important;\\r\\n        line-height: 28px !important\\r\\n    }\\r\\n\\r\\n    .mso h3,\\r\\n    .ie h3 {\\r\\n    }\\r\\n\\r\\n    .mso .layout__inner p,\\r\\n    .ie .layout__inner p,\\r\\n    .mso .layout__inner ol,\\r\\n    .ie .layout__inner ol,\\r\\n    .mso .layout__inner ul,\\r\\n    .ie .layout__inner ul {\\r\\n    }\\r\\n<\\/style>\\r\\n<meta name=\\\"robots\\\" content=\\\"noindex,nofollow\\\">\\r\\n\\r\\n<meta property=\\\"og:title\\\" content=\\\"Just One More Step\\\">\\r\\n\\r\\n<link href=\\\"https:\\/\\/css.createsend1.com\\/css\\/social.min.css?h=0ED47CE120160920\\\" media=\\\"screen,projection\\\" rel=\\\"stylesheet\\\" type=\\\"text\\/css\\\">\\r\\n\\r\\n\\r\\n<div class=\\\"wrapper\\\" style=\\\"min-width: 320px;background-color: #f5f7fa;\\\" lang=\\\"x-wrapper\\\">\\r\\n    <div class=\\\"preheader\\\" style=\\\"margin: 0 auto;max-width: 560px;min-width: 280px; width: 280px;\\\">\\r\\n        <div style=\\\"border-collapse: collapse;display: table;width: 100%;\\\">\\r\\n            <div class=\\\"snippet\\\" style=\\\"display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 140px; width: 140px;padding: 10px 0 5px 0;color: #b9b9b9;\\\">\\r\\n            <\\/div>\\r\\n            <div class=\\\"webversion\\\" style=\\\"display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 139px; width: 139px;padding: 10px 0 5px 0;text-align: right;color: #b9b9b9;\\\">\\r\\n            <\\/div>\\r\\n        <\\/div>\\r\\n\\r\\n        <div class=\\\"layout one-col fixed-width\\\" style=\\\"margin: 0 auto;max-width: 600px;min-width: 320px; width: 320px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;\\\">\\r\\n            <div class=\\\"layout__inner\\\" style=\\\"border-collapse: collapse;display: table;width: 100%;background-color: #c4e5dc;\\\" lang=\\\"x-layout__inner\\\">\\r\\n                <div class=\\\"column\\\" style=\\\"text-align: left;color: #60666d;font-size: 14px;line-height: 21px;max-width:600px;min-width:320px;\\\">\\r\\n                    <div style=\\\"margin-left: 20px;margin-right: 20px;margin-top: 24px;margin-bottom: 24px;\\\">\\r\\n                        <h1 style=\\\"margin-top: 0;margin-bottom: 0;font-style: normal;font-weight: normal;color: #44a8c7;font-size: 36px;line-height: 43px;font-family: bitter,georgia,serif;text-align: center;\\\">\\r\\n                            <img style=\\\"width: 200px;\\\" src=\\\"data:image\\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAAAwCAYAAABUmTXqAAAABGdBTUEAALGPC\\/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAABmJLR0QA\\/wD\\/AP+gvaeTAAAAB3RJTUUH5gsOBCMe2Gn2wwAAAAFvck5UAc+id5oAACxkSURBVHja7X15eFRFuv5b53T36SXd2fcQCPsSBGUVFUXBBXdFxnXcddwV0FHn+rvOjHecGXdFx33XGUVccEdBEAERlN0ohCRkTyfp\\/fTZq35\\/VHfohIQ06FznzvA+Tx6SQ1WdOnXqq2\\/\\/DgEA\\/YqjAUAAIKI7CAATAAUAx7MrkdKeALBhb7BEH6T26YnEGEnY0TuM5Bg92tsS9+8JEwDr654HcRD7CwJ0bdYTAcwH3+BJCAAaAPw3gPoefQcDeBCAJ6UPARAHcB+Ar5INe27YHpt9DoArEvdKvW8jgJsBhHrc9zAAdwLI7DFXA8DtALYeJJCD+LmQygHKAMzso91AAFcBqE655gMwC4C7l\\/ZjAVwN4DOAE0QP7pPEJQAeAJDTyxh1ABw9rh0O4FkAo3tpTwH89RddzYP4t0PqqU330W4GgFcAVKZc6yZK9UAFgBcBnJ68oF9xdCpxCACuA\\/AoeicO9DL2cYk5jN5He4aDOIifEcJ+tJ0K4FUAE9NsXwLgGQDn97huA7AAXAzzpjnWqeAEN+SXWqiD+M9EKoGQNNqPAyeSaeAcp78++QAeB3Bl4m8JwP8D8EcArn76EnCOcA64WFWWxvzSeYaDOIi0kaqDxME3ZH+bbAS4qPNnADL65wJZAB4CV6qLwBVvEf0jCmAuODFlp9FeB6D+by7eQfz7I5VAPgTXCW5A\\/6LXYHDd4Q4AD4Nv\\/n3BA+BP6N2U3BvqE2PPQXrEEQdwN4CN\\/5uL96+Oq6\\/+C9xuJ8LhGASBwOVyglKKxx9f8EtP7f8MUgkkAm4mjQG4DX37JpLQwfUCDcAj4OLUvtDfeEnsBBfJVgI4M432YQC\\/BfA0DkBJd7uPSasdYwx2uw0jRw7CN988h+nTr8GXX\\/5tf2\\/3T0dR0cnIy8tEW1sAr7zyMeLxEObNuzSHMWZ76KGb\\/ZmZM+F2H4MhQ0px+OFj0dkZxuLF9\\/7S0\\/6XhQ3o5ohTAfweXHT6fwCc++ibFMX+Dn6CPwGumP8UbAUnjnU97tEXOgHcAi7yIfksB4CJAC5AHwRGCFBYmMMkyfEVpfQ7ALsJIZg27SqsWfP0T3zknw95eSdCVXWMHz9cWLVq86EOh+MMQohvyZJVh9tsYkZm5swVoihoZWUlO02TrozH1R9VVTd\\/+p3\\/fdFtA\\/Zihv0TgIw++s4HdxQmMQvAU+Am3gPBN+DEsSXl2tPYo+D3REtiju8kLxwIcSQ4yCUAXthXO0EQAMBwu6X64uK8ZysqSh72+4Pqrl2NaGv76AAf+efDlCmXQ9MMtLUFihhjv5dl9UzGaD6lDIxxuieEdP3k5vo2Dhs24LhYTAl+\\/fWzv\\/T0\\/2VhA\\/Zy3gHcQvUYuPhyP7j4lHq6Eux92n4G4Dxw0+5Y7J+4sxzcEVnT4zrr8W\\/y3jsBXANgWWrj5HMcAKHs5QMihIAx1vUvpRQA7LGYMqS+vvWeQCDSnJHhenn06EFoa+N9fL7jAACWRbs2JcCJS5K4hNnZ+SkAQJKmw+NxQtOMbm2TiMdXYPLky+B0OrBrVxOCwWjXvCTJBsaAYPAzAMDll\\/8Pqqrq4PN5yhob\\/U8qinZyT6IAuJiY\\/AHw49y5x8krVmxEcfHt2LRpB1pbO7va9gWfz4Oysnwoiobt2\\/8OADjmmGvh8TixfXstolEZxx8\\/FaIoYMuWajQ2tmPatLHYvr0GmZkZaGz0Q5ZVEAJIkgO5uT4QQrBz56JexV2324ncXB903URbW2Cfc2OMobg4D6NGDQIhBB98cH\\/KOMfgQJCqg5QDOBTdN2MEnEvUgjviUlevDjw8JdXbTcFP4mCib3\\/KvgWgMDHuKOxxRBJwK9aLAD5PmRMFV\\/gLwT34p\\/W491pwsesnQRQFbdCg4iVtbYH3MjMzjuroCB1pGOYYSvk0NM0QKZWvz8nxfhIOy\\/6uh7EoZLmZeDzFnsSzJ62CrLOzXi4qGtxFiIQQxOOqixDBTghvZ5qWceedv1a2b6\\/FokUrIMsK\\/P5O2GyiB9y4wRhjhDFojDEtdazVq58WKivPn69p+skpBBfIysr4Kj8\\/uzoSkQdHIvIIVdUGMwYpHle33nXX0\\/r48cPhdDoExuBOmXNfIIJALEmyxy3LYgBw8cX3YO3aLdixYxfGjBnuiURkG8AOYYx5GGMb7HZRGzCgQJdlRQsEIiL2RF4QxhizLBonBFbyBozBQQicybWjlFmmSeOWRZPzcib2XG\\/zJC6XxD788IHo4MFnIS\\/vBAiCAL\\/\\/4+T\\/29C\\/eyEJBYCZSiAzATyH7qcpARAAV9578uGxAP4BHnKSGoulA3gy0ac\\/s2sBuJ\\/kTHQnPgGcSxwOvum79i54XNj8xIOmLpIO4AQAX6a5AH3CsmjA7w\\/e5vcH6vz+j18bOfJXQ1pbA6\\/qujE1pc24xsb2UYQQPwDMnj0Pa9duRU7OyHHBYGQhYywZo0YAaMOGVd7c3NzxdbK\\/YZgYM6bi8rq6lqtM0zIBiJJk3\\/z22yuvyc31yb\\/5zV+wZcsu5OT4yquqdj8DfihAEEiYEHITgE3JsVau3Ihx4y7y+f2hmZbVjRk+19i45LYEFyTHHXd9yebN1ROzs70LSkrytsbjKiTJDofDXiQI5MXE+9hXRIWoaUZ1W1vwMlXVwxdeeDe+\\/bYKmZme8aWlJae1tHTOVFXdt2LFdxWCIEjhsLxTEAhdvXrLphEjyq8Ph2NDCSFPAswBEAgCUSXJfjUhpEusJgS\\/AnAr+IEsiqJQ43Q6LhUEEko0uQHAr5EIZE0FIYS0tQWswsLZK+12+6elpUVLdV3DhAm3YOXKjQAwGdxS29\\/BTRP3WdtbNG7PzrngVqoscH+GldKOpPwkIQG4Cdz0Ox+cwHqLxaoA11lm9TFJgu4m4QwA\\/wPg+pQ59iSqnwssGo3D7XYhO\\/tU7N7dumvw4NKN9fWtU5MbkFKKeFzruv\\/QoWX46KPP4HINOhvAET0HtCx6NmPs66FD56C6+i0cccRYeDyuNe3twbtCIbmAEEAQhFEA3t+w4YdFy5c\\/DkIIDjvs4osMwzw+OY7DYX8jO9tXpSgagkF+raHBD4B1E6cAQBQFJwAUFs7G6NHnsdLS\\/KbOzvqm00674AtBEGLxuArGGJxOh8NmEw9Bggh7XRAGAAwej8s9eHCpDQCmTTvE\\/uOP9ddXVzdcZxjWkIQYilAoxl8OIZWUAm1tAf+cOTOMpqb2DEEghwGwMcYgiqLu8bg8gsDnbLfbIAikSNfNsUkuaLeLLq\\/XLSpKF8McgO4hT2CMG1IAIB5XQQgmKIp2sSiK85Ys+eurixd\\/QRMEkglgwj5f\\/J4jN3N\\/NpUbfHPehb0DCPvCJeCcpAjYKxZrFLjlaVaaY2WDE+mN+zHnnwUnnDAFhmHB53P3lM+77cfPP1+PCRMm5Oi6cSKl3bk\\/pRSdneHKIUPKPKLIaX7hwvn4+OOHvsvNzXzJZuOPZJqmva0tcE5l5RBx+vRrcOKJNw9rawtcbhjc0ORw2DtzcnyPGIappTJPl0tCRoYLNpvYbW0YY5dlZc16UBSFsUccMZZs3LgDY8YcimAwEmlubqehUBQejwsZGW7YbKLV49ED4P6oBgANbrek8bau7088caq8ZctO3HvvSyfs2tX4B00zuohDFAWDENIoCEKLzSYmF2nL4sUrVJfLSQRB6LqPzSZaXq8bPp+n6zk8HhdNEgwA2O02mpWVgYyMLsmoG4ez222B3FxfvdsttdhsIidjBhiGmWuzCQ\\/feuvCyd98833XkmDPAQ9BEJggkLbkMxJCmj0eJ\\/V4nHC7JeZ2S73mc\\/QFB4DfgesA\\/4V9s+IkzgEnrmsSkwC4nvMM+qHkBCwAeeAGg3P3Y64\\/GZRSJkkONDW1o67ubXHq1CtyLWvPHhJFIeL1uiOEEIwbdyXa2gIwDHOSrhujAIAQYni97mAsphRQSkEpmxKPq6N03dhwySV\\/xAsvfIhjj70edrvtmc7O8JxwWK5gDJBldUZdXcvklpbNa4cPP\\/yKSESuSLxM5Ob6Fj344I3rnnrqXXz44R4D4tChZRg7dnBs6dJvvg6FoqOTBEop8zBm3hKNKue+9daKd0VReCkjw\\/3tmjVbzTlzZqChwQ+PxwmPx8mSmysxdwgC+aNpWm8QQmyEAFOnjploWXRAPK6u\\/uijNerkyWPKv\\/nm+3sVRctInhJ2u22bz+f5azgcW5md7XVKkuMoRdFmUEoXiaIAp9MBMYWGRVFARoYLyUPD6XTA4bAjEol3bS+bzQafzwPWh2bEGPvTYYeNeC0QiGQ0Nvov8PuDdwCQEjqeb9u2mj6d2Ha7bX1WVsZlLS0dYUIIyc72OsaPH3aEqhoZpmlVEbJ3DkZ\\/sIGLTfeDi17pxD6dDOBlAEOxJ+AxHeIg4GLYc0iPOJIi30+G3W4TDz10eFY43ICRIweJEydeerIsK8enviSXS1o\\/fPjAraWlBWCMoaZmMWIx5STLsjyMAW631F5QkH0nIVzEZIxma5p+UkPDevh8Hjz00M049NDh+PTThTuzsrzPJzcJpTSPUnrNlCnHT+rsDF\\/ILWKAx+PcNWJE+ROPPrqIalp38VvTdKxdu83Mz8+6z+VyrkvldIwBlmUV67pxjaYZH+3YUf+s3W4b+vjjt5Li4lxIkh0TJoxo8fuDq5P9BIHA63X7nU5Hi8Nhb5DlFQ2zZk3+4pNPHn6UUvZtfX0bvv++boqiaJXJPoSQsCgK18ZiyiuMoV7TjB2yrDx36aWzL2lvD6wbNqwMbreUNJfzzWQTkZHh7uIOTqcj0YZ0zd1uF+HzeeDx9O6SM02rc\\/3671tbWzurDcNabLfb9NRn54cT7aOv2VRb+\\/Z2h8Pe6HJJDXV17+yePXvaexs2VD1hWVa9omjdOMgm8HyPoWls3OsBtIJ7u09JY88dA+BN8Lit\\/sZP4nNwMe20NNt\\/g73NxP0ieaKl+gsA5HV2Rl72+cqWvvTSRyWWZZ1oWTQr+Z8Oh93v8bj+smLFm\\/qNN96BNWu2YsKES4pqa5tnMQYIAiBJjjWDB5d+1t4e8odCsRxKGSils0866VePbNhQFQGA5uYOHHXUFbDbbS8Fg9FzIxF5DADE4+qpNTVNo1VVL0nM0QBw90cfrdnK2Nd7mWK3bHkVI0bMBWPsh7y8zAvb29n1pmldrutGNx8WpTRH0\\/SL7XZx+rRpV96oacYHRx55CG688WE9HI61pZqDYzHlfNO0KhljpKDgpJwXXvjwiOOOu\\/6u+vq2d3buXIGSkikFSdGPMYa8vCx17NghTbpuoKamCbt2LQZjDNOnX2NmZfngdrtgmla3zS+KIsnIcBGbjR8OkuSAy+VEDxELPp8Hus4PBULQk5vQcFhGKCTD43EWmqbVtadFUVDcbmcMAGIxpWuuKWMfk5NzwpOKogUNw8SQIWcPycnJzB4ypHSuLCvBjRtf7sY1NgC4CMC2NPdWHMDlAN5Ls\\/2hSI84GLhlaz7SD09ZDm7ZaEizfRfcbifcble3l2IYptjQ0HaIaVoLdN0437JoV86K1+sODRlS+teamsUrzj33N2hs9KOurhkdHeFppmkNB7hs6\\/E4P3j33RfqCcFqQSBgDNA0ozIeVyeJoohjj70Of\\/\\/7H3DccZOwfPm6Bp\\/P87QocjHHsmiWLKsTki\\/T43GuGDiw6L1RowZhwIDTe32OH398E9FoHIqiV5911jHzy8sLz8nLy1zkcklhbsXa0zYWUyqqqnbPk2Ul6\\/33VyMUioKkUB2lDKZpnQzgDkLI7bGYctXOnQ3DNm3aGWhs9GP58o9txcV5J6cSamZmBhk7dgiprByMXbsWA+Ci2qpVT8Lv\\/xgulwSn0wFBELqUasMw\\/ZLk6HS7OXdIcpA982Ww223E63UTt5tzGYfD0fOAmALgDJtNuMg0rfsYY13Kis0mvl1amr8hN9cHl0uCy9Wdg6mqnq2q2tWE4HZCyO0dHeFzamubB7W0dIpNTe18jB7r\\/DWAC8FNuv3lfRAAfnBPt4y98z4OBCa43+VucDt0OiLTB+A6TuOB3NDtdoIQAlXVkGoiTX0JDofNYAx1TqdjeXFx7osvvXTX+ksvvQfBYASffvoIGGOkuPiU05Onl91uq8nO9n5ZUjIZRUW566PR+KWMMUFV9Ywff6wf1dravmzChJEAgKqqWkydOh4Oh+3v4XDswmg0Pil1fi6XpBYV5S5sbw9Fa2s\\/Qm+W8+OPvwkAPx1VVcf339daum588utfz16+bNmGKa2tHVdEIvHzFEXrOnAopUeqqj4DKZEI\\/cBSFE0VRRGqqhFRFLoZa+JxhdXVtUDvI3LFNC1YlpVwvvL17egIbXv55Y+qR40aCKAnB+EWcsZYKDvba0QiMgghcLkcMAwjleCvBXCNZVGSfH+EEMYYe90wzFt\\/+GG3VlSUA6\\/XDcYYDMPsU+QCgNzcTDp+\\/HBEozI+++zjPbFYQJcJdjM4kTwD4Kg0Fq4dPOQjDp5bfqDQwENb\\/gzu00gHb4Bbtvypz7E\\/cDhse5lH3W5nkDF2dzyu+kVRFEpL8+OUsnXnnHNc25Ilq+hbb32BnBwfXnzxLowf\\/2uMG3dRhaYZ05P9VVX3bNmy638A0FAolguucQqMMZimders2Uc8I0mS9u23wBtv3IPy8jMQDsfa8\\/OznlAU7ZlUMcHlkl4488yjl1ZXN6K29u1enyHBaeyMYbzX6962e3eLMnBgMVpbO3VdN1b9\\/vdXrrv\\/\\/tdra2qa76SU2gHANC17Z2fYt\\/dYgNstITvb97fGxrYVgiCI2FO8oxoAZs8+whg+fO4KxthxAN\\/sfn9I+Pzz9YLT6cAhh1yILVtexZw5d8CyKKLROCKRWJJIuhZaEIg4ceIocvjhYxNcXOh6H3xcoKam+bObb74yvGDBn0AI4HRKiEaTmRldpkTCGO0iGqfTIQ8bNuC5QCDiN00LNTWLUVl5ARhjiERk6HqXWXgduF8kYf1ixONxRSoqiqOdnWEA6NOK9SO4yPIkuPOtP4TA8zxi4A6WdELaU5EMjnwEKWa4fYCBe+wXgHvtDzRIMRHCQdDDQqVUVJQs3rWrqUlRVFDKYBgWPv54DZxOB+6+m58DJ510C77+ejsyMz1HG4ZZnjJsEXjYzV6wLDqxsbF9LCHYkLxWX\\/8upk69AvG4+i5juBbAJABwOOxxQSAvvPHG52pl5eA+n2Hr1l0A4GGMPQFga1FR7pOjR1d899hjb5oOhx3z5z+m+3zurwiBhoTYKkl2q7y8SGaMobo6lfkyOBx2TJgw4kvG6JuNje3QtAg4jSgYMqQSBQVnIxqNbxFF0bQsTsyWZeXa7c55I0aU\\/3bZsi8iAPDWW1\\/gsstOccmy4rbZbJ2UMpVSpgJwMAa4XNIEy6KTXnrpo7XBYATxeAhjxozO0DSji0h03dAyMiYlDgECh6P7lnU6HUs9HtdmWVamqqp2VEKUzWhqar9m3Lhh37W2doYt6ww4nQ5QShMiVlfaU61lWa+Looh4PAZAx+7dNjzwwIsAOgAM7k4gPcrr1IEryU9hH4pySh8Z3HseBw+XT9eEHAPf6F3h6r2U+UkFA48c\\/m3ingdMHMAe5S0VqqqjoaHNbrOJiMW+QFVV730ppZgz5xjHe++tOplSKgBdMVw6sFd1GDsAGIaZY1n0xO3b126YNu1KrFnzDADg669XAsiV3W5ntKuTIMDtdhIAWLToT30+w6BBxRAEMraqqm6orpsT6+vbTn399U9XDBxYvLyx0b9FFIXBgUDkBkppl9IuiuK67GzviqQ3PWkZS4qb69dXjW1s9Nfn5WVmDRs25gRF0d2xWJzYbOLaW2+94IU\\/\\/\\/nlVfG4utayuqQMQZbVqzdt2lkxceLkuqysY4Wamma2ZMlXZV6va1tra+C3hYU52yIR+TtCyDEAoChaXnV1wwOyrN5js4lyZeXo45ubOy5JKv+CIMDn8zDDMPDAAzfC45mBWEzppmgrivY6pfSlkpL8I5ub25dompFNKUU4HJuzadOOdT5fxgOFhTno7AyDMS7qJYnP7XYe6nQ6zujsDAeOPHLCdELIoFgsTmU5l1I6+DFCyPb98YP8x8AwzC5vcF847bRbsXXrLuze3TZU180jk9d9Ps9nhmH+OR5XTQCEUmrm5mYeI8vqPbpugFKKlpaOQ88770KxpaWzi2253aXJX7tEEF3X0dq67wA9AKitbQaAQaZpZTHGoGl6nqbpc2Ix5WxRFPRoNG5njHVppxkZruiAAYWPdHZGOmbMOAzr1j2HrKxZzuTG1DQDra2dt9ls4vxwOCZs3LjDzhgX5QoLcwqamtpfsywazMryPhwKRccZhukDANO0iGlaJ\\/z4424QQkApBSEERUU5zVu2fIuSkqFxQRDeEAR6NKWMUMoQCsUOB\\/AuAFpX1yql6gd2u21rUVHOO4FABO3t\\/P6hUBQ9HLECpQyXXXbq2kce+cdiXY9ckRBlSSQi\\/5fP5\\/F\\/883GV7xenneXOr6iaCMURVtECLE2b94pJQNTE\\/T3LoDt3XwfPU7tQeDBgvs0s6b08YDrD79F+twD4CEkD4DndYi9zKMnCLhi9igS2Yb9tE8HPX1A9pSo1z7R3h6ELCuzTdMqBLoCEJfH4+py8JiwlSUl+asPPXT4IkEgzcl+lkWPWrNm6\\/Duok0XutaOUmbTdYMkTZx9QZZVxONqgBAip+pSlFLCGJOSxCGKInM6HV\\/m52dfcN55sxZXVBRBllXcdNNDZUVFuTN7PK8NgMQY7EkFO0Hc6\\/\\/4xxdUShkqKyveycryXudySVWCQLrCPSyLwjStro0sSY513MLP4PE4X3W7XY9Jkj1Vz7QDkDhBcc6RmenZMWbMoHtcLml7cXFuyjOxnuK7YBgmXn\\/9U6u4OO9vLpfUkvL8Wc3NHbf6fDkllFJYFhUY2yP+J96xDYCUnLNlUdhsIgoLs1FUlNPnRh6B9JV0gMdp3YcDV9KTKbkZSE9JJwAuS\\/S7EYA\\/tfbWAWAXeOJXcuwAEuLbvnDjjXPtr776iUUpfQMAtdlEobg4b7um6V0KdU3NIaipqa1zuXzPEYLhACil1MrK8ua1tu4VeEwBfAqgOfG7Bi4M7xPl5QWQJMeyYDB6kiTZj21vD41UFM3Kzc0c4XDYstvaghskyR5xuaRPhgwpWxuNxlu++mozZFmF3R6FoqiaZVkfgx84+zoVBABbGWPQdQNtbUG2e\\/cHrw4adMrynBzfnFAoOjUWU2hGhrvANC1VVbWo1+vRCcEXU6aMRUODH3l5WbHKyiF3bNhQtaSzMzwrHlfLJcnusdtt7mg03paR4RYLCrK\\/EQRh0VdfPd3417++gttuuyh1DuvBfWpW4l1VA8DZZ8\\/AnXde\\/F1W1qzfIOFYLi7Oo4SQz6urG6MulwSANQF4DftwijPG4HJJ1tChZc2iKHarrJjEOKRn5k0mTOWD56X\\/M8y8+0qYSmIvM+\\/+EEp\\/eQLx+Iper5922q2glMHrdZEPP1zDKGWIxXYB2L3P8QVBQCy2HGeddTvJyfGxZ5+98yfNAwAqK8+H0+lAR0cYdXUfAtAxa9aNGDGiPJ8x5p4z59j6GTNmsby8yRg5ciAKCnKwbNl6hMOfY926H5Gbm4l58x7Cp5+u7RYK0t98Zs68ASNHDsRHH61FTc1WADtwyikLMGZMhUcUBXP9+irts88e3WvdAOCHH3Zjx45vcfTRx2P69PEO07Qc27bVxN5\\/\\/34AFTjkkCNw++0XYc2arVi4cEG\\/a3TOOceitrYFVVW1kGUehKkoKwEMRUHBMKiqDtPs3\\/7D389u8DMTexHIVHDOUdnvSMA8cGp8GikF4n4GpCrhD4InUvWHZMLVLuCnKe3\\/Lrj66j8nYpwYXC4ndN3AY4\\/N\\/6ffd\\/787gTxwAM37rP9rbc+1u3v++674X99rfaFVAKZCC5mpBsK8l\\/gBJVOqAnAK47sT6jJU+Ac5bo0268BZ60NBwnkIH4upPLT8Ug\\/FGQhgNUA0tWOV4DXuLoIwPdp9pkJbiRYkmb7yeDliA7iIH42pFubNwkT3OK0ADy1NZ288w\\/BnY7V2BPK8m0a\\/Rh4qu\\/l4JmL\\/YGmOZ+DOIi0sT\\/JRzp40tTvwK0r6fRdBG7ZSg0i3AjOSVan0V8Et+JcC+D5X3qxDuI\\/D+kSSBycMP6I9OOkXgTwG\\/CweDieXZmqPFeBE8lnaY4VBE\\/jfRTpcbqDOIifBb35QdIt2pAUaZI\\/yfa9Fm3oxZlXCy5u9VW0oVt6JHhIyjzwUkS9FW3YL8JJNRnG4wEMHTocjDGUlRXAZhOxbNnCf\\/ba\\/6wYPnwunE4JXq8bp556BOrqWpEaFf63v92W9nrsWZcVv\\/Rj\\/eJIJZDPAZyBvWOIRoKX4Dkbe5f9ORd7l\\/0ZBn7iz0Z6ZX+WgZtp67EnyDFZ9mc4eFX31LI\\/O8Erm\\/zYYz4UwPZ0H1xRNBBCbACkk0+eKQcCEdLZGckEEAdIulzyXwaGYcJmE10AkyyLhisqitltt11IHnjg7yLA+q2emAgzIeDO2jjSCxr9t0cqgdRj78+s\\/Rr81O6tcNw88ConqZgC7hH\\/uQrHPZW4nlbhuP3BpEmjQCkrbW3tvKe1NXBfU1O7CeCWvLysPwiC0CCK03DhhbOxbNl6xGJxhEL7lgbLy8+Aw2HDtdeejZtv\\/hUEQcCCBY9i27YarFq1GbHYcgwdOgednWGEQp3IzMzFWWcdjfPOOx5nn30HIpFlOOWUBfjww6UAtkKSpsPpdCAc3gyeUdAdPK\\/iUIwbNxabN7+CAQMK4HA4TjJNs3DmzElPnXHGbWzRomVnWBZVnU7p4xtuuB+PPbYAQBEEoQKUru02XkVFCcAPu2sAvCIIQktr6yzceuv5GDduGH71q7vgdDq6Ct+Vlp4KQSBoaemEYXwFSZqOnBwfWlreBCGePtepqOgUtLS8z19kgsV5vTPgcjnh929FeflhCAZjiEY3orJyNrZt2wzGtoKQCkyefBwCgSiqq98EP3spgFEYPHg0OjvDGDOmAvX1bWhsXILS0tPQ1NSA7Ow8CIKAjo5P4PEcg4EDi1FVVQPgG4wbdxG2bt0FSmXwLI\\/J4HaoLSgvPxUul+M\\/t\\/To1Vf\\/BU8+eRspLz\\/jBrfbOduyLDMUir3uckmvl5bmQ9OMyYZhXm+ziSwry\\/uozSZ8u2VLtVMUxeskyf5qcXHeXK\\/XzZYu\\/XRhfv6gYR6P+yJdN36IRGJLRVHsCIc\\/x4IFj0KS7MI\\/\\/vH5mQ6Hfbam6WsCgeiLY8ZUWIyxsZSyWxhjDkmyP+VySavsdhFNTZ1zOzqCs2VZXanr5mtut1MnBOcCaLYsut7jcV3ncknPu1xSLBaLzxdFMZSVlWFfu\\/aZR48++trzTdPMXbPmmcfmzv3d6NWrt7xomlY8Ly\\/rKllWdlgWvcCyaM2QIaU\\/NDe3X62q+uOCIEQbGt5DWdlpAC\\/KdieAp9vago0DBxYOF0XxWkqpFo+rjxJCmhoblyQI6ky43U6PZdEbABwSDEafu\\/DC45f5fF7xk0++vtPtdu7aurV6LSHkFACPE0IogCuLinIr2tuD3+bnZy3etImXVM7ImIHy8qIiVdXn6bqRJYrik7t37\\/6uvLxczM31XatpxlE+n+cHl8v5ly++WCgff\\/xNt+ze3VIQj6sugKxvaHjvtYEDz0Bxcd7Imprm830+d0lxcd6Tum5s2Lq12j5gQOFlXq\\/n2HA49lZ+fubipqYOquvGlRkZbqm9PViVk5O5TJLs46PR+KmWZcUyMzMGuVzSnwzDausSgVKIww7uxf7rPoijJ04HV8oPlDgATr6vgnOhdFAM7vXvCtTZn6BFwzAxbdpVbMCAwpcURfXIsuIYO3bIkuLiXGRkOF3RqHznb35z5kVz5x73a78\\/cOeZZx7tDAQitlgsfqwsKxmKok1XFG06EEMspuRHIvLpgkDaYrF4JBnSQAjQ0RHOliTHfI\\/HZc\\/O9tmnTBnjmj17ms3vD946enTFpZMmjb6grq7lsk8+eRiNje2DZVm53uNxfWyaliZJ9iJF0RCLKYfFYsrQjo6QTZaVY+Nx1S3Liqiq2lyfz32GzSauzMyciVgsPthut1321FPvuIuK8nbEYspmy7JWl5bmNxmGCcMwo6IoXCHL6pmUsokVFSVmQQGPcg0EIggEImIgEDk0EIh4DGMzvF7PXEmyH+vzedorKkoKKipKMGjQGQB4xG9nZ+TcQw4Zdu\\/99994XklJ3uMPPPBK6emnH8UURTtBVbWJ0Wg8NxZTjo7FFBKLKYjFlKPC4ViWomjreS0vjlgsgEhEnmcYpqOwMGdtZqZnDPAd7HZxcna29\\/cPPnjTOXl5mXfGYvHTACAeV4+LxZRDQiH5m2Awcp7TebSzru4d0t4eusXlcuiyrC7bvbs1u66uBYIgzMjNzXz49NOnz3W5pMd37Wqu1DQD0ahyhCyroyllOwzDRDQaL5Ekx01FRbnBSEQ+vKam+bCmpnauI6RsLCe4fP977LuyO7BH7EnW4\\/2pld0BLpq9gj0OyP7EtFzwkkBXA73GlfWJ55\\/\\/Herr27BmzXfhWEx5MxyWN6xbtz0migKiUcUtiuKAYcPKMHhwCURRGFBX1+I0TV5z1+FwSIZhCowxygmBEFXVtg8eXLqMEEFPRsWGQjIAGF6ve5Gqaq2yrPyKMXborl1NNkEQKtau3fr2V19t\\/u+sLO\\/OJ598x8EYy9M0vb2srOBzm03c4HY71WSuPCEQJ00aXSKKgptSxhRFY3a7HaWl+assy9pcVlYAxsAIIUTXDfLGG5+ZhmF2aJqxe+nSV2Sez16w1uGwDwoEItdFo\\/JT27fXKt9\\/X9vbe2XASOTnZ24yTevteFw9WteNs7\\/88m+YPJlHIcXjGmKxeE5Ojhfjxg2F2+0sAIhr3LhhjDFmaJohulySEwDjkb0UlFK9paVziaYZ9araPZg3HldzCSHbJMn+hmGY3wIAYyjJyHB7x40biszMDFEUhfLEWjCfz9NCKd1AKTMNw8D9979mF0WSnZ3trfH5PF8oirZT03QAJGfHjoav33vvyxvC4dirNpuoJuZjBAKRDyyLNoiiAMuiyMrKsObMmbEyEIhsMAxT1DS9mxLtA4+kvQPpFUtwgCdU\\/Q39fxsE4KUi01H8hoGXCToR6WUmZoKLevOQflE7AMCsWZPg8XihKFo7eC1huN0u1NW1dMqy8vj997\\/e9PTT7zVqmvH4889\\/EJIkm+5w2Gu9Xve94Fa01gQN6wCCGzZUCYyt7Wb90XWTBoNRyemUBrrdTsHjcZKqqlqVMfaYZVGPaZoTGWOtr7\\/+qR4IRL4jhFQ3NLS9WFZW8PCYMRWlgweXIDvbuy072zeXMfbfoijojDEzkdvtFwQSkyRHMs8hCsAPECaKAggh32dn+846\\/PCzxsRicQQC0fb29uAbiqLS4cMHfltRUZwI6OtGHJ0ATKARfn\\/IFARhkMsluTweXgvB5eJL7PE4kZ3tW7Jmzdbl119\\/f0swGH3nhBOODBFyGAuFYgvb2gKVhYU5Zzgc9p2aJidF+ZAgEJ0xBln+IuW2Anw+z8uSZJ\\/j9wefj0bjYwEgGIx8tnNnw7vXXntfe1VV3epQKJqIuCad4NZMCiAgSQ689tpSXZIcSxVFu0QQyIu5ub6JubmZsNttXwoC+S4Wix8uCEL7sGEDmp1OBwAEk3NJnGcqY6xFllUGkAgSFtjUU\\/c88ODDdAol1IAT0x+QqJzYD2TwCN39+QTbJnDTcrqfYIuBh6esO4BoXi+4wSI4YcJIZGd7kZmZYX\\/nnZUlGRkudtVVpze3twfNDz5YDafT4VVVo7CgIDvsdkt01ar3O93u4c7EGO2pxHHllfeivr4N3333o5tSWjpq1CBl4cL5TS+++CHz+Tzim28uGxCNxoURIwY22myiHgrF4PN5PNu27SoePXqQsmzZwuaLL\\/4jMwzDvmbNtjKAabKsmG63q5NSSiXJXjxu3LB4IBAJtbZ2wuVyZmVmetxnnz2j5YknFjNZVu3RaLzUNE2\\/yyXF8\\/OzTw8Go6dblvVxW1tgEQ9u6EhdBwJenzdQVJRj1NS8jYKCk8p9Po9j9uxpzZGIHH\\/77RWIRJZhzJjzoao6YrF4Tltbuy8\\/P6+5vX2XfsIJs\\/HJJw8hJ+f4AYJAYqpqGJRSmRDCwIsAygCU1HX68svvcMkl98AwrGJV1Z2WRXcPHz6A7thRj8GDS7M2bKjKOfzwyujatc+2J0oJFXZ0hKz6+rYwYywbQPvFF89mZWUF9tde+3SAqmr0hBOmNjLGzCVLVsHlkjLDYbmAMdpUXl4U37jxe7jdGXng1rp4fn42dN1wFRfn5p944tSWBx\\/8h08QiAIgnmrFcqdJHD+C52JEwfMx+kMIPAX3GfC6vXFwHae\\/094LHvfvB4\\/9KuinvQP9i4V9oSvNddWqJ3HyyfMRDEaN7GzvbpfLgYaGtq5EGsuiUcZYlFKaWllDRS\\/lRp555g4MGTIHXq87HghEdlLKsHTpNwiFYgiHYxZjqOOfM3BAEAicTgdM05QZY9WWRfHqq58iEAhD102DMVabrAaSguYetwwlfpKlewxKaZ1pWigqykVhYU5tdrb3udbWwBpZVhGL7ZVqwgC0Aby+7rhxF6G5ub2eh\\/IrEEUBkQg3HG7f\\/jqczqNRVpYf0PWsgM0moqRkBDZv3pksTdRgGMkqJl1z7jW3Zd68xzBz5hQsXfp1C2MMubmZ8PuDyMnxQRSFUF5eVihZOyuBtpTf\\/QCg6yaamtoNxlgNY0BHRwimacFmE8EYC1NKwy6XhPb2ENzujN7momCPFbcrUSeVg1wGXsVwX9gMHjqyATxv5Etw0awvtINzjNdTrtnAxaG7se9S9NXgRaD94J+BfgL7\\/tKtDm5J+\\/JgNO\\/eGD\\/+IpSU5ENRVOze3YbW1s6DjsA0sD+psV+Dm1zTLSzXDB5D1bOwnAleulQGcC\\/S+1b6++Cc5ykc\\/Fb6AWHTplewadMvPYv\\/e0i3Nu8X2LvqIkHfBFYLrsB3EUePWCwKHmJyIxKfR+gFPcdehn2Hy9tw8DvpB\\/EzI3UTNqL715wATjQN4Kbfnl72CHiwoQfdY7Hi4PnpXyUbpoo8PUr6vAiuXF+BvYm1EXsHRq4FJ5I7wa1XqXM10DexHcRBHBBSdZDevmGerKhHgb0qMPbFQViiD1L79EQPf0VfZmUjOUaP9n1xCxMAO6iDHMTPhf8P\\/Itcf9Ip2+AAAAAldEVYdGRhdGU6Y3JlYXRlADIwMjItMTEtMTRUMDQ6MzU6MzArMDA6MDDyI1OYAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIyLTExLTE0VDA0OjM1OjMwKzAwOjAwg37rJAAAAABJRU5ErkJggg==\\\" data-filename=\\\"imageedit_76_3542310111.png\\\"><\\/h1>\\r\\n                    <\\/div>\\r\\n                <\\/div>\\r\\n            <\\/div>\\r\\n\\r\\n            <div class=\\\"layout one-col fixed-width\\\" style=\\\"margin: 0 auto;max-width: 600px;min-width: 320px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;\\\">\\r\\n                <div class=\\\"layout__inner\\\" style=\\\"border-collapse: collapse;display: table;width: 100%;background-color: #ffffff;\\\" lang=\\\"x-layout__inner\\\">\\r\\n                    <div class=\\\"column\\\" style=\\\"text-align: left; background: rgb(237, 241, 235); line-height: 21px; max-width: 600px; min-width: 320px; width: 320px;\\\">\\r\\n\\r\\n                        <div style=\\\"color: rgb(96, 102, 109); font-size: 14px; margin-left: 20px; margin-right: 20px; margin-top: 24px;\\\">\\r\\n                            <div style=\\\"line-height:10px;font-size:1px\\\">&nbsp;<\\/div>\\r\\n                        <\\/div>\\r\\n\\r\\n                        <div style=\\\"margin-left: 20px; margin-right: 20px;\\\">\\r\\n\\r\\n                            <p style=\\\"color: rgb(96, 102, 109); font-size: 14px; margin-top: 16px; margin-bottom: 0px;\\\"><strong>Hello admin,<\\/strong><\\/p>\\r\\n                            <p style=\\\"color: rgb(96, 102, 109); font-size: 14px; margin-top: 20px; margin-bottom: 20px;\\\"><strong>You are receiving this email because we received a password reset request for your account.<a href=\\\"https:\\/\\/mywise.mimeld.com\\/admin\\/password\\/reset\\/339af99cb3706965811d7fff354f893314467b8acaab9c968556dd609eb037a2?email=admin@demo.com\\\" target=\\\"_blank\\\">Click To Reset Password<\\/a>\\r\\n\\r\\n\\r\\nThis password reset link will expire in 60 minutes.\\r\\n\\r\\nIf you did not request a password reset, no further action is required.<\\/strong><\\/p>\\r\\n                            <p style=\\\"margin-top: 20px; margin-bottom: 20px;\\\"><strong style=\\\"color: rgb(96, 102, 109); font-size: 14px;\\\">Sincerely,<br>Team&nbsp;<\\/strong><font color=\\\"#60666d\\\"><b>Pay Secure<\\/b><\\/font><\\/p>\\r\\n                        <\\/div>\\r\\n\\r\\n                    <\\/div>\\r\\n                <\\/div>\\r\\n            <\\/div>\\r\\n\\r\\n            <div class=\\\"layout__inner\\\" style=\\\"border-collapse: collapse;display: table;width: 100%;background-color: #2c3262; margin-bottom: 20px\\\" lang=\\\"x-layout__inner\\\">\\r\\n                <div class=\\\"column\\\" style=\\\"text-align: left;color: #60666d;font-size: 14px;line-height: 21px;max-width:600px;min-width:320px;\\\">\\r\\n                    <div style=\\\"margin-top: 5px;margin-bottom: 5px;\\\">\\r\\n                        <p style=\\\"margin-top: 0;margin-bottom: 0;font-style: normal;font-weight: normal;color: #ffffff;font-size: 16px;line-height: 35px;font-family: bitter,georgia,serif;text-align: center;\\\">\\r\\n                            2022 ©  All Right Reserved<\\/p>\\r\\n                    <\\/div>\\r\\n                <\\/div>\\r\\n            <\\/div>\\r\\n\\r\\n        <\\/div>\\r\\n\\r\\n\\r\\n        <div style=\\\"border-collapse: collapse;display: table;width: 100%;\\\">\\r\\n            <div class=\\\"snippet\\\" style=\\\"display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 140px; width: 140px;padding: 10px 0 5px 0;color: #b9b9b9;\\\">\\r\\n            <\\/div>\\r\\n            <div class=\\\"webversion\\\" style=\\\"display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 139px; width: 139px;padding: 10px 0 5px 0;text-align: right;color: #b9b9b9;\\\">\\r\\n            <\\/div>\\r\\n        <\\/div>\\r\\n    <\\/div>\\r\\n<\\/div>\\\";s:6:\\\"locale\\\";N;s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";s:5:\\\"Admin\\\";s:7:\\\"address\\\";s:14:\\\"admin@demo.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:8:\\\"markdown\\\";N;s:7:\\\"\\u0000*\\u0000html\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:15:\\\"diskAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:5:\\\"theme\\\";N;s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";s:29:\\\"\\u0000*\\u0000assertionableRenderStrings\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1715916076, 1715916076);

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

--
-- Table structure for table `kycs`
--

CREATE TABLE `kycs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `input_form` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kycs`
--

INSERT INTO `kycs` (`id`, `input_form`, `status`, `created_at`, `updated_at`) VALUES
(2, '{\"DrivingLiences\":{\"field_name\":\"DrivingLiences\",\"field_level\":\"Driving Liences\",\"type\":\"text\",\"validation\":\"required\"},\"Address\":{\"field_name\":\"Address\",\"field_level\":\"Address\",\"type\":\"textarea\",\"validation\":\"required\"},\"PassportDocument\":{\"field_name\":\"PassportDocument\",\"field_level\":\"Passport Document\",\"type\":\"file\",\"validation\":\"required\"}}', 1, '2022-12-10 02:25:32', '2022-12-10 02:25:35');

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  `rtl` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = active, 0 = inactive	',
  `default_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `name`, `short_name`, `flag`, `is_active`, `rtl`, `default_status`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'en.png', 1, 0, 1, '2021-01-20 04:49:29', '2021-10-31 09:44:53'),
(2, 'Spanish', 'es', 'es.jpg', 1, 0, 0, '2021-01-21 05:33:06', '2022-06-25 05:42:26');

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

--
-- Table structure for table `line_items`
--

CREATE TABLE `line_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `line_item_type` varchar(255) NOT NULL,
  `line_item_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `description` longtext DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `subtotal` 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;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2020_10_19_061600_create_basic_controls_table', 1),
(5, '2020_10_20_100935_create_email_controls_table', 1),
(6, '2020_10_24_072526_create_email_templates_table', 1),
(7, '2020_11_07_085217_create_currencies_table', 2),
(8, '2020_11_08_075435_create_charges_limits_table', 3),
(9, '2020_11_09_112425_create_transfers_table', 4),
(10, '2020_11_11_103026_create_wallets_table', 5),
(11, '2020_11_14_065358_create_security_questions_table', 6),
(12, '2020_11_14_085811_create_two_factor_settings_table', 7),
(13, '2020_11_16_074706_create_transactions_table', 8),
(14, '2020_11_16_132223_create_jobs_table', 9),
(15, '2020_11_18_063222_create_exchanges_table', 10),
(16, '2020_11_19_072459_create_request_money_table', 11),
(17, '2020_11_25_060330_create_user_profiles_table', 12),
(18, '2020_11_30_095703_create_redeem_codes_table', 13),
(19, '2020_12_03_103512_create_admins_table', 14),
(20, '2020_12_06_100331_create_escrows_table', 15),
(21, '2020_12_09_064344_create_vouchers_table', 16),
(22, '2020_12_12_112328_create_sms_controls_table', 17),
(23, '2020_12_20_090105_create_sms_templates_table', 18),
(26, '2020_12_24_081403_create_payouts_table', 20),
(27, '2020_12_31_063516_create_site_notifications_table', 21),
(56, '2021_01_10_080449_create_deposits_table', 22),
(57, '2021_01_12_071930_create_funds_table', 23),
(58, '2021_01_16_121411_create_admin_profiles_table', 24),
(72, '2021_01_16_131037_create_disputes_table', 25),
(73, '2021_01_16_132315_create_dispute_details_table', 25),
(74, '2021_01_20_095223_create_languages_table', 26),
(75, '2021_01_21_101929_create_templates_table', 27),
(76, '2021_01_24_063900_create_template_media_table', 28),
(80, '2021_01_26_122022_create_contents_table', 29),
(81, '2021_01_26_122211_create_content_details_table', 29),
(82, '2021_01_26_122228_create_content_media_table', 29),
(84, '2021_01_31_060855_create_contacts_table', 30),
(85, '2021_01_31_074126_create_subscribes_table', 31),
(86, '2021_03_08_060607_create_referral_bonuses_table', 32),
(87, '2021_03_08_072720_create_commission_entries_table', 33),
(89, '2021_03_15_042634_create_basic_controls_table', 34),
(90, '2022_12_04_141240_create_recuring_invoices_table', 35),
(91, '2022_12_04_141650_create_invoices_table', 36),
(92, '2022_12_04_143335_create_line_items_table', 37),
(93, '2022_12_08_132812_create_kycs_table', 38),
(94, '2022_12_10_064852_create_user_kycs_table', 39),
(95, '2022_12_11_115620_create_stores_table', 40),
(96, '2022_12_12_105414_create_store_categories_table', 41),
(97, '2022_12_12_133624_create_store_shippings_table', 42),
(98, '2022_12_13_063456_create_store_product_attrs_table', 43),
(99, '2022_12_17_061738_create_store_products_table', 44),
(100, '2022_12_17_063720_create_store_product_images_table', 44),
(101, '2022_12_17_063845_create_product_store_maps_table', 44),
(103, '2022_12_17_063859_create_product_attr_maps_table', 45),
(104, '2022_12_17_064834_create_store_products_table', 46),
(105, '2022_12_18_091111_create_product_attr_lists_table', 47),
(106, '2022_12_18_104720_create_store_product_stocks_table', 48),
(107, '2022_12_24_065744_create_product_orders_table', 49),
(108, '2022_12_24_071858_create_product_order_details_table', 50),
(109, '2023_01_01_050125_create_seller_contacts_table', 51),
(110, '2023_01_02_095530_create_q_r_codes_table', 52),
(111, '2023_01_03_113735_create_virtual_card_methods_table', 53),
(112, '2023_01_04_102130_create_virtual_card_orders_table', 54),
(113, '2023_01_11_064324_create_virtual_card_transactions_table', 55),
(114, '2023_01_17_103352_create_razorpay_contacts_table', 56),
(115, '2020_12_24_051324_create_payout_methods_table', 57),
(116, '2023_01_23_102149_create_bill_methods_table', 58),
(117, '2023_01_23_130930_create_bill_services_table', 59),
(118, '2023_01_25_101024_create_bill_pays_table', 60),
(119, '2023_01_29_123413_create_api_orders_table', 61),
(120, '2023_01_30_071050_create_api_order_tests_table', 62),
(121, '2023_02_01_081645_create_roles_table', 63);

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

--
-- Table structure for table `notify_templates`
--

CREATE TABLE `notify_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `template_key` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `short_keys` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `firebase_notify_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0=>inactive, 1=>active	',
  `notify_for` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=> Admin, 0=> User',
  `lang_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notify_templates`
--

INSERT INTO `notify_templates` (`id`, `language_id`, `name`, `template_key`, `body`, `short_keys`, `status`, `firebase_notify_status`, `notify_for`, `lang_code`, `created_at`, `updated_at`) VALUES
(1, 1, 'Send money', 'TRANSFER_TO', '[[sender]] send money to your account amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(2, 1, 'Send money', 'TRANSFER_FROM', 'You have send money to [[receiver]] account amount [[amount]] [[currency]].Transaction: #[[transaction]]', '{\"receiver\":\"Receiver Name\",\"amount\":\"Send Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(3, 1, 'Request Money Initialise', 'REQUEST_MONEY_INIT', '[[sender]] request for send money to account amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(4, 1, 'Request Money Confirm', 'REQUEST_MONEY_CONFIRM', '[[sender]] confirm your request money amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(5, 1, 'Request Money Cancel', 'REQUEST_MONEY_CANCEL', '[[sender]] cancel your request money amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(6, 1, 'Money Exchange', 'MONEY_EXCHANGE', 'You are exchange [[from_amount]] [[from_currency]] to [[to_amount]] [[to_currency]]. Transaction: #[[transaction]]', '{\"from_amount\":\"Amount Exchange From\",\"from_currency\":\"Currency Exchange From\",\"to_amount\":\"Amount Exchange To\",\"to_currency\":\"Currency Exchange To\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(7, 1, 'Redeem Code Generate', 'REDEEM_CODE_GENERATE', 'You have generate a redeem code amount [[amount]] [[currency]].Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Redeem Code\"}', 1, 1, 0, 'en', NULL, NULL),
(8, 1, 'Redeem code sender', 'REDEEM_CODE_SENDER', '[[receiver]] used your redeem code amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Receiver Name who used code\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(9, 1, 'Redeem code used by', 'REDEEM_CODE_USED_BY', 'You have used a redeem code amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Redeem Code\"}', 1, 1, 0, 'en', NULL, NULL),
(10, 1, 'Escrow request sender', 'ESCROW_REQUEST_SENDER', 'Your escrow request to [[receiver]] amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Receiver Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(11, 1, 'Escrow request receiver', 'ESCROW_REQUEST_RECEIVER', 'You have escrow request from [[sender]] amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(12, 1, 'Escrow Request Accept from', 'ESCROW_REQUEST_ACCEPT_FROM', '[[sender]] accept your request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(13, 1, 'Escrow Request Accept by', 'ESCROW_REQUEST_ACCEPT_BY', 'You accept escrow request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(14, 1, 'Escrow Request Cancel from', 'ESCROW_REQUEST_CANCEL_FROM', '[[sender]] Cancel your request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(15, 1, 'Escrow Request Cancel by', 'ESCROW_REQUEST_CANCEL_BY', 'You Cancel escrow request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(16, 1, 'Escrow payment disburse from', 'ESCROW_PAYMENT_DISBURSED_REQUEST_FROM', '[[sender]] request to disburse your amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(17, 1, 'request to payment disburse by', 'ESCROW_PAYMENT_DISBURSED_REQUEST_BY', 'You request escrow disburse amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(18, 1, 'Escrow payment disburse from', 'ESCROW_PAYMENT_DISBURSED_FROM', '[[sender]] disburse your request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(19, 1, 'request to payment disburse by', 'ESCROW_PAYMENT_DISBURSED_BY', 'You disburse escrow request amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(20, 1, 'Dispute request to admin', 'DISPUTE_REQUEST_TO_ADMIN', '[[sender]] dispute escrow request amount [[amount]] [[currency]] . Transaction: #[[transaction]] click to reply [[link]]', '{\"sender\":\"Sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\",\"link\":\"Dispute reply link\"}', 1, 1, 1, 'en', NULL, NULL),
(21, 1, 'Dispute request to user', 'DISPUTE_REQUEST_TO_USER', '[[sender]] reply dispute escrow request amount. Transaction: #[[transaction]] click to reply [[link]]', '{\"sender\":\"Sender Name\",\"transaction\":\"Transaction Number\",\"link\":\"Dispute reply link\"}', 1, 1, 0, 'en', NULL, NULL),
(22, 1, 'Voucher payment request to', 'VOUCHER_PAYMENT_REQUEST_TO', '[[sender]] request to voucher payment amount [[amount]] [[currency]] . Transaction: #[[transaction]] click to payment [[link]]', '{\"sender\":\"Sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\",\"link\":\"Dispute reply link\"}', 1, 1, 0, 'en', NULL, NULL),
(23, 1, 'Voucher payment request from', 'VOUCHER_PAYMENT_REQUEST_FROM', 'You request to [[receiver]] voucher payment amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Receiver Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(24, 1, 'Voucher payment to', 'VOUCHER_PAYMENT_TO', '[[receiver]] payment to your voucher amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Request receiver name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(25, 1, 'Voucher payment from', 'VOUCHER_PAYMENT_FROM', 'You payment to [[sender]] voucher amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(26, 1, 'Voucher payment cancel to', 'VOUCHER_PAYMENT_CANCEL_TO', '[[receiver]] payment cancel to your voucher amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Request receiver name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(27, 1, 'Voucher payment cancel from', 'VOUCHER_PAYMENT_CANCEL_FROM', 'You payment cancel to [[sender]] voucher amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(28, 1, 'Payout Request Admin', 'PAYOUT_REQUEST_TO_ADMIN', '[[sender]] request for payment amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 1, 'en', NULL, NULL),
(29, 1, 'Payout Request from', 'PAYOUT_REQUEST_FROM', 'You request for payout amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(30, 1, 'Payout Confirm', 'PAYOUT_CONFIRM', '[[sender]] confirm your payout amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(31, 1, 'Payout Cancel', 'PAYOUT_CANCEL', '[[sender]] cancel your payout amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(32, 1, 'Add Fund user user', 'ADD_FUND_USER_USER', 'you add fund money amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, '2023-03-13 06:31:35'),
(33, 1, 'Add Fund user admin', 'ADD_FUND_USER_ADMIN', '[[user]] add fund money amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"user\":\"User full name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 1, 'en', NULL, '2022-07-02 09:53:35'),
(34, 1, 'Deposit Bonus', 'DEPOSIT_BONUS', 'Deposit Commission From [[sender]] amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(35, 1, 'Login Bonus', 'LOGIN_BONUS', 'Login Commission From [[sender]] amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Sender Name\",\"amount\":\"Received Amount\",\"currency\":\"Transfer Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(36, 1, 'SUPPORT TICKET CREATE', 'SUPPORT_TICKET_CREATE', '[[username]] create a ticket\r\nTicket : [[ticket_id]]', '{\"ticket_id\":\"Support Ticket ID\",\"username\":\"username\"}', 1, 1, 1, 'en', '2021-12-05 04:58:45', '2021-12-05 04:58:45'),
(37, 1, 'SUPPORT TICKET REPLIED', 'SUPPORT_TICKET_REPLIED', '[[username]] replied  ticket\r\nTicket : [[ticket_id]]', '{\"ticket_id\":\"Support Ticket ID\",\"username\":\"username\"}', 1, 1, 1, 'en', '2021-12-05 04:58:45', '2021-12-05 04:58:45'),
(38, 1, 'ADMIN REPLIED SUPPORT TICKET ', 'ADMIN_REPLIED_TICKET', 'Admin replied  \r\nTicket : [[ticket_id]]', '{\"ticket_id\":\"Support Ticket ID\"}', 1, 1, 0, 'en', '2021-12-05 05:00:17', '2021-12-05 05:00:17'),
(40, 1, 'Invoice payment to', 'INVOICE_PAYMENT_TO', '[[receiver]] payment to your invoice amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"receiver\":\"Request receiver name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(41, 1, 'Invoice payment from', 'INVOICE_PAYMENT_FROM', 'You payment to [[sender]] invoice amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"sender\":\"Request sender Name\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(42, 1, 'KYC APPROVE', 'KYC_APPROVE', 'Your KYC has been approved', '', 1, 1, 0, 'en', NULL, NULL),
(43, 1, 'KYC REJECT', 'KYC_REJECT', 'Your KYC has been rejected', '', 1, 1, 0, 'en', NULL, NULL),
(44, 1, 'Product order from', 'PRODUCT_ORDER', 'Your have a new order amount [[amount]] [[currency]] has been payment . Order Bumber: #[[orderNumber]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"orderNumber\":\"orderNumber\"}', 1, 1, 0, 'en', NULL, NULL),
(45, 1, 'QR payment to', 'QR_PAYMENT_TO', 'Amount [[amount]][[currency]] payment from [[email]] by QR Code', '{\"email\":\"email\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\"}', 1, 1, 0, 'en', NULL, NULL),
(46, 1, 'QR payment From', 'QR_PAYMENT_FROM', 'Amount [[amount]][[currency]] payment for [[sender]] by QR Code', '{\"sender\":\"sender\",\"amount\":\"Request Amount\",\"currency\":\"Request Currency\"}', 1, 1, 0, 'en', NULL, NULL),
(47, 1, 'Virtual Card Apply', 'VIRTUAL_CARD_APPLY', 'Amount [[amount]][[currency]] payment for virtual card from wallet ', '{\"amount\":\"amount\",\"currency\":\"currency\"}', 1, 1, 0, 'en', NULL, NULL),
(48, 1, 'Admin Virtual Card Apply', 'ADMIN_VIRTUAL_CARD_APPLY', 'Amount [[amount]][[currency]] payment for virtual card by [[username]] ', '{\"amount\":\"amount\",\"currency\":\"currency\",\"username\":\"username\"}', 1, 1, 0, 'en', NULL, NULL),
(49, 1, 'Virtual Card Rejected', 'VIRTUAL_CARD_REJECTED', 'Virtual card request has been rejected amount [[amount]][[currency]] payment for virtual card has been return ', '{\"amount\":\"amount\",\"currency\":\"currency\"}', 1, 1, 0, 'en', NULL, NULL),
(50, 1, 'Virtual Card Approve', 'VIRTUAL_CARD_APPROVE', 'Virtual card request has been approved. Card Number[[card_number]] balance [[balance]] expiry on [[expiry_date]]', '{\"name_on_card\":\"name_on_card\",\"card_id\":\"card_id\",\"cvv\":\"cvv\",\"card_number\":\"card_number\",\"brand\":\"brand\",\"expiry_date\":\"expiry_date\",\"balance\":\"balance\",\"currency\":\"currency\"}', 1, 1, 0, 'en', NULL, NULL),
(51, 1, 'Virtual Card Fund Return', 'VIRTUAL_CARD_FUND_RETURN', 'Virtual card fund request [[amount [[currency]] has been return card number: [[cardNumber]]', '{\"amount\":\"amount\",\"currency\":\"Request Currency\",\"cardNumber\":\"cardNumber\"}', 1, 1, 0, 'en', NULL, NULL),
(52, 1, 'Virtual Card Fund Approve', 'VIRTUAL_CARD_FUND_APPROVE', 'Virtual card fund request [[amount [[currency]] has been approved card number: [[cardNumber]]', '{\"amount\":\"amount\",\"currency\":\"Request Currency\",\"cardNumber\":\"cardNumber\"}', 1, 1, 0, 'en', NULL, NULL),
(53, 1, 'Virtual Card Un-Block', 'VIRTUAL_CARD_UNBLOCK', 'Your Card has been un-blocked card number-[[cardNumber]]', '{\"cardNumber\":\"cardNumber\"}', 1, 1, 0, 'en', NULL, NULL),
(54, 1, 'Virtual Card Block', 'VIRTUAL_CARD_BLOCK', 'Your Card has been blocked card number-[[cardNumber]]', '{\"cardNumber\":\"cardNumber\"}', 1, 1, 0, 'en', NULL, NULL),
(55, 1, 'Bill Payment Return', 'BILL_PAYMENT_RETURN', 'your bill pay [[amount]] [[currency]] has been return in [[return_currency]] wallet.\r\nreturn amount [[return_currency_amount]] [[return_currency]]', '{\"amount\":\"amount\",\"currency\":\"currency\",\"return_currency_amount\":\"return_currency_amount\",\"return_currency\":\"return_currency\",\"transaction\":\"transaction\"}', 1, 1, 0, 'en', NULL, NULL),
(56, 1, 'Bill Pay', 'BILL_PAY', '[[amount]] [[currency]] for bill. Transaction: #[[transaction]]', '{\"amount\":\"amount\",\"amount\":\"Request Amount\",\"currency\":\"currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(57, 1, 'Api Payment', 'API_PAYMENT', 'you got payment from api amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(58, 1, 'Admin Api Payment', 'ADMIN_API_PAYMENT', '[[receiver]] got payment from api amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"receiver\":\"receiver\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'en', NULL, NULL),
(59, 2, 'Add Fund user user', 'ADD_FUND_USER_USER', 'you add fund money amount [[amount]] [[currency]] . Transaction: #[[transaction]]', '{\"amount\":\"Request Amount\",\"currency\":\"Request Currency\",\"transaction\":\"Transaction Number\"}', 1, 1, 0, 'es', '2023-03-13 06:25:27', '2023-03-13 06:31:35');

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

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

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

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('admin@demo.com', '$2y$10$O8VTS2lEXhbRclJkUWQxm.v4RL/umtI2QZEh9/lI1GDfIZbXb1l/m', '2024-05-17 06:51:16');

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

--
-- Table structure for table `payouts`
--

CREATE TABLE `payouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_code` varchar(10) DEFAULT NULL COMMENT 'automatic payout currency code',
  `payout_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `response_id` varchar(191) DEFAULT NULL COMMENT 'api response id for webhooks',
  `percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Percent of charge',
  `charge_percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'After adding percent of charge',
  `charge_fixed` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `transfer_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount deduct from sender',
  `received_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount add to receiver',
  `charge_from` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Sender, 1 = Receiver',
  `note` text DEFAULT NULL,
  `withdraw_information` text DEFAULT NULL,
  `meta_field` text NOT NULL COMMENT 'for .flutterwave',
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(8) NOT NULL DEFAULT 0 COMMENT '0=Pending, 1=generate, 2 = payment done, 5 = cancel,6=failed',
  `utr` char(36) DEFAULT NULL,
  `last_error` text DEFAULT NULL COMMENT 'api error',
  `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 `payout_methods`
--

CREATE TABLE `payout_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `methodName` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `bank_name` text DEFAULT NULL COMMENT 'automatic payment for bank name',
  `banks` text DEFAULT NULL COMMENT 'admin bank permission',
  `parameters` text DEFAULT NULL COMMENT 'api parameters',
  `extra_parameters` text DEFAULT NULL,
  `inputForm` text DEFAULT NULL,
  `percentage_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `fixed_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `min_limit` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `max_limit` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `currency_lists` text DEFAULT NULL,
  `supported_currency` text DEFAULT NULL,
  `convert_rate` text DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  `is_automatic` tinyint(4) NOT NULL DEFAULT 0,
  `is_sandbox` tinyint(4) NOT NULL DEFAULT 0,
  `environment` enum('test','live') NOT NULL DEFAULT 'live',
  `is_auto_update` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'currency rate auto update',
  `logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payout_methods`
--

INSERT INTO `payout_methods` (`id`, `methodName`, `code`, `description`, `bank_name`, `banks`, `parameters`, `extra_parameters`, `inputForm`, `percentage_charge`, `fixed_charge`, `min_limit`, `max_limit`, `currency_lists`, `supported_currency`, `convert_rate`, `is_active`, `is_automatic`, `is_sandbox`, `environment`, `is_auto_update`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'Payoneer', NULL, 'Payment will receive within 3 days', NULL, NULL, NULL, NULL, '{\"account_name\":{\"name\":\"account_name\",\"label\":\"Account  Name\",\"type\":\"text\",\"validation\":\"required\"},\"account_number\":{\"name\":\"account_number\",\"label\":\"Account  Number\",\"type\":\"text\",\"validation\":\"required\"},\"description\":{\"name\":\"description\",\"label\":\"Description\",\"type\":\"textarea\",\"validation\":\"required\"}}', 0.75000000, 1.12300000, 1.00000000, 55.00000000, NULL, NULL, NULL, 1, 0, 0, 'live', 1, 'payoneer.png', '2020-12-23 19:40:29', '2021-02-13 23:13:55'),
(2, 'Paypal manual', NULL, 'Payment will receive within 9 hours', NULL, NULL, '[]', NULL, '{\"account_name\":{\"name\":\"account_name\",\"label\":\"Account  Name\",\"type\":\"text\",\"validation\":\"required\"},\"account_number\":{\"name\":\"account_number\",\"label\":\"Account  Number\",\"type\":\"text\",\"validation\":\"required\"},\"description\":{\"name\":\"description\",\"label\":\"Description\",\"type\":\"textarea\",\"validation\":\"required\"}}', 0.35000000, 1.32100000, 1.00000000, 169.00000000, NULL, NULL, '[]', 1, 0, 0, 'live', 0, 'paypal.png', '2020-12-23 19:40:51', '2023-01-22 06:03:36'),
(3, 'Bank', NULL, 'Payment will receive within 8 days', NULL, NULL, '[]', NULL, '{\"account_name\":{\"name\":\"account_name\",\"label\":\"Account Name\",\"type\":\"text\",\"validation\":\"required\"},\"account_number\":{\"name\":\"account_number\",\"label\":\"Account  Number\",\"type\":\"textarea\",\"validation\":\"required\"}}', 0.50000000, 1.00000000, 1.00000000, 100.00000000, NULL, NULL, '[]', 1, 0, 0, 'live', 0, 'bank.png', '2020-12-27 19:23:36', '2023-01-21 00:29:51'),
(9, 'Flutterwave', 'flutterwave', 'Payment will receive within 1 days', '{\"0\":{\"NGN BANK\":\"NGN BANK\",\"NGN DOM\":\"NGN DOM\",\"GHS BANK\":\"GHS BANK\",\"KES BANK\":\"KES BANK\",\"ZAR BANK\":\"ZAR BANK\",\"INTL EUR & GBP\":\"INTL EUR & GBP\",\"INTL USD\":\"INTL USD\",\"INTL OTHERS\":\"INTL OTHERS\",\"FRANCOPGONE\":\"FRANCOPGONE\",\"XAF/XOF MOMO\":\"XAF/XOF MOMO\",\"mPesa\":\"mPesa\",\"Rwanda Momo\":\"Rwanda Momo\",\"Uganda Momo\":\"Uganda Momo\",\"Zambia Momo\":\"Zambia Momo\",\"Barter\":\"Barter\",\"FLW\":\"FLW\"}}', '[\"NGN BANK\",\"NGN DOM\",\"GHS BANK\",\"INTL USD\"]', '{\"Public_Key\":\"\",\"Secret_Key\":\"\",\"Encryption_Key\":\"\"}', NULL, NULL, 0.50000000, 2.00000000, 10.00000000, 5000.00000000, '{\"USD\":\"USD\",\"KES\":\"KES\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"UGX\":\"UGX\",\"TZS\":\"TZS\"}', '{\"USD\":\"USD\",\"KES\":\"KES\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"UGX\":\"UGX\",\"TZS\":\"TZS\"}', '{\"USD\":1,\"KES\":124.1,\"GHS\":12.3,\"NGN\":455.06,\"GBP\":0.81,\"EUR\":0.92,\"UGX\":3677.34,\"TZS\":2335}', 1, 1, 0, 'live', 1, 'flutterwave.jpg', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(10, 'Razorpay', 'razorpay', 'Payment will receive within 1 days', '', NULL, '{\"account_number\":\"\",\"Key_Id\":\"\",\"Key_Secret\":\"\"}', '{\"webhook\":\"payout\"}', '{\"name\":{\"name\":\"name\",\"label\":\"Name\",\"type\":\"text\",\"validation\":\"required\"},\"email\":{\"name\":\"email\",\"label\":\"Email\",\"type\":\"text\",\"validation\":\"required\"},\"ifsc\":{\"name\":\"ifsc\",\"label\":\"IFSC\",\"type\":\"text\",\"validation\":\"required\"},\"account_number\":{\"name\":\"account_number\",\"label\":\"Account number\",\"type\":\"text\",\"validation\":\"required\"}}', 0.50000000, 2.00000000, 100.00000000, 50000.00000000, '{\"INR\":\"INR\"}', '{\"INR\":\"INR\"}', '{\"INR\":80.98}', 1, 1, 0, 'live', 1, 'razorpay.jpg', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(11, 'Paystack', 'paystack', 'Payment will receive within 1 days', '', NULL, '{\"Public_key\":\"\",\"Secret_key\":\"\"}', '{\"webhook\":\"payout\"}', '{\"name\":{\"name\":\"name\",\"label\":\"Name\",\"type\":\"text\",\"validation\":\"required\"},\"account_number\":{\"name\":\"account_number\",\"label\":\"Account  Number\",\"type\":\"text\",\"validation\":\"required\"}}', 1.30000000, 2.30000000, 50.00000000, 50000.00000000, '{\"NGN\":\"NGN\",\"GHS\":\"GHS\",\"ZAR\":\"ZAR\"}', '{\"NGN\":\"NGN\",\"GHS\":\"GHS\",\"ZAR\":\"ZAR\"}', '{\"NGN\":\"455\",\"GHS\":\"2.3\",\"ZAR\":\"17.2\"}', 1, 1, 0, '', 1, 'paystack.jpg', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(12, 'Coinbase', 'coinbase', 'Payment will receive within 1 days', '', NULL, '{\"API_Key\":\"\",\"API_Secret\":\"\",\"Api_Passphrase\":\"\"}', '{\"webhook\":\"payout\"}', '{\"crypto_address\":{\"name\":\"crypto_address\",\"label\":\"Crypto Address\",\"type\":\"text\",\"validation\":\"required\"}}', 1.30000000, 2.00000000, 50.00000000, 50000.00000000, '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '{\"BNB\":\"0.0032866584364651\",\"BTC\":\"4.3438047580189E-5\",\"XRP\":\"2.4317656276014\",\"ETH\":\"0.00060498363899103\",\"ETH2\":\"1\",\"USDT\":\"0.99970684227142\",\"BCH\":\"0.0077663435649339\",\"LTC\":\"0.011189496085365\",\"XMR\":\"0.0056633319909619\",\"TON\":\"0.43646828144729\"}', 1, 1, 0, '', 1, 'coinbase.png', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(14, 'Perfect Money', 'perfectmoney', 'Payment will receive within 1 days', '', NULL, '{\"Passphrase\":\"\",\"Account_ID\":\"\",\"Payer_Account\":\"\"}', '', '{\"account_number\":{\"name\":\"account_number\",\"label\":\"Account  Number\",\"type\":\"text\",\"validation\":\"required\"}}', 1.30000000, 2.00000000, 50.00000000, 50000.00000000, '{\"USD\":\"USD\",\"EUR\":\"EUR\"}', '{\"USD\":\"USD\",\"EUR\":\"EUR\"}', '{\"USD\":\"1\",\"EUR\":\"0.92\"}', 1, 1, 0, 'live', 1, 'perfect money.jpg', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(15, 'Paypal', 'paypal', 'Payment will receive within 1 days', '', NULL, '{\"cleint_id\":\"\",\"secret\":\"\"}', '{\"webhook\":\"payout\"}', '{\"receiver\":{\"name\":\"receiver\",\"label\":\"Receiver\",\"type\":\"text\",\"validation\":\"required\"}}', 2.00000000, 5.00000000, 5.00000000, 50000.00000000, '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"USD\"}', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"USD\"}', '{\"AUD\":\"1.44\",\"BRL\":\"5.21\",\"CAD\":\"1.34\",\"CZK\":\"21.99\",\"DKK\":\"6.85\",\"EUR\":\"0.92\",\"HKD\":\"7.83\",\"HUF\":\"361.73\",\"INR\":\"80.98\",\"ILS\":\"3.4\",\"JPY\":\"129.56\",\"MYR\":\"4.29\",\"MXN\":\"18.87\",\"TWD\":\"30.33\",\"NZD\":\"1.55\",\"NOK\":\"9.79\",\"PHP\":\"54.46\",\"PLN\":\"4.14\",\"GBP\":\"0.81\",\"RUB\":\"68.25\",\"SGD\":\"1.32\",\"SEK\":\"10.3\",\"CHF\":\"0.92\",\"THB\":\"32.64\",\"USD\":\"1\"}', 1, 1, 1, 'test', 1, 'paypal.jpg', '2020-12-27 19:23:36', '2023-03-16 00:17:44'),
(16, 'Binance', 'binance', 'Payment will receive within 1 days', '', NULL, '{\"API_Key\":\"\",\"KEY_Secret\":\"\"}', '', '{\"network\":{\"name\":\"network\",\"label\":\"Network\",\"type\":\"text\",\"validation\":\"required\"},\"address\":{\"name\":\"address\",\"label\":\"Address\",\"type\":\"text\",\"validation\":\"required\"},\"amount\":{\"name\":\"amount\",\"label\":\"Amount\",\"type\":\"text\",\"validation\":\"required\"}}', 1.30000000, 2.00000000, 50.00000000, 50000.00000000, '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '{\"BNB\":\"0.0032866584364651\",\"BTC\":\"4.3438047580189E-5\",\"XRP\":\"2.4317656276014\",\"ETH\":\"0.00060498363899103\",\"ETH2\":\"1\",\"USDT\":\"0.99970684227142\",\"BCH\":\"0.0077663435649339\",\"LTC\":\"0.011189496085365\",\"XMR\":\"0.0056633319909619\",\"TON\":\"0.43646828144729\"}', 1, 1, 1, 'live', 1, 'binance.png', '2020-12-27 19:23:36', '2023-03-16 00:17:44');

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

--
-- Table structure for table `product_attr_lists`
--

CREATE TABLE `product_attr_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_product_attrs_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_attr_maps`
--

CREATE TABLE `product_attr_maps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `attributes_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 `product_orders`
--

CREATE TABLE `product_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_number` text DEFAULT NULL,
  `gateway_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL COMMENT 'who owner of store',
  `currency_id` int(11) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `alt_phone` varchar(255) DEFAULT NULL,
  `total_amount` double DEFAULT NULL COMMENT 'without shipping charge',
  `shipping_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shipping_charge` double DEFAULT NULL,
  `detailed_address` varchar(255) DEFAULT NULL,
  `order_note` varchar(255) DEFAULT NULL,
  `utr` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=>pending,1=>complete',
  `stage` tinyint(6) DEFAULT NULL COMMENT '0=>arrivel,1=>processing,2=>on shipping,3=>out for delivers,4=>delivered,5=>cancel',
  `cancel_from` tinyint(6) 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 `product_order_details`
--

CREATE TABLE `product_order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `attributes_id` text DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `total_price` double 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 `product_store_maps`
--

CREATE TABLE `product_store_maps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_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 `q_r_codes`
--

CREATE TABLE `q_r_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL COMMENT 'who receive payment',
  `gateway_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `charge` double NOT NULL DEFAULT 0,
  `amount` double NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=>incomplete, 1=>complete',
  `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 `razorpay_contacts`
--

CREATE TABLE `razorpay_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_id` varchar(255) DEFAULT NULL,
  `entity` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `recuring_invoices`
--

CREATE TABLE `recuring_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number_of_payments` int(11) DEFAULT NULL,
  `current_number_of_payment` int(11) DEFAULT NULL,
  `first_arrival_date` timestamp NULL DEFAULT NULL,
  `last_arrival_date` timestamp NULL DEFAULT NULL,
  `subtotal` decimal(8,2) DEFAULT NULL,
  `tax` decimal(8,2) DEFAULT NULL,
  `vat` decimal(8,2) DEFAULT NULL,
  `tax_rate` decimal(8,2) DEFAULT NULL,
  `vat_rate` decimal(8,2) DEFAULT NULL,
  `grand_total` decimal(8,2) 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 `redeem_codes`
--

CREATE TABLE `redeem_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Percent of charge',
  `charge_percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'After adding percent of charge',
  `charge_fixed` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `transfer_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount deduct from sender',
  `received_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount add to receiver',
  `charge_from` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Sender, 1 = Receiver',
  `note` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=Success,0=Pending',
  `utr` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_bonuses`
--

CREATE TABLE `referral_bonuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `referral_on` varchar(50) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `calcType` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1 = fixed, 0 = percent',
  `amount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `minAmount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `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 `request_money`
--

CREATE TABLE `request_money` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'user id of request sender',
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'user id of received receiver',
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `utr` char(36) DEFAULT NULL COMMENT 'unique id for each payment request',
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'requested amount',
  `email` varchar(255) DEFAULT NULL COMMENT 'request receiver id',
  `note` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=Success,0=Pending',
  `percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'percent of charge',
  `charge_percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'after adding percent of charge',
  `charge_fixed` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `transfer_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'amount deduct from user who (received request)',
  `received_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'amount add to user who send (request money)',
  `charge_from` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Sender, 1 = Receiver',
  `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,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `permission` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=>deactive,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 `roles`
--

INSERT INTO `roles` (`id`, `user_id`, `name`, `permission`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Manager', '[\"19\"]', 1, '2023-02-01 03:51:55', '2023-02-02 07:28:44'),
(2, 1, 'HR', '[\"10\",\"7\",\"4\",\"2\"]', 1, '2023-02-01 03:57:38', '2023-02-01 04:23:50'),
(3, 1, 'Demo Admin', '[\"1\",\"3\",\"5\",\"9\",\"2\",\"4\",\"6\",\"10\",\"14\",\"16\",\"18\",\"22\",\"23\",\"19\",\"17\",\"15\",\"11\",\"8\"]', 1, '2023-10-29 13:12:42', '2024-04-01 15:20:37');

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

--
-- Table structure for table `security_questions`
--

CREATE TABLE `security_questions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) 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 `security_questions`
--

INSERT INTO `security_questions` (`id`, `question`, `created_at`, `updated_at`) VALUES
(1, 'What was the house number and street name you lived in as a child?', '2020-11-14 01:38:42', '2020-11-14 01:39:44'),
(2, 'What were the last four digits of your childhood telephone number?', '2020-11-14 01:40:01', '2020-11-14 01:40:01'),
(3, 'What primary school did you attend?', '2020-11-14 01:40:08', '2020-11-14 01:40:08'),
(4, 'In what town or city was your first full time job?', '2020-11-14 01:40:33', '2020-11-14 01:40:33'),
(5, 'In what town or city did you meet your spouse or partner?', '2020-11-14 01:40:59', '2020-11-14 01:40:59'),
(6, 'What is the middle name of your oldest child?', '2020-11-14 01:41:06', '2020-11-14 01:41:06'),
(7, 'What are the last five digits of your driver\'s license number?', '2020-11-14 02:06:57', '2020-11-14 02:06:57'),
(8, 'What is your grandmother\'s (on your mother\'s side) maiden name?', '2020-11-14 02:07:06', '2020-11-14 02:07:06'),
(9, 'What is your favourite sports name?', '2022-06-26 06:56:44', '2022-06-26 07:00:07');

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

--
-- Table structure for table `seller_contacts`
--

CREATE TABLE `seller_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sender_name` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller_contacts`
--

INSERT INTO `seller_contacts` (`id`, `store_id`, `user_id`, `sender_name`, `message`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 'alex boobs', 'how can i buy', '2022-12-31 23:15:24', '2022-12-31 23:15:24');

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

--
-- Table structure for table `site_notifications`
--

CREATE TABLE `site_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_notificational_id` int(11) NOT NULL,
  `site_notificational_type` varchar(255) 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 `sms_controls`
--

CREATE TABLE `sms_controls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `actionMethod` varchar(255) DEFAULT NULL,
  `actionUrl` varchar(255) DEFAULT NULL,
  `headerData` text DEFAULT NULL,
  `paramData` text DEFAULT NULL,
  `formData` 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 `sms_controls`
--

INSERT INTO `sms_controls` (`id`, `actionMethod`, `actionUrl`, `headerData`, `paramData`, `formData`, `created_at`, `updated_at`) VALUES
(1, 'POST', 'https://rest.nexmo.com/sms/json', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\"}', NULL, '{\"from\":\"Rownak\",\"text\":\"[[message]]\",\"to\":\"[[receiver]]\",\"api_key\":\"930cc608\",\"api_secret\":\"2pijsaMOUw5YKOK5\"}', '2020-12-13 01:45:29', '2022-06-29 00:34:54');

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

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

CREATE TABLE `stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `shipping_charge` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=>Inactive,1=>active',
  `delivery_note` varchar(10) NOT NULL DEFAULT 'disabled',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=>inactive , 1=>active',
  `link` text DEFAULT NULL,
  `short_description` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `user_id`, `name`, `image`, `shipping_charge`, `delivery_note`, `status`, `link`, `short_description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'LifeTime', '63a4098de066e1671694733.png', 1, 'disabled', 1, '317c4c69666554696d65', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters,', '2022-12-11 23:23:50', '2023-01-01 00:32:49', NULL),
(2, 1, 'Store Hook', '63a407e9100831671694313.png', 0, 'enable', 1, 'store-hook-shop', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', '2022-12-12 01:35:33', '2022-12-29 01:21:41', NULL),
(3, 1, 'asdf', '63b1281d3ec101672554525.png', 0, 'enable', 1, 'abc', 'sadf', '2023-01-01 00:28:45', '2023-01-01 00:29:54', '2023-01-01 00:29:54'),
(4, 1, 'dcb', '63b1284835fcf1672554568.png', 1, 'disabled', 1, '347c646362', '', '2023-01-01 00:29:28', '2023-01-01 00:29:49', '2023-01-01 00:29:49'),
(5, 1, 'afdf', '63b12b66028881672555366.png', 1, 'disabled', 1, 'asfgg', 'fd', '2023-01-01 00:42:46', '2023-01-01 00:42:49', '2023-01-01 00:42:49');

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

--
-- Table structure for table `store_categories`
--

CREATE TABLE `store_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) 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 `store_products`
--

CREATE TABLE `store_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `tag` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=>inactive , 1=>active',
  `description` longtext DEFAULT NULL,
  `instruction` longtext DEFAULT NULL,
  `thumbnail` 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 `store_product_attrs`
--

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

CREATE TABLE `store_product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image` 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 `store_product_stocks`
--

CREATE TABLE `store_product_stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_attr_lists_id` text DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `store_shippings`
--

CREATE TABLE `store_shippings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `charge` decimal(10,8) DEFAULT NULL,
  `status` tinyint(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 `subscribes`
--

CREATE TABLE `subscribes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL,
  `section_name` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` (`id`, `language_id`, `section_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 'banner', '{\"title\":\"TRUSTED ONLINE PAYMENT PLATFORM\",\"sub_title\":\"Low Transaction Fee to Boost Your Business\",\"short_description\":\"Your MXPay account is your key to unlock a universe of opportunities. Whether making international payments, receiving funds, managing your digital business, or accessing capital, MXPay opens your business up to the world.\",\"image_slogan\":\"+10  Years of Experience\"}', '2021-01-23 18:25:21', '2021-12-26 03:20:28'),
(2, 2, 'banner', '{\"title\":\"PLATAFORMA DE PAGO EN L\\u00cdNEA DE CONFIANZA\",\"sub_title\":\"Tarifa de transacci\\u00f3n baja para impulsar su negocio\",\"short_description\":\"Su cuenta MXPay es la clave para desbloquear un universo de oportunidades. Ya sea que realice pagos internacionales, reciba fondos, administre su negocio digital o acceda al capital, MXPay abre su negocio al mundo.\",\"image_slogan\":\"+10 a\\u00f1os de experiencia\"}', '2021-01-23 19:16:56', '2021-12-26 03:20:45'),
(3, 2, 'feature', '{\"title\":\"Caracter\\u00edsticas especiales\",\"sub_title\":\"Explorando nuestras caracter\\u00edsticas especiales\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exercitationem nam repellat.\"}', '2021-01-23 22:26:42', '2022-11-08 00:19:16'),
(4, 1, 'feature', '{\"title\":\"Special Features\",\"sub_title\":\"Exploring Our Special Features\",\"short_description\":\"MXPay offers seamless integration, real-time tracking, multi-currency support, robust security, user-friendly interfaces, quick settlements, and 24\\/7 support.<br \\/>\"}', '2021-01-23 22:27:00', '2024-06-05 09:43:39'),
(5, 1, 'about-us', '{\"title\":\"About Us\",\"sub_title\":\"Transfer and Deposite your money anytime, anywhere in the world\",\"short_description\":\"MXPay is end-to-end business solution which is provide to their client many services. Such as Send money, Request money, Voucher payment, Escrow, Withdraw money and more than 24 other payment gateways world wide.\"}', '2021-01-23 22:53:59', '2021-12-26 03:42:14'),
(6, 2, 'about-us', '{\"title\":\"Sobre nosotros\",\"sub_title\":\"Transfiere y deposita tu dinero en cualquier momento y en cualquier parte del mundo\",\"short_description\":\"MXPay es una soluci\\u00f3n comercial de extremo a extremo que brinda a sus clientes muchos servicios. Tales como Enviar dinero, Solicitar dinero, Pago de vales, Escrow, Retirar dinero y m\\u00e1s de 24 otras pasarelas de pago en todo el mundo.\"}', '2021-01-23 22:54:58', '2022-11-08 00:21:37'),
(7, 1, 'services', '{\"title\":\"Our Services\",\"sub_title\":\"Our Best Services\",\"short_description\":\"Enjoy the maximum services with MXPay digital solution and grow your business with us.\"}', '2021-01-23 23:14:34', '2021-12-26 03:52:28'),
(8, 2, 'services', '{\"title\":\"Nuestros servicios\",\"sub_title\":\"Nuestros mejores servicios\",\"short_description\":\"<p>Disfrute de los m\\u00e1ximos servicios con la soluci\\u00f3n digital MXPay y haga crecer su negocio con nosotros.<\\/p>\"}', '2021-01-23 23:15:29', '2022-11-08 00:22:32'),
(9, 1, 'how-it-works', '{\"title\":\"How It Works\",\"sub_title\":\"Get the best experience\",\"short_description\":\"MXPay is very easy to use. Just follow the below steps.\"}', '2021-01-23 23:37:31', '2021-12-26 04:34:24'),
(10, 2, 'how-it-works', '{\"title\":\"C\\u00f3mo funciona\",\"sub_title\":\"Obt\\u00e9n la mejor experiencia\",\"short_description\":\"MXPay es muy f\\u00e1cil de usar. Simplemente siga los pasos a continuaci\\u00f3n.\"}', '2021-01-23 23:37:45', '2021-12-26 04:34:46'),
(11, 1, 'faq', '{\"title\":\"FAQ\",\"sub_title\":\"Frequently Questions\",\"short_description\":\"Have a read through our FAQs for more information and if you have any further questions and would like us to get in touch.\"}', '2021-01-23 23:40:39', '2021-12-26 04:36:39'),
(12, 2, 'faq', '{\"title\":\"Preguntas m\\u00e1s frecuentes\",\"sub_title\":\"Preguntas frecuentes\",\"short_description\":\"Lea nuestras preguntas frecuentes para obtener m\\u00e1s informaci\\u00f3n y si tiene m\\u00e1s preguntas y desea que nos pongamos en contacto\"}', '2021-01-23 23:41:43', '2021-12-26 04:37:56'),
(13, 1, 'mobile-app', '{\"title\":\"Mobile App\",\"sub_title\":\"Manage Your Global Payments On The Wallet Mobile App\",\"short_description\":\"Download our latest version of the app from play store or app store and enjoy MXPay.\"}', '2021-01-24 00:13:47', '2021-12-26 04:53:59'),
(14, 1, 'clients-feedback', '{\"title\":\"Testimonials\",\"sub_title\":\"What Happy Clients Say\"}', '2021-01-24 00:21:45', '2022-06-06 05:39:55'),
(15, 1, 'blog', '{\"title\":\"Blog Posts\",\"sub_title\":\"Latest News &amp; Tips\",\"short_description\":\"MXPay offers seamless integration, real-time tracking, multi-currency support, robust security, user-friendly interfaces, quick settlements, and 24\\/7 support.<br \\/>\"}', '2021-01-24 00:30:10', '2024-06-05 09:44:42'),
(16, 2, 'mobile-app', '{\"title\":\"Aplicaci\\u00f3n movil\",\"sub_title\":\"Administre sus pagos globales en la aplicaci\\u00f3n m\\u00f3vil Wallet\",\"short_description\":\"Descargue nuestra \\u00faltima versi\\u00f3n de la aplicaci\\u00f3n desde Play Store o App Store y disfrute de MXPay.\"}', '2021-01-25 18:53:24', '2021-12-26 04:54:33'),
(17, 2, 'clients-feedback', '{\"title\":\"Testimonios\",\"sub_title\":\"Lo que dicen las clientes felices\"}', '2021-01-25 18:54:11', '2022-11-08 00:25:36'),
(18, 2, 'blog', '{\"title\":\"Publicaciones de blog\",\"sub_title\":\"\\u00daltimas noticias y Puntas\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exercitationem nam repellat.\"}', '2021-01-25 18:56:50', '2022-11-08 00:26:47'),
(19, 1, 'call', '{\"number\":\"+10236547896\",\"sub_title\":\"We are here to help your Transaction Call to discuss your Solute\"}', '2021-01-25 19:18:29', '2021-12-26 03:50:13'),
(20, 2, 'call', '{\"number\":\"+8801911105804\",\"sub_title\":\"Estamos aqu\\u00ed para ayudar a su Transaction Call para discutir su Solute\"}', '2021-01-25 19:18:40', '2021-01-28 00:00:29'),
(21, 1, 'customers-content', '{\"title\":\"What is Paypal Wallet?\",\"sub_title\":\"Payment Gateway Redefined\",\"short_description\":\"The project improves skills, fosters entrepreneurship and creates employment along selected value chains.\",\"total_users\":\"70000\",\"total_currency\":\"14000\",\"total_wallet\":\"200000\",\"gateways\":\"29\"}', '2021-01-27 22:21:32', '2022-06-08 06:20:39'),
(22, 2, 'customers-content', '{\"title\":\"Nuestros n\\u00fameros hablan\",\"sub_title\":\"Siempre intentamos comprender las expectativas de los clientes\",\"short_description\":\"<p>M\\u00e1s de 20.000 marcas confiables mediante Pay<br \\/><\\/p>\",\"happy_client\":\"550\",\"weekly_transaction\":\"100000\",\"monthly_transaction\":\"10000000\",\"yearly_transaction\":\"1000000000\"}', '2021-01-27 22:21:57', '2021-12-25 00:12:56'),
(23, 1, 'subscribe', '{\"title\":\"Newslatter\",\"sub_title\":\"Subscribe Our Newslatter\"}', '2021-02-10 05:36:27', '2021-02-10 05:36:27'),
(26, 1, 'login', '{\"title\":\"Login to Get Started\",\"sub_title\":\"Your ease of mind is our priority\",\"short_description\":\"Your ease of mind is our priority with MXPay\'s features.\",\"button_name\":\"Back To Home\"}', '2021-12-25 08:37:16', '2024-06-05 09:46:29'),
(27, 1, 'register', '{\"title\":\"Sign Up to Get Started\",\"sub_title\":\"Your ease of mind is our priority\",\"short_description\":\"Your ease of mind is our priority with MXPay\'s features.\",\"button_name\":\"Back To Home\"}', '2021-12-25 08:37:49', '2024-06-05 09:46:45'),
(28, 1, 'forget-password', '{\"title\":\"Reset Password\",\"sub_title\":\"Get reset password link\",\"short_description\":\"Your ease of mind is our priority with MXPay\'s features.\",\"button_name\":\"Back To Home\"}', '2021-12-25 08:38:16', '2024-06-05 09:47:00'),
(29, 1, 'reset-password', '{\"title\":\"Reset Password\",\"sub_title\":\"Enter your details to reset password\",\"short_description\":\"Your ease of mind is our priority with MXPay\'s features.\",\"button_name\":\"Back To Home\"}', '2021-12-25 08:39:39', '2024-06-05 09:47:15'),
(30, 1, 'email-verification', '{\"title\":\"Email Verification\",\"sub_title\":\"Verify your email\"}', '2021-12-25 08:40:06', '2021-12-25 08:40:06'),
(31, 1, 'sms-verification', '{\"title\":\"Phone Number Verification\",\"sub_title\":\"Verify your phone Number\"}', '2021-12-25 08:40:50', '2021-12-25 08:40:50'),
(32, 1, 'add-fund', '{\"short_description\":\"You can deposit money into your own wallet in multiple currencies\"}', '2021-12-25 09:09:33', '2021-12-25 09:13:07'),
(33, 1, 'send-money', '{\"short_description\":\"Send money to your friends and family instantly.\"}', '2021-12-25 09:13:56', '2021-12-26 05:14:35'),
(34, 1, 'request-money', '{\"short_description\":\"Send request for money to your desire one instantly.\"}', '2021-12-25 09:18:24', '2021-12-25 09:18:24'),
(35, 1, 'exchange-money', '{\"short_description\":\"Exchange money from your wallet to another wallet and enjoy hassle free transaction.\"}', '2021-12-25 09:19:33', '2021-12-25 09:19:33'),
(36, 1, 'generate-redeem-code', '{\"short_description\":\"Generate redeem code and share with your desire one and he\\/she will get the credit up.\"}', '2021-12-25 09:21:02', '2021-12-25 09:21:02'),
(37, 1, 'escrow', '{\"short_description\":\"Create escrow from here for your client and enjoy secure payment transaction.\"}', '2021-12-25 09:23:13', '2021-12-25 09:23:13'),
(38, 1, 'voucher-payment', '{\"short_description\":\"Generate voucher for your client and get instant money from them.\"}', '2021-12-25 09:25:30', '2021-12-25 09:25:30'),
(39, 1, 'payout-request', '{\"short_description\":\"Withdraw your money from here.\"}', '2021-12-25 09:26:45', '2021-12-25 09:26:45'),
(40, 2, 'subscribe', '{\"title\":\"Boletin informativo\",\"sub_title\":\"Suscr\\u00edbete a nuestro bolet\\u00edn\"}', '2021-12-26 05:11:16', '2021-12-26 05:11:16'),
(41, 2, 'login', '{\"title\":\"Iniciar sesi\\u00f3n para empezar\",\"sub_title\":\"Tu tranquilidad es nuestra prioridad\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exerci tationem.\",\"button_name\":\"De vuelta a casa\"}', '2021-12-26 05:12:26', '2022-11-08 00:32:03'),
(42, 2, 'register', '{\"title\":\"Reg\\u00edstrate para empezar\",\"sub_title\":\"Tu tranquilidad es nuestra prioridad\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exerci tationem.\",\"button_name\":\"De vuelta a casa\"}', '2021-12-26 05:12:42', '2022-11-08 00:32:58'),
(43, 2, 'forget-password', '{\"title\":\"Restablecer la contrase\\u00f1a\",\"sub_title\":\"Obtener enlace de restablecimiento de contrase\\u00f1a\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exerci tationem.\",\"button_name\":\"De vuelta a casa\"}', '2021-12-26 05:12:58', '2022-11-08 00:33:50'),
(44, 2, 'reset-password', '{\"title\":\"Restablecer la contrase\\u00f1a\",\"sub_title\":\"Ingrese sus datos para restablecer la contrase\\u00f1a\",\"short_description\":\"Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exerci tationem.\",\"button_name\":\"De vuelta a casa\"}', '2021-12-26 05:13:16', '2022-11-08 00:34:45'),
(45, 2, 'email-verification', '{\"title\":\"verificacion de email\",\"sub_title\":\"verifica tu correo electr\\u00f3nico\"}', '2021-12-26 05:13:35', '2021-12-26 05:13:35'),
(46, 2, 'sms-verification', '{\"title\":\"Verificaci\\u00f3n del n\\u00famero de tel\\u00e9fono\",\"sub_title\":\"Verifica tu numero de telefono\"}', '2021-12-26 05:13:53', '2021-12-26 05:13:53'),
(47, 2, 'add-fund', '{\"short_description\":\"Puede depositar dinero en su propia billetera en varias monedas\"}', '2021-12-26 05:14:09', '2021-12-26 05:14:09'),
(48, 2, 'send-money', '{\"short_description\":\"Env\\u00ede dinero a sus amigos y familiares al instante.\"}', '2021-12-26 05:14:43', '2021-12-26 05:14:43'),
(49, 2, 'request-money', '{\"short_description\":\"Env\\u00ede la solicitud de dinero a su deseo al instante.\"}', '2021-12-26 05:14:59', '2021-12-26 05:14:59'),
(50, 2, 'exchange-money', '{\"short_description\":\"Cambie dinero de su billetera a otra billetera y disfrute de transacciones sin problemas.\"}', '2021-12-26 05:15:12', '2021-12-26 05:15:12'),
(51, 2, 'generate-redeem-code', '{\"short_description\":\"Genere el c\\u00f3digo de canje y comp\\u00e1rtalo con su deseo y \\u00e9l \\/ ella obtendr\\u00e1 el cr\\u00e9dito.\"}', '2021-12-26 05:15:22', '2021-12-26 05:15:22'),
(52, 2, 'escrow', '{\"short_description\":\"Cree un dep\\u00f3sito en garant\\u00eda desde aqu\\u00ed para su cliente y disfrute de una transacci\\u00f3n de pago segura.\"}', '2021-12-26 05:15:36', '2021-12-26 05:15:36'),
(53, 2, 'voucher-payment', '{\"short_description\":\"Genere un cup\\u00f3n para su cliente y obtenga dinero instant\\u00e1neo de ellos.\"}', '2021-12-26 05:15:49', '2021-12-26 05:15:49'),
(54, 2, 'payout-request', '{\"short_description\":\"Retira tu dinero de aqu\\u00ed.\"}', '2021-12-26 05:16:02', '2021-12-26 05:16:02'),
(55, 1, 'get-started', '{\"title\":\"Get Started\",\"sub_title\":\"How to Get Started\",\"short_description\":\"MXPay offers seamless integration, real-time tracking, multi-currency support, robust security, user-friendly interfaces, quick settlements, and 24\\/7 support.\"}', '2022-06-06 05:14:26', '2024-06-05 09:44:14'),
(56, 1, 'contact', '{\"title\":\"Contact Information\",\"sub_title\":\"Contact Information We\\u2019ll create high-quality linkable content and build at least 40 high-authority.\"}', '2022-06-08 01:08:56', '2022-06-08 01:08:56'),
(57, 1, 'cookie-consent', '{\"title\":\"The Website uses cookies\",\"popup_short_description\":\"This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Cookie Policy.\",\"description\":\"<h1>Cookie Policy for bugfinder.net<\\/h1>\\n\\n<p>This is the Cookie Policy for MXPay, accessible from\\u00a0https:\\/\\/mxpay.mimeld.com<\\/p>\\n\\n<p><strong>What Are Cookies<\\/strong><\\/p>\\n\\n<p>As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or \'break\' certain elements of the sites functionality.<\\/p>\\n\\n<p><strong>How We Use Cookies<\\/strong><\\/p>\\n\\n<p>We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.<\\/p>\\n\\n<p><strong>Disabling Cookies<\\/strong><\\/p>\\n\\n<p>You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies. This Cookies Policy was created with the help of the <a href=\\\"https:\\/\\/www.cookiepolicygenerator.com\\/cookie-policy-generator\\/\\\">Cookies Policy Generator<\\/a>.<\\/p>\\n<p><strong>The Cookies We Set<\\/strong><\\/p>\\n\\n<ul>\\n\\n<li>\\n    <p>Account related cookies<\\/p>\\n    <p>If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Login related cookies<\\/p>\\n    <p>We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Email newsletters related cookies<\\/p>\\n    <p>This site offers newsletter or email subscription services and cookies may be used to remember if you are already registered and whether to show certain notifications which might only be valid to subscribed\\/unsubscribed users.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Orders processing related cookies<\\/p>\\n    <p>This site offers e-commerce or payment facilities and some cookies are essential to ensure that your order is remembered between pages so that we can process it properly.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Surveys related cookies<\\/p>\\n    <p>From time to time we offer user surveys and questionnaires to provide you with interesting insights, helpful tools, or to understand our user base more accurately. These surveys may use cookies to remember who has already taken part in a survey or to provide you with accurate results after you change pages.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Forms related cookies<\\/p>\\n    <p>When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Site preferences cookies<\\/p>\\n    <p>In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.<\\/p>\\n<\\/li>\\n\\n<\\/ul>\\n\\n<p><strong>Third Party Cookies<\\/strong><\\/p>\\n\\n<p>In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.<\\/p>\\n\\n<ul>\\n\\n<li>\\n    <p>This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.<\\/p>\\n    <p>For more information on Google Analytics cookies, see the official Google Analytics page.<\\/p>\\n<\\/li>\\n\\n<li>\\n    <p>Third party analytics are used to track and measure usage of this site so that we can continue to produce engaging content. These cookies may track things such as how long you spend on the site or pages you visit which helps us to understand how we can improve the site for you.<\\/p>\\n<\\/li>\\n\\n\\n\\n\\n\\n\\n\\n\\n<\\/ul>\\n\\n<p><strong>More Information<\\/strong><\\/p>\\n\\n<p>Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren\'t sure whether you need or not it\'s usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.<\\/p>\\n\\n<p>For more general information on cookies, please read <a href=\\\"https:\\/\\/www.cookiepolicygenerator.com\\/sample-cookies-policy\\/\\\">the Cookies Policy article<\\/a>.<\\/p>\\n\\n<p>However if you are still looking for more information then you can contact us through one of our preferred contact methods:<\\/p>\\n\\n<ul>\\n<li>Email: <\\/li>\\n<li>By visiting this link: <\\/li>\\n<\\/ul>\"}', '2022-10-04 10:39:20', '2024-06-05 09:48:09'),
(58, 2, 'cookie-consent', '{\"title\":\"El sitio web utiliza cookies\",\"popup_short_description\":\"Este sitio web utiliza cookies para mejorar la experiencia del usuario. Al utilizar nuestro sitio web, acepta todas las cookies de acuerdo con nuestra Pol\\u00edtica de cookies.\",\"description\":\"<h1>Cookie Policy for bugfinder.net<\\/h1>\\r\\n\\r\\n<p>This is the Cookie Policy for bugfinder.net, accessible from https:\\/\\/bugfinder.net<\\/p>\\r\\n\\r\\n<p><strong>What Are Cookies<\\/strong><\\/p>\\r\\n\\r\\n<p>As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or \'break\' certain elements of the sites functionality.<\\/p>\\r\\n\\r\\n<p><strong>How We Use Cookies<\\/strong><\\/p>\\r\\n\\r\\n<p>We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.<\\/p>\\r\\n\\r\\n<p><strong>Disabling Cookies<\\/strong><\\/p>\\r\\n\\r\\n<p>You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies. This Cookies Policy was created with the help of the <a href=\\\"https:\\/\\/www.cookiepolicygenerator.com\\/cookie-policy-generator\\/\\\">Cookies Policy Generator<\\/a>.<\\/p>\\r\\n<p><strong>The Cookies We Set<\\/strong><\\/p>\\r\\n\\r\\n<ul>\\r\\n\\r\\n<li>\\r\\n    <p>Account related cookies<\\/p>\\r\\n    <p>If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Login related cookies<\\/p>\\r\\n    <p>We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Email newsletters related cookies<\\/p>\\r\\n    <p>This site offers newsletter or email subscription services and cookies may be used to remember if you are already registered and whether to show certain notifications which might only be valid to subscribed\\/unsubscribed users.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Orders processing related cookies<\\/p>\\r\\n    <p>This site offers e-commerce or payment facilities and some cookies are essential to ensure that your order is remembered between pages so that we can process it properly.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Surveys related cookies<\\/p>\\r\\n    <p>From time to time we offer user surveys and questionnaires to provide you with interesting insights, helpful tools, or to understand our user base more accurately. These surveys may use cookies to remember who has already taken part in a survey or to provide you with accurate results after you change pages.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Forms related cookies<\\/p>\\r\\n    <p>When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Site preferences cookies<\\/p>\\r\\n    <p>In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<\\/ul>\\r\\n\\r\\n<p><strong>Third Party Cookies<\\/strong><\\/p>\\r\\n\\r\\n<p>In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.<\\/p>\\r\\n\\r\\n<ul>\\r\\n\\r\\n<li>\\r\\n    <p>This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.<\\/p>\\r\\n    <p>For more information on Google Analytics cookies, see the official Google Analytics page.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n<li>\\r\\n    <p>Third party analytics are used to track and measure usage of this site so that we can continue to produce engaging content. These cookies may track things such as how long you spend on the site or pages you visit which helps us to understand how we can improve the site for you.<\\/p>\\r\\n<\\/li>\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n<\\/ul>\\r\\n\\r\\n<p><strong>More Information<\\/strong><\\/p>\\r\\n\\r\\n<p>Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren\'t sure whether you need or not it\'s usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.<\\/p>\\r\\n\\r\\n<p>For more general information on cookies, please read <a href=\\\"https:\\/\\/www.cookiepolicygenerator.com\\/sample-cookies-policy\\/\\\">the Cookies Policy article<\\/a>.<\\/p>\\r\\n\\r\\n<p>However if you are still looking for more information then you can contact us through one of our preferred contact methods:<\\/p>\\r\\n\\r\\n<ul>\\r\\n<li>Email: <\\/li>\\r\\n<li>By visiting this link: <\\/li>\\r\\n<\\/ul>\"}', '2022-10-04 10:40:03', '2022-11-08 01:24:08'),
(59, 2, 'get-started', '{\"title\":\"Empezar\",\"sub_title\":\"C\\u00f3mo empezar\",\"short_description\":\"<p>Neque expedita, nobis eius excepturi minima ad repellendus quo quas qui, quisquam molestias illo velit cum amet beatae porro in exercitationem nam repellat.<br \\/><\\/p>\"}', '2022-11-08 00:24:05', '2022-11-08 00:24:05'),
(60, 2, 'contact', '{\"title\":\"Informaci\\u00f3n del contacto\",\"sub_title\":\"Informaci\\u00f3n de contacto Crearemos contenido enlazable de alta calidad y construiremos al menos 40 de alta autoridad.\"}', '2022-11-08 00:30:55', '2022-11-08 00:30:55'),
(61, 1, 'invoice-payment', '{\"short_description\":\"Generate invoice for your client and get instant money from them.\"}', '2022-12-10 23:30:35', '2022-12-10 23:43:28'),
(62, 2, 'invoice-payment', '{\"short_description\":\"Genere cup\\u00f3n para su cliente y obtenga dinero instant\\u00e1neo de ellos.\"}', '2022-12-10 23:30:40', '2022-12-10 23:43:42'),
(63, 1, 'virtual-card', '{\"short_description\":\"A \\u201cvirtual card\\u201d is stored on your phone and can be used to pay contactless in stores or online, but has its own unique card number, expiry date, and CVC.\"}', '2023-01-05 01:11:25', '2023-01-05 01:11:25'),
(64, 1, '2fa-verification', '{\"title\":\"2 FA  Verification\",\"sub_title\":\"Verify you are authenticate user\"}', '2023-03-02 00:57:07', '2023-03-02 00:57:07');

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

--
-- Table structure for table `template_media`
--

CREATE TABLE `template_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_name` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_media`
--

INSERT INTO `template_media` (`id`, `section_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'banner', '{\"image\":\"600d2670c10fa1611474544.jpg\",\"thumbnail\":\"6016b3390b4991612100409.jpg\"}', '2021-01-24 01:37:14', '2021-01-31 07:40:09'),
(2, 'about-us', '{\"image\":\"600f9e09f04d21611636233.jpg\",\"thumbnail\":\"600f9e0a02f021611636234.jpg\",\"youtube_link\":\"https:\\/\\/www.youtube.com\\/embed\\/OsXedJq1aWE\"}', '2021-01-24 06:12:07', '2021-01-25 22:43:54'),
(3, 'faq', '{\"image\":\"600d6424eec9f1611490340.png\"}', '2021-01-24 06:12:20', '2021-01-24 06:12:21'),
(5, 'call', '{\"image\":\"600fc2456e99c1611645509.png\"}', '2021-01-26 01:18:29', '2021-01-26 01:18:29'),
(6, 'login', '{\"image\":\"61c72c9cb78d21640443036.jpg\",\"button_link\":\"https:\\/\\/mxpay.mimeld.com\\/\"}', '2021-12-25 08:37:16', '2024-06-05 09:46:29'),
(7, 'register', '{\"image\":\"61c72cbdedff01640443069.jpg\",\"button_link\":\"https:\\/\\/mxpay.mimeld.com\\/\"}', '2021-12-25 08:37:49', '2024-06-05 09:46:45'),
(8, 'forget-password', '{\"image\":\"61c72cd840ca71640443096.jpg\",\"button_link\":\"https:\\/\\/mxpay.mimeld.com\\/\"}', '2021-12-25 08:38:16', '2024-06-05 09:47:00'),
(9, 'reset-password', '{\"image\":\"61c72d2b65eec1640443179.jpg\",\"button_link\":\"https:\\/\\/mxpay.mimeld.com\\/\"}', '2021-12-25 08:39:39', '2024-06-05 09:47:15'),
(10, 'email-verification', '{\"image\":\"61c72d46987031640443206.jpg\"}', '2021-12-25 08:40:06', '2021-12-25 08:40:06'),
(11, 'sms-verification', '{\"image\":\"61c72d72f39aa1640443250.jpg\"}', '2021-12-25 08:40:50', '2021-12-25 08:40:51'),
(12, 'feature', '{\"image\":\"62ba9f49f2e901656397641.png\"}', '2022-06-06 04:18:07', '2022-06-28 00:27:22'),
(13, 'get-started', '{\"image\":\"62ba9fd3333d21656397779.png\"}', '2022-06-06 05:14:26', '2022-06-28 00:29:39');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(91) DEFAULT NULL,
  `ticket` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed	',
  `last_reply` 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 `ticket_attachments`
--

CREATE TABLE `ticket_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_message_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ticket_messages`
--

CREATE TABLE `ticket_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED 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 `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactional_id` int(11) NOT NULL,
  `transactional_type` varchar(255) NOT NULL,
  `amount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_code` varchar(10) 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 `transactions`
--

INSERT INTO `transactions` (`id`, `transactional_id`, `transactional_type`, `amount`, `charge`, `currency_id`, `currency_code`, `created_at`, `updated_at`) VALUES
(1, 1, 'App\\Models\\Fund', 5000.00000000, 0.00000000, 1, NULL, '2023-05-03 17:15:04', '2023-05-03 17:15:04');

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

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

CREATE TABLE `transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Percent of charge',
  `charge_percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'After adding percent of charge',
  `charge_fixed` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `transfer_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount deduct from sender',
  `received_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount add to receiver',
  `charge_from` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Sender, 1 = Receiver',
  `note` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=Success,0=Pending',
  `utr` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `two_factor_settings`
--

CREATE TABLE `two_factor_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `security_question_id` bigint(20) UNSIGNED DEFAULT NULL,
  `answer` varchar(255) DEFAULT NULL COMMENT 'Security question answer',
  `hints` varchar(255) DEFAULT NULL COMMENT 'Security question answer hints',
  `security_pin` varchar(255) DEFAULT NULL,
  `enable_for` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `two_factor_settings`
--

INSERT INTO `two_factor_settings` (`id`, `user_id`, `security_question_id`, `answer`, `hints`, `security_pin`, `enable_for`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, NULL, NULL, NULL, '2023-03-16 00:34:39', '2023-03-16 00:34:39');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_by` int(11) DEFAULT NULL,
  `store_currency_id` int(11) DEFAULT NULL,
  `qr_currency_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 = inactive, 1 = active',
  `qr_link` text DEFAULT NULL,
  `language_id` bigint(20) DEFAULT NULL,
  `email_verification` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = inactive, 1 = active',
  `sms_verification` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = inactive, 1 = active',
  `verify_code` varchar(10) DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL,
  `two_fa` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: two-FA off, 1: two-FA on	',
  `two_fa_verify` tinyint(1) NOT NULL DEFAULT 1 COMMENT '	0: two-FA unverified, 1: two-FA verified	',
  `two_fa_code` varchar(20) DEFAULT NULL,
  `kyc_verified` tinyint(4) DEFAULT NULL COMMENT '0=> not verified, 1=>pending , 2=> verified 3=>rejected',
  `password` varchar(255) NOT NULL,
  `public_key` varchar(191) DEFAULT NULL COMMENT 'business api key',
  `secret_key` varchar(191) DEFAULT NULL COMMENT 'business api key',
  `mode` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=>test,1=>live',
  `remember_token` varchar(100) DEFAULT NULL,
  `fcm_token` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `notify_active_template` text DEFAULT NULL COMMENT 'notification enable'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `ref_by`, `store_currency_id`, `qr_currency_id`, `name`, `username`, `email`, `email_verified_at`, `status`, `qr_link`, `language_id`, `email_verification`, `sms_verification`, `verify_code`, `sent_at`, `two_fa`, `two_fa_verify`, `two_fa_code`, `kyc_verified`, `password`, `public_key`, `secret_key`, `mode`, `remember_token`, `fcm_token`, `created_at`, `updated_at`, `notify_active_template`) VALUES
(1, NULL, NULL, NULL, 'User1 Demo', 'user1', 'user@demo.com', NULL, 1, 'JFOCGKFVAVPO622OKVWA', 1, 1, 1, NULL, NULL, 0, 1, NULL, 2, '$2y$10$PpdYogi2fIoD4lNu4Ww87O.KIYwRHhYCDKzVUlfPzMpMjLDcoHHg6', 'c819b37cd0593a5b80f2e64991cd0c1b35154eef', '99eca97e3753b205d00ad696289d1fbb9059914a', 0, NULL, NULL, '2023-05-03 17:14:04', '2024-03-28 10:03:32', '[\"TRANSFER_TO\",\"TRANSFER_FROM\",\"REQUEST_MONEY_INIT\",\"REQUEST_MONEY_CONFIRM\",\"REQUEST_MONEY_CANCEL\",\"MONEY_EXCHANGE\",\"REDEEM_CODE_GENERATE\",\"REDEEM_CODE_SENDER\",\"REDEEM_CODE_USED_BY\",\"ESCROW_REQUEST_SENDER\",\"ESCROW_REQUEST_RECEIVER\",\"ESCROW_REQUEST_ACCEPT_FROM\",\"ESCROW_REQUEST_ACCEPT_BY\",\"ESCROW_REQUEST_CANCEL_FROM\",\"ESCROW_REQUEST_CANCEL_BY\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_FROM\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_BY\",\"ESCROW_PAYMENT_DISBURSED_FROM\",\"ESCROW_PAYMENT_DISBURSED_BY\",\"DISPUTE_REQUEST_TO_USER\",\"VOUCHER_PAYMENT_REQUEST_TO\",\"VOUCHER_PAYMENT_REQUEST_FROM\",\"VOUCHER_PAYMENT_TO\",\"VOUCHER_PAYMENT_FROM\",\"VOUCHER_PAYMENT_CANCEL_TO\",\"VOUCHER_PAYMENT_CANCEL_FROM\",\"PAYOUT_REQUEST_FROM\",\"PAYOUT_CONFIRM\",\"PAYOUT_CANCEL\",\"ADD_FUND_USER_USER\",\"DEPOSIT_BONUS\",\"LOGIN_BONUS\",\"ADMIN_REPLIED_TICKET\",\"INVOICE_PAYMENT_TO\",\"INVOICE_PAYMENT_FROM\",\"KYC_APPROVE\",\"KYC_REJECT\",\"PRODUCT_ORDER\",\"QR_PAYMENT_TO\",\"QR_PAYMENT_FROM\",\"VIRTUAL_CARD_APPLY\",\"ADMIN_VIRTUAL_CARD_APPLY\",\"VIRTUAL_CARD_REJECTED\",\"VIRTUAL_CARD_APPROVE\",\"VIRTUAL_CARD_FUND_RETURN\",\"VIRTUAL_CARD_FUND_APPROVE\",\"VIRTUAL_CARD_UNBLOCK\",\"VIRTUAL_CARD_BLOCK\",\"BILL_PAYMENT_RETURN\",\"BILL_PAY\",\"API_PAYMENT\",\"ADMIN_API_PAYMENT\"]'),
(2, NULL, NULL, NULL, 'User2 Demo', 'user2', 'user2@demo.com', NULL, 1, 'QE6F4M9KAUXU9SCAUGFZ', 1, 1, 1, NULL, NULL, 0, 1, NULL, NULL, '$2y$10$5E2wdwdLPOSWq9Sy4q0TaO31tj7nWP3Jdcr10SuhTJYvAtXl3qEj.', NULL, NULL, 0, NULL, NULL, '2023-05-03 17:18:09', '2024-04-01 12:02:44', '[\"TRANSFER_TO\",\"TRANSFER_FROM\",\"REQUEST_MONEY_INIT\",\"REQUEST_MONEY_CONFIRM\",\"REQUEST_MONEY_CANCEL\",\"MONEY_EXCHANGE\",\"REDEEM_CODE_GENERATE\",\"REDEEM_CODE_SENDER\",\"REDEEM_CODE_USED_BY\",\"ESCROW_REQUEST_SENDER\",\"ESCROW_REQUEST_RECEIVER\",\"ESCROW_REQUEST_ACCEPT_FROM\",\"ESCROW_REQUEST_ACCEPT_BY\",\"ESCROW_REQUEST_CANCEL_FROM\",\"ESCROW_REQUEST_CANCEL_BY\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_FROM\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_BY\",\"ESCROW_PAYMENT_DISBURSED_FROM\",\"ESCROW_PAYMENT_DISBURSED_BY\",\"DISPUTE_REQUEST_TO_USER\",\"VOUCHER_PAYMENT_REQUEST_TO\",\"VOUCHER_PAYMENT_REQUEST_FROM\",\"VOUCHER_PAYMENT_TO\",\"VOUCHER_PAYMENT_FROM\",\"VOUCHER_PAYMENT_CANCEL_TO\",\"VOUCHER_PAYMENT_CANCEL_FROM\",\"PAYOUT_REQUEST_FROM\",\"PAYOUT_CONFIRM\",\"PAYOUT_CANCEL\",\"ADD_FUND_USER_USER\",\"DEPOSIT_BONUS\",\"LOGIN_BONUS\",\"ADMIN_REPLIED_TICKET\",\"INVOICE_PAYMENT_TO\",\"INVOICE_PAYMENT_FROM\",\"KYC_APPROVE\",\"KYC_REJECT\",\"PRODUCT_ORDER\",\"QR_PAYMENT_TO\",\"QR_PAYMENT_FROM\",\"VIRTUAL_CARD_APPLY\",\"ADMIN_VIRTUAL_CARD_APPLY\",\"VIRTUAL_CARD_REJECTED\",\"VIRTUAL_CARD_APPROVE\",\"VIRTUAL_CARD_FUND_RETURN\",\"VIRTUAL_CARD_FUND_APPROVE\",\"VIRTUAL_CARD_UNBLOCK\",\"VIRTUAL_CARD_BLOCK\",\"BILL_PAYMENT_RETURN\",\"BILL_PAY\",\"API_PAYMENT\",\"ADMIN_API_PAYMENT\"]'),
(3, NULL, NULL, NULL, 'New User', 'newuser', 'newuser@demo.com', NULL, 1, '155VYV5CK49MKUJZCO7V', 1, 1, 1, NULL, NULL, 0, 1, NULL, NULL, '$2y$10$krGakFMX6ITMNPRu2eA3FOC7z8YQtNYozvHDBHkpfMJgUhF.W912K', NULL, NULL, 0, NULL, NULL, '2024-04-01 10:08:35', '2024-04-01 10:52:45', '[\"TRANSFER_TO\",\"TRANSFER_FROM\",\"REQUEST_MONEY_INIT\",\"REQUEST_MONEY_CONFIRM\",\"REQUEST_MONEY_CANCEL\",\"MONEY_EXCHANGE\",\"REDEEM_CODE_GENERATE\",\"REDEEM_CODE_SENDER\",\"REDEEM_CODE_USED_BY\",\"ESCROW_REQUEST_SENDER\",\"ESCROW_REQUEST_RECEIVER\",\"ESCROW_REQUEST_ACCEPT_FROM\",\"ESCROW_REQUEST_ACCEPT_BY\",\"ESCROW_REQUEST_CANCEL_FROM\",\"ESCROW_REQUEST_CANCEL_BY\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_FROM\",\"ESCROW_PAYMENT_DISBURSED_REQUEST_BY\",\"ESCROW_PAYMENT_DISBURSED_FROM\",\"ESCROW_PAYMENT_DISBURSED_BY\",\"DISPUTE_REQUEST_TO_USER\",\"VOUCHER_PAYMENT_REQUEST_TO\",\"VOUCHER_PAYMENT_REQUEST_FROM\",\"VOUCHER_PAYMENT_TO\",\"VOUCHER_PAYMENT_FROM\",\"VOUCHER_PAYMENT_CANCEL_TO\",\"VOUCHER_PAYMENT_CANCEL_FROM\",\"PAYOUT_REQUEST_FROM\",\"PAYOUT_CONFIRM\",\"PAYOUT_CANCEL\",\"ADD_FUND_USER_USER\",\"DEPOSIT_BONUS\",\"LOGIN_BONUS\",\"ADMIN_REPLIED_TICKET\",\"INVOICE_PAYMENT_TO\",\"INVOICE_PAYMENT_FROM\",\"KYC_APPROVE\",\"KYC_REJECT\",\"PRODUCT_ORDER\",\"QR_PAYMENT_TO\",\"QR_PAYMENT_FROM\",\"VIRTUAL_CARD_APPLY\",\"ADMIN_VIRTUAL_CARD_APPLY\",\"VIRTUAL_CARD_REJECTED\",\"VIRTUAL_CARD_APPROVE\",\"VIRTUAL_CARD_FUND_RETURN\",\"VIRTUAL_CARD_FUND_APPROVE\",\"VIRTUAL_CARD_UNBLOCK\",\"VIRTUAL_CARD_BLOCK\",\"BILL_PAYMENT_RETURN\",\"BILL_PAY\",\"API_PAYMENT\",\"ADMIN_API_PAYMENT\"]');

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

--
-- Table structure for table `user_kycs`
--

CREATE TABLE `user_kycs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `kyc_info` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=>pending , 1=> verified, 2=>rejected',
  `reason` longtext DEFAULT NULL COMMENT 'rejected reason',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_kycs`
--

INSERT INTO `user_kycs` (`id`, `user_id`, `kyc_info`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(1, 1, '{\"DrivingLiences\":{\"field_name\":\"Driving Liences\",\"field_value\":\"yes\",\"type\":\"text\"},\"Address\":{\"field_name\":\"Address\",\"field_value\":\"this is awesome\",\"type\":\"textarea\"},\"PassportDocument\":{\"field_name\":\"Passport Document\",\"field_value\":\"6452658438e4f1683121540.png\",\"type\":\"file\"}}', 1, NULL, '2023-05-03 17:15:40', '2023-05-03 17:15:58');

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

--
-- Table structure for table `user_profiles`
--

CREATE TABLE `user_profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city` varchar(32) DEFAULT NULL,
  `state` varchar(32) DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `phone_code` varchar(8) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `about_me` text DEFAULT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `last_login_ip` varchar(16) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_profiles`
--

INSERT INTO `user_profiles` (`id`, `user_id`, `city`, `state`, `phone`, `phone_code`, `address`, `about_me`, `profile_picture`, `last_login_at`, `last_login_ip`, `created_at`, `updated_at`) VALUES
(1, 1, '', '', '9876543210', '+91', '', NULL, NULL, '2024-07-09 10:25:29', '59.91.142.191', '2023-05-03 17:14:04', '2024-07-09 10:25:29'),
(2, 2, '', '', '9876543211', '+91', '', NULL, NULL, NULL, NULL, '2023-05-03 17:18:09', '2024-04-01 09:56:09'),
(3, 3, '', '', '9988776655', '+91', '', NULL, NULL, NULL, NULL, '2024-04-01 10:08:35', '2024-04-01 10:11:54');

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

--
-- Table structure for table `virtual_card_methods`
--

CREATE TABLE `virtual_card_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `parameters` text DEFAULT NULL,
  `currencies` text DEFAULT NULL,
  `debit_currency` varchar(20) DEFAULT NULL,
  `extra_parameters` text DEFAULT NULL,
  `add_fund_parameter` text DEFAULT NULL,
  `form_field` text DEFAULT NULL,
  `currency` text DEFAULT NULL,
  `symbol` text DEFAULT NULL,
  `info_box` mediumtext DEFAULT NULL,
  `alert_message` text NOT NULL COMMENT 'anything need to admin inform from alert',
  `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 `virtual_card_methods`
--

INSERT INTO `virtual_card_methods` (`id`, `code`, `name`, `image`, `status`, `parameters`, `currencies`, `debit_currency`, `extra_parameters`, `add_fund_parameter`, `form_field`, `currency`, `symbol`, `info_box`, `alert_message`, `created_at`, `updated_at`) VALUES
(1, 'flutterwave', 'Flutterwave', '63c2aab64d6e41673702070.jpg', 1, '{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\"}', '{\"0\":{\"NGN\":\"NGN\",\"USD\":\"USD\"}}', 'NGN', NULL, '{\"NGN\":{\"MinimumAmount\":{\"field_name\":\"MinimumAmount\",\"field_level\":\"Minimum Amount\",\"field_value\":\"500\",\"type\":\"text\",\"validation\":\"required\"},\"MaximumAmount\":{\"field_name\":\"MaximumAmount\",\"field_level\":\"Maximum Amount\",\"field_value\":\"10000\",\"type\":\"text\",\"validation\":\"required\"},\"PercentCharge\":{\"field_name\":\"PercentCharge\",\"field_level\":\"Percent Charge\",\"field_value\":\"2.3\",\"type\":\"text\",\"validation\":\"required\"},\"FixedCharge\":{\"field_name\":\"FixedCharge\",\"field_level\":\"Fixed Charge\",\"field_value\":\"2\",\"type\":\"text\",\"validation\":\"required\"},\"OpeningAmount\":{\"field_name\":\"OpeningAmount\",\"field_level\":\"Opening Amount\",\"field_value\":\"15\",\"type\":\"text\",\"validation\":\"required\"}},\"USD\":{\"MinimumAmount\":{\"field_name\":\"MinimumAmount\",\"field_level\":\"Minimum Amount\",\"field_value\":\"5\",\"type\":\"text\",\"validation\":\"required\"},\"MaximumAmount\":{\"field_name\":\"MaximumAmount\",\"field_level\":\"Maximum Amount\",\"field_value\":\"500\",\"type\":\"text\",\"validation\":\"required\"},\"PercentCharge\":{\"field_name\":\"PercentCharge\",\"field_level\":\"Percent Charge\",\"field_value\":\"1\",\"type\":\"text\",\"validation\":\"required\"},\"FixedCharge\":{\"field_name\":\"FixedCharge\",\"field_level\":\"Fixed Charge\",\"field_value\":\"2\",\"type\":\"text\",\"validation\":\"required\"},\"OpeningAmount\":{\"field_name\":\"OpeningAmount\",\"field_level\":\"Opening Amount\",\"field_value\":\"5\",\"type\":\"text\",\"validation\":\"required\"}}}', '{\"FirstName\":{\"field_name\":\"FirstName\",\"field_level\":\"First Name\",\"field_place\":\"Example\",\"type\":\"text\",\"validation\":\"required\"},\"LastName\":{\"field_name\":\"LastName\",\"field_level\":\"Last Name\",\"field_place\":\"User\",\"type\":\"text\",\"validation\":\"required\"},\"DateOfBirth\":{\"field_name\":\"DateOfBirth\",\"field_level\":\"Date Of Birth\",\"field_place\":\"1996/12/30\",\"type\":\"date\",\"validation\":\"required\"},\"Email\":{\"field_name\":\"Email\",\"field_level\":\"Email\",\"field_place\":\"userg@example.com\",\"type\":\"text\",\"validation\":\"required\"},\"Phone\":{\"field_name\":\"Phone\",\"field_level\":\"Phone\",\"field_place\":\"07030000000\",\"type\":\"text\",\"validation\":\"required\"},\"Title\":{\"field_name\":\"Title\",\"field_level\":\"Title\",\"field_place\":\"MR\",\"type\":\"text\",\"validation\":\"required\"},\"Gender\":{\"field_name\":\"Gender\",\"field_level\":\"Gender\",\"field_place\":\"M\",\"type\":\"text\",\"validation\":\"required\"},\"BillingName\":{\"field_name\":\"BillingName\",\"field_level\":\"Billing Name\",\"field_place\":\"Example User.\",\"type\":\"text\",\"validation\":\"nullable\"},\"BillingAddress\":{\"field_name\":\"BillingAddress\",\"field_level\":\"Billing Address\",\"field_place\":\"333, Fremont Street\",\"type\":\"text\",\"validation\":\"nullable\"},\"BillingCity\":{\"field_name\":\"BillingCity\",\"field_level\":\"Billing City\",\"field_place\":\"San Francisco\",\"type\":\"text\",\"validation\":\"nullable\"},\"BillingState\":{\"field_name\":\"BillingState\",\"field_level\":\"Billing State\",\"field_place\":\"CA\",\"type\":\"text\",\"validation\":\"nullable\"},\"BillingCountry\":{\"field_name\":\"BillingCountry\",\"field_level\":\"Billing Country\",\"field_place\":\"US\",\"type\":\"text\",\"validation\":\"nullable\"},\"BillingPostalCode\":{\"field_name\":\"BillingPostalCode\",\"field_level\":\"Billing Postal Code\",\"field_place\":\"94105\",\"type\":\"text\",\"validation\":\"nullable\"}}', '[\"NGN\",\"USD\"]', '[\"₦\",\"$\"]', 'The Flutterwave API allows you to create virtual cards that can be used online to make purchases and complete payments.', '', NULL, '2023-03-16 00:18:27'),
(4, 'ufitpay', 'UfitPay', '63baa1ee7a31c1673175534.png', 0, '{\"Api_Key\":\"\",\"Api_Token\":\"\"}', '{\"0\":{\"NGN\":\"NGN\",\"USD\":\"USD\"}}', 'USD', '', '{\"NGN\":{\"MinimumAmount\":{\"field_name\":\"MinimumAmount\",\"field_level\":\"Minimum Amount\",\"field_value\":\"2500\",\"type\":\"text\",\"validation\":\"required\"},\"MaximumAmount\":{\"field_name\":\"MaximumAmount\",\"field_level\":\"Maximum Amount\",\"field_value\":\"25000\",\"type\":\"text\",\"validation\":\"required\"},\"PercentCharge\":{\"field_name\":\"PercentCharge\",\"field_level\":\"Percent Charge\",\"field_value\":\"2\",\"type\":\"text\",\"validation\":\"required\"},\"FixedCharge\":{\"field_name\":\"FixedCharge\",\"field_level\":\"Fixed Charge\",\"field_value\":\"4\",\"type\":\"text\",\"validation\":\"required\"},\"OpeningAmount\":{\"field_name\":\"OpeningAmount\",\"field_level\":\"Opening Amount\",\"field_value\":\"15\",\"type\":\"text\",\"validation\":\"required\"}},\"USD\":{\"MinimumAmount\":{\"field_name\":\"MinimumAmount\",\"field_level\":\"Minimum Amount\",\"field_value\":\"10\",\"type\":\"text\",\"validation\":\"required\"},\"MaximumAmount\":{\"field_name\":\"MaximumAmount\",\"field_level\":\"Maximum Amount\",\"field_value\":\"500\",\"type\":\"text\",\"validation\":\"required\"},\"PercentCharge\":{\"field_name\":\"PercentCharge\",\"field_level\":\"Percent Charge\",\"field_value\":\"1\",\"type\":\"text\",\"validation\":\"required\"},\"FixedCharge\":{\"field_name\":\"FixedCharge\",\"field_level\":\"Fixed Charge\",\"field_value\":\"2\",\"type\":\"text\",\"validation\":\"required\"},\"OpeningAmount\":{\"field_name\":\"OpeningAmount\",\"field_level\":\"Opening Amount\",\"field_value\":\"3000\",\"type\":\"text\",\"validation\":\"required\"}}}', '{\"FirstName\":{\"field_name\":\"FirstName\",\"field_level\":\"First Name\",\"field_place\":\"Alex\",\"type\":\"text\",\"validation\":\"required\"},\"LastName\":{\"field_name\":\"LastName\",\"field_level\":\"Last Name\",\"field_place\":\"Hels\",\"type\":\"text\",\"validation\":\"required\"},\"Email\":{\"field_name\":\"Email\",\"field_level\":\"Email\",\"field_place\":\"alexhels@gmail.com\",\"type\":\"text\",\"validation\":\"required\"},\"Phone\":{\"field_name\":\"Phone\",\"field_level\":\"Phone\",\"field_place\":\"965852369\",\"type\":\"text\",\"validation\":\"required\"},\"BVN\":{\"field_name\":\"BVN\",\"field_level\":\"BVM\",\"field_place\":\"22485231397\",\"type\":\"text\",\"validation\":\"nullable\"}}', '[\"NGN\",\"USD\"]', '[\"₦\",\"$\"]', 'UfitPay offer you a simplified, unified, secure &amp; convenient banking, payment and fintech solutions, at much cheaper price.', 'Minimum Opening Amount: 10 USD or 2500 NGN', NULL, '2023-03-16 00:18:27');

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

--
-- Table structure for table `virtual_card_orders`
--

CREATE TABLE `virtual_card_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `virtual_card_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `form_input` text DEFAULT NULL,
  `status` tinyint(10) NOT NULL DEFAULT 0 COMMENT '0=>pending,1=>approve,2=>rejected,3=>resubmit,4=>generate,5=>block rqst,6=>fund rejected,7=>block,8=>add_fund_rqst,9=>inactive',
  `fund_amount` double NOT NULL DEFAULT 0,
  `fund_charge` double NOT NULL DEFAULT 0,
  `reason` text DEFAULT NULL,
  `resubmitted` tinyint(4) DEFAULT NULL COMMENT '0=>no,1=>yes',
  `charge` double NOT NULL DEFAULT 0 COMMENT 'admin charge',
  `charge_currency` int(11) DEFAULT NULL COMMENT 'admin base currency',
  `card_info` text DEFAULT NULL COMMENT 'response card information',
  `balance` double NOT NULL DEFAULT 0,
  `cvv` varchar(100) DEFAULT NULL,
  `card_number` text DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `brand` varchar(50) DEFAULT NULL,
  `name_on_card` varchar(50) DEFAULT NULL,
  `card_Id` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_error` text DEFAULT NULL COMMENT 'api given last error',
  `test` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `virtual_card_transactions`
--

CREATE TABLE `virtual_card_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `card_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `card_id` varchar(50) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `currency_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Percent of charge',
  `charge_percentage` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'After adding percent of charge',
  `charge_fixed` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `transfer_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount deduct from sender',
  `received_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount add to receiver',
  `charge_from` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Sender, 1 = Receiver',
  `note` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Pending, 1=generate, 2 = payment done, 5 = cancel',
  `utr` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `is_active` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  `is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = default, 0 = not default',
  `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 `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `currency_id`, `balance`, `is_active`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 5000.00000000, 1, 0, '2023-05-03 17:14:04', '2023-05-03 17:15:04'),
(2, 2, 1, 0.00000000, 1, 0, '2023-05-03 17:18:09', '2023-05-03 17:18:09'),
(3, 3, 1, 0.00000000, 1, 0, '2024-04-01 10:08:35', '2024-04-01 10:08:35');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`),
  ADD UNIQUE KEY `admins_username_unique` (`username`);

--
-- Indexes for table `admin_profiles`
--
ALTER TABLE `admin_profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_profiles_admin_id_foreign` (`admin_id`);

--
-- Indexes for table `api_orders`
--
ALTER TABLE `api_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `api_orders_user_id_index` (`user_id`),
  ADD KEY `api_orders_currency_id_index` (`currency_id`),
  ADD KEY `api_orders_gateway_id_index` (`gateway_id`);

--
-- Indexes for table `api_order_tests`
--
ALTER TABLE `api_order_tests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `api_order_tests_user_id_index` (`user_id`),
  ADD KEY `api_order_tests_currency_id_index` (`currency_id`),
  ADD KEY `api_order_tests_gateway_id_index` (`gateway_id`);

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

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

--
-- Indexes for table `bill_pays`
--
ALTER TABLE `bill_pays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bill_pays_method_id_index` (`method_id`),
  ADD KEY `bill_pays_user_id_index` (`user_id`),
  ADD KEY `bill_pays_service_id_index` (`service_id`);

--
-- Indexes for table `bill_services`
--
ALTER TABLE `bill_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bill_services_bill_method_id_index` (`bill_method_id`);

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

--
-- Indexes for table `commission_entries`
--
ALTER TABLE `commission_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commission_entries_to_user_foreign` (`to_user`),
  ADD KEY `commission_entries_from_user_foreign` (`from_user`);

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

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

--
-- Indexes for table `content_details`
--
ALTER TABLE `content_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_details_content_id_foreign` (`content_id`),
  ADD KEY `content_details_language_id_foreign` (`language_id`);

--
-- Indexes for table `content_media`
--
ALTER TABLE `content_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_media_content_id_foreign` (`content_id`);

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

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deposits_user_id_foreign` (`user_id`),
  ADD KEY `deposits_currency_id_foreign` (`currency_id`),
  ADD KEY `deposits_charges_limit_id_foreign` (`charges_limit_id`),
  ADD KEY `deposits_payment_method_id_foreign` (`payment_method_id`);

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

--
-- Indexes for table `dispute_details`
--
ALTER TABLE `dispute_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dispute_details_dispute_id_foreign` (`dispute_id`),
  ADD KEY `dispute_details_user_id_foreign` (`user_id`),
  ADD KEY `dispute_details_admin_id_foreign` (`admin_id`);

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

--
-- Indexes for table `escrows`
--
ALTER TABLE `escrows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `escrows_sender_id_foreign` (`sender_id`),
  ADD KEY `escrows_receiver_id_foreign` (`receiver_id`),
  ADD KEY `escrows_currency_id_foreign` (`currency_id`);

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

--
-- Indexes for table `funds`
--
ALTER TABLE `funds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `funds_user_id_foreign` (`user_id`),
  ADD KEY `funds_admin_id_foreign` (`admin_id`),
  ADD KEY `funds_currency_id_foreign` (`currency_id`);

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

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoices_sender_id_index` (`sender_id`),
  ADD KEY `invoices_recuring_invoice_id_index` (`recuring_invoice_id`);

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

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

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

--
-- Indexes for table `line_items`
--
ALTER TABLE `line_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `line_items_line_item_type_line_item_id_index` (`line_item_type`,`line_item_id`);

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

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

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

--
-- Indexes for table `payouts`
--
ALTER TABLE `payouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payouts_admin_id_foreign` (`admin_id`),
  ADD KEY `payouts_user_id_foreign` (`user_id`),
  ADD KEY `payouts_currency_id_foreign` (`currency_id`),
  ADD KEY `payouts_payout_method_id_foreign` (`payout_method_id`);

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

--
-- Indexes for table `product_attr_lists`
--
ALTER TABLE `product_attr_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_attr_lists_store_product_attrs_id_index` (`store_product_attrs_id`);

--
-- Indexes for table `product_attr_maps`
--
ALTER TABLE `product_attr_maps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_attr_maps_product_id_index` (`product_id`),
  ADD KEY `product_attr_maps_attributes_id_index` (`attributes_id`);

--
-- Indexes for table `product_orders`
--
ALTER TABLE `product_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_orders_gateway_id_index` (`gateway_id`),
  ADD KEY `product_orders_shipping_id_index` (`shipping_id`),
  ADD KEY `store_id` (`store_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `currency_id` (`currency_id`);

--
-- Indexes for table `product_order_details`
--
ALTER TABLE `product_order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_order_details_order_id_index` (`order_id`),
  ADD KEY `product_order_details_product_id_index` (`product_id`);

--
-- Indexes for table `product_store_maps`
--
ALTER TABLE `product_store_maps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_store_maps_product_id_index` (`product_id`),
  ADD KEY `product_store_maps_store_id_index` (`store_id`);

--
-- Indexes for table `q_r_codes`
--
ALTER TABLE `q_r_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `q_r_codes_gateway_id_index` (`gateway_id`),
  ADD KEY `q_r_codes_currency_id_index` (`currency_id`),
  ADD KEY `user_id` (`user_id`);

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

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

--
-- Indexes for table `redeem_codes`
--
ALTER TABLE `redeem_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `redeem_codes_sender_id_foreign` (`sender_id`),
  ADD KEY `redeem_codes_receiver_id_foreign` (`receiver_id`),
  ADD KEY `redeem_codes_currency_id_foreign` (`currency_id`);

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

--
-- Indexes for table `request_money`
--
ALTER TABLE `request_money`
  ADD PRIMARY KEY (`id`),
  ADD KEY `request_money_sender_id_foreign` (`sender_id`),
  ADD KEY `request_money_receiver_id_foreign` (`receiver_id`),
  ADD KEY `request_money_currency_id_foreign` (`currency_id`);

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

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

--
-- Indexes for table `seller_contacts`
--
ALTER TABLE `seller_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_contacts_store_id_index` (`store_id`),
  ADD KEY `seller_contacts_user_id_index` (`user_id`);

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

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

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

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

--
-- Indexes for table `store_products`
--
ALTER TABLE `store_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_products_category_id_index` (`category_id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `store_product_images`
--
ALTER TABLE `store_product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_product_images_product_id_index` (`product_id`);

--
-- Indexes for table `store_product_stocks`
--
ALTER TABLE `store_product_stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_product_stocks_user_id_index` (`user_id`),
  ADD KEY `store_product_stocks_product_id_index` (`product_id`);

--
-- Indexes for table `store_shippings`
--
ALTER TABLE `store_shippings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `store_shippings_user_id_index` (`user_id`),
  ADD KEY `store_id` (`store_id`);

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

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

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

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

--
-- Indexes for table `ticket_attachments`
--
ALTER TABLE `ticket_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_attachments_ticket_message_id_foreign` (`ticket_message_id`);

--
-- Indexes for table `ticket_messages`
--
ALTER TABLE `ticket_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_messages_ticket_id_foreign` (`ticket_id`),
  ADD KEY `ticket_messages_admin_id_foreign` (`admin_id`);

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

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

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

--
-- Indexes for table `virtual_card_orders`
--
ALTER TABLE `virtual_card_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `virtual_card_orders_virtual_card_method_id_index` (`virtual_card_method_id`),
  ADD KEY `virtual_card_orders_user_id_index` (`user_id`);

--
-- Indexes for table `virtual_card_transactions`
--
ALTER TABLE `virtual_card_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `virtual_card_transactions_user_id_index` (`user_id`),
  ADD KEY `virtual_card_transactions_card_order_id_index` (`card_order_id`);

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vouchers_sender_id_foreign` (`sender_id`),
  ADD KEY `vouchers_receiver_id_foreign` (`receiver_id`),
  ADD KEY `vouchers_currency_id_foreign` (`currency_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `commission_entries`
--
ALTER TABLE `commission_entries`
  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 `contents`
--
ALTER TABLE `contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `dispute_details`
--
ALTER TABLE `dispute_details`
  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=68;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `line_items`
--
ALTER TABLE `line_items`
  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=122;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `request_money`
--
ALTER TABLE `request_money`
  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=5;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_profiles`
--
ALTER TABLE `admin_profiles`
  ADD CONSTRAINT `admin_profiles_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`);

--
-- Constraints for table `commission_entries`
--
ALTER TABLE `commission_entries`
  ADD CONSTRAINT `commission_entries_from_user_foreign` FOREIGN KEY (`from_user`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `commission_entries_to_user_foreign` FOREIGN KEY (`to_user`) REFERENCES `users` (`id`);

--
-- Constraints for table `content_details`
--
ALTER TABLE `content_details`
  ADD CONSTRAINT `content_details_content_id_foreign` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`),
  ADD CONSTRAINT `content_details_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`);

--
-- Constraints for table `content_media`
--
ALTER TABLE `content_media`
  ADD CONSTRAINT `content_media_content_id_foreign` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`);

--
-- Constraints for table `deposits`
--
ALTER TABLE `deposits`
  ADD CONSTRAINT `deposits_charges_limit_id_foreign` FOREIGN KEY (`charges_limit_id`) REFERENCES `charges_limits` (`id`),
  ADD CONSTRAINT `deposits_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `deposits_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `gateways` (`id`),
  ADD CONSTRAINT `deposits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `dispute_details`
--
ALTER TABLE `dispute_details`
  ADD CONSTRAINT `dispute_details_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `dispute_details_dispute_id_foreign` FOREIGN KEY (`dispute_id`) REFERENCES `disputes` (`id`),
  ADD CONSTRAINT `dispute_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD CONSTRAINT `email_templates_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`);

--
-- Constraints for table `escrows`
--
ALTER TABLE `escrows`
  ADD CONSTRAINT `escrows_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `escrows_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `escrows_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `funds`
--
ALTER TABLE `funds`
  ADD CONSTRAINT `funds_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `funds_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `funds_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `notify_templates`
--
ALTER TABLE `notify_templates`
  ADD CONSTRAINT `notify_templates_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`);

--
-- Constraints for table `payouts`
--
ALTER TABLE `payouts`
  ADD CONSTRAINT `payouts_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `payouts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `payouts_payout_method_id_foreign` FOREIGN KEY (`payout_method_id`) REFERENCES `payout_methods` (`id`),
  ADD CONSTRAINT `payouts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `redeem_codes`
--
ALTER TABLE `redeem_codes`
  ADD CONSTRAINT `redeem_codes_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `redeem_codes_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `redeem_codes_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `request_money`
--
ALTER TABLE `request_money`
  ADD CONSTRAINT `request_money_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `request_money_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `request_money_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `templates`
--
ALTER TABLE `templates`
  ADD CONSTRAINT `templates_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`);

--
-- Constraints for table `tickets`
--
ALTER TABLE `tickets`
  ADD CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `ticket_attachments`
--
ALTER TABLE `ticket_attachments`
  ADD CONSTRAINT `ticket_attachments_ticket_message_id_foreign` FOREIGN KEY (`ticket_message_id`) REFERENCES `ticket_messages` (`id`);

--
-- Constraints for table `ticket_messages`
--
ALTER TABLE `ticket_messages`
  ADD CONSTRAINT `ticket_messages_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `ticket_messages_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`);

--
-- Constraints for table `user_profiles`
--
ALTER TABLE `user_profiles`
  ADD CONSTRAINT `user_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD CONSTRAINT `vouchers_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  ADD CONSTRAINT `vouchers_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `vouchers_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`);
COMMIT;

