Index: openacs-4/packages/lab-report/sql/postgresql/lab-report-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report/sql/postgresql/lab-report-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lab-report/sql/postgresql/lab-report-create.sql 12 May 2006 01:34:34 -0000 1.2 +++ openacs-4/packages/lab-report/sql/postgresql/lab-report-create.sql 21 May 2006 05:29:44 -0000 1.3 @@ -105,6 +105,10 @@ constraint lr_section_content_section_id_fk references lrc_section (section_id) on delete cascade, + package_id integer + constraint lr_section_content_package_id_fk + references apm_packages (package_id) + on delete cascade, content text ); @@ -213,11 +217,13 @@ content_id, report_id, section_id, + package_id, content ) VALUES ( v_content_id, p_report_id, p_section_id, + p_package_id, p_content );