-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `copiedsignal`
--

CREATE TABLE `copiedsignal` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `strikerate` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `copiedsignal`
--

INSERT INTO `copiedsignal` (`id`, `name`, `email`, `strikerate`) VALUES
(1, 'CEO MUSK', 'last@gmail.com', 26.89),
(2, 'Enfant Terrible', 'last@gmail.com', 69.98),
(3, 'Enfant Terrible', 'last@gmail.com', 69.98),
(4, 'AI ALPHA', 'last@gmail.com', 78),
(5, 'CEO MUSK', 'last@gmail.com', 24.78),
(6, 'idalis', 'madukwebethel995@gmail.com', 45),
(7, 'idalis', 'madukwebethel995@gmail.com', 45),
(8, 'Kevin Svenson', 'madukwebethel995@gmail.com', 59),
(9, 'Kevin Svenson', 'mer_georg@yahoo.com', 59),
(10, 'Kevin Svenson', 'mer_georg@yahoo.com', 25),
(11, 'Kevin Svenson', 'mer_georg@yahoo.com', 25),
(12, 'Koroush AK', 'asad_ambitious@ymail.com', 35),
(13, 'Koroush AK', 'asad_ambitious@ymail.com', 1065),
(14, 'Koroush AK', 'knotillusion@hotmail.com', 25),
(15, 'Koroush AK', 'knotillusion@hotmail.com', 25),
(16, 'Shawn Craig', 'madukwebethel995@gmail.com', 65),
(17, 'Chloé XRP', 'Daijuutenkaichi99@gmail.com', 25),
(18, 'Chloé XRP', 'Daijuutenkaichi99@gmail.com', 25),
(19, 'Chloé XRP', 'Daijuutenkaichi99@gmail.com', 25),
(20, 'Chloé XRP', 'Daijuutenkaichi99@gmail.com', 25),
(21, 'Chloé XRP', 'Daijuutenkaichi99@gmail.com', 25),
(22, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 35),
(23, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 35),
(24, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(25, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 15),
(26, 'Enfant Terrible', 'andre.petitcol@neuf.fr', 69.98),
(27, 'Enfant Terrible', 'andre.petitcol@neuf.fr', 69.98),
(28, 'Shawn Craig', 'andre.petitcol@neuf.fr', 65),
(29, 'Enfant Terrible', 'andre.petitcol@neuf.fr', 69.98),
(30, 'Enfant Terrible', 'andre.petitcol@neuf.fr', 69.98),
(31, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 15),
(32, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 5),
(33, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 5),
(34, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(35, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(36, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(37, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(38, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(39, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 20),
(40, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(41, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(42, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(43, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 30),
(44, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(45, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(46, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(47, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(48, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 40),
(49, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(50, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(51, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 40),
(52, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 40),
(53, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 50),
(54, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(55, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(56, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(57, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(58, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(59, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(60, 'Eunice D Wong', 'andre.petitcol@neuf.fr', 0),
(61, 'Wolf of Altcoins', 'Gotnot4@gmail.com', 60),
(62, 'Wolf of Altcoins', 'Gotnot4@gmail.com', 0),
(63, 'TanjaTrades', 'proadvice.trading@gmail.com', 55),
(64, 'TanjaTrades', 'proadvice.trading@gmail.com', 35),
(65, 'TanjaTrades', 'proadvice.trading@gmail.com', 78),
(66, 'TanjaTrades', 'proadvice.trading@gmail.com', 78),
(67, 'TanjaTrades', 'proadvice.trading@gmail.com', 25),
(68, 'TanjaTrades', 'proadvice.trading@gmail.com', 35),
(69, 'TanjaTrades', 'proadvice.trading@gmail.com', 15),
(70, 'TanjaTrades', 'proadvice.trading@gmail.com', 87),
(71, 'TanjaTrades', 'proadvice.trading@gmail.com', 85),
(72, 'TanjaTrades', 'proadvice.trading@gmail.com', 15),
(73, 'TanjaTrades', 'proadvice.trading@gmail.com', 15),
(74, 'TanjaTrades', 'proadvice.trading@gmail.com', 18),
(75, 'TanjaTrades', 'proadvice.trading@gmail.com', 5),
(76, 'TanjaTrades', 'proadvice.trading@gmail.com', 20),
(77, 'TanjaTrades', 'proadvice.trading@gmail.com', 20),
(78, 'TanjaTrades', 'proadvice.trading@gmail.com', 35),
(79, 'TanjaTrades', 'proadvice.trading@gmail.com', 25),
(80, 'TanjaTrades', 'proadvice.trading@gmail.com', 20),
(81, 'TanjaTrades', 'proadvice.trading@gmail.com', 30),
(82, 'JackTheRippler Ⓒ', 'Montycj091@gmail.com', 35),
(83, 'JackTheRippler Ⓒ', 'Montycj091@gmail.com', 45),
(84, 'JackTheRippler Ⓒ', 'Montycj091@gmail.com', 15),
(85, 'KC Trades ', 'frankuzwol8@gmail.com', 35),
(86, 'KC Trades ', 'frankuzwol8@gmail.com', 0),
(87, 'KC Trades ', 'frankuzwol8@gmail.com', 45),
(88, 'TanjaTrades', 'manishmani22171@gmail.com', 55),
(89, 'TanjaTrades', 'manishmani22171@gmail.com', 0),
(90, 'TanjaTrades', 'manishmani22171@gmail.com', 0),
(91, 'KC Trades ', 'frankuzwol8@gmail.com', 100),
(92, 'KC Trades ', 'frankuzwol8@gmail.com', 100),
(93, 'KC Trades ', 'frankuzwol8@gmail.com', 35),
(94, 'KC Trades ', 'frankuzwol8@gmail.com', 0),
(95, 'KC Trades ', 'frankuzwol8@gmail.com', 0),
(96, 'TanjaTrades', 'proadvice.trading@gmail.com', 0),
(97, 'VirtualBacon', 'mirza_gubeladze@yahoo.com', 15),
(98, 'VirtualBacon', 'mirza_gubeladze@yahoo.com', 25),
(99, 'VirtualBacon', 'mirza_gubeladze@yahoo.com', 0),
(100, 'Armando Pantoja', 'one.baja.life@gmail.com', 35),
(101, 'Armando Pantoja', 'one.baja.life@gmail.com', 25),
(102, 'Armando Pantoja', 'one.baja.life@gmail.com', 0),
(103, 'Armando Pantoja', 'one.baja.life@gmail.com', 0),
(104, 'Robin Seyr', 'cadjewelryschool@gmail.com', 45),
(105, 'AI ALPHA', 'mcoupe202@gmail.com', 0),
(106, 'AI ALPHA', 'mcoupe202@gmail.com', 0),
(107, 'AI ALPHA', 'mcoupe202@gmail.com', 0),
(108, 'AI ALPHA', 'mcoupe202@gmail.com', 0),
(109, 'Sykodelic 🔪', 'neelnibir55@gmail.com', 30),
(110, 'Brett Hill', 'caraceramos@gmail.com', 45),
(111, 'Brett Hill', 'caraceramos@gmail.com', 35);

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

--
-- Table structure for table `crypto`
--

CREATE TABLE `crypto` (
  `id` int(11) NOT NULL,
  `wallet_address` varchar(300) NOT NULL,
  `coin` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `demos`
--

CREATE TABLE `demos` (
  `id` int(11) NOT NULL,
  `email` varchar(300) NOT NULL,
  `package` varchar(299) NOT NULL,
  `tradetype` varchar(255) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `strikerate` varchar(255) NOT NULL,
  `earning` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  `profit` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `demos`
--

INSERT INTO `demos` (`id`, `email`, `package`, `tradetype`, `amount`, `strikerate`, `earning`, `endtime`, `profit`, `date`, `status`) VALUES
(617, 'finance.s.timoshenko@gmail.com', 'XMR/BUSD', 'buy', '2000', '', 0, 3, 0, '2023-04-03 22:19:42', 1),
(618, 'finance.s.timoshenko@gmail.com', 'ETH/GBP', 'sell', '2000', '', 0, 3, 0, '2023-04-03 22:23:38', 1),
(615, 'perirk81@mail.ru', 'XRP/BTC', 'buy', '2000', '', 0, 5, 0, '2023-03-17 20:55:00', 1),
(614, 'perirk81@mail.ru', 'MATIC/AUD', 'sell', '2000', '', 0, 5, 0, '2023-03-17 20:40:50', 1),
(613, 'perirk81@mail.ru', 'XRP/BNB', 'buy', '2000', '', 0, 5, 0, '2023-03-17 20:04:31', 1),
(612, 'falina8859@gmail.com', 'XRP/BTC', 'buy', '2000', '', 0, 5, 0, '2023-03-17 11:01:27', 1),
(611, 'falina8859@gmail.com', 'MATIC/AUD', 'sell', '2000', '', 0, 5, 0, '2023-03-17 10:48:44', 1),
(610, 'falina8859@gmail.com', 'XRP/BNB', 'buy', '2000', '', 0, 5, 0, '2023-03-17 10:28:44', 1),
(619, 'tatkakhalimova@mail.ru', 'EOS/USD', 'buy', '2000', '', 0, 5, 0, '2023-04-11 18:14:09', 1),
(620, 'tatkakhalimova@mail.ru', 'FTT/USDT', 'sell', '2000', '', 0, 5, 0, '2023-04-11 18:19:16', 1),
(623, 'krisz.asonik@gmail.com', 'ETC/EUR', 'buy', '2000', '', 0, 5, 0, '2023-04-29 10:56:55', 1),
(624, 'krisz.asonik@gmail.com', 'ETC/EUR', 'buy', '200', '', 0, 5, 0, '2023-04-29 11:15:35', 1),
(625, 'krisz.asonik@gmail.com', 'LTC/USD', 'buy', '2000', '', 0, 5, 0, '2023-04-30 11:45:47', 1),
(626, 'krisz.asonik@gmail.com', 'ETHDOWN/USDT', 'buy', '2000', '', 0, 5, 0, '2023-04-30 12:04:43', 1),
(627, 'tatys011807@hotmail.com', 'ETC/EUR', 'buy', '2000', '', 0, 5, 0, '2023-05-09 02:00:34', 1),
(628, 'tatys011807@hotmail.com', 'ETH/EUR', 'sell', '2000', '', 0, 5, 0, '2023-05-09 02:22:41', 1),
(629, 'larisarevakina871@gmail.com', 'ETC/EUR', 'buy', '2000', '', 0, 5, 0, '2023-05-09 10:11:14', 1),
(630, 'larisarevakina871@gmail.com', 'REP/USD', 'sell', '2000', '', 0, 5, 0, '2023-05-09 10:22:47', 1),
(631, 'raisa.voronina123@yandex.ru', 'ETH/EUR', 'buy', '2000', '', 0, 5, 0, '2023-05-09 10:26:26', 1),
(632, 'raisa.voronina123@yandex.ru', 'REP/USD', 'sell', '2000', '', 0, 5, 0, '2023-05-11 10:03:15', 1),
(633, 'ekaterina.pro2022@gmail.com', 'REP/USD', 'buy', '2000', '', 0, 5, 0, '2023-05-16 16:10:24', 1),
(634, 'ekaterina.pro2022@gmail.com', 'FTT/USDT', 'sell', '2000', '', 0, 5, 0, '2023-05-16 16:18:21', 1),
(635, 'dedova1933@gmail.com', 'SOL/USDT', 'buy', '2000', '', 0, 5, 0, '2023-05-30 14:50:53', 1),
(636, 'dedova1933@gmail.com', 'ZEC/BTC', 'sell', '2000', '', 0, 5, 0, '2023-05-30 14:57:12', 1),
(637, 'aznabaeva@bl.ru', 'WBTC/BUSD', 'buy', '2000', '', 0, 5, 0, '2023-06-04 09:33:50', 0),
(638, 'aznabaeva@bl.ru', 'BNB/USDC', 'buy', '2000', '', 0, 5, 0, '2023-06-04 09:40:28', 1),
(639, 'aznabaeva@bl.ru', 'BNB/USDC', 'sell', '2000', '', 0, 5, 0, '2023-06-04 09:44:17', 1);

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

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

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `method` varchar(299) NOT NULL,
  `amount` float NOT NULL,
  `earning` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `plan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `deposits` (`id`, `email`, `method`, `amount`, `earning`, `date`, `status`, `code`, `plan`) VALUES
(382428, 'Rijnbeek2000@hotmail.com', 'BITCOIN', 100, 0, '2023-12-07 08:34:10', 0, '1070', 'deposit'),
(382429, 'Aliusuleiman123@icloud.com', 'BITCOIN', 1, 0, '2023-12-07 12:43:11', 0, '175', 'deposit'),
(382430, 'Aliusuleiman123@icloud.com', 'BITCOIN', 1, 0, '2023-12-07 12:43:13', 0, '114', 'deposit'),
(382431, 'madukwebethel995@gmail.com', 'BITCOIN', 5000, 0, '2023-12-11 14:51:37', 1, '482', 'deposit'),
(382432, 'mer_georg@yahoo.com', 'USDT(TRC20)', 1000, 0, '2023-12-12 16:46:44', 1, '869', 'deposit'),
(382433, 'madukwebethel995@gmail.com', 'BITCOIN', 350000, 0, '2023-12-20 07:17:12', 0, '252', 'deposit'),
(382434, 'madukwebethel995@gmail.com', 'BITCOIN', 350000, 0, '2023-12-20 07:17:18', 1, '957', 'deposit'),
(382435, 'asad_ambitious@ymail.com', 'BITCOIN', 100, 0, '2023-12-20 19:41:09', 0, '401', 'deposit'),
(382436, 'asad_ambitious@ymail.com', 'BITCOIN', 100, 0, '2023-12-20 19:46:50', 1, '759', 'deposit'),
(382437, 'knotillusion@hotmail.com', 'Etheruem', 203, 0, '2023-12-26 19:50:54', 0, '442', 'deposit'),
(382438, 'knotillusion@hotmail.com', 'Etheruem', 203, 0, '2023-12-26 19:52:43', 0, '509', 'deposit'),
(382439, 'Iamoppongclifford@gmail.com', 'USDT(TRC20)', 500, 0, '2024-01-01 10:28:49', 0, '454', 'deposit'),
(382440, 'Daijuutenkaichi99@gmail.com', 'XRP', 160, 0, '2024-01-11 19:48:39', 0, '1094', 'deposit'),
(382441, 'madukwebethel995@gmail.com', 'BITCOIN', 230000, 0, '2024-01-13 20:52:03', 1, '21', 'deposit'),
(382442, 'andre.petitcol@neuf.fr', 'BITCOIN', 1000, 0, '2024-01-18 18:55:16', 0, '75', 'deposit'),
(382443, 'dhaferchakchouki0@gmail.com', 'BITCOIN', 10, 0, '2024-01-29 16:16:13', 0, '1005', 'deposit'),
(382444, 'proadvice.trading@gmail.com', 'USDT(TRC20)', 500, 0, '2024-02-06 16:42:00', 0, '34', 'deposit'),
(382445, 'proadvice.trading@gmail.com', 'USDT(TRC20)', 500, 0, '2024-02-06 16:42:16', 1, '105', 'deposit'),
(382446, 'proadvice.trading@gmail.com', 'USDT(TRC20)', 2000, 0, '2024-02-26 20:41:09', 0, '745', 'deposit'),
(382447, 'proadvice.trading@gmail.com', 'USDT(TRC20)', 2000, 0, '2024-02-26 20:41:20', 0, '224', 'deposit'),
(382448, 'Montycj091@gmail.com', 'XRP', 200, 0, '2024-03-10 21:13:01', 1, '732', 'deposit'),
(382449, 'frankuzwol8@gmail.com', 'BITCOIN', 100, 0, '2024-03-11 16:01:30', 1, '74', 'deposit'),
(382450, 'frankuzwol8@gmail.com', 'BITCOIN', 100, 0, '2024-03-11 16:39:55', 1, '333', 'deposit'),
(382451, 'frankuzwol8@gmail.com', 'BITCOIN', 100, 0, '2024-03-11 16:39:56', 1, '345', 'deposit'),
(382452, 'frankuzwol8@gmail.com', 'BITCOIN', 35, 0, '2024-03-11 20:43:10', 0, '521', 'deposit'),
(382453, 'manishmani22171@gmail.com', 'XRP', 24, 0, '2024-03-13 01:42:53', 1, '519', 'deposit'),
(382454, 'frankuzwol8@gmail.com', 'BITCOIN', 200, 0, '2024-03-30 14:05:12', 1, '606', 'deposit'),
(382455, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)', 700, 0, '2024-04-30 17:21:49', 0, '447', 'deposit'),
(382456, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)', 300, 0, '2024-05-02 00:49:23', 1, '651', 'deposit'),
(382457, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)', 300, 0, '2024-05-02 00:50:04', 0, '397', 'deposit'),
(382458, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:14:38', 0, '368', 'deposit'),
(382459, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:14:43', 0, '566', 'deposit'),
(382460, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:15:13', 0, '836', 'deposit'),
(382461, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:23:50', 0, '192', 'deposit'),
(382462, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:41:51', 0, '248', 'deposit'),
(382463, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 15:50:33', 0, '646', 'deposit'),
(382464, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 16:15:26', 0, '603', 'deposit'),
(382465, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 16:39:11', 0, '520', 'deposit'),
(382466, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 16:50:07', 0, '652', 'deposit'),
(382467, 'mirza_gubeladze@yahoo.com', 'Etheruem', 690, 0, '2024-05-02 16:58:19', 0, '306', 'deposit'),
(382468, 'kyle.leonard84@yahoo.com', 'BITCOIN', 400, 0, '2024-05-04 03:15:44', 0, '1089', 'deposit'),
(382469, 'mnigelmoyo23@gmail.com', 'USDT(TRC20)', 10, 0, '2024-05-06 15:30:07', 0, '1077', 'deposit'),
(382470, 'adeniyi4499@gmail.com', 'USDT(TRC20)', 0.192652, 0, '2024-05-10 09:44:06', 0, '371', 'deposit'),
(382471, 'salah.artin786@gmail.com', 'BITCOIN', 50, 0, '2024-06-13 21:10:39', 0, '974', 'deposit'),
(382472, 'salah.artin786@gmail.com', 'BITCOIN', 50, 0, '2024-06-13 21:12:41', 0, '1038', 'deposit'),
(382473, 'salah.artin786@gmail.com', 'BITCOIN', 5000, 0, '2024-06-13 21:21:09', 0, '98', 'deposit'),
(382474, 'one.baja.life@gmail.com', 'Etheruem', 2000, 0, '2024-06-18 23:11:14', 0, '276', 'deposit'),
(382475, 'one.baja.life@gmail.com', 'Etheruem', 2000, 0, '2024-06-18 23:26:23', 1, '408', 'deposit'),
(382476, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:51:34', 0, '463', 'deposit'),
(382477, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:51:40', 0, '701', 'deposit'),
(382478, 'mehmood22537@gmail.com', 'Etheruem', 0, 0, '2024-06-28 21:51:59', 0, '761', 'deposit'),
(382479, 'mehmood22537@gmail.com', 'USDT(TRC20)', 0, 0, '2024-06-28 21:52:09', 0, '382', 'deposit'),
(382480, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:52:15', 0, '845', 'deposit'),
(382481, 'mehmood22537@gmail.com', 'XRP', 0, 0, '2024-06-28 21:52:23', 0, '521', 'deposit'),
(382482, 'mehmood22537@gmail.com', 'XRP', 0, 0, '2024-06-28 21:52:30', 0, '115', 'deposit'),
(382483, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:52:46', 0, '870', 'deposit'),
(382484, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:52:49', 0, '567', 'deposit'),
(382485, 'mehmood22537@gmail.com', 'BITCOIN', 0, 0, '2024-06-28 21:52:51', 0, '115', 'deposit'),
(382486, 'proadvice.trading@gmail.com', 'USDT(TRC20)', 2000, 0, '2024-07-12 15:00:25', 0, '18', 'deposit'),
(382487, 'patel.dinesh603@gmail.com', 'BITCOIN', 100, 0, '2024-08-04 08:24:18', 0, '828', 'deposit'),
(382488, 'nkuhtalikong@gmail.com', 'USDT(TRC20)', 50, 0, '2024-10-04 19:18:22', 0, '1055', 'deposit'),
(382489, 'oapodaca09@gmail.com', 'BITCOIN', 200, 0, '2024-10-04 21:13:59', 0, '1049', 'deposit'),
(382490, 'chaosmite@chaosmite.net', 'Etheruem', 600, 0, '2024-11-11 07:22:53', 0, '854', 'deposit'),
(382491, 'neelnibir55@gmail.com', 'USDT(TRC20)', 50, 0, '2024-11-16 21:53:27', 0, '520', 'deposit'),
(382492, 'neelnibir55@gmail.com', 'USDT(TRC20)', 50, 0, '2024-11-16 21:54:00', 0, '485', 'deposit'),
(382493, 'neelnibir55@gmail.com', 'USDT(TRC20)', 50, 0, '2024-11-16 21:55:45', 0, '773', 'deposit'),
(382494, 'neelnibir55@gmail.com', 'USDT(TRC20)', 50, 0, '2024-11-16 22:09:28', 0, '744', 'deposit'),
(382495, 'neelnibir55@gmail.com', 'USDT(TRC20)', 50, 0, '2024-11-16 22:10:52', 0, '782', 'deposit'),
(382496, 'neelnibir55@gmail.com', 'USDT(TRC20)', 150, 0, '2024-11-16 22:48:45', 0, '101', 'deposit'),
(382497, 'caraceramos@gmail.com', 'BITCOIN', 200, 0, '2024-12-16 15:15:23', 0, '448', 'deposit'),
(382498, 'Jacques@taltec.co.za', 'XRP', 100, 0, '2024-12-19 15:58:20', 0, '300', 'deposit'),
(382499, 'caraceramos@gmail.com', 'Etheruem', 200, 0, '2024-12-21 22:51:10', 1, '714', 'deposit'),
(382500, 'caraceramos@gmail.com', 'Etheruem', 100, 0, '2024-12-30 18:17:29', 0, '1047', 'deposit');

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

--
-- Table structure for table `investments`
--

CREATE TABLE `investments` (
  `id` int(11) NOT NULL,
  `email` varchar(300) NOT NULL,
  `package` varchar(299) NOT NULL,
  `tradetype` varchar(255) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `endtime` int(11) NOT NULL,
  `strikerate` varchar(255) NOT NULL,
  `earning` int(11) NOT NULL,
  `profit` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL,
  `result` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`id`, `email`, `package`, `tradetype`, `amount`, `endtime`, `strikerate`, `earning`, `profit`, `date`, `status`, `result`) VALUES
(1398, 'madukwebethel995@gmail.com', 'ETH/BTC', 'buy', '12000', 30, '29', 15480, 0, '2023-12-12 15:52:12', 1, 1),
(1392, 'madukwebethel995@gmail.com', 'BTC/XRP', 'buy', '100', 60, '45', 145, 0, '2023-12-11 14:53:49', 1, 1),
(1393, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '2000', 30, '16', 2320, 0, '2023-12-11 14:54:09', 1, 1),
(1394, 'madukwebethel995@gmail.com', 'BTC/XRP', 'buy', '100', 60, '45', 145, 0, '2023-12-11 14:55:01', 1, 1),
(1395, 'madukwebethel995@gmail.com', 'BTC/EOS', 'buy', '800', 5, '36', 1088, 0, '2023-12-11 14:56:25', 1, 1),
(1396, 'madukwebethel995@gmail.com', 'ETC/BTC', 'buy', '500', 1, '16', 580, 0, '2023-12-11 14:57:49', 1, 1),
(1397, 'madukwebethel995@gmail.com', 'ETC/BTC', 'buy', '500', 1, '29', 645, 0, '2023-12-11 14:58:25', 1, 1),
(1399, 'madukwebethel995@gmail.com', 'XLM/BTC', 'buy', '23000', 1, '2', 23460, 0, '2023-12-12 15:52:34', 1, 1),
(1400, 'madukwebethel995@gmail.com', 'XRP/USDT', 'buy', '80000', 1, '9', 87200, 0, '2023-12-12 15:52:55', 1, 1),
(1401, 'madukwebethel995@gmail.com', 'BTC/USDT', 'buy', '1000', 60, '59', 1590, 0, '2023-12-12 17:43:41', 1, 1),
(1402, 'mer_georg@yahoo.com', 'BTC/USDT', 'buy', '1000', 60, '59', 1390, 0, '2023-12-12 17:45:36', 1, 1),
(1403, 'mer_georg@yahoo.com', 'BTC/USDT', 'buy', '190', 10, '25', 238, 0, '2023-12-13 07:03:26', 1, 1),
(1404, 'mer_georg@yahoo.com', 'BTC/USDT', 'buy', '190', 10, '25', 238, 0, '2023-12-13 07:22:42', 1, 1),
(1405, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '500', 1, '29', 645, 0, '2023-12-20 07:13:55', 1, 1),
(1406, 'madukwebethel995@gmail.com', 'EOS/USD', 'buy', '8000', 1, '16', 9280, 0, '2023-12-20 07:14:12', 1, 1),
(1407, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '40000', 1, '2', 40800, 0, '2023-12-20 07:14:31', 1, 1),
(1408, 'madukwebethel995@gmail.com', 'EOS/EUR', 'sell', '7000', 3, '13', 7910, 0, '2023-12-20 07:15:03', 1, 1),
(1409, 'madukwebethel995@gmail.com', 'ETH/BTC', 'sell', '2000', 5, '20', 2400, 0, '2023-12-20 07:15:39', 1, 1),
(1410, 'madukwebethel995@gmail.com', 'BCH/BTC', 'sell', '150', 1, '20', 180, 0, '2023-12-20 07:15:48', 1, 1),
(1411, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '90000', 1, '16', 104400, 0, '2023-12-20 07:16:03', 1, 1),
(1412, 'madukwebethel995@gmail.com', 'BCH/BTC', 'sell', '4000', 1, '20', 4800, 0, '2023-12-20 07:16:15', 1, 1),
(1413, 'madukwebethel995@gmail.com', 'EOS/USD', 'buy', '5600', 1, '29', 7224, 0, '2023-12-20 07:16:38', 1, 1),
(1414, 'asad_ambitious@ymail.com', 'BTC/USDT', 'buy', '200', 30, '35', 270, 0, '2023-12-20 20:39:18', 1, 1),
(1415, 'asad_ambitious@ymail.com', 'BTC/USDT', 'buy', '270', 1000, '1065', 3146, 0, '2023-12-20 22:21:41', 1, 1),
(1416, 'knotillusion@hotmail.com', 'BTC/ETH', 'buy', '200', 35, '25', 250, 0, '2023-12-26 19:59:31', 1, 1),
(1417, 'knotillusion@hotmail.com', 'BTC/ETH', 'buy', '300', 120, '25', 375, 0, '2023-12-26 21:01:09', 1, 1),
(1418, 'madukwebethel995@gmail.com', 'BTC/XRP', 'buy', '100', 50, '65', 165, 0, '2024-01-01 13:43:32', 1, 1),
(1419, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '130000', 1, '29', 167700, 0, '2024-01-01 13:43:52', 1, 1),
(1420, 'madukwebethel995@gmail.com', 'BTC/USDC', 'buy', '86000', 1, '16', 99760, 0, '2024-01-01 13:44:40', 1, 1),
(1421, 'madukwebethel995@gmail.com', 'EOS/EUR', 'buy', '50000', 1, '29', 64500, 0, '2024-01-01 13:45:06', 1, 1),
(1422, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '30000', 1, '16', 34800, 0, '2024-01-01 13:45:23', 1, 1),
(1423, 'madukwebethel995@gmail.com', 'ETC/EUR', 'buy', '84000', 1, '9', 91560, 0, '2024-01-01 13:45:53', 1, 1),
(1424, 'madukwebethel995@gmail.com', 'ETC/USD', 'buy', '150000', 1, '16', 174000, 0, '2024-01-01 13:46:18', 1, 1),
(1425, 'madukwebethel995@gmail.com', 'ETH/BTC', 'buy', '150000', 1, '2', 153000, 0, '2024-01-01 13:46:34', 1, 1),
(1426, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '99000', 1, '16', 114840, 0, '2024-01-01 13:47:21', 1, 1),
(1427, 'Daijuutenkaichi99@gmail.com', 'BTC/XRP', 'buy', '97', 30, '25', 121, 0, '2024-01-11 21:28:20', 1, 1),
(1428, 'Daijuutenkaichi99@gmail.com', 'BTC/XRP', 'buy', '97', 30, '25', 121, 0, '2024-01-12 04:22:34', 1, 0),
(1439, 'madukwebethel995@gmail.com', 'BTC/USDC', 'buy', '30000', 1, '2', 30600, 0, '2024-01-18 09:53:15', 1, 1),
(1429, 'Daijuutenkaichi99@gmail.com', 'BTC/XRP', 'buy', '0', 30, '25', 0, 0, '2024-01-12 11:42:04', 1, 0),
(1430, 'Daijuutenkaichi99@gmail.com', 'BTC/XRP', 'buy', '0', 30, '25', 0, 0, '2024-01-12 14:20:59', 1, 0),
(1431, 'Daijuutenkaichi99@gmail.com', 'BTC/XRP', 'buy', '0', 30, '25', 0, 0, '2024-01-12 17:57:00', 1, 0),
(1432, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '450000', 1, '16', 522000, 0, '2024-01-13 11:54:02', 1, 1),
(1433, 'madukwebethel995@gmail.com', 'ETH/BTC', 'sell', '500000', 1, '4', 520000, 0, '2024-01-13 11:54:29', 1, 1),
(1434, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '50000', 1, '16', 58000, 0, '2024-01-13 11:55:20', 1, 1),
(1435, 'madukwebethel995@gmail.com', 'XLM/BTC', 'buy', '250000', 1, '9', 272500, 0, '2024-01-13 11:55:44', 1, 1),
(1436, 'madukwebethel995@gmail.com', 'XRP/ETH', 'buy', '170000', 1, '16', 197200, 0, '2024-01-13 11:55:58', 1, 1),
(1437, 'madukwebethel995@gmail.com', 'ETH/EUR', 'buy', '350000', 1, '16', 406000, 0, '2024-01-13 11:56:24', 1, 1),
(1438, 'madukwebethel995@gmail.com', 'XRP/BTC', 'sell', '313577', 1, '13', 354342, 0, '2024-01-13 11:57:22', 1, 1),
(1440, 'madukwebethel995@gmail.com', 'BTC/GBP', 'buy', '4000', 1, '29', 5160, 0, '2024-01-18 09:53:31', 1, 1),
(1441, 'madukwebethel995@gmail.com', 'ETC/BTC', 'buy', '15000', 1, '16', 17400, 0, '2024-01-18 09:53:43', 1, 1),
(1442, 'andre.petitcol@neuf.fr', 'ETH/BTC ', 'buy', '945', 45, '35', 1276, 0, '2024-01-18 19:57:30', 1, 1),
(1445, 'andre.petitcol@neuf.fr', 'ETH/BTC ', 'buy', '1376', 90, '15', 1582, 0, '2024-01-18 22:35:10', 1, 1),
(1451, 'andre.petitcol@neuf.fr', 'ETH/USDC', 'sell', '1582', 30, '15', 1819, 0, '2024-01-19 13:00:18', 1, 1),
(1468, 'andre.petitcol@neuf.fr', 'BNB/ETH', 'buy', '8366', 60, '40', 11712, 0, '2024-01-21 20:47:46', 1, 1),
(1479, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-24 18:01:30', 1, 1),
(1477, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-23 16:34:39', 1, 1),
(1450, 'andre.petitcol@neuf.fr', 'BTC/EOS', 'sell', '0', 1, '69.98', 0, 0, '2024-01-19 07:40:57', 1, 0),
(1452, 'andre.petitcol@neuf.fr', 'BTC/USDT', 'buy', '1019', 120, '5', 1070, 0, '2024-01-19 14:15:13', 1, 1),
(1453, 'andre.petitcol@neuf.fr', 'BTC/USDT', 'buy', '1019', 120, '5', 1200, 0, '2024-01-19 16:23:32', 1, 1),
(1478, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-23 19:39:21', 1, 1),
(1463, 'andre.petitcol@neuf.fr', 'BNB/XRP', 'buy', '6089', 120, '30', 7916, 0, '2024-01-21 17:26:24', 1, 1),
(1480, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-24 22:55:00', 1, 1),
(1459, 'andre.petitcol@neuf.fr', 'BTC/ETH', 'sell', '5000', 60, '20', 6000, 0, '2024-01-20 20:01:59', 1, 1),
(1473, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '11917', 160, '50', 17876, 0, '2024-01-22 19:50:28', 1, 1),
(1475, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-23 06:41:55', 1, 1),
(1476, 'andre.petitcol@neuf.fr', 'BNB/USDT', 'buy', '0', 0, '0', 0, 0, '2024-01-23 14:26:04', 1, 1),
(1481, 'Gotnot4@gmail.com', 'BTC/BNB', 'buy', '100', 60, '60', 160, 0, '2024-02-03 12:35:38', 1, 1),
(1483, 'proadvice.trading@gmail.com', 'BTC/USDT', 'buy', '477', 60, '55', 739, 0, '2024-02-06 17:08:25', 1, 1),
(1484, 'proadvice.trading@gmail.com', 'XRP/USDT', 'buy', '1216', 120, '35', 1642, 0, '2024-02-07 11:46:54', 1, 1),
(1485, 'proadvice.trading@gmail.com', 'USDT/BNB', 'buy', '1842', 160, '78', 3279, 0, '2024-02-07 16:50:39', 1, 1),
(1486, 'proadvice.trading@gmail.com', 'USDT/ETH', 'buy', '6271', 160, '78', 11162, 0, '2024-02-08 16:50:09', 1, 1),
(1487, 'proadvice.trading@gmail.com', 'BTC/ETH', 'buy', '11162', 30, '25', 13953, 0, '2024-02-08 19:35:00', 1, 1),
(1488, 'proadvice.trading@gmail.com', 'BTC/ETH', 'buy', '15692', 60, '35', 21184, 0, '2024-02-09 11:18:29', 1, 1),
(1489, 'proadvice.trading@gmail.com', 'XRP/USDT', 'buy', '21184', 60, '15', 24362, 0, '2024-02-09 13:05:42', 1, 1),
(1490, 'proadvice.trading@gmail.com', 'XRP/ETH', 'buy', '4362', 40, '87', 8157, 0, '2024-02-09 13:53:09', 1, 1),
(1491, 'proadvice.trading@gmail.com', 'XRP/BTC', 'buy', '29882', 30, '85', 55282, 0, '2024-02-12 14:35:14', 1, 1),
(1492, 'proadvice.trading@gmail.com', 'ETH/BTC', 'buy', '57107', 30, '15', 65673, 0, '2024-02-13 08:33:30', 1, 1),
(1493, 'proadvice.trading@gmail.com', 'TRX/BTC', 'buy', '67543', 30, '15', 77674, 0, '2024-02-14 11:49:33', 1, 1),
(1494, 'proadvice.trading@gmail.com', 'BCH/TRX', 'buy', '79471', 30, '18', 93776, 0, '2024-02-15 08:28:14', 1, 1),
(1495, 'proadvice.trading@gmail.com', 'USDT/TRX', 'buy', '93776', 30, '5', 98465, 0, '2024-02-15 15:07:15', 1, 1),
(1496, 'proadvice.trading@gmail.com', 'USDT/TRX', 'buy', '98465', 25, '20', 109965, 0, '2024-02-16 10:23:53', 1, 1),
(1497, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '25000', 1, '16', 29000, 0, '2024-02-18 13:00:12', 1, 1),
(1498, 'madukwebethel995@gmail.com', 'BTC/USDC', 'buy', '32000', 1, '9', 34880, 0, '2024-02-18 13:00:26', 1, 1),
(1499, 'madukwebethel995@gmail.com', 'ETH/EUR', 'buy', '150', 1, '16', 174, 0, '2024-02-18 13:00:36', 1, 1),
(1500, 'madukwebethel995@gmail.com', 'ETH/USDC', 'buy', '34779', 1, '2', 35475, 0, '2024-02-18 13:00:50', 1, 1),
(1501, 'madukwebethel995@gmail.com', 'MKR/BTC', 'buy', '41000', 1, '16', 47560, 0, '2024-02-18 13:01:05', 1, 1),
(1502, 'madukwebethel995@gmail.com', 'LTC/GBP', 'buy', '55000', 1, '29', 70950, 0, '2024-02-18 13:01:29', 1, 1),
(1503, 'proadvice.trading@gmail.com', 'USDT/TRX', 'buy', '112036', 25, '20', 134443, 0, '2024-02-19 10:06:06', 1, 1),
(1504, 'proadvice.trading@gmail.com', 'USDT/BNB', 'buy', '136340', 60, '35', 184059, 0, '2024-02-20 09:17:19', 1, 1),
(1505, 'proadvice.trading@gmail.com', 'USDT/ETH', 'buy', '187127', 30, '25', 233909, 0, '2024-02-21 10:16:13', 1, 1),
(1506, 'proadvice.trading@gmail.com', 'USDT/BTC', 'buy', '235355', 45, '20', 282426, 0, '2024-02-29 09:29:45', 1, 1),
(1507, 'proadvice.trading@gmail.com', 'TRX/BTC', 'buy', '283483', 45, '30', 368528, 0, '2024-03-01 10:18:48', 1, 1),
(1508, 'Montycj091@gmail.com', 'BTC/XRP', 'sell', '122', 60, '35', 165, 0, '2024-03-10 21:22:47', 1, 1),
(1509, 'Montycj091@gmail.com', 'BTC/XRP', 'sell', '165', 60, '45', 239, 0, '2024-03-10 22:03:05', 1, 1),
(1510, 'Montycj091@gmail.com', 'BTC/XRP', 'buy', '239', 30, '15', 275, 0, '2024-03-10 22:35:15', 1, 1),
(1511, 'frankuzwol8@gmail.com', 'BTC/XRP', 'sell', '100', 60, '35', 135, 0, '2024-03-11 17:57:07', 1, 1),
(1512, 'frankuzwol8@gmail.com', 'BTC/XRP', 'sell', '0', 0, '0', 0, 0, '2024-03-11 18:06:04', 1, 1),
(1513, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '135', 30, '45', 196, 0, '2024-03-11 21:02:29', 1, 0),
(1514, 'manishmani22171@gmail.com', 'TRX/USDT', 'buy', '10', 30, '55', 27, 0, '2024-03-13 11:30:40', 1, 1),
(1515, 'manishmani22171@gmail.com', 'TRX/USDT', 'buy', '0', 0, '0', 0, 0, '2024-03-13 12:40:35', 1, 1),
(1516, 'manishmani22171@gmail.com', 'TRX/USDT', 'buy', '0', 0, '0', 0, 0, '2024-03-13 12:40:37', 1, 1),
(1517, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '500', 30, '100', 1000, 0, '2024-03-30 17:59:59', 1, 1),
(1518, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '500', 30, '100', 1000, 0, '2024-03-30 19:55:50', 1, 1),
(1519, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '646', 30, '35', 872, 0, '2024-03-30 20:52:08', 1, 1),
(1520, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '0', 0, '0', 0, 0, '2024-03-30 21:17:20', 1, 1),
(1521, 'frankuzwol8@gmail.com', 'BTC/XRP', 'buy', '0', 0, '0', 0, 0, '2024-04-09 20:55:25', 1, 1),
(1522, 'proadvice.trading@gmail.com', 'TRX/USDT', 'buy', '0', 0, '0', 0, 0, '2024-05-01 20:02:43', 1, 1),
(1523, 'mirza_gubeladze@yahoo.com', 'USDT/ETH', 'sell', '299', 30, '15', 344, 0, '2024-05-02 03:56:25', 1, 1),
(1524, 'mirza_gubeladze@yahoo.com', 'BTC/ETH', 'buy', '1008', 45, '25', 1260, 0, '2024-05-02 23:12:04', 1, 1),
(1525, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '150', 1, '2', 153, 0, '2024-05-03 17:48:08', 1, 1),
(1526, 'madukwebethel995@gmail.com', 'BTC/GBP', 'buy', '500', 1, '9', 545, 0, '2024-05-03 17:48:22', 1, 1),
(1527, 'madukwebethel995@gmail.com', 'EOS/USD', 'buy', '500000', 1, '9', 545000, 0, '2024-05-03 17:48:34', 1, 1),
(1528, 'madukwebethel995@gmail.com', 'LTC/USD', 'buy', '450000', 1, '2', 459000, 0, '2024-05-03 17:48:47', 1, 1),
(1529, 'madukwebethel995@gmail.com', 'BCH/BTC', 'buy', '300000', 1, '36', 408000, 0, '2024-05-03 17:49:33', 1, 1),
(1530, 'madukwebethel995@gmail.com', 'AUTO/BTC', 'buy', '85000', 1, '2', 86700, 0, '2024-05-03 17:49:52', 1, 1),
(1531, 'madukwebethel995@gmail.com', 'XRP/USDT', 'buy', '95000', 1, '2', 96900, 0, '2024-05-03 17:50:11', 1, 1),
(1532, 'madukwebethel995@gmail.com', 'XRP/ETH', 'buy', '350000', 1, '36', 476000, 0, '2024-05-03 17:50:29', 1, 1),
(1533, 'madukwebethel995@gmail.com', 'WBTC/BUSD', 'buy', '150', 1, '36', 204, 0, '2024-05-03 17:52:01', 1, 1),
(1534, 'madukwebethel995@gmail.com', 'ETHDOWN/USDT', 'buy', '25000', 1, '2', 25500, 0, '2024-05-03 17:52:14', 1, 1),
(1535, 'madukwebethel995@gmail.com', 'DASH/BTC', 'buy', '65000', 1, '2', 66300, 0, '2024-05-03 17:52:28', 1, 1),
(1536, 'madukwebethel995@gmail.com', 'BNB/EUR', 'buy', '53000', 1, '9', 57770, 0, '2024-05-03 17:52:46', 1, 1),
(1537, 'madukwebethel995@gmail.com', 'XRP/BNB', 'buy', '358909', 1, '2', 366087, 0, '2024-05-03 17:53:05', 1, 1),
(1538, 'madukwebethel995@gmail.com', 'BNB/GBP', 'sell', '150', 1, '13', 170, 0, '2024-05-03 17:53:43', 1, 1),
(1539, 'madukwebethel995@gmail.com', 'FTT/USDT', 'sell', '25000', 1, '4', 26000, 0, '2024-05-03 17:53:56', 1, 1),
(1540, 'madukwebethel995@gmail.com', 'FTT/USDT', 'sell', '25000', 1, '4', 26000, 0, '2024-05-03 17:53:59', 1, 1),
(1541, 'madukwebethel995@gmail.com', 'BNB/GBP', 'buy', '36000', 1, '2', 36720, 0, '2024-05-03 17:54:15', 1, 1),
(1542, 'madukwebethel995@gmail.com', 'BNB/USDC', 'sell', '89000', 1, '4', 92560, 0, '2024-05-03 17:54:37', 1, 1),
(1543, 'madukwebethel995@gmail.com', 'BNB/USDC', 'sell', '89000', 1, '4', 92560, 0, '2024-05-03 17:54:37', 1, 1),
(1544, 'madukwebethel995@gmail.com', 'BNB/USDC', 'sell', '89000', 1, '4', 92560, 0, '2024-05-03 17:54:41', 1, 1),
(1545, 'madukwebethel995@gmail.com', 'BNB/USDC', 'sell', '89000', 1, '4', 92560, 0, '2024-05-03 17:54:47', 1, 1),
(1546, 'madukwebethel995@gmail.com', 'BNB/USDC', 'sell', '89000', 1, '4', 92560, 0, '2024-05-03 17:54:52', 1, 1),
(1547, 'mirza_gubeladze@yahoo.com', 'BTC/ETH', 'buy', '0', 45, '0', 0, 0, '2024-05-03 19:52:33', 1, 1),
(1548, 'one.baja.life@gmail.com', 'ETH/BTC ', 'buy', '1984', 90, '35', 2678, 0, '2024-06-19 16:38:43', 1, 1),
(1549, 'one.baja.life@gmail.com', 'ETH/XRP', 'buy', '2678', 30, '25', 3348, 0, '2024-06-19 17:31:59', 1, 1),
(1550, 'one.baja.life@gmail.com', 'ETH/XRP', 'buy', '0', 0, '0', 0, 0, '2024-06-19 18:31:48', 1, 1),
(1551, 'one.baja.life@gmail.com', 'ETH/XRP', 'buy', '0', 0, '0', 0, 0, '2024-06-19 19:00:22', 1, 1),
(1552, 'cadjewelryschool@gmail.com', 'ETH/BTC ', 'buy', '213', 60, '45', 309, 0, '2024-08-14 22:34:46', 1, 1),
(1553, 'mcoupe202@gmail.com', 'BTC/EOS', 'sell', '0', 1, '0', 0, 0, '2024-09-10 21:18:31', 1, 1),
(1554, 'mcoupe202@gmail.com', 'BTC/EOS', 'sell', '0', 1, '0', 0, 0, '2024-09-10 21:19:07', 1, 1),
(1555, 'mcoupe202@gmail.com', 'BTC/EOS', 'sell', '0', 1, '0', 0, 0, '2024-09-10 21:19:07', 1, 1),
(1556, 'mcoupe202@gmail.com', 'BTC/EOS', 'sell', '0', 1, '0', 0, 0, '2024-09-10 21:19:07', 1, 1),
(1557, 'neelnibir55@gmail.com', 'BTC/USDT', 'buy', '200', 60, '30', 260, 0, '2024-11-16 23:07:25', 1, 1),
(1558, 'neelnibir55@gmail.com', 'BCH/BTC', 'buy', '150', 1, '36', 204, 0, '2024-11-17 12:46:08', 1, 1),
(1559, 'neelnibir55@gmail.com', 'BCH/BTC', 'buy', '150', 1, '29', 194, 0, '2024-11-17 13:13:56', 1, 1),
(1560, 'neelnibir55@gmail.com', 'BCH/BTC', 'buy', '150', 1, '29', 194, 0, '2024-11-17 14:12:22', 1, 1),
(1561, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '29', 194, 0, '2024-11-17 16:38:44', 1, 1),
(1562, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '29', 194, 0, '2024-11-17 17:13:59', 1, 1),
(1563, 'neelnibir55@gmail.com', 'BTC/USDC', 'sell', '150', 1, '13', 170, 0, '2024-11-17 20:05:00', 1, 1),
(1564, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 05:05:57', 1, 1),
(1565, 'neelnibir55@gmail.com', 'BTC/USDC', 'sell', '150', 1, '20', 180, 0, '2024-11-18 05:11:01', 1, 1),
(1566, 'neelnibir55@gmail.com', 'BTC/USDC', 'sell', '150', 1, '20', 180, 0, '2024-11-18 05:11:01', 1, 1),
(1567, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 09:17:16', 1, 1),
(1568, 'neelnibir55@gmail.com', 'BCH/BTC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 10:35:13', 1, 1),
(1569, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 12:28:38', 1, 1),
(1570, 'neelnibir55@gmail.com', 'BCH/BTC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 12:36:32', 1, 1),
(1571, 'neelnibir55@gmail.com', 'BTC/USDC', 'sell', '150', 1, '20', 180, 0, '2024-11-18 12:42:38', 1, 1),
(1572, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '150', 1, '36', 204, 0, '2024-11-18 19:09:01', 1, 1),
(1573, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '300', 1, '36', 408, 0, '2024-11-18 21:44:05', 1, 1),
(1574, 'neelnibir55@gmail.com', 'ETC/BTC', 'buy', '500', 1, '36', 680, 0, '2024-11-18 21:55:34', 1, 1),
(1575, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '800', 1, '36', 1088, 0, '2024-11-19 10:14:42', 1, 1),
(1576, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '1100', 1, '36', 1496, 0, '2024-11-19 10:20:30', 1, 1),
(1577, 'neelnibir55@gmail.com', 'BTC/USDC', 'buy', '1500', 1, '36', 2040, 0, '2024-11-19 10:41:28', 1, 1),
(1578, 'caraceramos@gmail.com', 'BTC/ETH', 'buy', '266', 90, '45', 386, 0, '2024-12-31 18:09:06', 1, 1),
(1579, 'caraceramos@gmail.com', 'USDT/ETH', 'buy', '386', 30, '35', 521, 0, '2025-01-02 14:17:18', 1, 1);

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

--
-- Table structure for table `signals`
--

CREATE TABLE `signals` (
  `id` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  `tradetype` varchar(255) NOT NULL,
  `strikerate` float NOT NULL,
  `earning` int(11) NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_name` varchar(255) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `win_rate` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `signals`
--

INSERT INTO `signals` (`id`, `endtime`, `tradetype`, `strikerate`, `earning`, `symbol`, `amount`, `name`, `short_name`, `unique_id`, `win_rate`, `date`) VALUES
(1, 1, 'buy', 24.78, 0, 'BCH/GBP', 100000, 'CEO MUSK', 'CE', 'CE23535', 0, '2023-08-16 14:45:54'),
(3, 1, 'sell', 0, 0, 'BTC/EOS', 0, 'AI ALPHA', '', 'copy345', 0, '2023-08-19 11:41:46'),
(5, 0, 'buy', 0, 0, 'BTC/USDT', 0, 'Rekt Capital', '', 'rektcapital', 0, '2023-12-09 21:28:46'),
(6, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'idalis', '', 'idalistrades', 0, '2023-12-10 06:11:45'),
(8, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Wendy O', '', 'CryptoWendyO', 0, '2023-12-12 08:29:55'),
(10, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Shawn Craig', '', 'digitalshawn', 0, '2023-12-12 15:36:50'),
(11, 0, 'buy', 0, 0, 'BTC/USDT', 0, 'Kevin Svenson', '', 'KevinSvenson_', 0, '2023-12-12 15:54:51'),
(12, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Chloé XRP', '', 'Chloe_Le_Pen', 0, '2023-12-19 08:44:29'),
(14, 0, 'buy', 0, 0, 'BTC/ETH', 0, 'Koroush AK', '', 'KoroushAK', 0, '2023-12-20 20:27:06'),
(15, 0, 'sell', 0, 0, 'BTC/USDT', 0, 'il Capo Of Crypto', '', 'CryptoCapo_', 0, '2024-01-02 19:20:19'),
(16, 0, 'sell', 0, 0, 'XRP/BTC', 0, 'Anthony Crudele', '', 'Anthony_C369', 0, '2024-01-07 08:04:19'),
(17, 0, 'sell', 0, 0, 'BTC/USDT', 0, 'MoneyTradeEdge', '', 'MoneyTradeEdge', 0, '2024-01-07 21:29:38'),
(18, 0, 'sell', 0, 0, 'BTC/USDT', 0, 'MoneyTradeEdge', '', 'MoneyTradeEdge', 0, '2024-01-08 07:08:04'),
(19, 0, 'buy', 0, 0, 'BTC/USDT', 0, 'Doctor Profit', '', 'DrProfitCrypto', 0, '2024-01-11 12:48:50'),
(20, 0, 'sell', 0, 0, 'BTC/USDT', 0, 'XRP CAPTAIN', '', 'UniverseTwenty', 0, '2024-01-11 21:49:23'),
(21, 0, 'buy', 0, 0, 'BTC/USDT', 0, 'Rajat Soni, CFA', '', 'Rajatsonifnance', 0, '2024-01-13 11:25:59'),
(22, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Trader Mind Mastery ', '', 'tradersmindedge', 0, '2024-01-13 11:47:45'),
(23, 30, 'buy', 20, 0, 'BTC/XRP', 200, 'JackTheRippler Ⓒ', '', 'RippleXrpie', 0, '2024-01-14 11:16:24'),
(24, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Maria Slavko', '', 'Maria_Slavko', 0, '2024-01-14 15:03:30'),
(25, 0, 'buy', 0, 0, 'BNB/USDT', 0, 'Eunice D Wong', '', '@Eunicedwong', 0, '2024-01-18 09:26:40'),
(26, 0, 'sell', 0, 0, 'XRP/BTC', 0, 'XRP Official ⚡ï¸', '', '@Ripple_XRP1', 0, '2024-01-25 15:54:22'),
(27, 0, 'sell', 0, 0, 'BTC/BNB', 0, 'Wolf of Altcoins', '', 'wolfaltcoin', 0, '2024-02-03 12:13:11'),
(28, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Emperor 👑', '', 'EmperorBTC', 0, '2024-02-04 12:57:15'),
(29, 0, 'buy', 0, 0, 'TRX/USDT', 0, 'TanjaTrades', '', 'TanjaTrades', 0, '2024-02-05 13:48:18'),
(30, 50, 'sell', 99, 0, 'BTC/XRP', 100, 'Amanda $LUNC 🌖', '', 'AmandaLunc', 0, '2024-02-20 14:10:32'),
(31, 30, 'sell', 45, 0, 'BTC/USDT', 1000, 'Honey', '', 'honey_xbt', 0, '2024-02-23 08:55:47'),
(32, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'KC Trades ', '', 'KCTrades777', 0, '2024-03-11 16:10:34'),
(33, 60, 'sell', 45, 0, 'BTC/USDT', 100, 'Patrick Karim', '', 'badcharts1', 0, '2024-03-12 12:31:26'),
(34, 60, 'buy', 100, 0, 'BTC/XRP', 100, 'Sean McBride', '', 'seanmcrbride16', 0, '2024-03-12 13:31:27'),
(35, 100, 'buy', 100, 0, 'BTC/USDT', 100, 'Sean McBride', '', 'seanmcbride16', 0, '2024-03-12 13:33:17'),
(36, 46, 'buy', 46, 0, 'BTC/XRP', 100, '💎 Diamond Trades 💎', '', '@sparkle6193920', 0, '2024-04-02 21:00:47'),
(37, 30, 'buy', 100, 0, 'BTC/XRP', 100, 'Arman', '', 'ArmanTradess', 0, '2024-04-09 18:56:39'),
(38, 45, 'buy', 100, 0, 'BTC/ETH', 100, '💎 Diamond Trades 💎', '', 'sparkle6193920', 0, '2024-04-10 20:52:01'),
(39, 45, 'sell', 10, 0, 'BTC/XRP', 100, 'Sir Pickle', '', '@SirPickle_', 0, '2024-04-20 11:01:10'),
(40, 45, 'buy', 0, 0, 'BTC/ETH', 0, 'VirtualBacon', '', 'VirtualBaconOx', 0, '2024-05-02 03:30:21'),
(41, 95, 'buy', 90, 0, 'BTC/USDT', 500, 'Ash Crypto', '', 'Ashcryptoreal', 0, '2024-05-26 16:28:04'),
(42, 95, 'buy', 100, 0, 'BTC/ETH', 100, 'BitcoinHabebe', '', 'Bitcoinhabebe', 0, '2024-06-10 18:09:06'),
(43, 0, 'buy', 0, 0, 'ETH/XRP', 0, 'Armando Pantoja', '', '_TallGuyTycoon', 0, '2024-06-19 16:27:36'),
(44, 0, 'buy', 0, 0, 'BTC/XRP', 0, 'Robin Seyr', '', 'RobinSeyr', 0, '2024-08-14 21:59:09'),
(45, 90, 'buy', 95, 0, 'BTC/USDT', 2000, 'Lawrence Lepard, \"fix the money, fix the world\"', '', 'LawrenceLepard', 0, '2024-09-09 22:24:39'),
(46, 90, 'buy', 85, 0, 'USDT/ETH', 100, 'Vivek ⚡ï¸', '', 'Vivek4real_', 0, '2024-09-17 12:39:58'),
(47, 30, 'buy', 25, 0, 'BTC/USDT', 2000, 'Sykodelic 🔪', '', 'Sykodelic_', 0, '2024-10-06 08:34:06'),
(48, 70, 'buy', 96, 0, 'ETH/BTC ', 200, 'Jimmy Song (송재준)', '', 'jimmysong', 0, '2024-11-11 07:28:09'),
(49, 95, 'buy', 100, 0, 'HEX/BTC', 1000, 'SUPERHEX', '', 'superhexwin ', 0, '2024-11-16 08:04:23'),
(50, 0, 'buy', 0, 0, 'USDT/ETH', 0, 'Brett Hill', '', 'Brett_Crypto_X', 0, '2024-12-04 08:42:42');

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

--
-- Table structure for table `trade`
--

CREATE TABLE `trade` (
  `id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `amount` int(11) NOT NULL,
  `strike-rate` int(11) NOT NULL,
  `end-time` varchar(255) NOT NULL,
  `end-price` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `trading-type` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `amount` float NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `method` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `transactions` (`id`, `type`, `amount`, `date`, `status`, `email`, `method`) VALUES
(259, 'Deposit', 100, '2023-12-07 08:34:10', 0, 'Rijnbeek2000@hotmail.com', 'BITCOIN'),
(260, 'Deposit', 1, '2023-12-07 12:43:11', 0, 'Aliusuleiman123@icloud.com', 'BITCOIN'),
(261, 'Deposit', 1, '2023-12-07 12:43:13', 0, 'Aliusuleiman123@icloud.com', 'BITCOIN'),
(262, 'Deposit', 5000, '2023-12-11 14:51:37', 0, 'madukwebethel995@gmail.com', 'BITCOIN'),
(263, 'Deposit', 1000, '2023-12-12 16:46:44', 0, 'mer_georg@yahoo.com', 'USDT(TRC20)'),
(264, 'Deposit', 350000, '2023-12-20 07:17:12', 0, 'madukwebethel995@gmail.com', 'BITCOIN'),
(265, 'Deposit', 350000, '2023-12-20 07:17:18', 0, 'madukwebethel995@gmail.com', 'BITCOIN'),
(266, 'Deposit', 100, '2023-12-20 19:41:09', 0, 'asad_ambitious@ymail.com', 'BITCOIN'),
(267, 'Deposit', 100, '2023-12-20 19:46:50', 0, 'asad_ambitious@ymail.com', 'BITCOIN'),
(268, 'Deposit', 203, '2023-12-26 19:50:54', 0, 'knotillusion@hotmail.com', 'Etheruem'),
(269, 'Deposit', 203, '2023-12-26 19:52:43', 0, 'knotillusion@hotmail.com', 'Etheruem'),
(270, 'Deposit', 500, '2024-01-01 10:28:49', 0, 'Iamoppongclifford@gmail.com', 'USDT(TRC20)'),
(271, 'Deposit', 160, '2024-01-11 19:48:39', 0, 'Daijuutenkaichi99@gmail.com', 'XRP'),
(272, 'Deposit', 230000, '2024-01-13 20:52:03', 0, 'madukwebethel995@gmail.com', 'BITCOIN'),
(273, 'Deposit', 1000, '2024-01-18 18:55:16', 0, 'andre.petitcol@neuf.fr', 'BITCOIN'),
(274, 'Deposit', 10, '2024-01-29 16:16:13', 0, 'dhaferchakchouki0@gmail.com', 'BITCOIN'),
(275, 'Deposit', 500, '2024-02-06 16:42:00', 0, 'proadvice.trading@gmail.com', 'USDT(TRC20)'),
(276, 'Deposit', 500, '2024-02-06 16:42:16', 0, 'proadvice.trading@gmail.com', 'USDT(TRC20)'),
(277, 'Deposit', 2000, '2024-02-26 20:41:09', 0, 'proadvice.trading@gmail.com', 'USDT(TRC20)'),
(278, 'Deposit', 2000, '2024-02-26 20:41:20', 0, 'proadvice.trading@gmail.com', 'USDT(TRC20)'),
(279, 'Deposit', 200, '2024-03-10 21:13:01', 0, 'Montycj091@gmail.com', 'XRP'),
(280, 'Deposit', 100, '2024-03-11 16:01:30', 0, 'frankuzwol8@gmail.com', 'BITCOIN'),
(281, 'Deposit', 100, '2024-03-11 16:39:55', 0, 'frankuzwol8@gmail.com', 'BITCOIN'),
(282, 'Deposit', 100, '2024-03-11 16:39:56', 0, 'frankuzwol8@gmail.com', 'BITCOIN'),
(283, 'Deposit', 35, '2024-03-11 20:43:10', 0, 'frankuzwol8@gmail.com', 'BITCOIN'),
(284, 'Deposit', 24, '2024-03-13 01:42:53', 0, 'manishmani22171@gmail.com', 'XRP'),
(285, 'Deposit', 200, '2024-03-30 14:05:12', 0, 'frankuzwol8@gmail.com', 'BITCOIN'),
(286, 'Deposit', 700, '2024-04-30 17:21:49', 0, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)'),
(287, 'Deposit', 300, '2024-05-02 00:49:23', 0, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)'),
(288, 'Deposit', 300, '2024-05-02 00:50:04', 0, 'mirza_gubeladze@yahoo.com', 'USDT(TRC20)'),
(289, 'Deposit', 690, '2024-05-02 15:14:39', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(290, 'Deposit', 690, '2024-05-02 15:14:43', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(291, 'Deposit', 690, '2024-05-02 15:15:13', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(292, 'Deposit', 690, '2024-05-02 15:23:50', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(293, 'Deposit', 690, '2024-05-02 15:41:51', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(294, 'Deposit', 690, '2024-05-02 15:50:33', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(295, 'Deposit', 690, '2024-05-02 16:15:30', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(296, 'Deposit', 690, '2024-05-02 16:39:11', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(297, 'Deposit', 690, '2024-05-02 16:50:07', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(298, 'Deposit', 690, '2024-05-02 16:58:19', 0, 'mirza_gubeladze@yahoo.com', 'Etheruem'),
(299, 'Deposit', 400, '2024-05-04 03:15:44', 0, 'kyle.leonard84@yahoo.com', 'BITCOIN'),
(300, 'Deposit', 10, '2024-05-06 15:30:07', 0, 'mnigelmoyo23@gmail.com', 'USDT(TRC20)'),
(301, 'Deposit', 0.192652, '2024-05-10 09:44:06', 0, 'adeniyi4499@gmail.com', 'USDT(TRC20)'),
(302, 'Deposit', 50, '2024-06-13 21:10:39', 0, 'salah.artin786@gmail.com', 'BITCOIN'),
(303, 'Deposit', 50, '2024-06-13 21:12:41', 0, 'salah.artin786@gmail.com', 'BITCOIN'),
(304, 'Deposit', 5000, '2024-06-13 21:21:09', 0, 'salah.artin786@gmail.com', 'BITCOIN'),
(305, 'Deposit', 2000, '2024-06-18 23:11:14', 0, 'one.baja.life@gmail.com', 'Etheruem'),
(306, 'Deposit', 2000, '2024-06-18 23:26:23', 0, 'one.baja.life@gmail.com', 'Etheruem'),
(307, 'Deposit', 0, '2024-06-28 21:51:34', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(308, 'Deposit', 0, '2024-06-28 21:51:40', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(309, 'Deposit', 0, '2024-06-28 21:51:59', 0, 'mehmood22537@gmail.com', 'Etheruem'),
(310, 'Deposit', 0, '2024-06-28 21:52:09', 0, 'mehmood22537@gmail.com', 'USDT(TRC20)'),
(311, 'Deposit', 0, '2024-06-28 21:52:15', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(312, 'Deposit', 0, '2024-06-28 21:52:23', 0, 'mehmood22537@gmail.com', 'XRP'),
(313, 'Deposit', 0, '2024-06-28 21:52:30', 0, 'mehmood22537@gmail.com', 'XRP'),
(314, 'Deposit', 0, '2024-06-28 21:52:46', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(315, 'Deposit', 0, '2024-06-28 21:52:49', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(316, 'Deposit', 0, '2024-06-28 21:52:51', 0, 'mehmood22537@gmail.com', 'BITCOIN'),
(317, 'Deposit', 2000, '2024-07-12 15:00:25', 0, 'proadvice.trading@gmail.com', 'USDT(TRC20)'),
(318, 'Deposit', 100, '2024-08-04 08:24:18', 0, 'patel.dinesh603@gmail.com', 'BITCOIN'),
(319, 'Deposit', 50, '2024-10-04 19:18:22', 0, 'nkuhtalikong@gmail.com', 'USDT(TRC20)'),
(320, 'Deposit', 200, '2024-10-04 21:13:59', 0, 'oapodaca09@gmail.com', 'BITCOIN'),
(321, 'Deposit', 600, '2024-11-11 07:22:54', 0, 'chaosmite@chaosmite.net', 'Etheruem'),
(322, 'Deposit', 50, '2024-11-16 21:53:27', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(323, 'Deposit', 50, '2024-11-16 21:54:00', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(324, 'Deposit', 50, '2024-11-16 21:55:45', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(325, 'Deposit', 50, '2024-11-16 22:09:28', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(326, 'Deposit', 50, '2024-11-16 22:10:52', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(327, 'Deposit', 150, '2024-11-16 22:48:45', 0, 'neelnibir55@gmail.com', 'USDT(TRC20)'),
(328, 'Deposit', 200, '2024-12-16 15:15:23', 0, 'caraceramos@gmail.com', 'BITCOIN'),
(329, 'Deposit', 100, '2024-12-19 15:58:20', 0, 'Jacques@taltec.co.za', 'XRP'),
(330, 'Deposit', 200, '2024-12-21 22:51:11', 0, 'caraceramos@gmail.com', 'Etheruem'),
(331, 'Deposit', 100, '2024-12-30 18:17:29', 0, 'caraceramos@gmail.com', 'Etheruem');

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

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

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `amount` float NOT NULL,
  `method` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `transfer_code` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `withdrawals` (`id`, `email`, `amount`, `method`, `address`, `transfer_code`, `date`, `status`) VALUES
(101, 'madukwebethel995@gmail.com', 150000, 'USDT', 'TDE4eeQS2q1Ye7PpWRt8g3QkEidpDhBYw8', 'Tuijhhj', '2023-12-26 19:35:31', 1),
(102, 'knotillusion@hotmail.com', 0.01, 'Bitcoin', 'bc1qwazw7h6nwpkuwqgkcz2q6vu9al90nw8yuwrsc9', '369', '2023-12-26 23:50:52', 0),
(103, 'Daijuutenkaichi99@gmail.com', 266, 'XRP', 'rnPbvk4ZgzaAYjQXmmemTTZWohfKRCPTJk', '', '2024-01-13 07:41:03', 0),
(104, 'proadvice.trading@gmail.com', 50000, 'Ethereum', '0x23A7b8B00f2d0165a086F18dca30D21EBD07C4B7', '561100', '2024-03-04 08:57:20', 1),
(105, 'Montycj091@gmail.com', 200, 'USDT', '0x9CFf905faeecD3f35A91b152e5B6105CFE957977', '', '2024-03-10 23:26:34', 1),
(106, 'manishmani22171@gmail.com', 27, 'USDT', 'TGJSz21NwQi9TVmsEsq7Xa6jVHstdPY8JN', '', '2024-03-15 13:56:19', 0),
(108, 'cadjewelryschool@gmail.com', 96, 'Ethereum', '0xD12dCDA7E358899f7d7bF34DF68FAE6283367b5E', '73476498', '2024-08-15 21:15:21', 1),
(109, 'neelnibir55@gmail.com', 260, 'USDT', 'TLg4zix1yNYhN8r3Vxo6ZjHf2Vb2qBPvUy', '', '2024-11-17 04:39:53', 0);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

