Track import time and target copy on import items
authorberick <berick@esilibrary.com>
Fri, 20 May 2011 21:06:05 +0000 (17:06 -0400)
committerberick <berick@esilibrary.com>
Fri, 20 May 2011 21:06:05 +0000 (17:06 -0400)
commitbdbc17483955db34804b4058bc33fc1a1e437a61
tree8113c952710ba7a3fb99a8e625c33abcff3da48c
parent7f4dc6aae0d831d4a32f51abad77e841ac0c77ce
Track import time and target copy on import items

Added import_time and imported_as columns to vandelay.import_item

For you branch trackers:

ALTER TABLE vandelay.import_item
    ADD import_time TIMESTAMP WITH TIME ZONE;

ALTER TABLE vandelay.import_item
    ADD imported_as BIGINT REFERENCES
    asset.copy (id) DEFERRABLE INITIALLY DEFERRED;
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/012.schema.vandelay.sql