/*!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 (1498,207380589022,'00:24:E8:39:A3:93','Broadcom NetXtreme 57xx Gigabit Controller - Packet Scheduler Miniport',1,'164.113.45.137'),(1499,207380589022,'00:16:D4:3E:93:CB','Realtek RTL8139/810x Family Fast Ethernet NIC - Packet Scheduler Miniport',1,NULL),(1494,207380589022,'00:1E:65:10:8C:A8','Intel(R) WiFi Link 5100 AGN - Packet Scheduler Miniport',1,'198.248.78.9'),(1497,207380589022,'C8:0A:A9:91:C7:EC','Realtek PCIe FE Family Controller',1,NULL),(1497,207380589022,'78:E4:00:98:20:22','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.88'),(1493,207380589022,'00:13:02:32:F7:94','Intel(R) PRO/Wireless 3945ABG Network Connection - Packet Scheduler Miniport',1,NULL),(1496,207380589022,'00:11:43:4D:0C:D6','Broadcom 570x Gigabit Integrated Controller - Packet Scheduler Miniport',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'),(1499,207380589022,'00:14:A5:BD:98:FA','Broadcom 802.11b/g WLAN - Packet Scheduler Miniport',1,'192.168.101.169'),(1496,207380589022,'00:90:4B:1A:19:A6','Dell TrueMobile 1400 Dual Band WLAN Mini-PCI Card - Packet Scheduler Miniport',1,'192.168.101.9'),(1495,207380589022,'1C:75:08:C0:61:2C','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1495,207380589022,'88:9F:FA:37:F9:00','Broadcom 802.11n Network Adapter',1,'192.168.101.42');
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 (1498,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1498,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1498,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1499,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1499,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),(1497,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1498,207380589022,1,'Operating-System','Windows XP',4,1),(1497,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1493,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1497,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1497,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1497,207380589022,1,'Operating-System','Windows 7 x64',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),(1499,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1499,207380589022,1,'Operating-System','Windows XP',4,1),(1496,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1496,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1496,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1496,207380589022,1,'Operating-System','Windows XP',4,1),(1495,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1495,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1495,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1495,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1495,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 (1494,207380589022,1,'ssmith','MAR-0019','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1304692841464,4,1,NULL),(1497,207380589022,1,'zeckser.jeffery','surelyacomputer','Windows 7 Home Premium 6.1','HCC-Users',1305257307933,4,1,'Piper AP VLAN Registration'),(1499,207380589022,1,'cdouglas','DOUGLAS','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1305587400001,4,1,'Highlander AP VLAN Registration'),(1493,207380589022,1,'cweiland','FAC-0016','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1304621333400,4,1,'Admin-MDF1 F18'),(1498,207380589022,1,'melton.brett','Brett','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1305299812674,4,1,NULL),(1496,207380589022,1,'stone.tucker','humperdi-883f3f','Microsoft Windows XP 5.1 Service Pack 2','HCC-Users',1305224045490,4,1,'ColonyPoint AP VLAN Registration'),(1495,207380589022,1,'brown.ashley01','CafeCandies','Windows 7 Home Premium 6.1','HCC-Users',1304992574927,4,1,'Crestview AP VLAN Registration');
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTTESTRESULT` ENABLE KEYS */;
--
-- Table structure for table `AGENTUPDATE`
--
DROP TABLE IF EXISTS `AGENTUPDATE`;
CREATE TABLE `AGENTUPDATE` (
`hostId` int(11) NOT NULL,
`attempts` int(11) NOT NULL,
`lastKnownVersion` varchar(255) default NULL,
PRIMARY KEY (`hostId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTUPDATE`
--
/*!40000 ALTER TABLE `AGENTUPDATE` DISABLE KEYS */;
LOCK TABLES `AGENTUPDATE` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTUPDATE` ENABLE KEYS */;