wok-current annotate ocsreports/stuff/ocsbase.sql @ rev 23485

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