adding copy_status to transit records
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 27 Jul 2005 21:06:46 +0000 (21:06 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 27 Jul 2005 21:06:46 +0000 (21:06 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@1556 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/action.pm
Open-ILS/src/sql/Pg/090.schema.action.sql

index 8ff2aae..f41038e 100644 (file)
@@ -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 /);
 
index bcb0a3c..e72e7cc 100644 (file)
@@ -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
 );