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.16 -r1.17
--- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	1 Dec 2006 16:47:56 -0000	1.16
+++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql	14 Dec 2006 09:19:30 -0000	1.17
@@ -235,3 +235,6 @@
 \i contacts-list-create.sql
 
 
+-- Change the user_preferences table as at least with contacts it is a party references table
+alter table user_preferences drop constraint user_prefs_user_id_fk;
+alter table user_preferences add constraint user_prefs_user_id_fk foreign key  (user_id) references parties (party_id);