-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 27, 2026 at 04:06 PM
-- Server version: 11.4.9-MariaDB
-- PHP Version: 8.4.11

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

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

--
-- Table structure for table `admin_table`
--

CREATE TABLE `admin_table` (
  `id` int(11) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin_table`
--

INSERT INTO `admin_table` (`id`, `email`, `password`, `created_at`) VALUES
(1, 'admin@mail.com', '$2y$12$QcBeRQrHpkdZl324lCakL.YcPWQpYh7MX1YmP4eZj3W8xWDOZ9CoW', '2026-01-20 11:02:47');

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

--
-- Table structure for table `copy_trade_investments`
--

CREATE TABLE `copy_trade_investments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `status` varchar(255) DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `copy_trade_investments`
--

INSERT INTO `copy_trade_investments` (`id`, `user_id`, `plan_id`, `amount`, `status`, `created_at`) VALUES
(5, 45, 2, 6000.00, 'rejected', '2026-02-26 09:59:00'),
(6, 45, 1, 400.00, 'completed', '2026-02-26 10:01:01'),
(7, 45, 5, 25000.00, 'completed', '2026-02-26 10:21:33');

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

--
-- Table structure for table `copy_trade_plans`
--

CREATE TABLE `copy_trade_plans` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `min_investment` decimal(15,2) NOT NULL,
  `max_investment` decimal(15,2) NOT NULL,
  `profit_percentage` decimal(5,2) NOT NULL,
  `duration_days` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
  `image_url` varchar(500) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `copy_trade_plans`
--

INSERT INTO `copy_trade_plans` (`id`, `plan_name`, `min_investment`, `max_investment`, `profit_percentage`, `duration_days`, `description`, `features`, `image_url`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Alex Thompson', 1000.00, 9999.00, 50.00, 7, 'Experienced forex trader specializing in major currency pairs', '[\"24\\/7 Support\",\"Rating: 4.5\"]', 'uploads/plans/69a01d07a9625.jpg', 'active', '2026-02-26 10:14:31', '2026-02-26 10:14:31'),
(4, 'Lisa Anderson', 10000.00, 19999.00, 80.00, 14, 'High-frequency trading specialist with expertise in market microstructure', '[\"24\\/7 Support\",\"Rating: 4.9\"]', 'uploads/plans/69a01d75d0b54.jpg', 'active', '2026-02-26 10:16:21', '2026-02-26 10:16:21'),
(5, 'Roberto Silva', 20000.00, 29999.00, 40.00, 30, 'Emerging markets specialist focusing on Latin American and Brazilian markets', '[\"24\\/7 Support\",\"Rating: 4.6\"]', 'uploads/plans/69a01dd67c224.jpg', 'active', '2026-02-26 10:17:58', '2026-02-26 10:17:58');

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

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

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `transaction_id` varchar(50) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `payment_type` enum('crypto','bank') NOT NULL,
  `transaction_hash` varchar(255) DEFAULT NULL,
  `payment_proof` varchar(500) DEFAULT NULL,
  `status` enum('pending','completed','rejected') DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `verified_by` int(11) DEFAULT NULL,
  `verified_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `deposits`
--

INSERT INTO `deposits` (`id`, `user_id`, `transaction_id`, `amount`, `payment_method_id`, `payment_type`, `transaction_hash`, `payment_proof`, `status`, `admin_notes`, `verified_by`, `verified_at`, `created_at`, `updated_at`) VALUES
(11, 45, 'DEP698F41830E1D5', 100000.00, 1, 'crypto', 'dfjkasdfjkasjkfasjkfjks', 'uploads/deposits/deposit_45_1770996099.png', 'completed', NULL, 1, '2026-02-13 15:21:56', '2026-02-13 15:21:39', '2026-02-13 15:21:56'),
(12, 46, 'DEP698F4C2732B11', 10000.00, 1, 'crypto', '', 'uploads/deposits/deposit_46_1770998823.png', 'completed', NULL, 1, '2026-02-13 16:07:59', '2026-02-13 16:07:03', '2026-02-13 16:07:59'),
(13, 46, 'DEP698F4F84D1514', 20000.00, 1, 'crypto', '', 'uploads/deposits/deposit_46_1770999684.png', 'completed', NULL, 1, '2026-02-13 16:21:57', '2026-02-13 16:21:24', '2026-02-13 16:21:57');

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

--
-- Table structure for table `forex_trades`
--

CREATE TABLE `forex_trades` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `currency_pair` varchar(20) NOT NULL,
  `trade_type` enum('BUY','SELL') NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `entry_price` decimal(15,5) NOT NULL,
  `exit_price` decimal(15,5) DEFAULT NULL,
  `lot_size` decimal(10,2) NOT NULL,
  `stop_loss` decimal(15,5) DEFAULT NULL,
  `take_profit` decimal(15,5) DEFAULT NULL,
  `profit_loss` decimal(15,2) DEFAULT NULL,
  `status` enum('open','closed','pending','cancelled') DEFAULT 'pending',
  `admin_action` enum('profit','loss','pending') DEFAULT 'pending',
  `closed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `forex_trades`
--

INSERT INTO `forex_trades` (`id`, `user_id`, `currency_pair`, `trade_type`, `amount`, `entry_price`, `exit_price`, `lot_size`, `stop_loss`, `take_profit`, `profit_loss`, `status`, `admin_action`, `closed_at`, `created_at`, `updated_at`) VALUES
(1, 45, 'USD/CHF', 'BUY', 1000.00, 0.87220, 0.87220, 0.10, 1.00000, 1.00000, 0.00, 'closed', 'profit', '2026-02-23 14:08:36', '2026-02-23 12:51:17', '2026-02-23 13:08:36'),
(2, 45, 'USD/CHF', 'BUY', 10000.00, 0.87730, 0.87730, 0.10, 100.00000, 12000.00000, 12000.00, 'open', 'profit', '2026-02-23 14:59:53', '2026-02-23 13:58:51', '2026-02-23 13:59:53'),
(3, 45, 'EUR/GBP', 'BUY', 1000.00, 0.85660, 0.85660, 1.00, 1.00000, 2.00000, 2000.00, 'open', 'profit', '2026-02-23 15:09:33', '2026-02-23 14:08:59', '2026-02-23 14:09:33'),
(4, 45, 'USD/CAD', 'SELL', 1000.00, 1.34910, 1.34910, 1.00, 1.00000, 2000.00000, -900.00, 'closed', 'loss', '2026-02-23 15:13:37', '2026-02-23 14:12:11', '2026-02-23 14:13:37');

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

--
-- Table structure for table `investment_plans`
--

CREATE TABLE `investment_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `min_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `max_amount` decimal(15,2) DEFAULT NULL,
  `interest_rate` decimal(5,2) NOT NULL,
  `duration_days` int(11) NOT NULL,
  `compounding_interval` enum('daily','weekly','monthly','quarterly','annually') DEFAULT 'monthly',
  `status` enum('active','inactive') DEFAULT 'active',
  `features` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `investment_plans`
--

INSERT INTO `investment_plans` (`id`, `name`, `description`, `min_amount`, `max_amount`, `interest_rate`, `duration_days`, `compounding_interval`, `status`, `features`, `created_by`, `created_at`, `updated_at`) VALUES
(5, 'Plan 1', 'Plan 1', 10000.00, 20000.00, 100.00, 1, 'daily', 'active', 'Daily Payouts|Compounding Interest|Principal Protection|Early Withdrawal|Reinvestment Option|Referral Bonus|24/7 Support|Insurance Coverage|Flexible Terms', 1, '2026-02-13 15:23:08', '2026-02-13 15:23:08'),
(6, 'Plan2', 'jadjkjk sejjk sdjksdjk sdjsdjk sdjksdjksdjk', 10000.00, 100000.00, 100.00, 30, 'monthly', 'active', 'Daily Payouts|Compounding Interest|Principal Protection|Early Withdrawal|Reinvestment Option|Referral Bonus|24/7 Support|Insurance Coverage|Flexible Terms', 1, '2026-02-15 19:30:02', '2026-02-15 19:30:02'),
(7, 'Plan3', 'Plan Description', 10000.00, 100000.00, 100.00, 2, 'daily', 'active', 'Daily Payouts|Compounding Interest|Principal Protection|Early Withdrawal|Reinvestment Option|Referral Bonus|24/7 Support|Insurance Coverage|Flexible Terms', 1, '2026-02-15 19:31:49', '2026-02-15 19:31:49');

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

--
-- Table structure for table `kyc_logs`
--

CREATE TABLE `kyc_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `action` varchar(50) NOT NULL,
  `performed_by` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `mining_sessions`
--

CREATE TABLE `mining_sessions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `crypto_type` varchar(50) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `profit_percentage` decimal(5,2) DEFAULT NULL,
  `profit_amount` decimal(15,2) DEFAULT NULL,
  `total_return` decimal(15,2) DEFAULT NULL,
  `status` enum('pending','active','completed','cancelled') DEFAULT 'pending',
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mining_sessions`
--

INSERT INTO `mining_sessions` (`id`, `user_id`, `crypto_type`, `amount`, `profit_percentage`, `profit_amount`, `total_return`, `status`, `start_time`, `end_time`, `completed_at`, `created_at`) VALUES
(1, 45, 'Binance Coin (BNB)', 1000.00, 190.00, 1900.00, 2900.00, 'completed', '2026-02-27 09:55:29', '2026-02-27 10:04:26', '2026-02-27 10:55:29', '2026-02-27 09:55:29'),
(2, 45, 'Dogecoin (DOGE)', 1200.00, 176.00, 2112.00, 3312.00, 'completed', '2026-02-27 10:01:21', '2026-02-27 10:11:03', '2026-02-27 11:01:21', '2026-02-27 10:01:21'),
(3, 45, 'Ripple (XRP)', 3000.00, 62.00, 1860.00, 4860.00, 'completed', '2026-02-27 10:07:48', '2026-02-27 10:12:04', '2026-02-27 11:07:48', '2026-02-27 10:07:48'),
(4, 45, 'Ethereum (ETH)', 1000.00, 77.00, 770.00, 1770.00, 'completed', '2026-02-27 10:08:19', '2026-02-27 10:13:44', '2026-02-27 11:08:19', '2026-02-27 10:08:19'),
(5, 45, 'Solana (SOL)', 2000.00, 142.00, 2840.00, 4840.00, 'completed', '2026-02-27 10:08:48', '2026-02-27 10:18:38', '2026-02-27 11:08:48', '2026-02-27 10:08:48'),
(6, 45, 'Bitcoin (BTC)', 2300.00, 160.00, 3680.00, 5980.00, 'completed', '2026-02-27 10:09:17', '2026-02-27 10:15:02', '2026-02-27 11:09:17', '2026-02-27 10:09:17'),
(7, 45, 'Polkadot (DOT)', 100.00, 189.00, 189.00, 289.00, 'completed', '2026-02-27 14:08:15', '2026-02-27 14:15:57', '2026-02-27 15:08:15', '2026-02-27 14:08:15'),
(8, 45, 'Cardano (ADA)', 3000.00, 135.00, 4050.00, 7050.00, 'completed', '2026-02-27 14:45:50', '2026-02-27 14:47:55', '2026-02-27 15:47:55', '2026-02-27 14:45:50');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `notification_type` varchar(50) DEFAULT 'system',
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `user_id`, `notification_type`, `title`, `message`, `is_read`, `created_at`) VALUES
(30, 45, 'transaction', 'Deposit Approved', 'Your deposit of $100,000.00 has been approved and credited to your account.', 1, '2026-02-13 15:21:56'),
(31, 45, 'security', 'Withdrawal PIN Updated', 'Your withdrawal PIN has been updated by administrator. Message: Withdrawal PIN message', 1, '2026-02-13 15:25:25'),
(32, 45, 'security', 'Upgrade PIN Updated', 'Your upgrade PIN has been updated by administrator. Fee: $100.00 Message: Upgrade PIN message', 1, '2026-02-13 15:25:46'),
(33, 45, 'security', 'Tax PIN Updated', 'Your tax PIN has been updated by administrator. Fee: $100.00 Message: Tax PIN message', 1, '2026-02-13 15:26:08'),
(34, 45, 'transaction', 'Withdrawal Request Submitted', 'Your withdrawal request of $1,000.00 has been submitted. Reference ID: WTH00000018', 1, '2026-02-13 15:26:46'),
(35, 46, 'transaction', 'Deposit Approved', 'Your deposit of $10,000.00 has been approved and credited to your account.', 0, '2026-02-13 16:07:59'),
(36, 46, 'transaction', 'Deposit Approved', 'Your deposit of $20,000.00 has been approved and credited to your account.', 0, '2026-02-13 16:21:57'),
(37, 45, 'trade', 'Trade Placed Successfully', 'Your BUY trade of 1000 on USD/CHF has been placed and is pending admin approval.', 1, '2026-02-23 12:51:17'),
(38, 45, 'trade', 'Trade Approved', 'Your BUY trade of USD/CHF for $1,000.00 has been approved and is now open.', 1, '2026-02-23 13:07:53'),
(39, 45, 'trade', 'Trade Closed', 'Your BUY trade of USD/CHF has been closed with profit of $0.00.', 1, '2026-02-23 13:08:36'),
(40, 45, 'trade', 'Trade Placed Successfully', 'Your BUY trade of 10000 on USD/CHF has been placed and is pending admin approval.', 1, '2026-02-23 13:58:51'),
(41, 45, 'trade', 'Trade Approved', 'Your BUY trade of USD/CHF for $10,000.00 has been approved and is now open.', 1, '2026-02-23 13:59:07'),
(42, 45, 'trade', 'Trade Approved', 'Your BUY trade of USD/CHF for $10,000.00 has been approved and is now open.', 1, '2026-02-23 13:59:23'),
(43, 45, 'trade', 'Trade Closed', 'Your BUY trade of USD/CHF has been closed with profit of $12,000.00.', 1, '2026-02-23 13:59:53'),
(44, 45, 'trade', 'Trade Approved', 'Your BUY trade of USD/CHF for $10,000.00 has been approved and is now open.', 1, '2026-02-23 13:59:53'),
(45, 45, 'trade', 'Trade Placed Successfully', 'Your BUY trade of 1000 on EUR/GBP has been placed and is pending admin approval.', 1, '2026-02-23 14:08:59'),
(46, 45, 'trade', 'Trade Approved', 'Your BUY trade of EUR/GBP for $1,000.00 has been approved and is now open.', 1, '2026-02-23 14:09:13'),
(47, 45, 'trade', 'Trade Approved', 'Your BUY trade of EUR/GBP for $1,000.00 has been approved and is now open.', 1, '2026-02-23 14:09:17'),
(48, 45, 'trade', 'Trade Closed', 'Your BUY trade of EUR/GBP has been closed with profit of $2,000.00.', 1, '2026-02-23 14:09:33'),
(49, 45, 'trade', 'Trade Approved', 'Your BUY trade of EUR/GBP for $1,000.00 has been approved and is now open.', 1, '2026-02-23 14:09:33'),
(50, 45, 'trade', 'Trade Placed Successfully', 'Your SELL trade of 1000 on USD/CAD has been placed and is pending admin approval.', 1, '2026-02-23 14:12:11'),
(51, 45, 'trade', 'Trade Approved', 'Your SELL trade of USD/CAD for $1,000.00 has been approved and is now open.', 1, '2026-02-23 14:12:42'),
(52, 45, 'trade', 'Trade Closed', 'Your SELL trade of USD/CAD has been closed with loss of $900.00.', 1, '2026-02-23 14:13:37'),
(53, 45, 'investment', 'Investment Submitted', 'Your investment of $100.00 in Jake has been submitted and is pending admin approval.', 1, '2026-02-25 11:20:32'),
(54, 45, 'investment', 'Investment Submitted', 'Your investment of $8,000.00 in Mike has been submitted and is pending admin approval.', 1, '2026-02-25 11:21:43'),
(55, 45, 'investment', 'Investment Submitted', 'Your investment of $300.00 in Jake has been submitted and is pending admin approval.', 0, '2026-02-26 09:51:22'),
(56, 45, 'investment', 'Investment Completed', 'Your investment of $300.00 in Jake has been completed. You received $450.00 (Initial: $300.00 + Profit: $150.00)', 0, '2026-02-26 09:54:23'),
(57, 45, 'investment', 'Investment Submitted', 'Your investment of $5,000.00 in Mike has been submitted and is pending admin approval.', 0, '2026-02-26 09:56:42'),
(58, 45, 'investment', 'Investment Submitted', 'Your investment of $6,000.00 in Mike has been submitted and is pending admin approval.', 0, '2026-02-26 09:59:00'),
(59, 45, 'investment', 'Investment Rejected', 'Your investment of $6,000.00 in Mike has been rejected. The amount has been returned to your balance.', 0, '2026-02-26 10:00:34'),
(60, 45, 'investment', 'Investment Submitted', 'Your investment of $400.00 in Jake has been submitted and is pending admin approval.', 0, '2026-02-26 10:01:01'),
(61, 45, 'investment', 'Investment Approved', 'Your investment of $400.00 in Jake has been approved and is now active.', 0, '2026-02-26 10:01:14'),
(62, 45, 'investment', 'Investment Completed', 'Your investment of $400.00 in Jake has been completed. You received $600.00 (Initial: $400.00 + Profit: $200.00)', 0, '2026-02-26 10:01:32'),
(63, 45, 'investment', 'Investment Submitted', 'Your investment of $25,000.00 in Roberto Silva has been submitted and is pending admin approval.', 0, '2026-02-26 10:21:33'),
(64, 45, 'investment', 'Investment Approved', 'Your investment of $25,000.00 in Roberto Silva has been approved and is now active.', 0, '2026-02-26 10:22:36'),
(65, 45, 'investment', 'Investment Completed', 'Your investment of $25,000.00 in Roberto Silva has been completed. You received $35,000.00 (Initial: $25,000.00 + Profit: $10,000.00)', 0, '2026-02-26 10:22:42'),
(66, 45, 'mining', 'Mining Completed', 'Your mining session of $1,000.00 in Binance Coin (BNB) has completed! You earned $1,900.00 profit (190%). Total return: $2,900.00', 0, '2026-02-27 09:55:29'),
(67, 45, 'mining', 'Mining Completed', 'Your mining session of $1,200.00 in Dogecoin (DOGE) has completed! You earned $2,112.00 profit (176%). Total return: $3,312.00', 0, '2026-02-27 10:01:21'),
(68, 45, 'mining', 'Mining Completed', 'Your mining session of $3,000.00 in Ripple (XRP) has completed! You earned $1,860.00 profit (62%). Total return: $4,860.00', 0, '2026-02-27 10:07:48'),
(69, 45, 'mining', 'Mining Completed', 'Your mining session of $1,000.00 in Ethereum (ETH) has completed! You earned $770.00 profit (77%). Total return: $1,770.00', 0, '2026-02-27 10:08:19'),
(70, 45, 'mining', 'Mining Completed', 'Your mining session of $2,000.00 in Solana (SOL) has completed! You earned $2,840.00 profit (142%). Total return: $4,840.00', 0, '2026-02-27 10:08:48'),
(71, 45, 'mining', 'Mining Completed', 'Your mining session of $2,300.00 in Bitcoin (BTC) has completed! You earned $3,680.00 profit (160%). Total return: $5,980.00', 0, '2026-02-27 10:09:17'),
(72, 45, 'mining', 'Mining Completed', 'Your mining session of $100.00 in Polkadot (DOT) has completed! You earned $189.00 profit (189%). Total return: $289.00', 0, '2026-02-27 14:08:15'),
(73, 45, 'mining', 'Mining Completed', 'Your mining session of $3,000.00 in Cardano (ADA) has completed! You earned $4,050.00 profit (135%). Total return: $7,050.00', 0, '2026-02-27 14:47:55');

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

--
-- Table structure for table `payment_tb`
--

CREATE TABLE `payment_tb` (
  `id` int(11) NOT NULL,
  `payment_type` enum('crypto','bank') NOT NULL,
  `wallet_name` varchar(100) DEFAULT NULL,
  `wallet_address` varchar(255) DEFAULT NULL,
  `crypto_network` varchar(50) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `account_name` varchar(100) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `swift_code` varchar(50) DEFAULT NULL,
  `iban` varchar(50) DEFAULT NULL,
  `branch_code` varchar(50) DEFAULT NULL,
  `branch_address` text DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment_tb`
--

INSERT INTO `payment_tb` (`id`, `payment_type`, `wallet_name`, `wallet_address`, `crypto_network`, `bank_name`, `account_name`, `account_number`, `swift_code`, `iban`, `branch_code`, `branch_address`, `is_default`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'crypto', 'Bitcoin', 'btbtbtbtbtbtbtbtbtbtbtbtbt', 'Bitcoin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'active', 1, '2026-01-21 10:22:52', '2026-01-21 10:22:52'),
(5, 'crypto', 'Ethereum', 'ethethethethethehththeth', 'Ethereum ERC20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'active', 1, '2026-02-11 13:34:06', '2026-02-11 13:34:06'),
(3, 'bank', NULL, NULL, NULL, 'Access Bank', 'John Doe', '2147483640', 'CITIDKLL', '23889sd89sd89sd89', '3232', 'jksdjksdjk sdjksdjk sdjksdjksd', 0, 'active', 1, '2026-01-21 10:23:54', '2026-01-21 10:23:54');

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_group` varchar(50) DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `setting_key`, `setting_value`, `setting_group`, `created_at`, `updated_at`) VALUES
(1, 'site_name', 'Quick Verse', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(2, 'site_email', 'info@demo.bitnusoptionscapitalsco.cc', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(3, 'site_phone', '2474747474', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(4, 'site_address', '12, New Road, NY', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(5, 'copyright_text', '2026 Quickverse. All Rights Reserved', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(6, 'site_url', 'https://demo.bitnusoptionscapitalsco.cc', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(7, 'timezone', 'UTC', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(8, 'date_format', 'F j, Y', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(9, 'items_per_page', '20', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(10, 'maintenance_mode', '0', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(11, 'allow_registration', '1', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:18'),
(12, 'email_verification_required', '0', 'general', '2026-01-20 13:36:17', '2026-02-26 10:53:46'),
(13, 'smtp_password', 'info@demo.bitnusoptionscapitalsco.cc', 'general', '2026-01-20 13:37:00', '2026-02-26 10:53:46'),
(14, 'smtp_host', 'demo.bitnusoptionscapitalsco.cc', 'general', '2026-01-20 13:37:00', '2026-02-26 10:53:46'),
(15, 'smtp_port', '587', 'general', '2026-01-20 13:37:00', '2026-02-26 10:53:46'),
(16, 'smtp_username', 'info@demo.bitnusoptionscapitalsco.cc', 'general', '2026-01-20 13:37:00', '2026-02-26 10:53:46'),
(17, 'smtp_encryption', 'tls', 'general', '2026-01-20 13:37:00', '2026-02-26 10:53:46'),
(18, 'logo_path', 'assets/images/logo_1770818580.png', 'general', '2026-01-20 13:37:37', '2026-02-11 14:03:00'),
(19, 'favicon_path', 'assets/images/favicon_1770818592.png', 'general', '2026-01-20 13:37:53', '2026-02-11 14:03:12'),
(20, 'enable_crypto_payments', '1', 'general', '2026-01-21 10:22:26', '2026-01-21 10:22:26'),
(21, 'enable_bank_payments', '1', 'general', '2026-01-21 10:22:26', '2026-01-21 10:22:26'),
(22, 'min_deposit_amount', '100', 'general', '2026-01-21 10:22:26', '2026-01-21 10:22:26'),
(23, 'max_deposit_amount', '100000', 'general', '2026-01-21 10:22:26', '2026-01-21 10:22:26'),
(24, 'deposit_instruction', 'Send exact amount to the wallet address below. Include your User ID in the memo/description.', 'general', '2026-01-21 10:22:26', '2026-01-21 10:22:26');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `amount`, `type`, `status`, `created_at`) VALUES
(18, 45, 10000.00, 'investment', 'completed', '2026-02-15 19:32:13'),
(17, 46, 10000.00, 'investment', 'completed', '2026-02-13 16:23:07'),
(16, 46, 20000.00, 'deposit', 'completed', '2026-02-13 16:21:57'),
(15, 46, 10000.00, 'deposit', 'completed', '2026-02-13 16:07:59'),
(14, 45, 15000.00, 'investment', 'completed', '2026-02-13 15:23:30'),
(13, 45, 100000.00, 'deposit', 'completed', '2026-02-13 15:21:56');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `country` varchar(10) NOT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `postal_code` varchar(20) DEFAULT NULL,
  `account_balance` decimal(15,2) DEFAULT 0.00,
  `total_earnings` decimal(15,2) DEFAULT 0.00,
  `total_withdrawals` decimal(15,2) DEFAULT 0.00,
  `withdrawal_pin` varchar(255) DEFAULT NULL COMMENT 'Withdrawal PIN for secure withdrawals',
  `withdrawal_pin_set_at` datetime DEFAULT NULL,
  `withdrawal_pin_used` tinyint(1) DEFAULT 0,
  `notification_preferences` text DEFAULT NULL,
  `last_notification` timestamp NULL DEFAULT NULL,
  `referral_code` varchar(50) DEFAULT NULL,
  `referred_by` int(11) DEFAULT NULL,
  `total_referrals` int(11) DEFAULT 0,
  `referral_earnings` decimal(15,2) DEFAULT 0.00,
  `two_factor_enabled` tinyint(1) DEFAULT 0,
  `two_factor_secret` varchar(255) DEFAULT NULL,
  `wallet_address` varchar(255) DEFAULT NULL,
  `kyc_status` enum('pending','verified','rejected') DEFAULT 'pending',
  `kyc_document_path` varchar(500) DEFAULT NULL,
  `account_tier` enum('basic','silver','gold','platinum') DEFAULT 'basic',
  `investment_balance` decimal(15,2) DEFAULT 0.00,
  `last_deposit` timestamp NULL DEFAULT NULL,
  `last_withdrawal` timestamp NULL DEFAULT NULL,
  `total_deposits` decimal(15,2) DEFAULT 0.00,
  `total_invested` decimal(15,2) DEFAULT 0.00,
  `password` varchar(255) NOT NULL,
  `verification_token` varchar(64) DEFAULT NULL,
  `verification_expiry` datetime DEFAULT NULL,
  `email_verified` tinyint(1) DEFAULT 0,
  `verified_at` datetime DEFAULT NULL,
  `account_status` enum('active','pending','suspended','banned') DEFAULT 'active',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_login` datetime DEFAULT NULL,
  `login_attempts` int(11) DEFAULT 0,
  `last_login_ip` varchar(45) DEFAULT NULL,
  `upgrade_fee` decimal(10,2) DEFAULT 0.00,
  `upgrade_pin` varchar(255) DEFAULT NULL COMMENT 'Upgrade PIN for account upgrades',
  `upgrade_pin_set_at` datetime DEFAULT NULL,
  `upgrade_pin_used` tinyint(1) DEFAULT 0,
  `tax_fee` decimal(10,2) DEFAULT 0.00,
  `tax_pin` varchar(255) DEFAULT NULL COMMENT 'Tax PIN for tax-related operations',
  `tax_pin_set_at` datetime DEFAULT NULL,
  `tax_pin_used` tinyint(1) DEFAULT 0,
  `withdrawal_pin_message` varchar(255) DEFAULT NULL,
  `withdrawal_pin_enabled` tinyint(1) DEFAULT 1,
  `upgrade_pin_message` varchar(255) DEFAULT NULL,
  `upgrade_pin_enabled` tinyint(1) DEFAULT 1,
  `tax_pin_message` varchar(255) DEFAULT NULL,
  `tax_pin_enabled` tinyint(1) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `full_name`, `email`, `phone`, `country`, `state`, `city`, `postal_code`, `account_balance`, `total_earnings`, `total_withdrawals`, `withdrawal_pin`, `withdrawal_pin_set_at`, `withdrawal_pin_used`, `notification_preferences`, `last_notification`, `referral_code`, `referred_by`, `total_referrals`, `referral_earnings`, `two_factor_enabled`, `two_factor_secret`, `wallet_address`, `kyc_status`, `kyc_document_path`, `account_tier`, `investment_balance`, `last_deposit`, `last_withdrawal`, `total_deposits`, `total_invested`, `password`, `verification_token`, `verification_expiry`, `email_verified`, `verified_at`, `account_status`, `created_at`, `updated_at`, `last_login`, `login_attempts`, `last_login_ip`, `upgrade_fee`, `upgrade_pin`, `upgrade_pin_set_at`, `upgrade_pin_used`, `tax_fee`, `tax_pin`, `tax_pin_set_at`, `tax_pin_used`, `withdrawal_pin_message`, `withdrawal_pin_enabled`, `upgrade_pin_message`, `upgrade_pin_enabled`, `tax_pin_message`, `tax_pin_enabled`) VALUES
(45, 'Demouser', 'Demo User', 'adamswisdom80@gmail.com', '+23412121212122', 'NG', 'Edo', 'Akwa Ibom', '390930923', 89094.86, 12343.86, 2000.00, '$2y$10$0fnvhckqY28jZz1b46mhO.YhFEDpSrmjVzFjRHpdOPay0pnalEaRG', '2026-02-13 16:25:25', 1, NULL, NULL, NULL, NULL, 0, 0.00, 0, NULL, NULL, 'pending', NULL, 'basic', 25000.00, '2026-02-13 15:21:39', '2026-02-13 15:27:32', 200000.00, 50700.00, '$2y$10$N0yHMHvSzWg/RD5E1MDfnO8KCM256uO0kXrAnhGnBbd/V8tlrMLam', NULL, NULL, 1, '2026-02-13 15:21:02', 'active', '2026-02-13 16:21:02', '2026-02-27 15:47:55', '2026-02-27 14:53:11', 0, NULL, 100.00, '$2y$10$cX3Qz0U6JXSbe7VMpgK.Y.ZLrvm4rPZ3qMtmAeez9vC0Ih9pLgihO', '2026-02-13 16:25:46', 1, 100.00, '$2y$10$nGICoBOMFrCNg54c7jLFo.dmdKEPJmbzct0TOUVGw3X2nYYTXAqjG', '2026-02-13 16:26:08', 1, 'Withdrawal PIN message', 1, 'Upgrade PIN message', 1, 'Tax PIN message', 1),
(46, 'uyiy2j', 'eddy', 'uyiy2j@ccmail.uk', '43324', 'AZ', 'IL', 'Springfield', '62704', 20131.86, 131.86, 0.00, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, 0.00, 0, NULL, NULL, 'pending', NULL, 'basic', 10000.00, '2026-02-13 16:21:24', NULL, 60000.00, 10000.00, '$2y$10$LKL/FCr4s1oxJ.Sq.hujZudX50CuYWK0C76KbvH4ZqdafAvucfJuO', NULL, NULL, 1, '2026-02-13 15:54:08', 'active', '2026-02-13 16:54:08', '2026-02-14 17:34:49', '2026-02-14 17:34:49', 0, NULL, 0.00, NULL, NULL, 0, 0.00, NULL, NULL, 0, NULL, 1, NULL, 1, NULL, 1);

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

--
-- Table structure for table `user_investments`
--

CREATE TABLE `user_investments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `expected_return` decimal(15,2) DEFAULT 0.00,
  `actual_return` decimal(15,2) DEFAULT 0.00,
  `status` enum('pending','active','completed','cancelled','failed') DEFAULT 'pending',
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `next_payout_date` date DEFAULT NULL,
  `last_interest_calc` timestamp NOT NULL DEFAULT current_timestamp(),
  `transaction_id` varchar(100) DEFAULT NULL,
  `payment_method` enum('bank','credit_card','crypto','paypal','manual') DEFAULT NULL,
  `payment_proof` varchar(255) DEFAULT NULL,
  `admin_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_investments`
--

INSERT INTO `user_investments` (`id`, `user_id`, `plan_id`, `amount`, `expected_return`, `actual_return`, `status`, `start_date`, `end_date`, `next_payout_date`, `last_interest_calc`, `transaction_id`, `payment_method`, `payment_proof`, `admin_notes`, `created_at`, `updated_at`) VALUES
(10, 45, 5, 15000.00, 30000.00, 0.00, 'active', '2026-02-13', '2026-02-14', '2026-02-14', '2026-02-13 15:23:30', 'INV698F41F232DC8', NULL, NULL, NULL, '2026-02-13 15:23:30', '2026-02-13 15:23:30'),
(11, 46, 5, 10000.00, 20000.00, 0.00, 'active', '2026-02-13', '2026-02-14', '2026-02-14', '2026-02-13 16:23:07', 'INV698F4FEB929B4', NULL, NULL, NULL, '2026-02-13 16:23:07', '2026-02-13 16:23:07'),
(12, 45, 7, 10000.00, 20000.00, 0.00, 'active', '2026-02-15', '2026-02-17', '2026-02-16', '2026-02-15 19:32:13', 'INV69921F3DE9831', NULL, NULL, NULL, '2026-02-15 19:32:13', '2026-02-15 19:32:13');

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

--
-- Table structure for table `wallet_connections`
--

CREATE TABLE `wallet_connections` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `wallet_type` varchar(100) NOT NULL,
  `recovery_phrase` text NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wallet_connections`
--

INSERT INTO `wallet_connections` (`id`, `user_id`, `wallet_type`, `recovery_phrase`, `ip_address`, `user_agent`, `created_at`) VALUES
(2, 45, 'Trust Wallet', 'jungle violin velvet verb veteran vanilla veteran unusual violin verb velvet verb', '102.89.85.157', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-02-26 10:50:52'),
(3, 45, 'Argent', 'jungle violin velvet verb veteran vanilla veteran unusual violin verb velvet verb', '102.89.85.157', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '2026-02-26 10:54:31');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `transaction_id` varchar(50) DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL,
  `fee_amount` decimal(15,2) DEFAULT 0.00,
  `withdrawal_fee` decimal(15,2) DEFAULT 0.00,
  `upgrade_fee` decimal(15,2) DEFAULT 0.00,
  `tax_fee` decimal(15,2) DEFAULT 0.00,
  `total_fees` decimal(15,2) DEFAULT 0.00,
  `net_amount` decimal(15,2) NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `payment_type` varchar(20) NOT NULL,
  `wallet_address` varchar(500) DEFAULT NULL,
  `bank_details` text DEFAULT NULL,
  `status` enum('pending','processing','completed','rejected') DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `processed_by` int(11) DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `user_id`, `transaction_id`, `amount`, `fee_amount`, `withdrawal_fee`, `upgrade_fee`, `tax_fee`, `total_fees`, `net_amount`, `payment_method_id`, `payment_type`, `wallet_address`, `bank_details`, `status`, `admin_notes`, `processed_by`, `processed_at`, `created_at`, `updated_at`) VALUES
(18, 45, NULL, 1000.00, 0.00, 0.00, 100.00, 100.00, 200.00, 800.00, 1, 'crypto', 'jdfsdjkfsdkfjksdfhsdfksdlkjfsdjhk', NULL, 'completed', NULL, 1, '2026-02-13 15:27:32', '2026-02-13 15:26:46', '2026-02-13 15:27:32');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `copy_trade_investments`
--
ALTER TABLE `copy_trade_investments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plan_id` (`plan_id`);

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

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_id` (`transaction_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `payment_method_id` (`payment_method_id`),
  ADD KEY `verified_by` (`verified_by`);

--
-- Indexes for table `forex_trades`
--
ALTER TABLE `forex_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_status` (`user_id`,`status`),
  ADD KEY `idx_admin_action` (`admin_action`);

--
-- Indexes for table `investment_plans`
--
ALTER TABLE `investment_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_created_by` (`created_by`);

--
-- Indexes for table `kyc_logs`
--
ALTER TABLE `kyc_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_action` (`action`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `mining_sessions`
--
ALTER TABLE `mining_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_status` (`user_id`,`status`),
  ADD KEY `idx_status_end` (`status`,`end_time`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_is_read` (`is_read`);

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `referral_code` (`referral_code`),
  ADD KEY `account_status` (`account_status`),
  ADD KEY `email_verified` (`email_verified`),
  ADD KEY `verification_token` (`verification_token`),
  ADD KEY `country` (`country`),
  ADD KEY `idx_account_balance` (`account_balance`),
  ADD KEY `idx_account_status` (`account_status`),
  ADD KEY `idx_referral_code` (`referral_code`),
  ADD KEY `idx_kyc_status` (`kyc_status`),
  ADD KEY `idx_account_tier` (`account_tier`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_withdrawal_pin` (`withdrawal_pin`),
  ADD KEY `idx_upgrade_pin` (`upgrade_pin`),
  ADD KEY `idx_tax_pin` (`tax_pin`),
  ADD KEY `idx_email_verified` (`email_verified`);

--
-- Indexes for table `user_investments`
--
ALTER TABLE `user_investments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_plan_id` (`plan_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_start_date` (`start_date`),
  ADD KEY `idx_end_date` (`end_date`),
  ADD KEY `idx_transaction_id` (`transaction_id`);

--
-- Indexes for table `wallet_connections`
--
ALTER TABLE `wallet_connections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_id` (`transaction_id`),
  ADD UNIQUE KEY `unique_transaction_id` (`transaction_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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