[icinga-devel] [PATCH] modified database_templates

mareadmin mail at mare-system.de
Mon May 18 23:29:18 CEST 2009


 module/idoutils/db/mysql2.sql | 1412 ++++++++++++++++++++++++++++++++++++++++
 module/idoutils/db/pgsql.sql  | 1420 +++++++++++++++++++++++++++++++++++++++++
 module/idoutils/db/sqlite.sql | 1273 ++++++++++++++++++++++++++++++++++++
 3 files changed, 4105 insertions(+), 0 deletions(-)
 create mode 100644 module/idoutils/db/mysql2.sql
 create mode 100644 module/idoutils/db/pgsql.sql
 create mode 100644 module/idoutils/db/sqlite.sql

diff --git a/module/idoutils/db/mysql2.sql b/module/idoutils/db/mysql2.sql
new file mode 100644
index 0000000..368fdf7
--- /dev/null
+++ b/module/idoutils/db/mysql2.sql
@@ -0,0 +1,1412 @@
+/*
+# mysql2.sql
+#   - modfied mysql.sql_template, let mysql choose the db_engine
+#   - int(6) && smallint() are now INTEGER
+#   - removed character set latin1
+#
+# mm/2009-05-18
+# 
+*/
+
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `icinga`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_acknowledgements`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_acknowledgements` (
+  `acknowledgement_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `entry_time_usec` INTEGER NOT NULL default '0',
+  `acknowledgement_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `author_name` varchar(64)  NOT NULL default '',
+  `comment_data` varchar(255)  NOT NULL default '',
+  `is_sticky` INTEGER NOT NULL default '0',
+  `persistent_comment` INTEGER NOT NULL default '0',
+  `notify_contacts` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`acknowledgement_id`)
+)  COMMENT='Current and historical host and service acknowledgements';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_commands`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_commands` (
+  `command_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER 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`)
+)   COMMENT='Command definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_commenthistory`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_commenthistory` (
+  `commenthistory_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `entry_time_usec` INTEGER NOT NULL default '0',
+  `comment_type` INTEGER NOT NULL default '0',
+  `entry_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `comment_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `internal_comment_id` INTEGER NOT NULL default '0',
+  `author_name` varchar(64)  NOT NULL default '',
+  `comment_data` varchar(255)  NOT NULL default '',
+  `is_persistent` INTEGER NOT NULL default '0',
+  `comment_source` INTEGER NOT NULL default '0',
+  `expires` INTEGER 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` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`commenthistory_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`comment_time`,`internal_comment_id`)
+)   COMMENT='Historical host and service comments';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_comments`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_comments` (
+  `comment_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `entry_time_usec` INTEGER NOT NULL default '0',
+  `comment_type` INTEGER NOT NULL default '0',
+  `entry_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `comment_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `internal_comment_id` INTEGER NOT NULL default '0',
+  `author_name` varchar(64)  NOT NULL default '',
+  `comment_data` varchar(255)  NOT NULL default '',
+  `is_persistent` INTEGER NOT NULL default '0',
+  `comment_source` INTEGER NOT NULL default '0',
+  `expires` INTEGER 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`)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_configfiles`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_configfiles` (
+  `configfile_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `configfile_type` INTEGER 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`)
+)   COMMENT='Configuration files';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_configfilevariables`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_configfilevariables` (
+  `configfilevariable_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `configfile_id` INTEGER NOT NULL default '0',
+  `varname` varchar(64)  NOT NULL default '',
+  `varvalue` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`configfilevariable_id`)
+)   COMMENT='Configuration file variables';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_conninfo`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_conninfo` (
+  `conninfo_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `lines_processed` INTEGER NOT NULL default '0',
+  `entries_processed` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`conninfo_id`)
+)   COMMENT='NDO2DB daemon connection information';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contactgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contactgroups` (
+  `contactgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `contactgroup_object_id` INTEGER 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`)
+)   COMMENT='Contactgroup definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contactgroup_members`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contactgroup_members` (
+  `contactgroup_member_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `contactgroup_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`contactgroup_member_id`),
+  UNIQUE KEY `instance_id` (`contactgroup_id`,`contact_object_id`)
+)   COMMENT='Contactgroup members';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contactnotificationmethods`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contactnotificationmethods` (
+  `contactnotificationmethod_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `contactnotification_id` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `command_object_id` INTEGER 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`)
+)   COMMENT='Historical record of contact notification methods';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contactnotifications`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contactnotifications` (
+  `contactnotification_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `notification_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`contactnotification_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`contact_object_id`,`start_time`,`start_time_usec`)
+)   COMMENT='Historical record of contact notifications';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contacts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contacts` (
+  `contact_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `service_timeperiod_object_id` INTEGER NOT NULL default '0',
+  `host_notifications_enabled` INTEGER NOT NULL default '0',
+  `service_notifications_enabled` INTEGER NOT NULL default '0',
+  `can_submit_commands` INTEGER NOT NULL default '0',
+  `notify_service_recovery` INTEGER NOT NULL default '0',
+  `notify_service_warning` INTEGER NOT NULL default '0',
+  `notify_service_unknown` INTEGER NOT NULL default '0',
+  `notify_service_critical` INTEGER NOT NULL default '0',
+  `notify_service_flapping` INTEGER NOT NULL default '0',
+  `notify_service_downtime` INTEGER NOT NULL default '0',
+  `notify_host_recovery` INTEGER NOT NULL default '0',
+  `notify_host_down` INTEGER NOT NULL default '0',
+  `notify_host_unreachable` INTEGER NOT NULL default '0',
+  `notify_host_flapping` INTEGER NOT NULL default '0',
+  `notify_host_downtime` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`contact_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`contact_object_id`)
+)   COMMENT='Contact definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contactstatus`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contactstatus` (
+  `contactstatus_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `host_notifications_enabled` INTEGER NOT NULL default '0',
+  `service_notifications_enabled` INTEGER 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` INTEGER NOT NULL default '0',
+  `modified_host_attributes` INTEGER NOT NULL default '0',
+  `modified_service_attributes` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`contactstatus_id`),
+  UNIQUE KEY `contact_object_id` (`contact_object_id`)
+)   COMMENT='Contact status';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contact_addresses`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contact_addresses` (
+  `contact_address_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `contact_id` INTEGER NOT NULL default '0',
+  `address_number` INTEGER NOT NULL default '0',
+  `address` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`contact_address_id`),
+  UNIQUE KEY `contact_id` (`contact_id`,`address_number`)
+)  COMMENT='Contact addresses';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_contact_notificationcommands`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_contact_notificationcommands` (
+  `contact_notificationcommand_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `contact_id` INTEGER NOT NULL default '0',
+  `notification_type` INTEGER NOT NULL default '0',
+  `command_object_id` INTEGER 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`)
+)   COMMENT='Contact host and service notification commands';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_customvariables`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_customvariables` (
+  `customvariable_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `has_been_modified` INTEGER 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`)
+)  COMMENT='Custom variables';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_customvariablestatus`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_customvariablestatus` (
+  `customvariablestatus_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `has_been_modified` INTEGER 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`)
+)  COMMENT='Custom variable status information';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_dbversion`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_dbversion` (
+  `name` varchar(10)  NOT NULL default '',
+  `version` varchar(10)  NOT NULL default ''
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_downtimehistory`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_downtimehistory` (
+  `downtimehistory_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `downtime_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `triggered_by_id` INTEGER NOT NULL default '0',
+  `is_fixed` INTEGER NOT NULL default '0',
+  `duration` INTEGER 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` INTEGER NOT NULL default '0',
+  `actual_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `actual_start_time_usec` INTEGER NOT NULL default '0',
+  `actual_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `actual_end_time_usec` INTEGER NOT NULL default '0',
+  `was_cancelled` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`downtimehistory_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`entry_time`,`internal_downtime_id`)
+)   COMMENT='Historical scheduled host and service downtime';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_eventhandlers`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_eventhandlers` (
+  `eventhandler_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `eventhandler_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `state_type` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `command_object_id` INTEGER NOT NULL default '0',
+  `command_args` varchar(255)  NOT NULL default '',
+  `command_line` varchar(255)  NOT NULL default '',
+  `timeout` INTEGER NOT NULL default '0',
+  `early_timeout` INTEGER NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `return_code` INTEGER NOT NULL default '0',
+  `output` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`eventhandler_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`start_time`,`start_time_usec`)
+)  COMMENT='Historical host and service event handlers';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_externalcommands`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_externalcommands` (
+  `externalcommand_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `command_type` INTEGER NOT NULL default '0',
+  `command_name` varchar(128)  NOT NULL default '',
+  `command_args` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`externalcommand_id`)
+)   COMMENT='Historical record of processed external commands';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_flappinghistory`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_flappinghistory` (
+  `flappinghistory_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `event_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `event_time_usec` INTEGER NOT NULL default '0',
+  `event_type` INTEGER NOT NULL default '0',
+  `reason_type` INTEGER NOT NULL default '0',
+  `flapping_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`flappinghistory_id`)
+)   COMMENT='Current and historical record of host and service flapping';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostchecks`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostchecks` (
+  `hostcheck_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  `check_type` INTEGER NOT NULL default '0',
+  `is_raw_check` INTEGER NOT NULL default '0',
+  `current_check_attempt` INTEGER NOT NULL default '0',
+  `max_check_attempts` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `state_type` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `command_object_id` INTEGER NOT NULL default '0',
+  `command_args` varchar(255)  NOT NULL default '',
+  `command_line` varchar(255)  NOT NULL default '',
+  `timeout` INTEGER NOT NULL default '0',
+  `early_timeout` INTEGER NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `latency` double NOT NULL default '0',
+  `return_code` INTEGER NOT NULL default '0',
+  `output` varchar(255)  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`)
+)   COMMENT='Historical host checks';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostdependencies`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostdependencies` (
+  `hostdependency_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  `dependent_host_object_id` INTEGER NOT NULL default '0',
+  `dependency_type` INTEGER NOT NULL default '0',
+  `inherits_parent` INTEGER NOT NULL default '0',
+  `timeperiod_object_id` INTEGER NOT NULL default '0',
+  `fail_on_up` INTEGER NOT NULL default '0',
+  `fail_on_down` INTEGER NOT NULL default '0',
+  `fail_on_unreachable` INTEGER 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`)
+)  COMMENT='Host dependency definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostescalations`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostescalations` (
+  `hostescalation_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  `timeperiod_object_id` INTEGER NOT NULL default '0',
+  `first_notification` INTEGER NOT NULL default '0',
+  `last_notification` INTEGER NOT NULL default '0',
+  `notification_interval` double NOT NULL default '0',
+  `escalate_on_recovery` INTEGER NOT NULL default '0',
+  `escalate_on_down` INTEGER NOT NULL default '0',
+  `escalate_on_unreachable` INTEGER 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`)
+)   COMMENT='Host escalation definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostescalation_contactgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostescalation_contactgroups` (
+  `hostescalation_contactgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `hostescalation_id` INTEGER NOT NULL default '0',
+  `contactgroup_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`hostescalation_contactgroup_id`),
+  UNIQUE KEY `instance_id` (`hostescalation_id`,`contactgroup_object_id`)
+)   COMMENT='Host escalation contact groups';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostescalation_contacts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostescalation_contacts` (
+  `hostescalation_contact_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `hostescalation_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`hostescalation_contact_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`hostescalation_id`,`contact_object_id`)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostgroups` (
+  `hostgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `hostgroup_object_id` INTEGER NOT NULL default '0',
+  `alias` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`hostgroup_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`hostgroup_object_id`)
+)   COMMENT='Hostgroup definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hostgroup_members`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hostgroup_members` (
+  `hostgroup_member_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `hostgroup_id` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`hostgroup_member_id`),
+  UNIQUE KEY `instance_id` (`hostgroup_id`,`host_object_id`)
+)   COMMENT='Hostgroup members';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hosts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hosts` (
+  `host_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `check_command_args` varchar(255)  NOT NULL default '',
+  `eventhandler_command_object_id` INTEGER NOT NULL default '0',
+  `eventhandler_command_args` varchar(255)  NOT NULL default '',
+  `notification_timeperiod_object_id` INTEGER NOT NULL default '0',
+  `check_timeperiod_object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `first_notification_delay` double NOT NULL default '0',
+  `notification_interval` double NOT NULL default '0',
+  `notify_on_down` INTEGER NOT NULL default '0',
+  `notify_on_unreachable` INTEGER NOT NULL default '0',
+  `notify_on_recovery` INTEGER NOT NULL default '0',
+  `notify_on_flapping` INTEGER NOT NULL default '0',
+  `notify_on_downtime` INTEGER NOT NULL default '0',
+  `stalk_on_up` INTEGER NOT NULL default '0',
+  `stalk_on_down` INTEGER NOT NULL default '0',
+  `stalk_on_unreachable` INTEGER NOT NULL default '0',
+  `flap_detection_enabled` INTEGER NOT NULL default '0',
+  `flap_detection_on_up` INTEGER NOT NULL default '0',
+  `flap_detection_on_down` INTEGER NOT NULL default '0',
+  `flap_detection_on_unreachable` INTEGER NOT NULL default '0',
+  `low_flap_threshold` double NOT NULL default '0',
+  `high_flap_threshold` double NOT NULL default '0',
+  `process_performance_data` INTEGER NOT NULL default '0',
+  `freshness_checks_enabled` INTEGER NOT NULL default '0',
+  `freshness_threshold` INTEGER NOT NULL default '0',
+  `passive_checks_enabled` INTEGER NOT NULL default '0',
+  `event_handler_enabled` INTEGER NOT NULL default '0',
+  `active_checks_enabled` INTEGER NOT NULL default '0',
+  `retain_status_information` INTEGER NOT NULL default '0',
+  `retain_nonstatus_information` INTEGER NOT NULL default '0',
+  `notifications_enabled` INTEGER NOT NULL default '0',
+  `obsess_over_host` INTEGER NOT NULL default '0',
+  `failure_prediction_enabled` INTEGER 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` INTEGER NOT NULL default '0',
+  `x_2d` INTEGER NOT NULL default '0',
+  `y_2d` INTEGER NOT NULL default '0',
+  `have_3d_coords` INTEGER 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`)
+)   COMMENT='Host definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_hoststatus`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_hoststatus` (
+  `hoststatus_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `output` varchar(255)  NOT NULL default '',
+  `perfdata` varchar(255)  NOT NULL default '',
+  `current_state` INTEGER NOT NULL default '0',
+  `has_been_checked` INTEGER NOT NULL default '0',
+  `should_be_scheduled` INTEGER NOT NULL default '0',
+  `current_check_attempt` INTEGER NOT NULL default '0',
+  `max_check_attempts` INTEGER NOT NULL default '0',
+  `last_check` datetime NOT NULL default '0000-00-00 00:00:00',
+  `next_check` datetime NOT NULL default '0000-00-00 00:00:00',
+  `check_type` INTEGER NOT NULL default '0',
+  `last_state_change` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_hard_state_change` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_hard_state` INTEGER NOT NULL default '0',
+  `last_time_up` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_time_down` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_time_unreachable` datetime NOT NULL default '0000-00-00 00:00:00',
+  `state_type` INTEGER NOT NULL default '0',
+  `last_notification` datetime NOT NULL default '0000-00-00 00:00:00',
+  `next_notification` datetime NOT NULL default '0000-00-00 00:00:00',
+  `no_more_notifications` INTEGER NOT NULL default '0',
+  `notifications_enabled` INTEGER NOT NULL default '0',
+  `problem_has_been_acknowledged` INTEGER NOT NULL default '0',
+  `acknowledgement_type` INTEGER NOT NULL default '0',
+  `current_notification_number` INTEGER NOT NULL default '0',
+  `passive_checks_enabled` INTEGER NOT NULL default '0',
+  `active_checks_enabled` INTEGER NOT NULL default '0',
+  `event_handler_enabled` INTEGER NOT NULL default '0',
+  `flap_detection_enabled` INTEGER NOT NULL default '0',
+  `is_flapping` INTEGER NOT NULL default '0',
+  `percent_state_change` double NOT NULL default '0',
+  `latency` double NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `scheduled_downtime_depth` INTEGER NOT NULL default '0',
+  `failure_prediction_enabled` INTEGER NOT NULL default '0',
+  `process_performance_data` INTEGER NOT NULL default '0',
+  `obsess_over_host` INTEGER NOT NULL default '0',
+  `modified_host_attributes` INTEGER NOT NULL default '0',
+  `event_handler` varchar(255)  NOT NULL default '',
+  `check_command` varchar(255)  NOT NULL default '',
+  `normal_check_interval` double NOT NULL default '0',
+  `retry_check_interval` double NOT NULL default '0',
+  `check_timeperiod_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`hoststatus_id`),
+  UNIQUE KEY `object_id` (`host_object_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `status_update_time` (`status_update_time`),
+  KEY `current_state` (`current_state`),
+  KEY `check_type` (`check_type`),
+  KEY `state_type` (`state_type`),
+  KEY `last_state_change` (`last_state_change`),
+  KEY `notifications_enabled` (`notifications_enabled`),
+  KEY `problem_has_been_acknowledged` (`problem_has_been_acknowledged`),
+  KEY `active_checks_enabled` (`active_checks_enabled`),
+  KEY `passive_checks_enabled` (`passive_checks_enabled`),
+  KEY `event_handler_enabled` (`event_handler_enabled`),
+  KEY `flap_detection_enabled` (`flap_detection_enabled`),
+  KEY `is_flapping` (`is_flapping`),
+  KEY `percent_state_change` (`percent_state_change`),
+  KEY `latency` (`latency`),
+  KEY `execution_time` (`execution_time`),
+  KEY `scheduled_downtime_depth` (`scheduled_downtime_depth`)
+)   COMMENT='Current host status information';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_host_contactgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_host_contactgroups` (
+  `host_contactgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `host_id` INTEGER NOT NULL default '0',
+  `contactgroup_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`host_contactgroup_id`),
+  UNIQUE KEY `instance_id` (`host_id`,`contactgroup_object_id`)
+)   COMMENT='Host contact groups';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_host_contacts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_host_contacts` (
+  `host_contact_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `host_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`host_contact_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`host_id`,`contact_object_id`)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_host_parenthosts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_host_parenthosts` (
+  `host_parenthost_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `host_id` INTEGER NOT NULL default '0',
+  `parent_host_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`host_parenthost_id`),
+  UNIQUE KEY `instance_id` (`host_id`,`parent_host_object_id`)
+)   COMMENT='Parent hosts';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_instances`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_instances` (
+  `instance_id` INTEGER NOT NULL auto_increment,
+  `instance_name` varchar(64)  NOT NULL default '',
+  `instance_description` varchar(128)  NOT NULL default '',
+  PRIMARY KEY  (`instance_id`)
+)   COMMENT='Location names of various Icinga installations';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_logentries`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_logentries` (
+  `logentry_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `logentry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `entry_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `entry_time_usec` INTEGER NOT NULL default '0',
+  `logentry_type` INTEGER NOT NULL default '0',
+  `logentry_data` varchar(255)  NOT NULL default '',
+  `realtime_data` INTEGER NOT NULL default '0',
+  `inferred_data_extracted` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`logentry_id`)
+)  COMMENT='Historical record of log entries';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_notifications`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_notifications` (
+  `notification_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `notification_type` INTEGER NOT NULL default '0',
+  `notification_reason` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `output` varchar(255)  NOT NULL default '',
+  `escalated` INTEGER NOT NULL default '0',
+  `contacts_notified` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`notification_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`start_time`,`start_time_usec`)
+)   COMMENT='Historical record of host and service notifications';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_objects`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_objects` (
+  `object_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `objecttype_id` INTEGER NOT NULL default '0',
+  `name1` varchar(128)  NOT NULL default '',
+  `name2` varchar(128)  default NULL,
+  `is_active` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`object_id`),
+  KEY `objecttype_id` (`objecttype_id`,`name1`,`name2`)
+)   COMMENT='Current and historical objects of all kinds';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_processevents`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_processevents` (
+  `processevent_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `event_type` INTEGER NOT NULL default '0',
+  `event_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `event_time_usec` INTEGER NOT NULL default '0',
+  `process_id` INTEGER NOT NULL default '0',
+  `program_name` varchar(16)  NOT NULL default '',
+  `program_version` varchar(20)  NOT NULL default '',
+  `program_date` varchar(10)  NOT NULL default '',
+  PRIMARY KEY  (`processevent_id`)
+)   COMMENT='Historical Icinga process events';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_programstatus`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_programstatus` (
+  `programstatus_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `program_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `program_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `is_currently_running` INTEGER NOT NULL default '0',
+  `process_id` INTEGER NOT NULL default '0',
+  `daemon_mode` INTEGER NOT NULL default '0',
+  `last_command_check` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_log_rotation` datetime NOT NULL default '0000-00-00 00:00:00',
+  `notifications_enabled` INTEGER NOT NULL default '0',
+  `active_service_checks_enabled` INTEGER NOT NULL default '0',
+  `passive_service_checks_enabled` INTEGER NOT NULL default '0',
+  `active_host_checks_enabled` INTEGER NOT NULL default '0',
+  `passive_host_checks_enabled` INTEGER NOT NULL default '0',
+  `event_handlers_enabled` INTEGER NOT NULL default '0',
+  `flap_detection_enabled` INTEGER NOT NULL default '0',
+  `failure_prediction_enabled` INTEGER NOT NULL default '0',
+  `process_performance_data` INTEGER NOT NULL default '0',
+  `obsess_over_hosts` INTEGER NOT NULL default '0',
+  `obsess_over_services` INTEGER NOT NULL default '0',
+  `modified_host_attributes` INTEGER NOT NULL default '0',
+  `modified_service_attributes` INTEGER NOT NULL default '0',
+  `global_host_event_handler` varchar(255)  NOT NULL default '',
+  `global_service_event_handler` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`programstatus_id`),
+  UNIQUE KEY `instance_id` (`instance_id`)
+)   COMMENT='Current program status information';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_runtimevariables`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_runtimevariables` (
+  `runtimevariable_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `varname` varchar(64)  NOT NULL default '',
+  `varvalue` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`runtimevariable_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`varname`)
+)   COMMENT='Runtime variables from the Icinga daemon';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_scheduleddowntime`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_scheduleddowntime` (
+  `scheduleddowntime_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `downtime_type` INTEGER NOT NULL default '0',
+  `object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `triggered_by_id` INTEGER NOT NULL default '0',
+  `is_fixed` INTEGER NOT NULL default '0',
+  `duration` INTEGER 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` INTEGER NOT NULL default '0',
+  `actual_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `actual_start_time_usec` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`scheduleddowntime_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`entry_time`,`internal_downtime_id`)
+)  COMMENT='Current scheduled host and service downtime';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_servicechecks`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_servicechecks` (
+  `servicecheck_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  `check_type` INTEGER NOT NULL default '0',
+  `current_check_attempt` INTEGER NOT NULL default '0',
+  `max_check_attempts` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `state_type` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `command_object_id` INTEGER NOT NULL default '0',
+  `command_args` varchar(255)  NOT NULL default '',
+  `command_line` varchar(255)  NOT NULL default '',
+  `timeout` INTEGER NOT NULL default '0',
+  `early_timeout` INTEGER NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `latency` double NOT NULL default '0',
+  `return_code` INTEGER NOT NULL default '0',
+  `output` varchar(255)  NOT NULL default '',
+  `perfdata` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`servicecheck_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `service_object_id` (`service_object_id`),
+  KEY `start_time` (`start_time`)
+)   COMMENT='Historical service checks';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_servicedependencies`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_servicedependencies` (
+  `servicedependency_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  `dependent_service_object_id` INTEGER NOT NULL default '0',
+  `dependency_type` INTEGER NOT NULL default '0',
+  `inherits_parent` INTEGER NOT NULL default '0',
+  `timeperiod_object_id` INTEGER NOT NULL default '0',
+  `fail_on_ok` INTEGER NOT NULL default '0',
+  `fail_on_warning` INTEGER NOT NULL default '0',
+  `fail_on_unknown` INTEGER NOT NULL default '0',
+  `fail_on_critical` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`servicedependency_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`service_object_id`,`dependent_service_object_id`,`dependency_type`,`inherits_parent`,`fail_on_ok`,`fail_on_warning`,`fail_on_unknown`,`fail_on_critical`)
+)  COMMENT='Service dependency definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_serviceescalations`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_serviceescalations` (
+  `serviceescalation_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  `timeperiod_object_id` INTEGER NOT NULL default '0',
+  `first_notification` INTEGER NOT NULL default '0',
+  `last_notification` INTEGER NOT NULL default '0',
+  `notification_interval` double NOT NULL default '0',
+  `escalate_on_recovery` INTEGER NOT NULL default '0',
+  `escalate_on_warning` INTEGER NOT NULL default '0',
+  `escalate_on_unknown` INTEGER NOT NULL default '0',
+  `escalate_on_critical` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`serviceescalation_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`service_object_id`,`timeperiod_object_id`,`first_notification`,`last_notification`)
+)   COMMENT='Service escalation definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_serviceescalation_contactgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_serviceescalation_contactgroups` (
+  `serviceescalation_contactgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `serviceescalation_id` INTEGER NOT NULL default '0',
+  `contactgroup_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`serviceescalation_contactgroup_id`),
+  UNIQUE KEY `instance_id` (`serviceescalation_id`,`contactgroup_object_id`)
+)   COMMENT='Service escalation contact groups';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_serviceescalation_contacts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_serviceescalation_contacts` (
+  `serviceescalation_contact_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `serviceescalation_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`serviceescalation_contact_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`serviceescalation_id`,`contact_object_id`)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_servicegroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_servicegroups` (
+  `servicegroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `servicegroup_object_id` INTEGER NOT NULL default '0',
+  `alias` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`servicegroup_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`servicegroup_object_id`)
+)   COMMENT='Servicegroup definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_servicegroup_members`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_servicegroup_members` (
+  `servicegroup_member_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `servicegroup_id` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`servicegroup_member_id`),
+  UNIQUE KEY `instance_id` (`servicegroup_id`,`service_object_id`)
+)   COMMENT='Servicegroup members';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_services`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_services` (
+  `service_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `host_object_id` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  `display_name` varchar(64)  NOT NULL default '',
+  `check_command_object_id` INTEGER NOT NULL default '0',
+  `check_command_args` varchar(255)  NOT NULL default '',
+  `eventhandler_command_object_id` INTEGER NOT NULL default '0',
+  `eventhandler_command_args` varchar(255)  NOT NULL default '',
+  `notification_timeperiod_object_id` INTEGER NOT NULL default '0',
+  `check_timeperiod_object_id` INTEGER 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` INTEGER NOT NULL default '0',
+  `first_notification_delay` double NOT NULL default '0',
+  `notification_interval` double NOT NULL default '0',
+  `notify_on_warning` INTEGER NOT NULL default '0',
+  `notify_on_unknown` INTEGER NOT NULL default '0',
+  `notify_on_critical` INTEGER NOT NULL default '0',
+  `notify_on_recovery` INTEGER NOT NULL default '0',
+  `notify_on_flapping` INTEGER NOT NULL default '0',
+  `notify_on_downtime` INTEGER NOT NULL default '0',
+  `stalk_on_ok` INTEGER NOT NULL default '0',
+  `stalk_on_warning` INTEGER NOT NULL default '0',
+  `stalk_on_unknown` INTEGER NOT NULL default '0',
+  `stalk_on_critical` INTEGER NOT NULL default '0',
+  `is_volatile` INTEGER NOT NULL default '0',
+  `flap_detection_enabled` INTEGER NOT NULL default '0',
+  `flap_detection_on_ok` INTEGER NOT NULL default '0',
+  `flap_detection_on_warning` INTEGER NOT NULL default '0',
+  `flap_detection_on_unknown` INTEGER NOT NULL default '0',
+  `flap_detection_on_critical` INTEGER NOT NULL default '0',
+  `low_flap_threshold` double NOT NULL default '0',
+  `high_flap_threshold` double NOT NULL default '0',
+  `process_performance_data` INTEGER NOT NULL default '0',
+  `freshness_checks_enabled` INTEGER NOT NULL default '0',
+  `freshness_threshold` INTEGER NOT NULL default '0',
+  `passive_checks_enabled` INTEGER NOT NULL default '0',
+  `event_handler_enabled` INTEGER NOT NULL default '0',
+  `active_checks_enabled` INTEGER NOT NULL default '0',
+  `retain_status_information` INTEGER NOT NULL default '0',
+  `retain_nonstatus_information` INTEGER NOT NULL default '0',
+  `notifications_enabled` INTEGER NOT NULL default '0',
+  `obsess_over_service` INTEGER NOT NULL default '0',
+  `failure_prediction_enabled` INTEGER 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 '',
+  PRIMARY KEY  (`service_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`service_object_id`),
+  KEY `service_object_id` (`service_object_id`)
+)   COMMENT='Service definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_servicestatus`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_servicestatus` (
+  `servicestatus_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `service_object_id` INTEGER NOT NULL default '0',
+  `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `output` varchar(255)  NOT NULL default '',
+  `perfdata` varchar(255)  NOT NULL default '',
+  `current_state` INTEGER NOT NULL default '0',
+  `has_been_checked` INTEGER NOT NULL default '0',
+  `should_be_scheduled` INTEGER NOT NULL default '0',
+  `current_check_attempt` INTEGER NOT NULL default '0',
+  `max_check_attempts` INTEGER NOT NULL default '0',
+  `last_check` datetime NOT NULL default '0000-00-00 00:00:00',
+  `next_check` datetime NOT NULL default '0000-00-00 00:00:00',
+  `check_type` INTEGER NOT NULL default '0',
+  `last_state_change` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_hard_state_change` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_hard_state` INTEGER NOT NULL default '0',
+  `last_time_ok` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_time_warning` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_time_unknown` datetime NOT NULL default '0000-00-00 00:00:00',
+  `last_time_critical` datetime NOT NULL default '0000-00-00 00:00:00',
+  `state_type` INTEGER NOT NULL default '0',
+  `last_notification` datetime NOT NULL default '0000-00-00 00:00:00',
+  `next_notification` datetime NOT NULL default '0000-00-00 00:00:00',
+  `no_more_notifications` INTEGER NOT NULL default '0',
+  `notifications_enabled` INTEGER NOT NULL default '0',
+  `problem_has_been_acknowledged` INTEGER NOT NULL default '0',
+  `acknowledgement_type` INTEGER NOT NULL default '0',
+  `current_notification_number` INTEGER NOT NULL default '0',
+  `passive_checks_enabled` INTEGER NOT NULL default '0',
+  `active_checks_enabled` INTEGER NOT NULL default '0',
+  `event_handler_enabled` INTEGER NOT NULL default '0',
+  `flap_detection_enabled` INTEGER NOT NULL default '0',
+  `is_flapping` INTEGER NOT NULL default '0',
+  `percent_state_change` double NOT NULL default '0',
+  `latency` double NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `scheduled_downtime_depth` INTEGER NOT NULL default '0',
+  `failure_prediction_enabled` INTEGER NOT NULL default '0',
+  `process_performance_data` INTEGER NOT NULL default '0',
+  `obsess_over_service` INTEGER NOT NULL default '0',
+  `modified_service_attributes` INTEGER NOT NULL default '0',
+  `event_handler` varchar(255)  NOT NULL default '',
+  `check_command` varchar(255)  NOT NULL default '',
+  `normal_check_interval` double NOT NULL default '0',
+  `retry_check_interval` double NOT NULL default '0',
+  `check_timeperiod_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`servicestatus_id`),
+  UNIQUE KEY `object_id` (`service_object_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `status_update_time` (`status_update_time`),
+  KEY `current_state` (`current_state`),
+  KEY `check_type` (`check_type`),
+  KEY `state_type` (`state_type`),
+  KEY `last_state_change` (`last_state_change`),
+  KEY `notifications_enabled` (`notifications_enabled`),
+  KEY `problem_has_been_acknowledged` (`problem_has_been_acknowledged`),
+  KEY `active_checks_enabled` (`active_checks_enabled`),
+  KEY `passive_checks_enabled` (`passive_checks_enabled`),
+  KEY `event_handler_enabled` (`event_handler_enabled`),
+  KEY `flap_detection_enabled` (`flap_detection_enabled`),
+  KEY `is_flapping` (`is_flapping`),
+  KEY `percent_state_change` (`percent_state_change`),
+  KEY `latency` (`latency`),
+  KEY `execution_time` (`execution_time`),
+  KEY `scheduled_downtime_depth` (`scheduled_downtime_depth`)
+)   COMMENT='Current service status information';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_service_contactgroups`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_service_contactgroups` (
+  `service_contactgroup_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `service_id` INTEGER NOT NULL default '0',
+  `contactgroup_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`service_contactgroup_id`),
+  UNIQUE KEY `instance_id` (`service_id`,`contactgroup_object_id`)
+)   COMMENT='Service contact groups';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_service_contacts`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_service_contacts` (
+  `service_contact_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `service_id` INTEGER NOT NULL default '0',
+  `contact_object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`service_contact_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`service_id`,`contact_object_id`)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_statehistory`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_statehistory` (
+  `statehistory_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `state_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `state_time_usec` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `state_change` INTEGER NOT NULL default '0',
+  `state` INTEGER NOT NULL default '0',
+  `state_type` INTEGER NOT NULL default '0',
+  `current_check_attempt` INTEGER NOT NULL default '0',
+  `max_check_attempts` INTEGER NOT NULL default '0',
+  `last_state` INTEGER NOT NULL default '-1',
+  `last_hard_state` INTEGER NOT NULL default '-1',
+  `output` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`statehistory_id`)
+)  COMMENT='Historical host and service state changes';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_systemcommands`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_systemcommands` (
+  `systemcommand_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `start_time_usec` INTEGER NOT NULL default '0',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time_usec` INTEGER NOT NULL default '0',
+  `command_line` varchar(255)  NOT NULL default '',
+  `timeout` INTEGER NOT NULL default '0',
+  `early_timeout` INTEGER NOT NULL default '0',
+  `execution_time` double NOT NULL default '0',
+  `return_code` INTEGER NOT NULL default '0',
+  `output` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`systemcommand_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `start_time` (`start_time`)
+)   COMMENT='Historical system commands that are executed';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_timedeventqueue`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_timedeventqueue` (
+  `timedeventqueue_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `event_type` INTEGER NOT NULL default '0',
+  `queued_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `queued_time_usec` INTEGER NOT NULL default '0',
+  `scheduled_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `recurring_event` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`timedeventqueue_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `event_type` (`event_type`),
+  KEY `scheduled_time` (`scheduled_time`),
+  KEY `object_id` (`object_id`)
+)   COMMENT='Current Icinga event queue';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_timedevents`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_timedevents` (
+  `timedevent_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `event_type` INTEGER NOT NULL default '0',
+  `queued_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `queued_time_usec` INTEGER NOT NULL default '0',
+  `event_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `event_time_usec` INTEGER NOT NULL default '0',
+  `scheduled_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `recurring_event` INTEGER NOT NULL default '0',
+  `object_id` INTEGER NOT NULL default '0',
+  `deletion_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `deletion_time_usec` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`timedevent_id`),
+  KEY `instance_id` (`instance_id`),
+  KEY `event_type` (`event_type`),
+  KEY `scheduled_time` (`scheduled_time`),
+  KEY `object_id` (`object_id`)
+)   COMMENT='Historical events from the Icinga event queue';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_timeperiods`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_timeperiods` (
+  `timeperiod_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `config_type` INTEGER NOT NULL default '0',
+  `timeperiod_object_id` INTEGER NOT NULL default '0',
+  `alias` varchar(255)  NOT NULL default '',
+  PRIMARY KEY  (`timeperiod_id`),
+  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`timeperiod_object_id`)
+)   COMMENT='Timeperiod definitions';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `icinga_timeperiod_timeranges`
+--
+
+CREATE TABLE IF NOT EXISTS `icinga_timeperiod_timeranges` (
+  `timeperiod_timerange_id` INTEGER NOT NULL auto_increment,
+  `instance_id` INTEGER NOT NULL default '0',
+  `timeperiod_id` INTEGER NOT NULL default '0',
+  `day` INTEGER NOT NULL default '0',
+  `start_sec` INTEGER NOT NULL default '0',
+  `end_sec` INTEGER NOT NULL default '0',
+  PRIMARY KEY  (`timeperiod_timerange_id`),
+  UNIQUE KEY `instance_id` (`timeperiod_id`,`day`,`start_sec`,`end_sec`)
+)   COMMENT='Timeperiod definitions';
diff --git a/module/idoutils/db/pgsql.sql b/module/idoutils/db/pgsql.sql
new file mode 100644
index 0000000..8c24e8d
--- /dev/null
+++ b/module/idoutils/db/pgsql.sql
@@ -0,0 +1,1420 @@
+/*
+# pgsql.sql
+#   - modfied mysql.sql to work with postgres 
+#
+# mm/2009-05-13
+# 
+#-----------------------------------------------------
+# database installation instructions
+# 
+# as user postgres: 
+# 
+# postgres=# CREATE USER icingauser;
+# postgres=# CREATE DATABASE icinga;
+# 
+# ph_hba.conf 
+#
+# local   icinga      icingauser                        trust
+#
+#/etc/init.d/postgresql-8.3 reload
+#
+# psql -U icinga < pgsql.sql  
+#
+#
+*/
+
+
+
+--
+-- Database: icinga
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_acknowledgements
+--
+
+CREATE TABLE  icinga_acknowledgements (
+  acknowledgement_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER NOT NULL default '0',
+  acknowledgement_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  author_name varchar(64) character set latin1 NOT NULL default '',
+  comment_data varchar(255) character set latin1 NOT NULL default '',
+  is_sticky INTEGER NOT NULL default '0',
+  persistent_comment INTEGER NOT NULL default '0',
+  notify_contacts INTEGER NOT NULL default '0',
+  PRIMARY KEY  (acknowledgement_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_commands
+--
+
+CREATE TABLE  icinga_commands (
+  command_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  command_line varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (command_id),
+  UNIQUE (instance_id,object_id,config_type)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_commenthistory
+--
+
+CREATE TABLE  icinga_commenthistory (
+  commenthistory_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER NOT NULL default '0',
+  comment_type INTEGER NOT NULL default '0',
+  entry_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  comment_time datetime NOT NULL default '0000-00-00 00:00:00',
+  internal_comment_id INTEGER NOT NULL default '0',
+  author_name varchar(64) character set latin1 NOT NULL default '',
+  comment_data varchar(255) character set latin1 NOT NULL default '',
+  is_persistent INTEGER NOT NULL default '0',
+  comment_source INTEGER NOT NULL default '0',
+  expires INTEGER 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 INTEGER NOT NULL default '0',
+  PRIMARY KEY  (commenthistory_id),
+  UNIQUE (instance_id,comment_time,internal_comment_id)
+);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_comments
+--
+
+CREATE TABLE  icinga_comments (
+  comment_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER NOT NULL default '0',
+  comment_type INTEGER NOT NULL default '0',
+  entry_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  comment_time datetime NOT NULL default '0000-00-00 00:00:00',
+  internal_comment_id INTEGER NOT NULL default '0',
+  author_name varchar(64) character set latin1 NOT NULL default '',
+  comment_data varchar(255) character set latin1 NOT NULL default '',
+  is_persistent INTEGER NOT NULL default '0',
+  comment_source INTEGER NOT NULL default '0',
+  expires INTEGER NOT NULL default '0',
+  expiration_time datetime NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (comment_id),
+  UNIQUE (instance_id,comment_time,internal_comment_id)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_configfiles
+--
+
+CREATE TABLE  icinga_configfiles (
+  configfile_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  configfile_type INTEGER NOT NULL default '0',
+  configfile_path varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (configfile_id),
+  UNIQUE (instance_id,configfile_type,configfile_path)
+);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_configfilevariables
+--
+
+CREATE TABLE  icinga_configfilevariables (
+  configfilevariable_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  configfile_id INTEGER NOT NULL default '0',
+  varname varchar(64) character set latin1 NOT NULL default '',
+  varvalue varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (configfilevariable_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_conninfo
+--
+
+CREATE TABLE  icinga_conninfo (
+  conninfo_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  agent_name varchar(32) character set latin1 NOT NULL default '',
+  agent_version varchar(8) character set latin1 NOT NULL default '',
+  disposition varchar(16) character set latin1 NOT NULL default '',
+  connect_source varchar(16) character set latin1 NOT NULL default '',
+  connect_type varchar(16) character set latin1 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 INTEGER NOT NULL default '0',
+  lines_processed INTEGER NOT NULL default '0',
+  entries_processed INTEGER NOT NULL default '0',
+  PRIMARY KEY  (conninfo_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactgroups
+--
+
+CREATE TABLE  icinga_contactgroups (
+  contactgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  contactgroup_object_id INTEGER NOT NULL default '0',
+  alias varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (contactgroup_id),
+  UNIQUE (instance_id,config_type,contactgroup_object_id)
+);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactgroup_members
+--
+
+CREATE TABLE  icinga_contactgroup_members (
+  contactgroup_member_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  contactgroup_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (contactgroup_member_id),
+  UNIQUE (contactgroup_id,contact_object_id)
+);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactnotificationmethods
+--
+
+CREATE TABLE  icinga_contactnotificationmethods (
+  contactnotificationmethod_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  contactnotification_id INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  command_object_id INTEGER NOT NULL default '0',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (contactnotificationmethod_id),
+  UNIQUE (instance_id,contactnotification_id,start_time,start_time_usec)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactnotifications
+--
+
+CREATE TABLE  icinga_contactnotifications (
+  contactnotification_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  notification_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  PRIMARY KEY  (contactnotification_id),
+  UNIQUE (instance_id,contact_object_id,start_time,start_time_usec)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contacts
+--
+
+CREATE TABLE  icinga_contacts (
+  contact_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  alias varchar(64) character set latin1 NOT NULL default '',
+  email_address varchar(255) character set latin1 NOT NULL default '',
+  pager_address varchar(64) character set latin1 NOT NULL default '',
+  host_timeperiod_object_id INTEGER NOT NULL default '0',
+  service_timeperiod_object_id INTEGER NOT NULL default '0',
+  host_notifications_enabled INTEGER NOT NULL default '0',
+  service_notifications_enabled INTEGER NOT NULL default '0',
+  can_submit_commands INTEGER NOT NULL default '0',
+  notify_service_recovery INTEGER NOT NULL default '0',
+  notify_service_warning INTEGER NOT NULL default '0',
+  notify_service_unknown INTEGER NOT NULL default '0',
+  notify_service_critical INTEGER NOT NULL default '0',
+  notify_service_flapping INTEGER NOT NULL default '0',
+  notify_service_downtime INTEGER NOT NULL default '0',
+  notify_host_recovery INTEGER NOT NULL default '0',
+  notify_host_down INTEGER NOT NULL default '0',
+  notify_host_unreachable INTEGER NOT NULL default '0',
+  notify_host_flapping INTEGER NOT NULL default '0',
+  notify_host_downtime INTEGER NOT NULL default '0',
+  PRIMARY KEY  (contact_id),
+  UNIQUE (instance_id,config_type,contact_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactstatus
+--
+
+CREATE TABLE  icinga_contactstatus (
+  contactstatus_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  status_update_time datetime NOT NULL default '0000-00-00 00:00:00',
+  host_notifications_enabled INTEGER NOT NULL default '0',
+  service_notifications_enabled INTEGER 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 INTEGER NOT NULL default '0',
+  modified_host_attributes INTEGER NOT NULL default '0',
+  modified_service_attributes INTEGER NOT NULL default '0',
+  PRIMARY KEY  (contactstatus_id),
+  UNIQUE  (contact_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contact_addresses
+--
+
+CREATE TABLE  icinga_contact_addresses (
+  contact_address_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  contact_id INTEGER NOT NULL default '0',
+  address_number INTEGER NOT NULL default '0',
+  address varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (contact_address_id),
+  UNIQUE  (contact_id,address_number)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contact_notificationcommands
+--
+
+CREATE TABLE  icinga_contact_notificationcommands (
+  contact_notificationcommand_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  contact_id INTEGER NOT NULL default '0',
+  notification_type INTEGER NOT NULL default '0',
+  command_object_id INTEGER NOT NULL default '0',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (contact_notificationcommand_id),
+  UNIQUE  (contact_id,notification_type,command_object_id,command_args)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_customvariables
+--
+
+CREATE TABLE  icinga_customvariables (
+  customvariable_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  has_been_modified INTEGER NOT NULL default '0',
+  varname varchar(255) character set latin1 NOT NULL default '',
+  varvalue varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (customvariable_id),
+  UNIQUE  (object_id,config_type,varname),
+  UNIQUE (varname)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_customvariablestatus
+--
+
+CREATE TABLE  icinga_customvariablestatus (
+  customvariablestatus_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  status_update_time datetime NOT NULL default '0000-00-00 00:00:00',
+  has_been_modified INTEGER NOT NULL default '0',
+  varname varchar(255) character set latin1 NOT NULL default '',
+  varvalue varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (customvariablestatus_id),
+  UNIQUE (object_id,varname),
+  UNIQUE (varname)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_dbversion
+--
+
+CREATE TABLE  icinga_dbversion (
+  name varchar(10) character set latin1 NOT NULL default '',
+  version varchar(10) character set latin1 NOT NULL default ''
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_downtimehistory
+--
+
+CREATE TABLE  icinga_downtimehistory (
+  downtimehistory_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  downtime_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  author_name varchar(64) character set latin1 NOT NULL default '',
+  comment_data varchar(255) character set latin1 NOT NULL default '',
+  internal_downtime_id INTEGER NOT NULL default '0',
+  triggered_by_id INTEGER NOT NULL default '0',
+  is_fixed INTEGER NOT NULL default '0',
+  duration INTEGER 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 INTEGER NOT NULL default '0',
+  actual_start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  actual_start_time_usec INTEGER NOT NULL default '0',
+  actual_end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  actual_end_time_usec INTEGER NOT NULL default '0',
+  was_cancelled INTEGER NOT NULL default '0',
+  PRIMARY KEY  (downtimehistory_id),
+  UNIQUE (instance_id,object_id,entry_time,internal_downtime_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_eventhandlers
+--
+
+CREATE TABLE  icinga_eventhandlers (
+  eventhandler_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  eventhandler_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  state_type INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  command_object_id INTEGER NOT NULL default '0',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  command_line varchar(255) character set latin1 NOT NULL default '',
+  timeout INTEGER NOT NULL default '0',
+  early_timeout INTEGER NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  return_code INTEGER NOT NULL default '0',
+  output varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (eventhandler_id),
+  UNIQUE (instance_id,object_id,start_time,start_time_usec)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_externalcommands
+--
+
+CREATE TABLE  icinga_externalcommands (
+  externalcommand_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  command_type INTEGER NOT NULL default '0',
+  command_name varchar(128) character set latin1 NOT NULL default '',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (externalcommand_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_flappinghistory
+--
+
+CREATE TABLE  icinga_flappinghistory (
+  flappinghistory_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  event_time datetime NOT NULL default '0000-00-00 00:00:00',
+  event_time_usec INTEGER NOT NULL default '0',
+  event_type INTEGER NOT NULL default '0',
+  reason_type INTEGER NOT NULL default '0',
+  flapping_type INTEGER NOT NULL default '0',
+  object_id INTEGER 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 INTEGER NOT NULL default '0',
+  PRIMARY KEY  (flappinghistory_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostchecks
+--
+
+CREATE TABLE  icinga_hostchecks (
+  hostcheck_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  check_type INTEGER NOT NULL default '0',
+  is_raw_check INTEGER NOT NULL default '0',
+  current_check_attempt INTEGER NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  state_type INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  command_object_id INTEGER NOT NULL default '0',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  command_line varchar(255) character set latin1 NOT NULL default '',
+  timeout INTEGER NOT NULL default '0',
+  early_timeout INTEGER NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  latency double NOT NULL default '0',
+  return_code INTEGER NOT NULL default '0',
+  output varchar(255) character set latin1 NOT NULL default '',
+  perfdata varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (hostcheck_id),
+  UNIQUE (instance_id,host_object_id,start_time,start_time_usec)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostdependencies
+--
+
+CREATE TABLE  icinga_hostdependencies (
+  hostdependency_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  dependent_host_object_id INTEGER NOT NULL default '0',
+  dependency_type INTEGER NOT NULL default '0',
+  inherits_parent INTEGER NOT NULL default '0',
+  timeperiod_object_id INTEGER NOT NULL default '0',
+  fail_on_up INTEGER NOT NULL default '0',
+  fail_on_down INTEGER NOT NULL default '0',
+  fail_on_unreachable INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hostdependency_id),
+  UNIQUE (instance_id,config_type,host_object_id,dependent_host_object_id,dependency_type,inherits_parent,fail_on_up,fail_on_down,fail_on_unreachable)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalations
+--
+
+CREATE TABLE  icinga_hostescalations (
+  hostescalation_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  timeperiod_object_id INTEGER NOT NULL default '0',
+  first_notification INTEGER NOT NULL default '0',
+  last_notification INTEGER NOT NULL default '0',
+  notification_interval double NOT NULL default '0',
+  escalate_on_recovery INTEGER NOT NULL default '0',
+  escalate_on_down INTEGER NOT NULL default '0',
+  escalate_on_unreachable INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hostescalation_id),
+  UNIQUE (instance_id,config_type,host_object_id,timeperiod_object_id,first_notification,last_notification)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalation_contactgroups
+--
+
+CREATE TABLE  icinga_hostescalation_contactgroups (
+  hostescalation_contactgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  hostescalation_id INTEGER NOT NULL default '0',
+  contactgroup_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hostescalation_contactgroup_id),
+  UNIQUE (hostescalation_id,contactgroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalation_contacts
+--
+
+CREATE TABLE  icinga_hostescalation_contacts (
+  hostescalation_contact_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  hostescalation_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hostescalation_contact_id),
+  UNIQUE (instance_id,hostescalation_id,contact_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostgroups
+--
+
+CREATE TABLE  icinga_hostgroups (
+  hostgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  hostgroup_object_id INTEGER NOT NULL default '0',
+  alias varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (hostgroup_id),
+  UNIQUE (instance_id,hostgroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostgroup_members
+--
+
+CREATE TABLE  icinga_hostgroup_members (
+  hostgroup_member_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  hostgroup_id INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hostgroup_member_id),
+  UNIQUE (hostgroup_id,host_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hosts
+--
+
+CREATE TABLE  icinga_hosts (
+  host_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  alias varchar(64) character set latin1 NOT NULL default '',
+  display_name varchar(64) character set latin1 NOT NULL default '',
+  address varchar(128) character set latin1 NOT NULL default '',
+  check_command_object_id INTEGER NOT NULL default '0',
+  check_command_args varchar(255) character set latin1 NOT NULL default '',
+  eventhandler_command_object_id INTEGER NOT NULL default '0',
+  eventhandler_command_args varchar(255) character set latin1 NOT NULL default '',
+  notification_timeperiod_object_id INTEGER NOT NULL default '0',
+  check_timeperiod_object_id INTEGER NOT NULL default '0',
+  failure_prediction_options varchar(64) character set latin1 NOT NULL default '',
+  check_interval double NOT NULL default '0',
+  retry_interval double NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  first_notification_delay double NOT NULL default '0',
+  notification_interval double NOT NULL default '0',
+  notify_on_down INTEGER NOT NULL default '0',
+  notify_on_unreachable INTEGER NOT NULL default '0',
+  notify_on_recovery INTEGER NOT NULL default '0',
+  notify_on_flapping INTEGER NOT NULL default '0',
+  notify_on_downtime INTEGER NOT NULL default '0',
+  stalk_on_up INTEGER NOT NULL default '0',
+  stalk_on_down INTEGER NOT NULL default '0',
+  stalk_on_unreachable INTEGER NOT NULL default '0',
+  flap_detection_enabled INTEGER NOT NULL default '0',
+  flap_detection_on_up INTEGER NOT NULL default '0',
+  flap_detection_on_down INTEGER NOT NULL default '0',
+  flap_detection_on_unreachable INTEGER NOT NULL default '0',
+  low_flap_threshold double NOT NULL default '0',
+  high_flap_threshold double NOT NULL default '0',
+  process_performance_data INTEGER NOT NULL default '0',
+  freshness_checks_enabled INTEGER NOT NULL default '0',
+  freshness_threshold INTEGER NOT NULL default '0',
+  passive_checks_enabled INTEGER NOT NULL default '0',
+  event_handler_enabled INTEGER NOT NULL default '0',
+  active_checks_enabled INTEGER NOT NULL default '0',
+  retain_status_information INTEGER NOT NULL default '0',
+  retain_nonstatus_information INTEGER NOT NULL default '0',
+  notifications_enabled INTEGER NOT NULL default '0',
+  obsess_over_host INTEGER NOT NULL default '0',
+  failure_prediction_enabled INTEGER NOT NULL default '0',
+  notes varchar(255) character set latin1 NOT NULL default '',
+  notes_url varchar(255) character set latin1 NOT NULL default '',
+  action_url varchar(255) character set latin1 NOT NULL default '',
+  icon_image varchar(255) character set latin1 NOT NULL default '',
+  icon_image_alt varchar(255) character set latin1 NOT NULL default '',
+  vrml_image varchar(255) character set latin1 NOT NULL default '',
+  statusmap_image varchar(255) character set latin1 NOT NULL default '',
+  have_2d_coords INTEGER NOT NULL default '0',
+  x_2d INTEGER NOT NULL default '0',
+  y_2d INTEGER NOT NULL default '0',
+  have_3d_coords INTEGER 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 (instance_id,config_type,host_object_id),
+  UNIQUE (host_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hoststatus
+--
+
+CREATE TABLE  icinga_hoststatus (
+  hoststatus_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  status_update_time datetime NOT NULL default '0000-00-00 00:00:00',
+  output varchar(255) character set latin1 NOT NULL default '',
+  perfdata varchar(255) character set latin1 NOT NULL default '',
+  current_state INTEGER NOT NULL default '0',
+  has_been_checked INTEGER NOT NULL default '0',
+  should_be_scheduled INTEGER NOT NULL default '0',
+  current_check_attempt INTEGER NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  last_check datetime NOT NULL default '0000-00-00 00:00:00',
+  next_check datetime NOT NULL default '0000-00-00 00:00:00',
+  check_type INTEGER NOT NULL default '0',
+  last_state_change datetime NOT NULL default '0000-00-00 00:00:00',
+  last_hard_state_change datetime NOT NULL default '0000-00-00 00:00:00',
+  last_hard_state INTEGER NOT NULL default '0',
+  last_time_up datetime NOT NULL default '0000-00-00 00:00:00',
+  last_time_down datetime NOT NULL default '0000-00-00 00:00:00',
+  last_time_unreachable datetime NOT NULL default '0000-00-00 00:00:00',
+  state_type INTEGER NOT NULL default '0',
+  last_notification datetime NOT NULL default '0000-00-00 00:00:00',
+  next_notification datetime NOT NULL default '0000-00-00 00:00:00',
+  no_more_notifications INTEGER NOT NULL default '0',
+  notifications_enabled INTEGER NOT NULL default '0',
+  problem_has_been_acknowledged INTEGER NOT NULL default '0',
+  acknowledgement_type INTEGER NOT NULL default '0',
+  current_notification_number INTEGER NOT NULL default '0',
+  passive_checks_enabled INTEGER NOT NULL default '0',
+  active_checks_enabled INTEGER NOT NULL default '0',
+  event_handler_enabled INTEGER NOT NULL default '0',
+  flap_detection_enabled INTEGER NOT NULL default '0',
+  is_flapping INTEGER NOT NULL default '0',
+  percent_state_change double NOT NULL default '0',
+  latency double NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  scheduled_downtime_depth INTEGER NOT NULL default '0',
+  failure_prediction_enabled INTEGER NOT NULL default '0',
+  process_performance_data INTEGER NOT NULL default '0',
+  obsess_over_host INTEGER NOT NULL default '0',
+  modified_host_attributes INTEGER NOT NULL default '0',
+  event_handler varchar(255) character set latin1 NOT NULL default '',
+  check_command varchar(255) character set latin1 NOT NULL default '',
+  normal_check_interval double NOT NULL default '0',
+  retry_check_interval double NOT NULL default '0',
+  check_timeperiod_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (hoststatus_id),
+  UNIQUE (host_object_id),
+  UNIQUE (instance_id),
+  UNIQUE (status_update_time),
+  UNIQUE (current_state),
+  UNIQUE (check_type),
+  UNIQUE (state_type),
+  UNIQUE (last_state_change),
+  UNIQUE (notifications_enabled),
+  UNIQUE (problem_has_been_acknowledged),
+  UNIQUE (active_checks_enabled),
+  UNIQUE (passive_checks_enabled),
+  UNIQUE (event_handler_enabled),
+  UNIQUE (flap_detection_enabled),
+  UNIQUE (is_flapping),
+  UNIQUE (percent_state_change),
+  UNIQUE (latency),
+  UNIQUE (execution_time),
+  UNIQUE (scheduled_downtime_depth)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_contactgroups
+--
+
+CREATE TABLE  icinga_host_contactgroups (
+  host_contactgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  host_id INTEGER NOT NULL default '0',
+  contactgroup_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (host_contactgroup_id),
+  UNIQUE (host_id,contactgroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_contacts
+--
+
+CREATE TABLE  icinga_host_contacts (
+  host_contact_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  host_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (host_contact_id),
+  UNIQUE (instance_id,host_id,contact_object_id)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_parenthosts
+--
+
+CREATE TABLE  icinga_host_parenthosts (
+  host_parenthost_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  host_id INTEGER NOT NULL default '0',
+  parent_host_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (host_parenthost_id),
+  UNIQUE (host_id,parent_host_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_instances
+--
+
+CREATE TABLE  icinga_instances (
+  instance_id SERIAL,
+  instance_name varchar(64) character set latin1 NOT NULL default '',
+  instance_description varchar(128) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (instance_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_logentries
+--
+
+CREATE TABLE  icinga_logentries (
+  logentry_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  logentry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER NOT NULL default '0',
+  logentry_type INTEGER NOT NULL default '0',
+  logentry_data varchar(255) character set latin1 NOT NULL default '',
+  realtime_data INTEGER NOT NULL default '0',
+  inferred_data_extracted INTEGER NOT NULL default '0',
+  PRIMARY KEY  (logentry_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_notifications
+--
+
+CREATE TABLE  icinga_notifications (
+  notification_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  notification_type INTEGER NOT NULL default '0',
+  notification_reason INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  output varchar(255) character set latin1 NOT NULL default '',
+  escalated INTEGER NOT NULL default '0',
+  contacts_notified INTEGER NOT NULL default '0',
+  PRIMARY KEY  (notification_id),
+  UNIQUE (instance_id,object_id,start_time,start_time_usec)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_objects
+--
+
+CREATE TABLE  icinga_objects (
+  object_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  objecttype_id INTEGER NOT NULL default '0',
+  name1 varchar(128) character set latin1 NOT NULL default '',
+  name2 varchar(128) character set latin1 default NULL,
+  is_active INTEGER NOT NULL default '0',
+  PRIMARY KEY  (object_id),
+  UNIQUE (objecttype_id,name1,name2)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_processevents
+--
+
+CREATE TABLE  icinga_processevents (
+  processevent_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  event_type INTEGER NOT NULL default '0',
+  event_time datetime NOT NULL default '0000-00-00 00:00:00',
+  event_time_usec INTEGER NOT NULL default '0',
+  process_id INTEGER NOT NULL default '0',
+  program_name varchar(16) character set latin1 NOT NULL default '',
+  program_version varchar(20) character set latin1 NOT NULL default '',
+  program_date varchar(10) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (processevent_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_programstatus
+--
+
+CREATE TABLE  icinga_programstatus (
+  programstatus_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  status_update_time datetime NOT NULL default '0000-00-00 00:00:00',
+  program_start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  program_end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  is_currently_running INTEGER NOT NULL default '0',
+  process_id INTEGER NOT NULL default '0',
+  daemon_mode INTEGER NOT NULL default '0',
+  last_command_check datetime NOT NULL default '0000-00-00 00:00:00',
+  last_log_rotation datetime NOT NULL default '0000-00-00 00:00:00',
+  notifications_enabled INTEGER NOT NULL default '0',
+  active_service_checks_enabled INTEGER NOT NULL default '0',
+  passive_service_checks_enabled INTEGER NOT NULL default '0',
+  active_host_checks_enabled INTEGER NOT NULL default '0',
+  passive_host_checks_enabled INTEGER NOT NULL default '0',
+  event_handlers_enabled INTEGER NOT NULL default '0',
+  flap_detection_enabled INTEGER NOT NULL default '0',
+  failure_prediction_enabled INTEGER NOT NULL default '0',
+  process_performance_data INTEGER NOT NULL default '0',
+  obsess_over_hosts INTEGER NOT NULL default '0',
+  obsess_over_services INTEGER NOT NULL default '0',
+  modified_host_attributes INTEGER NOT NULL default '0',
+  modified_service_attributes INTEGER NOT NULL default '0',
+  global_host_event_handler varchar(255) character set latin1 NOT NULL default '',
+  global_service_event_handler varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (programstatus_id),
+  UNIQUE (instance_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_runtimevariables
+--
+
+CREATE TABLE  icinga_runtimevariables (
+  runtimevariable_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  varname varchar(64) character set latin1 NOT NULL default '',
+  varvalue varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (runtimevariable_id),
+  UNIQUE (instance_id,varname)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_scheduleddowntime
+--
+
+CREATE TABLE  icinga_scheduleddowntime (
+  scheduleddowntime_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  downtime_type INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  entry_time datetime NOT NULL default '0000-00-00 00:00:00',
+  author_name varchar(64) character set latin1 NOT NULL default '',
+  comment_data varchar(255) character set latin1 NOT NULL default '',
+  internal_downtime_id INTEGER NOT NULL default '0',
+  triggered_by_id INTEGER NOT NULL default '0',
+  is_fixed INTEGER NOT NULL default '0',
+  duration INTEGER 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 INTEGER NOT NULL default '0',
+  actual_start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  actual_start_time_usec INTEGER NOT NULL default '0',
+  PRIMARY KEY  (scheduleddowntime_id),
+  UNIQUE (instance_id,object_id,entry_time,internal_downtime_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicechecks
+--
+
+CREATE TABLE  icinga_servicechecks (
+  servicecheck_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  check_type INTEGER NOT NULL default '0',
+  current_check_attempt INTEGER NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  state_type INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  command_object_id INTEGER NOT NULL default '0',
+  command_args varchar(255) character set latin1 NOT NULL default '',
+  command_line varchar(255) character set latin1 NOT NULL default '',
+  timeout INTEGER NOT NULL default '0',
+  early_timeout INTEGER NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  latency double NOT NULL default '0',
+  return_code INTEGER NOT NULL default '0',
+  output varchar(255) character set latin1 NOT NULL default '',
+  perfdata varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (servicecheck_id),
+  UNIQUE (instance_id),
+  UNIQUE (service_object_id),
+  UNIQUE (start_time)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicedependencies
+--
+
+CREATE TABLE  icinga_servicedependencies (
+  servicedependency_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  dependent_service_object_id INTEGER NOT NULL default '0',
+  dependency_type INTEGER NOT NULL default '0',
+  inherits_parent INTEGER NOT NULL default '0',
+  timeperiod_object_id INTEGER NOT NULL default '0',
+  fail_on_ok INTEGER NOT NULL default '0',
+  fail_on_warning INTEGER NOT NULL default '0',
+  fail_on_unknown INTEGER NOT NULL default '0',
+  fail_on_critical INTEGER NOT NULL default '0',
+  PRIMARY KEY  (servicedependency_id),
+  UNIQUE (instance_id,config_type,service_object_id,dependent_service_object_id,dependency_type,inherits_parent,fail_on_ok,fail_on_warning,fail_on_unknown,fail_on_critical)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalations
+--
+
+CREATE TABLE  icinga_serviceescalations (
+  serviceescalation_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  timeperiod_object_id INTEGER NOT NULL default '0',
+  first_notification INTEGER NOT NULL default '0',
+  last_notification INTEGER NOT NULL default '0',
+  notification_interval double NOT NULL default '0',
+  escalate_on_recovery INTEGER NOT NULL default '0',
+  escalate_on_warning INTEGER NOT NULL default '0',
+  escalate_on_unknown INTEGER NOT NULL default '0',
+  escalate_on_critical INTEGER NOT NULL default '0',
+  PRIMARY KEY  (serviceescalation_id),
+  UNIQUE (instance_id,config_type,service_object_id,timeperiod_object_id,first_notification,last_notification)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalation_contactgroups
+--
+
+CREATE TABLE  icinga_serviceescalation_contactgroups (
+  serviceescalation_contactgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  serviceescalation_id INTEGER NOT NULL default '0',
+  contactgroup_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (serviceescalation_contactgroup_id),
+  UNIQUE (serviceescalation_id,contactgroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalation_contacts
+--
+
+CREATE TABLE  icinga_serviceescalation_contacts (
+  serviceescalation_contact_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  serviceescalation_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (serviceescalation_contact_id),
+  UNIQUE (instance_id,serviceescalation_id,contact_object_id)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicegroups
+--
+
+CREATE TABLE  icinga_servicegroups (
+  servicegroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  servicegroup_object_id INTEGER NOT NULL default '0',
+  alias varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (servicegroup_id),
+  UNIQUE (instance_id,config_type,servicegroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicegroup_members
+--
+
+CREATE TABLE  icinga_servicegroup_members (
+  servicegroup_member_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  servicegroup_id INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (servicegroup_member_id),
+  UNIQUE (servicegroup_id,service_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_services
+--
+
+CREATE TABLE  icinga_services (
+  service_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  host_object_id INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  display_name varchar(64) character set latin1 NOT NULL default '',
+  check_command_object_id INTEGER NOT NULL default '0',
+  check_command_args varchar(255) character set latin1 NOT NULL default '',
+  eventhandler_command_object_id INTEGER NOT NULL default '0',
+  eventhandler_command_args varchar(255) character set latin1 NOT NULL default '',
+  notification_timeperiod_object_id INTEGER NOT NULL default '0',
+  check_timeperiod_object_id INTEGER NOT NULL default '0',
+  failure_prediction_options varchar(64) character set latin1 NOT NULL default '',
+  check_interval double NOT NULL default '0',
+  retry_interval double NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  first_notification_delay double NOT NULL default '0',
+  notification_interval double NOT NULL default '0',
+  notify_on_warning INTEGER NOT NULL default '0',
+  notify_on_unknown INTEGER NOT NULL default '0',
+  notify_on_critical INTEGER NOT NULL default '0',
+  notify_on_recovery INTEGER NOT NULL default '0',
+  notify_on_flapping INTEGER NOT NULL default '0',
+  notify_on_downtime INTEGER NOT NULL default '0',
+  stalk_on_ok INTEGER NOT NULL default '0',
+  stalk_on_warning INTEGER NOT NULL default '0',
+  stalk_on_unknown INTEGER NOT NULL default '0',
+  stalk_on_critical INTEGER NOT NULL default '0',
+  is_volatile INTEGER NOT NULL default '0',
+  flap_detection_enabled INTEGER NOT NULL default '0',
+  flap_detection_on_ok INTEGER NOT NULL default '0',
+  flap_detection_on_warning INTEGER NOT NULL default '0',
+  flap_detection_on_unknown INTEGER NOT NULL default '0',
+  flap_detection_on_critical INTEGER NOT NULL default '0',
+  low_flap_threshold double NOT NULL default '0',
+  high_flap_threshold double NOT NULL default '0',
+  process_performance_data INTEGER NOT NULL default '0',
+  freshness_checks_enabled INTEGER NOT NULL default '0',
+  freshness_threshold INTEGER NOT NULL default '0',
+  passive_checks_enabled INTEGER NOT NULL default '0',
+  event_handler_enabled INTEGER NOT NULL default '0',
+  active_checks_enabled INTEGER NOT NULL default '0',
+  retain_status_information INTEGER NOT NULL default '0',
+  retain_nonstatus_information INTEGER NOT NULL default '0',
+  notifications_enabled INTEGER NOT NULL default '0',
+  obsess_over_service INTEGER NOT NULL default '0',
+  failure_prediction_enabled INTEGER NOT NULL default '0',
+  notes varchar(255) character set latin1 NOT NULL default '',
+  notes_url varchar(255) character set latin1 NOT NULL default '',
+  action_url varchar(255) character set latin1 NOT NULL default '',
+  icon_image varchar(255) character set latin1 NOT NULL default '',
+  icon_image_alt varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (service_id),
+  UNIQUE (instance_id,config_type,service_object_id),
+  UNIQUE (service_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicestatus
+--
+
+CREATE TABLE  icinga_servicestatus (
+  servicestatus_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  service_object_id INTEGER NOT NULL default '0',
+  status_update_time datetime NOT NULL default '0000-00-00 00:00:00',
+  output varchar(255) character set latin1 NOT NULL default '',
+  perfdata varchar(255) character set latin1 NOT NULL default '',
+  current_state INTEGER NOT NULL default '0',
+  has_been_checked INTEGER NOT NULL default '0',
+  should_be_scheduled INTEGER NOT NULL default '0',
+  current_check_attempt INTEGER NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  last_check datetime NOT NULL default '0000-00-00 00:00:00',
+  next_check datetime NOT NULL default '0000-00-00 00:00:00',
+  check_type INTEGER NOT NULL default '0',
+  last_state_change datetime NOT NULL default '0000-00-00 00:00:00',
+  last_hard_state_change datetime NOT NULL default '0000-00-00 00:00:00',
+  last_hard_state INTEGER NOT NULL default '0',
+  last_time_ok datetime NOT NULL default '0000-00-00 00:00:00',
+  last_time_warning datetime NOT NULL default '0000-00-00 00:00:00',
+  last_time_unknown datetime NOT NULL default '0000-00-00 00:00:00',
+  last_time_critical datetime NOT NULL default '0000-00-00 00:00:00',
+  state_type INTEGER NOT NULL default '0',
+  last_notification datetime NOT NULL default '0000-00-00 00:00:00',
+  next_notification datetime NOT NULL default '0000-00-00 00:00:00',
+  no_more_notifications INTEGER NOT NULL default '0',
+  notifications_enabled INTEGER NOT NULL default '0',
+  problem_has_been_acknowledged INTEGER NOT NULL default '0',
+  acknowledgement_type INTEGER NOT NULL default '0',
+  current_notification_number INTEGER NOT NULL default '0',
+  passive_checks_enabled INTEGER NOT NULL default '0',
+  active_checks_enabled INTEGER NOT NULL default '0',
+  event_handler_enabled INTEGER NOT NULL default '0',
+  flap_detection_enabled INTEGER NOT NULL default '0',
+  is_flapping INTEGER NOT NULL default '0',
+  percent_state_change double NOT NULL default '0',
+  latency double NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  scheduled_downtime_depth INTEGER NOT NULL default '0',
+  failure_prediction_enabled INTEGER NOT NULL default '0',
+  process_performance_data INTEGER NOT NULL default '0',
+  obsess_over_service INTEGER NOT NULL default '0',
+  modified_service_attributes INTEGER NOT NULL default '0',
+  event_handler varchar(255) character set latin1 NOT NULL default '',
+  check_command varchar(255) character set latin1 NOT NULL default '',
+  normal_check_interval double NOT NULL default '0',
+  retry_check_interval double NOT NULL default '0',
+  check_timeperiod_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (servicestatus_id),
+  UNIQUE (service_object_id),
+  UNIQUE (instance_id),
+  UNIQUE (status_update_time),
+  UNIQUE (current_state),
+  UNIQUE (check_type),
+  UNIQUE (state_type),
+  UNIQUE (last_state_change),
+  UNIQUE (notifications_enabled),
+  UNIQUE (problem_has_been_acknowledged),
+  UNIQUE (active_checks_enabled),
+  UNIQUE (passive_checks_enabled),
+  UNIQUE (event_handler_enabled),
+  UNIQUE (flap_detection_enabled),
+  UNIQUE (is_flapping),
+  UNIQUE (percent_state_change),
+  UNIQUE (latency),
+  UNIQUE (execution_time),
+  UNIQUE (scheduled_downtime_depth)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_service_contactgroups
+--
+
+CREATE TABLE  icinga_service_contactgroups (
+  service_contactgroup_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  service_id INTEGER NOT NULL default '0',
+  contactgroup_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (service_contactgroup_id),
+  UNIQUE (service_id,contactgroup_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_service_contacts
+--
+
+CREATE TABLE  icinga_service_contacts (
+  service_contact_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  service_id INTEGER NOT NULL default '0',
+  contact_object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (service_contact_id),
+  UNIQUE (instance_id,service_id,contact_object_id)
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_statehistory
+--
+
+CREATE TABLE  icinga_statehistory (
+  statehistory_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  state_time datetime NOT NULL default '0000-00-00 00:00:00',
+  state_time_usec INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  state_change INTEGER NOT NULL default '0',
+  state INTEGER NOT NULL default '0',
+  state_type INTEGER NOT NULL default '0',
+  current_check_attempt INTEGER NOT NULL default '0',
+  max_check_attempts INTEGER NOT NULL default '0',
+  last_state INTEGER NOT NULL default '-1',
+  last_hard_state INTEGER NOT NULL default '-1',
+  output varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (statehistory_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_systemcommands
+--
+
+CREATE TABLE  icinga_systemcommands (
+  systemcommand_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  start_time datetime NOT NULL default '0000-00-00 00:00:00',
+  start_time_usec INTEGER NOT NULL default '0',
+  end_time datetime NOT NULL default '0000-00-00 00:00:00',
+  end_time_usec INTEGER NOT NULL default '0',
+  command_line varchar(255) character set latin1 NOT NULL default '',
+  timeout INTEGER NOT NULL default '0',
+  early_timeout INTEGER NOT NULL default '0',
+  execution_time double NOT NULL default '0',
+  return_code INTEGER NOT NULL default '0',
+  output varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (systemcommand_id),
+  UNIQUE (instance_id),
+  UNIQUE (start_time)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timedeventqueue
+--
+
+CREATE TABLE  icinga_timedeventqueue (
+  timedeventqueue_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  event_type INTEGER NOT NULL default '0',
+  queued_time datetime NOT NULL default '0000-00-00 00:00:00',
+  queued_time_usec INTEGER NOT NULL default '0',
+  scheduled_time datetime NOT NULL default '0000-00-00 00:00:00',
+  recurring_event INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  PRIMARY KEY  (timedeventqueue_id),
+  UNIQUE (instance_id),
+  UNIQUE (event_type),
+  UNIQUE (scheduled_time),
+  UNIQUE (object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timedevents
+--
+
+CREATE TABLE  icinga_timedevents (
+  timedevent_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  event_type INTEGER NOT NULL default '0',
+  queued_time datetime NOT NULL default '0000-00-00 00:00:00',
+  queued_time_usec INTEGER NOT NULL default '0',
+  event_time datetime NOT NULL default '0000-00-00 00:00:00',
+  event_time_usec INTEGER NOT NULL default '0',
+  scheduled_time datetime NOT NULL default '0000-00-00 00:00:00',
+  recurring_event INTEGER NOT NULL default '0',
+  object_id INTEGER NOT NULL default '0',
+  deletion_time datetime NOT NULL default '0000-00-00 00:00:00',
+  deletion_time_usec INTEGER NOT NULL default '0',
+  PRIMARY KEY  (timedevent_id),
+  UNIQUE (instance_id),
+  UNIQUE (event_type),
+  UNIQUE (scheduled_time),
+  UNIQUE (object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timeperiods
+--
+
+CREATE TABLE  icinga_timeperiods (
+  timeperiod_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  config_type INTEGER NOT NULL default '0',
+  timeperiod_object_id INTEGER NOT NULL default '0',
+  alias varchar(255) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (timeperiod_id),
+  UNIQUE (instance_id,config_type,timeperiod_object_id)
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timeperiod_timeranges
+--
+
+CREATE TABLE  icinga_timeperiod_timeranges (
+  timeperiod_timerange_id SERIAL,
+  instance_id INTEGER NOT NULL default '0',
+  timeperiod_id INTEGER NOT NULL default '0',
+  day INTEGER NOT NULL default '0',
+  start_sec INTEGER NOT NULL default '0',
+  end_sec INTEGER NOT NULL default '0',
+  PRIMARY KEY  (timeperiod_timerange_id),
+  UNIQUE (timeperiod_id,day,start_sec,end_sec)
+) ;
diff --git a/module/idoutils/db/sqlite.sql b/module/idoutils/db/sqlite.sql
new file mode 100644
index 0000000..76c438a
--- /dev/null
+++ b/module/idoutils/db/sqlite.sql
@@ -0,0 +1,1273 @@
+/*
+# sqlite.sql
+#   - modfied mysql.sql to work with sqlite3_db
+#
+# mm/2009-05-13
+# 
+*/
+
+
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: icinga
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_acknowledgements
+--
+
+CREATE TABLE IF NOT EXISTS icinga_acknowledgements (
+  acknowledgement_id INTEGER  auto_increment primary key,
+  instance_id INTEGER   default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER   default '0',
+  acknowledgement_type INTEGER   default '0',
+  object_id INTEGER   default '0',
+  state INTEGER  default '0',
+  author_name varchar(64)   default '',
+  comment_data varchar(255)   default '',
+  is_sticky INTEGER   default '0',
+  persistent_comment INTEGER   default '0',
+  notify_contacts INTEGER   default '0'
+  
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_commands
+--
+
+CREATE TABLE IF NOT EXISTS icinga_commands (
+  command_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  command_line varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_commenthistory
+--
+
+CREATE TABLE IF NOT EXISTS icinga_commenthistory (
+  commenthistory_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER  default '0',
+  comment_type INTEGER  default '0',
+  entry_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  comment_time datetime  default '0000-00-00 00:00:00',
+  internal_comment_id INTEGER  default '0',
+  author_name varchar(64)   default '',
+  comment_data varchar(255)   default '',
+  is_persistent INTEGER  default '0',
+  comment_source INTEGER  default '0',
+  expires INTEGER  default '0',
+  expiration_time datetime  default '0000-00-00 00:00:00',
+  deletion_time datetime  default '0000-00-00 00:00:00',
+  deletion_time_usec INTEGER  default '0'
+  
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_comments
+--
+
+CREATE TABLE IF NOT EXISTS icinga_comments (
+  comment_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER  default '0',
+  comment_type INTEGER  default '0',
+  entry_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  comment_time datetime  default '0000-00-00 00:00:00',
+  internal_comment_id INTEGER  default '0',
+  author_name varchar(64)   default '',
+  comment_data varchar(255)   default '',
+  is_persistent INTEGER  default '0',
+  comment_source INTEGER  default '0',
+  expires INTEGER  default '0',
+  expiration_time datetime  default '0000-00-00 00:00:00'
+  
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_configfiles
+--
+
+CREATE TABLE IF NOT EXISTS icinga_configfiles (
+  configfile_id INTEGER  auto_increment PRIMARY KEY  ,
+  instance_id INTEGER  default '0',
+  configfile_type INTEGER  default '0',
+  configfile_path varchar(255)   default ''
+
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_configfilevariables
+--
+
+CREATE TABLE IF NOT EXISTS icinga_configfilevariables (
+  configfilevariable_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  configfile_id INTEGER  default '0',
+  varname varchar(64)   default '',
+  varvalue varchar(255)   default ''
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_conninfo
+--
+
+CREATE TABLE IF NOT EXISTS icinga_conninfo (
+  conninfo_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  agent_name varchar(32)   default '',
+  agent_version varchar(8)   default '',
+  disposition varchar(16)   default '',
+  connect_source varchar(16)   default '',
+  connect_type varchar(16)   default '',
+  connect_time datetime  default '0000-00-00 00:00:00',
+  disconnect_time datetime  default '0000-00-00 00:00:00',
+  last_checkin_time datetime  default '0000-00-00 00:00:00',
+  data_start_time datetime  default '0000-00-00 00:00:00',
+  data_end_time datetime  default '0000-00-00 00:00:00',
+  bytes_processed INTEGER  default '0',
+  lines_processed INTEGER  default '0',
+  entries_processed INTEGER  default '0'
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contactgroups (
+  contactgroup_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  contactgroup_object_id INTEGER  default '0',
+  alias varchar(255)   default ''
+  )   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactgroup_members
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contactgroup_members (
+  contactgroup_member_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  contactgroup_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0'
+
+
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactnotificationmethods
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contactnotificationmethods (
+  contactnotificationmethod_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  contactnotification_id INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  command_object_id INTEGER  default '0',
+  command_args varchar(255)   default ''
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactnotifications
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contactnotifications (
+  contactnotification_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  notification_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0'
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contacts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contacts (
+  contact_id INTEGER  auto_increment PRIMARY KEY  ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  contact_object_id INTEGER  default '0',
+  alias varchar(64)   default '',
+  email_address varchar(255)   default '',
+  pager_address varchar(64)   default '',
+  host_timeperiod_object_id INTEGER  default '0',
+  service_timeperiod_object_id INTEGER  default '0',
+  host_notifications_enabled INTEGER  default '0',
+  service_notifications_enabled INTEGER  default '0',
+  can_submit_commands INTEGER  default '0',
+  notify_service_recovery INTEGER  default '0',
+  notify_service_warning INTEGER  default '0',
+  notify_service_unknown INTEGER  default '0',
+  notify_service_critical INTEGER  default '0',
+  notify_service_flapping INTEGER  default '0',
+  notify_service_downtime INTEGER  default '0',
+  notify_host_recovery INTEGER  default '0',
+  notify_host_down INTEGER  default '0',
+  notify_host_unreachable INTEGER  default '0',
+  notify_host_flapping INTEGER  default '0',
+  notify_host_downtime INTEGER  default '0'
+
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contactstatus
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contactstatus (
+  contactstatus_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0',
+  status_update_time datetime  default '0000-00-00 00:00:00',
+  host_notifications_enabled INTEGER  default '0',
+  service_notifications_enabled INTEGER  default '0',
+  last_host_notification datetime  default '0000-00-00 00:00:00',
+  last_service_notification datetime  default '0000-00-00 00:00:00',
+  modified_attributes INTEGER  default '0',
+  modified_host_attributes INTEGER  default '0',
+  modified_service_attributes INTEGER  default '0'
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contact_addresses
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contact_addresses (
+  contact_address_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  contact_id INTEGER  default '0',
+  address_number INTEGER  default '0'
+
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_contact_notificationcommands
+--
+
+CREATE TABLE IF NOT EXISTS icinga_contact_notificationcommands (
+  contact_notificationcommand_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  contact_id INTEGER  default '0',
+  notification_type INTEGER  default '0',
+  command_object_id INTEGER  default '0',
+  command_args varchar(255)   default ''
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_customvariables
+--
+
+CREATE TABLE IF NOT EXISTS icinga_customvariables (
+  customvariable_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  object_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  has_been_modified INTEGER  default '0',
+  varname varchar(255)   default '',
+  varvalue varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_customvariablestatus
+--
+
+CREATE TABLE IF NOT EXISTS icinga_customvariablestatus (
+  customvariablestatus_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  object_id INTEGER  default '0',
+  status_update_time datetime  default '0000-00-00 00:00:00',
+  has_been_modified INTEGER  default '0',
+  varname varchar(255)   default '',
+  varvalue varchar(255)   default ''
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_dbversion
+--
+
+CREATE TABLE IF NOT EXISTS icinga_dbversion (
+  name varchar(10)   default '',
+  version varchar(10)   default ''
+) ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_downtimehistory
+--
+
+CREATE TABLE IF NOT EXISTS icinga_downtimehistory (
+  downtimehistory_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  downtime_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  author_name varchar(64)   default '',
+  comment_data varchar(255)   default '',
+  internal_downtime_id INTEGER  default '0',
+  triggered_by_id INTEGER  default '0',
+  is_fixed INTEGER  default '0',
+  duration INTEGER  default '0',
+  scheduled_start_time datetime  default '0000-00-00 00:00:00',
+  scheduled_end_time datetime  default '0000-00-00 00:00:00',
+  was_started INTEGER  default '0',
+  actual_start_time datetime  default '0000-00-00 00:00:00',
+  actual_start_time_usec INTEGER  default '0',
+  actual_end_time datetime  default '0000-00-00 00:00:00',
+  actual_end_time_usec INTEGER  default '0',
+  was_cancelled INTEGER  default '0'
+
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_eventhandlers
+--
+
+CREATE TABLE IF NOT EXISTS icinga_eventhandlers (
+  eventhandler_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  eventhandler_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  state INTEGER  default '0',
+  state_type INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  command_object_id INTEGER  default '0',
+  command_args varchar(255)   default '',
+  command_line varchar(255)   default '',
+  timeout INTEGER  default '0',
+  early_timeout INTEGER  default '0',
+  execution_time double  default '0',
+  return_code INTEGER  default '0',
+  output varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_externalcommands
+--
+
+CREATE TABLE IF NOT EXISTS icinga_externalcommands (
+  externalcommand_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  command_type INTEGER  default '0',
+  command_name varchar(128)   default '',
+  command_args varchar(255)   default ''
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_flappinghistory
+--
+
+CREATE TABLE IF NOT EXISTS icinga_flappinghistory (
+  flappinghistory_id INTEGER  auto_increment PRIMARY KEY  ,
+  instance_id INTEGER  default '0',
+  event_time datetime  default '0000-00-00 00:00:00',
+  event_time_usec INTEGER  default '0',
+  event_type INTEGER  default '0',
+  reason_type INTEGER  default '0',
+  flapping_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  percent_state_change double  default '0',
+  low_threshold double  default '0',
+  high_threshold double  default '0',
+  comment_time datetime  default '0000-00-00 00:00:00',
+  internal_comment_id INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostchecks
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostchecks (
+  hostcheck_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  check_type INTEGER  default '0',
+  is_raw_check INTEGER  default '0',
+  current_check_attempt INTEGER  default '0',
+  max_check_attempts INTEGER  default '0',
+  state INTEGER  default '0',
+  state_type INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  command_object_id INTEGER  default '0',
+  command_args varchar(255)   default '',
+  command_line varchar(255)   default '',
+  timeout INTEGER  default '0',
+  early_timeout INTEGER  default '0',
+  execution_time double  default '0',
+  latency double  default '0',
+  return_code INTEGER  default '0',
+  output varchar(255)   default '',
+  perfdata varchar(255)   default ''
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostdependencies
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostdependencies (
+  hostdependency_id INTEGER  auto_increment PRIMARY KEY  ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  dependent_host_object_id INTEGER  default '0',
+  dependency_type INTEGER  default '0',
+  inherits_parent INTEGER  default '0',
+  timeperiod_object_id INTEGER  default '0',
+  fail_on_up INTEGER  default '0',
+  fail_on_down INTEGER  default '0',
+  fail_on_unreachable INTEGER  default '0'
+  
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalations
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostescalations (
+  hostescalation_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  timeperiod_object_id INTEGER  default '0',
+  first_notification INTEGER  default '0',
+  last_notification INTEGER  default '0',
+  notification_interval double  default '0',
+  escalate_on_recovery INTEGER  default '0',
+  escalate_on_down INTEGER  default '0',
+  escalate_on_unreachable INTEGER  default '0'
+   
+  
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalation_contactgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostescalation_contactgroups (
+  hostescalation_contactgroup_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  hostescalation_id INTEGER  default '0',
+  contactgroup_object_id INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostescalation_contacts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostescalation_contacts (
+  hostescalation_contact_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  hostescalation_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostgroups (
+  hostgroup_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  hostgroup_object_id INTEGER  default '0',
+  alias varchar(255)   default ''
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hostgroup_members
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hostgroup_members (
+  hostgroup_member_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  hostgroup_id INTEGER  default '0',
+  host_object_id INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hosts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hosts (
+  host_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  alias varchar(64)   default '',
+  display_name varchar(64)   default '',
+  address varchar(128)   default '',
+  check_command_object_id INTEGER  default '0',
+  check_command_args varchar(255)   default '',
+  eventhandler_command_object_id INTEGER  default '0',
+  eventhandler_command_args varchar(255)   default '',
+  notification_timeperiod_object_id INTEGER  default '0',
+  check_timeperiod_object_id INTEGER  default '0',
+  failure_prediction_options varchar(64)   default '',
+  check_interval double  default '0',
+  retry_interval double  default '0',
+  max_check_attempts INTEGER  default '0',
+  first_notification_delay double  default '0',
+  notification_interval double  default '0',
+  notify_on_down INTEGER  default '0',
+  notify_on_unreachable INTEGER  default '0',
+  notify_on_recovery INTEGER  default '0',
+  notify_on_flapping INTEGER  default '0',
+  notify_on_downtime INTEGER  default '0',
+  stalk_on_up INTEGER  default '0',
+  stalk_on_down INTEGER  default '0',
+  stalk_on_unreachable INTEGER  default '0',
+  flap_detection_enabled INTEGER  default '0',
+  flap_detection_on_up INTEGER  default '0',
+  flap_detection_on_down INTEGER  default '0',
+  flap_detection_on_unreachable INTEGER  default '0',
+  low_flap_threshold double  default '0',
+  high_flap_threshold double  default '0',
+  process_performance_data INTEGER  default '0',
+  freshness_checks_enabled INTEGER  default '0',
+  freshness_threshold INTEGER  default '0',
+  passive_checks_enabled INTEGER  default '0',
+  event_handler_enabled INTEGER  default '0',
+  active_checks_enabled INTEGER  default '0',
+  retain_status_information INTEGER  default '0',
+  retain_nonstatus_information INTEGER  default '0',
+  notifications_enabled INTEGER  default '0',
+  obsess_over_host INTEGER  default '0',
+  failure_prediction_enabled INTEGER  default '0',
+  notes varchar(255)   default '',
+  notes_url varchar(255)   default '',
+  action_url varchar(255)   default '',
+  icon_image varchar(255)   default '',
+  icon_image_alt varchar(255)   default '',
+  vrml_image varchar(255)   default '',
+  statusmap_image varchar(255)   default '',
+  have_2d_coords INTEGER  default '0',
+  x_2d INTEGER  default '0',
+  y_2d INTEGER  default '0',
+  have_3d_coords INTEGER  default '0',
+  x_3d double  default '0',
+  y_3d double  default '0',
+  z_3d double  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_hoststatus
+--
+
+CREATE TABLE IF NOT EXISTS icinga_hoststatus (
+  hoststatus_id INTEGER  auto_increment PRIMARY KEY ,
+  instance_id INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  status_update_time datetime  default '0000-00-00 00:00:00',
+  output varchar(255)   default '',
+  perfdata varchar(255)   default '',
+  current_state INTEGER  default '0',
+  has_been_checked INTEGER  default '0',
+  should_be_scheduled INTEGER  default '0',
+  current_check_attempt INTEGER  default '0',
+  max_check_attempts INTEGER  default '0',
+  last_check datetime  default '0000-00-00 00:00:00',
+  next_check datetime  default '0000-00-00 00:00:00',
+  check_type INTEGER  default '0',
+  last_state_change datetime  default '0000-00-00 00:00:00',
+  last_hard_state_change datetime  default '0000-00-00 00:00:00',
+  last_hard_state INTEGER  default '0',
+  last_time_up datetime  default '0000-00-00 00:00:00',
+  last_time_down datetime  default '0000-00-00 00:00:00',
+  last_time_unreachable datetime  default '0000-00-00 00:00:00',
+  state_type INTEGER  default '0',
+  last_notification datetime  default '0000-00-00 00:00:00',
+  next_notification datetime  default '0000-00-00 00:00:00',
+  no_more_notifications INTEGER  default '0',
+  notifications_enabled INTEGER  default '0',
+  problem_has_been_acknowledged INTEGER  default '0',
+  acknowledgement_type INTEGER  default '0',
+  current_notification_number INTEGER  default '0',
+  passive_checks_enabled INTEGER  default '0',
+  active_checks_enabled INTEGER  default '0',
+  event_handler_enabled INTEGER  default '0',
+  flap_detection_enabled INTEGER  default '0',
+  is_flapping INTEGER  default '0',
+  percent_state_change double  default '0',
+  latency double  default '0',
+  execution_time double  default '0',
+  scheduled_downtime_depth INTEGER  default '0',
+  failure_prediction_enabled INTEGER  default '0',
+  process_performance_data INTEGER  default '0',
+  obsess_over_host INTEGER  default '0',
+  modified_host_attributes INTEGER  default '0',
+  event_handler varchar(255)   default '',
+  check_command varchar(255)   default '',
+  normal_check_interval double  default '0',
+  retry_check_interval double  default '0',
+  check_timeperiod_object_id INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_contactgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_host_contactgroups (
+  host_contactgroup_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  host_id INTEGER  default '0',
+  contactgroup_object_id INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_contacts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_host_contacts (
+  host_contact_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  host_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_host_parenthosts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_host_parenthosts (
+  host_parenthost_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  host_id INTEGER  default '0',
+  parent_host_object_id INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_instances
+--
+
+CREATE TABLE IF NOT EXISTS icinga_instances (
+  instance_id INTEGER  auto_increment PRIMARY KEY,
+  instance_name varchar(64)   default '',
+  instance_description varchar(128)   default ''
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_logentries
+--
+
+CREATE TABLE IF NOT EXISTS icinga_logentries (
+  logentry_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  logentry_time datetime  default '0000-00-00 00:00:00',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  entry_time_usec INTEGER  default '0',
+  logentry_type INTEGER  default '0',
+  logentry_data varchar(255)   default '',
+  realtime_data INTEGER  default '0',
+  inferred_data_extracted INTEGER  default '0'
+  )  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_notifications
+--
+
+CREATE TABLE IF NOT EXISTS icinga_notifications (
+  notification_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  notification_type INTEGER  default '0',
+  notification_reason INTEGER  default '0',
+  object_id INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  state INTEGER  default '0',
+  output varchar(255)   default '',
+  escalated INTEGER  default '0',
+  contacts_notified INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_objects
+--
+
+CREATE TABLE IF NOT EXISTS icinga_objects (
+  object_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  objecttype_id INTEGER  default '0',
+  name1 varchar(128)   default '',
+  name2 varchar(128)  default NULL,
+  is_active INTEGER  default '0'
+)   ;
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_processevents
+--
+
+CREATE TABLE IF NOT EXISTS icinga_processevents (
+  processevent_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  event_type INTEGER  default '0',
+  event_time datetime  default '0000-00-00 00:00:00',
+  event_time_usec INTEGER  default '0',
+  process_id INTEGER  default '0',
+  program_name varchar(16)   default '',
+  program_version varchar(20)   default '',
+  program_date varchar(10)   default ''
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_programstatus
+--
+
+CREATE TABLE IF NOT EXISTS icinga_programstatus (
+  programstatus_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  status_update_time datetime  default '0000-00-00 00:00:00',
+  program_start_time datetime  default '0000-00-00 00:00:00',
+  program_end_time datetime  default '0000-00-00 00:00:00',
+  is_currently_running INTEGER  default '0',
+  process_id INTEGER  default '0',
+  daemon_mode INTEGER  default '0',
+  last_command_check datetime  default '0000-00-00 00:00:00',
+  last_log_rotation datetime  default '0000-00-00 00:00:00',
+  notifications_enabled INTEGER  default '0',
+  active_service_checks_enabled INTEGER  default '0',
+  passive_service_checks_enabled INTEGER  default '0',
+  active_host_checks_enabled INTEGER  default '0',
+  passive_host_checks_enabled INTEGER  default '0',
+  event_handlers_enabled INTEGER  default '0',
+  flap_detection_enabled INTEGER  default '0',
+  failure_prediction_enabled INTEGER  default '0',
+  process_performance_data INTEGER  default '0',
+  obsess_over_hosts INTEGER  default '0',
+  obsess_over_services INTEGER  default '0',
+  modified_host_attributes INTEGER  default '0',
+  modified_service_attributes INTEGER  default '0',
+  global_host_event_handler varchar(255)   default '',
+  global_service_event_handler varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_runtimevariables
+--
+
+CREATE TABLE IF NOT EXISTS icinga_runtimevariables (
+  runtimevariable_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  varname varchar(64)   default '',
+  varvalue varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_scheduleddowntime
+--
+
+CREATE TABLE IF NOT EXISTS icinga_scheduleddowntime (
+  scheduleddowntime_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  downtime_type INTEGER  default '0',
+  object_id INTEGER  default '0',
+  entry_time datetime  default '0000-00-00 00:00:00',
+  author_name varchar(64)   default '',
+  comment_data varchar(255)   default '',
+  internal_downtime_id INTEGER  default '0',
+  triggered_by_id INTEGER  default '0',
+  is_fixed INTEGER  default '0',
+  duration INTEGER  default '0',
+  scheduled_start_time datetime  default '0000-00-00 00:00:00',
+  scheduled_end_time datetime  default '0000-00-00 00:00:00',
+  was_started INTEGER  default '0',
+  actual_start_time datetime  default '0000-00-00 00:00:00',
+  actual_start_time_usec INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicechecks
+--
+
+CREATE TABLE IF NOT EXISTS icinga_servicechecks (
+  servicecheck_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  service_object_id INTEGER  default '0',
+  check_type INTEGER  default '0',
+  current_check_attempt INTEGER  default '0',
+  max_check_attempts INTEGER  default '0',
+  state INTEGER  default '0',
+  state_type INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  command_object_id INTEGER  default '0',
+  command_args varchar(255)   default '',
+  command_line varchar(255)   default '',
+  timeout INTEGER  default '0',
+  early_timeout INTEGER  default '0',
+  execution_time double  default '0',
+  latency double  default '0',
+  return_code INTEGER  default '0',
+  output varchar(255)   default '',
+  perfdata varchar(255)   default ''
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicedependencies
+--
+
+CREATE TABLE IF NOT EXISTS icinga_servicedependencies (
+  servicedependency_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  service_object_id INTEGER  default '0',
+  dependent_service_object_id INTEGER  default '0',
+  dependency_type INTEGER  default '0',
+  inherits_parent INTEGER  default '0',
+  timeperiod_object_id INTEGER  default '0',
+  fail_on_ok INTEGER  default '0',
+  fail_on_warning INTEGER  default '0',
+  fail_on_unknown INTEGER  default '0',
+  fail_on_critical INTEGER  default '0'
+
+  )  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalations
+--
+
+CREATE TABLE IF NOT EXISTS icinga_serviceescalations (
+  serviceescalation_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  service_object_id INTEGER  default '0',
+  timeperiod_object_id INTEGER  default '0',
+  first_notification INTEGER  default '0',
+  last_notification INTEGER  default '0',
+  notification_interval double  default '0',
+  escalate_on_recovery INTEGER  default '0',
+  escalate_on_warning INTEGER  default '0',
+  escalate_on_unknown INTEGER  default '0',
+  escalate_on_critical INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalation_contactgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_serviceescalation_contactgroups (
+  serviceescalation_contactgroup_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  serviceescalation_id INTEGER  default '0',
+  contactgroup_object_id INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_serviceescalation_contacts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_serviceescalation_contacts (
+  serviceescalation_contact_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  serviceescalation_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicegroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_servicegroups (
+  servicegroup_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  servicegroup_object_id INTEGER  default '0',
+  alias varchar(255)   default ''
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicegroup_members
+--
+
+CREATE TABLE IF NOT EXISTS icinga_servicegroup_members (
+  servicegroup_member_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  servicegroup_id INTEGER  default '0',
+  service_object_id INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_services
+--
+
+CREATE TABLE IF NOT EXISTS icinga_services (
+  service_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  host_object_id INTEGER  default '0',
+  service_object_id INTEGER  default '0',
+  display_name varchar(64)   default '',
+  check_command_object_id INTEGER  default '0',
+  check_command_args varchar(255)   default '',
+  eventhandler_command_object_id INTEGER  default '0',
+  eventhandler_command_args varchar(255)   default '',
+  notification_timeperiod_object_id INTEGER  default '0',
+  check_timeperiod_object_id INTEGER  default '0',
+  failure_prediction_options varchar(64)   default '',
+  check_interval double  default '0',
+  retry_interval double  default '0',
+  max_check_attempts INTEGER  default '0',
+  first_notification_delay double  default '0',
+  notification_interval double  default '0',
+  notify_on_warning INTEGER  default '0',
+  notify_on_unknown INTEGER  default '0',
+  notify_on_critical INTEGER  default '0',
+  notify_on_recovery INTEGER  default '0',
+  notify_on_flapping INTEGER  default '0',
+  notify_on_downtime INTEGER  default '0',
+  stalk_on_ok INTEGER  default '0',
+  stalk_on_warning INTEGER  default '0',
+  stalk_on_unknown INTEGER  default '0',
+  stalk_on_critical INTEGER  default '0',
+  is_volatile INTEGER  default '0',
+  flap_detection_enabled INTEGER  default '0',
+  flap_detection_on_ok INTEGER  default '0',
+  flap_detection_on_warning INTEGER  default '0',
+  flap_detection_on_unknown INTEGER  default '0',
+  flap_detection_on_critical INTEGER  default '0',
+  low_flap_threshold double  default '0',
+  high_flap_threshold double  default '0',
+  process_performance_data INTEGER  default '0',
+  freshness_checks_enabled INTEGER  default '0',
+  freshness_threshold INTEGER  default '0',
+  passive_checks_enabled INTEGER  default '0',
+  event_handler_enabled INTEGER  default '0',
+  active_checks_enabled INTEGER  default '0',
+  retain_status_information INTEGER  default '0',
+  retain_nonstatus_information INTEGER  default '0',
+  notifications_enabled INTEGER  default '0',
+  obsess_over_service INTEGER  default '0',
+  failure_prediction_enabled INTEGER  default '0',
+  notes varchar(255)   default '',
+  notes_url varchar(255)   default '',
+  action_url varchar(255)   default '',
+  icon_image varchar(255)   default '',
+  icon_image_alt varchar(255)   default ''
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_servicestatus
+--
+
+CREATE TABLE IF NOT EXISTS icinga_servicestatus (
+  servicestatus_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  service_object_id INTEGER  default '0',
+  status_update_time datetime  default '0000-00-00 00:00:00',
+  output varchar(255)   default '',
+  perfdata varchar(255)   default '',
+  current_state INTEGER  default '0',
+  has_been_checked INTEGER  default '0',
+  should_be_scheduled INTEGER  default '0',
+  current_check_attempt INTEGER  default '0',
+  max_check_attempts INTEGER  default '0',
+  last_check datetime  default '0000-00-00 00:00:00',
+  next_check datetime  default '0000-00-00 00:00:00',
+  check_type INTEGER  default '0',
+  last_state_change datetime  default '0000-00-00 00:00:00',
+  last_hard_state_change datetime  default '0000-00-00 00:00:00',
+  last_hard_state INTEGER  default '0',
+  last_time_ok datetime  default '0000-00-00 00:00:00',
+  last_time_warning datetime  default '0000-00-00 00:00:00',
+  last_time_unknown datetime  default '0000-00-00 00:00:00',
+  last_time_critical datetime  default '0000-00-00 00:00:00',
+  state_type INTEGER  default '0',
+  last_notification datetime  default '0000-00-00 00:00:00',
+  next_notification datetime  default '0000-00-00 00:00:00',
+  no_more_notifications INTEGER  default '0',
+  notifications_enabled INTEGER  default '0',
+  problem_has_been_acknowledged INTEGER  default '0',
+  acknowledgement_type INTEGER  default '0',
+  current_notification_number INTEGER  default '0',
+  passive_checks_enabled INTEGER  default '0',
+  active_checks_enabled INTEGER  default '0',
+  event_handler_enabled INTEGER  default '0',
+  flap_detection_enabled INTEGER  default '0',
+  is_flapping INTEGER  default '0',
+  percent_state_change double  default '0',
+  latency double  default '0',
+  execution_time double  default '0',
+  scheduled_downtime_depth INTEGER  default '0',
+  failure_prediction_enabled INTEGER  default '0',
+  process_performance_data INTEGER  default '0',
+  obsess_over_service INTEGER  default '0',
+  modified_service_attributes INTEGER  default '0',
+  event_handler varchar(255)   default '',
+  check_command varchar(255)   default '',
+  normal_check_interval double  default '0',
+  retry_check_interval double  default '0',
+  check_timeperiod_object_id INTEGER  default '0'
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_service_contactgroups
+--
+
+CREATE TABLE IF NOT EXISTS icinga_service_contactgroups (
+  service_contactgroup_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  service_id INTEGER  default '0',
+  contactgroup_object_id INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_service_contacts
+--
+
+CREATE TABLE IF NOT EXISTS icinga_service_contacts (
+  service_contact_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  service_id INTEGER  default '0',
+  contact_object_id INTEGER  default '0'
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_statehistory
+--
+
+CREATE TABLE IF NOT EXISTS icinga_statehistory (
+  statehistory_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  state_time datetime  default '0000-00-00 00:00:00',
+  state_time_usec INTEGER  default '0',
+  object_id INTEGER  default '0',
+  state_change INTEGER  default '0',
+  state INTEGER  default '0',
+  state_type INTEGER  default '0',
+  current_check_attempt INTEGER  default '0',
+  max_check_attempts INTEGER  default '0',
+  last_state INTEGER  default '-1',
+  last_hard_state INTEGER  default '-1',
+  output varchar(255)   default ''
+
+)   ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_systemcommands
+--
+
+CREATE TABLE IF NOT EXISTS icinga_systemcommands (
+  systemcommand_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  start_time datetime  default '0000-00-00 00:00:00',
+  start_time_usec INTEGER  default '0',
+  end_time datetime  default '0000-00-00 00:00:00',
+  end_time_usec INTEGER  default '0',
+  command_line varchar(255)   default '',
+  timeout INTEGER  default '0',
+  early_timeout INTEGER  default '0',
+  execution_time double  default '0',
+  return_code INTEGER  default '0',
+  output varchar(255)   default ''
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timedeventqueue
+--
+
+CREATE TABLE IF NOT EXISTS icinga_timedeventqueue (
+  timedeventqueue_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  event_type INTEGER  default '0',
+  queued_time datetime  default '0000-00-00 00:00:00',
+  queued_time_usec INTEGER  default '0',
+  scheduled_time datetime  default '0000-00-00 00:00:00',
+  recurring_event INTEGER  default '0',
+  object_id INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timedevents
+--
+
+CREATE TABLE IF NOT EXISTS icinga_timedevents (
+  timedevent_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  event_type INTEGER  default '0',
+  queued_time datetime  default '0000-00-00 00:00:00',
+  queued_time_usec INTEGER  default '0',
+  event_time datetime  default '0000-00-00 00:00:00',
+  event_time_usec INTEGER  default '0',
+  scheduled_time datetime  default '0000-00-00 00:00:00',
+  recurring_event INTEGER  default '0',
+  object_id INTEGER  default '0',
+  deletion_time datetime  default '0000-00-00 00:00:00',
+  deletion_time_usec INTEGER  default '0'
+)    ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timeperiods
+--
+
+CREATE TABLE IF NOT EXISTS icinga_timeperiods (
+  timeperiod_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  config_type INTEGER  default '0',
+  timeperiod_object_id INTEGER  default '0',
+  alias varchar(255)   default ''
+)  ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table icinga_timeperiod_timeranges
+--
+
+CREATE TABLE IF NOT EXISTS icinga_timeperiod_timeranges (
+  timeperiod_timerange_id INTEGER  auto_increment PRIMARY KEY,
+  instance_id INTEGER  default '0',
+  timeperiod_id INTEGER  default '0',
+  day INTEGER  default '0',
+  start_sec INTEGER  default '0',
+  end_sec INTEGER  default '0'
+)  ;
-- 
1.5.6.5



-- 


Markus Manzke


MARE System Kiel   .:.   http://www.mare-system.de






More information about the icinga-devel mailing list