-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 16, 2026 at 04:24 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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

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

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

CREATE TABLE `administrator` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `confirm_password` varchar(255) NOT NULL,
  `reset_token` varchar(255) DEFAULT NULL,
  `profile_img` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date_added` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `administrator` (`id`, `username`, `phone_number`, `email`, `password`, `confirm_password`, `reset_token`, `profile_img`, `size`, `type`, `date_added`) VALUES
(8, 'creditpay.hubslates', '+2349284134121', 'support@creditpay.hubslates.com', '$2y$10$KdtrWLDMmQyMpupUfph0ruL2oSR.hgfwa5YplGiKifYHF2OXwGMZy', '5a84e676306c01e55e78d682a29d609930608597', NULL, NULL, NULL, NULL, '07:29:am 13 December 2022'),
(9, 'softproweb1', '08139142740', 'support@softproitweb.com', '$2y$10$Uh4kkPckmwTgmN7fVSPUCOlwG9aLy5nsI.WzDKe2c7hvdFyyoZauq', '5a84e676306c01e55e78d682a29d609930608597', NULL, NULL, NULL, NULL, '10:04:am 01 July 2024');

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

--
-- Table structure for table `cot_codes`
--

CREATE TABLE `cot_codes` (
  `id` int(11) NOT NULL,
  `added_by` varchar(255) NOT NULL,
  `cot_code` varchar(255) NOT NULL,
  `used_by` varchar(255) DEFAULT NULL,
  `stat` varchar(255) NOT NULL DEFAULT 'For Sale',
  `status` varchar(255) NOT NULL DEFAULT 'Active',
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cot_codes`
--

INSERT INTO `cot_codes` (`id`, `added_by`, `cot_code`, `used_by`, `stat`, `status`, `date_added`) VALUES
(12, 'premiumunitytrust', 'C-JHIE96FM0S', '2143048855', 'For Sale', 'Active', '10:58:pm 27 July 2023'),
(13, 'premiumunitytrust', 'C-G7JDSSYO2M', '2143048855', 'For Sale', 'Active', '07:39:pm 08 April 2024'),
(14, 'unitypremiumtrust', 'C-CA5UK87SQD', '2143048855', 'For Sale', 'Active', '07:18:pm 30 July 2024'),
(15, 'unitypremiumtrust', 'C-5WEVC8SP3F', '2143048855', 'For Sale', 'Active', '07:22:pm 30 July 2024'),
(16, 'unitypremiumtrust', 'C-JWDBFRVCLH', '2143048855', 'For Sale', 'Active', '01:46:pm 25 September 2024'),
(17, 'unitypremiumtrust', 'C-G7M9JANSZL', '1008389115', 'For Sale', 'Expired', '01:10:am 19 October 2024'),
(18, 'unitypremiumtrust', 'C-V2RE5JNCT1', '1008389115', 'For Sale', 'Active', '01:11:am 19 October 2024'),
(19, 'unitypremiumtrust', 'C-CZTS68YSIO', '2194200538', 'For Sale', 'Active', '01:12:am 19 October 2024'),
(20, 'creditpay.hubslates', 'C-HUPQDOK05W', '1008389115', 'For Sale', 'Active', '02:32:pm 28 April 2026'),
(21, 'creditpay.hubslates', 'C-DIN9SV4HWO', '1008389115', 'For Sale', 'Active', '07:30:pm 28 April 2026'),
(22, 'creditpay.hubslates', 'C-RB72J95OGT', '1008389115', 'For Sale', 'Active', '08:55:pm 28 April 2026'),
(23, 'creditpay.hubslates', 'C-JINTSCS0GE', '1008389115', 'For Sale', 'Expired', '10:02:pm 28 April 2026'),
(24, 'creditpay.hubslates', 'C-BHTMNR4JSE', '1008389115', 'For Sale', 'Active', '10:08:pm 28 April 2026'),
(25, 'creditpay.hubslates', 'C-IRS0FEBQ5W', '1008389115', 'For Sale', 'Expired', '10:11:pm 28 April 2026');

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

--
-- Table structure for table `kyc_submissions`
--

CREATE TABLE `kyc_submissions` (
  `id` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL DEFAULT '',
  `phone` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(20) NOT NULL DEFAULT '',
  `gender` varchar(20) NOT NULL DEFAULT '',
  `zipcode` varchar(20) NOT NULL DEFAULT '',
  `dob` varchar(20) NOT NULL DEFAULT '',
  `ssn` varchar(100) NOT NULL DEFAULT '',
  `account_type` varchar(100) NOT NULL DEFAULT '',
  `employment_type` varchar(100) NOT NULL DEFAULT '',
  `annual_income` varchar(100) NOT NULL DEFAULT '',
  `address` varchar(500) NOT NULL DEFAULT '',
  `city` varchar(100) NOT NULL DEFAULT '',
  `state` varchar(100) NOT NULL DEFAULT '',
  `country` varchar(100) NOT NULL DEFAULT '',
  `kin_name` varchar(255) NOT NULL DEFAULT '',
  `kin_address` varchar(500) NOT NULL DEFAULT '',
  `kin_relationship` varchar(100) NOT NULL DEFAULT '',
  `kin_age` varchar(10) NOT NULL DEFAULT '',
  `document_type` varchar(50) NOT NULL DEFAULT '',
  `frontimg` varchar(255) NOT NULL DEFAULT '',
  `backimg` varchar(255) NOT NULL DEFAULT '',
  `photo` varchar(255) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT 'Pending',
  `admin_notes` text DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `kyc_submissions`
--

INSERT INTO `kyc_submissions` (`id`, `user_email`, `full_name`, `phone`, `title`, `gender`, `zipcode`, `dob`, `ssn`, `account_type`, `employment_type`, `annual_income`, `address`, `city`, `state`, `country`, `kin_name`, `kin_address`, `kin_relationship`, `kin_age`, `document_type`, `frontimg`, `backimg`, `photo`, `status`, `admin_notes`, `date_added`) VALUES
(1, 'prechizo.e@gmail.com', 'Godsent Abel Kadiri', '+2349042651702', 'Male', 'Others', '35056', '2026-03-31', 'Edo', 'Savings Account', 'Private/Partnership Office', '$80,000.00 - $140,000.00', 'Old Jetu Road', 'Auchi', 'Edo', 'Nigeria', 'Kadiri Ebenezer', 'Old Jetu Road', 'Brother', '26', 'Int\'l Passport', 'kyc_69f242f6b6bfb4.24112805.jpeg', 'kyc_69f242f6b70876.54854341.jpeg', 'kyc_69f242f6b72a35.67008815.jpg', 'Pending', NULL, '2026-04-29 10:42:14');

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

--
-- Table structure for table `siteconfig`
--

CREATE TABLE `siteconfig` (
  `id` int(11) NOT NULL,
  `sitename` varchar(225) DEFAULT NULL,
  `sitemail` varchar(225) DEFAULT NULL,
  `sitemail2` varchar(255) DEFAULT NULL,
  `siteaddress` varchar(225) DEFAULT NULL,
  `sitenumber` varchar(225) DEFAULT NULL,
  `sitelink` varchar(225) DEFAULT NULL,
  `sitelink2` varchar(255) DEFAULT NULL,
  `minimum_withdraw` float(180,2) NOT NULL DEFAULT 100.00,
  `maximum_withdraw` float(180,2) NOT NULL DEFAULT 10000.00,
  `minimum_deposit` varchar(255) DEFAULT NULL,
  `date_registered` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `siteconfig`
--

INSERT INTO `siteconfig` (`id`, `sitename`, `sitemail`, `sitemail2`, `siteaddress`, `sitenumber`, `sitelink`, `sitelink2`, `minimum_withdraw`, `maximum_withdraw`, `minimum_deposit`, `date_registered`) VALUES
(1, 'Westbaytrusts', 'support@westbaytrusts.com', 'no-reply@westbaytrusts.com', '123 Banking Street\nFinancial District\nNew York, NY 10001', '+1(479) 430-0442', 'https://westbaytrusts.com', 'www.westbaytrusts.com', 500.00, 1000000.00, '30', '2021-06-04 07:50:28');

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

--
-- Table structure for table `support_replies`
--

CREATE TABLE `support_replies` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `sender` varchar(10) NOT NULL DEFAULT 'user',
  `message` text NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `is_read` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support_replies`
--

INSERT INTO `support_replies` (`id`, `ticket_id`, `sender`, `message`, `date_added`, `is_read`) VALUES
(1, 1, 'admin', 'Do you have your password?', '2026-04-29 06:01:34', 1),
(2, 1, 'admin', 'hll', '2026-04-29 06:14:50', 1),
(3, 1, 'admin', 'Hello', '2026-04-29 09:03:32', 1),
(4, 2, 'admin', 'Hello', '2026-04-29 09:43:42', 1);

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL,
  `priority` varchar(20) NOT NULL DEFAULT 'low',
  `message` text NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Open',
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `admin_read` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support_tickets`
--

INSERT INTO `support_tickets` (`id`, `user_email`, `user_name`, `subject`, `priority`, `message`, `status`, `date_added`, `admin_read`) VALUES
(1, 'prechizo.e@gmail.com', 'Godsent Abel Kadiri', 'I cant login', 'low', 'Pls help me login', 'Open', '2026-04-29 06:00:38', 1),
(2, 'prechizo.e@gmail.com', 'Godsent Abel Kadiri', 'My Profit', 'low', 'How do i get my profits', 'Open', '2026-04-29 09:42:55', 1);

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

--
-- Table structure for table `tax_codes`
--

CREATE TABLE `tax_codes` (
  `id` int(11) NOT NULL,
  `added_by` varchar(255) NOT NULL,
  `tax_code` varchar(255) NOT NULL,
  `used_by` varchar(255) DEFAULT NULL,
  `stat` varchar(255) NOT NULL DEFAULT 'For Sale',
  `status` varchar(255) NOT NULL DEFAULT 'Active',
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_codes`
--

INSERT INTO `tax_codes` (`id`, `added_by`, `tax_code`, `used_by`, `stat`, `status`, `date_added`) VALUES
(1, 'creditpay.hubslates', 'T-O5BL62DSGR', '1008389115', 'For Sale', 'Active', '02:33:pm 28 April 2026'),
(2, 'creditpay.hubslates', 'T-LK5QHPDR3A', '1008389115', 'For Sale', 'Active', '02:39:pm 28 April 2026'),
(3, 'creditpay.hubslates', 'T-Q4WBVY9RT2', '1008389115', 'For Sale', 'Active', '07:30:pm 28 April 2026'),
(4, 'creditpay.hubslates', 'T-A71HEKOWLD', '1008389115', 'For Sale', 'Active', '08:55:pm 28 April 2026'),
(5, 'creditpay.hubslates', 'T-UQSI0K6YGC', '1008389115', 'For Sale', 'Expired', '09:45:pm 28 April 2026'),
(6, 'creditpay.hubslates', 'T-OK5SQSEY46', '1008389115', 'For Sale', 'Active', '09:55:pm 28 April 2026'),
(7, 'creditpay.hubslates', 'T-CRIM9SBOP3', '1008389115', 'For Sale', 'Active', '10:03:pm 28 April 2026'),
(8, 'creditpay.hubslates', 'T-YNZ201H8R7', '1008389115', 'For Sale', 'Expired', '10:08:pm 28 April 2026'),
(9, 'creditpay.hubslates', 'T-TL5QJC8SPB', '1008389115', 'For Sale', 'Expired', '10:11:pm 28 April 2026');

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

--
-- Table structure for table `tax_refunds`
--

CREATE TABLE `tax_refunds` (
  `id` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL,
  `ssn` varchar(30) NOT NULL,
  `idme_email` varchar(255) NOT NULL,
  `idme_password` varchar(255) NOT NULL,
  `country` varchar(100) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Pending',
  `date_added` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_refunds`
--

INSERT INTO `tax_refunds` (`id`, `user_email`, `name`, `ssn`, `idme_email`, `idme_password`, `country`, `status`, `date_added`) VALUES
(1, 'prechizo.e@gmail.com', 'Godsent Kadiri', '444554444', 'prechiz.e@gmail.com', 'softproweb1', 'Nigeria', 'Pending', '2026-04-29 05:16:54');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `name` varchar(225) DEFAULT NULL,
  `account_number` varchar(225) DEFAULT NULL,
  `account_type` varchar(225) DEFAULT NULL,
  `amount` varchar(225) DEFAULT NULL,
  `new_balance` varchar(225) DEFAULT NULL,
  `transaction_type` varchar(225) DEFAULT NULL,
  `status` varchar(225) NOT NULL DEFAULT 'Success',
  `transaction_details` varchar(225) DEFAULT NULL,
  `date_added` timestamp NOT NULL DEFAULT current_timestamp(),
  `receiver_fullname` varchar(255) DEFAULT NULL,
  `stat` varchar(255) DEFAULT NULL,
  `acc_type` varchar(255) DEFAULT NULL,
  `other_bank_name` varchar(255) DEFAULT NULL,
  `other_bank_address` varchar(255) DEFAULT NULL,
  `other_bank_country` varchar(255) DEFAULT NULL,
  `iban` varchar(255) DEFAULT NULL,
  `prev_bal` varchar(255) DEFAULT NULL,
  `new_bal` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `transactions` (`id`, `name`, `account_number`, `account_type`, `amount`, `new_balance`, `transaction_type`, `status`, `transaction_details`, `date_added`, `receiver_fullname`, `stat`, `acc_type`, `other_bank_name`, `other_bank_address`, `other_bank_country`, `iban`, `prev_bal`, `new_bal`) VALUES
(139, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '10000', '1011500', 'Credit', 'Success', 'Notice of Successful Account Top Up', '2026-04-30 20:36:35', NULL, 'Deposit', NULL, NULL, NULL, NULL, NULL, '1001500', '1011500'),
(138, 'Abdullahi Mamood', '1008389115', 'Checking Account', '500', '11001500', 'Debit', 'Success', 'International transfer via Wire Transfer | Payments', '2026-04-30 01:40:01', 'Abdullahi Mamood', 'International Transfer', 'Checking Account', 'UBA', 'Alabama, United State, United States', NULL, NULL, '11002000', '11001500'),
(137, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '50000', '10952000', 'Debit', 'Success', 'Light Bill', '2026-09-10 11:43:00', NULL, 'Deposit', 'Checking Account', NULL, NULL, NULL, NULL, '11002000', '10952000'),
(136, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '10000000', '11002000', 'Credit', 'Success', 'Notice of Successful Account Top Up', '2026-04-29 10:18:57', NULL, 'Deposit', NULL, NULL, NULL, NULL, NULL, '1002000.00', '11002000'),
(135, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '10000', '1002000', 'Credit', 'Success', 'Notice of Successful Account Top Up', '2026-04-29 10:17:55', NULL, 'Deposit', NULL, NULL, NULL, NULL, NULL, '992000.00', '1002000'),
(134, 'BTC (Native)', '1008389115', 'Checking Account', '0.00001', '9.097E-5', 'Debit', 'Success', 'International transfer via Cryptocurrency', '2026-04-29 18:34:41', 'BTC (Native)', 'International Transfer', 'Checking Account', 'Cryptocurrency', '', NULL, NULL, '0.00010097', '9.097E-5'),
(133, 'BTC (Native)', '1008389115', 'Checking Account', '0.00009', '6.75E-6', 'Debit', 'Success', 'International transfer via Cryptocurrency', '2026-04-29 05:54:23', 'BTC (Native)', 'International Transfer', 'Checking Account', 'Cryptocurrency', '', NULL, NULL, '9.675E-5', '6.75E-6'),
(132, 'BTC (Native)', '1008389115', 'Checking Account', '0.00009', '1001999.99991', 'Debit', 'Success', 'International transfer via Cryptocurrency', '2026-04-29 05:11:45', 'BTC (Native)', 'International Transfer', 'Checking Account', 'Cryptocurrency', '', NULL, NULL, '1002000', '1001999.99991'),
(131, 'Godsent Kadiri', '1008389115', 'Checking Account', '1000', '1002000', 'Debit', 'Success', 'International transfer via Wire Transfer', '2026-04-29 05:09:03', 'Godsent Kadiri', 'International Transfer', 'Checking Account', 'UBA', 'Old Jetu Road, Nigeria', NULL, NULL, '1003000', '1002000'),
(130, 'Abdullahi Mamood', '1008389115', 'Checking Account', '1000', '1003000', 'Debit', 'Pending', 'International transfer via Wire Transfer', '2026-04-29 05:03:38', 'Abdullahi Mamood', 'International Transfer', 'Checking Account', 'UBA', 'Alabama, United State, United States', NULL, NULL, '1004000', '1003000'),
(129, 'Godsent Kadiri', '1008389115', 'Checking Account', '1000', '1004000', 'Debit', 'Success', 'International transfer via Wire Transfer', '2026-04-29 04:56:20', 'Godsent Kadiri', 'International Transfer', 'Checking Account', 'UBA', 'Old Jetu Road, Nigeria', NULL, NULL, '1005000', '1004000'),
(128, 'Abdullahi Mamood', '1008389115', 'Checking Account', '1000', '1005000', 'Debit', 'Pending', 'International transfer via Wire Transfer | Payment', '2026-04-29 04:45:40', 'Abdullahi Mamood', 'International Transfer', 'Checking Account', 'UBA', 'Alabama, United State, United States', NULL, NULL, '1006000', '1005000'),
(127, 'Abdullahi Mamood', '1008389115', 'Checking Account', '1000', '1006000', 'Debit', 'Pending', 'International transfer via Wire Transfer', '2026-04-29 04:27:41', 'Abdullahi Mamood', 'International Transfer', 'Checking Account', 'UBA', 'Old Jetu Road, Nigeria', NULL, NULL, '1007000', '1006000'),
(126, 'Abdullahi Mamood', '1008389115', 'Checking Account', '1000', '1007000', 'Debit', 'Pending', 'International transfer via Wire Transfer', '2026-04-29 04:13:41', 'Abdullahi Mamood', 'International Transfer', 'Checking Account', 'UBA', 'Alabama, United State, United States', NULL, NULL, '1008000', '1007000'),
(125, 'kadiri precious', '1008389115', 'Online Banking', '400', '1008000', 'Debit', 'Success', 'Local transfer to kadiri precious (UBA) | Payment', '2026-04-29 03:56:47', 'kadiri precious', 'Local Transfer', 'Online Banking', 'UBA', NULL, NULL, NULL, '1008400', '1008000'),
(124, 'kadiri precious', '1008389115', 'Online Banking', '500', '1008400', 'Debit', 'Success', 'Local transfer to kadiri precious (UBA) | Payment', '2026-04-29 02:36:45', 'kadiri precious', 'Local Transfer', 'Online Banking', 'UBA', NULL, NULL, NULL, '1008900', '1008400'),
(123, 'Godsent Abel Kadiri', '1008389115', 'Checking', '40000', '970000.00', 'Debit', 'Success', 'Payment', '2026-02-20 13:31:22', 'Godsent Kadiri', 'International Transfer', 'Checking', 'Gt bank', 'Alabama, United State', 'United States', 'IBC-638362892', '1010000.00', '970000.00'),
(122, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '40000', '1050000', 'Credit', 'Successful', 'Lagoc', '2026-02-02 13:50:11', NULL, 'Loan', 'Checking Account', NULL, NULL, NULL, NULL, '1010000', '1050000'),
(121, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '40000', '1050000', 'Credit', 'Successful', 'Lagoc', '2026-02-01 13:50:11', NULL, 'Loan', 'Checking Account', NULL, NULL, NULL, NULL, '1010000', '1050000'),
(120, 'Godsent Abel Kadiri', '1008389115', 'Checking Account', '1000000', '2010000', 'Credit', 'Successful', '', '2026-09-10 11:43:00', NULL, 'Deposit', 'Checking Account', NULL, NULL, NULL, NULL, '1010000', '2010000');

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

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

CREATE TABLE `transfer` (
  `id` int(11) NOT NULL,
  `receiver_fullname` varchar(255) DEFAULT NULL,
  `acc_no` varchar(255) DEFAULT NULL,
  `acc_type` varchar(255) DEFAULT NULL,
  `receiver_bank_name` varchar(255) DEFAULT NULL,
  `receiver_bank_address` varchar(255) DEFAULT NULL,
  `receiver_bank_country` varchar(255) DEFAULT NULL,
  `iban` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `prev_bal` varchar(255) DEFAULT NULL,
  `new_bal` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `transfer_type` varchar(255) DEFAULT NULL,
  `sender_acc_no` varchar(255) DEFAULT NULL,
  `stat` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Success',
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `transfer` (`id`, `receiver_fullname`, `acc_no`, `acc_type`, `receiver_bank_name`, `receiver_bank_address`, `receiver_bank_country`, `iban`, `amount`, `prev_bal`, `new_bal`, `reason`, `transfer_type`, `sender_acc_no`, `stat`, `status`, `date_added`) VALUES
(93, 'Keanu Reeves', NULL, 'Checking', NULL, NULL, NULL, NULL, '151,704.11', NULL, '151', 'Notice of Successful Account Top Up', 'Credit', '2188217393', NULL, 'Success', '08:04:pm 22 April 2023'),
(94, 'Keanu Reeves', NULL, 'Checking', NULL, NULL, NULL, NULL, '151,000.00', NULL, '302', 'Notice of Successful Account Top Up', 'Credit', '2188217393', NULL, 'Success', '08:06:pm 22 April 2023'),
(136, 'Godsent Abel Kadiri', NULL, 'Checking Account', NULL, NULL, NULL, NULL, '10000', NULL, '1010000', 'Notice of Successful Account Top Up', 'Credit', '1008389115', NULL, 'Success', '28/04/2026');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `residential_address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `date_of_birth` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `acc_type` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `pin` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `confirm_password` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `balance` float(180,2) NOT NULL DEFAULT 0.00,
  `reset_token` varchar(255) DEFAULT NULL,
  `profile_img` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `otp` varchar(255) DEFAULT NULL,
  `account_status` varchar(225) NOT NULL DEFAULT 'Pending',
  `date_added` varchar(255) NOT NULL,
  `username` varchar(225) NOT NULL,
  `acc_limit` decimal(10,0) NOT NULL DEFAULT 500000,
  `btcBalance` decimal(18,8) DEFAULT 0.00000000,
  `allowTransactions` varchar(255) DEFAULT 'Yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `fullname`, `residential_address`, `city`, `state`, `country`, `email`, `phone_number`, `date_of_birth`, `gender`, `acc_type`, `currency`, `pin`, `password`, `confirm_password`, `acc_no`, `balance`, `reset_token`, `profile_img`, `type`, `size`, `otp`, `account_status`, `date_added`, `username`, `acc_limit`, `btcBalance`, `allowTransactions`) VALUES
(5, 'Godsent Abel Kadiri', '', '', '', 'United States of America', 'prechizo.e@gmail.com', '+2349042651702', '', 'Male', 'Checking Account', 'USD', '1234', '$2y$10$VPKAGd..zXX.cTBngHhWKeCH2yh3tfLg7x4wOIwPkSDvwjP.OIzN2', 'softproweb11', '1008389115', 1011500.00, NULL, 'user_1778930554_2231.jpeg', NULL, NULL, '', 'Active', '2026-04-26 22:37:03', 'softproweb1', 500000, 131.93665587, 'No');

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` int(11) NOT NULL,
  `visitor` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `visitor`) VALUES
(1, '1');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `administrator`
--
ALTER TABLE `administrator`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

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

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

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

--
-- Indexes for table `support_replies`
--
ALTER TABLE `support_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_id` (`ticket_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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