/*!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 (1321,207380589022,'00:26:BB:1B:53:18','en1',1,'192.168.101.49'),(1321,207380589022,'64:B9:E8:CE:C9:E6','en0',1,NULL),(1322,207380589022,'78:E4:00:D2:92:F1','Atheros AR5B95 Wireless Network Adapter',1,'192.168.101.239'),(1322,207380589022,'88:AE:1D:12:63:39','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1323,207380589022,'5C:AC:4C:25:ED:1A','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.117'),(1324,207380589022,'70:1A:04:AD:43:D7','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.166'),(1324,207380589022,'00:26:9E:CB:C6:15','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1319,207380589022,'F0:4D:A2:7C:77:58','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1319,207380589022,'70:F1:A1:E0:D4:93','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.245'),(1318,207380589022,'00:26:9E:25:94:AA','Realtek RTL8102E/RTL8103E Family PCI-E Fast Ethernet NIC (NDIS 6.20)',1,NULL),(1318,207380589022,'0C:60:76:0F:04:D0','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.100'),(1317,207380589022,'00:26:08:05:DE:C6','en0',1,NULL),(1317,207380589022,'00:26:BB:00:9A:9F','en1',1,NULL),(1316,207380589022,'00:23:8B:B3:EB:9C','Realtek RTL8102/8103 Family PCI-E FE NIC',1,NULL),(1316,207380589022,'00:24:2C:43:17:03','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.143'),(1327,207380589022,'00:21:63:FC:59:61','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.23'),(1327,207380589022,'00:1E:33:96:F3:37','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1328,207380589022,'00:23:4E:C7:BB:7F','Broadcom 802.11g Network Adapter - Packet Scheduler Miniport',1,'198.248.76.21'),(1328,207380589022,'00:23:8B:75:54:9D','Broadcom NetLink (TM) Fast Ethernet - Packet Scheduler Miniport',1,NULL),(1329,207380589022,'00:1E:4C:77:11:8D','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.129'),(1329,207380589022,'00:1B:24:F5:75:4F','NVIDIA nForce Networking Controller',1,NULL),(1330,207380589022,'70:F1:A1:7C:C1:FE','Realtek RTL8187B Wireless 802.11bg 54Mbps USB 2.0 Network Adapter',1,'192.168.101.95'),(1330,207380589022,'70:5A:B6:C0:F7:18','Realtek PCIe FE Family Controller',1,NULL),(1331,207380589022,'00:22:FA:C9:3F:62','Intel(R) Wireless WiFi Link 5100',1,'192.168.101.176'),(1331,207380589022,'00:23:5A:6F:4D:10','Broadcom NetLink (TM) Fast Ethernet',1,NULL),(1320,207380589022,'B4:82:FE:18:2C:B9','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'198.248.78.182'),(1320,207380589022,'00:26:6C:44:89:AA','Realtek PCIe FE Family Controller',1,NULL),(1314,207380589022,'00:21:00:D9:B7:28','Broadcom 802.11b/g WLAN',1,'164.113.46.152'),(1314,207380589022,'00:23:8B:B4:E0:4B','Realtek RTL8102/8103 Family PCI-E FE NIC',1,NULL),(1313,207380589022,'08:00:46:2E:32:C8','Realtek RTL8139 Family PCI Fast Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1313,207380589022,'00:22:3F:9C:02:00','RangeMax Wireless-N USB Adapter WN111v2 - Packet Scheduler Miniport',1,'192.168.101.130'),(1312,207380589022,'C8:0A:A9:85:78:7D','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(1312,207380589022,'20:7C:8F:03:86:7F','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.183'),(1311,207380589022,'00:23:12:00:68:3F','en1',1,'192.168.101.18'),(1311,207380589022,'00:22:41:36:80:C6','en0',1,NULL),(1310,207380589022,'C8:0A:A9:D5:5A:26','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(1310,207380589022,'70:F1:A1:B2:D9:C2','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.169'),(1309,207380589022,'00:15:C5:13:1D:7D','Broadcom 440x 10/100 Integrated Controller - McAfee Core NDIS Intermediate Filter Miniport',1,'169.254.115.59'),(1309,207380589022,'00:16:6F:87:8C:7D','Intel(R) PRO/Wireless 2200BG Network Connection - McAfee Core NDIS Intermediate Filter Miniport',1,'192.168.101.112'),(1308,207380589022,'00:25:64:3E:7E:3C','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1308,207380589022,'00:22:5F:BB:23:DE','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.22'),(1307,207380589022,'00:24:2C:6E:79:C2','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.15'),(1307,207380589022,'00:1F:16:7E:8E:7C','NVIDIA nForce 10/100/1000 Mbps Networking Controller',1,NULL),(1306,207380589022,'00:27:13:BD:25:2B','Bluetooth Device (Personal Area Network)',1,NULL),(1306,207380589022,'70:5A:B6:A3:20:7F','Realtek PCIe FE Family Controller',1,NULL),(1306,207380589022,'C4:17:FE:A6:7B:35','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.240'),(1305,207380589022,'C8:0A:A9:DC:BF:8D','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(1305,207380589022,'20:7C:8F:21:93:44','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.120'),(1304,207380589022,'00:22:5F:BF:4F:9B','Dell Wireless 1397 WLAN Mini-Card',1,'164.113.44.90'),(1304,207380589022,'00:22:19:F6:AC:62','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1326,207380589022,'00:A0:D1:92:69:0E','Marvell Yukon 88E8039 PCI-E Fast Ethernet Controller',1,NULL),(1325,207380589022,'94:44:52:75:FB:13','Belkin Basic Wireless USB Adapter',1,'192.168.101.163'),(1315,207380589022,'00:26:6C:56:32:40','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1315,207380589022,'00:16:44:66:DD:46','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.98'),(1326,207380589022,'00:16:44:8D:14:31','Realtek RTL8187B Wireless 802.11g 54Mbps USB 2.0 Network Adapter',1,'192.168.101.161'),(1325,207380589022,'00:1C:25:84:36:7E','NVIDIA nForce Networking Controller',1,NULL);
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 (1323,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1324,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1324,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1324,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1324,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1324,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1331,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1331,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1331,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1331,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1331,207380589022,1,'Operating-System','Windows Vista',4,1),(1330,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1330,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1330,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1330,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1330,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1329,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1329,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1329,207380589022,1,'Operating-System','Windows Vista',4,1),(1329,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1329,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1328,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1328,207380589022,1,'Operating-System','Windows XP',4,1),(1328,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1328,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1327,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1327,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1327,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1327,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1323,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1323,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1316,207380589022,1,'Operating-System','Windows Vista',4,1),(1316,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1316,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1316,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1316,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1317,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1317,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1318,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1318,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1318,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1318,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1318,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1319,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1319,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1319,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1319,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1319,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1320,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1320,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1320,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1320,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1320,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1321,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1321,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1322,207380589022,1,'Operating-System','Windows 7',4,1),(1322,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1322,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1322,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1322,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1323,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1323,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1314,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1314,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1314,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1314,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1314,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1313,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1313,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1313,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1313,207380589022,1,'Operating-System','Windows XP',4,1),(1312,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1312,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1312,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1312,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1312,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1311,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1310,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1311,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1310,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1310,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1310,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1310,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1309,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1309,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1309,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1309,207380589022,1,'Operating-System','Windows XP',4,1),(1308,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1308,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1308,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1308,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1308,207380589022,1,'Operating-System','Windows Vista',4,1),(1307,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1307,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1307,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1307,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1307,207380589022,1,'Operating-System','Windows Vista',4,1),(1306,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1306,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1306,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1306,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1306,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1305,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1305,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1305,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1305,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1305,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1304,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1304,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1304,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1304,207380589022,1,'Operating-System','Windows Vista',4,1),(1304,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1327,207380589022,1,'Operating-System','Windows Vista',4,1),(1326,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1326,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1326,207380589022,1,'Operating-System','Windows Vista',4,1),(1326,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1315,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1315,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1315,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1315,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1326,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1315,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1325,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1325,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1325,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1325,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1325,207380589022,1,'Operating-System','Windows Vista',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 (1323,207380589022,1,'Doty.Christine','Calypso','Windows 7 Home Premium 6.1','HCC-users',1286552976482,4,1,NULL),(1324,207380589022,1,'knight.mckensie','Angela-PC','Windows 7 Home Premium 6.1','HCC-users',1286714427968,4,1,NULL),(1327,207380589022,1,'eberly.bryce','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1286872590239,4,1,'HollyOak AP VLAN Registration'),(1328,207380589022,1,'pdonaldson','LENOVO-D8E0F85E','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1287233371368,4,1,NULL),(1329,207380589022,1,'ewing.sean','Cammi-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1287313566300,4,1,NULL),(1330,207380589022,1,'alba.michael','michael-PC','Windows 7 Home Premium 6.1','HCC-users',1287323160577,4,1,NULL),(1331,207380589022,1,'lu.xing','patchbear-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1287331314900,4,1,NULL),(1316,207380589022,1,'williams.Brandon','brandonwilliams','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1286216594548,4,1,NULL),(1315,207380589022,1,'adkins.heather','Heather-PC','Windows 7 Home Premium 6.1','HCC-users',1286186004271,4,1,'Crestview AP VLAN Registration'),(1318,207380589022,1,'volle.billie','JodiVolle-PC','Windows 7 Home Premium 6.1','HCC-users',1286391040603,4,1,'ColonyPoint AP VLAN Registration'),(1317,207380589022,1,'mgilmore','michael-gilmores-macbook-pro','Mac OS X 10.6.3','HCC-users',1286343529856,4,1,NULL),(1321,207380589022,1,'mace.michael','Corey-Momans-MacBook-Pro','Mac OS X 10.6.4','HCC-users',1286453942618,4,1,NULL),(1320,207380589022,1,'hirsch.steven','Owner-PC','Windows 7 Home Premium 6.1','HCC-users',1286434449769,4,1,NULL),(1319,207380589022,1,'gleason.charlotte','charlotte-PC','Windows 7 Home Premium 6.1','HCC-users',1286434443364,4,1,'Ellis-MDF1 27'),(1322,207380589022,1,'kent.kyle','TnP','Windows 7 Starter 6.1','HCC-users',1286458465651,4,1,NULL),(1314,207380589022,1,'schneider.brittany','Nicole-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 1','HCC-users',1286167522765,4,1,NULL),(1313,207380589022,1,'kelley.cody','carla15','Microsoft Windows XP 5.1 Service Pack 2','HCC-users',1286128272549,4,1,NULL),(1312,207380589022,1,'delgado.anais','Anais-PC','Windows 7 Home Premium 6.1','HCC-users',1286097202512,4,1,'HollyOak AP VLAN Registration'),(1311,207380589022,1,'Edmondson.jessica','kelsey-ligmans-macbook','Mac OS X 10.5.8','HCC-users',1286092898696,4,1,NULL),(1310,207380589022,1,'steeby.shaelea','Snow-bunny','Windows 7 Home Premium 6.1','HCC-users',1286041216611,4,1,NULL),(1308,207380589022,1,'korthanke.elizabeth','ENK-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1285840226829,4,1,'Ellis-MDF1 27'),(1309,207380589022,1,'mccartney.mackenzie','mackslaptop','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1286024904363,4,1,'Kiltie-MDF1 11'),(1307,207380589022,1,'chrapkowski.steven','steve-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1285774169909,4,1,NULL),(1306,207380589022,1,'Richardson.Courtney','Courtney-PC','Windows 7 Home Premium 6.1','HCC-users',1285745545427,4,1,'HollyOak AP VLAN Registration'),(1304,207380589022,1,'haynes.blake','Blake-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1285615973279,4,1,'Heritage-MDF1 68'),(1305,207380589022,1,'couvell.luc','Luc-PC','Windows 7 Home Premium 6.1','HCC-users',1285644350898,4,1,NULL),(1325,207380589022,1,'mgilmore','AlanClark-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1286781003612,4,1,NULL),(1326,207380589022,1,'clark.alexy','alexy-PC','Windows Vista (TM) Home Premium 6.0','HCC-users',1286799413644,4,1,'Crestview AP VLAN Registration');
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 */;