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