/*!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 (2109,207380589022,'70:F1:A1:3F:F5:DA','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.133'),(2109,207380589022,'70:5A:B6:FA:E2:42','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2110,207380589022,'E4:D5:3D:81:44:9A','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.242'),(2110,207380589022,'54:04:A6:47:5A:A6','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2108,207380589022,'00:1E:EC:33:4B:A3','Realtek RTL8101 Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(2108,207380589022,'00:1B:9E:9A:D6:9C','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.179'),(2107,207380589022,'1C:75:08:11:54:A5','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(2107,207380589022,'4C:0F:6E:53:C8:46','Atheros AR5B97 Wireless Network Adapter',1,'192.168.101.164'),(2106,207380589022,'2C:27:D7:E3:DA:12','Realtek PCIe FE Family Controller',1,NULL),(2106,207380589022,'AC:81:12:8B:FF:A0','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.198'),(2105,207380589022,'F4:6D:04:43:95:0A','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2105,207380589022,'BC:77:37:2A:4D:F5','Bluetooth Device (Personal Area Network)',1,NULL),(2105,207380589022,'BC:77:37:2A:4D:F2','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2105,207380589022,'BC:77:37:2A:4D:F1','Intel(R) Centrino(R) Wireless-N 1030',1,'192.168.101.83'),(2104,207380589022,'00:26:6C:5D:27:1C','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2104,207380589022,'00:26:B6:EF:0D:2E','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.200'),(2103,207380589022,'00:1E:EC:40:22:AC','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(2103,207380589022,'00:22:FA:0A:DE:12','Intel(R) WiFi Link 5100 AGN',1,'198.248.75.213'),(2102,207380589022,'AC:81:12:30:1C:3F','Broadcom 4313 802.11b/g/n',1,'192.168.101.77'),(2113,207380589022,'90:E6:BA:4D:95:3F','Atheros AR8121/AR8113/AR8114 PCI-E Ethernet Controller',1,NULL),(2113,207380589022,'00:25:D3:9E:49:72','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.12'),(2112,207380589022,'88:53:2E:7A:FC:0A','Bluetooth Device (Personal Area Network)',1,NULL),(2112,207380589022,'88:53:2E:7A:FC:07','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2112,207380589022,'84:8F:69:B8:D4:7C','Realtek PCIe GBE Family Controller',1,NULL),(2112,207380589022,'88:53:2E:7A:FC:06','Intel(R) Centrino(R) Advanced-N 6230',1,'192.168.101.55'),(2111,207380589022,'00:26:6C:46:51:B0','Realtek PCIe FE Family Controller',1,NULL),(2111,207380589022,'B4:82:FE:0A:62:D9','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.150');
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 (2110,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2110,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2110,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2110,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2110,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2109,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2109,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2109,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2108,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2109,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2109,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2108,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2108,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2108,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2108,207380589022,1,'Operating-System','Windows Vista',4,1),(2107,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2107,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2107,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2107,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2107,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2106,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2106,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2106,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2106,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2106,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2105,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2105,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2105,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2105,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2105,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2104,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2104,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2104,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2104,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2104,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2103,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(2103,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(2103,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(2103,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(2103,207380589022,1,'Operating-System','Windows Vista x64',4,1),(2102,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2102,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2102,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2102,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2102,207380589022,1,'Operating-System','Windows 7',4,1),(2113,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2113,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2113,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2113,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2113,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2112,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2112,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2112,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2112,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2112,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2111,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2111,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2111,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2111,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2111,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 (2110,207380589022,1,'ealey.tiffanie','GarrettRitzman','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327274576415,4,1,'Sunflower AP VLAN Registration'),(2109,207380589022,1,'hutchinson.jessica','Owner-PC','Windows 7 Home Premium 6.1','HCC-Users',1327267598240,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2108,207380589022,1,'hutchinson.keanon','Julie-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-Users',1327265846745,4,1,'Rubeti1 AP VLAN Registration'),(2107,207380589022,1,'kracht.lisa','LisaKU-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327122122909,4,1,'Degginger AP VLAN Registration'),(2106,207380589022,1,'bridges.isaac','Owner-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327039628875,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2105,207380589022,1,'templeton.avery','Rachel-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327004471282,4,1,'Degginger AP VLAN Registration'),(2104,207380589022,1,'sanford.william','Dixiemay-LT','Windows 7 Home Premium 6.1','HCC-Users',1326773809341,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2103,207380589022,1,'wganstrom','Wendell-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 1','HCC-Users',1326750437090,4,1,NULL),(2102,207380589022,1,'heideman.andrew','Andrew-PC','Windows 7 Ultimate 6.1','HCC-Users',1326699484032,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2113,207380589022,1,'skiles.victoria','Mark-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327685615048,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2112,207380589022,1,'buggs.detavis','TaraCooper-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1327639571868,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2111,207380589022,1,'hale.eli','Awesomesauce-PC','Windows 7 Home Premium 6.1','HCC-Users',1327492049455,4,1,'MSM760.Highland.cc.ks.us VLAN 30');
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 */;