projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
72d8a86
)
removed unncessary schema declared on column and fixed issue where value needed was...
author
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 9 Feb 2017 16:36:13 +0000 (11:36 -0500)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 9 Feb 2017 16:36:13 +0000 (11:36 -0500)
remove_ou_data/15_clear_auditors.sql
patch
|
blob
|
history
diff --git
a/remove_ou_data/15_clear_auditors.sql
b/remove_ou_data/15_clear_auditors.sql
index
20864e2
..
685d1cb
100644
(file)
--- a/
remove_ou_data/15_clear_auditors.sql
+++ b/
remove_ou_data/15_clear_auditors.sql
@@
-38,8
+38,8
@@
DELETE FROM auditor.asset_call_number_history WHERE owning_lib IN (
WHERE shortname = :ou_to_del
);
DELETE FROM auditor.actor_usr_address_history WHERE usr IN (
- SELECT au.id
+ SELECT id
FROM actor.usr
- WHERE home_ou = :ou_to_del
+ WHERE home_ou = (SELECT id FROM actor.org_unit WHERE shortname = :ou_to_del)
);
COMMIT;