-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 09, 2022 at 06:01 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: `scrixuez_smartbank`
--

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

--
-- Table structure for table `activitylog`
--

CREATE TABLE `activitylog` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `ip` varchar(100),
  `browser` varchar(100),
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activitylog`
--

INSERT INTO `activitylog` (`id`, `email`, `ip`, `browser`, `date`) VALUES
(1, 'admin@yourdomain.com', '12.456.64.21', '', '2022-01-29 15:17:24'),
(2, 'admin@yourdomain.com', '12.456.64.21', '', '2022-01-29 15:17:29');

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(6) NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `email`, `password`, `token`) VALUES
(1, 'admin@yourdomain.com', '0192023a7bbd73250516f069df18b500', 'INpA6zMHXJ');

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

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

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_region` varchar(100) NOT NULL DEFAULT 'local'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `banks` (`id`, `bank_name`, `bank_region`) VALUES
(1, 'Zenith Bank PLC', 'local'),
(2, 'Access Bank PLC', 'local'),
(4, 'Bitcoin Bank', 'international'),
(5, 'Eco Bank', 'international');

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

--
-- Table structure for table `beneficiaries`
--

CREATE TABLE `beneficiaries` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `account` varchar(20) NOT NULL,
  `bank` varchar(500) NOT NULL,
  `method` varchar(100) NOT NULL DEFAULT 'local',
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `userid` int(11) NOT NULL,
  `country` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `beneficiaries`
--

INSERT INTO `beneficiaries` (`id`, `name`, `account`, `bank`, `method`, `date`, `userid`, `country`) VALUES
(3, 'John wick', '11212232222', 'Bitcoin Bank', 'international', '2022-09-30 01:35:22', 271, 'JO'),
(4, 'Wow User', '5670925805', 'Access Bank PLC', 'local', '2022-10-01 02:47:40', 272, 'MY'),
(5, 'Alfred Firm', '2930863816', 'Zenith Bank PLC', 'local', '2022-10-07 02:02:21', 273, 'JM'),
(6, 'Dorime Group', '428493245', 'Access Bank PLC', 'local', '2022-10-08 06:18:58', 273, 'JM');

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

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

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `network` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rate` double DEFAULT NULL,
  `usd` double NOT NULL,
  `btctnx` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(45) NOT NULL DEFAULT 0,
  `tnxid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `loan` (
  `id` int(11) NOT NULL,
  `account` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `amount` int(200) NOT NULL,
  `duration` varchar(200) NOT NULL,
  `reason` varchar(200) DEFAULT NULL,
  `loanid` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `lt` varchar(100) DEFAULT NULL,
  `status` int(19) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `md`
--

CREATE TABLE `md` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `account` varchar(200) NOT NULL,
  `cheque` varchar(200) DEFAULT NULL,
  `amount` varchar(200) NOT NULL DEFAULT '0',
  `cid` varchar(200) NOT NULL,
  `status` int(200) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messageadmin`
--

CREATE TABLE `messageadmin` (
  `id` int(100) NOT NULL,
  `account` varchar(100) NOT NULL,
  `message` longtext DEFAULT NULL,
  `reply` longtext DEFAULT NULL,
  `msgid` varchar(199) NOT NULL,
  `status` int(10) NOT NULL DEFAULT 0,
  `astatus` int(23) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `net_abbr` varchar(10) NOT NULL,
  `net_name` varchar(225) NOT NULL,
  `net_addr` varchar(100) NOT NULL,
  `net_icon` varchar(100) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `net_abbr`, `net_name`, `net_addr`, `net_icon`, `date`, `status`) VALUES
(1, 'BTC', 'Bitcoin', 'bc1qv2ev7qygcf5q7glutfhxvhlyxwda26qgmpllp6', 'f7110d794176790cc4618f846f7df52c.jpeg', '2022-10-08 13:11:48', 1),
(2, 'ETH', 'Etherium', '0xA3Fefc7Cd98C92A355B83D0D8aF8749F83cb024a', '464654fc0f9aae0964c4f0f8851f4f63.jpeg', '2022-10-08 13:12:23', 1);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `_ref` int(11) DEFAULT NULL,
  `_key` varchar(255) NOT NULL,
  `_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `_ref`, `_key`, `_value`) VALUES
(40, NULL, 'currency', '\"$\"'),
(41, NULL, 'bname', '\"Smart Business\"'),
(42, NULL, 'logo', '\"949cf699001b049b5714dbcf05f39042.png\"'),
(43, NULL, 'email', '\"info@yourdomain.com\"'),
(44, NULL, 'phone', '\"+1234567899876\"'),
(45, NULL, 'baddress', '\"Smart Address\"'),
(46, NULL, 'title', '\"Welcome to Smart Business\"'),
(47, NULL, 'branch', '\"\"'),
(48, NULL, 'sname', '\"Smart Busuness\"'),
(49, NULL, 'charges', '\"0\"'),
(50, NULL, 'apipu', '\"\"'),
(51, NULL, 'apipr', '\"\"'),
(52, NULL, 'email_api', '\"1\"'),
(53, NULL, 'btc_wallet', '\"1L8XPNPjtenqBkhdpp5CTPfjKVqy5u4RVT\"'),
(54, NULL, 'news', '\"Hey we giving 50% bonus for every new registered account.\"'),
(55, NULL, 'sms_api', '\"0\"'),
(56, NULL, 'email_otp', '\"0\"'),
(57, NULL, 'account_types', '[\"current account\",\"professional account\",\"savings account\",\"fixed deposit account\"]'),
(58, NULL, 'transfer_codes', '{\"imf\":{\"code_type\":\"auto\",\"code_value\":null},\"cot\":{\"code_type\":\"static\",\"code_value\":\"2234\"},\"sars\":{\"code_type\":\"static\",\"code_value\":\"3601\"},\"tax\":{\"code_type\":\"auto\",\"code_value\":null}}'),
(59, NULL, 'address', '\"No 2 United Smart Street\"');

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

--
-- Table structure for table `tbl_transaction`
--

CREATE TABLE `tbl_transaction` (
  `id` int(10) NOT NULL,
  `tx_no` varchar(20) NOT NULL,
  `tx_type` varchar(10) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `date` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `to_accno` varchar(20) DEFAULT NULL,
  `account` varchar(100) DEFAULT NULL,
  `status` varchar(10) NOT NULL,
  `comments` varchar(200) DEFAULT NULL,
  `charges` double NOT NULL DEFAULT 0,
  `method` varchar(100) DEFAULT NULL,
  `bank_name` varchar(500) NOT NULL,
  `beneficiary` varchar(500) NOT NULL,
  `sender_name` varchar(500) DEFAULT NULL,
  `country` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(10) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(40) NOT NULL,
  `pwd` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `utype` varchar(100) DEFAULT NULL,
  `pics` varchar(200) DEFAULT NULL,
  `bdate` varchar(100) DEFAULT NULL,
  `acctno` double DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `pin` varchar(100) DEFAULT NULL,
  `balance` double NOT NULL DEFAULT 0,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zipcode` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `ssn` varchar(100) DEFAULT NULL,
  `rtn` varchar(200) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `acone` tinyint(4) NOT NULL DEFAULT 0,
  `actwo` tinyint(4) NOT NULL DEFAULT 0,
  `rdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `otp_hash` varchar(100) DEFAULT NULL,
  `card` varchar(200) DEFAULT NULL,
  `cardt` varchar(200) DEFAULT NULL,
  `month` int(200) DEFAULT NULL,
  `csv` int(100) DEFAULT NULL,
  `carddate` timestamp NOT NULL DEFAULT current_timestamp(),
  `sstatus` int(11) NOT NULL DEFAULT 0,
  `yr` int(200) DEFAULT NULL,
  `kyc` int(10) NOT NULL DEFAULT 0,
  `kyc_image` varchar(60) DEFAULT NULL,
  `token` varchar(100) DEFAULT NULL,
  `_json` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`id`, `fname`, `lname`, `pwd`, `email`, `phone`, `gender`, `utype`, `pics`, `bdate`, `acctno`, `active`, `status`, `pin`, `balance`, `address`, `city`, `state`, `zipcode`, `country`, `ssn`, `rtn`, `ip`, `acone`, `actwo`, `rdate`, `otp_hash`, `card`, `cardt`, `month`, `csv`, `carddate`, `sstatus`, `yr`, `kyc`, `kyc_image`, `token`, `_json`) VALUES
(273, 'Trial', 'User', '25d55ad283aa400af464c76d713c07ad', 'user@trial.com', '12345678909876', 'Male', 'current account', '79997e1c8bcd71b1284e0da52d5b4aec.jpeg', '1960-11-08', 1443820245, 1, 1, 'b59c67bf196a4758191e42f76670ceba', 453556, 'ewt345 add abuje gtr gf dgthth', 'DA', 'LA', '100002', 'JM', '234567', '1234567', '', 1, 0, '2022-10-07 01:17:27', 'c8cd63e1bf13c5016881652983fb615a', '', '', 0, 0, '2022-10-07 01:17:27', 0, 0, 0, '712a5db77d6590039909032d50cd373b.png', 'D?nUVMpT/k', '{\"transfer_email_otp\":\"5uqii\",\"transfer_codes\":{\"imf\":\"2308\",\"ipn\":\"7736\",\"tax\":\"4855\"}}');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_columns` (`email`,`acctno`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `messageadmin`
--
ALTER TABLE `messageadmin`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

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

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

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

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