From 2be8d5b23e81e0fbf057e1492f3507357c841020 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 20 Feb 2008 21:08:30 +0000 Subject: [PATCH] moving fund down to the detail git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@8804 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 26 +++++++++++++------------- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 +- 2 files changed, 14 insertions(+), 14 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 6d8362c813..3436b123a5 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -2688,20 +2688,18 @@ - - - - - - - - - - + + + + + + + + + - @@ -2771,12 +2769,14 @@ - + + - + + diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 7b3067c160..bafba8ad79 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -132,7 +132,6 @@ CREATE TABLE acq.picklist_entry ( CREATE TABLE acq.po_lineitem ( id BIGSERIAL PRIMARY KEY, purchase_order INT NOT NULL REFERENCES acq.purchase_order (id), - fund INT REFERENCES acq.fund (id), expected_recv_time TIMESTAMP WITH TIME ZONE, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), edit_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), @@ -157,6 +156,7 @@ CREATE INDEX po_li_note_li_idx ON acq.po_li_note (po_lineitem); CREATE TABLE acq.po_li_detail ( id BIGSERIAL PRIMARY KEY, po_lineitem INT NOT NULL REFERENCES acq.po_lineitem (id), + fund INT REFERENCES acq.fund (id), fund_debit INT REFERENCES acq.fund_debit (id), eg_copy_id BIGINT REFERENCES asset.copy (id), barcode TEXT, -- 2.11.0