projects
/
migration-tools.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
moving some cross saved templates and output folders
[migration-tools.git]
/
remove_ou_data
/
15_clear_auditors.sql
diff --git
a/remove_ou_data/15_clear_auditors.sql
b/remove_ou_data/15_clear_auditors.sql
index
ab941c3
..
685d1cb
100644
(file)
--- 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 id
+ FROM actor.usr
+ WHERE home_ou = (SELECT id FROM actor.org_unit WHERE shortname = :ou_to_del)
+);
COMMIT;