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.5 -r1.6
--- openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	14 Jun 2005 07:25:18 -0000	1.5
+++ openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	8 Sep 2005 18:14:00 -0000	1.6
@@ -144,3 +144,17 @@
 
     return ''1'';
 end;' language 'plpgsql';
+
+
+-- Create a sequence and a table for extended searches.
+
+create sequence contact_extend_search_seq;
+
+create table contact_extend_options (
+	extend_id 	integer
+			constraint contact_extend_options_pk primary key,
+	var_name	varchar(100) unique not null,
+	pretty_name	varchar(100) not null,
+	subquery 	varchar(5000) not null,
+	description     varchar(500)
+);
\ No newline at end of file
