Index: openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	8 Sep 2005 18:14:00 -0000	1.6
+++ openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	12 Sep 2005 14:12:22 -0000	1.7
@@ -157,4 +157,20 @@
 	pretty_name	varchar(100) not null,
 	subquery 	varchar(5000) not null,
 	description     varchar(500)
+);
+
+-- Creates a table to map contact_extend_options(extend_id)'s to 
+-- contact_searches(search_id)
+
+create table contact_search_extend_map (
+	search_id	integer
+			constraint contact_search_extend_map_search_id_fk
+			references contact_searches (search_id)
+			on delete cascade,
+	extend_id	integer
+			constraint contact_search_extend_map_extend_id_fk
+			references contact_extend_options (extend_id)
+			on delete cascade,
+			constraint contact_search_extend_map_pk
+			primary key (search_id,extend_id)
 );
\ No newline at end of file