Index: openacs-4/packages/forums/lib/message/content-updater-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/content-updater-oracle.xql,v
diff -u -N
--- openacs-4/packages/forums/lib/message/content-updater-oracle.xql	28 Jun 2006 20:30:28 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,46 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>   
-
-    <fullquery name="select_message_responses">
-        <querytext>
-            select message_id,
-                   0 as n_attachments,
-                   subject,
-                   content,
-                   format,
-                   person.name(user_id) as user_name,
-                   to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
-                   tree.tree_level(tree_sortkey) as tree_level,
-                   state,
-                   user_id,
-                   parent_id
-            from  $table_name
-            where forum_id = :forum_id
-            and   tree_sortkey between tree.left(:tree_sortkey) and tree.right(:tree_sortkey)
-            order by $order_by
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_message_responses_attachments">
-        <querytext>
-            select message_id,
-                   (select count(*) from attachments where object_id = message_id) as n_attachments,
-                   subject,
-                   content,
-                   format,
-                   person.name(user_id) as user_name,
-                   to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
-                   tree.tree_level(tree_sortkey) as tree_level,
-                   state,
-                   user_id,
-                   parent_id
-            from   $table_name
-            where  forum_id = :forum_id
-            and    tree_sortkey between tree.left(:tree_sortkey) and tree.right(:tree_sortkey)
-            order  by $order_by
-        </querytext>
-    </fullquery>
-
-</queryset>