-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 16, 2023 at 06:54 PM -- Server version: 10.3.38-MariaDB-cll-lve -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `operypig_pushup` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(255) UNSIGNED NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `uname` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `email`, `password`, `uname`) VALUES (1, 'admin@yahoo.com', 'workings', ''); -- -------------------------------------------------------- -- -- Table structure for table `ad_clicks` -- CREATE TABLE `ad_clicks` ( `id` int(255) UNSIGNED NOT NULL, `email` varchar(255) NOT NULL, `ad_id` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int(255) UNSIGNED NOT NULL, `cate_name` varchar(255) NOT NULL, `pro_pic` varchar(255) NOT NULL, `ad_num` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `coins` -- CREATE TABLE `coins` ( `id` int(255) UNSIGNED NOT NULL, `wallet_img` varchar(255) NOT NULL, `wallet_address` varchar(255) NOT NULL, `coin_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `coins` -- INSERT INTO `coins` (`id`, `wallet_img`, `wallet_address`, `coin_name`) VALUES (1, 'bitcoin.png', '3NPUrcpMybNFj9boqcHHRBfCQ8xPC2bARN', 'bitcoin'), (2, 'ethereum.png', '0x515A4769d011d746A27B0DB4613eE89dE539026A', 'ethereum'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int(255) UNSIGNED NOT NULL, `email` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `package` varchar(255) NOT NULL, `date_x_time` varchar(255) NOT NULL, `advert_name` varchar(255) NOT NULL, `note_advert` varchar(5000) NOT NULL, `trans_id` varchar(255) NOT NULL, `status` varchar(255) NOT NULL, `succcess_code` varchar(255) NOT NULL, `duration` varchar(255) NOT NULL, `ad_cate` varchar(255) NOT NULL, `product_image` varchar(255) NOT NULL, `description` varchar(50000) NOT NULL, `ad_type` varchar(255) NOT NULL, `clicks` varchar(255) NOT NULL, `main_post` varchar(255) NOT NULL, `click_paid` varchar(255) NOT NULL, `website_url` varchar(5000) NOT NULL, `approval` varchar(255) NOT NULL, `email_trans` varchar(255) NOT NULL, `payment_type` varchar(255) NOT NULL, `purpose` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `email`, `amount`, `package`, `date_x_time`, `advert_name`, `note_advert`, `trans_id`, `status`, `succcess_code`, `duration`, `ad_cate`, `product_image`, `description`, `ad_type`, `clicks`, `main_post`, `click_paid`, `website_url`, `approval`, `email_trans`, `payment_type`, `purpose`) VALUES (2, 'pronuxtech@gmail.com', '1000', '', '2022-Mar-14', '', '', '092458', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (3, 'pronuxtech@gmail.com', '1000', '', '2022-Mar-15', '', '', '034627', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (4, 'pronuxtech@gmail.com', '100', '', '2022-Mar-15', '', '', '796032', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (5, 'pronuxtech@gmail.com', '100', '', '2022-Mar-15', '', '', '841370', '', '013547', '', '', '', '', '', '', '', '', '', '', '', '', ''), (6, 'pronuxtech@gmail.com', '100', '', '2022-Mar-15', '', '', '630215', 'active', '715032', '', '', '', '', '', '', '', '', '', '', '', '', ''), (7, 'pronuxtech@gmail.com', '800', '', '2022-Mar-18', '', '', '193267', '', '584732', '', '', '', '', '', '', '', '', '', '', '', '', ''), (9, 'pushupbrands@gmail.com', '400', '', '2022-Mar-18', '', '', '751694', '', '403689', '', '', '', '', '', '', '', '', '', '', '', '', ''), (10, 'toskyonline@gmail.com', '100', '', '2022-Mar-20', '', '', '739108', '', '294760', '', '', '', '', '', '', '', '', '', '', '', '', ''), (11, 'toskyonline@gmail.com', '100', '', '2022-Mar-20', '', '', '623857', 'active', '203168', '', '', '', '', '', '', '', '', '', '', '', '', ''), (12, 'bitblocktrades@gmail.com', '500', '', '', '', '', '610845', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (13, 'bitblocktrades@gmail.com', '500', '', '', '', '', '037854', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (14, 'bitblocktrades@gmail.com', '600', '', '', '', '', '382975', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (15, 'bitblocktrades@gmail.com', '600', '', '', '', '', '725104', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (16, 'bitblocktrades@gmail.com', '700', '', '', '', '', '906254', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (17, 'bitblocktrades@gmail.com', '700', '', '', '', '', '289764', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (18, 'bitblocktrades@gmail.com', '777', '', '', '', '', '621309', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (19, 'bitblocktrades@gmail.com', '66', '', '', '', '', '902153', 'successful', '', '', '', '', '', '', '', '', '', '', '', '1', 'bitcoin', 'Account Funding'), (20, 'bitblocktrades@gmail.com', '600', '', '', '', '', '387125', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (21, 'bitblocktrades@gmail.com', '600', '', '', '', '', '098372', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (22, 'bitblocktrades@gmail.com', '700', '', '', '', '', '724053', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (23, 'bitblocktrades@gmail.com', '700', '', '', '', '', '123658', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (24, 'bitblocktrades@gmail.com', '900', '', '', '', '', '026719', 'successful', '', '', '', '', '', '', '', '', '', '', '', '1', 'bitcoin', 'Account Funding'), (25, 'bitblocktrades@gmail.com', '50', '', '', '', '', '781932', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'withdrawal'), (26, 'bitblocktrades@gmail.com', '400', '', '', '', '', '706913', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'withdrawal'), (27, 'dandyglobal2@gmail.com', '500', '', '', '', '', '297401', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (28, 'dandyglobal2@gmail.com', '500', '', '', '', '', '903264', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'ethereum', 'Account Funding'), (29, 'dandyglobal2@gmail.com', '200', '', '', '', '', '847106', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (30, 'dandyglobal2@gmail.com', '5000', '', '17 April 2022', 'EARN OVER $3000 DAILY', '', '675234', 'active', '', '3 days', 'Internet services', 'Screenshot_2022-04-17-10-22-29-611_com.android.chrome.jpg', 'Exchange and earn instantly', 'services', '9', '', '1000000', 'https://allprofittrade.com/', '', '', '', 'advert'), (31, 'dandyglobal2@gmail.com', '3000', '', '', '', '', '869054', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'withdrawal'), (32, 'dandyglobal2@gmail.com', '150', '', '05 May 2022', 'make money online', '', '927056', 'pending', '', '3 days', 'Internet services', '', 'earn unlimitedly', '', '', '', '10000', 'www.cointiply.com', '', '', '', 'advert'), (33, 'richygrace4real@gmail.com', '1500', '', '05 May 2022', 'Platform for unlimited income', '', '743586', 'active', '', '3 days', 'Internet services', '', 'Sign up to earn by viewing ads', '', '7', '', 'Select Clicks', 'https://www.buxinside.com/', '', '', '', 'advert'), (34, 'richygrace4real@gmail.com', '1500', '', '05 May 2022', '', '', '045976', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (35, 'richygrace4real@gmail.com', '200', '', '05 May 2022', '', '', '179583', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (36, 'dandyglobal2@gmail.com', '40', '', '17 May 2022', 'cryto world', '', '237851', 'active', '', '3 days', '', '', 'Earn crypto using coinmarketcap', 'services', '7', '', '300000', 'https://coinmarketcap.com/', '', '', '', 'advert'), (37, 'dandyglobal2@gmail.com', '500', '', '18 May 2022', 'BUY ONLINE', '', '382701', 'active', '', '3 days', '', '', 'Buy all you need online using our platform', 'services', '4', '', '1000000', 'https://best.aliexpress.com/', '', '', '', 'advert'), (38, 'dandyglobal2@gmail.com', '1000', '', '18 May 2022', 'TRADE WITH US', '', '029136', 'active', '', '14 days', '', '', 'MAKE INCOME TRADING WITH US', 'services', '6', '', '500000', 'https://www.binance.com/', '', '', '', 'advert'), (41, 'dandyglobal2@gmail.com', '2000', '', '20 May 2022', '', '', '174908', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (42, 'dandyglobal2@gmail.com', '600', '', '20 May 2022', '', '', '983106', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'ethereum', 'Account Funding'), (43, 'dandyglobal2@gmail.com', '1500', '', '20 May 2022', '', '', '540738', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (44, 'dandyglobal2@gmail.com', '2000', '', '20 May 2022', '', '', '367025', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (45, 'dandyglobal2@gmail.com', '65', '', '12 August 2022', '', '', '910687', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'withdrawal'), (46, 'dandyglobal2@gmail.com', '66', '', '12 August 2022', '', '', '374012', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'ethereum', 'Account Funding'), (47, 'dandyglobal2@gmail.com', '701', '', '12 August 2022', '', '', '781429', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'), (48, 'dandyglobal2@gmail.com', '700', '', '12 August 2022', '', '', '871304', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'ethereum', 'Account Funding'), (49, 'dandyglobal2@gmail.com', '800', '', '12 August 2022', '', '', '276391', 'pending', '', '', '', '', '', '', '', '', '', '', '', '', 'bitcoin', 'Account Funding'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(255) UNSIGNED NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `uname` varchar(255) NOT NULL, `account_balance` varchar(255) NOT NULL, `users_code` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `source_of_meeting` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `company_name` varchar(255) NOT NULL, `date_joined` varchar(255) NOT NULL, `pro_pic` varchar(255) NOT NULL, `two_fa_code` varchar(255) NOT NULL, `pushcoin` varchar(255) NOT NULL, `zip_code` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `total_profit` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `fname`, `lname`, `uname`, `account_balance`, `users_code`, `phone`, `password`, `email`, `source_of_meeting`, `country`, `address`, `company_name`, `date_joined`, `pro_pic`, `two_fa_code`, `pushcoin`, `zip_code`, `city`, `total_profit`) VALUES (1, '', 'smells', 'johson2', '9614', '76777', '', 'p', 'bitblocktrades@gmail.com', '', '', '', '', '', '', '', '300', '', '', ''), (2, '', '', 'Johnpaul', '', '187240', '7047650514', 'london', 'pushupbrands@gmail.com', '', '', '', '', '18 March 2022', '', '', '', '', '', ''), (3, '', '', 'tosky', '100', '879024', '08063626633', 'london', 'toskyonline@gmail.com', '', '', '', '', '20 March 2022', '', '', '', '', '', ''), (4, '', '', 'kenny', '38460', '085341', '07023889287', 'pushup.com', 'dandyglobal2@gmail.com', '', '', '', '', '29 March 2022', '', '', '390', '', '', ''), (5, '', '', 'konja', '4000', '981470', '07063663633', 'london', 'richygrace4real@gmail.com', '', '', '', '', '31 March 2022', '', '', '45', '', '', ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ad_clicks` -- ALTER TABLE `ad_clicks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `coins` -- ALTER TABLE `coins` 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`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `ad_clicks` -- ALTER TABLE `ad_clicks` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `coins` -- ALTER TABLE `coins` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;