-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: sql212.byethost.com
-- Generation Time: Apr 04, 2020 at 06:09 AM
-- Server version: 5.6.45-86.1
-- PHP Version: 7.2.22

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: `b32_25261310_blue`
--

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

--
-- Table structure for table `accountmaster`
--

CREATE TABLE `accountmaster` (
  `id` int(11) NOT NULL,
  `accounttype` varchar(25) NOT NULL,
  `prefix` varchar(11) NOT NULL,
  `minbalance` double(12,2) NOT NULL,
  `interest` double(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accountmaster`
--

INSERT INTO `accountmaster` (`id`, `accounttype`, `prefix`, `minbalance`, `interest`) VALUES
(5, 'Checking Account', 'CHA36577', 800.00, 10.00),
(6, 'Current Account', 'CUA4568', 1000.00, 20.00),
(7, 'Savings Account', 'SAV6476', 1500.00, 30.00);

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `accno` varchar(25) NOT NULL,
  `customerid` int(10) NOT NULL,
  `accstatus` varchar(25) NOT NULL,
  `accopendate` date NOT NULL,
  `accounttype` varchar(25) NOT NULL,
  `accountbalance` float(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`accno`, `customerid`, `accstatus`, `accopendate`, `accounttype`, `accountbalance`) VALUES
('1136626524', 98690, 'active', '2019-06-13', 'Current', 16062.00),
('4934039493', 98704, '', '2020-04-02', 'Current Account', 0.00),
('5026068705', 98703, '', '2020-03-22', 'Checking Account', 0.00),
('4336791635', 98702, '', '2020-03-01', 'Current Account', 1000000.00),
('4936912294', 98701, '', '2020-02-27', 'Current Account', 67970.00),
('1585628548', 98700, 'Active', '2020-02-27', '', 0.00);

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

--
-- Table structure for table `administrator`
--

CREATE TABLE `administrator` (
  `id` int(2) NOT NULL,
  `username` varchar(22) NOT NULL,
  `password` varchar(22) NOT NULL,
  `status` int(22) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `administrator`
--

INSERT INTO `administrator` (`id`, `username`, `password`, `status`) VALUES
(1, 'admin', 'admin', 0);

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

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `bank` varchar(100) NOT NULL,
  `code` varchar(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `banks` (`id`, `bank`, `code`) VALUES
(1, 'Access Bank', '044'),
(2, 'Aso Savinhgs and Loan', '401'),
(3, 'Citi Bank', '023'),
(4, 'Covenant Microfinance Bank', '551'),
(5, 'Diamond Bank', '063'),
(6, 'Eco Bank', '050'),
(7, 'Eco Mobile', '307'),
(8, 'Ekondo Microfinance Bank', '562'),
(9, 'Enterprice Bank', '084'),
(10, 'Equitorial Trust Bank', '040'),
(11, 'Fidelity Bank', '070'),
(12, 'Fidelity Mobile', '318'),
(13, 'Finatrust Microfinance Bank', '608'),
(14, 'First City Monument Bank', '214'),
(15, 'First Inland Bank', '085'),
(16, 'Guarantee Trust Bank', '058'),
(17, 'Heritage Bank', '030'),
(18, 'Jaiz Bank', '301'),
(19, 'Keystone Bank', '082'),
(20, 'Main Street Bank', '014'),
(21, 'PAGA', '327'),
(22, 'Skye Bank', '076'),
(23, 'Stanbic IBTC BAnk', '221'),
(24, 'Stanbic Mobile', '304'),
(25, 'Standard Chartered Bank', '068'),
(26, 'Sterline Bank', '232'),
(27, 'Sterline Mobile', '326'),
(28, 'Sun Trust Bank', '100'),
(29, 'Union Bank of Nigeria', '32'),
(30, 'United Bank For Africa', '33'),
(31, 'Unity Bank', '215'),
(32, 'Wema Bank', '35'),
(33, 'Zenith Bank', '57'),
(34, 'Zenith Mobile', '322');

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `ifsccode` varchar(25) NOT NULL,
  `branchname` varchar(50) NOT NULL,
  `city` varchar(25) NOT NULL,
  `branchaddress` text NOT NULL,
  `state` varchar(25) NOT NULL,
  `country` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`ifsccode`, `branchname`, `city`, `branchaddress`, `state`, `country`) VALUES
('2t59aiwlrhce08', 'Ohio Branch', 'Ikeja', '2, Awolowo,  Ikeja, Lagos State.', 'Lagos', 'Andorra'),
('8z05jxe3nylqdp', 'Ontario Branch', '4y45ghghcbn', 'nvhjfgfgdgg', 'yhfghnvcnb', 'Albania'),
('ctpblf00grmvzi', 'Australia Branch', '4y45ghghcbn', 'nvhjfgfgdgg', 'm;k', 'Algeria'),
('dspj9khm485fix', 'Lagos Branch', 'Ikeja', '2, Awolowo,  Ikeja, Lagos State.', 'Lagos', 'Andorra'),
('LDN3453', 'UK Branch', 'London', '1239 London Street', 'London', 'United Kingdom'),
('CA254', 'USA Branch', 'New York city', '2234, New york street', 'California', 'United States of America');

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `code` text NOT NULL,
  `comment` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `name`, `code`, `comment`) VALUES
(1, 'US Dollar', 'USD', ''),
(2, 'Australian Dollar', 'AUD', ''),
(3, 'Brazilian Real', 'BRL', ''),
(4, 'Canadian Dollar', 'CAD', ''),
(5, 'Czech Koruna', 'CZK', ''),
(6, 'Danish Krone', 'DKK', ''),
(7, 'Euro', 'EUR', ''),
(8, 'Thai Baht', 'THB', ''),
(9, 'Hong Kong Dollar', 'HKD', ''),
(10, 'Hungarian Forint', 'HUF', ''),
(11, 'Israeli New Sheqel', 'ILS', ''),
(12, 'Japanese Yen', 'JPY', ''),
(13, 'Malaysian Ringgit', 'MYR', ''),
(14, 'Mexican Peso', 'MXN', ''),
(15, 'Nigeria Naira', 'NGN', ''),
(16, 'New Zealand Dollar', 'NZD', ''),
(17, 'Philippine Peso', 'PHP', ''),
(18, 'Polish Zloty ', 'PLN', ''),
(19, 'Pound Sterling', 'GBP', ''),
(20, 'Russian Ruble', 'RUB', ''),
(21, 'Singapore Dollar', 'SGD', ''),
(22, 'Swedish Krona', 'SEK', ''),
(23, 'Swiss Franc', 'CHF', ''),
(24, 'Taiwan New Dollar', 'TWD', ''),
(26, 'Turkish Lira', 'TRY', '');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customerid` int(10) NOT NULL,
  `accountno` text NOT NULL,
  `acctype` varchar(33) NOT NULL,
  `ifsccode` varchar(25) NOT NULL,
  `firstname` varchar(25) NOT NULL,
  `lastname` varchar(25) NOT NULL,
  `email` varchar(22) NOT NULL,
  `phone` varchar(22) NOT NULL,
  `loginid` varchar(25) NOT NULL,
  `accpassword` varchar(50) NOT NULL,
  `transpassword` varchar(50) NOT NULL,
  `cot` varchar(50) NOT NULL,
  `imf` varchar(50) NOT NULL,
  `accstatus` varchar(25) NOT NULL,
  `city` varchar(25) NOT NULL,
  `state` varchar(25) NOT NULL,
  `country` varchar(25) NOT NULL,
  `accopendate` date NOT NULL,
  `lastlogin` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`customerid`, `accountno`, `acctype`, `ifsccode`, `firstname`, `lastname`, `email`, `phone`, `loginid`, `accpassword`, `transpassword`, `cot`, `imf`, `accstatus`, `city`, `state`, `country`, `accopendate`, `lastlogin`) VALUES
(98690, '1136626524', 'Current', '8z05jxe3nylqdp', 'Adekola', 'Gold', 'test@test.com', '02344423423280', 'test1234', 'test1234', 'test1234', 'COT', 'IMF', 'active', 'Ikeja', 'Lagos', 'Aruba', '2019-06-13', 'Thursday 27th of February 2020 '),
(98704, '4934039493', 'Current Account', '2t59aiwlrhce08', 'Allen', 'Mccoy', 'charlsdungan1@gmail.co', '', 'allen123', '8tivwpoude0h07', '8tivwpoude0h07', 'LBZ8YT2XM5', '39WJ4XFQH5', 'Active', 'Accra', 'Accra', 'Afganistan', '2020-04-02', 'Thursday 2nd of April 2020 '),
(98703, '5026068705', 'Checking Account', '2t59aiwlrhce08', 'Fas', 'Ca', 'dag@gmail.com', '2348108635478', 'rvwbmg3n2zcqdu', 'c62dk384vgsiox', 'c62dk384vgsiox', 'Q8J02EKHBM', 'G0KXVC6RS3', 'Active', 'Abraka', 'Delta ', 'Nigeria', '2020-03-22', ''),
(98702, '4336791635', 'Current Account', 'LDN3453', 'Joan', 'Thompson', 'clintonjoe30@gmail.com', '3097653457', 'joan33', 'joan33', 'joan33', 'L6OQH7FSGR', 'GWZQ98KD7C', 'Active', 'California', 'California', 'United States of America', '2020-03-01', 'Thursday 12th of March 2020 '),
(98701, '4936912294', 'Current Account', 'LDN3453', 'Clinton', 'John', 'clintonjoe23@gmail.com', '30645778', 'clinton41', 'clinton41', 'clinton41', '8ZQD5VELF2', '2MW40EJHT7', 'Active', 'New York city', 'New York', 'United States of America', '2020-02-27', 'Thursday 27th of February 2020 '),
(98700, '1585628548', '', 'ctpblf00grmvzi', 'Clement', 'Fcbest', 'clintonjoel733@gmail.c', '087653424', 'ld26y8rei3zu7t', 'clem22', 'clem22', 'RD4ZKNGTB9', 'BZP7MJYQ5L', 'Active', 'London', 'London', 'United Kingdom', '2020-02-27', '');

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

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

CREATE TABLE `deposits` (
  `id` int(6) NOT NULL,
  `customerid` varchar(33) NOT NULL,
  `amount` int(55) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `duration`
--

CREATE TABLE `duration` (
  `id` int(22) NOT NULL,
  `name` varchar(33) NOT NULL,
  `value` int(33) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `duration`
--

INSERT INTO `duration` (`id`, `name`, `value`, `status`) VALUES
(1, 'One Month', 30, 1),
(2, 'Two Months', 60, 1),
(3, 'Three Months', 90, 1),
(4, 'Four Months', 120, 1),
(5, 'Five Months', 150, 1),
(6, 'Six Months', 180, 1),
(7, 'Seven Months', 210, 1),
(8, 'Eight Months', 230, 1),
(9, 'Nine Months', 260, 1),
(10, 'Ten Months', 290, 1),
(11, 'Eleven Months', 320, 1),
(12, 'Twelve Months', 365, 1),
(13, 'Two Years', 730, 1);

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

--
-- Table structure for table `fixed_deposit`
--

CREATE TABLE `fixed_deposit` (
  `id` int(6) NOT NULL,
  `customerid` int(44) NOT NULL,
  `accno` int(22) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `duration` int(222) NOT NULL,
  `balance` float(10,2) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fixed_deposit`
--

INSERT INTO `fixed_deposit` (`id`, `customerid`, `accno`, `amount`, `duration`, `balance`, `status`) VALUES
(59, 98690, 2147483647, '20000', 730, 0.00, 1);

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

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

CREATE TABLE `loan` (
  `loanid` int(10) NOT NULL,
  `loantype` varchar(25) NOT NULL,
  `loanamt` float(10,2) NOT NULL,
  `loannumber` int(10) NOT NULL,
  `customerid` int(12) NOT NULL,
  `acctno` int(33) NOT NULL,
  `interest` float(10,2) NOT NULL,
  `balance` int(200) NOT NULL,
  `total` float(10,2) NOT NULL,
  `paid` float(10,2) NOT NULL,
  `startdate` date NOT NULL,
  `status` int(2) NOT NULL,
  `signed` varchar(33) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `loan` (`loanid`, `loantype`, `loanamt`, `loannumber`, `customerid`, `acctno`, `interest`, `balance`, `total`, `paid`, `startdate`, `status`, `signed`) VALUES
(24, 'Other Loan', 5000.00, 1366185950, 98690, 1136626524, 15.00, 5750, 0.00, 2134.00, '2019-06-13', 2, ''),
(25, 'Car Loan', 40.00, 1334915320, 98690, 1136626524, 15.00, 46, 0.00, 0.00, '2019-06-15', 2, ''),
(26, 'Car Loan', 5000.00, 1334915320, 98690, 1136626524, 15.00, 0, 0.00, 0.00, '2019-06-15', 0, ''),
(27, 'Travel Loan', 1000.00, 2147483647, 98704, 2147483647, 15.00, 0, 0.00, 0.00, '2020-04-02', 0, '');

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

--
-- Table structure for table `loanpayment`
--

CREATE TABLE `loanpayment` (
  `id` int(11) NOT NULL,
  `customerid` int(33) NOT NULL,
  `loanid` int(33) NOT NULL,
  `date` date NOT NULL,
  `paidamt` int(10) NOT NULL,
  `principleamt` float(10,2) NOT NULL,
  `interestamt` float(10,2) NOT NULL,
  `balance` float(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loanpayment`
--

INSERT INTO `loanpayment` (`id`, `customerid`, `loanid`, `date`, `paidamt`, `principleamt`, `interestamt`, `balance`) VALUES
(89, 98690, 1366185950, '2019-06-13', 123, 0.00, 0.00, 0.00),
(90, 98690, 1366185950, '2019-06-13', 777, 0.00, 0.00, 0.00),
(91, 98690, 1366185950, '2019-06-14', 1234, 0.00, 0.00, 0.00);

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

--
-- Table structure for table `loantype`
--

CREATE TABLE `loantype` (
  `loantype` varchar(25) NOT NULL,
  `prefix` varchar(25) NOT NULL,
  `maximumamt` float(10,2) NOT NULL,
  `minimumamt` float(10,2) NOT NULL,
  `interest` float(10,2) NOT NULL,
  `status` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loantype`
--

INSERT INTO `loantype` (`loantype`, `prefix`, `maximumamt`, `minimumamt`, `interest`, `status`) VALUES
('Car Loan', 'CL', 5000.00, 500.00, 15.00, 'active'),
('Home Loan', 'HL', 50000.00, 500.00, 15.00, 'active'),
('Land Loan', 'LL', 100000.00, 300.00, 15.00, 'active'),
('Other Loan', 'OL', 7000.00, 5000.00, 15.00, 'active'),
('Student Loan', 'SL', 75000.00, 1000.00, 15.00, 'active'),
('Travel Loan', 'TL', 70000.00, 1000.00, 15.00, 'active');

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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `mailid` int(10) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text NOT NULL,
  `mdatetime` datetime NOT NULL,
  `senderid` varchar(25) NOT NULL,
  `reciverid` varchar(25) NOT NULL,
  `status` varchar(3) NOT NULL DEFAULT 'New'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mail`
--

INSERT INTO `mail` (`mailid`, `subject`, `message`, `mdatetime`, `senderid`, `reciverid`, `status`) VALUES
(55, 'Hello My Guy', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-05 08:01:27', 'admin', '98687', ''),
(56, 'Hello My Guy', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-05 08:01:30', 'admin', '98687', ''),
(57, 'Hello My Guy', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-05 08:01:34', 'admin', '98687', ''),
(58, 'hello admin please', 'Hi ,jhghkgkhghkk\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-05 08:08:04', '98687', 'admin', ''),
(59, 'hello oga admin', 'jbcjkbwcjew i need to buy some stuff for my mums birthday at hearea in the house of thekufrijiHi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-05 07:55:02', 'admin', 'admin', ''),
(60, 'wdwdccwec', 'Hi ,\r\nType Your Message Content Here.\r\ncwecew\r\nCheers!\r\n', '2019-06-10 10:24:03', '98687', '98688', 'New'),
(61, 'sdsc', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-10 10:25:50', 'q35tdivfrc8yan', '98687', ''),
(62, 'sdsc', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-10 10:25:55', 'q35tdivfrc8yan', '98687', ''),
(63, 'test new', 'Hi ,\r\nType Your Message Content Here.\r\ndvsdv\r\nCheers!\r\n', '2019-06-10 10:36:25', 'q35tdivfrc8yan', 'admin', 'New'),
(64, 'asdds', 'Hi ,\r\nType Your Message Content Here.sdcdscdsc\r\n\r\nCheers!\r\n', '2019-06-10 10:47:26', '98687', 'q35tdivfrc8yan', 'New'),
(65, 'asdds', 'Hi ,\r\nType Your Message Content Here.sdcdscdsc\r\n\r\nCheers!\r\n', '2019-06-10 10:47:32', '98687', 'q35tdivfrc8yan', 'New'),
(66, 'bjghjgjh', 'rdhgfghfhjvhjkvkHi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-14 11:23:34', 'admin', '98690', ''),
(67, 'hello my guy', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-16 07:16:41', 'admin', '98690', ''),
(68, 'mbvhjvhv', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2019-06-17 06:34:56', 'admin', '98690', '');

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

--
-- Table structure for table `payment_gateway`
--

CREATE TABLE `payment_gateway` (
  `id` int(6) NOT NULL,
  `name` varchar(33) NOT NULL,
  `gateway_name` varchar(22) NOT NULL,
  `public_key` text NOT NULL,
  `secret_key` text NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_gateway`
--

INSERT INTO `payment_gateway` (`id`, `name`, `gateway_name`, `public_key`, `secret_key`, `status`) VALUES
(1, 'Paystack', 'Paystack', 'public key', 'secret key', 1),
(2, 'Rave', 'Rave', 'ghkgkhgkgkh', 'flutterwave public key', 1);

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

--
-- Table structure for table `saved`
--

CREATE TABLE `saved` (
  `id` int(12) NOT NULL,
  `userid` int(33) NOT NULL,
  `amount` int(33) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saved`
--

INSERT INTO `saved` (`id`, `userid`, `amount`, `date`, `status`) VALUES
(5, 98690, 20000, '2019-06-15 12:04:24', 0),
(6, 98690, 200, '2019-06-16 08:01:07', 0),
(7, 98690, 200, '2019-06-16 08:02:48', 0),
(8, 98690, 200, '2019-06-16 08:03:25', 0),
(9, 98690, 20000, '2019-06-16 08:05:14', 0),
(10, 98690, 20000, '2019-06-16 08:05:57', 0),
(11, 98690, 20000, '2019-06-16 13:11:17', 0),
(12, 98701, 70000, '2020-02-28 03:30:36', 0),
(13, 98702, 1000000, '2020-03-02 02:54:45', 0);

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `empid` int(10) NOT NULL,
  `firstname` varchar(22) NOT NULL,
  `lastname` varchar(22) NOT NULL,
  `country` varchar(22) NOT NULL,
  `state` varchar(22) NOT NULL,
  `bank_branch` varchar(22) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(25) NOT NULL,
  `email` varchar(30) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `createdat` date NOT NULL,
  `last_login` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`empid`, `firstname`, `lastname`, `country`, `state`, `bank_branch`, `username`, `password`, `email`, `phone`, `createdat`, `last_login`) VALUES
(232, 'Busola', 'Thomas', 'American Samoa', 'yhfghnvcnb', 'BOGC2345', 'adeola', 'adeola', 'uwakayode@gmail.com', '6574754754', '2019-06-05', '0000-00-00 00:00:00');

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

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `bank_name` varchar(22) NOT NULL,
  `currency` varchar(22) NOT NULL,
  `email` varchar(22) NOT NULL,
  `phone` varchar(22) NOT NULL,
  `theme_color` varchar(55) NOT NULL,
  `status` int(22) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`bank_name`, `currency`, `email`, `phone`, `theme_color`, `status`) VALUES
('Bluebank Internet Bank', 'USD', 'info@bluebank.com', '8656724157986', 'light-style-1.min.css', 1);

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

--
-- Table structure for table `theme`
--

CREATE TABLE `theme` (
  `id` int(11) NOT NULL,
  `color` varchar(33) NOT NULL,
  `code` varchar(44) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `theme`
--

INSERT INTO `theme` (`id`, `color`, `code`) VALUES
(1, 'Purple', 'light-style-1.min.css'),
(2, 'Light blue', 'light-style-blue.min.css'),
(3, 'Navy Blue', 'light-style-navyblue.min.css'),
(4, 'Pink', 'light-style-pink.min.css'),
(5, 'Green', 'light-style-green.min.css'),
(6, 'Red', 'light-style-red.min.css');

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

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

CREATE TABLE `transactions` (
  `transactionid` int(11) NOT NULL,
  `paymentdate` datetime NOT NULL,
  `payeeid` int(11) NOT NULL,
  `receiveid` varchar(11) NOT NULL,
  `charged` int(11) NOT NULL,
  `amount` double NOT NULL,
  `type` varchar(11) NOT NULL,
  `paymentstat` text NOT NULL,
  `cashier` varchar(33) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `transactions` (`transactionid`, `paymentdate`, `payeeid`, `receiveid`, `charged`, `amount`, `type`, `paymentstat`, `cashier`) VALUES
(147, '2020-03-01 09:57:50', 0, '98702', 0, 1000000, 'Credit', 'active', 'admin'),
(146, '2020-02-27 10:49:40', 98701, 'Swift4567', 0, 2000, 'Transfer', 'active', ''),
(145, '2020-02-27 10:35:58', 0, '', 98701, 30, 'Debit', 'active', 'admin'),
(144, '2020-02-27 10:33:37', 0, '98701', 0, 70000, 'Credit', 'active', 'admin');

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` int(33) NOT NULL,
  `sender` int(11) NOT NULL,
  `receiver` int(11) NOT NULL,
  `name` varchar(55) NOT NULL,
  `bank` varchar(33) NOT NULL,
  `swift` varchar(60) NOT NULL DEFAULT 'Not Specified',
  `address` varchar(500) NOT NULL DEFAULT 'Address Not Specified',
  `amount` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transfers`
--

INSERT INTO `transfers` (`id`, `sender`, `receiver`, `name`, `bank`, `swift`, `address`, `amount`, `date`, `status`) VALUES
(63, 98690, 1187011193, '', 'Khaytech Banking', 'Not Specified', 'Address Not Specified', 123, '2019-08-03 20:33:42', 1),
(64, 98690, 1187011193, '1187011193', 'Khaytech Banking', 'Not Specified', 'Address Not Specified', 123, '2019-08-03 20:37:26', 1),
(65, 98690, 1187011193, 'Olowokayemo Tanimola', 'Khaytech Banking', 'Not Specified', 'Address Not Specified', 123, '2019-08-03 20:37:50', 1),
(66, 98690, 577118011, 'Amrios Alaricos', 'FCMB', 'Not Specified', 'Jigawa', 1234, '2019-08-03 21:49:32', 1),
(67, 98690, 577118011, 'Amrios Alaricos', 'FCMB', 'SWIFT1234', 'Jigawa', 1234, '2019-08-03 21:53:26', 1),
(68, 98690, 577118011, 'Amrios Alaricos', 'FCMB', 'SWIFT1234', 'Jigawa', 123, '2019-08-03 22:32:35', 0),
(69, 98701, 2147483647, 'Mary Corton', 'Zenith Bank', 'Swift4567', '354 zenith ', 2000, '2020-02-28 03:46:39', 0);

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

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

CREATE TABLE `withdrawals` (
  `id` int(12) NOT NULL,
  `userid` int(33) NOT NULL,
  `amount` int(33) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(22) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `withdrawals` (`id`, `userid`, `amount`, `date`, `status`) VALUES
(19, 98690, 24, '0000-00-00 00:00:00', 1),
(20, 98690, 24, '0000-00-00 00:00:00', 1),
(21, 98690, 23, '0000-00-00 00:00:00', 1),
(22, 98690, 1234, '0000-00-00 00:00:00', 1),
(23, 98690, 54000, '0000-00-00 00:00:00', 1),
(24, 98690, 90, '0000-00-00 00:00:00', 1),
(25, 98690, 123, '0000-00-00 00:00:00', 1),
(26, 98690, 24, '0000-00-00 00:00:00', 1),
(27, 98690, 24, '0000-00-00 00:00:00', 1),
(28, 98690, 123, '0000-00-00 00:00:00', 1),
(29, 98690, 234, '0000-00-00 00:00:00', 1),
(30, 98690, 1234, '0000-00-00 00:00:00', 1),
(31, 98690, 1234, '0000-00-00 00:00:00', 1),
(32, 98690, 10, '0000-00-00 00:00:00', 1),
(33, 98690, 1234, '0000-00-00 00:00:00', 1),
(34, 98690, 1234, '0000-00-00 00:00:00', 1),
(35, 98690, 123, '0000-00-00 00:00:00', 1),
(36, 98690, 123, '0000-00-00 00:00:00', 1),
(37, 98690, 1234, '0000-00-00 00:00:00', 1),
(38, 98690, 123, '0000-00-00 00:00:00', 1),
(39, 98690, 123, '0000-00-00 00:00:00', 1),
(40, 98690, 123, '0000-00-00 00:00:00', 1),
(41, 98690, 123, '0000-00-00 00:00:00', 1),
(42, 98690, 1234, '0000-00-00 00:00:00', 1),
(43, 98690, 1234, '0000-00-00 00:00:00', 1),
(44, 98690, 123, '0000-00-00 00:00:00', 1),
(45, 98701, 2000, '2020-02-28 03:46:39', 1);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`accno`);

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

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

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`ifsccode`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customerid`);

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

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

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

--
-- Indexes for table `loan`
--
ALTER TABLE `loan`
  ADD PRIMARY KEY (`loanid`);

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

--
-- Indexes for table `loantype`
--
ALTER TABLE `loantype`
  ADD UNIQUE KEY `loantype` (`loantype`);

--
-- Indexes for table `mail`
--
ALTER TABLE `mail`
  ADD PRIMARY KEY (`mailid`);

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

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

--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
  ADD PRIMARY KEY (`empid`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customerid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98705;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fixed_deposit`
--
ALTER TABLE `fixed_deposit`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `loan`
--
ALTER TABLE `loan`
  MODIFY `loanid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

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

--
-- AUTO_INCREMENT for table `mail`
--
ALTER TABLE `mail`
  MODIFY `mailid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

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

--
-- AUTO_INCREMENT for table `saved`
--
ALTER TABLE `saved`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `empid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `transactionid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=148;

--
-- AUTO_INCREMENT for table `transfers`
--
ALTER TABLE `transfers`
  MODIFY `id` int(33) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

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