LP#1564079 Checkout history handles serials
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.fix_circ_history_copy_ref.sql
1
2 BEGIN;
3
4 --SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5
6 ALTER TABLE action.usr_circ_history 
7     DROP CONSTRAINT IF EXISTS usr_circ_history_target_copy_fkey;
8
9 CREATE TRIGGER action_usr_circ_history_target_copy_trig 
10     AFTER INSERT OR UPDATE ON action.usr_circ_history 
11     FOR EACH ROW EXECUTE PROCEDURE evergreen.fake_fkey_tgr('target_copy');
12
13 COMMIT;
14