Index: openacs-4/packages/invoices/sql/postgresql/invoices-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/sql/postgresql/invoices-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/invoices/sql/postgresql/invoices-create.sql	15 Dec 2005 18:58:42 -0000	1.7
+++ openacs-4/packages/invoices/sql/postgresql/invoices-create.sql	27 Dec 2005 16:39:34 -0000	1.8
@@ -84,7 +84,7 @@
 create index iv_costs_organization_idx on iv_costs(organization_id);
 create index iv_costs_currency_idx on iv_costs(currency);
 
-create sequence iv_offer_seq start with 1000;
+create sequence iv_offer_seq start with 100000;
 
 create table iv_offers (
         offer_id                integer
@@ -178,6 +178,10 @@
                                 constraint iv_invoices_organization_fk
                                 references organizations,
                                 -- who pays?
+        contact_id              integer not null
+                                constraint iv_invoices_contact_fk
+                                references parties,
+                                -- who receives email?
         recipient_id            integer not null
                                 constraint iv_invoices_recipient_fk
                                 references parties,