Index: openacs-4/packages/lorsm/lib/user-lorsm-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/lib/Attic/user-lorsm-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/lorsm/lib/user-lorsm-postgresql.xql	22 Nov 2006 12:09:14 -0000	1.1.2.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+<fullquery name="query">
+  <querytext>
+	select cpr.man_id, cpr.res_id, 'delivery' as needscorte
+	from ims_cp_resources cpr
+	where cpr.man_id = :man_id 
+	order by cpr.scorm_type desc limit 1
+  </querytext>
+</fullquery>
+
+<fullquery name="get_last_viewed">
+  <querytext>
+            select v.last_viewed
+              from views_views v,
+                   ims_cp_items i,
+                   ims_cp_organizations o
+             where v.viewer_id = :user_id
+               and v.object_id = i.ims_item_id
+               and i.org_id = o.org_id
+               and o.man_id = :man_id
+            order by v.last_viewed desc
+            limit 1
+  </querytext>
+</fullquery>
+
+</queryset>
\ No newline at end of file