-- MySQL dump 10.13  Distrib 5.1.30, for sun-solaris2.10 (sparc)
--
-- Host: localhost    Database: yourcompany_hw_sw_
-- ------------------------------------------------------
-- Server version	5.1.30-log

/*!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 `hardware`
--

DROP TABLE IF EXISTS `hardware`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `hardware` (
  `hardware_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hwmodel_id` int(10) unsigned NOT NULL,
  `serialnumber` varchar(100) DEFAULT NULL,
  `cpu` varchar(100) DEFAULT NULL,
  `memory` varchar(100) DEFAULT NULL,
  `harddisk` varchar(100) DEFAULT NULL,
  `nic` varchar(100) DEFAULT NULL,
  `hwcomment` varchar(100) DEFAULT NULL,
  `rack_id` int(10) unsigned NOT NULL,
  `office_id` int(10) unsigned NOT NULL,
  `manufacturer_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned NOT NULL,
  `team_id` int(10) unsigned NOT NULL,
  `hwstatus_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`hardware_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `hardware`
--

LOCK TABLES `hardware` WRITE;
/*!40000 ALTER TABLE `hardware` DISABLE KEYS */;
INSERT INTO `hardware` VALUES (1,4,'0716NNN003',NULL,NULL,NULL,NULL,'java',3,1,1,1,1,1),(2,4,'0716NNN063',NULL,NULL,NULL,NULL,'castro',3,1,1,1,1,1),(3,11,'0549AM2434',NULL,NULL,NULL,NULL,'gerda',4,1,1,4,2,1),(4,10,'0524AD82A7',NULL,NULL,NULL,NULL,'agate',40,1,1,4,3,1),(5,3,'FN44430108',NULL,NULL,NULL,NULL,'camel',41,1,1,4,1,2);
/*!40000 ALTER TABLE `hardware` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hwmodel`
--

DROP TABLE IF EXISTS `hwmodel`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `hwmodel` (
  `hwmodel_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hwmodel` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`hwmodel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `hwmodel`
--

LOCK TABLES `hwmodel` WRITE;
/*!40000 ALTER TABLE `hwmodel` DISABLE KEYS */;
INSERT INTO `hwmodel` VALUES (1,'Sun Fire V120'),(2,'Sun Fire V210'),(3,'Sun Fire V240'),(4,'Sun Fire T2000'),(5,'Sun Enterprise T5240'),(6,'StorEdge 3320 - JBOD'),(7,'StorEdge 3510'),(8,'StorEdge 6120'),(9,'StorEdge 6130'),(10,'Sun Fire V440'),(11,'Sun Fire X4200');
/*!40000 ALTER TABLE `hwmodel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hwstatus`
--

DROP TABLE IF EXISTS `hwstatus`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `hwstatus` (
  `hwstatus_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`hwstatus_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `hwstatus`
--

LOCK TABLES `hwstatus` WRITE;
/*!40000 ALTER TABLE `hwstatus` DISABLE KEYS */;
INSERT INTO `hwstatus` VALUES (1,'in use for production'),(2,'in use for testing'),(3,'for spare parts');
/*!40000 ALTER TABLE `hwstatus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manufacturer`
--

DROP TABLE IF EXISTS `manufacturer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `manufacturer` (
  `manufacturer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `manufacturername` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`manufacturer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `manufacturer`
--

LOCK TABLES `manufacturer` WRITE;
/*!40000 ALTER TABLE `manufacturer` DISABLE KEYS */;
INSERT INTO `manufacturer` VALUES (1,'Sun'),(2,'HP'),(3,'IBM'),(4,'Dell'),(5,'no name'),(6,'open source');
/*!40000 ALTER TABLE `manufacturer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `office`
--

DROP TABLE IF EXISTS `office`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `office` (
  `office_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `officename` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`office_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `office`
--

LOCK TABLES `office` WRITE;
/*!40000 ALTER TABLE `office` DISABLE KEYS */;
INSERT INTO `office` VALUES (1,'DCO'),(2,'MVO'),(3,'MARKHAM');
/*!40000 ALTER TABLE `office` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rack`
--

DROP TABLE IF EXISTS `rack`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `rack` (
  `rack_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rackname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`rack_id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `rack`
--

LOCK TABLES `rack` WRITE;
/*!40000 ALTER TABLE `rack` DISABLE KEYS */;
INSERT INTO `rack` VALUES (1,'A1'),(2,'A2'),(3,'A3'),(4,'A4'),(5,'A5'),(6,'A6'),(7,'A7'),(8,'A8'),(9,'A9'),(10,'A10'),(11,'A11'),(12,'A12'),(13,'A13'),(14,'A14'),(15,'A15'),(16,'A16'),(17,'A17'),(18,'A18'),(19,'A19'),(20,'A20'),(21,'B1'),(22,'B2'),(23,'B3'),(24,'B4'),(25,'B5'),(26,'B6'),(27,'B7'),(28,'B8'),(29,'B9'),(30,'B10'),(31,'C1'),(32,'C2'),(33,'C3'),(34,'C4'),(35,'C5'),(36,'C6'),(37,'C7'),(38,'C8'),(39,'C9'),(40,'C10'),(41,'C11');
/*!40000 ALTER TABLE `rack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `software`
--

DROP TABLE IF EXISTS `software`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `software` (
  `software_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `swname` varchar(100) DEFAULT NULL,
  `swlicense` varchar(100) DEFAULT NULL,
  `swquantity` int(10) unsigned DEFAULT '1',
  `swcomment` varchar(100) DEFAULT NULL,
  `manufacturer_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`software_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `software`
--

LOCK TABLES `software` WRITE;
/*!40000 ALTER TABLE `software` DISABLE KEYS */;
INSERT INTO `software` VALUES (1,'Ruby',NULL,1,'object oriented programming language',6,5),(2,'Apache',NULL,1,'Web server',6,5),(3,'MySQL','GPL license',10,'Relational database',1,4),(4,'ProFTP',NULL,1,'FTP server',6,5),(5,'syslog-ng',NULL,1,'log server',6,5),(6,'Nagios',NULL,1,'monitoring tool',6,5);
/*!40000 ALTER TABLE `software` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `team`
--

DROP TABLE IF EXISTS `team`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `team` (
  `team_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `teamname` varchar(100) DEFAULT NULL,
  `teammanager` varchar(100) DEFAULT NULL,
  `managerphone` varchar(100) DEFAULT NULL,
  `manageremail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`team_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `team`
--

LOCK TABLES `team` WRITE;
/*!40000 ALTER TABLE `team` DISABLE KEYS */;
INSERT INTO `team` VALUES (1,'UNIX','Voja Dudic',NULL,'voja@comp.com'),(2,'BA','Igor Freeman',NULL,'igor@comp.com'),(3,'CC','Milan',NULL,'milan@comp.com');
/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor`
--

DROP TABLE IF EXISTS `vendor`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `vendor` (
  `vendor_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vendorname` varchar(100) DEFAULT NULL,
  `vendorphone` varchar(100) DEFAULT NULL,
  `vendorfax` varchar(100) DEFAULT NULL,
  `vendoremail` varchar(100) DEFAULT NULL,
  `vendorwww` varchar(100) DEFAULT NULL,
  `vendorstreet` varchar(100) DEFAULT NULL,
  `vendorcity` varchar(100) DEFAULT NULL,
  `vendorstate` varchar(100) DEFAULT NULL,
  `vendorpostal` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`vendor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `vendor`
--

LOCK TABLES `vendor` WRITE;
/*!40000 ALTER TABLE `vendor` DISABLE KEYS */;
INSERT INTO `vendor` VALUES (1,'M Systems','1-866-230-0000','400-111-3010','rjanson@ccc.com','www.cc-cc.com','2411 Walker St.','Seattle','WA','98144'),(4,'Sun',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'open source',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `vendor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_contact`
--

DROP TABLE IF EXISTS `vendor_contact`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `vendor_contact` (
  `vendcont_it` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int(10) unsigned NOT NULL,
  `vcname` varchar(100) DEFAULT NULL,
  `vcphone` varchar(100) DEFAULT NULL,
  `vcfax` varchar(100) DEFAULT NULL,
  `vcemail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`vendcont_it`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `vendor_contact`
--

LOCK TABLES `vendor_contact` WRITE;
/*!40000 ALTER TABLE `vendor_contact` DISABLE KEYS */;
INSERT INTO `vendor_contact` VALUES (1,1,'Ben Donald',NULL,NULL,'bm@go.com'),(2,4,'All Lee','488.608.8548',NULL,'all.lee@sun.com'),(3,4,'Ram Nick','688-863-2491',NULL,NULL),(4,4,'Amor','650-999-0461',NULL,NULL);
/*!40000 ALTER TABLE `vendor_contact` 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 2009-12-23  3:13:40
