[icinga-checkins] icinga.org: icinga-core/test/cgis: idoutils: extend field agent_version for oracle and mysql, pgsql not affected #2104

[git at icinga.org]

Module: icinga-core
Branch: test/cgis
Commit: 122d27a0c0aa90a977516eec401363cae8b5212d
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=122d27a0c0aa90a977516eec401363cae8b5212d

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Mon Nov 21 20:48:17 2011 +0100

idoutils: extend field agent_version for oracle and mysql, pgsql not affected #2104
refs #2104

---

 module/idoutils/db/mysql/mysql.sql                 |    2 +-
 .../db/mysql/upgrade/mysql-upgrade-1.6.0.sql       |    5 +++++
 .../db/oracle/create_icinga_objects_oracle.sql     |    2 +-
 .../db/oracle/upgrade/oracle-upgrade-1.6.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 715aa41..69d8f06 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -152,7 +152,7 @@ CREATE TABLE IF NOT EXISTS icinga_conninfo (
   conninfo_id serial,
   instance_id bigint unsigned default 0,
   agent_name varchar(32) character set latin1  default '',
-  agent_version varchar(8) character set latin1  default '',
+  agent_version varchar(16) character set latin1  default '',
   disposition varchar(16) character set latin1  default '',
   connect_source varchar(16) character set latin1  default '',
   connect_type varchar(16) character set latin1  default '',
diff --git a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
index ef30957..6b6219d 100644
--- a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
+++ b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
@@ -14,6 +14,11 @@
 ALTER TABLE icinga_acknowledgements ADD end_time timestamp default '0000-00-00 00:00:00';
 
 -- -----------------------------------------
+-- extend conninfo.agent_version #2104
+-- -----------------------------------------
+ALTER TABLE icinga_conninfo modify agent_version varchar(16) default '';
+
+-- -----------------------------------------
 -- Table structure for table icinga_slahistory
 -- -----------------------------------------
 
diff --git a/module/idoutils/db/oracle/create_icinga_objects_oracle.sql b/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
index f52c298..a1b2465 100644
--- a/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
+++ b/module/idoutils/db/oracle/create_icinga_objects_oracle.sql
@@ -379,7 +379,7 @@ CREATE TABLE conninfo (
   id integer ,
   instance_id integer default 0 ,
   agent_name varchar2(32),
-  agent_version varchar2(8),
+  agent_version varchar2(16),
   disposition varchar2(16),
   connect_source varchar2(16),
   connect_type varchar2(16),
diff --git a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.6.0.sql b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.6.0.sql
index 0a88c4f..b7d9af5 100644
--- a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.6.0.sql
+++ b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.6.0.sql
@@ -35,6 +35,11 @@ spool oracle-upgrade-&&ICINGA_VERSION..log
 -- -----------------------------------------
 alter table acknowledgements add end_time TIMESTAMP(0) WITH LOCAL TIME ZONE default TO_TIMESTAMP_TZ('01.01.1970 UTC','DD.MM.YYYY TZR'); 
 
+-- -----------------------------------------
+-- extend conninfo.agent_version #2104
+-- -----------------------------------------
+alter table conninfo modify (agent_version varchar2(16));
+
 -- --------------------------------------------------------
 
 -- -----------------------------------------