Open-ILS/src/sql/Pg/upgrade/0013.schema.circ-checkin-ws-and-scan-time.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0013');
   4
   5 ALTER TABLE action.circulation
   6 ADD COLUMN checkin_workstation INT
   7         REFERENCES actor.workstation(id)
   8         ON DELETE SET NULL
   9         DEFERRABLE INITIALLY DEFERRED;
  10
  11 ALTER TABLE action.circulation
  12 ADD COLUMN checkin_scan_time TIMESTAMPTZ;
  13
  14 COMMIT;
  15