· 6 years ago · Sep 20, 2019, 06:54 AM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET AUTOCOMMIT = 0;
3START TRANSACTION;
4SET time_zone = "+00:00";
5
6DROP TABLE IF EXISTS `address`;
7CREATE TABLE IF NOT EXISTS `address` (
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
10 `email` varchar(190) COLLATE utf8_unicode_ci NOT NULL,
11 `created_at` timestamp NULL DEFAULT NULL,
12 `updated_at` timestamp NULL DEFAULT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
15
16INSERT INTO `address` (`id`, `address`, `email`, `created_at`, `updated_at`) VALUES
17(1, '3BcxbGsHCUSHyVvkb7tB4vJem3UHvaKPkn', 'test@gmail.com', NULL, NULL);
18
19DROP TABLE IF EXISTS `bank`;
20CREATE TABLE IF NOT EXISTS `bank` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
23 `bank_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
24 `acc_num` bigint(50) NOT NULL,
25 `acc_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
26 `domain` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
27 `userid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
28 `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
29 `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
30 `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
31 `box2` mediumtext COLLATE utf8_unicode_ci NOT NULL,
32 `box3` mediumtext COLLATE utf8_unicode_ci NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=MyISAM AUTO_INCREMENT=236012 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36INSERT INTO `bank` (`id`, `email`, `bank_name`, `acc_num`, `acc_name`, `domain`, `userid`, `password`, `status`, `type`, `box2`, `box3`) VALUES
37(235980, 'yung.norbs@yandex.com', 'VisaCard', 543335433354333543, 'Micheal Stephen', 'visa.com', '08/41', '094', 'verified', 'card', '', 'DELETED'),
38(235981, 'yung.norbs@yandex.com', 'CapitalOne', 93335433, 'Micheal Stephen', 'capitalone.com', 'odu31', 'Pouslses232', 'verified', 'bank', '', 'DELETED'),
39(235982, 'yung.norbs360@gmail.com', 'Royal Bank of Canada - RBC', 480304700, 'Old Steven', 'rbc.com', '30370242', 'axscdcfbgscdc', '', 'bank', '', ''),
40(235984, 'yung.norbs360@gmail.com', 'Bank of America - BOA', 38047007201, 'Micheal Stven', 'bankofamerica.com', 'miven3903', 'policescale12309', '', 'bank', '', ''),
41(236002, 'obehistephen@gmail.com', 'MasterCard', 5491687110981112, 'Micheal Solomon', 'mastercard.com', '03/19', '154', '', 'card', '', ''),
42(236001, 'obehistephen@gmail.com', 'National WestMinister Bank (Natwest)', 503489701, 'Micheal Solomon', 'natwest.co.uk', 'micholon701', 'pwd123', '', 'bank', '', ''),
43(235989, 'obehistephen@gmail.com', 'MasterCard', 5399173020830201, 'Daniel Mac Ezekiel', 'mastercard.com', '10/19', '222', 'verified', 'card', '', 'DELETED'),
44(235990, 'yung.norbs360@gmail.com', 'Discover', 601139033034444, 'Atedilluvian Mind', 'discover.com', '03/20', '443', 'verified', 'card', '', ''),
45(235991, 'yung.norbs360@gmail.com', 'MasterCard', 53232332, 'Paulson Melvei', 'mastercard.com', '03/18', '232', 'verified', 'card', '', ''),
46(235992, 'yung.norbs360@gmail.com', 'AmEx', 341000, '2323', '', '02/19', '3233', 'verified', 'card', '', 'DELETED'),
47(235993, 'yung.norbs360@gmail.com', 'MasterCard', 539920850302, 'Okise Andrew', 'mastercard.com', '06/21', '389', '', 'card', '', 'DELETED'),
48(235994, 'yung.norbs360@gmail.com', 'AmericanExpress', 34213213213121, '3233', '', '02/19', '2233', '', 'card', '', 'DELETED'),
49(235995, 'yung.norbs360@gmail.com', 'AmericanExpress', 342000, 'e3edc', 'americanexpress.com', '01/18', '333', '', 'card', '', 'DELETED'),
50(235996, 'yung.norbs360@gmail.com', 'BankPHB', 3980208302, 'Micheal Ajibade', 'bankphb.com', 'aj_mic', 'password123', '', 'bank', '', 'DELETED'),
51(235997, 'obehistephen@gmail.com', 'MasterCard', 5499202350504821, 'Maria Hagens', 'mastercard.com', '03/20', '154', '', 'card', '', 'DELETED'),
52(235999, 'obehistephen@gmail.com', 'MasterCard', 5399202083020101, 'Micheal Solomon', 'mastercard.com', '09/20', '154', '', 'card', '', 'DELETED'),
53(236000, 'yung.norbs@yandex.com', 'MasterCard', 5433354333543335, 'Olark Levdev', 'mastercard.com', '03/19', '154', '', 'card', '', 'DELETED'),
54(236005, 'yung.norbs360@gmail.com', 'Visa', 4665440246741264, 'Norbert Young', 'visa.com', '08/20', '403', '', 'card', '', ''),
55(236006, 'yung.norbs360@gmail.com', 'MasterCard', 5399232040404801, 'Success Obehi Stephen', 'mastercard.com', '03/19', '433', '', 'card', '', ''),
56(236007, 'yung.norbs360@gmail.com', 'CapitalOne', 390230030, 'Norbert Young', 'capitalone.com', 'norbertyg', 'securepassy1220', '', 'bank', '', 'DELETED'),
57(236008, 'joyceloed212@gmail.com', 'Bank of America - BOA', 325078008007, 'Runyang Lin', 'bankofamerica.com', 'allenbreed224@gmail.com', 'cookcook1', '', 'bank', '', ''),
58(236009, 'katuri5918@gmail.com', 'Visa', 4190023005739069, 'Lori Enfield', 'visa.com', '08/18', '776', '', 'card', '', 'DELETED'),
59(236010, 'niabigby@mail.com', 'Visa', 4169940261518373, 'Nia Bigby', 'visa.com', '02/21', '507', '', 'card', '', 'DELETED'),
60(236011, 'niabigby@mail.com', 'bofl federal bank', 9000145189666254, 'Nia Bigby', 'netspend.com', 'niabigby', 'Money12!', '', 'bank', '', 'DELETED');
61
62DROP TABLE IF EXISTS `history`;
63CREATE TABLE IF NOT EXISTS `history` (
64 `id` int(15) NOT NULL AUTO_INCREMENT,
65 `frm_acc_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
66 `to_acc_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
67 `date_day` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
68 `date_month` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
69 `date_year` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
70 `time` time NOT NULL,
71 `amount` float NOT NULL,
72 `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
73 `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
74 `task` mediumtext COLLATE utf8_unicode_ci NOT NULL,
75 `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
76 `paid_frm_bal` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
77 `box` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
78 `box2` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
79 PRIMARY KEY (`id`)
80) ENGINE=MyISAM AUTO_INCREMENT=13239 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
81
82INSERT INTO `history` (`id`, `frm_acc_id`, `to_acc_id`, `date_day`, `date_month`, `date_year`, `time`, `amount`, `type`, `description`, `task`, `status`, `paid_frm_bal`, `box`, `box2`) VALUES
83(13234, 'yung.norbs360@gmail.com', 'obehistephen@gmail.com', '27', 'Sep', '', '01:14:26', 134001, 'Gift', '', '', 'uncleared', 'Main Balance', '', ''),
84(13235, 'obehistephen@gmail.com0', 'yung.norbs360@gmail.com', '27', 'Sep', '', '01:14:26', 98000, 'Gift', 'Payment for property #34003 Old Hampton', 'The buyer is requesting that you send tax related documents for the purchase before the claims can be cleared.', 'cleared', 'Main Balance', '', ''),
85(13236, 'davidcjackman902@gmail.com', 'katuri5918@gmail.com', '10', 'Apr', '2018', '01:14:26', 85000, 'Gift', 'Payment for property loan reimbursement', '', 'uncleared', 'BTC Balance', '', ''),
86(13237, 'davidcjackman902@gmail.com', 'katuri5918@gmail.com', '10', 'Apr', '2018', '01:58:26', 315000, 'Gift', 'Balance Payment to total 400 grand', '', 'uncleared', 'BTC Balance', '', ''),
87(13238, 'sigurd.karoline14@gmail.com', 'shahjugal7@gmail.com', '12', 'Jun', '2018', '05:38:26', 25000, 'Gift', 'bitcoins exchange request from Karoline', '', 'uncleared', 'BTC Balance', '', '');
88
89DROP TABLE IF EXISTS `sessions`;
90CREATE TABLE IF NOT EXISTS `sessions` (
91 `id` int(11) NOT NULL AUTO_INCREMENT,
92 `login` text COLLATE utf8_unicode_ci NOT NULL,
93 `email` varchar(190) COLLATE utf8_unicode_ci NOT NULL,
94 `created_at` timestamp NULL DEFAULT NULL,
95 `updated_at` timestamp NULL DEFAULT NULL,
96 PRIMARY KEY (`id`)
97) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
98
99INSERT INTO `sessions` (`id`, `login`, `email`, `created_at`, `updated_at`) VALUES
100(1, '$2y$10$m2EwcGlHYpGSG5g7EMvsZeIa7gaD0X976YoFx1Z4DXyHN1yW3RcRe', 'test@gmail.com', NULL, NULL);
101
102DROP TABLE IF EXISTS `users2`;
103CREATE TABLE IF NOT EXISTS `users2` (
104 `id` int(11) NOT NULL AUTO_INCREMENT,
105 `oauth_provider` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
106 `oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
107 `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
108 `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
109 `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
110 `gender` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
111 `locale` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
112 `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
113 `profile_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
114 `created` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
115 `modified` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
116 `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
117 `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
118 `main_bal` float NOT NULL,
119 `uncleared_bal` float NOT NULL,
120 `euro_bal` float NOT NULL,
121 `address` text COLLATE utf8_unicode_ci NOT NULL,
122 `sec_qst` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
123 `sec_ans` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
124 `nok_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
125 `nok_contact` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
126 `nok_relationship` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
127 `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
128 `box` text COLLATE utf8_unicode_ci NOT NULL,
129 `confirm_mail` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
130 `email2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
131 `box2` text COLLATE utf8_unicode_ci NOT NULL,
132 `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
133 `zipcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
134 `add_btc` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
137
138INSERT INTO `users2` (`id`, `oauth_provider`, `oauth_uid`, `first_name`, `last_name`, `email`, `gender`, `locale`, `picture`, `profile_url`, `created`, `modified`, `status`, `phone`, `main_bal`, `uncleared_bal`, `euro_bal`, `address`, `sec_qst`, `sec_ans`, `nok_name`, `nok_contact`, `nok_relationship`, `password`, `box`, `confirm_mail`, `email2`, `box2`, `country`, `zipcode`, `add_btc`) VALUES
139(28, 'facebook', '1960222174232606', 'Scibrain', 'Scibrain', 'obehistephen@gmail.com0', '', 'en_US', 'https://scontent.xx.fbcdn.net/v/t1.0-1/21272653_1948013228786834_1273908514287852716_n.jpg?oh=bda6c16e4edb9098322dd528392fe54a&oe=5A82D87A', 'https://www.facebook.com/app_scoped_user_id/1960222174232606/', '2017-10-06 20:22:49', '', '30', '', 526001, 268002, 0, '', '', '', '', '', '', '', '', '1', '', '', '', '', NULL),
140(29, 'email', '481430858', 'Norbert', 'Young', 'yung.norbs360@gmail.com', 'Male', 'Bradford', 'https://www.bitcoinremit.bid/home/uploads/IMGCAPTURE 2017-01-05 00-03-09.jpg', '', '2017-10-06 20:22:49', '2018-04-02 01:48:33 AM', '20', '152', 0, 72.5, 0, '37 Sunbridge Rd', '', '', 'John Potter', 'tardy@energica.us', 'Cousin', 'SCIbrain12345', '', '1', '', '1985-12-25', 'United Kingdom', 'BD12AA', NULL),
141(31, 'facebook', '1960222174232606', 'Scibrain', 'Scibrain', 'obehistephen@gmail.com00', '', 'en_US', 'https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/21272653_1948013228786834_1273908514287852716_n.jpg?oh=bda6c16e4edb9098322dd528392fe54a&oe=5A82D87A&__gda__=1513850513_c9cf0813adf443f2565b1cdbd261cd2e', 'https://www.facebook.com/app_scoped_user_id/1960222174232606/', '2017-10-08 23:15:57', '', '30', '', 0, 0, 0, '', '', '', '', '', '', '', '', '1', '', '', '', '', NULL),
142(32, 'facebook', '1960222174232606', 'Scibrain', 'Scibrain', 'obehistephen@gmail.com00000', '', 'en_US', 'https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/21272653_1948013228786834_1273908514287852716_n.jpg?oh=bda6c16e4edb9098322dd528392fe54a&oe=5A82D87A&__gda__=1513850513_c9cf0813adf443f2565b1cdbd261cd2e', 'https://www.facebook.com/app_scoped_user_id/1960222174232606/', '2017-10-08 23:20:44', '', '30', '', 0, 0, 0, '', '', '', '', '', '', '', '', '1', '', '', '', '', NULL),
143(37, 'facebook', '1960222174232606', 'Scibrain', 'Scibrain', 'obehistephen@gmail.com000', '', 'en_US', 'https://fb-s-a-a.akamaihd.net/h-ak-fbx/v/t1.0-1/21272653_1948013228786834_1273908514287852716_n.jpg?oh=bda6c16e4edb9098322dd528392fe54a&oe=5A82D87A&__gda__=1513850513_c9cf0813adf443f2565b1cdbd261cd2e', 'https://www.facebook.com/app_scoped_user_id/1960222174232606/', '2017-10-08 23:36:23', '', '30', '', 0, 134001, 0, '', '', '', '', '', '', '', '', '1', '', '', '', '', NULL),
144(38, 'email', '227195602', 'Micheal', 'Solomon', 'obehistephen@gmail.com', 'Male', 'London', 'http://localhost/fb-wallet/home/uploads/0322schiff.jpg', '', '2017-10-08 23:36:23', '2018-03-31 02:56:48 PM', '50', '+15204420395', 0, 134001, 0, '54 Haymarket', 'Whats the name of your high school?', 'Kings College', 'John Potter', '37 Sunbridge Rd', 'Son', 'Hmd12345', '', '', '', '1945-12-12', 'United Kingdom', 'BD71DP', NULL),
145(50, 'email', '156105310', 'Tardy', 'Leonid', 'tardy_leonid@yahoo.com', '', 'en-US,', '', '', '2018-03-30 09:34:05 PM', '2018-04-01 06:57:06 PM', '20', '', 0, 0, 0, '', '', '', '', '', '', 'SCIbrain123', '', '', '', '', '', '', NULL),
146(51, 'email', '343916893', 'Scibrain', 'Stephen', 'tardy@energica.us', 'Male', 'en-US,', 'https://www.bitcoinremit.bid/home/uploads/0322schiff.jpg', '', '2018-03-30 10:43:09 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'hmd123', '', '', '', '', '', '', NULL),
147(52, 'email', '319684097', 'David', 'Holdenfort', 'engrholdenfort@gmail.com', 'Male', 'Fredonia', 'http://localhost/24CoinOption/coins/home/uploads/johansen-passport.jpg', '', '2018-03-31 03:23:36 PM', '2019-09-13 09:09:17 PM', '40', '', 0, 0, 0, '10401 Bennett Road, Fredonia NY', 'What was your first Job?', 'Pastor', 'Bryan Harry Jnr', 'allformelee274@gmail.com', 'Son', 'hmd123', '', '', '', '1990-12-25', 'United States', '14063', NULL),
148(53, 'email', '815050107', 'Chad', 'Rader', 'chicknman26@gmail.com', 'Male', 'Greeneville', 'https://www.bitcoinremit.uk/home/uploads/download_20180218_114904.jpg', '', '2018-04-05 01:11:52 AM', '2018-04-05 01:26:57 AM', '50', '+14232938884', 0, 0, 0, '720 Sanders Rd', 'In what town were you born?', 'Greeneville', 'Kathy Browning', '4235889290', 'Mother', 'Materrader2675', '', '', '', '1975-04-26', 'United States', '37743', NULL),
149(54, 'email', '999468125', 'allen', 'breed', 'allenbreed224@gmail.com', '', 'en-US,', '', '', '2018-04-06 05:55:36 AM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'cookcook1', '', '', '', '', '', '', NULL),
150(55, 'email', '975338123', 'Runyang ', 'Lin', 'joyceloed212@gmail.com', 'Female', 'california', 'https://www.bitcoinremit.uk/home/uploads/13256368_706803576129487_8901466892688417972_n.jpg', '', '2018-04-06 06:11:51 AM', '', '30', '', 0, 0, 0, '1501 Nogales st Rowland heights ', '', '', 'allen breed', 'allenbreed224@gmail.com', '61063403016', 'cookcook1', '', '', '', '1970-09-22', 'United States', '91748', NULL),
151(56, 'email', '249637313', 'Lori', 'Enfield', 'katuri5918@gmail.com', 'Female', 'Shawnee', '', '', '2018-04-10 03:08:28 AM', '2018-04-11 12:27:03 AM', '80', '+17633505918', 0, 400000, 0, '7150 Lackman Road Apt 1502', 'Whats the name of your high school?', 'Irondale', 'Jim Enfield', '218-573-3686', 'Father', 'jump4joy', '', '', '', '1965-05-20', 'United States', '66217', NULL),
152(57, 'email', '', 'David', 'Jackman', 'davidcjackman902@gmail.com', '', 'en-us', '', '', '2018-04-10 03:08:28 AM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'invalidstring123', '', '', '', '', '', '', NULL),
153(58, 'email', '150935457', 'stewart ', 'sarah ', 'stewartsarah256@gmail.com000', '', 'en-us', '', '', '2018-04-27 02:46:29 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'adeyemipablo', '', '', '', '', '', '', NULL),
154(59, 'email', '66237190', 'Nia', 'Bigby', 'niabigby@mail.com00', '', 'en-US,', '', '', '2018-04-29 11:23:57 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'Money12!', '', '', '', '', '', '', NULL),
155(60, 'email', '991718679', 'jason', 'mark', 'jasonmark037@gmail.com000', '', 'en-GB,', '', '', '2018-05-29 06:17:07 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'ibusa123', '', '', '', '', '', '', NULL),
156(61, 'email', '493513904', 'Muzahir', 'Tunio', 'muzahir.justtravel@gmail.com', 'Male', 'en-US,', 'https://www.bitcoinremit.uk/home/uploads/IMG-20170725-WA0060.jpg', '', '2018-06-12 08:24:35 AM', '', '20', '', 0, 0, 0, '', '', '', 'Muzahir Tunio', 'muzahir.justtravel@gmail.com', 'Single', 'MAryam.968', '', '', '', '1993-12-15', '', '', NULL),
157(62, 'email', '', 'Karoline', 'Sigurd', 'sigurd.karoline14@gmail.com', 'Female', 'en_US', '', '', '', '', '95', '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
158(63, 'email', '703313008', 'matt', 'damon', 'marley@kush.edu', '', 'en-US,', '', '', '2018-06-12 05:22:11 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'csjcs,xsx', '', '', '', '', '', '', NULL),
159(64, 'email', '540642713', 'Scibrain', 'Stephen', 'webmaster@bwe.com.ng', '', 'en-US,', '', '', '2018-06-27 08:33:19 AM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'hmd123', '', '', '', '', '', '', NULL),
160(65, 'email', '668252635', 'Doreen', 'Whalley', 'dorwhalley@gmail.com', '', 'en-us', '', '', '2018-08-03 11:41:43 AM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'Franziska', '', '', '', '', '', '', NULL),
161(66, 'email', '999043772', 'Nobert', 'Young', 'user2@xixmail.com', '', 'en-US,', '', '', '2018-10-03 07:32:08 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'hmd123', '', '', '', '', '', '', NULL),
162(67, 'email', '882849490', 'test', 'user', 'test@gmail.com', '', 'en-US,', '', '', '2018-12-14 08:08:46 PM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'test1234', '', '', '', '', '', '', '1.2'),
163(68, 'email', '203316783', 'Bryan', 'Harry', 'allformelee274@gmail.com', '', 'en-US,', '', '', '2019-09-14 07:55:46 AM', '', '20', '', 0, 0, 0, '', '', '', '', '', '', 'qwerty', '', '', '', '', '', '', NULL);
164
165DROP TABLE IF EXISTS `verify`;
166CREATE TABLE IF NOT EXISTS `verify` (
167 `id` int(10) NOT NULL AUTO_INCREMENT,
168 `step` int(10) NOT NULL,
169 `email` mediumtext COLLATE utf8_unicode_ci NOT NULL,
170 `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
171 `type` mediumtext COLLATE utf8_unicode_ci NOT NULL,
172 `status` mediumtext COLLATE utf8_unicode_ci NOT NULL,
173 `time` mediumtext COLLATE utf8_unicode_ci NOT NULL,
174 PRIMARY KEY (`id`)
175) ENGINE=MyISAM AUTO_INCREMENT=345385 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
176
177INSERT INTO `verify` (`id`, `step`, `email`, `name`, `type`, `status`, `time`) VALUES
178(345366, 1, 'joyceloed212@gmail.com', 'uploads/13256368_706803576129487_8901466892688417972_n.jpg', 'ID/Passport Document', 'Pending', '2018-04-06 06:21:45'),
179(345364, 3, 'yung.norbs360@gmail.com0', 'uploads/2000qar.jpg', 'Address Verification Documents', 'Pending', '2018-04-05 11:50:24'),
180(345362, 1, 'yung.norbs360@gmail.com0', 'uploads/_AQP7980.JPG', 'ID/Passport Document', 'Pending', '2018-04-05 11:44:56'),
181(345363, 2, 'yung.norbs360@gmail.com0', 'uploads/0afd88e0-3f21-40b3-85b8-f7bd34dc78c9.jpg', 'ID Selfie Verification', 'Pending', '2018-04-05 11:49:16'),
182(345377, 1, 'yung.norbs360@gmail.com', 'uploads/IMG37080952.jpg', 'ID/Passport Document', 'Pending', '2018-04-11 11:21:33'),
183(345381, 1, 'test@gmail.com', 'uploads/wallet.PNG', 'ID/Passport Document', 'Verified', '2018-12-16 06:33:39'),
184(345382, 2, 'test@gmail.com', 'uploads/Capture.PNG', 'ID Selfie Verification', 'Pending', '2018-12-16 06:33:55'),
185(345383, 3, 'test@gmail.com', 'uploads/Capture.PNG', 'Address Verification Documents', 'Pending', '2018-12-16 06:34:05'),
186(345384, 4, 'test@gmail.com', 'uploads/Capture.PNG', 'Physical Card Verification', 'Pending', '2018-12-16 06:34:10');
187
188DROP TABLE IF EXISTS `withdrawls`;
189CREATE TABLE IF NOT EXISTS `withdrawls` (
190 `id` int(11) NOT NULL AUTO_INCREMENT,
191 `code` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
192 `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
193 `amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
194 `created_at` timestamp NULL DEFAULT NULL,
195 `updated_at` timestamp NULL DEFAULT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
198
199INSERT INTO `withdrawls` (`id`, `code`, `address`, `amount`, `created_at`, `updated_at`) VALUES
200(1, 'u7p3fECA6fbepHB8X9zuULSxVBWBRINgZSEMe5Dyqw0httfWGHe8aMSR5QNl', '456465', '564564', NULL, NULL),
201(2, '2eGcf8fdW38hL89SGbXv2rwKw6dP2ttXjORct4bpz2XtEmROpsddH5TH6a91', '456465', '0.1', NULL, NULL),
202(4, 'TCuKGxScVBCo9z0WpfDm6ETQcZrPP8NngigBDgiqAChdk4UkgviwN2UsqcyI', '2Mu7tBF6fxB1QBLs8GdDraU8vedbDZTpmUT', '0.01', NULL, NULL),
203(6, 'vSTCwdtpr1MWQ4txgi0icali9D4JHpXSw9Hplg2euVCr4JndD18ODhdTdAjE', '2N2GR4eapX8w1Cp8RjtgPwvCtZ4p5MbESVq', '0.01', NULL, NULL);
204COMMIT;