Index: openacs-4/packages/robot-detection/robot-detection.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/robot-detection.info,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/robot-detection/robot-detection.info	2 May 2001 20:36:12 -0000	1.2
+++ openacs-4/packages/robot-detection/robot-detection.info	3 May 2001 20:00:49 -0000	1.3
@@ -29,6 +29,8 @@
             <file type="query_file" path="tcl/robot-detection-init.xql"/>
             <file type="tcl_procs" path="tcl/robot-detection-procs.tcl"/>
             <file type="query_file" path="tcl/robot-detection-procs.xql"/>
+            <file type="query_file"  db_type="postgresql" path="tcl/robot-detection-procs-postgresql.xql"/>
+            <file type="query_file"  db_type="oracle" path="tcl/robot-detection-procs-oracle.xql"/>
             <file type="content_page" path="www/admin/index.adp"/>
             <file type="content_page"  path="www/admin/index.tcl"/>
             <file type="query_file" path="www/admin/index.xql"/>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql	3 May 2001 20:00:36 -0000	1.1
@@ -0,0 +1,10 @@
+<?xml version="1.0"?>
+<queryset>
+ 
+<fullquery name="ad_update_robot_list.days_since_last_update">      
+      <querytext>
+	    select trunc(sysdate - max(nvl(modified_date, insertion_date))) from robots
+      </querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql	3 May 2001 20:00:36 -0000	1.1
@@ -0,0 +1,10 @@
+<?xml version="1.0"?>
+<queryset>
+ 
+<fullquery name="ad_update_robot_list.days_since_last_update">      
+      <querytext>
+		select trunc(current_time - max(coalesce(modified_date, insertion_date))) from robots
+      </querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql	2 May 2001 20:36:38 -0000	1.1
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql	3 May 2001 20:00:36 -0000	1.2
@@ -49,12 +49,4 @@
 </fullquery>
 
  
-<fullquery name="ad_update_robot_list.days_since_last_update">      
-      <querytext>
-      
-		select trunc(current_time - max(coalesce(modified_date, insertion_date))) from robots
-      </querytext>
-</fullquery>
-
- 
 </queryset>