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.3 -r1.4 --- openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql 30 Apr 2006 09:27:41 -0000 1.3 +++ openacs-4/packages/lab-report-central/sql/postgresql/lab-report-central-create.sql 30 Apr 2006 12:01:30 -0000 1.4 @@ -150,7 +150,18 @@ on delete cascade ); +create table lrc_lab_student_map ( + lab_id integer + constraint lrc_lab_student_map_lab_id_fk + references lrc_lab (lab_id) + on delete cascade, + user_id integer + constraint lrc_lab_student_map_user_id_fk + references users (user_id) + on delete cascade +); + -- -- Create functions --