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.9 -r1.10
--- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	8 Aug 2005 21:53:12 -0000	1.9
+++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	9 Aug 2005 12:44:19 -0000	1.10
@@ -138,11 +138,13 @@
 			references cr_revisions(revision_id)
 			on delete cascade,
 	customer_id 	integer
-			constraint contact_complaint_tracking_fk
-			references users(user_id) on delete cascade,
+			constraint contact_complaint_tracking_customer_fk
+			references parties(party_id) on delete cascade,
 	turnover	float,
 	percent		integer,
-	supplier_id	integer,
+	supplier_id	integer
+       			constraint contact_complaint_tracking_supplier_fk
+			references parties(party_id) on delete cascade,
 	paid		float,
 	object_id	integer,
 	state 		varchar(10),