-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Sep 19, 2016 at 12:25 PM
-- Server version: 5.6.31
-- PHP Version: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `tmiva_backend`
--

-- --------------------------------------------------------

--
-- Table structure for table `external_users`
--

CREATE TABLE IF NOT EXISTS `external_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(18) NOT NULL DEFAULT '',
  `password` varchar(18) NOT NULL DEFAULT '',
  `root_location` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `external_users`
--

INSERT INTO `external_users` (`id`, `username`, `password`, `root_location`) VALUES
(1, 'tmiva', 'tmiva', 15),
(2, 'fodm', 'fodm', 21);

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `parent` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `parent`) VALUES
(1, 'Smittys', 0),
(2, 'Windowsmith', 1),
(3, 'Bear Companies', 0),
(4, 'Kodiac', 3),
(6, 'Shelter Systems', 1),
(7, 'Milwork', 1),
(12, 'Subway DCW', 0),
(11, 'Panda', 3),
(13, 'WWEMA', 0),
(14, 'Finance', 2),
(15, 'TMI', 0),
(16, 'Web Division', 15),
(17, 'Messiah', 0),
(18, 'Adams Green', 0),
(19, 'Fishman Allergy', 0),
(20, 'Office PCs', 15),
(21, 'FODM', 0);

-- --------------------------------------------------------

--
-- Table structure for table `pc_build`
--

CREATE TABLE IF NOT EXISTS `pc_build` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client` varchar(20) NOT NULL DEFAULT '0',
  `user` varchar(30) NOT NULL DEFAULT '',
  `user_id` varchar(20) NOT NULL DEFAULT '',
  `computer` varchar(30) NOT NULL DEFAULT 'computer',
  `domain` varchar(30) NOT NULL DEFAULT '',
  `ip` varchar(16) NOT NULL DEFAULT '',
  `model` varchar(30) NOT NULL DEFAULT '',
  `brand` varchar(20) NOT NULL DEFAULT '',
  `serial` varchar(30) NOT NULL DEFAULT '',
  `asset_tag` varchar(20) NOT NULL DEFAULT '',
  `os` enum('2000 Professional','XP Home','XP Pro','Server 2000 Standard','Server 2000 Enterprise','Server 2000 Standard x64','Server 2000 Enterprise x64','Server 2003 Standard','Server 2003 Enterprise','Server 2003 Standard x64','Server 2003 Enterprise x64','Vista Business','Vista Basic','Vista Premium','Vista Ultimate','Other') DEFAULT NULL,
  `office` enum('Standard 2003','Professional 2003','Small Business 2003','Professional 2003','Basic 2007','Standard 2007','Small Business 2007','Enterprise 2007','Home and Student 2007','Professional 2007','Professional Plus 2007','Ultimate 2007','other') DEFAULT NULL,
  `antivirus` enum('norton 2006','Corp','internet security') DEFAULT NULL,
  `spybot` tinyint(1) NOT NULL DEFAULT '0',
  `ad_aware` tinyint(1) NOT NULL DEFAULT '0',
  `defender` tinyint(1) NOT NULL DEFAULT '0',
  `reader` tinyint(1) NOT NULL DEFAULT '0',
  `writer` tinyint(1) NOT NULL DEFAULT '0',
  `diskeeper` tinyint(1) NOT NULL DEFAULT '0',
  `winzip` tinyint(1) NOT NULL DEFAULT '0',
  `update_windows` tinyint(1) NOT NULL DEFAULT '0',
  `update_norton` tinyint(1) NOT NULL DEFAULT '0',
  `cleanup` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `data_transfer` varchar(255) NOT NULL DEFAULT '',
  `notes` varchar(255) NOT NULL DEFAULT '',
  `engineer` varchar(30) NOT NULL DEFAULT '',
  `date` varchar(10) NOT NULL DEFAULT '',
  `parent` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `pc_build`
--

INSERT INTO `pc_build` (`id`, `client`, `user`, `user_id`, `computer`, `domain`, `ip`, `model`, `brand`, `serial`, `asset_tag`, `os`, `office`, `antivirus`, `spybot`, `ad_aware`, `defender`, `reader`, `writer`, `diskeeper`, `winzip`, `update_windows`, `update_norton`, `cleanup`, `data_transfer`, `notes`, `engineer`, `date`, `parent`) VALUES
(17, '0', 'Bob Migilicutty', '', 'Bob''s Computer', 'Window Smith Admin', '', 'DC Exploder', 'Dell', '555-55555', '', 'XP Pro', 'Basic 2007', 'norton 2006', 0, 1, 0, 1, 1, 1, 1, 0, 0, 0, '', '', '', '0000-00-00', 2),
(18, 'Smittys', 'Bill Schwab Jr.', '', 'PC 133', 'Local', '', 'Insepid', 'WeakComps', '82934-23423', 'Whee', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '0000-00-00', 6),
(20, 'Smittys', 'Dan Someone', '', 'This PC', 'Milworkgroup', '10.0.0.0', 'DC Exploder', 'HP', '1298437', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'Josh West', '10/05/06', 7),
(22, 'TMI', 'Josh', '', 'MacBook', '', '', 'Macbook1.1', 'Apple', '4H6407CFU9C', '', 'Other', 'Standard 2003', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '', '', '', '4/9/07', 16),
(23, 'TMI', 'Tig', '', 'Black MacBook', '', '', 'MacBook', 'Apple', '', '', 'Other', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '4/17/07', 16),
(24, 'TMI', 'Josh and Tig', '', 'iMac', '', '', 'iMac 20', 'Apple', '', '', 'XP Pro', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '4/17/07', 16),
(26, 'TMI', 'Ann Isaascson', '', '', '', '', '', '', '', '', 'Vista Premium', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '6/12/07', 20),
(27, '', 'David Isaacson', '', '', '', '', '', '', '', '', 'Vista Business', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '6/12/07', 20),
(28, 'FODM', 'Dr. Bruce', '', 'drbruce', 'FODM', '10.1.1.101', 'Dimension 3000', 'DELL', '', '', '', '', '', 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, '', 'P4 3.00 4H2 1.00 GB RAM 40 GB HD', '', '', 21),
(29, 'FODM', 'Front Desk 15th Floor', '', 'computer', 'FODM', '10.1.1.118', 'Optiplex GX280', 'DELL', 'Service Tag ZPU5561', '5917SZ7145', '', '', '', 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, '', '512 MB RAM', '', '', 21),
(30, 'FODM', 'Soringher', '', 'drmesick', 'FODM', '10.1.1.122', 'Optiplex 170L', 'DELL', '1ZRTP81', '', 'XP Pro', 'Professional 2003', 'Corp', 0, 1, 0, 1, 0, 1, 1, 1, 0, 0, '', '', '', '', 21),
(31, 'FODM', 'Monique James', '', 'chevynew2', 'FODM', 'Auto Obtain', 'Optiplex GX745', 'DELL', 'FW2PBC1', '34591192993', 'XP Pro', 'Professional 2003', 'Corp', 0, 1, 0, 0, 1, 1, 1, 1, 0, 0, '', '', '', '', 21);

-- --------------------------------------------------------

--
-- Table structure for table `registration`
--

CREATE TABLE IF NOT EXISTS `registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `manufacturer` varchar(30) NOT NULL DEFAULT '',
  `operatingSystem` varchar(30) NOT NULL DEFAULT '',
  `code` varchar(50) NOT NULL DEFAULT '',
  `licenses_available` tinyint(4) NOT NULL DEFAULT '0',
  `licenses_total` tinyint(4) NOT NULL DEFAULT '0',
  `notes` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `name`, `manufacturer`, `operatingSystem`, `code`, `licenses_available`, `licenses_total`, `notes`) VALUES
(1, 'Photoshop 6', 'Adobe', 'Windows', 'PWW600R7109436-266', 0, 0, ''),
(8, 'Win 2000 Server Upgrade', 'Microsoft', 'Operating System', '16pb6 dhjdv 2mqhq rbryp k4m7p', 0, 0, ''),
(9, 'Photoshop CS', 'Adobe', 'Windows', '1045-1756-0999-0999-3438-3575', 0, 0, 'Not our copy.'),
(7, 'Photoshop CS 2', 'Adobe', 'Mac', '1045-0401-8488-4493-3078-1875', 0, 1, 'Can''t be installed without an activation code from a previous Macintosh version of Photoshop.'),
(6, 'Vista Ultimate', 'Microsoft', 'Operating System', '869q3-ry32y-j6c8x-7y66x-9dmvk', 3, 10, '');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

INSERT INTO `users` (`id`, `username`, `password`) VALUES
(1, 'tmiva', 'future12'),
(2, 'tig', 'digitig'),
(3, 'josh', 'troves'),
(4, 'ann', 'oscar'),
(5, 'david', 'future');

/*!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 */;