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

START TRANSACTION;



--
-- Database: `federare_news1`
--

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

--
-- 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `accountmaster` (`id`, `accounttype`, `prefix`, `minbalance`, `interest`) VALUES
(5, 'Savings', 'rbs-save', 0.00, 0.00),
(6, 'Checking', 'rbs-check', 0.00, 0.00),
(7, 'Current', 'rbs-current', 0.00, 0.00);

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

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

CREATE TABLE `accounts` (
  `accno` varchar(25) NOT NULL,
  `customerid` int(11) NOT NULL,
  `accstatus` varchar(25) NOT NULL,
  `accopendate` date NOT NULL,
  `accounttype` varchar(25) NOT NULL,
  `accountbalance` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `accounts` (`accno`, `customerid`, `accstatus`, `accopendate`, `accounttype`, `accountbalance`) VALUES
('4861543642', 98806, 'active', '1998-09-12', 'Savings', 92884000),
('5370869143', 98809, 'active', '1996-05-12', 'Savings', 1184500),
('7673708001', 98808, 'active', '1992-07-24', 'Checking', 89711110),
('8823667164', 98807, 'active', '2024-01-10', 'Savings', 55000);

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

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

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

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

INSERT INTO `banks` (`id`, `bank`, `code`) VALUES
(1, 'HSBC Holdings Bank', '044'),
(2, 'Lloyds Banking Group', '401'),
(3, 'Barclays', '023'),
(4, 'Standard Chartered', '551'),
(5, 'Alliance Trust Savings Limited', '063'),
(6, 'Arbuthnot Latham & Co Limited', '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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `branch` (`ifsccode`, `branchname`, `city`, `branchaddress`, `state`, `country`) VALUES
('17ie08zsbh6frj', 'New York Branch', 'New York', '144 New St, Birmingham B2 4NY, United Kingdom', 'New York', 'United States'),
('2onr4v1f0ce8bp', 'Lincoln Branch', 'Lincolnshire', '13 Stonebow Centre Lincoln Lincolnshire LN2 1DQ', 'England', 'United Kingdom'),
('5w6ksi40m72vxp', 'London Branch', 'London', '28 Cavendish Square, Marylebone, London W1G 0DB, United Kingdom', 'London', 'United Kingdom'),
('6j0n8prm15l0qb', 'Cambridge Branch', 'Cambridge', '28 Trinity St, Cambridge CB2 1TB, United Kingdom', 'England', 'United Kingdom'),
('ABNA0100310', 'Edinburgh Branch', 'Edinburghshire', '2 Bernard St, Leith, Edinburgh EH6 6PU, United Kingdom', 'Edinburgh', 'United Kingdom'),
('azelhk7w8s0r2i', 'Nottingham, England', 'Nottingham', '8 S Parade, Nottingham NG1 2JS, United Kingdom', 'England', 'United Kingdom'),
('ec6uzy25nqjh7m', 'Derby Branch', 'Derby', '41 Corn Market, Derby DE1 2DG, United Kingdom', 'England', 'United Kingdom'),
('fha39xvjs700ky', 'Bristol Branch', 'Bristol', '36, 38 Baldwin St, Bristol BS1 1NR, United Kingdom', 'England', 'United Kingdom'),
('jy13vztndo0cbi', 'Manchester Branch', 'Manchester', 'St Ann St, Manchester M60 2SS, United Kingdom', 'England', 'United Kingdom'),
('m7qtu3y5i6jfgn', 'Coventry Branch', 'Coventry', '15 Little Park St, Coventry CV1 2RN, United Kingdom', 'England', 'United Kingdom'),
('vqwmlb10dg97xh', 'Canterbury Branch', 'Canterbury ', '14 Rose Ln, Canterbury CT1 2ST, United Kingdom', 'England', 'United Kingdom'),
('xy7cnhqu1v3esg', 'Chester Branch', 'Chester', '15 Foregate St, Cheshire, Chester CH1 1HD, United Kingdom', 'England', 'United Kingdom');

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

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

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(100) DEFAULT NULL,
  `comment` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `currency` (`id`, `name`, `code`, `comment`) VALUES
(1, 'US Dollar', '$', ''),
(2, 'Australian Dollar', 'A$', ''),
(3, 'Brazilian Real', 'R$', ''),
(4, 'Canadian Dollar', 'C$', ''),
(5, 'Czech Koruna', 'Kč', ''),
(6, 'Danish Krone', 'kr', ''),
(7, 'Euro', '€', ''),
(8, 'Thai Baht', '฿', ''),
(9, 'Hong Kong Dollar', 'HK$', ''),
(10, 'Hungarian Forint', 'Ft', ''),
(11, 'Israeli New Sheqel', '₪', ''),
(12, 'Japanese Yen', '¥', ''),
(13, 'Malaysian Ringgit', 'RM', ''),
(14, 'Mexican Peso', 'MX$', ''),
(15, 'Nigeria Naira', '₦', ''),
(16, 'New Zealand Dollar', 'NZ$', ''),
(17, 'Philippine Peso', '₱', ''),
(18, 'Polish Zloty ', 'zł', ''),
(19, 'Pound Sterling', '£', ''),
(20, 'Russian Ruble', '₽', ''),
(21, 'Singapore Dollar', 'S$', ''),
(22, 'Swedish Krona', 'kr', ''),
(23, 'Swiss Franc', 'CHF', ''),
(24, 'Taiwan New Dollar', 'NT$', ''),
(26, 'Turkish Lira', '₺', '');

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

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

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `customerid` varchar(33) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

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

--
-- 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(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `accno` int(11) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `duration` int(11) NOT NULL,
  `balance` varchar(44) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `fixed_deposit` (`id`, `customerid`, `accno`, `amount`, `duration`, `balance`, `status`) VALUES
(75, 98704, 2147483647, '10000000', 290, '10,000,000.00', 1),
(76, 98705, 1458079036, '18000000', 260, '18,000,000.00', 1),
(77, 98707, 2147483647, '10000000', 260, '18,000,000.00', 1),
(78, 98706, 360571489, '1000000', 210, '18,000,000.00', 1),
(79, 98708, 2147483647, '10000000', 210, '18,000,000.00', 1),
(80, 98709, 2147483647, '10000000', 180, '10,000,000.00', 1),
(81, 98710, 1035480627, '10000000', 320, '10,000,000.00', 1);

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

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

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

--
-- 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, 'Other Loan', 7000.00, 2147483647, 98701, 2147483647, 15.00, 0, 0.00, 0.00, '2020-05-24', 0, ''),
(28, 'Other Loan', 7000.00, 2147483647, 98701, 2147483647, 15.00, 0, 0.00, 0.00, '2020-05-24', 0, ''),
(29, 'Other Loan', 7000.00, 2147483647, 98701, 2147483647, 15.00, 0, 0.00, 0.00, '2020-05-24', 0, '');

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

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

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

--
-- 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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(11) 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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', ''),
(69, 'You successfully made a transfer of €2,0000.', 'Hi , Steven Nathan James.\r\n You have successfully transferred a sum of €2,0000 to an account number in Russia. In a couple of hours the beneficiary will receieve the transfered amount.\r\nTHank you for banking with us\r\n\r\nCheers!\r\n', '2020-06-24 11:09:32', 'admin', '98692', ''),
(70, 'international transfer ', 'Hi \r\nI’m trying to transfer to Australia it won’t allow because I need a COT and IMF code\r\n', '2021-07-15 07:11:59', '98737', 'adeola', 'New'),
(71, 'international transfer ', 'Hi \r\nI’m trying to transfer to Australia it won’t allow because I need a COT and IMF code\r\n', '2021-07-15 07:11:59', '98737', 'adeola', 'New'),
(72, 'cot and imf codes ', 'Hi ,\r\nplease provide COT and IMF codes please so internstional trsnsfer can happen ', '2021-12-10 12:11:48', '98772', 'adeola', ''),
(73, 'cot and imf codes ', 'i will keep emailing until some one asnswers my question a i need to get this sorted URGENTLY', '2021-12-10 02:50:20', '98772', 'adeola', 'New'),
(77, 'nuu', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 10:40:55', 'adm88', '98804', 'New'),
(78, '678', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 12:31:30', 'adm88', '98804', 'New'),
(79, '67', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 12:35:12', 'adm88', '98804', 'New'),
(80, '67', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 12:37:57', 'adm88', '98804', 'New'),
(81, 'nn', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 12:43:22', 'adm88', '98804', 'New'),
(82, '376', 'Hi ,\r\nType Your Message Content Here.\r\n\r\nCheers!\r\n', '2024-09-28 06:56:54', 'adm88', '98766', 'New');

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

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

CREATE TABLE `saved` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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, 98695, 19999, '2020-08-06 19:37:45', 0),
(13, 98701, 13000000, '2020-08-06 19:38:31', 0),
(14, 98701, 13000000, '2020-08-06 19:38:39', 0),
(15, 98725, 5000, '2021-07-08 22:52:23', 0),
(16, 98725, 5000, '2021-07-08 22:52:32', 0),
(17, 98726, 100, '2021-07-27 13:14:29', 0),
(18, 98726, 200, '2021-07-27 13:23:27', 0),
(19, 98726, 300, '2021-07-27 13:30:19', 0),
(20, 98726, 300, '2021-07-27 13:35:21', 0),
(21, 98726, 500, '2021-07-27 13:41:22', 0),
(22, 98726, 500, '2021-07-27 13:43:37', 0),
(23, 98726, 400, '2021-07-27 13:46:46', 0),
(24, 98726, 100, '2021-07-27 13:48:32', 0),
(25, 98726, 200, '2021-07-27 13:50:49', 0),
(26, 98726, 100, '2021-07-27 19:09:06', 0),
(27, 98726, 400, '2021-07-27 19:19:54', 0),
(28, 98726, 100, '2021-07-27 19:48:31', 0),
(29, 98726, 3000, '2021-07-27 19:50:40', 0),
(30, 98726, 1000, '2021-07-27 19:55:42', 0),
(31, 98726, 100, '2021-07-27 19:57:32', 0),
(32, 98726, 200, '2021-07-27 20:01:43', 0),
(33, 98726, 200, '2021-07-27 20:04:04', 0),
(34, 98726, 800, '2021-07-27 20:06:08', 0),
(35, 98726, 100, '2021-07-27 20:06:30', 0),
(36, 98726, 100, '2021-07-27 20:06:48', 0),
(37, 98726, 100, '2021-07-27 20:09:04', 0),
(38, 98726, 100, '2021-07-27 20:09:45', 0),
(39, 98726, 50, '2021-07-27 20:10:58', 0),
(40, 98726, 60, '2021-07-27 20:12:20', 0),
(41, 98726, 100, '2021-07-27 21:39:55', 0),
(42, 98726, 100, '2021-07-27 21:43:03', 0),
(43, 98726, 100, '2021-07-27 21:44:02', 0),
(44, 98726, 100, '2021-07-27 21:44:42', 0),
(45, 98726, 100, '2021-07-27 21:47:15', 0),
(46, 98726, 100, '2021-07-27 21:52:56', 0),
(47, 98726, 400, '2021-07-27 22:00:04', 0),
(48, 98726, 100, '2021-07-27 22:04:19', 0),
(49, 98726, 100, '2021-07-27 22:07:19', 0),
(50, 98726, 100, '2021-07-27 22:10:02', 0),
(51, 98726, 1000, '2021-07-27 22:15:43', 0),
(52, 98726, 1000, '2021-07-27 22:19:52', 0),
(53, 98726, 200, '2021-07-27 22:37:53', 0),
(54, 98726, 100, '2021-07-27 23:12:48', 0),
(55, 98726, 100, '2021-07-27 23:15:37', 0),
(56, 98726, 100, '2021-07-28 00:06:07', 0),
(57, 98726, 100, '2021-07-28 00:17:48', 0),
(58, 98726, 1000, '2021-07-28 00:26:08', 0),
(59, 98726, 10000, '2021-07-28 00:27:36', 0),
(60, 98726, 1000, '2021-07-28 00:28:09', 0),
(61, 98726, 50000, '2021-07-28 00:35:54', 0),
(62, 98726, 10000, '2021-08-16 10:37:10', 0),
(63, 98726, 100000, '2021-08-16 10:40:37', 0),
(64, 98726, 1000, '2021-08-16 10:47:20', 0),
(65, 98762, 76261, '2021-08-16 11:17:57', 0),
(66, 98763, 52879, '2021-09-03 11:28:26', 0),
(67, 98765, 34805, '2021-10-09 10:11:03', 0),
(68, 98766, 1208522, '2021-11-12 15:46:42', 0),
(69, 98770, 1000, '2021-12-04 11:27:55', 0),
(70, 98768, 39856789, '2021-12-06 16:30:02', 0),
(71, 98769, 46000000, '2021-12-06 17:03:38', 0),
(72, 98772, 2800000, '2021-12-07 14:55:57', 0),
(73, 98772, 800000, '2021-12-10 07:50:51', 0),
(74, 98773, 1000000, '2022-01-17 20:11:47', 0),
(75, 98773, 1000000, '2022-01-17 20:12:10', 0),
(76, 98773, 1000000, '2022-01-17 23:38:52', 0),
(77, 98773, 500000, '2022-01-17 23:40:08', 0),
(78, 98766, 4000, '2022-03-13 20:01:09', 0),
(79, 98766, 90000, '2022-03-13 21:53:53', 0),
(80, 98774, 5000, '2022-03-13 23:02:34', 0),
(81, 98775, 10000, '2022-03-15 12:41:55', 0),
(82, 98776, 100931889, '2022-03-15 14:29:06', 0),
(83, 98777, 100932548, '2022-03-15 15:01:23', 0),
(84, 98777, 300000000, '2022-03-15 15:10:33', 0),
(85, 98778, 1010000, '2022-03-15 22:08:05', 0),
(86, 98779, 200312887, '2022-03-17 21:15:08', 0),
(87, 98780, 39215803, '2022-03-22 12:22:59', 0),
(88, 98782, 1009672, '2022-04-05 09:17:05', 0),
(89, 98766, 8000, '2022-11-08 23:51:30', 0),
(90, 98785, 23300, '2022-11-14 11:47:12', 0),
(91, 98785, 10000000, '2022-11-14 12:00:40', 0),
(92, 98766, 0, '2022-11-14 16:05:02', 0),
(93, 98766, 0, '2022-11-14 16:05:15', 0),
(94, 98766, 100000, '2022-11-14 16:06:30', 0),
(95, 98766, 5000, '2022-11-14 16:09:04', 0),
(96, 98766, 15000, '2022-11-14 16:18:02', 0),
(97, 98785, 10500, '2022-11-14 22:25:50', 0),
(98, 98766, 10000000, '2022-11-14 22:46:41', 0),
(99, 98766, 89000, '2022-11-14 22:47:50', 0),
(100, 98766, 65210, '2022-11-14 22:49:19', 0),
(101, 98766, 5500, '2022-11-14 22:50:27', 0),
(102, 98766, 3250, '2022-11-14 22:51:20', 0),
(103, 98766, 56700, '2022-11-14 22:52:44', 0),
(104, 98793, 301599, '2023-08-08 15:52:43', 0),
(105, 98793, 10000, '2023-08-08 16:01:38', 0),
(106, 98793, 86000, '2023-08-08 16:02:33', 0),
(107, 98793, 98000, '2023-08-08 16:03:09', 0),
(108, 98793, 78000, '2023-08-08 16:03:38', 0),
(109, 98793, 104000, '2023-08-08 16:04:26', 0),
(110, 98793, 11000, '2023-08-08 16:04:56', 0),
(111, 98793, -503455, '2023-08-08 16:06:51', 0),
(112, 98766, 90000, '2023-08-09 22:39:04', 0),
(113, 98803, 60000, '2024-09-16 07:54:53', 0),
(114, 98803, 19000, '2024-09-16 07:56:37', 0),
(115, 98803, 89000, '2024-09-16 07:57:16', 0),
(116, 98803, 48462, '2024-09-16 07:58:13', 0),
(117, 98803, 23122, '2024-09-16 08:02:14', 0),
(118, 98803, 7888, '2024-09-16 08:03:20', 0),
(119, 98803, 7888, '2024-09-16 08:04:57', 0),
(120, 98803, 67736, '2024-09-16 08:05:52', 0),
(121, 98803, 38717, '2024-09-16 08:06:52', 0),
(122, 98803, 5678, '2024-09-16 08:08:14', 0),
(123, 98803, 64827, '2024-09-16 08:09:05', 0),
(124, 98803, 39181, '2024-09-16 08:09:59', 0),
(125, 98803, 32678, '2024-09-16 08:11:36', 0),
(126, 98803, 17261, '2024-09-16 08:13:01', 0),
(127, 98803, 76921, '2024-09-16 08:16:29', 0),
(128, 98803, 12783, '2024-09-16 08:19:00', 0),
(129, 98803, 6781, '2024-09-16 08:19:44', 0),
(130, 98803, 5625, '2024-09-16 08:20:29', 0),
(131, 98803, 3991, '2024-09-16 08:21:44', 0),
(132, 98803, 63551, '2024-09-16 08:22:30', 0),
(133, 98803, 13815, '2024-09-16 08:23:41', 0),
(134, 98803, 8271, '2024-09-16 08:24:26', 0),
(135, 98803, 38817, '2024-09-16 08:25:09', 0),
(136, 98803, 6573, '2024-09-16 08:25:48', 0),
(137, 98803, 148371, '2024-09-16 08:26:56', 0),
(138, 98803, 87191, '2024-09-16 08:27:52', 0),
(139, 98803, 1283, '2024-09-16 08:28:45', 0),
(140, 98803, 1465, '2024-09-16 08:34:16', 0),
(141, 98803, 235351, '2024-09-16 08:34:56', 0),
(142, 98803, 56793, '2024-09-16 08:36:14', 0),
(143, 98803, 18817, '2024-09-16 08:41:54', 0),
(144, 98803, 2617, '2024-09-16 08:42:31', 0),
(145, 98803, 99847, '2024-09-16 08:43:51', 0),
(146, 98803, 87542, '2024-09-16 08:45:05', 0),
(147, 98803, 67629, '2024-09-16 08:45:50', 0),
(148, 98803, 28171, '2024-09-16 08:46:42', 0),
(149, 98803, 76500, '2024-09-16 08:47:59', 0),
(150, 98803, 42517, '2024-09-16 08:49:02', 0),
(151, 98803, 27616, '2024-09-16 08:51:29', 0),
(152, 98803, 11281, '2024-09-16 08:53:32', 0),
(153, 98803, 28700, '2024-09-16 08:54:26', 0),
(154, 98803, 498213, '2024-09-16 08:56:40', 0),
(155, 98803, 1627, '2024-09-16 08:57:30', 0),
(156, 98803, 13600, '2024-09-16 08:58:17', 0),
(157, 98803, 86600, '2024-09-16 08:59:48', 0),
(158, 98803, 37805, '2024-09-16 09:01:10', 0),
(159, 98803, 58711, '2024-09-16 09:02:36', 0),
(160, 98803, 117500, '2024-09-16 09:03:19', 0),
(161, 98803, 16289, '2024-09-16 09:04:21', 0),
(162, 98803, 57900, '2024-09-16 09:05:09', 0),
(163, 98803, 29381, '2024-09-16 09:06:23', 0),
(164, 98803, 12785, '2024-09-16 09:07:16', 0),
(165, 98803, 37189, '2024-09-16 09:08:12', 0),
(166, 98803, 98575, '2024-09-16 09:09:04', 0),
(167, 98803, 191821, '2024-09-16 09:10:10', 0),
(168, 98803, 9815, '2024-09-16 09:13:19', 0),
(169, 98803, 63767, '2024-09-16 09:14:26', 0),
(170, 98803, 8223, '2024-09-16 09:15:36', 0),
(171, 98803, 2516, '2024-09-16 09:16:10', 0),
(172, 98803, 3456, '2024-09-16 09:16:43', 0),
(173, 98803, 17287, '2024-09-16 09:17:19', 0),
(174, 98803, 1200, '2024-09-16 09:18:00', 0),
(175, 98803, 1721, '2024-09-16 09:18:30', 0),
(176, 98803, 3817, '2024-09-16 09:21:26', 0),
(177, 98803, 28171, '2024-09-16 09:22:10', 0),
(178, 98805, 2000, '2024-10-04 09:23:04', 0),
(179, 98805, 88000, '2024-11-01 09:29:41', 0),
(180, 98808, 2000, '2024-11-15 15:29:43', 0);

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

--
-- Table structure for table `steps`
--

CREATE TABLE `steps` (
  `step_id` int(11) NOT NULL,
  `step_name` varchar(255) DEFAULT NULL,
  `step_description` text DEFAULT NULL,
  `step_status` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `steps`
--

INSERT INTO `steps` (`step_id`, `step_name`, `step_description`, `step_status`) VALUES
(1, 'COT', 'Cost of Transfer charges applied by the bank899.', 0),
(2, 'IMF', 'International Monetary Fund approval required for large transfers.', 0),
(3, 'Activation-Code', 'Code needed to activate account for secure transactions.', 0),
(4, 'Tax-Code', 'Tax code applied to international fund transfersss.', 1),
(5, 'Validated!', 'Congratulations! You have successfully entered all the valid codes. You are now ready to proceed with your transfer. Thank you for your diligence, and we wish you a smooth and secure transaction!', 1);

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

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

CREATE TABLE `system_settings` (
  `bank_name` varchar(22) NOT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `email` varchar(22) NOT NULL,
  `phone` varchar(22) NOT NULL,
  `theme_color` varchar(55) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `system_settings` (`bank_name`, `currency`, `email`, `phone`, `theme_color`, `status`) VALUES
('Federal Reserve Bank', '$', 'info@federareserve', '0205600435', '', 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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(100) NOT NULL,
  `charged` int(11) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `type` varchar(11) NOT NULL,
  `paymentstat` text NOT NULL,
  `cashier` varchar(33) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `transactions` (`transactionid`, `paymentdate`, `payeeid`, `receiveid`, `charged`, `amount`, `type`, `paymentstat`, `cashier`) VALUES
(414, '2024-10-19 01:17:13', 98806, '807666', 0, '1000', 'Transfer', 'active', ''),
(415, '2024-11-01 02:29:00', 0, '98805', 0, '88000', 'Credit', 'active', 'admin'),
(416, '2024-11-06 11:00:28', 98806, 'DBSSSGSG', 0, '5000', 'Transfer', 'active', ''),
(417, '1999-07-21 02:10:00', 0, '98808', 0, '2000', 'Credit', 'active', 'admin'),
(418, '2024-11-17 09:10:53', 98809, '807666', 0, '5000', 'Transfer', 'active', ''),
(419, '2024-11-17 09:14:01', 98809, 'DBSSSGUS', 0, '1000', 'Transfer', 'active', ''),
(420, '2024-11-17 09:18:10', 98809, 'WFUGADUS', 0, '3500', 'Transfer', 'active', ''),
(421, '2024-11-17 09:21:25', 98809, 'FDRUDUS', 0, '6000', 'Transfer', 'active', ''),
(422, '2024-11-19 04:16:25', 98808, 'CHASUS33', 0, '258890', 'Transfer', 'active', '');

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

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

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

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

INSERT INTO `transfers` (`id`, `sender`, `receiver`, `name`, `bank`, `swift`, `address`, `amount`, `date`, `status`) VALUES
(298, 98806, '0876554443', 'hood guy', 'chase bank', '807666', '111 lazy man street', '1000', '2019-06-23 07:00:00', 0),
(299, 98806, '71712711986256', 'Lim Lee Tin', 'DBS', 'DBSSSGSG', '12 Marina Bay Financial Centre Tower 3 Singapore 018982', '5000', '2024-11-06 23:00:28', 0),
(300, 98809, '0876554443', 'Michael John', 'JPMorgan Chase bank', '807666', '12 Marina Bay Financial Centre Tower 018982 US', '5000', '2024-11-17 21:10:53', 1),
(301, 98809, '0617352971', 'Rose Mary', 'DBS', 'DBSSSGUS', 'Layout Road New York US', '1000', '2017-11-27 08:05:45', 1),
(302, 98809, '6179284561', 'Daniel Jones', 'WellsFargo', 'WFUGADUS', '4223 Heavens Way', '3500', '2019-11-09 07:00:00', 1),
(303, 98809, '31890267524', 'Lim Lee Tin', 'Federal Reserve Bank', 'FDRUDUS', '3506 Cherry Tree Drive', '6000', '2020-12-09 07:10:45', 1),
(304, 98808, '11402607541', 'FAST DELIVERY EQUIPMENT LOGISTIC LLC', 'CHASE BANK', 'CHASUS33', '202 LAKE AVE.LAKE WORTH,FL33460', '258890', '2024-11-19 16:16:25', 0);

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

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

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `withdrawals` (`id`, `userid`, `amount`, `date`, `status`) VALUES
(146, 98806, '1000', '2024-10-19 13:17:13', 1),
(147, 98806, '5000', '2024-11-06 23:00:28', 1),
(148, 98809, '5000', '2024-11-17 21:10:53', 1),
(149, 98809, '1000', '2024-11-17 21:14:02', 1),
(150, 98809, '3500', '2024-11-17 21:18:10', 1),
(151, 98809, '6000', '2024-11-17 21:21:25', 1),
(152, 98808, '258890', '2024-11-19 16:16:25', 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 `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`id`);

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

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

--
-- 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 `saved`
--
ALTER TABLE `saved`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `steps`
--
ALTER TABLE `steps`
  ADD PRIMARY KEY (`step_id`);

--
-- 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 `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- 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(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

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

--
-- AUTO_INCREMENT for table `steps`
--
ALTER TABLE `steps`
  MODIFY `step_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;
COMMIT;

