Resolvendo problema de Nagios + NPC

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

[ Hits: 7.294 ]

0 0

Denuncie Favoritos Indicar Impressora

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

Suporte remoto com VNC LTSP 4.2

Bloqueando tráfego via MAC com iptables

Perfis com uma pitada de tunning

Controle de acesso Squid + LTSP4.2

Limpando lixeira centralizada do Samba

Leitura recomendada

Xgl - Não apenas o GNOME, agora também o KDE!

Habilitando sudo no Debian 7

Customizando o Terminator com Solarized Color Scheme

Criando lançador (atalho) no GNOME 3 do Debian Wheezy

Hora certa no Debian