From 1c974a9f3a18b85dc9c1e26e8317e5b6bc0f1fca Mon Sep 17 00:00:00 2001 From: scottmk Date: Fri, 17 Apr 2009 18:15:12 +0000 Subject: [PATCH] Add CREATE TABLE statements, and the associated IDL entries, for two new tables: acq.fund_tag acq.fund_tag_map git-svn-id: svn://svn.open-ils.org/ILS/trunk@12907 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 55 ++++++++++++++++++++++++++++++++++ Open-ILS/src/sql/Pg/200.schema.acq.sql | 17 +++++++++++ 2 files changed, 72 insertions(+) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 4e5f179b9c..3e5d215722 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -4487,12 +4487,14 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA + + @@ -5698,6 +5700,59 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 0b6b0e73ea..85981226be 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -308,6 +308,23 @@ CREATE TABLE acq.distribution_formula_entry ( CHECK( owning_lib IS NOT NULL OR location IS NOT NULL ) ); +CREATE TABLE acq.fund_tag ( + id SERIAL PRIMARY KEY, + owner INT NOT NULL + REFERENCES actor.org_unit(id) DEFERRABLE INITIALLY DEFERRED, + name TEXT NOT NULL, + CONSTRAINT acqft_tag_once_per_owner UNIQUE (name, owner) +); + +CREATE TABLE acq.fund_tag_map ( + id SERIAL PRIMARY KEY, + fund INTEGER NOT NULL REFERENCES acq.fund(id) + DEFERRABLE INITIALLY DEFERRED, + tag INTEGER REFERENCES acq.fund_tag(id) + ON DELETE CASCADE + DEFERRABLE INITIALLY DEFERRED, + CONSTRAINT acqftm_fund_once_per_tag UNIQUE( fund, tag ) +); -- Functions -- 2.11.0