-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 09, 2021 at 02:59 PM
-- Server version: 10.3.28-MariaDB
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `mariston_mari`
--

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

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

CREATE TABLE `account` (
  `id` int(10) NOT NULL,
  `acc_no` varchar(20) DEFAULT NULL,
  `uname` varchar(100) DEFAULT NULL,
  `upass` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `billing_code` int(2) NOT 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) DEFAULT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `account` (`id`, `acc_no`, `uname`, `upass`, `email`, `billing_code`, `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`) VALUES
(27, '1234', 'SAB', 'demo', 'donsXXX@gmail.com', 1, 'Savings', 'DEMO USER', 'NNN', 'NAME', 'NIGERIA', 'jmm', 'Male', '08/11/2018', '+23310152679', 1, '132023', '08/11/2018', 'Single', 303293, 303293, 515, 'ACTIVE', 'USD $', '1234', '1234', '1234', '1234', '1234', 'Y', '0'),
(28, '012977777', 'ajovi4ever', '1234', 'ajovi4ever@gmail.com', 0, 'Savings', 'Jovial', '', 'Kevwoda', '9 Obadudu Road', 'Teacher', 'Male', '28/02/1979', '+14242715633', 1, '534440', '07/01/2020', 'Single', 203000, 202700, 0, 'ACTIVE', '$', '123', '456', '00', '1234', '789', 'Y', 'no'),
(29, '0000', '`123456', '123456', 'koreadeliverylinks@gmail.com', 0, 'Savings', 'saaaa', '', '`zssss', 'gggggggggggg', 'worker', 'Male', '01/10/1988', '234567900', NULL, NULL, '10/01/2020', 'Single', 0, 0, 0, 'DORMANT/INACTIVE', 'USD $', '00', '00', '00', '00', '00', 'N', 'no'),
(30, '0000', 'Jfkfkt', 'jfjr', 'jerryleo058@gmail.com', 0, 'Online Banking', 'jfjfj', 'Kfkfk', 'jfjf', 'Ejjeje', 'jfjfj', 'Female', '238585', '4858585ir', NULL, NULL, '11/01/2020', 'Married', 0, 0, 0, 'DORMANT/INACTIVE', 'USD $', '00', '00', '00', '00', '00', 'N', 'no'),
(31, '5454545454', 'kriz', 'letter', 'tellme_all2@yahoo.com', 0, 'NON-Resident', 'James', '', 'Luis', '843jkgf', 'Retired', 'Male', '16/01/2020', '+2348130683602', NULL, '120851', '16/01/2020', 'Single', 600000, 600000, 0, 'ACTIVE', 'USD $', 'N78ZF9', '73185', 'PJU6EY', '1234', '1234', 'Y', 'no'),
(35, '904822501628', 'agabajhn', 'Markchip@22', 'agabajhn@gmail.com', 0, 'Savings', 'JOHN', '', 'AGABA', '1 petervale', 'Business', 'Male', '07/07/1986', '27783789955', 1, '915919', '', 'Single', 194677, 194677, 0, 'ACTIVE', 'USD $', '2111', '2122', '', '2100', '2100', 'Y', 'no'),
(36, '0000', 'bonane', 'Markchip@2', 'solarintel86@gmail.com', 0, 'Savings', 'fred', 'j', 'jo', '', 'Business', 'Male', '07/07/1986', '27783789955', NULL, NULL, '02/03/2021', 'Single', 0, 0, 0, 'ACTIVE', 'USD $', '001', '002', '003', '004', '005', 'Y', 'no'),
(37, '001872950310', 'aalvarez', 'annia@2021', 'profzizinga001@gmail.com', 0, 'Joint Account', 'ANNIA', 'A', 'ALVAREZ', '', 'Business', 'Female', '29/09/1977', '27781157672', 1, '299511', '02/20/2021', 'Single', 100000, 100000, 0, 'ACTIVE', 'USD $', '2100', '2100', '2100', '2021', '2021', 'Y', 'no'),
(39, '1122334455', 'Timi', '654321', 'tomisidor@yahoo.com', 1, 'Checking', 'BRIAN', 'Pacinol', 'PALLIN', '52 Burleigh Street', 'Teacher', 'Male', '01/01/2009', '08098909034', 1, '163021', '29/01/2020', 'Single', 6497900, 6497900, 0, 'ACTIVE', 'EUR â‚¬', '0000', '0001', '0002', '4321', '4321', 'Y', 'no'),
(40, '001802749310', 'vumisa', 'happiness2020', 'jabuliledvumisa@gmail.com', 0, 'Savings', 'VUMISA', 'JABULILE', 'HAPPINESS', 'B342 Sundumbili, Mandeni', 'Business', 'Female', '21/08/1985', '27734001342', NULL, NULL, '08/03/2021', 'Single', 0, 0, 0, 'ACTIVE', 'USD $', '4545', '4545', '4545', '2020', '2020', 'Y', 'no'),
(41, '904429171628', 'mmboneni', 'ramakavhi2020', 'mukonaramakavhi78@gmail.com', 0, 'Savings', 'MMBONENI', 'RM', 'RAMAKAVHI', 'B155 Vuvha Village', 'Business', 'Male', '02/03/1978', '27818146469', NULL, NULL, '08/03/2021', 'Single', 0, 0, 0, 'ACTIVE', 'USD $', '4545', '4545', '4545', '2020', '2020', 'Y', 'no'),
(42, '904429601628', 'mokgobo', 'omolemo3030', 'letlhogonolomokgobo63@outlook.com', 0, 'Savings', 'LETLHOGONOLO', 'KENNEDY', 'MOKGOBO', '3 Talalla Cres, Noordwyk', 'Business', 'Male', '31/05/1975', '27604579651', 1, '200828', '08/03/2021', 'Single', 0, 0, 0, 'ACTIVE', 'USD $', '4545', '4545', '4545', '2020', '2020', 'Y', 'no');

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

--
-- 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;

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

INSERT INTO `admin` (`id`, `uname`, `upass`, `email`, `verified_count`) VALUES
(1, 'The admin', 'c6971d5db5a09df36056671e5fefa1f1', 'admin@admin.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(222) NOT NULL,
  `statz` varchar(200) DEFAULT 'Successfull'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `alerts` (`id`, `uname`, `amount`, `sender_name`, `type`, `remarks`, `date`, `time`, `email`, `statz`) VALUES
(153, '1230', 5000, 'UBA BANK DEMO', 'Credit', 'BANK DEMO APP TEST', '13:11:2019', '04:59:05', '', NULL),
(154, '1230', 200, 'UBA BANK DEMO', 'Credit', 'App demo test', '09/11/2019', '17:00:15', '', NULL),
(155, '123456', 5000, 'UBA BANK', 'Credit', 'OHA NGWA DAKAR', '13:11:2019', '05:00:15', '', NULL),
(158, '1234', 22, 'MARYANNE SUNDERZ', 'Debit', 'testing', '10/10/2019', '15:02:47', '', NULL),
(159, '1234', 11000, 'ALLAN MILLS', 'Debit', '999', '10/10/2019', '15:02:47', '', 'Successful'),
(160, '1234', 7, 'MARYANNE SUNDERZ', 'Debit', 'xx', '10/10/2019', '15:02:47', '', 'Pending'),
(161, '012977777', 20000, 'City Bank New York', 'Credit', 'Contract Award', '14/12/2019', '21:17:47', '', 'Successfull'),
(162, '012977777', 200000, 'Fidelity Bank', 'Credit', 'Award Winnings', '12/08/2019', '20:39:28', '', 'Successfull'),
(163, '012977777', 2000, 'Shell BP', 'Credit', 'Expenses', '12/08/2019', '20:41:56', '', 'Successfull'),
(164, '5454545454', 200000, 'James', 'Credit', 'goods', '16/01/2020', '12:08', '', 'Successfull'),
(165, '904822501628', 200000, 'Jefferson D', 'Credit', 'Illuminati', '02/03/2021', '15;32', '', 'Successfull'),
(166, '904822501628', 2000, 'America', 'Debit', 'ATM Withdrawal', '02/03/2021', '16:00', '', 'Successfull'),
(167, '001872950310', 100000, 'Absa Bank  Za', 'Credit', 'Online trade', '25/02/2021', '14:32', '', 'Successfull'),
(168, '1122334455', 500000, 'General Fahd Freij', 'Credit', 'Gas', '25/06/2020', '15:40:15', '', 'Successfull'),
(169, '1122334455', 100, 'Account', 'Debit', 'Service charge', '25/06/2021', '5:40:15', '', 'Successfull');

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

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

CREATE TABLE `forgot_pass` (
  `email` mediumtext COLLATE latin1_general_ci NOT NULL,
  `token` varchar(9999) COLLATE latin1_general_ci NOT NULL,
  `expiry` varchar(8999) COLLATE latin1_general_ci 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');

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `id` int(11) NOT NULL,
  `lamt` varchar(100) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loan`
--

INSERT INTO `loan` (`id`, `lamt`, `duration`, `description`) VALUES
(0, '1000', '1 year', 'Williams Hamsel'),
(0, '1000', '6 Months', 'Sam');

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

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

CREATE TABLE `message` (
  `id` int(10) NOT NULL,
  `sender_name` varchar(40) 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;

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

INSERT INTO `message` (`id`, `sender_name`, `reci_name`, `subject`, `msg`, `read`, `date`) VALUES
(1, 'Service Department', 'agabajhn', 'payment done', 'payment done please unsuspend my service', 'unread', '2021-03-07 18:57:38'),
(2, 'Customer Care', 'agabajhn', 'vin', 'clientel', 'unread', '2021-03-07 19:04:15'),
(3, 'Account Officer', 'Timi', 'Received', 'It was received', 'unread', '2021-03-07 19:05:20'),
(4, 'Customer Care', 'Timi', 'PLEASE HELP AND UNSUSPEND MY ACCOUNT', 'i am waiting for your quick response', 'unread', '2021-03-09 05:12:34');

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

--
-- 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;

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 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`) VALUES
(289, 'donsammi30@gmail.com', '12', '1892928282', 'kentclarke', 'bank card', 'DOMESTIC', 'DOMESTIC', 'Savings', 'personal', 'Domestic-Transfer', 'DOMESTIC'),
(290, 'susanander92@gmail.com', '200', '0785642198', 'CBAO', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'GIFT', 'Domestic-Transfer', 'InterBank'),
(291, 'wokolura@gmail.com', '4790', '9978530075', 'OHA NGWA DAKAR', 'ECOBANK DAKAR', 'ECOBANKXXXX', '', 'Savings', 'MY CONTRIBUTION TO OHA NGWA DAKAR', 'Senegal', 'Wire Transfer'),
(292, 'susanander92@gmail.com', '500', '888750645321', 'DEMO BANK', 'DEMON BANK', 'DOMESTIC', 'DOMESTIC', 'Savings', 'DEMO TEST', 'Domestic-Transfer', 'DOMESTIC'),
(293, 'susanander92@gmail.com', '300', '99999953489', 'CBAO DEMO', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'DEMO', 'Domestic-Transfer', 'InterBank'),
(294, 'susanander92@gmail.com', '1200', '87967543215', 'THE DEMO', 'THE DEMO', 'THEDEMOXXX', '', 'Savings', 'DEMO TEST', 'Austria', 'Wire Transfer'),
(295, 'susanander92@gmail.com', '50', '097654', 'THEDEMO', 'THEDEMO', 'DOMESTIC', 'DOMESTIC', 'Savings', 'DEMO', 'Domestic-Transfer', 'DOMESTIC'),
(296, 'susanander92@gmail.com', '250', '00067432178', 'LAGOS DEMO BANK', 'LAGOS DEMO BANK', 'DOMESTIC', 'DOMESTIC', 'Savings', 'DEMO LAGOS BANK', 'Domestic-Transfer', 'DOMESTIC'),
(297, 'donsammi30@gmail.com', '777', '10999999', 'iiiii', 'nmm', 'DOMESTIC', 'DOMESTIC', 'Savings', '111', 'Domestic-Transfer', 'DOMESTIC'),
(298, 'donsammi30@gmail.com', '100', '12345', 'Sanm', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Test', 'Domestic-Transfer', 'InterBank'),
(299, 'donsammi30@gmail.com', '3625', '123456', 'Jejdk', 'Jdbdkd', 'Jdjdu', '', 'Savings', 'Dhd', 'Afganistan', 'Wire Transfer'),
(300, 'donsammi30@gmail.com', '2000', '2007065898', 'Amos King', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Monthly allowance', 'Domestic-Transfer', 'InterBank'),
(301, 'donsammi30@gmail.com', '1000', '24784747', 'BB', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'loan', 'Domestic-Transfer', 'InterBank'),
(302, 'donsammi30@gmail.com', '200', '235689459', 'Dghhjkjgh', 'Ghjhfvhjjj', 'Ghh4678885', '', 'Savings', 'Gjjjj', 'Afganistan', 'Wire Transfer'),
(303, 'donsammi30@gmail.com', '125', '236988994', 'Fghkkkbfgjjj', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Ghjmmvghhb', 'Domestic-Transfer', 'InterBank'),
(304, 'donsammi30@gmail.com', '123', '235698158', 'Dgjjkkkknn', 'Ghhjjkkmbbb', '234567', '', 'Savings', 'Ghjkkk', 'Afganistan', 'Wire Transfer'),
(305, 'donsammi30@gmail.com', '124', '560868000', '2345567', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Chhjkkjb', 'Domestic-Transfer', 'InterBank'),
(306, 'donsammi30@gmail.com', '3000', '29183838', 'Mick', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'contract', 'Domestic-Transfer', 'InterBank'),
(307, 'donsammi30@gmail.com', '4555', '44543454', 'ghhhh', 'rgg', '35fef', '', 'Savings', 'efff', 'Afganistan', 'Wire Transfer'),
(308, 'ajovi4ever@gmail.com', '30000', '2390624162', 'Mark Wo', 'Sity Bank LTSD', 'SWE736H', '', 'Savings', 'MSB', 'Barbados', 'Wire Transfer'),
(309, 'donsammi30@gmail.com', '200', '455224555', 'Hff fred', 'Ubs', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Ok', 'Domestic-Transfer', 'DOMESTIC'),
(310, 'donsammi30@gmail.com', '1000', '1646797995900', 'Pin code', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'On code', 'Domestic-Transfer', 'InterBank'),
(311, 'donsammi30@gmail.com', '797', '4949494', 'Hsb', 'Ahab', '273', '', 'Savings', 'Bbsbs', 'Afganistan', 'Wire Transfer'),
(312, 'donsammi30@gmail.com', '600', '5729292922', 'Gah', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'China', 'Domestic-Transfer', 'InterBank'),
(313, 'donsammi30@gmail.com', '66373848', '53637384', 'Vbhhhh', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Losn', 'Domestic-Transfer', 'InterBank'),
(314, 'donsammi30@gmail.com', '500', '123', 'aaa', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', '123', 'Domestic-Transfer', 'InterBank'),
(315, 'donsammi30@gmail.com', '123', '123', '123', '123', 'DOMESTIC', 'DOMESTIC', 'Savings', '123', 'Domestic-Transfer', 'DOMESTIC'),
(316, 'donsammi30@gmail.com', '123', '123', '123', '123', 'DOMESTIC', 'DOMESTIC', 'Savings', '123', 'Domestic-Transfer', 'DOMESTIC'),
(317, 'donsammi30@gmail.com', '123', '123', 'aaa', 'aaa', '123', '', 'Savings', '123', 'Australia', 'Wire Transfer'),
(318, 'donsammi30@gmail.com', '123', '123', '123', '123', '123', '', 'Savings', '123', 'Bahamas', 'Wire Transfer'),
(319, 'donsammi30@gmail.com', '123', '123', 'aaa', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', '123', 'Domestic-Transfer', 'InterBank'),
(320, 'donsammi30@gmail.com', '123', '123', 'asdf', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', '12312assadfasdfasd', 'Domestic-Transfer', 'InterBank'),
(321, 'donsammi30@gmail.com', '123', '123', '123', '123', 'DOMESTIC', 'DOMESTIC', 'Savings', '123', 'Domestic-Transfer', 'DOMESTIC'),
(322, 'donsammi30@gmail.com', '1234', '1234', '1234', '1234', 'DOMESTIC', 'DOMESTIC', 'Savings', '1234', 'Domestic-Transfer', 'DOMESTIC'),
(323, 'donsammi30@gmail.com', '11111111', '1234', 'aaa', 'aaaa', 'DOMESTIC', 'DOMESTIC', 'Savings', 'aaaa', 'Domestic-Transfer', 'DOMESTIC'),
(324, 'donsammi30@gmail.com', '111', '1234', 'demo', 'aaa', 'DOMESTIC', 'DOMESTIC', 'Savings', 'aaa', 'Domestic-Transfer', 'DOMESTIC'),
(325, 'donsammi30@gmail.com', '1234', '4321', 'omed', 'aaa', 'DOMESTIC', 'DOMESTIC', 'Savings', 'asdfasdf', 'Domestic-Transfer', 'DOMESTIC'),
(326, 'donsammi30@gmail.com', '123', '23123', '1231', '12312', 'DOMESTIC', 'DOMESTIC', 'Savings', '3123123', 'Domestic-Transfer', 'DOMESTIC'),
(327, 'donsammi30@gmail.com', '123', '12312', '123', '3123', 'DOMESTIC', 'DOMESTIC', 'Savings', '123123', 'Domestic-Transfer', 'DOMESTIC'),
(328, 'donsammi30@gmail.com', '123', '123', '123', '123', '123', '', 'Savings', '123', 'Afganistan', 'Wire Transfer'),
(329, 'donsammi30@gmail.com', '123', '123', '123', '123', '123', '', 'Savings', '123', 'Afganistan', 'Wire Transfer'),
(330, 'donsammi30@gmail.com', '1234', '1234', '1234', '1234', '1234', '', 'Savings', '1234', 'Bahamas', 'Wire Transfer'),
(331, 'donsammi30@gmail.com', '1234', '1234', '1234', '1234', '1234', '', 'Savings', '1234', 'Afganistan', 'Wire Transfer'),
(332, 'donsammi30@gmail.com', '12341234123', '12342134213421', '213412342134', '123412342134213421342134', '123412342134213', '', 'Savings', '214123412342134', 'Bahamas', 'Wire Transfer'),
(333, 'donsammi30@gmail.com', '33', '3333333333333333', 'sslji', 'deed', '33322', '', 'Savings', '2dssa', 'Afganistan', 'Wire Transfer'),
(334, 'donsammi30@gmail.com', '66', '68678678668', 'gklkj', 'ghjghj', '8987789', '', 'Savings', 'kjgkjgjk', 'Afganistan', 'Wire Transfer'),
(335, 'donsammi30@gmail.com', '20000', '45893540954', 'John Stewart', 'InterBank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Fff', 'Domestic-Transfer', 'InterBank'),
(336, 'donsammi30@gmail.com', '10000', '1111', 'Get g', 'Bnaa', '111', '', 'Savings', 'Ttvb', 'Brazil', 'Wire Transfer'),
(337, 'donsammi30@gmail.com', '5768', '9473937379', 'John Cardon', 'Key bank', 'DOMESTIC', 'DOMESTIC', 'Savings', 'My friend', 'Domestic-Transfer', 'DOMESTIC'),
(338, 'donsammi30@gmail.com', '5765', '575668874467', 'Hjb hgv', 'Stone bank', 'Gfsjjh', '', 'Savings', 'Bank', 'Jordan', 'Wire Transfer'),
(339, 'donsammi30@gmail.com', '4000', '123467', 'john peters', 'ghho0', '456789', '', 'Savings', 'test', 'Afganistan', 'Wire Transfer'),
(340, 'donsammi30@gmail.com', '255', '254558755', 'Fred vera', 'Uba', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Food', 'Domestic-Transfer', 'DOMESTIC'),
(341, 'donsammi30@gmail.com', '100000', '0246467400', 'Elliot', 'Wakanda', 'DOMESTIC', 'DOMESTIC', 'Savings', 'Testing', 'Domestic-Transfer', 'DOMESTIC'),
(342, 'donsammi30@gmail.com', '4333', '57848774', 'kaer fred', 'hsbc', 'DOMESTIC', 'DOMESTIC', 'Savings', 'payment bill', 'Domestic-Transfer', 'DOMESTIC'),
(343, 'donsammi30@gmail.com', '50000', '0223910879', 'JAMES ONE', 'BANK OF AMERICA', 'UB3682', '', 'Savings', 'DONE', 'United States of America', 'Wire Transfer'),
(344, 'donsammi30@gmail.com', '2300', '653653656556', 'larry fred', 'HSBC BANK', 'DOMESTIC', 'DOMESTIC', 'Savings', 'FUND TRANSFER', 'Domestic-Transfer', 'DOMESTIC'),
(345, 'tomisidor@yahoo.com', '200', '09909888889', 'James Bond', 'Citi bank', '5444444', '4444444', '', 'Gas', 'Bahamas', 'WIRE TRANSFER'),
(346, 'agabajhn@gmail.com', '2000', '890661789', 'Agab', 'Bank of ug', 'DOMESTIC', 'DOMESTIC', '', 'Paid', 'Domestic-Transfer', 'DOMESTIC'),
(347, 'profzizinga001@gmail.com', '20000', '3230770400', 'Annia Alvarez', 'Wells Fargo', 'DOMESTIC', 'DOMESTIC', '', 'Pay bills', 'Domestic-Transfer', 'DOMESTIC'),
(348, 'tomisidor@yahoo.com', '1000', '09999898899', 'William Lewis', 'Citi bank', '099887676', '887676555434', '', 'Gas', 'Chad', 'WIRE TRANSFER'),
(349, 'agabajhn@gmail.com', '111', 'Uganda', 'JOHN AGABA', 'bdhdhd', 'ugzahd', '93874746', '', 'fixed', 'Uganda', 'WIRE TRANSFER'),
(350, 'agabajhn@gmail.com', '1212', 'Uganda', 'JOHN AGABA', 'hch', 'jddh2', '38884490', '', '83', 'Uganda', 'WIRE TRANSFER'),
(351, 'tomisidor@yahoo.com', '2000', '0090991211100', 'Renee Hamza', 'Citi Bank', '0099888', '00998888', '', 'Ticket', 'Aruba', 'WIRE-TRANSFER'),
(352, 'tomisidor@yahoo.com', '2000', '0099889988800', 'William Lewis', 'John Lewis', '0099888', '00099999', '', 'Ticket', 'Belgium', 'WIRE-TRANSFER'),
(353, 'tomisidor@yahoo.com', '2000', '1122334455', 'William Lewis', 'John Lewis', '0099888', '00099999', '', 'Ticket', 'Belgium', 'WIRE-TRANSFER');

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

--
-- 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;

--
-- 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'),
(47, 58126, 'UBA', NULL, 'TESTIN TICK', 'TESTIN TICK', 'Pending', '2019-11-13 04:56:52'),
(48, 83501, 'DEMO USER', NULL, '455', 'Ok', 'Pending', '2020-02-03 22:31:10'),
(49, 52338, 'DEMO USER', NULL, 'kihgf', 'ij', 'Pending', '2020-02-04 23:10:49'),
(50, 96832, 'JOHN', NULL, 'comp', 'lain', 'Pending', '2021-03-07 18:44:34'),
(51, 22894, 'JOHN', NULL, 'loaner', 'hi', 'Pending', '2021-03-07 18:55:23'),
(52, 92097, 'BRIAN', NULL, 'Test', 'Testing', 'Pending', '2021-03-07 19:00:03');

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

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

CREATE TABLE `transfer` (
  `id` int(10) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `bank_name` varchar(40) NOT NULL,
  `acc_name` varchar(100) NOT NULL,
  `transtype` varchar(1000) NOT NULL,
  `acc_no` varchar(20) NOT NULL,
  `reci_name` varchar(30) NOT NULL,
  `type` varchar(20) NOT NULL,
  `swift` varchar(100) NOT NULL,
  `routing` varchar(100) NOT NULL,
  `remarks` varchar(500) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `status` enum('Failed','Successful','Pending','On-hold','Cancelled') DEFAULT 'Successful',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `cout` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `transfer` (`id`, `amount`, `bank_name`, `acc_name`, `transtype`, `acc_no`, `reci_name`, `type`, `swift`, `routing`, `remarks`, `email`, `status`, `date`, `cout`) VALUES
(81, '200', 'InterBank', 'CBAO', 'InterBank', '0785642198', '', 'Savings', 'DOMESTIC', 'DOMESTIC', 'GIFT', 'rabeehied@100101.ru', 'Successful', '2019-11-13 05:08:43', 'Domestic-Transfer'),
(82, '500', 'DEMON BANK', 'DEMO BANK', 'DOMESTIC', '888750645321', '', 'Savings', 'DOMESTIC', 'DOMESTIC', 'DEMO TEST', 'susanander92@gmail.com', 'On-hold', '2019-11-13 14:28:45', 'Domestic-Transfer'),
(83, '300', 'InterBank', 'CBAO DEMO', 'InterBank', '99999953489', '', 'Savings', 'DOMESTIC', 'DOMESTIC', 'DEMO', 'susanander92@gmail.com', 'Successful', '2019-11-13 14:44:00', 'Domestic-Transfer'),
(84, '1200', 'THE DEMO', 'THE DEMO', 'Wire Transfer', '87967543215', '', 'Savings', 'THEDEMOXXX', '', 'DEMO TEST', 'susanander92@gmail.com', 'Successful', '2019-11-13 14:46:44', 'Austria'),
(85, '50', 'THEDEMO', 'THEDEMO', 'DOMESTIC', '097654', '', 'Savings', 'DOMESTIC', 'DOMESTIC', 'DEMO', 'susanander92@gmail.com', 'Successful', '2019-11-13 14:53:38', 'Domestic-Transfer'),
(86, '250', 'LAGOS DEMO BANK', 'LAGOS DEMO BANK', 'DOMESTIC', '00067432178', '', 'Savings', 'DOMESTIC', 'DOMESTIC', 'DEMO LAGOS BANK', 'susanander92@gmail.com', 'Cancelled', '2019-11-13 15:57:03', 'Domestic-Transfer'),
(87, '50000', 'BANK OF AMERICA', 'JAMES ONE', 'Wire Transfer', '0223910879', '', 'Savings', 'UB3682', '', 'DONE', 'donsammi30@gmail.com', 'Successful', '2020-02-05 08:06:59', 'United States of America'),
(88, '200', 'Citi bank', 'James Bond', 'WIRE TRANSFER', '09909888889', '', '', '5444444', '4444444', 'Gas', 'tomisidor@yahoo.com', 'Successful', '2021-02-24 14:21:03', 'Bahamas'),
(89, '2000', 'Bank of ug', 'Agab', 'DOMESTIC', '890661789', '', '', 'DOMESTIC', 'DOMESTIC', 'Paid', 'agabajhn@gmail.com', 'Successful', '2021-03-02 06:33:33', 'Domestic-Transfer'),
(90, '111', 'bdhdhd', 'JOHN AGABA', 'WIRE TRANSFER', 'Uganda', '', '', 'ugzahd', '93874746', 'fixed', 'agabajhn@gmail.com', 'Successful', '2021-03-07 20:02:09', 'Uganda'),
(91, '1212', 'hch', 'JOHN AGABA', 'WIRE TRANSFER', 'Uganda', '', '', 'jddh2', '38884490', '83', 'agabajhn@gmail.com', 'Successful', '2021-03-07 20:08:21', 'Uganda'),
(92, '2000', 'John Lewis', 'William Lewis', 'WIRE-TRANSFER', '1122334455', '', '', '0099888', '00099999', 'Ticket', 'tomisidor@yahoo.com', 'Successful', '2021-03-09 05:51:16', 'Belgium');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `ticket`
--
ALTER TABLE `ticket`
  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=43;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `transfer`
--
ALTER TABLE `transfer`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;
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 */;
