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.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
Index: openacs-4/packages/contacts/sql/postgresql/contacts-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/contacts/sql/postgresql/contacts-drop.sql	18 May 2005 16:45:49 -0000	1.3
+++ openacs-4/packages/contacts/sql/postgresql/contacts-drop.sql	8 Aug 2005 21:53:12 -0000	1.4
@@ -17,6 +17,8 @@
 drop table contact_groups;
 drop table contact_rels;
 drop table organization_rels;
+drop table contact_complaint_tracking;
+
 select content_type__drop_type ('contact_party_revision','t','t');
 --drop table contact_party_revisions;
 select acs_rel_type__drop_type('organization_rel','t');