# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1235862580 -3600
# Node ID 8ff28129e29c13adbe3efe3a973abba6bfbde5bf
# Parent  ac275328dab590f4f7da910564eb609eb7b60720
Řazení v souhrnu podle data posledního útoku

diff -r ac275328dab5 -r 8ff28129e29c java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml
--- a/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml	Sat Feb 28 21:50:25 2009 +0100
+++ b/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml	Sun Mar 01 00:09:40 2009 +0100
@@ -18,6 +18,7 @@
         WHERE   den >= date_trunc('day', ?::date)
                 AND den <= date_trunc('day', ?::date)
         GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
+        ORDER BY max(den) DESC
         ]]>
     </entry>
     <entry key="DENNI_SOUHRN_CIL">
@@ -38,6 +39,7 @@
                 AND den <= date_trunc('day', ?::date)
                 AND cil = ?
         GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
+        ORDER BY max(den) DESC
         ]]>
     </entry>
 </properties>
\ No newline at end of file