projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(from parent 1:
39c739c
)
add disable/renable rule so that copy locations can be deleted in remove_ou scripts
author
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 27 Feb 2017 13:35:55 +0000 (08:35 -0500)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 27 Feb 2017 13:35:55 +0000 (08:35 -0500)
remove_ou_data/14_remove_ou_extras.sql
patch
|
blob
|
history
diff --git
a/remove_ou_data/14_remove_ou_extras.sql
b/remove_ou_data/14_remove_ou_extras.sql
index
781090a
..
08bab80
100644
(file)
--- a/
remove_ou_data/14_remove_ou_extras.sql
+++ b/
remove_ou_data/14_remove_ou_extras.sql
@@
-21,6
+21,7
@@
create index tmp_idx on money.billing(btype);
ALTER TABLE action.circulation DISABLE TRIGGER action_circulation_target_copy_trig;
+ALTER TABLE asset.copy_location DISABLE RULE protect_copy_location_delete;
BEGIN;
@@
-68,4
+69,5
@@
DELETE FROM action_trigger.event_definition
COMMIT;
DROP INDEX money.tmp_idx;
+ALTER TABLE asset.copy_location ENABLE RULE protect_copy_location_delete;
ALTER TABLE action.circulation ENABLE TRIGGER action_circulation_target_copy_trig;