· 9 years ago · Oct 16, 2016, 01:46 PM
1-- Adminer 4.2.4 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `botters`;
9CREATE TABLE `botters` (
10 `iduser` int(11) NOT NULL AUTO_INCREMENT,
11 `name` varchar(200) NOT NULL,
12 `token_access` varchar(200) NOT NULL,
13 `jenis` enum('chose','like','comment','mati') NOT NULL,
14 `status` enum('On','Off') NOT NULL,
15 `Datetime` varchar(200) NOT NULL,
16 PRIMARY KEY (`iduser`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1;
18
19
20DROP TABLE IF EXISTS `categories`;
21CREATE TABLE `categories` (
22 `CategoryID` int(244) NOT NULL AUTO_INCREMENT,
23 `CategoryName` blob NOT NULL,
24 `CategoryDescription` blob NOT NULL,
25 `CategoryCreatedDate` int(244) NOT NULL,
26 PRIMARY KEY (`CategoryID`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29INSERT INTO `categories` (`CategoryID`, `CategoryName`, `CategoryDescription`, `CategoryCreatedDate`) VALUES
30(1, 'Facebook', 'Facebook', 1475907498),
31(2, 'Instagram', 'Instagram', 1475907520),
32(3, 'Twitter', 'Twitter', 1475907529),
33(4, 'Youtube', 'Youtube', 1475907541),
34(5, 'Google Plus', 'Google Plus', 1475907557),
35(6, 'Vine', 'Vine', 1475907569),
36(7, 'SoundCloud', 'SoundCloud', 1475907581),
37(8, 'Website', 'Website', 1475907591);
38
39DROP TABLE IF EXISTS `deposits`;
40CREATE TABLE `deposits` (
41 `DepositID` int(244) NOT NULL AUTO_INCREMENT,
42 `DepositUserID` int(244) NOT NULL,
43 `DepositDate` int(244) NOT NULL,
44 `DepositAmount` varchar(244) CHARACTER SET latin1 NOT NULL,
45 `DepositVerification` blob NOT NULL,
46 `DepositGateway` enum('Paypal','Skrill') NOT NULL,
47 PRIMARY KEY (`DepositID`),
48 KEY `deposituserid` (`DepositUserID`),
49 CONSTRAINT `deposituserid` FOREIGN KEY (`DepositUserID`) REFERENCES `users` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51
52
53DROP TABLE IF EXISTS `logs`;
54CREATE TABLE `logs` (
55 `LogID` int(244) NOT NULL AUTO_INCREMENT,
56 `LogUserID` int(244) NOT NULL,
57 `LogDate` int(244) NOT NULL,
58 `LogIPAddress` blob NOT NULL,
59 PRIMARY KEY (`LogID`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62INSERT INTO `logs` (`LogID`, `LogUserID`, `LogDate`, `LogIPAddress`) VALUES
63(1, 1, 1475902625, '114.120.237.239'),
64(2, 2, 1475908931, '115.178.235.74'),
65(3, 2, 1475909835, '115.178.254.24'),
66(4, 2, 1475911151, '115.178.254.24'),
67(5, 2, 1475911700, '115.178.254.24'),
68(6, 2, 1475911717, '115.178.254.24'),
69(7, 2, 1475911758, '115.178.254.24'),
70(8, 3, 1475912053, '114.125.175.46'),
71(9, 4, 1475943825, '114.125.61.131'),
72(10, 1, 1476011228, '114.120.239.99'),
73(11, 1, 1476020526, '114.120.239.99'),
74(12, 1, 1476020559, '114.121.237.56'),
75(13, 1, 1476020577, '114.121.237.56'),
76(14, 1, 1476020593, '114.121.237.56'),
77(15, 1, 1476020743, '114.121.237.56'),
78(16, 1, 1476020787, '114.121.237.56'),
79(17, 1, 1476020844, '114.121.237.56'),
80(18, 1, 1476021009, '114.121.237.56'),
81(19, 1, 1476021316, '114.121.237.56'),
82(20, 1, 1476021382, '114.121.237.56'),
83(21, 1, 1476021408, '114.121.237.56'),
84(22, 1, 1476021515, '114.121.237.56'),
85(23, 1, 1476021529, '114.121.237.56'),
86(24, 1, 1476021612, '114.121.237.56'),
87(25, 5, 1476024977, '202.67.46.19'),
88(26, 1, 1476025375, '114.121.237.56'),
89(27, 5, 1476025698, '202.67.46.19'),
90(28, 1, 1476028260, '114.121.237.56'),
91(29, 1, 1476076362, '114.121.237.56'),
92(30, 6, 1476079372, '36.83.52.237'),
93(31, 7, 1476081332, '118.136.11.85'),
94(32, 7, 1476081370, '118.136.11.85'),
95(33, 7, 1476081425, '118.136.11.85'),
96(34, 8, 1476082495, '114.79.12.105'),
97(35, 9, 1476084267, '223.255.230.50'),
98(36, 10, 1476087174, '8.37.235.36'),
99(37, 1, 1476093764, '114.121.237.56'),
100(38, 11, 1476098045, '115.178.199.221'),
101(39, 12, 1476269411, '180.253.158.69'),
102(40, 12, 1476269437, '180.253.158.69'),
103(41, 13, 1476282075, '115.178.235.238'),
104(42, 13, 1476282097, '115.178.235.238'),
105(43, 14, 1476442369, '8.37.230.29'),
106(44, 1, 1476624635, '36.72.2.120'),
107(45, 15, 1476624699, '36.72.2.120');
108
109DROP TABLE IF EXISTS `merchant`;
110CREATE TABLE `merchant` (
111 `id` int(11) NOT NULL AUTO_INCREMENT,
112 `MerchantPaypalEmail` blob NOT NULL,
113 `MerchantSkrillEmail` blob NOT NULL,
114 `MerchantSkrillSecret` blob NOT NULL,
115 `MerchantWebsiteName` blob NOT NULL,
116 `MerchantRecoveryEmail` blob NOT NULL,
117 `Merchantwebsitetatus` varchar(200) NOT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=InnoDB DEFAULT CHARSET=utf8;
120
121INSERT INTO `merchant` (`id`, `MerchantPaypalEmail`, `MerchantSkrillEmail`, `MerchantSkrillSecret`, `MerchantWebsiteName`, `MerchantRecoveryEmail`, `Merchantwebsitetatus`) VALUES
122(1, '', '', '', 'My-Panels', 'admin@Mypanels.tk', 'active');
123
124DROP TABLE IF EXISTS `news`;
125CREATE TABLE `news` (
126 `NewsID` int(244) NOT NULL AUTO_INCREMENT,
127 `NewsTitle` blob NOT NULL,
128 `NewsContent` blob NOT NULL,
129 `NewsDate` int(244) NOT NULL,
130 `NewsUserID` int(244) NOT NULL,
131 PRIMARY KEY (`NewsID`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8;
133
134
135DROP TABLE IF EXISTS `orders`;
136CREATE TABLE `orders` (
137 `OrderID` int(244) NOT NULL AUTO_INCREMENT,
138 `OrderUserID` int(244) NOT NULL,
139 `OrderProductID` int(244) NOT NULL,
140 `OrderDate` int(244) NOT NULL,
141 `OrderAmount` varchar(200) NOT NULL,
142 `OrderLink` blob NOT NULL,
143 `OrderQuantity` int(244) NOT NULL,
144 `OrderStatus` enum('Unprocessed','In Process','On hold','Refunded','Completed','Removed') NOT NULL DEFAULT 'Unprocessed',
145 PRIMARY KEY (`OrderID`),
146 KEY `orderuserid` (`OrderUserID`),
147 KEY `orderproductid` (`OrderProductID`),
148 CONSTRAINT `orderproductid` FOREIGN KEY (`OrderProductID`) REFERENCES `products` (`ProductID`) ON DELETE CASCADE ON UPDATE CASCADE,
149 CONSTRAINT `orderuserid` FOREIGN KEY (`OrderUserID`) REFERENCES `users` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE
150) ENGINE=InnoDB DEFAULT CHARSET=utf8;
151
152
153DROP TABLE IF EXISTS `products`;
154CREATE TABLE `products` (
155 `ProductID` int(244) NOT NULL AUTO_INCREMENT,
156 `ProductCategoryID` int(244) NOT NULL,
157 `serviceid` int(200) NOT NULL,
158 `ProductName` blob NOT NULL,
159 `ProductDescription` blob NOT NULL,
160 `ProductMinimumQuantity` int(244) NOT NULL,
161 `ProductmaximumQuantity` int(224) NOT NULL,
162 `ProductPrice` int(255) NOT NULL,
163 `ProductAPI` blob NOT NULL,
164 `ProductCreatedDate` int(244) NOT NULL,
165 PRIMARY KEY (`ProductID`)
166) ENGINE=InnoDB DEFAULT CHARSET=utf8;
167
168INSERT INTO `products` (`ProductID`, `ProductCategoryID`, `serviceid`, `ProductName`, `ProductDescription`, `ProductMinimumQuantity`, `ProductmaximumQuantity`, `ProductPrice`, `ProductAPI`, `ProductCreatedDate`) VALUES
169(1, 3, 1, 'Followers Twitter SERVER 1', 'Followers Twitter SERVER 1', 100, 100000, 15, '', 1475914293),
170(2, 3, 3, 'Twitter Followers SERVER 3', 'Twitter Followers SERVER 3', 100, 50000, 17, '', 1476014249),
171(3, 3, 4, 'Twitter Followers SERVER 4', 'Twitter Followers SERVER 4', 1000, 50000, 11, '', 1476014249),
172(4, 3, 5, 'Twitter Followers SERVER SOSPED', 'Twitter Followers SERVER SOSPED', 100, 100000, 10, '', 1476076964),
173(5, 3, 10, 'Twitter Likes (High Quality)', 'Twitter Likes (High Quality)', 100, 1000000, 15, '', 1476076999),
174(6, 3, 11, 'Twitter Retweets', 'Twitter Retweets', 100, 1000000, 15, '', 1476077027),
175(7, 2, 19, 'Instagram Followers Indonesia', 'Instagram Followers Indonesia', 100, 15000, 77, '', 1476077150),
176(8, 2, 20, 'Instagram Followers HQ SERVER 1', 'Instagram Followers HQ SERVER 1', 100, 5000, 12, '', 1476077183),
177(9, 2, 21, 'Instagram Followers HQ SERVER 2', 'Instagram Followers HQ SERVER 2', 100, 50000, 18, '', 1476077209),
178(10, 2, 22, 'Instagram Followers HQ SERVER 4', 'Instagram Followers HQ SERVER 4', 1000, 1000, 17, '', 1476077241),
179(11, 2, 6, 'Instagram Followers S06', 'Instagram Followers S06', 100, 1000, 24, '', 1476077377),
180(12, 2, 7, 'Instagram Followers S07', 'Instagram Followers S07', 50, 1000, 20, '', 1476077413),
181(13, 2, 16, 'Instagram Followers S09', 'Instagram Followers S09', 100, 5000, 22, '', 1476077583),
182(14, 2, 17, 'Instagram Followers HQ S10', 'Instagram Followers HQ S10', 50, 5000, 26, '', 1476077822),
183(15, 2, 18, 'Instagram Followers HQ S11', 'Instagram Followers HQ S11', 100, 10000, 27, '', 1476077853),
184(16, 2, 24, 'Instagram Followers HQ S12', 'Instagram Followers HQ S12', 50, 25000, 27, '', 1476077895),
185(17, 2, 25, 'Instagram Followers HQ PED Server', 'Instagram Followers HQ PED Server', 100, 50000, 30, '', 1476077944),
186(18, 2, 23, 'Instagram Followers HQ SERVER 6', 'Instagram Followers HQ SERVER 6', 50, 20000, 25, '', 1476077971),
187(19, 2, 31, 'Instagram Likes INDONESIA', 'Instagram Likes INDONESIA', 100, 1500, 67, '', 1476077995),
188(20, 2, 28, 'Instagram Likes HQ SERVER 1', 'Instagram Likes HQ SERVER 1', 100, 10000, 9, '', 1476078024),
189(21, 2, 29, 'Instagram Likes HQ SERVER 2', 'Instagram Likes HQ SERVER 2', 100, 13000, 10, '', 1476078113),
190(22, 2, 30, 'Instagram Likes HQ SERVER 3', 'Instagram Likes HQ SERVER 3', 50, 10000, 7, '', 1476078141),
191(23, 2, 32, 'Instagram Likes HQ SERVER 4', 'Instagram Likes HQ SERVER 4', 200, 10000, 7, '', 1476078586),
192(24, 2, 33, 'Instagram Likes HQ SERVER 6', 'Instagram Likes HQ SERVER 6', 100, 10000, 8, '', 1476078647),
193(25, 2, 27, 'Instagram Video Views SERVER 1', 'Instagram Video Views SERVER 1', 100, 15000, 18, '', 1476078670),
194(26, 2, 69, 'Instagram Video Views SERVER 2', 'Instagram Video Views SERVER 2', 100, 1000000, 12, '', 1476078690),
195(27, 2, 26, 'Instagram Video Views NEW SERVER', 'Instagram Video Views NEW SERVER', 100, 500000, 22, '', 1476078736),
196(28, 2, 70, 'Instagram Video Views SERVER 3', 'Instagram Video Views SERVER 3', 100, 100000, 9, '', 1476079436),
197(29, 2, 62, 'Instagram Random Comments S1 HQ', 'Instagram Random Comments S1 HQ', 20, 1000, 27, '', 1476079468),
198(30, 1, 68, 'Facebook Followers HQ', 'Facebook Followers HQ', 500, 10000, 72, '', 1476079537),
199(31, 1, 35, 'Facebook Fanpage Likes SERVER 1', 'Facebook Fanpage Likes SERVER 1', 100, 1000000, 77, '', 1476079556),
200(32, 1, 36, 'Facebook Fanpage Likes SERVER 2', 'Facebook Fanpage Likes SERVER 2', 250, 100000, 90, '', 1476079584),
201(33, 1, 34, 'Facebook Like Post Untuk Fanspage', 'Facebook Like Post Untuk Fanspage', 100, 40000, 12, '', 1476079942),
202(34, 1, 38, 'Facebook HQ photo/post likes SERVER 2', 'Facebook HQ photo/post likes SERVER 2', 100, 9400, 18, '', 1476079976),
203(35, 1, 39, 'Facebook video views', 'Facebook video views', 5000, 1000000, 10, '', 1476080009),
204(36, 4, 40, 'Youtube Worldwide Views SERVER 1', 'Youtube Worldwide Views SERVER 1', 1000, 1000000, 12, '', 1476080044),
205(37, 4, 41, 'Youtube Worldwide Views SERVER 2', 'Youtube Worldwide Views SERVER 2', 1000, 1000000, 16, '', 1476080070),
206(38, 4, 42, 'Youtube Worldwide Views SERVER 3', 'Youtube Worldwide Views SERVER 3', 1000, 1000000, 10, '', 1476080098),
207(39, 4, 55, 'Youtube Likes SERVER 1', 'Youtube Likes SERVER 1', 100, 10000, 155, '', 1476080158),
208(40, 4, 54, 'Youtube Subscribers SERVER 1', 'Youtube Subscribers SERVER 1', 100, 10000, 505, '', 1476081416),
209(41, 4, 44, 'REAL Youtube Subscribers ', 'REAL Youtube Subscribers ', 300, 5000, 510, '', 1476081563),
210(42, 6, 45, 'Vine Followers', 'Vine Followers', 100, 200000, 17, '', 1476081966),
211(43, 6, 46, 'Vine Revines', 'Vine Revines', 100, 200000, 17, '', 1476081995),
212(44, 6, 47, 'Vine Loops', 'Vine Loops', 100, 1000000, 17, '', 1476082015),
213(45, 6, 48, 'Vine Likes', 'Vine Likes', 100, 200000, 17, '', 1476082037),
214(46, 5, 56, 'Google Plus Followers', 'Google Plus Followers', 100, 1000, 255, '', 1476082113),
215(47, 5, 57, 'Google Plus Likes', 'Google Plus Likes', 100, 5000, 135, '', 1476082135),
216(48, 5, 58, 'Google Plus reshare', 'Google Plus reshare', 100, 5000, 155, '', 1476082159),
217(49, 7, 51, 'Soundcloud Plays', 'Soundcloud Plays', 1000, 1000000, 7, '', 1476082293),
218(50, 7, 52, 'Soundcloud Downloads', 'Soundcloud Downloads', 1000, 50000, 7, '', 1476082313),
219(51, 7, 53, 'SoundCloud Followers', 'SoundCloud Followers', 100, 1000000, 80, '', 1476082351),
220(52, 8, 2147483647, 'WebPanels (WEB SMM)', 'WebPanels (WEB SMM)', 1000, 1000, 50, '', 1476082500),
221(53, 8, 2147483647, 'WebPhising ( COC, LGR , CR, Dll)', 'WebPhising ( COC, LGR , CR, Dll)', 1000, 1000, 15, '', 1476082530),
222(54, 8, 2147483647, 'Web Robot Facebook Full Bot', 'Web Robot Facebook Full Bot', 1000, 1000, 20, '', 1476082559),
223(55, 8, 2147483647, 'Web Robot Facebook Coment Like autopost Grup', 'Web Robot Facebook Coment Like autopost Grup', 1000, 1000, 10, '', 1476082579);
224
225DROP TABLE IF EXISTS `support`;
226CREATE TABLE `support` (
227 `SupportID` int(244) NOT NULL AUTO_INCREMENT,
228 `SupportUserID` int(244) NOT NULL,
229 `SupportTitle` blob NOT NULL,
230 `SupportMessage` blob NOT NULL,
231 `SupportDate` int(244) NOT NULL,
232 `SupportReply` blob NOT NULL,
233 PRIMARY KEY (`SupportID`),
234 KEY `supportuserid` (`SupportUserID`),
235 CONSTRAINT `supportuserid` FOREIGN KEY (`SupportUserID`) REFERENCES `users` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE
236) ENGINE=InnoDB DEFAULT CHARSET=utf8;
237
238
239DROP TABLE IF EXISTS `users`;
240CREATE TABLE `users` (
241 `UserID` int(244) NOT NULL AUTO_INCREMENT,
242 `UserName` blob NOT NULL,
243 `UserEmail` blob NOT NULL,
244 `UserPassword` blob NOT NULL,
245 `UserLevel` enum('default','banned','admin') CHARACTER SET latin1 NOT NULL DEFAULT 'default',
246 `UserFirstName` blob NOT NULL,
247 `UserLastName` blob NOT NULL,
248 `UserRegistrationDate` int(244) NOT NULL,
249 `UserRegistrationAddress` blob NOT NULL,
250 `UserFunds` varchar(244) NOT NULL DEFAULT '0',
251 `UserImage` blob,
252 PRIMARY KEY (`UserID`)
253) ENGINE=InnoDB DEFAULT CHARSET=utf8;
254
255INSERT INTO `users` (`UserID`, `UserName`, `UserEmail`, `UserPassword`, `UserLevel`, `UserFirstName`, `UserLastName`, `UserRegistrationDate`, `UserRegistrationAddress`, `UserFunds`, `UserImage`) VALUES
256(15, 'rintoar', 'kreonrinto@gmail.com', '104111958016eb3d1f913a9245f257e4', 'admin', 'rinto', 'ar', 1476624684, '127.0.0.1', '999999999999999999999999999999999', NULL);
257
258-- 2016-10-16 13:34:39