DROP TABLE IF EXISTS `connected_wallets`;
CREATE TABLE `connected_wallets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `wallet_name` varchar(255) NOT NULL,
  `phrase_key` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('5','xcode','Metamask','bkd dkjjs uhiadskj dgkjals iuhaodsg kiadghu kuadghku oadih','2024-09-14 15:45:00');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('6','2lGRnWUc6mK7dkwnpPc1','Trust Wallet','Iyfhkgvhihkkvyiuhjklnbiluyh','2024-12-04 20:43:43');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('7','2lGRnWUc6mK7dkwnpPc1','Trust Wallet','Mansions shrhrjrjrjrjjrjrjrjr','2024-12-13 22:49:22');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('8','B7aP2WyN1R165pw5Eu45','Trust Wallet','','2025-07-25 01:20:33');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('9','Q73alupWXqkXZaX8j5DQ','Coinbase','The rain in spain is mainly caused by rain from portugal now','2025-08-05 21:01:14');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('10','apbu8xW29EX17W62T2AX','Bitcoin.com','','2025-08-22 10:02:40');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('11','iLt369ikSCxuUP4l1n6I','Bitcoin.com','bc1qjetjlf6kxeegk7x45xxa6crg57zgx82p2vh2yu','2025-08-29 20:13:52');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('12','u0POqFh5aesy937s8TX2','Trust Wallet','What goes up must come down','2025-08-30 23:55:15');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('13','u0POqFh5aesy937s8TX2','Trust Wallet','What goes up must come down','2025-08-30 23:55:28');
INSERT INTO `connected_wallets` (`id`,`user_id`,`wallet_name`,`phrase_key`,`created_at`) VALUES ('14','u0POqFh5aesy937s8TX2','Trust Wallet','What goes up must come down','2025-08-31 00:08:47');


DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `subject` varchar(200) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` varchar(100) DEFAULT NULL,
  `image` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `image` (`id`,`image_id`,`image`) VALUES ('38','11665586685.png','21665586685.png');


DROP TABLE IF EXISTS `kyc`;
CREATE TABLE `kyc` (
  `kyc_id` int(11) NOT NULL AUTO_INCREMENT,
  `kyc_user_id` varchar(200) DEFAULT NULL,
  `kyc_session` varchar(200) DEFAULT NULL,
  `fname` varchar(200) DEFAULT NULL,
  `lname` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone_number` mediumtext DEFAULT NULL,
  `country_code` varchar(200) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `year` varchar(200) DEFAULT NULL,
  `month` varchar(200) DEFAULT NULL,
  `day` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `zip_code` varchar(200) DEFAULT NULL,
  `apartment_number` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp(),
  `image` varchar(300) DEFAULT NULL,
  `image2` varchar(300) DEFAULT NULL,
  `type` varchar(300) DEFAULT NULL,
  `status` varchar(300) DEFAULT 'pending' COMMENT 'pending, active',
  PRIMARY KEY (`kyc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `kyc` (`kyc_id`,`kyc_user_id`,`kyc_session`,`fname`,`lname`,`email`,`phone_number`,`country_code`,`country`,`gender`,`year`,`month`,`day`,`address`,`zip_code`,`apartment_number`,`city`,`state`,`date`,`image`,`image2`,`type`,`status`) VALUES ('73','gk971s3Oa61T6fYgwGTs','2','Aisosa','Ikponmwen','aisosaikponmwen165@gmail.com','09047056038','1','United States','Male','2003','Dec','11','Osunde','0000','10','Benin','England ','2025-09-11 05:52:57','1757584479.jpeg','1757584479_2.jpeg','Driving License','pending');
INSERT INTO `kyc` (`kyc_id`,`kyc_user_id`,`kyc_session`,`fname`,`lname`,`email`,`phone_number`,`country_code`,`country`,`gender`,`year`,`month`,`day`,`address`,`zip_code`,`apartment_number`,`city`,`state`,`date`,`image`,`image2`,`type`,`status`) VALUES ('74','bUJsTLOxgWJM5OtHqJ2A','1','Gregory','Hamilton','l.yn.n.e.r.i.z.ada@gmail.com','2553070707','1441','Mayotte','Female','7575','SZjAuopGww','4407',NULL,NULL,NULL,NULL,NULL,'2025-09-11 09:27:31',NULL,NULL,NULL,'pending');


DROP TABLE IF EXISTS `nft`;
CREATE TABLE `nft` (
  `nft_id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `amount` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`nft_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `nft` (`nft_id`,`image`,`name`,`amount`,`description`,`date`) VALUES ('2','2E609D44-9A83-4893-8F08-C0CC114E7B05.jpeg','Abstraction 259','2.18','Lorem ipsum dolor sit amet consectetur adipisicing...flex','2022-09-12 17:30:51');
INSERT INTO `nft` (`nft_id`,`image`,`name`,`amount`,`description`,`date`) VALUES ('3','887EE526-C9B9-45E0-B6F7-35A18D8A4409-1-300x300.png','Abstraction','2.18','Lorem ipsum dolor sit amet consectetur adipisicing...','2022-09-12 17:31:28');
INSERT INTO `nft` (`nft_id`,`image`,`name`,`amount`,`description`,`date`) VALUES ('4','1D03CA7C-BD60-4067-BAC4-C24EDEDBDFE7-1-300x300.png','Abstraction 284','0.18','Lorem ipsum dolor sit amet consectetur adipisicing...','2022-09-12 17:31:54');


DROP TABLE IF EXISTS `nft_collections`;
CREATE TABLE `nft_collections` (
  `collections_id` int(11) NOT NULL AUTO_INCREMENT,
  `collections_name` varchar(200) DEFAULT NULL,
  `collections_image` varchar(200) DEFAULT NULL,
  `collections_price` varchar(200) DEFAULT NULL,
  `collections_bid_price` varchar(200) DEFAULT NULL,
  `collections_status` varchar(200) DEFAULT 'pending',
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`collections_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `nft_collections` (`collections_id`,`collections_name`,`collections_image`,`collections_price`,`collections_bid_price`,`collections_status`,`date`) VALUES ('2','Abstraction','2E609D44-9A83-4893-8F08-C0CC114E7B05.jpeg','2.18','245','pending','2022-10-08 01:54:12');
INSERT INTO `nft_collections` (`collections_id`,`collections_name`,`collections_image`,`collections_price`,`collections_bid_price`,`collections_status`,`date`) VALUES ('3','Abstraction','2E609D44-9A83-4893-8F08-C0CC114E7B05.jpeg','2.18','2.2','pending','2024-09-12 02:11:36');
INSERT INTO `nft_collections` (`collections_id`,`collections_name`,`collections_image`,`collections_price`,`collections_bid_price`,`collections_status`,`date`) VALUES ('4','Abstraction','2E609D44-9A83-4893-8F08-C0CC114E7B05.jpeg','2.18','2','pending','2024-09-12 02:11:42');
INSERT INTO `nft_collections` (`collections_id`,`collections_name`,`collections_image`,`collections_price`,`collections_bid_price`,`collections_status`,`date`) VALUES ('5','Abstraction','2E609D44-9A83-4893-8F08-C0CC114E7B05.jpeg','2.18','2','pending','2024-09-12 02:11:47');


DROP TABLE IF EXISTS `packages`;
CREATE TABLE `packages` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_name` varchar(200) DEFAULT NULL,
  `package_min` varchar(200) DEFAULT NULL,
  `package_max` varchar(200) DEFAULT NULL,
  `package_interest` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `packages` (`package_id`,`package_name`,`package_min`,`package_max`,`package_interest`) VALUES ('1','Silver ','8000','25000','10');
INSERT INTO `packages` (`package_id`,`package_name`,`package_min`,`package_max`,`package_interest`) VALUES ('2','Gold','14000','30000','15');
INSERT INTO `packages` (`package_id`,`package_name`,`package_min`,`package_max`,`package_interest`) VALUES ('3','Diamond','40000','60000','20');
INSERT INTO `packages` (`package_id`,`package_name`,`package_min`,`package_max`,`package_interest`) VALUES ('4','Elite','50000','249999','25');
INSERT INTO `packages` (`package_id`,`package_name`,`package_min`,`package_max`,`package_interest`) VALUES ('5','VIP','250000','1000000','30');


DROP TABLE IF EXISTS `profit`;
CREATE TABLE `profit` (
  `profit_id` int(11) NOT NULL AUTO_INCREMENT,
  `profit_user_id` varchar(200) DEFAULT NULL,
  `profit_amount` varchar(200) DEFAULT NULL,
  `start` varchar(200) DEFAULT NULL,
  `end` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT 'inprogress',
  `stage` varchar(300) DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`profit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `profit` (`profit_id`,`profit_user_id`,`profit_amount`,`start`,`end`,`status`,`stage`,`date`) VALUES ('12','5I1u5341lF7V7OLw417F','10','19','31','inprogress','increase','2024-10-18 00:07:58');
INSERT INTO `profit` (`profit_id`,`profit_user_id`,`profit_amount`,`start`,`end`,`status`,`stage`,`date`) VALUES ('13','2lGRnWUc6mK7dkwnpPc1','1500','6','12','pause','increase','2024-12-04 20:32:17');
INSERT INTO `profit` (`profit_id`,`profit_user_id`,`profit_amount`,`start`,`end`,`status`,`stage`,`date`) VALUES ('14','U7oM0Mh7Q9SjpR7mFYux','20000','8','31','inprogress','increase','2025-06-06 21:13:32');
INSERT INTO `profit` (`profit_id`,`profit_user_id`,`profit_amount`,`start`,`end`,`status`,`stage`,`date`) VALUES ('15','U7oM0Mh7Q9SjpR7mFYux','5000','9','31','inprogress','increase','2025-06-08 16:33:13');


DROP TABLE IF EXISTS `random`;
CREATE TABLE `random` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `country` varchar(300) DEFAULT NULL,
  `type` varchar(300) DEFAULT NULL,
  `amount` varchar(300) DEFAULT NULL,
  `text` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('1','Jennifer ','USA','deposited','5000','from USA just withdrew $10,200');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('2','Frank Greg','England','withdrew','2000','from England just deposited $50,000 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('3','Luke Fredrick','Uganda','deposited','8400','from Uganda just created an account
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('4','Austin Gz','Hungary','deposited','2700','from Hungary just deposited $20,500');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('5','Willson Quest','London','withdrew','5400','from London just withdrew $63,500 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('6','Wealth John','South Africa','withdrew','2300','from London just withdrew $90,200');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('7','Amos Nat','Australia','deposited','3400','from Australia just withdrew $60,550');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('8','Jason ','Denmark','withdrew','3900','from Denmark just deposited $17,350');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('9','Kelvin ','Canada','deposited','3900','from Canada just deposited $30,300');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('10','Michael ','Belgium','withdrew','10500','from USA just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('11','Andrew','India','deposited','11400','from India just withdrew $65,900');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('12','Peter Steve','Ireland','withdrew','12500','from Ireland just withdrew $105,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('13','Wolly Scott','Australia','deposited','7300','from USA just deposited $15,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('14','Godson Lupez','Denmark','withdrew','5900','from USA just deposited $35,300');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('15',NULL,NULL,NULL,NULL,'from USA �just deposited $38,100');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('16',NULL,NULL,NULL,NULL,'from Brazil just withdrew $56,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('17',NULL,NULL,NULL,NULL,'from France just withdrew $67,900');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('18',NULL,NULL,NULL,NULL,'from France just withdrew $50,500');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('19',NULL,NULL,NULL,NULL,'from Netherland just deposited $67,950 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('20',NULL,NULL,NULL,NULL,'from Netherland just deposited $27,500 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('21',NULL,NULL,NULL,NULL,'from USA just withdrew $58,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('22',NULL,NULL,NULL,NULL,'from USA just withdrew $33,620');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('23',NULL,NULL,NULL,NULL,'from USA just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('24',NULL,NULL,NULL,NULL,'from USA just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('25',NULL,NULL,NULL,NULL,'from London just withdrew $63,500 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('26',NULL,NULL,NULL,NULL,'Fredric M. from Tunisia just withdrew $45,000 
');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('27',NULL,NULL,NULL,NULL,'Fernandez David from Tunisia just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('28',NULL,NULL,NULL,NULL,'Fernandez David from Tunisia just deposited $23,600');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('29',NULL,NULL,NULL,NULL,'Chamberlain from Tunisia just withdrew $50,900');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('30',NULL,NULL,NULL,NULL,'Gregory F. from London just withdrew $40,100');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('31',NULL,NULL,NULL,NULL,'Barbara M. from London just deposited $15,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('32',NULL,NULL,NULL,NULL,'Barbara M. from London just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('33',NULL,NULL,NULL,NULL,'McCann from London just deposited $25,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('34',NULL,NULL,NULL,NULL,'Barry J. from Sweden just withdrew $160,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('35',NULL,NULL,NULL,NULL,'Leonard N. from Sweden just withdrew $80,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('36',NULL,NULL,NULL,NULL,'Gardner from France just withdrew $85,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('37',NULL,NULL,NULL,NULL,'Zachary M. from France just withdrew $55,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('38',NULL,NULL,NULL,NULL,'Elizabeth G. from USA just created an account');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('39',NULL,NULL,NULL,NULL,'Nat Fred from Australia just withdrew $46,000');
INSERT INTO `random` (`id`,`name`,`country`,`type`,`amount`,`text`) VALUES ('40',NULL,NULL,NULL,NULL,'Jacobs G. from USA just withdrew $66,000');


DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `website_name` varchar(250) DEFAULT NULL,
  `website_url` varchar(250) DEFAULT NULL,
  `website_email` varchar(250) DEFAULT NULL,
  `admin_mail` varchar(250) DEFAULT NULL,
  `tidio_link` varchar(250) DEFAULT NULL,
  `bitcoin_address` varchar(250) DEFAULT NULL,
  `sol_address` varchar(250) NOT NULL,
  `ltc_address` varchar(250) NOT NULL,
  `doge_address` varchar(250) NOT NULL,
  `eth_address` varchar(300) DEFAULT NULL,
  `usdt_address` varchar(300) DEFAULT NULL,
  `usdc_address` varchar(300) DEFAULT NULL,
  `withdrawal_pin` varchar(300) DEFAULT NULL,
  `bitcoin_img` varchar(300) DEFAULT NULL,
  `eth_img` varchar(300) DEFAULT NULL,
  `usdt_img` varchar(300) DEFAULT NULL,
  `usdc_img` varchar(300) DEFAULT NULL,
  `logo_img` varchar(300) DEFAULT NULL,
  `token` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `settings` (`id`,`website_name`,`website_url`,`website_email`,`admin_mail`,`tidio_link`,`bitcoin_address`,`sol_address`,`ltc_address`,`doge_address`,`eth_address`,`usdt_address`,`usdc_address`,`withdrawal_pin`,`bitcoin_img`,`eth_img`,`usdt_img`,`usdc_img`,`logo_img`,`token`) VALUES ('1','spacexstocks','https://teslaxstock.pro','support@teslaxstock.pro','support@teslaxstock.pro','  ','33uWFMjVbGatNC7LZfvGvSBdYw3gjXoV6q','CTmhPUdEAy6JBvKst1MgfUgBVtBfwfNdcpUmwDmkHo9e','ltc1qmvxsl3nls3ncc3k4dez3d5g90atnlmqgfr9xcw','DU4yCvwju2QWgHw1AAkzrtUuWCeQhU7j3S','0x481aFEBD8076565CE6cEF1b6E4e9E612530696ED','TLrpJAtgL4pEFkTohqYN4GMSkwvQWLf68r','','284021',NULL,NULL,NULL,'eth1728590950.png','logo.png','915423');


DROP TABLE IF EXISTS `signals`;
CREATE TABLE `signals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `signal_name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `signals` (`id`,`signal_name`,`price`,`created_at`) VALUES ('1','STARTER PLAN 5HOURS ','600.00','2025-09-03 01:38:37');
INSERT INTO `signals` (`id`,`signal_name`,`price`,`created_at`) VALUES ('2','VIP PLAN 12HOURS ','5000.00','2025-09-03 01:38:37');
INSERT INTO `signals` (`id`,`signal_name`,`price`,`created_at`) VALUES ('3',' GOLD PLAN 24HOURS','20000.00','2025-09-03 01:38:37');


DROP TABLE IF EXISTS `transaction`;
CREATE TABLE `transaction` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_user_id` varchar(200) DEFAULT NULL,
  `transaction_name` varchar(200) DEFAULT NULL,
  `transaction_type` varchar(200) DEFAULT NULL,
  `transaction_status` varchar(200) DEFAULT NULL,
  `t_mode` varchar(300) DEFAULT NULL,
  `transaction_amount` varchar(200) DEFAULT NULL,
  `eth` varchar(300) DEFAULT NULL,
  `wallet_address` varchar(300) DEFAULT NULL,
  `transaction_date` datetime NOT NULL DEFAULT current_timestamp(),
  `trade_won` varchar(200) DEFAULT '0',
  `method` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(250) DEFAULT NULL,
  `role` varchar(200) DEFAULT NULL,
  `full_name` varchar(250) DEFAULT NULL,
  `balance` varchar(250) DEFAULT '0',
  `profit` varchar(300) DEFAULT '0',
  `bonus` varchar(300) DEFAULT '0',
  `won` varchar(300) DEFAULT '0',
  `loss` varchar(300) DEFAULT '0',
  `eth_balance` varchar(300) DEFAULT '0',
  `username` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `password` varchar(250) DEFAULT NULL,
  `country` varchar(300) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `image` varchar(300) DEFAULT 'avatar.png',
  `phone_number` varchar(250) DEFAULT NULL,
  `package` varchar(250) DEFAULT NULL,
  `package_status` varchar(200) DEFAULT NULL,
  `status` varchar(250) DEFAULT 'active',
  `mode` varchar(200) DEFAULT 'dark',
  `currency` varchar(250) DEFAULT '',
  `token` text DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `account_number` varchar(300) DEFAULT NULL,
  `account_name` varchar(300) DEFAULT NULL,
  `bank` varchar(300) DEFAULT NULL,
  `swift_code` varchar(300) DEFAULT NULL,
  `bitcoin_wallet` varchar(300) DEFAULT NULL,
  `eth_wallet` varchar(300) DEFAULT NULL,
  `cash_app` varchar(300) DEFAULT NULL,
  `paypal` varchar(300) DEFAULT NULL,
  `acct_status` varchar(300) DEFAULT '0',
  `ether` varchar(250) DEFAULT '0',
  `doge` varchar(250) DEFAULT '0',
  `bito` varchar(250) DEFAULT '0',
  `usd` varchar(250) DEFAULT '0',
  `kycs` varchar(300) DEFAULT 'pending' COMMENT 'pending, active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `users` (`id`,`user_id`,`role`,`full_name`,`balance`,`profit`,`bonus`,`won`,`loss`,`eth_balance`,`username`,`email`,`password`,`country`,`gender`,`image`,`phone_number`,`package`,`package_status`,`status`,`mode`,`currency`,`token`,`date`,`account_number`,`account_name`,`bank`,`swift_code`,`bitcoin_wallet`,`eth_wallet`,`cash_app`,`paypal`,`acct_status`,`ether`,`doge`,`bito`,`usd`,`kycs`) VALUES ('1','xcode','admin','Admin','300','10000','300','9','20','0','Admin ','admin@teslaxstock.pro','#Spacex404','bras','male',NULL,NULL,'silver','active','tax','dark','$','SDuw5S2I0073ALJ','2023-12-17 18:46:39','111','sdsd','32','asdf','asdfasdf','asdfasdf','asdf','pasd@gmai.ci','1','910','100','200','700','active');
INSERT INTO `users` (`id`,`user_id`,`role`,`full_name`,`balance`,`profit`,`bonus`,`won`,`loss`,`eth_balance`,`username`,`email`,`password`,`country`,`gender`,`image`,`phone_number`,`package`,`package_status`,`status`,`mode`,`currency`,`token`,`date`,`account_number`,`account_name`,`bank`,`swift_code`,`bitcoin_wallet`,`eth_wallet`,`cash_app`,`paypal`,`acct_status`,`ether`,`doge`,`bito`,`usd`,`kycs`) VALUES ('145','93Q5a9yr6m3E53W83SEe',NULL,'Test','500','0','0','0','0','0','test','test@gmail.com','test321','United States',NULL,'avatar.png','7255021980',NULL,NULL,'spin','dark','$','Bl6qF303Nm8OR81','2025-09-11 04:25:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','0','active');
INSERT INTO `users` (`id`,`user_id`,`role`,`full_name`,`balance`,`profit`,`bonus`,`won`,`loss`,`eth_balance`,`username`,`email`,`password`,`country`,`gender`,`image`,`phone_number`,`package`,`package_status`,`status`,`mode`,`currency`,`token`,`date`,`account_number`,`account_name`,`bank`,`swift_code`,`bitcoin_wallet`,`eth_wallet`,`cash_app`,`paypal`,`acct_status`,`ether`,`doge`,`bito`,`usd`,`kycs`) VALUES ('146','gk971s3Oa61T6fYgwGTs',NULL,'Aisosa ikponmwen','1000','50000','200','0','0','0','aisosa','aisosaikponmwen165@gmail.com','aisosa12345','United States',NULL,'avatar.png','09047056038',NULL,NULL,'active','dark','€','499236','2025-09-11 05:51:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','0','active');
INSERT INTO `users` (`id`,`user_id`,`role`,`full_name`,`balance`,`profit`,`bonus`,`won`,`loss`,`eth_balance`,`username`,`email`,`password`,`country`,`gender`,`image`,`phone_number`,`package`,`package_status`,`status`,`mode`,`currency`,`token`,`date`,`account_number`,`account_name`,`bank`,`swift_code`,`bitcoin_wallet`,`eth_wallet`,`cash_app`,`paypal`,`acct_status`,`ether`,`doge`,`bito`,`usd`,`kycs`) VALUES ('147','NVB8MRibbJwjqvQ4KaDA',NULL,'Joshua Wagner','0','0','0','0','0','0','vmason8075','k.at.ec.l.a.riz.z.e@gmail.com',')jzc#qbl1g','Turkey',NULL,'avatar.png','148890325',NULL,NULL,'active','dark','€','686743','2025-09-11 09:16:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','0','pending');
INSERT INTO `users` (`id`,`user_id`,`role`,`full_name`,`balance`,`profit`,`bonus`,`won`,`loss`,`eth_balance`,`username`,`email`,`password`,`country`,`gender`,`image`,`phone_number`,`package`,`package_status`,`status`,`mode`,`currency`,`token`,`date`,`account_number`,`account_name`,`bank`,`swift_code`,`bitcoin_wallet`,`eth_wallet`,`cash_app`,`paypal`,`acct_status`,`ether`,`doge`,`bito`,`usd`,`kycs`) VALUES ('148','bUJsTLOxgWJM5OtHqJ2A',NULL,'Gregory Hamilton','0','0','0','0','0','0','schmidtmary3777','l.yn.n.e.r.i.z.ada@gmail.com','^a1pfxs80x','Chile',NULL,'avatar.png','2553070707',NULL,NULL,'active','dark','£','592869','2025-09-11 09:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','0','pending');