Index: openacs-4/packages/survey-reports/sql/postgresql/survey-reports-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey-reports/sql/postgresql/survey-reports-create.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/survey-reports/sql/postgresql/survey-reports-create.sql	14 Nov 2005 04:31:01 -0000	1.2
@@ -0,0 +1,23 @@
+-- 
+-- packages/survey/sql/postgresql/survey-reports-create.sql
+-- 
+-- @author Deds Castillo (deds@i-manila.com.ph)
+-- @creation-date 2004-10-21
+-- @arch-tag: 3e2487d0-6986-4257-ba5e-a352d23a0c8e
+-- @cvs-id $Id: survey-reports-create.sql,v 1.2 2005/11/14 04:31:01 daveb Exp $
+--
+
+create table survey_reports_survey_map (
+    template_id integer
+                constraint surv_rep_surv_map_template_id_fk
+                references cr_items
+                on delete cascade,
+    survey_id   integer
+                constraint surv_rep_surv_map_survey_id_fk
+                references surveys
+                on delete cascade,
+                primary key (template_id, survey_id),
+    survey_variables_p boolean,
+    survey_show_report_p boolean
+);
+