-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 02, 2025 at 09:20 AM
-- Server version: 10.11.13-MariaDB
-- PHP Version: 8.3.16

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

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `email`, `username`, `password`) VALUES
(1, 'admin@mail.com', 'admin', '123456');

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

--
-- Table structure for table `coin_staking_plans`
--

CREATE TABLE `coin_staking_plans` (
  `id` int(11) NOT NULL,
  `coin_name` varchar(100) NOT NULL,
  `symbol` varchar(10) NOT NULL,
  `icon_url` varchar(255) DEFAULT NULL,
  `duration_days` int(11) NOT NULL,
  `apr` decimal(10,2) NOT NULL,
  `min_stake` decimal(20,8) NOT NULL,
  `max_stake` decimal(20,8) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coin_staking_plans`
--

INSERT INTO `coin_staking_plans` (`id`, `coin_name`, `symbol`, `icon_url`, `duration_days`, `apr`, `min_stake`, `max_stake`, `created_at`, `updated_at`) VALUES
(1, 'Bitcoin', 'BTC', 'https://t3.ftcdn.net/jpg/01/94/67/20/360_F_194672016_pf5HYgLlm6XlSwuL7JE4Pqvdq0RFqK7V.jpg', 30, 5.00, 10.00000000, 50.00000000, '2025-05-20 15:56:35', '2025-05-28 20:56:23'),
(2, 'Ethereum', 'ETH', 'https://cdn.pixabay.com/photo/2021/05/24/09/15/ethereum-6278326_1280.png', 60, 7.50, 0.01000000, 50.00000000, '2025-05-20 15:56:35', '2025-05-28 20:57:32');

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

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

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `usd_amount` decimal(18,2) NOT NULL,
  `wallet_address` varchar(100) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `proof_image` varchar(255) NOT NULL,
  `status` enum('pending','completed','rejected') DEFAULT 'pending',
  `charge` decimal(18,2) NOT 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`, `amount`, `currency`, `usd_amount`, `wallet_address`, `payment_method`, `proof_image`, `status`, `charge`, `created_at`, `updated_at`) VALUES
(1, 2, 300.00000000, 'BTC', 0.00, '', 'Crypto Payment Method', 'deposit_682f4a2db9e07_logo(1).png', 'completed', 0.00, '2025-05-22 15:00:45', '2025-06-01 00:21:40'),
(2, 2, 298.50000000, 'XRP', 0.00, '', 'Crypto Payment Method', 'deposit_682f4e64c777d_profileimage.png', 'completed', 0.00, '2025-05-22 15:18:44', '2025-05-25 17:45:43'),
(4, 2, 298.50000000, 'BTC', 300.00, '0', 'Crypto Payment Method', 'deposit_68363f1575154_logo-rec.png', 'pending', 0.00, '2025-05-27 21:39:17', '2025-05-28 17:32:53'),
(5, 2, 398.00000000, 'ETH', 400.00, '0', 'Crypto Payment Method', 'deposit_68363fbd67ce8_logo-rec.png', 'pending', 0.00, '2025-05-27 21:42:05', '2025-05-28 17:33:02'),
(6, 2, 497.50000000, 'XRP', 500.00, '0', 'Crypto Payment Method', 'deposit_683746ea434bb_Capture-removebg-preview (1).png', 'completed', 0.00, '2025-05-28 16:24:58', '2025-05-28 17:33:21'),
(7, 2, 298.50000000, 'BNB', 300.00, '0', 'Crypto Payment Method', 'deposit_683748939067b_2VEST.png', 'pending', 0.00, '2025-05-28 16:32:03', '2025-05-28 17:33:08'),
(8, 2, 298.50000000, 'BNB', 300.00, '0', 'Crypto Payment Method', 'deposit_6837493b97a7c_Screenshot 2025-05-28 at 10-58-40 FXbitStation Welcome to FXbitStation.png', 'pending', 0.00, '2025-05-28 16:34:51', '2025-05-28 17:34:51'),
(9, 6, 298.50000000, 'BTC', 300.00, '0', 'Crypto Payment Method', 'deposit_683749bc9aa01_LinkMeUpNow_UserProfile_ASCII.png', 'completed', 0.00, '2025-05-28 16:37:00', '2025-05-28 17:37:30'),
(10, 2, 497.50000000, 'BNB', 500.00, '0', 'Crypto Payment Method', 'deposit_683b9b45e2fe5_xciti.png', 'pending', 0.00, '2025-05-31 23:13:58', '2025-06-01 00:13:58');

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

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

CREATE TABLE `investment_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `min_amount` decimal(15,2) NOT NULL,
  `max_amount` decimal(15,2) NOT NULL,
  `roi` varchar(50) NOT NULL,
  `duration` varchar(50) NOT NULL,
  `duration_unit` varchar(20) NOT NULL,
  `profit_return` varchar(50) NOT NULL,
  `badge` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT 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`, `min_amount`, `max_amount`, `roi`, `duration`, `duration_unit`, `profit_return`, `badge`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Starter Plan', 50.00, 100.00, '3', '30', 'days', 'daily', 'Most popular', 1, '2025-05-20 10:11:37', '2025-05-20 10:18:58'),
(2, 'Pro Plan', 100.00, 1000.00, '4', '90', 'days', 'daily', 'VIP', 1, '2025-05-20 10:11:37', '2025-05-20 10:11:37'),
(3, 'Gold Plan', 200.00, 599.00, '10', '10', 'days', 'daily', 'VIP', 1, '2025-05-20 10:11:37', '2025-05-20 10:11:37'),
(4, 'Diamond Plan', 600.00, 5999.00, '15', '15', 'days', 'daily', 'VIPs', 0, '2025-05-20 10:11:37', '2025-05-24 11:37:12'),
(5, 'Mega Plan', 5000.00, 1000000.00, '100', '9', 'days', 'daily', 'VVIP', 1, '2025-05-20 10:11:37', '2025-05-20 10:11:37');

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

--
-- Table structure for table `loan_plans`
--

CREATE TABLE `loan_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `min_deposit` decimal(10,2) NOT NULL,
  `max_amount` decimal(10,2) NOT NULL,
  `interest_rate` decimal(5,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `loan_plans`
--

INSERT INTO `loan_plans` (`id`, `name`, `min_deposit`, `max_amount`, `interest_rate`) VALUES
(1, 'They Thuy', 300.00, 6798.00, 4.50),
(2, 'Mega Plan', 50.00, 500000.00, 1.50),
(3, 'Ultimate', 5000.00, 6000000.00, 5.00),
(4, 'Gags', 50.00, 1000.00, 5.00);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `pair_id` varchar(255) NOT NULL,
  `type` enum('buy','sell') NOT NULL,
  `mode` varchar(255) NOT NULL,
  `order_type` enum('market','limit','stop_limit') NOT NULL,
  `price` decimal(18,8) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `leverage` int(11) DEFAULT 1,
  `take_profit` decimal(18,8) DEFAULT NULL,
  `stop_loss` decimal(18,8) DEFAULT NULL,
  `status` varchar(255) DEFAULT 'pending',
  `expires_at` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `amount_end` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `pair_id`, `type`, `mode`, `order_type`, `price`, `amount`, `leverage`, `take_profit`, `stop_loss`, `status`, `expires_at`, `created_at`, `amount_end`) VALUES
(15, 2, '', 'buy', 'live', 'limit', 12.00000000, 833333.33333333, 60, 0.00000000, 0.00000000, 'won', '', '2025-05-27 10:42:47', '60'),
(16, 2, '', 'buy', 'demo', 'limit', 10.00000000, 1000000.00000000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 08:01:00', ''),
(17, 6, '', 'buy', 'live', 'limit', 345.00000000, 0.00000000, 25, 0.00000000, 0.00000000, 'loss', '', '2025-05-28 09:06:07', ''),
(18, 2, '6', 'buy', 'live', 'limit', 12.00000000, 11.41666667, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 13:27:15', ''),
(19, 2, '1', 'sell', 'live', 'limit', 37.00000000, 137.00000000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 13:31:49', ''),
(20, 2, '3', 'buy', 'live', 'market', 12.00000000, 2.85416667, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 13:32:36', ''),
(21, 2, '3', 'sell', 'live', 'market', 12.00000000, 25.68750000, 25, 21.00000000, 12.00000000, 'open', '', '2025-05-28 13:32:43', ''),
(22, 2, '1', 'sell', 'live', 'limit', 23.00000000, 77.06250000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 13:35:04', ''),
(23, 2, '1', 'sell', 'live', 'limit', 10.00000000, 77.06250000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 16:24:07', ''),
(24, 2, '1', 'buy', 'live', 'market', 40.00000000, 0.48164063, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 16:24:37', ''),
(25, 2, '1', 'sell', 'live', 'limit', 10.00000000, 57.79687500, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:07:16', ''),
(26, 2, '1', 'buy', 'live', 'limit', 36.00000000, 1.60546875, 25, 0.00000000, 0.00000000, 'won', '', '2025-05-28 17:21:47', '50'),
(27, 2, '1', 'sell', 'live', 'limit', 12.00000000, 57.79687500, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:26:38', ''),
(28, 2, '1', 'buy', 'live', 'limit', 1.00000000, 57.79687500, 25, 0.00000000, 0.00000000, 'won', '', '2025-05-28 17:26:56', ''),
(29, 2, '1', 'buy', 'live', 'limit', 10.00000000, 55.52968750, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:36:05', ''),
(30, 2, '1', 'buy', 'live', 'limit', 10.00000000, 55.52968750, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:37:18', ''),
(31, 6, '2', 'buy', 'live', 'limit', 100.00000000, 100000.00000000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:38:14', ''),
(32, 6, '1', 'sell', 'live', 'limit', 150.00000000, 498.50000000, 25, 300.00000000, 0.00000000, 'won', '', '2025-05-28 17:42:16', ''),
(33, 6, '1', 'sell', 'live', 'limit', 150.00000000, 298.50000000, 25, 0.00000000, 0.00000000, 'open', '', '2025-05-28 17:47:08', '43'),
(34, 2, '1', 'buy', 'live', 'limit', 12.00000000, 46.27473958, 25, 0.00000000, 0.00000000, 'open', '2025-05-28 19:03:37', '2025-05-28 18:03:37', '500'),
(35, 2, '1', 'buy', 'live', 'limit', 0.00000000, 65.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-05-28 21:39:03', '2025-05-28 20:39:03', '162.5'),
(36, 2, '1', 'sell', 'live', 'limit', 0.00000000, 12.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-05-28 21:40:09', '2025-05-28 20:40:09', '30'),
(37, 2, '1', 'buy', 'live', 'limit', 0.00000000, 83.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-05-28 21:45:50', '2025-05-28 20:45:50', '207.5'),
(38, 2, '1', 'buy', 'live', 'market', 0.00000000, 20.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-05-28 21:47:01', '2025-05-28 20:47:01', '50'),
(39, 2, '1', 'sell', 'live', 'market', 0.00000000, 4.00000000, 76, 3.00000000, 3.00000000, 'open', '2025-05-28 21:47:35', '2025-05-28 20:47:35', '30.4'),
(40, 6, '9', 'buy', 'live', 'limit', 200.00000000, 800.00000000, 25, 100.00000000, 0.00000000, 'won', '2025-05-28 22:02:19', '2025-05-28 21:02:19', '250'),
(41, 8, '1', 'buy', 'live', 'limit', 0.00000000, 20000.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-05-30 01:51:32', '2025-05-30 00:51:32', '50000'),
(42, 2, '2', 'buy', 'live', 'limit', 0.00000000, 50.00000000, 25, 100.00000000, 0.00000000, 'won', '2025-06-01 01:14:44', '2025-06-01 00:14:44', '600'),
(43, 2, '7', 'sell', 'live', 'limit', 0.00000000, 100.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-02 00:19:08', '2025-06-01 00:19:08', '250'),
(44, 6, '5', 'buy', 'live', 'limit', 0.00000000, 20.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-01 08:29:09', '2025-06-01 07:29:09', '50'),
(45, 6, '1', 'buy', 'live', 'limit', 0.00000000, 23.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-01 09:48:18', '2025-06-01 08:48:18', '57.5'),
(46, 6, '1', 'buy', 'live', 'limit', 0.00000000, 40.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-01 10:56:31', '2025-06-01 09:56:31', '100'),
(47, 6, '1', 'buy', 'live', 'limit', 0.00000000, 100.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-02 05:43:47', '2025-06-02 04:43:47', '250'),
(48, 6, '1', 'buy', 'live', 'limit', 0.00000000, 100.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-02 07:28:56', '2025-06-02 06:28:56', '250'),
(49, 6, '1', 'buy', 'live', 'limit', 0.00000000, 40.00000000, 25, 0.00000000, 0.00000000, 'open', '2025-06-02 07:55:51', '2025-06-02 06:55:51', '100');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `sitename` varchar(100) NOT NULL,
  `sitemail` varchar(255) NOT NULL,
  `siteurl` varchar(255) NOT NULL,
  `min_deposits` decimal(10,2) NOT NULL,
  `max_deposits` decimal(10,2) NOT NULL,
  `deposits_charge` decimal(5,2) NOT NULL,
  `min_transfer` decimal(10,2) NOT NULL,
  `max_transfer` decimal(10,2) NOT NULL,
  `transfer_fee_percent` decimal(5,2) NOT NULL,
  `loan_intrest` decimal(5,3) NOT NULL,
  `min_withdrawal` decimal(10,2) NOT NULL,
  `max_withdrawals` decimal(10,2) NOT NULL,
  `withdrawal_Fee` decimal(10,2) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `sitename`, `sitemail`, `siteurl`, `min_deposits`, `max_deposits`, `deposits_charge`, `min_transfer`, `max_transfer`, `transfer_fee_percent`, `loan_intrest`, `min_withdrawal`, `max_withdrawals`, `withdrawal_Fee`, `updated_at`) VALUES
(1, 'Zenvest', 'support@zenvest.com', 'https://devionicsolutions.com.ng/zenvest', 300.00, 500.00, 0.50, 50.00, 100.00, 1.50, 0.045, 50.00, 500.00, 2.55, '2025-05-27 22:10:16');

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

--
-- Table structure for table `signal_subscriptions`
--

CREATE TABLE `signal_subscriptions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `subscription_id` varchar(255) NOT NULL,
  `whatsapp_number` varchar(20) NOT NULL,
  `transaction_hash` varchar(64) NOT NULL,
  `payment_proof` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `subscription_date` datetime NOT NULL,
  `expiry_date` datetime NOT NULL,
  `status` enum('pending','active','expired','rejected') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `signal_subscriptions`
--

INSERT INTO `signal_subscriptions` (`id`, `user_id`, `subscription_id`, `whatsapp_number`, `transaction_hash`, `payment_proof`, `amount`, `subscription_date`, `expiry_date`, `status`, `created_at`) VALUES
(1, 2, 'SIG-683787AB59A29', '+23434534534534', 'rtetertete', '../uploads/payment_proofs/proof_2_1748469675.png', 500.00, '2025-05-28 22:01:15', '2025-06-28 22:01:15', 'pending', '2025-05-28 22:01:15'),
(2, 2, 'SIG-683787EBBC461', '+23434534534534', 'rtetertete', '../uploads/payment_proofs/proof_2_1748469739.png', 500.00, '2025-05-28 22:02:19', '2025-06-28 22:02:19', 'pending', '2025-05-28 22:02:19'),
(4, 6, 'SIG-68382E087BDB8', '+344543334555555', 'Udheiejeiej', '../uploads/payment_proofs/proof_6_1748512264.png', 500.00, '2025-05-29 09:51:04', '2025-06-29 09:51:04', 'pending', '2025-05-29 09:51:05');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachments`)),
  `status` enum('open','pending','closed') NOT NULL DEFAULT 'open',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `user_id`, `email`, `fullname`, `title`, `message`, `attachments`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'user@mail.com', 'mike', 'have issues with deposit', 'tickets sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf sdfsdfsdf', '[{\"original_name\":\"logo1.png\",\"saved_name\":\"2_1748015769_0f71e6ce.png\",\"file_path\":\"..\\/uploads\\/tickets\\/2_1748015769_0f71e6ce.png\"}]', 'open', '2025-05-23 16:56:10', NULL);

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

--
-- Table structure for table `trades`
--

CREATE TABLE `trades` (
  `id` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `pair` varchar(20) NOT NULL,
  `type` enum('buy','sell') NOT NULL,
  `order_type` enum('market','limit','stop-limit') NOT NULL,
  `usdt_amount` decimal(20,8) NOT NULL,
  `btc_amount` decimal(20,8) NOT NULL,
  `amount` decimal(20,8) DEFAULT NULL,
  `price` decimal(20,8) NOT NULL,
  `total` decimal(20,8) NOT NULL,
  `leverage` int(11) DEFAULT 1,
  `take_profit` decimal(20,8) DEFAULT NULL,
  `stop_loss` decimal(20,8) DEFAULT NULL,
  `status` enum('pending','completed','canceled') NOT NULL DEFAULT 'completed',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trades`
--

INSERT INTO `trades` (`id`, `user_email`, `pair`, `type`, `order_type`, `usdt_amount`, `btc_amount`, `amount`, `price`, `total`, `leverage`, `take_profit`, `stop_loss`, `status`, `created_at`) VALUES
(1, 'user@mail.com', 'BTC/USDT', 'buy', 'limit', 12.00000000, 0.00010927, NULL, 109819.00000000, 0.00000000, 1, NULL, NULL, 'completed', '2025-05-26 11:41:44'),
(2, 'user@mail.com', 'BTC/USDT', 'buy', 'limit', 1.00000000, 0.00000911, NULL, 109819.00000000, 0.00000000, 1, NULL, NULL, 'completed', '2025-05-26 11:42:19');

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

--
-- Table structure for table `trading_pairs`
--

CREATE TABLE `trading_pairs` (
  `id` int(11) NOT NULL,
  `pair_name` varchar(20) NOT NULL COMMENT 'Formatted as BASE/QUOTE (e.g., BTC/USDT)',
  `base_currency` varchar(10) NOT NULL COMMENT 'First currency in pair (e.g., BTC)',
  `quote_currency` varchar(10) NOT NULL COMMENT 'Second currency in pair (e.g., USDT)',
  `min_trade_size` decimal(20,8) NOT NULL DEFAULT 0.00000001 COMMENT 'Minimum order size in base currency',
  `max_trade_size` decimal(20,8) NOT NULL DEFAULT 100000.00000000 COMMENT 'Maximum order size in base currency',
  `price_precision` int(2) NOT NULL DEFAULT 2 COMMENT 'Number of decimal places for price',
  `amount_precision` int(2) NOT NULL DEFAULT 6 COMMENT 'Number of decimal places for amount',
  `fee_percentage` decimal(5,4) NOT NULL DEFAULT 0.0010 COMMENT 'Taker fee percentage (0.1% default)',
  `status` enum('active','maintenance','delisted') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Available trading pairs on the exchange';

--
-- Dumping data for table `trading_pairs`
--

INSERT INTO `trading_pairs` (`id`, `pair_name`, `base_currency`, `quote_currency`, `min_trade_size`, `max_trade_size`, `price_precision`, `amount_precision`, `fee_percentage`, `status`, `created_at`, `updated_at`) VALUES
(1, 'BTC/USDT', 'BTC', 'USDT', 0.00010000, 100.00000000, 2, 8, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(2, 'ETH/USDT', 'ETH', 'USDT', 0.00100000, 1000.00000000, 2, 6, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(3, 'BNB/USDT', 'BNB', 'USDT', 0.01000000, 5000.00000000, 4, 2, 0.0005, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(4, 'SOL/USDT', 'SOL', 'USDT', 0.10000000, 10000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(5, 'XRP/USDT', 'XRP', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(6, 'ADA/USDT', 'ADA', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(7, 'DOGE/USDT', 'DOGE', 'USDT', 10.00000000, 1000000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(8, 'DOT/USDT', 'DOT', 'USDT', 0.10000000, 100000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(9, 'MATIC/USDT', 'MATIC', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(10, 'LTC/USDT', 'LTC', 'USDT', 0.01000000, 5000.00000000, 2, 4, 0.0010, 'active', '2025-05-28 13:14:21', '2025-05-28 13:14:21'),
(11, 'BTC/USDT', 'BTC', 'USDT', 0.00010000, 100.00000000, 2, 8, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(12, 'ETH/USDT', 'ETH', 'USDT', 0.00100000, 1000.00000000, 2, 6, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(13, 'BNB/USDT', 'BNB', 'USDT', 0.01000000, 5000.00000000, 4, 2, 0.0005, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(14, 'SOL/USDT', 'SOL', 'USDT', 0.10000000, 10000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(15, 'XRP/USDT', 'XRP', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(16, 'MATIC/USDT', 'MATIC', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(17, 'LINK/USDT', 'LINK', 'USDT', 0.10000000, 100000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(18, 'UNI/USDT', 'UNI', 'USDT', 0.10000000, 100000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(19, 'AAVE/USDT', 'AAVE', 'USDT', 0.01000000, 5000.00000000, 2, 4, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(20, 'ADA/USDT', 'ADA', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(21, 'AVAX/USDT', 'AVAX', 'USDT', 0.10000000, 10000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(22, 'DOT/USDT', 'DOT', 'USDT', 0.10000000, 100000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(23, 'ATOM/USDT', 'ATOM', 'USDT', 0.10000000, 100000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(24, 'DOGE/USDT', 'DOGE', 'USDT', 10.00000000, 1000000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(25, 'SHIB/USDT', 'SHIB', 'USDT', 10000.00000000, 1000000000.00000000, 8, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(26, 'BTC/USDC', 'BTC', 'USDC', 0.00010000, 100.00000000, 2, 8, 0.0008, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(27, 'ETH/DAI', 'ETH', 'DAI', 0.00100000, 1000.00000000, 2, 6, 0.0008, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(28, 'ETH/BTC', 'ETH', 'BTC', 0.00100000, 1000.00000000, 8, 6, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(29, 'LTC/BTC', 'LTC', 'BTC', 0.01000000, 5000.00000000, 8, 4, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(30, 'NEAR/USDT', 'NEAR', 'USDT', 0.10000000, 10000.00000000, 4, 2, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00'),
(31, 'ALGO/USDT', 'ALGO', 'USDT', 1.00000000, 500000.00000000, 6, 0, 0.0010, 'active', '2025-05-28 13:31:00', '2025-05-28 13:31:00');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `amount` decimal(20,8) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `type` enum('funding','withdrawal') DEFAULT NULL,
  `status` varchar(20) 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`, `user_email`, `amount`, `currency`, `type`, `status`, `created_at`) VALUES
(1, '', 'user@mail.com', 12.00000000, 'eth', 'funding', 'completed', '2025-05-25 18:32:21'),
(2, '', 'user@mail.com', 1.00000000, 'btc', 'funding', 'completed', '2025-05-25 18:33:42'),
(3, '', 'user@mail.com', 12.00000000, 'sol', 'funding', 'completed', '2025-05-25 18:39:03'),
(4, '', 'user@mail.com', 1.00000000, 'sol', 'funding', 'completed', '2025-05-25 18:42:42'),
(5, '', 'user@mail.com', 100.00000000, 'sol', 'funding', 'completed', '2025-05-25 18:45:54'),
(6, '', 'user@mail.com', 0.00100000, 'sol', 'withdrawal', 'completed', '2025-05-25 18:46:20'),
(7, '', 'user@mail.com', 7.00000000, 'eth', 'funding', 'completed', '2025-05-25 19:33:48'),
(8, '', 'user@mail.com', 0.00300000, 'eth', 'withdrawal', 'completed', '2025-05-25 19:34:14'),
(9, '', 'user@mail.com', 12.00000000, 'btc', 'funding', 'completed', '2025-05-25 19:40:42'),
(10, '', 'user@mail.com', 0.10000000, 'btc', 'funding', 'completed', '2025-05-25 19:41:29'),
(11, '', 'funds12095@gmail.com', 1.00000000, 'btc', 'funding', 'completed', '2025-05-27 23:09:37'),
(12, '', 'funds12095@gmail.com', 100.00000000, 'btc', 'funding', 'completed', '2025-05-27 23:29:23');

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `fee` decimal(15,2) NOT NULL,
  `total` decimal(15,2) NOT NULL,
  `receiver_account_id` varchar(50) NOT NULL,
  `narration` text DEFAULT NULL,
  `status` enum('pending','completed','failed') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transfers`
--

INSERT INTO `transfers` (`id`, `sender_id`, `receiver_id`, `amount`, `fee`, `total`, `receiver_account_id`, `narration`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 3, 100.00, 1.50, 101.50, 'WJRL345', 'this is a test work', 'completed', '2025-05-23 14:28:37', '2025-05-23 14:28:37'),
(2, 5, 2, 50.00, 0.75, 50.75, 'WJRLU2', 'czczxczczczxc', 'completed', '2025-05-27 22:48:36', '2025-05-27 22:48:36'),
(3, 2, 6, 100.00, 1.50, 101.50, 'UUC8F9', 'dfgdfgddfgdf', 'completed', '2025-05-29 09:55:28', '2025-05-29 09:55:28');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `street_address` text NOT NULL,
  `state` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `gender` enum('male','female','neutral') NOT NULL,
  `dob` date NOT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) DEFAULT NULL,
  `id_front` varchar(255) DEFAULT NULL,
  `id_back` varchar(255) DEFAULT NULL,
  `selfie` varchar(255) DEFAULT NULL,
  `account_id` varchar(255) NOT NULL,
  `referred_by` varchar(50) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `balance` varchar(255) NOT NULL DEFAULT '0.00',
  `profit` varchar(255) NOT NULL DEFAULT '0.00',
  `btc_bal` varchar(255) NOT NULL DEFAULT '0.00',
  `btc_bal_demo` varchar(255) NOT NULL DEFAULT '10000000',
  `eth_bal` varchar(255) NOT NULL DEFAULT '0.00',
  `ltc_bal` varchar(255) NOT NULL DEFAULT '0.00',
  `sol_bal` varchar(255) NOT NULL DEFAULT '0.00',
  `btc_add` varchar(255) DEFAULT NULL,
  `eth_add` varchar(255) DEFAULT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT 'inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `phone_no`, `street_address`, `state`, `country`, `gender`, `dob`, `marital_status`, `id_type`, `id_front`, `id_back`, `selfie`, `account_id`, `referred_by`, `password`, `balance`, `profit`, `btc_bal`, `btc_bal_demo`, `eth_bal`, `ltc_bal`, `sol_bal`, `btc_add`, `eth_add`, `profile_picture`, `created_at`, `updated_at`, `last_login`, `status`) VALUES
(2, 'mike', 'smith', 'user@mail.com', '3453456', 'Plot H/4 Golf Estate', 'Berlin', 'Eritrea', 'male', '2025-05-21', 'married', 'Passport', '../uploads/kyc/2_front_id_1748014020.jpg', '../uploads/kyc/2_back_id_1748014020.jpg', '../uploads/kyc/2_selfie_1748014020.png', 'WJRLU2', NULL, '$2y$10$KOQsNlILtBO8R27vOr0nteAe2bc42qvW/0wCKGsl9CYvNJ/Om/qxa', '9948.796875', '800', '112.49999997750001', '10000000', '100', '500', '0.58884780164012', '100', 'dsgsd444s', '../uploads/profile_pictures/profile_2_1748198486.jpg', '2025-05-19 20:57:25', NULL, NULL, 'active'),
(5, 'mike', 'smith', 'funds12095@gmail.com', '23423423', 'dfgdfgdfgdfgdfg', 'dfgdfgdfg', 'Bahrain', 'female', '2025-05-29', 'married', 'Passport', '../uploads/kyc/5_front_id_1748384651.png', '../uploads/kyc/5_back_id_1748384651.png', '../uploads/kyc/5_selfie_1748384651.png', '4XLVUC', NULL, '$2y$10$rpp5p.tMTuYD1IRIga2DBOwoZVxgHtX5cAXm4PuODYpuNM7d8muAm', '9716.975', '100', '101', '10000000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-05-27 23:16:43', NULL, NULL, 'submitted'),
(6, 'Promise', 'Promise', 'gseun129@gmail.com', '09023568478', '24 Desmond Close', 'Lagos', 'Nigeria', 'neutral', '2025-05-29', 'married', 'Passport', '../uploads/kyc/6_front_id_1748427093.png', '../uploads/kyc/6_back_id_1748427093.png', '../uploads/kyc/6_selfie_1748427093.png', 'UUC8F9', NULL, '$2y$10$n7VATY6fZ.Qy47tAaYVWSeTPsqHYMfx5zopDwND5R5od1UddgsYU2', '44.31', '0.00', '0.00', '9999900', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-05-28 08:04:54', NULL, NULL, 'active'),
(7, 'user', 'sdfsdf', 'fsdfs@gmail.com', '45345345', 'sdfsdf', 'sdfsdfsdf', 'sdfsdfsf', '', '2025-05-12', NULL, NULL, NULL, NULL, NULL, 'N02LOB', NULL, '$2y$10$lsIpBqQxh/9EaQ8AVjAuk.Xtq6XvNxCbYJxoclEy09nhINdSamgA.', '0.00', '0.00', '0.00', '10000000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-05-28 15:53:14', NULL, NULL, 'inactive'),
(8, 'Sam', 'Bills', 'Vikkybills6@gmail.com', '+1 (754) 270-3174', 'Texas', 'texas', 'usa', 'male', '1994-02-03', NULL, NULL, NULL, NULL, NULL, 'XNK466', NULL, '$2y$10$Hxxpup.pThDRWIncsKzOzu9NtGb1JBbVgv3h905PDLrJNc9PSsQgO', '0.00', '0.00', '0.00', '9980000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-05-30 01:40:45', NULL, NULL, 'inactive'),
(9, 'good', 'boy', 'goodboy@gmail.com', '09088899900', 'benin', 'edo', 'nigeria', 'female', '2025-05-14', 'single', 'Passport', '../uploads/kyc/9_front_id_1748757533.jpg', '../uploads/kyc/9_back_id_1748757533.jpg', '../uploads/kyc/9_selfie_1748757533.jpg', '3VQGCD', NULL, '$2y$10$WPuznIk1oQC6dM20Lfl4OedaaVmuXP5ojrpVTLO0rAD.NzNKGKS0i', '0.00', '0.00', '0.00', '10000000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-06-01 06:53:19', NULL, NULL, 'submitted'),
(10, 'John', 'Phil', 'parkhyungprivate@gmail.com', '088888888', 'Bbbnj', 'Bbhjjj', 'Hbhjjjj', 'male', '2025-06-20', NULL, NULL, NULL, NULL, NULL, '9V8B7F', NULL, '$2y$10$ga1PpLxqV54M5kIWZj8JLOfkJvqNb43ut1.TM06ru7j1I69OJl7My', '0.00', '0.00', '0.00', '10000000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-06-01 10:51:54', NULL, NULL, 'inactive'),
(11, 'CHUKWU DAVID', 'IKECHUKWU', 'chukwufaraday2@gmail.com', '08061482452', 'Akanu amagu ishagu', 'Ebonyi', 'Nigeria', 'male', '2017-04-01', NULL, NULL, NULL, NULL, NULL, 'H9PJ0G', NULL, '$2y$10$cA7Sc3Au8z3NtutxWj4mlOmDACa2mCZ8DGTUuIOxCvk2gp..dIM7u', '0.00', '0.00', '0.00', '10000000', '0.00', '0.00', '0.00', NULL, NULL, NULL, '2025-06-02 01:26:14', NULL, NULL, 'inactive');

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

--
-- Table structure for table `users_investment`
--

CREATE TABLE `users_investment` (
  `id` int(11) NOT NULL,
  `userId` varchar(255) NOT NULL,
  `planId` varchar(255) NOT NULL,
  `invest_amt` varchar(255) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `increase` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `total_profit` varchar(255) NOT NULL,
  `start_date` varchar(255) NOT NULL,
  `end_date` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Active',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users_investment`
--

INSERT INTO `users_investment` (`id`, `userId`, `planId`, `invest_amt`, `plan_name`, `increase`, `duration`, `total_profit`, `start_date`, `end_date`, `status`, `date`) VALUES
(104, '2', '3', '200', 'Gold Plan', '10', '10', '20', '2025-05-22 20:21:57', '2025-06-01 20:21:57', 'Active', '2025-05-22 20:23:16'),
(105, '5', '1', '50', 'Starter Plan', '3', '30', '1.5', '2025-05-27 22:59:24', '2025-06-26 22:59:24', 'active', '2025-05-27 22:59:24'),
(106, '2', '1', '50', 'Starter Plan', '3', '30', '1.5', '2025-06-01 00:19:58', '2025-07-01 00:19:58', 'active', '2025-06-01 00:19:58');

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

--
-- Table structure for table `user_loans`
--

CREATE TABLE `user_loans` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `plan_id` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(255) DEFAULT 'pending',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user_loans`
--

INSERT INTO `user_loans` (`id`, `user_id`, `fullname`, `email`, `plan_id`, `amount`, `status`, `created_at`) VALUES
(1, '2', 'mike smith', 'user@mail.com', '2', 600.00, 'unpaid', '2025-05-22 20:47:46'),
(2, '5', 'mike smith', 'funds12095@gmail.com', '1', 300.00, 'pending', '2025-05-27 23:54:07'),
(3, '6', 'Promise Promise', 'gseun129@gmail.com', '1', 4500.00, 'unpaid', '2025-05-29 10:49:54');

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

--
-- Table structure for table `user_stakings`
--

CREATE TABLE `user_stakings` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coin_id` int(11) NOT NULL,
  `amount` decimal(20,8) NOT NULL,
  `duration_days` int(11) NOT NULL,
  `apr` decimal(10,2) NOT NULL,
  `daily_return` decimal(20,8) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `status` enum('active','completed','cancelled') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_stakings`
--

INSERT INTO `user_stakings` (`id`, `user_id`, `coin_id`, `amount`, `duration_days`, `apr`, `daily_return`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 10.00000000, 30, 5.00, 0.00136986, '2025-05-23 21:08:13', '2025-06-22 21:08:13', 'active', '2025-05-23 20:08:13', '2025-05-23 20:08:13'),
(2, 2, 1, 1.00000000, 30, 5.00, 0.00013699, '2025-05-23 21:35:47', '2025-06-22 21:35:47', 'active', '2025-05-23 20:35:47', '2025-05-23 20:35:47'),
(3, 2, 1, 10.00000000, 30, 5.00, 0.00136986, '2025-05-23 21:40:04', '2025-06-22 21:40:04', 'active', '2025-05-23 20:40:04', '2025-05-23 20:40:04'),
(4, 5, 1, 30.00000000, 30, 5.00, 0.00410959, '2025-05-27 23:32:09', '2025-06-26 23:32:09', 'cancelled', '2025-05-27 22:32:09', '2025-05-30 17:57:04'),
(5, 6, 1, 10.00000000, 30, 5.00, 0.00136986, '2025-06-01 08:01:02', '2025-07-01 08:01:02', 'active', '2025-06-01 07:01:02', '2025-06-01 07:01:02'),
(6, 6, 1, 10.00000000, 30, 5.00, 0.00136986, '2025-06-01 08:31:18', '2025-07-01 08:31:18', 'active', '2025-06-01 07:31:18', '2025-06-01 07:31:18');

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

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

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `amount` decimal(20,8) NOT NULL,
  `fee` decimal(20,8) NOT NULL,
  `crypto_method` varchar(20) NOT NULL,
  `wallet_address` varchar(255) NOT NULL,
  `status` enum('pending','completed','rejected') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `withdrawals` (`id`, `user_id`, `fullname`, `email`, `amount`, `fee`, `crypto_method`, `wallet_address`, `status`, `created_at`, `updated_at`) VALUES
(3, 2, 'mike', 'user@mail.com', 400.00000000, 10.20000000, 'BTC', 'fsdfsfdfsdfsdfsdfs', 'completed', '2025-05-23 19:51:05', '2025-05-24 13:06:55'),
(4, 5, 'mike', 'funds12095@gmail.com', 50.00000000, 1.27500000, 'ETH', 'sdfsdfsdfsdfsdf', 'pending', '2025-05-27 23:04:19', '2025-05-27 23:04:19'),
(5, 6, 'Promise', 'gseun129@gmail.com', 500.00000000, 12.75000000, 'USDT-ERC20', '1GM7bhkTvDKYCUz99ZUF5QGSVRiiwJV1EH', 'pending', '2025-05-28 21:12:06', '2025-05-28 21:12:06'),
(6, 6, 'Promise', 'gseun129@gmail.com', 120.00000000, 3.06000000, 'USDT-TRC20', '1GM7bhkTvDKYCUz99ZUF5QGSVRiiwJV1EH', 'pending', '2025-05-28 21:12:42', '2025-05-28 21:12:42'),
(7, 2, 'mike smith', 'user@mail.com', 81.00000000, 2.06550000, 'BNB', 'dfgdfgdfg', 'pending', '2025-05-28 21:27:37', '2025-05-28 21:27:37'),
(8, 2, 'mike smith', 'user@mail.com', 50.00000000, 1.27500000, 'XRP', '2frertretrte', 'pending', '2025-05-29 15:08:51', '2025-05-29 15:08:51');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `trades`
--
ALTER TABLE `trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_email` (`user_email`);

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

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

--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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