From 89905ce7074a99eeef728eb55c08406e052d2c91 Mon Sep 17 00:00:00 2001 From: scottmk Date: Tue, 15 Dec 2009 18:03:18 +0000 Subject: [PATCH] 1. Create a default entry in acq.fiscal_calendar. 2. Create a foreign key in acq.actor.org_unit pointing to acq.fiscal_calendar, and defaulting to 1. M Open-ILS/src/sql/Pg/200.schema.acq.sql M Open-ILS/src/sql/Pg/002.schema.config.sql A Open-ILS/src/sql/Pg/upgrade/0115.schema.aou-fy-foreign-key.sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@15167 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/200.schema.acq.sql | 17 +++++++++++++++ .../0115.schema.aou-fy-foreign-key.sql | 21 +++++++++++++++++++ 3 files changed, 39 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0115.schema.aou-fy-foreign-key.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 58f0e08c36..9e3a9acf63 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -51,7 +51,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0114'); -- berick +INSERT INTO config.upgrade_log (version) VALUES ('0115'); -- Scott McKellar CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 85f60f844e..9d44465d91 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -417,6 +417,23 @@ CREATE TABLE acq.fiscal_calendar ( name TEXT NOT NULL ); +-- Create a default calendar (though we don't specify its contents). +-- Create a foreign key in actor.org_unit, initially pointing to +-- the default calendar. + +INSERT INTO acq.fiscal_calendar ( + name +) VALUES ( + + 'Default' +); + +ALTER TABLE actor.org_unit +ADD COLUMN fiscal_calendar INT NOT NULL + REFERENCES acq.fiscal_calendar( id ) + DEFERRABLE INITIALLY DEFERRED + DEFAULT 1; + CREATE TABLE acq.fiscal_year ( id SERIAL PRIMARY KEY, calendar INT NOT NULL diff --git a/Open-ILS/src/sql/Pg/upgrade/0115.schema.aou-fy-foreign-key.sql b/Open-ILS/src/sql/Pg/upgrade/0115.schema.aou-fy-foreign-key.sql new file mode 100644 index 0000000000..53836ce921 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0115.schema.aou-fy-foreign-key.sql @@ -0,0 +1,21 @@ +-- Create a default row in acq.fiscal_calendar +-- Add a column in actor.org_unit to point to it + +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0115'); -- Scott McKellar + +INSERT INTO acq.fiscal_calendar ( + name +) VALUES ( + + 'Default' +); + +ALTER TABLE actor.org_unit +ADD COLUMN fiscal_calendar INT NOT NULL + REFERENCES acq.fiscal_calendar( id ) + DEFERRABLE INITIALLY DEFERRED + DEFAULT 1; + +COMMIT; -- 2.43.2