-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 02, 2021 at 10:23 AM
-- Server version: 10.4.16-MariaDB
-- PHP Version: 7.4.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: `phronexix1`
--

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

--
-- Table structure for table `chiefadmin`
--

CREATE TABLE `chiefadmin` (
  `id` int(11) NOT NULL,
  `username` varchar(333) NOT NULL,
  `password` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `chiefadmin`
--

INSERT INTO `chiefadmin` (`id`, `username`, `password`) VALUES
(1, 'admin', 'adminExcellon2022');

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

--
-- Table structure for table `investment`
--

CREATE TABLE `investment` (
  `id` int(11) NOT NULL,
  `email` varchar(223) NOT NULL,
  `Amount` varchar(223) NOT NULL,
  `plan` varchar(233) NOT NULL,
  `profit` varchar(233) NOT NULL,
  `investDate` varchar(222) NOT NULL,
  `matureDate` varchar(222) NOT NULL,
  `status` varchar(333) NOT NULL,
  `TrnsID` varchar(222) NOT NULL,
  `wallet` varchar(220) NOT NULL,
  `comment` varchar(220) NOT NULL,
  `hours` varchar(222) NOT NULL DEFAULT 'NONE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `investment`
--

INSERT INTO `investment` (`id`, `email`, `Amount`, `plan`, `profit`, `investDate`, `matureDate`, `status`, `TrnsID`, `wallet`, `comment`, `hours`) VALUES
(1, 'finallopes7@gmail.com', '59996896644', 'Withdrawal', 'Withdrawal', '2021-Mar-04 05:07', 'Withdrawal', 'Pending Withdrawal', 'Wx439210785', 'None', 'Withdrawel chainhash', 'NONE');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `fullname` varchar(222) NOT NULL,
  `phone` varchar(222) NOT NULL,
  `email` varchar(222) NOT NULL,
  `cEmail` varchar(222) NOT NULL,
  `walletID` varchar(222) NOT NULL,
  `password` varchar(222) NOT NULL,
  `Cpass` varchar(222) NOT NULL,
  `country` varchar(222) NOT NULL,
  -- `answer` varchar(222) NOT NULL,
  `balance` varchar(222) NOT NULL,
  `dateReg` varchar(222) NOT NULL,
  `username` varchar(225) NOT NULL,
  `status` varchar(432) NOT NULL,
  `refusername` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `fullname`, `phone`, `email`, `cEmail`, `walletID`, `password`, `Cpass`, `country`, `balance`, `dateReg`, `username`, `status`, `refusername`) VALUES
(1, 'Floyd I.N.A. Lopes', '59996896644', 'finallopes7@gmail.com', 'finallopes7@gmail.com', '3R2YzcaAe87AWA2dKtDKfHyETVPx1E1sHT', 'E7vwXT6wXeZP9FT', 'E7vwXT6wXeZP9FT', 'Nigeria', '153', '2021-Mar-03', 'FINALBTC', 'Active', 'stalo'),
(2, 'stalo', '599968wdwd6644', 'xxx@gmail.com', 'xxx@gmail.com', '3R2YzcaAe87AWA2dKcccqwdqwKfHyETVPx1E1sHT', 'stalo', 'stalo', 'Nigeria', '12333', '2021-Mar-03', 'stalo', 'Active', 'stalo');


--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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