-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Dec 01, 2023 at 01:54 PM
-- Server version: 5.7.39
-- PHP Version: 7.4.33

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

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

--
-- Table structure for table `admin_tb`
--

CREATE TABLE `admin_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `level` varchar(200) NOT NULL,
  `is_email_validated` varchar(200) NOT NULL,
  `is_blocked` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin_tb`
--

INSERT INTO `admin_tb` (`id`, `unique_id`, `email`, `full_name`, `username`, `password`, `level`, `is_email_validated`, `is_blocked`, `is_deleted`, `created_at`, `updated_at`) VALUES
(3, 'TL1604753769SX', 'tester1@gmail.com', 'tester', 'tester1', '$6$rounds=1000$YourSaltyStringz$is.oFzwzGH8kXoq8D8vqJr.UCodEDahfxxT39pnevLeF9xEVQQ/GUBT9wrKURyLNfvQQw528hRHOmBH2FgdP70', '1', '0', '0', '0', 'November 7, 2020, 12:56 pm', 'December 8, 2020, 2:27 am'),
(7, 'XA1607147363RK', 'tester2@gmail.com', 'jack', 'tester2', '$6$rounds=1000$YourSaltyStringz$HGG/Xl3qJhY.QdomY/ALvB/0YtWtM2rD8haSW8cLHgBCSXglCUnqgqeafzQRY5TMjaePYTqK4BJ6OWaEENk0W/', '2', '0', '0', '1', 'December 5, 2020, 5:49 am', 'December 11, 2020, 9:29 pm'),
(10, 'RE1607727776BV', 'admin@trustfort.com', 'admin ', '', '$6$rounds=1000$YourSaltyStringz$KaSmOGpK98N2POEJxeIUIdchcnCaOoHyDLY9AWYHz0kCsecJYKt7Pl0AHHBDXYxjcjz9PEir3BUOqoadVXl3S/', '2', '', '0', '0', 'December 11, 2020, 11:02 pm', 'December 11, 2020, 11:02 pm'),
(11, 'XC1684551491OP', 'tester2@gmail.com', 'admin', '', '$6$rounds=1000$YourSaltyStringz$HGG/Xl3qJhY.QdomY/ALvB/0YtWtM2rD8haSW8cLHgBCSXglCUnqgqeafzQRY5TMjaePYTqK4BJ6OWaEENk0W/', '2', '', '0', '0', 'May 20, 2023, 2:58 am', 'May 20, 2023, 2:58 am');

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

--
-- Table structure for table `category_tb`
--

CREATE TABLE `category_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_tb`
--

INSERT INTO `category_tb` (`id`, `unique_id`, `name`, `is_deleted`, `created_at`, `updated_at`) VALUES
(3, 'JD1684522604MK', ' USA BANK LOGS', '0', 'May 19, 2023, 6:56 pm', 'May 19, 2023, 6:56 pm'),
(4, 'RF1684522617YX', ' UK BANK LOGINS', '0', 'May 19, 2023, 6:56 pm', 'May 19, 2023, 6:56 pm'),
(5, 'SR1684522626AB', ' CANADA BANK LOGINS', '0', 'May 19, 2023, 6:57 pm', 'May 19, 2023, 6:57 pm'),
(6, 'TT1684522656VA', 'Chase Bank Logs New', '1', 'May 19, 2023, 6:57 pm', 'May 19, 2023, 7:02 pm'),
(7, 'JV1684522720VX', 'Wells Fago Bank logsNew', '1', 'May 19, 2023, 6:58 pm', 'May 19, 2023, 7:02 pm');

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

--
-- Table structure for table `currencies_tb`
--

CREATE TABLE `currencies_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `admin_wallet_address` varchar(200) NOT NULL,
  `symbol` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currencies_tb`
--

INSERT INTO `currencies_tb` (`id`, `unique_id`, `name`, `admin_wallet_address`, `symbol`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'TN1605616253SO', 'Bitcoin', '17sA6owSRYLd2tSbJfezo4XTTcUA6XiPZ8 ', 'BTC', '0', 'November 17, 2020, 12:30 pm', 'May 25, 2021, 12:51 pm'),
(2, 'YS1605616281SC', 'Ethereum', 'BcUQaastAnpyiptJhgDwq', 'ETH', '1', 'November 17, 2020, 12:31 pm', 'April 7, 2021, 2:39 pm'),
(3, 'YZ1605616303XD', 'Btc Cash', 'TdkBVRz6sUJNedZAy', 'BCH', '1', 'November 17, 2020, 12:31 pm', 'April 7, 2021, 2:38 pm'),
(5, 'JK1605616353VU', 'Stellar', 'VRz6sUJNedZAyBcU', 'XLM', '1', 'November 17, 2020, 12:32 pm', 'April 7, 2021, 2:38 pm'),
(6, 'XA1605616366JE', 'Tether', 'VRz6sUJNedZAyUJH', 'USDT', '1', 'November 17, 2020, 12:32 pm', 'April 7, 2021, 2:38 pm'),
(7, 'RG1605616429RA', 'Algorand', 'aastAnpyiptJhgD', 'ALGO', '1', 'November 17, 2020, 12:33 pm', 'April 7, 2021, 2:38 pm'),
(9, 'SR1605616488JH', 'Litecoin', 'f8956HvLEzcQUZc5WR', 'LTC', '1', 'November 17, 2020, 12:34 pm', 'April 7, 2021, 2:38 pm'),
(10, 'SJ1607705391VB', 'test', 'test', 'test', '1', 'December 11, 2020, 4:49 pm', 'December 11, 2020, 5:51 pm'),
(12, 'TA1607722961RB', 'test', 'UA1P9H32AHM7qwQUqKaGW', 'test', '1', 'December 11, 2020, 9:42 pm', 'December 11, 2020, 9:44 pm'),
(13, 'RE1617849636RD', 'Ethereum', 'MuZUKQZcUA1P9H32AHM7qwQUqKaGWXjeV', 'ETH', '1', 'April 8, 2021, 2:40 am', 'May 25, 2021, 12:50 pm'),
(14, 'RG1617849647XC', 'Litecoin', 'qrjg90wk8c75yfkq208y4fla06u2t4a30uemaay2hy', 'LTC', '1', 'April 8, 2021, 2:40 am', 'May 25, 2021, 12:50 pm'),
(15, 'JX1617849666RB', 'Dodgecoin', '0x15502955ed65D64C1747E53c8F8bC520467731Aa', 'DOGE', '1', 'April 8, 2021, 2:41 am', 'May 25, 2021, 12:50 pm'),
(16, 'YX1700986893RB', 'USDT Tether', '0x27E904a9934EC86C69a32Ae3C4503F47897Ff54b', 'USDT', '0', 'November 26, 2023, 8:21 am', 'November 26, 2023, 8:21 am');

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

--
-- Table structure for table `investment_plan_tb`
--

CREATE TABLE `investment_plan_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `investment_plan_tb`
--

INSERT INTO `investment_plan_tb` (`id`, `unique_id`, `name`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'YZ1622029141UY', 'usa bank logs', '0', 'November 11, 2020, 2:03 am', 'May 16, 2023, 5:34 pm'),
(7, 'TV1684258481WO', 'uk bank logs', '0', 'May 16, 2023, 5:34 pm', 'May 16, 2023, 5:34 pm');

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

--
-- Table structure for table `package_tb`
--

CREATE TABLE `package_tb` (
  `id` int(200) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `investment_id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `min_amt` varchar(200) NOT NULL,
  `max_amt` varchar(200) NOT NULL,
  `total_percentage` varchar(200) NOT NULL,
  `daily_percentage` varchar(200) NOT NULL,
  `no_of_days` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package_tb`
--

INSERT INTO `package_tb` (`id`, `unique_id`, `investment_id`, `name`, `min_amt`, `max_amt`, `total_percentage`, `daily_percentage`, `no_of_days`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'RW1622029200XB', 'YZ1622029141UY', 'Stellar ', '100', '24999', '521.95', '1.7039726027397', '365', '0', 'May 26, 2021, 7:40 am', 'May 29, 2021, 6:00 am'),
(2, 'SX1622280942VO', 'YZ1622029141UY', 'Stellar 2', '100', '24999', '521.95', '1.7039726027397', '365', '1', 'May 29, 2021, 5:35 am', 'May 29, 2021, 6:00 am'),
(3, 'XI1622282257RW', 'YZ1622029141UY', 'Silver ', '25000', '49999', '651.8', '2.0597260273973', '365', '0', 'May 29, 2021, 5:57 am', 'May 29, 2021, 5:57 am'),
(4, 'KN1622282360RK', 'YZ1622029141UY', 'Gold ', '50000', '99999', '782', '2.4164383561644', '365', '0', 'May 29, 2021, 5:59 am', 'May 29, 2021, 5:59 am'),
(5, 'KJ1622282577JL', 'YZ1622029141UY', 'Platinum ', '100000', '1000000', '1042.9', '3.1312328767123', '365', '0', 'May 29, 2021, 6:02 am', 'May 29, 2021, 6:03 am');

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

--
-- Table structure for table `product_tb`
--

CREATE TABLE `product_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL,
  `subcategory_id` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `includes` text NOT NULL,
  `balance` varchar(200) NOT NULL,
  `price` varchar(200) NOT NULL,
  `file_name` varchar(200) DEFAULT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_tb`
--

INSERT INTO `product_tb` (`id`, `unique_id`, `category_id`, `subcategory_id`, `status`, `type`, `includes`, `balance`, `price`, `file_name`, `is_deleted`, `created_at`, `updated_at`) VALUES
(6, 'IH1684547236JL', 'SR1684522626AB', 'SV1684523539XA', 'Sold Out', 'Checkings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	', '15000', '150', 'sv1701013219kj.zip', '0', 'May 20, 2023, 1:47 am', 'November 26, 2023, 3:40 pm'),
(7, 'XD1684547256TN', 'SR1684522626AB', 'SX1684523468KJ', 'Available', 'Savings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	', '20000', '2000', NULL, '0', 'May 20, 2023, 1:47 am', 'May 20, 2023, 1:47 am'),
(8, 'CD1684547276WU', 'RF1684522617YX', 'XA1684523549SC', 'Available', 'Savings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	', '12000', '120', NULL, '0', 'May 20, 2023, 1:47 am', 'May 20, 2023, 1:47 am'),
(9, 'RW1684547294FX', 'RF1684522617YX', 'KJ1684523507VU', 'Available', 'Checkings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	', '1300', '130', NULL, '0', 'May 20, 2023, 1:48 am', 'May 20, 2023, 1:48 am'),
(10, 'FX1684547310CD', 'JD1684522604MK', 'RJ1684523562TZ', 'Available', 'Savings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	                                                        ', '5000', '500', NULL, '0', 'May 20, 2023, 1:48 am', 'November 26, 2023, 11:54 am'),
(11, 'RH1684547327RK', 'JD1684522604MK', 'KN1684523525IH', 'Available', 'Checkings Account', 'Email Access,ssn,debit card, routing,account number,zip Code,Tel Pin, Phone Number, Wire Enabled	', '2000', '200', NULL, '0', 'May 20, 2023, 1:48 am', 'May 20, 2023, 1:48 am');

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

--
-- Table structure for table `purchase_tb`
--

CREATE TABLE `purchase_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL,
  `subcategory_id` varchar(200) NOT NULL,
  `product_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase_tb`
--

INSERT INTO `purchase_tb` (`id`, `unique_id`, `category_id`, `subcategory_id`, `product_id`, `user_id`, `status`, `is_deleted`, `created_at`, `updated_at`) VALUES
(6, 'RF1684547606SB', 'SR1684522626AB', 'SV1684523539XA', 'IH1684547236JL', 'RE1622773325BV', 'confirmed', '0', 'May 20, 2023, 1:53 am', 'May 20, 2023, 2:19 am'),
(7, 'JU1701013565XR', 'JD1684522604MK', 'RJ1684523562TZ', 'FX1684547310CD', 'RE1622773325BV', 'pending', '0', 'November 26, 2023, 3:46 pm', 'November 26, 2023, 3:46 pm');

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

--
-- Table structure for table `referrer_bonus_tb`
--

CREATE TABLE `referrer_bonus_tb` (
  `id` int(200) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `txn_id` varchar(200) NOT NULL,
  `referrer_id` varchar(200) NOT NULL,
  `investor_id` varchar(200) NOT NULL,
  `amt_in_usd` varchar(200) NOT NULL,
  `coin_id` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `settings_tb`
--

CREATE TABLE `settings_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `acct_xpub_address` varchar(200) NOT NULL,
  `referrer_percentage` varchar(200) NOT NULL,
  `deposit_type` varchar(200) NOT NULL,
  `site_logo` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings_tb`
--

INSERT INTO `settings_tb` (`id`, `unique_id`, `acct_xpub_address`, `referrer_percentage`, `deposit_type`, `site_logo`, `phone`, `address`, `updated_at`) VALUES
(1, '', '', '5', 'by_wallet', '', '', '', 'April 10, 2021, 6:59 am');

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

--
-- Table structure for table `subcategory_tb`
--

CREATE TABLE `subcategory_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `category_id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subcategory_tb`
--

INSERT INTO `subcategory_tb` (`id`, `unique_id`, `category_id`, `name`, `is_deleted`, `created_at`, `updated_at`) VALUES
(3, 'SX1684523468KJ', 'SR1684522626AB', 'Chase Bank Logs', '0', 'May 19, 2023, 7:11 pm', 'May 20, 2023, 1:49 am'),
(4, 'KJ1684523507VU', 'RF1684522617YX', 'Wells Fago Bank logs', '0', 'May 19, 2023, 7:11 pm', 'May 20, 2023, 1:50 am'),
(5, 'KN1684523525IH', 'JD1684522604MK', 'Hsbc Bank Logs', '0', 'May 19, 2023, 7:12 pm', 'May 20, 2023, 1:50 am'),
(6, 'SV1684523539XA', 'SR1684522626AB', 'Suntrust Bank logs', '0', 'May 19, 2023, 7:12 pm', 'May 20, 2023, 1:49 am'),
(7, 'XA1684523549SC', 'RF1684522617YX', 'Capital One Bank Logs', '0', 'May 19, 2023, 7:12 pm', 'May 20, 2023, 1:50 am'),
(8, 'RJ1684523562TZ', 'JD1684522604MK', 'Cashapp Logs', '0', 'May 19, 2023, 7:12 pm', 'May 20, 2023, 1:50 am');

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

--
-- Table structure for table `support_tb`
--

CREATE TABLE `support_tb` (
  `id` int(200) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `main_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `message` varchar(200) NOT NULL,
  `main` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `support_tb`
--

INSERT INTO `support_tb` (`id`, `unique_id`, `main_id`, `user_id`, `title`, `message`, `main`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'VA1684255877XB', 'VA1684255877XB', 'TA1684253280WO', 'heelo', 'help me!\r\n', '1', '0', 'May 16, 2023, 4:51 pm', 'May 16, 2023, 4:51 pm'),
(2, 'YE1700985005TX', 'YE1700985005TX', 'RE1622773325BV', 'hello', 'hi', '1', '0', 'November 26, 2023, 7:50 am', 'November 26, 2023, 7:50 am');

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

--
-- Table structure for table `transaction_tb`
--

CREATE TABLE `transaction_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `investment_type_id` varchar(200) NOT NULL,
  `coin_type_id` varchar(200) NOT NULL,
  `plan_id` varchar(200) NOT NULL,
  `amt_in_usd` varchar(200) NOT NULL,
  `amt_in_currency` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `date_confirmed` varchar(200) NOT NULL,
  `interest_in_usd` varchar(200) NOT NULL,
  `day_counter` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction_tb`
--

INSERT INTO `transaction_tb` (`id`, `unique_id`, `user_id`, `investment_type_id`, `coin_type_id`, `plan_id`, `amt_in_usd`, `amt_in_currency`, `status`, `date_confirmed`, `interest_in_usd`, `day_counter`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'RB1622801039JU', 'RE1622773325BV', 'YZ1622029141UY', 'TN1605616253SO', 'RW1622029200XB', '2000', '0.054263319813627', 'confirmed', 'June 4, 2021, 10:08 am', '34.079452054794', '1', '0', 'June 4, 2021, 10:03 am', 'June 4, 2021, 10:12 am');

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

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` int(11) NOT NULL,
  `user_unique_id` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `passport` varchar(200) NOT NULL,
  `referrer` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`id`, `user_unique_id`, `phone`, `address`, `country`, `passport`, `referrer`, `is_deleted`, `created_at`, `updated_at`) VALUES
(2, 'RE1622773325BV', '123', 'xyz', 'Afganistan', 'avatar.png', '', '0', 'June 4, 2021, 2:22 am', 'November 26, 2023, 1:31 pm'),
(3, 'TA1684253280WO', '', '', '', 'yz1684256037sj.jpeg', '', '0', 'May 16, 2023, 4:08 pm', 'May 16, 2023, 4:53 pm'),
(4, 'TC1684253439RB', '', '', '', 'avatar.png', '', '0', 'May 16, 2023, 4:10 pm', 'May 16, 2023, 4:10 pm'),
(5, 'RA1684253617SO', '', '', '', 'avatar.png', '', '0', 'May 16, 2023, 4:13 pm', 'May 16, 2023, 4:13 pm');

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

--
-- Table structure for table `user_tb`
--

CREATE TABLE `user_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `is_email_validated` varchar(200) NOT NULL,
  `is_blocked` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_tb`
--

INSERT INTO `user_tb` (`id`, `unique_id`, `email`, `full_name`, `username`, `password`, `is_email_validated`, `is_blocked`, `is_deleted`, `created_at`, `updated_at`) VALUES
(2, 'RE1622773325BV', 'tester1@gmail.com', 'tester++1', '', '$6$rounds=1000$YourSaltyStringz$is.oFzwzGH8kXoq8D8vqJr.UCodEDahfxxT39pnevLeF9xEVQQ/GUBT9wrKURyLNfvQQw528hRHOmBH2FgdP70', '0', '0', '0', 'June 4, 2021, 2:22 am', 'November 26, 2023, 1:31 pm'),
(3, 'TA1684253280WO', 'kelly@gmail.com', 'kelly++rowland', '', '$6$rounds=1000$YourSaltyStringz$cQB6.lS0lkAp2EtGSv8mMA4QD2hAIO7HIDuW0y//ucdwDONbT/bE2rXUTfwJnJ02ycpTb04fNrSWp18.a7fNy1', '0', '0', '0', 'May 16, 2023, 4:08 pm', 'May 16, 2023, 5:02 pm'),
(4, 'TC1684253439RB', 'tester2@gmail.com', 'tester++2', '', '$6$rounds=1000$YourSaltyStringz$HGG/Xl3qJhY.QdomY/ALvB/0YtWtM2rD8haSW8cLHgBCSXglCUnqgqeafzQRY5TMjaePYTqK4BJ6OWaEENk0W/', '0', '0', '0', 'May 16, 2023, 4:10 pm', 'May 16, 2023, 4:10 pm'),
(5, 'RA1684253617SO', 'tester3@gmail.com', 'tester++3', '', '$6$rounds=1000$YourSaltyStringz$sqHmS0GGLOdrYD0C6dXMuoH/oB8E4y1BbfdhvWerHuAwxwABRsv4TbLc8jXp5fKavdMipYGHV5SvCTUdO.TYN.', '0', '0', '0', 'May 16, 2023, 4:13 pm', 'May 16, 2023, 4:13 pm');

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

--
-- Table structure for table `user_wallet_tb`
--

CREATE TABLE `user_wallet_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `coin_id` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_wallet_tb`
--

INSERT INTO `user_wallet_tb` (`id`, `unique_id`, `user_id`, `coin_id`, `address`, `is_deleted`, `created_at`, `updated_at`) VALUES
(2, 'TZ1622773326SO', 'RE1622773325BV', 'TN1605616253SO', 'UKQZcUA1P9H32AHM7qwQUqKaGWXjeV', '0', 'June 4, 2021, 2:22 am', 'June 4, 2021, 2:23 am'),
(3, 'XI1684253280XB', 'TA1684253280WO', 'TN1605616253SO', '', '0', 'May 16, 2023, 4:08 pm', 'May 16, 2023, 4:08 pm'),
(4, 'RD1684253439JX', 'TC1684253439RB', 'TN1605616253SO', '', '0', 'May 16, 2023, 4:10 pm', 'May 16, 2023, 4:10 pm'),
(5, 'VA1700986893RE', 'RA1684253617SO', 'YX1700986893RB', '', '0', 'November 26, 2023, 8:21 am', 'November 26, 2023, 8:21 am'),
(6, 'SR1700986893XI', 'TC1684253439RB', 'YX1700986893RB', '', '0', 'November 26, 2023, 8:21 am', 'November 26, 2023, 8:21 am'),
(7, 'XA1700986893SX', 'TA1684253280WO', 'YX1700986893RB', '', '0', 'November 26, 2023, 8:21 am', 'November 26, 2023, 8:21 am'),
(8, 'XD1700986893TL', 'RE1622773325BV', 'YX1700986893RB', '', '0', 'November 26, 2023, 8:21 am', 'November 26, 2023, 8:21 am');

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

--
-- Table structure for table `wallet_tb`
--

CREATE TABLE `wallet_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `coin_type_id` varchar(200) NOT NULL,
  `amt_in_currency` varchar(200) NOT NULL,
  `amt_in_usd` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `action_type` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `day_counter` varchar(200) NOT NULL,
  `date_confirmed` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wallet_tb`
--

INSERT INTO `wallet_tb` (`id`, `unique_id`, `user_id`, `coin_type_id`, `amt_in_currency`, `amt_in_usd`, `description`, `action_type`, `status`, `day_counter`, `date_confirmed`, `is_deleted`, `created_at`, `updated_at`) VALUES
(15, 'RH1700998578RP', 'RE1622773325BV', 'YX1700986893RB', '90000000', '90000000', 'my_deposit', 'top_up', 'confirmed', '0', 'November 26, 2023, 3:45 pm', '0', 'November 26, 2023, 11:36 am', 'November 26, 2023, 3:45 pm'),
(14, 'JW1700986922JK', 'RE1622773325BV', 'YX1700986893RB', '89.91008991009', '90', 'my_deposit', 'top_up', 'pending', '0', 'null', '0', 'November 26, 2023, 8:22 am', 'November 26, 2023, 8:22 am'),
(13, 'RH1700980729IH', 'RE1622773325BV', 'TN1605616253SO', '0.00013243906941953', '5', 'my_deposit', 'top_up', 'pending', '0', 'null', '0', 'November 26, 2023, 6:38 am', 'November 26, 2023, 6:38 am'),
(12, 'FX1700980554RW', 'RE1622773325BV', 'TN1605616253SO', '0.0023823521704155', '90', 'my_deposit', 'top_up', 'pending', '0', 'null', '0', 'November 26, 2023, 6:35 am', 'November 26, 2023, 6:35 am'),
(11, 'MP1684547606KN', 'RE1622773325BV', 'TN1605616253SO', 'null', '150', 'my_purchase', 'withdrawal', 'confirmed', 'null', 'null', '0', 'May 20, 2023, 1:53 am', 'May 20, 2023, 1:53 am'),
(10, 'YE1684547523RK', 'RE1622773325BV', 'TN1605616253SO', '0.0074457253160245', '200', 'my_deposit', 'top_up', 'confirmed', '0', 'May 20, 2023, 1:52 am', '0', 'May 20, 2023, 1:52 am', 'May 20, 2023, 1:52 am'),
(16, 'RE1701013565DC', 'RE1622773325BV', 'YX1700986893RB', 'null', '500', 'my_purchase', 'withdrawal', 'confirmed', 'null', 'null', '0', 'November 26, 2023, 3:46 pm', 'November 26, 2023, 3:46 pm');

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

--
-- Table structure for table `withdrawal_tb`
--

CREATE TABLE `withdrawal_tb` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(200) NOT NULL,
  `user_id` varchar(200) NOT NULL,
  `category` varchar(200) NOT NULL,
  `transaction_id` varchar(200) NOT NULL,
  `amt_in_usd` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `is_deleted` varchar(200) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_tb`
--
ALTER TABLE `admin_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `category_tb`
--
ALTER TABLE `category_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `currencies_tb`
--
ALTER TABLE `currencies_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `investment_plan_tb`
--
ALTER TABLE `investment_plan_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `package_tb`
--
ALTER TABLE `package_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `product_tb`
--
ALTER TABLE `product_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

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

--
-- Indexes for table `referrer_bonus_tb`
--
ALTER TABLE `referrer_bonus_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `settings_tb`
--
ALTER TABLE `settings_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `subcategory_tb`
--
ALTER TABLE `subcategory_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `support_tb`
--
ALTER TABLE `support_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `transaction_tb`
--
ALTER TABLE `transaction_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`user_unique_id`);

--
-- Indexes for table `user_tb`
--
ALTER TABLE `user_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `user_wallet_tb`
--
ALTER TABLE `user_wallet_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `wallet_tb`
--
ALTER TABLE `wallet_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- Indexes for table `withdrawal_tb`
--
ALTER TABLE `withdrawal_tb`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQUE` (`unique_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `referrer_bonus_tb`
--
ALTER TABLE `referrer_bonus_tb`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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