From 324a2c25e8df062b24360fb27e78866cac780ece Mon Sep 17 00:00:00 2001 From: Michael Friedrich Date: Mon, 10 Mar 2014 17:15:03 +0100 Subject: [PATCH] Prepare schema for endpoint object id (tbd). Refs #5636 --- components/db_ido_mysql/schema/upgrade/0.0.8.sql | 6 ++++++ components/db_ido_pgsql/schema/upgrade/0.0.8.sql | 7 +++++++ 2 files changed, 13 insertions(+) diff --git a/components/db_ido_mysql/schema/upgrade/0.0.8.sql b/components/db_ido_mysql/schema/upgrade/0.0.8.sql index 73ce7bc4d..2f17058fd 100644 --- a/components/db_ido_mysql/schema/upgrade/0.0.8.sql +++ b/components/db_ido_mysql/schema/upgrade/0.0.8.sql @@ -51,6 +51,12 @@ CREATE TABLE IF NOT EXISTS icinga_endpointstatus ( ALTER TABLE icinga_servicestatus ADD COLUMN endpoint_object_id bigint default NULL; ALTER TABLE icinga_hoststatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_contactstatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_programstatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_comments ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_scheduleddowntime ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_runtimevariables ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_customvariablestatus ADD COLUMN endpoint_object_id bigint default NULL; ALTER TABLE icinga_acknowledgements ADD COLUMN endpoint_object_id bigint default NULL; ALTER TABLE icinga_commenthistory ADD COLUMN endpoint_object_id bigint default NULL; diff --git a/components/db_ido_pgsql/schema/upgrade/0.0.8.sql b/components/db_ido_pgsql/schema/upgrade/0.0.8.sql index e443de08d..0ac267ee2 100644 --- a/components/db_ido_pgsql/schema/upgrade/0.0.8.sql +++ b/components/db_ido_pgsql/schema/upgrade/0.0.8.sql @@ -45,6 +45,13 @@ CREATE TABLE IF NOT EXISTS icinga_endpointstatus ( ALTER TABLE icinga_servicestatus ADD COLUMN endpoint_object_id bigint default NULL; ALTER TABLE icinga_hoststatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_contactstatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_programstatus ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_comments ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_scheduleddowntime ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_runtimevariables ADD COLUMN endpoint_object_id bigint default NULL; +ALTER TABLE icinga_customvariablestatus ADD COLUMN endpoint_object_id bigint default NULL; + ALTER TABLE icinga_acknowledgements ADD COLUMN endpoint_object_id bigint default NULL; ALTER TABLE icinga_commenthistory ADD COLUMN endpoint_object_id bigint default NULL; -- 2.40.0