/*!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 (1349,207380589022,'00:23:12:53:0A:F3','en1',1,'198.248.77.84'),(1349,207380589022,'00:23:32:B6:37:26','en0',1,NULL),(1348,207380589022,'00:0A:E4:E7:01:CE','Realtek RTL8169/8110 Family Gigabit Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1348,207380589022,'00:15:00:1F:BE:9C','Intel(R) PRO/Wireless 2200BG Network Connection - Packet Scheduler Miniport',1,'198.248.78.151'),(1347,207380589022,'00:0A:E4:E3:8E:49','Realtek RTL8169/8110 Family Gigabit Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1347,207380589022,'00:15:00:20:10:5D','Intel(R) PRO/Wireless 2200BG Network Connection - Packet Scheduler Miniport',1,'198.248.76.174'),(1346,207380589022,'00:0A:E4:E6:FD:0C','Realtek RTL8169/8110 Family Gigabit Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1346,207380589022,'00:15:00:1F:EA:DB','Intel(R) PRO/Wireless 2200BG Network Connection - Packet Scheduler Miniport',1,'198.248.78.123'),(1334,207380589022,'70:5A:B6:CD:40:B5','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1335,207380589022,'00:16:CE:37:33:68','Dell Wireless 1390 WLAN Mini-Card',1,'192.168.101.47'),(1336,207380589022,'0C:60:76:29:77:05','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.80'),(1336,207380589022,'00:1F:16:C8:0B:17','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1337,207380589022,'00:24:2B:E0:65:58','Atheros AR5B91 Wireless Network Adapter',1,'198.248.78.110'),(1337,207380589022,'00:1D:72:FB:B8:C6','Broadcom NetXtreme Gigabit Ethernet',1,NULL),(1350,207380589022,'70:5A:B6:F4:40:D9','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1351,207380589022,'00:25:56:4A:1D:F2','Atheros AR5009 802.11a/g/n WiFi Adapter',1,'198.248.76.63'),(1351,207380589022,'00:1F:16:D5:00:29','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1350,207380589022,'70:F1:A1:58:49:6F','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.90'),(1343,207380589022,'00:24:2C:3B:D8:B6','Atheros AR5007 802.11b/g WiFi Adapter',1,NULL),(1343,207380589022,'00:23:5A:41:20:B6','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,'192.168.101.247'),(1342,207380589022,'00:23:AE:3D:2B:1F','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1342,207380589022,'00:22:5F:B2:DD:BE','Dell Wireless 1397 WLAN Mini-Card',1,'198.248.92.79'),(1341,207380589022,'C8:0A:A9:BC:A8:CB','Realtek PCIe FE Family Controller',1,NULL),(1341,207380589022,'70:F1:A1:BC:DB:91','Realtek RTL8191SE 802.11b/g/n WiFi Adapter',1,'192.168.101.48'),(1344,207380589022,'00:26:BB:01:01:91','en1',1,'198.248.75.157'),(1334,207380589022,'F0:7B:CB:6E:57:07','Atheros AR5B95 Wireless Network Adapter',1,'192.168.101.139'),(1345,207380589022,'20:CF:30:2D:15:E7','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1344,207380589022,'00:26:4A:13:9E:06','en0',1,NULL),(1345,207380589022,'74:F0:6D:79:3D:2F','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.57'),(1338,207380589022,'00:26:2D:BB:80:0B','Realtek PCIe FE Family Controller',1,NULL),(1340,207380589022,'00:23:5A:AB:D2:1B','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1340,207380589022,'00:21:00:EC:0A:09','Broadcom 4322AG 802.11a/b/g/draft-n Wi-Fi Adapter',1,'198.248.77.84'),(1339,207380589022,'00:23:5A:25:91:81','Realtek RTL8102E/RTL8103E Family PCI-E Fast Ethernet NIC (NDIS 6.20)',1,NULL),(1339,207380589022,'00:21:00:A5:F6:1E','Broadcom 802.11g Network Adapter',1,'192.168.101.94'),(1338,207380589022,'70:F1:A1:2E:E5:45','Atheros AR5009 802.11a/g/n WiFi Adapter',1,'192.168.101.182');
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 (1337,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1337,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1337,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1337,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1337,207380589022,1,'Operating-System','Windows 7',4,1),(1336,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1336,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1336,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1336,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1335,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1336,207380589022,1,'Operating-System','Windows Vista',4,1),(1335,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1335,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1335,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1335,207380589022,1,'Operating-System','Windows 7',4,1),(1334,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1334,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1334,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1346,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1347,207380589022,1,'Operating-System','Windows XP',4,1),(1347,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1347,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1347,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1348,207380589022,1,'Operating-System','Windows XP',4,1),(1348,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1348,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1348,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1349,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1349,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1350,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1350,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1350,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1350,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1350,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1351,207380589022,1,'Operating-System','Windows Vista',4,1),(1351,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1351,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1351,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1351,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1343,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1343,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1343,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1343,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1342,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1343,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1342,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1342,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1342,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1341,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1342,207380589022,1,'Operating-System','Windows Vista',4,1),(1341,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1341,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1346,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1341,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1345,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1345,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1346,207380589022,1,'Operating-System','Windows XP',4,1),(1346,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1345,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1345,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1345,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1344,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1334,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1334,207380589022,1,'Operating-System','Windows 7',4,1),(1344,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1341,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1340,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1340,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1339,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1339,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1339,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1340,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1340,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1340,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1339,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1339,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1338,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1338,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1338,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1338,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1338,207380589022,1,'Operating-System','Windows 7 x64',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 (1351,207380589022,1,'child.michael','Michael-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1289141041626,4,1,NULL),(1350,207380589022,1,'kasper.thad','User-PC','Windows 7 Home Premium 6.1','HCC-users',1289126304986,4,1,NULL),(1349,207380589022,1,'sleahy','ne-b5bfffa307a0','Mac OS X 10.5.8','HCC-users',1288925610245,4,1,NULL),(1348,207380589022,1,'strube.megan','CT109-0024','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1288775798221,4,1,NULL),(1347,207380589022,1,'mcquerry.kaylyn','CT109-0020','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1288766904118,4,1,NULL),(1334,207380589022,1,'lightfoot.becky','JohnWall-PC','Windows 7 Starter 6.1','HCC-users',1287499524120,4,1,NULL),(1335,207380589022,1,'souter.david','loserboy-PC','Windows 7 Ultimate 6.1','HCC-users',1287507804183,4,1,'Sunflower AP VLAN Registration'),(1336,207380589022,1,'ewing.sandra','GatewayUser-PC','Windows Vista (TM) Home Premium 6.0','HCC-users',1287644133254,4,1,NULL),(1337,207380589022,1,'rhoads.cheyenne','Cheyenne-PC','Windows 7 Home Premium 6.1','HCC-users',1287721917892,4,1,NULL),(1338,207380589022,1,'mccullum.denzel','Buggy-PC','Windows 7 Home Premium 6.1','HCC-users',1288115555224,4,1,'Rubeti6 AP VLAN Registration'),(1346,207380589022,1,'rhoads.cheyenne','CT109-0022','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1288766561064,4,1,NULL),(1343,207380589022,1,'sharp.aron','Aron-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1288547689517,4,1,'Heritage-MDF1 21'),(1344,207380589022,1,'chess.glen','per-0030','Mac OS X 10.5.8','HCC-users',1288684660736,4,1,NULL),(1345,207380589022,1,'emberton.derek','Derek-PC','Windows 7 Home Premium 6.1','HCC-users',1288700952882,4,1,'Piper AP VLAN Registration'),(1340,207380589022,1,'aversman.corby','Corby-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 1','HCC-users',1288345809296,4,1,NULL),(1341,207380589022,1,'mcvicker.rustin','RustinMcVicker','Windows 7 Home Premium 6.1','HCC-users',1288468843678,4,1,NULL),(1342,207380589022,1,'Welborn.Chelsey','Chelsey-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1288537271521,4,1,'Hampton AP VLAN Remediation'),(1339,207380589022,1,'minner.tabetha','Tabetha-PC','Windows 7 Ultimate 6.1','HCC-users',1288196737430,4,1,NULL);
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 */;