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)