/*!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 (1012,207380589022,'00:23:5A:C3:BF:8F','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1011,207380589022,'00:1F:16:D5:6E:17','NVIDIA nForce 10/100/1000 Mbps Networking Controller',1,NULL),(1012,207380589022,'00:26:82:1A:42:3E','Broadcom 802.11b/g WLAN',1,'164.113.44.68'),(1004,207380589022,'00:23:AE:43:8F:71','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1005,207380589022,'00:1B:63:06:78:8A','en1',1,'192.168.101.162'),(1005,207380589022,'00:17:F2:C6:5B:94','en0',1,NULL),(1006,207380589022,'2C:81:58:FB:ED:A2','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.29'),(1006,207380589022,'54:42:49:00:E7:CC','Marvell Yukon 88E8059 PCI-E Gigabit Ethernet Controller',1,NULL),(1007,207380589022,'70:F1:A1:0C:D4:6D','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.126'),(1007,207380589022,'A4:BA:DB:A5:6D:1B','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1008,207380589022,'70:5A:B6:6A:83:4E','Broadcom NetLink (TM) Fast Ethernet',1,'192.168.101.88'),(1008,207380589022,'00:26:82:82:66:DB','Broadcom 802.11g Network Adapter',1,NULL),(1009,207380589022,'00:18:DE:29:9D:C4','Intel(R) PRO/Wireless 3945ABG Network Connection - Packet Scheduler Miniport',1,'192.168.101.134'),(1009,207380589022,'00:15:C5:4A:49:ED','Broadcom NetXtreme 57xx Gigabit Controller - Packet Scheduler Miniport',1,NULL),(1011,207380589022,'00:24:2C:91:97:8A','Atheros AR5007 802.11b/g WiFi Adapter',1,'164.113.44.65'),(1004,207380589022,'00:22:5F:BF:73:04','Dell Wireless 1397 WLAN Mini-Card',1,'164.113.44.163'),(1003,207380589022,'00:23:8B:44:51:11','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1003,207380589022,'00:23:4E:8A:D3:DC','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.223'),(1002,207380589022,'0C:EE:E6:D2:F1:EF','Dell Wireless 1397 WLAN Mini-Card',1,NULL),(1002,207380589022,'00:24:E8:F2:33:3A','Realtek PCIe GBE Family Controller',1,'192.168.101.86'),(998,207380589022,'00:25:64:69:D8:DC','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(999,207380589022,'00:23:12:52:A7:77','en1',1,'192.168.101.234'),(999,207380589022,'00:23:32:CA:0F:40','en0',1,NULL),(1000,207380589022,'00:22:FA:4F:00:AC','Intel(R) Wireless WiFi Link 5100',1,'192.168.101.110'),(1000,207380589022,'00:1E:33:B9:12:D0','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1001,207380589022,'00:22:69:86:4A:12','Atheros AR5B91 Wireless Network Adapter',1,'192.168.101.183'),(1001,207380589022,'00:1E:EC:5A:C0:B2','Broadcom NetXtreme Gigabit Ethernet',1,NULL),(1041,207380589022,'90:4C:E5:57:97:31','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.155'),(1042,207380589022,'1C:4B:D6:73:D5:46','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.46'),(1042,207380589022,'48:5B:39:0F:DA:6C','Atheros AR8121/AR8113/AR8114 PCI-E Ethernet Controller',1,NULL),(1043,207380589022,'00:17:C4:F0:C5:99','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.2'),(1043,207380589022,'70:5A:B6:DB:1C:21','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1044,207380589022,'0C:EE:E6:8C:CB:8F','Broadcom 802.11b/g WLAN',1,'192.168.101.165'),(1044,207380589022,'18:A9:05:8E:21:6B','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1045,207380589022,'1C:4B:D6:C9:EB:26','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.247'),(1045,207380589022,'48:5B:39:65:CF:A2','Atheros AR8121/AR8113/AR8114 PCI-E Ethernet Controller',1,NULL),(1046,207380589022,'00:1F:5B:BB:3E:C9','en1',1,'192.168.101.27'),(1046,207380589022,'00:1F:F3:CA:17:A2','en0',1,NULL),(1047,207380589022,'00:26:C7:1A:34:22','Intel(R) WiFi Link 1000 BGN',1,'192.168.101.123'),(1048,207380589022,'00:24:2B:56:F7:4F','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.182'),(1048,207380589022,'00:1F:16:62:F5:83','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1049,207380589022,'00:26:08:E6:10:F7','en1',1,'192.168.101.248'),(1049,207380589022,'00:26:4A:0F:CB:DC','en0',1,NULL),(1050,207380589022,'78:E7:D1:DB:88:E7','Realtek PCIe GBE Family Controller',1,'192.168.101.246'),(1050,207380589022,'70:F1:A1:59:38:80','Atheros AR9285 802.11b/g/n WiFi Adapter',1,NULL),(1051,207380589022,'00:17:C4:E3:7A:F0','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.52'),(1051,207380589022,'00:26:2D:7F:46:2C','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1052,207380589022,'00:24:2C:49:B3:78','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.36'),(1052,207380589022,'00:23:AE:2E:C3:72','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1010,207380589022,'00:1E:68:71:7A:E5','Realtek RTL8168B/8111B Family PCI-E GBE NIC',1,NULL),(1010,207380589022,'00:1D:E0:3F:80:53','Intel(R) Wireless WiFi Link 4965AGN',1,'198.248.76.124'),(998,207380589022,'70:1A:04:76:77:21','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.50'),(997,207380589022,'00:13:77:5B:36:7F','Marvell Yukon 88E8039 PCI-E Fast Ethernet Controller - ├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜',1,NULL),(997,207380589022,'00:1B:77:B4:7D:B8','Intel(R) PRO/Wireless 3945ABG Network Connection - ├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜├╜',1,'192.168.101.168'),(996,207380589022,'C4:2C:03:1A:40:5B','en0',1,NULL),(996,207380589022,'D8:A2:5E:94:B6:80','en1',1,'192.168.101.235'),(995,207380589022,'B8:AC:6F:54:3C:CA','Realtek PCIe FE Family Controller',1,NULL),(995,207380589022,'70:F1:A1:11:FB:AA','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.70'),(1040,207380589022,'00:0F:B0:C6:B4:50','Realtek RTL8139 Family PCI Fast Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1040,207380589022,'00:14:A5:72:09:7B','Broadcom 802.11b/g WLAN - Packet Scheduler Miniport',1,'192.168.101.53'),(1013,207380589022,'00:22:5F:FC:54:2D','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.195'),(1013,207380589022,'00:26:9E:39:7C:E6','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1014,207380589022,'F0:7B:CB:25:1A:4E','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.147'),(1014,207380589022,'B8:AC:6F:50:37:BE','Realtek PCIe GBE Family Controller',1,NULL),(1015,207380589022,'70:1A:04:5E:71:8B','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.31'),(1015,207380589022,'00:25:64:69:11:20','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1016,207380589022,'D8:A2:5E:8A:FB:9F','en1',1,'192.168.101.139'),(1016,207380589022,'C4:2C:03:08:9D:49','en0',1,NULL),(1017,207380589022,'00:30:65:05:B9:7C','en1',1,'164.113.46.59'),(1017,207380589022,'00:03:93:C3:9B:78','en0',1,NULL),(1018,207380589022,'00:23:14:86:97:A8','Intel(R) Centrino(R) Advanced-N 6200 AGN',1,'192.168.101.189'),(1018,207380589022,'00:23:14:86:97:A9','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1018,207380589022,'B8:AC:6F:6F:51:85','Realtek PCIe GBE Family Controller',1,NULL),(1019,207380589022,'B4:82:FE:56:D8:A3','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.43'),(1019,207380589022,'00:24:54:6C:B1:D4','Marvell Yukon 88E8040 Family PCI-E Fast Ethernet Controller',1,NULL),(1020,207380589022,'00:25:4B:8C:23:D0','en1',1,'172.16.30.62'),(1020,207380589022,'00:25:4B:AB:F1:18','en0',1,NULL),(1021,207380589022,'C4:17:FE:3A:43:9A','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.32'),(1021,207380589022,'00:26:2D:B6:E0:A3','Realtek PCIe FE Family Controller',1,NULL),(1022,207380589022,'48:5B:39:44:2E:21','Atheros AR8121/AR8113/AR8114 PCI-E Ethernet Controller',1,'192.168.101.74'),(1022,207380589022,'1C:4B:D6:98:E6:68','Atheros AR9285 Wireless Network Adapter',1,NULL),(1023,207380589022,'70:1A:04:5E:64:5B','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.3'),(1023,207380589022,'00:25:64:6B:7F:79','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1024,207380589022,'00:24:E8:39:A3:93','Broadcom NetXtreme 57xx Gigabit Controller',1,'192.168.101.199'),(1025,207380589022,'00:26:5E:FC:20:28','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.158'),(1025,207380589022,'00:24:BE:45:FC:E0','Marvell Yukon 88E8057 PCI-E Gigabit Ethernet Controller',1,NULL),(1026,207380589022,'00:21:00:D4:6E:44','Broadcom 4322AG 802.11a/b/g/draft-n Wi-Fi Adapter',1,'192.168.101.138'),(1026,207380589022,'00:23:5A:3D:F4:6E','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1027,207380589022,'00:1D:72:E4:5F:76','Generic Marvell Yukon 88E8071 based Ethernet Controller',1,'192.168.101.111'),(1027,207380589022,'00:23:4E:66:6A:C8','Atheros AR5B91 Wireless Network Adapter',1,'164.113.46.100'),(1028,207380589022,'00:21:6B:D2:48:02','Intel(R) WiFi Link 5100 AGN',1,'164.113.46.104'),(1028,207380589022,'00:23:54:83:79:3D','Broadcom NetLink (TM) Fast Ethernet',1,NULL),(1029,207380589022,'00:23:AE:43:8E:65','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,'192.168.101.81'),(1029,207380589022,'00:22:5F:B5:3E:06','Dell Wireless 1397 WLAN Mini-Card',1,NULL),(1030,207380589022,'00:21:00:10:39:2B','Broadcom 802.11b/g WLAN',1,'192.168.101.97'),(1030,207380589022,'00:1E:EC:2B:58:D4','Intel(R) PRO/100 VE Network Connection',1,NULL),(1031,207380589022,'00:21:00:01:C5:B1','Broadcom 802.11b/g WLAN',1,'192.168.101.228'),(1031,207380589022,'00:1E:68:2A:AC:E4','NVIDIA nForce Networking Controller',1,NULL),(1032,207380589022,'70:F1:A1:35:5D:2D','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.179'),(1032,207380589022,'A4:BA:DB:B3:F7:74','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1033,207380589022,'00:1E:64:78:52:8C','Intel(R) WiFi Link 1000 BGN',1,'192.168.101.237'),(1034,207380589022,'D8:A2:5E:8C:66:11','en1',1,'192.168.101.128'),(1034,207380589022,'C4:2C:03:15:1F:B0','en0',1,NULL),(1035,207380589022,'00:24:2B:92:E1:94','Atheros AR9281 Wireless Network Adapter',1,'192.168.101.149'),(1035,207380589022,'00:23:8B:90:A0:6A','Marvell Yukon 88E8040T PCI-E Fast Ethernet Controller',1,NULL),(1036,207380589022,'00:24:2B:B8:C3:7F','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.187'),(1036,207380589022,'00:1F:16:70:B5:3B','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1037,207380589022,'00:23:54:2E:0A:8D','NVIDIA nForce 10/100 Mbps Ethernet',1,'192.168.101.174'),(1038,207380589022,'00:25:D3:F4:1F:BB','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.180'),(1038,207380589022,'E0:CB:4E:68:13:BB','JMicron PCI Express Gigabit Ethernet Adapter',1,NULL),(1039,207380589022,'00:24:2C:3A:8C:1A','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.4'),(1039,207380589022,'00:1F:16:7C:A4:F9','NVIDIA nForce 10/100/1000 Mbps Networking Controller',1,NULL),(1053,207380589022,'F0:7B:CB:3D:BB:9A','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.94'),(1053,207380589022,'00:24:54:80:1E:10','Marvell Yukon 88E8040 Family PCI-E Fast Ethernet Controller',1,NULL),(1054,207380589022,'78:E4:00:4C:37:CC','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.239'),(1054,207380589022,'C8:0A:A9:96:5A:37','Realtek PCIe FE Family Controller',1,NULL),(1055,207380589022,'00:22:FA:A3:6D:94','Intel(R) WiFi Link 5100 AGN',1,'192.168.101.40'),(1055,207380589022,'00:1F:16:7A:F6:40','Realtek PCIe FE Family Controller',1,NULL),(1056,207380589022,'D8:D3:85:37:BF:F2','Marvell Yukon 88E8072 PCI-E Gigabit Ethernet Controller',1,'192.168.101.8'),(1056,207380589022,'78:E4:00:82:F5:76','Atheros AR9285 802.11b/g/n WiFi Adapter',1,NULL),(1057,207380589022,'00:25:D3:EA:20:8F','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.1'),(1057,207380589022,'E0:CB:4E:92:28:91','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1058,207380589022,'70:1A:04:27:07:61','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.38'),(1058,207380589022,'70:5A:B6:44:C4:7C','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1059,207380589022,'90:4C:E5:B4:75:34','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.13'),(1059,207380589022,'70:5A:B6:8B:07:EE','Realtek PCIe FE Family Controller',1,NULL),(1060,207380589022,'00:23:14:B5:12:40','Intel(R) Centrino(R) Advanced-N 6200 AGN',1,'192.168.101.64'),(1060,207380589022,'00:23:14:B5:12:41','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1060,207380589022,'88:AE:1D:3F:F1:55','Realtek PCIe FE Family Controller',1,NULL),(1061,207380589022,'00:25:64:52:C8:DB','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,'192.168.101.85'),(1061,207380589022,'00:22:5F:E5:F7:4D','Dell Wireless 1397 WLAN Mini-Card',1,NULL),(1062,207380589022,'00:22:69:61:BF:59','Dell Wireless 1395 WLAN Mini-Card',1,'192.168.101.164'),(1062,207380589022,'00:21:9B:E6:5B:BC','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1063,207380589022,'00:25:56:94:EF:A5','Broadcom 802.11b/g WLAN',1,'192.168.101.57'),(1063,207380589022,'00:23:8B:D0:8B:9B','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1064,207380589022,'00:17:C4:45:AF:A8','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.202'),(1064,207380589022,'00:21:70:81:23:D1','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',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 (1012,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1012,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1012,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1012,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1012,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1011,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1006,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1003,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1004,207380589022,1,'Operating-System','Windows Vista',4,1),(1004,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1004,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1004,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1004,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1005,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1005,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1006,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1006,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1006,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1006,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1003,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1003,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1003,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1003,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1002,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1002,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1002,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1002,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1002,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1001,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1001,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1001,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1001,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1011,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1011,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1011,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1011,207380589022,1,'Operating-System','Windows Vista',4,1),(1009,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1009,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1009,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1009,207380589022,1,'Operating-System','Windows XP',4,1),(1008,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1008,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1008,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1008,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1008,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1007,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1007,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1007,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1007,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1007,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1052,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1052,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1052,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1052,207380589022,1,'Operating-System','Windows Vista',4,1),(1052,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1051,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1051,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1051,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1051,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1051,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1050,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1050,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1050,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1050,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1049,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1050,207380589022,1,'Operating-System','Windows 7',4,1),(1049,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1048,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1048,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1048,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1048,207380589022,1,'Operating-System','Windows Vista',4,1),(1048,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1047,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1047,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1047,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1047,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1047,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1046,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1045,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1046,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1045,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1045,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1045,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1045,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1044,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1044,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1044,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1044,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1043,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1044,207380589022,1,'Operating-System','Windows 7',4,1),(1043,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1043,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1043,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1043,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1042,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1042,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1042,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1042,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1042,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1041,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1041,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1041,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1041,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1010,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1010,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1010,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1010,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1010,207380589022,1,'Operating-System','Windows Vista',4,1),(1001,207380589022,1,'Operating-System','Windows Vista',4,1),(1000,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1000,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1000,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1000,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1000,207380589022,1,'Operating-System','Windows Vista',4,1),(999,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(999,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(998,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(998,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(998,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(998,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(998,207380589022,1,'Operating-System','Windows 7 x64',4,1),(997,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(997,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(997,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(997,207380589022,1,'Operating-System','Windows XP',4,1),(996,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(996,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(995,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(995,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(995,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(995,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(995,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1041,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1040,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1040,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1040,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1040,207380589022,1,'Operating-System','Windows XP',4,1),(1013,207380589022,1,'Operating-System','Windows 7',4,1),(1013,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1013,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1013,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1013,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1014,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1014,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1014,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1014,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1014,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1015,207380589022,1,'Operating-System','Windows Vista',4,1),(1015,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1015,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1015,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1015,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1016,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1016,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1017,207380589022,1,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(1017,207380589022,1,'Operating-System','OS X Tiger Update',4,1),(1018,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1018,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1018,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1018,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1018,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1019,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1019,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1019,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1019,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1019,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1020,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1020,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1021,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1021,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1021,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1021,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1021,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1022,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1022,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1022,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1022,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1022,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1023,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1023,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1023,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1023,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1023,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1024,207380589022,1,'Operating-System','Windows XP',4,1),(1024,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1024,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1024,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1025,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1025,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1025,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1025,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1025,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1026,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1026,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1026,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1026,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1026,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1027,207380589022,1,'Operating-System','Windows Vista',4,1),(1027,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1027,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1027,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1027,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1028,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1028,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1028,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1028,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1028,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1029,207380589022,1,'Operating-System','Windows Vista',4,1),(1029,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1029,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1029,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1029,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1030,207380589022,1,'Operating-System','Windows Vista',4,1),(1030,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1030,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1030,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1030,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1031,207380589022,1,'Operating-System','Windows Vista',4,1),(1031,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1031,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1031,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1031,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1032,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1032,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1032,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1032,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1032,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1033,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1033,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1033,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1033,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1033,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1034,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1034,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1035,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1035,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1035,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1035,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1035,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1036,207380589022,1,'Operating-System','Windows Vista',4,1),(1036,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1036,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1036,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1036,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1037,207380589022,1,'Operating-System','Windows 7',4,1),(1037,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1037,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1037,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1037,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1038,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1038,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1038,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1038,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1038,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1039,207380589022,1,'Operating-System','Windows Vista',4,1),(1039,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1039,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1039,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1039,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1053,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1053,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1053,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1053,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1053,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1054,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1054,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1054,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1054,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1054,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1055,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1055,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1055,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1055,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1055,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1056,207380589022,1,'Operating-System','Windows 7',4,1),(1056,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1056,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1056,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1056,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1057,207380589022,1,'Operating-System','Windows 7',4,1),(1057,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1057,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1057,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1057,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1058,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1058,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1058,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1058,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1058,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1059,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1059,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1059,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1059,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1059,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1060,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1060,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1060,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1060,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1060,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1061,207380589022,1,'Operating-System','Windows Vista',4,1),(1061,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1061,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1061,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1061,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1062,207380589022,1,'Operating-System','Windows 7',4,1),(1062,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1062,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1062,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1062,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1063,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1063,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1063,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1063,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1063,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1064,207380589022,1,'Operating-System','Windows Vista',4,1),(1064,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1064,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1064,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1064,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',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 (1015,207380589022,1,'Alderson.Tori','tori-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1280847391400,4,1,NULL),(1004,207380589022,1,'sperfslage.julie','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1280422138792,4,1,NULL),(1005,207380589022,1,'anderson.callene','admins-MacBook-Pro-17','Mac OS X 10.6.4','HCC-users',1280424542173,4,1,NULL),(1006,207380589022,1,'montes.eruviel','BBY00613E0001GO','Windows 7 Home Premium 6.1','HCC-users',1280426697493,4,1,'Piper AP VLAN Registration'),(1007,207380589022,1,'chance.kaleb','Kalebs-PC','Windows 7 Home Premium 6.1','HCC-users',1280665757070,4,1,NULL),(1003,207380589022,1,'Sobotka.Erin','HP_Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1280406148355,4,1,NULL),(1000,207380589022,1,'tittel.rebecca','User-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1280338858071,4,1,NULL),(1001,207380589022,1,'gardner.gelia','Gelia-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1280376069042,4,1,NULL),(1002,207380589022,1,'rodgers.alex','JesusReigns-PC','Windows 7 Ultimate 6.1','HCC-users',1280396335322,4,1,'Rubeti-MDF1 17'),(1014,207380589022,1,'Cole.Alison','Alison-PC','Windows 7 Home Premium 6.1','HCC-users',1280846771849,4,1,'Hearthford AP VLAN Registration'),(1013,207380589022,1,'marshall.adam','Adam-PC','Windows 7 Home Premium 6.1','HCC-users',1280846734944,4,1,'Highlander AP VLAN Registration'),(1012,207380589022,1,'schmid.paige','Owner-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1280844136370,4,1,NULL),(1011,207380589022,1,'stone.brittany','Brittany-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-users',1280833065725,4,1,NULL),(1009,207380589022,1,'proctor.scott','scott-laptop','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1280687519464,4,1,'CornerStone AP VLAN Registration'),(1008,207380589022,1,'Howard.Dain','owner-PC','Windows 7 Home Premium 6.1','HCC-users',1280681597442,4,1,'Sunflower-MDF1 21'),(1052,207380589022,1,'Grier.mario','Mario-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-users',1281701590957,4,1,'Heritage-MDF1 70'),(1051,207380589022,1,'marshall.austin','marshall-PC','Windows 7 Home Premium 6.1','HCC-users',1281701302703,4,1,'Heritage-MDF1 68'),(1050,207380589022,1,'lparsons','ADM-0012','Windows 7 Enterprise 6.1','HCC-users',1281700746443,4,1,'Admin-MDF1 F16'),(1049,207380589022,1,'reuter.nathan','nathan-reuters-macbook-pro','Mac OS X 10.6.4','HCC-users',1281696069610,4,1,NULL),(1048,207380589022,1,'perez.bradley','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1281694917296,4,1,'CornerStone AP VLAN Registration'),(1047,207380589022,1,'Scholz.Lisa','LisaComputer','Windows 7 Home Premium 6.1','HCC-users',1281687460505,4,1,NULL),(1046,207380589022,1,'marshall.austin','caitlyn-muders-macbook-3','Mac OS X 10.5.8','HCC-users',1281643545023,4,1,NULL),(1045,207380589022,1,'hart.shane','Shane-PC','Windows 7 Home Premium 6.1','HCC-users',1281616465927,4,1,NULL),(1044,207380589022,1,'eberly.bryce','JoeyJohnson-PC','Windows 7 Starter 6.1','HCC-users',1281553338650,4,1,'Highlander AP VLAN Registration'),(1043,207380589022,1,'couvell.bret','Bret-PC','Windows 7 Home Premium 6.1','HCC-users',1281506350918,4,1,'ColonyPoint AP VLAN Registration'),(1041,207380589022,1,'gardner.gelia','Gelia-PC','Windows 7 Home Premium 6.1','HCC-users',1281378926273,4,1,NULL),(1010,207380589022,1,'highland\\rkarn','Russell-Mobile','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1280814654336,4,1,NULL),(1042,207380589022,1,'cyr.kobey','owner-PC','Windows 7 Home Premium 6.1','HCC-users',1281450155042,4,1,'Rubeti1 AP VLAN Registration'),(999,207380589022,1,'wilgers.miranda','miranda-wilgerss-macbook-pro','Mac OS X 10.5.8','HCC-users',1280333304744,4,1,'HollyOak AP VLAN Registration'),(998,207380589022,1,'fatherley.lindsey','lfatherley-PC','Windows 7 Home Premium 6.1','HCC-users',1280331142072,4,1,NULL),(997,207380589022,1,'jiao.chenxi','PC2010061523oxy','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1280331074988,4,1,NULL),(996,207380589022,1,'jiao.chenxi','Chenxi-JiaomatoMacBook-Pro','Mac OS X 10.6.3','HCC-users',1280327233682,4,1,NULL),(1040,207380589022,1,'eck.logan','eckpc','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1281350352957,4,1,'Degginger AP VLAN Registration'),(995,207380589022,1,'Davis.Leland','tyler-PC','Windows 7 Home Premium 6.1','HCC-users',1280238408696,4,1,'Degginger AP VLAN Registration'),(1016,207380589022,1,'dwerlkotte.erica','Erica-Dwerlkottes-MacBook-Pro','Mac OS X 10.6.4','HCC-users',1280847994873,4,1,NULL),(1017,207380589022,1,'griffin.rose','Mac-Macs-Computer-5','Mac OS X 10.4.11','HCC-users',1280854340901,4,1,NULL),(1018,207380589022,1,'wheat.alex','CameronWatie-PC','Windows 7 Home Premium 6.1','HCC-users',1280915433546,4,1,NULL),(1019,207380589022,1,'floyd.kristin','KristenFloyd-PC','Windows 7 Home Premium 6.1','HCC-users',1280949482871,4,1,'HollyOak AP VLAN Registration'),(1020,207380589022,1,'jrushing','janette-miller-rushings-macbook','Mac OS X 10.5.7','HCC-users',1280985249793,4,1,NULL),(1021,207380589022,1,'wheat.alex','johnson-PC','Windows 7 Home Premium 6.1','HCC-users',1280995968050,4,1,'Rubeti1 AP VLAN Registration'),(1022,207380589022,1,'burton.joshua','User-PC','Windows 7 Home Premium 6.1','HCC-users',1281002610493,4,1,'Heritage-MDF1 36'),(1023,207380589022,1,'Sambol.alexander','Owner-PC','Windows 7 Home Premium 6.1','HCC-users',1281004227397,4,1,NULL),(1024,207380589022,1,'melton.brett','Brett','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1281006406026,4,1,NULL),(1025,207380589022,1,'cookson.tyeler','Drake','Windows 7 Home Premium 6.1','HCC-users',1281012327725,4,1,'Claymont AP VLAN Registration'),(1026,207380589022,1,'gaitan.nicholas','Nick-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1281013561659,4,1,NULL),(1027,207380589022,1,'higgins.william','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1281016107955,4,1,'Ellis-MDF1 46'),(1028,207380589022,1,'winkel.zachary','Zach-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1281030754455,4,1,NULL),(1029,207380589022,1,'williams.orlando','Lando-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1281078785254,4,1,'Ellis-MDF1 62'),(1030,207380589022,1,'hart.shane','ShaneHart-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1281122447128,4,1,NULL),(1031,207380589022,1,'hightower.savannah','SMILES','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1281168397414,4,1,NULL),(1032,207380589022,1,'chance.jalen','Jalens-PC','Windows 7 Home Premium 6.1','HCC-users',1281179112872,4,1,'Highlander AP VLAN Registration'),(1033,207380589022,1,'Holle.Tyler','Tyler-PC','Windows 7 Home Premium 6.1','HCC-users',1281262637201,4,1,'Degginger AP VLAN Registration'),(1034,207380589022,1,'gardner.gelia','Gelias-Teddy-Bear','Mac OS X 10.6.4','HCC-users',1281267255716,4,1,NULL),(1035,207380589022,1,'hager.braden','braden-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1281271479151,4,1,'Degginger AP VLAN Registration'),(1036,207380589022,1,'eckhardt.ashley','AshleyMarie-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1281273993479,4,1,NULL),(1037,207380589022,1,'ackors.nicholas','Nick-PC','Windows 7 Ultimate 6.1','HCC-users',1281283906412,4,1,'Piper-MDF1 5'),(1038,207380589022,1,'menear.matthew','Wyatt-PC','Windows 7 Home Premium 6.1','HCC-users',1281288422270,4,1,'Crestview AP VLAN Registration'),(1039,207380589022,1,'Miller.Tyler1','Hunting','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1281292042211,4,1,'Degginger AP VLAN Registration'),(1053,207380589022,1,'Bakare.Akintunde','Tunde-PC','Windows 7 Home Premium 6.1','HCC-users',1281697859640,4,1,'Ellis-MDF1 A14'),(1054,207380589022,1,'marcellus.kenny','Kenny-PC','Windows 7 Home Premium 6.1','HCC-users',1281699169795,4,1,'Heritage-MDF1 66'),(1055,207380589022,1,'mcquerry.kaylyn','Kayla-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1281701637948,4,1,NULL),(1056,207380589022,1,'jberry','BHAMILTON4','Windows 7 Enterprise 6.1','HCC-users',1281702526161,4,1,'Admin-MDF1 A3 { StudNet } '),(1057,207380589022,1,'stevens.savannah','Savannah-PC','Windows 7 Starter 6.1','HCC-users',1281703035499,4,1,NULL),(1058,207380589022,1,'Robinson.Clifford','Cliff-PC','Windows 7 Home Premium 6.1','HCC-users',1281703668052,4,1,'Heritage-MDF1 70'),(1059,207380589022,1,'smith.tellis','tellis-PC','Windows 7 Home Premium 6.1','HCC-users',1281704045865,4,1,'Heritage-MDF1 70'),(1060,207380589022,1,'koch.daniel','Dan-PC','Windows 7 Home Premium 6.1','HCC-users',1281707984181,4,1,'Heritage-MDF1 68'),(1061,207380589022,1,'kuker.macie','Macie-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1281709461225,4,1,'Kiltie-MDF1 21'),(1062,207380589022,1,'blake.adrian','User-PC','Windows 7 Ultimate 6.1','HCC-users',1281713890886,4,1,'Heritage-MDF1 70'),(1063,207380589022,1,'wehking.troy','Troy-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1281717059467,4,1,'Heritage-MDF1 66'),(1064,207380589022,1,'lockheart.arias','Arias-pc','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-users',1281719641601,4,1,'Ellis-MDF1 64');
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 */;