Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	24 Oct 2001 19:03:54 -0000	1.13
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	30 Oct 2001 19:58:59 -0000	1.14
@@ -223,4 +223,27 @@
 );
 
 
+-- This table maps the datasources that are available for portals to
+-- bind to (i.e. creating a PE). This table is required since some DSs
+-- will not make sense for every portal. A "current time" DS will make
+-- sense for every portal, but a bboard DS may not, and we don't want
+-- to confuse everyone with DSs that don't make sense for the given
+-- portal
 
+create table portal_datasource_avail_map (
+	portal_datasource_id	integer
+				constraint p_ds_a_map_p_ds_id_pk
+				primary key,
+	portal_id		constraint p_ds_a_map_portal_id_fk
+				references portals on delete cascade
+				not null,
+	datasource_id		constraint p_ds_a_map_datasource_id_fk
+				references portal_datasources
+				on delete cascade
+				not null,
+ 	-- DSs are unique per-portal
+	constraint p_ds_a_map_pid_ds_un 
+	unique(portal_id,datasource_id)
+);
+
+