[icinga-checkins] icinga.org: icinga-core/dev/ido: idoutils: enlarge field FAILURE_PREDICTION_OPTIONS from 64 to 128 in table hosts for mysql and oracle . pgsql is not affected #2479

git at icinga.org git at icinga.org
Mon Apr 2 16:44:00 CEST 2012


Module: icinga-core
Branch: dev/ido
Commit: 76b5ab599e3bd1652f9b817d1c523d98e644eefe
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=76b5ab599e3bd1652f9b817d1c523d98e644eefe

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Sun Apr  1 20:48:03 2012 +0200

idoutils: enlarge field FAILURE_PREDICTION_OPTIONS from 64 to 128 in table hosts for mysql and oracle. pgsql is not affected #2479
refs #2479

---

 module/idoutils/db/mysql/mysql.sql                 |    2 +-
 .../db/mysql/upgrade/mysql-upgrade-1.7.0.sql       |    5 +++++
 .../db/oracle/create_icinga_objects_oracle.sql     |    2 +-
 .../db/oracle/upgrade/oracle-upgrade-1.7.0.sql     |    5 +++++
 4 files changed, 12 insertions(+), 2 deletions(-)

diff --git a/module/idoutils/db/mysql/mysql.sql b/module/idoutils/db/mysql/mysql.sql
index 3aed2f2..b4da89c 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -635,7 +635,7 @@ CREATE TABLE IF NOT EXISTS icinga_hosts (
   eventhandler_command_args varchar(255) character set latin1  default '',
   notification_timeperiod_object_id bigint unsigned default 0,
   check_timeperiod_object_id bigint unsigned default 0,
-  failure_prediction_options varchar(64) character set latin1  default '',
+  failure_prediction_options varchar(128) character set latin1  default '',
   check_interval double  default '0',
   retry_interval double  default '0',
   max_check_attempts smallint default 0,
diff --git a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.7.0.sql b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.7.0.sql
index 9c73090..fff7762 100644
--- a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.7.0.sql
+++ b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.7.0.sql
@@ -13,6 +13,11 @@
 create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 -- -----------------------------------------
+--#2479
+-- -----------------------------------------
+alter table icinga_hosts modify FAILURE_PREDICTION_OPTIONS varchar(128) ;
+
+-- -----------------------------------------
 -- update dbversion
 -- -----------------------------------------
 
diff --git a/module/idoutils/db/oracle/create_icinga_objects_oracle.sql b/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
index 1a02ecb..91058d6 100644
--- a/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
+++ b/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
@@ -998,7 +998,7 @@ CREATE TABLE hosts (
   eventhandler_command_args varchar2(1024),
   notif_timeperiod_object_id integer default 0 , 
   check_timeperiod_object_id integer default 0 ,
-  failure_prediction_options varchar2(64),
+  failure_prediction_options varchar2(128),
   check_interval number default 0 ,
   retry_interval number default 0 ,
   max_check_attempts integer default 0 ,
diff --git a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.7.0.sql b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.7.0.sql
index b1b397a..0a0e9db 100644
--- a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.7.0.sql
+++ b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.7.0.sql
@@ -40,6 +40,11 @@ create index statehistory_state_idx on statehistory(object_id,state)
 tablespace &IDXTBS;
 
 -- -----------------------------------------
+-- enlarge FAILURE_PREDICTION_OPTIONS #2479
+-- -----------------------------------------
+alter table hosts modify (FAILURE_PREDICTION_OPTIONS varchar2(128));
+
+-- -----------------------------------------
 -- finally update dbversion
 -- -----------------------------------------
 





More information about the icinga-checkins mailing list