Index: openacs-4/packages/download/sql/oracle/download-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/oracle/download-packages.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/download/sql/oracle/download-packages.sql	30 Sep 2003 12:10:07 -0000	1.2
+++ openacs-4/packages/download/sql/oracle/download-packages.sql	24 Mar 2004 03:18:19 -0000	1.3
@@ -38,6 +38,7 @@
     creation_user	in acs_objects.creation_user%TYPE default null,
     parent_id           in cr_items.parent_id%TYPE default null,
     context_id          in acs_objects.context_id%TYPE default null,
+    package_id          in acs_objects.package_id%TYPE default null,
     creation_ip	        in acs_objects.creation_ip%TYPE default null
   ) return download_repository.repository_id%TYPE;
 
@@ -71,6 +72,7 @@
     creation_user	in acs_objects.creation_user%TYPE default null,
     parent_id           in cr_items.parent_id%TYPE default null,
     context_id          in acs_objects.context_id%TYPE default null,
+    package_id          in acs_objects.package_id%TYPE default null,
     creation_ip	        in acs_objects.creation_ip%TYPE default null
   ) return download_repository.repository_id%TYPE
   is
@@ -84,6 +86,7 @@
       name => v_name,
       parent_id => new.parent_id,
       context_id => new.context_id,
+      package_id => new.package_id,
       title => new.title,
       description => new.description,
       text => new.help_text,
Index: openacs-4/packages/download/sql/postgresql/download-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-packages.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/download/sql/postgresql/download-packages.sql	17 May 2003 10:28:58 -0000	1.6
+++ openacs-4/packages/download/sql/postgresql/download-packages.sql	24 Mar 2004 03:18:19 -0000	1.7
@@ -36,7 +36,7 @@
 --   -set_metadata_value
 --   -downloaded_by
 
-create function download_rep__new (integer,varchar,varchar,varchar,timestamptz,integer,integer,integer,varchar)
+create function download_rep__new (integer,varchar,varchar,varchar,timestamptz,integer,integer,integer,integer,varchar)
 returns integer as '
 declare
 	new__repository_id			alias for $1;
@@ -47,7 +47,8 @@
 	new__creation_user			alias for $6;  -- default null
 	new__parent_id				alias for $7;  -- default null
 	new__context_id				alias for $8;  -- default null
-	new__creation_ip			alias for $9;  -- default null
+        new__package_id                         alias for $9;  -- default null
+	new__creation_ip			alias for $10;  -- default null
     v_name						cr_items.name%TYPE;
     v_repository_id				integer;
 	v_revision_id				integer;
@@ -69,7 +70,8 @@
 		''text/plain'',			-- mime_type
 		null,					-- nls_language
 		new__help_text,
-		''text''				-- storage_type (vk - not sure about this)
+		''text'',				-- storage_type (vk - not sure about this)
+                new__package_id
 	);
 
     insert into download_repository
Index: openacs-4/packages/download/www/admin/repository-ae-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/repository-ae-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/download/www/admin/repository-ae-oracle.xql	10 May 2001 20:51:30 -0000	1.1
+++ openacs-4/packages/download/www/admin/repository-ae-oracle.xql	24 Mar 2004 03:18:19 -0000	1.2
@@ -15,6 +15,7 @@
                              help_text => :help_text,
                              creation_user => :user_id,
                              parent_id => :package_id,
+                             package_id => :package_id,
                              context_id => :package_id);
                     end;
         
Index: openacs-4/packages/download/www/admin/repository-ae-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/repository-ae-postgresql.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/download/www/admin/repository-ae-postgresql.xql	14 May 2001 20:31:42 -0000	1.3
+++ openacs-4/packages/download/www/admin/repository-ae-postgresql.xql	24 Mar 2004 03:18:19 -0000	1.4
@@ -14,6 +14,7 @@
 			:user_id,
 			:package_id,
 			:package_id,
+			:package_id,
 			null
 		  );
       </querytext>