Index: openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/sql/postgresql/Attic/general-comments-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql 5 May 2003 01:14:18 -0000 1.2 +++ openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql 5 May 2003 01:21:05 -0000 1.3 @@ -18,7 +18,10 @@ primary key, object_id integer constraint general_comments_object_id_fk references acs_objects (object_id) on delete cascade, + package_id integer constraing general_comments_package_id_fk + references apm_packages (package_id) on delete cascade ); + comment on table general_comments is ' Extends the cr_revisions table to hold item level data. '; Index: openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/sql/postgresql/Attic/general-comments-plsql-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql 5 May 2003 01:14:18 -0000 1.1 +++ openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql 5 May 2003 01:21:05 -0000 1.2 @@ -7,13 +7,14 @@ declare p_comment_id alias for $1; p_object_id alias for $2; - p_parent_id alias for $3; - p_context_id alias for $4; - p_title alias for $5; - p_content alias for $6; - p_creation_user alias for $7; - p_creation_date alias for $8; - p_creation_ip alias for $9; + p_package_id alias for $3; + p_parent_id alias for $4; + p_context_id alias for $5; + p_title alias for $6; + p_content alias for $7; + p_creation_user alias for $8; + p_creation_date alias for $9; + p_creation_ip alias for $10; v_item_id cr_items.item_id%TYPE; begin v_item_id := content_item__new(