From c0a90cba7e4ee514b81f01c655ca4ac37e7759c7 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 27 Jul 2005 21:06:46 +0000 Subject: [PATCH] adding copy_status to transit records git-svn-id: svn://svn.open-ils.org/ILS/trunk@1556 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../OpenILS/Application/Storage/CDBI/action.pm | 10 ++++++---- Open-ILS/src/sql/Pg/090.schema.action.sql | 1 + 2 files changed, 7 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/action.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/action.pm index 8ff2aae70f..f41038e53a 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/action.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/action.pm @@ -93,8 +93,9 @@ package action::hold_transit_copy; use base qw/action/; __PACKAGE__->table('action_hold_transit_copy'); __PACKAGE__->columns(Primary => 'id'); -__PACKAGE__->columns(Essential => qw/hold source dest persistant_transfer target_copy - source_send_time dest_recv_time prev_hop/); +__PACKAGE__->columns(Essential => qw/source dest persistant_transfer target_copy + source_send_time dest_recv_time prev_hop + copy_status hold/); #------------------------------------------------------------------------------- @@ -103,13 +104,14 @@ use base qw/action/; __PACKAGE__->table('action_transit_copy'); __PACKAGE__->columns(Primary => 'id'); __PACKAGE__->columns(Essential => qw/source dest persistant_transfer target_copy - source_send_time dest_recv_time prev_hop/); + source_send_time dest_recv_time prev_hop + copy_status/); #------------------------------------------------------------------------------- package action::unfulfilled_hold_list; use base qw/action/; -__PACKAGE__->table('action_.unfulfilled_hold_list'); +__PACKAGE__->table('action_unfulfilled_hold_list'); __PACKAGE__->columns(Primary => 'id'); __PACKAGE__->columns(Essential => qw/hold current_copy circ_lib fail_time /); diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index bcb0a3c3f5..e72e7cc465 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -150,6 +150,7 @@ CREATE TABLE action.transit_copy ( source INT NOT NULL REFERENCES actor.org_unit (id), dest INT NOT NULL REFERENCES actor.org_unit (id), prev_hop INT REFERENCES action.transit_copy (id), + copy_status INT NOT NULL REFERENCES config.copy_status (id), persistant_transfer BOOL NOT NULL DEFAULT FALSE ); -- 2.43.2