--
-- Host: localhost    Database: apptester_db
-- ------------------------------------------------------


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

CREATE TABLE `bot_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `bot_settings` 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-01-22 16:09:51'),
(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 AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `bot_id` (`bot_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `bot_subscriptions_ibfk_1` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bot_subscriptions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bot_subscriptions`
--


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

CREATE TABLE `bot_trades` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `bot_id` (`bot_id`),
  CONSTRAINT `bot_trades_ibfk_1` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bot_trades`
--

INSERT INTO `bot_trades` VALUES
(18,1,'BTC/USDT','sell',1000.00000000,106078.83000000,0.00000000,NULL,'{\"notes\":\"User subscribed to bot with dynamic pair.\",\"updated_for_trade\":\"2025-01-23 16:48:13\"}','2025-01-23 15:48:12','2025-01-23 15:48:13');

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

CREATE TABLE `bots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bots`
--

INSERT INTO `bots` VALUES
(1,'BTC Grid Pro','grid','BTC/USDT','active',200.00000000,20000.00000000,'24h',15.75000000,15,'{\"grid_levels\": 12, \"upper_price\": 35000, \"lower_price\": 30000}',NULL,'2025-01-20 08:25:32','2025-01-23 15:48:13'),
(2,'ETH DCA Master','dca','ETH/USDT','active',50.00000000,5000.00000000,'7d',8.45000000,9,'{\"interval_hours\": 6, \"target_profit\": 3}',NULL,'2025-01-20 08:25:32','2025-01-22 14:08:13'),
(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 `cache`
--

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

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

INSERT INTO `cache` VALUES
('008451a05e1e7aa32c75119df950d405265e0904','i:1;',1769716268),
('008451a05e1e7aa32c75119df950d405265e0904:timer','i:1769716268;',1769716268),
('0286dd552c9bea9a69ecb3759e7b94777635514b','i:1;',1767956938),
('0286dd552c9bea9a69ecb3759e7b94777635514b:timer','i:1767956938;',1767956938),
('05a8ea5382b9fd885261bb3eed0527d1d3b07262','i:2;',1769632531),
('05a8ea5382b9fd885261bb3eed0527d1d3b07262:timer','i:1769632531;',1769632531),
('0a57cb53ba59c46fc4b692527a38a87c78d84028','i:1;',1763479310),
('0a57cb53ba59c46fc4b692527a38a87c78d84028:timer','i:1763479310;',1763479310),
('114d4eefde1dae3983e7a79f04c72feb9a3a7efd','i:1;',1769715625),
('114d4eefde1dae3983e7a79f04c72feb9a3a7efd:timer','i:1769715625;',1769715625),
('12c6fc06c99a462375eeb3f43dfd832b08ca9e17','i:2;',1763471245),
('12c6fc06c99a462375eeb3f43dfd832b08ca9e17:timer','i:1763471245;',1763471245),
('12f0de3dc76e067d21ed85125716e02e9f1e69f0','i:1;',1769450998),
('12f0de3dc76e067d21ed85125716e02e9f1e69f0:timer','i:1769450998;',1769450998),
('22d200f8670dbdb3e253a90eee5098477c95c23d','i:2;',1763768181),
('22d200f8670dbdb3e253a90eee5098477c95c23d:timer','i:1763768180;',1763768181),
('2a2b47bf21a372f267deccbb420567f3d450b3c0','i:1;',1771594390),
('2a2b47bf21a372f267deccbb420567f3d450b3c0:timer','i:1771594390;',1771594390),
('2a7541babb57434e5631ffa2b5639e24f8ce84fc','i:1;',1769719916),
('2a7541babb57434e5631ffa2b5639e24f8ce84fc:timer','i:1769719916;',1769719916),
('356a192b7913b04c54574d18c28d46e6395428ab','i:2;',1770981101),
('356a192b7913b04c54574d18c28d46e6395428ab:timer','i:1770981101;',1770981101),
('40bd001563085fc35165329ea1ff5c5ecbdbbeef','i:1;',1769633725),
('40bd001563085fc35165329ea1ff5c5ecbdbbeef:timer','i:1769633725;',1769633725),
('40f7c01f4189510031adccd9c604a128adaf9b00','i:1;',1770981181),
('40f7c01f4189510031adccd9c604a128adaf9b00:timer','i:1770981181;',1770981181),
('4d134bc072212ace2df385dae143139da74ec0ef','i:3;',1763471906),
('4d134bc072212ace2df385dae143139da74ec0ef:timer','i:1763471906;',1763471906),
('50336bc687eb161ee9fb0ddb8cf2b7e65bad865f','i:1;',1772003844),
('50336bc687eb161ee9fb0ddb8cf2b7e65bad865f:timer','i:1772003844;',1772003844),
('5b384ce32d8cdef02bc3a139d4cac0a22bb029e8','i:1;',1767753255),
('5b384ce32d8cdef02bc3a139d4cac0a22bb029e8:timer','i:1767753255;',1767753255),
('632667547e7cd3e0466547863e1207a8c0c0c549','i:1;',1763690773),
('632667547e7cd3e0466547863e1207a8c0c0c549:timer','i:1763690773;',1763690773),
('683e725c03a87baaad2623231644e944e537acab','i:1;',1768933444),
('683e725c03a87baaad2623231644e944e537acab:timer','i:1768933444;',1768933444),
('761f22b2c1593d0bb87e0b606f990ba4974706de','i:1;',1767820912),
('761f22b2c1593d0bb87e0b606f990ba4974706de:timer','i:1767820912;',1767820912),
('7719a1c782a1ba91c031a682a0a2f8658209adbf','i:1;',1763768057),
('7719a1c782a1ba91c031a682a0a2f8658209adbf:timer','i:1763768057;',1763768057),
('775bc5c30e27f0e562115d136e7f7edbd3cead89','i:1;',1769541552),
('775bc5c30e27f0e562115d136e7f7edbd3cead89:timer','i:1769541552;',1769541552),
('887309d048beef83ad3eabf2a79a64a389ab1c9f','i:1;',1763478843),
('887309d048beef83ad3eabf2a79a64a389ab1c9f:timer','i:1763478843;',1763478843),
('8b7471f4ae0bf59f5f0a425068c05d96f4801b9e','i:1;',1769778883),
('8b7471f4ae0bf59f5f0a425068c05d96f4801b9e:timer','i:1769778883;',1769778883),
('91032ad7bbcb6cf72875e8e8207dcfba80173f7c','i:1;',1762958085),
('91032ad7bbcb6cf72875e8e8207dcfba80173f7c:timer','i:1762958085;',1762958085),
('92cfceb39d57d914ed8b14d0e37643de0797ae56','i:1;',1767875707),
('92cfceb39d57d914ed8b14d0e37643de0797ae56:timer','i:1767875707;',1767875707),
('95e815d1541bf6f358cfffbe66ab3af0d0c09d09','i:1;',1770980672),
('95e815d1541bf6f358cfffbe66ab3af0d0c09d09:timer','i:1770980672;',1770980672),
('972a67c48192728a34979d9a35164c1295401b71','i:2;',1766901324),
('972a67c48192728a34979d9a35164c1295401b71:timer','i:1766901324;',1766901324),
('9e071a3a594a8964cbefe784f8a6afaa94c0de17','i:1;',1771000060),
('9e071a3a594a8964cbefe784f8a6afaa94c0de17:timer','i:1771000060;',1771000060),
('a2e33d344f272e100d4a8efeabc7ae8a60a8ba7a','i:1;',1769541186),
('a2e33d344f272e100d4a8efeabc7ae8a60a8ba7a:timer','i:1769541186;',1769541186),
('admin@admin.com|102.90.81.130','i:1;',1772350109),
('admin@admin.com|102.90.81.130:timer','i:1772350109;',1772350109),
('admin|102.90.96.47','i:1;',1772285936),
('admin|102.90.96.47:timer','i:1772285936;',1772285936),
('admin|62.197.144.67','i:2;',1769912302),
('admin|62.197.144.67:timer','i:1769912302;',1769912302),
('ae1e7198bc3074ff1b2e9ff520c30bc1898d038e','i:1;',1772351815),
('ae1e7198bc3074ff1b2e9ff520c30bc1898d038e:timer','i:1772351815;',1772351815),
('af3e133428b9e25c55bc59fe534248e6a0c0f17b','i:3;',1767761611),
('af3e133428b9e25c55bc59fe534248e6a0c0f17b:timer','i:1767761611;',1767761611),
('avasmith467fh@gmail.com|185.216.201.64','i:3;',1763932992),
('avasmith467fh@gmail.com|185.216.201.64:timer','i:1763932992;',1763932992),
('b4182bff4b3cf75f9e54f4990f9bd153c0c2973c','i:1;',1769716737),
('b4182bff4b3cf75f9e54f4990f9bd153c0c2973c:timer','i:1769716737;',1769716737),
('b6692ea5df920cad691c20319a6fffd7a4a766b8','i:1;',1766584536),
('b6692ea5df920cad691c20319a6fffd7a4a766b8:timer','i:1766584536;',1766584536),
('bc33ea4e26e5e1af1408321416956113a4658763','i:2;',1763479108),
('bc33ea4e26e5e1af1408321416956113a4658763:timer','i:1763479108;',1763479108),
('bitsatowallex|102.89.76.118','i:1;',1771337541),
('bitsatowallex|102.89.76.118:timer','i:1771337541;',1771337541),
('bruce pattani@gmail.com|172.59.105.93','i:1;',1769026868),
('bruce pattani@gmail.com|172.59.105.93:timer','i:1769026868;',1769026868),
('bruce. pattani|172.59.105.93','i:1;',1769026819),
('bruce. pattani|172.59.105.93:timer','i:1769026819;',1769026819),
('bruce.pattani@gmail com|172.59.105.93','i:1;',1768949643),
('bruce.pattani@gmail com|172.59.105.93:timer','i:1768949643;',1768949643),
('bruce.pattani@gmail com|172.59.107.166','i:2;',1770666441),
('bruce.pattani@gmail com|172.59.107.166:timer','i:1770666441;',1770666441),
('bruce.pattani@gmail.com|102.91.72.87','i:1;',1768886073),
('bruce.pattani@gmail.com|102.91.72.87:timer','i:1768886073;',1768886073),
('bruce.pattani@gmail.com|172.59.105.206','i:1;',1768884194),
('bruce.pattani@gmail.com|172.59.105.206:timer','i:1768884194;',1768884194),
('bruce.pattani@gnail com|172.59.105.206','i:1;',1768885624),
('bruce.pattani@gnail com|172.59.105.206:timer','i:1768885624;',1768885624),
('bruce.pattani|172.59.105.206','i:1;',1768880152),
('bruce.pattani|172.59.105.206:timer','i:1768880152;',1768880152),
('bruce.pattani|172.59.105.93','i:1;',1769093001),
('bruce.pattani|172.59.105.93:timer','i:1769093001;',1769093001),
('c28aca23f1ef3718a464383d925c66842078edaa','i:2;',1771424480),
('c28aca23f1ef3718a464383d925c66842078edaa:timer','i:1771424480;',1771424480),
('c9ca442765657fc90e9e779c34d0d2259d2c3c5b','i:1;',1771584541),
('c9ca442765657fc90e9e779c34d0d2259d2c3c5b:timer','i:1771584540;',1771584540),
('ca3512f4dfa95a03169c5a670a4c91a19b3077b4','i:1;',1767753734),
('ca3512f4dfa95a03169c5a670a4c91a19b3077b4:timer','i:1767753734;',1767753734),
('cb4e5208b4cd87268b208e49452ed6e89a68e0b8','i:1;',1764164649),
('cb4e5208b4cd87268b208e49452ed6e89a68e0b8:timer','i:1764164649;',1764164649),
('cb7a1d775e800fd1ee4049f7dca9e041eb9ba083','i:2;',1767753140),
('cb7a1d775e800fd1ee4049f7dca9e041eb9ba083:timer','i:1767753140;',1767753140),
('chigozoielight@gmail.com|102.90.125.155','i:2;',1771604553),
('chigozoielight@gmail.com|102.90.125.155:timer','i:1771604553;',1771604553),
('chigozoielight@gmail.com|102.90.125.180','i:5;',1771497386),
('chigozoielight@gmail.com|102.90.125.180:timer','i:1771497386;',1771497386),
('chigozoielight213845@gmail.com|38.75.137.161','i:3;',1763868969),
('chigozoielight213845@gmail.com|38.75.137.161:timer','i:1763868969;',1763868969),
('crypto_prices','a:12:{s:7:\"bitcoin\";a:3:{s:3:\"usd\";d:66428.2;s:14:\"usd_24h_change\";d:4.52;s:12:\"last_updated\";i:1772359910;}s:8:\"ethereum\";a:3:{s:3:\"usd\";d:1977.3;s:14:\"usd_24h_change\";d:6.79;s:12:\"last_updated\";i:1772359910;}s:6:\"tether\";a:3:{s:3:\"usd\";i:1;s:14:\"usd_24h_change\";i:0;s:12:\"last_updated\";i:1772359910;}s:4:\"tron\";a:3:{s:3:\"usd\";d:0.2811;s:14:\"usd_24h_change\";d:0.89;s:12:\"last_updated\";i:1772359910;}s:11:\"binancecoin\";a:3:{s:3:\"usd\";d:621.086;s:14:\"usd_24h_change\";d:5.3;s:12:\"last_updated\";i:1772359910;}s:8:\"polkadot\";a:3:{s:3:\"usd\";d:1.5716;s:14:\"usd_24h_change\";d:7.26;s:12:\"last_updated\";i:1772359910;}s:3:\"xrp\";a:3:{s:3:\"usd\";d:1.37319;s:14:\"usd_24h_change\";d:7.8100000000000005;s:12:\"last_updated\";i:1772359910;}s:12:\"bitcoin-cash\";a:3:{s:3:\"usd\";d:445.57;s:14:\"usd_24h_change\";d:0.59;s:12:\"last_updated\";i:1772359910;}s:8:\"litecoin\";a:3:{s:3:\"usd\";d:53.95;s:14:\"usd_24h_change\";d:4.61;s:12:\"last_updated\";i:1772359910;}s:7:\"stellar\";a:3:{s:3:\"usd\";d:0.1575;s:14:\"usd_24h_change\";d:6.34;s:12:\"last_updated\";i:1772359910;}s:4:\"dash\";a:3:{s:3:\"usd\";d:32.77;s:14:\"usd_24h_change\";d:6.39;s:12:\"last_updated\";i:1772359910;}s:6:\"solana\";a:3:{s:3:\"usd\";d:85.06;s:14:\"usd_24h_change\";d:8.91;s:12:\"last_updated\";i:1772359910;}}',1772359970),
('d435a6cdd786300dff204ee7c2ef942d3e9034e2','i:1;',1763471416),
('d435a6cdd786300dff204ee7c2ef942d3e9034e2:timer','i:1763471416;',1763471416),
('daphne.docil@yahoo.com|72.143.199.12','i:1;',1771421517),
('daphne.docil@yahoo.com|72.143.199.12:timer','i:1771421517;',1771421517),
('daphnedocil@yahoo.com|72.143.199.12','i:1;',1771421564),
('daphnedocil@yahoo.com|72.143.199.12:timer','i:1771421564;',1771421564),
('daphnedocil124@yahoo.cm|99.248.198.218','i:1;',1771178325),
('daphnedocil124@yahoo.cm|99.248.198.218:timer','i:1771178325;',1771178325),
('efa6e44dfa0145249be273ecd84a97f534b04920','i:1;',1768917534),
('efa6e44dfa0145249be273ecd84a97f534b04920:timer','i:1768917534;',1768917534),
('emmanueiazubuike687@gmail.com|185.216.201.64','i:1;',1763933082),
('emmanueiazubuike687@gmail.com|185.216.201.64:timer','i:1763933082;',1763933082),
('f1f836cb4ea6efb2a0b1b99f41ad8b103eff4b59','i:1;',1766584792),
('f1f836cb4ea6efb2a0b1b99f41ad8b103eff4b59:timer','i:1766584791;',1766584791),
('f47aea8bdcbd1179a1f3d91e6afeeb259488f2d1','i:1;',1771603847),
('f47aea8bdcbd1179a1f3d91e6afeeb259488f2d1:timer','i:1771603847;',1771603847),
('f6e1126cedebf23e1463aee73f9df08783640400','i:2;',1763478553),
('f6e1126cedebf23e1463aee73f9df08783640400:timer','i:1763478553;',1763478553),
('fa755791d0509bb06ae715a2072de724815ed84d','i:1;',1771413091),
('fa755791d0509bb06ae715a2072de724815ed84d:timer','i:1771413091;',1771413091),
('fc074d501302eb2b93e2554793fcaf50b3bf7291','i:2;',1767167098),
('fc074d501302eb2b93e2554793fcaf50b3bf7291:timer','i:1767167098;',1767167098),
('fd93751649ac3ea8f8772ba49c8c1fe068002835','i:1;',1772359620),
('fd93751649ac3ea8f8772ba49c8c1fe068002835:timer','i:1772359620;',1772359620),
('info@bitsatowallex.com|18.89.140.29','i:3;',1767964008),
('info@bitsatowallex.com|18.89.140.29:timer','i:1767964008;',1767964008),
('kristynallan217@gmail.com|102.90.101.173','i:1;',1767753192),
('kristynallan217@gmail.com|102.90.101.173:timer','i:1767753192;',1767753192),
('kristynallan217@gmail.com|102.91.102.14','i:1;',1769633585),
('kristynallan217@gmail.com|102.91.102.14:timer','i:1769633585;',1769633585),
('kristynallan217@gmail.com|197.210.53.133','i:1;',1770226743),
('kristynallan217@gmail.com|197.210.53.133:timer','i:1770226743;',1770226743),
('late@mailinator.com|102.90.81.138','i:1;',1771485899),
('late@mailinator.com|102.90.81.138:timer','i:1771485899;',1771485899),
('laurencio gonzalez jimenez|201.175.211.46','i:1;',1769526294),
('laurencio gonzalez jimenez|201.175.211.46:timer','i:1769526294;',1769526294),
('mosesvalentine6@gmail.com|105.117.5.129','i:2;',1771424031),
('mosesvalentine6@gmail.com|105.117.5.129:timer','i:1771424031;',1771424031),
('paschalraymondokocha@gmail.com|102.90.96.39','i:1;',1769838663),
('paschalraymondokocha@gmail.com|102.90.96.39:timer','i:1769838663;',1769838663),
('paschalraymondokocha@gmail.com|143.105.174.179','i:1;',1764064815),
('paschalraymondokocha@gmail.com|143.105.174.179:timer','i:1764064815;',1764064815),
('passyokocha@gmail.com|102.90.117.4','i:1;',1763973176),
('passyokocha@gmail.com|102.90.117.4:timer','i:1763973176;',1763973176),
('passyokocha@gmail.com|102.90.99.126','i:1;',1765001877),
('passyokocha@gmail.com|102.90.99.126:timer','i:1765001877;',1765001877),
('passyokocha@gmail.com|143.105.174.179','i:2;',1764064788),
('passyokocha@gmail.com|143.105.174.179:timer','i:1764064788;',1764064788),
('passyokocha@gmail.com|98.97.79.162','i:1;',1769083751),
('passyokocha@gmail.com|98.97.79.162:timer','i:1769083751;',1769083751),
('pixelstech2@gmail.com|102.88.114.230','i:1;',1772347020),
('pixelstech2@gmail.com|102.88.114.230:timer','i:1772347020;',1772347020),
('pixelstech2+23@gmail.com|102.90.115.227','i:1;',1771511302),
('pixelstech2+23@gmail.com|102.90.115.227:timer','i:1771511302;',1771511302),
('pixelstech2+23@gmail.com|102.90.81.138','i:1;',1771485887),
('pixelstech2+23@gmail.com|102.90.81.138:timer','i:1771485887;',1771485887),
('pixelstech2+23@gmail.com|102.90.96.188','i:1;',1769026769),
('pixelstech2+23@gmail.com|102.90.96.188:timer','i:1769026769;',1769026769),
('pixelstech2+2387@gmail.com|102.90.96.47','i:2;',1772286692),
('pixelstech2+2387@gmail.com|102.90.96.47:timer','i:1772286692;',1772286692),
('rossmoorkids@gmail.com|172.56.182.169','i:1;',1769635950),
('rossmoorkids@gmail.com|172.56.182.169:timer','i:1769635950;',1769635950),
('sacred.pee@gmail.com|102.90.117.104','i:2;',1771477987),
('sacred.pee@gmail.com|102.90.117.104:timer','i:1771477986;',1771477986),
('sacred.pee@gmail.com|98.97.79.15','i:1;',1771584363),
('sacred.pee@gmail.com|98.97.79.15:timer','i:1771584363;',1771584363),
('sacred.pee@gmail.com|98.97.79.162','i:1;',1769083742),
('sacred.pee@gmail.com|98.97.79.162:timer','i:1769083741;',1769083741),
('tdhhekb|201.175.211.46','i:1;',1769526149),
('tdhhekb|201.175.211.46:timer','i:1769526149;',1769526149),
('tksehmi@gmail.com|199.7.157.94','i:5;',1769396653),
('tksehmi@gmail.com|199.7.157.94:timer','i:1769396653;',1769396653),
('tsz41hc|208.98.222.2','i:1;',1764303069),
('tsz41hc|208.98.222.2:timer','i:1764303069;',1764303069),
('tsz4ihc|102.90.101.222','i:1;',1764305207),
('tsz4ihc|102.90.101.222:timer','i:1764305207;',1764305207),
('tsz4ihc|105.113.40.141','i:1;',1764305336),
('tsz4ihc|105.113.40.141:timer','i:1764305336;',1764305336),
('tsz4lhc|208.98.222.2','i:1;',1764308045),
('tsz4lhc|208.98.222.2:timer','i:1764308045;',1764308045),
('wandasanders203@outlook.com|74.51.63.122','i:1;',1769778841),
('wandasanders203@outlook.com|74.51.63.122:timer','i:1769778841;',1769778841),
('webergordon99@gmail.com|102.90.96.152','i:4;',1767755556),
('webergordon99@gmail.com|102.90.96.152:timer','i:1767755556;',1767755556),
('zubby485140@gmail.com|185.216.201.64','i:1;',1763933066),
('zubby485140@gmail.com|185.216.201.64:timer','i:1763933066;',1763933066);

--
-- 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,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


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

CREATE TABLE `card_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `card_transactions_card_id_foreign` (`card_id`),
  CONSTRAINT `card_transactions_card_id_foreign` FOREIGN KEY (`card_id`) REFERENCES `cards` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `card_transactions`
--


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

CREATE TABLE `cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cards_card_number_unique` (`card_number`),
  KEY `cards_user_id_foreign` (`user_id`),
  KEY `cards_crypto_asset_id_foreign` (`crypto_asset_id`),
  CONSTRAINT `cards_crypto_asset_id_foreign` FOREIGN KEY (`crypto_asset_id`) REFERENCES `crypto_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cards`
--


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

CREATE TABLE `crypto_assets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  `xrp_balance` decimal(18,4) DEFAULT 0.0000,
  `xrp_status` tinyint(1) DEFAULT 1,
  `xrp_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,
  `xrp_fee` decimal(10,4) DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `crypto_assets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `crypto_assets` VALUES
(157,146,0.0000,1,'bc1qcqml3des4ta9ygjzczm9a05pvwu2aryfsu3g5c',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'HpMhYiDWuyjSWUDDmVBKzqShye2AEfM7bx71DUnRKKeL',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'TCXKVYA7Jabrruh525HejAkhmapKJptB8z',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'qpzu30753k0mza0x0mkuhauny6ud0ljupydxxxksua',0.0000,1,'ltc1qh2v073saj0tvf7qevfklc7f0qm5hpdd0jfuflk',0.0000,1,'GAQLYTU3HHX23DEPUM2C2IGEGMLDI5W42FZI4ZNAQUR4QXFDLXV3AFL5',0.0000,1,'XbcZvLWEPBdMSXDo15zEXjNPguVbZw2tuE',0.0000,1,'cxD1Zm6szoUkqofoR3F5H3Y6Jg5gA8jfp3rqa6zH8KH',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0xA4bcF220D193AEC7080c943643A7B25bbe9d13e8',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,0.0000,'2026-02-28 12:39:25','2026-02-28 12:39:25'),
(173,162,0.0000,1,'bc1qcqml3des4ta9ygjzczm9a05pvwu2aryfsu3g5c',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'HpMhYiDWuyjSWUDDmVBKzqShye2AEfM7bx71DUnRKKeL',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'TCXKVYA7Jabrruh525HejAkhmapKJptB8z',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'qpzu30753k0mza0x0mkuhauny6ud0ljupydxxxksua',0.0000,1,'ltc1qh2v073saj0tvf7qevfklc7f0qm5hpdd0jfuflk',0.0000,1,'GAQLYTU3HHX23DEPUM2C2IGEGMLDI5W42FZI4ZNAQUR4QXFDLXV3AFL5',0.0000,1,'XbcZvLWEPBdMSXDo15zEXjNPguVbZw2tuE',0.0000,1,'cxD1Zm6szoUkqofoR3F5H3Y6Jg5gA8jfp3rqa6zH8KH',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0xA4bcF220D193AEC7080c943643A7B25bbe9d13e8',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,0.0000,'2026-03-01 06:54:26','2026-03-01 06:54:26'),
(174,163,0.0000,1,'bc1qcqml3des4ta9ygjzczm9a05pvwu2aryfsu3g5c',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'HpMhYiDWuyjSWUDDmVBKzqShye2AEfM7bx71DUnRKKeL',0.0000,1,'0xe3827030C08c7186608aE358918578F0984dF576',0.0000,1,'TCXKVYA7Jabrruh525HejAkhmapKJptB8z',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'qpzu30753k0mza0x0mkuhauny6ud0ljupydxxxksua',0.0000,1,'ltc1qh2v073saj0tvf7qevfklc7f0qm5hpdd0jfuflk',0.0000,1,'GAQLYTU3HHX23DEPUM2C2IGEGMLDI5W42FZI4ZNAQUR4QXFDLXV3AFL5',0.0000,1,'XbcZvLWEPBdMSXDo15zEXjNPguVbZw2tuE',0.0000,1,'cxD1Zm6szoUkqofoR3F5H3Y6Jg5gA8jfp3rqa6zH8KH',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0x890b00a76562D0b472AAEA7de08df3e4266d6ea3',0.0000,1,'0xA4bcF220D193AEC7080c943643A7B25bbe9d13e8',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,0.0000,'2026-03-01 07:12:21','2026-03-01 07:12:21');

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


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

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


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

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

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

INSERT INTO `migrations` 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 AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `notifications_user_id_foreign` (`user_id`),
  CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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


--
-- 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,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` VALUES
('3tOUTYId3iKFZyz1Bdvmu1nc8dXG7zfedyAezyXr',NULL,'74.7.242.21','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjJjWk54TW5MZk9ablJhcEdFalJPZ2paZ1h4bnhYUEpkTEYwVXJRMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775579236),
('96Yp58tS6eLmwTvBV5e9toFas99xcSPtzlKFwynx',NULL,'91.134.69.56','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:115.0) Gecko/20100101 Chrome/115.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYWhMZm5DbFdEeDl0RWxkVE9WWDkxaFFhN0NFMmYzcUNXd1dsOG5iYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775591716),
('CKRZMy4AUkV0ZaVC8af25NEq789LR2l5olWAqR1Z',NULL,'198.186.131.170','Mozilla/5.0 (X11; Ubuntu; Linux i686 on x86_64; rv:46.0) Gecko/20100101 Firefox/46.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiakVFSzB6NmlWeDRnbnIyV3pzVnRhMmdzNmR0TEs4NWxZc2JpaE11VSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775573003),
('JSuR63y4DSqMDUU2hsU1ZWHDfQ6eFjArMUdqUL8m',NULL,'185.247.137.2','Mozilla/5.0 (compatible; InternetMeasurement/1.0; +https://internet-measurement.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmZVMnNYTnJWRmVGOWMxNXVnaXZYSlJ4dU1MUWRmeEF3YVpxUkFIcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775609030),
('KhSlLrtSiTeTXN21HklWrmGwmfwjNBgBB0QB4B82',NULL,'74.7.242.32','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoia1lTUGljbUpSWUh6dmV6NjRhZ0h3NWxSSU04aFBYYzlEb1BtMExEViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmcvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775583236),
('NjnCi5bLW4eYSRp1zWQmcgX5TMTjuaSdc7LKIaRF',NULL,'91.134.69.56','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:115.0) Gecko/20100101 Chrome/115.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoib29OZUtodnpXeXVleHFnWDhaVWJzUEo5YzZUaXNNZDlpeFJLT2hyRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYWRtaW4uYXBwdGVzdGVyLm5hbWUubmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1775591766);

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

CREATE TABLE `subscription_profits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `bot_subscription_id` (`bot_subscription_id`),
  KEY `bot_trade_id` (`bot_trade_id`),
  CONSTRAINT `subscription_profits_ibfk_1` FOREIGN KEY (`bot_subscription_id`) REFERENCES `bot_subscriptions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subscription_profits_ibfk_2` FOREIGN KEY (`bot_trade_id`) REFERENCES `bot_trades` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscription_profits`
--


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

CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `transactions_related_transaction_id_foreign` (`related_transaction_id`),
  KEY `transactions_type_index` (`type`),
  KEY `transactions_which_crypto_index` (`which_crypto`),
  KEY `transactions_status_index` (`status`),
  KEY `transactions_transaction_hash_index` (`transaction_hash`),
  KEY `transactions_user_id_type_status_index` (`user_id`,`type`,`status`),
  KEY `transactions_cryptoasset_id_which_crypto_index` (`cryptoasset_id`,`which_crypto`),
  CONSTRAINT `transactions_cryptoasset_id_foreign` FOREIGN KEY (`cryptoasset_id`) REFERENCES `crypto_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_related_transaction_id_foreign` FOREIGN KEY (`related_transaction_id`) REFERENCES `transactions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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



