Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v diff -u -r1.9 -r1.9.4.1 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 28 Aug 2003 09:45:29 -0000 1.9 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 19 Feb 2005 18:24:09 -0000 1.9.4.1 @@ -388,7 +388,7 @@ 'content_revision.revision_name' ); -select define_function_args ('bt_bug__new','bug_id,bug_number,package_id,component_id,found_in_version,summary,user_agent,comment_content,comment_formt,creation_date,creation_user,creation_ip,item_subtype;bt_bug,content_type;bt_bug_revision'); +select define_function_args ('bt_bug__new','bug_id,bug_number,package_id,component_id,found_in_version,summary,user_agent,comment_content,comment_formt,creation_date,creation_user,creation_ip,fix_for_version,item_subtype;bt_bug,content_type;bt_bug_revision'); create or replace function bt_bug__new( integer, -- bug_id @@ -403,6 +403,7 @@ timestamptz, -- creation_date integer, -- creation_user varchar, -- creation_ip + integer, -- fix_for_version varchar, -- item_subtype varchar -- content_type ) returns int @@ -420,9 +421,10 @@ p_creation_date alias for $10; p_creation_user alias for $11; p_creation_ip alias for $12; - p_item_subtype alias for $13; - p_content_type alias for $14; - + p_fix_for_version alias for $13; + p_item_subtype alias for $14; + p_content_type alias for $15; + v_bug_id integer; v_revision_id integer; v_bug_number integer; @@ -465,24 +467,24 @@ -- create the item type row insert into bt_bugs - (bug_id, bug_number, comment_content, comment_format, parent_id, project_id, creation_date, creation_user) + (bug_id, bug_number, comment_content, comment_format, parent_id, project_id, creation_date, creation_user, fix_for_version) values - (v_bug_id, v_bug_number, p_comment_content, p_comment_format, v_folder_id, p_package_id, p_creation_date, p_creation_user); + (v_bug_id, v_bug_number, p_comment_content, p_comment_format, v_folder_id, p_package_id, p_creation_date, p_creation_user, p_fix_for_version); -- create the initial revision v_revision_id := bt_bug_revision__new( null, -- bug_revision_id v_bug_id, -- bug_id p_component_id, -- component_id p_found_in_version, -- found_in_version - null, -- fix_for_version + p_fix_for_version, -- fix_for_version null, -- fixed_in_version null, -- resolution p_user_agent, -- user_agent p_summary, -- summary p_creation_date, -- creation_date p_creation_user, -- creation_user - p_creation_ip -- creation_ip + p_creation_ip, -- creation_ip ); return v_bug_id; @@ -543,7 +545,7 @@ varchar, -- summary timestamptz, -- creation_date integer, -- creation_user - varchar -- creation_ip + varchar -- creation_ip ) returns int as ' declare