Index: openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql 24 Apr 2006 11:27:03 -0000 1.1 +++ openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql 27 Apr 2006 04:34:33 -0000 1.2 @@ -135,6 +135,17 @@ on delete cascade ); +create table lrc_lab_template_map ( + lab_id integer + constraint lrc_lt_map_lab_id_fk + references lrc_lab (lab_id) + on delete cascade, + template_id integer + constraint lrc_lt_map_template_id_fk + references lrc_template (template_id) + on delete cascade +); + create table lrc_template_section_map ( template_id integer constraint lrc_ts_map_template_id_fk