-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 14, 2025 at 10:27 PM
-- Server version: 10.11.10-MariaDB
-- PHP Version: 8.3.15

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

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

--
-- Table structure for table `bots`
--

CREATE TABLE `bots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `bot_type` varchar(255) NOT NULL,
  `trading_pair` varchar(255) DEFAULT 'BTC/USDT',
  `status` varchar(255) DEFAULT 'active',
  `min_amount` decimal(18,8) NOT NULL,
  `max_amount` decimal(18,8) NOT NULL,
  `duration` varchar(255) NOT NULL DEFAULT '24h',
  `total_profit` decimal(18,8) DEFAULT 0.00000000,
  `total_subscribers` int(11) DEFAULT 0,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `last_trade_at` timestamp NULL DEFAULT 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 `bots`
--

INSERT INTO `bots` (`id`, `name`, `bot_type`, `trading_pair`, `status`, `min_amount`, `max_amount`, `duration`, `total_profit`, `total_subscribers`, `settings`, `last_trade_at`, `created_at`, `updated_at`) VALUES
(1, 'BTC Grid Pro', 'grid', 'BTC/USDT', 'active', 200.00000000, 20000.00000000, '24h', 15.75000000, 17, '{\"grid_levels\": 12, \"upper_price\": 35000, \"lower_price\": 30000}', NULL, '2025-01-20 08:25:32', '2025-03-06 18:41:36'),
(2, 'ETH DCA Master', 'dca', 'ETH/USDT', 'active', 50.00000000, 5000.00000000, '7d', 8.45000000, 11, '{\"interval_hours\": 6, \"target_profit\": 3}', NULL, '2025-01-20 08:25:32', '2025-03-06 18:51:54'),
(3, 'Quick Arbitrage', 'arbitrage', 'USDT/BUSD', 'active', 200.00000000, 20000.00000000, '4h', 5.25000000, 2, '{\"min_spread\": 0.8, \"exchanges\": [\"binance\", \"huobi\"]}', NULL, '2025-01-20 08:25:32', '2025-01-20 08:25:32');

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

--
-- Table structure for table `bot_settings`
--

CREATE TABLE `bot_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bot_type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`parameters`)),
  `supported_pairs` text DEFAULT NULL,
  `duration_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`duration_options`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bot_settings`
--

INSERT INTO `bot_settings` (`id`, `bot_type`, `name`, `is_active`, `parameters`, `supported_pairs`, `duration_options`, `created_at`, `updated_at`) VALUES
(1, 'grid', 'Grid Trading Bot', 1, '{\"grid_levels\":\"10\",\"upper_limit\":\"1.05\",\"lower_limit\":\"0.95\"}', '[\"BTC\\/USDT\",\"ETH\\/USDT\",\"LTC\\/USDT\",\"XRP\\/USDT\",\"BNB\\/USDT\",\"ADA\\/USDT\",\"SOL\\/USDT\",\"DOGE\\/USDT\",\"DASH\\/USDT\",\"XLM\\/USDT\"]', '[\"5m\",\"10m\",\"15m\",\"30m\",\"1h\",\"4h\",\"12h\",\"24h\",\"3d\",\"7d\",\"30d\"]', '2025-01-20 08:25:32', '2025-03-05 17:49:56'),
(2, 'dca', 'DCA Trading Bot', 1, '{\"interval_hours\": 4, \"price_deviation\": 2}', NULL, '[\"24h\", \"7d\", \"30d\"]', '2025-01-20 08:25:32', '2025-01-20 08:25:32'),
(3, 'arbitrage', 'Arbitrage Bot', 1, '{\"min_spread\": 0.5, \"max_slippage\": 0.1}', NULL, '[\"1h\", \"4h\", \"12h\", \"24h\"]', '2025-01-20 08:25:32', '2025-01-20 08:25:32');

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

--
-- Table structure for table `bot_subscriptions`
--

CREATE TABLE `bot_subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bot_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `current_profit` decimal(18,8) DEFAULT 0.00000000,
  `total_profit` decimal(18,8) DEFAULT 0.00000000,
  `status` varchar(255) DEFAULT 'active',
  `subscribed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `expires_at` timestamp NULL DEFAULT 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;

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

--
-- Table structure for table `bot_trades`
--

CREATE TABLE `bot_trades` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bot_id` bigint(20) UNSIGNED NOT NULL,
  `trading_pair` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `price` decimal(18,8) NOT NULL,
  `profit` decimal(18,8) DEFAULT NULL,
  `result` enum('win','loss') DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `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 `bot_trades`
--

INSERT INTO `bot_trades` (`id`, `bot_id`, `trading_pair`, `action`, `amount`, `price`, `profit`, `result`, `metadata`, `created_at`, `updated_at`) VALUES
(19, 1, 'TRX/USDT', 'buy', 500.00000000, 0.24504100, 0.00000000, NULL, '{\"notes\":\"User subscribed to bot with dynamic pair.\",\"updated_for_trade\":\"2025-02-24 22:19:28\"}', '2025-02-24 21:19:28', '2025-02-24 21:19:28'),
(20, 2, 'BTC/USDT', 'sell', 100.00000000, 90398.63000000, 0.00000000, NULL, '{\"notes\":\"User subscribed to bot with dynamic pair.\",\"updated_for_trade\":\"2025-03-05 20:53:46\"}', '2025-03-05 19:53:46', '2025-03-05 19:53:46'),
(21, 1, 'BTC/USDT', 'sell', 10000.00000000, 88356.82000000, 0.00000000, NULL, '{\"notes\":\"User subscribed to bot with dynamic pair.\",\"updated_for_trade\":\"2025-03-06 19:41:36\"}', '2025-03-06 18:41:35', '2025-03-06 18:41:36'),
(22, 2, 'ETH/USDT', 'sell', 500.00000000, 2216.48000000, 0.00000000, NULL, '{\"notes\":\"User subscribed to bot with dynamic pair.\",\"updated_for_trade\":\"2025-03-06 19:51:54\"}', '2025-03-06 18:51:54', '2025-03-06 18:51:54');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('0a57cb53ba59c46fc4b692527a38a87c78d84028', 'i:1;', 1740666581),
('0a57cb53ba59c46fc4b692527a38a87c78d84028:timer', 'i:1740666581;', 1740666581),
('123456|191.101.157.6', 'i:1;', 1740439571),
('123456|191.101.157.6:timer', 'i:1740439571;', 1740439571),
('12c6fc06c99a462375eeb3f43dfd832b08ca9e17', 'i:1;', 1740419244),
('12c6fc06c99a462375eeb3f43dfd832b08ca9e17:timer', 'i:1740419244;', 1740419244),
('1f1362ea41d1bc65be321c0a378a20159f9a26d0', 'i:1;', 1741455249),
('1f1362ea41d1bc65be321c0a378a20159f9a26d0:timer', 'i:1741455249;', 1741455249),
('22d200f8670dbdb3e253a90eee5098477c95c23d', 'i:2;', 1740853285),
('22d200f8670dbdb3e253a90eee5098477c95c23d:timer', 'i:1740853285;', 1740853285),
('2a459380709e2fe4ac2dae5733c73225ff6cfee1', 'i:1;', 1741342858),
('2a459380709e2fe4ac2dae5733c73225ff6cfee1:timer', 'i:1741342858;', 1741342858),
('2e01e17467891f7c933dbaa00e1459d23db3fe4f', 'i:2;', 1741025694),
('2e01e17467891f7c933dbaa00e1459d23db3fe4f:timer', 'i:1741025694;', 1741025694),
('35e995c107a71caeb833bb3b79f9f54781b33fa1', 'i:1;', 1741432307),
('35e995c107a71caeb833bb3b79f9f54781b33fa1:timer', 'i:1741432307;', 1741432307),
('450ddec8dd206c2e2ab1aeeaa90e85e51753b8b7', 'i:1;', 1741513984),
('450ddec8dd206c2e2ab1aeeaa90e85e51753b8b7:timer', 'i:1741513984;', 1741513984),
('4d89d294cd4ca9f2ca57dc24a53ffb3ef5303122', 'i:1;', 1741362407),
('4d89d294cd4ca9f2ca57dc24a53ffb3ef5303122:timer', 'i:1741362407;', 1741362407),
('511a418e72591eb7e33f703f04c3fa16df6c90bd', 'i:1;', 1741303551),
('511a418e72591eb7e33f703f04c3fa16df6c90bd:timer', 'i:1741303551;', 1741303551),
('59129aacfb6cebbe2c52f30ef3424209f7252e82', 'i:1;', 1741357539),
('59129aacfb6cebbe2c52f30ef3424209f7252e82:timer', 'i:1741357539;', 1741357539),
('5a5b0f9b7d3f8fc84c3cef8fd8efaaa6c70d75ab', 'i:1;', 1741213751),
('5a5b0f9b7d3f8fc84c3cef8fd8efaaa6c70d75ab:timer', 'i:1741213751;', 1741213751),
('5b384ce32d8cdef02bc3a139d4cac0a22bb029e8', 'i:1;', 1740961441),
('5b384ce32d8cdef02bc3a139d4cac0a22bb029e8:timer', 'i:1740961441;', 1740961441),
('632667547e7cd3e0466547863e1207a8c0c0c549', 'i:1;', 1740908742),
('632667547e7cd3e0466547863e1207a8c0c0c549:timer', 'i:1740908742;', 1740908742),
('667be543b02294b7624119adc3a725473df39885', 'i:1;', 1741206694),
('667be543b02294b7624119adc3a725473df39885:timer', 'i:1741206694;', 1741206694),
('6c1e671f9af5b46d9c1a52067bdf0e53685674f7', 'i:1;', 1741248282),
('6c1e671f9af5b46d9c1a52067bdf0e53685674f7:timer', 'i:1741248282;', 1741248282),
('761f22b2c1593d0bb87e0b606f990ba4974706de', 'i:1;', 1740986083),
('761f22b2c1593d0bb87e0b606f990ba4974706de:timer', 'i:1740986083;', 1740986083),
('7719a1c782a1ba91c031a682a0a2f8658209adbf', 'i:2;', 1740737439),
('7719a1c782a1ba91c031a682a0a2f8658209adbf:timer', 'i:1740737439;', 1740737439),
('80e28a51cbc26fa4bd34938c5e593b36146f5e0c', 'i:2;', 1741176397),
('80e28a51cbc26fa4bd34938c5e593b36146f5e0c:timer', 'i:1741176397;', 1741176397),
('827bfc458708f0b442009c9c9836f7e4b65557fb', 'i:1;', 1741022274),
('827bfc458708f0b442009c9c9836f7e4b65557fb:timer', 'i:1741022274;', 1741022274),
('8effee409c625e1a2d8f5033631840e6ce1dcb64', 'i:1;', 1741199679),
('8effee409c625e1a2d8f5033631840e6ce1dcb64:timer', 'i:1741199679;', 1741199679),
('9109c85a45b703f87f1413a405549a2cea9ab556', 'i:1;', 1741200896),
('9109c85a45b703f87f1413a405549a2cea9ab556:timer', 'i:1741200896;', 1741200896),
('92cfceb39d57d914ed8b14d0e37643de0797ae56', 'i:1;', 1740985390),
('92cfceb39d57d914ed8b14d0e37643de0797ae56:timer', 'i:1740985390;', 1740985390),
('972a67c48192728a34979d9a35164c1295401b71', 'i:3;', 1740953315),
('972a67c48192728a34979d9a35164c1295401b71:timer', 'i:1740953315;', 1740953315),
('98fbc42faedc02492397cb5962ea3a3ffc0a9243', 'i:1;', 1740994323),
('98fbc42faedc02492397cb5962ea3a3ffc0a9243:timer', 'i:1740994323;', 1740994323),
('a17554a0d2b15a664c0e73900184544f19e70227', 'i:2;', 1741305281),
('a17554a0d2b15a664c0e73900184544f19e70227:timer', 'i:1741305281;', 1741305281),
('a72b20062ec2c47ab2ceb97ac1bee818f8b6c6cb', 'i:1;', 1741371044),
('a72b20062ec2c47ab2ceb97ac1bee818f8b6c6cb:timer', 'i:1741371044;', 1741371044),
('a9334987ece78b6fe8bf130ef00b74847c1d3da6', 'i:1;', 1741084041),
('a9334987ece78b6fe8bf130ef00b74847c1d3da6:timer', 'i:1741084041;', 1741084041),
('achikakumar0@gmail.com|223.185.24.65', 'i:1;', 1740986071),
('achikakumar0@gmail.com|223.185.24.65:timer', 'i:1740986071;', 1740986071),
('admin@|105.112.211.29', 'i:1;', 1740904747),
('admin@|105.112.211.29:timer', 'i:1740904747;', 1740904747),
('admin@|105.112.212.119', 'i:1;', 1740904955),
('admin@|105.112.212.119:timer', 'i:1740904955;', 1740904955),
('admin@|105.112.214.118', 'i:1;', 1740854408),
('admin@|105.112.214.118:timer', 'i:1740854408;', 1740854408),
('admin@1223344|105.112.211.29', 'i:1;', 1740904451),
('admin@1223344|105.112.211.29:timer', 'i:1740904451;', 1740904451),
('admin@1223344|105.112.214.118', 'i:1;', 1740854470),
('admin@1223344|105.112.214.118:timer', 'i:1740854470;', 1740854470),
('admin@1223344|105.112.221.146', 'i:1;', 1740472579),
('admin@1223344|105.112.221.146:timer', 'i:1740472579;', 1740472579),
('admin@123456|105.112.211.29', 'i:1;', 1740904415),
('admin@123456|105.112.211.29:timer', 'i:1740904415;', 1740904415),
('admin@mail.com|102.90.46.93', 'i:1;', 1740403686),
('admin@mail.com|102.90.46.93:timer', 'i:1740403686;', 1740403686),
('admin|102.90.46.93', 'i:1;', 1740424136),
('admin|102.90.46.93:timer', 'i:1740424136;', 1740424136),
('admit|105.112.214.195', 'i:1;', 1740472443),
('admit|105.112.214.195:timer', 'i:1740472443;', 1740472443),
('af3e133428b9e25c55bc59fe534248e6a0c0f17b', 'i:2;', 1740975727),
('af3e133428b9e25c55bc59fe534248e6a0c0f17b:timer', 'i:1740975727;', 1740975727),
('aswd01923@gmail.com|185.255.45.193', 'i:1;', 1741212622),
('aswd01923@gmail.com|185.255.45.193:timer', 'i:1741212622;', 1741212622),
('b6692ea5df920cad691c20319a6fffd7a4a766b8', 'i:1;', 1740940611),
('b6692ea5df920cad691c20319a6fffd7a4a766b8:timer', 'i:1740940611;', 1740940611),
('b7103ca278a75cad8f7d065acda0c2e80da0b7dc', 'i:2;', 1741399153),
('b7103ca278a75cad8f7d065acda0c2e80da0b7dc:timer', 'i:1741399153;', 1741399153),
('b7eb6c689c037217079766fdb77c3bac3e51cb4c', 'i:2;', 1741075550),
('b7eb6c689c037217079766fdb77c3bac3e51cb4c:timer', 'i:1741075550;', 1741075550),
('batceoenec@yahoo.com|138.99.72.101', 'i:2;', 1740959622),
('batceoenec@yahoo.com|138.99.72.101:timer', 'i:1740959622;', 1740959622),
('c097638f92de80ba8d6c696b26e6e601a5f61eb7', 'i:1;', 1741419687),
('c097638f92de80ba8d6c696b26e6e601a5f61eb7:timer', 'i:1741419687;', 1741419687),
('c5b76da3e608d34edb07244cd9b875ee86906328', 'i:2;', 1741102708),
('c5b76da3e608d34edb07244cd9b875ee86906328:timer', 'i:1741102708;', 1741102708),
('c66c65175fecc3103b3b587be9b5b230889c8628', 'i:2;', 1741329204),
('c66c65175fecc3103b3b587be9b5b230889c8628:timer', 'i:1741329204;', 1741329204),
('ca3512f4dfa95a03169c5a670a4c91a19b3077b4', 'i:1;', 1740961787),
('ca3512f4dfa95a03169c5a670a4c91a19b3077b4:timer', 'i:1740961787;', 1740961787),
('cadetcaution@gmail.com|105.113.58.60', 'i:2;', 1740911528),
('cadetcaution@gmail.com|105.113.58.60:timer', 'i:1740911528;', 1740911528),
('cb4e5208b4cd87268b208e49452ed6e89a68e0b8', 'i:1;', 1740911674),
('cb4e5208b4cd87268b208e49452ed6e89a68e0b8:timer', 'i:1740911674;', 1740911674),
('cb7a1d775e800fd1ee4049f7dca9e041eb9ba083', 'i:1;', 1740960569),
('cb7a1d775e800fd1ee4049f7dca9e041eb9ba083:timer', 'i:1740960569;', 1740960569),
('cmarlinrb@gmail.com|61.7.156.254', 'i:2;', 1741127200),
('cmarlinrb@gmail.com|61.7.156.254:timer', 'i:1741127200;', 1741127200),
('crypto_prices', 'a:11:{s:7:\"bitcoin\";a:3:{s:3:\"usd\";d:83971.800000000002910383045673370361328125;s:14:\"usd_24h_change\";d:4.30999999999999960920149533194489777088165283203125;s:12:\"last_updated\";i:1741986856;}s:8:\"ethereum\";a:3:{s:3:\"usd\";d:1919.3699999999998908606357872486114501953125;s:14:\"usd_24h_change\";d:4.019999999999999573674358543939888477325439453125;s:12:\"last_updated\";i:1741986856;}s:6:\"tether\";a:3:{s:3:\"usd\";i:1;s:14:\"usd_24h_change\";i:0;s:12:\"last_updated\";i:1741986856;}s:4:\"tron\";a:3:{s:3:\"usd\";d:0.2210999999999999909849890400437288917601108551025390625;s:14:\"usd_24h_change\";d:-0.94000000000000005773159728050814010202884674072265625;s:12:\"last_updated\";i:1741986856;}s:11:\"binancecoin\";a:3:{s:3:\"usd\";d:585.6670000000000300133251585066318511962890625;s:14:\"usd_24h_change\";d:1.8499999999999998667732370449812151491641998291015625;s:12:\"last_updated\";i:1741986856;}s:8:\"polkadot\";a:3:{s:3:\"usd\";d:4.1921999999999997044142219237983226776123046875;s:14:\"usd_24h_change\";d:7.5600000000000004973799150320701301097869873046875;s:12:\"last_updated\";i:1741986856;}s:12:\"bitcoin-cash\";a:3:{s:3:\"usd\";d:326.17000000000001591615728102624416351318359375;s:14:\"usd_24h_change\";d:0.309999999999999997779553950749686919152736663818359375;s:12:\"last_updated\";i:1741986856;}s:8:\"litecoin\";a:3:{s:3:\"usd\";d:91.644000000000005456968210637569427490234375;s:14:\"usd_24h_change\";d:5.79000000000000003552713678800500929355621337890625;s:12:\"last_updated\";i:1741986856;}s:7:\"stellar\";a:3:{s:3:\"usd\";d:0.2741000000000000103028696685214526951313018798828125;s:14:\"usd_24h_change\";d:2.350000000000000088817841970012523233890533447265625;s:12:\"last_updated\";i:1741986856;}s:4:\"dash\";a:3:{s:3:\"usd\";d:22.5799999999999982946974341757595539093017578125;s:14:\"usd_24h_change\";d:3.910000000000000142108547152020037174224853515625;s:12:\"last_updated\";i:1741986856;}s:6:\"solana\";a:3:{s:3:\"usd\";d:133.448000000000007503331289626657962799072265625;s:14:\"usd_24h_change\";d:9.7599999999999997868371792719699442386627197265625;s:12:\"last_updated\";i:1741986856;}}', 1741986916),
('d02560dd9d7db4467627745bd6701e809ffca6e3', 'i:1;', 1741418821),
('d02560dd9d7db4467627745bd6701e809ffca6e3:timer', 'i:1741418821;', 1741418821),
('d435a6cdd786300dff204ee7c2ef942d3e9034e2', 'i:1;', 1740432076),
('d435a6cdd786300dff204ee7c2ef942d3e9034e2:timer', 'i:1740432076;', 1740432076),
('d54ad009d179ae346683cfc3603979bc99339ef7', 'i:1;', 1741514173),
('d54ad009d179ae346683cfc3603979bc99339ef7:timer', 'i:1741514173;', 1741514173),
('droachu7@gmail.com|186.179.100.211', 'i:2;', 1740837665),
('droachu7@gmail.com|186.179.100.211:timer', 'i:1740837665;', 1740837665),
('e1822db470e60d090affd0956d743cb0e7cdf113', 'i:1;', 1741035464),
('e1822db470e60d090affd0956d743cb0e7cdf113:timer', 'i:1741035464;', 1741035464),
('e6c3dd630428fd54834172b8fd2735fed9416da4', 'i:1;', 1741217996),
('e6c3dd630428fd54834172b8fd2735fed9416da4:timer', 'i:1741217996;', 1741217996),
('eakismetoy95echo84@gmail.com|103.179.241.133', 'i:2;', 1740455599),
('eakismetoy95echo84@gmail.com|103.179.241.133:timer', 'i:1740455599;', 1740455599),
('ebaxterm19@gmail.com|176.235.99.27', 'i:2;', 1740771866),
('ebaxterm19@gmail.com|176.235.99.27:timer', 'i:1740771866;', 1740771866),
('f1f836cb4ea6efb2a0b1b99f41ad8b103eff4b59', 'i:1;', 1740940527),
('f1f836cb4ea6efb2a0b1b99f41ad8b103eff4b59:timer', 'i:1740940527;', 1740940527),
('f6e1126cedebf23e1463aee73f9df08783640400', 'i:2;', 1740473067),
('f6e1126cedebf23e1463aee73f9df08783640400:timer', 'i:1740473067;', 1740473067),
('fb644351560d8296fe6da332236b1f8d61b2828a', 'i:1;', 1741101648),
('fb644351560d8296fe6da332236b1f8d61b2828a:timer', 'i:1741101648;', 1741101648),
('fc074d501302eb2b93e2554793fcaf50b3bf7291', 'i:1;', 1740953638),
('fc074d501302eb2b93e2554793fcaf50b3bf7291:timer', 'i:1740953638;', 1740953638),
('fe2ef495a1152561572949784c16bf23abb28057', 'i:1;', 1741020380),
('fe2ef495a1152561572949784c16bf23abb28057:timer', 'i:1741020380;', 1741020380),
('hshhshh@gmail.com|185.255.45.193', 'i:1;', 1741208231),
('hshhshh@gmail.com|185.255.45.193:timer', 'i:1741208231;', 1741208231),
('ifecogabriel@gmail.com|102.90.97.239', 'i:3;', 1740940674),
('ifecogabriel@gmail.com|102.90.97.239:timer', 'i:1740940674;', 1740940674),
('johnsonmark9202962@gmail.com|102.88.84.16', 'i:2;', 1740985963),
('johnsonmark9202962@gmail.com|102.88.84.16:timer', 'i:1740985963;', 1740985963),
('kelvincourage123@gmail.com|102.90.46.93', 'i:2;', 1740428592),
('kelvincourage123@gmail.com|102.90.46.93:timer', 'i:1740428592;', 1740428592),
('kibiwotk188@gmail.com|154.157.85.235', 'i:1;', 1741513603),
('kibiwotk188@gmail.com|154.157.85.235:timer', 'i:1741513603;', 1741513603),
('kibiwotk5@gmail.com|154.157.85.235', 'i:1;', 1741513553),
('kibiwotk5@gmail.com|154.157.85.235:timer', 'i:1741513553;', 1741513553),
('kipchumbakelvin188@gmail.com|154.157.85.235', 'i:5;', 1741513518),
('kipchumbakelvin188@gmail.com|154.157.85.235:timer', 'i:1741513518;', 1741513518),
('lfryjq24@gmail.com|167.179.44.155', 'i:2;', 1741493625),
('lfryjq24@gmail.com|167.179.44.155:timer', 'i:1741493625;', 1741493625),
('liraponcep51@gmail.com|124.41.228.59', 'i:2;', 1740898089),
('liraponcep51@gmail.com|124.41.228.59:timer', 'i:1740898089;', 1740898089),
('merdodukev40@gmail.com|179.107.200.248', 'i:2;', 1741335621),
('merdodukev40@gmail.com|179.107.200.248:timer', 'i:1741335621;', 1741335621),
('operezx6@gmail.com|41.92.184.73', 'i:2;', 1740713249),
('operezx6@gmail.com|41.92.184.73:timer', 'i:1740713249;', 1740713249),
('ryanlikewise132@gmail.com|102.89.84.153', 'i:2;', 1740514418),
('ryanlikewise132@gmail.com|102.89.84.153:timer', 'i:1740514418;', 1740514418),
('ryanlikewise132@gmail.com|102.90.103.147', 'i:1;', 1740512501),
('ryanlikewise132@gmail.com|102.90.103.147:timer', 'i:1740512501;', 1740512501),
('ryanlikewise132@gmail.com|102.90.103.252', 'i:1;', 1740477636),
('ryanlikewise132@gmail.com|102.90.103.252:timer', 'i:1740477636;', 1740477636),
('ryanlikewise132@gmail.com|102.90.46.93', 'i:2;', 1740432211),
('ryanlikewise132@gmail.com|102.90.46.93:timer', 'i:1740432211;', 1740432211),
('ryanlikewise132@gmail.com|102.90.97.239', 'i:2;', 1740938979),
('ryanlikewise132@gmail.com|102.90.97.239:timer', 'i:1740938979;', 1740938979),
('ryanlikewise132@gmail.com|105.112.210.225', 'i:1;', 1740666409),
('ryanlikewise132@gmail.com|105.112.210.225:timer', 'i:1740666409;', 1740666409),
('ryanlikewise132@gmail.com|191.101.157.6', 'i:3;', 1740439488),
('ryanlikewise132@gmail.com|191.101.157.6:timer', 'i:1740439488;', 1740439488),
('ss|41.90.217.146', 'i:1;', 1740995808),
('ss|41.90.217.146:timer', 'i:1740995808;', 1740995808),
('standardvino515@gmail.com|105.112.208.241', 'i:2;', 1740853153),
('standardvino515@gmail.com|105.112.208.241:timer', 'i:1740853153;', 1740853153),
('standardvino515@gmail.com|105.112.213.227', 'i:1;', 1740904136),
('standardvino515@gmail.com|105.112.213.227:timer', 'i:1740904136;', 1740904136),
('standardvino515@gmail.com|105.112.221.146', 'i:1;', 1740472312),
('standardvino515@gmail.com|105.112.221.146:timer', 'i:1740472312;', 1740472312),
('sternhub7@gmail.com|102.90.46.93', 'i:2;', 1740403468),
('sternhub7@gmail.com|102.90.46.93:timer', 'i:1740403468;', 1740403468),
('user|102.90.101.149', 'i:1;', 1741022073),
('user|102.90.101.149:timer', 'i:1741022073;', 1741022073),
('williamsteri2002@gmail.com|41.207.250.102', 'i:2;', 1741415578),
('williamsteri2002@gmail.com|41.207.250.102:timer', 'i:1741415578;', 1741415578);

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cards`
--

CREATE TABLE `cards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `crypto_asset_id` bigint(20) UNSIGNED NOT NULL,
  `card_number` varchar(255) NOT NULL,
  `card_holder` varchar(255) NOT NULL,
  `expiry_month` varchar(2) NOT NULL,
  `expiry_year` varchar(2) NOT NULL,
  `cvv` varchar(4) NOT NULL,
  `billing_address` text NOT NULL,
  `zip_code` varchar(255) NOT NULL,
  `status` enum('active','inactive','frozen') NOT NULL DEFAULT 'inactive',
  `balance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `card_type` enum('virtual','physical') NOT NULL DEFAULT 'virtual',
  `last_four` varchar(4) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `card_transactions`
--

CREATE TABLE `card_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `card_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `crypto_assets`
--

CREATE TABLE `crypto_assets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `btc_balance` decimal(18,4) DEFAULT 0.0000,
  `btc_status` tinyint(1) DEFAULT 1,
  `btc_address` varchar(255) DEFAULT NULL,
  `usdt_trc20_balance` decimal(18,4) DEFAULT 0.0000,
  `usdt_trc20_status` tinyint(1) DEFAULT 1,
  `usdt_trc20_address` varchar(255) DEFAULT NULL,
  `usdt_erc20_balance` decimal(18,4) DEFAULT 0.0000,
  `usdt_erc20_status` tinyint(1) DEFAULT 1,
  `usdt_erc20_address` varchar(255) DEFAULT NULL,
  `eth_balance` decimal(18,4) DEFAULT 0.0000,
  `eth_status` tinyint(1) DEFAULT 1,
  `eth_address` varchar(255) DEFAULT NULL,
  `trx_balance` decimal(18,4) DEFAULT 0.0000,
  `trx_status` tinyint(1) DEFAULT 1,
  `trx_address` varchar(255) DEFAULT NULL,
  `usdt_bep20_balance` decimal(18,4) DEFAULT 0.0000,
  `usdt_bep20_status` tinyint(1) DEFAULT 1,
  `usdt_bep20_address` varchar(255) DEFAULT NULL,
  `bch_balance` decimal(18,4) DEFAULT 0.0000,
  `bch_status` tinyint(1) DEFAULT 1,
  `bch_address` varchar(255) DEFAULT NULL,
  `ltc_balance` decimal(18,4) DEFAULT 0.0000,
  `ltc_status` tinyint(1) DEFAULT 1,
  `ltc_address` varchar(255) DEFAULT NULL,
  `xlm_balance` decimal(18,4) DEFAULT 0.0000,
  `xlm_status` tinyint(1) DEFAULT 1,
  `xlm_address` varchar(255) DEFAULT NULL,
  `dash_balance` decimal(18,4) DEFAULT 0.0000,
  `dash_status` tinyint(1) DEFAULT 1,
  `dash_address` varchar(255) DEFAULT NULL,
  `sol_balance` decimal(18,4) DEFAULT 0.0000,
  `sol_status` tinyint(1) DEFAULT 1,
  `sol_address` varchar(255) DEFAULT NULL,
  `bnb_balance` decimal(18,4) DEFAULT 0.0000,
  `bnb_status` tinyint(1) DEFAULT 1,
  `bnb_address` varchar(255) DEFAULT NULL,
  `dot_balance` decimal(18,4) DEFAULT 0.0000,
  `dot_status` tinyint(1) DEFAULT 1,
  `dot_address` varchar(255) DEFAULT NULL,
  `btc_fee` decimal(10,4) DEFAULT 0.0000,
  `usdt_trc20_fee` decimal(10,4) DEFAULT 0.0000,
  `usdt_erc20_fee` decimal(10,4) DEFAULT 0.0000,
  `eth_fee` decimal(10,4) DEFAULT 0.0000,
  `trx_fee` decimal(10,4) DEFAULT 0.0000,
  `usdt_bep20_fee` decimal(10,4) DEFAULT 0.0000,
  `bch_fee` decimal(10,4) DEFAULT 0.0000,
  `ltc_fee` decimal(10,4) DEFAULT 0.0000,
  `xlm_fee` decimal(10,4) DEFAULT 0.0000,
  `dash_fee` decimal(10,4) DEFAULT 0.0000,
  `sol_fee` decimal(10,4) DEFAULT 0.0000,
  `bnb_fee` decimal(10,4) DEFAULT 0.0000,
  `dot_fee` decimal(10,4) DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crypto_assets`
--

INSERT INTO `crypto_assets` (`id`, `user_id`, `btc_balance`, `btc_status`, `btc_address`, `usdt_trc20_balance`, `usdt_trc20_status`, `usdt_trc20_address`, `usdt_erc20_balance`, `usdt_erc20_status`, `usdt_erc20_address`, `eth_balance`, `eth_status`, `eth_address`, `trx_balance`, `trx_status`, `trx_address`, `usdt_bep20_balance`, `usdt_bep20_status`, `usdt_bep20_address`, `bch_balance`, `bch_status`, `bch_address`, `ltc_balance`, `ltc_status`, `ltc_address`, `xlm_balance`, `xlm_status`, `xlm_address`, `dash_balance`, `dash_status`, `dash_address`, `sol_balance`, `sol_status`, `sol_address`, `bnb_balance`, `bnb_status`, `bnb_address`, `dot_balance`, `dot_status`, `dot_address`, `btc_fee`, `usdt_trc20_fee`, `usdt_erc20_fee`, `eth_fee`, `trx_fee`, `usdt_bep20_fee`, `bch_fee`, `ltc_fee`, `xlm_fee`, `dash_fee`, `sol_fee`, `bnb_fee`, `dot_fee`, `created_at`, `updated_at`) VALUES
(19, 8, 0.3281, 1, 'bcce8b2f3dd5b1e0089fff82b83bf06f6882db3e0f', 13600.0000, 1, 'Taef0196eb8712efced75024ef79657d3dfcd3751', 494.7864, 1, '0xe9792622d052665245e62815e4ac78b3711d6fd0', 0.2404, 1, '0x6705c63595946b18939aea9807f189cea2e62d41', 50.0000, 1, 'Teda40bcf195065c320f03f4e66edd1e868b4733d', 0.0000, 1, '0x389316e2b36830cfc2968b65e43b884cc28f4a05', 0.0000, 1, '113a5f40eec1194a52da849d7829fdd0a68ea7f49', 0.0000, 1, 'L4373a23b7ccbfac653c4d052ed7619f7bf2aa351', 0.0000, 1, 'G33f4d4ae79b426a7e2c94b0d5ff136db98a8a9a1719ac48cef9aa7f5', 0.0000, 1, 'Xc514ed992f9b03578915087b09c75d68ac', 0.0000, 1, 'Sob64651b31a17538edb995f39cde7b8e64cf9d963e9d8', 0.0000, 1, 'bnb62b04922d14e5d579fd9b0f00145ebe1e117bb', 0.0000, 1, '57e68b37a512e6b0eb81aedcf9ff5382389318d69a0a8f196', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2024-12-16 23:52:55', '2025-02-13 15:57:27'),
(36, 23, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 2817.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 5500.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 1000.0000, 1000.0000, 4000.0000, 500.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-24 20:18:07', '2025-03-08 09:31:04'),
(37, 24, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 50000.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-25 07:39:16', '2025-03-02 01:19:12'),
(38, 25, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 49799.9850, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-25 07:42:09', '2025-03-02 01:15:36'),
(39, 26, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-25 18:28:29', '2025-02-25 18:28:29'),
(40, 27, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-25 18:34:09', '2025-02-25 18:34:09'),
(41, 28, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-27 13:27:47', '2025-02-27 13:27:47'),
(42, 29, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-02-28 09:09:31', '2025-02-28 09:09:31'),
(43, 30, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 5000000.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0490, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 1.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-01 17:19:04', '2025-03-14 20:17:18'),
(44, 31, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 1000000.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 700.0000, 1.0000, 1000.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 08:42:58', '2025-03-05 10:45:46'),
(45, 32, 0.0000, 1, 'bc1q3fgreset8pn40t0x9avgws4tkeefhr4kuh5yhq', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 09:32:16', '2025-03-02 09:32:16'),
(46, 33, 100000.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 200000000.0000, 1, '0x341EF3C7B21483C5AAF99926C3A00b8a642e28B5', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 17:22:32', '2025-03-02 17:39:51'),
(48, 35, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 21:07:27', '2025-03-02 21:07:27'),
(49, 36, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 50000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.5000, 0.5000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 21:09:58', '2025-03-02 21:16:29'),
(50, 37, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 10000.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 4977000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 1.2616, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 600.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 23:01:48', '2025-03-06 22:29:11'),
(51, 38, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 23:21:34', '2025-03-02 23:21:34'),
(52, 39, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-02 23:27:33', '2025-03-02 23:27:33'),
(53, 40, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 5000000.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 500.0000, 0.0000, 0.0000, 500.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 03:10:42', '2025-03-03 07:39:55'),
(57, 44, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 08:30:29', '2025-03-03 08:30:29'),
(58, 45, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 08:53:49', '2025-03-03 08:53:49'),
(59, 46, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 5000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 600.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 15:43:48', '2025-03-03 15:55:13'),
(60, 47, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 16:15:55', '2025-03-03 16:15:55'),
(61, 48, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 17:05:37', '2025-03-03 17:05:37'),
(62, 49, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 17:07:55', '2025-03-03 17:07:55'),
(63, 50, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-03 19:56:08', '2025-03-03 20:01:49'),
(64, 51, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-04 07:02:51', '2025-03-04 07:02:51'),
(65, 52, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-04 09:22:55', '2025-03-04 09:22:55'),
(66, 53, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-04 14:36:10', '2025-03-04 14:36:10'),
(67, 54, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 10:54:14', '2025-03-05 10:54:14'),
(68, 55, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', -600.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 2812500.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 988.3203, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 10.3155, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 500.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 17:23:17', '2025-03-14 20:17:14'),
(69, 56, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 17:52:03', '2025-03-05 17:52:03'),
(70, 57, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 17:53:15', '2025-03-05 17:53:15'),
(71, 58, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 19:27:44', '2025-03-05 19:27:44'),
(72, 59, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 21:14:12', '2025-03-05 21:14:12'),
(73, 60, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-05 22:33:31', '2025-03-05 22:33:31'),
(74, 61, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', -10000.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 5000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 500.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-06 07:02:49', '2025-03-14 20:17:09'),
(75, 62, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-06 22:23:27', '2025-03-14 20:16:55'),
(76, 63, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-06 22:52:07', '2025-03-06 22:52:07'),
(77, 64, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 5000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 500.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-07 05:24:59', '2025-03-14 20:14:53'),
(78, 65, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-07 09:17:44', '2025-03-07 09:17:44'),
(79, 66, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-07 13:23:32', '2025-03-07 13:23:32'),
(80, 67, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 5000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 500.0000, 0.2000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-07 14:33:31', '2025-03-07 15:20:59'),
(82, 69, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-07 17:08:04', '2025-03-07 17:08:04'),
(83, 70, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-08 00:55:31', '2025-03-08 00:55:31'),
(84, 71, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-08 06:25:29', '2025-03-08 06:25:29'),
(85, 72, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-08 06:40:18', '2025-03-08 06:40:18'),
(86, 73, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-08 09:35:03', '2025-03-08 09:35:03'),
(87, 74, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 5000000.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 500.0000, 0.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-08 16:31:51', '2025-03-08 18:03:32'),
(88, 75, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-09 08:49:36', '2025-03-09 08:49:36'),
(89, 76, 0.0000, 1, '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 0.0000, 1, '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 0.0000, 1, 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 0.0000, 1, '0x60da516264775f8421812bcfecbc60cbce84c569', 0.0000, 1, 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 0.0000, 1, 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 0.0000, 1, 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 0.0000, 1, 'Not available', 0.0000, 1, '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 0.0000, 1, '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 0.0000, 1, 'Not available', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, '2025-03-09 08:53:21', '2025-03-09 08:53:21');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_12_07_080343_add_passcode_to_users_table', 1),
(6, '2024_12_14_150621_create_card', 2),
(7, '2024_12_14_153904_card_transactions', 3),
(8, '2024_12_14_171924_transactions', 4),
(9, '2024_12_15_150052_create_notifications_table', 5);

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

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

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `notifications` (`id`, `user_id`, `type`, `title`, `message`, `is_read`, `extra_data`, `created_at`, `updated_at`) VALUES
(17, 1, 'send_crypto', 'Pending Transaction', 'Incoming deposit of 1000.00000000 usdt_bep20 is pending.', 0, '{\"transaction_hash\":null,\"status\":\"pending\"}', '2024-12-17 04:28:14', '2024-12-17 04:28:14'),
(18, 1, 'send_crypto', 'Pending Transaction', 'Incoming deposit of 0.48500000 eth is pending.', 0, '{\"transaction_hash\":null,\"status\":\"pending\"}', '2024-12-17 04:33:59', '2024-12-17 04:33:59'),
(24, 8, 'kyc_upload', 'KYC Documents Uploaded', 'Your KYC documents have been submitted for verification.', 0, '\"{\\\"documents_uploaded\\\":[\\\"front_id\\\",\\\"back_id\\\",\\\"proof_of_residence\\\"],\\\"upload_timestamp\\\":\\\"2025-01-22 19:08:34\\\"}\"', '2025-01-22 18:08:34', '2025-01-22 18:08:34'),
(25, 8, 'kyc', 'KYC Approved', 'Your KYC verification has been approved.', 1, NULL, '2025-01-22 18:21:02', '2025-01-24 13:59:44'),
(26, 8, 'crypto_swap', 'Crypto Swap', 'Swapped 0.0040 BTC to 423.6376 USDT_ERC20', 0, '\"{\\\"transaction_id\\\":52,\\\"from_crypto\\\":\\\"btc\\\",\\\"to_crypto\\\":\\\"usdt_erc20\\\",\\\"from_amount\\\":0.004,\\\"to_amount\\\":423.63759999999996,\\\"usd_value\\\":423.63759999999996}\"', '2025-01-24 14:02:24', '2025-01-24 14:02:24'),
(27, 8, 'crypto_swap', 'Crypto Swap', 'Swapped 0.0033 BTC to 0.1039 ETH', 0, '\"{\\\"transaction_id\\\":53,\\\"from_crypto\\\":\\\"btc\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":0.0033,\\\"to_amount\\\":0.1039051018055859,\\\"usd_value\\\":347.06278199999997}\"', '2025-01-26 19:32:29', '2025-01-26 19:32:29'),
(28, 8, 'referral_bonus', 'Referral Bonus Received', 'You have received a referral bonus of $50.00 USDT for referring john von', 0, '\"{\\\"amount\\\":\\\"50.00\\\",\\\"referred_user\\\":\\\"john von\\\"}\"', '2025-02-13 15:40:38', '2025-02-13 15:40:38'),
(29, 8, 'referral_bonus', 'Referral Bonus Received', 'You have received a referral bonus of $50.00 USDT for referring john pen', 0, '\"{\\\"amount\\\":\\\"50.00\\\",\\\"referred_user\\\":\\\"john pen\\\"}\"', '2025-02-13 15:57:27', '2025-02-13 15:57:27'),
(39, 25, 'external_transfer', 'External Crypto Transfer', 'Sent 200,000.0000 USDT_ERC20 to external address 0x1fB1...6325', 0, '\"{\\\"transaction_id\\\":57,\\\"crypto\\\":\\\"usdt_erc20\\\",\\\"amount\\\":\\\"200000\\\",\\\"network\\\":\\\"ERC20\\\",\\\"full_address\\\":\\\"0x1fB18D6e42ff37DdB0aF3978a7E4620267346325\\\",\\\"transaction_hash\\\":\\\"47bc8fcb86fcc17e05b0b8b9a70de7dc3eabf89833f244299e5f1276fd6382fa\\\",\\\"network_fee\\\":0.005000000000000000104083408558608425664715468883514404296875}\"', '2025-02-25 08:00:20', '2025-02-25 08:00:20'),
(40, 25, 'external_transfer', 'External Crypto Transfer', 'Sent 200,000.0000 USDT_ERC20 to external address 0x1fB1...6325', 0, '\"{\\\"transaction_id\\\":58,\\\"crypto\\\":\\\"usdt_erc20\\\",\\\"amount\\\":\\\"200000\\\",\\\"network\\\":\\\"ERC20\\\",\\\"full_address\\\":\\\"0x1fB18D6e42ff37DdB0aF3978a7E4620267346325\\\",\\\"transaction_hash\\\":\\\"ea102f531c0e4b5c32279724087ea9a85c5acbe6171b2d665a718c4181c58753\\\",\\\"network_fee\\\":0.005000000000000000104083408558608425664715468883514404296875}\"', '2025-02-25 08:02:55', '2025-02-25 08:02:55'),
(41, 25, 'external_transfer', 'External Crypto Transfer', 'Sent 200.0000 USDT_ERC20 to external address 0x1fB1...6325', 0, '\"{\\\"transaction_id\\\":59,\\\"crypto\\\":\\\"usdt_erc20\\\",\\\"amount\\\":\\\"200\\\",\\\"network\\\":\\\"ERC20\\\",\\\"full_address\\\":\\\"0x1fB18D6e42ff37DdB0aF3978a7E4620267346325\\\",\\\"transaction_hash\\\":\\\"0fa9ad3d4db40ca82aecd504e92d7daba7e772bd7afdcaad40a61fa402ddc1bb\\\",\\\"network_fee\\\":0.005000000000000000104083408558608425664715468883514404296875}\"', '2025-02-25 08:11:01', '2025-02-25 08:11:01'),
(42, 23, 'external_transfer', 'External Crypto Transfer', 'Sent 0.0049 BTC to external address bc1qp5...zl42', 1, '\"{\\\"transaction_id\\\":60,\\\"crypto\\\":\\\"btc\\\",\\\"amount\\\":\\\"0.00490000\\\",\\\"network\\\":\\\"native\\\",\\\"full_address\\\":\\\"bc1qp5gc5k9xluex6a06ed0d4gqks8aj4lt2c7zl42\\\",\\\"transaction_hash\\\":\\\"49a6992086bf707cb900fc5542b380023d991a5db27e388087efd784649511c5\\\",\\\"network_fee\\\":0.0005000000000000000104083408558608425664715468883514404296875}\"', '2025-02-25 09:39:06', '2025-03-02 10:40:06'),
(46, 23, 'external_transfer', 'External Crypto Transfer', 'Sent 100.0000 USDT_TRC20 to external address TGyAqw...uDQw', 1, '\"{\\\"transaction_id\\\":64,\\\"crypto\\\":\\\"usdt_trc20\\\",\\\"amount\\\":\\\"100\\\",\\\"network\\\":\\\"TRC20\\\",\\\"full_address\\\":\\\"TGyAqwauyRC4CnWhn2KonnqfG7GEcduDQw\\\",\\\"transaction_hash\\\":\\\"50f571153d407b30e9b6eed943b428d80e5ab6aa530e9adff0d153a5ea28c746\\\",\\\"network_fee\\\":\\\"10.0000\\\"}\"', '2025-03-01 17:03:08', '2025-03-02 10:40:06'),
(53, 31, 'send_crypto', 'Pending Transaction', 'Incoming deposit of 500000.00000000 usdt_erc20 is pending.', 0, '{\"transaction_hash\":null,\"status\":\"pending\"}', '2025-03-02 08:53:06', '2025-03-02 08:53:06'),
(54, 31, 'send_crypto', 'Completed Transaction', 'Deposit of 500000.00000000 usdt_erc20 has been completed.', 0, '{\"transaction_hash\":null,\"status\":\"completed\"}', '2025-03-02 08:53:41', '2025-03-02 08:53:41'),
(55, 37, 'crypto_swap', 'Crypto Swap', 'Swapped 3,000.0000 USDT_ERC20 to 1.2616 ETH', 1, '\"{\\\"transaction_id\\\":73,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":3000,\\\"to_amount\\\":1.2616386162347656973992116036242805421352386474609375,\\\"usd_value\\\":3000}\"', '2025-03-03 06:23:21', '2025-03-06 22:37:29'),
(56, 37, 'crypto_swap', 'Crypto Swap', 'Swapped 20,000.0000 USDT_ERC20 to 20,000.0000 USDT_TRC20', 1, '\"{\\\"transaction_id\\\":74,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"usdt_trc20\\\",\\\"from_amount\\\":20000,\\\"to_amount\\\":20000,\\\"usd_value\\\":20000}\"', '2025-03-03 10:39:38', '2025-03-06 22:37:29'),
(57, 55, 'crypto_swap', 'Crypto Swap', 'Swapped 1,250,000.0000 USDT_ERC20 to 568.4480 ETH', 1, '\"{\\\"transaction_id\\\":75,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":1250000,\\\"to_amount\\\":568.447955179015707471990026533603668212890625,\\\"usd_value\\\":1250000}\"', '2025-03-05 17:54:42', '2025-03-05 20:31:20'),
(58, 55, 'crypto_swap', 'Crypto Swap', 'Swapped 937,500.0000 USDT_ERC20 to 422.6457 ETH', 1, '\"{\\\"transaction_id\\\":76,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":937500,\\\"to_amount\\\":422.64569442378177654973114840686321258544921875,\\\"usd_value\\\":937500}\"', '2025-03-05 18:13:31', '2025-03-05 20:31:20'),
(59, 55, 'crypto_swap', 'Crypto Swap', 'Swapped 2.7734 ETH to 10.3154 BNB', 1, '\"{\\\"transaction_id\\\":77,\\\"from_crypto\\\":\\\"eth\\\",\\\"to_crypto\\\":\\\"bnb\\\",\\\"from_amount\\\":2.773424999999969831065982361906208097934722900390625,\\\"to_amount\\\":10.3153906257343965791051232372410595417022705078125,\\\"usd_value\\\":6144.2180107499325458775274455547332763671875}\"', '2025-03-05 18:27:36', '2025-03-05 20:31:20'),
(60, 30, 'crypto_swap', 'Crypto Swap', 'Swapped 200,000.0000 USDT_ERC20 to 90.5174 ETH', 1, '\"{\\\"transaction_id\\\":78,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":200000,\\\"to_amount\\\":90.517397443788695454713888466358184814453125,\\\"usd_value\\\":200000}\"', '2025-03-05 18:38:33', '2025-03-07 05:23:54'),
(61, 55, 'crypto_swap', 'Crypto Swap', 'Swapped 7.0801 ETH to 15,786.7972 USDT_TRC20', 1, '\"{\\\"transaction_id\\\":79,\\\"from_crypto\\\":\\\"eth\\\",\\\"to_crypto\\\":\\\"usdt_trc20\\\",\\\"from_amount\\\":7.08007499999999989626076057902537286281585693359375,\\\"to_amount\\\":15786.797231250000550062395632266998291015625,\\\"usd_value\\\":15786.797231250000550062395632266998291015625}\"', '2025-03-05 19:52:14', '2025-03-05 20:31:20'),
(62, 61, 'crypto_swap', 'Crypto Swap', 'Swapped 20,000.0000 USDT_ERC20 to 20,000.0000 USDT_TRC20', 0, '\"{\\\"transaction_id\\\":80,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"usdt_trc20\\\",\\\"from_amount\\\":20000,\\\"to_amount\\\":20000,\\\"usd_value\\\":20000}\"', '2025-03-06 18:26:02', '2025-03-06 18:26:02'),
(63, 61, 'crypto_swap', 'Crypto Swap', 'Swapped 4,980,000.0000 USDT_ERC20 to 56.2196 BTC', 0, '\"{\\\"transaction_id\\\":81,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"btc\\\",\\\"from_amount\\\":4980000,\\\"to_amount\\\":56.2196041597991467142492183484137058258056640625,\\\"usd_value\\\":4980000}\"', '2025-03-06 18:45:54', '2025-03-06 18:45:54'),
(64, 55, 'crypto_swap', 'Crypto Swap', 'Swapped 2.5789 BNB to 0.0172 BTC', 0, '\"{\\\"transaction_id\\\":82,\\\"from_crypto\\\":\\\"bnb\\\",\\\"to_crypto\\\":\\\"btc\\\",\\\"from_amount\\\":2.57885000000000008668621376273222267627716064453125,\\\"to_amount\\\":0.0172291064362080394156695462015704833902418613433837890625,\\\"usd_value\\\":1533.6781989000000976375304162502288818359375}\"', '2025-03-06 19:13:25', '2025-03-06 19:13:25'),
(65, 37, 'send_crypto', 'Crypto Sent', 'You sent 10,000.0000 USDT_TRC20 to Moumen', 1, '\"{\\\"transaction_id\\\":83,\\\"amount\\\":\\\"10000\\\",\\\"crypto\\\":\\\"usdt_trc20\\\",\\\"recipient_id\\\":62}\"', '2025-03-06 22:29:11', '2025-03-06 22:37:29'),
(66, 62, 'receive_crypto', 'Crypto Received', 'You received 10,000.0000 USDT_TRC20 from Ammar', 1, '\"{\\\"transaction_id\\\":84,\\\"amount\\\":\\\"10000\\\",\\\"crypto\\\":\\\"usdt_trc20\\\",\\\"sender_id\\\":37}\"', '2025-03-06 22:29:11', '2025-03-06 22:42:02'),
(70, 64, 'crypto_swap', 'Crypto Swap', 'Swapped 1,249,288.0615 USDT_ERC20 to 570.3444 ETH', 0, '\"{\\\"transaction_id\\\":88,\\\"from_crypto\\\":\\\"usdt_erc20\\\",\\\"to_crypto\\\":\\\"eth\\\",\\\"from_amount\\\":1249288.06152500002644956111907958984375,\\\"to_amount\\\":570.3443928419793564899009652435779571533203125,\\\"usd_value\\\":1249288.06152500002644956111907958984375}\"', '2025-03-07 07:15:48', '2025-03-07 07:15:48'),
(71, 64, 'crypto_swap', 'Crypto Swap', 'Swapped 570.3444 ETH to 1,245,238.6320 USDT_ERC20', 0, '\"{\\\"transaction_id\\\":89,\\\"from_crypto\\\":\\\"eth\\\",\\\"to_crypto\\\":\\\"usdt_erc20\\\",\\\"from_amount\\\":570.344399999999950523488223552703857421875,\\\"to_amount\\\":1245238.63196399994194507598876953125,\\\"usd_value\\\":1245238.63196399994194507598876953125}\"', '2025-03-07 07:26:34', '2025-03-07 07:26:34'),
(72, 23, 'card_funding', 'Card Funded', 'You funded your card with 500.00 USD using USDT TRC20', 0, '\"{\\\"transaction_id\\\":90,\\\"card_transaction_id\\\":12,\\\"amount\\\":\\\"500\\\",\\\"crypto\\\":\\\"usdt_trc20\\\",\\\"crypto_amount\\\":500}\"', '2025-03-08 09:31:04', '2025-03-08 09:31:04');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('1LkSDdq2JmxvA4l5tI46iI6vMaatgMaTyr2j4YJl', 23, '102.90.101.36', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoic3BTVVlUVzlPaE9YQlY3bjg1OEFRTEkxTk5XaDB5OFBwVW9jNE1JRiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20vbm90aWZpY2F0aW9ucy91bnJlYWQtY291bnQiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyMztzOjE3OiJwYXNzY29kZV92ZXJpZmllZCI7YjoxO3M6MjA6InBhc3Njb2RlX3ZlcmlmaWVkX2F0IjtPOjI1OiJJbGx1bWluYXRlXFN1cHBvcnRcQ2FyYm9uIjozOntzOjQ6ImRhdGUiO3M6MjY6IjIwMjUtMDMtMTQgMjE6MTM6MjIuODA2ODQ0IjtzOjEzOiJ0aW1lem9uZV90eXBlIjtpOjM7czo4OiJ0aW1lem9uZSI7czozOiJVVEMiO319', 1741986802),
('1mJiqCxOnY7ksor0V3S4KKzYpFP6NW1WEHdagGuW', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRWtMaDU5czM3Y1M3UldFOHZqUk93NkdkVXNFeUQzQlphWk1kd3dadiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMjEzOTI5NDc3MC5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986179),
('5gsYenWChbkhc3scTSx889Zy1FbEvEPVXuNBBPMD', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQnNjVFJ3SkpTWnN6Rml2RkcwY3Vyd1d2bWpkWHlDVHJWTGgyUG5IaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('5sWOqdHTtqKby1lM4NkhCSrvVVHHd4oP4g2Vlk8I', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicWNkREt5UzZUUVVmYndEbk9UQXlhNlZ1QVF4ZDQ4UnZucHJSVE9ycCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMjEzOTIxMDQ0ODMuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986796),
('5Ykrbd8Lzo4kFYoXds1CfoD2xxzYD2tJ9TnHaiVa', 1, '102.90.101.36', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTlphWFRqajVEbGo4QzRhT0U5Ym05YlRRMVJRRDdvRDRDTmgzT2hPcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20vYWRtaW4vdHJhbnNhY3Rpb25zIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1741987039),
('7cOuTSY1ohKsmqPkfy4YPBeCGfwbCnRGT1vDTLi1', NULL, '66.249.79.201', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSDhnd1ZNcHNPRFJ0Y050QjUyN0FDdDJvd0IzYjB0Wkd2amEzekZ1eCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGODYwMDkxMDQzNzIuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986479),
('8HASGuRoMg3rXvXsn5x3t8NVfiKia1uKhxv2XE85', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUF3RWVxSzNLUzR3cGIzdHc5cWswU0VYZUlpM2hsbnVTM0o2S1lYSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDQ1MzI0NjkxOC5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741987018),
('9nMB4MmMt1CSYETSgNSJQ34zU2CqsQ3PgvGbNGMi', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVEplV2JyZ01rRmR6amJEQlh6OHVkWkh0NVd6QnI5Q081UXNqVmtXcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMzI0OTAxMDAzOTYuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986288),
('AWjWqssJHAcs3wjQg28FyaD9jlePBa5dDL0ysh6I', NULL, '66.249.76.135', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaTdZWDBxWmNmaUFIZTFqUGpyNnZXZDdpUWdnUWNmRldlSVpSdmZ3YSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDA0MDIzMjg5NC5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741985724),
('BRpyTrXnOENyCJ4MSWX5os8bZyymuW0yuZyB32Ql', NULL, '185.117.225.104', 'Mozilla/5.0 (compatible; BitSightBot/1.0)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRDE5MlphZHVGQXhIQjQ2WUUwWlNWQk10MkZ6YmplNkFVZnVEYUJxdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986822),
('eIX7fL4uoC2QlbRpqvpknAETcqEBcaYgZue94JjW', NULL, '43.153.76.247', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDkxRGpnM29uaEw5MHFKRkVTdjRndjNPeUIzdHhzM1I0V2V0Ukh3dyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vd3d3LmV4dHJhZGVybWluZXIuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986881),
('fwxLGnswaZraYXtz7hC0ZbYKTQFzjfAEVZqXMGbW', 1, '102.90.101.36', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoicXZ1eVhwTnFlZ2hJV1d3bXhqQnZMdHJET28zVE9ESU02VTRHTDlFYSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1MDoiaHR0cHM6Ly9leHRyYWRlcm1pbmVyLmNvbS9zZW5kL2V4dGVybmFsL3VzZHQvVFJDMjAiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0MToiaHR0cHM6Ly9leHRyYWRlcm1pbmVyLmNvbS9hZG1pbi9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1741987363),
('G23DTYRtMmV22Dok9yj8HYM3YoIaePN69YOyfwzU', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicUNBcmJFSUlwNzJNUlhmRnllUHJKblU1Vlh3d3BXMG1WQnptZ2J4VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('HFnheHx7xVSbbgB9BT97hC5RoyP0rAU8473LY77d', NULL, '45.130.136.155', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHh6M3oxN2x2UXBqSGNaa1lFcTgyMk9VT05Sa3N3czJZTWxIYll2eCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741987150),
('hXPpoacbiEHFqwoehNoJ9XiRsVNtx810BvGWkbn3', NULL, '66.249.79.200', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDF2eEx5YkI5cVVzdzJVTHRFVHJubGo2ejR1aU1odlRaMTBKVmdxViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNTAwNjk0NDU5Ni5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741987207),
('IZSdS0w2lxsscA5fyKNa7CpslLfzB4S1dDWdlXEW', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNjBweEx4eTc3T01TM056NjRzRHQxT1AxdE0xajZNTTl4ZFdkTkIxcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA3OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNTAwNjk4ODA0Lmh0bSZfYmRzaWQ9MnVsdklKLm5+WlhDSVcuMTcyMTg4NjY1NjA3MC4xNzIxODg2ODQ4Jl9nYT0yLjE5ODA0MDA0Ny4xOTU4ODA4NzQ4LjE3MjE4ODY2NTQtODYyMzk4MzA3LjE2OTk0NTM1NzgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986510),
('jpcTqS0GjMpSNiMYbJyp4LFYYR93vy337YCP5iO7', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSUJOdTZGS0c4dEdFVGt1RUpJcHJtZGpxbldPbHFuQzU2R0NRcmRLMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA3OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMzI0OTAyNjY1Lmh0bSZfYmRzaWQ9MnVsdklKLm5+WlhDSVcuMTcyMTg4NjY1NjA3MC4xNzIxODg2ODQ4Jl9nYT0yLjE5ODA0MDA0Ny4xOTU4ODA4NzQ4LjE3MjE4ODY2NTQtODYyMzk4MzA3LjE2OTk0NTM1NzgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741987313),
('l5jepjw96Tv4aaHfFhZ27yva40euGv35YXA0NQNH', NULL, '66.249.76.136', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSTFRNHZzNG9TSlQ4RDY5eXZxOXpUOE15VEMybnpVSWNwd3BCdTZqaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDQ1MzIzNTEyMC5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741987172),
('Mo70jPwVCfCjpcPhfwJmlFpIn2jCldI1Okshg1US', NULL, '66.249.76.135', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmVibENjVFNFamZDTjhOakJmb0hiRkZQSWxUck1ZeW1Cc21YSTZGUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDA3MjYxMTk1MzUuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741987211),
('MTGCKWtsLdm2dNzvttGJkuuQTAJx4gvjm2kt7YtV', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaG9jQXZWQ0lkaENmZnJ6VUtBOUgyQzRUMzN2dGJlVW9QMTNuTE9reCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA3OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGOTc3NTc3NzUwLmh0bSZfYmRzaWQ9MnVsdklKLm5+WlhDSVcuMTcyMTg4NjY1NjA3MC4xNzIxODg2ODQ4Jl9nYT0yLjE5ODA0MDA0Ny4xOTU4ODA4NzQ4LjE3MjE4ODY2NTQtODYyMzk4MzA3LjE2OTk0NTM1NzgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986786),
('ox8uAIUr1Jn0s60YaOyXBmCG8RC79tb2jW6U6Ffd', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUlpBTWcxS29ObzJNZ25PRVhlRlN4dVNzc3RQRTA5bFd6RWJPTlZBZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNjE3MjM2MDAzNS5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986865),
('Py3JnCyglxOsp1Nypvq3symzwoebkiLTx4OrB8ZN', NULL, '66.249.76.136', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMnZVTkZsUHNUNnBhMTFIbU1kclZXYXh0VkNRVGJJRTkzbjRhMHRDdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDA3MjYyMDQxNi5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986928),
('q0pGxzEiuJTysC0oHFfTWbCRVwFvKHanWqPKB6G9', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2tPdzlqZm55cW53UnVjOEQ0RHFWbDNrSW50NEVFWlFCUVVnTWYyOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('q6mYv0IMgkFApyIL5qytfOQqYy4UKG1nC4sodf5s', NULL, '66.249.79.200', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYzhyMnVsTTBMUkRHVTh0blJQVnpLUE44MTRqcVllN2R4WHJnZ0wzVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNDU4NDc3MjQ5NS5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986200),
('QlZi2l9dTXlCx2WEzTITZ3w70JkaI9GosV2iugWd', NULL, '66.249.83.3', 'Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNHAxVHIwZjZJQVV5RzlGd3NFT0hxRGdVZENETVJtbnYxR2JObW55QyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1MDoiaHR0cHM6Ly9leHRyYWRlcm1pbmVyLmNvbS9zZW5kL2V4dGVybmFsL1VTRFQvRVJDMjAiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo1MDoiaHR0cHM6Ly9leHRyYWRlcm1pbmVyLmNvbS9zZW5kL2V4dGVybmFsL1VTRFQvRVJDMjAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986672),
('quf8J8APtxVv3bSSkpH08g2WqEFjOIKJ9RTklbkt', 23, '102.89.46.201', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiQWVJN0Y1NlJWUEoybEFZOWNoUEc2MzJZQk84VWM4ZWw5dHZOVmxWTCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1MjoiaHR0cHM6Ly9leHRyYWRlcm1pbmVyLmNvbS9ub3RpZmljYXRpb25zL3VucmVhZC1jb3VudCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjUyOiJodHRwczovL2V4dHJhZGVybWluZXIuY29tL25vdGlmaWNhdGlvbnMvdW5yZWFkLWNvdW50Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjM7czoxNzoicGFzc2NvZGVfdmVyaWZpZWQiO2I6MTtzOjIwOiJwYXNzY29kZV92ZXJpZmllZF9hdCI7TzoyNToiSWxsdW1pbmF0ZVxTdXBwb3J0XENhcmJvbiI6Mzp7czo0OiJkYXRlIjtzOjI2OiIyMDI1LTAzLTE0IDIxOjE0OjE3LjU2NTA0NCI7czoxMzoidGltZXpvbmVfdHlwZSI7aTozO3M6ODoidGltZXpvbmUiO3M6MzoiVVRDIjt9fQ==', 1741986857),
('rAwoA4lQSW2hKN7LHiqwi6V0hcLLBpqDgx11MLKr', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU3AxTmZxT0JNZU5MMlI1R0dkeFdOcmZ2NHJwYnBSRHVTS1NLZGdJSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('SHmhmOYGXZ0hiRQejFiXX7VoOegfdap7VIzuchDu', NULL, '66.249.83.2', 'Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieXJtY1ZvcGwxUGliZ2I1dGVoZkxoalJPQWc4dGRxbnE2MnVuMDZIayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986673),
('tTZtlD6k05hvJ8nXLt3zlMlQntC6UiihUemga5OD', NULL, '66.249.79.200', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU3ExMjA1cGxrUW44bmZvQ21VUVdyVTlQRDRYZUVDWERyeGlGMDJoUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGODA5ODQxNzg4My5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986661),
('TzItOoiNGJhYMrsV6ecT2yzFKJ8wopffK9Zp6S2a', 1, '102.90.101.36', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.84 Mobile/15E148 Safari/604.1', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiblZ5WkR1bWU2c01uZWhrejBUMkhNSDlXMkN6T2Mwd2RSQzJwQVRoeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20vYWRtaW4vZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1741987484),
('U1bNEG37lkf9APigx7aDinbVHgbAtNoGHOOT2kGo', NULL, '66.249.79.201', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT20yYUdKaHRlMGxWMVc4aWpFMGNLVG9BTTEyTnRvTFc4YVp3aWdRayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGNjA2NDExMzY5NzQuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986550),
('unk3IOsaWZsjDuSH543LT66jBWNOJwccRQPerGXg', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUlpnTEI1OWRxY2xuZjJmUTJtVGNuTktpMnpNWnN1Ym5EbmhtWEVxRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI1OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGY2F0ZWdvcnklMkY5NzY0LTk3NzU3MDAwMDcuaHRtbCZfYmRzaWQ9MnVsdklKLm5+WlhDSVcuMTcyMTg4NjY1NjA3MC4xNzIxODg2ODQ4Jl9nYT0yLjE5ODA0MDA0Ny4xOTU4ODA4NzQ4LjE3MjE4ODY2NTQtODYyMzk4MzA3LjE2OTk0NTM1NzgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986229),
('WbKI5XuAr1PcMqYzWVzvFD4UkujiDhUi4AU9ciNA', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic3hBQlpXZmJhTnA5dVp5dU9zdG1IWVkyQzhhTjhRRDdwNkVGcDNOeCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('XaFs0ORqpwvULBuTG1R2CCekzNiRTTbxIDWGFscX', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZlFOZk1lbnFJUVRUbndEWkl3Wkx5YkpqNjhjUUVkZ1dWVGh2M1d6eSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMjI5NzMxNTI5OC5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741986489),
('XOnzdlXKjgKPss2qgimwuj4ZqLnzIMdTDpazR1UE', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiS0M3MTlnVkZWbndjNGdGeEpHc2lFaU9SMkdWWTJKcFIwRUhrOEJoaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGODYwMDkxMTUyNTQuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986255),
('Xv2ffcdB8KU1HO9tWZcYBMlRStNIlaRXpFFCOFSB', NULL, '66.249.76.136', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicUxpdW1DbFR2cGhUNVpSZ1l6dnhpVGVQN3pJZmlCeEQ3ZFp1cGpFYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA5OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMTM4NTMxMjE2MTkuaHRtJl9iZHNpZD0ydWx2SUoubn5aWENJVy4xNzIxODg2NjU2MDcwLjE3MjE4ODY4NDgmX2dhPTIuMTk4MDQwMDQ3LjE5NTg4MDg3NDguMTcyMTg4NjY1NC04NjIzOTgzMDcuMTY5OTQ1MzU3OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1741986302),
('zKHlMEL3R3zlkjAqggBWiNau7FsNpiCBXOvu2Du9', NULL, '197.210.54.62', 'WhatsApp/2.23.20.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjRQYkYzSFpZbWk2NGg1a2w5OXFFY2NxTGpJdDc0YWc1d21ndXpKViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXh0cmFkZXJtaW5lci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986994),
('ZN4KMGMZcmsqGTVUp8OWd533o2GnW4MXJRBFCrb6', NULL, '66.249.79.199', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.6943.141 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYVhPMTd3eUlzVFo5dFVWOG9Tdk9wU0Z4UmlmbXBoaTYwVXVsT1d3MSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA4OiJodHRwczovL2V4dHJhZGVybWluZXIuY29tLz9fYmRfcHJldl9wYWdlPWh0dHBzJTNBJTJGJTJGZXh0cmFkZXJtaW5lci5jb20lMkZkZXRhaWwucGhwJTNGMTM4NTM3MjQ3Ny5odG0mX2Jkc2lkPTJ1bHZJSi5uflpYQ0lXLjE3MjE4ODY2NTYwNzAuMTcyMTg4Njg0OCZfZ2E9Mi4xOTgwNDAwNDcuMTk1ODgwODc0OC4xNzIxODg2NjU0LTg2MjM5ODMwNy4xNjk5NDUzNTc4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1741987271);

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `display_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `display_name`, `description`, `is_public`, `order`, `created_at`, `updated_at`) VALUES
(1, 'site_logo', 'uploads/logos/1740425070_Blockcino-Logo-2048x410.png', 'general', 'file', 'Site Logo', NULL, 1, 0, '2024-12-15 16:50:09', '2025-02-24 18:24:30'),
(2, 'site_favicon', 'uploads/favicon/1740425070_cropped-blockcino-favi-icon-192x192.png', 'general', 'file', 'Site Favicon', NULL, 1, 0, '2024-12-15 16:50:09', '2025-02-24 18:24:30'),
(3, 'site_name', 'Extraderminer.com', 'general', 'text', 'Site Name', NULL, 1, 0, '2024-12-15 16:50:09', '2025-03-14 20:05:07'),
(4, 'company_name', 'Extraderminer.com', 'general', 'text', 'Company Name', NULL, 1, 0, '2024-12-15 16:50:09', '2025-03-14 20:05:07'),
(5, 'company_address', 'ccc', 'general', 'textarea', 'Company Address', NULL, 1, 0, '2024-12-15 16:50:09', '2025-03-14 20:05:07'),
(6, 'company_phone', '+18272002982', 'general', 'text', 'Company Phone', NULL, 1, 0, '2024-12-15 16:50:09', '2025-03-14 20:05:07'),
(7, 'company_email', 'support@extraderminer.com', 'general', 'email', 'Company Email', NULL, 1, 0, '2024-12-15 16:50:09', '2025-03-14 20:05:07'),
(8, 'email_header_logo', 'uploads/email/1740431992_Blockcino-Logo2-2048x410.png', 'email', 'file', 'Email Header Logo', NULL, 1, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(9, 'mail_mailer', 'smtp', 'email', 'text', 'Mail Mailer', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(10, 'mail_host', 'smpt.info@blockcino.online', 'email', 'text', 'Mail Host', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(11, 'mail_port', '465', 'email', 'text', 'Mail Port', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(12, 'mail_username', 'info@blockcino.online', 'email', 'text', 'Mail Username', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(13, 'mail_encryption', 'tls', 'email', 'text', 'Mail Encryption', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(14, 'mail_from_address', 'info@blockcino.online', 'email', 'email', 'Mail From Address', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(15, 'mail_from_name', 'Blockcino', 'email', 'text', 'Mail From Name', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(16, 'mail_password', 'DD&N,$)uL4DGEC', 'email', 'password', 'Mail Password', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(17, 'notify_admin_on_user_register', '1', 'notifications', 'boolean', 'Notify Admin On User Register', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(18, 'notify_admin_on_kyc_submission', '1', 'notifications', 'boolean', 'Notify Admin On Kyc Submission', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(19, 'notify_user_on_kyc_approval', '1', 'notifications', 'boolean', 'Notify User On Kyc Approval', NULL, 0, 0, '2024-12-17 11:18:41', '2025-02-24 20:19:52'),
(20, 'referral_enabled', '1', 'referral', 'boolean', 'Enable Referral System', NULL, 1, 0, '2025-02-13 10:22:53', '2025-03-14 20:05:07'),
(21, 'referral_bonus_amount', '5.00', 'referral', 'number', 'Referral Bonus Amount', NULL, 1, 0, '2025-02-13 10:22:53', '2025-03-14 20:05:07'),
(22, 'referral_bonus_type', 'instant', 'referral', 'select', 'Referral Bonus Distribution Type', NULL, 1, 0, '2025-02-13 10:22:53', '2025-03-14 20:05:07'),
(23, 'btc_address', '3LWJAwehZuEt7HsbHxrcqkaqzjYwQTpeLw', 'wallets', 'text', 'Btc address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(24, 'eth_address', '0x68d7201772AF8D321BfA85f2Cf9B8948942d3FEb', 'wallets', 'text', 'Eth address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(25, 'usdt_trc20_address', 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 'wallets', 'text', 'Usdt trc20 address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(26, 'usdt_erc20_address', '0xD926f36c6C3a93F969381D2a82f86b67336327C3', 'wallets', 'text', 'Usdt erc20 address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(27, 'usdt_bep20_address', '0x60da516264775f8421812bcfecbc60cbce84c569', 'wallets', 'text', 'Usdt bep20 address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(28, 'trx_address', 'TVTzJdCeaisK4tG5WuS4ipJsj65Duqm5FN', 'wallets', 'text', 'Trx address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(29, 'bch_address', 'qqjg5h4ex27fhk4cr5zunf359k9rcwxa257lyzazec', 'wallets', 'text', 'Bch address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(30, 'ltc_address', 'MAtiKarYDX1RsSMPwERhsE4dGgVznMQC4t', 'wallets', 'text', 'Ltc address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(31, 'xlm_address', 'GA53MFBYT4BZBRY47GN2345AXZXRFWNJX6HTGN7WYT2BMFA6BAJSZ2K7', 'wallets', 'text', 'Xlm address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(32, 'dash_address', 'Not available', 'wallets', 'text', 'Dash address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(33, 'sol_address', '5oQB4FDz2q9bWbw6vQbCCGcp6d5CbFqi2UNqQYfeuXyx', 'wallets', 'text', 'Sol address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(34, 'bnb_address', '0x6536b8d869826E66eFC5e7dbD4D04b337A6dCA7C', 'wallets', 'text', 'Bnb address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31'),
(35, 'dot_address', 'Not available', 'wallets', 'text', 'Dot address', NULL, 0, 0, '2025-02-13 14:13:24', '2025-03-04 15:34:31');

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

--
-- Table structure for table `subscription_profits`
--

CREATE TABLE `subscription_profits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bot_subscription_id` bigint(20) UNSIGNED NOT NULL,
  `bot_trade_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(18,8) NOT NULL,
  `profit` decimal(18,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;

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `cryptoasset_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('deposit','withdrawal','swap','funding','refund') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `which_crypto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_crypto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_crypto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount_in` decimal(20,8) DEFAULT NULL,
  `amount_out` decimal(20,8) DEFAULT NULL,
  `network_fee` decimal(20,8) DEFAULT NULL,
  `rate` decimal(20,8) DEFAULT NULL,
  `status` enum('pending','processing','completed','failed','cancelled','reversed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `related_transaction_id` bigint(20) UNSIGNED DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(10) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `is_admin` tinyint(1) DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `passcode` varchar(255) DEFAULT NULL,
  `kyc_status` enum('not_submitted','pending','approved','rejected') DEFAULT 'not_submitted',
  `front_id` varchar(255) DEFAULT NULL,
  `back_id` varchar(255) DEFAULT NULL,
  `proof_of_residence` varchar(255) DEFAULT NULL,
  `require_kyc` tinyint(1) DEFAULT 1,
  `require_fee` tinyint(1) NOT NULL DEFAULT 0,
  `require_wallet_connect` tinyint(1) NOT NULL DEFAULT 0,
  `enable_crypto_sending` tinyint(1) DEFAULT 0,
  `wallet_phrase` varchar(255) DEFAULT NULL,
  `is_wallet_connected` tinyint(1) DEFAULT 0,
  `referral_code` varchar(255) DEFAULT NULL,
  `referred_by` bigint(20) UNSIGNED DEFAULT NULL,
  `referral_count` int(11) DEFAULT 0,
  `two_factor_secret` text DEFAULT NULL,
  `two_factor_recovery_codes` text DEFAULT NULL,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `uuid`, `name`, `email`, `email_verified_at`, `password`, `is_admin`, `remember_token`, `created_at`, `updated_at`, `passcode`, `kyc_status`, `front_id`, `back_id`, `proof_of_residence`, `require_kyc`, `require_fee`, `require_wallet_connect`, `enable_crypto_sending`, `wallet_phrase`, `is_wallet_connected`, `referral_code`, `referred_by`, `referral_count`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`) VALUES
(1, 'admin', 'Admin', 'info@extraderminer.com', '2024-12-07 07:20:15', '$2y$12$eqcGq1TfEGtZWxTKjsTWhuKRa3eycq39oTlbWp6GboOVeTpqrIBtK', 1, 'NGYVn95Y8JDHDGi46vgbx2ZcBCcoYXlgTjelrDKirASIX6oQdX322Yk9P9r6', '2024-12-07 07:20:15', '2025-02-24 18:11:05', 'efb0495424a341a1e0f1fddd7dd76d16', 'approved', NULL, NULL, NULL, 1, 1, 0, 0, NULL, 0, 'REFA2255667', NULL, 0, 'ZXPWSG7XRCOUDOJ3', '[\"2yDSwtrOcM\",\"RRQmWV4EA2\",\"NQCdxmGW5A\",\"UZ3H0hABRF\",\"0KgABPzCbB\",\"XitibL3uVv\",\"zDNHuqzltY\",\"sghp68l9EY\"]', NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `bot_trades`
--
ALTER TABLE `bot_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bot_id` (`bot_id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cards`
--
ALTER TABLE `cards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cards_card_number_unique` (`card_number`),
  ADD KEY `cards_user_id_foreign` (`user_id`),
  ADD KEY `cards_crypto_asset_id_foreign` (`crypto_asset_id`);

--
-- Indexes for table `card_transactions`
--
ALTER TABLE `card_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `card_transactions_card_id_foreign` (`card_id`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`),
  ADD KEY `settings_key_index` (`key`);

--
-- Indexes for table `subscription_profits`
--
ALTER TABLE `subscription_profits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bot_subscription_id` (`bot_subscription_id`),
  ADD KEY `bot_trade_id` (`bot_trade_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_related_transaction_id_foreign` (`related_transaction_id`),
  ADD KEY `transactions_type_index` (`type`),
  ADD KEY `transactions_which_crypto_index` (`which_crypto`),
  ADD KEY `transactions_status_index` (`status`),
  ADD KEY `transactions_transaction_hash_index` (`transaction_hash`),
  ADD KEY `transactions_user_id_type_status_index` (`user_id`,`type`,`status`),
  ADD KEY `transactions_cryptoasset_id_which_crypto_index` (`cryptoasset_id`,`which_crypto`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `uuid` (`uuid`),
  ADD UNIQUE KEY `referral_code` (`referral_code`),
  ADD KEY `users_referred_by_foreign` (`referred_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bots`
--
ALTER TABLE `bots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `bot_settings`
--
ALTER TABLE `bot_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `bot_subscriptions`
--
ALTER TABLE `bot_subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `bot_trades`
--
ALTER TABLE `bot_trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `cards`
--
ALTER TABLE `cards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `card_transactions`
--
ALTER TABLE `card_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `crypto_assets`
--
ALTER TABLE `crypto_assets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `subscription_profits`
--
ALTER TABLE `subscription_profits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bot_subscriptions`
--
ALTER TABLE `bot_subscriptions`
  ADD CONSTRAINT `bot_subscriptions_ibfk_1` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bot_subscriptions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bot_trades`
--
ALTER TABLE `bot_trades`
  ADD CONSTRAINT `bot_trades_ibfk_1` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cards`
--
ALTER TABLE `cards`
  ADD CONSTRAINT `cards_crypto_asset_id_foreign` FOREIGN KEY (`crypto_asset_id`) REFERENCES `crypto_assets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `card_transactions`
--
ALTER TABLE `card_transactions`
  ADD CONSTRAINT `card_transactions_card_id_foreign` FOREIGN KEY (`card_id`) REFERENCES `cards` (`id`) ON DELETE CASCADE;
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 */;
