SliTaz Repositories

1 -- MySQL dump 10.11

2 --

3 -- Host: localhost Database: ocsweb

4 -- ------------------------------------------------------

5 -- Server version 5.0.51b-log

6

7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

10 /*!40101 SET NAMES utf8 */;

11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

12 /*!40103 SET TIME_ZONE='+00:00' */;

13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

17

18 --

19 -- Table structure for table `accesslog`

20 --

21 USE ocsweb;

22

23 DROP TABLE IF EXISTS `accesslog`;

24 SET @saved_cs_client = @@character_set_client;

25 SET character_set_client = utf8;

26 CREATE TABLE `accesslog` (

27 `ID` int(11) NOT NULL auto_increment,

28 `HARDWARE_ID` int(11) NOT NULL,

29 `USERID` varchar(255) default NULL,

30 `LOGDATE` datetime default NULL,

31 `PROCESSES` text,

32 PRIMARY KEY (`HARDWARE_ID`,`ID`),

33 KEY `ID` (`ID`)

34 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

35 SET character_set_client = @saved_cs_client;

36

37 --

38 -- Dumping data for table `accesslog`

39 --

40

41 LOCK TABLES `accesslog` WRITE;

42 /*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;

43 /*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;

44 UNLOCK TABLES;

45

46 --

47 -- Table structure for table `accountinfo`

48 --

49

50 DROP TABLE IF EXISTS `accountinfo`;

51 SET @saved_cs_client = @@character_set_client;

52 SET character_set_client = utf8;

53 CREATE TABLE `accountinfo` (

54 `HARDWARE_ID` int(11) NOT NULL,

55 `TAG` varchar(255) default 'NA',

56 PRIMARY KEY (`HARDWARE_ID`),

57 KEY `TAG` (`TAG`)

58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

59 SET character_set_client = @saved_cs_client;

60

61 --

62 -- Dumping data for table `accountinfo`

63 --

64

65 LOCK TABLES `accountinfo` WRITE;

66 /*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */;

67 /*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */;

68 UNLOCK TABLES;

69

70 --

71 -- Table structure for table `bios`

72 --

73

74 DROP TABLE IF EXISTS `bios`;

75 SET @saved_cs_client = @@character_set_client;

76 SET character_set_client = utf8;

77 CREATE TABLE `bios` (

78 `HARDWARE_ID` int(11) NOT NULL,

79 `SMANUFACTURER` varchar(255) default NULL,

80 `SMODEL` varchar(255) default NULL,

81 `SSN` varchar(255) default NULL,

82 `TYPE` varchar(255) default NULL,

83 `BMANUFACTURER` varchar(255) default NULL,

84 `BVERSION` varchar(255) default NULL,

85 `BDATE` varchar(255) default NULL,

86 PRIMARY KEY (`HARDWARE_ID`),

87 KEY `SSN` (`SSN`)

88 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

89 SET character_set_client = @saved_cs_client;

90

91 --

92 -- Dumping data for table `bios`

93 --

94

95 LOCK TABLES `bios` WRITE;

96 /*!40000 ALTER TABLE `bios` DISABLE KEYS */;

97 /*!40000 ALTER TABLE `bios` ENABLE KEYS */;

98 UNLOCK TABLES;

99

100 --

101 -- Table structure for table `config`

102 --

103

104 DROP TABLE IF EXISTS `config`;

105 SET @saved_cs_client = @@character_set_client;

106 SET character_set_client = utf8;

107 CREATE TABLE `config` (

108 `NAME` varchar(50) NOT NULL,

109 `IVALUE` int(11) default NULL,

110 `TVALUE` varchar(255) default NULL,

111 `COMMENTS` text,

112 PRIMARY KEY (`NAME`)

113 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

114 SET character_set_client = @saved_cs_client;

115

116 --

117 -- Dumping data for table `config`

118 --

119

120 LOCK TABLES `config` WRITE;

121 /*!40000 ALTER TABLE `config` DISABLE KEYS */;

122 INSERT INTO `config` VALUES ('FREQUENCY',0,'','Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),('PROLOG_FREQ',24,'','Specify the frequency (hours) of prolog, on agents'),('IPDISCOVER',2,'','Max number of computers per gateway retrieving IP on the network'),('INVENTORY_DIFF',1,'','Activate/Deactivate inventory incremental writing'),('IPDISCOVER_LATENCY',100,'','Default latency between two arp requests'),('INVENTORY_TRANSACTION',1,'','Enable/disable db commit at each inventory section'),('REGISTRY',0,'','Activates or not the registry query function'),('IPDISCOVER_MAX_ALIVE',7,'','Max number of days before an Ip Discover computer is replaced'),('DEPLOY',1,'','Activates or not the automatic deployment option'),('UPDATE',0,'','Activates or not the update feature'),('GUI_VERSION',0,'4100','Version of the installed GUI and database'),('TRACE_DELETED',0,'','Trace deleted/duplicated computers (Activated by GLPI)'),('LOGLEVEL',0,'','ocs engine loglevel'),('AUTO_DUPLICATE_LVL',7,'','Duplicates bitmap'),('DOWNLOAD',0,'','Activate softwares auto deployment feature'),('DOWNLOAD_CYCLE_LATENCY',60,'','Time between two cycles (seconds)'),('DOWNLOAD_PERIOD_LENGTH',10,'','Number of cycles in a period'),('DOWNLOAD_FRAG_LATENCY',10,'','Time between two downloads (seconds)'),('DOWNLOAD_PERIOD_LATENCY',0,'','Time between two periods (seconds)'),('DOWNLOAD_TIMEOUT',30,'','Validity of a package (in days)'),('LOCAL_SERVER',0,'localhost','Server address used for local import'),('LOCAL_PORT',80,'','Server port used for local import');

123 /*!40000 ALTER TABLE `config` ENABLE KEYS */;

124 UNLOCK TABLES;

125

126 --

127 -- Table structure for table `conntrack`

128 --

129

130 DROP TABLE IF EXISTS `conntrack`;

131 SET @saved_cs_client = @@character_set_client;

132 SET character_set_client = utf8;

133 CREATE TABLE `conntrack` (

134 `IP` varchar(255) NOT NULL default '',

135 `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

136 PRIMARY KEY (`IP`)

137 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;

138 SET character_set_client = @saved_cs_client;

139

140 --

141 -- Dumping data for table `conntrack`

142 --

143

144 LOCK TABLES `conntrack` WRITE;

145 /*!40000 ALTER TABLE `conntrack` DISABLE KEYS */;

146 /*!40000 ALTER TABLE `conntrack` ENABLE KEYS */;

147 UNLOCK TABLES;

148

149 --

150 -- Table structure for table `controllers`

151 --

152

153 DROP TABLE IF EXISTS `controllers`;

154 SET @saved_cs_client = @@character_set_client;

155 SET character_set_client = utf8;

156 CREATE TABLE `controllers` (

157 `ID` int(11) NOT NULL auto_increment,

158 `HARDWARE_ID` int(11) NOT NULL,

159 `MANUFACTURER` varchar(255) default NULL,

160 `NAME` varchar(255) default NULL,

161 `CAPTION` varchar(255) default NULL,

162 `DESCRIPTION` varchar(255) default NULL,

163 `VERSION` varchar(255) default NULL,

164 `TYPE` varchar(255) default NULL,

165 PRIMARY KEY (`HARDWARE_ID`,`ID`),

166 KEY `ID` (`ID`)

167 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

168 SET character_set_client = @saved_cs_client;

169

170 --

171 -- Dumping data for table `controllers`

172 --

173

174 LOCK TABLES `controllers` WRITE;

175 /*!40000 ALTER TABLE `controllers` DISABLE KEYS */;

176 /*!40000 ALTER TABLE `controllers` ENABLE KEYS */;

177 UNLOCK TABLES;

178

179 --

180 -- Table structure for table `deleted_equiv`

181 --

182

183 DROP TABLE IF EXISTS `deleted_equiv`;

184 SET @saved_cs_client = @@character_set_client;

185 SET character_set_client = utf8;

186 CREATE TABLE `deleted_equiv` (

187 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

188 `DELETED` varchar(255) NOT NULL,

189 `EQUIVALENT` varchar(255) default NULL

190 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

191 SET character_set_client = @saved_cs_client;

192

193 --

194 -- Dumping data for table `deleted_equiv`

195 --

196

197 LOCK TABLES `deleted_equiv` WRITE;

198 /*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */;

199 /*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */;

200 UNLOCK TABLES;

201

202 --

203 -- Table structure for table `deploy`

204 --

205

206 DROP TABLE IF EXISTS `deploy`;

207 SET @saved_cs_client = @@character_set_client;

208 SET character_set_client = utf8;

209 CREATE TABLE `deploy` (

210 `NAME` varchar(255) NOT NULL,

211 `CONTENT` longblob NOT NULL,

212 PRIMARY KEY (`NAME`)

213 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

214 SET character_set_client = @saved_cs_client;

215

216 --

217 -- Dumping data for table `deploy`

218 --

219

220 LOCK TABLES `deploy` WRITE;

221 /*!40000 ALTER TABLE `deploy` DISABLE KEYS */;

222 /*!40000 ALTER TABLE `deploy` ENABLE KEYS */;

223 UNLOCK TABLES;

224

225 --

226 -- Table structure for table `devices`

227 --

228

229 DROP TABLE IF EXISTS `devices`;

230 SET @saved_cs_client = @@character_set_client;

231 SET character_set_client = utf8;

232 CREATE TABLE `devices` (

233 `HARDWARE_ID` int(11) NOT NULL,

234 `NAME` varchar(50) NOT NULL,

235 `IVALUE` int(11) default NULL,

236 `TVALUE` varchar(255) default NULL,

237 `COMMENTS` text,

238 KEY `HARDWARE_ID` (`HARDWARE_ID`),

239 KEY `TVALUE` (`TVALUE`)

240 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

241 SET character_set_client = @saved_cs_client;

242

243 --

244 -- Dumping data for table `devices`

245 --

246

247 LOCK TABLES `devices` WRITE;

248 /*!40000 ALTER TABLE `devices` DISABLE KEYS */;

249 /*!40000 ALTER TABLE `devices` ENABLE KEYS */;

250 UNLOCK TABLES;

251

252 --

253 -- Table structure for table `devicetype`

254 --

255

256 DROP TABLE IF EXISTS `devicetype`;

257 SET @saved_cs_client = @@character_set_client;

258 SET character_set_client = utf8;

259 CREATE TABLE `devicetype` (

260 `ID` int(11) NOT NULL auto_increment,

261 `NAME` varchar(255) default NULL,

262 PRIMARY KEY (`ID`)

263 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

264 SET character_set_client = @saved_cs_client;

265

266 --

267 -- Dumping data for table `devicetype`

268 --

269

270 LOCK TABLES `devicetype` WRITE;

271 /*!40000 ALTER TABLE `devicetype` DISABLE KEYS */;

272 /*!40000 ALTER TABLE `devicetype` ENABLE KEYS */;

273 UNLOCK TABLES;

274

275 --

276 -- Table structure for table `dico_cat`

277 --

278

279 DROP TABLE IF EXISTS `dico_cat`;

280 SET @saved_cs_client = @@character_set_client;

281 SET character_set_client = utf8;

282 CREATE TABLE `dico_cat` (

283 `NAME` varchar(255) NOT NULL,

284 `PERMANENT` tinyint(4) default '0',

285 PRIMARY KEY (`NAME`)

286 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

287 SET character_set_client = @saved_cs_client;

288

289 --

290 -- Dumping data for table `dico_cat`

291 --

292

293 LOCK TABLES `dico_cat` WRITE;

294 /*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */;

295 /*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */;

296 UNLOCK TABLES;

297

298 --

299 -- Table structure for table `dico_ignored`

300 --

301

302 DROP TABLE IF EXISTS `dico_ignored`;

303 SET @saved_cs_client = @@character_set_client;

304 SET character_set_client = utf8;

305 CREATE TABLE `dico_ignored` (

306 `EXTRACTED` varchar(255) NOT NULL,

307 PRIMARY KEY (`EXTRACTED`)

308 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

309 SET character_set_client = @saved_cs_client;

310

311 --

312 -- Dumping data for table `dico_ignored`

313 --

314

315 LOCK TABLES `dico_ignored` WRITE;

316 /*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */;

317 /*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */;

318 UNLOCK TABLES;

319

320 --

321 -- Table structure for table `dico_soft`

322 --

323

324 DROP TABLE IF EXISTS `dico_soft`;

325 SET @saved_cs_client = @@character_set_client;

326 SET character_set_client = utf8;

327 CREATE TABLE `dico_soft` (

328 `EXTRACTED` varchar(255) NOT NULL,

329 `FORMATTED` varchar(255) NOT NULL,

330 PRIMARY KEY (`EXTRACTED`)

331 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

332 SET character_set_client = @saved_cs_client;

333

334 --

335 -- Dumping data for table `dico_soft`

336 --

337

338 LOCK TABLES `dico_soft` WRITE;

339 /*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */;

340 /*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */;

341 UNLOCK TABLES;

342

343 --

344 -- Table structure for table `download_available`

345 --

346

347 DROP TABLE IF EXISTS `download_available`;

348 SET @saved_cs_client = @@character_set_client;

349 SET character_set_client = utf8;

350 CREATE TABLE `download_available` (

351 `FILEID` varchar(255) NOT NULL,

352 `NAME` varchar(255) NOT NULL,

353 `PRIORITY` int(11) NOT NULL,

354 `FRAGMENTS` int(11) NOT NULL,

355 `SIZE` int(11) NOT NULL,

356 `OSNAME` varchar(255) NOT NULL,

357 `COMMENT` text,

358 PRIMARY KEY (`FILEID`)

359 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

360 SET character_set_client = @saved_cs_client;

361

362 --

363 -- Dumping data for table `download_available`

364 --

365

366 LOCK TABLES `download_available` WRITE;

367 /*!40000 ALTER TABLE `download_available` DISABLE KEYS */;

368 /*!40000 ALTER TABLE `download_available` ENABLE KEYS */;

369 UNLOCK TABLES;

370

371 --

372 -- Table structure for table `download_enable`

373 --

374

375 DROP TABLE IF EXISTS `download_enable`;

376 SET @saved_cs_client = @@character_set_client;

377 SET character_set_client = utf8;

378 CREATE TABLE `download_enable` (

379 `ID` int(11) NOT NULL auto_increment,

380 `FILEID` varchar(255) NOT NULL,

381 `INFO_LOC` varchar(255) NOT NULL,

382 `PACK_LOC` varchar(255) NOT NULL,

383 `CERT_PATH` varchar(255) default NULL,

384 `CERT_FILE` varchar(255) default NULL,

385 PRIMARY KEY (`ID`)

386 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

387 SET character_set_client = @saved_cs_client;

388

389 --

390 -- Dumping data for table `download_enable`

391 --

392

393 LOCK TABLES `download_enable` WRITE;

394 /*!40000 ALTER TABLE `download_enable` DISABLE KEYS */;

395 /*!40000 ALTER TABLE `download_enable` ENABLE KEYS */;

396 UNLOCK TABLES;

397

398 --

399 -- Table structure for table `download_history`

400 --

401

402 DROP TABLE IF EXISTS `download_history`;

403 SET @saved_cs_client = @@character_set_client;

404 SET character_set_client = utf8;

405 CREATE TABLE `download_history` (

406 `HARDWARE_ID` int(11) NOT NULL,

407 `PKG_ID` int(11) NOT NULL default '0',

408 `PKG_NAME` varchar(255) default NULL,

409 PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`)

410 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

411 SET character_set_client = @saved_cs_client;

412

413 --

414 -- Dumping data for table `download_history`

415 --

416

417 LOCK TABLES `download_history` WRITE;

418 /*!40000 ALTER TABLE `download_history` DISABLE KEYS */;

419 /*!40000 ALTER TABLE `download_history` ENABLE KEYS */;

420 UNLOCK TABLES;

421

422 --

423 -- Table structure for table `drives`

424 --

425

426 DROP TABLE IF EXISTS `drives`;

427 SET @saved_cs_client = @@character_set_client;

428 SET character_set_client = utf8;

429 CREATE TABLE `drives` (

430 `ID` int(11) NOT NULL auto_increment,

431 `HARDWARE_ID` int(11) NOT NULL,

432 `LETTER` varchar(255) default NULL,

433 `TYPE` varchar(255) default NULL,

434 `FILESYSTEM` varchar(255) default NULL,

435 `TOTAL` int(11) default NULL,

436 `FREE` int(11) default NULL,

437 `NUMFILES` int(11) default NULL,

438 `VOLUMN` varchar(255) default NULL,

439 PRIMARY KEY (`HARDWARE_ID`,`ID`),

440 KEY `ID` (`ID`)

441 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

442 SET character_set_client = @saved_cs_client;

443

444 --

445 -- Dumping data for table `drives`

446 --

447

448 LOCK TABLES `drives` WRITE;

449 /*!40000 ALTER TABLE `drives` DISABLE KEYS */;

450 /*!40000 ALTER TABLE `drives` ENABLE KEYS */;

451 UNLOCK TABLES;

452

453 --

454 -- Table structure for table `files`

455 --

456

457 DROP TABLE IF EXISTS `files`;

458 SET @saved_cs_client = @@character_set_client;

459 SET character_set_client = utf8;

460 CREATE TABLE `files` (

461 `NAME` varchar(255) NOT NULL,

462 `VERSION` varchar(255) NOT NULL,

463 `OS` varchar(255) NOT NULL,

464 `CONTENT` longblob NOT NULL,

465 PRIMARY KEY (`NAME`,`OS`,`VERSION`)

466 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

467 SET character_set_client = @saved_cs_client;

468

469 --

470 -- Dumping data for table `files`

471 --

472

473 LOCK TABLES `files` WRITE;

474 /*!40000 ALTER TABLE `files` DISABLE KEYS */;

475 /*!40000 ALTER TABLE `files` ENABLE KEYS */;

476 UNLOCK TABLES;

477

478 --

479 -- Table structure for table `hardware`

480 --

481

482 DROP TABLE IF EXISTS `hardware`;

483 SET @saved_cs_client = @@character_set_client;

484 SET character_set_client = utf8;

485 CREATE TABLE `hardware` (

486 `ID` int(11) NOT NULL auto_increment,

487 `DEVICEID` varchar(255) NOT NULL,

488 `NAME` varchar(255) default NULL,

489 `WORKGROUP` varchar(255) default NULL,

490 `USERDOMAIN` varchar(255) default NULL,

491 `OSNAME` varchar(255) default NULL,

492 `OSVERSION` varchar(255) default NULL,

493 `OSCOMMENTS` varchar(255) default NULL,

494 `PROCESSORT` varchar(255) default NULL,

495 `PROCESSORS` int(11) default '0',

496 `PROCESSORN` smallint(6) default NULL,

497 `MEMORY` int(11) default NULL,

498 `SWAP` int(11) default NULL,

499 `IPADDR` varchar(255) default NULL,

500 `ETIME` datetime default NULL,

501 `LASTDATE` datetime default NULL,

502 `LASTCOME` datetime default NULL,

503 `QUALITY` decimal(4,3) default '0.000',

504 `FIDELITY` bigint(20) default '1',

505 `USERID` varchar(255) default NULL,

506 `TYPE` int(11) default NULL,

507 `DESCRIPTION` varchar(255) default NULL,

508 `WINCOMPANY` varchar(255) default NULL,

509 `WINOWNER` varchar(255) default NULL,

510 `WINPRODID` varchar(255) default NULL,

511 `WINPRODKEY` varchar(255) default NULL,

512 `USERAGENT` varchar(50) default NULL,

513 `CHECKSUM` int(11) default '131071',

514 PRIMARY KEY (`DEVICEID`,`ID`),

515 KEY `NAME` (`NAME`),

516 KEY `CHECKSUM` (`CHECKSUM`),

517 KEY `DEVICEID` (`DEVICEID`),

518 KEY `ID` (`ID`)

519 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

520 SET character_set_client = @saved_cs_client;

521

522 --

523 -- Dumping data for table `hardware`

524 --

525

526 LOCK TABLES `hardware` WRITE;

527 /*!40000 ALTER TABLE `hardware` DISABLE KEYS */;

528 /*!40000 ALTER TABLE `hardware` ENABLE KEYS */;

529 UNLOCK TABLES;

530

531 --

532 -- Table structure for table `inputs`

533 --

534

535 DROP TABLE IF EXISTS `inputs`;

536 SET @saved_cs_client = @@character_set_client;

537 SET character_set_client = utf8;

538 CREATE TABLE `inputs` (

539 `ID` int(11) NOT NULL auto_increment,

540 `HARDWARE_ID` int(11) NOT NULL,

541 `TYPE` varchar(255) default NULL,

542 `MANUFACTURER` varchar(255) default NULL,

543 `CAPTION` varchar(255) default NULL,

544 `DESCRIPTION` varchar(255) default NULL,

545 `INTERFACE` varchar(255) default NULL,

546 `POINTTYPE` varchar(255) default NULL,

547 PRIMARY KEY (`HARDWARE_ID`,`ID`),

548 KEY `ID` (`ID`)

549 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

550 SET character_set_client = @saved_cs_client;

551

552 --

553 -- Dumping data for table `inputs`

554 --

555

556 LOCK TABLES `inputs` WRITE;

557 /*!40000 ALTER TABLE `inputs` DISABLE KEYS */;

558 /*!40000 ALTER TABLE `inputs` ENABLE KEYS */;

559 UNLOCK TABLES;

560

561 --

562 -- Table structure for table `locks`

563 --

564

565 DROP TABLE IF EXISTS `locks`;

566 SET @saved_cs_client = @@character_set_client;

567 SET character_set_client = utf8;

568 CREATE TABLE `locks` (

569 `HARDWARE_ID` int(11) NOT NULL,

570 `ID` int(11) default NULL,

571 `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

572 PRIMARY KEY (`HARDWARE_ID`),

573 KEY `SINCE` (`SINCE`)

574 ) ENGINE=MEMORY DEFAULT CHARSET=latin1;

575 SET character_set_client = @saved_cs_client;

576

577 --

578 -- Dumping data for table `locks`

579 --

580

581 LOCK TABLES `locks` WRITE;

582 /*!40000 ALTER TABLE `locks` DISABLE KEYS */;

583 /*!40000 ALTER TABLE `locks` ENABLE KEYS */;

584 UNLOCK TABLES;

585

586 --

587 -- Table structure for table `memories`

588 --

589

590 DROP TABLE IF EXISTS `memories`;

591 SET @saved_cs_client = @@character_set_client;

592 SET character_set_client = utf8;

593 CREATE TABLE `memories` (

594 `ID` int(11) NOT NULL auto_increment,

595 `HARDWARE_ID` int(11) NOT NULL,

596 `CAPTION` varchar(255) default NULL,

597 `DESCRIPTION` varchar(255) default NULL,

598 `CAPACITY` varchar(255) default NULL,

599 `PURPOSE` varchar(255) default NULL,

600 `TYPE` varchar(255) default NULL,

601 `SPEED` varchar(255) default NULL,

602 `NUMSLOTS` smallint(6) default NULL,

603 PRIMARY KEY (`HARDWARE_ID`,`ID`),

604 KEY `ID` (`ID`)

605 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

606 SET character_set_client = @saved_cs_client;

607

608 --

609 -- Dumping data for table `memories`

610 --

611

612 LOCK TABLES `memories` WRITE;

613 /*!40000 ALTER TABLE `memories` DISABLE KEYS */;

614 /*!40000 ALTER TABLE `memories` ENABLE KEYS */;

615 UNLOCK TABLES;

616

617 --

618 -- Table structure for table `modems`

619 --

620

621 DROP TABLE IF EXISTS `modems`;

622 SET @saved_cs_client = @@character_set_client;

623 SET character_set_client = utf8;

624 CREATE TABLE `modems` (

625 `ID` int(11) NOT NULL auto_increment,

626 `HARDWARE_ID` int(11) NOT NULL,

627 `NAME` varchar(255) default NULL,

628 `MODEL` varchar(255) default NULL,

629 `DESCRIPTION` varchar(255) default NULL,

630 `TYPE` varchar(255) default NULL,

631 PRIMARY KEY (`HARDWARE_ID`,`ID`),

632 KEY `ID` (`ID`)

633 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

634 SET character_set_client = @saved_cs_client;

635

636 --

637 -- Dumping data for table `modems`

638 --

639

640 LOCK TABLES `modems` WRITE;

641 /*!40000 ALTER TABLE `modems` DISABLE KEYS */;

642 /*!40000 ALTER TABLE `modems` ENABLE KEYS */;

643 UNLOCK TABLES;

644

645 --

646 -- Table structure for table `monitors`

647 --

648

649 DROP TABLE IF EXISTS `monitors`;

650 SET @saved_cs_client = @@character_set_client;

651 SET character_set_client = utf8;

652 CREATE TABLE `monitors` (

653 `ID` int(11) NOT NULL auto_increment,

654 `HARDWARE_ID` int(11) NOT NULL,

655 `MANUFACTURER` varchar(255) default NULL,

656 `CAPTION` varchar(255) default NULL,

657 `DESCRIPTION` varchar(255) default NULL,

658 `TYPE` varchar(255) default NULL,

659 `SERIAL` varchar(255) default NULL,

660 PRIMARY KEY (`HARDWARE_ID`,`ID`),

661 KEY `ID` (`ID`)

662 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

663 SET character_set_client = @saved_cs_client;

664

665 --

666 -- Dumping data for table `monitors`

667 --

668

669 LOCK TABLES `monitors` WRITE;

670 /*!40000 ALTER TABLE `monitors` DISABLE KEYS */;

671 /*!40000 ALTER TABLE `monitors` ENABLE KEYS */;

672 UNLOCK TABLES;

673

674 --

675 -- Table structure for table `netmap`

676 --

677

678 DROP TABLE IF EXISTS `netmap`;

679 SET @saved_cs_client = @@character_set_client;

680 SET character_set_client = utf8;

681 CREATE TABLE `netmap` (

682 `IP` varchar(15) NOT NULL,

683 `MAC` varchar(17) NOT NULL,

684 `MASK` varchar(15) NOT NULL,

685 `NETID` varchar(15) NOT NULL,

686 `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,

687 `NAME` varchar(255) default NULL,

688 PRIMARY KEY (`MAC`),

689 KEY `IP` (`IP`),

690 KEY `NETID` (`NETID`)

691 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

692 SET character_set_client = @saved_cs_client;

693

694 --

695 -- Dumping data for table `netmap`

696 --

697

698 LOCK TABLES `netmap` WRITE;

699 /*!40000 ALTER TABLE `netmap` DISABLE KEYS */;

700 /*!40000 ALTER TABLE `netmap` ENABLE KEYS */;

701 UNLOCK TABLES;

702

703 --

704 -- Table structure for table `network_devices`

705 --

706

707 DROP TABLE IF EXISTS `network_devices`;

708 SET @saved_cs_client = @@character_set_client;

709 SET character_set_client = utf8;

710 CREATE TABLE `network_devices` (

711 `ID` int(11) NOT NULL auto_increment,

712 `DESCRIPTION` varchar(255) default NULL,

713 `TYPE` varchar(255) default NULL,

714 `MACADDR` varchar(255) default NULL,

715 `USER` varchar(255) default NULL,

716 PRIMARY KEY (`ID`),

717 KEY `MACADDR` (`MACADDR`)

718 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

719 SET character_set_client = @saved_cs_client;

720

721 --

722 -- Dumping data for table `network_devices`

723 --

724

725 LOCK TABLES `network_devices` WRITE;

726 /*!40000 ALTER TABLE `network_devices` DISABLE KEYS */;

727 /*!40000 ALTER TABLE `network_devices` ENABLE KEYS */;

728 UNLOCK TABLES;

729

730 --

731 -- Table structure for table `networks`

732 --

733

734 DROP TABLE IF EXISTS `networks`;

735 SET @saved_cs_client = @@character_set_client;

736 SET character_set_client = utf8;

737 CREATE TABLE `networks` (

738 `ID` int(11) NOT NULL auto_increment,

739 `HARDWARE_ID` int(11) NOT NULL,

740 `DESCRIPTION` varchar(255) default NULL,

741 `TYPE` varchar(255) default NULL,

742 `TYPEMIB` varchar(255) default NULL,

743 `SPEED` varchar(255) default NULL,

744 `MACADDR` varchar(255) default NULL,

745 `STATUS` varchar(255) default NULL,

746 `IPADDRESS` varchar(255) default NULL,

747 `IPMASK` varchar(255) default NULL,

748 `IPGATEWAY` varchar(255) default NULL,

749 `IPSUBNET` varchar(255) default NULL,

750 `IPDHCP` varchar(255) default NULL,

751 PRIMARY KEY (`HARDWARE_ID`,`ID`),

752 KEY `MACADDR` (`MACADDR`),

753 KEY `IPSUBNET` (`IPSUBNET`),

754 KEY `ID` (`ID`)

755 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

756 SET character_set_client = @saved_cs_client;

757

758 --

759 -- Dumping data for table `networks`

760 --

761

762 LOCK TABLES `networks` WRITE;

763 /*!40000 ALTER TABLE `networks` DISABLE KEYS */;

764 /*!40000 ALTER TABLE `networks` ENABLE KEYS */;

765 UNLOCK TABLES;

766

767 --

768 -- Table structure for table `operators`

769 --

770

771 DROP TABLE IF EXISTS `operators`;

772 SET @saved_cs_client = @@character_set_client;

773 SET character_set_client = utf8;

774 CREATE TABLE `operators` (

775 `ID` varchar(255) NOT NULL default '',

776 `FIRSTNAME` varchar(255) default NULL,

777 `LASTNAME` varchar(255) default NULL,

778 `PASSWD` varchar(50) default NULL,

779 `ACCESSLVL` int(11) default NULL,

780 `COMMENTS` text,

781 PRIMARY KEY (`ID`)

782 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

783 SET character_set_client = @saved_cs_client;

784

785 --

786 -- Dumping data for table `operators`

787 --

788

789 LOCK TABLES `operators` WRITE;

790 /*!40000 ALTER TABLE `operators` DISABLE KEYS */;

791 INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account');

792 /*!40000 ALTER TABLE `operators` ENABLE KEYS */;

793 UNLOCK TABLES;

794

795 --

796 -- Table structure for table `ports`

797 --

798

799 DROP TABLE IF EXISTS `ports`;

800 SET @saved_cs_client = @@character_set_client;

801 SET character_set_client = utf8;

802 CREATE TABLE `ports` (

803 `ID` int(11) NOT NULL auto_increment,

804 `HARDWARE_ID` int(11) NOT NULL,

805 `TYPE` varchar(255) default NULL,

806 `NAME` varchar(255) default NULL,

807 `CAPTION` varchar(255) default NULL,

808 `DESCRIPTION` varchar(255) default NULL,

809 PRIMARY KEY (`HARDWARE_ID`,`ID`),

810 KEY `ID` (`ID`)

811 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

812 SET character_set_client = @saved_cs_client;

813

814 --

815 -- Dumping data for table `ports`

816 --

817

818 LOCK TABLES `ports` WRITE;

819 /*!40000 ALTER TABLE `ports` DISABLE KEYS */;

820 /*!40000 ALTER TABLE `ports` ENABLE KEYS */;

821 UNLOCK TABLES;

822

823 --

824 -- Table structure for table `printers`

825 --

826

827 DROP TABLE IF EXISTS `printers`;

828 SET @saved_cs_client = @@character_set_client;

829 SET character_set_client = utf8;

830 CREATE TABLE `printers` (

831 `ID` int(11) NOT NULL auto_increment,

832 `HARDWARE_ID` int(11) NOT NULL,

833 `NAME` varchar(255) default NULL,

834 `DRIVER` varchar(255) default NULL,

835 `PORT` varchar(255) default NULL,

836 PRIMARY KEY (`HARDWARE_ID`,`ID`),

837 KEY `ID` (`ID`)

838 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

839 SET character_set_client = @saved_cs_client;

840

841 --

842 -- Dumping data for table `printers`

843 --

844

845 LOCK TABLES `printers` WRITE;

846 /*!40000 ALTER TABLE `printers` DISABLE KEYS */;

847 /*!40000 ALTER TABLE `printers` ENABLE KEYS */;

848 UNLOCK TABLES;

849

850 --

851 -- Table structure for table `regconfig`

852 --

853

854 DROP TABLE IF EXISTS `regconfig`;

855 SET @saved_cs_client = @@character_set_client;

856 SET character_set_client = utf8;

857 CREATE TABLE `regconfig` (

858 `ID` int(11) NOT NULL auto_increment,

859 `NAME` varchar(255) default NULL,

860 `REGTREE` int(11) default NULL,

861 `REGKEY` text,

862 `REGVALUE` varchar(255) default NULL,

863 PRIMARY KEY (`ID`),

864 KEY `NAME` (`NAME`)

865 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

866 SET character_set_client = @saved_cs_client;

867

868 --

869 -- Dumping data for table `regconfig`

870 --

871

872 LOCK TABLES `regconfig` WRITE;

873 /*!40000 ALTER TABLE `regconfig` DISABLE KEYS */;

874 /*!40000 ALTER TABLE `regconfig` ENABLE KEYS */;

875 UNLOCK TABLES;

876

877 --

878 -- Table structure for table `registry`

879 --

880

881 DROP TABLE IF EXISTS `registry`;

882 SET @saved_cs_client = @@character_set_client;

883 SET character_set_client = utf8;

884 CREATE TABLE `registry` (

885 `ID` int(11) NOT NULL auto_increment,

886 `HARDWARE_ID` int(11) NOT NULL,

887 `NAME` varchar(255) default NULL,

888 `REGVALUE` varchar(255) default NULL,

889 PRIMARY KEY (`HARDWARE_ID`,`ID`),

890 KEY `NAME` (`NAME`),

891 KEY `ID` (`ID`)

892 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

893 SET character_set_client = @saved_cs_client;

894

895 --

896 -- Dumping data for table `registry`

897 --

898

899 LOCK TABLES `registry` WRITE;

900 /*!40000 ALTER TABLE `registry` DISABLE KEYS */;

901 /*!40000 ALTER TABLE `registry` ENABLE KEYS */;

902 UNLOCK TABLES;

903

904 --

905 -- Table structure for table `slots`

906 --

907

908 DROP TABLE IF EXISTS `slots`;

909 SET @saved_cs_client = @@character_set_client;

910 SET character_set_client = utf8;

911 CREATE TABLE `slots` (

912 `ID` int(11) NOT NULL auto_increment,

913 `HARDWARE_ID` int(11) NOT NULL,

914 `NAME` varchar(255) default NULL,

915 `DESCRIPTION` varchar(255) default NULL,

916 `DESIGNATION` varchar(255) default NULL,

917 `PURPOSE` varchar(255) default NULL,

918 `STATUS` varchar(255) default NULL,

919 `PSHARE` tinyint(4) default NULL,

920 PRIMARY KEY (`HARDWARE_ID`,`ID`),

921 KEY `ID` (`ID`)

922 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

923 SET character_set_client = @saved_cs_client;

924

925 --

926 -- Dumping data for table `slots`

927 --

928

929 LOCK TABLES `slots` WRITE;

930 /*!40000 ALTER TABLE `slots` DISABLE KEYS */;

931 /*!40000 ALTER TABLE `slots` ENABLE KEYS */;

932 UNLOCK TABLES;

933

934 --

935 -- Table structure for table `softwares`

936 --

937

938 DROP TABLE IF EXISTS `softwares`;

939 SET @saved_cs_client = @@character_set_client;

940 SET character_set_client = utf8;

941 CREATE TABLE `softwares` (

942 `ID` int(11) NOT NULL auto_increment,

943 `HARDWARE_ID` int(11) NOT NULL,

944 `PUBLISHER` varchar(255) default NULL,

945 `NAME` varchar(255) default NULL,

946 `VERSION` varchar(255) default NULL,

947 `FOLDER` text,

948 `COMMENTS` text,

949 `FILENAME` varchar(255) default NULL,

950 `FILESIZE` int(11) default '0',

951 `SOURCE` int(11) default NULL,

952 PRIMARY KEY (`HARDWARE_ID`,`ID`),

953 KEY `NAME` (`NAME`),

954 KEY `ID` (`ID`)

955 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

956 SET character_set_client = @saved_cs_client;

957

958 --

959 -- Dumping data for table `softwares`

960 --

961

962 LOCK TABLES `softwares` WRITE;

963 /*!40000 ALTER TABLE `softwares` DISABLE KEYS */;

964 /*!40000 ALTER TABLE `softwares` ENABLE KEYS */;

965 UNLOCK TABLES;

966

967 --

968 -- Table structure for table `sounds`

969 --

970

971 DROP TABLE IF EXISTS `sounds`;

972 SET @saved_cs_client = @@character_set_client;

973 SET character_set_client = utf8;

974 CREATE TABLE `sounds` (

975 `ID` int(11) NOT NULL auto_increment,

976 `HARDWARE_ID` int(11) NOT NULL,

977 `MANUFACTURER` varchar(255) default NULL,

978 `NAME` varchar(255) default NULL,

979 `DESCRIPTION` varchar(255) default NULL,

980 PRIMARY KEY (`HARDWARE_ID`,`ID`),

981 KEY `ID` (`ID`)

982 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

983 SET character_set_client = @saved_cs_client;

984

985 --

986 -- Dumping data for table `sounds`

987 --

988

989 LOCK TABLES `sounds` WRITE;

990 /*!40000 ALTER TABLE `sounds` DISABLE KEYS */;

991 /*!40000 ALTER TABLE `sounds` ENABLE KEYS */;

992 UNLOCK TABLES;

993

994 --

995 -- Table structure for table `storages`

996 --

997

998 DROP TABLE IF EXISTS `storages`;

999 SET @saved_cs_client = @@character_set_client;

1000 SET character_set_client = utf8;

1001 CREATE TABLE `storages` (

1002 `ID` int(11) NOT NULL auto_increment,

1003 `HARDWARE_ID` int(11) NOT NULL,

1004 `MANUFACTURER` varchar(255) default NULL,

1005 `NAME` varchar(255) default NULL,

1006 `MODEL` varchar(255) default NULL,

1007 `DESCRIPTION` varchar(255) default NULL,

1008 `TYPE` varchar(255) default NULL,

1009 `DISKSIZE` int(11) default NULL,

1010 PRIMARY KEY (`HARDWARE_ID`,`ID`),

1011 KEY `ID` (`ID`)

1012 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

1013 SET character_set_client = @saved_cs_client;

1014

1015 --

1016 -- Dumping data for table `storages`

1017 --

1018

1019 LOCK TABLES `storages` WRITE;

1020 /*!40000 ALTER TABLE `storages` DISABLE KEYS */;

1021 /*!40000 ALTER TABLE `storages` ENABLE KEYS */;

1022 UNLOCK TABLES;

1023

1024 --

1025 -- Table structure for table `subnet`

1026 --

1027

1028 DROP TABLE IF EXISTS `subnet`;

1029 SET @saved_cs_client = @@character_set_client;

1030 SET character_set_client = utf8;

1031 CREATE TABLE `subnet` (

1032 `NETID` varchar(15) NOT NULL,

1033 `NAME` varchar(255) default NULL,

1034 `ID` int(11) default NULL,

1035 `MASK` varchar(255) default NULL,

1036 PRIMARY KEY (`NETID`)

1037 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1038 SET character_set_client = @saved_cs_client;

1039

1040 --

1041 -- Dumping data for table `subnet`

1042 --

1043

1044 LOCK TABLES `subnet` WRITE;

1045 /*!40000 ALTER TABLE `subnet` DISABLE KEYS */;

1046 /*!40000 ALTER TABLE `subnet` ENABLE KEYS */;

1047 UNLOCK TABLES;

1048

1049 --

1050 -- Table structure for table `videos`

1051 --

1052

1053 DROP TABLE IF EXISTS `videos`;

1054 SET @saved_cs_client = @@character_set_client;

1055 SET character_set_client = utf8;

1056 CREATE TABLE `videos` (

1057 `ID` int(11) NOT NULL auto_increment,

1058 `HARDWARE_ID` int(11) NOT NULL,

1059 `NAME` varchar(255) default NULL,

1060 `CHIPSET` varchar(255) default NULL,

1061 `MEMORY` varchar(255) default NULL,

1062 `RESOLUTION` varchar(255) default NULL,

1063 PRIMARY KEY (`HARDWARE_ID`,`ID`),

1064 KEY `ID` (`ID`)

1065 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

1066 SET character_set_client = @saved_cs_client;

1067

1068 --

1069 -- Dumping data for table `videos`

1070 --

1071

1072 LOCK TABLES `videos` WRITE;

1073 /*!40000 ALTER TABLE `videos` DISABLE KEYS */;

1074 /*!40000 ALTER TABLE `videos` ENABLE KEYS */;

1075 UNLOCK TABLES;

1076 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

1077

1078 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

1079 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

1080 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

1081 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

1082 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

1083 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

1084 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

1085

1086 -- Dump completed on 2009-04-25 0:01:16