-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 30, 2025 at 01:08 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(50) DEFAULT NULL,
  `transaction_type` varchar(50) DEFAULT NULL,
  `narration` text DEFAULT NULL,
  `trade_action` varchar(10) DEFAULT NULL,
  `currency_pair` varchar(20) DEFAULT NULL,
  `stock_ticker` varchar(100) DEFAULT NULL,
  `proof_image` varchar(255) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'Pending',
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `entry_price` varchar(255) DEFAULT NULL,
  `stop_loss` varchar(255) DEFAULT NULL,
  `take_profit` varchar(255) DEFAULT NULL,
  `bitcoin_address` varchar(255) DEFAULT NULL,
  `ethereum_address` varchar(255) DEFAULT NULL,
  `litecoin_address` varchar(255) DEFAULT NULL,
  `bitcoincash_address` varchar(255) DEFAULT NULL,
  `skrill_email` varchar(255) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `account_number` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `swift_code` varchar(100) DEFAULT NULL,
  `upgrade_plan` enum('Basic','Standard','Premium','Ultimate') DEFAULT NULL,
  `upgrade_method` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `users` (
  `usersId` int(11) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `usersfullname` varchar(100) NOT NULL,
  `usersusername` varchar(50) NOT NULL,
  `usersaddress` text DEFAULT NULL,
  `userscity` varchar(100) DEFAULT NULL,
  `userszipcode` varchar(20) DEFAULT NULL,
  `userscountry` varchar(100) DEFAULT NULL,
  `userscurrency` varchar(10) NOT NULL,
  `usersnumber` varchar(20) DEFAULT NULL,
  `usersemail` varchar(100) NOT NULL,
  `usersurl` varchar(255) DEFAULT NULL,
  `userspassword` varchar(255) NOT NULL,
  `usersrawpassword` varchar(100) NOT NULL,
  `userstotalbalance` decimal(10,2) DEFAULT 0.00,
  `usersaccounttype` enum('Basic','Standard','Premium','Ultimate') DEFAULT 'Basic',
  `usersactivedeposit` decimal(10,2) DEFAULT 0.00,
  `usersactiveearning` decimal(10,2) DEFAULT 0.00,
  `userslastdeposit` decimal(10,2) DEFAULT 0.00,
  `userstotalwithdrawal` decimal(10,2) DEFAULT 0.00,
  `userstotaldeposit` decimal(10,2) DEFAULT 0.00,
  `userspendingwithdrawal` decimal(10,2) DEFAULT 0.00,
  `usersjoindate` datetime DEFAULT current_timestamp(),
  `userslastlogin` datetime DEFAULT NULL,
  `userskycstatus` enum('Not Verified','Verified') DEFAULT 'Not Verified',
  `email_code` varchar(100) DEFAULT NULL,
  `email_status` varchar(20) DEFAULT 'Pending',
  `user_completed_sessions` int(11) DEFAULT 0,
  `user_total_sessions` int(11) DEFAULT 0,
  `usersgender` varchar(10) DEFAULT NULL,
  `usersdob` date DEFAULT NULL,
  `usersmaritalstatus` varchar(20) DEFAULT NULL,
  `usersagegroup` varchar(20) DEFAULT NULL,
  `usersstate` varchar(50) DEFAULT NULL,
  `usersprofileimage` varchar(255) DEFAULT NULL,
  `withdrawal_fee` int(11) NOT NULL,
  `commission_code` int(10) NOT NULL,
  `taxation_code` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `verifications`
--

CREATE TABLE `verifications` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `marital_status` varchar(20) DEFAULT NULL,
  `age` varchar(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `id_front` varchar(255) DEFAULT NULL,
  `id_back` varchar(255) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'Pending',
  `date_submitted` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wallet_address`
--

CREATE TABLE `wallet_address` (
  `id` int(11) NOT NULL,
  `bitcoin_wallet` varchar(255) NOT NULL,
  `ethereum_wallet` varchar(255) NOT NULL,
  `usdt_wallet` varchar(255) NOT NULL,
  `bitcoincash_wallet` varchar(255) NOT NULL,
  `adminemail` varchar(100) NOT NULL,
  `admincode` int(11) NOT NULL,
  `dateofchanging` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallet_address`
--

INSERT INTO `wallet_address` (`id`, `bitcoin_wallet`, `ethereum_wallet`, `usdt_wallet`, `bitcoincash_wallet`, `adminemail`, `admincode`, `dateofchanging`) VALUES
(1, 'bc1qexamplebtcwallet', '0xExampleEthereumWallet0000000000000000000000', 'TExampleUSDTWalletAddress', 'qzexamplebitcoincashwallet0000000000000000', 'Ogbetaprince192@gmail.com', 6261, '2025-05-29 21:40:12');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`usersId`),
  ADD UNIQUE KEY `userid` (`userid`),
  ADD UNIQUE KEY `usersusername` (`usersusername`),
  ADD UNIQUE KEY `usersemail` (`usersemail`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `usersId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `verifications`
--
ALTER TABLE `verifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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