wok-stable view ocsreports/stuff/ocsbase.sql @ rev 11148
xterm: add xterm.desktop & xterm.png
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Tue Nov 01 09:40:24 2011 +0100 (2011-11-01) |
parents | |
children |
line source
1 -- MySQL dump 10.11
2 --
3 -- Host: localhost Database: ocsweb
4 -- ------------------------------------------------------
5 -- Server version 5.0.51b-log
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 */;
18 --
19 -- Table structure for table `accesslog`
20 --
21 USE ocsweb;
23 DROP TABLE IF EXISTS `accesslog`;
24 SET @saved_cs_client = @@character_set_client;
25 SET character_set_client = utf8;
26 CREATE TABLE `accesslog` (
27 `ID` int(11) NOT NULL auto_increment,
28 `HARDWARE_ID` int(11) NOT NULL,
29 `USERID` varchar(255) default NULL,
30 `LOGDATE` datetime default NULL,
31 `PROCESSES` text,
32 PRIMARY KEY (`HARDWARE_ID`,`ID`),
33 KEY `ID` (`ID`)
34 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35 SET character_set_client = @saved_cs_client;
37 --
38 -- Dumping data for table `accesslog`
39 --
41 LOCK TABLES `accesslog` WRITE;
42 /*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;
43 /*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;
44 UNLOCK TABLES;
46 --
47 -- Table structure for table `accountinfo`
48 --
50 DROP TABLE IF EXISTS `accountinfo`;
51 SET @saved_cs_client = @@character_set_client;
52 SET character_set_client = utf8;
53 CREATE TABLE `accountinfo` (
54 `HARDWARE_ID` int(11) NOT NULL,
55 `TAG` varchar(255) default 'NA',
56 PRIMARY KEY (`HARDWARE_ID`),
57 KEY `TAG` (`TAG`)
58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59 SET character_set_client = @saved_cs_client;
61 --
62 -- Dumping data for table `accountinfo`
63 --
65 LOCK TABLES `accountinfo` WRITE;
66 /*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */;
67 /*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */;
68 UNLOCK TABLES;
70 --
71 -- Table structure for table `bios`
72 --
74 DROP TABLE IF EXISTS `bios`;
75 SET @saved_cs_client = @@character_set_client;
76 SET character_set_client = utf8;
77 CREATE TABLE `bios` (
78 `HARDWARE_ID` int(11) NOT NULL,
79 `SMANUFACTURER` varchar(255) default NULL,
80 `SMODEL` varchar(255) default NULL,
81 `SSN` varchar(255) default NULL,
82 `TYPE` varchar(255) default NULL,
83 `BMANUFACTURER` varchar(255) default NULL,
84 `BVERSION` varchar(255) default NULL,
85 `BDATE` varchar(255) default NULL,
86 PRIMARY KEY (`HARDWARE_ID`),
87 KEY `SSN` (`SSN`)
88 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89 SET character_set_client = @saved_cs_client;
91 --
92 -- Dumping data for table `bios`
93 --
95 LOCK TABLES `bios` WRITE;
96 /*!40000 ALTER TABLE `bios` DISABLE KEYS */;
97 /*!40000 ALTER TABLE `bios` ENABLE KEYS */;
98 UNLOCK TABLES;
100 --
101 -- Table structure for table `config`
102 --
104 DROP TABLE IF EXISTS `config`;
105 SET @saved_cs_client = @@character_set_client;
106 SET character_set_client = utf8;
107 CREATE TABLE `config` (
108 `NAME` varchar(50) NOT NULL,
109 `IVALUE` int(11) default NULL,
110 `TVALUE` varchar(255) default NULL,
111 `COMMENTS` text,
112 PRIMARY KEY (`NAME`)
113 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
114 SET character_set_client = @saved_cs_client;
116 --
117 -- Dumping data for table `config`
118 --
120 LOCK TABLES `config` WRITE;
121 /*!40000 ALTER TABLE `config` DISABLE KEYS */;
122 INSERT INTO `config` VALUES ('FREQUENCY',0,'','Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),('PROLOG_FREQ',24,'','Specify the frequency (hours) of prolog, on agents'),('IPDISCOVER',2,'','Max number of computers per gateway retrieving IP on the network'),('INVENTORY_DIFF',1,'','Activate/Deactivate inventory incremental writing'),('IPDISCOVER_LATENCY',100,'','Default latency between two arp requests'),('INVENTORY_TRANSACTION',1,'','Enable/disable db commit at each inventory section'),('REGISTRY',0,'','Activates or not the registry query function'),('IPDISCOVER_MAX_ALIVE',7,'','Max number of days before an Ip Discover computer is replaced'),('DEPLOY',1,'','Activates or not the automatic deployment option'),('UPDATE',0,'','Activates or not the update feature'),('GUI_VERSION',0,'4100','Version of the installed GUI and database'),('TRACE_DELETED',0,'','Trace deleted/duplicated computers (Activated by GLPI)'),('LOGLEVEL',0,'','ocs engine loglevel'),('AUTO_DUPLICATE_LVL',7,'','Duplicates bitmap'),('DOWNLOAD',0,'','Activate softwares auto deployment feature'),('DOWNLOAD_CYCLE_LATENCY',60,'','Time between two cycles (seconds)'),('DOWNLOAD_PERIOD_LENGTH',10,'','Number of cycles in a period'),('DOWNLOAD_FRAG_LATENCY',10,'','Time between two downloads (seconds)'),('DOWNLOAD_PERIOD_LATENCY',0,'','Time between two periods (seconds)'),('DOWNLOAD_TIMEOUT',30,'','Validity of a package (in days)'),('LOCAL_SERVER',0,'localhost','Server address used for local import'),('LOCAL_PORT',80,'','Server port used for local import');
123 /*!40000 ALTER TABLE `config` ENABLE KEYS */;
124 UNLOCK TABLES;
126 --
127 -- Table structure for table `conntrack`
128 --
130 DROP TABLE IF EXISTS `conntrack`;
131 SET @saved_cs_client = @@character_set_client;
132 SET character_set_client = utf8;
133 CREATE TABLE `conntrack` (
134 `IP` varchar(255) NOT NULL default '',
135 `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
136 PRIMARY KEY (`IP`)
137 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;
138 SET character_set_client = @saved_cs_client;
140 --
141 -- Dumping data for table `conntrack`
142 --
144 LOCK TABLES `conntrack` WRITE;
145 /*!40000 ALTER TABLE `conntrack` DISABLE KEYS */;
146 /*!40000 ALTER TABLE `conntrack` ENABLE KEYS */;
147 UNLOCK TABLES;
149 --
150 -- Table structure for table `controllers`
151 --
153 DROP TABLE IF EXISTS `controllers`;
154 SET @saved_cs_client = @@character_set_client;
155 SET character_set_client = utf8;
156 CREATE TABLE `controllers` (
157 `ID` int(11) NOT NULL auto_increment,
158 `HARDWARE_ID` int(11) NOT NULL,
159 `MANUFACTURER` varchar(255) default NULL,
160 `NAME` varchar(255) default NULL,
161 `CAPTION` varchar(255) default NULL,
162 `DESCRIPTION` varchar(255) default NULL,
163 `VERSION` varchar(255) default NULL,
164 `TYPE` varchar(255) default NULL,
165 PRIMARY KEY (`HARDWARE_ID`,`ID`),
166 KEY `ID` (`ID`)
167 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168 SET character_set_client = @saved_cs_client;
170 --
171 -- Dumping data for table `controllers`
172 --
174 LOCK TABLES `controllers` WRITE;
175 /*!40000 ALTER TABLE `controllers` DISABLE KEYS */;
176 /*!40000 ALTER TABLE `controllers` ENABLE KEYS */;
177 UNLOCK TABLES;
179 --
180 -- Table structure for table `deleted_equiv`
181 --
183 DROP TABLE IF EXISTS `deleted_equiv`;
184 SET @saved_cs_client = @@character_set_client;
185 SET character_set_client = utf8;
186 CREATE TABLE `deleted_equiv` (
187 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
188 `DELETED` varchar(255) NOT NULL,
189 `EQUIVALENT` varchar(255) default NULL
190 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
191 SET character_set_client = @saved_cs_client;
193 --
194 -- Dumping data for table `deleted_equiv`
195 --
197 LOCK TABLES `deleted_equiv` WRITE;
198 /*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */;
199 /*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */;
200 UNLOCK TABLES;
202 --
203 -- Table structure for table `deploy`
204 --
206 DROP TABLE IF EXISTS `deploy`;
207 SET @saved_cs_client = @@character_set_client;
208 SET character_set_client = utf8;
209 CREATE TABLE `deploy` (
210 `NAME` varchar(255) NOT NULL,
211 `CONTENT` longblob NOT NULL,
212 PRIMARY KEY (`NAME`)
213 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
214 SET character_set_client = @saved_cs_client;
216 --
217 -- Dumping data for table `deploy`
218 --
220 LOCK TABLES `deploy` WRITE;
221 /*!40000 ALTER TABLE `deploy` DISABLE KEYS */;
222 /*!40000 ALTER TABLE `deploy` ENABLE KEYS */;
223 UNLOCK TABLES;
225 --
226 -- Table structure for table `devices`
227 --
229 DROP TABLE IF EXISTS `devices`;
230 SET @saved_cs_client = @@character_set_client;
231 SET character_set_client = utf8;
232 CREATE TABLE `devices` (
233 `HARDWARE_ID` int(11) NOT NULL,
234 `NAME` varchar(50) NOT NULL,
235 `IVALUE` int(11) default NULL,
236 `TVALUE` varchar(255) default NULL,
237 `COMMENTS` text,
238 KEY `HARDWARE_ID` (`HARDWARE_ID`),
239 KEY `TVALUE` (`TVALUE`)
240 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
241 SET character_set_client = @saved_cs_client;
243 --
244 -- Dumping data for table `devices`
245 --
247 LOCK TABLES `devices` WRITE;
248 /*!40000 ALTER TABLE `devices` DISABLE KEYS */;
249 /*!40000 ALTER TABLE `devices` ENABLE KEYS */;
250 UNLOCK TABLES;
252 --
253 -- Table structure for table `devicetype`
254 --
256 DROP TABLE IF EXISTS `devicetype`;
257 SET @saved_cs_client = @@character_set_client;
258 SET character_set_client = utf8;
259 CREATE TABLE `devicetype` (
260 `ID` int(11) NOT NULL auto_increment,
261 `NAME` varchar(255) default NULL,
262 PRIMARY KEY (`ID`)
263 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
264 SET character_set_client = @saved_cs_client;
266 --
267 -- Dumping data for table `devicetype`
268 --
270 LOCK TABLES `devicetype` WRITE;
271 /*!40000 ALTER TABLE `devicetype` DISABLE KEYS */;
272 /*!40000 ALTER TABLE `devicetype` ENABLE KEYS */;
273 UNLOCK TABLES;
275 --
276 -- Table structure for table `dico_cat`
277 --
279 DROP TABLE IF EXISTS `dico_cat`;
280 SET @saved_cs_client = @@character_set_client;
281 SET character_set_client = utf8;
282 CREATE TABLE `dico_cat` (
283 `NAME` varchar(255) NOT NULL,
284 `PERMANENT` tinyint(4) default '0',
285 PRIMARY KEY (`NAME`)
286 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
287 SET character_set_client = @saved_cs_client;
289 --
290 -- Dumping data for table `dico_cat`
291 --
293 LOCK TABLES `dico_cat` WRITE;
294 /*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */;
295 /*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */;
296 UNLOCK TABLES;
298 --
299 -- Table structure for table `dico_ignored`
300 --
302 DROP TABLE IF EXISTS `dico_ignored`;
303 SET @saved_cs_client = @@character_set_client;
304 SET character_set_client = utf8;
305 CREATE TABLE `dico_ignored` (
306 `EXTRACTED` varchar(255) NOT NULL,
307 PRIMARY KEY (`EXTRACTED`)
308 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
309 SET character_set_client = @saved_cs_client;
311 --
312 -- Dumping data for table `dico_ignored`
313 --
315 LOCK TABLES `dico_ignored` WRITE;
316 /*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */;
317 /*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */;
318 UNLOCK TABLES;
320 --
321 -- Table structure for table `dico_soft`
322 --
324 DROP TABLE IF EXISTS `dico_soft`;
325 SET @saved_cs_client = @@character_set_client;
326 SET character_set_client = utf8;
327 CREATE TABLE `dico_soft` (
328 `EXTRACTED` varchar(255) NOT NULL,
329 `FORMATTED` varchar(255) NOT NULL,
330 PRIMARY KEY (`EXTRACTED`)
331 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
332 SET character_set_client = @saved_cs_client;
334 --
335 -- Dumping data for table `dico_soft`
336 --
338 LOCK TABLES `dico_soft` WRITE;
339 /*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */;
340 /*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */;
341 UNLOCK TABLES;
343 --
344 -- Table structure for table `download_available`
345 --
347 DROP TABLE IF EXISTS `download_available`;
348 SET @saved_cs_client = @@character_set_client;
349 SET character_set_client = utf8;
350 CREATE TABLE `download_available` (
351 `FILEID` varchar(255) NOT NULL,
352 `NAME` varchar(255) NOT NULL,
353 `PRIORITY` int(11) NOT NULL,
354 `FRAGMENTS` int(11) NOT NULL,
355 `SIZE` int(11) NOT NULL,
356 `OSNAME` varchar(255) NOT NULL,
357 `COMMENT` text,
358 PRIMARY KEY (`FILEID`)
359 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
360 SET character_set_client = @saved_cs_client;
362 --
363 -- Dumping data for table `download_available`
364 --
366 LOCK TABLES `download_available` WRITE;
367 /*!40000 ALTER TABLE `download_available` DISABLE KEYS */;
368 /*!40000 ALTER TABLE `download_available` ENABLE KEYS */;
369 UNLOCK TABLES;
371 --
372 -- Table structure for table `download_enable`
373 --
375 DROP TABLE IF EXISTS `download_enable`;
376 SET @saved_cs_client = @@character_set_client;
377 SET character_set_client = utf8;
378 CREATE TABLE `download_enable` (
379 `ID` int(11) NOT NULL auto_increment,
380 `FILEID` varchar(255) NOT NULL,
381 `INFO_LOC` varchar(255) NOT NULL,
382 `PACK_LOC` varchar(255) NOT NULL,
383 `CERT_PATH` varchar(255) default NULL,
384 `CERT_FILE` varchar(255) default NULL,
385 PRIMARY KEY (`ID`)
386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
387 SET character_set_client = @saved_cs_client;
389 --
390 -- Dumping data for table `download_enable`
391 --
393 LOCK TABLES `download_enable` WRITE;
394 /*!40000 ALTER TABLE `download_enable` DISABLE KEYS */;
395 /*!40000 ALTER TABLE `download_enable` ENABLE KEYS */;
396 UNLOCK TABLES;
398 --
399 -- Table structure for table `download_history`
400 --
402 DROP TABLE IF EXISTS `download_history`;
403 SET @saved_cs_client = @@character_set_client;
404 SET character_set_client = utf8;
405 CREATE TABLE `download_history` (
406 `HARDWARE_ID` int(11) NOT NULL,
407 `PKG_ID` int(11) NOT NULL default '0',
408 `PKG_NAME` varchar(255) default NULL,
409 PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`)
410 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
411 SET character_set_client = @saved_cs_client;
413 --
414 -- Dumping data for table `download_history`
415 --
417 LOCK TABLES `download_history` WRITE;
418 /*!40000 ALTER TABLE `download_history` DISABLE KEYS */;
419 /*!40000 ALTER TABLE `download_history` ENABLE KEYS */;
420 UNLOCK TABLES;
422 --
423 -- Table structure for table `drives`
424 --
426 DROP TABLE IF EXISTS `drives`;
427 SET @saved_cs_client = @@character_set_client;
428 SET character_set_client = utf8;
429 CREATE TABLE `drives` (
430 `ID` int(11) NOT NULL auto_increment,
431 `HARDWARE_ID` int(11) NOT NULL,
432 `LETTER` varchar(255) default NULL,
433 `TYPE` varchar(255) default NULL,
434 `FILESYSTEM` varchar(255) default NULL,
435 `TOTAL` int(11) default NULL,
436 `FREE` int(11) default NULL,
437 `NUMFILES` int(11) default NULL,
438 `VOLUMN` varchar(255) default NULL,
439 PRIMARY KEY (`HARDWARE_ID`,`ID`),
440 KEY `ID` (`ID`)
441 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
442 SET character_set_client = @saved_cs_client;
444 --
445 -- Dumping data for table `drives`
446 --
448 LOCK TABLES `drives` WRITE;
449 /*!40000 ALTER TABLE `drives` DISABLE KEYS */;
450 /*!40000 ALTER TABLE `drives` ENABLE KEYS */;
451 UNLOCK TABLES;
453 --
454 -- Table structure for table `files`
455 --
457 DROP TABLE IF EXISTS `files`;
458 SET @saved_cs_client = @@character_set_client;
459 SET character_set_client = utf8;
460 CREATE TABLE `files` (
461 `NAME` varchar(255) NOT NULL,
462 `VERSION` varchar(255) NOT NULL,
463 `OS` varchar(255) NOT NULL,
464 `CONTENT` longblob NOT NULL,
465 PRIMARY KEY (`NAME`,`OS`,`VERSION`)
466 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
467 SET character_set_client = @saved_cs_client;
469 --
470 -- Dumping data for table `files`
471 --
473 LOCK TABLES `files` WRITE;
474 /*!40000 ALTER TABLE `files` DISABLE KEYS */;
475 /*!40000 ALTER TABLE `files` ENABLE KEYS */;
476 UNLOCK TABLES;
478 --
479 -- Table structure for table `hardware`
480 --
482 DROP TABLE IF EXISTS `hardware`;
483 SET @saved_cs_client = @@character_set_client;
484 SET character_set_client = utf8;
485 CREATE TABLE `hardware` (
486 `ID` int(11) NOT NULL auto_increment,
487 `DEVICEID` varchar(255) NOT NULL,
488 `NAME` varchar(255) default NULL,
489 `WORKGROUP` varchar(255) default NULL,
490 `USERDOMAIN` varchar(255) default NULL,
491 `OSNAME` varchar(255) default NULL,
492 `OSVERSION` varchar(255) default NULL,
493 `OSCOMMENTS` varchar(255) default NULL,
494 `PROCESSORT` varchar(255) default NULL,
495 `PROCESSORS` int(11) default '0',
496 `PROCESSORN` smallint(6) default NULL,
497 `MEMORY` int(11) default NULL,
498 `SWAP` int(11) default NULL,
499 `IPADDR` varchar(255) default NULL,
500 `ETIME` datetime default NULL,
501 `LASTDATE` datetime default NULL,
502 `LASTCOME` datetime default NULL,
503 `QUALITY` decimal(4,3) default '0.000',
504 `FIDELITY` bigint(20) default '1',
505 `USERID` varchar(255) default NULL,
506 `TYPE` int(11) default NULL,
507 `DESCRIPTION` varchar(255) default NULL,
508 `WINCOMPANY` varchar(255) default NULL,
509 `WINOWNER` varchar(255) default NULL,
510 `WINPRODID` varchar(255) default NULL,
511 `WINPRODKEY` varchar(255) default NULL,
512 `USERAGENT` varchar(50) default NULL,
513 `CHECKSUM` int(11) default '131071',
514 PRIMARY KEY (`DEVICEID`,`ID`),
515 KEY `NAME` (`NAME`),
516 KEY `CHECKSUM` (`CHECKSUM`),
517 KEY `DEVICEID` (`DEVICEID`),
518 KEY `ID` (`ID`)
519 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
520 SET character_set_client = @saved_cs_client;
522 --
523 -- Dumping data for table `hardware`
524 --
526 LOCK TABLES `hardware` WRITE;
527 /*!40000 ALTER TABLE `hardware` DISABLE KEYS */;
528 /*!40000 ALTER TABLE `hardware` ENABLE KEYS */;
529 UNLOCK TABLES;
531 --
532 -- Table structure for table `inputs`
533 --
535 DROP TABLE IF EXISTS `inputs`;
536 SET @saved_cs_client = @@character_set_client;
537 SET character_set_client = utf8;
538 CREATE TABLE `inputs` (
539 `ID` int(11) NOT NULL auto_increment,
540 `HARDWARE_ID` int(11) NOT NULL,
541 `TYPE` varchar(255) default NULL,
542 `MANUFACTURER` varchar(255) default NULL,
543 `CAPTION` varchar(255) default NULL,
544 `DESCRIPTION` varchar(255) default NULL,
545 `INTERFACE` varchar(255) default NULL,
546 `POINTTYPE` varchar(255) default NULL,
547 PRIMARY KEY (`HARDWARE_ID`,`ID`),
548 KEY `ID` (`ID`)
549 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
550 SET character_set_client = @saved_cs_client;
552 --
553 -- Dumping data for table `inputs`
554 --
556 LOCK TABLES `inputs` WRITE;
557 /*!40000 ALTER TABLE `inputs` DISABLE KEYS */;
558 /*!40000 ALTER TABLE `inputs` ENABLE KEYS */;
559 UNLOCK TABLES;
561 --
562 -- Table structure for table `locks`
563 --
565 DROP TABLE IF EXISTS `locks`;
566 SET @saved_cs_client = @@character_set_client;
567 SET character_set_client = utf8;
568 CREATE TABLE `locks` (
569 `HARDWARE_ID` int(11) NOT NULL,
570 `ID` int(11) default NULL,
571 `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
572 PRIMARY KEY (`HARDWARE_ID`),
573 KEY `SINCE` (`SINCE`)
574 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;
575 SET character_set_client = @saved_cs_client;
577 --
578 -- Dumping data for table `locks`
579 --
581 LOCK TABLES `locks` WRITE;
582 /*!40000 ALTER TABLE `locks` DISABLE KEYS */;
583 /*!40000 ALTER TABLE `locks` ENABLE KEYS */;
584 UNLOCK TABLES;
586 --
587 -- Table structure for table `memories`
588 --
590 DROP TABLE IF EXISTS `memories`;
591 SET @saved_cs_client = @@character_set_client;
592 SET character_set_client = utf8;
593 CREATE TABLE `memories` (
594 `ID` int(11) NOT NULL auto_increment,
595 `HARDWARE_ID` int(11) NOT NULL,
596 `CAPTION` varchar(255) default NULL,
597 `DESCRIPTION` varchar(255) default NULL,
598 `CAPACITY` varchar(255) default NULL,
599 `PURPOSE` varchar(255) default NULL,
600 `TYPE` varchar(255) default NULL,
601 `SPEED` varchar(255) default NULL,
602 `NUMSLOTS` smallint(6) default NULL,
603 PRIMARY KEY (`HARDWARE_ID`,`ID`),
604 KEY `ID` (`ID`)
605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
606 SET character_set_client = @saved_cs_client;
608 --
609 -- Dumping data for table `memories`
610 --
612 LOCK TABLES `memories` WRITE;
613 /*!40000 ALTER TABLE `memories` DISABLE KEYS */;
614 /*!40000 ALTER TABLE `memories` ENABLE KEYS */;
615 UNLOCK TABLES;
617 --
618 -- Table structure for table `modems`
619 --
621 DROP TABLE IF EXISTS `modems`;
622 SET @saved_cs_client = @@character_set_client;
623 SET character_set_client = utf8;
624 CREATE TABLE `modems` (
625 `ID` int(11) NOT NULL auto_increment,
626 `HARDWARE_ID` int(11) NOT NULL,
627 `NAME` varchar(255) default NULL,
628 `MODEL` varchar(255) default NULL,
629 `DESCRIPTION` varchar(255) default NULL,
630 `TYPE` varchar(255) default NULL,
631 PRIMARY KEY (`HARDWARE_ID`,`ID`),
632 KEY `ID` (`ID`)
633 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
634 SET character_set_client = @saved_cs_client;
636 --
637 -- Dumping data for table `modems`
638 --
640 LOCK TABLES `modems` WRITE;
641 /*!40000 ALTER TABLE `modems` DISABLE KEYS */;
642 /*!40000 ALTER TABLE `modems` ENABLE KEYS */;
643 UNLOCK TABLES;
645 --
646 -- Table structure for table `monitors`
647 --
649 DROP TABLE IF EXISTS `monitors`;
650 SET @saved_cs_client = @@character_set_client;
651 SET character_set_client = utf8;
652 CREATE TABLE `monitors` (
653 `ID` int(11) NOT NULL auto_increment,
654 `HARDWARE_ID` int(11) NOT NULL,
655 `MANUFACTURER` varchar(255) default NULL,
656 `CAPTION` varchar(255) default NULL,
657 `DESCRIPTION` varchar(255) default NULL,
658 `TYPE` varchar(255) default NULL,
659 `SERIAL` varchar(255) default NULL,
660 PRIMARY KEY (`HARDWARE_ID`,`ID`),
661 KEY `ID` (`ID`)
662 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
663 SET character_set_client = @saved_cs_client;
665 --
666 -- Dumping data for table `monitors`
667 --
669 LOCK TABLES `monitors` WRITE;
670 /*!40000 ALTER TABLE `monitors` DISABLE KEYS */;
671 /*!40000 ALTER TABLE `monitors` ENABLE KEYS */;
672 UNLOCK TABLES;
674 --
675 -- Table structure for table `netmap`
676 --
678 DROP TABLE IF EXISTS `netmap`;
679 SET @saved_cs_client = @@character_set_client;
680 SET character_set_client = utf8;
681 CREATE TABLE `netmap` (
682 `IP` varchar(15) NOT NULL,
683 `MAC` varchar(17) NOT NULL,
684 `MASK` varchar(15) NOT NULL,
685 `NETID` varchar(15) NOT NULL,
686 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
687 `NAME` varchar(255) default NULL,
688 PRIMARY KEY (`MAC`),
689 KEY `IP` (`IP`),
690 KEY `NETID` (`NETID`)
691 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
692 SET character_set_client = @saved_cs_client;
694 --
695 -- Dumping data for table `netmap`
696 --
698 LOCK TABLES `netmap` WRITE;
699 /*!40000 ALTER TABLE `netmap` DISABLE KEYS */;
700 /*!40000 ALTER TABLE `netmap` ENABLE KEYS */;
701 UNLOCK TABLES;
703 --
704 -- Table structure for table `network_devices`
705 --
707 DROP TABLE IF EXISTS `network_devices`;
708 SET @saved_cs_client = @@character_set_client;
709 SET character_set_client = utf8;
710 CREATE TABLE `network_devices` (
711 `ID` int(11) NOT NULL auto_increment,
712 `DESCRIPTION` varchar(255) default NULL,
713 `TYPE` varchar(255) default NULL,
714 `MACADDR` varchar(255) default NULL,
715 `USER` varchar(255) default NULL,
716 PRIMARY KEY (`ID`),
717 KEY `MACADDR` (`MACADDR`)
718 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
719 SET character_set_client = @saved_cs_client;
721 --
722 -- Dumping data for table `network_devices`
723 --
725 LOCK TABLES `network_devices` WRITE;
726 /*!40000 ALTER TABLE `network_devices` DISABLE KEYS */;
727 /*!40000 ALTER TABLE `network_devices` ENABLE KEYS */;
728 UNLOCK TABLES;
730 --
731 -- Table structure for table `networks`
732 --
734 DROP TABLE IF EXISTS `networks`;
735 SET @saved_cs_client = @@character_set_client;
736 SET character_set_client = utf8;
737 CREATE TABLE `networks` (
738 `ID` int(11) NOT NULL auto_increment,
739 `HARDWARE_ID` int(11) NOT NULL,
740 `DESCRIPTION` varchar(255) default NULL,
741 `TYPE` varchar(255) default NULL,
742 `TYPEMIB` varchar(255) default NULL,
743 `SPEED` varchar(255) default NULL,
744 `MACADDR` varchar(255) default NULL,
745 `STATUS` varchar(255) default NULL,
746 `IPADDRESS` varchar(255) default NULL,
747 `IPMASK` varchar(255) default NULL,
748 `IPGATEWAY` varchar(255) default NULL,
749 `IPSUBNET` varchar(255) default NULL,
750 `IPDHCP` varchar(255) default NULL,
751 PRIMARY KEY (`HARDWARE_ID`,`ID`),
752 KEY `MACADDR` (`MACADDR`),
753 KEY `IPSUBNET` (`IPSUBNET`),
754 KEY `ID` (`ID`)
755 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
756 SET character_set_client = @saved_cs_client;
758 --
759 -- Dumping data for table `networks`
760 --
762 LOCK TABLES `networks` WRITE;
763 /*!40000 ALTER TABLE `networks` DISABLE KEYS */;
764 /*!40000 ALTER TABLE `networks` ENABLE KEYS */;
765 UNLOCK TABLES;
767 --
768 -- Table structure for table `operators`
769 --
771 DROP TABLE IF EXISTS `operators`;
772 SET @saved_cs_client = @@character_set_client;
773 SET character_set_client = utf8;
774 CREATE TABLE `operators` (
775 `ID` varchar(255) NOT NULL default '',
776 `FIRSTNAME` varchar(255) default NULL,
777 `LASTNAME` varchar(255) default NULL,
778 `PASSWD` varchar(50) default NULL,
779 `ACCESSLVL` int(11) default NULL,
780 `COMMENTS` text,
781 PRIMARY KEY (`ID`)
782 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
783 SET character_set_client = @saved_cs_client;
785 --
786 -- Dumping data for table `operators`
787 --
789 LOCK TABLES `operators` WRITE;
790 /*!40000 ALTER TABLE `operators` DISABLE KEYS */;
791 INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account');
792 /*!40000 ALTER TABLE `operators` ENABLE KEYS */;
793 UNLOCK TABLES;
795 --
796 -- Table structure for table `ports`
797 --
799 DROP TABLE IF EXISTS `ports`;
800 SET @saved_cs_client = @@character_set_client;
801 SET character_set_client = utf8;
802 CREATE TABLE `ports` (
803 `ID` int(11) NOT NULL auto_increment,
804 `HARDWARE_ID` int(11) NOT NULL,
805 `TYPE` varchar(255) default NULL,
806 `NAME` varchar(255) default NULL,
807 `CAPTION` varchar(255) default NULL,
808 `DESCRIPTION` varchar(255) default NULL,
809 PRIMARY KEY (`HARDWARE_ID`,`ID`),
810 KEY `ID` (`ID`)
811 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
812 SET character_set_client = @saved_cs_client;
814 --
815 -- Dumping data for table `ports`
816 --
818 LOCK TABLES `ports` WRITE;
819 /*!40000 ALTER TABLE `ports` DISABLE KEYS */;
820 /*!40000 ALTER TABLE `ports` ENABLE KEYS */;
821 UNLOCK TABLES;
823 --
824 -- Table structure for table `printers`
825 --
827 DROP TABLE IF EXISTS `printers`;
828 SET @saved_cs_client = @@character_set_client;
829 SET character_set_client = utf8;
830 CREATE TABLE `printers` (
831 `ID` int(11) NOT NULL auto_increment,
832 `HARDWARE_ID` int(11) NOT NULL,
833 `NAME` varchar(255) default NULL,
834 `DRIVER` varchar(255) default NULL,
835 `PORT` varchar(255) default NULL,
836 PRIMARY KEY (`HARDWARE_ID`,`ID`),
837 KEY `ID` (`ID`)
838 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
839 SET character_set_client = @saved_cs_client;
841 --
842 -- Dumping data for table `printers`
843 --
845 LOCK TABLES `printers` WRITE;
846 /*!40000 ALTER TABLE `printers` DISABLE KEYS */;
847 /*!40000 ALTER TABLE `printers` ENABLE KEYS */;
848 UNLOCK TABLES;
850 --
851 -- Table structure for table `regconfig`
852 --
854 DROP TABLE IF EXISTS `regconfig`;
855 SET @saved_cs_client = @@character_set_client;
856 SET character_set_client = utf8;
857 CREATE TABLE `regconfig` (
858 `ID` int(11) NOT NULL auto_increment,
859 `NAME` varchar(255) default NULL,
860 `REGTREE` int(11) default NULL,
861 `REGKEY` text,
862 `REGVALUE` varchar(255) default NULL,
863 PRIMARY KEY (`ID`),
864 KEY `NAME` (`NAME`)
865 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
866 SET character_set_client = @saved_cs_client;
868 --
869 -- Dumping data for table `regconfig`
870 --
872 LOCK TABLES `regconfig` WRITE;
873 /*!40000 ALTER TABLE `regconfig` DISABLE KEYS */;
874 /*!40000 ALTER TABLE `regconfig` ENABLE KEYS */;
875 UNLOCK TABLES;
877 --
878 -- Table structure for table `registry`
879 --
881 DROP TABLE IF EXISTS `registry`;
882 SET @saved_cs_client = @@character_set_client;
883 SET character_set_client = utf8;
884 CREATE TABLE `registry` (
885 `ID` int(11) NOT NULL auto_increment,
886 `HARDWARE_ID` int(11) NOT NULL,
887 `NAME` varchar(255) default NULL,
888 `REGVALUE` varchar(255) default NULL,
889 PRIMARY KEY (`HARDWARE_ID`,`ID`),
890 KEY `NAME` (`NAME`),
891 KEY `ID` (`ID`)
892 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
893 SET character_set_client = @saved_cs_client;
895 --
896 -- Dumping data for table `registry`
897 --
899 LOCK TABLES `registry` WRITE;
900 /*!40000 ALTER TABLE `registry` DISABLE KEYS */;
901 /*!40000 ALTER TABLE `registry` ENABLE KEYS */;
902 UNLOCK TABLES;
904 --
905 -- Table structure for table `slots`
906 --
908 DROP TABLE IF EXISTS `slots`;
909 SET @saved_cs_client = @@character_set_client;
910 SET character_set_client = utf8;
911 CREATE TABLE `slots` (
912 `ID` int(11) NOT NULL auto_increment,
913 `HARDWARE_ID` int(11) NOT NULL,
914 `NAME` varchar(255) default NULL,
915 `DESCRIPTION` varchar(255) default NULL,
916 `DESIGNATION` varchar(255) default NULL,
917 `PURPOSE` varchar(255) default NULL,
918 `STATUS` varchar(255) default NULL,
919 `PSHARE` tinyint(4) default NULL,
920 PRIMARY KEY (`HARDWARE_ID`,`ID`),
921 KEY `ID` (`ID`)
922 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
923 SET character_set_client = @saved_cs_client;
925 --
926 -- Dumping data for table `slots`
927 --
929 LOCK TABLES `slots` WRITE;
930 /*!40000 ALTER TABLE `slots` DISABLE KEYS */;
931 /*!40000 ALTER TABLE `slots` ENABLE KEYS */;
932 UNLOCK TABLES;
934 --
935 -- Table structure for table `softwares`
936 --
938 DROP TABLE IF EXISTS `softwares`;
939 SET @saved_cs_client = @@character_set_client;
940 SET character_set_client = utf8;
941 CREATE TABLE `softwares` (
942 `ID` int(11) NOT NULL auto_increment,
943 `HARDWARE_ID` int(11) NOT NULL,
944 `PUBLISHER` varchar(255) default NULL,
945 `NAME` varchar(255) default NULL,
946 `VERSION` varchar(255) default NULL,
947 `FOLDER` text,
948 `COMMENTS` text,
949 `FILENAME` varchar(255) default NULL,
950 `FILESIZE` int(11) default '0',
951 `SOURCE` int(11) default NULL,
952 PRIMARY KEY (`HARDWARE_ID`,`ID`),
953 KEY `NAME` (`NAME`),
954 KEY `ID` (`ID`)
955 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
956 SET character_set_client = @saved_cs_client;
958 --
959 -- Dumping data for table `softwares`
960 --
962 LOCK TABLES `softwares` WRITE;
963 /*!40000 ALTER TABLE `softwares` DISABLE KEYS */;
964 /*!40000 ALTER TABLE `softwares` ENABLE KEYS */;
965 UNLOCK TABLES;
967 --
968 -- Table structure for table `sounds`
969 --
971 DROP TABLE IF EXISTS `sounds`;
972 SET @saved_cs_client = @@character_set_client;
973 SET character_set_client = utf8;
974 CREATE TABLE `sounds` (
975 `ID` int(11) NOT NULL auto_increment,
976 `HARDWARE_ID` int(11) NOT NULL,
977 `MANUFACTURER` varchar(255) default NULL,
978 `NAME` varchar(255) default NULL,
979 `DESCRIPTION` varchar(255) default NULL,
980 PRIMARY KEY (`HARDWARE_ID`,`ID`),
981 KEY `ID` (`ID`)
982 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
983 SET character_set_client = @saved_cs_client;
985 --
986 -- Dumping data for table `sounds`
987 --
989 LOCK TABLES `sounds` WRITE;
990 /*!40000 ALTER TABLE `sounds` DISABLE KEYS */;
991 /*!40000 ALTER TABLE `sounds` ENABLE KEYS */;
992 UNLOCK TABLES;
994 --
995 -- Table structure for table `storages`
996 --
998 DROP TABLE IF EXISTS `storages`;
999 SET @saved_cs_client = @@character_set_client;
1000 SET character_set_client = utf8;
1001 CREATE TABLE `storages` (
1002 `ID` int(11) NOT NULL auto_increment,
1003 `HARDWARE_ID` int(11) NOT NULL,
1004 `MANUFACTURER` varchar(255) default NULL,
1005 `NAME` varchar(255) default NULL,
1006 `MODEL` varchar(255) default NULL,
1007 `DESCRIPTION` varchar(255) default NULL,
1008 `TYPE` varchar(255) default NULL,
1009 `DISKSIZE` int(11) default NULL,
1010 PRIMARY KEY (`HARDWARE_ID`,`ID`),
1011 KEY `ID` (`ID`)
1012 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1013 SET character_set_client = @saved_cs_client;
1015 --
1016 -- Dumping data for table `storages`
1017 --
1019 LOCK TABLES `storages` WRITE;
1020 /*!40000 ALTER TABLE `storages` DISABLE KEYS */;
1021 /*!40000 ALTER TABLE `storages` ENABLE KEYS */;
1022 UNLOCK TABLES;
1024 --
1025 -- Table structure for table `subnet`
1026 --
1028 DROP TABLE IF EXISTS `subnet`;
1029 SET @saved_cs_client = @@character_set_client;
1030 SET character_set_client = utf8;
1031 CREATE TABLE `subnet` (
1032 `NETID` varchar(15) NOT NULL,
1033 `NAME` varchar(255) default NULL,
1034 `ID` int(11) default NULL,
1035 `MASK` varchar(255) default NULL,
1036 PRIMARY KEY (`NETID`)
1037 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1038 SET character_set_client = @saved_cs_client;
1040 --
1041 -- Dumping data for table `subnet`
1042 --
1044 LOCK TABLES `subnet` WRITE;
1045 /*!40000 ALTER TABLE `subnet` DISABLE KEYS */;
1046 /*!40000 ALTER TABLE `subnet` ENABLE KEYS */;
1047 UNLOCK TABLES;
1049 --
1050 -- Table structure for table `videos`
1051 --
1053 DROP TABLE IF EXISTS `videos`;
1054 SET @saved_cs_client = @@character_set_client;
1055 SET character_set_client = utf8;
1056 CREATE TABLE `videos` (
1057 `ID` int(11) NOT NULL auto_increment,
1058 `HARDWARE_ID` int(11) NOT NULL,
1059 `NAME` varchar(255) default NULL,
1060 `CHIPSET` varchar(255) default NULL,
1061 `MEMORY` varchar(255) default NULL,
1062 `RESOLUTION` varchar(255) default NULL,
1063 PRIMARY KEY (`HARDWARE_ID`,`ID`),
1064 KEY `ID` (`ID`)
1065 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1066 SET character_set_client = @saved_cs_client;
1068 --
1069 -- Dumping data for table `videos`
1070 --
1072 LOCK TABLES `videos` WRITE;
1073 /*!40000 ALTER TABLE `videos` DISABLE KEYS */;
1074 /*!40000 ALTER TABLE `videos` ENABLE KEYS */;
1075 UNLOCK TABLES;
1076 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1078 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1079 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1080 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1081 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1082 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1083 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1084 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1086 -- Dump completed on 2009-04-25 0:01:16