/*!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 (1490,207380589022,'58:94:6B:66:55:5C','Intel(R) Centrino(R) Advanced-N 6200 AGN',1,'192.168.101.195'),(1489,207380589022,'00:21:9B:E2:73:6A','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1489,207380589022,'00:22:69:3E:EF:0C','Dell Wireless 1395 WLAN Mini-Card',1,'192.168.101.158'),(1488,207380589022,'CC:52:AF:61:CD:99','Broadcom 4313 802.11b/g/n',1,NULL),(1488,207380589022,'2C:27:D7:C2:6B:23','Realtek PCIe FE Family Controller',1,'192.168.101.83'),(1486,207380589022,'00:26:BB:64:31:E4','en0',1,NULL),(1487,207380589022,'00:25:22:61:A7:7D','Realtek PCIe GBE Family Controller',1,'192.168.101.206'),(1486,207380589022,'00:26:BB:16:23:A7','en1',1,'198.248.77.249'),(1494,207380589022,'00:1E:65:10:8C:A8','Intel(R) WiFi Link 5100 AGN - Packet Scheduler Miniport',1,'198.248.78.9'),(1485,207380589022,'00:16:36:70:A6:B0','Realtek RTL8139/810x Family Fast Ethernet NIC',1,NULL),(1485,207380589022,'00:18:DE:04:15:3F','Intel(R) PRO/Wireless 3945ABG Network Connection',1,'198.248.78.218'),(1493,207380589022,'00:13:02:32:F7:94','Intel(R) PRO/Wireless 3945ABG Network Connection - Packet Scheduler Miniport',1,NULL),(1484,207380589022,'00:1C:23:AC:C0:78','Broadcom 440x 10/100 Integrated Controller',1,NULL),(1484,207380589022,'00:1D:D9:27:CC:22','Dell Wireless 1390 WLAN Mini-Card',1,'192.168.101.209'),(1492,207380589022,'C4:2C:03:1D:7B:28','en0',1,NULL),(1493,207380589022,'00:16:36:51:2A:F6','Realtek RTL8139/810x Family Fast Ethernet NIC - Packet Scheduler Miniport',1,'198.248.78.57'),(1492,207380589022,'D8:A2:5E:95:5B:65','en1',1,'192.168.101.178'),(1490,207380589022,'E0:2A:82:30:98:D4','Bluetooth Device (Personal Area Network)',1,NULL),(1491,207380589022,'00:23:4D:17:A2:93','Atheros AR5007 802.11b/g WiFi Adapter',1,'164.113.45.92'),(1491,207380589022,'00:1D:72:79:82:71','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 (1489,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1489,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1489,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1489,207380589022,1,'Operating-System','Windows Vista',4,1),(1488,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1488,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1488,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1488,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1488,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1487,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1487,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1487,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1487,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1487,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1486,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1486,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1485,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1494,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1494,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1494,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1494,207380589022,1,'Operating-System','Windows XP',4,1),(1485,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1485,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1485,207380589022,1,'Operating-System','Windows XP',4,1),(1484,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1493,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1484,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1484,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1484,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1484,207380589022,1,'Operating-System','Windows 7',4,1),(1493,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1493,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1493,207380589022,1,'Operating-System','Windows XP',4,1),(1492,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(1492,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1489,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1490,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1490,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1490,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1490,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1490,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1491,207380589022,1,'Operating-System','Windows Vista',4,1),(1491,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1491,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1491,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1491,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 (1489,207380589022,1,'spalding.kassandra','Ermal-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1304284240259,4,1,'Rubeti6 AP VLAN Registration'),(1488,207380589022,1,'smith.ryan1','Ryan-HP','Windows 7 Home Premium 6.1','HCC-Users',1304226608457,4,1,'Kiltie-MDF1 15'),(1487,207380589022,1,'ackors.nicholas','NickAckors-PC','Windows 7 Ultimate 6.1','HCC-Users',1303922612920,4,1,'Piper-MDF1 16'),(1494,207380589022,1,'ssmith','MAR-0019','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1304692841464,4,1,NULL),(1486,207380589022,1,'diveley.nicole','Nicole-Diveleys-MacBook-Pro','Mac OS X 10.6.7','HCC-Users',1303866823744,4,1,NULL),(1485,207380589022,1,'foster.joseph','AFH-0002','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1303833218698,4,1,NULL),(1493,207380589022,1,'cweiland','FAC-0016','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1304621333400,4,1,'Admin-MDF1 F18'),(1484,207380589022,1,'richardson.dante','jaron-PC','Windows 7 Ultimate 6.1','HCC-Users',1303788851638,4,1,'Rubeti1 AP VLAN Registration'),(1492,207380589022,1,'bronaugh.kala','Sami-Sallaways-MacBook-Pro','Mac OS X 10.6.5','HCC-Users',1304369105242,4,1,'Piper AP VLAN Registration'),(1490,207380589022,1,'sobotka.erin','Shawty-HP','Windows 7 Home Premium 6.1','HCC-Users',1304309280542,4,1,'HollyOak AP VLAN Registration'),(1491,207380589022,1,'lewis.thomas','Thomas-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-Users',1304311347669,4,1,'Kiltie-MDF1 11');
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 */;