X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2F14_remove_ou_extras.sql;h=08bab8010e564e8a2480fc44ec11c2d8ef30e85d;hp=781090a030e4c355bd995eec49d668e435235d0f;hb=06e695c596e784a9e2634b25612b4bd23ac047af;hpb=39c739cec27e2fc042d2f0ab72930a41604a3d45 diff --git a/remove_ou_data/14_remove_ou_extras.sql b/remove_ou_data/14_remove_ou_extras.sql index 781090a..08bab80 100644 --- 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;