From ad60dbd121969b9982f3d4e34185c865fd037acf Mon Sep 17 00:00:00 2001 From: erickson Date: Tue, 5 May 2009 12:58:40 +0000 Subject: [PATCH] adding collection_code field to lineitem_detail. git-svn-id: svn://svn.open-ils.org/ILS/trunk@13068 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 45914d40c0..d10f31fc41 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -215,6 +215,7 @@ CREATE TABLE acq.lineitem_detail ( barcode TEXT, cn_label TEXT, note TEXT, + collection_code TEXT, circ_modifier TEXT REFERENCES config.circ_modifier (code) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, owning_lib INT REFERENCES actor.org_unit (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, location INT REFERENCES asset.copy_location (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, -- 2.43.2