SliTaz Repositories

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/ocsreports/stuff/ocsbase.sql	Mon Feb 18 18:37:30 2013 +0100
     1.3 @@ -0,0 +1,1086 @@
     1.4 +-- MySQL dump 10.11
     1.5 +--
     1.6 +-- Host: localhost    Database: ocsweb
     1.7 +-- ------------------------------------------------------
     1.8 +-- Server version	5.0.51b-log
     1.9 +
    1.10 +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    1.11 +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    1.12 +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    1.13 +/*!40101 SET NAMES utf8 */;
    1.14 +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    1.15 +/*!40103 SET TIME_ZONE='+00:00' */;
    1.16 +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    1.17 +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    1.18 +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    1.19 +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    1.20 +
    1.21 +--
    1.22 +-- Table structure for table `accesslog`
    1.23 +--
    1.24 +USE ocsweb;
    1.25 +
    1.26 +DROP TABLE IF EXISTS `accesslog`;
    1.27 +SET @saved_cs_client     = @@character_set_client;
    1.28 +SET character_set_client = utf8;
    1.29 +CREATE TABLE `accesslog` (
    1.30 +  `ID` int(11) NOT NULL auto_increment,
    1.31 +  `HARDWARE_ID` int(11) NOT NULL,
    1.32 +  `USERID` varchar(255) default NULL,
    1.33 +  `LOGDATE` datetime default NULL,
    1.34 +  `PROCESSES` text,
    1.35 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
    1.36 +  KEY `ID` (`ID`)
    1.37 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    1.38 +SET character_set_client = @saved_cs_client;
    1.39 +
    1.40 +--
    1.41 +-- Dumping data for table `accesslog`
    1.42 +--
    1.43 +
    1.44 +LOCK TABLES `accesslog` WRITE;
    1.45 +/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;
    1.46 +/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;
    1.47 +UNLOCK TABLES;
    1.48 +
    1.49 +--
    1.50 +-- Table structure for table `accountinfo`
    1.51 +--
    1.52 +
    1.53 +DROP TABLE IF EXISTS `accountinfo`;
    1.54 +SET @saved_cs_client     = @@character_set_client;
    1.55 +SET character_set_client = utf8;
    1.56 +CREATE TABLE `accountinfo` (
    1.57 +  `HARDWARE_ID` int(11) NOT NULL,
    1.58 +  `TAG` varchar(255) default 'NA',
    1.59 +  PRIMARY KEY  (`HARDWARE_ID`),
    1.60 +  KEY `TAG` (`TAG`)
    1.61 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    1.62 +SET character_set_client = @saved_cs_client;
    1.63 +
    1.64 +--
    1.65 +-- Dumping data for table `accountinfo`
    1.66 +--
    1.67 +
    1.68 +LOCK TABLES `accountinfo` WRITE;
    1.69 +/*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */;
    1.70 +/*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */;
    1.71 +UNLOCK TABLES;
    1.72 +
    1.73 +--
    1.74 +-- Table structure for table `bios`
    1.75 +--
    1.76 +
    1.77 +DROP TABLE IF EXISTS `bios`;
    1.78 +SET @saved_cs_client     = @@character_set_client;
    1.79 +SET character_set_client = utf8;
    1.80 +CREATE TABLE `bios` (
    1.81 +  `HARDWARE_ID` int(11) NOT NULL,
    1.82 +  `SMANUFACTURER` varchar(255) default NULL,
    1.83 +  `SMODEL` varchar(255) default NULL,
    1.84 +  `SSN` varchar(255) default NULL,
    1.85 +  `TYPE` varchar(255) default NULL,
    1.86 +  `BMANUFACTURER` varchar(255) default NULL,
    1.87 +  `BVERSION` varchar(255) default NULL,
    1.88 +  `BDATE` varchar(255) default NULL,
    1.89 +  PRIMARY KEY  (`HARDWARE_ID`),
    1.90 +  KEY `SSN` (`SSN`)
    1.91 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    1.92 +SET character_set_client = @saved_cs_client;
    1.93 +
    1.94 +--
    1.95 +-- Dumping data for table `bios`
    1.96 +--
    1.97 +
    1.98 +LOCK TABLES `bios` WRITE;
    1.99 +/*!40000 ALTER TABLE `bios` DISABLE KEYS */;
   1.100 +/*!40000 ALTER TABLE `bios` ENABLE KEYS */;
   1.101 +UNLOCK TABLES;
   1.102 +
   1.103 +--
   1.104 +-- Table structure for table `config`
   1.105 +--
   1.106 +
   1.107 +DROP TABLE IF EXISTS `config`;
   1.108 +SET @saved_cs_client     = @@character_set_client;
   1.109 +SET character_set_client = utf8;
   1.110 +CREATE TABLE `config` (
   1.111 +  `NAME` varchar(50) NOT NULL,
   1.112 +  `IVALUE` int(11) default NULL,
   1.113 +  `TVALUE` varchar(255) default NULL,
   1.114 +  `COMMENTS` text,
   1.115 +  PRIMARY KEY  (`NAME`)
   1.116 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.117 +SET character_set_client = @saved_cs_client;
   1.118 +
   1.119 +--
   1.120 +-- Dumping data for table `config`
   1.121 +--
   1.122 +
   1.123 +LOCK TABLES `config` WRITE;
   1.124 +/*!40000 ALTER TABLE `config` DISABLE KEYS */;
   1.125 +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');
   1.126 +/*!40000 ALTER TABLE `config` ENABLE KEYS */;
   1.127 +UNLOCK TABLES;
   1.128 +
   1.129 +--
   1.130 +-- Table structure for table `conntrack`
   1.131 +--
   1.132 +
   1.133 +DROP TABLE IF EXISTS `conntrack`;
   1.134 +SET @saved_cs_client     = @@character_set_client;
   1.135 +SET character_set_client = utf8;
   1.136 +CREATE TABLE `conntrack` (
   1.137 +  `IP` varchar(255) NOT NULL default '',
   1.138 +  `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   1.139 +  PRIMARY KEY  (`IP`)
   1.140 +) ENGINE=MEMORY DEFAULT CHARSET=latin1;
   1.141 +SET character_set_client = @saved_cs_client;
   1.142 +
   1.143 +--
   1.144 +-- Dumping data for table `conntrack`
   1.145 +--
   1.146 +
   1.147 +LOCK TABLES `conntrack` WRITE;
   1.148 +/*!40000 ALTER TABLE `conntrack` DISABLE KEYS */;
   1.149 +/*!40000 ALTER TABLE `conntrack` ENABLE KEYS */;
   1.150 +UNLOCK TABLES;
   1.151 +
   1.152 +--
   1.153 +-- Table structure for table `controllers`
   1.154 +--
   1.155 +
   1.156 +DROP TABLE IF EXISTS `controllers`;
   1.157 +SET @saved_cs_client     = @@character_set_client;
   1.158 +SET character_set_client = utf8;
   1.159 +CREATE TABLE `controllers` (
   1.160 +  `ID` int(11) NOT NULL auto_increment,
   1.161 +  `HARDWARE_ID` int(11) NOT NULL,
   1.162 +  `MANUFACTURER` varchar(255) default NULL,
   1.163 +  `NAME` varchar(255) default NULL,
   1.164 +  `CAPTION` varchar(255) default NULL,
   1.165 +  `DESCRIPTION` varchar(255) default NULL,
   1.166 +  `VERSION` varchar(255) default NULL,
   1.167 +  `TYPE` varchar(255) default NULL,
   1.168 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.169 +  KEY `ID` (`ID`)
   1.170 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.171 +SET character_set_client = @saved_cs_client;
   1.172 +
   1.173 +--
   1.174 +-- Dumping data for table `controllers`
   1.175 +--
   1.176 +
   1.177 +LOCK TABLES `controllers` WRITE;
   1.178 +/*!40000 ALTER TABLE `controllers` DISABLE KEYS */;
   1.179 +/*!40000 ALTER TABLE `controllers` ENABLE KEYS */;
   1.180 +UNLOCK TABLES;
   1.181 +
   1.182 +--
   1.183 +-- Table structure for table `deleted_equiv`
   1.184 +--
   1.185 +
   1.186 +DROP TABLE IF EXISTS `deleted_equiv`;
   1.187 +SET @saved_cs_client     = @@character_set_client;
   1.188 +SET character_set_client = utf8;
   1.189 +CREATE TABLE `deleted_equiv` (
   1.190 +  `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   1.191 +  `DELETED` varchar(255) NOT NULL,
   1.192 +  `EQUIVALENT` varchar(255) default NULL
   1.193 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.194 +SET character_set_client = @saved_cs_client;
   1.195 +
   1.196 +--
   1.197 +-- Dumping data for table `deleted_equiv`
   1.198 +--
   1.199 +
   1.200 +LOCK TABLES `deleted_equiv` WRITE;
   1.201 +/*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */;
   1.202 +/*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */;
   1.203 +UNLOCK TABLES;
   1.204 +
   1.205 +--
   1.206 +-- Table structure for table `deploy`
   1.207 +--
   1.208 +
   1.209 +DROP TABLE IF EXISTS `deploy`;
   1.210 +SET @saved_cs_client     = @@character_set_client;
   1.211 +SET character_set_client = utf8;
   1.212 +CREATE TABLE `deploy` (
   1.213 +  `NAME` varchar(255) NOT NULL,
   1.214 +  `CONTENT` longblob NOT NULL,
   1.215 +  PRIMARY KEY  (`NAME`)
   1.216 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.217 +SET character_set_client = @saved_cs_client;
   1.218 +
   1.219 +--
   1.220 +-- Dumping data for table `deploy`
   1.221 +--
   1.222 +
   1.223 +LOCK TABLES `deploy` WRITE;
   1.224 +/*!40000 ALTER TABLE `deploy` DISABLE KEYS */;
   1.225 +/*!40000 ALTER TABLE `deploy` ENABLE KEYS */;
   1.226 +UNLOCK TABLES;
   1.227 +
   1.228 +--
   1.229 +-- Table structure for table `devices`
   1.230 +--
   1.231 +
   1.232 +DROP TABLE IF EXISTS `devices`;
   1.233 +SET @saved_cs_client     = @@character_set_client;
   1.234 +SET character_set_client = utf8;
   1.235 +CREATE TABLE `devices` (
   1.236 +  `HARDWARE_ID` int(11) NOT NULL,
   1.237 +  `NAME` varchar(50) NOT NULL,
   1.238 +  `IVALUE` int(11) default NULL,
   1.239 +  `TVALUE` varchar(255) default NULL,
   1.240 +  `COMMENTS` text,
   1.241 +  KEY `HARDWARE_ID` (`HARDWARE_ID`),
   1.242 +  KEY `TVALUE` (`TVALUE`)
   1.243 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.244 +SET character_set_client = @saved_cs_client;
   1.245 +
   1.246 +--
   1.247 +-- Dumping data for table `devices`
   1.248 +--
   1.249 +
   1.250 +LOCK TABLES `devices` WRITE;
   1.251 +/*!40000 ALTER TABLE `devices` DISABLE KEYS */;
   1.252 +/*!40000 ALTER TABLE `devices` ENABLE KEYS */;
   1.253 +UNLOCK TABLES;
   1.254 +
   1.255 +--
   1.256 +-- Table structure for table `devicetype`
   1.257 +--
   1.258 +
   1.259 +DROP TABLE IF EXISTS `devicetype`;
   1.260 +SET @saved_cs_client     = @@character_set_client;
   1.261 +SET character_set_client = utf8;
   1.262 +CREATE TABLE `devicetype` (
   1.263 +  `ID` int(11) NOT NULL auto_increment,
   1.264 +  `NAME` varchar(255) default NULL,
   1.265 +  PRIMARY KEY  (`ID`)
   1.266 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.267 +SET character_set_client = @saved_cs_client;
   1.268 +
   1.269 +--
   1.270 +-- Dumping data for table `devicetype`
   1.271 +--
   1.272 +
   1.273 +LOCK TABLES `devicetype` WRITE;
   1.274 +/*!40000 ALTER TABLE `devicetype` DISABLE KEYS */;
   1.275 +/*!40000 ALTER TABLE `devicetype` ENABLE KEYS */;
   1.276 +UNLOCK TABLES;
   1.277 +
   1.278 +--
   1.279 +-- Table structure for table `dico_cat`
   1.280 +--
   1.281 +
   1.282 +DROP TABLE IF EXISTS `dico_cat`;
   1.283 +SET @saved_cs_client     = @@character_set_client;
   1.284 +SET character_set_client = utf8;
   1.285 +CREATE TABLE `dico_cat` (
   1.286 +  `NAME` varchar(255) NOT NULL,
   1.287 +  `PERMANENT` tinyint(4) default '0',
   1.288 +  PRIMARY KEY  (`NAME`)
   1.289 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.290 +SET character_set_client = @saved_cs_client;
   1.291 +
   1.292 +--
   1.293 +-- Dumping data for table `dico_cat`
   1.294 +--
   1.295 +
   1.296 +LOCK TABLES `dico_cat` WRITE;
   1.297 +/*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */;
   1.298 +/*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */;
   1.299 +UNLOCK TABLES;
   1.300 +
   1.301 +--
   1.302 +-- Table structure for table `dico_ignored`
   1.303 +--
   1.304 +
   1.305 +DROP TABLE IF EXISTS `dico_ignored`;
   1.306 +SET @saved_cs_client     = @@character_set_client;
   1.307 +SET character_set_client = utf8;
   1.308 +CREATE TABLE `dico_ignored` (
   1.309 +  `EXTRACTED` varchar(255) NOT NULL,
   1.310 +  PRIMARY KEY  (`EXTRACTED`)
   1.311 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.312 +SET character_set_client = @saved_cs_client;
   1.313 +
   1.314 +--
   1.315 +-- Dumping data for table `dico_ignored`
   1.316 +--
   1.317 +
   1.318 +LOCK TABLES `dico_ignored` WRITE;
   1.319 +/*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */;
   1.320 +/*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */;
   1.321 +UNLOCK TABLES;
   1.322 +
   1.323 +--
   1.324 +-- Table structure for table `dico_soft`
   1.325 +--
   1.326 +
   1.327 +DROP TABLE IF EXISTS `dico_soft`;
   1.328 +SET @saved_cs_client     = @@character_set_client;
   1.329 +SET character_set_client = utf8;
   1.330 +CREATE TABLE `dico_soft` (
   1.331 +  `EXTRACTED` varchar(255) NOT NULL,
   1.332 +  `FORMATTED` varchar(255) NOT NULL,
   1.333 +  PRIMARY KEY  (`EXTRACTED`)
   1.334 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.335 +SET character_set_client = @saved_cs_client;
   1.336 +
   1.337 +--
   1.338 +-- Dumping data for table `dico_soft`
   1.339 +--
   1.340 +
   1.341 +LOCK TABLES `dico_soft` WRITE;
   1.342 +/*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */;
   1.343 +/*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */;
   1.344 +UNLOCK TABLES;
   1.345 +
   1.346 +--
   1.347 +-- Table structure for table `download_available`
   1.348 +--
   1.349 +
   1.350 +DROP TABLE IF EXISTS `download_available`;
   1.351 +SET @saved_cs_client     = @@character_set_client;
   1.352 +SET character_set_client = utf8;
   1.353 +CREATE TABLE `download_available` (
   1.354 +  `FILEID` varchar(255) NOT NULL,
   1.355 +  `NAME` varchar(255) NOT NULL,
   1.356 +  `PRIORITY` int(11) NOT NULL,
   1.357 +  `FRAGMENTS` int(11) NOT NULL,
   1.358 +  `SIZE` int(11) NOT NULL,
   1.359 +  `OSNAME` varchar(255) NOT NULL,
   1.360 +  `COMMENT` text,
   1.361 +  PRIMARY KEY  (`FILEID`)
   1.362 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.363 +SET character_set_client = @saved_cs_client;
   1.364 +
   1.365 +--
   1.366 +-- Dumping data for table `download_available`
   1.367 +--
   1.368 +
   1.369 +LOCK TABLES `download_available` WRITE;
   1.370 +/*!40000 ALTER TABLE `download_available` DISABLE KEYS */;
   1.371 +/*!40000 ALTER TABLE `download_available` ENABLE KEYS */;
   1.372 +UNLOCK TABLES;
   1.373 +
   1.374 +--
   1.375 +-- Table structure for table `download_enable`
   1.376 +--
   1.377 +
   1.378 +DROP TABLE IF EXISTS `download_enable`;
   1.379 +SET @saved_cs_client     = @@character_set_client;
   1.380 +SET character_set_client = utf8;
   1.381 +CREATE TABLE `download_enable` (
   1.382 +  `ID` int(11) NOT NULL auto_increment,
   1.383 +  `FILEID` varchar(255) NOT NULL,
   1.384 +  `INFO_LOC` varchar(255) NOT NULL,
   1.385 +  `PACK_LOC` varchar(255) NOT NULL,
   1.386 +  `CERT_PATH` varchar(255) default NULL,
   1.387 +  `CERT_FILE` varchar(255) default NULL,
   1.388 +  PRIMARY KEY  (`ID`)
   1.389 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.390 +SET character_set_client = @saved_cs_client;
   1.391 +
   1.392 +--
   1.393 +-- Dumping data for table `download_enable`
   1.394 +--
   1.395 +
   1.396 +LOCK TABLES `download_enable` WRITE;
   1.397 +/*!40000 ALTER TABLE `download_enable` DISABLE KEYS */;
   1.398 +/*!40000 ALTER TABLE `download_enable` ENABLE KEYS */;
   1.399 +UNLOCK TABLES;
   1.400 +
   1.401 +--
   1.402 +-- Table structure for table `download_history`
   1.403 +--
   1.404 +
   1.405 +DROP TABLE IF EXISTS `download_history`;
   1.406 +SET @saved_cs_client     = @@character_set_client;
   1.407 +SET character_set_client = utf8;
   1.408 +CREATE TABLE `download_history` (
   1.409 +  `HARDWARE_ID` int(11) NOT NULL,
   1.410 +  `PKG_ID` int(11) NOT NULL default '0',
   1.411 +  `PKG_NAME` varchar(255) default NULL,
   1.412 +  PRIMARY KEY  (`HARDWARE_ID`,`PKG_ID`)
   1.413 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.414 +SET character_set_client = @saved_cs_client;
   1.415 +
   1.416 +--
   1.417 +-- Dumping data for table `download_history`
   1.418 +--
   1.419 +
   1.420 +LOCK TABLES `download_history` WRITE;
   1.421 +/*!40000 ALTER TABLE `download_history` DISABLE KEYS */;
   1.422 +/*!40000 ALTER TABLE `download_history` ENABLE KEYS */;
   1.423 +UNLOCK TABLES;
   1.424 +
   1.425 +--
   1.426 +-- Table structure for table `drives`
   1.427 +--
   1.428 +
   1.429 +DROP TABLE IF EXISTS `drives`;
   1.430 +SET @saved_cs_client     = @@character_set_client;
   1.431 +SET character_set_client = utf8;
   1.432 +CREATE TABLE `drives` (
   1.433 +  `ID` int(11) NOT NULL auto_increment,
   1.434 +  `HARDWARE_ID` int(11) NOT NULL,
   1.435 +  `LETTER` varchar(255) default NULL,
   1.436 +  `TYPE` varchar(255) default NULL,
   1.437 +  `FILESYSTEM` varchar(255) default NULL,
   1.438 +  `TOTAL` int(11) default NULL,
   1.439 +  `FREE` int(11) default NULL,
   1.440 +  `NUMFILES` int(11) default NULL,
   1.441 +  `VOLUMN` varchar(255) default NULL,
   1.442 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.443 +  KEY `ID` (`ID`)
   1.444 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.445 +SET character_set_client = @saved_cs_client;
   1.446 +
   1.447 +--
   1.448 +-- Dumping data for table `drives`
   1.449 +--
   1.450 +
   1.451 +LOCK TABLES `drives` WRITE;
   1.452 +/*!40000 ALTER TABLE `drives` DISABLE KEYS */;
   1.453 +/*!40000 ALTER TABLE `drives` ENABLE KEYS */;
   1.454 +UNLOCK TABLES;
   1.455 +
   1.456 +--
   1.457 +-- Table structure for table `files`
   1.458 +--
   1.459 +
   1.460 +DROP TABLE IF EXISTS `files`;
   1.461 +SET @saved_cs_client     = @@character_set_client;
   1.462 +SET character_set_client = utf8;
   1.463 +CREATE TABLE `files` (
   1.464 +  `NAME` varchar(255) NOT NULL,
   1.465 +  `VERSION` varchar(255) NOT NULL,
   1.466 +  `OS` varchar(255) NOT NULL,
   1.467 +  `CONTENT` longblob NOT NULL,
   1.468 +  PRIMARY KEY  (`NAME`,`OS`,`VERSION`)
   1.469 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.470 +SET character_set_client = @saved_cs_client;
   1.471 +
   1.472 +--
   1.473 +-- Dumping data for table `files`
   1.474 +--
   1.475 +
   1.476 +LOCK TABLES `files` WRITE;
   1.477 +/*!40000 ALTER TABLE `files` DISABLE KEYS */;
   1.478 +/*!40000 ALTER TABLE `files` ENABLE KEYS */;
   1.479 +UNLOCK TABLES;
   1.480 +
   1.481 +--
   1.482 +-- Table structure for table `hardware`
   1.483 +--
   1.484 +
   1.485 +DROP TABLE IF EXISTS `hardware`;
   1.486 +SET @saved_cs_client     = @@character_set_client;
   1.487 +SET character_set_client = utf8;
   1.488 +CREATE TABLE `hardware` (
   1.489 +  `ID` int(11) NOT NULL auto_increment,
   1.490 +  `DEVICEID` varchar(255) NOT NULL,
   1.491 +  `NAME` varchar(255) default NULL,
   1.492 +  `WORKGROUP` varchar(255) default NULL,
   1.493 +  `USERDOMAIN` varchar(255) default NULL,
   1.494 +  `OSNAME` varchar(255) default NULL,
   1.495 +  `OSVERSION` varchar(255) default NULL,
   1.496 +  `OSCOMMENTS` varchar(255) default NULL,
   1.497 +  `PROCESSORT` varchar(255) default NULL,
   1.498 +  `PROCESSORS` int(11) default '0',
   1.499 +  `PROCESSORN` smallint(6) default NULL,
   1.500 +  `MEMORY` int(11) default NULL,
   1.501 +  `SWAP` int(11) default NULL,
   1.502 +  `IPADDR` varchar(255) default NULL,
   1.503 +  `ETIME` datetime default NULL,
   1.504 +  `LASTDATE` datetime default NULL,
   1.505 +  `LASTCOME` datetime default NULL,
   1.506 +  `QUALITY` decimal(4,3) default '0.000',
   1.507 +  `FIDELITY` bigint(20) default '1',
   1.508 +  `USERID` varchar(255) default NULL,
   1.509 +  `TYPE` int(11) default NULL,
   1.510 +  `DESCRIPTION` varchar(255) default NULL,
   1.511 +  `WINCOMPANY` varchar(255) default NULL,
   1.512 +  `WINOWNER` varchar(255) default NULL,
   1.513 +  `WINPRODID` varchar(255) default NULL,
   1.514 +  `WINPRODKEY` varchar(255) default NULL,
   1.515 +  `USERAGENT` varchar(50) default NULL,
   1.516 +  `CHECKSUM` int(11) default '131071',
   1.517 +  PRIMARY KEY  (`DEVICEID`,`ID`),
   1.518 +  KEY `NAME` (`NAME`),
   1.519 +  KEY `CHECKSUM` (`CHECKSUM`),
   1.520 +  KEY `DEVICEID` (`DEVICEID`),
   1.521 +  KEY `ID` (`ID`)
   1.522 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.523 +SET character_set_client = @saved_cs_client;
   1.524 +
   1.525 +--
   1.526 +-- Dumping data for table `hardware`
   1.527 +--
   1.528 +
   1.529 +LOCK TABLES `hardware` WRITE;
   1.530 +/*!40000 ALTER TABLE `hardware` DISABLE KEYS */;
   1.531 +/*!40000 ALTER TABLE `hardware` ENABLE KEYS */;
   1.532 +UNLOCK TABLES;
   1.533 +
   1.534 +--
   1.535 +-- Table structure for table `inputs`
   1.536 +--
   1.537 +
   1.538 +DROP TABLE IF EXISTS `inputs`;
   1.539 +SET @saved_cs_client     = @@character_set_client;
   1.540 +SET character_set_client = utf8;
   1.541 +CREATE TABLE `inputs` (
   1.542 +  `ID` int(11) NOT NULL auto_increment,
   1.543 +  `HARDWARE_ID` int(11) NOT NULL,
   1.544 +  `TYPE` varchar(255) default NULL,
   1.545 +  `MANUFACTURER` varchar(255) default NULL,
   1.546 +  `CAPTION` varchar(255) default NULL,
   1.547 +  `DESCRIPTION` varchar(255) default NULL,
   1.548 +  `INTERFACE` varchar(255) default NULL,
   1.549 +  `POINTTYPE` varchar(255) default NULL,
   1.550 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.551 +  KEY `ID` (`ID`)
   1.552 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.553 +SET character_set_client = @saved_cs_client;
   1.554 +
   1.555 +--
   1.556 +-- Dumping data for table `inputs`
   1.557 +--
   1.558 +
   1.559 +LOCK TABLES `inputs` WRITE;
   1.560 +/*!40000 ALTER TABLE `inputs` DISABLE KEYS */;
   1.561 +/*!40000 ALTER TABLE `inputs` ENABLE KEYS */;
   1.562 +UNLOCK TABLES;
   1.563 +
   1.564 +--
   1.565 +-- Table structure for table `locks`
   1.566 +--
   1.567 +
   1.568 +DROP TABLE IF EXISTS `locks`;
   1.569 +SET @saved_cs_client     = @@character_set_client;
   1.570 +SET character_set_client = utf8;
   1.571 +CREATE TABLE `locks` (
   1.572 +  `HARDWARE_ID` int(11) NOT NULL,
   1.573 +  `ID` int(11) default NULL,
   1.574 +  `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   1.575 +  PRIMARY KEY  (`HARDWARE_ID`),
   1.576 +  KEY `SINCE` (`SINCE`)
   1.577 +) ENGINE=MEMORY DEFAULT CHARSET=latin1;
   1.578 +SET character_set_client = @saved_cs_client;
   1.579 +
   1.580 +--
   1.581 +-- Dumping data for table `locks`
   1.582 +--
   1.583 +
   1.584 +LOCK TABLES `locks` WRITE;
   1.585 +/*!40000 ALTER TABLE `locks` DISABLE KEYS */;
   1.586 +/*!40000 ALTER TABLE `locks` ENABLE KEYS */;
   1.587 +UNLOCK TABLES;
   1.588 +
   1.589 +--
   1.590 +-- Table structure for table `memories`
   1.591 +--
   1.592 +
   1.593 +DROP TABLE IF EXISTS `memories`;
   1.594 +SET @saved_cs_client     = @@character_set_client;
   1.595 +SET character_set_client = utf8;
   1.596 +CREATE TABLE `memories` (
   1.597 +  `ID` int(11) NOT NULL auto_increment,
   1.598 +  `HARDWARE_ID` int(11) NOT NULL,
   1.599 +  `CAPTION` varchar(255) default NULL,
   1.600 +  `DESCRIPTION` varchar(255) default NULL,
   1.601 +  `CAPACITY` varchar(255) default NULL,
   1.602 +  `PURPOSE` varchar(255) default NULL,
   1.603 +  `TYPE` varchar(255) default NULL,
   1.604 +  `SPEED` varchar(255) default NULL,
   1.605 +  `NUMSLOTS` smallint(6) default NULL,
   1.606 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.607 +  KEY `ID` (`ID`)
   1.608 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.609 +SET character_set_client = @saved_cs_client;
   1.610 +
   1.611 +--
   1.612 +-- Dumping data for table `memories`
   1.613 +--
   1.614 +
   1.615 +LOCK TABLES `memories` WRITE;
   1.616 +/*!40000 ALTER TABLE `memories` DISABLE KEYS */;
   1.617 +/*!40000 ALTER TABLE `memories` ENABLE KEYS */;
   1.618 +UNLOCK TABLES;
   1.619 +
   1.620 +--
   1.621 +-- Table structure for table `modems`
   1.622 +--
   1.623 +
   1.624 +DROP TABLE IF EXISTS `modems`;
   1.625 +SET @saved_cs_client     = @@character_set_client;
   1.626 +SET character_set_client = utf8;
   1.627 +CREATE TABLE `modems` (
   1.628 +  `ID` int(11) NOT NULL auto_increment,
   1.629 +  `HARDWARE_ID` int(11) NOT NULL,
   1.630 +  `NAME` varchar(255) default NULL,
   1.631 +  `MODEL` varchar(255) default NULL,
   1.632 +  `DESCRIPTION` varchar(255) default NULL,
   1.633 +  `TYPE` varchar(255) default NULL,
   1.634 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.635 +  KEY `ID` (`ID`)
   1.636 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.637 +SET character_set_client = @saved_cs_client;
   1.638 +
   1.639 +--
   1.640 +-- Dumping data for table `modems`
   1.641 +--
   1.642 +
   1.643 +LOCK TABLES `modems` WRITE;
   1.644 +/*!40000 ALTER TABLE `modems` DISABLE KEYS */;
   1.645 +/*!40000 ALTER TABLE `modems` ENABLE KEYS */;
   1.646 +UNLOCK TABLES;
   1.647 +
   1.648 +--
   1.649 +-- Table structure for table `monitors`
   1.650 +--
   1.651 +
   1.652 +DROP TABLE IF EXISTS `monitors`;
   1.653 +SET @saved_cs_client     = @@character_set_client;
   1.654 +SET character_set_client = utf8;
   1.655 +CREATE TABLE `monitors` (
   1.656 +  `ID` int(11) NOT NULL auto_increment,
   1.657 +  `HARDWARE_ID` int(11) NOT NULL,
   1.658 +  `MANUFACTURER` varchar(255) default NULL,
   1.659 +  `CAPTION` varchar(255) default NULL,
   1.660 +  `DESCRIPTION` varchar(255) default NULL,
   1.661 +  `TYPE` varchar(255) default NULL,
   1.662 +  `SERIAL` varchar(255) default NULL,
   1.663 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.664 +  KEY `ID` (`ID`)
   1.665 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.666 +SET character_set_client = @saved_cs_client;
   1.667 +
   1.668 +--
   1.669 +-- Dumping data for table `monitors`
   1.670 +--
   1.671 +
   1.672 +LOCK TABLES `monitors` WRITE;
   1.673 +/*!40000 ALTER TABLE `monitors` DISABLE KEYS */;
   1.674 +/*!40000 ALTER TABLE `monitors` ENABLE KEYS */;
   1.675 +UNLOCK TABLES;
   1.676 +
   1.677 +--
   1.678 +-- Table structure for table `netmap`
   1.679 +--
   1.680 +
   1.681 +DROP TABLE IF EXISTS `netmap`;
   1.682 +SET @saved_cs_client     = @@character_set_client;
   1.683 +SET character_set_client = utf8;
   1.684 +CREATE TABLE `netmap` (
   1.685 +  `IP` varchar(15) NOT NULL,
   1.686 +  `MAC` varchar(17) NOT NULL,
   1.687 +  `MASK` varchar(15) NOT NULL,
   1.688 +  `NETID` varchar(15) NOT NULL,
   1.689 +  `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
   1.690 +  `NAME` varchar(255) default NULL,
   1.691 +  PRIMARY KEY  (`MAC`),
   1.692 +  KEY `IP` (`IP`),
   1.693 +  KEY `NETID` (`NETID`)
   1.694 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.695 +SET character_set_client = @saved_cs_client;
   1.696 +
   1.697 +--
   1.698 +-- Dumping data for table `netmap`
   1.699 +--
   1.700 +
   1.701 +LOCK TABLES `netmap` WRITE;
   1.702 +/*!40000 ALTER TABLE `netmap` DISABLE KEYS */;
   1.703 +/*!40000 ALTER TABLE `netmap` ENABLE KEYS */;
   1.704 +UNLOCK TABLES;
   1.705 +
   1.706 +--
   1.707 +-- Table structure for table `network_devices`
   1.708 +--
   1.709 +
   1.710 +DROP TABLE IF EXISTS `network_devices`;
   1.711 +SET @saved_cs_client     = @@character_set_client;
   1.712 +SET character_set_client = utf8;
   1.713 +CREATE TABLE `network_devices` (
   1.714 +  `ID` int(11) NOT NULL auto_increment,
   1.715 +  `DESCRIPTION` varchar(255) default NULL,
   1.716 +  `TYPE` varchar(255) default NULL,
   1.717 +  `MACADDR` varchar(255) default NULL,
   1.718 +  `USER` varchar(255) default NULL,
   1.719 +  PRIMARY KEY  (`ID`),
   1.720 +  KEY `MACADDR` (`MACADDR`)
   1.721 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.722 +SET character_set_client = @saved_cs_client;
   1.723 +
   1.724 +--
   1.725 +-- Dumping data for table `network_devices`
   1.726 +--
   1.727 +
   1.728 +LOCK TABLES `network_devices` WRITE;
   1.729 +/*!40000 ALTER TABLE `network_devices` DISABLE KEYS */;
   1.730 +/*!40000 ALTER TABLE `network_devices` ENABLE KEYS */;
   1.731 +UNLOCK TABLES;
   1.732 +
   1.733 +--
   1.734 +-- Table structure for table `networks`
   1.735 +--
   1.736 +
   1.737 +DROP TABLE IF EXISTS `networks`;
   1.738 +SET @saved_cs_client     = @@character_set_client;
   1.739 +SET character_set_client = utf8;
   1.740 +CREATE TABLE `networks` (
   1.741 +  `ID` int(11) NOT NULL auto_increment,
   1.742 +  `HARDWARE_ID` int(11) NOT NULL,
   1.743 +  `DESCRIPTION` varchar(255) default NULL,
   1.744 +  `TYPE` varchar(255) default NULL,
   1.745 +  `TYPEMIB` varchar(255) default NULL,
   1.746 +  `SPEED` varchar(255) default NULL,
   1.747 +  `MACADDR` varchar(255) default NULL,
   1.748 +  `STATUS` varchar(255) default NULL,
   1.749 +  `IPADDRESS` varchar(255) default NULL,
   1.750 +  `IPMASK` varchar(255) default NULL,
   1.751 +  `IPGATEWAY` varchar(255) default NULL,
   1.752 +  `IPSUBNET` varchar(255) default NULL,
   1.753 +  `IPDHCP` varchar(255) default NULL,
   1.754 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.755 +  KEY `MACADDR` (`MACADDR`),
   1.756 +  KEY `IPSUBNET` (`IPSUBNET`),
   1.757 +  KEY `ID` (`ID`)
   1.758 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.759 +SET character_set_client = @saved_cs_client;
   1.760 +
   1.761 +--
   1.762 +-- Dumping data for table `networks`
   1.763 +--
   1.764 +
   1.765 +LOCK TABLES `networks` WRITE;
   1.766 +/*!40000 ALTER TABLE `networks` DISABLE KEYS */;
   1.767 +/*!40000 ALTER TABLE `networks` ENABLE KEYS */;
   1.768 +UNLOCK TABLES;
   1.769 +
   1.770 +--
   1.771 +-- Table structure for table `operators`
   1.772 +--
   1.773 +
   1.774 +DROP TABLE IF EXISTS `operators`;
   1.775 +SET @saved_cs_client     = @@character_set_client;
   1.776 +SET character_set_client = utf8;
   1.777 +CREATE TABLE `operators` (
   1.778 +  `ID` varchar(255) NOT NULL default '',
   1.779 +  `FIRSTNAME` varchar(255) default NULL,
   1.780 +  `LASTNAME` varchar(255) default NULL,
   1.781 +  `PASSWD` varchar(50) default NULL,
   1.782 +  `ACCESSLVL` int(11) default NULL,
   1.783 +  `COMMENTS` text,
   1.784 +  PRIMARY KEY  (`ID`)
   1.785 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.786 +SET character_set_client = @saved_cs_client;
   1.787 +
   1.788 +--
   1.789 +-- Dumping data for table `operators`
   1.790 +--
   1.791 +
   1.792 +LOCK TABLES `operators` WRITE;
   1.793 +/*!40000 ALTER TABLE `operators` DISABLE KEYS */;
   1.794 +INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account');
   1.795 +/*!40000 ALTER TABLE `operators` ENABLE KEYS */;
   1.796 +UNLOCK TABLES;
   1.797 +
   1.798 +--
   1.799 +-- Table structure for table `ports`
   1.800 +--
   1.801 +
   1.802 +DROP TABLE IF EXISTS `ports`;
   1.803 +SET @saved_cs_client     = @@character_set_client;
   1.804 +SET character_set_client = utf8;
   1.805 +CREATE TABLE `ports` (
   1.806 +  `ID` int(11) NOT NULL auto_increment,
   1.807 +  `HARDWARE_ID` int(11) NOT NULL,
   1.808 +  `TYPE` varchar(255) default NULL,
   1.809 +  `NAME` varchar(255) default NULL,
   1.810 +  `CAPTION` varchar(255) default NULL,
   1.811 +  `DESCRIPTION` varchar(255) default NULL,
   1.812 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.813 +  KEY `ID` (`ID`)
   1.814 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.815 +SET character_set_client = @saved_cs_client;
   1.816 +
   1.817 +--
   1.818 +-- Dumping data for table `ports`
   1.819 +--
   1.820 +
   1.821 +LOCK TABLES `ports` WRITE;
   1.822 +/*!40000 ALTER TABLE `ports` DISABLE KEYS */;
   1.823 +/*!40000 ALTER TABLE `ports` ENABLE KEYS */;
   1.824 +UNLOCK TABLES;
   1.825 +
   1.826 +--
   1.827 +-- Table structure for table `printers`
   1.828 +--
   1.829 +
   1.830 +DROP TABLE IF EXISTS `printers`;
   1.831 +SET @saved_cs_client     = @@character_set_client;
   1.832 +SET character_set_client = utf8;
   1.833 +CREATE TABLE `printers` (
   1.834 +  `ID` int(11) NOT NULL auto_increment,
   1.835 +  `HARDWARE_ID` int(11) NOT NULL,
   1.836 +  `NAME` varchar(255) default NULL,
   1.837 +  `DRIVER` varchar(255) default NULL,
   1.838 +  `PORT` varchar(255) default NULL,
   1.839 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.840 +  KEY `ID` (`ID`)
   1.841 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.842 +SET character_set_client = @saved_cs_client;
   1.843 +
   1.844 +--
   1.845 +-- Dumping data for table `printers`
   1.846 +--
   1.847 +
   1.848 +LOCK TABLES `printers` WRITE;
   1.849 +/*!40000 ALTER TABLE `printers` DISABLE KEYS */;
   1.850 +/*!40000 ALTER TABLE `printers` ENABLE KEYS */;
   1.851 +UNLOCK TABLES;
   1.852 +
   1.853 +--
   1.854 +-- Table structure for table `regconfig`
   1.855 +--
   1.856 +
   1.857 +DROP TABLE IF EXISTS `regconfig`;
   1.858 +SET @saved_cs_client     = @@character_set_client;
   1.859 +SET character_set_client = utf8;
   1.860 +CREATE TABLE `regconfig` (
   1.861 +  `ID` int(11) NOT NULL auto_increment,
   1.862 +  `NAME` varchar(255) default NULL,
   1.863 +  `REGTREE` int(11) default NULL,
   1.864 +  `REGKEY` text,
   1.865 +  `REGVALUE` varchar(255) default NULL,
   1.866 +  PRIMARY KEY  (`ID`),
   1.867 +  KEY `NAME` (`NAME`)
   1.868 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   1.869 +SET character_set_client = @saved_cs_client;
   1.870 +
   1.871 +--
   1.872 +-- Dumping data for table `regconfig`
   1.873 +--
   1.874 +
   1.875 +LOCK TABLES `regconfig` WRITE;
   1.876 +/*!40000 ALTER TABLE `regconfig` DISABLE KEYS */;
   1.877 +/*!40000 ALTER TABLE `regconfig` ENABLE KEYS */;
   1.878 +UNLOCK TABLES;
   1.879 +
   1.880 +--
   1.881 +-- Table structure for table `registry`
   1.882 +--
   1.883 +
   1.884 +DROP TABLE IF EXISTS `registry`;
   1.885 +SET @saved_cs_client     = @@character_set_client;
   1.886 +SET character_set_client = utf8;
   1.887 +CREATE TABLE `registry` (
   1.888 +  `ID` int(11) NOT NULL auto_increment,
   1.889 +  `HARDWARE_ID` int(11) NOT NULL,
   1.890 +  `NAME` varchar(255) default NULL,
   1.891 +  `REGVALUE` varchar(255) default NULL,
   1.892 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.893 +  KEY `NAME` (`NAME`),
   1.894 +  KEY `ID` (`ID`)
   1.895 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.896 +SET character_set_client = @saved_cs_client;
   1.897 +
   1.898 +--
   1.899 +-- Dumping data for table `registry`
   1.900 +--
   1.901 +
   1.902 +LOCK TABLES `registry` WRITE;
   1.903 +/*!40000 ALTER TABLE `registry` DISABLE KEYS */;
   1.904 +/*!40000 ALTER TABLE `registry` ENABLE KEYS */;
   1.905 +UNLOCK TABLES;
   1.906 +
   1.907 +--
   1.908 +-- Table structure for table `slots`
   1.909 +--
   1.910 +
   1.911 +DROP TABLE IF EXISTS `slots`;
   1.912 +SET @saved_cs_client     = @@character_set_client;
   1.913 +SET character_set_client = utf8;
   1.914 +CREATE TABLE `slots` (
   1.915 +  `ID` int(11) NOT NULL auto_increment,
   1.916 +  `HARDWARE_ID` int(11) NOT NULL,
   1.917 +  `NAME` varchar(255) default NULL,
   1.918 +  `DESCRIPTION` varchar(255) default NULL,
   1.919 +  `DESIGNATION` varchar(255) default NULL,
   1.920 +  `PURPOSE` varchar(255) default NULL,
   1.921 +  `STATUS` varchar(255) default NULL,
   1.922 +  `PSHARE` tinyint(4) default NULL,
   1.923 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.924 +  KEY `ID` (`ID`)
   1.925 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.926 +SET character_set_client = @saved_cs_client;
   1.927 +
   1.928 +--
   1.929 +-- Dumping data for table `slots`
   1.930 +--
   1.931 +
   1.932 +LOCK TABLES `slots` WRITE;
   1.933 +/*!40000 ALTER TABLE `slots` DISABLE KEYS */;
   1.934 +/*!40000 ALTER TABLE `slots` ENABLE KEYS */;
   1.935 +UNLOCK TABLES;
   1.936 +
   1.937 +--
   1.938 +-- Table structure for table `softwares`
   1.939 +--
   1.940 +
   1.941 +DROP TABLE IF EXISTS `softwares`;
   1.942 +SET @saved_cs_client     = @@character_set_client;
   1.943 +SET character_set_client = utf8;
   1.944 +CREATE TABLE `softwares` (
   1.945 +  `ID` int(11) NOT NULL auto_increment,
   1.946 +  `HARDWARE_ID` int(11) NOT NULL,
   1.947 +  `PUBLISHER` varchar(255) default NULL,
   1.948 +  `NAME` varchar(255) default NULL,
   1.949 +  `VERSION` varchar(255) default NULL,
   1.950 +  `FOLDER` text,
   1.951 +  `COMMENTS` text,
   1.952 +  `FILENAME` varchar(255) default NULL,
   1.953 +  `FILESIZE` int(11) default '0',
   1.954 +  `SOURCE` int(11) default NULL,
   1.955 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.956 +  KEY `NAME` (`NAME`),
   1.957 +  KEY `ID` (`ID`)
   1.958 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.959 +SET character_set_client = @saved_cs_client;
   1.960 +
   1.961 +--
   1.962 +-- Dumping data for table `softwares`
   1.963 +--
   1.964 +
   1.965 +LOCK TABLES `softwares` WRITE;
   1.966 +/*!40000 ALTER TABLE `softwares` DISABLE KEYS */;
   1.967 +/*!40000 ALTER TABLE `softwares` ENABLE KEYS */;
   1.968 +UNLOCK TABLES;
   1.969 +
   1.970 +--
   1.971 +-- Table structure for table `sounds`
   1.972 +--
   1.973 +
   1.974 +DROP TABLE IF EXISTS `sounds`;
   1.975 +SET @saved_cs_client     = @@character_set_client;
   1.976 +SET character_set_client = utf8;
   1.977 +CREATE TABLE `sounds` (
   1.978 +  `ID` int(11) NOT NULL auto_increment,
   1.979 +  `HARDWARE_ID` int(11) NOT NULL,
   1.980 +  `MANUFACTURER` varchar(255) default NULL,
   1.981 +  `NAME` varchar(255) default NULL,
   1.982 +  `DESCRIPTION` varchar(255) default NULL,
   1.983 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
   1.984 +  KEY `ID` (`ID`)
   1.985 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   1.986 +SET character_set_client = @saved_cs_client;
   1.987 +
   1.988 +--
   1.989 +-- Dumping data for table `sounds`
   1.990 +--
   1.991 +
   1.992 +LOCK TABLES `sounds` WRITE;
   1.993 +/*!40000 ALTER TABLE `sounds` DISABLE KEYS */;
   1.994 +/*!40000 ALTER TABLE `sounds` ENABLE KEYS */;
   1.995 +UNLOCK TABLES;
   1.996 +
   1.997 +--
   1.998 +-- Table structure for table `storages`
   1.999 +--
  1.1000 +
  1.1001 +DROP TABLE IF EXISTS `storages`;
  1.1002 +SET @saved_cs_client     = @@character_set_client;
  1.1003 +SET character_set_client = utf8;
  1.1004 +CREATE TABLE `storages` (
  1.1005 +  `ID` int(11) NOT NULL auto_increment,
  1.1006 +  `HARDWARE_ID` int(11) NOT NULL,
  1.1007 +  `MANUFACTURER` varchar(255) default NULL,
  1.1008 +  `NAME` varchar(255) default NULL,
  1.1009 +  `MODEL` varchar(255) default NULL,
  1.1010 +  `DESCRIPTION` varchar(255) default NULL,
  1.1011 +  `TYPE` varchar(255) default NULL,
  1.1012 +  `DISKSIZE` int(11) default NULL,
  1.1013 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
  1.1014 +  KEY `ID` (`ID`)
  1.1015 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1.1016 +SET character_set_client = @saved_cs_client;
  1.1017 +
  1.1018 +--
  1.1019 +-- Dumping data for table `storages`
  1.1020 +--
  1.1021 +
  1.1022 +LOCK TABLES `storages` WRITE;
  1.1023 +/*!40000 ALTER TABLE `storages` DISABLE KEYS */;
  1.1024 +/*!40000 ALTER TABLE `storages` ENABLE KEYS */;
  1.1025 +UNLOCK TABLES;
  1.1026 +
  1.1027 +--
  1.1028 +-- Table structure for table `subnet`
  1.1029 +--
  1.1030 +
  1.1031 +DROP TABLE IF EXISTS `subnet`;
  1.1032 +SET @saved_cs_client     = @@character_set_client;
  1.1033 +SET character_set_client = utf8;
  1.1034 +CREATE TABLE `subnet` (
  1.1035 +  `NETID` varchar(15) NOT NULL,
  1.1036 +  `NAME` varchar(255) default NULL,
  1.1037 +  `ID` int(11) default NULL,
  1.1038 +  `MASK` varchar(255) default NULL,
  1.1039 +  PRIMARY KEY  (`NETID`)
  1.1040 +) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1.1041 +SET character_set_client = @saved_cs_client;
  1.1042 +
  1.1043 +--
  1.1044 +-- Dumping data for table `subnet`
  1.1045 +--
  1.1046 +
  1.1047 +LOCK TABLES `subnet` WRITE;
  1.1048 +/*!40000 ALTER TABLE `subnet` DISABLE KEYS */;
  1.1049 +/*!40000 ALTER TABLE `subnet` ENABLE KEYS */;
  1.1050 +UNLOCK TABLES;
  1.1051 +
  1.1052 +--
  1.1053 +-- Table structure for table `videos`
  1.1054 +--
  1.1055 +
  1.1056 +DROP TABLE IF EXISTS `videos`;
  1.1057 +SET @saved_cs_client     = @@character_set_client;
  1.1058 +SET character_set_client = utf8;
  1.1059 +CREATE TABLE `videos` (
  1.1060 +  `ID` int(11) NOT NULL auto_increment,
  1.1061 +  `HARDWARE_ID` int(11) NOT NULL,
  1.1062 +  `NAME` varchar(255) default NULL,
  1.1063 +  `CHIPSET` varchar(255) default NULL,
  1.1064 +  `MEMORY` varchar(255) default NULL,
  1.1065 +  `RESOLUTION` varchar(255) default NULL,
  1.1066 +  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
  1.1067 +  KEY `ID` (`ID`)
  1.1068 +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1.1069 +SET character_set_client = @saved_cs_client;
  1.1070 +
  1.1071 +--
  1.1072 +-- Dumping data for table `videos`
  1.1073 +--
  1.1074 +
  1.1075 +LOCK TABLES `videos` WRITE;
  1.1076 +/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
  1.1077 +/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
  1.1078 +UNLOCK TABLES;
  1.1079 +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  1.1080 +
  1.1081 +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  1.1082 +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  1.1083 +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  1.1084 +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1.1085 +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1.1086 +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  1.1087 +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  1.1088 +
  1.1089 +-- Dump completed on 2009-04-25  0:01:16