Resolvendo problema de Nagios + NPC

Publicado por Rogério Tomassoni em 08/09/2009

[ Hits: 6.562 ]

 


Resolvendo problema de Nagios + NPC



Com as versões Nagios 3.2.0, NPC 2.0.4 (GA), ndoutils-1.4b8 e Cacti 0.8.7e, tive problemas com o banco, usando a estrutura padrão da instalação do plugin. O processo que realizei foi o seguinte.

Com Nagios e NDO parados, instalei o NDO normalmente criando a sua estrutura de banco com script que o acompanha.

Instalei o plugin NPC padrão usando o script que o acompanha.

Após isso meu banco ficou com ambas estruturas de tabelas (Prefix: nagios_ e npc_), logo removi todas as tabelas com prefix npc_ e renomeei todas com Prefix nagios_ para npc_. Até este ponto ok. Porém faltava na estrutura a tabela npc_settings (sem ela o Cacti>NPC não exibia corretamente os grupos etc, ficando em branco BUG proposital). Então abri o arquivo setup do plugin, recortei o script que criava a tabela e executei na minha GUI SQLyog para criá-la.

Script:

CREATE TABLE npc_settings (
   user_id MEDIUMINT(8) UNSIGNED NOT NULL,
   settings TEXT DEFAULT NULL,
   PRIMARY KEY  (user_id)
) ENGINE=INNODB COMMENT='NPC user settings';

Também precisei atualizar algumas outras tabelas, para isso usei o script que vem juntamente com plugin (upgrade_schema.sql), executando o mesmo processo acima.

Pronto, funcionou perfeito!

Abaixo segue a estrutura completa do banco (Cacti + NPC). Lembrando que uso MySQL. Só copiar e executá-lo.

/*
SQLyog Community Edition- MySQL GUI v8.12
MySQL - 5.0.45 : Database - cacti
******************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`cacti` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `cacti`;

/*Table structure for table `cdef` */

DROP TABLE IF EXISTS `cdef`;

CREATE TABLE `cdef` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

/*Table structure for table `cdef_items` */

DROP TABLE IF EXISTS `cdef_items`;

CREATE TABLE `cdef_items` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `cdef_id` mediumint(8) unsigned NOT NULL default '0',
  `sequence` mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(2) NOT NULL default '0',
  `value` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `cdef_id` (`cdef_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

/*Table structure for table `colors` */

DROP TABLE IF EXISTS `colors`;

CREATE TABLE `colors` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hex` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;

/*Table structure for table `data_input` */

DROP TABLE IF EXISTS `data_input`;

CREATE TABLE `data_input` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `name` varchar(200) NOT NULL default '',
  `input_string` varchar(255) default NULL,
  `type_id` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

/*Table structure for table `data_input_data` */

DROP TABLE IF EXISTS `data_input_data`;

CREATE TABLE `data_input_data` (
  `data_input_field_id` mediumint(8) unsigned NOT NULL default '0',
  `data_template_data_id` mediumint(8) unsigned NOT NULL default '0',
  `t_value` char(2) default NULL,
  `value` text,
  PRIMARY KEY  (`data_input_field_id`,`data_template_data_id`),
  KEY `t_value` (`t_value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `data_input_fields` */

DROP TABLE IF EXISTS `data_input_fields`;

CREATE TABLE `data_input_fields` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `data_input_id` mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(200) NOT NULL default '',
  `data_name` varchar(50) NOT NULL default '',
  `input_output` char(3) NOT NULL default '',
  `update_rra` char(2) default '0',
  `sequence` smallint(5) NOT NULL default '0',
  `type_code` varchar(40) default NULL,
  `regexp_match` varchar(200) default NULL,
  `allow_nulls` char(2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `data_input_id` (`data_input_id`),
  KEY `type_code` (`type_code`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

/*Table structure for table `data_local` */

DROP TABLE IF EXISTS `data_local`;

CREATE TABLE `data_local` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `data_template_id` mediumint(8) unsigned NOT NULL default '0',
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `snmp_query_id` mediumint(8) NOT NULL default '0',
  `snmp_index` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=316 DEFAULT CHARSET=latin1;

/*Table structure for table `data_template` */

DROP TABLE IF EXISTS `data_template`;

CREATE TABLE `data_template` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `name` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

/*Table structure for table `data_template_data` */

DROP TABLE IF EXISTS `data_template_data`;

CREATE TABLE `data_template_data` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `local_data_template_data_id` mediumint(8) unsigned NOT NULL default '0',
  `local_data_id` mediumint(8) unsigned NOT NULL default '0',
  `data_template_id` mediumint(8) unsigned NOT NULL default '0',
  `data_input_id` mediumint(8) unsigned NOT NULL default '0',
  `t_name` char(2) default NULL,
  `name` varchar(250) NOT NULL default '',
  `name_cache` varchar(255) NOT NULL default '',
  `data_source_path` varchar(255) default NULL,
  `t_active` char(2) default NULL,
  `active` char(2) default NULL,
  `t_rrd_step` char(2) default NULL,
  `rrd_step` mediumint(8) unsigned NOT NULL default '0',
  `t_rra_id` char(2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `local_data_id` (`local_data_id`),
  KEY `data_template_id` (`data_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;

/*Table structure for table `data_template_data_rra` */

DROP TABLE IF EXISTS `data_template_data_rra`;

CREATE TABLE `data_template_data_rra` (
  `data_template_data_id` mediumint(8) unsigned NOT NULL default '0',
  `rra_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`data_template_data_id`,`rra_id`),
  KEY `data_template_data_id` (`data_template_data_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `data_template_rrd` */

DROP TABLE IF EXISTS `data_template_rrd`;

CREATE TABLE `data_template_rrd` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `local_data_template_rrd_id` mediumint(8) unsigned NOT NULL default '0',
  `local_data_id` mediumint(8) unsigned NOT NULL default '0',
  `data_template_id` mediumint(8) unsigned NOT NULL default '0',
  `t_rrd_maximum` char(2) default NULL,
  `rrd_maximum` varchar(20) NOT NULL default '0',
  `t_rrd_minimum` char(2) default NULL,
  `rrd_minimum` varchar(20) NOT NULL default '0',
  `t_rrd_heartbeat` char(2) default NULL,
  `rrd_heartbeat` mediumint(6) NOT NULL default '0',
  `t_data_source_type_id` char(2) default NULL,
  `data_source_type_id` smallint(5) NOT NULL default '0',
  `t_data_source_name` char(2) default NULL,
  `data_source_name` varchar(19) NOT NULL default '',
  `t_data_input_field_id` char(2) default NULL,
  `data_input_field_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `local_data_id` (`local_data_id`),
  KEY `data_template_id` (`data_template_id`),
  KEY `local_data_template_rrd_id` (`local_data_template_rrd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=691 DEFAULT CHARSET=latin1;

/*Table structure for table `graph_local` */

DROP TABLE IF EXISTS `graph_local`;

CREATE TABLE `graph_local` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `snmp_query_id` mediumint(8) NOT NULL default '0',
  `snmp_index` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `host_id` (`host_id`),
  KEY `graph_template_id` (`graph_template_id`),
  KEY `snmp_query_id` (`snmp_query_id`),
  KEY `snmp_index` (`snmp_index`)
) ENGINE=MyISAM AUTO_INCREMENT=298 DEFAULT CHARSET=latin1 COMMENT='Creates a relationship for each item in a custom graph.';

/*Table structure for table `graph_template_input` */

DROP TABLE IF EXISTS `graph_template_input`;

CREATE TABLE `graph_template_input` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text,
  `column_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 COMMENT='Stores the names for graph item input groups.';

/*Table structure for table `graph_template_input_defs` */

DROP TABLE IF EXISTS `graph_template_input_defs`;

CREATE TABLE `graph_template_input_defs` (
  `graph_template_input_id` mediumint(8) unsigned NOT NULL default '0',
  `graph_template_item_id` int(12) unsigned NOT NULL default '0',
  PRIMARY KEY  (`graph_template_input_id`,`graph_template_item_id`),
  KEY `graph_template_input_id` (`graph_template_input_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the relationship for what graph iitems are associated';

/*Table structure for table `graph_templates` */

DROP TABLE IF EXISTS `graph_templates`;

CREATE TABLE `graph_templates` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` char(32) NOT NULL default '',
  `name` char(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COMMENT='Contains each graph template name.';

/*Table structure for table `graph_templates_gprint` */

DROP TABLE IF EXISTS `graph_templates_gprint`;

CREATE TABLE `graph_templates_gprint` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `gprint_text` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Table structure for table `graph_templates_graph` */

DROP TABLE IF EXISTS `graph_templates_graph`;

CREATE TABLE `graph_templates_graph` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `local_graph_template_graph_id` mediumint(8) unsigned NOT NULL default '0',
  `local_graph_id` mediumint(8) unsigned NOT NULL default '0',
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  `t_image_format_id` char(2) default '0',
  `image_format_id` tinyint(1) NOT NULL default '0',
  `t_title` char(2) default '0',
  `title` varchar(255) NOT NULL default '',
  `title_cache` varchar(255) NOT NULL default '',
  `t_height` char(2) default '0',
  `height` mediumint(8) NOT NULL default '0',
  `t_width` char(2) default '0',
  `width` mediumint(8) NOT NULL default '0',
  `t_upper_limit` char(2) default '0',
  `upper_limit` varchar(20) NOT NULL default '0',
  `t_lower_limit` char(2) default '0',
  `lower_limit` varchar(20) NOT NULL default '0',
  `t_vertical_label` char(2) default '0',
  `vertical_label` varchar(200) default NULL,
  `t_slope_mode` char(2) default '0',
  `slope_mode` char(2) default 'on',
  `t_auto_scale` char(2) default '0',
  `auto_scale` char(2) default NULL,
  `t_auto_scale_opts` char(2) default '0',
  `auto_scale_opts` tinyint(1) NOT NULL default '0',
  `t_auto_scale_log` char(2) default '0',
  `auto_scale_log` char(2) default NULL,
  `t_scale_log_units` char(2) default '0',
  `scale_log_units` char(2) default NULL,
  `t_auto_scale_rigid` char(2) default '0',
  `auto_scale_rigid` char(2) default NULL,
  `t_auto_padding` char(2) default '0',
  `auto_padding` char(2) default NULL,
  `t_base_value` char(2) default '0',
  `base_value` mediumint(8) NOT NULL default '0',
  `t_grouping` char(2) default '0',
  `grouping` char(2) NOT NULL default '',
  `t_export` char(2) default '0',
  `export` char(2) default NULL,
  `t_unit_value` char(2) default '0',
  `unit_value` varchar(20) default NULL,
  `t_unit_exponent_value` char(2) default '0',
  `unit_exponent_value` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `local_graph_id` (`local_graph_id`),
  KEY `graph_template_id` (`graph_template_id`),
  KEY `title_cache` (`title_cache`)
) ENGINE=MyISAM AUTO_INCREMENT=342 DEFAULT CHARSET=latin1 COMMENT='Stores the actual graph data.';

/*Table structure for table `graph_templates_item` */

DROP TABLE IF EXISTS `graph_templates_item`;

CREATE TABLE `graph_templates_item` (
  `id` int(12) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `local_graph_template_item_id` int(12) unsigned NOT NULL default '0',
  `local_graph_id` mediumint(8) unsigned NOT NULL default '0',
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  `task_item_id` mediumint(8) unsigned NOT NULL default '0',
  `color_id` mediumint(8) unsigned NOT NULL default '0',
  `alpha` char(2) default 'FF',
  `graph_type_id` tinyint(3) NOT NULL default '0',
  `cdef_id` mediumint(8) unsigned NOT NULL default '0',
  `consolidation_function_id` tinyint(2) NOT NULL default '0',
  `text_format` varchar(255) default NULL,
  `value` varchar(255) default NULL,
  `hard_return` char(2) default NULL,
  `gprint_id` mediumint(8) unsigned NOT NULL default '0',
  `sequence` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `graph_template_id` (`graph_template_id`),
  KEY `local_graph_id` (`local_graph_id`),
  KEY `task_item_id` (`task_item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3266 DEFAULT CHARSET=latin1 COMMENT='Stores the actual graph item data.';

/*Table structure for table `graph_tree` */

DROP TABLE IF EXISTS `graph_tree`;

CREATE TABLE `graph_tree` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `sort_type` tinyint(3) unsigned NOT NULL default '1',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Table structure for table `graph_tree_items` */

DROP TABLE IF EXISTS `graph_tree_items`;

CREATE TABLE `graph_tree_items` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `graph_tree_id` smallint(5) unsigned NOT NULL default '0',
  `local_graph_id` mediumint(8) unsigned NOT NULL default '0',
  `rra_id` smallint(8) unsigned NOT NULL default '0',
  `title` varchar(255) default NULL,
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `order_key` varchar(100) NOT NULL default '0',
  `host_grouping_type` tinyint(3) unsigned NOT NULL default '1',
  `sort_children_type` tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `graph_tree_id` (`graph_tree_id`),
  KEY `host_id` (`host_id`),
  KEY `local_graph_id` (`local_graph_id`),
  KEY `order_key` (`order_key`)
) ENGINE=MyISAM AUTO_INCREMENT=298 DEFAULT CHARSET=latin1;

/*Table structure for table `host` */

DROP TABLE IF EXISTS `host`;

CREATE TABLE `host` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `host_template_id` mediumint(8) unsigned NOT NULL default '0',
  `description` varchar(150) NOT NULL default '',
  `hostname` varchar(250) default NULL,
  `notes` text,
  `snmp_community` varchar(100) default NULL,
  `snmp_version` tinyint(1) unsigned NOT NULL default '1',
  `snmp_username` varchar(50) default NULL,
  `snmp_password` varchar(50) default NULL,
  `snmp_auth_protocol` char(5) default '',
  `snmp_priv_passphrase` varchar(200) default '',
  `snmp_priv_protocol` char(6) default '',
  `snmp_context` varchar(64) default '',
  `snmp_port` mediumint(5) unsigned NOT NULL default '161',
  `snmp_timeout` mediumint(8) unsigned NOT NULL default '500',
  `availability_method` smallint(5) unsigned NOT NULL default '1',
  `ping_method` smallint(5) unsigned default '0',
  `ping_port` int(12) unsigned default '0',
  `ping_timeout` int(12) unsigned default '500',
  `ping_retries` int(12) unsigned default '2',
  `max_oids` int(12) unsigned default '10',
  `disabled` char(2) default NULL,
  `status` tinyint(2) NOT NULL default '0',
  `status_event_count` mediumint(8) unsigned NOT NULL default '0',
  `status_fail_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `status_rec_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `status_last_error` varchar(255) default '',
  `min_time` decimal(10,5) default '9.99999',
  `max_time` decimal(10,5) default '0.00000',
  `cur_time` decimal(10,5) default '0.00000',
  `avg_time` decimal(10,5) default '0.00000',
  `total_polls` int(12) unsigned default '0',
  `failed_polls` int(12) unsigned default '0',
  `availability` decimal(8,5) NOT NULL default '100.00000',
  `npc_host_object_id` int(11) default NULL COMMENT 'Nagios host object mapping',
  PRIMARY KEY  (`id`),
  KEY `disabled` (`disabled`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

/*Table structure for table `host_graph` */

DROP TABLE IF EXISTS `host_graph`;

CREATE TABLE `host_graph` (
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`host_id`,`graph_template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `host_snmp_cache` */

DROP TABLE IF EXISTS `host_snmp_cache`;

CREATE TABLE `host_snmp_cache` (
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `snmp_query_id` mediumint(8) unsigned NOT NULL default '0',
  `field_name` varchar(50) NOT NULL default '',
  `field_value` varchar(255) default NULL,
  `snmp_index` varchar(255) NOT NULL default '',
  `oid` text NOT NULL,
  PRIMARY KEY  (`host_id`,`snmp_query_id`,`field_name`,`snmp_index`),
  KEY `host_id` (`host_id`,`field_name`),
  KEY `snmp_index` (`snmp_index`),
  KEY `field_name` (`field_name`),
  KEY `field_value` (`field_value`),
  KEY `snmp_query_id` (`snmp_query_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `host_snmp_query` */

DROP TABLE IF EXISTS `host_snmp_query`;

CREATE TABLE `host_snmp_query` (
  `host_id` mediumint(8) unsigned NOT NULL default '0',
  `snmp_query_id` mediumint(8) unsigned NOT NULL default '0',
  `sort_field` varchar(50) NOT NULL default '',
  `title_format` varchar(50) NOT NULL default '',
  `reindex_method` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`host_id`,`snmp_query_id`),
  KEY `host_id` (`host_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `host_template` */

DROP TABLE IF EXISTS `host_template`;

CREATE TABLE `host_template` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

/*Table structure for table `host_template_graph` */

DROP TABLE IF EXISTS `host_template_graph`;

CREATE TABLE `host_template_graph` (
  `host_template_id` mediumint(8) unsigned NOT NULL default '0',
  `graph_template_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`host_template_id`,`graph_template_id`),
  KEY `host_template_id` (`host_template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `host_template_snmp_query` */

DROP TABLE IF EXISTS `host_template_snmp_query`;

CREATE TABLE `host_template_snmp_query` (
  `host_template_id` mediumint(8) unsigned NOT NULL default '0',
  `snmp_query_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`host_template_id`,`snmp_query_id`),
  KEY `host_template_id` (`host_template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `npc_acknowledgements` */

DROP TABLE IF EXISTS `npc_acknowledgements`;

CREATE TABLE `npc_acknowledgements` (
  `acknowledgement_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `entry_time_usec` int(11) NOT NULL default '0',
  `acknowledgement_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `state` smallint(6) NOT NULL default '0',
  `author_name` varchar(64) NOT NULL default '',
  `comment_data` varchar(255) NOT NULL default '',
  `is_sticky` smallint(6) NOT NULL default '0',
  `persistent_comment` smallint(6) NOT NULL default '0',
  `notify_contacts` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`acknowledgement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Current and historical host and service acknowledgements';

/*Table structure for table `npc_commands` */

DROP TABLE IF EXISTS `npc_commands`;

CREATE TABLE `npc_commands` (
  `command_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `command_line` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`command_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `object_id`, `config_type`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COMMENT='Command definitions';

/*Table structure for table `npc_commenthistory` */

DROP TABLE IF EXISTS `npc_commenthistory`;

CREATE TABLE `npc_commenthistory` (
  `commenthistory_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `entry_time_usec` int(11) NOT NULL default '0',
  `comment_type` smallint(6) NOT NULL default '0',
  `entry_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `comment_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `internal_comment_id` int(11) NOT NULL default '0',
  `author_name` varchar(64) NOT NULL default '',
  `comment_data` varchar(255) NOT NULL default '',
  `is_persistent` smallint(6) NOT NULL default '0',
  `comment_source` smallint(6) NOT NULL default '0',
  `expires` smallint(6) NOT NULL default '0',
  `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `deletion_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `deletion_time_usec` int(11) NOT NULL default '0',
  PRIMARY KEY  (`commenthistory_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `comment_time`, `internal_comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical host and service comments';

/*Table structure for table `npc_comments` */

DROP TABLE IF EXISTS `npc_comments`;

CREATE TABLE `npc_comments` (
  `comment_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `entry_time_usec` int(11) NOT NULL default '0',
  `comment_type` smallint(6) NOT NULL default '0',
  `entry_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `comment_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `internal_comment_id` int(11) NOT NULL default '0',
  `author_name` varchar(64) NOT NULL default '',
  `comment_data` varchar(255) NOT NULL default '',
  `is_persistent` smallint(6) NOT NULL default '0',
  `comment_source` smallint(6) NOT NULL default '0',
  `expires` smallint(6) NOT NULL default '0',
  `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`comment_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `comment_time`, `internal_comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `npc_configfiles` */

DROP TABLE IF EXISTS `npc_configfiles`;

CREATE TABLE `npc_configfiles` (
  `configfile_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `configfile_type` smallint(6) NOT NULL default '0',
  `configfile_path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`configfile_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `configfile_type`, `configfile_path`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Configuration files';

/*Table structure for table `npc_configfilevariables` */

DROP TABLE IF EXISTS `npc_configfilevariables`;

CREATE TABLE `npc_configfilevariables` (
  `configfilevariable_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `configfile_id` int(11) NOT NULL default '0',
  `varname` varchar(64) NOT NULL default '',
  `varvalue` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`configfilevariable_id`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=latin1 COMMENT='Configuration file variables';

/*Table structure for table `npc_conninfo` */

DROP TABLE IF EXISTS `npc_conninfo`;

CREATE TABLE `npc_conninfo` (
  `conninfo_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `agent_name` varchar(32) NOT NULL default '',
  `agent_version` varchar(8) NOT NULL default '',
  `disposition` varchar(16) NOT NULL default '',
  `connect_source` varchar(16) NOT NULL default '',
  `connect_type` varchar(16) NOT NULL default '',
  `connect_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `disconnect_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_checkin_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `data_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `data_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `bytes_processed` int(11) NOT NULL default '0',
  `lines_processed` int(11) NOT NULL default '0',
  `entries_processed` int(11) NOT NULL default '0',
  PRIMARY KEY  (`conninfo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='NDO2DB daemon connection information';

/*Table structure for table `npc_contact_addresses` */

DROP TABLE IF EXISTS `npc_contact_addresses`;

CREATE TABLE `npc_contact_addresses` (
  `contact_address_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `contact_id` int(11) NOT NULL default '0',
  `address_number` smallint(6) NOT NULL default '0',
  `address` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`contact_address_id`),
  UNIQUE KEY `contact_id` (`contact_id`, `address_number`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COMMENT='Contact addresses';

/*Table structure for table `npc_contact_notificationcommands` */

DROP TABLE IF EXISTS `npc_contact_notificationcommands`;

CREATE TABLE `npc_contact_notificationcommands` (
  `contact_notificationcommand_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `contact_id` int(11) NOT NULL default '0',
  `notification_type` smallint(6) NOT NULL default '0',
  `command_object_id` int(11) NOT NULL default '0',
  `command_args` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`contact_notificationcommand_id`),
  UNIQUE KEY `contact_id` (`contact_id`, `notification_type`, `command_object_id`, `command_args`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1 COMMENT='Contact host and service notification commands';

/*Table structure for table `npc_contactgroup_members` */

DROP TABLE IF EXISTS `npc_contactgroup_members`;

CREATE TABLE `npc_contactgroup_members` (
  `contactgroup_member_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `contactgroup_id` int(11) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`contactgroup_member_id`),
  UNIQUE KEY `instance_id` (`contactgroup_id`, `contact_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COMMENT='Contactgroup members';

/*Table structure for table `npc_contactgroups` */

DROP TABLE IF EXISTS `npc_contactgroups`;

CREATE TABLE `npc_contactgroups` (
  `contactgroup_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `contactgroup_object_id` int(11) NOT NULL default '0',
  `alias` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`contactgroup_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `config_type`, `contactgroup_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Contactgroup definitions';

/*Table structure for table `npc_contactnotificationmethods` */

DROP TABLE IF EXISTS `npc_contactnotificationmethods`;

CREATE TABLE `npc_contactnotificationmethods` (
  `contactnotificationmethod_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `contactnotification_id` int(11) NOT NULL default '0',
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_time_usec` int(11) NOT NULL default '0',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time_usec` int(11) NOT NULL default '0',
  `command_object_id` int(11) NOT NULL default '0',
  `command_args` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`contactnotificationmethod_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `contactnotification_id`, `start_time`,`start_time_usec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical record of contact notification methods';

/*Table structure for table `npc_contactnotifications` */

DROP TABLE IF EXISTS `npc_contactnotifications`;

CREATE TABLE `npc_contactnotifications` (
  `contactnotification_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `notification_id` int(11) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_time_usec` int(11) NOT NULL default '0',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time_usec` int(11) NOT NULL default '0',
  PRIMARY KEY  (`contactnotification_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `contact_object_id`, `start_time`, `start_time_usec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical record of contact notifications';

/*Table structure for table `npc_contacts` */

DROP TABLE IF EXISTS `npc_contacts`;

CREATE TABLE `npc_contacts` (
  `contact_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  `alias` varchar(64) NOT NULL default '',
  `email_address` varchar(255) NOT NULL default '',
  `pager_address` varchar(64) NOT NULL default '',
  `host_timeperiod_object_id` int(11) NOT NULL default '0',
  `service_timeperiod_object_id` int(11) NOT NULL default '0',
  `host_notifications_enabled` smallint(6) NOT NULL default '0',
  `service_notifications_enabled` smallint(6) NOT NULL default '0',
  `can_submit_commands` smallint(6) NOT NULL default '0',
  `notify_service_recovery` smallint(6) NOT NULL default '0',
  `notify_service_warning` smallint(6) NOT NULL default '0',
  `notify_service_unknown` smallint(6) NOT NULL default '0',
  `notify_service_critical` smallint(6) NOT NULL default '0',
  `notify_service_flapping` smallint(6) NOT NULL default '0',
  `notify_service_downtime` smallint(6) NOT NULL default '0',
  `notify_host_recovery` smallint(6) NOT NULL default '0',
  `notify_host_down` smallint(6) NOT NULL default '0',
  `notify_host_unreachable` smallint(6) NOT NULL default '0',
  `notify_host_flapping` smallint(6) NOT NULL default '0',
  `notify_host_downtime` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`contact_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `config_type`, `contact_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='Contact definitions';

/*Table structure for table `npc_contactstatus` */

DROP TABLE IF EXISTS `npc_contactstatus`;

CREATE TABLE `npc_contactstatus` (
  `contactstatus_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `host_notifications_enabled` smallint(6) NOT NULL default '0',
  `service_notifications_enabled` smallint(6) NOT NULL default '0',
  `last_host_notification` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_service_notification` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified_attributes` int(11) NOT NULL default '0',
  `modified_host_attributes` int(11) NOT NULL default '0',
  `modified_service_attributes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`contactstatus_id`),
  UNIQUE KEY `contact_object_id` (`contact_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='Contact status';

/*Table structure for table `npc_customvariables` */

DROP TABLE IF EXISTS `npc_customvariables`;

CREATE TABLE `npc_customvariables` (
  `customvariable_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `has_been_modified` smallint(6) NOT NULL default '0',
  `varname` varchar(255) NOT NULL default '',
  `varvalue` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`customvariable_id`),
  UNIQUE KEY `object_id_2` (`object_id`, `config_type`, `varname`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Custom variables';

/*Table structure for table `npc_customvariablestatus` */

DROP TABLE IF EXISTS `npc_customvariablestatus`;

CREATE TABLE `npc_customvariablestatus` (
  `customvariablestatus_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `has_been_modified` smallint(6) NOT NULL default '0',
  `varname` varchar(255) NOT NULL default '',
  `varvalue` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`customvariablestatus_id`),
  UNIQUE KEY `object_id_2` (`object_id`, `varname`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Custom variable status information';

/*Table structure for table `npc_dbversion` */

DROP TABLE IF EXISTS `npc_dbversion`;

CREATE TABLE `npc_dbversion` (
  `name` varchar(10) NOT NULL default '',
  `version` varchar(10) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `npc_downtimehistory` */

DROP TABLE IF EXISTS `npc_downtimehistory`;

CREATE TABLE `npc_downtimehistory` (
  `downtimehistory_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `downtime_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `author_name` varchar(64) NOT NULL default '',
  `comment_data` varchar(255) NOT NULL default '',
  `internal_downtime_id` int(11) NOT NULL default '0',
  `triggered_by_id` int(11) NOT NULL default '0',
  `is_fixed` smallint(6) NOT NULL default '0',
  `duration` smallint(6) NOT NULL default '0',
  `scheduled_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `scheduled_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `was_started` smallint(6) NOT NULL default '0',
  `actual_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `actual_start_time_usec` int(11) NOT NULL default '0',
  `actual_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `actual_end_time_usec` int(11) NOT NULL default '0',
  `was_cancelled` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`downtimehistory_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `object_id`,`entry_time`,`internal_downtime_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical scheduled host and service downtime';

/*Table structure for table `npc_eventhandlers` */

DROP TABLE IF EXISTS `npc_eventhandlers`;

CREATE TABLE `npc_eventhandlers` (
  `eventhandler_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `eventhandler_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `state` smallint(6) NOT NULL default '0',
  `state_type` smallint(6) NOT NULL default '0',
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_time_usec` int(11) NOT NULL default '0',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time_usec` int(11) NOT NULL default '0',
  `command_object_id` int(11) NOT NULL default '0',
  `command_args` varchar(255) NOT NULL default '',
  `command_line` varchar(255) NOT NULL default '',
  `timeout` smallint(6) NOT NULL default '0',
  `early_timeout` smallint(6) NOT NULL default '0',
  `execution_time` double NOT NULL default '0',
  `return_code` smallint(6) NOT NULL default '0',
  `output` varchar(255) NOT NULL default '',
  `long_output` varchar(8192) NOT NULL default '',
  PRIMARY KEY  (`eventhandler_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `object_id`, `start_time`, `start_time_usec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical host and service event handlers';

/*Table structure for table `npc_externalcommands` */

DROP TABLE IF EXISTS `npc_externalcommands`;

CREATE TABLE `npc_externalcommands` (
  `externalcommand_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `command_type` smallint(6) NOT NULL default '0',
  `command_name` varchar(128) NOT NULL default '',
  `command_args` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`externalcommand_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Historical record of processed external commands';

/*Table structure for table `npc_flappinghistory` */

DROP TABLE IF EXISTS `npc_flappinghistory`;

CREATE TABLE `npc_flappinghistory` (
  `flappinghistory_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `event_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `event_time_usec` int(11) NOT NULL default '0',
  `event_type` smallint(6) NOT NULL default '0',
  `reason_type` smallint(6) NOT NULL default '0',
  `flapping_type` smallint(6) NOT NULL default '0',
  `object_id` int(11) NOT NULL default '0',
  `percent_state_change` double NOT NULL default '0',
  `low_threshold` double NOT NULL default '0',
  `high_threshold` double NOT NULL default '0',
  `comment_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `internal_comment_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`flappinghistory_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Current and historical record of host and service flapping';

/*Table structure for table `npc_host_contactgroups` */

DROP TABLE IF EXISTS `npc_host_contactgroups`;

CREATE TABLE `npc_host_contactgroups` (
  `host_contactgroup_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `host_id` int(11) NOT NULL default '0',
  `contactgroup_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`host_contactgroup_id`),
  UNIQUE KEY `instance_id` (`host_id`, `contactgroup_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COMMENT='Host contact groups';

/*Table structure for table `npc_host_contacts` */

DROP TABLE IF EXISTS `npc_host_contacts`;

CREATE TABLE `npc_host_contacts` (
  `host_contact_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `host_id` int(11) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`host_contact_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `host_id`, `contact_object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `npc_host_graphs` */

DROP TABLE IF EXISTS `npc_host_graphs`;

CREATE TABLE `npc_host_graphs` (
  `host_graph_id` int(11) NOT NULL auto_increment,
  `host_object_id` int(11) NOT NULL,
  `local_graph_id` mediumint(8) unsigned NOT NULL,
  `pri` tinyint(1) default '1',
  PRIMARY KEY  (`host_graph_id`),
  KEY `idx1` (`host_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `npc_host_parenthosts` */

DROP TABLE IF EXISTS `npc_host_parenthosts`;

CREATE TABLE `npc_host_parenthosts` (
  `host_parenthost_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `host_id` int(11) NOT NULL default '0',
  `parent_host_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`host_parenthost_id`),
  UNIQUE KEY `instance_id` (`host_id`, `parent_host_object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Parent hosts';

/*Table structure for table `npc_hostchecks` */

DROP TABLE IF EXISTS `npc_hostchecks`;

CREATE TABLE `npc_hostchecks` (
  `hostcheck_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  `check_type` smallint(6) NOT NULL default '0',
  `is_raw_check` smallint(6) NOT NULL default '0',
  `current_check_attempt` smallint(6) NOT NULL default '0',
  `max_check_attempts` smallint(6) NOT NULL default '0',
  `state` smallint(6) NOT NULL default '0',
  `state_type` smallint(6) NOT NULL default '0',
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_time_usec` int(11) NOT NULL default '0',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time_usec` int(11) NOT NULL default '0',
  `command_object_id` int(11) NOT NULL default '0',
  `command_args` varchar(255) NOT NULL default '',
  `command_line` varchar(255) NOT NULL default '',
  `timeout` smallint(6) NOT NULL default '0',
  `early_timeout` smallint(6) NOT NULL default '0',
  `execution_time` double NOT NULL default '0',
  `latency` double NOT NULL default '0',
  `return_code` smallint(6) NOT NULL default '0',
  `output` varchar(255) NOT NULL default '',
  `long_output` varchar(8192) NOT NULL default '',
  `perfdata` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`hostcheck_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `host_object_id`, `start_time`, `start_time_usec`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COMMENT='Historical host checks';

/*Table structure for table `npc_hostdependencies` */

DROP TABLE IF EXISTS `npc_hostdependencies`;

CREATE TABLE `npc_hostdependencies` (
  `hostdependency_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  `dependent_host_object_id` int(11) NOT NULL default '0',
  `dependency_type` smallint(6) NOT NULL default '0',
  `inherits_parent` smallint(6) NOT NULL default '0',
  `timeperiod_object_id` int(11) NOT NULL default '0',
  `fail_on_up` smallint(6) NOT NULL default '0',
  `fail_on_down` smallint(6) NOT NULL default '0',
  `fail_on_unreachable` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`hostdependency_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `config_type`, `host_object_id`, `dependent_host_object_id`, `dependency_type`, `inherits_parent`, `fail_on_up`, `fail_on_down`, `fail_on_unreachable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Host dependency definitions';

/*Table structure for table `npc_hostescalation_contactgroups` */

DROP TABLE IF EXISTS `npc_hostescalation_contactgroups`;

CREATE TABLE `npc_hostescalation_contactgroups` (
  `hostescalation_contactgroup_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `hostescalation_id` int(11) NOT NULL default '0',
  `contactgroup_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`hostescalation_contactgroup_id`),
  UNIQUE KEY `instance_id` (`hostescalation_id`, `contactgroup_object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Host escalation contact groups';

/*Table structure for table `npc_hostescalation_contacts` */

DROP TABLE IF EXISTS `npc_hostescalation_contacts`;

CREATE TABLE `npc_hostescalation_contacts` (
  `hostescalation_contact_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `hostescalation_id` int(11) NOT NULL default '0',
  `contact_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`hostescalation_contact_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `hostescalation_id`, `contact_object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `npc_hostescalations` */

DROP TABLE IF EXISTS `npc_hostescalations`;

CREATE TABLE `npc_hostescalations` (
  `hostescalation_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  `timeperiod_object_id` int(11) NOT NULL default '0',
  `first_notification` smallint(6) NOT NULL default '0',
  `last_notification` smallint(6) NOT NULL default '0',
  `notification_interval` double NOT NULL default '0',
  `escalate_on_recovery` smallint(6) NOT NULL default '0',
  `escalate_on_down` smallint(6) NOT NULL default '0',
  `escalate_on_unreachable` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`hostescalation_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `config_type`, `host_object_id`, `timeperiod_object_id`, `first_notification`, `last_notification`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Host escalation definitions';

/*Table structure for table `npc_hostgroup_members` */

DROP TABLE IF EXISTS `npc_hostgroup_members`;

CREATE TABLE `npc_hostgroup_members` (
  `hostgroup_member_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `hostgroup_id` int(11) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`hostgroup_member_id`),
  UNIQUE KEY `instance_id` (`hostgroup_id`, `host_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COMMENT='Hostgroup members';

/*Table structure for table `npc_hostgroups` */

DROP TABLE IF EXISTS `npc_hostgroups`;

CREATE TABLE `npc_hostgroups` (
  `hostgroup_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `hostgroup_object_id` int(11) NOT NULL default '0',
  `alias` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`hostgroup_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `hostgroup_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Hostgroup definitions';

/*Table structure for table `npc_hosts` */

DROP TABLE IF EXISTS `npc_hosts`;

CREATE TABLE `npc_hosts` (
  `host_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `config_type` smallint(6) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  `alias` varchar(64) NOT NULL default '',
  `display_name` varchar(64) NOT NULL default '',
  `address` varchar(128) NOT NULL default '',
  `check_command_object_id` int(11) NOT NULL default '0',
  `check_command_args` varchar(255) NOT NULL default '',
  `eventhandler_command_object_id` int(11) NOT NULL default '0',
  `eventhandler_command_args` varchar(255) NOT NULL default '',
  `notification_timeperiod_object_id` int(11) NOT NULL default '0',
  `check_timeperiod_object_id` int(11) NOT NULL default '0',
  `failure_prediction_options` varchar(64) NOT NULL default '',
  `check_interval` double NOT NULL default '0',
  `retry_interval` double NOT NULL default '0',
  `max_check_attempts` smallint(6) NOT NULL default '0',
  `first_notification_delay` double NOT NULL default '0',
  `notification_interval` double NOT NULL default '0',
  `notify_on_down` smallint(6) NOT NULL default '0',
  `notify_on_unreachable` smallint(6) NOT NULL default '0',
  `notify_on_recovery` smallint(6) NOT NULL default '0',
  `notify_on_flapping` smallint(6) NOT NULL default '0',
  `notify_on_downtime` smallint(6) NOT NULL default '0',
  `stalk_on_up` smallint(6) NOT NULL default '0',
  `stalk_on_down` smallint(6) NOT NULL default '0',
  `stalk_on_unreachable` smallint(6) NOT NULL default '0',
  `flap_detection_enabled` smallint(6) NOT NULL default '0',
  `flap_detection_on_up` smallint(6) NOT NULL default '0',
  `flap_detection_on_down` smallint(6) NOT NULL default '0',
  `flap_detection_on_unreachable` smallint(6) NOT NULL default '0',
  `low_flap_threshold` double NOT NULL default '0',
  `high_flap_threshold` double NOT NULL default '0',
  `process_performance_data` smallint(6) NOT NULL default '0',
  `freshness_checks_enabled` smallint(6) NOT NULL default '0',
  `freshness_threshold` smallint(6) NOT NULL default '0',
  `passive_checks_enabled` smallint(6) NOT NULL default '0',
  `event_handler_enabled` smallint(6) NOT NULL default '0',
  `active_checks_enabled` smallint(6) NOT NULL default '0',
  `retain_status_information` smallint(6) NOT NULL default '0',
  `retain_nonstatus_information` smallint(6) NOT NULL default '0',
  `notifications_enabled` smallint(6) NOT NULL default '0',
  `obsess_over_host` smallint(6) NOT NULL default '0',
  `failure_prediction_enabled` smallint(6) NOT NULL default '0',
  `notes` varchar(255) NOT NULL default '',
  `notes_url` varchar(255) NOT NULL default '',
  `action_url` varchar(255) NOT NULL default '',
  `icon_image` varchar(255) NOT NULL default '',
  `icon_image_alt` varchar(255) NOT NULL default '',
  `vrml_image` varchar(255) NOT NULL default '',
  `statusmap_image` varchar(255) NOT NULL default '',
  `have_2d_coords` smallint(6) NOT NULL default '0',
  `x_2d` smallint(6) NOT NULL default '0',
  `y_2d` smallint(6) NOT NULL default '0',
  `have_3d_coords` smallint(6) NOT NULL default '0',
  `x_3d` double NOT NULL default '0',
  `y_3d` double NOT NULL default '0',
  `z_3d` double NOT NULL default '0',
  PRIMARY KEY  (`host_id`),
  UNIQUE KEY `instance_id` (`instance_id`, `config_type`, `host_object_id`),
  KEY `host_object_id` (`host_object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COMMENT='Host definitions';

/*Table structure for table `npc_hoststatus` */

DROP TABLE IF EXISTS `npc_hoststatus`;

CREATE TABLE `npc_hoststatus` (
  `hoststatus_id` int(11) NOT NULL auto_increment,
  `instance_id` smallint(6) NOT NULL default '0',
  `host_object_id` int(11) NOT NULL default '0',
  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `output` varchar(255) NOT NULL default '',
  `long_output` varchar(8192) NOT NULL default '',
  `perfdata` varchar(255) NOT NULL default '',
  `current_state` smallint(6) NOT NULL default '0',
  `has_been_checked`
Outras dicas deste autor

Acertando permissão do nagios.cmd

Adicionando módulo LTSP4.2 à árvore do kernel

Bloqueando tráfego via MAC com iptables

Renomeando Konsole

Suporte remoto com x11vnc

Leitura recomendada

Problema ao instalar o Enlightenment 17

Liberar root para acesso ao modo gráfico no Ubuntu

Acelerando o apt-get ou similares

Remover Chaveiro de Sessão no Debian 8.3 Jessie Cinnamon

WindowMaker - Dockando na marra

  

Comentários

Nenhum comentário foi encontrado.



Contribuir com comentário




Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner
Linux banner
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts