-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Feb 26, 2023 at 02:40 PM
-- Server version: 10.6.11-MariaDB-cll-lve
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u227876131_mtfghjk`
--

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

--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `id` int(10) NOT NULL,
  `kyc` varchar(255) NOT NULL,
  `acc_no` varchar(20) DEFAULT NULL,
  `uname` varchar(100) DEFAULT NULL,
  `upass` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `fname` varchar(100) DEFAULT NULL,
  `mname` varchar(100) DEFAULT NULL,
  `lname` varchar(100) DEFAULT NULL,
  `addr` varchar(100) DEFAULT NULL,
  `work` varchar(100) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `dob` varchar(30) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `phone_verify` tinyint(4) NOT NULL DEFAULT 2,
  `tmp_otp` varchar(100) DEFAULT NULL,
  `reg_date` varchar(25) DEFAULT NULL,
  `marry` varchar(20) DEFAULT NULL,
  `t_bal` int(200) DEFAULT NULL,
  `a_bal` int(200) DEFAULT NULL,
  `logins` int(50) DEFAULT 0,
  `status` enum('ACTIVE','DORMANT/INACTIVE','DISABLED','CLOSED','SUSPEND','ON HOLD') DEFAULT 'ACTIVE',
  `currency` varchar(50) DEFAULT NULL,
  `cot` varchar(20) DEFAULT NULL,
  `tax` varchar(20) DEFAULT NULL,
  `imf` varchar(20) DEFAULT NULL,
  `pin_auth` varchar(222) DEFAULT NULL,
  `pin` varchar(222) DEFAULT NULL,
  `verify` varchar(40) DEFAULT NULL,
  `resetComplete` varchar(4) NOT NULL DEFAULT 'no',
  `billing_code` tinyint(2) NOT NULL DEFAULT 0,
  `btc` int(2) NOT NULL DEFAULT 0,
  `btc_bal` varchar(255) NOT NULL,
  `btc_w` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `account`
--

INSERT INTO `account` (`id`, `kyc`, `acc_no`, `uname`, `upass`, `email`, `type`, `fname`, `mname`, `lname`, `addr`, `work`, `sex`, `dob`, `phone`, `phone_verify`, `tmp_otp`, `reg_date`, `marry`, `t_bal`, `a_bal`, `logins`, `status`, `currency`, `cot`, `tax`, `imf`, `pin_auth`, `pin`, `verify`, `resetComplete`, `billing_code`, `btc`, `btc_bal`, `btc_w`) VALUES
(34, '', '1028907812', 'augustinesherman', 'demo1', 'codewebscript@gmail.com', 'Checking', 'Augustine', '-', 'Sherman', '102 Bda Road Obosi, Onitsha, Anambra State', 'Web Developer', 'Male', '2022-03-17', '4356435678', 2, '231934', '01/03/2022', 'Married', 144, 144, 0, 'ACTIVE', '$', '1326', '1197', '9215', '341519203', '1431134619', 'Y', 'no', 0, 1, '0.0000', '45676654345tghjhgfdfgh'),
(47, '', '682624372', 'Heldwill20', 'Frankbest10$', 'fawziaakbari07@gmail.com', 'Savings', 'Heldwill', '-', 'Matthias ', 'California', 'Civil Engineer', 'Male', '1970-01-05', '+16319402976', 1, '384055', '04/11/2022', 'Single', 653030, 653000, 0, 'ACTIVE', '$', '1994227302', '1812202897', '302300700', '495257304', '511641024', 'Y', 'no', 0, 1, '0.0000', 'N/A'),
(63, '', '5473787064', 'Arthur2', 'Aurtur22', 'Branoarthur75@gmail.com', 'Savings', 'Brano', '-', 'Arthur', 'California', 'Engineer', 'Male', '1969-12-19', '+1 (504) 261-6687', 2, '227791', '18/12/2020', 'Single', 1682895, 1682895, 0, 'ACTIVE', '$', '1449334442', '1068995523', '2030777711', '1978838568', '1459963457', 'Y', 'no', 2, 1, '0.0000', 'N/A'),
(69, '', '4816589101', 'MarkD231', '498768', 'tonymarts66@gmail.com', 'Savings', 'David', '-', 'mark', 'California', 'Civil Engineer', 'Male', '1972-12-06', '+44 7774 498768', 2, '252411', '03/01/2020', 'Single', 5703240, 5703240, 0, 'ACTIVE', '$', '1339962710', '1828614085', '1603254407', '645697900', '1131810694', 'Y', 'no', 2, 1, '0.0000', 'N/A'),
(70, '', '5635848026', 'Smith3', '743478', 'Smithanderson2590@gmail.com', 'Savings', 'Smith', '-', 'Anderson', 'California', 'Civil Engineer', 'Male', '19970-10-06', '+(1559)274-3478', 2, '141256', '04/01/2023', 'Single', 2973340, 2973340, 0, 'ACTIVE', '$', '1693394781', '2058706843', '709777681', '1289040865', '1143082154', 'Y', 'no', 0, 1, '0.0000', 'N/A'),
(74, '', '7437886469', 'Emmanuel202', 'Regan20', 'makishumble66@gmail.com', 'Savings', 'Emmanuel', '-', 'Regan', 'California', 'Civil Engineer', 'Male', '2000-10-07', '+12093727248', 1, '438221', '16/01/2020', 'Single', 2100976, 2100976, 0, 'ACTIVE', '$', '97046060', '1678529059', '408630808', '172240585', '1232096543', 'Y', 'no', 0, 1, '0.0000', 'N/A');

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

--
-- Table structure for table `account_kyc`
--

CREATE TABLE `account_kyc` (
  `id` int(11) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `account_kyc`
--

INSERT INTO `account_kyc` (`id`, `filename`, `acc_name`, `email`, `status`) VALUES
(33, 'ticket.png', 'Digital Team', 'digitalforestict@gmail.com', 0),
(37, 'admin.jpg', 'Augustine Sherman', 'augustinesherman4@gmail.com', 0),
(38, 'IMG_44183_36523_4_1.jpg', ' ', 'digitalforestict@gmail.com', 0);

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(10) NOT NULL,
  `uname` varchar(40) NOT NULL,
  `upass` varchar(40) NOT NULL,
  `email` varchar(100) NOT NULL,
  `verified_count` enum('Y','N') DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `uname`, `upass`, `email`, `verified_count`) VALUES
(1, 'The admin', 'admin22', 'admin@codewebmaster.com', 'Y');

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

--
-- Table structure for table `alerts`
--

CREATE TABLE `alerts` (
  `id` int(100) NOT NULL,
  `uname` varchar(40) NOT NULL,
  `amount` int(40) NOT NULL,
  `sender_name` varchar(40) NOT NULL,
  `type` varchar(10) NOT NULL,
  `remarks` varchar(100) NOT NULL,
  `date` varchar(20) NOT NULL,
  `time` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `statz` varchar(200) DEFAULT 'Successfull'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `alerts`
--

INSERT INTO `alerts` (`id`, `uname`, `amount`, `sender_name`, `type`, `remarks`, `date`, `time`, `email`, `statz`) VALUES
(1, '1028907812', 111, 'BUY SCRIPTS', 'Credit', 'd', '10/10/2010', '02:57', '', 'Successfull'),
(2, '1028907812', 111, 'Cash Deposit', 'Credit', 'dd', '10/10/2020', '02:55', '', 'Successfull'),
(3, '1028907812', 120, 'BUY SCRIPTS', 'Credit', 'hlp', '2019-11-13', '02:55', '', 'Successfull'),
(4, '1028907812', 700, 'Mike Okafor', 'Debit', 'help', '10/10/2013', '02:55', '', 'Successfull'),
(5, '1028907812', 111, 'Wells Fargo', 'Credit', 'gt', '10/10/2020', '02:55', '', 'Successfull'),
(6, '1028907812', 122, 'Cash Deposit', 'Credit', 'ee', '2019-11-13', '02:55', '', 'Successfull'),
(7, '1028907812', 122, 'BUY SCRIPTS', 'Credit', 'g', '2019-11-13', '02:11', '', 'Successfull'),
(8, '1028907812', 122, 'Cash Deposit', 'Credit', 'gg', '10/10/2010', '02:11', '', 'Successfull'),
(9, '1028907812', 122, 'BUY SCRIPTS', 'Credit', 'fd', '2019-11-13', 'ff', '', 'Successfull'),
(10, '6030015964', 105000, 'BANK OF AMERICA', 'Credit', 'WORKING PAYMENT', '21/04/2021', '12:22', '', 'Successfull'),
(11, '6030015964', 25000, 'BANK OF AMERICA', 'Credit', 'Work Payment', '21/04/2021', '12:22', '', 'Successfull'),
(12, '6030015964', 2000, 'BANK OF AMERICA', 'Debit', 'Business', '2022-03-01 16:37:24.', '12:22', '', 'Successfull'),
(13, '5657441328', 10000, 'Jasper Hars', 'Credit', 'Business', '2022-01-25 16:37:24.', '12:22', '', 'Successfull'),
(14, '5657441328', 1000, 'Heldwill', 'Debit', 'Manager', '2022-02-25 16:37:24.', '1:22pm', '', 'Successfull'),
(15, '3722764203', 10000, 'Business', 'Credit', 'Business', '26/03/2022', '12:30', '', 'Successfull'),
(16, '8365334377', 700000, 'China Engineering', 'Credit', 'Payment for contract', '12/12/2022', '01:30', '', 'Successfull');

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

--
-- Table structure for table `bank_settings`
--

CREATE TABLE `bank_settings` (
  `id` int(255) NOT NULL,
  `bank_site_name` varchar(255) NOT NULL,
  `bank_site_domain` varchar(255) NOT NULL,
  `bank_site_email` varchar(255) NOT NULL,
  `bank_site_phone` varchar(255) NOT NULL,
  `bank_site_address` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bank_settings`
--

INSERT INTO `bank_settings` (`id`, `bank_site_name`, `bank_site_domain`, `bank_site_email`, `bank_site_phone`, `bank_site_address`) VALUES
(1, 'People\'s United (M&T)', 'http://peopleunitedb.com/us/USER_AUTH/', 'info@peopleunitedb.com', '', '850 Main Street Bridgeport, CT 06604');

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

--
-- Table structure for table `beneficiary`
--

CREATE TABLE `beneficiary` (
  `id` int(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `racc` varchar(255) NOT NULL,
  `rbank` varchar(255) NOT NULL,
  `rname` varchar(255) NOT NULL,
  `remail` varchar(255) NOT NULL,
  `rswift` varchar(255) NOT NULL,
  `iban` varchar(255) NOT NULL,
  `baddress` varchar(255) NOT NULL,
  `rcurrency` varchar(255) NOT NULL,
  `bdate` varchar(255) NOT NULL,
  `rtype` varchar(255) NOT NULL,
  `rcountry` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `beneficiary`
--

INSERT INTO `beneficiary` (`id`, `acc_no`, `email`, `racc`, `rbank`, `rname`, `remail`, `rswift`, `iban`, `baddress`, `rcurrency`, `bdate`, `rtype`, `rcountry`) VALUES
(7, '1028907812', 'digitalforestict@gmail.com', '4356756453', 'Eco Bank Plc', 'Emeka Okafor John', 'abcd@gmail.com', 'HSJD839289', '1192288288282882822', '102 Bida Road Awada', 'AFN', '02:10 PM 30 Aug 2021', 'DOMICILIARY ACCOUNT', 'Aruba'),
(9, '1028907812', 'digitalforestict@gmail.com', '2803839398`', 'HSBC Bank ', 'Chidimma Grace', 'chidimam@gmail.com', 'HYD3033', '10000939833', '102 Bida Road Awada Okpoko', 'BDT', '09:45 AM 13 Sep 2021', 'NON-Resident', 'Algeria'),
(10, '1028907812', 'digitalforestict@gmail.com', '373939393', 'Fcmb bank', 'Williams john', 'willams@gmail.com', 'Hdhdj73', '73939933933', '11 windy street', 'AUD', '11:55 AM 17 Sep 2021', 'DOMICILIARY ACCOUNT', 'Austria'),
(11, '1028907812', 'digitalforestict@gmail.com', '3546782', 'gtb', 'erick', 'ericemanuelries@gmail.com', 'hy4653', '6e7536077433', 'Av. AntÃ³nio Augusto de Aguiar 31 Piso -4,', 'XAG', '02:30 AM 24 Sep 2021', 'Savings', 'Portugal'),
(12, '', '', '10003839398`', 'HSBC Bank', 'Emeka John N', 'chidimam1212@gmail.com', 'HSJD811911', '122228828111111822', '102 Bida Road Awada Obosi', 'AUD', '01:20 PM 25 Sep 2021', 'Online Banking', 'Australia'),
(13, '8888762877', 'augustinesherman4@gmail.com', '18038393911', 'HSBC Bank', 'Emeke John N', 'chidimam12121@gmail.com', 'HSJD812232', '11922882800-9876', '102 Bida Road Awada Obosi', 'AUD', '01:25 PM 25 Sep 2021', 'Checking', 'Australia'),
(7, '1028907812', 'digitalforestict@gmail.com', '4356756453', 'Eco Bank Plc', 'Emeka Okafor John', 'abcd@gmail.com', 'HSJD839289', '1192288288282882822', '102 Bida Road Awada', 'AFN', '02:10 PM 30 Aug 2021', 'DOMICILIARY ACCOUNT', 'Aruba'),
(9, '1028907812', 'digitalforestict@gmail.com', '2803839398`', 'HSBC Bank ', 'Chidimma Grace', 'chidimam@gmail.com', 'HYD3033', '10000939833', '102 Bida Road Awada Okpoko', 'BDT', '09:45 AM 13 Sep 2021', 'NON-Resident', 'Algeria'),
(10, '1028907812', 'digitalforestict@gmail.com', '373939393', 'Fcmb bank', 'Williams john', 'willams@gmail.com', 'Hdhdj73', '73939933933', '11 windy street', 'AUD', '11:55 AM 17 Sep 2021', 'DOMICILIARY ACCOUNT', 'Austria'),
(11, '1028907812', 'digitalforestict@gmail.com', '3546782', 'gtb', 'erick', 'ericemanuelries@gmail.com', 'hy4653', '6e7536077433', 'Av. AntÃ³nio Augusto de Aguiar 31 Piso -4,', 'XAG', '02:30 AM 24 Sep 2021', 'Savings', 'Portugal'),
(12, '', '', '10003839398`', 'HSBC Bank', 'Emeka John N', 'chidimam1212@gmail.com', 'HSJD811911', '122228828111111822', '102 Bida Road Awada Obosi', 'AUD', '01:20 PM 25 Sep 2021', 'Online Banking', 'Australia'),
(13, '8888762877', 'augustinesherman4@gmail.com', '18038393911', 'HSBC Bank', 'Emeke John N', 'chidimam12121@gmail.com', 'HSJD812232', '11922882800-9876', '102 Bida Road Awada Obosi', 'AUD', '01:25 PM 25 Sep 2021', 'Checking', 'Australia');

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

--
-- Table structure for table `crypto`
--

CREATE TABLE `crypto` (
  `id` int(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `rwallet` varchar(255) NOT NULL,
  `swallet` varchar(255) NOT NULL,
  `amt` varchar(225) NOT NULL,
  `date` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `ref` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `crypto`
--

INSERT INTO `crypto` (`id`, `acc_no`, `email`, `rwallet`, `swallet`, `amt`, `date`, `status`, `ref`) VALUES
(1, '1028907812 ', 'digitalforestict@gmail.com ', 'REydd99eudjddjdjdjd', 'HJOPOIDGBHJOIDKPLOIJDUHHJIDKOPOI', '0.00076', '08:51 PM 26 Mar 2022', 'SUCCESS', '1130954838-750664285');

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

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` int(11) NOT NULL,
  `email_host` varchar(20) NOT NULL,
  `email_username` varchar(255) NOT NULL,
  `email_password` varchar(20) NOT NULL,
  `bank_name` varchar(20) NOT NULL,
  `sender_email` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `email_host`, `email_username`, `email_password`, `bank_name`, `sender_email`) VALUES
(1, 'buyscriptsdemo.work', 'banki_tech@buyscriptsdemo.work', '2020money@L', 'BANKI-TECH SOLUTION', 'info@buyscriptsdemo.work'),
(1, 'buyscriptsdemo.work', 'banki_tech@buyscriptsdemo.work', '2020money@L', 'BANKI-TECH SOLUTION', 'info@buyscriptsdemo.work');

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

--
-- Table structure for table `forgot_pass`
--

CREATE TABLE `forgot_pass` (
  `email` mediumtext NOT NULL,
  `token` varchar(9999) NOT NULL,
  `expiry` varchar(8999) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `forgot_pass`
--

INSERT INTO `forgot_pass` (`email`, `token`, `expiry`) VALUES
('raysid453773@qq.com', 'dc466e979fbadb1a76f3bcbb4ff5824c48276826', '2019-08-03 17:45:41'),
('raysid453773@qq.com', '8418226b19a5c874eb55ac5ba29df35e476600e8', '2019-08-03 17:45:45'),
('raysid453773@qq.com', '9263c2bcea46a0d5cbe4b6c9104a510b0436512d', '2019-08-03 17:47:27'),
('bhich@qe.luk2.com', '5366a1fc96bf0bfd5da34df0a16698b2a26b7404', '2019-08-03 17:48:03'),
('bhich@qe.luk2.com', 'dfd7e9a37772e1f7beec2ce077275c6fae44675f', '2019-08-03 18:17:32'),
('raysid453773@qq.com', 'dc466e979fbadb1a76f3bcbb4ff5824c48276826', '2019-08-03 17:45:41'),
('raysid453773@qq.com', '8418226b19a5c874eb55ac5ba29df35e476600e8', '2019-08-03 17:45:45'),
('raysid453773@qq.com', '9263c2bcea46a0d5cbe4b6c9104a510b0436512d', '2019-08-03 17:47:27'),
('bhich@qe.luk2.com', '5366a1fc96bf0bfd5da34df0a16698b2a26b7404', '2019-08-03 17:48:03'),
('bhich@qe.luk2.com', 'dfd7e9a37772e1f7beec2ce077275c6fae44675f', '2019-08-03 18:17:32');

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

--
-- Table structure for table `live_transfer`
--

CREATE TABLE `live_transfer` (
  `id` int(255) NOT NULL,
  `beneficiary_account_no` varchar(255) NOT NULL,
  `beneficiary_ifsc` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `live_transfer`
--

INSERT INTO `live_transfer` (`id`, `beneficiary_account_no`, `beneficiary_ifsc`, `amount`) VALUES
(1, '43', 'ED', '344'),
(2, '4356787654433', 'WEDSS34333', '2'),
(7, 'try', 'KKBK0004601', '2'),
(8, '1114458275', 'KKBK0004601', '2'),
(9, '40083294029', 'SBIN0012021', '2'),
(10, '063678100000171', 'YESB0000636', '2'),
(11, '10066587735', 'IDFC', '2'),
(12, '10062121418', 'IDFB0020106', '2'),
(13, '5556053000060218', 'SIBL0000405', '2'),
(1, '43', 'ED', '344'),
(2, '4356787654433', 'WEDSS34333', '2'),
(7, 'try', 'KKBK0004601', '2'),
(8, '1114458275', 'KKBK0004601', '2'),
(9, '40083294029', 'SBIN0012021', '2'),
(10, '063678100000171', 'YESB0000636', '2'),
(11, '10066587735', 'IDFC', '2'),
(12, '10062121418', 'IDFB0020106', '2'),
(13, '5556053000060218', 'SIBL0000405', '2');

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(10) NOT NULL,
  `sender_name` varchar(40) NOT NULL,
  `msg_no` varchar(255) NOT NULL,
  `reci_name` varchar(40) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `msg` varchar(2000) NOT NULL,
  `read` enum('unread','opened') DEFAULT 'unread',
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `sender_name`, `msg_no`, `reci_name`, `subject`, `msg`, `read`, `date`) VALUES
(1, 'Sender', '334', 'digitalforest', 'HELLO-Digital1', 'please this is a testing messages to your dashboard to confirm is this is working perfectly well.', 'unread', '2021-07-17 19:07:31'),
(2, 'Customer Care', '754', 'digitalforest', 'MY DOMAIN NOT PROPAGATING', 'Please sort out all email issues now.\r\nEnjoy up to two levels of income 40% transaction fee bonus for 1st tier referrals and 10% transaction fee bonus for 2nd tier referrals.', 'unread', '2021-07-17 19:15:41'),
(3, 'Service Department', '644', 'digitalforest', 'MY DOMAIN NOT PROPAGATING', 'please activate my domain', 'unread', '2021-08-30 20:51:42'),
(1, 'Sender', '334', 'digitalforest', 'HELLO-Digital1', 'please this is a testing messages to your dashboard to confirm is this is working perfectly well.', 'unread', '2021-07-17 19:07:31'),
(2, 'Customer Care', '754', 'digitalforest', 'MY DOMAIN NOT PROPAGATING', 'Please sort out all email issues now.\r\nEnjoy up to two levels of income 40% transaction fee bonus for 1st tier referrals and 10% transaction fee bonus for 2nd tier referrals.', 'unread', '2021-07-17 19:15:41'),
(3, 'Service Department', '644', 'digitalforest', 'MY DOMAIN NOT PROPAGATING', 'please activate my domain', 'unread', '2021-08-30 20:51:42');

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

--
-- Table structure for table `next_of_kin`
--

CREATE TABLE `next_of_kin` (
  `id` int(255) NOT NULL,
  `nname` varchar(255) NOT NULL,
  `nadd` varchar(255) NOT NULL,
  `nemail` varchar(255) NOT NULL,
  `nphone` varchar(255) NOT NULL,
  `bdate` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `next_of_kin`
--

INSERT INTO `next_of_kin` (`id`, `nname`, `nadd`, `nemail`, `nphone`, `bdate`, `acc_no`) VALUES
(3, 'Emeka chris', '112 obosi', 'Enake@gmail.com', '73839939393', '12:00 PM 17 Sep 2021', '1028907812'),
(4, 'Emeka Okafor Njoku', '102 Awada road nkpor', 'abcemeka@gmail.com', '19292992921', '01:37 PM 25 Sep 2021', '8888762877'),
(3, 'Emeka chris', '112 obosi', 'Enake@gmail.com', '73839939393', '12:00 PM 17 Sep 2021', '1028907812'),
(4, 'Emeka Okafor Njoku', '102 Awada road nkpor', 'abcemeka@gmail.com', '19292992921', '01:37 PM 25 Sep 2021', '8888762877');

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

--
-- Table structure for table `quick_loan`
--

CREATE TABLE `quick_loan` (
  `id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `loanamt` varchar(255) NOT NULL,
  `inter` varchar(255) NOT NULL,
  `dura` varchar(255) NOT NULL,
  `monthlypay` varchar(255) NOT NULL,
  `purpose` varchar(2550) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `quick_loan`
--

INSERT INTO `quick_loan` (`id`, `name`, `acc_no`, `email`, `loanamt`, `inter`, `dura`, `monthlypay`, `purpose`, `balance`, `status`, `date`) VALUES
(8, 'Augustine Sherman', '8888762877', 'augustinesherman4@gmail.com', '$1000', '0.00%', '0-6 months', 'USD0.00', 'help', '0.00', 'PENDING', '01:15 PM 25 Sep 2021'),
(9, 'Digital Team', '1028907812', 'digitalforestict@gmail.com', '15000', '0.00%', '24- 34 months', 'USD0.00', 'Business ', '0.00', 'PENDING', '11:24 AM 15 Nov 2021'),
(11, 'Digital Team', '1028907812', 'digitalforestict@gmail.com', '40000', '0.00%', '36 months', 'USD0.00', 'Fubd', '0.00', 'PENDING', '12:55 PM 14 Feb 2022'),
(8, 'Augustine Sherman', '8888762877', 'augustinesherman4@gmail.com', '$1000', '0.00%', '0-6 months', 'USD0.00', 'help', '0.00', 'PENDING', '01:15 PM 25 Sep 2021'),
(9, 'Digital Team', '1028907812', 'digitalforestict@gmail.com', '15000', '0.00%', '24- 34 months', 'USD0.00', 'Business ', '0.00', 'PENDING', '11:24 AM 15 Nov 2021'),
(11, 'Digital Team', '1028907812', 'digitalforestict@gmail.com', '40000', '0.00%', '36 months', 'USD0.00', 'Fubd', '0.00', 'PENDING', '12:55 PM 14 Feb 2022');

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

--
-- Table structure for table `security_question`
--

CREATE TABLE `security_question` (
  `id` int(255) NOT NULL,
  `ans1` varchar(255) NOT NULL,
  `ans2` varchar(255) NOT NULL,
  `sdate` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `security_question`
--

INSERT INTO `security_question` (`id`, `ans1`, `ans2`, `sdate`, `acc_no`) VALUES
(2, 'Honda Civic', 'Rose Royce Phantom', '08:29 AM 11 Jul 2021', '1028907812'),
(3, 'toyota', 'uniben', '11:04 AM 12 Jul 2021', '1028907812'),
(2, 'Honda Civic', 'Rose Royce Phantom', '08:29 AM 11 Jul 2021', '1028907812'),
(3, 'toyota', 'uniben', '11:04 AM 12 Jul 2021', '1028907812');

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

--
-- Table structure for table `s_account`
--

CREATE TABLE `s_account` (
  `id` int(255) NOT NULL,
  `macc_no` varchar(255) NOT NULL,
  `memail` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `s_type` varchar(255) NOT NULL,
  `s_currency` varchar(255) NOT NULL,
  `sacc_no` varchar(255) NOT NULL,
  `s_bal` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `s_account`
--

INSERT INTO `s_account` (`id`, `macc_no`, `memail`, `phone`, `s_type`, `s_currency`, `sacc_no`, `s_bal`) VALUES
(7, '1028907812', 'marykimps5@gmail.com', '07084669068', 'Beneficiary Account', 'ALL', '5586262027', '1000'),
(8, '', '', '', 'Domicilary Account', '$', '9480632668', '0.00'),
(7, '1028907812', 'marykimps5@gmail.com', '07084669068', 'Beneficiary Account', 'ALL', '5586262027', '1000'),
(8, '', '', '', 'Domicilary Account', '$', '9480632668', '0.00');

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

--
-- Table structure for table `temp_account`
--

CREATE TABLE `temp_account` (
  `id` int(10) NOT NULL,
  `upass` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `mname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `addr` varchar(100) NOT NULL,
  `work` varchar(100) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `reg_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `marry` varchar(20) NOT NULL,
  `currency` varchar(5) NOT NULL,
  `code` varchar(6) NOT NULL,
  `verify` enum('Y','N') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `temp_transfer`
--

CREATE TABLE `temp_transfer` (
  `id` int(100) NOT NULL,
  `email` varchar(40) DEFAULT NULL,
  `amount` varchar(20) DEFAULT NULL,
  `acc_no` varchar(300) NOT NULL,
  `acc_name` varchar(60) NOT NULL,
  `bank_name` varchar(40) NOT NULL,
  `swift` varchar(15) NOT NULL,
  `routing` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `remarks` text NOT NULL,
  `cout` varchar(1000) NOT NULL,
  `transtype` varchar(1000) NOT NULL,
  `date` timestamp(5) NOT NULL DEFAULT current_timestamp(5) ON UPDATE current_timestamp(5)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `temp_transfer`
--

INSERT INTO `temp_transfer` (`id`, `email`, `amount`, `acc_no`, `acc_name`, `bank_name`, `swift`, `routing`, `type`, `remarks`, `cout`, `transtype`, `date`) VALUES
(597, 'digitalforestict@gmail.com', '900', '987657897', 'Emeka Chalres', 'Eco Bank', 'SWE346', '5676543456', '', 'help', 'Australia', 'Wire', '2022-03-01 15:43:35.16984'),
(598, 'ryananthony2633@gmail.com', '4350', '700295659', 'Phou Jannie Volk', 'chase bank', 'CHASUS33', '021000021', '', 'Business', 'United States of America', 'Wire', '2022-03-02 01:24:27.02236'),
(599, 'ryananthony2633@gmail.com', '4300', '700295659', 'Phou Jannie Volk', 'Chase Bank', 'CHASUS33', '021000021', '', 'Business', 'United States of America', 'Wire', '2022-03-02 01:27:19.00714'),
(600, 'ryananthony2633@gmail.com', '191991', '3737374', 'gkethene', 'Bankk', 'uhetedee', '34323', '', 'reeee', 'Solomon Islands', 'Wire', '2022-03-02 10:42:38.74850'),
(601, 'ryananthony2633@gmail.com', '444444', '444333', '34fe', 'jeufdd', 'hejehdd', '999988', '', 'ffff', 'Benin', 'Wire', '2022-03-02 10:43:43.75596'),
(602, 'ryananthony2633@gmail.com', '33444454', '565444', 'dewded', 'drff', '33344', '4455', '', '44444', 'Barbados', 'Wire', '2022-03-02 10:50:25.60261'),
(603, 'rianheldwill20@gmail.com', '234334', '33444', '3dd', '33', 'BANK6228WAXS', 'cde', '', 'rrrer', 'Peoples Bank', 'Local Bank', '2022-03-02 20:49:53.12292'),
(604, 'rianheldwill20@gmail.com', '23443', '33333', '3333', '333', 'BANK6228WAXS', '333', '', '3333', 'Peoples Bank', 'Local Bank', '2022-03-02 20:51:01.00696'),
(605, 'rianheldwill20@gmail.com', '424', '422', '333', 'Peoples Bank', 'BANK6228WAXS', 'BANK6228WAXS', '', 'dddd', 'Peoples Bank', 'EFT MyBank', '2022-03-02 20:52:26.43480'),
(606, 'rianheldwill20@gmail.com', '44', '6666', '4444', 'Peoples Bank', 'BANK6228WAXS', 'BANK6228WAXS', '', '44', 'Peoples Bank', 'EFT MyBank', '2022-03-02 20:54:27.41059'),
(607, 'heldwillgaran@gmail.com', '10000', '97502568102', 'Ayhan bozkan', 'Kuveyt turk bank', 'Kteftrisxxx', '145511', '', 'Business', 'Turkey', 'Wire', '2022-03-26 12:52:24.36157'),
(608, 'heldwillgaran@gmail.com', '1110000', '222222222222222222', '33333', '3333333', '3333', '3333', '', '33333333', 'Austria', 'Wire', '2022-03-26 12:55:55.24849'),
(609, 'heldwillgaran@gmail.com', '100000', '97502568102', '97502568-102', 'Kuveyt turk bank', 'KTEFTRISXXX', '145511', '', 'Businsss', 'Turkey', 'Wire', '2022-03-26 12:57:38.63475'),
(610, 'osamahtarik@gmail.com', '2500', '003774627263', 'Jim Nuller', 'New York Community Bank', 'Stnmeghata', '29477296263', '', 'Business', 'Japan', 'Wire', '2022-03-31 20:51:46.10028'),
(611, 'digitalforestict@gmail.com', '500', '4567654', 'ecd', 'eco', '3456yghjh', '09:16 AM 01 Apr 2022', '', 'help', 'Algeria', 'Wire', '2022-04-01 09:16:27.42478'),
(612, 'digitalforestict@gmail.com', '599', '345676543', 'eds', 'wsdfghj', 'rfgthjk', '09:24 AM 01 Apr 2022', '', 'sdfgh', 'Armenia', 'Wire', '2022-04-01 09:24:35.80012'),
(613, 'digitalforestict@gmail.com', '123', '456787656', 'fgbhj', 'fghjk', 'rfgthyjk', '09:25 AM 01 Apr 2022', '', 'dfghj', 'Armenia', 'Wire', '2022-04-01 09:25:29.37395'),
(614, 'marcosheldwill@gmail.com', '300000', '5567344733', 'Chris Michael', 'TÃ¼rkiye Finans', 'AFKBTRISXXX\'dir', '11:33 AM 02 Nov 2022', '', 'Business', 'Sweden', 'Wire', '2022-11-02 15:36:38.89200'),
(615, 'marcosheldwill@gmail.com', '1000000', '38539341', 'Heldwill Hafe', 'May Financial Bank', 'AFKBTRISXXX', '11:37 AM 02 Nov 2022', '', 'Client', 'Latvia', 'Wire', '2022-11-02 15:38:36.05275'),
(616, 'marcosheldwill@gmail.com', '472020', '4045369672', 'Osamah - Tarik', 'Peoples Bank', 'BANK6228WAXS', '11:39 AM 02 Nov 2022', '', 'Business', 'Peoples Bank', 'EFT MyBank', '2022-11-02 15:39:52.93744'),
(617, 'marcosheldwill@gmail.com', '62798000', '8945275687', 'Alex - Wang', 'Peoples Bank', 'BANK6228WAXS', '11:40 AM 02 Nov 2022', '', 'Martials', 'Peoples Bank', 'EFT MyBank', '2022-11-02 15:41:07.74333'),
(618, 'marcosheldwill@gmail.com', '30000', '2197211195', 'Maxwell Donald - Goforth', 'Peoples Bank', 'BANK6228WAXS', '11:42 AM 02 Nov 2022', '', 'Business', 'Peoples Bank', 'EFT MyBank', '2022-11-02 15:42:49.62475'),
(619, 'marcosheldwill@gmail.com', '200000', '2197211195', 'Maxwell Donald - Goforth', 'Peoples Bank', 'BANK6228WAXS', '11:43 AM 02 Nov 2022', '', 'Business', 'Peoples Bank', 'EFT MyBank', '2022-11-02 15:44:08.43383'),
(620, 'marcosheldwill@gmail.com', '500000', '1028907812', 'Augustine - Sherman', 'Peoples Bank', 'BANK6228WAXS', '11:44 AM 02 Nov 2022', '', 'Business', 'Peoples Bank', 'EFT MyBank', '2022-11-02 15:45:01.00616'),
(621, 'marcosheldwill@gmail.com', '1200000', '7048332105', 'Hocus Polkus llc', 'Wells Fargo', 'WFBIUS6SXXX', '07:05 AM 04 Nov 2022', '', 'For Wilson Ford', 'United States of America', 'Wire', '2022-11-04 11:10:06.90702'),
(622, 'Luongdavid55@gmail.com', '35.000', '773857651', 'Henry Desmond', 'Chase Bank', 'BANK6228WAXS', '08:24 PM 06 Nov 2022', '', 'Property for clinic', 'Peoples Bank', 'Local Bank', '2022-11-07 01:31:52.64041'),
(623, 'tangineeequipment@aol.com', '10000', '375024342903', 'Amelia Wang', 'Bank of America', 'BANK6228WAXS', '03:46 AM 08 Nov 2022', '', 'For Bill', 'Peoples Bank', 'Local Bank', '2022-11-08 08:52:20.56150'),
(624, 'tangineeequipment@aol.com', '10000', '8870434490', 'Widiya Ariyana', 'Bank Central Asia', 'CENAIDJA', '03:55 AM 08 Nov 2022', '', 'Transfer fund', 'Indonesia', 'Wire', '2022-11-08 09:11:07.64026'),
(625, 'digitalforestict@gmail.com', '10', '877666', 'Eddy', 'GT', '63663', '01:14 PM 11 Nov 2022', '', 'Test', 'Anguilla', 'Wire', '2022-11-11 18:22:27.20890'),
(626, 'rosetteinal@gmail.com', '2649000', '8332290706', 'Guangzhou Lolo Commercial Trading Co., LTD', 'Community Federal Savings Bank', '026073008', '04:40 AM 15 Nov 2022', '', 'For medical materials payment', 'China', 'Wire', '2022-11-15 09:44:39.00753'),
(627, 'makishumble@gmail.com', '15000', '109450072', 'Gayypgeldi tajov', 'Peoples Bank', 'BANK6228WAXS', '07:44 AM 15 Nov 2022', '', 'Tool', 'Peoples Bank', 'EFT MyBank', '2022-11-15 12:49:37.94373'),
(628, 'makishumble66@gmail.com', '20000', '109450072', 'GAYYPGELDI TAJOV', 'Qnb Finansbank', 'TR43 0011 1000 ', '04:11 AM 22 Nov 2022', '', 'For taxes', 'Turkey', 'Wire', '2022-11-22 09:18:05.29926'),
(629, 'makishumble66@gmail.com', '20000', '109450072', 'GAYYPGELDI TAJOV', 'Qnb Finansbank', 'NMIBTZTZ', '04:24 AM 22 Nov 2022', '', 'For taxes', 'Turkey', 'Wire', '2022-11-22 09:31:33.00587'),
(630, 'makishumble@gmail.com', '10000', '1065545577', 'Baris Murat', 'Peoples Bank', 'BANK6228WAXS', '01:12 PM 24 Nov 2022', '', 'Money for your work from Emanuel Ragen', 'Peoples Bank', 'EFT MyBank', '2022-11-24 18:17:17.86517'),
(631, 'makishumble@gmail.com', '10000', '0519576546612426', 'Mehmet Omer', 'Peoples Bank', 'BANK6228WAXS', '01:30 PM 24 Nov 2022', '', 'Money for you work from Emanuel Regan', 'Peoples Bank', 'EFT MyBank', '2022-11-24 18:35:25.81887'),
(632, 'digitalforestict@gmail.com', '23', '654345676543', 'dffees dees', 'transd', '456543', '03:21 AM 30 Nov 2022', '', 'hgjh', 'Australia', 'Wire', '2022-11-30 08:33:15.38761'),
(633, 'Briggsellertson5@gmail.com', '600000', '192861810912811', 'Tianjin Equipment', 'Tianjin Equipment', 'BKCHCNBJ', '04:10 PM 01 Dec 2022', '', 'For materials', 'China', 'Wire', '2022-12-01 21:25:33.30811'),
(634, 'makishumble@gmail.com', '1550000', '52667556464', 'Hajg', 'Peoples Bank', 'BANK6228WAXS', '11:03 AM 13 Dec 2022', '', 'Tool', 'Peoples Bank', 'EFT MyBank', '2022-12-13 16:05:38.07626'),
(635, 'makishumble@gmail.com', '15.000', '109450072', 'GAYYPGELDI-TAJOV', 'Peoples Bank', 'BANK6228WAXS', '11:29 AM 13 Dec 2022', '', 'Payment for New machine', 'Peoples Bank', 'EFT MyBank', '2022-12-13 16:39:41.93089'),
(636, 'makishumble@gmail.com', '15.000', '109450072', 'GAYYPGELDI-TAJOV', 'Peoples Bank', 'BANK6228WAXS', '11:45 AM 13 Dec 2022', '', 'Payment for New machine', 'Peoples Bank', 'EFT MyBank', '2022-12-13 16:46:48.21350'),
(637, 'reganemmanuel929@gmail.com', '15000', '430011100000000109450072', 'Gayypgeldi Tajov', 'Peoples Bank', 'BANK6228WAXS', '07:10 PM 13 Dec 2022', '', 'Achat  de  materiel  en  Turquie', 'Peoples Bank', 'EFT MyBank', '2022-12-14 00:13:44.83909'),
(638, 'reganemmanuel929@gmail.com', '15000', '430011100000000109450072', 'Gayypgeldi Tajov', 'Peoples Bank', 'BANK6228WAXS', '07:15 PM 13 Dec 2022', '', 'paiement  matetien  en  Turquie', 'Peoples Bank', 'EFT MyBank', '2022-12-14 00:16:34.75345'),
(639, 'reganemmanuel929@gmail.com', '15000', '109450072', 'Gayypgeldi Tajov', 'Peoples Bank', 'BANK6228WAXS', '05:35 AM 14 Dec 2022', '', 'Paiement   achat  machine', 'Peoples Bank', 'EFT MyBank', '2022-12-14 10:37:51.69342'),
(640, 'reganemmanuel929@gmail.com', '15000', '109450072', 'Gayypgeldi Tajov', 'Peoples Bank', 'BANK6228WAXS', '05:50 AM 14 Dec 2022', '', 'Achat  machine', 'Peoples Bank', 'EFT MyBank', '2022-12-14 10:51:28.99526'),
(641, 'reganemmanuel929@gmail.com', '15000', '109450072', 'Gayypgeldi  Tajov', 'Peoples Bank', 'BANK6228WAXS', '06:06 AM 14 Dec 2022', '', 'Achat  machine', 'Peoples Bank', 'EFT MyBank', '2022-12-14 11:07:45.18447'),
(642, 'makishumble66@gmail.com', '24000', '321370765', 'Tax office usa', 'Peoples Bank', 'BANK6228WAXS', '10:08 AM 16 Dec 2022', '', 'Payment  for American  tax', 'Peoples Bank', 'EFT MyBank', '2022-12-16 15:10:50.02931'),
(643, 'makishumble66@gmail.com', '6666666', '66555555555', 'Trrrtf', 'Peoples Bank', 'BANK6228WAXS', '10:08 AM 16 Dec 2022', '', 'Hhggh', 'Peoples Bank', 'EFT MyBank', '2022-12-16 15:10:50.53724'),
(644, 'makishumble66@gmail.com', '24000', '8476171555', '321370765', 'Tax office  usa', 'GTBATRISXxx', '10:11 AM 16 Dec 2022', '', 'Payment  for American taxes', 'United States of America', 'Wire', '2022-12-16 15:16:19.80224'),
(645, 'reganemmanuel929@gmail.com', '15000', '0519576546612426', 'Mehmet Omer', 'Peoples Bank', 'BANK6228WAXS', '03:55 PM 18 Dec 2022', '', 'Salary', 'Peoples Bank', 'EFT MyBank', '2022-12-18 20:57:25.79359'),
(646, 'Geraldbenjamin0627@gmail.com', '25.000', '0062398', 'Akbank', 'MUHAMMED BEYTULLAD SÃœDÃœPEK', 'AKBKTRIS', '09:54 AM 27 Dec 2022', '', 'ekipman alÄ±mÄ± iÃ§in', 'Turkey', 'Wire', '2022-12-27 15:06:41.87086'),
(647, 'Geraldbenjamin0627@gmail.com', '30.000', '825909967045003', 'HASSAN SALLAN', 'Ziraat bank', 'TCZBTR2A', '02:57 PM 29 Dec 2022', '', 'Kismi Ã¶deme iÃ§in', 'Turkey', 'Wire', '2022-12-29 19:59:43.39884'),
(648, 'Branoarthur75@gmail.com', '50000', '825909967045003', 'Hassan Sallan', 'Ziraat bank', 'TCZBTR2A', '08:24 AM 13 Jan 2023', '', 'For the payment of Work done.', 'Turkey', 'Wire', '2023-01-13 13:34:31.05656'),
(649, 'makishumble66@gmail.com', '10000', '825909967045003', 'HASSAN KHALID', 'Peoples Bank', 'BANK6228WAXS', '07:12 AM 17 Jan 2023', '', 'DE LA FEMME (ANGELA) A EMMANUEL', 'Peoples Bank', 'EFT MyBank', '2023-01-17 12:14:07.82182'),
(650, 'makishumble66@gmail.com', '44444', '456556', 'Fffgggg', 'Peoples Bank', 'BANK6228WAXS', '07:26 PM 25 Jan 2023', '', 'H', 'Peoples Bank', 'EFT MyBank', '2023-01-26 00:27:03.90135'),
(651, 'makishumble66@gmail.com', '5566', '6654444555', 'Dffgggg', 'Peoples Bank', 'BANK6228WAXS', '07:42 PM 25 Jan 2023', '', 'Yygg', 'Peoples Bank', 'EFT MyBank', '2023-01-26 00:42:53.72943'),
(652, 'fawziaakbari07@gmail.com', '65500', '42034679673', 'Westwood  Building  Materials', 'CITIBANK', 'BANK6228WAXS', '06:12 PM 03 Feb 2023', '', 'Materials', 'Peoples Bank', 'Local Bank', '2023-02-03 23:14:03.47821'),
(653, 'digitalforestict@gmail.com', '50', '0056410161', 'Amos', 'Access Bank', '123', '04:11 PM 11 Feb 2023', '', 'Gh', 'Nigeria', 'Wire', '2023-02-11 21:12:49.86377');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `id` int(10) NOT NULL,
  `tc` int(10) NOT NULL,
  `sender_name` varchar(40) NOT NULL,
  `mail` varchar(40) DEFAULT NULL,
  `subject` varchar(100) NOT NULL,
  `msg` varchar(1000) NOT NULL,
  `status` enum('Pending','Replied') DEFAULT 'Pending',
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`id`, `tc`, `sender_name`, `mail`, `subject`, `msg`, `status`, `date`) VALUES
(46, 99568, 'UBA', NULL, 'TESTIN LOAN', 'TESTIN LOAN', 'Pending', '2019-11-13 04:55:56'),
(68, 27954, 'Digital', NULL, 'Customer Rapid Billing', 'Tran', 'Pending', '2021-08-31 09:13:25'),
(69, 56319, 'Digital', NULL, 'Customer Rapid Billing', 'Th', 'Pending', '2021-08-31 09:14:41'),
(70, 23309, 'Digital', NULL, 'ju', 'olpo', 'Pending', '2021-09-01 17:20:34'),
(71, 92921, 'Digital', NULL, 'Customer Rapid Billing', 'Gg', 'Pending', '2021-09-02 12:12:42'),
(72, 37339, 'Digital', NULL, 'Account activation', 'Please activate my account', 'Pending', '2021-09-17 12:03:29'),
(73, 92840, 'Augustine', NULL, 'PLEASE ACTIVATE THE DOMAIN', 'please work on my request', 'Pending', '2021-09-25 13:39:18'),
(74, 74416, 'Digital', NULL, 'test', 'good', 'Pending', '2021-11-07 04:12:16'),
(75, 46273, 'Digital', NULL, 'Customer BTC Billing', 'tes b', 'Pending', '2021-11-07 04:13:58'),
(76, 84992, 'Digital', NULL, 'Quick Deposit Notification', 'Teyhege', 'Pending', '2021-11-16 18:09:40'),
(77, 38303, 'Digital', NULL, 'Bank Deposit Notification', 'Business', 'Pending', '2021-11-16 18:11:19'),
(78, 84775, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:08'),
(79, 31613, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:16'),
(80, 13675, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:17'),
(81, 5337, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:28'),
(82, 39183, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:38'),
(83, 24320, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:44'),
(84, 41712, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:55'),
(85, 56539, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:55'),
(86, 68879, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:56'),
(87, 32225, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:56'),
(88, 71138, 'Digital', NULL, 'BTC Deposit Notification', 'JANES', 'Pending', '2021-12-14 01:02:52'),
(89, 60094, 'Digital', NULL, 'Quick Deposit Notification', 'WELLS FARGO', 'Pending', '2021-12-14 01:04:30'),
(90, 61916, 'Digital', NULL, 'Hi', 'Ueueheh', 'Pending', '2021-12-23 20:52:55'),
(91, 36651, 'Digital', NULL, 'hi', 'hi', 'Pending', '2022-01-08 13:02:28'),
(92, 10708, 'Digital', NULL, 'BTC Deposit Notification', 'Segh', 'Pending', '2022-01-30 07:43:50'),
(93, 30054, 'Digital', NULL, 'Quick Deposit Notification', 'western union', 'Pending', '2022-02-01 11:00:57'),
(94, 60165, 'Digital', NULL, 'BTC Deposit Notification', '88', 'Pending', '2022-02-23 16:39:44'),
(46, 99568, 'UBA', NULL, 'TESTIN LOAN', 'TESTIN LOAN', 'Pending', '2019-11-13 04:55:56'),
(68, 27954, 'Digital', NULL, 'Customer Rapid Billing', 'Tran', 'Pending', '2021-08-31 09:13:25'),
(69, 56319, 'Digital', NULL, 'Customer Rapid Billing', 'Th', 'Pending', '2021-08-31 09:14:41'),
(70, 23309, 'Digital', NULL, 'ju', 'olpo', 'Pending', '2021-09-01 17:20:34'),
(71, 92921, 'Digital', NULL, 'Customer Rapid Billing', 'Gg', 'Pending', '2021-09-02 12:12:42'),
(72, 37339, 'Digital', NULL, 'Account activation', 'Please activate my account', 'Pending', '2021-09-17 12:03:29'),
(73, 92840, 'Augustine', NULL, 'PLEASE ACTIVATE THE DOMAIN', 'please work on my request', 'Pending', '2021-09-25 13:39:18'),
(74, 74416, 'Digital', NULL, 'test', 'good', 'Pending', '2021-11-07 04:12:16'),
(75, 46273, 'Digital', NULL, 'Customer BTC Billing', 'tes b', 'Pending', '2021-11-07 04:13:58'),
(76, 84992, 'Digital', NULL, 'Quick Deposit Notification', 'Teyhege', 'Pending', '2021-11-16 18:09:40'),
(77, 38303, 'Digital', NULL, 'Bank Deposit Notification', 'Business', 'Pending', '2021-11-16 18:11:19'),
(78, 84775, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:08'),
(79, 31613, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:16'),
(80, 13675, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:17'),
(81, 5337, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:28'),
(82, 39183, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:38'),
(83, 24320, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:44'),
(84, 41712, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:55'),
(85, 56539, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:55'),
(86, 68879, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:56'),
(87, 32225, 'Digital', NULL, 'Bank Deposit Notification', 'Genesis', 'Pending', '2021-12-13 20:09:56'),
(88, 71138, 'Digital', NULL, 'BTC Deposit Notification', 'JANES', 'Pending', '2021-12-14 01:02:52'),
(89, 60094, 'Digital', NULL, 'Quick Deposit Notification', 'WELLS FARGO', 'Pending', '2021-12-14 01:04:30'),
(90, 61916, 'Digital', NULL, 'Hi', 'Ueueheh', 'Pending', '2021-12-23 20:52:55'),
(91, 36651, 'Digital', NULL, 'hi', 'hi', 'Pending', '2022-01-08 13:02:28'),
(92, 10708, 'Digital', NULL, 'BTC Deposit Notification', 'Segh', 'Pending', '2022-01-30 07:43:50'),
(93, 30054, 'Digital', NULL, 'Quick Deposit Notification', 'western union', 'Pending', '2022-02-01 11:00:57'),
(94, 60165, 'Digital', NULL, 'BTC Deposit Notification', '88', 'Pending', '2022-02-23 16:39:44'),
(0, 12959, 'Heldwill', NULL, 'BTC Deposit Notification', 'business', 'Pending', '2022-03-26 21:53:45');

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

--
-- Table structure for table `transfer`
--

CREATE TABLE `transfer` (
  `id` int(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `transtype` varchar(255) NOT NULL,
  `acc_no` varchar(225) NOT NULL,
  `type` int(255) NOT NULL,
  `swift` varchar(255) NOT NULL,
  `routing` varchar(255) NOT NULL,
  `remarks` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` enum('Pending','Successful','Cancel','ON-Hold') NOT NULL DEFAULT 'Successful',
  `date` varchar(255) NOT NULL,
  `cout` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transfer`
--

INSERT INTO `transfer` (`id`, `amount`, `bank_name`, `acc_name`, `transtype`, `acc_no`, `type`, `swift`, `routing`, `remarks`, `email`, `status`, `date`, `cout`) VALUES
(1, '4300', 'Chase Bank', 'Phou Jannie Volk', 'Wire', '700295659', 0, 'CHASUS33', '021000021', 'Business', 'ryananthony2633@gmail.com', 'Successful', '2022-03-01 16:37:24.75185', 'United States of America'),
(2, '100000', 'Kuveyt turk bank', '97502568-102', 'Wire', '97502568102', 0, 'KTEFTRISXXX', '01/01/2022 16:15', 'Businsss', 'marcosheldwill@gmail.com', 'Successful', '26/07/2022', 'Turkey'),
(3, '2500', 'New York Community Bank', 'Jim Nuller', 'Wire', '003774627263', 0, 'Stnmeghata', '29477296263', 'Business', 'osamahtarik@gmail.com', 'Successful', '31/03/2021', 'Japan'),
(4, '500', 'eco', 'ecd', 'Wire', '4567654', 0, '3456yghjh', '09:16 AM 01 Apr 2012', 'help', 'digitalforestict@gmail.com', 'Pending', '09:16 AM 01 Apr 2020', 'Algeria'),
(5, '123', 'fghjk', 'fgbhj', 'Wire', '456787656', 0, 'rfgthyjk', '09:25 AM 01 Apr 2022', 'dfghj', 'digitalforestict@gmail.com', 'Successful', '', 'Armenia'),
(6, '300000', 'TÃ¼rkiye Finans', 'Chris Michael', 'Wire', '5567344733', 0, 'AFKBTRISXXX\'dir', '01/02/2022 14:32', 'Business', 'marcosheldwill@gmail.com', 'Successful', '26/05/2021  15:23', 'Sweden'),
(7, '1000000', 'May Financial Bank', 'Heldwill Hafe', 'Wire', '38539341', 0, 'AFKBTRISXXX', '10/04/2022 17:32', 'Client', 'marcosheldwill@gmail.com', 'Successful', '31/10/2022', 'Latvia'),
(8, '472020', 'Peoples Bank', 'Osamah - Tarik', 'EFT MyBank', '4045369672', 0, 'BANK6228WAXS', '01/05/2022 01:00', 'Business', 'marcosheldwill@gmail.com', 'Successful', '10/08/2022', 'Peoples Bank'),
(9, '30000', 'Peoples Bank', 'Maxwell Donald - Goforth', 'EFT MyBank', '2197211195', 0, 'BANK6228WAXS', '11/06/2022 02:55', 'Business', 'marcosheldwill@gmail.com', 'Successful', '11/07/2022', 'Peoples Bank'),
(10, '200000', 'Peoples Bank', 'Maxwell Donald - Goforth', 'EFT MyBank', '2197211195', 0, 'BANK6228WAXS', '01/10/2022 07:01', 'Business', 'marcosheldwill@gmail.com', 'Successful', '26/04/2022', 'Peoples Bank'),
(11, '200000', 'Peoples Bank', 'Maxwell Donald - Goforth', 'EFT MyBank', '2197211195', 0, 'BANK6228WAXS', '01/07/2022 14:32', 'Business', 'marcosheldwill@gmail.com', 'Successful', '02/03/2022', 'Peoples Bank'),
(12, '500000', 'Peoples Bank', 'Augustine - Sherman', 'EFT MyBank', '1028907812', 0, 'BANK6228WAXS', '01/08/2022 14:32', 'Business', 'marcosheldwill@gmail.com', 'Successful', '01/01/2021 14:32', 'Peoples Bank'),
(13, '1200000', 'Wells Fargo', 'Hocus Polkus llc', 'Wire', '7048332105', 0, 'WFBIUS6SXXX', '07:05 AM 04 Nov 2022', 'For Wilson Ford', 'marcosheldwill@gmail.com', 'Successful', '', 'United States of America'),
(14, '35.000', 'Chase Bank', 'Henry Desmond', 'Local Bank', '773857651', 0, 'BANK6228WAXS', '08:24 PM 06 Nov 2022', 'Property for clinic', 'Luongdavid55@gmail.com', 'Successful', '', 'Peoples Bank'),
(15, '10000', 'Bank of America', 'Amelia Wang', 'Local Bank', '375024342903', 0, 'BANK6228WAXS', '03:46 AM 08 Nov 2022', 'For Bill', 'tangineeequipment@aol.com', 'Successful', '', 'Peoples Bank'),
(16, '10', 'GT', 'Eddy', 'Wire', '877666', 0, '63663', '01:14 PM 11 Nov 2022', 'Test', 'digitalforestict@gmail.com', 'Successful', '', 'Anguilla'),
(17, '2649000', 'Community Federal Savings Bank', 'Guangzhou Lolo Commercial Trading Co., LTD', 'Wire', '8332290706', 0, '026073008', '04:40 AM 15 Nov 2022', 'For medical materials payment', 'rosetteinal@gmail.com', 'Successful', '', 'China'),
(18, '15000', 'Peoples Bank', 'Gayypgeldi tajov', 'EFT MyBank', '109450072', 0, 'BANK6228WAXS', '07:44 AM 15 Nov 2022', 'Tool', 'makishumble@gmail.com', 'Successful', '', 'Peoples Bank'),
(19, '20000', 'Qnb Finansbank', 'GAYYPGELDI TAJOV', 'Wire', '109450072', 0, 'NMIBTZTZ', '04:24 AM 22 Nov 2022', 'For taxes', 'makishumble66@gmail.com', 'Successful', '', 'Turkey'),
(20, '10000', 'Peoples Bank', 'Baris Murat', 'EFT MyBank', '1065545577', 0, 'BANK6228WAXS', '01:12 PM 24 Nov 2022', 'Money for your work from Emanuel Ragen', 'makishumble@gmail.com', 'Successful', '', 'Peoples Bank'),
(21, '10000', 'Peoples Bank', 'Mehmet Omer', 'EFT MyBank', '0519576546612426', 0, 'BANK6228WAXS', '01:30 PM 24 Nov 2022', 'Money for you work from Emanuel Regan', 'makishumble@gmail.com', 'Successful', '', 'Peoples Bank'),
(22, '23', 'transd', 'dffees dees', 'Wire', '654345676543', 0, '456543', '03:21 AM 30 Nov 2022', 'hgjh', 'digitalforestict@gmail.com', 'Successful', '', 'Australia'),
(23, '600000', 'Tianjin Equipment', 'Tianjin Equipment', 'Wire', '192861810912811', 0, 'BKCHCNBJ', '04:10 PM 01 Dec 2022', 'For materials', 'Briggsellertson5@gmail.com', 'Successful', '', 'China'),
(24, '1550000', 'Peoples Bank', 'Hajg', 'EFT MyBank', '52667556464', 0, 'BANK6228WAXS', '11:03 AM 13 Dec 2022', 'Tool', 'makishumble@gmail.com', 'Successful', '', 'Peoples Bank'),
(25, '15.000', 'Peoples Bank', 'GAYYPGELDI-TAJOV', 'EFT MyBank', '109450072', 0, 'BANK6228WAXS', '11:45 AM 13 Dec 2022', 'Payment for New machine', 'makishumble@gmail.com', 'Successful', '', 'Peoples Bank'),
(26, '15000', 'Peoples Bank', 'Gayypgeldi  Tajov', 'EFT MyBank', '109450072', 0, 'BANK6228WAXS', '06:06 AM 14 Dec 2022', 'Achat  machine', 'reganemmanuel929@gmail.com', 'Successful', '', 'Peoples Bank'),
(27, '24000', 'Tax office  usa', '321370765', 'Wire', '8476171555', 0, 'GTBATRISXxx', '10:11 AM 16 Dec 2022', 'Payment  for American taxes', 'makishumble66@gmail.com', 'Successful', '', 'United States of America'),
(28, '15000', 'Peoples Bank', 'Mehmet Omer', 'EFT MyBank', '0519576546612426', 0, 'BANK6228WAXS', '03:55 PM 18 Dec 2022', 'Salary', 'reganemmanuel929@gmail.com', 'Successful', '', 'Peoples Bank'),
(29, '25.000', 'MUHAMMED BEYTULLAD SÃœDÃœPEK', 'Akbank', 'Wire', '0062398', 0, 'AKBKTRIS', '09:54 AM 27 Dec 2022', 'ekipman alÄ±mÄ± iÃ§in', 'Geraldbenjamin0627@gmail.com', 'Successful', '', 'Turkey'),
(30, '30.000', 'Ziraat bank', 'HASSAN SALLAN', 'Wire', '825909967045003', 0, 'TCZBTR2A', '02:57 PM 29 Dec 2022', 'Kismi Ã¶deme iÃ§in', 'Geraldbenjamin0627@gmail.com', 'Successful', '', 'Turkey'),
(31, '50000', 'Ziraat bank', 'Hassan Sallan', 'Wire', '825909967045003', 0, 'TCZBTR2A', '08:24 AM 13 Jan 2023', 'For the payment of Work done.', 'Branoarthur75@gmail.com', 'Successful', '', 'Turkey'),
(32, '10000', 'Peoples Bank', 'HASSAN KHALID', 'EFT MyBank', '825909967045003', 0, 'BANK6228WAXS', '07:12 AM 17 Jan 2023', 'DE LA FEMME (ANGELA) A EMMANUEL', 'makishumble66@gmail.com', 'Successful', '', 'Peoples Bank'),
(33, '65500', 'CITIBANK', 'Westwood  Building  Materials', 'Local Bank', '42034679673', 0, 'BANK6228WAXS', '06:12 PM 03 Feb 2023', 'Materials', 'fawziaakbari07@gmail.com', 'Successful', '', 'Peoples Bank');

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

--
-- Table structure for table `virtual_card`
--

CREATE TABLE `virtual_card` (
  `id` int(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `card_no` varchar(255) NOT NULL,
  `exp` varchar(255) NOT NULL,
  `cvv` varchar(255) NOT NULL,
  `card_type` varchar(255) NOT NULL,
  `card_status` varchar(255) NOT NULL,
  `card_bal` varchar(255) NOT NULL,
  `card_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `virtual_card`
--

INSERT INTO `virtual_card` (`id`, `acc_no`, `name`, `email`, `card_no`, `exp`, `cvv`, `card_type`, `card_status`, `card_bal`, `card_date`) VALUES
(23, '1028907812', 'Digital Forest', 'digitalforestict@gmail.com', '5310 2029 2728 2781', '10/24', '769', 'Visa Card', 'INACTIVE', '9000', '01:13 PM 25 Sep 2021'),
(23, '1028907812', 'Digital Forest', 'digitalforestict@gmail.com', '5310 2029 2728 2781', '10/24', '769', 'Visa Card', 'INACTIVE', '9000', '01:13 PM 25 Sep 2021');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `alerts`
--
ALTER TABLE `alerts`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `bank_settings`
--
ALTER TABLE `bank_settings`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `crypto`
--
ALTER TABLE `crypto`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `temp_transfer`
--
ALTER TABLE `temp_transfer`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=654;

--
-- AUTO_INCREMENT for table `transfer`
--
ALTER TABLE `transfer`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
