From 85ace50585d1b7144f1618a60d70937027ecec21 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 22 Jul 2020 15:16:26 -0400 Subject: [PATCH] rename 13 to be more accurate --- remove_ou_data/13_remove_more_patron_extras.sql | 67 ----------------------- 1 files changed, 0 insertions(+), 67 deletions(-) delete mode 100644 remove_ou_data/13_remove_more_patron_extras.sql diff --git a/remove_ou_data/13_remove_more_patron_extras.sql b/remove_ou_data/13_remove_more_patron_extras.sql deleted file mode 100644 index 1d5ee31..0000000 --- a/remove_ou_data/13_remove_more_patron_extras.sql +++ /dev/null @@ -1,67 +0,0 @@ --- Copyright 2015, Equinox Software, Inc. --- Author: Galen Charlton --- --- This program is free software; you can redistribute it and/or --- modify it under the terms of the GNU General Public License --- as published by the Free Software Foundation; either version 2 --- of the License, or (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program; if not, write to the Free Software --- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. - -\set ou_to_del ''''EXAMPLE'''' -\set ECHO all -\timing - -BEGIN; - -DELETE FROM action.non_cataloged_circulation WHERE patron IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM action.non_cataloged_circulation WHERE staff IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM action.usr_circ_history WHERE usr IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); - -DELETE FROM acq.user_request WHERE usr IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.lineitem WHERE creator IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.lineitem WHERE selector IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.lineitem WHERE editor IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.lineitem WHERE purchase_order IN -(SELECT id FROM acq.purchase_order WHERE creator IN - (SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del))); -DELETE FROM acq.po_note WHERE purchase_order IN -(SELECT id FROM acq.purchase_order WHERE creator IN - (SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del))); -DELETE FROM acq.purchase_order WHERE creator IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.purchase_order WHERE owner IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.fund_allocation WHERE fund IN -(SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.invoice_item WHERE fund_debit IN -(SELECT id FROM acq.fund_debit WHERE fund IN (SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del))); -DELETE FROM acq.invoice WHERE receiver IN -(SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); - -DELETE FROM acq.lineitem_detail WHERE fund IN -(SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.fund_debit WHERE fund IN -(SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.fund_transfer WHERE src_fund IN -(SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.fund_transfer WHERE dest_fund IN -(SELECT id FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); -DELETE FROM acq.fund WHERE org IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); - - -COMMIT; -- 1.7.2.5