· 8 years ago · Apr 15, 2018, 01:02 PM
1-- MySQL dump 10.11
2--
3-- Host: localhost Database: admin_conect2
4-- ------------------------------------------------------
5-- Server version 5.0.67-community
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `bss_commands`
20--
21
22DROP TABLE IF EXISTS `bss_commands`;
23SET @saved_cs_client = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `bss_commands` (
26 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
27 `ForMachineID` varchar(16) NOT NULL default '',
28 `JobID` varchar(32) NOT NULL default '',
29 `cmd` text NOT NULL,
30 `result` tinyint(4) NOT NULL default '0',
31 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
32 PRIMARY KEY (`JobID`),
33 KEY `ForMachineID` (`ForMachineID`)
34) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
35SET character_set_client = @saved_cs_client;
36
37--
38-- Dumping data for table `bss_commands`
39--
40
41LOCK TABLES `bss_commands` WRITE;
42/*!40000 ALTER TABLE `bss_commands` DISABLE KEYS */;
43/*!40000 ALTER TABLE `bss_commands` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `bss_users`
48--
49
50DROP TABLE IF EXISTS `bss_users`;
51SET @saved_cs_client = @@character_set_client;
52SET character_set_client = utf8;
53CREATE TABLE `bss_users` (
54 `MachineID` char(16) NOT NULL default '',
55 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
56 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
57 `Version` int(11) NOT NULL default '0',
58 `LastIP` int(11) NOT NULL default '0',
59 PRIMARY KEY (`MachineID`)
60) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
61SET character_set_client = @saved_cs_client;
62
63--
64-- Dumping data for table `bss_users`
65--
66
67LOCK TABLES `bss_users` WRITE;
68/*!40000 ALTER TABLE `bss_users` DISABLE KEYS */;
69/*!40000 ALTER TABLE `bss_users` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `bss_xfiles`
74--
75
76DROP TABLE IF EXISTS `bss_xfiles`;
77SET @saved_cs_client = @@character_set_client;
78SET character_set_client = utf8;
79CREATE TABLE `bss_xfiles` (
80 `MachineID` varchar(16) NOT NULL default '',
81 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
82 `FileMD5` varchar(32) NOT NULL default '',
83 `Type` char(3) NOT NULL default '',
84 `Comment` varchar(180) NOT NULL default '',
85 `data` mediumblob NOT NULL,
86 UNIQUE KEY `FileMD5` (`FileMD5`),
87 KEY `MachineID` (`MachineID`)
88) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
89SET character_set_client = @saved_cs_client;
90
91--
92-- Dumping data for table `bss_xfiles`
93--
94
95LOCK TABLES `bss_xfiles` WRITE;
96/*!40000 ALTER TABLE `bss_xfiles` DISABLE KEYS */;
97/*!40000 ALTER TABLE `bss_xfiles` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `bss_xfriendlynames`
102--
103
104DROP TABLE IF EXISTS `bss_xfriendlynames`;
105SET @saved_cs_client = @@character_set_client;
106SET character_set_client = utf8;
107CREATE TABLE `bss_xfriendlynames` (
108 `MachineID` varchar(16) NOT NULL default '',
109 `Name` varchar(255) NOT NULL default '',
110 PRIMARY KEY (`MachineID`)
111) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
112SET character_set_client = @saved_cs_client;
113
114--
115-- Dumping data for table `bss_xfriendlynames`
116--
117
118LOCK TABLES `bss_xfriendlynames` WRITE;
119/*!40000 ALTER TABLE `bss_xfriendlynames` DISABLE KEYS */;
120/*!40000 ALTER TABLE `bss_xfriendlynames` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `bss_xips`
125--
126
127DROP TABLE IF EXISTS `bss_xips`;
128SET @saved_cs_client = @@character_set_client;
129SET character_set_client = utf8;
130CREATE TABLE `bss_xips` (
131 `MachineID` char(16) NOT NULL default '',
132 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
133 `IP` int(11) NOT NULL default '0',
134 PRIMARY KEY (`IP`),
135 KEY `MachineID` (`MachineID`),
136 KEY `DateTime` (`DateTime`)
137) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
138SET character_set_client = @saved_cs_client;
139
140--
141-- Dumping data for table `bss_xips`
142--
143
144LOCK TABLES `bss_xips` WRITE;
145/*!40000 ALTER TABLE `bss_xips` DISABLE KEYS */;
146/*!40000 ALTER TABLE `bss_xips` ENABLE KEYS */;
147UNLOCK TABLES;
148
149--
150-- Table structure for table `bss_xstats`
151--
152
153DROP TABLE IF EXISTS `bss_xstats`;
154SET @saved_cs_client = @@character_set_client;
155SET character_set_client = utf8;
156CREATE TABLE `bss_xstats` (
157 `MachineID` char(16) NOT NULL default '',
158 `Start` datetime NOT NULL default '0000-00-00 00:00:00',
159 `End` datetime NOT NULL default '0000-00-00 00:00:00',
160 `Type` tinyint(4) NOT NULL default '0',
161 KEY `MachineID` (`MachineID`)
162) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
163SET character_set_client = @saved_cs_client;
164
165--
166-- Dumping data for table `bss_xstats`
167--
168
169LOCK TABLES `bss_xstats` WRITE;
170/*!40000 ALTER TABLE `bss_xstats` DISABLE KEYS */;
171/*!40000 ALTER TABLE `bss_xstats` ENABLE KEYS */;
172UNLOCK TABLES;
173
174--
175-- Table structure for table `core_updates`
176--
177
178DROP TABLE IF EXISTS `core_updates`;
179SET @saved_cs_client = @@character_set_client;
180SET character_set_client = utf8;
181CREATE TABLE `core_updates` (
182 `MachineID` char(16) NOT NULL default '',
183 `LastCoreUpdate` datetime NOT NULL default '0000-00-00 00:00:00',
184 `LastIP` int(11) NOT NULL default '0',
185 `LastUpdateReason` tinyint(4) NOT NULL default '0',
186 `Country` char(2) NOT NULL default '',
187 PRIMARY KEY (`MachineID`),
188 KEY `Country` (`Country`)
189) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
190SET character_set_client = @saved_cs_client;
191
192--
193-- Dumping data for table `core_updates`
194--
195
196LOCK TABLES `core_updates` WRITE;
197/*!40000 ALTER TABLE `core_updates` DISABLE KEYS */;
198/*!40000 ALTER TABLE `core_updates` ENABLE KEYS */;
199UNLOCK TABLES;
200
201--
202-- Table structure for table `crgrab_certs`
203--
204
205DROP TABLE IF EXISTS `crgrab_certs`;
206SET @saved_cs_client = @@character_set_client;
207SET character_set_client = utf8;
208CREATE TABLE `crgrab_certs` (
209 `MachineID` varchar(16) NOT NULL default '',
210 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
211 `IP` int(11) NOT NULL default '0',
212 `CertMD5` varchar(32) NOT NULL default '',
213 `CertPwd` mediumblob NOT NULL,
214 `CertData` mediumblob NOT NULL,
215 PRIMARY KEY (`CertMD5`),
216 KEY `MachineID` (`MachineID`),
217 KEY `DateTime` (`DateTime`)
218) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
219SET character_set_client = @saved_cs_client;
220
221--
222-- Dumping data for table `crgrab_certs`
223--
224
225LOCK TABLES `crgrab_certs` WRITE;
226/*!40000 ALTER TABLE `crgrab_certs` DISABLE KEYS */;
227/*!40000 ALTER TABLE `crgrab_certs` ENABLE KEYS */;
228UNLOCK TABLES;
229
230--
231-- Table structure for table `crgrab_info`
232--
233
234DROP TABLE IF EXISTS `crgrab_info`;
235SET @saved_cs_client = @@character_set_client;
236SET character_set_client = utf8;
237CREATE TABLE `crgrab_info` (
238 `cert_for` mediumblob NOT NULL,
239 `cert_from` mediumblob NOT NULL,
240 `cert_start_date` varchar(12) NOT NULL default '',
241 `cert_end_date` varchar(12) NOT NULL default '',
242 `cert_md5` varchar(32) NOT NULL default '',
243 `cert_hash_of_sha1` bigint(20) NOT NULL default '0',
244 `row_md5` varchar(32) NOT NULL default '',
245 PRIMARY KEY (`row_md5`),
246 KEY `cert_hash_of_sha1` (`cert_hash_of_sha1`),
247 KEY `cert_md5` (`cert_md5`)
248) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
249SET character_set_client = @saved_cs_client;
250
251--
252-- Dumping data for table `crgrab_info`
253--
254
255LOCK TABLES `crgrab_info` WRITE;
256/*!40000 ALTER TABLE `crgrab_info` DISABLE KEYS */;
257/*!40000 ALTER TABLE `crgrab_info` ENABLE KEYS */;
258UNLOCK TABLES;
259
260--
261-- Table structure for table `crgrab_url_watch`
262--
263
264DROP TABLE IF EXISTS `crgrab_url_watch`;
265SET @saved_cs_client = @@character_set_client;
266SET character_set_client = utf8;
267CREATE TABLE `crgrab_url_watch` (
268 `MachineID` varchar(16) NOT NULL default '',
269 `AddedDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
270 `IPFrom` int(11) NOT NULL default '0',
271 `cert_hash_of_sha1` bigint(20) NOT NULL default '0',
272 `captured_url` mediumblob NOT NULL,
273 `data_md5` varchar(32) NOT NULL default '',
274 PRIMARY KEY (`data_md5`),
275 KEY `MachineID` (`MachineID`),
276 KEY `cert_hash_of_sha1` (`cert_hash_of_sha1`)
277) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
278SET character_set_client = @saved_cs_client;
279
280--
281-- Dumping data for table `crgrab_url_watch`
282--
283
284LOCK TABLES `crgrab_url_watch` WRITE;
285/*!40000 ALTER TABLE `crgrab_url_watch` DISABLE KEYS */;
286/*!40000 ALTER TABLE `crgrab_url_watch` ENABLE KEYS */;
287UNLOCK TABLES;
288
289--
290-- Table structure for table `emscan_files`
291--
292
293DROP TABLE IF EXISTS `emscan_files`;
294SET @saved_cs_client = @@character_set_client;
295SET character_set_client = utf8;
296CREATE TABLE `emscan_files` (
297 `MachineID` varchar(16) NOT NULL default '',
298 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
299 `FileMD5` varchar(32) NOT NULL default '',
300 `State` tinyint(4) NOT NULL default '0',
301 `MCount` int(11) NOT NULL default '0',
302 `CCode` char(2) NOT NULL default '',
303 `data` mediumblob NOT NULL,
304 UNIQUE KEY `FileMD5` (`FileMD5`),
305 KEY `MachineID` (`MachineID`),
306 KEY `CCode` (`CCode`)
307) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
308SET character_set_client = @saved_cs_client;
309
310--
311-- Dumping data for table `emscan_files`
312--
313
314LOCK TABLES `emscan_files` WRITE;
315/*!40000 ALTER TABLE `emscan_files` DISABLE KEYS */;
316/*!40000 ALTER TABLE `emscan_files` ENABLE KEYS */;
317UNLOCK TABLES;
318
319--
320-- Table structure for table `fgrab`
321--
322
323DROP TABLE IF EXISTS `fgrab`;
324SET @saved_cs_client = @@character_set_client;
325SET character_set_client = utf8;
326CREATE TABLE `fgrab` (
327 `MachineID` varchar(16) NOT NULL default '',
328 `Version` int(11) NOT NULL default '0',
329 `FromIP` int(11) NOT NULL default '0',
330 `GType` tinyint(4) NOT NULL default '0',
331 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
332 `data_hash` varchar(32) NOT NULL default '',
333 `data` mediumblob NOT NULL,
334 KEY `MachineID` (`MachineID`),
335 KEY `GType` (`GType`),
336 KEY `Added` (`Added`)
337) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
338SET character_set_client = @saved_cs_client;
339
340--
341-- Dumping data for table `fgrab`
342--
343
344LOCK TABLES `fgrab` WRITE;
345/*!40000 ALTER TABLE `fgrab` DISABLE KEYS */;
346/*!40000 ALTER TABLE `fgrab` ENABLE KEYS */;
347UNLOCK TABLES;
348
349--
350-- Table structure for table `fgrab_0609`
351--
352
353DROP TABLE IF EXISTS `fgrab_0609`;
354SET @saved_cs_client = @@character_set_client;
355SET character_set_client = utf8;
356CREATE TABLE `fgrab_0609` (
357 `MachineID` varchar(16) NOT NULL default '',
358 `Version` int(11) NOT NULL default '0',
359 `FromIP` int(11) NOT NULL default '0',
360 `GType` tinyint(4) NOT NULL default '0',
361 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
362 `data_hash` varchar(32) NOT NULL default '',
363 `data` mediumblob NOT NULL,
364 KEY `MachineID` (`MachineID`),
365 KEY `GType` (`GType`),
366 KEY `Added` (`Added`)
367) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
368SET character_set_client = @saved_cs_client;
369
370--
371-- Dumping data for table `fgrab_0609`
372--
373
374LOCK TABLES `fgrab_0609` WRITE;
375/*!40000 ALTER TABLE `fgrab_0609` DISABLE KEYS */;
376/*!40000 ALTER TABLE `fgrab_0609` ENABLE KEYS */;
377UNLOCK TABLES;
378
379--
380-- Table structure for table `fgrab_rules`
381--
382
383DROP TABLE IF EXISTS `fgrab_rules`;
384SET @saved_cs_client = @@character_set_client;
385SET character_set_client = utf8;
386CREATE TABLE `fgrab_rules` (
387 `id` tinyint(4) NOT NULL default '0',
388 `name` varchar(200) NOT NULL default '',
389 `data_hash` varchar(32) NOT NULL default '',
390 `data` mediumblob NOT NULL,
391 PRIMARY KEY (`id`),
392 UNIQUE KEY `data_hash` (`data_hash`)
393) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
394SET character_set_client = @saved_cs_client;
395
396--
397-- Dumping data for table `fgrab_rules`
398--
399
400LOCK TABLES `fgrab_rules` WRITE;
401/*!40000 ALTER TABLE `fgrab_rules` DISABLE KEYS */;
402/*!40000 ALTER TABLE `fgrab_rules` ENABLE KEYS */;
403UNLOCK TABLES;
404
405--
406-- Table structure for table `fgrab_setting`
407--
408
409DROP TABLE IF EXISTS `fgrab_setting`;
410SET @saved_cs_client = @@character_set_client;
411SET character_set_client = utf8;
412CREATE TABLE `fgrab_setting` (
413 `s_name` varchar(25) NOT NULL default '',
414 `s_value` varchar(25) NOT NULL default '',
415 KEY `s_name` (`s_name`)
416) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
417SET character_set_client = @saved_cs_client;
418
419--
420-- Dumping data for table `fgrab_setting`
421--
422
423LOCK TABLES `fgrab_setting` WRITE;
424/*!40000 ALTER TABLE `fgrab_setting` DISABLE KEYS */;
425/*!40000 ALTER TABLE `fgrab_setting` ENABLE KEYS */;
426UNLOCK TABLES;
427
428--
429-- Table structure for table `fkt_commands`
430--
431
432DROP TABLE IF EXISTS `fkt_commands`;
433SET @saved_cs_client = @@character_set_client;
434SET character_set_client = utf8;
435CREATE TABLE `fkt_commands` (
436 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
437 `ForMachineID` varchar(16) NOT NULL default '',
438 `JobID` varchar(32) NOT NULL default '',
439 `cmd` text NOT NULL,
440 `result` tinyint(4) NOT NULL default '0',
441 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
442 PRIMARY KEY (`JobID`),
443 KEY `ForMachineID` (`ForMachineID`)
444) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
445SET character_set_client = @saved_cs_client;
446
447--
448-- Dumping data for table `fkt_commands`
449--
450
451LOCK TABLES `fkt_commands` WRITE;
452/*!40000 ALTER TABLE `fkt_commands` DISABLE KEYS */;
453/*!40000 ALTER TABLE `fkt_commands` ENABLE KEYS */;
454UNLOCK TABLES;
455
456--
457-- Table structure for table `fkt_users`
458--
459
460DROP TABLE IF EXISTS `fkt_users`;
461SET @saved_cs_client = @@character_set_client;
462SET character_set_client = utf8;
463CREATE TABLE `fkt_users` (
464 `MachineID` char(16) NOT NULL default '',
465 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
466 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
467 `Version` int(11) NOT NULL default '0',
468 `LastIP` int(11) NOT NULL default '0',
469 PRIMARY KEY (`MachineID`)
470) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
471SET character_set_client = @saved_cs_client;
472
473--
474-- Dumping data for table `fkt_users`
475--
476
477LOCK TABLES `fkt_users` WRITE;
478/*!40000 ALTER TABLE `fkt_users` DISABLE KEYS */;
479/*!40000 ALTER TABLE `fkt_users` ENABLE KEYS */;
480UNLOCK TABLES;
481
482--
483-- Table structure for table `fkt_xfiles`
484--
485
486DROP TABLE IF EXISTS `fkt_xfiles`;
487SET @saved_cs_client = @@character_set_client;
488SET character_set_client = utf8;
489CREATE TABLE `fkt_xfiles` (
490 `MachineID` varchar(16) NOT NULL default '',
491 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
492 `FileMD5` varchar(32) NOT NULL default '',
493 `Type` char(3) NOT NULL default '',
494 `Comment` varchar(180) NOT NULL default '',
495 `data` mediumblob NOT NULL,
496 UNIQUE KEY `FileMD5` (`FileMD5`),
497 KEY `MachineID` (`MachineID`)
498) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
499SET character_set_client = @saved_cs_client;
500
501--
502-- Dumping data for table `fkt_xfiles`
503--
504
505LOCK TABLES `fkt_xfiles` WRITE;
506/*!40000 ALTER TABLE `fkt_xfiles` DISABLE KEYS */;
507/*!40000 ALTER TABLE `fkt_xfiles` ENABLE KEYS */;
508UNLOCK TABLES;
509
510--
511-- Table structure for table `fkt_xfriendlynames`
512--
513
514DROP TABLE IF EXISTS `fkt_xfriendlynames`;
515SET @saved_cs_client = @@character_set_client;
516SET character_set_client = utf8;
517CREATE TABLE `fkt_xfriendlynames` (
518 `MachineID` varchar(16) NOT NULL default '',
519 `Name` varchar(255) NOT NULL default '',
520 PRIMARY KEY (`MachineID`)
521) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
522SET character_set_client = @saved_cs_client;
523
524--
525-- Dumping data for table `fkt_xfriendlynames`
526--
527
528LOCK TABLES `fkt_xfriendlynames` WRITE;
529/*!40000 ALTER TABLE `fkt_xfriendlynames` DISABLE KEYS */;
530/*!40000 ALTER TABLE `fkt_xfriendlynames` ENABLE KEYS */;
531UNLOCK TABLES;
532
533--
534-- Table structure for table `fkt_xips`
535--
536
537DROP TABLE IF EXISTS `fkt_xips`;
538SET @saved_cs_client = @@character_set_client;
539SET character_set_client = utf8;
540CREATE TABLE `fkt_xips` (
541 `MachineID` char(16) NOT NULL default '',
542 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
543 `IP` int(11) NOT NULL default '0',
544 PRIMARY KEY (`IP`),
545 KEY `MachineID` (`MachineID`),
546 KEY `DateTime` (`DateTime`)
547) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
548SET character_set_client = @saved_cs_client;
549
550--
551-- Dumping data for table `fkt_xips`
552--
553
554LOCK TABLES `fkt_xips` WRITE;
555/*!40000 ALTER TABLE `fkt_xips` DISABLE KEYS */;
556/*!40000 ALTER TABLE `fkt_xips` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Table structure for table `flscan_files`
561--
562
563DROP TABLE IF EXISTS `flscan_files`;
564SET @saved_cs_client = @@character_set_client;
565SET character_set_client = utf8;
566CREATE TABLE `flscan_files` (
567 `MachineID` varchar(16) NOT NULL default '',
568 `Version` int(11) NOT NULL default '0',
569 `FromIP` int(11) NOT NULL default '0',
570 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
571 `FileMD5` varchar(32) NOT NULL default '',
572 `Comment` varchar(180) NOT NULL default '',
573 `data` mediumblob NOT NULL,
574 PRIMARY KEY (`FileMD5`),
575 KEY `MachineID` (`MachineID`),
576 KEY `DateTimeAdded` (`DateTimeAdded`)
577) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
578SET character_set_client = @saved_cs_client;
579
580--
581-- Dumping data for table `flscan_files`
582--
583
584LOCK TABLES `flscan_files` WRITE;
585/*!40000 ALTER TABLE `flscan_files` DISABLE KEYS */;
586/*!40000 ALTER TABLE `flscan_files` ENABLE KEYS */;
587UNLOCK TABLES;
588
589--
590-- Table structure for table `frgrab_commands`
591--
592
593DROP TABLE IF EXISTS `frgrab_commands`;
594SET @saved_cs_client = @@character_set_client;
595SET character_set_client = utf8;
596CREATE TABLE `frgrab_commands` (
597 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
598 `ForMachineID` varchar(16) NOT NULL default '',
599 `JobID` varchar(32) NOT NULL default '',
600 `cmd` text NOT NULL,
601 `result` tinyint(4) NOT NULL default '0',
602 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
603 PRIMARY KEY (`JobID`),
604 KEY `ForMachineID` (`ForMachineID`)
605) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
606SET character_set_client = @saved_cs_client;
607
608--
609-- Dumping data for table `frgrab_commands`
610--
611
612LOCK TABLES `frgrab_commands` WRITE;
613/*!40000 ALTER TABLE `frgrab_commands` DISABLE KEYS */;
614/*!40000 ALTER TABLE `frgrab_commands` ENABLE KEYS */;
615UNLOCK TABLES;
616
617--
618-- Table structure for table `frgrab_users`
619--
620
621DROP TABLE IF EXISTS `frgrab_users`;
622SET @saved_cs_client = @@character_set_client;
623SET character_set_client = utf8;
624CREATE TABLE `frgrab_users` (
625 `MachineID` char(16) NOT NULL default '',
626 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
627 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
628 `Version` int(11) NOT NULL default '0',
629 `LastIP` int(11) NOT NULL default '0',
630 PRIMARY KEY (`MachineID`)
631) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
632SET character_set_client = @saved_cs_client;
633
634--
635-- Dumping data for table `frgrab_users`
636--
637
638LOCK TABLES `frgrab_users` WRITE;
639/*!40000 ALTER TABLE `frgrab_users` DISABLE KEYS */;
640/*!40000 ALTER TABLE `frgrab_users` ENABLE KEYS */;
641UNLOCK TABLES;
642
643--
644-- Table structure for table `frgrab_xfriendlynames`
645--
646
647DROP TABLE IF EXISTS `frgrab_xfriendlynames`;
648SET @saved_cs_client = @@character_set_client;
649SET character_set_client = utf8;
650CREATE TABLE `frgrab_xfriendlynames` (
651 `MachineID` varchar(16) NOT NULL default '',
652 `Name` varchar(255) NOT NULL default '',
653 PRIMARY KEY (`MachineID`)
654) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
655SET character_set_client = @saved_cs_client;
656
657--
658-- Dumping data for table `frgrab_xfriendlynames`
659--
660
661LOCK TABLES `frgrab_xfriendlynames` WRITE;
662/*!40000 ALTER TABLE `frgrab_xfriendlynames` DISABLE KEYS */;
663/*!40000 ALTER TABLE `frgrab_xfriendlynames` ENABLE KEYS */;
664UNLOCK TABLES;
665
666--
667-- Table structure for table `frgrab_xips`
668--
669
670DROP TABLE IF EXISTS `frgrab_xips`;
671SET @saved_cs_client = @@character_set_client;
672SET character_set_client = utf8;
673CREATE TABLE `frgrab_xips` (
674 `MachineID` char(16) NOT NULL default '',
675 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
676 `IP` int(11) NOT NULL default '0',
677 PRIMARY KEY (`IP`),
678 KEY `MachineID` (`MachineID`),
679 KEY `DateTime` (`DateTime`)
680) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
681SET character_set_client = @saved_cs_client;
682
683--
684-- Dumping data for table `frgrab_xips`
685--
686
687LOCK TABLES `frgrab_xips` WRITE;
688/*!40000 ALTER TABLE `frgrab_xips` DISABLE KEYS */;
689/*!40000 ALTER TABLE `frgrab_xips` ENABLE KEYS */;
690UNLOCK TABLES;
691
692--
693-- Table structure for table `ftpsniff_data`
694--
695
696DROP TABLE IF EXISTS `ftpsniff_data`;
697SET @saved_cs_client = @@character_set_client;
698SET character_set_client = utf8;
699CREATE TABLE `ftpsniff_data` (
700 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
701 `MachineID` varchar(16) NOT NULL default '',
702 `ReceivedFromIP` int(11) NOT NULL default '0',
703 `FTPIP` int(11) NOT NULL default '0',
704 `FTPPort` int(11) NOT NULL default '0',
705 `FTPHost` varchar(128) NOT NULL default '',
706 `FTPUser` varchar(128) NOT NULL default '',
707 `FTPPass` varchar(128) NOT NULL default '',
708 `hash` varchar(32) NOT NULL default '',
709 PRIMARY KEY (`DateTime`),
710 UNIQUE KEY `hash` (`hash`),
711 KEY `MachineID` (`MachineID`)
712) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
713SET character_set_client = @saved_cs_client;
714
715--
716-- Dumping data for table `ftpsniff_data`
717--
718
719LOCK TABLES `ftpsniff_data` WRITE;
720/*!40000 ALTER TABLE `ftpsniff_data` DISABLE KEYS */;
721/*!40000 ALTER TABLE `ftpsniff_data` ENABLE KEYS */;
722UNLOCK TABLES;
723
724--
725-- Table structure for table `ftpsniff_trashrules`
726--
727
728DROP TABLE IF EXISTS `ftpsniff_trashrules`;
729SET @saved_cs_client = @@character_set_client;
730SET character_set_client = utf8;
731CREATE TABLE `ftpsniff_trashrules` (
732 `name` varchar(200) NOT NULL default '',
733 `rule_hash` varchar(32) NOT NULL default '',
734 `rule_s` varchar(200) NOT NULL default '',
735 `rule_l` tinyint(4) NOT NULL default '0',
736 PRIMARY KEY (`rule_hash`)
737) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
738SET character_set_client = @saved_cs_client;
739
740--
741-- Dumping data for table `ftpsniff_trashrules`
742--
743
744LOCK TABLES `ftpsniff_trashrules` WRITE;
745/*!40000 ALTER TABLE `ftpsniff_trashrules` DISABLE KEYS */;
746/*!40000 ALTER TABLE `ftpsniff_trashrules` ENABLE KEYS */;
747UNLOCK TABLES;
748
749--
750-- Table structure for table `iba2_commands`
751--
752
753DROP TABLE IF EXISTS `iba2_commands`;
754SET @saved_cs_client = @@character_set_client;
755SET character_set_client = utf8;
756CREATE TABLE `iba2_commands` (
757 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
758 `ForMachineID` varchar(16) NOT NULL default '',
759 `JobID` varchar(32) NOT NULL default '',
760 `cmd` text NOT NULL,
761 `result` tinyint(4) NOT NULL default '0',
762 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
763 PRIMARY KEY (`JobID`),
764 KEY `ForMachineID` (`ForMachineID`)
765) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
766SET character_set_client = @saved_cs_client;
767
768--
769-- Dumping data for table `iba2_commands`
770--
771
772LOCK TABLES `iba2_commands` WRITE;
773/*!40000 ALTER TABLE `iba2_commands` DISABLE KEYS */;
774/*!40000 ALTER TABLE `iba2_commands` ENABLE KEYS */;
775UNLOCK TABLES;
776
777--
778-- Table structure for table `iba2_users`
779--
780
781DROP TABLE IF EXISTS `iba2_users`;
782SET @saved_cs_client = @@character_set_client;
783SET character_set_client = utf8;
784CREATE TABLE `iba2_users` (
785 `MachineID` char(16) NOT NULL default '',
786 `Browser` tinyint(4) NOT NULL default '0',
787 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
788 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
789 `Version` int(11) NOT NULL default '0',
790 `LastIP` int(11) NOT NULL default '0',
791 PRIMARY KEY (`MachineID`)
792) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
793SET character_set_client = @saved_cs_client;
794
795--
796-- Dumping data for table `iba2_users`
797--
798
799LOCK TABLES `iba2_users` WRITE;
800/*!40000 ALTER TABLE `iba2_users` DISABLE KEYS */;
801/*!40000 ALTER TABLE `iba2_users` ENABLE KEYS */;
802UNLOCK TABLES;
803
804--
805-- Table structure for table `iba2_xfiles`
806--
807
808DROP TABLE IF EXISTS `iba2_xfiles`;
809SET @saved_cs_client = @@character_set_client;
810SET character_set_client = utf8;
811CREATE TABLE `iba2_xfiles` (
812 `MachineID` varchar(16) NOT NULL default '',
813 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
814 `FileMD5` varchar(32) NOT NULL default '',
815 `Type` char(3) NOT NULL default '',
816 `data` mediumblob NOT NULL,
817 UNIQUE KEY `FileMD5` (`FileMD5`),
818 KEY `MachineID` (`MachineID`)
819) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
820SET character_set_client = @saved_cs_client;
821
822--
823-- Dumping data for table `iba2_xfiles`
824--
825
826LOCK TABLES `iba2_xfiles` WRITE;
827/*!40000 ALTER TABLE `iba2_xfiles` DISABLE KEYS */;
828/*!40000 ALTER TABLE `iba2_xfiles` ENABLE KEYS */;
829UNLOCK TABLES;
830
831--
832-- Table structure for table `iba2_xfriendlynames`
833--
834
835DROP TABLE IF EXISTS `iba2_xfriendlynames`;
836SET @saved_cs_client = @@character_set_client;
837SET character_set_client = utf8;
838CREATE TABLE `iba2_xfriendlynames` (
839 `MachineID` varchar(16) NOT NULL default '',
840 `Name` varchar(255) NOT NULL default '',
841 PRIMARY KEY (`MachineID`)
842) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
843SET character_set_client = @saved_cs_client;
844
845--
846-- Dumping data for table `iba2_xfriendlynames`
847--
848
849LOCK TABLES `iba2_xfriendlynames` WRITE;
850/*!40000 ALTER TABLE `iba2_xfriendlynames` DISABLE KEYS */;
851/*!40000 ALTER TABLE `iba2_xfriendlynames` ENABLE KEYS */;
852UNLOCK TABLES;
853
854--
855-- Table structure for table `iba2_xips`
856--
857
858DROP TABLE IF EXISTS `iba2_xips`;
859SET @saved_cs_client = @@character_set_client;
860SET character_set_client = utf8;
861CREATE TABLE `iba2_xips` (
862 `MachineID` char(16) NOT NULL default '',
863 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
864 `IP` int(11) NOT NULL default '0',
865 PRIMARY KEY (`IP`),
866 KEY `MachineID` (`MachineID`),
867 KEY `DateTime` (`DateTime`)
868) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
869SET character_set_client = @saved_cs_client;
870
871--
872-- Dumping data for table `iba2_xips`
873--
874
875LOCK TABLES `iba2_xips` WRITE;
876/*!40000 ALTER TABLE `iba2_xips` DISABLE KEYS */;
877/*!40000 ALTER TABLE `iba2_xips` ENABLE KEYS */;
878UNLOCK TABLES;
879
880--
881-- Table structure for table `iba2_xkeysmemo`
882--
883
884DROP TABLE IF EXISTS `iba2_xkeysmemo`;
885SET @saved_cs_client = @@character_set_client;
886SET character_set_client = utf8;
887CREATE TABLE `iba2_xkeysmemo` (
888 `MachineID` varchar(16) NOT NULL default '',
889 `KeyID` varchar(64) NOT NULL default '',
890 `Memo` mediumblob NOT NULL,
891 PRIMARY KEY (`KeyID`),
892 KEY `MachineID` (`MachineID`)
893) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
894SET character_set_client = @saved_cs_client;
895
896--
897-- Dumping data for table `iba2_xkeysmemo`
898--
899
900LOCK TABLES `iba2_xkeysmemo` WRITE;
901/*!40000 ALTER TABLE `iba2_xkeysmemo` DISABLE KEYS */;
902/*!40000 ALTER TABLE `iba2_xkeysmemo` ENABLE KEYS */;
903UNLOCK TABLES;
904
905--
906-- Table structure for table `iba2_xstats`
907--
908
909DROP TABLE IF EXISTS `iba2_xstats`;
910SET @saved_cs_client = @@character_set_client;
911SET character_set_client = utf8;
912CREATE TABLE `iba2_xstats` (
913 `MachineID` char(16) NOT NULL default '',
914 `Start` datetime NOT NULL default '0000-00-00 00:00:00',
915 `End` datetime NOT NULL default '0000-00-00 00:00:00',
916 `Type` tinyint(4) NOT NULL default '0',
917 KEY `MachineID` (`MachineID`)
918) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
919SET character_set_client = @saved_cs_client;
920
921--
922-- Dumping data for table `iba2_xstats`
923--
924
925LOCK TABLES `iba2_xstats` WRITE;
926/*!40000 ALTER TABLE `iba2_xstats` DISABLE KEYS */;
927/*!40000 ALTER TABLE `iba2_xstats` ENABLE KEYS */;
928UNLOCK TABLES;
929
930--
931-- Table structure for table `pageranks`
932--
933
934DROP TABLE IF EXISTS `pageranks`;
935SET @saved_cs_client = @@character_set_client;
936SET character_set_client = utf8;
937CREATE TABLE `pageranks` (
938 `Host` varchar(128) NOT NULL default '',
939 `PR` tinyint(4) NOT NULL default '0',
940 PRIMARY KEY (`Host`),
941 KEY `PR` (`PR`)
942) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
943SET character_set_client = @saved_cs_client;
944
945--
946-- Dumping data for table `pageranks`
947--
948
949LOCK TABLES `pageranks` WRITE;
950/*!40000 ALTER TABLE `pageranks` DISABLE KEYS */;
951/*!40000 ALTER TABLE `pageranks` ENABLE KEYS */;
952UNLOCK TABLES;
953
954--
955-- Table structure for table `plugins_updates`
956--
957
958DROP TABLE IF EXISTS `plugins_updates`;
959SET @saved_cs_client = @@character_set_client;
960SET character_set_client = utf8;
961CREATE TABLE `plugins_updates` (
962 `MachineID` char(16) NOT NULL default '',
963 `LastPluginsUpdate` datetime NOT NULL default '0000-00-00 00:00:00',
964 `LastIP` int(11) NOT NULL default '0',
965 `Country` char(2) NOT NULL default '',
966 PRIMARY KEY (`MachineID`),
967 KEY `Country` (`Country`)
968) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
969SET character_set_client = @saved_cs_client;
970
971--
972-- Dumping data for table `plugins_updates`
973--
974
975LOCK TABLES `plugins_updates` WRITE;
976/*!40000 ALTER TABLE `plugins_updates` DISABLE KEYS */;
977/*!40000 ALTER TABLE `plugins_updates` ENABLE KEYS */;
978UNLOCK TABLES;
979
980--
981-- Table structure for table `psb_commands`
982--
983
984DROP TABLE IF EXISTS `psb_commands`;
985SET @saved_cs_client = @@character_set_client;
986SET character_set_client = utf8;
987CREATE TABLE `psb_commands` (
988 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
989 `ForMachineID` varchar(16) NOT NULL default '',
990 `JobID` varchar(32) NOT NULL default '',
991 `cmd` text NOT NULL,
992 `result` tinyint(4) NOT NULL default '0',
993 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
994 PRIMARY KEY (`JobID`),
995 KEY `ForMachineID` (`ForMachineID`)
996) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
997SET character_set_client = @saved_cs_client;
998
999--
1000-- Dumping data for table `psb_commands`
1001--
1002
1003LOCK TABLES `psb_commands` WRITE;
1004/*!40000 ALTER TABLE `psb_commands` DISABLE KEYS */;
1005/*!40000 ALTER TABLE `psb_commands` ENABLE KEYS */;
1006UNLOCK TABLES;
1007
1008--
1009-- Table structure for table `psb_users`
1010--
1011
1012DROP TABLE IF EXISTS `psb_users`;
1013SET @saved_cs_client = @@character_set_client;
1014SET character_set_client = utf8;
1015CREATE TABLE `psb_users` (
1016 `MachineID` char(16) NOT NULL default '',
1017 `Browser` tinyint(4) NOT NULL default '0',
1018 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
1019 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
1020 `Version` int(11) NOT NULL default '0',
1021 `LastIP` int(11) NOT NULL default '0',
1022 PRIMARY KEY (`MachineID`)
1023) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1024SET character_set_client = @saved_cs_client;
1025
1026--
1027-- Dumping data for table `psb_users`
1028--
1029
1030LOCK TABLES `psb_users` WRITE;
1031/*!40000 ALTER TABLE `psb_users` DISABLE KEYS */;
1032/*!40000 ALTER TABLE `psb_users` ENABLE KEYS */;
1033UNLOCK TABLES;
1034
1035--
1036-- Table structure for table `psb_xfiles`
1037--
1038
1039DROP TABLE IF EXISTS `psb_xfiles`;
1040SET @saved_cs_client = @@character_set_client;
1041SET character_set_client = utf8;
1042CREATE TABLE `psb_xfiles` (
1043 `MachineID` varchar(16) NOT NULL default '',
1044 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
1045 `FileMD5` varchar(32) NOT NULL default '',
1046 `Type` char(3) NOT NULL default '',
1047 `data` mediumblob NOT NULL,
1048 UNIQUE KEY `FileMD5` (`FileMD5`),
1049 KEY `MachineID` (`MachineID`)
1050) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1051SET character_set_client = @saved_cs_client;
1052
1053--
1054-- Dumping data for table `psb_xfiles`
1055--
1056
1057LOCK TABLES `psb_xfiles` WRITE;
1058/*!40000 ALTER TABLE `psb_xfiles` DISABLE KEYS */;
1059/*!40000 ALTER TABLE `psb_xfiles` ENABLE KEYS */;
1060UNLOCK TABLES;
1061
1062--
1063-- Table structure for table `psb_xfriendlynames`
1064--
1065
1066DROP TABLE IF EXISTS `psb_xfriendlynames`;
1067SET @saved_cs_client = @@character_set_client;
1068SET character_set_client = utf8;
1069CREATE TABLE `psb_xfriendlynames` (
1070 `MachineID` varchar(16) NOT NULL default '',
1071 `Name` varchar(255) NOT NULL default '',
1072 PRIMARY KEY (`MachineID`)
1073) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1074SET character_set_client = @saved_cs_client;
1075
1076--
1077-- Dumping data for table `psb_xfriendlynames`
1078--
1079
1080LOCK TABLES `psb_xfriendlynames` WRITE;
1081/*!40000 ALTER TABLE `psb_xfriendlynames` DISABLE KEYS */;
1082/*!40000 ALTER TABLE `psb_xfriendlynames` ENABLE KEYS */;
1083UNLOCK TABLES;
1084
1085--
1086-- Table structure for table `psb_xips`
1087--
1088
1089DROP TABLE IF EXISTS `psb_xips`;
1090SET @saved_cs_client = @@character_set_client;
1091SET character_set_client = utf8;
1092CREATE TABLE `psb_xips` (
1093 `MachineID` char(16) NOT NULL default '',
1094 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
1095 `IP` int(11) NOT NULL default '0',
1096 PRIMARY KEY (`IP`),
1097 KEY `MachineID` (`MachineID`),
1098 KEY `DateTime` (`DateTime`)
1099) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1100SET character_set_client = @saved_cs_client;
1101
1102--
1103-- Dumping data for table `psb_xips`
1104--
1105
1106LOCK TABLES `psb_xips` WRITE;
1107/*!40000 ALTER TABLE `psb_xips` DISABLE KEYS */;
1108/*!40000 ALTER TABLE `psb_xips` ENABLE KEYS */;
1109UNLOCK TABLES;
1110
1111--
1112-- Table structure for table `psb_xkeysmemo`
1113--
1114
1115DROP TABLE IF EXISTS `psb_xkeysmemo`;
1116SET @saved_cs_client = @@character_set_client;
1117SET character_set_client = utf8;
1118CREATE TABLE `psb_xkeysmemo` (
1119 `MachineID` varchar(16) NOT NULL default '',
1120 `KeyID` varchar(64) NOT NULL default '',
1121 `Memo` mediumblob NOT NULL,
1122 PRIMARY KEY (`KeyID`),
1123 KEY `MachineID` (`MachineID`)
1124) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1125SET character_set_client = @saved_cs_client;
1126
1127--
1128-- Dumping data for table `psb_xkeysmemo`
1129--
1130
1131LOCK TABLES `psb_xkeysmemo` WRITE;
1132/*!40000 ALTER TABLE `psb_xkeysmemo` DISABLE KEYS */;
1133/*!40000 ALTER TABLE `psb_xkeysmemo` ENABLE KEYS */;
1134UNLOCK TABLES;
1135
1136--
1137-- Table structure for table `psb_xstats`
1138--
1139
1140DROP TABLE IF EXISTS `psb_xstats`;
1141SET @saved_cs_client = @@character_set_client;
1142SET character_set_client = utf8;
1143CREATE TABLE `psb_xstats` (
1144 `MachineID` char(16) NOT NULL default '',
1145 `Start` datetime NOT NULL default '0000-00-00 00:00:00',
1146 `End` datetime NOT NULL default '0000-00-00 00:00:00',
1147 `Type` tinyint(4) NOT NULL default '0',
1148 KEY `MachineID` (`MachineID`)
1149) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1150SET character_set_client = @saved_cs_client;
1151
1152--
1153-- Dumping data for table `psb_xstats`
1154--
1155
1156LOCK TABLES `psb_xstats` WRITE;
1157/*!40000 ALTER TABLE `psb_xstats` DISABLE KEYS */;
1158/*!40000 ALTER TABLE `psb_xstats` ENABLE KEYS */;
1159UNLOCK TABLES;
1160
1161--
1162-- Table structure for table `rfb_commands`
1163--
1164
1165DROP TABLE IF EXISTS `rfb_commands`;
1166SET @saved_cs_client = @@character_set_client;
1167SET character_set_client = utf8;
1168CREATE TABLE `rfb_commands` (
1169 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
1170 `ForMachineID` varchar(16) NOT NULL default '',
1171 `JobID` varchar(32) NOT NULL default '',
1172 `cmd` text NOT NULL,
1173 `result` tinyint(4) NOT NULL default '0',
1174 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
1175 PRIMARY KEY (`JobID`),
1176 KEY `ForMachineID` (`ForMachineID`)
1177) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1178SET character_set_client = @saved_cs_client;
1179
1180--
1181-- Dumping data for table `rfb_commands`
1182--
1183
1184LOCK TABLES `rfb_commands` WRITE;
1185/*!40000 ALTER TABLE `rfb_commands` DISABLE KEYS */;
1186/*!40000 ALTER TABLE `rfb_commands` ENABLE KEYS */;
1187UNLOCK TABLES;
1188
1189--
1190-- Table structure for table `rfb_users`
1191--
1192
1193DROP TABLE IF EXISTS `rfb_users`;
1194SET @saved_cs_client = @@character_set_client;
1195SET character_set_client = utf8;
1196CREATE TABLE `rfb_users` (
1197 `MachineID` char(16) NOT NULL default '',
1198 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
1199 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
1200 `Version` int(11) NOT NULL default '0',
1201 `LastIP` int(11) NOT NULL default '0',
1202 PRIMARY KEY (`MachineID`)
1203) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1204SET character_set_client = @saved_cs_client;
1205
1206--
1207-- Dumping data for table `rfb_users`
1208--
1209
1210LOCK TABLES `rfb_users` WRITE;
1211/*!40000 ALTER TABLE `rfb_users` DISABLE KEYS */;
1212/*!40000 ALTER TABLE `rfb_users` ENABLE KEYS */;
1213UNLOCK TABLES;
1214
1215--
1216-- Table structure for table `rfb_xfiles`
1217--
1218
1219DROP TABLE IF EXISTS `rfb_xfiles`;
1220SET @saved_cs_client = @@character_set_client;
1221SET character_set_client = utf8;
1222CREATE TABLE `rfb_xfiles` (
1223 `MachineID` varchar(16) NOT NULL default '',
1224 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
1225 `FileMD5` varchar(32) NOT NULL default '',
1226 `Type` char(3) NOT NULL default '',
1227 `Comment` varchar(180) NOT NULL default '',
1228 `data` mediumblob NOT NULL,
1229 UNIQUE KEY `FileMD5` (`FileMD5`),
1230 KEY `MachineID` (`MachineID`)
1231) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1232SET character_set_client = @saved_cs_client;
1233
1234--
1235-- Dumping data for table `rfb_xfiles`
1236--
1237
1238LOCK TABLES `rfb_xfiles` WRITE;
1239/*!40000 ALTER TABLE `rfb_xfiles` DISABLE KEYS */;
1240/*!40000 ALTER TABLE `rfb_xfiles` ENABLE KEYS */;
1241UNLOCK TABLES;
1242
1243--
1244-- Table structure for table `rfb_xfriendlynames`
1245--
1246
1247DROP TABLE IF EXISTS `rfb_xfriendlynames`;
1248SET @saved_cs_client = @@character_set_client;
1249SET character_set_client = utf8;
1250CREATE TABLE `rfb_xfriendlynames` (
1251 `MachineID` varchar(16) NOT NULL default '',
1252 `Name` varchar(255) NOT NULL default '',
1253 PRIMARY KEY (`MachineID`)
1254) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1255SET character_set_client = @saved_cs_client;
1256
1257--
1258-- Dumping data for table `rfb_xfriendlynames`
1259--
1260
1261LOCK TABLES `rfb_xfriendlynames` WRITE;
1262/*!40000 ALTER TABLE `rfb_xfriendlynames` DISABLE KEYS */;
1263/*!40000 ALTER TABLE `rfb_xfriendlynames` ENABLE KEYS */;
1264UNLOCK TABLES;
1265
1266--
1267-- Table structure for table `rfb_xips`
1268--
1269
1270DROP TABLE IF EXISTS `rfb_xips`;
1271SET @saved_cs_client = @@character_set_client;
1272SET character_set_client = utf8;
1273CREATE TABLE `rfb_xips` (
1274 `MachineID` char(16) NOT NULL default '',
1275 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
1276 `IP` int(11) NOT NULL default '0',
1277 PRIMARY KEY (`IP`),
1278 KEY `MachineID` (`MachineID`),
1279 KEY `DateTime` (`DateTime`)
1280) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1281SET character_set_client = @saved_cs_client;
1282
1283--
1284-- Dumping data for table `rfb_xips`
1285--
1286
1287LOCK TABLES `rfb_xips` WRITE;
1288/*!40000 ALTER TABLE `rfb_xips` DISABLE KEYS */;
1289/*!40000 ALTER TABLE `rfb_xips` ENABLE KEYS */;
1290UNLOCK TABLES;
1291
1292--
1293-- Table structure for table `vtb_commands`
1294--
1295
1296DROP TABLE IF EXISTS `vtb_commands`;
1297SET @saved_cs_client = @@character_set_client;
1298SET character_set_client = utf8;
1299CREATE TABLE `vtb_commands` (
1300 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
1301 `ForMachineID` varchar(16) NOT NULL default '',
1302 `JobID` varchar(32) NOT NULL default '',
1303 `cmd` text NOT NULL,
1304 `result` tinyint(4) NOT NULL default '0',
1305 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
1306 PRIMARY KEY (`JobID`),
1307 KEY `ForMachineID` (`ForMachineID`)
1308) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1309SET character_set_client = @saved_cs_client;
1310
1311--
1312-- Dumping data for table `vtb_commands`
1313--
1314
1315LOCK TABLES `vtb_commands` WRITE;
1316/*!40000 ALTER TABLE `vtb_commands` DISABLE KEYS */;
1317/*!40000 ALTER TABLE `vtb_commands` ENABLE KEYS */;
1318UNLOCK TABLES;
1319
1320--
1321-- Table structure for table `vtb_users`
1322--
1323
1324DROP TABLE IF EXISTS `vtb_users`;
1325SET @saved_cs_client = @@character_set_client;
1326SET character_set_client = utf8;
1327CREATE TABLE `vtb_users` (
1328 `MachineID` char(16) NOT NULL default '',
1329 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
1330 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
1331 `Version` int(11) NOT NULL default '0',
1332 `LastIP` int(11) NOT NULL default '0',
1333 PRIMARY KEY (`MachineID`)
1334) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1335SET character_set_client = @saved_cs_client;
1336
1337--
1338-- Dumping data for table `vtb_users`
1339--
1340
1341LOCK TABLES `vtb_users` WRITE;
1342/*!40000 ALTER TABLE `vtb_users` DISABLE KEYS */;
1343/*!40000 ALTER TABLE `vtb_users` ENABLE KEYS */;
1344UNLOCK TABLES;
1345
1346--
1347-- Table structure for table `vtb_xfiles`
1348--
1349
1350DROP TABLE IF EXISTS `vtb_xfiles`;
1351SET @saved_cs_client = @@character_set_client;
1352SET character_set_client = utf8;
1353CREATE TABLE `vtb_xfiles` (
1354 `MachineID` varchar(16) NOT NULL default '',
1355 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
1356 `FileMD5` varchar(32) NOT NULL default '',
1357 `Type` char(3) NOT NULL default '',
1358 `Comment` varchar(180) NOT NULL default '',
1359 `data` mediumblob NOT NULL,
1360 UNIQUE KEY `FileMD5` (`FileMD5`),
1361 KEY `MachineID` (`MachineID`)
1362) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1363SET character_set_client = @saved_cs_client;
1364
1365--
1366-- Dumping data for table `vtb_xfiles`
1367--
1368
1369LOCK TABLES `vtb_xfiles` WRITE;
1370/*!40000 ALTER TABLE `vtb_xfiles` DISABLE KEYS */;
1371/*!40000 ALTER TABLE `vtb_xfiles` ENABLE KEYS */;
1372UNLOCK TABLES;
1373
1374--
1375-- Table structure for table `vtb_xfriendlynames`
1376--
1377
1378DROP TABLE IF EXISTS `vtb_xfriendlynames`;
1379SET @saved_cs_client = @@character_set_client;
1380SET character_set_client = utf8;
1381CREATE TABLE `vtb_xfriendlynames` (
1382 `MachineID` varchar(16) NOT NULL default '',
1383 `Name` varchar(255) NOT NULL default '',
1384 PRIMARY KEY (`MachineID`)
1385) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1386SET character_set_client = @saved_cs_client;
1387
1388--
1389-- Dumping data for table `vtb_xfriendlynames`
1390--
1391
1392LOCK TABLES `vtb_xfriendlynames` WRITE;
1393/*!40000 ALTER TABLE `vtb_xfriendlynames` DISABLE KEYS */;
1394/*!40000 ALTER TABLE `vtb_xfriendlynames` ENABLE KEYS */;
1395UNLOCK TABLES;
1396
1397--
1398-- Table structure for table `vtb_xips`
1399--
1400
1401DROP TABLE IF EXISTS `vtb_xips`;
1402SET @saved_cs_client = @@character_set_client;
1403SET character_set_client = utf8;
1404CREATE TABLE `vtb_xips` (
1405 `MachineID` char(16) NOT NULL default '',
1406 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
1407 `IP` int(11) NOT NULL default '0',
1408 PRIMARY KEY (`IP`),
1409 KEY `MachineID` (`MachineID`),
1410 KEY `DateTime` (`DateTime`)
1411) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1412SET character_set_client = @saved_cs_client;
1413
1414--
1415-- Dumping data for table `vtb_xips`
1416--
1417
1418LOCK TABLES `vtb_xips` WRITE;
1419/*!40000 ALTER TABLE `vtb_xips` DISABLE KEYS */;
1420/*!40000 ALTER TABLE `vtb_xips` ENABLE KEYS */;
1421UNLOCK TABLES;
1422
1423--
1424-- Table structure for table `wm_bl`
1425--
1426
1427DROP TABLE IF EXISTS `wm_bl`;
1428SET @saved_cs_client = @@character_set_client;
1429SET character_set_client = utf8;
1430CREATE TABLE `wm_bl` (
1431 `WMID` varchar(12) NOT NULL default '',
1432 `LastUpdated` datetime NOT NULL default '0000-00-00 00:00:00',
1433 `Value` int(11) default NULL,
1434 UNIQUE KEY `WMID` (`WMID`)
1435) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1436SET character_set_client = @saved_cs_client;
1437
1438--
1439-- Dumping data for table `wm_bl`
1440--
1441
1442LOCK TABLES `wm_bl` WRITE;
1443/*!40000 ALTER TABLE `wm_bl` DISABLE KEYS */;
1444/*!40000 ALTER TABLE `wm_bl` ENABLE KEYS */;
1445UNLOCK TABLES;
1446
1447--
1448-- Table structure for table `wu_commands`
1449--
1450
1451DROP TABLE IF EXISTS `wu_commands`;
1452SET @saved_cs_client = @@character_set_client;
1453SET character_set_client = utf8;
1454CREATE TABLE `wu_commands` (
1455 `Added` datetime NOT NULL default '0000-00-00 00:00:00',
1456 `ForMachineID` varchar(16) NOT NULL default '',
1457 `JobID` varchar(32) NOT NULL default '',
1458 `cmd` text NOT NULL,
1459 `result` tinyint(4) NOT NULL default '0',
1460 `Finished` datetime NOT NULL default '0000-00-00 00:00:00',
1461 `filetoupload` mediumblob NOT NULL,
1462 `filememo` mediumblob NOT NULL,
1463 PRIMARY KEY (`JobID`),
1464 KEY `ForMachineID` (`ForMachineID`)
1465) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1466SET character_set_client = @saved_cs_client;
1467
1468--
1469-- Dumping data for table `wu_commands`
1470--
1471
1472LOCK TABLES `wu_commands` WRITE;
1473/*!40000 ALTER TABLE `wu_commands` DISABLE KEYS */;
1474/*!40000 ALTER TABLE `wu_commands` ENABLE KEYS */;
1475UNLOCK TABLES;
1476
1477--
1478-- Table structure for table `wu_users`
1479--
1480
1481DROP TABLE IF EXISTS `wu_users`;
1482SET @saved_cs_client = @@character_set_client;
1483SET character_set_client = utf8;
1484CREATE TABLE `wu_users` (
1485 `MachineID` char(16) NOT NULL default '',
1486 `FirstRun` datetime NOT NULL default '0000-00-00 00:00:00',
1487 `LastRun` datetime NOT NULL default '0000-00-00 00:00:00',
1488 `Version` int(11) NOT NULL default '0',
1489 `LastIP` int(11) NOT NULL default '0',
1490 PRIMARY KEY (`MachineID`)
1491) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1492SET character_set_client = @saved_cs_client;
1493
1494--
1495-- Dumping data for table `wu_users`
1496--
1497
1498LOCK TABLES `wu_users` WRITE;
1499/*!40000 ALTER TABLE `wu_users` DISABLE KEYS */;
1500/*!40000 ALTER TABLE `wu_users` ENABLE KEYS */;
1501UNLOCK TABLES;
1502
1503--
1504-- Table structure for table `wu_xfiles`
1505--
1506
1507DROP TABLE IF EXISTS `wu_xfiles`;
1508SET @saved_cs_client = @@character_set_client;
1509SET character_set_client = utf8;
1510CREATE TABLE `wu_xfiles` (
1511 `MachineID` varchar(16) NOT NULL default '',
1512 `DateTimeAdded` datetime NOT NULL default '0000-00-00 00:00:00',
1513 `FileMD5` varchar(32) NOT NULL default '',
1514 `Type` char(3) NOT NULL default '',
1515 `Comment` varchar(180) NOT NULL default '',
1516 `data` mediumblob NOT NULL,
1517 UNIQUE KEY `FileMD5` (`FileMD5`),
1518 KEY `MachineID` (`MachineID`)
1519) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1520SET character_set_client = @saved_cs_client;
1521
1522--
1523-- Dumping data for table `wu_xfiles`
1524--
1525
1526LOCK TABLES `wu_xfiles` WRITE;
1527/*!40000 ALTER TABLE `wu_xfiles` DISABLE KEYS */;
1528/*!40000 ALTER TABLE `wu_xfiles` ENABLE KEYS */;
1529UNLOCK TABLES;
1530
1531--
1532-- Table structure for table `wu_xfriendlynames`
1533--
1534
1535DROP TABLE IF EXISTS `wu_xfriendlynames`;
1536SET @saved_cs_client = @@character_set_client;
1537SET character_set_client = utf8;
1538CREATE TABLE `wu_xfriendlynames` (
1539 `MachineID` varchar(16) NOT NULL default '',
1540 `Name` varchar(255) NOT NULL default '',
1541 PRIMARY KEY (`MachineID`)
1542) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1543SET character_set_client = @saved_cs_client;
1544
1545--
1546-- Dumping data for table `wu_xfriendlynames`
1547--
1548
1549LOCK TABLES `wu_xfriendlynames` WRITE;
1550/*!40000 ALTER TABLE `wu_xfriendlynames` DISABLE KEYS */;
1551/*!40000 ALTER TABLE `wu_xfriendlynames` ENABLE KEYS */;
1552UNLOCK TABLES;
1553
1554--
1555-- Table structure for table `wu_xips`
1556--
1557
1558DROP TABLE IF EXISTS `wu_xips`;
1559SET @saved_cs_client = @@character_set_client;
1560SET character_set_client = utf8;
1561CREATE TABLE `wu_xips` (
1562 `MachineID` char(16) NOT NULL default '',
1563 `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
1564 `IP` int(11) NOT NULL default '0',
1565 PRIMARY KEY (`IP`),
1566 KEY `MachineID` (`MachineID`),
1567 KEY `DateTime` (`DateTime`)
1568) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1569SET character_set_client = @saved_cs_client;
1570
1571--
1572-- Dumping data for table `wu_xips`
1573--
1574
1575LOCK TABLES `wu_xips` WRITE;
1576/*!40000 ALTER TABLE `wu_xips` DISABLE KEYS */;
1577/*!40000 ALTER TABLE `wu_xips` ENABLE KEYS */;
1578UNLOCK TABLES;
1579
1580--
1581-- Table structure for table `wu_xstats`
1582--
1583
1584DROP TABLE IF EXISTS `wu_xstats`;
1585SET @saved_cs_client = @@character_set_client;
1586SET character_set_client = utf8;
1587CREATE TABLE `wu_xstats` (
1588 `MachineID` char(16) NOT NULL default '',
1589 `Start` datetime NOT NULL default '0000-00-00 00:00:00',
1590 `End` datetime NOT NULL default '0000-00-00 00:00:00',
1591 `Type` tinyint(4) NOT NULL default '0',
1592 KEY `MachineID` (`MachineID`)
1593) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1594SET character_set_client = @saved_cs_client;
1595
1596--
1597-- Dumping data for table `wu_xstats`
1598--
1599
1600LOCK TABLES `wu_xstats` WRITE;
1601/*!40000 ALTER TABLE `wu_xstats` DISABLE KEYS */;
1602/*!40000 ALTER TABLE `wu_xstats` ENABLE KEYS */;
1603UNLOCK TABLES;
1604
1605--
1606-- Table structure for table `xmemo`
1607--
1608
1609DROP TABLE IF EXISTS `xmemo`;
1610SET @saved_cs_client = @@character_set_client;
1611SET character_set_client = utf8;
1612CREATE TABLE `xmemo` (
1613 `MachineID` varchar(16) NOT NULL default '',
1614 `memo` varchar(128) NOT NULL default '',
1615 PRIMARY KEY (`MachineID`)
1616) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1617SET character_set_client = @saved_cs_client;
1618
1619--
1620-- Dumping data for table `xmemo`
1621--
1622
1623LOCK TABLES `xmemo` WRITE;
1624/*!40000 ALTER TABLE `xmemo` DISABLE KEYS */;
1625/*!40000 ALTER TABLE `xmemo` ENABLE KEYS */;
1626UNLOCK TABLES;
1627/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1628
1629/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1630/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1631/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1632/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1633/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1634/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1635/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1636
1637-- Dump completed on 2009-06-19 11:09:56