-- http://www.phpmyadmin.net
--




--
-- Database: `equipment`
--

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

--
-- Table structure for table `attachments`
--

CREATE TABLE IF NOT EXISTS `attachments` (
  `aKey` int(11) NOT NULL AUTO_INCREMENT,
  `pKey` int(11) NOT NULL,
  `suffix` varchar(32) NOT NULL,
  `bytes` bigint(20) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filename` varchar(247) NOT NULL,
  `comment` varchar(247) DEFAULT NULL,
  `type` varchar(247) DEFAULT NULL,
  `who` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`aKey`),
  KEY `pKey` (`pKey`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;


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

--
-- Table structure for table `aux_barcode_prefix`
--

CREATE TABLE IF NOT EXISTS `aux_barcode_prefix` (
  `prefix` char(2) NOT NULL DEFAULT '',
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_barcode_prefix`
--

INSERT INTO `aux_barcode_prefix` (`prefix`, `name`) VALUES
('AM', 'Applied Math'),
('BU', NULL),
('CF', NULL),
('CG', 'Computer Graphics'),
('CN', NULL),
('CO', NULL),
('CS', 'Computer Science'),
('DC', NULL),
('DO', 'Dean''s Office'),
('DS', NULL),
('GI', 'Games Institute'),
('HP', NULL),
('IC', NULL),
('IQ', NULL),
('IT', NULL),
('LP', NULL),
('MF', 'Math Faculty Computing Facility'),
('MS', NULL),
('OA', NULL),
('PM', 'Pure Math'),
('PR', NULL),
('QC', NULL),
('SA', NULL),
('SC', NULL),
('SG', NULL);

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

--
-- Table structure for table `aux_buildings`
--

CREATE TABLE IF NOT EXISTS `aux_buildings` (
  `prefix` varchar(8) NOT NULL DEFAULT '',
  `numberOfDigits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_buildings`
--

INSERT INTO `aux_buildings` (`prefix`, `numberOfDigits`) VALUES
('AD', 5),
('BFG', 4),
('CEIT', 4),
('CPH', 4),
('DC', 4),
('EC1', 3),
('HH', 3),
('M3', 4),
('MC', 4),
('PH', 4),
('PHY', 4),
('QNC', 4);

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

--
-- Table structure for table `aux_charges`
--

CREATE TABLE IF NOT EXISTS `aux_charges` (
  `type` varchar(32) DEFAULT NULL,
  `architecture` varchar(247) DEFAULT NULL,
  `connection` int(11) DEFAULT NULL,
  `administration` int(11) DEFAULT NULL,
  `service` int(11) DEFAULT NULL,
  `damping` float DEFAULT NULL,
  `subsidy` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_charges`
--

INSERT INTO `aux_charges` (`type`, `architecture`, `connection`, `administration`, `service`, `damping`, `subsidy`) VALUES
(NULL, '+IRIX64', NULL, NULL, NULL, NULL, NULL),
(NULL, 'AIX 4.2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'AIX', NULL, NULL, NULL, NULL, NULL),
(NULL, 'BSD', NULL, NULL, NULL, NULL, NULL),
(NULL, 'FreeBSD', NULL, NULL, NULL, NULL, NULL),
(NULL, 'IRIX', NULL, NULL, NULL, NULL, NULL),
(NULL, 'IRIX64', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Lab+Linux', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Lab+MacOS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Lab+Windows', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux & Windows', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux CentOS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Redboot Student', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Redhat', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Ubuntu 10.10', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Ubuntu 12.04', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Ubuntu 9.10', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Ubuntu', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux', NULL, NULL, NULL, NULL, NULL),
(NULL, 'MacOS X', NULL, NULL, NULL, NULL, NULL),
(NULL, 'MacOS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'NetApp', NULL, NULL, NULL, NULL, NULL),
(NULL, 'NetBSD', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Nexus', NULL, NULL, NULL, NULL, NULL),
(NULL, 'OpenStep', NULL, NULL, NULL, NULL, NULL),
(NULL, 'OSF1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Polaris', NULL, NULL, NULL, NULL, NULL),
(NULL, 'SunOS 5.6', NULL, NULL, NULL, NULL, NULL),
(NULL, 'SunOS 5.8', NULL, NULL, NULL, NULL, NULL),
(NULL, 'SunOS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Unknown VMware', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Unknown', NULL, NULL, NULL, NULL, NULL),
(NULL, 'VMWare', NULL, NULL, NULL, NULL, NULL),
(NULL, 'vSphere', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows & Linux', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 2000', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 2003', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 7 Pro', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 7', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 8', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 98', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows Terminal Server', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows Vista', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows XP', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Linux Ubuntu 14.04', NULL, NULL, NULL, NULL, NULL),
(NULL, 'Windows 10', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `aux_cname`
--

CREATE TABLE IF NOT EXISTS `aux_cname` (
  `cname` varchar(50) NOT NULL,
  PRIMARY KEY (`cname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `aux_domain`
--

CREATE TABLE IF NOT EXISTS `aux_domain` (
  `domain` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'user',
  PRIMARY KEY (`domain`),
  KEY `domain` (`domain`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_domain`
--

INSERT INTO `aux_domain` (`domain`, `type`) VALUES
('afp.cs.uwaterloo.ca', 'user'),
('ceph.cscf.uwaterloo.ca', 'user'),
('cgl.uwaterloo.ca', 'user'),
('cloud.cs.uwaterloo.ca', 'user'),
('cnst.cs.uwaterloo.ca', 'system'),
('cs.private.uwaterloo.ca', 'user'),
('cs.uwaterloo.ca', 'system'),
('cscf.uwaterloo.ca', 'user'),
('csclub.uwaterloo.ca', 'user'),
('csg.uwaterloo.ca', 'user'),
('dev.cs.uwaterloo.ca', 'user'),
('dev.cscf.uwaterloo.ca', 'user'),
('haproxy.cs.uwaterloo.ca', 'user'),
('haproxy.cscf.uwaterloo.ca', 'user'),
('icinga.cs.uwaterloo.ca', 'user'),
('icinga.cscf.uwaterloo.ca', 'user'),
('isg.cs.uwaterloo.ca', 'system'),
('lom.cscf.uwaterloo.ca', 'user'),
('math', 'user'),
('math.uwaterloo.ca', 'user'),
('nas.cscf.uwaterloo.ca', 'user'),
('net.uwaterloo.ca', 'user'),
('nextcloud-test.cs.uwaterloo.ca', 'user'),
('nextcloud.cs.uwaterloo.ca', 'user'),
('private.uwaterloo.ca', 'user'),
('rcs.uwaterloo.ca', 'user'),
('scg.uwaterloo.ca', 'user'),
('shoshin.uwaterloo.ca', 'user'),
('storage.cs.uwaterloo.ca', 'user'),
('student.cs.uwaterloo.ca', 'system'),
('syn.uwaterloo.ca', 'user'),
('sysadmins.cscf.uwaterloo.ca', 'system'),
('uwaterloo.ca', 'system'),
('watgamer.uwaterloo.ca', 'user');

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

--
-- Table structure for table `aux_equipment_type`
--

CREATE TABLE IF NOT EXISTS `aux_equipment_type` (
  `value` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_equipment_type`
--

INSERT INTO `aux_equipment_type` (`value`) VALUES
('Computer'),
('Display'),
('FileServer'),
('HVAC'),
('IP'),
('Mobile'),
('Networking'),
('Other'),
('Printer'),
('Projector'),
('SPDU'),
('Terminal'),
('Unknown'),
('UPS'),
('Virtual-kvm'),
('Virtual-lxc'),
('Virtual-VirtualBox'),
('Virtual-vmware');

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

--
-- Table structure for table `aux_groups`
--

CREATE TABLE IF NOT EXISTS `aux_groups` (
  `gr_unit` varchar(8) NOT NULL DEFAULT '',
  `gr_name` varchar(255) NOT NULL DEFAULT '',
  `gr_title` varchar(255) DEFAULT NULL,
  `gr_subTitle` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gr_unit`,`gr_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_groups`
--

INSERT INTO `aux_groups` (`gr_unit`, `gr_name`, `gr_title`, `gr_subTitle`) VALUES
('CS', 'ai', 'Computer Science Research Environments', 'Artificial Intelligence Group (AI)'),
('CS', 'arg-tc', 'General Computer Science Environment', 'Thin Clients'),
('CS', 'arg-unix-general-use', 'General Computer Science Environment', 'Unix - General-Use'),
('CS', 'arg-unix-server', 'General Computer Science Environment', 'Unix - Dedicated-Use'),
('CS', 'arg-windows-general-use', 'General Computer Science Environment', 'Windows Terminal Server - General-Use'),
('CS', 'bioinformatics', 'Computer Science Research Environments', ''),
('CS', 'ccermcs', 'Computer Science Research Environments', 'CCERMCS group'),
('CS', 'ccng', 'Computer Science Research Environments', 'Computer Communications Networks Group (CCNG)'),
('CS', 'cgl', 'Computer Science Research Environments', 'Computer Graphics Lab (CGL)'),
('CS', 'cs', 'Other', 'Miscellaneous'),
('CS', 'cs-theory', 'Computer Science Research Environments', 'Theory Group'),
('CS', 'cscf-devel', 'CSCF', 'Development Systems'),
('CS', 'cscf-unix-general-use', 'CSCF', 'Unix - General-Use'),
('CS', 'cscf-unix-servers', 'CSCF', 'Unix - Dedicated-Use'),
('CS', 'cscf-windows-general-use', 'CSCF', 'Windows Terminal Server - General-Use'),
('CS', 'cscf-windows-servers', 'CSCF', 'System Servers - MS Windows Server Edition'),
('CS', 'drg', 'Computer Science Research Environments', 'Database Group'),
('CS', 'eng-mrl', 'Other Research Groups', 'Microtechnology Research Laboratory (MRL)'),
('CS', 'grad-pc', 'Computer Science Research Environments', 'Grad Student PCs'),
('CS', 'icr', 'Other Research Groups', 'Institute for Computer Research  (ICR)'),
('CS', 'net-dist-sys', 'Computer Science Research Environments', 'Networks and Distributed Systems'),
('CS', 'networks', 'CSCF', 'network switches and routers'),
('CS', 'plg', 'Computer Science Research Environments', 'Programming Languages Group (PLG)'),
('CS', 'research-cit', 'Computer Science Research Environments', 'CIT Lab'),
('CS', 'rsg-storage', 'CSCF', 'RSG Stored equipment'),
('CS', 'scg', 'Computer Science Research Environments', 'Symbolic Computation Group (SCG)'),
('CS', 'scicom', 'Computer Science Research Environments', 'Scientific Computation Group (SciCom)'),
('CS', 'se', 'Computer Science Research Environments', 'Software Engineering Group (SE)'),
('CS', 'shoshin', 'Computer Science Research Environments', ''),
('CS', 'ss', 'Computer Science Research Environments', 'Simulation Server (SS)'),
('CS', 'storage', 'Other', 'Hosts in Storage'),
('CS', 'student-windows-general-use', 'Computer Science Teaching Environment', 'Windows Terminal Server - General-Use'),
('CS', 'swag', 'Computer Science Research Environments', 'Software Architecture Group'),
('CS', 'teaching-cit', 'Computer Science Teaching Environment', 'CIT Lab'),
('CS', 'teaching-graphics', 'Computer Science Teaching Environment', 'Graphics Lab'),
('CS', 'teaching-mac', 'Computer Science Teaching Environment', 'Workstations - MacOS'),
('CS', 'teaching-mac-servers', 'Computer Science Teaching Environment', 'System Servers - Macintosh'),
('CS', 'teaching-nexus-servers', 'Computer Science Teaching Environment', 'System Servers - Windows - Nexus'),
('CS', 'teaching-realtime', 'Computer Science Teaching Environment', 'Realtime Lab'),
('CS', 'teaching-server', 'Computer Science Teaching Environment', 'System Servers'),
('CS', 'teaching-unix-general-use', 'Computer Science Teaching Environment', 'Unix - General-Use'),
('CS', 'teaching-unix-servers', 'Computer Science Teaching Environment', 'Unix - Dedicated-Use'),
('CS', 'teaching-windows-general-use', 'Computer Science Teaching Environment', 'Thin Clients'),
('CS', 'unknown', 'Other', 'Hosts we haven''t categorized yet'),
('CS', 'watform', 'Computer Science Research Environments', 'WatForm group');

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

--
-- Table structure for table `aux_hosts`
--

CREATE TABLE IF NOT EXISTS `aux_hosts` (
  `id` varchar(255) NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ipa` varchar(15) NOT NULL,
  `mac` varchar(17) DEFAULT NULL,
  `CSasset` varchar(16) DEFAULT NULL,
  `pKey` varchar(16) DEFAULT NULL,
  `DNSid` varchar(16) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  `BusinessContact` varchar(255) DEFAULT NULL,
  `TechnicalContact` varchar(255) DEFAULT NULL,
  `PolicyEight` varchar(255) DEFAULT NULL,
  `LegacyAdminID` varchar(255) DEFAULT NULL,
  `LegacyContactID` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `LocalUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `aux_hosts_all`
--

CREATE TABLE IF NOT EXISTS `aux_hosts_all` (
  `id` varchar(255) NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ipa` varchar(15) NOT NULL,
  `mac` varchar(17) DEFAULT NULL,
  `CSasset` varchar(16) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  `BusinessContact` varchar(255) DEFAULT NULL,
  `TechnicalContact` varchar(255) DEFAULT NULL,
  `PolicyEight` varchar(255) DEFAULT NULL,
  `LegacyAdminID` varchar(255) DEFAULT NULL,
  `LegacyContactID` varchar(255) DEFAULT NULL,
  `PrimaryOU` varchar(255) DEFAULT NULL,
  `SecondaryOU` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `LocalUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `aux_hosts_tmp`
--

CREATE TABLE IF NOT EXISTS `aux_hosts_tmp` (
  `id` varchar(255) NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ipa` varchar(15) NOT NULL,
  `mac` varchar(17) DEFAULT NULL,
  `CSasset` varchar(16) DEFAULT NULL,
  `pKey` varchar(16) DEFAULT NULL,
  `DNSid` varchar(16) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  `BusinessContact` varchar(255) DEFAULT NULL,
  `TechnicalContact` varchar(255) DEFAULT NULL,
  `PolicyEight` varchar(255) DEFAULT NULL,
  `LegacyAdminID` varchar(255) DEFAULT NULL,
  `LegacyContactID` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `LocalUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `aux_licences`
--

CREATE TABLE IF NOT EXISTS `aux_licences` (
  `lKey` int(11) NOT NULL AUTO_INCREMENT,
  `licenceCharge` varchar(247) DEFAULT NULL,
  `licName` varchar(247) DEFAULT NULL,
  `licenceName` varchar(247) DEFAULT NULL,
  PRIMARY KEY (`lKey`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `aux_licences`
--

INSERT INTO `aux_licences` (`lKey`, `licenceCharge`, `licName`, `licenceName`) VALUES
(4, '8500', 'Windows Office 2007', 'Windows Office 2007 XP'),
(5, '7000', 'Mac Office 2008', 'Mac Office 2008, 2004'),
(6, '9000', 'Windows Vista', 'Windows Vista Business'),
(7, '35000', 'Windows Server', 'Windows 2003/2008 Server Enterprise Edition'),
(8, '10100', 'Windows XP', 'Windows XP Business'),
(9, '8000', 'Windows 7', 'Windows 7 Business');

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

--
-- Table structure for table `aux_policyEight`
--

CREATE TABLE IF NOT EXISTS `aux_policyEight` (
  `value` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_policyEight`
--

INSERT INTO `aux_policyEight` (`value`) VALUES
('Restricted'),
('Highly-restricted'),
('Confidential'),
('Public');

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

--
-- Table structure for table `aux_ranges`
--

CREATE TABLE IF NOT EXISTS `aux_ranges` (
  `id` varchar(247) NOT NULL,
  `name` varchar(247) NOT NULL,
  `start` int(10) unsigned NOT NULL,
  `end` int(10) unsigned NOT NULL,
  `comment` varchar(247) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_ranges`
--

INSERT INTO `aux_ranges` (`id`, `name`, `start`, `end`, `comment`) VALUES
('10.0.150.0', 'PHY_1002', 167810563, 167810813, 'CS /24'),
('10.0.151.0', 'DC_3556_ilom', 167810819, 167811069, 'CS /24'),
('10.0.152.0', 'DC_3558', 167811075, 167811325, 'CS /24'),
('10.0.153.0', 'Reserved_RT_572874', 167811331, 167811581, 'CS /24'),
('10.0.154.0', 'MC_3015', 167811587, 167811837, 'CS /24'),
('10.0.155.0', 'M3_3101', 167811843, 167812093, 'CS /24'),
('10.1.1.0', '10.1.1.0', 167837955, 167838205, 'CS /24'),
('10.1.2.0', 'private-cs-san152.net', 167838211, 167838461, 'CS /24'),
('10.1.3.0', '10.1.3.0', 167838467, 167838717, 'CS /24'),
('10.10.150.0', 'CS_Storage_|_PHY_1002', 168465923, 168466173, 'CS /24'),
('10.10.152.0', 'CS_Storage_|_DC_3558', 168466435, 168466685, 'CS /24'),
('10.10.153.0', 'Reserved_RT_572874', 168466691, 168466941, 'CS /24'),
('10.10.154.0', 'CS_Storage_|_MC_3015', 168466947, 168467197, 'CS /24'),
('10.10.155.0', 'CS_Storage_|_M3_3101', 168467203, 168467453, 'CS /24'),
('10.10.83.0', 'istpriwireless.net', 168448771, 168449021, 'CS /24'),
('10.15.0.0', 'cs-dns-park.net', 168755203, 168755709, 'CS /23'),
('10.15.134.0', 'mso-private.net', 168789507, 168789757, 'CS /24'),
('10.15.150.0', 'CS_Server_|_PHY_1002', 168793603, 168793853, 'CS /24'),
('10.15.152.0', 'CS_Server_|_DC_3558', 168794115, 168794365, 'CS /24'),
('10.15.153.0', 'Reserved_RT_572874', 168794371, 168794621, 'CS /24'),
('10.15.154.0', 'CS_Server_|_MC_3015', 168794627, 168794877, 'CS /24'),
('10.15.155.0', 'CS_Server_|_M3_3101', 168794883, 168795133, 'CS /24'),
('10.15.16.0', 'cspriv016net.net', 168759299, 168759549, 'CS /24'),
('10.15.167.0', 'csserver1-mc-private.net', 168797955, 168798077, 'CS /25'),
('10.15.167.128', 'csserver1-dc-private.net', 168798083, 168798205, 'CS /25'),
('10.15.18.0', 'dc-lom.net', 168759811, 168760061, 'CS /24'),
('10.15.2.0', 'dc-sensor.net', 168755715, 168755965, 'CS /24'),
('10.15.28.0', 'mc-lom.net', 168762371, 168762621, 'CS /24'),
('10.15.3.0', 'mc-sensor.net', 168755971, 168756221, 'CS /24'),
('10.15.32.0', 'dc-printer.net', 168763395, 168763645, 'CS /24'),
('10.15.4.0', 'dc-cloud.net', 168756227, 168756477, 'CS /24'),
('10.15.48.0', 'dc-cs-tc1.net', 168767491, 168767741, 'CS /24'),
('10.15.49.0', 'dc-cs-nettop1.net', 168767747, 168767997, 'CS /24'),
('10.15.5.0', 'mc-cloud.net', 168756483, 168756733, 'CS /24'),
('10.15.6.0', 'dc-cscf-dev.net', 168756739, 168756989, 'CS /24'),
('10.15.62.0', 'mc-cs-nettop1.net', 168771075, 168771325, 'CS /24'),
('10.15.63.0', 'mc-cs-tc1.net', 168771331, 168771581, 'CS /24'),
('10.15.64.0', 'dc-rtlab.net', 168771587, 168771837, 'CS /24'),
('10.15.65.0', '10.15.65.0', 168771843, 168772093, 'CS /24'),
('10.15.7.0', 'mc-cscf-dev.net', 168756995, 168757245, 'CS /24'),
('10.15.74.0', '10.15.74.0', 168774147, 168774397, 'CS /24'),
('10.15.75.0', '10.15.75.0', 168774403, 168774653, 'CS /24'),
('10.15.77.0', '10.15.77.0', 168774915, 168775165, 'CS /24'),
('10.15.78.0', '10.15.78.0', 168775171, 168775421, 'CS /24'),
('10.15.79.0', 'mc-rtlab.net', 168775427, 168775677, 'CS /24'),
('10.15.8.0', 'UNUSED', 168757251, 168757277, 'CS /27'),
('10.15.8.128', '10.15.8.128', 168757379, 168757405, 'CS /27'),
('10.15.8.160', '10.15.8.160', 168757411, 168757437, 'CS /27'),
('10.15.8.192', '10.15.8.192', 168757443, 168757469, 'CS /27'),
('10.15.8.224', '10.15.8.224', 168757475, 168757501, 'CS /27'),
('10.15.8.32', '10.15.8.32', 168757283, 168757309, 'CS /27'),
('10.15.8.64', '10.15.8.64', 168757315, 168757341, 'CS /27'),
('10.15.8.96', '10.15.8.96', 168757347, 168757373, 'CS /27'),
('10.15.80.0', 'cspriv080net.net', 168775683, 168775933, 'CS /24'),
('10.20.0.0', 'Campus_eduroam', 169082883, 169148413, 'AUTH /16'),
('10.21.0.0', 'Campus_unsecured', 169148419, 169213949, 'AUTH /16'),
('10.22.0.0', 'Resnet_eduroam', 169213955, 169279485, 'AUTH /16'),
('10.23.0.0', 'Resnet_unsecured', 169279491, 169345021, 'AUTH /16'),
('10.24.0.0', 'SKYNET', 169345027, 169345277, 'AUTH /24'),
('10.24.1.0', 'DEVWiFI2', 169345283, 169345533, 'AUTH /24'),
('10.24.16.0', 'Managed-Wifi-Subnet', 169349123, 169353213, 'AUTH /20'),
('10.24.2.0', 'Games_Institute_Wireless', 169345539, 169345789, 'AUTH /24'),
('10.24.3.0', 'DEVWIFI', 169345795, 169345821, 'AUTH /27'),
('10.24.4.0', 'MAC_DR_network_1_-_MGMT', 169346051, 169346109, 'CR /26'),
('10.24.4.128', 'MAC_DR_network_3_-_Vserver_Data', 169346179, 169346237, 'CR /26'),
('10.24.4.192', 'MAC_DR_network_4', 169346243, 169346301, 'CR /26'),
('10.24.4.64', 'MAC_DR_network_2_-_Inter_Cluster', 169346115, 169346173, 'CR /26'),
('10.4.0.0', '10.4.0.0', 168034307, 168099837, 'CS /16'),
('10.42.1.0', '10.42.1.0', 170524931, 170525181, 'CS /24'),
('10.42.2.0', '10.42.2.0', 170525187, 170525437, 'CS /24'),
('10.97.1.0', '10.97.1.0', 174129411, 174129661, 'CS /24'),
('10.97.10.0', '10.97.10.0', 174131715, 174131965, 'CS /24'),
('10.97.128.0', '10.97.128.0', 174161923, 174162173, 'CS /24'),
('10.98.0.0', '10.98.0.0', 174194691, 174194941, 'MATH /24'),
('129.97.105.0', 'flash-cs.net', 2170644739, 2170644989, 'CS /24'),
('129.97.114.0', 'cgl.net', 2170647043, 2170647293, 'CS /24'),
('129.97.119.128', 'cs-savi.net', 2170648451, 2170648509, 'CS /26'),
('129.97.119.192', 'ripple-admin.net', 2170648515, 2170648573, 'CS /26'),
('129.97.134.0', 'mathstudentorgs.net', 2170652163, 2170652413, 'MATH /24'),
('129.97.15.0', 'cscf.net', 2170621699, 2170621949, 'CS /24'),
('129.97.152.0', 'CS_Server_Public_|_PHY_1002', 2170656768, 2170656783, 'CS /28'),
('129.97.152.112', 'cs-mc-server8', 2170656880, 2170656895, 'CS /28'),
('129.97.152.128', 'cs-mc-server9', 2170656897, 2170656902, 'CS /29'),
('129.97.152.136', 'cs-mc-server10', 2170656905, 2170656910, 'CS /29'),
('129.97.152.144', 'cs-mc-server11', 2170656913, 2170656918, 'CS /29'),
('129.97.152.152', 'cs-mc-server12', 2170656921, 2170656926, 'CS /29'),
('129.97.152.16', 'cs-dc-serverroom-ipv6-test', 2170656784, 2170656799, 'CS /28'),
('129.97.152.160', 'cs-mc-server13', 2170656929, 2170656934, 'CS /29'),
('129.97.152.168', 'cs-mc-server14', 2170656937, 2170656942, 'CS /29'),
('129.97.152.176', 'cs-mc-server15', 2170656945, 2170656950, 'CS /29'),
('129.97.152.184', 'cs-mc-server16', 2170656953, 2170656958, 'CS /29'),
('129.97.152.192', 'cs-mc-server17', 2170656961, 2170656966, 'CS /29'),
('129.97.152.200', 'cs-mc-server18', 2170656969, 2170656974, 'CS /29'),
('129.97.152.208', 'cs-mc-server19', 2170656977, 2170656982, 'CS /29'),
('129.97.152.216', 'cs-mc-server20', 2170656985, 2170656990, 'CS /29'),
('129.97.152.224', 'cs-mc-server21', 2170656993, 2170656998, 'CS /29'),
('129.97.152.232', 'cs-mc-server22', 2170657001, 2170657006, 'CS /29'),
('129.97.152.240', 'cs-mc-server23', 2170657009, 2170657014, 'CS /29'),
('129.97.152.248', 'cs-mc-server24', 2170657017, 2170657022, 'CS /29'),
('129.97.152.32', 'cs-mc-server3', 2170656800, 2170656815, 'CS /28'),
('129.97.152.48', 'cs-mc-server4', 2170656816, 2170656831, 'CS /28'),
('129.97.152.64', 'cs-mc-server5', 2170656832, 2170656847, 'CS /28'),
('129.97.152.80', 'cs-mc-server6', 2170656848, 2170656863, 'CS /28'),
('129.97.152.96', 'cs-mc-server7', 2170656864, 2170656879, 'CS /28'),
('129.97.16.0', 'CS_4th_floor_MC', 2170621955, 2170622077, 'CS /25'),
('129.97.16.192', 'cslab2.net', 2170622147, 2170622205, 'CS /26'),
('129.97.167.0', 'cs-teaching.net', 2170660611, 2170660669, 'CS /26'),
('129.97.167.128', 'cs-anycast.net', 2170660739, 2170660861, 'CS /25'),
('129.97.167.64', 'cs-general.net', 2170660675, 2170660733, 'CS /26'),
('129.97.168.0', 'csclient1.net', 2170660867, 2170661117, 'CS /24'),
('129.97.169.0', 'csclient2.net', 2170661123, 2170661373, 'CS /24'),
('129.97.170.0', 'csclient3.net', 2170661379, 2170661885, 'CS /23'),
('129.97.173.0', 'dc-cs-admin.net', 2170662147, 2170662173, 'CS /27'),
('129.97.173.128', 'cs-dc-nettops.net', 2170662275, 2170662333, 'CS /26'),
('129.97.173.192', 'csg.net', 2170662339, 2170662397, 'CS /26'),
('129.97.173.32', 'csreserve173.net', 2170662179, 2170662205, 'CS /27'),
('129.97.173.64', 'mc-cs-ugrad.net', 2170662211, 2170662269, 'CS /26'),
('129.97.18.16', 'csclub_csc-data.net', 2170622480, 2170622495, 'CS /28'),
('129.97.186.0', 'wheat.net', 2170665475, 2170665725, 'CS /24'),
('129.97.2.184', 'mc-user2', 2170618553, 2170618558, 'AS /29'),
('129.97.242.192', 'bb1-watgamer', 2170680003, 2170680061, 'AS /26'),
('129.97.26.0', 'csresearch2.net', 2170624515, 2170624765, 'CS /24'),
('129.97.34.0', 'mc-lab1.net', 2170626563, 2170626621, 'CS /26'),
('129.97.34.128', 'mc-lab3.net', 2170626691, 2170626749, 'CS /26'),
('129.97.34.192', 'mc-lab4.net', 2170626755, 2170626813, 'CS /26'),
('129.97.34.64', 'mc-lab2.net', 2170626627, 2170626685, 'CS /26'),
('129.97.51.0', 'mclab5-_mc3003', 2170630915, 2170631037, 'CS /25'),
('129.97.51.128', 'mclab6-_mc3005', 2170631043, 2170631101, 'CS /26'),
('129.97.51.192', 'mclab7-_mc3027', 2170631107, 2170631165, 'CS /26'),
('129.97.59.0', 'mclab8-mc3022', 2170632963, 2170633021, 'CS /26'),
('129.97.59.128', 'cs-dc-lab.net', 2170633091, 2170633149, 'CS /26'),
('129.97.59.192', 'sweng-dc-lab.net', 2170633155, 2170633213, 'CS /26'),
('129.97.59.64', 'mclab9-_realtime', 2170633027, 2170633053, 'CS /27'),
('129.97.59.96', 'mclab10-_graphics', 2170633059, 2170633085, 'CS /27'),
('129.97.7.0', 'csresearch1.net', 2170619651, 2170619901, 'CS /24'),
('129.97.74.0', 'cs-untrust.net', 2170636803, 2170637053, 'CS /24'),
('129.97.75.0', 'delegated_to_rcs.uwaterloo.ca', 2170637059, 2170637309, 'CS /24'),
('129.97.84.0', 'csclient.net', 2170639363, 2170639613, 'CS /24'),
('129.97.86.128', 'cs-sr-pub1_(RT_350192)', 2170640003, 2170640029, 'CS /27'),
('172.16.4.128', 'rgmatlab1.net', 2886730881, 2886730886, 'CS /29'),
('172.16.4.136', 'rgmatlab2.net', 2886730889, 2886730894, 'CS /29'),
('172.16.4.144', 'rgmatlab3.net', 2886730897, 2886730902, 'CS /29'),
('172.19.0.0', 'cscore.net', 2886926339, 2886926589, 'CS /24'),
('172.19.1.0', 'mc-cs2-dc-cs2-trk2.net', 2886926593, 2886926594, 'CS /30'),
('172.19.1.100', '172.19.1.100', 2886926693, 2886926694, 'CS /30'),
('172.19.1.104', '172.19.1.104', 2886926697, 2886926698, 'CS /30'),
('172.19.1.108', '172.19.1.108', 2886926701, 2886926702, 'CS /30'),
('172.19.1.112', '172.19.1.112', 2886926705, 2886926706, 'CS /30'),
('172.19.1.116', '172.19.1.116', 2886926709, 2886926710, 'CS /30'),
('172.19.1.12', 'UNUSED', 2886926605, 2886926606, 'CS /30'),
('172.19.1.120', '172.19.1.120', 2886926713, 2886926714, 'CS /30'),
('172.19.1.124', '172.19.1.124', 2886926717, 2886926718, 'CS /30'),
('172.19.1.128', '172.19.1.128', 2886926721, 2886926722, 'CS /30'),
('172.19.1.132', '172.19.1.132', 2886926725, 2886926726, 'CS /30'),
('172.19.1.136', '172.19.1.136', 2886926729, 2886926730, 'CS /30'),
('172.19.1.140', '172.19.1.140', 2886926733, 2886926734, 'CS /30'),
('172.19.1.144', '172.19.1.144', 2886926737, 2886926738, 'CS /30'),
('172.19.1.148', '172.19.1.148', 2886926741, 2886926742, 'CS /30'),
('172.19.1.152', '172.19.1.152', 2886926745, 2886926746, 'CS /30'),
('172.19.1.156', '172.19.1.156', 2886926749, 2886926750, 'CS /30'),
('172.19.1.16', 'dc-cs2-dc-cs1-trk1.net', 2886926609, 2886926610, 'CS /30'),
('172.19.1.160', '172.19.1.160', 2886926753, 2886926754, 'CS /30'),
('172.19.1.164', '172.19.1.164', 2886926757, 2886926758, 'CS /30'),
('172.19.1.168', '172.19.1.168', 2886926761, 2886926762, 'CS /30'),
('172.19.1.172', '172.19.1.172', 2886926765, 2886926766, 'CS /30'),
('172.19.1.176', '172.19.1.176', 2886926769, 2886926770, 'CS /30'),
('172.19.1.180', '172.19.1.180', 2886926773, 2886926774, 'CS /30'),
('172.19.1.184', '172.19.1.184', 2886926777, 2886926778, 'CS /30'),
('172.19.1.188', '172.19.1.188', 2886926781, 2886926782, 'CS /30'),
('172.19.1.192', '172.19.1.192', 2886926785, 2886926786, 'CS /30'),
('172.19.1.196', '172.19.1.196', 2886926789, 2886926790, 'CS /30'),
('172.19.1.20', 'dc-cs1-cs-rt-dc-2303a', 2886926613, 2886926614, 'CS /30'),
('172.19.1.200', '172.19.1.200', 2886926793, 2886926794, 'CS /30'),
('172.19.1.204', '172.19.1.204', 2886926797, 2886926798, 'CS /30'),
('172.19.1.208', '172.19.1.208', 2886926801, 2886926802, 'CS /30'),
('172.19.1.212', '172.19.1.212', 2886926805, 2886926806, 'CS /30'),
('172.19.1.216', '172.19.1.216', 2886926809, 2886926810, 'CS /30'),
('172.19.1.220', '172.19.1.220', 2886926813, 2886926814, 'CS /30'),
('172.19.1.224', '172.19.1.224', 2886926817, 2886926818, 'CS /30'),
('172.19.1.228', '172.19.1.228', 2886926821, 2886926822, 'CS /30'),
('172.19.1.232', '172.19.1.232', 2886926825, 2886926826, 'CS /30'),
('172.19.1.236', '172.19.1.236', 2886926829, 2886926830, 'CS /30'),
('172.19.1.24', 'cs-rt-mc-3015-a-cs-rt-dc-2303a', 2886926617, 2886926618, 'CS /30'),
('172.19.1.240', '172.19.1.240', 2886926833, 2886926834, 'CS /30'),
('172.19.1.244', '172.19.1.244', 2886926837, 2886926838, 'CS /30'),
('172.19.1.248', '172.19.1.248', 2886926841, 2886926842, 'CS /30'),
('172.19.1.252', '172.19.1.252', 2886926845, 2886926846, 'CS /30'),
('172.19.1.28', 'mc-cs2_-_mc-rt-3015-mso-a', 2886926621, 2886926622, 'CS /30'),
('172.19.1.32', 'mc-rt-3015-mso-a_|_dc-rt-3558-mso-a', 2886926625, 2886926626, 'CS /30'),
('172.19.1.36', 'm3-3101-bgp.net', 2886926629, 2886926630, 'CS /30'),
('172.19.1.4', 'mc-cs2-dc-cs1-trk3.net', 2886926597, 2886926598, 'CS /30'),
('172.19.1.40', 'dc-3558-bgp.net', 2886926633, 2886926634, 'CS /30'),
('172.19.1.44', 'mc-3015-bgp.net', 2886926637, 2886926638, 'CS /30'),
('172.19.1.48', '172.19.1.48', 2886926641, 2886926642, 'CS /30'),
('172.19.1.52', '172.19.1.52', 2886926645, 2886926646, 'CS /30'),
('172.19.1.56', '172.19.1.56', 2886926649, 2886926650, 'CS /30'),
('172.19.1.60', '172.19.1.60', 2886926653, 2886926654, 'CS /30'),
('172.19.1.64', '172.19.1.64', 2886926657, 2886926658, 'CS /30'),
('172.19.1.68', '172.19.1.68', 2886926661, 2886926662, 'CS /30'),
('172.19.1.72', '172.19.1.72', 2886926665, 2886926666, 'CS /30'),
('172.19.1.76', '172.19.1.76', 2886926669, 2886926670, 'CS /30'),
('172.19.1.8', 'MSO-RT-MGMT', 2886926601, 2886926602, 'CS /30'),
('172.19.1.80', '172.19.1.80', 2886926673, 2886926674, 'CS /30'),
('172.19.1.84', '172.19.1.84', 2886926677, 2886926678, 'CS /30'),
('172.19.1.88', '172.19.1.88', 2886926681, 2886926682, 'CS /30'),
('172.19.1.92', '172.19.1.92', 2886926685, 2886926686, 'CS /30'),
('172.19.1.96', '172.19.1.96', 2886926689, 2886926690, 'CS /30'),
('172.19.10.0', 'mc-cs-cvl.net', 2886928899, 2886929149, 'CS /24'),
('172.19.100.0', '172.19.100.0', 2886951939, 2886952189, 'CS /24'),
('172.19.101.0', '172.19.101.0', 2886952195, 2886952445, 'CS /24'),
('172.19.102.0', '172.19.102.0', 2886952451, 2886952701, 'CS /24'),
('172.19.103.0', '172.19.103.0', 2886952707, 2886952957, 'CS /24'),
('172.19.104.0', '172.19.104.0', 2886952963, 2886953213, 'CS /24'),
('172.19.105.0', '172.19.105.0', 2886953219, 2886953469, 'CS /24'),
('172.19.106.0', '172.19.106.0', 2886953475, 2886953725, 'CS /24'),
('172.19.107.0', '172.19.107.0', 2886953731, 2886953981, 'CS /24'),
('172.19.108.0', '172.19.108.0', 2886953987, 2886954237, 'CS /24'),
('172.19.109.0', '172.19.109.0', 2886954243, 2886954493, 'CS /24'),
('172.19.11.0', '172.19.11.0', 2886929155, 2886929405, 'CS /24'),
('172.19.110.0', '172.19.110.0', 2886954499, 2886954749, 'CS /24'),
('172.19.111.0', '172.19.111.0', 2886954755, 2886955005, 'CS /24'),
('172.19.112.0', '172.19.112.0', 2886955011, 2886959101, 'CS /20'),
('172.19.12.0', 'dc-cs-cvl.net', 2886929411, 2886929661, 'CS /24'),
('172.19.128.0', 'himrod.net_|_RT_328093', 2886959107, 2886959357, 'CS /24'),
('172.19.129.0', 'cs-srv-mgmt.net', 2886959360, 2886959375, 'CS /28'),
('172.19.13.0', '172.19.13.0', 2886929667, 2886929917, 'CS /24'),
('172.19.134.0', 'Math_Student_Orgs_|_RT_359401_|_RT_594948', 2886960643, 2886960893, 'CS /24'),
('172.19.14.0', '172.19.14.0', 2886929923, 2886930173, 'CS /24'),
('172.19.15.0', 'CS_Server_DC_3558', 2886930179, 2886930205, 'CS /27'),
('172.19.15.128', 'cs-srv-mc.net', 2886930307, 2886930365, 'CS /26'),
('172.19.15.192', 'CS_Server_M3_3101', 2886930371, 2886930429, 'CS /26'),
('172.19.15.32', 'cs-mgmt-m3.net', 2886930208, 2886930223, 'CS /28'),
('172.19.15.64', 'Reserved_RT_572874', 2886930243, 2886930301, 'CS /26'),
('172.19.150.0', 'cs-srv4.net_|_PHY_1002', 2886964739, 2886964989, 'CS /24'),
('172.19.152.0', 'cs-srv4.net_|_DC_3558', 2886965251, 2886965501, 'CS /24'),
('172.19.153.0', 'Reserved_RT_572874', 2886965507, 2886965757, 'CS /24'),
('172.19.154.0', 'cs-srv4.net_|_MC_3015', 2886965763, 2886966013, 'CS /24'),
('172.19.155.0', 'cs-srv4.net_|_M3_3101', 2886966019, 2886966269, 'CS /24'),
('172.19.156.0', 'ripple-data.net', 2886966275, 2886966525, 'CS /24'),
('172.19.157.0', 'ripple-ipmi.net', 2886966531, 2886966653, 'CS /25'),
('172.19.157.128', 'ASIMOV-DEPLOY-DC', 2886966656, 2886966671, 'CS /28'),
('172.19.157.144', 'ASIMOV-DEPLOY-DC-SERVER', 2886966672, 2886966687, 'CS /28'),
('172.19.157.160', 'ASIMOV-DEPLOY-MC', 2886966688, 2886966703, 'CS /28'),
('172.19.157.176', 'ASIMOV-DEPLOY-MC-SERVER', 2886966704, 2886966719, 'CS /28'),
('172.19.157.192', 'ASIMOV-DEPLOY-M3', 2886966720, 2886966735, 'CS /28'),
('172.19.16.0', '172.19.16.0', 2886930435, 2886930685, 'CS /24'),
('172.19.167.0', 'cs-teaching.net', 2886969091, 2886969149, 'CS /26'),
('172.19.167.128', 'cs-anycast.net', 2886969219, 2886969341, 'CS /25'),
('172.19.167.64', 'cs-general.net', 2886969155, 2886969213, 'CS /26'),
('172.19.168.0', 'CSC_Cloud_Mgmt_|_RT_590359', 2886969347, 2886969373, 'CS /27'),
('172.19.168.32', 'CSC_Cloud_Storage', 2886969379, 2886969405, 'CS /27'),
('172.19.173.64', 'mc-ugster-lom', 2886970691, 2886970749, 'CS /26'),
('172.19.18.0', 'cs-dc-syn', 2886930947, 2886931069, 'CS /25'),
('172.19.2.0', '172.19.2.0', 2886926851, 2886927101, 'CS /24'),
('172.19.20.0', 'cs-researchmgmt-mc', 2886931459, 2886931709, 'CS /24'),
('172.19.3.0', '172.19.3.0', 2886927107, 2886927357, 'CS /24'),
('172.19.32.0', 'dc-cs-server1-campus.net', 2886934531, 2886934781, 'CS /24'),
('172.19.33.0', 'dc-cs-printer.net', 2886934787, 2886935037, 'CS /24'),
('172.19.34.0', 'dc-cs-vm1.net', 2886935043, 2886935165, 'CS /25'),
('172.19.34.128', 'mc-cs-vm1.net', 2886935171, 2886935293, 'CS /25'),
('172.19.35.0', '172.19.35.0', 2886935299, 2886935549, 'CS /24'),
('172.19.36.0', '172.19.36.0', 2886935555, 2886935805, 'CS /24'),
('172.19.37.0', '172.19.37.0', 2886935811, 2886936061, 'CS /24'),
('172.19.38.0', '172.19.38.0', 2886936067, 2886936317, 'CS /24'),
('172.19.39.0', '172.19.39.0', 2886936323, 2886936573, 'CS /24'),
('172.19.4.0', '172.19.4.0', 2886927360, 2886927375, 'AS /28'),
('172.19.4.112', '172.19.4.112', 2886927472, 2886927487, 'CS /28'),
('172.19.4.128', 'cs-ups-dc.net', 2886927491, 2886927517, 'CS /27'),
('172.19.4.16', '172.19.4.16', 2886927376, 2886927391, 'AS /28'),
('172.19.4.160', 'cs-mc-ups.net', 2886927523, 2886927549, 'CS /27'),
('172.19.4.192', '172.19.4.192', 2886927555, 2886927581, 'CS /27'),
('172.19.4.224', '172.19.4.224', 2886927587, 2886927613, 'CS /27'),
('172.19.4.32', 'as-sec-dc', 2886927395, 2886927421, 'AS /27'),
('172.19.4.64', '172.19.4.64', 2886927424, 2886927439, 'CS /28'),
('172.19.4.80', '172.19.4.80', 2886927440, 2886927455, 'CS /28'),
('172.19.4.96', '172.19.4.96', 2886927456, 2886927471, 'CS /28'),
('172.19.40.0', 'dc-printer2.net', 2886936579, 2886936829, 'AS /24'),
('172.19.41.0', '172.19.41.0', 2886936835, 2886937085, 'CS /24'),
('172.19.42.0', '172.19.42.0', 2886937091, 2886937341, 'CS /24'),
('172.19.43.0', '172.19.43.0', 2886937347, 2886937597, 'CS /24'),
('172.19.44.0', '172.19.44.0', 2886937603, 2886937853, 'CS /24'),
('172.19.45.0', '172.19.45.0', 2886937859, 2886938109, 'CS /24'),
('172.19.46.0', '172.19.46.0', 2886938115, 2886938365, 'CS /24'),
('172.19.47.0', 'mc-cs-server1-campus.net', 2886938371, 2886938621, 'CS /24'),
('172.19.48.0', 'cs-t1-net_(v530)', 2886938627, 2886938749, 'CS /25'),
('172.19.48.128', 'cs-t2-net_(v531)', 2886938755, 2886938877, 'CS /25'),
('172.19.49.0', 'cs-t3-net_(v532)', 2886938883, 2886939005, 'CS /25'),
('172.19.49.128', 'cs-t4-net_(v533)', 2886939011, 2886939069, 'CS /26'),
('172.19.49.192', 'cs-t5-net_(v534)', 2886939075, 2886939133, 'CS /26'),
('172.19.5.0', 'dc-cs-fw1.net', 2886927617, 2886927622, 'CS /29'),
('172.19.5.104', '172.19.5.104', 2886927721, 2886927726, 'CS /29'),
('172.19.5.112', '172.19.5.112', 2886927729, 2886927734, 'CS /29'),
('172.19.5.120', 'cs-mc-prt', 2886927737, 2886927742, 'CS /29'),
('172.19.5.128', 'cs-net-dc-ap-mgmt.net', 2886927747, 2886927869, 'CS /25'),
('172.19.5.16', 'cs-rt-m3', 2886927633, 2886927638, 'CS /29'),
('172.19.5.24', 'csc-ipmi.net', 2886927641, 2886927646, 'CS /29'),
('172.19.5.32', 'MSO-MGMT-Vlan', 2886927649, 2886927654, 'CS /29'),
('172.19.5.40', '172.19.5.40', 2886927657, 2886927662, 'CS /29'),
('172.19.5.48', '172.19.5.48', 2886927665, 2886927670, 'CS /29'),
('172.19.5.56', '172.19.5.56', 2886927673, 2886927678, 'CS /29'),
('172.19.5.64', '172.19.5.64', 2886927681, 2886927686, 'CS /29'),
('172.19.5.72', '172.19.5.72', 2886927689, 2886927694, 'CS /29'),
('172.19.5.8', 'mc-storage.net', 2886927625, 2886927630, 'CS /29'),
('172.19.5.80', '172.19.5.80', 2886927697, 2886927702, 'CS /29'),
('172.19.5.88', '172.19.5.88', 2886927705, 2886927710, 'CS /29'),
('172.19.5.96', '172.19.5.96', 2886927713, 2886927718, 'CS /29'),
('172.19.50.0', 'cs-t6-net_(v535)', 2886939139, 2886939197, 'CS /26'),
('172.19.50.128', 'cs-t8-net_(v537)', 2886939267, 2886939325, 'CS /26'),
('172.19.50.192', 'cs-t9-net_(v538)', 2886939331, 2886939389, 'CS /26'),
('172.19.50.64', 'cs-t7-net_(v536)', 2886939203, 2886939261, 'CS /26'),
('172.19.51.0', 'cs-t10-net', 2886939395, 2886939421, 'CS /27'),
('172.19.52.0', 'RESERVED_-_CS_Teaching', 2886939651, 2886939901, 'CS /24'),
('172.19.53.0', 'RESERVED_-_CS_Teaching', 2886939907, 2886940157, 'CS /24'),
('172.19.54.0', 'RESERVED_-_CS_Teaching', 2886940163, 2886940413, 'CS /24'),
('172.19.55.0', 'cs-t11-net_(v539)', 2886940419, 2886940669, 'CS /24'),
('172.19.6.0', '172.19.6.0', 2886927875, 2886928125, 'CS /24'),
('172.19.64.0', '172.19.64.0', 2886942723, 2886946813, 'CS /20'),
('172.19.7.0', '172.19.7.0', 2886928131, 2886928381, 'CS /24'),
('172.19.8.0', '172.19.8.0', 2886928387, 2886928637, 'CS /24'),
('172.19.86.128', 'oat-internal.net', 2886948483, 2886948509, 'CS /27'),
('172.19.9.0', '172.19.9.0', 2886928643, 2886928893, 'CS /24'),
('172.19.96.0', 'dc-cs-research1.net', 2886950915, 2886951165, 'CS /24'),
('172.19.97.0', 'hr-ipmi', 2886951171, 2886951421, 'CS /24'),
('172.19.98.0', 'mr-ipmi', 2886951427, 2886951677, 'CS /24'),
('172.19.99.0', '172.19.99.0', 2886951683, 2886951933, 'CS /24'),
('198.96.155.0', 'ex-iangoldberg.net', 3328219904, 3328219919, 'CS /28');

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

--
-- Table structure for table `aux_ranges_tmp`
--

CREATE TABLE IF NOT EXISTS `aux_ranges_tmp` (
  `id` varchar(247) NOT NULL,
  `name` varchar(247) NOT NULL,
  `start` int(10) unsigned NOT NULL,
  `end` int(10) unsigned NOT NULL,
  `comment` varchar(247) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_ranges_tmp`
--

INSERT INTO `aux_ranges_tmp` (`id`, `name`, `start`, `end`, `comment`) VALUES
('10.0.150.0', 'PHY_1002', 167810563, 167810813, 'CS /24'),
('10.0.151.0', 'DC_3556_ilom', 167810819, 167811069, 'CS /24'),
('10.0.152.0', 'DC_3558', 167811075, 167811325, 'CS /24'),
('10.0.153.0', 'Reserved_RT_572874', 167811331, 167811581, 'CS /24'),
('10.0.154.0', 'MC_3015', 167811587, 167811837, 'CS /24'),
('10.0.155.0', 'M3_3101', 167811843, 167812093, 'CS /24'),
('10.1.1.0', '10.1.1.0', 167837955, 167838205, 'CS /24'),
('10.1.2.0', 'private-cs-san152.net', 167838211, 167838461, 'CS /24'),
('10.1.3.0', '10.1.3.0', 167838467, 167838717, 'CS /24'),
('10.10.150.0', 'CS_Storage_|_PHY_1002', 168465923, 168466173, 'CS /24'),
('10.10.152.0', 'CS_Storage_|_DC_3558', 168466435, 168466685, 'CS /24'),
('10.10.153.0', 'Reserved_RT_572874', 168466691, 168466941, 'CS /24'),
('10.10.154.0', 'CS_Storage_|_MC_3015', 168466947, 168467197, 'CS /24'),
('10.10.155.0', 'CS_Storage_|_M3_3101', 168467203, 168467453, 'CS /24'),
('10.10.83.0', 'istpriwireless.net', 168448771, 168449021, 'CS /24'),
('10.15.0.0', 'cs-dns-park.net', 168755203, 168755709, 'CS /23'),
('10.15.134.0', 'mso-private.net', 168789507, 168789757, 'CS /24'),
('10.15.150.0', 'CS_Server_|_PHY_1002', 168793603, 168793853, 'CS /24'),
('10.15.152.0', 'CS_Server_|_DC_3558', 168794115, 168794365, 'CS /24'),
('10.15.153.0', 'Reserved_RT_572874', 168794371, 168794621, 'CS /24'),
('10.15.154.0', 'CS_Server_|_MC_3015', 168794627, 168794877, 'CS /24'),
('10.15.155.0', 'CS_Server_|_M3_3101', 168794883, 168795133, 'CS /24'),
('10.15.16.0', 'cspriv016net.net', 168759299, 168759549, 'CS /24'),
('10.15.167.0', 'csserver1-mc-private.net', 168797955, 168798077, 'CS /25'),
('10.15.167.128', 'csserver1-dc-private.net', 168798083, 168798205, 'CS /25'),
('10.15.18.0', 'dc-lom.net', 168759811, 168760061, 'CS /24'),
('10.15.2.0', 'dc-sensor.net', 168755715, 168755965, 'CS /24'),
('10.15.28.0', 'mc-lom.net', 168762371, 168762621, 'CS /24'),
('10.15.3.0', 'mc-sensor.net', 168755971, 168756221, 'CS /24'),
('10.15.32.0', 'dc-printer.net', 168763395, 168763645, 'CS /24'),
('10.15.4.0', 'dc-cloud.net', 168756227, 168756477, 'CS /24'),
('10.15.48.0', 'dc-cs-tc1.net', 168767491, 168767741, 'CS /24'),
('10.15.49.0', 'dc-cs-nettop1.net', 168767747, 168767997, 'CS /24'),
('10.15.5.0', 'mc-cloud.net', 168756483, 168756733, 'CS /24'),
('10.15.6.0', 'dc-cscf-dev.net', 168756739, 168756989, 'CS /24'),
('10.15.62.0', 'mc-cs-nettop1.net', 168771075, 168771325, 'CS /24'),
('10.15.63.0', 'mc-cs-tc1.net', 168771331, 168771581, 'CS /24'),
('10.15.64.0', 'dc-rtlab.net', 168771587, 168771837, 'CS /24'),
('10.15.65.0', '10.15.65.0', 168771843, 168772093, 'CS /24'),
('10.15.7.0', 'mc-cscf-dev.net', 168756995, 168757245, 'CS /24'),
('10.15.74.0', '10.15.74.0', 168774147, 168774397, 'CS /24'),
('10.15.75.0', '10.15.75.0', 168774403, 168774653, 'CS /24'),
('10.15.77.0', '10.15.77.0', 168774915, 168775165, 'CS /24'),
('10.15.78.0', '10.15.78.0', 168775171, 168775421, 'CS /24'),
('10.15.79.0', 'mc-rtlab.net', 168775427, 168775677, 'CS /24'),
('10.15.8.0', 'UNUSED', 168757251, 168757277, 'CS /27'),
('10.15.8.128', '10.15.8.128', 168757379, 168757405, 'CS /27'),
('10.15.8.160', '10.15.8.160', 168757411, 168757437, 'CS /27'),
('10.15.8.192', '10.15.8.192', 168757443, 168757469, 'CS /27'),
('10.15.8.224', '10.15.8.224', 168757475, 168757501, 'CS /27'),
('10.15.8.32', '10.15.8.32', 168757283, 168757309, 'CS /27'),
('10.15.8.64', '10.15.8.64', 168757315, 168757341, 'CS /27'),
('10.15.8.96', '10.15.8.96', 168757347, 168757373, 'CS /27'),
('10.15.80.0', 'cspriv080net.net', 168775683, 168775933, 'CS /24'),
('10.20.0.0', 'Campus_eduroam', 169082883, 169148413, 'AUTH /16'),
('10.21.0.0', 'Campus_unsecured', 169148419, 169213949, 'AUTH /16'),
('10.22.0.0', 'Resnet_eduroam', 169213955, 169279485, 'AUTH /16'),
('10.23.0.0', 'Resnet_unsecured', 169279491, 169345021, 'AUTH /16'),
('10.24.0.0', 'SKYNET', 169345027, 169345277, 'AUTH /24'),
('10.24.1.0', 'DEVWiFI2', 169345283, 169345533, 'AUTH /24'),
('10.24.16.0', 'Managed-Wifi-Subnet', 169349123, 169353213, 'AUTH /20'),
('10.24.2.0', 'Games_Institute_Wireless', 169345539, 169345789, 'AUTH /24'),
('10.24.3.0', 'DEVWIFI', 169345795, 169345821, 'AUTH /27'),
('10.24.4.0', 'MAC_DR_network_1_-_MGMT', 169346051, 169346109, 'CR /26'),
('10.24.4.128', 'MAC_DR_network_3_-_Vserver_Data', 169346179, 169346237, 'CR /26'),
('10.24.4.192', 'MAC_DR_network_4', 169346243, 169346301, 'CR /26'),
('10.24.4.64', 'MAC_DR_network_2_-_Inter_Cluster', 169346115, 169346173, 'CR /26'),
('10.4.0.0', '10.4.0.0', 168034307, 168099837, 'CS /16'),
('10.42.1.0', '10.42.1.0', 170524931, 170525181, 'CS /24'),
('10.42.2.0', '10.42.2.0', 170525187, 170525437, 'CS /24'),
('10.97.1.0', '10.97.1.0', 174129411, 174129661, 'CS /24'),
('10.97.10.0', '10.97.10.0', 174131715, 174131965, 'CS /24'),
('10.97.128.0', '10.97.128.0', 174161923, 174162173, 'CS /24'),
('10.98.0.0', '10.98.0.0', 174194691, 174194941, 'MATH /24'),
('129.97.105.0', 'flash-cs.net', 2170644739, 2170644989, 'CS /24'),
('129.97.114.0', 'cgl.net', 2170647043, 2170647293, 'CS /24'),
('129.97.119.128', 'cs-savi.net', 2170648451, 2170648509, 'CS /26'),
('129.97.119.192', 'ripple-admin.net', 2170648515, 2170648573, 'CS /26'),
('129.97.134.0', 'mathstudentorgs.net', 2170652163, 2170652413, 'MATH /24'),
('129.97.15.0', 'cscf.net', 2170621699, 2170621949, 'CS /24'),
('129.97.152.0', 'CS_Server_Public_|_PHY_1002', 2170656768, 2170656783, 'CS /28'),
('129.97.152.112', 'cs-mc-server8', 2170656880, 2170656895, 'CS /28'),
('129.97.152.128', 'cs-mc-server9', 2170656897, 2170656902, 'CS /29'),
('129.97.152.136', 'cs-mc-server10', 2170656905, 2170656910, 'CS /29'),
('129.97.152.144', 'cs-mc-server11', 2170656913, 2170656918, 'CS /29'),
('129.97.152.152', 'cs-mc-server12', 2170656921, 2170656926, 'CS /29'),
('129.97.152.16', 'cs-dc-serverroom-ipv6-test', 2170656784, 2170656799, 'CS /28'),
('129.97.152.160', 'cs-mc-server13', 2170656929, 2170656934, 'CS /29'),
('129.97.152.168', 'cs-mc-server14', 2170656937, 2170656942, 'CS /29'),
('129.97.152.176', 'cs-mc-server15', 2170656945, 2170656950, 'CS /29'),
('129.97.152.184', 'cs-mc-server16', 2170656953, 2170656958, 'CS /29'),
('129.97.152.192', 'cs-mc-server17', 2170656961, 2170656966, 'CS /29'),
('129.97.152.200', 'cs-mc-server18', 2170656969, 2170656974, 'CS /29'),
('129.97.152.208', 'cs-mc-server19', 2170656977, 2170656982, 'CS /29'),
('129.97.152.216', 'cs-mc-server20', 2170656985, 2170656990, 'CS /29'),
('129.97.152.224', 'cs-mc-server21', 2170656993, 2170656998, 'CS /29'),
('129.97.152.232', 'cs-mc-server22', 2170657001, 2170657006, 'CS /29'),
('129.97.152.240', 'cs-mc-server23', 2170657009, 2170657014, 'CS /29'),
('129.97.152.248', 'cs-mc-server24', 2170657017, 2170657022, 'CS /29'),
('129.97.152.32', 'cs-mc-server3', 2170656800, 2170656815, 'CS /28'),
('129.97.152.48', 'cs-mc-server4', 2170656816, 2170656831, 'CS /28'),
('129.97.152.64', 'cs-mc-server5', 2170656832, 2170656847, 'CS /28'),
('129.97.152.80', 'cs-mc-server6', 2170656848, 2170656863, 'CS /28'),
('129.97.152.96', 'cs-mc-server7', 2170656864, 2170656879, 'CS /28'),
('129.97.16.0', 'CS_4th_floor_MC', 2170621955, 2170622077, 'CS /25'),
('129.97.16.192', 'cslab2.net', 2170622147, 2170622205, 'CS /26'),
('129.97.167.0', 'cs-teaching.net', 2170660611, 2170660669, 'CS /26'),
('129.97.167.128', 'cs-anycast.net', 2170660739, 2170660861, 'CS /25'),
('129.97.167.64', 'cs-general.net', 2170660675, 2170660733, 'CS /26'),
('129.97.168.0', 'csclient1.net', 2170660867, 2170661117, 'CS /24'),
('129.97.169.0', 'csclient2.net', 2170661123, 2170661373, 'CS /24'),
('129.97.170.0', 'csclient3.net', 2170661379, 2170661885, 'CS /23'),
('129.97.173.0', 'dc-cs-admin.net', 2170662147, 2170662173, 'CS /27'),
('129.97.173.128', 'cs-dc-nettops.net', 2170662275, 2170662333, 'CS /26'),
('129.97.173.192', 'csg.net', 2170662339, 2170662397, 'CS /26'),
('129.97.173.32', 'csreserve173.net', 2170662179, 2170662205, 'CS /27'),
('129.97.173.64', 'mc-cs-ugrad.net', 2170662211, 2170662269, 'CS /26'),
('129.97.18.16', 'csclub_csc-data.net', 2170622480, 2170622495, 'CS /28'),
('129.97.186.0', 'wheat.net', 2170665475, 2170665725, 'CS /24'),
('129.97.2.184', 'mc-user2', 2170618553, 2170618558, 'AS /29'),
('129.97.242.192', 'bb1-watgamer', 2170680003, 2170680061, 'AS /26'),
('129.97.26.0', 'csresearch2.net', 2170624515, 2170624765, 'CS /24'),
('129.97.34.0', 'mc-lab1.net', 2170626563, 2170626621, 'CS /26'),
('129.97.34.128', 'mc-lab3.net', 2170626691, 2170626749, 'CS /26'),
('129.97.34.192', 'mc-lab4.net', 2170626755, 2170626813, 'CS /26'),
('129.97.34.64', 'mc-lab2.net', 2170626627, 2170626685, 'CS /26'),
('129.97.51.0', 'mclab5-_mc3003', 2170630915, 2170631037, 'CS /25'),
('129.97.51.128', 'mclab6-_mc3005', 2170631043, 2170631101, 'CS /26'),
('129.97.51.192', 'mclab7-_mc3027', 2170631107, 2170631165, 'CS /26'),
('129.97.59.0', 'mclab8-mc3022', 2170632963, 2170633021, 'CS /26'),
('129.97.59.128', 'cs-dc-lab.net', 2170633091, 2170633149, 'CS /26'),
('129.97.59.192', 'sweng-dc-lab.net', 2170633155, 2170633213, 'CS /26'),
('129.97.59.64', 'mclab9-_realtime', 2170633027, 2170633053, 'CS /27'),
('129.97.59.96', 'mclab10-_graphics', 2170633059, 2170633085, 'CS /27'),
('129.97.7.0', 'csresearch1.net', 2170619651, 2170619901, 'CS /24'),
('129.97.74.0', 'cs-untrust.net', 2170636803, 2170637053, 'CS /24'),
('129.97.75.0', 'delegated_to_rcs.uwaterloo.ca', 2170637059, 2170637309, 'CS /24'),
('129.97.84.0', 'csclient.net', 2170639363, 2170639613, 'CS /24'),
('129.97.86.128', 'cs-sr-pub1_(RT_350192)', 2170640003, 2170640029, 'CS /27'),
('172.16.4.128', 'rgmatlab1.net', 2886730881, 2886730886, 'CS /29'),
('172.16.4.136', 'rgmatlab2.net', 2886730889, 2886730894, 'CS /29'),
('172.16.4.144', 'rgmatlab3.net', 2886730897, 2886730902, 'CS /29'),
('172.19.0.0', 'cscore.net', 2886926339, 2886926589, 'CS /24'),
('172.19.1.0', 'mc-cs2-dc-cs2-trk2.net', 2886926593, 2886926594, 'CS /30'),
('172.19.1.100', '172.19.1.100', 2886926693, 2886926694, 'CS /30'),
('172.19.1.104', '172.19.1.104', 2886926697, 2886926698, 'CS /30'),
('172.19.1.108', '172.19.1.108', 2886926701, 2886926702, 'CS /30'),
('172.19.1.112', '172.19.1.112', 2886926705, 2886926706, 'CS /30'),
('172.19.1.116', '172.19.1.116', 2886926709, 2886926710, 'CS /30'),
('172.19.1.12', 'UNUSED', 2886926605, 2886926606, 'CS /30'),
('172.19.1.120', '172.19.1.120', 2886926713, 2886926714, 'CS /30'),
('172.19.1.124', '172.19.1.124', 2886926717, 2886926718, 'CS /30'),
('172.19.1.128', '172.19.1.128', 2886926721, 2886926722, 'CS /30'),
('172.19.1.132', '172.19.1.132', 2886926725, 2886926726, 'CS /30'),
('172.19.1.136', '172.19.1.136', 2886926729, 2886926730, 'CS /30'),
('172.19.1.140', '172.19.1.140', 2886926733, 2886926734, 'CS /30'),
('172.19.1.144', '172.19.1.144', 2886926737, 2886926738, 'CS /30'),
('172.19.1.148', '172.19.1.148', 2886926741, 2886926742, 'CS /30'),
('172.19.1.152', '172.19.1.152', 2886926745, 2886926746, 'CS /30'),
('172.19.1.156', '172.19.1.156', 2886926749, 2886926750, 'CS /30'),
('172.19.1.16', 'dc-cs2-dc-cs1-trk1.net', 2886926609, 2886926610, 'CS /30'),
('172.19.1.160', '172.19.1.160', 2886926753, 2886926754, 'CS /30'),
('172.19.1.164', '172.19.1.164', 2886926757, 2886926758, 'CS /30'),
('172.19.1.168', '172.19.1.168', 2886926761, 2886926762, 'CS /30'),
('172.19.1.172', '172.19.1.172', 2886926765, 2886926766, 'CS /30'),
('172.19.1.176', '172.19.1.176', 2886926769, 2886926770, 'CS /30'),
('172.19.1.180', '172.19.1.180', 2886926773, 2886926774, 'CS /30'),
('172.19.1.184', '172.19.1.184', 2886926777, 2886926778, 'CS /30'),
('172.19.1.188', '172.19.1.188', 2886926781, 2886926782, 'CS /30'),
('172.19.1.192', '172.19.1.192', 2886926785, 2886926786, 'CS /30'),
('172.19.1.196', '172.19.1.196', 2886926789, 2886926790, 'CS /30'),
('172.19.1.20', 'dc-cs1-cs-rt-dc-2303a', 2886926613, 2886926614, 'CS /30'),
('172.19.1.200', '172.19.1.200', 2886926793, 2886926794, 'CS /30'),
('172.19.1.204', '172.19.1.204', 2886926797, 2886926798, 'CS /30'),
('172.19.1.208', '172.19.1.208', 2886926801, 2886926802, 'CS /30'),
('172.19.1.212', '172.19.1.212', 2886926805, 2886926806, 'CS /30'),
('172.19.1.216', '172.19.1.216', 2886926809, 2886926810, 'CS /30'),
('172.19.1.220', '172.19.1.220', 2886926813, 2886926814, 'CS /30'),
('172.19.1.224', '172.19.1.224', 2886926817, 2886926818, 'CS /30'),
('172.19.1.228', '172.19.1.228', 2886926821, 2886926822, 'CS /30'),
('172.19.1.232', '172.19.1.232', 2886926825, 2886926826, 'CS /30'),
('172.19.1.236', '172.19.1.236', 2886926829, 2886926830, 'CS /30'),
('172.19.1.24', 'cs-rt-mc-3015-a-cs-rt-dc-2303a', 2886926617, 2886926618, 'CS /30'),
('172.19.1.240', '172.19.1.240', 2886926833, 2886926834, 'CS /30'),
('172.19.1.244', '172.19.1.244', 2886926837, 2886926838, 'CS /30'),
('172.19.1.248', '172.19.1.248', 2886926841, 2886926842, 'CS /30'),
('172.19.1.252', '172.19.1.252', 2886926845, 2886926846, 'CS /30'),
('172.19.1.28', 'mc-cs2_-_mc-rt-3015-mso-a', 2886926621, 2886926622, 'CS /30'),
('172.19.1.32', 'mc-rt-3015-mso-a_|_dc-rt-3558-mso-a', 2886926625, 2886926626, 'CS /30'),
('172.19.1.36', 'm3-3101-bgp.net', 2886926629, 2886926630, 'CS /30'),
('172.19.1.4', 'mc-cs2-dc-cs1-trk3.net', 2886926597, 2886926598, 'CS /30'),
('172.19.1.40', 'dc-3558-bgp.net', 2886926633, 2886926634, 'CS /30'),
('172.19.1.44', 'mc-3015-bgp.net', 2886926637, 2886926638, 'CS /30'),
('172.19.1.48', '172.19.1.48', 2886926641, 2886926642, 'CS /30'),
('172.19.1.52', '172.19.1.52', 2886926645, 2886926646, 'CS /30'),
('172.19.1.56', '172.19.1.56', 2886926649, 2886926650, 'CS /30'),
('172.19.1.60', '172.19.1.60', 2886926653, 2886926654, 'CS /30'),
('172.19.1.64', '172.19.1.64', 2886926657, 2886926658, 'CS /30'),
('172.19.1.68', '172.19.1.68', 2886926661, 2886926662, 'CS /30'),
('172.19.1.72', '172.19.1.72', 2886926665, 2886926666, 'CS /30'),
('172.19.1.76', '172.19.1.76', 2886926669, 2886926670, 'CS /30'),
('172.19.1.8', 'MSO-RT-MGMT', 2886926601, 2886926602, 'CS /30'),
('172.19.1.80', '172.19.1.80', 2886926673, 2886926674, 'CS /30'),
('172.19.1.84', '172.19.1.84', 2886926677, 2886926678, 'CS /30'),
('172.19.1.88', '172.19.1.88', 2886926681, 2886926682, 'CS /30'),
('172.19.1.92', '172.19.1.92', 2886926685, 2886926686, 'CS /30'),
('172.19.1.96', '172.19.1.96', 2886926689, 2886926690, 'CS /30'),
('172.19.10.0', 'mc-cs-cvl.net', 2886928899, 2886929149, 'CS /24'),
('172.19.100.0', '172.19.100.0', 2886951939, 2886952189, 'CS /24'),
('172.19.101.0', '172.19.101.0', 2886952195, 2886952445, 'CS /24'),
('172.19.102.0', '172.19.102.0', 2886952451, 2886952701, 'CS /24'),
('172.19.103.0', '172.19.103.0', 2886952707, 2886952957, 'CS /24'),
('172.19.104.0', '172.19.104.0', 2886952963, 2886953213, 'CS /24'),
('172.19.105.0', '172.19.105.0', 2886953219, 2886953469, 'CS /24'),
('172.19.106.0', '172.19.106.0', 2886953475, 2886953725, 'CS /24'),
('172.19.107.0', '172.19.107.0', 2886953731, 2886953981, 'CS /24'),
('172.19.108.0', '172.19.108.0', 2886953987, 2886954237, 'CS /24'),
('172.19.109.0', '172.19.109.0', 2886954243, 2886954493, 'CS /24'),
('172.19.11.0', '172.19.11.0', 2886929155, 2886929405, 'CS /24'),
('172.19.110.0', '172.19.110.0', 2886954499, 2886954749, 'CS /24'),
('172.19.111.0', '172.19.111.0', 2886954755, 2886955005, 'CS /24'),
('172.19.112.0', '172.19.112.0', 2886955011, 2886959101, 'CS /20'),
('172.19.12.0', 'dc-cs-cvl.net', 2886929411, 2886929661, 'CS /24'),
('172.19.128.0', 'himrod.net_|_RT_328093', 2886959107, 2886959357, 'CS /24'),
('172.19.129.0', 'cs-srv-mgmt.net', 2886959360, 2886959375, 'CS /28'),
('172.19.13.0', '172.19.13.0', 2886929667, 2886929917, 'CS /24'),
('172.19.134.0', 'Math_Student_Orgs_|_RT_359401_|_RT_594948', 2886960643, 2886960893, 'CS /24'),
('172.19.14.0', '172.19.14.0', 2886929923, 2886930173, 'CS /24'),
('172.19.15.0', 'CS_Server_DC_3558', 2886930179, 2886930205, 'CS /27'),
('172.19.15.128', 'cs-srv-mc.net', 2886930307, 2886930365, 'CS /26'),
('172.19.15.192', 'CS_Server_M3_3101', 2886930371, 2886930429, 'CS /26'),
('172.19.15.32', 'cs-mgmt-m3.net', 2886930208, 2886930223, 'CS /28'),
('172.19.15.64', 'Reserved_RT_572874', 2886930243, 2886930301, 'CS /26'),
('172.19.150.0', 'cs-srv4.net_|_PHY_1002', 2886964739, 2886964989, 'CS /24'),
('172.19.152.0', 'cs-srv4.net_|_DC_3558', 2886965251, 2886965501, 'CS /24'),
('172.19.153.0', 'Reserved_RT_572874', 2886965507, 2886965757, 'CS /24'),
('172.19.154.0', 'cs-srv4.net_|_MC_3015', 2886965763, 2886966013, 'CS /24'),
('172.19.155.0', 'cs-srv4.net_|_M3_3101', 2886966019, 2886966269, 'CS /24'),
('172.19.156.0', 'ripple-data.net', 2886966275, 2886966525, 'CS /24'),
('172.19.157.0', 'ripple-ipmi.net', 2886966531, 2886966653, 'CS /25'),
('172.19.157.128', 'ASIMOV-DEPLOY-DC', 2886966656, 2886966671, 'CS /28'),
('172.19.157.144', 'ASIMOV-DEPLOY-DC-SERVER', 2886966672, 2886966687, 'CS /28'),
('172.19.157.160', 'ASIMOV-DEPLOY-MC', 2886966688, 2886966703, 'CS /28'),
('172.19.157.176', 'ASIMOV-DEPLOY-MC-SERVER', 2886966704, 2886966719, 'CS /28'),
('172.19.157.192', 'ASIMOV-DEPLOY-M3', 2886966720, 2886966735, 'CS /28'),
('172.19.16.0', '172.19.16.0', 2886930435, 2886930685, 'CS /24'),
('172.19.167.0', 'cs-teaching.net', 2886969091, 2886969149, 'CS /26'),
('172.19.167.128', 'cs-anycast.net', 2886969219, 2886969341, 'CS /25'),
('172.19.167.64', 'cs-general.net', 2886969155, 2886969213, 'CS /26'),
('172.19.168.0', 'CSC_Cloud_Mgmt_|_RT_590359', 2886969347, 2886969373, 'CS /27'),
('172.19.168.32', 'CSC_Cloud_Storage', 2886969379, 2886969405, 'CS /27'),
('172.19.173.64', 'mc-ugster-lom', 2886970691, 2886970749, 'CS /26'),
('172.19.18.0', 'cs-dc-syn', 2886930947, 2886931069, 'CS /25'),
('172.19.2.0', '172.19.2.0', 2886926851, 2886927101, 'CS /24'),
('172.19.20.0', 'cs-researchmgmt-mc', 2886931459, 2886931709, 'CS /24'),
('172.19.3.0', '172.19.3.0', 2886927107, 2886927357, 'CS /24'),
('172.19.32.0', 'dc-cs-server1-campus.net', 2886934531, 2886934781, 'CS /24'),
('172.19.33.0', 'dc-cs-printer.net', 2886934787, 2886935037, 'CS /24'),
('172.19.34.0', 'dc-cs-vm1.net', 2886935043, 2886935165, 'CS /25'),
('172.19.34.128', 'mc-cs-vm1.net', 2886935171, 2886935293, 'CS /25'),
('172.19.35.0', '172.19.35.0', 2886935299, 2886935549, 'CS /24'),
('172.19.36.0', '172.19.36.0', 2886935555, 2886935805, 'CS /24'),
('172.19.37.0', '172.19.37.0', 2886935811, 2886936061, 'CS /24'),
('172.19.38.0', '172.19.38.0', 2886936067, 2886936317, 'CS /24'),
('172.19.39.0', '172.19.39.0', 2886936323, 2886936573, 'CS /24'),
('172.19.4.0', '172.19.4.0', 2886927360, 2886927375, 'AS /28'),
('172.19.4.112', '172.19.4.112', 2886927472, 2886927487, 'CS /28'),
('172.19.4.128', 'cs-ups-dc.net', 2886927491, 2886927517, 'CS /27'),
('172.19.4.16', '172.19.4.16', 2886927376, 2886927391, 'AS /28'),
('172.19.4.160', 'cs-mc-ups.net', 2886927523, 2886927549, 'CS /27'),
('172.19.4.192', '172.19.4.192', 2886927555, 2886927581, 'CS /27'),
('172.19.4.224', '172.19.4.224', 2886927587, 2886927613, 'CS /27'),
('172.19.4.32', 'as-sec-dc', 2886927395, 2886927421, 'AS /27'),
('172.19.4.64', '172.19.4.64', 2886927424, 2886927439, 'CS /28'),
('172.19.4.80', '172.19.4.80', 2886927440, 2886927455, 'CS /28'),
('172.19.4.96', '172.19.4.96', 2886927456, 2886927471, 'CS /28'),
('172.19.40.0', 'dc-printer2.net', 2886936579, 2886936829, 'AS /24'),
('172.19.41.0', '172.19.41.0', 2886936835, 2886937085, 'CS /24'),
('172.19.42.0', '172.19.42.0', 2886937091, 2886937341, 'CS /24'),
('172.19.43.0', '172.19.43.0', 2886937347, 2886937597, 'CS /24'),
('172.19.44.0', '172.19.44.0', 2886937603, 2886937853, 'CS /24'),
('172.19.45.0', '172.19.45.0', 2886937859, 2886938109, 'CS /24'),
('172.19.46.0', '172.19.46.0', 2886938115, 2886938365, 'CS /24'),
('172.19.47.0', 'mc-cs-server1-campus.net', 2886938371, 2886938621, 'CS /24'),
('172.19.48.0', 'cs-t1-net_(v530)', 2886938627, 2886938749, 'CS /25'),
('172.19.48.128', 'cs-t2-net_(v531)', 2886938755, 2886938877, 'CS /25'),
('172.19.49.0', 'cs-t3-net_(v532)', 2886938883, 2886939005, 'CS /25'),
('172.19.49.128', 'cs-t4-net_(v533)', 2886939011, 2886939069, 'CS /26'),
('172.19.49.192', 'cs-t5-net_(v534)', 2886939075, 2886939133, 'CS /26'),
('172.19.5.0', 'dc-cs-fw1.net', 2886927617, 2886927622, 'CS /29'),
('172.19.5.104', '172.19.5.104', 2886927721, 2886927726, 'CS /29'),
('172.19.5.112', '172.19.5.112', 2886927729, 2886927734, 'CS /29'),
('172.19.5.120', 'cs-mc-prt', 2886927737, 2886927742, 'CS /29'),
('172.19.5.128', 'cs-net-dc-ap-mgmt.net', 2886927747, 2886927869, 'CS /25'),
('172.19.5.16', 'cs-rt-m3', 2886927633, 2886927638, 'CS /29'),
('172.19.5.24', 'csc-ipmi.net', 2886927641, 2886927646, 'CS /29'),
('172.19.5.32', 'MSO-MGMT-Vlan', 2886927649, 2886927654, 'CS /29'),
('172.19.5.40', '172.19.5.40', 2886927657, 2886927662, 'CS /29'),
('172.19.5.48', '172.19.5.48', 2886927665, 2886927670, 'CS /29'),
('172.19.5.56', '172.19.5.56', 2886927673, 2886927678, 'CS /29'),
('172.19.5.64', '172.19.5.64', 2886927681, 2886927686, 'CS /29'),
('172.19.5.72', '172.19.5.72', 2886927689, 2886927694, 'CS /29'),
('172.19.5.8', 'mc-storage.net', 2886927625, 2886927630, 'CS /29'),
('172.19.5.80', '172.19.5.80', 2886927697, 2886927702, 'CS /29'),
('172.19.5.88', '172.19.5.88', 2886927705, 2886927710, 'CS /29'),
('172.19.5.96', '172.19.5.96', 2886927713, 2886927718, 'CS /29'),
('172.19.50.0', 'cs-t6-net_(v535)', 2886939139, 2886939197, 'CS /26'),
('172.19.50.128', 'cs-t8-net_(v537)', 2886939267, 2886939325, 'CS /26'),
('172.19.50.192', 'cs-t9-net_(v538)', 2886939331, 2886939389, 'CS /26'),
('172.19.50.64', 'cs-t7-net_(v536)', 2886939203, 2886939261, 'CS /26'),
('172.19.51.0', 'cs-t10-net', 2886939395, 2886939421, 'CS /27'),
('172.19.52.0', 'RESERVED_-_CS_Teaching', 2886939651, 2886939901, 'CS /24'),
('172.19.53.0', 'RESERVED_-_CS_Teaching', 2886939907, 2886940157, 'CS /24'),
('172.19.54.0', 'RESERVED_-_CS_Teaching', 2886940163, 2886940413, 'CS /24'),
('172.19.55.0', 'cs-t11-net_(v539)', 2886940419, 2886940669, 'CS /24'),
('172.19.6.0', '172.19.6.0', 2886927875, 2886928125, 'CS /24'),
('172.19.64.0', '172.19.64.0', 2886942723, 2886946813, 'CS /20'),
('172.19.7.0', '172.19.7.0', 2886928131, 2886928381, 'CS /24'),
('172.19.8.0', '172.19.8.0', 2886928387, 2886928637, 'CS /24'),
('172.19.86.128', 'oat-internal.net', 2886948483, 2886948509, 'CS /27'),
('172.19.9.0', '172.19.9.0', 2886928643, 2886928893, 'CS /24'),
('172.19.96.0', 'dc-cs-research1.net', 2886950915, 2886951165, 'CS /24'),
('172.19.97.0', 'hr-ipmi', 2886951171, 2886951421, 'CS /24'),
('172.19.98.0', 'mr-ipmi', 2886951427, 2886951677, 'CS /24'),
('172.19.99.0', '172.19.99.0', 2886951683, 2886951933, 'CS /24'),
('198.96.155.0', 'ex-iangoldberg.net', 3328219904, 3328219919, 'CS /28');

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

--
-- Table structure for table `aux_regions`
--

CREATE TABLE IF NOT EXISTS `aux_regions` (
  `regions` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_regions`
--

INSERT INTO `aux_regions` (`regions`) VALUES
('mfcf.math'),
('general.math'),
('student.math'),
('hood.math'),
('iqc3.math'),
('governor.math'),
('services203.math'),
('services211.math'),
('services215.math'),
('zone9.math'),
('testing.math');

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

--
-- Table structure for table `aux_services`
--

CREATE TABLE IF NOT EXISTS `aux_services` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ServiceName` varchar(75) NOT NULL,
  `Monitored` tinyint(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2752 ;

--
-- Dumping data for table `aux_services`
--

INSERT INTO `aux_services` (`ID`, `ServiceName`, `Monitored`) VALUES
(6, 'Remote Desktop Protocol', 1),
(7, 'Secure Shell', 1),
(8, 'Directory Services', 1),
(9, 'System Health (collectd reqd)', 1),
(10, 'Web Server', 1),
(12, 'Alive (ping)', 1),
(13, 'MySQL', 1),
(14, 'DNS Service', 1),
(15, 'LDAP - CSCF', 1),
(16, 'LDAP - CS-GENERAL', 1),
(17, 'LDAP - CS-TEACHING', 1),
(18, 'Room Environment (Old Websensor)', 1),
(19, 'APC Environmental Unit', 1),
(20, 'APC UPS', 1),
(21, 'GEIST PDU Monitoring', 0),
(522, 'Liebert HVAC Monitoring', 1),
(523, 'Samba', 0),
(524, 'Simple Mail Transfer Protocol', 0),
(525, 'Cups Print Server', 0),
(526, 'Internet Message Access Protocol (IMAP)', 0),
(527, 'File Trnsfer Protocol', 0),
(528, 'Virtual Network Computing', 0),
(530, 'Temperature Monitoring (lmSensors)', 0),
(2747, 'Web Server (SSL)', 0),
(2748, 'DC3556 GEIST GBB100-P', 0),
(2749, 'Eaton Powerware UPS Monitoring', 0),
(2750, 'Dell PowerEdge OpenManage', 0),
(2751, 'HP Health', 0);

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

--
-- Table structure for table `aux_special`
--

CREATE TABLE IF NOT EXISTS `aux_special` (
  `value` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_special`
--

INSERT INTO `aux_special` (`value`) VALUES
('FullSubsidy'),
('GradTerminal'),
('NoSubsidy');

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

--
-- Table structure for table `aux_sponsors`
--

CREATE TABLE IF NOT EXISTS `aux_sponsors` (
  `unit` varchar(8) NOT NULL DEFAULT '',
  `code` varchar(32) NOT NULL DEFAULT '',
  `userid` varchar(32) NOT NULL DEFAULT '',
  `fullName` varchar(64) NOT NULL DEFAULT '',
  `department` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  KEY `unit` (`unit`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `aux_support_class`
--

CREATE TABLE IF NOT EXISTS `aux_support_class` (
  `value` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aux_support_class`
--

INSERT INTO `aux_support_class` (`value`) VALUES
('All'),
('Split'),
('Retired'),
('Dedicated'),
('Contract'),
('None'),
('Desktop');

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

--
-- Table structure for table `aux_used_ip`
--

CREATE TABLE IF NOT EXISTS `aux_used_ip` (
  `ip` bigint(2) NOT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Temporary table for speeding up Free IP in Range drop down list query';


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

--
-- Table structure for table `history`
--

CREATE TABLE IF NOT EXISTS `history` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `pKey` int(11) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `userName` varchar(32) DEFAULT NULL,
  `fieldName` varchar(255) DEFAULT NULL,
  `oldValue` mediumtext,
  `newValue` mediumtext,
  PRIMARY KEY (`id`),
  KEY `pKey` (`pKey`),
  KEY `fieldName` (`fieldName`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=275401 ;

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

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory` (
  `pKey` int(11) NOT NULL AUTO_INCREMENT,
  `accountNumber` varchar(247) DEFAULT NULL,
  `active` varchar(247) DEFAULT 'y',
  `adminContact` varchar(247) DEFAULT NULL,
  `authUser` varchar(247) DEFAULT NULL,
  `barcode` varchar(247) DEFAULT NULL,
  `comments` mediumtext,
  `contractAFF` varchar(247) DEFAULT NULL,
  `contractBegins` date DEFAULT NULL,
  `contractCost` float DEFAULT NULL,
  `contractEnds` date DEFAULT NULL,
  `contractPurchaseOrder` varchar(247) DEFAULT NULL,
  `contractQuoteNumber` varchar(247) DEFAULT NULL,
  `contractVendor` varchar(247) DEFAULT NULL,
  `cpuModel` varchar(247) DEFAULT NULL,
  `description` mediumtext,
  `dns_admin` varchar(247) DEFAULT NULL,
  `dns_contact` varchar(247) DEFAULT NULL,
  `edocsUrl` varchar(250) DEFAULT NULL,
  `entered` date DEFAULT NULL,
  `equipmentType` varchar(247) DEFAULT NULL,
  `fixedAssetTag` varchar(247) DEFAULT NULL,
  `found` date DEFAULT NULL,
  `groups` varchar(247) DEFAULT NULL,
  `hardware` varchar(247) DEFAULT NULL,
  `lastModified` varchar(247) DEFAULT NULL,
  `memory` varchar(247) DEFAULT NULL,
  `model` varchar(247) DEFAULT NULL,
  `numberOfCPUs` int(11) DEFAULT NULL,
  `numberOfCores` int(11) DEFAULT NULL,
  `operatingSystem` varchar(247) DEFAULT NULL,
  `operatingSystemSNMP` varchar(247) DEFAULT NULL,
  `policyEight` varchar(100) NOT NULL DEFAULT 'Restricted',
  `processor` varchar(247) DEFAULT NULL,
  `purchaseCost` varchar(247) DEFAULT NULL,
  `purchaseOrder` varchar(247) DEFAULT NULL,
  `purpose` mediumtext,
  `region` varchar(247) DEFAULT NULL,
  `room` varchar(247) DEFAULT NULL,
  `serialNumber` varchar(247) DEFAULT NULL,
  `special` varchar(247) DEFAULT NULL,
  `speed` varchar(247) DEFAULT NULL,
  `sponsorCode` varchar(32) DEFAULT NULL,
  `subscriptionCode` varchar(247) DEFAULT NULL,
  `supportAFF` varchar(247) DEFAULT NULL,
  `supportBegins` varchar(247) DEFAULT NULL,
  `supportClass` varchar(247) DEFAULT NULL,
  `supportEnds` varchar(247) DEFAULT NULL,
  `systemDescription` varchar(247) DEFAULT NULL,
  `systemDescriptionDate` date DEFAULT NULL,
  `unit` varchar(247) DEFAULT NULL,
  `vendor` varchar(247) DEFAULT NULL,
  `warrantyStart` date DEFAULT NULL,
  `warrantyStop` date DEFAULT NULL,
  `isSaltProvisioned` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is this machine provisioned by salt?',
  `bootpFileLocation` varchar(250) DEFAULT NULL COMMENT 'The bootP File location (pre seed file)',
  `bootpServerLocation` varchar(250) DEFAULT NULL COMMENT 'The booP Server location (pre seed server)',
  `managementHost` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`pKey`),
  UNIQUE KEY `barcode` (`barcode`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ;

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

--
-- Table structure for table `inv_dns`
--

CREATE TABLE IF NOT EXISTS `inv_dns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pKey` int(11) NOT NULL COMMENT 'Foreign Key to inventory table',
  `hostDomainName` varchar(247) NOT NULL DEFAULT '' COMMENT 'host portion of FQDN',
  `domain` varchar(253) NOT NULL DEFAULT '' COMMENT 'domain portion of FQDN',
  `ipAddress` varchar(247) NOT NULL DEFAULT '',
  `macAddressKey` int(11) DEFAULT NULL COMMENT 'Foreign Key to inv_macAddresses table',
  `ipPurpose` varchar(247) NOT NULL DEFAULT '' COMMENT 'fulltext description/purpose',
  `syncWithDns` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=do not sync, 1=sync',
  `dhcp` varchar(1) NOT NULL DEFAULT 'y' COMMENT 'n=dhcp not set, y=dhcp set',
  `vlanTagging` varchar(1) NOT NULL DEFAULT 'n' COMMENT 'n=vlan tagging not set, y=vlan tagging set',
  PRIMARY KEY (`id`),
  KEY `macAddressfKey` (`macAddressKey`),
  KEY `pKey` (`pKey`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='DNS records for inventory associated items' AUTO_INCREMENT=19437 ;

--
-- Dumping data for table `inv_dns`
--

INSERT INTO `inv_dns` (`id`, `pKey`, `hostDomainName`, `domain`, `ipAddress`, `macAddressKey`, `ipPurpose`, `syncWithDns`, `dhcp`, `vlanTagging`) VALUES
(1, 160, '', 'cs.uwaterloo.ca', '', 784, '', 0, 'n', 'n'),
(3, 169, '', 'uwaterloo.ca', '', 229, '', 0, 'n', 'n'),
(4, 170, '', 'uwaterloo.ca', '', 228, '', 0, 'n', 'n'),
(5, 172, '', 'uwaterloo.ca', '', 3196, '', 0, 'n', 'n'),
(6, 173, '', 'uwaterloo.ca', '', 695, '', 0, 'n', 'n'),
(7, 174, '', 'uwaterloo.ca', '', 225, '', 0, 'n', 'n'),
(8, 175, '', 'uwaterloo.ca', '', 224, '', 0, 'n', 'n'),
(15, 199, '', 'uwaterloo.ca', '', 3106, '', 0, 'n', 'n'),
(20, 204, '', 'uwaterloo.ca', '', 232, '', 0, 'n', 'n'),
(21, 205, '', 'uwaterloo.ca', '', 247, '', 0, 'n', 'n'),
(22, 206, '', 'uwaterloo.ca', '', 231, '', 0, 'n', 'n'),
(23, 207, '', 'uwaterloo.ca', '', 230, '', 0, 'n', 'n'),
(24, 208, '', 'uwaterloo.ca', '', 226, '', 0, 'n', 'n'),
(27, 212, '', 'uwaterloo.ca', '', 241, '', 0, 'n', 'n'),
(28, 213, '', 'uwaterloo.ca', '', 234, '', 0, 'n', 'n'),
(29, 214, '', 'uwaterloo.ca', '', 244, '', 0, 'n', 'n'),
(31, 216, '', 'uwaterloo.ca', '', 243, '', 0, 'n', 'n'),
(32, 217, '', 'uwaterloo.ca', '', 235, '', 0, 'n', 'n'),
(34, 219, '', 'uwaterloo.ca', '', 227, '', 0, 'n', 'n'),
(35, 220, '', 'uwaterloo.ca', '', 688, '', 0, 'n', 'n'),
(36, 221, '', 'uwaterloo.ca', '', 238, '', 0, 'n', 'n'),
(37, 222, '', 'uwaterloo.ca', '', 236, '', 0, 'n', 'n'),
(38, 223, 'dccore-exsw22', 'uwaterloo.ca', '129.97.16.122', 242, '', 0, 'n', 'n'),
(40, 226, '', 'uwaterloo.ca', '', 245, '', 0, 'n', 'n'),
(49, 237, '', 'uwaterloo.ca', '', 4377, '', 0, 'n', 'n'),
(50, 238, '', 'uwaterloo.ca', '', 3555, '', 0, 'n', 'n'),
(52, 240, '', 'uwaterloo.ca', '', 4361, '', 0, 'n', 'n'),
(53, 241, '', 'uwaterloo.ca', '', 4365, '', 0, 'n', 'n'),
(54, 242, '', 'uwaterloo.ca', '', 4366, '', 0, 'n', 'n'),
(55, 243, '', 'uwaterloo.ca', '', 4363, '', 0, 'n', 'n'),
(56, 244, '', 'uwaterloo.ca', '', 4369, '', 0, 'n', 'n'),
(57, 245, '', 'uwaterloo.ca', '', 4371, '', 0, 'n', 'n'),
(58, 246, '', 'uwaterloo.ca', '', 4364, '', 0, 'n', 'n'),
(59, 247, '', 'uwaterloo.ca', '', 4379, '', 0, 'n', 'n'),
(60, 248, '', 'uwaterloo.ca', '', 4368, '', 0, 'n', 'n'),
(61, 249, '', 'uwaterloo.ca', '', 4380, '', 0, 'n', 'n'),
(62, 250, '', 'uwaterloo.ca', '', 4372, '', 0, 'n', 'n'),
(63, 251, '', 'uwaterloo.ca', '', 4367, '', 0, 'n', 'n'),
(64, 252, '', 'uwaterloo.ca', '', 4374, '', 0, 'n', 'n'),
(65, 253, '', 'uwaterloo.ca', '', 4362, '', 0, 'n', 'n'),
(66, 254, '', 'uwaterloo.ca', '', 4376, '', 0, 'n', 'n'),
(67, 255, '', 'uwaterloo.ca', '', 4370, '', 0, 'n', 'n'),
(68, 256, '', 'uwaterloo.ca', '', 4373, '', 0, 'n', 'n'),
(69, 257, '', 'uwaterloo.ca', '', 4360, '', 0, 'n', 'n'),
(70, 258, '', 'uwaterloo.ca', '', 3554, '', 0, 'n', 'n'),
(71, 259, '', 'uwaterloo.ca', '', 4375, '', 0, 'n', 'n'),
(74, 265, '', 'cs.uwaterloo.ca', '', 3550, '', 0, 'n', 'n'),
(100, 291, '', 'uwaterloo.ca', '', 3108, '', 0, 'n', 'n'),
(103, 294, '', 'uwaterloo.ca', '', 3107, '', 0, 'n', 'n'),
(104, 295, 'aip2.math', 'uwaterloo.ca', '10.15.74.33', 253, '', 0, 'n', 'n'),
(116, 307, '', 'uwaterloo.ca', '', 704, '', 0, 'n', 'n'),
(122, 313, '', 'uwaterloo.ca', '', 706, '', 0, 'n', 'n'),
(126, 317, 'hyabusa', 'cs.uwaterloo.ca', '129.97.7.50', 595, '', 1, 'y', 'n'),
(127, 318, '', 'uwaterloo.ca', '', 590, '', 0, 'n', 'n'),
(128, 319, 'rebel', 'cs.uwaterloo.ca', '129.97.7.124', 594, '', 1, 'y', 'n'),
(129, 320, '', 'uwaterloo.ca', '', 591, '', 0, 'n', 'n'),
(130, 321, '', 'uwaterloo.ca', '', 596, '', 0, 'n', 'n'),
(139, 330, '', 'uwaterloo.ca', '', 592, '', 0, 'n', 'n'),
(142, 333, '', 'uwaterloo.ca', '', 593, '', 0, 'n', 'n'),
(145, 336, 'fireblade', 'cs.uwaterloo.ca', '10.15.74.117', 597, '', 1, 'y', 'n'),
(146, 337, '', 'uwaterloo.ca', '', 3552, '', 0, 'n', 'n'),
(150, 342, '', 'uwaterloo.ca', '', 271, '', 0, 'n', 'n'),
(152, 344, '', 'uwaterloo.ca', '', 272, '', 0, 'n', 'n'),
(163, 355, '', 'uwaterloo.ca', '', 269, '', 0, 'n', 'n'),
(171, 363, '', 'uwaterloo.ca', '', 268, '', 0, 'n', 'n'),
(183, 376, '', 'uwaterloo.ca', '', 270, '', 0, 'n', 'n'),
(185, 380, '', 'uwaterloo.ca', '', 239, '', 0, 'n', 'n'),
(190, 385, '', 'uwaterloo.ca', '', 356, '', 0, 'n', 'n'),
(192, 387, '', 'uwaterloo.ca', '', 357, '', 0, 'n', 'n'),
(193, 388, 'buzz', 'uwaterloo.ca', '', 354, '', 0, 'n', 'n'),
(196, 391, 'scicom1', 'uwaterloo.ca', '10.15.74.130', 710, '', 0, 'n', 'n'),
(197, 392, '', 'uwaterloo.ca', '', 711, '', 0, 'n', 'n'),
(209, 404, 'bcr10', 'uwaterloo.ca', '129.97.34.125', NULL, '', 0, 'n', 'n'),
(211, 406, 'bcr2', 'uwaterloo.ca', '129.97.34.12', NULL, '', 0, 'n', 'n'),
(213, 408, 'r2d2', 'cs.uwaterloo.ca', '172.19.33.28', NULL, '', 1, 'y', 'n'),
(214, 409, 'bcr12', 'uwaterloo.ca', '129.97.34.126', NULL, '', 0, 'n', 'n'),
(216, 411, '', 'cs.uwaterloo.ca', '', 604, '', 0, 'n', 'n'),
(304, 503, 'spinneret', 'cgl.uwaterloo.ca', '129.97.114.13', NULL, '', 0, 'n', 'n'),
(310, 509, 'orcinus', 'cgl.uwaterloo.ca', '', NULL, '', 0, 'n', 'n'),
(314, 514, 'snug', 'cgl.uwaterloo.ca', '129.97.114.39', NULL, '', 0, 'n', 'n'),
(318, 518, 'veridian', 'cgl.uwaterloo.ca', '129.97.114.154', NULL, '', 0, 'n', 'n'),
(322, 522, 'citrine', 'cgl.uwaterloo.ca', '129.97.114.45', 3542, '', 0, 'n', 'n'),
(337, 537, 'sarc', 'cgl.uwaterloo.ca', '129.97.114.26', 114, '', 0, 'n', 'n'),
(344, 544, 'exhaust', 'cgl.uwaterloo.ca', '129.97.114.51', NULL, '', 0, 'n', 'n'),
(345, 545, 'ahab', 'cgl.uwaterloo.ca', '129.97.114.50', NULL, '', 0, 'n', 'n'),
(346, 546, 'bligh', 'cgl.uwaterloo.ca', '129.97.114.49', NULL, '', 0, 'n', 'n'),
(347, 547, 'esen', 'cgl.uwaterloo.ca', '129.97.114.46', NULL, '', 0, 'n', 'n'),
(487, 979, 'cs-ncd19', 'math', '10.15.78.84', NULL, '', 0, 'n', 'n'),
(543, 1050, 'flax25', 'uwaterloo.ca', '129.97.186.225', NULL, '', 1, 'y', 'n'),
(627, 1150, 'thames', 'uwaterloo.ca', '129.97.105.27', NULL, '', 0, 'n', 'n'),
(629, 1152, '', 'uwaterloo.ca', '', 62, '', 0, 'n', 'n'),
(642, 1171, '', 'uwaterloo.ca', '', 73, '', 0, 'n', 'n'),
(654, 1188, '', 'uwaterloo.ca', '', 3084, '', 0, 'n', 'n'),
(703, 1239, '', 'uwaterloo.ca', '', 4641, '', 0, 'n', 'n'),
(714, 1251, 'spinet', 'uwaterloo.ca', '129.97.114.141', 11, '', 0, 'n', 'n'),
(720, 1257, 'scicom2', 'uwaterloo.ca', '10.15.74.132', 3002, '', 0, 'n', 'n'),
(722, 1259, 'complexity', 'uwaterloo.ca', '129.97.170.22', 112, '', 0, 'n', 'n'),
(734, 1271, '', 'uwaterloo.ca', '', 3528, '', 0, 'n', 'n'),
(738, 1275, '', 'uwaterloo.ca', '', 3099, '', 0, 'n', 'n'),
(739, 1276, 'speed', 'uwaterloo.ca', '10.15.78.58', NULL, '', 1, 'y', 'n'),
(754, 1291, '', 'uwaterloo.ca', '', 3072, '', 0, 'n', 'n'),
(766, 1305, '', 'uwaterloo.ca', '', 448, '', 0, 'n', 'n'),
(775, 1315, '', 'uwaterloo.ca', '', 72, '', 0, 'n', 'n'),
(781, 1321, '', 'uwaterloo.ca', '', 68, '', 0, 'n', 'n'),
(789, 1329, '', 'uwaterloo.ca', '', 264, '', 0, 'n', 'n'),
(793, 1333, '', 'uwaterloo.ca', '', 14, '', 0, 'n', 'n'),
(798, 1338, '', '', '', 3531, '', 0, 'n', 'n'),
(799, 1339, '', 'cs.uwaterloo.ca', '', 3533, '', 0, 'n', 'n'),
(802, 1342, 'optrasc1275n-dc3546', 'uwaterloo.ca', '10.15.77.67', 2311, '', 0, 'n', 'n'),
(803, 1343, '', '', '', 3532, '', 0, 'n', 'n'),
(813, 1353, 'bcr4', 'uwaterloo.ca', '129.97.34.14', NULL, '', 0, 'n', 'n'),
(829, 1370, 'bcr', 'uwaterloo.ca', '129.97.34.144', NULL, '', 0, 'n', 'n'),
(831, 1372, 'canola7', 'uwaterloo.ca', '129.97.186.117', NULL, '', 1, 'y', 'n'),
(843, 1384, 'bryce1', 'math', '10.15.74.230', 3541, '', 0, 'n', 'n'),
(866, 1407, '', 'uwaterloo.ca', '', 3188, '', 0, 'n', 'n'),
(873, 1414, '', 'uwaterloo.ca', '', 116, '', 0, 'n', 'n'),
(878, 1421, 'Old-trurl', 'cs.uwaterloo.ca', '', 3530, '', 0, 'n', 'n'),
(896, 1440, '', 'uwaterloo.ca', '', 658, '', 0, 'n', 'n'),
(897, 1441, '', 'uwaterloo.ca', '', 3071, '', 0, 'n', 'n'),
(899, 1443, '', 'uwaterloo.ca', '', 662, '', 0, 'n', 'n'),
(916, 1460, 'delphina', 'cgl.uwaterloo.ca', '129.97.114.35', NULL, '', 0, 'n', 'n'),
(921, 1465, 'flax1', 'uwaterloo.ca', '129.97.186.201', 3101, '', 1, 'y', 'n'),
(922, 1466, 'flax2', 'uwaterloo.ca', '129.97.186.202', NULL, '', 1, 'y', 'n'),
(923, 1467, '', 'uwaterloo.ca', '', 3096, '', 0, 'n', 'n'),
(924, 1468, 'canola1', 'uwaterloo.ca', '129.97.186.200', 3098, '', 1, 'y', 'n'),
(926, 1470, '', 'uwaterloo.ca', '', 3097, '', 0, 'n', 'n'),
(927, 1471, '', 'uwaterloo.ca', '', 3102, '', 0, 'n', 'n'),
(929, 1473, 'flax9', 'uwaterloo.ca', '129.97.186.209', NULL, '', 1, 'y', 'n'),
(930, 1474, 'flax10', 'uwaterloo.ca', '', 3100, '', 0, 'n', 'n'),
(932, 1476, 'flax23', 'uwaterloo.ca', '', 353, '', 0, 'n', 'n'),
(933, 1477, 'scicom9', 'uwaterloo.ca', '10.15.74.26', NULL, '', 0, 'n', 'n'),
(939, 1484, 'scicom10', 'uwaterloo.ca', '10.15.74.239', 788, '', 0, 'n', 'n'),
(948, 1495, 'beaver', 'uwaterloo.ca', '129.97.105.49', NULL, '', 0, 'n', 'n'),
(950, 1497, 'bear', 'uwaterloo.ca', '129.97.105.225', NULL, '', 1, 'y', 'n'),
(952, 1500, 'styx', 'uwaterloo.ca', '129.97.105.10', NULL, '', 0, 'n', 'n'),
(953, 1501, '', 'uwaterloo.ca', '', 3546, '', 0, 'n', 'n'),
(962, 1510, '', 'math', '', 3545, '', 0, 'n', 'n'),
(978, 1526, '', 'uwaterloo.ca', '', 1185, '', 0, 'n', 'n'),
(979, 1527, '', 'uwaterloo.ca', '', 2983, '', 0, 'n', 'n'),
(996, 1546, '', 'uwaterloo.ca', '', 3197, '', 0, 'n', 'n'),
(1000, 1550, '', 'uwaterloo.ca', '', 3012, '', 0, 'n', 'n'),
(1005, 1555, 'lucky', 'math', '', 3548, '', 0, 'n', 'n'),
(1007, 1558, '', 'uwaterloo.ca', '', 3007, '', 0, 'n', 'n'),
(1012, 1563, '', 'uwaterloo.ca', '', 3016, '', 0, 'n', 'n'),
(1020, 1571, 'diamond', 'uwaterloo.ca', '129.97.34.38', 3017, '', 0, 'n', 'n'),
(1022, 1574, '', 'uwaterloo.ca', '', 3011, '', 0, 'n', 'n'),
(1024, 1576, 'figaro', 'cgl.uwaterloo.ca', '129.97.114.30', NULL, '', 0, 'n', 'n'),
(1041, 1593, '', 'uwaterloo.ca', '', 661, '', 0, 'n', 'n'),
(1046, 1598, '', 'uwaterloo.ca', '', 3003, '', 0, 'n', 'n'),
(1047, 1599, 'lj-dc3334', 'cs.uwaterloo.ca', '172.19.33.253', 1182, '', 1, 'y', 'n'),
(1059, 1611, 'scicom15', 'math', '10.15.75.58', NULL, '', 0, 'n', 'n'),
(1065, 1617, '', 'uwaterloo.ca', '', 3190, '', 0, 'n', 'n'),
(1081, 1633, '', 'uwaterloo.ca', '', 122, '', 0, 'n', 'n'),
(1085, 1637, '', 'uwaterloo.ca', '', 121, '', 0, 'n', 'n'),
(1087, 1639, 'scicom18', 'math', '10.15.75.108', 1143, '', 0, 'n', 'n'),
(1104, 1656, 'lumine', 'cs.uwaterloo.ca', '129.97.168.87', 1184, '', 1, 'y', 'n'),
(1107, 1659, '', 'uwaterloo.ca', '', 3189, '', 0, 'n', 'n'),
(1111, 1663, '', 'uwaterloo.ca', '', 3169, '', 0, 'n', 'n'),
(1114, 1666, '', 'uwaterloo.ca', '', 282, '', 0, 'n', 'n'),
(1124, 1678, '', 'uwaterloo.ca', '', 4378, '', 0, 'n', 'n'),
(1131, 1685, '', 'uwaterloo.ca', '', 3076, '', 0, 'n', 'n'),
(1132, 1686, '', 'uwaterloo.ca', '', 3103, '', 0, 'n', 'n'),
(1133, 1687, '', 'uwaterloo.ca', '', 3079, '', 0, 'n', 'n'),
(1135, 1689, '', 'uwaterloo.ca', '', 3078, '', 0, 'n', 'n'),
(1136, 1690, 'flax17', 'uwaterloo.ca', '', 3077, '', 0, 'n', 'n'),
(1141, 1695, 'bechtel', 'uwaterloo.ca', '129.97.105.29', 486, '', 0, 'n', 'n'),
(1142, 1696, 'bowman', 'uwaterloo.ca', '129.97.105.143', 484, '', 1, 'y', 'n'),
(1143, 1697, 'moffat', 'uwaterloo.ca', '129.97.105.31', 482, '', 0, 'n', 'n'),
(1144, 1698, 'sandrock', 'uwaterloo.ca', '129.97.105.32', 483, '', 0, 'n', 'n'),
(1145, 1699, 'tutton', 'uwaterloo.ca', '129.97.105.33', 485, '', 0, 'n', 'n'),
(1146, 1700, '', 'uwaterloo.ca', '', 506, '', 0, 'n', 'n'),
(1148, 1702, '', 'uwaterloo.ca', '', 507, '', 0, 'n', 'n'),
(1152, 1706, '', 'uwaterloo.ca', '', 257, '', 0, 'n', 'n'),
(1154, 1708, '', 'uwaterloo.ca', '', 3193, '', 0, 'n', 'n'),
(1157, 1712, 'marble', 'cs.uwaterloo.ca', '129.97.84.164', 1183, '', 1, 'y', 'n'),
(1161, 1716, '', 'cs.uwaterloo.ca', '', 287, '', 0, 'n', 'n'),
(1163, 1718, 'scg17', 'cs.uwaterloo.ca', '10.15.75.149', NULL, '', 1, 'y', 'n'),
(1167, 1722, 'scg13', 'cs.uwaterloo.ca', '10.15.75.145', NULL, '', 1, 'y', 'n'),
(1169, 1724, '', 'uwaterloo.ca', '', 288, '', 0, 'n', 'n'),
(1171, 1726, 'sneetch', 'cs.uwaterloo.ca', '10.15.75.135', 286, '', 1, 'y', 'n'),
(1173, 1728, '', 'uwaterloo.ca', '', 254, '', 0, 'n', 'n'),
(1174, 1729, '', 'uwaterloo.ca', '', 709, '', 0, 'n', 'n'),
(1176, 1731, '', 'uwaterloo.ca', '', 707, '', 0, 'n', 'n'),
(1178, 1733, '', 'uwaterloo.ca', '', 708, '', 0, 'n', 'n'),
(1182, 1737, 'baton', 'cs.uwaterloo.ca', '129.97.7.238', 508, '', 1, 'y', 'n'),
(1195, 1752, '', 'uwaterloo.ca', '', 309, '', 0, 'n', 'n'),
(1196, 1753, '', 'uwaterloo.ca', '', 318, '', 0, 'n', 'n'),
(1197, 1754, '', 'uwaterloo.ca', '', 317, '', 0, 'n', 'n'),
(1199, 1756, 'turing', 'cs.uwaterloo.ca', '129.97.186.70', 321, '', 1, 'y', 'n'),
(1201, 1758, 'mesa', 'cs.uwaterloo.ca', '', 319, '', 0, 'n', 'n'),
(1202, 1759, 'awk-old', 'cs.uwaterloo.ca', '', 322, '', 0, 'n', 'n'),
(1203, 1760, '', 'uwaterloo.ca', '', 325, '', 0, 'n', 'n'),
(1204, 1761, '', 'uwaterloo.ca', '', 315, '', 0, 'n', 'n'),
(1205, 1762, '', 'uwaterloo.ca', '', 320, '', 0, 'n', 'n'),
(1206, 1763, '', 'uwaterloo.ca', '', 259, '', 0, 'n', 'n'),
(1207, 1764, '', 'uwaterloo.ca', '', 324, '', 0, 'n', 'n'),
(1209, 1766, 'cavia', 'cs.uwaterloo.ca', '10.15.78.27', NULL, '', 1, 'y', 'n'),
(1210, 1767, 'lj-dc3351', 'uwaterloo.ca', '10.15.75.139', NULL, '', 0, 'n', 'n'),
(1211, 1768, 'graceland', 'uwaterloo.ca', '10.15.167.136', 598, '', 0, 'n', 'n'),
(1213, 1770, '', 'uwaterloo.ca', '', 311, '', 0, 'n', 'n'),
(1214, 1771, '', 'uwaterloo.ca', '', 312, '', 0, 'n', 'n'),
(1215, 1772, '', 'uwaterloo.ca', '', 397, '', 0, 'n', 'n'),
(1216, 1773, '', 'uwaterloo.ca', '', 350, '', 0, 'n', 'n'),
(1217, 1774, '', 'uwaterloo.ca', '', 3015, '', 0, 'n', 'n'),
(1218, 1775, 'db-pc02', 'cs.uwaterloo.ca', '129.97.168.208', 314, '', 1, 'y', 'n'),
(1227, 1785, '', 'uwaterloo.ca', '', 1191, '', 0, 'n', 'n'),
(1230, 1789, 'lexmark-dc2305', 'math', '10.15.74.24', 2312, '', 0, 'n', 'n'),
(1233, 1792, 'finder', 'cs.uwaterloo.ca', '', 1112, '', 0, 'n', 'n'),
(1235, 1794, 'sterling', 'cs.uwaterloo.ca', '129.97.7.39', 741, '', 1, 'y', 'n'),
(1237, 1796, '', 'uwaterloo.ca', '', 293, '', 0, 'n', 'n'),
(1241, 1800, '', 'uwaterloo.ca', '', 292, '', 0, 'n', 'n'),
(1243, 1802, 'emily', 'cs.uwaterloo.ca', '', 294, '', 0, 'n', 'n'),
(1245, 1804, '', 'uwaterloo.ca', '', 290, '', 0, 'n', 'n'),
(1247, 1806, '', 'uwaterloo.ca', '', 291, '', 0, 'n', 'n'),
(1251, 1811, 'dc2560f-lpr', 'uwaterloo.ca', '10.15.2.15', 261, '', 0, 'n', 'n'),
(1252, 1812, '', 'uwaterloo.ca', '', 258, '', 0, 'n', 'n'),
(1253, 1813, '', 'uwaterloo.ca', '', 260, '', 0, 'n', 'n'),
(1256, 1816, '', 'uwaterloo.ca', '', 3018, '', 0, 'n', 'n'),
(1257, 1817, '', '', '', 3524, '', 0, 'n', 'n'),
(1261, 1821, '', 'uwaterloo.ca', '', 3684, '', 0, 'n', 'n'),
(1262, 1822, 'shatner', 'cs.uwaterloo.ca', '', 602, '', 0, 'n', 'n'),
(1264, 1824, 'mathmac76', 'math', '', 513, '', 0, 'n', 'n'),
(1265, 1825, '', 'cs.uwaterloo.ca', '', 663, '', 0, 'n', 'n'),
(1266, 1826, '', 'uwaterloo.ca', '', 671, '', 0, 'n', 'n'),
(1271, 1831, 'cloud9', 'uwaterloo.ca', '10.15.78.70', NULL, '', 0, 'n', 'n'),
(1280, 1840, 'jswang', 'math', '10.15.74.47', 3095, '', 0, 'n', 'n'),
(1283, 1843, '', '', '', 113, '', 0, 'n', 'n'),
(1289, 1849, '', 'uwaterloo.ca', '', 417, '', 0, 'n', 'n'),
(1290, 1850, '', 'uwaterloo.ca', '', 3168, '', 0, 'n', 'n'),
(1292, 1852, '', 'uwaterloo.ca', '', 670, '', 0, 'n', 'n'),
(1300, 1865, '', 'uwaterloo.ca', '', 511, '', 0, 'n', 'n'),
(1309, 1874, '', 'uwaterloo.ca', '', 3006, '', 0, 'n', 'n'),
(1311, 1876, 'geoengine1', 'cs.uwaterloo.ca', '129.97.7.68', 3005, '', 1, 'y', 'n'),
(1312, 1878, 'geoengine2', 'math', '10.15.77.22', NULL, '', 0, 'n', 'n'),
(1314, 1880, '', 'uwaterloo.ca', '', 3004, '', 0, 'n', 'n'),
(1318, 1884, 'juswin', 'cs.uwaterloo.ca', '129.97.168.180', 827, '', 1, 'y', 'n'),
(1320, 1887, '', 'uwaterloo.ca', '', 490, '', 0, 'n', 'n'),
(1324, 1891, '', 'cs.uwaterloo.ca', '', 739, '', 0, 'n', 'n'),
(1325, 1893, '', 'uwaterloo.ca', '', 3069, '', 0, 'n', 'n'),
(1327, 1895, '', 'uwaterloo.ca', '', 3167, '', 0, 'n', 'n'),
(1328, 1896, '', 'uwaterloo.ca', '', 3166, '', 0, 'n', 'n'),
(1330, 1898, 'jessie', 'cs.uwaterloo.ca', '129.97.168.82', 115, '', 1, 'y', 'n'),
(1332, 1900, '', 'uwaterloo.ca', '', 505, '', 0, 'n', 'n'),
(1334, 1903, 'curupira', 'cs.uwaterloo.ca', '129.97.7.84', 3576, '', 1, 'y', 'n'),
(1336, 1905, '', 'cs.uwaterloo.ca', '', 3578, '', 0, 'n', 'n'),
(1337, 1906, '', 'uwaterloo.ca', '', 443, '', 0, 'n', 'n'),
(1341, 1910, '', 'uwaterloo.ca', '', 493, '', 0, 'n', 'n'),
(1343, 1912, 'ddbs1', 'cs.uwaterloo.ca', '129.97.168.100', 495, '', 1, 'y', 'n'),
(1350, 1919, 'genome', 'cs.uwaterloo.ca', '129.97.7.28', 724, '', 1, 'y', 'n'),
(1352, 1921, '', 'uwaterloo.ca', '', 499, '', 0, 'n', 'n'),
(1353, 1922, '', 'uwaterloo.ca', '', 492, '', 0, 'n', 'n'),
(1394, 1980, 'tc037', 'cs.uwaterloo.ca', '10.15.48.37', 3266, '', 1, 'y', 'n'),
(1396, 1982, 'tc036', 'cs.uwaterloo.ca', '10.15.48.36', 3409, '', 1, 'y', 'n'),
(1397, 1983, 'tc039', 'cs.uwaterloo.ca', '10.15.48.39', 3419, '', 1, 'y', 'n'),
(1398, 1984, 'tc032', 'cs.uwaterloo.ca', '10.15.48.32', 3415, '', 0, 'n', 'n'),
(1399, 1985, 'tc051', 'cs.uwaterloo.ca', '10.15.48.51', 3424, '', 1, 'y', 'n'),
(1400, 1986, 'tc048', 'cs.uwaterloo.ca', '10.15.48.48', 3410, '', 1, 'y', 'n'),
(1401, 1987, 'tc056', 'cs.uwaterloo.ca', '10.15.48.56', 3421, '', 1, 'y', 'n'),
(1402, 1988, 'tc069', 'student.cs.uwaterloo.ca', '10.15.63.69', 3416, '', 1, 'y', 'n'),
(1403, 1989, 'tc060', 'cs.uwaterloo.ca', '10.15.48.60', 3423, '', 1, 'y', 'n'),
(1404, 1990, 'tc058', 'student.cs.uwaterloo.ca', '10.15.63.58', 3411, '', 1, 'y', 'n'),
(1405, 1991, '', 'cs.uwaterloo.ca', '', 3412, '', 0, 'n', 'n'),
(1406, 1992, '', 'uwaterloo.ca', '', 3414, '', 0, 'n', 'n'),
(1407, 1993, 'tc035', 'cs.uwaterloo.ca', '10.15.48.35', 3420, '', 1, 'y', 'n'),
(1408, 1994, '', 'uwaterloo.ca', '', 3407, '', 0, 'n', 'n'),
(1409, 1995, '', 'uwaterloo.ca', '', 3408, '', 0, 'n', 'n'),
(1410, 1996, 'tc038', 'cs.uwaterloo.ca', '10.15.48.38', 3417, '', 1, 'y', 'n'),
(1411, 1997, 'tc053', 'cs.uwaterloo.ca', '10.15.48.53', 3422, '', 0, 'n', 'n'),
(1412, 1998, '', 'uwaterloo.ca', '', 3405, '', 0, 'n', 'n'),
(1415, 2001, 'tc052', 'student.cs.uwaterloo.ca', '10.15.63.52', 3454, '', 1, 'y', 'n'),
(1416, 2002, 'tc070', 'cs.uwaterloo.ca', '10.15.48.70', 3435, '', 0, 'n', 'n'),
(1417, 2003, '', 'cs.uwaterloo.ca', '', 3451, '', 0, 'n', 'n'),
(1418, 2004, 'tc030', 'cs.uwaterloo.ca', '10.15.48.30', 3434, '', 1, 'y', 'n'),
(1419, 2005, 'tc075', 'student.cs.uwaterloo.ca', '10.15.63.75', 3440, '', 1, 'y', 'n'),
(1420, 2006, 'tc050', 'cs.uwaterloo.ca', '10.15.48.50', 3429, '', 1, 'y', 'n'),
(1421, 2007, 'tc029', 'cs.uwaterloo.ca', '10.15.48.29', 3450, '', 1, 'y', 'n'),
(1422, 2008, 'tc054', 'cs.uwaterloo.ca', '10.15.48.54', 3445, '', 1, 'y', 'n'),
(1423, 2009, 'tc071', 'cs.uwaterloo.ca', '10.15.48.71', 3453, '', 1, 'y', 'n'),
(1424, 2010, '', 'cs.uwaterloo.ca', '', 3452, '', 0, 'n', 'n'),
(1425, 2011, '', 'cs.uwaterloo.ca', '', 3436, '', 0, 'n', 'n'),
(1426, 2012, '', 'uwaterloo.ca', '', 3441, '', 0, 'n', 'n'),
(1427, 2013, '', 'cs.uwaterloo.ca', '', 3443, '', 0, 'n', 'n'),
(1428, 2014, 'tc071', 'student.cs.uwaterloo.ca', '10.15.63.71', 3444, '', 1, 'y', 'n'),
(1429, 2015, '', 'cs.uwaterloo.ca', '', 3447, '', 0, 'n', 'n'),
(1430, 2016, '', '', '', 3448, '', 0, 'n', 'n'),
(1431, 2017, 'tc094', 'student.cs.uwaterloo.ca', '10.15.63.94', 3446, '', 1, 'y', 'n'),
(1432, 2018, '', 'cs.uwaterloo.ca', '', 3449, '', 0, 'n', 'n'),
(1433, 2019, '', '', '', 3442, '', 0, 'n', 'n'),
(1434, 2020, 'tc056', 'student.cs.uwaterloo.ca', '10.15.63.56', 3418, '', 1, 'y', 'n'),
(1435, 2021, '', '', '', 3425, '', 0, 'n', 'n'),
(1436, 2022, 'tc057', 'cs.uwaterloo.ca', '10.15.48.57', 3426, '', 0, 'n', 'n'),
(1437, 2023, 'tc053', 'student.cs.uwaterloo.ca', '10.15.63.53', 3428, '', 1, 'y', 'n'),
(1438, 2024, '', 'cs.uwaterloo.ca', '', 3430, '', 0, 'n', 'n'),
(1439, 2025, 'tc031', 'cs.uwaterloo.ca', '10.15.48.31', 3431, '', 1, 'y', 'n'),
(1440, 2026, '', 'cs.uwaterloo.ca', '', 3432, '', 0, 'n', 'n'),
(1441, 2027, '', 'uwaterloo.ca', '', 3433, '', 0, 'n', 'n'),
(1442, 2028, '', 'cs.uwaterloo.ca', '', 3438, '', 0, 'n', 'n'),
(1443, 2029, '', 'cs.uwaterloo.ca', '', 3439, '', 0, 'n', 'n'),
(1448, 2035, '', 'uwaterloo.ca', '', 541, '', 0, 'n', 'n'),
(1449, 2037, 'scicom24', 'math', '10.15.75.156', NULL, '', 0, 'n', 'n'),
(1456, 2047, '', '', '', 3427, '', 0, 'n', 'n'),
(1462, 2055, 'fleming', 'math', '10.15.78.78', NULL, '', 0, 'n', 'n'),
(1464, 2057, '', 'uwaterloo.ca', '', 474, '', 0, 'n', 'n'),
(1465, 2058, 'alg21', 'cs.uwaterloo.ca', '', 464, '', 0, 'n', 'n'),
(1466, 2059, 'alg23', 'cs.uwaterloo.ca', '129.97.168.193', 475, '', 1, 'y', 'n'),
(1467, 2060, '', 'uwaterloo.ca', '', 477, '', 0, 'n', 'n'),
(1468, 2061, '', 'uwaterloo.ca', '', 469, '', 0, 'n', 'n'),
(1469, 2062, '', 'uwaterloo.ca', '', 503, '', 0, 'n', 'n'),
(1470, 2063, '', 'uwaterloo.ca', '', 470, '', 0, 'n', 'n'),
(1471, 2064, '', 'uwaterloo.ca', '', 478, '', 0, 'n', 'n'),
(1472, 2065, 'alg35', 'cs.uwaterloo.ca', '', 465, '', 0, 'n', 'n'),
(1473, 2066, 'alg36', 'cs.uwaterloo.ca', '', 472, '', 0, 'n', 'n'),
(1474, 2067, '', 'uwaterloo.ca', '', 476, '', 0, 'n', 'n'),
(1475, 2068, '', 'uwaterloo.ca', '', 479, '', 0, 'n', 'n'),
(1487, 2083, 'scicom25', 'math', '', 467, '', 0, 'n', 'n'),
(1489, 2085, 'scicom26', 'math', '10.15.74.135', 466, '', 0, 'n', 'n'),
(1492, 2090, '', 'uwaterloo.ca', '', 473, '', 0, 'n', 'n'),
(1493, 2092, '', 'uwaterloo.ca', '', 794, '', 0, 'n', 'n'),
(1496, 2098, '', 'uwaterloo.ca', '', 526, '', 0, 'n', 'n'),
(1499, 2102, '', 'uwaterloo.ca', '', 780, '', 0, 'n', 'n'),
(1501, 2104, 'babak', 'cs.uwaterloo.ca', '129.97.7.248', 781, '', 1, 'y', 'n'),
(1504, 2107, '', 'uwaterloo.ca', '', 502, '', 0, 'n', 'n'),
(1506, 2109, '', 'uwaterloo.ca', '', 471, '', 0, 'n', 'n'),
(1509, 2112, 'zipf', 'uwaterloo.ca', '', NULL, '', 0, 'n', 'n'),
(1512, 2116, '', 'uwaterloo.ca', '', 3171, '', 0, 'n', 'n'),
(1514, 2118, '', 'uwaterloo.ca', '', 779, '', 0, 'n', 'n'),
(1516, 2120, 'alg31', 'cs.uwaterloo.ca', '127.0.1.1', NULL, '', 0, 'n', 'n'),
(1517, 2122, '', 'cs.uwaterloo.ca', '', 2165, '', 0, 'n', 'n'),
(1520, 2125, '', 'uwaterloo.ca', '', 504, '', 0, 'n', 'n'),
(1521, 2126, 'huey', 'cgl.uwaterloo.ca', '129.97.114.25', NULL, '', 0, 'n', 'n'),
(1536, 2141, '', 'uwaterloo.ca', '', 715, '', 0, 'n', 'n'),
(1541, 2146, '', 'cs.uwaterloo.ca', '', 605, '', 0, 'n', 'n'),
(1542, 2147, 'scheme', 'math', '129.97.186.75', 2937, '', 0, 'n', 'n'),
(1543, 2148, 'comsim1', 'cs.uwaterloo.ca', '129.97.168.174', 805, '', 1, 'y', 'n'),
(1544, 2149, '', 'uwaterloo.ca', '', 775, '', 0, 'n', 'n'),
(1545, 2150, '', 'uwaterloo.ca', '', 778, '', 0, 'n', 'n'),
(1546, 2151, '', 'uwaterloo.ca', '', 776, '', 0, 'n', 'n'),
(1547, 2153, 'swag02', 'uwaterloo.ca', '129.97.169.4', 777, '', 0, 'n', 'n'),
(1548, 2154, '', 'uwaterloo.ca', '', 774, '', 0, 'n', 'n'),
(1550, 2156, 'lp1csnet', 'cs.uwaterloo.ca', '10.15.74.125', 664, '', 1, 'y', 'n'),
(1551, 2157, 'boitata', 'cs.uwaterloo.ca', '129.97.7.62', 792, '', 1, 'y', 'n'),
(1559, 2165, '', 'uwaterloo.ca', '', 3471, '', 0, 'n', 'n'),
(1561, 2167, '', 'uwaterloo.ca', '', 2883, '', 0, 'n', 'n'),
(1562, 2168, '', 'cscf.uwaterloo.ca', '', 2881, '', 0, 'n', 'n'),
(1563, 2169, '', 'cs.uwaterloo.ca', '', 3468, '', 0, 'n', 'n'),
(1565, 2171, '', 'uwaterloo.ca', '', 3183, '', 0, 'n', 'n'),
(1569, 2176, '', 'uwaterloo.ca', '', 804, '', 0, 'n', 'n'),
(1570, 2177, 'proteome', 'cs.uwaterloo.ca', '129.97.7.161', 798, '', 1, 'y', 'n'),
(1571, 2178, '', 'cs.uwaterloo.ca', '', 802, '', 0, 'n', 'n'),
(1573, 2181, '', '', '', 800, '', 0, 'n', 'n'),

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

--
-- Table structure for table `inv_macAddress`
--

CREATE TABLE IF NOT EXISTS `inv_macAddress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pKey` int(11) NOT NULL,
  `macName` varchar(247) NOT NULL DEFAULT '',
  `macAddress` varchar(247) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pKey` (`pKey`),
  KEY `macAddress` (`macAddress`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='macAddresses associated with the physical network cards attached to inventory items' AUTO_INCREMENT=10627 ;

--
-- Dumping data for table `inv_macAddress`
--

INSERT INTO `inv_macAddress` (`id`, `pKey`, `macName`, `macAddress`) VALUES
(1, 3735, '', '00:50:ba:7c:69:94'),
(2, 11179, '', '00:80:77:7e:0b:7e'),
(3, 12450, '', '00:1f:f3:4e:03:8a'),
(4, 7358, '', '00:00:1a:1a:1f:36'),
(5, 11729, '', '00:00:24:c6:56:18'),
(6, 11954, '', '00:00:24:c6:56:18'),
(7, 8937, '', '00:00:24:c6:56:19'),
(8, 11963, '', '00:00:24:c6:e5:e0'),
(9, 11380, '', '00:00:39:0c:be:9a'),
(10, 16281, 'snmp management card', '00:00:68:1b:83:e9'),
(11, 1251, '', '00:00:a2:68:59:a0'),
(12, 8990, '', '00:00:A7:00:04:A2'),
(13, 5670, '', '00:00:A7:00:BF:6E'),
(14, 1333, '', '00:00:A7:02:24:5C'),
(15, 2873, '', '00:00:A7:02:8E:B2'),
(16, 2871, '', '00:00:A7:02:8E:B8'),
(17, 3498, '', '00:00:A7:04:E7:0C'),
(18, 3502, '', '00:00:A7:04:E7:0E'),
(19, 3504, '', '00:00:A7:04:E7:0F'),
(20, 3496, '', '00:00:A7:04:E7:10'),
(21, 3489, '', '00:00:A7:04:E7:11'),
(22, 3485, '', '00:00:A7:04:E7:12'),
(23, 3507, '', '00:00:A7:04:E7:13'),
(24, 3482, '', '00:00:A7:04:E7:14'),
(25, 3476, '', '00:00:A7:04:E7:15'),
(26, 3480, '', '00:00:A7:04:E7:16'),
(27, 3513, '', '00:00:A7:04:E7:17'),
(28, 3478, '', '00:00:A7:04:E7:18'),
(29, 3477, '', '00:00:A7:04:E7:19'),
(30, 3514, '', '00:00:A7:04:E7:1A'),
(31, 3493, '', '00:00:A7:04:E7:1B'),
(32, 3500, '', '00:00:A7:04:E7:1C'),
(33, 3511, '', '00:00:A7:04:E7:1D'),
(34, 3494, '', '00:00:A7:04:E7:1E'),
(35, 3492, '', '00:00:A7:04:E7:1F'),
(36, 3499, '', '00:00:A7:04:E7:20'),
(37, 3508, '', '00:00:A7:04:E7:21'),
(38, 3488, '', '00:00:A7:04:E7:23'),
(39, 3505, '', '00:00:A7:04:E7:24'),
(40, 3510, '', '00:00:A7:04:E7:25'),
(41, 3479, '', '00:00:A7:04:E7:26'),
(42, 3512, '', '00:00:A7:04:E7:27'),
(43, 3509, '', '00:00:A7:04:E7:28'),
(44, 3503, '', '00:00:A7:04:E7:29'),
(45, 3487, '', '00:00:A7:04:E7:2A'),
(46, 3486, '', '00:00:A7:04:E7:2B'),
(47, 3495, '', '00:00:A7:04:E7:2C'),
(48, 3506, '', '00:00:A7:04:E7:2D'),
(49, 3497, '', '00:00:A7:04:E7:2E'),
(50, 3484, '', '00:00:A7:04:E7:2F'),
(51, 3483, '', '00:00:A7:04:E7:30'),
(52, 3481, '', '00:00:A7:04:E7:31'),
(53, 3501, '', '00:00:A7:04:E7:32'),
(54, 3491, '', '00:00:A7:04:E7:33'),
(55, 3834, '', '00:00:A7:05:44:D1'),
(56, 3835, '', '00:00:A7:05:44:DD'),
(57, 3836, '', '00:00:A7:05:44:F0'),
(58, 9752, '', '00:00:A7:10:11:43'),
(59, 5027, '', '00:00:a7:10:24:2e'),
(60, 8976, '', '00:00:a7:11:a0:06'),
(61, 10087, '', '00:00:A7:12:7F:1C'),
(62, 1152, '', '00:00:A7:12:96:F5'),
(63, 4936, '', '00:00:A7:13:61:A4'),
(64, 2528, '', '00:00:A7:13:6C:07'),
(65, 2515, '', '00:00:A7:13:6C:C7'),
(66, 2523, '', '00:00:A7:13:6D:32'),
(67, 1092, '', '00:00:a7:13:7a:32'),
(68, 1321, '', '00:00:A7:14:83:71'),
(69, 2576, '', '00:00:A7:14:D5:7B'),
(70, 2575, '', '00:00:A7:14:D5:D7'),
(71, 5128, '', '00:00:a7:15:09:d3'),
(72, 1315, '', '00:00:A7:15:60:AF'),
(73, 1171, '', '00:00:A7:15:75:77'),
(74, 9123, '', '00:00:A7:15:77:2F'),
(75, 5740, '', '00:00:A7:15:E3:DA'),
(76, 3571, '', '00:00:A7:1E:04:67'),
(77, 3837, '', '00:00:A7:1F:06:D0'),
(78, 3842, '', '00:00:A7:1F:06:D3'),
(79, 3841, '', '00:00:A7:1F:07:84'),
(80, 3846, '', '00:00:A7:1F:07:8C'),
(81, 3838, '', '00:00:A7:1F:07:D2'),
(82, 3840, '', '00:00:A7:1F:07:D6'),
(83, 3887, '', '00:00:A7:1F:08:02'),
(84, 3891, '', '00:00:A7:1F:0C:82'),
(85, 3850, '', '00:00:A7:1F:1E:3F'),
(86, 4158, '', '00:00:A7:1F:47:34'),
(87, 4159, '', '00:00:A7:1F:47:35'),
(88, 4162, '', '00:00:A7:1F:47:65'),
(89, 3848, '', '00:00:A7:1F:47:79'),
(90, 4160, '', '00:00:A7:1F:47:D8'),
(91, 3844, '', '00:00:A7:1F:48:7F'),
(92, 3890, '', '00:00:A7:1F:48:86'),
(93, 3843, '', '00:00:A7:1F:48:CD'),
(94, 4161, '', '00:00:A7:1F:48:F9'),

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

--
-- Table structure for table `licences`
--

CREATE TABLE IF NOT EXISTS `licences` (
  `lKey` int(11) NOT NULL DEFAULT '0',
  `pKey` int(11) NOT NULL DEFAULT '9',
  `licenceSponsor` varchar(32) DEFAULT NULL,
  `startDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `licenceNumber` varchar(247) DEFAULT NULL,
  `licenceComments` varchar(247) DEFAULT NULL,
  PRIMARY KEY (`lKey`,`pKey`),
  KEY `lKey` (`lKey`),
  KEY `pKey` (`pKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan`
--

CREATE TABLE IF NOT EXISTS `loan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `barcode` varchar(247) NOT NULL,
  `cabinet` varchar(247) NOT NULL DEFAULT 'DC2560g',
  `date_out` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_in` timestamp NULL DEFAULT NULL,
  `given_to` varchar(247) NOT NULL,
  `given_by` varchar(247) NOT NULL,
  `due_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2151 ;

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

--
-- Table structure for table `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `userid` varchar(32) DEFAULT NULL,
  `what` varchar(6) DEFAULT NULL,
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `relations`
--

CREATE TABLE IF NOT EXISTS `relations` (
  `parent` int(11) NOT NULL COMMENT 'The parent inventory item which is a foreign key of the inventory item pkey',
  `child` int(11) NOT NULL COMMENT 'The child inventory item which is a foreign key of the inventory item pkey',
  `type` varchar(12) NOT NULL DEFAULT 'dependency' COMMENT 'The type of relation being used. Either "dependency" or "see-also"',
  UNIQUE KEY `parent_child_type` (`parent`,`child`,`type`),
  KEY `child` (`child`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores the parent-child relationships between two inventory item primary keys.';


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

--
-- Table structure for table `rel_cname_inventory`
--

CREATE TABLE IF NOT EXISTS `rel_cname_inventory` (
  `cname` varchar(50) NOT NULL,
  `pKey` int(11) NOT NULL,
  PRIMARY KEY (`cname`,`pKey`),
  KEY `pKey` (`pKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rel_rt_loan`
--

CREATE TABLE IF NOT EXISTS `rel_rt_loan` (
  `loanId` int(11) NOT NULL,
  `rt` int(11) NOT NULL,
  PRIMARY KEY (`loanId`,`rt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rel_rt_loan`
--

INSERT INTO `rel_rt_loan` (`loanId`, `rt`) VALUES
(2, 78717),
(6, 89956),
(7, 89969),
(16, 90218),
(17, 90199),
(18, 90199),
(19, 90218),
(20, 90210),
(21, 90203),
(22, 90645),
(23, 90784),
(25, 90216),
(26, 72834),
(27, 90950),
(29, 90881),
(30, 88276),
(31, 88276),
(32, 85877),
(33, 85877),
(34, 85877),
(35, 85877),
(36, 91224),
(37, 91153),
(38, 91137),
(39, 89729),
(40, 90196),
(41, 90224),
(42, 90983),
(43, 88334),
(46, 91403),
(47, 91403),
(48, 91454),
(49, 91537),
(51, 91689),
(52, 91697),
(54, 91741),
(55, 91741),
(56, 91763),
(57, 91351),
(58, 91800),
(60, 91830),
(63, 91995),
(64, 92025),
(66, 92032),
(67, 92032),
(68, 92032),
(69, 92156),
(71, 91997),
(72, 92032),
(73, 92032),
(74, 92217),
(75, 92217),
(76, 92205),
(78, 92205),
(79, 92205),
(80, 92206),
(81, 92206),
(82, 92200),
(83, 92200),
(84, 92200),
(85, 92200),
(86, 92200),
(87, 92200),
(88, 92200),
(89, 92240),
(90, 92200),
(91, 92204),
(92, 92204),
(93, 92204),
(94, 92204),
(95, 92204),
(96, 92204),
(97, 92204),
(98, 92204),
(99, 92201),
(100, 92201),
(101, 92201),
(102, 92201),
(103, 92201),
(104, 92201),
(105, 92201),
(106, 92201),
(107, 92201),
(108, 92201),
(109, 92201),
(110, 92201),
(111, 92201),
(112, 92201),
(113, 92201),
(114, 92201),
(115, 92201),
(116, 92201),
(117, 92216),
(118, 92216),
(119, 92216),
(120, 92216),
(121, 92216),
(122, 92216),
(123, 92216),
(124, 92216),
(125, 92216),
(126, 92216),
(127, 92202),
(128, 92202),
(129, 92202),
(130, 92240),
(132, 92249),
(133, 92218),
(135, 92218),
(136, 92218),
(137, 92218),
(138, 92218),
(139, 92218),
(140, 92218),
(141, 92218),
(142, 92218),
(143, 92218),
(144, 92218),
(145, 92218),
(146, 92218),
(147, 92218),
(148, 92218),
(149, 92218),
(150, 92218),
(151, 92218),
(152, 92218),
(153, 92218),
(154, 92218),
(155, 92218),
(156, 92218),
(157, 92201),
(158, 91965),
(159, 92347),
(161, 92513),
(162, 92474),
(163, 92474),
(164, 92474),
(165, 92474),
(166, 92474),
(167, 92474),
(168, 92474),
(169, 92474),
(170, 92474),
(171, 92474),
(172, 92499),
(179, 92525),
(180, 92525),

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

--
-- Table structure for table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Host` int(11) NOT NULL,
  `ServiceName` varchar(75) NOT NULL,
  `Monitored` tinyint(1) NOT NULL,
  `Status` enum('OK','WARNING','UNKNOWN','CRITICAL') CHARACTER SET utf8 DEFAULT 'OK',
  PRIMARY KEY (`ID`),
  KEY `Host` (`Host`),
  KEY `Monitored` (`Monitored`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=592 ;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`ID`, `Host`, `ServiceName`, `Monitored`, `Status`) VALUES
(1, 12394, 'Secure Shell', 0, 'OK'),
(42, 13732, 'Alive (ping)', 1, 'OK'),
(43, 12790, 'Secure Shell', 1, 'OK'),
(44, 12790, 'Web Server', 1, 'OK'),
(45, 12394, 'System Health (collectd reqd)', 0, 'OK'),
(53, 14356, 'Secure Shell', 1, 'OK'),
(54, 13900, 'Secure Shell', 1, 'OK'),
(55, 14262, 'Secure Shell', 1, 'OK'),
(58, 12972, 'Secure Shell', 1, 'OK'),
(59, 12319, 'Alive (ping)', 1, 'OK'),
(62, 12319, 'Web Server', 1, 'OK'),
(64, 15454, 'Web Server', 1, 'OK'),
(66, 15454, 'Secure Shell', 1, 'OK'),
(68, 14209, 'Alive (ping)', 1, 'OK'),
(69, 14210, 'Alive (ping)', 1, 'OK'),
(70, 14236, 'Alive (ping)', 1, 'OK'),
(71, 14237, 'Alive (ping)', 1, 'OK'),
(74, 13732, 'Secure Shell', 1, 'OK'),

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `userid` varchar(32) NOT NULL DEFAULT '',
  `comment` varchar(255) DEFAULT NULL,
  `expires` date NOT NULL DEFAULT '0000-00-00',
  `flags` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `users` (`userid`, `comment`, `expires`, `flags`) VALUES
('test', NULL, '9999-12-31', 'wmda');


--
-- Constraints for dumped tables
--

--
-- Constraints for table `attachments`
--
ALTER TABLE `attachments`
  ADD CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`pKey`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inv_dns`
--
ALTER TABLE `inv_dns`
  ADD CONSTRAINT `inv_dns_ibfk_1` FOREIGN KEY (`pKey`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `inv_dns_ibfk_2` FOREIGN KEY (`macAddressKey`) REFERENCES `inv_macAddress` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `inv_macAddress`
--
ALTER TABLE `inv_macAddress`
  ADD CONSTRAINT `inv_macAddress_ibfk_1` FOREIGN KEY (`pKey`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `licences`
--
ALTER TABLE `licences`
  ADD CONSTRAINT `licences_ibfk_1` FOREIGN KEY (`lKey`) REFERENCES `aux_licences` (`lKey`) ON UPDATE CASCADE,
  ADD CONSTRAINT `licences_ibfk_2` FOREIGN KEY (`pKey`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log`
--
ALTER TABLE `log`
  ADD CONSTRAINT `log_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON UPDATE CASCADE;

--
-- Constraints for table `relations`
--
ALTER TABLE `relations`
  ADD CONSTRAINT `child_fk` FOREIGN KEY (`child`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `parent_fk` FOREIGN KEY (`parent`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rel_cname_inventory`
--
ALTER TABLE `rel_cname_inventory`
  ADD CONSTRAINT `rel_cname_inventory_ibfk_1` FOREIGN KEY (`cname`) REFERENCES `aux_cname` (`cname`) ON UPDATE CASCADE,
  ADD CONSTRAINT `rel_cname_inventory_ibfk_2` FOREIGN KEY (`pKey`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rel_rt_loan`
--
ALTER TABLE `rel_rt_loan`
  ADD CONSTRAINT `rel_rt_loan_ibfk_1` FOREIGN KEY (`loanId`) REFERENCES `loan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_ibfk_1` FOREIGN KEY (`Host`) REFERENCES `inventory` (`pKey`) ON DELETE CASCADE ON UPDATE CASCADE;

