Index: openacs-4/packages/download/download.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/download.info,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/download/download.info	24 Jun 2015 05:23:22 -0000	1.15
+++ openacs-4/packages/download/download.info	25 Jul 2015 17:58:28 -0000	1.16
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
 
-    <version name="5.2d3" url="http://openacs.org/repository/download/apm/download-5.2d3.apm">
+    <version name="5.2d4" url="http://openacs.org/repository/download/apm/download-5.2d4.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -19,7 +19,7 @@
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/plain">Intended to support downloads of versioned software and packages.  UI needs work.</description>
 
-        <provides url="download" version="5.2d3"/>
+        <provides url="download" version="5.2d4"/>
         <requires url="acs-kernel" version="5.2.0a1"/>
         <requires url="acs-content-repository" version="5.2.0a3"/>
 
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 -r1.9 -r1.10
--- openacs-4/packages/download/sql/postgresql/download-create.sql	16 Sep 2013 09:19:58 -0000	1.9
+++ openacs-4/packages/download/sql/postgresql/download-create.sql	25 Jul 2015 17:58:28 -0000	1.10
@@ -313,7 +313,7 @@
        select repository_id, 
                  o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
                  o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
-                 o.modifying_ip, o.tree_sortkey, o.max_child_sortkey,
+                 o.modifying_ip, 
 	          i.parent_id, 
 			  r.title, 
 			  r.description, 
@@ -346,7 +346,7 @@
        select dar.*, 
                           o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
                           o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
-                          o.modifying_ip, o.tree_sortkey, o.max_child_sortkey,
+                          o.modifying_ip, 
 			  r.item_id as archive_id, 
 			  r.title as file_name, 
 			  r.description as version_name, 
Index: openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql	25 Jul 2015 17:58:28 -0000	1.1
@@ -0,0 +1,28 @@
+create or replace view download_repository_obj as
+select repository_id, 
+                 o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
+                 o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
+                 o.modifying_ip, 
+                  i.parent_id, 
+                          r.title, 
+                          r.description, 
+                          r.content as help_text
+       from download_repository dr, acs_objects o, cr_items i, cr_revisions r
+           where dr.repository_id = o.object_id
+	   and i.item_id = o.object_id
+	   and r.revision_id = i.live_revision;
+
+create or replace view download_arch_revisions_obj as
+select dar.*, 
+                          o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
+                          o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
+                          o.modifying_ip, 
+                          r.item_id as archive_id, 
+                          r.title as file_name, 
+                          r.description as version_name, 
+                          r.publish_date, 
+                          r.mime_type, 
+                          r.content
+       from download_archive_revisions dar, acs_objects o, cr_revisions r
+           where dar.revision_id = o.object_id
+	   and   dar.revision_id = r.revision_id;