-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 19, 2026 at 10:29 PM
-- Server version: 10.11.18-MariaDB-cll-lve-log
-- PHP Version: 8.4.24

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

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `userID` int(11) NOT NULL,
  `email` varchar(150) NOT NULL,
  `wallet_address` varchar(150) DEFAULT NULL,
  `invoice_id` varchar(150) NOT NULL,
  `price_in_usd` double DEFAULT NULL,
  `price_in_btc` double DEFAULT NULL,
  `date` varchar(150) NOT NULL,
  `span` varchar(150) DEFAULT NULL,
  `paid` varchar(10) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`userID`, `email`, `wallet_address`, `invoice_id`, `price_in_usd`, `price_in_btc`, `date`, `span`, `paid`) VALUES
(1, 'gicyy65@gmail.com', '', 'axQun8JeHtzChhb', 2000, 0.01757262, '1761486594', '', '0'),
(2, 'gicyy65@gmail.com', '', 'FPyg8UbOxSzdLU9', 2000, 0.01757262, '1761486595', '', '0'),
(3, 'gicyy65@gmail.com', '', 'X87AmHHE8WNlQPs', 2000, 0.01757262, '1761486596', '', '0'),
(4, 'marylinlynlafon@gmail.com', '', 'HNOsQWtbjNCUCcg', 2000, 0.02078788, '1763230534', '', '1'),
(5, 'themelaburn@gmail.com', '', 'HK7QcFz8uqKcBEY', 3000000, 32.79394993, '1765413564', '', '1'),
(6, 'Idriswebb124@gmail.com', '', 'aJy7RInWBBmuSnP', 40000, 0.56958696, '1773245133', '', '1'),
(7, 'davidwebbmain@gmail.com', '', 'aEadadxxSvPxSqk', 40000, 0.56427086, '1773249370', '', '1'),
(8, 'Themelaburn@gmail.com', '', 'PVVH1eKQWTYahAG', 2000, 0.02925305, '1774553399', '', '0'),
(9, 'Themelaburn@gmail.com', '', '1normVj5sdlxHa7', 3000, 0.04385794, '1774553451', '', '0'),
(10, 'Themelaburn@gmail.com', '', 'XZ979wQloB9CuXQ', 3000, 0.04385794, '1774553463', '', '0'),
(11, 'pjmarney@yahoo.com', '', '1DWhZLets2iR1ik', 3000, 0.04387332, '1774553495', '', '0'),
(12, 'pjmarney@yahoo.com', '', 'hrUgspUaYnc8DNA', 3000, 0.04387332, '1774553505', '', '0'),
(13, 'pjmarney@yahoo.com', '', 'Y3sgRomhyOAagJe', 3000, 0.04387332, '1774553515', '', '0'),
(14, 'pjmarney@yahoo.com', '', 'jlqDNzZcPKv1egn', 3000, 0.04373268, '1774555068', '', '0'),
(15, 'pjmarney@yahoo.com', '', 'kVMbtkulXG3hJgS', 3000, 0.04373268, '1774555078', '', '0'),
(16, 'pjmarney@yahoo.com', '', 'CHynWj7Axm6w5bf', 3000, 0.04373268, '1774555088', '', '0'),
(17, 'pjmarney@yahoo.com', '', 'CeZ4gIHcor47Eyf', 3000, 0.04373268, '1774555098', '', '0'),
(18, 'Themelaburn@gmail.com', NULL, 'pbX8bH1BQMWHFV3', 2020, 0.03369037, '1782730969', NULL, '0'),
(19, 'box_ln9w@riskdotmp3.me', NULL, 't9bjXPkp4iEyjm5', 200, 0.00333811, '1782938233', NULL, '0'),
(20, 'Themelaburn@gmail.com', NULL, '4LqMt2JbkcsBsO7', 2020, 0.03285314, '1783010921', NULL, '0'),
(21, 'xingx.ing.zha.n.gdb@gmail.com', NULL, 'F9xjWntoWxz2Rex', 1000, 0.01554943, '1783802442', NULL, '0'),
(22, 'narim70172@lasttea.com', NULL, 'r7pZLMSlmpaVA4O', 500, 0.00781646, '1784342091', NULL, '0'),
(23, 'Themelaburn@gmail.com', NULL, '3f4VOjgP5JjH9sC', 2000, 0.03120271, '1784393634', NULL, '0'),
(24, 'Themelaburn@gmail.com', NULL, '4XiaqCClvrXtKhU', 1000, 0.0155678, '1784393662', NULL, '0'),
(25, 'Bradchadley21@icloud.com', NULL, 'EVPZh5MNK7Nndm4', 1400, 0.02174823, '1785325668', NULL, '0'),
(26, 'Themelaburn@gmail.com', NULL, 'Izk21111yRmFwNg', 2000, 0.03167586, '1785667401', NULL, '0'),
(27, 'blk4vp2kw1ph9@web-library.net', NULL, '1nWWApBBN46OrL7', 1000, 0.0155834, '1785881134', NULL, '0');

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `userID` int(11) NOT NULL,
  `username` varchar(150) NOT NULL,
  `password` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`userID`, `username`, `password`) VALUES
(1, 'admin', '28528cae289c6ad7c7bc7b1676018744');

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

--
-- Table structure for table `tbl_blog`
--

CREATE TABLE `tbl_blog` (
  `userID` int(11) NOT NULL,
  `image` varchar(150) NOT NULL,
  `title` varchar(150) NOT NULL,
  `text` text NOT NULL,
  `views` varchar(150) NOT NULL DEFAULT '0',
  `date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_deposite`
--

CREATE TABLE `tbl_deposite` (
  `userID` int(11) NOT NULL,
  `email` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_deposite`
--

INSERT INTO `tbl_deposite` (`userID`, `email`, `amount`, `date`) VALUES
(1, 'marylinlynlafon@gmail.com', '2000', '11/12/2025'),
(2, 'themelaburn@gmail.com', '3000000', '11/12/2025'),
(3, 'Idriswebb124@gmail.com', '40000', '11/03/2026'),
(4, 'davidwebbmain@gmail.com', '40000', '11/03/2026'),
(5, 'davidwebbmain@gmail.com', '40000', '11/03/2026'),
(6, 'davidwebbmain@gmail.com', '40000', '11/03/2026'),
(7, 'davidwebbmain@gmail.com', '40000', '11/03/2026');

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

--
-- Table structure for table `tbl_earning`
--

CREATE TABLE `tbl_earning` (
  `userID` int(11) NOT NULL,
  `email` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `type` varchar(191) NOT NULL,
  `date` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_earning`
--

INSERT INTO `tbl_earning` (`userID`, `email`, `amount`, `type`, `date`) VALUES
(1, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '12/12/2025'),
(2, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '13/12/2025'),
(3, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '14/12/2025'),
(4, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '15/12/2025'),
(5, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '16/12/2025'),
(6, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '17/12/2025'),
(7, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '18/12/2025'),
(8, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '19/12/2025'),
(9, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '20/12/2025'),
(10, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '21/12/2025'),
(11, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '22/12/2025'),
(12, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '23/12/2025'),
(13, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '08/04/2026'),
(14, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '08/04/2026'),
(15, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '08/04/2026'),
(16, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '09/04/2026'),
(17, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '09/04/2026'),
(18, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '09/04/2026'),
(19, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '10/04/2026'),
(20, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '10/04/2026'),
(21, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '10/04/2026'),
(22, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '11/04/2026'),
(23, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '11/04/2026'),
(24, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '11/04/2026'),
(25, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '12/04/2026'),
(26, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '12/04/2026'),
(27, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '12/04/2026'),
(28, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '13/04/2026'),
(29, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '13/04/2026'),
(30, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '13/04/2026'),
(31, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '14/04/2026'),
(32, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '14/04/2026'),
(33, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '14/04/2026'),
(34, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '15/04/2026'),
(35, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '15/04/2026'),
(36, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '15/04/2026'),
(37, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '16/04/2026'),
(38, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '16/04/2026'),
(39, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '16/04/2026'),
(40, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '17/04/2026'),
(41, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '17/04/2026'),
(42, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '17/04/2026'),
(43, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '18/04/2026'),
(44, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '18/04/2026'),
(45, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '18/04/2026'),
(46, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '19/04/2026'),
(47, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '19/04/2026'),
(48, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '19/04/2026'),
(49, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '20/04/2026'),
(50, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '20/04/2026'),
(51, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '20/04/2026'),
(52, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '21/04/2026'),
(53, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '21/04/2026'),
(54, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '21/04/2026'),
(55, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '22/04/2026'),
(56, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '22/04/2026'),
(57, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '22/04/2026'),
(58, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '23/04/2026'),
(59, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '23/04/2026'),
(60, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '23/04/2026'),
(61, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '24/04/2026'),
(62, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '24/04/2026'),
(63, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '24/04/2026'),
(64, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '25/04/2026'),
(65, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '25/04/2026'),
(66, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '25/04/2026'),
(67, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '26/04/2026'),
(68, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '26/04/2026'),
(69, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '26/04/2026'),
(70, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '27/04/2026'),
(71, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '27/04/2026'),
(72, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '27/04/2026'),
(73, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '28/04/2026'),
(74, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '28/04/2026'),
(75, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '28/04/2026'),
(76, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '29/04/2026'),
(77, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '29/04/2026'),
(78, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '29/04/2026'),
(79, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '30/04/2026'),
(80, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '30/04/2026'),
(81, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '30/04/2026'),
(82, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '25/06/2026'),
(83, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '25/06/2026'),
(84, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '25/06/2026'),
(85, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '26/06/2026'),
(86, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '26/06/2026'),
(87, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '26/06/2026'),
(88, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '27/06/2026'),
(89, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '27/06/2026'),
(90, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '27/06/2026'),
(91, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '28/06/2026'),
(92, 'Pjmarney@yahoo.com', '9.47', 'Investment profit', '28/06/2026'),
(93, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '28/06/2026'),
(94, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '29/06/2026'),
(95, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '29/06/2026'),
(96, 'themelaburn@gmail.com', '3343.3333333333', 'Investment profit', '30/06/2026'),
(97, 'Davidwebbmain@gmail.com', '200', 'Investment profit', '30/06/2026'),
(98, 'Bradchadley21@icloud.com', '12.38', 'Investment profit', '30/06/2026');

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

--
-- Table structure for table `tbl_info`
--

CREATE TABLE `tbl_info` (
  `userID` int(11) NOT NULL,
  `investors` varchar(150) NOT NULL DEFAULT '0',
  `earnings` varchar(150) NOT NULL DEFAULT '0',
  `withdrawals` varchar(150) NOT NULL DEFAULT '0',
  `support` varchar(150) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_investment`
--

CREATE TABLE `tbl_investment` (
  `userID` int(11) NOT NULL,
  `email` varchar(150) NOT NULL,
  `orderID` varchar(150) NOT NULL,
  `amount_invested` varchar(150) NOT NULL,
  `amount_to_earn` varchar(150) NOT NULL,
  `daily_profit` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL,
  `date` varchar(50) NOT NULL,
  `start` varchar(150) NOT NULL,
  `end` varchar(150) NOT NULL,
  `plan` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_investment`
--

INSERT INTO `tbl_investment` (`userID`, `email`, `orderID`, `amount_invested`, `amount_to_earn`, `daily_profit`, `status`, `date`, `start`, `end`, `plan`) VALUES
(1, 'themelaburn@gmail.com', '82448', '3000', '300', '10', '0', '11/12/2025', '1765413678', '1796517678', 'starter'),
(6, 'Bradchadley21@icloud.com', '59463', '3714', '371.4', '12.38', '0', '29/06/2026', '1782737606', '1813841606', 'starter'),
(7, 'Bradchadley21@icloud.com', '13222', '1501', '37.525', '5.3607142857143', '0', '30/07/2026', '1785438464', '1793214464', 'trial');

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

--
-- Table structure for table `tbl_message`
--

CREATE TABLE `tbl_message` (
  `userID` int(11) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `userID` int(11) NOT NULL,
  `fullname` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `state` varchar(150) NOT NULL,
  `country` varchar(150) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `ref_email` varchar(150) NOT NULL,
  `password` varchar(50) NOT NULL,
  `accountID` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `token_code` varchar(150) DEFAULT NULL,
  `confirm` int(11) NOT NULL DEFAULT 0,
  `wallet_address` varchar(150) DEFAULT NULL,
  `balance` varchar(150) NOT NULL DEFAULT '0',
  `profit` varchar(150) NOT NULL DEFAULT '0',
  `last_deposite` varchar(150) NOT NULL DEFAULT '0',
  `last_withdrawal` varchar(150) NOT NULL DEFAULT '0',
  `txnid` varchar(150) DEFAULT NULL,
  `ref_pay` varchar(10) NOT NULL DEFAULT '0',
  `auth_code` varchar(150) DEFAULT NULL,
  `address_given` varchar(191) DEFAULT NULL,
  `addressID` varchar(191) DEFAULT NULL,
  `incoming_btc` varchar(191) DEFAULT NULL,
  `start` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`userID`, `fullname`, `email`, `state`, `country`, `phone`, `ref_email`, `password`, `accountID`, `date`, `token_code`, `confirm`, `wallet_address`, `balance`, `profit`, `last_deposite`, `last_withdrawal`, `txnid`, `ref_pay`, `auth_code`, `address_given`, `addressID`, `incoming_btc`, `start`) VALUES
(4, 'lynlafon', 'marylinlynlafon@gmail.com', '', 'United States', '6822209964', '', '668e9f6adc4110abe6e6a447a4801e20', 'KKbJF', '15/11/2025', '', 0, '', '2000', '0', '2000', '0', '', '0', '', 'bc1qrljg33jwnvhqh0m99feywu3kjpmd7p0t9msk8r', '5993594263', '', '0'),
(5, 'Kelvin', 'uzowuluuchechi@gmail.com', '', 'Nigeria', '08165628000', '', 'dfeacdebdd52607b78a0eca093c2ed7a', 'TCu88', '02/12/2025', '', 0, '', '0', '0', '0', '0', '', '0', '', '', '', '', '0'),
(6, 'Pamela', 'Themelaburn@gmail.com', '', 'United States', '6373737382', '', 'c81e728d9d4c2f636f067f89cc14862c', '4nVdD', '11/12/2025', '', 0, '', '2497002', '137076.66666662', '3000000', '0', '', '0', '', 'bc1qrljg33jwnvhqh0m99feywu3kjpmd7p0t9msk8r', '2159581564', '', '1765413539'),
(11, 'Chad Bradley', 'Bradchadley21@icloud.com', '', 'United States', '330-321-1828', '', '68bb68fef089809abe3ab79369f1e820', 'vSwNj', '28/06/2026', NULL, 0, '', '0', '786.87', '0', '0', NULL, '0', NULL, 'bc1qrljg33jwnvhqh0m99feywu3kjpmd7p0t9msk8r', '6538959453', NULL, '1782663733'),
(16, 'James Miller', 'blk4vp2kw1ph9@web-library.net', '', 'United States', '3239165117', '', 'd503833f7ef0238a60bba2461c23f93d', 'njoXH', '04/08/2026', NULL, 0, '', '2', '0', '0', '0', NULL, '0', NULL, 'bc1qrljg33jwnvhqh0m99feywu3kjpmd7p0t9msk8r', '7268918813', NULL, '1785881077');

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

--
-- Table structure for table `tbl_wallet`
--

CREATE TABLE `tbl_wallet` (
  `userID` int(11) NOT NULL,
  `wallet_address` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbl_withdrawal`
--

CREATE TABLE `tbl_withdrawal` (
  `userID` int(11) NOT NULL,
  `email` varchar(150) NOT NULL,
  `orderID` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `description_name` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL DEFAULT '0',
  `date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_blog`
--
ALTER TABLE `tbl_blog`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_deposite`
--
ALTER TABLE `tbl_deposite`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_earning`
--
ALTER TABLE `tbl_earning`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_info`
--
ALTER TABLE `tbl_info`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_investment`
--
ALTER TABLE `tbl_investment`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_message`
--
ALTER TABLE `tbl_message`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_wallet`
--
ALTER TABLE `tbl_wallet`
  ADD PRIMARY KEY (`userID`);

--
-- Indexes for table `tbl_withdrawal`
--
ALTER TABLE `tbl_withdrawal`
  ADD PRIMARY KEY (`userID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

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

--
-- AUTO_INCREMENT for table `tbl_blog`
--
ALTER TABLE `tbl_blog`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_earning`
--
ALTER TABLE `tbl_earning`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `tbl_info`
--
ALTER TABLE `tbl_info`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_message`
--
ALTER TABLE `tbl_message`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tbl_wallet`
--
ALTER TABLE `tbl_wallet`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;

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