BEGIN;
+DELETE FROM asset.copy_alert WHERE copy IN (
+ SELECT id FROM asset.copy WHERE circ_lib IN
+ (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)
+);
+
+
-- NOTE: no FK
DELETE FROM asset.opac_visible_copies WHERE copy_id IN (
SELECT id FROM asset.copy WHERE circ_lib IN
DELETE FROM asset.copy WHERE circ_lib IN
(SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del);
+DELETE FROM asset.latest_inventory WHERE copy IN
+ (SELECT li.copy FROM asset.latest_inventory li LEFT JOIN asset.copy acp ON acp.id = li.copy WHERE acp.id IS NULL)
+;
+
COMMIT;
DROP INDEX vandelay.tmp_import_as;