[icinga-checkins] icinga.org: icinga-core/test/ido: revert TEXT for mysql configfile_path, as this is a unique constraint member

git at icinga.org git at icinga.org
Sun Apr 29 09:49:43 CEST 2012


Module: icinga-core
Branch: test/ido
Commit: 0b9ef1ac2c726d0f9e2126dfb8293aaffc0dda53
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=0b9ef1ac2c726d0f9e2126dfb8293aaffc0dda53

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Apr 27 11:16:29 2012 +0200

revert TEXT for mysql configfile_path, as this is a unique constraint member

more on the issue itsself.

fixes #2181

---

 module/idoutils/db/mysql/mysql.sql                 |    2 +-
 .../db/mysql/upgrade/mysql-upgrade-1.7.0.sql       |    3 ---
 2 files changed, 1 insertions(+), 4 deletions(-)

diff --git a/module/idoutils/db/mysql/mysql.sql b/module/idoutils/db/mysql/mysql.sql
index bc346f9..617973b 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -122,7 +122,7 @@ CREATE TABLE IF NOT EXISTS icinga_configfiles (
   configfile_id serial,
   instance_id bigint unsigned default 0,
   configfile_type smallint default 0,
-  configfile_path TEXT character set latin1  default '',
+  configfile_path varchar(255) character set latin1  default '',
   PRIMARY KEY  (configfile_id),
   UNIQUE KEY instance_id (instance_id,configfile_type,configfile_path)
 ) ENGINE=InnoDB  COMMENT='Configuration files';
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 0757e99..bed08e8 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
@@ -42,9 +42,6 @@ alter table icinga_commenthistory modify comment_data TEXT;
 -- comments
 alter table icinga_comments modify comment_data TEXT;
 
--- configfiles
-alter table icinga_configfiles modify configfile_path TEXT;
-
 -- configfilevariables
 alter table icinga_configfilevariables modify varvalue TEXT;
 





More information about the icinga-checkins mailing list