Open-ILS/src/sql/Pg/upgrade/0019.schema.action-aged-circ-new-cols.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0019');
   4
   5 ALTER TABLE action.aged_circulation
   6 ADD COLUMN workstation INT;
   7
   8 ALTER TABLE action.aged_circulation
   9 ADD COLUMN checkin_workstation INT;
  10
  11 ALTER TABLE action.aged_circulation
  12 ADD COLUMN checkin_scan_time TIMESTAMPTZ;
  13
  14 ALTER TABLE action.aged_circulation
  15 ADD COLUMN parent_circ BIGINT;
  16
  17 COMMIT;