Index: openacs-4/packages/download/sql/postgresql/download-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-create.sql,v
diff -u -N -r1.7 -r1.7.4.1
--- openacs-4/packages/download/sql/postgresql/download-create.sql	12 Mar 2004 19:19:47 -0000	1.7
+++ openacs-4/packages/download/sql/postgresql/download-create.sql	2 Nov 2005 01:29:38 -0000	1.7.4.1
@@ -331,14 +331,15 @@
               da.archive_id, 
 			  da.archive_type_id, 
 			  da.archive_desc_id,
-              desc_item.title as summary, 
-			  desc_item.description as description, 
-			  desc_item.mime_type as description_type,
-              desc_item.creation_user, 
-			  desc_item.creation_date, 
-			  desc_item.creation_ip 
-       from download_archives da, cr_items cri, download_archive_descsi desc_item
-	   where da.archive_desc_id = desc_item.revision_id and 
+              crr.title as summary, 
+			  crr.description as description, 
+			  crr.mime_type as description_type,
+              o.creation_user, 
+			  o.creation_date, 
+			  o.creation_ip 
+       from download_archives da, cr_items cri, cr_revisions crr, acs_objects o
+	   where da.archive_desc_id = crr.revision_id and 
+                         da.archive_desc_id = o.object_id and
 			 da.archive_id = cri.item_id;
 
 create view download_arch_revisions_obj as