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

START TRANSACTION;



--
-- Database: `exchangebuz`
--

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

--
-- Table structure for table `add_crypto`
--

CREATE TABLE `add_crypto` (
  `id` int(10) NOT NULL,
  `uid` varchar(120) NOT NULL,
  `merchant_source` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `add_manual_payment`
--

CREATE TABLE `add_manual_payment` (
  `id` int(10) NOT NULL,
  `uid` varchar(120) NOT NULL,
  `gateway` varchar(120) NOT NULL,
  `currency` varchar(120) NOT NULL,
  `currency_code` varchar(120) DEFAULT NULL,
  `minimum_amount` decimal(10,2) NOT NULL,
  `maximum_amount` decimal(10,2) NOT NULL,
  `reserve` decimal(10,2) NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `field_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`field_name`)),
  `field_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`field_value`)),
  `include_extra_fee` enum('true','false') DEFAULT 'false',
  `extra_fee` decimal(10,2) NOT NULL,
  `allow_customers_to_send_money` enum('true','false') DEFAULT 'false',
  `is_crypto_currency` enum('true','false') DEFAULT 'false',
  `require_user_to_login` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_email` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_personal_documents` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_mobile_number` enum('true','false') DEFAULT 'false',
  `icon` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `add_manual_payment`
--

INSERT INTO `add_manual_payment` (`id`, `uid`, `gateway`, `currency`, `currency_code`, `minimum_amount`, `maximum_amount`, `reserve`, `fee`, `field_name`, `field_value`, `include_extra_fee`, `extra_fee`, `allow_customers_to_send_money`, `is_crypto_currency`, `require_user_to_login`, `require_user_to_verify_email`, `require_user_to_verify_personal_documents`, `require_user_to_verify_mobile_number`, `icon`, `created_at`, `updated_at`) VALUES
(1, '855e48ae-8086-4a7a-906b-12bac9d13035', 'Payeer', 'BDT', NULL, 234.00, 1000.00, 10000.00, 80.00, '[{\"id\":529,\"field_name\":\"sadf\"},{\"id\":411,\"field_name\":\"sadf\"},{\"id\":255,\"field_name\":\"sadf\"},{\"id\":600,\"field_name\":\"sadf\"},{\"id\":484,\"field_name\":\"sadf\"},{\"id\":764,\"field_name\":\"sadf\"},{\"id\":640,\"field_name\":\"sadf\"},{\"id\":94,\"field_name\":\"sdf\"},{\"id\":489,\"field_name\":\"sadf\"},{\"id\":85,\"field_name\":\"sadf\"}]', '[{\"id\":525,\"field_value\":\"sadf\"},{\"id\":106,\"field_value\":\"sadf\"},{\"id\":402,\"field_value\":\"asdf\"},{\"id\":187,\"field_value\":\"sadf\"},{\"id\":958,\"field_value\":\"sadf\"},{\"id\":685,\"field_value\":\"sadf\"},{\"id\":771,\"field_value\":\"sadf\"},{\"id\":765,\"field_value\":\"sadf\"},{\"id\":137,\"field_value\":\"sadf\"},{\"id\":548,\"field_value\":\"sadf\"}]', 'true', 23.00, NULL, 'true', 'true', 'false', 'false', 'false', NULL, '2025-01-09 02:27:28', '2025-01-09 02:27:28'),
(2, 'd491be89-44f1-4771-b260-fd169b015de0', 'UPI', 'INR', NULL, 234.00, 10000.00, 100003.00, 900.00, '[{\"id\":370,\"field_name\":\"sadfsdaf\"},{\"id\":946,\"field_name\":\"sadf\"},{\"id\":664,\"field_name\":\"sadf\"},{\"id\":385,\"field_name\":\"sadf\"},{\"id\":736,\"field_name\":\"sdf\"},{\"id\":12,\"field_name\":\"sadf\"},{\"id\":396,\"field_name\":\"sadf\"},{\"id\":422,\"field_name\":\"sadf\"},{\"id\":26,\"field_name\":\"sadf\"},{\"id\":952,\"field_name\":\"sadf\"}]', '[{\"id\":120,\"field_value\":\"sadf\"},{\"id\":369,\"field_value\":\"sadf\"},{\"id\":843,\"field_value\":\"sadf\"},{\"id\":245,\"field_value\":\"sadf\"},{\"id\":920,\"field_value\":\"sadf\"},{\"id\":91,\"field_value\":\"sadf\"},{\"id\":698,\"field_value\":\"sadf\"},{\"id\":929,\"field_value\":\"sadf\"},{\"id\":396,\"field_value\":\"sadf\"},{\"id\":104,\"field_value\":\"sadf\"}]', 'true', 324.00, NULL, 'true', 'true', 'false', 'false', 'false', NULL, '2025-01-09 02:32:39', '2025-01-09 02:32:39'),
(3, '20beed65-a00e-4b2b-a655-e5e2f6459b20', 'Razorpay', 'JOD', NULL, 80.00, 10000.00, 3500000.00, 65.00, '[{\"id\":370,\"field_name\":\"sadfsdaf\"},{\"id\":946,\"field_name\":\"sadf\"},{\"id\":664,\"field_name\":\"sadf\"},{\"id\":385,\"field_name\":\"sadf\"},{\"id\":736,\"field_name\":\"sdf\"},{\"id\":12,\"field_name\":\"sadf\"},{\"id\":396,\"field_name\":\"sadf\"},{\"id\":422,\"field_name\":\"sadf\"},{\"id\":26,\"field_name\":\"sadf\"},{\"id\":952,\"field_name\":\"sadf\"},{\"id\":698,\"field_name\":\"sadf\"},{\"id\":219,\"field_name\":\"sadf\"},{\"id\":209,\"field_name\":\"sadf\"},{\"id\":786,\"field_name\":\"sadf\"},{\"id\":512,\"field_name\":\"sadf\"},{\"id\":294,\"field_name\":\"asdf\"},{\"id\":106,\"field_name\":\"sadf\"},{\"id\":322,\"field_name\":\"sadf\"},{\"id\":557,\"field_name\":\"asdf\"},{\"id\":561,\"field_name\":\"asdf\"}]', '[{\"id\":120,\"field_value\":\"sadf\"},{\"id\":369,\"field_value\":\"sadf\"},{\"id\":843,\"field_value\":\"sadf\"},{\"id\":245,\"field_value\":\"sadf\"},{\"id\":920,\"field_value\":\"sadf\"},{\"id\":91,\"field_value\":\"sadf\"},{\"id\":698,\"field_value\":\"sadf\"},{\"id\":929,\"field_value\":\"sadf\"},{\"id\":396,\"field_value\":\"sadf\"},{\"id\":104,\"field_value\":\"sadf\"},{\"id\":957,\"field_value\":\"sadf\"},{\"id\":681,\"field_value\":\"sadf\"},{\"id\":27,\"field_value\":\"sadf\"},{\"id\":951,\"field_value\":\"sadf\"},{\"id\":937,\"field_value\":\"sadf\"},{\"id\":8,\"field_value\":\"sadf\"},{\"id\":140,\"field_value\":\"sadf\"},{\"id\":23,\"field_value\":\"sadf\"},{\"id\":808,\"field_value\":\"asdf\"},{\"id\":436,\"field_value\":\"sadf\"}]', 'true', 23.00, NULL, 'true', 'false', 'false', 'false', 'false', NULL, '2025-01-09 02:33:47', '2025-01-09 02:33:47');

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

--
-- Table structure for table `add_merchant`
--

CREATE TABLE `add_merchant` (
  `id` int(10) NOT NULL,
  `uid` varchar(120) NOT NULL,
  `select_merchant` varchar(120) NOT NULL,
  `currency` varchar(120) NOT NULL,
  `minimum_amount` decimal(10,2) NOT NULL,
  `maximum_amount` decimal(10,2) NOT NULL,
  `reserve` decimal(10,2) NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `include_extra_fee` enum('true','false') DEFAULT 'false',
  `extra_fee` decimal(10,2) NOT NULL,
  `allow_customers_to_send_money` enum('true','false') DEFAULT 'false',
  `require_user_to_login` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_email` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_documents` enum('true','false') DEFAULT 'false',
  `require_user_to_verify_mobile_number` enum('true','false') DEFAULT 'false',
  `status` enum('Active','Not Active') DEFAULT 'Not Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `add_merchant`
--

INSERT INTO `add_merchant` (`id`, `uid`, `select_merchant`, `currency`, `minimum_amount`, `maximum_amount`, `reserve`, `fee`, `include_extra_fee`, `extra_fee`, `allow_customers_to_send_money`, `require_user_to_login`, `require_user_to_verify_email`, `require_user_to_verify_documents`, `require_user_to_verify_mobile_number`, `status`, `created_at`, `updated_at`) VALUES
(1, '93e1c2e1-fa87-46ac-999b-ca7fab406831', 'AdvCash', 'BGN', 10.00, 1000.00, 10000.00, 900.00, 'true', 3242.00, 'true', 'false', 'false', 'false', 'true', 'Active', '2025-01-07 00:12:02', '2025-01-07 00:12:26'),
(2, '1df546c0-91d7-44c6-b25d-b98b9aecfdf7', 'Payza', 'BHD', 234.00, 1000.00, 10000.00, 80.00, 'true', 56.00, 'true', 'true', 'true', 'true', 'true', 'Not Active', '2025-01-07 00:12:58', '2025-01-07 00:12:58'),
(3, 'beb39d8e-a8bc-4177-8707-e58547a117fb', 'SolidTrust Pay', 'SLL', 10.00, 23434.00, 1000034.00, 5420.00, 'true', 800.00, 'false', 'false', 'false', 'false', 'true', 'Not Active', '2025-01-07 00:13:40', '2025-01-07 00:13:40'),
(4, 'f7938091-799e-4d1c-9a50-84b43e144c8e', 'Entromoney', 'BGN', 234.00, 234234.00, 100003.00, 80.00, 'true', 234.00, 'false', 'true', 'true', 'true', 'true', 'Not Active', '2025-01-07 00:34:39', '2025-01-07 00:34:39'),
(5, '5f6403e8-dd3e-4308-af79-030cbe1d84ca', 'Perfect Money', 'BAM', 234.00, 234234.00, 10000343.00, 80.00, 'true', 345.00, 'true', 'true', 'true', 'true', 'true', 'Not Active', '2025-01-07 00:37:59', '2025-01-07 00:37:59'),
(6, '3672615f-114f-4482-ba8d-b1757c4d1116', 'WebMoney', 'NPR', 234.00, 1000.00, 10000.00, 45.00, 'true', 23.00, 'false', 'true', 'false', 'true', 'false', 'Not Active', '2025-01-07 00:39:43', '2025-01-07 00:39:43'),
(7, '1f9df224-0b2c-42e7-ad7f-416fa3a30dbd', 'Payeer', 'AOA', 234.00, 520000.00, 1000034.00, 900.00, 'true', 4234.00, 'true', 'true', 'false', 'false', 'false', 'Active', '2025-01-07 00:40:13', '2025-01-07 00:41:34');

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

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

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

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

--
-- Table structure for table `support`
--

CREATE TABLE `support` (
  `id` int(10) NOT NULL,
  `uid` varchar(120) NOT NULL,
  `fullname` varchar(120) NOT NULL,
  `email` varchar(120) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support`
--

INSERT INTO `support` (`id`, `uid`, `fullname`, `email`, `subject`, `phone`, `message`, `created_at`, `updated_at`) VALUES
(1, '32aa57a7-d93b-48dc-aa64-363816094dd6', 'Vikas Rathore', 'vikasrathore95160@gmail.com', 'sadfsdf', '09516044664', 'sadfsdf', '2025-01-03 06:46:47', '2025-01-03 06:46:47'),
(2, '590fc4aa-503d-4471-bc39-6a9ceb96c33e', 'Vikas Rathore', 'vikasrathore95160@gmail.com', 'sdfgdsfg', '09516044664', 'sdfgsdfsdaf', '2025-01-03 06:54:17', '2025-01-03 06:54:17'),
(3, '12e0eed0-d829-41c6-83cd-281f6321082e', 'Vikas Rathore', 'vikasrathore95160@gmail.com', 'asdf', '09516044664', 'asdfsdf', '2025-01-03 06:58:22', '2025-01-03 06:58:22'),
(4, '1c02dbe4-6389-437e-a80c-98e77b0e9394', 'Vikas Rathore', 'vikasrathore95160@gmail.com', 'sdfsad', '09516044664', 'sadfsdf', '2025-01-03 07:02:05', '2025-01-03 07:02:05'),
(5, '69fea3ff-6d6d-4026-a9a4-429cd4d0bf23', 'dfgdfdf', 'dfgdfg@gmail.vom', 'dfgdfg', '2435235235', 'dfdfgdfsgfg', '2025-01-03 07:05:45', '2025-01-03 07:05:45'),
(6, '4c018f2f-be15-45dc-88fd-fa809aab4622', 'hello', 'hello@example.com', 'aslkdjfl', '6442441', 'askjdhfkhasdkjfhsadv', '2025-01-03 07:15:01', '2025-01-03 07:15:01');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `add_crypto`
--
ALTER TABLE `add_crypto`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `add_manual_payment`
--
ALTER TABLE `add_manual_payment`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `add_merchant`
--
ALTER TABLE `add_merchant`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `support`
--
ALTER TABLE `support`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

