-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: localhost    Database: inventory_management
-- ------------------------------------------------------
-- Server version	5.6.23-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 `public_800 numbers`
--

DROP TABLE IF EXISTS `public_800 numbers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_800 numbers` (
  `id` int(10) NOT NULL,
  `800 number` varchar(50) DEFAULT NULL,
  `local number` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_answering service after hours`
--

DROP TABLE IF EXISTS `public_answering service after hours`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_answering service after hours` (
  `id` int(10) NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_broadband cards`
--

DROP TABLE IF EXISTS `public_broadband cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_broadband cards` (
  `model of card` varchar(255) DEFAULT NULL,
  `partner name` varchar(50) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `sim card no` varchar(255) DEFAULT NULL,
  `phone number` varchar(50) DEFAULT NULL,
  `department` varchar(50) DEFAULT NULL,
  `ssid` varchar(255) DEFAULT NULL,
  KEY `ssid` (`ssid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_century ethernet reporting`
--

DROP TABLE IF EXISTS `public_century ethernet reporting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_century ethernet reporting` (
  `id` int(10) NOT NULL,
  `user id` varchar(255) DEFAULT NULL,
  `pswd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user id` (`user id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_centurylink`
--

DROP TABLE IF EXISTS `public_centurylink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_centurylink` (
  `id` int(10) NOT NULL,
  `sprint contact` varchar(50) DEFAULT NULL,
  `sprint circuit` varchar(50) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  `field3` varchar(255) DEFAULT NULL,
  `Field01` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_charlottesville phone lines`
--

DROP TABLE IF EXISTS `public_charlottesville phone lines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_charlottesville phone lines` (
  `id` int(10) NOT NULL,
  `line` varchar(50) DEFAULT NULL,
  `phone number` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_cisco`
--

DROP TABLE IF EXISTS `public_cisco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_cisco` (
  `id` int(10) NOT NULL,
  `user id` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `contract number` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  `asset tag` int(10) DEFAULT NULL,
  `field3` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user id01` (`user id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_comdata`
--

DROP TABLE IF EXISTS `public_comdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_comdata` (
  `id` int(10) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  `field3` varchar(255) DEFAULT NULL,
  `field4` varchar(255) DEFAULT NULL,
  `port` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_controls ip for ogden rd`
--

DROP TABLE IF EXISTS `public_controls ip for ogden rd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_controls ip for ogden rd` (
  `id` int(10) NOT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_copier count 2015`
--

DROP TABLE IF EXISTS `public_copier count 2015`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_copier count 2015` (
  `id` int(10) NOT NULL,
  `copier` varchar(255) DEFAULT NULL,
  `january` int(10) DEFAULT NULL,
  `february` int(10) DEFAULT NULL,
  `march` varchar(255) DEFAULT NULL,
  `april` varchar(255) DEFAULT NULL,
  `may` varchar(255) DEFAULT NULL,
  `june` varchar(255) DEFAULT NULL,
  `july` varchar(255) DEFAULT NULL,
  `august` varchar(255) DEFAULT NULL,
  `september` varchar(255) DEFAULT NULL,
  `october` varchar(255) DEFAULT NULL,
  `november` varchar(255) DEFAULT NULL,
  `december` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_dell switches`
--

DROP TABLE IF EXISTS `public_dell switches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_dell switches` (
  `service tag` varchar(50) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `id` int(10) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `ip address` varchar(50) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `mac` varchar(50) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `asset tag` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_edgewood server room`
--

DROP TABLE IF EXISTS `public_edgewood server room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_edgewood server room` (
  `camera` varchar(50) DEFAULT NULL,
  `ip address` varchar(50) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ip address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_fax machines`
--

DROP TABLE IF EXISTS `public_fax machines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_fax machines` (
  `location` varchar(50) DEFAULT NULL,
  `fax model` varchar(50) DEFAULT NULL,
  `machine id` varchar(50) DEFAULT NULL,
  `ip address` varchar(255) DEFAULT NULL,
  `asset tag` varchar(50) DEFAULT NULL,
  KEY `machine id` (`machine id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_ftp sites`
--

DROP TABLE IF EXISTS `public_ftp sites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_ftp sites` (
  `username` varchar(50) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_google accounts`
--

DROP TABLE IF EXISTS `public_google accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_google accounts` (
  `id` int(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `favorite food` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_ip phones in richmond`
--

DROP TABLE IF EXISTS `public_ip phones in richmond`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_ip phones in richmond` (
  `id` int(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_ipads`
--

DROP TABLE IF EXISTS `public_ipads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_ipads` (
  `id` int(10) NOT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `serial no` varchar(255) DEFAULT NULL,
  `imeid` varchar(255) DEFAULT NULL,
  `apple care no` varchar(255) DEFAULT NULL,
  `expires` date DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `iccid` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `imeid` (`imeid`),
  KEY `iccid` (`iccid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_ntelos master list`
--

DROP TABLE IF EXISTS `public_ntelos master list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_ntelos master list` (
  `department` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `phone number` double(15,0) DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `last` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_office ips`
--

DROP TABLE IF EXISTS `public_office ips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_office ips` (
  `id` int(10) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  `network` varchar(50) DEFAULT NULL,
  `ip address` varchar(50) DEFAULT NULL,
  `gateway` varchar(50) DEFAULT NULL,
  `subnet mask` varchar(50) DEFAULT NULL,
  `dns servers` varchar(50) DEFAULT NULL,
  `ip range` varchar(50) DEFAULT NULL,
  `pbx for ip phones` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `account number` varchar(255) DEFAULT NULL,
  `rounter mac address` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_paste errors`
--

DROP TABLE IF EXISTS `public_paste errors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_paste errors` (
  `department` varchar(255) DEFAULT NULL,
  `phone number` double(15,0) DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `last` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_phone switches`
--

DROP TABLE IF EXISTS `public_phone switches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_phone switches` (
  `id` int(10) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  `bipu ip address` varchar(50) DEFAULT NULL,
  `switch ip` varchar(255) DEFAULT NULL,
  `wan ip` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_polycom`
--

DROP TABLE IF EXISTS `public_polycom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_polycom` (
  `id` int(10) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  `system name` varchar(50) DEFAULT NULL,
  `asset tag` int(10) DEFAULT NULL,
  `serial number` varchar(50) DEFAULT NULL,
  `static wan` varchar(50) DEFAULT NULL,
  `ip address` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_pot lines`
--

DROP TABLE IF EXISTS `public_pot lines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_pot lines` (
  `id` int(10) NOT NULL,
  `department` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number01` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_projectors`
--

DROP TABLE IF EXISTS `public_projectors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_projectors` (
  `projector model` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `asset tag` varchar(50) DEFAULT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service code` varchar(50) DEFAULT NULL,
  KEY `express service code` (`express service code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_residential ntelos line`
--

DROP TABLE IF EXISTS `public_residential ntelos line`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_residential ntelos line` (
  `id` int(10) NOT NULL,
  `ntelos tech support` varchar(255) DEFAULT NULL,
  `residential no` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_residential service numbers`
--

DROP TABLE IF EXISTS `public_residential service numbers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_residential service numbers` (
  `id` int(10) NOT NULL,
  `number type` varchar(50) DEFAULT NULL,
  `number` int(10) DEFAULT NULL,
  `call forward number` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number type` (`number type`),
  KEY `number02` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_richmond office phone no`
--

DROP TABLE IF EXISTS `public_richmond office phone no`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_richmond office phone no` (
  `id` int(10) NOT NULL,
  `number` varchar(50) DEFAULT NULL,
  `purpose` varchar(50) DEFAULT NULL,
  `location that rings` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number03` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_routers`
--

DROP TABLE IF EXISTS `public_routers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_routers` (
  `id` int(10) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `serial no` varchar(255) DEFAULT NULL,
  `support contract` int(10) DEFAULT NULL,
  `alternate ip` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `support renewal` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_san ip information`
--

DROP TABLE IF EXISTS `public_san ip information`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_san ip information` (
  `san side a` varchar(255) DEFAULT NULL,
  `san side b` varchar(255) DEFAULT NULL,
  `Field01` varchar(255) DEFAULT NULL,
  `san iscsi ip side a` varchar(255) DEFAULT NULL,
  `san iscsi ip side b` varchar(255) DEFAULT NULL,
  `san iscsi from esx server` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_security system ip addresses`
--

DROP TABLE IF EXISTS `public_security system ip addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_security system ip addresses` (
  `id` int(10) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `ip address` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_service call forwards`
--

DROP TABLE IF EXISTS `public_service call forwards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_service call forwards` (
  `id` int(10) NOT NULL,
  `main number` varchar(255) DEFAULT NULL,
  `answering service` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_smartphones`
--

DROP TABLE IF EXISTS `public_smartphones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_smartphones` (
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_ssd`
--

DROP TABLE IF EXISTS `public_ssd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_ssd` (
  `id` int(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `ssd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_surface tablets`
--

DROP TABLE IF EXISTS `public_surface tablets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_surface tablets` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor asset` int(10) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `operating system04` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_toshiba static ips`
--

DROP TABLE IF EXISTS `public_toshiba static ips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_toshiba static ips` (
  `id` int(10) NOT NULL,
  `ip address` varchar(50) DEFAULT NULL,
  `field2` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_trane laptops`
--

DROP TABLE IF EXISTS `public_trane laptops`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_trane laptops` (
  `id` int(10) NOT NULL,
  `first name` varchar(255) DEFAULT NULL,
  `last name` varchar(255) DEFAULT NULL,
  `st` varchar(255) DEFAULT NULL,
  `esc` varchar(255) DEFAULT NULL,
  `asset` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `office` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_us cellular`
--

DROP TABLE IF EXISTS `public_us cellular`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_us cellular` (
  `id` int(10) NOT NULL,
  `number` double(15,0) DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `last` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `Field01` varchar(255) DEFAULT NULL,
  `sim no` varchar(255) DEFAULT NULL,
  `ssid` varchar(255) DEFAULT NULL,
  `field1` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ssid01` (`ssid`),
  KEY `number04` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_verizon master list`
--

DROP TABLE IF EXISTS `public_verizon master list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_verizon master list` (
  `id` int(10) NOT NULL,
  `department` varchar(255) DEFAULT NULL,
  `phone number` double(15,0) DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `last` varchar(255) DEFAULT NULL,
  `phone model` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `public_wireless access points`
--

DROP TABLE IF EXISTS `public_wireless access points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `public_wireless access points` (
  `id` int(10) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `ip address` varchar(50) DEFAULT NULL,
  `passcode` varchar(255) DEFAULT NULL,
  `ssid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ssid02` (`ssid`),
  KEY `passcode` (`passcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table01`
--

DROP TABLE IF EXISTS `table01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table01` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `printer model` varchar(50) DEFAULT NULL,
  `Field03` varchar(50) DEFAULT NULL,
  `warranty` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `scanner model` varchar(50) DEFAULT NULL,
  `Field04` varchar(50) DEFAULT NULL,
  `Field05` varchar(50) DEFAULT NULL,
  `ship date` varchar(255) DEFAULT NULL,
  `Field06` varchar(255) DEFAULT NULL,
  `product key codes` varchar(255) DEFAULT NULL,
  `Field07` varchar(255) DEFAULT NULL,
  `product key codes1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `Index01` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table02`
--

DROP TABLE IF EXISTS `table02`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table02` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `ship date` date DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `warranty` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `scanner model` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `Index02` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table03`
--

DROP TABLE IF EXISTS `table03`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table03` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `Index03` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table04`
--

DROP TABLE IF EXISTS `table04`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table04` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `warranty` varchar(255) DEFAULT NULL,
  `ship date` date DEFAULT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `printer model` varchar(50) DEFAULT NULL,
  `scanner model` varchar(255) DEFAULT NULL,
  `Field03` varchar(255) DEFAULT NULL,
  `Field04` varchar(50) DEFAULT NULL,
  `Field05` varchar(255) DEFAULT NULL,
  `product key codes` varchar(255) DEFAULT NULL,
  `solid state` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `operating system` (`operating system`),
  CONSTRAINT `table04_ibfk_1` FOREIGN KEY (`operating system`) REFERENCES `table02` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table05`
--

DROP TABLE IF EXISTS `table05`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table05` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `printer model` varchar(50) DEFAULT NULL,
  `Field03` varchar(50) DEFAULT NULL,
  `warranty` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `scanner model` varchar(50) DEFAULT NULL,
  `Field04` varchar(50) DEFAULT NULL,
  `Field05` varchar(50) DEFAULT NULL,
  `ship date` date DEFAULT NULL,
  `Field06` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `operating system01` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table06`
--

DROP TABLE IF EXISTS `table06`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table06` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `printer model` varchar(50) DEFAULT NULL,
  `Field03` varchar(50) DEFAULT NULL,
  `warranty` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `scanner model` varchar(50) DEFAULT NULL,
  `Field04` varchar(50) DEFAULT NULL,
  `Field05` varchar(50) DEFAULT NULL,
  `ship date` date DEFAULT NULL,
  `Field06` varchar(50) DEFAULT NULL,
  `product key codes` varchar(255) DEFAULT NULL,
  `Field07` varchar(255) DEFAULT NULL,
  `product key codes1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `operating system02` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `table07`
--

DROP TABLE IF EXISTS `table07`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table07` (
  `department` varchar(50) DEFAULT NULL,
  `allocation` varchar(255) DEFAULT NULL,
  `first name` varchar(50) DEFAULT NULL,
  `last name` varchar(50) DEFAULT NULL,
  `computer name` varchar(50) NOT NULL,
  `service tag` varchar(50) DEFAULT NULL,
  `express service tag` varchar(50) DEFAULT NULL,
  `pc model` varchar(50) DEFAULT NULL,
  `cost` double(15,0) DEFAULT NULL,
  `operating system` varchar(50) DEFAULT NULL,
  `Field01` varchar(50) DEFAULT NULL,
  `monitor model` varchar(50) DEFAULT NULL,
  `Field02` varchar(50) DEFAULT NULL,
  `ram` varchar(50) DEFAULT NULL,
  `printer model` varchar(50) DEFAULT NULL,
  `Field03` varchar(50) DEFAULT NULL,
  `warranty` varchar(50) DEFAULT NULL,
  `office version` varchar(50) DEFAULT NULL,
  `scanner model` varchar(50) DEFAULT NULL,
  `Field04` varchar(50) DEFAULT NULL,
  `Field05` varchar(50) DEFAULT NULL,
  `ship date` date DEFAULT NULL,
  `Field06` varchar(255) DEFAULT NULL,
  `product key codes` varchar(255) DEFAULT NULL,
  `Field07` varchar(255) DEFAULT NULL,
  `product key codes1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`computer name`),
  KEY `operating system03` (`operating system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2015-03-03 16:15:17
