/*!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 (2186,207380589022,'5C:AC:4C:60:89:63','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'198.248.76.117'),(2184,207380589022,'00:14:A5:6F:05:7B','Broadcom 802.11g Network Adapter',1,'192.168.101.234'),(2191,207380589022,'20:CF:30:2D:15:E7','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2185,207380589022,'F8:1E:DF:E6:5D:48','en1',1,'192.168.101.5'),(2183,207380589022,'00:26:2D:BB:3F:CF','Realtek PCIe FE Family Controller',1,'192.168.101.230'),(2183,207380589022,'70:F1:A1:3A:0F:52','Atheros AR5009 802.11a/g/n WiFi Adapter',1,NULL),(2182,207380589022,'C8:2A:14:38:03:1E','en0',1,NULL),(2182,207380589022,'E4:CE:8F:1D:4A:7D','en2',1,NULL),(2182,207380589022,'E4:CE:8F:1D:4A:7C','en1',1,'198.248.77.229'),(2181,207380589022,'00:26:6C:06:F0:4C','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2181,207380589022,'E0:CA:94:D4:4B:30','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.189'),(2194,207380589022,'E8:9A:8F:5D:93:BE','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2193,207380589022,'E4:D5:3D:81:44:9A','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.168'),(2192,207380589022,'00:1A:73:D0:B4:DE','Broadcom 802.11b/g WLAN',1,'169.254.102.132'),(2192,207380589022,'00:1B:24:D7:72:20','NVIDIA nForce Networking Controller',1,'192.168.101.223'),(2180,207380589022,'00:22:FB:71:8F:82','Intel(R) WiFi Link 5100 AGN',1,'192.168.101.208'),(2180,207380589022,'00:1E:33:24:1A:48','Realtek PCIe GBE Family Controller',1,NULL),(2191,207380589022,'74:F0:6D:79:3D:2F','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.206'),(2190,207380589022,'40:6C:8F:22:9D:CF','en0',1,NULL),(2190,207380589022,'70:56:81:8A:3A:91','en1',1,'192.168.101.8'),(2186,207380589022,'C8:0A:A9:D6:29:D1','Realtek PCIe FE Family Controller',1,NULL),(2187,207380589022,'AC:81:12:A4:EA:86','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.94'),(2187,207380589022,'78:E3:B5:5A:28:A0','Realtek PCIe FE Family Controller',1,NULL),(2188,207380589022,'88:9F:FA:36:9A:05','Broadcom 802.11n Network Adapter',1,'192.168.101.222'),(2188,207380589022,'1C:75:08:B7:C6:F6','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2189,207380589022,'08:2E:5F:85:2A:F5','Realtek PCIe GBE Family Controller',1,'192.168.101.89'),(2189,207380589022,'20:10:7A:33:C3:B3','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,NULL),(2184,207380589022,'00:14:C2:E5:5F:50','Broadcom 440x 10/100 Integrated Controller',1,NULL),(2193,207380589022,'54:04:A6:47:5A:A6','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2194,207380589022,'D0:DF:9A:66:C0:46','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.48'),(2185,207380589022,'7C:6D:62:8F:41:63','en0',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 (2188,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2188,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2189,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2189,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2189,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2189,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2189,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2190,207380589022,2,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(2190,207380589022,2,'Operating-System','OS X Tiger Update',4,1),(2190,207380589022,2,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(2190,207380589022,2,'Operating-System','OS X Leopard Update',4,1),(2190,207380589022,2,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2190,207380589022,2,'Operating-System','OS X Snow Leopard Update',4,1),(2191,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2191,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2191,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2191,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2191,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2193,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2193,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2193,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2193,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2193,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2192,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2192,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2192,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2192,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2192,207380589022,1,'Operating-System','Windows Vista',4,1),(2180,207380589022,1,'Operating-System','Windows 7',4,1),(2180,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2180,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2180,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2180,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2181,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2181,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2181,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2181,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2181,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2182,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2182,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(2183,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2183,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2183,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2183,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2183,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2184,207380589022,1,'Operating-System','Windows 7',4,1),(2184,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2184,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2184,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2184,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2194,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2194,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2194,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2194,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2194,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2188,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2188,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2188,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2187,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2186,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2186,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2187,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2187,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2187,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2187,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2186,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2186,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2186,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2185,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(2185,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',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 (2186,207380589022,1,'pierce.andrew','Owner-HP','Windows 7 Home Premium 6.1','HCC-Users',1335648423212,4,1,NULL),(2191,207380589022,1,'dobrovolny.brodan','Derek-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335738758505,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2194,207380589022,1,'medina.kody','Cassie-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1336040565927,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2188,207380589022,1,'gumm.chase','ch-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335674184431,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2189,207380589022,1,'Keach.David','Keach-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335681408176,4,1,'ScottiePlace-MDF1 7'),(2190,207380589022,2,'schwalm.lauren','Laurens-MacBook-Pro','Mac OS X 10.7.3','HCC-Users',1335727895545,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2192,207380589022,1,'wright.derek','Jonathan-PC','Windows Vista (TM) Home Premium 6.0','HCC-Users',1335768810831,4,1,'ScottiePlace-MDF1 7'),(2180,207380589022,1,'Kudernatschova.Zuzan','Zuza-PC','Windows 7 Professional 6.1','HCC-Users',1335041191518,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2181,207380589022,1,'koehler.cara','Caralee-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335076326076,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2182,207380589022,1,'orton.leigha','bus-0004','Mac OS X 10.6.8','HCC-Users',1335117586494,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2183,207380589022,1,'wilson.tomy','Tom-Laptop','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335128772811,4,1,'ScottiePlace-MDF1 6'),(2184,207380589022,1,'moore.cody','PC-1234','Windows 7 Professional 6.1 Service Pack 1','HCC-Users',1335159169096,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2187,207380589022,1,'mcnutt.coty','Mackenzie-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335673468691,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2193,207380589022,1,'ealey.tiffanie','GarrettRitzman','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1335846117395,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2185,207380589022,1,'trimble.cody','Macy-Parkers-MacBook-Pro','Mac OS X 10.6.4','HCC-Users',1335499824113,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 */;