Index: openacs-4/packages/bookmarks/tcl/bookmarks-init-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/tcl/bookmarks-init-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/bookmarks/tcl/bookmarks-init-oracle.xql 2 Jun 2001 07:33:06 -0000 1.1
+++ openacs-4/packages/bookmarks/tcl/bookmarks-init-oracle.xql 25 Sep 2003 17:07:09 -0000 1.2
@@ -13,32 +13,7 @@
-
-
-
-
- select b.bookmark_id,
- b.url_id,
- b.local_title,
- acs_objects.creation_date,
- b.parent_id,
- bm_urls.complete_url,
- b.folder_p
- from (select /*+INDEX(bm_bookmarks bm_bookmarks_local_title_idx)*/ bookmark_id, url_id, local_title, folder_p, level lev,
- parent_id, owner_id, rownum ord_num from bm_bookmarks
- start with parent_id = :root_folder_id connect by prior bookmark_id = parent_id) b,
- bm_urls,
- acs_objects
- where owner_id = :user_id
- and acs_objects.object_id = b.bookmark_id
- and b.url_id = bm_urls.url_id(+)
- order by ord_num
-
-
-
-
-
delete from bm_in_closed_p where creation_date < (sysdate - 1)