/*!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 (1383,207380589022,'00:1E:33:72:E9:E7','Realtek PCIe FE Family Controller',1,NULL),(1372,207380589022,'00:21:CC:40:5D:00','Realtek PCIe FE Family Controller',1,NULL),(1372,207380589022,'00:03:7F:8F:45:40','Atheros AR5009 802.11a/g/n WiFi Adapter',1,'192.168.101.16'),(1371,207380589022,'00:27:13:DC:E7:DD','Bluetooth Device (Personal Area Network)',1,NULL),(1371,207380589022,'70:F3:95:35:8D:0A','Broadcom 4313 802.11b/g/n',1,'192.168.101.46'),(1383,207380589022,'00:21:6B:1C:1C:9E','Intel(R) WiFi Link 5100 AGN',1,'192.168.101.143'),(1382,207380589022,'70:5A:B6:DC:37:87','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1382,207380589022,'00:17:C4:E7:E2:77','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.184'),(1381,207380589022,'70:5A:B6:FF:02:18','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1381,207380589022,'78:E4:00:B7:BD:89','Broadcom 802.11n Network Adapter',1,'192.168.101.149'),(1380,207380589022,'00:C0:9F:C5:CD:CF','Realtek RTL8139/810x Family Fast Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1370,207380589022,'00:26:6C:6D:4C:9B','Realtek PCIe FE Family Controller',1,NULL),(1370,207380589022,'B4:82:FE:61:8C:29','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.93'),(1369,207380589022,'00:23:AE:2D:E4:95','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1369,207380589022,'00:22:5F:8D:28:9C','Dell Wireless 1397 WLAN Mini-Card',1,'198.248.75.166'),(1368,207380589022,'00:1E:68:1D:62:78','NVIDIA nForce 10/100 Mbps Ethernet',1,NULL),(1380,207380589022,'00:14:A5:18:85:E8','Broadcom 802.11b/g WLAN - Packet Scheduler Miniport',1,'192.168.101.6'),(1379,207380589022,'60:EB:69:53:3E:23','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(1368,207380589022,'00:1F:3A:4A:D9:84','Atheros AR5007 802.11b/g WiFi Adapter',1,'164.113.46.92'),(1379,207380589022,'1C:65:9D:65:5C:72','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.3'),(1378,207380589022,'00:26:2D:72:4B:A1','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1378,207380589022,'90:4C:E5:86:BD:F0','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.197'),(1373,207380589022,'00:1F:E2:CF:3B:E0','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.182'),(1374,207380589022,'70:F1:A1:BD:0E:7C','Realtek RTL8191SE 802.11b/g/n WiFi Adapter',1,'192.168.101.147'),(1374,207380589022,'C8:0A:A9:C5:6B:14','Realtek PCIe FE Family Controller',1,NULL),(1375,207380589022,'70:F1:A1:EA:1E:8F','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.205'),(1375,207380589022,'A4:BA:DB:DD:BF:B7','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1376,207380589022,'B4:82:FE:5B:29:26','Realtek RTL8187B Wireless 802.11bg 54Mbps USB 2.0 Network Adapter',1,'192.168.101.94'),(1376,207380589022,'70:5A:B6:89:10:07','Realtek PCIe FE Family Controller',1,NULL),(1377,207380589022,'00:0B:6B:E7:E4:91','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.230'),(1377,207380589022,'00:26:2D:87:F4:44','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1383,207380589022,'00:21:6B:1C:1C:9F','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1384,207380589022,'00:26:82:0E:C6:86','Broadcom 802.11b/g WLAN',1,'198.248.77.20'),(1384,207380589022,'00:23:5A:A1:EA:42','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(1385,207380589022,'70:5A:B6:BE:44:61','Realtek PCIe FE Family Controller',1,'192.168.101.118'),(1385,207380589022,'70:F1:A1:64:AB:EE','Realtek RTL8187B Wireless 802.11bg 54Mbps USB 2.0 Network Adapter',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 (1372,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1372,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1372,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1372,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1371,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1371,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1371,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1371,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1371,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1370,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1370,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1383,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1383,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1383,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1383,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1383,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1382,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1382,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1382,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1382,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1370,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1370,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1370,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1369,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1369,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1369,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1369,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1382,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1381,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1381,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1381,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1381,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1381,207380589022,1,'Operating-System','Windows 7',4,1),(1369,207380589022,1,'Operating-System','Windows Vista',4,1),(1368,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1380,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1380,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1380,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1380,207380589022,1,'Operating-System','Windows XP',4,1),(1379,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1379,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1368,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1368,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1368,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1368,207380589022,1,'Operating-System','Windows Vista',4,1),(1379,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1379,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1379,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1378,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1378,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1378,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1378,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1378,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1372,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1373,207380589022,1,'Operating-System','Windows Vista',4,1),(1373,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1373,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1373,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1373,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1374,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1374,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1374,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1374,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1374,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1375,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1375,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1375,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1375,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1375,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1376,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1376,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1376,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1376,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1376,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1377,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1377,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1377,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1377,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1377,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1384,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1384,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1384,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1384,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1384,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1385,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1385,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1385,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1385,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1385,207380589022,1,'Operating-System','Windows 7 x64 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 (1384,207380589022,1,'kkliewer','Kathy-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1291876174785,4,1,NULL),(1372,207380589022,1,'Davis.Cody','Cody-PC','Windows 7 Home Premium 6.1','HCC-users',1291378806557,4,1,'Sunflower AP VLAN Registration'),(1371,207380589022,1,'cluck.emily','Emily-PC','Windows 7 Home Premium 6.1','HCC-users',1291366907171,4,1,'HollyOak AP VLAN Registration'),(1370,207380589022,1,'rogers.michael','michael-PC','Windows 7 Home Premium 6.1','HCC-users',1291279991546,4,1,'Ellis-MDF1 27'),(1383,207380589022,1,'koehler.brent','jacobs-PC','Windows 7 Ultimate 6.1','HCC-users',1291833675096,4,1,NULL),(1382,207380589022,1,'Harris.Aaron1','AaronH-PC','Windows 7 Home Premium 6.1','HCC-users',1291828658168,4,1,'Enterprise AP VLAN Registration'),(1381,207380589022,1,'ashby.taylor','Taylor-PC','Windows 7 Starter 6.1','HCC-users',1291781404013,4,1,'Crestview AP VLAN Registration'),(1369,207380589022,1,'phillips.andrea','Andre','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1291085284992,4,1,NULL),(1368,207380589022,1,'vaughngibson.kenneth','Kenny-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1291035837153,4,1,'Ellis-MDF1 64'),(1380,207380589022,1,'thomas.douglas','your-4105e587b6','Microsoft Windows XP 5.1 Service Pack 2','HCC-users',1291780851216,4,1,'Enterprise AP VLAN Registration'),(1379,207380589022,1,'davis.jillian01','Jillian-PC','Windows 7 Home Premium 6.1','HCC-users',1291630390504,4,1,NULL),(1378,207380589022,1,'riley.evan','Evan-PC','Windows 7 Home Premium 6.1','HCC-users',1291619937679,4,1,'Enterprise AP VLAN Registration'),(1373,207380589022,1,'mathewson.sarah','ToddO-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1291389699569,4,1,'Hearthford AP VLAN Registration'),(1374,207380589022,1,'knight.mckensie','Parker-PC','Windows 7 Home Premium 6.1','HCC-users',1291526311408,4,1,NULL),(1375,207380589022,1,'parker.allan','Allan-PC','Windows 7 Home Premium 6.1','HCC-users',1291540777549,4,1,'Sunflower AP VLAN Registration'),(1376,207380589022,1,'beatty.jacob','Jacob-PC','Windows 7 Home Premium 6.1','HCC-users',1291548773664,4,1,'Enterprise AP VLAN Registration'),(1377,207380589022,1,'vanwinkle.garrett','garvanwikle-PC','Windows 7 Home Premium 6.1','HCC-users',1291552555241,4,1,'Enterprise AP VLAN Registration'),(1385,207380589022,1,'wehking.troy','Laptop-PC','Windows 7 Home Premium 6.1','HCC-users',1292082892318,4,1,'Heritage-MDF1 32');
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 */;