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

START TRANSACTION;



--
-- Database: `tooluyli_nationall`
--

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

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

CREATE TABLE `admin` (
  `id` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'Superadmin', 'BossBoss');

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

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` int(11) NOT NULL,
  `first` varchar(255) NOT NULL,
  `last` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `cpass` varchar(255) NOT NULL,
  `ques` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  `ques2` varchar(255) NOT NULL,
  `ans2` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `date2` varchar(255) NOT NULL,
  `a_number` varchar(255) NOT NULL,
  `x_number` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL,
  `taxcode` varchar(255) NOT NULL,
  `revenuecode` varchar(255) NOT NULL,
  `cot` varchar(255) NOT NULL,
  `pin` varchar(255) NOT NULL,
  `dormat` varchar(255) NOT NULL,
  `suspend` varchar(255) NOT NULL,
  `activate` varchar(255) NOT NULL,
  `delet` int(255) NOT NULL,
  `middle_name` varchar(255) NOT NULL,
  `n_of_kin` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `ssn` varchar(255) NOT NULL,
  `m_name` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `routine` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `credit` varchar(255) NOT NULL,
  `debit` varchar(255) NOT NULL,
  `purpose` varchar(255) NOT NULL,
  `freeze` varchar(255) NOT NULL,
  `deleted` varchar(255) NOT NULL,
  `date1` varchar(255) NOT NULL,
  `date3` varchar(255) NOT NULL,
  `date4` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `mpurpose` varchar(255) NOT NULL,
  `otp` varchar(255) NOT NULL,
  `savings` varchar(255) NOT NULL,
  `ira` varchar(255) NOT NULL,
  `act_otp` varchar(255) NOT NULL,
  `act_code` varchar(255) NOT NULL,
  `loan` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `client`
--

INSERT INTO `client` (`id`, `first`, `last`, `username`, `email`, `pass`, `cpass`, `ques`, `ans`, `ques2`, `ans2`, `date`, `date2`, `a_number`, `x_number`, `balance`, `taxcode`, `revenuecode`, `cot`, `pin`, `dormat`, `suspend`, `activate`, `delet`, `middle_name`, `n_of_kin`, `phone_number`, `ssn`, `m_name`, `country`, `state`, `address`, `routine`, `dob`, `credit`, `debit`, `purpose`, `freeze`, `deleted`, `date1`, `date3`, `date4`, `time`, `mpurpose`, `otp`, `savings`, `ira`, `act_otp`, `act_code`, `loan`) VALUES
(1, 'David', 'Austing', 'alayonimi', 'Test@gmail.com', '123456', '', '', '', '', '', '08/02/2024', '', '1503636029', '', '41500', '1111', '', '', '1234', '', '', '', 0, 'money', '', '+2347011357409', '', '', 'Nigeria', 'Ondo', '1 Oluwatuyi street', '', '10/10/1976', '', '', '', '', '', '', '', '', '', '', '', '8000', '100000', '', 'YES', 1),
(2, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '08/02/2024', '', '50000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '50000', '', 'Transfer', '', '', '', '', '12/09/2022', '12:18:26', '', '', '', '', '', '', 1),
(3, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '51500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '1500', '', 'GSK', '', '', '', '', '12/11/2022', '12:39:59', '', '', '', '', '', '', 1),
(4, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '50500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '1000', 'Payment', '', '', '', '', '17/12/2022', '12:41:01', '', '', '', '', '', '', 1),
(5, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '46500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '4000', 'Cryptocurrency', '', '', '', '', '22/01/2023', '12:42:13', '', '', '', '', '', '', 1),
(116, 'Hshshs', 'Gshshs', 'Hsshs', 'hshshshs@gmail.com', 'okok22', '', '', '', '', '', '20/05/2024', '', '9236650130', '', '', '', '', '', '1111', '', '', '', 0, 'Hshshsh', '', '9045778987', '', '', 'Us', 'Florida', 'Habsbsbs', '', '01-25-2000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0),
(115, 'Atilla', 'Gardiner', 'AtillaG', 'tooofficial2x@gmail.cln', 'highflyer456', '', '', '', '', '', '20/05/2024', '', '2900135366', '', '', '', '', '', '1111', '', '', '', 0, 'Gerard', '', '9046441570', '', '', 'USA', 'Florida', 'Fggg', '', '03/17/2003', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0),
(114, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '59748', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '485980', 'Transfer', '', '', '', '', '12/11/2023', '01:28:39', '', '', '', '', '', '', 1),
(113, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '545728', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '90000', '', 'Payment', '', '', '', '', '20/10/2023', '01:27:46', '', '', '', '', '', '', 1),
(112, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '455728', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '50666', 'Transfer', '', '', '', '', '19/08/2023', '01:27:04', '', '', '', '', '', '', 1),
(109, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '370639', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '135755', 'Transfer', '', '', '', '', '19/06/2023', '01:22:42', '', '', '', '', '', '', 1),
(108, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '445827', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '70000', '', 'Payment', '', '', '', '', '12/03/2023', '01:22:07', '', '', '', '', '', '', 1),
(107, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '375827', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '150000', '', 'Transfer', '', '', '', '', '11/01/2023', '01:21:14', '', '', '', '', '', '', 1),
(106, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '225827', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '280567', 'Payment', '', '', '', '', '21/12/2022', '01:20:02', '', '', '', '', '', '', 1),
(105, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '416394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '90000', 'Transfer', '', '', '', '', '12/09/2021', '01:17:22', '', '', '', '', '', '', 1),
(103, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '456394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '50000', 'Transfer', '', '', '', '', '22/02/2021', '01:16:03', '', '', '', '', '', '', 1),
(102, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '232910', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '176960', '', 'Contract', '', '', '', '', '22/08/2020', '01:15:03', '', '', '', '', '', '', 1),
(101, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '55950', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '450444', 'Contract', '', '', '', '', '23/04/2020', '01:13:47', '', '', '', '', '', '', 1),
(99, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '467694', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '38700', 'Contract', '', '', '', '', '24/10/2019', '01:10:02', '', '', '', '', '', '', 1),
(100, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '517694', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '50000', '', 'Transfer', '', '', '', '', '10/01/2020', '01:12:54', '', '', '', '', '', '', 1),
(97, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '416394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '90000', 'Contract', '', '', '', '', '12/09/2019', '01:02:46', '', '', '', '', '', '', 1),
(96, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '506394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '980000', '', 'Reverse', '', '', '', '', '31/01/2019', '12:56:57', '', '', '', '', '', '', 1),
(95, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '-473606', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '980000', 'Transfer', '', '', '', '', '31/01/2019', '12:56:02', '', '', '', '', '', '', 1),
(93, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1156394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '350000', 'Transfer', '', '', '', '', '12/11/2018', '12:49:48', '', '', '', '', '', '', 1),
(92, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '545694', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '960700', 'Payment', '', '', '', '', '12/08/2018', '12:43:52', '', '', '', '', '', '', 1),
(91, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1615299', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '90000', '', 'Payment', '', '', '', '', '22/07/2018', '12:41:27', '', '', '', '', '', '', 1),
(90, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1525299', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '18905', '', 'Contract', '', '', '', '', '12/02/2018', '11:54:04', '', '', '', '', '', '', 1),
(94, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1157894', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '1500', '', 'Payment', '', '', '', '', '19/12/2018', '12:53:09', '', '', '', '', '', '', 1),
(36, 'Wilson', 'P', 'wilsonbradP01', 'support@unpracticians.com', 'Wilsonman', '', '', '', '', '', '02/03/2024', '02/03/2024', '1039562063', '', '135800', '', '', '', '2345', '', '', '', 0, 'Brad', '', '+1', '', '', 'USA', 'Maryland', '78', '', '10/10/1976', '', '', '', '', '', '', '', '', '', '', '', '', '', 'YES', '', 0),
(37, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '135600', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135600', '', 'Transfer', '', '', '', '', '12/01/2023', '06:49:23', '', '', '', '', '', '', 0),
(39, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '271350', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135750', '', 'Transfer', '', '', '', '', '22/04/2023', '07:15:56', '', '', '', '', '', '', 0),
(40, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '406959', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135609', '', 'Transfer', '', '', '', '', '12/05/2023', '07:16:21', '', '', '', '', '', '', 0),
(41, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '542656', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135697', '', 'Transfer', '', '', '', '', '12/07/2023', '07:16:56', '', '', '', '', '', '', 0),
(42, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '678350', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135694', '', 'Transfer', '', '', '', '', '12/11/2023', '07:17:18', '', '', '', '', '', '', 0),
(43, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '02/03/2024', '', '50', '135750', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '678300', 'Payment', '', '', '', '', '30/11/2023', '07:18:19', '', '', '', '', '', '', 0),
(44, '', '', 'wilsonbradP01', '', '', '', '', '', '', '', '', '', '', '135800', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135750', '', 'Transfer', '', '', '', '', '12/01/2024', '07:22:04', '', '', '', '', '', '', 0),
(45, 'Annah', 'Melissa', 'Downingann', 'downingannah@gmail.com', 'Downing0909', '', '', '', '', '', '29/03/2024', '', '6610092353', '', '153902', '', '', '', '0909', '', '', '', 0, 'Downing', '', '07011357409', '', '', 'USA', 'California', 'San francesco', '', '10/10/1976', '', '', '', '', '', '', '', '', '', '', '', '', '', 'YES', '', 0),
(46, '', '', 'Downingann', '', '', '', '', '', '', '', '', '29/03/2024', '', '153902', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '153902', '', 'Transfer', '', '', '', '', '12/11/2023', '02:58:54', '', '', '', '', '', '', 0),
(47, 'Karen', 'Turner', 'Karenstocks23', 'bewitcyborg@gmail.com', 'Christopher2563', '', '', '', '', '', '15/04/2024', '', '5390136062', '', '631500', '', '', '', '2313', '', '', '', 0, 'Joy', '', '3235465018', '', '', 'United States', 'Illinois', '1641 Jones street', '', '12-23-1975', '', '', '', '', '', '', '', '', '', '', '', '', '', 'YES', '', 0),
(48, '', '', 'Karenstocks23', '', '', '', '', '', '', '', '', '15/04/2024', '', '1500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '1500', '', 'Initial Deposit ', '', '', '', '', '04/15/2024', '08:55:19', '', '', '', '', '', '', 0),
(49, '', '', 'Karenstocks23', '', '', '', '', '', '', '', '', '', '', '751500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '750000', '', 'Check deposited ', '', '', '', '', '04/15/2024', '09:12:10', '', '', '', '', '', '', 0),
(50, '', '', 'Karenstocks23', '', '', '', '', '', '', '', '', '', '', '631500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '120000', 'Transfer', '', '', '', '', '16/04/2024', '10:08:40', '', '', '', '', '', '', 0),
(51, 'Nicholas', 'Nick', 'Nicholasjohnedw', 'nicholaslongell241@gmail.com', 'Nora4565', '', '', '', '', '', '19/04/2024', '', '0605632391', '', '8725021', '', '', '', '2313', '', '', '', 0, 'John', '', '', '', '', 'United States', 'Illinois', '1641 Jones street', '', '23/12/1975', '', '', '', '', '', '', '', '', '', '', '', '', '850750', 'YES', '', 0),
(52, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '19/04/2024', '', '150000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '150000', '', 'Deposit ', '', '', '', '', '01/05/2024', '03:32:04', '', '', '', '', '', '', 0),
(67, 'Nicholas', 'Longell', 'Nicholasjohnedww', 'ajayiolasunkanmi83@gmail.com', 'Emmanuel', '', '', '', '', '', '22/04/2024', '', '2330965061', '', '', '', '', '', '2002', '', '', '', 0, 'Lorey', '', '08131589011', '', '', 'United state', 'Wisconsin', 'Wisconsin', '', '43', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0),
(53, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '600000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '450000', '', 'Check deposit/7992749', '', '', '', '', '01/09/2024', '03:32:47', '', '', '', '', '', '', 0),
(54, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '549950', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '50050', 'Debit/Trf68736&', '', '', '', '', '01/15/2024', '03:33:46', '', '', '', '', '', '', 0),
(55, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '1250604', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '700654', '', 'Zion group Inc', '', '', '', '', '01/22/2024', '03:34:55', '', '', '', '', '', '', 0),
(56, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '1331104', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '80500', '', 'Xiongteam ltd', '', '', '', '', '01/27/2024', '03:35:50', '', '', '', '', '', '', 0),
(57, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '1330048', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '1056', 'British Air', '', '', '', '', '02/04/2024', '03:38:23', '', '', '', '', '', '', 0),
(58, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '1328048', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '2000', 'Debit/6508764', '', '', '', '', '02/09/2024', '03:39:45', '', '', '', '', '', '', 0),
(59, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '2128548', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '800500', '', 'Bitcoin mining', '', '', '', '', '02/15/2024', '03:40:34', '', '', '', '', '', '', 0),
(60, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '2123498', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '5050', 'Atm/debit 572972', '', '', '', '', '02/19/2024', '03:42:01', '', '', '', '', '', '', 0),
(61, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '4130293', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '2006795', '', 'Cr/7973783', '', '', '', '', '02/25/2024', '03:45:39', '', '', '', '', '', '', 0),
(62, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '4630860', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '500567', '', 'House of Lords Inc ', '', '', '', '', '02/28/2024', '03:48:19', '', '', '', '', '', '', 0),
(63, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '7630860', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '3000000', '', 'Transfer', '', '', '', '', '03/02/2024', '04:54:56', '', '', '', '', '', '', 0),
(64, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '8331381', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '700521', '', 'Btc', '', '', '', '', '03/27/2024', '04:57:52', '', '', '', '', '', '', 0),
(65, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '8731768', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '400387', '', 'Payment', '', '', '', '', '04/10/2024', '04:58:43', '', '', '', '', '', '', 0),
(66, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '8731521', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '247', 'Btc', '', '', '', '', '04/15/2024', '05:02:59', '', '', '', '', '', '', 0),
(68, '', '', 'Nicholasjohnedw', '', '', '', '', '', '', '', '', '', '', '8725021', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '6500.00', 'Transfer', '', '', '', '', '25/04/2024', '01:38:07', '', '', '', '', '', '', 0),
(69, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '44500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '2000', 'Transfer', '', '', '', '', '28/04/2024', '07:29:37', '', '', '', '', '', '', 1),
(70, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '44000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '500', 'Transfer', '', '', '', '', '28/04/2024', '07:29:59', '', '', '', '', '', '', 1),
(71, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '43500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '500', 'Transfer', '', '', '', '', '28/04/2024', '07:30:44', '', '', '', '', '', '', 1),
(72, '', '', 'alayonimi', '', '', '', '', '', '', '', '', '', '', '41500', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '2000', 'Transfer', '', '', '', '', '28/04/2024', '07:30:52', '', '', '', '', '', '', 1),
(73, 'Fredrick', 'Kosman', 'Fred', 'fred1968@gmail.com', 'Kosman7', '', '', '', '', '', '29/04/2024', '', '5130069632', '', '59748', '', '', '', '9988', '', '', '', 0, 'O', '', '07011357409', '', '', 'USA', 'OHIO', 'Maryland', '', '10/10/1968', '', '', '', '', '', '', '', '', '', '', '', '51901', '100,564', '', 'YES', 1),
(74, '', '', 'Fred', '', '', '', '', '', '', '', '', '29/04/2024', '', '50000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '50000', '', 'Transfer', '', '', '', '', '10/11/2015', '11:05:00', '', '', '', '', '', '', 1),
(75, 'Heriberta', 'Garcia', 'HeribertaGomezGarcia', 'heriberta2313@gmail.com', 'Cyborg@2313', '', '', '', '', '', '29/04/2024', '', '6103509632', '', '21000', '', '', '', '2313', '', '', '', 0, 'Gomez', '', '3234137675', '', '', 'United States', 'Illinois', '1641 Jones street,Glendale heights', '', '12/23/1975', '', '', '', '', '', '', '', '', '', '', '', '', '', 'YES', '', 0),
(76, '', '', 'HeribertaGomezGarcia', '', '', '', '', '', '', '', '', '29/04/2024', '', '1000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '1000', '', 'Opening Deposit ', '', '', '', '', '04/26/2024', '05:53:58', '', '', '', '', '', '', 0),
(77, '', '', 'HeribertaGomezGarcia', '', '', '', '', '', '', '', '', '', '', '11000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '10000', '', 'Deposit/Trf 68798264', '', '', '', '', '04/29/2024', '05:54:59', '', '', '', '', '', '', 0),
(78, '', '', 'HeribertaGomezGarcia', '', '', '', '', '', '', '', '', '', '', '21000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '10000', '', 'Deposit/Trf 69007284', '', '', '', '', '04/29/2024', '05:55:44', '', '', '', '', '', '', 0),
(79, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '120000', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '70000', '', 'Payment', '', '', '', '', '09/12/2015', '10:43:07', '', '', '', '', '', '', 1),
(80, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '119950', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '50', 'Charges', '', '', '', '', '09/12/2015', '10:44:03', '', '', '', '', '', '', 1),
(81, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '119900', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '50', 'Charges', '', '', '', '', '09/12/2015', '10:44:03', '', '', '', '', '', '', 1),
(82, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '40445', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '79455', 'Contract', '', '', '', '', '03/04/2016', '10:44:41', '', '', '', '', '', '', 1),
(83, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1040445', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '1000000', '', 'GSK', '', '', '', '', '24/06/2016', '10:46:03', '', '', '', '', '', '', 1),
(87, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '513415', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '7000', '', 'Transfer', '', '', '', '', '27/05/2017', '10:51:16', '', '', '', '', '', '', 1),
(84, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1176195', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '135750', '', 'Transfer', '', '', '', '', '12/09/2016', '10:47:28', '', '', '', '', '', '', 1),
(85, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '1086195', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '90000', 'Transfer', '', '', '', '', '12/01/2017', '10:48:36', '', '', '', '', '', '', 1),
(86, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '506415', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '579780', 'Payment', '', '', '', '', '18/02/2017', '10:49:29', '', '', '', '', '', '', 1),
(88, '', '', 'Fred', '', '', '', '', '', '', '', '', '', '', '506394', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '21', 'Charges', '', '', '', '', '27/05/2017', '10:51:49', '', '', '', '', '', '', 1);

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

--
-- Table structure for table `d_user`
--

CREATE TABLE `d_user` (
  `id` int(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `size` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `d_user`
--

INSERT INTO `d_user` (`id`, `file`, `type`, `size`, `username`, `date`, `time`) VALUES
(1, '97063-144392f0-9b6c-43ea-86a8-6790b5b3949c.jpeg', 'image/jpeg', 49, 'Downingann', '29-03-2024', '03:03:16:pm'),
(2, '71343-fred.jpeg', 'image/jpeg', 97, 'Fred', '29-04-2024', '03:45:53:pm');

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

--
-- Table structure for table `LoanBalance`
--

CREATE TABLE `LoanBalance` (
  `id` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `month` varchar(255) NOT NULL,
  `active` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `accnum` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `middlename` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `otp` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `client`
--
ALTER TABLE `client`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

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

--
-- AUTO_INCREMENT for table `LoanBalance`
--
ALTER TABLE `LoanBalance`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;
COMMIT;

