# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1271767980 0
# Node ID 74608c12b4fe9a17f6f9e870aa66ca0c7852c0fc
# Parent  4bae3081eb1e5da351d1ce567c7054963704d409
Added Query for the CacheCleaner that it use to determin which Tables has been updated.

gnv-artifacts/trunk@960 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 4bae3081eb1e -r 74608c12b4fe gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Tue Apr 20 10:11:28 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Tue Apr 20 12:53:00 2010 +0000
@@ -1,3 +1,9 @@
+2010-04-20  Tim Englich  <tim.englich@intevation.de>
+
+	* doc/conf/queries.properties: 
+	  Added Query for the CacheCleaner that it use to determin which Tables has 
+	  been updated.
+
 2010-04-20  Ingo Weinzierl <ingo.weinzierl@intevation.de>
 
 	* src/main/java/de/intevation/gnv/state/profile/horizontalcrosssection/HorizontalCrossSectionMeshOutputState.java:
diff -r 4bae3081eb1e -r 74608c12b4fe gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Tue Apr 20 10:11:28 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Tue Apr 20 12:53:00 2010 +0000
@@ -1401,4 +1401,8 @@
     from sde.geometry_columns \
     where f_table_schema = '?' and \
           f_table_name = '?' and \
-          f_geometry_column='SHAPE'
\ No newline at end of file
+          f_geometry_column='SHAPE'
+          
+updated_tables = SELECT FULLTABLENAME \
+    FROM MEDIAN.LASTUPDATED \
+    WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS')
\ No newline at end of file