create database ittest;
use ittest;
-- MySQL dump 10.13  Distrib 5.1.52, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: ittest
-- ------------------------------------------------------
-- Server version	5.1.52

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `aliases`
--

DROP TABLE IF EXISTS `aliases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aliases` (
  `al_s` char(16) NOT NULL,
  `co_s` char(16) DEFAULT NULL,
  `co_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`al_s`),
  KEY `co_s` (`co_s`),
  CONSTRAINT `co` FOREIGN KEY (`co_s`) REFERENCES `computers` (`co_s`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aliases`
--

LOCK TABLES `aliases` WRITE;
/*!40000 ALTER TABLE `aliases` DISABLE KEYS */;
/*!40000 ALTER TABLE `aliases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `buildings`
--

DROP TABLE IF EXISTS `buildings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buildings` (
  `gb_s` char(4) NOT NULL DEFAULT '',
  `gb_l` char(64) DEFAULT NULL,
  `gb_a1` char(64) DEFAULT NULL,
  `gb_a2` char(64) DEFAULT NULL,
  `gb_a3` char(64) DEFAULT NULL,
  `gb_a4` char(64) DEFAULT NULL,
  `gb_plz` char(32) DEFAULT '12345',
  `gb_ort` char(64) DEFAULT 'Somewhere',
  `gb_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`gb_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `buildings`
--

LOCK TABLES `buildings` WRITE;
/*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
INSERT INTO `buildings` VALUES ('A','House A','67 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:13'),
('B','House B','69 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:25'),
('C','House C','68 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:40'),
('D','House D','70 Campus Avenue',NULL,NULL,NULL,'12345','Smalltown','2012-03-03 15:49:53');
/*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `computers`
--

DROP TABLE IF EXISTS `computers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `computers` (
  `co_s` char(16) NOT NULL DEFAULT 'e__',
  `us_s` char(12) DEFAULT NULL,
  `co_ip` char(18) DEFAULT NULL,
  `co_mc` char(18) DEFAULT NULL,
  `ng_s` char(12) DEFAULT NULL,
  `co_co` char(64) DEFAULT NULL,
  `dc_s` char(16) DEFAULT NULL,
  `dg_s` char(16) DEFAULT NULL,
  `dd_n` char(16) DEFAULT NULL,
  `gb_s` char(4) DEFAULT NULL,
  `co_r` char(8) DEFAULT NULL,
  `co_in` char(12) DEFAULT NULL,
  `co_sn` char(64) DEFAULT NULL,
  `co_dd` char(64) DEFAULT NULL,
  `co_ff` int(11) DEFAULT '0',
  `co_gu` int(11) DEFAULT '0',
  `co_hi` char(32) DEFAULT NULL,
  `co_ex` date DEFAULT NULL,
  `co_nn` int(11) DEFAULT '0',
  `co_na` int(11) DEFAULT '0',
  `co_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`co_s`),
  KEY `us_s` (`us_s`),
  KEY `co_ip` (`co_ip`),
  KEY `ng_s` (`ng_s`),
  KEY `dc_s` (`dc_s`),
  KEY `dg_s` (`dg_s`),
  KEY `dd_n` (`dd_n`),
  KEY `gb_s` (`gb_s`),
  KEY `co_r` (`co_r`),
  KEY `co_in` (`co_in`),
  KEY `co_sn` (`co_sn`),
  CONSTRAINT `c7` FOREIGN KEY (`us_s`) REFERENCES `users` (`us_s`) ON UPDATE CASCADE,
  CONSTRAINT `c8` FOREIGN KEY (`ng_s`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE,
  CONSTRAINT `cg` FOREIGN KEY (`gb_s`) REFERENCES `buildings` (`gb_s`) ON UPDATE CASCADE,
  CONSTRAINT `ch` FOREIGN KEY (`dc_s`) REFERENCES `dhcpclasses` (`dc_s`) ON UPDATE CASCADE,
  CONSTRAINT `ck` FOREIGN KEY (`dg_s`) REFERENCES `dhcpgroups` (`dg_s`) ON UPDATE CASCADE,
  CONSTRAINT `cn` FOREIGN KEY (`dd_n`) REFERENCES `patches` (`dd_n`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `computers`
--

LOCK TABLES `computers` WRITE;
/*!40000 ALTER TABLE `computers` DISABLE KEYS */;
INSERT 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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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');
/*!40000 ALTER TABLE `computers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ddspeed`
--

DROP TABLE IF EXISTS `ddspeed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ddspeed` (
  `sp_s` char(12) NOT NULL DEFAULT '',
  `sp_l` char(64) DEFAULT NULL,
  `sp_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sp_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ddspeed`
--

LOCK TABLES `ddspeed` WRITE;
/*!40000 ALTER TABLE `ddspeed` DISABLE KEYS */;
INSERT INTO `ddspeed` VALUES ('10','10 MBit/s half-duplex','2012-03-03 15:45:08'),
('100','100 MBit/s half-duplex','2012-03-03 15:45:08'),
('100fd','100 MBit/s full-duplex','2012-03-03 15:45:08'),
('10fd','10 MBit/s full-duplex','2012-03-03 15:45:08'),
('auto','Autonegotiation','2012-03-03 15:45:08');
/*!40000 ALTER TABLE `ddspeed` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dhcpclasses`
--

DROP TABLE IF EXISTS `dhcpclasses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dhcpclasses` (
  `dc_s` char(16) NOT NULL DEFAULT '-',
  `dc_d` char(64) DEFAULT NULL,
  `nw_ip` char(18) NOT NULL DEFAULT '0.0.0.0',
  `dc_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dc_s`),
  KEY `nw_ip` (`nw_ip`),
  CONSTRAINT `cm` FOREIGN KEY (`nw_ip`) REFERENCES `networks` (`nw_ip`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dhcpclasses`
--

LOCK TABLES `dhcpclasses` WRITE;
/*!40000 ALTER TABLE `dhcpclasses` DISABLE KEYS */;
INSERT INTO `dhcpclasses` VALUES ('dc_staff','Faculty staff','123.45.67.0','2012-03-03 16:01:29'),
('dc_stud','Students','123.45.67.0','2012-03-03 16:01:18');
/*!40000 ALTER TABLE `dhcpclasses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dhcpgroups`
--

DROP TABLE IF EXISTS `dhcpgroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dhcpgroups` (
  `dg_s` char(16) NOT NULL,
  `dg_l` char(64) DEFAULT NULL,
  `dg_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dg_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dhcpgroups`
--

LOCK TABLES `dhcpgroups` WRITE;
/*!40000 ALTER TABLE `dhcpgroups` DISABLE KEYS */;
INSERT INTO `dhcpgroups` VALUES ('scili','Computers booting into Scientific Linux installation from networ','2012-03-03 16:03:19');
/*!40000 ALTER TABLE `dhcpgroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dhcpoptions`
--

DROP TABLE IF EXISTS `dhcpoptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dhcpoptions` (
  `do_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `do_sc` enum('server','vlan','network','group','pool','host') DEFAULT 'server',
  `do_sn` char(32) DEFAULT NULL,
  `do_n` char(64) NOT NULL,
  `do_v` char(64) NOT NULL,
  `do_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`do_pk`),
  KEY `do_sc` (`do_sc`),
  KEY `do_sn` (`do_sn`),
  KEY `do_n` (`do_n`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dhcpoptions`
--

LOCK TABLES `dhcpoptions` WRITE;
/*!40000 ALTER TABLE `dhcpoptions` DISABLE KEYS */;
INSERT INTO `dhcpoptions` VALUES (1,'server',NULL,'log-facility','local1','2012-03-03 16:04:37'),
(2,'server',NULL,'ddns-update-style','none','2012-03-03 16:04:46'),
(3,'server',NULL,'default-lease-time','900','2012-03-03 16:04:54'),
(4,'server',NULL,'max-lease-time','1200','2012-03-03 16:05:01'),
(5,'server',NULL,'option:domain-name-servers','123.45.68.10, 123.45.68.11','2012-03-03 16:05:42'),
(6,'server',NULL,'option:domain-name','nonsens.my-university.edu','2012-03-03 16:06:15'),
(7,'group','scili','filename','/data/opt/linux/install','2012-03-03 16:06:32'),
(8,'group','scili','next-server','123.45.67.100','2012-03-03 16:06:42'),
(9,'group','scili','server-name','fs.nonsens.my-university.edu','2012-03-03 16:07:19'),
(10,'server',NULL,'option:netbios-name-servers','123.45.67.100','2012-03-03 16:08:00'),
(11,'server',NULL,'option:netbios-dd-server','123.45.67.100','2012-03-03 16:08:14'),
(12,'server',NULL,'option:netbios-node-type','2','2012-03-03 16:08:35'),
(13,'server',NULL,'authorative','yes','2012-03-03 16:08:57');
/*!40000 ALTER TABLE `dhcpoptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dhcppools`
--

DROP TABLE IF EXISTS `dhcppools`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dhcppools` (
  `dp_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dp_st` char(18) DEFAULT NULL,
  `dp_en` char(18) DEFAULT NULL,
  `nw_ip` char(18) DEFAULT NULL,
  `dp_al` int(11) DEFAULT '0',
  `dp_dn` int(11) DEFAULT '1',
  `dc_s` char(16) DEFAULT NULL,
  `dp_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dp_pk`),
  KEY `nw_ip` (`nw_ip`),
  KEY `cj` (`dc_s`),
  CONSTRAINT `ci` FOREIGN KEY (`nw_ip`) REFERENCES `networks` (`nw_ip`) ON UPDATE CASCADE,
  CONSTRAINT `cj` FOREIGN KEY (`dc_s`) REFERENCES `dhcpclasses` (`dc_s`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dhcppools`
--

LOCK TABLES `dhcppools` WRITE;
/*!40000 ALTER TABLE `dhcppools` DISABLE KEYS */;
INSERT 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'),
(3,'123.45.67.180','123.45.67.189','123.45.67.0',0,1,'dc_stud','2012-03-03 16:01:59'),
(4,'192.168.1.180','192.168.1.189','192.168.1.0',1,0,NULL,'2012-03-03 16:02:23');
/*!40000 ALTER TABLE `dhcppools` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `licenses`
--

DROP TABLE IF EXISTS `licenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `licenses` (
  `li_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `li_on` char(24) DEFAULT '',
  `sw_s` char(16) DEFAULT NULL,
  `us_s` char(12) DEFAULT NULL,
  `co_s` char(16) DEFAULT NULL,
  `lt_s` char(16) DEFAULT 's',
  `li_no` char(64) DEFAULT NULL,
  `sr_s` char(16) DEFAULT NULL,
  `li_dd` char(16) DEFAULT NULL,
  `li_nd` char(16) DEFAULT NULL,
  `li_di` char(16) DEFAULT NULL,
  `li_ni` char(16) DEFAULT NULL,
  `li_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`li_pk`),
  KEY `li_on` (`li_on`),
  KEY `sw_s` (`sw_s`),
  KEY `us_s` (`us_s`),
  KEY `co_s` (`co_s`),
  KEY `lt_s` (`lt_s`),
  KEY `sr_s` (`sr_s`),
  KEY `li_dd` (`li_dd`),
  KEY `li_nd` (`li_nd`),
  KEY `li_di` (`li_di`),
  KEY `li_ni` (`li_ni`),
  CONSTRAINT `ca` FOREIGN KEY (`sw_s`) REFERENCES `swproducts` (`sw_s`) ON UPDATE CASCADE,
  CONSTRAINT `cb` FOREIGN KEY (`sr_s`) REFERENCES `swresellers` (`sr_s`) ON UPDATE CASCADE,
  CONSTRAINT `cc` FOREIGN KEY (`lt_s`) REFERENCES `licensetypes` (`lt_s`) ON UPDATE CASCADE,
  CONSTRAINT `cd` FOREIGN KEY (`us_s`) REFERENCES `users` (`us_s`) ON UPDATE CASCADE,
  CONSTRAINT `ce` FOREIGN KEY (`co_s`) REFERENCES `computers` (`co_s`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `licenses`
--

LOCK TABLES `licenses` WRITE;
/*!40000 ALTER TABLE `licenses` DISABLE KEYS */;
INSERT 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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(11,'O. Orange 008/2011','yasm-ms-48','orange','pc-or','flexlm',NULL,NULL,NULL,NULL,NULL,NULL,'2012-03-03 19:36:25'),
(12,'O. Orange 008/2011','yasm-ms-48','orange','l-or','flexlm',NULL,NULL,NULL,NULL,NULL,NULL,'2012-03-03 19:36:25');
/*!40000 ALTER TABLE `licenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `licensetypes`
--

DROP TABLE IF EXISTS `licensetypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `licensetypes` (
  `lt_s` char(16) NOT NULL,
  `lt_l` char(64) DEFAULT '',
  `lt_i` int(11) DEFAULT '1',
  `lt_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`lt_s`),
  KEY `lt_l` (`lt_l`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `licensetypes`
--

LOCK TABLES `licensetypes` WRITE;
/*!40000 ALTER TABLE `licensetypes` DISABLE KEYS */;
INSERT INTO `licensetypes` VALUES ('bsd','BSD style license',1,'2012-03-03 15:45:09'),
('c','Single user concurrent license',1,'2012-03-03 15:45:09'),
('flexlm','Flexlm controlled client installation',1,'2012-03-03 15:45:09'),
('flexlm-s5','Flexlm license server, 5 users',5,'2012-03-03 15:45:09'),
('gpl2','GNU General Public License, version 2',1,'2012-03-03 15:45:09'),
('gpl3','GNU General Public License, version 3',1,'2012-03-03 15:45:09'),
('lgpl2','GNU Lesser General Public License, version 2',1,'2012-03-03 15:45:09'),
('lgpl3','GNU Lesser General Public License, version 3',1,'2012-03-03 15:45:09'),
('s','Single user user license',1,'2012-03-03 15:45:09');
/*!40000 ALTER TABLE `licensetypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netgroups`
--

DROP TABLE IF EXISTS `netgroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netgroups` (
  `ng_s` char(12) NOT NULL DEFAULT '-',
  `ng_l` char(64) DEFAULT '',
  `ng_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ng_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netgroups`
--

LOCK TABLES `netgroups` WRITE;
/*!40000 ALTER TABLE `netgroups` DISABLE KEYS */;
INSERT INTO `netgroups` VALUES ('no_p_hst','SMB access to staff member home directories','2012-03-03 16:13:59'),
('no_p_ssh','SSH permission to file server','2012-03-03 16:13:56'),
('no_t_ad','Administrators PC and laptop','2012-03-03 16:14:01'),
('no_t_lab','Laboratory and classroom PCs','2012-03-03 16:10:30'),
('no_t_st','Staff member PCs','2012-03-03 16:10:15');
/*!40000 ALTER TABLE `netgroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `networks`
--

DROP TABLE IF EXISTS `networks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `networks` (
  `nw_ip` char(18) NOT NULL DEFAULT '',
  `nw_ma` char(18) DEFAULT '',
  `nw_gw` char(18) DEFAULT '',
  `nw_bc` char(18) DEFAULT '',
  `vl_s` char(8) DEFAULT '',
  `nw_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`nw_ip`),
  KEY `vl_s` (`vl_s`),
  CONSTRAINT `cf` FOREIGN KEY (`vl_s`) REFERENCES `vlans` (`vl_s`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `networks`
--

LOCK TABLES `networks` WRITE;
/*!40000 ALTER TABLE `networks` DISABLE KEYS */;
INSERT 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'),
('192.168.1.0','255.255.255.0','192.168.1.1','192.168.101.255','200','2012-03-03 15:59:39'),
('192.168.2.0','255.255.255.0','192.168.2.1','192.168.2.255','300','2012-03-03 15:59:56'),
('98.76.54.0','255.255.255.0','98.76.54.1','98.76.54.255','200','2012-03-03 16:42:02');
/*!40000 ALTER TABLE `networks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ngdeps`
--

DROP TABLE IF EXISTS `ngdeps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ngdeps` (
  `nd_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nd_p` char(12) DEFAULT NULL,
  `nd_c` char(12) DEFAULT NULL,
  `nd_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`nd_pk`),
  KEY `nd_p` (`nd_p`),
  KEY `nd_c` (`nd_c`),
  CONSTRAINT `c5` FOREIGN KEY (`nd_p`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE,
  CONSTRAINT `c6` FOREIGN KEY (`nd_c`) REFERENCES `netgroups` (`ng_s`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ngdeps`
--

LOCK TABLES `ngdeps` WRITE;
/*!40000 ALTER TABLE `ngdeps` DISABLE KEYS */;
INSERT INTO `ngdeps` VALUES (1,'no_p_hst','no_p_ssh','2012-03-03 16:12:46'),
(3,'no_p_ssh','no_t_ad','2012-03-03 16:13:09'),
(5,'no_p_hst','no_t_st','2012-03-03 16:13:48');
/*!40000 ALTER TABLE `ngdeps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patches`
--

DROP TABLE IF EXISTS `patches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patches` (
  `dd_n` char(16) NOT NULL DEFAULT '',
  `sp_s` char(12) DEFAULT 'auto',
  `vl_s` char(8) DEFAULT '-',
  `dd_p` char(16) DEFAULT NULL,
  `gb_s` char(4) DEFAULT '',
  `dd_r` char(8) DEFAULT NULL,
  `dd_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dd_n`),
  KEY `sp_s` (`sp_s`),
  KEY `vl_s` (`vl_s`),
  KEY `gb_s` (`gb_s`),
  CONSTRAINT `c2` FOREIGN KEY (`sp_s`) REFERENCES `ddspeed` (`sp_s`) ON UPDATE CASCADE,
  CONSTRAINT `c3` FOREIGN KEY (`vl_s`) REFERENCES `vlans` (`vl_s`) ON UPDATE CASCADE,
  CONSTRAINT `c4` FOREIGN KEY (`gb_s`) REFERENCES `buildings` (`gb_s`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `patches`
--

LOCK TABLES `patches` WRITE;
/*!40000 ALTER TABLE `patches` DISABLE KEYS */;
INSERT INTO `patches` VALUES ('A/0/0125','auto','200','G-12','A','0001','2012-03-03 15:57:08'),
('A/0/0126','auto','200','G-13','A','0001','2012-03-03 15:57:19'),
('A/0/0127','auto','200','G-14','A','0001','2012-03-03 15:57:32'),
('A/0/0128','auto','200','G-15','A','0002','2012-03-03 15:57:43'),
('A/0/0129','auto','200','G-16','A','0002','2012-03-03 15:58:29'),
('A/0/0130','auto','200','G-17','A','0002','2012-03-03 15:58:31'),
('A/0/0131','auto','200','G-18','A','0003','2012-03-03 15:58:34');
/*!40000 ALTER TABLE `patches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `swmanufacturers`
--

DROP TABLE IF EXISTS `swmanufacturers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `swmanufacturers` (
  `sm_s` char(16) NOT NULL,
  `sm_l` char(64) DEFAULT '',
  `sm_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sm_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `swmanufacturers`
--

LOCK TABLES `swmanufacturers` WRITE;
/*!40000 ALTER TABLE `swmanufacturers` DISABLE KEYS */;
INSERT INTO `swmanufacturers` VALUES ('sms','SmartSoft','2012-03-03 16:15:10'),
('yasm','Yet Another Software Manufacturer','2012-03-03 16:15:29');
/*!40000 ALTER TABLE `swmanufacturers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `swproducts`
--

DROP TABLE IF EXISTS `swproducts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `swproducts` (
  `sw_s` char(16) NOT NULL,
  `sw_l` char(64) DEFAULT '',
  `sm_s` char(16) DEFAULT '',
  `sw_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sw_s`),
  KEY `sm_s` (`sm_s`),
  CONSTRAINT `c9` FOREIGN KEY (`sm_s`) REFERENCES `swmanufacturers` (`sm_s`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `swproducts`
--

LOCK TABLES `swproducts` WRITE;
/*!40000 ALTER TABLE `swproducts` DISABLE KEYS */;
INSERT INTO `swproducts` VALUES ('SMS:001-005-28','Fine Desktop 2.8','sms','2012-03-03 16:17:53'),
('SMS:001-005-29','Fine Desktop 2.9','sms','2012-03-03 16:18:03'),
('SMS:001-018-15','Cool Text Editor 1.5','sms','2012-03-03 16:55:08'),
('SMS:001-018-16','Cool Text Editor 1.6','sms','2012-03-03 16:55:20'),
('yasm-ms-47','Mathematic Formula 4.7','yasm','2012-03-03 16:18:12'),
('yasm-ms-48','Mathematic Formula 4.8','yasm','2012-03-03 16:18:17'),
('yasm-ms-48u','Mathematic Formula 4.8 UPGRADE','yasm','2012-03-03 16:18:23');
/*!40000 ALTER TABLE `swproducts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `swresellers`
--

DROP TABLE IF EXISTS `swresellers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `swresellers` (
  `sr_s` char(16) NOT NULL,
  `sr_l` char(64) DEFAULT '',
  `sr_a1` char(64) DEFAULT NULL,
  `sr_a2` char(64) DEFAULT NULL,
  `sr_a3` char(64) DEFAULT NULL,
  `sr_a4` char(64) DEFAULT NULL,
  `sr_plz` char(8) DEFAULT NULL,
  `sr_ort` char(64) DEFAULT NULL,
  `sr_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sr_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `swresellers`
--

LOCK TABLES `swresellers` WRITE;
/*!40000 ALTER TABLE `swresellers` DISABLE KEYS */;
/*!40000 ALTER TABLE `swresellers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `us_s` char(12) NOT NULL DEFAULT '-',
  `us_t` char(32) DEFAULT NULL,
  `us_sn` char(64) DEFAULT '',
  `us_fn` char(64) DEFAULT '',
  `us_em` char(64) DEFAULT NULL,
  `us_ko` char(16) DEFAULT NULL,
  `us_se` char(16) DEFAULT NULL,
  `us_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`us_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('blue',NULL,'Betty','Blue','b.blue@my-university.edu','70211','1302','2012-03-03 15:51:36'),
('itdep',NULL,'','IT department',NULL,NULL,NULL,'2012-03-03 16:30:10'),
('orange','Prof.','Oliver','Orange','o.orange@my-university.edu','70210','1101','2012-03-03 15:50:30'),
('red','Dr.','Robert','Red','r.red@my-university.edu','70310','1401','2012-03-03 15:50:57'),
('white',NULL,'Walther','White','w.white@my-university.edu','70212','1005','2012-03-03 15:52:01');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vlans`
--

DROP TABLE IF EXISTS `vlans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlans` (
  `vl_s` char(8) NOT NULL DEFAULT '',
  `vl_l` char(64) DEFAULT 'my network',
  `vl_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`vl_s`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlans`
--

LOCK TABLES `vlans` WRITE;
/*!40000 ALTER TABLE `vlans` DISABLE KEYS */;
INSERT INTO `vlans` VALUES ('1','IT department, internal service controller network','2012-03-03 15:56:24'),
('100','IT department','2012-03-03 15:55:24'),
('200','Engineering faculty','2012-03-03 15:55:51'),
('300','Nonsens faculty','2012-03-03 15:55:59');
/*!40000 ALTER TABLE `vlans` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-03-04 16:12:14
