Index: openacs-4/packages/contacts/sql/postgresql/contacts-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	4 Jun 2005 12:36:45 -0000	1.4
+++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	20 Jun 2005 16:48:36 -0000	1.5
@@ -95,6 +95,16 @@
         unique(party_id,title,signature)
 );
 
+create table contact_mailings (
+        mailing_id            integer
+                                constraint contact_mailings_id_pk primary key,
+        title                   varchar(255)
+                                constraint contact_mailings_title_nn not null,
+        mailing                 varchar(1000)
+                                constraint contact_mailings_mailing_nn not null
+        unique(party_id,title,mailing)
+);
+
 -- this view greatly simplifies getting available roles for various contact types
 create view contact_rel_types as 
 (    select rel_type,
