-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 09, 2026 at 06:40 AM
-- Server version: 11.4.9-MariaDB
-- PHP Version: 8.4.11

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


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

--
-- Database: `devionic_payzaa`
--

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

--
-- 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
(1, 'Checking', 'rbs-check', 0.00, 0.00),
(2, 'Current', 'rbs-current', 0.00, 0.00),
(3, 'Savings', 'rbs-save', 0.00, 0.00),
(4, 'Domiciliary Account', 'x81726', 500.00, 20.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` 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
('2947800916', 6, 'onreview', '2025-10-23', 'Current', 0),
('5193366363', 5, 'onreview', '2025-10-23', 'Domiciliary Account', 0),
('5454999995', 3, 'active', '2025-10-21', 'Current', 102853),
('7365508186', 4, 'onreview', '2025-10-22', 'Domiciliary Account', 0);

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

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

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

INSERT INTO `administrator` (`id`, `username`, `password`, `status`) VALUES
(0, 'admin', '123456', 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- 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
('RBSUS001', 'New York Main Branch', 'New York', '123 Wall Street, Manhattan', 'New York', 'USA'),
('RBSUS002', 'Los Angeles Branch', 'Los Angeles', '456 Sunset Boulevard, Downtown', 'California', 'USA'),
('RBSUS003', 'Chicago Branch', 'Chicago', '789 Michigan Avenue, The Loop', 'Illinois', 'USA'),
('RBSUS004', 'Houston Branch', 'Houston', '1011 Main Street, Midtown', 'Texas', 'USA');

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

--
-- 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 `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(100) 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,
  `image` varchar(255) NOT NULL,
  `dob` text NOT NULL,
  `gender` varchar(10) NOT NULL,
  `activationcode` varchar(50) NOT NULL,
  `taxcode` varchar(50) NOT NULL,
  `transfer_count` int(11) DEFAULT 0,
  `regstatus` enum('visible','hidden') NOT NULL DEFAULT 'visible',
  `card_long_digit` varchar(16) DEFAULT NULL,
  `valid_thru` varchar(6) DEFAULT NULL,
  `otp` varchar(6) DEFAULT NULL,
  `otp_attempts` int(11) DEFAULT 0,
  `otp_generated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 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`, `image`, `dob`, `gender`, `activationcode`, `taxcode`, `transfer_count`, `regstatus`, `card_long_digit`, `valid_thru`, `otp`, `otp_attempts`, `otp_generated_at`) VALUES
(3, '5454999995', 'Current', 'RBSUS002', 'Tommy', 'Meylan', 'user@mail.com', '12345678909', '1234567890', '123456', '1234', '1234', '1234', 'active', 'Catahoula', 'Louisiana', 'United States', '2025-10-21', 'Monday 9th of February 2026', 'profile_68f767419f4a1.jpg', '1989-10-13', 'Male', '1234', '1234', 16, 'visible', '4484952728385537', '03/29', '123456', 0, '2026-02-09 04:08:12'),
(4, '7365508186', 'Domiciliary Account', 'RBSUS002', 'Ifeanyi', 'Ozoigbo ', 'let4loveonyeoma@gmail.com', '+2347066780159', 'sozp34dnajw0vc', 'n8o0tyfsz2le3c', '4156', 'U7QAOHWYD3', '9E0KQ14UPI', 'onreview', 'Onitsha', 'Anambra State', 'Nigeria', '2025-10-22', '', '', '1992-03-10', 'male', 'TYDAQ8ZMUO', 'VNJHFUKG19', 0, 'visible', '4847945251471168', '05/29', '274044', 0, '2025-10-22 14:36:44'),
(5, '5193366363', 'Domiciliary Account', 'RBSUS003', 'Jamilu ', 'Yusuf Hussain ', 'jameeluyusuf4@gmail.com', '+2347087206342', '61vlwcu43sx9pk', '@Therevelutionist01.', '1960', 'FR3GJIAL5W', 'PN2V64YQX0', 'onreview', 'Kano', 'Kano State', 'Nigeria', '2025-10-23', '', '', '1996-05-21', 'male', 'WHGF74RZNV', 'KULJD6A9P4', 0, 'visible', '4468814538794397', '06/29', '145236', 0, '2025-10-23 07:14:32'),
(6, '2947800916', 'Current', 'RBSUS001', 'Prince Peter', 'Antai', 'peter2antai@gmail.com', '+2348119006586', 'q6jgml8ohxz75t', 'rk7301wyzdi8p4', '2580', 'E3QA5VJGI6', 'XA4R561CDO', 'onreview', 'Juigalpa', 'Chontales Department', 'Nicaragua', '2025-10-23', '', '', '1990-10-23', 'male', 'E7ODMRYPAI', 'S529FU1M3E', 0, 'visible', '4842624971345647', '08/29', '258013', 0, '2025-10-23 21:34:39');

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

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

CREATE TABLE `deposits` (
  `id` int(6) 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(22) NOT NULL,
  `name` varchar(33) NOT NULL,
  `value` int(33) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- 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` varchar(44) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` int(11) NOT NULL,
  `otp_enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `otp_enabled`) VALUES
(1, 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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `saved` (`id`, `userid`, `amount`, `date`, `status`) VALUES
(1, 3, 50000, '2025-10-21 20:36:14', 0),
(2, 3, 1000, '2026-02-08 11:19:14', 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 bank', 1),
(2, 'IMF', 'International Monetary Fund approval required for large transfers.', 1),
(3, 'Activation-Code', 'Code needed to activate account for secure transactions.', 1),
(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 `stock_orders`
--

CREATE TABLE `stock_orders` (
  `id` int(11) NOT NULL,
  `customerid` varchar(50) NOT NULL,
  `symbol` varchar(10) NOT NULL,
  `stock_name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `total_cost` decimal(15,2) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active',
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_orders`
--

INSERT INTO `stock_orders` (`id`, `customerid`, `symbol`, `stock_name`, `price`, `quantity`, `total_cost`, `status`, `date`) VALUES
(1, '3', 'TSLA', 'Tesla, Inc.', 435.80, 1, 435.80, 'Active', '2026-01-09 08:02:19'),
(2, '3', 'GOOGL', 'Alphabet Inc.', 324.25, 1, 324.25, 'Active', '2026-01-20 14:57:01'),
(3, '3', 'TSLA', 'Tesla, Inc.', 407.79, 2, 815.58, 'Active', '2026-02-06 14:52:41'),
(4, '3', 'GOOGL', 'Alphabet Inc.', 322.74, -1, 322.74, 'Active', '2026-02-06 15:43:45'),
(5, '3', 'GOOGL', 'Alphabet Inc.', 323.37, 10, 3233.70, 'Active', '2026-02-06 15:48:45'),
(6, '3', 'TSLA', 'Tesla, Inc.', 412.20, -1, 412.20, 'Active', '2026-02-06 18:37:36'),
(7, '3', 'AAPL', 'Apple Inc.', 278.13, 1, 278.13, 'Active', '2026-02-07 19:57:23'),
(8, '3', 'AAPL', 'Apple Inc.', 278.12, 1, 278.12, 'Active', '2026-02-08 08:40:31'),
(9, '3', 'TSLA', 'Tesla, Inc.', 411.11, 1, 411.11, 'Active', '2026-02-08 12:04:46'),
(10, '3', 'AAPL', 'Apple Inc.', 278.13, 1, 278.13, 'Active', '2026-02-08 20:04:54'),
(11, '3', 'GOOGL', 'Alphabet Inc.', 322.86, 1, 322.86, 'Active', '2026-02-09 01:59:46');

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

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

CREATE TABLE `system_settings` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(22) NOT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(22) NOT NULL,
  `theme_color` varchar(55) NOT NULL,
  `status` int(22) NOT NULL,
  `brand_logo` varchar(500) DEFAULT NULL,
  `favicon` varchar(500) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `email2` varchar(255) DEFAULT NULL,
  `phone2` varchar(50) DEFAULT NULL,
  `live_chat_provider` varchar(50) DEFAULT NULL COMMENT 'tawk, tidio, or null',
  `live_chat_code` text DEFAULT NULL COMMENT 'JS embed code for the chat widget',
  `smtp_host` varchar(190) DEFAULT NULL,
  `smtp_port` int(11) DEFAULT 465,
  `smtp_username` varchar(190) DEFAULT NULL,
  `smtp_password` varchar(255) DEFAULT NULL,
  `smtp_encryption` varchar(20) DEFAULT 'ssl',
  `smtp_from_email` varchar(190) DEFAULT NULL,
  `smtp_from_name` varchar(190) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `system_settings` (`id`, `bank_name`, `currency`, `email`, `phone`, `theme_color`, `status`, `brand_logo`, `favicon`, `company_address`, `email2`, `phone2`, `live_chat_provider`, `live_chat_code`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `smtp_encryption`, `smtp_from_email`, `smtp_from_name`) VALUES
(2, 'Blue Crest', '$', 'mail@devionicsolutions.com.ng', '12345678909', '', 0, 'assets/images/brand/logo_1770451590.png', 'assets/images/brand/favicon_1770493628.png', '123st Manhattan', 'mail@devionicsolutions.com.ng', NULL, '', '', NULL, 465, NULL, NULL, 'ssl', NULL, NULL);

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `transactions` (`transactionid`, `paymentdate`, `payeeid`, `receiveid`, `charged`, `amount`, `type`, `paymentstat`, `cashier`) VALUES
(1, '2025-10-15 21:36:00', 0, '3', 0, '50000', 'Credit', 'active', '0'),
(2, '2022-12-12 00:00:00', 3, '', 0, '2300', 'Debit', 'active', '0'),
(3, '2025-10-22 06:06:26', 3, '11111111111', 0, '500', 'Transfer', 'active', ''),
(4, '2026-01-09 08:02:19', 3, 'Stock Buy', 3, '435.8', '', '1', ''),
(5, '2026-01-09 09:15:31', 3, '32442322', 0, '765', 'Transfer', 'active', ''),
(6, '2026-01-09 09:16:50', 3, '23322344342', 0, '209', 'Transfer', 'active', ''),
(7, '2026-01-09 09:28:32', 3, '2342424234', 0, '23', 'Transfer', 'active', ''),
(8, '2026-01-20 14:57:01', 3, 'Stock Buy', 3, '324.2487', '', '1', ''),
(9, '2026-02-06 14:52:41', 3, 'Stock Buy', 3, '815.58', '', '1', ''),
(10, '2026-02-06 15:43:45', 0, '3', 3, '322.74', '', '1', ''),
(11, '2026-02-06 15:48:45', 3, 'Stock Buy', 3, '3233.7', '', '1', ''),
(12, '2026-02-06 16:31:48', 3, '12345678908', 0, '100', 'Transfer', 'active', ''),
(13, '2026-02-06 16:49:25', 3, '', 0, '0', 'Transfer', 'active', ''),
(14, '2026-02-06 18:37:36', 0, '3', 3, '412.2', '', '1', ''),
(15, '2026-02-07 08:32:45', 3, '12345678908', 0, '600', 'Transfer', 'active', ''),
(16, '2026-02-08 10:28:02', 3, '23423423442', 0, '12', 'Transfer', 'active', ''),
(17, '2026-02-08 10:33:45', 3, 'sdfsdffdff', 0, '100', 'Transfer', 'active', ''),
(18, '2026-02-08 10:45:35', 3, '35678bdbdj', 0, '1000', 'Transfer', 'active', ''),
(19, '2026-02-28 22:34:00', 0, '3', 0, '1000', 'Credit', 'active', '0'),
(20, '2026-02-08 12:08:14', 3, '74yf654367', 0, '2300', 'Transfer', 'active', ''),
(21, '2026-02-08 12:39:39', 3, '123123123123', 0, '100', 'Transfer', 'active', ''),
(22, '2026-02-08 12:43:47', 3, '23423424', 0, '21', 'Transfer', 'active', ''),
(23, '2026-02-08 13:07:37', 3, '34242', 0, '12', 'Transfer', 'active', ''),
(24, '2026-02-08 15:01:49', 3, '74yf654367', 0, '600', 'Transfer', 'active', ''),
(25, '2026-02-08 15:23:32', 3, '234234234', 0, '50', 'Transfer', 'active', ''),
(26, '2026-02-08 15:41:26', 3, '74yf654367', 0, '400', 'Transfer', 'active', ''),
(27, '2026-02-08 16:42:18', 3, '3423424234', 0, '12', 'Transfer', 'active', ''),
(28, '2026-02-08 20:01:21', 3, '5634567365', 0, '3000', 'Transfer', 'active', ''),
(29, '2026-02-08 20:10:44', 3, '74yf654367', 0, '400', 'Transfer', 'active', '');

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

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

CREATE TABLE `transfers` (
  `id` int(33) 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
(1, 3, '5454999995', 'Susan Roland', 'Chase bank', '11111111111', '123 rose street', '500', '2025-10-22 06:06:26', 1),
(2, 3, '5454999995', 'sdfsfsdfsfsf', 'sdfsdfsfsf', '32442322', 'sdfsffsf', '765', '2026-01-09 09:15:31', 1),
(3, 3, '5454999995', 'sdfsfsdfsf', 'sddfsdfsdf', '23322344342', 'sdfsfsdfdsdfsd', '209', '2026-01-09 09:16:50', 0),
(4, 3, '5454999995', 'zxvzxvvzxv', 'zxzvzxvzvzxv', '2342424234', 'zvzxxzvzxvzx', '23', '2026-01-09 09:28:32', 0),
(5, 3, '5454999995', 'sdfdfsdfsdf', 'sdf', '12345678908', 'sdfsdf', '100', '2026-02-06 16:31:48', 0),
(6, 3, '', '', '', '', '', '0', '2026-02-06 16:49:25', 0),
(7, 3, '5454999995', 'kate', 'bank of America ', '12345678908', 'none f', '600', '2026-02-07 08:32:45', 0),
(8, 3, '5454999995', 'sdffsfdsf', 'sdfsf', '23423423442', 'sdffsdfsfsdfdsf', '12', '2026-02-08 10:28:02', 0),
(9, 3, '5454999995', 'sdfsdfsdf', 'sdfsf', 'sdfsdffdff', 'sdfsfds', '100', '2026-02-08 10:33:45', 0),
(10, 3, '5454999995', 'Kate Middleton ', 'Kate', '35678bdbdj', 'Test b', '1000', '2026-02-08 10:45:35', 0),
(11, 3, '5454999995', 'Demond', 'Tesla bank', '74yf654367', '1234 desko', '2300', '2026-02-08 12:08:15', 0),
(12, 3, '5454999995', 'Demond', 'Tesla bank', '74yf654367', '1234 desko', '600', '2026-02-08 15:01:49', 0),
(13, 3, '5454999995', 'sdfsdfsdf', 'sdfsf', '234234234', 'sdffsf', '50', '2026-02-08 15:23:32', 0),
(14, 3, '5454999995', 'Demond', 'Tesla bank', '74yf654367', '1234 desko', '400', '2026-02-08 15:41:26', 0),
(15, 3, '5454999995', 'Christaino H', 'Desmond', '5634567365', '123 Desmond QY', '3000', '2026-02-08 20:01:21', 0),
(16, 3, '5454999995', 'Demond', 'Tesla bank', '74yf654367', '1234 desko', '400', '2026-02-08 20:10:44', 0);

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

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

CREATE TABLE `withdrawals` (
  `id` int(12) NOT NULL,
  `userid` int(33) NOT NULL,
  `amount` varchar(44) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(22) 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
(1, 3, '500', '2025-10-22 06:06:26', 1),
(2, 3, '765', '2026-01-09 09:15:31', 1),
(3, 3, '209', '2026-01-09 09:16:50', 1),
(4, 3, '23', '2026-01-09 09:28:32', 1),
(5, 3, '100', '2026-02-06 16:31:48', 1),
(6, 3, '0', '2026-02-06 16:49:25', 1),
(7, 3, '600', '2026-02-07 08:32:45', 1),
(8, 3, '12', '2026-02-08 10:28:02', 1),
(9, 3, '100', '2026-02-08 10:33:45', 1),
(10, 3, '1000', '2026-02-08 10:45:35', 1),
(11, 3, '2300', '2026-02-08 12:08:15', 1),
(12, 3, '600', '2026-02-08 15:01:49', 1),
(13, 3, '50', '2026-02-08 15:23:32', 1),
(14, 3, '400', '2026-02-08 15:41:26', 1),
(15, 3, '3000', '2026-02-08 20:01:21', 1),
(16, 3, '400', '2026-02-08 20:10:44', 1);

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `method_name` varchar(100) NOT NULL,
  `method_type` varchar(40) NOT NULL DEFAULT 'other',
  `wallet_address` varchar(255) DEFAULT NULL,
  `network_type` varchar(80) DEFAULT NULL,
  `bank_name` varchar(120) DEFAULT NULL,
  `account_name` varchar(120) DEFAULT NULL,
  `account_number` varchar(120) DEFAULT NULL,
  `instructions` text DEFAULT NULL,
  `require_receipt` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `topup_requests`
--

CREATE TABLE `topup_requests` (
  `id` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `method_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `reference` varchar(40) NOT NULL,
  `note` text DEFAULT NULL,
  `receipt_path` varchar(255) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `notified_customer` tinyint(1) NOT NULL DEFAULT 0,
  `admin_note` text DEFAULT NULL,
  `processed_by` varchar(100) DEFAULT NULL,
  `processed_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

--
-- Indexes for table `topup_requests`
--
ALTER TABLE `topup_requests`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_topup_reference` (`reference`),
  ADD KEY `idx_topup_customer` (`customerid`),
  ADD KEY `idx_topup_method` (`method_id`),
  ADD KEY `idx_topup_status` (`status`);

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

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

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

--
-- 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 for table `general_settings`
--
ALTER TABLE `general_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `topup_requests`
--
ALTER TABLE `topup_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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