-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 12, 2022 at 03:47 AM
-- Server version: 10.3.36-MariaDB-log-cll-lve
-- PHP Version: 7.4.30

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

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `acct_username` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `firstname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_no` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '0=deactive,1=active',
  `acct_balance` double DEFAULT 0,
  `loan_balance` double DEFAULT 0,
  `acct_limit` double DEFAULT NULL,
  `limit_remain` double DEFAULT NULL,
  `acct_type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_gender` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `marital_status` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_currency` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_status` varchar(50) COLLATE utf8_unicode_ci DEFAULT 'active' COMMENT 'active, hold',
  `acct_email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_occupation` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_dob` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `ssn` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `frontID` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `backID` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_password` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_pin` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_otp` int(11) DEFAULT NULL,
  `acct_cot` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `acct_imf` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `acct_tax` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `mgr_name` text COLLATE utf8_unicode_ci NOT NULL,
  `mgr_no` text COLLATE utf8_unicode_ci NOT NULL,
  `mgr_email` text COLLATE utf8_unicode_ci NOT NULL,
  `mgr_id` text COLLATE utf8_unicode_ci NOT NULL,
  `mgr_image` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `acct_address` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `users` (`id`, `acct_username`, `firstname`, `lastname`, `image`, `acct_no`, `billing_code`, `acct_balance`, `loan_balance`, `acct_limit`, `limit_remain`, `acct_type`, `acct_gender`, `marital_status`, `acct_currency`, `acct_status`, `acct_email`, `acct_phone`, `acct_occupation`, `acct_dob`, `ssn`, `frontID`, `backID`, `country`, `state`, `acct_password`, `acct_pin`, `acct_otp`, `acct_cot`, `acct_imf`, `acct_tax`, `mgr_name`, `mgr_no`, `mgr_email`, `mgr_id`, `mgr_image`, `acct_address`, `createdAt`) VALUES
(5, 'bryte', 'bryte', 'david', '1661883382favicon.png', '123456789', 0, 19999997760, 0, NULL, -2240, 'Savings', 'male', NULL, 'USD', 'active', 'brytedree@gmail.com', '24387906453', 'miner', '2022-08-09', '12345678', '1661883382favicon.png', '1661883382favicon.png', 'Bangladesh', 'New york', '$2y$10$R01tHtUBSJ3z4UhMUcg9n.D0cxT3iANXz2RIURHkjzJMi6ePhSVeG', '1234', 179475, '', '', '', '', '', '', '', NULL, 'queens 34 California  New york 3245324', '2022-08-30 20:16:22'),
(7, 'Attwillant', 'leo', 'yhi', '1661960865IMG_2794.webp', '9909898212', 0, 0, 0, NULL, NULL, 'Savings', 'male', NULL, 'USD', 'hold', 'att.willlant@gmail.com', '9297387280', 'Driver ', '1985-04-06', '1234567', '16619608656c60fc1e7ace8ec80f659ff649167649.jpg', '16619608650db5c76c79fd85aeb1c8d4c2b66796d8.jpg', 'United States of America', 'New York', '$2y$10$XeWU7FJEiKs0RrMaix78eO19CTpSgCpK5bDrls5kpfF.iu2ufaD46', '1234', NULL, '', '', '', '', '', '', '', NULL, 'Rss 13 unit 4 87391 Buffalo New York 14209', '2022-08-31 17:47:45');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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