Index: openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql 21 Dec 2002 22:29:50 -0000 1.4
+++ openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql 25 Sep 2003 17:08:22 -0000 1.5
@@ -14,31 +14,6 @@
-
-
-
-
- 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 bm.bookmark_id, bm.url_id, bm.local_title, bm.folder_p,
- bm.parent_id, bm.owner_id, bm.tree_sortkey from bm_bookmarks bm, bm_bookmarks bm2
- where bm2.bookmark_id = :root_folder_id
- and bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey)
- ) b left join bm_urls using (url_id),
- acs_objects
- where owner_id = :user_id
- and acs_objects.object_id = b.bookmark_id
- order by b.tree_sortkey
-
-
-
-
-
delete from bm_in_closed_p where creation_date < (current_timestamp - interval '1 day')