/*!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 (2147,207380589022,'00:22:19:CF:52:94','Broadcom NetLink (TM) Fast Ethernet',1,NULL),(2156,207380589022,'B8:70:F4:9A:EE:01','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(2155,207380589022,'00:27:10:B8:5E:A8','Intel(R) Centrino(R) Advanced-N 6200 AGN',1,'192.168.101.109'),(2154,207380589022,'2C:41:38:5C:5F:3F','Realtek PCIe GBE Family Controller',1,NULL),(2152,207380589022,'00:25:64:4B:8C:EE','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(2152,207380589022,'00:22:5F:D9:64:B6','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.248'),(2146,207380589022,'D0:DF:9A:D4:EA:EB','Atheros AR9002WB-1NG Wireless Network Adapter',1,'192.168.101.58'),(2146,207380589022,'E8:9A:8F:A9:DD:E8','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2147,207380589022,'00:22:5F:31:F0:95','Dell Wireless 1395 WLAN Mini-Card',1,'172.16.50.152'),(2149,207380589022,'00:23:AE:44:3D:6C','Realtek RTL8102/8103 Family PCI-E FE NIC',1,NULL),(2150,207380589022,'8C:A9:82:60:63:92','Intel(R) WiFi Link 1000 BGN',1,'198.248.78.163'),(2150,207380589022,'78:2B:CB:F1:6C:D7','Realtek PCIe FE Family Controller',1,NULL),(2150,207380589022,'8C:A9:82:60:63:93','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2151,207380589022,'88:53:2E:9D:94:F5','Intel(R) Centrino(R) Advanced-N 6230',1,'192.168.101.47'),(2151,207380589022,'88:53:2E:9D:94:F6','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2151,207380589022,'88:53:2E:9D:94:F9','Bluetooth Device (Personal Area Network)',1,NULL),(2151,207380589022,'E8:03:9A:29:5F:A1','Realtek PCIe GBE Family Controller',1,NULL),(2148,207380589022,'F0:DE:F1:B9:DB:05','Realtek PCIe GBE Family Controller',1,NULL),(2148,207380589022,'40:25:C2:9A:4F:1D','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2148,207380589022,'64:D4:DA:68:64:33','Intel(R) Centrino(R) WiMAX 6150',1,NULL),(2148,207380589022,'40:25:C2:9A:4F:1C','Intel(R) Centrino(R) Wireless-N 6150',1,'192.168.101.162'),(2158,207380589022,'C8:2A:14:43:69:A1','en0',1,NULL),(2157,207380589022,'00:22:5F:D8:FB:09','Dell Wireless 1397 WLAN Mini-Card',1,'192.168.101.52'),(2157,207380589022,'00:25:64:4A:5B:F2','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(2158,207380589022,'E4:CE:8F:3E:F0:CC','en1',1,'192.168.101.146'),(2156,207380589022,'A0:88:B4:1E:6B:C8','Intel(R) Centrino(R) Advanced-N 6205',1,'192.168.101.187'),(2156,207380589022,'A0:88:B4:1E:6B:C9','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2155,207380589022,'F0:4D:A2:59:C7:97','Realtek PCIe GBE Family Controller',1,NULL),(2155,207380589022,'00:27:10:B8:5E:A9','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2153,207380589022,'5C:AC:4C:04:61:59','Broadcom 802.11n Network Adapter',1,'192.168.101.229'),(2153,207380589022,'20:6A:8A:19:28:F0','Broadcom NetLink (TM) Gigabit Ethernet #2',1,NULL),(2154,207380589022,'20:10:7A:26:4B:67','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.77'),(2149,207380589022,'00:22:FB:3F:60:52','Intel(R) WiFi Link 5100 AGN',1,'192.168.101.46');
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 (2157,207380589022,1,'Operating-System','Windows Vista',4,1),(2157,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2157,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2157,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2157,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2158,207380589022,2,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(2158,207380589022,2,'Operating-System','OS X Tiger Update',4,1),(2158,207380589022,2,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(2158,207380589022,2,'Operating-System','OS X Leopard Update',4,1),(2158,207380589022,2,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2158,207380589022,2,'Operating-System','OS X Snow Leopard Update',4,1),(2148,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2148,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2148,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2148,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2147,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2147,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2148,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2153,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2152,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2152,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2152,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2152,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2152,207380589022,1,'Operating-System','Windows Vista',4,1),(2146,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2146,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2146,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2146,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2146,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2147,207380589022,1,'Operating-System','Windows Vista',4,1),(2147,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2147,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2156,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2156,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2156,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2156,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2156,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2155,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2155,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2155,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2155,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2155,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2154,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2154,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2154,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2154,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2154,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2151,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2151,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2151,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2151,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2150,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2151,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2150,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2150,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2150,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2150,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2153,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2153,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2153,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2153,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2149,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2149,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2149,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2149,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2149,207380589022,1,'Operating-System','Windows Vista',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 (2146,207380589022,1,'floydmcknight.julian','JuliansPC-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1330580024517,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2147,207380589022,1,'caudle.anna','Anna-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1330626156422,4,1,NULL),(2148,207380589022,1,'souter.david','Ubercompy','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1330677530755,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2149,207380589022,1,'allen.amanda1','DanielKruse-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 2','HCC-Users',1331089231590,4,1,'Crestview AP VLAN Registration'),(2150,207380589022,1,'mccann.hayley@highlandcc.edu','Hayley-PC','Windows 7 Home Premium 6.1','HCC-Users',1331154712038,4,1,NULL),(2151,207380589022,1,'dakken.melinda','Kris-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1331441883986,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2154,207380589022,1,'waggoner.cassie','RyanSmith-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1331662115482,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2155,207380589022,1,'Kelley.Holly','JuneRizzo-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1331700063036,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2156,207380589022,1,'koehler.brent','GATEWAY-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1331782433401,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2157,207380589022,1,'walls.haley','Haley-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-Users',1331791613458,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2158,207380589022,2,'eberly.bryce','Kelsey-Dirckss-MacBook-Pro','Mac OS X 10.7.2','HCC-Users',1331924679556,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2153,207380589022,1,'Deters.Xavier','USER-PC','Windows 7 Home Premium 6.1','HCC-Users',1331620449751,4,1,'HollyOak AP VLAN Registration'),(2152,207380589022,1,'Johansen.Jacob','Jacob-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-Users',1331610371985,4,1,'Hampton 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 */;