[icinga-checkins] icinga.org: icinga-core/cmaser/fixes: fix typo in oracle upgrade 1.0. 2 fix object relations script

[git at icinga.org]

Module: icinga-core
Branch: cmaser/fixes
Commit: fae01ccfa3740a793b59e9b21a1925c84a968396
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=fae01ccfa3740a793b59e9b21a1925c84a968396

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Jun 24 16:21:00 2010 +0200

fix typo in oracle upgrade 1.0.2 fix object relations script

fixes #533

---

 .../oracle-upgrade-1.0.2-fix-object-relations.sql  |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/module/idoutils/db/oracle/oracle-upgrade-1.0.2-fix-object-relations.sql b/module/idoutils/db/oracle/oracle-upgrade-1.0.2-fix-object-relations.sql
index ecb12a9..78d5e85 100644
--- a/module/idoutils/db/oracle/oracle-upgrade-1.0.2-fix-object-relations.sql
+++ b/module/idoutils/db/oracle/oracle-upgrade-1.0.2-fix-object-relations.sql
@@ -197,7 +197,7 @@ SELECT i4.id FROM (
             FROM (
                   SELECT object_id AS o_id,
                          id AS hc_id
-                  FROM hostchecks i1
+                  FROM acknowledgements i1
             ) i2
            JOIN objects obj1
            ON i2.o_id=obj1.id