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