-- MySQL dump 10.13  Distrib 5.1.61, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: jffnms-release
-- ------------------------------------------------------
-- Server version	5.1.61-2

/*!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 `acct`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acct` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `usern` char(15) NOT NULL DEFAULT '',
  `s_name` char(30) NOT NULL DEFAULT '',
  `c_name` char(30) NOT NULL DEFAULT '',
  `elapsed_time` int(11) NOT NULL DEFAULT '0',
  `bytes_in` int(11) DEFAULT '0',
  `bytes_out` int(11) DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmd` char(250) NOT NULL DEFAULT '',
  `type` char(15) NOT NULL DEFAULT '0',
  `analized` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `analized` (`analized`),
  KEY `s_name` (`s_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `acct`
--

LOCK TABLES `acct` WRITE;
/*!40000 ALTER TABLE `acct` DISABLE KEYS */;
/*!40000 ALTER TABLE `acct` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `actions`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `actions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  `command` char(60) NOT NULL DEFAULT 'none',
  `internal_parameters` char(120) NOT NULL DEFAULT '',
  `user_parameters` char(120) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `command` (`command`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='Actions activated by Triggers';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `actions`
--

LOCK TABLES `actions` WRITE;
/*!40000 ALTER TABLE `actions` DISABLE KEYS */;
INSERT INTO `actions` VALUES (1,'No Action','none','',''),(2,'Send Mail','email','from:nms,to:<profile-email>,subject:NMS','from:From,subject:Subject,comment:Comment'),(3,'Send SMS via Modem','smsclient','smsname:<profile-smsalias>',''),(4,'Send SMS via Mail','email','short:1,from:nms,to:<profile-email>,subject:NMS','from:From,subject:Subject');
/*!40000 ALTER TABLE `actions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alarm_states`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alarm_states` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(30) NOT NULL DEFAULT '',
  `activate_alarm` tinyint(1) NOT NULL DEFAULT '0',
  `sound_in` char(30) NOT NULL DEFAULT '',
  `sound_out` char(30) NOT NULL DEFAULT '',
  `state` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `description` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alarm_states`
--

LOCK TABLES `alarm_states` WRITE;
/*!40000 ALTER TABLE `alarm_states` DISABLE KEYS */;
INSERT INTO `alarm_states` VALUES (1,'down',10,'down.wav','up.wav',1),(2,'up',100,'','',2),(3,'alert',60,'boing.wav','',3),(4,'testing',40,'','',4),(5,'running',100,'','',2),(6,'not running',20,'','',1),(7,'open',100,'','',2),(8,'closed',15,'','',1),(9,'error',90,'boing.wav','',3),(10,'invalid',30,'','',1),(11,'valid',110,'','',2),(12,'reachable',100,'','',2),(13,'unreachable',5,'','',1),(14,'lowerlayerdown',10,'down.wav','up.wav',1),(15,'synchronized',100,'','',2),(16,'unsynchronized',6,'','',1),(17,'battery normal',100,'','',2),(18,'battery low',4,'','',1),(19,'battery unknown',2,'','',1),(20,'on battery',3,'','',1),(21,'on line',90,'','',2),(22,'ok',100,'','',2),(23,'out of bounds',10,'','',1),(24,'unavailable',10,'down.wav','up.wav',1),(25,'available',100,'','',2),(26,'battery depleted',3,'','',1),(27,'other',10,'','',1),(28,'unknown',10,'','',1),(29,'noncritical',90,'','',1),(30,'critical',10,'','',1),(31,'nonrecoverabl',10,'','',1),(32,'warning',80,'down.wav','up.wav',1);
/*!40000 ALTER TABLE `alarm_states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alarms`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alarms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_stop` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `interface` int(10) NOT NULL DEFAULT '0',
  `type` int(10) NOT NULL DEFAULT '0',
  `active` int(10) NOT NULL DEFAULT '1',
  `referer_start` int(10) NOT NULL DEFAULT '0',
  `referer_stop` int(10) NOT NULL DEFAULT '0',
  `triggered` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `type` (`type`),
  KEY `interface` (`interface`),
  KEY `active` (`active`),
  KEY `triggered` (`triggered`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alarms`
--

LOCK TABLES `alarms` WRITE;
/*!40000 ALTER TABLE `alarms` DISABLE KEYS */;
/*!40000 ALTER TABLE `alarms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `usern` char(60) NOT NULL DEFAULT '',
  `passwd` varchar(200) DEFAULT NULL,
  `fullname` char(60) NOT NULL DEFAULT '',
  `router` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `usern` (`usern`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth`
--

LOCK TABLES `auth` WRITE;
/*!40000 ALTER TABLE `auth` DISABLE KEYS */;
INSERT INTO `auth` VALUES (1,'No User','$1$txVdymrd$AO3Qa8js9lVNkyscQ552b1','No User Name',0),(2,'admin','adpexzg3FUZAk','Administrator',0);
/*!40000 ALTER TABLE `auth` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `autodiscovery`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `autodiscovery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '0',
  `poller_default` tinyint(1) NOT NULL DEFAULT '1',
  `permit_add` tinyint(1) NOT NULL DEFAULT '0',
  `permit_del` tinyint(1) NOT NULL DEFAULT '0',
  `permit_mod` tinyint(1) NOT NULL DEFAULT '0',
  `permit_disable` tinyint(1) NOT NULL DEFAULT '0',
  `skip_loopback` tinyint(1) NOT NULL DEFAULT '0',
  `check_state` tinyint(1) NOT NULL DEFAULT '1',
  `check_address` tinyint(1) NOT NULL DEFAULT '1',
  `alert_del` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `autodiscovery`
--

LOCK TABLES `autodiscovery` WRITE;
/*!40000 ALTER TABLE `autodiscovery` DISABLE KEYS */;
INSERT INTO `autodiscovery` VALUES (1,'No Autodiscovery',1,0,0,0,0,0,1,1,1),(2,'Standard',1,1,0,0,1,1,1,1,1),(3,'Automagic',1,1,1,1,0,1,1,1,1),(4,'Administrative',0,1,1,0,1,1,1,1,1),(5,'Just Inform',0,0,0,0,0,0,1,1,1),(6,'Standard (for Switches)',1,1,0,1,0,1,1,0,1);
/*!40000 ALTER TABLE `autodiscovery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clients`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` char(60) NOT NULL DEFAULT '',
  `password` char(30) NOT NULL DEFAULT '',
  `name` char(60) NOT NULL DEFAULT '',
  `shortname` char(30) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,'unkclient','','Unknown Customer','Unknown',1),(2,'','','New Customer','Customer1',1);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` int(10) NOT NULL DEFAULT '0',
  `host` int(10) NOT NULL DEFAULT '0',
  `interface` char(150) NOT NULL,
  `state` char(40) NOT NULL DEFAULT '',
  `username` char(40) NOT NULL DEFAULT '',
  `info` char(150) NOT NULL DEFAULT '',
  `referer` int(10) NOT NULL DEFAULT '0',
  `ack` int(10) NOT NULL DEFAULT '0',
  `analized` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `host` (`host`),
  KEY `interface` (`interface`),
  KEY `username` (`username`),
  KEY `ack` (`ack`),
  KEY `type` (`type`),
  KEY `state` (`state`),
  KEY `date` (`date`),
  KEY `analized` (`analized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events_latest`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events_latest` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` int(10) NOT NULL DEFAULT '0',
  `host` int(10) NOT NULL DEFAULT '0',
  `interface` char(40) NOT NULL DEFAULT '',
  `state` char(40) NOT NULL DEFAULT '',
  `username` char(40) NOT NULL DEFAULT '',
  `info` char(150) NOT NULL DEFAULT '',
  `referencia` int(10) NOT NULL DEFAULT '0',
  `ack` int(10) NOT NULL DEFAULT '0',
  `analized` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `tipo` (`type`),
  KEY `host` (`host`),
  KEY `interface` (`interface`),
  KEY `analized` (`analized`),
  KEY `date` (`date`),
  KEY `username` (`username`),
  KEY `ack` (`ack`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events_latest`
--

LOCK TABLES `events_latest` WRITE;
/*!40000 ALTER TABLE `events_latest` DISABLE KEYS */;
/*!40000 ALTER TABLE `events_latest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `filters`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `filters` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `filters`
--

LOCK TABLES `filters` WRITE;
/*!40000 ALTER TABLE `filters` DISABLE KEYS */;
INSERT INTO `filters` VALUES (1,'All Events'),(4,'Severity Level > Warning'),(5,'Dont Show SLA or Commands'),(8,'Dont Show SLA'),(10,'BGP Events'),(13,'Commands Only'),(17,'Interfaces'),(18,'UnACK Events'),(19,'Windows Events'),(20,'PIX');
/*!40000 ALTER TABLE `filters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `filters_cond`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `filters_cond` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `filter_id` int(10) NOT NULL DEFAULT '1',
  `pos` int(5) NOT NULL DEFAULT '1',
  `field_id` int(10) NOT NULL DEFAULT '1',
  `op` char(10) NOT NULL DEFAULT '=',
  `value` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `filter` (`filter_id`),
  KEY `field` (`field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `filters_cond`
--

LOCK TABLES `filters_cond` WRITE;
/*!40000 ALTER TABLE `filters_cond` DISABLE KEYS */;
INSERT INTO `filters_cond` VALUES (1,1,1,1,'=','1'),(2,5,1,2,'!=','12'),(3,4,1,3,'>','30'),(4,5,3,2,'!=','8'),(5,5,2,4,'=',''),(6,8,1,2,'!=','12'),(10,10,1,2,'=','6'),(13,13,1,2,'=','8'),(20,17,1,11,'>','1'),(21,18,1,12,'=','0'),(22,19,1,2,'=','46'),(23,19,5,5,'=',''),(24,19,10,2,'=','47'),(25,19,15,5,'=',''),(26,19,20,2,'=','48'),(27,19,25,5,'=',''),(28,19,30,2,'=','49'),(29,20,2,5,'=',''),(30,20,3,2,'=','63'),(31,20,4,5,'=',''),(32,20,5,2,'=','62'),(33,20,6,5,'=',''),(34,20,7,2,'=','65'),(35,20,9,2,'=','67'),(37,20,10,5,'=',''),(38,20,11,2,'=','61'),(39,20,12,5,'=',''),(40,20,13,2,'=','66'),(41,20,1,2,'=','64'),(43,20,8,5,'=',''),(44,20,14,5,'=',''),(45,20,15,2,'=','29'),(46,20,16,5,'=',''),(47,20,17,2,'=','28');
/*!40000 ALTER TABLE `filters_cond` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `filters_fields`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `filters_fields` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  `field` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8 COMMENT='Fields that can be used for filtering';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `filters_fields`
--

LOCK TABLES `filters_fields` WRITE;
/*!40000 ALTER TABLE `filters_fields` DISABLE KEYS */;
INSERT INTO `filters_fields` VALUES (1,'ALL',''),(2,'Event Type','types.id'),(3,'Severity Level','severity.level'),(4,'AND','AND'),(5,'OR','OR'),(6,'Host','hosts.id'),(7,'Zone','zones.id'),(11,'Interface ID','interfaces.id'),(12,'Acknowledge','events.ack');
/*!40000 ALTER TABLE `filters_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `graph_types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `graph_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(30) NOT NULL DEFAULT '',
  `type` int(10) NOT NULL DEFAULT '1',
  `graph1` char(60) NOT NULL DEFAULT '',
  `graph2` char(60) NOT NULL DEFAULT '',
  `sizex1` int(4) NOT NULL DEFAULT '0',
  `sizey1` int(4) NOT NULL DEFAULT '0',
  `sizex2` int(4) NOT NULL DEFAULT '0',
  `sizey2` int(4) NOT NULL DEFAULT '0',
  `allow_aggregation` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='Performance Graph Types';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `graph_types`
--

LOCK TABLES `graph_types` WRITE;
/*!40000 ALTER TABLE `graph_types` DISABLE KEYS */;
INSERT INTO `graph_types` VALUES (1,'No Graph Selected',1,'','',0,0,0,0,0),(3,'Traffic',4,'traffic','',500,150,0,0,1),(4,'Utilization',4,'traffic_util','',500,150,0,0,0),(5,'Packets',4,'packets','error_packets',275,170,250,170,1),(6,'Error Rate',4,'error_rate','',500,170,0,0,0),(7,'RTT & Packet Loss',4,'rtt','traffic_pl',275,155,260,140,0),(8,'Interface Packet Loss',4,'packetloss','',500,180,0,0,0),(9,'Cisco CPU Usage',3,'cpu_util','',500,175,0,0,1),(10,'Cisco Memory',3,'memory','',510,150,0,0,0),(11,'Drops',4,'drop_packets','',500,175,0,0,0),(14,'BGP Updates',6,'bgp_updates','',500,150,0,0,0),(15,'Used Storage',8,'storage','',500,150,0,0,1),(16,'CSS VIP Hits',9,'css_vip_hits','',500,150,0,0,0),(17,'CSS VIP Traffic',9,'css_vip_output_only_traffic','',500,150,0,0,0),(18,'Solaris Memory Usage',10,'ucd_memory','',500,180,0,0,0),(19,'Solaris Load Average',10,'ucd_load_average','',500,150,0,0,0),(20,'Solaris CPU Usage',10,'ucd_cpu_solaris','',500,175,0,0,0),(21,'CPU Usage',11,'ucd_cpu_linux','',500,175,0,0,1),(22,'Load Average',11,'ucd_load_average','',500,150,0,0,1),(23,'Established Connections',2,'tcp_conn_number','',500,175,0,0,1),(24,'Connection Delay',2,'tcp_conn_delay','',500,175,0,0,0),(25,'IP Accounting',3,'acct_bytes','acct_packets',275,170,260,170,0),(26,'Processes / Users',12,'hostmib_users_procs','',500,170,0,0,0),(27,'TCP Connection Status',12,'tcpmib_connections','',500,150,0,0,0),(28,'Processor Utilization',12,'cpu_util','',500,175,0,0,0),(29,'Processes / Users',11,'hostmib_users_procs','',500,170,0,0,0),(30,'TCP Connection Status',11,'tcpmib_connections','',500,150,0,0,0),(31,'TCP Connection Status',3,'tcpmib_connections','',500,150,0,0,0),(32,'Accounted Packets',13,'cisco_mac_packets','',500,150,0,0,0),(33,'Accounted Bytes',13,'cisco_mac_bytes','',500,150,0,0,0),(34,'SP RTT & Loss',14,'rtt','packetloss',270,170,265,170,0),(35,'Median RTT',14,'rtt','',500,175,0,0,0),(36,'Packets Lost',14,'packetloss','',500,175,0,0,0),(37,'Temperature',17,'temperature','',500,180,0,0,1),(38,'SA Agent Round-Trip Latency',19,'cisco_saagent_rtl','',500,150,0,0,0),(39,'SA Agent Jitter',19,'cisco_saagent_jitter','',500,150,0,0,0),(40,'SA Agent % Packet Loss',19,'cisco_saagent_packetloss','',500,150,0,0,0),(41,'Host Round Trip Time',20,'rtt','',500,150,0,0,0),(42,'Host Packet Loss',20,'packetloss','',500,175,0,0,0),(43,'TC Class Rate',21,'tc_rate','',500,150,0,0,1),(44,'Instances/Memory',15,'apps_instances','apps_memory',250,175,280,175,0),(45,'Connection Delay',23,'tcp_conn_delay','',500,175,0,0,0),(46,'Temperature',26,'temperature','',500,175,0,0,1),(47,'Packets New',4,'packets_new','',610,170,0,0,0),(48,'Livingston Portmaster Serial',28,'pm_serial','',500,175,0,0,0),(49,'CGI Requests',27,'iis_tcgir','',500,150,0,0,0),(50,'POSTs and GETs',27,'iis_tptg','',500,150,0,0,0),(51,'Files Sent',27,'iis_tfs','',500,150,0,0,0),(52,'Bytes Received',27,'iis_tbr','',500,150,0,0,0),(53,'Hits',29,'apache_tac','',500,175,0,0,1),(54,'KBytes',29,'apache_tkb','',500,175,0,0,1),(55,'Apache CPU Load',29,'apache_cplo','',500,175,0,0,0),(59,'Bytes Per Request',29,'apache_bpr','',500,175,0,0,0),(60,'Workers',29,'apache_workers','',500,175,0,0,0),(61,'Load/Capacity',31,'apc_load_capacity','',500,175,0,0,0),(62,'Voltages',31,'apc_voltages','',500,150,0,0,0),(63,'Time Remaining',31,'apc_time_remaining','',500,150,0,0,0),(64,'Temperature',31,'temperature','',500,150,0,0,0),(65,'Records',30,'sql_records','',500,150,0,0,0),(66,'Traffic',32,'alteon_octets','',500,175,0,0,1),(67,'Session Rate',32,'alteon_sessionrate','',500,175,0,0,1),(68,'Failures',32,'alteon_failures_sessions','',500,175,0,0,0),(69,'Current Sessions',32,'alteon_sessions','',500,175,0,0,1),(70,'Current Sessions',33,'alteon_sessions','',500,175,0,0,1),(71,'Sessions Rate',33,'alteon_sessionrate','',500,175,0,0,1),(72,'Octets',33,'alteon_octets','',500,175,0,0,1),(73,'Response Time',34,'response_time','',500,175,0,0,0),(74,'Memory',35,'alteon_memory','',500,175,0,0,0),(75,'CPU Load',35,'alteon_load_average','',500,175,0,0,0),(76,'TCP Connections',35,'tcpmib_connections','',500,150,0,0,0),(77,'Sensor Value',36,'brocade_sensor','',500,175,0,0,0),(78,'Frames',37,'frames','',500,175,0,0,0),(79,'Traffic',37,'traffic_words','',500,175,0,0,0),(80,'Cisco Dialup Usage',38,'cisco_serial','',500,175,0,0,0),(81,'Time Usage',39,'inf_ldisk_time','',500,150,0,0,0),(82,'I/O Rate',39,'inf_ldisk_rate','',500,150,0,0,0),(83,'Battery Temperature',40,'temperature','',500,150,0,0,0),(84,'Time Remaining',40,'ups_time_remaining','',500,150,0,0,0),(85,'UPS Voltage',41,'ups_voltage','',500,150,0,0,1),(86,'UPS Current',41,'ups_current','',500,150,0,0,1),(87,'UPS Load',41,'ups_load','',500,150,0,0,1),(88,'Charge Remaining',40,'ups_charge_remaining','',500,150,0,0,0),(89,'IPTables Rate',42,'iptables_rate','',500,150,0,170,1),(90,'Routes',6,'bgp_routes','',500,150,0,0,0),(91,'PIX Connections',43,'pix_connections','',500,175,0,0,0),(92,'NAT Active Binds',44,'cisco_nat_active','',500,150,0,0,0),(93,'NAT Packets',44,'cisco_nat_packets','',500,150,0,0,0),(94,'Sensor Value',45,'sensor_value','',500,150,0,0,0),(95,'OS/400 CPU Usage',46,'cpu_os400','',500,150,0,0,0),(96,'Dell OpenManage Ambient Temp',47,'dell_om_temp','',500,150,0,0,0),(97,'Dell OpenManage Fan RPM',47,'dell_om_fan','',500,150,0,0,0),(98,'UPS Power',41,'ups_power','',500,150,0,0,1),(99,'PDU Load',49,'pdu_load','',500,150,0,0,1),(102,'Time Usage',57,'inf_ldisk_time','',500,175,0,0,0),(103,'I/O Byte Rate',57,'inf_ldisk_rate','',500,175,0,0,0),(104,'I/O Ops Rate',57,'inf_ldisk_opsrate','',500,175,0,0,0),(105,'FC Frames',52,'frames','',500,175,0,0,0),(106,'IBM Blade CPU Temp',51,'ibm_blade_cpu_temp','',500,150,0,0,0),(107,'IBM Blade Power',54,'ibm_blade_power','',500,150,0,0,0),(101,'Wireless Associated',53,'cisco_80211X_associated','',500,175,0,0,0);
/*!40000 ALTER TABLE `graph_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hosts`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hosts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip_tacacs` char(16) NOT NULL DEFAULT '',
  `ip` varchar(39) NOT NULL DEFAULT '',
  `name` char(255) NOT NULL,
  `rocommunity` char(100) NOT NULL DEFAULT '',
  `rwcommunity` char(100) NOT NULL DEFAULT '',
  `zone` int(10) NOT NULL DEFAULT '0',
  `tftp` char(20) NOT NULL DEFAULT '',
  `autodiscovery` int(10) NOT NULL DEFAULT '1',
  `config_type` int(10) NOT NULL DEFAULT '1',
  `autodiscovery_default_customer` int(10) NOT NULL DEFAULT '1',
  `satellite` int(10) NOT NULL DEFAULT '1',
  `dmii` char(10) NOT NULL DEFAULT '1',
  `lat` decimal(12,2) NOT NULL DEFAULT '0.00',
  `lon` decimal(12,2) NOT NULL DEFAULT '0.00',
  `show_host` tinyint(1) NOT NULL DEFAULT '1',
  `poll` tinyint(1) NOT NULL DEFAULT '1',
  `creation_date` int(10) NOT NULL DEFAULT '0',
  `modification_date` int(10) NOT NULL DEFAULT '0',
  `last_poll_date` int(10) NOT NULL DEFAULT '0',
  `last_poll_time` int(10) NOT NULL DEFAULT '0',
  `poll_interval` int(10) NOT NULL DEFAULT '300',
  `dmii_up` tinyint(1) NOT NULL DEFAULT '1',
  `sysobjectid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `zone` (`zone`),
  KEY `ip` (`ip`),
  KEY `ip_tacacs` (`ip_tacacs`),
  KEY `autodiscovery_default_customer` (`autodiscovery_default_customer`),
  KEY `autodiscovery` (`autodiscovery`),
  KEY `satellite` (`satellite`),
  KEY `poll` (`poll`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hosts`
--

LOCK TABLES `hosts` WRITE;
/*!40000 ALTER TABLE `hosts` DISABLE KEYS */;
INSERT INTO `hosts` VALUES (1,'','','Unknown','','',1,'',1,1,1,1,'1','0.00','0.00',1,1,0,0,1232673711,0,300,1,NULL);
/*!40000 ALTER TABLE `hosts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hosts_config`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hosts_config` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `host` int(10) NOT NULL DEFAULT '0',
  `config` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `host` (`host`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Hosts Config Files';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hosts_config`
--

LOCK TABLES `hosts_config` WRITE;
/*!40000 ALTER TABLE `hosts_config` DISABLE KEYS */;
INSERT INTO `hosts_config` VALUES (1,'0000-00-00 00:00:00',1,'No Config');
/*!40000 ALTER TABLE `hosts_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hosts_config_types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hosts_config_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(60) NOT NULL DEFAULT '',
  `command` char(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='Host Config Commands';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hosts_config_types`
--

LOCK TABLES `hosts_config_types` WRITE;
/*!40000 ALTER TABLE `hosts_config_types` DISABLE KEYS */;
INSERT INTO `hosts_config_types` VALUES (1,'No Configuration Transfer','none'),(2,'Cisco IOS, Newer than 12.0 (CONFIG-COPY-MIB)','cisco_cc'),(3,'Cisco IOS, Older than 12.0 (SYS-MIB)','cisco_sys'),(4,'Cisco CatOS, Catalyst Switches (STACK-MIB)','cisco_catos'),(5,'Alteon WebOS Switches (DANGEROUS)','alteon_webos');
/*!40000 ALTER TABLE `hosts_config_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interface_types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interface_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` varchar(40) NOT NULL DEFAULT '',
  `autodiscovery_validate` tinyint(1) NOT NULL DEFAULT '0',
  `autodiscovery_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `autodiscovery_function` varchar(40) NOT NULL DEFAULT '',
  `autodiscovery_parameters` varchar(200) NOT NULL DEFAULT '',
  `autodiscovery_default_poller` int(10) NOT NULL DEFAULT '1',
  `have_graph` tinyint(1) NOT NULL DEFAULT '0',
  `rrd_structure_rra` text NOT NULL,
  `rrd_structure_res` varchar(20) NOT NULL DEFAULT '',
  `rrd_structure_step` int(4) NOT NULL DEFAULT '300',
  `graph_default` int(10) NOT NULL DEFAULT '1',
  `break_by_card` tinyint(1) NOT NULL DEFAULT '0',
  `update_handler` varchar(30) NOT NULL DEFAULT 'none',
  `allow_manual_add` tinyint(1) NOT NULL DEFAULT '0',
  `sla_default` int(10) NOT NULL DEFAULT '1',
  `have_tools` tinyint(1) NOT NULL DEFAULT '0',
  `snmp_oid` varchar(255) NOT NULL DEFAULT '.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `autodiscovery_enabled` (`autodiscovery_enabled`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interface_types`
--

LOCK TABLES `interface_types` WRITE;
/*!40000 ALTER TABLE `interface_types` DISABLE KEYS */;
INSERT INTO `interface_types` VALUES (1,'No Interface Type',0,0,'none','',1,0,'','',300,1,0,'none',0,1,0,'.'),(2,'TCP Ports',0,1,'tcp_ports','-sT -p1-500,600-1024',5,1,'RRA:LAST:0.5:1:<resolution>','103680',300,23,0,'tcp_ports',1,1,1,''),(3,'Cisco System Info',1,1,'host_information','cisco,9.1,9.5',3,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,9,0,'none',0,7,0,'ent.9'),(4,'Physical Interfaces',1,1,'snmp_interfaces','',61,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,3,1,'none',0,1,1,'.'),(6,'BGP Neighbors',1,1,'bgp_peers','',8,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,90,0,'none',0,1,0,'.'),(8,'Storage',1,1,'storage','',9,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,15,0,'none',0,9,0,'.'),(9,'CSS VIPs',0,1,'css_vips','',10,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,17,0,'none',0,1,0,'ent.9'),(10,'Solaris System Info',1,1,'host_information','solaris,sparc,sun,11.2.3.10,8072.3.2.3',12,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,20,0,'none',0,1,0,'.'),(11,'Linux/Unix System Info',1,1,'host_information','2021.250.10,linux,2021.250.255,freebsd,netSnmp,8072',11,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,21,0,'none',0,10,0,'.'),(12,'Windows System Info',1,1,'host_information','enterprises.311',13,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,28,0,'none',0,11,0,'.'),(13,'Cisco MAC Accounting',1,1,'cisco_accounting','',14,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,33,0,'none',0,1,0,'.'),(14,'Smokeping Host',1,1,'smokeping','/var/lib/smokeping',15,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,34,0,'none',0,8,0,''),(15,'Applications',1,0,'hostmib_apps','',16,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,44,0,'none',0,1,0,'.'),(16,'Cisco Power Supply',1,1,'cisco_envmib','PowerSupply,5.1.2,5.1.3',17,0,'','103680',300,1,1,'none',0,1,0,'ent.9'),(17,'Cisco Temperature',1,1,'cisco_envmib','Temperature,3.1.2,3.1.6',18,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,37,1,'none',0,1,0,'ent.9'),(18,'Cisco Voltage',1,1,'cisco_envmib','Voltage,2.1.2,2.1.7',19,0,'','103680',300,1,1,'none',0,1,0,'ent.9'),(19,'Cisco SA Agent',1,1,'cisco_saagent','',20,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,39,0,'none',0,1,0,'ent.9'),(20,'Reachable',1,1,'reachability','',21,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,41,0,'none',0,1,0,''),(21,'Linux Traffic Control',1,1,'linux_tc','.1.3.6.1.4.1.2021.5001',22,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,43,1,'none',0,1,0,'.'),(22,'NTP',0,1,'ntp_client','',23,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,''),(23,'UDP Ports',0,0,'tcp_ports','-sU -p1-500,600-1024 --host_timeout 15000',24,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,45,0,'tcp_ports',1,1,0,''),(24,'Compaq Physical Drives',0,1,'cpqmib','phydrv',25,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(25,'Compaq Fans',0,1,'cpqmib','fans',26,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(26,'Compaq Temperature',0,1,'cpqmib','temperature',27,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,46,0,'none',0,1,0,'.'),(27,'IIS Webserver Information',0,1,'iis_info','',28,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,50,0,'none',0,1,0,'.'),(28,'Livingston Serial Port',0,1,'livingston_serial_port','',29,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,48,0,'none',0,1,0,'.'),(29,'Apache',0,1,'apache','',30,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,53,0,'none',1,1,0,''),(30,'SQL Query',0,1,'none','',32,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,65,0,'none',1,1,0,''),(31,'APC',1,1,'apc','enterprises.318',31,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,61,0,'none',0,1,0,'.'),(32,'Alteon Real Server',1,1,'alteon_realservers','',33,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,66,0,'none',0,1,0,'ent.1872'),(33,'Alteon Virtual Server',0,1,'alteon_virtualservers','',34,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,70,0,'none',0,1,0,'ent.1872'),(34,'Alteon Real Services',0,1,'alteon_realservices','',35,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,73,0,'none',0,1,0,'ent.1872'),(35,'Alteon System Info',1,1,'host_information','enterprises.1872',36,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,75,0,'none',0,1,0,'ent.1872'),(36,'Brocade Sensors',0,0,'brocade_sensors','',37,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,77,0,'none',0,1,0,'ent.1588'),(37,'Brocade FC Ports',0,0,'brocade_fcports','',38,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,78,0,'none',0,1,0,'ent.1588'),(38,'Cisco Dialup Usage',1,1,'cisco_serial_port','',39,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,80,0,'none',0,1,0,'ent.9'),(39,'Windows Logical Disks',1,1,'informant_ldisks','',40,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,82,0,'none',0,1,0,'.'),(40,'UPS',1,1,'ups','',41,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,84,0,'none',0,1,0,'.'),(41,'UPS Lines',0,1,'ups_lines','',42,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,85,0,'none',0,1,0,'.'),(42,'IPTables Chains',1,1,'linux_iptables','.1.3.6.1.4.1.2021.5002',43,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,89,1,'none',0,1,0,'.'),(43,'Cisco PIX',1,1,'pix_connections','',44,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,91,0,'none',0,1,0,'ent.9'),(44,'Cisco NAT',0,1,'simple','.1.3.6.1.4.1.9.10.77.1.2.1.0,NAT',45,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,93,0,'none',0,1,0,'ent.9'),(45,'Sensors',1,1,'sensors','',46,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,94,1,'none',0,1,0,'.'),(46,'OS/400 System Info',1,1,'simple','.1.3.6.1.4.1.2.6.4.5.1.0,OS400',47,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,95,0,'none',0,1,0,'.'),(47,'Dell Chassis',1,1,'simple','.1.3.6.1.4.1.674.10892.1.200.10.1.2.1,Chassis status',48,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(48,'PDU',1,1,'pdu','',49,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(49,'PDU Banks',0,1,'pdu_banks','',50,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,99,0,'none',0,1,0,'.'),(50,'IBM Component Health',1,0,'ibm_ComponentHealth','',57,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(51,'IBM Blade server',1,0,'ibm_blade_servers','',51,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,106,0,'none',0,1,0,'.'),(52,'Generic FC Ports',1,0,'fc_ports','',52,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,105,0,'none',0,1,0,'.'),(53,'Cisco Wireless Device',1,0,'simple','.1.3.6.1.4.1.9.9.273.1.1.2.1.1.1,Cisco AP',53,1,'RRA:AVERAGE:0.5:1\r\n:<resolution>','103680',300,101,0,'none',0,1,0,'ent.9'),(54,'IBM Blade Power',1,0,'ibm_blade_power','',54,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,107,0,'none',0,1,0,'.'),(55,'Compaq Power Supply',1,0,'cpqmib','powersupply',55,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(56,'IBM Storage Controller',0,0,'ibm_ds_storage','storagesubsystem',56,0,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,1,0,'none',0,1,0,'.'),(57,'Informant Disks 64',1,1,'informant_adv_ldisks','',58,1,'RRA:AVERAGE:0.5:1:<resolution>','103680',300,102,0,'none',0,1,0,'.');
/*!40000 ALTER TABLE `interface_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interface_types_field_types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interface_types_field_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(30) NOT NULL DEFAULT '',
  `handler` char(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interface_types_field_types`
--

LOCK TABLES `interface_types_field_types` WRITE;
/*!40000 ALTER TABLE `interface_types_field_types` DISABLE KEYS */;
INSERT INTO `interface_types_field_types` VALUES (1,'Unknown','none'),(3,'Index','text'),(5,'Boolean','bool'),(7,'Description','text'),(8,'Other','text'),(20,'RRDTool DS','rrd_ds');
/*!40000 ALTER TABLE `interface_types_field_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interface_types_fields`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interface_types_fields` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  `name` char(40) NOT NULL DEFAULT '',
  `pos` int(3) NOT NULL DEFAULT '10',
  `itype` int(10) NOT NULL DEFAULT '1',
  `ftype` int(10) NOT NULL DEFAULT '1',
  `showable` tinyint(1) NOT NULL DEFAULT '1',
  `overwritable` tinyint(1) NOT NULL DEFAULT '1',
  `tracked` tinyint(1) NOT NULL DEFAULT '0',
  `default_value` char(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `ftype_itype` (`ftype`,`itype`),
  KEY `ftype` (`ftype`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interface_types_fields`
--

LOCK TABLES `interface_types_fields` WRITE;
/*!40000 ALTER TABLE `interface_types_fields` DISABLE KEYS */;
INSERT INTO `interface_types_fields` VALUES (1,'Unknown','unknown',10,1,1,0,0,0,''),(3,'SNMP IFIndex','interfacenumber',60,4,3,1,1,0,''),(4,'Description','description',10,4,7,1,1,1,''),(5,'IP Address','address',30,4,7,1,1,0,''),(6,'Input Bandwidth','bandwidthin',50,4,8,1,1,0,'1'),(7,'Port Number','port',10,2,3,1,1,0,''),(9,'Check Content','check_content',30,2,5,2,1,0,'0'),(10,'Port Description','description',20,2,7,1,1,0,''),(11,'Input Bytes','input',10,4,20,0,0,0,'DS:input:COUNTER:600:0:<bandwidth>'),(12,'Established Connections','tcp_conn_number',10,2,20,0,0,0,'DS:tcp_conn_number:GAUGE:600:0:10000'),(13,'Check Content URL','check_url',40,2,8,2,1,0,''),(14,'Output Bytes','output',20,4,20,0,0,0,'DS:output:COUNTER:600:0:<bandwidth>'),(15,'Input Packets','inpackets',70,4,20,0,0,0,'DS:inpackets:COUNTER:600:0:<bandwidth>'),(16,'Flip In Out in Graphs','flipinout',70,4,5,2,1,0,'0'),(20,'Connection Delay','conn_delay',20,2,20,0,0,0,'DS:conn_delay:GAUGE:600:0:100000'),(21,'Output Bandwidth','bandwidthout',51,4,8,2,1,0,'1'),(22,'Peer Address','peer',36,4,8,1,1,0,''),(23,'Input Errors','inputerrors',30,4,20,0,0,0,'DS:inputerrors:COUNTER:600:0:<bandwidth>'),(24,'Output Errors','outputerrors',40,4,20,0,0,0,'DS:outputerrors:COUNTER:600:0:<bandwidth>'),(25,'Round Trip Time','rtt',50,4,20,0,0,0,'DS:rtt:GAUGE:600:0:10000'),(26,'PacketLoss','packetloss',60,4,20,0,0,0,'DS:packetloss:GAUGE:600:0:1000'),(27,'Output Packets','outpackets',80,4,20,0,0,0,'DS:outpackets:COUNTER:600:0:<bandwidth>'),(28,'Drops','drops',90,4,20,0,0,0,'DS:drops:COUNTER:600:0:<bandwidth>'),(29,'Not Used','aux4',100,4,20,0,0,0,'DS:aux4:COUNTER:600:0:<bandwidth>'),(30,'Saved Input Bandwidth','bandwidthin',110,4,20,0,0,0,'DS:bandwidthin:GAUGE:600:0:<bandwidth>'),(31,'Saved Output Bandwidth','bandwidthout',120,4,20,0,0,0,'DS:bandwidthout:GAUGE:600:0:<bandwidth>'),(32,'Index','index',10,12,3,0,0,0,''),(33,'Description','description',20,12,7,1,0,1,'System Information'),(34,'Number of Processors','cpu_num',30,12,8,1,1,0,'1'),(35,'Index','index',10,11,3,0,0,0,''),(36,'Description','description',20,11,7,1,0,1,'System Information'),(37,'Number of CPUs','cpu_num',30,11,8,1,1,0,'1'),(43,'CPU','cpu',10,3,20,0,0,0,'DS:cpu:GAUGE:600:0:100'),(44,'Mem Used','mem_used',20,3,20,0,0,0,'DS:mem_used:GAUGE:600:0:100000000000'),(45,'Mem Free','mem_free',30,3,20,0,0,0,'DS:mem_free:GAUGE:600:0:100000000000'),(46,'Acct Packets','acct_packets',40,3,20,0,0,0,'DS:acct_packets:ABSOLUTE:600:0:100000000000'),(47,'Acct Bytes','acct_bytes',50,3,20,0,0,0,'DS:acct_bytes:GAUGE:600:0:100000000000'),(48,'Tcp Active','tcp_active',60,3,20,0,0,0,'DS:tcp_active:COUNTER:600:0:10000000'),(49,'Tcp Passive','tcp_passive',70,3,20,0,0,0,'DS:tcp_passive:COUNTER:600:0:1000000'),(50,'Tcp Established','tcp_established',80,3,20,0,0,0,'DS:tcp_established:COUNTER:600:0:1000000'),(51,'Bgpin','bgpin',10,6,20,0,0,0,'DS:bgpin:COUNTER:600:0:10000000'),(52,'Bgpout','bgpout',20,6,20,0,0,0,'DS:bgpout:COUNTER:600:0:10000000'),(53,'Bgpuptime','bgpuptime',30,6,20,0,0,0,'DS:bgpuptime:GAUGE:600:0:10000000'),(56,'Storage Block Size','storage_block_size',10,8,20,0,0,0,'DS:storage_block_size:GAUGE:600:0:<size>'),(57,'Storage Block Count','storage_block_count',20,8,20,0,0,0,'DS:storage_block_count:GAUGE:600:0:<size>'),(58,'Storage Used Blocks','storage_used_blocks',30,8,20,0,0,0,'DS:storage_used_blocks:GAUGE:600:0:<size>'),(59,'Output','output',10,9,20,0,0,0,'DS:output:COUNTER:600:0:<bandwidth>'),(60,'Hits','hits',20,9,20,0,0,0,'DS:hits:COUNTER:600:0:<bandwidth>'),(61,'Cpu User Ticks','cpu_user_ticks',10,10,20,0,0,0,'DS:cpu_user_ticks:COUNTER:600:0:86400'),(62,'Cpu Idle Ticks','cpu_idle_ticks',20,10,20,0,0,0,'DS:cpu_idle_ticks:COUNTER:600:0:86400'),(63,'Cpu Wait Ticks','cpu_wait_ticks',30,10,20,0,0,0,'DS:cpu_wait_ticks:COUNTER:600:0:86400'),(64,'Cpu Kernel Ticks','cpu_kernel_ticks',40,10,20,0,0,0,'DS:cpu_kernel_ticks:COUNTER:600:0:86400'),(65,'Swap Total','swap_total',50,10,20,0,0,0,'DS:swap_total:GAUGE:600:0:10000000000'),(66,'Swap Available','swap_available',60,10,20,0,0,0,'DS:swap_available:GAUGE:600:0:10000000000'),(67,'Mem Total','mem_total',70,10,20,0,0,0,'DS:mem_total:GAUGE:600:0:10000000000'),(68,'Mem Available','mem_available',80,10,20,0,0,0,'DS:mem_available:GAUGE:600:0:10000000000'),(69,'Load Average 1','load_average_1',90,10,20,0,0,0,'DS:load_average_1:GAUGE:600:0:1000'),(70,'Load Average 5','load_average_5',100,10,20,0,0,0,'DS:load_average_5:GAUGE:600:0:1000'),(71,'Load Average 15','load_average_15',110,10,20,0,0,0,'DS:load_average_15:GAUGE:600:0:1000'),(72,'Cpu User Ticks','cpu_user_ticks',10,11,20,0,0,0,'DS:cpu_user_ticks:COUNTER:600:0:86400'),(73,'Cpu Idle Ticks','cpu_idle_ticks',20,11,20,0,0,0,'DS:cpu_idle_ticks:COUNTER:600:0:86400'),(74,'Cpu Nice Ticks','cpu_nice_ticks',30,11,20,0,0,0,'DS:cpu_nice_ticks:COUNTER:600:0:86400'),(75,'Cpu System Ticks','cpu_system_ticks',40,11,20,0,0,0,'DS:cpu_system_ticks:COUNTER:600:0:86400'),(76,'Load Average 1','load_average_1',50,11,20,0,0,0,'DS:load_average_1:GAUGE:600:0:1000'),(77,'Load Average 5','load_average_5',60,11,20,0,0,0,'DS:load_average_5:GAUGE:600:0:1000'),(78,'Load Average 15','load_average_15',70,11,20,0,0,0,'DS:load_average_15:GAUGE:600:0:1000'),(79,'Num Users','num_users',80,11,20,0,0,0,'DS:num_users:GAUGE:600:0:100000'),(80,'Num Procs','num_procs',90,11,20,0,0,0,'DS:num_procs:GAUGE:600:0:10000000'),(81,'Tcp Active','tcp_active',100,11,20,0,0,0,'DS:tcp_active:COUNTER:600:0:10000000'),(82,'Tcp Passive','tcp_passive',110,11,20,0,0,0,'DS:tcp_passive:COUNTER:600:0:1000000'),(83,'Tcp Established','tcp_established',120,11,20,0,0,0,'DS:tcp_established:COUNTER:600:0:1000000'),(84,'CPU','cpu',10,12,20,0,0,0,'DS:cpu:GAUGE:600:0:100'),(85,'Num Users','num_users',20,12,20,0,0,0,'DS:num_users:GAUGE:600:0:100000'),(86,'Num Procs','num_procs',30,12,20,0,0,0,'DS:num_procs:GAUGE:600:0:10000000'),(87,'Tcp Active','tcp_active',40,12,20,0,0,0,'DS:tcp_active:COUNTER:600:0:10000000'),(88,'Tcp Passive','tcp_passive',50,12,20,0,0,0,'DS:tcp_passive:COUNTER:600:0:1000000'),(89,'Tcp Established','tcp_established',60,12,20,0,0,0,'DS:tcp_established:COUNTER:600:0:1000000'),(90,'Input','input',10,13,20,0,0,0,'DS:input:COUNTER:600:0:10000000000'),(91,'Output','output',20,13,20,0,0,0,'DS:output:COUNTER:600:0:10000000000'),(92,'Inputpackets','inputpackets',30,13,20,0,0,0,'DS:inputpackets:COUNTER:600:0:10000000000'),(93,'Outputpackets','outputpackets',40,13,20,0,0,0,'DS:outputpackets:COUNTER:600:0:10000000000'),(94,'RTT','rtt',10,14,20,0,0,0,'DS:rtt:GAUGE:600:0:10000'),(95,'Packetloss','packetloss',20,14,20,0,0,0,'DS:packetloss:GAUGE:600:0:1000'),(98,'Temperature','temperature',10,17,20,0,0,0,'DS:temperature:GAUGE:600:0:100'),(100,'Forward Jitter','forward_jitter',10,19,20,0,0,0,'DS:forward_jitter:GAUGE:600:0:100'),(101,'Backward Jitter','backward_jitter',20,19,20,0,0,0,'DS:backward_jitter:GAUGE:600:0:100'),(102,'Rt Latency','rt_latency',30,19,20,0,0,0,'DS:rt_latency:GAUGE:600:0:100'),(103,'Forward Packetloss','forward_packetloss',40,19,20,0,0,0,'DS:forward_packetloss:GAUGE:600:0:100'),(104,'Backward Packetloss','backward_packetloss',50,19,20,0,0,0,'DS:backward_packetloss:GAUGE:600:0:100'),(105,'RTT','rtt',10,20,20,0,0,0,'DS:rtt:GAUGE:600:0:10000'),(106,'Packetloss','packetloss',20,20,20,0,0,0,'DS:packetloss:GAUGE:600:0:1000'),(107,'Bytes','bytes',10,21,20,0,0,0,'DS:bytes:COUNTER:600:0:<ceil>'),(108,'Packets','packets',20,21,20,0,0,0,'DS:packets:COUNTER:600:0:<ceil>'),(109,'Disk Type','storage_type',10,8,7,1,0,1,''),(110,'Size (Bytes)','size',20,8,7,1,1,1,'0'),(111,'Description','description',30,8,7,1,1,0,''),(112,'Index','index',40,8,3,0,0,0,''),(113,'Index','index',10,10,3,1,0,0,''),(114,'Description','description',20,10,7,1,0,1,'System Information'),(115,'Number of Processors','cpu_num',30,10,8,1,1,0,'1'),(116,'Index','index',10,14,3,1,0,0,''),(117,'Description','description',20,14,7,1,1,0,''),(118,'Index','index',10,20,3,0,0,0,''),(119,'Description','description',20,20,7,1,0,1,''),(120,'Rate','rate',20,21,7,1,0,1,''),(121,'Ceil','ceil',30,21,7,1,0,1,''),(122,'Index','index',50,21,3,1,0,0,''),(123,'Description','description',40,21,7,2,1,0,''),(124,'Index','index',10,9,3,1,0,0,''),(125,'Owner','owner',20,9,7,1,0,1,''),(126,'VIP Address','address',30,9,7,1,0,1,''),(127,'Bandwidth','bandwidth',40,9,8,1,1,0,'1'),(128,'Description','description',20,18,7,1,1,0,''),(129,'Description','description',20,17,7,1,1,0,''),(130,'Description','description',20,16,7,1,1,0,''),(131,'Index','index',30,18,3,1,0,0,''),(132,'Index','index',30,17,3,1,0,0,''),(133,'Index','index',10,16,3,1,0,0,''),(134,'Number of Processors','cpu_num',30,3,8,1,1,0,'1'),(135,'Index','index',10,3,3,1,0,0,''),(136,'Description','description',20,3,7,1,0,1,'System Information'),(137,'Index','index',10,19,3,1,0,0,''),(138,'Description','description',20,19,7,1,1,0,''),(139,'Description','description',20,13,7,1,1,0,''),(140,'Index','index',35,13,3,1,0,0,''),(141,'MAC Address','mac',30,13,8,0,0,1,''),(142,'Interface Index','ifindex',40,13,8,2,0,1,''),(143,'IP Address','address',25,13,7,1,0,1,''),(144,'Flip Graph In/Out','flipinout',45,13,5,2,1,0,'0'),(145,'Local IP','local',30,6,7,1,0,1,''),(146,'Remote IP','remote',40,6,3,1,0,0,''),(147,'Autonomous System','asn',20,6,7,1,0,1,''),(149,'Description','description',50,6,7,2,1,0,''),(150,'Process Name','process_name',10,15,3,2,0,0,''),(151,'Description','description',20,15,7,1,1,0,''),(153,'Instances at Discovery','instances',30,15,8,1,1,0,'1'),(154,'Pings to Send','pings',80,4,8,2,1,0,'50'),(155,'Pings to Send','pings',30,20,8,2,1,0,'50'),(156,'PL Threshold %','threshold',40,20,8,2,1,0,'70'),(157,'Interval (ms)','interval',50,20,8,2,1,0,'300'),(158,'Check Content RegExp','check_regexp',50,2,8,2,1,0,''),(159,'Current Instances','current_instances',10,15,20,0,0,0,'DS:current_instances:GAUGE:600:0:99999'),(160,'Index','index',10,22,3,0,0,0,'1'),(161,'Fixed Admin Status','fixed_admin_status',99,4,5,2,1,0,'0'),(162,'Usage Threshold %','usage_threshold',40,8,8,2,1,0,'80'),(164,'Used Memory','used_memory',20,15,20,0,0,0,'DS:used_memory:GAUGE:600:0:9999999'),(165,'IP Mask','mask',32,4,8,2,1,1,''),(167,'Show in Celcius','show_celcius',40,17,5,2,1,0,'1'),(168,'Port Number','port',10,23,3,1,1,0,''),(169,'Port Description','description',20,23,7,1,1,0,''),(170,'Connection Delay','conn_delay',10,23,20,0,0,0,'DS:conn_delay:GAUGE:600:0:100000'),(171,'Controller','controller',10,24,7,1,0,1,''),(172,'Drive','drvindex',11,24,7,1,0,1,''),(173,'Drive Model','model',15,24,8,1,0,1,''),(174,'Index','index',5,24,3,0,0,0,''),(175,'Index','index',5,25,3,0,0,0,''),(176,'Chassis','chassis',10,25,8,1,0,1,''),(177,'Fan','fanindex',11,25,8,1,0,1,''),(178,'Location','location',20,25,7,1,0,1,''),(179,'Index','index',5,26,3,0,1,0,''),(180,'Chassis','chassis',10,26,7,1,0,1,''),(181,'Sensor','tempindex',11,26,7,1,0,1,''),(182,'Location','location',2,26,7,1,0,1,''),(183,'Temperature','temperature',80,26,20,0,0,0,'DS:temperature:GAUGE:600:0:1000'),(184,'Index','index',10,27,3,0,0,0,'1'),(185,'Total Bytes Received','tbr',10,27,20,0,0,0,'DS:tbr:COUNTER:600:0:999999999'),(186,'Total CGI Requests','tcgir',20,27,20,0,0,0,'DS:tcgir:COUNTER:600:0:999999999'),(187,'Total Files Sent','tfs',30,27,20,0,0,0,'DS:tfs:COUNTER:600:0:999999999'),(188,'Total Gets','tg',40,27,20,0,0,0,'DS:tg:COUNTER:600:0:999999999'),(189,'Total Posts','tp',50,27,20,0,0,0,'DS:tp:COUNTER:600:0:999999999'),(190,'Serial Lines Free','pm_serial_free',10,28,20,1,0,0,'DS:pm_serial_free:GAUGE:600:0:5000'),(191,'Serial Lines Connecting','pm_serial_connecting',20,28,20,1,0,0,'DS:pm_serial_connecting:GAUGE:600:0:5000'),(192,'Serial Lines Established','pm_serial_established',30,28,20,1,0,0,'DS:pm_serial_established:GAUGE:600:0:5000'),(193,'Serial Lines Disconnecting','pm_serial_disconnecting',40,28,20,1,0,0,'DS:pm_serial_disconnecting:GAUGE:600:0:5000'),(194,'Serial Lines Command','pm_serial_command',50,28,20,1,0,0,'DS:pm_serial_command:GAUGE:600:0:5000'),(195,'Serial Lines NoService','pm_serial_noservice',60,28,20,1,0,0,'DS:pm_serial_noservice:GAUGE:600:0:5000'),(196,'Index','index',10,28,3,0,0,0,'1'),(197,'Process Threshold','proc_threshold',40,12,8,2,1,0,'100'),(199,'Description','description',20,29,7,2,1,0,'Apache Stats'),(200,'Total Accesses','tac',30,29,20,0,0,0,'DS:tac:COUNTER:600:0:100000'),(201,'IP:Port','ip_port',10,29,3,1,1,0,''),(202,'Total KBytes','tkb',20,29,20,0,0,0,'DS:tkb:COUNTER:600:0:10000000'),(203,'CPU Load','cplo',60,29,20,0,0,0,'DS:cplo:GAUGE:600:0:1000'),(204,'Uptime','up',10,29,20,0,0,0,'DS:up:GAUGE:600:0:99999999999999'),(205,'Bytes Per Request','bpr',40,29,20,0,0,0,'DS:bpr:GAUGE:600:0:10000000'),(208,'Busy Workers','bw',90,29,20,0,0,0,'DS:bw:GAUGE:600:0:1000'),(209,'Idle Workers','iw',50,29,20,0,0,0,'DS:iw:GAUGE:600:0:1000'),(210,'Index','index',10,31,3,0,0,0,'1'),(211,'Description','description',20,31,7,1,0,1,''),(212,'Battery Capacity','capacity',10,31,20,0,0,0,'DS:capacity:GAUGE:600:0:100'),(213,'Output Load','load',20,31,20,0,0,0,'DS:load:GAUGE:600:0:100'),(214,'Input Voltage','in_voltage',31,31,20,0,0,0,'DS:in_voltage:GAUGE:600:0:400'),(215,'Output Voltage','out_voltage',40,31,20,0,0,0,'DS:out_voltage:GAUGE:600:0:400'),(216,'Time Remaining','time_remaining',50,31,20,0,0,0,'DS:time_remaining:GAUGE:600:0:9999999999'),(217,'Temperature','temperature',60,31,20,0,0,0,'DS:temperature:GAUGE:600:0:200'),(218,'Show Temp in Celcius','show_celcius',31,31,5,2,1,0,'1'),(220,'Index','index',10,30,3,1,1,0,'1'),(221,'Description','description',20,30,7,1,1,0,''),(222,'DSN','dsn',30,30,8,2,1,0,''),(223,'Username','username',40,30,8,2,1,0,''),(224,'Password','password',50,30,8,2,1,0,''),(225,'Max Records','max_records',60,30,8,2,1,0,''),(226,'Min Records','min_records',70,30,8,2,1,0,''),(227,'Counter Records','records_counter',10,30,20,0,0,0,'DS:records_counter:COUNTER:600:0:9999999999'),(228,'Query','query',55,30,8,2,1,0,''),(229,'Absolute Records','records_absolute',20,30,20,0,0,0,'DS:records_absolute:GAUGE:600:0:9999999999'),(230,'Is Absolute?','absolute',80,30,5,1,1,0,'0'),(231,'Percentile','percentile',55,4,8,2,1,0,''),(232,'Index','index',10,32,3,0,0,0,''),(233,'Hostname','hostname',20,32,7,1,1,0,''),(234,'Max Connections','max_connections',30,32,8,2,1,0,''),(235,'Total Sessions','total_sessions',50,32,20,0,0,0,'DS:total_sessions:COUNTER:600:0:100000000'),(236,'Current Sessions','current_sessions',55,32,20,0,0,0,'DS:current_sessions:GAUGE:600:0:<max_connections>'),(237,'Failures','failures',60,32,20,0,0,0,'DS:failures:COUNTER:600:0:10000'),(238,'Octets','octets',65,32,20,0,0,0,'DS:octets:COUNTER:600:0:1000000000'),(239,'Index','index',10,33,3,0,0,1,''),(240,'Hostname','hostname',20,33,7,1,1,0,''),(241,'Total Sessions','total_sessions',30,33,20,0,0,0,'DS:total_sessions:COUNTER:600:0:100000000'),(242,'Current Sessions','current_sessions',35,33,20,0,0,0,'DS:current_sessions:GAUGE:600:0:20000'),(243,'Octets','octets',40,33,20,0,0,0,'DS:octets:COUNTER:600:0:1000000000'),(244,'Index','index',10,34,3,0,0,0,''),(245,'Hostname','hostname',20,34,7,1,0,0,''),(246,'Address','address',30,34,7,1,0,0,''),(247,'Port','port',35,34,7,1,0,0,''),(248,'Real Server','real_server',15,34,8,0,0,1,''),(249,'Response Time','response_time',40,34,20,0,0,0,'DS:response_time:GAUGE:600:0:10000'),(250,'Index','index',10,35,3,0,0,0,''),(251,'Description','description',20,35,7,1,0,0,''),(252,'Number of CPUs','cpu_num',30,35,8,0,0,0,''),(253,'TCP Active','tcp_active',40,35,20,0,0,0,'DS:tcp_active:COUNTER:600:0:10000'),(254,'TCP Passive','tcp_passive',41,35,20,0,0,0,'DS:tcp_passive:COUNTER:600:0:10000'),(255,'TCP Established','tcp_established',42,35,20,0,0,0,'DS:tcp_established:COUNTER:600:0:10000'),(256,'Memory Total','mem_total',50,35,20,0,0,0,'DS:mem_total:GAUGE:600:0:100000000'),(257,'Memory Used','mem_used',51,35,20,0,0,0,'DS:mem_used:GAUGE:600:0:100000000'),(258,'CPU A 1 Sec','cpua_1sec',60,35,20,0,0,0,'DS:cpua_1sec:GAUGE:600:0:1000'),(259,'CPU A 4 Secs','cpua_4secs',61,35,20,0,0,0,'DS:cpua_4secs:GAUGE:600:0:1000'),(260,'CPU A 64 Secs','cpua_64secs',62,35,20,0,0,0,'DS:cpua_64secs:GAUGE:600:0:1000'),(261,'CPU B 1 Sec','cpub_1sec',65,35,20,0,0,0,'DS:cpub_1sec:GAUGE:600:0:1000'),(262,'CPU B 4 Secs','cpub_4secs',66,35,20,0,0,0,'DS:cpub_4secs:GAUGE:600:0:1000'),(263,'CPU B 64 Secs','cpub_64secs',67,35,20,0,0,0,'DS:cpub_64secs:GAUGE:600:0:1000'),(264,'Index','index',10,36,3,0,0,0,''),(265,'Type','sensor_type',30,36,8,1,0,0,''),(266,'Value','sensor_value',40,36,20,0,0,0,'DS:sensor_value:GAUGE:600:0:3000000000'),(267,'Index','index',10,37,3,0,0,0,''),(268,'Description','description',20,37,7,1,0,0,''),(269,'Physical Status','phy',40,37,8,1,0,0,''),(270,'Tx Words','tx_words',40,37,20,0,0,0,'DS:tx_words:COUNTER:600:0:1000000000'),(271,'Rx Words','rx_words',45,37,20,0,0,0,'DS:rx_words:COUNTER:600:0:1000000000'),(272,'Tx Frames','tx_frames',50,37,20,0,0,0,'DS:tx_frames:COUNTER:600:0:100000000'),(273,'Rx Frames','rx_frames',55,37,20,0,0,0,'DS:rx_frames:COUNTER:600:0:100000000'),(274,'Index','index',10,38,3,0,0,0,'1'),(275,'Async Used','cisco_async',10,38,20,0,0,0,'DS:cisco_async:GAUGE:600:0:5000'),(276,'DSX Used','cisco_dsx',20,38,20,0,0,0,'DS:cisco_dsx:GAUGE:600:0:5000'),(277,'Free','cisco_free',30,38,20,0,0,0,'DS:cisco_free:GAUGE:600:0:5000'),(278,'Description','description',20,38,7,2,1,0,''),(279,'System Name','name',40,11,7,1,0,1,''),(280,'Location','location',50,11,7,1,0,1,''),(281,'Contact','contact',60,11,7,1,0,1,''),(282,'System Name','name',50,12,7,1,0,1,''),(283,'Location','location',60,12,7,1,0,1,''),(284,'Contact','contact',70,12,7,1,0,1,''),(285,'System Name','name',40,3,7,1,0,1,''),(286,'Location','location',50,3,7,1,0,1,''),(287,'Contact','contact',60,3,7,1,0,1,''),(288,'System Name','name',40,10,7,1,0,1,''),(289,'Location','location',50,10,7,1,0,1,''),(290,'Contact','contact',60,10,7,1,0,1,''),(291,'System Name','name',40,35,7,1,0,1,''),(292,'Location','location',50,35,7,1,0,1,''),(293,'Contact','contact',60,35,7,1,0,1,''),(294,'Index','index',10,39,3,0,0,0,''),(295,'Description','description',20,39,7,2,1,0,'SNMP Informant Disk Stats'),(296,'lDisk % Read Time','inf_d_read_time',20,39,20,0,0,0,'DS:inf_d_read_time:GAUGE:600:0:100'),(297,'lDisk % Write Time','inf_d_write_time',10,39,20,0,0,0,'DS:inf_d_write_time:GAUGE:600:0:100'),(298,'lDisk Read Rate','inf_d_read_rate',30,39,20,0,0,0,'DS:inf_d_read_rate:GAUGE:600:0:1048576000'),(299,'lDisk Write Rate','inf_d_write_rate',25,39,20,0,0,0,'DS:inf_d_write_rate:GAUGE:600:0:1048576000'),(300,'Index','index',10,40,3,0,0,0,'1'),(301,'Identification','ident',20,40,7,1,0,1,''),(302,'Description','description',30,40,7,2,1,0,''),(303,'Battery Temperature','temperature',10,40,20,0,0,0,'DS:temperature:GAUGE:600:0:200'),(304,'Show in Celcius','show_celcius',40,40,5,2,1,0,'1'),(305,'Minutes Remaining','minutes_remaining',20,40,20,0,0,0,'DS:minutes_remaining:GAUGE:600:0:10000'),(306,'Index','index',10,41,3,0,0,0,''),(307,'Line Type','line_type',20,41,8,0,0,0,''),(308,'Line Index','line_index',30,41,8,0,0,0,''),(309,'Description','description',40,41,7,2,1,0,''),(310,'Voltage','voltage',10,41,20,0,0,0,'DS:voltage:GAUGE:600:0:500'),(311,'Current','current',20,41,20,0,0,0,'DS:current:GAUGE:600:0:100'),(312,'Load','load',30,41,20,0,0,0,'DS:load:GAUGE:600:0:100'),(313,'Charge Remaining','charge_remaining',30,40,20,0,0,0,'DS:charge_remaining:GAUGE:600:0:100'),(314,'IPTables Chain','chainnumber',10,42,3,1,1,0,''),(315,'Default Policy','policy',30,42,7,1,1,0,''),(316,'Number of Packets','ipt_packets',10,42,20,0,0,0,'DS:ipt_packets:COUNTER:600:0:1000000000'),(317,'Number of Bytes','ipt_bytes',20,42,20,0,0,0,'DS:ipt_bytes:COUNTER:600:0:<bandwidth>'),(318,'Description','description',20,42,7,2,1,0,''),(319,'Accepted Routers','accepted_routes',40,6,20,0,0,0,'DS:accepted_routes:GAUGE:600:0:900000'),(320,'Advertised Routers','advertised_routes',50,6,20,0,0,0,'DS:advertised_routes:GAUGE:600:0:900000'),(322,'Estimated Bandwidth','bandwidth',40,42,8,2,1,0,'10240000'),(323,'Index','index',10,43,3,0,0,0,''),(324,'Connections','pix_connections',10,43,20,0,0,0,'DS:pix_connections:GAUGE:600:0:1000000'),(325,'Description','description',20,43,7,1,1,0,''),(326,'Index','index',10,44,3,0,0,0,'1'),(327,'Description','description',20,44,7,2,1,0,''),(328,'Cisco Max Inbound NAT Bytes','NatInMax',30,44,8,2,1,0,'1000000000'),(329,'Cisco Max Outbound NAT Bytes','NatOutMax',40,44,8,2,1,0,'1000000000'),(330,'Cisco NAT Other IP Outbound','cisco_nat_other_ip_outbound',10,44,20,0,0,0,'DS:cisco_nat_other_ip_outbound:COUNTER:600:0:<NatOutMax>'),(331,'Cisco NAT Other IP Inbound','cisco_nat_other_ip_inbound',15,44,20,0,0,0,'DS:cisco_nat_other_ip_inbound:COUNTER:600:0:<NatInMax>'),(332,'Cisco NAT ICMP Outbound','cisco_nat_icmp_outbound',20,44,20,0,0,0,'DS:cisco_nat_icmp_outbound:COUNTER:600:0:<NatOutMax>'),(333,'Cisco NAT ICMP Inbound','cisco_nat_icmp_inbound',25,44,20,0,0,0,'DS:cisco_nat_icmp_inbound:COUNTER:600:0:<NatInMax>'),(334,'Cisco NAT UDP Outbound','cisco_nat_udp_outbound',30,44,20,0,0,0,'DS:cisco_nat_udp_outbound:COUNTER:600:0:<NatOutMax>'),(335,'Cisco NAT UDP Inbound','cisco_nat_udp_inbound',35,44,20,0,0,0,'DS:cisco_nat_udp_inbound:COUNTER:600:0:<NatInMax>'),(336,'Cisco NAT TCP Outbound','cisco_nat_tcp_outbound',40,44,20,0,0,0,'DS:cisco_nat_tcp_outbound:COUNTER:600:0:<NatOutMax>'),(337,'Cisco NAT TCP Inbound','cisco_nat_tcp_inbound',45,44,20,0,0,0,'DS:cisco_nat_tcp_inbound:COUNTER:600:0:<NatInMax>'),(338,'Cisco NAT Active Binds','cisco_nat_active_binds',50,44,20,0,0,0,'DS:cisco_nat_active_binds:GAUGE:600:0:100000'),(339,'Index','index',10,45,3,0,0,0,''),(340,'Value','value',10,45,20,0,0,0,'DS:value:GAUGE:600:-100000:100000'),(341,'Description','description',20,45,7,1,1,0,''),(342,'Show in Celcius','show_celcius',31,45,5,2,1,0,'1'),(343,'Show in Celcius','show_in_celcius',30,26,5,2,1,0,'1'),(344,'CPU Usage Threshold','cpu_threshold',90,3,8,2,1,0,'60'),(345,'Index','index',10,46,8,0,0,0,''),(346,'Description','description',20,46,7,2,1,0,''),(347,'CPU Usage','cpu400',10,46,20,0,0,0,'DS:cpu400:GAUGE:600:0:10000'),(348,'CPU Usage Threshold','cpu_threshold',90,11,8,2,1,0,'80'),(350,'Index','index',10,47,3,0,0,0,''),(351,'Description','description',20,47,7,1,1,0,'System Information'),(352,'Dell OpenManage Fan RPM #2','dell_om_fan_2',51,47,20,0,0,0,'DS:dell_om_fan_2:GAUGE:600:0:100000'),(353,'Dell OpenManage Fan RPM #3','dell_om_fan_3',52,47,20,0,0,0,'DS:dell_om_fan_3:GAUGE:600:0:100000'),(354,'Dell OpenManage Fan RPM #4','dell_om_fan_4',53,47,20,0,0,0,'DS:dell_om_fan_4:GAUGE:600:0:100000'),(355,'Dell OpenManage Fan RPM #5','dell_om_fan_5',54,47,20,0,0,0,'DS:dell_om_fan_5:GAUGE:600:0:100000'),(356,'Dell OpenManage Fan RPM #6','dell_om_fan_6',55,47,20,0,0,0,'DS:dell_om_fan_6:GAUGE:600:0:100000'),(357,'Dell OpenManage Fan RPM #7','dell_om_fan_7',56,47,20,0,0,0,'DS:dell_om_fan_7:GAUGE:600:0:100000'),(367,'UPS Type','upstype',50,40,7,1,0,1,''),(358,'UPS Type','upstype',50,41,7,1,0,1,''),(359,'Power','power',50,41,20,0,0,0,'DS:power:GAUGE:600:0:100000'),(360,'Description','description',20,48,7,1,0,0,''),(361,'Index','index',10,48,3,0,0,0,''),(362,'Index','index',10,49,3,0,0,0,''),(363,'Banks','banks',50,48,7,1,0,0,''),(364,'Power Rating  Amps)','powerrating',40,49,7,1,0,0,''),(365,'Load (Amps)','load',50,49,20,0,0,0,'DS:load:GAUGE:600:0:100'),(366,'Overload Threshold','threshold',50,49,7,1,0,0,''),(394,'Index','index',5,50,3,0,0,0,''),(368,'Index','index',10,51,3,0,0,0,''),(369,'Health State','health_state',15,51,7,0,0,1,''),(370,'Serial Number','serial',20,51,7,1,0,1,''),(371,'Manuf date','manuf_date',30,51,7,1,0,1,''),(372,'CPU1 Temperature','temperature',35,51,20,0,0,0,'DS:temperature:GAUGE:600:0:100'),(373,'CPU2 Temperature','temperature2',40,51,20,0,0,0,'DS:temperature2:GAUGE:600:0:100'),(374,'Index','index',10,52,3,0,0,0,''),(375,'Oper Status','oper',30,52,8,1,0,0,''),(376,'Tx Frames','tx_frames',40,52,20,0,0,0,'DS:tx_frames:COUNTER:600:0:100000000'),(377,'Rx Frames','rx_frames',50,52,20,0,0,0,'DS:rx_frames:COUNTER:600:0:100000000'),(378,'FC Port','real_index',11,52,7,1,0,1,''),(379,'Admin Status','admin',20,52,8,1,0,0,''),(380,'Index','index',1,53,3,0,0,0,''),(381,'Description','description',10,53,7,1,1,0,''),(382,'Associated','associated',20,53,20,0,0,0,'DS:associated:GAUGE:600:0:2100'),(383,'Index','index',10,54,3,0,0,0,''),(384,'Power Module 1','module1',15,54,7,1,0,1,''),(385,'Power Module 2','module2',20,54,7,1,0,1,''),(386,'Power Consumption','fuelGaugePowerInUse',35,54,20,2,0,0,'DS:fuelGaugePowerInUse:GAUGE:600:0:10000'),(387,'Power Capacity','totalpower',30,54,7,1,0,0,''),(388,'Index','index',5,55,3,0,0,0,''),(389,'Chassis','chassis',10,55,8,1,0,1,''),(390,'Bay','bayindex',15,55,8,1,0,1,''),(391,'Index','index',1,56,3,0,0,0,''),(392,'Number of arrays','nb_arrays',10,56,8,1,0,0,''),(393,'Cpu Threshold','cpu_threshold',40,46,8,2,1,0,'90'),(406,'Index','index',5,57,3,0,0,0,''),(395,'Description','description',10,57,7,1,1,0,'Ldisk 64'),(396,'Current Queue Length','cur_disk_q',20,57,20,0,0,0,'DS:cur_disk_q:GAUGE:600:0:10000'),(397,'Average Queue Length','avg_disk_q',25,57,20,0,0,0,'DS:avg_disk_q:GAUGE:600:0:10000'),(398,'Average Read Queue Length','avg_disk_rdq',30,57,20,0,0,0,'DS:avg_disk_rdq:GAUGE:600:0:10000'),(399,'Average Write Queue Length','avg_disk_wrq',35,57,20,0,0,0,'DS:avg_disk_wrq:GAUGE:600:0:10000'),(400,'Percent Read Time','inf_d_read_time',40,57,20,0,0,0,'DS:inf_d_read_time:GAUGE:600:0:100'),(401,'Percent Write Time','inf_d_write_time',45,57,20,0,0,0,'DS:inf_d_write_time:GAUGE:600:0:100'),(402,'Reads Per Sec','rd_ops',50,57,20,0,0,0,'DS:rd_ops:GAUGE:600:0:10000'),(403,'Writes Per Sec','wr_ops',55,57,20,0,0,0,'DS:wr_ops:GAUGE:600:0:10000'),(404,'Read Bytes Per Sec','inf_d_read_rate',55,57,20,0,0,0,'DS:inf_d_read_rate:GAUGE:600:0:10000'),(405,'Write Bytes Per Sec','inf_d_write_rate',55,57,20,0,0,0,'DS:inf_d_write_rate:GAUGE:600:0:10000'),(407,'Ignore Case','ignore_case',30,15,8,1,1,0,'0');
/*!40000 ALTER TABLE `interface_types_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interfaces`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interfaces` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` int(10) NOT NULL DEFAULT '1',
  `interface` char(30) NOT NULL DEFAULT '',
  `host` int(10) NOT NULL DEFAULT '1',
  `client` int(10) NOT NULL DEFAULT '1',
  `sla` int(10) NOT NULL DEFAULT '1',
  `poll` int(10) NOT NULL DEFAULT '1',
  `make_sound` tinyint(1) NOT NULL DEFAULT '1',
  `show_rootmap` tinyint(1) NOT NULL DEFAULT '1',
  `rrd_mode` tinyint(2) NOT NULL DEFAULT '2',
  `creation_date` int(10) NOT NULL DEFAULT '0',
  `modification_date` int(10) NOT NULL DEFAULT '0',
  `last_poll_date` int(10) NOT NULL DEFAULT '0',
  `poll_interval` int(5) NOT NULL DEFAULT '0',
  `check_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idint` (`id`),
  KEY `interface` (`interface`),
  KEY `host` (`host`),
  KEY `client` (`client`),
  KEY `poll` (`poll`),
  KEY `sla` (`sla`),
  KEY `interfacehost` (`interface`,`host`),
  KEY `last_poll_date` (`last_poll_date`),
  KEY `type` (`type`),
  KEY `check_status` (`check_status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interfaces`
--

LOCK TABLES `interfaces` WRITE;
/*!40000 ALTER TABLE `interfaces` DISABLE KEYS */;
INSERT INTO `interfaces` VALUES (1,1,'Unknown0',1,1,1,1,1,1,1,0,0,0,0,1);
/*!40000 ALTER TABLE `interfaces` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interfaces_values`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interfaces_values` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `interface` int(10) NOT NULL DEFAULT '0',
  `field` int(10) NOT NULL DEFAULT '0',
  `value` varchar(3000) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `interface_field` (`interface`,`field`),
  KEY `interface` (`interface`),
  KEY `field` (`field`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interfaces_values`
--

LOCK TABLES `interfaces_values` WRITE;
/*!40000 ALTER TABLE `interfaces_values` DISABLE KEYS */;
INSERT INTO `interfaces_values` VALUES (1,1,1,'');
/*!40000 ALTER TABLE `interfaces_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `journal`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `journal` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_stop` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` longtext NOT NULL,
  `subject` varchar(40) NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `ticket` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `journal`
--

LOCK TABLES `journal` WRITE;
/*!40000 ALTER TABLE `journal` DISABLE KEYS */;
INSERT INTO `journal` VALUES (1,'2002-01-20 19:09:07','0000-00-00 00:00:00','Internally used ID','',0,''),(2,'2002-01-20 19:09:07','0000-00-00 00:00:00','Internally used ID','',0,'');
/*!40000 ALTER TABLE `journal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logfiles`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logfiles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `filename` varchar(60) NOT NULL,
  `last_poll_date` int(10) NOT NULL DEFAULT '0',
  `file_offset` int(10) DEFAULT NULL,
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logfiles`
--

LOCK TABLES `logfiles` WRITE;
/*!40000 ALTER TABLE `logfiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `logfiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logfiles_match_groups`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logfiles_match_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `logfile` int(10) NOT NULL,
  `pos` int(10) NOT NULL DEFAULT '10',
  `match_item` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logfiles_match_groups`
--

LOCK TABLES `logfiles_match_groups` WRITE;
/*!40000 ALTER TABLE `logfiles_match_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `logfiles_match_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logfiles_match_items`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logfiles_match_items` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` varchar(30) NOT NULL,
  `match_text` varchar(255) NOT NULL,
  `interface` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `state` varchar(20) NOT NULL,
  `info` varchar(20) NOT NULL,
  `type` int(10) NOT NULL,
  `host` varchar(20) DEFAULT NULL,
  `logfile_id` int(10) NOT NULL DEFAULT '0',
  `pos` int(10) NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logfiles_match_items`
--

LOCK TABLES `logfiles_match_items` WRITE;
/*!40000 ALTER TABLE `logfiles_match_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `logfiles_match_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `maps`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maps` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent` int(10) NOT NULL DEFAULT '0',
  `name` char(60) NOT NULL DEFAULT '',
  `color` char(6) NOT NULL DEFAULT '00A348',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Map Hierarchy';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maps`
--

LOCK TABLES `maps` WRITE;
/*!40000 ALTER TABLE `maps` DISABLE KEYS */;
INSERT INTO `maps` VALUES (1,1,'Root Map','00A348');
/*!40000 ALTER TABLE `maps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `maps_interfaces`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maps_interfaces` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `map` int(10) NOT NULL DEFAULT '0',
  `interface` int(10) NOT NULL DEFAULT '0',
  `x` int(5) NOT NULL DEFAULT '1',
  `y` int(5) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id2` (`id`),
  KEY `map` (`map`),
  KEY `interface` (`interface`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Map to Interface Mapping';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maps_interfaces`
--

LOCK TABLES `maps_interfaces` WRITE;
/*!40000 ALTER TABLE `maps_interfaces` DISABLE KEYS */;
INSERT INTO `maps_interfaces` VALUES (1,1,1,1,1);
/*!40000 ALTER TABLE `maps_interfaces` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nad_hosts`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nad_hosts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `snmp_name` char(120) NOT NULL DEFAULT '',
  `description` varchar(3000) NOT NULL,
  `snmp_community` char(60) NOT NULL DEFAULT '',
  `forwarding` tinyint(2) NOT NULL DEFAULT '0',
  `date_added` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Network AutoDiscovery Hosts';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nad_hosts`
--

LOCK TABLES `nad_hosts` WRITE;
/*!40000 ALTER TABLE `nad_hosts` DISABLE KEYS */;
/*!40000 ALTER TABLE `nad_hosts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nad_ips`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nad_ips` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `host` int(10) NOT NULL DEFAULT '1',
  `ip` char(20) NOT NULL DEFAULT '',
  `type` int(4) NOT NULL DEFAULT '0',
  `network` int(10) NOT NULL DEFAULT '1',
  `dns` char(120) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `host` (`host`,`ip`),
  KEY `network` (`network`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Network AutoDiscovery IPs';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nad_ips`
--

LOCK TABLES `nad_ips` WRITE;
/*!40000 ALTER TABLE `nad_ips` DISABLE KEYS */;
/*!40000 ALTER TABLE `nad_ips` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nad_networks`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nad_networks` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `network` char(20) NOT NULL DEFAULT '',
  `deep` tinyint(2) NOT NULL DEFAULT '1',
  `oper_status` tinyint(2) NOT NULL DEFAULT '1',
  `parent` int(10) NOT NULL DEFAULT '1',
  `seed` int(10) NOT NULL DEFAULT '1',
  `oper_status_changed` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `network` (`network`),
  KEY `parent` (`parent`),
  KEY `seed` (`seed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Network AutoDiscovery Networks';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nad_networks`
--

LOCK TABLES `nad_networks` WRITE;
/*!40000 ALTER TABLE `nad_networks` DISABLE KEYS */;
/*!40000 ALTER TABLE `nad_networks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pollers`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pollers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` char(60) NOT NULL DEFAULT '',
  `description` char(60) NOT NULL DEFAULT '',
  `command` char(60) NOT NULL DEFAULT '',
  `parameters` char(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pollers`
--

LOCK TABLES `pollers` WRITE;
/*!40000 ALTER TABLE `pollers` DISABLE KEYS */;
INSERT INTO `pollers` VALUES (1,'no_poller','No Poller','no_poller',''),(2,'input','SNMP Input Rate','snmp_counter','.1.3.6.1.2.1.2.2.1.10.<interfacenumber>'),(3,'verify_interface_number','Cisco Verify Interface Number','verify_interface_number',''),(5,'cisco_snmp_ping_start','Cisco SNMP Ping Start','cisco_snmp_ping_start',''),(6,'cisco_snmp_ping_wait','Cisco SNMP Ping Wait','cisco_snmp_ping_wait',''),(7,'packetloss','Cisco SNMP Ping Get PL','cisco_snmp_ping_get_pl',''),(8,'rtt','Cisco SNMP Ping Get RTT','cisco_snmp_ping_get_rtt',''),(9,'cisco_snmp_ping_end','Cisco SNMP Ping End','cisco_snmp_ping_end',''),(10,'output','SNMP Output Rate','snmp_counter','.1.3.6.1.2.1.2.2.1.16.<interfacenumber>'),(11,'outputerrors','SNMP Output Errors','snmp_counter','.1.3.6.1.2.1.2.2.1.20.<interfacenumber>'),(12,'inputerrors','SNMP Input Errors','snmp_counter','.1.3.6.1.2.1.2.2.1.14.<interfacenumber>'),(13,'interface_oper_status','SNMP Interface Operational Status','snmp_interface_status_all','8'),(14,'interface_admin_status','SNMP Interface Administrative Status','snmp_interface_status_all','7'),(16,'cpu','Cisco CPU Utilization','snmp_counter','.1.3.6.1.4.1.9.9.109.1.1.1.1.5.1'),(21,'inpackets','SNMP Input Packets','snmp_counter','.1.3.6.1.2.1.2.2.1.11.<interfacenumber>'),(22,'outpackets','SNMP Output Packets','snmp_counter','.1.3.6.1.2.1.2.2.1.17.<interfacenumber>'),(23,'tcp_status,tcp_content,conn_delay','TCP Port Check & Delay','tcp_status',''),(24,'mem_used','Cisco Used Memory','snmp_counter','.1.3.6.1.4.1.9.9.48.1.1.1.5.1'),(25,'mem_free','Cisco Free Memory','snmp_counter','.1.3.6.1.4.1.9.9.48.1.1.1.6.1'),(26,'drops','SNMP Drops','snmp_counter','.1.3.6.1.2.1.2.2.1.19.<interfacenumber>'),(30,'cpu','Cisco 2500 Series CPU Utilization','snmp_counter','.1.3.6.1.4.1.9.2.1.56.0'),(31,'bgpin','BGP Inbound Updates','snmp_counter','.1.3.6.1.2.1.15.3.1.10.<remote>'),(32,'bgpout','BGP Outbound Updates','snmp_counter','.1.3.6.1.2.1.15.3.1.11.<remote>'),(33,'bgpuptime','BGP Uptime','snmp_counter','.1.3.6.1.2.1.15.3.1.16.<remote>'),(35,'storage_used_blocks','Storage Device Used Blocks','snmp_counter','.1.3.6.1.2.1.25.2.3.1.6.<index>'),(36,'storage_block_count','Storage Device Total Blocks','snmp_counter','.1.3.6.1.2.1.25.2.3.1.5.<index>'),(37,'storage_block_size','Storage Device Block Size','snmp_counter','.1.3.6.1.2.1.25.2.3.1.4.<index>'),(38,'bgp_peer_status','BGP Peer Status','bgp_peer_status','<remote>'),(40,'hits','CSS VIP Hits','snmp_counter','.1.3.6.1.4.1.2467.1.16.4.1.18.\"<owner>\".\"<interface>\"'),(41,'output','CSS VIP Traffic Rate','snmp_counter','.1.3.6.1.4.1.2467.1.16.4.1.25.\"<owner>\".\"<interface>\"'),(42,'cpu_kernel_ticks','CPU Kernel Time','snmp_counter','.1.3.6.1.4.1.2021.11.55.0'),(43,'cpu_idle_ticks','CPU Idle Time','snmp_counter','.1.3.6.1.4.1.2021.11.53.0'),(44,'cpu_wait_ticks','CPU Wait Time','snmp_counter','.1.3.6.1.4.1.2021.11.54.0'),(45,'cpu_system_ticks','CPU System Time','snmp_counter','.1.3.6.1.4.1.2021.11.52.0'),(46,'mem_available','Real Memory Available','snmp_counter','.1.3.6.1.4.1.2021.4.6.0'),(47,'mem_total','Real Memory Total','snmp_counter','.1.3.6.1.4.1.2021.4.5.0'),(48,'swap_available','Swap Memory Available','snmp_counter','.1.3.6.1.4.1.2021.4.4.0'),(49,'swap_total','Swap Memory Total','snmp_counter','.1.3.6.1.4.1.2021.4.3.0'),(50,'load_average_15','Load Average 15 min','snmp_counter','.1.3.6.1.4.1.2021.10.1.3.3'),(51,'load_average_5','Load Average 5 min','snmp_counter','.1.3.6.1.4.1.2021.10.1.3.2'),(52,'load_average_1','Load Average 1 min','snmp_counter','.1.3.6.1.4.1.2021.10.1.3.1'),(53,'cpu_user_ticks','CPU User Time','snmp_counter','.1.3.6.1.4.1.2021.11.50.0'),(54,'cpu_nice_ticks','CPU Nice Time','snmp_counter','.1.3.6.1.4.1.2021.11.51.0'),(55,'bandwidthin','Get Bandwidth IN from DB','db','bandwidthin,to_bytes'),(56,'bandwidthout','Get Bandwidth OUT from DB','db','bandwidthout,to_bytes'),(57,'tcp_conn_number','TCP Connection Numbers','tcp_connection_number',''),(58,'acct_bytes,acct_packets','Cisco Accounting','cisco_accounting',''),(59,'cpu','Host MIB Proc Average Util','snmp_walk_average','.1.3.6.1.2.1.25.3.3.1.2'),(60,'num_procs','Host MIB Number of Processes','snmp_counter','.1.3.6.1.2.1.25.1.6.0'),(61,'num_users','Host MIB Number of Users','snmp_counter','.1.3.6.1.2.1.25.1.5.0'),(62,'tcp_active','TCP MIB Active Opens','snmp_counter','.1.3.6.1.2.1.6.5.0'),(63,'tcp_passive','TCP MIB Passive Opens','snmp_counter','.1.3.6.1.2.1.6.6.0'),(64,'tcp_established','TCP MIB Established Connections','snmp_counter','.1.3.6.1.2.1.6.9.0'),(65,'inputpackets','Cisco MAC Accounting Input Packets','snmp_counter','.1.3.6.1.4.1.9.9.84.1.2.1.1.3.<ifindex>.1.<mac>'),(66,'outputpackets','Cisco MAC Accounting Output Packets','snmp_counter','.1.3.6.1.4.1.9.9.84.1.2.1.1.3.<ifindex>.2.<mac>'),(67,'input','Cisco MAC Accounting Input Bytes','snmp_counter','.1.3.6.1.4.1.9.9.84.1.2.1.1.4.<ifindex>.1.<mac>'),(68,'output','Cisco MAC Accounting Output Bytes','snmp_counter','.1.3.6.1.4.1.9.9.84.1.2.1.1.4.<ifindex>.2.<mac>'),(69,'packetloss','Smokeping Loss','smokeping','loss'),(70,'rtt','Smokeping RTT','smokeping','median'),(71,'app_status,current_instances','Host MIB Process Verifier','hostmib_apps','<interface>'),(72,'cisco_powersupply_status','Cisco Power Supply Status','cisco_envmib_status','5.1.3'),(73,'cisco_temperature_status','Cisco Temperature Status','cisco_envmib_status','3.1.6'),(74,'cisco_voltage_status','Cisco Voltage Status','cisco_envmib_status','2.1.7'),(75,'temperature','Cisco Temperature','snmp_counter','.1.3.6.1.4.1.9.9.13.1.3.1.3.<index>'),(76,'sa_agent_verify','Verify SA Agent Operation','cisco_saagent_verify',''),(77,'forward_jitter','SA Agent Forward Jitter','cisco_saagent_forwardjitter',''),(78,'backward_jitter','SA Agent Backward Jitter','cisco_saagent_backwardjitter',''),(79,'rt_latency','SA Agent Round-Trip Latency','cisco_saagent_rtl',''),(80,'forward_packetloss','SA Agent fw % PacketLoss','cisco_saagent_fwpacketloss',''),(81,'backward_packetloss','SA Agent bw % PacketLoss','cisco_saagent_bwpacketloss',''),(82,'verify_smokeping_number','Verify Smokeping Number','verify_smokeping_number',''),(85,'tcp_content_analisis','TCP Port Response Check','tcp_port_content','tcp_content'),(86,'ping','Reachability Start FPING','reachability_start',''),(87,'wait','Reachability Wait until finished','reachability_wait',''),(88,'rtt','Reachability RTT','reachability_values','rtt'),(89,'packetloss','Reachability PL','reachability_values','pl'),(90,'ping_cleanup','Reachability End','reachability_end',''),(91,'status','Reachability Status','reachability_status',''),(93,'bytes','Linux TC Bytes','snmp_counter','<autodiscovery_parameters>.1.6.<index>'),(94,'packets','Linux TC Packets','snmp_counter','<autodiscovery_parameters>.1.7.<index>'),(95,'verify_tc_number','Linux TC Verfy Interface Number','verify_tc_class_number',''),(100,'tcp_status,tcp_content','TCP Port Status','buffer',''),(101,'app_status','Host MIB Status','buffer',''),(102,'ntp_status','NTP Status','ntp_client',''),(103,'used_memory','Host MIB Process Memory Usage','hostmib_perf','2'),(105,'udp_status,conn_delay','UDP Port Status & Delay','udp_status',''),(106,'udp_status','UDP Port Status','buffer',''),(107,'temperature','Compaq Temperature','snmp_counter','.1.3.6.1.4.1.232.6.2.6.8.1.4.<chassis>.<tempindex>'),(108,'temp_status','Compaq Temperature Status','snmp_status','.1.3.6.1.4.1.232.6.2.6.8.1.6.<chassis>.<tempindex>,2=up'),(109,'fan_status','Compaq Fan Condition','snmp_status','.1.3.6.1.4.1.232.6.2.6.7.1.9.<chassis>.<fanindex>,2=up'),(110,'compaq_disk','Compaq Drive Condition','snmp_status','.1.3.6.1.4.1.232.3.2.5.1.1.6.<controller>.<drvindex>,2=up'),(111,'tbr','IIS Total Bytes Received','snmp_counter','.1.3.6.1.4.1.311.1.7.3.1.4.0'),(112,'tcgir','IIS Total CGI Requests','snmp_counter','.1.3.6.1.4.1.311.1.7.3.1.35.0'),(113,'tfs','IIS Total Files Sent','snmp_counter','.1.3.6.1.4.1.311.1.7.3.1.5.0'),(114,'tg','IIS Total GETs','snmp_counter','.1.3.6.1.4.1.311.1.7.3.1.18.0'),(115,'tp','IIS Total Posts','snmp_counter','.1.3.6.1.4.1.311.1.7.3.1.19.0'),(116,'pm_serial_free','Livingston Portmaster Free','livingston_serial_port_status','1'),(117,'pm_serial_established','Livingston Portmaster Established','livingston_serial_port_status','3'),(118,'pm_serial_disconnecting','Livingston Portmaster Disconnecting','livingston_serial_port_status','4'),(119,'pm_serial_command','Livingston Portmaster Command','livingston_serial_port_status','5'),(120,'pm_serial_connecting','Livingston Portmaster Connecting','livingston_serial_port_status','2'),(121,'pm_serial_noservice','Livingston Portmaster No Service','livingston_serial_port_status','6'),(122,'tac,tkb,cplo,up,bpr,bw,iw','Apache Status','apache',''),(123,'capacity','a APC Battery Capacity','snmp_counter','.1.3.6.1.4.1.318.1.1.1.2.2.1.0'),(124,'load','a APC Output Load','snmp_counter','.1.3.6.1.4.1.318.1.1.1.4.2.3.0'),(125,'in_voltage','a APC Input Voltage','snmp_counter','.1.3.6.1.4.1.318.1.1.1.3.2.1.0'),(126,'out_voltage','a APC Output Voltage','snmp_counter','.1.3.6.1.4.1.318.1.1.1.4.2.1.0'),(127,'time_remaining','a APC Time Remaining','snmp_counter','.1.3.6.1.4.1.318.1.1.1.2.2.3.0'),(128,'status','a APC Battery Status','snmp_status','.1.3.6.1.4.1.318.1.1.1.2.1.1.0,2=battery normal|1=battery unknown|3=battery low'),(129,'temperature','a APC Temperature','snmp_counter','.1.3.6.1.4.1.318.1.1.1.2.2.2.0'),(130,'output_status','a APC Output Status','snmp_status','.1.3.6.1.4.1.318.1.1.1.4.1.1.0,2=on line|3=on battery'),(131,'records_counter,records_absolute','ODBC Query','odbc_query',''),(132,'sql_status','SQL Query Status','sql_status',''),(133,'admin_state','Alteon RServer Admin','snmp_counter','.1.3.6.1.4.1.1872.2.1.5.2.1.10.<index>'),(134,'oper_state','Alteon RServer Oper','snmp_status','.1.3.6.1.4.1.1872.2.1.9.2.2.1.7.<index>,2=up'),(135,'current_sessions','Alteon RServer Current Sessions','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.5.1.2.<index>'),(136,'failures','Alteon RServer Failures','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.5.1.4.<index>'),(137,'octets','Alteon RServer Octets','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.5.1.7.<index>'),(138,'total_sessions','Alteon RServer Total Sessions','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.5.1.3.<index>'),(139,'admin_state','Alteon VServer Admin State','snmp_counter','.1.3.6.1.4.1.1872.2.1.5.5.1.4.<index>'),(140,'current_sessions','Alteon VServer Current Sessions','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.7.1.2.<index>'),(141,'total_sessions','Alteon VServer Total Sessions','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.7.1.3.<index>'),(142,'octets','Alteon VServer Octets','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.2.7.1.6.<index>'),(143,'admin_state','Alteon RService Admin State','snmp_counter','.1.3.6.1.4.1.1872.2.1.5.2.1.10.<real_server>'),(144,'oper_state','Alteon RService Oper State','snmp_status','.1.3.6.1.4.1.1872.2.1.9.2.4.1.6.<index>,2=up'),(145,'response_time','Alteon RService Response Time','snmp_counter','.1.3.6.1.4.1.1872.2.1.9.2.4.1.7.<index>'),(146,'cpua_1sec','Alteon CPU A 1Sec','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.16.1.0'),(147,'cpua_4secs','Alteon CPU A 4Secs','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.16.3.0'),(148,'cpua_64secs','Alteon CPU A 64Secs','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.16.5.0'),(149,'cpub_1sec','Alteon CPU B 1Sec','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.1.16.2.0'),(150,'cpub_4secs','Alteon CPU B 4 Secs','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.16.4.0'),(151,'cpub_64secs','Alteon CPU B 64Secs','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.16.6.0'),(152,'mem_total','Alteon Memory Total','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.12.6.0'),(153,'mem_used','Alteon Memory Used','snmp_counter','.1.3.6.1.4.1.1872.2.1.8.12.4.0'),(154,'sensor_value','Brocade Sensor Value','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.1.22.1.4.<index>'),(155,'oper_status','Brocade Sensor Oper','snmp_status','1.3.6.1.4.1.1588.2.1.1.1.1.22.1.3.<index>,4=ok|3=alert|5=alert'),(156,'tx_words','Brocade FCPort TxWords','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.11.<index>'),(157,'rx_words','Brocade FCPort RxWords','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.12.<index>'),(158,'tx_frames','Brocade FCPort TxFrames','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.13.<index>'),(159,'rx_frames','Brocade FCPort RxFrames','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.14.<index>'),(160,'admin_state','Brocade Fc Port Admin State','snmp_counter','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.5.<index>'),(161,'oper_status','Brocade fC Ports Oper Status','snmp_status','1.3.6.1.4.1.1588.2.1.1.1.6.2.1.4.<index>,1=up|3=testing'),(162,'phy_state','Brocade FC Port Phy State','brocade_fcport_phystate','<index>'),(163,'cisco_async','Cisco Async Utilisation','cisco_serial_port_status','1'),(164,'cisco_dsx','Cisco DSX Utilisation','cisco_serial_port_status','2'),(165,'cisco_free','Cisco Port Free','cisco_serial_port_status','3'),(166,'inf_d_read_time','Informant Disk Read Time','snmp_counter','.1.3.6.1.4.1.9600.1.1.1.1.2.<index>'),(167,'inf_d_write_time','Informant Disk Write Time','snmp_counter','.1.3.6.1.4.1.9600.1.1.1.1.4.<index>'),(168,'inf_d_read_rate','Informant Disk Read Rate','snmp_counter','.1.3.6.1.4.1.9600.1.1.1.1.15.<index>'),(169,'inf_d_write_rate','Informant Disk Write Rate','snmp_counter','.1.3.6.1.4.1.9600.1.1.1.1.18.<index>'),(170,'status','UPS Battery Status','snmp_status','.1.3.6.1.2.1.33.1.2.1.0,2=battery normal|1=battery unknown|3=battery low|3=battery depleted'),(171,'temperature','UPS Battery Temperature','snmp_counter','.1.3.6.1.2.1.33.1.2.7.0'),(172,'minutes_remaining','UPS Battery Minutes Remaining','snmp_counter','.1.3.6.1.2.1.33.1.2.3.0'),(173,'charge_remaining','UPS Battery Charge Remaining','snmp_counter','.1.3.6.1.2.1.33.1.2.4.0'),(174,'voltage','UPS Lines Voltage','ups_line',''),(175,'current','UPS Lines Current','ups_line',''),(176,'load','UPS Lines Load','ups_line',''),(177,'ipt_packets','IPTables Chain Packets','snmp_counter','.1.3.6.1.4.1.2021.5002.1.4.<chainnumber>'),(178,'ipt_bytes','IPTables Chainl Bytes','snmp_counter','.1.3.6.1.4.1.2021.5002.1.5.<chainnumber>'),(179,'accepted_routes','BGP Accepted Routes','snmp_counter','.1.3.6.1.4.1.9.9.187.1.2.4.1.1.<remote>.1.1'),(180,'advertised_routes','BGP Advertised Routes','snmp_counter','.1.3.6.1.4.1.9.9.187.1.2.4.1.6.<remote>.1.1'),(181,'pix_connections','Pix Connections Poller','snmp_counter','.1.3.6.1.4.1.9.9.147.1.2.2.2.1.5.<index>'),(182,'cisco_nat_other_ip_inbound','Cisco NAT Other IP Inbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.2.1'),(183,'cisco_nat_icmp_inbound','Cisco NAT ICMP Inbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.2.2'),(184,'cisco_nat_udp_inbound','Cisco NAT UDP Inbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.2.3'),(185,'cisco_nat_tcp_inbound','Cisco NAT TCP Inbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.2.4'),(186,'cisco_nat_other_ip_outbound','Cisco NAT Other IP Outbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.3.1'),(187,'cisco_nat_icmp_outbound','Cisco NAT ICMP Outbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.3.2'),(188,'cisco_nat_udp_outbound','Cisco NAT UDP Outbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.3.3'),(189,'cisco_nat_tcp_outbound','Cisco NAT TCP Outbound','snmp_counter','.1.3.6.1.4.1.9.10.77.1.3.1.1.3.4'),(190,'cisco_nat_active_binds','Cisco NAT Active Binds','snmp_counter','.1.3.6.1.4.1.9.10.77.1.2.1.0'),(191,'value','Sensor Value','snmp_counter','.1.3.6.1.2.1.25.8.1.5.<index>'),(192,'storage_verify','Verify Storage Index','verify_storage_index',''),(193,'cpu400','OS 400 System Load','snmp_counter','.1.3.6.1.4.1.2.6.4.5.1.0'),(194,'dell_om_chassis','Dell OpenManage Chassis','snmp_status','1.3.6.1.4.1.674.10892.1.200.10.1.2.1,1=other|2=unknown|3=ok|4=noncritical|5=critical|6=nonrecoverabl'),(195,'dell_om_temp','Dell OpenManage Ambient Temp','snmp_counter','1.3.6.1.4.1.674.10892.1.700.20.1.6.1.1'),(196,'dell_om_fan_1','Dell OpenManage Fan RPM #1','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.1'),(197,'dell_om_fan_2','Dell OpenManage Fan RPM #2','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.2'),(198,'dell_om_fan_3','Dell OpenManage Fan RPM #3','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.3'),(199,'dell_om_fan_4','Dell OpenManage Fan RPM #4','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.4'),(200,'dell_om_fan_5','Dell OpenManage Fan RPM #5','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.5'),(201,'dell_om_fan_6','Dell OpenManage Fan RPM #6','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.6'),(202,'dell_om_fan_7','Dell OpenManage Fan RPM #7','snmp_counter','1.3.6.1.4.1.674.10892.1.700.12.1.6.1.7'),(203,'power','UPS Lines Power','ups_line',''),(204,'status','PDU Load Status','snmp_status','.1.3.6.1.4.1.318.1.1.12.2.3.1.1.3.<index>,1=load normal|2=load low|3=load near overload|4=load ove'),(205,'load','PDU Banks Load','pdu_banks',''),(206,'ibm_component_health','IBM Component Health Status','snmp_status','1.3.6.1.4.1.2.6.159.1.1.30.3.1.2.<index>,0=up|1=warning|2=down'),(207,'status','IBM Blade Server Health Status','snmp_status_ibm','.1.3.6.1.4.1.2.3.51.2.22.1.5.1.1.5.<index>,1=up|2=warning|3=down'),(208,'temperature','IBM Blade Server CPU1 Temp','snmp_ibm_temperature','.1.3.6.1.4.1.2.3.51.2.22.1.5.3.1.13.<index>'),(209,'status','IBM Blade Power Status','snmp_status_ibm','.1.3.6.1.4.1.2.3.51.2.2.10.1.1.1.3.index>,1=up|2=warning|3=down'),(210,'fuelGaugePowerInUse','IBM Blade Power Gauge','snmp_ibm_power','.1.3.6.1.4.1.2.3.51.2.2.10.1.1.1.10.<index>'),(211,'temperature2','IBM Blade Server CPU2 Temp','snmp_ibm_temperature','.1.3.6.1.4.1.2.3.51.2.22.1.5.3.1.14.<index>'),(212,'status','FC Oper Status','snmp_status','.1.3.6.1.2.1.75.1.2.2.1.2.<real_index>,1=up|2=offline|4=linkFailure'),(213,'rx_frames','FCPort RxFrames','snmp_counter','.1.3.6.1.2.1.75.1.4.3.1.1.<real_index>'),(214,'tx_frames','FCPort TxFrames','snmp_counter','.1.3.6.1.2.1.75.1.4.3.1.2.<real_index>'),(215,'associated','Client Associated','snmp_counter','.1.3.6.1.4.1.9.9.273.1.1.2.1.1.1'),(216,'power_status','Compaq Power Condition','snmp_status','1.3.6.1.4.1.232.6.2.9.3.1.4.<chassis>.<bayindex>,2=up'),(217,'status','IBM Storage Controller status','ibm_ds_storage','controler'),(218,'arraystatus','AS 400 System','snmp_array_null','.1.3.6.1.2.1.25.2.3.1.6'),(219,'cur_disk_q','Inf-64 Disk CurrentDiskQueue','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.16.<index>'),(220,'avg_disk_q','Inf-64 Disk AvgDiskQueu','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.10.<index>'),(221,'avg_disk_rdq','Inf-64 Disk avg Read DiskQueue','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.11.<index>'),(222,'avg_disk_wrq','Inf-64 Disk avg Write DiskQueue','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.12.<index>'),(223,'inf_d_read_time','Inf-64 Disk Read Time','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.2.<index>'),(224,'inf_d_write_time','Inf-64 Disk Write Time','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.4.<index>'),(225,'rd_ops','Inf-64 Disk Read rate','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.19.<index>'),(226,'wr_ops','Inf-64 Disk Write rate','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.22.<index>'),(227,'inf_d_read_rate','Inf-64 Disk Read Bytes','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.18.<index>'),(228,'inf_d_write_rate','Inf-64 Disk Write Bytes','snmp_counter','.1.3.6.1.4.1.9600.1.2.44.1.21.<index>'),(229,'input','SNMP Input Rate HC','snmp_counter','.1.3.6.1.2.1.2.2.1.10.<interfacenumber>,.1.3.6.1.2.1.31.1.1.1.6.<interfacenumber>'),(230,'output','SNMP Output Rate HC','snmp_counter','.1.3.6.1.2.1.2.2.1.16.<interfacenumber>,.1.3.6.1.2.1.31.1.1.1.10.<interfacenumber>'),(231,'inpackets','SNMP Input Packets HC','snmp_counter','.1.3.6.1.2.1.2.2.1.11.<interfacenumber>,.1.3.6.1.2.1.31.1.1.1.7.<interfacenumber>'),(232,'outpackets','SNMP Output Packets HC','snmp_counter','.1.3.6.1.2.1.2.2.1.17.<interfacenumber>,.1.3.6.1.2.1.31.1.1.1.11.<interfacenumber>');
/*!40000 ALTER TABLE `pollers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pollers_backend`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pollers_backend` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(60) NOT NULL DEFAULT '',
  `command` char(60) NOT NULL DEFAULT '',
  `parameters` char(60) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pollers_backend`
--

LOCK TABLES `pollers_backend` WRITE;
/*!40000 ALTER TABLE `pollers_backend` DISABLE KEYS */;
INSERT INTO `pollers_backend` VALUES (1,'No Backend','no_backend','',0),(2,'Unknown Event','event','1',0),(9,'Temporal Buffer','buffer','',0),(10,'RRDTool All DSs','rrd','*',0),(12,'Alarm Verify Operational','alarm','3,,180',1),(14,'Change Interface Number','verify_interface_number','',0),(19,'Alarm TCP Port','alarm','22',1),(20,'Alarm Environmental','alarm','26',1),(24,'Alarm BGP Peer','alarm','6,,180',1),(25,'Application Alarm','alarm','38',1),(27,'Alarm TCP Content','alarm','39',1),(28,'Alarm Reachability','alarm','40',1),(29,'Admin Status Change View','db','show_rootmap,down=2|up=1,0',1),(30,'Multiple Temporal Buffer','multi_buffer','',0),(31,'Alarm NTP','alarm','41,nothing',1),(32,'RRD Individual Value','rrd','',0),(33,'Alarm APC','alarm','60',1),(34,'Alarm SQL Records','alarm','50',1),(35,'Alteon Admin Status View','db','show_rootmap,down=0|up=2,2',1),(36,'Alarm Alteon RServer','alarm','68',1),(37,'Alarm Alteon Service','alarm','69',1),(38,'Alarm Alteon VServer','alarm','70',1),(39,'Brocace FC Admin View','db','show_rootmap,down=2|up=1,0',0),(40,'Alarm Brocade FC Port','alarm','71',1),(41,'Alarm IBM','alarm','75',1),(42,'IBM San Trap','event','77',0),(43,'Alarm OS/400','alarm','78',1),(44,'Alarm IBM Storage Controller','alarm','80',1);
/*!40000 ALTER TABLE `pollers_backend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pollers_groups`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pollers_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(60) NOT NULL DEFAULT '',
  `interface_type` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pollers_groups`
--

LOCK TABLES `pollers_groups` WRITE;
/*!40000 ALTER TABLE `pollers_groups` DISABLE KEYS */;
INSERT INTO `pollers_groups` VALUES (1,'No Polling',1),(2,'Cisco Interface',4),(3,'Cisco Router',3),(5,'TCP/IP Port',2),(8,'BGP Neighbor',6),(9,'Storage Device',8),(10,'CSS VIP',9),(11,'Linux/Unix Host',11),(12,'Solaris Host',10),(13,'Windows Host',12),(14,'Cisco Accounting',13),(15,'Smokeping Host',14),(16,'HostMIB Application',15),(17,'Cisco Power Supply',16),(18,'Cisco Tempererature',17),(19,'Cisco Voltage',18),(20,'Cisco SA Agent',19),(21,'Reachability',20),(22,'TC Class',21),(23,'NTP',22),(24,'UDP/IP Port',23),(25,'Compaq Physical Drive',24),(26,'Compaq Fan',25),(27,'Compaq Temperature',26),(28,'IIS Info',27),(29,'Livingston Portmaster',28),(30,'Apache',29),(31,'APC',31),(32,'ODBC',30),(33,'Alteon Real Server',32),(34,'Alteon Virtual Server',33),(35,'Alteon Real Services',34),(36,'Alteon System Info',35),(37,'Brocade Sensors',36),(38,'Brocade FC Ports',37),(39,'Cisco Dialup',38),(40,'Windows Informant Disks',39),(41,'UPS',40),(42,'UPS Lines',41),(43,'IPTable Chain',42),(44,'PIX Connection Stat',43),(45,'Cisco NAT',44),(46,'Sensors',45),(47,'OS/400 Host',46),(48,'Dell Chassis',47),(49,'PDU',48),(50,'PDU Banks',49),(57,'IBM Component Health',50),(51,'IBM Blade Servers',51),(52,'Fibre Channel Interface',52),(53,'Cisco 802.11X Device',53),(54,'IBM Blade Power Module',54),(55,'Compaq Power Supply',55),(56,'IBM Storage Controller',56),(58,'Informant Disks 64',57),(59,'Cisco Interface HC',4),(60,'SNMP Interface',4),(61,'SNMP Interface HC',4);
/*!40000 ALTER TABLE `pollers_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pollers_poller_groups`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pollers_poller_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `poller_group` int(10) NOT NULL DEFAULT '1',
  `pos` tinyint(4) NOT NULL DEFAULT '1',
  `poller` int(10) NOT NULL DEFAULT '1',
  `backend` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `poller_group` (`poller_group`),
  KEY `poller` (`poller`),
  KEY `backend` (`backend`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pollers_poller_groups`
--

LOCK TABLES `pollers_poller_groups` WRITE;
/*!40000 ALTER TABLE `pollers_poller_groups` DISABLE KEYS */;
INSERT INTO `pollers_poller_groups` VALUES (1,1,1,1,1),(2,2,20,2,9),(3,2,10,3,14),(4,2,15,5,9),(5,2,50,6,1),(6,2,55,7,9),(7,2,60,8,9),(8,2,65,9,1),(9,2,30,10,9),(10,2,40,11,9),(11,2,45,12,9),(12,2,80,1,10),(14,2,16,13,12),(16,3,10,16,9),(20,3,2,20,19),(21,2,25,21,9),(22,2,35,22,9),(23,5,10,23,30),(24,3,20,24,9),(25,3,50,1,10),(26,3,30,25,9),(27,2,46,26,9),(30,8,10,31,32),(31,8,40,32,32),(32,8,50,33,32),(35,9,10,37,9),(36,9,20,36,9),(37,9,30,35,9),(38,9,60,1,10),(39,8,5,38,24),(41,10,10,41,9),(42,10,20,40,9),(43,10,60,1,10),(44,11,10,54,9),(45,11,20,53,9),(46,11,30,43,9),(47,11,40,45,9),(48,11,50,52,9),(49,11,60,51,9),(50,11,70,50,9),(51,11,80,1,10),(52,12,10,45,9),(53,12,20,43,9),(54,12,30,42,9),(55,12,40,44,9),(56,12,50,52,9),(57,12,60,51,9),(58,12,70,50,9),(59,12,80,46,9),(60,12,90,47,9),(61,12,100,48,9),(62,12,110,49,9),(63,12,120,1,10),(64,2,47,55,9),(65,2,48,56,9),(66,5,20,57,9),(67,5,60,1,10),(68,3,40,58,30),(69,13,10,59,9),(70,13,20,60,9),(71,13,30,61,9),(72,13,40,62,9),(73,13,50,64,9),(74,13,60,63,9),(75,13,100,1,10),(76,11,15,60,9),(77,11,25,61,9),(78,11,35,64,9),(79,11,45,62,9),(80,11,55,63,9),(81,3,15,64,9),(82,3,25,62,9),(83,3,35,63,9),(84,14,10,65,9),(85,14,20,67,9),(86,14,30,68,9),(87,14,40,66,9),(88,14,50,1,10),(89,15,30,70,9),(90,15,20,69,9),(91,15,90,1,10),(92,16,10,71,30),(93,17,20,72,20),(94,18,10,73,20),(95,19,20,74,20),(96,18,20,75,9),(97,18,50,1,10),(98,20,10,76,11),(99,20,20,77,9),(100,20,30,81,9),(101,20,40,80,9),(102,20,50,79,9),(103,20,60,78,9),(104,20,90,1,10),(105,15,10,82,14),(106,5,30,85,27),(107,21,1,86,9),(108,21,122,87,1),(109,21,123,88,9),(110,21,124,89,9),(111,21,126,90,1),(112,21,125,91,28),(113,21,127,1,10),(114,22,92,93,9),(115,22,93,94,9),(116,22,91,95,14),(117,22,94,1,10),(122,2,17,14,29),(123,5,15,100,19),(124,16,20,101,25),(125,16,90,1,10),(126,23,50,102,31),(127,16,30,103,9),(129,24,10,105,30),(130,24,20,106,19),(131,24,30,1,10),(132,27,10,108,20),(133,27,20,107,9),(134,27,90,1,10),(135,26,10,109,20),(136,25,10,110,20),(137,28,10,111,9),(138,28,20,112,9),(139,28,30,113,9),(140,28,40,114,9),(141,28,50,115,9),(142,28,90,1,10),(143,29,90,1,10),(144,29,10,116,9),(145,29,20,120,9),(146,29,30,117,9),(147,29,50,119,9),(148,29,60,121,9),(149,29,40,118,9),(150,30,20,1,10),(151,30,10,122,30),(152,31,10,128,20),(153,31,20,123,9),(154,31,31,124,9),(155,31,40,125,9),(156,31,50,126,9),(157,31,60,127,9),(158,31,90,1,10),(159,31,70,129,9),(160,31,15,130,33),(161,32,10,131,30),(162,32,20,132,34),(163,32,90,1,10),(164,33,10,133,35),(165,33,15,134,12),(166,33,20,135,9),(167,33,25,136,9),(168,33,30,137,9),(169,33,35,138,9),(170,33,90,1,10),(171,34,10,139,29),(172,34,20,140,9),(173,34,30,142,9),(174,34,40,141,9),(175,34,90,1,10),(176,35,10,143,29),(177,35,30,144,37),(178,35,20,145,9),(179,35,90,1,10),(180,36,10,146,9),(181,36,11,147,9),(182,36,12,148,9),(183,36,15,149,9),(184,36,16,150,9),(185,36,17,151,9),(186,36,20,62,9),(187,36,21,63,9),(188,36,22,64,9),(189,36,30,153,9),(190,36,35,152,9),(191,36,90,1,10),(192,37,10,155,12),(193,37,20,154,9),(194,37,90,1,10),(195,38,40,156,9),(196,38,45,157,9),(197,38,50,158,9),(198,38,55,159,9),(199,38,90,1,10),(200,38,10,160,39),(201,38,20,161,12),(202,38,30,162,40),(203,39,10,165,9),(204,39,20,164,9),(205,39,30,163,9),(206,39,90,1,10),(207,40,10,168,32),(208,40,20,169,32),(209,40,30,166,32),(210,40,40,167,32),(211,41,10,170,20),(212,41,20,173,32),(213,41,30,172,32),(214,41,40,171,32),(215,42,10,174,32),(216,42,20,175,32),(217,42,30,176,32),(218,43,10,178,32),(219,43,20,177,32),(220,8,20,179,32),(221,8,30,180,32),(222,44,10,181,32),(223,45,50,190,32),(224,45,10,186,32),(225,45,20,187,32),(226,45,30,188,32),(227,45,40,189,32),(228,45,15,182,32),(229,45,25,183,32),(230,45,35,184,32),(231,45,45,185,32),(232,46,20,191,32),(233,9,5,192,14),(234,47,1,193,32),(235,48,20,194,29),(236,48,10,194,12),(237,48,30,195,32),(238,48,40,196,9),(239,48,41,197,9),(240,48,42,198,9),(241,48,43,199,9),(242,48,44,200,9),(243,48,45,201,9),(244,48,46,202,9),(245,48,50,1,10),(246,42,50,203,32),(247,49,10,204,32),(248,50,10,205,32),(249,57,1,206,41),(250,51,1,207,20),(251,51,5,208,9),(252,52,1,212,20),(253,52,5,213,9),(254,52,10,214,9),(255,52,20,1,10),(256,51,10,211,9),(257,51,15,1,10),(258,53,1,215,32),(259,54,1,210,32),(260,54,2,209,41),(261,55,10,216,20),(262,56,1,217,44),(263,47,5,218,43),(264,58,10,219,32),(265,58,20,220,32),(266,58,30,221,32),(267,58,40,222,32),(268,58,50,223,32),(269,58,60,224,32),(270,58,70,225,32),(271,58,80,226,32),(272,58,90,227,32),(273,58,100,228,32),(274,59,10,3,14),(275,59,15,5,9),(276,59,16,13,12),(277,59,17,14,29),(278,59,20,229,9),(279,59,25,231,9),(280,59,30,230,9),(281,59,35,232,9),(282,59,40,11,9),(283,59,45,12,9),(284,59,46,26,9),(285,59,47,55,9),(286,59,48,56,9),(287,59,50,6,1),(288,59,55,7,9),(289,59,60,8,9),(290,59,65,9,1),(291,59,80,1,10),(292,60,10,3,14),(293,60,16,13,12),(294,60,17,14,29),(295,60,20,2,9),(296,60,25,21,9),(297,60,30,10,9),(298,60,35,22,9),(299,60,40,11,9),(300,60,45,12,9),(301,60,46,26,9),(302,60,47,55,9),(303,60,48,56,9),(304,60,80,1,10),(305,61,10,3,14),(306,61,16,13,12),(307,61,17,14,29),(308,61,20,229,9),(309,61,25,231,9),(310,61,30,230,9),(311,61,35,232,9),(312,61,40,11,9),(313,61,45,12,9),(314,61,46,26,9),(315,61,47,55,9),(316,61,48,56,9),(317,61,80,1,10);
/*!40000 ALTER TABLE `pollers_poller_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profiles`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userid` int(10) NOT NULL DEFAULT '1',
  `profile_option` int(10) DEFAULT '1',
  `value` int(10) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `tag` (`profile_option`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='User Authorization';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profiles`
--

LOCK TABLES `profiles` WRITE;
/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
INSERT INTO `profiles` VALUES (1,1,1,1),(2,2,9,12),(3,2,11,300),(4,2,13,30),(5,2,16,36),(6,2,20,46),(7,2,25,50),(8,2,2,8),(9,2,8,6),(10,2,14,32),(11,2,15,34),(12,2,6,20);
/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profiles_options`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles_options` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tag` char(30) NOT NULL DEFAULT '',
  `description` char(60) NOT NULL DEFAULT '',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_profile` tinyint(1) NOT NULL DEFAULT '1',
  `use_default` tinyint(1) NOT NULL DEFAULT '0',
  `default_value` char(60) NOT NULL DEFAULT '',
  `type` char(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='Authorization Tags';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profiles_options`
--

LOCK TABLES `profiles_options` WRITE;
/*!40000 ALTER TABLE `profiles_options` DISABLE KEYS */;
INSERT INTO `profiles_options` VALUES (1,'NO_TAG','No Option',1,1,0,'','select'),(2,'ADMIN_ACCESS','Administration Access',0,1,0,'1','select'),(6,'REPORTS_VIEW_ALL_INTERFACES','View All Interfaces',0,1,0,'1','select'),(8,'ADMIN_USERS','User Administration',0,1,0,'1','select'),(9,'MAP_SOUND','Map Sound',1,1,1,'1','select'),(11,'EMAIL','eMail',1,1,1,'','text'),(12,'MAP','Base Map',0,0,0,'1','text'),(13,'EVENTS_SOUND','Events Sound',1,1,1,'1','select'),(14,'ADMIN_SYSTEM','System Administration',0,1,0,'1','select'),(15,'ADMIN_HOSTS','Host Administration',0,1,0,'1','select'),(16,'VIEW_REPORTS','Reports Access',0,0,1,'1','select'),(19,'POPUPS_DISABLED','Disable Popups',0,1,0,'1','select'),(20,'VIEW_STARTPAGE_STATS','View Start Page Stats',1,1,1,'1','select'),(21,'EVENTS_DEFAULT_FILTER','Events Default Filter',1,1,0,'0','text'),(22,'EVENTS_REFRESH','Events Refresh Interval (secs)',1,1,0,'20','text'),(23,'MAP_REFRESH','Map Refresh Interval (secs)',1,1,0,'20','text'),(24,'SMSALIAS','SMS Pager Alias',1,1,0,'','text'),(25,'VIEW_TYPE_DEFAULT','Default View Type',1,1,1,'dhtml','select'),(26,'VIEW_DEFAULT','Default View',1,1,0,'start','select'),(27,'CUSTOMER','Customer Filter',0,1,0,'','text');
/*!40000 ALTER TABLE `profiles_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profiles_values`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles_values` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `profile_option` int(10) NOT NULL DEFAULT '1',
  `description` char(30) NOT NULL DEFAULT '',
  `value` char(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `profile_option` (`profile_option`)
) ENGINE=MyISAM AUTO_INCREMENT=301 DEFAULT CHARSET=utf8 COMMENT='Profiles Options Values';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profiles_values`
--

LOCK TABLES `profiles_values` WRITE;
/*!40000 ALTER TABLE `profiles_values` DISABLE KEYS */;
INSERT INTO `profiles_values` VALUES (1,1,'No Value','1'),(5,9,'Disable','0'),(6,8,'Yes','1'),(7,8,'No','0'),(8,2,'Yes','1'),(12,9,'Enable','1'),(20,6,'Yes','1'),(21,6,'No','0'),(30,13,'Yes','1'),(31,13,'No','0'),(32,14,'Yes','1'),(33,14,'No','0'),(34,15,'Yes','1'),(35,15,'No','0'),(36,16,'Yes','1'),(37,16,'No','0'),(43,19,'Yes','1'),(44,19,'No','0'),(46,20,'Yes','1'),(47,20,'No','0'),(48,25,'Normal','normal'),(49,25,'Text Only','text'),(50,25,'DHTML','dhtml'),(52,25,'Normal Big','normal-big'),(53,25,'DHTML Big','dhtml-big'),(55,26,'Start Page','start'),(56,26,'Hosts & Events','hosts-events'),(57,26,'Interfaces & Events','interfaces-events'),(58,26,'Maps & Events','maps-events'),(59,26,'Alarmed Interfaces & Events','alarmed-events'),(60,26,'Alarmed Interfaces','alarmed'),(61,26,'Interfaces','interfaces'),(62,26,'Hosts','hosts'),(63,26,'Maps','maps'),(64,26,'Hosts All Interfaces','hosts-all-int'),(65,26,'Events','events'),(66,26,'Alarmed Hosts & Events','alarmed-hosts-events'),(300,11,'','');
/*!40000 ALTER TABLE `profiles_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `satellites`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `satellites` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  `parent` int(10) NOT NULL DEFAULT '1',
  `url` char(150) NOT NULL DEFAULT '',
  `sat_group` int(10) NOT NULL DEFAULT '1',
  `sat_type` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  KEY `sat_type` (`sat_type`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Satellites';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `satellites`
--

LOCK TABLES `satellites` WRITE;
/*!40000 ALTER TABLE `satellites` DISABLE KEYS */;
INSERT INTO `satellites` VALUES (1,'Local',1,'',1,1);
/*!40000 ALTER TABLE `satellites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `severity`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `severity` (
  `id` tinyint(10) NOT NULL AUTO_INCREMENT,
  `level` tinyint(10) NOT NULL DEFAULT '0',
  `severity` char(20) NOT NULL DEFAULT '',
  `bgcolor` char(15) NOT NULL DEFAULT '',
  `fgcolor` char(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `nivel` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `severity`
--

LOCK TABLES `severity` WRITE;
/*!40000 ALTER TABLE `severity` DISABLE KEYS */;
INSERT INTO `severity` VALUES (1,127,'Unknown','000000','FFFFFF'),(2,30,'Warning','00AA00','FFFFFF'),(3,40,'Fault','F51D30','EEEEEE'),(4,50,'Big Fault','DA4725','FFFFFF'),(5,60,'Critical','FF0000','FFFFFF'),(13,10,'Administrative','8D00BA','FFFFFF'),(14,20,'Information','F9FD5F','000000'),(18,35,'Service','0090F0','FFFFFF');
/*!40000 ALTER TABLE `severity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slas`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slas` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(60) NOT NULL DEFAULT '',
  `state` int(10) NOT NULL DEFAULT '3',
  `info` char(60) NOT NULL DEFAULT '',
  `event_type` int(10) NOT NULL DEFAULT '12',
  `threshold` tinyint(3) NOT NULL DEFAULT '100',
  `interface_type` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `state` (`state`),
  KEY `event_type` (`event_type`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slas`
--

LOCK TABLES `slas` WRITE;
/*!40000 ALTER TABLE `slas` DISABLE KEYS */;
INSERT INTO `slas` VALUES (1,'No SLA',3,'No SLA',12,100,1),(4,'Customer Satellite Link',3,'Customer Sat Link:',12,75,4),(5,'Main Fiber Link',3,'Main Link:',12,100,4),(6,'Main Satellite Link',3,'Main Sat Link:',12,100,4),(7,'Cisco Router',3,'Router:',12,100,3),(8,'Smokeping Host',3,'Smokeping:',12,100,14),(9,'Storage',3,'Storage',12,100,8),(10,'Linux/Unix CPU',3,'',12,100,11),(11,'Windows CPU',3,'',12,100,12),(12,'APC UPS',3,'APC UPS',12,100,31);
/*!40000 ALTER TABLE `slas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slas_cond`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slas_cond` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cond` char(250) NOT NULL,
  `description` char(60) NOT NULL DEFAULT '',
  `event` char(60) NOT NULL DEFAULT '',
  `variable_show` char(250) NOT NULL DEFAULT '',
  `variable_show_info` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='SLA Atomic Conditions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slas_cond`
--

LOCK TABLES `slas_cond` WRITE;
/*!40000 ALTER TABLE `slas_cond` DISABLE KEYS */;
INSERT INTO `slas_cond` VALUES (1,'1=2','Unknown','Unknown','',''),(2,'(<rtt> > 60)','RoundTrip Time > 60ms','RTT > 60','<rtt>','ms'),(3,'( ((<packetloss> * 100) / <pings>) > 20)','Packet Loss > 20%','PL > 20%','((<packetloss> * 100) / <pings>)','%'),(4,'(<in> < ((<bandwidthin>*95)/100))','Input Traffic < 95%','IN < 95%','(<in> / 1000)','Kbps'),(5,'AND','AND','','',''),(6,'OR','OR','','',''),(7,'(<rtt> > 700)','RoundTrip Time > 700ms','RTT > 700','<rtt>','ms'),(8,'(<rtt> > 900)','RoundTrip Time > 900ms','RTT > 900','<rtt>','ms'),(9,'(((<packetloss> * 100) / <pings>) > 50)','Packet Loss > 50%','PL > 50%','((<packetloss> * 100) / <pings>)','%'),(11,'(<in> > ((<bandwidthin>*90)/100))','Input Traffic > 90%','IN > 90%','(<in> / 1000)','Kbps'),(12,'(<in> < ((<bandwidthin>*1)/100))','Input Traffic < 1%','IN < 1 %','',''),(13,' (<out> > ((<bandwidthout>*90)/100))','Output Traffic > 90%','OUT > 90%','(<out> / 1000 )','kbps'),(14,'(<out> < ((<bandwidthout>*95)/100))','Output Traffic < 95%','OUT < 95%','(<out> / 1000 )','kbps'),(15,'( ( (<inerrors> / (<inpackets> + <inerrors> + 1) )*100) > 20)','Input Error Rate > 20%','IN ERR > 20%','( (<inerrors> / (<inpackets> + <inerrors> + 1) )*100)','% = <inerrors> eps'),(16,'( ( (<inerrors> / (<inpackets> + <inerrors> + 1) )*100) > 10)','Input Error Rate > 10%','IN ERR > 10%','( (<inerrors> / (<inpackets> + <inerrors> + 1) )*100)','% = <inerrors> eps'),(18,'( ( (<drops> / (<outpackets> + 1) )*100) > 1)','Drops > 1%','Drops > 1%','( (<drops> / (<outpackets> + 1) )*100)','% = <drops> dps'),(19,' ( ( (<drops> / (<outpackets> + 1) )*100) > 2)','Drops > 2%','Drops > 2%','( (<drops> / (<outpackets> + 1) )*100)','% = <drops> dps'),(20,'(((<packetloss> * 100) / <pings>) > 10)','Packet Loss > 10%','PL > 10%','((<packetloss> * 100) / <pings>)','%'),(21,'( ( (<drops> / (<outpackets> +<drops> + 1) )*100) > 10)','Drops > 10%','Drops > 10%','( (<drops> / (<outpackets> +<drops> + 1) )*100)','%'),(22,' (<in> < ((<bandwidthin>*99)/100))','Input Traffic < 99%','IN < 99%',' (<in> / 1000 )','Kbps'),(23,' (<out> < ((<bandwidthout>*99)/100))',' Output Traffic < 99%',' OUT < 99%',' (<out> / 1000 )','Kbps'),(24,'(<cpu> > <cpu_threshold>)','High CPU Utilization','Usage > <cpu_threshold>%','<cpu>','%'),(25,'(<packetloss> > 10)','SP Packet Loss > 10%','Packet Loss > 10%','<packetloss>','%'),(26,'( <storage_used_blocks> > ((<storage_block_count>*<usage_threshold>)/100))','Used Storage','Used > <usage_threshold>%','((<storage_used_blocks> * 100)/<storage_block_count>)','%'),(27,'( <load_average_5> > 5 )','Load Average > 5','Load Average > 5','<load_average_5>',''),(28,'(((( <cpu_user_ticks> + <cpu_nice_ticks> + <cpu_system_ticks> ) * 100 ) / ( <cpu_user_ticks> + <cpu_idle_ticks> + <cpu_nice_ticks> + <cpu_system_ticks> )) > <cpu_threshold>)','High CPU Utilization','Usage > <cpu_threshold>%','((( <cpu_user_ticks> + <cpu_nice_ticks> + <cpu_system_ticks> ) * 100 ) / ( <cpu_user_ticks> + <cpu_idle_ticks> + <cpu_nice_ticks> + <cpu_system_ticks> ))','%'),(29,'( ((<mem_used> * 100) / (<mem_used> + <mem_free>)) > 80)','Memory Usage > 80%','Memory Usage > 80%','((<mem_used> * 100) / (<mem_used> + <mem_free>))','%'),(30,'(<cpu> > 90)','CPU Utilization > 90%','CPU > 90%','<cpu>','%'),(31,'(<num_procs> > <proc_threshold>)','Too Many Processes','Processes > <proc_threshold>','<num_procs>','Processes'),(32,'(<temperature> > 55)','APC temp > 55','APC temp > 55','<temperature>','C'),(33,'(<time_remaining> < 300000)','APC time < 50 minutes','APC time < 50 minutes','<time_remaining>','min');
/*!40000 ALTER TABLE `slas_cond` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slas_sla_cond`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slas_sla_cond` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pos` tinyint(2) NOT NULL DEFAULT '1',
  `sla` int(10) NOT NULL DEFAULT '1',
  `cond` int(10) NOT NULL DEFAULT '1',
  `show_in_result` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `sla` (`sla`),
  KEY `cond` (`cond`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='SLA - Condition Relationships';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slas_sla_cond`
--

LOCK TABLES `slas_sla_cond` WRITE;
/*!40000 ALTER TABLE `slas_sla_cond` DISABLE KEYS */;
INSERT INTO `slas_sla_cond` VALUES (1,1,1,1,0),(9,30,4,4,0),(10,40,4,7,1),(11,50,4,20,1),(12,70,4,6,0),(13,74,4,5,0),(14,10,5,11,1),(15,20,5,2,1),(16,40,5,20,1),(17,50,5,6,0),(18,60,5,6,0),(19,10,6,11,1),(20,30,6,7,1),(21,60,6,6,0),(22,40,6,3,1),(23,50,6,6,0),(33,20,4,14,0),(35,75,4,6,0),(36,15,5,13,1),(37,70,5,6,0),(38,20,6,13,1),(39,70,6,6,0),(40,10,4,16,1),(41,73,4,5,0),(42,45,6,16,1),(43,55,6,6,0),(44,30,5,16,1),(45,45,5,6,0),(47,60,4,18,1),(48,72,4,6,0),(49,10,7,24,1),(50,10,8,25,1),(51,30,8,6,0),(52,20,8,2,1),(53,1,9,26,1),(54,10,10,27,1),(55,20,10,28,1),(56,30,10,6,0),(57,20,7,29,1),(58,30,7,6,0),(59,10,11,30,1),(60,20,11,31,1),(61,30,11,6,0),(62,5,12,32,1),(63,10,12,6,0),(64,1,12,33,1);
/*!40000 ALTER TABLE `slas_sla_cond` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `syslog`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `syslog` (
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `host` varchar(128) DEFAULT NULL,
  `date_logged` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `message` text,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `analized` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `analized` (`analized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `syslog`
--

LOCK TABLES `syslog` WRITE;
/*!40000 ALTER TABLE `syslog` DISABLE KEYS */;
/*!40000 ALTER TABLE `syslog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `syslog_types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `syslog_types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `match_text` char(255) NOT NULL DEFAULT '',
  `interface` char(10) NOT NULL DEFAULT '',
  `username` char(20) NOT NULL DEFAULT '',
  `state` char(10) NOT NULL DEFAULT '',
  `info` char(10) NOT NULL DEFAULT '',
  `type` int(10) NOT NULL DEFAULT '1',
  `pos` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `syslog_types`
--

LOCK TABLES `syslog_types` WRITE;
/*!40000 ALTER TABLE `syslog_types` DISABLE KEYS */;
INSERT INTO `syslog_types` VALUES (1,'UNKNOWN','0','','','*',1,1),(2,'%SYS-5-CONFIG_I:.+|%SYS-5-CONFIG:','7','5','','3',2,1),(3,'%LINEPROTO-5-UPDOWN:','5','','9','',3,1),(4,'%LINK-3-UPDOWN:','2','','6','',4,1),(5,'%CONTROLLER-5-UPDOWN:','3','','7','2',5,1),(6,'%BGP-5-ADJCHANGE:','2','','3','6',6,1),(7,'%LINK-5-CHANGED:','2','','7','6',7,1),(9,'%RCMD-4-RSHPORTATTEMPT:','5','','','7',9,1),(17,'%CLEAR-5-COUNTERS:','5','7','','10',17,1),(20,'%PIX-2-106006:','7','5','1','3',29,1),(21,'%PIX-2-106007:','7','5','1','3',29,1),(22,'%PIX-2-106001:','8','6','4','2',29,1),(25,'%PIX-3-106010:','7','5','1','3',29,1),(26,'%PIX-3-106014:','7','5','1','3',29,1),(29,'%PIX-3-305006:.+|%PIX-2-106012:.+|%PIX-3-305005:.+|%PIX-3-307001:.+','','','','D',28,1),(30,'%CDP-4-DUPLEX_MISMATCH:','5','10','','11',34,1),(31,'%SEC-6-IPACCESSLOGS:','2','4','3','5',35,1),(32,'%SEC-6-IPACCESSLOGP:.+|%SEC-6-IPACCESSLOGNP:','2','7','3','8',35,1),(33,'%BGP-3-NOTIFICATION: (\\S+ \\S+) neighbor (\\S+) \\S+ (\\S+ \\S+ \\S+) \\S+ \\S+','2','','1','3',36,1),(34,'%SYS-5-RESTART:','','','','D',26,1),(35,'%SYS-5-RELOAD:','','','','D',26,1),(36,'%SEC-6-IPACCESSLOGDP:','2','5','3','9',35,1),(37,'EXCESSCOLL:','1','','','',37,1),(38,'^([^[]+)(?:\\[\\d+\\])?:\\s+(.+)$','1','','','2',44,100),(39,'CRON\\[\\d+\\]: \\((\\S+)\\) CMD (.*)','cron','1','','2',45,1),(40,'^(\\S.*)\\[info\\]\\s*(\\S+)\\s*(\\S.*)','1','','2','3',46,10),(41,'^(\\S.*)\\[error\\]\\s*(\\S+)\\s*(\\S.*)','1','','2','3',48,10),(42,'^(\\S.*)\\[warning\\]\\s*(\\S+)\\s*(\\S.*)','1','','2','3',47,10),(43,'^security\\[failure\\] (\\d*) (.*)','','','1','2',49,10),(44,'%PIX-1-(\\d*): (.*)','1','','','2',67,2),(45,'%PIX-2-(\\d*): (.*)','1','','','2',66,2),(46,'%PIX-3-(\\d*): (.*)','1','','','2',65,2),(47,'%PIX-4-(\\d*): (.*)','1','','','2',64,2),(48,'%PIX-6-(\\d*): (.*)','1','','','2',62,2),(49,'%PIX-5-(\\d*): (.*)','1','','','2',63,2),(50,'%PIX-7-(\\d*): (.*)','1','','','2',61,2),(51,'%PIX-4-106023:','6','4','1','2',29,1),(52,'^UPS: (.*)\\. (.*)$','UPS','','','1',26,1),(53,'WebOS <slb>: real server (\\S+) operational','1','','up','',68,1),(54,'WebOS <slb>: cannot contact real server (\\S+)','1','','down','',68,1),(55,'WebOS <slb>: No services are available for Virtual Server\\d+:(\\S+)','1','','down','',70,1),(56,'WebOS <slb>: Services are available for Virtual Server\\d+:(\\S+)','1','','up','',70,1),(57,'WebOS <slb>: real service (\\S+) operational','1','','up','',69,1),(58,'WebOS <slb>: cannot contact real service (\\S+)','1','','closed','',69,1),(59,'%ISDN-6-CONNECT: Interface (\\S+) is now (\\S+) (.+)$','1','','2','3',72,1),(60,'%ISDN-6-DISCONNECT: Interface (\\S+) (\\S+) (.+)$','1','','2','3',72,1);
/*!40000 ALTER TABLE `syslog_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tools`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tools` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(60) NOT NULL DEFAULT '',
  `name` char(30) NOT NULL DEFAULT '',
  `file_group` char(30) NOT NULL DEFAULT '',
  `itype` int(10) NOT NULL DEFAULT '1',
  `pos` int(3) NOT NULL DEFAULT '1',
  `allow_set` tinyint(1) NOT NULL DEFAULT '0',
  `allow_get` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `itype` (`itype`,`pos`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tools`
--

LOCK TABLES `tools` WRITE;
/*!40000 ALTER TABLE `tools` DISABLE KEYS */;
INSERT INTO `tools` VALUES (1,'Nothing','none','none',1,1,0,1),(3,'Description','if_alias','',4,2,1,1),(4,'Change Admin Status','if_admin','',4,3,1,1),(5,'Connections List','tcp_cnx','',2,1,1,1);
/*!40000 ALTER TABLE `tools` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trap_receivers`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trap_receivers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `position` int(4) NOT NULL DEFAULT '0',
  `match_oid` char(100) NOT NULL DEFAULT '',
  `description` char(60) NOT NULL DEFAULT '',
  `command` char(60) NOT NULL DEFAULT '',
  `parameters` char(250) NOT NULL DEFAULT '',
  `backend` int(10) NOT NULL DEFAULT '1',
  `interface_type` int(10) NOT NULL DEFAULT '1',
  `stop_if_matches` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trap_receivers`
--

LOCK TABLES `trap_receivers` WRITE;
/*!40000 ALTER TABLE `trap_receivers` DISABLE KEYS */;
INSERT INTO `trap_receivers` VALUES (1,99,'.*','Default Trap Receiver','unknown','',2,1,1),(2,10,'.1.3.6.1.6.3.1.1.5.4','Link Up','static','up,interfacenumber,1',12,4,1),(3,10,'.1.3.6.1.6.3.1.1.5.3','Link Down','static','down,interfacenumber,1',12,4,1),(4,10,'enterprises.1123.4.300.0.1','IBM DS Event','static','warning,state,2',12,1,1),(10001,10,'enterprises.9.0.1','blah','static','warning,state,2',2,4,1);
/*!40000 ALTER TABLE `trap_receivers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traps`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traps` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` char(20) NOT NULL DEFAULT '',
  `trap_oid` char(250) NOT NULL DEFAULT '',
  `analized` tinyint(1) NOT NULL DEFAULT '0',
  `date` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `analized` (`analized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `traps`
--

LOCK TABLES `traps` WRITE;
/*!40000 ALTER TABLE `traps` DISABLE KEYS */;
/*!40000 ALTER TABLE `traps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traps_varbinds`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traps_varbinds` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `trapid` int(10) NOT NULL DEFAULT '0',
  `trap_oid` varchar(250) DEFAULT NULL,
  `value` varchar(250) NOT NULL DEFAULT '',
  `oidid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `trapid` (`trapid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trap Variable Bindings';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `traps_varbinds`
--

LOCK TABLES `traps_varbinds` WRITE;
/*!40000 ALTER TABLE `traps_varbinds` DISABLE KEYS */;
/*!40000 ALTER TABLE `traps_varbinds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `triggers`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `triggers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(40) NOT NULL DEFAULT '',
  `type` char(20) NOT NULL DEFAULT 'alarm',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Triggers to be check';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `triggers`
--

LOCK TABLES `triggers` WRITE;
/*!40000 ALTER TABLE `triggers` DISABLE KEYS */;
INSERT INTO `triggers` VALUES (1,'No Trigger','alarm'),(2,'Interface Status Change','alarm');
/*!40000 ALTER TABLE `triggers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `triggers_rules`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `triggers_rules` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `trigger_id` int(10) NOT NULL DEFAULT '1',
  `pos` int(4) NOT NULL DEFAULT '10',
  `field` char(40) NOT NULL DEFAULT '',
  `operator` char(20) NOT NULL DEFAULT '',
  `value` char(100) NOT NULL DEFAULT '',
  `action_id` int(10) NOT NULL DEFAULT '1',
  `action_parameters` char(250) NOT NULL DEFAULT '',
  `stop` tinyint(1) NOT NULL DEFAULT '1',
  `and_or` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `trigger_id` (`trigger_id`,`pos`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Trigger Rules';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `triggers_rules`
--

LOCK TABLES `triggers_rules` WRITE;
/*!40000 ALTER TABLE `triggers_rules` DISABLE KEYS */;
INSERT INTO `triggers_rules` VALUES (1,1,10,'none','=','',1,'',1,1),(2,2,10,'type','!IN','12,25',2,'from:,subject:<interface-client_shortname> <interface-interface> <interface-description> <alarm-type_description> <alarm-state_description>,comment:Default Trigger',0,1);
/*!40000 ALTER TABLE `triggers_rules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `triggers_users`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `triggers_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL DEFAULT '1',
  `trigger_id` int(10) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Multiple triggers per user Relationship';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `triggers_users`
--

LOCK TABLES `triggers_users` WRITE;
/*!40000 ALTER TABLE `triggers_users` DISABLE KEYS */;
INSERT INTO `triggers_users` VALUES (1,1,1,0);
/*!40000 ALTER TABLE `triggers_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `types`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `types` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `description` char(30) NOT NULL DEFAULT '',
  `severity` int(10) NOT NULL DEFAULT '1',
  `text` char(250) NOT NULL DEFAULT '',
  `generate_alarm` tinyint(1) NOT NULL DEFAULT '0',
  `alarm_up` int(10) NOT NULL DEFAULT '1',
  `alarm_duration` int(5) NOT NULL DEFAULT '0',
  `show_default` tinyint(1) NOT NULL DEFAULT '1',
  `show_host` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `severity` (`severity`),
  KEY `description` (`description`),
  KEY `generate_alarm` (`generate_alarm`)
) ENGINE=MyISAM AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `types`
--

LOCK TABLES `types` WRITE;
/*!40000 ALTER TABLE `types` DISABLE KEYS */;
INSERT INTO `types` VALUES (1,'Unknown',2,'<interface> <user> <state> <info>',0,1,0,1,1),(2,'Configuration',2,'<user>: Changed Configuration from <info> <interface>',0,1,0,1,1),(3,'Interface Protocol',3,'Interface <interface> Protocol <state> <info> (<client> <interface-description>)',1,1,0,1,1),(4,'Interface Link',4,'Interface <interface> Link <state> <info> (<client> <interface-description>)',0,1,0,1,1),(5,'Controller Status',4,'Controller  <info> <interface> <state>',0,1,0,1,1),(6,'BGP Status',5,'BGP Neighbor <interface> <state> <info> (<client> <interface-description>)',1,1,0,1,1),(7,'Interface Shutdown',4,'Interface <interface> <info> <state> (<client> <interface-description>)',0,4,0,1,1),(8,'Command',2,'<user>: <info>',0,1,0,1,1),(9,'RShell Attempt',14,'RShell attempt from <info> <state>',0,1,0,1,1),(12,'SLA',14,'<interface> <info> (<client> <interface-description>)',1,1,1800,1,1),(17,'Clear Counters',14,'<user> Cleared Counters of <interface>  (<client> <interface-description>)',0,1,0,1,1),(22,'TCP/UDP Service',18,'TCP/UDP Service <interface> <state> (<client> <interface-description>) <info>',1,1,0,1,1),(25,'Administrative',13,'<interface> <info>',1,1,1800,1,1),(26,'Environmental',5,'<interface> <state> <info>',1,1,0,1,1),(28,'PIX Event',14,'<info>',0,1,0,1,1),(29,'PIX Port',2,'<state> <info> packet from <user> to <interface>',0,1,0,1,1),(34,'Duplex Mismatch',2,'Duplex Mismatch, <interface> is not full duplex and <user> <info> is full duplex',0,1,0,1,1),(35,'ACL',14,'ACL <interface> <state> <info> packets from <user>',0,1,0,1,1),(36,'BGP Notification',14,'Notification <state> <interface> <info>',0,1,0,1,1),(37,'Excess Collitions',2,'Excess Collitions on Interface <interface>',0,1,0,1,1),(38,'Application',5,'Application <interface> is <state> <info> (<client> <interface-description>)',1,1,0,1,1),(39,'TCP Content',18,'Content Response on <interface> is <state> (<client> <interface-description>) <info>',1,1,0,1,1),(40,'Reachability',5,'Host is <state> with <info>',1,1,0,1,1),(41,'NTP',14,'<interface> is <state> <info>',1,1,0,1,1),(42,'Tool Action',5,'<interface> <info> changed to <state> by <user> (<client> <interface-description>)',0,1,0,1,1),(43,'Internal',14,'<user> <interface> <state> <info>',0,1,0,1,0),(44,'Syslog',14,'<interface>: <info>',0,1,0,1,1),(45,'Hide this Event',14,'<interface> <user> <state> <info>',0,1,0,0,1),(46,'Win Info',14,'<interface>: <info> (ID:<state>)',0,1,0,2,1),(47,'Win Warning',2,'<interface>: <info> (ID:<state>)',0,1,0,1,1),(48,'Win Error',3,'<interface>: <info> (ID:<state>)',0,1,0,1,1),(49,'Win Security',3,'<info> (ID:<state>)',0,1,0,1,1),(50,'SQL',3,'SQL <interface> is <state> <info>',1,1,0,1,1),(60,'APC Status',5,'<interface> is <state> <info>',1,1,0,1,1),(61,'PIX Debug',13,'<info> (ID:<interface>)',0,1,0,2,1),(62,'PIX Info',14,'<info> (ID:<interface>)',0,1,0,2,1),(63,'PIX Notif',2,'<info> (ID:<interface>)',0,1,0,2,1),(64,'PIX Warn',18,'<info> (ID:<interface>)',0,1,0,2,1),(65,'PIX Error',3,'<info> (ID:<interface>)',0,1,0,2,1),(66,'PIX Crit',4,'<info> (ID:<interface>)',1,1,0,1,1),(67,'PIX Alert',5,'<info> (ID:<interface>)',1,1,0,1,1),(68,'Alteon RServer',3,'Real Server <interface> is <state>',1,1,0,1,1),(69,'Alteon Service',3,'Real Service <interface> is <state> <info>',1,1,0,1,1),(70,'Alteon VServer',3,'Virtual Server <interface> is <state> <info>',0,1,0,1,1),(71,'Brocade FC Port',3,'<interface> <state> (<info>)',1,1,0,1,1),(72,'ISDN',14,'<interface> <state> <info>',1,1,0,1,1),(73,'To delete',13,'<info>  <state>  <interface> <user>',0,1,0,2,1),(74,'IBM error',5,'<info> (id:<interface>)',1,1,0,1,1),(75,'IBM Warning',127,'<interface> is in <state> state',1,1,0,1,1),(76,'Disable polling',13,'Polling for host <interface> is disabled (enabling time: <info>)',0,1,0,1,0),(77,'IBM San Trap',5,'<user>: <state> <info> (<interface>)',1,1,0,1,1),(78,'OS/400 Error',5,'A subsystem is <state> on the OS/400',1,1,0,1,1),(79,'Enable polling',13,'Polling for host <interface> is enabled',0,1,0,1,0),(80,'Storage Controller',4,'<info>',1,1,0,1,1);
/*!40000 ALTER TABLE `types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zones`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zones` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `zone` char(60) NOT NULL DEFAULT '',
  `shortname` char(10) NOT NULL DEFAULT '',
  `image` char(30) NOT NULL DEFAULT '',
  `seeds` char(250) NOT NULL DEFAULT '',
  `max_deep` tinyint(1) NOT NULL DEFAULT '2',
  `communities` char(250) NOT NULL DEFAULT '',
  `refresh` int(6) NOT NULL DEFAULT '86400',
  `admin_status` tinyint(1) NOT NULL DEFAULT '0',
  `show_zone` tinyint(1) NOT NULL DEFAULT '1',
  `allow_private` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zones`
--

LOCK TABLES `zones` WRITE;
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
INSERT INTO `zones` VALUES (1,'Unknown','UNK','unknown.png','',1,'',86400,0,1,0),(2,'New Zone','NewZone','unknown.png','',1,'',86400,0,1,1);
/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-05-26 14:50:28
ALTER TABLE interface_types AUTO_INCREMENT = 10001;
ALTER TABLE interface_types_fields AUTO_INCREMENT = 10001;
ALTER TABLE interface_types_field_types AUTO_INCREMENT = 10001;
ALTER TABLE graph_types AUTO_INCREMENT = 10001;
ALTER TABLE alarm_states AUTO_INCREMENT = 10001;
ALTER TABLE severity AUTO_INCREMENT = 10001;
ALTER TABLE syslog_types AUTO_INCREMENT = 10001;
ALTER TABLE trap_receivers AUTO_INCREMENT = 10001;
ALTER TABLE types AUTO_INCREMENT = 10001;
ALTER TABLE slas AUTO_INCREMENT = 10001;
ALTER TABLE slas_cond AUTO_INCREMENT = 10001;
ALTER TABLE slas_sla_cond AUTO_INCREMENT = 10001;
ALTER TABLE filters AUTO_INCREMENT = 10001;
ALTER TABLE filters_fields AUTO_INCREMENT = 10001;
ALTER TABLE filters_cond AUTO_INCREMENT = 10001;
ALTER TABLE pollers AUTO_INCREMENT = 10001;
ALTER TABLE pollers_groups AUTO_INCREMENT = 10001;
ALTER TABLE pollers_backend AUTO_INCREMENT = 10001;
ALTER TABLE pollers_poller_groups AUTO_INCREMENT = 10001;
ALTER TABLE autodiscovery AUTO_INCREMENT = 10001;
ALTER TABLE hosts_config_types AUTO_INCREMENT = 10001;
ALTER TABLE tools AUTO_INCREMENT = 10001;
ALTER TABLE profiles_options AUTO_INCREMENT = 10001;
ALTER TABLE actions AUTO_INCREMENT = 10001;
ALTER TABLE profiles_values AUTO_INCREMENT = 300;
