From 3d2301405894b7fb75fd551c9138b2ca9b63e8f5 Mon Sep 17 00:00:00 2001 From: Bill Erickson <berick@esilibrary.com> Date: Tue, 21 Jun 2011 17:05:42 -0400 Subject: [PATCH] Update serial.unit auditor table along w/ asset.copy change Signed-off-by: Bill Erickson <berick@esilibrary.com> --- Open-ILS/src/sql/Pg/upgrade/0562.schema.copy_active_date.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/0562.schema.copy_active_date.sql b/Open-ILS/src/sql/Pg/upgrade/0562.schema.copy_active_date.sql index 8bfc1dcdac..c2cffff97b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0562.schema.copy_active_date.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0562.schema.copy_active_date.sql @@ -13,6 +13,9 @@ ALTER TABLE asset.copy ALTER TABLE auditor.asset_copy_history ADD COLUMN active_date TIMESTAMP WITH TIME ZONE; +ALTER TABLE auditor.serial_unit_history + ADD COLUMN active_date TIMESTAMP WITH TIME ZONE; + ALTER TABLE config.copy_status ADD COLUMN copy_active BOOL NOT NULL DEFAULT FALSE; -- 2.11.0