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.10 -r1.11 --- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql 9 Aug 2005 12:44:19 -0000 1.10 +++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql 5 Oct 2005 22:17:48 -0000 1.11 @@ -128,30 +128,6 @@ constraint organization_rels_rel_id_pk primary key ); - - -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_customer_fk - references parties(party_id) on delete cascade, - turnover float, - percent 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), - 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