Index: openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql	13 Feb 2006 01:30:07 -0000	1.2
+++ openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql	17 Feb 2006 12:50:05 -0000	1.3
@@ -19,7 +19,7 @@
      <querytext>
        SELECT map.map_id, n.uos_code, n.uos_name, uos.uos_id,
            rev.year_id, y.name, rev.core_id,
-	   map.live_revision_id, uosr.session_ids
+	   map.live_revision_id, uosr.session_ids, uos.uos_name_id
        FROM cc_uos uos, cc_uos_revisions uosr, cc_stream_uos_map map,
            cc_stream_uos_map_rev rev, cc_year y, cc_uos_name n
        WHERE uos.uos_id = map.uos_id
@@ -38,4 +38,14 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="requisites">
+     <querytext>
+       SELECT rev.prerequisite_ids, rev.assumed_knowledge_ids,
+           rev.corequisite_ids, rev.prohibition_ids, rev.no_longer_offered_ids
+       FROM cc_uos u, cc_uos_revisions rev
+       WHERE u.uos_id = :requisites_id
+       AND u.live_revision_id = rev.uos_revision_id
+     </querytext>
+   </fullquery>
+
 </queryset>