From fa6f9b339cb75d2c1f701c9364a9b780d693b391 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 16 Oct 2014 16:17:16 -0400 Subject: [PATCH] LP#1380709 Fund debit links to invoice entry Fund debits created by lineitem_details (copies) now track which invoice entry last touched the fund debit. With this, it's possible to say with certainty which invoice a fund_debit "belongs" to, which is particularly useful for reporting fund summary information on an invoice. Note this has no affect fund_debit's linked to invoice_item's, since they already link to the fund debits. Signed-off-by: Bill Erickson --- .../sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql new file mode 100644 index 0000000000..aca7918dbb --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql @@ -0,0 +1,10 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE acq.fund_debit + ADD COLUMN invoice_entry INTEGER + REFERENCES acq.invoice_entry (id) + ON DELETE SET NULL; + +COMMIT; -- 2.11.0