naparuba/shinken — Issue #25: Merlindb - Host and servicedependency
Author: Frescha
Created: 2011-10-29 08:21:04+00:00
State: open
Labels: Broker

Host- and servicedependency should be maneged in the next version.

Sample table structure see attachment

###
-- phpMyAdmin SQL Dump
-- version 3.3.7deb5build0.10.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 04. Mai 2011 um 11:18
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3-1ubuntu9.3

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

--
-- Datenbank: `merlin`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur f√ºr Tabelle `servicedependency`
--

CREATE TABLE IF NOT EXISTS `servicedependency` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`service` int(11) NOT NULL,
`dependent_service` int(11) NOT NULL,
`dependency_period` varchar(75) COLLATE latin1_general_cs DEFAULT NULL,
`inherits_parent` tinyint(1) DEFAULT NULL,
`execution_failure_options` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`notification_failure_options` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=1 ;

###

-- phpMyAdmin SQL Dump
-- version 3.3.7deb5build0.10.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 04. Mai 2011 um 11:20
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3-1ubuntu9.3

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

--
-- Datenbank: `merlin`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur f√ºr Tabelle `hostdependency`
--

CREATE TABLE IF NOT EXISTS `hostdependency` (
`instance_id` int(11) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
`host_name` int(11) NOT NULL,
`dependent_host_name` int(11) NOT NULL,
`dependency_period` varchar(75) COLLATE latin1_general_cs DEFAULT NULL,
`inherits_parent` tinyint(1) DEFAULT NULL,
`execution_failure_options` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`notification_failure_options` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `hostdependency`
--