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.9 -r1.10 --- openacs-4/packages/invoices/sql/postgresql/invoices-create.sql 4 Jan 2006 08:06:45 -0000 1.9 +++ openacs-4/packages/invoices/sql/postgresql/invoices-create.sql 15 Mar 2006 17:05:06 -0000 1.10 @@ -317,7 +317,27 @@ references acs_objects ); +create table iv_journals ( + file_id integer + constraint iv_journals_pk + primary key, + creation_date timestamptz + constraint iv_journals_date_nn + not null +); +create table iv_journal_country_codes ( + iso_code char(2) + constraint iv_journal_country_codes_pk + primary key + constraint iv_journal_country_codes_iso_code_fk + references countries, + journal_code varchar(4) + constraint iv_journal_country_codes_journal_code_nn + not null +); + + begin; select acs_privilege__create_privilege('invoice_cancel',null,null); select acs_privilege__create_privilege('invoice_export',null,null);