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

START TRANSACTION;



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

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_status` tinyint(1) NOT NULL DEFAULT '0',
  `click_url` text COLLATE utf8mb4_unicode_ci,
  `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 `admin_notifications`
--

INSERT INTO `admin_notifications` (`id`, `user_id`, `title`, `read_status`, `click_url`, `created_at`, `updated_at`) VALUES
(1, 1, 'New member registered', 0, '/red/user/detail/1', '2025-03-21 18:11:34', '2025-03-21 18:11:34'),
(2, 1, 'New Investment In VIP-1 from 8168271947', 0, '/red/users/investment/1', '2025-03-22 02:03:44', '2025-03-22 02:03:44'),
(3, 1, 'Deposit request from 8168271947', 0, '/red/deposit/details/1', '2025-03-22 12:29:47', '2025-03-22 12:29:47'),
(4, 1, 'New Investment In NIKON-1 from 8168271947', 0, '/code/users/investment/1', '2025-04-16 08:05:47', '2025-04-16 08:05:47'),
(5, 1, 'New Investment In NIKON-2 from 8168271947', 0, '/code/users/investment/1', '2025-04-16 08:05:56', '2025-04-16 08:05:56'),
(6, 2, 'New member registered', 0, '/code/user/detail/2', '2025-04-16 15:42:35', '2025-04-16 15:42:35'),
(7, 2, 'New Investment In NIKON-3 from 8168271948', 0, '/code/users/investment/2', '2025-04-16 15:43:39', '2025-04-16 15:43:39'),
(8, 3, 'New member registered', 0, '/code/user/detail/3', '2025-04-16 15:48:53', '2025-04-16 15:48:53'),
(9, 3, 'New Investment In NIKON-3 from 8168271948', 0, '/code/users/investment/3', '2025-04-16 15:50:47', '2025-04-16 15:50:47'),
(10, 4, 'New member registered', 0, '/code/user/detail/4', '2025-04-16 18:26:04', '2025-04-16 18:26:04'),
(11, 4, 'New Investment In NIKON-5 from 8168271949', 0, '/code/users/investment/4', '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(12, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/code/withdraw/details/1', '2025-04-16 19:30:25', '2025-04-16 19:30:25'),
(13, 1, 'New Investment In NIKON-3 from 8168271947', 0, '/code/users/investment/1', '2025-04-21 01:07:10', '2025-04-21 01:07:10'),
(14, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/code/withdraw/details/2', '2025-04-21 03:51:35', '2025-04-21 03:51:35'),
(15, 1, 'New Investment In NIKON-1 from 8168271947', 0, '/control/users/investment/1', '2025-05-09 15:09:26', '2025-05-09 15:09:26'),
(16, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/3', '2025-05-09 15:41:48', '2025-05-09 15:41:48'),
(17, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/4', '2025-05-09 16:07:19', '2025-05-09 16:07:19'),
(18, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/5', '2025-05-09 16:10:19', '2025-05-09 16:10:19'),
(19, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/6', '2025-05-09 16:10:46', '2025-05-09 16:10:46'),
(20, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/7', '2025-05-09 16:14:49', '2025-05-09 16:14:49'),
(21, 1, 'New  Bonus  withdraw request from 8168271947', 0, '/control/withdraw/details/8', '2025-05-09 16:16:30', '2025-05-09 16:16:30');

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

--
-- Table structure for table `admin_password_resets`
--

CREATE TABLE `admin_password_resets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(40) COLLATE utf8mb4_unicode_ci NOT 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 `banks`
--

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

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`id`, `bank_code`, `name`, `created_at`, `updated_at`) VALUES
(1, '044', 'Access Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(2, '023', 'Citi Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(3, '050', 'EcoBank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(4, '011', 'First Bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(5, '214', 'First City Monument Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(6, '070', 'Fidelity Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(7, '058', 'Guaranty Trust Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(8, '076', 'Polaris bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(9, '221', 'Stanbic IBTC Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(10, '068', 'Standard Chaterted bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(11, '232', 'Sterling Bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(12, '033', 'United Bank for Africa', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(13, '032', 'Union Bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(14, '035', 'Wema Bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(15, '057', 'Zenith bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(16, '215', 'Unity Bank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(17, '101', 'ProvidusBank PLC', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(18, '082', 'Keystone Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(19, '301', 'Jaiz Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(20, '030', 'Heritage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(21, '100', 'Suntrust Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(22, '608', 'FINATRUST MICROFINANCE BANK', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(23, '090175', 'Rubies Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(24, '090267', 'Kuda', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(25, '090115', 'TCF MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(26, '400001', 'FSDH Merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(27, '502', 'Rand merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(28, '103', 'Globus Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(29, '327', 'Paga', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(30, '000026', 'Taj Bank Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(31, '100022', 'GoMoney', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(32, '090180', 'AMJU Unique Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(33, '090393', 'BRIDGEWAY MICROFINANCE BANK', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(34, '090328', 'Eyowo MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(35, '090281', 'Mint-Finex MICROFINANCE BANK', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(36, '070006', 'Covenant Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(37, '090110', 'VFD Micro Finance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(38, '090317', 'PatrickGold Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(39, '090325', 'Sparkle', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(40, '305', 'Paycom', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(41, '070001', 'NPF MicroFinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(42, '110001', 'PayAttitude Online', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(43, '100027', 'Intellifin', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(44, '100032', 'Contec Global Infotech Limited (NowNow)', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(45, '100031', 'FCMB Easy Account', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(46, '100030', 'EcoMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(47, '100029', 'Innovectives Kesh', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(48, '100026', 'One Finance', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(49, '100025', 'Zinternet Nigera Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(50, '100023', 'TagPay', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(51, '100021', 'Eartholeum', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(52, '100020', 'MoneyBox', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(53, '100019', 'Fidelity Mobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(54, '000019', 'Enterprise Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(55, '060001', 'Coronation Merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(56, '060002', 'FBNQUEST Merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(57, '060003', 'Nova Merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(58, '070007', 'Omoluabi savings and loans', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(59, '090001', 'ASOSavings & Loans', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(60, '090005', 'Trustbond Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(61, '090006', 'SafeTrust ', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(62, '090107', 'FBN Mortgages Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(63, '100024', 'Imperial Homes Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(64, '100028', 'AG Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(65, '070009', 'Gateway Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(66, '070010', 'Abbey Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(67, '070011', 'Refuge Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(68, '070012', 'Lagos Building Investment Company', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(69, '070013', 'Platinum Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(70, '070014', 'First Generation Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(71, '070015', 'Brent Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(72, '070016', 'Infinity Trust Mortgage Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(73, '090003', 'Jubilee-Life Mortgage  Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(74, '070017', 'Haggai Mortgage Bank Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(75, '090108', 'New Prudential Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(76, '070002', 'Fortis Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(77, '070008', 'Page Financials', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(78, '090004', 'Parralex Microfinance bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(79, '090097', 'Ekondo MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(80, '090112', 'Seed Capital Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(81, '090114', 'Empire trust MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(82, '090116', 'AMML MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(83, '090117', 'Boctrust Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(84, '090118', 'IBILE Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(85, '090119', 'Ohafia Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(86, '090120', 'Wetland Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(87, '090121', 'Hasal Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(88, '090122', 'Gowans Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(89, '090123', 'Verite Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(90, '090124', 'Xslnce Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(91, '090125', 'Regent Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(92, '090126', 'Fidfund Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(93, '090127', 'BC Kash Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(94, '090128', 'Ndiorah Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(95, '090129', 'Money Trust Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(96, '090130', 'Consumer Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(97, '090131', 'Allworkers Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(98, '090132', 'Richway Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(99, '090133', ' AL-Barakah Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(100, '090134', 'Accion Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(101, '090135', 'Personal Trust Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(102, '090136', 'Baobab Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(103, '090137', 'PecanTrust Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(104, '090138', 'Royal Exchange Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(105, '090139', 'Visa Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(106, '090140', 'Sagamu Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(107, '090141', 'Chikum Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(108, '090142', 'Yes Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(109, '090143', 'Apeks Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(110, '090144', 'CIT Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(111, '090145', 'Fullrange Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(112, '090146', 'Trident Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(113, '090147', 'Hackman Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(114, '090148', 'Bowen Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(115, '090149', 'IRL Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(116, '090150', 'Virtue Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(117, '090151', 'Mutual Trust Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(118, '090152', 'Nagarta Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(119, '090153', 'FFS Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(120, '090154', 'CEMCS Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(121, '090155', 'La  Fayette Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(122, '090156', 'e-Barcs Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(123, '090157', 'Infinity Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(124, '090158', 'Futo Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(125, '090159', 'Credit Afrique Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(126, '090160', 'Addosser Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(127, '090161', 'Okpoga Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(128, '090162', 'Stanford Microfinance Bak', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(129, '090164', 'First Royal Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(130, '090165', 'Petra Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(131, '090166', 'Eso-E Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(132, '090167', 'Daylight Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(133, '090168', 'Gashua Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(134, '090169', 'Alpha Kapital Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(135, '090171', 'Mainstreet Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(136, '090172', 'Astrapolaris Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(137, '090173', 'Reliance Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(138, '090174', 'Malachy Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(139, '090175', 'HighStreet Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(140, '090176', 'Bosak Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(141, '090177', 'Lapo Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(142, '090178', 'GreenBank Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(143, '090179', 'FAST Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(144, '090188', 'Baines Credit Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(145, '090189', 'Esan Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(146, '090190', 'Mutual Benefits Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(147, '090191', 'KCMB Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(148, '090192', 'Midland Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(149, '090193', 'Unical Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(150, '090194', 'NIRSAL Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(151, '090195', 'Grooming Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(152, '090196', 'Pennywise Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(153, '090197', 'ABU Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(154, '090198', 'RenMoney Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(155, '090205', 'New Dawn Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(156, '090251', 'UNN MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(157, '090258', 'Imo State Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(158, '090259', 'Alekun Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(159, '090260', 'Above Only Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(160, '090261', 'Quickfund Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(161, '090262', 'Stellas Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(162, '090263', 'Navy Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(163, '090264', 'Auchi Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(164, '090265', 'Lovonus Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(165, '090266', 'Uniben Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(166, '090268', 'Adeyemi College Staff Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(167, '090269', 'Greenville Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(168, '090270', 'AB Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(169, '090271', 'Lavender Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(170, '090272', 'Olabisi Onabanjo University Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(171, '090273', 'Emeralds Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(172, '090276', 'Trustfund Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(173, '090277', 'Al-Hayat Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(174, '100001', 'FET', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(175, '100003', 'Parkway-ReadyCash', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(176, '100005', 'Cellulant', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(177, '100006', 'eTranzact', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(178, '100007', 'Stanbic IBTC @ease wallet', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(179, '100008', 'Ecobank Xpress Account', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(180, '100009', 'GTMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(181, '100010', 'TeasyMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(182, '100011', 'Mkudi', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(183, '100012', 'VTNetworks', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(184, '100013', 'AccessMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(185, '100014', 'FBNMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(186, '100015', 'Kegow', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(187, '100016', 'FortisMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(188, '100017', 'Hedonmark', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(189, '100018', 'ZenithMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(190, '110002', 'Flutterwave Technology Solutions Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(191, '999999', 'NIP Virtual Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(192, '000025', 'Titan Trust Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(193, '303', 'ChamsMobile', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(194, '090423', 'MAUTECH Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(195, '060004', 'Greenwich Merchant Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(196, '000030', 'Parallex Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(197, '090366', 'Firmus MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(198, '100033', 'PALMPAY', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(199, '090383', 'Manny Microfinance bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(200, '090420', 'Letshego MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(201, '100035', 'M36', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(202, '090286', 'Safe Haven MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(203, '120001', '9 Payment Service Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(204, '090426', 'Tangerine Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(205, '090482', 'FEDETH MICROFINANCE BANK', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(206, '100026', 'Carbon', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(207, '090470', 'DOT MICROFINANCE BANK', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(208, '000031', 'PremiumTrust Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(209, '090435', 'Links Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(210, '110007', 'TeamApt', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(211, '000033', 'ENaira', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(212, '090560', 'TANADI MFB (CRUST)', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(213, '090495', 'GOODNEWS MFB', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(214, '120005', 'Money Master Psb', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(215, '120004', 'Smartcash Payment Service Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(216, '120003', 'Momo Psb', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(217, '120002', 'Hopepsb', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(218, '110029', 'Woven Finance', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(219, '110028', 'Nomba Financial Services Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(220, '110027', 'Yello Digital Financial Services', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(221, '110026', 'Spay Business', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(222, '110025', 'Netapps Technology Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(223, '110024', 'Resident Fintech Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(224, '110023', 'Capricorn Digital', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(225, '110022', 'Koraypay', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(226, '110021', 'Bud Infrastructure Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(227, '110019', 'Nibssussd Payments', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(228, '110018', 'Microsystems Investment And Development Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(229, '110017', 'Crowdforce', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(230, '110015', 'Vas2Nets Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(231, '110013', 'Qr Payments', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(232, '110012', 'Cellulant Pssp', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(233, '110011', 'Arca Payments', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(234, '110010', 'Interswitch Financial Inclusion Services (Ifis)', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(235, '110008', 'Kadick Integration Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(236, '110006', 'Paystack Payments Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(237, '110005', '3Line Card Management Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(238, '110003', 'Interswitch Limited', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(239, '100052', 'Beta-Access Yello', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(240, '100039', 'Titan-Paystack', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(241, '100036', 'Kegow(Chamsmobile)', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(242, '100034', 'Zwallet', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(243, '100004', 'Opay', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(244, '090580', 'Otech Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(245, '090579', 'Gbede Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(246, '090578', 'Iwade Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(247, '090576', 'Octopus Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(248, '090575', 'Firstmidas Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(249, '090573', 'Snow Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(250, '090572', 'Ewt Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(251, '090571', 'Ilaro Poly Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(252, '090570', 'Iyamoye Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(253, '090569', 'Qube Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(254, '090568', 'Broadview Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(255, '090567', 'Orokam Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(256, '090566', 'Okuku Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(257, '090565', 'Oke-Aro Oredegbe Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(258, '090564', 'Supreme Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(259, '090563', 'Balera Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(260, '090562', 'Cedar Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(261, '090561', 'Akuchukwu Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(262, '090559', 'Shield Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(263, '090558', 'Shongom Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(264, '090557', 'Lifegate Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(265, '090556', 'Egwafin Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(266, '090555', 'Bishopgate Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(267, '090554', 'Kayvee Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(268, '090553', 'Consistent Trust Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(269, '090552', 'Ekimogun Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(270, '090551', 'Fairmoney Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(271, '090550', 'Green Energy Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(272, '090549', 'Kc Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(273, '090548', 'Ally Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(274, '090547', 'Rockshield Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(275, '090546', 'Ijebu-Ife Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(276, '090545', 'Abulesoro Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(277, '090544', 'Aspire Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(278, '090543', 'Iwoama Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(279, '090542', 'Otuo Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(280, '090541', 'Excellent Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(281, '090540', 'Aztec Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(282, '090539', 'Enrich Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(283, '090538', 'Blue Investments Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(284, '090537', 'Lobrem Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(285, '090536', 'Ikoyi-Osun Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(286, '090535', 'Nkpolu-Ust Microfinance', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(287, '090534', 'Polyibadan Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(288, '090532', 'Ibolo Micorfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(289, '090531', 'Aku Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(290, '090530', 'Confidence Microfinance Bank Ltd', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(291, '090529', 'Ampersand Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(292, '090528', 'Mgbidi Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(293, '090527', 'Ojokoro Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(294, '090526', 'Crescent Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(295, '090525', 'Triple A Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(296, '090524', 'Solidrock Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(297, '090523', 'Chase Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(298, '090521', 'Foresight Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(299, '090520', 'Ic Globalmicrofinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(300, '090519', 'Ibom Fadama Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(301, '090518', 'Afemai Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(302, '090517', 'Uhuru Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(303, '090516', 'Numo Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(304, '090515', 'Rima Growth Pathway Microfinance Bank ', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(305, '090514', 'Umuchinemere Procredit Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(306, '090513', 'Seap Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(307, '090512', 'Bubayero Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(308, '090511', 'Cloverleaf  Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(309, '090510', 'Umunnachi Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(310, '090509', 'Capitalmetriq Swift Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(311, '090508', 'Borno Renaissance Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(312, '090507', 'Fims Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(313, '090506', 'Solid Allianze Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(314, '090505', 'Nigeria Prisonsmicrofinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(315, '090504', 'Zikora Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(316, '090503', 'Projects Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(317, '090502', 'Shalom Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(318, '090501', 'Boromu Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(319, '090500', 'Gwong Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(320, '090499', 'Pristine Divitis Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(321, '090498', 'Catland Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(322, '090497', 'Palmcoast Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(323, '090496', 'Radalpha Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(324, '090494', 'Boji Boji Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(325, '090493', 'Iperu Microfinance Bank', '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(326, '090492', 'Oraukwu  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(327, '090491', 'Nsuk  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(328, '090490', 'Chukwunenye  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(329, '090489', 'Alvana Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(330, '090488', 'Ibu-Aje Microfinance', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(331, '090487', 'Kingdom College  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(332, '090486', 'Fortress Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(333, '090485', 'Safegate Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(334, '090484', 'Garki Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(335, '090483', 'Ada Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(336, '090481', 'Prisco  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(337, '090480', 'Cintrust Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(338, '090479', 'First Heritage Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(339, '090478', 'Avuenegbe Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(340, '090477', 'Light Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(341, '090476', 'Anchorage Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(342, '090475', 'Giant Stride Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(343, '090474', 'Verdant Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(344, '090473', 'Assets Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(345, '090472', 'Caretaker Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(346, '090471', 'Oluchukwu Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(347, '090469', 'Aniocha Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(348, '090468', 'Olofin Owena Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(349, '090467', 'Good Neighbours Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(350, '090466', 'Yct Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(351, '090465', 'Maintrust Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(352, '090464', 'Unimaid Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(353, '090463', 'Rehoboth Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(354, '090462', 'Monarch Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(355, '090461', 'Uniibadan Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(356, '090460', 'Oluyole Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(357, '090459', 'Nice Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(358, '090456', 'Ospoly Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(359, '090454', 'Borstal Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(360, '090453', 'Uzondu Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(361, '090452', 'Unilag  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(362, '090451', 'Atbu  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(363, '090450', 'Kwasu Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(364, '090449', 'Sls  Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(365, '090448', 'Moyofade Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(366, '090446', 'Support Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(367, '090445', 'Capstone Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(368, '090444', 'Boi Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(369, '090443', 'Rima Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(370, '090441', 'Giwa Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(371, '090440', 'Cherish Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(372, '090439', 'Ibeto  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(373, '090438', 'Futminna Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(374, '090437', 'Oakland Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(375, '090436', 'Spectrum Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(376, '090434', 'Insight Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(377, '090433', 'Rigo Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(378, '090432', 'Memphis Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(379, '090431', 'Bluewhales  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(380, '090430', 'Ilora Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(381, '090429', 'Crossriver  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(382, '090428', 'Ishie  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(383, '090427', 'Ebsu Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(384, '090425', 'Banex Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(385, '090424', 'Abucoop  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(386, '090422', 'Landgold  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(387, '090421', 'Izon Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(388, '090419', 'Winview Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(389, '090418', 'Highland Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(390, '090417', 'Imowo Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(391, '090416', 'Chibueze Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(392, '090415', 'Calabar Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(393, '090414', 'Crutech  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(394, '090413', 'Benysta Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(395, '090412', 'Preeminent Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(396, '090411', 'Giginya Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(397, '090410', 'Maritime Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(398, '090409', 'Fcmb Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(399, '090408', 'Gmb Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(400, '090406', 'Business Support Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(401, '090405', 'Moniepoint Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(402, '090404', 'Olowolagba Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(403, '090403', 'Uda Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(404, '090402', 'Peace Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(405, '090401', 'Shepherd Trust Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(406, '090400', 'Finca Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(407, '090399', 'Nwannegadi Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(408, '090398', 'Federal Polytechnic Nekede Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(409, '090397', 'Chanelle Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(410, '090396', 'Oscotech Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(411, '090395', 'Borgu Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(412, '090394', 'Amac Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(413, '090392', 'Mozfin Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(414, '090391', 'Davodani  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(415, '090390', 'Parkway Mf Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(416, '090389', 'Ek-Reliable Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(417, '090386', 'Interland Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(418, '090385', 'Gti  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(419, '090380', 'Kredi Money Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(420, '090379', 'Peniel Micorfinance Bank Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(421, '090378', 'New Golden Pastures Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(422, '090377', 'Isaleoyo Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(423, '090376', 'Apple  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(424, '090374', 'Coastline Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(425, '090373', 'Tf Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(426, '090372', 'Legend Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(427, '090371', 'Agosasa Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(428, '090370', 'Ilasan Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(429, '090369', 'Seedvest Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(430, '090365', 'Corestep Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(431, '090364', 'Nuture Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(432, '090363', 'Headway Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(433, '090362', 'Molusi Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(434, '090360', 'Cashconnect   Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(435, '090353', 'Isuofia Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(436, '090352', 'Jessefield Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(437, '090350', 'Illorin Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(438, '090349', 'Nasarawa Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(439, '090345', 'Oau Microfinance Bank Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(440, '090343', 'Citizen Trust Microfinance Bank Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(441, '090341', 'Unilorin Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(442, '090340', 'Stockcorp  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(443, '090338', 'Uniuyo Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(444, '090337', 'Iyeru Okin Microfinance Bank Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(445, '090336', 'Bipc Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(446, '090333', 'Oche Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(447, '090332', 'Evergreen Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(448, '090331', 'Unaab Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(449, '090330', 'Fame Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(450, '090329', 'Neptune Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(451, '090327', 'Trust Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(452, '090326', 'Balogun Gambari Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(453, '090324', 'Ikenne Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(454, '090323', 'Mainland Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(455, '090322', 'Rephidim Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(456, '090321', 'Mayfair  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(457, '090320', 'Kadpoly Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(458, '090319', 'Bonghe Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(459, '090318', 'Federal University Dutse  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(460, '090316', 'Bayero Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(461, '090315', 'U And C Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(462, '090310', 'Edfin Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(463, '090308', 'Brightway Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(464, '090307', 'Aramoko Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(465, '090305', 'Sulsap Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(466, '090304', 'Evangel Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(467, '090303', 'Purplemoney Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(468, '090302', 'Sunbeam Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(469, '090299', 'Kontagora Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(470, '090298', 'Federalpoly Nasarawamfb', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(471, '090297', 'Alert Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(472, '090296', 'Polyuwanna Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(473, '090295', 'Omiye Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(474, '090294', 'Eagle Flight Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(475, '090293', 'Brethren Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(476, '090292', 'Afekhafe Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(477, '090291', 'Halacredit Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(478, '090290', 'Fct Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(479, '090289', 'Pillar Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(480, '090287', 'Assets Matrix Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(481, '090285', 'First Option Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(482, '090283', 'Thrive Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(483, '090282', 'Arise Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(484, '090280', 'Megapraise Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(485, '090279', 'Ikire Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(486, '090278', 'Glory Microfinance Bank ', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(487, '090275', 'Meridian Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(488, '090274', 'Prestige Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(489, '090254', 'Coalcamp Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(490, '090252', 'Yobe Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(491, '090211', 'Itex Integrated Services Limited', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(492, '090202', 'Accelerex Network', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(493, '090201', 'Xpress Payments', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(494, '090186', 'Girei Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(495, '090182', 'Standard Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(496, '090181', 'Balogun Fulani  Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(497, '090170', 'Rahama Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(498, '090163', 'First Multiple Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(499, '090113', 'Microvis Microfinance Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(500, '080002', 'Tajwallet', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(501, '070026', 'Fha Mortgage Bank Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(502, '070025', 'Akwa Savings & Loans Limited', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(503, '070024', 'Homebase Mortgage', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(504, '070023', 'Delta Trust Mortgage Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(505, '070022', 'Stb Mortgage Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(506, '070021', 'Coop Mortgage Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(507, '070019', 'Mayfresh Mortgage Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(508, '050006', 'Branch International Financial Services', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(509, '050005', 'Aaa Finance', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(510, '050004', 'Newedge Finance Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(511, '050003', 'Sagegrey Finance Limited', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(512, '050002', 'Fewchore Finance Company Limited', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(513, '050001', 'County Finance Ltd', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(514, '000029', 'Lotus Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(515, '000028', 'Central Bank Of Nigeria', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(516, '000036', 'Optimus Bank', '2023-01-25 07:35:28', '2023-01-25 07:35:28'),
(517, '090589', 'Mercury MFB', '2023-01-25 07:35:28', '2023-01-25 07:35:28');

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

--
-- Table structure for table `bank_withdrawals`
--

CREATE TABLE `bank_withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `withdrawal_id` bigint(20) UNSIGNED NOT NULL,
  `bank_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_withdrawals`
--

INSERT INTO `bank_withdrawals` (`id`, `withdrawal_id`, `bank_code`, `account_number`, `account_name`, `created_at`, `updated_at`) VALUES
(1, 1, '136', '51114710803', 'prince emmanuel', '2025-04-16 19:30:25', '2025-04-16 19:30:25'),
(2, 2, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-04-21 03:51:35', '2025-04-21 03:51:35'),
(3, 3, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 15:41:48', '2025-05-09 15:41:48'),
(4, 4, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 16:07:19', '2025-05-09 16:07:19'),
(5, 5, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 16:10:19', '2025-05-09 16:10:19'),
(6, 6, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 16:10:46', '2025-05-09 16:10:46'),
(7, 7, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 16:14:49', '2025-05-09 16:14:49'),
(8, 8, 'GCASH', '51114710803', 'PRINCE CHIDI EMMANUEL', '2025-05-09 16:16:30', '2025-05-09 16:16:30');

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

--
-- Table structure for table `boards`
--

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

--
-- Dumping data for table `boards`
--

INSERT INTO `boards` (`id`, `messages`, `created_at`, `updated_at`) VALUES
(1, '816****47 invest 3,000', '2025-03-22 02:03:44', '2025-03-22 02:03:44'),
(2, '816****47 deposited 1,000', '2025-03-22 12:29:47', '2025-03-22 12:29:47'),
(3, '816****47 invest 500', '2025-04-16 08:05:47', '2025-04-16 08:05:47'),
(4, '816****47 invest 1,000', '2025-04-16 08:05:56', '2025-04-16 08:05:56'),
(5, '816****48 invest 2,000', '2025-04-16 15:43:39', '2025-04-16 15:43:39'),
(6, '816****48 invest 2,000', '2025-04-16 15:50:47', '2025-04-16 15:50:47'),
(7, '816****49 invest 8,000', '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(8, '816****47 withdraw 200', '2025-04-16 19:30:25', '2025-04-16 19:30:25'),
(9, '816****47 invest 2,000', '2025-04-21 01:07:10', '2025-04-21 01:07:10'),
(10, '816****47 withdraw 3,000', '2025-04-21 03:51:35', '2025-04-21 03:51:35'),
(11, '816****47 invest 500', '2025-05-09 15:09:26', '2025-05-09 15:09:26'),
(12, '816****47 withdraw 3,000', '2025-05-09 15:41:48', '2025-05-09 15:41:48'),
(13, '816****47 withdraw 3,000', '2025-05-09 16:07:19', '2025-05-09 16:07:19'),
(14, '816****47 withdraw 3,000', '2025-05-09 16:10:19', '2025-05-09 16:10:19'),
(15, '816****47 withdraw 100', '2025-05-09 16:10:46', '2025-05-09 16:10:46'),
(16, '816****47 withdraw 3,000', '2025-05-09 16:14:49', '2025-05-09 16:14:49'),
(17, '816****47 withdraw 3,000', '2025-05-09 16:16:30', '2025-05-09 16:16:30');

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

--
-- Table structure for table `codes`
--

CREATE TABLE `codes` (
  `id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `redeemed_count` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `crypt_payments`
--

CREATE TABLE `crypt_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `wallet_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_out` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_coin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_forwarded_coin` double DEFAULT NULL,
  `coin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response_log` text COLLATE utf8mb4_unicode_ci,
  `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 `daily_tasks`
--

CREATE TABLE `daily_tasks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `task_id` bigint(20) UNSIGNED DEFAULT NULL,
  `task_time` enum('Morning','Night') COLLATE utf8mb4_unicode_ci NOT NULL,
  `task_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `method_code` int(10) UNSIGNED NOT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `method_currency` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `final_amo` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `detail` text COLLATE utf8mb4_unicode_ci,
  `btc_amo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btc_wallet` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trx` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `try` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel',
  `from_api` tinyint(1) NOT NULL DEFAULT '0',
  `admin_feedback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposits`
--

INSERT INTO `deposits` (`id`, `user_id`, `method_code`, `amount`, `method_currency`, `charge`, `rate`, `final_amo`, `detail`, `btc_amo`, `btc_wallet`, `trx`, `try`, `status`, `from_api`, `admin_feedback`, `created_at`, `updated_at`) VALUES
(1, 3, 1001, '1000.00000000', 'NGN', '0.00000000', '1.00000000', '1000.00000000', '{\"phone_number\":{\"field_name\":\"08168271947\",\"type\":\"text\"}}', '0', '', 'UR6OJB28HS4X', 0, 1, 0, NULL, '2025-03-22 12:29:38', '2025-03-22 12:29:47'),
(2, 3, 1001, '500.00000000', 'NGN', '0.00000000', '1.00000000', '500.00000000', NULL, '0', '', 'T388W1ZM7QE3', 0, 1, 0, NULL, '2025-04-17 11:08:26', '2025-04-17 11:08:26'),
(3, 1, 1001, '500.00000000', 'NGN', '0.00000000', '1.00000000', '500.00000000', NULL, '0', '', 'DZUOC4BS3BE1', 0, 2, 0, NULL, '2025-05-09 16:00:23', '2025-05-09 16:00:23');

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

--
-- Table structure for table `email_logs`
--

CREATE TABLE `email_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `mail_sender` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_from` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_to` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_logs`
--

INSERT INTO `email_logs` (`id`, `user_id`, `mail_sender`, `email_from`, `email_to`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Deposit Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your deposit request of <b>1,000.00 NGN</b> is via&nbsp; <b>Bank Transfer </b>submitted successfully<b> .<br></b></div><div><b><br></b></div><div><b>Details of your Deposit :<br></b></div><div><br></div><div>Amount : 1,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">0.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 NGN</div><div>Payable : 1,000.00 NGN <br></div><div>Pay via :&nbsp; Bank Transfer</div><div><br></div><div>Transaction Number : UR6OJB28HS4X</div><div><br></div><div><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-03-22 12:29:47', '2025-03-22 12:29:47'),
(2, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>200.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 200.00 NGN</div><div>Charge: <font color=\"#FF0000\">40.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 160.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : X44O9JXWZ9AU</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>68,500.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-04-16 19:30:25', '2025-04-16 19:30:25'),
(3, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : U515A4YWA15D</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,500.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-04-21 03:51:35', '2025-04-21 03:51:35'),
(4, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : AQKCJZ9V8GM2</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 15:41:48', '2025-05-09 15:41:48'),
(5, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : NH6M3OOPNXG1</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 16:07:19', '2025-05-09 16:07:19'),
(6, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : MYRWKJHSZTYB</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 16:10:19', '2025-05-09 16:10:19'),
(7, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>100.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 100.00 NGN</div><div>Charge: <font color=\"#FF0000\">20.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 80.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : 5HUP5MGORKKB</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 16:10:46', '2025-05-09 16:10:46');
INSERT INTO `email_logs` (`id`, `user_id`, `mail_sender`, `email_from`, `email_to`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(8, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : 797NV589E6X4</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 16:14:49', '2025-05-09 16:14:49'),
(9, 1, 'php', 'Chevron Corp no-reply@gmgstry.org', '8168271947@gmail', 'Withdraw Request Submitted Successfully', '<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n    <title>GMG</title>\n    <style>\n@media only screen and (max-width: 620px) {\n  table.body h1 {\n    font-size: 28px !important;\n    margin-bottom: 10px !important;\n  }\n\n  table.body p,\ntable.body ul,\ntable.body ol,\ntable.body td,\ntable.body span,\ntable.body a {\n    font-size: 16px !important;\n  }\n\n  table.body .wrapper,\ntable.body .article {\n    padding: 10px !important;\n  }\n\n  table.body .content {\n    padding: 0 !important;\n  }\n\n  table.body .container {\n    padding: 0 !important;\n    width: 100% !important;\n  }\n\n  table.body .main {\n    border-left-width: 0 !important;\n    border-radius: 0 !important;\n    border-right-width: 0 !important;\n  }\n\n  table.body .btn table {\n    width: 100% !important;\n  }\n\n  table.body .btn a {\n    width: 100% !important;\n  }\n\n  table.body .img-responsive {\n    height: auto !important;\n    max-width: 100% !important;\n    width: auto !important;\n  }\n}\n@media all {\n  .ExternalClass {\n    width: 100%;\n  }\n\n  .ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\n    line-height: 100%;\n  }\n\n  .apple-link a {\n    color: inherit !important;\n    font-family: inherit !important;\n    font-size: inherit !important;\n    font-weight: inherit !important;\n    line-height: inherit !important;\n    text-decoration: none !important;\n  }\n\n  #MessageViewBody a {\n    color: inherit;\n    text-decoration: none;\n    font-size: inherit;\n    font-family: inherit;\n    font-weight: inherit;\n    line-height: inherit;\n  }\n\n  .btn-primary table td:hover {\n    background-color: #34495e !important;\n  }\n\n  .btn-primary a:hover {\n    background-color: #34495e !important;\n    border-color: #34495e !important;\n  }\n}\n</style>\n  \n  \n    <span class=\"preheader\" style=\"color: transparent; display: none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; visibility: hidden; width: 0;\"></span>\n    <table role=\"presentation\" class=\"body\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f6f6f6; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" bgcolor=\"#f6f6f6\">\n      <tbody><tr>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n        <td class=\"container\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; display: block; max-width: 580px; padding: 10px; width: 580px; margin: 0 auto;\" width=\"580\" valign=\"top\">\n          <div class=\"content\" style=\"box-sizing: border-box; display: block; margin: 0 auto; max-width: 580px; padding: 10px;\">\n\n            <!-- START CENTERED WHITE CONTAINER -->\n            <table role=\"presentation\" class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background: #ffffff; border-radius: 3px; width: 100%;\" width=\"100%\">\n\n              <!-- START MAIN CONTENT AREA -->\n              <tbody><tr>\n                <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\" valign=\"top\">\n                  <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tbody><tr>\n                      <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">Hello 8168271947,</p><div>Your withdraw request of <b>3,000.00 NGN</b>&nbsp; via&nbsp; <b>Bank Withdrawal </b>has been submitted Successfully.<b><br></b></div><div><b><br></b></div><div><b>Details of your withdraw:<br></b></div><div><br></div><div>Amount : 3,000.00 NGN</div><div>Charge: <font color=\"#FF0000\">600.00 NGN</font></div><div><br></div><div>Conversion Rate : 1 NGN = 1.00 ₦</div><div>You will get: 2,400.00 ₦ <br></div><div>Via :&nbsp; Bank Withdrawal</div><div><br></div><div>Transaction Number : 3AFMD6FE9G6T</div><div><font size=\"4\" color=\"#FF0000\"><b><br></b></font></div><div><font size=\"4\" color=\"#FF0000\"><b>This may take 10 Minutes to process the payment.</b></font><br></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\"><b><br></b></font></div><div><font size=\"5\">Your current Balance is <b>66,000.00 NGN</b></font></div><div><br></div><div><br><br><br><br></div><br><br><br><p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px;\">GRAPHENE MANUFACTURING GROUP (GMG)<br></p>\n                      </td>\n                    </tr>\n                  </tbody></table>\n                </td>\n              </tr>\n\n            <!-- END MAIN CONTENT AREA -->\n            </tbody></table>\n            <!-- END CENTERED WHITE CONTAINER -->\n\n            <!-- START FOOTER -->\n            <div class=\"footer\" style=\"clear: both; margin-top: 10px; text-align: center; width: 100%;\">\n              <table role=\"presentation\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tbody><tr>\n                  <td class=\"content-block\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\">\n                    <span class=\"apple-link\" style=\"color: #999999; font-size: 12px; text-align: center;\">(c) GRAPHENE MANUFACTURING GROUP (GMG)</span><br><br>Don\'t like these emails? <a href=\"http://i.imgur.com/CScmqnj.gif\" style=\"text-decoration: underline; color: #999999; font-size: 12px; text-align: center;\">Unsubscribe</a>.\n                  </td>\n                </tr>\n                <tr>\n                  <td class=\"content-block powered-by\" style=\"font-family: sans-serif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; color: #999999; font-size: 12px; text-align: center;\" valign=\"top\" align=\"center\"><br></td>\n                </tr>\n              </tbody></table>\n            </div>\n            <!-- END FOOTER -->\n\n          </div>\n        </td>\n        <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\" valign=\"top\">&nbsp;</td>\n      </tr>\n    </tbody></table>', '2025-05-09 16:16:30', '2025-05-09 16:16:30');

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

--
-- Table structure for table `email_sms_templates`
--

CREATE TABLE `email_sms_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `act` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subj` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_body` text COLLATE utf8mb4_unicode_ci,
  `sms_body` text COLLATE utf8mb4_unicode_ci,
  `shortcodes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_status` tinyint(1) NOT NULL DEFAULT '1',
  `sms_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 `extensions`
--

CREATE TABLE `extensions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `act` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `script` text COLLATE utf8mb4_unicode_ci,
  `shortcode` text COLLATE utf8mb4_unicode_ci COMMENT 'object',
  `support` text COLLATE utf8mb4_unicode_ci COMMENT 'help section',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>enable, 2=>disable',
  `deleted_at` datetime 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 `extensions`
--

INSERT INTO `extensions` (`id`, `act`, `name`, `description`, `image`, `script`, `shortcode`, `support`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'tawk-chat', 'Tawk.to', 'Key location is shown bellow', 'tawky_big.png', '<script>\r\n                        var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n                        (function(){\r\n                        var s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\n                        s1.async=true;\r\n                        s1.src=\"https://embed.tawk.to/{{app_key}}\";\r\n                        s1.charset=\"UTF-8\";\r\n                        s1.setAttribute(\"crossorigin\",\"*\");\r\n                        s0.parentNode.insertBefore(s1,s0);\r\n                        })();\r\n                    </script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"------------------\"}}', 'twak.png', 2, NULL, '2019-10-18 22:16:05', '2021-06-23 09:52:11');

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

--
-- Table structure for table `frontends`
--

CREATE TABLE `frontends` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `data_keys` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data_values` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `frontends`
--

INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `created_at`, `updated_at`) VALUES
(1, 'seo.data', '{\"seo_image\":\"1\",\"keywords\":[\"admin\",\"blog\",\"aaaa\",\"ddd\",\"aaa\"],\"description\":\"Vip-Alat \\n\\nA unique system which generates up to 700% in 25 days with daily withdrawals\",\"social_title\":\"VIP Alat\",\"social_description\":\"Vip-Alat \\n\\nA unique system which generates up to 700% in 25 days with daily withdrawals\",\"image\":\"64a873c7ad2ae1688761287.jpg\"}', '2020-07-04 22:42:52', '2023-07-07 20:21:27'),
(24, 'about.content', '{\"has_image\":\"1\",\"heading\":\"About LiteHyip\",\"sub_heading\":\"Lorem, ipsum dolor sit amet consectetur adipisicing elit. Sunt debitis ipsam molestias! Magni at molestiae a, eveniet voluptas et doloribus expedita officia, quo, ducimus rem unde sequi beatae vitae quis eveniet voluptas.\",\"image\":\"60cf2c42b63571624190018.png\"}', '2020-10-27 23:51:20', '2021-06-23 05:29:58'),
(25, 'blog.content', '{\"heading\":\"Latest News\",\"sub_heading\":\"Hic tenetur nihil ex. Doloremque ipsa velit, ea molestias expedita sed voluptatem ex voluptatibus temporibus sequi. sddd\"}', '2020-10-27 23:51:34', '2020-10-27 23:52:52'),
(26, 'blog.element', '{\"has_image\":[\"1\",\"1\"],\"title\":\"this is a test blog 2\",\"description\":\"aewf asdf\",\"description_nic\":\"asdf asdf\",\"blog_icon\":\"<i class=\\\"lab la-hornbill\\\"><\\/i>\",\"blog_image_1\":\"5f99164f1baec1603868239.jpg\",\"blog_image_2\":\"5ff2e146346d21609752902.jpg\"}', '2020-10-27 23:57:19', '2021-01-04 02:35:02'),
(27, 'contact_us.content', '{\"heading\":\"Get in Touch\",\"sub_heading\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt voluptates rerum corporis molestias dolores.\"}', '2020-10-27 23:59:19', '2021-06-22 04:03:53'),
(28, 'counter.content', '{\"heading\":\"Latest News\",\"sub_heading\":\"Register New Account\"}', '2020-10-28 00:04:02', '2020-10-28 00:04:02'),
(30, 'blog.element', '{\"has_image\":[\"1\",\"1\"],\"title\":\"This is test blog 1\",\"description\":\"asdfasdf ffffffffff\",\"description_nic\":\"asdfasdf asdd vvvvvvvvvvvvvvvvvv\",\"blog_icon\":\"<i class=\\\"las la-highlighter\\\"><\\/i>\",\"blog_image_1\":\"5f9d0689e022d1604126345.jpg\",\"blog_image_2\":\"5f9d068a341211604126346.jpg\"}', '2020-10-30 23:39:05', '2020-11-12 03:36:39'),
(31, 'social_icon.element', '{\"title\":\"Facebook\",\"social_icon\":\"<i class=\\\"las la-expand\\\"><\\/i>\",\"url\":\"https:\\/\\/www.google.com\\/\"}', '2020-11-12 03:07:30', '2021-05-12 04:56:59'),
(33, 'feature.content', '{\"heading\":\"Why You Trust Our Service\"}', '2021-01-03 22:40:54', '2021-06-20 10:58:56'),
(35, 'service.element', '{\"trx_type\":\"withdraw\",\"service_icon\":\"<i class=\\\"las la-highlighter\\\"><\\/i>\",\"title\":\"asdfasdf\",\"description\":\"asdfasdfasdfasdf\"}', '2021-03-06 00:12:10', '2021-03-06 00:12:10'),
(36, 'service.content', '{\"trx_type\":\"withdraw\",\"heading\":\"asdf fffff\",\"sub_heading\":\"asdf asdfasdf\"}', '2021-03-06 00:27:34', '2021-03-06 01:19:39'),
(39, 'banner.content', '{\"has_image\":\"1\",\"heading\":\"Invest for Future in Stable Platform and Make Fast Money\",\"sub_heading\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Alias quibusdam eveniet similique magni accusantium soluta totam incidunt quam quis architecto amet.\",\"btn_text\":\"Get Started\",\"btn_link\":\"login\",\"image\":\"60cf2520cc9251624188192.jpg\"}', '2021-05-02 05:09:30', '2021-06-20 09:53:13'),
(41, 'cookie.data', '{\"link\":\"#\",\"description\":\"<font color=\\\"#ffffff\\\" face=\\\"Exo, sans-serif\\\"><span style=\\\"font-size: 18px;\\\">We may use cookies or any other tracking technologies when you visit our website, including any other media form, mobile website, or mobile application related or connected to help customize the Site and improve your experience.<\\/span><\\/font><br>\",\"status\":1}', '2020-07-04 22:42:52', '2021-06-06 08:43:37'),
(44, 'overView.element', '{\"title\":\"Total Users\",\"text\":\"68,00,000\",\"icon\":\"<i class=\\\"fas fa-users\\\"><\\/i>\"}', '2021-06-20 10:16:20', '2021-06-20 10:18:22'),
(45, 'overView.element', '{\"title\":\"Winners\",\"text\":\"98,00,000\",\"icon\":\"<i class=\\\"fas fa-trophy\\\"><\\/i>\"}', '2021-06-20 10:17:27', '2021-06-20 10:18:27'),
(46, 'overView.element', '{\"title\":\"Total Visitors\",\"text\":\"88,00,000\",\"icon\":\"<i class=\\\"far fa-eye\\\"><\\/i>\"}', '2021-06-20 10:18:06', '2021-06-20 10:18:06'),
(47, 'about.element', '{\"title\":\"Secure Investments\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"fas fa-shield-alt\\\"><\\/i>\"}', '2021-06-20 10:29:38', '2021-06-20 10:29:38'),
(48, 'about.element', '{\"title\":\"Fast Online Transfer\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"fas fa-tachometer-alt\\\"><\\/i>\"}', '2021-06-20 10:31:23', '2021-06-20 10:31:23'),
(49, 'about.element', '{\"title\":\"Profit Guaranteed\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"fas fa-award\\\"><\\/i>\"}', '2021-06-20 10:31:48', '2021-06-20 10:31:48'),
(50, 'package.content', '{\"heading\":\"Latest Investment Packages\"}', '2021-06-20 10:35:19', '2021-06-20 10:35:19'),
(51, 'howToWork.content', '{\"heading\":\"It\'s Easy to Join and Make Money\",\"sub_heading\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Veniam consequatur ipsam ab aperiam facilis ad deserunt debitis ullam. Labore dolore odio magnam corporis in iure.\"}', '2021-06-20 10:38:40', '2021-06-20 10:38:40'),
(52, 'howToWork.element', '{\"title\":\"Create an Account\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Nobis, modi omnis.\"}', '2021-06-20 10:40:25', '2021-06-20 10:40:25'),
(53, 'howToWork.element', '{\"title\":\"Choose Lottery\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Nobis, modi omnis.\"}', '2021-06-20 10:40:37', '2021-06-20 10:40:37'),
(54, 'howToWork.element', '{\"title\":\"Pick Lottery\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\"}', '2021-06-20 10:40:50', '2021-06-20 10:40:50'),
(55, 'howToWork.element', '{\"title\":\"Win Lottery\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\"}', '2021-06-20 10:40:59', '2021-06-20 10:40:59'),
(56, 'latestTrx.content', '{\"heading\":\"Recent Deposit And Withdraw\"}', '2021-06-20 10:56:04', '2021-06-21 09:59:56'),
(59, 'feature.element', '{\"title\":\"Best Lottery Platform\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"fas fa-award\\\"><\\/i>\"}', '2021-06-20 11:10:15', '2021-06-20 11:12:18'),
(60, 'feature.element', '{\"title\":\"Quick Deposit\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"las la-wallet\\\"><\\/i>\"}', '2021-06-20 11:10:29', '2021-06-20 11:12:26'),
(61, 'feature.element', '{\"title\":\"Quick Withdraw\",\"text\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Numquam, minus maiores.\",\"icon\":\"<i class=\\\"las la-credit-card\\\"><\\/i>\"}', '2021-06-20 11:10:39', '2021-06-20 11:12:30'),
(62, 'faq.content', '{\"heading\":\"Frequently Asked Questions\"}', '2021-06-20 11:13:37', '2021-06-20 11:13:37'),
(63, 'faq.element', '{\"question\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit.\",\"answer\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Doloremque perspiciatis harum voluptatibus natus alias nesciunt eius similique tenetur corporis fuga eligendi in enim quisquam dolor voluptates nihil obcaecati pariatur commodi facilis, officiis nobis porro eum architecto! Delectus ut voluptatibus voluptatem, aliquam tenetur et facilis, quia veritatis temporibus, ex magni soluta.\"}', '2021-06-20 11:14:00', '2021-06-20 11:14:00'),
(64, 'faq.element', '{\"question\":\"Doloremque perspiciatis harum voluptatibus natus.\",\"answer\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Doloremque perspiciatis harum voluptatibus natus alias nesciunt eius similique tenetur corporis fuga eligendi in enim quisquam dolor voluptates nihil obcaecati pariatur commodi facilis, officiis nobis porro eum architecto! Delectus ut voluptatibus voluptatem, aliquam tenetur et facilis, quia veritatis temporibus, ex magni soluta.\"}', '2021-06-20 11:14:21', '2021-06-20 11:14:21'),
(65, 'faq.element', '{\"question\":\"Nesciunt eius similique tenetur corporis fuga.\",\"answer\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Doloremque perspiciatis harum voluptatibus natus alias nesciunt eius similique tenetur corporis fuga eligendi in enim quisquam dolor voluptates nihil obcaecati pariatur commodi facilis, officiis nobis porro eum architecto! Delectus ut voluptatibus voluptatem, aliquam tenetur et facilis, quia veritatis temporibus, ex magni soluta.\"}', '2021-06-20 11:14:39', '2021-06-20 11:14:39'),
(66, 'faq.element', '{\"question\":\"Eligendi in enim quisquam dolor voluptates nihil.\",\"answer\":\"Lorem ipsum dolor sit amet consectetur adipisicing elit. Doloremque perspiciatis harum voluptatibus natus alias nesciunt eius similique tenetur corporis fuga eligendi in enim quisquam dolor voluptates nihil obcaecati pariatur commodi facilis, officiis nobis porro eum architecto! Delectus ut voluptatibus voluptatem, aliquam tenetur et facilis, quia veritatis temporibus, ex magni soluta.\"}', '2021-06-20 11:14:54', '2021-06-20 11:14:54'),
(67, 'topInvestor.content', '{\"heading\":\"Top Investors\"}', '2021-06-20 11:39:13', '2021-06-20 11:39:13'),
(68, 'topInvestor.element', '{\"has_image\":\"1\",\"name\":\"Rahim\",\"country\":\"Bangladesh\",\"date\":\"27 Feb, 2020\",\"image\":\"60cf40a9a6aff1624195241.jpg\"}', '2021-06-20 11:50:41', '2021-06-20 11:50:41'),
(69, 'topInvestor.element', '{\"has_image\":\"1\",\"name\":\"Karim\",\"country\":\"American Samoa\",\"date\":\"17 Feb, 2020\",\"image\":\"60cf40cc362851624195276.jpg\"}', '2021-06-20 11:51:16', '2021-06-20 11:51:16'),
(70, 'topInvestor.element', '{\"has_image\":\"1\",\"name\":\"Rasel\",\"country\":\"England\",\"date\":\"17 Feb, 2021\",\"image\":\"60cf40ed21f901624195309.jpg\"}', '2021-06-20 11:51:49', '2021-06-20 11:51:49'),
(71, 'testimonial.content', '{\"heading\":\"What User Say About Us\",\"sub_heading\":\"Lorem, ipsum dolor sit amet consectetur adipisicing elit. Nisi suscipit, sunt obcaecati porro consequuntur quo deleniti voluptatum at qui eum quibusdam sapiente laborum\"}', '2021-06-20 11:55:37', '2021-06-20 11:55:37'),
(72, 'testimonial.element', '{\"has_image\":\"1\",\"name\":\"Rahim\",\"number_of_star\":\"5\",\"say\":\"Lorem ipsum dolor sit amet, consectetur adicing elit. Eius aut odit non. Sunt, laborum Nemo erunt sit libero eius corporis voluptates sapie smoss.\",\"designation\":\"User\",\"image\":\"60cf4eba798621624198842.png\"}', '2021-06-20 12:45:05', '2021-06-20 12:50:42'),
(73, 'testimonial.element', '{\"has_image\":\"1\",\"name\":\"Morjina\",\"number_of_star\":\"4\",\"say\":\"Lorem ipsum dolor sit amet, consectetur adicing elit. Eius aut odit non. Sunt, laborum Nemo erunt sit libero eius corporis voluptates sapie smoss.\",\"designation\":\"Software Develeper\",\"image\":\"60cf4d7f74ed21624198527.png\"}', '2021-06-20 12:45:27', '2021-06-20 12:48:38'),
(74, 'payment.content', '{\"heading\":\"Payment We Accept\",\"sub_heading\":\"Lorem ipsum dolor sit, amet consectetur adipisicing elit. Esse voluptatum eaque earum quos quia? Id aspernatur ratione, voluptas nulla rerum laudantium neque ipsam eaque\",\"btn_text\":\"Create An Account\",\"btn_link\":\"register\"}', '2021-06-20 12:56:36', '2021-06-20 13:08:49'),
(75, 'payment.element', '{\"title\":\"Investors\",\"text\":\"24k\"}', '2021-06-20 13:01:15', '2021-06-20 13:01:15'),
(76, 'payment.element', '{\"title\":\"Investors\",\"text\":\"56K\"}', '2021-06-20 13:01:30', '2021-06-20 13:01:30'),
(77, 'payment.element', '{\"title\":\"Investors\",\"text\":\"22K\"}', '2021-06-20 13:01:40', '2021-06-20 13:01:40'),
(78, 'payment.element', '{\"title\":\"Investors\",\"text\":\"24k\"}', '2021-06-20 13:01:52', '2021-06-20 13:01:52'),
(79, 'footer.content', '{\"text\":\"Copyright \\u00a9 2021 All Right Reserved\"}', '2021-06-20 13:30:47', '2021-06-20 13:30:47'),
(80, 'footer.element', '{\"soial_media_link\":\"https:\\/\\/www.facebook.com\",\"icon\":\"<i class=\\\"fab fa-facebook-f\\\"><\\/i>\"}', '2021-06-20 13:31:28', '2021-06-20 13:31:28'),
(81, 'footer.element', '{\"soial_media_link\":\"https:\\/\\/www.youtube.com\",\"icon\":\"<i class=\\\"fab fa-youtube\\\"><\\/i>\"}', '2021-06-20 13:31:46', '2021-06-20 13:31:46'),
(82, 'policy_pages.element', '{\"title\":\"Privacy\",\"details\":\"<div><font color=\\\"#ff00cc\\\">loremLorem, ipsum dolor sit amet consectetur adipisicing elit. Aut commodi cupiditate neque doloribus? Assumenda natus officiis eius quaerat laboriosam harum temporibus delectus ab eaque quas nulla dolore reiciendis voluptate magni minima laborum ipsum, nemo unde. Ut similique, quod itaque reprehenderit illum inventore dolore sint cupiditate cum eaque earum asperiores ducimus vero ipsum in aspernatur officiis natus possimus nam praesentium obcaecati! Ducimus, voluptatum corrupti! Quia et maxime perferendis architecto. Sed facilis aliquam eveniet. Quaerat cumque aspernatur perferendis fuga labore eius saepe voluptatibus sit ipsum qui, culpa eligendi unde porro voluptatem atque consectetur ipsam tempore doloribus esse iure sint eum rerum! Enim ab, harum neque molestiae maiores architecto tempore omnis voluptatum. Iure vitae eligendi recusandae distinctio, earum culpa iste tenetur atque accusantium vel exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<br \\/><\\/font><div><font color=\\\"#ff00cc\\\">exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<\\/font><\\/div><\\/div>\"}', '2021-06-20 13:35:54', '2021-06-23 09:46:03'),
(83, 'breadcumb.content', '{\"has_image\":\"1\",\"image\":\"60d020254c9181624252453.jpg\"}', '2021-06-21 03:41:58', '2021-06-21 03:44:13'),
(84, 'contact_us.element', '{\"address_type\":\"Office Address\",\"address\":\"Shyamoli Ring Road, Janata Housing Society, Adabor, Dhaka - 1207, Bangladesh\",\"icon\":\"<i class=\\\"fas fa-map-marker-alt\\\"><\\/i>\"}', '2021-06-22 04:04:09', '2021-06-22 04:04:09'),
(85, 'contact_us.element', '{\"address_type\":\"Phone\",\"address\":\"+123456789541\",\"icon\":\"<i class=\\\"las la-phone\\\"><\\/i>\"}', '2021-06-22 04:04:49', '2021-06-22 04:04:49'),
(86, 'contact_us.element', '{\"address_type\":\"Email\",\"address\":\"demo@gmail.com\",\"icon\":\"<i class=\\\"fas fa-envelope-open\\\"><\\/i>\"}', '2021-06-22 04:05:16', '2021-06-22 04:05:16'),
(87, 'footer.element', '{\"soial_media_link\":\"https:\\/\\/www.instagram.com\",\"icon\":\"<i class=\\\"fab fa-instagram\\\"><\\/i>\"}', '2021-06-23 09:31:30', '2021-06-23 09:31:30'),
(88, 'footer.element', '{\"soial_media_link\":\"https:\\/\\/www.twitter.com\",\"icon\":\"<i class=\\\"fab fa-twitter\\\"><\\/i>\"}', '2021-06-23 09:31:50', '2021-06-23 09:31:50'),
(89, 'footer.element', '{\"soial_media_link\":\"https:\\/\\/www.linkedin.com\",\"icon\":\"<i class=\\\"fab fa-linkedin\\\"><\\/i>\"}', '2021-06-23 09:32:06', '2021-06-23 09:32:06'),
(90, 'policy_pages.element', '{\"title\":\"Terms\",\"details\":\"<font color=\\\"#ff00cc\\\">loremLorem, ipsum dolor sit amet consectetur adipisicing elit. Aut commodi cupiditate neque doloribus? Assumenda natus officiis eius quaerat laboriosam harum temporibus delectus ab eaque quas nulla dolore reiciendis voluptate magni minima laborum ipsum, nemo unde. Ut similique, quod itaque reprehenderit illum inventore dolore sint cupiditate cum eaque earum asperiores ducimus vero ipsum in aspernatur officiis natus possimus nam praesentium obcaecati! Ducimus, voluptatum corrupti! Quia et maxime perferendis architecto. Sed facilis aliquam eveniet. Quaerat cumque aspernatur perferendis fuga labore eius saepe voluptatibus sit ipsum qui, culpa eligendi unde porro voluptatem atque consectetur ipsam tempore doloribus esse iure sint eum rerum! Enim ab, harum neque molestiae maiores architecto tempore omnis voluptatum. Iure vitae eligendi recusandae distinctio, earum culpa iste tenetur atque accusantium vel exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<br \\/><\\/font><div><font color=\\\"#ff00cc\\\">exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<\\/font><\\/div>\"}', '2021-06-23 09:34:56', '2021-06-23 09:45:41'),
(91, 'policy_pages.element', '{\"title\":\"Policy\",\"details\":\"<div><font color=\\\"#ff00cc\\\">loremLorem, ipsum dolor sit amet consectetur adipisicing elit. Aut commodi cupiditate neque doloribus? Assumenda natus officiis eius quaerat laboriosam harum temporibus delectus ab eaque quas nulla dolore reiciendis voluptate magni minima laborum ipsum, nemo unde. Ut similique, quod itaque reprehenderit illum inventore dolore sint cupiditate cum eaque earum asperiores ducimus vero ipsum in aspernatur officiis natus possimus nam praesentium obcaecati! Ducimus, voluptatum corrupti! Quia et maxime perferendis architecto. Sed facilis aliquam eveniet. Quaerat cumque aspernatur perferendis fuga labore eius saepe voluptatibus sit ipsum qui, culpa eligendi unde porro voluptatem atque consectetur ipsam tempore doloribus esse iure sint eum rerum! Enim ab, harum neque molestiae maiores architecto tempore omnis voluptatum. Iure vitae eligendi recusandae distinctio, earum culpa iste tenetur atque accusantium vel exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<br \\/><\\/font><div><font color=\\\"#ff00cc\\\">exercitationem ab, nemo ut magnam, tempora natus dolor aspernatur debitis voluptatem vero quidem et at omnis? Laboriosam fugiat explicabo quasi iusto, similique saepe non quod. Praesentium quia minus quasi.<\\/font><\\/div><\\/div>\"}', '2021-06-23 09:36:26', '2021-06-23 09:46:08'),
(92, 'faq.element', '{\"question\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit.\",\"answer\":\"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, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as thei\"}', '2021-06-23 09:47:17', '2021-06-23 09:47:17'),
(93, 'faq.element', '{\"question\":\"Eligendi in enim quisquam dolor voluptates nihil.\",\"answer\":\"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, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as thei\"}', '2021-06-23 09:47:26', '2021-06-23 09:47:26'),
(94, 'faq.element', '{\"question\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit.\",\"answer\":\"Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words,\"}', '2021-06-23 09:47:43', '2021-06-23 09:47:43'),
(95, 'faq.element', '{\"question\":\"Nesciunt eius similique tenetur corporis fuga.\",\"answer\":\"Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words,\"}', '2021-06-23 09:47:56', '2021-06-23 09:47:56'),
(96, 'topInvestor.element', '{\"has_image\":\"1\",\"name\":\"Zahidul\",\"country\":\"\\u00c5land Islands\",\"date\":\"11 Feb, 2021\",\"image\":\"60d318a8b590e1624447144.jpg\"}', '2021-06-23 09:49:04', '2021-06-23 09:49:05'),
(97, 'testimonial.element', '{\"has_image\":\"1\",\"name\":\"Roksana\",\"number_of_star\":\"5\",\"say\":\"Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,\",\"designation\":\"Android Developer\",\"image\":\"60d318e2ae25a1624447202.png\"}', '2021-06-23 09:50:02', '2021-06-23 09:50:28');

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

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

CREATE TABLE `fund_transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `withdrawal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `response` text COLLATE utf8mb4_unicode_ci,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` int(11) DEFAULT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NULL',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>enable, 2=>disable',
  `gateway_parameters` text COLLATE utf8mb4_unicode_ci,
  `supported_currencies` text COLLATE utf8mb4_unicode_ci,
  `crypto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: fiat currency, 1: crypto currency',
  `extra` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `input_form` text COLLATE utf8mb4_unicode_ci,
  `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`, `alias`, `image`, `status`, `gateway_parameters`, `supported_currencies`, `crypto`, `extra`, `description`, `input_form`, `created_at`, `updated_at`) VALUES
(30, 116, 'Qepay', 'Qepay', '66196ac9bfdcc1712941769.jpeg', 1, '{\"mchtId\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"102001002\"},\"paymentKey\":{\"title\":\"Payment Key\",\"global\":true,\"value\":\"QMHYTGCP3CSHQROIMRI9FATYKQ1HPQ3Q\"},\"depositKey\":{\"title\":\"Deposit Key\",\"global\":true,\"value\":\"a3a0b75ae9964c7ab08d8b8125cb6715\"}}', '{\"PKR\":\"PKR\",\"USD\":\"USD\"}', 0, '{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"shpay\"}}', NULL, NULL, NULL, '2025-05-09 15:53:11'),
(34, 1000, 'USDT', 'usdt', '62ac838c12d611655473036.png', 1, '[]', '[]', 0, NULL, '<div>Send USDT into</div><div><br></div><div>Wallet Address<br></div>', '{\"transaction_hash\":{\"field_name\":\"transaction_hash\",\"field_level\":\"Transaction Hash\",\"type\":\"text\",\"validation\":\"required\"}}', '2022-06-17 12:37:16', '2024-02-22 22:40:46'),
(35, 1001, 'Bank Transfer', 'bank_transfer', '63c99223114c51674154531.png', 1, '[]', '[]', 0, NULL, '<div>Step 1 - Copy account details<br></div><div>Step 2 - Send funds to the generated account number<br></div><div>Step 3 - Enter sender\'s name and Payment receipt</div><div>Step 4 - Submit<br></div>', '{\"phone_number\":{\"field_name\":\"phone_number\",\"field_level\":\"Phone Number\",\"type\":\"text\",\"validation\":\"required\"}}', '2023-01-19 17:55:31', '2025-01-21 03:05:56');

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

--
-- Table structure for table `gateway_currencies`
--

CREATE TABLE `gateway_currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_code` int(11) DEFAULT NULL,
  `gateway_alias` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `max_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `percent_charge` decimal(5,2) NOT NULL DEFAULT '0.00',
  `fixed_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_parameter` text COLLATE utf8mb4_unicode_ci,
  `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 `gateway_currencies`
--

INSERT INTO `gateway_currencies` (`id`, `name`, `currency`, `symbol`, `method_code`, `gateway_alias`, `min_amount`, `max_amount`, `percent_charge`, `fixed_charge`, `rate`, `image`, `gateway_parameter`, `created_at`, `updated_at`) VALUES
(1, 'Bank Transfer', 'NGN', '', 1001, 'bank_transfer', '100.00000000', '500000.00000000', '0.00', '0.00000000', '1.00000000', '63c99223114c51674154531.png', '{\"phone_number\":{\"field_name\":\"phone_number\",\"field_level\":\"Phone Number\",\"type\":\"text\",\"validation\":\"required\"}}', '2023-01-19 17:55:31', '2025-01-21 03:05:56'),
(5, 'USDT', 'USD', '$', 1000, 'usdt', '1.00000000', '100000.00000000', '0.00', '0.00000000', '750.00000000', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `investments`
--

CREATE TABLE `investments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `trx` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `interest_type` tinyint(1) NOT NULL COMMENT '0=>Fixed, 1=>Percent',
  `interest_amount` decimal(28,8) NOT NULL,
  `total_return` double NOT NULL DEFAULT '0',
  `total_paid` int(11) NOT NULL,
  `next_return_date` datetime NOT NULL,
  `status` tinyint(4) NOT NULL COMMENT '0=>Running, 1=>Completed',
  `is_started` tinyint(4) 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;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`id`, `trx`, `plan_id`, `user_id`, `amount`, `interest_type`, `interest_amount`, `total_return`, `total_paid`, `next_return_date`, `status`, `is_started`, `created_at`, `updated_at`) VALUES
(2, '6TFUFN1AH836', 1, 1, '500.00000000', 0, '100.00000000', 30, 0, '2025-04-17 09:05:47', 0, 1, '2025-04-16 08:05:47', '2025-04-16 08:05:47'),
(3, 'AON53RFKN11M', 2, 1, '1000.00000000', 0, '300.00000000', 30, 0, '2025-04-17 09:05:56', 0, 1, '2025-04-16 08:05:56', '2025-04-16 08:05:56'),
(5, '4CGTAE2H45PC', 3, 3, '2000.00000000', 0, '600.00000000', 30, 0, '2025-04-17 16:50:47', 0, 1, '2025-04-16 15:50:47', '2025-04-16 15:50:47'),
(6, 'E523E5K8DVAD', 5, 4, '8000.00000000', 0, '2200.00000000', 30, 0, '2025-04-17 19:26:46', 0, 1, '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(7, 'GGMXPQRY5OMS', 1, 1, '500.00000000', 0, '100.00000000', 30, 0, '2025-04-18 11:45:35', 1, 1, '2025-04-17 10:45:35', '2025-04-17 10:45:35'),
(8, 'KJA5JMYZ8KVZ', 1, 1, '500.00000000', 0, '100.00000000', 30, 0, '2025-04-18 11:55:18', 1, 1, '2025-04-17 10:55:18', '2025-04-17 10:55:18'),
(9, 'T388W1ZM7QE3', 1, 1, '500.00000000', 0, '100.00000000', 30, 0, '2025-04-18 12:08:26', 1, 1, '2025-04-17 11:08:26', '2025-04-17 11:08:26'),
(10, 'MFKJZEKCOPX6', 3, 1, '2000.00000000', 0, '600.00000000', 30, 0, '2025-04-22 02:07:10', 0, 1, '2025-04-21 01:07:10', '2025-04-21 01:07:10'),
(11, 'Z568FAW4SWAK', 1, 1, '500.00000000', 0, '100.00000000', 30, 0, '2025-05-10 16:09:26', 0, 1, '2025-05-09 15:09:26', '2025-05-09 15:09:26');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text_align` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: left to right text align, 1: right to left text align',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: not default language, 1: default language',
  `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` bigint(20) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2020_06_14_061757_create_support_tickets_table', 3),
(5, '2020_06_14_061837_create_support_messages_table', 3),
(6, '2020_06_14_061904_create_support_attachments_table', 3),
(7, '2020_06_14_062359_create_admins_table', 3),
(8, '2020_06_14_064604_create_transactions_table', 4),
(9, '2020_06_14_065247_create_general_settings_table', 5),
(12, '2014_10_12_100000_create_password_resets_table', 6),
(13, '2020_06_14_060541_create_user_logins_table', 6),
(14, '2020_06_14_071708_create_admin_password_resets_table', 7),
(15, '2020_09_14_053026_create_countries_table', 8),
(16, '2021_03_15_084721_create_admin_notifications_table', 9),
(17, '2016_06_01_000001_create_oauth_auth_codes_table', 10),
(18, '2016_06_01_000002_create_oauth_access_tokens_table', 10),
(19, '2016_06_01_000003_create_oauth_refresh_tokens_table', 10),
(20, '2016_06_01_000004_create_oauth_clients_table', 10),
(21, '2016_06_01_000005_create_oauth_personal_access_clients_table', 10),
(22, '2021_05_08_103925_create_sms_gateways_table', 11),
(23, '2019_12_14_000001_create_personal_access_tokens_table', 12),
(24, '2021_05_23_111859_create_email_logs_table', 13),
(25, '2021_06_21_161109_create_plans_table', 14),
(26, '2021_06_21_175829_create_investments_table', 15),
(27, '2021_06_22_173346_create_invest_histories_table', 16),
(28, '2022_06_17_090109_create_tasks_table', 17),
(29, '2022_06_17_090408_create_daily_tasks_table', 17),
(30, '2022_06_17_171405_add_url_to_tasks_table', 18),
(31, '2022_06_24_183644_create_wallets_table', 19),
(32, '2022_06_24_183720_create_crypt_payments_table', 19),
(33, '2022_08_06_164635_create_bank_withdrawals_table', 20),
(34, '2022_08_06_220115_create_fund_transfers_table', 20),
(35, '2022_09_06_054404_add_is_bank_to_withdrawal_methods_table', 21),
(36, '2022_09_06_054415_add_is_bank_to_withdrawals_table', 21),
(37, '2023_01_25_093123_create_banks_table', 22),
(38, '2023_03_15_202639_create_boards_table', 23);

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempname` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'template name',
  `secs` text COLLATE utf8mb4_unicode_ci,
  `is_default` 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 `pages`
--

INSERT INTO `pages` (`id`, `name`, `slug`, `tempname`, `secs`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'HOME', 'home', 'templates.basic.', '[\"overView\",\"about\",\"package\",\"howToWork\",\"latestTrx\",\"feature\",\"faq\",\"topInvestor\",\"testimonial\",\"payment\"]', 1, '2020-07-11 05:23:58', '2021-06-20 12:52:00');

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

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

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

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_amount` double NOT NULL,
  `max_amount` double NOT NULL,
  `total_return` int(11) NOT NULL,
  `interest_type` tinyint(1) NOT NULL COMMENT '1=>Percent, 0=>Fixed',
  `interest_amount` double NOT NULL,
  `status` tinyint(1) NOT NULL,
  `img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interest_hours` int(11) NOT NULL DEFAULT '24',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `buy_limit` int(11) NOT NULL DEFAULT '1000',
  `invest_count` int(11) 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 `plans`
--

INSERT INTO `plans` (`id`, `name`, `min_amount`, `max_amount`, `total_return`, `interest_type`, `interest_amount`, `status`, `img`, `interest_hours`, `type`, `buy_limit`, `invest_count`, `created_at`, `updated_at`) VALUES
(1, 'NIKON-1', 500, 500, 30, 0, 100, 1, NULL, 24, 0, 1000, 4, '2025-04-04 02:32:27', '2025-04-17 11:08:26'),
(2, 'NIKON-2', 1000, 1000, 30, 0, 300, 1, NULL, 24, 0, 1000, 1, '2025-04-04 02:38:00', '2025-04-16 08:05:56'),
(3, 'NIKON-3', 2000, 2000, 30, 0, 600, 1, NULL, 24, 0, 1000, 2, '2025-04-04 02:38:27', '2025-04-16 15:50:47'),
(4, 'NIKON-4', 4000, 4000, 30, 0, 1200, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:38:54', '2025-04-04 02:38:54'),
(5, 'NIKON-5', 8000, 8000, 30, 0, 2200, 1, NULL, 24, 0, 1000, 1, '2025-04-04 02:39:36', '2025-04-16 18:26:46'),
(6, 'NIKON-6', 20000, 20000, 30, 0, 6000, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:41:51', '2025-04-04 02:41:51'),
(7, 'NIKON-7', 40000, 40000, 30, 0, 12000, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:43:32', '2025-04-04 02:43:32'),
(8, 'NIKON-8', 80000, 80000, 30, 0, 24000, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:44:18', '2025-04-04 02:44:18'),
(9, 'NIKON-9', 100000, 100000, 30, 0, 30000, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:44:56', '2025-04-04 02:44:56'),
(10, 'NIKON-10', 500000, 500000, 30, 0, 150000, 1, NULL, 24, 0, 1000, 0, '2025-04-04 02:46:04', '2025-04-04 02:46:04');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '2',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `post_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `trx_type` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trx` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `amount`, `charge`, `post_balance`, `trx_type`, `trx`, `details`, `created_at`, `updated_at`) VALUES
(1, 1, '10.00000000', '0.00000000', '10.00000000', '+', 'A5QJ94F4GTUR', 'Welcome Bonus', '2025-03-21 18:11:36', '2025-03-21 18:11:36'),
(2, 1, '3000.00000000', '0.00000000', '7000.00000000', '-', 'ZCKZ8XD4V8M6', 'Successfully invested in VIP-1', '2025-03-22 02:03:44', '2025-03-22 02:03:44'),
(3, 1, '500.00000000', '0.00000000', '69500.00000000', '-', '6TFUFN1AH836', 'Successfully invested in NIKON-1', '2025-04-16 08:05:47', '2025-04-16 08:05:47'),
(4, 1, '1000.00000000', '0.00000000', '68500.00000000', '-', 'AON53RFKN11M', 'Successfully invested in NIKON-2', '2025-04-16 08:05:56', '2025-04-16 08:05:56'),
(5, 2, '10.00000000', '0.00000000', '10.00000000', '+', 'P6WVJ6S9FW57', 'Welcome Bonus', '2025-04-16 15:42:35', '2025-04-16 15:42:35'),
(6, 2, '2000.00000000', '0.00000000', '8000.00000000', '-', '7X493EACMTER', 'Successfully invested in NIKON-3', '2025-04-16 15:43:39', '2025-04-16 15:43:39'),
(7, 3, '10.00000000', '0.00000000', '10.00000000', '+', '3XUU1VX7UK1Q', 'Welcome Bonus', '2025-04-16 15:48:53', '2025-04-16 15:48:53'),
(8, 3, '2000.00000000', '0.00000000', '8000.00000000', '-', '4CGTAE2H45PC', 'Successfully invested in NIKON-3', '2025-04-16 15:50:47', '2025-04-16 15:50:47'),
(9, 1, '600.00000000', '0.00000000', '50600.00000000', '+', '2Q7P7U6F144D', 'Level 1 bonus from 8168271948', '2025-04-16 15:50:47', '2025-04-16 15:50:47'),
(10, 4, '10.00000000', '0.00000000', '10.00000000', '+', 'PF5Y7T7X8BCH', 'Welcome Bonus', '2025-04-16 18:26:04', '2025-04-16 18:26:04'),
(11, 4, '8000.00000000', '0.00000000', '2000.00000000', '-', 'E523E5K8DVAD', 'Successfully invested in NIKON-5', '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(12, 3, '2400.00000000', '0.00000000', '2410.00000000', '+', 'DEWJ5YNOOTSP', 'Level 1 bonus from 8168271949', '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(13, 1, '240.00000000', '0.00000000', '50840.00000000', '+', '2HZ2FV2ZXE5T', 'Level 2 bonus from 8168271949', '2025-04-16 18:26:46', '2025-04-16 18:26:46'),
(14, 1, '200.00000000', '40.00000000', '50640.00000000', '-', 'X44O9JXWZ9AU', '160.00 ₦  Bonus  Withdraw', '2025-04-16 19:30:25', '2025-04-16 19:30:25'),
(15, 1, '2000.00000000', '0.00000000', '66500.00000000', '-', 'MFKJZEKCOPX6', 'Successfully invested in NIKON-3', '2025-04-21 01:07:10', '2025-04-21 01:07:10'),
(16, 1, '100.00000000', '0.00000000', '50840.00000000', '+', 'VFX1TACEXSNF', 'Daily Bonus', '2025-04-21 02:38:28', '2025-04-21 02:38:28'),
(17, 1, '3000.00000000', '600.00000000', '47740.00000000', '-', 'U515A4YWA15D', '2,400.00 ₦  Bonus  Withdraw', '2025-04-21 03:51:35', '2025-04-21 03:51:35'),
(18, 1, '100.00000000', '0.00000000', '47940.00000000', '+', '2SODXSFH8K3X', 'Daily CheckIn', '2025-04-27 01:02:04', '2025-04-27 01:02:04'),
(19, 1, '500.00000000', '0.00000000', '66000.00000000', '-', 'Z568FAW4SWAK', 'Successfully invested in NIKON-1', '2025-05-09 15:09:26', '2025-05-09 15:09:26'),
(20, 1, '3000.00000000', '600.00000000', '44840.00000000', '-', 'AQKCJZ9V8GM2', '2,400.00 ₦  Bonus  Withdraw Via Bank Withdrawal', '2025-05-09 15:41:48', '2025-05-09 15:41:48'),
(21, 1, '3000.00000000', '600.00000000', '41840.00000000', '-', 'NH6M3OOPNXG1', '2,400.00 ₦  Bonus  Withdraw', '2025-05-09 16:07:19', '2025-05-09 16:07:19'),
(22, 1, '3000.00000000', '600.00000000', '38840.00000000', '-', 'MYRWKJHSZTYB', '2,400.00 ₦  Bonus  Withdraw', '2025-05-09 16:10:19', '2025-05-09 16:10:19'),
(23, 1, '100.00000000', '20.00000000', '38740.00000000', '-', '5HUP5MGORKKB', '80.00 ₦  Bonus  Withdraw', '2025-05-09 16:10:46', '2025-05-09 16:10:46'),
(24, 1, '3000.00000000', '600.00000000', '35740.00000000', '-', '797NV589E6X4', '2,400.00 ₦  Bonus  Withdraw', '2025-05-09 16:14:49', '2025-05-09 16:14:49'),
(25, 1, '3000.00000000', '600.00000000', '32740.00000000', '-', '3AFMD6FE9G6T', '2,400.00 ₦  Bonus  Withdraw', '2025-05-09 16:16:30', '2025-05-09 16:16:30');

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

--
-- Table structure for table `user_gift_code_redemptions`
--

CREATE TABLE `user_gift_code_redemptions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `gift_code_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `os` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` (`id`, `user_id`, `user_ip`, `city`, `country`, `country_code`, `longitude`, `latitude`, `browser`, `os`, `created_at`, `updated_at`) VALUES
(1, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-21 18:11:36', '2025-03-21 18:11:36'),
(2, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-21 19:33:33', '2025-03-21 19:33:33'),
(3, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-21 23:16:36', '2025-03-21 23:16:36'),
(4, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-22 09:11:37', '2025-03-22 09:11:37'),
(5, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-22 09:46:26', '2025-03-22 09:46:26'),
(6, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-22 11:15:44', '2025-03-22 11:15:44'),
(7, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-25 08:02:46', '2025-03-25 08:02:46'),
(8, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-29 02:45:35', '2025-03-29 02:45:35'),
(9, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-29 02:47:20', '2025-03-29 02:47:20'),
(10, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-03-31 00:43:35', '2025-03-31 00:43:35'),
(11, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-05 00:26:32', '2025-04-05 00:26:32'),
(12, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-11 21:09:37', '2025-04-11 21:09:37'),
(13, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-15 20:39:02', '2025-04-15 20:39:02'),
(14, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-15 22:23:05', '2025-04-15 22:23:05'),
(15, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 07:03:20', '2025-04-16 07:03:20'),
(16, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 11:36:56', '2025-04-16 11:36:56'),
(17, 2, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 15:42:35', '2025-04-16 15:42:35'),
(18, 3, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 15:48:53', '2025-04-16 15:48:53'),
(19, 3, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 18:23:19', '2025-04-16 18:23:19'),
(20, 4, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 18:26:04', '2025-04-16 18:26:04'),
(21, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-16 18:27:24', '2025-04-16 18:27:24'),
(22, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-17 07:15:09', '2025-04-17 07:15:09'),
(23, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-17 09:46:31', '2025-04-17 09:46:31'),
(24, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-19 16:54:20', '2025-04-19 16:54:20'),
(25, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-20 21:39:47', '2025-04-20 21:39:47'),
(26, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-21 09:16:46', '2025-04-21 09:16:46'),
(27, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-21 13:24:45', '2025-04-21 13:24:45'),
(28, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 00:13:03', '2025-04-27 00:13:03'),
(29, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 00:26:58', '2025-04-27 00:26:58'),
(30, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 00:32:28', '2025-04-27 00:32:28'),
(31, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 01:21:49', '2025-04-27 01:21:49'),
(32, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 02:33:12', '2025-04-27 02:33:12'),
(33, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 03:54:08', '2025-04-27 03:54:08'),
(34, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-04-27 10:17:55', '2025-04-27 10:17:55'),
(35, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-05-08 18:46:39', '2025-05-08 18:46:39'),
(36, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-05-09 14:19:22', '2025-05-09 14:19:22'),
(37, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-05-09 14:25:12', '2025-05-09 14:25:12'),
(38, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-05-09 15:43:32', '2025-05-09 15:43:32'),
(39, 1, '::1', '', '', '', '', '', 'Chrome', 'Mac OS X', '2025-05-09 15:06:53', '2025-05-09 15:06:53');

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

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

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

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `method_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `currency` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `trx` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `final_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `after_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `withdraw_information` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel,  ',
  `admin_feedback` text COLLATE utf8mb4_unicode_ci,
  `is_bonus` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_bank` tinyint(4) NOT NULL DEFAULT '0',
  `ipn_limit` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `method_id`, `user_id`, `amount`, `currency`, `rate`, `charge`, `trx`, `final_amount`, `after_charge`, `withdraw_information`, `status`, `admin_feedback`, `is_bonus`, `created_at`, `updated_at`, `is_bank`, `ipn_limit`) VALUES
(1, 1, 1, '200.00000000', '₦', '1.00000000', '40.00000000', 'X44O9JXWZ9AU', '160.00000000', '160.00000000', NULL, 1, NULL, 1, '2025-04-16 19:30:25', '2025-04-16 19:30:25', 1, 0),
(2, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', 'U515A4YWA15D', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-04-21 03:51:35', '2025-04-21 03:51:35', 1, 0),
(3, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', 'AQKCJZ9V8GM2', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-05-09 15:41:48', '2025-05-09 15:41:48', 1, 0),
(4, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', 'NH6M3OOPNXG1', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-05-09 16:07:19', '2025-05-09 16:07:19', 1, 0),
(5, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', 'MYRWKJHSZTYB', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-05-09 16:10:19', '2025-05-09 16:10:19', 1, 0),
(6, 1, 1, '100.00000000', '₦', '1.00000000', '20.00000000', '5HUP5MGORKKB', '80.00000000', '80.00000000', NULL, 2, NULL, 1, '2025-05-09 16:10:46', '2025-05-09 16:10:46', 1, 0),
(7, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', '797NV589E6X4', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-05-09 16:14:49', '2025-05-09 16:14:49', 1, 0),
(8, 1, 1, '3000.00000000', '₦', '1.00000000', '600.00000000', '3AFMD6FE9G6T', '2400.00000000', '2400.00000000', NULL, 2, NULL, 1, '2025-05-09 16:16:30', '2025-05-09 16:16:30', 1, 0);

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

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_limit` decimal(28,8) DEFAULT '0.00000000',
  `max_limit` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `delay` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fixed_charge` decimal(28,8) DEFAULT '0.00000000',
  `rate` decimal(28,8) DEFAULT '0.00000000',
  `percent_charge` decimal(5,2) DEFAULT NULL,
  `wit_limit` int(11) NOT NULL DEFAULT '4',
  `currency` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_data` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_bank` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw_methods`
--

INSERT INTO `withdraw_methods` (`id`, `name`, `image`, `min_limit`, `max_limit`, `delay`, `fixed_charge`, `rate`, `percent_charge`, `wit_limit`, `currency`, `user_data`, `description`, `status`, `created_at`, `updated_at`, `is_bank`) VALUES
(1, 'Bank Withdrawal', '6316d2e18fd131662440161.jpg', '100.00000000', '500000.00000000', '10 Minutes', '0.00000000', '1.00000000', '20.00', 4, '₦', '[]', '<p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">1. The minimum withdrawal amount is 1000NGN.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">2. Withdrawals will be charged 4% personal income tax.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">3. There is no time limit for withdrawal, and withdrawals can be made at any time.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">4. There is no limit to the number of withdrawals per day.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">5. The withdrawal will be received within half an hour. If there are special circumstances that cause the withdrawal to be delayed, it will not exceed 24 hours.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\">6. Please make sure that your bank account information is filled in correctly, otherwise the withdrawal will fail.</p><p style=\"margin: 0px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); display: block; margin-block: 1em; margin-inline: 0px;\"><br></p>', 1, '2022-09-06 03:56:01', '2025-01-21 01:09:34', 1);

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

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

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

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

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

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

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

--
-- Indexes for table `daily_tasks`
--
ALTER TABLE `daily_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `daily_tasks_user_id_foreign` (`user_id`),
  ADD KEY `daily_tasks_task_id_foreign` (`task_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `codes`
--
ALTER TABLE `codes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `user_gift_code_redemptions`
--
ALTER TABLE `user_gift_code_redemptions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `crypt_payments`
--
ALTER TABLE `crypt_payments`
  ADD CONSTRAINT `crypt_payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `daily_tasks`
--
ALTER TABLE `daily_tasks`
  ADD CONSTRAINT `daily_tasks_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `daily_tasks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

