[icinga-checkins] icinga.org: icinga-web/master: Use upref_id instead of upref_modified to fix pgsql data (refs #3868)

git at icinga.org git at icinga.org
Thu Apr 4 11:52:51 CEST 2013


Module: icinga-web
Branch: master
Commit: c68f59469edc1ccd770f3f8e5be24a647db7ec33
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=c68f59469edc1ccd770f3f8e5be24a647db7ec33

Author: Markus Frosch <markus at lazyfrosch.de>
Date:   Mon Mar 25 14:49:25 2013 +0100

Use upref_id instead of upref_modified to fix pgsql data (refs #3868)

---

 .../updates/pgsql/pgsql_v1-8-1_to_v1-8-3.sql       |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/etc/schema/updates/pgsql/pgsql_v1-8-1_to_v1-8-3.sql b/etc/schema/updates/pgsql/pgsql_v1-8-1_to_v1-8-3.sql
index e2e7f4c..0e3c0d5 100644
--- a/etc/schema/updates/pgsql/pgsql_v1-8-1_to_v1-8-3.sql
+++ b/etc/schema/updates/pgsql/pgsql_v1-8-1_to_v1-8-3.sql
@@ -26,8 +26,8 @@ SELECT
     upref_created,
     upref_modified
 FROM nsm_user_preference_trans t
-WHERE upref_modified = (
-    SELECT MAX(upref_modified)
+WHERE upref_id = (
+    SELECT MAX(upref_id)
     FROM nsm_user_preference_trans t2
     WHERE t.upref_key = t2.upref_key
       and t.upref_user_id = t2.upref_user_id





More information about the icinga-checkins mailing list