/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `AAAMAPS`
--
DROP TABLE IF EXISTS `AAAMAPS`;
CREATE TABLE `AAAMAPS` (
`id` int(11) NOT NULL,
`authServerName` varchar(255) NOT NULL,
`priority` int(11) NOT NULL,
`elemId` int(11) default NULL,
`domain` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AAAMAPS`
--
/*!40000 ALTER TABLE `AAAMAPS` DISABLE KEYS */;
LOCK TABLES `AAAMAPS` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AAAMAPS` ENABLE KEYS */;
--
-- Table structure for table `AAASERVERS`
--
DROP TABLE IF EXISTS `AAASERVERS`;
CREATE TABLE `AAASERVERS` (
`id` int(11) NOT NULL,
`landscape` double(20,0) default NULL,
`name` varchar(255) NOT NULL,
`netAddr` varchar(255) NOT NULL,
`authPort` int(11) default '1812',
`acctPort` int(11) default NULL,
`secret` varchar(255) default NULL,
`checkUser` varchar(255) default NULL,
`checkPassword` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AAASERVERS`
--
/*!40000 ALTER TABLE `AAASERVERS` DISABLE KEYS */;
LOCK TABLES `AAASERVERS` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AAASERVERS` ENABLE KEYS */;
--
-- Table structure for table `ADMINPROFILE`
--
DROP TABLE IF EXISTS `ADMINPROFILE`;
CREATE TABLE `ADMINPROFILE` (
`id` int(11) NOT NULL,
`name` varchar(255) default NULL,
`landscape` double(20,0) default NULL,
`canCreateBulk` tinyint(4) default NULL,
`canCreateConference` tinyint(4) default NULL,
`canCreateIndividual` tinyint(4) default NULL,
`canSendMessages` tinyint(4) default NULL,
`isKioskMode` tinyint(4) default NULL,
`isAlwaysOn` tinyint(4) default NULL,
`manageAccounts` int(11) default NULL,
`adminProfileObj` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ADMINPROFILE`
--
/*!40000 ALTER TABLE `ADMINPROFILE` DISABLE KEYS */;
LOCK TABLES `ADMINPROFILE` WRITE;
INSERT INTO `ADMINPROFILE` VALUES (1,'Profile_Sample',207380589022,1,1,1,0,0,1,-1,'226com.bsc.guest.AdminProfile131.2111214Profile_Sample14true14true14true15false15false14true121012-112-112-112-112451215219java.util.ArrayList1211111211\014true219java.util.Hashtable10');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ADMINPROFILE` ENABLE KEYS */;
--
-- Table structure for table `AGENTMAC`
--
DROP TABLE IF EXISTS `AGENTMAC`;
CREATE TABLE `AGENTMAC` (
`id` int(11) default NULL,
`landscape` double(20,0) default NULL,
`mac` varchar(255) default NULL,
`description` varchar(255) default NULL,
`version` double(20,0) default NULL,
`ip` varchar(255) default NULL,
KEY `idx_id` (`id`),
KEY `idx_mac` (`mac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTMAC`
--
/*!40000 ALTER TABLE `AGENTMAC` DISABLE KEYS */;
LOCK TABLES `AGENTMAC` WRITE;
INSERT INTO `AGENTMAC` VALUES (1549,207380589022,'20:7C:8F:2F:5D:1B','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.77'),(1549,207380589022,'60:EB:69:46:97:00','Atheros AR8152 PCI-E Fast Ethernet Controller #2',1,NULL),(1550,207380589022,'E4:CE:8F:1D:4A:7C','en1',1,'192.168.101.225'),(1550,207380589022,'C8:2A:14:38:03:1E','en0',1,NULL),(1551,207380589022,'70:F1:A1:91:0E:69','Realtek RTL8191SE 802.11b/g/n WiFi Adapter',1,'192.168.101.153'),(1551,207380589022,'C8:0A:A9:B4:5F:A8','Realtek PCIe FE Family Controller',1,NULL),(1548,207380589022,'00:1C:BF:52:4A:46','Intel(R) PRO/Wireless 3945ABG Network Connection - Packet Scheduler Miniport',1,'192.168.101.200'),(1530,207380589022,'00:1B:38:18:7A:51','Realtek RTL8101 Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1530,207380589022,'00:1B:9E:36:46:37','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.134'),(1548,207380589022,'00:1D:09:A7:00:82','Broadcom NetXtreme 57xx Gigabit Controller - Packet Scheduler Miniport',1,NULL),(1547,207380589022,'78:84:3C:E3:E6:93','Realtek PCIe GBE Family Controller',1,NULL),(1547,207380589022,'64:D4:DA:52:A3:55','Intel(R) Centrino(R) WiMAX 6150',1,NULL),(1547,207380589022,'40:25:C2:27:82:91','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1547,207380589022,'40:25:C2:27:82:90','Intel(R) Centrino(R) Wireless-N 6150',1,'192.168.101.27'),(1546,207380589022,'98:4B:E1:A7:A0:FC','Realtek PCIe FE Family Controller',1,NULL),(1546,207380589022,'AC:81:12:44:FF:E9','Broadcom 4313 802.11b/g/n',1,'192.168.101.135'),(1545,207380589022,'00:A0:D1:D6:A3:8B','Intel(R) PRO/100 VE Network Connection - Packet Scheduler Miniport',1,NULL),(1545,207380589022,'00:04:23:6E:5A:04','Intel(R) PRO/Wireless 2100 LAN 3B Mini PCI Adapter - Packet Scheduler Miniport',1,'192.168.101.203'),(1544,207380589022,'78:E3:B5:50:26:61','Realtek PCIe FE Family Controller',1,NULL),(1544,207380589022,'68:A3:C4:B3:92:D1','Ralink RT5390 802.11b/g/n WiFi Adapter',1,'192.168.101.110'),(1531,207380589022,'5C:AC:4C:26:D3:6B','Broadcom 802.11n Network Adapter',1,'192.168.101.227'),(1531,207380589022,'60:EB:69:0C:F7:B3','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1532,207380589022,'00:25:4B:8C:23:D0','en1',1,'198.248.76.178'),(1532,207380589022,'00:25:4B:AB:F1:18','en0',1,NULL),(1533,207380589022,'00:1B:B1:EC:6D:07','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.107'),(1533,207380589022,'F0:4D:A2:C8:87:7F','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1534,207380589022,'00:90:4B:7E:C0:D0','Dell TrueMobile 1300 WLAN Mini-PCI Card - Packet Scheduler Miniport',1,'192.168.101.250'),(1534,207380589022,'00:0F:1F:A9:1B:84','Intel(R) PRO/100 VE Network Connection - Packet Scheduler Miniport',1,NULL),(1535,207380589022,'00:11:43:B1:C1:CF','Broadcom NetXtreme 57xx Gigabit Controller - Packet Scheduler Miniport',1,'198.248.76.30'),(1536,207380589022,'70:1A:04:2F:FA:77','Realtek RTL8187B Wireless 802.11bg 54Mbps USB 2.0 Network Adapter',1,'192.168.101.247'),(1536,207380589022,'00:26:22:3D:F3:98','Realtek PCIe FE Family Controller',1,NULL),(1537,207380589022,'78:E4:00:0A:52:5F','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.60'),(1537,207380589022,'C8:0A:A9:57:EE:EA','Realtek RTL8102E/RTL8103E Family PCI-E Fast Ethernet NIC (NDIS 6.20)',1,NULL),(1538,207380589022,'00:26:B6:EF:0D:2E','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.112'),(1538,207380589022,'00:26:6C:5D:27:1C','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1539,207380589022,'00:21:00:25:67:30','Broadcom 802.11b/g WLAN',1,'192.168.101.26'),(1539,207380589022,'00:1D:72:5B:FC:4B','NVIDIA nForce Networking Controller',1,NULL),(1539,207380589022,'00:21:86:32:8A:E9','Bluetooth Device (Personal Area Network)',1,NULL),(1540,207380589022,'70:F1:A1:47:E3:CA','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.29'),(1540,207380589022,'00:26:6C:6A:87:5B','Realtek PCIe FE Family Controller',1,NULL),(1541,207380589022,'70:1A:04:D6:F6:5F','Realtek RTL8187SE Wireless LAN PCIE Network Adapter',1,'192.168.101.198'),(1541,207380589022,'00:26:22:FD:D6:E2','Realtek PCIe FE Family Controller',1,NULL),(1542,207380589022,'78:E4:00:43:AB:38','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.9'),(1542,207380589022,'A4:BA:DB:C8:9D:9B','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1543,207380589022,'00:1C:26:2C:64:CE','Dell Wireless 1390 WLAN Mini-Card - Packet Scheduler Miniport',1,'192.168.101.188');
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTMAC` ENABLE KEYS */;
--
-- Table structure for table `AGENTTEST`
--
DROP TABLE IF EXISTS `AGENTTEST`;
CREATE TABLE `AGENTTEST` (
`id` int(11) default NULL,
`landscape` double(20,0) default NULL,
`status` int(11) default NULL,
`category` varchar(255) default NULL,
`test` varchar(255) default NULL,
`type` int(11) default NULL,
`version` double(20,0) default NULL,
KEY `idx_status` (`status`),
KEY `idx_id` (`id`),
KEY `idx_test` (`test`),
KEY `idx_category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTTEST`
--
/*!40000 ALTER TABLE `AGENTTEST` DISABLE KEYS */;
LOCK TABLES `AGENTTEST` WRITE;
INSERT INTO `AGENTTEST` VALUES (1551,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1547,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1547,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1551,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1551,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1551,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1551,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1550,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1549,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1550,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1549,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1549,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1549,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1548,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1549,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1548,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1548,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1548,207380589022,1,'Operating-System','Windows XP',4,1),(1530,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1530,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1530,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1530,207380589022,1,'Operating-System','Windows Vista',4,1),(1547,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1547,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1547,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1546,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1546,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1546,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1546,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1546,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1545,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1545,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1545,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1545,207380589022,1,'Operating-System','Windows XP',4,1),(1544,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1544,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1544,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1544,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1544,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1530,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1531,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1531,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1531,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1531,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1531,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1532,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1532,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1533,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1533,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1533,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1533,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1533,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1534,207380589022,1,'Operating-System','Windows XP',4,1),(1534,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1534,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1534,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1535,207380589022,1,'Operating-System','Windows XP',4,1),(1535,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1535,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1535,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1536,207380589022,1,'Operating-System','Windows 7',4,1),(1536,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1536,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1536,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1536,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1537,207380589022,1,'Operating-System','Windows 7',4,1),(1537,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1537,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1537,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1537,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1538,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1538,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1538,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1538,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1538,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1539,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1539,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1539,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1539,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1539,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1540,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1540,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1540,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1540,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1540,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1541,207380589022,1,'Operating-System','Windows 7',4,1),(1541,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1541,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1541,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1541,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1542,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1542,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1542,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1542,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1542,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1543,207380589022,1,'Operating-System','Windows XP',4,1),(1543,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1543,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1543,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTTEST` ENABLE KEYS */;
--
-- Table structure for table `AGENTTESTRESULT`
--
DROP TABLE IF EXISTS `AGENTTESTRESULT`;
CREATE TABLE `AGENTTESTRESULT` (
`id` int(11) NOT NULL,
`landscape` double(20,0) default NULL,
`status` int(11) default NULL,
`userID` varchar(255) default NULL,
`hostName` varchar(255) default NULL,
`os` varchar(255) default NULL,
`policy` varchar(255) default NULL,
`time` double(20,0) default NULL,
`type` int(11) default NULL,
`version` double(20,0) default NULL,
`location` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTTESTRESULT`
--
/*!40000 ALTER TABLE `AGENTTESTRESULT` DISABLE KEYS */;
LOCK TABLES `AGENTTESTRESULT` WRITE;
INSERT INTO `AGENTTESTRESULT` VALUES (1548,207380589022,1,'mbeagle','HH91','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1310891878754,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1549,207380589022,1,'torrez.ruben','Owner-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1310898303389,4,1,'Huntington AP VLAN Registration'),(1550,207380589022,1,'Orton.Leigha','Leigha-Ortons-MacBook-Pro','Mac OS X 10.6.7','HCC-Users',1310898404210,4,1,'Huntington AP VLAN Registration'),(1551,207380589022,1,'moore.arionne','compaq','Windows 7 Home Premium 6.1','HCC-Users',1310899296826,4,1,'Hearthford AP VLAN Registration'),(1530,207380589022,1,'larrison.daniel','DanielLarris-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1309818333519,4,1,'Hampton AP VLAN Registration'),(1547,207380589022,1,'gormley.kaitlyn','Lynn-VAIO','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1310890731581,4,1,'Huntington AP VLAN Registration'),(1546,207380589022,1,'lawrence.tricia','Owner-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1310883665201,4,1,'Huntington AP VLAN Registration'),(1545,207380589022,1,'Garvin.Aniqueia','OGDRMLABSL1','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1310866174485,4,1,'Huntington AP VLAN Registration'),(1544,207380589022,1,'Hickman.William','Alaina-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1310821606643,4,1,'Enterprise AP VLAN Registration'),(1531,207380589022,1,'gumm.chase','Chase-PC','Windows 7 Home Premium 6.1','HCC-Users',1309821957911,4,1,'Hampton AP VLAN Registration'),(1532,207380589022,1,'jrushing','janette-miller-rushings-macbook','Mac OS X 10.6.7','HCC-Users',1309830583561,4,1,NULL),(1533,207380589022,1,'mezger.tyler','Tyler-PC','Windows 7 Home Premium 6.1','HCC-Users',1309848945623,4,1,'Hampton AP VLAN Registration'),(1534,207380589022,1,'durbin.vanessa','delld505','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1309856433168,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1535,207380589022,1,'jarnold','CT109-0001','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1309895886954,4,1,'CT-MDF1 D2'),(1536,207380589022,1,'reese.erin','ErinReese-PC','Windows 7 Home Premium 6.1','HCC-Users',1309933652804,4,1,'Hearthford AP VLAN Registration'),(1537,207380589022,1,'jones.venson','bigvenny-PC','Windows 7 Home Premium 6.1','HCC-Users',1309942919171,4,1,'Enterprise AP VLAN Registration'),(1538,207380589022,1,'May.Erik','Dixiemay-LT','Windows 7 Home Premium 6.1','HCC-Users',1309944858798,4,1,'Enterprise AP VLAN Registration'),(1539,207380589022,1,'potter.allison','OfficeDepot-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1309948666944,4,1,'Huntington AP VLAN Registration'),(1540,207380589022,1,'sherman.samantha','Rissa-PC','Windows 7 Home Premium 6.1','HCC-Users',1309954383029,4,1,'Huntington AP VLAN Registration'),(1541,207380589022,1,'jones.venson','venny-PC','Windows 7 Home Premium 6.1','HCC-Users',1310012300675,4,1,'Enterprise AP VLAN Registration'),(1542,207380589022,1,'williamson.tyler','aarons-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1310017929329,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1543,207380589022,1,'jpalan','jillian-3637bea','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1310076941610,4,1,'MSM760.Highland.cc.ks.us VLAN 30');
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTTESTRESULT` ENABLE KEYS */;
--
-- Table structure for table `AGENTUPDATE`
--
DROP TABLE IF EXISTS `AGENTUPDATE`;
CREATE TABLE `AGENTUPDATE` (
`hostId` int(11) NOT NULL,
`attempts` int(11) NOT NULL,
`lastKnownVersion` varchar(255) default NULL,
PRIMARY KEY (`hostId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTUPDATE`
--
/*!40000 ALTER TABLE `AGENTUPDATE` DISABLE KEYS */;
LOCK TABLES `AGENTUPDATE` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTUPDATE` ENABLE KEYS */;