LP#1248734: stamp schema update
[Evergreen.git] / 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;