wok-current diff ocsreports/stuff/ocsbase.sql @ rev 24396
Add some current_version
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Tue Feb 08 12:15:27 2022 +0000 (2022-02-08) |
parents | |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/ocsreports/stuff/ocsbase.sql Tue Feb 08 12:15:27 2022 +0000 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