Index: openacs-4/packages/wiki/www/admin/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wiki/www/admin/Attic/index-oracle.xql,v
diff -u -N
--- openacs-4/packages/wiki/www/admin/index-oracle.xql	13 Jun 2005 09:50:05 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,117 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="get_folder_contents_paginate">      
-      <querytext>
-      
-  select
-    r.item_id, v.title, last_modified
-  from 
-    cr_resolved_items r, cr_items i, cr_folders f, cr_revisions v, 
-    cr_revisions u, acs_objects o
-  where
-    r.parent_id = :parent_id
-  and
-    r.resolved_id = i.item_id
-  and
-    i.item_id = o.object_id
-  and
-    i.latest_revision = v.revision_id (+)
-  and
-    i.live_revision = u.revision_id (+)
-  and
-    i.item_id = f.folder_id (+)
-   [template::list::orderby_clause -name folder_items -orderby]  
-
-      </querytext>
-</fullquery>
-
-<partialquery name="get_folder_contents">      
-      <querytext>
-
-  select
-    r.item_id, r.item_id as id, v.revision_id, r.resolved_id, r.is_symlink,
-    r.name, i.parent_id, i.content_type, i.publish_status, u.publish_date,
-    NVL(trim(
-      decode(o.object_type, 'content_symlink', r.label,
-			  'content_folder', f.label,
-			  nvl(v.title, i.name))),
-      '-') title,
-    o.object_type, t.pretty_name as pretty_content_type, last_modified, 
-    v.content_length
-  from 
-    cr_resolved_items r, cr_items i, cr_folders f, cr_revisions v, 
-    cr_revisions u, acs_objects o, acs_object_types t
-  where
-    r.parent_id = :parent_id
-  and
-    r.resolved_id = i.item_id
-  and
-    i.item_id = o.object_id
-  and
-    i.content_type = t.object_type
-  and
-    i.latest_revision = v.revision_id (+)
-  and
-    i.live_revision = u.revision_id (+)
-  and
-    i.item_id = f.folder_id (+)
-  and
-   [template::list::page_where_clause -and -name folder_items -key r.item_id]
-   [template::list::orderby_clause -name folder_items -orderby]
-  
-      </querytext>
-</partialquery>
-
-<fullquery name="get_resolved_id">      
-      <querytext>
-      
-    select content_symlink.resolve( :item_id ) from dual
-  
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="get_index_page_id">      
-      <querytext>
-      
-  select content_folder.get_index_page(:parent_id) from dual
-
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="get_symlinks">      
-      <querytext>
-      
-  select
-    i.item_id id,
-    content_item.get_path(i.item_id) path
-  from 
-    cr_items i, cr_symlinks s
-  where
-    i.item_id = s.target_id
-  and
-    i.item_id = :original_id
-
-      </querytext>
-</fullquery>
-
-<fullquery name="get_info">      
-      <querytext>
-      
-    select
-      parent_id, NVL(label, name) label, description
-    from
-      cr_items i, cr_folders f
-    where
-      i.item_id = f.folder_id
-    and
-      f.folder_id = :item_id
-  
-      </querytext>
-</fullquery>
- 
-</queryset>