From 6b1c7d0b5585d2de5fac7d7803c475f88d560186 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 17 Oct 2016 10:53:07 -0400 Subject: [PATCH] remove auditor history edits --- remove_ou_data/15_clear_auditors.sql | 6 +++++- remove_ou_data/README | 1 - 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/remove_ou_data/15_clear_auditors.sql b/remove_ou_data/15_clear_auditors.sql index ab941c3..20864e2 100644 --- a/remove_ou_data/15_clear_auditors.sql +++ b/remove_ou_data/15_clear_auditors.sql @@ -37,5 +37,9 @@ DELETE FROM auditor.asset_call_number_history WHERE owning_lib IN ( FROM actor.org_unit WHERE shortname = :ou_to_del ); - +DELETE FROM auditor.actor_usr_address_history WHERE usr IN ( + SELECT au.id + FROM actor.usr + WHERE home_ou = :ou_to_del +); COMMIT; diff --git a/remove_ou_data/README b/remove_ou_data/README index c740409..00d2bf3 100644 --- a/remove_ou_data/README +++ b/remove_ou_data/README @@ -17,4 +17,3 @@ remove the actor.org_unit entries themselves. TODO: -- remove event output that is no longer associated with any events --- remvoe user address auditor entries -- 1.7.2.5