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