Index: openacs-4/packages/invoices/sql/postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/sql/postgresql/upgrade/upgrade-1.0d6-1.0d7.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/invoices/sql/postgresql/upgrade/upgrade-1.0d6-1.0d7.sql	3 May 2006 05:53:43 -0000	1.1
@@ -0,0 +1,15 @@
+create table iv_joined_invoices (
+        file_id                 integer
+                                constraint iv_joined_invoices_pk
+                                primary key,
+        creation_date           timestamptz
+                                constraint iv_joined_invoices_date_nn
+                                not null
+);
+
+insert into iv_joined_invoices (file_id, creation_date) values (0, now());
+
+alter table iv_invoices add column pdf_status varchar(10) default 'new';
+alter table iv_invoices add column pdf_file_id integer constraint iv_invoices_pdf_file_fk references cr_items;
+
+update iv_invoices set pdf_status = 'sent';