Open-ILS/src/sql/Pg/upgrade/1210.schema.lp1248734_add_ws_to_ihu.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('1210', :eg_version); -- csharp/rhamby/sandbergja/gmcharlt
   4
   5 ALTER TABLE action.in_house_use ADD COLUMN workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED;
   6 ALTER TABLE action.non_cat_in_house_use ADD COLUMN workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED;
   7
   8 CREATE INDEX action_in_house_use_ws_idx ON action.in_house_use ( workstation );
   9 CREATE INDEX non_cat_in_house_use_ws_idx ON action.non_cat_in_house_use ( workstation );
  10
  11 COMMIT;