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.3 -r1.4
--- openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	14 Jun 2005 06:21:48 -0000	1.3
+++ openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	14 Jun 2005 06:51:54 -0000	1.4
@@ -19,6 +19,7 @@
         object_type             varchar(1000)
                                 constraint contact_searches_object_type_nn not null,
         deleted_p               boolean default 'f'
+                                constraint contact_searches_deleted_p_nn not null
 );
 
 -- create the content type
@@ -90,7 +91,7 @@
     insert into contact_searches
     (search_id,title,owner_id,all_or_any,object_type,deleted_p)
     values
-    (v_search_id,p_title,p_owner_id,p_all_or_any,p_object_type,deleted_p);
+    (v_search_id,p_title,p_owner_id,p_all_or_any,p_object_type,p_deleted_p);
 
     return v_search_id;
 
