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 -N -r1.8 -r1.9
--- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	28 Jul 2005 13:41:50 -0000	1.8
+++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	8 Aug 2005 21:53:12 -0000	1.9
@@ -129,6 +129,27 @@
 );
 
 
+
+create table contact_complaint_tracking (
+	complaint_id    integer
+			constraint contact_complaint_tracking_pk 
+			primary key
+			constraint contact_complaint_tracking_fk
+			references cr_revisions(revision_id)
+			on delete cascade,
+	customer_id 	integer
+			constraint contact_complaint_tracking_fk
+			references users(user_id) on delete cascade,
+	turnover	float,
+	percent		integer,
+	supplier_id	integer,
+	paid		float,
+	object_id	integer,
+	state 		varchar(10),
+			constraint cct_state_ck
+			check (state in ('valid','invalid','open'))
+);
+
 \i contacts-package-create.sql
 \i contacts-search-create.sql
 \i contacts-messages-create.sql
