[icinga-checkins] icinga.org: icinga-core/dev/ido: idoutils: fix typo in sql #2274

git at icinga.org git at icinga.org
Mon Feb 6 15:54:48 CET 2012


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

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Fri Feb  3 20:09:57 2012 +0100

idoutils: fix typo in sql #2274
refs #2274

---

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

diff --git a/module/idoutils/db/mysql/mysql.sql b/module/idoutils/db/mysql/mysql.sql
index bc93d60..1bb38fd 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -1564,7 +1564,7 @@ CREATE INDEX loge_inst_id_time_idx on icinga_logentries (instance_id ASC, logent
 -- statehistory
 CREATE INDEX statehist_i_id_o_id_s_ty_s_ti on icinga_statehistory(instance_id, object_id, state_type, state_time);
 --#2274
-create index statehist_state_idx on icinga_statehistory(objectid,state);
+create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 
 -- SLA statehistory
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 996a86e..c246c51 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
@@ -10,7 +10,7 @@
 -- -----------------------------------------
 --#2274
 -- -----------------------------------------
-create index statehist_state_idx on icinga_statehistory(objectid,state);
+create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 -- -----------------------------------------
 -- update dbversion
diff --git a/module/idoutils/db/pgsql/pgsql.sql b/module/idoutils/db/pgsql/pgsql.sql
index 900c27c..ae6f5ca 100644
--- a/module/idoutils/db/pgsql/pgsql.sql
+++ b/module/idoutils/db/pgsql/pgsql.sql
@@ -1603,7 +1603,7 @@ CREATE INDEX services_combined_object_idx ON icinga_services(service_object_id,
 -- statehistory
 CREATE INDEX statehist_i_id_o_id_s_ty_s_ti on icinga_statehistory(instance_id, object_id, state_type, state_time);
 --#2274
-create index statehist_state_idx on icinga_statehistory(objectid,state);
+create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 -- SLA statehistory
 CREATE INDEX slahist_i_id_o_id_s_ti_s_s_ti_e on icinga_slahistory(instance_id,object_id,start_time,end_time);
diff --git a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
index 996a86e..c246c51 100644
--- a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
+++ b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
@@ -10,7 +10,7 @@
 -- -----------------------------------------
 --#2274
 -- -----------------------------------------
-create index statehist_state_idx on icinga_statehistory(objectid,state);
+create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 -- -----------------------------------------
 -- update dbversion





More information about the icinga-checkins mailing list