wok-next annotate ocsinventory/stuff/ocsbase.sql @ rev 21253

updated duplicity (0.6.20 -> 0.8.07)
author Hans-G?nter Theisgen
date Fri Dec 06 09:07:53 2019 +0100 (2019-12-06)
parents
children
rev   line source
pascal@20179 1 -- MySQL dump 10.11
pascal@20179 2 --
pascal@20179 3 -- Host: localhost Database: ocsweb
pascal@20179 4 -- ------------------------------------------------------
pascal@20179 5 -- Server version 5.0.51b-log
pascal@20179 6
pascal@20179 7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
pascal@20179 8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
pascal@20179 9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
pascal@20179 10 /*!40101 SET NAMES utf8 */;
pascal@20179 11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
pascal@20179 12 /*!40103 SET TIME_ZONE='+00:00' */;
pascal@20179 13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
pascal@20179 14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
pascal@20179 15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
pascal@20179 16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
pascal@20179 17
pascal@20179 18 --
pascal@20179 19 -- Table structure for table `accesslog`
pascal@20179 20 --
pascal@20179 21 USE ocsweb;
pascal@20179 22
pascal@20179 23 DROP TABLE IF EXISTS `accesslog`;
pascal@20179 24 SET @saved_cs_client = @@character_set_client;
pascal@20179 25 SET character_set_client = utf8;
pascal@20179 26 CREATE TABLE `accesslog` (
pascal@20179 27 `ID` int(11) NOT NULL auto_increment,
pascal@20179 28 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 29 `USERID` varchar(255) default NULL,
pascal@20179 30 `LOGDATE` datetime default NULL,
pascal@20179 31 `PROCESSES` text,
pascal@20179 32 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 33 KEY `ID` (`ID`)
pascal@20179 34 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 35 SET character_set_client = @saved_cs_client;
pascal@20179 36
pascal@20179 37 --
pascal@20179 38 -- Dumping data for table `accesslog`
pascal@20179 39 --
pascal@20179 40
pascal@20179 41 LOCK TABLES `accesslog` WRITE;
pascal@20179 42 /*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;
pascal@20179 43 /*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;
pascal@20179 44 UNLOCK TABLES;
pascal@20179 45
pascal@20179 46 --
pascal@20179 47 -- Table structure for table `accountinfo`
pascal@20179 48 --
pascal@20179 49
pascal@20179 50 DROP TABLE IF EXISTS `accountinfo`;
pascal@20179 51 SET @saved_cs_client = @@character_set_client;
pascal@20179 52 SET character_set_client = utf8;
pascal@20179 53 CREATE TABLE `accountinfo` (
pascal@20179 54 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 55 `TAG` varchar(255) default 'NA',
pascal@20179 56 PRIMARY KEY (`HARDWARE_ID`),
pascal@20179 57 KEY `TAG` (`TAG`)
pascal@20179 58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 59 SET character_set_client = @saved_cs_client;
pascal@20179 60
pascal@20179 61 --
pascal@20179 62 -- Dumping data for table `accountinfo`
pascal@20179 63 --
pascal@20179 64
pascal@20179 65 LOCK TABLES `accountinfo` WRITE;
pascal@20179 66 /*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */;
pascal@20179 67 /*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */;
pascal@20179 68 UNLOCK TABLES;
pascal@20179 69
pascal@20179 70 --
pascal@20179 71 -- Table structure for table `bios`
pascal@20179 72 --
pascal@20179 73
pascal@20179 74 DROP TABLE IF EXISTS `bios`;
pascal@20179 75 SET @saved_cs_client = @@character_set_client;
pascal@20179 76 SET character_set_client = utf8;
pascal@20179 77 CREATE TABLE `bios` (
pascal@20179 78 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 79 `SMANUFACTURER` varchar(255) default NULL,
pascal@20179 80 `SMODEL` varchar(255) default NULL,
pascal@20179 81 `SSN` varchar(255) default NULL,
pascal@20179 82 `TYPE` varchar(255) default NULL,
pascal@20179 83 `BMANUFACTURER` varchar(255) default NULL,
pascal@20179 84 `BVERSION` varchar(255) default NULL,
pascal@20179 85 `BDATE` varchar(255) default NULL,
pascal@20179 86 PRIMARY KEY (`HARDWARE_ID`),
pascal@20179 87 KEY `SSN` (`SSN`)
pascal@20179 88 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 89 SET character_set_client = @saved_cs_client;
pascal@20179 90
pascal@20179 91 --
pascal@20179 92 -- Dumping data for table `bios`
pascal@20179 93 --
pascal@20179 94
pascal@20179 95 LOCK TABLES `bios` WRITE;
pascal@20179 96 /*!40000 ALTER TABLE `bios` DISABLE KEYS */;
pascal@20179 97 /*!40000 ALTER TABLE `bios` ENABLE KEYS */;
pascal@20179 98 UNLOCK TABLES;
pascal@20179 99
pascal@20179 100 --
pascal@20179 101 -- Table structure for table `config`
pascal@20179 102 --
pascal@20179 103
pascal@20179 104 DROP TABLE IF EXISTS `config`;
pascal@20179 105 SET @saved_cs_client = @@character_set_client;
pascal@20179 106 SET character_set_client = utf8;
pascal@20179 107 CREATE TABLE `config` (
pascal@20179 108 `NAME` varchar(50) NOT NULL,
pascal@20179 109 `IVALUE` int(11) default NULL,
pascal@20179 110 `TVALUE` varchar(255) default NULL,
pascal@20179 111 `COMMENTS` text,
pascal@20179 112 PRIMARY KEY (`NAME`)
pascal@20179 113 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 114 SET character_set_client = @saved_cs_client;
pascal@20179 115
pascal@20179 116 --
pascal@20179 117 -- Dumping data for table `config`
pascal@20179 118 --
pascal@20179 119
pascal@20179 120 LOCK TABLES `config` WRITE;
pascal@20179 121 /*!40000 ALTER TABLE `config` DISABLE KEYS */;
pascal@20179 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');
pascal@20179 123 /*!40000 ALTER TABLE `config` ENABLE KEYS */;
pascal@20179 124 UNLOCK TABLES;
pascal@20179 125
pascal@20179 126 --
pascal@20179 127 -- Table structure for table `conntrack`
pascal@20179 128 --
pascal@20179 129
pascal@20179 130 DROP TABLE IF EXISTS `conntrack`;
pascal@20179 131 SET @saved_cs_client = @@character_set_client;
pascal@20179 132 SET character_set_client = utf8;
pascal@20179 133 CREATE TABLE `conntrack` (
pascal@20179 134 `IP` varchar(255) NOT NULL default '',
pascal@20179 135 `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
pascal@20179 136 PRIMARY KEY (`IP`)
pascal@20179 137 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;
pascal@20179 138 SET character_set_client = @saved_cs_client;
pascal@20179 139
pascal@20179 140 --
pascal@20179 141 -- Dumping data for table `conntrack`
pascal@20179 142 --
pascal@20179 143
pascal@20179 144 LOCK TABLES `conntrack` WRITE;
pascal@20179 145 /*!40000 ALTER TABLE `conntrack` DISABLE KEYS */;
pascal@20179 146 /*!40000 ALTER TABLE `conntrack` ENABLE KEYS */;
pascal@20179 147 UNLOCK TABLES;
pascal@20179 148
pascal@20179 149 --
pascal@20179 150 -- Table structure for table `controllers`
pascal@20179 151 --
pascal@20179 152
pascal@20179 153 DROP TABLE IF EXISTS `controllers`;
pascal@20179 154 SET @saved_cs_client = @@character_set_client;
pascal@20179 155 SET character_set_client = utf8;
pascal@20179 156 CREATE TABLE `controllers` (
pascal@20179 157 `ID` int(11) NOT NULL auto_increment,
pascal@20179 158 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 159 `MANUFACTURER` varchar(255) default NULL,
pascal@20179 160 `NAME` varchar(255) default NULL,
pascal@20179 161 `CAPTION` varchar(255) default NULL,
pascal@20179 162 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 163 `VERSION` varchar(255) default NULL,
pascal@20179 164 `TYPE` varchar(255) default NULL,
pascal@20179 165 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 166 KEY `ID` (`ID`)
pascal@20179 167 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 168 SET character_set_client = @saved_cs_client;
pascal@20179 169
pascal@20179 170 --
pascal@20179 171 -- Dumping data for table `controllers`
pascal@20179 172 --
pascal@20179 173
pascal@20179 174 LOCK TABLES `controllers` WRITE;
pascal@20179 175 /*!40000 ALTER TABLE `controllers` DISABLE KEYS */;
pascal@20179 176 /*!40000 ALTER TABLE `controllers` ENABLE KEYS */;
pascal@20179 177 UNLOCK TABLES;
pascal@20179 178
pascal@20179 179 --
pascal@20179 180 -- Table structure for table `deleted_equiv`
pascal@20179 181 --
pascal@20179 182
pascal@20179 183 DROP TABLE IF EXISTS `deleted_equiv`;
pascal@20179 184 SET @saved_cs_client = @@character_set_client;
pascal@20179 185 SET character_set_client = utf8;
pascal@20179 186 CREATE TABLE `deleted_equiv` (
pascal@20179 187 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
pascal@20179 188 `DELETED` varchar(255) NOT NULL,
pascal@20179 189 `EQUIVALENT` varchar(255) default NULL
pascal@20179 190 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 191 SET character_set_client = @saved_cs_client;
pascal@20179 192
pascal@20179 193 --
pascal@20179 194 -- Dumping data for table `deleted_equiv`
pascal@20179 195 --
pascal@20179 196
pascal@20179 197 LOCK TABLES `deleted_equiv` WRITE;
pascal@20179 198 /*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */;
pascal@20179 199 /*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */;
pascal@20179 200 UNLOCK TABLES;
pascal@20179 201
pascal@20179 202 --
pascal@20179 203 -- Table structure for table `deploy`
pascal@20179 204 --
pascal@20179 205
pascal@20179 206 DROP TABLE IF EXISTS `deploy`;
pascal@20179 207 SET @saved_cs_client = @@character_set_client;
pascal@20179 208 SET character_set_client = utf8;
pascal@20179 209 CREATE TABLE `deploy` (
pascal@20179 210 `NAME` varchar(255) NOT NULL,
pascal@20179 211 `CONTENT` longblob NOT NULL,
pascal@20179 212 PRIMARY KEY (`NAME`)
pascal@20179 213 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 214 SET character_set_client = @saved_cs_client;
pascal@20179 215
pascal@20179 216 --
pascal@20179 217 -- Dumping data for table `deploy`
pascal@20179 218 --
pascal@20179 219
pascal@20179 220 LOCK TABLES `deploy` WRITE;
pascal@20179 221 /*!40000 ALTER TABLE `deploy` DISABLE KEYS */;
pascal@20179 222 /*!40000 ALTER TABLE `deploy` ENABLE KEYS */;
pascal@20179 223 UNLOCK TABLES;
pascal@20179 224
pascal@20179 225 --
pascal@20179 226 -- Table structure for table `devices`
pascal@20179 227 --
pascal@20179 228
pascal@20179 229 DROP TABLE IF EXISTS `devices`;
pascal@20179 230 SET @saved_cs_client = @@character_set_client;
pascal@20179 231 SET character_set_client = utf8;
pascal@20179 232 CREATE TABLE `devices` (
pascal@20179 233 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 234 `NAME` varchar(50) NOT NULL,
pascal@20179 235 `IVALUE` int(11) default NULL,
pascal@20179 236 `TVALUE` varchar(255) default NULL,
pascal@20179 237 `COMMENTS` text,
pascal@20179 238 KEY `HARDWARE_ID` (`HARDWARE_ID`),
pascal@20179 239 KEY `TVALUE` (`TVALUE`)
pascal@20179 240 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 241 SET character_set_client = @saved_cs_client;
pascal@20179 242
pascal@20179 243 --
pascal@20179 244 -- Dumping data for table `devices`
pascal@20179 245 --
pascal@20179 246
pascal@20179 247 LOCK TABLES `devices` WRITE;
pascal@20179 248 /*!40000 ALTER TABLE `devices` DISABLE KEYS */;
pascal@20179 249 /*!40000 ALTER TABLE `devices` ENABLE KEYS */;
pascal@20179 250 UNLOCK TABLES;
pascal@20179 251
pascal@20179 252 --
pascal@20179 253 -- Table structure for table `devicetype`
pascal@20179 254 --
pascal@20179 255
pascal@20179 256 DROP TABLE IF EXISTS `devicetype`;
pascal@20179 257 SET @saved_cs_client = @@character_set_client;
pascal@20179 258 SET character_set_client = utf8;
pascal@20179 259 CREATE TABLE `devicetype` (
pascal@20179 260 `ID` int(11) NOT NULL auto_increment,
pascal@20179 261 `NAME` varchar(255) default NULL,
pascal@20179 262 PRIMARY KEY (`ID`)
pascal@20179 263 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 264 SET character_set_client = @saved_cs_client;
pascal@20179 265
pascal@20179 266 --
pascal@20179 267 -- Dumping data for table `devicetype`
pascal@20179 268 --
pascal@20179 269
pascal@20179 270 LOCK TABLES `devicetype` WRITE;
pascal@20179 271 /*!40000 ALTER TABLE `devicetype` DISABLE KEYS */;
pascal@20179 272 /*!40000 ALTER TABLE `devicetype` ENABLE KEYS */;
pascal@20179 273 UNLOCK TABLES;
pascal@20179 274
pascal@20179 275 --
pascal@20179 276 -- Table structure for table `dico_cat`
pascal@20179 277 --
pascal@20179 278
pascal@20179 279 DROP TABLE IF EXISTS `dico_cat`;
pascal@20179 280 SET @saved_cs_client = @@character_set_client;
pascal@20179 281 SET character_set_client = utf8;
pascal@20179 282 CREATE TABLE `dico_cat` (
pascal@20179 283 `NAME` varchar(255) NOT NULL,
pascal@20179 284 `PERMANENT` tinyint(4) default '0',
pascal@20179 285 PRIMARY KEY (`NAME`)
pascal@20179 286 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 287 SET character_set_client = @saved_cs_client;
pascal@20179 288
pascal@20179 289 --
pascal@20179 290 -- Dumping data for table `dico_cat`
pascal@20179 291 --
pascal@20179 292
pascal@20179 293 LOCK TABLES `dico_cat` WRITE;
pascal@20179 294 /*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */;
pascal@20179 295 /*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */;
pascal@20179 296 UNLOCK TABLES;
pascal@20179 297
pascal@20179 298 --
pascal@20179 299 -- Table structure for table `dico_ignored`
pascal@20179 300 --
pascal@20179 301
pascal@20179 302 DROP TABLE IF EXISTS `dico_ignored`;
pascal@20179 303 SET @saved_cs_client = @@character_set_client;
pascal@20179 304 SET character_set_client = utf8;
pascal@20179 305 CREATE TABLE `dico_ignored` (
pascal@20179 306 `EXTRACTED` varchar(255) NOT NULL,
pascal@20179 307 PRIMARY KEY (`EXTRACTED`)
pascal@20179 308 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 309 SET character_set_client = @saved_cs_client;
pascal@20179 310
pascal@20179 311 --
pascal@20179 312 -- Dumping data for table `dico_ignored`
pascal@20179 313 --
pascal@20179 314
pascal@20179 315 LOCK TABLES `dico_ignored` WRITE;
pascal@20179 316 /*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */;
pascal@20179 317 /*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */;
pascal@20179 318 UNLOCK TABLES;
pascal@20179 319
pascal@20179 320 --
pascal@20179 321 -- Table structure for table `dico_soft`
pascal@20179 322 --
pascal@20179 323
pascal@20179 324 DROP TABLE IF EXISTS `dico_soft`;
pascal@20179 325 SET @saved_cs_client = @@character_set_client;
pascal@20179 326 SET character_set_client = utf8;
pascal@20179 327 CREATE TABLE `dico_soft` (
pascal@20179 328 `EXTRACTED` varchar(255) NOT NULL,
pascal@20179 329 `FORMATTED` varchar(255) NOT NULL,
pascal@20179 330 PRIMARY KEY (`EXTRACTED`)
pascal@20179 331 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 332 SET character_set_client = @saved_cs_client;
pascal@20179 333
pascal@20179 334 --
pascal@20179 335 -- Dumping data for table `dico_soft`
pascal@20179 336 --
pascal@20179 337
pascal@20179 338 LOCK TABLES `dico_soft` WRITE;
pascal@20179 339 /*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */;
pascal@20179 340 /*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */;
pascal@20179 341 UNLOCK TABLES;
pascal@20179 342
pascal@20179 343 --
pascal@20179 344 -- Table structure for table `download_available`
pascal@20179 345 --
pascal@20179 346
pascal@20179 347 DROP TABLE IF EXISTS `download_available`;
pascal@20179 348 SET @saved_cs_client = @@character_set_client;
pascal@20179 349 SET character_set_client = utf8;
pascal@20179 350 CREATE TABLE `download_available` (
pascal@20179 351 `FILEID` varchar(255) NOT NULL,
pascal@20179 352 `NAME` varchar(255) NOT NULL,
pascal@20179 353 `PRIORITY` int(11) NOT NULL,
pascal@20179 354 `FRAGMENTS` int(11) NOT NULL,
pascal@20179 355 `SIZE` int(11) NOT NULL,
pascal@20179 356 `OSNAME` varchar(255) NOT NULL,
pascal@20179 357 `COMMENT` text,
pascal@20179 358 PRIMARY KEY (`FILEID`)
pascal@20179 359 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 360 SET character_set_client = @saved_cs_client;
pascal@20179 361
pascal@20179 362 --
pascal@20179 363 -- Dumping data for table `download_available`
pascal@20179 364 --
pascal@20179 365
pascal@20179 366 LOCK TABLES `download_available` WRITE;
pascal@20179 367 /*!40000 ALTER TABLE `download_available` DISABLE KEYS */;
pascal@20179 368 /*!40000 ALTER TABLE `download_available` ENABLE KEYS */;
pascal@20179 369 UNLOCK TABLES;
pascal@20179 370
pascal@20179 371 --
pascal@20179 372 -- Table structure for table `download_enable`
pascal@20179 373 --
pascal@20179 374
pascal@20179 375 DROP TABLE IF EXISTS `download_enable`;
pascal@20179 376 SET @saved_cs_client = @@character_set_client;
pascal@20179 377 SET character_set_client = utf8;
pascal@20179 378 CREATE TABLE `download_enable` (
pascal@20179 379 `ID` int(11) NOT NULL auto_increment,
pascal@20179 380 `FILEID` varchar(255) NOT NULL,
pascal@20179 381 `INFO_LOC` varchar(255) NOT NULL,
pascal@20179 382 `PACK_LOC` varchar(255) NOT NULL,
pascal@20179 383 `CERT_PATH` varchar(255) default NULL,
pascal@20179 384 `CERT_FILE` varchar(255) default NULL,
pascal@20179 385 PRIMARY KEY (`ID`)
pascal@20179 386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 387 SET character_set_client = @saved_cs_client;
pascal@20179 388
pascal@20179 389 --
pascal@20179 390 -- Dumping data for table `download_enable`
pascal@20179 391 --
pascal@20179 392
pascal@20179 393 LOCK TABLES `download_enable` WRITE;
pascal@20179 394 /*!40000 ALTER TABLE `download_enable` DISABLE KEYS */;
pascal@20179 395 /*!40000 ALTER TABLE `download_enable` ENABLE KEYS */;
pascal@20179 396 UNLOCK TABLES;
pascal@20179 397
pascal@20179 398 --
pascal@20179 399 -- Table structure for table `download_history`
pascal@20179 400 --
pascal@20179 401
pascal@20179 402 DROP TABLE IF EXISTS `download_history`;
pascal@20179 403 SET @saved_cs_client = @@character_set_client;
pascal@20179 404 SET character_set_client = utf8;
pascal@20179 405 CREATE TABLE `download_history` (
pascal@20179 406 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 407 `PKG_ID` int(11) NOT NULL default '0',
pascal@20179 408 `PKG_NAME` varchar(255) default NULL,
pascal@20179 409 PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`)
pascal@20179 410 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 411 SET character_set_client = @saved_cs_client;
pascal@20179 412
pascal@20179 413 --
pascal@20179 414 -- Dumping data for table `download_history`
pascal@20179 415 --
pascal@20179 416
pascal@20179 417 LOCK TABLES `download_history` WRITE;
pascal@20179 418 /*!40000 ALTER TABLE `download_history` DISABLE KEYS */;
pascal@20179 419 /*!40000 ALTER TABLE `download_history` ENABLE KEYS */;
pascal@20179 420 UNLOCK TABLES;
pascal@20179 421
pascal@20179 422 --
pascal@20179 423 -- Table structure for table `drives`
pascal@20179 424 --
pascal@20179 425
pascal@20179 426 DROP TABLE IF EXISTS `drives`;
pascal@20179 427 SET @saved_cs_client = @@character_set_client;
pascal@20179 428 SET character_set_client = utf8;
pascal@20179 429 CREATE TABLE `drives` (
pascal@20179 430 `ID` int(11) NOT NULL auto_increment,
pascal@20179 431 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 432 `LETTER` varchar(255) default NULL,
pascal@20179 433 `TYPE` varchar(255) default NULL,
pascal@20179 434 `FILESYSTEM` varchar(255) default NULL,
pascal@20179 435 `TOTAL` int(11) default NULL,
pascal@20179 436 `FREE` int(11) default NULL,
pascal@20179 437 `NUMFILES` int(11) default NULL,
pascal@20179 438 `VOLUMN` varchar(255) default NULL,
pascal@20179 439 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 440 KEY `ID` (`ID`)
pascal@20179 441 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 442 SET character_set_client = @saved_cs_client;
pascal@20179 443
pascal@20179 444 --
pascal@20179 445 -- Dumping data for table `drives`
pascal@20179 446 --
pascal@20179 447
pascal@20179 448 LOCK TABLES `drives` WRITE;
pascal@20179 449 /*!40000 ALTER TABLE `drives` DISABLE KEYS */;
pascal@20179 450 /*!40000 ALTER TABLE `drives` ENABLE KEYS */;
pascal@20179 451 UNLOCK TABLES;
pascal@20179 452
pascal@20179 453 --
pascal@20179 454 -- Table structure for table `files`
pascal@20179 455 --
pascal@20179 456
pascal@20179 457 DROP TABLE IF EXISTS `files`;
pascal@20179 458 SET @saved_cs_client = @@character_set_client;
pascal@20179 459 SET character_set_client = utf8;
pascal@20179 460 CREATE TABLE `files` (
pascal@20179 461 `NAME` varchar(255) NOT NULL,
pascal@20179 462 `VERSION` varchar(255) NOT NULL,
pascal@20179 463 `OS` varchar(255) NOT NULL,
pascal@20179 464 `CONTENT` longblob NOT NULL,
pascal@20179 465 PRIMARY KEY (`NAME`,`OS`,`VERSION`)
pascal@20179 466 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 467 SET character_set_client = @saved_cs_client;
pascal@20179 468
pascal@20179 469 --
pascal@20179 470 -- Dumping data for table `files`
pascal@20179 471 --
pascal@20179 472
pascal@20179 473 LOCK TABLES `files` WRITE;
pascal@20179 474 /*!40000 ALTER TABLE `files` DISABLE KEYS */;
pascal@20179 475 /*!40000 ALTER TABLE `files` ENABLE KEYS */;
pascal@20179 476 UNLOCK TABLES;
pascal@20179 477
pascal@20179 478 --
pascal@20179 479 -- Table structure for table `hardware`
pascal@20179 480 --
pascal@20179 481
pascal@20179 482 DROP TABLE IF EXISTS `hardware`;
pascal@20179 483 SET @saved_cs_client = @@character_set_client;
pascal@20179 484 SET character_set_client = utf8;
pascal@20179 485 CREATE TABLE `hardware` (
pascal@20179 486 `ID` int(11) NOT NULL auto_increment,
pascal@20179 487 `DEVICEID` varchar(255) NOT NULL,
pascal@20179 488 `NAME` varchar(255) default NULL,
pascal@20179 489 `WORKGROUP` varchar(255) default NULL,
pascal@20179 490 `USERDOMAIN` varchar(255) default NULL,
pascal@20179 491 `OSNAME` varchar(255) default NULL,
pascal@20179 492 `OSVERSION` varchar(255) default NULL,
pascal@20179 493 `OSCOMMENTS` varchar(255) default NULL,
pascal@20179 494 `PROCESSORT` varchar(255) default NULL,
pascal@20179 495 `PROCESSORS` int(11) default '0',
pascal@20179 496 `PROCESSORN` smallint(6) default NULL,
pascal@20179 497 `MEMORY` int(11) default NULL,
pascal@20179 498 `SWAP` int(11) default NULL,
pascal@20179 499 `IPADDR` varchar(255) default NULL,
pascal@20179 500 `ETIME` datetime default NULL,
pascal@20179 501 `LASTDATE` datetime default NULL,
pascal@20179 502 `LASTCOME` datetime default NULL,
pascal@20179 503 `QUALITY` decimal(4,3) default '0.000',
pascal@20179 504 `FIDELITY` bigint(20) default '1',
pascal@20179 505 `USERID` varchar(255) default NULL,
pascal@20179 506 `TYPE` int(11) default NULL,
pascal@20179 507 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 508 `WINCOMPANY` varchar(255) default NULL,
pascal@20179 509 `WINOWNER` varchar(255) default NULL,
pascal@20179 510 `WINPRODID` varchar(255) default NULL,
pascal@20179 511 `WINPRODKEY` varchar(255) default NULL,
pascal@20179 512 `USERAGENT` varchar(50) default NULL,
pascal@20179 513 `CHECKSUM` int(11) default '131071',
pascal@20179 514 PRIMARY KEY (`DEVICEID`,`ID`),
pascal@20179 515 KEY `NAME` (`NAME`),
pascal@20179 516 KEY `CHECKSUM` (`CHECKSUM`),
pascal@20179 517 KEY `DEVICEID` (`DEVICEID`),
pascal@20179 518 KEY `ID` (`ID`)
pascal@20179 519 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 520 SET character_set_client = @saved_cs_client;
pascal@20179 521
pascal@20179 522 --
pascal@20179 523 -- Dumping data for table `hardware`
pascal@20179 524 --
pascal@20179 525
pascal@20179 526 LOCK TABLES `hardware` WRITE;
pascal@20179 527 /*!40000 ALTER TABLE `hardware` DISABLE KEYS */;
pascal@20179 528 /*!40000 ALTER TABLE `hardware` ENABLE KEYS */;
pascal@20179 529 UNLOCK TABLES;
pascal@20179 530
pascal@20179 531 --
pascal@20179 532 -- Table structure for table `inputs`
pascal@20179 533 --
pascal@20179 534
pascal@20179 535 DROP TABLE IF EXISTS `inputs`;
pascal@20179 536 SET @saved_cs_client = @@character_set_client;
pascal@20179 537 SET character_set_client = utf8;
pascal@20179 538 CREATE TABLE `inputs` (
pascal@20179 539 `ID` int(11) NOT NULL auto_increment,
pascal@20179 540 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 541 `TYPE` varchar(255) default NULL,
pascal@20179 542 `MANUFACTURER` varchar(255) default NULL,
pascal@20179 543 `CAPTION` varchar(255) default NULL,
pascal@20179 544 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 545 `INTERFACE` varchar(255) default NULL,
pascal@20179 546 `POINTTYPE` varchar(255) default NULL,
pascal@20179 547 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 548 KEY `ID` (`ID`)
pascal@20179 549 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 550 SET character_set_client = @saved_cs_client;
pascal@20179 551
pascal@20179 552 --
pascal@20179 553 -- Dumping data for table `inputs`
pascal@20179 554 --
pascal@20179 555
pascal@20179 556 LOCK TABLES `inputs` WRITE;
pascal@20179 557 /*!40000 ALTER TABLE `inputs` DISABLE KEYS */;
pascal@20179 558 /*!40000 ALTER TABLE `inputs` ENABLE KEYS */;
pascal@20179 559 UNLOCK TABLES;
pascal@20179 560
pascal@20179 561 --
pascal@20179 562 -- Table structure for table `locks`
pascal@20179 563 --
pascal@20179 564
pascal@20179 565 DROP TABLE IF EXISTS `locks`;
pascal@20179 566 SET @saved_cs_client = @@character_set_client;
pascal@20179 567 SET character_set_client = utf8;
pascal@20179 568 CREATE TABLE `locks` (
pascal@20179 569 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 570 `ID` int(11) default NULL,
pascal@20179 571 `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
pascal@20179 572 PRIMARY KEY (`HARDWARE_ID`),
pascal@20179 573 KEY `SINCE` (`SINCE`)
pascal@20179 574 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;
pascal@20179 575 SET character_set_client = @saved_cs_client;
pascal@20179 576
pascal@20179 577 --
pascal@20179 578 -- Dumping data for table `locks`
pascal@20179 579 --
pascal@20179 580
pascal@20179 581 LOCK TABLES `locks` WRITE;
pascal@20179 582 /*!40000 ALTER TABLE `locks` DISABLE KEYS */;
pascal@20179 583 /*!40000 ALTER TABLE `locks` ENABLE KEYS */;
pascal@20179 584 UNLOCK TABLES;
pascal@20179 585
pascal@20179 586 --
pascal@20179 587 -- Table structure for table `memories`
pascal@20179 588 --
pascal@20179 589
pascal@20179 590 DROP TABLE IF EXISTS `memories`;
pascal@20179 591 SET @saved_cs_client = @@character_set_client;
pascal@20179 592 SET character_set_client = utf8;
pascal@20179 593 CREATE TABLE `memories` (
pascal@20179 594 `ID` int(11) NOT NULL auto_increment,
pascal@20179 595 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 596 `CAPTION` varchar(255) default NULL,
pascal@20179 597 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 598 `CAPACITY` varchar(255) default NULL,
pascal@20179 599 `PURPOSE` varchar(255) default NULL,
pascal@20179 600 `TYPE` varchar(255) default NULL,
pascal@20179 601 `SPEED` varchar(255) default NULL,
pascal@20179 602 `NUMSLOTS` smallint(6) default NULL,
pascal@20179 603 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 604 KEY `ID` (`ID`)
pascal@20179 605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 606 SET character_set_client = @saved_cs_client;
pascal@20179 607
pascal@20179 608 --
pascal@20179 609 -- Dumping data for table `memories`
pascal@20179 610 --
pascal@20179 611
pascal@20179 612 LOCK TABLES `memories` WRITE;
pascal@20179 613 /*!40000 ALTER TABLE `memories` DISABLE KEYS */;
pascal@20179 614 /*!40000 ALTER TABLE `memories` ENABLE KEYS */;
pascal@20179 615 UNLOCK TABLES;
pascal@20179 616
pascal@20179 617 --
pascal@20179 618 -- Table structure for table `modems`
pascal@20179 619 --
pascal@20179 620
pascal@20179 621 DROP TABLE IF EXISTS `modems`;
pascal@20179 622 SET @saved_cs_client = @@character_set_client;
pascal@20179 623 SET character_set_client = utf8;
pascal@20179 624 CREATE TABLE `modems` (
pascal@20179 625 `ID` int(11) NOT NULL auto_increment,
pascal@20179 626 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 627 `NAME` varchar(255) default NULL,
pascal@20179 628 `MODEL` varchar(255) default NULL,
pascal@20179 629 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 630 `TYPE` varchar(255) default NULL,
pascal@20179 631 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 632 KEY `ID` (`ID`)
pascal@20179 633 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 634 SET character_set_client = @saved_cs_client;
pascal@20179 635
pascal@20179 636 --
pascal@20179 637 -- Dumping data for table `modems`
pascal@20179 638 --
pascal@20179 639
pascal@20179 640 LOCK TABLES `modems` WRITE;
pascal@20179 641 /*!40000 ALTER TABLE `modems` DISABLE KEYS */;
pascal@20179 642 /*!40000 ALTER TABLE `modems` ENABLE KEYS */;
pascal@20179 643 UNLOCK TABLES;
pascal@20179 644
pascal@20179 645 --
pascal@20179 646 -- Table structure for table `monitors`
pascal@20179 647 --
pascal@20179 648
pascal@20179 649 DROP TABLE IF EXISTS `monitors`;
pascal@20179 650 SET @saved_cs_client = @@character_set_client;
pascal@20179 651 SET character_set_client = utf8;
pascal@20179 652 CREATE TABLE `monitors` (
pascal@20179 653 `ID` int(11) NOT NULL auto_increment,
pascal@20179 654 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 655 `MANUFACTURER` varchar(255) default NULL,
pascal@20179 656 `CAPTION` varchar(255) default NULL,
pascal@20179 657 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 658 `TYPE` varchar(255) default NULL,
pascal@20179 659 `SERIAL` varchar(255) default NULL,
pascal@20179 660 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 661 KEY `ID` (`ID`)
pascal@20179 662 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 663 SET character_set_client = @saved_cs_client;
pascal@20179 664
pascal@20179 665 --
pascal@20179 666 -- Dumping data for table `monitors`
pascal@20179 667 --
pascal@20179 668
pascal@20179 669 LOCK TABLES `monitors` WRITE;
pascal@20179 670 /*!40000 ALTER TABLE `monitors` DISABLE KEYS */;
pascal@20179 671 /*!40000 ALTER TABLE `monitors` ENABLE KEYS */;
pascal@20179 672 UNLOCK TABLES;
pascal@20179 673
pascal@20179 674 --
pascal@20179 675 -- Table structure for table `netmap`
pascal@20179 676 --
pascal@20179 677
pascal@20179 678 DROP TABLE IF EXISTS `netmap`;
pascal@20179 679 SET @saved_cs_client = @@character_set_client;
pascal@20179 680 SET character_set_client = utf8;
pascal@20179 681 CREATE TABLE `netmap` (
pascal@20179 682 `IP` varchar(15) NOT NULL,
pascal@20179 683 `MAC` varchar(17) NOT NULL,
pascal@20179 684 `MASK` varchar(15) NOT NULL,
pascal@20179 685 `NETID` varchar(15) NOT NULL,
pascal@20179 686 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
pascal@20179 687 `NAME` varchar(255) default NULL,
pascal@20179 688 PRIMARY KEY (`MAC`),
pascal@20179 689 KEY `IP` (`IP`),
pascal@20179 690 KEY `NETID` (`NETID`)
pascal@20179 691 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 692 SET character_set_client = @saved_cs_client;
pascal@20179 693
pascal@20179 694 --
pascal@20179 695 -- Dumping data for table `netmap`
pascal@20179 696 --
pascal@20179 697
pascal@20179 698 LOCK TABLES `netmap` WRITE;
pascal@20179 699 /*!40000 ALTER TABLE `netmap` DISABLE KEYS */;
pascal@20179 700 /*!40000 ALTER TABLE `netmap` ENABLE KEYS */;
pascal@20179 701 UNLOCK TABLES;
pascal@20179 702
pascal@20179 703 --
pascal@20179 704 -- Table structure for table `network_devices`
pascal@20179 705 --
pascal@20179 706
pascal@20179 707 DROP TABLE IF EXISTS `network_devices`;
pascal@20179 708 SET @saved_cs_client = @@character_set_client;
pascal@20179 709 SET character_set_client = utf8;
pascal@20179 710 CREATE TABLE `network_devices` (
pascal@20179 711 `ID` int(11) NOT NULL auto_increment,
pascal@20179 712 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 713 `TYPE` varchar(255) default NULL,
pascal@20179 714 `MACADDR` varchar(255) default NULL,
pascal@20179 715 `USER` varchar(255) default NULL,
pascal@20179 716 PRIMARY KEY (`ID`),
pascal@20179 717 KEY `MACADDR` (`MACADDR`)
pascal@20179 718 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 719 SET character_set_client = @saved_cs_client;
pascal@20179 720
pascal@20179 721 --
pascal@20179 722 -- Dumping data for table `network_devices`
pascal@20179 723 --
pascal@20179 724
pascal@20179 725 LOCK TABLES `network_devices` WRITE;
pascal@20179 726 /*!40000 ALTER TABLE `network_devices` DISABLE KEYS */;
pascal@20179 727 /*!40000 ALTER TABLE `network_devices` ENABLE KEYS */;
pascal@20179 728 UNLOCK TABLES;
pascal@20179 729
pascal@20179 730 --
pascal@20179 731 -- Table structure for table `networks`
pascal@20179 732 --
pascal@20179 733
pascal@20179 734 DROP TABLE IF EXISTS `networks`;
pascal@20179 735 SET @saved_cs_client = @@character_set_client;
pascal@20179 736 SET character_set_client = utf8;
pascal@20179 737 CREATE TABLE `networks` (
pascal@20179 738 `ID` int(11) NOT NULL auto_increment,
pascal@20179 739 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 740 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 741 `TYPE` varchar(255) default NULL,
pascal@20179 742 `TYPEMIB` varchar(255) default NULL,
pascal@20179 743 `SPEED` varchar(255) default NULL,
pascal@20179 744 `MACADDR` varchar(255) default NULL,
pascal@20179 745 `STATUS` varchar(255) default NULL,
pascal@20179 746 `IPADDRESS` varchar(255) default NULL,
pascal@20179 747 `IPMASK` varchar(255) default NULL,
pascal@20179 748 `IPGATEWAY` varchar(255) default NULL,
pascal@20179 749 `IPSUBNET` varchar(255) default NULL,
pascal@20179 750 `IPDHCP` varchar(255) default NULL,
pascal@20179 751 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 752 KEY `MACADDR` (`MACADDR`),
pascal@20179 753 KEY `IPSUBNET` (`IPSUBNET`),
pascal@20179 754 KEY `ID` (`ID`)
pascal@20179 755 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 756 SET character_set_client = @saved_cs_client;
pascal@20179 757
pascal@20179 758 --
pascal@20179 759 -- Dumping data for table `networks`
pascal@20179 760 --
pascal@20179 761
pascal@20179 762 LOCK TABLES `networks` WRITE;
pascal@20179 763 /*!40000 ALTER TABLE `networks` DISABLE KEYS */;
pascal@20179 764 /*!40000 ALTER TABLE `networks` ENABLE KEYS */;
pascal@20179 765 UNLOCK TABLES;
pascal@20179 766
pascal@20179 767 --
pascal@20179 768 -- Table structure for table `operators`
pascal@20179 769 --
pascal@20179 770
pascal@20179 771 DROP TABLE IF EXISTS `operators`;
pascal@20179 772 SET @saved_cs_client = @@character_set_client;
pascal@20179 773 SET character_set_client = utf8;
pascal@20179 774 CREATE TABLE `operators` (
pascal@20179 775 `ID` varchar(255) NOT NULL default '',
pascal@20179 776 `FIRSTNAME` varchar(255) default NULL,
pascal@20179 777 `LASTNAME` varchar(255) default NULL,
pascal@20179 778 `PASSWD` varchar(50) default NULL,
pascal@20179 779 `ACCESSLVL` int(11) default NULL,
pascal@20179 780 `COMMENTS` text,
pascal@20179 781 PRIMARY KEY (`ID`)
pascal@20179 782 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 783 SET character_set_client = @saved_cs_client;
pascal@20179 784
pascal@20179 785 --
pascal@20179 786 -- Dumping data for table `operators`
pascal@20179 787 --
pascal@20179 788
pascal@20179 789 LOCK TABLES `operators` WRITE;
pascal@20179 790 /*!40000 ALTER TABLE `operators` DISABLE KEYS */;
pascal@20179 791 INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account');
pascal@20179 792 /*!40000 ALTER TABLE `operators` ENABLE KEYS */;
pascal@20179 793 UNLOCK TABLES;
pascal@20179 794
pascal@20179 795 --
pascal@20179 796 -- Table structure for table `ports`
pascal@20179 797 --
pascal@20179 798
pascal@20179 799 DROP TABLE IF EXISTS `ports`;
pascal@20179 800 SET @saved_cs_client = @@character_set_client;
pascal@20179 801 SET character_set_client = utf8;
pascal@20179 802 CREATE TABLE `ports` (
pascal@20179 803 `ID` int(11) NOT NULL auto_increment,
pascal@20179 804 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 805 `TYPE` varchar(255) default NULL,
pascal@20179 806 `NAME` varchar(255) default NULL,
pascal@20179 807 `CAPTION` varchar(255) default NULL,
pascal@20179 808 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 809 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 810 KEY `ID` (`ID`)
pascal@20179 811 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 812 SET character_set_client = @saved_cs_client;
pascal@20179 813
pascal@20179 814 --
pascal@20179 815 -- Dumping data for table `ports`
pascal@20179 816 --
pascal@20179 817
pascal@20179 818 LOCK TABLES `ports` WRITE;
pascal@20179 819 /*!40000 ALTER TABLE `ports` DISABLE KEYS */;
pascal@20179 820 /*!40000 ALTER TABLE `ports` ENABLE KEYS */;
pascal@20179 821 UNLOCK TABLES;
pascal@20179 822
pascal@20179 823 --
pascal@20179 824 -- Table structure for table `printers`
pascal@20179 825 --
pascal@20179 826
pascal@20179 827 DROP TABLE IF EXISTS `printers`;
pascal@20179 828 SET @saved_cs_client = @@character_set_client;
pascal@20179 829 SET character_set_client = utf8;
pascal@20179 830 CREATE TABLE `printers` (
pascal@20179 831 `ID` int(11) NOT NULL auto_increment,
pascal@20179 832 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 833 `NAME` varchar(255) default NULL,
pascal@20179 834 `DRIVER` varchar(255) default NULL,
pascal@20179 835 `PORT` varchar(255) default NULL,
pascal@20179 836 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 837 KEY `ID` (`ID`)
pascal@20179 838 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 839 SET character_set_client = @saved_cs_client;
pascal@20179 840
pascal@20179 841 --
pascal@20179 842 -- Dumping data for table `printers`
pascal@20179 843 --
pascal@20179 844
pascal@20179 845 LOCK TABLES `printers` WRITE;
pascal@20179 846 /*!40000 ALTER TABLE `printers` DISABLE KEYS */;
pascal@20179 847 /*!40000 ALTER TABLE `printers` ENABLE KEYS */;
pascal@20179 848 UNLOCK TABLES;
pascal@20179 849
pascal@20179 850 --
pascal@20179 851 -- Table structure for table `regconfig`
pascal@20179 852 --
pascal@20179 853
pascal@20179 854 DROP TABLE IF EXISTS `regconfig`;
pascal@20179 855 SET @saved_cs_client = @@character_set_client;
pascal@20179 856 SET character_set_client = utf8;
pascal@20179 857 CREATE TABLE `regconfig` (
pascal@20179 858 `ID` int(11) NOT NULL auto_increment,
pascal@20179 859 `NAME` varchar(255) default NULL,
pascal@20179 860 `REGTREE` int(11) default NULL,
pascal@20179 861 `REGKEY` text,
pascal@20179 862 `REGVALUE` varchar(255) default NULL,
pascal@20179 863 PRIMARY KEY (`ID`),
pascal@20179 864 KEY `NAME` (`NAME`)
pascal@20179 865 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 866 SET character_set_client = @saved_cs_client;
pascal@20179 867
pascal@20179 868 --
pascal@20179 869 -- Dumping data for table `regconfig`
pascal@20179 870 --
pascal@20179 871
pascal@20179 872 LOCK TABLES `regconfig` WRITE;
pascal@20179 873 /*!40000 ALTER TABLE `regconfig` DISABLE KEYS */;
pascal@20179 874 /*!40000 ALTER TABLE `regconfig` ENABLE KEYS */;
pascal@20179 875 UNLOCK TABLES;
pascal@20179 876
pascal@20179 877 --
pascal@20179 878 -- Table structure for table `registry`
pascal@20179 879 --
pascal@20179 880
pascal@20179 881 DROP TABLE IF EXISTS `registry`;
pascal@20179 882 SET @saved_cs_client = @@character_set_client;
pascal@20179 883 SET character_set_client = utf8;
pascal@20179 884 CREATE TABLE `registry` (
pascal@20179 885 `ID` int(11) NOT NULL auto_increment,
pascal@20179 886 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 887 `NAME` varchar(255) default NULL,
pascal@20179 888 `REGVALUE` varchar(255) default NULL,
pascal@20179 889 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 890 KEY `NAME` (`NAME`),
pascal@20179 891 KEY `ID` (`ID`)
pascal@20179 892 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 893 SET character_set_client = @saved_cs_client;
pascal@20179 894
pascal@20179 895 --
pascal@20179 896 -- Dumping data for table `registry`
pascal@20179 897 --
pascal@20179 898
pascal@20179 899 LOCK TABLES `registry` WRITE;
pascal@20179 900 /*!40000 ALTER TABLE `registry` DISABLE KEYS */;
pascal@20179 901 /*!40000 ALTER TABLE `registry` ENABLE KEYS */;
pascal@20179 902 UNLOCK TABLES;
pascal@20179 903
pascal@20179 904 --
pascal@20179 905 -- Table structure for table `slots`
pascal@20179 906 --
pascal@20179 907
pascal@20179 908 DROP TABLE IF EXISTS `slots`;
pascal@20179 909 SET @saved_cs_client = @@character_set_client;
pascal@20179 910 SET character_set_client = utf8;
pascal@20179 911 CREATE TABLE `slots` (
pascal@20179 912 `ID` int(11) NOT NULL auto_increment,
pascal@20179 913 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 914 `NAME` varchar(255) default NULL,
pascal@20179 915 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 916 `DESIGNATION` varchar(255) default NULL,
pascal@20179 917 `PURPOSE` varchar(255) default NULL,
pascal@20179 918 `STATUS` varchar(255) default NULL,
pascal@20179 919 `PSHARE` tinyint(4) default NULL,
pascal@20179 920 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 921 KEY `ID` (`ID`)
pascal@20179 922 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 923 SET character_set_client = @saved_cs_client;
pascal@20179 924
pascal@20179 925 --
pascal@20179 926 -- Dumping data for table `slots`
pascal@20179 927 --
pascal@20179 928
pascal@20179 929 LOCK TABLES `slots` WRITE;
pascal@20179 930 /*!40000 ALTER TABLE `slots` DISABLE KEYS */;
pascal@20179 931 /*!40000 ALTER TABLE `slots` ENABLE KEYS */;
pascal@20179 932 UNLOCK TABLES;
pascal@20179 933
pascal@20179 934 --
pascal@20179 935 -- Table structure for table `softwares`
pascal@20179 936 --
pascal@20179 937
pascal@20179 938 DROP TABLE IF EXISTS `softwares`;
pascal@20179 939 SET @saved_cs_client = @@character_set_client;
pascal@20179 940 SET character_set_client = utf8;
pascal@20179 941 CREATE TABLE `softwares` (
pascal@20179 942 `ID` int(11) NOT NULL auto_increment,
pascal@20179 943 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 944 `PUBLISHER` varchar(255) default NULL,
pascal@20179 945 `NAME` varchar(255) default NULL,
pascal@20179 946 `VERSION` varchar(255) default NULL,
pascal@20179 947 `FOLDER` text,
pascal@20179 948 `COMMENTS` text,
pascal@20179 949 `FILENAME` varchar(255) default NULL,
pascal@20179 950 `FILESIZE` int(11) default '0',
pascal@20179 951 `SOURCE` int(11) default NULL,
pascal@20179 952 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 953 KEY `NAME` (`NAME`),
pascal@20179 954 KEY `ID` (`ID`)
pascal@20179 955 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 956 SET character_set_client = @saved_cs_client;
pascal@20179 957
pascal@20179 958 --
pascal@20179 959 -- Dumping data for table `softwares`
pascal@20179 960 --
pascal@20179 961
pascal@20179 962 LOCK TABLES `softwares` WRITE;
pascal@20179 963 /*!40000 ALTER TABLE `softwares` DISABLE KEYS */;
pascal@20179 964 /*!40000 ALTER TABLE `softwares` ENABLE KEYS */;
pascal@20179 965 UNLOCK TABLES;
pascal@20179 966
pascal@20179 967 --
pascal@20179 968 -- Table structure for table `sounds`
pascal@20179 969 --
pascal@20179 970
pascal@20179 971 DROP TABLE IF EXISTS `sounds`;
pascal@20179 972 SET @saved_cs_client = @@character_set_client;
pascal@20179 973 SET character_set_client = utf8;
pascal@20179 974 CREATE TABLE `sounds` (
pascal@20179 975 `ID` int(11) NOT NULL auto_increment,
pascal@20179 976 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 977 `MANUFACTURER` varchar(255) default NULL,
pascal@20179 978 `NAME` varchar(255) default NULL,
pascal@20179 979 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 980 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 981 KEY `ID` (`ID`)
pascal@20179 982 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 983 SET character_set_client = @saved_cs_client;
pascal@20179 984
pascal@20179 985 --
pascal@20179 986 -- Dumping data for table `sounds`
pascal@20179 987 --
pascal@20179 988
pascal@20179 989 LOCK TABLES `sounds` WRITE;
pascal@20179 990 /*!40000 ALTER TABLE `sounds` DISABLE KEYS */;
pascal@20179 991 /*!40000 ALTER TABLE `sounds` ENABLE KEYS */;
pascal@20179 992 UNLOCK TABLES;
pascal@20179 993
pascal@20179 994 --
pascal@20179 995 -- Table structure for table `storages`
pascal@20179 996 --
pascal@20179 997
pascal@20179 998 DROP TABLE IF EXISTS `storages`;
pascal@20179 999 SET @saved_cs_client = @@character_set_client;
pascal@20179 1000 SET character_set_client = utf8;
pascal@20179 1001 CREATE TABLE `storages` (
pascal@20179 1002 `ID` int(11) NOT NULL auto_increment,
pascal@20179 1003 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 1004 `MANUFACTURER` varchar(255) default NULL,
pascal@20179 1005 `NAME` varchar(255) default NULL,
pascal@20179 1006 `MODEL` varchar(255) default NULL,
pascal@20179 1007 `DESCRIPTION` varchar(255) default NULL,
pascal@20179 1008 `TYPE` varchar(255) default NULL,
pascal@20179 1009 `DISKSIZE` int(11) default NULL,
pascal@20179 1010 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 1011 KEY `ID` (`ID`)
pascal@20179 1012 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 1013 SET character_set_client = @saved_cs_client;
pascal@20179 1014
pascal@20179 1015 --
pascal@20179 1016 -- Dumping data for table `storages`
pascal@20179 1017 --
pascal@20179 1018
pascal@20179 1019 LOCK TABLES `storages` WRITE;
pascal@20179 1020 /*!40000 ALTER TABLE `storages` DISABLE KEYS */;
pascal@20179 1021 /*!40000 ALTER TABLE `storages` ENABLE KEYS */;
pascal@20179 1022 UNLOCK TABLES;
pascal@20179 1023
pascal@20179 1024 --
pascal@20179 1025 -- Table structure for table `subnet`
pascal@20179 1026 --
pascal@20179 1027
pascal@20179 1028 DROP TABLE IF EXISTS `subnet`;
pascal@20179 1029 SET @saved_cs_client = @@character_set_client;
pascal@20179 1030 SET character_set_client = utf8;
pascal@20179 1031 CREATE TABLE `subnet` (
pascal@20179 1032 `NETID` varchar(15) NOT NULL,
pascal@20179 1033 `NAME` varchar(255) default NULL,
pascal@20179 1034 `ID` int(11) default NULL,
pascal@20179 1035 `MASK` varchar(255) default NULL,
pascal@20179 1036 PRIMARY KEY (`NETID`)
pascal@20179 1037 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
pascal@20179 1038 SET character_set_client = @saved_cs_client;
pascal@20179 1039
pascal@20179 1040 --
pascal@20179 1041 -- Dumping data for table `subnet`
pascal@20179 1042 --
pascal@20179 1043
pascal@20179 1044 LOCK TABLES `subnet` WRITE;
pascal@20179 1045 /*!40000 ALTER TABLE `subnet` DISABLE KEYS */;
pascal@20179 1046 /*!40000 ALTER TABLE `subnet` ENABLE KEYS */;
pascal@20179 1047 UNLOCK TABLES;
pascal@20179 1048
pascal@20179 1049 --
pascal@20179 1050 -- Table structure for table `videos`
pascal@20179 1051 --
pascal@20179 1052
pascal@20179 1053 DROP TABLE IF EXISTS `videos`;
pascal@20179 1054 SET @saved_cs_client = @@character_set_client;
pascal@20179 1055 SET character_set_client = utf8;
pascal@20179 1056 CREATE TABLE `videos` (
pascal@20179 1057 `ID` int(11) NOT NULL auto_increment,
pascal@20179 1058 `HARDWARE_ID` int(11) NOT NULL,
pascal@20179 1059 `NAME` varchar(255) default NULL,
pascal@20179 1060 `CHIPSET` varchar(255) default NULL,
pascal@20179 1061 `MEMORY` varchar(255) default NULL,
pascal@20179 1062 `RESOLUTION` varchar(255) default NULL,
pascal@20179 1063 PRIMARY KEY (`HARDWARE_ID`,`ID`),
pascal@20179 1064 KEY `ID` (`ID`)
pascal@20179 1065 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
pascal@20179 1066 SET character_set_client = @saved_cs_client;
pascal@20179 1067
pascal@20179 1068 --
pascal@20179 1069 -- Dumping data for table `videos`
pascal@20179 1070 --
pascal@20179 1071
pascal@20179 1072 LOCK TABLES `videos` WRITE;
pascal@20179 1073 /*!40000 ALTER TABLE `videos` DISABLE KEYS */;
pascal@20179 1074 /*!40000 ALTER TABLE `videos` ENABLE KEYS */;
pascal@20179 1075 UNLOCK TABLES;
pascal@20179 1076 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
pascal@20179 1077
pascal@20179 1078 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
pascal@20179 1079 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
pascal@20179 1080 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
pascal@20179 1081 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
pascal@20179 1082 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
pascal@20179 1083 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
pascal@20179 1084 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
pascal@20179 1085
pascal@20179 1086 -- Dump completed on 2009-04-25 0:01:16