From 9991ee2af184d0eb5dd7b0bb14c97901a79879ea Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Thu, 12 Jul 2018 16:06:46 +0000 Subject: [PATCH] lp1777675 inventory date support SQL additions - Add inventory_date and inventory_workstation columns to asset.copy table. Signed-off-by: Kyle Huckins Changes to be committed: modified: Open-ILS/src/sql/Pg/040.schema.asset.sql new file: Open-ILS/src/sql/Pg/upgrade/XXXX-create-inventory-workstation-and-date-columns.sql --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 4 +++- .../XXXX-create-inventory-workstation-and-date-columns.sql | 9 +++++++++ 2 files changed, 12 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX-create-inventory-workstation-and-date-columns.sql diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 24dda3c41b..2ee6e0037e 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -102,7 +102,9 @@ CREATE TABLE asset.copy ( status_changed_time TIMESTAMP WITH TIME ZONE, active_date TIMESTAMP WITH TIME ZONE, mint_condition BOOL NOT NULL DEFAULT TRUE, - cost NUMERIC(8,2) + cost NUMERIC(8,2), + inventory_workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED, + inventory_date TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); CREATE UNIQUE INDEX copy_barcode_key ON asset.copy (barcode) WHERE deleted = FALSE OR deleted IS FALSE; CREATE INDEX cp_cn_idx ON asset.copy (call_number); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX-create-inventory-workstation-and-date-columns.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX-create-inventory-workstation-and-date-columns.sql new file mode 100644 index 0000000000..1d03b933b7 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX-create-inventory-workstation-and-date-columns.sql @@ -0,0 +1,9 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE asset.copy + ADD COLUMN inventory_workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED, + ADD COLUMN inventory_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(); + +COMMIT; \ No newline at end of file -- 2.11.0