1create database ittest; 2use ittest; 3-- MySQL dump 10.13 Distrib 5.1.52, for redhat-linux-gnu (i386) 4-- 5-- Host: localhost Database: ittest 6-- ------------------------------------------------------ 7-- Server version 5.1.52 8 9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 12/*!40101 SET NAMES utf8 */; 13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 14/*!40103 SET TIME_ZONE='+00:00' */; 15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 19 20-- 21-- Table structure for table `aliases` 22-- 23 24DROP TABLE IF EXISTS `aliases`; 25/*!40101 SET @saved_cs_client = @@character_set_client */; 26/*!40101 SET character_set_client = utf8 */; 27CREATE TABLE `aliases` ( 28 `al_s` char(16) NOT NULL, 29 `co_s` char(16) DEFAULT NULL, 30 `co_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 31 PRIMARY KEY (`al_s`), 32 KEY `co_s` (`co_s`), 33 CONSTRAINT `co` FOREIGN KEY (`co_s`) REFERENCES `computers` (`co_s`) ON UPDATE CASCADE 34) ENGINE=InnoDB DEFAULT CHARSET=latin1; 35/*!40101 SET character_set_client = @saved_cs_client */; 36 37-- 38-- Dumping data for table `aliases` 39-- 40 41LOCK TABLES `aliases` WRITE; 42/*!40000 ALTER TABLE `aliases` DISABLE KEYS */; 43/*!40000 ALTER TABLE `aliases` ENABLE KEYS */; 44UNLOCK TABLES; 45 46-- 47-- Table structure for table `buildings` 48-- 49 50DROP TABLE IF EXISTS `buildings`; 51/*!40101 SET @saved_cs_client = @@character_set_client */; 52/*!40101 SET character_set_client = utf8 */; 53CREATE TABLE `buildings` ( 54 `gb_s` char(4) NOT NULL DEFAULT '', 55 `gb_l` char(64) DEFAULT NULL, 56 `gb_a1` char(64) DEFAULT NULL, 57 `gb_a2` char(64) DEFAULT NULL, 58 `gb_a3` char(64) DEFAULT NULL, 59 `gb_a4` char(64) DEFAULT NULL, 60 `gb_plz` char(32) DEFAULT '12345', 61 `gb_ort` char(64) DEFAULT 'Somewhere', 62 `gb_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 63 PRIMARY KEY (`gb_s`) 64) ENGINE=InnoDB DEFAULT CHARSET=latin1; 65/*!40101 SET character_set_client = @saved_cs_client */; 66 67-- 68-- Dumping data for table `buildings` 69-- 70 71LOCK TABLES `buildings` WRITE; 72/*!40000 ALTER TABLE `buildings` DISABLE KEYS */; 73INSERT INTO `buildings` VALUES ('A','House A','67 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:13'), 74('B','House B','69 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:25'), 75('C','House C','68 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:40'), 76('D','House D','70 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:53'); 77/*!40000 ALTER TABLE `buildings` ENABLE KEYS */; 78UNLOCK TABLES; 79 80-- 81-- Table structure for table `computers` 82-- 83 84DROP TABLE IF EXISTS `computers`; 85/*!40101 SET @saved_cs_client = @@character_set_client */; 86/*!40101 SET character_set_client = utf8 */; 87CREATE TABLE `computers` ( 88 `co_s` char(16) NOT NULL DEFAULT 'e__', 89 `us_s` char(12) DEFAULT NULL, 90 `co_ip` char(18) DEFAULT NULL, 91 `co_mc` char(18) DEFAULT NULL, 92 `ng_s` char(12) DEFAULT NULL, 93 `co_co` char(64) DEFAULT NULL, 94 `dc_s` char(16) DEFAULT NULL, 95 `dg_s` char(16) DEFAULT NULL, 96 `dd_n` char(16) DEFAULT NULL, 97 `gb_s` char(4) DEFAULT NULL, 98 `co_r` char(8) DEFAULT NULL, 99 `co_in` char(12) DEFAULT NULL, 100 `co_sn` char(64) DEFAULT NULL, 101 `co_dd` char(64) DEFAULT NULL, 102 `co_ff` int(11) DEFAULT '0', 103 `co_gu` int(11) DEFAULT '0', 104 `co_hi` char(32) DEFAULT NULL, 105 `co_ex` date DEFAULT NULL, 106 `co_nn` int(11) DEFAULT '0', 107 `co_na` int(11) DEFAULT '0', 108 `co_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 109 PRIMARY KEY (`co_s`), 110 KEY `us_s` (`us_s`), 111 KEY `co_ip` (`co_ip`), 112 KEY `ng_s` (`ng_s`), 113 KEY `dc_s` (`dc_s`), 114 KEY `dg_s` (`dg_s`), 115 KEY `dd_n` (`dd_n`), 116 KEY `gb_s` (`gb_s`), 117 KEY `co_r` (`co_r`), 118 KEY `co_in` (`co_in`), 119 KEY `co_sn` (`co_sn`), 120 CONSTRAINT `c7` FOREIGN KEY (`us_s`) REFERENCES `users` (`us_s`) ON UPDATE CASCADE, 121 CONSTRAINT `c8` FOREIGN KEY (`ng_s`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE, 122 CONSTRAINT `cg` FOREIGN KEY (`gb_s`) REFERENCES `buildings` (`gb_s`) ON UPDATE CASCADE, 123 CONSTRAINT `ch` FOREIGN KEY (`dc_s`) REFERENCES `dhcpclasses` (`dc_s`) ON UPDATE CASCADE, 124 CONSTRAINT `ck` FOREIGN KEY (`dg_s`) REFERENCES `dhcpgroups` (`dg_s`) ON UPDATE CASCADE, 125 CONSTRAINT `cn` FOREIGN KEY (`dd_n`) REFERENCES `patches` (`dd_n`) ON UPDATE CASCADE 126) ENGINE=InnoDB DEFAULT CHARSET=latin1; 127/*!40101 SET character_set_client = @saved_cs_client */; 128 129-- 130-- Dumping data for table `computers` 131-- 132 133LOCK TABLES `computers` WRITE; 134/*!40000 ALTER TABLE `computers` DISABLE KEYS */; 135INSERT INTO `computers` VALUES ('fs','blue','123.45.67.100','00:3D:2C:4F:ED:38',NULL,'File server',NULL,NULL,NULL,'A','0011','2010-0035',NULL,'nonsens.my-university.edu',0,0,NULL,NULL,0,0,'2012-03-03 16:39:04'), 136('fs-eth1','blue','123.45.67.200','00:3D:2C:4F:ED:39',NULL,'Secondary network interface fs',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nonsens.my-university.edu',0,4,NULL,NULL,0,0,'2012-03-03 16:39:07'), 137('l-0001',NULL,NULL,'2C:3A:FB:12:35:7F',NULL,'BYOD Laptop Gerald Grey','dc_stud',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,'2015-08-31',0,0,'2012-03-03 16:38:23'), 138('l-bl','blue','123.45.67.102','00:EA:BD:3F:2B:0D','no_t_ad','Laptop Betty Blue',NULL,NULL,'A/0/0126','A','0001','2012-0302',NULL,'nonsens.my-university.edu',0,0,NULL,NULL,0,0,'2012-03-03 16:26:21'), 139('l-or','orange',NULL,'00:EA:BD:3F:2B:0F',NULL,'BYOD Laptop Oliver Orange','dc_staff',NULL,NULL,'A','0002',NULL,NULL,NULL,0,1,NULL,NULL,0,0,'2012-03-03 16:38:11'), 140('pc-bl','blue','123.45.67.101','00:EA:BD:3F:2B:0C','no_t_ad','Desktop PC Betty Blue, administrator',NULL,NULL,'A/0/0125','A','0001','2012-0301','YFQ32545','nonsens.my-university.edu',0,0,NULL,NULL,0,0,'2012-03-03 16:25:06'), 141('pc-or','orange','123.45.67.103','00:EA:BD:3F:2B:0E','no_t_st','Desktop PC Oliver Orange',NULL,NULL,'A/0/0128','A','0002','2012-0013','GXQ34572','nonsens.my-university.edu',0,0,NULL,NULL,0,0,'2012-03-03 16:27:58'), 142('router','itdep','123.45.67.1',NULL,NULL,'Router, managed by IT department',NULL,NULL,NULL,NULL,NULL,'1010-0014',NULL,'nonsens.my-university.edu',0,2,NULL,NULL,0,0,'2012-03-03 16:39:02'), 143('vpn033',NULL,'98.76.54.33',NULL,'no_t_st','Dynamic IP address assigned by VPN system',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nonsens.my-university.edu',0,3,NULL,NULL,0,0,'2012-03-03 16:39:08'); 144/*!40000 ALTER TABLE `computers` ENABLE KEYS */; 145UNLOCK TABLES; 146 147-- 148-- Table structure for table `ddspeed` 149-- 150 151DROP TABLE IF EXISTS `ddspeed`; 152/*!40101 SET @saved_cs_client = @@character_set_client */; 153/*!40101 SET character_set_client = utf8 */; 154CREATE TABLE `ddspeed` ( 155 `sp_s` char(12) NOT NULL DEFAULT '', 156 `sp_l` char(64) DEFAULT NULL, 157 `sp_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 158 PRIMARY KEY (`sp_s`) 159) ENGINE=InnoDB DEFAULT CHARSET=latin1; 160/*!40101 SET character_set_client = @saved_cs_client */; 161 162-- 163-- Dumping data for table `ddspeed` 164-- 165 166LOCK TABLES `ddspeed` WRITE; 167/*!40000 ALTER TABLE `ddspeed` DISABLE KEYS */; 168INSERT INTO `ddspeed` VALUES ('10','10 MBit/s half-duplex','2012-03-03 15:45:08'), 169('100','100 MBit/s half-duplex','2012-03-03 15:45:08'), 170('100fd','100 MBit/s full-duplex','2012-03-03 15:45:08'), 171('10fd','10 MBit/s full-duplex','2012-03-03 15:45:08'), 172('auto','Autonegotiation','2012-03-03 15:45:08'); 173/*!40000 ALTER TABLE `ddspeed` ENABLE KEYS */; 174UNLOCK TABLES; 175 176-- 177-- Table structure for table `dhcpclasses` 178-- 179 180DROP TABLE IF EXISTS `dhcpclasses`; 181/*!40101 SET @saved_cs_client = @@character_set_client */; 182/*!40101 SET character_set_client = utf8 */; 183CREATE TABLE `dhcpclasses` ( 184 `dc_s` char(16) NOT NULL DEFAULT '-', 185 `dc_d` char(64) DEFAULT NULL, 186 `nw_ip` char(18) NOT NULL DEFAULT '0.0.0.0', 187 `dc_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 188 PRIMARY KEY (`dc_s`), 189 KEY `nw_ip` (`nw_ip`), 190 CONSTRAINT `cm` FOREIGN KEY (`nw_ip`) REFERENCES `networks` (`nw_ip`) ON UPDATE CASCADE 191) ENGINE=InnoDB DEFAULT CHARSET=latin1; 192/*!40101 SET character_set_client = @saved_cs_client */; 193 194-- 195-- Dumping data for table `dhcpclasses` 196-- 197 198LOCK TABLES `dhcpclasses` WRITE; 199/*!40000 ALTER TABLE `dhcpclasses` DISABLE KEYS */; 200INSERT INTO `dhcpclasses` VALUES ('dc_staff','Faculty staff','123.45.67.0','2012-03-03 16:01:29'), 201('dc_stud','Students','123.45.67.0','2012-03-03 16:01:18'); 202/*!40000 ALTER TABLE `dhcpclasses` ENABLE KEYS */; 203UNLOCK TABLES; 204 205-- 206-- Table structure for table `dhcpgroups` 207-- 208 209DROP TABLE IF EXISTS `dhcpgroups`; 210/*!40101 SET @saved_cs_client = @@character_set_client */; 211/*!40101 SET character_set_client = utf8 */; 212CREATE TABLE `dhcpgroups` ( 213 `dg_s` char(16) NOT NULL, 214 `dg_l` char(64) DEFAULT NULL, 215 `dg_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 216 PRIMARY KEY (`dg_s`) 217) ENGINE=InnoDB DEFAULT CHARSET=latin1; 218/*!40101 SET character_set_client = @saved_cs_client */; 219 220-- 221-- Dumping data for table `dhcpgroups` 222-- 223 224LOCK TABLES `dhcpgroups` WRITE; 225/*!40000 ALTER TABLE `dhcpgroups` DISABLE KEYS */; 226INSERT INTO `dhcpgroups` VALUES ('scili','Computers booting into Scientific Linux installation from networ','2012-03-03 16:03:19'); 227/*!40000 ALTER TABLE `dhcpgroups` ENABLE KEYS */; 228UNLOCK TABLES; 229 230-- 231-- Table structure for table `dhcpoptions` 232-- 233 234DROP TABLE IF EXISTS `dhcpoptions`; 235/*!40101 SET @saved_cs_client = @@character_set_client */; 236/*!40101 SET character_set_client = utf8 */; 237CREATE TABLE `dhcpoptions` ( 238 `do_pk` int(10) unsigned NOT NULL AUTO_INCREMENT, 239 `do_sc` enum('server','vlan','network','group','pool','host') DEFAULT 'server', 240 `do_sn` char(32) DEFAULT NULL, 241 `do_n` char(64) NOT NULL, 242 `do_v` char(64) NOT NULL, 243 `do_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 244 PRIMARY KEY (`do_pk`), 245 KEY `do_sc` (`do_sc`), 246 KEY `do_sn` (`do_sn`), 247 KEY `do_n` (`do_n`) 248) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; 249/*!40101 SET character_set_client = @saved_cs_client */; 250 251-- 252-- Dumping data for table `dhcpoptions` 253-- 254 255LOCK TABLES `dhcpoptions` WRITE; 256/*!40000 ALTER TABLE `dhcpoptions` DISABLE KEYS */; 257INSERT INTO `dhcpoptions` VALUES (1,'server',NULL,'log-facility','local1','2012-03-03 16:04:37'), 258(2,'server',NULL,'ddns-update-style','none','2012-03-03 16:04:46'), 259(3,'server',NULL,'default-lease-time','900','2012-03-03 16:04:54'), 260(4,'server',NULL,'max-lease-time','1200','2012-03-03 16:05:01'), 261(5,'server',NULL,'option:domain-name-servers','123.45.68.10, 123.45.68.11','2012-03-03 16:05:42'), 262(6,'server',NULL,'option:domain-name','nonsens.my-university.edu','2012-03-03 16:06:15'), 263(7,'group','scili','filename','/data/opt/linux/install','2012-03-03 16:06:32'), 264(8,'group','scili','next-server','123.45.67.100','2012-03-03 16:06:42'), 265(9,'group','scili','server-name','fs.nonsens.my-university.edu','2012-03-03 16:07:19'), 266(10,'server',NULL,'option:netbios-name-servers','123.45.67.100','2012-03-03 16:08:00'), 267(11,'server',NULL,'option:netbios-dd-server','123.45.67.100','2012-03-03 16:08:14'), 268(12,'server',NULL,'option:netbios-node-type','2','2012-03-03 16:08:35'), 269(13,'server',NULL,'authorative','yes','2012-03-03 16:08:57'); 270/*!40000 ALTER TABLE `dhcpoptions` ENABLE KEYS */; 271UNLOCK TABLES; 272 273-- 274-- Table structure for table `dhcppools` 275-- 276 277DROP TABLE IF EXISTS `dhcppools`; 278/*!40101 SET @saved_cs_client = @@character_set_client */; 279/*!40101 SET character_set_client = utf8 */; 280CREATE TABLE `dhcppools` ( 281 `dp_pk` int(10) unsigned NOT NULL AUTO_INCREMENT, 282 `dp_st` char(18) DEFAULT NULL, 283 `dp_en` char(18) DEFAULT NULL, 284 `nw_ip` char(18) DEFAULT NULL, 285 `dp_al` int(11) DEFAULT '0', 286 `dp_dn` int(11) DEFAULT '1', 287 `dc_s` char(16) DEFAULT NULL, 288 `dp_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 289 PRIMARY KEY (`dp_pk`), 290 KEY `nw_ip` (`nw_ip`), 291 KEY `cj` (`dc_s`), 292 CONSTRAINT `ci` FOREIGN KEY (`nw_ip`) REFERENCES `networks` (`nw_ip`) ON UPDATE CASCADE, 293 CONSTRAINT `cj` FOREIGN KEY (`dc_s`) REFERENCES `dhcpclasses` (`dc_s`) ON UPDATE CASCADE 294) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; 295/*!40101 SET character_set_client = @saved_cs_client */; 296 297-- 298-- Dumping data for table `dhcppools` 299-- 300 301LOCK TABLES `dhcppools` WRITE; 302/*!40000 ALTER TABLE `dhcppools` DISABLE KEYS */; 303INSERT INTO `dhcppools` VALUES (2,'123.45.67.10','123.45.67.19','123.45.67.0',0,1,'dc_staff','2012-03-03 16:01:35'), 304(3,'123.45.67.180','123.45.67.189','123.45.67.0',0,1,'dc_stud','2012-03-03 16:01:59'), 305(4,'192.168.1.180','192.168.1.189','192.168.1.0',1,0,NULL,'2012-03-03 16:02:23'); 306/*!40000 ALTER TABLE `dhcppools` ENABLE KEYS */; 307UNLOCK TABLES; 308 309-- 310-- Table structure for table `licenses` 311-- 312 313DROP TABLE IF EXISTS `licenses`; 314/*!40101 SET @saved_cs_client = @@character_set_client */; 315/*!40101 SET character_set_client = utf8 */; 316CREATE TABLE `licenses` ( 317 `li_pk` int(10) unsigned NOT NULL AUTO_INCREMENT, 318 `li_on` char(24) DEFAULT '', 319 `sw_s` char(16) DEFAULT NULL, 320 `us_s` char(12) DEFAULT NULL, 321 `co_s` char(16) DEFAULT NULL, 322 `lt_s` char(16) DEFAULT 's', 323 `li_no` char(64) DEFAULT NULL, 324 `sr_s` char(16) DEFAULT NULL, 325 `li_dd` char(16) DEFAULT NULL, 326 `li_nd` char(16) DEFAULT NULL, 327 `li_di` char(16) DEFAULT NULL, 328 `li_ni` char(16) DEFAULT NULL, 329 `li_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 330 PRIMARY KEY (`li_pk`), 331 KEY `li_on` (`li_on`), 332 KEY `sw_s` (`sw_s`), 333 KEY `us_s` (`us_s`), 334 KEY `co_s` (`co_s`), 335 KEY `lt_s` (`lt_s`), 336 KEY `sr_s` (`sr_s`), 337 KEY `li_dd` (`li_dd`), 338 KEY `li_nd` (`li_nd`), 339 KEY `li_di` (`li_di`), 340 KEY `li_ni` (`li_ni`), 341 CONSTRAINT `ca` FOREIGN KEY (`sw_s`) REFERENCES `swproducts` (`sw_s`) ON UPDATE CASCADE, 342 CONSTRAINT `cb` FOREIGN KEY (`sr_s`) REFERENCES `swresellers` (`sr_s`) ON UPDATE CASCADE, 343 CONSTRAINT `cc` FOREIGN KEY (`lt_s`) REFERENCES `licensetypes` (`lt_s`) ON UPDATE CASCADE, 344 CONSTRAINT `cd` FOREIGN KEY (`us_s`) REFERENCES `users` (`us_s`) ON UPDATE CASCADE, 345 CONSTRAINT `ce` FOREIGN KEY (`co_s`) REFERENCES `computers` (`co_s`) ON UPDATE CASCADE 346) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; 347/*!40101 SET character_set_client = @saved_cs_client */; 348 349-- 350-- Dumping data for table `licenses` 351-- 352 353LOCK TABLES `licenses` WRITE; 354/*!40000 ALTER TABLE `licenses` DISABLE KEYS */; 355INSERT INTO `licenses` VALUES (1,'B. Blue 005/2010 - 1 - 1','SMS:001-005-28','blue','pc-bl','s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:06'), 356(2,'B. Blue 005/2010 - 1 - 2','SMS:001-005-28','orange','pc-or','s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:45'), 357(3,'B. Blue 005/2010 - 1 - 3','SMS:001-005-28','blue','l-bl','s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:11'), 358(4,'B. Blue 005/2010 - 1 - 4','SMS:001-005-28','red',NULL,'s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-04 14:36:57'), 359(5,'B. Blue 005/2010 - 2 - 1','SMS:001-018-15','blue','pc-bl','s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:14'), 360(6,'B. Blue 005/2010 - 2 - 2','SMS:001-018-15','blue','pc-or','s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:17'), 361(7,'B. Blue 005/2010 - 2 - 3','SMS:001-018-15','red',NULL,'s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-04 14:36:59'), 362(8,'B. Blue 005/2010 - 2 - 4','SMS:001-018-15',NULL,NULL,'s',NULL,NULL,'3.5.10','0815','3.5.10','336905','2012-03-03 19:18:31'), 363(9,'O. Orange 008/2011','yasm-ms-48','orange','fs','flexlm-s5',NULL,NULL,'5.8.11','235579','10.8.11','88237361','2012-03-03 19:24:42'), 364(10,'O. Orange 008/2011','yasm-ms-48','orange','pc-bl','flexlm','Mathematic formulas are needed for the xyz project.',NULL,NULL,NULL,NULL,NULL,'2012-03-03 19:36:25'), 365(11,'O. Orange 008/2011','yasm-ms-48','orange','pc-or','flexlm',NULL,NULL,NULL,NULL,NULL,NULL,'2012-03-03 19:36:25'), 366(12,'O. Orange 008/2011','yasm-ms-48','orange','l-or','flexlm',NULL,NULL,NULL,NULL,NULL,NULL,'2012-03-03 19:36:25'); 367/*!40000 ALTER TABLE `licenses` ENABLE KEYS */; 368UNLOCK TABLES; 369 370-- 371-- Table structure for table `licensetypes` 372-- 373 374DROP TABLE IF EXISTS `licensetypes`; 375/*!40101 SET @saved_cs_client = @@character_set_client */; 376/*!40101 SET character_set_client = utf8 */; 377CREATE TABLE `licensetypes` ( 378 `lt_s` char(16) NOT NULL, 379 `lt_l` char(64) DEFAULT '', 380 `lt_i` int(11) DEFAULT '1', 381 `lt_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 382 PRIMARY KEY (`lt_s`), 383 KEY `lt_l` (`lt_l`) 384) ENGINE=InnoDB DEFAULT CHARSET=latin1; 385/*!40101 SET character_set_client = @saved_cs_client */; 386 387-- 388-- Dumping data for table `licensetypes` 389-- 390 391LOCK TABLES `licensetypes` WRITE; 392/*!40000 ALTER TABLE `licensetypes` DISABLE KEYS */; 393INSERT INTO `licensetypes` VALUES ('bsd','BSD style license',1,'2012-03-03 15:45:09'), 394('c','Single user concurrent license',1,'2012-03-03 15:45:09'), 395('flexlm','Flexlm controlled client installation',1,'2012-03-03 15:45:09'), 396('flexlm-s5','Flexlm license server, 5 users',5,'2012-03-03 15:45:09'), 397('gpl2','GNU General Public License, version 2',1,'2012-03-03 15:45:09'), 398('gpl3','GNU General Public License, version 3',1,'2012-03-03 15:45:09'), 399('lgpl2','GNU Lesser General Public License, version 2',1,'2012-03-03 15:45:09'), 400('lgpl3','GNU Lesser General Public License, version 3',1,'2012-03-03 15:45:09'), 401('s','Single user user license',1,'2012-03-03 15:45:09'); 402/*!40000 ALTER TABLE `licensetypes` ENABLE KEYS */; 403UNLOCK TABLES; 404 405-- 406-- Table structure for table `netgroups` 407-- 408 409DROP TABLE IF EXISTS `netgroups`; 410/*!40101 SET @saved_cs_client = @@character_set_client */; 411/*!40101 SET character_set_client = utf8 */; 412CREATE TABLE `netgroups` ( 413 `ng_s` char(12) NOT NULL DEFAULT '-', 414 `ng_l` char(64) DEFAULT '', 415 `ng_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 416 PRIMARY KEY (`ng_s`) 417) ENGINE=InnoDB DEFAULT CHARSET=latin1; 418/*!40101 SET character_set_client = @saved_cs_client */; 419 420-- 421-- Dumping data for table `netgroups` 422-- 423 424LOCK TABLES `netgroups` WRITE; 425/*!40000 ALTER TABLE `netgroups` DISABLE KEYS */; 426INSERT INTO `netgroups` VALUES ('no_p_hst','SMB access to staff member home directories','2012-03-03 16:13:59'), 427('no_p_ssh','SSH permission to file server','2012-03-03 16:13:56'), 428('no_t_ad','Administrators PC and laptop','2012-03-03 16:14:01'), 429('no_t_lab','Laboratory and classroom PCs','2012-03-03 16:10:30'), 430('no_t_st','Staff member PCs','2012-03-03 16:10:15'); 431/*!40000 ALTER TABLE `netgroups` ENABLE KEYS */; 432UNLOCK TABLES; 433 434-- 435-- Table structure for table `networks` 436-- 437 438DROP TABLE IF EXISTS `networks`; 439/*!40101 SET @saved_cs_client = @@character_set_client */; 440/*!40101 SET character_set_client = utf8 */; 441CREATE TABLE `networks` ( 442 `nw_ip` char(18) NOT NULL DEFAULT '', 443 `nw_ma` char(18) DEFAULT '', 444 `nw_gw` char(18) DEFAULT '', 445 `nw_bc` char(18) DEFAULT '', 446 `vl_s` char(8) DEFAULT '', 447 `nw_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 448 PRIMARY KEY (`nw_ip`), 449 KEY `vl_s` (`vl_s`), 450 CONSTRAINT `cf` FOREIGN KEY (`vl_s`) REFERENCES `vlans` (`vl_s`) ON UPDATE CASCADE 451) ENGINE=InnoDB DEFAULT CHARSET=latin1; 452/*!40101 SET character_set_client = @saved_cs_client */; 453 454-- 455-- Dumping data for table `networks` 456-- 457 458LOCK TABLES `networks` WRITE; 459/*!40000 ALTER TABLE `networks` DISABLE KEYS */; 460INSERT INTO `networks` VALUES ('123.45.67.0','255.255.255.0','123.45.67.1','123.45.67.255','200','2012-03-03 15:59:13'), 461('192.168.1.0','255.255.255.0','192.168.1.1','192.168.101.255','200','2012-03-03 15:59:39'), 462('192.168.2.0','255.255.255.0','192.168.2.1','192.168.2.255','300','2012-03-03 15:59:56'), 463('98.76.54.0','255.255.255.0','98.76.54.1','98.76.54.255','200','2012-03-03 16:42:02'); 464/*!40000 ALTER TABLE `networks` ENABLE KEYS */; 465UNLOCK TABLES; 466 467-- 468-- Table structure for table `ngdeps` 469-- 470 471DROP TABLE IF EXISTS `ngdeps`; 472/*!40101 SET @saved_cs_client = @@character_set_client */; 473/*!40101 SET character_set_client = utf8 */; 474CREATE TABLE `ngdeps` ( 475 `nd_pk` int(10) unsigned NOT NULL AUTO_INCREMENT, 476 `nd_p` char(12) DEFAULT NULL, 477 `nd_c` char(12) DEFAULT NULL, 478 `nd_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 479 PRIMARY KEY (`nd_pk`), 480 KEY `nd_p` (`nd_p`), 481 KEY `nd_c` (`nd_c`), 482 CONSTRAINT `c5` FOREIGN KEY (`nd_p`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE, 483 CONSTRAINT `c6` FOREIGN KEY (`nd_c`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE 484) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; 485/*!40101 SET character_set_client = @saved_cs_client */; 486 487-- 488-- Dumping data for table `ngdeps` 489-- 490 491LOCK TABLES `ngdeps` WRITE; 492/*!40000 ALTER TABLE `ngdeps` DISABLE KEYS */; 493INSERT INTO `ngdeps` VALUES (1,'no_p_hst','no_p_ssh','2012-03-03 16:12:46'), 494(3,'no_p_ssh','no_t_ad','2012-03-03 16:13:09'), 495(5,'no_p_hst','no_t_st','2012-03-03 16:13:48'); 496/*!40000 ALTER TABLE `ngdeps` ENABLE KEYS */; 497UNLOCK TABLES; 498 499-- 500-- Table structure for table `patches` 501-- 502 503DROP TABLE IF EXISTS `patches`; 504/*!40101 SET @saved_cs_client = @@character_set_client */; 505/*!40101 SET character_set_client = utf8 */; 506CREATE TABLE `patches` ( 507 `dd_n` char(16) NOT NULL DEFAULT '', 508 `sp_s` char(12) DEFAULT 'auto', 509 `vl_s` char(8) DEFAULT '-', 510 `dd_p` char(16) DEFAULT NULL, 511 `gb_s` char(4) DEFAULT '', 512 `dd_r` char(8) DEFAULT NULL, 513 `dd_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 514 PRIMARY KEY (`dd_n`), 515 KEY `sp_s` (`sp_s`), 516 KEY `vl_s` (`vl_s`), 517 KEY `gb_s` (`gb_s`), 518 CONSTRAINT `c2` FOREIGN KEY (`sp_s`) REFERENCES `ddspeed` (`sp_s`) ON UPDATE CASCADE, 519 CONSTRAINT `c3` FOREIGN KEY (`vl_s`) REFERENCES `vlans` (`vl_s`) ON UPDATE CASCADE, 520 CONSTRAINT `c4` FOREIGN KEY (`gb_s`) REFERENCES `buildings` (`gb_s`) ON UPDATE CASCADE 521) ENGINE=InnoDB DEFAULT CHARSET=latin1; 522/*!40101 SET character_set_client = @saved_cs_client */; 523 524-- 525-- Dumping data for table `patches` 526-- 527 528LOCK TABLES `patches` WRITE; 529/*!40000 ALTER TABLE `patches` DISABLE KEYS */; 530INSERT INTO `patches` VALUES ('A/0/0125','auto','200','G-12','A','0001','2012-03-03 15:57:08'), 531('A/0/0126','auto','200','G-13','A','0001','2012-03-03 15:57:19'), 532('A/0/0127','auto','200','G-14','A','0001','2012-03-03 15:57:32'), 533('A/0/0128','auto','200','G-15','A','0002','2012-03-03 15:57:43'), 534('A/0/0129','auto','200','G-16','A','0002','2012-03-03 15:58:29'), 535('A/0/0130','auto','200','G-17','A','0002','2012-03-03 15:58:31'), 536('A/0/0131','auto','200','G-18','A','0003','2012-03-03 15:58:34'); 537/*!40000 ALTER TABLE `patches` ENABLE KEYS */; 538UNLOCK TABLES; 539 540-- 541-- Table structure for table `swmanufacturers` 542-- 543 544DROP TABLE IF EXISTS `swmanufacturers`; 545/*!40101 SET @saved_cs_client = @@character_set_client */; 546/*!40101 SET character_set_client = utf8 */; 547CREATE TABLE `swmanufacturers` ( 548 `sm_s` char(16) NOT NULL, 549 `sm_l` char(64) DEFAULT '', 550 `sm_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 551 PRIMARY KEY (`sm_s`) 552) ENGINE=InnoDB DEFAULT CHARSET=latin1; 553/*!40101 SET character_set_client = @saved_cs_client */; 554 555-- 556-- Dumping data for table `swmanufacturers` 557-- 558 559LOCK TABLES `swmanufacturers` WRITE; 560/*!40000 ALTER TABLE `swmanufacturers` DISABLE KEYS */; 561INSERT INTO `swmanufacturers` VALUES ('sms','SmartSoft','2012-03-03 16:15:10'), 562('yasm','Yet Another Software Manufacturer','2012-03-03 16:15:29'); 563/*!40000 ALTER TABLE `swmanufacturers` ENABLE KEYS */; 564UNLOCK TABLES; 565 566-- 567-- Table structure for table `swproducts` 568-- 569 570DROP TABLE IF EXISTS `swproducts`; 571/*!40101 SET @saved_cs_client = @@character_set_client */; 572/*!40101 SET character_set_client = utf8 */; 573CREATE TABLE `swproducts` ( 574 `sw_s` char(16) NOT NULL, 575 `sw_l` char(64) DEFAULT '', 576 `sm_s` char(16) DEFAULT '', 577 `sw_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 578 PRIMARY KEY (`sw_s`), 579 KEY `sm_s` (`sm_s`), 580 CONSTRAINT `c9` FOREIGN KEY (`sm_s`) REFERENCES `swmanufacturers` (`sm_s`) ON UPDATE CASCADE 581) ENGINE=InnoDB DEFAULT CHARSET=latin1; 582/*!40101 SET character_set_client = @saved_cs_client */; 583 584-- 585-- Dumping data for table `swproducts` 586-- 587 588LOCK TABLES `swproducts` WRITE; 589/*!40000 ALTER TABLE `swproducts` DISABLE KEYS */; 590INSERT INTO `swproducts` VALUES ('SMS:001-005-28','Fine Desktop 2.8','sms','2012-03-03 16:17:53'), 591('SMS:001-005-29','Fine Desktop 2.9','sms','2012-03-03 16:18:03'), 592('SMS:001-018-15','Cool Text Editor 1.5','sms','2012-03-03 16:55:08'), 593('SMS:001-018-16','Cool Text Editor 1.6','sms','2012-03-03 16:55:20'), 594('yasm-ms-47','Mathematic Formula 4.7','yasm','2012-03-03 16:18:12'), 595('yasm-ms-48','Mathematic Formula 4.8','yasm','2012-03-03 16:18:17'), 596('yasm-ms-48u','Mathematic Formula 4.8 UPGRADE','yasm','2012-03-03 16:18:23'); 597/*!40000 ALTER TABLE `swproducts` ENABLE KEYS */; 598UNLOCK TABLES; 599 600-- 601-- Table structure for table `swresellers` 602-- 603 604DROP TABLE IF EXISTS `swresellers`; 605/*!40101 SET @saved_cs_client = @@character_set_client */; 606/*!40101 SET character_set_client = utf8 */; 607CREATE TABLE `swresellers` ( 608 `sr_s` char(16) NOT NULL, 609 `sr_l` char(64) DEFAULT '', 610 `sr_a1` char(64) DEFAULT NULL, 611 `sr_a2` char(64) DEFAULT NULL, 612 `sr_a3` char(64) DEFAULT NULL, 613 `sr_a4` char(64) DEFAULT NULL, 614 `sr_plz` char(8) DEFAULT NULL, 615 `sr_ort` char(64) DEFAULT NULL, 616 `sr_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 617 PRIMARY KEY (`sr_s`) 618) ENGINE=InnoDB DEFAULT CHARSET=latin1; 619/*!40101 SET character_set_client = @saved_cs_client */; 620 621-- 622-- Dumping data for table `swresellers` 623-- 624 625LOCK TABLES `swresellers` WRITE; 626/*!40000 ALTER TABLE `swresellers` DISABLE KEYS */; 627/*!40000 ALTER TABLE `swresellers` ENABLE KEYS */; 628UNLOCK TABLES; 629 630-- 631-- Table structure for table `users` 632-- 633 634DROP TABLE IF EXISTS `users`; 635/*!40101 SET @saved_cs_client = @@character_set_client */; 636/*!40101 SET character_set_client = utf8 */; 637CREATE TABLE `users` ( 638 `us_s` char(12) NOT NULL DEFAULT '-', 639 `us_t` char(32) DEFAULT NULL, 640 `us_sn` char(64) DEFAULT '', 641 `us_fn` char(64) DEFAULT '', 642 `us_em` char(64) DEFAULT NULL, 643 `us_ko` char(16) DEFAULT NULL, 644 `us_se` char(16) DEFAULT NULL, 645 `us_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 646 PRIMARY KEY (`us_s`) 647) ENGINE=InnoDB DEFAULT CHARSET=latin1; 648/*!40101 SET character_set_client = @saved_cs_client */; 649 650-- 651-- Dumping data for table `users` 652-- 653 654LOCK TABLES `users` WRITE; 655/*!40000 ALTER TABLE `users` DISABLE KEYS */; 656INSERT INTO `users` VALUES ('blue',NULL,'Betty','Blue','b.blue@my-university.edu','70211','1302','2012-03-03 15:51:36'), 657('itdep',NULL,'','IT department',NULL,NULL,NULL,'2012-03-03 16:30:10'), 658('orange','Prof.','Oliver','Orange','o.orange@my-university.edu','70210','1101','2012-03-03 15:50:30'), 659('red','Dr.','Robert','Red','r.red@my-university.edu','70310','1401','2012-03-03 15:50:57'), 660('white',NULL,'Walther','White','w.white@my-university.edu','70212','1005','2012-03-03 15:52:01'); 661/*!40000 ALTER TABLE `users` ENABLE KEYS */; 662UNLOCK TABLES; 663 664-- 665-- Table structure for table `vlans` 666-- 667 668DROP TABLE IF EXISTS `vlans`; 669/*!40101 SET @saved_cs_client = @@character_set_client */; 670/*!40101 SET character_set_client = utf8 */; 671CREATE TABLE `vlans` ( 672 `vl_s` char(8) NOT NULL DEFAULT '', 673 `vl_l` char(64) DEFAULT 'my network', 674 `vl_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 675 PRIMARY KEY (`vl_s`) 676) ENGINE=InnoDB DEFAULT CHARSET=latin1; 677/*!40101 SET character_set_client = @saved_cs_client */; 678 679-- 680-- Dumping data for table `vlans` 681-- 682 683LOCK TABLES `vlans` WRITE; 684/*!40000 ALTER TABLE `vlans` DISABLE KEYS */; 685INSERT INTO `vlans` VALUES ('1','IT department, internal service controller network','2012-03-03 15:56:24'), 686('100','IT department','2012-03-03 15:55:24'), 687('200','Engineering faculty','2012-03-03 15:55:51'), 688('300','Nonsens faculty','2012-03-03 15:55:59'); 689/*!40000 ALTER TABLE `vlans` ENABLE KEYS */; 690UNLOCK TABLES; 691/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 692 693/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 694/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 695/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 696/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 697/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 698/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 699/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 700 701-- Dump completed on 2012-03-04 16:12:14 702