Index: openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d5-1.0d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d5-1.0d6.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d5-1.0d6.sql	8 Aug 2005 21:54:05 -0000	1.1
@@ -0,0 +1,19 @@
+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_user_id_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'))
+);
\ No newline at end of file