· 8 years ago · Dec 01, 2017, 07:36 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Nov 25, 2017 at 03:36 PM
7-- Server version: 10.2.10-MariaDB
8-- PHP Version: 5.6.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `wfgutngt_ss`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `actions`
29--
30
31CREATE TABLE `actions` (
32 `id` int(64) NOT NULL,
33 `admin` varchar(64) NOT NULL,
34 `client` varchar(64) NOT NULL,
35 `action` varchar(6444) NOT NULL,
36 `date` int(21) NOT NULL
37) ENGINE=MyISAM DEFAULT CHARSET=latin1;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `api`
43--
44
45CREATE TABLE `api` (
46 `id` int(2) NOT NULL,
47 `name` varchar(50) NOT NULL,
48 `api` varchar(1024) NOT NULL,
49 `slots` int(3) NOT NULL,
50 `methods` varchar(100) NOT NULL,
51 `type` int(88) NOT NULL,
52 `status` int(88) NOT NULL
53) ENGINE=MyISAM DEFAULT CHARSET=latin1;
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `bans`
59--
60
61CREATE TABLE `bans` (
62 `username` varchar(15) NOT NULL,
63 `reason` varchar(1024) NOT NULL
64) ENGINE=MyISAM DEFAULT CHARSET=latin1;
65
66-- --------------------------------------------------------
67
68--
69-- Table structure for table `blacklist`
70--
71
72CREATE TABLE `blacklist` (
73 `ID` int(11) NOT NULL,
74 `data` varchar(50) NOT NULL,
75 `type` varchar(10) NOT NULL
76) ENGINE=MyISAM DEFAULT CHARSET=latin1;
77
78--
79-- Dumping data for table `blacklist`
80--
81
82INSERT INTO `blacklist` (`ID`, `data`, `type`) VALUES
83(2, 'live:devpicklez', 'skype'),
84(3, 'live:devpicklez@gmail.com', 'skype'),
85(4, 'https://superstress.pw/', 'victim'),
86(5, '75.69.47.208', 'victim'),
87(6, 'https://s.superstatus.website/', 'victim'),
88(7, '79.143.52.19', 'victim'),
89(8, 'big-fin-frank', 'skype'),
90(9, 'big_fin_frank', 'skype');
91
92-- --------------------------------------------------------
93
94--
95-- Table structure for table `faq`
96--
97
98CREATE TABLE `faq` (
99 `id` int(3) NOT NULL,
100 `question` varchar(1024) NOT NULL,
101 `answer` varchar(5000) NOT NULL
102) ENGINE=MyISAM DEFAULT CHARSET=latin1;
103
104--
105-- Dumping data for table `faq`
106--
107
108INSERT INTO `faq` (`id`, `question`, `answer`) VALUES
109(30, 'Do you offer free trials?', 'We might, open live chat!'),
110(29, 'Abuse', 'No abuse is tolerated. If you see abuse please email: admin@trumpservices.pw'),
111(25, 'Multiple Accounts', 'You are not allowed to create more than one account. If caught [ you will be banned ] !'),
112(28, 'Trial Rebuying', 'You ARE NOT allowed to buy the trial more than ONE time.'),
113(27, 'VPN - Proxy - RDP', 'Proxy, VPN, RDP isn\'t allowed as we need to know if you are sharing the account. But exceptions made if asked if you can have 2 people on the account if you have a plan high enough.'),
114(1, 'Changing the F.A.Q', 'Our admin have the permission to change the F.A.Q any time they want without telling any customer.'),
115(31, 'What is the guarantee that my target will be offline? ', 'We provide no guarantee that your stress test will cause the target to be down. If your target does not go down please open a ticket so we may investigate why it did not. \r\nEstimated Wait Time - 24 to 48 Hours'),
116(35, 'Do you offer lifetime packages?', 'Open live chat for this type of question.'),
117(4, 'What payment methods do you accept?', 'We accept Paypal and Bitcoin ONLY.'),
118(6, 'What\'s the point of using a Layer 7 attack method?', 'Layer 7 attack methods target servers at an application layer in attempt to trick servers into allowing and process dirty traffic. This generally means utilizing the maximum amount of resources so no clients are allocated any.'),
119(7, 'What is the difference between bits and bytes?', 'Usually bits (lowercase b) are used to describe data transfer and bytes (uppercase B) for data storage. The only physical difference between the two is that every byte contains eight bits of data.\r\nOn our site you will run into three common units:\r\nMbps (megabits per second) - average data transfer rate\r\nB (bytes) - packet size\r\nkB (kilobytes) - packet size (1024 bytes = 1 kilobyte)'),
120(8, 'Is there a limit on how many boots I can launch per day?', 'Yes, you\'re not allowed to stress more than 40 hosts a day, we do this in order to keep our network unsaturated.'),
121(13, 'What\'s the difference between attack methods?', 'SSDP - Layer 4 UDP amplification vector, usually our hardest hitting attack method, should render most targets inaccessible.\r\nDNS - Layer 4 UDP amplification vector, DNS amplification vector, oldest UDP amplification vector and should be used for low protection targets.\r\nNTP - Layer 4 UDP amplification vector, being famous for downing CloudFlare, and many other targets it has the best amplification factor, but the least vulnerability rate, shouldn\'t be used for highly protected targets.\r\nTCP-FUCK (NGSSYN) - Layer 4 TCP - Spoofed TCP attack method, exhausting most connections.\r\nACK - Layer 4 TCP - Spoofed TCP attack method.\r\nSYN - Layer 4 TCP - Spoofed TCP attack method.\r\nDOMINATE - Layer 4 TCP - Spoofed TCP attack method ( strong for home connections ).\r\nTCOP - Layer 4 TCP - Spoofed TCP attack method randomly attacking port.\r\nSNMP - Layer 4 UDP amplification vector - Spoofed Udp attack method.\r\nJoomla (Recommended)- Layer 7 - Strong. spamming web bandwitdh.\r\nXMLRPC - Layer 7 - Taking down websites fast.\r\nGET & POST - Layer 7 - Flooding web with client request.\r\n'),
122(34, 'Why can\'t I pay with PayPal?', 'You can! Just open the live chat for an agent to assist you.'),
123(32, 'Can I share my account?', 'Check the VPN, Proxy, RDP tab!'),
124(33, 'I bought a package and DIDNT receive it!', 'Wait 15 minutes. If you still haven\'t received it please open a ticket with your payment method, email, username, and transaction ID.'),
125(26, 'What is VIP?', 'With VIP you can use private network, you have more power and can drop protected servers easy!');
126
127-- --------------------------------------------------------
128
129--
130-- Table structure for table `fe`
131--
132
133CREATE TABLE `fe` (
134 `ID` int(11) NOT NULL,
135 `userID` int(11) NOT NULL,
136 `type` varchar(1) NOT NULL,
137 `ip` varchar(15) NOT NULL
138) ENGINE=MyISAM DEFAULT CHARSET=latin1;
139
140-- --------------------------------------------------------
141
142--
143-- Table structure for table `iplogs`
144--
145
146CREATE TABLE `iplogs` (
147 `ID` int(11) NOT NULL,
148 `userID` int(11) NOT NULL,
149 `logged` varchar(15) NOT NULL,
150 `date` int(11) NOT NULL
151) ENGINE=MyISAM DEFAULT CHARSET=latin1;
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `loginlogs`
157--
158
159CREATE TABLE `loginlogs` (
160 `username` varchar(30) NOT NULL,
161 `ip` varchar(15) NOT NULL,
162 `date` int(11) NOT NULL,
163 `country` varchar(20) NOT NULL
164) ENGINE=InnoDB DEFAULT CHARSET=latin1;
165
166--
167-- Dumping data for table `loginlogs`
168--
169
170INSERT INTO `loginlogs` (`username`, `ip`, `date`, `country`) VALUES
171('bigfinfrank', '75.69.47.208', 1511620214, 'XX'),
172
173-- --------------------------------------------------------
174
175--
176-- Table structure for table `logs`
177--
178
179CREATE TABLE `logs` (
180 `id` int(11) NOT NULL,
181 `user` varchar(15) NOT NULL,
182 `ip` varchar(1024) NOT NULL,
183 `port` int(5) NOT NULL,
184 `time` int(4) NOT NULL,
185 `method` varchar(10) NOT NULL,
186 `date` int(11) NOT NULL,
187 `stopped` int(1) NOT NULL DEFAULT 0,
188 `handler` varchar(50) NOT NULL,
189 `network` varchar(50) NOT NULL
190) ENGINE=InnoDB DEFAULT CHARSET=latin1;
191
192-- --------------------------------------------------------
193
194--
195-- Table structure for table `messages`
196--
197
198CREATE TABLE `messages` (
199 `messageid` int(11) NOT NULL,
200 `ticketid` int(11) NOT NULL,
201 `content` text NOT NULL,
202 `sender` varchar(30) NOT NULL,
203 `date` int(20) NOT NULL
204) ENGINE=MyISAM DEFAULT CHARSET=latin1;
205
206-- --------------------------------------------------------
207
208--
209-- Table structure for table `methods`
210--
211
212CREATE TABLE `methods` (
213 `id` int(2) NOT NULL,
214 `name` varchar(30) NOT NULL,
215 `fullname` varchar(20) NOT NULL,
216 `type` varchar(6) NOT NULL,
217 `command` varchar(1000) NOT NULL
218) ENGINE=MyISAM DEFAULT CHARSET=latin1;
219
220--
221-- Dumping data for table `methods`
222--
223
224INSERT INTO `methods` (`id`, `name`, `fullname`, `type`, `command`) VALUES
225(1, 'BtY', 'bty', 'layer7', '');
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `news`
231--
232
233CREATE TABLE `news` (
234 `ID` int(11) NOT NULL,
235 `color` varchar(25) NOT NULL,
236 `icon` varchar(25) NOT NULL,
237 `title` varchar(1024) NOT NULL,
238 `content` varchar(1000) NOT NULL,
239 `date` int(11) NOT NULL
240) ENGINE=MyISAM DEFAULT CHARSET=latin1;
241
242--
243-- Dumping data for table `news`
244--
245
246INSERT INTO `news` (`ID`, `color`, `icon`, `title`, `content`, `date`) VALUES
247(3, 'bg-city', 'fa fa-check', 'Site Maintenance', 'The site will still be up, but maintenance will be going around for parts of the website to improve stability. Thank you.', 1511620014),
248(2, 'bg-success', 'fa fa-check', 'Plans!', 'Custom Plans are available, Go to live chat to discuss more!', 1511572920);
249
250-- --------------------------------------------------------
251
252--
253-- Table structure for table `payments`
254--
255
256CREATE TABLE `payments` (
257 `ID` int(11) NOT NULL,
258 `paid` float NOT NULL,
259 `plan` int(11) NOT NULL,
260 `user` int(15) NOT NULL,
261 `email` varchar(60) NOT NULL,
262 `tid` varchar(30) NOT NULL,
263 `date` int(255) NOT NULL
264) ENGINE=MyISAM DEFAULT CHARSET=latin1;
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `plans`
270--
271
272CREATE TABLE `plans` (
273 `ID` int(11) NOT NULL,
274 `name` varchar(50) NOT NULL,
275 `mbt` int(11) NOT NULL,
276 `unit` varchar(10) NOT NULL,
277 `length` int(11) NOT NULL,
278 `price` float NOT NULL,
279 `concurrents` int(11) NOT NULL,
280 `private` int(1) NOT NULL
281) ENGINE=MyISAM DEFAULT CHARSET=latin1;
282
283--
284-- Dumping data for table `plans`
285--
286
287INSERT INTO `plans` (`ID`, `name`, `mbt`, `unit`, `length`, `price`, `concurrents`, `private`) VALUES
288(43, 'Super Diamond', 2400, 'Months', 1, 30, 2, 0),
289(34, 'Super Lifetime', 3600, 'Years', 100, 120, 3, 2),
290(32, 'Private Admin', 999420153, 'Years', 30, 0, 5135151, 1),
291(35, 'Supporter', 1500, 'Months', 1, 1, 2, 1),
292(37, 'Super Bronze', 600, 'Months', 1, 5, 1, 0),
293(38, 'Super Silver', 1200, 'Months', 1, 10, 1, 0),
294(39, 'Super Gold', 1600, 'Months', 1, 20, 2, 0),
295(40, 'Super VIP', 1800, 'Months', 1, 30, 1, 2),
296(41, 'Super Gold VIP', 2400, 'Months', 1, 40, 2, 2),
297(42, 'Regular Admin', 3600, 'Months', 100, 1, 4, 1),
298(44, 'Super God Regualr', 3600, 'Months', 2, 45, 4, 0),
299(46, 'Super God VIP', 3600, 'Months', 2, 55, 4, 2);
300
301-- --------------------------------------------------------
302
303--
304-- Table structure for table `reports`
305--
306
307CREATE TABLE `reports` (
308 `id` int(11) NOT NULL,
309 `username` varchar(64) NOT NULL,
310 `report` varchar(644) NOT NULL,
311 `date` int(64) NOT NULL
312) ENGINE=MyISAM DEFAULT CHARSET=latin1;
313
314-- --------------------------------------------------------
315
316--
317-- Table structure for table `servers`
318--
319
320CREATE TABLE `servers` (
321 `id` int(2) NOT NULL,
322 `name` varchar(50) NOT NULL,
323 `ip` varchar(15) NOT NULL,
324 `password` varchar(100) NOT NULL,
325 `slots` int(3) NOT NULL,
326 `methods` varchar(100) NOT NULL
327) ENGINE=MyISAM DEFAULT CHARSET=latin1;
328
329-- --------------------------------------------------------
330
331--
332-- Table structure for table `settings`
333--
334
335CREATE TABLE `settings` (
336 `sitename` varchar(1024) NOT NULL,
337 `description` text NOT NULL,
338 `paypal` varchar(50) NOT NULL,
339 `bitcoin` varchar(50) NOT NULL,
340 `maintenance` varchar(100) NOT NULL,
341 `rotation` int(1) NOT NULL DEFAULT 0,
342 `system` varchar(7) NOT NULL,
343 `maxattacks` int(5) NOT NULL,
344 `testboots` int(1) NOT NULL,
345 `cloudflare` int(1) NOT NULL,
346 `skype` varchar(200) NOT NULL,
347 `key` varchar(100) NOT NULL,
348 `issuerId` varchar(50) NOT NULL,
349 `coinpayments` varchar(50) NOT NULL,
350 `ipnSecret` varchar(100) NOT NULL,
351 `google_site` varchar(644) NOT NULL,
352 `google_secret` varchar(644) NOT NULL,
353 `btc_address` varchar(64) NOT NULL,
354 `secretKey` varchar(50) NOT NULL,
355 `cbp` int(1) NOT NULL,
356 `paypal_email` varchar(64) NOT NULL,
357 `theme` varchar(64) NOT NULL,
358 `logo` varchar(64) NOT NULL,
359 `hub_status` int(77) NOT NULL,
360 `hub_reason` varchar(77) NOT NULL,
361 `hub_time` int(43) NOT NULL,
362 `hub_rtime` int(65) NOT NULL
363) ENGINE=MyISAM DEFAULT CHARSET=latin1;
364
365--
366-- Dumping data for table `settings`
367--
368
369INSERT INTO `settings` (`sitename`, `description`, `paypal`, `bitcoin`, `maintenance`, `rotation`, `system`, `maxattacks`, `testboots`, `cloudflare`, `skype`, `key`, `issuerId`, `coinpayments`, `ipnSecret`, `google_site`, `google_secret`, `btc_address`, `secretKey`, `cbp`, `paypal_email`, `theme`, `logo`, `hub_status`, `hub_reason`, `hub_time`, `hub_rtime`) VALUES
370('Super Stress', 'Welcome to Super Stress! The shit that will make you rock the TOP!', '0', '1', '0', 0, 'api', 50, 0, 1, '', '0', '0', '35452009429183ebf9a1c905f7f52e11', '2580', '6LfusDkUAAAAAHZNi8Wbe4BLwnQ7L1yYVwcDQx-s', '6LfusDkUAAAAACFIVnACqEh8YRF7rLol8a1uVCE2', '1MMZxo8RfGgsgXcCrFgbg2VLXKphutk76c', '', 1, '', 'modern.min.css', 'diamond', 1, '', 0, 1505264348);
371
372-- --------------------------------------------------------
373
374--
375-- Table structure for table `tickets`
376--
377
378CREATE TABLE `tickets` (
379 `id` int(11) NOT NULL,
380 `subject` varchar(1024) NOT NULL,
381 `content` text NOT NULL,
382 `status` varchar(30) NOT NULL,
383 `username` varchar(15) NOT NULL,
384 `date` int(20) NOT NULL
385) ENGINE=MyISAM DEFAULT CHARSET=latin1;
386
387-- --------------------------------------------------------
388
389--
390-- Table structure for table `users`
391--
392
393CREATE TABLE `users` (
394 `ID` int(11) NOT NULL,
395 `username` varchar(15) NOT NULL,
396 `password` varchar(40) NOT NULL,
397 `email` varchar(50) NOT NULL,
398 `rank` int(11) NOT NULL DEFAULT 0,
399 `membership` int(11) NOT NULL,
400 `expire` int(11) NOT NULL,
401 `status` int(11) NOT NULL,
402 `referral` varchar(50) NOT NULL,
403 `referralbalance` int(3) NOT NULL DEFAULT 0,
404 `testattack` int(1) NOT NULL,
405 `activity` int(64) NOT NULL DEFAULT 0
406) ENGINE=MyISAM DEFAULT CHARSET=latin1;
407
408--
409-- Dumping data for table `users`
410--
411
412INSERT INTO `users` (`ID`, `username`, `password`, `email`, `rank`, `membership`, `expire`, `status`, `referral`, `referralbalance`, `testattack`, `activity`) VALUES
413(1, 'admin', '1156719ce1b20029c5c99b4adae9838fde90bc13', 'admin@superstress.pw', 1, 32, 2147483647, 0, '0', 0, 0, 1511622153),
414(16, 'bigfinfrank', '4319e076b500c19cefe9d89b771cd45fa5d08f3f', 'bigfinfrank@yahoo.com', 2, 42, 1774400126, 0, '0', 0, 0, 0),
415(15, 'RaitzRain', '12422473ce5f9765a5d61175199c702929c7c611', 'raitzsemjasesstaff@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
416(14, 'maimai1', 'b4ddd6b4f01980eb12c469d2722b47fe4f8d66d3', 'rikinpelit@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
417(13, 'Maimai1', 'b4ddd6b4f01980eb12c469d2722b47fe4f8d66d3', 'rikirasila@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
418(12, 'Epless', '0b75ef23f73d3268605ca05f7c664ab667255fef', 'harryphipps770@gmail.com', 1, 42, 1774402049, 0, '0', 0, 0, 1511621356),
419(17, 'Quierem', 'e547927bbc9add0fc5ab3d3224bdc1d5256fe655', 'cycl0se0@gmail.com', 2, 35, 1514200073, 0, '0', 0, 0, 0),
420(18, 'Quier3m', 'd2907a372d4f46516bfaf10a6054fd354604cd27', 'cyclozee@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
421(19, 'panos3006', 'f9b3e25fd5e8b1dee154e5f314735978e4e92384', 'panos3006@googlemail.com', 0, 0, 0, 0, '0', 0, 0, 0),
422(20, 'blackpit', 'f9b3e25fd5e8b1dee154e5f314735978e4e92384', 'bblackpit3006@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
423(21, 'pizza', '10470c3b4b1fed12c3baac014be15fac67c6e815', 'kubakuba79@seznam.cz', 0, 0, 0, 0, '0', 0, 0, 0),
424(22, 'Michakke', '26e252fcc2e3164214b2721cf5c9fae5ba166f65', 'Michakke@wp.pl', 0, 0, 0, 0, '0', 0, 0, 0),
425(23, 'jackman', '31dcb0e1592716916adf333f03adcbc9f2e6da7b', 'awawc40@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
426(24, 'awaw', '31dcb0e1592716916adf333f03adcbc9f2e6da7b', 'awaw_chol@hotmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
427(25, 'Parswagg', 'c7f33dc104f14c58f460a519f54db174f4027c6c', 'parsa@parsa.cc', 0, 0, 0, 0, '0', 0, 0, 0),
428(26, 'xpizza', '10470c3b4b1fed12c3baac014be15fac67c6e815', 'dadasd@seznam.cz', 0, 0, 0, 0, '0', 0, 0, 0),
429(27, 'zpizza', '5e64f25fbeefabbc6f97335d19e1fd75e789c60b', 'dadadasxyx@seznam.cz', 0, 0, 0, 0, '0', 0, 0, 0),
430(29, 'theo420', '4d54eec6116e00c12b1024145ac94902cc7f06f9', 'theogameshd@Hotmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
431(30, 'Natedawgsc', '857cc19820c910cc9e68b5c659cbc5aef324e094', 'itsmewdfinatedawg1@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0),
432(31, 'Ryhz', '327b9372a3804476cf291d011ac275d4f2ca6fe8', 'iryhzatdawn@gmail.com', 2, 35, 1514163450, 0, '0', 0, 0, 0),
433(32, 'kazi', '9e6dbc096c390bec9c191bc99f90247afaaa5e28', 'roman@serverstress.net', 1, 42, 1774401191, 0, '0', 0, 0, 1511624172),
434(33, 'Ruthless', '8467bae4100e4e0efb91d89bc5040c6bf0eab5a1', 'dadehernadez15@gmail.com', 2, 35, 1514165820, 0, '0', 0, 0, 0),
435(35, 'dvents', 'c33371e0b0817930830b9bcafcf66d482954ff6e', 'dvents@mailinator.com', 0, 0, 0, 0, '0', 0, 0, 0),
436(36, 'Alex', '06e765e17715e2950762ec817d981b528977f66e', 'root@alexg0d.site', 0, 0, 0, 0, '0', 0, 0, 0),
437(37, 'isuxat', 'b8cb10b5b92d329641a37a0c85458c365df47c61', 'darkendnetwork@gmail.com', 0, 0, 0, 0, '0', 0, 0, 0);
438
439-- --------------------------------------------------------
440
441--
442-- Table structure for table `wbs`
443--
444
445CREATE TABLE `wbs` (
446 `id` int(100) NOT NULL,
447 `username` varchar(100) NOT NULL,
448 `email` varchar(100) NOT NULL,
449 `reason` varchar(100) NOT NULL,
450 `appeal` int(100) NOT NULL,
451 `appealstat` int(100) NOT NULL,
452 `type` int(100) NOT NULL,
453 `expire` date NOT NULL
454) ENGINE=MyISAM DEFAULT CHARSET=latin1;
455
456--
457-- Indexes for dumped tables
458--
459
460--
461-- Indexes for table `actions`
462--
463ALTER TABLE `actions`
464 ADD PRIMARY KEY (`id`),
465 ADD UNIQUE KEY `id` (`id`);
466
467--
468-- Indexes for table `api`
469--
470ALTER TABLE `api`
471 ADD PRIMARY KEY (`id`);
472
473--
474-- Indexes for table `blacklist`
475--
476ALTER TABLE `blacklist`
477 ADD PRIMARY KEY (`ID`);
478
479--
480-- Indexes for table `faq`
481--
482ALTER TABLE `faq`
483 ADD PRIMARY KEY (`id`);
484
485--
486-- Indexes for table `fe`
487--
488ALTER TABLE `fe`
489 ADD PRIMARY KEY (`ID`);
490
491--
492-- Indexes for table `iplogs`
493--
494ALTER TABLE `iplogs`
495 ADD PRIMARY KEY (`ID`),
496 ADD KEY `ID` (`ID`);
497
498--
499-- Indexes for table `loginlogs`
500--
501ALTER TABLE `loginlogs`
502 ADD KEY `date` (`date`),
503 ADD KEY `username` (`username`);
504
505--
506-- Indexes for table `logs`
507--
508ALTER TABLE `logs`
509 ADD PRIMARY KEY (`id`),
510 ADD KEY `time_date` (`time`,`date`,`handler`,`stopped`) USING BTREE;
511
512--
513-- Indexes for table `messages`
514--
515ALTER TABLE `messages`
516 ADD PRIMARY KEY (`messageid`);
517
518--
519-- Indexes for table `methods`
520--
521ALTER TABLE `methods`
522 ADD UNIQUE KEY `id_2` (`id`),
523 ADD KEY `id` (`id`);
524
525--
526-- Indexes for table `news`
527--
528ALTER TABLE `news`
529 ADD PRIMARY KEY (`ID`);
530
531--
532-- Indexes for table `payments`
533--
534ALTER TABLE `payments`
535 ADD PRIMARY KEY (`ID`);
536
537--
538-- Indexes for table `plans`
539--
540ALTER TABLE `plans`
541 ADD PRIMARY KEY (`ID`);
542
543--
544-- Indexes for table `reports`
545--
546ALTER TABLE `reports`
547 ADD UNIQUE KEY `id` (`id`);
548
549--
550-- Indexes for table `servers`
551--
552ALTER TABLE `servers`
553 ADD PRIMARY KEY (`id`);
554
555--
556-- Indexes for table `settings`
557--
558ALTER TABLE `settings`
559 ADD UNIQUE KEY `key` (`key`),
560 ADD KEY `sitename` (`sitename`(767));
561
562--
563-- Indexes for table `tickets`
564--
565ALTER TABLE `tickets`
566 ADD PRIMARY KEY (`id`);
567
568--
569-- Indexes for table `users`
570--
571ALTER TABLE `users`
572 ADD PRIMARY KEY (`ID`),
573 ADD KEY `ID` (`ID`);
574
575--
576-- Indexes for table `wbs`
577--
578ALTER TABLE `wbs`
579 ADD PRIMARY KEY (`id`);
580
581--
582-- AUTO_INCREMENT for dumped tables
583--
584
585--
586-- AUTO_INCREMENT for table `actions`
587--
588ALTER TABLE `actions`
589 MODIFY `id` int(64) NOT NULL AUTO_INCREMENT;
590--
591-- AUTO_INCREMENT for table `api`
592--
593ALTER TABLE `api`
594 MODIFY `id` int(2) NOT NULL AUTO_INCREMENT;
595--
596-- AUTO_INCREMENT for table `blacklist`
597--
598ALTER TABLE `blacklist`
599 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
600--
601-- AUTO_INCREMENT for table `faq`
602--
603ALTER TABLE `faq`
604 MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
605--
606-- AUTO_INCREMENT for table `fe`
607--
608ALTER TABLE `fe`
609 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
610--
611-- AUTO_INCREMENT for table `iplogs`
612--
613ALTER TABLE `iplogs`
614 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
615--
616-- AUTO_INCREMENT for table `logs`
617--
618ALTER TABLE `logs`
619 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30568;
620--
621-- AUTO_INCREMENT for table `messages`
622--
623ALTER TABLE `messages`
624 MODIFY `messageid` int(11) NOT NULL AUTO_INCREMENT;
625--
626-- AUTO_INCREMENT for table `methods`
627--
628ALTER TABLE `methods`
629 MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
630--
631-- AUTO_INCREMENT for table `news`
632--
633ALTER TABLE `news`
634 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
635--
636-- AUTO_INCREMENT for table `payments`
637--
638ALTER TABLE `payments`
639 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
640--
641-- AUTO_INCREMENT for table `plans`
642--
643ALTER TABLE `plans`
644 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
645--
646-- AUTO_INCREMENT for table `reports`
647--
648ALTER TABLE `reports`
649 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
650--
651-- AUTO_INCREMENT for table `servers`
652--
653ALTER TABLE `servers`
654 MODIFY `id` int(2) NOT NULL AUTO_INCREMENT;
655--
656-- AUTO_INCREMENT for table `tickets`
657--
658ALTER TABLE `tickets`
659 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=249;
660--
661-- AUTO_INCREMENT for table `users`
662--
663ALTER TABLE `users`
664 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;COMMIT;
665
666/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
667/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
668/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;